Retrieves all the purchase orders
Request Information
URI Parameters :
None.
Body Parameters :
None.
Response Information
Resource Description :
IHttpActionResult
purchase_orderName | 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": "c3899026-1a36-43c6-adfa-b7b51bdc9ef9", "id2": 2, "jobs_id": "cafd4a59-0e0c-41c5-bd40-77b6bbe1af56", "jobs_reference_back_office": "sample string 4", "supplier_company_id": "d049c448-ee93-4c77-8229-9169bce09a14", "supplier_company_code": "sample string 6", "user_id": "bad944a6-78d9-443f-adc0-88d0ee289305", "user_code": "sample string 8", "description": "sample string 9", "memo": "sample string 10", "total_lines": 11, "date_create": "2025-01-18T05:06:19.0091211+00:00", "date_update": "2025-01-18T05:06:19.0091211+00:00", "date_delivery": "2025-01-18T05:06:19.0091211+00:00", "confirmed_date_delivery": "2025-01-18T05:06:19.0091211+00:00", "delivery_db_address_id": "949cc5f0-ea41-43d4-b5be-cf6c6a560c12", "approved_by_user_id": "a13ca695-f724-4e3c-bb2f-edc32202bae9", "approved_by_user_code": "sample string 18", "technical_user_id": "7ef57950-4cfe-4ece-85aa-715bff876a6b", "technical_user_code": "sample string 20", "purchase_order_status_id": "2e4ded5b-36e2-4ed9-a2f2-63ff82d6ba6c", "purchase_order_status_code": "sample string 22", "article_stock_location_id": "7e58f357-9c52-4482-af20-fb0a4b9070bf", "is_pickup": true, "reference_back_office": "sample string 25", "modified_dateutc": "2025-01-18T05:06:19.0091211+00:00" }