Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse REQUISITION LONG TEXT Table


View exposing long-text lines associated with purchasing requisitions including text type, line sequence, line tag, and line text.


Field Name

Description

Data Type

Length

LINE_SEQUENCE

Line sequence associated with the record.

NUMBER

LINE_TAG

Line tag associated with the record.

VARCHAR2

2

LINE_TEXT

Line text associated with the record.

VARCHAR2

140

REQUISITION_ITEM

Requisition item associated with the record.

NUMBER

5

REQUISITION_NUMBER

Requisition number associated with the record.

VARCHAR2

10

REQUISITION_TEXT_TYPE

Requisition text type associated with the record.

VARCHAR2

9

WAREHOUSE_INSERT_TIMESTAMP

Warehouse insert timestamp associated with the warehouse record.

DATE

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE