PayrollItemWage Table

Back to list of tables.

Column Data type Data type name Length Can be queried? Can be updated? Can be inserted? Mandatory when inserting? Format Refers To Version introduced in Edition available in
ListID 12 VARCHAR 36 True False False False %s 3.0 US, CA, UK
TimeCreated 93 TIMESTAMP 23 True False False False CCCC-MM-DDThh:mm:ssZ 3.0 US, CA, UK
TimeModified 93 TIMESTAMP 23 True False False False CCCC-MM-DDThh:mm:ssZ 3.0 US, CA, UK
EditSequence 12 VARCHAR 16 True False False False %s 3.0 US, CA, UK
Name 12 VARCHAR 31 True False False False %s 3.0 US, CA, UK
IsActive -7 BIT 2 True False False False
1
0
true
false
 3.0 US, CA, UK
WageType 12 VARCHAR 14 True False False False
Addition
Deduction
CompanyContribution
Tax
DirectDeposit
 3.0 US, CA, UK
ExpenseAccountRef_ListID 12 VARCHAR 36 True False False False %s ListID 3.0 US, CA, UK
ExpenseAccountRef_FullName 12 VARCHAR 159 True False False False %s FullName 3.0 US, CA, UK