 |
Lawson Insight Technical Documentation |
|
PBTIMEREC FILE
UPDATED BY
AC541 AC542 BN150 PR128 PR131 PR132
PR134 PR136 PR137 PR195 PR197 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 PR530 PR82.1 PR85.1 UK102
UK330 UK120
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TPB-COMPANY Numeric 4 AC541 AC542
Company The company number represents an BN150 PR128
established company and is entered on PR131 PR132
all function codes. PR134 PR136
PR137 PR195
PR197 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
PR530 PR82.1
PR85.1 UK102
UK120 UK330
TPB-EMPLOYEE Numeric 9 AC541 AC542
Employee Contains the employee number. Each BN150 PR128
person employed by the company is PR131 PR132
assigned a unique number. The system PR134 PR136
uses the employee number to correlate PR137 PR195
all of the information related to that PR197 PR32.1
person. 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
PR530 PR82.1
PR85.1 UK102
UK120 UK330
TPB-CHECK-ID Numeric 12 PR197 PR85.1
Internal Check ID Contains the payment identification
Number number (unique payment identifier used
in tracking payment information).
TPB-PAY-SUM-GRP Alpha 3 PR197 PR85.1
Payment Summary
Group
TPB-TIME-SEQ Numeric 12 AC541 AC542
Sequence Number BN150 PR128
PR131 PR132
PR134 PR136
PR137 PR195
PR197 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
PR530 PR82.1
PR85.1 UK102
UK120 UK330
TPB-DED-GRP-AMT Signed 15.2 PR85.1
Ded Grp Amt
TPB-DED-GRP-AMT-WC Signed 15.2 PR85.1
Ded Grp Amt Wc
TPB-DED-GRP-AMT-SU Signed 15.2 PR85.1
Ded Grp Amt Su
TPB-PCT-RATE-1 Signed 8.5 AC541 AC542
Pct Rate 1 BN150 PR128
PR131 PR132
PR134 PR136
PR137 PR195
PR197 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
PR530 PR82.1
PR85.1 UK102
UK120 UK330
TPB-PCT-RATE-2 Signed 8.5 AC541 AC542
Pct Rate 2 BN150 PR128
PR131 PR132
PR134 PR136
PR137 PR195
PR197 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
PR530 PR82.1
PR85.1 UK102
UK120 UK330
TPB-AMT-RATE-1 Signed 6.2 AC541 AC542
Amt Rate 1 BN150 PR128
PR131 PR132
PR134 PR136
PR137 PR195
PR197 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
PR530 PR82.1
PR85.1 UK102
UK120 UK330
TPB-AMT-RATE-2 Signed 6.2 AC541 AC542
Amt Rate 2 BN150 PR128
PR131 PR132
PR134 PR136
PR137 PR195
PR197 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
PR530 PR82.1
PR85.1 UK102
UK120 UK330
TPB-GROSS-AMT-1 Signed 15.2 AC541 AC542
Gross Amt 1 BN150 PR128
PR131 PR132
PR134 PR136
PR137 PR195
PR197 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
PR530 PR82.1
PR85.1 UK102
UK120 UK330
TPB-GROSS-AMT-2 Signed 15.2 AC541 AC542
Gross Amt 2 BN150 PR128
PR131 PR132
PR134 PR136
PR137 PR195
PR197 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
PR530 PR82.1
PR85.1 UK102
UK120 UK330
TPB-CLIENT-JOBID Alpha 20 AC541 AC542
Client Jobid BN150 PR128
PR131 PR132
PR134 PR136
PR137 PR195
PR197 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
PR530 PR82.1
PR85.1 UK102
UK120 UK330
TPB-TIME-USER-FLD Alpha 20 AC541 AC542
Time User Fld BN150 PR128
PR131 PR132
PR134 PR136
PR137 PR195
PR197 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
PR530 PR82.1
PR85.1 UK102
UK120 UK330
TPB-UNITS-AMOUNT Signed 15.2 AC541 AC542
Units Amount This is the units amount included in BN150 PR128
the file. PR131 PR132
PR134 PR136
PR137 PR195
PR197 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
PR530 PR82.1
PR85.1 UK102
UK120 UK330
TPB-UNIT-MEASURE Alpha 12 AC541 AC542
Unit Measure BN150 PR128
PR131 PR132
PR134 PR136
PR137 PR195
PR197 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
PR530 PR82.1
PR85.1 UK102
UK120 UK330
TPB-RATE Signed 13.4 AC541 AC542
Rate Contains the percentage rate. BN150 PR128
PR131 PR132
PR134 PR136
PR137 PR195
PR197 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
PR530 PR82.1
PR85.1 UK102
UK120 UK330
TPB-GROSS-CALC-AMT Signed 15.2
Gross Calc Amt
TPB-CURRENCY-CODE Alpha 5
Currency Code This field contains the company base
currency code established in Company
(GL10.1 ).
TPB-CURR-ND Numeric 1
Currency Number of Represents the number of decimals
Decimals defined for the currency of the object.
TPB-CHECK-TYPE Alpha 1
Payment Type Contains the payment type.
PBTIMEREC FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TPBSET1 COMPANY AC541 AC542
EMPLOYEE BN150 PR128
TIME-SEQ PR131 PR132
PR134 PR136
PR137 PR195
PR197 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
PR530 PR82.1
PR85.1 UK102
...
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
|