Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse 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