PURCHASE ORDER TYPE Table
Contains information about the type of purchase order.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
PURCHASE_ORDER_TYPE_KEY |
Key identifying the type of Purchase Order. This key is used only for linking to the Purchase Order Type table, not for reporting. |
VARCHAR2 |
5 |
PURCHASE_ORDER_TYPE_NAME |
Name describing the type/kind of purchase order. |
VARCHAR2 |
20 |
PURCHASING_DOC_CATEGORY |
Code identifying the category of a purchasing document (Example: A, B, F, K, L). |
VARCHAR2 |
1 |
PURCHASING_DOC_CATEGORY_NAME |
Long name for the purchasing document category (Example: RFQ, Purchase Requisition, Purchase Order, Contract, Scheduling Agreement.) |
VARCHAR2 |
30 |
PURCHASING_DOC_TYPE |
Code identifing the type of a purchasing document. |
VARCHAR2 |
4 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |