accounts_payable_bills
FIELDS
RECORDNO, RECORDTYPE, RECORDID, CONTACTTAXGROUP, FINANCIALENTITY, STATE, RAWSTATE, VENDORID, VENDORNAME, FORM1099TYPE, FOR...
accounts_payable_bill_items
FIELDS
RECORDNO, RECORDKEY, ACCOUNTKEY, ACCOUNTNO, OFFSETACCOUNTKEY, OFFSETGLACCOUNTNO, OFFSETGLACCOUNTTITLE, ACCOUNTTITLE, ACCOU...
accounts_payable_payments
FIELDS
RECORDNO, PRBATCHKEY, RECORDTYPE, RECORDID, FINANCIALENTITY, FINANCIALENTITYTYPE, FINANCIALACCOUNTNAME, FINANCIALACCOUNTCU...
accounts_payable_payment_details
FIELDS
RECORDNO, RECORDKEY, ENTRYKEY, POSADJKEY, POSADJENTRYKEY, PAYMENTKEY, PAYMENTENTRYKEY, PAYMENTDATE, PAYMENTAMOUNT, TRX_PAY...
accounts_payable_vendors
FIELDS
RECORDNO, VENDORID, NAME, NAME1099, PARENTKEY, PARENTID, PARENTNAME, DISPLAYCONTACT.CONTACTNAME, DISPLAYCONTACT.COMPANYNAM...
accounts_payable_bank_accounts
FIELDS
RECORDNO, PROVIDERKEY, PROVIDERID, BANKACCOUNTKEY, BANKACCOUNTID, STATE, ISREBATEACCOUNT, MESSAGE, AUTHURL, WHENCREATED, W...
checking_accounts
FIELDS
BANKACCOUNTID, BANKACCOUNTNO, GLACCOUNTNO, GLACCOUNTTITLE, BANKNAME, ROUTINGNO, BRANCHID, BANKACCOUNTTYPE, PHONE, CHECKLAY...
savings_accounts
FIELDS
BANKACCOUNTID, BANKACCOUNTNO, GLACCOUNTNO, GLACCOUNTKEY, BANKNAME, ROUTINGNO, BRANCHID, BANKACCOUNTTYPE, PHONE, MAILADDRES...
card_accounts
FIELDS
RECORDNO, CARDID, DESCRIPTION, CARDNUM, CARDTYPE, EXP_MONTH, EXP_YEAR, MAILADDRESS.ADDRESS1, MAILADDRESS.ADDRESS2, MAILADD...
classes
FIELDS
RECORDNO, CLASSID, NAME, DESCRIPTION, STATUS, PARENTKEY, PARENTID, WHENCREATED, WHENMODIFIED, CREATEDBY, MODIFIEDBY, MEGAE...
tasks
FIELDS
RECORDNO, TASKID, PARENTKEY, PARENTID, NAME, PARENTTASKNAME, PROJECTKEY, PROJECTID, PROJECTNAME, PROJECTBEGINDATE, PROJECT...
general_ledger_accounts
FIELDS
RECORDNO, ACCOUNTNO, TITLE, ACCOUNTTYPE, NORMALBALANCE, CLOSINGTYPE, CLOSINGACCOUNTNO, CLOSINGACCOUNTTITLE, STATUS, REQUIR...
general_ledger_details
FIELDS
RECORDNO, BATCHKEY, BATCH_DATE, BATCH_TITLE, SYMBOL, BATCH_NO, BOOKID, CHILDENTITY, MODIFIED, REFERENCENO, ADJ, MODULEKEY,...
general_ledger_journal_entries
FIELDS
RECORDNO, BATCHNO, BATCH_TITLE, BALANCE, JOURNAL, BATCH_DATE, MODULE, USERKEY, REFERENCENO, REVERSED, REVERSEDKEY, REVERSE...
general_ledger_journal_entry_lines
FIELDS
RECORDNO, BATCHNO, USERNO, LINE_NO, TR_TYPE, ENTRY_DATE, AMOUNT, TRX_AMOUNT, BATCH_NUMBER, BATCH_DATE, BATCHTITLE, ACCOUNT...
projects
FIELDS
RECORDNO, PROJECTID, NAME, DESCRIPTION, CURRENCY, PROJECTCATEGORY, PROJECTSTATUSKEY, PROJECTSTATUS, PREVENTTIMESHEET, PREV...
invoices
FIELDS
RECORDNO, RECORDTYPE, RECORDID, CONTACTTAXGROUP, STATE, RAWSTATE, CUSTOMERID, CUSTOMERNAME, CUSTEMAILOPTIN, TRX_ENTITYDUE,...
adjustments
FIELDS
RECORDNO, RECORDTYPE, RECORDID, CONTACTTAXGROUP, STATE, RAWSTATE, CUSTOMERID, CUSTOMERNAME, CUSTEMAILOPTIN, TRX_ENTITYDUE,...
customers
FIELDS
RECORDNO, CUSTOMERID, NAME, ENTITY, PARENTKEY, PARENTID, PARENTNAME, DISPLAYCONTACT.CONTACTNAME, DISPLAYCONTACT.COMPANYNAM...
deposits
FIELDS
RECORDNO, FINANCIALENTITY, BANKACCOUNTKEY, WHENCREATED, DEPOSITID, RECORDTYPE, DESCRIPTION, BASECURR, CURRENCY, TOTALENTER...
items
FIELDS
RECORDNO, ITEMID, STATUS, MRR, NAME, EXTENDED_DESCRIPTION, PODESCRIPTION, SODESCRIPTION, ISSUPPLYITEM, PRODUCTLINEID, PROD...
invoice_items
FIELDS
RECORDNO, RECORDKEY, ACCOUNTKEY, ACCOUNTNO, OFFSETACCOUNTKEY, OFFSETGLACCOUNTNO, OFFSETGLACCOUNTTITLE, ACCOUNTTITLE, ACCOU...
adjustment_items
FIELDS
RECORDNO, RECORDKEY, ACCOUNTKEY, ACCOUNTNO, OFFSETACCOUNTKEY, OFFSETGLACCOUNTNO, OFFSETGLACCOUNTTITLE, ACCOUNTTITLE, ACCOU...
departments
FIELDS
DEPARTMENTID, RECORDNO, TITLE, PARENTKEY, PARENTID, PARENTNAME, SUPERVISORKEY, SUPERVISORID, WHENCREATED, WHENMODIFIED, SU...
audit_history_accounts_payable_bills
FIELDS
ID, OBJECTTYPE, OBJECTKEY, USERID, ACCESSTIME, ACCESSMODE, WORKFLOWACTION, IPADDRESS, SOURCE, NOTES, ACTION_DETAILS, FIELD...
audit_history_accounts_payable_bill_items
FIELDS
ID, OBJECTTYPE, OBJECTKEY, USERID, ACCESSTIME, ACCESSMODE, WORKFLOWACTION, IPADDRESS, SOURCE, NOTES, ACTION_DETAILS, FIELD...
audit_history_accounts_payable_payments
FIELDS
ID, OBJECTTYPE, OBJECTKEY, USERID, ACCESSTIME, ACCESSMODE, WORKFLOWACTION, IPADDRESS, SOURCE, NOTES, ACTION_DETAILS, FIELD...
audit_history_accounts_payable_payment_details
FIELDS
ID, OBJECTTYPE, OBJECTKEY, USERID, ACCESSTIME, ACCESSMODE, WORKFLOWACTION, IPADDRESS, SOURCE, NOTES, ACTION_DETAILS, FIELD...
audit_history_accounts_payable_vendors
FIELDS
ID, OBJECTTYPE, OBJECTKEY, USERID, ACCESSTIME, ACCESSMODE, WORKFLOWACTION, IPADDRESS, SOURCE, NOTES, ACTION_DETAILS, FIELD...
audit_history_accounts_payable_bank_accounts
FIELDS
ID, OBJECTTYPE, OBJECTKEY, USERID, ACCESSTIME, ACCESSMODE, WORKFLOWACTION, IPADDRESS, SOURCE, NOTES, ACTION_DETAILS, FIELD...
audit_history_checking_accounts
FIELDS
ID, OBJECTTYPE, OBJECTKEY, USERID, ACCESSTIME, ACCESSMODE, WORKFLOWACTION, IPADDRESS, SOURCE, NOTES, ACTION_DETAILS, FIELD...
audit_history_savings_accounts
FIELDS
ID, OBJECTTYPE, OBJECTKEY, USERID, ACCESSTIME, ACCESSMODE, WORKFLOWACTION, IPADDRESS, SOURCE, NOTES, ACTION_DETAILS, FIELD...
audit_history_card_accounts
FIELDS
ID, OBJECTTYPE, OBJECTKEY, USERID, ACCESSTIME, ACCESSMODE, WORKFLOWACTION, IPADDRESS, SOURCE, NOTES, ACTION_DETAILS, FIELD...
audit_history_classes
FIELDS
ID, OBJECTTYPE, OBJECTKEY, USERID, ACCESSTIME, ACCESSMODE, WORKFLOWACTION, IPADDRESS, SOURCE, NOTES, ACTION_DETAILS, FIELD...
audit_history_tasks
FIELDS
ID, OBJECTTYPE, OBJECTKEY, USERID, ACCESSTIME, ACCESSMODE, WORKFLOWACTION, IPADDRESS, SOURCE, NOTES, ACTION_DETAILS, FIELD...
audit_history_general_ledger_accounts
FIELDS
ID, OBJECTTYPE, OBJECTKEY, USERID, ACCESSTIME, ACCESSMODE, WORKFLOWACTION, IPADDRESS, SOURCE, NOTES, ACTION_DETAILS, FIELD...
audit_history_general_ledger_details
FIELDS
ID, OBJECTTYPE, OBJECTKEY, USERID, ACCESSTIME, ACCESSMODE, WORKFLOWACTION, IPADDRESS, SOURCE, NOTES, ACTION_DETAILS, FIELD...
audit_history_general_ledger_journal_entries
FIELDS
ID, OBJECTTYPE, OBJECTKEY, USERID, ACCESSTIME, ACCESSMODE, WORKFLOWACTION, IPADDRESS, SOURCE, NOTES, ACTION_DETAILS, FIELD...
audit_history_general_ledger_journal_entry_lines
FIELDS
ID, OBJECTTYPE, OBJECTKEY, USERID, ACCESSTIME, ACCESSMODE, WORKFLOWACTION, IPADDRESS, SOURCE, NOTES, ACTION_DETAILS, FIELD...
audit_history_projects
FIELDS
ID, OBJECTTYPE, OBJECTKEY, USERID, ACCESSTIME, ACCESSMODE, WORKFLOWACTION, IPADDRESS, SOURCE, NOTES, ACTION_DETAILS, FIELD...
audit_history_invoices
FIELDS
ID, OBJECTTYPE, OBJECTKEY, USERID, ACCESSTIME, ACCESSMODE, WORKFLOWACTION, IPADDRESS, SOURCE, NOTES, ACTION_DETAILS, FIELD...
audit_history_adjustments
FIELDS
ID, OBJECTTYPE, OBJECTKEY, USERID, ACCESSTIME, ACCESSMODE, WORKFLOWACTION, IPADDRESS, SOURCE, NOTES, ACTION_DETAILS, FIELD...
audit_history_customers
FIELDS
ID, OBJECTTYPE, OBJECTKEY, USERID, ACCESSTIME, ACCESSMODE, WORKFLOWACTION, IPADDRESS, SOURCE, NOTES, ACTION_DETAILS, FIELD...
audit_history_deposits
FIELDS
ID, OBJECTTYPE, OBJECTKEY, USERID, ACCESSTIME, ACCESSMODE, WORKFLOWACTION, IPADDRESS, SOURCE, NOTES, ACTION_DETAILS, FIELD...
audit_history_items
FIELDS
ID, OBJECTTYPE, OBJECTKEY, USERID, ACCESSTIME, ACCESSMODE, WORKFLOWACTION, IPADDRESS, SOURCE, NOTES, ACTION_DETAILS, FIELD...
audit_history_invoice_items
FIELDS
ID, OBJECTTYPE, OBJECTKEY, USERID, ACCESSTIME, ACCESSMODE, WORKFLOWACTION, IPADDRESS, SOURCE, NOTES, ACTION_DETAILS, FIELD...
audit_history_adjustment_items
FIELDS
ID, OBJECTTYPE, OBJECTKEY, USERID, ACCESSTIME, ACCESSMODE, WORKFLOWACTION, IPADDRESS, SOURCE, NOTES, ACTION_DETAILS, FIELD...
audit_history_departments
FIELDS
ID, OBJECTTYPE, OBJECTKEY, USERID, ACCESSTIME, ACCESSMODE, WORKFLOWACTION, IPADDRESS, SOURCE, NOTES, ACTION_DETAILS, FIELD...
audit_history_locations
FIELDS
ID, OBJECTTYPE, OBJECTKEY, USERID, ACCESSTIME, ACCESSMODE, WORKFLOWACTION, IPADDRESS, SOURCE, NOTES, ACTION_DETAILS, FIELD...
audit_history_budget_list
FIELDS
ID, OBJECTTYPE, OBJECTKEY, USERID, ACCESSTIME, ACCESSMODE, WORKFLOWACTION, IPADDRESS, SOURCE, NOTES, ACTION_DETAILS, FIELD...
audit_history_budget_details
FIELDS
ID, OBJECTTYPE, OBJECTKEY, USERID, ACCESSTIME, ACCESSMODE, WORKFLOWACTION, IPADDRESS, SOURCE, NOTES, ACTION_DETAILS, FIELD...
audit_history_po_documents
FIELDS
ID, OBJECTTYPE, OBJECTKEY, USERID, ACCESSTIME, ACCESSMODE, WORKFLOWACTION, IPADDRESS, SOURCE, NOTES, ACTION_DETAILS, FIELD...
audit_history_employees
FIELDS
ID, OBJECTTYPE, OBJECTKEY, USERID, ACCESSTIME, ACCESSMODE, WORKFLOWACTION, IPADDRESS, SOURCE, NOTES, ACTION_DETAILS, FIELD...
locations
FIELDS
LOCATIONID, RECORDNO, NAME, PARENTID, PARENTNAME, SUPERVISORNAME, SUPERVISORID, CONTACTINFO.CONTACTNAME, CONTACTINFO.LASTN...
budget_list
FIELDS
RECORDNO, BUDGETID, DESCRIPTION, SYSTEMGENERATED, DEFAULT_BUDGET, USER, STATUS, WHENCREATED, WHENMODIFIED, CREATEDBY, MODI...
budget_details
FIELDS
RECORDNO, BUDGETKEY, BUDGETID, CURRENCY, SYSTEMGENERATED, PERIODKEY, ACCOUNTKEY, DEPTKEY, LOCATIONKEY, AMOUNT, BASEDON, GR...
po_documents
FIELDS
RECORDNO, DOCNO, DOCID, CREATEDFROM, STATE, CLOSED, WHENCREATED, AUWHENCREATED, CREATEDBY, MODIFIEDBY, WHENMODIFIED, WHEND...
employees
FIELDS
RECORDNO, EMPLOYEEID, SSN, TITLE, LOCATIONID, LOCATIONKEY, DEPARTMENTID, DEPARTMENTKEY, PARENTKEY, SUPERVISORID, SUPERVISO...