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": "f5efba2f-e233-4e51-8a1e-86916a792cbb",
"purchase_order_id": "e2f71919-5cbc-4768-86eb-f958240e7bd9",
"purchase_order_reference_back_office": "sample string 3",
"purchase_order": {
"id": "b3c218b7-f708-4faa-9361-285fb1dec4ae",
"id2": 2,
"jobs_id": "c5fb55b3-28e6-4e0e-9ec5-cb3575dda89a",
"jobs_reference_back_office": "sample string 4",
"supplier_company_id": "71020adc-9288-4ec7-804f-512d7faabd29",
"supplier_company_code": "sample string 6",
"user_id": "ebe886dd-80b7-4612-ab62-187bee36d6dd",
"user_code": "sample string 8",
"description": "sample string 9",
"memo": "sample string 10",
"total_lines": 11,
"date_create": "2025-01-18T10:43:29.6260664+00:00",
"date_update": "2025-01-18T10:43:29.6260664+00:00",
"date_delivery": "2025-01-18T10:43:29.6260664+00:00",
"confirmed_date_delivery": "2025-01-18T10:43:29.6260664+00:00",
"delivery_db_address_id": "dd861ba6-1bcf-4d29-a1fd-f85ba8940bcd",
"approved_by_user_id": "8ad83f92-ecf5-4227-938a-246056f6dc99",
"approved_by_user_code": "sample string 18",
"technical_user_id": "cd78c40c-14e7-4c8d-a35d-5199b1caa5e3",
"technical_user_code": "sample string 20",
"purchase_order_status_id": "12718bbf-89fd-4b53-b74d-1e51399e928d",
"purchase_order_status_code": "sample string 22",
"article_stock_location_id": "d84bae52-8ad6-4d26-9f91-a459b6e4231b",
"is_pickup": true,
"reference_back_office": "sample string 25",
"modified_dateutc": "2025-01-18T10:43:29.6360699+00:00"
},
"article_id": "be1578d8-8f01-4363-8ae0-1adf8d1342ba",
"article_code": "sample string 5",
"article": {
"id": "3394deda-c975-4a56-be51-1d2d877db6cf",
"article_category_id": "bc560f60-8e99-4283-be4f-1cb074ada648",
"article_category": {
"id": "1741bb29-e8d5-497e-927e-c8d44ca7a27a",
"parent_id": "0766b073-ab4c-40a3-a193-85e9e2aa4c8b",
"parent_code": "sample string 3",
"code": "sample string 4",
"name": "sample string 5",
"modified_dateutc": "2025-01-18T10:43:29.6360699+00:00"
},
"article_category_code": "sample string 3",
"article_group_1_id": "a0f2cd11-03f0-4b1a-b2d0-c3e77db4acf0",
"article_group_1_code": "sample string 5",
"article_group_2_id": "04c63bf9-ee47-4c0a-938e-089c8b788f75",
"article_group_2_code": "sample string 7",
"article_group_3_id": "bbb39afa-6ddd-49bc-b84d-f9fb3f57c56c",
"article_group_3_code": "sample string 9",
"article_group_4_id": "af9c5671-910a-4a95-b283-6409d0049869",
"article_group_4_code": "sample string 11",
"article_group_5_id": "9ba07a70-0848-49c1-9ab4-845e872a9de0",
"article_group_5_code": "sample string 13",
"article_group_6_id": "c95cee52-ef32-4c92-b0b7-ba959f7063a7",
"article_group_6_code": "sample string 15",
"physical_stock": 16,
"back_order_client": 17,
"back_order_supplier": 18,
"expected_delivery_date_bo_supplier": "2025-01-18T10:43:29.6360699+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-01-18T10:43:29.6360699+00:00",
"date_update": "2025-01-18T10:43:29.6360699+00:00",
"modified_dateutc": "2025-01-18T10:43:29.6360699+00:00",
"article_color_id": "0e8d150d-5f52-44be-baab-b15b9a59ef53",
"article_color_code": "sample string 38",
"article_color": {
"id": "0cbaf613-f210-4201-b2c3-eb904faf2ac2",
"name": "sample string 2",
"code": "sample string 3",
"modified_dateutc": "2025-01-18T10:43:29.6360699+00:00"
},
"warranty_period_nb_months": 39,
"use_serial": true,
"_replace_id": "f031afb4-0d5f-49f1-b179-9e079716d537",
"replace_article_code": "sample string 42",
"db_unit_of_measure_id_selling": "36556dc1-ffd2-4b2f-a59f-1f2798eb960a",
"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-01-18T10:43:29.6360699+00:00"
}