BNATXLIMIT – No description in the Lawson data dictionary

System
Human Resources (HR)
Prefix
ALF
Primary key
TAX-STATUS, EFFECT-DATE
Fields
5
Updated by
1 program
Referenced by
0 programs

BNATXLIMIT is a Lawson Human Resources table (prefix ALF); no description in the lawson data dictionary. It is indexed by TAX-STATUS, EFFECT-DATE (ALFSET1). It is updated by BN12.2. The table has 5 fields, 1 index and 0 documented relations.

About BNATXLIMIT

No description in the Lawson data dictionary.

Fields (5)

Column = COBOL field name without the ALF- 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
#ALF-TAX-STATUS PK
TAX_STATUS		Alpha 2—BN12.2
#ALF-EFFECT-DATE PK
EFFECT_DATE		Numeric 8 (yyyymmdd)—BN12.2
#ALF-REMUN-CODE
REMUN_CODE		Alpha 4——
#ALF-DED-LIMIT
DED_LIMIT		Signed 18.2—BN12.2
#ALF-CU-DED-LIMIT
CU_DED_LIMIT		Signed 18.2—BN12.2

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
ALFSET1
  1. TAX-STATUS
  2. EFFECT-DATE
PrimaryBN12.2

Programs

Updated by (1)