# Rptrelationscustomerturnoverresult - Catalog: `ionBIZ` - Retrieve: true ## Table Columns The columns of the table `Rptrelationscustomerturnoverresult` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `ActualCosts` | `decimal` | Actual Costs | ☐ | | | `ActualHours` | `int64` | Actual Hours | ☐ | | | `ActualSales` | `decimal` | Actual Sales | ☐ | | | `AveragePaymentPeriod` | `int32` | Average Payment Period | ☐ | | | `Customer` | `string` | Customer | ☐ | | | `CustomerCustomerId` | `string` | Customer Customer ID | ☐ | | | `Department` | `string` | Department | ☐ | | | `HoldingName` | `string` | Holding Name | ☐ | | | `Id` | `int32` | ID | ☑ | | | `InvoicedVATexcl` | `decimal` | Invoiced VAT Excl. | ☐ | | | `InvoicedVATincl` | `decimal` | Invoiced VAT Incl. | ☐ | | | `OpenCredit` | `decimal` | Open Credit | ☐ | | | `OpenCreditLimit` | `decimal` | Open Credit Limit | ☐ | | | `OpenSaldo` | `decimal` | Open Balance | ☐ | | | `Overdue` | `decimal` | Overdue | ☐ | | | `Paid` | `decimal` | Paid | ☐ | | | `Profit` | `decimal` | Profit | ☐ | | | `TotalAmountToInvoice` | `decimal` | Total Amount to Invoice | ☐ | | | `WeightedPaymentPeriod` | `int32` | Weighted Payment Period | ☐ | |