ORD_CUST_HS_VW

(SQL View)
 Index Back

Order Line view for copies

Date Initials Issue Description 110501 dms R-JMILLE-QC4A5 Prevent copy of canceled lines 111201 dms 9646001 Prevent copy of invalid prods 111601 dms 9646001 Remove unused fields 111506 dms 1576506002 Use ORD_HEADER_LOCK in SQL

SELECT A.BUSINESS_UNIT , A.SOLD_TO_CUST_ID , A.ORDER_NO , A.ORDER_DATE , B.ORDER_INT_LINE_NO , B.PRODUCT_ID , C.EFF_STATUS , C.ACTIVITY_ID , B.ADDRESS_SEQ_NUM , B.BCKORDR_CNCL_FLAG , C.BUSINESS_UNIT_PC , B.CARRIER_ID , B.CARRIER_ID_EXP , B.CCI_REQ_EXP , B.CNTCT_SEQ_SHIP , B.COO_REQ_EXP , B.CNTRCT_ID , B.CNTRCT_LINE_NBR , B.CNTRCT_SCHED_NBR , B.CURRENCY_CD , B.CURRENCY_CD_BASE , B.CUSTOMER_ITEM_NBR , B.CUSTOMER_PO , B.CUSTOMER_PO_LINE , C.DESCR , B.DROP_SHIP_FLAG , B.EXPORT , B.EXPORT_APPL_DT , B.EXPORT_LIC_APPL , B.EXPORT_LIC_EXPIRE , B.EXPORT_LIC_NBR , B.EXPORT_LIC_QTY , B.EXPORT_LIC_REC , B.EXPORT_LIC_REQ , B.EXPORT_LIC_TYPE , B.EXPORT_LIC_VALUE , B.EXPORT_REC_DT , B.FREIGHT_TERMS , B.FREIGHT_TERMS_EXP , B.IMPORT_APPL_DT , B.IMPORT_CERT_NBR , B.IMPORT_LIC_APPL , B.IMPORT_LIC_EXP , B.IMPORT_LIC_REC , B.IMPORT_LIC_REQ , B.IMPORT_REC_DT , B.NAFTA_REQ_EXP , B.PRICE_PROGRAM , B.PROD_ID_ENTERED , B.PROD_ID_SRC , C.PROJECT_ID , B.QTY_ORDERED , B.REASON_CD , B.SED_REQ_EXP , B.SHIP_PARTIAL_FLAG , A.SHIP_PRIOR_FLAG , B.SHIP_PRIORITY_EXP , B.SHIP_PRIORITY_ID , B.SHIP_TO_CUST_ID , B.SHIP_TYPE_ID , B.SHIP_TYPE_ID_EXP , B.STORE_NUMBER , B.UNIT_OF_MEASURE , B.UPC_ID , B.UPN_ID , B.CONFIG_CODE , B.TAX_CD FROM PS_ORD_HEADER A , PS_ORD_LINE B , PS_PROD_ITEM C WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.ORDER_NO = B.ORDER_NO AND A.ORDER_STATUS IN ('C','O','P') AND B.ORD_LINE_STATUS IN ('C','O','P') AND C.SETID = ( SELECT SETID FROM PS_SET_CNTRL_REC S WHERE S.SETCNTRLVALUE = A.BUSINESS_UNIT AND S.RECNAME = 'PROD_ITEM') AND B.PRODUCT_ID = C.PRODUCT_ID AND A.ORDER_TYPE_CD = 'SO' AND NOT EXISTS ( SELECT 'X' FROM PS_ORD_HEADER_LOCK L WHERE %Join(COMMON_KEYS, ORD_HEADER A, ORD_HEADER_LOCK L) AND L.BACKGROUND_REQD = 'Y')

  • Related Language Record: ORD_CUST_HS_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: BUS_UNIT_TBL_OM

    2 SOLD_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Sold To Customer
    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 ORDER_DATE Date(10) DATE Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
    5 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line

    Default Value: 1

    6 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
    7 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive
    8 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
    9 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number

    Prompt Table: CUST_ADDRSHP_VW

    10 BCKORDR_CNCL_FLAG Character(1) VARCHAR2(1) NOT NULL Cancel Backorder
    N=Cancel Backorder No
    Y=Cancel Backorder Yes

    Y/N Table Edit

    11 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit
    12 CARRIER_ID Character(10) VARCHAR2(10) NOT NULL Carrier ID

    Prompt Table: %EDITTABLE8

    13 CARRIER_ID_EXP Character(10) VARCHAR2(10) NOT NULL Export Carrier ID

    Prompt Table: %EDITTABLE8

    14 CCI_REQ_EXP Character(1) VARCHAR2(1) NOT NULL Canadian Customs Invoice
    N=No
    Y=Yes
    15 CNTCT_SEQ_SHIP Number(5,0) INTEGER NOT NULL Primary Contact - Ship To

    Prompt Table: CUST_CNCT_SH_VW

    16 COO_REQ_EXP Character(1) VARCHAR2(1) NOT NULL Certificate of Origin
    N=No
    Y=Yes
    17 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID

    Prompt Table: ORD_SCN_HDR1_VW

    18 CNTRCT_LINE_NBR Number(5,0) INTEGER NOT NULL Buying Agreement Line Nbr

    Prompt Table: ORD_SCN_LN_VW

    19 CNTRCT_SCHED_NBR Number(5,0) INTEGER NOT NULL Buying Agreement Schedule
    20 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    21 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency
    22 CUSTOMER_ITEM_NBR Character(18) VARCHAR2(18) NOT NULL Customer Item Number
    23 CUSTOMER_PO Character(25) VARCHAR2(25) NOT NULL Customer PO
    24 CUSTOMER_PO_LINE Character(11) VARCHAR2(11) NOT NULL Customer PO Line
    25 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    26 DROP_SHIP_FLAG Character(1) VARCHAR2(1) NOT NULL Drop Ship
    N=No
    Y=Yes
    27 EXPORT Character(1) VARCHAR2(1) NOT NULL Export Analytic Instance
    N=No
    Y=Yes
    28 EXPORT_APPL_DT Date(10) DATE Application Date
    29 EXPORT_LIC_APPL Character(3) VARCHAR2(3) NOT NULL Applied For
    NO=No
    YES=Yes
    30 EXPORT_LIC_EXPIRE Date(10) DATE Expiration Date
    31 EXPORT_LIC_NBR Character(18) VARCHAR2(18) NOT NULL Export License Nbr
    32 EXPORT_LIC_QTY Number(6,0) INTEGER NOT NULL License Quantity
    33 EXPORT_LIC_REC Character(3) VARCHAR2(3) NOT NULL License Received
    NO=No
    YES=Yes
    34 EXPORT_LIC_REQ Character(3) VARCHAR2(3) NOT NULL Export License Required
    NO=No
    YES=Yes
    35 EXPORT_LIC_TYPE Character(4) VARCHAR2(4) NOT NULL License Type
    GDST=General
    SPEC=Specific
    36 EXPORT_LIC_VALUE Number(10,2) DECIMAL(9,2) NOT NULL License Value
    37 EXPORT_REC_DT Date(10) DATE Date Received
    38 FREIGHT_TERMS Character(10) VARCHAR2(10) NOT NULL Freight Terms Code

    Prompt Table: %EDITTABLE7

    39 FREIGHT_TERMS_EXP Character(10) VARCHAR2(10) NOT NULL Export Freight Terms Code

    Prompt Table: %EDITTABLE7

    40 IMPORT_APPL_DT Date(10) DATE Application Date
    41 IMPORT_CERT_NBR Character(18) VARCHAR2(18) NOT NULL Import License Nbr
    42 IMPORT_LIC_APPL Character(3) VARCHAR2(3) NOT NULL Applied For
    NO=No
    YES=Yes
    43 IMPORT_LIC_EXP Date(10) DATE Expiration Date
    44 IMPORT_LIC_REC Character(3) VARCHAR2(3) NOT NULL License Received
    NO=No
    YES=Yes
    45 IMPORT_LIC_REQ Character(3) VARCHAR2(3) NOT NULL Import License Required
    NO=No
    YES=Yes
    46 IMPORT_REC_DT Date(10) DATE Date Received
    47 NAFTA_REQ_EXP Character(1) VARCHAR2(1) NOT NULL North American Free Trade Agmt
    N=No
    Y=Yes
    48 PRICE_PROGRAM Character(10) VARCHAR2(10) NOT NULL Date Initials Issue Description 111701 dms F-CJORGENS-11 Add EXCL_PRICE_LBL

    Prompt Table: EOEP_ARB_ID_VW

    49 PROD_ID_ENTERED Character(20) VARCHAR2(20) NOT NULL Product ID Entered
    50 PROD_ID_SRC Character(1) VARCHAR2(1) NOT NULL Product Source
    C=Customer
    P=UPC
    S=System
    U=Universal
    51 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
    52 QTY_ORDERED Signed Number(16,4) DECIMAL(14,4) NOT NULL Order Qty
    53 REASON_CD Character(10) VARCHAR2(10) NOT NULL Reason Code
    54 SED_REQ_EXP Character(1) VARCHAR2(1) NOT NULL Shippers Export Declaration
    N=No
    Y=Yes
    55 SHIP_PARTIAL_FLAG Character(1) VARCHAR2(1) NOT NULL Partial Schedules
    N=Ship Partial No
    Y=Ship Partial Yes

    Y/N Table Edit

    56 SHIP_PRIOR_FLAG Character(1) VARCHAR2(1) NOT NULL Ship Prior to Request Date
    N=Ship Prior No
    Y=Ship Prior Yes

    Y/N Table Edit

    57 SHIP_PRIORITY_EXP Character(6) VARCHAR2(6) NOT NULL Export Shipping Priority

    Prompt Table: %EDITTABLE6

    58 SHIP_PRIORITY_ID Character(6) VARCHAR2(6) NOT NULL Shipping Priority Code

    Prompt Table: %EDITTABLE6

    59 SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer

    Prompt Table: CUST_SLDSHP_VW

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

    Prompt Table: %EDITTABLE4

    61 SHIP_TYPE_ID_EXP Character(10) VARCHAR2(10) NOT NULL Export Shipping Method

    Prompt Table: %EDITTABLE4

    62 STORE_NUMBER Character(17) VARCHAR2(17) NOT NULL Store Number
    63 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: PROD_UOM

    64 UPC_ID Character(18) VARCHAR2(18) NOT NULL Uniform Product Code ID
    65 UPN_ID Character(20) VARCHAR2(20) NOT NULL Universal Product Number
    66 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator
    67 TAX_CD Character(8) VARCHAR2(8) NOT NULL Tax Code