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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#ACA-COMPANY PK
COMPANY		Numeric 4The number representing an AR company.AR15.4
#ACA-AR-CATEGORY PK
AR_CATEGORY		Alpha 5User-defined category code used to default general ledger accounts during manual transaction entry.AR15.4
#ACA-ACCT-UNIT
ACCT_UNIT		Alpha 15The 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 6This 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 4This 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 15Activities 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 10This field contains a code representing specific tax information. This must be valid Tax Code.AR15.4
#ACA-TAX-EXEMPT-CD
TAX_EXEMPT_CD		Alpha 1Used 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 5The activity account category.AR15.4
#ACA-ACCT-UNIT-FLAG
ACCT_UNIT_FLAG		Alpha 1Will 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 1This field contains the transaction line type for possible intrastat usage. Valid values are: Blank
  • G Goods
  • S Service
AR15.4

Indexes (1)

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
ACASET1
  1. COMPANY
  2. AR-CATEGORY
PrimaryAR15.4, AR215

Relations

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

One to one (3) — lookups and parents

RelationTableRulesConditionField map
ArcompARCOMPRequired
ACA-COMPANY→ACO-COMPANY
GlmasterGLMASTERRequired
ACA-COMPANY→GLM-COMPANY
ACA-ACCT-UNIT→GLM-ACCT-UNIT
ACA-ACCOUNT→GLM-ACCOUNT
ACA-SUB-ACCOUNT→GLM-SUB-ACCOUNT
TxtaxcodeTXTAXCODENot Required
ACA-COMPANY→TAC-COMPANY
ACA-TAX-CODE→TAC-TAX-CODE

Programs

Updated by (1)

Referenced by (1)