ORD_SCH_COPY_VW

(SQL View)
 Index Back

Order Sched cpy from hdr lvl

Date Initials Issue Description 022002 dms 11697201 Use sp_om_dnc_nonvw prompt 052504 dms F-KNANN-V59N4 Remove ship_partial_ord

SELECT business_unit , order_no , order_int_line_no , sched_line_nbr , ship_to_cust_id , activity_id , address_seq_num , addr_ovrd_level , bckordr_cncl_flag , business_unit_pc , commsn_method , comm_pct , distrib_type , drop_ship_flag , ds_network_code , freight_terms , list_price , list_price_base , net_unit_price , net_unit_price_bse , pc_distrib_status , po_distrib_status , po_hold_flag , price_override , price_override_bse , price_program , price_protected , priceset_price , priceset_price_bse , project_id , qty_scheduled , req_arrival_dttm , req_ship_dttm , route_cd , sched_arrv_dttm , sched_ship_dttm , ship_from_bu , ship_partial_flag , ship_prior_flag , ship_priority_id , ship_type_id , std_discount , support_team_cd , tax_amt , tax_amt_bse , tax_exempt_flg , geo_code , tax_pct , trnspt_lead_days , trnspt_lead_hours , trnspt_lead_min FROM PS_ORD_SCHEDULE WHERE ord_sch_status = 'O'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BU_OM_NONVW

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

Default Value: 1

4 SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL Schedule Line Number
5 SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer

Default Value: ORD_HEADER.SOLD_TO_CUST_ID

Prompt Table: CUST_SHP_A1_VW

6 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
7 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number
8 ADDR_OVRD_LEVEL Character(1) VARCHAR2(1) NOT NULL Address Override Level
D=Demand Line
H=Header
L=Line
S=Schedule
9 BCKORDR_CNCL_FLAG Character(1) VARCHAR2(1) NOT NULL Cancel Backorder
N=Cancel Backorder No
Y=Cancel Backorder Yes

Y/N Table Edit

Default Value: ORD_LINE.BCKORDR_CNCL_FLAG

10 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit

Default Value: ORD_HEADER.BUSINESS_UNIT_PC

11 COMMSN_METHOD Character(1) VARCHAR2(1) NOT NULL Commission Method
C=Commission Percent
P=Pro-Rata Percent
12 COMM_PCT Number(6,2) DECIMAL(5,2) NOT NULL Commission %
13 DISTRIB_TYPE Character(10) VARCHAR2(10) NOT NULL Distrib. Type
14 DROP_SHIP_FLAG Character(1) VARCHAR2(1) NOT NULL Drop Ship
N=No
Y=Yes

Default Value: N

15 DS_NETWORK_CODE Character(6) VARCHAR2(6) NOT NULL Distribution Network Code

Default Value: ORD_HEADER.DS_NETWORK_CODE

16 FREIGHT_TERMS Character(10) VARCHAR2(10) NOT NULL Freight Terms Code

Default Value: ORD_LINE.FREIGHT_TERMS

17 LIST_PRICE Signed Number(17,4) DECIMAL(15,4) NOT NULL List Price
18 LIST_PRICE_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL List Price (base)
19 NET_UNIT_PRICE Signed Number(16,4) DECIMAL(14,4) NOT NULL Net Unit Price
20 NET_UNIT_PRICE_BSE Signed Number(16,4) DECIMAL(14,4) NOT NULL Net Unit Price (base)
21 PC_DISTRIB_STATUS Character(1) VARCHAR2(1) NOT NULL PC Distribution Status
B=Budget Check
D=Distributed
G=Generated
H=Hold
I=Ignore
M=Modified
N=Not Distributed
S=Staged

Default Value: N

22 PO_DISTRIB_STATUS Character(1) VARCHAR2(1) NOT NULL PO Distribution Status
0=Non-PO
1=Active
2=In-process
3=Error
4=Processed
5=Modified
23 PO_HOLD_FLAG Character(1) VARCHAR2(1) NOT NULL PO Hold Flag

Y/N Table Edit

Default Value: N

24 PRICE_OVERRIDE Signed Number(16,4) DECIMAL(14,4) NOT NULL Price Override
25 PRICE_OVERRIDE_BSE Signed Number(16,4) DECIMAL(14,4) NOT NULL Price Override (base)
26 PRICE_PROGRAM Character(10) VARCHAR2(10) NOT NULL Date Initials Issue Description 111701 dms F-CJORGENS-11 Add EXCL_PRICE_LBL
27 PRICE_PROTECTED Character(1) VARCHAR2(1) NOT NULL Price Protected
28 PRICESET_PRICE Signed Number(16,4) DECIMAL(14,4) NOT NULL Price Rule Price
29 PRICESET_PRICE_BSE Signed Number(16,4) DECIMAL(14,4) NOT NULL Priceset Rule (base)
30 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

Default Value: ORD_HEADER.PROJECT_ID

31 QTY_SCHEDULED Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity Scheduled
32 REQ_ARRIVAL_DTTM DateTime(26) TIMESTAMP Requested Arrival

Default Value: ORD_LINE.REQ_ARRIVAL_DTTM

33 REQ_SHIP_DTTM DateTime(26) TIMESTAMP Requested Ship
34 ROUTE_CD Character(6) VARCHAR2(6) NOT NULL A unique identifier assigned to a delivery route. Route codes can be associated with customer addresses for external orders or locations for internal orders. Route codes can be used to identify the appropriate delivery schedule for a customer/location if you are managing product shipments with your own vehicles.
35 SCHED_ARRV_DTTM DateTime(26) TIMESTAMP Schedule Arrival Dt/Tm
36 SCHED_SHIP_DTTM DateTime(26) TIMESTAMP Schedule Ship Datetime

Default Value: ORD_LINE.SCHED_SHIP_DTTM

37 SHIP_FROM_BU Character(5) VARCHAR2(5) NOT NULL Ship from INV BU

Default Value: ORD_LINE.SHIP_FROM_BU

Prompt Table: SP_OM_DNS_NONVW

38 SHIP_PARTIAL_FLAG Character(1) VARCHAR2(1) NOT NULL Partial Schedules
N=Ship Partial No
Y=Ship Partial Yes

Y/N Table Edit

Default Value: ORD_LINE.SHIP_PARTIAL_FLAG

39 SHIP_PRIOR_FLAG Character(1) VARCHAR2(1) NOT NULL Ship Prior to Request Date
N=Ship Prior No
Y=Ship Prior Yes

Y/N Table Edit

Default Value: ORD_LINE.SHIP_PRIOR_FLAG

40 SHIP_PRIORITY_ID Character(6) VARCHAR2(6) NOT NULL Shipping Priority Code

Default Value: ORD_LINE.SHIP_PRIORITY_ID

41 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code

Default Value: ORD_LINE.SHIP_TYPE_ID

42 STD_DISCOUNT Signed Number(7,2) DECIMAL(5,2) NOT NULL Standard Discount

Default Value: ORD_HEADER.STD_DISCOUNT

43 SUPPORT_TEAM_CD Character(6) VARCHAR2(6) NOT NULL Support Team Code
44 TAX_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Tax Amount
45 TAX_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Tax Amount (base)
46 TAX_EXEMPT_FLG Character(1) VARCHAR2(1) NOT NULL Tax Exempt Flag
47 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
48 TAX_PCT Number(7,4) DECIMAL(6,4) NOT NULL Tax Percent
49 TRNSPT_LEAD_DAYS Number(3,0) SMALLINT NOT NULL Transportation Lead Tm (days)
50 TRNSPT_LEAD_HOURS Number(2,0) SMALLINT NOT NULL Transportation Lead Tm (Hours)
51 TRNSPT_LEAD_MIN Number(2,0) SMALLINT NOT NULL Transportation Lead Tm (Min)