OM_DMD_DEL_VW (SQL View)	Index Back
OM Delivery/Demand OM will not consider containers during field change events, and FulfillDemand class prevents updates to any schedules with packed demand (even if there are multiple demand lines). As such, there is no reason to retrieve container info in this view. If this changes, then changes need to be made to make this view behave like the Inventory counterpart IN_DMD_DEL_VW. Date Initials Issue Description 020210 dms 1913661002 Remove IN_DLV_SHUOM_VW from view SQL.

OM_DMD_DEL_VW

(SQL View)

OM Delivery/Demand

OM will not consider containers during field change events, and FulfillDemand class prevents updates to any schedules with packed demand (even if there are multiple demand lines). As such, there is no reason to retrieve container info in this view. If this changes, then changes need to be made to make this view behave like the Inventory counterpart IN_DMD_DEL_VW. Date Initials Issue Description 020210 dms 1913661002 Remove IN_DLV_SHUOM_VW from view SQL.

SELECT T.SETID , D.BUSINESS_UNIT , 'OM' , D.SOURCE_BUS_UNIT , D.ORDER_NO , D.ORDER_INT_LINE_NO , D.SCHED_LINE_NBR , D.INV_ITEM_ID , D.DEMAND_LINE_NO , 'OM' , D.SOURCE_BUS_UNIT , D.ORDER_NO , T.COMMODITY_CD , 'N' , ' ' , ' ' , T.HARMONIZED_CD , M.INV_ITEM_GROUP , %DatePart(D.SCHED_DTTM) , ' ' , %Sql(IN_DEL_FLAGS_CASE, D, DELIVERY_ERROR, 'N', V) , %Sql(IN_DEL_FLAGS_CASE, D, DELIVERY_STATUS, '99', V) , ' ' , ' ' , %Sql(IN_DEL_FLAGS_CASE, D, BILL_ONLY, 'N', V) , M.INVENTORY_ITEM , M.UNIT_MEASURE_STD , %Sql(IN_DEL_FLAGS_CASE, D, FREIGHT_ERROR, 'N', V) , %Sql(IN_DEL_FLAGS_CASE, D, FRT_CHRG_OPEN, 'Y', VO) , %Sql(IN_DEL_FLAGS_CASE, D, FRT_CHRG_OVERRIDE, 'N', VO) , %Sql(IN_DEL_FLAGS_CASE, D, FRT_COMMIT_BILLING, 'N', V) , %Sql(IN_DEL_FLAGS_CASE, D, FRT_RATE_STATUS, '00', V) , %Sql(IN_DEL_FLAGS_CASE, D, MANIFEST_STATUS, '00', V) , D.BUSINESS_UNIT , 0 , 0 , 0 , 0 , 0 , 0 , 0 , D.UNIT_OF_MEASURE , CASE D.IN_FULFILL_STATE WHEN '60' THEN D.UNIT_MEASURE_SHIP WHEN '70' THEN D.UNIT_MEASURE_SHIP ELSE CASE U.INV_UOM_TYPE WHEN 'SHIP' THEN D.UNIT_OF_MEASURE ELSE M.UNIT_MEASURE_STD END END , 'N' , 0 , %Round(%DecMult(D.DELIV_UNIT_WT, D.DELIV_UNIT_WT_CNV), 4) , %Round(%DecMult(D.DELIV_UNIT_VOL, D.DELIV_UNIT_VOL_CNV), 4) , 0 , 0 , 0 , 0 , 0 , 'O' , '1' , '1' , 'N' , 'N' , 'N' , 'N' , ' ' , 'SO' , D.SINGLE_SHIP_FLAG , D.EXPORT , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , %DateNull , ' ' , ' ' , B.SOFT_ALLOC_FLG , I.SOFT_ALLOC_FLG , 1 , 1 , D.DELIV_UNIT_VOL_CNV , D.DELIV_UNIT_WT_CNV , 0 , 0 , 0 , 0 , 0 , D.DELIV_UNIT_VOL , D.DELIV_UNIT_WT , 0 , D.QTY_PER , D.UNIT_OF_MEASURE , CASE D.IN_FULFILL_STATE WHEN '60' THEN D.UNIT_MEASURE_SHIP WHEN '70' THEN D.UNIT_MEASURE_SHIP ELSE CASE U.INV_UOM_TYPE WHEN 'SHIP' THEN D.UNIT_OF_MEASURE ELSE M.UNIT_MEASURE_STD END END , D.DELIV_UOM_SHIP_VOL , D.DELIV_UOM_SHIP_WT , D.DELIV_UOM_WT , D.DELIV_UOM_VOL , 'N' , 'N' , 'N' , 'N' , 'N' , 'N' , 'N' , 'N' , %DatePart(D.SHIP_EARLY_DTTM) , 3 , ' ' , ' ' , 0 , 0 , 0 , 0 , 0 , 0 , 0 , ' ' , ' ' , 0 , 0 , 0 , 0 , 0 , 0 , ' ' , ' ' , ' ' , 1 , %DateNull , ' ' , 0 , 0 , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , %subrec(IN_DMD_DEL_SBR, D) FROM PS_IN_DEMAND D LEFT OUTER JOIN PS_IN_DELIVERY V ON V.BUSINESS_UNIT = D.BUSINESS_UNIT AND V.DELIVERY_ID = D.DELIVERY_ID LEFT OUTER JOIN PS_IN_DELIVERY_ORD VO ON VO.BUSINESS_UNIT = D.BUSINESS_UNIT AND VO.DEMAND_SOURCE = D.DEMAND_SOURCE AND VO.SOURCE_BUS_UNIT = D.SOURCE_BUS_UNIT AND VO.ORDER_NO = D.ORDER_NO AND VO.DELIVERY_ID = D.DELIVERY_ID AND VO.CHARGE_TYPE = 'F' AND VO.FREIGHT_APP = 'OM' AND VO.SEQ_NUM = 0 JOIN PS_INV_ITEMS_EVW T ON T.INV_ITEM_ID = D.INV_ITEM_ID JOIN PS_MASTER_ITEM_TBL M ON M.SETID = T.SETID AND M.INV_ITEM_ID = T.INV_ITEM_ID LEFT OUTER JOIN PS_DF_SETUP_IT_INV I ON I.BUSINESS_UNIT = D.BUSINESS_UNIT AND I.INV_ITEM_ID = D.INV_ITEM_ID JOIN PS_DF_SETUP_INV B ON B.BUSINESS_UNIT = D.BUSINESS_UNIT LEFT OUTER JOIN PS_UOM_TYPE_INV U ON U.SETID = M.SETID AND U.INV_ITEM_ID = D.INV_ITEM_ID AND U.UNIT_OF_MEASURE = D.UNIT_OF_MEASURE AND U.INV_UOM_TYPE = 'SHIP' WHERE D.DEMAND_SOURCE = 'OM' AND D.IN_FULFILL_STATE BETWEEN '10' AND '60' AND D.IN_PROCESS_DATE IS NOT NULL AND D.APPROVED_FLAG = 'Y' AND D.RESERVE_STATUS < '99'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID_INV_ITEM Character(5) VARCHAR2(5) NOT NULL Inv Items SETID

