COMMITMENT TYPE Table
A dimension table to be used with commitment fact tables, to identify types of commitments, such as blanket orders or LDS. Also includes commitment type codes and descriptions.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
COMMITMENT_CATEGORY |
Category of commitment: currently Manual Commitment, Purchase Order Commitment, and Purchase Requisition Commitment. |
VARCHAR2 |
50 |
COMMITMENT_CATEGORY_CODE |
Code designating category of commitment as defined in SAP. See Commitment_Category definition for descriptions. |
VARCHAR2 |
2 |
COMMITMENT_TYPE_KEY |
Key used to join to the COMMITMENT_TYPE table which describes various aspects of the commitment. |
VARCHAR2 |
5 |
IS_BLANKET_ORDER_COMMITMENT |
Flag indicating whether a commitment is a blanket order. Values: Y or N. |
VARCHAR2 |
1 |
IS_LDS_COMMITMENT |
Flag indicating whether a commitment is an LDS commitment. Values: Y or N. |
VARCHAR2 |
1 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |