OMBCK_AET

(SQL Table)
Index Back

OM Completion AE Cache

OM Completion AE Cache NOTE: No more Fields should be added to this table to to platform constraints. Add additional fields to OMBCK2_AET. Modified 5/20 yb

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
4 BUSINESS_UNIT_TO Character(5) VARCHAR2(5) NOT NULL 04/10/00 SCC (Internet Architecture): Add label BUSINESS_UNIT
5 EOEP_ARB_ID Character(10) VARCHAR2(10) NOT NULL Arbitration Plan
6 OM_FLAG Character(1) VARCHAR2(1) NOT NULL OM Work Flag
7 ORDER_DATE Date(10) DATE Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
8 ORDER_DATE_TO Date(10) DATE Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
9 ORDER_GRP Character(6) VARCHAR2(6) NOT NULL Order Group
10 ORDER_GRP_TO Character(6) VARCHAR2(6) NOT NULL Order Completion rel 9.0
11 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line
12 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
13 ORDER_NO_TO Character(10) VARCHAR2(10) NOT NULL To Order No
14 ORDER_STATUS Character(3) VARCHAR2(3) NOT NULL Order Status
C=Closed
O=Open
P=Pending
X=Canceled
15 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
16 PRICE Signed Number(16,4) DECIMAL(14,4) NOT NULL This is price per unit for calculating the service charge.
17 PRICE_PROGRAM Character(10) VARCHAR2(10) NOT NULL Date Initials Issue Description 111701 dms F-CJORGENS-11 Add EXCL_PRICE_LBL
18 PRICE_PROTECTED Character(1) VARCHAR2(1) NOT NULL Price Protected
19 PROD_ID_SRC Character(1) VARCHAR2(1) NOT NULL Product Source
C=Customer
P=UPC
S=System
U=Universal
20 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
21 REGION_CD Character(10) VARCHAR2(10) NOT NULL Identifies the Sales Region. Populated on the Item Table to identify the Sales Region the Item is applied to.
22 REPRICE_ONLY Character(1) VARCHAR2(1) NOT NULL Reprice Only
23 ROUTE_CD_OUT 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.
24 ROUTE_CARRIER_ID Character(10) VARCHAR2(10) NOT NULL Used to return the Carrier ID assigned to a given transportation route.
25 ROUTE_SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Used to return the Ship Via assigned to a given transportation route.
26 ROUTE_SCHED_DATE Date(10) DATE Date on which a delivery route code can be used to fulfill orders.
27 SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL Schedule Line Number
28 SETID_INV_ITEM Character(5) VARCHAR2(5) NOT NULL Inv Items SETID
29 SETID_LOCATION Character(5) VARCHAR2(5) NOT NULL Location SetID
30 SETID_MST_ITEM Character(5) VARCHAR2(5) NOT NULL Master Item SETID
31 SOLD_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Sold To Customer
32 SOLD_TO_CUST_ID_TO Character(15) VARCHAR2(15) NOT NULL Order Completion Rel 9.0
33 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
34 SEQUENCE_NBR Number(2,0) SMALLINT NOT NULL Sequence Number
35 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
36 UNIT_PRICE Signed Number(17,5) DECIMAL(15,5) NOT NULL Unit Price
37 PRICE_BASE Signed Number(16,4) DECIMAL(14,4) NOT NULL Net Unit Price (base)
38 LAST_ORDER Character(10) VARCHAR2(10) NOT NULL Last Order
39 LIST_PRICE Signed Number(17,4) DECIMAL(15,4) NOT NULL List Price
40 LIST_PRICE_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL List Price (base)
41 SCHED_SHIP_DTTM DateTime(26) TIMESTAMP Schedule Ship Datetime
42 SCHED_SHIP_ORIG DateTime(26) TIMESTAMP Original Sch Ship
43 SCHED_SHIP_TIME Time(15) TIMESTAMP Scheduled Ship Time
44 SCHED_ARRV_DTTM DateTime(26) TIMESTAMP Schedule Arrival Dt/Tm
45 SCHED_ARRV_ORIG DateTime(26) TIMESTAMP Original Sch Arrival
46 SCHED_ARRV_TIME Time(15) TIMESTAMP Scheduled Arrival Time
47 REQ_SHIP_DTTM DateTime(26) TIMESTAMP Requested Ship
48 REQ_ARRIVAL_DTTM DateTime(26) TIMESTAMP Requested Arrival
49 REQ_ARRIVAL_ORIG DateTime(26) TIMESTAMP Original Req Arrival
50 REQ_ARRIVAL_TIME Time(15) TIMESTAMP Requested Arrival Time
51 STOP_FLAG Character(1) VARCHAR2(1) NOT NULL Stop Search Here
52 SEARCH_STOPPED Character(1) VARCHAR2(1) NOT NULL Search Stopped

