Lawson Insight Technical Documentation |
|
PBTIMEREC
PBTIMEREC FILE
UPDATED BY
BN150 PR128 PR130 PR131 PR132 PR134
PR136 PR137 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 PR35.9 PR36.1
PR37.1 PR45.1 PR529 PR530 PR560 PR82.1
PR85.1 UK102 UK330 TA147 TP135
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TPB-COMPANY Numeric 4 BN150 PR128
Element: Company Hr Identifies the AP company if the PR130 PR131
resource type = V. Identifies the HR PR132 PR134
company if the resource type = E. It is PR136 PR137
blank for type A, P or Q resources. 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
PR35.9 PR36.1
PR37.1 PR45.1
PR529 PR530
PR560 PR82.1
PR85.1 TA147
TP135 UK102
UK330
TPB-EMPLOYEE Numeric 9 BN150 PR128
Element: Employee Contains the employee number. Each PR130 PR131
person employed by the company is PR132 PR134
assigned a unique number. The system PR136 PR137
uses the employee number to correlate PR197 PR29.1
all of the information related to that PR32.1 PR32.2
person. PR33.1 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR37.1 PR45.1
PR529 PR530
PR560 PR82.1
PR85.1 TA147
TP135 UK102
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 BN150 PR128
Element: Sequence Number PR130 PR131
PR132 PR134
PR136 PR137
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
PR35.9 PR36.1
PR37.1 PR45.1
PR529 PR530
PR560 PR82.1
PR85.1 TA147
TP135 UK102
UK330
TPB-DED-GRP-AMT Signed 15.2 PR85.1
Element: Ded Grp Amt
TPB-DED-GRP-AMT-WC Signed 15.2 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 BN150 PR128
Element: Pct Rate 1 PR130 PR131
PR132 PR134
PR136 PR137
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
PR35.9 PR36.1
PR37.1 PR45.1
PR529 PR530
PR560 PR82.1
PR85.1 TA147
TP135 UK102
UK330
TPB-PCT-RATE-2 Signed 8.5 BN150 PR128
Element: Pct Rate 2 PR130 PR131
PR132 PR134
PR136 PR137
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
PR35.9 PR36.1
PR37.1 PR45.1
PR529 PR530
PR560 PR82.1
PR85.1 TA147
TP135 UK102
UK330
TPB-AMT-RATE-1 Signed 6.2 BN150 PR128
Element: Amt Rate 1 PR130 PR131
PR132 PR134
PR136 PR137
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
PR35.9 PR36.1
PR37.1 PR45.1
PR529 PR530
PR560 PR82.1
PR85.1 TA147
TP135 UK102
UK330
TPB-AMT-RATE-2 Signed 6.2 BN150 PR128
Element: Amt Rate 2 PR130 PR131
PR132 PR134
PR136 PR137
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
PR35.9 PR36.1
PR37.1 PR45.1
PR529 PR530
PR560 PR82.1
PR85.1 TA147
TP135 UK102
UK330
TPB-GROSS-AMT-1 Signed 15.2 BN150 PR128
Element: Gross Amt 1 PR130 PR131
PR132 PR134
PR136 PR137
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
PR35.9 PR36.1
PR37.1 PR45.1
PR529 PR530
PR560 PR82.1
PR85.1 TA147
TP135 UK102
UK330
TPB-GROSS-AMT-2 Signed 15.2 BN150 PR128
Element: Gross Amt 2 PR130 PR131
PR132 PR134
PR136 PR137
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
PR35.9 PR36.1
PR37.1 PR45.1
PR529 PR530
PR560 PR82.1
PR85.1 TA147
TP135 UK102
UK330
TPB-CLIENT-JOBID Alpha 20 BN150 PR128
Element: Client Jobid PR130 PR131
PR132 PR134
PR136 PR137
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
PR35.9 PR36.1
PR37.1 PR45.1
PR529 PR530
PR560 PR82.1
PR85.1 TA147
TP135 UK102
UK330
TPB-TIME-USER-FLD Alpha 20 BN150 PR128
Element: Time User Fld PR130 PR131
PR132 PR134
PR136 PR137
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
PR35.9 PR36.1
PR37.1 PR45.1
PR529 PR530
PR560 PR82.1
PR85.1 TA147
TP135 UK102
UK330
TPB-UNITS-AMOUNT Signed 15.2 BN150 PR128
Element: Units Amount This is the units amount included in PR130 PR131
the file. PR132 PR134
PR136 PR137
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
PR35.9 PR36.1
PR37.1 PR45.1
PR529 PR530
PR560 PR82.1
PR85.1 TA147
TP135 UK102
UK330
TPB-UNIT-MEASURE Alpha 12 BN150 PR128
Element: Unit Measure PR130 PR131
PR132 PR134
PR136 PR137
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
PR35.9 PR36.1
PR37.1 PR45.1
PR529 PR530
PR560 PR82.1
PR85.1 TA147
TP135 UK102
UK330
TPB-RATE Signed 13.4 BN150 PR128
Element: Rate Contains the percentage rate. PR130 PR131
PR132 PR134
PR136 PR137
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
PR35.9 PR36.1
PR37.1 PR45.1
PR529 PR530
PR560 PR82.1
PR85.1 TA147
TP135 UK102
UK330
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 Represents the number of decimals
Code defined for the currency of the object.
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 BN150 PR128
EMPLOYEE PR130 PR131
TIME-SEQ PR132 PR134
PR136 PR137
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
PR35.9 PR36.1
PR37.1 PR45.1
PR529 PR530
PR560 PR82.1
...
PBTIMEREC FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Employee EMPLOYEE Required
TPB-COMPANY -> EMP-COMPANY
TPB-EMPLOYEE -> EMP-EMPLOYEE
Timerecord TIMERECORD Required
TPB-COMPANY -> TRD-COMPANY
TPB-EMPLOYEE -> TRD-EMPLOYEE
TPB-TIME-SEQ -> TRD-TIME-SEQ
|