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": "78f74ac2-58f3-45c6-972d-4b78f35b58c9",
"purchase_order_id": "8d7d5e35-735c-4950-8110-962bea624c3b",
"purchase_order_reference_back_office": "sample string 3",
"purchase_order": {
"id": "335ba893-ff84-44e6-ad88-18aeaa3d6f4b",
"id2": 2,
"jobs_id": "45ad55a9-34be-4731-b615-32d3a1c4c332",
"jobs_reference_back_office": "sample string 4",
"supplier_company_id": "d8d4ed53-d379-4eb1-a0fe-d192d4444563",
"supplier_company_code": "sample string 6",
"user_id": "302e8485-836f-43ce-ac90-03655caa451f",
"user_code": "sample string 8",
"description": "sample string 9",
"memo": "sample string 10",
"total_lines": 11,
"date_create": "2025-03-09T15:02:14.751968+00:00",
"date_update": "2025-03-09T15:02:14.751968+00:00",
"date_delivery": "2025-03-09T15:02:14.751968+00:00",
"confirmed_date_delivery": "2025-03-09T15:02:14.751968+00:00",
"delivery_db_address_id": "73bc287d-9033-40d2-b426-2e8b06bf5289",
"approved_by_user_id": "88478c4a-f8f8-4795-97c6-f8259d451ebd",
"approved_by_user_code": "sample string 18",
"technical_user_id": "bed67448-9575-4f29-99df-2b5e1f32439d",
"technical_user_code": "sample string 20",
"purchase_order_status_id": "a14353ee-026c-4f2b-9aff-8e247239859c",
"purchase_order_status_code": "sample string 22",
"article_stock_location_id": "7efc90c1-6806-4049-919c-12d5eb4ba2c6",
"is_pickup": true,
"reference_back_office": "sample string 25",
"modified_dateutc": "2025-03-09T15:02:14.751968+00:00"
},
"article_id": "d65940b6-c25f-445b-9574-52751b4d5450",
"article_code": "sample string 5",
"article": {
"id": "e59f8714-551b-42d1-9c06-05091bade8a1",
"article_category_id": "1fa74846-bc00-417a-82c6-72c4b7b13eb0",
"article_category": {
"id": "8710041d-bbd5-4c4d-b08b-85f0521b43b1",
"parent_id": "2491f759-6edc-4303-8242-706d8b7a3c6a",
"parent_code": "sample string 3",
"code": "sample string 4",
"name": "sample string 5",
"modified_dateutc": "2025-03-09T15:02:14.751968+00:00"
},
"article_category_code": "sample string 3",
"article_group_1_id": "4300d016-9d33-4af7-81d2-939bb06baa88",
"article_group_1_code": "sample string 5",
"article_group_2_id": "c258673b-9463-4f73-b84d-d279dc9a3532",
"article_group_2_code": "sample string 7",
"article_group_3_id": "4ae56622-414c-44ca-89ee-76fec5a8f23c",
"article_group_3_code": "sample string 9",
"article_group_4_id": "156d5ff8-9369-4978-8f2e-88487e2f5c55",
"article_group_4_code": "sample string 11",
"article_group_5_id": "8180620f-bc56-4b2e-beaa-58e3e3161bf7",
"article_group_5_code": "sample string 13",
"article_group_6_id": "b15ac46f-6401-4468-95fe-297b31a66474",
"article_group_6_code": "sample string 15",
"physical_stock": 16,
"back_order_client": 17,
"back_order_supplier": 18,
"expected_delivery_date_bo_supplier": "2025-03-09T15:02:14.751968+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-03-09T15:02:14.751968+00:00",
"date_update": "2025-03-09T15:02:14.751968+00:00",
"modified_dateutc": "2025-03-09T15:02:14.751968+00:00",
"article_color_id": "e9afa191-3a7f-4c3d-9d97-0f2e0867bae2",
"article_color_code": "sample string 38",
"article_color": {
"id": "d2b1198a-1613-4ab4-8536-cde14f4d9ddc",
"name": "sample string 2",
"code": "sample string 3",
"modified_dateutc": "2025-03-09T15:02:14.751968+00:00"
},
"warranty_period_nb_months": 39,
"use_serial": true,
"_replace_id": "cabef38b-420c-424e-a4e9-f546abff7cf2",
"replace_article_code": "sample string 42",
"db_unit_of_measure_id_selling": "cc169e1a-a876-4f31-a7b3-f5ac4708a6ab",
"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": "2025-03-09T15:02:14.7721069+00:00"
}