# 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 |  |

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