TABLE DETAIL REFERENCE: Account
(Online VERSION)
| FIELD NAME | TYPE | TYPENAME | LENGTH | QUERYABLE | UPDATEABLE | INSERTABLE | REQUIRED ON INSERT |
VALIDATE | RELATES TO |
|---|---|---|---|---|---|---|---|---|---|
| ListID | 12 | VARCHAR | 36 | True | False | False | False | %s | |
| TimeCreated | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
| TimeModified | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
| EditSequence | 12 | VARCHAR | 10 | True | False | False | False | %s | |
| Name | 12 | VARCHAR | 100 | True | True | True | True | %s | |
| FullName | 12 | VARCHAR | 1000 | True | True | True | False | %s | |
| IsActive | -7 | BIT | 1 | True | True | False | False | 1 0 true false | |
| ParentRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | |
| ParentRefFullName | 12 | VARCHAR | 1000 | True | True | True | False | %s | |
| Sublevel | 4 | INTEGER | 4 | True | False | False | False | %11.0f | |
| AccountType | 12 | VARCHAR | 21 | True | True | True | True | AccountsPayable AccountsReceivable Bank CostOfGoodsSold CreditCard Equity Expense FixedAsset Income LongTermLiability Nonposting OtherAsset OtherCurrentAsset OtherCurrentLiability OtherExpense OtherIncome | |
| DetailAccountType | 12 | VARCHAR | 255 | True | True | True | False | 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 | |
| AccountNumber | 12 | VARCHAR | 64 | True | True | True | False | %s | |
| LastCheckNumber | 12 | VARCHAR | 21 | True | True | True | False | %s | |
| Desc | 12 | VARCHAR | 100 | True | True | True | False | %s | |
| Description | 12 | VARCHAR | 4095 | True | True | True | False | %s | |
| Balance | 3 | DECIMAL | 15 | True | False | True | False | %11.2f | |
| TotalBalance | 3 | DECIMAL | 15 | True | True | True | False | %11.2f | |
| OpenBalance | 3 | DECIMAL | 13 | True | False | True | False | %11.2f | |
| OpenBalanceDate | 9 | DATE | 6 | True | True | True | False | CCCC-MM-DD | |
| CurrencyRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
| CurrencyRefFullName | 12 | VARCHAR | 64 | True | True | True | False | %s | Yes |
| TaxCodeRefListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
| TaxCodeRefFullName | 12 | VARCHAR | 64 | True | True | True | False | %s | Yes |
| AccountAlias | 12 | VARCHAR | 1000 | True | True | True | True | %s | |
| TxnLocationType | 12 | VARCHAR | 255 | True | True | True | False | WithinFrance FranceOverseas OutsideFranceWithEU OutsideEU |