2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: SP_BUIN_NONVW

3 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

4 SOURCE_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Source Bus Unit

5 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

6 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line

7 SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL Schedule Line Number

8 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

9 DEMAND_LINE_NO Number(4,0) SMALLINT NOT NULL Demand Line No

10 SEL_DEMAND_SOURCE Character(2) VARCHAR2(2) NOT NULL Select Demand Source

11 SEL_SOURCE_BU Character(5) VARCHAR2(5) NOT NULL Select Source Business Unit

12 SEL_ORDER_NO Character(10) VARCHAR2(10) NOT NULL Select Order

13 COMMODITY_CD Character(10) VARCHAR2(10) NOT NULL Commodity Code

14 CUST_PICKUP Character(1) VARCHAR2(1) NOT NULL Counter sale customer pickup flag
N=No
Y=Yes

15 DOC_REFNUM Character(20) VARCHAR2(20) NOT NULL Counter sale document reference number

16 FREIGHT_BILL_TYPE Character(2) VARCHAR2(2) NOT NULL Freight Bill Type
OE=Order Entry
SH=Shipping

17 HARMONIZED_CD Character(14) VARCHAR2(14) NOT NULL Harmonized Code

18 INV_ITEM_GROUP Character(15) VARCHAR2(15) NOT NULL Item Group

19 SCHED_SHIP_DATE Date(10) DATE Scheduled Ship Date

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

21 DELIVERY_ERROR Character(1) VARCHAR2(1) NOT NULL Delivery Error
Default Value: N

22 DELIVERY_STATUS Character(2) VARCHAR2(2) NOT NULL Delivery Status
00=Pending for Demand
10=Pending for Quote
20=Open
60=Closed for Shipment
70=Delivery Completed
90=Canceled
99=Unassigned
Default Value: 20

23 DELIVERY_KEY Character(40) VARCHAR2(40) NOT NULL Delivery Key

24 DELIVERY_KEY1 Character(40) VARCHAR2(40) NOT NULL Delivery Key

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

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

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

28 FREIGHT_ERROR Character(1) VARCHAR2(1) NOT NULL Freight Error
Default Value: N

29 FRT_CHRG_OPEN Character(1) VARCHAR2(1) NOT NULL Freight can be modified
Default Value: Y

30 FRT_CHRG_OVERRIDE Character(1) VARCHAR2(1) NOT NULL Freight Charge Override
Default Value: N

31 FRT_COMMIT_BILLING Character(1) VARCHAR2(1) NOT NULL Freight Committed for Billing
Default Value: N

32 FRT_RATE_STATUS Character(2) VARCHAR2(2) NOT NULL Rate Status
00=None
10=Requested
20=Received
Default Value: 00

33 MANIFEST_STATUS Character(2) VARCHAR2(2) NOT NULL Manifest Status
00=None
10=Requested
20=Received
Default Value: 00

34 NEW_BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL New Business Unit

35 DELIV_TOTWK_QTY Number(20,4) DECIMAL(19,4) NOT NULL Delivery Working Quantity

36 DELIV_WORK_QTY Number(16,4) DECIMAL(15,4) NOT NULL Delivery Working Quantity

37 DELIV_WK_QTY_LAST Number(16,4) DECIMAL(15,4) NOT NULL Delivery Working Quantity

38 DELIV_WK_QTY_ORIG Number(16,4) DECIMAL(15,4) NOT NULL Delivery Working Quantity

39 DELIV_WK_QTY_SHIP Number(16,4) DECIMAL(15,4) NOT NULL Delivery Shipped Work Qty

40 DELIV_WKQTY_LSTSHP Number(16,4) DECIMAL(15,4) NOT NULL Delivery Shipped Work Qty

41 DELIV_WKQTY_ORGSHP Number(16,4) DECIMAL(15,4) NOT NULL Delivery Shipped Work Qty

42 DELIV_UOM_QTY Character(3) VARCHAR2(3) NOT NULL Delivery Order Qty UOM

43 DELIV_SHIP_UOM_QTY Character(3) VARCHAR2(3) NOT NULL Delivery Ship Qty UOM

44 USE_STD_UOM_FLAG Character(1) VARCHAR2(1) NOT NULL Use Standard UOM

45 SHIPPING_QTY Number(17,4) DECIMAL(16,4) NOT NULL Shipping Quantity

46 SHIPPING_WEIGHT Signed Number(17,4) DECIMAL(15,4) NOT NULL Shipping Weight

47 SHIPPING_VOLUME Signed Number(17,4) DECIMAL(15,4) NOT NULL Shipping Volume

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

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

50 EXTENDED_NET_PRICE Signed Number(29,4) DECIMAL(27,4) NOT NULL Ext Net Amount

51 EXT_NET_PRC_BASE Signed Number(29,4) DECIMAL(27,4) NOT NULL Extended Net Price (base)

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

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

54 TRFT_SRC_TYPE Character(1) VARCHAR2(1) NOT NULL Alternate Source Type
0=All Sources
1=Inventory Business Unit
2=Distribution Network
3=New Requisition
4=New Purchase Order
5=Existing Requisition
6=Existing Purchase Order
7=Existing Interunit Transfer
8=Existing Production Order
9=New Production Order

55 TRFT_DISPOSITION Character(1) VARCHAR2(1) NOT NULL Supply Source disposition
1=Direct Ship
2=Direct Receipt

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

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

