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 This column is for Oracle Internal use only. 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