PRORD_NSTK_VW (SQL View)	Index Back
Ord Nonstocked lines/scheds Date Initials Issue Description 091401 dms F-CJORGENS-11 Add REASON_CD 022002 dms 11697201 Use sp_om_dnc_nonvw prompt

PRORD_NSTK_VW

(SQL View)

Ord Nonstocked lines/scheds

Date Initials Issue Description 091401 dms F-CJORGENS-11 Add REASON_CD 022002 dms 11697201 Use sp_om_dnc_nonvw prompt

SELECT DISTINCT S.BUSINESS_UNIT , S.ORDER_NO , S.ORDER_INT_LINE_NO , S.SCHED_LINE_NBR , M.INV_ITEM_ID , 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 , INV.CONFIG_CODE , S.COO_REQ_EXP , S.CURRENCY_CD_BASE , 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.PRICE_PROTECTED , S.PRICESET_PRICE , S.PRICESET_PRICE_BSE , INV.PRODUCT_ID , L.PRODUCT_ID_ORIG , S.PROJECT_ID , L.QTY_ORDERED , S.QTY_SCHEDULED , S.QTY_SCHED_ORIG , S.REASON_CD , S.REQ_ARRIVAL_DTTM , S.REQ_ARRIVAL_ORIG , ' ' , 0 , 0 , S.REQ_SHIP_DTTM , S.REQ_SHIP_ORIG , S.RESOURCE_CATEGORY , S.RESOURCE_TYPE , S.RESOURCE_SUB_CAT , 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.TAX_PCT , S.TRNSPT_LEAD_DAYS , S.TRNSPT_LEAD_HOURS , S.TRNSPT_LEAD_MIN , INV.UNIT_OF_MEASURE , L.UNIT_COST , S.DATETIME_ADDED , S.LASTUPDDTTM , S.LAST_MAINT_OPRID , S.PROCESS_INSTANCE , INV.QTY_CODE , INV.QTY_PER , INV.PARENT_PROD_ID , s.cntct_seq_ship , H.CURRENCY_CD , H.BILL_ONLY , H.ORDER_GRP , H.SOURCE_CD , %DateNull , M.INVENTORY_ITEM , P.PHYSICAL_NATURE , M.UNIT_MEASURE_STD , M.LOT_CONTROL , M.SERIAL_CONTROL , M.SHIP_SERIAL_CNTRL , S.IN_FULFILL_STATE , P.PRODUCT_KIT_FLAG , P.CFG_KIT_FLAG , P.COST_ELEMENT , S.VAT_DFLT_DONE_FLG , S.VAT_ENTITY , S.COUNTRY_SHIP_FROM , S.STATE_SHIP_FROM FROM PS_IN_DEMAND INV , PS_ORD_SCHEDULE S , PS_MASTER_ITEM_TBL M , PS_ORD_LINE L , PS_ORD_HEADER H , PS_PROD_ITEM P WHERE M.SETID = ( SELECT SETID FROM PS_SET_CNTRL_REC WHERE RECNAME = 'PROD_ITEM' AND SETCNTRLVALUE = S.BUSINESS_UNIT) AND M.INV_ITEM_ID = INV.INV_ITEM_ID AND (M.INVENTORY_ITEM = 'N' OR S.DROP_SHIP_FLAG = 'Y' OR H.BILL_ONLY = 'Y') AND S.ORD_SCH_STATUS = 'O' AND INV.SOURCE_BUS_UNIT = S.BUSINESS_UNIT AND INV.ORDER_NO = S.ORDER_NO AND INV.ORDER_INT_LINE_NO = S.ORDER_INT_LINE_NO AND INV.SCHED_LINE_NBR = S.SCHED_LINE_NBR AND %Join(COMMON_KEYS, ord_line L, ord_schedule s) AND %Join(COMMON_KEYS, ord_header h, ord_line L) AND P.SETID = M.SETID AND P.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
Default Value: OPR_DEF_TBL_OM.BUSINESS_UNIT
Prompt Table: SP_BU_OM2_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
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 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

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

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

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

9 ATP_DATE Date(10) DATE ATP Promise Date

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

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

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

13 CANCEL_DATE Date(10) DATE Cancel Date

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

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

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

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

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

19 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator

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

21 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency

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

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

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

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

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

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

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

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

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

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

32 EXPORT_APPL_DT Date(10) DATE Application Date

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

34 EXPORT_REC_DT Date(10) DATE Date Received

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

36 EXPORT_LIC_EXPIRE Date(10) DATE Expiration Date

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

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

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

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

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

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

43 IMPORT_APPL_DT Date(10) DATE Application Date

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

45 IMPORT_REC_DT Date(10) DATE Date Received

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

47 IMPORT_LIC_EXP Date(10) DATE Expiration Date

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

49 INVOICE_DT Date(10) DATE Invoice Date

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

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

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

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

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

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

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

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

58 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

59 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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

76 REASON_CD Character(10) VARCHAR2(10) NOT NULL Reason Code

77 REQ_ARRIVAL_DTTM DateTime(26) TIMESTAMP Requested Arrival

78 REQ_ARRIVAL_ORIG DateTime(26) TIMESTAMP Original Req Arrival

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

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

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

82 REQ_SHIP_DTTM DateTime(26) TIMESTAMP Requested Ship

83 REQ_SHIP_ORIG DateTime(26) TIMESTAMP Original Req Ship

84 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Category

85 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Source Type

86 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Subcategory

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

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

89 SCHED_ARRV_ORIG DateTime(26) TIMESTAMP Original Sch Arrival

90 SCHED_SHIP_DTTM DateTime(26) TIMESTAMP Schedule Ship Datetime

91 SCHED_SHIP_ORIG DateTime(26) TIMESTAMP Original Sch Ship

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

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

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

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

96 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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

114 UNIT_COST Signed Number(16,4) DECIMAL(14,4) NOT NULL Unit Cost

115 DATETIME_ADDED DateTime(26) TIMESTAMP DateTime Added

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

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

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

119 QTY_CODE Character(3) VARCHAR2(3) NOT NULL Per
ASY=Assembly
ORD=Order

120 QTY_PER Number(10,4) DECIMAL(9,4) NOT NULL Quantity

121 PARENT_PROD_ID Character(18) VARCHAR2(18) NOT NULL Parent Product Id

122 CNTCT_SEQ_SHIP Number(5,0) INTEGER NOT NULL Primary Contact - Ship To

123 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

124 BILL_ONLY Character(1) VARCHAR2(1) NOT NULL Indicates a sales order is to be billed only, and not fulfilled through Inventory.

125 ORDER_GRP Character(6) VARCHAR2(6) NOT NULL Order Group

126 SOURCE_CD Character(6) VARCHAR2(6) NOT NULL Source Code

127 DEMAND_DATE Date(10) DATE Demand Date

128 INVENTORY_ITEM Character(1) VARCHAR2(1) NOT NULL Inventory Item
N=No
Y=Yes

129 PHYSICAL_NATURE Character(1) VARCHAR2(1) NOT NULL Physical Nature
G=Goods
S=Services

130 UNIT_MEASURE_STD Character(3) VARCHAR2(3) NOT NULL Standard Unit of Measure

131 LOT_CONTROL Character(1) VARCHAR2(1) NOT NULL Lot Control
N=N
Y=Y

132 SERIAL_CONTROL Character(1) VARCHAR2(1) NOT NULL Serial Control
N=N
Y=Y

133 SHIP_SERIAL_CNTRL Character(1) VARCHAR2(1) NOT NULL Shipping Serial Control

134 IN_FULFILL_STATE Character(2) VARCHAR2(2) NOT NULL Inventory Fulfillment State
10=Pending
20=Unfulfilled
30=Releasable
40=Released
50=Confirmed
60=Shipped
70=Depleted
90=Canceled

135 PRODUCT_KIT_FLAG Character(1) VARCHAR2(1) NOT NULL Product Kit

136 CFG_KIT_FLAG Character(1) VARCHAR2(1) NOT NULL Configured Kit

137 COST_ELEMENT Character(4) VARCHAR2(4) NOT NULL Cost Element

138 VAT_DFLT_DONE_FLG Character(1) VARCHAR2(1) NOT NULL VAT Defaulting Done
N=Awaiting Defaulting
X=Do not default
Y=Defaulting Done

139 VAT_ENTITY Character(20) VARCHAR2(20) NOT NULL Specifies an organizational entity that is responsible for VAT reporting and that is registered in one or more countries that require VAT reporting. A single VAT entity is linked to one or more General Ledger Business Units depending on the reporting requirements.

140 COUNTRY_SHIP_FROM Character(3) VARCHAR2(3) NOT NULL Specifies the country from which the invoice contents were shipped (for VAT processing only).

141 STATE_SHIP_FROM Character(6) VARCHAR2(6) NOT NULL Ship From State

