OM_ADJWS_VW

(SQL View)
 Index Back

OM_ADJUST Worksheet Vw

Date Init Issue Description 102604 JJM F-CJORG-L1CX3 Sprinklebacks - Margin Adjustments 111506 dms 1576506002 Use ORD_HEADER_LOCK in SQL

SELECT OH.BUSINESS_UNIT , OH.ORDER_NO , OL.ORDER_INT_LINE_NO , OS.SCHED_LINE_NBR , OS.ORD_SCH_STATUS , OH.ORDER_TYPE_CD , OH.ORDER_DATE , OL.PRODUCT_ID , OL.CONFIG_CODE , OS.NET_UNIT_PRICE , OS.NET_UNIT_PRICE_BSE , OS.PRICE_PROTECTED , OS.QTY_SCHEDULED , 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_ORD_HEADER_LOCK OK WHERE %Join(COMMON_KEYS, ORD_HEADER OH , ORD_LINE OL) AND %Join(COMMON_KEYS, ORD_LINE OL, ORD_SCHEDULE OS) AND %Join(COMMON_KEYS, ORD_HEADER_LOCK OK, ORD_HEADER OH) AND OH.ORDER_STATUS IN ('O','P') AND OL.ORD_LINE_STATUS IN ('O','P') AND OS.ORD_SCH_STATUS IN ('O','P') AND OK.PROCESS_INSTANCE = 0 AND OK.IN_PROCESS_FLG = 'N'

# 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 ORD_SCH_STATUS Character(1) VARCHAR2(1) NOT NULL Schedule Status
C=Closed
O=Open
P=Pending
X=Canceled
6 ORDER_TYPE_CD Character(3) VARCHAR2(3) NOT NULL Order Type
QUO=Sales Quote
SO=Sales Order
7 ORDER_DATE Date(10) DATE Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
8 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
9 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator
10 NET_UNIT_PRICE Signed Number(16,4) DECIMAL(14,4) NOT NULL Net Unit Price
11 NET_UNIT_PRICE_BSE Signed Number(16,4) DECIMAL(14,4) NOT NULL Net Unit Price (base)
12 PRICE_PROTECTED Character(1) VARCHAR2(1) NOT NULL Price Protected
13 QTY_SCHEDULED Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity Scheduled
14 SHIP_FROM_BU Character(5) VARCHAR2(5) NOT NULL Ship from INV BU
15 SOLD_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Sold To Customer
16 BILL_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer
17 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
18 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency
19 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.
20 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
21 UNIT_COST Signed Number(16,4) DECIMAL(14,4) NOT NULL Unit Cost
22 UNIT_COST_ALT Signed Number(16,4) DECIMAL(14,4) NOT NULL Date Init. Issue # Description 092804 JJM F-CJORG-L1CX3 Sprinklebacks