SRM_DB_RASN_VW

(SQL View)
 Index Back

ASN pagelet


SELECT DISTINCT D.BUYER_ID , A.EIP_CTL_ID , B.ORDER_NO , A.ASN_RECEIVED_DT , B.SHIPMENT_NO , E.SETID , E.VENDOR_ID , E.VNDR_NAME_SHRT_USR , D.BUSINESS_UNIT , D.PO_ID FROM PS_RECV_ASHD_EC A , PS_RECV_AOHD_EC B , PS_RECV_AOLN_EC C , PS_PO_HDR D , PS_VENDOR E , PS_PO_OPRDEFN_VW F , PS_SRM_DB_BU_VW G WHERE A.EIP_CTL_ID = B.EIP_CTL_ID AND B.EIP_CTL_ID = C.EIP_CTL_ID AND B.ASN_SEQ_NBR = C.ASN_SEQ_NBR AND B.BUSINESS_UNIT_PO = D.BUSINESS_UNIT AND B.PO_ID = D.PO_ID AND D.VENDOR_SETID = E.SETID AND D.VENDOR_ID = E.VENDOR_ID AND D.BUYER_ID = F.OPRID AND (G.BUYER_ID = D.BUYER_ID AND G.BUSINESS_UNIT = D.BUSINESS_UNIT)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer
2 EIP_CTL_ID Character(25) VARCHAR2(25) NOT NULL Enterprise Components EIP (enterprise integration point) control field
3 ORDER_NO Character(10) VARCHAR2(10) NOT NULL Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
4 ASN_RECEIVED_DT Date(10) DATE ASR Trans Receipt Date
5 SHIPMENT_NO Character(30) VARCHAR2(30) NOT NULL Shipment Number
6 SETID Character(5) VARCHAR2(5) NOT NULL SetID
7 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
8 VNDR_NAME_SHRT_USR Character(10) VARCHAR2(10) NOT NULL Short Vendor Name
9 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
10 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order