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).    
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    

Copyright © 2019, 2022, Oracle and/or its affiliates.