|
|
ARRTMADJ FILE
AR RTM Payment Adjustment
The AR RTM Payment Adjustment file contains adjustments that were taken
against the invoices, debit memos, or credit 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 amount.
REFERENCED BY
AR282
UPDATED BY
AR300 AR82.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ARJ-COMPANY Numeric 4 AR82.1
Element: Company The number representing an AR company.
ARJ-CUSTOMER Alpha 9 (Right Justified) AR82.1
Element: Customer Number of the customer that owns the
Return-to-Maker payment.
ARJ-TRANS-NBR Alpha 10 (Right Justified) AR82.1
Element: Transaction NuNumber of the Return-to-Maker check the
adjustments were created with.
ARJ-BATCH-NBR Numeric 6 AR82.1
Element: Batch Nbr Batch number of return-to-maker
payment.
ARJ-DR-COMPANY Numeric 4 AR82.1
Element: Transaction CoAR company to which the debit
transaction, paid by the RTM payment,
belongs.
ARJ-DR-TYPE Alpha 1 AR82.1
Element: Transaction TyDebit transaction type that was
originally paid with the RTM payment.
Valid values are:
D = Debit memo
I = Invoice
C = Credit Memo
ARJ-DR-TRANS-NBR Alpha 22 AR82.1
Element: Transaction NuDebit transaction number that was
originally paid with the RTM payment.
ARJ-DR-PAYMENT-SEQ Numeric 3 AR82.1
Element: Payment SequenThis is the invoice, debit memo, or
credit 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 7 AR82.1
Element: Application NuSpecifies the application number of the
original write-off.
ARJ-ADJ-SEQ Numeric 3 AR82.1
Element: Adjustment NumSpecifies the adjustment number of the
original adjustment.
ARJ-DR-CUST Alpha 9 (Right Justified) AR82.1
Element: Customer Number of the customer whose invoice
and adjustment were exhausted with the
RTM payment.
ARJ-DESC Alpha 30 (Lower Case) AR82.1
Element: Description Description of the original adjustment.
ARJ-AMOUNT Signed 18.2 AR82.1
Element: Adjustment AmoThe amount of the original adjustment.
ARRTMADJ FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ARJSET1 COMPANY AR282 AR300
CUSTOMER 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
|
