|
|
TMTIME FILE
REFERENCED BY
UK120 UK270
UPDATED BY
UK330 UK300 UK60.1 UK70.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TMT-COMPANY Numeric 4 UK330 UK60.1
Element: Company The company number represents an UK70.1
established company and is entered on
all function codes.
TMT-EMPLOYEE Numeric 9 UK330 UK60.1
Element: Employee Contains the employee number. Each UK70.1
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.
TMT-TIME-SEQ Numeric 12 UK330 UK60.1
Element: Sequence Number UK70.1
TMT-TR-DATE Numeric 8 (yyyymmdd) UK330 UK60.1
Element: Time Record Date UK70.1
TMT-PCD-SEQ-NBR Numeric 4 UK330 UK60.1
Element: Pcd Seq Nbr UK70.1
TMT-PAY-CODE Alpha 4 UK330 UK60.1
Element: Payment Code Contains the pay code. A pay code is a UK70.1
user-defined code that identifies a kind
of pay.
TMT-PAY-SUM-GRP Alpha 3 UK330 UK60.1
Payment Summary UK70.1
Group
TMT-ATTEND-CODE Alpha 2 UK330 UK60.1
Element: Attendance CodA user-defined alphanumeric code that UK70.1
represents a reason for an employee's
absence or hours worked. Examples of
attendance codes are, sick, vacation,
overtime, on the job injury, snow day,
tardy, left early, and so on. Validated
in the Attendance Code file.
TMT-HOURS Signed 7.2 UK330 UK60.1
Element: Hours Contains the hours. UK70.1
TMT-RATE Signed 13.4 UK330 UK60.1
Element: Rate Contains the percentage rate. UK70.1
TMT-WAGE-AMOUNT Signed 13.2 UK330 UK60.1
Element: Wage Amount Contains the sum of all wage amounts UK70.1
from the time records for pay codes tied
to this pay summary group.
TMT-OT-RATE Signed 13.4 UK330
Element: Ot Rate
TMT-OT-PREM-AMT Signed 13.2 UK330
Element: Ot Prem Amt
TMT-SHFT-DIFF-RATE Signed 13.4 UK330
Element: Shft Diff Rate
TMT-SHIFT-DIFF Signed 13.2 UK330
Element: Shift Differential
TMT-JOB-CODE Alpha 9 UK330 UK60.1
Element: Job Code Contains a user-defined code that UK70.1
represents a type of job.
TMT-PROCESS-LEVEL Alpha 5 UK330 UK60.1
Element: Process Level This field contains the process level, UK70.1
which is the reporting hierarchy below
company.
TMT-DEPARTMENT Alpha 5 UK330 UK60.1
Element: Department Contains the department. UK70.1
TMT-UNION-CODE Alpha 10 UK330 UK60.1
Element: Union Code UK70.1
TMT-POSITION Alpha 12 UK330 UK60.1
Element: Position Contains the user-defined code that UK70.1
represents a position in the company.
TMT-SHIFT Numeric 1 UK330 UK60.1
Element: Shift Contains the shift number associated UK70.1
with the pay.
TMT-DIST-COMPANY Numeric 4 UK330 UK60.1
Element: Company UK70.1
TMT-DST-ACCT-UNIT Alpha 15 UK330 UK60.1
Element: Accounting Unit UK70.1
TMT-DST-ACCOUNT Numeric 6 UK330 UK60.1
Element: Account UK70.1
TMT-DST-SUB-ACCT Numeric 4 UK330 UK60.1
Element: Subaccount UK70.1
TMT-ACTIVITY Alpha 15 UK330 UK60.1
Element: Activity Activities are the processes or UK70.1
procedures that produce work. Cost
objects (products, services, customers,
and so on) are the reasons for
performing the activity.
TMT-ACCT-CATEGORY Alpha 5 UK330 UK60.1
Element: Account CategoAccount categories are groupings of UK70.1
costs, revenues, or a combination of
both used for reporting and inquiries
for activities in the Activity
Management system. All transactions are
posted to an account category within an
activity. You can assign a specific
General Ledger account or range of
accounts (company, accounting unit,
account, and subaccount) that make up
the transactions posted to an account
category using AC07.1 (Account
Assignment).
Period-to-date, year-to-date, and
life-to-date balances are maintained by
account category for activities. Account
categories must be assigned to
activities before you do any budgeting
or transaction processing.
TMT-PER-END-DATE Numeric 8 (yyyymmdd) UK330
Element: Date
TMT-CHECK-NBR Numeric 8 UK330
Element: Payment Number
TMT-TYPE Alpha 2 UK330
Element: Type This identifies whether this record is
created because of a picking
transaction, or because of a return.
Valid values are:
"IS" = Picking transaction.
"RR" = Return.
~$1 VENDOR
The vendor's identification code.
TMT-REMUN-CODE Alpha 4
Element: Remun Code Contains the remuneration code. Valid
value is C001 = Bonus.
TMT-BUS-NBR-GRP Alpha 4
Element: Bus Nbr Grp Contains the business number group.
TMT-REPORT-ENTITY Alpha 5
Element: Process Level Contains the report entity.
Report Entity is the Process Level or
Company that this Process Level reports
to for tax reporting. If the Process
Level itself is independent then the
independent Process Level is the Report
Entity. If the Process Level is non
independent and is associated to a
independent head Process Level then the
independent head Process Level is the
Report Entity. If the Process Level is
non independent and is not associated to
a independent head Process Level then
the Company is the Report Entity.
TMT-QC-ENT-NBR-GRP Alpha 4
Element: Qc Ent Nbr GrpContains the Quebec enterprise number
group.
TMT-CURRENCY-CODE Alpha 5
Element: Currency Code This field contains the company base
currency code established in Company
(GL10.1 ).
TMT-CURR-ND Numeric 1
Account Currency
Code
TMTIME FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TMTSET1 COMPANY UK330 UK120
EMPLOYEE UK300 UK60.1
TIME-SEQ UK70.1
TMTSET2 COMPANY UK120 UK70.1
EMPLOYEE
TR-DATE*
TIME-SEQ
TMTSET3 COMPANY UK270
EMPLOYEE
PAY-CODE
TIME-SEQ
TMTIME FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Attend Code ATTENDCODE Required
TMT-COMPANY -> ATC-COMPANY
TMT-ATTEND-CODE -> ATC-ATTEND-CODE
Company PRSYSTEM Required
TMT-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Department DEPTCODE Required
TMT-COMPANY -> DPT-COMPANY
TMT-PROCESS-LEVEL -> DPT-PROCESS-LEVEL
TMT-DEPARTMENT -> DPT-DEPARTMENT
Employee EMPLOYEE Required
TMT-COMPANY -> EMP-COMPANY
TMT-EMPLOYEE -> EMP-EMPLOYEE
Process Level PRSYSTEM Required
TMT-COMPANY -> PRS-COMPANY
TMT-PROCESS-LEVEL -> PRS-PROCESS-LEVEL
Prqcentgrp PRQCENTGRP Not Required
TMT-COMPANY -> PQC-COMPANY
TMT-PROCESS-LEVEL -> PQC-PROCESS-LEVEL
TMT-QC-ENT-NBR-GRP -> PQC-QC-ENT-NBR-GRP
Timerecord TIMERECORD Not Required
TMT-COMPANY -> TRD-COMPANY
TMT-EMPLOYEE -> TRD-EMPLOYEE
TMT-TIME-SEQ -> TRD-TIME-SEQ
|
