# Profit_Salesorders: Sales Orders ## Documentation Profit_Salesorders - Name: `Profit_Salesorders` - Catalog: `AfasOnline` - Schema: `GetConnector` - Label: Sales Orders - Partition-specific: false - Select: true - Insert: false - Update: false - Delete: false - Select Service URL (OData-specific): `/connectors/Profit_Salesorders` - Insert Service URL (OData-specific): `/connectors/Profit_Salesorders` - Update Service URL (OData-specific): `/connectors/Profit_Salesorders` - Delete Service URL (OData-specific): `/connectors/Profit_Salesorders` - Field Selection Method (OData-specific): NotRequired ## Table Columns The columns of the table `Profit_Salesorders` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `CurrencyId` | `string(3)` | Currency | | | | `CustomerReference` | `string(100)` | Assignment number/reference | | | | `DebtorId` | `string(16)` | Sales relation | | | | `Discount` | `decimal` | Invoice discount | | | | `Gross` | `decimal` | Gross amount | | | | `InvoiceTotal` | `decimal` | Invoice total | | | | `OrderDate` | `datetime` | Date | | | | `OrderNumber` | `string(12)` | Order number | | | | `Ordersoort` | `string(10)` | Order type | | | | `Quantity` | `decimal` | Total quantity | | | | `Status` | `string(100)` | Status | | | | `TotalAmount` | `decimal` | Total amount | | | | `VAT` | `decimal` | VAT amount | | |