Account 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 1.0 US, CA, UK
TimeCreated 93 TIMESTAMP 23 True False False False CCCC-MM-DDThh:mm:ssZ 1.0 US, CA, UK
TimeModified 93 TIMESTAMP 23 True False False False CCCC-MM-DDThh:mm:ssZ 1.0 US, CA, UK
EditSequence 12 VARCHAR 16 True False False False %s 1.0 US, CA, UK
Name 12 VARCHAR 31 True True True True %s 1.0 US, CA, UK
12 VARCHAR 159 True False False False %s 1.0 US, CA, UK
IsActive -7 BIT 2 True True True False
1
0
true
false
 1.0 US, CA, UK
ParentRef_ListID 12 VARCHAR 159 True True True False %s 1.0 US, CA, UK
ParentRef_FullName 12 VARCHAR 159 True True True False %s 1.0 US, CA, UK
Sublevel 4 INTEGER 9 True False False False %11.0f 1.0 US, CA, UK
AccountType 12 VARCHAR 21 True True True True
AccountsPayable
AccountsReceivable
Bank
CostOfGoodsSold
CreditCard
Equity
Expense
FixedAsset
Income
LongTermLiability
Nonposting
OtherAsset
OtherCurrentAsset
OtherCurrentLiability
OtherExpense
OtherIncome
 1.0 US, CA, UK
SpecialAccountType 12 VARCHAR 30 True False False False
AccountsPayable
AccountsReceivable
CondenseItemAdjustmentExpenses
CostOfGoodsSold
DirectDepositLiabilities
Estimates
InventoryAssets
OpeningBalanceEquity
PayrollExpenses
PayrollLiabilities
PettyCash
PurchaseOrders
ReconciliationDifferences
RetainedEarnings
SalesOrders
SalesTaxPayable
UncategorizedExpenses
UncategorizedIncome
UndepositedFunds
 2.1 US, CA, UK
AccountNumber 12 VARCHAR 7 True True True False %s 1.0 US, CA, UK
BankNumber 12 VARCHAR 25 True True True False %s 2.0 US, CA, UK
Description 12 VARCHAR 200 True True True False %s 1.0 US, CA, UK
Balance 2 NUMERIC 15 True False False False %10.2f 1.0 US, CA, UK
TotalBalance 2 NUMERIC 15 True False False False %10.2f 1.0 US, CA, UK
OpenBalance 2 NUMERIC 15 True True True False %10.2f 1.0 US, CA, UK
OpenBalanceDate 91 DATE 91 True True True False CCCC-MM-DD 1.0 US, CA, UK
TaxLineInfoRet_TaxLineID 12 VARCHAR 36 True False False False %11.0f TaxLineID 2.1 US, CA
TaxLineInfoRet_TaxLineName 12 VARCHAR 256 True False False False %s TaxLineName 2.1 US, CA
CashFlowClassification 12 VARCHAR 13 True False False False
None
Operating
Investing
Financing
NotApplicable
 2.1 US, CA, UK
CurrencyRef_ListID 12 VARCHAR 36 True True True False %s ListID 8.0 US, CA, UK
CurrencyRef_FullName 12 VARCHAR 64 True True True False %s Name 1.0 US, CA, UK

Back to list of tables.