Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                             APDFTSTMT FILE

The Draft Statement file contains the AP BOE Draft Statement Number and total
amount of each statement.  Records are created by AP167 and are read and
updated by AP181.

UPDATED BY

AP167     AP181     AP962

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

ADF-CASH-CODE        Alpha 4                                     AP167   AP962
Cash Code            The cash code representing the bank
                     where the BOEs are cashed.

ADF-PAY-GROUP        Alpha 4                                     AP167   AP962
Pay Group            A pay group is used for processing
                     accounts payable payments. A pay group
                     lets you create a single payment for a
                     vendor to pay invoices received by all
                     company process levels assigned to the
                     pay group.


ADF-COMPANY          Numeric 4                                   AP167   AP962
Company              The company number represents an
                     established company and is entered on
                     all function codes.

ADF-STATUS           Numeric 1                                   AP167   AP181
Status               This field contains the status of the       AP962
                     transaction.

ADF-STATEMENT-NBR    Numeric 8                                   AP167   AP962
Statement Nbr        The statement number assigned to a
                     group of BOEs that have been marked as
                     cashed by the bank on the same date by
                     running AP167 (BOE Cashing Statement).

ADF-BANK-INST-CODE   Alpha 3                                     AP167   AP962
Transaction Code     A transaction code that represents a
                     type  bill of exchange payment.

ADF-STATEMENT-DATE   Numeric 8  (yyyymmdd)                       AP167   AP962
Statement Date       The date on which the BOEs are cashed
                     by the bank.

ADF-STMT-TRAN-AMT    Signed 15.2                                 AP167   AP962
Stmt Tran Amt        The total amount of the BOEs in the
                     statement in the bank currency.

ADF-STMT-BASE-AMT    Signed 15.2                                 AP167   AP962
Stmt Base Amt        The total amount of the BOEs in the
                     statement in base company currency.

                         APDFTSTMT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ADFSET1   CASH-CODE     This index is used to access the         AP181   AP962
          PAY-GROUP     statement information for a cash code
          STATEMENT-NBR and pay group.
          COMPANY

ADFSET2   CASH-CODE     This index is sued to access bill of
          COMPANY       exchange statements for a cash code and
          STATEMENT-NBR company.