Lawson Insight Technical Documentation |
|
ARCUSTPER
ARCUSTPER FILE
AR Customer Period Totals
The AR Customer Period Totals file contains period end transaction totals for
a customer. Customer Period totals can be viewed in AR75 Customer Summary.
REFERENCED BY
AR251 AR255 AR264 AR271 AR290 AR72.1
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.8 AR301 AR32.1
AR33.1 AR33.3 AR33.6 AR34.1 AR35.1 AR35.2
AR37.1 AR37.2 AR37.3 AR37.4 AR37.5 AR37.6
AR37.7 AR38.1 AR38.2 AR38.3 AR39.1 AR39.2
AR42.1 AR42.2 AR42.6 AR42.7 AR43.1 AR44.3
AR48.3 AR501 AR502 AR504 AR560 AR570
AR575 AR580 AR80.1 AR80.2 AR800 AR82.1
ARLL.1 CB06.2 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 The number representing an AR company. 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.8 AR32.1
AR33.1 AR33.3
AR33.6 AR34.1
AR35.1 AR35.2
AR37.1 AR37.2
AR37.3 AR37.4
AR37.5 AR37.6
AR37.7 AR38.1
AR38.2 AR38.3
AR39.1 AR39.2
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR48.3 AR501
AR502 AR504
AR560 AR570
AR575 AR580
AR80.1 AR80.2
AR800 AR82.1
ARLL.1 CB06.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.8 AR32.1
AR33.1 AR33.3
AR33.6 AR34.1
AR35.1 AR35.2
AR37.1 AR37.2
AR37.3 AR37.4
AR37.5 AR37.6
AR37.7 AR38.1
AR38.2 AR38.3
AR39.1 AR39.2
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR48.3 AR501
AR502 AR504
AR560 AR570
AR575 AR580
AR80.1 AR80.2
AR800 AR82.1
ARLL.1 CB06.2
...
ARP-YEAR Numeric 4 AR115 AR124
Element: Fiscal Period The fiscal year (as defined by the AR129 AR13.1
General Ledger system) for the data AR13.2 AR130
stored on this record. AR131 AR135
AR137 AR180
AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR24.1
AR28.1 AR29.1
AR29.3 AR30.1
AR30.8 AR32.1
AR33.1 AR33.3
AR33.6 AR34.1
AR35.1 AR35.2
AR37.1 AR37.2
AR37.3 AR37.4
AR37.5 AR37.6
AR37.7 AR38.1
AR38.2 AR38.3
AR39.1 AR39.2
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR48.3 AR501
AR502 AR504
AR560 AR570
AR575 AR580
AR80.1 AR80.2
AR800 AR82.1
ARLL.1 CB06.2
...
ARP-PERIOD-BILL Signed 18.2 Occurs 13 Times AR115 AR129
Element: Period Billed The period (as defined by the General AR13.1 AR13.2
Ledger) billed amount for invoices AR130 AR131
entered for this period. AR135 AR137
AR180 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR28.1 AR29.1
AR29.3 AR30.1
AR30.8 AR32.1
AR33.1 AR33.3
AR33.6 AR34.1
AR35.1 AR35.2
AR37.1 AR37.2
AR37.3 AR37.4
AR37.5 AR37.6
AR37.7 AR38.1
AR38.2 AR38.3
AR39.1 AR39.2
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR48.3 AR501
AR502 AR560
AR80.1 AR80.2
AR800 AR82.1
ARLL.1 CB06.2
DT150 DT155
DT160 DT165
DT166 DT180
...
ARP-PERIOD-CRDTS Signed 18.2 Occurs 13 Times AR115 AR129
Element: Period Credit The period (as defined by the General AR130 AR131
Ledger) credit amount for credit memos AR135 AR137
entered for this period. AR180 AR190
AR501 AR502
AR560 AR800
AR82.1 ARLL.1
DT150 DT155
DT160 DT165
DT166 DT180
DT181 DT520
ARP-PERIOD-WROFFS Signed 18.2 Occurs 13 Times AR190 AR501
Period Write Off The period (as defined by the General AR504
Amount Ledger) write-off amount for write-offs
entered for this period.
ARP-PERIOD-PAID Signed 18.2 Occurs 13 Times AR115 AR124
Element: Period Paid AmThe period (as defined by the General AR129 AR130
Ledger) paid amount for payments AR131 AR135
entered for this period. AR137 AR180
AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR24.1
AR30.1 AR32.1
AR34.1 AR501
AR502 AR560
AR570 AR575
AR580 AR800
AR82.1 ARLL.1
CB191 DT150
DT155 DT160
DT165 DT166
DT170 DT180
DT181 DT520
ARP-PERIOD-CHGBKS Signed 18.2 Occurs 13 Times AR115 AR129
Period Chargeback The period (as defined by the General AR13.1 AR13.2
Amount Ledger) chargeback amount for AR130 AR131
chargebacks entered for this period. AR135 AR137
AR180 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR28.1 AR29.1
AR29.3 AR30.1
AR30.8 AR32.1
AR33.1 AR33.3
AR33.6 AR34.1
AR35.1 AR35.2
AR37.1 AR37.2
AR37.3 AR37.4
AR37.5 AR37.6
AR37.7 AR38.1
AR38.2 AR38.3
AR39.1 AR39.2
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR48.3 AR501
AR502 AR560
AR80.1 AR80.2
AR800 AR82.1
ARLL.1 CB06.2
DT150 DT155
DT160 DT165
DT166 DT180
...
ARP-PERIOD-EA-DISC Signed 18.2 Occurs 13 Times AR115 AR129
Element: Intl Amt AR13.1 AR13.2
AR130 AR131
AR135 AR137
AR180 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR28.1 AR29.1
AR29.3 AR30.1
AR30.8 AR32.1
AR33.1 AR33.3
AR33.6 AR34.1
AR35.1 AR35.2
AR37.1 AR37.2
AR37.3 AR37.4
AR37.5 AR37.6
AR37.7 AR38.1
AR38.2 AR38.3
AR39.1 AR39.2
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR48.3 AR501
AR502 AR560
AR80.1 AR80.2
AR800 AR82.1
ARLL.1 CB06.2
DT150 DT155
DT160 DT165
DT166 DT180
...
ARP-PERIOD-UE-DISC Signed 18.2 Occurs 13 Times AR115 AR129
Element: Intl Amt AR13.1 AR13.2
AR130 AR131
AR135 AR137
AR180 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR28.1 AR29.1
AR29.3 AR30.1
AR30.8 AR32.1
AR33.1 AR33.3
AR33.6 AR34.1
AR35.1 AR35.2
AR37.1 AR37.2
AR37.3 AR37.4
AR37.5 AR37.6
AR37.7 AR38.1
AR38.2 AR38.3
AR39.1 AR39.2
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR48.3 AR501
AR502 AR560
AR80.1 AR80.2
AR800 AR82.1
ARLL.1 CB06.2
DT150 DT155
DT160 DT165
DT166 DT180
...
ARCUSTPER FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ARPSET1 COMPANY AR10.1 AR115
CUSTOMER 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 AR264
AR271 AR28.1
AR29.1 AR29.3
AR290 AR30.1
AR30.8 AR301
AR32.1 AR33.1
...
|