eBridge for Sage PFW Overview

Description: Creates a Sales Order in the accounting system.

The Inbound Sales Order touchpoint includes the following fields:

HeaderCustomerKey
HeaderOrderNumber
HeaderOrderStatus
HeaderHoldOrder
HeaderHoldReason
HeaderTermsKey
HeaderOrderDate
HeaderReqDeliveryDate
HeaderCancelDate
HeaderSalespersonKey
HeaderCommOverridePct
HeaderCommOverrideAmt
HeaderBuyer
HeaderCustomerPoNo
HeaderNonTaxableFreightAmt
HeaderRecurCycleKey
HeaderCreateBackOrder
HeaderFOBKey
HeaderCommentKey
HeaderCustClassKey
HeaderLocationKey
HeaderShipViaKey
HeaderTerritoryKey
HeaderTrackingNumber
HeaderReceiptNumber
HeaderReceiptDate
HeaderReceiptAmt
HeaderCCType
HeaderCCNumber
HeaderCCExpirationDate
HeaderCCCardholderName
HeaderCCAuthCode
HeaderCCPhone
HeaderNotes
HeaderSchedShipDate
ShipToType
ShipToCode
ShipToName
ShipToLine1
ShipToLine2
ShipToLine3
ShipToCity
ShipToState
ShipToZipCode
ShipToCountry
ShipToAttention
BillToType
BillToCode
BillToName
BillToLine1
BillToLine2
BillToLine3
BillToCity
BillToState
BillToZipCode
BillToCountry
BillToAttention
DetailLineType
DetailItemKey
DetailDescription
DetailLocationKey
DetailQtyOrdered
DetailUnitPrice
DetailQtyRemaining
DetailDiscountPct
DetailTaxKey
DetailRevenueAcct
DetailRequestDate
DetailShipDate
DetailTrackingNumber
DetailLotNo
DetailUnitCost
DetailNotes

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

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

Description: Extracts a Customer Record from the accounting system.

The Outbound Customer touchpoint includes the following fields:

CustomerCustomerkey
CustomerCustomername
CustomerCustomeraddress1
CustomerCustomeraddress2
CustomerCustomeraddress3
CustomerCustomercity
CustomerCustomerstate
CustomerCustomerzipcode
CustomerCustomercountry
CustomerCustomerattention
CustomerAttnphone
CustomerContactname
CustomerContactphone
CustomerResalenumber
CustomerTelexnumber
CustomerFaxnumber
CustomerCreditcardnumber
CustomerCreditcardtype
CustomerExpirationdate
CustomerWebcustomer
CustomerVendorkey
CustomerCreditlimitamt
CustomerCredithold
CustomerPaymentmthd
CustomerPrintstatement
CustomerAssessfinancecharge
CustomerTaxkey
CustomerTermskey
CustomerFobkey
CustomerShipviakey
CustomerCustomerclasskey
CustomerLocationkey
CustomerShiptokey
CustomerTerritorykey
CustomerSalespersonkey
CustomerInvoicecommentkey
CustomerStatementcommentkey
CustomerTaxcountry
CustomerTaxid
CustomerRsrv1
CustomerPrinttaxid
CustomerRsrv2
CustomerUninvoicedcredit
CustomerPrimarypricemthd
CustomerSecondarypricemthd
CustomerEmailaddress
CustomerWebpageurl
CustomerNameoncreditcard
CustomerCvv2number
CustomerCustomerSince
CustomerStatusFlag
CustomerCreditRiskFlag
CustomerCreditRating1
CustomerCreditRating2
CustomerCreditRating3
CustomerCollectorKey
CustomerContact1Key
CustomerContact1TypeKey
CustomerContact2Key
CustomerContact2TypeKey
CustomerContact3Key
CustomerContact3TypeKey
CustomerContact4Key
CustomerContact4TypeKey
CustomerContact5Key
CustomerContact5TypeKey
CustomerTimeZone
CustomerDnBNumber
CustomerSICNAIC
CustomerSpare
CustomerRecuserid
CustomerRecdate
CustomerRectime
CustomerCustomerDescription
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
ShipToCustomerkey
ShipToShiptokey
ShipToShiptoname
ShipToShiptoaddress1
ShipToShiptoaddress2
ShipToShiptoaddress3
ShipToShiptocity
ShipToShiptostate
ShipToShiptozipcode
ShipToShiptocountry
ShipToShiptoattention
ShipToAttnphone
ShipToContactname
ShipToContactphone
ShipToTaxkey
ShipToTermskey
ShipToFobkey
ShipToShipviakey
ShipToCustomerclasskey
ShipToLocationkey
ShipToTerritorykey
ShipToSalespersonkey
ShipToInvoicecommentkey
ShipToTaxcountry
ShipToTaxid
ShipToRsrv1
ShipToPrinttaxid
ShipToRsrv2
ShipToSpare
ShipToRecuserid
ShipToRecdate
ShipToRectime
ShipAddressTranslationTranslationStatus
ShipAddressTranslationShipID
ShipAddressTranslationShipName
ShipAddressTranslationExternalID
ShipAddressTranslationExternalDesc
ShipAddressTranslationBuffer
ShipAddressTranslationLevel
ShipAddressTranslationEDIFlag
ShipAddressTranslationCustomField1
ShipAddressTranslationCustomField2
ShipAddressTranslationCustomField3
ShipAddressTranslationCustomField4
ShipAddressTranslationCustomField5

