|
|
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
Element: Company Hr Identifies the AP company if the
resource type = V. Identifies the HR
company if the resource type = E. It is
blank for type A, P or Q resources.
RTB-EMPLOYEE Numeric 9 PR197 PR85.1
Element: 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
Element: Sequence Number
RTB-DED-GRP-AMT Signed 15.2 PR197 PR85.1
Element: Ded Grp Amt
RTB-DED-GRP-AMT-WC Signed 15.2 PR197 PR85.1
Element: Ded Grp Amt Wc
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: Units Amount 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 Represents the number of decimals
Code defined for the currency of the object.
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 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
Employee EMPLOYEE Required
RTB-COMPANY -> EMP-COMPANY
RTB-EMPLOYEE -> EMP-EMPLOYEE
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
|
