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 AR199 AR20.1
AR21.1 AR21.2 AR21.3 AR24.1 AR29.2 AR30.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 Company number. AR137 AR194
AR199 AR20.1
AR21.1 AR21.2
AR21.3 AR24.1
AR29.2 AR30.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 AR199 AR20.1
company. AR21.1 AR21.2
AR21.3 AR24.1
AR29.2 AR30.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 AR199 AR20.1
level. Valid values are: AR21.1 AR21.2
AR21.3 AR24.1
01 = Invoiced AR29.2 AR30.1
02 = Debits/Credits AR34.1 AR42.1
03 = Payments/Charges AR42.2 AR42.7
04 = Non-AR Payments Entered AR43.1 AR502
05 = Beginning Balance AR503 AR504
06 = Chargebacks AR560 AR570
07 = Discounts AR575 AR580
08 = Shorts/Write-Offs AR82.1 ARLL.1
09 = Gain/Loss CB191 DT180
10 = Cashed Bills of Exchange 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 AR20.1 AR21.1
Summary). AR21.2 AR21.3
AR24.1 AR29.2
AR30.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 AR199
for the current period since the last AR20.1 AR21.1
running of AR199 (Period Closing). AR21.2 AR21.3
AR24.1 AR29.2
AR30.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 AR199
for the current year since the last AR20.1 AR21.1
running of AR199 (Period Closing) with AR21.2 AR21.3
year-end option. AR24.1 AR29.2
AR30.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 This path is used for record uniqueness AR02.1 AR115
PROCESS-LEVEL and record selection. AR124 AR137
TYPE AR194 AR199
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.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
...
ARSSET2 COMPANY This path is used to select records in AR01.1 AR194
TYPE type order.
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
|