IN_DMD_DEL_VW (SQL View)	Index Back
Inventory Demand Fulfillment Date Initials Issue Description 020210 dms 1913661001 Remove IN_DLV_SHUOM_VW from view SQL.

IN_DMD_DEL_VW

(SQL View)

Inventory Demand Fulfillment

Date Initials Issue Description 020210 dms 1913661001 Remove IN_DLV_SHUOM_VW from view SQL.

SELECT T.SETID , D.BUSINESS_UNIT , D.DEMAND_SOURCE , D.SOURCE_BUS_UNIT , D.ORDER_NO , D.ORDER_INT_LINE_NO , D.SCHED_LINE_NBR , D.INV_ITEM_ID , D.DEMAND_LINE_NO , D.DEMAND_SOURCE , 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' , ' ' , ' ' , 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 , D.CURRENCY_CD , D.CURRENCY_CD , B.IN_FRT_USAGE , 1 , %CurrentDateIn , BU.CUR_RT_TYPE , 1 , 1 , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , %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 = 'IN' 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 JOIN PS_BUS_UNIT_TBL_IN BU ON BU.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.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
Prompt Table: SP_BU_FS_NONVW

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