# RelationAddresses: ionBIZ Customer Addresses - Catalog: `ionBIZ` - Label: Customer Addresses - Retrieve: true ## Table Columns The columns of the table `RelationAddresses` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `Active` | `boolean` | Active | ☐ | | | `Address_CountryId` | `int32` | Address Country ID | ☐ | | | `AffiliateCode` | `string` | Affiliate Code | ☐ | | | `BankName` | `string` | Bank Name | ☐ | | | `BIC` | `string` | BIC | ☐ | | | `CreationDate` | `datetimeoffset` | Creation Date | ☐ | | | `CreatorId` | `int32` | Creator ID | ☐ | | | `CreditNoteTemplateId` | `int32` | Credit Note Template ID | ☐ | | | `DefaultCurrencyId` | `int32` | Default Currency ID | ☐ | | | `DeletedById` | `int32` | Deleted by ID | ☐ | | | `DeletionDate` | `datetimeoffset` | Deletion Date | ☐ | | | `Description` | `string` | Description | ☐ | | | `Email` | `string` | Email | ☐ | | | `ExternalCode` | `string` | External Code | ☐ | | | `Fax` | `string` | Fax | ☐ | | | `GeneralLedgerAcc` | `string` | General Ledger Account | ☐ | | | `GeneralLedgerSubAcc` | `string` | General Ledger Subaccount | ☐ | | | `GroupInvoiceLinesById` | `int32` | Group Invoice Lines by ID | ☐ | | | `IBAN` | `string` | IBAN | ☐ | | | `Id` | `int32` | ID | ☑ | | | `InvoiceAddress` | `boolean` | Invoice Address | ☐ | | | `InvoiceDetailTemplateId` | `int32` | Invoice Detail Template ID | ☐ | | | `InvoiceInDays` | `boolean` | Invoice in Days | ☐ | | | `InvoiceName` | `string` | Invoice Name | ☐ | | | `InvoiceTemplateId` | `int32` | Invoice Template ID | ☐ | | | `IsDefault` | `boolean` | Is Default | ☐ | | | `IsDeleted` | `boolean` | Is Deleted | ☐ | | | `Logo` | `byte[]` | Logo | ☐ | | | `Mileage` | `decimal` | Mileage | ☐ | | | `Name` | `string` | Name | ☐ | | | `PaymentConditionId` | `int32` | Payment Condition ID | ☐ | | | `PeppolCompanyId` | `string` | Peppol Company ID | ☐ | | | `ProjectInvoiceGroupId` | `int32` | Project Invoice Group ID | ☐ | | | `PurchaseOrderDeliveryConditionId` | `int32` | Purchase Order Delivery Condition ID | ☐ | | | `PurchaseOrderPaymentConditionId` | `int32` | Purchase Order Payment Condition ID | ☐ | | | `PurchaseOrderWarrantyConditionId` | `int32` | Purchase Order Warranty Condition ID | ☐ | | | `ReceivablesAcc` | `string` | Receivables Account | ☐ | | | `ReceivablesSubAcc` | `string` | Receivables Subaccount | ☐ | | | `RegistrationNumber` | `string` | Registration Number | ☐ | | | `RelationContactId` | `int32` | Relation Contact ID | ☐ | | | `RelationId` | `int32` | Relation ID | ☐ | | | `SendInvoiceByOption` | `int32` | Send Invoice by Option | ☐ | | | `SiteRef` | `string` | Site Reference | ☐ | | | `StructuredReferenceId` | `int32` | Structured Reference ID | ☐ | | | `SysEndTime` | `datetimeoffset` | System End Time | ☐ | | | `SysStartTime` | `datetimeoffset` | System Start Time | ☐ | | | `Telephone` | `string` | Telephone | ☐ | | | `VAT_CountryId` | `int32` | VAT Country ID | ☐ | | | `Vat` | `string` | VAT | ☐ | | | `VATPercentageId` | `int32` | VAT Percentage ID | ☐ | | | `Website` | `string` | Website | ☐ | |