#	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: SP_BU_OM2_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 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	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
6	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID
7	ADDR_OVRD_LEVEL	Character(1)	VARCHAR2(1) NOT NULL	Address Override Level D=Demand Line H=Header L=Line S=Schedule
8	ADDRESS_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Address Sequence Number
9	ATP_DATE	Date(10)	DATE	ATP Promise Date
10	BCKORDR_CNCL_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Cancel Backorder N=Cancel Backorder No Y=Cancel Backorder Yes Y/N Table Edit
11	BUSINESS_UNIT_PC	Character(5)	VARCHAR2(5) NOT NULL	PC Business Unit
12	BUSINESS_UNIT_PO	Character(5)	VARCHAR2(5) NOT NULL	PO Business Unit
13	CANCEL_DATE	Date(10)	DATE	Cancel Date
14	CARRIER_ID	Character(10)	VARCHAR2(10) NOT NULL	Carrier ID
15	CARRIER_ID_EXP	Character(10)	VARCHAR2(10) NOT NULL	Export Carrier ID
16	CCI_REQ_EXP	Character(1)	VARCHAR2(1) NOT NULL	Canadian Customs Invoice N=No Y=Yes
17	COMM_PCT	Number(6,2)	DECIMAL(5,2) NOT NULL	Commission %
18	COMMSN_METHOD	Character(1)	VARCHAR2(1) NOT NULL	Commission Method C=Commission Percent P=Pro-Rata Percent
19	CONFIG_CODE	Character(50)	VARCHAR2(50) NOT NULL	Product Configurator
20	COO_REQ_EXP	Character(1)	VARCHAR2(1) NOT NULL	Certificate of Origin N=No Y=Yes
21	CURRENCY_CD_BASE	Character(3)	VARCHAR2(3) NOT NULL	Business Unit Base Currency
22	CUSTOMER_PO	Character(25)	VARCHAR2(25) NOT NULL	Customer PO
23	CUSTOMER_PO_LINE	Character(11)	VARCHAR2(11) NOT NULL	Customer PO Line
24	CUSTOMER_PO_SCHED	Character(11)	VARCHAR2(11) NOT NULL	Customer PO Schedule
25	DEMAND_SENT	Character(1)	VARCHAR2(1) NOT NULL	Demand Sent to INV Y/N Table Edit
26	DISTRIB_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Distrib. Type
27	DROP_SHIP_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Drop Ship N=No Y=Yes
28	DS_NETWORK_CODE	Character(6)	VARCHAR2(6) NOT NULL	Distribution Network Code
29	EXPORT_LIC_REQ	Character(3)	VARCHAR2(3) NOT NULL	Export License Required NO=No YES=Yes
30	EXPORT_LIC_TYPE	Character(4)	VARCHAR2(4) NOT NULL	License Type GDST=General SPEC=Specific
31	EXPORT_LIC_APPL	Character(3)	VARCHAR2(3) NOT NULL	Applied For NO=No YES=Yes
32	EXPORT_APPL_DT	Date(10)	DATE	Application Date
33	EXPORT_LIC_REC	Character(3)	VARCHAR2(3) NOT NULL	License Received NO=No YES=Yes
34	EXPORT_REC_DT	Date(10)	DATE	Date Received
35	EXPORT_LIC_NBR	Character(18)	VARCHAR2(18) NOT NULL	Export License Nbr
36	EXPORT_LIC_EXPIRE	Date(10)	DATE	Expiration Date
37	EXPORT_LIC_VALUE	Number(10,2)	DECIMAL(9,2) NOT NULL	License Value
38	EXPORT_LIC_QTY	Number(6,0)	INTEGER NOT NULL	License Quantity
39	FREIGHT_TERMS	Character(10)	VARCHAR2(10) NOT NULL	Freight Terms Code
40	FREIGHT_TERMS_EXP	Character(10)	VARCHAR2(10) NOT NULL	Export Freight Terms Code
41	IMPORT_LIC_REQ	Character(3)	VARCHAR2(3) NOT NULL	Import License Required NO=No YES=Yes
42	IMPORT_LIC_APPL	Character(3)	VARCHAR2(3) NOT NULL	Applied For NO=No YES=Yes
43	IMPORT_APPL_DT	Date(10)	DATE	Application Date
44	IMPORT_LIC_REC	Character(3)	VARCHAR2(3) NOT NULL	License Received NO=No YES=Yes
45	IMPORT_REC_DT	Date(10)	DATE	Date Received
46	IMPORT_CERT_NBR	Character(18)	VARCHAR2(18) NOT NULL	Import License Nbr
47	IMPORT_LIC_EXP	Date(10)	DATE	Expiration Date
48	INVOICE	Character(22)	VARCHAR2(22) NOT NULL	Invoice
49	INVOICE_DT	Date(10)	DATE	Invoice Date
50	ORD_SCH_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Schedule Status C=Closed O=Open P=Pending X=Canceled
51	LIST_PRICE	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	List Price
52	LIST_PRICE_BASE	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	List Price (base)
53	LOAD_ID	Character(10)	VARCHAR2(10) NOT NULL	Load ID
54	LOT_ALLOC_FLG	Character(1)	VARCHAR2(1) NOT NULL	Allow Lot Allocation Y/N Table Edit Default Value: N
55	NAFTA_REQ_EXP	Character(1)	VARCHAR2(1) NOT NULL	North American Free Trade Agmt N=No Y=Yes
56	NET_UNIT_PRICE	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	Net Unit Price
57	NET_UNIT_PRICE_BSE	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	Net Unit Price (base)
58	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
59	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
60	PO_HOLD_FLAG	Character(1)	VARCHAR2(1) NOT NULL	PO Hold Flag Y/N Table Edit
61	PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase Order
62	PO_LINE_NBR	Number(5,0)	INTEGER NOT NULL	Purchase Order Line Number
63	PO_SCHED_NBR	Number(3,0)	SMALLINT NOT NULL	PO Schedule Number
64	PRICE_OVERRIDE	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	Price Override
65	PRICE_OVERRIDE_BSE	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	Price Override (base)
66	PRICE_PROGRAM	Character(10)	VARCHAR2(10) NOT NULL	Date Initials Issue Description 111701 dms F-CJORGENS-11 Add EXCL_PRICE_LBL
67	PRICE_PROTECTED	Character(1)	VARCHAR2(1) NOT NULL	Price Protected
68	PRICESET_PRICE	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	Price Rule Price
69	PRICESET_PRICE_BSE	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	Priceset Rule (base)
70	PRODUCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product ID
71	PRODUCT_ID_ORIG	Character(18)	VARCHAR2(18) NOT NULL	Original Product
72	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField
73	QTY_ORDERED	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	Order Qty
74	QTY_SCHEDULED	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Quantity Scheduled
75	QTY_SCHED_ORIG	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	Original Qty Scheduled
76	REASON_CD	Character(10)	VARCHAR2(10) NOT NULL	Reason Code
77	REQ_ARRIVAL_DTTM	DateTime(26)	TIMESTAMP	Requested Arrival
78	REQ_ARRIVAL_ORIG	DateTime(26)	TIMESTAMP	Original Req Arrival
79	REQ_ID	Character(10)	VARCHAR2(10) NOT NULL	Requisition ID
80	REQ_LINE_NBR	Number(5,0)	INTEGER NOT NULL	Requisition Line Number
81	REQ_SCHED_NBR	Number(3,0)	SMALLINT NOT NULL	Requisition Schedule Number
82	REQ_SHIP_DTTM	DateTime(26)	TIMESTAMP	Requested Ship
83	REQ_SHIP_ORIG	DateTime(26)	TIMESTAMP	Original Req Ship
84	RESOURCE_CATEGORY	Character(5)	VARCHAR2(5) NOT NULL	Category
85	RESOURCE_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Source Type
86	RESOURCE_SUB_CAT	Character(5)	VARCHAR2(5) NOT NULL	Subcategory
87	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.
88	SCHED_ARRV_DTTM	DateTime(26)	TIMESTAMP	Schedule Arrival Dt/Tm
89	SCHED_ARRV_ORIG	DateTime(26)	TIMESTAMP	Original Sch Arrival
90	SCHED_SHIP_DTTM	DateTime(26)	TIMESTAMP	Schedule Ship Datetime
91	SCHED_SHIP_ORIG	DateTime(26)	TIMESTAMP	Original Sch Ship
92	SED_REQ_EXP	Character(1)	VARCHAR2(1) NOT NULL	Shippers Export Declaration N=No Y=Yes
93	SHIP_FROM_BU	Character(5)	VARCHAR2(5) NOT NULL	Ship from INV BU Prompt Table: SP_OM_DNS_NONVW
94	SHIP_PARTIAL_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Partial Schedules N=Ship Partial No Y=Ship Partial Yes Y/N Table Edit
95	SHIP_PARTIAL_ORD	Character(1)	VARCHAR2(1) NOT NULL	Partial Order N=Partial Order No Y=Partial Order Yes
96	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
97	SHIP_PRIORITY_ID	Character(6)	VARCHAR2(6) NOT NULL	Shipping Priority Code
98	SHIP_PRIORITY_EXP	Character(6)	VARCHAR2(6) NOT NULL	Export Shipping Priority
99	SHIP_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Ship To Customer Prompt Table: CUST_SHP_A1_VW
100	SHIP_TYPE_ID	Character(10)	VARCHAR2(10) NOT NULL	Ship Via Code
101	SHIP_TYPE_ID_EXP	Character(10)	VARCHAR2(10) NOT NULL	Export Shipping Method
102	SPECIAL_HANDLING	Character(1)	VARCHAR2(1) NOT NULL	Special Handling N=No Y=Yes Y/N Table Edit Default Value: N
103	STD_DISCOUNT	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Standard Discount
104	STORE_NUMBER	Character(17)	VARCHAR2(17) NOT NULL	Store Number
105	SUPPORT_TEAM_CD	Character(6)	VARCHAR2(6) NOT NULL	Support Team Code
106	TAX_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Tax Amount
107	TAX_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Tax Amount (base)
108	TAX_EXEMPT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Tax Exempt Flag
109	TAX_PCT	Number(7,4)	DECIMAL(6,4) NOT NULL	Tax Percent
110	TRNSPT_LEAD_DAYS	Number(3,0)	SMALLINT NOT NULL	Transportation Lead Tm (days)
111	TRNSPT_LEAD_HOURS	Number(2,0)	SMALLINT NOT NULL	Transportation Lead Tm (Hours)
112	TRNSPT_LEAD_MIN	Number(2,0)	SMALLINT NOT NULL	Transportation Lead Tm (Min)
113	UNIT_OF_MEASURE	Character(3)	VARCHAR2(3) NOT NULL	Used on an approval rule set. MHR=Muti Hourly PER=Percentage SQF=Square Footage
114	UNIT_COST	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	Unit Cost
115	DATETIME_ADDED	DateTime(26)	TIMESTAMP	DateTime Added
116	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.
117	LAST_MAINT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Last Maintained By Operator ID
118	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
119	QTY_CODE	Character(3)	VARCHAR2(3) NOT NULL	Per ASY=Assembly ORD=Order
120	QTY_PER	Number(10,4)	DECIMAL(9,4) NOT NULL	Quantity
121	PARENT_PROD_ID	Character(18)	VARCHAR2(18) NOT NULL	Parent Product Id
122	CNTCT_SEQ_SHIP	Number(5,0)	INTEGER NOT NULL	Primary Contact - Ship To
123	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
124	BILL_ONLY	Character(1)	VARCHAR2(1) NOT NULL	Indicates a sales order is to be billed only, and not fulfilled through Inventory.
125	ORDER_GRP	Character(6)	VARCHAR2(6) NOT NULL	Order Group
126	SOURCE_CD	Character(6)	VARCHAR2(6) NOT NULL	Source Code
127	DEMAND_DATE	Date(10)	DATE	Demand Date
128	INVENTORY_ITEM	Character(1)	VARCHAR2(1) NOT NULL	Inventory Item N=No Y=Yes
129	PHYSICAL_NATURE	Character(1)	VARCHAR2(1) NOT NULL	Physical Nature G=Goods S=Services
130	UNIT_MEASURE_STD	Character(3)	VARCHAR2(3) NOT NULL	Standard Unit of Measure
131	LOT_CONTROL	Character(1)	VARCHAR2(1) NOT NULL	Lot Control N=N Y=Y
132	SERIAL_CONTROL	Character(1)	VARCHAR2(1) NOT NULL	Serial Control N=N Y=Y
133	SHIP_SERIAL_CNTRL	Character(1)	VARCHAR2(1) NOT NULL	Shipping Serial Control
134	IN_FULFILL_STATE	Character(2)	VARCHAR2(2) NOT NULL	Inventory Fulfillment State 10=Pending 20=Unfulfilled 30=Releasable 40=Released 50=Confirmed 60=Shipped 70=Depleted 90=Canceled
135	PRODUCT_KIT_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Product Kit
136	CFG_KIT_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Configured Kit
137	COST_ELEMENT	Character(4)	VARCHAR2(4) NOT NULL	Cost Element
138	VAT_DFLT_DONE_FLG	Character(1)	VARCHAR2(1) NOT NULL	VAT Defaulting Done N=Awaiting Defaulting X=Do not default Y=Defaulting Done
139	VAT_ENTITY	Character(20)	VARCHAR2(20) NOT NULL	Specifies an organizational entity that is responsible for VAT reporting and that is registered in one or more countries that require VAT reporting. A single VAT entity is linked to one or more General Ledger Business Units depending on the reporting requirements.
140	COUNTRY_SHIP_FROM	Character(3)	VARCHAR2(3) NOT NULL	Specifies the country from which the invoice contents were shipped (for VAT processing only).
141	STATE_SHIP_FROM	Character(6)	VARCHAR2(6) NOT NULL	Ship From State