ARCATEGORY – Accounts Receivable Category

System: Accounts Receivable (AR)
Prefix: ACA
Primary key: COMPANY, AR-CATEGORY
Fields: 12
Updated by: 1 program
Referenced by: 1 program

ARCATEGORY is the Accounts Receivable Category table in Lawson Accounts Receivable (prefix ACA). It is indexed by COMPANY, AR-CATEGORY (ACASET1). It is related 1:1 to ARCOMP, GLMASTER and TXTAXCODE. It is updated by AR15.4 and referenced by AR215. The table has 12 fields, 1 index and 3 documented relations.

About ARCATEGORY

The AR Category file is used for defaulting general ledger account distributions for manual transaction entry in AR42 (Transaction Entry).

Fields (12)

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

Field / column	Type	Description & values	Updated by
`ACA-COMPANY` PK COMPANY	Numeric 4	The number representing an AR company.	AR15.4
`ACA-AR-CATEGORY` PK AR_CATEGORY	Alpha 5	User-defined category code used to default general ledger accounts during manual transaction entry.	AR15.4
`ACA-ACCT-UNIT` ACCT_UNIT	Alpha 15	The accounting unit is a shorthand notation representing the variable level number. When used in the General Ledger Account Master file, the accounting unit must be defined in the General Ledger Names file as a posting accounting unit.	AR15.4
`ACA-ACCOUNT` ACCOUNT	Numeric 6	This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.	AR15.4
`ACA-SUB-ACCOUNT` SUB_ACCOUNT	Numeric 4	This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.	AR15.4
`ACA-DESCRIPTION` DESCRIPTION	Alpha 30 (Lower Case)	The description of the category.	AR15.4
`ACA-ACTIVITY` ACTIVITY	Alpha 15	Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity.	AR15.4
`ACA-TAX-CODE` TAX_CODE	Alpha 10	This field contains a code representing specific tax information. This must be valid Tax Code.	AR15.4
`ACA-TAX-EXEMPT-CD` TAX_EXEMPT_CD	Alpha 1	Used By Lawson Order Entry. Determines whether category is tax exempt or not. Valid values are: `E` Exempt `T` Taxable	AR15.4
`ACA-ACCT-CATEGORY` ACCT_CATEGORY	Alpha 5	The activity account category.	AR15.4
`ACA-ACCT-UNIT-FLAG` ACCT_UNIT_FLAG	Alpha 1	Will determine if the account unit of the category can be overriden during processing. `N` Acct Unit Can be Overridden `Y` Acct Unit Can't be Overridden	AR15.4
`ACA-LINE-TYPE` LINE_TYPE	Alpha 1	This field contains the transaction line type for possible intrastat usage. Valid values are: Blank `G` Goods `S` Service	AR15.4

Indexes (1)

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
`ACASET1`	`COMPANY`, `AR-CATEGORY`	Primary		AR15.4, AR215

Relations

One to one (3) — lookups and parents

Relation	Table	Rules	Field map
Arcomp	ARCOMP	Required	`ACA-COMPANY` → `ACO-COMPANY`
Glmaster	GLMASTER	Required	`ACA-COMPANY` → `GLM-COMPANY`, `ACA-ACCT-UNIT` → `GLM-ACCT-UNIT`, `ACA-ACCOUNT` → `GLM-ACCOUNT`, `ACA-SUB-ACCOUNT` → `GLM-SUB-ACCOUNT`
Txtaxcode	TXTAXCODE	Not Required	`ACA-COMPANY` → `TAC-COMPANY`, `ACA-TAX-CODE` → `TAC-TAX-CODE`

ARCATEGORY – Accounts Receivable Category

About ARCATEGORY

Fields (12)

Indexes (1)

Relations

One to one (3) — lookups and parents

Programs

Updated by (1)

Referenced by (1)