PRORD_STK_VW (SQL View)	Index Back
Ord stocked lines/scheds Date Initials Issue Description 022002 dms 11697201 Use sp_om_dnc_nonvw prompt

PRORD_STK_VW

(SQL View)

Ord stocked lines/scheds

Date Initials Issue Description 022002 dms 11697201 Use sp_om_dnc_nonvw prompt

SELECT o.business_unit , o.order_no , o.order_int_line_no , s.sched_line_nbr , s.activity_id , s.addr_ovrd_level , s.address_seq_num , s.atp_date , s.bckordr_cncl_flag , s.business_unit_pc , ' ' , s.cancel_date , s.carrier_id , s.carrier_id_exp , s.cci_req_exp , s.comm_pct , s.commsn_method , s.coo_req_exp , s.customer_po , s.customer_po_line , s.customer_po_sched , s.demand_sent , s.distrib_type , s.drop_ship_flag , s.ds_network_code , s.export_lic_req , s.export_lic_type , s.export_lic_appl , s.export_appl_dt , s.export_lic_rec , s.export_rec_dt , s.export_lic_nbr , s.export_lic_expire , s.export_lic_value , s.export_lic_qty , s.freight_terms , s.freight_terms_exp , s.import_lic_req , s.import_lic_appl , s.import_appl_dt , s.import_lic_rec , s.import_rec_dt , s.import_cert_nbr , s.import_lic_exp , s.invoice , s.invoice_dt , s.ord_sch_status , s.list_price , s.list_price_base , s.load_id , s.lot_alloc_flg , s.nafta_req_exp , s.net_unit_price , s.net_unit_price_bse , s.pc_distrib_status , s.po_distrib_status , s.po_hold_flag , ' ' , 0 , 0 , s.price_override , s.price_override_bse , s.price_program , s.priceset_price , s.priceset_price_bse , s.price_protected , o.product_id , o.product_id_orig , s.project_id , o.qty_ordered , s.qty_sched_orig , s.qty_scheduled , s.req_arrival_dttm , s.req_arrival_orig , ' ' , 0 , 0 , s.req_ship_dttm , s.req_ship_orig , s.route_cd , s.sched_arrv_dttm , s.sched_arrv_orig , s.sched_ship_dttm , s.sched_ship_orig , s.sed_req_exp , s.ship_from_bu , s.ship_partial_flag , h.ship_partial_ord , s.ship_prior_flag , s.ship_priority_id , s.ship_priority_exp , s.ship_to_cust_id , s.ship_type_id , s.ship_type_id_exp , s.special_handling , s.std_discount , s.store_number , s.support_team_cd , s.tax_amt , s.tax_amt_bse , s.tax_exempt_flg , s.geo_code , s.tax_pct , s.trnspt_lead_days , s.trnspt_lead_hours , s.trnspt_lead_min , o.unit_of_measure , s.datetime_added , s.lastupddttm , s.last_maint_oprid , s.process_instance FROM PS_ORD_SCHEDULE s , ps_prod_invitem_vw p , ps_ord_line o , ps_ord_header h WHERE p.setid = ( SELECT setid FROM ps_set_cntrl_rec WHERE SETCNTRLVALUE = o.business_unit AND recname = 'PROD_ITEM') AND o.product_id = p.product_id AND p.inventory_item = 'Y' AND %Join(COMMON_KEYS, ord_line o, ord_schedule s) AND %Join(COMMON_KEYS, ord_header h, ord_line o)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: OPR_DEF_TBL_OM.BUSINESS_UNIT
Prompt Table: BUS_UNIT_TBL_OM

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
Prompt Table: PRORD_NSTK_SRCH

3 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line
Prompt Table: PRORD_NSTK_SRCH

4 SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL Schedule Line Number
Prompt Table: PRORD_NSTK_SRCH

5 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID

6 ADDR_OVRD_LEVEL Character(1) VARCHAR2(1) NOT NULL Address Override Level
D=Demand Line
H=Header
L=Line
S=Schedule

7 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number

8 ATP_DATE Date(10) DATE ATP Promise Date

