Retrieves all the purchase order order lines

Request Information

URI Parameters :

None.

Body Parameters :

None.

Response Information

Resource Description :

IHttpActionResult

purchase_order_details
NameDescriptionTypeAdditional 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": "40c3d8c7-c97b-4290-a0e3-495e7efbe2ba",
  "purchase_order_id": "bd77ac3c-2361-4909-8248-2e97ace87376",
  "purchase_order_reference_back_office": "sample string 3",
  "purchase_order": {
    "id": "74e3ca1a-f26a-474b-9992-eec41cc1e93e",
    "id2": 2,
    "jobs_id": "a467d6e3-3f66-411a-ae06-cb5d5ad28c9d",
    "jobs_reference_back_office": "sample string 4",
    "supplier_company_id": "bae74c1b-904f-49ba-be0b-eac0fa8cee68",
    "supplier_company_code": "sample string 6",
    "user_id": "2398a38b-fdc0-4b0f-8969-1b1dc7980cb7",
    "user_code": "sample string 8",
    "description": "sample string 9",
    "memo": "sample string 10",
    "total_lines": 11,
    "date_create": "2025-01-22T01:20:23.1530246+00:00",
    "date_update": "2025-01-22T01:20:23.1530246+00:00",
    "date_delivery": "2025-01-22T01:20:23.1530246+00:00",
    "confirmed_date_delivery": "2025-01-22T01:20:23.1530246+00:00",
    "delivery_db_address_id": "7e29b3c4-b68d-4086-8ebc-185fa887a419",
    "approved_by_user_id": "5476a36f-eecf-469d-a7f0-6a64b234e21b",
    "approved_by_user_code": "sample string 18",
    "technical_user_id": "7a33f940-fa14-4f1e-84dc-f3cd1eca8c8b",
    "technical_user_code": "sample string 20",
    "purchase_order_status_id": "5fc36322-ebc9-4a0b-bfed-572b50791464",
    "purchase_order_status_code": "sample string 22",
    "article_stock_location_id": "1432b78f-c93e-4c18-af5a-f66c101f3a7b",
    "is_pickup": true,
    "reference_back_office": "sample string 25",
    "modified_dateutc": "2025-01-22T01:20:23.1530246+00:00"
  },
  "article_id": "f775d5ce-5b4f-449a-8ab2-331de4903049",
  "article_code": "sample string 5",
  "article": {
    "id": "c9c35ae4-050b-4276-9ee2-0225b5c2def5",
    "article_category_id": "ff173245-236a-4623-8a1e-ee7d740ab416",
    "article_category": {
      "id": "066d257d-09d9-408b-9e5c-c10ff0ccfb65",
      "parent_id": "ed99eec7-ee61-491d-ab49-e760d49334cc",
      "parent_code": "sample string 3",
      "code": "sample string 4",
      "name": "sample string 5",
      "modified_dateutc": "2025-01-22T01:20:23.1530246+00:00"
    },
    "article_category_code": "sample string 3",
    "article_group_1_id": "3709a632-11fd-4876-80e0-fa5267e070f2",
    "article_group_1_code": "sample string 5",
    "article_group_2_id": "8bf2c940-e297-413d-868f-c0b06d8ca9f1",
    "article_group_2_code": "sample string 7",
    "article_group_3_id": "4b30d274-dee9-430a-ad3b-546e8a6b1474",
    "article_group_3_code": "sample string 9",
    "article_group_4_id": "bfb7f88c-feee-4153-85d5-d1e97448c161",
    "article_group_4_code": "sample string 11",
    "article_group_5_id": "f7b42480-ed2c-4419-a5a1-34a238f30ccd",
    "article_group_5_code": "sample string 13",
    "article_group_6_id": "ed0bb81e-d82e-434d-8c20-368d538310f6",
    "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-22T01:20:23.1530246+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-22T01:20:23.1530246+00:00",
    "date_update": "2025-01-22T01:20:23.1530246+00:00",
    "modified_dateutc": "2025-01-22T01:20:23.1530246+00:00",
    "article_color_id": "68c9102a-a1fa-496d-adb7-0d18d0fc42b5",
    "article_color_code": "sample string 38",
    "article_color": {
      "id": "c7945a2a-f006-4528-ac5c-a79ece8f7490",
      "name": "sample string 2",
      "code": "sample string 3",
      "modified_dateutc": "2025-01-22T01:20:23.1530246+00:00"
    },
    "warranty_period_nb_months": 39,
    "use_serial": true,
    "_replace_id": "26bf5df7-e6a7-4dfa-bc12-ed8a313c2f1b",
    "replace_article_code": "sample string 42",
    "db_unit_of_measure_id_selling": "965abd3d-2a40-4604-ba24-20f6cf09b302",
    "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"
      }
    ]
  },
  "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-22T01:20:23.1530246+00:00"
}