COMMITMENT PO SUMMARY Table
View exposing summarized purchase order commitment detail by cost collector, general ledger account, vendor, purchase order, and line item including commitment, planned, and invoiced amounts and quantities.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
COMMITMENT_AMOUNT |
Commitment amount as provided by the source. |
NUMBER |
18,2 |
COMMITMENT_AMOUNT_LC |
Commitment amount lc as provided by the source. |
NUMBER |
18,2 |
COMPANY_CODE |
Code identifying company. |
VARCHAR2 |
4 |
COST_COLLECTOR_KEY |
Surrogate key identifying the cost collector. |
VARCHAR2 |
12 |
EXPECTED_DEBIT_DATE |
Date associated with expected debit. |
DATE |
|
GL_ACCOUNT_KEY |
Surrogate key identifying the gl account. |
VARCHAR2 |
10 |
INVOICED_AMOUNT |
Invoiced amount as provided by the source. |
NUMBER |
18,2 |
INVOICED_AMOUNT_LC |
Invoiced amount lc as provided by the source. |
NUMBER |
18,2 |
LOCAL_CURRENCY |
Local currency as provided by the source. |
VARCHAR2 |
5 |
PLANNED_AMOUNT |
Planned amount as provided by the source. |
NUMBER |
18,2 |
PLANNED_AMOUNT_LC |
Planned amount lc as provided by the source. |
NUMBER |
18,2 |
PLANNED_QUANTITY |
Planned quantity as provided by the source. |
NUMBER |
18,3 |
PO_LINE_ITEM |
Po line item as provided by the source. |
NUMBER |
|
PO_NUMBER |
Po number as provided by the source. |
VARCHAR2 |
10 |
TOTAL_QUANTITY |
Total quantity as provided by the source. |
NUMBER |
18,3 |
TRANSACTION_CURRENCY |
Transaction currency as provided by the source. |
VARCHAR2 |
5 |
VENDOR_KEY |
Surrogate key identifying the vendor. |
VARCHAR2 |
11 |
WAREHOUSE_LOAD_DATE |
Date associated with warehouse load. |
DATE |