EBS:PO_DISTRIBUTIONS_ALL

描述：采购订单分布

Primary Key: PO_DISTRIBUTIONS_PK

1. PO_DISTRIBUTION_ID

Primary Key: PO_DISTRIBUTIONS_UK1

1. PO_HEADER_ID
2. PO_LINE_ID
3. LINE_LOCATION_ID
4. DISTRIBUTION_NUM

Foreign Keys from this table:

Foreign Key Column	Foreign Table
PO_DISTRIBUTIONS_ALL.PO_HEADER_ID	PO_HEADERS_ALL
PO_DISTRIBUTIONS_ALL.DESTINATION_SUBINVENTORY PO_DISTRIBUTIONS_ALL.DESTINATION_ORGANIZATION_ID	MTL_SECONDARY_INVENTORIES
PO_DISTRIBUTIONS_ALL.BOM_RESOURCE_ID	BOM_RESOURCES
PO_DISTRIBUTIONS_ALL.BUDGET_ACCOUNT_ID	GL_CODE_COMBINATIONS
PO_DISTRIBUTIONS_ALL.ACCRUAL_ACCOUNT_ID	GL_CODE_COMBINATIONS
PO_DISTRIBUTIONS_ALL.PO_LINE_ID	PO_LINES_ALL
PO_DISTRIBUTIONS_ALL.VARIANCE_ACCOUNT_ID	GL_CODE_COMBINATIONS
PO_DISTRIBUTIONS_ALL.SOURCE_DISTRIBUTION_ID	PO_DISTRIBUTIONS_ALL
PO_DISTRIBUTIONS_ALL.TASK_ID	PA_TASKS
PO_DISTRIBUTIONS_ALL.LINE_LOCATION_ID	PO_LINE_LOCATIONS_ALL
PO_DISTRIBUTIONS_ALL.PO_RELEASE_ID	PO_RELEASES_ALL
PO_DISTRIBUTIONS_ALL.REQ_DISTRIBUTION_ID	PO_REQ_DISTRIBUTIONS_ALL
PO_DISTRIBUTIONS_ALL.SET_OF_BOOKS_ID	GL_SETS_OF_BOOKS
PO_DISTRIBUTIONS_ALL.CODE_COMBINATION_ID	GL_CODE_COMBINATIONS

Foreign Keys to this table:

Foreign Key Column	Foreign Table
	PO_DISTRIBUTIONS_ALL
