Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ARCUSTPER


                             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
Element: 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
Element: 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
Element: 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
Element: Period Billed 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
Element: Period Credit 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
Element: Period Paid AmThe 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
                                                                 ...