ORD_PRC_SCH_VW

(SQL View)
 Index Back

ORD_PRC_SCH_VW


SELECT OS.BUSINESS_UNIT ,OS.SHIP_TO_CUST_ID ,OS.ORDER_NO ,OS.ORDER_INT_LINE_NO ,OS.SCHED_LINE_NBR ,OS.LIST_PRICE ,OS.LIST_PRICE_BASE ,OS.CUST_PO_PRICE ,OS.CUST_PO_PRC_BASE ,OS.NET_UNIT_PRICE ,OS.NET_UNIT_PRICE_BSE ,OS.CUST_NET_PRICE ,OS.CUST_NET_PRC_BASE ,OS.CUST_BILL_BACK_ALL ,OS.CUST_BBACK_ALL_BSE ,OS.CUST_OFF_INV_DISC ,OS.CUST_OFF_INV_BASE ,OS.SHIP_FROM_BU ,OS.CURRENCY_CD ,OS.CURRENCY_CD_BASE ,OS.PRICE_PROTECTED FROM PS_ORD_SCHEDULE OS , PS_ORD_HOLD OH , PS_BUS_UNIT_TBL_OM OMBU WHERE OH.BUSINESS_UNIT = OS.BUSINESS_UNIT AND OH.ORDER_NO = OS.ORDER_NO AND OH.ORDER_INT_LINE_NO = OS.ORDER_INT_LINE_NO AND OH.SCHED_LINE_NBR = OS.SCHED_LINE_NBR AND OMBU.BUSINESS_UNIT = OH.BUSINESS_UNIT AND OH.HOLD_CD = OMBU.HOLD_PRC_DPY AND OH.EFF_STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship 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_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line
5 SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL Schedule Line Number
6 LIST_PRICE Signed Number(17,4) DECIMAL(15,4) NOT NULL List Price
7 LIST_PRICE_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL List Price (base)
8 CUST_PO_PRICE Signed Number(17,4) DECIMAL(15,4) NOT NULL Customer PO Price
9 CUST_PO_PRC_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Customer PO Price Base
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 CUST_NET_PRICE Signed Number(16,4) DECIMAL(14,4) NOT NULL Customer Net Price
13 CUST_NET_PRC_BASE Signed Number(16,4) DECIMAL(14,4) NOT NULL Customer Net Price Base
14 CUST_BILL_BACK_ALL Signed Number(18,5) DECIMAL(16,5) NOT NULL Customer's bill-back allowance
15 CUST_BBACK_ALL_BSE Signed Number(18,5) DECIMAL(16,5) NOT NULL Customer Bill Back Allow Base
16 CUST_OFF_INV_DISC Signed Number(18,5) DECIMAL(16,5) NOT NULL Customer Off-Inv Discount
17 CUST_OFF_INV_BASE Signed Number(18,5) DECIMAL(16,5) NOT NULL Cust Off Invoice Disc Base
18 SHIP_FROM_BU Character(5) VARCHAR2(5) NOT NULL Ship from INV BU
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 PRICE_PROTECTED Character(1) VARCHAR2(1) NOT NULL Price Protected

Y/N Table Edit