Introduction

Enzo Server
  Installation
  Quick Start
  Core Features
    Async Calls
    ConnectionStrings
    Edge Cache
    HTTP Access
    Scheduling
    Views
  Advanced Capabilities
    Change Data Capture
  Administration
    Configuration Settings
    Logins & ACL
    Auditing
    Current Executions
    Linked Server
    SSL

  User Guides
     Sharding
     Sharding Overview

     SharePoint

   Adapters
    All Adapters


  SDK
    Overview
    Installation
    DevHost
    Create A Simple Adapter
    Handler Columns

    Advanced SDK Concepts
      Handler Decorators
      Dynamic Columns
      Table & Table Enumerators
      Virtual Tables



Intacct Adapter








Access Intacct Cloud Accounting from SQL Server and REST commands


This adapter requires a subscription to Intacct services



Configuration Settings



Name Description Default
Boolean _isDefault Make this the default configuration. Defaults to true if configName is already the default.
String senderId senderId for control element
String senderPassword senderPassword for control element
String userId userId for authorization element
String companyId companyId for authorization element
String password password for authorization element
String url URL to access Intacct web services
String readQueryPageSize Default number of items in a batch to return in readQuery requests 1000
String httpRequestTimeout The time-out value in milliseconds for the HTTP request 600000

Handlers



GetACCOUNTGROUP
ACCOUNTGROUP
Select ACCOUNTGROUP details. details 

Arguments


SQL Call

exec bsc.Intacct.GetACCOUNTGROUP
select * from bsc.Intacct.ACCOUNTGROUP


Http Call

/bsc/intacct/getaccountgroup

Output Columns

String ACCOUNTGROUPNAME
String HEADINGTITLE
String TOTALTITLE
String NORMALBALANCE
String MEMBERSTYPE
Boolean ISKPI
String PROJECTID
String CUSTOMERID
String VENDORID
String EMPLOYEEID
String ITEMID
String CLASSID
GetARINVOICE
ARINVOICE
Select ARINVOICE items. details 

Arguments


SQL Call

exec Intacct.GetARINVOICE
select * from Intacct.ARINVOICE


Http Call

/bsc/intacct/getarinvoice

Output Columns

Int32 RECORDNO
Int32 PRBATCHKEY
String PRBATCH
String RECORDTYPE
String DESCRIPTION
Decimal TOTALENTERED
Decimal TOTALPAID
Decimal TOTALSELECTED
Decimal TOTALDUE
String RAWSTATE
DateTime WHENCREATED
DateTime WHENPAID
String TERMKEY
String TERMNAME
DateTime WHENDISCOUNT
String RECORDID
Int32 USERKEY
DateTime WHENDUE
String DOCNUMBER
String VENDENTITY
String CUSTENTITY
String CLEARED
DateTime CLRDATE
String MODULEKEY
String STATUS
String SYSTEMGENERATED
DateTime WHENPOSTED
String ONHOLD
String CURRENCY
Decimal TRX_TOTALENTERED
Decimal TRX_TOTALPAID
Decimal TRX_TOTALSELECTED
Decimal TRX_TOTALDUE
String PRXBATCHKEY
String DELIVERYMETHOD
String BANKACKNOWLEDGED
String ACKMESSAGEKEY
DateTime WHENBANKCONFIRMED
String CONFMESSAGEKEY
DateTime RECON_DATE
String BASECURR
String VENDORACCTNOKEY
String LOCATIONKEY
DateTime AUWHENCREATED
DateTime WHENMODIFIED
Int32 CREATEDBY
Int32 MODIFIEDBY
Int32 CUSTOMERID
String CUSTOMERNAME
String BILLTOCONTACTNAME
String BILLTOPAYTOKEY
String SHIPTOCONTACTNAME
String SHIPTORETURNTOKEY
String CUSTMESSAGEID
String DESCRIPTION2
String HASPOSTEDREVREC
String CONTACT_CONTACTNAME
String CONTACT_PREFIX
String CONTACT_FIRSTNAME
String CONTACT_INITIAL
String CONTACT_LASTNAME
String CONTACT_COMPANYNAME
String CONTACT_PRINTAS
String CONTACT_PHONE1
String CONTACT_PHONE2
String CONTACT_CELLPHONE
String CONTACT_PAGER
String CONTACT_FAX
String CONTACT_EMAIL1
String CONTACT_EMAIL2
String CONTACT_URL1
String CONTACT_URL2
String CONTACT_VISIBLE
String CONTACT_MAILADDRESS_ADDRESS1
String CONTACT_MAILADDRESS_ADDRESS2
String CONTACT_MAILADDRESS_CITY
String CONTACT_MAILADDRESS_STATE
String CONTACT_MAILADDRESS_ZIP
String CONTACT_MAILADDRESS_COUNTRY
String CONTACT_MAILADDRESS_COUNTRYCODE
String SHIPTO_CONTACTNAME
String SHIPTO_PREFIX
String SHIPTO_FIRSTNAME
String SHIPTO_INITIAL
String SHIPTO_LASTNAME
String SHIPTO_COMPANYNAME
String SHIPTO_PRINTAS
String SHIPTO_PHONE1
String SHIPTO_PHONE2
String SHIPTO_CELLPHONE
String SHIPTO_PAGER
String SHIPTO_FAX
String SHIPTO_EMAIL1
String SHIPTO_EMAIL2
String SHIPTO_URL1
String SHIPTO_URL2
String SHIPTO_VISIBLE
String SHIPTO_MAILADDRESS_ADDRESS1
String SHIPTO_MAILADDRESS_ADDRESS2
String SHIPTO_MAILADDRESS_CITY
String SHIPTO_MAILADDRESS_STATE
String SHIPTO_MAILADDRESS_ZIP
String SHIPTO_MAILADDRESS_COUNTRY
String SHIPTO_MAILADDRESS_COUNTRYCODE
String BILLTO_CONTACTNAME
String BILLTO_PREFIX
String BILLTO_FIRSTNAME
String BILLTO_INITIAL
String BILLTO_LASTNAME
String BILLTO_COMPANYNAME
String BILLTO_PRINTAS
String BILLTO_PHONE1
String BILLTO_PHONE2
String BILLTO_CELLPHONE
String BILLTO_PAGER
String BILLTO_FAX
String BILLTO_EMAIL1
String BILLTO_EMAIL2
String BILLTO_URL1
String BILLTO_URL2
String BILLTO_VISIBLE
String BILLTO_MAILADDRESS_ADDRESS1
String BILLTO_MAILADDRESS_ADDRESS2
String BILLTO_MAILADDRESS_CITY
String BILLTO_MAILADDRESS_STATE
String BILLTO_MAILADDRESS_ZIP
String BILLTO_MAILADDRESS_COUNTRY
String BILLTO_MAILADDRESS_COUNTRYCODE
String MEGAENTITYKEY
String MEGAENTITYID
String MEGAENTITYNAME
GetCLASS
CLASS
Select CLASS details. details 

Arguments


SQL Call

exec Intacct.GetCLASS
select * from Intacct.CLASS


Http Call

/bsc/intacct/getclass

Output Columns

Int32 RECORDNO
String CLASSID
String NAME
String DESCRIPTION
String STATUS
String PARENTKEY
String PARENTID
String PARENTNAME
DateTime WHENCREATED
DateTime WHENMODIFIED
Int32 CREATEDBY
Int32 MODIFIEDBY
String MEGAENTITYKEY
String MEGAENTITYID
String MEGAENTITYNAME
GetDEPARTMENT
DEPARTMENT
Select DEPARTMENT items. details 

Arguments


SQL Call

exec Intacct.GetDEPARTMENT
select * from Intacct.DEPARTMENT


Http Call

/bsc/intacct/getdepartment

Output Columns

Int32 DEPARTMENTID
Int32 RECORDNO
String TITLE
String PARENTKEY
String PARENTID
String SUPERVISORKEY
String SUPERVISORID
DateTime WHENCREATED
DateTime WHENMODIFIED
String SUPERVISORNAME
String STATUS
String CUSTTITLE
String CREATEDBY
String MODIFIEDBY
GetGLACCOUNT
GLACCOUNT
Select GLACCOUNT details. details 

Arguments


SQL Call

exec Intacct.GetGLACCOUNT
select * from Intacct.GLACCOUNT


Http Call

/bsc/intacct/getglaccount

Output Columns

Int32 RECORDNO
String ACCOUNTNO
String TITLE
String ACCOUNTTYPE
String NORMALBALANCE
String CLOSINGTYPE
String CLOSINGACCOUNTNO
String CLOSINGACCOUNTTITLE
String STATUS
Boolean REQUIREDEPT
Boolean REQUIRELOC
Boolean TAXABLE
Int32 CATEGORYKEY
String CATEGORY
String TAXCODE
String MRCCODE
Int32 CLOSETOACCTKEY
String ALTERNATIVEACCOUNT
DateTime WHENCREATED
DateTime WHENMODIFIED
Int32 CREATEDBY
Int32 MODIFIEDBY
String MEGAENTITYKEY
String MEGAENTITYID
String MEGAENTITYNAME
Boolean DOCUPEAK_RESTRICTED
Boolean REQUIREPROJECT
Boolean REQUIRECUSTOMER
Boolean REQUIREVENDOR
Boolean REQUIREEMPLOYEE
Boolean REQUIREITEM
Boolean REQUIRECLASS
GetGLACCTGRP
GLACCTGRP
Select GLACCTGRP items. details 

Arguments


SQL Call

exec Intacct.GetGLACCTGRP
select * from Intacct.GLACCTGRP


Http Call

/bsc/intacct/getglacctgrp

Output Columns

Int32 RECORDNO
String NAME
String NORMAL_BALANCE
Boolean ISLEAF
String ASOF
Boolean APPLYASOF
Boolean INCLUDECHILDAMT
String TITLE
String TOTALTITLE
String RANGEFROM
String RANGETO
String HOWCREATED
Int32 LOCATIONKEY
Int32 DEPTKEY
String DBCR
String FILTERDEPT
String FILTERLOC
String MEMBERTYPE
Int32 DEPTGRPKEY
Int32 LOCGRPKEY
String LOCNAME
String LOCGRPNAME
String DEPTNAME
String DEPTGRPNAME
String DEPTNO
String DEPTGRPID
String LOCNO
String LOCGRPID
Boolean ISKPI
String FILTERVENDOR
String FILTERCUSTOMER
String FILTERPROJECT
String FILTEREMPLOYEE
String FILTERITEM
String FILTERCLASS
String FILTERCONTRACT
String FILTERWAREHOUSE
DateTime WHENCREATED
DateTime WHENMODIFIED
Int32 CREATEDBY
Int32 MODIFIEDBY
String MEGAENTITYKEY
String MEGAENTITYID
String MEGAENTITYNAME
Int32 PROJECTDIMKEY
String PROJECTID
String PROJECTNAME
Int32 CUSTOMERDIMKEY
String CUSTOMERID
String CUSTOMERNAME
Int32 VENDORDIMKEY
String VENDORID
String VENDORNAME
Int32 EMPLOYEEDIMKEY
String EMPLOYEEID
String EMPLOYEENAME
Int32 ITEMDIMKEY
String ITEMID
String ITEMNAME
Int32 CLASSDIMKEY
String CLASSID
String CLASSNAME
GetGLACCTGRPHIERARCHY
GLACCTGRPHIERARCHY
Select GLACCTGRPHIERARCHY details. details 

Arguments


SQL Call

exec Intacct.GetGLACCTGRPHIERARCHY
select * from Intacct.GLACCTGRPHIERARCHY


Http Call

/bsc/intacct/getglacctgrphierarchy

Output Columns

Int32 RECORDNO
Int32 GLACCTGRPKEY
String GLACCTGRPNAME
String GLACCTGRPTITLE
String GLACCTGRPNORMALBALANCE
String GLACCTGRPMEMBERTYPE
String GLACCTGRPHOWCREATED
String GLACCTGRPLOCATIONKEY
Int32 ACCOUNTKEY
String ACCOUNTNO
String ACCOUNTTITLE
String ACCOUNTNORMALBALANCE
String ACCOUNTTYPE
String ACCOUNTLOCATIONKEY
GetGLACCTGRPMEMBER
GLACCTGRPMEMBER
Select GLACCTGRPMEMBER details. details 

