描述:采购订单释放
Primary Key: PO_RELEASES_PK
- PO_RELEASE_ID
Primary Key: PO_RELEASES_UK1
- PO_HEADER_ID
- RELEASE_NUM
Foreign Keys from this table:
Foreign Key Column | Foreign Table |
---|---|
PO_RELEASES_ALL.PO_HEADER_ID | PO_HEADERS_ALL |
PO_RELEASES_ALL.HOLD_BY | PO_AGENTS |
PO_RELEASES_ALL.AGENT_ID | PO_AGENTS |
Foreign Keys to this table:
Foreign Key Column | Foreign Table |
---|---|
FII_AP_INV_B.PO_RELEASE_ID | PO_RELEASES_ALL |
FII_AP_INV_STG.PO_RELEASE_ID | PO_RELEASES_ALL |
JAI_PO_OSP_HDRS.OTH_DOC_ID | PO_RELEASES_ALL |
JAI_PO_REP_PRRG_T.PO_HEADER_ID JAI_PO_REP_PRRG_T.PO_RELEASE_NUM | PO_RELEASES_ALL |
MTL_SUPPLY.PO_RELEASE_ID | PO_RELEASES_ALL |
PO_ACCEPTANCES.PO_RELEASE_ID | PO_RELEASES_ALL |
PO_ACTION_HISTORY.OBJECT_ID | PO_RELEASES_ALL |
PO_DISTRIBUTIONS_ARCHIVE_ALL.PO_RELEASE_ID | PO_RELEASES_ALL |
PO_DISTRIBUTIONS_ALL.PO_RELEASE_ID | PO_RELEASES_ALL |
PO_LINE_LOCATIONS_ARCHIVE_ALL.PO_RELEASE_ID | PO_RELEASES_ALL |
PO_LINE_LOCATIONS_ALL.PO_RELEASE_ID | PO_RELEASES_ALL |
PO_NOTIFICATIONS_ALL.OBJECT_ID | PO_RELEASES_ALL |
QA_RESULTS.PO_RELEASE_ID | PO_RELEASES_ALL |
RCV_ACCOUNTING_EVENTS.PO_RELEASE_ID | PO_RELEASES_ALL |
RCV_SHIPMENT_LINES.PO_RELEASE_ID | PO_RELEASES_ALL |
RCV_SUPPLY.PO_RELEASE_ID | PO_RELEASES_ALL |
RCV_TRANSACTIONS.PO_RELEASE_ID | PO_RELEASES_ALL |
RCV_TRANSACTIONS_INTERFACE.PO_RELEASE_ID | PO_RELEASES_ALL |
Comments:
PO_RELEASES_ALL包含关于一揽子和计划采购订单释放的信息。对于一揽子或计划的采购订单,您需要为您发出的每一个发布提供一行。每行包括买家、日期、发布状态和发布号。每个版本必须至少有一个采购订单装运(PO_LINE_LOCATIONS_ALL)。RELEASE_NUM是分配给发布的数字。