PO_SS_ASNOHD_VW

(SQL View)
 Index Back

Sup Portal: ASN History Vw


SELECT C.EIP_CTL_ID , C.ASN_SEQ_NBR , B.VENDOR_SETID , B.VENDOR_ID , B.VNDR_LOC , C.SHIPMENT_NO , C.PO_ID , C.ORDER_NO , B.ASN_STATUS , A.EIP_SOURCE , C.SHIP_DATE , B.ASN_RECEIVED_DT , B.SHIP_TYPE_ID , C.BILL_OF_LADING , C.PRO_NUMBER , B.CARRIER_ID FROM PS_RECV_AOHD_EC C , PS_RECV_ASHD_EC B , PS_EO_EIP_CTL A WHERE A.EIP_CTL_ID = B.EIP_CTL_ID AND B.EIP_CTL_ID = C.EIP_CTL_ID

  • Related Language Record: PO_SS_ASNOHD_LG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EIP_CTL_ID Character(25) VARCHAR2(25) NOT NULL Enterprise Components EIP (enterprise integration point) control field
    2 ASN_SEQ_NBR Number(9,0) DECIMAL(9) NOT NULL ASR Key sequence number
    3 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
    4 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
    5 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
    6 SHIPMENT_NO Character(30) VARCHAR2(30) NOT NULL Shipment Number
    7 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
    8 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
    9 ASN_STATUS Character(1) VARCHAR2(1) NOT NULL ASR Processing Status
    E=Error
    N=New
    P=Processed
    R=Ready
    V=Validated
    X=Canceled
    10 EIP_SOURCE Character(1) VARCHAR2(1) NOT NULL EIP Source
    1=Msg Agent
    2=Online
    3=Batch
    4=Auto Gen
    5=Message
    11 SHIP_DATE Date(10) DATE Item Shipping Date
    12 ASN_RECEIVED_DT Date(10) DATE ASR Trans Receipt Date
    13 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code
    14 BILL_OF_LADING Character(30) VARCHAR2(30) NOT NULL Specifies a bill of lading number associated with a Receivables item.
    15 PRO_NUMBER Character(40) VARCHAR2(40) NOT NULL Pro Number
    16 CARRIER_ID Character(10) VARCHAR2(10) NOT NULL Carrier ID