Arguments


SQL Call

exec Intacct.GetGLACCTGRPMEMBER
select * from Intacct.GLACCTGRPMEMBER


Http Call

/bsc/intacct/getglacctgrpmember

Output Columns

Int32 RECORDNO
String PARENTKEY
String CHILDKEY
String CHILDNAME
Int32 SORTORD
DateTime WHENCREATED
DateTime WHENMODIFIED
String CREATEDBY
String MODIFIEDBY
GetGLBATCH
GLBATCH
Select GLBATCH items. details 

Arguments


SQL Call

exec Intacct.GetGLBATCH
select * from Intacct.GLBATCH


Http Call

/bsc/intacct/getglbatch

Output Columns

Int32 RECORDNO
Int32 BATCHNO
String BATCH_TITLE
Decimal BALANCE
String JOURNAL
Int32 JOURNALKEY
String ADJ
DateTime BATCH_DATE
String MODULE
String CHILDENTITY
Int32 USERKEY
String REFERENCENO
String REVERSED
String REVERSEDKEY
String REVERSEDFROM
String TEMPLATEKEY
String PRBATCHKEY
String PRBATCHRECTYPE
DateTime MODIFIED
String MODIFIEDBYID
String SCHOPKEY
String RRSENTRYKEY
String RRSKEY
String BASELOCATION
String BASELOCATION_NO
String BASELOCATION_NAME
String USERINFO_LOGINID
Int32 LOCATIONKEY
DateTime WHENCREATED
DateTime WHENMODIFIED
Int32 CREATEDBY
Int32 MODIFIEDBY
String STATE
Int32 MEGAENTITYKEY
String MEGAENTITYID
String MEGAENTITYNAME
GetGLBUDGET
GLBUDGET
Select GLBUDGET items. details 

Arguments


SQL Call

exec Intacct.GetGLBUDGET
select * from Intacct.GLBUDGET


Http Call

/bsc/intacct/getglbudget

Output Columns

Int32 RECORDNO
Int32 BUDGETKEY
String BUDGETID
Int32 PERIODKEY
Int32 ACCOUNTKEY
Int32 DEPTKEY
Int32 LOCATIONKEY
Decimal AMOUNT
String BASEDON
String GROWBY
String PERPERIOD
String GLACCOUNTNO
String ACCT_NO
String ACCOUNT_TYPE
String ACCTTITLE
String NORMALBALANCE
String STATISTICAL
String DEPARTMENTID
Int32 DEPT_NO
String DEPTITLE
String LOCATIONID
String LOCATION_NO
String LOCATIONTITLE
String PERIODNAME
String REPORTINGPERIODNAME
DateTime PSTARTDATE
DateTime PENDDATE
String PROJECTDIMKEY
String PROJECTID
String PROJECTNAME
String CUSTOMERDIMKEY
String CUSTOMERID
String CUSTOMERNAME
String VENDORDIMKEY
String VENDORID
String VENDORNAME
String EMPLOYEEDIMKEY
String EMPLOYEEID
String EMPLOYEENAME
String ITEMDIMKEY
String ITEMID
String ITEMNAME
String CLASSDIMKEY
String CLASSID
String CLASSNAME
String MEGAENTITYKEY
String MEGAENTITYID
String MEGAENTITYNAME
String CUSTOMDIMENSIONS
GetGLBUDGETITEM
GLBUDGETITEM
Select GLBUDGETITEM details. details 

Arguments


SQL Call

exec Intacct.GetGLBUDGETITEM
select * from Intacct.GLBUDGETITEM


Http Call

/bsc/intacct/getglbudgetitem

Output Columns

String BUDGETID
String BUDGETKEY
Int32 RECORDNO
String GLACCOUNTNO
String TITLE
String ACCOUNTKEY
String NORMALBALANCE
String DEPARTMENTID
String DEPTKEY
String LOCATIONID
String LOCATIONKEY
String BASEDON
String GROWBY
String REPORTINGPERIODNAME
String PERIODKEY
String PERPERIOD
DateTime STARTDATE
DateTime ENDDATE
Decimal AMOUNT
String PROJECTID
String CUSTOMERID
String VENDORID
String EMPLOYEEID
String ITEMID
String CLASSID
GetGLCOACATMEMBER
GLCOACATMEMBER
Select GLCOACATMEMBER items. details 

