Please enable JavaScript to view this site.

Navigation: Schema:  > Tabellen

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

 

Email

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