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 AR115 AR124 AR150 AR20.1 AR21.1
AR21.2 AR21.3 AR219 AR24.1 AR30.1 AR30.2
AR30.4 AR31.5 AR42.2 AR42.7 AR501 AR550
AR560 AR570 AR575 AR580 BL01.1 BL02.1
BL03.1 BL04.1 BL05.1 BL06.1 BL07.1 BL09.1
BL10.1 BL12.1 BL121 BL125 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 BL217 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 BL530 BL546 BL80.1
BL80.2 BL80.3 BL80.4 BL80.6 BL802 BL81.1
BL82.1 BL85.1 BL85.2 BL85.3 BL90.1 BL91.1
BL98.1 BL99.1 BR11.1 CB191 CXCP.1 DR100
IC02.1 IC141 IC142 IC83.1 PHI3.1 POIJ.1
RQ11.1 RQ12.1 RQ13.1 TX140 WH110 WH120
WH126 WH130 WH21.1 WH21.2 WH21.3 WH21.4
WH210 WH22.1 WH33.1 WH33.2 WH33.3 WH33.4
WH33.5 WH33.6 WH33.8 WH33.9 WH34.1 WH34.2
WH34.3 WH34.4
UPDATED BY
BL00.1 BL123
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
OEC-COMPANY Numeric 4 BL00.1
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 Displays the company description. BL141 BL240
BL241 BL243
BL340 BL341
OEC-ADDR1 Alpha 30 (Lower Case) BL00.1
Address 1 First line of company address
information.
OEC-ADDR2 Alpha 30 (Lower Case) BL00.1
Address 2 Second line of company address
information.
OEC-ADDR3 Alpha 30 (Lower Case) BL00.1
Address 3 Third line of company address
information.
OEC-ADDR4 Alpha 30 (Lower Case) BL00.1
Address 4 Fourth line of company address
information.
OEC-CITY Alpha 18 (Lower Case) BL00.1
City This field contains the city of the
address.
OEC-STATE Alpha 2 BL00.1
State or Province This field contains the two-character
state code of the address.
OEC-ZIP Alpha 10 BL00.1
Postal Code This field contains the postal code of
the address.
OEC-COUNTRY Alpha 30 (Lower Case) BL00.1
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-COUNTY Alpha 25 (Lower Case) BL00.1
County The county for the company address.
OEC-MAN-ORD-FL Alpha 1 BL00.1
Man Ord Fl Flag indicating whether orders will be
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
Default The default cancellation reason code to
Cancellation Reson be used when orders are canceled or
deleted during processing. These codes
are set up on BL07.1 (Reason Codes).
OEC-BTCH-CNTRL-TL Alpha 1 BL00.1
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-POST-UNITS-FL Alpha 1 BL00.1
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
Currency Code This field contains the company's base
currency code established in the General
Ledger system.
OEC-MULTI-CURR-FL Alpha 1 BL00.1
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
Base Number Of The number of decimal positions defined
Decimals for the company base currency.
OEC-CURR-OVR-FL Alpha 1 BL00.1
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
Rate Ovr Fl This flag indicates whether currency
exchange rates can be overridden on
transactions.
Y = Yes
N = No
OEC-REPRICE-FL Alpha 1 BL00.1
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
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
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
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
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
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
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
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
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
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
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
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
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
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
Tax Price Fl Flag to indicate that prices include
taxes.
Y = Yes
N = No
OEC-DISC-AOC-FL Alpha 1 BL00.1
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
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
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
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
Invoice Printed Flag If invoicing is done at the company
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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-RMT-COUNTY Alpha 25 (Lower Case) BL00.1
Rmt County
OEC-INCOMPLETE-FL Alpha 1 BL00.1
Incomplete Flag Company incomplete flag indicates that
the company has not been fully added to
the system.
OEC-BL-INCOMPL-FL Alpha 1
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
Com Type 1 This field contains the first comment
type.
OEC-MAN-RET-FL Alpha 1 BL00.1
Man Ret Fl
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 by Intrastat. Must be
defined in IN02.1 (Region Maintenance)
OEC-EC-CTRY-NBR Numeric 3 BL00.1
Ec Ctry Nbr The European Community Country number;
leave blank if not a member of the
European Community.
OEC-ISO-CTRY-NBR Numeric 3 BL00.1
Iso Ctry Nbr The ISO country number.
OEC-RMT-CTRY-CODE Alpha 2 BL00.1
Rmt Ctry Code
OEC-RMT-REGION Alpha 2 BL00.1
Rmt Region
OEC-RMT-EC-CTRY Numeric 3 BL00.1
Rmt Ec Ctry
OEC-RMT-ISO-CTRY Numeric 3 BL00.1
Rmt Iso Ctry
OECOMPANY FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
OECSET1 COMPANY AR08.1 AR115
AR124 AR150
AR20.1 AR21.1
AR21.2 AR21.3
AR219 AR24.1
AR30.1 AR30.2
AR30.4 AR31.5
AR42.2 AR42.7
AR501 AR550
AR560 AR570
AR575 AR580
BL00.1 BL01.1
BL02.1 BL03.1
BL04.1 BL05.1
BL06.1 BL07.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
Oecompref OECOMPREF
OEC-COMPANY -> OEL-COMPANY
OEL-PROCESS-LEVEL
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
|
