ARAPPLIED

AR Application

The AR Application file contains cash application records which serve as linking or audit records for each application made. Applications originate from one of four sources. The four main sources are; applications made with payments, applications made with credit memos, "adjustments" (partial or full write-offs and full chargebacks), or applications that have transferred liability from an open item to a bill of exchange.

REFERENCED BY
GL235


UPDATED BY
ARLL.1 CB06.2 CB191

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ARA-COMPANY
Element: Company
Numeric 4
The number representing an AR company.
ARLL.1
ARA-TRANS-TYPE
Element: Transaction Type
Alpha 1
The type of transaction referenced by this application. Valid values are: C = Credit memo D = Debit memo I = Invoice P = Payment
ARLL.1
ARA-INVOICE
Element: Invoice
Alpha 22
Used to identify the invoice.
ARLL.1
ARA-PAYMENT-SEQ
Element: Payment Sequence
Numeric 6
A unique number assigned to each transaction to be interfaced into the Lawson system.
ARLL.1
ARA-BATCH-NBR
Element: Batch Nbr
Numeric 6
This identifies the batch the entered invoices, debit memos, credit memos, or payments are a part of.
ARLL.1
ARA-APP-SEQ
Element: Application Sequence
Numeric 7
The number of applications made to a specific transaction.
ARLL.1
ARA-STATUS
Element: Status
Numeric 1
Represents the processing position within the posting cycle. For example, if the application was made during the entry and application of cash in AR30 (Cash Entry and Application), the status will be 0. When that batch of cash is released, the status will be changed depending on the following set of rules: If an application is made by other than the entry and apply method, or when the cash batch is released, the status will be set to 2 if the debit company requires an audit of applications (Yes selected in the Review Applications field in AR01.2). The status will be set to a 4 if the debit company does not require an audit of applications (No selected in the Review Applications field in AR01.2). Valid values are: 0 = Unreleased 2 = Requires audit listing 4 = Available for posting 5 = Posted
ARLL.1 CB191
ARA-APPLD-AMT
Element: Applied Amount
Signed 18.2
The amount applied to the transaction by this payment or credit memo.
ARLL.1
ARA-ADJ-AMT
Element: Adjustment Amount
Signed 18.2
The total amount of adjustments made with this application.
ARA-ADJ-SEQ
Element: Adjustment Sequence
Numeric 3
The last adjustment sequence number for this application record.
ARA-CR-COMPANY
Payment Transaction
Company
Numeric 4
The company number associated with the applied payment or credit memo.
ARLL.1
ARA-CR-CUSTOMER
Payment Transaction
Customer
Alpha 9 (Right Justified)
The customer number associated with the applied payment or credit memo.
ARLL.1
ARA-CR-BATCH
Element: Cash Batch Number
Numeric 6
The cash batch number associated with the applied payment or credit memo.
ARLL.1
ARA-CR-PYMNT-SEQ
Element: Payment Sequence
Numeric 6
The sequence number of the payment within the cash batch. This field will be 0 if the application was from a credit memo or an adjustment.
ARLL.1
ARA-CR-TYPE
Element: Payment Type
Alpha 1
The transaction type of the payment. Valid values are: B = Bill of Exchange C = Credit Memo D = Debit Memo P = Payment
ARLL.1
ARA-CR-NBR
Payment Transaction
Number
Alpha 22
The transaction number of the applied payment or credit memo.
ARLL.1
ARA-CR-SUFFIX
Credit Memo Suffix
Number
Numeric 3
Suffix number needed for file relationships.
ARLL.1
ARA-CR-CANCEL-SEQ
Element: BOE Cancel Sequence
Numeric 4
The bill of exchange cancel sequence number.
ARA-CR-APP-SEQ
Application
Sequence Number
Numeric 7
Sequence number of the application made with this payment or credit memo.
ARLL.1
ARA-CR-APP-AMT
Payment Applied
Amount
Signed 18.2
The amount in payment in the currency of the payment or credit memo that was applied against the transaction.
ARLL.1
ARA-CR-ORIG-AP-AMT
Element: Intl Amt
Signed 18.2
The amount of the application in the currency of the payment.
ARLL.1
ARA-CR-ADJ-SEQ
Credit Adjustment
Sequence
Numeric 3
The sequence number of the credit adjustment.
ARA-CR-ADJ-AMT
Credit Adjustment
Amount
Signed 18.2
The amount of the credit adjustment.
ARA-DEPOSIT-DATE
Element: Deposit Date
Numeric 8 (yyyymmdd)
The deposit date of the payment, or the general ledger date of the credit memo. This date is used in calculations such as IPA, DBT, and so on.
ARLL.1
ARA-OPR-CODE
Element: Operator Code
Alpha 10 (Lower Case)
The operator code used to create the application. If the operator is required at the company level, must be a valid operator code defined in AR15.6 (Operator). If the operator is not required, this is the operator's system logon ID.
ARLL.1
ARA-GL-DATE
Element: General Ledger Date
Numeric 8 (yyyymmdd)
The general ledger posting date of the application. Either the general ledger date of the applied payment or credit memo or the system date of the application defaults depending on the options defined for the company. For partial and full write-offs, the application general ledger date defined by the operator will be used. All application general ledger dates are maintainable by the operator.
ARLL.1
ARA-AR-CODE
Accounts Receivable
Code
Alpha 4
The accounts receivable code used to identify the general ledger account that is to be credited. This is normally the accounts receivable code assigned to the invoice or debit memo being paid.
ARLL.1
ARA-OFFSET-CODE
Element: Offset Code
Alpha 4
The accounts receivable code that identifies the offset general ledger account that is debited when application occurs. For payment applications, this is the RNA code or Prepay code. For credit applications, this is the AR code assigned to the credit memo. If grouping by a bill of exchange, this is the AR code assigned to the bill of exchange process level.
ARLL.1
ARA-APP-SOURCE
Element: Application Source
Alpha 1
Indicates how the application was made. Valid values are: A = Automatic cash application C = Converted application record M = Manual cash application R = Payment reversal application X = Automatic memo application B = Bill of Exchange E = Electronic Funds Transfer
W = Automatic Write Off
T = Transfer to AP
S = Mixed Signed Application
G = Grouped Memo
J = Adjustment Maintenance
ARLL.1
ARA-RESULT-FL
Element: Application Result
Alpha 1
Indicates the result of the application as it relates to the invoice or debit memo. It tracks fully applied status and timeliness of the application. Valid values are: C = Credit application D = Partially applied (late) F = Fully applied (on time) L = Fully applied (late) P = Partially applied (on time) W = Finance charge assessed B = Bill of Exchange X = Partially applied (late) with charges assessed Y = Fully applied (late) with charges assessed
ARLL.1
ARA-ORIG-APP-AMT
Transaction
Application Amount
Signed 18.2
The application amount in transaction currency.
ARLL.1
ARA-APP-CURR-CD
Application
Currency Code
Alpha 5
The currency of the application.
ARLL.1
ARA-APP-CURR
Application
Currency Type
Alpha 1
This field indicates what type of application occurred in terms of currency. Valid values are: B = Base N = Non-base M = Mixed
ARLL.1
ARA-REVERSE-FL
Element: Reversal
Alpha 1
Indicates whether an application was reversed after posting to the general ledger. If a reversal is created in AR80 (Payment Application Reversal) or AR180 (Payment Application Reversal Creation), the system creates the appropriate reversing journal entries. Valid values are: N = No reversal Y = Reversal application record
ARLL.1
ARA-PREPAY-FLAG
Element: Prepayment Flag
Numeric 1
Indicates if payment is a prepayment.
ARA-DELETE-FL
Element: Delete Fl
Alpha 1

