ARRTM FILE
AR Return to Maker Payment
The AR Return-to-maker Payment file contains information about
Return-to-Maker (RTM) payments. An RTM payment will be canceled with all
reversing audit functions provided through the RTM process.
REFERENCED BY
AR129 AR130 AR150 AR282 AR286 AR287
AR30.1 AR30.2 AR30.4 AR30.8 AR199 AR29.1
AR80.1
UPDATED BY
AR300 AR82.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RTM-COMPANY Numeric 4 AR82.1
Company Company number.
RTM-CUSTOMER Alpha 9 (Right Justified) AR82.1
Customer Number The customer that submitted the
Return-to-Maker payment.
RTM-TRANS-NBR Alpha 10 (Right Justified) AR82.1
Transaction Number Payment number that was returned.
RTM-BATCH-NBR Numeric 6 AR82.1
Batch Number This identifies the batch the returned
payment originally belonged to.
RTM-TRANS-TYPE Alpha 1 AR82.1
Transaction Type This will indicate the payment type.
It will be defaulted from the payment
record. Valid value is:
P = Customer Payment
RTM-STATUS Numeric 1 AR82.1
Status This will indicate the status of entry.
The returned payment will not be
processed until the record is released.
Valid values are:
0 = Unreleased RTM
2 = Released RTM
1 = Released RTM
RTM-RETURN-DATE Numeric 8 (yyyymmdd) AR82.1
Date Returned The date the check was returned.
RTM-SALESMAN Numeric 4 AR82.1
SalesRep Sales representative assigned to the
customer.
RTM-CREDIT-ANLYST Alpha 4 AR82.1
Credit Analyst Credit analyst assigned to the
customer.
RTM-DESC Alpha 30 (Lower Case) AR82.1
Description Free form description of return.
RTM-PAYMNT-AMT Signed 15.2 AR82.1
Payment Amount This is the amount of the payment that
has been returned.
RTM-DEBIT-MEMO Alpha 22 AR82.1
Debit Memo This will be the system-assigned debit
number that will be used to request
payment from the customer. These debit
memo transactions will be distinguished
from other debit memos in that the last
7 numbers will be prefixed by "RM-".
RTM-BILLBACK Alpha 1 AR82.1
Bill Back This field indicates whether or not to
Adjustments bill back all the adjustments made to
the invoice (discounts and write-offs).
Valid values are:
Y = Yes; Bill back all adjusts
N = No; Only bill selected adjusts
RTM-CHGE-BANK Alpha 1 AR82.1
Chargeback Bank This will indicate whether the bank
Charges charges entered should be charged back
to the customer. Valid values are:
Y = Yes; charge bank charges
N = No; do not charge bank charges
RTM-ADJ-AMT Signed 15.2 AR82.1
Adjustment Amount This is the sum of adjustments taken on
applications that were made from the
returned payment.
RTM-ADDTNL-AMT Signed 15.2 AR82.1
Additional Amount This is any additional amount to be
charged to the customer. Service
charges, for example.
RTM-GL-DATE Numeric 8 (yyyymmdd) AR82.1
Posting Date This is the date the reversing journal
entries will be posted to general ledger
when a return-to-maker transaction is
created.
RTM-ACCT-UNIT Alpha 15 Occurs 2 Times AR82.1
Accounting Unit GL accounting unit. This will be
optionally entered to account for any
additional charges incurred.
RTM-ACCOUNT Numeric 6 Occurs 2 Times AR82.1
Account GL account number to be used for any
additional charges.
RTM-SUB-ACCT Numeric 4 Occurs 2 Times AR82.1
Subaccount GL subaccount number for any additional
charges.
RTM-COMMENT Alpha 40 (Lower Case) AR82.1
Comment Line Occurs 3 Times
The comment narrative for the
information that will appear on the
Request for Payment Notice form
produced.
RTM-RTM-INST-CODE Alpha 3 AR82.1
RTM Transaction Code The bank service transaction code for
this return-to-maker check. It must
exist in the Lawson Cash Ledger system.
RTM-TRANS-IDENT Numeric 10 AR82.1
Transaction ID A unique system-generated
identification value assigned to the
transaction to make this record unique.
RTM-JRNL-BOOK-NBR Alpha 12 AR82.1
Journal Book Number Contains the journal book number for
the RTM transaction.
ARRTM FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RTMSET1 COMPANY This path is used for record uniqueness AR129 AR130
CUSTOMER and selection. AR150 AR282
TRANS-NBR AR286 AR287
BATCH-NBR AR30.1 AR30.2
AR30.4 AR30.8
AR300 AR82.1
RTMSET2 COMPANY This path is used to select unreleased AR199 AR282
CUSTOMER records. AR29.1 AR80.1
TRANS-NBR Subset
BATCH-NBR Where STATUS = Zeroes
RTMSET3 COMPANY This path is used to select records in AR282
GL-DATE general ledger date and customer order.
CUSTOMER
TRANS-NBR
BATCH-NBR
RTMSET4 COMPANY This path is used to select records in AR150
CUSTOMER customer and debit memo number order.
DEBIT-MEMO
TRANS-NBR
BATCH-NBR
RTMSET5 RTM-INST-CODE This path is used to allow drill down
TRANS-IDENT from cash ledger screens back into the
returned payment file.
KeyChange, Subset
Where RTM-INST-CODE != Spaces
ARRTM FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Ar Pymnt Hdr ARPYMNTHDR Required
RTM-COMPANY -> APH-COMPANY (APHSET1)
RTM-BATCH-NBR -> APH-BATCH-NBR
Arcomp ARCOMP Required
RTM-COMPANY -> ACO-COMPANY
Arcustomer ARCUSTOMER Required
RTM-COMPANY -> ACM-COMPANY
RTM-CUSTOMER -> ACM-CUSTOMER
Arpayment ARPAYMENT Required
RTM-COMPANY -> APM-COMPANY
RTM-BATCH-NBR -> APM-BATCH-NBR
RTM-TRANS-TYPE -> APM-TRANS-TYPE
RTM-TRANS-NBR -> APM-TRANS-NBR
RTM-CUSTOMER -> APM-CUSTOMER
Arurtm ARURTM Not Required
RTM-COMPANY -> UTM-COMPANY
RTM-CUSTOMER -> UTM-CUSTOMER
RTM-TRANS-NBR -> UTM-TRANS-NBR
RTM-BATCH-NBR -> UTM-BATCH-NBR
Zeroes -> UTM-SEQ
Custdesc CUSTDESC Required
ACO-CUST-GROUP -> CUD-CUST-GROUP
RTM-CUSTOMER -> CUD-CUSTOMER
ARRTM FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Arapplied ARAPPLIED Delete Restricted
RTM-COMPANY -> ARA-CR-COMPANY
RTM-CUSTOMER -> ARA-CR-CUSTOMER
RTM-TRANS-TYPE -> ARA-CR-TYPE
RTM-TRANS-NBR -> ARA-CR-NBR
Zeroes -> ARA-CR-PYMNT-SEQ
RTM-BATCH-NBR -> ARA-CR-BATCH
ARA-CR-SUFFIX
ARA-CR-CANCEL-SEQ
ARA-CR-APP-SEQ
Arrtmadj ARRTMADJ Delete Cascades
RTM-COMPANY -> ARJ-COMPANY
RTM-CUSTOMER -> ARJ-CUSTOMER
RTM-TRANS-NBR -> ARJ-TRANS-NBR
RTM-BATCH-NBR -> ARJ-BATCH-NBR
ARJ-DR-COMPANY
ARJ-DR-TYPE
ARJ-DR-TRANS-NBR
ARJ-DR-PAYMENT-SEQ
ARJ-DR-BATCH-NBR
ARJ-APP-SEQ
ARJ-ADJ-SEQ
|
