UK330 |
FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||
---|---|---|---|---|
TMT-COMPANY Element: Company Hr | Numeric 4 |
|
||
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. |
|
||
TMT-TIME-SEQ Element: Time Seq | Numeric 12 |
|
||
TMT-TR-DATE Element: Tr Date | Numeric 8 (yyyymmdd) |
|
||
TMT-PCD-SEQ-NBR Element: Pcd Seq Nbr | Numeric 4 |
|
||
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. |
|
||
TMT-PAY-SUM-GRP Element: Pay Sum Grp | Alpha 3 |
|
||
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. |
|
||
TMT-HOURS Element: Hours | Signed 7.2 Contains the hours. |
|
||
TMT-RATE Element: Rate | Signed 13.4 Contains the percentage rate. |
|
||
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. |
|
||
TMT-OT-RATE Element: Ot Rate | Signed 13.4 |
|
||
TMT-OT-PREM-AMT Element: Ot Prem Amt | Signed 13.2 |
|
||
TMT-SHFT-DIFF-RATE Element: Shft Diff Rate | Signed 13.4 |
|
||
TMT-SHIFT-DIFF Element: Shift Diff | Signed 13.2 |
|
||
TMT-JOB-CODE Element: Job Code | Alpha 9 Contains a user-defined code that represents a type of job. |
|
||
TMT-PROCESS-LEVEL Element: Process Lev Hr | Alpha 5 |
|
||
TMT-DEPARTMENT Element: Department | Alpha 5 Contains the department. |
|
||
TMT-UNION-CODE Element: Union Code | Alpha 10 |
|
||
TMT-POSITION Element: Position | Alpha 12 Contains the user-defined code that represents a position in the company. |
|
||
TMT-SHIFT Element: Shift | Numeric 1 Contains the shift number associated with the pay. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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 |
|
||
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). |
|
||
TMT-CHECK-NBR Element: Check Nbr | Numeric 8 |
|
||
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. |
|
||
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. |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
TMTSET1 |
COMPANY EMPLOYEE TIME-SEQ |
|
| ||||||||
TMTSET2 |
COMPANY EMPLOYEE TR-DATE* TIME-SEQ |
|
|||||||||
TMTSET3 |
COMPANY EMPLOYEE PAY-CODE TIME-SEQ |
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
Attend Code | ATTENDCODE |
Required
| |||||||||
Company | PRSYSTEM |
Required
| |||||||||
Department | DEPTCODE |
Required
| |||||||||
Employee | EMPLOYEE |
Required
| |||||||||
Process Level | PRSYSTEM |
Required
| |||||||||
Prqcentgrp | PRQCENTGRP |
Not Required
| |||||||||
Timerecord | TIMERECORD |
Not Required
|
All trademarks and registered trademarks are the property of their
respective owners.