When integrating AGR with Dynamics 365 Finance & Operations via Recurring Integrations, the following data entities and their respective fields are required to ensure a seamless data flow into AGR:
Data Entities
1 | Bill of materials headers |
2 | Bill of materials lines V3 |
3 | Customers V3 |
4 | InventDim DataEntity |
5 | InventTrans DataEntity |
6 | Inventory on-hand by warehouse V2 |
7 | Item coverage V2 |
8 | Product categories |
9 | Product category hierarchies |
10 | Product default order settings V3 |
11 | Products V2 |
12 | Purchase order lines V2 |
13 | Released products V2 |
14 | Sales order headers V3 |
15 | Sales order lines V3 |
16 | Transfer order headers |
17 | Transfer order lines |
18 | Vendors V2 |
19 | Warehouse locations |
Data Entity Fields
Bill of materials headers |
BOMID |
ENGCHGDISPLAYPRODUCTNUMBER |
Bill of materials lines V3 |
BOMID |
ITEMNUMBER |
QUANTITY] |
Customers V3 |
CUSTOMERACCOUNT |
ORGANIZATIONNAME |
ADDRESSDESCRIPTION |
DELIVERYADDRESSLOCATIONID |
ADDRESSCITY |
ORGANIZATIONNAME/NAME |
InventDim DataEntity |
INVENTDIMID |
CONFIGID |
INVENTLOCATIONID |
InventTrans DataEntity |
RECID1 |
DATEPHYSICAL |
ITEMID |
QTY |
REFERENCECATEGORY |
REFERENCEID |
INVENTTRANSID |
INVENTDIMID |
STATUSISSUE |
Inventory on-hand by warehouse V2 |
ITEMNUMBER |
PRODUCTCONFIGURATIONID |
INVENTORYWAREHOUSEID |
ONHANDQUANTITY |
TOTALAVAILABLEQUANTITY |
Item coverage V2 |
ITEMNUMBER |
COVERAGEWAREHOUSEID |
COVERAGEPRODUCTCONFIGURATIONID |
MAXIMUMONHANDINVENTORYQUANTITY |
MINIMUMONHANDINVENTORYQUANTITY |
PROCUREMENTLEADTIMEDAYS |
REORDERPOINT |
REORDERPOINT |
Product categories |
PRODUCTCATEGORYHIERARCHYNAME |
CATEGORYNAME |
CATEGORYCODE |
CATEGORYDESCRIPTION |
CATEGORYKEYWORDS |
CATEGORYRECORDID |
DEFAULTPROJECTGLOBALCATEGORYID |
EXTERNALID |
FRIENDLYCATEGORYNAME |
ISCATEGORYINHERITINGPARENTCATEGORYATTRIBUTES |
ISCATEGORYINHERITINGPARENTPRODUCTATTRIBUTES |
ISTANGIBLEPRODUCT |
PARENTPRODUCTCATEGORYCODE |
PARENTPRODUCTCATEGORYHIERARCHYNAME |
PARENTPRODUCTCATEGORYNAME |
PROJECTCATEGORYNAME |
Product category hierarchies |
HIERARCHYNAME |
HIERARCHYDESCRIPTION |
Product default order settings V3 |
ITEMNUMBER |
PROCUREMENTQUANTITYMULTIPLES |
INVENTORYLEADTIMEDAYS |
MINIMUMPROCUREMENTORDERQUANTITY |
PROCUREMENTLEADTIMEDAYS |
ISPROCUREMENTUSINGWORKINGDAYS |
Products V2 |
PRODUCTNUMBER |
PRODUCTDESCRIPTION |
PRODUCTNAME |
Purchase order lines V2 |
PURCHASEORDERNUMBER |
CONFIRMEDDELIVERYDATE |
ITEMNUMBER |
ORDEREDPURCHASEQUANTITY |
RECEIVINGWAREHOUSEID |
Released products V2 |
ITEMNUMBER |
PURCHASEPRICE |
PURCHASEPRICEQUANTITY |
SALESPRICE |
PRODUCTGROUPID |
PRIMARYVENDORACCOUNTNUMBER |
BUYERGROUPID |
PURCHASEUNITSYMBOL |
PRODUCTVOLUME |
NETPRODUCTWEIGHT |
SEARCHNAME |
UNITCOST |
UNITCOSTQUANTITY |
Sales order headers V3 |
SALESORDERNUMBER |
DELIVERYADDRESSLOCATIONID |
Sales order lines V3 |
CONFIRMEDRECEIPTDATE |
DELIVERYADDRESSCITY |
DELIVERYADDRESSNAME |
ITEMNUMBER |
ORDEREDSALESQUANTITY |
SALESORDERLINESTATUS |
SALESORDERNUMBER |
INVENTORYLOTID |
SHIPPINGWAREHOUSEID |
Transfer order headers |
RECEIVINGWAREHOUSEID |
SHIPPINGWAREHOUSEID |
TRANSFERORDERNUMBER |
Transfer order lines |
TRANSFERORDERNUMBER |
ITEMNUMBER |
REQUESTEDRECEIPTDATE |
TRANSFERQUANTITY |
PRODUCTCONFIGURATIONID |
Vendors V2 |
VENDORACCOUNTNUMBER |
VENDORSEARCHNAME |
Warehouse locations |
WAREHOUSEID |