Y/N Table Edit

53 SOURCE_CD Character(6) VARCHAR2(6) NOT NULL Source Code
54 SOURCE_CD_TO Character(6) VARCHAR2(6) NOT NULL Order Completion rel9.0
55 STD_DISCOUNT Signed Number(7,2) DECIMAL(5,2) NOT NULL Standard Discount
56 BILL_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer
57 SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer
58 ADDRESS_SEQ_SHIP Number(5,0) INTEGER NOT NULL Primary Address - Ship To
59 ADDRESS_SEQ_SOLD Number(5,0) INTEGER NOT NULL Primary Address - Sold To
60 SUBCUST_QUAL1 Character(15) VARCHAR2(15) NOT NULL Specifies a user-defined grouping of customer receivables activity. A subcustomer qualifier provides the ability to record and report receivables activity across multiple business units and/or multiple customers. For example a subcustomer qualifier could represent a sales region or a geographic area. There are two possible subcustomer qualifiers: SUBCUST_QUAL1 and SUBCUST_QUAL2.
61 SUBCUST_QUAL2 Character(15) VARCHAR2(15) NOT NULL Specifies a user-defined grouping of customer receivables activity. A subcustomer qualifier provides the ability to record and report receivables activity across multiple business units and/or multiple customers. For example a subcustomer qualifier could represent a sales region or a geographic area. There are two possible subcustomer qualifiers: SUBCUST_QUAL1 and SUBCUST_QUAL2.
62 LOAD_ID Character(10) VARCHAR2(10) NOT NULL Load ID
63 TRNSPT_LEAD_DAYS Number(3,0) SMALLINT NOT NULL Transportation Lead Tm (days)
64 TRNSPT_LEAD_HOURS Number(2,0) SMALLINT NOT NULL Transportation Lead Tm (Hours)
65 TRNSPT_LEAD_MIN Number(2,0) SMALLINT NOT NULL Transportation Lead Tm (Min)
66 TRFT_RULE_CD Character(10) VARCHAR2(10) NOT NULL Arbitration Rule Code.
67 TRFT_SET_ID Character(10) VARCHAR2(10) NOT NULL Rule Cd
68 SHIP_TIME Time(15) TIMESTAMP Ship Time
69 TIME_TO Time(15) TIMESTAMP To Time
70 TIME_FROM Time(15) TIMESTAMP From Time
71 TIME_HH Number(2,0) SMALLINT NOT NULL Time - Hour
72 TIME_MM Number(2,0) SMALLINT NOT NULL Time - Minute
73 SHIP_DAY Character(1) VARCHAR2(1) NOT NULL Day of Week
1=Sunday
2=Monday
3=Tuesday
4=Wednesday
5=Thursday
6=Friday
7=Saturday
74 WEEKDAY Character(1) VARCHAR2(1) NOT NULL Weekday 1
1=Sunday
2=Monday
3=Tuesday
4=Wednesday
5=Thursday
6=Friday
7=Saturday
75 DTTM_FROM DateTime(26) TIMESTAMP From Date/Time
76 DTTM_TO DateTime(26) TIMESTAMP To Date/Time
77 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
78 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
A=Active
I=Inactive
79 PRC_SCHED_DT_FLAG Character(1) VARCHAR2(1) NOT NULL Scheduled Ship Date
80 PREF_CARRIER_FLAG Character(1) VARCHAR2(1) NOT NULL Preferred Carrier flag
N=No Preferred Carrier
Y=Preferred Carrier
81 FINAL_PRICE Character(1) VARCHAR2(1) NOT NULL Stop Price Calculation Here
N=No
Y=Yes
82 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
83 CP_TEMPLATE_ID Character(10) VARCHAR2(10) NOT NULL Template ID Field
84 HOLD_CD Character(6) VARCHAR2(6) NOT NULL Hold Code
85 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID
86 CNTRCT_LINE_NBR Number(5,0) INTEGER NOT NULL Buying Agreement Line Nbr
87 CARRIER_ID Character(10) VARCHAR2(10) NOT NULL Carrier ID
88 CARRIER_ID_EXP Character(10) VARCHAR2(10) NOT NULL Export Carrier ID
89 CUSTOMER_PO Character(25) VARCHAR2(25) NOT NULL Customer PO
90 CUSTOMER_PO_LINE Character(11) VARCHAR2(11) NOT NULL Customer PO Line
91 CUST_PO_PRICE Signed Number(17,4) DECIMAL(15,4) NOT NULL Customer PO Price
92 CUST_PO_PRC_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Customer PO Price Base
93 CUST_NET_PRICE Signed Number(16,4) DECIMAL(14,4) NOT NULL Customer Net Price
94 CUST_NET_PRC_BASE Signed Number(16,4) DECIMAL(14,4) NOT NULL Customer Net Price Base
95 CUST_OFF_INV_DISC Signed Number(18,5) DECIMAL(16,5) NOT NULL Customer Off-Inv Discount
96 CUST_BILL_BACK_ALL Signed Number(18,5) DECIMAL(16,5) NOT NULL Customer's bill-back allowance
97 CUST_BBACK_ALL_BSE Signed Number(18,5) DECIMAL(16,5) NOT NULL Customer Bill Back Allow Base
98 CUST_OFF_INV_BASE Signed Number(18,5) DECIMAL(16,5) NOT NULL Cust Off Invoice Disc Base
99 CUST_PROMO_NUM Character(10) VARCHAR2(10) NOT NULL Customer Promotion Number
100 CUSTOMER_PO_SCHED Character(11) VARCHAR2(11) NOT NULL Customer PO Schedule
101 FREIGHT_TERMS_EXP Character(10) VARCHAR2(10) NOT NULL Export Freight Terms Code
102 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.
103 ROUTE_STOP_NBR Number(5,0) INTEGER NOT NULL An identifier used to sequence customer addresses/location for a given route.
104 SHIP_PRIORITY_EXP Character(6) VARCHAR2(6) NOT NULL Export Shipping Priority
105 SHIP_TYPE_ID_EXP Character(10) VARCHAR2(10) NOT NULL Export Shipping Method
106 STORE_NUMBER Character(17) VARCHAR2(17) NOT NULL Store Number
107 CR_CARD_NBR Character(44) VARCHAR2(44) NOT NULL "See OM
108 CR_CARD_TYPE Character(3) VARCHAR2(3) NOT NULL "See OM
01=Visa
02=MasterCard
03=Diners Club/Carte Blanche
04=AMEX
05=Discover
06=EnRoute
109 CNTCT_SEQ_NUM Number(5,0) INTEGER NOT NULL Contact Sequence Number
110 FREIGHT_TERMS Character(10) VARCHAR2(10) NOT NULL Freight Terms Code
111 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code
112 SHIP_PRIORITY_ID Character(6) VARCHAR2(6) NOT NULL Shipping Priority Code
113 PYMNT_TERMS_CD Character(5) VARCHAR2(5) NOT NULL Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers.
114 PAYMENT_METHOD Character(3) VARCHAR2(3) NOT NULL Specifies the preferred method of payment by a customer. Examples of payment method are check direct debit and draft. 10/28/2003 edw 655070000 - Removed LTC and CSH xlats.
ACH=ACH
CC=Credit Card
CHK=Check
CSH=Cash
DD=Direct Debit
DR=Draft
EC=Electronic Check
EFT=Electronic Fund Transfer
GE=Giro - EFT
PL=PayPal
WIR=Wire Report
115 DS_NETWORK_CODE Character(6) VARCHAR2(6) NOT NULL Distribution Network Code
116 SHIP_FROM_BU Character(5) VARCHAR2(5) NOT NULL Ship from INV BU
117 UNIT_COST Signed Number(16,4) DECIMAL(14,4) NOT NULL Unit Cost
118 NET_EXTENDED_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Net Extended Amt
119 CUSTOMER_GROUP Character(10) VARCHAR2(10) NOT NULL Customer Group
120 ADDR_OVRD_LEVEL Character(1) VARCHAR2(1) NOT NULL Address Override Level
D=Demand Line
H=Header
L=Line
S=Schedule
121 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number
122 TAX_VENDOR Character(1) VARCHAR2(1) NOT NULL Tax Provider
A=Taxware
N=None
V=Vertex
123 STATE Character(6) VARCHAR2(6) NOT NULL State
124 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
125 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
126 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency
127 DST_ID_DIS Character(10) VARCHAR2(10) NOT NULL Discount Distribution Code
128 DST_PCT_DIS Signed Number(7,2) DECIMAL(5,2) NOT NULL Discount Dist Percentage
129 DST_ID_REV Character(10) VARCHAR2(10) NOT NULL Revenue Dist Code
130 DST_PCT_REV Signed Number(7,2) DECIMAL(5,2) NOT NULL Revenue Dist Percentage
131 DST_ID_SUR Character(10) VARCHAR2(10) NOT NULL Surcharge Distribution Code
132 DST_PCT_SUR Signed Number(7,2) DECIMAL(5,2) NOT NULL Surcharge Dist Percentage
133 DST_RULE_CD Character(10) VARCHAR2(10) NOT NULL Dist Rule Code
134 DISTRIB_SET_ID Character(10) VARCHAR2(10) NOT NULL Distribution Set ID
135 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor
136 RATE_DATE Date(10) DATE Exchange Rate Date
137 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier
138 RT_TYPE Character(5) VARCHAR2(5) NOT NULL Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
139 REPLACEMENT_FLG Character(2) VARCHAR2(2) NOT NULL Replacement Flag
NA=Not Applicable
RN=Replace Goods Not Returned
RR=Replacement of Returned Goods
140 PRODUCT_FAMILY Character(1) VARCHAR2(1) NOT NULL Product Family
141 SUPPORT_TEAM_CD Character(6) VARCHAR2(6) NOT NULL Support Team Code
142 COMMSN_METHOD Character(1) VARCHAR2(1) NOT NULL Commission Method
C=Commission Percent
P=Pro-Rata Percent
143 COUNTRY_SHIP_FROM Character(3) VARCHAR2(3) NOT NULL Specifies the country from which the invoice contents were shipped (for VAT processing only).
144 COUNTRY_SHIP_TO Character(3) VARCHAR2(3) NOT NULL Specifies the country to which the invoice contents were shipped (for VAT processing only).
145 COUNTRY_VAT_BILLFR Character(3) VARCHAR2(3) NOT NULL Specifies the country where an invoice is generated (for VAT processing only).
146 COUNTRY_VAT_BILLTO Character(3) VARCHAR2(3) NOT NULL Specifies the country where an invoice is sent (for VAT processing only).
147 DROP_SHIP_FLAG Character(1) VARCHAR2(1) NOT NULL Drop Ship
N=No
Y=Yes
148 IST_TXN_FLG Character(1) VARCHAR2(1) NOT NULL Intrastat Transaction Flag
N=No
Y=Yes
149 COMMSN_LEVEL Character(1) VARCHAR2(1) NOT NULL Commissions Level
0=No Commissions
1=By Header
2=By Schedule
150 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
151 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit
152 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
153 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
154 VAT_CALC_GROSS_NET Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether VAT calculation should be done on the Gross (G) amount or on the Net (N) amount of sales or purchase transaction. When calculating VAT at net the early payment discount is applied to the goods amount before calculating the VAT. When calculating VAT at gross the VAT is initially calculated based on the gross transaction amount.
G=Calculate at Gross
N=Calculate at Net
155 VAT_DCLRTN_POINT Character(1) VARCHAR2(1) NOT NULL A flag that specifies when VAT information for sales or purchase transaction is recognized for reporting to the appropriate VAT authority. VAT is declared at invoice time, delivery time, accounting date or the time of payment.
A=At Accounting Date
D=At Delivery Time
I=At Invoice Time
P=At Payment Time
156 VAT_DFLT_WRK Character(2) VARCHAR2(2) NOT NULL VAT Defaulting Work
157 VAT_DST_ACCT_TYPE Character(4) VARCHAR2(4) NOT NULL Specifies the accounting code associated with a VAT account type and with a VAT transaction. The accounting code determines when and how the transaction is distributed (posted) to the general ledger.
158 VAT_ENTITY Character(20) VARCHAR2(20) NOT NULL Specifies an organizational entity that is responsible for VAT reporting and that is registered in one or more countries that require VAT reporting. A single VAT entity is linked to one or more General Ledger Business Units depending on the reporting requirements.
159 VAT_EXCPTN_CERTIF Character(20) VARCHAR2(20) NOT NULL Specifies the VAT exception certificate number. This identifier serves as proof of customer's exemption from VAT.
160 VAT_EXCPTN_TYPE Character(1) VARCHAR2(1) NOT NULL A flag that specifies the reason for a VAT exemption for a customer. Suspension (S) and Exoneration (X) are examples of Exception Type.
N=None
S=Suspended
X=Exonerated
161 VAT_RECALC_FLG Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not the VAT discount amount is recalculated at payment time. This field is only used if the VAT Calculation Type (VAT_CAL_GROSS_NET) is gross.
162 VAT_RGSTRN_BUYER Character(20) VARCHAR2(20) NOT NULL Specifies a customers VAT Registration ID for a particular country.
163 VAT_SUSPENSION_FLG Character(1) VARCHAR2(1) NOT NULL Use VAT Suspension
164 VAT_SVC_PERFRM_FLG Character(1) VARCHAR2(1) NOT NULL Where VAT Services Physically Performed Flag
1=Ship To Location
2=Ship From Location
3=Buyer's Location
4=Supplier's Location
165 PHYSICAL_NATURE Character(1) VARCHAR2(1) NOT NULL Physical Nature
G=Goods
S=Services
166 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.
167 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.
168 TAX_CD_VAT_PCT Signed Number(9,4) DECIMAL(7,4) NOT NULL Specifies the tax percentage that corresponds to the VAT code. If more than one VAT authority is linked to a VAT code this will represent an aggregate percentage.
169 TAX_CD Character(8) VARCHAR2(8) NOT NULL Tax Code
170 TAX_CUST_GROUP Character(10) VARCHAR2(10) NOT NULL Tax Customer Group
171 BILL_TYPE_ID Character(3) VARCHAR2(3) NOT NULL Bill Type Identifier
172 EXPORT_ORDER_FLG Character(1) VARCHAR2(1) NOT NULL Flag Orders for Export
173 SINGLE_SHIP_RES Number(3,0) SMALLINT NOT NULL Single Ship Reserve
174 FRT_CHRG_METHOD Character(2) VARCHAR2(2) NOT NULL Freight Charge Method
01=Order Value
02=Weight
03=Volume
04=Order Quantity
175 FRT_RULE_CD Character(10) VARCHAR2(10) NOT NULL Freight Rule Code
176 FREIGHT_BILL_TYPE Character(2) VARCHAR2(2) NOT NULL Freight Bill Type
OE=Order Entry
SH=Shipping
177 PROD_SUBSTITUTE Character(1) VARCHAR2(1) NOT NULL Allow Product Substitutions
N=No
Y=Yes
178 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
179 FIELDNAME1 Character(18) VARCHAR2(18) NOT NULL Field Name 1
180 RECNAME_1 Character(15) VARCHAR2(15) NOT NULL Record 1 Name
181 RECNAME_2 Character(15) VARCHAR2(15) NOT NULL Record 2 Name
182 COMMODITY_CD Character(10) VARCHAR2(10) NOT NULL Commodity Code
183 HARMONIZED_CD Character(14) VARCHAR2(14) NOT NULL Harmonized Code
184 INV_ITEM_GROUP Character(15) VARCHAR2(15) NOT NULL Item Group
185 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
186 TEMP_FLD Character(1) VARCHAR2(1) NOT NULL Temporary Field for App Engine
187 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
188 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
189 X_VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Third Party Supplier
190 X_VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Third Party Supplier Location
191 DELIVERY_ID Character(10) VARCHAR2(10) NOT NULL Delivery ID
192 DELIVERY_ID2 Character(10) VARCHAR2(10) NOT NULL Delivery ID
193 DEL_ORD_RESTRICTED Character(1) VARCHAR2(1) NOT NULL Deliveries restricted to order
N=Deliveries Not Restricted
Y=Deliveries Restricted to Order
194 SHIP_ID Character(10) VARCHAR2(10) NOT NULL Shipping ID
195 ADDTL_ADJ_BILLED Character(1) VARCHAR2(1) NOT NULL Adjustment Amount Billed
196 FRT_BY_QTY Character(1) VARCHAR2(1) NOT NULL Freight by Order Quantity
197 FRT_BY_WT Character(1) VARCHAR2(1) NOT NULL Freight by Shipping Weight
198 FRT_BY_VOL Character(1) VARCHAR2(1) NOT NULL Freight by Shipping Volume
199 UNIT_MEASURE_SHIP Character(3) VARCHAR2(3) NOT NULL Shipment Unit of Measure
200 UNIT_MEASURE_WT Character(3) VARCHAR2(3) NOT NULL Weight UOM
201 UNIT_MEASURE_VOL Character(3) VARCHAR2(3) NOT NULL Volume UOM
202 SHIPPING_QTY Number(17,4) DECIMAL(16,4) NOT NULL Shipping Quantity
203 SHIPPING_WEIGHT Signed Number(17,4) DECIMAL(15,4) NOT NULL Shipping Weight
204 SHIPPING_VOLUME Signed Number(17,4) DECIMAL(15,4) NOT NULL Shipping Volume
205 CONVERSION_RATE Signed Number(17,8) DECIMAL(15,8) NOT NULL Conversion Rate
206 VAT_ROUND_RULE Character(1) VARCHAR2(1) NOT NULL " Rounding rule to be applied to VAT calculations. Options are 'Natural'
D=Round Down
N=Natural Round
U=Round Up
207 CR_CARD_EXPMO Character(2) VARCHAR2(2) NOT NULL Card Expiration Month
01=January
02=February
03=March
04=April
05=May
06=June
07=July
08=August
09=September
10=October
11=November
12=December
208 CR_CARD_EXPYR Character(4) VARCHAR2(4) NOT NULL Card Expiration Year
2011=2011
2012=2012
2013=2013
2014=2014
2015=2015
2016=2016
2017=2017
2018=2018
2019=2019
2020=2020
209 DISTRIB_TYPE Character(10) VARCHAR2(10) NOT NULL Distrib. Type
210 ALLOW_OVERPICK_FLG Character(1) VARCHAR2(1) NOT NULL Used to indicate whether or not overpicking is allowed for a customer or business unit.
211 CATEGORY_CD Character(18) VARCHAR2(18) NOT NULL Category Code
212 SHIPTO_ID Character(10) VARCHAR2(10) NOT NULL Ship To Location
213 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator
214 BLD_CLAUSE_LONG Long Character(1024) VARCHAR2(1024) Concatenate Build Clause
215 CUST_PICKUP Character(1) VARCHAR2(1) NOT NULL Counter sale customer pickup flag
N=No
Y=Yes

Y/N Table Edit

216 STATE_SHIP_FROM Character(6) VARCHAR2(6) NOT NULL Ship From State
217 VAT_DFLT_DONE_FLG Character(1) VARCHAR2(1) NOT NULL VAT Defaulting Done
N=Awaiting Defaulting
X=Do not default
Y=Defaulting Done
218 VAT_DS_DFLT_FLG Character(1) VARCHAR2(1) NOT NULL Process only Direct Ship VAT
N=NO
Y=Y
219 VAT_PO_DELTA_FLG Character(1) VARCHAR2(1) NOT NULL PO Change Options
1=Do not check for changes
2=Change - Reset VAT Defaults
3=Change - No Reset VAT
4=Report - log differences