Method QuickBooks Online Table Documentation

Account QuickBooks Table


AccountNumber		Text	7
AccountType	AccountAccountType (AccountTypeName)	Dropdown	50
Balance		Money	0
BankNumber		Text	25
BankType	AccountBankType (BankTypeName)	Dropdown	10
CashFlowClassification	AccountCashFlowClassification (CashFlowClassificationName)	Dropdown	20
Currency	Currency (CurrencyCode)	Dropdown	0
↳ CurrencySymbol	(CurrencySymbol)	Linked	10
Desc		Text	200
DetailAccountType	AccountDetailAccountType (DetailAccountTypeName)	Dropdown	0
EditSequence		Text	50
FullName		Text	1000
IsActive		YesNo	0
IsTaxAccount		YesNo	0
LastCheckNumber		Text	50
LastModifiedDate		DateTime	255
ListID		Text	100
Name		Text	31
ParentFullName	Account (FullName)	Dropdown	1000
RecordID		Integer	0
SalesTaxCode	SalesTaxCode (Name)	Dropdown	3
SpecialAccountType	AccountSpecialAccountType (SpecialAccountTypeName)	Dropdown	50
Sublevel		Integer	0
TaxLineInfoRet		Integer	0
TimeCreated		DateTime	0
TimeModifiedAccounting		DateTime	0
TotalBalance		Money	0

AccountAccountType Method Table


AccountTypeName	Text	50
LastModifiedDate	DateTime	255
RecordID	Integer	0

AccountBankType QuickBooks Table


BankTypeName	Text	10
Description	Text	50
LastModifiedDate	DateTime	255
RecordID	Integer	0

AccountCashFlowClassification Method Table


CashFlowClassificationName	Text	20
LastModifiedDate	DateTime	255
RecordID	Integer	0

AccountDetailAccountType Method Table


DetailAccountTypeName	Text	50
LastModifiedDate	DateTime	255
RecordID	Integer	0

AccountSpecialAccountType Method Table


LastModifiedDate	DateTime	255
RecordID	Integer	0
SpecialAccountTypeName	Text	50

Activity Method Table


ActivityGroup	ActivityGroup (Name)	Dropdown	0
ActivityInvoiceType	ActivityInvoiceType (ActivityInvoiceType)	Dropdown	0
ActivityPriority	ActivityPriority (ActivityPriority)	Dropdown	50
ActivityStatus	ActivityStatus (ActivityStatus)	Dropdown	50
↳ ActivityStatusColor	(StatusColor)	Linked	50
↳ ActivityStatusType	(ActivityStatusType)	Linked	0
ActivityType	ActivityType (ActivityType)	Dropdown	-1
↳ ActivityTypeIsAppSpecific	(IsAppSpecific)	Linked	0
↳ ActivityTypeIsShowOnCalendar	(IsShowOnCalendar)	Linked	255
ActualCompletedDate		DateTime	255
ActualDuration		Decimal	2
ActualStartDate		DateTime	255
AssignedTo	Users (UserName)	Dropdown	-1
Campaign	Campaign (Name)	Dropdown	-1
Cases	Cases (RecordID)	Dropdown	-1
↳ IsClosedCaseStatus	(IsClosedCaseStatus)	Linked	255
Comments		Text	32000
ContactEmail		Text	1023
ContactName		Text	100
ContactPhoneNumber		Text	100
Contacts	Contacts (RecordID)	Dropdown	-1
↳ ContactsAssignedTo	(AssignedTo)	Linked	-1
↳ ContactsBalance	(Balance)	Linked	255
↳ ContactsCampaign	(Name)	Linked	-1
↳ ContactsEmail	(Email)	Linked	1023
↳ ContactsFaceBookUserName	(FaceBookUserName)	Linked	75
↳ ContactsLinkedInPublicUserName	(LinkedInPublicUserName)	Linked	100
↳ ContactsMobile	(Mobile)	Linked	21
↳ ContactsName	(Name)	Linked	0
↳ ContactsPhone	(Phone)	Linked	21
↳ ContactsTitle	(Title)	Linked	255
↳ ContactsTwitterUserName	(TwitterUserName)	Linked	15
↳ ContactsWebsite	(Website)	Linked	255
CreatedBy	Users (spdSecurityUserName)	Dropdown	-1
CreatedDate		DateTime	-1
DueDateEnd		DateTime	255
DueDateStart		DateTime	-1
EmailBCC		Text	1023
EmailBody		Text	32000
EmailCC		Text	1023
EmailFrom		Text	1023
EmailFromName		Text	255
EmailSubject		Text	1000
EmailTemplate	EmailTemplate (Name)	Dropdown	-1
EmailTo		Text	1023
Entity	Entity (FullName)	Dropdown	-1
↳ ActivityCompanyName	(CompanyName)	Linked	255
↳ BillAddressAddr1	(BillAddressAddr1)	Linked	500
↳ BillAddressAddr2	(BillAddressAddr2)	Linked	500
↳ BillAddressAddr3	(BillAddressAddr3)	Linked	500
↳ BillAddressCity	(BillAddressCity)	Linked	255
↳ BillAddressCountry	(BillAddressCountry)	Linked	255
↳ BillAddressPostalCode	(BillAddressPostalCode)	Linked	30
↳ BillAddressState	(BillAddressState)	Linked	255
↳ EntityCompanyName	(CompanyName)	Linked	50
↳ EntityType	(EntityType)	Linked	0
↳ ShipAddressAddr1	(ShipAddressAddr1)	Linked	500
↳ ShipAddressAddr2	(ShipAddressAddr2)	Linked	500
↳ ShipAddressAddr3	(ShipAddressAddr3)	Linked	500
↳ ShipAddressCity	(ShipAddressCity)	Linked	255
↳ ShipAddressCountry	(ShipAddressCountry)	Linked	0
↳ ShipAddressPostalCode	(ShipAddressPostalCode)	Linked	30
↳ ShipAddressState	(ShipAddressState)	Linked	255
EstimateRecordID	Estimate (RecordID)	Dropdown	0
FollowUpFromActivityNo	Activity (RecordID)	Dropdown	-1
↳ FollowUpFromActivityComments	(Comments)	Linked	32000
InvoiceRecordID	Invoice (RecordID)	Dropdown	0
IsAllDayAppointment		YesNo	-1
IsChangedOccurrence		YesNo	-1
IsNotInternal		YesNo	0
IsToBeRenewed		YesNo	-1
Job	Jobs (RecordID)	Dropdown	0
JobSiteAddr1		Text	500
JobSiteAddr2		Text	500
JobSiteAddr3		Text	500
JobSiteAddr4		Text	500
JobSiteAddr5		Text	500
JobSiteCity		Text	500
JobSiteCountry		Text	255
JobSitePostalCode		Text	30
JobSiteState		Text	255
LastModifiedBy	Users (spdSecurityUserName)	Dropdown	-1
LastModifiedDate		DateTime	255
NoSkipSync		Text	10
Opportunity	Opportunity (RecordID)	Dropdown	-1
↳ OpportunityStageCategory	(OpportunityStageCategory)	Linked	50
OutlookApplicationId		Text	200
OutlookSyncId		Text	200
ProposalRecordID	Proposal (RecordID)	Dropdown	0
PurchaseOrderRecordID	PurchaseOrder (RecordID)	Dropdown	0
ReceivePaymentRecordID	ReceivePayment (RecordID)	Dropdown	0
RecordID		Integer	0
RecurrenceInfo		Text	8000
RecurrenceRecordID		Integer	-1
RecurrenceType		Text	10
RefNumber		Text	11
SalesOrderRecordID	SalesOrder (RecordID)	Dropdown	0
SalesReceiptRecordID	SalesReceipt (RecordID)	Dropdown	0
SortOrder		Integer	0
TagList		Text	4000
TempBillAddressCityStateProvZipPostal		Text	1000
TotalAmount		Money	0
TotalCost		Money	0
WorkOrderInstructions		Text	32000
WorkOrderRecordID	Activity (RecordID)	Dropdown	0

ActivityEntryType Method Table


ActivityEntryType		Text	50
DefaultActivityTypeForEntryType	ActivityType (ActivityType)	Dropdown	-1
IsSetForDefaultActivityType		YesNo	255
LastModifiedDate		DateTime	255
RecordID		Integer	-1

ActivityGroup Method Table


LastModifiedDate	DateTime	255
Name	Text	255
RecordID	Integer	0

ActivityInvoiceType Method Table


ActivityInvoiceType	Text	255
InvoiceTypeColor	Text	10
InvoiceTypeIcon	Picture	0
LastModifiedDate	DateTime	255
RecordID	Integer	0

ActivityJobItems Method Table


ActivityJobItemGroupRecordID	ActivityJobItems (RecordID)	Dropdown	0
ActivityNo	Activity (RecordID)	Dropdown	0
↳ ActivityAssignedTo	(AssignedTo)	Linked	0
↳ ActivityAssignedToRecordID	(AssignedTo_RecordID)	Linked	0
↳ ActivityDueDateStart	(DueDateStart)	Linked	0
↳ ActivityInvoiceType	(ActivityInvoiceType)	Linked	0
↳ ActivityRecurrenceType	(RecurrenceType)	Linked	0
↳ ActivtiyStatusType	(ActivityStatusType)	Linked	0
ActManHrs		Decimal	2
Amount		Money	0
Class	Class (FullName)	Dropdown	0
Cost		Money	0
CostPer		Money	0
CustomerEquipment	customerequipment (Name)	Dropdown	0
EstManHrs		Decimal	2
Instructions		Text	4000
IsIncludedOnInvoice		YesNo	0
IsTimerOn		YesNo	0
Item	Item (FullName)	Dropdown	0
↳ ItemType	(ItemType)	Linked	0
ItemDescription		Text	4000
ItemSalesTax	SalesTaxCode (Name)	Dropdown	0
LastModifiedDate		DateTime	255
Qty		Decimal	5
Rate		Money	0
RecordID		Integer	0

ActivityPriority Method Table


ActivityPriority	Text	255
LastModifiedDate	DateTime	255
RecordID	Integer	0

ActivityStatus Method Table


ActivityStatus		Text	255
ActivityStatusType	ActivityStatusType (Name)	Dropdown	0
IsActive		YesNo	0
IsCauseReminder		YesNo	0
LastModifiedDate		DateTime	255
RecordID		Integer	0
StatusColor		Text	50

ActivityStatusType Method Table


LastModifiedDate	DateTime	255
Name	Text	25
RecordID	Integer	0

ActivityType Method Table


ActivityEntryType	ActivityEntryType (ActivityEntryType)	Dropdown	50
ActivityType		Text	255
AutoFollowUpActivityPriority	ActivityPriority (ActivityPriority)	Dropdown	-1
AutoFollowUpActivityStatus	ActivityStatus (ActivityStatus)	Dropdown	-1
AutoFollowUpActivityType	ActivityType (ActivityType)	Dropdown	-1
AutoFollowUpAssignedTo	Users (UserName)	Dropdown	-1
AutoFollowUpDaysLater		Integer	255
DefaultActivityStatus	ActivityStatus (ActivityStatus)	Dropdown	0
Description		Text	255
IsActive		YesNo	255
IsAppSpecific		YesNo	0
IsAutoCreateFollowUp		YesNo	255
IsCauseReminder		YesNo	0
IsShowOnCalendar		YesNo	255
LastModifiedDate		DateTime	255
RecordID		Integer	0

AuditTrail Method Table


Action	Text	30
Comment	Text	4000
ComputerName	Text	50
CreatedDate	DateTime	0
IPAddressLocal	Text	20
IPAddressPublic	Text	20
RecordID	Integer	0
TableName	Text	100
TableRecordID	Integer	0
UserName	Text	25

Bill QuickBooks Table


AmountDue		Money	0
AmountDueInHomeCurrency		Decimal	0
APAccount	Account (FullName)	Dropdown	0
Bankinfo	BillPaymentCheck (Amount)	Dropdown	-1
↳ BankAccount	(BankAccount)	Linked	0
Campaign	Campaign (Name)	Dropdown	-1
Currency	Currency (CurrencyCode)	Dropdown	0
↳ CurrencySymbol	(CurrencySymbol)	Linked	10
DueDate		DateTime	0
EditSequence		Text	50
ExchangeRate		Decimal	0
IsPaid		YesNo	0
IsTaxIncluded		YesNo	0
IsWaitingForSyncApproval		YesNo	0
LastModifiedDate		DateTime	255
Location	InventoryControlLocation (FullName)	Dropdown	-1
↳ LocationRoot	(RootName)	Linked	255
Memo		Text	4000
OpenAmount		Money	0
PrintOrCheck	PrintOrCheck (PrintOrCheck)	Dropdown	50
RecordID		Integer	0
RefNumber		Text	21
SalesTaxCode	SalesTaxCode (Name)	Dropdown	0
TagList		Text	4000
TaxCalculation	TaxCalculationType (Name)	Dropdown	0
Terms	Terms (Name)	Dropdown	0
TimeCreated		DateTime	0
TimeModifiedAccounting		DateTime	0
TxnDate		DateTime	0
TxnID		Text	100
TxnMethodFlag		Text	31
TxnNumber		Integer	0
Vendor	Entity (FullName)	Dropdown	0
↳ VendorBalance	(Balance)	Linked	255

BillLineExpense QuickBooks Table


Account	Account (FullName)	Dropdown	0
Amount		Money	0
AmountInclusive		Money	100
BillableStatus	BillableStatus (BillableStatus)	Dropdown	0
BillRecordID	Bill (RecordID)	Dropdown	0
Class	Class (FullName)	Dropdown	0
Customer	Entity (FullName)	Dropdown	0
IsMarkupPercent		YesNo	0
LastModifiedDate		DateTime	255
MarkupRate		Decimal	0
Memo		Text	4000
RecordID		Integer	0
SalesTaxCode	SalesTaxCode (Name)	Dropdown	0
TxnLineID		Text	100
TxnMethodFlag		Text	31

BillLineItem QuickBooks Table


Amount		Money	0
AmountInclusive		Money	100
BillableStatus	BillableStatus (BillableStatus)	Dropdown	0
BillLineGroupRecordID	BillLineItem (RecordID)	Dropdown	0
BillRecordID	Bill (RecordID)	Dropdown	0
↳ BillTxnDate	(TxnDate)	Linked	0
Class	Class (FullName)	Dropdown	0
Cost		Decimal	5
CostInclusive		Decimal	100
Customer	Entity (FullName)	Dropdown	0
Desc		Text	4000
IsMarkupPercent		YesNo	0
Item	Item (FullName)	Dropdown	0
LastModifiedDate		DateTime	255
LinkToPurchaseOrder	purchaseorderline (RecordID)	Dropdown	0
MarkupRate		Decimal	0
QuanityOnTransferOrder		Decimal	0
Quantity		Decimal	0
RecordID		Integer	0
SalesTaxCode	SalesTaxCode (Name)	Dropdown	0
TxnLineID		Text	100
TxnMethodFlag		Text	31

BillableStatus QuickBooks Table


BillableStatus	Text	50
LastModifiedDate	DateTime	255
RecordID	Integer	0

Campaign Method Table


ActualCost		Money	255
AssignedTo	Users (UserName)	Dropdown	-1
BudgetedCost		Money	255
CampaignActivityAssignedTo	Users (spdSecurityUserName)	Dropdown	0
CampaignActivityComments		Text	32000
CampaignActivityDueDateEnd		DateTime	0
CampaignActivityDueDateStart		DateTime	0
CampaignActivityPriority	ActivityPriority (ActivityPriority)	Dropdown	0
CampaignActivityStatus	ActivityStatus (ActivityStatus)	Dropdown	0
CampaignActivityType	ActivityType (ActivityType)	Dropdown	0
CampaignFollowupActivityAssignedTo	Users (spdSecurityUserName)	Dropdown	0
CampaignFollowupActivityDueDateEnd		DateTime	0
CampaignFollowupActivityDueDateStart		DateTime	0
CampaignFollowupActivityPriority	ActivityPriority (ActivityPriority)	Dropdown	0
CampaignFollowupActivityStatus	ActivityStatus (ActivityStatus)	Dropdown	0
CampaignFollowupActivityType	ActivityType (ActivityType)	Dropdown	0
CampaignStatus	CampaignStatus (CampaignStatus)	Dropdown	50
CampaignType	CampaignType (CampaignType)	Dropdown	50
CreatedBy	Users (spdSecurityUserName)	Dropdown	-1
CreatedDate		DateTime	-1
Description		Text	4000
EmailBody		Text	32000
EmailFromAddress		Text	255
EmailFromName		Text	255
EmailSenderRecordID	EmailSenders (RecordID)	Dropdown	0
EmailSubject		Text	255
EmailTemplateToSend	EmailTemplate (Name)	Dropdown	0
EndDate		DateTime	255
ExpectedResponsePercent		Decimal	2
ExpectedRevenue		Money	255
IsActive		YesNo	255
IsAppendOptoutMessage		YesNo	0
IsCampaignCreateActivity		YesNo	0
IsCampaignFollowActivity		YesNo	0
IsEmailSent		YesNo	0
IsTestEmailSent		YesNo	0
LastModifiedBy	Users (spdSecurityUserName)	Dropdown	-1
LastModifiedDate		DateTime	255
Name		Text	100
OptoutMessage		Text	4000
RecordID		Integer	0
StartDate		DateTime	255
TotalContacts		Integer	255
TotalLeads		Integer	255
TotalLeadsConverted		Integer	255
TotalOpportunities		Integer	255
TotalOpportunitiesLost		Integer	255
TotalOpportunitiesWon		Integer	255
TotalResponses		Integer	255
TotalSent		Integer	255
TotalsLastCalculatedDate		DateTime	255
TotalUnsubscribed		Integer	0
TotalValueOpportunities		Money	255
TotalValueOpportunitiesLost		Money	255
TotalValueOpportunitiesWon		Money	255

CampaignEmailOutboundStatus Method Table


CampaignEmailOutboundStatus	Text	50
LastModifiedDate	DateTime	255
RecordID	Integer	0

CampaignStatus Method Table


CampaignStatus	Text	255
LastModifiedDate	DateTime	255
RecordID	Integer	0

CampaignType Method Table


CampaignType	Text	255
LastModifiedDate	DateTime	255
RecordID	Integer	0

CaseOrigin Method Table


CaseOrigin	Text	255
IsActive	YesNo	0
LastModifiedDate	DateTime	255
RecordID	Integer	0

CasePriority Method Table


CasePriority	Text	255
IsActive	YesNo	0
LastModifiedDate	DateTime	255
RecordID	Integer	0

CaseReason Method Table


CaseReason	Text	255
IsActive	YesNo	0
LastModifiedDate	DateTime	255
RecordID	Integer	0

CaseStatus Method Table


CaseStatus	Text	255
IsActive	YesNo	0
IsClosedCaseStatus	YesNo	255
LastModifiedDate	DateTime	255
RecordID	Integer	0

CaseType Method Table


CaseType	Text	255
IsActive	YesNo	0
IsNotShowInPortal	YesNo	0
LastModifiedDate	DateTime	255
RecordID	Integer	0

Cases Method Table


AssignedTo	Users (UserName)	Dropdown	-1
CaseOrigin	CaseOrigin (CaseOrigin)	Dropdown	-1
CasePriority	CasePriority (CasePriority)	Dropdown	50
CaseReason	CaseReason (CaseReason)	Dropdown	50
CaseStatus	CaseStatus (CaseStatus)	Dropdown	-1
↳ IsClosedCaseStatus	(IsClosedCaseStatus)	Linked	255
CaseType	CaseType (CaseType)	Dropdown	50
ClosedDate		DateTime	255
ContactEmail		Text	1023
ContactFax		Text	21
ContactMobile		Text	21
ContactName		Text	41
ContactPhone		Text	21
Contacts	Contacts (RecordID)	Dropdown	-1
↳ ContactsAssignedTo	(AssignedTo)	Linked	-1
↳ ContactsBalance	(Balance)	Linked	255
↳ ContactsCampaign	(Name)	Linked	-1
↳ ContactsEmail	(Email)	Linked	1023
↳ ContactsFaceBookUserName	(FaceBookUserName)	Linked	75
↳ ContactsLinkedInPublicUserName	(LinkedInPublicUserName)	Linked	100
↳ ContactsMobile	(Mobile)	Linked	21
↳ ContactsName	(Name)	Linked	0
↳ ContactsPhone	(Phone)	Linked	21
↳ ContactsTitle	(Title)	Linked	255
↳ ContactsTwitterUserName	(TwitterUserName)	Linked	15
↳ ContactsWebsite	(Website)	Linked	255
CreatedBy	Users (spdSecurityUserName)	Dropdown	-1
CreatedDate		DateTime	-1
Description		Text	32000
Entity	Entity (FullName)	Dropdown	-1
↳ BillAddressAddr1	(BillAddressAddr1)	Linked	500
↳ BillAddressAddr2	(BillAddressAddr2)	Linked	500
↳ BillAddressAddr3	(BillAddressAddr3)	Linked	500
↳ BillAddressCity	(BillAddressCity)	Linked	255
↳ BillAddressCountry	(BillAddressCountry)	Linked	255
↳ BillAddressPostalCode	(BillAddressPostalCode)	Linked	30
↳ BillAddressState	(BillAddressState)	Linked	255
↳ EntityCompanyName	(CompanyName)	Linked	50
InternalComments		Text	4000
IsClosedBySelfService		YesNo	255
IsClosedWhenCreated		YesNo	255
IsEmailCaseNotificationToContact		YesNo	255
LastCompletedActivity	Activity (RecordID)	Dropdown	0
↳ LastActivityCompletedDate	(ActualCompletedDate)	Linked	255
LastModifiedBy	Users (spdSecurityUserName)	Dropdown	-1
LastModifiedDate		DateTime	255
NextPendingActivity	Activity (RecordID)	Dropdown	0
↳ NextActivityDueDate	(DueDateStart)	Linked	-1
RecordID		Integer	0
Subject		Text	255
TagList		Text	4000
TempBillAddressCityStateProvZipPostal		Text	1000

Check QuickBooks Table


Account	Account (FullName)	Dropdown	0
Amount		Money	0
AmountInHomeCurrency		Decimal	0
Campaign	Campaign (Name)	Dropdown	-1
Currency	Currency (CurrencyCode)	Dropdown	0
EditSequence		Text	50
ExchangeRate		Decimal	0
IsTaxIncluded		YesNo	0
IsToBePrinted		YesNo	0
IsWaitingForSyncApproval		YesNo	0
LastModifiedDate		DateTime	255
Location	InventoryControlLocation (FullName)	Dropdown	-1
↳ LocationRoot	(RootName)	Linked	255
Memo		Text	4000
PayeeEntity	Entity (FullName)	Dropdown	0
RecordID		Integer	0
RefNumber		Text	21
SalesTaxCode	SalesTaxCode (Name)	Dropdown	0
TimeCreated		DateTime	0
TimeModifiedAccounting		DateTime	0
TxnDate		DateTime	0
TxnID		Text	100
TxnMethodFlag		Text	31
TxnNumber		Integer	0

CheckLineExpense QuickBooks Table


Account	Account (FullName)	Dropdown	0
Amount		Money	0
CheckRecordID	Check (RecordID)	Dropdown	0
Class	Class (FullName)	Dropdown	0
Customer	Entity (FullName)	Dropdown	0
LastModifiedDate		DateTime	255
Memo		Text	4000
RecordID		Integer	0
SalesTaxCode	SalesTaxCode (Name)	Dropdown	0
TxnLineID		Text	100
TxnMethodFlag		Text	31

Class QuickBooks Table


EditSequence		Text	50
FullName		Text	1000
IsActive		YesNo	0
LastModifiedDate		DateTime	255
ListID		Text	100
Name		Text	100
ParentFullName	Class (FullName)	Dropdown	1000
RecordID		Integer	0
Sublevel		Integer	0
TimeCreated		DateTime	0
TimeModifiedAccounting		DateTime	0

ClassDonorFlowPrograms Method Table


Classes	Class (FullName)	Dropdown	0
↳ ClassName	(Name)	Linked	0
ClassTitle		Text	255
DonorFlow	DonorFlow (RecordID)	Dropdown	0
LastModifiedDate		DateTime	255
RecordID		Integer	0

CommunicationTemplates Method Table


LastModifiedDate	DateTime	255
MessageCustom	Text	32000
MessageDefault	Text	32000
Name	Text	160
RecordID	Integer	0

Company QuickBooks Table


AccountingCompanyName	Text	100
AddressAddr1	Text	500
AddressAddr2	Text	500
AddressAddr3	Text	500
AddressAddr4	Text	500
AddressAddr5	Text	41
AddressAttentionTo	Text	255
AddressCity	Text	255
AddressCountry	Text	255
AddressNote	Text	41
AddressPostalCode	Text	30
AddressState	Text	255
CompanyAddressForCustomerAddr1	Text	500
CompanyAddressForCustomerAddr2	Text	500
CompanyAddressForCustomerAddr3	Text	500
CompanyAddressForCustomerAddr4	Text	500
CompanyAddressForCustomerAddr5	Text	500
CompanyAddressForCustomerAttentionTo	Text	255
CompanyAddressForCustomerCity	Text	255
CompanyAddressForCustomerCountry	Text	255
CompanyAddressForCustomerNote	Text	41
CompanyAddressForCustomerPostalCode	Text	30
CompanyAddressForCustomerState	Text	255
CompanyName	Text	59
CompanyType	Text	255
CompanyWebSite	Text	100
CurrencyCode	Text	3
CurrencySymbol	Text	10
Edition	Text	50
EIN	Text	20
Email	Text	100
Fax	Text	51
FirstMonthFiscalYear	Text	20
FirstMonthIncomeTaxYear	Text	20
IndustryCode	Text	50
IsItemCategoriesFeatureEnabled	YesNo	0
IsSampleCompany	YesNo	0
LastModifiedDate	DateTime	255
LegalAddressAddr1	Text	500
LegalAddressAddr2	Text	500
LegalAddressAddr3	Text	500
LegalAddressAddr4	Text	500
LegalAddressAddr5	Text	500
LegalAddressCity	Text	255
LegalAddressCountry	Text	255
LegalAddressNote	Text	41
LegalAddressPostalCode	Text	30
LegalAddressState	Text	255
LegalCompanyName	Text	100
NP501Status	Text	255
NPAggregateReportSignOff	Text	1500
NPAggregateReportStatement	Text	1500
NPFederalIdentificationNo	Text	255
NPReceiptStatement	Text	1500
OfferingSKU	Text	50
Phone	Text	20
QBCompanyStartDate	DateTime	0
RecordID	Integer	0
SSN	Text	11
SubscriptionStatus	Text	50
TaxForm	Text	20

CompanyCurrency QuickBooks Table


Code	Text	100
EditSequence	Text	20
IsActive	YesNo	0
ListID	Text	100
Name	Text	64
RecordID	Integer	0
TimeCreated	DateTime	0
TimeModifiedAccounting	DateTime	0

Contacts Method Table


AltPhone		Text	30
ContactPortalURL		Text	255
DirectDial		Text	80
Email		Text	1023
Entity	Entity (FullName)	Dropdown	-1
↳ AccountNumber	(AccountNumber)	Linked	99
↳ AssignedTo	(AssignedTo)	Linked	-1
↳ AssignedToRecordID	(AssignedTo_RecordID)	Linked	0
↳ Balance	(Balance)	Linked	255
↳ BillAddressAddr1	(BillAddressAddr1)	Linked	500
↳ BillAddressAddr2	(BillAddressAddr2)	Linked	500
↳ BillAddressAddr3	(BillAddressAddr3)	Linked	500
↳ BillAddressAddr4	(BillAddressAddr4)	Linked	500
↳ BillAddressAddr5	(BillAddressAddr5)	Linked	500
↳ BillAddressCity	(BillAddressCity)	Linked	255
↳ BillAddressCountry	(BillAddressCountry)	Linked	255
↳ BillAddressNote	(BillAddressNote)	Linked	41
↳ BillAddressPostalCode	(BillAddressPostalCode)	Linked	30
↳ BillAddressState	(BillAddressState)	Linked	255
↳ BirthDate	(BirthDate)	Linked	255
↳ Campaign	(Name)	Linked	-1
↳ Class	(FullName)	Linked	0
↳ CompanyName	(CompanyName)	Linked	50
↳ Currency	(Currency)	Linked	0
↳ CustomerHealthScore	(CustomerHealthScore)	Linked	0
↳ CustomerType	(FullName)	Linked	0
↳ EmployeeType	(Name)	Linked	0
↳ EntityCreatedDate	(CreatedDate)	Linked	0
↳ EntityLastInvoiceRecordIDAmount	(LastInvoiceRecordIDAmount)	Linked	0
↳ EntityLastInvoiceRecordIDTxnDate	(LastInvoiceRecordIDTxnDate)	Linked	0
↳ EntityLastSalesReceiptRecordIDTotalAmount	(LastSalesReceiptRecordIDTotalAmount)	Linked	0
↳ EntityLastSalesReceiptRecordIDTxnDate	(LastSalesReceiptRecordIDTxnDate)	Linked	0
↳ EntityLifetimeValue	(LifetimeValue)	Linked	0
↳ EntityRecordID	(RecordID)	Linked	0
↳ EntityType	(EntityType)	Linked	20
↳ Fax	(Fax)	Linked	30
↳ FullName	(FullName)	Linked	1000
↳ Gender	(Gender)	Linked	0
↳ IsActive	(IsActive)	Linked	0
↳ IsLeadStatusOnly	(IsLeadStatusOnly)	Linked	255
↳ IsTaxable	(IsTaxable)	Linked	0
↳ LastActivityCompletedDate	(LastActivityCompletedDate)	Linked	255
↳ LastCompletedActivity	(RecordID)	Linked	0
↳ LeadConvertedDate	(LeadConvertedDate)	Linked	255
↳ LeadRating	(LeadRating)	Linked	50
↳ LeadSource	(LeadSource)	Linked	50
↳ LeadStatus	(LeadStatus)	Linked	50
↳ NextActivityDueDate	(NextActivityDueDate)	Linked	-1
↳ NextPendingActivity	(RecordID)	Linked	0
↳ ParentFullName	(FullName)	Linked	0
↳ PreferredPaymentMethod	(Name)	Linked	0
↳ PriceLevel	(Name)	Linked	0
↳ PrintAs	(PrintAs)	Linked	41
↳ ResaleNumber	(ResaleNumber)	Linked	15
↳ SalesRep	(SalesRep)	Linked	0
↳ SalesRepRecordID	(RecordID)	Linked	0
↳ SalesTaxCode	(Name)	Linked	0
↳ SalesTaxItem	(FullName)	Linked	0
↳ ShipAddressAddr1	(ShipAddressAddr1)	Linked	500
↳ ShipAddressAddr2	(ShipAddressAddr2)	Linked	500
↳ ShipAddressAddr3	(ShipAddressAddr3)	Linked	500
↳ ShipAddressAddr4	(ShipAddressAddr4)	Linked	500
↳ ShipAddressAddr5	(ShipAddressAddr5)	Linked	500
↳ ShipAddressCity	(ShipAddressCity)	Linked	255
↳ ShipAddressCountry	(ShipAddressCountry)	Linked	255
↳ ShipAddressNote	(ShipAddressNote)	Linked	41
↳ ShipAddressPostalCode	(ShipAddressPostalCode)	Linked	30
↳ ShipAddressState	(ShipAddressState)	Linked	255
↳ Sublevel	(Sublevel)	Linked	0
↳ Terms	(Name)	Linked	0
↳ TotalBalance	(TotalBalance)	Linked	0
↳ VendorType	(FullName)	Linked	0
FaceBookUserName		Text	75
FirstName		Text	100
InstagramUserName		Text	255
IsOptOutOfBilling		YesNo	255
IsOptOutOfMarketing		YesNo	255
LastModifiedDate		DateTime	255
LastName		Text	100
LinkedInPublicUserName		Text	100
Mobile		Text	30
Name		Text	450
Note		Text	4000
Pager		Text	21
Phone		Text	30
PortalPassword		Text	10
PortalUserName		Text	10
ProfileImage		Picture	0
RecordID		Integer	0
SkypeUserName		Text	32
SpecialType		Text	10
TagList		Text	4000
Title		Text	41
TwitterUserName		Text	50
Website		Text	1000

CountryCode Method Table


CountryCode	Text	50
FullName	Text	255
LastModifiedDate	DateTime	255
RecordID	Integer	0

CreditCardCharge QuickBooks Table


Account	Account (FullName)	Dropdown	0
Amount		Money	0
AmountInHomeCurrency		Decimal	0
Currency	Currency (CurrencyCode)	Dropdown	0
EditSequence		Text	50
ExchangeRate		Decimal	0
IsTaxIncluded		YesNo	0
IsWaitingForSyncApproval		YesNo	0
LastModifiedDate		DateTime	255
Memo		Text	4000
PayeeEntity	Entity (FullName)	Dropdown	0
RecordID		Integer	0
RefNumber		Text	21
SalesTaxCode	SalesTaxCode (Name)	Dropdown	0
TimeCreated		DateTime	0
TimeModifiedAccounting		DateTime	0
TxnDate		DateTime	0
TxnID		Text	100
TxnMethodFlag		Text	31
TxnNumber		Integer	0

CreditCardChargeLineExpense QuickBooks Table


Account	Account (FullName)	Dropdown	0
Amount		Money	0
Class	Class (FullName)	Dropdown	0
CreditCardChargeRecordID	CreditCardCharge (RecordID)	Dropdown	0
Customer	Entity (FullName)	Dropdown	0
LastModifiedDate		DateTime	255
Memo		Text	4000
RecordID		Integer	0
SalesTaxCode	SalesTaxCode (Name)	Dropdown	0
TxnLineID		Text	100
TxnMethodFlag		Text	31

CreditCardChargeLineItem QuickBooks Table


Amount		Money	0
Class	Class (FullName)	Dropdown	0
Cost		Decimal	5
CreditCardChargeLineItemGroupRecordID	CreditCardChargeLineItem (RecordID)	Dropdown	0
CreditCardChargeRecordID	CreditCardCharge (RecordID)	Dropdown	0
Customer	Entity (FullName)	Dropdown	0
Desc		Text	4000
Item	Item (FullName)	Dropdown	0
LastModifiedDate		DateTime	255
Quantity		Decimal	0
RecordID		Integer	0
SalesTaxCode	SalesTaxCode (Name)	Dropdown	0
TxnLineID		Text	100
TxnMethodFlag		Text	31

CreditCardCredit QuickBooks Table


Account	Account (FullName)	Dropdown	0
Amount		Money	0
AmountInHomeCurrency		Decimal	0
Currency	Currency (CurrencyCode)	Dropdown	0
EditSequence		Text	50
ExchangeRate		Decimal	0
IsTaxIncluded		YesNo	0
IsWaitingForSyncApproval		YesNo	0
LastModifiedDate		DateTime	255
Memo		Text	4000
PayeeEntity	Entity (FullName)	Dropdown	0
RecordID		Integer	0
RefNumber		Text	21
SalesTaxCode	SalesTaxCode (Name)	Dropdown	0
TimeCreated		DateTime	0
TimeModifiedAccounting		DateTime	0
TxnDate		DateTime	0
TxnID		Text	100
TxnMethodFlag		Text	31
TxnNumber		Integer	0

CreditCardCreditLineExpense QuickBooks Table


Account	Account (FullName)	Dropdown	0
Amount		Money	0
Class	Class (FullName)	Dropdown	0
CreditCardCreditRecordID	CreditCardCredit (RecordID)	Dropdown	0
Customer	Entity (FullName)	Dropdown	0
LastModifiedDate		DateTime	255
Memo		Text	4000
RecordID		Integer	0
SalesTaxCode	SalesTaxCode (Name)	Dropdown	0
TxnLineID		Text	100
TxnMethodFlag		Text	31

CreditMemo QuickBooks Table


ARAccount	Account (FullName)	Dropdown	1000
AssignedTo	Users (UserName)	Dropdown	-1
BillAddressAddr1		Text	500
BillAddressAddr2		Text	500
BillAddressAddr3		Text	500
BillAddressAddr4		Text	500
BillAddressAddr5		Text	500
BillAddressCity		Text	255
BillAddressCountry		Text	255
BillAddressNote		Text	41
BillAddressPostalCode		Text	30
BillAddressState		Text	255
BillEmail		Text	100
Campaign	Campaign (Name)	Dropdown	-1
Class	Class (FullName)	Dropdown	1000
CreditRemaining		Money	0
CreditRemainingInHomeCurrency		Decimal	0
Currency	Currency (CurrencyCode)	Dropdown	0
Customer	Entity (FullName)	Dropdown	1000
CustomerMessage	CustomerMsg (Name)	Dropdown	0
CustomerMsgText		Text	1000
CustomerSalesTaxCode	SalesTaxCode (Name)	Dropdown	3
DiscountAmt		Decimal	0
DiscountRate		Decimal	0
DiscountTaxable		YesNo	1000
DueDate		DateTime	0
EditSequence		Text	50
ExchangeRate		Decimal	0
FOB		Text	13
hiddenInternalCUSTOMFIELD1		Text	31
hiddenInternalCUSTOMFIELD10		Text	31
hiddenInternalCUSTOMFIELD11		Text	31
hiddenInternalCUSTOMFIELD12		Text	31
hiddenInternalCUSTOMFIELD13		Text	31
hiddenInternalCUSTOMFIELD14		Text	31
hiddenInternalCUSTOMFIELD15		Text	31
hiddenInternalCUSTOMFIELD16		Text	31
hiddenInternalCUSTOMFIELD17		Text	31
hiddenInternalCUSTOMFIELD18		Text	31
hiddenInternalCUSTOMFIELD19		Text	31
hiddenInternalCUSTOMFIELD2		Text	31
hiddenInternalCUSTOMFIELD20		Text	31
hiddenInternalCUSTOMFIELD21		Text	31
hiddenInternalCUSTOMFIELD22		Text	31
hiddenInternalCUSTOMFIELD23		Text	31
hiddenInternalCUSTOMFIELD24		Text	31
hiddenInternalCUSTOMFIELD25		Text	31
hiddenInternalCUSTOMFIELD26		Text	31
hiddenInternalCUSTOMFIELD27		Text	31
hiddenInternalCUSTOMFIELD28		Text	31
hiddenInternalCUSTOMFIELD29		Text	31
hiddenInternalCUSTOMFIELD3		Text	31
hiddenInternalCUSTOMFIELD30		Text	31
hiddenInternalCUSTOMFIELD4		Text	31
hiddenInternalCUSTOMFIELD5		Text	31
hiddenInternalCUSTOMFIELD6		Text	31
hiddenInternalCUSTOMFIELD7		Text	31
hiddenInternalCUSTOMFIELD8		Text	31
hiddenInternalCUSTOMFIELD9		Text	31
IsPending		YesNo	0
IsTaxIncluded		YesNo	0
IsToBeEmailed		YesNo	0
IsToBePrinted		YesNo	0
IsWaitingForSyncApproval		YesNo	0
ItemSalesTax	Item (FullName)	Dropdown	31
LastModifiedDate		DateTime	255
Location	InventoryControlLocation (FullName)	Dropdown	-1
↳ LocationRoot	(RootName)	Linked	255
Memo		Text	4000
Opportunity	Opportunity (RecordID)	Dropdown	-1
Other		Text	29
PaymentMethod	PaymentMethod (Name)	Dropdown	0
PONumber		Text	25
RecordID		Integer	0
RefNumber		Text	21
SalesRep	SalesRep (Initial)	Dropdown	0
SalesTaxPercentage		Decimal	0
SalesTaxTotal		Money	0
ShipAddressAddr1		Text	500
ShipAddressAddr2		Text	500
ShipAddressAddr3		Text	500
ShipAddressAddr4		Text	500
ShipAddressAddr5		Text	500
ShipAddressCity		Text	255
ShipAddressCountry		Text	255
ShipAddressNote		Text	41
ShipAddressPostalCode		Text	30
ShipAddressState		Text	255
ShipDate		DateTime	0
ShipMethod	ShipMethod (Name)	Dropdown	100
ShippingAmt		Decimal	1000
Subtotal		Money	0
TaxCalculation	TaxCalculationType (Name)	Dropdown	0
TaxExemption	TaxExemptionReason (Reason)	Dropdown	0
Template	Template (Name)	Dropdown	31
Terms	Terms (Name)	Dropdown	100
TimeCreated		DateTime	0
TimeModifiedAccounting		DateTime	0
TotalAmount		Money	0
TxnDate		DateTime	0
TxnID		Text	100
TxnMethodFlag		Text	31
TxnNumber		Integer	0

CreditMemoLine QuickBooks Table


Amount		Money	0
AmountInclusive		Money	100
Class	Class (FullName)	Dropdown	159
CreditMemoLineGroupRecordID	CreditMemoLine (RecordID)	Dropdown	0
CreditMemoRecordID	CreditMemo (RecordID)	Dropdown	0
Desc		Text	4000
hiddenInternalCUSTOMFIELD1		Text	31
hiddenInternalCUSTOMFIELD10		Text	31
hiddenInternalCUSTOMFIELD11		Text	31
hiddenInternalCUSTOMFIELD12		Text	31
hiddenInternalCUSTOMFIELD13		Text	31
hiddenInternalCUSTOMFIELD14		Text	31
hiddenInternalCUSTOMFIELD15		Text	31
hiddenInternalCUSTOMFIELD16		Text	31
hiddenInternalCUSTOMFIELD17		Text	31
hiddenInternalCUSTOMFIELD18		Text	31
hiddenInternalCUSTOMFIELD19		Text	31
hiddenInternalCUSTOMFIELD2		Text	31
hiddenInternalCUSTOMFIELD20		Text	31
hiddenInternalCUSTOMFIELD21		Text	31
hiddenInternalCUSTOMFIELD22		Text	31
hiddenInternalCUSTOMFIELD23		Text	31
hiddenInternalCUSTOMFIELD24		Text	31
hiddenInternalCUSTOMFIELD25		Text	31
hiddenInternalCUSTOMFIELD26		Text	31
hiddenInternalCUSTOMFIELD27		Text	31
hiddenInternalCUSTOMFIELD28		Text	31
hiddenInternalCUSTOMFIELD29		Text	31
hiddenInternalCUSTOMFIELD3		Text	31
hiddenInternalCUSTOMFIELD30		Text	31
hiddenInternalCUSTOMFIELD4		Text	31
hiddenInternalCUSTOMFIELD5		Text	31
hiddenInternalCUSTOMFIELD6		Text	31
hiddenInternalCUSTOMFIELD7		Text	31
hiddenInternalCUSTOMFIELD8		Text	31
hiddenInternalCUSTOMFIELD9		Text	31
IsPrintItemsInGroup		YesNo	0
IsRatePercent		YesNo	0
Item	Item (FullName)	Dropdown	159
LastModifiedDate		DateTime	255
LineOrder		Integer	0
Other1		Text	29
Other2		Text	29
QuanityOnTransferOrder		Decimal	0
Quantity		Decimal	0
Rate		Decimal	5
RateInclusive		Money	100
RecordID		Integer	0
SalesTaxCode	SalesTaxCode (Name)	Dropdown	3
ServiceDate		DateTime	0
TaxClassificationRef		Integer	0
TotalAmount		Money	100
TxnLineID		Text	100
TxnMethodFlag		Text	31
UnitOfMeasure		Text	31

Currency QuickBooks Table


AsOfDate	DateTime	0
CurrencyCode	Text	3
CurrencySymbol	Text	10
DecimalPlaces	Integer	0
DecimalSeparator	Text	1
EditSequence	Text	100
ExchangeRate	Decimal	0
IsActive	YesNo	1
IsUserDefinedCurrency	YesNo	1
LastModifiedDate	DateTime	255
ListID	Text	100
Name	Text	64
RecordID	Integer	0
ThousandSeparator	Text	1
ThousandSeparatorGrouping	Text	20
TimeCreated	DateTime	0
TimeModifiedAccounting	DateTime	0

Customer QuickBooks Table


AltContact		Text	31
AltPhone		Text	30
AssignedTo	Users (UserName)	Dropdown	-1
Balance		Money	0
BillAddressAddr1		Text	500
BillAddressAddr2		Text	500
BillAddressAddr3		Text	500
BillAddressAddr4		Text	500
BillAddressAddr5		Text	500
BillAddressAttentionTo		Text	255
BillAddressCity		Text	255
BillAddressCountry		Text	255
BillAddressNote		Text	41
BillAddressPostalCode		Text	30
BillAddressState		Text	255
Campaign	Campaign (Name)	Dropdown	-1
Class	Class (FullName)	Dropdown	0
CompanyName		Text	100
CreatedDate		DateTime	255
CreditCardAddress		Text	41
CreditCardNumber		Text	25
CreditCardPostalCode		Text	41
CreditLimit		Decimal	0
Currency	Currency (CurrencyCode)	Dropdown	0
CustomerHealthScore		Decimal	0
CustomerType	CustomerType (FullName)	Dropdown	0
DeliveryMethod	DeliveryMethod (DeliveryMethodName)	Dropdown	50
DirectDial		Text	80
EditSequence		Text	50
Email		Text	100
EntityType		Text	20
ExpirationMonth		Integer	0
ExpirationYear		Integer	0
Fax		Text	30
FirstName		Text	100
FullName		Text	450
IsActive		YesNo	0
IsLeadStatusOnly		YesNo	0
IsStatementWithParent		YesNo	0
IsTaxable		YesNo	0
JobDesc		Text	99
JobEndDate		DateTime	0
JobProjectedEndDate		DateTime	0
JobStartDate		DateTime	0
JobStatus	JobStatus (JobStatus)	Dropdown	0
JobType	JobType (FullName)	Dropdown	0
LastCompletedActivity	Activity (RecordID)	Dropdown	0
↳ LastActivityCompletedDate	(ActualCompletedDate)	Linked	255
LastInvoiceRecordID	Invoice (RecordID)	Dropdown	0
↳ LastInvoiceRecordIDAmount	(Amount)	Linked	0
↳ LastInvoiceRecordIDTxnDate	(TxnDate)	Linked	0
LastModifiedDate		DateTime	255
LastName		Text	100
LastSalesReceiptRecordID	SalesReceipt (RecordID)	Dropdown	0
↳ LastSalesReceiptRecordIDTotalAmount	(TotalAmount)	Linked	0
↳ LastSalesReceiptRecordIDTxnDate	(TxnDate)	Linked	0
Latitude		Decimal	2
LeadConvertedDate		DateTime	255
LeadRating	LeadRating (LeadRating)	Dropdown	50
LeadSource	LeadSource (LeadSource)	Dropdown	-1
LeadStatus	LeadStatus (LeadStatus)	Dropdown	50
LifetimeValue		Decimal	2
ListID		Text	100
Longitude		Decimal	2
MergeOnNextSyncTo	Entity (FullName)	Dropdown	0
MiddleName		Text	100
Mobile		Text	30
Name		Text	450
NameOnCard		Text	41
NextPendingActivity	Activity (RecordID)	Dropdown	0
↳ NextActivityDueDate	(DueDateStart)	Linked	-1
Notes		Text	4000
OverdueARBalance		Money	255
OverduePayBalance		Money	255
Pager		Text	21
ParentFullName	Entity (FullName)	Dropdown	0
Phone		Text	30
PortalPassword		Text	10
PortalUserName		Text	10
PreferredPaymentMethod	PaymentMethod (Name)	Dropdown	0
PriceLevel	PriceLevel (Name)	Dropdown	0
PrintAs		Text	110
RecordID		Integer	0
ResaleNumber		Text	16
SalesRep	SalesRep (Initial)	Dropdown	5
↳ SalesRepRecordID	(RecordID)	Linked	0
SalesTaxCode	SalesTaxCode (Name)	Dropdown	0
SalesTaxCountry		Text	50
SalesTaxItem	Item (FullName)	Dropdown	0
Salutation		Text	16
ShipAddressAddr1		Text	500
ShipAddressAddr2		Text	500
ShipAddressAddr3		Text	500
ShipAddressAddr4		Text	500
ShipAddressAddr5		Text	500
ShipAddressAttentionTo		Text	255
ShipAddressCity		Text	255
ShipAddressCountry		Text	255
ShipAddressNote		Text	41
ShipAddressPostalCode		Text	30
ShipAddressState		Text	255
Sublevel		Integer	0
Suffix		Text	16
TaxExemptionReason	TaxExemptionReason (Reason)	Dropdown	0
Terms	Terms (Name)	Dropdown	100
TimeCreated		DateTime	0
TimeModifiedAccounting		DateTime	0
TotalBalance		Money	0

CustomerHealthScoreCalculationWeights Method Table


LastModifiedDate	DateTime	255
RecordID	Integer	-1
ScoreCategory	Text	255
Weight	Decimal	2

CustomerHealthScoreHistory Method Table


CalculatedDate		DateTime	-1
Customer	Entity (FullName)	Dropdown	-1
EngagementScore		Decimal	0
FinancialScore		Decimal	0
HealthScore		Decimal	0
LastModifiedDate		DateTime	255
RecordID		Integer	-1
SalesMomentumScore		Decimal	0
SupportScore		Decimal	0

CustomerPaymentInfo Method Table


EntityRecordID	Integer	0
Expiry	Text	10
Id	Text	100
Last4	Text	25
LastModifiedDate	DateTime	255
Name	Text	200
RecordID	Integer	0
Status	Text	25
Type	Text	100

CustomerType QuickBooks Table


EditSequence		Text	50
FullName		Text	1000
IsActive		YesNo	0
LastModifiedDate		DateTime	255
ListID		Text	100
Name		Text	31
ParentFullName	CustomerType (FullName)	Dropdown	1000
RecordID		Integer	0
Sublevel		Integer	0
TimeCreated		DateTime	0
TimeModifiedAccounting		DateTime	0

DocumentLibrary Method Table


AssignedTo	Users (UserName)	Dropdown	-1
CreatedBy	Users (spdSecurityUserName)	Dropdown	-1
CreatedDate		DateTime	255
Description		Text	4000
Document		File	255
DocumentExternalURL		Text	1000
DocumentLibraryFolder	DocumentLibraryFolder (Name)	Dropdown	-1
ExternalDocName		Text	255
IsActive		YesNo	255
IsForInternalUse		YesNo	-1
LastModifiedBy	Users (spdSecurityUserName)	Dropdown	-1
LastModifiedDate		DateTime	255
Name		Text	255
RecordID		Integer	0

DocumentLibraryFolder Method Table


AssignedTo	Users (UserName)	Dropdown	-1
CreatedBy	Users (spdSecurityUserName)	Dropdown	-1
CreatedDate		DateTime	-1
IsActive		YesNo	0
LastModifiedBy	Users (spdSecurityUserName)	Dropdown	-1
LastModifiedDate		DateTime	255
Name		Text	255
RecordID		Integer	0

DocumentLibraryLink Method Table


Activity	Activity (RecordID)	Dropdown	-1
Cases	Cases (RecordID)	Dropdown	-1
CreatedBy	Users (spdSecurityUserName)	Dropdown	-1
CreatedDate		DateTime	255
Document	DocumentLibrary (Name)	Dropdown	-1
↳ AssignedTo	(AssignedTo)	Linked	-1
↳ AssignedToRecordID	(AssignedTo_RecordID)	Linked	0
↳ DocumentAttachment	(Document)	Linked	255
↳ DocumentExternalURL	(DocumentExternalURL)	Linked	1000
↳ DocumentFileName	(DocumentFileName)	Linked	1000
↳ DocumentLibraryFolder	(Name)	Linked	-1
↳ IsForInternalUse	(IsForInternalUse)	Linked	255
Entity	Entity (FullName)	Dropdown	-1
Estimate	Estimate (RecordID)	Dropdown	-1
↳ EstimateRefNumber	(RefNumber)	Linked	50
Invoice	Invoice (RecordID)	Dropdown	-1
↳ InvoiceRefNumber	(RefNumber)	Linked	50
LastModifiedBy	Users (spdSecurityUserName)	Dropdown	-1
LastModifiedDate		DateTime	255
Notes		Text	1000
Opportunity	Opportunity (RecordID)	Dropdown	-1
↳ OpportunityName	(Name)	Linked	0
ReceivePayment	ReceivePayment (RecordID)	Dropdown	-1
↳ ReceivePaymentRefNumber	(RefNumber)	Linked	50
RecordID		Integer	0
SalesOrder	SalesOrder (RecordID)	Dropdown	-1
Solution	Solution (Title)	Dropdown	-1

DonationPlan Method Table


Amount		Money	0
AssignedTo	Users (UserName)	Dropdown	0
Customer	Entity (RecordID)	Dropdown	0
↳ BillAddressAddr1	(BillAddressAddr1)	Linked	0
↳ BillAddressAddr2	(BillAddressAddr2)	Linked	0
↳ BillAddressAddr3	(BillAddressAddr3)	Linked	0
↳ BillAddressAddr4	(BillAddressAddr4)	Linked	0
↳ BillAddressAddr5	(BillAddressAddr5)	Linked	0
↳ BillAddressCity	(BillAddressCity)	Linked	0
↳ BillAddressCountry	(BillAddressCountry)	Linked	0
↳ BillAddressPostalCode	(BillAddressPostalCode)	Linked	0
↳ BillAddressState	(BillAddressState)	Linked	0
↳ FullName	(FullName)	Linked	0
↳ ShipAddressAddr1	(ShipAddressAddr1)	Linked	0
↳ ShipAddressAddr2	(ShipAddressAddr2)	Linked	0
↳ ShipAddressAddr3	(ShipAddressAddr3)	Linked	0
↳ ShipAddressAddr4	(ShipAddressAddr4)	Linked	0
↳ ShipAddressAddr5	(ShipAddressAddr5)	Linked	0
↳ ShipAddressCity	(ShipAddressCity)	Linked	0
↳ ShipAddressCountry	(ShipAddressCountry)	Linked	0
↳ ShipAddressPostalCode	(ShipAddressPostalCode)	Linked	0
↳ ShipAddressState	(ShipAddressState)	Linked	0
EndDate		DateTime	0
Frequency	Frequency (FrequencyName)	Dropdown	0
IsActive		YesNo	0
IsAnonymousDonation		YesNo	0
IsInHonour		YesNo	0
IsInMemory		YesNo	0
LastDonationDate		DateTime	0
LastModifiedDate		DateTime	255
NextDonationDate		DateTime	0
PaymentDetailsRecordID	CustomerPaymentInfo (RecordID)	Dropdown	0
↳ PaymentDetailsLast4	(Last4)	Linked	0
↳ PaymentExpiry	(Expiry)	Linked	0
↳ PaymentType	(Type)	Linked	0
RecordID		Integer	0
StartDate		DateTime	0

DonationPlanLine Method Table


Amount		Money	0
Class		Text	255
Description		Text	255
DonationPlanRecordID	DonationPlan (RecordID)	Dropdown	0
Item	Item (FullName)	Dropdown	0
↳ SalesTaxCode	(Name)	Linked	0
LastModifiedDate		DateTime	255
Quantity		Decimal	0
Rate		Decimal	5
RecordID		Integer	0

DonorFlow Method Table


DefaultDepositToAccount	Account (FullName)	Dropdown	0
DefaultDonationAmount1		Money	0
DefaultDonationAmount2		Money	0
DefaultDonationAmount3		Money	0
DefaultDonationItem	Item (FullName)	Dropdown	0
DefaultDonationItemClassProgram	Class (FullName)	Dropdown	0
DefaultInternalNotificationEmail	EmailTemplate (Name)	Dropdown	0
DefaultReceiptTemplate	spiderReports (ReportName)	Dropdown	0
DefaultThankYouEmailTemplate	EmailTemplate (Name)	Dropdown	0
DonorPageBackgroundImage		Picture	0
FollowupActivityAssignedTo	Users (UserName)	Dropdown	0
FollowupActivityBodyText		Text	4000
FollowupActivityDefaultType	ActivityType (ActivityType)	Dropdown	0
FollowupActivityNumOfDays		Integer	0
FooterText		Text	5000
HeaderText		Text	5000
IsAnonymousDonationEnabled		YesNo	0
IsAutoNotCreateFollowUpActivity		YesNo	0
IsCoveringProcessingFeeByDefault		YesNo	0
IsDedicationEnabled		YesNo	0
IsIgnorePaymentProcessing		YesNo	0
IsNotAutomaticallySendReceipt		YesNo	0
IsNotAutomaticallySendThankYouEmail		YesNo	0
IsNotSendInternalEmailNotification		YesNo	0
IsOneTimeDonationEnabled		YesNo	0
IsProcessingFeeSeparateItem		YesNo	0
IsProvidingOptionToCoverProcessingFee		YesNo	0
IsRecurringEnabled		YesNo	0
IsShowItems		YesNo	0
IsShowPrograms		YesNo	0
LastModifiedDate		DateTime	255
PageTitle		Text	3000
ProcessingFeeItem	Item (FullName)	Dropdown	0
ProcessingFeePercentage		Decimal	2
RecordID		Integer	0
ThankYouPageMainText		Text	5000

DraftOrderRequestLine Method Table


Customer	Entity (RecordID)	Dropdown	0
Description		Text	255
EstimatedPrice		Money	0
EstimatedRate		Money	0
Item	Item (FullName)	Dropdown	0
LastModifiedDate		DateTime	255
Qty		Decimal	2
RecordID		Integer	0

EmailCampaignsMailingList Method Table


Campaign	Campaign (RecordID)	Dropdown	0
CampaignEmailOutboundStatus	CampaignEmailOutboundStatus (CampaignEmailOutboundStatus)	Dropdown	0
Contact	Contacts (RecordID)	Dropdown	0
↳ ContactBillingOptOut	(IsOptOutOfBilling)	Linked	0
↳ ContactEmail	(Email)	Linked	0
↳ ContactFirstName	(FirstName)	Linked	0
↳ ContactLastName	(LastName)	Linked	0
↳ ContactMarketingOptOut	(IsOptOutOfMarketing)	Linked	0
ContactEntity	Contacts (EntityRef)	Dropdown	0
LastModifiedDate		DateTime	255
RecordID		Integer	0

EmailTemplate Method Table


AssignedTo	Users (UserName)	Dropdown	-1
CreatedBy	Users (spdSecurityUserName)	Dropdown	-1
CreatedDate		DateTime	-1
EmailBCC		Text	1023
EmailBody		Text	32000
EmailBodyThumbnailImage		Picture	0
EmailCC		Text	1023
EmailFrom		Text	1023
EmailSenderRecordID	EmailSenders (RecordID)	Dropdown	0
EmailSubject		Text	1000
EmailTemplateCategory	EmailTemplateCategory (EmailTemplateCategory)	Dropdown	50
EmailTo		Text	1023
IsActive		YesNo	255
IsHidden		YesNo	255
IsMarketplaceTemplate		YesNo	0
IsPreventDeleteOrNameEdit		YesNo	255
LastModifiedBy	Users (spdSecurityUserName)	Dropdown	-1
LastModifiedDate		DateTime	255
MergeTableList		Text	1000
Name		Text	100
RecordID		Integer	0

EmailTemplateCategory Method Table


EmailTemplateCategory	Text	50
LastModifiedDate	DateTime	255
RecordID	Integer	-1

Employee QuickBooks Table


AccountNumber		Text	99
AccrualPeriodVacationName	EmployeeAccrualPeriodVacation (AccrualPeriodVacationName)	Dropdown	50
AltPhone		Text	21
AssignedTo	Users (UserName)	Dropdown	-1
BillAddressAttentionTo		Text	255
BirthDate		DateTime	0
Campaign	Campaign (Name)	Dropdown	-1
Class	Class (FullName)	Dropdown	0
ClearEarnings		YesNo	0
CreatedDate		DateTime	255
Currency	Currency (CurrencyCode)	Dropdown	0
CustomerHealthScore		Decimal	0
DirectDial		Text	80
EditSequence		Text	50
Email		Text	100
EmployeeAddressAddr1		Text	500
EmployeeAddressAddr2		Text	500
EmployeeAddressAddr3		Text	500
EmployeeAddressAddr4		Text	500
EmployeeAddressCity		Text	255
EmployeeAddressCountry		Text	255
EmployeeAddressPostalCode		Text	30
EmployeeAddressState		Text	255
EntityType		Text	20
Fax		Text	30
FirstName		Text	100
FullName		Text	450
Gender	EmployeeGender (GenderName)	Dropdown	0
HiredDate		DateTime	0
IsActive		YesNo	0
IsLeadStatusOnly		YesNo	0
IsTaxable		YesNo	0
LastCompletedActivity	Activity (RecordID)	Dropdown	0
↳ LastActivityCompletedDate	(ActualCompletedDate)	Linked	255
LastInvoiceRecordID	Invoice (RecordID)	Dropdown	0
↳ LastInvoiceRecordIDAmount	(Amount)	Linked	0
↳ LastInvoiceRecordIDTxnDate	(TxnDate)	Linked	0
LastModifiedDate		DateTime	255
LastName		Text	100
LastSalesReceiptRecordID	SalesReceipt (RecordID)	Dropdown	0
↳ LastSalesReceiptRecordIDTotalAmount	(TotalAmount)	Linked	0
↳ LastSalesReceiptRecordIDTxnDate	(TxnDate)	Linked	0
Latitude		Decimal	2
LeadConvertedDate		DateTime	255
LeadRating	LeadRating (LeadRating)	Dropdown	50
LeadSource	LeadSource (LeadSource)	Dropdown	-1
LeadStatus	LeadStatus (LeadStatus)	Dropdown	50
LifetimeValue		Decimal	2
ListID		Text	100
Longitude		Decimal	2
MiddleName		Text	100
Mobile		Text	21
Name		Text	450
NextPendingActivity	Activity (RecordID)	Dropdown	0
↳ NextActivityDueDate	(DueDateStart)	Linked	-1
Notes		Text	4095
OverdueARBalance		Money	255
OverduePayBalance		Money	255
Pager		Text	21
PagerPIN		Text	10
Paybalance		Money	255
PayPeriod	PayPeriod (PayPeriodName)	Dropdown	0
Phone		Text	21
PortalPassword		Text	10
PortalUserName		Text	10
PrintAs		Text	110
RecordID		Integer	0
ReleasedDate		DateTime	0
Salutation		Text	16
ShipAddressAttentionTo		Text	255
SickHoursAccrualPeriod	EmployeeAccrualPeriodSick (AccrualPeriodSickName)	Dropdown	50
SickHoursAccrualStartDate		DateTime	0
SickHoursIsResettingHoursEachNewYear		YesNo	0
SickHoursMaximumSeconds		Integer	0
SickHoursSecondsAccrued		Integer	0
SickHoursSecondsAvailable		Integer	0
SickHoursSecondsUsed		Integer	0
SkypeUserName		Text	32
SSN		Text	11
Suffix		Text	16
TaxExemptionReason	TaxExemptionReason (Reason)	Dropdown	0
TaxNumber		Text	50
TimeCreated		DateTime	0
TimeModifiedAccounting		DateTime	0
UseTimeDataToCreatePaychecks	EmployeeUseTimeDataToCreatePaychecks (UseTimeDataToCreatePaychecks)	Dropdown	0
VacationHoursAccrualStartDate		DateTime	0
VacationHoursIsResettingHoursEachNewYear		YesNo	0
VacationHoursMaximumSeconds		Integer	0
VacationHoursSecondsAccrued		Integer	0
VacationHoursSecondsAvailable		Integer	0
VacationHoursSecondsUsed		Integer	0

Entity QuickBooks Table


AltContact		Text	31
AltPhone		Text	30
AssignedTo	Users (UserName)	Dropdown	-1
Balance		Money	0
BillAddressAddr1		Text	500
BillAddressAddr2		Text	500
BillAddressAddr3		Text	500
BillAddressAddr4		Text	500
BillAddressAddr5		Text	500
BillAddressAttentionTo		Text	255
BillAddressCity		Text	255
BillAddressCountry		Text	255
BillAddressNote		Text	41
BillAddressPostalCode		Text	30
BillAddressState		Text	255
BirthDate		DateTime	0
Campaign	Campaign (Name)	Dropdown	-1
Class	Class (FullName)	Dropdown	0
ClearEarnings		YesNo	0
CompanyName		Text	100
CreatedDate		DateTime	255
CreditCardAddress		Text	41
CreditCardNumber		Text	25
CreditCardPostalCode		Text	41
CreditLimit		Decimal	0
Currency	Currency (CurrencyCode)	Dropdown	0
CustomerHealthScore		Decimal	0
CustomerType	CustomerType (FullName)	Dropdown	0
DeliveryMethod	DeliveryMethod (DeliveryMethodName)	Dropdown	50
DirectDial		Text	80
EditSequence		Text	50
Email		Text	100
EmployeeType	EmployeeType (Name)	Dropdown	50
EntityType		Text	20
ExpirationMonth		Integer	0
ExpirationYear		Integer	0
Fax		Text	30
FirstName		Text	100
FullName		Text	450
Gender	EmployeeGender (GenderName)	Dropdown	0
HiredDate		DateTime	0
IsActive		YesNo	0
IsLeadStatusOnly		YesNo	0
IsStatementWithParent		YesNo	0
IsTaxable		YesNo	0
IsVendorEligibleFor1099		YesNo	0
JobDesc		Text	99
JobEndDate		DateTime	0
JobProjectedEndDate		DateTime	0
JobStartDate		DateTime	0
JobStatus	JobStatus (JobStatus)	Dropdown	0
JobType	JobType (FullName)	Dropdown	0
LastCompletedActivity	Activity (RecordID)	Dropdown	0
↳ LastActivityCompletedDate	(ActualCompletedDate)	Linked	255
LastInvoiceRecordID	Invoice (RecordID)	Dropdown	0
↳ LastInvoiceRecordIDAmount	(Amount)	Linked	0
↳ LastInvoiceRecordIDTxnDate	(TxnDate)	Linked	0
LastModifiedDate		DateTime	255
LastName		Text	100
LastSalesReceiptRecordID	SalesReceipt (RecordID)	Dropdown	0
↳ LastSalesReceiptRecordIDTotalAmount	(TotalAmount)	Linked	0
↳ LastSalesReceiptRecordIDTxnDate	(TxnDate)	Linked	0
Latitude		Decimal	2
LeadConvertedDate		DateTime	255
LeadRating	LeadRating (LeadRating)	Dropdown	50
LeadSource	LeadSource (LeadSource)	Dropdown	-1
LeadStatus	LeadStatus (LeadStatus)	Dropdown	50
LifetimeValue		Decimal	2
ListID		Text	100
Longitude		Decimal	2
MergeOnNextSyncTo	Entity (FullName)	Dropdown	0
MiddleName		Text	100
Mobile		Text	30
Name		Text	450
NameOnCard		Text	41
NameOnCheck		Text	41
NextPendingActivity	Activity (RecordID)	Dropdown	0
↳ NextActivityDueDate	(DueDateStart)	Linked	-1
Notes		Text	4000
OverdueARBalance		Money	255
OverduePayBalance		Money	255
Pager		Text	21
PagerPIN		Text	10
ParentFullName	Entity (FullName)	Dropdown	0
PayPeriod	PayPeriod (PayPeriodName)	Dropdown	0
Phone		Text	30
PortalPassword		Text	10
PortalUserName		Text	10
PreferredPaymentMethod	PaymentMethod (Name)	Dropdown	0
PriceLevel	PriceLevel (Name)	Dropdown	0
PrintAs		Text	110
RecordID		Integer	0
ReleasedDate		DateTime	0
ResaleNumber		Text	16
SalesRep	SalesRep (Initial)	Dropdown	5
↳ SalesRepRecordID	(RecordID)	Linked	0
SalesTaxCode	SalesTaxCode (Name)	Dropdown	0
SalesTaxCountry		Text	50
SalesTaxItem	Item (FullName)	Dropdown	0
Salutation		Text	16
ShipAddressAddr1		Text	500
ShipAddressAddr2		Text	500
ShipAddressAddr3		Text	500
ShipAddressAddr4		Text	500
ShipAddressAddr5		Text	500
ShipAddressAttentionTo		Text	255
ShipAddressCity		Text	255
ShipAddressCountry		Text	255
ShipAddressNote		Text	41
ShipAddressPostalCode		Text	30
ShipAddressState		Text	255
SickHoursAccrualPeriod	EmployeeAccrualPeriodSick (AccrualPeriodSickName)	Dropdown	50
SickHoursAccrualStartDate		DateTime	0
SickHoursIsResettingHoursEachNewYear		YesNo	0
SickHoursMaximumSeconds		Integer	0
SickHoursSecondsAccrued		Integer	0
SickHoursSecondsAvailable		Integer	0
SickHoursSecondsUsed		Integer	0
SSN		Text	11
Sublevel		Integer	0
Suffix		Text	16
TaxExemptionReason	TaxExemptionReason (Reason)	Dropdown	0
Terms	Terms (Name)	Dropdown	100
TimeCreated		DateTime	0
TimeModifiedAccounting		DateTime	0
TotalBalance		Money	0
UseTimeDataToCreatePaychecks	EmployeeUseTimeDataToCreatePaychecks (UseTimeDataToCreatePaychecks)	Dropdown	0
VacationHoursAccrualStartDate		DateTime	0
VacationHoursIsResettingHoursEachNewYear		YesNo	0
VacationHoursMaximumSeconds		Integer	0
VacationHoursSecondsAccrued		Integer	0
VacationHoursSecondsAvailable		Integer	0
VacationHoursSecondsUsed		Integer	0
VendorTaxIdent		Text	10
VendorType	VendorType (FullName)	Dropdown	0

Estimate QuickBooks Table


AcceptedBy		Text	50
AcceptedDate		DateTime	0
Activity	Activity (RecordID)	Dropdown	-1
AssignedTo	Users (UserName)	Dropdown	-1
BillAddressAddr1		Text	500
BillAddressAddr2		Text	500
BillAddressAddr3		Text	500
BillAddressAddr4		Text	500
BillAddressAddr5		Text	500
BillAddressCity		Text	255
BillAddressCountry		Text	255
BillAddressNote		Text	41
BillAddressPostalCode		Text	30
BillAddressState		Text	255
BillEmail		Text	100
Campaign	Campaign (Name)	Dropdown	-1
Class	Class (FullName)	Dropdown	1000
Currency	Currency (CurrencyCode)	Dropdown	0
↳ CurrencySymbol	(CurrencySymbol)	Linked	10
Customer	Entity (FullName)	Dropdown	1000
CustomerMessage	CustomerMsg (Name)	Dropdown	0
CustomerMsgText		Text	1000
CustomerSalesTaxCode	SalesTaxCode (Name)	Dropdown	3
DepositAmount		Money	0
DiscountAmt		Decimal	0
DiscountRate		Decimal	0
DiscountTaxable		YesNo	0
DueDate		DateTime	0
EditSequence		Text	50
EstimateStatus	EstimateStatus (Name)	Dropdown	8
EstimateSummary		Text	3000
ExchangeRate		Decimal	0
ExpirationDate		DateTime	0
FOB		Text	13
hiddenInternalCUSTOMFIELD1		Text	31
hiddenInternalCUSTOMFIELD10		Text	31
hiddenInternalCUSTOMFIELD11		Text	31
hiddenInternalCUSTOMFIELD12		Text	31
hiddenInternalCUSTOMFIELD13		Text	31
hiddenInternalCUSTOMFIELD14		Text	31
hiddenInternalCUSTOMFIELD15		Text	31
hiddenInternalCUSTOMFIELD16		Text	31
hiddenInternalCUSTOMFIELD17		Text	31
hiddenInternalCUSTOMFIELD18		Text	31
hiddenInternalCUSTOMFIELD19		Text	31
hiddenInternalCUSTOMFIELD2		Text	31
hiddenInternalCUSTOMFIELD20		Text	31
hiddenInternalCUSTOMFIELD21		Text	31
hiddenInternalCUSTOMFIELD22		Text	31
hiddenInternalCUSTOMFIELD23		Text	31
hiddenInternalCUSTOMFIELD24		Text	31
hiddenInternalCUSTOMFIELD25		Text	31
hiddenInternalCUSTOMFIELD26		Text	31
hiddenInternalCUSTOMFIELD27		Text	31
hiddenInternalCUSTOMFIELD28		Text	31
hiddenInternalCUSTOMFIELD29		Text	31
hiddenInternalCUSTOMFIELD3		Text	31
hiddenInternalCUSTOMFIELD30		Text	31
hiddenInternalCUSTOMFIELD4		Text	31
hiddenInternalCUSTOMFIELD5		Text	31
hiddenInternalCUSTOMFIELD6		Text	31
hiddenInternalCUSTOMFIELD7		Text	31
hiddenInternalCUSTOMFIELD8		Text	31
hiddenInternalCUSTOMFIELD9		Text	31
IsActive		YesNo	0
IsDepositPercent		YesNo	0
IsTaxIncluded		YesNo	0
IsToBeEmailed		YesNo	0
IsToBePrinted		YesNo	0
IsWaitingForSyncApproval		YesNo	0
Job	Jobs (RecordID)	Dropdown	0
LastModifiedDate		DateTime	255
Location	InventoryControlLocation (FullName)	Dropdown	0
Memo		Text	4000
Opportunity	Opportunity (RecordID)	Dropdown	-1
PONumber		Text	25
RecordID		Integer	0
RefNumber		Text	21
SalesRep	SalesRep (Initial)	Dropdown	0
SalesTaxPercentage		Decimal	0
SalesTaxTotal		Money	0
ShipAddressAddr1		Text	500
ShipAddressAddr2		Text	500
ShipAddressAddr3		Text	500
ShipAddressAddr4		Text	500
ShipAddressAddr5		Text	500
ShipAddressCity		Text	255
ShipAddressCountry		Text	255
ShipAddressNote		Text	41
ShipAddressPostalCode		Text	30
ShipAddressState		Text	25
ShippingAmt		Decimal	0
Subtotal		Money	0
TagList		Text	4000
TaxCalculation	TaxCalculationType (Name)	Dropdown	0
Terms	Terms (Name)	Dropdown	100
TimeCreated		DateTime	0
TimeModifiedAccounting		DateTime	0
TotalAmount		Money	0
TotalAmountInHomeCurrency		Decimal	0
TxnDate		DateTime	0
TxnID		Text	100
TxnMethodFlag		Text	31
TxnNumber		Integer	0

EstimateLine QuickBooks Table


Amount		Money	0
AmountInclusive		Money	100
Class	Class (FullName)	Dropdown	159
Desc		Text	4000
EstimateLineGroupRecordID	EstimateLine (RecordID)	Dropdown	0
EstimateRecordID	Estimate (RecordID)	Dropdown	0
↳ EstimateAssignedToRecordID	(AssignedTo_RecordID)	Linked	0
↳ EstimateCustomerRecordID	(Customer_RecordID)	Linked	0
↳ EstimateIsActive	(IsActive)	Linked	0
↳ EstimateSalesRepRecordID	(SalesRep_RecordID)	Linked	0
↳ EstimateStatusRecordID	(EstimateStatus_RecordID)	Linked	0
↳ EstimateTaxCalculation	(TaxCalculation)	Linked	0
↳ EstimateTxnDate	(TxnDate)	Linked	0
hiddenInternalCUSTOMFIELD1		Text	31
hiddenInternalCUSTOMFIELD10		Text	31
hiddenInternalCUSTOMFIELD11		Text	31
hiddenInternalCUSTOMFIELD12		Text	31
hiddenInternalCUSTOMFIELD13		Text	31
hiddenInternalCUSTOMFIELD14		Text	31
hiddenInternalCUSTOMFIELD15		Text	31
hiddenInternalCUSTOMFIELD16		Text	31
hiddenInternalCUSTOMFIELD17		Text	31
hiddenInternalCUSTOMFIELD18		Text	31
hiddenInternalCUSTOMFIELD19		Text	31
hiddenInternalCUSTOMFIELD2		Text	31
hiddenInternalCUSTOMFIELD20		Text	31
hiddenInternalCUSTOMFIELD21		Text	31
hiddenInternalCUSTOMFIELD22		Text	31
hiddenInternalCUSTOMFIELD23		Text	31
hiddenInternalCUSTOMFIELD24		Text	31
hiddenInternalCUSTOMFIELD25		Text	31
hiddenInternalCUSTOMFIELD26		Text	31
hiddenInternalCUSTOMFIELD27		Text	31
hiddenInternalCUSTOMFIELD28		Text	31
hiddenInternalCUSTOMFIELD29		Text	31
hiddenInternalCUSTOMFIELD3		Text	31
hiddenInternalCUSTOMFIELD30		Text	31
hiddenInternalCUSTOMFIELD4		Text	31
hiddenInternalCUSTOMFIELD5		Text	31
hiddenInternalCUSTOMFIELD6		Text	31
hiddenInternalCUSTOMFIELD7		Text	31
hiddenInternalCUSTOMFIELD8		Text	31
hiddenInternalCUSTOMFIELD9		Text	31
IncomeAccount	Account (FullName)	Dropdown	10
IsMarkupPercent		YesNo	0
IsPrintItemsInGroup		YesNo	0
IsRatePercent		YesNo	0
Item	Item (FullName)	Dropdown	159
↳ ItemIsActive	(IsActive)	Linked	0
↳ ItemIsUsedOnPurchaseTransaction	(IsUsedOnPurchaseTransaction)	Linked	0
↳ ItemPrefVendor	(FullName)	Linked	0
↳ ItemType	(ItemType)	Linked	0
LastModifiedDate		DateTime	255
LineOrder		Integer	0
Other1		Text	29
Other2		Text	29
Quantity		Decimal	0
Rate		Decimal	5
RateInclusive		Decimal	100
RecordID		Integer	0
SalesTaxCode	SalesTaxCode (Name)	Dropdown	3
TaxClassificationRef		Integer	0
TotalAmount		Money	0
TxnLineID		Text	100
TxnMethodFlag		Text	31
UnitOfMeasure		Text	31

EstimateStatus QuickBooks Table


LastModifiedDate	DateTime	255
Name	Text	10
RecordID	Integer	0

ExchangeRate QuickBooks Table


AsOfDate	DateTime	255
EditSequence	Text	20
ListID	Text	100
Rate	Decimal	5
RecordID	Integer	0
SourceCurrencyCode	Text	5
TargetCurrencyCode	Text	5
TimeCreated	DateTime	0

Frequency Method Table


FrequencyMonths	Integer	0
FrequencyName	Text	50
LastModifiedDate	DateTime	255
RecordID	Integer	0

GPSDevice Method Table


DeviceID	Text	100
DeviceName	Text	200
LastDateTime	DateTime	0
LastLatitude	Text	30
LastLongitude	Text	30
LastModifiedDate	DateTime	255
RecordID	Integer	0

GPSLog Method Table


DateTimeLogged		DateTime	0
DeviceID	GPSDevice (DeviceName)	Dropdown	0
LastModifiedDate		DateTime	255
LatitudeLogged		Text	30
LongitudeLogged		Text	30
RecordID		Integer	0

GPSRoute Method Table


Address		Text	100
AddressCity		Text	30
AddressName		Text	100
AddressStreetNumber		Text	10
AddressZipCode		Text	10
DeviceID	GPSDevice (DeviceName)	Dropdown	0
LastModifiedDate		DateTime	255
Latitude		Text	30
Longitude		Text	30
Note		Text	4000
RecordID		Integer	0
RouteDate		DateTime	0

GuestAcceptProposalLog Method Table


LastModifiedDate		DateTime	255
ProposalRecordID	Proposal (RecordID)	Dropdown	0
RecordID		Integer	0
ViewedDate		DateTime	0

ImportLog Method Table


ImportDate	DateTime	-1
ImportID	Text	50
ImportUser	Text	50
LastModifiedDate	DateTime	255
RecordID	Integer	-1
RecordIDRef	Integer	0
Table	Text	100

InternalJobStatus Method Table


InternalJobStatus	Text	255
LastModifiedDate	DateTime	255
RecordID	Integer	-1

InternalJobType Method Table


JobType	Text	255
LastModifiedDate	DateTime	255
RecordID	Integer	-1

InternalNotes Method Table


ActivityRecordID	Activity (RecordID)	Dropdown	0
AssignedTo	Users (UserName)	Dropdown	0
CreatedBy	Users (spdSecurityUserName)	Dropdown	0
CreatedDate		DateTime	0
LastModifiedDate		DateTime	255
Note		Text	32000
RecordID		Integer	0

InvInventory Method Table


CreatedAt		DateTime	-1
Item	Item (RecordID)	Dropdown	0
LastModifiedDate		DateTime	255
Location	InvLocation (RecordID)	Dropdown	0
↳ LocationName	(Name)	Linked	0
QuantityCommitted		Decimal	0
QuantityExpected		Decimal	0
QuantityInStock		Decimal	0
RecordID		Integer	-1
SafetyStockLevel		Decimal	0
UpdatedAt		DateTime	-1

InvInvoiceLineInventoryMapping Method Table


CreatedAt		DateTime	-1
InvoiceLine	InvoiceLine (RecordID)	Dropdown	0
LastModifiedDate		DateTime	255
Location	InvLocation (RecordID)	Dropdown	0
RecordID		Integer	-1
UpdatedAt		DateTime	-1

InvLocation Method Table


City	Text	510
Country	Text	510
CreatedAt	DateTime	-1
DeletedAt	DateTime	-1
invLocationAddr1	Text	1000
invLocationAddr2	Text	1000
invLocationAddr3	Text	1000
invLocationAddr4	Text	1000
invLocationAddr5	Text	1000
invLocationState	Text	510
IsAllowedOnPurchaseTransactions	YesNo	-1
IsAllowedOnSalesTransactions	YesNo	-1
IsPrimaryWarehouse	YesNo	-1
LastModifiedDate	DateTime	255
Name	Text	1000
PostalCode	Text	60
RecordID	Integer	-1
Status	Integer	-1
UpdatedAt	DateTime	-1

InvPurchaseOrderLineInventoryMapping Method Table


CreatedAt		DateTime	-1
LastModifiedDate		DateTime	255
Location	InvLocation (RecordID)	Dropdown	0
PurchaseOrderLine	PurchaseOrderLine (RecordID)	Dropdown	0
RecordID		Integer	-1
UpdatedAt		DateTime	-1

InvSalesOrderLineInventoryMapping Method Table


CreatedAt		DateTime	-1
LastModifiedDate		DateTime	255
Location	InvLocation (RecordID)	Dropdown	0
RecordID		Integer	-1
SalesOrderLine	SalesOrderLine (RecordID)	Dropdown	0
UpdatedAt		DateTime	-1

InvSalesReceiptLineInventoryMapping Method Table


CreatedAt		DateTime	-1
LastModifiedDate		DateTime	255
Location	InvLocation (RecordID)	Dropdown	0
RecordID		Integer	-1
SalesReceiptLine	SalesReceiptLine (RecordID)	Dropdown	0
UpdatedAt		DateTime	-1

InvStockAdjustment Method Table


CreatedAt		DateTime	-1
LastModifiedDate		DateTime	255
Location	InvLocation (RecordID)	Dropdown	0
↳ LocationName	(Name)	Linked	0
RecordID		Integer	-1
StockAdjustmentDate		DateTime	-1
StockAdjustmentReason		Text	-1
StockAdjustmentRefNumber		Text	500
UpdatedAt		DateTime	-1

InvStockAdjustmentLine Method Table


CreatedAt		DateTime	-1
Item	Item (RecordID)	Dropdown	0
↳ ItemFullName	(FullName)	Linked	0
LastModifiedDate		DateTime	255
Quantity		Decimal	0
RecordID		Integer	-1
StockAdjustment	InvStockAdjustment (RecordID)	Dropdown	0
↳ StockAdjustmentLocationName	(LocationName)	Linked	0
↳ StockAdjustmentStockAdjustmentDate	(StockAdjustmentDate)	Linked	0
↳ StockAdjustmentStockAdjustmentReason	(StockAdjustmentReason)	Linked	0
UpdatedAt		DateTime	-1

InvStorageBin Method Table


BinName		Text	255
CreatedAt		DateTime	-1
IsActive		YesNo	-1
LastModifiedDate		DateTime	255
Location	InvLocation (RecordID)	Dropdown	0
RecordID		Integer	-1
UpdatedAt		DateTime	-1

InventoryAdjustment QuickBooks Table


Account	Account (FullName)	Dropdown	159
Class	Class (FullName)	Dropdown	159
Customer	Entity (FullName)	Dropdown	209
EditSequence		Text	50
IsWaitingForSyncApproval		YesNo	0
LastModifiedDate		DateTime	255
Location	InventoryControlLocation (FullName)	Dropdown	-1
↳ LocationRoot	(RootName)	Linked	255
Memo		Text	4000
RecordID		Integer	0
RefNumber		Text	21
TimeCreated		DateTime	0
TimeModifiedAccounting		DateTime	0
TxnDate		DateTime	0
TxnID		Text	100
TxnMethodFlag		Text	31
TxnNumber		Integer	0

InventoryAdjustmentLine QuickBooks Table


InventoryAdjustmentRecordID	InventoryAdjustment (RecordID)	Dropdown	0
Item	Item (FullName)	Dropdown	159
LastModifiedDate		DateTime	255
NewQuantity		Decimal	0
NewValue		Money	0
QuanityOnTransferOrder		Decimal	0
QuantityDifference		Decimal	0
RecordID		Integer	0
TxnLineID		Text	100
ValueDifference		Money	0

InventoryControlAutoBinSelection Method Table


LastModifiedDate	DateTime	255
Name	Text	50
RecordID	Integer	0

InventoryControlBin Method Table


Area	InventoryControlLocationGroup (Name)	Dropdown	-1
BinDate		DateTime	255
CreatedBy	Users (UserName)	Dropdown	-1
CreatedDate		DateTime	255
Description		Text	255
ExpiryDate		DateTime	255
InventoryControlBinType	InventoryControlBinType (Name)	Dropdown	-1
↳ IsCountedTowardQuantityOnHand	(IsCountedTowardQuantityOnHand)	Linked	255
InventoryControlLocation	InventoryControlLocation (FullName)	Dropdown	-1
↳ InventoryControlLocationRoot	(RootName)	Linked	255
Item	Item (FullName)	Dropdown	-1
LastModifiedBy	Users (spdSecurityUserName)	Dropdown	-1
LastModifiedDate		DateTime	255
LotNumber		Text	255
Name		Text	2054
Quantity		Decimal	2
RecordID		Integer	0
RevisionLevel		Text	255

InventoryControlBinSerial Method Table


Cost		Money	0
CreatedBy	Users (UserName)	Dropdown	-1
CreatedDate		DateTime	255
Description		Text	255
InventoryControlBin	InventoryControlBin (Name)	Dropdown	-1
↳ BinItem	(Item)	Linked	0
LastModifiedBy	Users (spdSecurityUserName)	Dropdown	-1
LastModifiedDate		DateTime	255
RecordID		Integer	0
SerialNumber		Text	255

InventoryControlBinType Method Table


Caption	Text	50
IsCountedTowardQuantityOnHand	YesNo	255
LastModifiedDate	DateTime	255
Name	Text	50
RecordID	Integer	0

InventoryControlLocation Method Table


Contact		Text	41
CreatedBy	Users (UserName)	Dropdown	-1
CreatedDate		DateTime	255
Description		Text	255
EditSequence		Text	100
Email		Text	1023
Fax		Text	21
FullName		Text	1000
InventoryControlLocationGroup	InventoryControlLocationGroup (Name)	Dropdown	-1
IsActive		YesNo	0
IsDefault		YesNo	255
LastModifiedBy	Users (spdSecurityUserName)	Dropdown	-1
LastModifiedDate		DateTime	255
ListID		Text	100
Name		Text	255
ParentFullName	InventoryControlLocation (FullName)	Dropdown	0
Phone		Text	21
RecordID		Integer	0
RootName		Text	255
SiteAddressAddr1		Text	41
SiteAddressAddr2		Text	41
SiteAddressAddr3		Text	41
SiteAddressAddr4		Text	41
SiteAddressAddr5		Text	41
SiteAddressCity		Text	31
SiteAddressCountry		Text	31
SiteAddressPostalCode		Text	13
SiteAddressState		Text	21
Sublevel		Integer	0
TimeCreated		DateTime	0
TimeModifiedAccounting		DateTime	0

InventoryControlLocationGroup Method Table


CreatedBy	Users (UserName)	Dropdown	-1
CreatedDate		DateTime	255
Description		Text	255
LastModifiedBy	Users (spdSecurityUserName)	Dropdown	-1
LastModifiedDate		DateTime	255
Location	InventoryControlLocation (FullName)	Dropdown	-1
Name		Text	50
RecordID		Integer	0

InventoryControlMonitor Method Table


AlertLevel		Decimal	5
CriticalLevel		Decimal	5
CurrentOnHand		Decimal	5
Item	Item (FullName)	Dropdown	-1
↳ ItemType	(ItemType)	Linked	20
↳ PurchaseDesc	(PurchaseDesc)	Linked	4095
LastModifiedDate		DateTime	255
Location	InventoryControlLocation (FullName)	Dropdown	-1
↳ LocationRoot	(RootName)	Linked	255
MonitorLevel		Text	20
RecordID		Integer	0
ReplenishLevel		Decimal	5

InventoryControlTransferOrder Method Table


BinFrom	InventoryControlBin (Name)	Dropdown	-1
BinFromPrevious	InventoryControlBin (Name)	Dropdown	-1
BinSerial	InventoryControlBinSerial (SerialNumber)	Dropdown	-1
BinTo	InventoryControlBin (Name)	Dropdown	-1
BinToPrevious	InventoryControlBin (Name)	Dropdown	-1
Cost		Money	0
CreatedBy	Users (UserName)	Dropdown	-1
CreatedDate		DateTime	255
Description		Text	255
IsPending		YesNo	0
IsWaitingToBePicked		YesNo	255
LastModifiedBy	Users (spdSecurityUserName)	Dropdown	-1
LastModifiedDate		DateTime	255
Quantity		Decimal	2
RecordID		Integer	0
TxnDate		DateTime	255
TxnDetailRecordID		Integer	255
TxnID		Text	100
TxnLineID		Text	100
TxnRecordID		Integer	255
TxnType		Text	50

Invoice QuickBooks Table


Amount		Money	0
AppliedAmount		Money	0
ARAccount	Account (FullName)	Dropdown	31
AssignedTo	Users (UserName)	Dropdown	-1
BalanceRemaining		Money	0
BalanceRemainingInHomeCurrency		Decimal	0
BillAddressAddr1		Text	500
BillAddressAddr2		Text	500
BillAddressAddr3		Text	500
BillAddressAddr4		Text	500
BillAddressAddr5		Text	500
BillAddressCity		Text	255
BillAddressCountry		Text	255
BillAddressNote		Text	41
BillAddressPostalCode		Text	30
BillAddressState		Text	255
BillEmail		Text	100
Campaign	Campaign (Name)	Dropdown	-1
Cards		YesNo	0
Class	Class (FullName)	Dropdown	1000
Currency	Currency (CurrencyCode)	Dropdown	0
↳ CurrencySymbol	(CurrencySymbol)	Linked	10
Customer	Entity (FullName)	Dropdown	1000
CustomerMessage	CustomerMsg (Name)	Dropdown	0
CustomerMsgText		Text	1000
CustomerSalesTaxCode	SalesTaxCode (Name)	Dropdown	3
DepositToAccount	Account (FullName)	Dropdown	0
DiscountAmt		Decimal	0
DiscountRate		Decimal	0
DiscountTaxable		YesNo	0
DueDate		DateTime	0
Estimate	Estimate (RecordID)	Dropdown	0
EstimateRecordID	Estimate (RecordID)	Dropdown	0
ExchangeRate		Decimal	0
FOB		Text	13
FreeBankTransfer		YesNo	0
hiddenInternalCUSTOMFIELD1		Text	31
hiddenInternalCUSTOMFIELD10		Text	31
hiddenInternalCUSTOMFIELD11		Text	31
hiddenInternalCUSTOMFIELD12		Text	31
hiddenInternalCUSTOMFIELD13		Text	31
hiddenInternalCUSTOMFIELD14		Text	31
hiddenInternalCUSTOMFIELD15		Text	31
hiddenInternalCUSTOMFIELD16		Text	31
hiddenInternalCUSTOMFIELD17		Text	31
hiddenInternalCUSTOMFIELD18		Text	31
hiddenInternalCUSTOMFIELD19		Text	31
hiddenInternalCUSTOMFIELD2		Text	31
hiddenInternalCUSTOMFIELD20		Text	31
hiddenInternalCUSTOMFIELD21		Text	31
hiddenInternalCUSTOMFIELD22		Text	31
hiddenInternalCUSTOMFIELD23		Text	31
hiddenInternalCUSTOMFIELD24		Text	31
hiddenInternalCUSTOMFIELD25		Text	31
hiddenInternalCUSTOMFIELD26		Text	31
hiddenInternalCUSTOMFIELD27		Text	31
hiddenInternalCUSTOMFIELD28		Text	31
hiddenInternalCUSTOMFIELD29		Text	31
hiddenInternalCUSTOMFIELD3		Text	31
hiddenInternalCUSTOMFIELD30		Text	31
hiddenInternalCUSTOMFIELD4		Text	31
hiddenInternalCUSTOMFIELD5		Text	31
hiddenInternalCUSTOMFIELD6		Text	31
hiddenInternalCUSTOMFIELD7		Text	31
hiddenInternalCUSTOMFIELD8		Text	31
hiddenInternalCUSTOMFIELD9		Text	31
InvoiceState	InvoiceState (InvoiceState)	Dropdown	0
IsPaid		YesNo	0
IsTaxIncluded		YesNo	0
IsToBeEmailed		YesNo	0
IsToBePrinted		YesNo	0
IsWaitingForSyncApproval		YesNo	0
Job	Jobs (RecordID)	Dropdown	0
LastModifiedDate		DateTime	255
Location	InventoryControlLocation (FullName)	Dropdown	-1
↳ LocationRoot	(RootName)	Linked	255
Memo		Text	4000
Opportunity	Opportunity (RecordID)	Dropdown	-1
Other		Text	29
PONumber		Text	25
ProposalRecordID	Proposal (RecordID)	Dropdown	0
RecordID		Integer	0
RefNumber		Text	21
SalesTaxPercentage		Decimal	0
SalesTaxTotal		Money	0
ShipAddressAddr1		Text	500
ShipAddressAddr2		Text	500
ShipAddressAddr3		Text	500
ShipAddressAddr4		Text	500
ShipAddressAddr5		Text	500
ShipAddressCity		Text	255
ShipAddressCountry		Text	255
ShipAddressNote		Text	41
ShipAddressPostalCode		Text	30
ShipAddressState		Text	255
ShipDate		DateTime	0
ShipMethodName		Text	100
ShippingAmt		Decimal	0
ShipTrackingNumber		Text	31
Subtotal		Money	0
TagList		Text	4000
TaxCalculation	TaxCalculationType (Name)	Dropdown	0
Terms	Terms (Name)	Dropdown	100
TimeCreated		DateTime	0
TimeModifiedAccounting		DateTime	0
TotalAmountInHomeCurrency		Decimal	0
TxnDate		DateTime	0
TxnID		Text	100
TxnMethodFlag		Text	31
TxnNumber		Integer	0

InvoiceLine QuickBooks Table


Amount		Money	0
AmountInclusive		Money	100
Class	Class (FullName)	Dropdown	159
Desc		Text	4000
hiddenInternalCUSTOMFIELD1		Text	31
hiddenInternalCUSTOMFIELD10		Text	31
hiddenInternalCUSTOMFIELD11		Text	31
hiddenInternalCUSTOMFIELD12		Text	31
hiddenInternalCUSTOMFIELD13		Text	31
hiddenInternalCUSTOMFIELD14		Text	31
hiddenInternalCUSTOMFIELD15		Text	31
hiddenInternalCUSTOMFIELD16		Text	31
hiddenInternalCUSTOMFIELD17		Text	31
hiddenInternalCUSTOMFIELD18		Text	31
hiddenInternalCUSTOMFIELD19		Text	31
hiddenInternalCUSTOMFIELD2		Text	31
hiddenInternalCUSTOMFIELD20		Text	31
hiddenInternalCUSTOMFIELD21		Text	31
hiddenInternalCUSTOMFIELD22		Text	31
hiddenInternalCUSTOMFIELD23		Text	31
hiddenInternalCUSTOMFIELD24		Text	31
hiddenInternalCUSTOMFIELD25		Text	31
hiddenInternalCUSTOMFIELD26		Text	31
hiddenInternalCUSTOMFIELD27		Text	31
hiddenInternalCUSTOMFIELD28		Text	31
hiddenInternalCUSTOMFIELD29		Text	31
hiddenInternalCUSTOMFIELD3		Text	31
hiddenInternalCUSTOMFIELD30		Text	31
hiddenInternalCUSTOMFIELD4		Text	31
hiddenInternalCUSTOMFIELD5		Text	31
hiddenInternalCUSTOMFIELD6		Text	31
hiddenInternalCUSTOMFIELD7		Text	31
hiddenInternalCUSTOMFIELD8		Text	31
hiddenInternalCUSTOMFIELD9		Text	31
IncomeAccount	Account (FullName)	Dropdown	10
InvoiceLineGroupRecordID	InvoiceLine (RecordID)	Dropdown	0
InvoiceRecordID	Invoice (RecordID)	Dropdown	0
↳ InvoiceAmount	(Amount)	Linked	0
↳ InvoiceAssignedToRecordID	(AssignedTo_RecordID)	Linked	0
↳ InvoiceBalanceRemaining	(BalanceRemaining)	Linked	0
↳ InvoiceCustomerRecordID	(Customer_RecordID)	Linked	0
↳ InvoiceDueDate	(DueDate)	Linked	0
↳ InvoiceSalesRepRecordID	(SalesRep_RecordID)	Linked	0
↳ InvoiceTaxCalculation	(TaxCalculation)	Linked	0
↳ InvoiceTxnDate	(TxnDate)	Linked	0
IsPrintItemsInGroup		YesNo	0
IsRatePercent		YesNo	0
Item	Item (FullName)	Dropdown	159
↳ ItemIsActive	(IsActive)	Linked	0
↳ ItemIsUsedOnPurchaseTransaction	(IsUsedOnPurchaseTransaction)	Linked	0
↳ ItemPrefVendor	(FullName)	Linked	0
↳ ItemType	(ItemType)	Linked	0
LastModifiedDate		DateTime	255
LineOrder		Integer	0
LinkToSalesOrder	SalesOrderLine (RecordID)	Dropdown	0
LocationBin	InventoryControlLocation (FullName)	Dropdown	-1
LocationSite	InventoryControlLocation (FullName)	Dropdown	-1
LotNumber		Text	40
Other1		Text	29
Other2		Text	29
QuanityOnTransferOrder		Decimal	0
Quantity		Decimal	0
Rate		Decimal	5
RateInclusive		Decimal	100
RecordID		Integer	0
SalesTaxCode	SalesTaxCode (Name)	Dropdown	3
SerialNumber		Text	4095
ServiceDate		DateTime	0
TaxClassificationRef		Integer	0
TotalAmount		Money	0
TxnLineID		Text	100
TxnMethodFlag		Text	31
UnitOfMeasure		Text	31

InvoiceState Method Table


InvoiceState		Text	255
InvoiceStateType	InvoiceStateType (InvoiceStateType)	Dropdown	0
LastModifiedDate		DateTime	255
RecordID		Integer	-1

InvoiceStateType Method Table


InvoiceStateType	Text	255
LastModifiedDate	DateTime	255
RecordID	Integer	-1

InvoiceStatus Method Table


Description	Text	50
InvoiceStatusName	Text	10
LastModifiedDate	DateTime	255
RecordID	Integer	0

Item QuickBooks Table


AlertLevel		Decimal	255
AssetAccount	Account (FullName)	Dropdown	1000
AverageCost		Money	0
COGSAccount	Account (FullName)	Dropdown	1000
CriticalLevel		Decimal	255
EditSequence		Text	50
EstHrs		Decimal	2
FullName		Text	1000
hiddenInternalCUSTOMFIELD1		Text	31
hiddenInternalCUSTOMFIELD10		Text	31
hiddenInternalCUSTOMFIELD11		Text	31
hiddenInternalCUSTOMFIELD12		Text	31
hiddenInternalCUSTOMFIELD13		Text	31
hiddenInternalCUSTOMFIELD14		Text	31
hiddenInternalCUSTOMFIELD15		Text	31
hiddenInternalCUSTOMFIELD16		Text	31
hiddenInternalCUSTOMFIELD17		Text	31
hiddenInternalCUSTOMFIELD18		Text	31
hiddenInternalCUSTOMFIELD19		Text	31
hiddenInternalCUSTOMFIELD2		Text	31
hiddenInternalCUSTOMFIELD20		Text	31
hiddenInternalCUSTOMFIELD21		Text	31
hiddenInternalCUSTOMFIELD22		Text	31
hiddenInternalCUSTOMFIELD23		Text	31
hiddenInternalCUSTOMFIELD24		Text	31
hiddenInternalCUSTOMFIELD25		Text	31
hiddenInternalCUSTOMFIELD26		Text	31
hiddenInternalCUSTOMFIELD27		Text	31
hiddenInternalCUSTOMFIELD28		Text	31
hiddenInternalCUSTOMFIELD29		Text	31
hiddenInternalCUSTOMFIELD3		Text	31
hiddenInternalCUSTOMFIELD30		Text	31
hiddenInternalCUSTOMFIELD4		Text	31
hiddenInternalCUSTOMFIELD5		Text	31
hiddenInternalCUSTOMFIELD6		Text	31
hiddenInternalCUSTOMFIELD7		Text	31
hiddenInternalCUSTOMFIELD8		Text	31
hiddenInternalCUSTOMFIELD9		Text	31
IncomeAccount	Account (FullName)	Dropdown	1000
InventoryControlAutoBinSelection	InventoryControlAutoBinSelection (Name)	Dropdown	-1
InvStartDate		DateTime	0
IsActive		YesNo	0
IsAvailableForReorder		YesNo	0
IsNotNPDonation		YesNo	0
IsPricePercent		YesNo	0
IsPrintItemsInGroup		YesNo	0
IsSalesAndPurchase		YesNo	0
IsSerialTrackingRequired		YesNo	255
IsTaxIncluded		YesNo	0
IsTrackQtyOnHand		YesNo	0
IsUsedOnPurchaseTransaction		YesNo	0
IsUsedOnSalesTransaction		YesNo	0
ItemHeight		Decimal	2
ItemLength		Decimal	2
ItemType		Text	20
ItemWeight		Decimal	2
ItemWidth		Decimal	2
LastModifiedDate		DateTime	255
LeadTime		Text	255
LeadTimeFixed		Decimal	2
ListID		Text	100
LotSizeMinimum		Decimal	2
LotSizeMultiple		Decimal	2
LowLevelCode		Text	255
ManufacturerPartNumber		Text	31
MFGLeadTimeUOM	MFGLeadTimeUOM (LeadTimeUOM)	Dropdown	50
MonitorLevel		Text	255
Name		Text	100
ParentFullName	Item (FullName)	Dropdown	1000
PrefVendor	Entity (FullName)	Dropdown	0
PriceInclusive		Money	0
PurchaseCost		Decimal	0
PurchaseCostInclusive		Money	0
PurchaseDesc		Text	4095
PurchaseTaxCalculation	TaxCalculationType (Name)	Dropdown	0
PurchaseTaxCode	SalesTaxCode (Name)	Dropdown	0
QuantityInStock		Decimal	0
QuantityOnHand		Decimal	0
QuantityOnOrder		Decimal	0
QuantityOnSalesOrder		Decimal	0
RecordID		Integer	0
ReorderPoint		Decimal	0
ReplenishLevel		Integer	255
SalesDesc		Text	4000
SalesPrice		Decimal	0
SalesTaxCode	SalesTaxCode (Name)	Dropdown	0
Sku		Text	100
Sublevel		Integer	0
TaxCalculation	TaxCalculationType (Name)	Dropdown	0
TaxClassification	TaxClassification (Name)	Dropdown	0
TaxRate		Decimal	0
TimeCreated		DateTime	0
TimeModifiedAccounting		DateTime	0
UnitOfMeasureSet	UnitOfMeasureSet (Name)	Dropdown	0

ItemCategory QuickBooks Table


Account	Account (FullName)	Dropdown	0
AlertLevel		Decimal	255
AssetAccount	Account (FullName)	Dropdown	0
blnIsPricePercent		YesNo	0
Cost		Decimal	0
CostInclusive		Money	0
CriticalLevel		Decimal	255
EditSequence		Text	50
EstHrs		Decimal	2
ExpenseAccount	Account (FullName)	Dropdown	0
FullName		Text	159
InventoryControlAutoBinSelection	InventoryControlAutoBinSelection (Name)	Dropdown	-1
InvStartDate		DateTime	0
IsActive		YesNo	0
IsAvailableForReorder		YesNo	0
IsNotNPDonation		YesNo	0
IsPrintItemsInGroup		YesNo	0
IsSalesAndPurchase		YesNo	0
IsSerialTrackingRequired		YesNo	255
IsTaxIncluded		YesNo	0
IsTrackQtyOnHand		YesNo	0
IsUsedOnPurchaseTransaction		YesNo	0
IsUsedOnSalesTransaction		YesNo	0
ItemDesc		Text	4095
ItemHeight		Decimal	2
ItemLength		Decimal	2
ItemType		Text	20
ItemWeight		Decimal	2
ItemWidth		Decimal	2
LastModifiedDate		DateTime	255
LeadTime		Text	255
LeadTimeFixed		Decimal	2
ListID		Text	100
LotSizeMinimum		Decimal	2
LotSizeMultiple		Decimal	2
LowLevelCode		Text	255
ManufacturerPartNumber		Text	31
MFGLeadTimeUOM	MFGLeadTimeUOM (LeadTimeUOM)	Dropdown	50
MonitorLevel		Text	255
Name		Text	31
Notes		Text	4095
Parent	Item (FullName)	Dropdown	0
PaymentMethod	PaymentMethod (Name)	Dropdown	0
Price		Decimal	0
PriceInclusive		Money	0
PurchaseDesc		Text	4095
PurchaseTaxCalculation	TaxCalculationType (Name)	Dropdown	0
PurchaseTaxCode	SalesTaxCode (Name)	Dropdown	0
QuantityInStock		Decimal	0
RecordID		Integer	0
ReplenishLevel		Integer	255
SalesTaxCode	SalesTaxCode (Name)	Dropdown	0
Sku		Text	100
Sublevel		Integer	0
TaxCalculation	TaxCalculationType (Name)	Dropdown	0
TaxClassification	TaxClassification (Name)	Dropdown	0
TimeCreated		DateTime	0
TimeModifiedAccounting		DateTime	0
UnitOfMeasureSet	UnitOfMeasureSet (Name)	Dropdown	0
Vendor	Entity (FullName)	Dropdown	0

ItemDonorFlow Method Table


DonorFlow	DonorFlow (RecordID)	Dropdown	0
Item	Item (FullName)	Dropdown	0
↳ ItemSalesDesc	(SalesDesc)	Linked	0
↳ ItemSalesPrice	(SalesPrice)	Linked	0
ItemTitle		Text	255
LastModifiedDate		DateTime	255
RecordID		Integer	0

ItemGroup QuickBooks Table


AlertLevel		Decimal	255
CriticalLevel		Decimal	255
EditSequence		Text	50
EstHrs		Decimal	2
hiddenInternalCUSTOMFIELD1		Text	31
hiddenInternalCUSTOMFIELD10		Text	31
hiddenInternalCUSTOMFIELD11		Text	31
hiddenInternalCUSTOMFIELD12		Text	31
hiddenInternalCUSTOMFIELD13		Text	31
hiddenInternalCUSTOMFIELD14		Text	31
hiddenInternalCUSTOMFIELD15		Text	31
hiddenInternalCUSTOMFIELD16		Text	31
hiddenInternalCUSTOMFIELD17		Text	31
hiddenInternalCUSTOMFIELD18		Text	31
hiddenInternalCUSTOMFIELD19		Text	31
hiddenInternalCUSTOMFIELD2		Text	31
hiddenInternalCUSTOMFIELD20		Text	31
hiddenInternalCUSTOMFIELD21		Text	31
hiddenInternalCUSTOMFIELD22		Text	31
hiddenInternalCUSTOMFIELD23		Text	31
hiddenInternalCUSTOMFIELD24		Text	31
hiddenInternalCUSTOMFIELD25		Text	31
hiddenInternalCUSTOMFIELD26		Text	31
hiddenInternalCUSTOMFIELD27		Text	31
hiddenInternalCUSTOMFIELD28		Text	31
hiddenInternalCUSTOMFIELD29		Text	31
hiddenInternalCUSTOMFIELD3		Text	31
hiddenInternalCUSTOMFIELD30		Text	31
hiddenInternalCUSTOMFIELD4		Text	31
hiddenInternalCUSTOMFIELD5		Text	31
hiddenInternalCUSTOMFIELD6		Text	31
hiddenInternalCUSTOMFIELD7		Text	31
hiddenInternalCUSTOMFIELD8		Text	31
hiddenInternalCUSTOMFIELD9		Text	31
InventoryControlAutoBinSelection	InventoryControlAutoBinSelection (Name)	Dropdown	-1
InvStartDate		DateTime	0
IsActive		YesNo	0
IsAvailableForReorder		YesNo	0
IsNotNPDonation		YesNo	0
IsPrintItemsInGroup		YesNo	0
IsSerialTrackingRequired		YesNo	255
IsTrackQtyOnHand		YesNo	0
IsUsedOnPurchaseTransaction		YesNo	0
IsUsedOnSalesTransaction		YesNo	0
ItemDesc		Text	4000
ItemHeight		Decimal	2
ItemLength		Decimal	2
ItemType		Text	20
ItemWeight		Decimal	2
ItemWidth		Decimal	2
LastModifiedDate		DateTime	255
LeadTime		Text	255
LeadTimeFixed		Decimal	2
ListID		Text	100
LotSizeMinimum		Decimal	2
LotSizeMultiple		Decimal	2
LowLevelCode		Text	255
MFGLeadTimeUOM	MFGLeadTimeUOM (LeadTimeUOM)	Dropdown	50
MonitorLevel		Text	255
Name		Text	100
PurchaseTaxCalculation	TaxCalculationType (Name)	Dropdown	0
QuantityInStock		Decimal	0
RecordID		Integer	0
ReplenishLevel		Integer	255
Sku		Text	100
SpecialItemType	ItemSpecialItemType (SpecialItemTypeName)	Dropdown	50
Sublevel		Integer	0
TaxCalculation	TaxCalculationType (Name)	Dropdown	0
TaxClassification	TaxClassification (Name)	Dropdown	0
TimeCreated		DateTime	0
TimeModifiedAccounting		DateTime	0
UnitOfMeasureSet	UnitOfMeasureSet (Name)	Dropdown	0

ItemGroupOrAssemblyList QuickBooks Table


Item	Item (FullName)	Dropdown	159
ItemGroupOrAssembly	Item (FullName)	Dropdown	159
LastModifiedDate		DateTime	255
Quantity		Decimal	0
RecordID		Integer	0

ItemInventory QuickBooks Table


AlertLevel		Decimal	255
AssetAccount	Account (FullName)	Dropdown	1000
AverageCost		Money	0
COGSAccount	Account (FullName)	Dropdown	1000
CriticalLevel		Decimal	255
EditSequence		Text	50
EstHrs		Decimal	2
FullName		Text	1000
hiddenInternalCUSTOMFIELD1		Text	31
hiddenInternalCUSTOMFIELD10		Text	31
hiddenInternalCUSTOMFIELD11		Text	31
hiddenInternalCUSTOMFIELD12		Text	31
hiddenInternalCUSTOMFIELD13		Text	31
hiddenInternalCUSTOMFIELD14		Text	31
hiddenInternalCUSTOMFIELD15		Text	31
hiddenInternalCUSTOMFIELD16		Text	31
hiddenInternalCUSTOMFIELD17		Text	31
hiddenInternalCUSTOMFIELD18		Text	31
hiddenInternalCUSTOMFIELD19		Text	31
hiddenInternalCUSTOMFIELD2		Text	31
hiddenInternalCUSTOMFIELD20		Text	31
hiddenInternalCUSTOMFIELD21		Text	31
hiddenInternalCUSTOMFIELD22		Text	31
hiddenInternalCUSTOMFIELD23		Text	31
hiddenInternalCUSTOMFIELD24		Text	31
hiddenInternalCUSTOMFIELD25		Text	31
hiddenInternalCUSTOMFIELD26		Text	31
hiddenInternalCUSTOMFIELD27		Text	31
hiddenInternalCUSTOMFIELD28		Text	31
hiddenInternalCUSTOMFIELD29		Text	31
hiddenInternalCUSTOMFIELD3		Text	31
hiddenInternalCUSTOMFIELD30		Text	31
hiddenInternalCUSTOMFIELD4		Text	31
hiddenInternalCUSTOMFIELD5		Text	31
hiddenInternalCUSTOMFIELD6		Text	31
hiddenInternalCUSTOMFIELD7		Text	31
hiddenInternalCUSTOMFIELD8		Text	31
hiddenInternalCUSTOMFIELD9		Text	31
IncomeAccount	Account (FullName)	Dropdown	1000
InventoryControlAutoBinSelection	InventoryControlAutoBinSelection (Name)	Dropdown	-1
InvStartDate		DateTime	0
IsActive		YesNo	0
IsAvailableForReorder		YesNo	0
IsNotNPDonation		YesNo	0
IsPricePercent		YesNo	0
IsPrintItemsInGroup		YesNo	0
IsSerialTrackingRequired		YesNo	255
IsTaxIncluded		YesNo	0
IsTrackQtyOnHand		YesNo	0
IsUsedOnPurchaseTransaction		YesNo	0
IsUsedOnSalesTransaction		YesNo	0
ItemHeight		Decimal	2
ItemLength		Decimal	2
ItemType		Text	20
ItemWeight		Decimal	2
ItemWidth		Decimal	2
LastModifiedDate		DateTime	255
LeadTime		Text	255
LeadTimeFixed		Decimal	2
ListID		Text	100
LotSizeMinimum		Decimal	2
LotSizeMultiple		Decimal	2
LowLevelCode		Text	255
ManufacturerPartNumber		Text	31
MFGLeadTimeUOM	MFGLeadTimeUOM (LeadTimeUOM)	Dropdown	50
MonitorLevel		Text	255
Name		Text	100
ParentFullName	Item (FullName)	Dropdown	1000
PrefVendor	Entity (FullName)	Dropdown	0
PriceInclusive		Money	0
PurchaseCost		Decimal	0
PurchaseCostInclusive		Money	0
PurchaseDesc		Text	4095
PurchaseTaxCalculation	TaxCalculationType (Name)	Dropdown	0
PurchaseTaxCode	SalesTaxCode (Name)	Dropdown	0
QuantityInStock		Decimal	0
QuantityOnHand		Decimal	0
QuantityOnOrder		Decimal	0
QuantityOnSalesOrder		Decimal	0
RecordID		Integer	0
ReorderPoint		Decimal	0
ReplenishLevel		Integer	255
SalesDesc		Text	4000
SalesPrice		Decimal	0
SalesTaxCode	SalesTaxCode (Name)	Dropdown	0
Sku		Text	100
Sublevel		Integer	0
TaxCalculation	TaxCalculationType (Name)	Dropdown	0
TaxClassification	TaxClassification (Name)	Dropdown	0
TimeCreated		DateTime	0
TimeModifiedAccounting		DateTime	0
UnitOfMeasureSet	UnitOfMeasureSet (Name)	Dropdown	0

ItemNonInventory QuickBooks Table


AlertLevel		Decimal	255
CriticalLevel		Decimal	255
EditSequence		Text	50
EstHrs		Decimal	2
ExpenseAccount	Account (FullName)	Dropdown	0
FullName		Text	1000
hiddenInternalCUSTOMFIELD1		Text	31
hiddenInternalCUSTOMFIELD10		Text	31
hiddenInternalCUSTOMFIELD11		Text	31
hiddenInternalCUSTOMFIELD12		Text	31
hiddenInternalCUSTOMFIELD13		Text	31
hiddenInternalCUSTOMFIELD14		Text	31
hiddenInternalCUSTOMFIELD15		Text	31
hiddenInternalCUSTOMFIELD16		Text	31
hiddenInternalCUSTOMFIELD17		Text	31
hiddenInternalCUSTOMFIELD18		Text	31
hiddenInternalCUSTOMFIELD19		Text	31
hiddenInternalCUSTOMFIELD2		Text	31
hiddenInternalCUSTOMFIELD20		Text	31
hiddenInternalCUSTOMFIELD21		Text	31
hiddenInternalCUSTOMFIELD22		Text	31
hiddenInternalCUSTOMFIELD23		Text	31
hiddenInternalCUSTOMFIELD24		Text	31
hiddenInternalCUSTOMFIELD25		Text	31
hiddenInternalCUSTOMFIELD26		Text	31
hiddenInternalCUSTOMFIELD27		Text	31
hiddenInternalCUSTOMFIELD28		Text	31
hiddenInternalCUSTOMFIELD29		Text	31
hiddenInternalCUSTOMFIELD3		Text	31
hiddenInternalCUSTOMFIELD30		Text	31
hiddenInternalCUSTOMFIELD4		Text	31
hiddenInternalCUSTOMFIELD5		Text	31
hiddenInternalCUSTOMFIELD6		Text	31
hiddenInternalCUSTOMFIELD7		Text	31
hiddenInternalCUSTOMFIELD8		Text	31
hiddenInternalCUSTOMFIELD9		Text	31
IncomeAccount	Account (FullName)	Dropdown	1000
InventoryControlAutoBinSelection	InventoryControlAutoBinSelection (Name)	Dropdown	-1
InvStartDate		DateTime	0
IsActive		YesNo	0
IsAvailableForReorder		YesNo	0
IsNotNPDonation		YesNo	0
IsPricePercent		YesNo	0
IsPrintItemsInGroup		YesNo	0
IsSalesAndPurchase		YesNo	0
IsSerialTrackingRequired		YesNo	255
IsTaxIncluded		YesNo	0
IsTrackQtyOnHand		YesNo	0
IsUsedOnPurchaseTransaction		YesNo	0
IsUsedOnSalesTransaction		YesNo	0
ItemHeight		Decimal	2
ItemLength		Decimal	2
ItemType		Text	20
ItemWeight		Decimal	2
ItemWidth		Decimal	2
LastModifiedDate		DateTime	255
LeadTime		Text	255
LeadTimeFixed		Decimal	2
ListID		Text	100
LotSizeMinimum		Decimal	2
LotSizeMultiple		Decimal	2
LowLevelCode		Text	255
ManufacturerPartNumber		Text	31
MFGLeadTimeUOM	MFGLeadTimeUOM (LeadTimeUOM)	Dropdown	50
MonitorLevel		Text	255
Name		Text	100
ParentFullName	Item (FullName)	Dropdown	1000
PrefVendor	Entity (FullName)	Dropdown	0
PriceInclusive		Money	0
PurchaseCost		Decimal	0
PurchaseCostInclusive		Money	0
PurchaseDesc		Text	4095
PurchaseTaxCalculation	TaxCalculationType (Name)	Dropdown	0
PurchaseTaxCode	SalesTaxCode (Name)	Dropdown	0
QuantityInStock		Decimal	0
RecordID		Integer	0
ReplenishLevel		Integer	255
SalesDesc		Text	4000
SalesPrice		Decimal	0
SalesTaxCode	SalesTaxCode (Name)	Dropdown	0
Sku		Text	100
Sublevel		Integer	0
TaxCalculation	TaxCalculationType (Name)	Dropdown	0
TaxClassification	TaxClassification (Name)	Dropdown	0
TimeCreated		DateTime	0
TimeModifiedAccounting		DateTime	0
UnitOfMeasureSet	UnitOfMeasureSet (Name)	Dropdown	0

ItemPurchaseHistory Method Table


Customer	Entity (FullName)	Dropdown	0
Item	Item (FullName)	Dropdown	0
↳ ItemCost	(PurchaseCost)	Linked	0
↳ ItemSalesDesc	(SalesDesc)	Linked	0
↳ ItemSalesPrice	(SalesPrice)	Linked	0
LastInvoiceRecordID	Invoice (RecordID)	Dropdown	0
↳ LastInvoiceTxnDate	(TxnDate)	Linked	0
LastModifiedDate		DateTime	255
LastSalesPrice		Decimal	2
LastSalesReceiptRecordID	SalesReceipt (RecordID)	Dropdown	0
↳ LastSalesReceiptTxnDate	(TxnDate)	Linked	0
RecordID		Integer	0
SalesPrice		Decimal	2
TotalQuantityPurchased		Decimal	2

ItemService QuickBooks Table


AlertLevel		Decimal	255
CriticalLevel		Decimal	255
EditSequence		Text	50
EstHrs		Decimal	2
ExpenseAccount	Account (FullName)	Dropdown	159
FullName		Text	450
hiddenInternalCUSTOMFIELD1		Text	31
hiddenInternalCUSTOMFIELD10		Text	31
hiddenInternalCUSTOMFIELD11		Text	31
hiddenInternalCUSTOMFIELD12		Text	31
hiddenInternalCUSTOMFIELD13		Text	31
hiddenInternalCUSTOMFIELD14		Text	31
hiddenInternalCUSTOMFIELD15		Text	31
hiddenInternalCUSTOMFIELD16		Text	31
hiddenInternalCUSTOMFIELD17		Text	31
hiddenInternalCUSTOMFIELD18		Text	31
hiddenInternalCUSTOMFIELD19		Text	31
hiddenInternalCUSTOMFIELD2		Text	31
hiddenInternalCUSTOMFIELD20		Text	31
hiddenInternalCUSTOMFIELD21		Text	31
hiddenInternalCUSTOMFIELD22		Text	31
hiddenInternalCUSTOMFIELD23		Text	31
hiddenInternalCUSTOMFIELD24		Text	31
hiddenInternalCUSTOMFIELD25		Text	31
hiddenInternalCUSTOMFIELD26		Text	31
hiddenInternalCUSTOMFIELD27		Text	31
hiddenInternalCUSTOMFIELD28		Text	31
hiddenInternalCUSTOMFIELD29		Text	31
hiddenInternalCUSTOMFIELD3		Text	31
hiddenInternalCUSTOMFIELD30		Text	31
hiddenInternalCUSTOMFIELD4		Text	31
hiddenInternalCUSTOMFIELD5		Text	31
hiddenInternalCUSTOMFIELD6		Text	31
hiddenInternalCUSTOMFIELD7		Text	31
hiddenInternalCUSTOMFIELD8		Text	31
hiddenInternalCUSTOMFIELD9		Text	31
IncomeAccount	Account (FullName)	Dropdown	1000
InventoryControlAutoBinSelection	InventoryControlAutoBinSelection (Name)	Dropdown	-1
InvStartDate		DateTime	0
IsActive		YesNo	0
IsAvailableForReorder		YesNo	0
IsNotNPDonation		YesNo	0
IsPricePercent		YesNo	0
IsPrintItemsInGroup		YesNo	0
IsSalesAndPurchase		YesNo	0
IsSerialTrackingRequired		YesNo	255
IsTaxIncluded		YesNo	0
IsTrackQtyOnHand		YesNo	0
IsUsedOnPurchaseTransaction		YesNo	0
IsUsedOnSalesTransaction		YesNo	0
ItemHeight		Decimal	2
ItemLength		Decimal	2
ItemType		Text	20
ItemWeight		Decimal	2
ItemWidth		Decimal	2
LastModifiedDate		DateTime	255
LeadTime		Text	255
LeadTimeFixed		Decimal	2
ListID		Text	100
LotSizeMinimum		Decimal	2
LotSizeMultiple		Decimal	2
LowLevelCode		Text	255
MFGLeadTimeUOM	MFGLeadTimeUOM (LeadTimeUOM)	Dropdown	50
MonitorLevel		Text	255
Name		Text	100
ParentFullName	Item (FullName)	Dropdown	1000
PrefVendor	Entity (FullName)	Dropdown	0
PriceInclusive		Money	0
PurchaseCost		Decimal	0
PurchaseCostInclusive		Money	0
PurchaseDesc		Text	4095
PurchaseTaxCalculation	TaxCalculationType (Name)	Dropdown	0
PurchaseTaxCode	SalesTaxCode (Name)	Dropdown	0
QuantityInStock		Decimal	0
RecordID		Integer	0
ReplenishLevel		Integer	255
SalesDesc		Text	4000
SalesPrice		Decimal	0
SalesTaxCode	SalesTaxCode (Name)	Dropdown	3
Sku		Text	100
Sublevel		Integer	0
TaxCalculation	TaxCalculationType (Name)	Dropdown	0
TaxClassification	TaxClassification (Name)	Dropdown	0
TimeCreated		DateTime	0
TimeModifiedAccounting		DateTime	0
UnitOfMeasureSet	UnitOfMeasureSet (Name)	Dropdown	0

JobPriority Method Table


JobPriority	Text	255
LastModifiedDate	DateTime	255
RecordID	Integer	-1

Jobs Method Table


Contact	Contacts (RecordID)	Dropdown	0
Customer	Entity (FullName)	Dropdown	0
InternalJobStatus	InternalJobStatus (InternalJobStatus)	Dropdown	0
InternalJobType	InternalJobType (JobType)	Dropdown	0
JobSiteAddr1		Text	500
JobSiteAddr2		Text	500
JobSiteAddr3		Text	500
JobSiteAddr4		Text	500
JobSiteAddr5		Text	500
JobSiteCity		Text	500
JobSiteCountry		Text	255
JobSitePostalCode		Text	30
JobSiteState		Text	255
LastModifiedDate		DateTime	255
Priority	JobPriority (JobPriority)	Dropdown	0
RecordID		Integer	0

JournalEntry QuickBooks Table


Campaign	Campaign (Name)	Dropdown	-1
Currency	Currency (CurrencyCode)	Dropdown	0
EditSequence		Text	50
ExchangeRate		Decimal	0
IsAdjustment		YesNo	0
IsAmountsEnteredInHomeCurrency		YesNo	0
IsHomeCurrencyAdjustment		YesNo	0
IsWaitingForSyncApproval		YesNo	0
LastModifiedDate		DateTime	255
Memo		Text	4000
RecordID		Integer	0
RefNumber		Text	21
TimeCreated		DateTime	0
TimeModifiedAccounting		DateTime	0
TxnDate		DateTime	0
TxnID		Text	100
TxnMethodFlag		Text	31
TxnNumber		Integer	0

JournalEntryLine QuickBooks Table


Account	Account (FullName)	Dropdown	159
AmountCredit		Money	0
AmountDebit		Money	0
BillableStatus	BillableStatus (BillableStatus)	Dropdown	20
Class	Class (FullName)	Dropdown	159
Entity	Entity (FullName)	Dropdown	209
ItemSalesTax	Item (FullName)	Dropdown	0
JournalEntryRecordID	JournalEntry (RecordID)	Dropdown	0
LastModifiedDate		DateTime	255
Memo		Text	4000
RecordID		Integer	0
TxnLineID		Text	100
TxnMethodFlag		Text	31

LeadForms Method Table


BodyText		Text	5000
CustomWebpage		Text	255
DefaultAssignedTo	Users (UserName)	Dropdown	0
DefaultEmailAssignedTo	EmailTemplate (Name)	Dropdown	0
DefaultEmailCustomer	EmailTemplate (Name)	Dropdown	0
Description		Text	4000
FooterText		Text	5000
HeaderText		Text	5000
IsActive		YesNo	0
IsEmailNotificationAssignedTo		YesNo	0
IsEmailNotificationCustomer		YesNo	0
IsRedirectedToCustomWebpage		YesNo	0
LastModifiedDate		DateTime	255
LeadSource	LeadSource (LeadSource)	Dropdown	0
Name		Text	240
OpportunityStage	OpportunityStage (OpportunityStage)	Dropdown	0
RecordID		Integer	0
ResponseCount		Integer	0
ResponseRate		Decimal	4
ThankYouText		Text	5000
Title		Text	4000
ViewCount		Integer	0

LeadRating Method Table


LastModifiedDate	DateTime	255
LeadRating	Text	50
RecordID	Integer	-1

LeadSource Method Table


LastModifiedDate	DateTime	255
LeadSource	Text	255
RecordID	Integer	0

LeadStatus Method Table


LastModifiedDate	DateTime	255
LeadStatus	Text	50
RecordID	Integer	-1

ListBuilder Method Table


AccountNumber		Text	99
AltContact		Text	31
AltPhone		Text	30
AppliedAmount		Money	255
AssignedTo	Users (UserName)	Dropdown	-1
Balance		Money	255
BalanceRemaining		Money	255
BillAddressAddr1		Text	500
BillAddressAddr2		Text	500
BillAddressAddr3		Text	500
BillAddressCity		Text	255
BillAddressCountry		Text	255
BillAddressPostalCode		Text	30
BillAddressState		Text	255
BirthDate		DateTime	255
Campaign		Text	100
Class		Text	159
CompanyName		Text	100
Contact		Text	450
ContactAssignedTo		Text	255
ContactRecordID		Integer	255
CustomerType		Text	159
Email		Text	1023
EntityRecordID		Integer	255
FirstName		Text	100
FullName		Text	1000
IsActive		YesNo	255
IsLeadStatusOnly		YesNo	255
IsOptOutOfBilling		YesNo	255
IsOptOutOfMarketing		YesNo	255
LastModifiedDate		DateTime	255
LastName		Text	100
MiddleName		Text	100
Mobile		Text	30
Name		Text	450
Pager		Text	21
Phone		Text	30
PortalPassword		Text	10
PortalUserName		Text	10
PreferredPaymentMethod		Text	31
RecordID		Integer	0
RefNumber		Text	50
SalesRep		Text	100
ShipAddressAddr1		Text	500
ShipAddressAddr2		Text	500
ShipAddressAddr3		Text	500
ShipAddressCity		Text	255
ShipAddressCountry		Text	255
ShipAddressPostalCode		Text	30
ShipAddressState		Text	255
TagList		Text	4000
Terms		Text	31
Title		Text	25
TotalAmount		Money	255
TxnDate		DateTime	255
TxnRecordID		Integer	255
TxnType		Text	50

MFGLeadTimeUOM Method Table


LastModifiedDate	DateTime	255
LeadTimeUOM	Text	50
RecordID	Integer	0

Opportunity Method Table


Amount		Money	255
AssignedTo	Users (UserName)	Dropdown	-1
Campaign	Campaign (Name)	Dropdown	-1
CasesRecordID	Cases (RecordID)	Dropdown	0
CloseDate		DateTime	255
ContactEmail		Text	1023
ContactFax		Text	21
ContactMobile		Text	21
ContactName		Text	450
ContactPhone		Text	21
Contacts	Contacts (RecordID)	Dropdown	-1
↳ ContactsAssignedTo	(AssignedTo)	Linked	-1
↳ ContactsBalance	(Balance)	Linked	255
↳ ContactsCampaign	(Name)	Linked	-1
↳ ContactsEmail	(Email)	Linked	1023
↳ ContactsFaceBookUserName	(FaceBookUserName)	Linked	75
↳ ContactsLinkedInPublicUserName	(LinkedInPublicUserName)	Linked	100
↳ ContactsMobile	(Mobile)	Linked	21
↳ ContactsName	(Name)	Linked	0
↳ ContactsPhone	(Phone)	Linked	21
↳ ContactsTitle	(Title)	Linked	255
↳ ContactsTwitterUserName	(TwitterUserName)	Linked	15
↳ ContactsWebsite	(Website)	Linked	255
CreatedBy	Users (spdSecurityUserName)	Dropdown	-1
CreatedDate		DateTime	-1
Customer	Entity (FullName)	Dropdown	-1
↳ BillAddressAddr1	(BillAddressAddr1)	Linked	500
↳ BillAddressAddr2	(BillAddressAddr2)	Linked	500
↳ BillAddressAddr3	(BillAddressAddr3)	Linked	500
↳ BillAddressCity	(BillAddressCity)	Linked	255
↳ BillAddressCountry	(BillAddressCountry)	Linked	255
↳ BillAddressPostalCode	(BillAddressPostalCode)	Linked	30
↳ BillAddressState	(BillAddressState)	Linked	255
↳ CustomerCompanyName	(CompanyName)	Linked	50
↳ CustomerEmail	(Email)	Linked	1023
Description		Text	4000
ExpectedRevenue		Money	255
LastCompletedActivity	Activity (RecordID)	Dropdown	0
↳ LastActivityCompletedDate	(ActualCompletedDate)	Linked	255
LastModifiedBy	Users (spdSecurityUserName)	Dropdown	-1
LastModifiedDate		DateTime	255
LeadSource	LeadSource (LeadSource)	Dropdown	50
Name		Text	150
NextPendingActivity	Activity (RecordID)	Dropdown	0
↳ NextActivityDueDate	(DueDateStart)	Linked	-1
NextStep		Text	255
OpportunityStage	OpportunityStage (OpportunityStage)	Dropdown	-1
↳ OpportunityStageCategory	(OpportunityStageCategory)	Linked	50
OpportunityType	OpportunityType (OpportunityType)	Dropdown	50
Private		YesNo	255
ProbabilityPercent		Decimal	2
Quantity		Decimal	2
RecordID		Integer	0
ReorderCustomerComment		Text	255
TagList		Text	4000
TempBillAddressCityStateProvZipPostal		Text	1000

OpportunityLine Method Table


Amount		Money	0
Description		Text	4096
Item	Item (FullName)	Dropdown	0
↳ ItemType	(ItemType)	Linked	0
LastModifiedDate		DateTime	255
OpportunityRecordID	Opportunity (RecordID)	Dropdown	0
Quantity		Decimal	2
Rate		Money	0
RecordID		Integer	0

OpportunityStage Method Table


isDefault		YesNo	0
IsNotActive		YesNo	0
LastModifiedDate		DateTime	255
OpportunityStage		Text	255
OpportunityStageCategory	OpportunityStageCategory (OpportunityStageCategory)	Dropdown	50
RecordID		Integer	0
StageOrder		Integer	255
StageProbabilityPercent		Decimal	2

OpportunityStageCategory Method Table


LastModifiedDate	DateTime	255
OpportunityStageCategory	Text	50
RecordID	Integer	-1

OpportunityType Method Table


LastModifiedDate	DateTime	255
OpportunityType	Text	255
RecordID	Integer	0

PaymentGateway Method Table


ARAccount	Account (FullName)	Dropdown	0
DepositToAccount	Account (FullName)	Dropdown	0
IsActive		YesNo	1
IsSim		YesNo	0
LastModifiedDate		DateTime	255
LoginID		Text	255
MerchantType		Text	10
Name		Text	255
PaymentMethod	PaymentMethod (Name)	Dropdown	0
ProcessorType		Text	255
RecordID		Integer	0
TransactionKey		Text	255

PaymentMethod QuickBooks Table


EditSequence		Text	50
IsActive		YesNo	0
LastModifiedDate		DateTime	255
ListID		Text	100
Name		Text	31
PaymentMethodType	PaymentMethodType (PaymentMethodTypeName)	Dropdown	0
RecordID		Integer	0
TimeCreated		DateTime	0
TimeModifiedAccounting		DateTime	0

PaymentTransactionLog Method Table


Address		Text	250
Amount		Money	0
City		Text	100
Country		Text	100
Currency		Text	3
CustomerCompany		Text	250
CustomerName		Text	250
Email		Text	250
intMarkedForDeletion		Integer	0
IsApproved		YesNo	0
LastModifiedDate		DateTime	255
MaskedCC		Text	50
PaymentGateway	PaymentGateway (Name)	Dropdown	0
PaymentType		Text	50
RecordID		Integer	0
ResponseCode		Text	50
ResponseMessage		Text	250
ResponseRaw		Text	5000
ServerTimeModified		DateTime	0
StateOrProvince		Text	100
TransactionID		Text	50
TransactionTime		DateTime	0
TransactionType		Text	50
ZipCode		Text	50

PayrollItemNonWage QuickBooks Table


EditSequence		Text	50
ExpenseAccount	Account (FullName)	Dropdown	159
IsActive		YesNo	0
LastModifiedDate		DateTime	255
LiabilityAccount	Account (FullName)	Dropdown	159
ListID		Text	100
Name		Text	31
RecordID		Integer	0
TimeCreated		DateTime	0
TimeModifiedAccounting		DateTime	0
WageType	PayrollItemWageType (WageTypeName)	Dropdown	50

PayrollItemWage QuickBooks Table


EditSequence		Text	50
ExpenseAccount	Account (FullName)	Dropdown	159
IsActive		YesNo	0
LastModifiedDate		DateTime	255
ListID		Text	100
Name		Text	31
RecordID		Integer	0
TimeCreated		DateTime	0
TimeModifiedAccounting		DateTime	0
WageType	PayrollItemWageType (WageTypeName)	Dropdown	50

Pledge Method Table


LastModifiedDate				DateTime	255
RecordID				Integer	0

Preferences QuickBooks Table


AgingReportBasis		Text	50
AnnualInterestRate		Decimal	0
ASTEnabled		YesNo	0
AutomaticLoginUserName		Text	50
CalculateChargesFrom		Text	50
ClosingDate		DateTime	0
CustomTxnNumbers		YesNo	1
DaysBillsAreDue		Integer	0
DefaultCustomerMsgText		Text	1000
DefaultDiscountAccount	Account (FullName)	Dropdown	159
DefaultFOB		Text	50
DefaultItemSalesTax	Item (FullName)	Dropdown	159
DefaultMarkup		Decimal	0
DefaultNonTaxableSalesTaxCode	SalesTaxCode (Name)	Dropdown	31
DefaultSalesTaxPercentage		Decimal	0
DefaultShipMethod	ShipMethod (Name)	Dropdown	31
DefaultTaxableSalesTaxCode	SalesTaxCode (Name)	Dropdown	31
DefaultTermsRef		Integer	0
DiscountEnabled		YesNo	0
FinanceChargeAccount	Account (FullName)	Dropdown	159
FirstDayOfWeek		Text	50
GracePeriod		Integer	0
HomeCurrencyCode		Text	3
IsAssessingForOverdueCharges		YesNo	0
IsAssigningJournalEntryNumbers		YesNo	0
IsAutoApplyingPayments		YesNo	0
IsAutomaticallyUsingDiscounts		YesNo	0
IsAutomaticLoginAllowed		YesNo	0
IsMarkedToBePrinted		YesNo	0
IsMultiCurrencyOn		YesNo	0
IsMultiLocationInventoryAvailable		YesNo	0
IsMultiLocationInventoryEnabled		YesNo	0
IsPersonalDataAccessAllowed		YesNo	0
IsPrintingItemsWithZeroAmounts		YesNo	0
IsQuantityOnHand		YesNo	0
IsRequiringAccounts		YesNo	0
IsRoundingSalesPriceUp		YesNo	0
IsSalesTaxOn		YesNo	0
IsTrackingReimbursedExpensesAsIncome		YesNo	0
IsUsingAccountNumbers		YesNo	0
IsUsingAuditTrail		YesNo	0
IsUsingClassTracking		YesNo	0
IsUsingEstimates		YesNo	0
IsUsingInventory		YesNo	0
IsUsingPriceLevels		YesNo	0
IsUsingProgressInvoicing		YesNo	0
LastModifiedDate		DateTime	255
MinFinanceCharge		Decimal	0
PaySalesTax		Text	50
RecordID		Integer	0
SummaryReportBasis		Text	50

PreferencesMethod Method Table


AstOverride		YesNo	0
DefaultCaseActivityFollowUpNumOfDays		Integer	0
DefaultCaseActivityFollowUpType	ActivityType (ActivityType)	Dropdown	0
DefaultCaseActivityType	ActivityType (ActivityType)	Dropdown	0
DefaultCaseAssignedTo	Users (UserName)	Dropdown	0
DefaultCaseOrigin	CaseOrigin (CaseOrigin)	Dropdown	0
DefaultCasePortalAssignedTo	Users (spdSecurityUserName)	Dropdown	0
DefaultCasePortalOrigin	CaseOrigin (CaseOrigin)	Dropdown	0
DefaultCasePortalType	CaseType (CaseType)	Dropdown	0
DefaultCasePriority	CasePriority (CasePriority)	Dropdown	0
DefaultCaseReason	CaseReason (CaseReason)	Dropdown	0
DefaultCaseStatus	CaseStatus (CaseStatus)	Dropdown	0
DefaultCaseType	CaseType (CaseType)	Dropdown	0
DefaultEmailActivity	EmailTemplate (Name)	Dropdown	-1
DefaultEmailCaseAssignedTo	EmailTemplate (Name)	Dropdown	-1
DefaultEmailCaseUpdateContact	EmailTemplate (Name)	Dropdown	-1
DefaultEmailCaseUpdateStaff	EmailTemplate (Name)	Dropdown	0
DefaultEmailContactAdd	EmailTemplate (Name)	Dropdown	-1
DefaultEmailContactEdit	EmailTemplate (Name)	Dropdown	-1
DefaultEmailCustomerEdit	EmailTemplate (Name)	Dropdown	-1
DefaultEmailEstimate	EmailTemplate (Name)	Dropdown	-1
DefaultEmailEstimateAcceptedInternalNotification	EmailTemplate (Name)	Dropdown	0
DefaultEmailEstimateActivityType	ActivityType (ActivityType)	Dropdown	0
DefaultEmailEstimateApproval	EmailTemplate (Name)	Dropdown	0
DefaultEmailEstimateDeposit	EmailTemplate (Name)	Dropdown	0
DefaultEmailEstimateDepositPaymentNotification	EmailTemplate (Name)	Dropdown	0
DefaultEmailEstimateRejectedInternalNotification	EmailTemplate (Name)	Dropdown	0
DefaultEmailFollowUpActivity	EmailTemplate (Name)	Dropdown	-1
DefaultEmailInvoice	EmailTemplate (Name)	Dropdown	-1
DefaultEmailInvoiceActivityType	ActivityType (ActivityType)	Dropdown	0
DefaultEmailNewOrderRequest	EmailTemplate (Name)	Dropdown	0
DefaultEmailOpportunityAssignedTo	EmailTemplate (Name)	Dropdown	-1
DefaultEmailOrderRequestApproved	EmailTemplate (Name)	Dropdown	0
DefaultEmailOrderRequestRejected	EmailTemplate (Name)	Dropdown	0
DefaultEmailOrderRequestRejection	EmailTemplate (Name)	Dropdown	0
DefaultEmailPayment	EmailTemplate (Name)	Dropdown	-1
DefaultEmailPaymentActivityType	ActivityType (ActivityType)	Dropdown	0
DefaultEmailPaymentInternal	EmailTemplate (Name)	Dropdown	0
DefaultEmailPurchaseOrder	EmailTemplate (Name)	Dropdown	0
DefaultEmailPurchaseOrderActivityType	ActivityType (ActivityType)	Dropdown	0
DefaultEmailSalesOrder	EmailTemplate (Name)	Dropdown	0
DefaultEmailSalesOrderActivityType	ActivityType (ActivityType)	Dropdown	0
DefaultEmailSalesReceipt	EmailTemplate (Name)	Dropdown	0
DefaultEmailSalesReceiptActivityType	ActivityType (ActivityType)	Dropdown	0
DefaultEmailWorkOrderReminder	EmailTemplate (Name)	Dropdown	0
DefaultEstimateDepositItem	Item (FullName)	Dropdown	0
DefaultInvoiceARAccount	Account (FullName)	Dropdown	-1
DefaultInvoiceIsPrintPreview		YesNo	255
DefaultInvoiceIsToBeEmailed		YesNo	255
DefaultInvoiceIsToBePrinted		YesNo	255
DefaultInvoiceIsWaitingForSyncApproval		YesNo	255
DefaultOpportunityStatus	OpportunityStage (OpportunityStage)	Dropdown	0
DefaultOptoutMessage		Text	4000
DefaultOrderRequestAssignedTo	Users (spdSecurityUserName)	Dropdown	0
DefaultTemplateCheck	spiderReports (ReportName)	Dropdown	-1
DefaultTemplateCreditMemo	spiderReports (ReportName)	Dropdown	-1
DefaultTemplateEstimate	spiderReports (ReportName)	Dropdown	-1
DefaultTemplateInvoice	spiderReports (ReportName)	Dropdown	-1
DefaultTemplatePurchaseOrder	spiderReports (ReportName)	Dropdown	-1
DefaultTemplateSalesOrder	spiderReports (ReportName)	Dropdown	-1
DefaultTemplateSalesReceipt	spiderReports (ReportName)	Dropdown	-1
DefaultTimeTrackingBillableStatus	BillableStatus (BillableStatus)	Dropdown	-1
DefaultTimeTrackingIsWaitingForSyncApproval		YesNo	255
DefaultTimeTrackingPayrollItem	PayrollItemWage (Name)	Dropdown	-1
DefaultTimeTrackingServiceItem	Item (FullName)	Dropdown	0
DefaultTimeTrackLaborCost		Money	255
DefaultWorkOrderIsReminderEnabled		YesNo	0
DefaultWorkOrderReminderType	ReminderTypes (ReminderTypeName)	Dropdown	0
FieldServiceTemplateRouteList	spiderReports (ReportName)	Dropdown	0
FieldServiceTemplateWorkOrder	spiderReports (ReportName)	Dropdown	0
FieldServiceWorkOrderInternalEmail	EmailTemplate (Name)	Dropdown	0
FieldServiceWorkOrderServiceItem	Item (FullName)	Dropdown	0
InventoryControlAutoBinSelection	InventoryControlAutoBinSelection (Name)	Dropdown	-1
InvoiceTimeRoundingDirection	RoundingDirection (RecordID)	Dropdown	0
InvoiceTimeRoundingInterval	RoundingInterval (RecordID)	Dropdown	0
IsAutoAssignRefNumber		YesNo	0
IsCasePortalActive		YesNo	0
IsEmailNotificationContact		YesNo	255
IsEmailNotificationEstimate		YesNo	255
IsEmailNotificationInvoice		YesNo	255
IsEmailNotificationPayment		YesNo	255
IsEstimateApprovalEnabled		YesNo	0
IsEstimateDepositEnabled		YesNo	0
IsFieldCrewPriceVisible		YesNo	1
IsInvoiceReorderEnabled		YesNo	0
IsMLMEnabled		YesNo	0
IsProposalIsPaymentRequiredToAccept		YesNo	0
IsSalesReceiptReorderEnabled		YesNo	0
IsSalesTransactionAddressFreeForm		YesNo	255
IsTimeInvoiceRoundingEnabled		YesNo	0
LastModifiedDate		DateTime	255
MappingEndingAddress		Text	255
MappingIncludeFirstAddressLine		YesNo	0
MappingStartingAddress		Text	255
NPDefaultDepositToAccount	Account (FullName)	Dropdown	0
NPDefaultEmailDonationReceipt	EmailTemplate (Name)	Dropdown	0
NPDefaultTemplateAggregateReport	spiderReports (ReportName)	Dropdown	0
NPDefaultTemplateDonationReceipt	spiderReports (ReportName)	Dropdown	0
NPDefaultTemplateThankYouLetter	spiderReports (ReportName)	Dropdown	0
NPLetterBody		Text	15000
ProposalDefaultEmailExternal	EmailTemplate (Name)	Dropdown	0
ProposalDefaultEmailInternal	EmailTemplate (Name)	Dropdown	0
ProposalDefaultEmailPaymentFailed	EmailTemplate (Name)	Dropdown	0
ProposalDefaultEmailPaymentMethodExpiring	EmailTemplate (Name)	Dropdown	0
ProposalDefaultTemplateEngagementLetter	spiderReports (ReportName)	Dropdown	0
ProposalDefaultTermsEngagementLetterTemplate	ProposalEngagementLetterTemplate (Name)	Dropdown	0
ProposalsPaymentFailedEmail		YesNo	0
ProposalsPaymentMethodExpiringEmail		YesNo	0
RecordID		Integer	0
WorkOrderExternalEmail	EmailTemplate (Name)	Dropdown	0

PrintOrCheck Method Table


LastModifiedDate	DateTime	255
PrintOrCheck	Text	50
RecordID	Integer	0

Proposal Method Table


AcceptanceTerms		Integer	0
AcceptanceTermsDueDate		DateTime	0
AcceptedBy		Text	50
AcceptedBySignature		Text	255
AcceptedDate		DateTime	0
AcceptedIPAddress		Text	30
AssignedTo	Users (UserName)	Dropdown	0
BalanceRemaining		Money	0
Contacts	Contacts (RecordID)	Dropdown	0
↳ ContactsEmail	(Email)	Linked	0
↳ ContactsName	(Name)	Linked	0
↳ ContactsPhone	(Phone)	Linked	0
Currency	Currency (CurrencyCode)	Dropdown	0
Customer	Entity (FullName)	Dropdown	0
↳ CompanyName	(CompanyName)	Linked	0
↳ EntityType	(EntityType)	Linked	0
↳ IsCustomerActive	(IsActive)	Linked	0
CustomerPaymentInfoRecordID	CustomerPaymentInfo (RecordID)	Dropdown	0
EmailTemplate	EmailTemplate (Name)	Dropdown	0
EndDate		DateTime	0
EngagementLetterBody		Text	90000
EngagementLetterTemplate	ProposalEngagementLetterTemplate (Name)	Dropdown	0
EngagementLetterTemplateText		Text	90000
ExchangeRate		Decimal	0
FirstBillDate		DateTime	0
IncludedSubtotal		Money	0
IsAutoPaid		YesNo	0
IsBillingStartDateOnAcceptance		YesNo	0
IsRecurringLastDayOfMonth		YesNo	0
LastModifiedDate		DateTime	255
NextInvoiceDate		DateTime	0
OnAcceptanceSubtotal		Money	0
OnCompletionSubtotal		Money	0
PersonalizedMessage		Text	32000
ProposalName		Text	150
ProposalRecurrenceMultiplier		Integer	0
ProposalSentDate		DateTime	0
ProposalStatus	ProposalStatus (ProposalStatus)	Dropdown	0
↳ ProposalStatusType	(ProposalStatusType)	Linked	0
RecordID		Integer	0
RecurrenceFrequency	ProposalRecurrenceFrequency (ProposalRecurrenceFrequency)	Dropdown	0
RecurringDayOfMonth		Integer	0
RecurringSubtotal		Money	0
StartDate		DateTime	0
TagList		Text	4000
Terms	Terms (Name)	Dropdown	0
TotalAmount		Money	0
TotalInvoiced		Money	0

ProposalEngagementLetterTemplate Method Table


AssignedTo	Users (UserName)	Dropdown	0
EngagementLetterBody		Text	90000
IsActive		YesNo	0
LastModifiedDate		DateTime	255
Name		Text	100
RecordID		Integer	0

ProposalLine Method Table


Amount		Money	0
Description		Text	4095
IncomeAccount	Account (FullName)	Dropdown	0
Item	Item (FullName)	Dropdown	0
LastModifiedDate		DateTime	255
ProposalLineBillingType	ProposalLineBillingType (ProposalLineBillingType)	Dropdown	0
ProposalRecordID	Proposal (RecordID)	Dropdown	0
Quantity		Decimal	2
Rate		Decimal	5
RecordID		Integer	0
SalesTaxCode	SalesTaxCode (Name)	Dropdown	0

ProposalLineBillingType Method Table


LastModifiedDate	DateTime	255
ProposalLineBillingType	Text	50
RecordID	Integer	0
SortOrder	Integer	0

ProposalRecurrenceFrequency Method Table


LastModifiedDate	DateTime	255
ProposalRecurrenceFrequency	Text	50
RecordID	Integer	0

ProposalStatus Method Table


LastModifiedDate		DateTime	255
ProposalStatus		Text	50
ProposalStatusType	ProposalStatusType (ProposalStatusType)	Dropdown	0
RecordID		Integer	0

ProposalStatusType Method Table


LastModifiedDate	DateTime	255
ProposalStatusType	Text	50
RecordID	Integer	0

PurchaseOrder QuickBooks Table


APAccount	Account (FullName)	Dropdown	0
BillAddressAddr1		Text	500
BillAddressAddr2		Text	500
BillAddressAddr3		Text	500
BillAddressAddr4		Text	500
BillAddressAddr5		Text	500
BillAddressCity		Text	255
BillAddressCountry		Text	255
BillAddressNote		Text	41
BillAddressPostalCode		Text	30
BillAddressState		Text	255
Campaign	Campaign (Name)	Dropdown	-1
Class	Class (FullName)	Dropdown	0
Currency	Currency (CurrencyCode)	Dropdown	0
↳ CurrencySymbol	(CurrencySymbol)	Linked	10
DueDate		DateTime	0
EditSequence		Text	50
ExchangeRate		Decimal	0
ExpectedDate		DateTime	0
FOB		Text	50
hiddenInternalCUSTOMFIELD1		Text	31
hiddenInternalCUSTOMFIELD10		Text	31
hiddenInternalCUSTOMFIELD11		Text	31
hiddenInternalCUSTOMFIELD12		Text	31
hiddenInternalCUSTOMFIELD13		Text	31
hiddenInternalCUSTOMFIELD14		Text	31
hiddenInternalCUSTOMFIELD15		Text	31
hiddenInternalCUSTOMFIELD16		Text	31
hiddenInternalCUSTOMFIELD17		Text	31
hiddenInternalCUSTOMFIELD18		Text	31
hiddenInternalCUSTOMFIELD19		Text	31
hiddenInternalCUSTOMFIELD2		Text	31
hiddenInternalCUSTOMFIELD20		Text	31
hiddenInternalCUSTOMFIELD21		Text	31
hiddenInternalCUSTOMFIELD22		Text	31
hiddenInternalCUSTOMFIELD23		Text	31
hiddenInternalCUSTOMFIELD24		Text	31
hiddenInternalCUSTOMFIELD25		Text	31
hiddenInternalCUSTOMFIELD26		Text	31
hiddenInternalCUSTOMFIELD27		Text	31
hiddenInternalCUSTOMFIELD28		Text	31
hiddenInternalCUSTOMFIELD29		Text	31
hiddenInternalCUSTOMFIELD3		Text	31
hiddenInternalCUSTOMFIELD30		Text	31
hiddenInternalCUSTOMFIELD4		Text	31
hiddenInternalCUSTOMFIELD5		Text	31
hiddenInternalCUSTOMFIELD6		Text	31
hiddenInternalCUSTOMFIELD7		Text	31
hiddenInternalCUSTOMFIELD8		Text	31
hiddenInternalCUSTOMFIELD9		Text	31
IsFullyReceived		YesNo	0
IsManuallyClosed		YesNo	0
IsTaxIncluded		YesNo	0
IsToBeEmailed		YesNo	0
IsToBePrinted		YesNo	0
IsWaitingForSyncApproval		YesNo	0
Job	Jobs (RecordID)	Dropdown	0
LastModifiedDate		DateTime	255
Location	InventoryControlLocation (FullName)	Dropdown	-1
↳ LocationRoot	(RootName)	Linked	255
Memo		Text	4000
Other1		Text	25
Other2		Text	29
PurchaseOrderStatus	PurchaseOrderStatus (Name)	Dropdown	0
RecordID		Integer	0
RefNumber		Text	21
ReleaseDate		DateTime	255
SalesTaxCode	SalesTaxCode (Name)	Dropdown	0
SalesTaxTotal		Money	0
ShipAddressAddr1		Text	500
ShipAddressAddr2		Text	500
ShipAddressAddr3		Text	500
ShipAddressAddr4		Text	500
ShipAddressAddr5		Text	500
ShipAddressCity		Text	255
ShipAddressCountry		Text	255
ShipAddressNote		Text	41
ShipAddressPostalCode		Text	30
ShipAddressState		Text	255
ShipMethod	ShipMethod (Name)	Dropdown	0
ShipToEntity	Entity (FullName)	Dropdown	0
Subtotal		Money	0
TagList		Text	4000
TaxCalculation	TaxCalculationType (Type)	Dropdown	0
Template	Template (Name)	Dropdown	0
Terms	Terms (Name)	Dropdown	0
TimeCreated		DateTime	0
TimeModifiedAccounting		DateTime	0
TotalAmount		Money	0
TotalAmountInHomeCurrency		Decimal	0
TxnDate		DateTime	0
TxnID		Text	100
TxnMethodFlag		Text	31
TxnNumber		Integer	0
Vendor	Entity (FullName)	Dropdown	0
VendorMsg		Text	1000

PurchaseOrderLine QuickBooks Table


Amount		Money	0
AmountInclusive		Money	100
BillableStatus	BillableStatus (BillableStatus)	Dropdown	0
Class	Class (FullName)	Dropdown	0
CostInclusive		Decimal	100
Customer	Entity (FullName)	Dropdown	0
DateReq		DateTime	255
Desc		Text	4095
hiddenInternalCUSTOMFIELD1		Text	31
hiddenInternalCUSTOMFIELD10		Text	31
hiddenInternalCUSTOMFIELD11		Text	31
hiddenInternalCUSTOMFIELD12		Text	31
hiddenInternalCUSTOMFIELD13		Text	31
hiddenInternalCUSTOMFIELD14		Text	31
hiddenInternalCUSTOMFIELD15		Text	31
hiddenInternalCUSTOMFIELD16		Text	31
hiddenInternalCUSTOMFIELD17		Text	31
hiddenInternalCUSTOMFIELD18		Text	31
hiddenInternalCUSTOMFIELD19		Text	31
hiddenInternalCUSTOMFIELD2		Text	31
hiddenInternalCUSTOMFIELD20		Text	31
hiddenInternalCUSTOMFIELD21		Text	31
hiddenInternalCUSTOMFIELD22		Text	31
hiddenInternalCUSTOMFIELD23		Text	31
hiddenInternalCUSTOMFIELD24		Text	31
hiddenInternalCUSTOMFIELD25		Text	31
hiddenInternalCUSTOMFIELD26		Text	31
hiddenInternalCUSTOMFIELD27		Text	31
hiddenInternalCUSTOMFIELD28		Text	31
hiddenInternalCUSTOMFIELD29		Text	31
hiddenInternalCUSTOMFIELD3		Text	31
hiddenInternalCUSTOMFIELD30		Text	31
hiddenInternalCUSTOMFIELD4		Text	31
hiddenInternalCUSTOMFIELD5		Text	31
hiddenInternalCUSTOMFIELD6		Text	31
hiddenInternalCUSTOMFIELD7		Text	31
hiddenInternalCUSTOMFIELD8		Text	31
hiddenInternalCUSTOMFIELD9		Text	31
IsManuallyClosed		YesNo	0
IsMarkupPercent		YesNo	0
IsPrintItemsInGroup		YesNo	0
Item	Item (FullName)	Dropdown	0
↳ ItemType	(ItemType)	Linked	0
LastModifiedDate		DateTime	255
LineOrder		Integer	0
LinkToPurchaseOrder	purchaseorderline (RecordID)	Dropdown	0
MarkupRate		Decimal	0
Other1		Text	29
Other2		Text	29
PurchaseOrderLineGroupRecordID	PurchaseOrderLine (RecordID)	Dropdown	0
PurchaseOrderRecordID	PurchaseOrder (RecordID)	Dropdown	0
↳ PurchaseOrderIsFullyReceived	(IsFullyReceived)	Linked	0
↳ PurchaseOrderIsManuallyClosed	(IsManuallyClosed)	Linked	0
↳ PurchaseOrderStatusRecordID	(PurchaseOrderStatus_RecordID)	Linked	0
↳ PurchaseOrderTaxCalculation	(TaxCalculation)	Linked	0
↳ PurchaseOrderTxnDate	(TxnDate)	Linked	0
↳ PurchaseOrderVendorRecordID	(Vendor_RecordID)	Linked	0
QuanityOnTransferOrder		Decimal	0
Quantity		Decimal	0
Rate		Decimal	5
ReceivedQuantity		Decimal	0
RecordID		Integer	0
SalesTaxCode	SalesTaxCode (Name)	Dropdown	0
ServiceDate		DateTime	0
TxnLineID		Text	100
TxnMethodFlag		Text	31

PurchaseOrderLineExpense QuickBooks Table


Account	Account (FullName)	Dropdown	0
Amount		Money	0
AmountInclusive		Money	100
BillableStatus	BillableStatus (BillableStatus)	Dropdown	0
Class	Class (FullName)	Dropdown	0
Customer	Entity (FullName)	Dropdown	0
IsMarkupPercent		YesNo	0
LastModifiedDate		DateTime	255
MarkupRate		Decimal	0
Memo		Text	4000
PurchaseOrder	PurchaseOrder (RecordID)	Dropdown	0
RecordID		Integer	0
SalesTaxCode	SalesTaxCode (Name)	Dropdown	0
TxnLineID		Text	100
TxnMethodFlag		Integer	0

PurchaseOrderStatus QuickBooks Table


LastModifiedDate	DateTime	255
Name	Text	10
RecordID	Integer	0

ReceivePayment QuickBooks Table


AdditionalReference		Text	255
AssignedTo	Users (UserName)	Dropdown	-1
AuthorizationCode		Text	12
AVSStreet		Text	20
AVSZip		Text	20
BatchPaymentTxnID		Text	255
CardSecurityCodeMatch		Text	20
ClientTransID		Text	16
CommercialCardCode		Text	24
CreditCardAddress		Text	50
CreditCardNumber		Text	50
CreditCardPostalCode		Text	18
CreditCardTransID		Text	24
Currency	Currency (CurrencyCode)	Dropdown	0
↳ CurrencySymbol	(CurrencySymbol)	Linked	10
Customer	Entity (FullName)	Dropdown	0
↳ SalesRepRecordID	(RecordID)	Linked	0
DepositToAccount	Account (FullName)	Dropdown	0
EditSequence		Text	50
ExchangeRate		Decimal	0
ExpirationMonth		Integer	0
ExpirationYear		Integer	0
IsAutoApply		YesNo	0
IsWaitingForSyncApproval		YesNo	0
LastModifiedDate		DateTime	255
Location	InventoryControlLocation (FullName)	Dropdown	0
Memo		Text	4000
MerchantAccountNumber		Text	32
NameOnCard		Text	50
PaymentGroupingCode		Integer	0
PaymentMethod	PaymentMethod (Name)	Dropdown	0
PaymentStatus		Text	20
ProposalRecordID	Proposal (RecordID)	Dropdown	0
ReconBatchID		Text	84
RecordID		Integer	0
RefNumber		Text	21
ResultCode		Integer	0
ResultMessage		Text	60
TagList		Text	4000
TimeCreated		DateTime	0
TimeModifiedAccounting		DateTime	0
TotalAmount		Money	0
TotalAmountInHomeCurrency		Decimal	0
TransactionMode	TransactionMode (TransactionMode)	Dropdown	0
TxnAuthorizationStamp		Integer	0
TxnAuthorizationTime		DateTime	0
TxnDate		DateTime	0
TxnID		Text	100
TxnMethodFlag		Text	31
TxnNumber		Integer	0
UnusedCredits		Money	0
UnusedPayment		Money	0

ReceivePaymentAppliedToTxn QuickBooks Table


Amount		Money	0
BalanceRemaining		Money	0
CreditAmount		Money	0
CreditTxnID		Text	100
CreditTxnRecordID		Integer	0
CreditTxnType	TransactionType (TxnType)	Dropdown	0
DiscountAccount	Account (FullName)	Dropdown	0
DiscountAmount		Money	0
LastModifiedDate		DateTime	255
ReceivePaymentRecordID	ReceivePayment (RecordID)	Dropdown	0
RecordID		Integer	0
RefNumber		Text	21
TxnDate		DateTime	0
TxnID		Text	100
TxnRecordID		Integer	0
TxnType	TransactionType (TxnType)	Dropdown	0

ReminderTypes Method Table


LastModifiedDate	DateTime	255
RecordID	Integer	0
ReminderTypeName	Text	255

Report QuickBooks Table


AccountFullName		Text	209
AccountType		Text	100
AssignedTo	Users (UserName)	Dropdown	-1
ClassFullName		Text	209
CustomEndDate		DateTime	255
CustomStartDate		DateTime	255
DetailLevel		Text	25
EntityFullName		Text	209
EntityType		Text	100
GeneratedDate		DateTime	255
IncludeAccounts		Text	10
ItemFullName		Text	209
ItemType		Text	100
LastModifiedDate		DateTime	255
PostingStatus		Text	25
RecordID		Integer	0
ReportAttachment		File	255
ReportBasis		Text	10
ReportOpenBalanceAsOf		Text	25
ReportPeriod		Text	100
ReportSchedule	ReportSchedule (Name)	Dropdown	-1
ReportType		Text	100
SummarizeRowsBy		Text	25
TxnType		Text	100

ReportMethod Method Table


CreatedDate	DateTime	0
MasterTable	Text	100
RecordID	Text	100
ReportDescription	Text	1000
ReportName	Text	50

ReportSchedule QuickBooks Table


AccountFullName		Text	209
AccountIncludeChildren		YesNo	255
AccountType		Text	100
AssignedTo	Users (UserName)	Dropdown	-1
ClassFullName		Text	209
ClassIncludeChildren		YesNo	255
CustomEndDate		DateTime	255
CustomInterval		Text	25
CustomIntervalRecalculateNextDate		DateTime	255
CustomStartDate		DateTime	255
DetailLevel		Text	25
EntityFullName		Text	209
EntityIncludeChildren		YesNo	255
EntityType		Text	100
IncludeAccounts		Text	10
IncludeColumns		Text	1000
IsActive		YesNo	255
ItemFullName		Text	209
ItemIncludeChildren		YesNo	255
ItemType		Text	100
LastModifiedDate		DateTime	255
Name		Text	255
PostingStatus		Text	25
RecordID		Integer	0
RegenerateInterval		Text	25
RegenerateNextDate		DateTime	255
ReportBasis		Text	10
ReportOpenBalanceAsOf		Text	25
ReportPeriod		Text	100
ReportType		Text	100
SummarizeRowsBy		Text	25
TxnType		Text	100

RoundingDirection Method Table


LastModifiedDate	DateTime	255
LineOrder	Integer	0
Name	Text	255
RecordID	Integer	0

RoundingInterval Method Table


LastModifiedDate	DateTime	255
LineOrder	Integer	0
Name	Text	255
RecordID	Integer	0

SalesOrder QuickBooks Table


AssignedTo	Users (UserName)	Dropdown	-1
BillAddressAddr1		Text	500
BillAddressAddr2		Text	500
BillAddressAddr3		Text	500
BillAddressAddr4		Text	500
BillAddressAddr5		Text	500
BillAddressCity		Text	255
BillAddressCountry		Text	255
BillAddressNote		Text	41
BillAddressPostalCode		Text	30
BillAddressState		Text	255
Campaign	Campaign (Name)	Dropdown	-1
Class	Class (FullName)	Dropdown	0
Currency	Currency (CurrencyCode)	Dropdown	0
↳ CurrencySymbol	(CurrencySymbol)	Linked	10
Customer	Entity (FullName)	Dropdown	0
CustomerMsg	CustomerMsg (Name)	Dropdown	0
CustomerSalesTaxCode	SalesTaxCode (Name)	Dropdown	0
DueDate		DateTime	0
EditSequence		Text	50
ExchangeRate		Decimal	0
FOB		Text	13
hiddenInternalCUSTOMFIELD1		Text	31
hiddenInternalCUSTOMFIELD10		Text	31
hiddenInternalCUSTOMFIELD11		Text	31
hiddenInternalCUSTOMFIELD12		Text	31
hiddenInternalCUSTOMFIELD13		Text	31
hiddenInternalCUSTOMFIELD14		Text	31
hiddenInternalCUSTOMFIELD15		Text	31
hiddenInternalCUSTOMFIELD16		Text	31
hiddenInternalCUSTOMFIELD17		Text	31
hiddenInternalCUSTOMFIELD18		Text	31
hiddenInternalCUSTOMFIELD19		Text	31
hiddenInternalCUSTOMFIELD2		Text	31
hiddenInternalCUSTOMFIELD20		Text	31
hiddenInternalCUSTOMFIELD21		Text	31
hiddenInternalCUSTOMFIELD22		Text	31
hiddenInternalCUSTOMFIELD23		Text	31
hiddenInternalCUSTOMFIELD24		Text	31
hiddenInternalCUSTOMFIELD25		Text	31
hiddenInternalCUSTOMFIELD26		Text	31
hiddenInternalCUSTOMFIELD27		Text	31
hiddenInternalCUSTOMFIELD28		Text	31
hiddenInternalCUSTOMFIELD29		Text	31
hiddenInternalCUSTOMFIELD3		Text	31
hiddenInternalCUSTOMFIELD30		Text	31
hiddenInternalCUSTOMFIELD4		Text	31
hiddenInternalCUSTOMFIELD5		Text	31
hiddenInternalCUSTOMFIELD6		Text	31
hiddenInternalCUSTOMFIELD7		Text	31
hiddenInternalCUSTOMFIELD8		Text	31
hiddenInternalCUSTOMFIELD9		Text	31
IsFullyInvoiced		YesNo	0
IsManuallyClosed		YesNo	0
IsTaxIncluded		YesNo	0
IsToBeEmailed		YesNo	0
IsToBePrinted		YesNo	0
IsWaitingForSyncApproval		YesNo	0
ItemSalesTax	Item (FullName)	Dropdown	0
LastModifiedDate		DateTime	255
Location	InventoryControlLocation (FullName)	Dropdown	-1
↳ LocationRoot	(RootName)	Linked	255
Memo		Text	4000
Opportunity	Opportunity (RecordID)	Dropdown	-1
Other		Text	29
PONumber		Text	25
RecordID		Integer	0
RefNumber		Text	21
SalesOrderState	SalesOrderState (SalesOrderState)	Dropdown	0
SalesRep	SalesRep (Initial)	Dropdown	0
SalesTaxPercentage		Decimal	0
SalesTaxTotal		Money	0
ShipAddressAddr1		Text	500
ShipAddressAddr2		Text	500
ShipAddressAddr3		Text	500
ShipAddressAddr4		Text	500
ShipAddressAddr5		Text	500
ShipAddressCity		Text	255
ShipAddressCountry		Text	255
ShipAddressNote		Text	41
ShipAddressPostalCode		Text	30
ShipAddressState		Text	255
ShipDate		DateTime	0
ShipMethod	ShipMethod (Name)	Dropdown	0
Subtotal		Money	0
TagList		Text	4000
Template	Template (Name)	Dropdown	0
Terms	Terms (Name)	Dropdown	0
TimeCreated		DateTime	0
TimeModifiedAccounting		DateTime	0
TotalAmount		Money	0
TotalAmountInHomeCurrency		Decimal	0
TxnDate		DateTime	0
TxnID		Text	100
TxnMethodFlag		Text	31
TxnNumber		Integer	0

SalesOrderLine QuickBooks Table


Amount		Money	0
Class	Class (FullName)	Dropdown	0
Desc		Text	4000
hiddenInternalCUSTOMFIELD1		Text	31
hiddenInternalCUSTOMFIELD10		Text	31
hiddenInternalCUSTOMFIELD11		Text	31
hiddenInternalCUSTOMFIELD12		Text	31
hiddenInternalCUSTOMFIELD13		Text	31
hiddenInternalCUSTOMFIELD14		Text	31
hiddenInternalCUSTOMFIELD15		Text	31
hiddenInternalCUSTOMFIELD16		Text	31
hiddenInternalCUSTOMFIELD17		Text	31
hiddenInternalCUSTOMFIELD18		Text	31
hiddenInternalCUSTOMFIELD19		Text	31
hiddenInternalCUSTOMFIELD2		Text	31
hiddenInternalCUSTOMFIELD20		Text	31
hiddenInternalCUSTOMFIELD21		Text	31
hiddenInternalCUSTOMFIELD22		Text	31
hiddenInternalCUSTOMFIELD23		Text	31
hiddenInternalCUSTOMFIELD24		Text	31
hiddenInternalCUSTOMFIELD25		Text	31
hiddenInternalCUSTOMFIELD26		Text	31
hiddenInternalCUSTOMFIELD27		Text	31
hiddenInternalCUSTOMFIELD28		Text	31
hiddenInternalCUSTOMFIELD29		Text	31
hiddenInternalCUSTOMFIELD3		Text	31
hiddenInternalCUSTOMFIELD30		Text	31
hiddenInternalCUSTOMFIELD4		Text	31
hiddenInternalCUSTOMFIELD5		Text	31
hiddenInternalCUSTOMFIELD6		Text	31
hiddenInternalCUSTOMFIELD7		Text	31
hiddenInternalCUSTOMFIELD8		Text	31
hiddenInternalCUSTOMFIELD9		Text	31
IncomeAccount	Account (FullName)	Dropdown	0
Invoiced		Decimal	0
IsManuallyClosed		YesNo	0
IsPrintItemsInGroup		YesNo	0
IsRatePercent		YesNo	0
Item	Item (FullName)	Dropdown	0
↳ ItemIsActive	(IsActive)	Linked	0
↳ ItemIsUsedOnPurchaseTransaction	(IsUsedOnPurchaseTransaction)	Linked	0
↳ ItemPrefVendor	(FullName)	Linked	0
↳ ItemType	(ItemType)	Linked	0
LastModifiedDate		DateTime	255
LineOrder		Integer	0
LocationBin	InventoryControlLocation (FullName)	Dropdown	-1
LocationSite	InventoryControlLocation (FullName)	Dropdown	-1
LotNumber		Text	40
Other1		Text	29
Other2		Text	29
Quantity		Decimal	0
Rate		Decimal	5
RecordID		Integer	0
SalesOrderLineGroupRecordID	SalesOrderLine (RecordID)	Dropdown	0
SalesOrderRecordID	SalesOrder (RecordID)	Dropdown	0
SalesTaxCode	SalesTaxCode (Name)	Dropdown	0
SerialNumber		Text	4095
TotalAmount		Money	0
TxnLineID		Text	100
TxnMethodFlag		Text	31

SalesOrderState Method Table


LastModifiedDate		DateTime	255
RecordID		Integer	-1
SalesOrderState		Text	255
SalesOrderStateType	SalesOrderStateType (SalesOrderStateType)	Dropdown	0

SalesOrderStateType Method Table


LastModifiedDate	DateTime	255
RecordID	Integer	-1
SalesOrderStateType	Text	255

SalesReceipt QuickBooks Table


AssignedTo	Users (UserName)	Dropdown	-1
BalanceRemaining		Decimal	0
BalanceRemainingInHomeCurrency		Decimal	0
BillAddressAddr1		Text	500
BillAddressAddr2		Text	500
BillAddressAddr3		Text	500
BillAddressAddr4		Text	500
BillAddressAddr5		Text	500
BillAddressCity		Text	255
BillAddressCountry		Text	255
BillAddressPostalCode		Text	30
BillAddressState		Text	255
BillEmail		Text	100
Campaign	Campaign (Name)	Dropdown	-1
CheckNumber		Text	255
Class	Class (FullName)	Dropdown	0
Currency	Currency (CurrencyCode)	Dropdown	0
↳ CurrencySymbol	(CurrencySymbol)	Linked	10
Customer	Entity (FullName)	Dropdown	0
↳ FirstName	(FirstName)	Linked	0
CustomerMsgText		Text	1000
CustomerSalesTaxCode	SalesTaxCode (Name)	Dropdown	0
DepositToAccount	Account (FullName)	Dropdown	0
DiscountAmt		Decimal	2
DiscountRate		Decimal	5
DiscountTaxable		YesNo	255
DonationPlanRecordID	DonationPlan (RecordID)	Dropdown	0
↳ Frequency	(Frequency)	Linked	0
DueDate		DateTime	0
EditSequence		Text	50
EstimateRecordID	Estimate (RecordID)	Dropdown	0
ExchangeRate		Decimal	0
ExpirationMonth		Integer	0
ExpirationYear		Integer	0
hiddenInternalCUSTOMFIELD1		Text	31
hiddenInternalCUSTOMFIELD10		Text	31
hiddenInternalCUSTOMFIELD11		Text	31
hiddenInternalCUSTOMFIELD12		Text	31
hiddenInternalCUSTOMFIELD13		Text	31
hiddenInternalCUSTOMFIELD14		Text	31
hiddenInternalCUSTOMFIELD15		Text	31
hiddenInternalCUSTOMFIELD16		Text	31
hiddenInternalCUSTOMFIELD17		Text	31
hiddenInternalCUSTOMFIELD18		Text	31
hiddenInternalCUSTOMFIELD19		Text	31
hiddenInternalCUSTOMFIELD2		Text	31
hiddenInternalCUSTOMFIELD20		Text	31
hiddenInternalCUSTOMFIELD21		Text	31
hiddenInternalCUSTOMFIELD22		Text	31
hiddenInternalCUSTOMFIELD23		Text	31
hiddenInternalCUSTOMFIELD24		Text	31
hiddenInternalCUSTOMFIELD25		Text	31
hiddenInternalCUSTOMFIELD26		Text	31
hiddenInternalCUSTOMFIELD27		Text	31
hiddenInternalCUSTOMFIELD28		Text	31
hiddenInternalCUSTOMFIELD29		Text	31
hiddenInternalCUSTOMFIELD3		Text	31
hiddenInternalCUSTOMFIELD30		Text	31
hiddenInternalCUSTOMFIELD4		Text	31
hiddenInternalCUSTOMFIELD5		Text	31
hiddenInternalCUSTOMFIELD6		Text	31
hiddenInternalCUSTOMFIELD7		Text	31
hiddenInternalCUSTOMFIELD8		Text	31
hiddenInternalCUSTOMFIELD9		Text	31
IsAnonymousDonation		YesNo	0
IsEmailSent		YesNo	0
IsInHonour		YesNo	0
IsInMemory		YesNo	0
IsLetterSent		YesNo	0
IsReceiptSent		YesNo	0
IsTaxIncluded		YesNo	0
IsToBeEmailed		YesNo	0
IsToBePrinted		YesNo	0
IsWaitingForSyncApproval		YesNo	0
LastModifiedDate		DateTime	255
Location	InventoryControlLocation (FullName)	Dropdown	-1
↳ LocationRoot	(RootName)	Linked	255
Memo		Text	4000
NPLetterBody		Text	15000
Opportunity	Opportunity (RecordID)	Dropdown	-1
PaymentMethod	PaymentMethod (Name)	Dropdown	0
Pledge	Pledge (RecordID)	Dropdown	0
RecordID		Integer	0
RefNumber		Text	21
SalesTaxPercentage		Decimal	0
SalesTaxTotal		Money	0
ShipAddressAddr1		Text	500
ShipAddressAddr2		Text	500
ShipAddressAddr3		Text	500
ShipAddressAddr4		Text	500
ShipAddressAddr5		Text	500
ShipAddressCity		Text	255
ShipAddressCountry		Text	255
ShipAddressPostalCode		Text	30
ShipAddressState		Text	255
ShipDate		DateTime	0
ShipMethodName		Text	100
ShippingAmt		Money	255
ShipTrackingNumber		Text	255
Subtotal		Money	0
TagList		Text	4000
TaxCalculation	TaxCalculationType (Name)	Dropdown	0
TimeCreated		DateTime	0
TimeModifiedAccounting		DateTime	0
TotalAmount		Money	0
TotalAmountInHomeCurrency		Decimal	0
TxnDate		DateTime	0
TxnID		Text	100
TxnMethodFlag		Text	31
TxnNumber		Integer	0

SalesReceiptLine QuickBooks Table


Amount		Money	0
AmountInclusive		Money	100
Class	Class (FullName)	Dropdown	0
Desc		Text	4000
hiddenInternalCUSTOMFIELD1		Text	31
hiddenInternalCUSTOMFIELD10		Text	31
hiddenInternalCUSTOMFIELD11		Text	31
hiddenInternalCUSTOMFIELD12		Text	31
hiddenInternalCUSTOMFIELD13		Text	31
hiddenInternalCUSTOMFIELD14		Text	31
hiddenInternalCUSTOMFIELD15		Text	31
hiddenInternalCUSTOMFIELD16		Text	31
hiddenInternalCUSTOMFIELD17		Text	31
hiddenInternalCUSTOMFIELD18		Text	31
hiddenInternalCUSTOMFIELD19		Text	31
hiddenInternalCUSTOMFIELD2		Text	31
hiddenInternalCUSTOMFIELD20		Text	31
hiddenInternalCUSTOMFIELD21		Text	31
hiddenInternalCUSTOMFIELD22		Text	31
hiddenInternalCUSTOMFIELD23		Text	31
hiddenInternalCUSTOMFIELD24		Text	31
hiddenInternalCUSTOMFIELD25		Text	31
hiddenInternalCUSTOMFIELD26		Text	31
hiddenInternalCUSTOMFIELD27		Text	31
hiddenInternalCUSTOMFIELD28		Text	31
hiddenInternalCUSTOMFIELD29		Text	31
hiddenInternalCUSTOMFIELD3		Text	31
hiddenInternalCUSTOMFIELD30		Text	31
hiddenInternalCUSTOMFIELD4		Text	31
hiddenInternalCUSTOMFIELD5		Text	31
hiddenInternalCUSTOMFIELD6		Text	31
hiddenInternalCUSTOMFIELD7		Text	31
hiddenInternalCUSTOMFIELD8		Text	31
hiddenInternalCUSTOMFIELD9		Text	31
IsPrintItemsInGroup		YesNo	0
IsRatePercent		YesNo	0
Item	Item (FullName)	Dropdown	0
↳ ItemIsNotNPDonation	(IsNotNPDonation)	Linked	0
↳ ItemType	(ItemType)	Linked	0
LastModifiedDate		DateTime	255
LineOrder		Integer	0
QuanityOnTransferOrder		Decimal	0
Quantity		Decimal	0
Rate		Decimal	5
RateInclusive		Decimal	100
RecordID		Integer	0
SalesReceiptLineGroupRecordID	SalesReceiptLine (RecordID)	Dropdown	0
SalesReceiptRecordID	SalesReceipt (RecordID)	Dropdown	0
↳ CustomerRecordID	(Customer_RecordID)	Linked	0
↳ FirstName	(FirstName)	Linked	0
↳ SalesReceiptAssignedToRecordID	(AssignedTo_RecordID)	Linked	0
↳ SalesReceiptBalanceRemaining	(BalanceRemaining)	Linked	0
↳ SalesReceiptSalesRepRecordID	(SalesRep_RecordID)	Linked	0
↳ SalesReceiptTaxCalculation	(TaxCalculation)	Linked	0
↳ TxnDate	(TxnDate)	Linked	0
ServiceDate		DateTime	0
TaxClassificationRef		Integer	0
TotalAmount		Money	0
TxnLineID		Text	100
TxnMethodFlag		Text	31

SalesTaxCode QuickBooks Table


Desc		Text	31
EditSequence		Text	50
IsActive		YesNo	0
IsTaxable		YesNo	0
IsUsedOnPurchaseTransaction		YesNo	0
IsUsedOnSalesTransaction		YesNo	0
ItemPurchaseTax	Item (FullName)	Dropdown	100
ItemSalesTax	Item (FullName)	Dropdown	100
LastModifiedDate		DateTime	255
ListID		Text	100
Name		Text	100
RecordID		Integer	0
TimeCreated		DateTime	0
TimeModifiedAccounting		DateTime	0

Solution Method Table


AssignedTo	Users (UserName)	Dropdown	-1
CreatedBy	Users (spdSecurityUserName)	Dropdown	-1
CreatedDate		DateTime	-1
IsForInternalUse		YesNo	255
LastModifiedBy	Users (spdSecurityUserName)	Dropdown	-1
LastModifiedDate		DateTime	255
RecordID		Integer	0
SolutionBody		Text	100000
SolutionStatus	SolutionStatus (SolutionStatus)	Dropdown	-1
SolutionType	SolutionType (SolutionType)	Dropdown	50
Title		Text	255

SolutionStatus Method Table


LastModifiedDate	DateTime	255
RecordID	Integer	0
SolutionStatus	Text	255

SolutionType Method Table


LastModifiedDate		DateTime	255
Name		Text	50
Parent	SolutionType (SolutionType)	Dropdown	0
RecordID		Integer	0
SolutionType		Text	255
Sublevel		Integer	0

StateCode Method Table


CountryCode	CountryCode (CountryCode)	Dropdown	0
FullName		Text	255
LastModifiedDate		DateTime	255
RecordID		Integer	0
StateCode		Text	50

StockAppFeatureAvailability Method Table


FeatureName	Text	255
IsAvailable	YesNo	0
LastModifiedDate	DateTime	255
RecordID	Integer	0

TaxCalculationType QuickBooks Table


LastModifiedDate	DateTime	255
Name	Text	100
RecordID	Integer	0
Type	Text	50

TaxClassification QuickBooks Table


ApplicableTo	Text	100
Code	Text	20
Description	Text	500
IsActive	YesNo	0
LastModifiedDate	DateTime	255
Level	Integer	0
ListID	Text	50
Name	Text	500
ParentRef	Integer	0
RecordID	Integer	0
TimeModifiedAccounting	DateTime	0

TaxExemptionReason Method Table


Reason				Text	255
RecordID				Integer	0

Tenant Method Table


LastModifiedDate	DateTime	255
Name	Text	50
RecordID	Integer	0
TagList	Text	-1

Terms QuickBooks Table


DayOfMonthDue	Integer	0
DiscountDayOfMonth	Integer	0
DiscountPct	Decimal	0
DueNextMonthDays	Integer	0
EditSequence	Text	50
IsActive	YesNo	0
IsDateDriven	YesNo	0
LastModifiedDate	DateTime	255
ListID	Text	100
Name	Text	31
RecordID	Integer	0
StdDiscountDays	Integer	0
StdDueDays	Integer	0
TimeCreated	DateTime	0
TimeModifiedAccounting	DateTime	0

ThirdPartyPortalLink Method Table


LastModifiedDate		DateTime	255
RecordID		Integer	0
ThirdPartyPortal	spiderThirdPartyLogin (spdThirdPartyLoginName)	Dropdown	0
ThirdPartyPortalLinkClickDate		DateTime	0
ThirdPartyPortalLinkClickIPaddress		Text	50
ThirdPartyPortalLinkExpires		DateTime	0
ThirdPartyPortalLinkID		Text	50
ThirdPartyPortalRecordID		Integer	0
ThirdPartyPortalSharedName		Text	50
ThirdPartyPortalSharedValue		Text	255
ThirdPartyPortalTabLink	spiderLinks (spdLinksName)	Dropdown	0

TimeRange Method Table


LastModifiedDate	DateTime	255
LineOrder	Integer	0
RangeName	Text	255
RecordID	Integer	0

TimeTracking QuickBooks Table


ActivitiesJobItem	ActivityJobItems (RecordID)	Dropdown	0
↳ ActivityNo	(RecordID)	Linked	0
BillableStatus	BillableStatus (BillableStatus)	Dropdown	20
BreakMinutes		Integer	255
Class	Class (FullName)	Dropdown	1000
Customer	Entity (FullName)	Dropdown	1000
DurationHours		Decimal	0
DurationMinutes		Decimal	0
EditSequence		Text	50
Entity	Entity (FullName)	Dropdown	1000
IsWaitingForSyncApproval		YesNo	0
Item	Item (FullName)	Dropdown	31
LastModifiedDate		DateTime	255
Location	InventoryControlLocation (FullName)	Dropdown	0
Notes		Text	4000
Rate		Money	0
RecordID		Integer	0
SalesTaxCode	SalesTaxCode (Name)	Dropdown	3
TimeCreated		DateTime	0
TimeModifiedAccounting		DateTime	0
TimeTrackingEndTime		DateTime	255
TimeTrackingStartTime		DateTime	255
TxnDate		DateTime	0
TxnID		Text	100
TxnNumber		Integer	0

Transaction QuickBooks Table


Account	Account (FullName)	Dropdown	0
AccountNumber		Text	50
AccountTxn		Text	0
Amount		Money	0
AmountForAccountBalance		Money	0
AmountForEntityBalance		Money	0
DueDate		DateTime	0
Entity	Entity (FullName)	Dropdown	0
EntityTxn		Text	1000
EntityType		Text	25
IsDetailLine		YesNo	0
IsPostedToAccounting		YesNo	0
IsWaitingForSyncApproval		YesNo	0
Memo		Text	4094
RecordID		Integer	0
RefNumber		Text	21
TimeModified		DateTime	100
TxnDate		DateTime	0
TxnDetailRecordID		Integer	0
TxnMethodFlag		Text	31
TxnRecordID		Integer	0
TxnType		Text	25
TxnTypeParent		Text	100

Users Method Table


ActivitiesDefaultDisplay		Text	255
ContactsDefaultDisplay		Text	255
CRMActivityDefaultActivityPriority	ActivityPriority (ActivityPriority)	Dropdown	-1
CRMActivityDefaultActivityType	ActivityType (ActivityType)	Dropdown	-1
CRMActivityDefaultActivityTypeAppointment	ActivityType (ActivityType)	Dropdown	-1
CRMActivityDefaultActivityTypePhoneCall	ActivityType (ActivityType)	Dropdown	-1
CRMActivityDefaultActivityTypeTasks	ActivityType (ActivityType)	Dropdown	-1
CRMActivityDefaultFollowupDays		Integer	255
CRMActivityDefaultFollowupPriority	ActivityPriority (ActivityPriority)	Dropdown	-1
CRMActivityDefaultFollowupStatus	ActivityStatus (ActivityStatus)	Dropdown	-1
CRMActivityDefaultFollowupType	ActivityType (ActivityType)	Dropdown	-1
CRMActivityDefaultOptOutOfEmail		YesNo	0
CRMActivityDefaultStatus	ActivityStatus (ActivityStatus)	Dropdown	-1
CRMCaseIsDefaultNewCaseNotificationToContact		YesNo	255
EmailSignature		Text	15000
Entity	Entity (FullName)	Dropdown	0
Grouping		Text	1000
IsActive		YesNo	0
isClassicMobileEnabled		YesNo	0
LastInvitationTimestamp		DateTime	0
MappingEndingAddress		Text	255
MappingStartingAddress		Text	255
NewContactEntityPreference		Text	255
RecordID		Integer	0
Roles		Text	1000
UserEmail		Text	255
UserName		Text	25
WorkOrderDefaultDisplay		Text	255

UsersSignInLog Method Table


CompanyAccount	Text	100
EmailAddress	Text	1023
IsThirdPartyPortal	YesNo	0
RecordID	Integer	0
SignInAs	Text	25
SignInDate	DateTime	0
SignInExpiryDate	DateTime	0
SignInIPAddress	Text	25
SignInIsActive	YesNo	0
SignInLastPromptedDate	DateTime	0
SignOutDate	DateTime	0
ThirdPartyPortalLoginRecordID	Integer	0
ThirdPartyPortalLoginTable	Text	100
UserName	Integer	0

Vendor QuickBooks Table


AccountNumber		Text	100
AltContact		Text	31
AltPhone		Text	30
AssignedTo	Users (UserName)	Dropdown	-1
Balance		Money	0
BillAddressAttentionTo		Text	255
Campaign	Campaign (Name)	Dropdown	-1
CompanyName		Text	100
Contact		Text	450
CreatedDate		DateTime	255
CreditLimit		Decimal	0
Currency	Currency (CurrencyCode)	Dropdown	0
CustomerHealthScore		Decimal	0
DirectDial		Text	80
EditSequence		Text	50
Email		Text	100
EntityType		Text	20
Fax		Text	30
FirstName		Text	100
FullName		Text	450
IsActive		YesNo	0
IsLeadStatusOnly		YesNo	0
IsTaxable		YesNo	0
IsVendorEligibleFor1099		YesNo	0
LastCompletedActivity	Activity (RecordID)	Dropdown	0
↳ LastActivityCompletedDate	(ActualCompletedDate)	Linked	255
LastInvoiceRecordID	Invoice (RecordID)	Dropdown	0
↳ LastInvoiceRecordIDAmount	(Amount)	Linked	0
↳ LastInvoiceRecordIDTxnDate	(TxnDate)	Linked	0
LastModifiedDate		DateTime	255
LastName		Text	100
LastSalesReceiptRecordID	SalesReceipt (RecordID)	Dropdown	0
↳ LastSalesReceiptRecordIDTotalAmount	(TotalAmount)	Linked	0
↳ LastSalesReceiptRecordIDTxnDate	(TxnDate)	Linked	0
Latitude		Decimal	2
LeadConvertedDate		DateTime	255
LeadRating	LeadRating (LeadRating)	Dropdown	50
LeadSource	LeadSource (LeadSource)	Dropdown	-1
LeadStatus	LeadStatus (LeadStatus)	Dropdown	50
LifetimeValue		Decimal	2
ListID		Text	100
Longitude		Decimal	2
MergeOnNextSyncTo	Entity (FullName)	Dropdown	0
MiddleName		Text	100
Mobile		Text	30
Name		Text	450
NameOnCheck		Text	110
NextPendingActivity	Activity (RecordID)	Dropdown	0
↳ NextActivityDueDate	(DueDateStart)	Linked	-1
Notes		Text	4095
OverdueARBalance		Money	255
OverduePayBalance		Money	255
Pager		Text	21
Paybalance		Money	255
Phone		Text	30
PortalPassword		Text	10
PortalUserName		Text	10
PrintAs		Text	110
RecordID		Integer	0
SalesRep	SalesRep (Initial)	Dropdown	5
↳ SalesRepRecordID	(RecordID)	Linked	0
Salutation		Text	16
ShipAddressAttentionTo		Text	255
SkypeUserName		Text	32
Suffix		Text	16
TaxExemptionReason	TaxExemptionReason (Reason)	Dropdown	0
TaxNumber		Text	50
Terms	Terms (Name)	Dropdown	100
TimeCreated		DateTime	0
TimeModifiedAccounting		DateTime	0
VendorAddressAddr1		Text	500
VendorAddressAddr2		Text	500
VendorAddressAddr3		Text	500
VendorAddressAddr4		Text	500
VendorAddressAddr5		Text	500
VendorAddressCity		Text	255
VendorAddressCountry		Text	255
VendorAddressNote		Text	41
VendorAddressPostalCode		Text	30
VendorAddressState		Text	255
VendorTaxIdent		Text	15
VendorType	VendorType (FullName)	Dropdown	0

VendorCredit QuickBooks Table


APAccount	Account (FullName)	Dropdown	0
Campaign	Campaign (Name)	Dropdown	-1
CreditAmount		Money	0
CreditAmountInHomeCurrency		Decimal	0
Currency	Currency (CurrencyCode)	Dropdown	0
EditSequence		Text	50
ExchangeRate		Decimal	0
IsWaitingForSyncApproval		YesNo	0
LastModifiedDate		DateTime	255
Location	InventoryControlLocation (FullName)	Dropdown	-1
↳ LocationRoot	(RootName)	Linked	255
Memo		Text	4000
OpenAmount		Money	0
RecordID		Integer	0
RefNumber		Text	21
TimeCreated		DateTime	0
TimeModifiedAccounting		DateTime	0
TxnDate		DateTime	0
TxnID		Text	100
TxnMethodFlag		Text	31
TxnNumber		Integer	0
Vendor	Entity (FullName)	Dropdown	0

VendorCreditLineExpense QuickBooks Table


Account	Account (FullName)	Dropdown	0
Amount		Money	0
BillableStatus	BillableStatus (BillableStatus)	Dropdown	0
Class	Class (FullName)	Dropdown	0
Customer	Entity (FullName)	Dropdown	0
LastModifiedDate		DateTime	255
Memo		Text	4000
RecordID		Integer	0
SalesTaxCode	SalesTaxCode (Name)	Dropdown	0
TxnLineID		Text	100
TxnMethodFlag		Text	31
VendorCreditRecordID	VendorCredit (RecordID)	Dropdown	0

VendorType QuickBooks Table


EditSequence		Text	50
FullName		Text	159
IsActive		YesNo	0
LastModifiedDate		DateTime	255
ListID		Text	100
Name		Text	31
ParentFullName	VendorType (FullName)	Dropdown	159
RecordID		Integer	0
Sublevel		Integer	0
TimeCreated		DateTime	0
TimeModifiedAccounting		DateTime	0

WorkOrderReminders Method Table


LastModifiedDate		DateTime	255
RecordID		Integer	0
ReminderType	ReminderTypes (ReminderTypeName)	Dropdown	0
WorkOrder	Activity (RecordID)	Dropdown	0
↳ WorkOrderCustomerRecordID	(EntityRef_RecordID)	Linked	0
↳ WorkOrderDueDateStart	(DueDateStart)	Linked	0

customerequipment Method Table


DateAcquired	DateTime	0
DateSold	DateTime	0
Description	Text	4000
LastModifiedDate	DateTime	255
Make	Text	50
Model	Text	50
ModelNumber	Text	30
Name	Text	70
RecordID	Integer	0
SerialNumber	Text	30
Warranty	Text	4000
WarrantyExpiryLabor	DateTime	0
WarrantyExpiryParts	DateTime	0
WarrantyMiles	Decimal	2

ountingConflicts Method Table


BlnResolved	YesNo	0
ConflictDate	DateTime	0
ConflictReason	Text	4000
ConflictRecordID	Integer	0
ConflictTableNameFriendly	Text	100
ConflictType	Text	50
ConflictUserID	Integer	0
ConflictXml	Text	8000
EntityTypeFriendly	Text	255
NameOrRefNumber	Text	255
RecordID	Integer	0
SyncRequestKey	Text	50