GET api/product/{id}/history/purchases
Lists purchase orders and invoices matching query parameters, that have specified product in detail table
Request Information
URI Parameters
Name | Description | Type | Additional information |
---|---|---|---|
id |
Product guid |
globally unique identifier |
Required |
Status | OrderStatus |
None. |
|
SupplierIdentifier | Collection of byte |
None. |
|
SupplierIdentifierGuid | globally unique identifier |
None. |
|
PLUG_UID | Collection of byte |
None. |
|
PluGuid | globally unique identifier |
None. |
|
StoreID |
Matches against either the ordered for store, or the ordered from store for store transfers |
integer |
None. |
TransfersOnlyStore |
When true, StoreID is only matched against the ordered from store for store transfers |
boolean |
None. |
OrdersOnlyStore |
When true, StoreID is only matched against the ordered for store |
boolean |
None. |
Search | string |
None. |
|
OrderNo | string |
None. |
|
DetailSearch | DetailSearchType |
None. |
|
OrderType | string |
None. |
|
ShowHeader | ShowHeaderType |
None. |
|
ExcludeCompleted | boolean |
None. |
|
ExcludeStarted | boolean |
None. |
|
ExcludeSent | boolean |
None. |
|
ExcludeInvoices | boolean |
None. |
|
ExcludeCancelled | boolean |
None. |
|
CreatedBefore |
Local created date filtering before |
date |
None. |
CreatedAfter |
Local created date filtering after |
date |
None. |
SentBefore |
Local sent date filtering before |
date |
None. |
DueDateBefore |
Due date filtering before |
date |
None. |
DueDateAfter |
Due date filtering after |
date |
None. |
SentAfter |
Local sent date filtering after |
date |
None. |
StockReceivedAfter |
Local stock received after |
date |
None. |
StockReceivedBefore |
Local stock received after |
date |
None. |
TradingPartner | OrderTradingPartner |
None. |
|
TransferInvoiced | boolean |
None. |
|
AutoOrder | boolean |
None. |
|
SortBy | OrderSortBy |
None. |
|
Sort | SortOrder |
None. |
|
Relations | boolean |
None. |
|
Details | boolean |
None. |
|
Skip |
Number of records to skip over |
integer |
None. |
Take |
Number of records to take |
integer |
None. |
TotalCount | integer |
Relation. This field may not always be loaded or used for updates. |
Body Parameters
None.
Response Information
Resource Description
PageList containing list of purchase history records and count of all matching purchase history
PageListOfPurchaseHistoryName | Description | Type | Additional information |
---|---|---|---|
Type | string |
None. |
|
List | Collection of PurchaseHistory |
None. |
|
Skip |
Number of records to skip over |
integer |
None. |
Take |
Number of records to take |
integer |
None. |
TotalCount | integer |
Relation. This field may not always be loaded or used for updates. |
Response Formats
application/json, text/json
{ "type": "PurchaseHistory", "list": [ { "$id": "2", "invoiceIdentifier": "yTUtO3a7OEC6pZvB3EeL4A==", "invoiceIdentifierGuid": "3b2d35c9-bb76-4038-baa5-9bc1dc478be0", "invoiceNo": "sample string 1", "invoiceDate": "2025-10-05T00:02:38.5056338", "invoiceText": "sample string 2", "invoiceSupplierIdentifier": "265w8H/zEU6laLNrwkMbqA==", "invoiceSupplierIdentifierGuid": "f070aedb-f37f-4e11-a568-b36bc2431ba8", "invoiceSupplierName": "sample string 3", "invoiceStatus": 1, "completed": "2025-10-05T00:02:38.5056338", "invoiceQty": 4.1, "invoiceCost": 5.1, "invoiceExtCost": 6.1, "hasInvoice": true, "orderGuid": "L+H1I9yiSUStYTFT1ZLEgw==", "orderIdentifier": "23f5e12f-a2dc-4449-ad61-3153d592c483", "orderID": 1, "sent": "2025-10-05T00:02:38.5056338", "sentLocal": "2025-10-05T00:02:38.5056338", "sentByUser": "sample string 8", "orderDescription": "sample string 9", "orderSupplierIdentifier": "EGU/tN5bkEeTO2cxO2sLhA==", "orderSupplierIdentifierGuid": "b43f6510-5bde-4790-933b-67313b6b0b84", "orderSupplierName": "sample string 10", "orderQty": 11.1, "orderCost": 12.1, "hasOrder": true }, { "$ref": "2" } ], "skip": 1, "take": 1, "totalCount": 1 }
application/xml, text/xml
<PageListOfPurchaseHistoryyDisaqof xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/EziManager.Models.Common"> <Skip>1</Skip> <Take>1</Take> <TotalCount>1</TotalCount> <List xmlns:d2p1="http://schemas.datacontract.org/2004/07/EziManager.Models.EMC.Orders"> <d2p1:PurchaseHistory> <d2p1:Completed>2025-10-05T00:02:38.5056338+00:00</d2p1:Completed> <d2p1:HasInvoice>true</d2p1:HasInvoice> <d2p1:HasOrder>true</d2p1:HasOrder> <d2p1:InvoiceCost>5.1</d2p1:InvoiceCost> <d2p1:InvoiceDate>2025-10-05T00:02:38.5056338+00:00</d2p1:InvoiceDate> <d2p1:InvoiceExtCost>6.1</d2p1:InvoiceExtCost> <d2p1:InvoiceIdentifier>yTUtO3a7OEC6pZvB3EeL4A==</d2p1:InvoiceIdentifier> <d2p1:InvoiceIdentifierGuid>3b2d35c9-bb76-4038-baa5-9bc1dc478be0</d2p1:InvoiceIdentifierGuid> <d2p1:InvoiceNo>sample string 1</d2p1:InvoiceNo> <d2p1:InvoiceQty>4.1</d2p1:InvoiceQty> <d2p1:InvoiceStatus>1</d2p1:InvoiceStatus> <d2p1:InvoiceSupplierIdentifier>265w8H/zEU6laLNrwkMbqA==</d2p1:InvoiceSupplierIdentifier> <d2p1:InvoiceSupplierIdentifierGuid>f070aedb-f37f-4e11-a568-b36bc2431ba8</d2p1:InvoiceSupplierIdentifierGuid> <d2p1:InvoiceSupplierName>sample string 3</d2p1:InvoiceSupplierName> <d2p1:InvoiceText>sample string 2</d2p1:InvoiceText> <d2p1:OrderCost>12.1</d2p1:OrderCost> <d2p1:OrderDescription>sample string 9</d2p1:OrderDescription> <d2p1:OrderGuid>L+H1I9yiSUStYTFT1ZLEgw==</d2p1:OrderGuid> <d2p1:OrderID>1</d2p1:OrderID> <d2p1:OrderIdentifier>23f5e12f-a2dc-4449-ad61-3153d592c483</d2p1:OrderIdentifier> <d2p1:OrderQty>11.1</d2p1:OrderQty> <d2p1:OrderSupplierIdentifier>EGU/tN5bkEeTO2cxO2sLhA==</d2p1:OrderSupplierIdentifier> <d2p1:OrderSupplierIdentifierGuid>b43f6510-5bde-4790-933b-67313b6b0b84</d2p1:OrderSupplierIdentifierGuid> <d2p1:OrderSupplierName>sample string 10</d2p1:OrderSupplierName> <d2p1:Sent>2025-10-05T00:02:38.5056338+00:00</d2p1:Sent> <d2p1:SentByUser>sample string 8</d2p1:SentByUser> <d2p1:SentLocal>2025-10-05T00:02:38.5056338+00:00</d2p1:SentLocal> </d2p1:PurchaseHistory> <d2p1:PurchaseHistory> <d2p1:Completed>2025-10-05T00:02:38.5056338+00:00</d2p1:Completed> <d2p1:HasInvoice>true</d2p1:HasInvoice> <d2p1:HasOrder>true</d2p1:HasOrder> <d2p1:InvoiceCost>5.1</d2p1:InvoiceCost> <d2p1:InvoiceDate>2025-10-05T00:02:38.5056338+00:00</d2p1:InvoiceDate> <d2p1:InvoiceExtCost>6.1</d2p1:InvoiceExtCost> <d2p1:InvoiceIdentifier>yTUtO3a7OEC6pZvB3EeL4A==</d2p1:InvoiceIdentifier> <d2p1:InvoiceIdentifierGuid>3b2d35c9-bb76-4038-baa5-9bc1dc478be0</d2p1:InvoiceIdentifierGuid> <d2p1:InvoiceNo>sample string 1</d2p1:InvoiceNo> <d2p1:InvoiceQty>4.1</d2p1:InvoiceQty> <d2p1:InvoiceStatus>1</d2p1:InvoiceStatus> <d2p1:InvoiceSupplierIdentifier>265w8H/zEU6laLNrwkMbqA==</d2p1:InvoiceSupplierIdentifier> <d2p1:InvoiceSupplierIdentifierGuid>f070aedb-f37f-4e11-a568-b36bc2431ba8</d2p1:InvoiceSupplierIdentifierGuid> <d2p1:InvoiceSupplierName>sample string 3</d2p1:InvoiceSupplierName> <d2p1:InvoiceText>sample string 2</d2p1:InvoiceText> <d2p1:OrderCost>12.1</d2p1:OrderCost> <d2p1:OrderDescription>sample string 9</d2p1:OrderDescription> <d2p1:OrderGuid>L+H1I9yiSUStYTFT1ZLEgw==</d2p1:OrderGuid> <d2p1:OrderID>1</d2p1:OrderID> <d2p1:OrderIdentifier>23f5e12f-a2dc-4449-ad61-3153d592c483</d2p1:OrderIdentifier> <d2p1:OrderQty>11.1</d2p1:OrderQty> <d2p1:OrderSupplierIdentifier>EGU/tN5bkEeTO2cxO2sLhA==</d2p1:OrderSupplierIdentifier> <d2p1:OrderSupplierIdentifierGuid>b43f6510-5bde-4790-933b-67313b6b0b84</d2p1:OrderSupplierIdentifierGuid> <d2p1:OrderSupplierName>sample string 10</d2p1:OrderSupplierName> <d2p1:Sent>2025-10-05T00:02:38.5056338+00:00</d2p1:Sent> <d2p1:SentByUser>sample string 8</d2p1:SentByUser> <d2p1:SentLocal>2025-10-05T00:02:38.5056338+00:00</d2p1:SentLocal> </d2p1:PurchaseHistory> </List> </PageListOfPurchaseHistoryyDisaqof>
application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
PK S E[��e�� 5 xl/workbook.xml � (� ����0D�&�C���� '.^=x_�" �%m ~��o�vfg�N1k34Z�#GesS�)g��%ؓ�P�]���y1�u�c��[�r,���� �l/&KW�?,;����N�+J�P�:)�fO�� �[��$l ��T`�EPD�Ē�����ے�)1���#i2�q�+O�Kr����a�~W_PK S E[���� � [Content_Types].xml � (� ���J�0�_��*M�D��V�*��d� �d�k��<�H���V���= ��|�o��|����������+�����7l���e۶~=E�"�zlXO�@Ճ��C�3]HNR~���R��uU�<���������a��36��b7םQ �1Z�$�8z�R��3 tP��-c�� g����_M��Of���~O�s�T���� ����P<�D��e=1Z��a2�b ��%#H'�2}���e�B)��~j/F�t��PK S E[j�\�' ' _rels/.rels � (� <?xml version="1.0" encoding="utf-8"?><Relationships xmlns="http://schemas.openxmlformats.org/package/2006/relationships"><Relationship Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/officeDocument" Target="xl/workbook.xml" Id="R12b63fe52cb64d9b" /></Relationships>PK S E[�0H� xl/worksheets/sheet1.xml � (� ��]o�0�������K"��T�]Ջ����l'���J�u� ��9~},�ۗ�gi��}I�!�}�+�rxr���٠ͳm�t��ݚ6��ٲ����>���jm:���9 ]ת�;]�:�;D1���V8��m��©ۿ�G#E"t�Ԫ��EV)�}L��sxG�{ *� �Rr��`<���Ǐ�Uq`� ~�?P�Z�Z���R�ĂS�ֆ'��8::�ރ�\3rO���71��K��:����oM&��:]���a�q����x����D$���e�d�������㒈�4M(����UMS#� '����P���՝_�p1~�����:��L|_䒸_�ح���د�d!���d�����a��� �)�q�\�/j��))�0���I�<h� w����+PK S E[�:�k� P xl/_rels/workbook.xml.rels � (� ��KN�0@�b͞8i�Ġ�ݰ��{�Q;��B�Ƃ#q�"A*�`��h~OO��|�Xoߦ�������$FFY=���Sh$l7�=���ٳ�b| }��^�4�O�L&vZ�&1u�Q�#�JӒ�%n��p��?D۶��g�N����Zw�=Q v@�Q����5dI����yS�RV�(D.W����|������L�dR���Y)���2=:�/��K/��党D��y��(Z�_���_l� PK S E[Ѓc'2 E xl/styles.xml � (� �S�j�0��&0���0�^�]v��:��d;��H��Kj�vG�Mz�zOHr�iB8v �F��WEG�?s�Oh�lff�uZМ���ށh�R���6�'��2��������ɳ�UŦ`<Қo���x���8��K�6BC ^�کĖ��B���n��f8����9� ����CUk��#��U�ub��WUB;��k���&� AR>��� ��im��ΑF���YO��%�}� ��LJ\in�,���9oy}��y.�$��6��ųNJ�c��T��rĘ)փBR淶�E3ʟ�\��q��PK S E[���� � xl/sharedStrings.xml � (� ePMK�0�+!w��T��ʪ���$�!}�a����*�_oV�{��)w���H�"Vr� ) m��|��.� 6�*� I��K"يTɑy�Қ����`V�b �3L��)��i����(�u0��qF��3���?�\]r�-���R�/w�����Mk�3�o������0';�ۜ�rR�CPM�,�H� BrV��n��_�5hH��=xR��Q����U����O��PK- S E[��e�� 5 xl/workbook.xmlPK- S E[���� � � [Content_Types].xmlPK- S E[j�\�' ' U _rels/.relsPK- S E[�0H� � xl/worksheets/sheet1.xmlPK- S E[�:�k� P � xl/_rels/workbook.xml.relsPK- S E[Ѓc'2 E � xl/styles.xmlPK- S E[���� � l xl/sharedStrings.xmlPK � �
application/vnd.ms-excel
PK S E[��a%� 5 xl/workbook.xml � (� ����0D�J��(� �P���ҵCwL� JR��o �ԭ��|~>>;4��F� [����`̉���P�]g��}1�uR`m�[��,���Y�K�]/'G7�?,7Y����^�J�Դ:��K���٭2{��$l��_a�Ū��%��%�soKSb�G�)�Is�&Ko ��>`���/PK S E[���� � [Content_Types].xml � (� ���J�0�_��*M�D��V�*��d� �d�k��<�H���V���= ��|�o��|����������+�����7l���e۶~=E�"�zlXO�@Ճ��C�3]HNR~���R��uU�<���������a��36��b7םQ �1Z�$�8z�R��3 tP��-c�� g����_M��Of���~O�s�T���� ����P<�D��e=1Z��a2�b ��%#H'�2}���e�B)��~j/F�t��PK S E[匥�' ' _rels/.rels � (� <?xml version="1.0" encoding="utf-8"?><Relationships xmlns="http://schemas.openxmlformats.org/package/2006/relationships"><Relationship Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/officeDocument" Target="xl/workbook.xml" Id="R8dce60619b0b4ec9" /></Relationships>PK S E[�0H� xl/worksheets/sheet1.xml � (� ��]o�0�������K"��T�]Ջ����l'���J�u� ��9~},�ۗ�gi��}I�!�}�+�rxr���٠ͳm�t��ݚ6��ٲ����>���jm:���9 ]ת�;]�:�;D1���V8��m��©ۿ�G#E"t�Ԫ��EV)�}L��sxG�{ *� �Rr��`<���Ǐ�Uq`� ~�?P�Z�Z���R�ĂS�ֆ'��8::�ރ�\3rO���71��K��:����oM&��:]���a�q����x����D$���e�d�������㒈�4M(����UMS#� '����P���՝_�p1~�����:��L|_䒸_�ح���د�d!���d�����a��� �)�q�\�/j��))�0���I�<h� w����+PK S E[��]�� P xl/_rels/workbook.xml.rels � (� ��KN�0@�b͞�N��ݰa[z��3����.г��H\�H�J,�t5��ӓf>�?�۷id/���l 2������ۻ ����F�i"��XZ���>�y�y0=M27�M��� cJ}�g4G��B��/p�d��L�!��=:s���?����c�"�=��b ?��/Af� 쩩a'�V��C��RUh�x)�z}���,��*�UQ(��7���S�}���iY^�=T$�4��\��/j��/6_PK S E[Ѓc'2 E xl/styles.xml � (� �S�j�0��&0���0�^�]v��:��d;��H��Kj�vG�Mz�zOHr�iB8v �F��WEG�?s�Oh�lff�uZМ���ށh�R���6�'��2��������ɳ�UŦ`<Қo���x���8��K�6BC ^�کĖ��B���n��f8����9� ����CUk��#��U�ub��WUB;��k���&� AR>��� ��im��ΑF���YO��%�}� ��LJ\in�,���9oy}��y.�$��6��ųNJ�c��T��rĘ)փBR淶�E3ʟ�\��q��PK S E[���� � xl/sharedStrings.xml � (� ePMK�0�+!w��T��ʪ���$�!}�a����*�_oV�{��)w���H�"Vr� ) m��|��.� 6�*� I��K"يTɑy�Қ����`V�b �3L��)��i����(�u0��qF��3���?�\]r�-���R�/w�����Mk�3�o������0';�ۜ�rR�CPM�,�H� BrV��n��_�5hH��=xR��Q����U����O��PK- S E[��a%� 5 xl/workbook.xmlPK- S E[���� � � [Content_Types].xmlPK- S E[匥�' ' U _rels/.relsPK- S E[�0H� � xl/worksheets/sheet1.xmlPK- S E[��]�� P � xl/_rels/workbook.xml.relsPK- S E[Ѓc'2 E � xl/styles.xmlPK- S E[���� � k xl/sharedStrings.xmlPK � �