BI_LINE_ERR_VW (SQL View)	Index Back
BI Line error view

BI_LINE_ERR_VW

(SQL View)

BI Line error view

SELECT A.BUSINESS_UNIT , A.INVOICE , A.LINE_SEQ_NUM , A.ERROR_STATUS_BI , A.PROCESS_INSTANCE , A.LAST_UPDATE_DTTM FROM PS_BI_LINE A WHERE A.ERROR_STATUS_BI <> ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

2 INVOICE Character(22) VARCHAR2(22) NOT NULL Invoice

3 LINE_SEQ_NUM Number(5,0) INTEGER NOT NULL Sequence

4 ERROR_STATUS_BI Character(4) VARCHAR2(4) NOT NULL Error Status

5 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

6 LAST_UPDATE_DTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	INVOICE	Character(22)	VARCHAR2(22) NOT NULL	Invoice
3	LINE_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Sequence
4	ERROR_STATUS_BI	Character(4)	VARCHAR2(4) NOT NULL	Error Status
5	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
6	LAST_UPDATE_DTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.