# 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 | | |