C = Credit Memo Deleted
D = Debit Memo Deleted
I = Invoice Deleted
P = Payment Deleted
ARA-AR-CUST-PO-NBR
Element: Ar Cust Po Nbr
Derived
ARA-AR-DUE-DATE
Element: Ar Due Date
Derived


ARAPPLIED FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ARASET1 COMPANY
TRANS-TYPE
INVOICE
PAYMENT-SEQ
BATCH-NBR
APP-SEQ
KeyChange
ARLL.1 GL235
ARASET2 CR-COMPANY
CR-BATCH
CR-PYMNT-SEQ
COMPANY
TRANS-TYPE
INVOICE
PAYMENT-SEQ
BATCH-NBR
APP-SEQ
KeyChange, Subset
WhereCR-TYPE ="P"
CB06.2 CB191
ARASET3 CR-COMPANY
CR-CUSTOMER
CR-TYPE
CR-NBR
CR-PYMNT-SEQ
CR-BATCH
CR-SUFFIX
CR-CANCEL-SEQ
CR-APP-SEQ
KeyChange, Subset
WhereCR-COMPANY !=Zeroes
CB191
ARASET4 COMPANY
TRANS-TYPE
INVOICE
PAYMENT-SEQ
BATCH-NBR
APP-SEQ
KeyChange, Subset
WhereSTATUS =Zeroes
OrSTATUS =2
OrSTATUS =4
ARASET5 COMPANY
GL-DATE
TRANS-TYPE
INVOICE
PAYMENT-SEQ
BATCH-NBR
APP-SEQ
CR-COMPANY
CR-BATCH
CR-PYMNT-SEQ
KeyChange
ARASET6 CR-COMPANY
GL-DATE
CR-CUSTOMER
CR-TYPE
CR-NBR
CR-PYMNT-SEQ
CR-SUFFIX
CR-CANCEL-SEQ
CR-BATCH
CR-APP-SEQ
KeyChange, Subset
WhereCR-COMPANY !=Zeroes


