This information applies to Microsoft Dynamics Business Central versions 17+ and Business Central Public Cloud, integrated with AGR through the AGR Data Integrator.
Overview
When AGR sends an order to Business Central, the AGR Data Integrator receives it through two REST endpoints exposed by the extension:
AGR API Order Header — one record per AGR order, containing the order-level information.
AGR API Order Lines — one record per item line on the order, linked back to the header through
agr_order_id.
This article documents every field that AGR can populate on those two entities, so you can confirm what data is delivered into BC and use it in your downstream processes (Purchase Orders, Transfer Orders, Production Orders, Assembly Orders, or the Requisition Worksheet).
AGR API Order Header
Source entity in BC: ori AGR API Order Header. One row per AGR order.
Field | Description |
| Unique AGR order identifier. Used to link header to lines. |
| Order type as received from AGR: Purchase, Transfer, Production, or Assembly. |
| Origin location or vendor number. |
| Destination location number. |
| Estimated delivery date. |
| BC order number created from this AGR order. |
| BC order type created (Purchase Order, Transfer Order, etc.). |
| BC posted document number (populated after posting). |
| Date the order was posted in BC. |
| Flag indicating the order was sent from AGR. |
| Flag indicating the order has been processed into BC. |
| Flag indicating the order lines have been imported. |
| Flag indicating status has been updated back to AGR. |
| Flag to skip processing for this order. |
| Whether the order has an error. |
| Error description. |
| Type of BC error. |
| Timestamp when the record was created. |
| Timestamp when the record was last modified. |
| User who created the record. |
| User who last modified the record. |
AGR API Order Lines
Source entity in BC: ori AGR API Order Lines. One row per line on the order. Lines are linked to the header through agr_order_id.
Field | Description |
| AGR order identifier (link to the header). |
| Line number within the AGR order. |
| BC item number to be ordered. |
| Item variant code. |
| Quantity to order. |
| Destination location for this line. |
| Color attribute (AGR-specific). |
| Size attribute (AGR-specific). |
| Style attribute (AGR-specific). |
| Base unit of measure resolved in BC. |
| Purchase unit of measure resolved in BC. |
| BC production or assembly order number created for this line. |
| Planning reference order number (Requisition Worksheet). |
| Internal header reference. |
| Whether this line has an error. |
| Error description for this line. |
| Timestamp when the record was created. |
| Timestamp when the record was last modified. |
| User who created the record. |
| User who last modified the record. |