58 DEL_ORD_RESTRICTED Character(1) VARCHAR2(1) NOT NULL Deliveries restricted to order
N=Deliveries Not Restricted
Y=Deliveries Restricted to Order
Default Value: N

59 BACKGROUND_REQD Character(1) VARCHAR2(1) NOT NULL Background Process Required
E=OMBCKEND Req'd
N=No
P=Pricing Req'd
Y=Yes

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

61 ORDER_TYPE_CD Character(3) VARCHAR2(3) NOT NULL Order Type
QUO=Sales Quote
SO=Sales Order

62 SINGLE_SHIP_FLAG Character(1) VARCHAR2(1) NOT NULL Single Ship Flag
N=No
Y=Yes

63 EXPORT Character(1) VARCHAR2(1) NOT NULL Export Analytic Instance
N=No
Y=Yes

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

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

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

67 CUSTOMER_ITEM_NBR Character(18) VARCHAR2(18) NOT NULL Customer Item Number

68 UPC_ID Character(18) VARCHAR2(18) NOT NULL Uniform Product Code ID

69 UPN_ID Character(20) VARCHAR2(20) NOT NULL Universal Product Number

70 EXPORT_LIC_EXPIRE Date(10) DATE Expiration Date

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

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

73 SOFT_ALLOC_FLG Character(1) VARCHAR2(1) NOT NULL Soft Reserve

74 SOFT_ALLOC_FLG2 Character(1) VARCHAR2(1) NOT NULL Soft Reserve

75 CONVERSION_RT_ORD Signed Number(17,8) DECIMAL(15,8) NOT NULL Order to Std UOM

76 CONV_RT_ORD_LAST Signed Number(17,8) DECIMAL(15,8) NOT NULL Order to Std UOM

77 CONV_RT_VOL_LAST Number(16,8) DECIMAL(15,8) NOT NULL Unit volume conversion rate

78 CONV_RT_WT_LAST Number(16,8) DECIMAL(15,8) NOT NULL Unit weight conversion rate

79 NET_UNIT_LAST Signed Number(16,4) DECIMAL(14,4) NOT NULL Net Unit Price

80 NET_UNIT_LAST_BSE Signed Number(16,4) DECIMAL(14,4) NOT NULL Net Unit Price (base)

81 EXT_NETPRCBSE_LAST Signed Number(29,4) DECIMAL(27,4) NOT NULL Extended Net Price (base)

82 EXT_NET_PRICE_LAST Signed Number(29,4) DECIMAL(27,4) NOT NULL Ext Net Price

83 SHIP_QTY_LAST Number(16,4) DECIMAL(15,4) NOT NULL Shipping Quantity

84 SHIP_VOL_LAST Signed Number(17,4) DECIMAL(15,4) NOT NULL Shipping Volume

85 SHIP_WT_LAST Signed Number(17,4) DECIMAL(15,4) NOT NULL Shipping Weight

86 QTY_SCHED_LAST Signed Number(17,4) DECIMAL(15,4) NOT NULL Last Quantity Scheduled

87 QTY_PER_LAST Number(10,4) DECIMAL(9,4) NOT NULL Last qty per value

88 UOM_LAST Character(3) VARCHAR2(3) NOT NULL Previous unit of measure

89 UOM_SHIP_LAST Character(3) VARCHAR2(3) NOT NULL Shipment Unit of Measure

90 UOM_SHIP_VOL_LAST Character(3) VARCHAR2(3) NOT NULL Ship UOM for Volume

91 UOM_SHIP_WT_LAST Character(3) VARCHAR2(3) NOT NULL Ship UOM for Weight

92 UOM_WT_LAST Character(3) VARCHAR2(3) NOT NULL Weight UOM

93 UOM_VOL_LAST Character(3) VARCHAR2(3) NOT NULL Volume UOM

94 ADJ_DELIVERY Character(1) VARCHAR2(1) NOT NULL Adjust Delivery Flag
A=Add
M=Move
N=No Action
R=Remove
Default Value: N

95 ADJ_WTVOL Character(1) VARCHAR2(1) NOT NULL Adjust Weight or Volume
Y/N Table Edit
Default Value: N

96 ADJ_QTY Character(1) VARCHAR2(1) NOT NULL Adjust Quantity
Default Value: N

97 ADJ_VALUE Character(1) VARCHAR2(1) NOT NULL Adjust Delivery Value
Default Value: N

98 SQL_ACTION Character(1) VARCHAR2(1) NOT NULL SQL Action to Take
D=Delete
I=Insert
N=No Action
U=Update
Default Value: N

99 CARRIER_UPD Character(1) VARCHAR2(1) NOT NULL Used to mark that a Carrier ID update is pending.
Default Value: N

100 SHP_TYP_UPD Character(1) VARCHAR2(1) NOT NULL Used to mark that a Ship Type ID update is pending.
Default Value: N

101 SHP_DTTM_UPD Character(1) VARCHAR2(1) NOT NULL Used to mark Scheduled Shipping Date/Time update is pending.
Default Value: N

102 SHIP_EARLY_DATE Date(10) DATE Earliest Ship Date

103 SELECTTYPE Number(1,0) SMALLINT NOT NULL Selection Type

104 SHIP_CNTR_ID Character(20) VARCHAR2(20) NOT NULL Shipping Container ID

105 CHILD_SHIP_CNTR Character(20) VARCHAR2(20) NOT NULL Child Shipping Container ID

106 CNTR_DTL_NET_VOL Signed Number(17,4) DECIMAL(15,4) NOT NULL Shipping Volume

107 CNTR_DTL_NET_WT Signed Number(17,4) DECIMAL(15,4) NOT NULL Shipping Weight

108 CNTR_GROSS_VOLUME Signed Number(17,4) DECIMAL(15,4) NOT NULL Packing Volume

109 CNTR_GROSS_WEIGHT Signed Number(17,4) DECIMAL(15,4) NOT NULL Shipping Weight

110 CNTR_NET_VOLUME Signed Number(17,4) DECIMAL(15,4) NOT NULL Total Volume

111 CNTR_NET_WEIGHT Signed Number(17,4) DECIMAL(15,4) NOT NULL Net Weight

112 EMPTY_WEIGHT Signed Number(17,4) DECIMAL(15,4) NOT NULL Empty Weight

