# Profit_Creditor: Profit Creditor ## Documentation Profit_Creditor - Name: `Profit_Creditor` - Catalog: `AfasOnline` - Schema: `AfasOnline` - Label: Profit Creditor ## Table Columns The columns of the table `Profit_Creditor` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `Adressline1` | `string` | Address line 1 (street - house no.) | | | | `Adressline3` | `string` | Address line 3 (postal code - city) | | | | `Adressline4` | `string` | Address line 4 (country) | | | | `AutoPayment` | `boolean` | Pay automatically | | | | `BcCo` | `string` | Org. no. | | | | `Blocked` | `boolean` | Block completely, no longer visible | | | | `Btw-nummer` | `string` | VAT number | | | | `ChOfCommNr` | `string` | Chamber of Commerce number | | | | `CreateDate` | `datetime` | Created on | | | | `CreditLimit` | `decimal` | Credit limit | | | | `CreditorId` | `string` | Supplier number | | | | `CreditorName` | `string` | Supplier name | | | | `Email` | `string` | Work email | | | | `IBAN` | `string` | IBAN number | | | | `ModifiedDate` | `datetime` | Modified on | | | | `PaymentCondition` | `string` | Payment term | | | | `SearchName` | `string` | Search name | | | | `TelNr` | `string` | Work phone number | | | | `TempBlocked` | `boolean` | Block temporarily | | | | `VatDuty` | `string` | VAT liability | | |