PRORD_MARK_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 082106 JJM 1551597000 Added CUST_ID field 111506 dms 1576506002 Use ORD_HEADER_LOCK in SQL

PRORD_MARK_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 082106 JJM 1551597000 Added CUST_ID field 111506 dms 1576506002 Use ORD_HEADER_LOCK in SQL

SELECT INV.SOURCE_BUS_UNIT , INV.ORDER_NO , INV.ORDER_INT_LINE_NO , INV.SCHED_LINE_NBR , INV.INV_ITEM_ID , INV.DEMAND_LINE_NO , INV.DEMAND_SOURCE , 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 , H.SOLD_TO_CUST_ID , 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 , O.PRODUCT_ID_ORIG , S.PROJECT_ID , INV.QTY_REQUESTED , O.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.SUPPLY_DOC_CREATED , 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 , O.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 , INV.DEMAND_DATE , M.INVENTORY_ITEM , M.PHYSICAL_NATURE , M.UNIT_MEASURE_STD , INV.IST_DISTRIB_STATUS FROM PS_IN_DEMAND INV , PS_ORD_SCHEDULE S , PS_MASTER_ITEM_TBL M , PS_ORD_LINE O , PS_ORD_HEADER H , PS_ORD_HEADER_LOCK K 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 INV.IN_FULFILL_STATE = '10' AND %Join(COMMON_KEYS, ord_line o, ord_schedule s) AND %Join(COMMON_KEYS, ord_header h, ord_line o) AND %Join(COMMON_KEYS, ord_header_lock k, ord_header h) AND K.IN_PROCESS_FLG <> 'Y' AND K.BACKGROUND_REQD = 'N' AND K.HOLD_REQD = 'N' AND K.CREDIT_REQD = 'N' AND K.PROCESS_INSTANCE = 0

# 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 DEMAND_LINE_NO Number(4,0) SMALLINT NOT NULL Demand Line No

7 DEMAND_SOURCE Character(2) VARCHAR2(2) NOT NULL Demand Source
IN=Material Request
OM=Sales Order
PL=Planning Requisition
PO=Purchase Order
PR=Purchasing Requisition
RT=Material Return
SF=Production Request
WM=Work Order

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

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

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

11 ATP_DATE Date(10) DATE ATP Promise Date

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

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

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

15 CANCEL_DATE Date(10) DATE Cancel Date

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

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

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

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

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

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

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

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

24 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.

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

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

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

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

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

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

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

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

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

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

35 EXPORT_APPL_DT Date(10) DATE Application Date

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

37 EXPORT_REC_DT Date(10) DATE Date Received

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

39 EXPORT_LIC_EXPIRE Date(10) DATE Expiration Date

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

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

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

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

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

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

46 IMPORT_APPL_DT Date(10) DATE Application Date

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

48 IMPORT_REC_DT Date(10) DATE Date Received

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

50 IMPORT_LIC_EXP Date(10) DATE Expiration Date

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

52 INVOICE_DT Date(10) DATE Invoice Date

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

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

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

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

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

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

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

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

61 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

62 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

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

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

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

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

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

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

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

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

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

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

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

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

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

76 QTY_REQUESTED Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Requested

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

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

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

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

81 REQ_ARRIVAL_DTTM DateTime(26) TIMESTAMP Requested Arrival

82 REQ_ARRIVAL_ORIG DateTime(26) TIMESTAMP Original Req Arrival

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

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

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

86 REQ_SHIP_DTTM DateTime(26) TIMESTAMP Requested Ship

87 REQ_SHIP_ORIG DateTime(26) TIMESTAMP Original Req Ship

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

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

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

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

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

93 SCHED_ARRV_ORIG DateTime(26) TIMESTAMP Original Sch Arrival

94 SCHED_SHIP_DTTM DateTime(26) TIMESTAMP Schedule Ship Datetime

95 SCHED_SHIP_ORIG DateTime(26) TIMESTAMP Original Sch Ship

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

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

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

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

100 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

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

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

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

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

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

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

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

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

109 SUPPLY_DOC_CREATED Character(1) VARCHAR2(1) NOT NULL Flag to indicate that a supply document (po or req) has been created.

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

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

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

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

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

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

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

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

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

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

120 DATETIME_ADDED DateTime(26) TIMESTAMP DateTime Added

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

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

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

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

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

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

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

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

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

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

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

132 DEMAND_DATE Date(10) DATE Demand Date

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

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

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

136 IST_DISTRIB_STATUS Character(1) VARCHAR2(1) NOT NULL Intrastat Distribution Status
A=Awaiting Arrival Processing
D=Distributed
I=Ignored
M=Archival Entry
N=Not Distributed
R=Reversal Entry
S=Awaiting Dispatch Processing
U=Undefined

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