Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse VAPS PAID TRANS Table


XXX


Field Name

Description

Data Type

Length

D100_ADDR1

XXX

VARCHAR2

25

D100_ADDR2

XXX

VARCHAR2

25

D100_ADDR3

XXX

VARCHAR2

21

D100_ADDR4

XXX

VARCHAR2

21

D100_AGENCY

XXX

VARCHAR2

20

D100_AMOUNT

XXX

NUMBER

10,2

D100_BATCH_NO

XXX

NUMBER

4

D100_DATE_ENTERED

XXX

DATE

D100_DEFER_DATE

XXX

DATE

D100_FAST_CHECK

XXX

VARCHAR2

1

D100_ID

XXX

VARCHAR2

9

D100_INVOICE

XXX

VARCHAR2

20

D100_PAID_DATE

XXX

DATE

D100_PAYEE_NAME

XXX

VARCHAR2

26

D100_SEQ_NO

XXX

NUMBER

5

D100_TRANS_TYPE

XXX

NUMBER

2

D100_TRIP_NO

XXX

VARCHAR2

8

D100_USER_ID

XXX

VARCHAR2

12

D100_VENDOR_CODE

XXX

VARCHAR2

6

D100_VERIFY

XXX

VARCHAR2

1