CS_POLNANDSHPVW

(SQL View)
 Index Back

PO line and ship schedule join

Used in SCMT bind mappings for PO

SELECT A.BUSINESS_UNIT ,A.PO_ID ,A.LINE_NBR ,B.SCHED_NBR ,A.CANCEL_STATUS ,A.CHANGE_STATUS ,A.ITM_SETID ,A.INV_ITEM_ID ,A.ITM_ID_VNDR ,A.VNDR_CATALOG_ID ,A.CATEGORY_ID ,A.CHNG_ORD_SEQ ,A.UNIT_OF_MEASURE ,A.QTY_TYPE ,A.PRICE_DT_TYPE ,A.MFG_ID ,A.MFG_ITM_ID ,A.CNTRCT_SETID ,A.CNTRCT_ID ,A.VERSION_NBR ,A.CNTRCT_LINE_NBR ,A.CAT_LINE_NBR ,A.RELEASE_NBR ,A.CNTRCT_RATE_MULT ,A.CNTRCT_RATE_DIV , A.VRBT_ID ,A.RFQ_ID ,A.RFQ_LINE_NBR ,A.INSPECT_CD ,A.ROUTING_ID ,A.RECV_REQ ,A.PRICE_CAN_CHANGE ,A.WTHD_SW ,A.WTHD_CD ,A.CONFIG_CODE ,A.CP_TEMPLATE_ID ,A.DESCR254_MIXED ,A.REPLEN_OPT ,A.AMT_ONLY_FLG ,%subrec(PUR_USR_LIN_SBR, A) ,A.GPO_ID ,A.GPO_CNTRCT_NBR ,A.BENEFIT_ID ,A.PHYSICAL_NATURE ,A.CNTRCT_CF_LOCK ,A.AUC_GROUP_ID ,B.DUE_DT ,B.DUE_TIME ,B.SHIPTO_ID ,B.SHIP_TYPE_ID ,B.CARRIER_ID ,B.REVISION ,B.PRICE_PO ,B.QTY_PO ,B.MERCHANDISE_AMT ,C.FREIGHT_AMT ,C.MISC_AMT ,C.SALETX_AMT ,(B.MERCHANDISE_AMT + C.FREIGHT_AMT + C.MISC_AMT + C.SALETX_AMT + C.USETAX_AMT + C.VAT_AMT) ,C.USETAX_AMT ,C.VAT_AMT FROM PS_PO_LINE A , PS_PO_LINE_SHIP B , PS_CS_PO_DISTSUMVW C WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.PO_ID=B.PO_ID AND A.LINE_NBR=B.LINE_NBR AND C.BUSINESS_UNIT = B.BUSINESS_UNIT AND C.PO_ID = B.PO_ID AND C.LINE_NBR = B.LINE_NBR AND C.SCHED_NBR = B.SCHED_NBR

  • Parent record: PO_HDR_FS

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
    3 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
    4 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
    5 CANCEL_STATUS Character(1) VARCHAR2(1) NOT NULL Cancel Status
    A=Active
    C=Closed
    D=Denied
    H=Hold
    O=Open
    P=Pending Approval
    X=Canceled

    Default Value: A

    6 CHANGE_STATUS Character(1) VARCHAR2(1) NOT NULL Change Order Status
    C=Changed
    U=Unchanged

    Default Value: U

    7 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID
    8 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

    Prompt Table: %EDIT_ITEM_ID

    9 ITM_ID_VNDR Character(50) VARCHAR2(50) NOT NULL Vendor Item ID
    10 VNDR_CATALOG_ID Character(20) VARCHAR2(20) NOT NULL Vendor's Catalog Number
    11 CATEGORY_ID Character(5) VARCHAR2(5) NOT NULL Category ID

    Prompt Table: ITM_CAT_VW

    12 CHNG_ORD_SEQ Number(3,0) SMALLINT NOT NULL Change Order Sequence Number
    13 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
    MHR=Muti Hourly
    PER=Percentage
    SQF=Square Footage

    Prompt Table: %EDIT_UOM

    14 QTY_TYPE Character(1) VARCHAR2(1) NOT NULL Quantity to Use for Prices
    L=Line Quantity
    S=Schedule Quantity

    Default Value: S

    15 PRICE_DT_TYPE Character(1) VARCHAR2(1) NOT NULL Date to Use for Prices
    D=Due Date
    P=PO Date

    Default Value: P

    16 MFG_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer ID

    Prompt Table: MANUFACTURER

    17 MFG_ITM_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer's Item ID
    18 CNTRCT_SETID Character(5) VARCHAR2(5) NOT NULL SetID
    19 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID

    Prompt Table: PO_CNTRCT_SRCH

    20 VERSION_NBR Number(5,0) INTEGER NOT NULL Contract Version number
    21 CNTRCT_LINE_NBR Number(5,0) INTEGER NOT NULL Buying Agreement Line Nbr

    Prompt Table: %EDIT_CNTRCT_LN

    22 CAT_LINE_NBR Number(5,0) INTEGER NOT NULL Contract Category Line Number
    23 RELEASE_NBR Number(5,0) INTEGER NOT NULL Release Number
    24 CNTRCT_RATE_MULT Number(16,8) DECIMAL(15,8) NOT NULL Contract Rate Multiplier
    25 CNTRCT_RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Contract Rate Divider
    26 VRBT_ID Character(25) VARCHAR2(25) NOT NULL Vendor Rebate ID
    27 RFQ_ID Character(10) VARCHAR2(10) NOT NULL RFQ ID
    28 RFQ_LINE_NBR Number(5,0) INTEGER NOT NULL RFQ Line
    29 INSPECT_CD Character(1) VARCHAR2(1) NOT NULL Inspection Required
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    30 ROUTING_ID Character(10) VARCHAR2(10) NOT NULL Inspection Routing ID

    Prompt Table: ROUTING_HDR

    31 RECV_REQ Character(1) VARCHAR2(1) NOT NULL Receiving Required
    N=Optional
    X=Do Not
    Y=Required

    Default Value: N

    32 PRICE_CAN_CHANGE Character(1) VARCHAR2(1) NOT NULL Price Can Be Changed on Order
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: Y

    33 WTHD_SW Character(1) VARCHAR2(1) NOT NULL Withholding Applicable Flag
    B=Global and 1099
    G=Global
    T=1099

    Y/N Table Edit

    34 WTHD_CD Character(5) VARCHAR2(5) NOT NULL Withholding Code
    35 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator
    36 CP_TEMPLATE_ID Character(10) VARCHAR2(10) NOT NULL Template ID Field
    37 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
    38 REPLEN_OPT Character(2) VARCHAR2(2) NOT NULL Replenish Code
    01=Standard
    02=Stockless
    39 AMT_ONLY_FLG Character(1) VARCHAR2(1) NOT NULL Amount Only
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    40 USER_LINE_CHAR1 Character(1) VARCHAR2(1) NOT NULL Custom Character 1
    41 CUSTOM_C100_B1 Character(100) VARCHAR2(100) NOT NULL Custom Field 1
    42 CUSTOM_C100_B2 Character(100) VARCHAR2(100) NOT NULL Custom Field 2
    43 CUSTOM_C100_B3 Character(100) VARCHAR2(100) NOT NULL Custom Field 3
    44 CUSTOM_C100_B4 Character(100) VARCHAR2(100) NOT NULL Custom Field 4
    45 CUSTOM_DATE_B Date(10) DATE Custom Date
    46 CUSTOM_C1_B Character(1) VARCHAR2(1) NOT NULL Custom Character 2
    47 GPO_ID Character(18) VARCHAR2(18) NOT NULL GPO ID
    48 GPO_CNTRCT_NBR Character(25) VARCHAR2(25) NOT NULL GPO Contract Number
    49 BENEFIT_ID Character(10) VARCHAR2(10) NOT NULL Benefit Identification
    50 PHYSICAL_NATURE Character(1) VARCHAR2(1) NOT NULL Physical Nature
    G=Goods
    S=Services
    51 CNTRCT_CF_LOCK Character(1) VARCHAR2(1) NOT NULL Lock Chartfields
    N=No
    Y=Yes
    52 AUC_GROUP_ID Character(18) VARCHAR2(18) NOT NULL GroupID
    53 DUE_DT Date(10) DATE NOT NULL 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.
    54 DUE_TIME Time(15) TIMESTAMP Due Time
    55 SHIPTO_ID Character(10) VARCHAR2(10) NOT NULL Ship To Location
    56 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code
    57 CARRIER_ID Character(10) VARCHAR2(10) NOT NULL Carrier ID
    58 REVISION Character(4) VARCHAR2(4) NOT NULL 01/27/2000 RML Added "As of" label
    59 PRICE_PO Signed Number(17,5) DECIMAL(15,5) NOT NULL Purchase Order Price
    60 QTY_PO Number(16,4) DECIMAL(15,4) NOT NULL Purchase Order Quantity
    61 MERCHANDISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
    62 FREIGHT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Freight Amount
    63 MISC_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Misc. Amount
    64 SALETX_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Sales Tax Amount
    65 TOTAL_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Amount
    66 USETAX_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount
    67 VAT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the amount of VAT associated with a transaction such as an invoice or a purchase order. In PeopleSoft Receivables this field is populated when the VAT declaration point is set to Invoice.