描述:采购文档行(采购订单、采购协议、报价、询价)
Primary Key: PO_LINES_PK
- PO_LINE_ID
Primary Key: PO_LINES_UK1
- PO_HEADER_ID
- LINE_NUM
Foreign Keys from this table:
Foreign Key Column | Foreign Table |
---|---|
PO_LINES_ALL.CATEGORY_ID | MTL_CATEGORIES_B |
PO_LINES_ALL.LINE_TYPE_ID | PO_LINE_TYPES_B |
PO_LINES_ALL.UN_NUMBER_ID | PO_UN_NUMBERS_B |
PO_LINES_ALL.HAZARD_CLASS_ID | PO_HAZARD_CLASSES_B |
PO_LINES_ALL.FROM_HEADER_ID | PO_HEADERS_ALL |
PO_LINES_ALL.FROM_LINE_ID | PO_LINES_ALL |
Foreign Keys to this table:
Foreign Key Column | Foreign Table |
---|---|
AHL_OSP_ORDER_LINES.PO_LINE_ID | PO_LINES_ALL |
CSI_ITEM_INSTANCES.PO_ORDER_LINE_ID | PO_LINES_ALL |
CST_RCV_ACQ_COST_DETAILS.PO_LINE_LOCATION_ID | PO_LINES_ALL |
ICX_SHOPPING_CART_LINES.AUTOSOURCE_DOC_HEADER_ID ICX_SHOPPING_CART_LINES.AUTOSOURCE_DOC_LINE_NUM | PO_LINES_ALL |
IGC_CC_ACCT_LINES.CC_ACCT_LINE_ID | PO_LINES_ALL |
JAI_AP_MATCH_INV_TAXES.PO_LINE_ID | PO_LINES_ALL |
JAI_CMN_RG_23AC_I_TRXS.PO_LINE_ID | PO_LINES_ALL |
JAI_PO_COPYDOC_T.PO_LINE_ID | PO_LINES_ALL |
JAI_PO_COPY_T.PO_LINE_ID | PO_LINES_ALL |
JAI_PO_LINE_LOCATIONS.PO_LINE_ID | PO_LINES_ALL |
JAI_PO_OSP_LINES.PO_LINE_ID | PO_LINES_ALL |
JAI_PO_QUOT_LINES_T.PO_LINE_ID | PO_LINES_ALL |
JAI_PO_QUOT_LINES_T.FROM_LINE_ID | PO_LINES_ALL |
JAI_PO_REQUEST_T.PO_LINE_ID | PO_LINES_ALL |
JAI_PO_TAXES.PO_LINE_ID | PO_LINES_ALL |
MTL_SUPPLY.PO_LINE_ID | PO_LINES_ALL |
IGC_CC_ARC_ACCT_LINES.CC_ACCT_LINE_ID | PO_LINES_ALL |
IGC_CC_ACCT_LINES_INTERFACE.INTERFACE_ACCT_LINE_ID | PO_LINES_ALL |
OE_DROP_SHIP_SOURCES.PO_LINE_ID | PO_LINES_ALL |
PA_CI_SUPPLIER_DETAILS.PO_LINE_ID | PO_LINES_ALL |
PA_EXPENDITURE_ITEMS_AR.PO_LINE_ID | PO_LINES_ALL |
PA_TRANSACTION_INTERFACE_ALL.PO_LINE_ID | PO_LINES_ALL |
PA_TXN_INTERFACE_AUDIT_AR.PO_LINE_ID | PO_LINES_ALL |
PA_TXN_INTERFACE_AUDIT_ALL.PO_LINE_ID | PO_LINES_ALL |
PO_ACCRUAL_RECONCILE_TEMP_ALL.PO_LINE_ID | PO_LINES_ALL |
PO_ACCRUAL_WRITE_OFFS_ALL.PO_LINE_ID | PO_LINES_ALL |
PO_AUTOSOURCE_DOCUMENTS_ALL.DOCUMENT_LINE_ID | PO_LINES_ALL |
PO_DISTRIBUTIONS_ARCHIVE_ALL.PO_LINE_ID | PO_LINES_ALL |
PO_DISTRIBUTIONS_ALL.PO_LINE_ID | PO_LINES_ALL |
PO_LINES_ARCHIVE_ALL.FROM_LINE_ID | PO_LINES_ALL |
PO_LINES_ARCHIVE_ALL.PO_LINE_ID | PO_LINES_ALL |
PO_LINES_ALL.FROM_LINE_ID | PO_LINES_ALL |
PO_LINE_LOCATIONS_ARCHIVE_ALL.PO_LINE_ID | PO_LINES_ALL |
PO_LINE_LOCATIONS_ARCHIVE_ALL.FROM_LINE_ID | PO_LINES_ALL |
PO_LINE_LOCATIONS_ALL.FROM_LINE_ID | PO_LINES_ALL |
PO_LINE_LOCATIONS_ALL.PO_LINE_ID | PO_LINES_ALL |
PO_REQEXPRESS_LINES_ALL.PO_LINE_ID | PO_LINES_ALL |
RCV_ACCOUNTING_EVENTS.PO_LINE_ID | PO_LINES_ALL |
RCV_SHIPMENT_LINES.PO_LINE_ID | PO_LINES_ALL |
RCV_SUPPLY.PO_LINE_ID | PO_LINES_ALL |
RCV_TRANSACTIONS.PO_LINE_ID | PO_LINES_ALL |
RCV_TRANSACTIONS_INTERFACE.PO_LINE_ID | PO_LINES_ALL |
SO_DROP_SHIP_SOURCES.PO_LINE_ID | PO_LINES_ALL |
WIP_COST_TXN_INTERFACE.PO_LINE_ID | PO_LINES_ALL |
WIP_TRANSACTIONS.PO_LINE_ID | PO_LINES_ALL |
Comments:
PO_LINES_ALL存储关于每个采购订单行的当前信息。附加到文档的每一行都需要一行。有五种文档类型使用行: RFQs、Quotations、Standard purchase orders、Planned purchase orders、Blanket purchase orders、Contracts。每一行都包括行号、项目号和类别、单位、价格、税务信息、匹配信息和为该行订购的数量。Oracle采购使用这些信息来记录和更新采购订单、报价和RFQs的项目和价格信息。
PO_LINE_ID是系统生成的唯一行号,对用户不可见。LINE_NUM是采购订单上的行号。
Oracle Purchasing使用CONTRACT_ID从一个标准的采购订单行引用一个合同采购订单。甲骨文采购使用
ALLOW_PRICE_OVERRIDE_FLAG、COMMITTED_AMOUNT QUANTITY_COMMITTED,
MIN_RELEASE_AMOUNT仅用于一揽子和计划的采购订单线。
QUANTITY字段存储所有采购订单发货行的总数量(在PO_LINE_LOCATIONS_ALL中找到)。