| 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 |
| supplier_company_id |
Foreign key to company, contains the supplier |
globally unique identifier | |
| supplier_contact_id |
Foreign key of the contact at the supplier company to reach about this purchase order. |
globally unique identifier | |
| user_id |
Creator of the purchase order |
globally unique identifier | |
| 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 | |
| reference |
Free-text reference for this purchase order (e.g. the supplier's order confirmation number). |
string | |
| 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 | |
| technical_user_id |
User to contact if case of technical question about the purchase order |
globally unique identifier | |
| sent_by_email |
Indicates this purchase order has been sent to the supplier by email. |
boolean | |
| sent_by_xml |
Indicates this purchase order has been sent to the supplier via XML/EDI integration. |
boolean | |
| 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 |
| po_status |
Display text of the purchase order status (denormalized copy of the status referenced by ). |
string | |
| article_stock_location_id |
Stock location that will receive the articles |
globally unique identifier | |
| webshop_reference |
Reference/order number from the supplier's webshop, when the purchase order was placed through one. |
string | |
| 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 |