# Profit_Debtor_Invoices: Debtor Invoices ## Documentation Profit_Debtor_Invoices - Name: `Profit_Debtor_Invoices` - Catalog: `AfasOnline` - Schema: `GetConnector` - Label: Debtor Invoices - Partition-specific: false - Select: true - Insert: false - Update: false - Delete: false - Select Service URL (OData-specific): `/connectors/Profit_Debtor_Invoices` - Insert Service URL (OData-specific): `/connectors/Profit_Debtor_Invoices` - Update Service URL (OData-specific): `/connectors/Profit_Debtor_Invoices` - Delete Service URL (OData-specific): `/connectors/Profit_Debtor_Invoices` - Field Selection Method (OData-specific): NotRequired ## 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(3)` | Currency | | | | `DebtorId` | `string(16)` | Customer number | | | | `Description` | `string(120)` | Invoice description | | | | `ExpDate` | `datetime` | Due date | | | | `InvoiceNr` | `string(12)` | Invoice number | | | | `NookPieceDate` | `datetime` | Document date | | | | `UnitId` | `int32` | Administration | | |