REQUISITION TYPE Table
Purchasing requisition type codes and descriptions
Field Name |
Description |
Data Type |
Length |
---|---|---|---|
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 |
REQUISITION_TYPE |
XXX |
VARCHAR2 |
4 |
REQUISITION_TYPE_KEY |
Key field used to join to the REQUISITION_TYPE table. This field should only be used for joining data, NOT for reporting. |
VARCHAR2 |
5 |
REQUISITION_TYPE_NAME |
XXX |
VARCHAR2 |
20 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |