Connectors
Microsoft Dynamics On-Premise
Connectors
Microsoft Dynamics On-Premise
Connector Details
| Name | Value |
|---|---|
| Platform | Microsoft Dynamics On-Premise |
| Auth Type | API Keys |
| Direction | Bidirectional |
Supported Data
See the table below for the list of data you can read with the Microsoft Dynamics On-Premise connector.
| Table Name | Fields |
|---|---|
| accounts | No, Name, GIFI_Code, Net_Change, Balance, Income_Balance, Account_Category, Account_Subcategory_Descript, Account_Type, Direct_Posting, Totaling, Gen_Posting_Type, Gen_Bus_Posting_Group, Gen_Prod_Posting_Group, VAT_Bus_Posting_Group, VAT_Prod_Posting_Group, Debit_Amount, Credit_Amount, Balance_at_Date, Additional_Currency_Net_Change, Add_Currency_Balance_at_Date, Additional_Currency_Balance, Consol_Debit_Acc, Consol_Credit_Acc, Cost_Type_No, Consol_Translation_Method, Default_IC_Partner_G_L_Acc_No, Default_Deferral_Template_Code, Business_Unit_Filter, Global_Dimension_1_Filter, Global_Dimension_2_Filter, Date_Filter, Dimension_Set_ID_Filter |
| companies | Name, Evaluation_Company, Display_Name, Id, Business_Profile_Id |
| items | id, number, number2, description, searchDescription, description2, assemblyBom, baseUnitOfMeasure, priceUnitConversion, type, inventoryPostingGroup, shelfNumber, itemDiscGroup, allowInvoiceDisc, statisticsGroup, commissionGroup, unitPrice, priceProfitCalculation, profitPercent, costingMethod, unitCost, standardCost, lastDirectCost, indirectCostPercent, costIsAdjusted, allowOnlineAdjustment, vendorNumber, vendorItemNumber, leadTimeCalculation, reorderPoint, maximumInventory, reorderQuantity, alternativeItemNumber, unitListPrice, dutyDuePercent, dutyCode, grossWeight, netWeight, unitsPerParcel, unitVolume, durability, freightType, tariffNumber, dutyUnitConversion, countryRegionPurchasedCode, budgetQuantity, budgetedAmount, budgetProfit, comment, blocked, costIsPostedToGL, blockReason, lastDatetimeModified, lastDateModified, lastTimeModified, dateFilter, globalDimension1Filter, globalDimension2Filter, locationFilter, inventory, netInvoicedQty, netChange, purchasesQty, salesQty, positiveAdjmtQty, negativeAdjmtQty, purchasesLcy, salesLcy, positiveAdjmtLcy, negativeAdjmtLcy, cogsLcy, qtyOnPurchOrder, qtyOnSalesOrder, priceIncludesVat, dropShipmentFilter, vatBusPostingGrPrice, genProdPostingGroup, transferredQty, transferredLcy, countryRegionOfOriginCode, automaticExtTexts, numberSeries, taxGroupCode, vatProdPostingGroup, reserve, reservedQtyOnInventory, reservedQtyOnPurchOrders, reservedQtyOnSalesOrders, globalDimension1Code, globalDimension2Code, resQtyOnOutboundTransfer, resQtyOnInboundTransfer, resQtyOnSalesReturns, resQtyOnPurchReturns, stockoutWarning, preventNegativeInventory, costOfOpenProductionOrders, applicationWkshUserId, assemblyPolicy, resQtyOnAssemblyOrder, resQtyOnAsmComp, qtyOnAssemblyOrder, qtyOnAsmComponent, qtyOnJobOrder, resQtyOnJobOrder, gtin, defaultDeferralTemplateCode, lowLevelCode, lotSize, serialNos, lastUnitCostCalcDate, rolledUpMaterialCost, rolledUpCapacityCost, scrapPercent, inventoryValueZero, discreteOrderQuantity, minimumOrderQuantity, maximumOrderQuantity, safetyStockQuantity, orderMultiple, safetyLeadTime, flushingMethod, replenishmentSystem, scheduledReceiptQty, scheduledNeedQty, roundingPrecision, binFilter, variantFilter, salesUnitOfMeasure, purchUnitOfMeasure, timeBucket, reservedQtyOnProdOrder, resQtyOnProdOrderComp, resQtyOnReqLine, reorderingPolicy, includeInventory, manufacturingPolicy, reschedulingPeriod, lotAccumulationPeriod, dampenerPeriod, dampenerQuantity, overflowLevel, planningTransferShipQty, planningWorksheetQty, stockkeepingUnitExists, manufacturerCode, itemCategoryCode, createdFromNonstockItem, substitutesExist, qtyInTransit, transOrdReceiptQty, transOrdShipmentQty, qtyAssignedToShip, qtyPicked, serviceItemGroup, qtyOnServiceOrder, resQtyOnServiceOrders, itemTrackingCode, lotNos, expirationCalculation, lotNumberFilter, serialNumberFilter, qtyOnPurchReturn, qtyOnSalesReturn, numberOfSubstitutes, warehouseClassCode, specialEquipmentCode, putAwayTemplateCode, putAwayUnitOfMeasureCode, physInvtCountingPeriodCode, lastCountingPeriodUpdate, lastPhysInvtDate, useCrossDocking, nextCountingStartDate, nextCountingEndDate, identifierCode, unitOfMeasureId, taxGroupId, routingNumber, productionBomNumber, singleLevelMaterialCost, singleLevelCapacityCost, singleLevelSubcontrdCost, singleLevelCapOvhdCost, singleLevelMfgOvhdCost, overheadRate, rolledUpSubcontractedCost, rolledUpMfgOvhdCost, rolledUpCapOverheadCost, planningIssuesQty, planningReceiptQty, plannedOrderReceiptQty, fpOrderReceiptQty, relOrderReceiptQty, planningReleaseQty, plannedOrderReleaseQty, purchReqReceiptQty, purchReqReleaseQty, orderTrackingPolicy, prodForecastQuantityBase, productionForecastName, componentForecast, qtyOnProdOrder, qtyOnComponentLines, critical, commonItemNumber |
| vendors | id, number, name, searchName, name2, address, address2, city, contact, phoneNumber, telexNumber, ourAccountNumber, territoryCode, globalDimension1Code, globalDimension2Code, budgetedAmount, vendorPostingGroup, currencyCode, languageCode, statisticsGroup, paymentTermsCode, finChargeTermsCode, purchaserCode, shipmentMethodCode, shippingAgentCode, invoiceDiscCode, countryRegionCode, comment, blocked, payToVendorNumber, priority, paymentMethodCode, lastModifiedDateTime, lastDateModified, dateFilter, globalDimension1Filter, globalDimension2Filter, balance, balanceLcy, netChange, netChangeLcy, purchasesLcy, invDiscountsLcy, pmtDiscountsLcy, balanceDue, balanceDueLcy, payments, invoiceAmounts, crMemoAmounts, financeChargeMemoAmounts, paymentsLcy, invAmountsLcy, crMemoAmountsLcy, finChargeMemoAmountsLcy, outstandingOrders, amtRcdNotInvoiced, applicationMethod, pricesIncludingVat, faxNumber, telexAnswerBack, vatRegistrationNumber, genBusPostingGroup, picture@odata.mediaEditLink, picture@odata.mediaReadLink, gln, postCode, county, debitAmount, creditAmount, debitAmountLcy, creditAmountLcy, eMail, homePage, reminderAmounts, reminderAmountsLcy, numberSeries, taxAreaCode, taxLiable, vatBusPostingGroup, currencyFilter, outstandingOrdersLcy, amtRcdNotInvoicedLcy, blockPaymentTolerance, pmtDiscToleranceLcy, pmtToleranceLcy, icPartnerCode, refunds, refundsLcy, otherAmounts, otherAmountsLcy, prepaymentPercent, outstandingInvoices, outstandingInvoicesLcy, payToNumberOfArchivedDoc, buyFromNumberOfArchivedDoc, partnerType, creditorNumber, preferredBankAccountCode, cashFlowPaymentTermsCode, primaryContactNumber, responsibilityCenter, locationCode, leadTimeCalculation, numberOfPstdReceipts, numberOfPstdInvoices, numberOfPstdReturnShipments, numberOfPstdCreditMemos, payToNumberOfOrders, payToNumberOfInvoices, payToNumberOfReturnOrders, payToNumberOfCreditMemos, payToNumberOfPstdReceipts, payToNumberOfPstdInvoices, payToNumberOfPstdReturnS, payToNumberOfPstdCrMemos, numberOfQuotes, numberOfBlanketOrders, numberOfOrders, numberOfInvoices, numberOfReturnOrders, numberOfCreditMemos, numberOfOrderAddresses, payToNumberOfQuotes, payToNumberOfBlanketOrders, numberOfIncomingDocuments, baseCalendarCode, documentSendingProfile, validateEuVatRegNumber, currencyId, paymentTermsId, paymentMethodId |