Retrieves all the purchase order order lines
Request Information
URI Parameters :
None.
Body Parameters :
None.
Response Information
Resource Description :
IHttpActionResult
purchase_order_detailsName | Description | Type | Additional information |
---|---|---|---|
id |
Primary Key |
globally unique identifier | |
purchase_order_id |
Foreign key of the purchase_order |
globally unique identifier |
Optionally required : purchase_order_id, purchase_order_reference or purchase_order must be provided |
purchase_order_reference_back_office |
Embedded entity "purchase_order" using ERP PK when adding/updating |
string |
Optionally required : purchase_order_id, purchase_order_reference_back_office or purchase_order must be provided |
purchase_order |
Embedded entity "purchase_order" when adding/updating |
purchase_order |
Optionally required : purchase_order_id, purchase_order_reference_back_office or purchase_order must be provided |
article_id |
Foreign key of article |
globally unique identifier |
Optionally required : article_id, article_code or article must be provided |
article_code |
Embedded entity "article" using ERP PK when adding/updating |
string |
Optionally required : article_id, article_code or article must be provided |
article |
Embedded entity "article" when adding/updating |
article |
Optionally required : article_id, article_code or article must be provided |
line_number |
Line Number, auto filled with (Highest+1) if value is 0/null |
integer | |
code |
Code of the article (auto filled if empty) |
string |
Max length: 255 |
supplier_code |
Code of the supplier for this article |
string |
Max length: 255 |
name |
Article Name (will be auto filled if article.name+description are empty) |
string |
Max length: 255 |
description |
Article description (will be auto filled by article.short_description if name+description are empty) |
string |
Max length: 255 |
price |
Unit Price |
decimal number |
Matching regular expression pattern: ^[0-9]\d*(\.\d+)?$ Range: inclusive between 0.1 and 1.79769313486232E+308 |
quantity |
Quantity |
decimal number |
Required Range: inclusive between 0.1 and 1.79769313486232E+308 |
memo |
Line memo/remark |
string | |
cost_price |
Unit Cost Price (statistic purpose) |
decimal number |
Matching regular expression pattern: ^[0-9]\d*(\.\d+)?$ |
reference_back_office |
Field used for Embedded entity (store there your ERP PK) |
string |
Max length: 50 |
modified_dateutc |
Readonly system field managed by database, filled with GetUtcDate when adding,updating |
date |
Response Formats
application/json, text/json
{ "id": "7d055f76-e80b-4fd1-ae9a-44c8d978b0cf", "purchase_order_id": "8f59ef16-7c7e-4926-b1ee-dbb078fac7a9", "purchase_order_reference_back_office": "sample string 3", "purchase_order": { "id": "12ed0a7d-d347-4b4b-9e45-215f5a1346f0", "id2": 2, "jobs_id": "6afc8fbf-7ab3-4c4e-8554-2ac0d4a99740", "jobs_reference_back_office": "sample string 4", "supplier_company_id": "0feaf3ae-ef93-4eb6-8fdb-adb0a10a31ba", "supplier_company_code": "sample string 6", "user_id": "2367194e-3490-47d3-9b9b-e69596db634f", "user_code": "sample string 8", "description": "sample string 9", "memo": "sample string 10", "total_lines": 11, "date_create": "2025-06-29T10:04:41.6307261+00:00", "date_update": "2025-06-29T10:04:41.6307261+00:00", "date_delivery": "2025-06-29T10:04:41.6307261+00:00", "confirmed_date_delivery": "2025-06-29T10:04:41.6307261+00:00", "delivery_db_address_id": "b6061d2a-5252-433d-acef-bf01cb7abae2", "approved_by_user_id": "bce6ff19-ae3e-46d1-9206-48a61e240784", "approved_by_user_code": "sample string 18", "technical_user_id": "673f1b2d-be65-4612-8b0a-6af11c5ef7b2", "technical_user_code": "sample string 20", "purchase_order_status_id": "2157cc2b-d857-4d47-95e7-f2e8c3032c47", "purchase_order_status_code": "sample string 22", "article_stock_location_id": "bcb98d5f-3b8b-4f1c-882a-ee6364130e1a", "is_pickup": true, "reference_back_office": "sample string 25", "modified_dateutc": "2025-06-29T10:04:41.6307261+00:00" }, "article_id": "693fd6f5-0e1d-47b0-a27d-2c797f2aab72", "article_code": "sample string 5", "article": { "id": "e453cd6e-ff26-421f-98a8-08528d47379f", "article_category_id": "50a55d76-347f-4b89-b22c-4fc58a330ce9", "article_category": { "id": "f9c878cf-527a-4cf4-9e19-68738a250f44", "parent_id": "a72ef135-17d2-46b5-938e-544778e0ca48", "parent_code": "sample string 3", "code": "sample string 4", "name": "sample string 5", "modified_dateutc": "2025-06-29T10:04:41.6307261+00:00" }, "article_category_code": "sample string 3", "article_group_1_id": "3e2826e1-0a12-41ec-a72d-9b9a0eead1f4", "article_group_1_code": "sample string 5", "article_group_2_id": "3c08f2b9-806c-4501-b805-ffe05390da23", "article_group_2_code": "sample string 7", "article_group_3_id": "29ed079d-c52b-483e-8e9a-a23cb6e073be", "article_group_3_code": "sample string 9", "article_group_4_id": "673d0271-5dc2-4f46-ab1b-4a6f54284e72", "article_group_4_code": "sample string 11", "article_group_5_id": "895f4244-23c3-4f8e-b593-d42f5d1eabf3", "article_group_5_code": "sample string 13", "article_group_6_id": "cbbb76ad-a5bf-431c-98ff-49e42ba81159", "article_group_6_code": "sample string 15", "physical_stock": 16, "back_order_client": 17, "back_order_supplier": 18, "expected_delivery_date_bo_supplier": "2025-06-29T10:04:41.6307261+00:00", "article_increment": 20, "min_article_quantity": 21, "entered_price": 22.0, "cost_price": 23.1, "no_stock": true, "archived": true, "is_travel_fee": true, "is_mileage_fee": true, "code": "sample string 28", "name": "sample string 29", "description_short": "sample string 30", "description_long": "sample string 31", "barcode": "sample string 32", "notes": "sample string 33", "date_create": "2025-06-29T10:04:41.6307261+00:00", "date_update": "2025-06-29T10:04:41.6307261+00:00", "modified_dateutc": "2025-06-29T10:04:41.6307261+00:00", "article_color_id": "e5e153d9-c4ff-4803-bb9a-d9d3e100ee53", "article_color_code": "sample string 38", "article_color": { "id": "cb73c143-7b81-45a2-9af0-da794ba5e96d", "name": "sample string 2", "code": "sample string 3", "modified_dateutc": "2025-06-29T10:04:41.6307261+00:00" }, "warranty_period_nb_months": 39, "use_serial": true, "_replace_id": "cd891528-0020-4710-b319-46444729ba7e", "replace_article_code": "sample string 42", "db_unit_of_measure_id_selling": "812d7db7-c5c9-4d6b-a8f6-47db30500ed4", "db_unit_of_measure_code_selling": "sample string 44", "translations": [ { "field_name": "sample string 1", "language_code": "sample string 2", "value_translated": "sample string 3" }, { "field_name": "sample string 1", "language_code": "sample string 2", "value_translated": "sample string 3" } ] }, "line_number": 6, "code": "sample string 7", "supplier_code": "sample string 8", "name": "sample string 9", "description": "sample string 10", "price": 11.0, "quantity": 12.0, "memo": "sample string 13", "cost_price": 14.0, "reference_back_office": "sample string 15", "modified_dateutc": "2025-06-29T10:04:41.6307261+00:00" }