ORDENT_SHIP_VW

(SQL View)
 Index Back

Order entry shipment schedule

Order entry shipment schedules display.

SELECT S.BUSINESS_UNIT , S.ORDER_NO , S.ORDER_INT_LINE_NO , S.SCHED_LINE_NBR , S.DELIVERY_ID , L.PROD_ID_ENTERED , L.PRODUCT_ID , I.DESCR , S.SCHED_SHIP_DTTM , S.SHIP_FROM_BU , S.CARRIER_ID , L.UNIT_OF_MEASURE , S.QTY_SCHEDULED , %Round(%DecMult(S.NET_UNIT_PRICE, S.QTY_SCHEDULED), 4) , S.NET_UNIT_PRICE , S.CURRENCY_CD , S.NET_UNIT_PRICE_BSE , S.CURRENCY_CD_BASE , S.SHIP_TO_CUST_ID , S.ADDRESS_SEQ_NUM , S.ADDR_OVRD_LEVEL , 'N' , I.DIST_CFG_FLAG , I.PRDN_CFG_FLAG , I.CFG_KIT_FLAG FROM PS_ORD_SCHEDULE S , PS_ORD_LINE L , PS_ORDENT_PITEM_VW I , PS_SET_CNTRL_REC R WHERE %Join(COMMON_KEYS, ORD_SCHEDULE S, ORD_LINE L) AND L.ORD_LINE_STATUS NOT IN ('X','C') AND R.SETCNTRLVALUE = S.BUSINESS_UNIT AND R.RECNAME = 'ORDENT_PITEM_VW' AND R.SETID = I.SETID AND I.PRODUCT_ID = L.PRODUCT_ID

# 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 DELIVERY_ID Character(10) VARCHAR2(10) NOT NULL Delivery ID
6 PROD_ID_ENTERED Character(20) VARCHAR2(20) NOT NULL Product ID Entered
7 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
8 DESCR Character(30) VARCHAR2(30) NOT NULL Description
9 SCHED_SHIP_DTTM DateTime(26) TIMESTAMP Schedule Ship Datetime
10 SHIP_FROM_BU Character(5) VARCHAR2(5) NOT NULL Ship from INV BU
11 CARRIER_ID Character(10) VARCHAR2(10) NOT NULL Carrier ID
12 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
13 QTY_SCHEDULED Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity Scheduled
14 EXTENDED_NET_PRICE Signed Number(29,4) DECIMAL(27,4) NOT NULL Ext Net Amount
15 NET_UNIT_PRICE Signed Number(16,4) DECIMAL(14,4) NOT NULL Net Unit Price
16 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
17 NET_UNIT_PRICE_BSE Signed Number(16,4) DECIMAL(14,4) NOT NULL Net Unit Price (base)
18 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency
19 SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer
20 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number
21 ADDR_OVRD_LEVEL Character(1) VARCHAR2(1) NOT NULL Address Override Level
D=Demand Line
H=Header
L=Line
S=Schedule
22 CP_OPT_DETL_BTN Character(1) VARCHAR2(1) NOT NULL Option Detail button
23 DIST_CFG_FLAG Character(1) VARCHAR2(1) NOT NULL Distribution Configuration
24 PRDN_CFG_FLAG Character(1) VARCHAR2(1) NOT NULL Production Configuration
25 CFG_KIT_FLAG Character(1) VARCHAR2(1) NOT NULL Configured Kit