|
|
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
AP125 AP126 AP131 AP25.1 AP25.2 AP26.1
AP27.1 AP30.4 AR08.1 AR09.1 AR10.1 AR115
AR124 AR150 AR20.1 AR21.1 AR21.2 AR21.3
AR219 AR24.1 AR30.1 AR301 AR31.5 AR33.5
AR34.1 AR42.2 AR42.7 AR501 AR550 AR560
AR570 AR575 AR580 ARLL.1 BL01.1 BL02.1
BL03.1 BL04.1 BL05.1 BL06.1 BL07.1 BL09.1
BL10.1 BL12.1 BL120 BL121 BL125 BL13.1
BL130 BL14.1 BL140 BL141 BL15.1 BL16.1
BL199 BL20.1 BL20.3 BL20.5 BL20.6 BL200
BL201 BL202 BL203 BL204 BL205 BL206
BL207 BL209 BL21.2 BL21.5 BL210 BL212
BL213 BL214 BL215 BL217 BL220 BL230
BL231 BL232 BL240 BL241 BL243 BL244
BL245 BL246 BL247 BL248 BL29.1 BL29.2
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 BL520 BL530 BL546 BL80.1 BL80.2
BL80.3 BL80.4 BL80.6 BL802 BL81.1 BL82.1
BL820 BL85.1 BL85.2 BL85.3 BL90.1 BL91.1
BL92.1 BL98.1 BL99.1 BR11.1 CB191 CXCP.1
IC02.1 IC28.1 IC83.1 MA180 MA530 MA531
MA60.2 MA60.3 MA60.5 MA61.1 MA66.2 MA66.3
MA67.1 MA67.2 MA70.1 MA75.1 MA80.1 MAI1.1
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 OE111 OE112 OE113 OE116 OE13.1
OE13.2 OE13.3 OE13.5 OE13.6 OE130 OE14.1
OE14.2 OE14.3 OE14.4 OE16.1 OE210 OE229
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 OE30.1 OE30.2 OE30.3 OE30.4 OE30.5
OE30.6 OE30.7 OE30.9 OE310 OE330 OE51.1
OE510 OE52.1 OE53.1 OE530 OE54.1 OE59.1
OE60.1 OE80.1 OE80.2 OE80.3 OE80.4 OE80.5
OE80.6 OE81.1 OE81.2 OE81.3 OE830 OE85.1
OE85.2 OE85.3 OE86.1 OE86.2 OE86.3 OE86.4
OE90.1 OE90.2 PO100 PO101 PO122 PO131
PO20.1 PO21.2 PO21.3 PO21.4 PO21.5 PO22.1
PO23.1 PO29.1 PO30.1 PO30.2 PO30.3 PO300
PO31.1 PO31.2 PO32.2 PO33.1 PO34.1 PO35.1
PO38.1 PO39.1 PO39.2 PO44.1 PO50.1 PO52.1
PO520 POI3.1 POIE.1 POII.1 POIJ.1 RQ10.1
RQ10.2 RQ12.1 RQ13.1 RQ13.2 RQ35.1 RQ500
RQIF.1 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 SA310 TX140
WH110 WH120 WH126 WH130 WH132 WH190
WH20.1 WH20.2 WH20.3 WH20.4 WH20.5 WH20.6
WH20.7 WH21.1 WH21.2 WH21.3 WH21.4 WH210
WH22.1 WH222 WH25.1 WH25.2 WH30.1 WH30.2
WH30.3 WH30.4 WH31.1 WH31.2 WH31.3 WH31.4
WH32.1 WH32.2 WH32.3 WH32.4 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 WO120 WO131 WO132 WO133
WO140 WO20.1 WO30.1 WO32.1 WO32.2 WO32.3
WO32.4 WO32.5 WO40.1 WO40.2 WO40.3 WO40.4
WO40.5 WO41.1 WO41.2 WO41.3 WO41.4 WO42.1
WO42.2 WO42.3 WO42.4 WO42.5 WO45.1 WOEX.1
WOSP.1
UPDATED BY
BL00.1 BL122 BL123 OE114 OE129 OE810
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
OEC-COMPANY Numeric 4 BL00.1
Element: Company Identifies the AP company if the
resource type = V. Identifies the HR
company if the resource type = E. It is
blank for type A, P or Q resources.
OEC-NAME Alpha 30 (Lower Case) BL00.1 BL140
Element: Name Displays the company description. BL141 BL240
BL241 BL243
BL340 BL341
OE53.1
OEC-ADDR1 Alpha 30 (Lower Case) BL00.1
Element: Address 1 First line of company address
information.
OEC-ADDR2 Alpha 30 (Lower Case) BL00.1
Element: Address 1 Second line of company address
information.
OEC-ADDR3 Alpha 30 (Lower Case) BL00.1
Element: Address 1 Third line of company address
information.
OEC-ADDR4 Alpha 30 (Lower Case) BL00.1
Element: Address 1 Fourth line of company address
information.
OEC-CITY Alpha 18 (Lower Case) BL00.1
Element: City This field contains the city of the
address.
OEC-STATE Alpha 2 BL00.1
Element: State or ProviThis field contains the two-character
state code of the address.
OEC-ZIP Alpha 10 BL00.1
Element: Postal Code This field contains the postal code of
the address.
OEC-COUNTRY Alpha 30 (Lower Case) BL00.1
Element: Country or OthThis 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
Element: County The county for the company address.
OEC-MAN-ORD-FL Alpha 1 BL00.1 OE810
Element: All Flag 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
Element: Cb Reason The default cancellation reason code to
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
Element: All Flag Flag indicating whether the user wants
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
Element: Accounting UniDefault sales account unit. When adding
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
Element: 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
Element: 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
Element: Accounting UniDefault accounting unit to be used for
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
Element: 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
Element: Subaccount Default subaccount number to be used as
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
Element: Accounting UniDefault sales general ledger account
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
Element: Account Default sales general ledger account
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
Element: Subaccount Default sales general ledger subaccount
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
Element: Accounting UniDefault accounting unit to be debited
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
Element: Account Default accounting number to be debited
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
Element: Subaccount Default subaccount number to be debited
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
Element: Accounting UniDiscount account unit. When adding
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
Element: 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
Element: Subaccount Discount subaccount number. When adding
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
Element: All Flag 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
Element: All Flag This flag indicates whether users will
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 SA202
Element: Currency Code This field contains the company's base SA203 SA204
currency code established in the General SA260 SA261
Ledger system. SA262 SA270
SA271 SA272
SA280 SA281
SA282 SA290
SA291 SA292
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
Element: All Flag 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
Element: 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
Element: All Flag The flag indicates whether to reprice
at invoice creation time or not.
Y = Yes
N = No
OEC-RATE-FRZ-CD Alpha 1 BL00.1
Element: 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
Element: All Flag The price location flag indicates if
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
Element: All Flag 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
Element: All Flag 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
Element: All Flag 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 Flag invoicing 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
Element: All Flag 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
Element: All Flag Enter Yes to post cost for an
interfaced invoice from another system.
Y = Yes
N = No
OEC-COD-INVC-OPT Alpha 1 BL00.1
Element: All Flag 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
Element: All Flag 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
Element: All Flag 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
Element: 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
P = Price incl tax - print summary
OEC-TAX-PRICE-FL Alpha 1
Element: All Flag Flag to indicate that prices include
taxes.
Y = Yes
N = No
OEC-DISC-AOC-FL Alpha 1 BL00.1
Element: All Flag 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
Element: All Flag 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 OE129
Element: All 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
Element: All Flag If invoicing is done at the company
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 OE114
Element: All 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
Element: All Flag 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
Element: All Flag 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
Element: Ack 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
Element: 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
Element: Ack 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
Element: Ack 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
Element: Ack 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
Element: 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
Element: Address 1 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
Element: Address 1 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
Element: Address 1 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
Element: Address 1 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
Element: Billing 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
Element: State or ProviRemit-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
Element: Postal Code 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
Element: Country or OthRemit-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
Element: County
OEC-INCOMPLETE-FL Alpha 1 BL00.1
Element: Incomplete FlaCompany incomplete flag indicates that
the company has not been fully added to
the system.
OEC-BL-INCOMPL-FL Alpha 1
Element: All Flag This field indicates whether or not
setup was completed for the Order Entry
company.
N = No
Y = Yes
OEC-COM-TYPE-1 Derived
Element: Com Type 1 This field contains the first comment
type.
OEC-MAN-RET-FL Alpha 1 BL00.1
Element: Account Flag
OEC-COUNTRY-CODE Alpha 2 BL00.1
Element: 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
Element: 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
Element: 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
Element: Iso Ctry Nbr The ISO country number.
OEC-RMT-CTRY-CODE Alpha 2 BL00.1
Element: Rmt Ctry Code
OEC-RMT-REGION Alpha 2 BL00.1
Element: Rmt Region
OEC-RMT-EC-CTRY Numeric 3 BL00.1
Element: Rmt Ec Ctry
OEC-RMT-ISO-CTRY Numeric 3 BL00.1
Element: Rmt Iso Ctry
OECOMPANY FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
OECSET1 COMPANY AP125 AP126
AP131 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AR08.1 AR09.1
AR10.1 AR115
AR124 AR150
AR20.1 AR21.1
AR21.2 AR21.3
AR219 AR24.1
AR30.1 AR301
AR31.5 AR33.5
AR34.1 AR42.2
AR42.7 AR501
AR550 AR560
...
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
OEL-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
|