Description: Extracts an Inventory Record from the accounting system.

The Outbound Inventory touchpoint includes the following fields:

ItemItemkey
ItemItemdescription1
ItemItemdescription2
ItemRsrv1
ItemPurchaseconvertfactr
ItemWeight
ItemPhysicalcountdays
ItemTrackseriallot
ItemItemtype
ItemItemsubtype
ItemCostmthd
ItemOversoldcostmthd
ItemAbckey
ItemManufacturer
ItemAlternateitemkey
ItemProductkey
ItemCommoditykey
ItemEccncode
ItemItemlength
ItemItemwidth
ItemItemheight
ItemLinearuom
ItemInctrlcode
ItemPlannercode
ItemOrderpolicycode
ItemOrderpointqty
ItemMinimumorderqty
ItemMaximumorderqty
ItemRoundingfactor
ItemSafetystockcode
ItemSafetystockqty
ItemStockuom
ItemYieldfactor
ItemForecasttmfence
ItemPlanningtmfence
ItemPegindicator
ItemBackflush
ItemLevelcode
ItemLeadtime
ItemMrptrigger
ItemRsrvmfg
ItemOperatingcurrencykey
ItemAltstockuom
ItemManufacturerpartnum
ItemRsrvstubunprc
ItemRsrvstubuncst
ItemPorequiresseriallot
ItemSorequiresseriallot
ItemSoallownewseriallot
ItemSeriallotmask
ItemLotsize
ItemDaystoexpire
ItemMisc1header
ItemMisc2header
ItemMisc3header
ItemMisc4header
ItemMisc5header
ItemWebitem
ItemItmqtyrndnodec
ItemItmqtymask
ItemItmcostrndnodec
ItemItmcostmask
ItemSellinguomkey
ItemUpccode
ItemRetired
ItemSpare
ItemRecuserid
ItemRecdate
ItemRectime
ItemItemdescription3
ItemEC
ItemTranslationTranslationStatus
ItemTranslationItemID
ItemTranslationItemDesc
ItemTranslationExternalID
ItemTranslationExternalDesc
ItemTranslationBuffer
ItemTranslationLevel
ItemTranslationEDIFlag
ItemTranslationUPCCode
ItemTranslationCustomField1
ItemTranslationCustomField2
ItemTranslationCustomField3
ItemTranslationCustomField4
ItemTranslationCustomField5
ItemTranslationWeight
ItemTranslationHeight
ItemTranslationLength
ItemTranslationWidth
ItemTranslationInnerPack
ItemTranslationStandPack
LocationItemkey
LocationLocationkey
LocationItemclasskey
LocationStatus
LocationDatemodified
LocationPhyscountstatus
LocationPhyscountstartdate
LocationPhyscountcmpletedate
LocationMarketcost
LocationReordercost
LocationCarryingcost
LocationStandardcost
LocationAvgcost
LocationLastcost
LocationDistributedcost
LocationBaseprice
LocationQtyonhand
LocationQtyoversold
LocationQtyonorder
LocationQtytransitin
LocationQtytransitout
LocationQtycommitsales
LocationQtycommitproduction
LocationQtypoindirect
LocationQtyoeindirect
LocationReorderqtydate
LocationMaxorderqtydate
LocationRsrv5
LocationMfgstatus
LocationBinnumber
LocationWeightperunit
LocationWeightdescription
LocationRevenueacct
LocationCogsacct
LocationMfgstatusdate
LocationBasepricedate
LocationMarketcostdate
LocationReordercostdate
LocationCarrycostdate
LocationStandardcostdate
LocationMinstockqtydate
LocationMaxstockqtydate
LocationBasepriceopercurrncy
LocationBasepriceitemcurrncy
LocationLastcostopercurrency
LocationLastcostitemcurrency
LocationAvgcostopercurrency
LocationAvgcostitemcurrency
LocationCommissionkey
LocationSalestaxkey
LocationRsrva
LocationMinimumstockqty
LocationMaximumstockqty
LocationReorderqty
LocationMaximumorderqty
LocationRsrv6
LocationPrimaryvendorkey
LocationPurchasestaxkey
LocationCogsadjustmentacct
LocationWestechsubgroup
LocationOrderqtymultipledate
LocationCreatemultiplejobs
LocationOrderqtymultiple
LocationQtycommitted
LocationSpare
LocationRecuserid
LocationRecdate
LocationRectime
LocationLODLocationkey
LocationLocationdescription
LocationLocationshortdescrip
LocationRecuserid
LocationRecdate
LocationRecspare
LocationRectime
LocationSpare

Description: Extracts a Posted Invoice from the accounting system.

The Outbound Posted Invoice touchpoint includes the following fields:

HeaderCustomerkey
HeaderCustomername
HeaderCustomeraddress1
HeaderCustomeraddress2
HeaderCustomeraddress3
HeaderCustomercity
HeaderCustomerstate
HeaderCustomerzipcode
HeaderCustomercountry
HeaderCustomerattention
HeaderShiptokey
HeaderShiptoname
HeaderShiptoaddress1
HeaderShiptoaddress2
HeaderShiptoaddress3
HeaderShiptocity
HeaderShiptostate
HeaderShiptozipcode
HeaderShiptocountry
HeaderShiptoattention
HeaderTransactionnumber
HeaderApplyto
HeaderStatus
HeaderInvoicedate
HeaderAgedate
HeaderRequestdate
HeaderShipdate
HeaderRecurkey
HeaderBuyer
HeaderCustomerponumber
HeaderChecknumber
HeaderCheckamt
HeaderCommissionoverride
HeaderLocationkey
HeaderTerritorykey
HeaderSalespersonkey
HeaderTermskey
HeaderFobkey
HeaderShipviakey
HeaderCommentkey
HeaderCustomerclasskey
HeaderEditreportstatus
HeaderTaxontotal
HeaderFreightamt
HeaderRsrv
HeaderCreditmemo
HeaderInvoicenumber
HeaderRsrvfrmoe
HeaderRsrvoecst
HeaderRsrvpymth
HeaderSysdocid
HeaderApplysysdocid
HeaderOedocid
HeaderRsrvediflg
HeaderTransactiontype
HeaderOnaccount
HeaderDocumenttotal
HeaderLastlinsq
HeaderCreditcardtype
HeaderCreditcardnumber
HeaderExpirationdate
HeaderCreditauthorization
HeaderCreditcardphonenum
HeaderNameoncreditcard
HeaderReference
HeaderDeposit
HeaderPaybalance
HeaderPreauthorizationamt
HeaderDepositamt
HeaderDepositauthorization
HeaderPaymentbalanceamt
HeaderAuthorizationdate
HeaderAuthorizationtime
HeaderCvv2number
HeaderPreauthgotranid
HeaderDepositgotranid
HeaderCreatedbyshipmentpst
HeaderShipmentno
HeaderReprintCount
HeaderBackOrderCount
HeaderPrintInHome
HeaderPrintLocation
HeaderPrintRequestDate
HeaderPrintShipDate
HeaderPrintTaxRateKey
HeaderPrintDiscDetail
HeaderSpare
HeaderRecuserid
HeaderRecdate
HeaderRectime
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
ShipAddressTranslationTranslationStatus
ShipAddressTranslationShipID
ShipAddressTranslationShipName
ShipAddressTranslationExternalID
ShipAddressTranslationExternalDesc
ShipAddressTranslationBuffer
ShipAddressTranslationLevel
ShipAddressTranslationEDIFlag
ShipAddressTranslationCustomField1
ShipAddressTranslationCustomField2
ShipAddressTranslationCustomField3
ShipAddressTranslationCustomField4
ShipAddressTranslationCustomField5
CustomerCustomerkey
CustomerCustomername
CustomerCustomeraddress1
CustomerCustomeraddress2
CustomerCustomeraddress3
CustomerCustomercity
CustomerCustomerstate
CustomerCustomerzipcode
CustomerCustomercountry
CustomerCustomerattention
CustomerAttnphone
CustomerContactname
CustomerContactphone
CustomerResalenumber
CustomerTelexnumber
CustomerFaxnumber
CustomerCreditcardnumber
CustomerCreditcardtype
CustomerExpirationdate
CustomerWebcustomer
CustomerVendorkey
CustomerCreditlimitamt
CustomerCredithold
CustomerPaymentmthd
CustomerPrintstatement
CustomerAssessfinancecharge
CustomerTaxkey
CustomerTermskey
CustomerFobkey
CustomerShipviakey
CustomerCustomerclasskey
CustomerLocationkey
CustomerShiptokey
CustomerTerritorykey
CustomerSalespersonkey
CustomerInvoicecommentkey
CustomerStatementcommentkey
CustomerTaxcountry
CustomerTaxid
CustomerRsrv1
CustomerPrinttaxid
CustomerRsrv2
CustomerUninvoicedcredit
CustomerPrimarypricemthd
CustomerSecondarypricemthd
CustomerEmailaddress
CustomerWebpageurl
CustomerNameoncreditcard
CustomerCvv2number
CustomerCustomerSince
CustomerStatusFlag
CustomerCreditRiskFlag
CustomerCreditRating1
CustomerCreditRating2
CustomerCreditRating3
CustomerCollectorKey
CustomerContact1Key
CustomerContact1TypeKey
CustomerContact2Key
CustomerContact2TypeKey
CustomerContact3Key
CustomerContact3TypeKey
CustomerContact4Key
CustomerContact4TypeKey
CustomerContact5Key
CustomerContact5TypeKey
CustomerTimeZone
CustomerDnBNumber
CustomerSICNAIC
CustomerSpare
CustomerRecuserid
CustomerRecdate
CustomerRectime
CustomerCustomerDescription
DetailDocumentnumber
DetailLocationkey
DetailCustomerkey
DetailItemkey
DetailItemdescription
DetailUnitprice
DetailQtyordered
DetailQtyshipped
DetailTaxkey
DetailRevenueacctkey
DetailCostamt
DetailCustomerclasskey
DetailRequestdate
DetailShipdate
DetailDocumentdate
DetailDiscountpercent
DetailActualtaxlevel1amt
DetailActualtaxlevel2amt
DetailActualtaxlevel3amt
DetailActualtaxlevel4amt
DetailOrderinfo
DetailBolinfo
DetailSysdocid
DetailSyslinsq
DetailOrigsysid
DetailOrigdocid
DetailOriglinsq
DetailRefsysid
DetailRefdocid
DetailReflinsq
DetailReftype
DetailShipdocid
DetailRsrvnc
DetailLineitemtype
DetailTransactiontype
DetailReference
DetailBolnum
DetailCrefitemnum
DetailInvpostbyship
DetailCustpono
DetailSellinguom
DetailSellqtyordered
DetailShipquantity
DetailSellunitprice
DetailSelluommultiplie
DetailSelluomkey
DetailRownumber
DetailPriceIncludesTax
DetailQtyRemaining
DetailUOMQtyOrdered
DetailUOMQtyShipped
DetailUOMQtyRemaining
DetailUOMUnitPrice
DetailQtyUOM
DetailPriceUOM
DetailQtyCnvFctr
DetailSpare
DetailRecuserid
DetailRecdate
DetailRectime
DetailTranslationTranslationStatus
DetailTranslationItemID
DetailTranslationItemDesc
DetailTranslationExternalID
DetailTranslationExternalDesc
DetailTranslationBuffer
DetailTranslationLevel
DetailTranslationEDIFlag
DetailTranslationUPCCode
DetailTranslationCustomField1
DetailTranslationCustomField2
DetailTranslationCustomField3
DetailTranslationCustomField4
DetailTranslationCustomField5
DetailTranslationWeight
DetailTranslationHeight
DetailTranslationLength
DetailTranslationWidth
DetailTranslationInnerPack
DetailTranslationStandPack

Description: Extracts a Sales Order from the accounting system.

The Outbound Sales Order touchpoint includes the following fields:

HeaderCustomerkey
HeaderCustomername
HeaderCustomeraddress1
HeaderCustomeraddress2
HeaderCustomeraddress3
HeaderCustomercity
HeaderCustomerstate
HeaderCustomerzipcode
HeaderCustomercountry
HeaderCustomerattention
HeaderShiptokey
HeaderShiptoname
HeaderShiptoaddress1
HeaderShiptoaddress2
HeaderShiptoaddress3
HeaderShiptocity
HeaderShiptostate
HeaderShiptozipcode
HeaderShiptocountry
HeaderShiptoattention
HeaderOrdernumber
HeaderPoststatus
HeaderOrderstatus
HeaderOrderdate
HeaderRequestdate
HeaderCanceldate
HeaderBackordercount
HeaderRecurkey
HeaderBuyer
HeaderCustomerponumber
HeaderChecknumber
HeaderCheckamt
HeaderCommissionoverride
HeaderLocationkey
HeaderTerritorykey
HeaderSalespersonkey
HeaderTermskey
HeaderFobkey
HeaderShipviakey
HeaderCommentkey
HeaderCustomerclasskey
HeaderFreightamt
HeaderDiscountmultiplier
HeaderShipdate
HeaderEditreportstatus
HeaderInvoicenumber
HeaderInvoicedate
HeaderAgedate
HeaderSelectchecknumber
HeaderSelectcheckamt
HeaderLabelcount
HeaderAllowbackorder
HeaderTaxontotal
HeaderRma
HeaderRsrvdropship
HeaderSysdocid
HeaderEdiflag
HeaderWorkorderpost
HeaderLastlinsq
HeaderCreditcardtype
HeaderCreditcardnumber
HeaderExpirationdate
HeaderCreditauthorization
HeaderCreditcardphonenum
HeaderNameoncreditcard
HeaderPaymentreceiptdate
HeaderUsecreditcard
HeaderReference
HeaderDeposit
HeaderPaybalance
HeaderPreauthorizationamt
HeaderDepositamt
HeaderDepositauthorization
HeaderPaymentbalanceamt
HeaderAuthorizationdate
HeaderAuthorizationtime
HeaderCvv2number
HeaderPreauthgotranid
HeaderDepositgotranid
HeaderCcdepositbooked
HeaderHoldFlag
HeaderHoldReason
HeaderPrintInHome
HeaderPrintLocation
HeaderPrintRequestDate
HeaderPrintShipDate
HeaderPrintTaxRateKey
HeaderSpare
HeaderRecuserid
HeaderRecdate
HeaderRectime
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
ShipAddressTranslationTranslationStatus
ShipAddressTranslationShipID
ShipAddressTranslationShipName
ShipAddressTranslationExternalID
ShipAddressTranslationExternalDesc
ShipAddressTranslationBuffer
ShipAddressTranslationLevel
ShipAddressTranslationEDIFlag
ShipAddressTranslationCustomField1
ShipAddressTranslationCustomField2
ShipAddressTranslationCustomField3
ShipAddressTranslationCustomField4
ShipAddressTranslationCustomField5
CustomerCustomerkey
CustomerCustomername
CustomerCustomeraddress1
CustomerCustomeraddress2
CustomerCustomeraddress3
CustomerCustomercity
CustomerCustomerstate
CustomerCustomerzipcode
CustomerCustomercountry
CustomerCustomerattention
CustomerAttnphone
CustomerContactname
CustomerContactphone
CustomerResalenumber
CustomerTelexnumber
CustomerFaxnumber
CustomerCreditcardnumber
CustomerCreditcardtype
CustomerExpirationdate
CustomerWebcustomer
CustomerVendorkey
CustomerCreditlimitamt
CustomerCredithold
CustomerPaymentmthd
CustomerPrintstatement
CustomerAssessfinancecharge
CustomerTaxkey
CustomerTermskey
CustomerFobkey
CustomerShipviakey
CustomerCustomerclasskey
CustomerLocationkey
CustomerShiptokey
CustomerTerritorykey
CustomerSalespersonkey
CustomerInvoicecommentkey
CustomerStatementcommentkey
CustomerTaxcountry
CustomerTaxid
CustomerRsrv1
CustomerPrinttaxid
CustomerRsrv2
CustomerUninvoicedcredit
CustomerPrimarypricemthd
CustomerSecondarypricemthd
CustomerEmailaddress
CustomerWebpageurl
CustomerNameoncreditcard
CustomerCvv2number
CustomerCustomerSince
CustomerStatusFlag
CustomerCreditRiskFlag
CustomerCreditRating1
CustomerCreditRating2
CustomerCreditRating3
CustomerCollectorKey
CustomerContact1Key
CustomerContact1TypeKey
CustomerContact2Key
CustomerContact2TypeKey
CustomerContact3Key
CustomerContact3TypeKey
CustomerContact4Key
CustomerContact4TypeKey
CustomerContact5Key
CustomerContact5TypeKey
CustomerTimeZone
CustomerDnBNumber
CustomerSICNAIC
CustomerSpare
CustomerRecuserid
CustomerRecdate
CustomerRectime
CustomerCustomerDescription
DetailOrdernumber
DetailItemkey
DetailItemdescription
DetailLocationkey
DetailUnitprice
DetailQtyordered
DetailQtyremaining
DetailDiscountpercent
DetailTaxkey
DetailRevenueacctkey
DetailQtyshipped
DetailSeriallotitem
DetailRequestdate
DetailShipdate
DetailUnitcost
DetailDocumentdate
DetailClasskey
DetailMetatronfield
DetailEdilinenumber
DetailSysdocid
DetailSyslinsq
DetailOrigsysid
DetailOrigdocid
DetailOriglinsq
DetailRsrvnc
DetailLineitemtype
DetailRownumber
DetailReference
DetailOrigUnitPrice
DetailSpare
DetailRecuserid
DetailRecdate
DetailRectime
DetailTranslationTranslationStatus
DetailTranslationItemID
DetailTranslationItemDesc
DetailTranslationExternalID
DetailTranslationExternalDesc
DetailTranslationBuffer
DetailTranslationLevel
DetailTranslationEDIFlag
DetailTranslationUPCCode
DetailTranslationCustomField1
DetailTranslationCustomField2
DetailTranslationCustomField3
DetailTranslationCustomField4
DetailTranslationCustomField5
DetailTranslationWeight
DetailTranslationHeight
DetailTranslationLength
DetailTranslationWidth
DetailTranslationInnerPack
DetailTranslationStandPack

Description: Extracts an Unposted Invoice from the accounting system.

The Outbound Unposted Invoice touchpoint includes the following fields:

HeaderCustomerkey
HeaderCustomername
HeaderCustomeraddress1
HeaderCustomeraddress2
HeaderCustomeraddress3
HeaderCustomercity
HeaderCustomerstate
HeaderCustomerzipcode
HeaderCustomercountry
HeaderCustomerattention
HeaderShiptokey
HeaderShiptoname
HeaderShiptoaddress1
HeaderShiptoaddress2
HeaderShiptoaddress3
HeaderShiptocity
HeaderShiptostate
HeaderShiptozipcode
HeaderShiptocountry
HeaderShiptoattention
HeaderTransactionnumber
HeaderApplyto
HeaderStatus
HeaderInvoicedate
HeaderAgedate
HeaderRequestdate
HeaderShipdate
HeaderRecurkey
HeaderBuyer
HeaderCustomerponumber
HeaderChecknumber
HeaderCheckamt
HeaderCommissionoverride
HeaderLocationkey
HeaderTerritorykey
HeaderSalespersonkey
HeaderTermskey
HeaderFobkey
HeaderShipviakey
HeaderCommentkey
HeaderCustomerclasskey
HeaderEditreportstatus
HeaderTaxontotal
HeaderFreightamt
HeaderRsrv
HeaderCreditmemo
HeaderInvoicenumber
HeaderRsrvfrmoe
HeaderRsrvoecst
HeaderRsrvpymth
HeaderSysdocid
HeaderApplysysdocid
HeaderOedocid
HeaderRsrvediflg
HeaderTransactiontype
HeaderOnaccount
HeaderDocumenttotal
HeaderLastlinsq
HeaderCreditcardtype
HeaderCreditcardnumber
HeaderExpirationdate
HeaderCreditauthorization
HeaderCreditcardphonenum
HeaderNameoncreditcard
HeaderReference
HeaderDeposit
HeaderPaybalance
HeaderPreauthorizationamt
HeaderDepositamt
HeaderDepositauthorization
HeaderPaymentbalanceamt
HeaderAuthorizationdate
HeaderAuthorizationtime
HeaderCvv2number
HeaderPreauthgotranid
HeaderDepositgotranid
HeaderCreatedbyshipmentpst
HeaderShipmentno
HeaderReprintCount
HeaderBackOrderCount
HeaderPrintInHome
HeaderPrintLocation
HeaderPrintRequestDate
HeaderPrintShipDate
HeaderPrintTaxRateKey
HeaderPrintDiscDetail
HeaderSpare
HeaderRecuserid
HeaderRecdate
HeaderRectime
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
ShipAddressTranslationTranslationStatus
ShipAddressTranslationShipID
ShipAddressTranslationShipName
ShipAddressTranslationExternalID
ShipAddressTranslationExternalDesc
ShipAddressTranslationBuffer
ShipAddressTranslationLevel
ShipAddressTranslationEDIFlag
ShipAddressTranslationCustomField1
ShipAddressTranslationCustomField2
ShipAddressTranslationCustomField3
ShipAddressTranslationCustomField4
ShipAddressTranslationCustomField5
CustomerCustomerkey
CustomerCustomername
CustomerCustomeraddress1
CustomerCustomeraddress2
CustomerCustomeraddress3
CustomerCustomercity
CustomerCustomerstate
CustomerCustomerzipcode
CustomerCustomercountry
CustomerCustomerattention
CustomerAttnphone
CustomerContactname
CustomerContactphone
CustomerResalenumber
CustomerTelexnumber
CustomerFaxnumber
CustomerCreditcardnumber
CustomerCreditcardtype
CustomerExpirationdate
CustomerWebcustomer
CustomerVendorkey
CustomerCreditlimitamt
CustomerCredithold
CustomerPaymentmthd
CustomerPrintstatement
CustomerAssessfinancecharge
CustomerTaxkey
CustomerTermskey
CustomerFobkey
CustomerShipviakey
CustomerCustomerclasskey
CustomerLocationkey
CustomerShiptokey
CustomerTerritorykey
CustomerSalespersonkey
CustomerInvoicecommentkey
CustomerStatementcommentkey
CustomerTaxcountry
CustomerTaxid
CustomerRsrv1
CustomerPrinttaxid
CustomerRsrv2
CustomerUninvoicedcredit
CustomerPrimarypricemthd
CustomerSecondarypricemthd
CustomerEmailaddress
CustomerWebpageurl
CustomerNameoncreditcard
CustomerCvv2number
CustomerCustomerSince
CustomerStatusFlag
CustomerCreditRiskFlag
CustomerCreditRating1
CustomerCreditRating2
CustomerCreditRating3
CustomerCollectorKey
CustomerContact1Key
CustomerContact1TypeKey
CustomerContact2Key
CustomerContact2TypeKey
CustomerContact3Key
CustomerContact3TypeKey
CustomerContact4Key
CustomerContact4TypeKey
CustomerContact5Key
CustomerContact5TypeKey
CustomerTimeZone
CustomerDnBNumber
CustomerSICNAIC
CustomerSpare
CustomerRecuserid
CustomerRecdate
CustomerRectime
CustomerCustomerDescription
DetailTransactionnumber
DetailItemkey
DetailItemdescription
DetailLocationkey
DetailUnitprice
DetailQtyordered
DetailQtyshipped
DetailDiscountpercent
DetailTaxkey
DetailRevenueacctkey
DetailSeriallotflag
DetailRequestdate
DetailShipdate
DetailCostamt
DetailDocumentdate
DetailCustomerclasskey
DetailOrdernumber
DetailBollanumber
DetailSectionnumber
DetailEdilinenumber
DetailSysdocid
DetailSyslinsq
DetailOrigsysid
DetailOrigdocid
DetailOriglinsq
DetailRefsysid
DetailRefdocid
DetailReflinsq
DetailReftype
DetailShipdocid
DetailRsrvnc
DetailLineitemtype
DetailTransactiontype
DetailRownumber
DetailReference
DetailSpare
DetailRecuserid
DetailRecdate
DetailRectime
DetailTranslationTranslationStatus
DetailTranslationItemID
DetailTranslationItemDesc
DetailTranslationExternalID
DetailTranslationExternalDesc
DetailTranslationBuffer
DetailTranslationLevel
DetailTranslationEDIFlag
DetailTranslationUPCCode
DetailTranslationCustomField1
DetailTranslationCustomField2
DetailTranslationCustomField3
DetailTranslationCustomField4
DetailTranslationCustomField5
DetailTranslationWeight
DetailTranslationHeight
DetailTranslationLength
DetailTranslationWidth
DetailTranslationInnerPack
DetailTranslationStandPack