Data Warehouse

IS&T Home >   Data Warehouse

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