Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             ARCUSTPER FILE

                       AR Customer Period Totals

The AR Customer Period Totals file contains period end totals for a customer.

REFERENCED BY

AR251     AR255     AR271     AR290     AR75.1

UPDATED BY

AR10.1    AR115     AR124     AR129     AR13.1    AR13.2
AR130     AR131     AR135     AR137     AR180     AR190
AR20.1    AR21.1    AR21.2    AR21.3    AR24.1    AR28.1
AR29.1    AR29.3    AR30.1    AR30.2    AR30.3    AR30.4
AR30.8    AR301     AR31.6    AR35.1    AR35.2    AR37.1
AR37.2    AR37.3    AR37.4    AR37.5    AR37.6    AR37.7
AR42.1    AR42.2    AR42.6    AR42.7    AR43.1    AR44.3
AR48.3    AR501     AR502     AR504     AR560     AR570
AR575     AR580     AR82.1    CB191     DT150     DT155
DT160     DT165     DT166     DT170     DT180     DT181
DT30.1    DT30.2    DT40.1    DT45.1    DT520     DT60.1
DT60.2    DT70.1    DT70.3    DT80.1    DT85.1    DT85.2
DT90.1    DT92.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

ARP-COMPANY          Numeric 4                                   AR115   AR124
Company              Company number. Must be a valid             AR129   AR13.1
                     customer in the AR Company file.            AR13.2  AR130
                                                                 AR131   AR135
                                                                 AR137   AR180
                                                                 AR190   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR24.1
                                                                 AR28.1  AR29.1
                                                                 AR29.3  AR30.1
                                                                 AR30.2  AR30.3
                                                                 AR30.4  AR30.8
                                                                 AR31.6  AR35.1
                                                                 AR35.2  AR37.1
                                                                 AR37.2  AR37.3
                                                                 AR37.4  AR37.5
                                                                 AR37.6  AR37.7
                                                                 AR42.1  AR42.2
                                                                 AR42.6  AR42.7
                                                                 AR43.1  AR44.3
                                                                 AR48.3  AR501
                                                                 AR502   AR504
                                                                 AR560   AR570
                                                                 AR575   AR580
                                                                 AR82.1  CB191
                                                                 DT150   DT155
                                                                 DT160   DT165
                                                                 DT166   DT170
                                                                 DT180   DT181
                                                                 DT30.1  DT30.2
                                                                 ...

ARP-CUSTOMER         Alpha 9  (Right Justified)                  AR115   AR124
Customer             Customer number.                            AR129   AR13.1
                                                                 AR13.2  AR130
                                                                 AR131   AR135
                                                                 AR137   AR180
                                                                 AR190   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR24.1
                                                                 AR28.1  AR29.1
                                                                 AR29.3  AR30.1
                                                                 AR30.2  AR30.3
                                                                 AR30.4  AR30.8
                                                                 AR31.6  AR35.1
                                                                 AR35.2  AR37.1
                                                                 AR37.2  AR37.3
                                                                 AR37.4  AR37.5
                                                                 AR37.6  AR37.7
                                                                 AR42.1  AR42.2
                                                                 AR42.6  AR42.7
                                                                 AR43.1  AR44.3
                                                                 AR48.3  AR501
                                                                 AR502   AR504
                                                                 AR560   AR570
                                                                 AR575   AR580
                                                                 AR82.1  CB191
                                                                 DT150   DT155
                                                                 DT160   DT165
                                                                 DT166   DT170
                                                                 DT180   DT181
                                                                 DT30.1  DT30.2
                                                                 ...

ARP-YEAR             Numeric 4                                   AR115   AR124
Fiscal Period        The fiscal year for the data stored on      AR129   AR13.1
                     this record.                                AR13.2  AR130
                                                                 AR131   AR135
                                                                 AR137   AR180
                                                                 AR190   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR24.1
                                                                 AR28.1  AR29.1
                                                                 AR29.3  AR30.1
                                                                 AR30.2  AR30.3
                                                                 AR30.4  AR30.8
                                                                 AR31.6  AR35.1
                                                                 AR35.2  AR37.1
                                                                 AR37.2  AR37.3
                                                                 AR37.4  AR37.5
                                                                 AR37.6  AR37.7
                                                                 AR42.1  AR42.2
                                                                 AR42.6  AR42.7
                                                                 AR43.1  AR44.3
                                                                 AR48.3  AR501
                                                                 AR502   AR504
                                                                 AR560   AR570
                                                                 AR575   AR580
                                                                 AR82.1  CB191
                                                                 DT150   DT155
                                                                 DT160   DT165
                                                                 DT166   DT170
                                                                 DT180   DT181
                                                                 DT30.1  DT30.2
                                                                 ...

