Lawson Insight Technical Documentation |
|
TATABLEX
TATABLEX FILE
REFERENCED BY
LP06.2 LP06.3 LP06.4 LP06.5 LP07.1 LP201
LP203 LP204 LP140 LP145 LP198
UPDATED BY
LP04.2 LP04.3 LP04.4 LP04.5 LP04.6 LP04.7
LP04.8 LP04.9 HR00.1 HR01.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TBX-COMPANY Numeric 4 LP04.2 LP04.3
Element: Company Hr LP04.4 LP04.5
LP04.6 LP04.7
LP04.8 LP04.9
TBX-TABLE Alpha 10 LP04.2 LP04.3
Element: Ta Table LP04.4 LP04.5
LP04.6 LP04.7
LP04.8 LP04.9
TBX-EFFECTIVE-DATE Numeric 8 (yyyymmdd) LP04.2 LP04.3
Element: Ta Begin Date LP04.4 LP04.5
LP04.6 LP04.7
LP04.8 LP04.9
TBX-FROM Numeric 16 LP04.2 LP04.3
Element: Ta From LP04.4 LP04.5
LP04.6 LP04.7
LP04.8 LP04.9
TBX-AMT-PCT Signed 18.6 LP04.2 LP04.3
Element: Ta Amount LP04.4 LP04.5
LP04.6 LP04.7
LP04.8 LP04.9
TBX-AMT-PCT-IND Numeric 1 LP04.2 LP04.3
Element: Ta Indicator 1 = Amount LP04.4 LP04.5
2 = Percent LP04.6 LP04.7
LP04.8 LP04.9
TBX-FORMULA Alpha 10 LP04.2 LP04.6
Element: Ta Formula
TBX-CALCULATION Alpha 10 LP04.2 LP04.3
Element: Ta Calculation LP04.4 LP04.5
LP04.6 LP04.7
LP04.8 LP04.9
TBX-MAXIMUM Signed 18.6 LP04.2 LP04.3
Element: Ta Maximum LP04.4 LP04.6
LP04.7 LP04.8
TBX-DATE-STAMP Numeric 8 (yyyymmdd) LP04.2 LP04.3
Element: Date Stamp This field contains the server date LP04.4 LP04.5
(month, date, and year) of the last LP04.6 LP04.7
change to this record. LP04.8 LP04.9
TBX-TIME-STAMP Numeric 6 (hhmmss) LP04.2 LP04.3
Element: Time Stamp Contains the server time (hour, minute, LP04.4 LP04.5
and second) when the record was last LP04.6 LP04.7
changed. LP04.8 LP04.9
TBX-USER-ID Alpha 10 (Lower Case) LP04.2 LP04.3
Element: User LP04.4 LP04.5
LP04.6 LP04.7
LP04.8 LP04.9
TATABLEX FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TBXSET1 COMPANY HR00.1 HR01.1
TABLE LP04.2 LP04.3
EFFECTIVE-DATE LP04.4 LP04.5
FROM LP04.6 LP04.7
LP04.8 LP04.9
LP06.2 LP06.3
LP06.4 LP06.5
LP07.1 LP201
LP203 LP204
TBXSET2 COMPANY LP140 LP145
TABLE LP198
EFFECTIVE-DATE
FROM*
TATABLEX FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
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
|