|
|
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 AR282 AR286 AR287 AR29.2
AR29.1 AR30.1 AR30.8 AR32.1 AR33.1 AR33.3
AR34.1 AR80.2 AR80.1 AR198 AR199
UPDATED BY
AR150 AR300 AR82.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RTM-COMPANY Numeric 4 AR82.1
Element: Company The number representing an AR company.
RTM-CUSTOMER Alpha 9 (Right Justified) AR82.1
Element: Customer The customer that submitted the
Return-to-Maker payment.
RTM-TRANS-NBR Alpha 10 (Right Justified) AR82.1
Element: Transaction NuPayment number that was returned.
RTM-BATCH-NBR Numeric 6 AR82.1
Element: Batch Nbr This identifies the batch the returned
payment originally belonged to.
RTM-TRANS-TYPE Alpha 1 AR82.1
Element: Trans 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
Element: 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
1 = Released RTM
RTM-RETURN-DATE Numeric 8 (yyyymmdd) AR82.1
Element: Date The date the payment was returned.
RTM-SALESMAN Numeric 4 AR82.1
Element: SalesRep Sales representative assigned to the
customer.
RTM-CREDIT-ANLYST Alpha 4 AR82.1
Element: Credit AnalystCredit analyst assigned to the
customer.
RTM-DESC Alpha 30 (Lower Case) AR82.1
Element: Description Free form description of returned
payment.
RTM-PAYMNT-AMT Signed 18.2 AR82.1
Element: Intl Amt This is the amount of the payment that
has been returned.
RTM-DEBIT-MEMO Alpha 22 AR150 AR82.1
Element: 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 18.2 AR82.1
Element: Adjustment AmoThis is the sum of adjustments taken on
applications that were made from the
returned payment.
RTM-ADDTNL-AMT Signed 18.2 AR82.1
Element: Additional AmoThis is any additional amount to be
charged to the customer. Service
charges, for example.
RTM-GL-DATE Numeric 8 (yyyymmdd) AR82.1
Element: 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
Element: Acct 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
Element: Account GL account number to be used for any
additional charges.
RTM-SUB-ACCT Numeric 4 Occurs 2 Times AR82.1
Element: Sub Acct GL subaccount number for any additional
charges.
RTM-COMMENT Alpha 40 (Lower Case) AR82.1
Element: Comment 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
Element: RTM TransactioThe 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
Element: Transaction IDA unique CB system-generated
identification value assigned to the
transaction to make the interface
adjustment record unique.
RTM-JRNL-BOOK-NBR Alpha 12 AR82.1
Element: Journal Book NContains the journal book number for
the RTM transaction.
ARRTM FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RTMSET1 COMPANY AR129 AR130
CUSTOMER AR150 AR282
TRANS-NBR AR286 AR287
BATCH-NBR AR29.2 AR30.1
AR30.8 AR300
AR32.1 AR33.1
AR33.3 AR34.1
AR80.2 AR82.1
RTMSET2 COMPANY Subset AR198 AR199
CUSTOMER Where STATUS = Zeroes AR282 AR29.1
TRANS-NBR AR80.1 AR80.2
BATCH-NBR
RTMSET3 COMPANY AR282
GL-DATE
CUSTOMER
TRANS-NBR
BATCH-NBR
RTMSET4 COMPANY AR150
CUSTOMER
DEBIT-MEMO
TRANS-NBR
BATCH-NBR
RTMSET5 RTM-INST-CODE KeyChange, Subset
TRANS-IDENT 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
|
