# SalesOrdersExploded: Exact Online Sales Orders (Exploded Structure) - 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. This is a read-only view. The Exact Online API may not support changing the data or the Invantive UniversalSQL driver for Exact Online does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Exact Online API. ## View Columns The columns of the view `SalesOrdersExploded` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `AmountDC` | `double` | Amount Division Currency | ☐ | | | `AmountFC` | `double` | Amount Foreign Currency | ☐ | | | `ApprovalStatus` | `int16` | Approval Status | ☐ | | | `ApprovalStatusDescription` | `varchar2` | | ☐ | | | `Approved` | `datetime` | Approved | ☐ | | | `Approver` | `guid` | Approver | ☐ | | | `ApproverFullName` | `varchar2` | Approver Full Name | ☐ | | | `Created` | `datetime` | Created | ☐ | | | `Creator` | `guid` | Creator | ☐ | | | `CreatorFullName` | `varchar2` | Creator Full Name | ☐ | | | `Currency` | `varchar2` | Currency | ☐ | | | `DeliverTo` | `guid` | Deliver to | ☐ | | | `DeliverToContactPerson` | `guid` | Deliver to Contact Person | ☐ | | | `DeliverToContactPersonFullName` | `varchar2` | Deliver To Contact Person Full Name | ☐ | | | `DeliverToName` | `varchar2` | Deliver to Name | ☐ | | | `DeliveryAddress` | `guid` | Delivery Address | ☐ | | | `DeliveryDate` | `datetime` | Delivery Date | ☐ | | | `DeliveryStatus` | `int16` | Delivery Status | ☐ | | | `DeliveryStatusDescription` | `varchar2` | Delivery Status Description | ☐ | | | `Description` | `varchar2` | Description | ☐ | | | `Division` | `int32` | Division | ☐ | | | `Document` | `guid` | Document | ☐ | | | `DocumentNumber` | `int32` | Document Number | ☐ | | | `DocumentSubject` | `varchar2` | Document Subject | ☐ | | | `InvoiceStatus` | `int16` | Invoice Status | ☐ | | | `InvoiceStatusDescription` | `varchar2` | Invoice Status Description | ☐ | | | `InvoiceTo` | `guid` | Invoice to | ☐ | | | `InvoiceToContactPerson` | `guid` | Invoice to Contact Person | ☐ | | | `InvoiceToContactPersonFullName` | `varchar2` | Invoice To Contact Person Full Name | ☐ | | | `InvoiceToName` | `varchar2` | Invoice to Name | ☐ | | | `Modified` | `datetime` | Modified | ☐ | | | `Modifier` | `guid` | Modifier | ☐ | | | `ModifierFullName` | `varchar2` | Modified Full Name | ☐ | | | `OrderDate` | `datetime` | Order Date | ☐ | | | `OrderedBy` | `guid` | Ordered by | ☐ | | | `OrderedByContactPerson` | `guid` | Ordered by Contact Person | ☐ | | | `OrderedByContactPersonFullName` | `varchar2` | Ordered by Contact Person Full Name | ☐ | | | `OrderedByName` | `varchar2` | Ordered by Name | ☐ | | | `OrderID` | `guid` | Order ID | ☑ | | | `OrderNumber` | `int32` | Order Number | ☐ | | | `PaymentCondition` | `varchar2` | Payment Condition | ☐ | | | `PaymentConditionDescription` | `varchar2` | Payment Condition Description | ☐ | | | `PaymentReference` | `varchar2` | Payment Reference | ☐ | | | `Remarks` | `varchar2` | Remarks | ☐ | | | `Salesperson` | `guid` | Sales Person | ☐ | | | `SalespersonFullName` | `varchar2` | Sales Person Full Name | ☐ | | | `ShippingMethod` | `guid` | Shipping Method | ☐ | | | `ShippingMethodDescription` | `varchar2` | Shipping Method Description | ☐ | | | `SolAmountDC` | `double` | Sales Order Line Amount Division Currency | ☐ | | | `SolAmountFC` | `double` | Sales Order Line Amount Foreign Currency | ☐ | | | `SolCostCenter` | `varchar2` | Sales Order Line Cost Centre | ☐ | | | `SolCostCenterDescription` | `varchar2` | | ☐ | | | `SolCostPriceFC` | `double` | Sales Order Line Cost Price Foreign Currency | ☐ | | | `SolCostUnit` | `varchar2` | Sales Order Line Cost Unit | ☐ | | | `SolCostUnitDescription` | `varchar2` | | ☐ | | | `SolDeliveryDate` | `datetime` | Sales Order Line Delivery Date | ☐ | | | `SolDescription` | `varchar2` | Sales Order Line Description | ☐ | | | `SolDiscount` | `double` | Sales Order Line Discount | ☐ | | | `SolDivision` | `int32` | Sales Order Line Division | ☐ | | | `SolID` | `guid` | Sales Order Line ID | ☑ | | | `SolItem` | `guid` | Sales Order Line Item | ☐ | | | `SolItemCode` | `varchar2` | Sales Order Line Item Code | ☐ | | | `SolItemDescription` | `varchar2` | Sales Order Line Item Description | ☐ | | | `SolItemVersion` | `guid` | Sales Order Line Item Version | ☐ | | | `SolItemVersionDescription` | `varchar2` | | ☐ | | | `SolLineNumber` | `int32` | Sales Order Line Number | ☐ | | | `SolMargin` | `double` | Sales Order Line Margin | ☐ | | | `SolNetAmountFC` | `double` | Sales Order Line Net Amount Foreign Currency | ☐ | | | `SolNetPrice` | `double` | Sales Order Line Net Price | ☐ | | | `SolNotes` | `varchar2` | Sales Order Line Notes | ☐ | | | `SolOrderNumber` | `int32` | Sales Order Number | ☐ | | | `SolPricelist` | `guid` | Sales Order Line Price List | ☐ | | | `SolPricelistDescription` | `varchar2` | | ☐ | | | `SolProject` | `guid` | Sales Order Line Project | ☐ | | | `SolProjectDescription` | `varchar2` | | ☐ | | | `SolQuantity` | `double` | Sales Order Line Quantity | ☐ | | | `SolQuantityDelivered` | `double` | | ☐ | | | `SolQuantityInvoiced` | `double` | Sales Order Line Quantity Invoiced | ☐ | | | `SolShopOrder` | `guid` | Sales Order Line Shop Order | ☐ | | | `SolTaxSchedule` | `guid` | Sales Order Line Tax Schedule | ☐ | | | `SolTaxScheduleCode` | `varchar2` | Sales Order Line Tax Schedule Code | ☐ | | | `SolTaxScheduleDescription` | `varchar2` | | ☐ | | | `SolUnitCode` | `varchar2` | Sales Order Line Unit Code | ☐ | | | `SolUnitDescription` | `varchar2` | Sales Order Line Unit Description | ☐ | | | `SolUnitPrice` | `double` | Sales Order Line Unit Price | ☐ | | | `SolUseDropShipment` | `int16` | Sales Order Line Use Drop Shipment | ☑ | | | `SolVATAmountFC` | `double` | Sales Order Line VAT Amount Foreign Currency | ☐ | | | `SolVATCode` | `varchar2` | Sales Order Line VAT Code | ☐ | | | `SolVATCodeDescription` | `varchar2` | | ☐ | | | `SolVATPercentage` | `double` | Sales Order Line VAT Percentage | ☐ | | | `Status` | `int16` | Status | ☐ | | | `StatusDescription` | `varchar2` | Status Description | ☐ | | | `TaxSchedule` | `guid` | Tax Schedule | ☐ | | | `TaxScheduleCode` | `varchar2` | Tax Schedule Code | ☐ | | | `TaxScheduleDescription` | `varchar2` | Tax Schedule Description | ☐ | | | `WarehouseCode` | `varchar2` | Warehouse Code | ☐ | | | `WarehouseDescription` | `varchar2` | Warehouse Description | ☐ | | | `WarehouseID` | `guid` | Warehouse ID | ☐ | | | `YourRef` | `varchar2` | Your Reference | ☐ | |