COMMITMENT HISTORY Table
View exposing historical financial commitment records including validity dates, cost collector, general ledger account, vendor, material group, reference document attributes, commitment amounts, quantities, expected debit dates, currencies, and transaction text.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
COMMITMENT_AMOUNT |
Commitment amount as provided by the source. |
NUMBER |
13,2 |
COMMITMENT_AMOUNT_LC |
Commitment amount lc as provided by the source. |
NUMBER |
13,2 |
COMMITMENT_TYPE_KEY |
Surrogate key identifying the commitment type. |
VARCHAR2 |
5 |
COST_COLLECTOR_KEY |
Surrogate key identifying the cost collector. |
VARCHAR2 |
12 |
COST_COLLECTOR_KEY |
Surrogate key identifying the cost collector. |
VARCHAR2 |
12 |
DOCUMENT_DATE |
Date associated with document. |
DATE |
|
EXPECTED_DEBIT_DATE |
Date associated with expected debit. |
DATE |
|
EXPECTED_DEBIT_FISCAL_PERIOD |
Expected debit fiscal period as provided by the source. |
VARCHAR2 |
6 |
GL_ACCOUNT_KEY |
Surrogate key identifying the gl account. |
VARCHAR2 |
10 |
LOCAL_CURRENCY |
Local currency as provided by the source. |
VARCHAR2 |
5 |
MATERIAL_GROUP_KEY |
Surrogate key identifying the material group. |
VARCHAR2 |
9 |
PLANNED_AMOUNT |
Planned amount as provided by the source. |
NUMBER |
13,2 |
PLANNED_AMOUNT_LC |
Planned amount lc as provided by the source. |
NUMBER |
13,2 |
PLANNED_QUANTITY |
Planned quantity as provided by the source. |
NUMBER |
15,3 |
RECORD_VALID_FROM_DATE |
Date associated with record valid from. |
DATE |
|
RECORD_VALID_FROM_DATE |
Date associated with record valid from. |
DATE |
|
RECORD_VALID_THRU_DATE |
Date associated with record valid thru. |
DATE |
|
RECORD_VALID_THRU_DATE |
Date associated with record valid thru. |
DATE |
|
REFERENCE_ASSIGNMENT_NUMBER |
Reference assignment number as provided by the source. |
NUMBER |
|
REFERENCE_DOCUMENT_NUMBER |
Reference document number as provided by the source. |
VARCHAR2 |
10 |
REFERENCE_DOCUMENT_NUMBER |
Reference document number as provided by the source. |
VARCHAR2 |
10 |
REFERENCE_DOCUMENT_TYPE |
Reference document type as provided by the source. |
VARCHAR2 |
30 |
REFERENCE_ITEM_NUMBER |
Reference item number as provided by the source. |
NUMBER |
|
SEGMENT_TEXT |
Segment text as provided by the source. |
VARCHAR2 |
120 |
TOTAL_QUANTITY |
Total quantity as provided by the source. |
NUMBER |
15,3 |
TRANSACTION_COUNTER |
Transaction counter as provided by the source. |
NUMBER |
|
TRANSACTION_CURRENCY |
Transaction currency as provided by the source. |
VARCHAR2 |
5 |
USER_ID |
Business identifier for the user. |
VARCHAR2 |
12 |
VENDOR_KEY |
Surrogate key identifying the vendor. |
VARCHAR2 |
11 |
VENDOR_KEY |
Surrogate key identifying the vendor. |
VARCHAR2 |
11 |
WAREHOUSE_LOAD_DATE |
Date associated with warehouse load. |
DATE |