EXD_IUT_VW2

(SQL View)
Index Back

Excise Inv IUT Receipt View 1

Supplier Excise Invoice prompt table on InterUnit Receipts.

SELECT L.SOURCE_BUS_UNIT , L.INTERUNIT_ID , L.BUSINESS_UNIT , L.RECEIVER_ID , L.BUSINESS_UNIT_IN , H.BILL_OF_LADING , L.PACKSLIP_NO FROM PS_INV_RECV_LN L , PS_INV_RECV_HDR H WHERE L.BUSINESS_UNIT = H.BUSINESS_UNIT AND L.RECEIVER_ID = H.RECEIVER_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SOURCE_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Source Bus Unit
2 INTERUNIT_ID Character(10) VARCHAR2(10) NOT NULL InterUnit Order ID
3 BUSINESS_UNIT_RECV Character(5) VARCHAR2(5) NOT NULL Receiving Business Unit
4 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number
5 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit
6 BILL_OF_LADING Character(30) VARCHAR2(30) NOT NULL Specifies a bill of lading number associated with a Receivables item.
7 PACKSLIP_NO Character(22) VARCHAR2(22) NOT NULL Packing Slip Number