Reporting View Target: RECEIVED_ITEM

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

SGHE Banner Operational Data Store
Reporting View Target: RECEIVED_ITEM_TEXT

Description Contains text lines associated with purchase order received items.
Key & Frequency One row per document number per each line of text.

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

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

RECEIVER_DOCUMENT Receiver Document Unique user defined or system assigned one-up document number for the receiving document. VARCHAR2(63)
FOBTEXT

FOBTEXT_CODE

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

Description	Contains text lines associated with purchase order received items.
Key & Frequency	One row per document number per each line of text.

Target Column	Business Name	Business Definition	Database Data Type	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
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
RECEIVER_DOCUMENT	Receiver Document	Unique user defined or system assigned one-up document number for the receiving document.	VARCHAR2(63)	FOBTEXT	FOBTEXT_CODE
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