MercuryGate Code Tables

Install / Update the following code tables in MercuryGate to enable the Navix integration

Insert these Code Tables, updating the Enterprise Name to the client’s Admin level, and updating any necessary directories.

NOTE: You'll need to open a Salesforce Case to have MercuryGate create/update any Extract or Import code tables.

Exports- These send Loads out to Navix to create Navix Orders

 

[Insert Enterprise Name]|EM:XMLShippingOrderNavix|ARCHIVEDIRECTORY|{INSERT CORRECT DIRECTORY}

[Insert Enterprise Name]|EM:XMLShippingOrderNavix|BATCHSIZE|1

[Insert Enterprise Name]|EM:XMLShippingOrderNavix|DESTDIRECTORY|{INSERT CORRECT DIRECTORY}

[Insert Enterprise Name]|EM:XMLShippingOrderNavixDESTDIRECTORY-TestMode|{INSERT CORRECT DIRECTORY}

[Insert Enterprise Name]|EM:XMLShippingOrderNavix|DESTEMAIL|{Insert your email if you want to receive these docs}

[Insert Enterprise Name]|EM:XMLShippingOrderNavix|DESTFILEEXTENSION|.xml

[Insert Enterprise Name]|EM:XMLShippingOrderNavix|DESTFILEPREFIX|ShippingOrder-CustomerName-Navix-

[Insert Enterprise Name]|EM:XMLShippingOrderNavix|INSTANTIATION|CustomerLoadBasic,CustomerLoadItems,CustomerLoadRates,ShipmentBasic,ShipmentItems

[Insert Enterprise Name]|EM:XMLShippingOrderNavix|JAVACONVERTERCLASS|com.mg.converters.XMLExtractor

[Insert Enterprise Name]|EM:XMLShippingOrderNavix|Version|3.34

 

[Insert Enterprise Name]|EM:XMLTransportNavix|ARCHIVEDIRECTORY|{INSERT CORRECT DIRECTORY}

[Insert Enterprise Name]|EM:XMLTransportNavix|BATCHSIZE|1

[Insert Enterprise Name]|EM:XMLTransportNavix|DESTDIRECTORY|{INSERT CORRECT DIRECTORY}

[Insert Enterprise Name]|EM:XMLTransportNavixDESTDIRECTORY-TestMode|{INSERT CORRECT DIRECTORY}

[Insert Enterprise Name]|EM:XMLTransportNavix|DESTEMAIL|kyle.wegman@navix.io

[Insert Enterprise Name]|EM:XMLTransportNavix|DESTFILEEXTENSION|.xml

[Insert Enterprise Name]|EM:XMLTransportNavix|DESTFILEPREFIX|Transport-CustomerName-Navix-

[Insert Enterprise Name]|EM:XMLTransportNavix|INSTANTIATION|TransportBasic,TransportItems,TransportRates,ShipmentBasic,ShipmentItems

[Insert Enterprise Name]|EM:XMLTransportNavix|JAVACONVERTERCLASS|com.mg.converters.XMLExtractor

[Insert Enterprise Name]|EM:XMLTransportNavix|Version|3.35

 

[Insert Enterprise Name]|RemoteServiceConfig|debug|true

 

[Insert Enterprise Name]|TransportExtractTypes|XMLTransportNavix|Transport XML (Navix)

 

[Insert Enterprise Name]|WE:XMLShippingOrderNavix|Extract|EM:XMLShippingOrderNavix

[Insert Enterprise Name]|WE:XMLShippingOrderNavix|HTTPPostHeaderValsTableName|WSPostHeaderVals

[Insert Enterprise Name]|WE:XMLShippingOrderNavix|Password|0c6yihv1V0Zc

[Insert Enterprise Name]|WE:XMLShippingOrderNavix|Production|true

[Insert Enterprise Name]|WE:XMLShippingOrderNavix|ProductionServer|https://navix.ngrok.dev/mgxmlloads

[Insert Enterprise Name]|WE:XMLShippingOrderNavix|RequestIdSequenceName|Web Service Tracking Number

[Insert Enterprise Name]|WE:XMLShippingOrderNavix|TestServer|https://navix.ngrok.dev/mgxmlloads

[Insert Enterprise Name]|WE:XMLShippingOrderNavix|User|NAVIXLOADID

 

[Insert Enterprise Name]|WE:XMLTransportNavix|Extract|EM:XMLTransportNavix

[Insert Enterprise Name]|WE:XMLTransportNavix|HTTPPostHeaderValsTableName|WSPostHeaderVals

[Insert Enterprise Name]|WE:XMLTransportNavix|Password|0c6yihv1V0Zc

[Insert Enterprise Name]|WE:XMLTransportNavix|Production|true

[Insert Enterprise Name]|WE:XMLTransportNavix|ProductionServer|https://navix.ngrok.dev/mgxmlloads

[Insert Enterprise Name]|WE:XMLTransportNavix|RequestIdSequenceName|Web Service Tracking Number

[Insert Enterprise Name]|WE:XMLTransportNavix|TestServer|https://navix.ngrok.dev/mgxmlloads

[Insert Enterprise Name]|WE:XMLTransportNavix|User|NAVIXLOADID

 

Imports- These enable Navix to send “Audit and Docs Out” to create Document Links and Invoices back in MercuryGate

 

 

[Insert Enterprise Name]|IM:DocumentLinkLoader|UserId|NAVIXLOADID

[Insert Enterprise Name]|IM:DocumentLinkLoader|UseDefaultCompany|true

[Insert Enterprise Name]|IM:DocumentLinkLoader|ResponseExtractCodeTableName|ImportDocumentResponse

[Insert Enterprise Name]|IM:DocumentLinkLoader|Response|com.mg.importers.GenericImportResponder

[Insert Enterprise Name]|IM:DocumentLinkLoader|RelativeLogFile|Log-Import-Document-Navix.csv

[Insert Enterprise Name]|IM:DocumentLinkLoader|RelativeCompleteDir|Document

[Insert Enterprise Name]|IM:DocumentLinkLoader|Parser|com.mg.importers.XMLDocumentParser

[Insert Enterprise Name]|IM:DocumentLinkLoader|Loader|com.mg.importers.DocumentLoader

[Insert Enterprise Name]|IM:DocumentLinkLoader|FindCompanyRefNum|true

[Insert Enterprise Name]|IM:DocumentLinkLoader|FileNameRegEx|NAVIX-DOC.*

[Insert Enterprise Name]|IM:DocumentLinkLoader|BaseImportDirectory-TestMode|\\awsfsqa\CustomerData\demo

[Insert Enterprise Name]|IM:DocumentLinkLoader|BaseImportDirectory|\\awsfsprod\CustomerData\demo

[Insert Enterprise Name]|IM:DocumentLinkLoader|UserId|NAVIXLOADID

[Insert Enterprise Name]|IM:DocumentLinkLoader|UseDefaultCompany|true

[Insert Enterprise Name]|IM:DocumentLinkLoader|ResponseExtractCodeTableName|ImportDocumentResponse

[Insert Enterprise Name]|IM:DocumentLinkLoader|Response|com.mg.importers.GenericImportResponder

[Insert Enterprise Name]|IM:DocumentLinkLoader|RelativeLogFile|Log-Import-Document-Navix.csv

[Insert Enterprise Name]|IM:DocumentLinkLoader|RelativeCompleteDir|Document

[Insert Enterprise Name]|IM:DocumentLinkLoader|Parser|com.mg.importers.XMLDocumentParser

[Insert Enterprise Name]|IM:DocumentLinkLoader|Loader|com.mg.importers.DocumentLoader

[Insert Enterprise Name]|IM:DocumentLinkLoader|FindCompanyRefNum|true

[Insert Enterprise Name]|IM:DocumentLinkLoader|FileNameRegEx|NAVIX-DOC.*

[Insert Enterprise Name]|IM:DocumentLinkLoader|BaseImportDirectory-TestMode|{INSERT CORRECT DIRECTORY}

[Insert Enterprise Name]|IM:DocumentLinkLoader|BaseImportDirectory|{INSERT CORRECT DIRECTORY}

 

 

[Insert Enterprise Name]|WI:WebInXMLCarrierInvoice|updateInvoiceStep|REPLACE

[Insert Enterprise Name]|WI:WebInXMLCarrierInvoice|updateInvoiceStatus|REPLACE

[Insert Enterprise Name]|WI:WebInXMLCarrierInvoice|updateInvoiceSettleChargeReason|REPLACE

[Insert Enterprise Name]|WI:WebInXMLCarrierInvoice|updateInvoiceSettleCharge|REPLACE

[Insert Enterprise Name]|WI:WebInXMLCarrierInvoice|updateInvoiceInvoiceNumber|REPLACE

[Insert Enterprise Name]|WI:WebInXMLCarrierInvoice|updateInvoiceInvoiceDate|REPLACE

[Insert Enterprise Name]|WI:WebInXMLCarrierInvoice|updateInvoiceCompleteDate|REPLACE

[Insert Enterprise Name]|WI:WebInXMLCarrierInvoice|updateInvoiceComments|REPLACE

[Insert Enterprise Name]|WI:WebInXMLCarrierInvoice|updateInvoiceAllReferences|REPLACE

[Insert Enterprise Name]|WI:WebInXMLCarrierInvoice|UserId|NAVIXLOADID

[Insert Enterprise Name]|WI:WebInXMLCarrierInvoice|RelativeLogFile|ImportWeb-XMLInvoice.csv

[Insert Enterprise Name]|WI:WebInXMLCarrierInvoice|RelativeCompleteDir|FreightBill

[Insert Enterprise Name]|WI:WebInXMLCarrierInvoice|PriceSheetType|Carrier

[Insert Enterprise Name]|WI:WebInXMLCarrierInvoice|Parser|com.mg.importers.XMLInvoiceParser

[Insert Enterprise Name]|WI:WebInXMLCarrierInvoice|Loader|com.mg.importers.InvoiceLoader

[Insert Enterprise Name]|WI:WebInXMLCarrierInvoice|InvoiceLoadByEDIReceiverId|false

[Insert Enterprise Name]|WI:WebInXMLCarrierInvoice|InvoiceCheckInfo|REPLACE

[Insert Enterprise Name]|WI:WebInXMLCarrierInvoice|InvoiceAllCharges|REPLACE

[Insert Enterprise Name]|WI:WebInXMLCarrierInvoice|ImportInvoicesOfInactiveCarrier|false

[Insert Enterprise Name]|WI:WebInXMLCarrierInvoice|FindCarrierBy-XX-options|SCAC-FIRST-MATCH

[Insert Enterprise Name]|WI:WebInXMLCarrierInvoice|FindCarrierBy|SCAC-FIRST-MATCH

[Insert Enterprise Name]|WI:WebInXMLCarrierInvoice|FileNameRegEx|(?i)Carrier-Invoice.*xml

[Insert Enterprise Name]|WI:WebInXMLCarrierInvoice|DefaultInvoiceType|Carrier

[Insert Enterprise Name]|WI:WebInXMLCarrierInvoice|DateFormatXXX|MM/dd/yyyy hh:mm

[Insert Enterprise Name]|WI:WebInXMLCarrierInvoice|DateFormat|MM/dd/yyyy

[Insert Enterprise Name]|WI:WebInXMLCarrierInvoice|BaseImportDirectory-TestMode|{INSERT CORRECT DIRECTORY}

[Insert Enterprise Name]|WI:WebInXMLCarrierInvoice|BaseImportDirectory|{INSERT CORRECT DIRECTORY}

[Insert Enterprise Name]|WI:WebInXMLCarrierInvoice|AllowMultiplePROReferences|false

 

[Insert Enterprise Name]|WI:WebInDocumentLink|customerIntegrationId|Demo

[Insert Enterprise Name]|WI:WebInDocumentLink|UserId|NAVIXLOADID

 

[Insert Enterprise Name]|ImportWeb|??? – Can someone at Infios please fill in?

LinkTypes- These are the types of Document Links that Navix is able to send back to MG.

Mapping: The "Code" value in each of these tables represents the value that comes out of Navix's API. MercuryGate's Code Tables eliminate the need for Navix to do custom mapping of documents on our clients' behalf. For example, if you prefer to call a Bill of Lading a BOL, you can map like this:

*|LinkTypes|BillOfLading|BOL

Full Mapping Table:

*|LinkTypes|DeliveryReceipt|Delivery Receipt

*|LinkTypes|ProofOfDelivery|Proof of Delivery

*|LinkTypes|BillOfLading|Bill of Lading

*|LinkTypes|NoticeOfAssignment|Notice of Assignment

*|LinkTypes|RateConfirmation|Rate Confirmation

*|LinkTypes|WeightAndInspectionCertificate|Weight and Inspection Certificate

*|LinkTypes|LetterOfAuthority|Letter of Authority

*|LinkTypes|LumperReceipt|Lumper Receipt

*|LinkTypes|PackingList|Packing List

*|LinkTypes|GeneratedInvoice|Generated Invoice

*|LinkTypes|Email|Email

*|LinkTypes|CommercialInvoice|Commercial Invoice

*|LinkTypes|CertificateOfOrigin|Certificate of Origin

*|LinkTypes|CustomerRateConfirmation|Customer Rate Confirmation

*|LinkTypes|ElectronicInterchangeReceipt|Electronic Interchange Receipt

*|LinkTypes|GatePass|Gate Pass

*|LinkTypes|InsuranceCertificate|Insurance Certificate

*|LinkTypes|OtherReceipt|Other Receipt

*|LinkTypes|W9|W9

*|LinkTypes|DeliveryOrder|Delivery Order

*|LinkTypes|WeightScaleTicket|Weight Scale Ticket

*|LinkTypes|TrailerInterchangeReceipt|Trailer Interchange Receipt

*|LinkTypes|PurchaseOrder|Purchase Order

*|LinkTypes|EscortTicket|Escort Ticket

*|LinkTypes|PermitReceipt|Permit Receipt

*|LinkTypes|ServiceOrder|Service Order

*|LinkTypes|CertificateOfDestruction|Certificate of Destruction

*|LinkTypes|DonationReceipt|Donation Receipt

*|LinkTypes|SmartAndFinalStamp|Smart And Final Stamp

*|LinkTypes|InboundTripReport|Inbound Trip Report

*|LinkTypes|WeighmasterCertificate|Weighmaster Certificate

*|LinkTypes|CargoActivitySheet|Cargo Activity Sheet

*|LinkTypes|WeberBOL|Weber BOL

*|LinkTypes|TimeCard|Time Card

*|LinkTypes|TransferSheet|Transfer Sheet

*|LinkTypes|TripManifest|Trip Manifest

*|LinkTypes|TrailerControlRecord|Trailer Control Record

*|LinkTypes|TargetTripSheet|Target Trip Sheet

*|LinkTypes|ExitPass|Exit Pass

*|LinkTypes|PortOfArthurBOL|Port of Arthur BOL

*|LinkTypes|ColdChainCustodyForm|Cold Chain Custody Form

*|LinkTypes|IGFFreightDispatch|IGF Freight Dispatch

*|LinkTypes|EquipmentSubmissionForm|Equipment Submission Form

*|LinkTypes|Release|Release

*|LinkTypes|ACIManifest|ACI Manifest

*|LinkTypes|TrailerPicture|Trailer Picture

*|LinkTypes|MaterialSafetyDataSheet|Material Safety Data Sheet

*|LinkTypes|ShipTicket|Ship Ticket

*|LinkTypes|DeliveryTicket|Delivery Ticket

*|LinkTypes|InvoiceCorrected|Invoice - Corrected

*|LinkTypes|EIRTicket|EIR Ticket

*|LinkTypes|PalletReceipt|Pallet Receipt

*|LinkTypes|HistoricalAuditDocuments|Historical Audit Documents

*|LinkTypes|DetentionReceipt|Detention Receipt

*|LinkTypes|Unknown|Unknown

*|LinkTypes|Manifest|Manifest

*|LinkTypes|CustomerRateApproval|Customer Rate Approval

*|LinkTypes|LoadCoverSheet|Load Cover Sheet

*|LinkTypes|SafetyChecklist|Safety Checklist

*|LinkTypes|WalmartDeliveryConfirmationReport|Walmart Delivery Confirmation Report