ARCOMPAUD – AR Company Audit

System
Accounts Receivable (AR)
Prefix
RAU
Primary key
COMPANY, UNIQUE-I-D
Fields
13
Updated by
1 program
Referenced by
53 programs

ARCOMPAUD is the AR Company Audit table in Lawson Accounts Receivable (prefix RAU). It is indexed by COMPANY, UNIQUE-I-D (RAUSET1); alternate indexes: RAUSET2, RAUSET3 and RAUUID. It is related 1:1 to ARCOMP and ARDICT. It is updated by AR01.1 and referenced by AC56.1, AC560, BR02.3, BR10.1, BR10.9, BR11.1, BR120, BR121 and 45 more. The table has 13 fields, 4 indexes and 2 documented relations.

About ARCOMPAUD

No description in the Lawson data dictionary.

Fields (13)

Column = COBOL field name without the RAU- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
RAU-UNIQUE-I-D PK
UNIQUE_I_D
Bad Type 36
RAU-COMPANY PK
COMPANY
Numeric 4AR01.1
RAU-CUST-GROUP
CUST_GROUP
Alpha 5AR01.1
RAU-ACTION
ACTION
Alpha 1AR01.1
RAU-OPERATOR
OPERATOR
Alpha 10AR01.1
RAU-DATE
DATE
Numeric 8 (yyyymmdd)AR01.1
RAU-TIME
TIME
Numeric 6 (hhmmss)AR01.1
RAU-PROGRAM
PROGRAM
Alpha 5AR01.1
RAU-FLD-NAME
FLD_NAME
Alpha 15AR01.1
RAU-FLD-NBR
FLD_NBR
Numeric 4AR01.1
RAU-OLD-VALUE
OLD_VALUE
Alpha 30 (Lower Case)AR01.1
RAU-NEW-VALUE
NEW_VALUE
Alpha 30 (Lower Case)AR01.1
RAU-DB-FILE-PFX
DB_FILE_PFX
Alpha 3AR01.1

Indexes (4)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
RAUSET1COMPANY, UNIQUE-I-DPrimaryAC56.1, AC560, BR02.3, BR10.1, BR10.9, BR11.1, BR120, BR121 +22 more (list truncated in source)
RAUSET2CUST-GROUP, COMPANY, UNIQUE-I-D
RAUSET3COMPANY, DATE, OPERATOR, UNIQUE-I-D
RAUUIDUNIQUE-I-D

Relations

One to one (2) — lookups and parents

RelationTableRulesConditionField map
ArcompARCOMPRequiredRAU-COMPANYACO-COMPANY (ACOSET1)
ArdictARDICTRequiredRAU-DB-FILE-PFXARY-DB-FILE-PFX, RAU-FLD-NBRARY-FLD-NBR

Programs

Updated by (1)

Referenced by (53)