Purchasing line type dimension
Module: Purchasing
LINE_TYPE_ID
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 |