Retrieves all the purchase orders
Request Information
URI Parameters :
None.
Body Parameters :
None.
Response Information
Resource Description :
IHttpActionResult
purchase_order| Name | Description | Type | Additional 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
{
"id": "cac99b84-f665-40dd-9cdc-24b2faa3fdd5",
"id2": 2,
"jobs_id": "b6c45f6d-c56f-47fd-89f8-0781401d5c6d",
"jobs_reference_back_office": "sample string 4",
"supplier_company_id": "a238aa98-2f40-4743-bbdc-09287aef4138",
"supplier_company_code": "sample string 6",
"user_id": "8e859a4d-12f8-441a-a1da-a9f06be2da12",
"user_code": "sample string 8",
"description": "sample string 9",
"memo": "sample string 10",
"total_lines": 11,
"date_create": "2024-12-21T17:23:37.5640678+00:00",
"date_update": "2024-12-21T17:23:37.5640678+00:00",
"date_delivery": "2024-12-21T17:23:37.5640678+00:00",
"confirmed_date_delivery": "2024-12-21T17:23:37.5640678+00:00",
"delivery_db_address_id": "66c578c0-5656-44fd-a0b4-9ddd2157d43f",
"approved_by_user_id": "775c6638-b370-4bdd-ae68-94e740bd2025",
"approved_by_user_code": "sample string 18",
"technical_user_id": "a258552b-83c9-495c-83fd-6062820d2223",
"technical_user_code": "sample string 20",
"purchase_order_status_id": "2d73562c-b931-4b33-a6ff-72547373272f",
"purchase_order_status_code": "sample string 22",
"article_stock_location_id": "9e7f503a-c31b-4a32-a3d0-ff16bbbf99bd",
"is_pickup": true,
"reference_back_office": "sample string 25",
"modified_dateutc": "2024-12-21T17:23:37.5640678+00:00"
}