COMMITMENT PO SUMMARY Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
COMMITMENT_AMOUNT |
The dollars committed (set aside) but not yet paid for the line item. |
NUMBER |
18,2 |
COMMITMENT_AMOUNT_LC |
XXX |
NUMBER |
18,2 |
COMPANY_CODE |
Shows to which "company" in SAP a cost collector is attached. MIT uses separate "companies" in SAP to differentiate financial transactions for different legal entities with differing business rules or reporting requirements. There are currently three company codes, "CUR" for main campus, "TECR" for MIT's alumni magazine, Technology Review, and "LCP1" for Lincoln Laboratory. |
VARCHAR2 |
4 |
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 |
EXPECTED_DEBIT_DATE |
Date when a commitment is expected to be posted. |
DATE |
|
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 |
INVOICED_AMOUNT |
The dollar amount associated with this transaction which has been invoiced. This value equates to the 'actual amounts' seen in the Financial Detail table. |
NUMBER |
18,2 |
INVOICED_AMOUNT_LC |
XXX |
NUMBER |
18,2 |
LOCAL_CURRENCY |
XXX |
VARCHAR2 |
5 |
PLANNED_AMOUNT |
Dollar amount planned for this commitment. |
NUMBER |
18,2 |
PLANNED_AMOUNT_LC |
XXX |
NUMBER |
18,2 |
PLANNED_QUANTITY |
Quantity planned for this commitment (ea, boxes, liters, etc.). |
NUMBER |
18,3 |
PO_LINE_ITEM |
XXX |
NUMBER |
|
PO_NUMBER |
Purchase Order number. |
VARCHAR2 |
10 |
TOTAL_QUANTITY |
Outstanding commitment quantity on the COMMITMENT_HISTORY. |
NUMBER |
18,3 |
TRANSACTION_CURRENCY |
XXX |
VARCHAR2 |
5 |
VENDOR_KEY |
Key identifying an entry in the VENDOR master table. This field should only be used for linking tables together, not for reporting. |
VARCHAR2 |
11 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |