Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                            ARICUSTPER FILE

                       Customer Period Conversion

Customer Period Conversion

UPDATED BY

AR501     AR98.2

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

AIE-COMPANY          Numeric 4                                   AR98.2
Company              Required. Customer company number.

AIE-CUSTOMER         Alpha 9  (Right Justified)                  AR98.2
Customer             Required. This field contains the
                     number that represents a customer.

AIE-YEAR             Numeric 4                                   AR98.2
Fiscal Year          Required. The fiscal year for the data
                     stored on this record.

AIE-PERIOD-BILL      Signed 15.2 Occurs 13 Times                 AR98.2
Period Invoiced      Period amount billed (invoiced).
Amount

AIE-PERIOD-CRDTS     Signed 15.2 Occurs 13 Times                 AR98.2
Period Credit Memo   Period credit memo amount.
Amount

AIE-PERIOD-PAID      Signed 15.2 Occurs 13 Times                 AR98.2
Period Paid Amount   Period paid amount.

AIE-PERIOD-WROFFS    Signed 15.2 Occurs 13 Times                 AR98.2
Period Write Off     Period write-off amount.
Amount

AIE-PERIOD-CHGBKS    Signed 15.2 Occurs 13 Times                 AR98.2
Period Chargeback    Period chargeback amount.
Amount

                         ARICUSTPER FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

AIESET1   COMPANY       The path is used to keep the records     AR501   AR98.2
          CUSTOMER      unique.
          YEAR