PBTIMEREC FILE
UPDATED BY
AC541 AC542 BN150 BN66.1 PR128 PR130
PR131 PR132 PR134 PR136 PR137 PR140
PR189 PR195 PR197 PR29.1 PR32.1 PR32.2
PR33.1 PR33.2 PR33.3 PR35.1 PR35.2 PR35.3
PR35.4 PR35.5 PR35.6 PR35.8 PR36.1 PR37.1
PR45.1 PR529 PR530 PR560 PR80.1 PR82.1
PR85.1 PR89.1 UK102 UK330 UK560 TA147
UK120
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TPB-COMPANY Numeric 4 AC541 AC542
Element: Company The company number represents an BN150 BN66.1
established company and is entered on PR128 PR130
all function codes. PR131 PR132
PR134 PR136
PR137 PR140
PR189 PR195
PR197 PR29.1
PR32.1 PR32.2
PR33.1 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR36.1 PR37.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
PR85.1 PR89.1
TA147 UK102
UK120 UK330
UK560
TPB-EMPLOYEE Numeric 9 AC541 AC542
Element: Employee Contains the employee number. Each BN150 BN66.1
person employed by the company is PR128 PR130
assigned a unique number. The system PR131 PR132
uses the employee number to correlate PR134 PR136
all of the information related to that PR137 PR140
person. PR189 PR195
PR197 PR29.1
PR32.1 PR32.2
PR33.1 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR36.1 PR37.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
PR85.1 PR89.1
TA147 UK102
UK120 UK330
UK560
TPB-CHECK-ID Numeric 12 BN66.1 PR140
Internal Check ID Contains the payment identification PR189 PR195
Number number (unique payment identifier used PR197 PR80.1
in tracking payment information). PR85.1 PR89.1
TPB-PAY-SUM-GRP Alpha 3 BN66.1 PR140
Payment Summary PR189 PR195
Group PR197 PR80.1
PR85.1 PR89.1
TPB-TIME-SEQ Numeric 12 AC541 AC542
Element: Sequence Number BN150 BN66.1
PR128 PR130
PR131 PR132
PR134 PR136
PR137 PR140
PR189 PR195
PR197 PR29.1
PR32.1 PR32.2
PR33.1 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR36.1 PR37.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
PR85.1 PR89.1
TA147 UK102
UK120 UK330
UK560
TPB-DED-GRP-AMT Signed 15.2 PR80.1 PR85.1
Element: Ded Grp Amt
TPB-DED-GRP-AMT-WC Signed 15.2 PR80.1 PR85.1
Element: Ded Grp Amt Wc
TPB-DED-GRP-AMT-SU Signed 15.2
Element: Ded Grp Amt Su
TPB-PCT-RATE-1 Signed 8.5 AC541 AC542
Element: Pct Rate 1 BN150 BN66.1
PR128 PR130
PR131 PR132
PR134 PR136
PR137 PR140
PR189 PR195
PR197 PR29.1
PR32.1 PR32.2
PR33.1 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR36.1 PR37.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
PR85.1 PR89.1
TA147 UK102
UK120 UK330
UK560
TPB-PCT-RATE-2 Signed 8.5 AC541 AC542
Element: Pct Rate 2 BN150 BN66.1
PR128 PR130
PR131 PR132
PR134 PR136
PR137 PR140
PR189 PR195
PR197 PR29.1
PR32.1 PR32.2
PR33.1 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR36.1 PR37.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
PR85.1 PR89.1
TA147 UK102
UK120 UK330
UK560
TPB-AMT-RATE-1 Signed 6.2 AC541 AC542
Element: Amt Rate 1 BN150 BN66.1
PR128 PR130
PR131 PR132
PR134 PR136
PR137 PR140
PR189 PR195
PR197 PR29.1
PR32.1 PR32.2
PR33.1 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR36.1 PR37.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
PR85.1 PR89.1
TA147 UK102
UK120 UK330
UK560
TPB-AMT-RATE-2 Signed 6.2 AC541 AC542
Element: Amt Rate 2 BN150 BN66.1
PR128 PR130
PR131 PR132
PR134 PR136
PR137 PR140
PR189 PR195
PR197 PR29.1
PR32.1 PR32.2
PR33.1 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR36.1 PR37.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
PR85.1 PR89.1
TA147 UK102
UK120 UK330
UK560
TPB-GROSS-AMT-1 Signed 15.2 AC541 AC542
Element: Gross Amt 1 BN150 BN66.1
PR128 PR130
PR131 PR132
PR134 PR136
PR137 PR140
PR189 PR195
PR197 PR29.1
PR32.1 PR32.2
PR33.1 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR36.1 PR37.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
PR85.1 PR89.1
TA147 UK102
UK120 UK330
UK560
TPB-GROSS-AMT-2 Signed 15.2 AC541 AC542
Element: Gross Amt 2 BN150 BN66.1
PR128 PR130
PR131 PR132
PR134 PR136
PR137 PR140
PR189 PR195
PR197 PR29.1
PR32.1 PR32.2
PR33.1 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR36.1 PR37.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
PR85.1 PR89.1
TA147 UK102
UK120 UK330
UK560
TPB-CLIENT-JOBID Alpha 20 AC541 AC542
Element: Client Jobid BN150 BN66.1
PR128 PR130
PR131 PR132
PR134 PR136
PR137 PR140
PR189 PR195
PR197 PR29.1
PR32.1 PR32.2
PR33.1 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR36.1 PR37.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
PR85.1 PR89.1
TA147 UK102
UK120 UK330
UK560
TPB-TIME-USER-FLD Alpha 20 AC541 AC542
Element: Time User Fld BN150 BN66.1
PR128 PR130
PR131 PR132
PR134 PR136
PR137 PR140
PR189 PR195
PR197 PR29.1
PR32.1 PR32.2
PR33.1 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR36.1 PR37.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
PR85.1 PR89.1
TA147 UK102
UK120 UK330
UK560
TPB-UNITS-AMOUNT Signed 15.2 AC541 AC542
Element: Adj Amt This is the units amount included in BN150 BN66.1
the file. PR128 PR130
PR131 PR132
PR134 PR136
PR137 PR140
PR189 PR195
PR197 PR29.1
PR32.1 PR32.2
PR33.1 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR36.1 PR37.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
PR85.1 PR89.1
TA147 UK102
UK120 UK330
UK560
TPB-UNIT-MEASURE Alpha 12 AC541 AC542
Element: Unit Measure BN150 BN66.1
PR128 PR130
PR131 PR132
PR134 PR136
PR137 PR140
PR189 PR195
PR197 PR29.1
PR32.1 PR32.2
PR33.1 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR36.1 PR37.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
PR85.1 PR89.1
TA147 UK102
UK120 UK330
UK560
TPB-RATE Signed 13.4 AC541 AC542
Element: Rate Contains the percentage rate. BN150 BN66.1
PR128 PR130
PR131 PR132
PR134 PR136
PR137 PR140
PR189 PR195
PR197 PR29.1
PR32.1 PR32.2
PR33.1 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR36.1 PR37.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
PR85.1 PR89.1
TA147 UK102
UK120 UK330
UK560
TPB-GROSS-CALC-AMT Signed 15.2
Element: Gross Calc Amt
TPB-CURRENCY-CODE Alpha 5
Element: Currency Code This field contains the company base
currency code established in Company
(GL10.1 ).
TPB-CURR-ND Numeric 1
Account Currency
Code
TPB-CHECK-TYPE Alpha 1
Element: Payment Type Contains the payment type.
PBTIMEREC FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TPBSET1 COMPANY AC541 AC542
EMPLOYEE BN150 BN66.1
TIME-SEQ PR128 PR130
PR131 PR132
PR134 PR136
PR137 PR140
PR189 PR195
PR197 PR29.1
PR32.1 PR32.2
PR33.1 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR36.1 PR37.1
...
TPBSET2 COMPANY
EMPLOYEE
CHECK-ID
PAY-SUM-GRP
TIME-SEQ
PBTIMEREC FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Timerecord TIMERECORD Required
TPB-COMPANY -> TRD-COMPANY (TRDSET1)
TPB-EMPLOYEE -> TRD-EMPLOYEE
TPB-TIME-SEQ -> TRD-TIME-SEQ
|
