Retrieves all the purchase orders

Request Information

URI Parameters :

None.

Body Parameters :

None.

Response Information

Resource Description :

IHttpActionResult

purchase_order
NameDescriptionTypeAdditional information
id

Primary Key

globally unique identifier
id2

Internal ID (numeric) automatically filled if empty

integer
jobs_id

Foreign key to Jobs

globally unique identifier

Optionally required : jobs_id, jobs_reference_back_office or jobs must be provided

jobs_reference_back_office

Embedded entity "jobs" using ERP PK when adding/updating

string

Optionally required : jobs_id, jobs_reference_back_office or jobs must be provided

jobs

Embedded entity "jobs" using ERP PK when adding/updating

jobs

Optionally required : jobs_id, jobs_reference_back_office or jobs must be provided

supplier_company_id

Foreign key to company, contains the supplier

globally unique identifier
supplier_company_code

Embedded entity "company" for the supplier using ERP PK when adding/updating

string
supplier_company

Embedded entity "company" for supplier using ERP PK when adding/updating

company
user_id

Creator of the purchase order

globally unique identifier
user_code

Embedded entity "user" for creator using ERP PK when adding/updating purchase_order

string
user

Embedded entity "user" for creator using node when adding/updating purchase_order

user
description

Description of the purchase order

string

Max length: 4000

memo

Memo, remark

string
total_lines

Number of lines, automatically filled when adding/updating/deleting lines

integer
date_create

Creation date

date
date_update

Last update date

date
date_delivery

Estimated date of delivery

date
confirmed_date_delivery

Date of the delivery

date
delivery_db_address_id

If Delivery and no picking, AddressID of the company (if not the main)

globally unique identifier
approved_by_user_id

If approval was needed, which user approves it

globally unique identifier
approved_by_user_code

Embedded entity "user" for approver using ERP PK when adding/updating purchase_order

string
approved_by_user

Embedded entity "user" for approver using node when adding/updating purchase_order

user
technical_user_id

User to contact if case of technical question about the purchase order

globally unique identifier
technical_user_code

Embedded entity "user" for technical user using ERP PK when adding/updating purchase_order

string
technical_user

Embedded entity "user" for technical user using node when adding/updating purchase_order

user
purchase_order_status_id

Foreign key to purchase_order_status

globally unique identifier

Optionally required : purchase_order_status_id or purchase_order_status_code must be provided

purchase_order_status_code

Foreign key to purchase_order_status using code. Use "Approved","SentToSupplier","Cancelled" or "Delivered"

string

Optionally required : purchase_order_status_id or purchase_order_status_code must be provided

article_stock_location_id

Stock location that will receive the articles

globally unique identifier
is_pickup

If pickup, the technician will go himself to the supplier to take the goods

boolean
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": "46949a40-53ef-45af-966e-fc1a12ba3b08",
  "id2": 2,
  "jobs_id": "3143d1f3-acf4-4366-b438-fcc4524b42a3",
  "jobs_reference_back_office": "sample string 4",
  "supplier_company_id": "683dce5c-3712-42bb-9837-c31fca76a26c",
  "supplier_company_code": "sample string 6",
  "user_id": "44649ff9-0c10-44bf-affc-d7128dcb9277",
  "user_code": "sample string 8",
  "description": "sample string 9",
  "memo": "sample string 10",
  "total_lines": 11,
  "date_create": "2023-03-29T03:20:50.0866429+00:00",
  "date_update": "2023-03-29T03:20:50.0866429+00:00",
  "date_delivery": "2023-03-29T03:20:50.0866429+00:00",
  "confirmed_date_delivery": "2023-03-29T03:20:50.0866429+00:00",
  "delivery_db_address_id": "d0f4d503-abfb-4eaf-9e70-fca666f9f1d6",
  "approved_by_user_id": "c5b2f9ec-89fe-4c27-b51a-8b04c154e0d2",
  "approved_by_user_code": "sample string 18",
  "technical_user_id": "c76eedf0-622e-4675-9966-254f67499ddf",
  "technical_user_code": "sample string 20",
  "purchase_order_status_id": "6ecd1299-93f5-4daa-ba1f-b116fb11eddd",
  "purchase_order_status_code": "sample string 22",
  "article_stock_location_id": "79e393b0-eb36-4727-abe6-786d249595fe",
  "is_pickup": true,
  "reference_back_office": "sample string 25",
  "modified_dateutc": "2023-03-29T03:20:50.0866429+00:00"
}