ORD_SHIPMENT_VW

(SQL View)
 Index Back

Shipping Interface View

Date Init. Issue # Description 06/26/01 JJM F-FSELK-11 Project Gemini chartfield changes 05/25/04 twh F-KNANN-V59N4 Replace demand table references with IN_DEMAND and remove address and accounting fields

SELECT SOURCE_BUS_UNIT , ORDER_NO , ORDER_INT_LINE_NO , SCHED_LINE_NBR , INV_ITEM_ID , DEMAND_LINE_NO , DEMAND_SOURCE , BUSINESS_UNIT , AUTO_TYPE , DEMAND_DATE , REQUEST_DATE , %DatePart(CANCEL_DTTM) , %DatePart(SCHED_DTTM) , %TimePart(SCHED_DTTM) , %DatePart(ORIG_SCHED_DTTM) , %TimePart(ORIG_SCHED_DTTM) , %DatePart(SHIP_DTTM) , %TimePart(SHIP_DTTM) , SCHED_ARRV_DTTM , %DatePart(PICK_DTTM) , PICK_CONFIRM_DTTM , ORIG_BU , DESTIN_BU , DATE_LAST_MAINT , LAST_MAINT_OPRID , LOAD_ID , CARRIER_ID , SHIP_TYPE_ID , %DatePart(SHIP_EARLY_DTTM) , %TimePart(SHIP_EARLY_DTTM) , %DatePart(SHIP_LATE_DTTM) , %TimePart(SHIP_LATE_DTTM) , FREIGHT_TERMS , PRIORITY_NBR , DISTRIB_TYPE , PICK_BATCH_ID , PICKLIST_LINE_NO , ' ' , 0 , 0 , REQ_DISTRIB_NBR , PRODUCT_ID , PARENT_PROD_ID , KIT_LINE_NBR , CHARGE_FLAG , CNTRCT_ID , DESTIN_GL_BU , FERC_CD , INTERUNIT_ID , INTERUNIT_LINE , INTERUNIT_FLG , INTERUNIT_STAT , INV_ITEM_ALIAS , PRICE_MARKUP_PCT , LOCATION , CUST_ID , CUST_NAME , SHIP_TO_CUST_ID , SHIP_CUST_NAME1 , SHIP_CUST_NAME2 , ADDRESS_SEQ_NUM , TAX_EXEMPT_FLG , EXP_RETURN_DATE , ORIG_OPRID , TRANSFER_COST , PACKAGING_CD , CURRENCY_CD , QTY_REQUESTED , QTY_REQUESTED_BASE , QTY_ALLOCATED , QTY_ALLOC_BASE , QTY_PICKED , QTY_SHIPPED , QTY_SHIPPED_CONV , QTY_PICK_BASE , QTY_SHIP_BASE , QTY_BACKORDER , QTY_BACKORDER_BASE , ' ' , FULFILL_FLAG , RESERVE_STATUS , CONFIRMED_FLAG , HARD_ALLOC_FLAG , LOT_ALLOC_FLG , ' ' , SHIPPED_MESSAGE , QTY_VERIFY_MSG , APPROVED_FLAG , SHIP_PRIOR_FLG , BCKORDR_CNCL_FLAG , BCKORDER_FLAG , CUSTODIAN , CHARGE_CODE , COSTED_FLAG , PARTIAL_QTY_FLAG , PARTIAL_ORDER_FLAG , ' ' , ' ' , FROZEN_FLG , OM_FLG , SHIP_ID , SHIP_LINE_NO , UNIT_MEASURE_WT , UNIT_MEASURE_VOL , UNIT_MEASURE_SHIP , UNIT_OF_MEASURE , SHIP_UOM_CONV_FLAG , STORAGE_AREA , STOR_LEVEL_1 , STOR_LEVEL_2 , STOR_LEVEL_3 , STOR_LEVEL_4 , TRANSFER_YIELD , 0 , ' ' , ' ' , PSSH_NONOWN_FLAG , INTERUNIT_INSERT , DEPLETE_INV_FLG , DT_TIMESTAMP , CONFIG_CODE , BILL_OF_LADING , BUSINESS_UNIT_BI , DIRECT_INVOICING , PRO_NUMBER , EDI_DT_TIME , BACKORDER_CREATED , ' ' , RTV_ID , RTV_LN_NBR , RTV_DISTRIB_NUM , PRICE_PO , HOLD_FLAG , HOLD_CD , CARTON_PRINTED , SHIPPING_PRINTED , IST_DISTRIB_STATUS , SHIP_SHORT_WF_DONE , CURRENCY_CD_DEST , TAX_CD_VAT , TRANSFER_COST_DEST , VAT_TXN_TYPE_CD , VAT_APPLICABILITY , ROUTE_CD , ROUTE_STOP_NBR , PICK_RELEASE_ID , %DatePart(RESERVED_DTTM) , %DatePart(DEPLETED_DTTM) , BUDGET_DT , EXPORT , REPLACEMENT_FLG , IST_RETURN_FLG_IUT , IST_TXN_FLG , ORIG_INV_ITEM_ID , ORIG_UOM , ALLOW_SUB_ITEM_FLG , FRT_CHRG_OVERRIDE , FRT_CHRG_METHOD , FRT_RULE_CD , DELIVERY_ID , NET_UNIT_PRICE , ALLOW_OVERPICK_FLG , MAX_PICK_TOLERANCE , PUB_PROCESS_INST , RECV_SHIP_SEQ_NBR , REASON_CD , TRANSFER_CALC_TYPE , FORM_DISTRIB_STAT , TMS_EXT_REF_ID , TMS_EXT_REF_LN_NBR , TMS_PROCESS_FLG , TMS_LOAD_STP_NBR , UPDATE_RESTRCT_LVL , SHIP_PROCESS_TYP FROM PS_IN_DEMAND WHERE DEMAND_SOURCE = 'OM' AND IN_FULFILL_STATE IN ('60', '70')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 ORDER_NO Character(10) VARCHAR2(10) NOT NULL Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
3 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line
4 SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL Schedule Line Number
5 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

