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": "ea5d6e07-34c4-4302-a598-46e983db4688", "purchase_order_id": "397a29ac-de98-430b-aa71-d32e5864b9fe", "purchase_order_reference_back_office": "sample string 3", "purchase_order": { "id": "83697925-e65c-437a-9c53-dbf5c6a38ca6", "id2": 2, "jobs_id": "9383cbc5-6b54-42a5-8edb-97ea1235ccec", "jobs_reference_back_office": "sample string 4", "supplier_company_id": "1905d369-cd23-47df-9ef3-549f6a5621c2", "supplier_company_code": "sample string 6", "user_id": "73f58ea4-29fc-4d0e-850e-0542b2068f7f", "user_code": "sample string 8", "description": "sample string 9", "memo": "sample string 10", "total_lines": 11, "date_create": "2025-05-18T01:21:14.8204388+00:00", "date_update": "2025-05-18T01:21:14.8204388+00:00", "date_delivery": "2025-05-18T01:21:14.8204388+00:00", "confirmed_date_delivery": "2025-05-18T01:21:14.8204388+00:00", "delivery_db_address_id": "bd24dcec-c5d6-45c8-9d02-4138d7cf795c", "approved_by_user_id": "017cbbe9-0be0-4bd3-b8fc-62463d7c2f75", "approved_by_user_code": "sample string 18", "technical_user_id": "2c7d3173-2f3e-4504-8e02-39d17cc2706d", "technical_user_code": "sample string 20", "purchase_order_status_id": "999a587b-13eb-483c-a12b-6e1c68f85b83", "purchase_order_status_code": "sample string 22", "article_stock_location_id": "3dff774b-8e4f-496b-94c0-ccf5cc1421d4", "is_pickup": true, "reference_back_office": "sample string 25", "modified_dateutc": "2025-05-18T01:21:14.8204388+00:00" }, "article_id": "10e9b9ee-d2f2-4c8d-9f71-0c05b4df83b1", "article_code": "sample string 5", "article": { "id": "368078ef-372c-4867-85e2-afd0a1359db6", "article_category_id": "fc4937fe-6856-4e28-a86f-044ece6dd087", "article_category": { "id": "ed4372d6-cd11-481e-aa8f-41c2bf6d03b4", "parent_id": "3757ad6e-3758-421d-909e-bc6934ccb22c", "parent_code": "sample string 3", "code": "sample string 4", "name": "sample string 5", "modified_dateutc": "2025-05-18T01:21:14.8204388+00:00" }, "article_category_code": "sample string 3", "article_group_1_id": "3dedbcb2-f6c3-47a2-bd2e-07b8974bc17f", "article_group_1_code": "sample string 5", "article_group_2_id": "92d35be5-a7b2-4c8e-b92a-7a81afa5e1cc", "article_group_2_code": "sample string 7", "article_group_3_id": "a6bf6ec3-0b56-4d51-b56d-88195a92ed04", "article_group_3_code": "sample string 9", "article_group_4_id": "60cf1ed1-a4f0-41bc-bf89-6f3d0681838a", "article_group_4_code": "sample string 11", "article_group_5_id": "f74bb5be-9ff3-49b3-9316-1f67f449b0d5", "article_group_5_code": "sample string 13", "article_group_6_id": "a1a19de0-3215-4f39-a09c-c76b1dfff6c8", "article_group_6_code": "sample string 15", "physical_stock": 16, "back_order_client": 17, "back_order_supplier": 18, "expected_delivery_date_bo_supplier": "2025-05-18T01:21:14.8204388+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-05-18T01:21:14.8204388+00:00", "date_update": "2025-05-18T01:21:14.8204388+00:00", "modified_dateutc": "2025-05-18T01:21:14.8204388+00:00", "article_color_id": "bbc8befe-2f06-4ac6-943d-82cd29a8c5c8", "article_color_code": "sample string 38", "article_color": { "id": "6ed27856-3ab1-461f-9c6e-dc7720dd32a1", "name": "sample string 2", "code": "sample string 3", "modified_dateutc": "2025-05-18T01:21:14.8204388+00:00" }, "warranty_period_nb_months": 39, "use_serial": true, "_replace_id": "624ff1d9-5715-40c5-8afe-10ba18c4a43e", "replace_article_code": "sample string 42", "db_unit_of_measure_id_selling": "f0c670e0-d526-4436-b263-2bf26a6db77a", "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-05-18T01:21:14.8204388+00:00" }