ARP-PERIOD-BILL      Signed 15.2 Occurs 13 Times                 AR115   AR129
Period Billed Amount The period billed amount for invoices       AR13.1  AR13.2
                     entered for this period.                    AR130   AR131
                                                                 AR135   AR137
                                                                 AR180   AR190
                                                                 AR28.1  AR29.1
                                                                 AR29.3  AR30.1
                                                                 AR30.2  AR30.3
                                                                 AR30.4  AR30.8
                                                                 AR31.6  AR35.1
                                                                 AR35.2  AR37.1
                                                                 AR37.2  AR37.3
                                                                 AR37.4  AR37.5
                                                                 AR37.6  AR37.7
                                                                 AR42.1  AR42.2
                                                                 AR42.6  AR42.7
                                                                 AR43.1  AR44.3
                                                                 AR48.3  AR501
                                                                 AR502   AR560
                                                                 AR82.1  DT150
                                                                 DT155   DT160
                                                                 DT165   DT166
                                                                 DT180   DT181
                                                                 DT30.1  DT30.2
                                                                 DT40.1  DT45.1
                                                                 DT520   DT60.1
                                                                 DT60.2  DT70.1
                                                                 DT70.3  DT80.1
                                                                 DT85.1  DT85.2
                                                                 DT90.1  DT92.1

ARP-PERIOD-CRDTS     Signed 15.2 Occurs 13 Times                 AR115   AR129
Period Credit Amount The period credit amount for credit         AR130   AR131
                     memos entered for this period.              AR135   AR137
                                                                 AR180   AR190
                                                                 AR501   AR502
                                                                 AR560   AR82.1
                                                                 DT150   DT155
                                                                 DT160   DT165
                                                                 DT166   DT180
                                                                 DT181   DT520

ARP-PERIOD-WROFFS    Signed 15.2 Occurs 13 Times                 AR190   AR501
Period Write Off     The period write-off amount for             AR504
Amount               write-offs entered for this period.

ARP-PERIOD-PAID      Signed 15.2 Occurs 13 Times                 AR115   AR124
Period Paid Amount   The period paid amount for payments         AR129   AR130
                     entered for this period.                    AR131   AR135
                                                                 AR137   AR180
                                                                 AR190   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR24.1
                                                                 AR30.1  AR30.2
                                                                 AR30.4  AR501
                                                                 AR502   AR560
                                                                 AR570   AR575
                                                                 AR580   AR82.1
                                                                 CB191   DT150
                                                                 DT155   DT160
                                                                 DT165   DT166
                                                                 DT170   DT180
                                                                 DT181   DT520

ARP-PERIOD-CHGBKS    Signed 15.2 Occurs 13 Times                 AR115   AR129
Period Chargeback    The period chargeback amount for            AR13.1  AR13.2
Amount               chargebacks entered for this period.        AR130   AR131
                                                                 AR135   AR137
                                                                 AR180   AR190
                                                                 AR28.1  AR29.1
                                                                 AR29.3  AR30.1
                                                                 AR30.2  AR30.3
                                                                 AR30.4  AR30.8
                                                                 AR31.6  AR35.1
                                                                 AR35.2  AR37.1
                                                                 AR37.2  AR37.3
                                                                 AR37.4  AR37.5
                                                                 AR37.6  AR37.7
                                                                 AR42.1  AR42.2
                                                                 AR42.6  AR42.7
                                                                 AR43.1  AR44.3
                                                                 AR48.3  AR501
                                                                 AR502   AR560
                                                                 AR82.1  DT150
                                                                 DT155   DT160
                                                                 DT165   DT166
                                                                 DT180   DT181
                                                                 DT30.1  DT30.2
                                                                 DT40.1  DT45.1
                                                                 DT520   DT60.1
                                                                 DT60.2  DT70.1
                                                                 DT70.3  DT80.1
                                                                 DT85.1  DT85.2
                                                                 DT90.1  DT92.1

                         ARCUSTPER FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ARPSET1   COMPANY       The path is used to keep records         AR10.1  AR115
          CUSTOMER      unique.                                  AR124   AR129
          YEAR                                                   AR13.1  AR13.2
                                                                 AR130   AR131
                                                                 AR135   AR137
                                                                 AR180   AR190
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR24.1  AR251
                                                                 AR255   AR271
                                                                 AR28.1  AR29.1
                                                                 AR29.3  AR290
                                                                 AR30.1  AR30.2
                                                                 AR30.3  AR30.4
                                                                 AR30.8  AR301
                                                                 ...