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": "20f68ec7-09ca-4279-8131-a20b65f7cae3",
"purchase_order_id": "a4092520-8412-475e-99ec-8ab6d3c47666",
"purchase_order_reference_back_office": "sample string 3",
"purchase_order": {
"id": "c503dc3d-a831-406c-a912-5d3107b360e4",
"id2": 2,
"jobs_id": "69b3b792-3c45-44c9-81ec-59dd41fde697",
"jobs_reference_back_office": "sample string 4",
"supplier_company_id": "9b17829a-5bfd-47ff-a0de-67cb6b2e788f",
"supplier_company_code": "sample string 6",
"user_id": "26283335-8662-480c-8229-256251ec2454",
"user_code": "sample string 8",
"description": "sample string 9",
"memo": "sample string 10",
"total_lines": 11,
"date_create": "2025-01-18T05:00:46.409029+00:00",
"date_update": "2025-01-18T05:00:46.409029+00:00",
"date_delivery": "2025-01-18T05:00:46.409029+00:00",
"confirmed_date_delivery": "2025-01-18T05:00:46.409029+00:00",
"delivery_db_address_id": "5ba1770c-954c-4af9-9d59-6841318e8d21",
"approved_by_user_id": "6a449930-654c-4d84-9c1b-1e7e2c27ae0d",
"approved_by_user_code": "sample string 18",
"technical_user_id": "c2d2bab0-1b1e-44cd-bd43-1031100a6eee",
"technical_user_code": "sample string 20",
"purchase_order_status_id": "1c8860b7-c35c-47dd-abf2-189c2316d9fc",
"purchase_order_status_code": "sample string 22",
"article_stock_location_id": "052b802e-b999-4262-8d76-ebb6fc17db78",
"is_pickup": true,
"reference_back_office": "sample string 25",
"modified_dateutc": "2025-01-18T05:00:46.409029+00:00"
},
"article_id": "392492cd-5fca-46ca-a770-2ce50ad76aaf",
"article_code": "sample string 5",
"article": {
"id": "014c30d4-3ac5-4099-8c75-51f7f02a1527",
"article_category_id": "d693da3f-96b7-414c-a15b-3f8a6941534d",
"article_category": {
"id": "4ae7e7ad-427a-4c38-ac53-46cf0acb09fa",
"parent_id": "1dfbf61c-1f98-40c2-9a8f-72ab97f2b2b9",
"parent_code": "sample string 3",
"code": "sample string 4",
"name": "sample string 5",
"modified_dateutc": "2025-01-18T05:00:46.409029+00:00"
},
"article_category_code": "sample string 3",
"article_group_1_id": "9b302df8-cfd1-4bdb-a7c9-8ce201ff178d",
"article_group_1_code": "sample string 5",
"article_group_2_id": "3adb11d8-18c2-4676-8529-ee7e45e61f3d",
"article_group_2_code": "sample string 7",
"article_group_3_id": "f7809af4-3711-4690-812c-c3fcd58f1503",
"article_group_3_code": "sample string 9",
"article_group_4_id": "ea3c60c5-7679-4a10-87c9-230ddfed313d",
"article_group_4_code": "sample string 11",
"article_group_5_id": "5e426179-5e97-4be7-8396-ac389ae9fc50",
"article_group_5_code": "sample string 13",
"article_group_6_id": "628b7667-b1c5-403a-b3e0-6b6ac7f49b8e",
"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-18T05:00:46.409029+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-18T05:00:46.409029+00:00",
"date_update": "2025-01-18T05:00:46.409029+00:00",
"modified_dateutc": "2025-01-18T05:00:46.409029+00:00",
"article_color_id": "8bb4e2ec-c7a5-45f9-83dc-11726a1e3de6",
"article_color_code": "sample string 38",
"article_color": {
"id": "46b30390-4067-4222-8881-9e7a9be65e7f",
"name": "sample string 2",
"code": "sample string 3",
"modified_dateutc": "2025-01-18T05:00:46.409029+00:00"
},
"warranty_period_nb_months": 39,
"use_serial": true,
"_replace_id": "8ecb791b-237d-43d6-b569-131b45ce1978",
"replace_article_code": "sample string 42",
"db_unit_of_measure_id_selling": "1041c24a-5fbb-41e7-a987-2222085810a7",
"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-18T05:00:46.409029+00:00"
}