RelationAddresses: ionBIZ Relatie Adressen |
Catalogus: ionBIZ
Label: Relatie Adressen
Ophalen: true
Tabelkolommen
De kolommen van de tabel RelationAddresses worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype.
Naam |
Datatype |
Label |
Verplicht |
Documentatie |
---|---|---|---|---|
Active |
boolean |
itgen_ibz_active |
☐ |
|
Address_CountryId |
int32 |
itgen_ibz_address_countryid |
☐ |
|
AffiliateCode |
string |
itgen_ibz_affiliatecode |
☐ |
|
BankName |
string |
itgen_ibz_bankname |
☐ |
|
BIC |
string |
itgen_ibz_bic |
☐ |
|
CreationDate |
datetimeoffset |
itgen_ibz_creationdate |
☐ |
|
CreatorId |
int32 |
itgen_ibz_creatorid |
☐ |
|
CreditNoteTemplateId |
int32 |
itgen_ibz_creditnotetemplateid |
☐ |
|
DefaultCurrencyId |
int32 |
itgen_ibz_defaultcurrencyid |
☐ |
|
DeletedById |
int32 |
itgen_ibz_deletedbyid |
☐ |
|
DeletionDate |
datetimeoffset |
itgen_ibz_deletiondate |
☐ |
|
Description |
string |
itgen_ibz_description |
☐ |
|
string |
itgen_ibz_email |
☐ |
|
|
ExternalCode |
string |
itgen_ibz_externalcode |
☐ |
|
Fax |
string |
itgen_ibz_fax |
☐ |
|
GeneralLedgerAcc |
string |
itgen_ibz_generalledgeracc |
☐ |
|
GeneralLedgerSubAcc |
string |
itgen_ibz_generalledgersubacc |
☐ |
|
GroupInvoiceLinesById |
int32 |
itgen_ibz_groupinvoicelinesbyid |
☐ |
|
IBAN |
string |
itgen_ibz_iban |
☐ |
|
Id |
int32 |
itgen_ibz_id |
☑ |
|
InvoiceAddress |
boolean |
itgen_ibz_invoiceaddress |
☐ |
|
InvoiceDetailTemplateId |
int32 |
itgen_ibz_invoicedetailtemplateid |
☐ |
|
InvoiceInDays |
boolean |
itgen_ibz_invoiceindays |
☐ |
|
InvoiceName |
string |
itgen_ibz_invoicename |
☐ |
|
InvoiceTemplateId |
int32 |
itgen_ibz_invoicetemplateid |
☐ |
|
IsDefault |
boolean |
itgen_ibz_isdefault |
☐ |
|
IsDeleted |
boolean |
itgen_ibz_isdeleted |
☐ |
|
Logo |
byte[] |
itgen_ibz_logo |
☐ |
|
Mileage |
decimal |
itgen_ibz_mileage |
☐ |
|
Name |
string |
itgen_ibz_name |
☐ |
|
PaymentConditionId |
int32 |
itgen_ibz_paymentconditionid |
☐ |
|
PeppolCompanyId |
string |
itgen_ibz_peppolcompanyid |
☐ |
|
ProjectInvoiceGroupId |
int32 |
itgen_ibz_projectinvoicegroupid |
☐ |
|
PurchaseOrderDeliveryConditionId |
int32 |
itgen_ibz_purchaseorderdeliveryconditionid |
☐ |
|
PurchaseOrderPaymentConditionId |
int32 |
itgen_ibz_purchaseorderpaymentconditionid |
☐ |
|
PurchaseOrderWarrantyConditionId |
int32 |
itgen_ibz_purchaseorderwarrantyconditionid |
☐ |
|
ReceivablesAcc |
string |
itgen_ibz_receivablesacc |
☐ |
|
ReceivablesSubAcc |
string |
itgen_ibz_receivablessubacc |
☐ |
|
RegistrationNumber |
string |
itgen_ibz_registrationnumber |
☐ |
|
RelationContactId |
int32 |
itgen_ibz_relationcontactid |
☐ |
|
RelationId |
int32 |
itgen_ibz_relationid |
☐ |
|
SendInvoiceByOption |
int32 |
itgen_ibz_sendinvoicebyoption |
☐ |
|
SiteRef |
string |
itgen_ibz_siteref |
☐ |
|
StructuredReferenceId |
int32 |
itgen_ibz_structuredreferenceid |
☐ |
|
SysEndTime |
datetimeoffset |
itgen_ibz_sysendtime |
☐ |
|
SysStartTime |
datetimeoffset |
itgen_ibz_sysstarttime |
☐ |
|
Telephone |
string |
itgen_ibz_telephone |
☐ |
|
Vat |
string |
itgen_ibz_vat |
☐ |
|
VATPercentageId |
int32 |
itgen_ibz_vatpercentageid |
☐ |
|
Website |
string |
itgen_ibz_website |
☐ |
|
22-12-2022 20:59 Versie 22.1.101-BETA+3681