Lawson Insight Technical Documentation |
|
ARSUMMARY
ARSUMMARY FILE
Transaction Activity
The Transaction Activity file contains totals by process level of accounts
receivable activity. Current, period, and year to date amount totals are
maintained.
REFERENCED BY
AR02.1
UPDATED BY
AR115 AR124 AR137 AR194 AR195 AR199
AR20.1 AR21.1 AR21.2 AR21.3 AR24.1 AR29.2
AR30.1 AR32.1 AR34.1 AR42.1 AR42.2 AR42.7
AR43.1 AR502 AR503 AR504 AR560 AR570
AR575 AR580 AR82.1 ARLL.1 CB191 DT180
DT181 DT185 DT45.1 DT70.1 DT80.1 DT85.1
DT85.2 DT90.1 DT92.1 AR01.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ARS-COMPANY Numeric 4 AR115 AR124
Element: Company The number representing an AR company. AR137 AR194
AR195 AR199
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR32.1
AR34.1 AR42.1
AR42.2 AR42.7
AR43.1 AR502
AR503 AR504
AR560 AR570
AR575 AR580
AR82.1 ARLL.1
CB191 DT180
DT181 DT185
DT45.1 DT70.1
DT80.1 DT85.1
DT85.2 DT90.1
DT92.1
ARS-PROCESS-LEVEL Alpha 5 AR115 AR124
Element: Process Level This field contains the process level, AR137 AR194
which is the reporting hierarchy below AR195 AR199
company. AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR32.1
AR34.1 AR42.1
AR42.2 AR42.7
AR43.1 AR502
AR503 AR504
AR560 AR570
AR575 AR580
AR82.1 ARLL.1
CB191 DT180
DT181 DT185
DT45.1 DT70.1
DT80.1 DT85.1
DT85.2 DT90.1
DT92.1
ARS-TYPE Alpha 2 AR115 AR124
Transaction Type is the breakout level of AR137 AR194
Activity Level transaction activity for the process AR195 AR199
level. Valid values are: AR20.1 AR21.1
AR21.2 AR21.3
01 = Invoiced AR24.1 AR29.2
02 = Debits/Credits AR30.1 AR32.1
03 = Payments/Charges AR34.1 AR42.1
04 = Non-AR Payments Entered AR42.2 AR42.7
05 = Beginning Balance AR43.1 AR502
06 = Chargebacks AR503 AR504
07 = Discounts AR560 AR570
08 = Shorts/Write-Offs AR575 AR580
09 = Gain/Loss AR82.1 ARLL.1
10 = Cashed Bills of Exchange CB191 DT180
DT181 DT185
DT45.1 DT70.1
DT80.1 DT85.1
DT85.2 DT90.1
DT92.1
ARS-TODAYS-AMT Signed 18.2 AR115 AR124
Element: Current AmountThis is the total amount of activity AR137 AR194
since the last running of AR194 (Audit AR195 AR20.1
Summary). AR21.1 AR21.2
AR21.3 AR24.1
AR29.2 AR30.1
AR32.1 AR34.1
AR42.1 AR42.2
AR42.7 AR43.1
AR502 AR503
AR504 AR560
AR570 AR575
AR580 AR82.1
ARLL.1 CB191
DT180 DT181
DT45.1 DT70.1
DT80.1 DT85.1
DT85.2 DT90.1
DT92.1
ARS-PERIOD-AMT Signed 18.2 AR115 AR124
Element: Period Amount This is the total amount of activity AR137 AR195
for the current period since the last AR199 AR20.1
running of AR199 (Period Closing). AR21.1 AR21.2
AR21.3 AR24.1
AR29.2 AR30.1
AR32.1 AR34.1
AR42.1 AR42.2
AR42.7 AR43.1
AR502 AR503
AR504 AR560
AR570 AR575
AR580 AR82.1
ARLL.1 CB191
DT180 DT181
DT45.1 DT70.1
DT80.1 DT85.1
DT85.2 DT90.1
DT92.1
ARS-CURR-YR-AMT Signed 18.2 AR115 AR124
Element: Intl Amt This is the total amount of activity AR137 AR195
for the current year since the last AR199 AR20.1
running of AR199 (Period Closing) with AR21.1 AR21.2
year-end option. AR21.3 AR24.1
AR29.2 AR30.1
AR32.1 AR34.1
AR42.1 AR42.2
AR42.7 AR43.1
AR502 AR503
AR504 AR560
AR570 AR575
AR580 AR82.1
ARLL.1 CB191
DT180 DT181
DT45.1 DT70.1
DT80.1 DT85.1
DT85.2 DT90.1
DT92.1
ARS-PREV-DATE Numeric 8 (yyyymmdd) AR194
Element: Last Update The last date that this record was
updated.
ARSUMMARY FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ARSSET1 COMPANY AR02.1 AR115
PROCESS-LEVEL AR124 AR137
TYPE AR194 AR195
AR199 AR20.1
AR21.1 AR21.2
AR21.3 AR24.1
AR29.2 AR30.1
AR32.1 AR34.1
AR42.1 AR42.2
AR42.7 AR43.1
AR502 AR503
AR504 AR560
AR570 AR575
AR580 AR82.1
ARLL.1 CB191
...
ARSSET2 COMPANY AR01.1 AR194
TYPE AR199
PROCESS-LEVEL
ARSUMMARY FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Arcomp ARCOMP Required
ARS-COMPANY -> ACO-COMPANY
Arprocesslevel ARPROCLEVL Required
ARS-COMPANY -> APV-COMPANY
ARS-PROCESS-LEVEL -> APV-PROCESS-LEVEL
|