Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse VAPS TRANS DIST Table


XXX


Field Name

Description

Data Type

Length

BATCH_NO

XXX

NUMBER

4

DATE_ENTERED

XXX

DATE

DIST_ACCT

XXX

VARCHAR2

6

DIST_AMT

XXX

NUMBER

10,2

DIST_OBJ

XXX

VARCHAR2

5

DIST_STATUS

XXX

VARCHAR2

1

JV_DATE

XXX

DATE

JV_STATUS

XXX

VARCHAR2

1

SEQ_NO

XXX

NUMBER

5

SEQ_SUFFIX

XXX

NUMBER

2

TIME_ENTERED

XXX

VARCHAR2

6

TRANS_TYPE

XXX

NUMBER

2

TRIP_NO

XXX

VARCHAR2

8