PO_REQ_DISTRIBUTIONS_ALL表格详细记录了与采购申请行相关的会计分布信息，每个申请行至少对应一个会计分布。该表包含如会计分录ID、预算账户、应付账户、差异账户等关键字段，并与其他多个表通过外键关联，如GL_CODE_COMBINATIONS、PA_PROJECTS_ALL等。此表在财务系统中起到核心作用，确保准确跟踪和分配财务数据。
描述：征用分布
Primary Key: PO_REQ_DISTRIBUTIONS_PK
- DISTRIBUTION_ID
Foreign Keys from this table:
| Foreign Key Column | Foreign Table |
|---|---|
| PO_REQ_DISTRIBUTIONS_ALL.REQUISITION_LINE_ID | PO_REQUISITION_LINES_ALL |
| PO_REQ_DISTRIBUTIONS_ALL.SET_OF_BOOKS_ID | GL_SETS_OF_BOOKS |
| PO_REQ_DISTRIBUTIONS_ALL.CODE_COMBINATION_ID | GL_CODE_COMBINATIONS |
| PO_REQ_DISTRIBUTIONS_ALL.BUDGET_ACCOUNT_ID | GL_CODE_COMBINATIONS |
| PO_REQ_DISTRIBUTIONS_ALL.ACCRUAL_ACCOUNT_ID | GL_CODE_COMBINATIONS |
| PO_REQ_DISTRIBUTIONS_ALL.VARIANCE_ACCOUNT_ID | GL_CODE_COMBINATIONS |
| PO_REQ_DISTRIBUTIONS_ALL.PROJECT_ID | PA_PROJECTS_ALL |
| PO_REQ_DISTRIBUTIONS_ALL.TASK_ID | PA_TASKS |
| PO_REQ_DISTRIBUTIONS_ALL.EXPENDITURE_TYPE | PA_EXPENDITURE_TYPES |
| PO_REQ_DISTRIBUTIONS_ALL.DISTRIBUTION_ID | PO_REQ_DISTRIBUTIONS_ALL |
Foreign Keys to this table:
| Foreign Key Column | Foreign Table |
|---|---|
| GMS_AWARD_DISTRIBUTIONS.DISTRIBUTION_ID | PO_REQ_DISTRIBUTIONS_ALL |
| PA_BC_COMMITMENTS_ALL.PRL_DISTRIBUTION_ID | PO_REQ_DISTRIBUTIONS_ALL |
| PO_DISTRIBUTIONS_ARCHIVE_ALL.REQ_DISTRIBUTION_ID | PO_REQ_DISTRIBUTIONS_ALL |
| PO_DISTRIBUTIONS_ALL.REQ_DISTRIBUTION_ID | PO_REQ_DISTRIBUTIONS_ALL |
| PO_REQUISITIONS_INTERFACE_ALL.REQ_DISTRIBUTION_ID | PO_REQ_DISTRIBUTIONS_ALL |
| PO_REQ_DISTRIBUTIONS_ALL.DISTRIBUTION_ID | PO_REQ_DISTRIBUTIONS_ALL |
| RCV_SHIPMENT_LINES.REQ_DISTRIBUTION_ID | PO_REQ_DISTRIBUTIONS_ALL |
| RCV_TRANSACTIONS.REQ_DISTRIBUTION_ID | PO_REQ_DISTRIBUTIONS_ALL |
| RCV_TRANSACTIONS_INTERFACE.REQ_DISTRIBUTION_ID | PO_REQ_DISTRIBUTIONS_ALL |
Comments：
PO_REQ_DISTRIBUTIONS_ALL存储与每个请求行关联的会计分布的信息。每个申请行必须至少有一个会计分布。你需要为创建的每个请求分布使用一行。每行包含Accounting Flexfield ID和requisition行数量。
PO_REQ_DISTRIBUTIONS_ALL是存储请求信息的三个表之一。
扫一扫
2657
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