9 BCKORDR_CNCL_FLAG Character(1) VARCHAR2(1) NOT NULL Cancel Backorder
N=Cancel Backorder No
Y=Cancel Backorder Yes
Y/N Table Edit

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

11 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit

12 CANCEL_DATE Date(10) DATE Cancel Date

13 CARRIER_ID Character(10) VARCHAR2(10) NOT NULL Carrier ID

14 CARRIER_ID_EXP Character(10) VARCHAR2(10) NOT NULL Export Carrier ID

15 CCI_REQ_EXP Character(1) VARCHAR2(1) NOT NULL Canadian Customs Invoice
N=No
Y=Yes

16 COMM_PCT Number(6,2) DECIMAL(5,2) NOT NULL Commission %

17 COMMSN_METHOD Character(1) VARCHAR2(1) NOT NULL Commission Method
C=Commission Percent
P=Pro-Rata Percent

18 COO_REQ_EXP Character(1) VARCHAR2(1) NOT NULL Certificate of Origin
N=No
Y=Yes

19 CUSTOMER_PO Character(25) VARCHAR2(25) NOT NULL Customer PO

20 CUSTOMER_PO_LINE Character(11) VARCHAR2(11) NOT NULL Customer PO Line

21 CUSTOMER_PO_SCHED Character(11) VARCHAR2(11) NOT NULL Customer PO Schedule

22 DEMAND_SENT Character(1) VARCHAR2(1) NOT NULL Demand Sent to INV
Y/N Table Edit

23 DISTRIB_TYPE Character(10) VARCHAR2(10) NOT NULL Distrib. Type

24 DROP_SHIP_FLAG Character(1) VARCHAR2(1) NOT NULL Drop Ship
N=No
Y=Yes

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

26 EXPORT_LIC_REQ Character(3) VARCHAR2(3) NOT NULL Export License Required
NO=No
YES=Yes

27 EXPORT_LIC_TYPE Character(4) VARCHAR2(4) NOT NULL License Type
GDST=General
SPEC=Specific

28 EXPORT_LIC_APPL Character(3) VARCHAR2(3) NOT NULL Applied For
NO=No
YES=Yes

29 EXPORT_APPL_DT Date(10) DATE Application Date

30 EXPORT_LIC_REC Character(3) VARCHAR2(3) NOT NULL License Received
NO=No
YES=Yes

31 EXPORT_REC_DT Date(10) DATE Date Received

32 EXPORT_LIC_NBR Character(18) VARCHAR2(18) NOT NULL Export License Nbr

33 EXPORT_LIC_EXPIRE Date(10) DATE Expiration Date

34 EXPORT_LIC_VALUE Number(10,2) DECIMAL(9,2) NOT NULL License Value

35 EXPORT_LIC_QTY Number(6,0) INTEGER NOT NULL License Quantity

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

37 FREIGHT_TERMS_EXP Character(10) VARCHAR2(10) NOT NULL Export Freight Terms Code

38 IMPORT_LIC_REQ Character(3) VARCHAR2(3) NOT NULL Import License Required
NO=No
YES=Yes

39 IMPORT_LIC_APPL Character(3) VARCHAR2(3) NOT NULL Applied For
NO=No
YES=Yes

40 IMPORT_APPL_DT Date(10) DATE Application Date

41 IMPORT_LIC_REC Character(3) VARCHAR2(3) NOT NULL License Received
NO=No
YES=Yes

42 IMPORT_REC_DT Date(10) DATE Date Received

43 IMPORT_CERT_NBR Character(18) VARCHAR2(18) NOT NULL Import License Nbr

44 IMPORT_LIC_EXP Date(10) DATE Expiration Date

45 INVOICE Character(22) VARCHAR2(22) NOT NULL Invoice

46 INVOICE_DT Date(10) DATE Invoice Date

47 ORD_SCH_STATUS Character(1) VARCHAR2(1) NOT NULL Schedule Status
C=Closed
O=Open
P=Pending
X=Canceled

48 LIST_PRICE Signed Number(17,4) DECIMAL(15,4) NOT NULL List Price

49 LIST_PRICE_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL List Price (base)

50 LOAD_ID Character(10) VARCHAR2(10) NOT NULL Load ID

