SalesOrdersExploded: Exact Online Sales Orders (Exploded Structure)
read only per partition REST
- Catalog:
ExactOnlineREST - Schema:
SalesOrder - Primary Keys:
SolID - Label: Sales Orders (Exploded Structure)
The data in this table is partitioned per value of the Division column.
Can only retrieve data.
API Source
- Endpoint:
/api/v1/{division}/salesorder/SalesOrders?$expand=SalesOrderLines - 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 SalesOrdersExploded 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 | filters on the platform, writable, ::ancestor. |
||
Amount |
double |
Amount Foreign Currency | filters on the platform, writable, ::ancestor. |
||
Approval |
int16 |
Approval Status | filters on the platform, writable, ::ancestor. |
||
Approval |
varchar2 |
Approval Status Description | filters on the platform, writable, ::ancestor. |
||
Approved |
datetime |
Approved | filters on the platform, writable, ::ancestor. |
||
Approver |
guid |
Approver | filters on the platform, writable, ::ancestor. |
||
Approver |
varchar2 |
Approver Full Name | filters on the platform, writable, ::ancestor. |
||
Created |
datetime |
Created | filters on the platform, writable, ::ancestor. |
||
Creator |
guid |
Creator | filters on the platform, writable, ::ancestor. |
||
Creator |
varchar2 |
Creator Full Name | filters on the platform, writable, ::ancestor. |
||
Currency |
varchar2 |
Currency | filters on the platform, writable, ::ancestor. |
||
Deliver |
guid |
Deliver to | filters on the platform, writable, ::ancestor. |
||
Deliver |
guid |
Deliver to Contact Person | filters on the platform, writable, ::ancestor. |
||
Deliver |
varchar2 |
Deliver To Contact Person Full Name | filters on the platform, writable, ::ancestor. |
||
Deliver |
varchar2 |
Deliver to Name | filters on the platform, writable, ::ancestor. |
||
Delivery |
guid |
Delivery Address | filters on the platform, writable, ::ancestor. |
||
Delivery |
datetime |
Delivery Date | filters on the platform, writable, ::ancestor. |
||
Delivery |
int16 |
Delivery Status | filters on the platform, writable, ::ancestor. |
||
Delivery |
varchar2 |
Delivery Status Description | writable, ::ancestor. |
||
Description |
varchar2 |
Description | filters on the platform, writable, ::ancestor. |
||
Division |
int32 |
Division | filters on the platform, writable, ::ancestor. |
||
Document |
guid |
Document | filters on the platform, writable, ::ancestor. |
||
Document |
int32 |
Document Number | filters on the platform, writable, ::ancestor. |
||
Document |
varchar2 |
Document Subject | filters on the platform, writable, ::ancestor. |
||
Invoice |
int16 |
Invoice Status | filters on the platform, writable, ::ancestor. |
||
Invoice |
varchar2 |
Invoice Status Description | writable, ::ancestor. |
||
Invoice |
guid |
Invoice to | filters on the platform, writable, ::ancestor. |
||
Invoice |
guid |
Invoice to Contact Person | filters on the platform, writable, ::ancestor. |
||
Invoice |
varchar2 |
Invoice To Contact Person Full Name | filters on the platform, writable, ::ancestor. |
||
Invoice |
varchar2 |
Invoice to Name | filters on the platform, writable, ::ancestor. |
||
Modified |
datetime |
Modified | filters on the platform, writable, ::ancestor. |
||
Modifier |
guid |
Modifier | filters on the platform, writable, ::ancestor. |
||
Modifier |
varchar2 |
Modified Full Name | filters on the platform, writable, ::ancestor. |
||
Order |
datetime |
Order Date | filters on the platform, writable, ::ancestor. |
||
Order |
guid |
Order ID | filters on the platform, writable, ::ancestor. |
||
Order |
int32 |
Order Number | filters on the platform, writable, ::ancestor. |
||
Ordered |
guid |
Ordered by | filters on the platform, writable, ::ancestor. |
||
Ordered |
guid |
Ordered by Contact Person | filters on the platform, writable, ::ancestor. |
||
Ordered |
varchar2 |
Ordered by Contact Person Full Name | filters on the platform, writable, ::ancestor. |
||
Ordered |
varchar2 |
Ordered by Name | filters on the platform, writable, ::ancestor. |
||
Payment |
varchar2 |
Payment Condition | filters on the platform, writable, ::ancestor. |
||
Payment |
varchar2 |
Payment Condition Description | filters on the platform, writable, ::ancestor. |
||
Payment |
varchar2 |
Payment Reference | filters on the platform, writable, ::ancestor. |
||
Remarks |
varchar2 |
Remarks | filters on the platform, writable, ::ancestor. |
||
Salesperson |
guid |
Sales Person | filters on the platform, writable, ::ancestor. |
||
Salesperson |
varchar2 |
Sales Person Full Name | filters on the platform, writable, ::ancestor. |
||
Shipping |
guid |
Shipping Method | filters on the platform, writable, ::ancestor. |
||
Shipping |
varchar2 |
Shipping Method Description | filters on the platform, writable, ::ancestor. |
||
Sol |
double |
Sales Order Line Amount Division Currency | writable, Amount |
||
Sol |
double |
Sales Order Line Amount Foreign Currency | writable, Amount |
||
Sol |
varchar2 |
Sales Order Line Cost Centre | writable, Cost |
||
Sol |
varchar2 |
itgen_eol_solcostcenterdescription | writable, Cost |
||
Sol |
double |
Sales Order Line Cost Price Foreign Currency | writable, Cost |
||
Sol |
varchar2 |
Sales Order Line Cost Unit | writable, Cost |
||
Sol |
varchar2 |
itgen_eol_solcostunitdescription | writable, Cost |
||
Sol |
datetime |
Sales Order Line Delivery Date | writable, Delivery |
||
Sol |
varchar2 |
Sales Order Line Description | writable, Description |
||
Sol |
double |
Sales Order Line Discount | writable, Discount |
||
Sol |
int32 |
Sales Order Line Division | writable, Division |
||
SolID |
guid |
Sales Order Line ID | writable, ID |
||
Sol |
guid |
Sales Order Line Item | writable, Item |
||
Sol |
varchar2 |
Sales Order Line Item Code | writable, Item |
||
Sol |
varchar2 |
Sales Order Line Item Description | writable, Item |
||
Sol |
guid |
Sales Order Line Item Version | writable, Item |
||
Sol |
varchar2 |
itgen_eol_solitemversiondescription | writable, Item |
||
Sol |
int32 |
Sales Order Line Number | writable, Line |
||
Sol |
double |
Sales Order Line Margin | writable, Margin |
||
Sol |
double |
Sales Order Line Net Amount Foreign Currency | writable | ||
Sol |
double |
Sales Order Line Net Price | writable, Net |
||
Sol |
varchar2 |
Sales Order Line Notes | writable, Notes |
||
Sol |
int32 |
Sales Order Number | writable, Order |
||
Sol |
guid |
Sales Order Line Price List | writable, Pricelist |
||
Sol |
varchar2 |
itgen_eol_solpricelistdescription | writable, Pricelist |
||
Sol |
guid |
Sales Order Line Project | writable, Project |
||
Sol |
varchar2 |
itgen_eol_solprojectdescription | writable, Project |
||
Sol |
double |
Sales Order Line Quantity | writable, Quantity |
||
Sol |
double |
itgen_eol_solquantitydelivered | writable, Quantity |
||
Sol |
double |
Sales Order Line Quantity Invoiced | writable, Quantity |
||
Sol |
guid |
Sales Order Line Shop Order | writable, Shop |
||
Sol |
guid |
Sales Order Line Tax Schedule | writable, Tax |
||
Sol |
varchar2 |
Sales Order Line Tax Schedule Code | writable, Tax |
||
Sol |
varchar2 |
itgen_eol_soltaxscheduledescription | writable, Tax |
||
Sol |
varchar2 |
Sales Order Line Unit Code | writable, Unit |
||
Sol |
varchar2 |
Sales Order Line Unit Description | writable, Unit |
||
Sol |
double |
Sales Order Line Unit Price | writable, Unit |
||
Sol |
int16 |
Sales Order Line Use Drop Shipment | writable, Use |
||
Sol |
double |
Sales Order Line VAT Amount Foreign Currency | writable, VAT |
||
Sol |
varchar2 |
Sales Order Line VAT Code | writable, VAT |
||
Sol |
varchar2 |
itgen_eol_solvatcodedescription | writable, VAT |
||
Sol |
double |
Sales Order Line VAT Percentage | writable, VAT |
||
Status |
int16 |
Status | filters on the platform, writable, ::ancestor. |
||
Status |
varchar2 |
Status Description | writable, ::ancestor. |
||
Tax |
guid |
Tax Schedule | filters on the platform, writable, ::ancestor. |
||
Tax |
varchar2 |
Tax Schedule Code | filters on the platform, writable, ::ancestor. |
||
Tax |
varchar2 |
Tax Schedule Description | filters on the platform, writable, ::ancestor. |
||
Warehouse |
varchar2 |
Warehouse Code | filters on the platform, writable, ::ancestor. |
||
Warehouse |
varchar2 |
Warehouse Description | filters on the platform, writable, ::ancestor. |
||
Warehouse |
guid |
Warehouse ID | filters on the platform, writable, ::ancestor. |
||
Your |
varchar2 |
Your Reference | filters on the platform, writable, ::ancestor. |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: