Retrieves all the purchase order order lines
Request Information
URI Parameters :
None.
Body Parameters :
None.
Response Information
Resource Description :
IHttpActionResult
purchase_order_details| Name | 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
Sample:
{
"id": "da0f98d1-e4b9-4c62-b280-42b38080f990",
"purchase_order_id": "c45b5b0c-8d08-4989-b901-6d5718423a6b",
"purchase_order_reference_back_office": "sample string 3",
"purchase_order": {
"id": "672f5ae0-6962-44b5-83a7-c9fd4bc4f564",
"id2": 2,
"jobs_id": "d677993a-bda4-45d9-9718-4e8994a3a5d0",
"jobs_reference_back_office": "sample string 4",
"supplier_company_id": "e157d346-42f2-4b4b-b7ae-7bf9c00c6e57",
"supplier_company_code": "sample string 6",
"user_id": "734985b9-e9bc-4843-8763-7a1ee07302b5",
"user_code": "sample string 8",
"description": "sample string 9",
"memo": "sample string 10",
"total_lines": 11,
"date_create": "2024-09-29T05:18:53.2480926+00:00",
"date_update": "2024-09-29T05:18:53.2480926+00:00",
"date_delivery": "2024-09-29T05:18:53.2480926+00:00",
"confirmed_date_delivery": "2024-09-29T05:18:53.2480926+00:00",
"delivery_db_address_id": "6dad09d1-1bfc-4bf0-88ec-c3ed3d3fc024",
"approved_by_user_id": "ded897b7-5de5-4f10-b084-f35dd4496c1c",
"approved_by_user_code": "sample string 18",
"technical_user_id": "8a534721-de5f-47d9-81bb-a1317ce04f50",
"technical_user_code": "sample string 20",
"purchase_order_status_id": "ebd7770f-a87d-4686-8a9c-13bd5999954c",
"purchase_order_status_code": "sample string 22",
"article_stock_location_id": "715a1b73-78b1-4f1b-8035-9d74eead466a",
"is_pickup": true,
"reference_back_office": "sample string 25",
"modified_dateutc": "2024-09-29T05:18:53.2480926+00:00"
},
"article_id": "2b7f9b99-0fde-43ce-8bd8-2886458d1266",
"article_code": "sample string 5",
"article": {
"id": "d3708619-5cd7-4a70-a85e-f4f8b7d25143",
"article_category_id": "5ea09f45-7590-4337-b505-fa5e01d339c1",
"article_category": {
"id": "afd1379d-452b-464f-adea-421d7009d653",
"parent_id": "70371067-0801-45c4-92bb-224169006378",
"parent_code": "sample string 3",
"code": "sample string 4",
"name": "sample string 5",
"modified_dateutc": "2024-09-29T05:18:53.2480926+00:00"
},
"article_category_code": "sample string 3",
"article_group_1_id": "f0418717-65d8-4f26-b983-b560b66b67ab",
"article_group_1_code": "sample string 5",
"article_group_2_id": "0d960c94-3ea0-498c-858e-4ce6c7f91c67",
"article_group_2_code": "sample string 7",
"article_group_3_id": "c3b7900b-0fcc-4c41-9b5d-60e33bc74e0b",
"article_group_3_code": "sample string 9",
"article_group_4_id": "c85f306f-a80d-4bc2-b64b-83125ba8b2e8",
"article_group_4_code": "sample string 11",
"article_group_5_id": "b99e6d3c-1a62-4623-989e-1e992df8a1a3",
"article_group_5_code": "sample string 13",
"article_group_6_id": "59337e67-8976-449f-8844-881290e77166",
"article_group_6_code": "sample string 15",
"physical_stock": 16,
"back_order_client": 17,
"back_order_supplier": 18,
"expected_delivery_date_bo_supplier": "2024-09-29T05:18:53.2585434+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": "2024-09-29T05:18:53.2585434+00:00",
"date_update": "2024-09-29T05:18:53.2585434+00:00",
"modified_dateutc": "2024-09-29T05:18:53.2585434+00:00",
"article_color_id": "89a4d690-9eab-462c-8cd2-0464ba0330ee",
"article_color_code": "sample string 38",
"article_color": {
"id": "5bd279ee-f15b-40a9-82b1-a23db80e0119",
"name": "sample string 2",
"code": "sample string 3",
"modified_dateutc": "2024-09-29T05:18:53.2585434+00:00"
},
"warranty_period_nb_months": 39,
"use_serial": true,
"_replace_id": "a998f9a2-4b1c-4717-a465-62c801738b0e",
"replace_article_code": "sample string 42",
"db_unit_of_measure_id_selling": "aeb0acf4-3b52-4d80-8cd5-7023abeef240",
"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"
}
],
"udf1": "sample string 45",
"udf2": "sample string 46",
"udf3": "sample string 47",
"udf4": "sample string 48",
"udf5": "sample string 49",
"udf6": "sample string 50",
"udf7": "sample string 51",
"udf8": "sample string 52",
"udf9": "sample string 53",
"udf10": "sample string 54",
"udf11": "sample string 55",
"udf12": "sample string 56",
"udf13": "sample string 57",
"udf14": "sample string 58",
"udf15": "sample string 59",
"udf16": "sample string 60",
"udf17": "sample string 61",
"udf18": "sample string 62",
"udf19": "sample string 63",
"udf20": "sample string 64",
"udf21": "sample string 65",
"udf22": "sample string 66",
"udf23": "sample string 67",
"udf24": "sample string 68",
"udf25": "sample string 69",
"udf26": "sample string 70",
"udf27": "sample string 71",
"udf28": "sample string 72",
"udf29": "sample string 73",
"udf30": "sample string 74",
"udf31": "sample string 75",
"udf32": "sample string 76",
"udf33": "sample string 77",
"udf34": "sample string 78",
"udf35": "sample string 79",
"udf36": "sample string 80",
"udf37": "sample string 81",
"udf38": "sample string 82",
"udf39": "sample string 83",
"udf40": "sample string 84",
"udf41": "sample string 85",
"udf42": "sample string 86",
"udf43": "sample string 87",
"udf44": "sample string 88",
"udf45": "sample string 89",
"udf46": "sample string 90",
"udf47": "sample string 91",
"udf48": "sample string 92",
"udf49": "sample string 93",
"udf50": "sample string 94",
"udf51": "sample string 95",
"udf52": "sample string 96",
"udf53": "sample string 97",
"udf54": "sample string 98",
"udf55": "sample string 99",
"udf56": "sample string 100",
"udf57": "sample string 101",
"udf58": "sample string 102",
"udf59": "sample string 103",
"udf60": "sample string 104",
"udf61": "sample string 105",
"udf62": "sample string 106",
"udf63": "sample string 107",
"udf64": "sample string 108",
"udf65": "sample string 109",
"udf66": "sample string 110",
"udf67": "sample string 111",
"udf68": "sample string 112",
"udf69": "sample string 113",
"udf70": "sample string 114",
"udf71": "sample string 115",
"udf72": "sample string 116",
"udf73": "sample string 117",
"udf74": "sample string 118",
"udf75": "sample string 119",
"udf76": "sample string 120",
"udf77": "sample string 121",
"udf78": "sample string 122",
"udf79": "sample string 123",
"udf80": "sample string 124",
"udf81": "sample string 125",
"udf82": "sample string 126",
"udf83": "sample string 127",
"udf84": "sample string 128",
"udf85": "sample string 129",
"udf86": "sample string 130",
"udf87": "sample string 131",
"udf88": "sample string 132",
"udf89": "sample string 133",
"udf90": "sample string 134",
"udf91": "sample string 135",
"udf92": "sample string 136",
"udf93": "sample string 137",
"udf94": "sample string 138",
"udf95": "sample string 139",
"udf96": "sample string 140",
"udf97": "sample string 141",
"udf98": "sample string 142",
"udf99": "sample string 143",
"udf100": "sample string 144"
},
"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": "2024-09-29T05:18:53.2585434+00:00"
}