|
|
TMTIME FILE
UPDATED BY
UK330
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TMT-COMPANY Numeric 4 UK330
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.
TMT-EMPLOYEE Numeric 9 UK330
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.
TMT-TIME-SEQ Numeric 12 UK330
Element: Sequence Number
TMT-TR-DATE Numeric 8 (yyyymmdd) UK330
Element: Time Record Date
TMT-PCD-SEQ-NBR Numeric 4 UK330
Element: Pcd Seq Nbr
TMT-PAY-CODE Alpha 4 UK330
Element: Payment Code Contains the pay code. A pay code is a
user-defined code that identifies a kind
of pay.
TMT-PAY-SUM-GRP Alpha 3 UK330
Payment Summary
Group
TMT-ATTEND-CODE Alpha 2 UK330
Element: Attendance CodA 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.
TMT-HOURS Signed 7.2 UK330
Element: Hours Contains the hours.
TMT-RATE Signed 13.4 UK330
Element: Rate Contains the percentage rate.
TMT-WAGE-AMOUNT Signed 13.2 UK330
Element: Wage Amount Contains the sum of all wage amounts
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
Element: Job Code Contains a user-defined code that
represents a type of job.
TMT-PROCESS-LEVEL Alpha 5 UK330
Element: Process Lev HrThis field contains the process level,
which is the reporting hierarchy below
company.
TMT-DEPARTMENT Alpha 5 UK330
Element: Department Contains the department.
TMT-UNION-CODE Alpha 10 UK330
Element: Union Code
TMT-POSITION Alpha 12 UK330
Element: Position Contains the user-defined code that
represents a position in the company.
TMT-SHIFT Numeric 1 UK330
Element: Shift Contains the shift number associated
with the pay.
TMT-DIST-COMPANY Numeric 4 UK330
Element: Company The company number used for posting the
transaction. A valid intercompany
relationship must be defined in the
Lawson General Ledger system.
TMT-DST-ACCT-UNIT Alpha 15 UK330
Element: Accounting UniContains the General Ledger accounting
unit to which the amount is posted.
TMT-DST-ACCOUNT Numeric 6 UK330
Element: Account Contains the General Ledger account to
which the amount is posted.
TMT-DST-SUB-ACCT Numeric 4 UK330
Element: Subaccount Contains the General Ledger subaccount
to which the amount is posted.
TMT-ACTIVITY Alpha 15 UK330
Element: Activity Activities are the processes or
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
Element: Account CategoAccount 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
TMT-PER-END-DATE Numeric 8 (yyyymmdd) UK330
Element: Period End DatIdentifies period end date in
distribution record; used during PR198
to relieve salary encumbrance
commitments for pay period (updated from
TIMERECORD.PER-END-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: Report Entity 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 Represents the number of decimals
Code defined for the currency of the object.
TMTIME FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TMTSET1 COMPANY UK330
EMPLOYEE
TIME-SEQ
TMTSET2 COMPANY
EMPLOYEE
TR-DATE*
TIME-SEQ
TMTSET3 COMPANY
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 (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
|
