WM_RESERVE_VW

(SQL View)
 Index Back

Work Order Reservation demand

View used my Maintenance Management and Work Orders to attempt Inventory item reservations and updates to IN_DEMAND record.

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.in_fulfill_state , a.in_prior_state , a.demand_date , a.request_date , a.cancel_dttm , a.sched_dttm , a.orig_sched_dttm , a.pick_dttm , a.pick_confirm_dttm , a.orig_bu , a.destin_bu , a.transfer_yield , 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.sched_arrv_dttm , a.freight_terms , a.priority_nbr , a.distrib_type , a.pick_batch_id , a.picklist_line_no , a.in_zero_picked_flg , a.release_instance , 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.qty_per , a.qty_code , a.optional_ship , a.dp_kit_parent_qty , a.dp_kit_parent_uom , a.charge_flag , a.cntrct_id , a.ferc_cd , a.interunit_id , a.interunit_line , a.interunit_flg , a.interunit_stat , a.interunit_insert , 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.address_seq_num , a.cntct_seq_ship , a.addr_ovrd_level , 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_promised_base , a.qty_allocated , a.qty_alloc_base , a.qty_backorder , a.qty_backorder_base , a.qty_picked , a.qty_pick_base , a.qty_pick_ovride , a.qty_pick_ovr_base , a.qty_pack_base , a.qty_shipped , a.qty_ship_base , a.qty_shipped_conv , a.last_qty_ship , a.last_qty_ship_base , a.fulfill_flag , a.picklist_printed , a.confirmed_flag , a.shipped_message , a.qty_verify_msg , a.approved_flag , a.ship_prior_flg , a.bckordr_cncl_flag , a.bckorder_flag , a.backorder_created , a.custodian , a.charge_code , a.destin_gl_bu , a.distrib_flag , a.costed_flag , a.partial_qty_flag , a.partial_order_flag , a.in_line_bo_rule , a.in_line_resv_rule , a.in_ln_resv_bo_rule , a.in_order_resv_rule , a.reserve_status , a.reserved_dttm , a.frozen_flg , a.unit_measure_ship , a.unit_measure_vol , a.unit_measure_wt , a.unit_of_measure , a.ship_uom_conv_flag , a.hard_alloc_flag , a.lot_alloc_flg , a.storage_area , a.stor_level_1 , a.stor_level_2 , a.stor_level_3 , a.stor_level_4 , a.last_process_inst , a.dt_timestamp , a.config_code , a.direct_invoicing , a.edi_dt_time , 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.ship_short_wf_done , a.currency_cd_dest , a.tax_cd_vat , a.transfer_cost_dest , a.vat_txn_type_cd , a.vat_applicability , a.route_cd , a.route_stop_nbr , a.pick_release_id , a.budget_dt , a.export , a.replacement_flg , a.ist_return_flg_iut , a.ist_txn_flg , a.ist_distrib_status , 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.pub_process_inst , a.ship_id , a.ship_line_no , a.ship_dttm , a.bill_of_lading , a.pro_number , a.ext_ref_nbr , a.ext_ref_ln_nbr , a.reason_cd , a.transfer_calc_type , a.form_distrib_stat , a.tms_ext_ref_id , a.tms_ext_ref_ln_nbr , a.tms_process_flg , a.tms_load_stp_nbr , a.update_restrct_lvl , a.ship_process_typ , a.om_flg , a.pssh_nonown_flag , a.deplete_inv_flg , a.depleted_dttm , a.business_unit_bi , a.recv_ship_seq_nbr , a.post_ship_instance , a.vmi_destin_shipto , a.vmi_om_bu , a.vmi_order_link , a.priority_ship_from , a.peg_status , a.sup_peg_status , a.claim_id , %subrec(IN_DMD_USER_SBR,A) , a.speedtype_key , a.account , a.altacct , %subrec(CF16_AN_SBR,A) , a.deptid , %subrec(PC_CF1_N_SBR,A) , a.combo_valid_flg , a.in_process_date , a.omb_process_date FROM PS_IN_DEMAND a WHERE a.demand_source = 'WM' AND (a.in_fulfill_state >= '10' AND a.in_fulfill_state < '70')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_FS.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

