TAFORMULAX

UPDATED BY
LP06.2 LP06.3 LP06.4 LP06.5 HR00.1 HR01.1
LP140 LP145 LP198 LP201 LP203 LP206

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TFX-COMPANY
Element: Company Hr		Numeric 4
LP06.2 LP06.3
LP06.4 LP06.5
TFX-FORMULA
Element: Ta Formula		Alpha 10
LP06.2 LP06.3
LP06.4 LP06.5
TFX-FROM-HOURS
Element: Ta From		Numeric 16
LP06.2 LP06.3
LP06.4 LP06.5
TFX-RATIO-SRV-CLS
Element: Ta Service Cls		Alpha 3
LP06.2 LP06.3
LP06.4 LP06.5
TFX-FORMULA-DATE
Element: Ta Formula Dt		Numeric 8 (yyyymmdd)
LP06.2 LP06.3
LP06.4 LP06.5
TFX-DATE-DESC
Element: Ta Description		Alpha 30 (Lower Case)
LP06.5
TFX-MULT-SRV-CLS
Element: Ta Service Cls		Alpha 3
LP06.2 LP06.3
TFX-FORMULA-AMT
Element: Ta Amount		Signed 18.6
LP06.2 LP06.3
LP06.4 LP06.5
TFX-CALCULATION
Element: Ta Calc		Alpha 10
LP06.2 LP06.3
LP06.4 LP06.5
TFX-DATE-STAMP
Element: Date Stamp		Numeric 8 (yyyymmdd)
This field contains the server date (month, date, and year) of the last change to this record.
LP06.2 LP06.3
LP06.4 LP06.5
TFX-TIME-STAMP
Element: Time Stamp		Numeric 6 (hhmmss)
Contains the server time (hour, minute, and second) when the record was last changed.
LP06.2 LP06.3
LP06.4 LP06.5
TFX-USER-ID
Element: User		Alpha 10 (Lower Case)
LP06.2 LP06.3
LP06.4 LP06.5


TAFORMULAX FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TFXSET1 COMPANY
FORMULA
FROM-HOURS
RATIO-SRV-CLS
FORMULA-DATE
HR00.1 HR01.1
LP06.2 LP06.3
LP06.4 LP06.5
LP140 LP145
LP198 LP201
LP203 LP206
TFXSET2 COMPANY
FORMULA
FROM-HOURS*
RATIO-SRV-CLS
FORMULA-DATE
LP140 LP145
LP198


TAFORMULAX FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED 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

File created: Wed Jun 08 20:50:01 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.