Cloud-based Accounting Integration
The #1 Integration Platform | 1 800 755 6921
Find us on:

eBridge for QuickBooks Overview

QuickBooks

Versions: 2004 Prem CAN, 2004 PRO US, 2005, 2006, 2007, 2008, 2009, 2010, 2011, 2012, 2013
Inbound Touchpoints: Customer, Customer Payment, Customer Update, Sales Order, Sales Order Update
Outbound Touchpoints: Advanced Shipping Notice PP, Advanced Shipping Notice ST, Customer, Inventory, Posted Invoice, Purchase Order, Sales Order, Unposted Invoice

eBRIDGE integrates your QuickBooks with the following business systems:

  • EDI integration
    Provide efficiency to the EDI transaction process by automatically moving data to and from EDI documents
  • CRM integration
    Synchronize data with your CRM solution to prevent manual data entry and share accurate information across departments.
  • eCommerce integration
    Increase the speed of information exchange with your eCommerce site for faster order processing and improved customer service efficiency.
  • SCM | Supply Chain Management
    Generate UPS®, FedEx® or DHL® shipments with source data from the back-office financial system

Click here to see our QuickBooks integration partners

Click on any inbound or outbound touchpoint
above to view additional information.
CUSTOMIZE THIS SOLUTION
Design your own connection using our interactive Blueprint builder!
QuickBooks to

eBridge Connections has been in the integration business for a long time. Since 1993, we have developed thousands of connections for our customers that include QuickBooks.

Here is a sample of some of these customer connections:

1 A customer connected their QuickBooks 2013 accounting package to Amazon Marketplace FBA on June 17, 2013 [view]
2 A customer connected their QuickBooks 2011 accounting package to 3D Cart on June 7, 2013 [view]
3 A customer connected their QuickBooks 2013 accounting package to Volusion and Salesforce Winter 2013 on June 4, 2013 [view]
4 A customer connected their QuickBooks 2013 accounting package to Whole Foods Market on June 4, 2013 [view]
5 A customer connected their QuickBooks 2013 accounting package to DSSI Sovereign 4010 and AGFA 4010 on June 4, 2013 [view]
6 A customer connected their QuickBooks 2013 accounting package to Do It Best 4010 on June 4, 2013 [view]
7 A customer connected their QuickBooks 2013 accounting package to Magento Community 1.7 on June 4, 2013 [view]
8 A customer connected their QuickBooks 2012 accounting package to Volusion on May 26, 2013 [view]
9 A customer connected their QuickBooks 2013 accounting package to Volusion on May 23, 2013 [view]
10 A customer connected their QuickBooks 2013 accounting package to Salesforce Winter 2013 on May 21, 2013 [view]

View more connections

GET A QUOTE
Contact eBridge Connections about connection your QuickBooks accounting software
Inbound Customer

Description: Creates a Customer Record in the accounting system.

The Inbound Customer touchpoint includes the following fields:

CustomerParentFullName
CustomerName
CustomerCompanyName
CustomerSalutation
CustomerFirstName
CustomerMiddleName
CustomerLastName
CustomerPhone
CustomerAltPhone
CustomerFax
CustomerEmail
CustomerContact
CustomerAltContact
CustomerCustomerType
CustomerTerms
CustomerSalesRep
CustomerOpenBalance
CustomerOpenBalanceDate
CustomerTaxCode
CustomerItemSalesTax
CustomerResaleNumber
CustomerAccountNumber
CustomerCreditLimit
CustomerPayMethod
CustomerCCNumber
CustomerCCExpMonth
CustomerCCExpYear
CustomerCCNameOnCard
CustomerCCAddress
CustomerCCPostalCode
CustomerCurrency
CustomerIsUsingCustTax
CustomerPriceLevel
CustomerJobStatus
CustomerJobStartDate
CustomerJobProjectedEndDate
CustomerJobEndDate
CustomerJobDesc
CustomerJobType
CustomerMemo
CustomerUDFName
CustomerUDFValue
ShipToType
ShipToName
ShipToFiller1
ShipToAddr1
ShipToAddr2
ShipToAddr3
ShipToAddr4
ShipToCity
ShipToState
ShipToZip
ShipToCountry
ShipToNote
BillToType
BillToFiller1
BillToAddr1
BillToAddr2
BillToAddr3
BillToAddr4
BillToCity
BillToState
BillToZip
BillToCountry
BillToNote

Inbound Customer Payment

Description: Creates a Customer Payment in the accounting system.

The Inbound Customer Payment touchpoint includes the following fields:

HeaderCustomerID
HeaderRefNumber
HeaderTxnDate
HeaderTotalAmount
HeaderPaymentMethod
HeaderARAccount
HeaderDepositToAccount
HeaderMemo
DetailRefNumber
DetailPaymentAmount

Inbound Customer Update

Description: Updates an existing Customer Record in the accounting system.

The Inbound Customer Update touchpoint includes the following fields:

CustomerParentFullName
CustomerName
CustomerCompanyName
CustomerSalutation
CustomerFirstName
CustomerMiddleName
CustomerLastName
CustomerPhone
CustomerAltPhone
CustomerFax
CustomerEmail
CustomerContact
CustomerAltContact
CustomerCustomerType
CustomerTerms
CustomerSalesRep
CustomerOpenBalance
CustomerOpenBalanceDate
CustomerTaxCode
CustomerItemSalesTax
CustomerResaleNumber
CustomerAccountNumber
CustomerCreditLimit
CustomerPayMethod
CustomerCCNumber
CustomerCCExpMonth
CustomerCCExpYear
CustomerCCNameOnCard
CustomerCCAddress
CustomerCCPostalCode
CustomerCurrency
CustomerIsUsingCustTax
CustomerPriceLevel
CustomerJobStatus
CustomerJobStartDate
CustomerJobProjectedEndDate
CustomerJobEndDate
CustomerJobDesc
CustomerJobType
CustomerMemo
CustomerUDFName
CustomerUDFValue
ShipToType
ShipToName
ShipToFiller1
ShipToAddr1
ShipToAddr2
ShipToAddr3
ShipToAddr4
ShipToCity
ShipToState
ShipToZip
ShipToCountry
ShipToNote
BillToType
BillToFiller1
BillToAddr1
BillToAddr2
BillToAddr3
BillToAddr4
BillToCity
BillToState
BillToZip
BillToCountry
BillToNote

Inbound Sales Order

Description: Creates a Sales Order in the accounting system.

The Inbound Sales Order touchpoint includes the following fields:

HeaderTemplate
HeaderCustomerID
HeaderSONumber
HeaderTxnDate
HeaderPONumber
HeaderDueDate
HeaderShipDate
HeaderIsToBePrinted
HeaderIsToBeEmailed
HeaderIsTaxIncluded
HeaderClass
HeaderTerms
HeaderSalesRep
HeaderFOB
HeaderShipMethod
HeaderTaxCode
HeaderItemSalesTax
HeaderCustomerMsg
HeaderOther
HeaderDocType
SOMMemo
SOHeaderUserFieldsName
SOHeaderUserFieldsValue
Customer_ParentFullName
Customer_Name
Customer_CompanyName
Customer_Salutation
Customer_FirstName
Customer_MiddleName
Customer_LastName
Customer_Phone
Customer_AltPhone
Customer_Fax
Customer_Email
Customer_Contact
Customer_AltContact
Customer_Customer_tomerType
Customer_Terms
Customer_SalesRep
Customer_OpenBalance
Customer_OpenBalanceDate
Customer_TaxCode
Customer_ItemSalesTax
Customer_ResaleNumber
Customer_AccountNumber
Customer_CreditLimit
Customer_PayMethod
Customer_CCNumber
Customer_CCExpMonth
Customer_CCExpYear
Customer_CCNameOnCard
Customer_CCAddress
Customer_CCPostalCode
Customer_Currency
Customer_IsUsingCustomer_tTax
Customer_PriceLevel
Customer_JobStatus
Customer_JobStartDate
Customer_JobProjectedEndDate
Customer_JobEndDate
Customer_JobDesc
Customer_JobType
Customer_MEMMemo
Customer_UserFieldName
Customer_UserFieldValue
BillTo_ADRName
BillTo_ADRAddr1
BillTo_ADRAddr2
BillTo_ADRAddr3
BillTo_ADRAddr4
BillTo_ADRCity
BillTo_ADRState
BillTo_ADRZip
BillTo_ADRCountry
BillTo_ADRNote
ShipTo_ADRName
ShipTo_ADRAddr1
ShipTo_ADRAddr2
ShipTo_ADRAddr3
ShipTo_ADRAddr4
ShipTo_ADRCity
ShipTo_ADRState
ShipTo_ADRZip
ShipTo_ADRCountry
ShipTo_ADRNote
DetailItemType
DetailItemID
DetailQuantity
DetailUofM
DetailRate
DetailRateType
DetailPriceLevel
DetailTaxCode
DetailClass
DetailOther1
DetailOther2
DetailItemDesc
DetailUserFields_Name
DetailUserFields_Value

Inbound Sales Order Update

Description: Updates an existing Sales Order in the accounting system.

The Inbound Sales Order Update touchpoint includes the following fields:

HeaderTemplate
HeaderCustomerID
HeaderSONumber
HeaderTxnDate
HeaderPONumber
HeaderDueDate
HeaderShipDate
HeaderIsToBePrinted
HeaderIsToBeEmailed
HeaderIsTaxIncluded
HeaderClass
HeaderTerms
HeaderSalesRep
HeaderFOB
HeaderShipMethod
HeaderTaxCode
HeaderItemSalesTax
HeaderCustomerMsg
HeaderOther
HeaderDocType
SOMMemo
SOHeaderUserFieldsName
SOHeaderUserFieldsValue
Customer_ParentFullName
Customer_Name
Customer_CompanyName
Customer_Salutation
Customer_FirstName
Customer_MiddleName
Customer_LastName
Customer_Phone
Customer_AltPhone
Customer_Fax
Customer_Email
Customer_Contact
Customer_AltContact
Customer_Customer_tomerType
Customer_Terms
Customer_SalesRep
Customer_OpenBalance
Customer_OpenBalanceDate
Customer_TaxCode
Customer_ItemSalesTax
Customer_ResaleNumber
Customer_AccountNumber
Customer_CreditLimit
Customer_PayMethod
Customer_CCNumber
Customer_CCExpMonth
Customer_CCExpYear
Customer_CCNameOnCard
Customer_CCAddress
Customer_CCPostalCode
Customer_Currency
Customer_IsUsingCustomer_tTax
Customer_PriceLevel
Customer_JobStatus
Customer_JobStartDate
Customer_JobProjectedEndDate
Customer_JobEndDate
Customer_JobDesc
Customer_JobType
Customer_MEMMemo
Customer_UserFieldName
Customer_UserFieldValue
BillTo_ADRName
BillTo_ADRAddr1
BillTo_ADRAddr2
BillTo_ADRAddr3
BillTo_ADRAddr4
BillTo_ADRCity
BillTo_ADRState
BillTo_ADRZip
BillTo_ADRCountry
BillTo_ADRNote
ShipTo_ADRName
ShipTo_ADRAddr1
ShipTo_ADRAddr2
ShipTo_ADRAddr3
ShipTo_ADRAddr4
ShipTo_ADRCity
ShipTo_ADRState
ShipTo_ADRZip
ShipTo_ADRCountry
ShipTo_ADRNote
DetailItemType
DetailItemID
DetailQuantity
DetailUofM
DetailRate
DetailRateType
DetailPriceLevel
DetailTaxCode
DetailClass
DetailOther1
DetailOther2
DetailItemDesc
DetailUserFields_Name
DetailUserFields_Value

Outbound Advanced Shipping Notice PP

Description: Extracts document information from the accounting system that is uploaded into the eBridge ASN module for ASN creation in Pick and Pack mode. ASN can be created from Sales Order, Unposted Invoice and Posted Invoice

The Outbound Advanced Shipping Notice PP touchpoint includes the following fields:

ShipmentTransSetID
ShipmentLocaCustomerNo
ShipmentPublicCustNo
ShipmentShipmentID
ShipmentCartonCount
ShipmentGrossWeight
ShipmentWeightUofM
ShipmentShipmentDate
ShipmentShipmentTime
ShipmentCarrierNotes
ShipmentCarrierID
ShipmentCarrierName1
ShipmentCarrierName2
ShipmentCarrierAddr1
ShipmentCarrierAddr2
ShipmentCarrierCity
ShipmentCarrierProv
ShipmentCarrierCountry
ShipmentCarrierPostalCode
ShipmentCarrierFax
ShipmentCarrierPhone
ShipmentLocalShipToID
ShipmentPublicShipToID
ShipmentShipToName1
ShipmentShipToName2
ShipmentShipToAddr1
ShipmentShipToAddr2
ShipmentShipToCity
ShipmentShipToProv
ShipmentShipToCountry
ShipmentShipToPostalCode
ShipmentShipToPhone
ShipmentShipAuthorization
ShipmentTrailerCount
ShipmentPackComplete
ShipmentPackType
ShipmentCustomerID
ShipmentBuffer
ShipmentExpDeliveryDate
ShipmentExportedFlag
ShipmentBillOfLading
PartnerTranslationPartnerType
PartnerTranslationTranslationStatus
PartnerTranslationPartnerID
PartnerTranslationPartnerName
PartnerTranslationExternalID
PartnerTranslationExternalDesc
PartnerTranslationBuffer
PartnerTranslationLevel
PartnerTranslationEDIFlag
PartnerTranslationCustomField1
PartnerTranslationCustomField2
PartnerTranslationCustomField3
PartnerTranslationCustomField4
PartnerTranslationCustomField5
PartnerTranslationPriceSource
PartnerTranslationASNFormat
PartnerTranslationASNConType
PartnerTranslationGroupID
PartnerTranslationGroupDesc
ShipAddressTranslationTranslationStatus
ShipAddressTranslationShipID
ShipAddressTranslationShipName
ShipAddressTranslationExternalID
ShipAddressTranslationExternalDesc
ShipAddressTranslationBuffer
ShipAddressTranslationLevel
ShipAddressTranslationEDIFlag
ShipAddressTranslationCustomField1
ShipAddressTranslationCustomField2
ShipAddressTranslationCustomField3
ShipAddressTranslationCustomField4
ShipAddressTranslationCustomField5
TrailerSequenceNo
TrailerTrailerID
TrailerDescription
TrailerCartonCount
TrailerDocCount
TrailerWeight
TrailerBuffer
DocumentOrderNo
DocumentOrderDate
DocumentExpShipDate
DocumentCancelDate
DocumentUltReceiver
DocumentReceiverName1
DocumentReceiverName2
DocumentReceiverAddr1
DocumentReceiverAddr2
DocumentReceiverCity
DocumentReceiverProv
DocumentReceiverCountry
DocumentReceiverPostalCode
DocumentReceiverPhone
DocumentLocalBillToID
DocumentPublicBillToID
DocumentBillToName1
DocumentBillToName2
DocumentBillToAddr1
DocumentBillToAddr2
DocumentBillToCity
DocumentBillToProv
DocumentBillToCountry
DocumentBillToPostalCode
DocumentBillToPhone
DocumentDepartment
DocumentAppID
DocumentCustomerDocNo
DocumentVendorIDSupplierID
DocumentShipToID
DocumentHCartons
DocumentHDetails
DocumentInvoiceNo
DocumentBuffer
CartontonLabel
CartontonLabelRow
CartonAppID
CartonType,
CartonManufID
CartonSerialNo
CartonMH10ChkDigit
CartonCDetails
CartonTrailerID
CartonTrackingNumber
DetailLineNo
DetailLocalItemNo
DetailPublicItemNo
DetailLocalItemDesc
DetailPublicItemDesc
DetailAdditional
DetailQtyInCarton
DetailUnitOfMeas
DetailUnitPrice
DetailBackOrderedQty
DetailOriginalQty
DetailBuffer
DetailUPCode
DetailTranslationTranslationStatus
DetailTranslationItemID
DetailTranslationItemDesc
DetailTranslationExternalID
DetailTranslationExternalDesc
DetailTranslationBuffer
DetailTranslationLevel
DetailTranslationEDIFlag
DetailTranslationUPCCode
DetailTranslationCustomField1
DetailTranslationCustomField2
DetailTranslationCustomField3
DetailTranslationCustomField4
DetailTranslationCustomField5
DetailTranslationWeight
DetailTranslationHeight
DetailTranslationLength
DetailTranslationWidth
DetailTranslationInnerPack
DetailTranslationStandPack

Outbound Advanced Shipping Notice ST

Description: Extracts document information from the accounting system that is uploaded into the eBridge ASN module for ASN creation in Standard mode. ASN can be created from Sales Order, Unposted Invoice and Posted Invoice

The Outbound Advanced Shipping Notice ST touchpoint includes the following fields:

ShipmentTransSetID
ShipmentLocaCustomerNo
ShipmentPublicCustNo
ShipmentShipmentID
ShipmentCartonCount
ShipmentGrossWeight
ShipmentWeightUofM
ShipmentShipmentDate
ShipmentShipmentTime
ShipmentCarrierNotes
ShipmentCarrierID
ShipmentCarrierName1
ShipmentCarrierName2
ShipmentCarrierAddr1
ShipmentCarrierAddr2
ShipmentCarrierCity
ShipmentCarrierProv
ShipmentCarrierCountry
ShipmentCarrierPostalCode
ShipmentCarrierFax
ShipmentCarrierPhone
ShipmentLocalShipToID
ShipmentPublicShipToID
ShipmentShipToName1
ShipmentShipToName2
ShipmentShipToAddr1
ShipmentShipToAddr2
ShipmentShipToCity
ShipmentShipToProv
ShipmentShipToCountry
ShipmentShipToPostalCode
ShipmentShipToPhone
ShipmentShipAuthorization
ShipmentTrailerCount
ShipmentPackComplete
ShipmentPackType
ShipmentCustomerID
ShipmentBuffer
ShipmentExpDeliveryDate
ShipmentExportedFlag
ShipmentBillOfLading
PartnerTranslationPartnerType
PartnerTranslationTranslationStatus
PartnerTranslationPartnerID
PartnerTranslationPartnerName
PartnerTranslationExternalID
PartnerTranslationExternalDesc
PartnerTranslationBuffer
PartnerTranslationLevel
PartnerTranslationEDIFlag
PartnerTranslationCustomField1
PartnerTranslationCustomField2
PartnerTranslationCustomField3
PartnerTranslationCustomField4
PartnerTranslationCustomField5
PartnerTranslationPriceSource
PartnerTranslationASNFormat
PartnerTranslationASNConType
ShipAddressTranslationTranslationStatus
ShipAddressTranslationShipID
ShipAddressTranslationShipName
ShipAddressTranslationExternalID
ShipAddressTranslationExternalDesc
ShipAddressTranslationBuffer
ShipAddressTranslationLevel
ShipAddressTranslationEDIFlag
ShipAddressTranslationCustomField1
ShipAddressTranslationCustomField2
ShipAddressTranslationCustomField3
ShipAddressTranslationCustomField4
ShipAddressTranslationCustomField5
TrailerSequenceNo
TrailerTrailerID
TrailerDescription
TrailerCartonCount
TrailerDocCount
TrailerWeight
TrailerBuffer
DocumentOrderNo
DocumentOrderDate
DocumentExpShipDate
DocumentCancelDate
DocumentUltReceiver
DocumentReceiverName1
DocumentReceiverName2
DocumentReceiverAddr1
DocumentReceiverAddr2
DocumentReceiverCity
DocumentReceiverProv
DocumentReceiverCountry
DocumentReceiverPostalCode
DocumentReceiverPhone
DocumentLocalBillToID
DocumentPublicBillToID
DocumentBillToName1
DocumentBillToName2
DocumentBillToAddr1
DocumentBillToAddr2
DocumentBillToCity
DocumentBillToProv
DocumentBillToCountry
DocumentBillToPostalCode
DocumentBillToPhone
DocumentDepartment
DocumentAppID
DocumentCustomerDocNo
DocumentVendorIDSupplierID
DocumentShipToID
DocumentHCartons
DocumentHDetails
DocumentInvoiceNo
DocumentBuffer
DetailLineNo
DetailLocalItemNo
DetailPublicItemNo
DetailLocalItemDesc
DetailPublicItemDesc
DetailAdditional
DetailQtyInCartons
DetailUnitOfMeas
DetailUnitPrice
DetailBackOrderedQty
DetailOriginalQty
DetailBuffer
DetailUPCCode
DetailTranslationTranslationStatus
DetailTranslationItemID
DetailTranslationItemDesc
DetailTranslationExternalID
DetailTranslationExternalDesc
DetailTranslationBuffer
DetailTranslationLevel
DetailTranslationEDIFlag
DetailTranslationUPCCode
DetailTranslationCustomField1
DetailTranslationCustomField2
DetailTranslationCustomField3
DetailTranslationCustomField4
DetailTranslationCustomField5
DetailTranslationWeight
DetailTranslationHeight
DetailTranslationLength
DetailTranslationWidth
DetailTranslationInnerPack
DetailTranslationStandPack
CartonMH10Fmt
CartonMH10Raw
CartonMH10ApplID
CartonMH10Type
CartonMH10ManufID
CartonMH10SerialNo
CartonMH10ChkDigit
CartonCDetails
CartonTrailerID
CartonTrackingNo

Outbound Customer

Description: Extracts a Customer Record from the accounting system.

The Outbound Customer touchpoint includes the following fields:

