CURRENT COMMITMENTS Table
View exposing current commitment records used for financial reporting and analysis.
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 |
COMPANY_CODE |
Code identifying company. |
VARCHAR2 |
4 |
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 |
PLANT_KEY |
Surrogate key identifying the plant. |
VARCHAR2 |
4 |
RECORD_VALID_FROM_DATE |
Date associated with record valid from. |
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_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 |
WAREHOUSE_LOAD_DATE |
Date associated with warehouse load. |
DATE |