# Profit_Debtor_Invoices: Debtor Invoices ## Documentation Profit_Debtor_Invoices - Name: `Profit_Debtor_Invoices` - Catalog: `AfasOnline` - Schema: `AfasOnline` - Label: Debtor Invoices ## Table Columns The columns of the table `Profit_Debtor_Invoices` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `AmtInvoice` | `decimal` | Total invoice amount | | | | `AmtInvoiceCurr` | `decimal` | Total invoice amount in currency | | | | `Balance` | `decimal` | Balance | | | | `BalanceCurr` | `decimal` | Balance (currency) | | | | `CurrencyId` | `string` | Currency | | | | `DebtorId` | `string` | Customer number | | | | `Description` | `string` | Invoice description | | | | `ExpDate` | `datetime` | Due date | | | | `InvoiceNr` | `string` | Invoice number | | | | `NookPieceDate` | `datetime` | Document date | | | | `UnitId` | `int32` | Administration | | |