CustomerListID
CustomerTimeCreated
CustomerTimeModified
CustomerEditSequence
CustomerName
CustomerFullName
CustomerIsActive
CustomerParent
CustomerSubLevel
CustomerCompanyName
CustomerSalutation
CustomerFirstName
CustomerMiddleName
CustomerLastName
CustomerSuffix
CustomerPhone
CustomerAltPhone
CustomerFax
CustomerEmail
CustomerContact
CustomerAltContact
CustomerCustomerType
CustomerTerms
CustomerSalesRep
CustomerBalance
CustomerTotalBalance
CustomerTaxCode
CustomerSalesTaxCode
CustomerItemSalesTax
CustomerSalesTaxCountry
CustomerResaleNumber
CustomerAccountNumber
CustomerCreditLimit
CustomerPreferedPaymentMethod
CustomerCreditCardNumber
CustomerExpirationMonth
CustomerExpirationYear
CustomerNameOnCard
CustomerCreditCardAddress
CustomerCreditCardPostalCode
CustomerJobStatus
CustomerJobStartDate
CustomerJobProjectedEndDate
CustomerJobEndDate
CustomerJobDesc
CustomerJobType
CustomerPriceLevel
CustomerCurrency
CustomerIsUsingCustomerTaxCode
CustomerMemo
CustomerOwnerGUID
CustomerUDFName
CustomerUDFType
CustomerUDFValue
PartnerTranslationsPartnerType
PartnerTranslationsTranslationStatus
PartnerTranslationsPartnerID
PartnerTranslationsPartnerName
PartnerTranslationsExternalID
PartnerTranslationsExternalDesc
PartnerTranslationsBuffer
PartnerTranslationsLevel
PartnerTranslationsEDIFlag
PartnerTranslationsCustomField1
PartnerTranslationsCustomField2
PartnerTranslationsCustomField3
PartnerTranslationsCustomField4
PartnerTranslationsCustomField5
PartnerTranslationsPriceSource
PartnerTranslationsASNFormat
PartnerTranslationsASNConType
PartnerTranslationsGroupID
PartnerTranslationsGroupDesc
PartnerTranslationsGroupStatus
PartnerTranslationsGroupField1
PartnerTranslationsGroupField2
PartnerTranslationsGroupField3
PartnerTranslationsGroupField4
PartnerTranslationsGroupField5
ShipToType
ShipToCode
ShipToAddr1
ShipToAddr2
ShipToAddr3
ShipToAddr4
ShipToAddr5
ShipToCity
ShipToState
ShipToZip
ShipToCountry
ShipToNote
ShipToAddrLine1
ShipToAddrLine2
ShipToAddrLine3
ShipToAddrLine4
ShipToAddrLine5
BillToType
BillToCode
BillToAddr1
BillToAddr2
BillToAddr3
BillToAddr4
BillToAddr5
BillToCity
BillToState
BillToZip
BillToCountry
BillToNote
BillToAddrLine1
BillToAddrLine2
BillToAddrLine3
BillToAddrLine4
BillToAddrLine5
ShipAddressTranslationTranslationStatus
ShipAddressTranslationShipID
ShipAddressTranslationShipName
ShipAddressTranslationExternalID
ShipAddressTranslationExternalDesc
ShipAddressTranslationBuffer
ShipAddressTranslationLevel
ShipAddressTranslationEDIFlag
ShipAddressTranslationCustomField1
ShipAddressTranslationCustomField2
ShipAddressTranslationCustomField3
ShipAddressTranslationCustomField4
ShipAddressTranslationCustomField5

Outbound Inventory

Description: Extracts an Inventory Record from the accounting system.

The Outbound Inventory touchpoint includes the following fields:

ItemItemType
ItemListID
ItemTimeCreated
ItemTimeModified
ItemEditSequence
ItemName
ItemFullName
ItemIsActive
ItemParent
ItemSubLevel
ItemUofM
ItemManufacturerPartNumber
ItemIsTaxIncluded
ItemSalesTaxCode
ItemPurchaseTaxCode
ItemSalesOrPurchase
ItemPriceType
ItemPrice
ItemPricePercent
ItemAccount
ItemSalesPrice
ItemIncomeAccount
ItemPurchaseCost
ItemExpenseAccount
ItemCOGSAccount
ItemVendor
ItemForeignPrice
ItemAssetAccount
ItemProcessPoint
ItemQuantityOnHand
ItemAverageCost
ItemQuantityOnOrder
ItemQuantityOnSalesOrder
ItemPaymentMethod
ItemSpecialItemType
ItemIsUsedOnPurchaseTransaction
ItemSalesTaxReturnLineNumber
ItemDesc
ItemOwnerGUID
ItemUDFName
ItemUDFType
ItemUDFValue
ItemTranslationTranslationStatus
ItemTranslationItemID
ItemTranslationItemDesc
ItemTranslationExternalID
ItemTranslationExternalDesc
ItemTranslationBuffer
ItemTranslationLevel
ItemTranslationEDIFlag
ItemTranslationUPCCode
ItemTranslationCustomField1
ItemTranslationCustomField2
ItemTranslationCustomField3
ItemTranslationCustomField4
ItemTranslationCustomField5
ItemTranslationWeight
ItemTranslationHeight
ItemTranslationLength
ItemTranslationWidth
ItemTranslationInnerPack
ItemTranslationStandPack
ItemTax
ItemSubItem
ItemSubQuantity
SubItemTranslationTranslationStatus
SubItemTranslationItemID
SubItemTranslationItemDesc
SubItemTranslationExternalID
SubItemTranslationExternalDesc
SubItemTranslationBuffer
SubItemTranslationLevel
SubItemTranslationEDIFlag
SubItemTranslationUPCCode
SubItemTranslationCustomField1
SubItemTranslationCustomField2
SubItemTranslationCustomField3
SubItemTranslationCustomField4
SubItemTranslationCustomField5
SubItemTranslationWeight
SubItemTranslationHeight
SubItemTranslationLength
SubItemTranslationWidth
SubItemTranslationInnerPack
SubItemTranslationStandPack

Outbound Posted Invoice

Description: Extracts a Posted Invoice from the accounting system.

The Outbound Posted Invoice touchpoint includes the following fields:

