表名: po.po_un_numbers
说明: 货期表
UN_NUMBER_ID NUMBER 货期标识码
UN_NUMBER VARCHAR2(25) 货期
DESCRIPTION VARCHAR2(240) 说明
表名:po.rcv_transactions
说明:到货接收
TRANSACTION_ID NUMBER 接收交易ID
CREATION_DATE DATE 创建时间
CREATED_BY NUMBER 创建人ID
REQUEST_ID NUMBER
TRANSACTION_TYPE VARCHAR2(25) 交易类型*
TRANSACTION_DATE DATE 交易日期
QUANTITY NUMBER 数量
UNIT_OF_MEASURE VARCHAR2(25) 单位
SHIPMENT_HEADER_ID NUMBER 发运头ID
SHIPMENT_LINE_ID NUMBER 发运行ID
INV_TRANSACTION_ID NUMBER INV模块交易登记ID
SOURCE_DOCUMENT_CODE VARCHAR2(25) 来源文档
DESTINATION_TYPE_CODE VARCHAR2(25) 目的类型*
PRIMARY_QUANTITY NUMBER 主单位数量
PRIMARY_UNIT_OF_MEASURE VARCHAR2(25) 主单位
EMPLOYEE_ID NUMBER(9) 员工ID
PARENT_TRANSACTION_ID NUMBER 父交易ID
PO_HEADER_ID NUMBER PO头ID
PO_RELEASE_ID NUMBER
PO_LINE_ID NUMBER PO行ID
PO_LINE_LOCATION_ID NUMBER PO定位行ID
PO_DISTRIBUTION_ID NUMBER PO发散ID
PO_REVISION_NUM NUMBER PO版本
REQUISITION_LINE_ID NUMBER PR行ID
PO_UNIT_PRICE NUMBER 单位
CURRENCY_CODE VARCHAR2(15) 币种
CURRENCY_CONVERSION_TYPE VARCHAR2(30) 货币转换类型
CURRENCY_CONVERSION_RATE NUMBER 汇率
CURRENCY_CONVERSION_DATE DATE 汇率日期
DELIVER_TO_PERSON_ID NUMBER(9) 投递给员工ID
DELIVER_TO_LOCATION_ID NUMBER 投递地点ID
VENDOR_ID NUMBER 供应商ID
VENDOR_SITE_ID NUMBER 供应商地址ID
ORGANIZATION_ID NUMBER 组织代码
SUBINVENTORY VARCHAR2(10) 子库
LOCATION_ID NUMBER 库位ID(与inv.mtl_item_locations关联)
RMA_REFERENCE VARCHAR2(30) RMA参考
COMMENTS VARCHAR2(240) 备注
INVOICE_ID NUMBER 发票ID
INVOICE_STATUS_CODE VARCHAR2(25) 发票状态
说明:TRANSACTION_TYPE 与 DESTINATION_TYPE_CODE 取值
TRANSACTION_TYPE
ACCEPT 接受 检验合格
CORRECT 校正 录入错误,信息调整
DELIVER 交货 正式入库
RECEIVE 接收 收货
REJECT 拒绝 接收后未作入库或退货处理
RETURN TO RECEIVING 返回至接收 从库房返回到暂存库
RETURN TO VENDOR 返回至供应商 从暂存库/库房/车间退货到供应商
TRANSFER 转帐 香港暂存库转公司暂存库
DESTINATION_TYPE_CODE
EXPENSE 费用
INVENTORY 库房
RECEIVING 暂存
SHOP FLOOR 车间
表名:po.po_vendors
说明:供应商表
VENDOR_ID NUMBER
VENDOR_NAME VARCHAR2(80)
SEGMENT1 VARCHAR2(30)
CREATION_DATE DATE
CREATED_BY NUMBER
EMPLOYEE_ID NUMBER
VENDOR_TYPE_LOOKUP_CODE VARCHAR2(25)
CUSTOMER_NUM VARCHAR2(25)
MIN_ORDER_AMOUNT NUMBER
SHIP_TO_LOCATION_ID NUMBER
BILL_TO_LOCATION_ID NUMBER
SHIP_VIA_LOOKUP_CODE VARCHAR2(25)
FREIGHT_TERMS_LOOKUP_CODE VARCHAR2(25)
FOB_LOOKUP_CODE VARCHAR2(25)
TERMS_ID NUMBER
SET_OF_BOOKS_ID NUMBER
CREDIT_STATUS_LOOKUP_CODE VARCHAR2(25)
CREDIT_LIMIT NUMBER
ALWAYS_TAKE_DISC_FLAG VARCHAR2(1)
PAY_DATE_BASIS_LOOKUP_CODE VARCHAR2(25)
PAY_GROUP_LOOKUP_CODE VARCHAR2(25)
PAYMENT_PRIORITY NUMBER
INVOICE_CURRENCY_CODE VARCHAR2(15)
PAYMENT_CURRENCY_CODE VARCHAR2(15)
INVOICE_AMOUNT_LIMIT NUMBER
EXCHANGE_DATE_LOOKUP_CODE VARCHAR2(25)
HOLD_ALL_PAYMENTS_FLAG VARCHAR2(1)
HOLD_FUTURE_PAYMENTS_FLAG VARCHAR2(1)
HOLD_REASON VARCHAR2(240)
DISTRIBUTION_SET_ID NUMBER
ACCTS_PAY_CODE_COMBINATION_ID NUMBER
DISC_LOST_CODE_COMBINATION_ID NUMBER
DISC_TAKEN_CODE_COMBINATION_ID NUMBER
EXPENSE_CODE_COMBINATION_ID NUMBER
PREPAY_CODE_COMBINATION_ID NUMBER
NUM_1099 VARCHAR2(30)
TYPE_1099 VARCHAR2(10)
WITHHOLDING_STATUS_LOOKUP_CODE VARCHAR2(25)
WITHHOLDING_START_DATE DATE
ORGANIZATION_TYPE_LOOKUP_CODE VARCHAR2(25)
VAT_CODE VARCHAR2(15)
START_DATE_ACTIVE DATE
END_DATE_ACTIVE DATE
MINORITY_GROUP_LOOKUP_CODE VARCHAR2(25)
PAYMENT_METHOD_LOOKUP_CODE VARCHAR2(25)
BANK_ACCOUNT_NAME VARCHAR2(80)
BANK_ACCOUNT_NUM VARCHAR2(30)
BANK_NUM VARCHAR2(25)
BANK_ACCOUNT_TYPE VARCHAR2(25)
WOMEN_OWNED_FLAG VARCHAR2(1)
SMALL_BUSINESS_FLAG VARCHAR2(1)
STANDARD_INDUSTRY_CLASS VARCHAR2(25)
HOLD_FLAG VARCHAR2(1)
PURCHASING_HOLD_REASON VARCHAR2(240)
HOLD_BY NUMBER(9)
HOLD_DATE DATE
TERMS_DATE_BASIS VARCHAR2(25)
PRICE_TOLERANCE NUMBER
INSPECTION_REQUIRED_FLAG VARCHAR2(1)
RECEIPT_REQUIRED_FLAG VARCHAR2(1)
QTY_RCV_TOLERANCE NUMBER
QTY_RCV_EXCEPTION_CODE VARCHAR2(25)
ENFORCE_SHIP_TO_LOCATION_CODE VARCHAR2(25)
DAYS_EARLY_RECEIPT_ALLOWED NUMBER
DAYS_LATE_RECEIPT_ALLOWED NUMBER
RECEIPT_DAYS_EXCEPTION_CODE VARCHAR2(25)
RECEIVING_ROUTING_ID NUMBER
ALLOW_SUBSTITUTE_RECEIPTS_FLAG VARCHAR2(1)
ALLOW_UNORDERED_RECEIPTS_FLAG VARCHAR2(1)
HOLD_UNMATCHED_INVOICES_FLAG VARCHAR2(1)
EXCLUSIVE_PAYMENT_FLAG VARCHAR2(1)
TAX_VERIFICATION_DATE DATE
NAME_CONTROL VARCHAR2(4)
STATE_REPORTABLE_FLAG VARCHAR2(1)
FEDERAL_REPORTABLE_FLAG VARCHAR2(1)
BANK_NUMBER VARCHAR2(30)
EDI_TRANSACTION_HANDLING VARCHAR2(25)
EDI_PAYMENT_METHOD VARCHAR2(25)
EDI_PAYMENT_FORMAT VARCHAR2(25)
EDI_REMITTANCE_METHOD VARCHAR2(25)
EDI_REMITTANCE_INSTRUCTION VARCHAR2(256)
BANK_CHARGE_BEARER VARCHAR2(1)
BANK_BRANCH_TYPE VARCHAR2(25)
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/15725751/viewspace-615260/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/15725751/viewspace-615260/