ORD_ORDADJ_VW

(SQL View)
 Index Back

Order adjustment view

Order adjustment view

SELECT A.BUSINESS_UNIT , A.ORDER_NO , A.ORDER_INT_LINE_NO , A.SCHED_LINE_NBR , A.PRC_SCHED_NBR , A.EOEP_RULE_ID , A.EOEP_FORMULA_ID , S.SHIP_FROM_BU , S.DELIVERY_ID , A.SEQ_NUM , A.ORDER_FLAG , %Round(%DecMult(A.PRICING_QTY, P.PRC_NET_UNIT_PRICE) , 4) , %Round(%DecMult(A.PRICING_QTY, A.OM_PRC_AMOUNT) , 4) , %Round(%DecMult(A.PRICING_QTY, A.OM_PRC_AMOUNT_BSE) , 4) , S.PAYMENT_INDICATOR , P.INVOICED_QTY FROM PS_ORD_PRICE_ADJST A , PS_ORD_PRICE_SCHED P , PS_ORD_SCHEDULE S , PS_ORD_LINE L WHERE A.BUSINESS_UNIT = P.BUSINESS_UNIT AND A.ORDER_NO = P.ORDER_NO AND A.ORDER_INT_LINE_NO = P.ORDER_INT_LINE_NO AND A.SCHED_LINE_NBR = P.SCHED_LINE_NBR AND A.PRC_SCHED_NBR = P.PRC_SCHED_NBR AND P.BUSINESS_UNIT = S.BUSINESS_UNIT AND P.ORDER_NO = S.ORDER_NO AND P.ORDER_INT_LINE_NO = S.ORDER_INT_LINE_NO AND P.SCHED_LINE_NBR = S.SCHED_LINE_NBR AND S.BUSINESS_UNIT = L.BUSINESS_UNIT AND S.ORDER_NO = L.ORDER_NO AND S.ORDER_INT_LINE_NO = L.ORDER_INT_LINE_NO AND L.ORD_LINE_STATUS <> 'X' AND S.ORD_SCH_STATUS <> 'X' AND A.ORDER_FLAG IN ('Y','L')

# 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 PRC_SCHED_NBR Number(6,0) INTEGER NOT NULL Pricing Schedule Number
6 EOEP_RULE_ID Character(30) VARCHAR2(30) NOT NULL Price Rule ID
7 EOEP_FORMULA_ID Number(10,0) DECIMAL(10) NOT NULL Pricing Formula ID
8 SHIP_FROM_BU Character(5) VARCHAR2(5) NOT NULL Ship from INV BU
9 DELIVERY_ID Character(10) VARCHAR2(10) NOT NULL Delivery ID
10 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
11 ORDER_FLAG Character(1) VARCHAR2(1) NOT NULL Total Order Flag
12 EXT_GROSS_NET Signed Number(29,4) DECIMAL(27,4) NOT NULL Extended Gross Net
13 ORD_ADJST_SCH_AMT Signed Number(19,4) DECIMAL(17,4) NOT NULL Adjustment Amount
14 ORD_ADJST_SCH_BASE Signed Number(19,4) DECIMAL(17,4) NOT NULL Adjustment Amount
15 PAYMENT_INDICATOR Character(2) VARCHAR2(2) NOT NULL Counter sale payment indicator
00=Invoice in Billing
01=Ready to Invoice
02=Not Ready to Invoice
03=Invoice in OM
04=Partial Payment
99=Canceled
16 INVOICED_QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Note: OM_BILL populates this field with the quantity invoiced in PRICING UOM.