SalesOrders: Exact Online Sales Orders
insert update delete per partition webhook REST
- Catalog:
ExactOnlineREST - Schema:
SalesOrder - Primary Keys:
OrderID - Label: Sales Orders
The data in this table is partitioned per value of the Division column.
Can retrieve data and change data using insert, update and delete.
Changes arrive through the webhook topic SalesOrders.
API Source
- Endpoint:
/api/v1/{division}/salesorder/SalesOrders - Metadata:
/api/v1/{division}/salesorder/$metadata
Performance Characteristics
| Characteristic | Value |
|---|---|
| Average access latency (ms) | 5 |
| Full scan rows per minute | 7,200 |
| Point query rows per minute | 300 |
| Write rows per minute | 300 |
The result can be cached on the client.
Table Columns
The columns of the table SalesOrders are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.
| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
Amount |
double |
Amount Division Currency | writable | Amount in the default currency of the company. | |
Amount |
double |
Amount Discount | writable | Discount amount in the default currency of the company. | |
Amount |
double |
Amount Discount excluding VAT | writable | Discount amount exclude VAT in the default currency of the company. | |
Amount |
double |
Amount Foreign Currency | writable | Amount in the currency of the transaction. | |
Amount |
double |
Amount Foreign Currency excluding VAT | writable | Amount exclude VAT in the currency of the transaction. | |
Approval |
int16 |
Approval Status | filters on the platform, writable | Shows if this sales order is approved. | |
Approval |
varchar2 |
Approval Status Description | writable | Description of ApprovalStatus. | |
Approved |
datetime |
Approved | writable | Approval datetime. | |
Approver |
guid |
Approver | filters on the platform, writable | User who approved the sales order. | |
Approver |
varchar2 |
Approver Full Name | writable | Name of approver. | |
Created |
datetime |
Created | filters on the platform, writable | Creation date. | |
Created |
datetime |
Created (UTC) | writable | Creation date in UTC. | |
Creator |
guid |
Creator | writable | User ID of creator. | |
Creator |
varchar2 |
Creator Full Name | writable | Name of creator. | |
Currency |
varchar2 |
Currency | writable | Currency code. | |
Deliver |
guid |
Deliver to | filters on the platform, writable | Reference to delivery customer. | |
Deliver |
guid |
Deliver to Contact Person | filters on the platform, writable | Reference to contact person of delivery customer. | |
Deliver |
varchar2 |
Deliver To Contact Person Full Name | writable | Name of contact person of delivery customer. | |
Deliver |
varchar2 |
Deliver to Name | writable | Name of delivery customer. | |
Delivery |
guid |
Delivery Address | filters on the platform, writable | Delivery address. | |
Delivery |
datetime |
Delivery Date | filters on the platform, writable | Delivery date. | |
Delivery |
int16 |
Delivery Status | filters on the platform, writable | Delivery status; 12=Open, 20=Partial, 21=Complete, 45=Canceled. | |
Delivery |
varchar2 |
Delivery Status Description | writable | Description of DeliveryStatus. | |
Description |
varchar2 |
Description | filters on the platform, writable | Description. | |
Discount |
double |
Discount | writable | Discount percentage. | |
Division |
int32 |
Division | Division code. | ||
Division |
varchar2 |
Division Chamber of Commerce Number | writable | Chamber of commerce number of the Exact Online division. | |
Division |
varchar2 |
Division IBAN Number | writable | IBAN number of the Exact Online division. | |
Division |
varchar2 |
Division Company Name | writable | Company name of the Exact Online division. | |
Division |
varchar2 |
Division RSIN Number | writable | RSIN number of the Exact Online division. | |
Division |
varchar2 |
Division VAT Number | writable | VAT number of the Exact Online division. | |
Division |
varchar2 |
Division Wage Tax Number | writable | Wage tax number of the Exact Online division. | |
Division |
varchar2 |
Division Label | writable | Label of the Exact Online division. | |
Division |
varchar2 |
Administration Name | writable | Name of the Exact Online division. | |
Division |
varchar2 |
Subscription Holder Name | writable | Name of the customer account in division 1 owning the Exact Online subscription to which this division belongs. | |
Division |
varchar2 |
Subscription Holder Number | writable | Number of the customer account in division 1 owning the Exact Online subscription to which this division belongs. | |
Division |
int64 |
Division Short Name | writable | Short name of the Exact Online division. | |
Document |
guid |
Document | filters on the platform, writable | Document that is manually linked to the sales order. | |
Document |
int32 |
Document Number | writable | Number of the document. | |
Document |
varchar2 |
Document Subject | writable | Subject of the document. | |
Incoterm |
varchar2 |
Incoterm Address | filters on the platform, writable | ||
Incoterm |
varchar2 |
Incoterm Code | filters on the platform, writable | ||
Incoterm |
int16 |
Incoterm Version | filters on the platform, writable | ||
Invoice |
int16 |
Invoice Status | filters on the platform, writable | Invoice status; 10=draft, 20=open, 50=processed. | |
Invoice |
varchar2 |
Invoice Status Description | writable | Description of InvoiceStatus. | |
Invoice |
guid |
Invoice to | filters on the platform, writable | Reference to the Customer who will receive the invoice. | |
Invoice |
guid |
Invoice to Contact Person | filters on the platform, writable | Reference to the Contact person of the customer who will receive the invoice. | |
Invoice |
varchar2 |
Invoice To Contact Person Full Name | writable | Name of the contact person of the customer who will receive the invoice. | |
Invoice |
varchar2 |
Invoice to Name | writable | Name of the customer who will receive the invoice. | |
Modified |
datetime |
Modified | filters on the platform, writable | Last modified date. | |
Modified |
datetime |
Modified (UTC) | writable | Last modified date in UTC. | |
Modifier |
guid |
Modifier | writable | User ID of modifier. | |
Modifier |
varchar2 |
Modified Full Name | writable | Name of modifier. | |
Order |
datetime |
Order Date | filters on the platform, writable | Order date. | |
Order |
guid |
Order ID | filters on the platform, writable | Primary key. | |
Order |
int32 |
Order Number | filters on the platform, writable | Number of sales order. | |
Ordered |
guid |
Ordered by | filters on the platform, writable | Customer who ordered the sales order. | |
Ordered |
guid |
Ordered by Contact Person | filters on the platform, writable | Contact person of the customer who ordered the sales order. | |
Ordered |
varchar2 |
Ordered by Contact Person Full Name | writable | Name of contact person of the customer who ordered the sales order. | |
Ordered |
varchar2 |
Ordered by Name | writable | Name of the customer who ordered the sales order. | |
Payment |
varchar2 |
Payment Condition | writable | The payment condition used for due date and discount calculation. | |
Payment |
varchar2 |
Payment Condition Description | writable | Description of PaymentCondition. | |
Payment |
varchar2 |
Payment Reference | filters on the platform, writable | Payment reference for sales order. | |
Remarks |
varchar2 |
Remarks | writable | Extra remarks. | |
Sales |
guid |
Sales Channel | filters on the platform | ||
Sales |
varchar2 |
Sales Channel Code | filters on the platform | ||
Sales |
varchar2 |
Sales Channel Description | filters on the platform | ||
Salesperson |
guid |
Sales Person | filters on the platform, writable | Sales representative. | |
Salesperson |
varchar2 |
Sales Person Full Name | writable | Name of sales representative. | |
Selection |
guid |
Selection Code | filters on the platform | ID of selection code. | |
Selection |
varchar2 |
Selection Code | Code of selection code. | ||
Selection |
varchar2 |
itgen_eol_selectioncodedescription | Description of selection code. | ||
Shipping |
guid |
Shipping Method | filters on the platform, writable | ShippingMethod. | |
Shipping |
varchar2 |
Shipping Method Description | writable | Description of ShippingMethod. | |
Status |
int16 |
Status | filters on the platform, writable | The status of the sales order. 12 = Open, 20 = Partial, 21 = Complete, 45 = Cancelled. | |
Status |
varchar2 |
Status Description | writable | Description of Status. | |
Tax |
guid |
Tax Schedule | filters on the platform, writable | Obsolete. | |
Tax |
varchar2 |
Tax Schedule Code | writable | Obsolete. | |
Tax |
varchar2 |
Tax Schedule Description | writable | Obsolete. | |
Warehouse |
varchar2 |
Warehouse Code | writable | Code of Warehouse. | |
Warehouse |
varchar2 |
Warehouse Description | writable | Description of Warehouse. | |
Warehouse |
guid |
Warehouse ID | filters on the platform, writable | Warehouse. | |
Your |
varchar2 |
Your Reference | filters on the platform, writable | The reference number of the customer. |
Keys
| Key | Column | Refers to | Kind | Description |
|---|---|---|---|---|
Sales |
Approver |
Users. |
Key | |
Sales |
Creator |
Users. |
Key | |
Sales |
Currency |
Currencies.Code |
Key | |
Sales |
Deliver |
Contacts.ID |
Key | |
Sales |
Deliver |
Accounts.ID |
Key | |
Sales |
Delivery |
Addresses.ID |
Key | |
Sales |
Document |
Documents.ID |
Key | |
Sales |
Invoice |
Contacts.ID |
Key | |
Sales |
Invoice |
Accounts.ID |
Key | |
Sales |
Modifier |
Users. |
Key | |
Sales |
Ordered |
Contacts.ID |
Key | |
Sales |
Ordered |
Accounts.ID |
Key | |
Sales |
Salesperson |
Users. |
Key | |
Sales |
Selection |
SelectionCodes.ID |
Key | |
Sales |
Shipping |
ShippingMethods.ID |
Key | |
Sales |
Warehouse |
Warehouses.ID |
Key |
Referenced By
- PurchaseOrderLines
SalesOrder(Key) - PurchaseOrders
SalesOrder(Key) - SalesInvoiceLines
SalesOrder(Key) - SalesInvoiceLinesBulk
SalesOrder(Key) - SalesOrderLines
OrderID(Key) - SalesOrderLinesBulk
OrderID(Key)
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: