TATABLEX – No description in the Lawson data dictionary

System: Absence Management (LP)
Prefix: TBX
Primary key: COMPANY, TABLE, EFFECTIVE-DATE, FROM
Fields: 12
Updated by: 15 programs
Referenced by: 6 programs

TATABLEX is a Lawson Absence Management table (prefix TBX); no description in the lawson data dictionary. It is indexed by COMPANY, TABLE, EFFECTIVE-DATE, FROM (TBXSET1); alternate indexes: TBXSET2. It is related 1:1 to TACALC, PRSYSTEM, TAFORMULAS and TATABLE. It is updated by HR00.1, HR01.1, LP04.2, LP04.3, LP04.4, LP04.5, LP04.6, LP04.7 and 7 more and referenced by LP140, LP145, LP198, LP201, LP203 and LP204. The table has 12 fields, 2 indexes and 4 documented relations.

About TATABLEX

No description in the Lawson data dictionary.

Fields (12)

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

Field / column	Type	Description & values	Updated by
`TBX-COMPANY` PK COMPANY	Numeric 4	—	LP04.2, LP04.3, LP04.4, LP04.5, LP04.6, LP04.7, LP04.8, LP04.9
`TBX-TABLE` PK TABLE	Alpha 10	—	LP04.2, LP04.3, LP04.4, LP04.5, LP04.6, LP04.7, LP04.8, LP04.9
`TBX-EFFECTIVE-DATE` PK EFFECTIVE_DATE	Numeric 8 (yyyymmdd)	—	LP04.2, LP04.3, LP04.4, LP04.5, LP04.6, LP04.7, LP04.8, LP04.9
`TBX-FROM` PK FROM	Numeric 16	—	LP04.2, LP04.3, LP04.4, LP04.5, LP04.6, LP04.7, LP04.8, LP04.9
`TBX-AMT-PCT` AMT_PCT	Signed 18.6	—	LP04.2, LP04.3, LP04.4, LP04.5, LP04.6, LP04.7, LP04.8, LP04.9
`TBX-AMT-PCT-IND` AMT_PCT_IND	Numeric 1	— `1` Amount `2` Percent	LP04.2, LP04.3, LP04.4, LP04.5, LP04.6, LP04.7, LP04.8, LP04.9
`TBX-FORMULA` FORMULA	Alpha 10	—	LP04.2, LP04.6
`TBX-CALCULATION` CALCULATION	Alpha 10	—	LP04.2, LP04.3, LP04.4, LP04.5, LP04.6, LP04.7, LP04.8, LP04.9
`TBX-MAXIMUM` MAXIMUM	Signed 18.6	—	LP04.2, LP04.3, LP04.4, LP04.6, LP04.7, LP04.8
`TBX-DATE-STAMP` DATE_STAMP	Numeric 8 (yyyymmdd)	This field contains the server date (month, date, and year) of the last change to this record.	LP04.2, LP04.3, LP04.4, LP04.5, LP04.6, LP04.7, LP04.8, LP04.9
`TBX-TIME-STAMP` TIME_STAMP	Numeric 6 (hhmmss)	Contains the server time (hour, minute, and second) when the record was last changed.	LP04.2, LP04.3, LP04.4, LP04.5, LP04.6, LP04.7, LP04.8, LP04.9
`TBX-USER-ID` USER_ID	Alpha 10 (Lower Case)	—	LP04.2, LP04.3, LP04.4, LP04.5, LP04.6, LP04.7, LP04.8, LP04.9

Indexes (2)

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
`TBXSET1`	`COMPANY`, `TABLE`, `EFFECTIVE-DATE`, `FROM`	Primary		HR00.1, HR01.1, LP04.2, LP04.3, LP04.4, LP04.5, LP04.6, LP04.7 +10 more
`TBXSET2`	`COMPANY`, `TABLE`, `EFFECTIVE-DATE`, `FROM*`			LP140, LP145, LP198

Relations

One to one (4) — lookups and parents

Relation	Table	Rules	Condition	Field map
Calculation	TACALC	Required	When (TBX-CALCULATION != Spaces)	`TBX-COMPANY` → `TCA-COMPANY`, `TBX-CALCULATION` → `TCA-CALCULATION`
Company	PRSYSTEM	Required		`TBX-COMPANY` → `PRS-COMPANY`, `Spaces` → `PRS-PROCESS-LEVEL`
Formula	TAFORMULAS	Required	When (TBX-FORMULA != Spaces)	`TBX-COMPANY` → `TFO-COMPANY`, `TBX-FORMULA` → `TFO-FORMULA`
Table	TATABLE	Required		`TBX-COMPANY` → `TBL-COMPANY`, `TBX-TABLE` → `TBL-TABLE`, `TBX-EFFECTIVE-DATE` → `TBL-EFFECTIVE-DATE`

Programs

Updated by (15)

HR00.1 Company
HR01.1 Process Level
LP04.2 Cycle Based Accrual Table
LP04.3 Cycle Based Allotment Table
LP04.4 Cycle Based Limit Table
LP04.5 Cycle Based GL Liability Table
LP04.6 Hours Based Accrual Table
LP04.7 Hours Based Allotment Table
LP04.8 Hours Based Limit Table
LP04.9 Hours Based GL Liability Table
LP06.2 Cycle Amount Formula
LP06.3 Hours Amount Formula
LP06.4 Ratio Formula
LP06.5 Date Formula
LP07.1 Calculation

Referenced by (6)

LP140 Employee Absence Plan Calculation
LP145 Allotment Adjustment Calculation
LP198 General Ledger Liability Update
LP201 Absence Plan Listing
LP203 Absence Plan Rules Listing
LP204 Rules Tables Listing