PO DIST RAW Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ACCOUNT_ASSIGNMENT_NUMBER |
Account distribution assignment serial number. This number identifies a single account distribution for a line item. |
NUMBER |
2 |
ACCT_SETTLEMENT_REF_DATE |
XXX |
VARCHAR2 |
10 |
COMMITMENT_ITEM |
In SAP's FM module, expenses are classified by "commitment item", not G/L account. Each G/L account in SAP's CO module maps to a "commitment item" in the FM module. There are many fewer commitment items that G/L accounts. FM's commitment items represent a more summarized view of expense types. |
VARCHAR2 |
14 |
COST_COLLECTOR_KEY |
Key used to join the Cost Collector to the financial transaction, and to get the master data that were current at the time of the transaction. This field should only be used for joining data, NOT for reporting. |
VARCHAR2 |
12 |
COST_ELEMENT |
Three digits used to identify the cost element in SAP. |
VARCHAR2 |
12 |
DELETION_INDICATOR |
XXX |
VARCHAR2 |
1 |
DISTRIBUTION_AMOUNT |
XXX |
NUMBER |
34,2 |
DISTRIBUTION_PERCENTAGE |
The percentage of the line item value which has been assigned to a particular cost collector/GL account. The percentage values of the account distributions for a given PO line item will total 100. |
NUMBER |
34,2 |
FINAL_INVOICE_INDICATOR |
XXX |
VARCHAR2 |
1 |
FUND |
XXX |
VARCHAR2 |
10 |
FUND_CENTER |
XXX |
VARCHAR2 |
16 |
GL_ACCOUNT_KEY |
Key used to join the GL_ACCOUNT to the financial transaction, and to get the master data that were current at the time of the transaction. This field should only be used for joining data, NOT for reporting. |
VARCHAR2 |
10 |
GOODS_RECIPIENT |
The person or group who will receive the goods. |
VARCHAR2 |
50 |
IS_POSTING_TO_COST_CENTER |
XXX |
VARCHAR2 |
1 |
IS_POSTING_TO_ORDER |
XXX |
VARCHAR2 |
1 |
IS_POSTING_TO_PROJECT |
XXX |
VARCHAR2 |
1 |
LINE_ITEM_NUMBER |
XXX |
NUMBER |
5 |
PO_VALUE |
XXX |
NUMBER |
16,2 |
PRIME_SPONSOR_KEY |
XXX |
VARCHAR2 |
10 |
PROFIT_CENTER |
XXX |
VARCHAR2 |
10 |
PURCHASING_DOCUMENT_NUMBER |
XXX |
VARCHAR2 |
10 |
QUANTITY |
The number of a particular key allocated to a person. |
NUMBER |
17,3 |
SALES_DOCUMENT_ITEM |
XXX |
NUMBER |
6 |
SALES_DOCUMENT_NUMBER |
XXX |
VARCHAR2 |
10 |
SPONSOR_KEY |
Key identifying an entry in the Sponsor master table. This field should only be used for linking tables together, not for reporting. |
VARCHAR2 |
10 |
UNLOADING_POINT |
The location to which the goods should be delivered. |
VARCHAR2 |
60 |
UPDATE_FLAG |
XXX |
VARCHAR2 |
1 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |