Overview
When Pay Conditions is selected in Requested Data, the report will return the following details in the TSPayCondition sheet:
|
Field Name |
Data Type |
Information |
|
TSPayCondition_TSPCID |
Integer (Unsigned) |
The primary key for a Pay Condition |
|
IsManuallyEntered |
Boolean (Yes/No) |
Whether or not this Pay Condition was manually created or generated by the system |
|
Timesheet_TSID |
Integer (Unsigned) |
The Tiesheet ID linked to the Pay Condition, if any |
|
FixedOrVariableTimesheet |
String |
If the Pay Condition belongs to a timesheet, denotes whether it is Fixed or Variable |
|
Date |
Date |
The starting date of the week this Pay Condition applies to when calculating payroll or invoicing |
|
Job_UID |
Date |
The Job ID linked to the Pay Condition |
|
PayCat_PCID |
Integer (Unsigned) |
The ID of the pay category the Pay Condition belongs to 0 = base unit |
|
ChargeItem_CCID |
Integer (Unsigned) |
The ID of the Charge Item linked to the Pay Condition 0 = base unit |
|
UnitsMonday |
Decimal |
The number of units applied on Monday |
|
UnitsTuesday |
Decimal |
The number of units applied on Tuesday |
|
UnitsWednesday |
Decimal |
The number of units applied on Wednesday |
|
UnitsThursday |
Decimal |
The number of units applied on Thursday |
|
UnitsFriday |
Decimal |
The number of units applied on Friday |
|
UnitsSaturday |
Decimal |
The number of units applied on Saturday |
|
UnitsSunday |
Decimal |
The number of units applied on Sunday |
|
UnitsExtra |
Decimal |
The number of extra units applied to this Pay Condition (any units) |
|
TotalUnits |
Decimal |
The total number of units applied to this Pay Condition |
|
Status |
String |
The status of this Pay Condition |
|
PM_PID |
Integer (Unsigned) |
The foreign key of the project to which this Pay Condition belongs |
|
PM_PCID |
Integer (Unsigned) |
The foreign key of activity to which this Pay Condition belongs |
Comments
0 comments
Please sign in to leave a comment.