|
|
TMTIME FILE
UK Pay/Hours History
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
Company The company number represents an UK70.1
established company and is entered on
all function codes.
TMT-EMPLOYEE Numeric 9 UK330 UK60.1
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
Sequence Number UK70.1
TMT-TR-DATE Numeric 8 (yyyymmdd) UK330 UK60.1
Time Record Date Contains the time record date. UK70.1
TMT-PCD-SEQ-NBR Numeric 4 UK330 UK60.1
Pcd Seq Nbr UK70.1
TMT-PAY-CODE Alpha 4 UK330 UK60.1
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 This field is used for PSGRELATE (Pay UK70.1
Group Class Relationship).
TMT-ATTEND-CODE Alpha 2 UK330 UK60.1
Attendance Code Contains the code that represents UK70.1
absence or hours worked.
TMT-HOURS Signed 7.2 UK330 UK60.1
Hours Contains the hours. UK70.1
TMT-RATE Signed 13.4 UK330 UK60.1
Rate Contains the percentage rate. UK70.1
TMT-WAGE-AMOUNT Signed 11.2 UK330 UK60.1
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
Ot Rate Contains the overtime rate.
TMT-OT-PREM-AMT Signed 11.2 UK330
Ot Prem Amt Contains the overtime premium amount.
TMT-SHFT-DIFF-RATE Signed 13.4 UK330
Shft Diff Rate
TMT-SHIFT-DIFF Signed 11.2 UK330
Shift Differential
TMT-JOB-CODE Alpha 9 UK330 UK60.1
Job Code Contains a user-defined code that UK70.1
represents a type of job.
TMT-PROCESS-LEVEL Alpha 5 UK330 UK60.1
Process Level This field contains the process level, UK70.1
which is the reporting hierarchy below
company.
TMT-DEPARTMENT Alpha 5 UK330 UK60.1
Department Contains the department. UK70.1
TMT-UNION-CODE Alpha 10 UK330 UK60.1
Union Code UK70.1
TMT-POSITION Alpha 12 UK330 UK60.1
Position Contains the user-defined code that UK70.1
represents a position in the company.
TMT-SHIFT Numeric 1 UK330 UK60.1
Shift Contains the shift number associated UK70.1
with the pay.
TMT-DIST-COMPANY Numeric 4 UK330 UK60.1
Distribution Company The company number used for posting the UK70.1
transaction. A valid intercompany
relationship must be defined in the
Lawson General Ledger system.
TMT-DST-ACCT-UNIT Alpha 15 UK330 UK60.1
Distribution Contains the General Ledger accounting UK70.1
Accounting Unit unit to which the amount is posted.
TMT-DST-ACCOUNT Numeric 6 UK330 UK60.1
Distribution Contains the General Ledger account to UK70.1
Account Number which the amount is posted.
TMT-DST-SUB-ACCT Numeric 4 UK330 UK60.1
Distribution Contains the General Ledger subaccount UK70.1
Subaccount Number to which the amount is posted.
TMT-ACTIVITY Alpha 15 UK330 UK60.1
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. Activities and
cost object activities are used
synonymously in the Activity Management
system. Direct costs are posted to
activities, and indirect costs are
allocated to activities based on
activity drivers.
Activities are grouped or organized by
activity levels. There are two kinds of
activities: "posting allowed" and
"summary only." Use posting level
activities to budget and maintain all
posted transactions. Summary activities
or macro activities combine information
and balances from lower level activities
for reporting and inquiries.
TMT-ACCT-CATEGORY Alpha 5 UK330 UK60.1
Account Category Account 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
Period End Date
TMT-CHECK-NBR Numeric 8 UK330
Payment Number
TMT-TYPE Alpha 2 UK330
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.
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
Timerecord TIMERECORD Not Required
TMT-COMPANY -> TRD-COMPANY
TMT-EMPLOYEE -> TRD-EMPLOYEE
TMT-TIME-SEQ -> TRD-TIME-SEQ
|