ARCUSTPER FILE
AR Customer Period Totals
AR Customer Period Totals
REFERENCED BY
AR251 AR255 AR271 AR290 AR75.1
UPDATED BY
AR10.1 AR115 AR124 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 AR501
AR502 AR504 AR560 AR570 AR575 AR580
AR82.1 AR973 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 AR13.1 AR13.2
customer in the AR Company file. 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 AR501
AR502 AR504
AR560 AR570
AR575 AR580
AR82.1 AR973
CB191 DT150
DT155 DT160
DT165 DT166
DT170 DT180
DT181 DT30.1
DT30.2 DT40.1
...
ARP-CUSTOMER Alpha 9 (Right Justified) AR115 AR124
Customer Customer number. 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 AR501
AR502 AR504
AR560 AR570
AR575 AR580
AR82.1 AR973
CB191 DT150
DT155 DT160
DT165 DT166
DT170 DT180
DT181 DT30.1
DT30.2 DT40.1
...
ARP-YEAR Numeric 4 AR115 AR124
Fiscal Period The fiscal year for the data stored on AR13.1 AR13.2
this record. 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 AR501
AR502 AR504
AR560 AR570
AR575 AR580
AR82.1 AR973
CB191 DT150
DT155 DT160
DT165 DT166
DT170 DT180
DT181 DT30.1
DT30.2 DT40.1
...
ARP-PERIOD-BILL Signed 15.2 Occurs 13 Times AR115 AR13.1
Period Billed Amount The period billed amount for invoices AR13.2 AR130
entered for this period. 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 AR501
AR502 AR560
AR82.1 AR973
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 AR130
Period Credit Amount The period credit amount for credit AR131 AR135
memos entered for this period. AR137 AR180
AR190 AR43.1
AR501 AR502
AR560 AR82.1
AR973 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 AR973
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 AR130 AR131
entered for this period. AR135 AR137
AR180 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR30.1
AR30.2 AR30.4
AR43.1 AR501
AR502 AR560
AR570 AR575
AR580 AR82.1
AR973 CB191
DT150 DT155
DT160 DT165
DT166 DT170
DT180 DT181
DT520
ARP-PERIOD-CHGBKS Signed 15.2 Occurs 13 Times AR115 AR13.1
Period Chargeback The period chargeback amount for AR13.2 AR130
Amount chargebacks entered for this period. 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 AR501
AR502 AR560
AR82.1 AR973
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 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
...
|