Arguments


SQL Call

exec Intacct.GetGLCOACATMEMBER
select * from Intacct.GLCOACATMEMBER


Http Call

/bsc/intacct/getglcoacatmember

Output Columns

Int32 RECORDNO
Int32 PARENTKEY
Int32 SORTORD
Int32 CATEGORYKEY
String CATEGORYNAME
DateTime WHENCREATED
DateTime WHENMODIFIED
Int32 CREATEDBY
Int32 MODIFIEDBY
GetGLENTRY
GLENTRY
Select GLENTRY details. details 

Arguments


SQL Call

exec Intacct.GetGLENTRY
select * from Intacct.GLENTRY


Http Call

/bsc/intacct/getglentry

Output Columns

Int32 RECORDNO
Int32 BATCHNO
Int32 USERNO
Int32 LINE_NO
Int32 TR_TYPE
DateTime ENTRY_DATE
Decimal AMOUNT
Decimal TRX_AMOUNT
Int32 BATCH_NUMBER
DateTime BATCH_DATE
String BATCHTITLE
Int32 ACCOUNTKEY
String ACCOUNTNO
String ACCOUNTTITLE
String STATISTICAL
String DEPARTMENTKEY
String DEPARTMENT
String DEPARTMENTTITLE
Int32 LOCATIONKEY
String LOCATION
String LOCATIONNAME
String DOCUMENT
String DESCRIPTION
String UNITS
String BASECURR
String CURRENCY
String CLEARED
DateTime CLRDATE
String TIMEPERIOD
String ADJ
DateTime EXCH_RATE_DATE
String EXCH_RATE_TYPE_ID
String EXCHANGE_RATE
DateTime RECON_DATE
String ALLOCATION
String ALLOCATIONKEY
String BASELOCATION
String BASELOCATION_NO
String BASELOCATION_NAME
String IETYPE
String PARENTGLENTRYKEY
String TMPLENTRYKEY
DateTime WHENCREATED
DateTime WHENMODIFIED
Int32 CREATEDBY
Int32 MODIFIEDBY
String STATE
String PROJECTDIMKEY
String PROJECTID
String PROJECTNAME
String CUSTOMERDIMKEY
String CUSTOMERID
String CUSTOMERNAME
String VENDORDIMKEY
String VENDORID
String VENDORNAME
String EMPLOYEEDIMKEY
String EMPLOYEEID
String EMPLOYEENAME
String ITEMDIMKEY
String ITEMID
String ITEMNAME
String CLASSDIMKEY
String CLASSID
String CLASSNAME
GetGLTRANSACTION
GLTRANSACTION
Select GLTRANSACTION details. details 

Arguments


SQL Call

exec Intacct.GetGLTRANSACTION
select * from Intacct.GLTRANSACTION


Http Call

/bsc/intacct/getgltransaction

Output Columns

String KEY
String JOURNALID
Int32 BATCHNO
DateTime DATECREATED
DateTime DATEMODIFIED
String DESCRIPTION
String SOURCEENTITY
String STATE
GetInvoices
INVOICE
Select INVOICE details. details 

Arguments


SQL Call

exec Intacct.GetINVOICE
select * from Intacct.INVOICE


Http Call

/bsc/intacct/getinvoices

Output Columns

String KEY
String CUSTOMERID
DateTime DATECREATED
DateTime DATEPOSTED
DateTime DATEDUE
DateTime DATEPAID
String TERMNAME
String BATCHKEY
String INVOICENO
String PONUMBER
Decimal TOTALAMOUNT
Decimal TOTALPAID
Decimal TOTALDUE
String DESCRIPTION
Decimal TRX_TOTALAMOUNT
Decimal TRX_TOTALPAID
Decimal TRX_TOTALDUE
String BASECURR
String CURRENCY
String BILLTO
String SHIPTO
DateTime WHENMODIFIED
String STATE
GetJOURNAL
JOURNAL
Select JOURNAL details. details 

Arguments


SQL Call

