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). | ||||
MATCHING_BASIS | VARCHAR2 | 32 | Matching basis of the line type (Quantity/Amount). | ||||
MATCH_OPTION | VARCHAR2 | 32 | Indicator of whether the invoice for the shipment should be matched to the purchase order or the receipt.Possible values are P for Purchase Order and R for Receipt |