# SalesOrders: Exact Online Sales Orders - 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. ## 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 | Documentation | |---|:---:|---|:---:|---| | `AmountDC` | `double` | Amount Division Currency | ☑ | Amount in the default currency of the company. | | `AmountDiscount` | `double` | Amount Discount | ☐ | Discount amount in the default currency of the company. | | `AmountDiscountExclVat` | `double` | Amount Discount excluding VAT | ☐ | Discount amount exclude VAT in the default currency of the company. | | `AmountFC` | `double` | Amount Foreign Currency | ☑ | Amount in the currency of the transaction. | | `AmountFCExclVat` | `double` | Amount Foreign Currency excluding VAT | ☐ | Amount exclude VAT in the currency of the transaction. | | `ApprovalStatus` | `int16` | Approval Status | ☑ | Shows if this sales order is approved. | | `ApprovalStatusDescription` | `varchar2` | | ☐ | Description of ApprovalStatus. | | `Approved` | `datetime` | Approved | ☐ | Approval datetime. | | `Approver` | `guid` | Approver | ☐ | User who approved the sales order. | | `ApproverFullName` | `varchar2`(240) | Approver Full Name | ☐ | Name of approver. | | `Created` | `datetime` | Created | ☑ | Creation date. | | `CreatedUtc` | `datetime` | Created (UTC) | ☐ | Creation date in UTC. | | `Creator` | `guid` | Creator | ☐ | User ID of creator. | | `CreatorFullName` | `varchar2`(240) | Creator Full Name | ☐ | Name of creator. | | `Currency` | `varchar2`(30) | Currency | ☐ | Currency code. | | `DeliverTo` | `guid` | Deliver to | ☐ | Reference to delivery customer. | | `DeliverToContactPerson` | `guid` | Deliver to Contact Person | ☐ | Reference to contact person of delivery customer. | | `DeliverToContactPersonFullName` | `varchar2`(240) | Deliver To Contact Person Full Name | ☐ | Name of contact person of delivery customer. | | `DeliverToName` | `varchar2` | Deliver to Name | ☐ | Name of delivery customer. | | `DeliveryAddress` | `guid` | Delivery Address | ☐ | Delivery address. | | `DeliveryDate` | `datetime` | Delivery Date | ☐ | Delivery date. | | `DeliveryStatus` | `int16` | Delivery Status | ☐ | Delivery status; 12=Open, 20=Partial, 21=Complete, 45=Canceled. | | `DeliveryStatusDescription` | `varchar2` | Delivery Status Description | ☐ | Description of DeliveryStatus. | | `Description` | `varchar2` | Description | ☐ | Description. | | `Discount` | `double` | Discount | ☐ | Discount percentage. | | `Division` | `int32` | Division | ☑ | Division code. | | `DivisionCompanyCoCNumber` | `varchar2`(60) | Division Chamber of Commerce Number | ☐ | Chamber of commerce number of the Exact Online division. | | `DivisionCompanyIBANNumber` | `varchar2`(50) | Division IBAN Number | ☐ | IBAN number of the Exact Online division. | | `DivisionCompanyName` | `varchar2`(50) | Division Company Name | ☑ | Company name of the Exact Online division. | | `DivisionCompanyRSINNumber` | `varchar2`(9) | Division RSIN Number | ☐ | RSIN number of the Exact Online division. | | `DivisionCompanyVATNumber` | `varchar2`(35) | Division VAT Number | ☐ | VAT number of the Exact Online division. | | `DivisionCompanyWageTaxNumber` | `varchar2`(60) | Division Wage Tax Number | ☐ | Wage tax number of the Exact Online division. | | `DivisionLabel` | `varchar2`(128) | Division Label | ☑ | Label of the Exact Online division. | | `DivisionName` | `varchar2`(50) | Administration Name | ☑ | Name of the Exact Online division. | | `DivisionOwnerCompanyName` | `varchar2`(50) | Subscription Holder Name | ☑ | Name of the customer account in division 1 owning the Exact Online subscription to which this division belongs. | | `DivisionOwnerCompanyNumber` | `varchar2`(18) | Subscription Holder Number | ☑ | Number of the customer account in division 1 owning the Exact Online subscription to which this division belongs. | | `DivisionShortName` | `int64` | Division Short Name | ☑ | Short name of the Exact Online division. | | `Document` | `guid` | Document | ☐ | Document that is manually linked to the sales order. | | `DocumentNumber` | `int32` | Document Number | ☐ | Number of the document. | | `DocumentSubject` | `varchar2`(256) | Document Subject | ☐ | Subject of the document. | | `IncotermAddress` | `varchar2` | Incoterm Address | ☐ | | | `IncotermCode` | `varchar2` | Incoterm Code | ☐ | | | `IncotermVersion` | `int16` | Incoterm Version | ☐ | | | `InvoiceStatus` | `int16` | Invoice Status | ☐ | Invoice status; 10=draft, 20=open, 50=processed. | | `InvoiceStatusDescription` | `varchar2` | Invoice Status Description | ☐ | Description of InvoiceStatus. | | `InvoiceTo` | `guid` | Invoice to | ☐ | Reference to the Customer who will receive the invoice. | | `InvoiceToContactPerson` | `guid` | Invoice to Contact Person | ☐ | Reference to the Contact person of the customer who will receive the invoice. | | `InvoiceToContactPersonFullName` | `varchar2`(240) | Invoice To Contact Person Full Name | ☐ | Name of the contact person of the customer who will receive the invoice. | | `InvoiceToName` | `varchar2` | Invoice to Name | ☐ | Name of the customer who will receive the invoice. | | `Modified` | `datetime` | Modified | ☑ | Last modified date. | | `ModifiedUtc` | `datetime` | Modified (UTC) | ☐ | Last modified date in UTC. | | `Modifier` | `guid` | Modifier | ☐ | User ID of modifier. | | `ModifierFullName` | `varchar2`(240) | Modified Full Name | ☐ | Name of modifier. | | `OrderDate` | `datetime` | Order Date | ☐ | Order date. | | `OrderedBy` | `guid` | Ordered by | ☐ | Customer who ordered the sales order. | | `OrderedByContactPerson` | `guid` | Ordered by Contact Person | ☐ | Contact person of the customer who ordered the sales order. | | `OrderedByContactPersonFullName` | `varchar2`(240) | Ordered by Contact Person Full Name | ☐ | Name of contact person of the customer who ordered the sales order. | | `OrderedByName` | `varchar2`(50) | Ordered by Name | ☐ | Name of the customer who ordered the sales order. | | `OrderID` | `guid` | Order ID | ☑ | Primary key. | | `OrderNumber` | `int32` | Order Number | ☑ | Number of sales order. | | `PaymentCondition` | `varchar2`(2) | Payment Condition | ☐ | The payment condition used for due date and discount calculation. | | `PaymentConditionDescription` | `varchar2`(60) | Payment Condition Description | ☐ | Description of PaymentCondition. | | `PaymentReference` | `varchar2`(60) | Payment Reference | ☐ | Payment reference for sales order. | | `Remarks` | `varchar2` | Remarks | ☐ | Extra remarks. | | `SalesChannel` | `guid` | Sales Channel | ☐ | | | `SalesChannelCode` | `varchar2` | Sales Channel Code | ☐ | | | `SalesChannelDescription` | `varchar2` | Sales Channel Description | ☐ | | | `Salesperson` | `guid` | Sales Person | ☐ | Sales representative. | | `SalespersonFullName` | `varchar2`(240) | Sales Person Full Name | ☐ | Name of sales representative. | | `SelectionCode` | `guid` | Selection Code | ☐ | ID of selection code. | | `SelectionCodeCode` | `varchar2` | Selection Code | ☐ | Code of selection code. | | `SelectionCodeDescription` | `varchar2` | | ☐ | Description of selection code. | | `ShippingMethod` | `guid` | Shipping Method | ☐ | ShippingMethod. | | `ShippingMethodDescription` | `varchar2` | Shipping Method Description | ☐ | Description of ShippingMethod. | | `Status` | `int16` | Status | ☐ | The status of the sales order. 12 = Open, 20 = Partial, 21 = Complete, 45 = Cancelled. | | `StatusDescription` | `varchar2` | Status Description | ☐ | Description of Status. | | `TaxSchedule` | `guid` | Tax Schedule | ☐ | Obsolete. | | `TaxScheduleCode` | `varchar2` | Tax Schedule Code | ☐ | Obsolete. | | `TaxScheduleDescription` | `varchar2` | Tax Schedule Description | ☐ | Obsolete. | | `WarehouseCode` | `varchar2` | Warehouse Code | ☐ | Code of Warehouse. | | `WarehouseDescription` | `varchar2` | Warehouse Description | ☐ | Description of Warehouse. | | `WarehouseID` | `guid` | Warehouse ID | ☐ | Warehouse. | | `YourRef` | `varchar2`(30) | Your Reference | ☐ | The reference number of the customer. |