ARCODE – AR GL Code

System
Accounts Receivable (AR)
Prefix
RCD
Primary key
COMPANY, AR-CODE
Fields
8
Updated by
5 programs
Referenced by
7 programs

ARCODE is the AR GL Code table in Lawson Accounts Receivable (prefix RCD). It is indexed by COMPANY, AR-CODE (RCDSET1). It is related 1:1 to ARCOMP. It is updated by AR01.1, AR02.1, AR15.7, BRIP.1 and WH20.7 and referenced by AR08.1, AR10.1, AR215, AR501, AR550, ARLL.1 and CB191. The table has 8 fields, 1 index and 1 documented relation.

About ARCODE

The AR GL Code file holds codes that represent accounts receivable, received not applied, prepayment, and finance charge general ledger accounts to be used in the Accounts Receivable System.

Fields (8)

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

Field / columnTypeDescription & valuesUpdated by
RCD-COMPANY PK
COMPANY		Numeric 4The number representing an AR company.AR01.1, AR15.7
RCD-AR-CODE PK
AR_CODE		Alpha 4This code is used to identify accounts receivable accounts (trade, non-trade, etc), prepayment, received not applied, and finance charge accounts.AR01.1, AR15.7
RCD-DESC
DESC		Alpha 30 (Lower Case)Contains a description of the code.AR01.1, AR15.7
RCD-ACCT-UNIT
ACCT_UNIT		Alpha 15This is the general ledger accounting unit of the associated AR Code.AR01.1, AR15.7
RCD-ACCOUNT
ACCOUNT		Numeric 6This is the general ledger account number of the AR code.AR01.1, AR15.7
RCD-SUB-ACCT
SUB_ACCT		Numeric 4This is the general ledger subaccount of the AR Code.AR01.1, AR15.7
RCD-USED-FL
USED_FL		Alpha 1The used flag that signifies if a code has been used. A code cannot be deleted once it has been used, and only the description will be allowed to change once in use. By adding this code to a process level record, the code will be considered used. Valid values are:
  • N Not used
  • Y Used
AR01.1, AR02.1, AR15.7, BRIP.1, WH20.7
RCD-ACTIVE-STATUS
ACTIVE_STATUS		Alpha 1Indicates whether the code has an active or inactive status. Valid values are:
  • A Active
  • I Inactive
AR01.1, AR15.7

Indexes (1)

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

IndexKeysFlagsConditionUsed in
RCDSET1COMPANY, AR-CODEPrimaryAR01.1, AR02.1, AR08.1, AR10.1, AR15.7, AR215, AR501, AR550 +4 more

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
ArcompARCOMPRequiredRCD-COMPANY → ACO-COMPANY

Programs

Updated by (5)

Referenced by (7)