IN_FL_DM4_TAO

(SQL Table)
Index Back

Demand temp

Dedicated temp table containing demand inf_inv, demand inv, ship inf_inv data. Used to hold demand lines for the current processing group.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
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

Prompt Table: BU_ITM_INV_VW2

9 DEMAND_LINE_NO Number(4,0) SMALLINT NOT NULL Demand Line No
10 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
11 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
12 EIP_CTL_ID Character(25) VARCHAR2(25) NOT NULL Enterprise Components EIP (enterprise integration point) control field
13 GRP_SEQ_NBR Number(10,0) DECIMAL(10) NOT NULL Sequence used to uniquely identify a row in the Fulfillment Group stage table.
14 DTL_SEQ_NBR Number(10,0) DECIMAL(10) NOT NULL Sequence used to uniquely identify a row in the Fulfillment Details stage table.
15 PASS_THROUGH_LEVEL Character(2) VARCHAR2(2) NOT NULL Provides the ability to pass good transactions through the system while holding up transactions that need additional review. When processing, the Pass-through Level must be less than or equal to Processing Level and Commit Level. If the process recieves a Pass-through Level greater than the specified Commit Level or Processing Level, the Commit Group and/or Processing Group will be expanded to include all data at the Pass-through Level.
10=Request
20=Order
30=Line
16 PROCESSING_GROUP Number(10,0) DECIMAL(10) NOT NULL A group of data to be processed which may be smaller than the group of data identified by the run request. When processing, if the Pass-through Level is greater than the specified Processing Level, the Processing Group should be expanded to include all data at the Pass-through Level.
17 COMMIT_GROUP Number(10,0) DECIMAL(10) NOT NULL A group of data to be committed to the database as one unit of work that may be smaller than the processing group. Commit Group will always be contained within a Processing Group. When processing, if Pass-through Level is greater than the specified Commit Level, the Commit Group will be expanded to include all data at the Pass-through Level.
18 DEMAND_DATE Date(10) DATE Demand Date
19 REQUEST_DATE Date(10) DATE Requested
20 CANCEL_DATE Date(10) DATE Cancel Date
21 SCHED_DTTM DateTime(26) TIMESTAMP 08/16/01 JNW (CN#PL900-1.0): Added
22 ORIG_SCHED_DTTM DateTime(26) TIMESTAMP Original Schedule Date/Time
23 SHIP_DTTM DateTime(26) TIMESTAMP Ship Date/Time
24 SCHED_ARRV_DTTM DateTime(26) TIMESTAMP Schedule Arrival Dt/Tm
25 PICK_DATE Date(10) DATE Picked Date
26 PICK_CONFIRM_DTTM DateTime(26) TIMESTAMP Pick Confirm Date/Time
27 ORIG_BU Character(5) VARCHAR2(5) NOT NULL Original Business Unit
28 DESTIN_BU Character(5) VARCHAR2(5) NOT NULL Destination Unit
29 DATE_LAST_MAINT Date(10) DATE Date Last Maintained
30 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID
31 LOAD_ID Character(10) VARCHAR2(10) NOT NULL Load ID

Prompt Table: LOAD_INV

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

Prompt Table: CARRIER_ID

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

Prompt Table: SHIP_METHOD

34 SHIP_EARLY_DTTM DateTime(26) TIMESTAMP Earliest Ship Date/Time
35 SHIP_LATE_DTTM DateTime(26) TIMESTAMP Latest Ship Date/Time
36 FREIGHT_TERMS Character(10) VARCHAR2(10) NOT NULL Freight Terms Code

Prompt Table: FREIGHT_TERMS

37 PRIORITY_NBR Number(3,0) SMALLINT NOT NULL Priority
38 DISTRIB_TYPE Character(10) VARCHAR2(10) NOT NULL Distrib. Type

Prompt Table: CM_DISTR_TYPE

39 PICK_BATCH_ID Number(10,0) DECIMAL(10) NOT NULL Pick Batch ID
40 PICKLIST_LINE_NO Number(7,0) INTEGER NOT NULL Pick List Sorting Line Number
41 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
42 PARENT_PROD_ID Character(18) VARCHAR2(18) NOT NULL Parent Product Id
43 KIT_LINE_NBR Number(3,0) SMALLINT NOT NULL Kit Line Number
44 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID
45 FERC_CD Character(10) VARCHAR2(10) NOT NULL FERC Code

Prompt Table: FERC_CD_TBL

46 INTERUNIT_ID Character(10) VARCHAR2(10) NOT NULL InterUnit Order ID
47 INTERUNIT_LINE Number(5,0) INTEGER NOT NULL InterUnit Order Line
48 INTERUNIT_FLG Character(1) VARCHAR2(1) NOT NULL InterUnit
N=No
Y=Yes

Y/N Table Edit

Default Value: N

49 INTERUNIT_STAT Character(1) VARCHAR2(1) NOT NULL InterUnit Status
C=Cancelled
I=In-Transit
O=Open
P=Picked
R=Received

Default Value: O

50 PRICE_MARKUP_PCT Signed Number(16,2) DECIMAL(14,2) NOT NULL Price Markup %
51 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

Prompt Table: LOCATION_SBU_VW

52 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.
53 CUST_NAME Character(40) VARCHAR2(40) NOT NULL Name
54 SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer
55 SHIP_CUST_NAME1 Character(40) VARCHAR2(40) NOT NULL Ship To Name
56 SHIP_CUST_NAME2 Character(40) VARCHAR2(40) NOT NULL Ship To Name 2
57 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number
58 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

Prompt Table: COUNTRY_TBL

59 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
60 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
61 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
62 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
63 CITY Character(30) VARCHAR2(30) NOT NULL City
64 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
65 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2
66 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
AB=House Boat
WW=Trailer
67 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1
68 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
69 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3
70 COUNTY Character(30) VARCHAR2(30) NOT NULL County
71 STATE Character(6) VARCHAR2(6) NOT NULL State

Prompt Table: %EDIT_STATE

72 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
73 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
74 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

Y/N Table Edit

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

Y/N Table Edit

76 TRANSFER_COST Signed Number(16,4) DECIMAL(14,4) NOT NULL Transfer Price
77 PACKAGING_CD Character(4) VARCHAR2(4) NOT NULL Packaging Code

Prompt Table: PACKAGNG_CD_INV

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

Prompt Table: CURRENCY_CD_TBL

79 QTY_REQUESTED Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Requested
80 QTY_REQUESTED_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Requested Base
81 QTY_ALLOCATED Signed Number(17,4) DECIMAL(15,4) NOT NULL Allocated quantity
82 QTY_ALLOC_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity allocation
83 QTY_PICKED Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Picked
84 QTY_SHIPPED Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Shipped
85 QTY_SHIPPED_CONV Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Shipped
86 QTY_PICK_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Pick Base
87 QTY_SHIP_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Ship Base
88 LAST_QTY_SHIP Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity Last Shipped
89 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'.
90 QTY_BACKORDER Signed Number(17,4) DECIMAL(15,4) NOT NULL Backorder Qty
91 QTY_BACKORDER_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Backorder Base Qty
92 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.
93 FULFILL_FLAG Character(1) VARCHAR2(1) NOT NULL OK to Pick

Y/N Table Edit

Default Value: N

94 RESERVED_FLAG Character(1) VARCHAR2(1) NOT NULL Reserved Flag
B=Both
N=No
Y=Yes

Y/N Table Edit

Default Value: N

95 PICKLIST_PRINTED Character(1) VARCHAR2(1) NOT NULL Picklist Printed

Y/N Table Edit

Default Value: N

96 CONFIRMED_FLAG Character(1) VARCHAR2(1) NOT NULL Confirm

Y/N Table Edit

Default Value: N

97 HARD_ALLOC_FLAG Character(1) VARCHAR2(1) NOT NULL Hard Allocate

Y/N Table Edit

Default Value: N

98 LOT_ALLOC_FLG Character(1) VARCHAR2(1) NOT NULL Allow Lot Allocation

Y/N Table Edit

Default Value: N

99 SHIPPED_MESSAGE Character(1) VARCHAR2(1) NOT NULL Shipped Message

Y/N Table Edit

Default Value: N

100 QTY_VERIFY_MSG Character(1) VARCHAR2(1) NOT NULL Verify Qty

Y/N Table Edit

Default Value: N

101 APPROVED_FLAG Character(1) VARCHAR2(1) NOT NULL Approved
B=Both
N=No
Y=Yes

Y/N Table Edit

Default Value: N

102 SHIP_PRIOR_FLG Character(1) VARCHAR2(1) NOT NULL Ship Prior to Sched Date

Y/N Table Edit

Default Value: N

103 BCKORDR_CNCL_FLAG Character(1) VARCHAR2(1) NOT NULL Cancel Backorder
N=Cancel Backorder No
Y=Cancel Backorder Yes

Y/N Table Edit

Default Value: N

104 BCKORDER_FLAG Character(1) VARCHAR2(1) NOT NULL Backorder Flag
N=No
Y=Yes

Y/N Table Edit

Default Value: N

105 CUSTODIAN Character(30) VARCHAR2(30) NOT NULL Custodian
106 CHARGE_CODE Character(20) VARCHAR2(20) NOT NULL Charge Code
107 DISTRIB_FLAG Character(1) VARCHAR2(1) NOT NULL GL Distribution

Y/N Table Edit

Default Value: N

108 COSTED_FLAG Character(1) VARCHAR2(1) NOT NULL Cost status of the transaction. Contains two values: 'N' cost have not been calculated for the transaction and 'Y' cost have been calculated for the transaction
E=Error; Cannot process
N=Transaction is Not Costed
P=Qualified for Purging
X=Transaction Won't be Costed
Y=Transaction is Costed

Default Value: N

109 PARTIAL_QTY_FLAG Character(1) VARCHAR2(1) NOT NULL Partial Qtys Can Ship

Y/N Table Edit

Default Value: N

110 PARTIAL_ORDER_FLAG Character(1) VARCHAR2(1) NOT NULL Partial Orders Can Ship
N=No
Y=Yes

Y/N Table Edit

Default Value: N

111 AUTO_PICK_FLAG Character(1) VARCHAR2(1) NOT NULL Flag Items for Auto-Pick

Y/N Table Edit

112 AUTO_SHIP_FLAG Character(1) VARCHAR2(1) NOT NULL Flag Items for Auto-Ship

Y/N Table Edit

113 FROZEN_FLG Character(1) VARCHAR2(1) NOT NULL Frozen Flag
B=Both
N=No
Y=Yes

Y/N Table Edit

Default Value: N

114 OM_FLG Character(1) VARCHAR2(1) NOT NULL Order Management Extract Flag

Y/N Table Edit

Default Value: N

115 SHIP_ID Character(10) VARCHAR2(10) NOT NULL Shipping ID

Prompt Table: SHIP_HDR_INV

116 SHIP_LINE_NO Number(10,2) DECIMAL(9,2) NOT NULL Ship Line No
117 UNIT_MEASURE_WT Character(3) VARCHAR2(3) NOT NULL Weight UOM

Prompt Table: UNITS_TBL

118 UNIT_MEASURE_VOL Character(3) VARCHAR2(3) NOT NULL Volume UOM

Prompt Table: UNITS_TBL

119 UNIT_MEASURE_SHIP Character(3) VARCHAR2(3) NOT NULL Shipment Unit of Measure

Prompt Table: INV_SHIP_UOM_VW

120 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

121 SHIP_UOM_CONV_FLAG Character(1) VARCHAR2(1) NOT NULL UOM Conversion Flag-Ship Panel
1=Enter Qty in Ordering UOM
2=Enter Qty in Shipping UOM

Default Value: 1

122 STORAGE_AREA Character(5) VARCHAR2(5) NOT NULL Storage Area
123 STOR_LEVEL_1 Character(4) VARCHAR2(4) NOT NULL Storage Level 1
124 STOR_LEVEL_2 Character(4) VARCHAR2(4) NOT NULL Storage Level 2
125 STOR_LEVEL_3 Character(4) VARCHAR2(4) NOT NULL Storage Level 3
126 STOR_LEVEL_4 Character(4) VARCHAR2(4) NOT NULL Storage Level 4
127 TRANSFER_YIELD Number(5,1) DECIMAL(4,1) NOT NULL Transfer Yield
128 PROCESS_STATUS Character(1) VARCHAR2(1) NOT NULL Process Status
A=Active
C=Successfully Completed
E=Completed With Errors
N=Not Yet Processed
P=Processing Now
X=No Success
129 PSSH_NONOWN_FLAG Character(1) VARCHAR2(1) NOT NULL Non Own Flag

Y/N Table Edit

Default Value: N

130 INTERUNIT_INSERT Character(1) VARCHAR2(1) NOT NULL Interunit Insert

Y/N Table Edit

Default Value: N

131 DEPLETE_INV_FLG Character(1) VARCHAR2(1) NOT NULL Deplete Inventory Flag

Default Value: Y

132 DT_TIMESTAMP DateTime(26) TIMESTAMP Date Timestamp
133 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator
134 BILLING_STATUS Character(1) VARCHAR2(1) NOT NULL Billing Status
A=Available
B=In Billing
C=Contract
I=Invoiced
N=Not Avail
P=In Process
S=Staged

Default Value: N

135 BILL_OF_LADING Character(30) VARCHAR2(30) NOT NULL Specifies a bill of lading number associated with a Receivables item.
136 BUSINESS_UNIT_BI Character(5) VARCHAR2(5) NOT NULL Billing Business Unit
137 INVOICE Character(22) VARCHAR2(22) NOT NULL Invoice
138 LINE_SEQ_NUM Number(5,0) INTEGER NOT NULL Sequence
139 DIRECT_INVOICING Character(1) VARCHAR2(1) NOT NULL Direct Invoicing

Y/N Table Edit

Default Value: N

140 PRO_NUMBER Character(40) VARCHAR2(40) NOT NULL Pro Number
141 EDI_DT_TIME DateTime(26) TIMESTAMP EDI DATE TIME STAMP
142 BACKORDER_CREATED Character(1) VARCHAR2(1) NOT NULL Backorder Created Flag

Y/N Table Edit

Default Value: N

143 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
144 PRICE_PO Signed Number(17,5) DECIMAL(15,5) NOT NULL Purchase Order Price
145 HOLD_FLAG Character(1) VARCHAR2(1) NOT NULL Hold
N=Hold
Y=Hold
146 NOTIFY Character(1) VARCHAR2(1) NOT NULL Field to specify the notification method - WorkList only, Email only or Worklist and Email
B=Email and Worklist
N=None
W=WorkList Only
147 BACKORDER_ACTION Character(2) VARCHAR2(2) NOT NULL Backorder Action
01=Cancel Backorder
02=Create Backorder
03=Hold and Notify
04=Release as Shortage
05=Reserve Substitute
148 HOLD_CD Character(6) VARCHAR2(6) NOT NULL Hold Code

Prompt Table: HOLD_CD

149 CARTON_PRINTED Character(1) VARCHAR2(1) NOT NULL Carton Print Flag

Y/N Table Edit

Default Value: N

150 SHIPPING_PRINTED Character(1) VARCHAR2(1) NOT NULL Shipping Container Print Flag

Y/N Table Edit

Default Value: N

151 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

Default Value: I

152 SHIP_SHORT_WF_DONE Character(1) VARCHAR2(1) NOT NULL Ship Short WF Notification

Y/N Table Edit

Default Value: N

153 CURRENCY_CD_DEST Character(3) VARCHAR2(3) NOT NULL Currency Code Dest
154 TAX_CD_VAT Character(8) VARCHAR2(8) NOT NULL Defines the VAT (Value Added Tax) percentage (via link to the Tax Authority) and is used to retrieve VAT accounting ChartFields. The VAT code determines how the VAT amount is calculated on a transaction and how that amount is accounted and reported for.
155 TRANSFER_COST_DEST Signed Number(16,4) DECIMAL(14,4) NOT NULL Transfer Price Dest
156 VAT_TXN_TYPE_CD Character(4) VARCHAR2(4) NOT NULL Specifies a user-defined category of business transaction that is subject to VAT accounting and reporting. The VAT code and the VAT transaction type are used in conjunction with the VAT account type to obtain the ChartFields for accounting entries. Some examples of VAT Transaction Types are Exempt Sales Exempt Purchases Triangulation EU Sales and Domestic Sales.
157 VAT_APPLICABILITY Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not a transaction is eligible for VAT (Value Added Tax) taxation or why it is not eligible.
E=Exempt
N=Not Applicable
O=Outside of Scope of VAT
S=Suspended
T=Taxable
V=VAT Only
X=Exonerated
158 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

159 ROUTE_STOP_NBR Number(5,0) INTEGER NOT NULL An identifier used to sequence customer addresses/location for a given route.
160 PICK_RELEASE_ID Number(10,0) DECIMAL(10) NOT NULL Pick Release ID
161 RESERVED_DATE Date(10) DATE Date on which a demand line was soft reserved.
162 DEPLETED_DATE Date(10) DATE Date on which a shipped demand line was depleted from on-hand inventory quantity balances.
163 BUDGET_DT Date(10) DATE Budget Date
164 EXPORT Character(1) VARCHAR2(1) NOT NULL Export Analytic Instance
N=No
Y=Yes

Y/N Table Edit

Default Value: N

165 REPLACEMENT_FLG Character(2) VARCHAR2(2) NOT NULL Replacement Flag
NA=Not Applicable
RN=Replace Goods Not Returned
RR=Replacement of Returned Goods

Default Value: NA

166 IST_RETURN_FLG_IUT Character(1) VARCHAR2(1) NOT NULL Intrastat InterUnit Returns

Y/N Table Edit

Default Value: N

167 IST_TXN_FLG Character(1) VARCHAR2(1) NOT NULL Intrastat Transaction Flag
N=No
Y=Yes

Default Value: N

168 ORIG_INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Used to identify the original item ordered, in case an item substitution has taken place.
169 ORIG_UOM Character(3) VARCHAR2(3) NOT NULL Original Unit of Measure
170 ALLOW_SUB_ITEM_FLG Character(1) VARCHAR2(1) NOT NULL Used to indicate whether item substitutions are allowed on the order schedule.

Y/N Table Edit

Default Value: N

171 FRT_CHRG_OVERRIDE Character(1) VARCHAR2(1) NOT NULL Freight Charge Override

Y/N Table Edit

Default Value: N

172 FRT_CHRG_METHOD Character(2) VARCHAR2(2) NOT NULL Freight Charge Method
01=Order Value
02=Weight
03=Volume
04=Order Quantity
173 FRT_RULE_CD Character(10) VARCHAR2(10) NOT NULL Freight Rule Code
174 CUSTOMER_PO Character(25) VARCHAR2(25) NOT NULL Customer PO
175 SHIP_ID_EST Character(10) VARCHAR2(10) NOT NULL Estimated Ship ID
176 NET_UNIT_PRICE Signed Number(16,4) DECIMAL(14,4) NOT NULL Net Unit Price
177 CUST_CONTACT Character(40) VARCHAR2(40) NOT NULL Customer Contact
178 ALLOW_OVERPICK_FLG Character(1) VARCHAR2(1) NOT NULL Used to indicate whether or not overpicking is allowed for a customer or business unit.

Y/N Table Edit

Default Value: N

179 MAX_PICK_TOLERANCE Number(6,2) DECIMAL(5,2) NOT NULL Used to indicate the allowable percentage of overshipment for a customer or business unit.
180 QTY_PACK_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Base Quantity Packed
181 SINGLE_SHIP_FLAG Character(1) VARCHAR2(1) NOT NULL Single Ship Flag
N=No
Y=Yes

Y/N Table Edit

Default Value: N

182 EXT_REF_NBR Number(10,0) DECIMAL(10) NOT NULL External Reference Number
183 EXT_REF_LN_NBR Number(5,0) INTEGER NOT NULL External Reference Line Number
184 PUB_PROCESS_INST Number(10,0) DECIMAL(10) NOT NULL Process Instance
185 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
186 EXTENSION Character(6) VARCHAR2(6) NOT NULL Phone Extension
187 COUNTRY_CODE Character(3) VARCHAR2(3) NOT NULL Int'l Prefix
188 REASON_CD Character(10) VARCHAR2(10) NOT NULL Reason Code

Prompt Table: REASON_SHIP_VW

189 TRANSFER_CALC_TYPE Character(1) VARCHAR2(1) NOT NULL Holds information regarding when the transfer price is calculated.
0=Calculate Cost at Depletions
1=Transfer at Zero Cost

Default Value: 0

190 INTFC_ID Number(8,0) INTEGER NOT NULL Interface ID
191 INTFC_LINE_NUM Number(8,0) INTEGER NOT NULL Interface Line Number
192 TMS_EXT_REF_ID Character(10) VARCHAR2(10) NOT NULL TMS Reference ID
193 TMS_EXT_REF_LN_NBR Number(7,0) INTEGER NOT NULL TMS Line Number
194 UPDATE_RESTRCT_LVL Character(1) VARCHAR2(1) NOT NULL This is a translate field that indicates the restriction level and is checked by online processes when the row is being updated by a background process.
195 QTY_FLG Character(1) VARCHAR2(1) NOT NULL Quantity Bid factor Flag

Y/N Table Edit

Default Value: N

196 QTY_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Base Quantity
197 QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity
198 UNIT_MEASURE_TXN Character(3) VARCHAR2(3) NOT NULL Transaction Unit of Measure
199 FROM_STOR_AREA Character(5) VARCHAR2(5) NOT NULL From storage area
200 FROM_STOR_LEV1 Character(4) VARCHAR2(4) NOT NULL From Storage Level 1
201 FROM_STOR_LEV2 Character(4) VARCHAR2(4) NOT NULL From Storage Level 2
202 FROM_STOR_LEV3 Character(4) VARCHAR2(4) NOT NULL From Storage Level 3
203 FROM_STOR_LEV4 Character(4) VARCHAR2(4) NOT NULL From Storage Level 4
204 NEW_ROW Character(1) VARCHAR2(1) NOT NULL New Row of Information
N=DONOT ALLOW
Y=ALLOW
205 HOLD_STATUS Character(1) VARCHAR2(1) NOT NULL Hold From Further Processing

Default Value: Y

206 IN_LINE_BO_RULE Character(10) VARCHAR2(10) NOT NULL Line Backorder Rule
207 IN_LINE_RESV_RULE Character(10) VARCHAR2(10) NOT NULL Line Reservation Rule
208 IN_LN_RESV_BO_RULE Character(10) VARCHAR2(10) NOT NULL Line Reservation - Backorder
209 IN_ORDER_RESV_RULE Character(10) VARCHAR2(10) NOT NULL Order Reservation Rule
210 RESERVED_CRIT_MET Character(1) VARCHAR2(1) NOT NULL Reserved Flag

Default Value: N

211 HOLD_RESERVE_QTY Character(1) VARCHAR2(1) NOT NULL Hold Reservation Quantity
212 DESTIN_GL_BU Character(5) VARCHAR2(5) NOT NULL Destination GL Business Unit
213 ADDR_OVRD_LEVEL Character(1) VARCHAR2(1) NOT NULL Address Override Level
D=Demand Line
H=Header
L=Line
S=Schedule
214 VMI_DESTIN_SHIPTO Character(15) VARCHAR2(15) NOT NULL Ship To Customer
215 OUTER_MOST_CNTR_ID Character(20) VARCHAR2(20) NOT NULL Shipping Container ID
216 SHIP_CNTR_ID Character(20) VARCHAR2(20) NOT NULL Shipping Container ID
217 LAST_PROCESS_INST Number(10,0) DECIMAL(10) NOT NULL Process Instance
218 DELIVERY_ID Character(10) VARCHAR2(10) NOT NULL Delivery ID
219 NEW_LINE Character(1) VARCHAR2(1) NOT NULL New Line
220 RTV_VERIFIED Character(1) VARCHAR2(1) NOT NULL RTV Verified

Y/N Table Edit