Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse VAPS POD Table


View exposing legacy VAPS purchase order distribution detail including purchase order, company, account and object codes, amount, cumulative amount, purchase order date, and add or log audit fields.


Field Name

Description

Data Type

Length

POD_ACCT_NUM

Pod acct num associated with the record.

VARCHAR2

5

POD_ADDED_AGENCY

Pod added agency associated with the record.

VARCHAR2

10

POD_ADDED_BY

Pod added by associated with the record.

VARCHAR2

12

POD_ADDED_DATE

Date associated with pod added.

VARCHAR2

12

POD_AMT

Pod amt associated with the record.

NUMBER

11,2

POD_CO_NUM

Pod co num associated with the record.

NUMBER

3

POD_CUM_AMT

Pod cum amt associated with the record.

NUMBER

11,2

POD_LOG

Pod log associated with the record.

VARCHAR2

1

POD_OBJ_CODE

Code identifying pod obj.

VARCHAR2

3

POD_PO_DATE

Date associated with pod po.

DATE

POD_PO_NUM

Pod po num associated with the record.

NUMBER

7