Lawson Insight Technical Documentation |
|
TAFORMULAX
TAFORMULAX FILE
REFERENCED BY
LP07.1 LP08.1 LP140 LP145 LP198 LP201
LP203 LP206
UPDATED BY
LP06.2 LP06.3 LP06.4 LP06.5 HR00.1 HR01.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TFX-COMPANY Numeric 4 LP06.2 LP06.3
Element: Company Hr LP06.4 LP06.5
TFX-FORMULA Alpha 10 LP06.2 LP06.3
Element: Ta Formula LP06.4 LP06.5
TFX-FROM-HOURS Numeric 16 LP06.2 LP06.3
Element: Ta From LP06.4 LP06.5
TFX-RATIO-SRV-CLS Alpha 3 LP06.2 LP06.3
Element: Ta Service Cls LP06.4 LP06.5
TFX-FORMULA-DATE Numeric 8 (yyyymmdd) LP06.2 LP06.3
Element: Ta Formula Dt LP06.4 LP06.5
TFX-DATE-DESC Alpha 30 (Lower Case) LP06.5
Element: Ta Description
TFX-MULT-SRV-CLS Alpha 3 LP06.2 LP06.3
Element: Ta Service Cls
TFX-FORMULA-AMT Signed 18.6 LP06.2 LP06.3
Element: Ta Amount LP06.4 LP06.5
TFX-CALCULATION Alpha 10 LP06.2 LP06.3
Element: Ta Calc LP06.4 LP06.5
TFX-DATE-STAMP Numeric 8 (yyyymmdd) LP06.2 LP06.3
Element: Date Stamp This field contains the server date LP06.4 LP06.5
(month, date, and year) of the last
change to this record.
TFX-TIME-STAMP Numeric 6 (hhmmss) LP06.2 LP06.3
Element: Time Stamp Contains the server time (hour, minute, LP06.4 LP06.5
and second) when the record was last
changed.
TFX-USER-ID Alpha 10 (Lower Case) LP06.2 LP06.3
Element: User LP06.4 LP06.5
TAFORMULAX FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TFXSET1 COMPANY HR00.1 HR01.1
FORMULA LP06.2 LP06.3
FROM-HOURS LP06.4 LP06.5
RATIO-SRV-CLS LP07.1 LP08.1
FORMULA-DATE LP140 LP145
LP198 LP201
LP203 LP206
TFXSET2 COMPANY LP140 LP145
FORMULA LP198
FROM-HOURS*
RATIO-SRV-CLS
FORMULA-DATE
TAFORMULAX FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Calculation TACALC Required
When (TFX-CALCULATION != Spaces )
TFX-COMPANY -> TCA-COMPANY
TFX-CALCULATION -> TCA-CALCULATION
Company PRSYSTEM Required
TFX-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Formulas TAFORMULAS Required
TFX-COMPANY -> TFO-COMPANY
TFX-FORMULA -> TFO-FORMULA
Mult Srv Cls TASERVCLSS Required
When (TFX-MULT-SRV-CLS != Spaces )
TFX-COMPANY -> TSL-COMPANY
TFX-MULT-SRV-CLS -> TSL-SERVICE-CLASS
Ratio Srv Cls TASERVCLSS Required
When (TFX-RATIO-SRV-CLS != Spaces )
TFX-COMPANY -> TSL-COMPANY
TFX-RATIO-SRV-CLS -> TSL-SERVICE-CLASS
|