Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse LIBRARY INVOICE STATUS Table


View exposing library invoice status reference values used to classify invoice processing states.


Field Name

Description

Data Type

Length

LIBRARY_INVOICE_STATUS_KEY

Surrogate key identifying the library invoice status.

VARCHAR2

10

PAYMENT_METHOD

Payment method associated with the record.

VARCHAR2

30

PAYMENT_METHOD_CODE

Code identifying payment method.

VARCHAR2

3

PAYMENT_STATUS

Payment status associated with the record.

VARCHAR2

30

PAYMENT_STATUS_CODE

Code identifying payment status.

VARCHAR2

2

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE