eBridge for Sage MAS 500 Overview

Sage MAS 500

Versions: 6.3, 7.0, 7.2, 7.3

Inbound Touchpoints: Credit Memo, Customer, Customer Payment, Customer Update, Inventory Transaction, Receipt of Goods, Sales Order, Shipment

Outbound Touchpoints: Advanced Shipping Notice PP, Advanced Shipping Notice ST, Customer, Inventory, Posted Invoice, Sales Order, Unposted Invoice, Vendor Payment

eBRIDGE integrates your Sage MAS 500 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 Sage MAS 500 integration partners

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 Sage MAS 500.

Here is a sample of some of these customer connections:

1	A customer connected their Sage MAS 500 7.3 accounting package to Volusion on April 1, 2013 [view]
2	A customer connected their Sage MAS 500 7.3 accounting package to Salesforce on October 30, 2012 [view]
3	A customer connected their Sage MAS 500 7.0 accounting package to Magento on July 26, 2012 [view]
4	A customer connected their Sage MAS 500 6.3 accounting package to Volusion on November 16, 2011 [view]
5	A customer connected their Sage MAS 500 7.3 accounting package to Select Your Integration Connection Above on August 23, 2011 [view]
6	A customer connected their Sage MAS 500 7.3 accounting package to Select Your eCommerce Publisher Above on August 15, 2011 [view]
7	A customer connected their Sage MAS 500 7.3 accounting package to Magento XML on July 6, 2011 [view]
8	A customer connected their Sage MAS 500 7.3 accounting package to Salesforce XML and Magento on June 29, 2011 [view]
9	A customer connected their Sage MAS 500 7.3 accounting package to Business Catalyst Webstore XML to XML on June 23, 2011 [view]
10	A customer connected their Sage MAS 500 7.3 accounting package to Fortune 3 on June 21, 2011 [view]

View more connections

GET A QUOTE
Contact eBridge Connections about connection your Sage MAS 500 accounting software

Inbound Credit Memo

Description: Creates a Credit Memo in the accounting system.

The Inbound Credit Memo touchpoint includes the following fields:

HeaderPONo
HeaderVendID
HeaderReceiptNo
HeaderRcptDate
DetailPOLineNum
DetailItemID
DetailQuantity
DetailUofM
DetailUnitCost

Inbound Customer

Description: Creates a Customer Record in the accounting system.

The Inbound Customer touchpoint includes the following fields:

HeaderTranNo
HeaderCustomerID
HeaderBilltoID
HeaderContactID
HeaderCustPONo
HeaderSalesSourceId
HeaderCustClassID
HeaderSODate
HeaderExpirationDate
HeaderSalesPersonID
HeaderPmtTermsID
HeaderComment
HeaderUserFld1
HeaderUserFld2
HeaderUserFld3
HeaderUserFld4
HeaderWhseID
HeaderDfltShipPriority
HeaderCommPlanID
HeaderReference
HeaderDfltRequestDate
HeaderDfltPromDate
HeaderDfltShipDate
HeaderDfltDropShip
HeaderVendorID
HeaderPurchasefromAddrID
HeaderShipToID
HeaderShipMethID
HeaderFOBID
HeaderCrCardType
HeaderCrCardNo
HeaderCrCardAuthNo
HeaderCrCardExpiration
HeaderHold
HeaderHoldReason
HeaderRequireSOAck
HeaderStatus
HeaderDfltCreatePO
HeaderDfltDeliveryMeth
External Address code
ShipToAddressAddrKey
ShipToAddressAddrLine1
ShipToAddressAddrLine2
ShipToAddressAddrLine3
ShipToAddressAddrLine4
ShipToAddressAddrLine5
ShipToAddressAddrName
ShipToAddressCity
ShipToAddressCountryID
ShipToAddressFax
ShipToAddressFaxExt
ShipToAddressPhone
ShipToAddressPhoneExt
ShipToAddressPostalCode
ShipToAddressStateID
ShipToAddressUpdateCounter
BillToAddressAddressQualifier
BillToAddressAddrKey
BillToAddressAddrLine1
BillToAddressAddrLine2
BillToAddressAddrLine3
BillToAddressAddrLine4
BillToAddressAddrLine5
BillToAddressAddrName
BillToAddressCity
BillToAddressCountryID
BillToAddressFax
BillToAddressFaxExt
BillToAddressPhone
BillToAddressPhoneExt
BillToAddressPostalCode
BillToAddressStateID
BillToAddressUpdateCounter
HeaderNotesCmtType
HeaderNotesNote1
HeaderNotesNote2
HeaderNotesNote3
HeaderNotesNote4
HeaderNotesNote5
HeaderNotesNote6
HeaderNotesNote7
DetailItemID
DetailStatus
DetailWarehouseID
DetailDescription
DetailQtyOrd
DetailQtyOpenToShip
DetailUnitPrice
DetailUnitMeasID
DetailShipMethID
DetailFOBID
DetailShipPriority
DetailShiptoID
DetailFreightAmt
DetailDropShip
DetailVendID
DetailPrimaryAddrName
DetailCommPlanID
DetailCommClassID
DetailGLAcctNo
DetailDescription_1
DetailRequestDateDate
DetailRequestDateTime
DetailShipDateDate
DetailShipDateTime
DetailPromiseDateDate
DetailPromiseDateTime
DetailSTaxClassID
DetailTradeDiscPct
DetailTradeDiscAmt
DetailExtCmnt
DetailHold
DetailHoldREason
DetailUserFld1
DetailUserFld2
DetailInclOnPickList
DetailInclOnPackList
DetailCmntOnly
DetailNotesCmtType
DetailNotesNote1
DetailNotesNote2
DetailNotesNote3
DetailNotesNote4
DetailNotesNote5
DetailNotesNote6
DetailNotesNote7
DetaileBridgeComment

Inbound Customer Payment

Description: Creates a Customer Payment in the accounting system.

The Inbound Customer Payment touchpoint includes the following fields:

HeaderBatchID
HeaderBatchDescription
HeaderWarehouse
HeaderPostDate
HeaderisPrivate
HeaderisOnHold
HeaderOnHoldReason
DetailTranType
DetailTranNo
DetailTranDate
DetailTargetWarehouse
DetailItemID
DetailAdjQty
DetailOnHandQty
DetailUnitOfMeasure
DetailUnitCost
DetailGLAcctNo
DetailAcctRefCode
DetailReasonCode
DetailBinID
DetailLotNo
DetailTranCmnt

Inbound Customer Update

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

The Inbound Customer Update touchpoint includes the following fields:

HeaderCustomerID
HeaderCustomerName
HeaderContactName
HeaderABANo
HeaderCreditLimit
HeaderTaxID
HeaderPhone
HeaderPhoneExt
HeaderFax
HeaderEmail
HeaderPmtTerms
HeaderStmtfromkey
HeaderStmtcyclekey
HeaderInvcfromkey
HeaderRequireSOAck
HeaderSoackformkey
HeaderPacklistformkey
BillTo_ADRAddrLine1
BillTo_ADRAddrLine2
BillTo_ADRAddrLine3
BillTo_ADRAddrLine4
BillTo_ADRAddrName
BillTo_ADRCity
BillTo_ADRCountryID
BillTo_ADRPostalCode
BillTo_ADRStateID
BillTo_ADRUpdateCounter
BillTo_ADRAddrID
ShipTo_ADRAddrLine1
ShipTo_ADRAddrLine2
ShipTo_ADRAddrLine3
ShipTo_ADRAddrLine4
ShipTo_ADRAddrName
ShipTo_ADRCity
ShipTo_ADRCountryID
ShipTo_ADRPostalCode
ShipTo_ADRStateID
ShipTo_ADRUpdateCounter
ShipTo_ADRAddrID

Inbound Inventory Transaction

Description: Creates an Inventory Transaction in the accounting system.

The Inbound Inventory Transaction touchpoint includes the following fields:

Inbound Receipt of Goods

Description: Creates a Receipt of Goods in the accounting system.

The Inbound Receipt of Goods touchpoint includes the following fields:

HeaderSOnum
HeaderWarehouse
HeaderCustomer
HeaderCustPO
HeaderShipTrackNo
HeaderFreightAmt
HeaderShipKey
HeaderTranNo
HeaderSOnumChg
HeaderisNewBatch
DetailSOLineNo
DetailItemID
DetailQtyShipped
DetailBinID

Inbound Sales Order

Description: Creates a Sales Order in the accounting system.

The Inbound Sales Order touchpoint includes the following fields:

HeaderTranNo
HeaderCustomerID
HeaderBilltoID
HeaderContactID
HeaderCustPONo
HeaderSalesSourceId
HeaderCustClassID
HeaderSODate
HeaderExpirationDate
HeaderSalesPersonID
HeaderPmtTermsID
HeaderComment
HeaderUserFld1
HeaderUserFld2
HeaderUserFld3
HeaderUserFld4
HeaderWhseID
HeaderDfltShipPriority
HeaderCommPlanID
HeaderReference
HeaderDfltRequestDate
HeaderDfltPromDate
HeaderDfltShipDate
HeaderDfltDropShip
HeaderVendorID
HeaderPurchasefromAddrID
HeaderShipToID
HeaderShipMethID
HeaderFOBID
HeaderCrCardType
HeaderCrCardNo
HeaderCrCardAuthNo
HeaderCrCardExpiration
HeaderHold
HeaderHoldReason
HeaderRequireSOAck
HeaderStatus
HeaderDfltCreatePO
HeaderDfltDeliveryMeth
External Address code
ShipToAddressAddrKey
ShipToAddressAddrLine1
ShipToAddressAddrLine2
ShipToAddressAddrLine3
ShipToAddressAddrLine4
ShipToAddressAddrLine5
ShipToAddressAddrName
ShipToAddressCity
ShipToAddressCountryID
ShipToAddressFax
ShipToAddressFaxExt
ShipToAddressPhone
ShipToAddressPhoneExt
ShipToAddressPostalCode
ShipToAddressStateID
ShipToAddressUpdateCounter
BillToAddressAddressQualifier
BillToAddressAddrKey
BillToAddressAddrLine1
BillToAddressAddrLine2
BillToAddressAddrLine3
BillToAddressAddrLine4
BillToAddressAddrLine5
BillToAddressAddrName
BillToAddressCity
BillToAddressCountryID
BillToAddressFax
BillToAddressFaxExt
BillToAddressPhone
BillToAddressPhoneExt
BillToAddressPostalCode
BillToAddressStateID
BillToAddressUpdateCounter
HeaderNotesCmtType
HeaderNotesNote1
HeaderNotesNote2
HeaderNotesNote3
HeaderNotesNote4
HeaderNotesNote5
HeaderNotesNote6
HeaderNotesNote7
DetailSOKey
DetailSOLineKey
DetailItemID
DetailStatus
DetailWarehouseID
DetailDescription
DetailQtyOrd
DetailQtyOpenToShip
DetailUnitPrice
DetailUnitMeasID
DetailShipMethID
DetailFOBID
DetailShipPriority
DetailShiptoID
DetailFreightAmt
DetailDropShip
DetailVendID
DetailPrimaryAddrName
DetailCommPlanID
DetailCommClassID
DetailGLAcctNo
DetailDescription_1
DetailRequestDateDate
DetailRequestDateTime
DetailShipDateDate
DetailShipDateTime
DetailPromiseDateDate
DetailPromiseDateTime
DetailSTaxClassID
DetailTradeDiscPct
DetailTradeDiscAmt
DetailExtCmnt
DetailHold
DetailHoldREason
DetailUserFld1
DetailUserFld2
DetailInclOnPickList
DetailInclOnPackList
DetailCmntOnly
DetailNotesCmtType
DetailNotesNote1
DetailNotesNote2
DetailNotesNote3
DetailNotesNote4
DetailNotesNote5
DetailNotesNote6
DetailNotesNote7
DetaileBridgeComment

Inbound Shipment

Description: Creates a Shipment in the accounting system.

The Inbound Shipment touchpoint includes the following fields:

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:

CustomerCustKey
CustomerABANo
CustomerAllowCustRefund
CustomerAllowWriteOff
CustomerBillingType
CustomerCompanyID
CustomerCreateDate
CustomerCreateDateTime
CustomerCreateType
CustomerCreateUserID
CustomerCreditLimit
CustomerCreditLimitAgeCat
CustomerCRMCustID
CustomerCurrExchSchdKey
CustomerCustClassKey
CustomerCustID
CustomerCustName
CustomerCustRefNo
CustomerDateEstab
CustomerDateEstabTime
CustomerDfltBillToAddrKey
CustomerDfltItemKey
CustomerDfltSalesAcctKey
CustomerDfltShipToAddrKey
CustomerFinChgPct
CustomerFinChgFlatAmt
CustomerHold
CustomerImportLogKey
CustomerPrimaryAddrKey
CustomerPrimaryCntctKey
CustomerPrintDunnMsg
CustomerReqCreditLimit
CustomerReqPO
CustomerRetntPct
CustomerSalesReturnAcctKey
CustomerSalesSourceKey
CustomerShipPriority
CustomerStatus
CustomerStdIndusCodeID
CustomerStmtCycleKey
CustomerStmtFormKey
CustomerTradeDiscPct
CustomerUpdateCounter
CustomerUpdateDate
CustomerUpdateDateTime
CustomerUpdateUserID
CustomerUserFld1
CustomerUserFld2
CustomerUserFld3
CustomerUserFld4
CustomerVendKey
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
BillToType
BillToLine1
BillToLine2
BillToLine3
BillToLine4
BillToLine5
BillToName
BillToCity
BillToCountry
BillToFax
BillToFaxExt
BillToPhone
BillToPhoneExt
BillToZipCode
BillToState
ShipToType
ShipToLine1
ShipToLine2
ShipToLine3
ShipToLine4
ShipToLine5
ShipToName
ShipToCity
ShipToCountry
ShipToFax
ShipToFaxExt
ShipToPhone
ShipToPhoneExt
ShipToZipCode
ShipToState
PurchaseFromType
PurchaseFromLine1
PurchaseFromLine2
PurchaseFromLine3
PurchaseFromLine4
PurchaseFromLine5
PurchaseFromName
PurchaseFromCity
PurchaseFromCountry
PurchaseFromFax
PurchaseFromFaxExt
PurchaseFromPhone
PurchaseFromPhoneExt
PurchaseFromZipCode
PurchaseFromState
PrimaryAddressType
PrimaryAddressLine1
PrimaryAddressLine2
PrimaryAddressLine3
PrimaryAddressLine4
PrimaryAddressLine5
PrimaryAddressName
PrimaryAddressCity
PrimaryAddressCountry
PrimaryAddressFax
PrimaryAddressFaxExt
PrimaryAddressPhone
PrimaryAddressPhoneExt
PrimaryAddressZipCode
PrimaryAddressState
RemitToType
RemitToLine1
RemitToLine2
RemitToLine3
RemitToLine4
RemitToLine5
RemitToName
RemitToCity
RemitToCountry
RemitToFax
RemitToFaxExt
RemitToPhone
RemitToPhoneExt
RemitToZipCode
RemitToState
ConsigneeType
ConsigneeLine1
ConsigneeLine2
ConsigneeLine3
ConsigneeLine4
ConsigneeLine5
ConsigneeName
ConsigneeCity
ConsigneeCountry
ConsigneeFax
ConsigneeFaxExt
ConsigneePhone
ConsigneePhoneExt
ConsigneeZipCode
ConsigneeState
CarrierType
CarrierLine1
CarrierLine2
CarrierLine3
CarrierLine4
CarrierLine5
CarrierName
CarrierCity
CarrierCountry
CarrierFax
CarrierFaxExt
CarrierPhone
CarrierPhoneExt
CarrierZipCode
CarrierState
UltimateReceiverType
UltimateReceiverLine1
UltimateReceiverLine2
UltimateReceiverLine3
UltimateReceiverLine4
UltimateReceiverLine5
UltimateReceiverName
UltimateReceiverCity
UltimateReceiverCountry
UltimateReceiverFax
UltimateReceiverFaxExt
UltimateReceiverPhone
UltimateReceiverPhoneExt
UltimateReceiverZipCode
UltimateReceiverState

