Connectors
Exact
Connector Details
| Name | Value |
|---|---|
| Platform | Exact |
| Auth Type | OAuth |
| Direction | Read |
Supported Data
See the table below for the list of data you can read with the Exact connector.
| Table Name | Fields |
|---|---|
| items | AverageCost, Code, CopyRemarks, CostPriceCurrency, CostPriceNew, CostPriceStandard, Created, Creator, CreatorFullName, Division, EndDate, Description, ExtraDescription, FreeBoolField_01, FreeBoolField_02, FreeBoolField_03, FreeBoolField_04, FreeBoolField_05, FreeDateField_01, FreeDateField_02, FreeDateField_03, FreeDateField_04, FreeDateField_05, FreeNumberField_01, FreeNumberField_02, FreeNumberField_03, FreeNumberField_04, FreeNumberField_05, FreeNumberField_06, FreeNumberField_07, FreeNumberField_08, FreeTextField_01, FreeTextField_02, FreeTextField_03, FreeTextField_04, FreeTextField_05, FreeTextField_06, FreeTextField_07, FreeTextField_08, FreeTextField_09, FreeTextField_10, GLCosts, GLCostsCode, GLCostsDescription, GLRevenueCode, GLRevenue, GLRevenueDescription, GLStockCode, GLStockDescription, GLStock, ID, IsBatchItem, IsFractionAllowedItem, IsMakeItem, IsNewContract, IsOnDemandItem, IsPackageItem, IsPurchaseItem, IsSalesItem, IsSerialItem, IsStockItem, IsSubcontractedItem, IsTaxableItem, IsTime, Class_01, Class_02, Class_03, Class_04, Class_05, Class_06, Class_07, Class_08, Class_09, Class_10, Barcode, IsWebshopItem, ItemGroup, ItemGroupCode, ItemGroupDescription, Modified, Modifier, ModifierFullName, SecurityLevel, StandardSalesPrice, Stock, Unit, UnitDescription, UnitType, GrossWeight, NetWeight, NetWeightUnit, Notes, PictureName, PictureUrl, PictureThumbnailUrl, SalesVatCode, SalesVatCodeDescription, SearchCode, SecuriytLevel, StartDate, StatisticalCode, StatisticalNetWeight, StatisticalUnits, StatisticalValue |
| purchase_orderlines | ID, AmountDC, AmountFC, CostCenter, CostCenterDescription, CostUnit, CostUnitDescription, Created, Creator, CreatorFullName, Description, Discount, Expense, Division, ExpenseDescription, InStock, InvoiceQuantity, IsBatchNumberItem, IsSerialNumberItem, Item, ItemBarcode, ItemCode, ItemDescription, ItemDivisable, LineNumber, Modified, Modifier, ModifierFullName, NetPrice, Notes, Project, ProjectCode, ProjectDescription, ProjectedStock, PurchaseOrderID, Quantity, QuantityInPurchaseUnits, Rebill, ReceiptDate, ReceivedQuantity, SalesOrder, SalesOrderLine, SalesOrderLineNumber, SalesOrderNumber, SupplierItemCode, SupplierItemCopyRemarks, Unit, UnitDescription, UnitPrice, VATAmount, VATCode, VATDescription, VATPercentage |
| purchase_orders | AmountDC, AmountFC, Created, Creator, CreatorFullName, Currency, DeliveryAccount, DeliveryAccountCode, DeliveryAccountName, DeliveryAddress, DeliveryContact, DeliveryContactPersonFullName, Description, Division, Document, DocumentSubject, DropShipment, ExchangeRate, IncotermAddress, IncotermCode, IncotermVersion, InvoiceStatus, Modified, Modifier, ModifierFullName, OrderDate, OrderNumber, OrderStatus, PaymentCondition, PaymentConditionDescription, PurchaseOrderID, PurchaseAgent, PurchaseAgentFullName, PurchaseOrderLineCount, ReceiptDate, ReceiptStatus, Remarks, SalesOrder, SalesOrderNumber, SelectionCode, SelectionCodeCode, SelectionCodeDescription, ShippingMethod, ShippingMethodCode, ShippingMethodDescription, Source, Supplier, SupplierCode, SupplierContact, SupplierContactPersonFullName, SupplierName, VATAmount, Warehouse, WarehouseCode, WarehouseDescription, YourRef |
| sales_invoice_lines | ID, AmountDC, ItemCode, InvoiceID, Quantity, SalesOrderNumber |
| sales_invoices | InvoiceID, AmountDC, InvoiceDate |
| sales_items_prices | ID, Item, ItemCode, Price, Quantity, StartDate, EndDate |
| sales_order | AmountDC, AmountFC, AmountFCExclVat, DeliverToContactPerson, DeliverToContactPersonFullName, DeliverToName, OrderedByName, TaxSchedule, WarohouseID, YourRef, AmountDiscount, AmountDiscountExclVat, ApprovalStatus, ApprovalStatusDescription, Approved, Approver, ApproverFullName, Created, Creator, CreatorFullName, Currency, DeliverTo, DeliveryDate, DeliveryStatus, DeliveryStatusDescription, DeliveryAddress, Description, OrderDate, OrderedBy, OrderedNyName, OrderID, OrderNumber, Salesperson, Status, StatusDescription, WarehouseCode, WarehouseID, WarehouseDescription |
| sales_orderlines | AmountDC, AmountFC, DeliveryDate, Description, Discount, ID, Item, ItemCode, ItemDescription, LineNumber, NetPrice, OrderID, OrderNumber, Quantity, UnitCode, UnitDescription, UnitPrice, UseDropShipment, VATAmount, CostCenter, CostCenterDescription, CostPriceFC, CostUnit, CostUnitDescription, CustomerItemCode, Division, ItemVersion, ItemVersionDescription, Notes, Pricelist, PricelistDescription, ProjectDescription, Project, PurchaseOrder, PurchaseOrderLine, PurchaseOrderLineNumber, PurchaseOrderNumber, ShopOrder, VATCode, VATCodeDescription, VATPercentage |
| supplierProducts | Creator, CreatorFullName, Currency, CurrencyDescription, Division, DropShipment, ID, Item, ItemCode, ItemDescription, MinimumQuantity, Modified, Modifier, ModifierFullName, PurchaseLeadTime, PurchasePrice, PurchaseUnit, PurchaseUnitDescription, StartDate, Supplier, SupplierCode, SupplierDescription, SupplierItemCode, CopyRemarks, CountryOfOrigin, CountryOfOriginDescription, Created, EndDate, MainSupplier, Notes, PurchaseUnitFactor, PurchaseVATCode, PurchaseVATCodeDescription |
| suppliers | ID, Name, Email, PurchaseLeadDays |
| warehouses | Created, CreatorFullName, CurrentStock, ID, Item, ItemCode, ItemDescription, ItemStartDate, ItemUnit, ItemUnitDescription, MaximumStock, Modified, Modifier, ModifierFullName, ProjectedStock, ReorderPoint, SafetyStock, StorageLocationUrl, Warehouse, WarehouseCode, WarehouseDescription, ItemIsSotckItem, ItemEndDate, PlanningDetailsUrl, PlannedStockIn, PlannedStockOut, Creator, DefaultStorageLocation, DefaultStorageLocationCode, DefaultStorageLocationDescription, Division, OrderPolicy, Period, ReorderQuantity, ReplenishmentType, ReservedStock, ItemIsFractionAllowedItem, ItemIsStockItem |
Credentials Setup
Follow the steps below to get the credentials you need to use the Exact connector.
The first thing you need to do is log in to Exact, or create a free Exact account.
Click on Manage my app.
Scroll down you will see production Apps. You can register your app.
Enter App name and Add redirect URI. You should add the Redirect URI https://hotglue.xyz/callback
You can get Client ID and secret from Develop Your APP section.
Now you can insert the client id and client secret pair into your hotglue Exact source settings.