Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

TMTIME


                              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