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
| 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 |
|
| NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||
|---|---|---|---|---|---|---|---|---|---|
| OECSET1 |
COMPANY |
|
|||||||
| RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Arcomp | ARCOMP |
Not Required
| ||||||||||||||||||||||||||||||
| Cucodes | CUCODES |
Required
| ||||||||||||||||||||||||||||||
| Exp Acct | GLMASTER |
Required
| ||||||||||||||||||||||||||||||
| Glsystem | GLSYSTEM |
Required
| ||||||||||||||||||||||||||||||
| Iccompany | ICCOMPANY |
Required
| ||||||||||||||||||||||||||||||
| Itemgroup | ITEMGROUP |
Required
| ||||||||||||||||||||||||||||||
| Misc Cgs Acct | GLMASTER |
Required
| ||||||||||||||||||||||||||||||
| Misc Sls Acct | GLMASTER |
Required
| ||||||||||||||||||||||||||||||
| Oereason | OEREASON |
Required
| ||||||||||||||||||||||||||||||
| Ord Disc Acct | GLMASTER |
Required
| ||||||||||||||||||||||||||||||
| Sales Account | GLMASTER |
Required
|
| RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Coline | COLINE |
Delete Restricted
| |||||||||||||||
| Custorder | CUSTORDER |
Delete Restricted
| |||||||||||||||
| Oebases | OEBASE |
Delete Restricted
| |||||||||||||||
| Oecompref | OECOMPREF |
| |||||||||||||||
| Oediscount | OEDISCOUNT |
Delete Restricted
| |||||||||||||||
| Oefrtcode | OEFRTCODE |
| |||||||||||||||
| Oeinvoice | OEINVOICE |
| |||||||||||||||
| Oeprclist | OEPRCLIST |
Delete Restricted
| |||||||||||||||
| Oeproclev | OEPROCLEV |
Delete Restricted
| |||||||||||||||
| Price Lists | OEPRCLIST |
Delete Restricted
|
All trademarks and registered trademarks are the property of their
respective owners.