HeaderTxnID
HeaderTimeCreated
HeaderTimeModified
HeaderEditSequence
HeaderTxnNumber
HeaderCustomerID
HeaderCustomerFullName
HeaderClass
HeaderARAccount
HeaderTemplate
HeaderTxnDate
HeaderRefNumber
HeaderIsPending
HeaderIsFinanceCharge
HeaderPONumber
HeaderTerms
HeaderDueDate
HeaderSalesRep
HeaderFOB
HeaderShipDate
HeaderShipMethod
HeaderSubTotal
HeaderItemSalesTax
HeaderSalesTaxPercentage
HeaderSalesTaxTotal
HeaderTotalAmount
HeaderAppliedAmount
HeaderBalanceRemaining
HeaderIsManuallyClosed
HeaderIsFullyInvoiced
HeaderIsPaid
HeaderCustomerMsg
HeaderIsToBePrinted
HeaderIsToBeEmailed
HeaderIsTaxIncluded
HeaderCustomerTaxCode
HeaderCustomerSalesTaxCode
HeaderSuggestedDiscountAmount
HeaderSuggestedDiscountDate
HeaderTax1Total
HeaderTax2Total
HeaderExchangeRate
HeaderOther
HeaderMemo
HeaderOwnerGUID
HeaderUDFName
HeaderUDFType
HeaderUDFValue
PartnerTranslationsPartnerType
PartnerTranslationsTranslationStatus
PartnerTranslationsPartnerID
PartnerTranslationsPartnerName
PartnerTranslationsExternalID
PartnerTranslationsExternalDesc
PartnerTranslationsBuffer
PartnerTranslationsLevel
PartnerTranslationsEDIFlag
PartnerTranslationsCustomField1
PartnerTranslationsCustomField2
PartnerTranslationsCustomField3
PartnerTranslationsCustomField4
PartnerTranslationsCustomField5
PartnerTranslationsPriceSource
PartnerTranslationsASNFormat
PartnerTranslationsASNConType
PartnerTranslationsGroupID
PartnerTranslationsGroupDesc
PartnerTranslationsGroupStatus
PartnerTranslationsGroupField1
PartnerTranslationsGroupField2
PartnerTranslationsGroupField3
PartnerTranslationsGroupField4
PartnerTranslationsGroupField5
ShipToType
ShipToCode
ShipToAddr1
ShipToAddr2
ShipToAddr3
ShipToAddr4
ShipToAddr5
ShipToCity
ShipToState
ShipToZip
ShipToCountry
ShipToNote
ShipToAddrLine1
ShipToAddrLine2
ShipToAddrLine3
ShipToAddrLine4
ShipToAddrLine5
BillToType
BillToCode
BillToAddr1
BillToAddr2
BillToAddr3
BillToAddr4
BillToAddr5
BillToCity
BillToState
BillToZip
BillToCountry
BillToNote
BillToAddrLine1
BillToAddrLine2
BillToAddrLine3
BillToAddrLine4
BillToAddrLine5
ShipAddressTranslationTranslationStatus
ShipAddressTranslationShipID
ShipAddressTranslationShipName
ShipAddressTranslationExternalID
ShipAddressTranslationExternalDesc
ShipAddressTranslationBuffer
ShipAddressTranslationLevel
ShipAddressTranslationEDIFlag
ShipAddressTranslationCustomField1
ShipAddressTranslationCustomField2
ShipAddressTranslationCustomField3
ShipAddressTranslationCustomField4
ShipAddressTranslationCustomField5
DetailTxnLineID
DetailItemID
DetailItemFullName
DetailItemDesc
DetailQuantity
DetailUofM
DetailUofMOverride
DetailRateType
DetailRate
DetailRatePercent
DetailClass
DetailAmount
DetailServiceDate
DetailTaxCode
DetailSalesTaxCode
DetailIsTaxable
DetailInvoiced
DetailIsManuallyClosed
DetailOther1
DetailOther2
DetailOwnerGUID
DetailUDFName
DetailUDFType
DetailUDFValue
DetailTranslationTranslationStatus
DetailTranslationItemID
DetailTranslationItemDesc
DetailTranslationExternalID
DetailTranslationExternalDesc
DetailTranslationBuffer
DetailTranslationLevel
DetailTranslationEDIFlag
DetailTranslationUPCCode
DetailTranslationCustomField1
DetailTranslationCustomField2
DetailTranslationCustomField3
DetailTranslationCustomField4
DetailTranslationCustomField5
DetailTranslationWeight
DetailTranslationHeight
DetailTranslationLength
DetailTranslationWidth
DetailTranslationInnerPack
DetailTranslationStandPack

Outbound Purchase Order

Description: Extracts a Purchase Order from the accounting system.

The Outbound Purchase Order touchpoint includes the following fields:

