TMTIME

UPDATED BY
UK330

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TMT-COMPANY
Element: Company Hr
Numeric 4
UK330
TMT-EMPLOYEE
Element: Employee
Numeric 9
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.
UK330
TMT-TIME-SEQ
Element: Time Seq
Numeric 12
UK330
TMT-TR-DATE
Element: Tr Date
Numeric 8 (yyyymmdd)
UK330
TMT-PCD-SEQ-NBR
Element: Pcd Seq Nbr
Numeric 4
UK330
TMT-PAY-CODE
Element: Pay Code
Alpha 4
Contains the pay code. A pay code is a user-defined code that identifies a kind of pay.
UK330
TMT-PAY-SUM-GRP
Element: Pay Sum Grp
Alpha 3
UK330
TMT-ATTEND-CODE
Element: Attend Code
Alpha 2
A user-defined alphanumeric code that 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.
UK330
TMT-HOURS
Element: Hours
Signed 7.2
Contains the hours.
UK330
TMT-RATE
Element: Rate
Signed 13.4
Contains the percentage rate.
UK330
TMT-WAGE-AMOUNT
Element: Wage Amount
Signed 13.2
Contains the sum of all wage amounts from the time records for pay codes tied to this pay summary group.
UK330
TMT-OT-RATE
Element: Ot Rate
Signed 13.4
UK330
TMT-OT-PREM-AMT
Element: Ot Prem Amt
Signed 13.2
UK330
TMT-SHFT-DIFF-RATE
Element: Shft Diff Rate
Signed 13.4
UK330
TMT-SHIFT-DIFF
Element: Shift Diff
Signed 13.2
UK330
TMT-JOB-CODE
Element: Job Code
Alpha 9
Contains a user-defined code that represents a type of job.
UK330
TMT-PROCESS-LEVEL
Element: Process Lev Hr
Alpha 5
UK330
TMT-DEPARTMENT
Element: Department
Alpha 5
Contains the department.
UK330
TMT-UNION-CODE
Element: Union Code
Alpha 10
UK330
TMT-POSITION
Element: Position
Alpha 12
Contains the user-defined code that represents a position in the company.
UK330
TMT-SHIFT
Element: Shift
Numeric 1
Contains the shift number associated with the pay.
UK330
TMT-DIST-COMPANY
Element: Company
Numeric 4
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.
UK330
TMT-DST-ACCT-UNIT
Element: Acct Unit
Alpha 15
The accounting unit is a shorthand notation representing the variable level number. When used in the General Ledger Account Master file, the accounting unit must be defined in the General Ledger Names file as a posting accounting unit.
UK330
TMT-DST-ACCOUNT
Element: Account
Numeric 6
This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.
UK330
TMT-DST-SUB-ACCT
Element: Sub Acct
Numeric 4
This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.
UK330
TMT-ACTIVITY
Element: Activity
Alpha 15
Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity.
UK330
TMT-ACCT-CATEGORY
Element: Acct Category
Alpha 5
Account categories are groupings of 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. Valid account category types are: cost revenue accrual pass thru
UK330
TMT-PER-END-DATE
Element: Per End Date
Numeric 8 (yyyymmdd)
Identifies period end date in distribution record; used during PR198 to relieve salary encumbrance commitments for pay period (updated from TIMERECORD.PER-END-DATE).
UK330
TMT-CHECK-NBR
Element: Check Nbr
Numeric 8
UK330
TMT-TYPE
Element: Type
Alpha 2
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.
UK330
TMT-REMUN-CODE
Element: Remun Code
Alpha 4
Contains the remuneration code. Valid value is C001 = Bonus.
E010 = U.S. Commission
E006 = U.S. Bonus
TMT-BUS-NBR-GRP
Element: Bus Nbr Grp
Alpha 4
Contains the business number group.
TMT-REPORT-ENTITY
Element: Report Entity
Alpha 5
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
Element: Qc Ent Nbr Grp
Alpha 4
Contains the Quebec enterprise number group.
TMT-CURRENCY-CODE
Element: Currency Code
Alpha 5
This field contains the company base currency code established in Company (GL10.1 ).
TMT-CURR-ND
Element: Acct Nd
Numeric 1
The number of decimals assigned to a particular account as determined by the account currency.


TMTIME FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TMTSET1 COMPANY
EMPLOYEE
TIME-SEQ
UK330
TMTSET2 COMPANY
EMPLOYEE
TR-DATE*
TIME-SEQ
TMTSET3 COMPANY
EMPLOYEE
PAY-CODE
TIME-SEQ


TMTIME FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Attend Code ATTENDCODE Required
TMT-COMPANY->ATC-COMPANY (ATCSET1)
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


File created: Wed Jun 08 20:51:44 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.