PO_SS_ASNOLN_VW

(SQL View)
 Index Back

Sup Portal: ASN History Vw


SELECT A.EIP_CTL_ID , A.ASN_SEQ_NBR , A.ASN_SCHED_NBR , A.PO_ID , A.LINE_NBR , A.SCHED_NBR , A.ORDER_NO , A.ORDER_INT_LINE_NO , A.ASN_STATUS , B.ITM_ID_VNDR , A.INV_ITEM_ID , A.ASN_DESCR , A.DESCR254_MIXED , A.REVISION , A.QTY_SHIPPED_CONV , 0 , A.UNIT_MEASURE_SHIP , A.MESSAGE_NBR , A.SERIAL_CONTROL , A.LOT_CONTROL , ' ' , A.INVOICE_ID , A.PRO_NUMBER , A.BILL_OF_LADING , A.ERS_ACTION FROM PS_RECV_AOLN_EC A , PS_PO_LINE B WHERE A.BUSINESS_UNIT_PO = B.BUSINESS_UNIT AND A.PO_ID = B.PO_ID AND A.LINE_NBR = B.LINE_NBR

  • Related Language Record: PO_SS_ASNOLN_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 ASN_SCHED_NBR Number(9,0) DECIMAL(9) NOT NULL ASR Schedule Sequence Number
    4 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
    5 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
    6 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
    7 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
    8 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line
    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 ITM_ID_VNDR Character(50) VARCHAR2(50) NOT NULL Vendor Item ID
    11 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
    12 ASN_DESCR Character(30) VARCHAR2(30) NOT NULL ASR Item Description
    13 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
    14 REVISION Character(4) VARCHAR2(4) NOT NULL 01/27/2000 RML Added "As of" label
    15 QTY_SHIPPED_CONV Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Shipped
    16 QTY_SHIPPED Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Shipped
    17 UNIT_MEASURE_SHIP Character(3) VARCHAR2(3) NOT NULL Shipment Unit of Measure
    18 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
    19 SERIAL_CONTROL Character(1) VARCHAR2(1) NOT NULL Serial Control
    N=N
    Y=Y
    20 LOT_CONTROL Character(1) VARCHAR2(1) NOT NULL Lot Control
    N=N
    Y=Y
    21 MESSAGE_TEXT Character(100) VARCHAR2(100) NOT NULL Message Text This field refers to the Text for a particular Message Number in the Message Catalog.
    22 INVOICE_ID Character(30) VARCHAR2(30) NOT NULL Invoice Number
    23 PRO_NUMBER Character(40) VARCHAR2(40) NOT NULL Pro Number
    24 BILL_OF_LADING Character(30) VARCHAR2(30) NOT NULL Specifies a bill of lading number associated with a Receivables item.
    25 ERS_ACTION Character(1) VARCHAR2(1) NOT NULL ERS Action
    N=No
    Y=Yes