AM_CON_RE3_VW (SQL View)	Index Back
Rcvr Line Nbr - Pre Intfc Selects the Receiver Business Unit + Receiver ID + Recv Line Number from those entries in pre interface am with load status NEW.

AM_CON_RE3_VW

(SQL View)

Rcvr Line Nbr - Pre Intfc

Selects the Receiver Business Unit + Receiver ID + Recv Line Number from those entries in pre interface am with load status NEW.

SELECT DISTINCT BUSINESS_UNIT_RECV , RECEIVER_ID , RECV_LN_NBR FROM PS_INTFC_PHY_A A WHERE A.LOAD_STATUS = 'NEW' AND A.RECEIVER_ID <> ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 KEY_CHAR_30_01 Character(30) VARCHAR2(30) NOT NULL Key Char(30) 01

3 RECV_LN_NBR Number(5,0) INTEGER NOT NULL Receipt Line

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	KEY_CHAR_30_01	Character(30)	VARCHAR2(30) NOT NULL	Key Char(30) 01
3	RECV_LN_NBR	Number(5,0)	INTEGER NOT NULL	Receipt Line