ARAPPLIED FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Arcomp ARCOMP Required
ARA-COMPANY->ACO-COMPANY (ACOSET1)
Arcrcomp ARCOMP Required
When ARA-CR-COMPANY !=Zeroes
ARA-CR-COMPANY->ACO-COMPANY
Arcrcustomer ARCUSTOMER Required
When ARA-CR-CUSTOMER !=Spaces
AndARA-CR-CUSTOMER !="000000000"
ARA-CR-COMPANY->ACM-COMPANY
ARA-CR-CUSTOMER->ACM-CUSTOMER
Aroihdr AROIHDR Required
ARA-COMPANY->ARH-COMPANY
ARO-ALT-TYPE->ARH-TRANS-TYPE
ARA-INVOICE->ARH-INVOICE
Aroitems AROITEMS Required
ARA-COMPANY->ARO-COMPANY
ARA-TRANS-TYPE->ARO-TRANS-TYPE
ARA-INVOICE->ARO-INVOICE
ARA-PAYMENT-SEQ->ARO-PAYMENT-SEQ
Arpayment ARPAYMENT Required
When ARA-CR-TYPE ="P"
ARA-CR-COMPANY->APM-COMPANY
ARA-CR-BATCH->APM-BATCH-NBR
ARA-CR-PYMNT-SEQ->APM-PAYMENT-SEQ
Custdescpay CUSTDESC Required
When ARA-CR-CUSTOMER !=Spaces
AndARA-CR-CUSTOMER !="000000000"
ACO-CUST-GROUP->CUD-CUST-GROUP
ARA-CR-CUSTOMER->CUD-CUSTOMER


ARAPPLIED FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Aradjust ARADJUST Delete Cascades
ARA-COMPANY->ADJ-COMPANY
ARA-TRANS-TYPE->ADJ-TRANS-TYPE
ARA-INVOICE->ADJ-INVOICE
ARA-PAYMENT-SEQ->ADJ-PAYMENT-SEQ
ARA-BATCH-NBR->ADJ-BATCH-NBR
ARA-APP-SEQ->ADJ-APP-SEQ
  ADJ-ADJ-SEQ
Ardrafts ARDRAFTS Required
ARA-CR-COMPANY->ARD-COMPANY
ARA-CR-NBR->ARD-AR-DRAFT-NBR
ARA-CR-SUFFIX->ARD-SUFFIX
ARA-CR-CUSTOMER->ARD-CUSTOMER
Zeroes->ARD-CANCEL-SEQ
  ARD-DRAFT-SOURCE


File created: Thu Jun 09 11:08:53 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.