ARRTMADJ FILE
AR RTM Payment Adjustment
The AR RTM Payment Adjustment file contains adjustments that were taken
against the invoices or debit memos that were paid with the Return-to-Maker
payment. At the user's discretion, these disallowed adjustments will be
included in the return-to-maker payment.
REFERENCED BY
AR282
UPDATED BY
AR300 AR82.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ARJ-COMPANY Numeric 4 AR82.1
Company Company number.
ARJ-CUSTOMER Alpha 9 (Right Justified) AR82.1
Customer Number Number of the customer that owns the
Return-to-Maker payment.
ARJ-TRANS-NBR Alpha 10 (Right Justified) AR82.1
Transaction Number Number of the Return-to-Maker check the
adjustments were created with.
ARJ-BATCH-NBR Numeric 6 AR82.1
Batch Number Batch number of return-to-maker
payment.
ARJ-DR-COMPANY Numeric 4 AR82.1
Transaction Company AR company to which the debit
transaction, paid by the RTM payment,
belongs.
ARJ-DR-TYPE Alpha 1 AR82.1
Transaction Type Debit transaction type that was
originally paid with the RTM payment.
Valid values are:
D = Debit memo
I = Invoice
ARJ-DR-TRANS-NBR Alpha 22 AR82.1
Transaction Number Debit transaction number that was
originally paid with the RTM payment.
ARJ-DR-PAYMENT-SEQ Numeric 3 AR82.1
Payment Sequence This is the Invoice/Debit Memo payment
sequence used in the application.
ARJ-DR-BATCH-NBR Numeric 6 AR82.1
Transaction Batch The batch number of the invoice or
Number debit memo.
ARJ-APP-SEQ Numeric 5 AR82.1
Application Number Specifies the application number of the
original write-off.
ARJ-ADJ-SEQ Numeric 3 AR82.1
Adjustment Number Specifies the adjustment number of the
original adjustment.
ARJ-DR-CUST Alpha 9 (Right Justified) AR82.1
Customer Number of the customer whose invoice
and adjustment were exhausted with the
RTM payment.
ARJ-DESC Alpha 30 (Lower Case) AR82.1
Description Description of the original adjustment.
ARJ-AMOUNT Currency 15.2 AR82.1
Adjustment Amount The amount of the original adjustment.
ARRTMADJ FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ARJSET1 COMPANY This path is used for record uniqueness AR282 AR300
CUSTOMER and selection. AR82.1
TRANS-NBR
BATCH-NBR
DR-COMPANY
DR-TYPE
DR-TRANS-NBR
DR-PAYMENT-SEQ
DR-BATCH-NBR
APP-SEQ
ADJ-SEQ
ARRTMADJ FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Aradjust ARADJUST Required
ARJ-DR-COMPANY -> ADJ-COMPANY
ARJ-DR-TYPE -> ADJ-TRANS-TYPE
ARJ-DR-TRANS-NBR -> ADJ-INVOICE
ARJ-DR-PAYMENT-SEQ -> ADJ-PAYMENT-SEQ
ARJ-DR-BATCH-NBR -> ADJ-BATCH-NBR
ARJ-APP-SEQ -> ADJ-APP-SEQ
ARJ-ADJ-SEQ -> ADJ-ADJ-SEQ
Aroitems AROITEMS Required
ARJ-COMPANY -> ARO-COMPANY
ARJ-DR-TYPE -> ARO-TRANS-TYPE
ARJ-DR-TRANS-NBR -> ARO-INVOICE
ARJ-DR-PAYMENT-SEQ -> ARO-PAYMENT-SEQ
Arreason ARREASON Not Required
ARJ-DR-COMPANY -> ARR-COMPANY
"AD" -> ARR-TYPE
ADJ-REASON-CODE -> ARR-REASON-CODE
|
