Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

APRECON


                              APRECON FILE

                     Invoice Accrual Reconciliation

The Invoice Accrual Reconciliation file contains records of the dates that
AP260 (Invoice Accrual Reconciliation) has been run for a company. AP260 uses
the information in this file and the reconcile date field on the Accounts
Payable Invoice file to determine which invoice records to process.

UPDATED BY

AP136

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

APN-COMPANY            Numeric 4                                 AP136
Element: Company       The accounts payable company number
                       used to run AP260 (Invoice Accrual
                       Reconciliation). Must be a valid record
                       in the Accounts Payable Company file.

APN-RECON-DATE         Numeric 8  (yyyymmdd)                     AP136
Element: Recon Date    The reconciliation date used to run
                       AP260 (Invoice Accrual Reconciliation)
                       for the company.

APN-ACCR-CODE          Alpha 4                                   AP136
Element: Accr Code     A user-defined code representing a
                       general ledger accrual account.

APN-INV-CURRENCY       Alpha 5                                   AP136
Element: To Base Curr

                         APRECON FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

APNSET1   COMPANY                                                AP136
          RECON-DATE
          ACCR-CODE
          INV-CURRENCY

APNSET3   COMPANY       KeyChange, Subset                        AP136
          RECON-DATE    Where (INV-CURRENCY = Spaces )
          ACCR-CODE

APNSET4   COMPANY       KeyChange, Subset                        AP136
          RECON-DATE    Where (ACCR-CODE = Spaces )
          INV-CURRENCY