Outbound Inventory

Description: Extracts an Inventory Record from the accounting system.

The Outbound Inventory touchpoint includes the following fields:

DetailItemKey
DetailAllowCostOvrd
DetailAllowDecimalQty
DetailAllowDropShip
DetailAllowPriceOvrd
DetailAllowRtrns
DetailAvailForSale
DetailCommClassKey
DetailCommodityCodeKey
DetailCompanyID
DetailCOSAcctKey
DetailCreateDateDate
DetailCreateDateTime
DetailCreateType
DetailCreateUserID
DetailCRMItemID
DetailDateEstabDate
DetailDateEstabTime
DetailDfltWhseKey
DetailExpAcctKey
DetailFreightClassKey
DetailImportLogKey
DetailInclOnPackList
DetailInternalLongDesc
DetailIntrnlDeliveryReq
DetailItemClassKey
DetailItemID
DetailItemSubType
DetailItemType
DetailMatchToleranceKey
DetailMatSafetySheetKey
DetailMinSaleQty
DetailPerUsageOrdLimit
DetailPriceSeq
DetailPriceUnitMeasKey
DetailProdDetlLink
DetailProdPriceGroupKey
DetailPurchProdLineKey
DetailPurchUnitMeasKey
DetailRcptReq
DetailRcvgCmnt
DetailRestockRate
DetailReturnsAcctKey
DetailRplcmntUnitCost
DetailSaleMultiple
DetailSalesAcctKey
DetailSalesProdLineKey
DetailSalesUnitMeasKey
DetailSeasonal
DetailShelfLife
DetailStatus
DetailSTaxClassKey
DetailStdBinQty
DetailStdPrice
DetailStdUnitCost
DetailStockUnitMeasKey
DetailSubjToTradeDisc
DetailSuccessorDateDate
DetailSuccessorDateTime
DetailSuccessorItemKey
DetailTargetMargin
DetailTrackMeth
DetailUpdateCounter
DetailUpdateDateDate
DetailUpdateDateTime
DetailUpdateUserID
DetailUserFld1
DetailUserFld2
DetailUserFld3
DetailUserFld4
DetailUserFld5
DetailUserFld6
DetailValuationMeth
DetailVendFamilyKey
DetailWarrantyDays
DetailWarrantyProvider
DetailShortDesc
ItemTranslationStatus
ItemItemID
ItemItemDesc
ItemExternalID
ItemExternalDesc
ItemBuffer
ItemLevel
ItemEDIFlag
ItemUPCCode
ItemCustomField1
ItemCustomField2
ItemCustomField3
ItemCustomField4
ItemCustomField5
ItemWeight
ItemHeight
ItemLength
ItemWidth
ItemInnerPack
ItemStandPack

Outbound Posted Invoice

Description: Extracts a Posted Invoice from the accounting system.

The Outbound Posted Invoice touchpoint includes the following fields:

HeaderInvcKey
HeaderAuthOvrdAmt
HeaderBalance
HeaderBalanceHC
HeaderBatchKey
HeaderBillToAddrKey
HeaderBillToCustAddrKey
HeaderBillToCustAddrID
HeaderClosingPostDateDate
HeaderClosingPostDateTime
HeaderClosingTranDateDate
HeaderClosingTranDateTime
HeaderCommPlanKey
HeaderCommPlanID
HeaderCompanyID
HeaderConfirmToCntctKey
HeaderConfirmToCntctName
HeaderCostOfSales
HeaderCreateDateDate
HeaderCreateDateTime
HeaderCreateType
HeaderCreateUserID
HeaderCurrExchRate
HeaderCurrExchSchdKey
HeaderCurrExchSchdID
HeaderCurrID
HeaderCustClassKey
HeaderCustClassID
HeaderCustKey
HeaderCustID
HeaderCustPONo
HeaderDiscAmt
HeaderDiscDateDate
HeaderDiscDateTime
HeaderDiscTakenAmt
HeaderDueDateDate
HeaderDueDateTime
HeaderFOBKey
HeaderFOBID
HeaderHandlAmt
HeaderImportLogKey
HeaderImportLogID
HeaderInDispute
HeaderInvcFormKey
HeaderNextApplEntryNo
HeaderPmtTermsKey
HeaderPmtTermsID
HeaderPostDateDate
HeaderPostDateTime
HeaderPrimarySperKey
HeaderPrimarySperID
HeaderReasonCodeKey
HeaderReasonCodeID
HeaderRecurInvoiceKey
HeaderRetntAmt
HeaderRetntPct
HeaderSalesAmt
HeaderShipAmt
HeaderShipMethKey
HeaderShipMethID
HeaderShipToAddrKey
HeaderShipToCustAddrKey
HeaderShipToCustAddrID
HeaderShipZoneKey
HeaderShipZoneID
HeaderSourceModule
HeaderStatus
HeaderSTaxAmt
HeaderSTaxCalc
HeaderSTaxTranKey
HeaderTradeDiscAmt
HeaderTranAmt
HeaderTranAmtHC
HeaderTranCmnt
HeaderTranDateDate
HeaderTranDateTime
HeaderTranID
HeaderTranNo
HeaderTranType
HeaderUpdateCounter
HeaderUpdateDateDate
HeaderUpdateDateTime
HeaderUpdateUserID
HeaderVoucherKey
HeaderVoucherNo
HeaderShipTrackNo
HeaderCustRefNo
HeaderCorrespondingSONo
Header1BOLReq
Header1CalcMeth
Header1CalcUnit
Header1ShipChargeRate
Header1ShipMethDesc
Header1ShipMethID
Header1Description
Header1FOBID
Header1Description_1
Header1Description_2
Header1VouchNo
Header1Description_3
Header1DiscDateOption
Header1DiscDayOrMonth
Header1DiscFixedDateDate
Header1DiscFixedDateTime
Header1DiscMinDays
Header1DiscPct
Header1DueDateOption
Header1DueDayOrMonth
Header1DueFixedDateDate
Header1DueFixedDateTime
Header1DueMinDays
Header1PmtTermsID
Header1CustClassName
Header1ShipZoneID
Header1Name
HeaderPackagePackageKey
HeaderPackageCartonKey
HeaderPackageComment
HeaderPackageDeclaredValue
HeaderPackageExtShipSystemFreightAmt
HeaderPackageFreightClassKey
HeaderPackageGrossWeight
HeaderPackageHazMat
HeaderPackagePackageNo
HeaderPackageShipKey
HeaderPackageShipTrackNo
HeaderPackageShipmentTranNo
HeaderPackageInvoiceTranNo
HeaderPackageInvoiceTranNo
HeaderPackageInvoiceDateDate
HeaderPackageInvoiceDateTime
CustomerPartnerType
CustomerTranslationStatus
CustomerPartnerID
CustomerPartnerName
CustomerExternalID
CustomerExternalDesc
CustomerBuffer
CustomerLevel
CustomerEDIFlag
CustomerCustomField1
CustomerCustomField2
CustomerCustomField3
CustomerCustomField4
CustomerCustomField5
CustomerPriceSource
CustomerASNFormat
CustomerASNConType
CustomerGroupID
CustomerGroupDesc
CustomerGroupStatus
CustomerGroupField1
CustomerGroupField2
CustomerGroupField3
CustomerGroupField4
CustomerGroupField5
CustomerSPartnerGroupNo
CustomerSPartnerGroupID2
CustomerSPartnerGroupDesc2
BillToTranslationStatus
BillToTranslationShipID
BillToTranslationShipName
BillToTranslationExternalID
BillToTranslationExternalDesc
BillToTranslationBuffer
BillToTranslationLevel
BillToTranslationEDIFlag
BillToTranslationCustomField1
BillToTranslationCustomField2
BillToTranslationCustomField3
BillToTranslationCustomField4
BillToTranslationCustomField5
BillToADRType
BillToADRLine1
BillToADRLine2
BillToADRLine3
BillToADRLine4
BillToAD1Line5
BillToADRName
BillToADRCity
BillToADRCountry
BillToADRFax
BillToADRFaxExt
BillToADRPhone
BillToADRPhoneExt
BillToADRZipCode
BillToADRState
ShipToADRType
ShipToADRLine1
ShipToADRLine2
ShipToADRLine3
ShipToADRLine4
ShipToAD1Line5
ShipToADRName
ShipToADRCity
ShipToADRCountry
ShipToADRFax
ShipToADRFaxExt
ShipToADRPhone
ShipToADRPhoneExt
ShipToADRZipCode
ShipToADRState
PurchaseFromADRType
PurchaseFromADRLine1
PurchaseFromADRLine2
PurchaseFromADRLine3
PurchaseFromADRLine4
PurchaseFromAD1Line5
PurchaseFromADRName
PurchaseFromADRCity
PurchaseFromADRCountry
PurchaseFromADRFax
PurchaseFromADRFaxExt
PurchaseFromADRPhone
PurchaseFromADRPhoneExt
PurchaseFromADRZipCode
PurchaseFromADRState
PrimaryADRType
PrimaryADRLine1
PrimaryADRLine2
PrimaryADRLine3
PrimaryADRLine4
PrimaryAD1Line5
PrimaryADRName
PrimaryADRCity
PrimaryADRCountry
PrimaryADRFax
PrimaryADRFaxExt
PrimaryADRPhone
PrimaryADRPhoneExt
PrimaryADRZipCode
PrimaryADRState
RemitToADRType
RemitToADRLine1
RemitToADRLine2
RemitToADRLine3
RemitToADRLine4
RemitToAD1Line5
RemitToADRName
RemitToADRCity
RemitToADRCountry
RemitToADRFax
RemitToADRFaxExt
RemitToADRPhone
RemitToADRPhoneExt
RemitToADRZipCode
RemitToADRState
ConsigneeADRType
ConsigneeADRLine1
ConsigneeADRLine2
ConsigneeADRLine3
ConsigneeADRLine4
ConsigneeAD1Line5
ConsigneeADRName
ConsigneeADRCity
ConsigneeADRCountry
ConsigneeADRFax
ConsigneeADRFaxExt
ConsigneeADRPhone
ConsigneeADRPhoneExt
ConsigneeADRZipCode
ConsigneeADRState
CarrierADRType
CarrierADRLine1
CarrierADRLine2
CarrierADRLine3
CarrierADRLine4
CarrierAD1Line5
CarrierADRName
CarrierADRCity
CarrierADRCountry
CarrierADRFax
CarrierADRFaxExt
CarrierADRPhone
CarrierADRPhoneExt
CarrierADRZipCode
CarrierADRState
UltimateReceiverADRType
UltimateReceiverADRLine1
UltimateReceiverADRLine2
UltimateReceiverADRLine3
UltimateReceiverADRLine4
UltimateReceiverAD1Line5
UltimateReceiverADRName
UltimateReceiverADRCity
UltimateReceiverADRCountry
UltimateReceiverADRFax
UltimateReceiverADRFaxExt
UltimateReceiverADRPhone
UltimateReceiverADRPhoneExt
UltimateReceiverADRZipCode
UltimateReceiverADRState
ShipToTranslationStatus
ShipToTranslationShipID
ShipToTranslationShipName
ShipToTranslationExternalID
ShipToTranslationExternalDesc
ShipToTranslationBuffer
ShipToTranslationLevel
ShipToTranslationEDIFlag
ShipToTranslationCustomField1
ShipToTranslationCustomField2
ShipToTranslationCustomField3
ShipToTranslationCustomField4
ShipToTranslationCustomField5
DetailInvoiceLineKey
DetailActCommAmt
DetailCalcCommAmt
DetailCmntOnly
DetailCommBase
DetailCommClassKey
DetailCommClassID
DetailCommPlanKey
DetailCommPlanID
DetailDescription
DetailExtAmt
DetailExtCmnt
DetailInvcKey
DetailItemAliasKey
DetailItemAliasID
DetailItemKey
DetailItemID
DetailKitInvoiceLineKey
DetailProjClientID
DetailProjID
DetailRtrnType
DetailSeqNo
DetailShipLineKey
DetailSOLineKey
DetailSTaxClassKey
DetailTradeDiscAmt
DetailUnitCost
DetailUnitMeasKey
DetailUnitMeasID
DetailUnitPrice
DetailUnitPriceOvrd
DetailSOLineNo
DetailSOUserFld1
DetailSOUserFld2
DetailDistributionInvoiceLineDistKey
DetailDistributionAcctRefKey
DetailDistributionAcctRefNo
DetailDistributionExtAmt
DetailDistributionFOBKey
DetailDistributionFOBID
DetailDistributionFreightAmt
DetailDistributionInvoiceLineKey
DetailDistributionQtyShipped
DetailDistributionSalesAcctKey
DetailDistributionSalesAcctNo
DetailDistributionShipLineDistKey
DetailDistributionShipMethKey
DetailDistributionShipMethID
DetailDistributionShipZoneKey
DetailDistributionShipZoneID
DetailDistributionSOLineDistKey
DetailDistributionSTaxTranKey
DetailDistributionTradeDiscAmt
DetailItemDataItemKey
DetailItemDataAllowCostOvrd
DetailItemDataAllowDecimalQty
DetailItemDataAllowDropShip
DetailItemDataAllowPriceOvrd
DetailItemDataAllowRtrns
DetailItemDataAvailForSale
DetailItemDataCommClassKey
DetailItemDataCommodityCodeKey
DetailItemDataCompanyID
DetailItemDataCOSAcctKey
DetailItemDataCreateDate
DetailItemDataCreateType
DetailItemDataCreateUserID
DetailItemDataCRMItemID
DetailItemDataDateEstab
DetailItemDataDfltWhseKey
DetailItemDataExpAcctKey
DetailItemDataFASAssetTemplate
DetailItemDataFreightClassKey
DetailItemDataImportLogKey
DetailItemDataInclOnPackList
DetailItemDataInternalLongDesc
DetailItemDataIntrnlDeliveryReq
DetailItemDataItemClassKey
DetailItemDataItemID
DetailItemDataItemSubType
DetailItemDataItemType
DetailItemDataMatchToleranceKey
DetailItemDataMatSafetySheetKey
DetailItemDataMinSaleQty
DetailItemDataPerUsageOrdLimit
DetailItemDataPriceSeq
DetailItemDataPriceUnitMeasKey
DetailItemDataProdDetlLink
DetailItemDataProdPriceGroupKey
DetailItemDataPurchProdLineKey
DetailItemDataPurchUnitMeasKey
DetailItemDataRcptReq
DetailItemDataRcvgCmnt
DetailItemDataRestockRate
DetailItemDataReturnsAcctKey
DetailItemDataRplcmntUnitCost
DetailItemDataSaleMultiple
DetailItemDataSalesAcctKey
DetailItemDataSalesProdLineKey
DetailItemDataSalesUnitMeasKey
DetailItemDataSeasonal
DetailItemDataShelfLife
DetailItemDataStatus
DetailItemDataSTaxClassKey
DetailItemDataStdBinQty
DetailItemDataStdPrice
DetailItemDataStdUnitCost
DetailItemDataStockUnitMeasKey
DetailItemDataSubjToTradeDisc
DetailItemDataSuccessorDate
DetailItemDataSuccessorItemKey
DetailItemDataTargetMargin
DetailItemDataTrackMeth
DetailItemDataUpdateCounter
DetailItemDataUpdateDate
DetailItemDataUpdateUserID
DetailItemDataUserFld1
DetailItemDataUserFld2
DetailItemDataUserFld3
DetailItemDataUserFld4
DetailItemDataUserFld5
DetailItemDataUserFld6
DetailItemDataValuationMeth
DetailItemDataVendFamilyKey
DetailItemDataWarrantyDays
DetailItemDataWarrantyProvider
DetailItemDataCommClassID
DetailItemDataCommodityCodeID
DetailItemDataGLAcctNo
DetailItemDataWhseID
DetailItemDataItemClassID
DetailItemDataFreightClassID
DetailItemDataPriceUnitMeasID
DetailItemDataPurchUnitMeasID
DetailItemDataSalesUnitMeasID
DetailItemDataStockUnitMeasID
DetailItemDataSalesProdLineID
DetailItemDataPurchProdLineID
DetailItemDataProdPriceGroupID
DetailPackageDeclaredValue
DetailPackageExtShipSystemFreightAmt
DetailPackageFreightClassKey
DetailPackageGrossWeight
DetailPackageHazMat
DetailPackagePackageNo
DetailPackageShipTrackNo
DetailPackageQty
DetailPackageComment
DetailItemTransStatus
DetailItemLocalID
DetailItemLocalDesc
DetailItemExternalID
DetailItemExternalDesc
DetailItembuffer
DetailItemTranLevel
DetailItemBridgeFlag
DetailItemUPC
DetailItemCustomField1
DetailItemCustomField2
DetailItemCustomField3
DetailItemCustomField4
DetailItemCustomField5
DetailItemWeight
DetailItemLength
DetailItemHeight
DetailItemWidth
DetailItemInnerPack
DetailItemStandPack
DetailDDXData
DetailUPCUnitMeasID
DetailUPCConversionFacto
DetailUPCUnitVolume
DetailUPCUnitWeight
DetailUPCUPC
DetailUPCUseForPurchases
DetailUPCUseForSales
DetailUPCUseStdConv

Outbound Sales Order

Description: Extracts a Sales Order from the accounting system.

The Outbound Sales Order touchpoint includes the following fields:

HeaderSOKey
HeaderAckDateDate
HeaderAckDateTime
HeaderAuthOvrdAmt
HeaderBillToAddrKey
HeaderBillToCustAddrKey
HeaderBillToCustAddrID
HeaderBlnktRelNo
HeaderBlnktSOKey
HeaderChngOrdDateDate
HeaderChngOrdDateTime
HeaderChngOrdNo
HeaderChngReason
HeaderChngUserID
HeaderCloseDateDate
HeaderCloseDateTime
HeaderCntctKey
HeaderCntctName
HeaderCompanyID
HeaderCrCardAuthNo
HeaderCrCardExpiration
HeaderCrCardNo
HeaderCreateDateDate
HeaderCreateDateTime
HeaderCreateType
HeaderCreateUserID
HeaderCrHold
HeaderCurrExchRate
HeaderCurrExchSchdKey
HeaderCurrExchSchdID
HeaderCurrID
HeaderCustClassKey
HeaderCustClassID
HeaderCustKey
HeaderCustID
HeaderCustPONo
HeaderCustQuoteKey
HeaderCustQuoteNo
HeaderDfltAcctRefKey
HeaderDfltAcctRefNo
HeaderDfltCommPlanKey
HeaderDfltCommPlanID
HeaderDfltDropShip
HeaderDfltFOBKey
HeaderDfltFOBID
HeaderDfltPromDateDate
HeaderDfltPromDateTime
HeaderDfltPurchVAddrKey
HeaderDfltPurchVAddrID
HeaderDfltRequestDateDate
HeaderDfltRequestDateTime
HeaderDfltShipDateDate
HeaderDfltShipDateTime
HeaderDfltShipMethKey
HeaderDfltShipMethID
HeaderDfltShipPriority
HeaderDfltShipToAddrKey
HeaderDfltShipToCAddrKey
HeaderDfltShipToCAddrID
HeaderDfltShipZoneKey
HeaderDfltShipZoneID
HeaderDfltVendKey
HeaderDfltVendID
HeaderDfltWhseKey
HeaderDfltWhseID
HeaderExpirationDate
HeaderExpirationTime
HeaderFixedCurrExchRate
HeaderFreightAmt
HeaderHold
HeaderHoldReason
HeaderImportLogKey
HeaderImportLogID
HeaderNextLineNo
HeaderOpenAmt
HeaderOpenAmtHC
HeaderPmtTermsKey
HeaderPmtTermsID1
HeaderPrimarySperKey
HeaderPrimarySperID
HeaderQuoteFormKey
HeaderRecurSOKey
HeaderRecurSONo
HeaderSalesAmt
HeaderSalesAmtHC
HeaderSalesSourceKey
HeaderSalesSourceID
HeaderSOAckFormKey
HeaderStatus
HeaderSTaxAmt
Header1STaxCalc
Header1STaxTranKey
Header1TenderTypeKey
Header1TenderTypeID
Header1TradeDiscAmt
Header1TranAmt
Header1TranAmtHC
Header1TranCmnt
Header1TranDateDate
Header1TranDateTime
Header1TranID
Header1TranNo
Header1TranNoChngOrd
Header1TranNoRel
Header1TranNoRelChngOrd
Header1TranType
Header1UpdateCounter
Header1UpdateDateDate
Header1UpdateDateTime
Header1UpdateUserID
Header1UserFld1
Header1UserFld2
Header1UserFld3
Header1UserFld4
Header1BOLReq
Header1CalcMeth
Header1CalcUnit
Header1ShipChargeRate
Header1ShipMethDesc
Header1ShipMethID
Header1Description
Header1FOBID
Header1Description_1
Header1Description_2
Header1DiscDateOption
Header1DiscDayOrMonth
Header1DiscFixedDateDate
Header1DiscFixedDateTime
Header1DiscMinDays
Header1DiscPct
Header1DueDateOption
Header1DueDayOrMonth
Header1DueFixedDateDate
Header1DueFixedDateTime
Header1DueMinDays
Header1PmtTermsID
Header1CustClassName
Header1ShipZoneID
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
BillToTranslationStatus
BillToTranslationShipID"
BillToTranslationShipName"
BillToTranslationExternalID"
BillToTranslationExternalDesc"
BillToTranslationBuffer"
BillToTranslationLevel"
BillToTranslationEDIFlag"
BillToTranslationCustomField1"
BillToTranslationCustomField2"
BillToTranslationCustomField3"
BillToTranslationCustomField4"
BillToTranslationCustomField5"
ShipToTranslationStatus
ShipToTranslationShipID
ShipToTranslationShipName
ShipToTranslationExternalID
ShipToTranslationExternalDesc
ShipToTranslationBuffer
ShipToTranslationLevel
ShipToTranslationEDIFlag
ShipToTranslationCustomField1
ShipToTranslationCustomField2
ShipToTranslationCustomField3
ShipToTranslationCustomField4
ShipToTranslationCustomField5
BillToADRType
BillToADRLine1
BillToADRLine2
BillToADRLine3
BillToADRLine4
BillToAD1Line5
BillToADRName
BillToADRCity
BillToADRCountry
BillToADRFax
BillToADRFaxExt
BillToADRPhone
BillToADRPhoneExt
BillToADRZipCode
BillToADRState
ShipToADRType
ShipToADRLine1
ShipToADRLine2
ShipToADRLine3
ShipToADRLine4
ShipToAD1Line5
ShipToADRName
ShipToADRCity
ShipToADRCountry
ShipToADRFax
ShipToADRFaxExt
ShipToADRPhone
ShipToADRPhoneExt
ShipToADRZipCode
ShipToADRState
PurchaseFromADRType
PurchaseFromADRLine1
PurchaseFromADRLine2
PurchaseFromADRLine3
PurchaseFromADRLine4
PurchaseFromAD1Line5
PurchaseFromADRName
PurchaseFromADRCity
PurchaseFromADRCountry
PurchaseFromADRFax
PurchaseFromADRFaxExt
PurchaseFromADRPhone
PurchaseFromADRPhoneExt
PurchaseFromADRZipCode
PurchaseFromADRState
PrimaryADRType
PrimaryADRLine1
PrimaryADRLine2
PrimaryADRLine3
PrimaryADRLine4
PrimaryAD1Line5
PrimaryADRName
PrimaryADRCity
PrimaryADRCountry
PrimaryADRFax
PrimaryADRFaxExt
PrimaryADRPhone
PrimaryADRPhoneExt
PrimaryADRZipCode
PrimaryADRState
RemitToADRType
RemitToADRLine1
RemitToADRLine2
RemitToADRLine3
RemitToADRLine4
RemitToAD1Line5
RemitToADRName
RemitToADRCity
RemitToADRCountry
RemitToADRFax
RemitToADRFaxExt
RemitToADRPhone
RemitToADRPhoneExt
RemitToADRZipCode
RemitToADRState
ConsigneeADRType
ConsigneeADRLine1
ConsigneeADRLine2
ConsigneeADRLine3
ConsigneeADRLine4
ConsigneeAD1Line5
ConsigneeADRName
ConsigneeADRCity
ConsigneeADRCountry
ConsigneeADRFax
ConsigneeADRFaxExt
ConsigneeADRPhone
ConsigneeADRPhoneExt
ConsigneeADRZipCode
ConsigneeADRState
CarrierADRType
CarrierADRLine1
CarrierADRLine2
CarrierADRLine3
CarrierADRLine4
CarrierAD1Line5
CarrierADRName
CarrierADRCity
CarrierADRCountry
CarrierADRFax
CarrierADRFaxExt
CarrierADRPhone
CarrierADRPhoneExt
CarrierADRZipCode
CarrierADRState
UltimateReceiverADRType
UltimateReceiverADRLine1
UltimateReceiverADRLine2
UltimateReceiverADRLine3
UltimateReceiverADRLine4
UltimateReceiverAD1Line5
UltimateReceiverADRName
UltimateReceiverADRCity
UltimateReceiverADRCountry
UltimateReceiverADRFax
UltimateReceiverADRFaxExt
UltimateReceiverADRPhone
UltimateReceiverADRPhoneExt
UltimateReceiverADRZipCode
UltimateReceiverADRState
DetailSOLineKey
DetailCloseDateDate
DetailCloseDateTime
DetailCmntOnly
DetailCommClassKey
DetailCommClassID
DetailCommPlanKey
DetailCommPlanID
DetailCustQuoteLineKey
DetailDescription
DetailExtCmnt
DetailInclOnPackList
DetailInclOnPickList
DetailItemAliasKey
DetailItemAliasID
DetailItemKey
DetailItemID
DetailPOLineKey
DetailReqCert
DetailSOKey
DetailSONo
DetailSOLineNo
DetailStatus
DetailSTaxClassKey
DetailUnitMeasKey
DetailUnitMeasID
DetailUnitPrice
DetailUnitPriceOvrd
DetailUpdateCounter
DetailUserFld1
DetailUserFld2
DetailDistributionSOLineDistKey
DetailDistributionAcctRefKey
DetailDistributionAcctRefNo
DetailDistributionAmtInvcd
DetailDistributionBlnktSOLineDistKey
DetailDistributionDropShip
DetailDistributionExtAmt
DetailDistributionFOBKey
DetailDistributionFOBID
DetailDistributionFreightAmt
DetailDistributionGLAcctKey
DetailDistributionGLAcctNo
DetailDistributionHold
DetailDistributionHoldReason
DetailDistributionOrigOrdered
DetailDistributionOrigPromiseDateDate
DetailDistributionOrigPromiseDateTime
DetailDistributionPromiseDateDate
DetailDistributionPromiseDateTime
DetailDistributionPurchVendAddrKey
DetailDistributionPurchVendAddrID
DetailDistributionQtyInvcd
DetailDistributionQtyOnBO
DetailDistributionQtyOpenToShip
DetailDistributionQtyOrd
DetailDistributionQtyRtrnCredit
DetailDistributionQtyRtrnReplacement
DetailDistributionQtyShip
DetailDistributionRequestDateDate
DetailDistributionRequestDateTime
DetailDistributionShipDateDate
DetailDistributionShipDateTime
DetailDistributionShipMethKey
DetailDistributionShipMethID
DetailDistributionShipPriority
DetailDistributionShipToAddrKey
DetailDistributionShipToCustAddrKey
DetailDistributionShipToCustAddrID
DetailDistributionShipZoneKey
DetailDistributionShipZoneID
DetailDistributionSOLineKey
DetailDistributionStatus
DetailDistributionSTaxTranKey
DetailDistributionTradeDiscAmt
DetailDistributionTradeDiscPct
DetailDistributionUpdateCounter
DetailDistributionVendKey
DetailDistributionVendID
DetailDistributionWhseKey
DetailDistributionWhseID
DetailTranslationTranslationStatus
DetailTranslationItemID
DetailTranslationItemDesc
DetailTranslationExternalID
DetailTranslationExternalDesc
DetailTranslationBuffer
DetailTranslationLevel
DetailTranslationEDIFlag
DetailTranslationUPCCode
DetailTranslationCustomField1
DetailTranslationCustomField2
DetailTranslationCustomField3
DetailTranslationCustomField4
DetailTranslationCustomField5
DetailTranslationWeight
DetailTranslationHeight
DetailTranslationLength
DetailTranslationWidth
DetailTranslationInnerPack
DetailTranslationStandPack
DetailUPCUnitMeasID
DetailUPCConversionFacto
DetailUPCUnitVolume
DetailUPCUnitWeight
DetailUPCUPC
DetailUPCUseForPurchases
DetailUPCUseForSales
DetailUPCUseStdConv

Outbound Unposted Invoice

Description: Extracts an Unposted Invoice from the accounting system.

The Outbound Unposted Invoice touchpoint includes the following fields:

HeaderInvcKey
HeaderAuthOvrdAmt
HeaderBalance
HeaderBalanceHC
HeaderBatchKey
HeaderBillToAddrKey
HeaderBillToCustAddrKey
HeaderBillToCustAddrID
HeaderClosingPostDateDate
HeaderClosingPostDateTime
HeaderClosingTranDateDate
HeaderClosingTranDateTime
HeaderCommPlanKey
HeaderCommPlanID
HeaderCompanyID
HeaderConfirmToCntctKey
HeaderConfirmToCntctName
HeaderCostOfSales
HeaderCreateDateDate
HeaderCreateDateTime
HeaderCreateType
HeaderCreateUserID
HeaderCurrExchRate
HeaderCurrExchSchdKey
HeaderCurrExchSchdID
HeaderCurrID
HeaderCustClassKey
HeaderCustClassID
HeaderCustKey
HeaderCustID
HeaderCustPONo
HeaderDiscAmt
HeaderDiscDateDate
HeaderDiscDateTime
HeaderDiscTakenAmt
HeaderDueDateDate
HeaderDueDateTime
HeaderFOBKey
HeaderFOBID
HeaderHandlAmt
HeaderImportLogKey
HeaderImportLogID
HeaderInDispute
HeaderInvcFormKey
HeaderNextApplEntryNo
HeaderPmtTermsKey
HeaderPmtTermsID
HeaderPostDateDate
HeaderPostDateTime
HeaderPrimarySperKey
HeaderPrimarySperID
HeaderReasonCodeKey
HeaderReasonCodeID
HeaderRecurInvoiceKey
HeaderRetntAmt
HeaderRetntPct
HeaderSalesAmt
HeaderShipAmt
HeaderShipMethKey
HeaderShipMethID
HeaderShipToAddrKey
HeaderShipToCustAddrKey
HeaderShipToCustAddrID
HeaderShipZoneKey
HeaderShipZoneID
HeaderSourceModule
HeaderStatus
HeaderSTaxAmt
HeaderSTaxCalc
HeaderSTaxTranKey
HeaderTradeDiscAmt
HeaderTranAmt
HeaderTranAmtHC
HeaderTranCmnt
HeaderTranDateDate
HeaderTranDateTime
HeaderTranID
HeaderTranNo
HeaderTranType
HeaderUpdateCounter
HeaderUpdateDateDate
HeaderUpdateDateTime
HeaderUpdateUserID
HeaderVoucherKey
HeaderVoucherNo
HeaderShipTrackNo
HeaderCustRefNo
HeaderCorrespondingSONo
Header1BOLReq
Header1CalcMeth
Header1CalcUnit
Header1ShipChargeRate
Header1ShipMethDesc
Header1ShipMethID
Header1Description
Header1FOBID
Header1Description_1
Header1Description_2
Header1VouchNo
Header1Description_3
Header1DiscDateOption
Header1DiscDayOrMonth
Header1DiscFixedDateDate
Header1DiscFixedDateTime
Header1DiscMinDays
Header1DiscPct
Header1DueDateOption
Header1DueDayOrMonth
Header1DueFixedDateDate
Header1DueFixedDateTime
Header1DueMinDays
Header1PmtTermsID
Header1CustClassName
Header1ShipZoneID
Header1Name
HeaderCustomerPartnerType
HeaderCustomerTranslationStatus
HeaderCustomerPartnerID
HeaderCustomerPartnerName
HeaderCustomerExternalID
HeaderCustomerExternalDesc
HeaderCustomerBuffer
HeaderCustomerLevel
HeaderCustomerEDIFlag
HeaderCustomerCustomField1
HeaderCustomerCustomField2
HeaderCustomerCustomField3
HeaderCustomerCustomField4
HeaderCustomerCustomField5
HeaderCustomerPriceSource
HeaderCustomerASNFormat
HeaderCustomerASNConType
HeaderCustomerGroupID
HeaderCustomerGroupDesc
HeaderCustomerGroupStatus
HeaderCustomerGroupField1
HeaderCustomerGroupField2
HeaderCustomerGroupField3
HeaderCustomerGroupField4
HeaderCustomerGroupField5
HeaderCustomerSPartnerGroupNo
HeaderCustomerSPartnerGroupID2
HeaderCustomerSPartnerGroupDesc2
BillToTranslationStatus
BillToTranslationShipID
BillToTranslationShipName
BillToTranslationExternalID
BillToTranslationExternalDesc
BillToTranslationBuffer
BillToTranslationLevel
BillToTranslationEDIFlag
BillToTranslationCustomField1
BillToTranslationCustomField2
BillToTranslationCustomField3
BillToTranslationCustomField4
BillToTranslationCustomField5
BillToADRType
BillToADRLine1
BillToADRLine2
BillToADRLine3
BillToADRLine4
BillToAD1Line5
BillToADRName
BillToADRCity
BillToADRCountry
BillToADRFax
BillToADRFaxExt
BillToADRPhone
BillToADRPhoneExt
BillToADRZipCode
BillToADRState
ShipToADRType
ShipToADRLine1
ShipToADRLine2
ShipToADRLine3
ShipToADRLine4
ShipToAD1Line5
ShipToADRName
ShipToADRCity
ShipToADRCountry
ShipToADRFax
ShipToADRFaxExt
ShipToADRPhone
ShipToADRPhoneExt
ShipToADRZipCode
ShipToADRState
PurchaseFromADRType
PurchaseFromADRLine1
PurchaseFromADRLine2
PurchaseFromADRLine3
PurchaseFromADRLine4
PurchaseFromAD1Line5
PurchaseFromADRName
PurchaseFromADRCity
PurchaseFromADRCountry
PurchaseFromADRFax
PurchaseFromADRFaxExt
PurchaseFromADRPhone
PurchaseFromADRPhoneExt
PurchaseFromADRZipCode
PurchaseFromADRState
PrimaryADRType
PrimaryADRLine1
PrimaryADRLine2
PrimaryADRLine3
PrimaryADRLine4
PrimaryAD1Line5
PrimaryADRName
PrimaryADRCity
PrimaryADRCountry
PrimaryADRFax
PrimaryADRFaxExt
PrimaryADRPhone
PrimaryADRPhoneExt
PrimaryADRZipCode
PrimaryADRState
RemitToADRType
RemitToADRLine1
RemitToADRLine2
RemitToADRLine3
RemitToADRLine4
RemitToAD1Line5
RemitToADRName
RemitToADRCity
RemitToADRCountry
RemitToADRFax
RemitToADRFaxExt
RemitToADRPhone
RemitToADRPhoneExt
RemitToADRZipCode
RemitToADRState
ConsigneeADRType
ConsigneeADRLine1
ConsigneeADRLine2
ConsigneeADRLine3
ConsigneeADRLine4
ConsigneeAD1Line5
ConsigneeADRName
ConsigneeADRCity
ConsigneeADRCountry
ConsigneeADRFax
ConsigneeADRFaxExt
ConsigneeADRPhone
ConsigneeADRPhoneExt
ConsigneeADRZipCode
ConsigneeADRState
CarrierADRType
CarrierADRLine1
CarrierADRLine2
CarrierADRLine3
CarrierADRLine4
CarrierAD1Line5
CarrierADRName
CarrierADRCity
CarrierADRCountry
CarrierADRFax
CarrierADRFaxExt
CarrierADRPhone
CarrierADRPhoneExt
CarrierADRZipCode
CarrierADRState
UltimateReceiverADRType
UltimateReceiverADRLine1
UltimateReceiverADRLine2
UltimateReceiverADRLine3
UltimateReceiverADRLine4
UltimateReceiverAD1Line5
UltimateReceiverADRName
UltimateReceiverADRCity
UltimateReceiverADRCountry
UltimateReceiverADRFax
UltimateReceiverADRFaxExt
UltimateReceiverADRPhone
UltimateReceiverADRPhoneExt
UltimateReceiverADRZipCode
UltimateReceiverADRState
ShipToTranslationStatus
ShipToTranslationShipID
ShipToTranslationShipName
ShipToTranslationExternalID
ShipToTranslationExternalDesc
ShipToTranslationBuffer
ShipToTranslationLevel
ShipToTranslationEDIFlag
ShipToTranslationCustomField1
ShipToTranslationCustomField2
ShipToTranslationCustomField3
ShipToTranslationCustomField4
ShipToTranslationCustomField5
DetailInvoiceLineKey
DetailActCommAmt
DetailCalcCommAmt
DetailCmntOnly
DetailCommBase
DetailCommClassKey
DetailCommClassID
DetailCommPlanKey
DetailCommPlanID
DetailDescription
DetailExtAmt
DetailExtCmnt
DetailInvcKey
DetailItemAliasKey
DetailItemAliasID
DetailItemKey
DetailItemID
DetailKitInvoiceLineKey
DetailProjClientID
DetailProjID
DetailRtrnType
DetailSeqNo
DetailShipLineKey
DetailSOLineKey
DetailSTaxClassKey
DetailTradeDiscAmt
DetailUnitCost
DetailUnitMeasKey
DetailUnitMeasID
DetailUnitPrice
DetailUnitPriceOvrd
DetailSOLineNo
DetailSOUserFld1
DetailSOUserFld2
DetailDistributionInvoiceLineDistKey
DetailDistributionAcctRefKey
DetailDistributionAcctRefNo
DetailDistributionExtAmt
DetailDistributionFOBKey
DetailDistributionFOBID
DetailDistributionFreightAmt
DetailDistributionInvoiceLineKey
DetailDistributionQtyShipped
DetailDistributionSalesAcctKey
DetailDistributionSalesAcctNo
DetailDistributionShipLineDistKey
DetailDistributionShipMethKey
DetailDistributionShipMethID
DetailDistributionShipZoneKey
DetailDistributionShipZoneID
DetailDistributionSOLineDistKey
DetailDistributionSTaxTranKey
DetailDistributionTradeDiscAmt
DetailItemItemKey
DetailItemAllowCostOvrd
DetailItemAllowDecimalQty
DetailItemAllowDropShip
DetailItemAllowPriceOvrd
DetailItemAllowRtrns
DetailItemAvailForSale
DetailItemCommClassKey
DetailItemCommodityCodeKey
DetailItemCompanyID
DetailItemCOSAcctKey
DetailItemCreateDate
DetailItemCreateType
DetailItemCreateUserID
DetailItemCRMItemID
DetailItemDateEstab
DetailItemDfltWhseKey
DetailItemExpAcctKey
DetailItemFASAssetTemplate
DetailItemFreightClassKey
DetailItemImportLogKey
DetailItemInclOnPackList
DetailItemInternalLongDesc
DetailItemIntrnlDeliveryReq
DetailItemItemClassKey
DetailItemItemID
DetailItemItemSubType
DetailItemItemType
DetailItemMatchToleranceKey
DetailItemMatSafetySheetKey
DetailItemMinSaleQty
DetailItemPerUsageOrdLimit
DetailItemPriceSeq
DetailItemPriceUnitMeasKey
DetailItemProdDetlLink
DetailItemProdPriceGroupKey
DetailItemPurchProdLineKey
DetailItemPurchUnitMeasKey
DetailItemRcptReq
DetailItemRcvgCmnt
DetailItemRestockRate
DetailItemReturnsAcctKey
DetailItemRplcmntUnitCost
DetailItemSaleMultiple
DetailItemSalesAcctKey
DetailItemSalesProdLineKey
DetailItemSalesUnitMeasKey
DetailItemSeasonal
DetailItemShelfLife
DetailItemStatus
DetailItemSTaxClassKey
DetailItemStdBinQty
DetailItemStdPrice
DetailItemStdUnitCost
DetailItemStockUnitMeasKey
DetailItemSubjToTradeDisc
DetailItemSuccessorDate
DetailItemSuccessorItemKey
DetailItemTargetMargin
DetailItemTrackMeth
DetailItemUpdateCounter
DetailItemUpdateDate
DetailItemUpdateUserID
DetailItemUserFld1
DetailItemUserFld2
DetailItemUserFld3
DetailItemUserFld4
DetailItemUserFld5
DetailItemUserFld6
DetailItemValuationMeth
DetailItemVendFamilyKey
DetailItemWarrantyDays
DetailItemWarrantyProvider
DetailItemCommClassID
DetailItemCommodityCodeID
DetailItemGLAcctNo
DetailItemWhseID
DetailItemItemClassID
DetailItemFreightClassID
DetailItemPriceUnitMeasID
DetailItemPurchUnitMeasID
DetailItemSalesUnitMeasID
DetailItemStockUnitMeasID
DetailItemSalesProdLineID
DetailItemPurchProdLineID
DetailItemProdPriceGroupID
DetailPackageDeclaredValue
DetailPackageExtShipSystemFreightAmt
DetailPackageFreightClassKey
DetailPackageGrossWeight
DetailPackageHazMat
DetailPackagePackageNo
DetailPackageShipTrackNo
DetailPackageQty
DetailPackageComment
ItemTransStatus
ItemLocalID
ItemLocalDesc
ItemExternalID
ItemExternalDesc
Itembuffer
ItemTranLevel
ItemBridgeFlag
ItemPC
ItemCustomField1
ItemCustomField2
ItemCustomField3
ItemCustomField4
ItemCustomField5
ItemWeight
ItemLength
ItemHeight
ItemWidth
ItemInnerPack
ItemStandPack
DetailUPCUnitMeasID
DetailUPCConversionFacto
DetailUPCUnitVolume
DetailUPCUnitWeight
DetailUPCUPC
DetailUPCUseForPurchases
DetailUPCUseForSales
DetailUPCUseStdConv

Outbound Vendor Payment

Description: Extracts Vendor Payments from the accounting system.

The Outbound Vendor Payment touchpoint includes the following fields:

VendPmtKey
AddrKey
CreateDate
CreateType
CreateUserID
CurrExchRate
CurrExchSchdKey
CurrID
DiscTakenAmt
POKey
PrePaidVendInvcNo
RevVendPmtKey
TranAmt
TranAmtHC
TranCmnt
TranDate
TranNo
TranType
UnappliedAmt
UnappliedAmtHC
UpdateCounter
UpdateDate
UpdateUserID
VendClassKey
VendPmtMethKey
ChkType
RetntAmt
PostDate
VendKey
AllowPOBackOrder
BuyerKey
CashAcctKey
CompanyID
CreateDate
CreateDateTime
CreateType
CreateUserID
CreditLimit
CurrExchSchdKey
DfltItemKey
DfltPurchAcctKey
DfltPurchAddrKey
DfltRemitToAddrKey
HoldPmt
ImportLogKey
MatchToleranceKey
PmtTermsKey
POFormKey
PrimaryAddrKey
PrimaryCntctKey
RcvgCmnt
RequirePOIssue
RequireRMA
RetntRate
SeparateChk
Status
TaxPayerID
UpdateCounter
UpdateDate
UpdateDateTime
UpdateUserID
UserFld1
UserFld2
UserFld3
UserFld4
V1099Control
V1099Box
V1099Form
V1099Type
VendClassKey
VendID
VendName
VendPmtMethKey
VendRefNo
VouchCmnt
VouchNo
TranAmt
DiscAmt
TranCmnt