TATABLEX

REFERENCED BY
LP140 LP145 LP198 LP06.2 LP06.3 LP06.4
LP06.5 LP07.1 LP201 LP203 LP204


UPDATED BY
HR00.1 HR01.1 LP04.2 LP04.3 LP04.4 LP04.5
LP04.6 LP04.7 LP04.8 LP04.9

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TBX-COMPANY
Element: Company Hr
Numeric 4
LP04.2 LP04.3
LP04.4 LP04.5
LP04.6 LP04.7
LP04.8 LP04.9
TBX-TABLE
Element: Ta Table
Alpha 10
LP04.2 LP04.3
LP04.4 LP04.5
LP04.6 LP04.7
LP04.8 LP04.9
TBX-EFFECTIVE-DATE
Element: Ta Begin Date
Numeric 8 (yyyymmdd)
LP04.2 LP04.3
LP04.4 LP04.5
LP04.6 LP04.7
LP04.8 LP04.9
TBX-FROM
Element: Ta From
Numeric 16
LP04.2 LP04.3
LP04.4 LP04.5
LP04.6 LP04.7
LP04.8 LP04.9
TBX-AMT-PCT
Element: Ta Amount
Signed 18.6
LP04.2 LP04.3
LP04.4 LP04.5
LP04.6 LP04.7
LP04.8 LP04.9
TBX-AMT-PCT-IND
Element: Ta Indicator
Numeric 1

1 = Amount
2 = Percent
LP04.2 LP04.3
LP04.4 LP04.5
LP04.6 LP04.7
LP04.8 LP04.9
TBX-FORMULA
Element: Ta Formula
Alpha 10
LP04.2 LP04.6
TBX-CALCULATION
Element: Ta Calculation
Alpha 10
LP04.2 LP04.3
LP04.4 LP04.5
LP04.6 LP04.7
LP04.8 LP04.9
TBX-MAXIMUM
Element: Ta Maximum
Signed 18.6
LP04.2 LP04.3
LP04.4 LP04.6
LP04.7 LP04.8
TBX-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.
LP04.2 LP04.3
LP04.4 LP04.5
LP04.6 LP04.7
LP04.8 LP04.9
TBX-TIME-STAMP
Element: 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
Element: User
Alpha 10 (Lower Case)
LP04.2 LP04.3
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
TABLE
EFFECTIVE-DATE
FROM
HR00.1 HR01.1
LP04.2 LP04.3
LP04.4 LP04.5
LP04.6 LP04.7
LP04.8 LP04.9
LP06.2 LP06.3
LP06.4 LP06.5
LP07.1 LP201
LP203 LP204
TBXSET2 COMPANY
TABLE
EFFECTIVE-DATE
FROM*
LP140 LP145
LP198


TATABLEX FILE RELATIONS


ONE TO ONE RELATIONS

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


File created: Thu Jun 09 11:19:49 2016

Home
Contact Us



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