ARSAPPLIED – Cash Application Select

System: Accounts Receivable (AR)
Prefix: ASG
Primary key: CR-COMPANY, CR-BATCH, CR-PYMNT-SEQ, COMPANY, TRANS-TYPE, INVOICE, PAYMENT-SEQ
Fields: 15
Updated by: 1 program
Referenced by: 1 program

ARSAPPLIED is the Cash Application Select table in Lawson Accounts Receivable (prefix ASG). It is indexed by CR-COMPANY, CR-BATCH, CR-PYMNT-SEQ, COMPANY, TRANS-TYPE, INVOICE, PAYMENT-SEQ (ASGSET1); alternate indexes: ASGSET2 and ASGSET3. It is related 1:1 to AROITEMS and ARPAYMENT and 1:M to ARSADJUST. It is updated by CB06.2 and referenced by CB191. The table has 15 fields, 3 indexes and 3 documented relations.

About ARSAPPLIED

The Cash Application Select file contains the cash application select records that have been selected but not yet processed, thereby creating application records.

Fields (15)

Column = COBOL field name without the ASG- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`ASG-CR-COMPANY` PK CR_COMPANY	Numeric 4	The number representing an AR company.	—
`ASG-CR-BATCH` PK CR_BATCH	Numeric 6	The batch of the payment.	—
`ASG-CR-PYMNT-SEQ` PK CR_PYMNT_SEQ	Numeric 6	The sequence number of the payment.	—
`ASG-COMPANY` PK COMPANY	Numeric 4	The company number of the transaction.	—
`ASG-TRANS-TYPE` PK TRANS_TYPE	Alpha 1	The transaction type associated with the selected application. Valid values are: `C` Credit Memo `D` Debit Memo `I` Invoice `P` Payment	—
`ASG-INVOICE` PK INVOICE	Alpha 22	Used to identify the invoice.	—
`ASG-PAYMENT-SEQ` PK PAYMENT_SEQ	Numeric 6	A unique number assigned to each transaction to be interfaced into the Lawson system.	—
`ASG-OPEN-AMT` OPEN_AMT	Signed 18.2	The open amount of the transaction.	—
`ASG-ORIG-OPEN-AMT` ORIG_OPEN_AMT	Signed 18.2	The open amount in transaction currency.	—
`ASG-CR-ORIG-AP-AMT` CR_ORIG_AP_AMT	Signed 18.2	The amount of the application in the payment currency.	—
`ASG-ADJ-SEQ` ADJ_SEQ	Numeric 3	The sequence number of the adjustment.	—
`ASG-GL-DATE` GL_DATE	Numeric 8 (yyyymmdd)	This field contains the date the applications will be posted to the general ledger.	—
`ASG-OPR-CODE` OPR_CODE	Alpha 10 (Lower Case)	This field contains the operator code. This is the user ID of the person who last maintained this record.	—
`ASG-EFT-FL` EFT_FL	Alpha 1	Indicates if the open amount was selected for application during EFT processing. Valid values are: processing processing `Y` Record was written from EFT `N` Record was written from online	—
`ASG-SELECT-SEQ` SELECT_SEQ	Numeric 6	The payment application order.	—

Indexes (3)

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

Index	Keys	Flags	Used in
`ASGSET1`	`CR-COMPANY`, `CR-BATCH`, `CR-PYMNT-SEQ`, `COMPANY`, `TRANS-TYPE`, `INVOICE`, `PAYMENT-SEQ`	Primary	CB06.2, CB191
`ASGSET2`	`COMPANY`, `TRANS-TYPE`, `INVOICE`, `PAYMENT-SEQ`		—
`ASGSET3`	`CR-COMPANY`, `CR-BATCH`, `CR-PYMNT-SEQ`, `SELECT-SEQ`		—

Relations

One to one (2) — lookups and parents

Relation	Table	Rules	Condition	Field map
Aroitems	AROITEMS	Required		`ASG-COMPANY` → `ARO-COMPANY (AROSET1)`, `ASG-TRANS-TYPE` → `ARO-TRANS-TYPE`, `ASG-INVOICE` → `ARO-INVOICE`, `ASG-PAYMENT-SEQ` → `ARO-PAYMENT-SEQ`
Arpayment	ARPAYMENT	Required		`ASG-CR-COMPANY` → `APM-COMPANY`, `ASG-CR-BATCH` → `APM-BATCH-NBR`, `ASG-CR-PYMNT-SEQ` → `APM-PAYMENT-SEQ`

One to many (1) — child tables

Relation	Table	Rules	Condition	Field map
Arsadjust	ARSADJUST	Delete Cascades		`ASG-COMPANY` → `ASJ-COMPANY`, `ASG-TRANS-TYPE` → `ASJ-TRANS-TYPE`, `ASG-INVOICE` → `ASJ-INVOICE`, `ASG-PAYMENT-SEQ` → `ASJ-PAYMENT-SEQ`, `Zeroes` → `ASJ-BATCH-NBR`, → `ASJ-ADJ-SEQ`

ARSAPPLIED – Cash Application Select

About ARSAPPLIED

Fields (15)

Indexes (3)

Relations

One to one (2) — lookups and parents

One to many (1) — child tables

Programs

Updated by (1)

Referenced by (1)