 |
Lawson Insight Technical Documentation |
|
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 AR190 AR194 AR199
AR20.1 AR21.1 AR21.2 AR21.3 AR24.1 AR29.2
AR30.1 AR30.2 AR30.4 AR42.1 AR42.2 AR42.7
AR43.1 AR502 AR503 AR504 AR560 AR570
AR575 AR580 AR82.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
Company Company number. AR137 AR190
AR194 AR199
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR30.2
AR30.4 AR42.1
AR42.2 AR42.7
AR43.1 AR502
AR503 AR504
AR560 AR570
AR575 AR580
AR82.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
Process Level This field contains the process level, AR137 AR190
which is the reporting hierarchy below AR194 AR199
company. AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR30.2
AR30.4 AR42.1
AR42.2 AR42.7
AR43.1 AR502
AR503 AR504
AR560 AR570
AR575 AR580
AR82.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 AR190
Activity Level transaction activity for the process AR194 AR199
level. Valid values are: AR20.1 AR21.1
AR21.2 AR21.3
01 = Invoiced AR24.1 AR29.2
02 = Debits/Credits AR30.1 AR30.2
03 = Payments/Charges AR30.4 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 CB191
10 = Cashed Bills of Exchange DT180 DT181
DT185 DT45.1
DT70.1 DT80.1
DT85.1 DT85.2
DT90.1 DT92.1
ARS-TODAYS-AMT Signed 13.2 AR115 AR124
Current Amount This is the total amount of activity AR137 AR190
since the last running of AR194 (Audit AR194 AR20.1
Summary). AR21.1 AR21.2
AR21.3 AR24.1
AR29.2 AR30.1
AR30.2 AR30.4
AR42.1 AR42.2
AR42.7 AR43.1
AR502 AR503
AR504 AR560
AR570 AR575
AR580 AR82.1
CB191 DT180
DT181 DT45.1
DT70.1 DT80.1
DT85.1 DT85.2
DT90.1 DT92.1
ARS-PERIOD-AMT Signed 15.2 AR115 AR124
Period Amount This is the total amount of activity AR137 AR190
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
AR30.2 AR30.4
AR42.1 AR42.2
AR42.7 AR43.1
AR502 AR503
AR504 AR560
AR570 AR575
AR580 AR82.1
CB191 DT180
DT181 DT45.1
DT70.1 DT80.1
DT85.1 DT85.2
DT90.1 DT92.1
ARS-CURR-YR-AMT Signed 15.2 AR115 AR124
Current Year Amount This is the total amount of activity AR137 AR190
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
AR30.2 AR30.4
AR42.1 AR42.2
AR42.7 AR43.1
AR502 AR503
AR504 AR560
AR570 AR575
AR580 AR82.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
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 AR190 AR194
AR199 AR20.1
AR21.1 AR21.2
AR21.3 AR24.1
AR29.2 AR30.1
AR30.2 AR30.4
AR42.1 AR42.2
AR42.7 AR43.1
AR502 AR503
AR504 AR560
AR570 AR575
AR580 AR82.1
CB191 DT180
...
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
|