Prompt Table: BU_ITM_INV_VW2

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

Default Value: 1

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

Default Value: OM

8 SHIP_FROM_BU Character(5) VARCHAR2(5) NOT NULL Ship from INV BU
9 AUTO_TYPE Character(3) VARCHAR2(3) NOT NULL Number Type
10 DEMAND_DATE Date(10) DATE Demand Date

Default Value: %date

11 REQUEST_DATE Date(10) DATE Requested
12 CANCEL_DATE Date(10) DATE Cancel Date
13 SCHED_DATE Date(10) DATE Schedule Date
14 SCHED_TIME Time(15) TIMESTAMP Schedule Time
15 ORIG_SCHED_DATE Date(10) DATE Orig Sched Date
16 ORIG_SCHED_TIME Time(15) TIMESTAMP Original Schedule Time
17 SHIP_DATE Date(10) DATE Item Shipping Date
18 SHIP_TIME Time(15) TIMESTAMP Ship Time
19 SCHED_ARRV_DTTM DateTime(26) TIMESTAMP Schedule Arrival Dt/Tm
20 PICK_DATE Date(10) DATE Picked Date
21 PICK_CONFIRM_DTTM DateTime(26) TIMESTAMP Pick Confirm Date/Time
22 ORIG_BU Character(5) VARCHAR2(5) NOT NULL Original Business Unit
23 DESTIN_BU Character(5) VARCHAR2(5) NOT NULL Destination Unit
24 DATE_LAST_MAINT Date(10) DATE Date Last Maintained

Default Value: %date

25 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID
26 LOAD_ID Character(10) VARCHAR2(10) NOT NULL Load ID

Prompt Table: LOAD_INV

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

Prompt Table: CARRIER_ID

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

Prompt Table: SHIP_METHOD

29 SHIP_EARLY_DATE Date(10) DATE Earliest Ship Date
30 SHIP_EARLY_TIME Time(15) TIMESTAMP Earliest Ship Time
31 SHIP_LATE_DATE Date(10) DATE Latest Ship Date
32 SHIP_LATE_TIME Time(15) TIMESTAMP Latest Ship Time
33 FREIGHT_TERMS Character(10) VARCHAR2(10) NOT NULL Freight Terms Code

Prompt Table: FREIGHT_TERMS

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

Default Value: 999

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

Prompt Table: CM_DISTR_TYPE

36 PICK_BATCH_ID Number(10,0) DECIMAL(10) NOT NULL Pick Batch ID
37 PICKLIST_LINE_NO Number(7,0) INTEGER NOT NULL Pick List Sorting Line Number
38 REQ_ID Character(10) VARCHAR2(10) NOT NULL Requisition ID
39 REQ_LINE_NBR Number(5,0) INTEGER NOT NULL Requisition Line Number
40 REQ_SCHED_NBR Number(3,0) SMALLINT NOT NULL Requisition Schedule Number
41 REQ_DISTRIB_NBR Number(5,0) INTEGER NOT NULL Requisition Distrib Number
42 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
43 PARENT_PROD_ID Character(18) VARCHAR2(18) NOT NULL Parent Product Id
44 KIT_LINE_NBR Number(3,0) SMALLINT NOT NULL Kit Line Number
45 CHARGE_FLAG Character(1) VARCHAR2(1) NOT NULL Charged Out

Y/N Table Edit

Default Value: N

46 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID
47 DESTIN_GL_BU Character(5) VARCHAR2(5) NOT NULL Destination GL Business Unit

Prompt Table: SP_BU_GL_NONVW

48 FERC_CD Character(10) VARCHAR2(10) NOT NULL FERC Code

Prompt Table: FERC_CD_TBL

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

Y/N Table Edit

Default Value: N

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

Default Value: O

53 INV_ITEM_ALIAS Character(18) VARCHAR2(18) NOT NULL Item Alias
54 PRICE_MARKUP_PCT Signed Number(16,2) DECIMAL(14,2) NOT NULL Price Markup %
55 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

Prompt Table: LOCATION_SBU_VW

56 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.
57 CUST_NAME Character(40) VARCHAR2(40) NOT NULL Name
58 SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer
59 SHIP_CUST_NAME1 Character(40) VARCHAR2(40) NOT NULL Ship To Name
60 SHIP_CUST_NAME2 Character(40) VARCHAR2(40) NOT NULL Ship To Name 2
61 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number
62 TAX_EXEMPT_FLG Character(1) VARCHAR2(1) NOT NULL Tax Exempt Flag

Y/N Table Edit

Default Value: N

63 EXP_RETURN_DATE Date(10) DATE Return Date
64 ORIG_OPRID Character(30) VARCHAR2(30) NOT NULL User ID
65 TRANSFER_COST Signed Number(16,4) DECIMAL(14,4) NOT NULL Transfer Price
66 PACKAGING_CD Character(4) VARCHAR2(4) NOT NULL Packaging Code

Prompt Table: PACKAGNG_CD_INV

67 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
68 QTY_REQUESTED Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Requested
69 QTY_REQUESTED_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Requested Base
70 QTY_ALLOCATED Signed Number(17,4) DECIMAL(15,4) NOT NULL Allocated quantity
71 QTY_ALLOC_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity allocation
72 QTY_PICKED Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Picked
73 QTY_SHIPPED Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Shipped
74 QTY_SHIPPED_CONV Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Shipped
75 QTY_PICK_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Pick Base
76 QTY_SHIP_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Ship Base
77 QTY_BACKORDER Signed Number(17,4) DECIMAL(15,4) NOT NULL Backorder Qty
78 QTY_BACKORDER_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Backorder Base Qty
79 CANCEL_FLAG Character(1) VARCHAR2(1) NOT NULL Cancel PO
B=Both
N=No
Y=Yes

Y/N Table Edit

Default Value: N

80 FULFILL_FLAG Character(1) VARCHAR2(1) NOT NULL OK to Pick

Y/N Table Edit

Default Value: N

81 RESERVE_STATUS Character(2) VARCHAR2(2) NOT NULL Reservation Status
10=Pending
11=Unreserved
12=Shortage, Rules Not Met
15=Reserved, Rules Not Met
21=Shortage, Line Rule Met
22=Reserved, Line Rule Met
31=Shortage, All Rules Met
32=Reserved, All Rules Met
40=Reserve Run
99=Invalid
82 CONFIRMED_FLAG Character(1) VARCHAR2(1) NOT NULL Confirm

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: N

85 SHIPPED_FLAG Character(1) VARCHAR2(1) NOT NULL Shipped
B=Both
N=No
Y=Yes

Y/N Table Edit

Default Value: Y

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

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: N

90 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

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

Y/N Table Edit

Default Value: N

92 CUSTODIAN Character(30) VARCHAR2(30) NOT NULL Custodian
93 CHARGE_CODE Character(20) VARCHAR2(20) NOT NULL Charge Code
94 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

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: N

97 NET_CHANGE_FLG Character(1) VARCHAR2(1) NOT NULL Production Planning Net Change

Y/N Table Edit

Default Value: N

98 NET_CHANGE_EP Character(1) VARCHAR2(1) NOT NULL Enterprise Planning Net Change
99 FROZEN_FLG Character(1) VARCHAR2(1) NOT NULL Frozen Flag
B=Both
N=No
Y=Yes

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: N

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

Prompt Table: SHIP_HDR_INV

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

Prompt Table: UNITS_TBL

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

Prompt Table: UNITS_TBL

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

Prompt Table: INV_SHIP_UOM_VW

106 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

107 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

108 STORAGE_AREA Character(5) VARCHAR2(5) NOT NULL Storage Area
109 STOR_LEVEL_1 Character(4) VARCHAR2(4) NOT NULL Storage Level 1
110 STOR_LEVEL_2 Character(4) VARCHAR2(4) NOT NULL Storage Level 2
111 STOR_LEVEL_3 Character(4) VARCHAR2(4) NOT NULL Storage Level 3
112 STOR_LEVEL_4 Character(4) VARCHAR2(4) NOT NULL Storage Level 4
113 TRANSFER_YIELD Number(5,1) DECIMAL(4,1) NOT NULL Transfer Yield
114 POST_SHIP_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Cancel Instance
115 PSSH_RUN_STATUS Character(1) VARCHAR2(1) NOT NULL Cancel Status
1=Not Processed
2=In Process
3=Process Complete

Default Value: 1

116 PSSH_COMPLETE Character(1) VARCHAR2(1) NOT NULL Post Ship Complete

Y/N Table Edit

Default Value: Y

117 PSSH_NONOWN_FLAG Character(1) VARCHAR2(1) NOT NULL Non Own Flag

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: N

120 DT_TIMESTAMP DateTime(26) TIMESTAMP Date Timestamp
121 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator
122 BILL_OF_LADING Character(30) VARCHAR2(30) NOT NULL Specifies a bill of lading number associated with a Receivables item.
123 BUSINESS_UNIT_BI Character(5) VARCHAR2(5) NOT NULL Billing Business Unit
124 DIRECT_INVOICING Character(1) VARCHAR2(1) NOT NULL Direct Invoicing
125 PRO_NUMBER Character(40) VARCHAR2(40) NOT NULL Pro Number
126 EDI_DT_TIME DateTime(26) TIMESTAMP EDI DATE TIME STAMP
127 BACKORDER_CREATED Character(1) VARCHAR2(1) NOT NULL Backorder Created Flag
128 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
129 RTV_ID Character(10) VARCHAR2(10) NOT NULL Return To Vendor ID
130 RTV_LN_NBR Number(5,0) INTEGER NOT NULL Return To Vendor Line
131 RTV_DISTRIB_NUM Number(5,0) INTEGER NOT NULL RTV Distribution Number
132 PRICE_PO Signed Number(17,5) DECIMAL(15,5) NOT NULL Purchase Order Price
133 HOLD_FLAG Character(1) VARCHAR2(1) NOT NULL Hold
N=Hold
Y=Hold

Y/N Table Edit

Default Value: N

134 HOLD_CD Character(6) VARCHAR2(6) NOT NULL Hold Code

Prompt Table: HOLD_CD

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

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: N

137 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
138 SHIP_SHORT_WF_DONE Character(1) VARCHAR2(1) NOT NULL Ship Short WF Notification
139 CURRENCY_CD_DEST Character(3) VARCHAR2(3) NOT NULL Currency Code Dest
140 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.
141 TRANSFER_COST_DEST Signed Number(16,4) DECIMAL(14,4) NOT NULL Transfer Price Dest
142 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.
143 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
144 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

145 ROUTE_STOP_NBR Number(5,0) INTEGER NOT NULL An identifier used to sequence customer addresses/location for a given route.
146 PICK_RELEASE_ID Number(10,0) DECIMAL(10) NOT NULL Pick Release ID
147 RESERVED_DATE Date(10) DATE Date on which a demand line was soft reserved.
148 DEPLETED_DATE Date(10) DATE Date on which a shipped demand line was depleted from on-hand inventory quantity balances.
149 BUDGET_DT Date(10) DATE Budget Date
150 EXPORT Character(1) VARCHAR2(1) NOT NULL Export Analytic Instance
N=No
Y=Yes
151 REPLACEMENT_FLG Character(2) VARCHAR2(2) NOT NULL Replacement Flag
NA=Not Applicable
RN=Replace Goods Not Returned
RR=Replacement of Returned Goods
152 IST_RETURN_FLG_IUT Character(1) VARCHAR2(1) NOT NULL Intrastat InterUnit Returns
153 IST_TXN_FLG Character(1) VARCHAR2(1) NOT NULL Intrastat Transaction Flag
N=No
Y=Yes
154 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.
155 ORIG_UOM Character(3) VARCHAR2(3) NOT NULL Original Unit of Measure
156 ALLOW_SUB_ITEM_FLG Character(1) VARCHAR2(1) NOT NULL Used to indicate whether item substitutions are allowed on the order schedule.
157 FRT_CHRG_OVERRIDE Character(1) VARCHAR2(1) NOT NULL Freight Charge Override
158 FRT_CHRG_METHOD Character(2) VARCHAR2(2) NOT NULL Freight Charge Method
01=Order Value
02=Weight
03=Volume
04=Order Quantity
159 FRT_RULE_CD Character(10) VARCHAR2(10) NOT NULL Freight Rule Code
160 DELIVERY_ID Character(10) VARCHAR2(10) NOT NULL Delivery ID
161 NET_UNIT_PRICE Signed Number(16,4) DECIMAL(14,4) NOT NULL Net Unit Price
162 ALLOW_OVERPICK_FLG Character(1) VARCHAR2(1) NOT NULL Used to indicate whether or not overpicking is allowed for a customer or business unit.
163 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.
164 PUB_PROCESS_INST Number(10,0) DECIMAL(10) NOT NULL Process Instance
165 RECV_SHIP_SEQ_NBR Number(3,0) SMALLINT NOT NULL Receiver Shipping Sequence
166 REASON_CD Character(10) VARCHAR2(10) NOT NULL Reason Code
167 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

168 FORM_DISTRIB_STAT Character(1) VARCHAR2(1) NOT NULL Used for Sales Tax Forms tracking
D=Distributed
I=Ignore
N=Not Distributed
U=Undefined

Default Value: U

169 TMS_EXT_REF_ID Character(10) VARCHAR2(10) NOT NULL TMS Reference ID
170 TMS_EXT_REF_LN_NBR Number(7,0) INTEGER NOT NULL TMS Line Number
171 TMS_PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL TMS Process Flag

Default Value: N

172 TMS_LOAD_STP_NBR Number(5,0) INTEGER NOT NULL Load Stop Number
173 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.
174 SHIP_PROCESS_TYP 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.
0=Front End Shipping
1=Background Shipping
2=On-Line Shipping