Acct Receivables 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
AR09.1 | AR09.4 | AR10.1 | AR11.1 | AR12.1 | AR12.2 |
AR13.1 | AR13.2 | AR210 | AR301 | AR501 | AR550 |
GL235 | TX140 |
ARLL.1 | CB06.2 | CB191 |
FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||
---|---|---|---|---|
ARA-COMPANY Element: Company | Numeric 4 The number representing an AR company. |
|
||
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 |
|
||
ARA-INVOICE Element: Invoice | Alpha 22 Used to identify the invoice. |
|
||
ARA-PAYMENT-SEQ Element: Payment Sequence | Numeric 6 A unique number assigned to each transaction to be interfaced into the Lawson system. |
|
||
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. |
|
||
ARA-APP-SEQ Element: Application Sequence | Numeric 7 The number of applications made to a specific transaction. |
|
||
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 |
|
||
ARA-APPLD-AMT Element: Applied Amount | Signed 18.2 The amount applied to the transaction by this payment or credit memo. |
|
||
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. |
|
||
ARA-CR-CUSTOMER Payment Transaction Customer | Alpha 9 (Right Justified) The customer number associated with the applied payment or credit memo. |
|
||
ARA-CR-BATCH Element: Cash Batch Number | Numeric 6 The cash batch number associated with the applied payment or credit memo. |
|
||
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. |
|
||
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 |
|
||
ARA-CR-NBR Payment Transaction Number | Alpha 22 The transaction number of the applied payment or credit memo. |
|
||
ARA-CR-SUFFIX Credit Memo Suffix Number | Numeric 3 Suffix number needed for file relationships. |
|
||
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. |
|
||
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. |
|
||
ARA-CR-ORIG-AP-AMT Element: Intl Amt | Signed 18.2 The amount of the application in the currency of the payment. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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 |
|
||
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 |
|
||
ARA-ORIG-APP-AMT Transaction Application Amount | Signed 18.2 The application amount in transaction currency. |
|
||
ARA-APP-CURR-CD Application Currency Code | Alpha 5 The currency of the application. |
|
||
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 |
|
||
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 |
|
||
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 |
|
||
ARA-AMD-AR-OBJ-ID Element: Obj Id | Numeric 12 |
|
||
ARA-AMD-OFF-OBJ-ID Element: Obj Id | Numeric 12 |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | |||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
ARASET1 |
COMPANY TRANS-TYPE INVOICE PAYMENT-SEQ BATCH-NBR APP-SEQ |
|
| |||||||||||||||||||||||||
ARASET2 |
CR-COMPANY CR-BATCH CR-PYMNT-SEQ COMPANY TRANS-TYPE INVOICE PAYMENT-SEQ BATCH-NBR APP-SEQ |
|
| |||||||||||||||||||||||||
ARASET3 |
CR-COMPANY CR-CUSTOMER CR-TYPE CR-NBR CR-PYMNT-SEQ CR-BATCH CR-SUFFIX CR-CANCEL-SEQ CR-APP-SEQ |
|
| |||||||||||||||||||||||||
ARASET4 |
COMPANY TRANS-TYPE INVOICE PAYMENT-SEQ BATCH-NBR APP-SEQ |
|
||||||||||||||||||||||||||
ARASET5 |
COMPANY GL-DATE TRANS-TYPE INVOICE PAYMENT-SEQ BATCH-NBR APP-SEQ CR-COMPANY CR-BATCH CR-PYMNT-SEQ |
|
||||||||||||||||||||||||||
ARASET6 |
CR-COMPANY GL-DATE CR-CUSTOMER CR-TYPE CR-NBR CR-PYMNT-SEQ CR-SUFFIX CR-CANCEL-SEQ CR-BATCH CR-APP-SEQ |
|
||||||||||||||||||||||||||
ARASET7 |
AMD-AR-OBJ-ID COMPANY TRANS-TYPE INVOICE PAYMENT-SEQ BATCH-NBR APP-SEQ |
|
||||||||||||||||||||||||||
ARASET8 |
AMD-OFF-OBJ-ID COMPANY TRANS-TYPE INVOICE PAYMENT-SEQ BATCH-NBR APP-SEQ |
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Arappldbod | ARAPPLDBOD |
Not Required, Delete Cascades
| ||||||||||||||||||
Arcomp | ARCOMP |
Required
| ||||||||||||||||||
Arcrcomp | ARCOMP |
Required
| ||||||||||||||||||
Arcrcustomer | ARCUSTOMER |
Required
| ||||||||||||||||||
Ardistrib Ar | ARDISTRIB |
Required
| ||||||||||||||||||
Ardistrib Off | ARDISTRIB |
Required
| ||||||||||||||||||
Aroihdr | AROIHDR |
Required
| ||||||||||||||||||
Aroitems | AROITEMS |
Required
| ||||||||||||||||||
Arpayment | ARPAYMENT |
Required
| ||||||||||||||||||
Custdescpay | CUSTDESC |
Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Aradjust | ARADJUST |
Delete Cascades
| |||||||||||||||||||||
Ardrafts | ARDRAFTS |
Required
|
All trademarks and registered trademarks are the property of their
respective owners.