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	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	CB191	MA41.1	MA41.2	MA41.4	MA41.7
MA43.1	MA43.2	MA43.3	MA43.4	MA43.6	MA43.7
MAI1.1	PO136	PO190	PO300	PO520	POCP.1
POI3.1	POII.1	POIJ.1	TX00.1	TX140

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

OECOMPANY FILE RELATIONS

ONE TO ONE RELATIONS

OECOMPANY FILE RELATIONS

ONE TO MANY RELATIONS

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