51 LOT_ALLOC_FLG Character(1) VARCHAR2(1) NOT NULL Allow Lot Allocation
Y/N Table Edit
Default Value: N

52 NAFTA_REQ_EXP Character(1) VARCHAR2(1) NOT NULL North American Free Trade Agmt
N=No
Y=Yes

53 NET_UNIT_PRICE Signed Number(16,4) DECIMAL(14,4) NOT NULL Net Unit Price

54 NET_UNIT_PRICE_BSE Signed Number(16,4) DECIMAL(14,4) NOT NULL Net Unit Price (base)

55 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

56 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

57 PO_HOLD_FLAG Character(1) VARCHAR2(1) NOT NULL PO Hold Flag
Y/N Table Edit

58 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order

59 PO_LINE_NBR Number(5,0) INTEGER NOT NULL Purchase Order Line Number

60 PO_SCHED_NBR Number(3,0) SMALLINT NOT NULL PO Schedule Number

61 PRICE_OVERRIDE Signed Number(16,4) DECIMAL(14,4) NOT NULL Price Override

62 PRICE_OVERRIDE_BSE Signed Number(16,4) DECIMAL(14,4) NOT NULL Price Override (base)

63 PRICE_PROGRAM Character(10) VARCHAR2(10) NOT NULL Date Initials Issue Description 111701 dms F-CJORGENS-11 Add EXCL_PRICE_LBL

64 PRICESET_PRICE Signed Number(16,4) DECIMAL(14,4) NOT NULL Price Rule Price

65 PRICESET_PRICE_BSE Signed Number(16,4) DECIMAL(14,4) NOT NULL Priceset Rule (base)

66 PRICE_PROTECTED Character(1) VARCHAR2(1) NOT NULL Price Protected

67 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID

68 PRODUCT_ID_ORIG Character(18) VARCHAR2(18) NOT NULL Original Product

69 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

70 QTY_ORDERED Signed Number(16,4) DECIMAL(14,4) NOT NULL Order Qty

71 QTY_SCHED_ORIG Signed Number(16,4) DECIMAL(14,4) NOT NULL Original Qty Scheduled

72 QTY_SCHEDULED Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity Scheduled

73 REQ_ARRIVAL_DTTM DateTime(26) TIMESTAMP Requested Arrival

74 REQ_ARRIVAL_ORIG DateTime(26) TIMESTAMP Original Req Arrival

75 REQ_ID Character(10) VARCHAR2(10) NOT NULL Requisition ID

76 REQ_LINE_NBR Number(5,0) INTEGER NOT NULL Requisition Line Number

77 REQ_SCHED_NBR Number(3,0) SMALLINT NOT NULL Requisition Schedule Number

78 REQ_SHIP_DTTM DateTime(26) TIMESTAMP Requested Ship

79 REQ_SHIP_ORIG DateTime(26) TIMESTAMP Original Req Ship

80 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.

81 SCHED_ARRV_DTTM DateTime(26) TIMESTAMP Schedule Arrival Dt/Tm

82 SCHED_ARRV_ORIG DateTime(26) TIMESTAMP Original Sch Arrival

83 SCHED_SHIP_DTTM DateTime(26) TIMESTAMP Schedule Ship Datetime

84 SCHED_SHIP_ORIG DateTime(26) TIMESTAMP Original Sch Ship

85 SED_REQ_EXP Character(1) VARCHAR2(1) NOT NULL Shippers Export Declaration
N=No
Y=Yes

86 SHIP_FROM_BU Character(5) VARCHAR2(5) NOT NULL Ship from INV BU
Prompt Table: SP_OM_DNS_NONVW

87 SHIP_PARTIAL_FLAG Character(1) VARCHAR2(1) NOT NULL Partial Schedules
N=Ship Partial No
Y=Ship Partial Yes
Y/N Table Edit

88 SHIP_PARTIAL_ORD Character(1) VARCHAR2(1) NOT NULL Partial Order
N=Partial Order No
Y=Partial Order Yes

89 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

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

91 SHIP_PRIORITY_EXP Character(6) VARCHAR2(6) NOT NULL Export Shipping Priority

92 SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer
Prompt Table: CUST_SHP_A1_VW

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

