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.

Field / column	Type	Description & values	Updated by
`RPA-UNIQUE-I-D` PK UNIQUE_I_D	Bad Type 36	—	—
`RPA-COMPANY` PK COMPANY	Numeric 4	—	AR02.1
`RPA-PROCESS-LEVEL` PK PROCESS_LEVEL	Alpha 5	—	AR02.1
`RPA-ACTION` ACTION	Alpha 1	—	AR02.1
`RPA-OPERATOR` OPERATOR	Alpha 10	—	AR02.1
`RPA-DATE` DATE	Numeric 8 (yyyymmdd)	—	AR02.1
`RPA-TIME` TIME	Numeric 6 (hhmmss)	—	AR02.1
`RPA-PROGRAM` PROGRAM	Alpha 5	—	AR02.1
`RPA-FLD-NAME` FLD_NAME	Alpha 15	—	AR02.1
`RPA-FLD-NBR` FLD_NBR	Numeric 4	—	AR02.1
`RPA-OLD-VALUE` OLD_VALUE	Alpha 30 (Lower Case)	—	AR02.1
`RPA-NEW-VALUE` NEW_VALUE	Alpha 30 (Lower Case)	—	AR02.1
`RPA-DB-FILE-PFX` DB_FILE_PFX	Alpha 3	—	AR02.1

Indexes (3)

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

Index	Keys	Flags	Used in
`RPASET1`	`COMPANY`, `PROCESS-LEVEL`, `UNIQUE-I-D`	Primary	AC56.1, AC560, BR02.3, BR10.1, BR10.9, BR11.1, BR120, BR121 +22 more (list truncated in source)
`RPASET2`	`COMPANY`, `PROCESS-LEVEL`, `DATE`, `OPERATOR`, `UNIQUE-I-D`		—
`RPAUID`	`UNIQUE-I-D`		—

Relations

One to one (2) — lookups and parents

Relation	Table	Rules	Condition	Field map
Ardict	ARDICT	Required		`RPA-DB-FILE-PFX` → `ARY-DB-FILE-PFX (ARYSET1)`, `RPA-FLD-NBR` → `ARY-FLD-NBR`
Arproclevl	ARPROCLEVL	Required		`RPA-COMPANY` → `APV-COMPANY`, `RPA-PROCESS-LEVEL` → `APV-PROCESS-LEVEL`

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