PBTIME FILE
REFERENCED BY
PBWC.1
UPDATED BY
PR197 PR85.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RTB-COMPANY Numeric 4 PR197 PR85.1
Company The company number represents an
established company and is entered on
all function codes.
RTB-EMPLOYEE Numeric 9 PR197 PR85.1
Employee Contains the employee number. Each
person employed by the company is
assigned a unique number. The system
uses the employee number to correlate
all of the information related to that
person.
RTB-CHECK-ID Numeric 12 PR197 PR85.1
Internal Check ID Contains the payment identification
Number number (unique payment identifier used
in tracking payment information).
RTB-PAY-SUM-GRP Alpha 3 PR197 PR85.1
Payment Summary
Group
RTB-TIME-SEQ Numeric 12 PR197 PR85.1
Sequence Number
RTB-DED-GRP-AMT Signed 15.2 PR197 PR85.1
Ded Grp Amt
RTB-DED-GRP-AMT-WC Signed 15.2 PR197 PR85.1
Ded Grp Amt Wc
RTB-DED-GRP-AMT-SU Signed 15.2 PR197 PR85.1
Ded Grp Amt Su
RTB-PCT-RATE-1 Signed 8.5 PR197 PR85.1
Pct Rate 1
RTB-PCT-RATE-2 Signed 8.5 PR197 PR85.1
Pct Rate 2
RTB-AMT-RATE-1 Signed 6.2 PR197 PR85.1
Amt Rate 1
RTB-AMT-RATE-2 Signed 6.2 PR197 PR85.1
Amt Rate 2
RTB-GROSS-AMT-1 Signed 15.2 PR197 PR85.1
Gross Amt 1
RTB-GROSS-AMT-2 Signed 15.2 PR197 PR85.1
Gross Amt 2
RTB-CLIENT-JOBID Alpha 20 PR197
Client Jobid
RTB-TIME-USER-FLD Alpha 20 PR197
Time User Fld
RTB-UNITS-AMOUNT Signed 15.2 PR197 PR85.1
Units Amount This is the units amount included in
the file.
RTB-UNIT-MEASURE Alpha 12 PR197
Unit Measure
RTB-RATE Signed 13.4 PR197 PR85.1
Rate Contains the percentage rate.
RTB-GROSS-CALC-AMT Signed 15.2 PR197 PR85.1
Gross Calc Amt
RTB-CURRENCY-CODE Alpha 5
Currency Code This field contains the company base
currency code established in Company
(GL10.1 ).
RTB-CURR-ND Numeric 1
Currency Number of Represents the number of decimals
Decimals defined for the currency of the object.
RTB-CHECK-TYPE Alpha 1 PR197 PR85.1
Payment Type Contains the payment type.
PBTIME FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RTBSET1 COMPANY PBWC.1 PR197
EMPLOYEE PR85.1
CHECK-ID
PAY-SUM-GRP
TIME-SEQ
PBTIME FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Prtime PRTIME Required
RTB-COMPANY -> PRT-COMPANY
RTB-EMPLOYEE -> PRT-EMPLOYEE
RTB-CHECK-ID -> PRT-CHECK-ID
RTB-PAY-SUM-GRP -> PRT-PAY-SUM-GRP
RTB-TIME-SEQ -> PRT-TIME-SEQ
|
