ARITEMAUD FILE
Open Item Audit
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.
REFERENCED BY
AR115 AR129 AR130 AR131 AR135 AR137
AR150 AR180 AR190 AR194 AR196 AR198
AR20.1 AR21.1 AR21.2 AR21.3 AR229 AR250
AR251 AR252 AR253 AR255 AR256 AR257
AR275 AR30.1 AR30.8 AR32.1 AR33.1 AR33.3
AR33.5 AR33.6 AR34.1 AR35.1 AR35.2 AR37.1
AR37.2 AR37.3 AR37.4 AR37.5 AR37.6 AR37.7
AR38.1 AR38.2 AR38.3 AR39.1 AR39.2 AR42.1
AR42.2 AR42.6 AR42.7 AR43.1 AR44.3 AR45.1
AR48.3 AR502 AR504 AR506 AR525 AR560
AR80.1 AR80.2 AR800 ARLL.1 CB06.2 DT150
UPDATED BY
AR29.3 AR300
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ARZ-COMPANY Numeric 4 AR29.3
Element: Company The number representing an AR company.
ARZ-TRANS-TYPE Alpha 1 AR29.3
Element: Trans Type Indicates the transaction type. Valid
value are
C = Credit Memo
D = Debit Memo
I = Invoice
ARZ-INVOICE Alpha 22 AR29.3
Element: Invoice Used to identify the invoice.
ARZ-PAYMENT-SEQ Numeric 6 AR29.3
Payment Sequence A unique number assigned to each
Number transaction to be interfaced into the
Lawson system.
ARZ-CANCEL-DATE Numeric 8 (yyyymmdd) AR29.3
Element: Cancellation DThe reassign date as specified in
AR29.3.
ARZ-CUSTOMER Alpha 9 (Right Justified) AR29.3
Element: Customer Customer number.
ARZ-DUE-DATE Numeric 8 (yyyymmdd) AR29.3
Element: Due Date The transaction due date.
ARZ-ORIG-AMT Signed 18.2 AR29.3
Element: Intl Amt Transaction amount in transaction
currency.
ARZ-TRAN-AMT Signed 18.2 AR29.3
Element: Intl Amt Transaction amount in company base
currency.
ARZ-ACTIVITY Alpha 15 AR29.3
Element: Activity The Activity value of the transaction.
ARZ-OPR-CODE Alpha 10 (Lower Case)
Element: Opr Code This field contains the user's login
code during the transfer payment
process.
ARITEMAUD FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ARZSET1 COMPANY AR115 AR129
TRANS-TYPE AR130 AR131
INVOICE AR135 AR137
PAYMENT-SEQ AR150 AR180
AR190 AR194
AR196 AR198
AR20.1 AR21.1
AR21.2 AR21.3
AR229 AR250
AR251 AR252
AR253 AR255
AR256 AR257
AR275 AR29.3
AR30.1 AR30.8
AR300 AR32.1
...
ARZSET2 COMPANY AR137 AR150
CUSTOMER AR250 AR251
TRANS-TYPE AR253 AR255
INVOICE AR257
PAYMENT-SEQ
|