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": "b79c2093-57b9-491e-961e-6ee7741afeaa",
"purchase_order_id": "417e5eb7-2058-4e6f-8fcd-7e8541b22601",
"purchase_order_reference_back_office": "sample string 3",
"purchase_order": {
"id": "0c4eebd8-1984-490f-96a4-556a80d32ffc",
"id2": 2,
"jobs_id": "9b742b00-f675-47a4-a397-103390dfa04d",
"jobs_reference_back_office": "sample string 4",
"supplier_company_id": "01ed1aa1-fa92-4b98-a3bc-dceec7f65125",
"supplier_company_code": "sample string 6",
"user_id": "871bbabb-aa83-4efa-88d9-e24bf9f008f8",
"user_code": "sample string 8",
"description": "sample string 9",
"memo": "sample string 10",
"total_lines": 11,
"date_create": "2024-09-29T01:23:46.5824446+00:00",
"date_update": "2024-09-29T01:23:46.5824446+00:00",
"date_delivery": "2024-09-29T01:23:46.5824446+00:00",
"confirmed_date_delivery": "2024-09-29T01:23:46.5824446+00:00",
"delivery_db_address_id": "82baada6-dd5d-408f-9a66-7f1e12a72894",
"approved_by_user_id": "3a4f4970-3ca8-4012-ab4a-dd014e3255b4",
"approved_by_user_code": "sample string 18",
"technical_user_id": "0e92ba08-c417-4397-881d-6a25bca18c9f",
"technical_user_code": "sample string 20",
"purchase_order_status_id": "49aa2184-a323-4b07-8b35-6dcd648ed105",
"purchase_order_status_code": "sample string 22",
"article_stock_location_id": "63c5602f-ec7c-48ea-92ec-8438456158d9",
"is_pickup": true,
"reference_back_office": "sample string 25",
"modified_dateutc": "2024-09-29T01:23:46.5824446+00:00"
},
"article_id": "65887318-8af1-4b6e-9e42-94c9b5e017d9",
"article_code": "sample string 5",
"article": {
"id": "00ffe658-3656-4aa3-ba47-0e29ddb2f135",
"article_category_id": "a4a49146-08da-47a4-9ec9-693a8d5d15ca",
"article_category": {
"id": "830e7828-2c99-4e24-afdb-0468056ce92b",
"parent_id": "7cf7aa79-d684-47cf-834e-5c1506e117fe",
"parent_code": "sample string 3",
"code": "sample string 4",
"name": "sample string 5",
"modified_dateutc": "2024-09-29T01:23:46.5824446+00:00"
},
"article_category_code": "sample string 3",
"article_group_1_id": "29051819-cd14-4e7b-a9eb-1996d07cb997",
"article_group_1_code": "sample string 5",
"article_group_2_id": "19316fc6-16d7-4908-a0f2-f1edcc1f4626",
"article_group_2_code": "sample string 7",
"article_group_3_id": "ff1a253e-518a-416d-ae4e-e7954a74f224",
"article_group_3_code": "sample string 9",
"article_group_4_id": "5a449cd2-b130-4429-a874-517b721d0575",
"article_group_4_code": "sample string 11",
"article_group_5_id": "06faa019-f5c0-475d-913c-c78d52289ef7",
"article_group_5_code": "sample string 13",
"article_group_6_id": "83517770-1896-4a8e-aa08-3f922f07af4f",
"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-29T01:23:46.5824446+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-29T01:23:46.5824446+00:00",
"date_update": "2024-09-29T01:23:46.5824446+00:00",
"modified_dateutc": "2024-09-29T01:23:46.5824446+00:00",
"article_color_id": "a8a6ea1d-46fc-46ad-bfc4-d588e212f8d7",
"article_color_code": "sample string 38",
"article_color": {
"id": "97e5d04a-94bd-4800-b63f-7fc84aa318bb",
"name": "sample string 2",
"code": "sample string 3",
"modified_dateutc": "2024-09-29T01:23:46.5824446+00:00"
},
"warranty_period_nb_months": 39,
"use_serial": true,
"_replace_id": "0a9c0e7a-d607-4eb0-87c7-ae8ad7de9750",
"replace_article_code": "sample string 42",
"db_unit_of_measure_id_selling": "01dd3e6d-fbe5-46b9-a60d-a1dbf094d80b",
"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-29T01:23:46.5824446+00:00"
}