94 SHIP_TYPE_ID_EXP Character(10) VARCHAR2(10) NOT NULL Export Shipping Method

95 SPECIAL_HANDLING Character(1) VARCHAR2(1) NOT NULL Special Handling
N=No
Y=Yes
Y/N Table Edit
Default Value: N

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

97 STORE_NUMBER Character(17) VARCHAR2(17) NOT NULL Store Number

98 SUPPORT_TEAM_CD Character(6) VARCHAR2(6) NOT NULL Support Team Code

99 TAX_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Tax Amount

100 TAX_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Tax Amount (base)

101 TAX_EXEMPT_FLG Character(1) VARCHAR2(1) NOT NULL Tax Exempt Flag

102 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code

103 TAX_PCT Number(7,4) DECIMAL(6,4) NOT NULL Tax Percent

104 TRNSPT_LEAD_DAYS Number(3,0) SMALLINT NOT NULL Transportation Lead Tm (days)

105 TRNSPT_LEAD_HOURS Number(2,0) SMALLINT NOT NULL Transportation Lead Tm (Hours)

106 TRNSPT_LEAD_MIN Number(2,0) SMALLINT NOT NULL Transportation Lead Tm (Min)

107 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage

108 DATETIME_ADDED DateTime(26) TIMESTAMP DateTime Added

109 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

110 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID

