InfiniSuite SDK
  • Introduction
  • SDK & Scripting
    • Building Applications
    • Widgets
    • Classes
      • BaseApp
      • DashboardApp
      • EntityApp
      • FormApp
      • ListApp
      • Menu
      • Report
      • ReportQueryApp
      • Toolbar
      • TransactionApp
    • Libraries
      • ApiLib
      • AppLib
      • CacheLib
      • ChartLib
      • ExportLib
      • ImportLib
      • InfobarLib
      • LogLib
      • MainLib
      • MessageLib
      • RqlLib
      • ScriptLib
      • SpreadsheetLib
      • SystemLib
      • TabLib
      • TransactionGridLib
    • Sample Code
      • Entity App
      • Using Radiobuttons
  • REST API
    • Using the REST API
      • Entity Endpoint Summary
      • Authentication
      • Filters
      • Using RQL to Query Data
    • REST Endpoints
      • Account
      • Address
      • Application
      • Box1099
      • Class
      • CompanySetup
      • Contact
      • Favorite
      • Form1099
      • Item
      • Job
      • List
      • ListItem
      • Log
      • Note
      • Relationship
      • SalesTax
      • SalesTaxGroup
      • SalesTaxGroupItem
      • Task
      • Term
      • Transaction
      • TransactionDetail
      • Unit
  • Data Model & Schema
    • Data Model
    • Business Object Schemas
    • Tables
      • account
      • address
      • class
      • companysetup
      • contact
      • item
      • job
      • lead
      • list
      • listitem
      • relationship
      • task
      • term
      • transaction
      • unit
    • Views
      • accountbalanceview
      • accountbalanceyearmonthview
      • accountviewcompact
      • addressview
      • billview
      • classview
      • contactview
      • customerbalance
      • customerinvoicebodetail
      • customerinvoiceboheader
      • customerinvoicetotal
      • customeropeninvoices
      • customeropeninvoicetotal
      • customerpaymenttotal
      • itemview
      • listitemview
      • modelrelationview
      • openbillview
      • salestaxgroupitemview
      • scriptview
      • taskview
      • transaction_balance_view
      • transactiondetailview
      • transactiondetailviewcompact
      • transactiondetailviewnooffset
      • transactiondetailviewoffset
      • transactionview
      • transactionviewcompact
      • trialbalanceview
      • vendorbalance
  • Reference
    • Account Types
    • Field Types
    • Script Types
    • Tab Types
    • Transaction Types
    • Grid Filters
  • Setup & Configuration
    • Application Manager
    • Schema Manager
    • Script Manager
    • Bundle Manager
    • Text Localization
  • License
    • Open Source Licenses
Powered by GitBook
On this page
  • Type: table
  • Columns

Was this helpful?

  1. Data Model & Schema
  2. Tables

account

Type: table

Columns

Column

Type

Attributes

Description

abanbr

varchar

accountcategoryrowid

int

accountid

varchar

accountname

varchar

accounttyperowid

int

balance

decimal

bankaccountnbr

varchar

box1099rowid

int

cashflowsection

varchar

checkscriptrowid

int

companyrowid

int

consolidateinsummary

smallint

consolidationaccountid

varchar

consolidationclassid

varchar

currencyratetyperowid

int

currencyrowid

int

description

varchar

fstcurrencyratetyperowid

int

haschildren

smallint

isactive

tinyint

lastdocnbr

int

namerequired

smallint

nestlevel

smallint

noncashaccount

smallint

onus

varchar

parentrowid

int

relationshiprowid

int

routingnbr

varchar

rowid

int

auto_increment

sortorder

varchar

specaccount

varchar

taxformlinelistitemrowid

int

transitnbr

varchar

unitrequired

smallint

updatetimestamp

timestamp

on update CURRENT_TIMESTAMP

v.ismain -- Wed, Feb 28, 2018 2:58 PM

PreviousTablesNextaddress

Last updated 5 years ago

Was this helpful?