PBTIME FILE
REFERENCED BY
PBWC.1
UPDATED BY
BN66.1 PR140 PR189 PR195 PR197 PR80.1
PR85.1 PR89.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RTB-COMPANY Numeric 4 BN66.1 PR140
Element: Company The company number represents an PR189 PR195
established company and is entered on PR197 PR80.1
all function codes. PR85.1 PR89.1
RTB-EMPLOYEE Numeric 9 BN66.1 PR140
Element: Employee Contains the employee number. Each PR189 PR195
person employed by the company is PR197 PR80.1
assigned a unique number. The system PR85.1 PR89.1
uses the employee number to correlate
all of the information related to that
person.
RTB-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
RTB-PAY-SUM-GRP Alpha 3 BN66.1 PR140
Payment Summary PR189 PR195
Group PR197 PR80.1
PR85.1 PR89.1
RTB-TIME-SEQ Numeric 12 BN66.1 PR140
Element: Sequence Number PR189 PR195
PR197 PR80.1
PR85.1 PR89.1
RTB-DED-GRP-AMT Signed 15.2 PR197 PR80.1
Element: Ded Grp Amt PR85.1
RTB-DED-GRP-AMT-WC Signed 15.2 PR197 PR80.1
Element: Ded Grp Amt Wc PR85.1
RTB-DED-GRP-AMT-SU Signed 15.2 PR197 PR85.1
Element: Ded Grp Amt Su
RTB-PCT-RATE-1 Signed 8.5 PR197 PR85.1
Element: Pct Rate 1
RTB-PCT-RATE-2 Signed 8.5 PR197 PR85.1
Element: Pct Rate 2
RTB-AMT-RATE-1 Signed 6.2 PR197 PR85.1
Element: Amt Rate 1
RTB-AMT-RATE-2 Signed 6.2 PR197 PR85.1
Element: Amt Rate 2
RTB-GROSS-AMT-1 Signed 15.2 PR197 PR85.1
Element: Gross Amt 1
RTB-GROSS-AMT-2 Signed 15.2 PR197 PR85.1
Element: Gross Amt 2
RTB-CLIENT-JOBID Alpha 20 PR197
Element: Client Jobid
RTB-TIME-USER-FLD Alpha 20 PR197
Element: Time User Fld
RTB-UNITS-AMOUNT Signed 15.2 PR197 PR85.1
Element: Adj Amt This is the units amount included in
the file.
RTB-UNIT-MEASURE Alpha 12 PR197
Element: Unit Measure
RTB-RATE Signed 13.4 PR197 PR85.1
Element: Rate Contains the percentage rate.
RTB-GROSS-CALC-AMT Signed 15.2 PR197 PR85.1
Element: Gross Calc Amt
RTB-CURRENCY-CODE Alpha 5
Element: Currency Code This field contains the company base
currency code established in Company
(GL10.1 ).
RTB-CURR-ND Numeric 1
Account Currency
Code
RTB-CHECK-TYPE Alpha 1 PR197 PR85.1
Element: Payment Type Contains the payment type.
PBTIME FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RTBSET1 COMPANY BN66.1 PBWC.1
EMPLOYEE PR140 PR189
CHECK-ID PR195 PR197
PAY-SUM-GRP PR80.1 PR85.1
TIME-SEQ PR89.1
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
|
