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. PK = primary key (present in every index); SETn = leading/alternate key of that index.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
#RAU-UNIQUE-I-D PKUNIQUE_I_D | Bad Type 36 | — | — |
#RAU-COMPANY PKCOMPANY | Numeric 4 | — | AR01.1 |
#RAU-CUST-GROUP SET2CUST_GROUP | Alpha 5 | — | AR01.1 |
#RAU-ACTIONACTION | Alpha 1 | — | AR01.1 |
#RAU-OPERATOR SET3OPERATOR | Alpha 10 | — | AR01.1 |
#RAU-DATE SET3DATE | Numeric 8 (yyyymmdd) | — | AR01.1 |
#RAU-TIMETIME | Numeric 6 (hhmmss) | — | AR01.1 |
#RAU-PROGRAMPROGRAM | Alpha 5 | — | AR01.1 |
#RAU-FLD-NAMEFLD_NAME | Alpha 15 | — | AR01.1 |
#RAU-FLD-NBRFLD_NBR | Numeric 4 | — | AR01.1 |
#RAU-OLD-VALUEOLD_VALUE | Alpha 30 (Lower Case) | — | AR01.1 |
#RAU-NEW-VALUENEW_VALUE | Alpha 30 (Lower Case) | — | AR01.1 |
#RAU-DB-FILE-PFXDB_FILE_PFX | Alpha 3 | — | AR01.1 |
Indexes (4)
Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
RAUSET1 |
| Primary | AC56.1, AC560, BR02.3, BR10.1, BR10.9, BR11.1, BR120, BR121 +22 more (list truncated in source) | |
RAUSET2 |
| — | ||
RAUSET3 |
| — | ||
RAUUID |
| — |
Relations
One to one (2) — lookups and parents
Programs
Updated by (1)
- AR01.1 Company
Referenced by (53)
- AC56.1 Setup Interface Adjustment
- AC560 Setup Interface
- BR02.3 Retainer Invoice Entry
- BR10.1 Contract Parameters
- BR10.9 Product Contract Parameters
- BR11.1 Customer
- BR120 Invoice Calculation
- BR121 Invoice Print and Interface
- BR122 Online batch invoice process
- BR123 Product Invoice Cancel
- BR131 Revenue Realization
- BR140 Billing and Revenue Backout
- BR145 Invoice Control Maintenance
- BR151 Product Invoicing
- BR152 Maintenance Invoicing
- BR156 Maintenance Quote
- BR157 Maintenance Cancel
- BR16.1 Service Location
- BR16.2 Customer Maintenance Renew Date
- BR17.1 Bill To Group
- BR180 Location Vertex Geocode Update
- BR19.1 Single Invoice Calculation
- BR20.1 Invoice Edit Contract
- BR20.2 Invoice Edit Line
- BR20.3 Invoice Edit Activity
- BR20.4 Invoice Edit Activity and Account Category
- BR20.5 Invoice Edit Transaction
- BR20.7 Invoice Header
- BR21.1 Invoice Cancellation
- BR211 Activity Customer Listing
- BR216 Service Location Listing
- BR217 Bill To Group Listing
- BR220 Invoice Audit Listing
- BR245 Invoice Control Listing
- BR252 Maintenance Schedule Listing
- BR300 Invoice Purge
- BR420 Billing Invoice Report
- BR45.1 Invoice Control
- BR450 Activity Aging
- BR46.1 Bill in Advance
- BR46.2 Transfer Invoice Transaction
- BR46.4 Split Transfer
- BR48.1 Customer Template
- BR49.1 Invoice Adjustment Maintenance
- BR521 Billing Import
- BR91.1 Contract By Customer Inquiry
- BRIP.1 Invoice Print Program
- TX101 Journal File Create
- TX140 Vertex Geocode Update
- TX226 Purchasing and Sales Journal
- TX301 Journal Detail Purge
- WH20.2 Nonstock and Special Allocation
- WH20.7 Substitute Location