|
|
OECOMPANY FILE
Order Entry Company
This file stores the companies set up in the Lawson Billing system and used
in the Lawson Billing and Order Entry systems. The company records in this
file are continually accessed for validation throughout the system.
REFERENCED BY
AR08.1 AR10.1 AR115 AR124 AR150 AR20.1
AR21.1 AR21.2 AR21.3 AR24.1 AR30.1 AR30.2
AR30.4 AR31.5 AR42.2 AR42.7 AR501 AR550
AR570 AR575 AR580 BL01.1 BL02.1 BL02.2
BL03.1 BL04.1 BL05.1 BL06.1 BL07.1 BL09.1
BL10.1 BL12.1 BL121 BL13.1 BL14.1 BL140
BL141 BL15.1 BL16.1 BL199 BL200 BL201
BL202 BL203 BL204 BL205 BL206 BL207
BL209 BL210 BL212 BL213 BL214 BL215
BL220 BL230 BL231 BL232 BL240 BL241
BL243 BL244 BL245 BL246 BL247 BL248
BL290 BL291 BL293 BL30.1 BL30.2 BL30.3
BL30.5 BL31.1 BL31.2 BL31.3 BL31.5 BL31.7
BL32.1 BL32.2 BL32.3 BL32.4 BL320 BL33.1
BL330 BL331 BL34.1 BL340 BL341 BL40.1
BL40.2 BL40.3 BL41.1 BL42.1 BL42.2 BL43.1
BL44.1 BL45.1 BL45.2 BL45.3 BL46.1 BL46.2
BL46.3 BL47.1 BL47.2 BL47.3 BL48.1 BL48.2
BL48.3 BL546 BL80.1 BL80.2 BL80.3 BL80.5
BL802 BL81.1 BL85.1 BL85.2 BL85.3 BL90.1
BL902 BL91.1 CB191 OE112 OE130 OE210
OE230 OE251 OE252 OE253 OE254 OE259
OE260 OE270 OE271 OE272 OE280 OE281
OE282 OE283 OE284 OE285 OE286 OE287
OE288 OE289 OE290 OE291 OE292 OE293
OE294 OE310 OE330 OE51.1 OE52.1 OE53.1
OE54.1 OE59.1 OE60.1 OE80.1 OE80.2 OE80.3
OE80.4 OE80.5 OE80.6 OE81.1 OE81.2 OE81.3
OE85.1 OE90.1 OE90.2 SA00.1 SA03.1 SA04.1
SA100 SA202 SA203 SA204 SA250 SA251
SA252 SA253 SA254 SA255 SA256 SA257
SA260 SA261 SA262 SA270 SA271 SA272
SA280 SA281 SA282 SA290 SA291 SA292
SA300 SA310 TX140 WH110 WH120 WH126
WH130 WH132 WH190 WH21.1 WH21.2 WH21.3
WH21.4 WH210 WH224 WH30.1 WH30.2 WH30.3
WH31.1 WH31.2 WH31.3 WH32.1 WH32.2 WH32.3
WH33.1 WH33.2 WH33.3 WH33.4 WH33.5 WH33.6
WH33.8 WH33.9 WH34.1 WH34.2 WH34.3 WH34.4
WH40.1 WH40.2 WH520 WH830
UPDATED BY
AC115 BL00.1 BL120 BL122 BL123 BL130
BL20.1 BL20.3 BL21.2 BL21.5 BL29.1 BL29.2
BL520 BL820 BL92.1 BL940 BL962 OE10.1
OE10.2 OE10.3 OE10.4 OE10.5 OE10.6 OE10.7
OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110
OE113 OE114 OE129 OE14.4 OE15.1 OE15.2
OE15.3 OE15.4 OE15.5 OE15.7 OE30.1 OE30.2
OE30.3 OE30.4 OE30.5 OE30.6 OE30.7 OE30.9
OE510 OE810 OE830 OE920 OE950 WH20.7
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
OEC-COMPANY Numeric 4 BL00.1 BL962
Company The company number represents an
established company and is entered on
all function codes.
OEC-NAME Alpha 30 (Lower Case) BL00.1 BL140
Name Contains the company description. BL141 BL240
BL241 BL243
BL340 BL341
BL962 OE53.1
OEC-ADDR1 Alpha 30 (Lower Case) BL00.1 BL962
Address 1 First line of company address
information.
OEC-ADDR2 Alpha 30 (Lower Case) BL00.1 BL962
Address 2 Second line of company address
information.
OEC-ADDR3 Alpha 30 (Lower Case) BL00.1 BL962
Address 3 Third line of company address
information.
OEC-ADDR4 Alpha 30 (Lower Case) BL00.1 BL962
Address 4 Fourth line of company address
information.
OEC-CITY Alpha 18 (Lower Case) BL00.1 BL962
City This field contains the city of the
address.
OEC-STATE Alpha 2 BL00.1 BL962
State or Province This field contains the two-character
state code of the address.
OEC-ZIP Alpha 10 BL00.1 BL962
Postal Code This field contains the postal code of
the address.
OEC-COUNTRY Alpha 30 (Lower Case) BL00.1 BL962
Country or Other This field contains the country of the
address, or it can be used for
additional information such as an
attention name.
OEC-VERTEX-FL Alpha 1 BL962
VERTEX Used Flag Flag indicating whether company will
use a third-party tax module.
C = USE CITY/ZIP FOR VERTEX ACCESS
F = USE FIPS FOR VERTEX ACCESS
G = USE GEO CODE FOR VERTEX ACCESS
Z = USE ZIP CODE FOR VERTEX ACCESS
" " = Company does not use Vertex
A = Use AVP Taxing
OEC-LAST-ORD-NBR Numeric 8 BL92.1 BL962
Last Order Number Number of the last order placed OE10.1 OE10.2
throughout the company. OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE510
OE810 OE920
WH20.7
OEC-MAN-ORD-FL Alpha 1 BL00.1 BL962
Man Ord Fl Flag indicating whether orders will be OE810 OE920
manually numbered by the user at entry
time or automatically numbered by the
system.
N = No
Y = Yes
OEC-DEF-REASON Alpha 4 BL00.1 BL962
Default The default cancellation reason code to
Cancellation Reason be used when orders are canceled or
deleted during processing. These codes
are set up on BL07.1 (Reason Codes).
OEC-LST-INVC-BTCH Numeric 6 BL00.1 BL120
Lst Invc Btch The number of the last invoice batch BL130 BL20.1
produced by the system for this company. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
BL940 BL962
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
OEC-BTCH-CNTRL-TL Alpha 1 BL00.1 BL962
Batch Control Total Flag indicating whether batch control
Flag totals will be required to be added
before releasing the batch of invoices
on BL120 (Invoice Batch Release).
Y = Yes
N = No
OEC-INVC-PREFIX Alpha 2 BL00.1 BL962
Invoice Prefix Invoice prefix is assigned from either
the company or process level depending
on the invoice level option chosen. This
is simply a unique two-character prefix
that will precede the invoice number for
all invoices created by the system.
OEC-LST-INVC-NBR Numeric 8 AC115 BL00.1
Last Invoice Number Number of last invoice created BL120 BL130
throughout the company. BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
BL962 OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OEC-CM-PREFIX Alpha 2 BL00.1 BL962
Cm Prefix Credit memo prefix is assigned from
either the company or process level
depending on an invoicing option
established for the company. This is
simply a unique two-character prefix
that will precede the credit memo number
for all credit memos created.
OEC-LST-CM-NBR Numeric 8 AC115 BL00.1
Lst Cm Nbr Number of the last credit memo created BL120 BL130
throughout the company. BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
BL962 OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OEC-RECUR-PREFIX Alpha 2 BL00.1 BL962
Recur Prefix This field contains the recurring
invoice prefix that is assigned from
either the company or process level,
based on a company-level option.
OEC-LST-RECUR-INVC Numeric 8 BL00.1 BL120
Lst Recur Invc This field contains the number of the BL130 BL20.1
last recurring invoice created BL20.3 BL21.2
throughout the company. BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
BL940 BL962
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
OEC-POST-UNITS-FL Alpha 1 BL00.1 BL962
Post Units to GL Flag indicating whether the user wants
Flag to post units for any of the journal
entries created in the Billing and Order
Entry systems.
N = No
Y = Yes
OEC-SLS-ACCT-UNIT Alpha 15 BL00.1 BL962
Sales Accounting Default sales account unit. When adding
Unit process levels to the Billing system,
this sales account unit will default
onto the process level sales account
unit field if left blank. This is the
only use for sales account unit at the
company level. The system will use the
sales account unit at the process level
when determining which revenue account
to credit for special orders.
OEC-SLS-ACCOUNT Numeric 6 BL00.1 BL962
Sales Account Sales account number. When adding
process levels to the system in Billing,
this sales account number will default
onto the process level sales account
number field if left blank. This is the
only use for sales account number at the
company level. The system will use the
sales account number at the process
level when determining what revenue
account to credit for special orders.
OEC-SLS-SUB-ACCT Numeric 4 BL00.1 BL962
Sales Subaccount Sales subaccount number. When adding
process level to the system in BL01.1
(Process Level), this number will
default into the process level sales
subaccount number field if left blank.
This is the only use for sales
subaccount number at the company level.
The system will use sales subaccount
number at the process level when
determining what number to credit for
revenue for special orders.
OEC-EXP-ACCT-UNIT Alpha 15 BL00.1 BL962
Expense Accounting Default accounting unit to be used for
Unit the offset to COGS for special orders.
When a process level is added to the
company, this account unit will default
onto the process level if left blank.
This is the only use for this account
unit at the company level. When placing
an order for a special item, the system
will credit this account unit at the
process level.
OEC-EXP-ACCOUNT Numeric 6 BL00.1 BL962
Expense Account Default account number to be used for
the offset to COGS for special orders.
When a process level is added to the
company this account number will default
onto the process level if left blank.
This is the only use for this account
number at the company level. When
placing an order for a special item, the
system will credit this account number
at the process level.
OEC-EXP-SUB-ACCT Numeric 4 BL00.1 BL962
Depr Expense Default subaccount number to be used as
Subaccount the offset to COGS for special orders.
When a process level is added to the
company this subaccount number will
default onto the process level if left
blank. This is the only use for the
subaccount number at the company level.
When placing an order for a special
item, the system will credit this
subaccount number at the process level.
OEC-MI-ACCT-UNIT Alpha 15 BL00.1 BL962
Default Misc Default sales general ledger account
Accounting Unit unit. When process levels are added to
the Billing system, this sales account
unit will default onto the Special Order
Sales account unit field on the process
level if left blank. This is the only
use for this account at the company
level. When a special order is placed,
this special sales account unit on the
process level will be credited.
OEC-MI-ACCOUNT Numeric 6 BL00.1 BL962
Default Misc Default sales general ledger account
Account Number number. When process levels are added to
the Billing system, this sales account
number will default onto the Special
Order Sales Account number field on the
process level if left blank. This is the
only use for this account at the company
level. When a special order is placed
this special sales account number on the
process level will be credited.
OEC-MI-SUB-ACCT Numeric 4 BL00.1 BL962
Default Misc Default sales general ledger subaccount
Subaccount Number number. When process levels are added to
the Billing system, this sales
subaccount number will default onto the
Special Order Sales Subaccount number
field on the process level if left
blank. This is the only use for this
account at the company level. When a
special order is placed, this special
sales subaccount number on the process
level will be credited.
OEC-MCG-ACCT-UNIT Alpha 15 BL00.1 BL962
Miscellaneous COGS Default accounting unit to be debited
Acct Unit as the COGS for special orders. When a
process level is added to the company,
this account unit will default onto the
process level if left blank. This is the
only use for this account unit at the
company level. When placing an order for
a special item, the system will debit
this account unit at the process level.
OEC-MCG-ACCOUNT Numeric 6 BL00.1 BL962
Miscellaneous COGS Default accounting number to be debited
Account as the COGS for special orders. When a
process level is added to the company,
this account unit will default onto the
process level if left blank. This is the
only use for this account unit at the
company level. When placing an order for
a special item, the system will debit
this account number at the process
level.
OEC-MCG-SUB-ACCT Numeric 4 BL00.1 BL962
Miscellaneous COGS Default subaccount number to be debited
Subacct as the COGS for special orders. When a
process level is added to the company,
this subaccount number will default onto
the process level if left blank. This is
the only use for this subaccount number
at the company level. When placing an
order for a special item, the system
will debit this subaccount number at the
process level.
OEC-DSC-ACCT-UNIT Alpha 15 BL00.1 BL962
Discount Accounting Discount account unit. When adding
Unit process levels to the Billing system,
this discount account unit will default
onto the process level discount account
unit field if left blank. This is the
only use for discount account unit at
the company level. The system will debit
this discount account unit at the
process level when Add-on discounts are
used on an order. Add-on discounts may
be entered on an order line or an order
header by using some of the options
available at order entry time.
OEC-DSC-ACCOUNT Numeric 6 BL00.1 BL962
Discount Account Discount account number. When adding
process levels to the Billing system
this discount account number will
default onto the process level discount
account number field if left blank. This
is the only use for discount account
number at the company level. The system
will debit this discount account number
at the process level when add-on
discounts are used on an order. Add-on
discounts can be entered on an order
line or an order header by using some of
the options available at order entry
time.
OEC-DSC-SUB-ACCT Numeric 4 BL00.1 BL962
Discount Subaccount Discount subaccount number. When adding
Number process levels to the Billing system,
this discount subaccount number will
default onto the process level discount
subaccount number field if left blank.
This is the only use for discount
subaccount number at the company level.
The system will debit this discount
subaccount number on the process level
associated with the order when add-on
discounts are used on an order. Add-on
discounts may be entered on an order
line or an order header by using some of
the options available at order entry
time.
OEC-ROUTE-STOP-FL Alpha 1 BL00.1 BL962
Route Stop Fl Route and stop flag. This indicates
whether this company uses route and stop
delivery.
Y = Yes
N = No
OEC-UOM-REQ-FL Alpha 1 BL00.1 BL962
Require Entry of This flag indicates whether users will
UOM Flag be required to enter the unit of measure
for each item when adding an order to
the system.
N = No
Y = Yes
OEC-CURRENCY-CODE Alpha 5 BL00.1 BL962
Currency Code This field contains the company's base SA202 SA203
currency code established in the General SA204 SA260
Ledger system. SA261 SA262
SA270 SA271
SA272 SA280
SA281 SA282
SA290 SA291
SA292
OEC-MULTI-CURR-FL Alpha 1 BL00.1 BL962
Multiply Currency This flag indicates whether currencies
Flag other than the company base currency are
allowed during processing of orders in
the Order Entry system.
Y = Yes
N = No
OEC-BASE-ND Numeric 1 BL00.1 BL962
Base Number Of The number of decimal positions defined
Decimals for the company base currency.
OEC-CURR-OVR-FL Alpha 1 BL00.1 BL962
Curr Ovr Fl This flag indicates whether or not
users can override the default currency
when adding an order to the system.
OEC-RATE-OVR-FL Alpha 1 BL00.1 BL962
Rate Override Flag This flag indicates whether currency
exchange rates can be overridden on
transactions.
Y = Yes
N = No
OEC-REPRICE-FL Alpha 1 BL00.1 BL962
Reprice Fl The flag indicates whether to reprice
at invoice creation time or not.
Y = Yes
N = No
OEC-RATE-FRZ-CD Alpha 1 BL00.1 BL962
Rate Frz-Cd This value indicates when the system
should freeze the currency rate used on
the transaction.
E = Freeze Rate At Entry
I = Freeze Rate When Invoiced
OEC-PRICE-LOC-FL Alpha 1 BL00.1 BL962
Price at Location The price location flag indicates if
Level Flag the company will be pricing items at the
location level or the company level. If
location level is chosen, each item must
have a separate base price established
for each location.
N = No
Y = Yes
OEC-PRICE-CURR-FL Alpha 1 BL00.1 BL962
Price Curr Fl Flag indicating if pricing is to be
done in the cost-based currency or the
currency used when placing the order.
Y = Yes
N = No
OEC-AUDIT-ORD-FL Alpha 1 BL00.1 BL962
Audit Ord Fl Audit order flag indicates whether or
not the system should keep track of any
changes made to orders. If so, an audit
report can be run listing all changes.
N = No
Y = Yes
OEC-AUDIT-PRC-FL Alpha 1 BL00.1 BL962
Audit Prc Fl Audit price flag indicates whether the
system should keep track of any changes
made to the normal default pricing on an
order. If so a report can be run listing
all changes or price overrides, OE283
(Price Overrides).
N = No
Y = Yes
OEC-ALLOC-DT-FL Alpha 1 BL00.1 BL962
Allocation Date This value identifies which date on the
Option order the system should use when
determining what to allocate.
E = Entry Date
R = Request Date
S = Expected Ship Date
OEC-INVC-OPT-FL Alpha 1 BL00.1 BL962
Invoice Invoice option flag indicates if
Company/Proc Lvl Flaginvoicing will be done at the company
level or process level. Users have the
choice of establishing different
invoicing parameters for each process
level if needed.
C = Company level invoicing.
P = Process level invoicing.
OEC-INVC-EDIT-OPT Alpha 1 BL00.1 BL962
Invoice Edit Option Option to require running of BL121
(Invoice Print Edit Report) before the
invoices are printed and finalized.
N = No
Y = Yes
OEC-INTF-COST-FL Alpha 1 BL00.1 BL962
Intf Cost Fl Enter Yes to post cost for an
interfaced invoice from another system.
Y = Yes
N = No
OEC-COD-INVC-OPT Alpha 1 BL00.1 BL962
Cod Invc Opt This option determines whether invoices
should be created and printed twice for
Cash On Delivery orders. If Yes is
chosen, an invoice will be printed to be
sent with the goods (invoice at this
time is placed on hold until the driver
returns with the payment) and when the
driver returns with the payment, this
option determines whether that invoice
should be printed again to send to the
customer for their records. This final
invoice will reflect any corrections
made after the driver returns.
Y = Yes
N = No
OEC-BL-OPER-CNTRL Alpha 1 BL00.1 BL962
Bl Oper Cntrl A flag to indicate whether entry of
periodic billing quantity and charges
are restricted by billing operator. If
the flag is set to Yes, operator/item
combinations have to be set up in BL15.1
(Recurring Invoice User).
Y = Yes
N = No
OEC-BILL-EQL-INVC Alpha 1 BL00.1 BL962
Bill Eql Invc A flag to indicate whether the bill
date of a recurring invoice equals the
invoice date.
Y = Yes
N = No
OEC-TAX-PRINT-CD Alpha 1 BL00.1 BL962
Tax Print Cd This code determines whether the tax
lines should print in summary or detail
on the invoice.
D = Calc by line - print detail
S = Calc by line - print summary
T = Calc and print in summary
OEC-TAX-PRICE-FL Alpha 1 BL962
Tax Price Fl Flag to indicate that prices include
taxes.
Y = Yes
N = No
OEC-DISC-AOC-FL Alpha 1 BL00.1 BL962
Disc AOC Fl Flag to indicate whether add-on charges
are included in order level discount
calculations.
Y = Yes
N = No
OEC-TERMS-AOC-FL Alpha 1 BL00.1 BL962
Terms AOC Fl Flag to indicate whether add-on charges
are included in the terms calculations.
For example, if payment terms include a
percentage discount and this flag is set
to No, the add-on charge amount will not
be included in the total of the order
from which the terms discount will be
calculated.
Y = Yes
N = No
OEC-INVC-CR-FL Alpha 1 BL962 OE129
Credit Memo Flag If invoicing is done at the company
level and OE129 (Daily Shipment Journal)
is running (this program creates
invoices), this flag will be set to Yes
to indicate that other invoice updating
batch programs cannot be run.
N = No
Y = Yes
OEC-INVC-EDIT-FL Alpha 1 BL962
Invoice Edit If invoicing is done at the company
Running Flag level and BL121 (Invoice Print Edit
Report) is running, this flag will be
set to Yes to indicate that other
invoice update programs cannot be run.
N = No
Y = Yes
OEC-INVC-PRT-FL Alpha 1 BL122 BL962
Invoice Printed Flag If invoicing is done at the company OE114
level and BL122 (Invoice and Register
Print) is running, this flag will be set
to Yes to indicate that other invoice
update programs may not be run.
N = No
Y = Yes
OEC-INVC-UPD-FL Alpha 1 BL123 BL962
Invc Upd Fl If invoicing is done at the company
level and BL123 (Sub-System Update) is
running, this flag will be set to Yes to
indicate that other invoice update
programs cannot be run.
N = No
Y = Yes
OEC-INVC-DTL-FL Alpha 1 BL00.1 BL962
Invc Dtl Fl This flag indicates whether
lots/sublots and serial numbers of items
ordered should print on the invoice.
N = No
Y = Yes
OEC-REL-COM-OPT Alpha 1 Occurs 10 Times BL00.1 BL962
Rel Com Opt An "X" on this field indicates that all
comments tied to an item on IC18.1 (Item
Comments) and belonging to the comment
type at the top of the column will print
on OE110 (Batch Order Release).
OEC-ACK-COM-OPT Alpha 1 Occurs 10 Times BL00.1 BL962
Ack Com Opt Selecting this field indicates that all
comments tied to an item on IC18.1 (Item
Comments) and belonging to the comment
type at the bottom of the column will
print on OE112 (Acknowledgment Print
Report).
OEC-QTE-COM-OPT Alpha 1 Occurs 10 Times BL00.1 BL962
Qte Com Opt An "X" placed on this line indicates
that all comments tied to an item on
IC18.1 (Item Comments) and belonging to
the comment type at the bottom of the
column will print on OE113 (Quotation
Listing and Delete).
OEC-JOR-COM-OPT Alpha 1 Occurs 10 Times BL00.1 BL962
Jor Com Opt An "X" placed on this line indicates
that all comments tied to an item on
IC18.1 (Item Comments) and belonging to
the comment type at the bottom of the
column will print on OE129 (Daily
Shipment Journal).
OEC-INV-COM-OPT Alpha 1 Occurs 10 Times BL00.1 BL962
Inv Com Opt An "X" on this line indicates that all
comments tied to an item on IC18.1 (Item
Comments) and belonging to the comment
type referenced below will print on
BL122 (Invoice Register and Print).
OEC-RMT-NAME Alpha 30 (Lower Case) BL00.1 BL962
Rmt Name Company remit-to name. If left blank,
company name will default or can be
overridden. All forms generated to send
to a customer will print this as the
remit-to name.
OEC-RMT-ADDR1 Alpha 30 (Lower Case) BL00.1 BL962
Rmt Addr1 Remit-to address. If left blank,
company address will default or it can
be overridden. All forms generated by
the Order Entry and Billing systems will
print this as a remit-to address.
OEC-RMT-ADDR2 Alpha 30 (Lower Case) BL00.1 BL962
Rmt Addr2 Remit-to address line 2. If left blank
the company address line 2 will default
or it can be overridden. All forms
generated by the Order Entry and Billing
systems will print this address as the
remit-to.
OEC-RMT-ADDR3 Alpha 30 (Lower Case) BL00.1 BL962
Rmt Addr3 Remit-to address line 3. If left blank
the company address line 3 will default
or it can be overridden. All forms
generated by the Order Entry and Billing
systems will print this address as the
remit-to.
OEC-RMT-ADDR4 Alpha 30 (Lower Case) BL00.1 BL962
Rmt Addr4 Remit-to address line 4. If left blank,
company address line 4 will default or
it can be overridden. All forms
generated by the Order Entry and Billing
systems will print this as the remit-to
address.
OEC-RMT-CITY Alpha 18 BL00.1 BL962
Rmt City Remit-to city. If left blank, company
city will default or it can be
overridden. All forms generated by the
Order Entry and Billing systems will
print this as the remit-to city.
OEC-RMT-STATE Alpha 2 BL00.1 BL962
Rmt State Remit-to state. If left blank, company
state will default or it can be
overridden. All forms generated by the
Order Entry and Billing systems will
print this as the remit-to state.
OEC-RMT-ZIP Alpha 10 BL00.1 BL962
Rmt Zip Remit-to postal (zip) code. If left
blank the company postal code will
default or it can be overridden. All
forms generated by the Order Entry and
Billing systems will print this as the
remit-to postal code.
OEC-RMT-COUNTRY Alpha 30 (Lower Case) BL00.1 BL962
Rmt Country Remit-to country. If left blank, the
company country will default or can be
overridden. All forms generated by the
Order Entry and Billing systems will
print this as the remit-to country.
OEC-LAST-AR-BATCH Numeric 3 BL00.1 BL123
Last Ar Batch The last Accounts Receivable batch of BL962
invoices that was used by the system.
OEC-INCOMPLETE-FL Alpha 1 BL00.1 BL962
Incomplete Flag Company incomplete flag indicates that
the company has not been fully added to
the system.
OEC-BL-INCOMPL-FL Alpha 1 BL962
Bl Incompl Fl This field indicates whether or not
setup was completed for the Order Entry
company.
N = No
Y = Yes
OEC-COM-TYPE-1 Derived
Comm Type 1 This field contains the first comment
type.
OEC-COUNTRY-CODE Alpha 2 BL00.1
Country Code The country code. Required for VAT and
intrastat reporting. Must be defined in
IN01.1 (Country Maintenance).
OEC-REGION Alpha 2 BL00.1
Region Code The region code, if applicable for the
country. Used only by Intrastat. Must be
defined in IN02.1 (Region Maintenance).
OECOMPANY FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
OECSET1 COMPANY AC115 AR08.1
AR10.1 AR115
AR124 AR150
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR30.1
AR30.2 AR30.4
AR31.5 AR42.2
AR42.7 AR501
AR550 AR570
AR575 AR580
BL00.1 BL01.1
BL02.1 BL02.2
BL03.1 BL04.1
BL05.1 BL06.1
...
OECOMPANY FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Arcomp ARCOMP Not Required
OEC-COMPANY -> ACO-COMPANY
Cucodes CUCODES Required
When OEC-CURRENCY-CODE != Spaces
OEC-CURRENCY-CODE -> CUC-CURRENCY-CODE
Exp Acct GLMASTER Required
When OEC-EXP-ACCT-UNIT != Spaces
Or OEC-EXP-ACCOUNT != Zeroes
Or OEC-EXP-SUB-ACCT != Zeroes
OEC-COMPANY -> GLM-COMPANY
OEC-EXP-ACCT-UNIT -> GLM-ACCT-UNIT
OEC-EXP-ACCOUNT -> GLM-ACCOUNT
OEC-EXP-SUB-ACCT -> GLM-SUB-ACCOUNT
Glsystem GLSYSTEM Required
OEC-COMPANY -> GLS-COMPANY
Iccompany ICCOMPANY Required
OEC-COMPANY -> ICC-COMPANY
Itemgroup ITEMGROUP Required
ICC-ITEM-GROUP -> ITG-ITEM-GROUP
Misc Cgs Acct GLMASTER Required
When OEC-MCG-ACCT-UNIT != Spaces
Or OEC-MCG-ACCOUNT != Zeroes
Or OEC-MCG-SUB-ACCT != Zeroes
OEC-COMPANY -> GLM-COMPANY
OEC-MCG-ACCT-UNIT -> GLM-ACCT-UNIT
OEC-MCG-ACCOUNT -> GLM-ACCOUNT
OEC-MCG-SUB-ACCT -> GLM-SUB-ACCOUNT
Misc Sls Acct GLMASTER Required
OEC-COMPANY -> GLM-COMPANY
OEC-MI-ACCT-UNIT -> GLM-ACCT-UNIT
OEC-MI-ACCOUNT -> GLM-ACCOUNT
OEC-MI-SUB-ACCT -> GLM-SUB-ACCOUNT
Oereason OEREASON Required
When OEC-DEF-REASON != Spaces
OEC-COMPANY -> OER-COMPANY
OEC-DEF-REASON -> OER-REASON-CODE
Ord Disc Acct GLMASTER Required
When OEC-DSC-ACCT-UNIT != Spaces
Or OEC-DSC-ACCOUNT != Zeroes
Or OEC-DSC-SUB-ACCT != Zeroes
OEC-COMPANY -> GLM-COMPANY
OEC-DSC-ACCT-UNIT -> GLM-ACCT-UNIT
OEC-DSC-ACCOUNT -> GLM-ACCOUNT
OEC-DSC-SUB-ACCT -> GLM-SUB-ACCOUNT
Sales Account GLMASTER Required
OEC-COMPANY -> GLM-COMPANY
OEC-SLS-ACCT-UNIT -> GLM-ACCT-UNIT
OEC-SLS-ACCOUNT -> GLM-ACCOUNT
OEC-SLS-SUB-ACCT -> GLM-SUB-ACCOUNT
OECOMPANY FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Coline COLINE Delete Restricted
OEC-COMPANY -> COL-COMPANY
COL-ORDER-NBR
COL-LINE-NBR
Custorder CUSTORDER Delete Restricted
OEC-COMPANY -> COR-COMPANY
COR-ORDER-NBR
Oebases OEBASE Delete Restricted
OEC-COMPANY -> OEB-COMPANY
OEB-LOCATION
OEB-BASE-NAME
OEB-CURRENCY-CODE
OEB-ITEM
Oecredcard OECREDCARD
OEC-COMPANY -> OCR-COMPANY
OCR-CC-TYPE
Oediscount OEDISCOUNT Delete Restricted
OEC-COMPANY -> OED-COMPANY
OED-DISC-CODE
Oefrtcode OEFRTCODE
OEC-COMPANY -> OFR-COMPANY
OFR-FRT-CODE
Oeinvoice OEINVOICE
OEC-COMPANY -> OEI-COMPANY
OEI-INVC-PREFIX
OEI-INVC-NUMBER
Oeprcbook OEPRCBOOK Delete Cascades
OEC-COMPANY -> OPB-COMPANY
OPB-BOOK-NAME
Oeprclist OEPRCLIST Delete Restricted
OEC-COMPANY -> OPL-COMPANY
OPL-CUSTOMER
OPL-LIST-NAME
OPL-PROMOTION
Oeproclev OEPROCLEV Delete Restricted
OEC-COMPANY -> OEP-COMPANY
OEP-PROCESS-LEVEL
Oewksheet OEWKSHEET Delete Restricted
OEC-COMPANY -> OWK-COMPANY
OWK-WORK-NAME
Price Lists OEPRCLIST Delete Restricted
OEC-COMPANY -> OPL-COMPANY
Spaces -> OPL-CUSTOMER
OPL-LIST-NAME
OPL-PROMOTION
|