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 / column | Type | Description & values | Updated by |
|---|---|---|---|
OEC-COMPANY PKCOMPANY | 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-NAMENAME | Alpha 30 (Lower Case) | Displays the company description. | — |
OEC-ADDR1ADDR1 | Alpha 30 (Lower Case) | First line of company address information. | — |
OEC-ADDR2ADDR2 | Alpha 30 (Lower Case) | Second line of company address information. | — |
OEC-ADDR3ADDR3 | Alpha 30 (Lower Case) | Third line of company address information. | — |
OEC-ADDR4ADDR4 | Alpha 30 (Lower Case) | Fourth line of company address information. | — |
OEC-CITYCITY | Alpha 18 (Lower Case) | This field contains the city of the address. | — |
OEC-STATESTATE | Alpha 2 | This field contains the two-character state code of the address. | — |
OEC-ZIPZIP | Alpha 10 | This field contains the postal code of the address. | — |
OEC-COUNTRYCOUNTRY | 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-COUNTYCOUNTY | Alpha 25 (Lower Case) | The county for the company address. | — |
OEC-MAN-ORD-FLMAN_ORD_FL | Alpha 1 | Flag indicating whether orders will be manually numbered by the user at entry time or automatically numbered by the system.
| — |
OEC-DEF-REASONDEF_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-TLBTCH_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).
| — |
OEC-POST-UNITS-FLPOST_UNITS_FL | 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.
| — |
OEC-SLS-ACCT-UNITSLS_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-ACCOUNTSLS_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-ACCTSLS_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-UNITEXP_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-ACCOUNTEXP_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-ACCTEXP_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-UNITMI_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-ACCOUNTMI_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-ACCTMI_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-UNITMCG_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-ACCOUNTMCG_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-ACCTMCG_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-UNITDSC_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-ACCOUNTDSC_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-ACCTDSC_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-FLROUTE_STOP_FL | Alpha 1 | Route and stop flag. This indicates whether this company uses route and stop delivery.
| — |
OEC-UOM-REQ-FLUOM_REQ_FL | Alpha 1 | This flag indicates whether users will be required to enter the unit of measure for each item when adding an order.
| — |
OEC-CURRENCY-CODECURRENCY_CODE | Alpha 5 | This field contains the company's base currency code established in General Ledger. | — |
OEC-MULTI-CURR-FLMULTI_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.
| — |
OEC-BASE-NDBASE_ND | Numeric 1 | The number of decimal positions defined for the company base currency. | — |
OEC-CURR-OVR-FLCURR_OVR_FL | Alpha 1 | This flag indicates whether or not users can override the default currency when adding an order to the system. | — |
OEC-RATE-OVR-FLRATE_OVR_FL | Alpha 1 | This flag indicates whether currency exchange rates can be overridden on transactions.
| — |
OEC-REPRICE-FLREPRICE_FL | Alpha 1 | The flag indicates whether to reprice at invoice creation time or not.
| — |
OEC-RATE-FRZ-CDRATE_FRZ_CD | Alpha 1 | This value indicates when the system should freeze the currency rate used on the transaction.
| — |
OEC-PRICE-LOC-FLPRICE_LOC_FL | 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.
| — |
OEC-PRICE-CURR-FLPRICE_CURR_FL | Alpha 1 | Flag indicating if pricing is to be done in the cost-based currency or the currency used when placing the order.
| — |
OEC-AUDIT-ORD-FLAUDIT_ORD_FL | 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.
| — |
OEC-AUDIT-PRC-FLAUDIT_PRC_FL | 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).
| — |
OEC-ALLOC-DT-FLALLOC_DT_FL | Alpha 1 | This value identifies which date on the order the system should use when determining what to allocate.
| — |
OEC-INVC-OPT-FLINVC_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.
| — |
OEC-INVC-EDIT-OPTINVC_EDIT_OPT | Alpha 1 | Option to require running of BL121 (Invoice Print Edit Report) before the invoices are printed and finalized.
| — |
OEC-INTF-COST-FLINTF_COST_FL | Alpha 1 | Enter Yes to post cost for an interfaced invoice from another system.
| — |
OEC-COD-INVC-OPTCOD_INVC_OPT | 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.
| — |
OEC-BL-OPER-CNTRLBL_OPER_CNTRL | 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).
| — |
OEC-BILL-EQL-INVCBILL_EQL_INVC | Alpha 1 | —
| — |
OEC-TAX-PRINT-CDTAX_PRINT_CD | Alpha 1 | This code determines whether the tax lines should print in summary or detail on the invoice.
| — |
OEC-TAX-PRICE-FLTAX_PRICE_FL | Alpha 1 | Flag to indicate that prices include taxes.
| — |
OEC-DISC-AOC-FLDISC_AOC_FL | Alpha 1 | Flag to indicate whether add-on charges are included in order level discount calculations.
| — |
OEC-TERMS-AOC-FLTERMS_AOC_FL | 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.
| — |
OEC-INVC-CR-FLINVC_CR_FL | 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.
| — |
OEC-INVC-EDIT-FLINVC_EDIT_FL | 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.
| — |
OEC-INVC-PRT-FLINVC_PRT_FL | 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.
| — |
OEC-INVC-UPD-FLINVC_UPD_FL | 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.
| — |
OEC-INVC-DTL-FLINVC_DTL_FL | Alpha 1 | This flag indicates whether lots/sublots and serial numbers of items ordered should print on the invoice.
| — |
OEC-REL-COM-OPTREL_COM_OPT | Alpha 1 Occurs 10 Times ×10 | 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-OPTACK_COM_OPT | Alpha 1 Occurs 10 Times ×10 | 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-OPTQTE_COM_OPT | Alpha 1 Occurs 10 Times ×10 | 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-OPTJOR_COM_OPT | Alpha 1 Occurs 10 Times ×10 | 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-OPTINV_COM_OPT | Alpha 1 Occurs 10 Times ×10 | 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-NAMERMT_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-ADDR1RMT_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-ADDR2RMT_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-ADDR3RMT_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-ADDR4RMT_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-CITYRMT_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-STATERMT_STATE | 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-ZIPRMT_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-COUNTRYRMT_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-COUNTYRMT_COUNTY | Alpha 25 (Lower Case) | The county for the company address. | — |
OEC-INCOMPLETE-FLINCOMPLETE_FL | Alpha 1 | Company incomplete flag indicates that the company has not been fully added to the system. | — |
OEC-BL-INCOMPL-FLBL_INCOMPL_FL | Alpha 1 | This field indicates whether or not setup was completed for the Order Entry company.
| — |
OEC-COM-TYPE-1COM_TYPE_1 | Derived | This field contains the first comment type. | — |
OEC-MAN-RET-FLMAN_RET_FL | Alpha 1 | — | — |
OEC-COUNTRY-CODECOUNTRY_CODE | Alpha 2 | The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance). | — |
OEC-REGIONREGION | Alpha 2 | The region code, if applicable for the country. Used by Intrastat. Must be defined in IN02.1 (Region Maintenance) | — |
OEC-EC-CTRY-NBREC_CTRY_NBR | Numeric 3 | The European Community Country number; leave blank if not a member of the European Community. | — |
OEC-ISO-CTRY-NBRISO_CTRY_NBR | Numeric 3 | The ISO country number. | — |
OEC-RMT-CTRY-CODERMT_CTRY_CODE | Alpha 2 | — | — |
OEC-RMT-REGIONRMT_REGION | Alpha 2 | — | — |
OEC-RMT-EC-CTRYRMT_EC_CTRY | Numeric 3 | — | — |
OEC-RMT-ISO-CTRYRMT_ISO_CTRY | Numeric 3 | — | — |
OEC-BACK-ORD-CNTRLBACK_ORD_CNTRL | Alpha 1 | —
| — |
OEC-TERMS-FRT-FLTERMS_FRT_FL | Alpha 1 | — | — |
OEC-LIMIT-RETURNSLIMIT_RETURNS | Alpha 1 | —
| — |
OEC-RETURN-DAYSRETURN_DAYS | Numeric 6 | — | — |
OEC-RND-ACCT-UNITRND_ACCT_UNIT | Alpha 15 | — | — |
OEC-RND-ACCOUNTRND_ACCOUNT | Numeric 6 | — | — |
OEC-RND-SUB-ACCTRND_SUB_ACCT | Numeric 4 | — | — |
OEC-RND-FLGRND_FLG | Alpha 1 | " " = Blank
| — |
Indexes (1)
Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
OECSET1 | COMPANY | Primary | AC56.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
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| 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 |
One to many (10) — child tables
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| 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 |
Programs
No Lawson programs are documented as updating or referencing this table.