# SalesOrdersBulk: 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. This is a read-only table. 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. ## Table Columns The columns of the table `SalesOrdersBulk` are shown below. Each column has an SQL data type. | 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 excluding 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` | 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` | Creator Full Name | ☐ | Name of creator. | | `Currency` | `varchar2` | Currency | ☐ | Currency code. | | `DeliverTo` | `guid` | Deliver to | ☐ | Reference to the delivery customer. For an existing sales order this value can not be changed. | | `DeliverToContactPerson` | `guid` | Deliver to Contact Person | ☐ | Reference to contact person of delivery customer. | | `DeliverToContactPersonFullName` | `varchar2` | 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 | ☐ | Shipping status. | | `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` | Document Subject | ☐ | Subject of the document. | | `IncotermAddress` | `varchar2` | Incoterm Address | ☐ | | | `IncotermCode` | `varchar2` | Incoterm Code | ☐ | | | `IncotermVersion` | `int16` | Incoterm Version | ☐ | | | `InvoiceStatus` | `int16` | Invoice Status | ☐ | Invoice status. | | `InvoiceStatusDescription` | `varchar2` | Invoice Status Description | ☐ | Description of InvoiceStatus. | | `InvoiceTo` | `guid` | Invoice to | ☐ | Reference to the customer who will receive the invoice. For an existing sales order this value can not be changed. | | `InvoiceToContactPerson` | `guid` | Invoice to Contact Person | ☐ | Reference to the contact person of the customer who will receive the invoice. | | `InvoiceToContactPersonFullName` | `varchar2` | 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` | Modified Full Name | ☐ | Name of modifier. | | `OrderDate` | `datetime` | Order Date | ☐ | Order date. | | `OrderedBy` | `guid` | Ordered by | ☐ | Customer who ordered the sales order. For an existing sales order this value can not be changed. | | `OrderedByContactPerson` | `guid` | Ordered by Contact Person | ☐ | Contact person of the customer who ordered the sales order. | | `OrderedByContactPersonFullName` | `varchar2` | Ordered by Contact Person Full Name | ☐ | Name of contact person of the customer who ordered the sales order. | | `OrderedByName` | `varchar2` | 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` | Payment Condition | ☐ | The payment condition used for due date and discount calculation. | | `PaymentConditionDescription` | `varchar2` | Payment Condition Description | ☐ | Description of PaymentCondition. | | `PaymentReference` | `varchar2` | 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` | 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` | Your Reference | ☐ | The reference number of the customer. |