DW_PURCHASING_LINE_TYPE_D

Purchasing line type dimension

Details

Module: Purchasing

Key Columns

LINE_TYPE_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
LINE_TYPE_ID NUMBER 38 0 True Line type unique identifier    
SOURCE_RECORD_ID NUMBER 38 0   Source record identifier.    
LINE_TYPE_CODE VARCHAR2 32     Stores a unique code to identify the line type.    
CATEGORY_ID NUMBER 38 0   Item class    
PURCHASE_BASIS VARCHAR2 32     Purchase basis of the line type. (Goods/Services). Values are from the table DW_SCM_CODE_VALUES_LKP_TL with CODE_TYPE=PURCHASE BASIS. DW_SCM_CODE_VALUES_LKP_TL CODE
MATCHING_BASIS VARCHAR2 32     Matching basis of the line type (Quantity/Amount). Values are from the table DW_SCM_CODE_VALUES_LKP_TL with CODE_TYPE=MATCH_BASIS. DW_SCM_CODE_VALUES_LKP_TL CODE
MATCH_OPTION VARCHAR2 32     Indicator of whether the invoice for the shipment should be matched to the purchase order or the receipt. Values are from DW_SCM_CODE_VALUES_LKP_TL with CODE_TYPE=PO INVOICE MATCH OPTION. Possible values are P for Purchase Order and R for Receipt DW_SCM_CODE_VALUES_LKP_TL CODE