TABLE DETAIL REFERENCE: Account
(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 31TrueTrueTrueTrue%s
FullName12 VARCHAR 159TrueFalseFalseFalse%s
IsActive-7 BIT 1TrueTrueTrueFalse
1
0
true
false
ParentRefListID12 VARCHAR 36TrueTrueTrueFalse%s
ParentRefFullName12 VARCHAR 159TrueTrueTrueFalse%s
Sublevel4 INTEGER 4TrueFalseFalseFalse%11.0f
AccountType12 VARCHAR 21TrueTrueTrueTrue
AccountsPayable
AccountsReceivable
Bank
CostOfGoodsSold
CreditCard
Equity
Expense
FixedAsset
Income
LongTermLiability
Nonposting
OtherAsset
OtherCurrentAsset
OtherCurrentLiability
OtherExpense
OtherIncome
SpecialAccountType12 VARCHAR 30TrueFalseFalseFalse
AccountsPayable
AccountsReceivable
CondenseItemAdjustmentExpenses
CostOfGoodsSold
DirectDepositLiabilities
Estimates
InventoryAssets
OpeningBalanceEquity
PayrollExpenses
PayrollLiabilities
PettyCash
PurchaseOrders
ReconciliationDifferences
RetainedEarnings
SalesOrders
SalesTaxPayable
UncategorizedExpenses
UncategorizedIncome
UndepositedFunds
IsTaxAccount-7 BIT 1TrueTrueTrueFalse
1
0
true
false
AccountNumber12 VARCHAR 7TrueTrueTrueFalse%s
BankNumber12 VARCHAR 25TrueTrueTrueFalse%s
Desc12 VARCHAR 200TrueTrueTrueFalse%s
Description12 VARCHAR 4095TrueTrueTrueFalse%s
Balance3 DECIMAL 18TrueFalseFalseFalse%10.2f
TotalBalance3 DECIMAL 18TrueFalseFalseFalse%10.2f
OpenBalance3 DECIMAL 18TrueTrueTrueFalse%10.2f
OpenBalanceDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
SalesTaxCodeRefListID12 VARCHAR 36TrueFalseTrueFalse%s Yes
SalesTaxCodeRefFullName12 VARCHAR 3TrueFalseTrueFalse%s Yes
TaxCodeRefListID12 VARCHAR 36TrueFalseTrueFalse%s Yes
TaxCodeRefFullName12 VARCHAR 3TrueFalseTrueFalse%s Yes
TaxLineInfoRetTaxLineID4 INTEGER 4TrueFalseFalseFalse%11.0f Yes
TaxLineInfoRetTaxLineName12 VARCHAR 256TrueFalseFalseFalse%s Yes
CashFlowClassification12 VARCHAR 13TrueFalseFalseFalse
None
Operating
Investing
Financing
NotApplicable
CurrencyRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
CurrencyRefFullName12 VARCHAR 64TrueTrueTrueFalse%s Yes