TABLE DETAIL REFERENCE: PayrollItemWage
(Canada VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
ListID12 VARCHAR 36TrueFalseFalseFalse%s
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
EditSequence12 VARCHAR 16TrueFalseFalseFalse%s
Name12 VARCHAR 31TrueFalseTrueTrue%s
IsActive-7 BIT 1TrueFalseTrueFalse
1
0
true
false
WageType12 VARCHAR 14TrueFalseTrueFalse
Bonus
Commission
HourlyOvertime
HourlyRegular
HourlySick
HourlyVacation
SalaryRegular
SalarySick
SalaryVacation
ExpenseAccountRefListID12 VARCHAR 36TrueFalseTrueFalse%s Yes
ExpenseAccountRefFullName12 VARCHAR 159TrueFalseTrueFalse%s Yes