PO_LN_SHP_EC_VW

(SQL View)
 Index Back

PO Line Shipping Schedule


SELECT B.EIP_CTL_ID , B.BUSINESS_UNIT , B.PO_ID , B.LINE_NBR , B.SCHED_NBR , B.PRICE_PO , B.DUE_DT , B.DUE_TIME , B.SHIPTO_ID , B.QTY_PO , B.MERCHANDISE_AMT , B.CURRENCY_CD , B.FREIGHT_TERMS , B.SHIP_TYPE_ID , B.REVISION , A.UNIT_OF_MEASURE FROM PS_PO_LINE_EC A , PS_PO_LINE_SHIP_EC B WHERE A.EIP_CTL_ID = B.EIP_CTL_ID AND A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.PO_ID = B.PO_ID AND A.LINE_NBR = B.LINE_NBR

  • Parent record: PO_LINE_EC

    • # 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 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    3 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
    4 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
    5 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
    6 PRICE_PO Signed Number(17,5) DECIMAL(15,5) NOT NULL Purchase Order Price
    7 DUE_DT Date(10) DATE Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.
    8 DUE_TIME Time(15) TIMESTAMP Due Time
    9 SHIPTO_ID Character(10) VARCHAR2(10) NOT NULL Ship To Location

    Prompt Table: SHIPTO_TBL

    10 QTY_PO Number(16,4) DECIMAL(15,4) NOT NULL Purchase Order Quantity
    11 MERCHANDISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
    12 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    13 FREIGHT_TERMS Character(10) VARCHAR2(10) NOT NULL Freight Terms Code

    Prompt Table: FREIGHT_TERMS

    14 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code

    Prompt Table: SHIP_METHOD

    15 REVISION Character(4) VARCHAR2(4) NOT NULL 01/27/2000 RML Added "As of" label
    16 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
    MHR=Muti Hourly
    PER=Percentage
    SQF=Square Footage