TABLE DETAIL REFERENCE: Account
(Online 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 10TrueFalseFalseFalse%s
Name12 VARCHAR 100TrueTrueTrueTrue%s
FullName12 VARCHAR 1000TrueTrueTrueFalse%s
IsActive-7 BIT 1TrueTrueFalseFalse
1
0
true
false
ParentRefListID12 VARCHAR 36TrueTrueTrueFalse%s
ParentRefFullName12 VARCHAR 1000TrueTrueTrueFalse%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
DetailAccountType12 VARCHAR 255TrueTrueTrueFalse
AP
AR
AccumulatedAdjustment
AccumulatedAmortization
AccumulatedAmortizationOfOtherAssets
AccumulatedDepletion
AccumulatedDepreciation
AdvertisingOrPromotional
AllowanceForBadDebts
Amortization
Auto
BadDebts
BankCharges
Buildings
CashOnHand
CharitableContributions
Checking
CommonStock
CostOfLabor
CostOfLaborCOS
CreditCard
DepletableAssets
Depreciation
DevelopmentCosts
DiscountsOrRefundsGiven
DividendIncome
DuesAndSubscriptions
EmployeeCashAdvances
Entertainment
EntertainmentMeals
EquipmentRental
EquipmentRentalCOS
FederalIncomeTaxPayable
FurnitureAndFixtures
Goodwill
Insurance
InsurancePayable
IntangibleAssets
InterestEarned
InterestPaid
Inventory
InvestmentMortgageOrRealEstateLoans
InvestmentOther
InvestmentTaxExemptSecurities
InvestmentUSGovObligations
Land
LeaseBuyout
LeaseholdImprovements
LegalAndProfessionalFees
Licenses
LineOfCredit
LoanPayable
LoansToOfficers
LoansToOthers
LoansToStockholders
MachineryAndEquipment
MoneyMarket
NonProfitIncome
NotesPayable
OfficeOrGeneralAdministrativeExpenses
OpeningBalanceEquity
OrganizationalCosts
OtherCostsOfServiceCOS
OtherCurrentAssets
OtherCurrentLiab
OtherFixedAssets
OtherInvestmentIncome
OtherLongTermAssets
OtherLongTermLiab
OtherMiscExpense
OtherMiscIncome
OtherMiscServiceCost
OtherPrimaryIncome
OwnersEquity
PaidInCapitalOrSurplus
PartnerContributions
PartnerDistributions
PartnersEquity
PayrollClearing
PayrollExpenses
PayrollTaxPayable
PenaltiesAndSettlements
PreferredStock
PrepaidExpenses
PrepaidExpensesPayable
PromotionalMeals
RentOrLeaseOfBuildings
RentsHeldInTrust
RentsInTrustLiab
RepairAndMaintenance
Retainage
RetainedEarnings
SalesOfProductIncome
SalesTaxPayable
Savings
SecurityDeposits
ServiceOrFeeIncome
ShareholderNotesPayable
ShippingFreightAndDelivery
ShippingFreightAndDeliveryCOS
StateOrLocalIncomeTaxPayable
SuppliesAndMaterials
SuppliesAndMaterialsCOGS
TaxExemptInterest
TaxesPaid
Travel
TravelMeals
TreasuryStock
TrustAccounts
TrustAccountsLiab
UndepositedFunds
Utilities
Vehicles
AccountNumber12 VARCHAR 7TrueTrueTrueFalse%s
LastCheckNumber12 VARCHAR 21TrueTrueTrueFalse%s
Desc12 VARCHAR 100TrueTrueTrueFalse%s
Balance3 DECIMAL 15TrueFalseTrueFalse%11.2f
TotalBalance3 DECIMAL 15TrueTrueTrueFalse%11.2f
OpenBalance3 DECIMAL 13TrueFalseTrueFalse%11.2f
OpenBalanceDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
CurrencyRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
CurrencyRefFullName12 VARCHAR 64TrueTrueTrueFalse%s Yes
TaxCodeRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
TaxCodeRefFullName12 VARCHAR 64TrueTrueTrueFalse%s Yes
AccountAlias12 VARCHAR 1000TrueTrueTrueTrue%s
TxnLocationType12 VARCHAR 255TrueTrueTrueFalse
WithinFrance
FranceOverseas
OutsideFranceWithEU
OutsideEU