113 CNTR_UOM_VOL Character(3) VARCHAR2(3) NOT NULL Container volume unit of measure

114 CNTR_UOM_WT Character(3) VARCHAR2(3) NOT NULL Weight UOM

115 DELIV_QTY_PACK Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity Packed

116 DELIV_QTY_PACK_BSE Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity Packed Base

117 DELIV_QTY_PACK_SHP Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity Packed Shipped

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

119 DEMAND_RS_ROW Number(7,0) INTEGER NOT NULL Demand rowset row

120 DEMAND_RS_ROW2 Number(7,0) INTEGER NOT NULL Demand rowset row

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

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

123 IN_FRT_USAGE Character(2) VARCHAR2(2) NOT NULL Indicator of internal or external freight
10=Internal
20=External
30=None
40=Both

124 COUNTER Number(10,0) DECIMAL(10) NOT NULL Counter
Default Value: 1

125 RATE_DATE Date(10) DATE Exchange Rate Date

126 RT_TYPE Character(5) VARCHAR2(5) NOT NULL Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.

127 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier

128 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor

129 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
Prompt Table: COUNTRY_TBL

130 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1

131 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2

132 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3

133 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4

134 CITY Character(30) VARCHAR2(30) NOT NULL City

135 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1

136 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2

137 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
AB=House Boat
WW=Trailer

138 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1

139 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2

140 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3

141 COUNTY Character(30) VARCHAR2(30) NOT NULL County

142 STATE Character(6) VARCHAR2(6) NOT NULL State
Prompt Table: STATE_TBL

143 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal

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

145 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit
Y/N Table Edit

146 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

147 IN_PRIOR_STATE Character(2) VARCHAR2(2) NOT NULL Inventory Fulfillment State at the time the demand line was cancelled
10=Pending
20=Unfulfilled
30=Releasable
40=Released
50=Picking Confirmed
60=Shipped
70=Depleted
90=Canceled

