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

ARAPPLIED FILE RELATIONS

ONE TO ONE RELATIONS

ARAPPLIED FILE RELATIONS

ONE TO MANY RELATIONS

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