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.

Field / column	Type	Description & values	Updated by
`ARA-COMPANY` PK COMPANY	Numeric 4	The number representing an AR company.	ARLL.1
`ARA-TRANS-TYPE` PK TRANS_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` PK INVOICE	Alpha 22	Used to identify the invoice.	ARLL.1
`ARA-PAYMENT-SEQ` PK PAYMENT_SEQ	Numeric 6	A unique number assigned to each transaction to be interfaced into the Lawson system.	ARLL.1
`ARA-BATCH-NBR` PK 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` PK APP_SEQ	Numeric 7	The number of applications made to a specific transaction.	ARLL.1
`ARA-STATUS` 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` APPLD_AMT	Signed 18.2	The amount applied to the transaction by this payment or credit memo.	ARLL.1
`ARA-ADJ-AMT` ADJ_AMT	Signed 18.2	The total amount of adjustments made with this application.	—
`ARA-ADJ-SEQ` ADJ_SEQ	Numeric 3	The last adjustment sequence number for this application record.	—
`ARA-CR-COMPANY` CR_COMPANY	Numeric 4	The company number associated with the applied payment or credit memo.	ARLL.1
`ARA-CR-CUSTOMER` CR_CUSTOMER	Alpha 9 (Right Justified)	The customer number associated with the applied payment or credit memo.	ARLL.1
`ARA-CR-BATCH` CR_BATCH	Numeric 6	The cash batch number associated with the applied payment or credit memo.	ARLL.1
`ARA-CR-PYMNT-SEQ` CR_PYMNT_SEQ	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` CR_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` CR_NBR	Alpha 22	The transaction number of the applied payment or credit memo.	ARLL.1
`ARA-CR-SUFFIX` CR_SUFFIX	Numeric 3	Suffix number needed for file relationships.	ARLL.1
`ARA-CR-CANCEL-SEQ` CR_CANCEL_SEQ	Numeric 4	The bill of exchange cancel sequence number.	—
`ARA-CR-APP-SEQ` CR_APP_SEQ	Numeric 7	Sequence number of the application made with this payment or credit memo.	ARLL.1
`ARA-CR-APP-AMT` CR_APP_AMT	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` CR_ORIG_AP_AMT	Signed 18.2	The amount of the application in the currency of the payment.	ARLL.1
`ARA-CR-ADJ-SEQ` CR_ADJ_SEQ	Numeric 3	The sequence number of the credit adjustment.	—
`ARA-CR-ADJ-AMT` CR_ADJ_AMT	Signed 18.2	The 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` 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 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` 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` APP_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` RESULT_FL	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: 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.2	The application amount in transaction currency.	ARLL.1
`ARA-APP-CURR-CD` APP_CURR_CD	Alpha 5	The currency of the application.	ARLL.1
`ARA-APP-CURR` APP_CURR	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` REVERSE_FL	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` PREPAY_FLAG	Numeric 1	Indicates 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` AMD_AR_OBJ_ID	Numeric 12	—	—
`ARA-AMD-OFF-OBJ-ID` AMD_OFF_OBJ_ID	Numeric 12	—	—

Indexes (8)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`ARASET1`	`COMPANY`, `TRANS-TYPE`, `INVOICE`, `PAYMENT-SEQ`, `BATCH-NBR`, `APP-SEQ`	Primary, KeyChange		AR09.1, AR09.4, AR10.1, AR11.1, AR12.1, AR12.2, AR13.1, AR13.2 +9 more
`ARASET2`	`CR-COMPANY`, `CR-BATCH`, `CR-PYMNT-SEQ`, `COMPANY`, `TRANS-TYPE`, `INVOICE`, `PAYMENT-SEQ`, `BATCH-NBR`, `APP-SEQ`	KeyChange, Subset	Where CR-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	Where CR-COMPANY != Zeroes	CB191
`ARASET4`	`COMPANY`, `TRANS-TYPE`, `INVOICE`, `PAYMENT-SEQ`, `BATCH-NBR`, `APP-SEQ`	KeyChange, Subset	Where STATUS = Zeroes Or STATUS = 2 Or STATUS = 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	Where CR-COMPANY != Zeroes	—
`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`			—

Relations

One to one (10) — lookups and parents

Relation	Table	Rules	Condition	Field map
Arappldbod	ARAPPLDBOD	Not 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`
Arcomp	ARCOMP	Required		`ARA-COMPANY` → `ACO-COMPANY`
Arcrcomp	ARCOMP	Required	When ARA-CR-COMPANY != Zeroes	`ARA-CR-COMPANY` → `ACO-COMPANY`
Arcrcustomer	ARCUSTOMER	Required	When ARA-CR-CUSTOMER != Spaces And ARA-CR-CUSTOMER != "000000000"	`ARA-CR-COMPANY` → `ACM-COMPANY`, `ARA-CR-CUSTOMER` → `ACM-CUSTOMER`
Ardistrib Ar	ARDISTRIB	Required		`ARA-AMD-AR-OBJ-ID` → `AMD-ARA-OBJ-ID`
Ardistrib Off	ARDISTRIB	Required		`ARA-AMD-AR-OBJ-ID` → `AMD-ARA-OBJ-ID`
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 And ARA-CR-CUSTOMER != "000000000"	`ACO-CUST-GROUP` → `CUD-CUST-GROUP`, `ARA-CR-CUSTOMER` → `CUD-CUSTOMER`

One to many (2) — child tables

Relation	Table	Rules	Condition	Field map
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`

Programs

Updated by (3)

ARLL.1 AR Transaction Interface
CB06.2 Bank Statement Detail Entry
CB191 Bank Statement Close

Referenced by (14)

AR09.1 Customer Group Address
AR09.4 Bill To
AR10.1 Customer
AR11.1 Customer Contacts
AR12.1 National Account
AR12.2 National Account Speed Entry
AR13.1 MICR Customer
AR13.2 Customer MICR
AR210 Customer Listing
AR301 Customer Purge
AR501 Customer Conversion
AR550 Customer Interface
GL235 AR Currency Rounding GL Report
TX140 Vertex Geocode Update