OECOMPANY

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
AC56.1 AC560 AP125 AP126 AP131 AP20.1
AP20.2 AP20.3 AP20.4 AP20.5 AP20.7 AP21.1
AP23.1 AP25.1 AP25.2 AP26.1 AP27.1 AP30.4
API1.1 API2.1 AR01.1 AR08.1 AR09.1 AR10.1
AR301 AR501 AR550 ARLL.1 BR11.1 BR48.1
CB191 CX05.1 CX05.2 CX100 CX20.1 CX20.2
CX20.4 CX20.5 CX220 CX30.1 CX300 CX506
CX805 CXCP.1 DR100 IC02.1 IC140 IC141
IC142 IC66.1 IC83.1 MA180 MA41.1 MA41.2
MA41.4 MA41.7 MA42.2 MA43.2 MA43.7 MA44.1
MA44.2 MA530 MA531 MA60.2 MA60.3 MA60.5
MA61.1 MA66.2 MA67.2 MA67.3 MA68.2 MA68.3
MA68.5 MA70.1 MA75.1 MA80.1 MAI1.1 PD10.1
PD10.2 PD130 PD20.1 PD20.2 PD20.3 PO100
PO101 PO122 PO131 PO136 PO150 PO190
PO20.1 PO20.6 PO20.9 PO21.1 PO21.2 PO21.3
PO21.4 PO21.5 PO22.1 PO22.3 PO22.4 PO23.1
PO24.1 PO25.1 PO25.5 PO25.6 PO25.7 PO27.2
PO28.2 PO29.1 PO30.1 PO30.2 PO30.3 PO30.4
PO300 PO31.1 PO31.2 PO32.2 PO32.4 PO33.1
PO34.1 PO35.1 PO36.1 PO36.2 PO38.1 PO39.1
PO39.2 PO44.1 PO50.1 PO52.1 PO520 PO536
PO54.5 POCP.1 POI3.1 POID.1 POII.1 POIJ.1
RQ10.1 RQ10.2 RQ10.3 RQ10.4 RQ11.1 RQ12.1
RQ13.1 RQ13.2 RQ35.1 RQ500 RQIC.1 RQID.1
RQIF.1 RQIG.1 RQIJ.1 TX00.1 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 WH32.5 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 ZW130

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
OEC-COMPANY
Element: Company
Numeric 4
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
Element: Name
Alpha 30 (Lower Case)
Displays the company description.
OEC-ADDR1
Element: Addr1
Alpha 30 (Lower Case)
First line of company address information.
OEC-ADDR2
Element: Addr1
Alpha 30 (Lower Case)
Second line of company address information.
OEC-ADDR3
Element: Addr1
Alpha 30 (Lower Case)
Third line of company address information.
OEC-ADDR4
Element: Addr1
Alpha 30 (Lower Case)
Fourth line of company address information.
OEC-CITY
Element: City
Alpha 18 (Lower Case)
This field contains the city of the address.
OEC-STATE
Element: State
Alpha 2
This field contains the two-character state code of the address.
OEC-ZIP
Element: Zip
Alpha 10
This field contains the postal code of the address.
OEC-COUNTRY
Element: Country
Alpha 30 (Lower Case)
This field contains the country of the address, or it can be used for additional information such as an attention name.
OEC-COUNTY
Element: County
Alpha 25 (Lower Case)
The county for the company address.
OEC-MAN-ORD-FL
Element: All Flag
Alpha 1
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
Element: Cb Reason
Alpha 4
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
Element: Btch Cntrl Tl
Alpha 1
Flag indicating whether batch control 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
Element: All Flag
Alpha 1
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
Element: Acct Unit
Alpha 15
Default 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
Element: Account
Numeric 6
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
Element: Sub Acct
Numeric 4
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
Element: Acct Unit
Alpha 15
Default 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
Element: Account
Numeric 6
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
Element: Sub Acct
Numeric 4
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
Element: Acct Unit
Alpha 15
Default 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
Element: Account
Numeric 6
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
Element: Sub Acct
Numeric 4
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
Element: Acct Unit
Alpha 15
Default 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
Element: Account
Numeric 6
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
Element: Sub Acct
Numeric 4
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
Element: Acct Unit
Alpha 15
Discount 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
Element: Account
Numeric 6
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
Element: Sub Acct
Numeric 4
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
Element: All Flag
Alpha 1
Route and stop flag. This indicates whether this company uses route and stop delivery.
Y = Yes
N = No
OEC-UOM-REQ-FL
Element: All Flag
Alpha 1
This flag indicates whether users will be required to enter the unit of measure for each item when adding an order.
N = No
Y = Yes
OEC-CURRENCY-CODE
Element: Currency Code
Alpha 5
This field contains the company's base currency code established in General Ledger.
OEC-MULTI-CURR-FL
Element: Multi Curr Fl
Alpha 1
This flag indicates whether currencies other than the company base currency are allowed during processing of orders in the Order Entry system.
Y = Yes
N = No
OEC-BASE-ND
Element: Base Nd
Numeric 1
The number of decimal positions defined for the company base currency.
OEC-CURR-OVR-FL
Element: All Flag
Alpha 1
This flag indicates whether or not users can override the default currency when adding an order to the system.
OEC-RATE-OVR-FL
Element: Rate Ovr Fl
Alpha 1
This flag indicates whether currency exchange rates can be overridden on transactions.
Y = Yes
N = No
OEC-REPRICE-FL
Element: All Flag
Alpha 1
The flag indicates whether to reprice at invoice creation time or not.
Y = Yes
N = No
OEC-RATE-FRZ-CD
Element: Rate Frz Cd
Alpha 1
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
Element: All Flag
Alpha 1
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
Element: All Flag
Alpha 1
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
Element: All Flag
Alpha 1
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
Element: All Flag
Alpha 1
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
Element: Alloc Dt Fl
Alpha 1
This value identifies which date on the order the system should use when determining what to allocate.
E = Entry Date
R = Request Date
S = Expected Ship Date
OEC-INVC-OPT-FL
Element: Invc Opt Fl
Alpha 1
Invoice option flag indicates if 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
Element: All Flag
Alpha 1
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
Element: All Flag
Alpha 1
Enter Yes to post cost for an interfaced invoice from another system.
Y = Yes
N = No
OEC-COD-INVC-OPT
Element: All Flag
Alpha 1
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
Element: All Flag
Alpha 1
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
Element: All Flag
Alpha 1

Y = Yes
N = No
OEC-TAX-PRINT-CD
Element: Tax Print Cd
Alpha 1
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
B = Calc Line - Prt Detail & Summ
X = Calc Summ - Prt Detail & Summ
OEC-TAX-PRICE-FL
Element: All Flag
Alpha 1
Flag to indicate that prices include taxes.
Y = Yes
N = No
OEC-DISC-AOC-FL
Element: All Flag
Alpha 1
Flag to indicate whether add-on charges are included in order level discount calculations.
Y = Yes
N = No
OEC-TERMS-AOC-FL
Element: All Flag
Alpha 1
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
Element: All Flag
Alpha 1
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
Element: All Flag
Alpha 1
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
Element: All Flag
Alpha 1
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
Element: All Flag
Alpha 1
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
Element: All Flag
Alpha 1
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
Element: Ack Com Opt
Alpha 1 Occurs 10 Times
An "X" on this field indicates that all comments tied to an item on Item Comments (IC18.1) and belonging to the comment type at the top of the column will print on Batch Order Release (OE110).
OEC-ACK-COM-OPT
Element: Ack Com Opt
Alpha 1 Occurs 10 Times
Selecting this field indicates that all comments tied to an item on Item Comments (IC18.1) and belonging to the comment type at the bottom of the column will print on Acknowledgment Print Report (OE112).
OEC-QTE-COM-OPT
Element: Ack Com Opt
Alpha 1 Occurs 10 Times
An "X" placed on this line indicates that all comments tied to an item on Item Comments (IC18.1) and belonging to the comment type at the bottom of the column will print on Quotation Listing and Delete (OE113).
OEC-JOR-COM-OPT
Element: Ack Com Opt
Alpha 1 Occurs 10 Times
An "X" placed on this line indicates that all comments tied to an item on Item Comments (IC18.1) and belonging to the comment type at the bottom of the column will print on Daily Shipment Journal (OE129).
OEC-INV-COM-OPT
Element: Ack Com Opt
Alpha 1 Occurs 10 Times
An "X" on this line indicates that all comments tied to an item on Item Comments (IC18.1) and belonging to the comment type referenced below will print on Invoice Register and Print (BL122).
OEC-RMT-NAME
Element: Name
Alpha 30 (Lower Case)
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
Element: Addr1
Alpha 30 (Lower Case)
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
Element: Addr1
Alpha 30 (Lower Case)
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
Element: Addr1
Alpha 30 (Lower Case)
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
Element: Addr1
Alpha 30 (Lower Case)
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
Element: Bill City
Alpha 18
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
Element: State Prov
Alpha 2
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
Element: Zip
Alpha 10
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
Element: Country
Alpha 30 (Lower Case)
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
Element: County
Alpha 25 (Lower Case)
The county for the company address.
OEC-INCOMPLETE-FL
Element: Incomplete Fl
Alpha 1
Company incomplete flag indicates that the company has not been fully added to the system.
OEC-BL-INCOMPL-FL
Element: All Flag
Alpha 1
This field indicates whether or not setup was completed for the Order Entry company.
N = No
Y = Yes
OEC-COM-TYPE-1
Element: Com Type 1
Derived
This field contains the first comment type.
OEC-MAN-RET-FL
Element: Account Flag
Alpha 1
OEC-COUNTRY-CODE
Element: Country Code
Alpha 2
The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance).
OEC-REGION
Element: Region
Alpha 2
The region code, if applicable for the country. Used by Intrastat. Must be defined in IN02.1 (Region Maintenance)
OEC-EC-CTRY-NBR
Element: Ec Ctry Nbr
Numeric 3
The European Community Country number; leave blank if not a member of the European Community.
OEC-ISO-CTRY-NBR
Element: Iso Ctry Nbr
Numeric 3
The ISO country number.
OEC-RMT-CTRY-CODE
Element: Rmt Ctry Code
Alpha 2
OEC-RMT-REGION
Element: Rmt Region
Alpha 2
OEC-RMT-EC-CTRY
Element: Rmt Ec Ctry
Numeric 3
OEC-RMT-ISO-CTRY
Element: Rmt Iso Ctry
Numeric 3
OEC-BACK-ORD-CNTRL
Element: All Flag
Alpha 1

O = Order Entry Only
W = Warehouse Only
B = Both Order Entry and Warehouse
I = Ignore
OEC-TERMS-FRT-FL
Element: All Flag
Alpha 1
OEC-LIMIT-RETURNS
Element: All Flag
Alpha 1

N = None
D = Days
S = Specific Date
OEC-RETURN-DAYS
Element: Return Days
Numeric 6


OECOMPANY FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
OECSET1 COMPANY
...
AC56.1 AC560
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
AR01.1 AR08.1
AR09.1 AR10.1
AR301 AR501
AR550 ARLL.1
BR11.1 BR48.1


OECOMPANY FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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
OrOEC-EXP-ACCOUNT !=Zeroes
OrOEC-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
OrOEC-MCG-ACCOUNT !=Zeroes
OrOEC-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
OrOEC-DSC-ACCOUNT !=Zeroes
OrOEC-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
NAME
RELATED 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
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
Price Lists OEPRCLIST Delete Restricted
OEC-COMPANY->OPL-COMPANY
Spaces->OPL-CUSTOMER
  OPL-LIST-NAME
  OPL-PROMOTION


File created: Thu Jun 09 11:09:30 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.