HeaderTxnID
HeaderTimeCreated
HeaderTimeModified
HeaderEditSequence
HeaderTxnNumber
HeaderVendorID
HeaderVendorName
HeaderClass
HeaderShipToEntity
HeaderTemplate
HeaderTxnDate
HeaderRefNumber
HeaderTerms
HeaderDueDate
HeaderExpectedDate
HeaderShipMethod
HeaderFOB
HeaderTotalAmount
HeaderIsManuallyClosed
HeaderIsFullyReceived
HeaderVendorMsg
HeaderIsToBePrinted
HeaderIsToBeEmailed
HeaderIsTaxIncluded
HeaderTax1Total
HeaderTax2Total
HeaderExchangeRate
HeaderSalesTaxCode
HeaderOther1
HeaderOther2
HeaderMemo
HeaderOwnerGUID
HeaderUDFName
HeaderUDFType
HeaderUDFValue
PartnerTranslationsPartnerType
PartnerTranslationsTranslationStatus
PartnerTranslationsPartnerID
PartnerTranslationsPartnerName
PartnerTranslationsExternalID
PartnerTranslationsExternalDesc
PartnerTranslationsBuffer
PartnerTranslationsLevel
PartnerTranslationsEDIFlag
PartnerTranslationsCustomField1
PartnerTranslationsCustomField2
PartnerTranslationsCustomField3
PartnerTranslationsCustomField4
PartnerTranslationsCustomField5
PartnerTranslationsPriceSource
PartnerTranslationsASNFormat
PartnerTranslationsASNConType
PartnerTranslationsGroupID
PartnerTranslationsGroupDesc
PartnerTranslationsGroupStatus
PartnerTranslationsGroupField1
PartnerTranslationsGroupField2
PartnerTranslationsGroupField3
PartnerTranslationsGroupField4
PartnerTranslationsGroupField5
ShipToType
ShipToCode
ShipToAddr1
ShipToAddr2
ShipToAddr3
ShipToAddr4
ShipToAddr5
ShipToCity
ShipToState
ShipToZip
ShipToCountry
ShipToNote
ShipToAddrLine1
ShipToAddrLine2
ShipToAddrLine3
ShipToAddrLine4
ShipToAddrLine5
BillToType
BillToCode
BillToAddr1
BillToAddr2
BillToAddr3
BillToAddr4
BillToAddr5
BillToCity
BillToState
BillToZip
BillToCountry
BillToNote
BillToAddrLine1
BillToAddrLine2
BillToAddrLine3
BillToAddrLine4
BillToAddrLine5
BillToType
BillToCode
BillToAddr1
BillToAddr2
BillToAddr3
BillToAddr4
BillToAddr5
BillToCity
BillToState
BillToZip
BillToCountry
BillToNote
BillToAddrLine1
BillToAddrLine2
BillToAddrLine3
BillToAddrLine4
BillToAddrLine5
DetailTxnLineID
DetailItemID
DetailItemFullName
DetailItemDesc
DetailQuantity
DetailUofM
DetailUofMOverride
DetailRate
DetailClass
DetailAmount
DetailCustomer
DetailServiceDate
DetailReceivedQuantity
DetailIsManuallyClosed
DetailTaxCode
DetailOther1
DetailOther2
DetailOwnerGUID
DetailUDFName
DetailUDFType
DetailUDFValue
DetailTranslationTranslationStatus
DetailTranslationItemID
DetailTranslationItemDesc
DetailTranslationExternalID
DetailTranslationExternalDesc
DetailTranslationBuffer
DetailTranslationLevel
DetailTranslationEDIFlag
DetailTranslationUPCCode
DetailTranslationCustomField1
DetailTranslationCustomField2
DetailTranslationCustomField3
DetailTranslationCustomField4
DetailTranslationCustomField5
DetailTranslationWeight
DetailTranslationHeight
DetailTranslationLength
DetailTranslationWidth
DetailTranslationInnerPack
DetailTranslationStandPack

Outbound Sales Order

Description: Extracts a Sales Order from the accounting system.

The Outbound Sales Order touchpoint includes the following fields:

HeaderTxnID
HeaderTimeCreated
HeaderTimeModified
HeaderEditSequence
HeaderTxnNumber
HeaderCustomerID
HeaderCustomerFullName
HeaderClass
HeaderARAccount
HeaderTemplate
HeaderTxnDate
HeaderRefNumber
HeaderIsPending
HeaderIsFinanceCharge
HeaderPONumber
HeaderTerms
HeaderDueDate
HeaderSalesRep
HeaderFOB
HeaderShipDate
HeaderShipMethod
HeaderSubTotal
HeaderItemSalesTax
HeaderSalesTaxPercentage
HeaderSalesTaxTotal
HeaderTotalAmount
HeaderAppliedAmount
HeaderBalanceRemaining
HeaderIsManuallyClosed
HeaderIsFullyInvoiced
HeaderIsPaid
HeaderCustomerMsg
HeaderIsToBePrinted
HeaderIsToBeEmailed
HeaderIsTaxIncluded
HeaderCustomerTaxCode
HeaderCustomerSalesTaxCode
HeaderSuggestedDiscountAmount
HeaderSuggestedDiscountDate
HeaderTax1Total
HeaderTax2Total
HeaderExchangeRate
HeaderOther
HeaderMemo
HeaderOwnerGUID
HeaderUDFName
HeaderUDFType
HeaderUDFValue
PartnerTranslationsPartnerType
PartnerTranslationsTranslationStatus
PartnerTranslationsPartnerID
PartnerTranslationsPartnerName
PartnerTranslationsExternalID
PartnerTranslationsExternalDesc
PartnerTranslationsBuffer
PartnerTranslationsLevel
PartnerTranslationsEDIFlag
PartnerTranslationsCustomField1
PartnerTranslationsCustomField2
PartnerTranslationsCustomField3
PartnerTranslationsCustomField4
PartnerTranslationsCustomField5
PartnerTranslationsPriceSource
PartnerTranslationsASNFormat
PartnerTranslationsASNConType
PartnerTranslationsGroupID
PartnerTranslationsGroupDesc
PartnerTranslationsGroupStatus
PartnerTranslationsGroupField1
PartnerTranslationsGroupField2
PartnerTranslationsGroupField3
PartnerTranslationsGroupField4
PartnerTranslationsGroupField5
ShipToType
ShipToCode
ShipToAddr1
ShipToAddr2
ShipToAddr3
ShipToAddr4
ShipToAddr5
ShipToCity
ShipToState
ShipToZip
ShipToCountry
ShipToNote
ShipToAddrLine1
ShipToAddrLine2
ShipToAddrLine3
ShipToAddrLine4
ShipToAddrLine5
BillToType
BillToCode
BillToAddr1
BillToAddr2
BillToAddr3
BillToAddr4
BillToAddr5
BillToCity
BillToState
BillToZip
BillToCountry
BillToNote
BillToAddrLine1
BillToAddrLine2
BillToAddrLine3
BillToAddrLine4
BillToAddrLine5
ShipAddressTranslationTranslationStatus
ShipAddressTranslationShipID
ShipAddressTranslationShipName
ShipAddressTranslationExternalID
ShipAddressTranslationExternalDesc
ShipAddressTranslationBuffer
ShipAddressTranslationLevel
ShipAddressTranslationEDIFlag
ShipAddressTranslationCustomField1
ShipAddressTranslationCustomField2
ShipAddressTranslationCustomField3
ShipAddressTranslationCustomField4
ShipAddressTranslationCustomField5
DetailTxnLineID
DetailItemID
DetailItemFullName
DetailItemDesc
DetailQuantity
DetailUofM
DetailUofMOverride
DetailRateType
DetailRate
DetailRatePercent
DetailClass
DetailAmount
DetailServiceDate
DetailTaxCode
DetailSalesTaxCode
DetailIsTaxable
DetailInvoiced
DetailIsManuallyClosed
DetailOther1
DetailOther2
DetailOwnerGUID
DetailUDFName
DetailUDFType
DetailUDFValue
DetailTranslationTranslationStatus
DetailTranslationItemID
DetailTranslationItemDesc
DetailTranslationExternalID
DetailTranslationExternalDesc
DetailTranslationBuffer
DetailTranslationLevel
DetailTranslationEDIFlag
DetailTranslationUPCCode
DetailTranslationCustomField1
DetailTranslationCustomField2
DetailTranslationCustomField3
DetailTranslationCustomField4
DetailTranslationCustomField5
DetailTranslationWeight
DetailTranslationHeight
DetailTranslationLength
DetailTranslationWidth
DetailTranslationInnerPack
DetailTranslationStandPack

Outbound Unposted Invoice

Description: Extracts an Unposted Invoice from the accounting system.

The Outbound Unposted Invoice touchpoint includes the following fields:

HeaderTxnID
HeaderTimeCreated
HeaderTimeModified
HeaderEditSequence
HeaderTxnNumber
HeaderCustomerID
HeaderCustomerFullName
HeaderClass
HeaderARAccount
HeaderTemplate
HeaderTxnDate
HeaderRefNumber
HeaderIsPending
HeaderIsFinanceCharge
HeaderPONumber
HeaderTerms
HeaderDueDate
HeaderSalesRep
HeaderFOB
HeaderShipDate
HeaderShipMethod
HeaderSubTotal
HeaderItemSalesTax
HeaderSalesTaxPercentage
HeaderSalesTaxTotal
HeaderTotalAmount
HeaderAppliedAmount
HeaderBalanceRemaining
HeaderIsManuallyClosed
HeaderIsFullyInvoiced
HeaderIsPaid
HeaderCustomerMsg
HeaderIsToBePrinted
HeaderIsToBeEmailed
HeaderIsTaxIncluded
HeaderCustomerTaxCode
HeaderCustomerSalesTaxCode
HeaderSuggestedDiscountAmount
HeaderSuggestedDiscountDate
HeaderTax1Total
HeaderTax2Total
HeaderExchangeRate
HeaderOther
HeaderMemo
HeaderOwnerGUID
HeaderUDFName
HeaderUDFType
HeaderUDFValue
PartnerTranslationsPartnerType
PartnerTranslationsTranslationStatus
PartnerTranslationsPartnerID
PartnerTranslationsPartnerName
PartnerTranslationsExternalID
PartnerTranslationsExternalDesc
PartnerTranslationsBuffer
PartnerTranslationsLevel
PartnerTranslationsEDIFlag
PartnerTranslationsCustomField1
PartnerTranslationsCustomField2
PartnerTranslationsCustomField3
PartnerTranslationsCustomField4
PartnerTranslationsCustomField5
PartnerTranslationsPriceSource
PartnerTranslationsASNFormat
PartnerTranslationsASNConType
PartnerTranslationsGroupID
PartnerTranslationsGroupDesc
PartnerTranslationsGroupStatus
PartnerTranslationsGroupField1
PartnerTranslationsGroupField2
PartnerTranslationsGroupField3
PartnerTranslationsGroupField4
PartnerTranslationsGroupField5
ShipToType
ShipToCode
ShipToAddr1
ShipToAddr2
ShipToAddr3
ShipToAddr4
ShipToAddr5
ShipToCity
ShipToState
ShipToZip
ShipToCountry
ShipToNote
ShipToAddrLine1
ShipToAddrLine2
ShipToAddrLine3
ShipToAddrLine4
ShipToAddrLine5
BillToType
BillToCode
BillToAddr1
BillToAddr2
BillToAddr3
BillToAddr4
BillToAddr5
BillToCity
BillToState
BillToZip
BillToCountry
BillToNote
BillToAddrLine1
BillToAddrLine2
BillToAddrLine3
BillToAddrLine4
BillToAddrLine5
ShipAddressTranslationTranslationStatus
ShipAddressTranslationShipID
ShipAddressTranslationShipName
ShipAddressTranslationExternalID
ShipAddressTranslationExternalDesc
ShipAddressTranslationBuffer
ShipAddressTranslationLevel
ShipAddressTranslationEDIFlag
ShipAddressTranslationCustomField1
ShipAddressTranslationCustomField2
ShipAddressTranslationCustomField3
ShipAddressTranslationCustomField4
ShipAddressTranslationCustomField5
DetailTxnLineID
DetailItemID
DetailItemFullName
DetailItemDesc
DetailQuantity
DetailUofM
DetailUofMOverride
DetailRateType
DetailRate
DetailRatePercent
DetailClass
DetailAmount
DetailServiceDate
DetailTaxCode
DetailSalesTaxCode
DetailIsTaxable
DetailInvoiced
DetailIsManuallyClosed
DetailOther1
DetailOther2
DetailOwnerGUID
DetailUDFName
DetailUDFType
DetailUDFValue
DetailTranslationTranslationStatus
DetailTranslationItemID
DetailTranslationItemDesc
DetailTranslationExternalID
DetailTranslationExternalDesc
DetailTranslationBuffer
DetailTranslationLevel
DetailTranslationEDIFlag
DetailTranslationUPCCode
DetailTranslationCustomField1
DetailTranslationCustomField2
DetailTranslationCustomField3
DetailTranslationCustomField4
DetailTranslationCustomField5
DetailTranslationWeight
DetailTranslationHeight
DetailTranslationLength
DetailTranslationWidth
DetailTranslationInnerPack
DetailTranslationStandPack