OECOMPANY – Order Entry Company

System
Billing (BL)
Prefix
OEC
Primary key
COMPANY
Fields
94
Updated by
0 programs
Referenced by
0 programs

OECOMPANY is the Order Entry Company table in Lawson Billing (prefix OEC). It is indexed by COMPANY (OECSET1). It is related 1:1 to ARCOMP, CUCODES, GLMASTER, GLSYSTEM, ICCOMPANY, ITEMGROUP and OEREASON and 1:M to COLINE, CUSTORDER, OEBASE, OECOMPREF, OEDISCOUNT, OEFRTCODE, OEINVOICE, OEPRCLIST and 1 more. The table has 94 fields, 1 index and 21 documented relations.

About OECOMPANY

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.

Fields (94)

Column = COBOL field name without the OEC- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
OEC-COMPANY PK
COMPANY
Numeric 4Identifies 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
NAME
Alpha 30 (Lower Case)Displays the company description.
OEC-ADDR1
ADDR1
Alpha 30 (Lower Case)First line of company address information.
OEC-ADDR2
ADDR2
Alpha 30 (Lower Case)Second line of company address information.
OEC-ADDR3
ADDR3
Alpha 30 (Lower Case)Third line of company address information.
OEC-ADDR4
ADDR4
Alpha 30 (Lower Case)Fourth line of company address information.
OEC-CITY
CITY
Alpha 18 (Lower Case)This field contains the city of the address.
OEC-STATE
STATE
Alpha 2This field contains the two-character state code of the address.
OEC-ZIP
ZIP
Alpha 10This field contains the postal code of the address.
OEC-COUNTRY
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
COUNTY
Alpha 25 (Lower Case)The county for the company address.
OEC-MAN-ORD-FL
MAN_ORD_FL
Alpha 1Flag 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
DEF_REASON
Alpha 4The 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
BTCH_CNTRL_TL
Alpha 1Flag 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
POST_UNITS_FL
Alpha 1Flag 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
SLS_ACCT_UNIT
Alpha 15Default 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
SLS_ACCOUNT
Numeric 6Sales 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
SLS_SUB_ACCT
Numeric 4Sales 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
EXP_ACCT_UNIT
Alpha 15Default 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
EXP_ACCOUNT
Numeric 6Default 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
EXP_SUB_ACCT
Numeric 4Default 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
MI_ACCT_UNIT
Alpha 15Default 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
MI_ACCOUNT
Numeric 6Default 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
MI_SUB_ACCT
Numeric 4Default 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
MCG_ACCT_UNIT
Alpha 15Default 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
MCG_ACCOUNT
Numeric 6Default 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
MCG_SUB_ACCT
Numeric 4Default 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
DSC_ACCT_UNIT
Alpha 15Discount 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
DSC_ACCOUNT
Numeric 6Discount 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
DSC_SUB_ACCT
Numeric 4Discount 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
ROUTE_STOP_FL
Alpha 1Route and stop flag. This indicates whether this company uses route and stop delivery.
  • Y Yes
  • N No
OEC-UOM-REQ-FL
UOM_REQ_FL
Alpha 1This 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
CURRENCY_CODE
Alpha 5This field contains the company's base currency code established in General Ledger.
OEC-MULTI-CURR-FL
MULTI_CURR_FL
Alpha 1This 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
BASE_ND
Numeric 1The number of decimal positions defined for the company base currency.
OEC-CURR-OVR-FL
CURR_OVR_FL
Alpha 1This flag indicates whether or not users can override the default currency when adding an order to the system.
OEC-RATE-OVR-FL
RATE_OVR_FL
Alpha 1This flag indicates whether currency exchange rates can be overridden on transactions.
  • Y Yes
  • N No
OEC-REPRICE-FL
REPRICE_FL
Alpha 1The flag indicates whether to reprice at invoice creation time or not.
  • Y Yes
  • N No
OEC-RATE-FRZ-CD
RATE_FRZ_CD
Alpha 1This 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
PRICE_LOC_FL
Alpha 1The 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
PRICE_CURR_FL
Alpha 1Flag 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
AUDIT_ORD_FL
Alpha 1Audit 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
AUDIT_PRC_FL
Alpha 1Audit 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
ALLOC_DT_FL
Alpha 1This 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
INVC_OPT_FL
Alpha 1Invoice 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
INVC_EDIT_OPT
Alpha 1Option to require running of BL121 (Invoice Print Edit Report) before the invoices are printed and finalized.
  • N No
  • Y Yes
OEC-INTF-COST-FL
INTF_COST_FL
Alpha 1Enter Yes to post cost for an interfaced invoice from another system.
  • Y Yes
  • N No
OEC-COD-INVC-OPT
COD_INVC_OPT
Alpha 1This 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
BL_OPER_CNTRL
Alpha 1A 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
BILL_EQL_INVC
Alpha 1
  • Y Yes
  • N No
OEC-TAX-PRINT-CD
TAX_PRINT_CD
Alpha 1This 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
TAX_PRICE_FL
Alpha 1Flag to indicate that prices include taxes.
  • Y Yes
  • N No
OEC-DISC-AOC-FL
DISC_AOC_FL
Alpha 1Flag to indicate whether add-on charges are included in order level discount calculations.
  • Y Yes
  • N No
OEC-TERMS-AOC-FL
TERMS_AOC_FL
Alpha 1Flag 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
INVC_CR_FL
Alpha 1If 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
INVC_EDIT_FL
Alpha 1If 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
INVC_PRT_FL
Alpha 1If 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
INVC_UPD_FL
Alpha 1If 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
INVC_DTL_FL
Alpha 1This flag indicates whether lots/sublots and serial numbers of items ordered should print on the invoice.
  • N No
  • Y Yes
OEC-REL-COM-OPT
REL_COM_OPT
Alpha 1 Occurs 10 Times ×10An "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
ACK_COM_OPT
Alpha 1 Occurs 10 Times ×10Selecting 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
QTE_COM_OPT
Alpha 1 Occurs 10 Times ×10An "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
JOR_COM_OPT
Alpha 1 Occurs 10 Times ×10An "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
INV_COM_OPT
Alpha 1 Occurs 10 Times ×10An "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
RMT_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
RMT_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
RMT_ADDR2
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
RMT_ADDR3
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
RMT_ADDR4
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
RMT_CITY
Alpha 18Remit-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
RMT_STATE
Alpha 2Remit-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
RMT_ZIP
Alpha 10Remit-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
RMT_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
RMT_COUNTY
Alpha 25 (Lower Case)The county for the company address.
OEC-INCOMPLETE-FL
INCOMPLETE_FL
Alpha 1Company incomplete flag indicates that the company has not been fully added to the system.
OEC-BL-INCOMPL-FL
BL_INCOMPL_FL
Alpha 1This field indicates whether or not setup was completed for the Order Entry company.
  • N No
  • Y Yes
OEC-COM-TYPE-1
COM_TYPE_1
DerivedThis field contains the first comment type.
OEC-MAN-RET-FL
MAN_RET_FL
Alpha 1
OEC-COUNTRY-CODE
COUNTRY_CODE
Alpha 2The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance).
OEC-REGION
REGION
Alpha 2The region code, if applicable for the country. Used by Intrastat. Must be defined in IN02.1 (Region Maintenance)
OEC-EC-CTRY-NBR
EC_CTRY_NBR
Numeric 3The European Community Country number; leave blank if not a member of the European Community.
OEC-ISO-CTRY-NBR
ISO_CTRY_NBR
Numeric 3The ISO country number.
OEC-RMT-CTRY-CODE
RMT_CTRY_CODE
Alpha 2
OEC-RMT-REGION
RMT_REGION
Alpha 2
OEC-RMT-EC-CTRY
RMT_EC_CTRY
Numeric 3
OEC-RMT-ISO-CTRY
RMT_ISO_CTRY
Numeric 3
OEC-BACK-ORD-CNTRL
BACK_ORD_CNTRL
Alpha 1
  • O Order Entry Only
  • W Warehouse Only
  • B Both Order Entry and Warehouse
  • I Ignore
OEC-TERMS-FRT-FL
TERMS_FRT_FL
Alpha 1
OEC-LIMIT-RETURNS
LIMIT_RETURNS
Alpha 1
  • N None
  • D Days
  • S Specific Date
OEC-RETURN-DAYS
RETURN_DAYS
Numeric 6
OEC-RND-ACCT-UNIT
RND_ACCT_UNIT
Alpha 15
OEC-RND-ACCOUNT
RND_ACCOUNT
Numeric 6
OEC-RND-SUB-ACCT
RND_SUB_ACCT
Numeric 4
OEC-RND-FLG
RND_FLG
Alpha 1" " = Blank
  • N None
  • W Nearest whole amount

Indexes (1)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
OECSET1COMPANYPrimaryAC56.1, AC560, AP125, AP126, AP131, AP20.1, AP20.2, AP20.3 +22 more (list truncated in source)

Relations

One to one (11) — lookups and parents

RelationTableRulesConditionField map
ArcompARCOMPNot RequiredOEC-COMPANYACO-COMPANY
CucodesCUCODESRequiredWhen OEC-CURRENCY-CODE != SpacesOEC-CURRENCY-CODECUC-CURRENCY-CODE
Exp AcctGLMASTERRequiredWhen OEC-EXP-ACCT-UNIT != Spaces Or OEC-EXP-ACCOUNT != Zeroes Or OEC-EXP-SUB-ACCT != ZeroesOEC-COMPANYGLM-COMPANY, OEC-EXP-ACCT-UNITGLM-ACCT-UNIT, OEC-EXP-ACCOUNTGLM-ACCOUNT, OEC-EXP-SUB-ACCTGLM-SUB-ACCOUNT
GlsystemGLSYSTEMRequiredOEC-COMPANYGLS-COMPANY
IccompanyICCOMPANYRequiredOEC-COMPANYICC-COMPANY
ItemgroupITEMGROUPRequiredICC-ITEM-GROUPITG-ITEM-GROUP
Misc Cgs AcctGLMASTERRequiredWhen OEC-MCG-ACCT-UNIT != Spaces Or OEC-MCG-ACCOUNT != Zeroes Or OEC-MCG-SUB-ACCT != ZeroesOEC-COMPANYGLM-COMPANY, OEC-MCG-ACCT-UNITGLM-ACCT-UNIT, OEC-MCG-ACCOUNTGLM-ACCOUNT, OEC-MCG-SUB-ACCTGLM-SUB-ACCOUNT
Misc Sls AcctGLMASTERRequiredOEC-COMPANYGLM-COMPANY, OEC-MI-ACCT-UNITGLM-ACCT-UNIT, OEC-MI-ACCOUNTGLM-ACCOUNT, OEC-MI-SUB-ACCTGLM-SUB-ACCOUNT
OereasonOEREASONRequiredWhen OEC-DEF-REASON != SpacesOEC-COMPANYOER-COMPANY, OEC-DEF-REASONOER-REASON-CODE
Ord Disc AcctGLMASTERRequiredWhen OEC-DSC-ACCT-UNIT != Spaces Or OEC-DSC-ACCOUNT != Zeroes Or OEC-DSC-SUB-ACCT != ZeroesOEC-COMPANYGLM-COMPANY, OEC-DSC-ACCT-UNITGLM-ACCT-UNIT, OEC-DSC-ACCOUNTGLM-ACCOUNT, OEC-DSC-SUB-ACCTGLM-SUB-ACCOUNT
Sales AccountGLMASTERRequiredOEC-COMPANYGLM-COMPANY, OEC-SLS-ACCT-UNITGLM-ACCT-UNIT, OEC-SLS-ACCOUNTGLM-ACCOUNT, OEC-SLS-SUB-ACCTGLM-SUB-ACCOUNT

One to many (10) — child tables

RelationTableRulesConditionField map
ColineCOLINEDelete RestrictedOEC-COMPANYCOL-COMPANY, COL-ORDER-NBR, COL-LINE-NBR
CustorderCUSTORDERDelete RestrictedOEC-COMPANYCOR-COMPANY, COR-ORDER-NBR
OebasesOEBASEDelete RestrictedOEC-COMPANYOEB-COMPANY, OEB-LOCATION, OEB-BASE-NAME, OEB-CURRENCY-CODE, OEB-ITEM
OecomprefOECOMPREFOEC-COMPANYOEL-COMPANY, OEL-PROCESS-LEVEL, OEL-TYPE
OediscountOEDISCOUNTDelete RestrictedOEC-COMPANYOED-COMPANY, OED-DISC-CODE
OefrtcodeOEFRTCODEOEC-COMPANYOFR-COMPANY, OFR-FRT-CODE
OeinvoiceOEINVOICEOEC-COMPANYOEI-COMPANY, OEI-INVC-PREFIX, OEI-INVC-NUMBER
OeprclistOEPRCLISTDelete RestrictedOEC-COMPANYOPL-COMPANY, OPL-CUSTOMER, OPL-LIST-NAME, OPL-PROMOTION
OeproclevOEPROCLEVDelete RestrictedOEC-COMPANYOEP-COMPANY, OEP-PROCESS-LEVEL
Price ListsOEPRCLISTDelete RestrictedOEC-COMPANYOPL-COMPANY, SpacesOPL-CUSTOMER, OPL-LIST-NAME, OPL-PROMOTION

Programs

No Lawson programs are documented as updating or referencing this table.