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: view
  • Columns

Was this helpful?

  1. Data Model & Schema
  2. Views

addressview

Type: view

Columns

Column

Type

Attributes

Description

accountrowid

int

addressid

varchar

addresstypeaccountrowid

int

addresstypeclassrowid

int

addresstypedescription

varchar

addresstypeid

varchar

addresstypeisactive

tinyint

addresstypelistitemrowid

int

addresstyperowid

int

addresstypeuid

varchar

addresstypexref

varchar

attention

varchar

city

varchar

companyrowid

int

contactrowid

int

countrylistitemrowid

int

description

varchar

isactive

tinyint

isdefault

smallint

jobrowid

int

noterowid

int

phonenbr

varchar

relationshiprowid

int

rowid

int

state

varchar

streetaddress

varchar

taskrowid

int

transactionrowid

int

updatetimestamp

timestamp

zipcode

varchar

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

PreviousaccountviewcompactNextbillview

Last updated 5 years ago

Was this helpful?