PayrollItemNonWage Table

Back to list of tables.

ColumnData typeData type nameLengthCan be queried?Can be updated?Can be inserted?Mandatory when inserting?FormatRefers ToVersion introduced inEdition available in
ListID12VARCHAR36TrueFalseFalseFalse%s3.0US, CA, UK
TimeCreated93TIMESTAMP23TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ3.0US, CA, UK
TimeModified93TIMESTAMP23TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ3.0US, CA, UK
EditSequence12VARCHAR16TrueFalseFalseFalse%s3.0US, CA, UK
Name12VARCHAR31TrueFalseFalseFalse%s3.0US, CA, UK
IsActive-7BIT2TrueFalseFalseFalse
1
0
true
false
3.0US, CA, UK
NonWageType12VARCHAR19TrueFalseFalseFalse
Addition
Deduction
CompanyContribution
Tax
DirectDeposit
3.0US, CA, UK
ExpenseAccountRef_ListID12VARCHAR36TrueFalseFalseFalse%sListID3.0US, CA, UK
ExpenseAccountRef_FullName12VARCHAR159TrueFalseFalseFalse%sFullName3.0US, CA, UK
LiabilityAccount_RefListID12VARCHAR36TrueFalseFalseFalse%sListID3.0US, CA, UK
LiabilityAccountRef_FullName12VARCHAR159TrueFalseFalseFalse%sFullName3.0US, CA, UK