Please enable JavaScript to view this site.

Navigation: Schema:  > Tabellen

Relations: ionBIZ Relaties

Catalogus: ionBIZ

Label: Relaties

Ophalen: true

Tabelkolommen

De kolommen van de tabel Relations worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype.

Naam

Datatype

Label

Verplicht

Documentatie

AccountManagerId

int32

itgen_ibz_accountmanagerid

 

Active

boolean

itgen_ibz_active

 

Blocked

int32

itgen_ibz_blocked

 

Comment

string

itgen_ibz_comment

 

CreationDate

datetimeoffset

itgen_ibz_creationdate

 

CreatorId

int32

itgen_ibz_creatorid

 

CreditControlComment

string

itgen_ibz_creditcontrolcomment

 

DateBlocked

datetimeoffset

itgen_ibz_dateblocked

 

DefaultAddressId

int32

itgen_ibz_defaultaddressid

 

DefaultInvoiceToCustomerId

int32

itgen_ibz_defaultinvoicetocustomerid

 

DeletedById

int32

itgen_ibz_deletedbyid

 

DeletionDate

datetimeoffset

itgen_ibz_deletiondate

 

DepartmentId

int32

itgen_ibz_departmentid

 

Description

string

itgen_ibz_description

 

EmailDomains

string

itgen_ibz_emaildomains

 

ExternalCode

string

itgen_ibz_externalcode

 

GeneralDiscountPercent

decimal

itgen_ibz_generaldiscountpercent

 

Id

int32

itgen_ibz_id

 

InternalStatusCustomer

int32

itgen_ibz_internalstatuscustomer

 

IsDeleted

boolean

itgen_ibz_isdeleted

 

LedgerAccountId

int32

itgen_ibz_ledgeraccountid

 

LegalFormId

int32

itgen_ibz_legalformid

 

Mileage

decimal

itgen_ibz_mileage

 

ModifiedById

int32

itgen_ibz_modifiedbyid

 

Name

string

itgen_ibz_name

 

OpenCreditLimit

decimal

itgen_ibz_opencreditlimit

 

ProjectCode

string

itgen_ibz_projectcode

 

Reference

string

itgen_ibz_reference

 

RelationCode

string

itgen_ibz_relationcode

 

RelationGroupId

int32

itgen_ibz_relationgroupid

 

RelationHoldingId

int32

itgen_ibz_relationholdingid

 

RelationId

string

itgen_ibz_relationid

 

RelationLanguageId

int32

itgen_ibz_relationlanguageid

 

RelationTypeId

int32

itgen_ibz_relationtypeid

 

StatusCustomer

int32

itgen_ibz_statuscustomer

 

SysEndTime

datetimeoffset

itgen_ibz_sysendtime

 

SysStartTime

datetimeoffset

itgen_ibz_sysstarttime

 

TimesheetRuleInvoicingId

int32

itgen_ibz_timesheetruleinvoicingid

 

 

22-12-2022 20:59 Versie 22.1.101-BETA+3681