Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse PURCHASE ORDER TYPE Table


View exposing purchase order type reference records including PO type codes and descriptions used in procurement processing.


Field Name

Description

Data Type

Length

PURCHASE_ORDER_TYPE_KEY

Surrogate key identifying the purchase order type.

VARCHAR2

5

PURCHASE_ORDER_TYPE_NAME

Purchase order type name associated with the record.

VARCHAR2

20

PURCHASING_DOC_CATEGORY

Purchasing doc category associated with the record.

VARCHAR2

1

PURCHASING_DOC_CATEGORY_NAME

Purchasing doc category name associated with the record.

VARCHAR2

30

PURCHASING_DOC_TYPE

Purchasing doc type associated with the record.

VARCHAR2

4

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE