IN_SHPSHR_WF_VW

(SQL View)
 Index Back

Shipping Interface Workflow

Shipping Interface Workflow 06/21/04 CWA Data Model Changes - Replaced sched_line_no with sched_line_nbr.

SELECT a.business_unit , a.demand_source , a.source_bus_unit , a.order_no , a.order_int_line_no , a.sched_line_nbr , a.inv_item_id , a.demand_line_no , a.auto_type , a.demand_date , a.request_date , a.cancel_dttm , a.sched_dttm , a.orig_sched_dttm , a.ship_dttm , a.sched_arrv_dttm , a.pick_dttm , a.orig_bu , a.destin_bu , a.date_last_maint , a.last_maint_oprid , a.load_id , a.carrier_id , a.ship_type_id , a.ship_early_dttm , a.ship_late_dttm , a.freight_terms , a.priority_nbr , a.distrib_type , a.pick_batch_id , a.picklist_line_no , A.activity_id , A.RESOURCE_TYPE , A.RESOURCE_CATEGORY , A.RESOURCE_SUB_CAT , A.analysis_type , A.combo_valid_flg , A.speedtype_key , a.req_id , a.req_line_nbr , a.req_sched_nbr , a.req_distrib_nbr , a.product_id , a.parent_prod_id , a.kit_line_nbr , a.charge_flag , a.cntrct_id , A.account , A.altacct , a.ferc_cd , a.interunit_id , a.interunit_line , a.interunit_flg , a.interunit_stat , a.inv_item_alias , a.price_markup_pct , a.location , a.cust_id , a.cust_name , a.ship_to_cust_id , a.ship_cust_name1 , a.ship_cust_name2 , a.tax_exempt_flg , a.exp_return_date , a.orig_oprid , a.transfer_cost , a.packaging_cd , a.currency_cd , a.qty_requested , a.qty_requested_base , a.qty_allocated , a.qty_alloc_base , a.qty_picked , a.qty_shipped , a.qty_shipped_conv , a.qty_pick_base , a.qty_ship_base , a.qty_backorder , a.qty_backorder_base , a.in_fulfill_state , a.reserve_status , a.confirmed_flag , a.hard_alloc_flag , a.lot_alloc_flg , a.shipped_message , a.qty_verify_msg , a.approved_flag , a.ship_prior_flg , a.bckordr_cncl_flag , a.bckorder_flag , a.custodian , a.charge_code , a.costed_flag , a.partial_qty_flag , a.partial_order_flag , a.frozen_flg , a.om_flg , a.ship_id , a.ship_line_no , A.business_unit_pc , a.unit_measure_wt , a.unit_measure_vol , a.unit_measure_ship , a.unit_of_measure , a.ship_uom_conv_flag , a.storage_area , a.stor_level_1 , a.stor_level_2 , a.stor_level_3 , a.stor_level_4 , a.transfer_yield , c.process_instance , c.prcsname , a.pssh_nonown_flag , a.interunit_insert , a.deplete_inv_flg , a.dt_timestamp , a.config_code , a.bill_of_lading , a.business_unit_bi , a.direct_invoicing , a.pro_number , a.edi_dt_time , a.backorder_created , a.business_unit_po , a.rtv_id , a.rtv_ln_nbr , a.rtv_distrib_num , a.price_po , a.hold_flag , a.hold_cd , a.carton_printed , a.shipping_printed , a.ist_distrib_status , a.ship_short_wf_done , a.route_cd , a.route_stop_nbr , a.pick_release_id , a.reserved_dttm , a.depleted_dttm , a.currency_cd_dest , a.tax_cd_vat , a.transfer_cost_dest , a.vat_applicability , a.vat_txn_type_cd , a.budget_dt , a.export , a.replacement_flg , a.ist_return_flg_iut , a.ist_txn_flg , a.orig_inv_item_id , a.orig_uom , a.allow_sub_item_flg , a.frt_chrg_override , a.frt_chrg_method , a.frt_rule_cd , a.ship_id_est , a.net_unit_price , a.allow_overpick_flg , a.max_pick_tolerance , A.SINGLE_SHIP_FLAG , A.EXT_REF_NBR , A.EXT_REF_LN_NBR , A.PUB_PROCESS_INST , A.TRANSFER_CALC_TYPE FROM PS_IN_DEMAND a , PS_IN_DEMAND_LOCK C WHERE %Join(COMMON_KEYS, IN_DEMAND A, IN_DEMAND_LOCK C) AND a.ship_short_wf_done = 'N' AND (((a.qty_allocated = 0) AND (a.qty_shipped <= (a.qty_requested - a.qty_backorder)) AND a.qty_backorder <> 0) OR ((a.qty_allocated > 0) AND (a.qty_shipped < a.qty_allocated))) AND a.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

Prompt Table: SP_BUIN_NONVW

2 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
3 SOURCE_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Source Bus Unit

Prompt Table: SP_BU_FS_NONVW

4 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
5 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line
6 SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL Schedule Line Number
7 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
8 DEMAND_LINE_NO Number(4,0) SMALLINT NOT NULL Demand Line No

Default Value: 1

9 AUTO_TYPE Character(3) VARCHAR2(3) NOT NULL Number Type
10 DEMAND_DATE Date(10) DATE Demand Date
11 REQUEST_DATE Date(10) DATE Requested
12 CANCEL_DTTM DateTime(26) TIMESTAMP Dttm demand line was canceled
13 SCHED_DTTM DateTime(26) TIMESTAMP 08/16/01 JNW (CN#PL900-1.0): Added
14 ORIG_SCHED_DTTM DateTime(26) TIMESTAMP Original Schedule Date/Time
15 SHIP_DTTM DateTime(26) TIMESTAMP Ship Date/Time
16 SCHED_ARRV_DTTM DateTime(26) TIMESTAMP Schedule Arrival Dt/Tm
17 PICK_DTTM DateTime(26) TIMESTAMP Picked Date/Time
18 ORIG_BU Character(5) VARCHAR2(5) NOT NULL Original Business Unit
19 DESTIN_BU Character(5) VARCHAR2(5) NOT NULL Destination Unit
20 DATE_LAST_MAINT Date(10) DATE Date Last Maintained
21 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID
22 LOAD_ID Character(10) VARCHAR2(10) NOT NULL Load ID
23 CARRIER_ID Character(10) VARCHAR2(10) NOT NULL Carrier ID
24 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code
25 SHIP_EARLY_DTTM DateTime(26) TIMESTAMP Earliest Ship Date/Time
26 SHIP_LATE_DTTM DateTime(26) TIMESTAMP Latest Ship Date/Time
27 FREIGHT_TERMS Character(10) VARCHAR2(10) NOT NULL Freight Terms Code
28 PRIORITY_NBR Number(3,0) SMALLINT NOT NULL Priority
29 DISTRIB_TYPE Character(10) VARCHAR2(10) NOT NULL Distrib. Type
30 PICK_BATCH_ID Number(10,0) DECIMAL(10) NOT NULL Pick Batch ID
31 PICKLIST_LINE_NO Number(7,0) INTEGER NOT NULL Pick List Sorting Line Number
32 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
33 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Source Type
34 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Category
35 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Subcategory
36 ANALYSIS_TYPE Character(3) VARCHAR2(3) NOT NULL Analysis Type

Default Value: INSTALLATION_PC.AN_TYPE_IN

37 COMBO_VALID_FLG Character(1) VARCHAR2(1) NOT NULL ChartField Combinatn Valid Flg
?=Validation in Progress
V=Valid ChartField Combination
X=Invalid ChartField Combo
38 SPEEDTYPE_KEY Character(10) VARCHAR2(10) NOT NULL SpeedType Key
39 REQ_ID Character(10) VARCHAR2(10) NOT NULL Requisition ID
40 REQ_LINE_NBR Number(5,0) INTEGER NOT NULL Requisition Line Number
41 REQ_SCHED_NBR Number(3,0) SMALLINT NOT NULL Requisition Schedule Number
42 REQ_DISTRIB_NBR Number(5,0) INTEGER NOT NULL Requisition Distrib Number
43 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
44 PARENT_PROD_ID Character(18) VARCHAR2(18) NOT NULL Parent Product Id
45 KIT_LINE_NBR Number(3,0) SMALLINT NOT NULL Kit Line Number
46 CHARGE_FLAG Character(1) VARCHAR2(1) NOT NULL Charged Out

Default Value: N

47 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID
48 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account

Prompt Table: %EDIT_ACCOUNT

49 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account

Prompt Table: %EDIT_ALTACCT

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

Y/N Table Edit

Default Value: N

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

Default Value: O

55 INV_ITEM_ALIAS Character(18) VARCHAR2(18) NOT NULL Item Alias
56 PRICE_MARKUP_PCT Signed Number(16,2) DECIMAL(14,2) NOT NULL Price Markup %
57 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
58 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.
59 CUST_NAME Character(40) VARCHAR2(40) NOT NULL Name
60 SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer
61 SHIP_CUST_NAME1 Character(40) VARCHAR2(40) NOT NULL Ship To Name
62 SHIP_CUST_NAME2 Character(40) VARCHAR2(40) NOT NULL Ship To Name 2
63 TAX_EXEMPT_FLG Character(1) VARCHAR2(1) NOT NULL Tax Exempt Flag

Y/N Table Edit

64 EXP_RETURN_DATE Date(10) DATE Return Date
65 ORIG_OPRID Character(30) VARCHAR2(30) NOT NULL User ID
66 TRANSFER_COST Signed Number(16,4) DECIMAL(14,4) NOT NULL Transfer Price
67 PACKAGING_CD Character(4) VARCHAR2(4) NOT NULL Packaging Code
68 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
69 QTY_REQUESTED Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Requested
70 QTY_REQUESTED_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Requested Base
71 QTY_ALLOCATED Signed Number(17,4) DECIMAL(15,4) NOT NULL Allocated quantity
72 QTY_ALLOC_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity allocation
73 QTY_PICKED Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Picked
74 QTY_SHIPPED Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Shipped
75 QTY_SHIPPED_CONV Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Shipped
76 QTY_PICK_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Pick Base
77 QTY_SHIP_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Ship Base
78 QTY_BACKORDER Signed Number(17,4) DECIMAL(15,4) NOT NULL Backorder Qty
79 QTY_BACKORDER_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Backorder Base Qty
80 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
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
83 HARD_ALLOC_FLAG Character(1) VARCHAR2(1) NOT NULL Hard Allocate
84 LOT_ALLOC_FLG Character(1) VARCHAR2(1) NOT NULL Allow Lot Allocation

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: N

89 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

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

Y/N Table Edit

Default Value: N

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

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

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

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

Y/N Table Edit

Default Value: N

98 SHIP_ID Character(10) VARCHAR2(10) NOT NULL Shipping ID
99 SHIP_LINE_NO Number(10,2) DECIMAL(9,2) NOT NULL Ship Line No
100 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit
101 UNIT_MEASURE_WT Character(3) VARCHAR2(3) NOT NULL Weight UOM
102 UNIT_MEASURE_VOL Character(3) VARCHAR2(3) NOT NULL Volume UOM
103 UNIT_MEASURE_SHIP Character(3) VARCHAR2(3) NOT NULL Shipment Unit of Measure
104 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
105 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

106 STORAGE_AREA Character(5) VARCHAR2(5) NOT NULL Storage Area
107 STOR_LEVEL_1 Character(4) VARCHAR2(4) NOT NULL Storage Level 1
108 STOR_LEVEL_2 Character(4) VARCHAR2(4) NOT NULL Storage Level 2
109 STOR_LEVEL_3 Character(4) VARCHAR2(4) NOT NULL Storage Level 3
110 STOR_LEVEL_4 Character(4) VARCHAR2(4) NOT NULL Storage Level 4
111 TRANSFER_YIELD Number(5,1) DECIMAL(4,1) NOT NULL Transfer Yield
112 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
113 PRCSNAME Character(12) VARCHAR2(12) NOT NULL Process Name
114 PSSH_NONOWN_FLAG Character(1) VARCHAR2(1) NOT NULL Non Own Flag

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: N

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

Default Value: Y

117 DT_TIMESTAMP DateTime(26) TIMESTAMP Date Timestamp
118 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator
119 BILL_OF_LADING Character(30) VARCHAR2(30) NOT NULL Specifies a bill of lading number associated with a Receivables item.
120 BUSINESS_UNIT_BI Character(5) VARCHAR2(5) NOT NULL Billing Business Unit
121 DIRECT_INVOICING Character(1) VARCHAR2(1) NOT NULL Direct Invoicing

Y/N Table Edit

Default Value: N

122 PRO_NUMBER Character(40) VARCHAR2(40) NOT NULL Pro Number
123 EDI_DT_TIME DateTime(26) TIMESTAMP EDI DATE TIME STAMP
124 BACKORDER_CREATED Character(1) VARCHAR2(1) NOT NULL Backorder Created Flag

Y/N Table Edit

Default Value: N

125 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
126 RTV_ID Character(10) VARCHAR2(10) NOT NULL Return To Vendor ID
127 RTV_LN_NBR Number(5,0) INTEGER NOT NULL Return To Vendor Line
128 RTV_DISTRIB_NUM Number(5,0) INTEGER NOT NULL RTV Distribution Number
129 PRICE_PO Signed Number(17,5) DECIMAL(15,5) NOT NULL Purchase Order Price
130 HOLD_FLAG Character(1) VARCHAR2(1) NOT NULL Hold
N=Hold
Y=Hold

Y/N Table Edit

Default Value: N

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

Prompt Table: HOLD_CD

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

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: N

134 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

135 SHIP_SHORT_WF_DONE Character(1) VARCHAR2(1) NOT NULL Ship Short WF Notification
136 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.
137 ROUTE_STOP_NBR Number(5,0) INTEGER NOT NULL An identifier used to sequence customer addresses/location for a given route.
138 PICK_RELEASE_ID Number(10,0) DECIMAL(10) NOT NULL Pick Release ID
139 RESERVED_DTTM DateTime(26) TIMESTAMP Reserved Date/Time
140 DEPLETED_DTTM DateTime(26) TIMESTAMP Dttm Demand Line was Depleted
141 CURRENCY_CD_DEST Character(3) VARCHAR2(3) NOT NULL Currency Code Dest
142 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.
143 TRANSFER_COST_DEST Signed Number(16,4) DECIMAL(14,4) NOT NULL Transfer Price Dest
144 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
145 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.
146 BUDGET_DT Date(10) DATE Budget Date
147 EXPORT Character(1) VARCHAR2(1) NOT NULL Export Analytic Instance
N=No
Y=Yes

Y/N Table Edit

Default Value: N

148 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

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

Y/N Table Edit

Default Value: N

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

Default Value: N

151 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.
152 ORIG_UOM Character(3) VARCHAR2(3) NOT NULL Original Unit of Measure
153 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

154 FRT_CHRG_OVERRIDE Character(1) VARCHAR2(1) NOT NULL Freight Charge Override
155 FRT_CHRG_METHOD Character(2) VARCHAR2(2) NOT NULL Freight Charge Method
01=Order Value
02=Weight
03=Volume
04=Order Quantity
156 FRT_RULE_CD Character(10) VARCHAR2(10) NOT NULL Freight Rule Code
157 SHIP_ID_EST Character(10) VARCHAR2(10) NOT NULL Estimated Ship ID
158 NET_UNIT_PRICE Signed Number(16,4) DECIMAL(14,4) NOT NULL Net Unit Price
159 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

160 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.
161 SINGLE_SHIP_FLAG Character(1) VARCHAR2(1) NOT NULL Single Ship Flag
N=No
Y=Yes
162 EXT_REF_NBR Number(10,0) DECIMAL(10) NOT NULL External Reference Number
163 EXT_REF_LN_NBR Number(5,0) INTEGER NOT NULL External Reference Line Number
164 PUB_PROCESS_INST Number(10,0) DECIMAL(10) NOT NULL Process Instance
165 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