Default Value: IN

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

Prompt Table: BU_ITM_INV_VW2

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

Default Value: 20

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 DEMAND_DATE Date(10) DATE Demand Date

Default Value: %date

13 REQUEST_DATE Date(10) DATE Requested

Default Value: %date

14 CANCEL_DTTM DateTime(26) TIMESTAMP Dttm demand line was canceled
15 SCHED_DTTM DateTime(26) TIMESTAMP 08/16/01 JNW (CN#PL900-1.0): Added

Default Value: %DATETIME

16 ORIG_SCHED_DTTM DateTime(26) TIMESTAMP Original Schedule Date/Time
17 PICK_DTTM DateTime(26) TIMESTAMP Picked Date/Time
18 PICK_CONFIRM_DTTM DateTime(26) TIMESTAMP Pick Confirm Date/Time
19 ORIG_BU Character(5) VARCHAR2(5) NOT NULL Original Business Unit
20 DESTIN_BU Character(5) VARCHAR2(5) NOT NULL Destination Unit

Prompt Table: SP_BUIN_NONVW

21 TRANSFER_YIELD Number(5,1) DECIMAL(4,1) NOT NULL Transfer Yield
22 DATE_LAST_MAINT Date(10) DATE Date Last Maintained
23 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID
24 LOAD_ID Character(10) VARCHAR2(10) NOT NULL Load ID

Prompt Table: LOAD_INV_OPN_VW

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

Prompt Table: CARRIER_ID

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

Prompt Table: SHIP_METHOD

27 SHIP_EARLY_DTTM DateTime(26) TIMESTAMP Earliest Ship Date/Time
28 SHIP_LATE_DTTM DateTime(26) TIMESTAMP Latest Ship Date/Time
29 SCHED_ARRV_DTTM DateTime(26) TIMESTAMP Schedule Arrival Dt/Tm
30 FREIGHT_TERMS Character(10) VARCHAR2(10) NOT NULL Freight Terms Code

Prompt Table: FREIGHT_TERMS

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

Default Value: 999

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

Prompt Table: CM_DISTR_TYPE
Set Control Field: SETCNTRLVALUE

33 PICK_BATCH_ID Number(10,0) DECIMAL(10) NOT NULL Pick Batch ID
34 PICKLIST_LINE_NO Number(7,0) INTEGER NOT NULL Pick List Sorting Line Number
35 IN_ZERO_PICKED_FLG Character(1) VARCHAR2(1) NOT NULL Zero Picked

Default Value: N

36 RELEASE_INSTANCE Number(10,0) DECIMAL(10) NOT NULL 08/2004 rcw: Order Release Instance
37 REQ_ID Character(10) VARCHAR2(10) NOT NULL Requisition ID
38 REQ_LINE_NBR Number(5,0) INTEGER NOT NULL Requisition Line Number
39 REQ_SCHED_NBR Number(3,0) SMALLINT NOT NULL Requisition Schedule Number
40 REQ_DISTRIB_NBR Number(5,0) INTEGER NOT NULL Requisition Distrib 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 QTY_PER Number(10,4) DECIMAL(9,4) NOT NULL Quantity
45 QTY_CODE Character(3) VARCHAR2(3) NOT NULL Per
ASY=Assembly
ORD=Order
46 OPTIONAL_SHIP Character(1) VARCHAR2(1) NOT NULL OK to Ship Without
47 DP_KIT_PARENT_QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Demand Planning Kit Parent Qty
48 DP_KIT_PARENT_UOM Character(3) VARCHAR2(3) NOT NULL DP Kit Parent Unit of Measure
49 CHARGE_FLAG Character(1) VARCHAR2(1) NOT NULL Charged Out

Y/N Table Edit

Default Value: N

50 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID
51 FERC_CD Character(10) VARCHAR2(10) NOT NULL FERC Code

Prompt Table: FERC_CD_TBL

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

Y/N Table Edit

Default Value: N

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

Default Value: O

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

Default Value: N

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

Prompt Table: %EDITTABLE5

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

Prompt Table: %EDITTABLE

61 CUST_NAME Character(40) VARCHAR2(40) NOT NULL Name
62 SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer

Prompt Table: %EDITTABLE2

63 SHIP_CUST_NAME1 Character(40) VARCHAR2(40) NOT NULL Ship To Name
64 SHIP_CUST_NAME2 Character(40) VARCHAR2(40) NOT NULL Ship To Name 2
65 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number

Prompt Table: %EDITTABLE3

66 CNTCT_SEQ_SHIP Number(5,0) INTEGER NOT NULL Primary Contact - Ship To

Default Value: 0

67 ADDR_OVRD_LEVEL Character(1) VARCHAR2(1) NOT NULL Address Override Level
D=Demand Line
H=Header
L=Line
S=Schedule
68 TAX_EXEMPT_FLG Character(1) VARCHAR2(1) NOT NULL Tax Exempt Flag

Y/N Table Edit

Default Value: Y

69 EXP_RETURN_DATE Date(10) DATE Return Date
70 ORIG_OPRID Character(30) VARCHAR2(30) NOT NULL User ID
71 TRANSFER_COST Signed Number(16,4) DECIMAL(14,4) NOT NULL Transfer Price
72 PACKAGING_CD Character(4) VARCHAR2(4) NOT NULL Packaging Code

Prompt Table: PACKAGNG_CD_INV

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

Prompt Table: CURRENCY_CD_TBL

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

Y/N Table Edit

Default Value: N

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

Default Value: N

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

Default Value: N

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

Default Value: N

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

Default Value: N

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

Default Value: N

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

Y/N Table Edit

Default Value: N

98 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

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

Y/N Table Edit

Default Value: N

100 BACKORDER_CREATED Character(1) VARCHAR2(1) NOT NULL Backorder Created Flag

Default Value: N

101 CUSTODIAN Character(30) VARCHAR2(30) NOT NULL Custodian
102 CHARGE_CODE Character(20) VARCHAR2(20) NOT NULL Charge Code
103 DESTIN_GL_BU Character(5) VARCHAR2(5) NOT NULL Destination GL Business Unit

Prompt Table: SP_BU_GL_NONVW

104 DISTRIB_FLAG Character(1) VARCHAR2(1) NOT NULL GL Distribution

Default Value: N

105 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

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

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: N

108 IN_LINE_BO_RULE Character(10) VARCHAR2(10) NOT NULL Line Backorder Rule

Prompt Table: IN_RULE_B_VW

109 IN_LINE_RESV_RULE Character(10) VARCHAR2(10) NOT NULL Line Reservation Rule

Prompt Table: IN_RULE_R_VW

110 IN_LN_RESV_BO_RULE Character(10) VARCHAR2(10) NOT NULL Line Reservation - Backorder

Prompt Table: IN_RULE_R_VW

111 IN_ORDER_RESV_RULE Character(10) VARCHAR2(10) NOT NULL Order Reservation Rule

Prompt Table: IN_RULE_O_VW

112 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

Default Value: 11

113 RESERVED_DTTM DateTime(26) TIMESTAMP Reserved Date/Time
114 FROZEN_FLG Character(1) VARCHAR2(1) NOT NULL Frozen Flag
B=Both
N=No
Y=Yes

Y/N Table Edit

Default Value: N

115 UNIT_MEASURE_SHIP Character(3) VARCHAR2(3) NOT NULL Shipment Unit of Measure
116 UNIT_MEASURE_VOL Character(3) VARCHAR2(3) NOT NULL Volume UOM
117 UNIT_MEASURE_WT Character(3) VARCHAR2(3) NOT NULL Weight UOM
118 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

119 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

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

Default Value: N

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

Y/N Table Edit

Default Value: N

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 LAST_PROCESS_INST Number(10,0) DECIMAL(10) NOT NULL Process Instance
128 DT_TIMESTAMP DateTime(26) TIMESTAMP Date Timestamp
129 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator

Prompt Table: %EDITTABLE6

130 DIRECT_INVOICING Character(1) VARCHAR2(1) NOT NULL Direct Invoicing

Y/N Table Edit

Default Value: N

131 EDI_DT_TIME DateTime(26) TIMESTAMP EDI DATE TIME STAMP
132 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
133 RTV_ID Character(10) VARCHAR2(10) NOT NULL Return To Vendor ID
134 RTV_LN_NBR Number(5,0) INTEGER NOT NULL Return To Vendor Line
135 RTV_DISTRIB_NUM Number(5,0) INTEGER NOT NULL RTV Distribution Number
136 PRICE_PO Signed Number(17,5) DECIMAL(15,5) NOT NULL Purchase Order Price
137 HOLD_FLAG Character(1) VARCHAR2(1) NOT NULL Hold
N=Hold
Y=Hold

Y/N Table Edit

Default Value: N

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

Prompt Table: HOLD_CD

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

Default Value: N

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

Default Value: N

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

Default Value: N

142 CURRENCY_CD_DEST Character(3) VARCHAR2(3) NOT NULL Currency Code Dest
143 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.
144 TRANSFER_COST_DEST Signed Number(16,4) DECIMAL(14,4) NOT NULL Transfer Price Dest
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 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
147 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

148 ROUTE_STOP_NBR Number(5,0) INTEGER NOT NULL An identifier used to sequence customer addresses/location for a given route.
149 PICK_RELEASE_ID Number(10,0) DECIMAL(10) NOT NULL Pick Release ID
150 BUDGET_DT Date(10) DATE Budget Date
151 EXPORT Character(1) VARCHAR2(1) NOT NULL Export Analytic Instance
N=No
Y=Yes

Y/N Table Edit

Default Value: N

152 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

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

Y/N Table Edit

Default Value: N

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

Default Value: N

155 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

156 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.
157 ORIG_UOM Character(3) VARCHAR2(3) NOT NULL Original Unit of Measure
158 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

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

Default Value: N

160 FRT_CHRG_METHOD Character(2) VARCHAR2(2) NOT NULL Freight Charge Method
01=Order Value
02=Weight
03=Volume
04=Order Quantity
161 FRT_RULE_CD Character(10) VARCHAR2(10) NOT NULL Freight Rule Code
162 SHIP_ID_EST Character(10) VARCHAR2(10) NOT NULL Estimated Ship ID
163 NET_UNIT_PRICE Signed Number(16,4) DECIMAL(14,4) NOT NULL Net Unit Price
164 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

165 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.
166 SINGLE_SHIP_FLAG Character(1) VARCHAR2(1) NOT NULL Single Ship Flag
N=No
Y=Yes

Y/N Table Edit

Default Value: N

167 PUB_PROCESS_INST Number(10,0) DECIMAL(10) NOT NULL Process Instance
168 SHIP_ID Character(10) VARCHAR2(10) NOT NULL Shipping ID
169 SHIP_LINE_NO Number(10,2) DECIMAL(9,2) NOT NULL Ship Line No
170 SHIP_DTTM DateTime(26) TIMESTAMP Ship Date/Time
171 BILL_OF_LADING Character(30) VARCHAR2(30) NOT NULL Specifies a bill of lading number associated with a Receivables item.
172 PRO_NUMBER Character(40) VARCHAR2(40) NOT NULL Pro Number
173 EXT_REF_NBR Number(10,0) DECIMAL(10) NOT NULL External Reference Number
174 EXT_REF_LN_NBR Number(5,0) INTEGER NOT NULL External Reference Line Number
175 REASON_CD Character(10) VARCHAR2(10) NOT NULL Reason Code

Prompt Table: REASON_SHIP_VW

176 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

177 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

178 TMS_EXT_REF_ID Character(10) VARCHAR2(10) NOT NULL TMS Reference ID
179 TMS_EXT_REF_LN_NBR Number(7,0) INTEGER NOT NULL TMS Line Number
180 TMS_PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL TMS Process Flag

Default Value: N

181 TMS_LOAD_STP_NBR Number(5,0) INTEGER NOT NULL Load Stop Number
182 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.
183 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
184 OM_FLG Character(1) VARCHAR2(1) NOT NULL Order Management Extract Flag

Default Value: N

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

Default Value: N

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

Default Value: Y

187 DEPLETED_DTTM DateTime(26) TIMESTAMP Dttm Demand Line was Depleted
188 BUSINESS_UNIT_BI Character(5) VARCHAR2(5) NOT NULL Billing Business Unit
189 RECV_SHIP_SEQ_NBR Number(3,0) SMALLINT NOT NULL Receiver Shipping Sequence
190 POST_SHIP_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Cancel Instance
191 VMI_DESTIN_SHIPTO Character(15) VARCHAR2(15) NOT NULL Ship To Customer
192 VMI_OM_BU Character(5) VARCHAR2(5) NOT NULL OM Business Unit Related to VMI
193 VMI_ORDER_LINK Character(28) VARCHAR2(28) NOT NULL VMI Order Link
194 PRIORITY_SHIP_FROM Character(5) VARCHAR2(5) NOT NULL PRIORITY SHIP FROM BUSINESS UNIT
195 PEG_STATUS Character(2) VARCHAR2(2) NOT NULL 07/21/04 EGS: Created
10=Open
20=Completed
30=Canceled
40=Not Pegged

Default Value: 40

196 SUP_PEG_STATUS Character(2) VARCHAR2(2) NOT NULL 07/21/04 EGS: Created
10=Open
20=Completed
30=Canceled
40=Unpegged

Default Value: 40

197 CLAIM_ID Character(15) VARCHAR2(15) NOT NULL Claim ID
198 LINE_FIELD_C1_A Character(1) VARCHAR2(1) NOT NULL User Defined C1 A
199 LINE_FIELD_C1_B Character(1) VARCHAR2(1) NOT NULL User Defined C1 B
200 LINE_FIELD_C1_C Character(1) VARCHAR2(1) NOT NULL User Defined C1 C
201 LINE_FIELD_C1_D Character(1) VARCHAR2(1) NOT NULL User Defined C1 D
202 LINE_FIELD_C2 Character(2) VARCHAR2(2) NOT NULL User Defined C2
203 LINE_FIELD_C4 Character(4) VARCHAR2(4) NOT NULL User Defined C4
204 LINE_FIELD_C6 Character(6) VARCHAR2(6) NOT NULL User Defined C6
205 LINE_FIELD_C8 Character(8) VARCHAR2(8) NOT NULL User Defined C8
206 LINE_FIELD_C10_A Character(10) VARCHAR2(10) NOT NULL User Defined C10 A
207 LINE_FIELD_C10_B Character(10) VARCHAR2(10) NOT NULL User Defined C10 B
208 LINE_FIELD_C10_C Character(10) VARCHAR2(10) NOT NULL User Defined C10 C
209 LINE_FIELD_C10_D Character(10) VARCHAR2(10) NOT NULL Line Fld C10 D
210 LINE_FIELD_C30_A Character(30) VARCHAR2(30) NOT NULL User Defined C30 A
211 LINE_FIELD_C30_B Character(30) VARCHAR2(30) NOT NULL User Defined C30 B
212 LINE_FIELD_C30_C Character(30) VARCHAR2(30) NOT NULL User Defined C30 C
213 LINE_FIELD_C30_D Character(30) VARCHAR2(30) NOT NULL User Defined C30 D
214 LINE_FIELD_DTTM_A DateTime(26) TIMESTAMP User Defined DTTM A
215 LINE_FIELD_DTTM_B DateTime(26) TIMESTAMP User Defined DTTM B
216 LINE_FIELD_DTTM_C DateTime(26) TIMESTAMP User Defined DTTM C
217 LINE_FIELD_DTTM_D DateTime(26) TIMESTAMP User Defined DTTM D
218 LINE_FIELD_N11_A Signed Number(17,4) DECIMAL(15,4) NOT NULL User Defined N11.4 A
219 LINE_FIELD_N11_B Signed Number(17,4) DECIMAL(15,4) NOT NULL User Defined N11.4 B
220 LINE_FIELD_N11_C Signed Number(17,4) DECIMAL(15,4) NOT NULL User Defined N11.4 C
221 LINE_FIELD_N11_D Signed Number(17,4) DECIMAL(15,4) NOT NULL User Defined N11.4 D
222 LINE_FIELD_N15_A Number(15,0) DECIMAL(15) NOT NULL User Defined N15.0 A
223 LINE_FIELD_N15_B Number(15,0) DECIMAL(15) NOT NULL User Defined N15.0 B
224 LINE_FIELD_N15_C Number(15,0) DECIMAL(15) NOT NULL User Defined N15.0 C
225 LINE_FIELD_N15_D Number(15,0) DECIMAL(15) NOT NULL User Defined N15.0 D
226 SPEEDTYPE_KEY Character(10) VARCHAR2(10) NOT NULL SpeedType Key
227 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account

Prompt Table: %EDIT_ACCOUNT

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

Prompt Table: %EDIT_ALTACCT

229 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField

Prompt Table: OPERUNT_BUGL_VW

230 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product ChartField

Prompt Table: PRODUCT_BUGL_VW

231 FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund Code

Prompt Table: FUND_BUGL_VW

232 CLASS_FLD Character(5) VARCHAR2(5) NOT NULL Class Field

Prompt Table: CLASSCF_BUGL_VW

233 PROGRAM_CODE Character(5) VARCHAR2(5) NOT NULL Program Code ChartField

Prompt Table: PROGRAM_BUGL_VW

234 BUDGET_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference

Prompt Table: BUD_REF_BUGL_VW

235 AFFILIATE Character(5) VARCHAR2(5) NOT NULL Affiliate

Prompt Table: AFFILIATE_VW

236 AFFILIATE_INTRA1 Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate1

Prompt Table: %EDIT_INTRA01

237 AFFILIATE_INTRA2 Character(10) VARCHAR2(10) NOT NULL Operating Unit Affiliate

Prompt Table: %EDIT_INTRA02

238 CHARTFIELD1 Character(10) VARCHAR2(10) NOT NULL Expansion chartfield 1

Prompt Table: CF1_BUGL_VW

239 CHARTFIELD2 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 2

Prompt Table: CF2_BUGL_VW

240 CHARTFIELD3 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 3

Prompt Table: CF3_BUGL_VW

241 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

Prompt Table: DEPTID_BUGL_VW

242 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit

Prompt Table: %EDIT_BU_PC

243 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

Prompt Table: %EDIT_PROJECT

244 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID

Prompt Table: %EDIT_ACTIVITY

245 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Source Type

Prompt Table: PROJ_RESTYPE_FS
Set Control Field: BUSINESS_UNIT_PC

246 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Category

Prompt Table: %EDIT_RES_CAT
Set Control Field: BUSINESS_UNIT_PC

247 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Subcategory

Prompt Table: %EDIT_RES_SUB
Set Control Field: BUSINESS_UNIT_PC

248 ANALYSIS_TYPE Character(3) VARCHAR2(3) NOT NULL Analysis Type

Prompt Table: %EDIT_ANALYSIS
Set Control Field: BUSINESS_UNIT_PC

249 COMBO_VALID_FLG Character(1) VARCHAR2(1) NOT NULL ChartField Combinatn Valid Flg
?=Validation in Progress
V=Valid ChartField Combination
X=Invalid ChartField Combo
250 IN_PROCESS_DATE Date(10) DATE Process Date

Default Value: %date

251 OMB_PROCESS_DATE Date(10) DATE Process Date