 |
Lawson Insight Technical Documentation |
|
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
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 AR115 AR124
CUSTOMER unique. AR129 AR13.1
YEAR 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 AR31.6
...
|