Lawson Insight Technical Documentation |
|
TAFORMULAS
TAFORMULAS FILE
REFERENCED BY
LP04.2 LP04.3 LP04.4 LP04.5 LP04.6 LP04.7
LP04.8 LP04.9 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
TFO-COMPANY Numeric 4 LP06.2 LP06.3
Element: Company Hr LP06.4 LP06.5
TFO-FORMULA Alpha 10 LP06.2 LP06.3
Element: Ta Formula LP06.4 LP06.5
TFO-DESCRIPTION Alpha 30 (Lower Case) LP06.2 LP06.3
Element: Ta Description LP06.4 LP06.5
TFO-FORMULA-TYPE Numeric 2 LP06.2 LP06.3
Element: Ta Type Contains the units of measure for the LP06.4 LP06.5
summarized totals.
01 = Cycle Amount
02 = Hours Amount
03 = Ratio
04 = Date
TFO-HOURS-SRV-CLS Alpha 3 LP06.2
Element: Ta Service Cls
TFO-HOURS-SRV-TYPE Numeric 2 LP06.3
Element: Ta Type Contains the units of measure for the
summarized totals.
01 = Life to date (LTD)
02 = Year to date (YTD)
03 = Prior year total (PYT)
TFO-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.
TFO-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.
TFO-USER-ID Alpha 10 (Lower Case) LP06.2 LP06.3
Element: User LP06.4 LP06.5
TAFORMULAS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TFOSET1 COMPANY HR00.1 HR01.1
FORMULA LP04.2 LP04.3
LP04.4 LP04.5
LP04.6 LP04.7
LP04.8 LP04.9
LP06.2 LP06.3
LP06.4 LP06.5
LP08.1 LP140
LP145 LP198
LP201 LP203
LP206
TFOSET2 COMPANY Subset LP06.2 LP206
FORMULA-TYPE Where (FORMULA-TYPE = 1 )
FORMULA
TFOSET3 COMPANY Subset LP06.3 LP206
FORMULA-TYPE Where (FORMULA-TYPE = 2 )
FORMULA
TFOSET4 COMPANY Subset LP06.4 LP206
FORMULA-TYPE Where (FORMULA-TYPE = 3 )
FORMULA
TFOSET5 COMPANY Subset LP06.5 LP206
FORMULA-TYPE Where (FORMULA-TYPE = 4 )
FORMULA
TAFORMULAS FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
TFO-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Hours Srv Cls TASERVCLSS Required
When (TFO-HOURS-SRV-CLS != Spaces )
TFO-COMPANY -> TSL-COMPANY
TFO-HOURS-SRV-CLS -> TSL-SERVICE-CLASS
TAFORMULAS FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Formulax TAFORMULAX Delete Cascades
TFO-COMPANY -> TFX-COMPANY
TFO-FORMULA -> TFX-FORMULA
TFX-FROM-HOURS
TFX-RATIO-SRV-CLS
TFX-FORMULA-DATE
|