ARPRLAUD – AR Process Level Audit
- System
- Accounts Receivable (AR)
- Prefix
RPA- Primary key
COMPANY,PROCESS-LEVEL,UNIQUE-I-D- Fields
- 13
- Updated by
- 1 program
- Referenced by
- 53 programs
ARPRLAUD is the AR Process Level Audit table in Lawson Accounts Receivable (prefix RPA). It is indexed by COMPANY, PROCESS-LEVEL, UNIQUE-I-D (RPASET1); alternate indexes: RPASET2 and RPAUID. It is related 1:1 to ARDICT and ARPROCLEVL. It is updated by AR02.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, 3 indexes and 2 documented relations.
About ARPRLAUD
No description in the Lawson data dictionary.
Fields (13)
Column = COBOL field name without the RPA- 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 |
|---|---|---|---|
#RPA-UNIQUE-I-D PKUNIQUE_I_D | Bad Type 36 | — | — |
#RPA-COMPANY PKCOMPANY | Numeric 4 | — | AR02.1 |
#RPA-PROCESS-LEVEL PKPROCESS_LEVEL | Alpha 5 | — | AR02.1 |
#RPA-ACTIONACTION | Alpha 1 | — | AR02.1 |
#RPA-OPERATOR SET2OPERATOR | Alpha 10 | — | AR02.1 |
#RPA-DATE SET2DATE | Numeric 8 (yyyymmdd) | — | AR02.1 |
#RPA-TIMETIME | Numeric 6 (hhmmss) | — | AR02.1 |
#RPA-PROGRAMPROGRAM | Alpha 5 | — | AR02.1 |
#RPA-FLD-NAMEFLD_NAME | Alpha 15 | — | AR02.1 |
#RPA-FLD-NBRFLD_NBR | Numeric 4 | — | AR02.1 |
#RPA-OLD-VALUEOLD_VALUE | Alpha 30 (Lower Case) | — | AR02.1 |
#RPA-NEW-VALUENEW_VALUE | Alpha 30 (Lower Case) | — | AR02.1 |
#RPA-DB-FILE-PFXDB_FILE_PFX | Alpha 3 | — | AR02.1 |
Indexes (3)
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 |
|---|---|---|---|---|
RPASET1 |
| Primary | AC56.1, AC560, BR02.3, BR10.1, BR10.9, BR11.1, BR120, BR121 +22 more (list truncated in source) | |
RPASET2 |
| — | ||
RPAUID |
| — |
Relations
One to one (2) — lookups and parents
| Relation | Table | Rules | Condition | Field map | ||||||
|---|---|---|---|---|---|---|---|---|---|---|
| Ardict | ARDICT | Required |
| |||||||
| Arproclevl | ARPROCLEVL | Required |
|
Programs
Updated by (1)
- AR02.1 Process Level
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