Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST
Finance Reporting View Reports

SGHE Banner Operational Data Store
Reporting View Target: INVOICE_TEXT

Description Contains text lines associated with invoices.
Key & Frequency One row per document number per each line of text.
Recommended Search Columns INVOICE

Target Column Business Name Business Definition Database Data Type Domain Value Source Name Source Column
ADMINISTRATIVE_GROUP Administrative Group Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)  

NA

NA

INVOICE Invoice Invoice document number. VARCHAR2(63)  

FOBTEXT

FOBTEXT_CODE

MULTI_SOURCE Multi Source Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)  

NA

NA

MULTI_SOURCE_DESC Multi Source Description Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)  

NA

NA

PRINT_IND Print Indicator Permits the user to indicate what descriptive text should be printed on a document. VARCHAR2(63)  

FOBTEXT

FOBTEXT_PRT_IND

PROCESS_GROUP Process Group Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)  

NA

NA

SEQUENCE_NUMBER Sequence Number Sequence number used to order lines of text related to a document and item. NUMBER  

FOBTEXT

FOBTEXT_SEQ_NUM

TEXT Text User-defined text to be stored. VARCHAR2(255)  

FOBTEXT

FOBTEXT_TEXT



Ver: 9.0