|
|
ARRTM FILE
AR Return to Maker Payment
AR Return to Maker Payment
REFERENCED BY
AR130 AR150 AR282 AR286 AR287 AR30.1
AR30.2 AR30.4 AR30.8 AR199 AR29.1 AR80.1
UPDATED BY
AR300 AR82.1 AR971
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RTM-COMPANY Numeric 4 AR82.1 AR971
Company Company number.
RTM-CUSTOMER Alpha 9 (Right Justified) AR82.1 AR971
Customer Number The customer that submitted the
Return-to-Maker payment.
RTM-TRANS-NBR Alpha 10 (Right Justified) AR82.1 AR971
Transaction Number Payment number that was returned.
RTM-BATCH-NBR Numeric 6 AR82.1 AR971
Batch Number This identifies the batch the returned
payment originally belonged to.
RTM-TRANS-TYPE Alpha 1 AR82.1 AR971
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 AR971
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
RTM-RETURN-DATE Numeric 8 (yyyymmdd) AR82.1 AR971
Date Returned The date the check was returned.
RTM-SALESMAN Numeric 4 AR82.1 AR971
Sales Rep Sales representative assigned to the
customer.
RTM-CREDIT-ANLYST Alpha 4 AR82.1 AR971
Credit Analyst Credit analyst assigned to the
customer.
RTM-DESC Alpha 30 (Lower Case) AR82.1 AR971
Description Free form description of return.
RTM-PAYMNT-AMT Signed 15.2 AR82.1 AR971
Payment Amount This is the amount of the payment that
has been returned.
RTM-DEBIT-MEMO Alpha 10 AR82.1 AR971
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 AR971
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 AR971
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 AR971
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 AR971
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 AR971
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 AR971
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 AR971
Account GL account number to be used for any
additional charges.
RTM-SUB-ACCT Numeric 4 Occurs 2 Times AR82.1 AR971
Subaccount GL subaccount number for any additional
charges.
RTM-COMMENT Alpha 40 (Lower Case) AR82.1 AR971
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 AR971
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 AR971
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 AR130 AR150
CUSTOMER and selection. AR282 AR286
TRANS-NBR AR287 AR30.1
BATCH-NBR 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 Duplicates, 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
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
|