ARITEMAUD – Open Item Audit

System: Accounts Receivable (AR)
Prefix: ARZ
Primary key: COMPANY, TRANS-TYPE, INVOICE, PAYMENT-SEQ
Fields: 11
Updated by: 0 programs
Referenced by: 0 programs

ARITEMAUD is the Open Item Audit table in Lawson Accounts Receivable (prefix ARZ). It is indexed by COMPANY, TRANS-TYPE, INVOICE, PAYMENT-SEQ (ARZSET1); alternate indexes: ARZSET2. The table has 11 fields, 2 indexes and 0 documented relations.

About ARITEMAUD

The Item Audit file is used to reconstruct a point-in-time view of the open item records that have been transferred. This file is used mainly is "as of" date type programs such as aging reports.

Fields (11)

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

Field / column	Type	Description & values	Updated by
`ARZ-COMPANY` PK COMPANY	Numeric 4	The number representing an AR company.	—
`ARZ-TRANS-TYPE` PK TRANS_TYPE	Alpha 1	Indicates the transaction type. Valid value are `C` Credit Memo `D` Debit Memo `I` Invoice	—
`ARZ-INVOICE` PK INVOICE	Alpha 22	Used to identify the invoice.	—
`ARZ-PAYMENT-SEQ` PK PAYMENT_SEQ	Numeric 6	A unique number assigned to each transaction to be interfaced into the Lawson system.	—
`ARZ-CANCEL-DATE` CANCEL_DATE	Numeric 8 (yyyymmdd)	The reassign date as specified in AR29.3.	—
`ARZ-CUSTOMER` CUSTOMER	Alpha 9 (Right Justified)	Customer number.	—
`ARZ-DUE-DATE` DUE_DATE	Numeric 8 (yyyymmdd)	The transaction due date.	—
`ARZ-ORIG-AMT` ORIG_AMT	Signed 18.2	Transaction amount in transaction currency.	—
`ARZ-TRAN-AMT` TRAN_AMT	Signed 18.2	Transaction amount in company base currency.	—
`ARZ-ACTIVITY` ACTIVITY	Alpha 15	The Activity value of the transaction.	—
`ARZ-OPR-CODE` OPR_CODE	Alpha 10 (Lower Case)	This field contains the user's login code during the transfer payment process.	—

Indexes (2)

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

Index	Keys	Flags	Condition	Used in
`ARZSET1`	`COMPANY`, `TRANS-TYPE`, `INVOICE`, `PAYMENT-SEQ`	Primary		ARLL.1, CB06.2
`ARZSET2`	`COMPANY`, `CUSTOMER`, `TRANS-TYPE`, `INVOICE`, `PAYMENT-SEQ`			—

Programs

No Lawson programs are documented as updating or referencing this table.