ARAPPLIED – Acct Receivables Application

System
Accounts Receivable (AR)
Prefix
ARA
Primary key
COMPANY, TRANS-TYPE, INVOICE, PAYMENT-SEQ, BATCH-NBR, APP-SEQ
Fields
40
Updated by
3 programs
Referenced by
14 programs

ARAPPLIED is the Acct Receivables Application table in Lawson Accounts Receivable (prefix ARA). It is indexed by COMPANY, TRANS-TYPE, INVOICE, PAYMENT-SEQ, BATCH-NBR, APP-SEQ (ARASET1); alternate indexes: ARASET2, ARASET3, ARASET4, ARASET5, ARASET6, ARASET7 and ARASET8. It is related 1:1 to ARAPPLDBOD, ARCOMP, ARCUSTOMER, ARDISTRIB, AROIHDR, AROITEMS, ARPAYMENT and CUSTDESC and 1:M to ARADJUST and ARDRAFTS. It is updated by ARLL.1, CB06.2 and CB191 and referenced by AR09.1, AR09.4, AR10.1, AR11.1, AR12.1, AR12.2, AR13.1, AR13.2 and 6 more. The table has 40 fields, 8 indexes and 12 documented relations.

About ARAPPLIED

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.

Fields (40)

Column = COBOL field name without the ARA- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#ARA-COMPANY PK
COMPANY		Numeric 4The number representing an AR company.ARLL.1
#ARA-TRANS-TYPE PK
TRANS_TYPE		Alpha 1The type of transaction referenced by this application. Valid values are:
  • C Credit memo
  • D Debit memo
  • I Invoice
  • P Payment
ARLL.1
#ARA-INVOICE PK
INVOICE		Alpha 22Used to identify the invoice.ARLL.1
#ARA-PAYMENT-SEQ PK
PAYMENT_SEQ		Numeric 6A unique number assigned to each transaction to be interfaced into the Lawson system.ARLL.1
#ARA-BATCH-NBR PK
BATCH_NBR		Numeric 6This identifies the batch the entered invoices, debit memos, credit memos, or payments are a part of.ARLL.1
#ARA-APP-SEQ PK
APP_SEQ		Numeric 7The number of applications made to a specific transaction.ARLL.1
#ARA-STATUS
STATUS		Numeric 1Represents 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
APPLD_AMT		Signed 18.2The amount applied to the transaction by this payment or credit memo.ARLL.1
#ARA-ADJ-AMT
ADJ_AMT		Signed 18.2The total amount of adjustments made with this application.—
#ARA-ADJ-SEQ
ADJ_SEQ		Numeric 3The last adjustment sequence number for this application record.—
#ARA-CR-COMPANY SET2 SET3 SET5 SET6
CR_COMPANY		Numeric 4The company number associated with the applied payment or credit memo.ARLL.1
#ARA-CR-CUSTOMER SET3 SET6
CR_CUSTOMER		Alpha 9 (Right Justified)The customer number associated with the applied payment or credit memo.ARLL.1
#ARA-CR-BATCH SET2 SET3 SET5 SET6
CR_BATCH		Numeric 6The cash batch number associated with the applied payment or credit memo.ARLL.1
#ARA-CR-PYMNT-SEQ SET2 SET3 SET5 SET6
CR_PYMNT_SEQ		Numeric 6The 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 SET3 SET6
CR_TYPE		Alpha 1The 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 SET3 SET6
CR_NBR		Alpha 22The transaction number of the applied payment or credit memo.ARLL.1
#ARA-CR-SUFFIX SET3 SET6
CR_SUFFIX		Numeric 3Suffix number needed for file relationships.ARLL.1
#ARA-CR-CANCEL-SEQ SET3 SET6
CR_CANCEL_SEQ		Numeric 4The bill of exchange cancel sequence number.—
#ARA-CR-APP-SEQ SET3 SET6
CR_APP_SEQ		Numeric 7Sequence number of the application made with this payment or credit memo.ARLL.1
#ARA-CR-APP-AMT
CR_APP_AMT		Signed 18.2The 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
CR_ORIG_AP_AMT		Signed 18.2The amount of the application in the currency of the payment.ARLL.1
#ARA-CR-ADJ-SEQ
CR_ADJ_SEQ		Numeric 3The sequence number of the credit adjustment.—
#ARA-CR-ADJ-AMT
CR_ADJ_AMT		Signed 18.2The amount of the credit adjustment.—
#ARA-DEPOSIT-DATE
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
OPR_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 SET5 SET6
GL_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
AR_CODE		Alpha 4The 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
OFFSET_CODE		Alpha 4The 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
APP_SOURCE		Alpha 1Indicates 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
RESULT_FL		Alpha 1Indicates 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: charges assessed assessed
  • 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
  • Y Fully applied (late) with charges
ARLL.1
#ARA-ORIG-APP-AMT
ORIG_APP_AMT		Signed 18.2The application amount in transaction currency.ARLL.1
#ARA-APP-CURR-CD
APP_CURR_CD		Alpha 5The currency of the application.ARLL.1
#ARA-APP-CURR
APP_CURR		Alpha 1This 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
REVERSE_FL		Alpha 1Indicates 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
PREPAY_FLAG		Numeric 1Indicates if payment is a prepayment.—
#ARA-DELETE-FL
DELETE_FL		Alpha 1—
  • C Credit Memo Deleted
  • D Debit Memo Deleted
  • I Invoice Deleted
  • P Payment Deleted
—
#ARA-AR-CUST-PO-NBR
AR_CUST_PO_NBR		Derived——
#ARA-AR-DUE-DATE
AR_DUE_DATE		Derived——
#ARA-AMD-AR-OBJ-ID SET7
AMD_AR_OBJ_ID		Numeric 12——
#ARA-AMD-OFF-OBJ-ID SET8
AMD_OFF_OBJ_ID		Numeric 12——

Indexes (8)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
ARASET1
  1. COMPANY
  2. TRANS-TYPE
  3. INVOICE
  4. PAYMENT-SEQ
  5. BATCH-NBR
  6. APP-SEQ
Primary, KeyChangeAR09.1, AR09.4, AR10.1, AR11.1, AR12.1, AR12.2, AR13.1, AR13.2 +9 more
ARASET2
  1. CR-COMPANY
  2. CR-BATCH
  3. CR-PYMNT-SEQ
  4. COMPANY
  5. TRANS-TYPE
  6. INVOICE
  7. PAYMENT-SEQ
  8. BATCH-NBR
  9. APP-SEQ
KeyChange, SubsetWhere CR-TYPE = "P"CB06.2, CB191
ARASET3
  1. CR-COMPANY
  2. CR-CUSTOMER
  3. CR-TYPE
  4. CR-NBR
  5. CR-PYMNT-SEQ
  6. CR-BATCH
  7. CR-SUFFIX
  8. CR-CANCEL-SEQ
  9. CR-APP-SEQ
KeyChange, SubsetWhere CR-COMPANY != ZeroesCB191
ARASET4
  1. COMPANY
  2. TRANS-TYPE
  3. INVOICE
  4. PAYMENT-SEQ
  5. BATCH-NBR
  6. APP-SEQ
KeyChange, SubsetWhere STATUS = Zeroes Or STATUS = 2 Or STATUS = 4—
ARASET5
  1. COMPANY
  2. GL-DATE
  3. TRANS-TYPE
  4. INVOICE
  5. PAYMENT-SEQ
  6. BATCH-NBR
  7. APP-SEQ
  8. CR-COMPANY
  9. CR-BATCH
  10. CR-PYMNT-SEQ
KeyChange—
ARASET6
  1. CR-COMPANY
  2. GL-DATE
  3. CR-CUSTOMER
  4. CR-TYPE
  5. CR-NBR
  6. CR-PYMNT-SEQ
  7. CR-SUFFIX
  8. CR-CANCEL-SEQ
  9. CR-BATCH
  10. CR-APP-SEQ
KeyChange, SubsetWhere CR-COMPANY != Zeroes—
ARASET7
  1. AMD-AR-OBJ-ID
  2. COMPANY
  3. TRANS-TYPE
  4. INVOICE
  5. PAYMENT-SEQ
  6. BATCH-NBR
  7. APP-SEQ
—
ARASET8
  1. AMD-OFF-OBJ-ID
  2. COMPANY
  3. TRANS-TYPE
  4. INVOICE
  5. PAYMENT-SEQ
  6. BATCH-NBR
  7. APP-SEQ
—

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
ARAPPLDBODARCOMPARCUSTOMERARDISTRIBAROIHDRAROITEMSARPAYMENTCUSTDESCARADJUSTARDRAFTSARAPPLIED

One to one (10) — lookups and parents

RelationTableRulesConditionField map
ArappldbodARAPPLDBODNot Required, Delete Cascades
ARA-COMPANY→YBK-COMPANY (YBKSET1)
ARA-TRANS-TYPE→YBK-TRANS-TYPE
ARA-INVOICE→YBK-INVOICE
ARA-PAYMENT-SEQ→YBK-PAYMENT-SEQ
ARA-BATCH-NBR→YBK-BATCH-NBR
ARA-APP-SEQ→YBK-APP-SEQ
ArcompARCOMPRequired
ARA-COMPANY→ACO-COMPANY
ArcrcompARCOMPRequiredWhen ARA-CR-COMPANY != Zeroes
ARA-CR-COMPANY→ACO-COMPANY
ArcrcustomerARCUSTOMERRequiredWhen ARA-CR-CUSTOMER != Spaces And ARA-CR-CUSTOMER != "000000000"
ARA-CR-COMPANY→ACM-COMPANY
ARA-CR-CUSTOMER→ACM-CUSTOMER
Ardistrib ArARDISTRIBRequired
ARA-AMD-AR-OBJ-ID→AMD-ARA-OBJ-ID
Ardistrib OffARDISTRIBRequired
ARA-AMD-AR-OBJ-ID→AMD-ARA-OBJ-ID
AroihdrAROIHDRRequired
ARA-COMPANY→ARH-COMPANY
ARO-ALT-TYPE→ARH-TRANS-TYPE
ARA-INVOICE→ARH-INVOICE
AroitemsAROITEMSRequired
ARA-COMPANY→ARO-COMPANY
ARA-TRANS-TYPE→ARO-TRANS-TYPE
ARA-INVOICE→ARO-INVOICE
ARA-PAYMENT-SEQ→ARO-PAYMENT-SEQ
ArpaymentARPAYMENTRequiredWhen ARA-CR-TYPE = "P"
ARA-CR-COMPANY→APM-COMPANY
ARA-CR-BATCH→APM-BATCH-NBR
ARA-CR-PYMNT-SEQ→APM-PAYMENT-SEQ
CustdescpayCUSTDESCRequiredWhen ARA-CR-CUSTOMER != Spaces And ARA-CR-CUSTOMER != "000000000"
ACO-CUST-GROUP→CUD-CUST-GROUP
ARA-CR-CUSTOMER→CUD-CUSTOMER

One to many (2) — child tables

RelationTableRulesConditionField map
AradjustARADJUSTDelete 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
ArdraftsARDRAFTSRequired
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

Programs

Updated by (3)

Referenced by (14)