148 SCHED_DTTM DateTime(26) TIMESTAMP 08/16/01 JNW (CN#PL900-1.0): Added

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

150 SHIP_EARLY_DTTM DateTime(26) TIMESTAMP Earliest Ship Date/Time

151 SHIP_LATE_DTTM DateTime(26) TIMESTAMP Latest Ship Date/Time

152 LOAD_ID Character(10) VARCHAR2(10) NOT NULL Load ID
Prompt Table: LOAD_INV

153 CARRIER_ID Character(10) VARCHAR2(10) NOT NULL Carrier ID
Prompt Table: CARRIER_ID

154 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code
Prompt Table: SHIP_METHOD

155 FREIGHT_TERMS Character(10) VARCHAR2(10) NOT NULL Freight Terms Code
Prompt Table: FREIGHT_TERMS

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

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

158 KIT_LINE_NBR Number(3,0) SMALLINT NOT NULL Kit Line Number

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

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

161 OPTIONAL_SHIP Character(1) VARCHAR2(1) NOT NULL OK to Ship Without

162 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
Prompt Table: LOCATION_SBU_VW

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

164 SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer

165 SHIP_CUST_NAME1 Character(40) VARCHAR2(40) NOT NULL Ship To Name

166 SHIP_CUST_NAME2 Character(40) VARCHAR2(40) NOT NULL Ship To Name 2

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

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

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

170 QTY_REQUESTED_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Requested Base

171 QTY_PROMISED_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Promised Base

172 QTY_ALLOCATED Signed Number(17,4) DECIMAL(15,4) NOT NULL Allocated quantity

173 QTY_ALLOC_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity allocation

174 QTY_BACKORDER Signed Number(17,4) DECIMAL(15,4) NOT NULL Backorder Qty

175 QTY_BACKORDER_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Backorder Base Qty

176 QTY_PICKED Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Picked

177 QTY_PICK_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Pick Base

178 QTY_PICK_OVRIDE Signed Number(17,4) DECIMAL(15,4) NOT NULL Field used to override the net requested quantity when printing the pick play for non-soft reservation items.

179 QTY_PICK_OVR_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Field used to override the net requested quantity in standard uom when printing the pick play for non-soft reservation items.

180 QTY_PACK_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Base Quantity Packed

181 QTY_SHIPPED Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Shipped

182 QTY_SHIP_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Ship Base

183 QTY_SHIPPED_CONV Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Shipped

184 LAST_QTY_SHIP Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity Last Shipped

185 LAST_QTY_SHIP_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Used to save the last value of quantity shipped from the Shipping Issues Panel in Standard UOM at the DEMAND_PHYS_INV and SHIP_INF_INV level. Default to the quantity picked from the Express Issues Panel or for cases where auto ship equals 'Y'.

186 IN_ZERO_PICKED_FLG Character(1) VARCHAR2(1) NOT NULL Zero Picked

187 BCKORDER_FLAG Character(1) VARCHAR2(1) NOT NULL Backorder Flag
N=No
Y=Yes
Y/N Table Edit
Default Value: N

188 BACKORDER_CREATED Character(1) VARCHAR2(1) NOT NULL Backorder Created Flag
Y/N Table Edit
Default Value: N

189 UNIT_MEASURE_SHIP Character(3) VARCHAR2(3) NOT NULL Shipment Unit of Measure
Prompt Table: INV_SHIP_UOM_VW

190 UNIT_MEASURE_VOL Character(3) VARCHAR2(3) NOT NULL Volume UOM
Prompt Table: UNITS_TBL

191 UNIT_MEASURE_WT Character(3) VARCHAR2(3) NOT NULL Weight UOM
Prompt Table: UNITS_TBL

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

193 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.
Prompt Table: ROUTE_INV_VW

194 ROUTE_STOP_NBR Number(5,0) INTEGER NOT NULL An identifier used to sequence customer addresses/location for a given route.

195 FRT_CHRG_METHOD Character(2) VARCHAR2(2) NOT NULL Freight Charge Method
01=Order Value
02=Weight
03=Volume
04=Order Quantity

196 FRT_RULE_CD Character(10) VARCHAR2(10) NOT NULL Freight Rule Code

197 DELIVERY_ID Character(10) VARCHAR2(10) NOT NULL Delivery ID

198 SHIP_ID Character(10) VARCHAR2(10) NOT NULL Shipping ID
Prompt Table: SHIP_HDR_INV

199 PRO_NUMBER Character(40) VARCHAR2(40) NOT NULL Pro Number

200 TMS_LOAD_STP_NBR Number(5,0) INTEGER NOT NULL Load Stop Number

201 DELIV_UNIT_VOL Number(16,4) DECIMAL(15,4) NOT NULL Delivery Unit Volume

202 DELIV_UNIT_WT Number(16,4) DECIMAL(15,4) NOT NULL Delivery Unit Weight

203 DELIV_UOM_VOL Character(3) VARCHAR2(3) NOT NULL Delivery Volume UOM

204 DELIV_UOM_WT Character(3) VARCHAR2(3) NOT NULL Delivery Weight UOM

205 DELIV_UOM_SHIP_VOL Character(3) VARCHAR2(3) NOT NULL Ship UOM for volume conversion

206 DELIV_UOM_SHIP_WT Character(3) VARCHAR2(3) NOT NULL Ship UOM for weight conversion

207 DELIV_UNIT_VOL_CNV Number(16,8) DECIMAL(15,8) NOT NULL Unit volume conversion rate

208 DELIV_UNIT_WT_CNV Number(16,8) DECIMAL(15,8) NOT NULL Unit weight conversion rate

209 DELIV_USE_UOM_SHIP Character(1) VARCHAR2(1) NOT NULL Use UNIT_MEASURE_SHIP
Y/N Table Edit
Default Value: N

210 PREF_CARRIER_FLAG Character(1) VARCHAR2(1) NOT NULL Preferred Carrier flag
N=No Preferred Carrier
Y=Preferred Carrier
Default Value: N

211 PICK_BATCH_ID Number(10,0) DECIMAL(10) NOT NULL Pick Batch ID

212 PICKLIST_LINE_NO Number(7,0) INTEGER NOT NULL Pick List Sorting Line Number

213 PRIORITY_NBR Number(3,0) SMALLINT NOT NULL Priority

214 DEMAND_DATE Date(10) DATE Demand Date

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID_INV_ITEM	Character(5)	VARCHAR2(5) NOT NULL	Inv Items SETID
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BUIN_NONVW
3	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
4	SOURCE_BUS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Source Bus Unit
5	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
6	ORDER_INT_LINE_NO	Number(5,0)	INTEGER NOT NULL	Order Line
7	SCHED_LINE_NBR	Number(6,0)	INTEGER NOT NULL	Schedule Line Number
8	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
9	DEMAND_LINE_NO	Number(4,0)	SMALLINT NOT NULL	Demand Line No
10	SEL_DEMAND_SOURCE	Character(2)	VARCHAR2(2) NOT NULL	Select Demand Source
11	SEL_SOURCE_BU	Character(5)	VARCHAR2(5) NOT NULL	Select Source Business Unit
12	SEL_ORDER_NO	Character(10)	VARCHAR2(10) NOT NULL	Select Order
13	COMMODITY_CD	Character(10)	VARCHAR2(10) NOT NULL	Commodity Code
14	CUST_PICKUP	Character(1)	VARCHAR2(1) NOT NULL	Counter sale customer pickup flag N=No Y=Yes
15	DOC_REFNUM	Character(20)	VARCHAR2(20) NOT NULL	Counter sale document reference number
16	FREIGHT_BILL_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Freight Bill Type OE=Order Entry SH=Shipping
17	HARMONIZED_CD	Character(14)	VARCHAR2(14) NOT NULL	Harmonized Code
18	INV_ITEM_GROUP	Character(15)	VARCHAR2(15) NOT NULL	Item Group
19	SCHED_SHIP_DATE	Date(10)	DATE	Scheduled Ship Date
20	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.
21	DELIVERY_ERROR	Character(1)	VARCHAR2(1) NOT NULL	Delivery Error Default Value: N
22	DELIVERY_STATUS	Character(2)	VARCHAR2(2) NOT NULL	Delivery Status 00=Pending for Demand 10=Pending for Quote 20=Open 60=Closed for Shipment 70=Delivery Completed 90=Canceled 99=Unassigned Default Value: 20
23	DELIVERY_KEY	Character(40)	VARCHAR2(40) NOT NULL	Delivery Key
24	DELIVERY_KEY1	Character(40)	VARCHAR2(40) NOT NULL	Delivery Key
25	BILL_ONLY	Character(1)	VARCHAR2(1) NOT NULL	Indicates a sales order is to be billed only, and not fulfilled through Inventory. Default Value: N
26	INVENTORY_ITEM	Character(1)	VARCHAR2(1) NOT NULL	Inventory Item N=No Y=Yes
27	UNIT_MEASURE_STD	Character(3)	VARCHAR2(3) NOT NULL	Standard Unit of Measure
28	FREIGHT_ERROR	Character(1)	VARCHAR2(1) NOT NULL	Freight Error Default Value: N
29	FRT_CHRG_OPEN	Character(1)	VARCHAR2(1) NOT NULL	Freight can be modified Default Value: Y
30	FRT_CHRG_OVERRIDE	Character(1)	VARCHAR2(1) NOT NULL	Freight Charge Override Default Value: N
31	FRT_COMMIT_BILLING	Character(1)	VARCHAR2(1) NOT NULL	Freight Committed for Billing Default Value: N
32	FRT_RATE_STATUS	Character(2)	VARCHAR2(2) NOT NULL	Rate Status 00=None 10=Requested 20=Received Default Value: 00
33	MANIFEST_STATUS	Character(2)	VARCHAR2(2) NOT NULL	Manifest Status 00=None 10=Requested 20=Received Default Value: 00
34	NEW_BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	New Business Unit
35	DELIV_TOTWK_QTY	Number(20,4)	DECIMAL(19,4) NOT NULL	Delivery Working Quantity
36	DELIV_WORK_QTY	Number(16,4)	DECIMAL(15,4) NOT NULL	Delivery Working Quantity
37	DELIV_WK_QTY_LAST	Number(16,4)	DECIMAL(15,4) NOT NULL	Delivery Working Quantity
38	DELIV_WK_QTY_ORIG	Number(16,4)	DECIMAL(15,4) NOT NULL	Delivery Working Quantity
39	DELIV_WK_QTY_SHIP	Number(16,4)	DECIMAL(15,4) NOT NULL	Delivery Shipped Work Qty
40	DELIV_WKQTY_LSTSHP	Number(16,4)	DECIMAL(15,4) NOT NULL	Delivery Shipped Work Qty
41	DELIV_WKQTY_ORGSHP	Number(16,4)	DECIMAL(15,4) NOT NULL	Delivery Shipped Work Qty
42	DELIV_UOM_QTY	Character(3)	VARCHAR2(3) NOT NULL	Delivery Order Qty UOM
43	DELIV_SHIP_UOM_QTY	Character(3)	VARCHAR2(3) NOT NULL	Delivery Ship Qty UOM
44	USE_STD_UOM_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Use Standard UOM
45	SHIPPING_QTY	Number(17,4)	DECIMAL(16,4) NOT NULL	Shipping Quantity
46	SHIPPING_WEIGHT	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Shipping Weight
47	SHIPPING_VOLUME	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Shipping Volume
48	NET_UNIT_PRICE	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	Net Unit Price
49	NET_UNIT_PRICE_BSE	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	Net Unit Price (base)
50	EXTENDED_NET_PRICE	Signed Number(29,4)	DECIMAL(27,4) NOT NULL	Ext Net Amount
51	EXT_NET_PRC_BASE	Signed Number(29,4)	DECIMAL(27,4) NOT NULL	Extended Net Price (base)
52	QTY_SCHEDULED	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Quantity Scheduled
53	ORD_SCH_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Schedule Status C=Closed O=Open P=Pending X=Canceled
54	TRFT_SRC_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Alternate Source Type 0=All Sources 1=Inventory Business Unit 2=Distribution Network 3=New Requisition 4=New Purchase Order 5=Existing Requisition 6=Existing Purchase Order 7=Existing Interunit Transfer 8=Existing Production Order 9=New Production Order
55	TRFT_DISPOSITION	Character(1)	VARCHAR2(1) NOT NULL	Supply Source disposition 1=Direct Ship 2=Direct Receipt
56	DROP_SHIP_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Drop Ship N=No Y=Yes
57	CFG_KIT_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Configured Kit
58	DEL_ORD_RESTRICTED	Character(1)	VARCHAR2(1) NOT NULL	Deliveries restricted to order N=Deliveries Not Restricted Y=Deliveries Restricted to Order Default Value: N
59	BACKGROUND_REQD	Character(1)	VARCHAR2(1) NOT NULL	Background Process Required E=OMBCKEND Req'd N=No P=Pricing Req'd Y=Yes
60	SOURCE_CD	Character(6)	VARCHAR2(6) NOT NULL	Source Code
61	ORDER_TYPE_CD	Character(3)	VARCHAR2(3) NOT NULL	Order Type QUO=Sales Quote SO=Sales Order
62	SINGLE_SHIP_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Single Ship Flag N=No Y=Yes
63	EXPORT	Character(1)	VARCHAR2(1) NOT NULL	Export Analytic Instance N=No Y=Yes
64	CUSTOMER_PO	Character(25)	VARCHAR2(25) NOT NULL	Customer PO
65	CUSTOMER_PO_LINE	Character(11)	VARCHAR2(11) NOT NULL	Customer PO Line
66	CUSTOMER_PO_SCHED	Character(11)	VARCHAR2(11) NOT NULL	Customer PO Schedule
67	CUSTOMER_ITEM_NBR	Character(18)	VARCHAR2(18) NOT NULL	Customer Item Number
68	UPC_ID	Character(18)	VARCHAR2(18) NOT NULL	Uniform Product Code ID
69	UPN_ID	Character(20)	VARCHAR2(20) NOT NULL	Universal Product Number
70	EXPORT_LIC_EXPIRE	Date(10)	DATE	Expiration Date
71	EXPORT_LIC_NBR	Character(18)	VARCHAR2(18) NOT NULL	Export License Nbr
72	EXPORT_LIC_TYPE	Character(4)	VARCHAR2(4) NOT NULL	License Type GDST=General SPEC=Specific
73	SOFT_ALLOC_FLG	Character(1)	VARCHAR2(1) NOT NULL	Soft Reserve
74	SOFT_ALLOC_FLG2	Character(1)	VARCHAR2(1) NOT NULL	Soft Reserve
75	CONVERSION_RT_ORD	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Order to Std UOM
76	CONV_RT_ORD_LAST	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Order to Std UOM
77	CONV_RT_VOL_LAST	Number(16,8)	DECIMAL(15,8) NOT NULL	Unit volume conversion rate
78	CONV_RT_WT_LAST	Number(16,8)	DECIMAL(15,8) NOT NULL	Unit weight conversion rate
79	NET_UNIT_LAST	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	Net Unit Price
80	NET_UNIT_LAST_BSE	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	Net Unit Price (base)
81	EXT_NETPRCBSE_LAST	Signed Number(29,4)	DECIMAL(27,4) NOT NULL	Extended Net Price (base)
82	EXT_NET_PRICE_LAST	Signed Number(29,4)	DECIMAL(27,4) NOT NULL	Ext Net Price
83	SHIP_QTY_LAST	Number(16,4)	DECIMAL(15,4) NOT NULL	Shipping Quantity
84	SHIP_VOL_LAST	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Shipping Volume
85	SHIP_WT_LAST	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Shipping Weight
86	QTY_SCHED_LAST	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Last Quantity Scheduled
87	QTY_PER_LAST	Number(10,4)	DECIMAL(9,4) NOT NULL	Last qty per value
88	UOM_LAST	Character(3)	VARCHAR2(3) NOT NULL	Previous unit of measure
89	UOM_SHIP_LAST	Character(3)	VARCHAR2(3) NOT NULL	Shipment Unit of Measure
90	UOM_SHIP_VOL_LAST	Character(3)	VARCHAR2(3) NOT NULL	Ship UOM for Volume
91	UOM_SHIP_WT_LAST	Character(3)	VARCHAR2(3) NOT NULL	Ship UOM for Weight
92	UOM_WT_LAST	Character(3)	VARCHAR2(3) NOT NULL	Weight UOM
93	UOM_VOL_LAST	Character(3)	VARCHAR2(3) NOT NULL	Volume UOM
94	ADJ_DELIVERY	Character(1)	VARCHAR2(1) NOT NULL	Adjust Delivery Flag A=Add M=Move N=No Action R=Remove Default Value: N
95	ADJ_WTVOL	Character(1)	VARCHAR2(1) NOT NULL	Adjust Weight or Volume Y/N Table Edit Default Value: N
96	ADJ_QTY	Character(1)	VARCHAR2(1) NOT NULL	Adjust Quantity Default Value: N
97	ADJ_VALUE	Character(1)	VARCHAR2(1) NOT NULL	Adjust Delivery Value Default Value: N
98	SQL_ACTION	Character(1)	VARCHAR2(1) NOT NULL	SQL Action to Take D=Delete I=Insert N=No Action U=Update Default Value: N
99	CARRIER_UPD	Character(1)	VARCHAR2(1) NOT NULL	Used to mark that a Carrier ID update is pending. Default Value: N
100	SHP_TYP_UPD	Character(1)	VARCHAR2(1) NOT NULL	Used to mark that a Ship Type ID update is pending. Default Value: N
101	SHP_DTTM_UPD	Character(1)	VARCHAR2(1) NOT NULL	Used to mark Scheduled Shipping Date/Time update is pending. Default Value: N
102	SHIP_EARLY_DATE	Date(10)	DATE	Earliest Ship Date
103	SELECTTYPE	Number(1,0)	SMALLINT NOT NULL	Selection Type
104	SHIP_CNTR_ID	Character(20)	VARCHAR2(20) NOT NULL	Shipping Container ID
105	CHILD_SHIP_CNTR	Character(20)	VARCHAR2(20) NOT NULL	Child Shipping Container ID
106	CNTR_DTL_NET_VOL	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Shipping Volume
107	CNTR_DTL_NET_WT	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Shipping Weight
108	CNTR_GROSS_VOLUME	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Packing Volume
109	CNTR_GROSS_WEIGHT	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Shipping Weight
110	CNTR_NET_VOLUME	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Total Volume
111	CNTR_NET_WEIGHT	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Net Weight
112	EMPTY_WEIGHT	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Empty Weight
113	CNTR_UOM_VOL	Character(3)	VARCHAR2(3) NOT NULL	Container volume unit of measure
114	CNTR_UOM_WT	Character(3)	VARCHAR2(3) NOT NULL	Weight UOM
115	DELIV_QTY_PACK	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Quantity Packed
116	DELIV_QTY_PACK_BSE	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Quantity Packed Base
117	DELIV_QTY_PACK_SHP	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Quantity Packed Shipped
118	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
119	DEMAND_RS_ROW	Number(7,0)	INTEGER NOT NULL	Demand rowset row
120	DEMAND_RS_ROW2	Number(7,0)	INTEGER NOT NULL	Demand rowset row
121	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
122	CURRENCY_CD_BASE	Character(3)	VARCHAR2(3) NOT NULL	Business Unit Base Currency
123	IN_FRT_USAGE	Character(2)	VARCHAR2(2) NOT NULL	Indicator of internal or external freight 10=Internal 20=External 30=None 40=Both
124	COUNTER	Number(10,0)	DECIMAL(10) NOT NULL	Counter Default Value: 1
125	RATE_DATE	Date(10)	DATE	Exchange Rate Date
126	RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
127	RATE_MULT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Rate Multiplier
128	RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Divisor
129	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Prompt Table: COUNTRY_TBL
130	ADDRESS1	Character(55)	VARCHAR2(55) NOT NULL	Address 1
131	ADDRESS2	Character(55)	VARCHAR2(55) NOT NULL	Address 2
132	ADDRESS3	Character(55)	VARCHAR2(55) NOT NULL	Address 3
133	ADDRESS4	Character(55)	VARCHAR2(55) NOT NULL	Address 4
134	CITY	Character(30)	VARCHAR2(30) NOT NULL	City
135	NUM1	Character(6)	VARCHAR2(6) NOT NULL	Number 1
136	NUM2	Character(6)	VARCHAR2(6) NOT NULL	Number 2
137	HOUSE_TYPE	Character(2)	VARCHAR2(2) NOT NULL	House Type AB=House Boat WW=Trailer
138	ADDR_FIELD1	Character(2)	VARCHAR2(2) NOT NULL	Address Field 1
139	ADDR_FIELD2	Character(4)	VARCHAR2(4) NOT NULL	Address Field 2
140	ADDR_FIELD3	Character(4)	VARCHAR2(4) NOT NULL	Address Field 3
141	COUNTY	Character(30)	VARCHAR2(30) NOT NULL	County
142	STATE	Character(6)	VARCHAR2(6) NOT NULL	State Prompt Table: STATE_TBL
143	POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Postal
144	GEO_CODE	Character(11)	VARCHAR2(11) NOT NULL	Geo Code
145	IN_CITY_LIMIT	Character(1)	VARCHAR2(1) NOT NULL	In City Limit Y/N Table Edit
146	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
147	IN_PRIOR_STATE	Character(2)	VARCHAR2(2) NOT NULL	Inventory Fulfillment State at the time the demand line was cancelled 10=Pending 20=Unfulfilled 30=Releasable 40=Released 50=Picking Confirmed 60=Shipped 70=Depleted 90=Canceled
148	SCHED_DTTM	DateTime(26)	TIMESTAMP	08/16/01 JNW (CN#PL900-1.0): Added
149	SCHED_ARRV_DTTM	DateTime(26)	TIMESTAMP	Schedule Arrival Dt/Tm
150	SHIP_EARLY_DTTM	DateTime(26)	TIMESTAMP	Earliest Ship Date/Time
151	SHIP_LATE_DTTM	DateTime(26)	TIMESTAMP	Latest Ship Date/Time
152	LOAD_ID	Character(10)	VARCHAR2(10) NOT NULL	Load ID Prompt Table: LOAD_INV
153	CARRIER_ID	Character(10)	VARCHAR2(10) NOT NULL	Carrier ID Prompt Table: CARRIER_ID
154	SHIP_TYPE_ID	Character(10)	VARCHAR2(10) NOT NULL	Ship Via Code Prompt Table: SHIP_METHOD
155	FREIGHT_TERMS	Character(10)	VARCHAR2(10) NOT NULL	Freight Terms Code Prompt Table: FREIGHT_TERMS
156	PRODUCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product ID
157	PARENT_PROD_ID	Character(18)	VARCHAR2(18) NOT NULL	Parent Product Id
158	KIT_LINE_NBR	Number(3,0)	SMALLINT NOT NULL	Kit Line Number
159	QTY_PER	Number(10,4)	DECIMAL(9,4) NOT NULL	Quantity
160	QTY_CODE	Character(3)	VARCHAR2(3) NOT NULL	Per ASY=Assembly ORD=Order
161	OPTIONAL_SHIP	Character(1)	VARCHAR2(1) NOT NULL	OK to Ship Without
162	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code Prompt Table: LOCATION_SBU_VW
163	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.
164	SHIP_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Ship To Customer
165	SHIP_CUST_NAME1	Character(40)	VARCHAR2(40) NOT NULL	Ship To Name
166	SHIP_CUST_NAME2	Character(40)	VARCHAR2(40) NOT NULL	Ship To Name 2
167	ADDRESS_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Address Sequence Number
168	ADDR_OVRD_LEVEL	Character(1)	VARCHAR2(1) NOT NULL	Address Override Level D=Demand Line H=Header L=Line S=Schedule
169	QTY_REQUESTED	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Qty Requested
170	QTY_REQUESTED_BASE	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Qty Requested Base
171	QTY_PROMISED_BASE	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Qty Promised Base
172	QTY_ALLOCATED	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Allocated quantity
173	QTY_ALLOC_BASE	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Quantity allocation
174	QTY_BACKORDER	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Backorder Qty
175	QTY_BACKORDER_BASE	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Backorder Base Qty
176	QTY_PICKED	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Qty Picked
177	QTY_PICK_BASE	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Qty Pick Base
178	QTY_PICK_OVRIDE	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Field used to override the net requested quantity when printing the pick play for non-soft reservation items.
179	QTY_PICK_OVR_BASE	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Field used to override the net requested quantity in standard uom when printing the pick play for non-soft reservation items.
180	QTY_PACK_BASE	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Base Quantity Packed
181	QTY_SHIPPED	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Qty Shipped
182	QTY_SHIP_BASE	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Qty Ship Base
183	QTY_SHIPPED_CONV	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Qty Shipped
184	LAST_QTY_SHIP	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Quantity Last Shipped
185	LAST_QTY_SHIP_BASE	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Used to save the last value of quantity shipped from the Shipping Issues Panel in Standard UOM at the DEMAND_PHYS_INV and SHIP_INF_INV level. Default to the quantity picked from the Express Issues Panel or for cases where auto ship equals 'Y'.
186	IN_ZERO_PICKED_FLG	Character(1)	VARCHAR2(1) NOT NULL	Zero Picked
187	BCKORDER_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Backorder Flag N=No Y=Yes Y/N Table Edit Default Value: N
188	BACKORDER_CREATED	Character(1)	VARCHAR2(1) NOT NULL	Backorder Created Flag Y/N Table Edit Default Value: N
189	UNIT_MEASURE_SHIP	Character(3)	VARCHAR2(3) NOT NULL	Shipment Unit of Measure Prompt Table: INV_SHIP_UOM_VW
190	UNIT_MEASURE_VOL	Character(3)	VARCHAR2(3) NOT NULL	Volume UOM Prompt Table: UNITS_TBL
191	UNIT_MEASURE_WT	Character(3)	VARCHAR2(3) NOT NULL	Weight UOM Prompt Table: UNITS_TBL
192	UNIT_OF_MEASURE	Character(3)	VARCHAR2(3) NOT NULL	Used on an approval rule set. MHR=Muti Hourly PER=Percentage SQF=Square Footage Prompt Table: INV_ORDR_UOM_VW
193	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. Prompt Table: ROUTE_INV_VW
194	ROUTE_STOP_NBR	Number(5,0)	INTEGER NOT NULL	An identifier used to sequence customer addresses/location for a given route.
195	FRT_CHRG_METHOD	Character(2)	VARCHAR2(2) NOT NULL	Freight Charge Method 01=Order Value 02=Weight 03=Volume 04=Order Quantity
196	FRT_RULE_CD	Character(10)	VARCHAR2(10) NOT NULL	Freight Rule Code
197	DELIVERY_ID	Character(10)	VARCHAR2(10) NOT NULL	Delivery ID
198	SHIP_ID	Character(10)	VARCHAR2(10) NOT NULL	Shipping ID Prompt Table: SHIP_HDR_INV
199	PRO_NUMBER	Character(40)	VARCHAR2(40) NOT NULL	Pro Number
200	TMS_LOAD_STP_NBR	Number(5,0)	INTEGER NOT NULL	Load Stop Number
201	DELIV_UNIT_VOL	Number(16,4)	DECIMAL(15,4) NOT NULL	Delivery Unit Volume
202	DELIV_UNIT_WT	Number(16,4)	DECIMAL(15,4) NOT NULL	Delivery Unit Weight
203	DELIV_UOM_VOL	Character(3)	VARCHAR2(3) NOT NULL	Delivery Volume UOM
204	DELIV_UOM_WT	Character(3)	VARCHAR2(3) NOT NULL	Delivery Weight UOM
205	DELIV_UOM_SHIP_VOL	Character(3)	VARCHAR2(3) NOT NULL	Ship UOM for volume conversion
206	DELIV_UOM_SHIP_WT	Character(3)	VARCHAR2(3) NOT NULL	Ship UOM for weight conversion
207	DELIV_UNIT_VOL_CNV	Number(16,8)	DECIMAL(15,8) NOT NULL	Unit volume conversion rate
208	DELIV_UNIT_WT_CNV	Number(16,8)	DECIMAL(15,8) NOT NULL	Unit weight conversion rate
209	DELIV_USE_UOM_SHIP	Character(1)	VARCHAR2(1) NOT NULL	Use UNIT_MEASURE_SHIP Y/N Table Edit Default Value: N
210	PREF_CARRIER_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Preferred Carrier flag N=No Preferred Carrier Y=Preferred Carrier Default Value: N
211	PICK_BATCH_ID	Number(10,0)	DECIMAL(10) NOT NULL	Pick Batch ID
212	PICKLIST_LINE_NO	Number(7,0)	INTEGER NOT NULL	Pick List Sorting Line Number
213	PRIORITY_NBR	Number(3,0)	SMALLINT NOT NULL	Priority
214	DEMAND_DATE	Date(10)	DATE	Demand Date