OM_ADJUST_VW

(SQL View)
 Index Back

OM_ADJUST Worksheet Vw

Date Init Issue Description 102604 JJM F-CJORG-L1CX3 Sprinklebacks - Margin Adjustments 081208 JJM ICE 1769021000 Removed Price Prot restriction

SELECT OH.BUSINESS_UNIT , OH.ORDER_NO , OL.ORDER_INT_LINE_NO , OS.SCHED_LINE_NBR , OH.ORDER_TYPE_CD , OH.ORDER_DATE , PI.SETID , OL.PRODUCT_ID , OL.CONFIG_CODE , CUST.SETID , CUST.NAME1 , OS.NET_UNIT_PRICE , OS.NET_UNIT_PRICE_BSE , OS.PRICE_PROTECTED , OS.PRICE_PROTECTED , OS.SHIP_FROM_BU , OH.SOLD_TO_CUST_ID , OH.BILL_TO_CUST_ID , OH.CURRENCY_CD , OH.CURRENCY_CD_BASE , OH.RT_TYPE , OL.UNIT_OF_MEASURE , OL.UNIT_COST , 0 FROM PS_ORD_HEADER OH , PS_ORD_LINE OL , PS_ORD_SCHEDULE OS , PS_CUSTOMER CUST , PS_PROD_ITEM PI WHERE %Join(COMMON_KEYS, ORD_HEADER OH , ORD_LINE OL) AND %Join(COMMON_KEYS, ORD_LINE OL, ORD_SCHEDULE OS) AND PI.PRODUCT_ID = OL.PRODUCT_ID AND PI.SETID = ( SELECT SCR1.SETID FROM PS_SET_CNTRL_REC SCR1 WHERE SCR1.SETCNTRLVALUE = OH.BUSINESS_UNIT AND SCR1.RECNAME = 'PROD_ITEM') AND CUST.CUST_ID = OH.SOLD_TO_CUST_ID AND CUST.SETID = ( SELECT SCR2.SETID FROM PS_SET_CNTRL_REC SCR2 WHERE SCR2.SETCNTRLVALUE = OH.BUSINESS_UNIT AND SCR2.RECNAME = 'CUSTOMER') AND OH.ORDER_STATUS IN ('O','P') AND OL.ORD_LINE_STATUS IN ('O','P') AND OS.ORD_SCH_STATUS IN ('O','P')

  • Related Language Record: OM_ADJUST_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 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
    3 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line
    4 SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL Schedule Line Number
    5 ORDER_TYPE_CD Character(3) VARCHAR2(3) NOT NULL Order Type
    QUO=Sales Quote
    SO=Sales Order
    6 ORDER_DATE Date(10) DATE Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
    7 PROD_SETID Character(5) VARCHAR2(5) NOT NULL Product SetID
    8 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
    9 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator
    10 CUST_SETID Character(5) VARCHAR2(5) NOT NULL Customer SetID
    11 CUST_NAME Character(40) VARCHAR2(40) NOT NULL Name
    12 NET_UNIT_PRICE Signed Number(16,4) DECIMAL(14,4) NOT NULL Net Unit Price
    13 NET_UNIT_PRICE_BSE Signed Number(16,4) DECIMAL(14,4) NOT NULL Net Unit Price (base)
    14 PRICE_PROT_ORIG Character(1) VARCHAR2(1) NOT NULL Date Init. Issue # Description 092804 JJM F-CJORG-L1CX3 Sprinklebacks
    15 PRICE_PROTECTED Character(1) VARCHAR2(1) NOT NULL Price Protected
    16 SHIP_FROM_BU Character(5) VARCHAR2(5) NOT NULL Ship from INV BU
    17 SOLD_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Sold To Customer
    18 BILL_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer
    19 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    20 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency
    21 RT_TYPE Character(5) VARCHAR2(5) NOT NULL Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
    22 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
    MHR=Muti Hourly
    PER=Percentage
    SQF=Square Footage
    23 UNIT_COST Signed Number(16,4) DECIMAL(14,4) NOT NULL Unit Cost
    24 UNIT_COST_ALT Signed Number(16,4) DECIMAL(14,4) NOT NULL Date Init. Issue # Description 092804 JJM F-CJORG-L1CX3 Sprinklebacks