PO DIST RAW Table
View exposing raw purchase order distribution records including cost collector, account, and distribution attributes.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ACCOUNT_ASSIGNMENT_NUMBER |
Account assignment number associated with the record. |
NUMBER |
2 |
ACCT_SETTLEMENT_REF_DATE |
Date associated with acct settlement ref. |
VARCHAR2 |
10 |
COMMITMENT_ITEM |
Commitment item associated with the record. |
VARCHAR2 |
14 |
COST_COLLECTOR_KEY |
Surrogate key identifying the cost collector. |
VARCHAR2 |
12 |
COST_ELEMENT |
Cost element associated with the record. |
VARCHAR2 |
12 |
DELETION_INDICATOR |
Indicator identifying whether deletion (Y/N). |
VARCHAR2 |
1 |
DISTRIBUTION_AMOUNT |
Distribution amount associated with the record. |
NUMBER |
34,2 |
DISTRIBUTION_PERCENTAGE |
Distribution percentage associated with the record. |
NUMBER |
34,2 |
FINAL_INVOICE_INDICATOR |
Indicator identifying whether final invoice (Y/N). |
VARCHAR2 |
1 |
FUND |
Fund associated with the record. |
VARCHAR2 |
10 |
FUND_CENTER |
Fund center associated with the record. |
VARCHAR2 |
16 |
GL_ACCOUNT_KEY |
Surrogate key identifying the gl account. |
VARCHAR2 |
10 |
GOODS_RECIPIENT |
Goods recipient associated with the record. |
VARCHAR2 |
50 |
IS_POSTING_TO_COST_CENTER |
Indicator identifying whether posting to cost center (Y/N). |
VARCHAR2 |
1 |
IS_POSTING_TO_ORDER |
Indicator identifying whether posting to order (Y/N). |
VARCHAR2 |
1 |
IS_POSTING_TO_PROJECT |
Indicator identifying whether posting to project (Y/N). |
VARCHAR2 |
1 |
LINE_ITEM_NUMBER |
Line item number associated with the record. |
NUMBER |
5 |
PO_VALUE |
Po value associated with the record. |
NUMBER |
16,2 |
PRIME_SPONSOR_KEY |
Surrogate key identifying the prime sponsor. |
VARCHAR2 |
10 |
PROFIT_CENTER |
Profit center associated with the record. |
VARCHAR2 |
10 |
PURCHASING_DOCUMENT_NUMBER |
Purchasing document number associated with the record. |
VARCHAR2 |
10 |
QUANTITY |
Quantity associated with the record. |
NUMBER |
17,3 |
SALES_DOCUMENT_ITEM |
Sales document item associated with the record. |
NUMBER |
6 |
SALES_DOCUMENT_NUMBER |
Sales document number associated with the record. |
VARCHAR2 |
10 |
SPONSOR_KEY |
Surrogate key identifying the sponsor. |
VARCHAR2 |
10 |
UNLOADING_POINT |
Unloading point associated with the record. |
VARCHAR2 |
60 |
UPDATE_FLAG |
Indicator identifying whether update (Y/N). |
VARCHAR2 |
1 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |