Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             OECOMPREF FILE

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
Company              The company number represents an
                     established company and is entered on
                     all function codes.


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


OEL-LST-ORD-NBR      Numeric 8                                   BLI1.1
Lst Ord Nbr          Number of the last order placed
                     throughout the company.

OEL-LST-INVC-NBR     Numeric 8                                   BLI1.1
Last Invoice Number  Number of last invoice created
                     throughout the company.

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

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

OEL-LST-INVC-BTCH    Numeric 6                                   BLI1.1
Lst Invc Btch        The number of the last invoice batch
                     produced by the system for this company.

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

OEL-CM-PREFIX        Alpha 2
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
Invoice Prefix       Invoice 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
Recur Prefix         This 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
Lst Ret Nbr

OEL-LST-AUTH-BATCH   Numeric 8                                   BLI1.1
Lst Auth Batch       Last 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
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