AP_INVOICE_DISTRIBUTIONS_ALL.PO_DISTRIBUTION_ID	PO_DISTRIBUTIONS_ALL
IGC_CC_DET_PF.CC_DET_PF_LINE_ID	PO_DISTRIBUTIONS_ALL
CST_AP_PO_RECONCILIATION.PO_DISTRIBUTION_ID	PO_DISTRIBUTIONS_ALL
CST_AP_VARIANCE_LINES.PO_DISTRIBUTION_ID	PO_DISTRIBUTIONS_ALL
CST_MISC_RECONCILIATION.PO_DISTRIBUTION_ID	PO_DISTRIBUTIONS_ALL
CST_RECONCILIATION_SUMMARY.PO_DISTRIBUTION_ID	PO_DISTRIBUTIONS_ALL
CST_WRITE_OFFS.PO_DISTRIBUTION_ID	PO_DISTRIBUTIONS_ALL
FA_ASSET_INVOICES.PO_DISTRIBUTION_ID	PO_DISTRIBUTIONS_ALL
FA_MASSADD_REP_ITF.PO_DISTRIBUTION_ID	PO_DISTRIBUTIONS_ALL
FA_MASS_ADDITIONS.PO_DISTRIBUTION_ID	PO_DISTRIBUTIONS_ALL
FA_MC_ASSET_INVOICES.PO_DISTRIBUTION_ID	PO_DISTRIBUTIONS_ALL
FV_INV_SELECTED_DUEDATE.PO_DISTRIBUTION_ID	PO_DISTRIBUTIONS_ALL
GMS_AWARD_DISTRIBUTIONS.PO_DISTRIBUTION_ID	PO_DISTRIBUTIONS_ALL
JAI_AP_MATCH_ERS_T.PO_DISTRIBUTION_ID	PO_DISTRIBUTIONS_ALL
JAI_AP_MATCH_INV_TAXES.PO_DISTRIBUTION_ID	PO_DISTRIBUTIONS_ALL
JAI_PO_OSP_LINES.PO_DISTRIBUTION_ID	PO_DISTRIBUTIONS_ALL
JAI_PO_REP_PRRG_T.PO_DISTRIBUTION_ID	PO_DISTRIBUTIONS_ALL
MTL_KANBAN_CARD_ACTIVITY.DOCUMENT_DETAIL_ID	PO_DISTRIBUTIONS_ALL
MTL_SUPPLY.PO_DISTRIBUTION_ID	PO_DISTRIBUTIONS_ALL
IGC_CC_ARC_DET_PF.CC_DET_PF_LINE_ID	PO_DISTRIBUTIONS_ALL
IGC_CC_DET_PF_INTERFACE.INTERFACE_DET_PF_LINE_ID	PO_DISTRIBUTIONS_ALL
PA_BC_COMMITMENTS_ALL.DOCUMENT_DISTRIBUTION_ID	PO_DISTRIBUTIONS_ALL
PA_BC_COMMITMENTS_ALL.DOCUMENT_DISTRIBUTION_ID	PO_DISTRIBUTIONS_ALL
PA_BC_PACKETS.DOCUMENT_DISTRIBUTION_ID	PO_DISTRIBUTIONS_ALL
PA_BC_COMMITMENTS_ALL.PDL_PO_DISTRIBUTION_ID	PO_DISTRIBUTIONS_ALL
PO_ACCRUAL_RECONCILE_TEMP_ALL.PO_DISTRIBUTION_ID	PO_DISTRIBUTIONS_ALL
PO_ACCRUAL_WRITE_OFFS_ALL.PO_DISTRIBUTION_ID	PO_DISTRIBUTIONS_ALL
PO_DISTRIBUTIONS_ARCHIVE_ALL.PO_DISTRIBUTION_ID	PO_DISTRIBUTIONS_ALL
PO_DISTRIBUTIONS_ARCHIVE_ALL.SOURCE_DISTRIBUTION_ID	PO_DISTRIBUTIONS_ALL
PO_DISTRIBUTIONS_ALL.SOURCE_DISTRIBUTION_ID	PO_DISTRIBUTIONS_ALL
RCV_ACCOUNTING_EVENTS.PO_DISTRIBUTION_ID	PO_DISTRIBUTIONS_ALL
RCV_SHIPMENT_LINES.PO_DISTRIBUTION_ID	PO_DISTRIBUTIONS_ALL
RCV_SUPPLY.PO_DISTRIBUTION_ID	PO_DISTRIBUTIONS_ALL
RCV_TRANSACTIONS.PO_DISTRIBUTION_ID	PO_DISTRIBUTIONS_ALL
RCV_TRANSACTIONS_INTERFACE.PO_DISTRIBUTION_ID	PO_DISTRIBUTIONS_ALL

Comments:

PO_DISTRIBUTIONS_ALL包含采购订单发货行的会计分配信息。你需要为你附加到采购订单装运的每一个分配线一行。在Oracle Purchasing中使用发行版的文档有四种类型: Standard Purchase Orders、Planned Purchase Orders、Planned Purchase Order Releases、Blanket Purchase Order Releases。每行包括目标类型、请求者ID、订购数量以及分发的交付位置。Oracle采购使用此信息记录采购订单和发布的会计和请购信息。

PO_DISTRIBUTIONS_ALL是存储购买订单和发布信息的五个表之一。PO_DISTRIBUTIONS_ALL中的某些列只有在特定条件存在时才包含信息:

如果您从一个请求自动创建这个记帐分发，REQ_DISTRIBUTION_ID对应于您在采购订单上复制的请求分发的ID。

如果你在订单上使用外币，Oracle Purchasing使用RATE和存储货币转换信息
RATE_DATE。

如果使用了产权负担，则GL_ENCUMBERED_DATE和
GL_ENCUMBERED_PERIOD_NAME包含产权负担信息Oracle采购用于在Oracle总账中创建日记账条目。

如果您没有从在线申请自动创建采购订单，则REQ_LINE_REFERENCE_NUM和REQ_HEADER_REFERENCE_NUM包含相应的纸质申请的申请号和申请行号。这两个列不是另一个表的外键。

如果该分发对应于一个全面的采购订单释放，PO_RELEASE_ID将标识该释放。

如果SOURCE_DISTRIBUTION_ID有一个值，则该分发是计划采购订单释放的一部分。

如果您取消分发，Oracle采购会自动更新QUANTITY_CANCELLED或GL_CANCELLED_DATE。如果您使用了产权负担，Oracle采购也输入UNENCUMBERED_AMOUNT。

你可以在“分发”窗口中输入分发信息，可以通过“购买订单”和“发布”窗口访问。