111 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_OM.BUSINESS_UNIT Prompt Table: BUS_UNIT_TBL_OM
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 Prompt Table: PRORD_NSTK_SRCH
3	ORDER_INT_LINE_NO	Number(5,0)	INTEGER NOT NULL	Order Line Prompt Table: PRORD_NSTK_SRCH
4	SCHED_LINE_NBR	Number(6,0)	INTEGER NOT NULL	Schedule Line Number Prompt Table: PRORD_NSTK_SRCH
5	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID
6	ADDR_OVRD_LEVEL	Character(1)	VARCHAR2(1) NOT NULL	Address Override Level D=Demand Line H=Header L=Line S=Schedule
7	ADDRESS_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Address Sequence Number
8	ATP_DATE	Date(10)	DATE	ATP Promise Date
9	BCKORDR_CNCL_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Cancel Backorder N=Cancel Backorder No Y=Cancel Backorder Yes Y/N Table Edit
10	BUSINESS_UNIT_PC	Character(5)	VARCHAR2(5) NOT NULL	PC Business Unit
11	BUSINESS_UNIT_PO	Character(5)	VARCHAR2(5) NOT NULL	PO Business Unit
12	CANCEL_DATE	Date(10)	DATE	Cancel Date
13	CARRIER_ID	Character(10)	VARCHAR2(10) NOT NULL	Carrier ID
14	CARRIER_ID_EXP	Character(10)	VARCHAR2(10) NOT NULL	Export Carrier ID
15	CCI_REQ_EXP	Character(1)	VARCHAR2(1) NOT NULL	Canadian Customs Invoice N=No Y=Yes
16	COMM_PCT	Number(6,2)	DECIMAL(5,2) NOT NULL	Commission %
17	COMMSN_METHOD	Character(1)	VARCHAR2(1) NOT NULL	Commission Method C=Commission Percent P=Pro-Rata Percent
18	COO_REQ_EXP	Character(1)	VARCHAR2(1) NOT NULL	Certificate of Origin N=No Y=Yes
19	CUSTOMER_PO	Character(25)	VARCHAR2(25) NOT NULL	Customer PO
20	CUSTOMER_PO_LINE	Character(11)	VARCHAR2(11) NOT NULL	Customer PO Line
21	CUSTOMER_PO_SCHED	Character(11)	VARCHAR2(11) NOT NULL	Customer PO Schedule
22	DEMAND_SENT	Character(1)	VARCHAR2(1) NOT NULL	Demand Sent to INV Y/N Table Edit
23	DISTRIB_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Distrib. Type
24	DROP_SHIP_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Drop Ship N=No Y=Yes
25	DS_NETWORK_CODE	Character(6)	VARCHAR2(6) NOT NULL	Distribution Network Code
26	EXPORT_LIC_REQ	Character(3)	VARCHAR2(3) NOT NULL	Export License Required NO=No YES=Yes
27	EXPORT_LIC_TYPE	Character(4)	VARCHAR2(4) NOT NULL	License Type GDST=General SPEC=Specific
28	EXPORT_LIC_APPL	Character(3)	VARCHAR2(3) NOT NULL	Applied For NO=No YES=Yes
29	EXPORT_APPL_DT	Date(10)	DATE	Application Date
30	EXPORT_LIC_REC	Character(3)	VARCHAR2(3) NOT NULL	License Received NO=No YES=Yes
31	EXPORT_REC_DT	Date(10)	DATE	Date Received
32	EXPORT_LIC_NBR	Character(18)	VARCHAR2(18) NOT NULL	Export License Nbr
33	EXPORT_LIC_EXPIRE	Date(10)	DATE	Expiration Date
34	EXPORT_LIC_VALUE	Number(10,2)	DECIMAL(9,2) NOT NULL	License Value
35	EXPORT_LIC_QTY	Number(6,0)	INTEGER NOT NULL	License Quantity
36	FREIGHT_TERMS	Character(10)	VARCHAR2(10) NOT NULL	Freight Terms Code
37	FREIGHT_TERMS_EXP	Character(10)	VARCHAR2(10) NOT NULL	Export Freight Terms Code
38	IMPORT_LIC_REQ	Character(3)	VARCHAR2(3) NOT NULL	Import License Required NO=No YES=Yes
39	IMPORT_LIC_APPL	Character(3)	VARCHAR2(3) NOT NULL	Applied For NO=No YES=Yes
40	IMPORT_APPL_DT	Date(10)	DATE	Application Date
41	IMPORT_LIC_REC	Character(3)	VARCHAR2(3) NOT NULL	License Received NO=No YES=Yes
42	IMPORT_REC_DT	Date(10)	DATE	Date Received
43	IMPORT_CERT_NBR	Character(18)	VARCHAR2(18) NOT NULL	Import License Nbr
44	IMPORT_LIC_EXP	Date(10)	DATE	Expiration Date
45	INVOICE	Character(22)	VARCHAR2(22) NOT NULL	Invoice
46	INVOICE_DT	Date(10)	DATE	Invoice Date
47	ORD_SCH_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Schedule Status C=Closed O=Open P=Pending X=Canceled
48	LIST_PRICE	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	List Price
49	LIST_PRICE_BASE	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	List Price (base)
50	LOAD_ID	Character(10)	VARCHAR2(10) NOT NULL	Load ID
51	LOT_ALLOC_FLG	Character(1)	VARCHAR2(1) NOT NULL	Allow Lot Allocation Y/N Table Edit Default Value: N
52	NAFTA_REQ_EXP	Character(1)	VARCHAR2(1) NOT NULL	North American Free Trade Agmt N=No Y=Yes
53	NET_UNIT_PRICE	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	Net Unit Price
54	NET_UNIT_PRICE_BSE	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	Net Unit Price (base)
55	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
56	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
57	PO_HOLD_FLAG	Character(1)	VARCHAR2(1) NOT NULL	PO Hold Flag Y/N Table Edit
58	PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase Order
59	PO_LINE_NBR	Number(5,0)	INTEGER NOT NULL	Purchase Order Line Number
60	PO_SCHED_NBR	Number(3,0)	SMALLINT NOT NULL	PO Schedule Number
61	PRICE_OVERRIDE	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	Price Override
62	PRICE_OVERRIDE_BSE	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	Price Override (base)
63	PRICE_PROGRAM	Character(10)	VARCHAR2(10) NOT NULL	Date Initials Issue Description 111701 dms F-CJORGENS-11 Add EXCL_PRICE_LBL
64	PRICESET_PRICE	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	Price Rule Price
65	PRICESET_PRICE_BSE	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	Priceset Rule (base)
66	PRICE_PROTECTED	Character(1)	VARCHAR2(1) NOT NULL	Price Protected
67	PRODUCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product ID
68	PRODUCT_ID_ORIG	Character(18)	VARCHAR2(18) NOT NULL	Original Product
69	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField
70	QTY_ORDERED	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	Order Qty
71	QTY_SCHED_ORIG	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	Original Qty Scheduled
72	QTY_SCHEDULED	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Quantity Scheduled
73	REQ_ARRIVAL_DTTM	DateTime(26)	TIMESTAMP	Requested Arrival
74	REQ_ARRIVAL_ORIG	DateTime(26)	TIMESTAMP	Original Req Arrival
75	REQ_ID	Character(10)	VARCHAR2(10) NOT NULL	Requisition ID
76	REQ_LINE_NBR	Number(5,0)	INTEGER NOT NULL	Requisition Line Number
77	REQ_SCHED_NBR	Number(3,0)	SMALLINT NOT NULL	Requisition Schedule Number
78	REQ_SHIP_DTTM	DateTime(26)	TIMESTAMP	Requested Ship
79	REQ_SHIP_ORIG	DateTime(26)	TIMESTAMP	Original Req Ship
80	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.
81	SCHED_ARRV_DTTM	DateTime(26)	TIMESTAMP	Schedule Arrival Dt/Tm
82	SCHED_ARRV_ORIG	DateTime(26)	TIMESTAMP	Original Sch Arrival
83	SCHED_SHIP_DTTM	DateTime(26)	TIMESTAMP	Schedule Ship Datetime
84	SCHED_SHIP_ORIG	DateTime(26)	TIMESTAMP	Original Sch Ship
85	SED_REQ_EXP	Character(1)	VARCHAR2(1) NOT NULL	Shippers Export Declaration N=No Y=Yes
86	SHIP_FROM_BU	Character(5)	VARCHAR2(5) NOT NULL	Ship from INV BU Prompt Table: SP_OM_DNS_NONVW
87	SHIP_PARTIAL_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Partial Schedules N=Ship Partial No Y=Ship Partial Yes Y/N Table Edit
88	SHIP_PARTIAL_ORD	Character(1)	VARCHAR2(1) NOT NULL	Partial Order N=Partial Order No Y=Partial Order Yes
89	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
90	SHIP_PRIORITY_ID	Character(6)	VARCHAR2(6) NOT NULL	Shipping Priority Code
91	SHIP_PRIORITY_EXP	Character(6)	VARCHAR2(6) NOT NULL	Export Shipping Priority
92	SHIP_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Ship To Customer Prompt Table: CUST_SHP_A1_VW
93	SHIP_TYPE_ID	Character(10)	VARCHAR2(10) NOT NULL	Ship Via Code
94	SHIP_TYPE_ID_EXP	Character(10)	VARCHAR2(10) NOT NULL	Export Shipping Method
95	SPECIAL_HANDLING	Character(1)	VARCHAR2(1) NOT NULL	Special Handling N=No Y=Yes Y/N Table Edit Default Value: N
96	STD_DISCOUNT	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Standard Discount
97	STORE_NUMBER	Character(17)	VARCHAR2(17) NOT NULL	Store Number
98	SUPPORT_TEAM_CD	Character(6)	VARCHAR2(6) NOT NULL	Support Team Code
99	TAX_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Tax Amount
100	TAX_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Tax Amount (base)
101	TAX_EXEMPT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Tax Exempt Flag
102	GEO_CODE	Character(11)	VARCHAR2(11) NOT NULL	Geo Code
103	TAX_PCT	Number(7,4)	DECIMAL(6,4) NOT NULL	Tax Percent
104	TRNSPT_LEAD_DAYS	Number(3,0)	SMALLINT NOT NULL	Transportation Lead Tm (days)
105	TRNSPT_LEAD_HOURS	Number(2,0)	SMALLINT NOT NULL	Transportation Lead Tm (Hours)
106	TRNSPT_LEAD_MIN	Number(2,0)	SMALLINT NOT NULL	Transportation Lead Tm (Min)
107	UNIT_OF_MEASURE	Character(3)	VARCHAR2(3) NOT NULL	Used on an approval rule set. MHR=Muti Hourly PER=Percentage SQF=Square Footage
108	DATETIME_ADDED	DateTime(26)	TIMESTAMP	DateTime Added
109	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
110	LAST_MAINT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Last Maintained By Operator ID
111	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance