|
|
TMTIME FILE
UPDATED BY
UK330
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TMT-COMPANY Numeric 4 UK330
Element: Company Hr
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: Time Seq
TMT-TR-DATE Numeric 8 (yyyymmdd) UK330
Element: Tr Date
TMT-PCD-SEQ-NBR Numeric 4 UK330
Element: Pcd Seq Nbr
TMT-PAY-CODE Alpha 4 UK330
Element: Pay 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
Element: Pay Sum Grp
TMT-ATTEND-CODE Alpha 2 UK330
Element: Attend Code 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.
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 Diff
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 Hr
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 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-DST-ACCT-UNIT Alpha 15 UK330
Element: Acct Unit 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.
TMT-DST-ACCOUNT Numeric 6 UK330
Element: Account This field along with the accounting
unit and subaccount make up the location
(account) where amounts and other
account information is stored.
TMT-DST-SUB-ACCT Numeric 4 UK330
Element: Sub Acct This field contains the subaccount from
your general ledger chart of accounts
that was charged with the amount carried
on this record.
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: Acct Category 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
TMT-PER-END-DATE Numeric 8 (yyyymmdd) UK330
Element: Per End Date Identifies 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: Check Nbr
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.
E010 = U.S. Commission
E006 = U.S. 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
Element: Acct Nd 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 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
|
