# Profit_Creditor_Invoices: Profit Creditor Invoices ## Documentation Profit_Creditor_Invoices - Name: `Profit_Creditor_Invoices` - Catalog: `AfasOnline` - Schema: `GetConnector` - Label: Profit Creditor Invoices - Partition-specific: false - Select: true - Insert: false - Update: false - Delete: false - Select Service URL (OData-specific): `/connectors/Profit_Creditor_Invoices` - Insert Service URL (OData-specific): `/connectors/Profit_Creditor_Invoices` - Update Service URL (OData-specific): `/connectors/Profit_Creditor_Invoices` - Delete Service URL (OData-specific): `/connectors/Profit_Creditor_Invoices` - Field Selection Method (OData-specific): NotRequired ## Table Columns The columns of the table `Profit_Creditor_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 | | | | `Blocked` | `boolean` | Blocked for payment/collection | | | | `BookPieceDate` | `datetime` | Invoice date | | | | `BookPiecrNr` | `string(32)` | Document number | | | | `CreditorId` | `string(16)` | Supplier no. | | | | `CurrencyId` | `string(3)` | Currency | | | | `Description` | `string(120)` | Invoice description | | | | `ExpDate` | `datetime` | Due date | | | | `InvoiceNr` | `string(12)` | Invoice number | | | | `UnitId` | `int32` | Administration | | |