# Profit_Salesorders: Sales Orders ## Documentation Profit_Salesorders - Name: `Profit_Salesorders` - Catalog: `AfasOnline` - Schema: `AfasOnline` - Label: Sales Orders ## 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` | Currency | | | | `CustomerReference` | `string` | Assignment number/reference | | | | `DebtorId` | `string` | Sales relation | | | | `Discount` | `decimal` | Invoice discount | | | | `Gross` | `decimal` | Gross amount | | | | `InvoiceTotal` | `decimal` | Invoice total | | | | `OrderDate` | `datetime` | Date | | | | `OrderNumber` | `string` | Order number | | | | `Ordersoort` | `string` | Order type | | | | `Quantity` | `decimal` | Total quantity | | | | `Status` | `string` | Status | | | | `TotalAmount` | `decimal` | Total amount | | | | `VAT` | `decimal` | VAT amount | | |