Please enable JavaScript to view this site.

Navigation: Schema:  > Tabellen

PurchaseInvoices: ionBIZ Inkoopfacturen

Catalogus: ionBIZ

Label: Inkoopfacturen

Ophalen: true

Tabelkolommen

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

Naam

Datatype

Label

Verplicht

Documentatie

Address_CountryId

int32

itgen_ibz_address_countryid

 

CreationDate

datetimeoffset

itgen_ibz_creationdate

 

CreatorId

int32

itgen_ibz_creatorid

 

CurrencyId

int32

itgen_ibz_currencyid

 

DeletedById

int32

itgen_ibz_deletedbyid

 

DeletionDate

datetimeoffset

itgen_ibz_deletiondate

 

DeliveryDate

datetimeoffset

itgen_ibz_deliverydate

 

Description

string

itgen_ibz_description

 

DocDate

datetimeoffset

itgen_ibz_docdate

 

DocId

string

itgen_ibz_docid

 

DueDate

datetimeoffset

itgen_ibz_duedate

 

Id

int32

itgen_ibz_id

 

IsDeleted

boolean

itgen_ibz_isdeleted

 

Locked

boolean

itgen_ibz_locked

 

Notes

string

itgen_ibz_notes

 

PaidOn

datetimeoffset

itgen_ibz_paidon

 

PaymentMethodId

int32

itgen_ibz_paymentmethodid

 

PaymentRef

string

itgen_ibz_paymentref

 

ProjectId

int32

itgen_ibz_projectid

 

PurchaseInvoiceStatusId

int32

itgen_ibz_purchaseinvoicestatusid

 

RelationContactId

int32

itgen_ibz_relationcontactid

 

RelationId

int32

itgen_ibz_relationid

 

RelationVat

string

itgen_ibz_relationvat

 

ResourceId

int32

itgen_ibz_resourceid

 

ResourceLanguageId

int32

itgen_ibz_resourcelanguageid

 

SupplierDocId

string

itgen_ibz_supplierdocid

 

SysEndTime

datetimeoffset

itgen_ibz_sysendtime

 

SysStartTime

datetimeoffset

itgen_ibz_sysstarttime

 

TemplateId

int32

itgen_ibz_templateid

 

 

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