Method QuickBooks Desktop Table Documentation

Legend:
Text
Integer
Decimal
Money
Yes/No
Date/Time
File
Picture
Dropdown
Linked
QuickBooks Sync
Method Only
Required
Unique
Stock Tables List
ARRefundCreditCard QuickBooks Table
AddressAddr1 Text 41
AddressAddr2 Text 41
AddressAddr3 Text 41
AddressAddr4 Text 41
AddressAddr5 Text 41
AddressCity Text 31
AddressCountry Text 31
AddressNote Text 41
AddressPostalCode Text 13
AddressState Text 21
ARAccount Account (FullName) Dropdown 0
AuthorizationCode Text 12
AVSStreet Text 20
AVSZip Text 20
CardSecurityCodeMatch Text 20
ClientTransID Text 16
CommercialCardCode Text 24
CreditCardAddress Text 41
CreditCardNumber Text 25
CreditCardPostalCode Text 18
CreditCardTransID Text 24
Customer Entity (FullName) Dropdown 0
EditSequence Text 50
ExpirationMonth Integer 0
ExpirationYear Integer 0
IsWaitingForSyncApproval YesNo 0
LastModifiedDate DateTime 255
Memo Text 4095
MerchantAccountNumber Text 32
NameOnCard Text 41
PaymentGroupingCode Integer 0
PaymentMethod PaymentMethod (Name) Dropdown 0
PaymentStatus Text 20
ReconBatchID Text 84
RecordID Integer 0
RefNumber Text 11
RefundFromAccount Account (FullName) Dropdown 0
ResultCode Integer 0
ResultMessage Text 60
TimeCreated DateTime 0
TimeModifiedAccounting DateTime 0
TotalAmount Money 0
TransactionMode TransactionMode (TransactionMode) Dropdown 0
TxnAuthorizationStamp Integer 0
TxnAuthorizationTime DateTime 0
TxnDate DateTime 0
TxnID Text 100
TxnMethodFlag Text 31
TxnNumber Integer 0
ARRefundCreditCardAppliedToTxn QuickBooks Table
ARRefundCreditCardRecordID ARRefundCreditCard (RecordID) Dropdown 0
CreditRemaining Money 0
LastModifiedDate DateTime 255
RecordID Integer 0
RefNumber Text 20
RefundAmount Money 0
TxnDate DateTime 0
TxnID Text 100
TxnRecordID Integer 0
TxnType TransactionType (TxnType) Dropdown 0
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 159
IsActive YesNo 0
IsTaxAccount YesNo 0
LastCheckNumber Text 50
LastModifiedDate DateTime 255
ListID Text 100
Name Text 31
ParentFullName Account (FullName) Dropdown 159
RecordID Integer 0
SalesTaxCode SalesTaxCode (Name) Dropdown 0
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 4095
OpenAmount Money 0
PrintOrCheck PrintOrCheck (PrintOrCheck) Dropdown 50
RecordID Integer 0
RefNumber Text 20
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 4095
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 4095
IsMarkupPercent YesNo 0
Item Item (FullName) Dropdown 0
LastModifiedDate DateTime 255
LinkToPurchaseOrder purchaseorderline (RecordID) Dropdown 0
LocationSite InventoryControlLocation (FullName) Dropdown -1
MarkupRate Decimal 0
QuanityOnTransferOrder Decimal 0
Quantity Decimal 0
RecordID Integer 0
SalesTaxCode SalesTaxCode (Name) Dropdown 0
TxnLineID Text 100
TxnMethodFlag Text 31
UnitOfMeasure Text 31
BillPaymentCheck QuickBooks Table
AddressAddr1 Text 41
AddressAddr2 Text 41
AddressAddr3 Text 41
AddressAddr4 Text 41
AddressAddr5 Text 41
AddressCity Text 31
AddressCountry Text 31
AddressNote Text 41
AddressPostalCode Text 13
AddressState Text 21
Amount Money 0
AmountInHomeCurrency Decimal 0
APAccount Account (FullName) Dropdown 0
BankAccount Account (FullName) Dropdown 0
Currency Currency (CurrencyCode) Dropdown 0
EditSequence Text 50
ExchangeRate Decimal 0
IsToBePrinted YesNo 0
IsWaitingForSyncApproval YesNo 0
LastModifiedDate DateTime 255
Memo Text 4095
PayeeEntity Entity (FullName) Dropdown 0
RecordID Integer 0
RefNumber Text 11
TimeCreated DateTime 0
TimeModifiedAccounting DateTime 0
TxnDate DateTime 0
TxnID Text 100
TxnMethodFlag Text 31
TxnNumber Integer 0
BillPaymentCheckAppliedToTxn QuickBooks Table
Amount Money 0
BalanceRemaining Money 0
BillPaymentCheckRecordID BillPaymentCheck (RecordID) Dropdown 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
RecordID Integer 0
RefNumber Text 11
TxnDate DateTime 0
TxnID Text 100
TxnRecordID Integer 0
TxnType TransactionType (TxnType) Dropdown 0
BillPaymentCreditCard QuickBooks Table
Amount Money 0
AmountInHomeCurrency Decimal 0
APAccount Account (FullName) Dropdown 0
CreditCardAccount Account (FullName) Dropdown 0
Currency Currency (CurrencyCode) Dropdown 0
EditSequence Text 50
ExchangeRate Decimal 0
IsWaitingForSyncApproval YesNo 0
LastModifiedDate DateTime 255
Memo Text 4095
PayeeEntity Entity (FullName) Dropdown 0
RecordID Integer 0
RefNumber Text 11
TimeCreated DateTime 0
TimeModifiedAccounting DateTime 0
TxnDate DateTime 0
TxnID Text 100
TxnMethodFlag Text 31
TxnNumber Integer 0
BillPaymentCreditCardAppliedToTxn QuickBooks Table
Amount Money 0
BalanceRemaining Money 0
BillPaymentCreditCard BillPaymentCreditCard (RecordID) Dropdown 0
CreditAmount Money 0
CreditTxnID Text 100
CreditTxnRecordID Integer 0
DiscountAccount Account (FullName) Dropdown 0
DiscountAmount Money 0
LastModifiedDate DateTime 255
RecordID Integer 0
RefNumber Text 11
TxnDate DateTime 0
TxnID Text 100
TxnRecordID Integer 0
TxnType TransactionType (TxnType) Dropdown 0
BillableStatus QuickBooks Table
BillableStatus Text 50
LastModifiedDate DateTime 255
RecordID Integer 0
BillingRate QuickBooks Table
BillingRateType BillingRateType (BillingRateTypeName) Dropdown 20
EditSequence Text 50
FixedBillingRate Money 0
LastModifiedDate DateTime 255
ListID Text 100
Name Text 20
RecordID Integer 0
TimeCreated DateTime 0
TimeModifiedAccounting DateTime 0
BillingRatePerItemRetList QuickBooks Table
BillingRate BillingRate (Name) Dropdown 31
CustomRate Money 0
CustomRatePercent Decimal 0
IsCustomRate YesNo 0
Item Item (FullName) Dropdown 159
LastModifiedDate DateTime 255
RecordID Integer 0
BuildAssembly QuickBooks Table
EditSequence Text 50
IsPending YesNo 0
IsWaitingForSyncApproval YesNo 0
ItemInventoryAssembly Item (FullName) Dropdown 0
LastModifiedDate DateTime 255
Location InventoryControlLocation (FullName) Dropdown -1
↳ LocationRoot (RootName) Linked 255
Memo Text 4095
PlannedFinish DateTime 255
PlannedStart DateTime 255
QuantityCanBuild Decimal 0
QuantityOnHand Decimal 0
QuantityOnSalesOrder Decimal 0
QuantityToBuild Decimal 0
RecordID Integer 0
RefNumber Text 11
TimeCreated DateTime 0
TimeModifiedAccounting DateTime 0
TxnDate DateTime 0
TxnID Text 100
TxnNumber Integer 0
BuildAssemblyLineItem QuickBooks Table
BuildAssemblyRecordID BuildAssembly (RecordID) Dropdown 0
ComponentDesc Text 4095
ComponentItem Item (FullName) Dropdown 0
ComponentQuantityNeeded Decimal 0
ComponentQuantityOnHand Decimal 0
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
Charge QuickBooks Table
Amount Money 0
ARAccount Account (FullName) Dropdown 0
BalanceRemaining Money 0
BilledDate DateTime 0
Campaign Campaign (Name) Dropdown -1
Class Class (FullName) Dropdown 0
Customer Entity (FullName) Dropdown 0
Desc Text 4095
DueDate DateTime 0
EditSequence Text 50
IsPaid YesNo 0
IsWaitingForSyncApproval YesNo 0
Item Item (FullName) Dropdown 0
LastModifiedDate DateTime 255
Quantity Decimal 0
Rate Decimal 5
RecordID Integer 0
RefNumber Text 11
TimeCreated DateTime 0
TimeModifiedAccounting DateTime 0
TxnDate DateTime 0
TxnID Integer 0
TxnMethodFlag Text 31
TxnNumber Integer 0
Check QuickBooks Table
Account Account (FullName) Dropdown 0
AddressAddr1 Text 41
AddressAddr2 Text 41
AddressAddr3 Text 41
AddressAddr4 Text 41
AddressAddr5 Text 41
AddressCity Text 31
AddressCountry Text 31
AddressNote Text 41
AddressPostalCode Text 13
AddressState Text 21
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 4095
PayeeEntity Entity (FullName) Dropdown 0
RecordID Integer 0
RefNumber Text 11
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
BillableStatus BillableStatus (BillableStatus) Dropdown 0
CheckRecordID Check (RecordID) Dropdown 0
Class Class (FullName) Dropdown 0
Customer Entity (FullName) Dropdown 0
LastModifiedDate DateTime 255
Memo Text 4095
RecordID Integer 0
SalesTaxCode SalesTaxCode (Name) Dropdown 0
TxnLineID Text 100
TxnMethodFlag Text 31
CheckLineItem QuickBooks Table
Amount Money 0
BillableStatus BillableStatus (BillableStatus) Dropdown 0
CheckLineItemGroupRecordID CheckLineItem (RecordID) Dropdown 0
CheckRecordID Check (RecordID) Dropdown 0
Class Class (FullName) Dropdown 0
Cost Decimal 5
Customer Entity (FullName) Dropdown 0
Desc Text 4095
Item Item (FullName) Dropdown 0
LastModifiedDate DateTime 255
QuanityOnTransferOrder Decimal 0
Quantity Decimal 0
RecordID Integer 0
SalesTaxCode SalesTaxCode (Name) Dropdown 0
TxnLineID Text 100
TxnMethodFlag Text 31
UnitOfMeasure Text 31
Class QuickBooks Table
EditSequence Text 50
FullName Text 159
IsActive YesNo 0
LastModifiedDate DateTime 255
ListID Text 100
Name Text 31
ParentFullName Class (FullName) Dropdown 159
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 59
AddressAddr1 Text 41
AddressAddr2 Text 41
AddressAddr3 Text 41
AddressAddr4 Text 41
AddressAddr5 Text 41
AddressAttentionTo Text 255
AddressCity Text 31
AddressCountry Text 31
AddressNote Text 41
AddressPostalCode Text 13
AddressState Text 21
CompanyAddressForCustomerAddr1 Text 41
CompanyAddressForCustomerAddr2 Text 41
CompanyAddressForCustomerAddr3 Text 41
CompanyAddressForCustomerAddr4 Text 41
CompanyAddressForCustomerAddr5 Text 41
CompanyAddressForCustomerAttentionTo Text 255
CompanyAddressForCustomerCity Text 31
CompanyAddressForCustomerCountry Text 31
CompanyAddressForCustomerNote Text 41
CompanyAddressForCustomerPostalCode Text 13
CompanyAddressForCustomerState Text 21
CompanyName Text 59
CompanyType Text 255
CompanyWebSite Text 100
CurrencyCode Text 3
CurrencySymbol Text 10
Edition Text 50
EIN Text 20
Email Text 1023
Fax Text 51
FirstMonthFiscalYear Text 20
FirstMonthIncomeTaxYear Text 20
IndustryCode Text 50
IsItemCategoriesFeatureEnabled YesNo 0
IsSampleCompany YesNo 0
LastModifiedDate DateTime 255
LegalAddressAddr1 Text 41
LegalAddressAddr2 Text 41
LegalAddressAddr3 Text 41
LegalAddressAddr4 Text 41
LegalAddressAddr5 Text 41
LegalAddressCity Text 31
LegalAddressCountry Text 31
LegalAddressNote Text 41
LegalAddressPostalCode Text 13
LegalAddressState Text 21
LegalCompanyName Text 59
NP501Status Text 255
NPAggregateReportSignOff Text 1500
NPAggregateReportStatement Text 1500
NPFederalIdentificationNo Text 255
NPReceiptStatement Text 1500
OfferingSKU Text 50
Phone Text 51
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 4095
PayeeEntity Entity (FullName) Dropdown 0
RecordID Integer 0
RefNumber Text 11
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
BillableStatus BillableStatus (BillableStatus) Dropdown 0
Class Class (FullName) Dropdown 0
CreditCardChargeRecordID CreditCardCharge (RecordID) Dropdown 0
Customer Entity (FullName) Dropdown 0
LastModifiedDate DateTime 255
Memo Text 4095
RecordID Integer 0
SalesTaxCode SalesTaxCode (Name) Dropdown 0
TxnLineID Text 100
TxnMethodFlag Text 31
CreditCardChargeLineItem QuickBooks Table
Amount Money 0
BillableStatus BillableStatus (BillableStatus) Dropdown 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 4095
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
UnitOfMeasure 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 4095
PayeeEntity Entity (FullName) Dropdown 0
RecordID Integer 0
RefNumber Text 11
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
BillableStatus BillableStatus (BillableStatus) Dropdown 0
Class Class (FullName) Dropdown 0
CreditCardCreditRecordID CreditCardCredit (RecordID) Dropdown 0
Customer Entity (FullName) Dropdown 0
LastModifiedDate DateTime 255
Memo Text 4095
RecordID Integer 0
SalesTaxCode SalesTaxCode (Name) Dropdown 0
TxnLineID Text 100
TxnMethodFlag Text 31
CreditCardCreditLineItem QuickBooks Table
Amount Money 0
BillableStatus BillableStatus (BillableStatus) Dropdown 0
Class Class (FullName) Dropdown 0
Cost Decimal 5
CreditCardCreditLineItemGroupRecordID CreditCardCreditLineItem (RecordID) Dropdown 0
CreditCardCreditRecordID CreditCardCredit (RecordID) Dropdown 0
Customer Entity (FullName) Dropdown 0
Desc Text 4095
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
UnitOfMeasure Text 31
CreditMemo QuickBooks Table
ARAccount Account (FullName) Dropdown 209
AssignedTo Users (UserName) Dropdown -1
BillAddressAddr1 Text 41
BillAddressAddr2 Text 41
BillAddressAddr3 Text 41
BillAddressAddr4 Text 41
BillAddressAddr5 Text 41
BillAddressCity Text 31
BillAddressCountry Text 31
BillAddressNote Text 41
BillAddressPostalCode Text 13
BillAddressState Text 21
BillEmail Text 100
Campaign Campaign (Name) Dropdown -1
Class Class (FullName) Dropdown 209
CreditRemaining Money 0
CreditRemainingInHomeCurrency Decimal 0
Currency Currency (CurrencyCode) Dropdown 0
Customer Entity (FullName) Dropdown 209
CustomerMessage CustomerMsg (Name) Dropdown 101
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 4095
Opportunity Opportunity (RecordID) Dropdown -1
Other Text 29
PaymentMethod PaymentMethod (Name) Dropdown 0
PONumber Text 25
RecordID Integer 0
RefNumber Text 11
SalesRep SalesRep (Initial) Dropdown 5
SalesTaxPercentage Decimal 0
SalesTaxTotal Money 0
ShipAddressAddr1 Text 41
ShipAddressAddr2 Text 41
ShipAddressAddr3 Text 41
ShipAddressAddr4 Text 41
ShipAddressAddr5 Text 41
ShipAddressCity Text 31
ShipAddressCountry Text 31
ShipAddressNote Text 41
ShipAddressPostalCode Text 13
ShipAddressState Text 21
ShipDate DateTime 0
ShipMethod ShipMethod (Name) Dropdown 31
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 31
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 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
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
AccountNumber Text 99
AltContact Text 41
AltPhone Text 21
AssignedTo Users (UserName) Dropdown -1
Balance Money 0
BillAddressAddr1 Text 41
BillAddressAddr2 Text 41
BillAddressAddr3 Text 41
BillAddressAddr4 Text 41
BillAddressAddr5 Text 41
BillAddressAttentionTo Text 255
BillAddressCity Text 31
BillAddressCountry Text 31
BillAddressNote Text 41
BillAddressPostalCode Text 13
BillAddressState Text 21
Campaign Campaign (Name) Dropdown -1
Class Class (FullName) Dropdown 0
CompanyName Text 41
Contact Text 41
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 159
DeliveryMethod DeliveryMethod (DeliveryMethodName) Dropdown 0
DirectDial Text 80
EditSequence Text 50
Email Text 1023
EntityType Text 20
ExpirationMonth Integer 0
ExpirationYear Integer 0
Fax Text 21
FirstName Text 41
FullName Text 209
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
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 41
JobType JobType (FullName) Dropdown 159
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 25
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 5
Name Text 41
NameOnCard Text 41
NextPendingActivity Activity (RecordID) Dropdown 0
↳ NextActivityDueDate (DueDateStart) Linked -1
Notes Text 4095
OverdueARBalance Money 255
OverduePayBalance Money 255
Pager Text 21
ParentFullName Entity (FullName) Dropdown 0
Phone Text 21
PortalPassword Text 10
PortalUserName Text 10
PreferredPaymentMethod PaymentMethod (Name) Dropdown 31
PriceLevel PriceLevel (Name) Dropdown 31
PrintAs Text 41
RecordID Integer 0
ResaleNumber Text 15
SalesRep SalesRep (Initial) Dropdown 5
↳ SalesRepRecordID (RecordID) Linked 0
SalesTaxCode SalesTaxCode (Name) Dropdown 31
SalesTaxCountry Text 50
SalesTaxItem Item (FullName) Dropdown 31
Salutation Text 16
ShipAddressAddr1 Text 41
ShipAddressAddr2 Text 41
ShipAddressAddr3 Text 41
ShipAddressAddr4 Text 41
ShipAddressAddr5 Text 41
ShipAddressAttentionTo Text 255
ShipAddressCity Text 31
ShipAddressCountry Text 31
ShipAddressNote Text 41
ShipAddressPostalCode Text 13
ShipAddressState Text 21
Sublevel Integer 0
Suffix Text 16
TaxExemptionReason TaxExemptionReason (Reason) Dropdown 0
Terms Terms (Name) Dropdown 31
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
CustomerMsg QuickBooks Table
EditSequence Text 50
IsActive YesNo 0
LastModifiedDate DateTime 255
ListID Text 100
Name Text 101
RecordID Integer 0
TimeCreated DateTime 0
TimeModifiedAccounting DateTime 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 159
IsActive YesNo 0
LastModifiedDate DateTime 255
ListID Text 100
Name Text 31
ParentFullName CustomerType (FullName) Dropdown 159
RecordID Integer 0
Sublevel Integer 0
TimeCreated DateTime 0
TimeModifiedAccounting DateTime 0
Deposit QuickBooks Table
CashBackAccount Account (FullName) Dropdown 0
CashBackAmount Money 0
CashBackMemo Text 4095
CashBackTxnLineID Text 100
Currency Currency (CurrencyCode) Dropdown 0
DepositToAccount Account (FullName) Dropdown 0
DepositTotal Money 0
DepositTotalInHomeCurrency Decimal 0
EditSequence Text 50
ExchangeRate Decimal 0
IsWaitingForSyncApproval YesNo 0
LastModifiedDate DateTime 255
Memo Text 4095
RecordID Integer 0
TimeCreated DateTime 0
TimeModifiedAccounting DateTime 0
TxnDate DateTime 0
TxnID Text 100
TxnMethodFlag Text 31
TxnNumber Integer 0
DepositLine QuickBooks Table
Account Account (FullName) Dropdown 0
Amount Money 0
CheckNumber Text 11
Class Class (FullName) Dropdown 0
DepositRecordID Deposit (RecordID) Dropdown 0
Entity Entity (FullName) Dropdown 0
LastModifiedDate DateTime 255
Memo Text 4095
PaymentMethod PaymentMethod (Name) Dropdown 0
PaymentTxnLineID Text 100
RecordID Integer 0
TxnID Text 100
TxnLineID Text 100
TxnMethodFlag Text 31
TxnRecordID Integer 0
TxnType TransactionType (TxnType) Dropdown 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
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
BillingRate BillingRate (Name) Dropdown 0
BirthDate DateTime 0
Campaign Campaign (Name) Dropdown -1
Class Class (FullName) Dropdown 159
ClearEarnings YesNo 0
CreatedDate DateTime 255
Currency Currency (CurrencyCode) Dropdown 0
CustomerHealthScore Decimal 0
DirectDial Text 80
EditSequence Text 50
Email Text 1023
EmployeeAddressAddr1 Text 41
EmployeeAddressAddr2 Text 41
EmployeeAddressAddr3 Text 41
EmployeeAddressAddr4 Text 41
EmployeeAddressCity Text 31
EmployeeAddressCountry Text 31
EmployeeAddressPostalCode Text 13
EmployeeAddressState Text 21
EmployeeType EmployeeType (Name) Dropdown 50
EntityType Text 20
Fax Text 21
FirstName Text 41
FullName Text 450
Gender EmployeeGender (GenderName) Dropdown 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
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 25
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 5
Mobile Text 21
Name Text 41
NextPendingActivity Activity (RecordID) Dropdown 0
↳ NextActivityDueDate (DueDateStart) Linked -1
Notes Text 4095
OverdueARBalance Money 255
OverduePayBalance Money 255
Pager Text 21
PagerPIN Text 21
Paybalance Money 255
PayPeriod PayPeriod (PayPeriodName) Dropdown 50
Phone Text 21
PortalPassword Text 10
PortalUserName Text 10
PrintAs Text 41
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 50
VacationHoursAccrualStartDate DateTime 0
VacationHoursIsResettingHoursEachNewYear YesNo 0
VacationHoursMaximumSeconds Integer 0
VacationHoursSecondsAccrued Integer 0
VacationHoursSecondsAvailable Integer 0
VacationHoursSecondsUsed Integer 0
EmployeeEarningsRetList QuickBooks Table
Employee Entity (FullName) Dropdown 159
IsRate YesNo 0
LastModifiedDate DateTime 255
PayrollItemRefID PayrollItemWage (Name) Dropdown 0
Rate Decimal 0
RatePercent Decimal 0
RecordID Integer 0
EmployeeGender QuickBooks Table
GenderName Text 50
LastModifiedDate DateTime 255
RecordID Integer 0
Entity QuickBooks Table
AccountNumber Text 99
AccrualPeriodVacationName EmployeeAccrualPeriodVacation (AccrualPeriodVacationName) Dropdown 50
AltContact Text 41
AltPhone Text 21
AssignedTo Users (UserName) Dropdown -1
Balance Money 0
BillAddressAddr1 Text 41
BillAddressAddr2 Text 41
BillAddressAddr3 Text 41
BillAddressAddr4 Text 41
BillAddressAddr5 Text 41
BillAddressAttentionTo Text 255
BillAddressCity Text 31
BillAddressCountry Text 31
BillAddressNote Text 41
BillAddressPostalCode Text 13
BillAddressState Text 21
BirthDate DateTime 0
Campaign Campaign (Name) Dropdown -1
Class Class (FullName) Dropdown 159
ClearEarnings YesNo 0
CompanyName Text 41
Contact Text 41
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 159
DeliveryMethod DeliveryMethod (DeliveryMethodName) Dropdown 0
DirectDial Text 80
EditSequence Text 50
Email Text 1023
EmployeeType EmployeeType (Name) Dropdown 50
EntityType Text 20
ExpirationMonth Integer 0
ExpirationYear Integer 0
Fax Text 21
FirstName Text 41
FullName Text 209
Gender EmployeeGender (GenderName) Dropdown 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
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 41
JobType JobType (FullName) Dropdown 159
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 25
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 5
Name Text 41
NameOnCard Text 41
NameOnCheck Text 41
NextPendingActivity Activity (RecordID) Dropdown 0
↳ NextActivityDueDate (DueDateStart) Linked -1
Notes Text 4095
OverdueARBalance Money 255
OverduePayBalance Money 255
Pager Text 21
PagerPIN Text 21
ParentFullName Entity (FullName) Dropdown 0
PayPeriod PayPeriod (PayPeriodName) Dropdown 50
Phone Text 21
PortalPassword Text 10
PortalUserName Text 10
PreferredPaymentMethod PaymentMethod (Name) Dropdown 31
PriceLevel PriceLevel (Name) Dropdown 31
PrintAs Text 41
RecordID Integer 0
ReleasedDate DateTime 0
ResaleNumber Text 15
SalesRep SalesRep (Initial) Dropdown 5
↳ SalesRepRecordID (RecordID) Linked 0
SalesTaxCode SalesTaxCode (Name) Dropdown 31
SalesTaxCountry Text 50
SalesTaxItem Item (FullName) Dropdown 31
Salutation Text 16
ShipAddressAddr1 Text 41
ShipAddressAddr2 Text 41
ShipAddressAddr3 Text 41
ShipAddressAddr4 Text 41
ShipAddressAddr5 Text 41
ShipAddressAttentionTo Text 255
ShipAddressCity Text 31
ShipAddressCountry Text 31
ShipAddressNote Text 41
ShipAddressPostalCode Text 13
ShipAddressState Text 21
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 31
TimeCreated DateTime 0
TimeModifiedAccounting DateTime 0
TotalBalance Money 0
UseTimeDataToCreatePaychecks EmployeeUseTimeDataToCreatePaychecks (UseTimeDataToCreatePaychecks) Dropdown 50
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 159
Estimate QuickBooks Table
AcceptedBy Text 50
AcceptedDate DateTime 0
Activity Activity (RecordID) Dropdown -1
AssignedTo Users (UserName) Dropdown -1
BillAddressAddr1 Text 41
BillAddressAddr2 Text 41
BillAddressAddr3 Text 41
BillAddressAddr4 Text 41
BillAddressAddr5 Text 41
BillAddressCity Text 31
BillAddressCountry Text 31
BillAddressNote Text 41
BillAddressPostalCode Text 13
BillAddressState Text 21
Campaign Campaign (Name) Dropdown -1
Class Class (FullName) Dropdown 209
Currency Currency (CurrencyCode) Dropdown 0
↳ CurrencySymbol (CurrencySymbol) Linked 10
Customer Entity (FullName) Dropdown 209
CustomerMessage CustomerMsg (Name) Dropdown 101
CustomerMsgText Text 1000
CustomerSalesTaxCode SalesTaxCode (Name) Dropdown 3
DepositAmount Money 0
DueDate DateTime 0
EditSequence Text 50
EstimateStatus EstimateStatus (Name) Dropdown 0
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
ItemSalesTax Item (FullName) Dropdown 31
Job Jobs (RecordID) Dropdown 0
LastModifiedDate DateTime 255
Location InventoryControlLocation (FullName) Dropdown 0
Memo Text 4095
Opportunity Opportunity (RecordID) Dropdown -1
Other Text 29
PONumber Text 25
RecordID Integer 0
RefNumber Text 11
SalesRep SalesRep (Initial) Dropdown 0
SalesTaxPercentage Decimal 0
SalesTaxTotal Money 0
ShipAddressAddr1 Text 41
ShipAddressAddr2 Text 41
ShipAddressAddr3 Text 41
ShipAddressAddr4 Text 41
ShipAddressAddr5 Text 41
ShipAddressCity Text 31
ShipAddressCountry Text 31
ShipAddressNote Text 41
ShipAddressPostalCode Text 13
ShipAddressState Text 21
Subtotal Money 0
TagList Text 4000
TaxCalculation TaxCalculationType (Name) Dropdown 0
Template Template (Name) Dropdown 31
Terms Terms (Name) Dropdown 31
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 4095
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
LocationSite InventoryControlLocation (FullName) Dropdown -1
MarkupRate Decimal 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
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
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
LegalName Text 500
Name Text 1000
PostalCode Text 60
RecordID Integer -1
Status Integer -1
UpdatedAt DateTime -1
InvPurchaseOrderFulfilment Method Table
BilledStatus Integer -1
DateFulfilled DateTime 255
FulfilmentType Text 50
IsDeleted Integer -1
LastModifiedDate DateTime 255
PurchaseOrder PurchaseOrder (RecordID) Dropdown 0
RecordID Integer -1
InvPurchaseOrderFulfilmentLine Method Table
BilledStatus Integer -1
CreatedAt DateTime -1
FulfilledQuantity Decimal 0
FulfilmentAmount Money -1
FulfilmentRate Decimal 0
InvLocation InvLocation (RecordID) Dropdown 0
InvPurchaseOrderFulfilment InvPurchaseOrderFulfilment (RecordID) Dropdown 0
IsDeleted Integer -1
Item Item (RecordID) Dropdown 0
LastModifiedDate DateTime 255
OrderedQuantity Decimal 0
PurchaseOrderLine PurchaseOrderLine (RecordID) Dropdown 0
RecordID Integer -1
UpdatedAt DateTime -1
InvSalesOrderFulfilment Method Table
DateFulfilled DateTime 255
FulfilmentType Text 50
InvoicedStatus Integer -1
IsDeleted Integer -1
LastModifiedDate DateTime 255
RecordID Integer -1
SalesOrder SalesOrder (RecordID) Dropdown 0
InvSalesOrderFulfilmentLine Method Table
CreatedAt DateTime -1
FulfilledQuantity Decimal 0
FulfilmentAmount Money -1
FulfilmentRate Decimal 0
InvLocation InvLocation (RecordID) Dropdown 0
InvoicedStatus Integer -1
InvSalesOrderFulfilment InvSalesOrderFulfilment (RecordID) Dropdown 0
IsDeleted Integer -1
Item Item (RecordID) Dropdown 0
LastModifiedDate DateTime 255
OrderedQuantity Decimal 0
RecordID Integer -1
SalesOrderLine SalesOrderLine (RecordID) Dropdown 0
UpdatedAt DateTime -1
InvStockAdjustment Method Table
Account Account (RecordID) Dropdown 0
CreatedAt DateTime -1
Description Text 500
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 4095
RecordID Integer 0
RefNumber Text 11
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 209
AssignedTo Users (UserName) Dropdown -1
BalanceRemaining Money 0
BalanceRemainingInHomeCurrency Decimal 0
BillAddressAddr1 Text 41
BillAddressAddr2 Text 41
BillAddressAddr3 Text 41
BillAddressAddr4 Text 41
BillAddressAddr5 Text 41
BillAddressCity Text 31
BillAddressCountry Text 31
BillAddressNote Text 41
BillAddressPostalCode Text 13
BillAddressState Text 21
Campaign Campaign (Name) Dropdown -1
Cards YesNo 0
Class Class (FullName) Dropdown 209
Currency Currency (CurrencyCode) Dropdown 0
↳ CurrencySymbol (CurrencySymbol) Linked 10
Customer Entity (FullName) Dropdown 209
CustomerMessage CustomerMsg (Name) Dropdown 101
CustomerSalesTaxCode SalesTaxCode (Name) Dropdown 3
DepositToAccount Account (FullName) Dropdown 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
IsFinanceCharge YesNo 0
IsPaid YesNo 0
IsPending YesNo 0
IsTaxIncluded YesNo 0
IsToBeEmailed YesNo 0
IsToBePrinted YesNo 0
IsWaitingForSyncApproval YesNo 0
ItemSalesTax Item (FullName) Dropdown 31
Job Jobs (RecordID) Dropdown 0
LastModifiedDate DateTime 255
Location InventoryControlLocation (FullName) Dropdown -1
↳ LocationRoot (RootName) Linked 255
Memo Text 4095
Opportunity Opportunity (RecordID) Dropdown -1
Other Text 29
PONumber Text 25
ProposalRecordID Proposal (RecordID) Dropdown 0
RecordID Integer 0
RefNumber Text 11
SalesRep SalesRep (Initial) Dropdown 5
SalesTaxPercentage Decimal 0
SalesTaxTotal Money 0
ShipAddressAddr1 Text 41
ShipAddressAddr2 Text 41
ShipAddressAddr3 Text 41
ShipAddressAddr4 Text 41
ShipAddressAddr5 Text 41
ShipAddressCity Text 31
ShipAddressCountry Text 31
ShipAddressNote Text 41
ShipAddressPostalCode Text 13
ShipAddressState Text 21
ShipDate DateTime 0
ShipMethod ShipMethod (Name) Dropdown 31
Subtotal Money 0
SuggestedDiscountAmount Money 0
SuggestedDiscountDate DateTime 0
TagList Text 4000
TaxCalculation TaxCalculationType (Name) Dropdown 0
Template Template (Name) Dropdown 31
Terms Terms (Name) Dropdown 31
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 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
IncomeAccount Account (FullName) Dropdown 10
InvLocation InvLocation (RecordID) Dropdown 0
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 159
AverageCost Money 0
COGSAccount Account (FullName) Dropdown 159
CriticalLevel Decimal 255
EditSequence Text 50
EstHrs Decimal 2
FullName Text 159
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 159
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 31
ParentFullName Item (FullName) Dropdown 159
PrefVendor Entity (FullName) Dropdown 159
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 4095
SalesPrice Decimal 0
SalesTaxCode SalesTaxCode (Name) Dropdown 3
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
ItemDiscount QuickBooks Table
AlertLevel Decimal 255
CriticalLevel Decimal 255
DiscountAccount Account (FullName) Dropdown 159
DiscountRate Decimal 0
EditSequence Text 50
EstHrs Decimal 2
FullName Text 159
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
IsPricePercent YesNo 0
IsPrintItemsInGroup YesNo 0
IsSerialTrackingRequired YesNo 255
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
MFGLeadTimeUOM MFGLeadTimeUOM (LeadTimeUOM) Dropdown 50
MonitorLevel Text 255
Name Text 31
ParentFullName Item (FullName) Dropdown 159
PriceInclusive Money 0
PurchaseTaxCalculation TaxCalculationType (Name) Dropdown 0
QuantityInStock Decimal 0
RecordID Integer 0
ReplenishLevel Integer 255
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
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
ItemFixedAsset QuickBooks Table
AcquiredAs ItemAcquiredAs (ItemAcquiredAsName) Dropdown 20
AlertLevel Decimal 255
AssetAccount Account (FullName) Dropdown 159
AssetDesc Text 50
AssetNumber Text 10
CostBasis Decimal 0
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
IsPricePercent YesNo 0
IsPrintItemsInGroup YesNo 0
IsSerialTrackingRequired YesNo 255
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
Location Text 50
LotSizeMinimum Decimal 2
LotSizeMultiple Decimal 2
LowLevelCode Text 255
MFGLeadTimeUOM MFGLeadTimeUOM (LeadTimeUOM) Dropdown 50
MonitorLevel Text 255
Name Text 31
Notes Text 4095
PONumber Text 30
PriceInclusive Money 0
PurchaseCost Decimal 0
PurchaseCostInclusive Money 0
PurchaseDate DateTime 0
PurchaseDesc Text 50
PurchaseTaxCalculation TaxCalculationType (Name) Dropdown 0
QuantityInStock Decimal 0
RecordID Integer 0
ReplenishLevel Integer 255
SalesDate DateTime 0
SalesDesc Text 50
SalesExpense Money 0
SalesPrice Decimal 0
SerialNumber Text 30
Sku Text 100
Sublevel Integer 0
TaxCalculation TaxCalculationType (Name) Dropdown 0
TaxClassification TaxClassification (Name) Dropdown 0
TimeCreated DateTime 0
TimeModifiedAccounting DateTime 0
VendorOrPayeeName Text 50
WarrantyExpDate DateTime 30
YearEndAccumulatedDepreciation Decimal 0
YearEndBookValue Decimal 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 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
MFGLeadTimeUOM MFGLeadTimeUOM (LeadTimeUOM) Dropdown 50
MonitorLevel Text 255
Name Text 31
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 159
AverageCost Money 0
COGSAccount Account (FullName) Dropdown 159
CriticalLevel Decimal 255
EditSequence Text 50
EstHrs Decimal 2
FullName Text 159
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 159
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 31
ParentFullName Item (FullName) Dropdown 159
PrefVendor Entity (FullName) Dropdown 159
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 4095
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
ItemInventoryAssembly QuickBooks Table
AlertLevel Decimal 255
AssetAccount Account (FullName) Dropdown 159
AverageCost Money 0
BuildPoint Decimal 0
COGSAccount Account (FullName) Dropdown 159
CriticalLevel Decimal 255
EditSequence Text 50
EstHrs Decimal 2
FullName Text 159
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 159
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
MFGLeadTimeUOM MFGLeadTimeUOM (LeadTimeUOM) Dropdown 50
MonitorLevel Text 255
Name Text 31
ParentFullName Item (FullName) Dropdown 159
PrefVendor Entity (FullName) Dropdown 159
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
ReplenishLevel Integer 255
SalesDesc Text 4095
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
ItemNonInventory QuickBooks Table
AlertLevel Decimal 255
CriticalLevel Decimal 255
EditSequence Text 50
EstHrs Decimal 2
ExpenseAccount Account (FullName) Dropdown 159
FullName Text 159
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 159
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 31
ParentFullName Item (FullName) Dropdown 159
PrefVendor Entity (FullName) Dropdown 159
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 4095
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
ItemOtherCharge QuickBooks Table
AlertLevel Decimal 255
CriticalLevel Decimal 255
EditSequence Text 50
EstHrs Decimal 2
ExpenseAccount Account (FullName) Dropdown 159
FullName Text 159
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 159
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 31
ParentFullName Item (FullName) Dropdown 159
PrefVendor Entity (FullName) Dropdown 159
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 4095
SalesPrice Decimal 0
SalesTaxCode SalesTaxCode (Name) Dropdown 3
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
ItemPayment QuickBooks Table
AlertLevel Decimal 255
CriticalLevel Decimal 255
DepositToAccount Account (FullName) Dropdown 159
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 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
MFGLeadTimeUOM MFGLeadTimeUOM (LeadTimeUOM) Dropdown 50
MonitorLevel Text 255
Name Text 31
PaymentMethod PaymentMethod (Name) Dropdown 31
PurchaseTaxCalculation TaxCalculationType (Name) Dropdown 0
QuantityInStock Decimal 0
RecordID Integer 0
ReplenishLevel Integer 255
Sku Text 100
Sublevel Integer 0
TaxCalculation TaxCalculationType (Name) Dropdown 0
TaxClassification TaxClassification (Name) Dropdown 0
TimeCreated DateTime 0
TimeModifiedAccounting DateTime 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
ItemReceipt QuickBooks Table
APAccount Account (FullName) Dropdown 0
Campaign Campaign (Name) Dropdown -1
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 4095
RecordID Integer 0
RefNumber Text 20
SalesTaxCode SalesTaxCode (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
ItemReceiptLineExpense 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
ItemReceiptRecordID ItemReceipt (RecordID) Dropdown 0
LastModifiedDate DateTime 255
Memo Text 4095
RecordID Integer 0
SalesTaxCode SalesTaxCode (Name) Dropdown 0
TxnLineID Text 100
TxnMethodFlag Text 31
ItemReceiptLineItem QuickBooks Table
Amount Money 0
BillableStatus BillableStatus (BillableStatus) Dropdown 0
Class Class (FullName) Dropdown 0
Cost Decimal 5
Customer Entity (FullName) Dropdown 0
Desc Text 4095
Item Item (FullName) Dropdown 0
ItemReceiptLineItemGroupRecordID ItemReceiptLineItem (RecordID) Dropdown 0
ItemReceiptRecordID ItemReceipt (RecordID) Dropdown 0
LastModifiedDate DateTime 255
LinkToPurchaseOrder purchaseorderline (RecordID) Dropdown 0
QuanityOnTransferOrder Decimal 0
Quantity Decimal 0
RecordID Integer 0
SalesTaxCode SalesTaxCode (Name) Dropdown 0
TxnLineID Text 100
TxnMethodFlag Text 31
UnitOfMeasure Text 31
ItemSalesTax 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 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
MFGLeadTimeUOM MFGLeadTimeUOM (LeadTimeUOM) Dropdown 50
MonitorLevel Text 255
Name Text 31
PurchaseTaxCalculation TaxCalculationType (Name) Dropdown 0
QuantityInStock Decimal 0
RecordID Integer 0
ReplenishLevel Integer 255
SalesTaxReturnLineNumber Text 50
Sku Text 100
Sublevel Integer 0
TaxCalculation TaxCalculationType (Name) Dropdown 0
TaxClassification TaxClassification (Name) Dropdown 0
TaxRate Decimal 0
TaxVendor Entity (FullName) Dropdown 159
TimeCreated DateTime 0
TimeModifiedAccounting DateTime 0
ItemSalesTaxGroup 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 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
MFGLeadTimeUOM MFGLeadTimeUOM (LeadTimeUOM) Dropdown 50
MonitorLevel Text 255
Name Text 31
PurchaseTaxCalculation TaxCalculationType (Name) Dropdown 0
QuantityInStock Decimal 0
RecordID Integer 0
ReplenishLevel Integer 255
Sku Text 100
Sublevel Integer 0
TaxCalculation TaxCalculationType (Name) Dropdown 0
TaxClassification TaxClassification (Name) Dropdown 0
TimeCreated DateTime 0
TimeModifiedAccounting DateTime 0
ItemService QuickBooks Table
AlertLevel Decimal 255
CriticalLevel Decimal 255
EditSequence Text 50
EstHrs Decimal 2
ExpenseAccount Account (FullName) Dropdown 159
FullName Text 159
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 159
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 31
ParentFullName Item (FullName) Dropdown 159
PrefVendor Entity (FullName) Dropdown 159
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 4095
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
ItemSubtotal 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 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
MFGLeadTimeUOM MFGLeadTimeUOM (LeadTimeUOM) Dropdown 50
MonitorLevel Text 255
Name Text 31
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
JobPriority Method Table
JobPriority Text 255
LastModifiedDate DateTime 255
RecordID Integer -1
JobStatus QuickBooks Table
JobStatus Text 50
LastModifiedDate DateTime 255
RecordID Integer 0
JobType QuickBooks Table
EditSequence Text 50
FullName Text 159
IsActive YesNo 0
LastModifiedDate DateTime 255
ListID Text 100
Name Text 50
ParentFullName JobType (FullName) Dropdown 159
RecordID Integer 0
Sublevel Integer 0
TimeCreated DateTime 0
TimeModifiedAccounting DateTime 0
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 4095
RecordID Integer 0
RefNumber Text 11
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 4095
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
OtherName QuickBooks Table
AccountNumber Text 99
AltContact Text 41
AltPhone Text 21
AssignedTo Users (UserName) Dropdown -1
BillAddressAttentionTo Text 255
Campaign Campaign (Name) Dropdown -1
CompanyName Text 41
Contact Text 41
CreatedDate DateTime 255
Currency Currency (CurrencyCode) Dropdown 0
CustomerHealthScore Decimal 0
DirectDial Text 80
EditSequence Text 50
Email Text 1023
EntityType Text 20
Fax Text 21
FirstName Text 41
FullName Text 450
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 25
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 5
Mobile Text 30
Name Text 41
NextPendingActivity Activity (RecordID) Dropdown 0
↳ NextActivityDueDate (DueDateStart) Linked -1
Notes Text 4095
OtherNameAddressAddr1 Text 41
OtherNameAddressAddr2 Text 41
OtherNameAddressAddr3 Text 41
OtherNameAddressAddr4 Text 41
OtherNameAddressAddr5 Text 41
OtherNameAddressCity Text 31
OtherNameAddressCountry Text 31
OtherNameAddressNote Text 41
OtherNameAddressPostalCode Text 13
OtherNameAddressState Text 21
OverdueARBalance Money 255
OverduePayBalance Money 255
Pager Text 21
Paybalance Money 255
Phone Text 21
PortalPassword Text 10
PortalUserName Text 10
PrintAs Text 41
RecordID Integer 0
Salutation Text 16
ShipAddressAttentionTo Text 255
SkypeUserName Text 32
TaxExemptionReason TaxExemptionReason (Reason) Dropdown 0
TaxNumber Text 50
TimeCreated DateTime 0
TimeModifiedAccounting DateTime 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
PriceLevel QuickBooks Table
Currency Currency (CurrencyCode) Dropdown 0
EditSequence Text 50
IsActive YesNo 0
LastModifiedDate DateTime 255
ListID Text 100
Name Text 31
PriceLevelFixedPercentage Decimal 0
PriceLevelType PriceLevelType (PriceLevelTypeName) Dropdown 50
RecordID Integer 0
TimeCreated DateTime 0
TimeModifiedAccounting DateTime 0
PriceLevelPerItemRetList QuickBooks Table
CustomPrice Decimal 0
CustomPricePercent Decimal 0
IsCustomRate YesNo 0
Item Item (FullName) Dropdown 159
LastModifiedDate DateTime 255
PriceLevel PriceLevel (Name) Dropdown 31
RecordID Integer 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 41
BillAddressAddr2 Text 41
BillAddressAddr3 Text 41
BillAddressAddr4 Text 41
BillAddressAddr5 Text 41
BillAddressCity Text 31
BillAddressCountry Text 31
BillAddressNote Text 41
BillAddressPostalCode Text 13
BillAddressState Text 21
BillingStatus Text 100
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 13
FulfilmentStatus Text 100
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 4095
Other1 Text 25
Other2 Text 29
PurchaseOrderStatus PurchaseOrderStatus (Name) Dropdown 0
RecordID Integer 0
RefNumber Text 11
ReleaseDate DateTime 255
SalesTaxCode SalesTaxCode (Name) Dropdown 0
SalesTaxTotal Money 0
ShipAddressAddr1 Text 41
ShipAddressAddr2 Text 41
ShipAddressAddr3 Text 41
ShipAddressAddr4 Text 41
ShipAddressAddr5 Text 41
ShipAddressCity Text 31
ShipAddressCountry Text 31
ShipAddressNote Text 41
ShipAddressPostalCode Text 13
ShipAddressState Text 21
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 99
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
InvInventory InvInventory (RecordID) Dropdown 0
InvLocation InvLocation (RecordID) Dropdown 0
IsManuallyClosed YesNo 0
IsMarkupPercent YesNo 0
IsPrintItemsInGroup YesNo 0
Item Item (FullName) Dropdown 0
↳ ItemQuantityInStock (QuantityInStock) Linked 0
↳ ItemType (ItemType) Linked 0
LastModifiedDate DateTime 255
LineBillingStatus Text 100
LineFulfilmentStatus Text 100
LineOrder Integer 0
LinkToPurchaseOrder purchaseorderline (RecordID) Dropdown 0
ManufacturerPartNumber Text 31
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
QuantityToReceive 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
UnitOfMeasure Text 31
ReceivePayment QuickBooks Table
AdditionalReference Text 255
ARAccount Account (FullName) Dropdown 0
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 25
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 4095
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 20
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 20
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 41
BillAddressAddr2 Text 41
BillAddressAddr3 Text 41
BillAddressAddr4 Text 41
BillAddressAddr5 Text 41
BillAddressCity Text 31
BillAddressCountry Text 31
BillAddressNote Text 41
BillAddressPostalCode Text 13
BillAddressState Text 21
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
FulfilmentStatus Text 100
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
InvoicingStatus Text 100
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 4095
Opportunity Opportunity (RecordID) Dropdown -1
Other Text 29
PONumber Text 25
RecordID Integer 0
RefNumber Text 11
SalesOrderState SalesOrderState (SalesOrderState) Dropdown 0
SalesRep SalesRep (Initial) Dropdown 0
SalesTaxPercentage Decimal 0
SalesTaxTotal Money 0
ShipAddressAddr1 Text 41
ShipAddressAddr2 Text 41
ShipAddressAddr3 Text 41
ShipAddressAddr4 Text 41
ShipAddressAddr5 Text 41
ShipAddressCity Text 31
ShipAddressCountry Text 31
ShipAddressNote Text 41
ShipAddressPostalCode Text 13
ShipAddressState Text 21
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 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
IncomeAccount Account (FullName) Dropdown 0
InvInventory InvInventory (RecordID) Dropdown 0
InvLocation InvLocation (RecordID) 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
↳ ItemQuantityInStock (QuantityInStock) Linked 0
↳ ItemType (ItemType) Linked 0
LastModifiedDate DateTime 255
LineFulfilmentStatus Text 100
LineInvoicingStatus Text 100
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
QuantityToDeliver Decimal 0
Rate Decimal 5
RecordID Integer 0
SalesOrderLineGroupRecordID SalesOrderLine (RecordID) Dropdown 0
SalesOrderRecordID SalesOrder (RecordID) Dropdown 0
↳ SalesOrderFulfilmentStatus (FulfilmentStatus) Linked 0
SalesTaxCode SalesTaxCode (Name) Dropdown 0
SerialNumber Text 4095
TotalAmount Money 0
TxnLineID Text 100
TxnMethodFlag Text 31
UnitOfMeasure 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
AuthorizationCode Text 12
AVSStreet Text 20
AVSZip Text 20
BalanceRemaining Decimal 0
BalanceRemainingInHomeCurrency Decimal 0
BillAddressAddr1 Text 41
BillAddressAddr2 Text 41
BillAddressAddr3 Text 41
BillAddressAddr4 Text 41
BillAddressAddr5 Text 41
BillAddressCity Text 31
BillAddressCountry Text 31
BillAddressNote Text 41
BillAddressPostalCode Text 13
BillAddressState Text 21
BillEmail Text 100
Campaign Campaign (Name) Dropdown -1
CardSecurityCodeMatch Text 20
CheckNumber Text 25
Class Class (FullName) Dropdown 0
ClientTransID Text 16
CommercialCardCode Text 24
CreditCardAddress Text 41
CreditCardNumber Text 25
CreditCardPostalCode Text 18
CreditCardTransID Text 24
Currency Currency (CurrencyCode) Dropdown 0
↳ CurrencySymbol (CurrencySymbol) Linked 10
Customer Entity (FullName) Dropdown 0
↳ FirstName (FirstName) Linked 0
CustomerMsg CustomerMsg (Name) Dropdown 0
CustomerMsgText Text 1000
CustomerSalesTaxCode SalesTaxCode (Name) Dropdown 0
DepositToAccount Account (FullName) Dropdown 0
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
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
IsAnonymousDonation YesNo 0
IsEmailSent YesNo 0
IsInHonour YesNo 0
IsInMemory YesNo 0
IsLetterSent YesNo 0
IsPending YesNo 0
IsReceiptSent 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 4095
MerchantAccountNumber Text 32
NameOnCard Text 41
NPLetterBody Text 15000
Opportunity Opportunity (RecordID) Dropdown -1
Other Text 29
PaymentGroupingCode Integer 0
PaymentMethod PaymentMethod (Name) Dropdown 0
PaymentStatus Text 20
Pledge Pledge (RecordID) Dropdown 0
ReconBatchID Text 84
RecordID Integer 0
RefNumber Text 11
ResultCode Integer 0
ResultMessage Text 60
SalesRep SalesRep (Initial) Dropdown 0
SalesTaxPercentage Decimal 0
SalesTaxTotal Money 0
ShipAddressAddr1 Text 41
ShipAddressAddr2 Text 41
ShipAddressAddr3 Text 41
ShipAddressAddr4 Text 41
ShipAddressAddr5 Text 41
ShipAddressCity Text 31
ShipAddressCountry Text 31
ShipAddressNote Text 41
ShipAddressPostalCode Text 13
ShipAddressState Text 21
ShipDate DateTime 0
ShipMethod ShipMethod (Name) Dropdown 0
ShipTrackingNumber Text 255
Subtotal Money 0
TagList Text 4000
TaxCalculation TaxCalculationType (Name) Dropdown 0
Template Template (Name) Dropdown 0
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
SalesReceiptLine QuickBooks Table
Amount Money 0
AmountInclusive Money 100
Class Class (FullName) Dropdown 0
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
InvLocation InvLocation (RecordID) Dropdown 0
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
LocationSite InventoryControlLocation (FullName) Dropdown -1
Other1 Text 29
Other2 Text 29
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
SalesTaxCode SalesTaxCode (Name) Dropdown 0
ServiceDate DateTime 0
TaxClassificationRef Integer 0
TotalAmount Money 0
TxnLineID Text 100
TxnMethodFlag Text 31
UnitOfMeasure Text 31
SalesRep QuickBooks Table
EditSequence Text 50
Initial Text 5
IsActive YesNo 0
LastModifiedDate DateTime 255
ListID Text 100
RecordID Integer 0
SalesRepName Entity (FullName) Dropdown 159
↳ EntityType (EntityType) Linked 20
↳ Phone (Phone) Linked 21
TimeCreated DateTime 0
TimeModifiedAccounting DateTime 0
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 3
RecordID Integer 0
TimeCreated DateTime 0
TimeModifiedAccounting DateTime 0
ShipMethod QuickBooks Table
EditSequence Text 50
Entity Entity (FullName) Dropdown -1
IsActive YesNo 0
LastModifiedDate DateTime 255
ListID Text 100
Name Text 15
Notes Text 255
RecordID Integer 0
ShipDate DateTime 255
TimeCreated DateTime 0
TimeModifiedAccounting DateTime 0
TransferOrder InventoryControlTransferOrder (RecordID) Dropdown -1
ShippingAddress QuickBooks Table
Customer Entity (FullName) Dropdown 0
DefaultShipTo YesNo 0
LastModifiedDate DateTime 255
Name Text 41
RecordID Integer 0
ShipAddressAddr1 Text 41
ShipAddressAddr2 Text 41
ShipAddressAddr3 Text 41
ShipAddressAddr4 Text 41
ShipAddressAddr5 Text 41
ShipAddressCity Text 31
ShipAddressCountry Text 31
ShipAddressNote Text 41
ShipAddressPostalCode Text 13
ShipAddressState Text 21
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
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 209
Customer Entity (FullName) Dropdown 209
DurationHours Decimal 0
DurationMinutes Decimal 0
EditSequence Text 50
Entity Entity (FullName) Dropdown 209
IsWaitingForSyncApproval YesNo 0
Item Item (FullName) Dropdown 31
LastModifiedDate DateTime 255
Location InventoryControlLocation (FullName) Dropdown 0
Notes Text 4095
PayrollItemWage PayrollItemWage (Name) Dropdown 31
RecordID Integer 0
TimeCreated DateTime 0
TimeModifiedAccounting DateTime 0
TimeTrackingEndTime DateTime 255
TimeTrackingStartTime DateTime 255
TxnDate DateTime 0
TxnID Text 100
TxnNumber Integer 0
ToDo QuickBooks Table
EditSequence Text 50
IsActive YesNo 0
IsDone YesNo 0
LastModifiedDate DateTime 255
ListID Text 100
Notes Text 4095
RecordID Integer 0
ReminderDate DateTime 0
TimeCreated DateTime 0
TimeModifiedAccounting DateTime 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
UnitOfMeasureRelatedUnit QuickBooks Table
LastModifiedDate DateTime 255
RecordID Integer 0
RelatedUnitAbbreviation Text 31
RelatedUnitConversionRatio Money 0
RelatedUnitName Text 31
UnitOfMeasureSetRecordID Integer 0
UnitOfMeasureSet QuickBooks Table
BaseUnitAbbreviation Text 31
BaseUnitName Text 31
DefaultUnitPurchase Text 31
DefaultUnitSales Text 31
DefaultUnitShipping Text 31
EditSequence Text 50
IsActive YesNo 0
IsWaitingForSyncApproval YesNo 0
LastModifiedDate DateTime 255
ListID Text 100
Name Text 31
RecordID Integer 0
TimeCreated DateTime 0
TimeModifiedAccounting DateTime 0
UnitOfMeasureType UnitOfMeasureSetType (UnitOfMeasureSetType) Dropdown 0
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
Vehicle QuickBooks Table
Desc Text 256
EditSequence Text 50
IsActive YesNo 0
LastModifiedDate DateTime 255
ListID Text 100
Name Text 31
RecordID Integer 0
TimeCreated DateTime 0
TimeModifiedAccounting DateTime 0
VehicleMileage QuickBooks Table
BillableAmount Decimal 0
BillableRate Money 0
BillableStatus BillableStatus (BillableStatus) Dropdown 20
Class Class (FullName) Dropdown 159
Customer Entity (FullName) Dropdown 209
EditSequence Text 50
IsWaitingForSyncApproval YesNo 0
Item Item (FullName) Dropdown 159
LastModifiedDate DateTime 255
Notes Text 4095
OdometerEnd Decimal 0
OdometerStart Decimal 0
RecordID Integer 0
StandardMileageRate Decimal 0
StandardMileageTotalAmount Decimal 0
TimeCreated DateTime 0
TimeModifiedAccounting DateTime 0
TotalMiles Decimal 0
TripEndDate DateTime 0
TripStartDate DateTime 0
TxnID Text 100
Vehicle Vehicle (Name) Dropdown 31
Vendor QuickBooks Table
AccountNumber Text 99
AltContact Text 41
AltPhone Text 21
AssignedTo Users (UserName) Dropdown -1
Balance Money 0
BillAddressAttentionTo Text 255
BillingRate BillingRate (Name) Dropdown 0
Campaign Campaign (Name) Dropdown -1
CompanyName Text 41
Contact Text 41
CreatedDate DateTime 255
CreditLimit Decimal 0
Currency Currency (CurrencyCode) Dropdown 0
CustomerHealthScore Decimal 0
DirectDial Text 80
EditSequence Text 50
Email Text 1023
EntityType Text 20
Fax Text 21
FirstName Text 41
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
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 25
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 5
Mobile Text 30
Name Text 41
NameOnCheck Text 41
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 21
PortalPassword Text 10
PortalUserName Text 10
PrintAs Text 41
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 31
TimeCreated DateTime 0
TimeModifiedAccounting DateTime 0
VendorAddressAddr1 Text 41
VendorAddressAddr2 Text 41
VendorAddressAddr3 Text 41
VendorAddressAddr4 Text 41
VendorAddressAddr5 Text 41
VendorAddressCity Text 31
VendorAddressCountry Text 31
VendorAddressNote Text 41
VendorAddressPostalCode Text 13
VendorAddressState Text 21
VendorTaxIdent Text 15
VendorType VendorType (FullName) Dropdown 159
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 4095
OpenAmount Money 0
RecordID Integer 0
RefNumber Text 20
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 4095
RecordID Integer 0
SalesTaxCode SalesTaxCode (Name) Dropdown 0
TxnLineID Text 100
TxnMethodFlag Text 31
VendorCreditRecordID VendorCredit (RecordID) Dropdown 0
VendorCreditLineItem QuickBooks Table
Amount Money 0
BillableStatus BillableStatus (BillableStatus) Dropdown 0
Class Class (FullName) Dropdown 0
Cost Decimal 5
Customer Entity (FullName) Dropdown 0
Desc Text 4095
Item Item (FullName) Dropdown 0
LastModifiedDate DateTime 255
QuanityOnTransferOrder Decimal 0
Quantity Decimal 0
RecordID Integer 0
SalesTaxCode SalesTaxCode (Name) Dropdown 0
TxnLineID Text 100
TxnMethodFlag Text 31
UnitOfMeasure Text 31
VendorCreditLineItemGroupRecordID VendorCreditLineItem (RecordID) Dropdown 0
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