Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

OECOMPREF


                             OECOMPREF FILE

                           Company Reference

Used to store incrementing and fixed reference values fo various processing in
Order Entry and Billing applications.

REFERENCED BY

AR42.2    AR42.7    AR560     BR11.1    PHI3.1    WH20.7

UPDATED BY

BLI1.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

OEL-COMPANY            Numeric 4
Element: Company       The company number represents an
                       established company and is entered on
                       all function codes.

OEL-PROCESS-LEVEL      Alpha 5
Element: Process Level This field contains the process level,
                       which is the reporting hierarchy below
                       company.

OEL-LST-ORD-NBR        Numeric 8                                 BLI1.1
Element: Order Number  Number of the last order placed
                       throughout the company.

OEL-LST-INVC-NBR       Numeric 8                                 BLI1.1
Element: Invc Number   Number of last invoice created
                       throughout the company.

OEL-LST-RECUR-INVC     Numeric 8                                 BLI1.1
Element: Invc Number   This field contains the number of the
                       last recurring invoice created
                       throughout the company.

OEL-LST-CM-NBR         Numeric 8                                 BLI1.1
Element: Lst Cm Nbr    Number of the last credit memo created
                       throughout the company.

OEL-LST-INVC-BTCH      Numeric 6                                 BLI1.1
Element: Batch Number  The number of the last invoice batch
                       produced by the system for this company.

OEL-LST-AR-BATCH       Numeric 6                                 BLI1.1
Element: Lst Ar Batch  The last Accounts Receivable batch of
                       invoices that was used by the system.

OEL-CM-PREFIX          Alpha 2
Element: Cm Prefix     Credit memo prefix is assigned from
                       either the company or process level
                       depending on an invoicing option
                       established for the company.  This is
                       simply a unique two-character prefix
                       that will precede the credit memo number
                       for all credit memos created.

OEL-INVC-PREFIX        Alpha 2
Element: Invoice PrefixInvoice prefix that is assigned from
                       either the company or process level,
                       depending on the invoice-level option
                       chosen.  This is simply a unique
                       two-character prefix that will precede
                       the invoice number for all invoces
                       created by the system.

OEL-RECUR-PREFIX       Alpha 2
Element: Invoice PrefixThis field contains the recurring
                       invoice prefix that is assigned from
                       either the company or process level,
                       based on a company-level option.

OEL-LST-RET-NBR        Numeric 10                                BLI1.1
Element: Return Number

OEL-LST-AUTH-BATCH     Numeric 8                                 BLI1.1
Element: Last Batch NumLast credit card authorization batch
                       number. Credit card orders and resulting
                       authorization requests are assigned
                       these numbers upon order release.m

OEL-LST-TRANS-ID       Numeric 8                                 BLI1.1
Element: Lst Trans Id

                         OECOMPREF FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

OELSET1   COMPANY                                                AR42.2  AR42.7
          PROCESS-LEVEL                                          AR560   BLI1.1
                                                                 BR11.1  PHI3.1
                                                                 WH20.7