# Profit_Creditor_Invoices: Profit Creditor Invoices ## Documentation Profit_Creditor_Invoices - Name: `Profit_Creditor_Invoices` - Catalog: `AfasOnline` - Schema: `AfasOnline` - Label: Profit Creditor Invoices ## 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` | Document number | | | | `CreditorId` | `string` | Supplier no. | | | | `CurrencyId` | `string` | Currency | | | | `Description` | `string` | Invoice description | | | | `ExpDate` | `datetime` | Due date | | | | `InvoiceNr` | `string` | Invoice number | | | | `UnitId` | `int32` | Administration | | |