AM_TXN_RE4_VW

(SQL View)
 Index Back

Rcvr Line Nbr - Intfc Review

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

SELECT DISTINCT BUSINESS_UNIT_RECV , RECEIVER_ID , RECV_LN_NBR FROM PS_INTFC_PHY_A A WHERE A.LOAD_STATUS NOT IN ('CON' , 'UNI') 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