exec Intacct.GetJOURNAL
select * from Intacct.JOURNAL


Http Call

/bsc/intacct/getjournal

Output Columns

String SYMBOL
String TITLE
String STATUS
DateTime WHENCREATED
DateTime WHENMODIFIED
String CREATEDBY
String MODIFIEDBY
GetLOCATION
LOCATION
Select LOCATION details. details 

Arguments


SQL Call

exec Intacct.GetLOCATION
select * from Intacct.LOCATION


Http Call

/bsc/intacct/getlocation

Output Columns

String LOCATIONID
String RECORDNO
String NAME
String PARENTID
String SUPERVISORNAME
String SUPERVISORID
String CONTACTINFO_CONTACTNAME
String CONTACTINFO_PRINTAS
String CONTACTINFO_PHONE1
String CONTACTINFO_PHONE2
String CONTACTINFO_EMAIL1
String CONTACTINFO_EMAIL2
String CONTACTINFO_FAX
String CONTACTINFO_MAILADDRESS_ADDRESS1
String CONTACTINFO_MAILADDRESS_ADDRESS2
String CONTACTINFO_MAILADDRESS_CITY
String CONTACTINFO_MAILADDRESS_STATE
String CONTACTINFO_MAILADDRESS_ZIP
String CONTACTINFO_MAILADDRESS_COUNTRY
String CONTACTINFO_MAILADDRESS_COUNTRYCODE
DateTime STARTDATE
DateTime ENDDATE
String SHIPTO_CONTACTNAME
String SHIPTO_PHONE1
String SHIPTO_PHONE2
String SHIPTO_MAILADDRESS_ADDRESS1
String SHIPTO_MAILADDRESS_ADDRESS2
String SHIPTO_MAILADDRESS_CITY
String SHIPTO_MAILADDRESS_STATE
String SHIPTO_MAILADDRESS_ZIP
String SHIPTO_MAILADDRESS_COUNTRY
String SHIPTO_MAILADDRESS_COUNTRYCODE
String STATUS
DateTime WHENCREATED
DateTime WHENMODIFIED
String FEDERALID
String FIRSTMONTH
String WEEKSTART
String IEPAYABLE_ACCOUNT
String IEPAYABLE_NUMBER
String IERECEIVABLE_ACCOUNT
String IERECEIVABLE_NUMBER
String MESSAGE_TEXT
String MARKETING_TEXT
String FOOTNOTETEXT
String REPORTPRINTAS
String ISROOT
String RESERVEAMT
String VENDORNAME
String VENDORID
String CUSTOMERID
String CUSTOMERNAME
String CURRENCY
String ENTITY
String ENTITYRECORDNO
String HAS_IE_RELATION
String CUSTTITLE
String BUSINESSDAYS
String WEEKENDS
String FIRSTMONTHTAX
String CONTACTKEY
String SUPERVISORKEY
String PARENTKEY
String SHIPTOKEY
String IEPAYABLEACCTKEY
String IERECEIVABLEACCTKEY
String VENDENTITY
String CUSTENTITY
String TAXID
String CREATEDBY
String MODIFIEDBY
GetVENDOR
VENDOR
Select VENDOR details. details 

Arguments


SQL Call

exec Intacct.GetVENDOR
select * from Intacct.VENDOR


Http Call

/bsc/intacct/getvendor

Output Columns

String RECORDNO
String VENDORID
String NAME
String NAME1099
String PARENTKEY
String PARENTID
String PARENTNAME
String DISPLAYCONTACT_CONTACTNAME
String DISPLAYCONTACT_COMPANYNAME
String DISPLAYCONTACT_PREFIX
String DISPLAYCONTACT_FIRSTNAME
String DISPLAYCONTACT_LASTNAME
String DISPLAYCONTACT_INITIAL
String DISPLAYCONTACT_PRINTAS
String DISPLAYCONTACT_TAXABLE
String DISPLAYCONTACT_TAXGROUP
String DISPLAYCONTACT_PHONE1
String DISPLAYCONTACT_PHONE2
String DISPLAYCONTACT_CELLPHONE
String DISPLAYCONTACT_PAGER
String DISPLAYCONTACT_FAX
String DISPLAYCONTACT_EMAIL1
String DISPLAYCONTACT_EMAIL2
String DISPLAYCONTACT_URL1
String DISPLAYCONTACT_URL2
String DISPLAYCONTACT_VISIBLE
String DISPLAYCONTACT_MAILADDRESS_ADDRESS1
String DISPLAYCONTACT_MAILADDRESS_ADDRESS2
String DISPLAYCONTACT_MAILADDRESS_CITY
String DISPLAYCONTACT_MAILADDRESS_STATE
String DISPLAYCONTACT_MAILADDRESS_ZIP
String DISPLAYCONTACT_MAILADDRESS_COUNTRY
String DISPLAYCONTACT_MAILADDRESS_COUNTRYCODE
Decimal DISPLAYCONTACT_MAILADDRESS_LATITUDE
Decimal DISPLAYCONTACT_MAILADDRESS_LONGITUDE
String DISPLAYCONTACT_STATUS
String ENTITY
String TERMNAME
String TERMVALUE
String VENDORACCOUNTNO
String TAXID
String CREDITLIMIT
String TOTALDUE
String BILLINGTYPE
String VENDTYPE
String VENDTYPE1099TYPE
String GLGROUP
String PRICESCHEDULE
String DISCOUNT
String PRICELIST
String COMMENTS
String ACCOUNTLABEL
String APACCOUNT
String APACCOUNTTITLE
String FORM1099TYPE
String FORM1099BOX
String PAYMENTPRIORITY
String CONTACTINFO_CONTACTNAME
String CONTACTINFO_PREFIX
String CONTACTINFO_FIRSTNAME
String CONTACTINFO_INITIAL
String CONTACTINFO_LASTNAME
String CONTACTINFO_COMPANYNAME
String CONTACTINFO_PRINTAS
String CONTACTINFO_PHONE1
String CONTACTINFO_PHONE2
String CONTACTINFO_CELLPHONE
String CONTACTINFO_PAGER
String CONTACTINFO_FAX
String CONTACTINFO_EMAIL1
String CONTACTINFO_EMAIL2
String CONTACTINFO_URL1
String CONTACTINFO_URL2
String CONTACTINFO_VISIBLE
String CONTACTINFO_MAILADDRESS_ADDRESS1
String CONTACTINFO_MAILADDRESS_ADDRESS2
String CONTACTINFO_MAILADDRESS_CITY
String CONTACTINFO_MAILADDRESS_STATE
String CONTACTINFO_MAILADDRESS_ZIP
String CONTACTINFO_MAILADDRESS_COUNTRY
String CONTACTINFO_MAILADDRESS_COUNTRYCODE
String PAYTO_CONTACTNAME
String PAYTO_PREFIX
String PAYTO_FIRSTNAME
String PAYTO_INITIAL
String PAYTO_LASTNAME
String PAYTO_COMPANYNAME
String PAYTO_PRINTAS
String PAYTO_PHONE1
String PAYTO_PHONE2
String PAYTO_CELLPHONE
String PAYTO_PAGER
String PAYTO_FAX
String PAYTO_EMAIL1
String PAYTO_EMAIL2
String PAYTO_URL1
String PAYTO_URL2
String PAYTO_VISIBLE
String PAYTO_MAILADDRESS_ADDRESS1
String PAYTO_MAILADDRESS_ADDRESS2
String PAYTO_MAILADDRESS_CITY
String PAYTO_MAILADDRESS_STATE
String PAYTO_MAILADDRESS_ZIP
String PAYTO_MAILADDRESS_COUNTRY
String PAYTO_MAILADDRESS_COUNTRYCODE
String RETURNTO_CONTACTNAME
String RETURNTO_PREFIX
String RETURNTO_FIRSTNAME
String RETURNTO_INITIAL
String RETURNTO_LASTNAME
String RETURNTO_COMPANYNAME
String RETURNTO_PRINTAS
String RETURNTO_PHONE1
String RETURNTO_PHONE2
String RETURNTO_CELLPHONE
String RETURNTO_PAGER
String RETURNTO_FAX
String RETURNTO_EMAIL1
String RETURNTO_EMAIL2
String RETURNTO_URL1
String RETURNTO_URL2
String RETURNTO_VISIBLE
String RETURNTO_MAILADDRESS_ADDRESS1
String RETURNTO_MAILADDRESS_ADDRESS2
String RETURNTO_MAILADDRESS_CITY
String RETURNTO_MAILADDRESS_STATE
String RETURNTO_MAILADDRESS_ZIP
String RETURNTO_MAILADDRESS_COUNTRY
String RETURNTO_MAILADDRESS_COUNTRYCODE
String STATUS
String PAYDATEVALUE
String ONETIME
String ONHOLD
DateTime WHENMODIFIED
String ISOWNER
String DONOTCUTCHECK
String OWNER.EQGLACCOUNT
String OWNER.EQGLACCOUNTLABEL
String OWNER.HOLDDIST
String OWNER.ACCOUNTLABEL.LABEL
String CURRENCY
String ACHENABLED
String WIREENABLED
String CHECKENABLED
String ACHBANKROUTINGNUMBER
String ACHACCOUNTNUMBER
String ACHACCOUNTTYPE
String ACHREMITTANCETYPE
String WIREBANKNAME
String WIREBANKROUTINGNUMBER
String WIREACCOUNTNUMBER
String WIREACCOUNTTYPE
String PMPLUSREMITTANCETYPE
String PMPLUSEMAIL
String PMPLUSFAX
String DISPLAYTERMDISCOUNT
String OEPRCLSTKEY
String DISPLOCACCTNOCHECK
DateTime WHENCREATED
String CREATEDBY
String MODIFIEDBY
String PAYMENTNOTIFY
String PAYMETHODKEY
String MERGEPAYMENTREQ
String DISPLAYCONTACTKEY
String PRIMARYCONTACTKEY
String PAYTOKEY
String RETURNTOKEY
String ACCOUNTLABELKEY
String ACCOUNTKEY
String VENDTYPEKEY
String GLGRPKEY
String TERMSKEY
String VENDORACCTNOKEY
String PAYMETHODREC
String OUTSOURCECHECK
String OUTSOURCECHECKSTATE
String OUTSOURCEACH
String OUTSOURCEACHSTATE
String OUTSOURCECARD
String OUTSOURCECARDOVERRIDE
String CARDSTATE
String VENDORACHACCOUNTID
String VENDORACCOUNTOUTSOURCEACH
String OFFSETGLACCOUNTNO
String OFFSETGLACCOUNTNOTITLE
String CONTACTTO1099.CONTACTNAME
String CONTACTTO1099.PREFIX
String CONTACTTO1099.FIRSTNAME
String CONTACTTO1099.INITIAL
String CONTACTTO1099.LASTNAME
String CONTACTTO1099.COMPANYNAME
String CONTACTTO1099.PRINTAS
String CONTACTTO1099.PHONE1
String CONTACTTO1099.PHONE2
String CONTACTTO1099.CELLPHONE
String CONTACTTO1099.PAGER
String CONTACTTO1099.FAX
String CONTACTTO1099.EMAIL1
String CONTACTTO1099.EMAIL2
String CONTACTTO1099.URL1
String CONTACTTO1099.URL2
String CONTACTTO1099.VISIBLE
String CONTACTTO1099.MAILADDRESS.ADDRESS1
String CONTACTTO1099.MAILADDRESS.ADDRESS2
String CONTACTTO1099.MAILADDRESS.CITY
String CONTACTTO1099.MAILADDRESS.STATE
String CONTACTTO1099.MAILADDRESS.ZIP
String CONTACTTO1099.MAILADDRESS.COUNTRY
String CONTACTTO1099.MAILADDRESS.COUNTRYCODE
String CONTACTKEY1099
String SUPDOCID
String VENDOR_AMEX_ORGANIZATION_ID
String VENDOR_AMEX_ORG_ADDRESS_ID
String VENDOR_AMEX_CD_AFFILIATE_ID
String VENDOR_AMEX_CARD_AFFILIATE_ID
String AMEX_BANK_ACCOUNT_ID
String AMEX_BANK_ACCOUNT_ADDRESS_ID
String MEGAENTITYKEY
String MEGAENTITYID
String MEGAENTITYNAME