ARSUMMARY

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
AR01.1 ARLL.1 CB191

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ARS-COMPANY
Element: Company
Numeric 4
The number representing an AR company.
ARLL.1 CB191
ARS-PROCESS-LEVEL
Element: Process Level
Alpha 5
This field contains the process level, which is the reporting hierarchy below company.
ARLL.1 CB191
ARS-TYPE
Transaction
Activity Level
Alpha 2
Type is the breakout level of transaction activity for the process level. Valid values are: 01 = Invoiced 02 = Debits/Credits 03 = Payments/Charges 04 = Non-AR Payments Entered 05 = Beginning Balance 06 = Chargebacks 07 = Discounts 08 = Shorts/Write-Offs 09 = Gain/Loss 10 = Cashed Bills of Exchange
ARLL.1 CB191
ARS-TODAYS-AMT
Element: Current Amount
Signed 18.2
This is the total amount of activity since the last running of AR194 (Audit Summary).
ARLL.1 CB191
ARS-PERIOD-AMT
Element: Period Amount
Signed 18.2
This is the total amount of activity for the current period since the last running of AR199 (Period Closing).
ARLL.1 CB191
ARS-CURR-YR-AMT
Element: Intl Amt
Signed 18.2
This is the total amount of activity for the current year since the last running of AR199 (Period Closing) with year-end option.
ARLL.1 CB191
ARS-PREV-DATE
Element: Last Update
Numeric 8 (yyyymmdd)
The last date that this record was updated.


ARSUMMARY FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ARSSET1 COMPANY
PROCESS-LEVEL
TYPE
AR02.1 ARLL.1
CB191
ARSSET2 COMPANY
TYPE
PROCESS-LEVEL
AR01.1


ARSUMMARY FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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


File created: Thu Jun 09 11:09:08 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.