ARCYCLE – Accounts Receivable Cycle Code

System
Accounts Receivable (AR)
Prefix
ACY
Primary key
COMPANY, CYCLE-TYPE, CYCLE
Fields
5
Updated by
2 programs
Referenced by
10 programs

ARCYCLE is the Accounts Receivable Cycle Code table in Lawson Accounts Receivable (prefix ACY). It is indexed by COMPANY, CYCLE-TYPE, CYCLE (ACYSET1). It is updated by AR01.1 and AR04.1 and referenced by AR08.1, AR09.1, AR10.1, AR12.1, AR12.2, AR204, AR301, AR501 and 2 more. The table has 5 fields, 1 index and 0 documented relations.

About ARCYCLE

The AR Cycle Code file stores the valid customer statement cyclendunning cycle, and finance charge cycle information established in AR04 (Cycle Codes). Cycle codes are user defined and are assigned to each individual customer by adding the cycle code to the customer master record.

Fields (5)

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

Field / columnTypeDescription & valuesUpdated by
ACY-COMPANY PK
COMPANY		Numeric 4Company number.AR01.1, AR04.1
ACY-CYCLE-TYPE PK
CYCLE_TYPE		Alpha 1Indicates the cycle code type. Valid values are:
  • B Balance Forward
  • O Open Item
  • D Dunning Notice
  • F Finance Charge
AR01.1, AR04.1
ACY-CYCLE PK
CYCLE		Alpha 2Cycle code.AR01.1, AR04.1
ACY-CYCLE-RANGE1
CYCLE_RANGE1		Alpha 1Valid only for statement cycle codes for balance forward customers. This is the first value, of the first letter, of the customer search name which determines the beginning alpha sort range to assign statement cycle codes.AR04.1
ACY-CYCLE-RANGE2
CYCLE_RANGE2		Alpha 1Valid only for statement cycle codes for balance forward customers. This ending value, of the first letter, of the customer search name which determines the ending alpha sort range to assign statement cycle codes.AR04.1

Indexes (1)

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

IndexKeysFlagsConditionUsed in
ACYSET1COMPANY, CYCLE-TYPE, CYCLEPrimaryAR01.1, AR04.1, AR08.1, AR09.1, AR10.1, AR12.1, AR12.2, AR204 +4 more

Programs

Updated by (2)

Referenced by (10)