title: "Invoice (table)" category: reference tags: [table, invoice, datamodel] source: database-schema.json date: 2026-04-17 status: published
dba.Invoice
Schema: dba
Aantal kolommen: 36
Zie ook de entity-pagina: ../entities/Invoice
Kolommenbewerken
| Kolom | Type | Nullable | Default | Identity |
|---|---|---|---|---|
InvId |
nvarchar(9) | Nee | — | — |
InvDescr |
nvarchar(200) | Ja | — | — |
InvContext |
bigint | Nee | ((1)) | — |
InvRecStatus |
int | Nee | ((0)) | — |
InvBookDate |
date | Ja | — | — |
InvCompId |
nvarchar(6) | Nee | — | — |
InvCurConvFactor |
smallint | Nee | ((0)) | — |
InvCurId |
nvarchar(5) | Nee | — | — |
InvCurRate |
decimal(21,5) | Nee | ((0)) | — |
InvDataProvider |
nvarchar(50) | Ja | — | — |
InvDate |
datetimeoffset(7) | Ja | — | — |
InvDepId |
nvarchar(11) | Ja | — | — |
InvEmpId |
nvarchar(9) | Ja | — | — |
InvExported |
smallint | Nee | ((0)) | — |
InvExternalId |
nvarchar(50) | Ja | — | — |
InvExternalStatus |
nvarchar(50) | Ja | — | — |
InvExtra1 |
smallint | Nee | ((0)) | — |
InvExtra2 |
int | Nee | ((0)) | — |
InvExtra3 |
int | Nee | ((0)) | — |
InvExtra4 |
nvarchar(15) | Ja | — | — |
InvExtra5 |
nvarchar(15) | Ja | — | — |
InvExtra6 |
nvarchar(15) | Ja | — | — |
InvPchId |
nvarchar(10) | Ja | — | — |
InvProviderMutDate |
datetimeoffset(7) | Ja | — | — |
InvPurchaseAddType |
smallint | Nee | ((0)) | — |
InvRecCreateDate |
datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
InvSitId |
nvarchar(8) | Ja | — | — |
InvStdTotPrice |
decimal(21,5) | Nee | ((0)) | — |
InvStdTotPriceInclVat |
decimal(21,5) | Nee | ((0)) | — |
InvStdVatPrice |
decimal(21,5) | Nee | ((0)) | — |
InvText |
nvarchar(max) | Ja | — | — |
InvTotal |
decimal(21,5) | Nee | ((0)) | — |
InvTransferNextTime |
smallint | Nee | ((0)) | — |
InvVdrId |
nvarchar(6) | Ja | — | — |
InvFileExtension |
nvarchar(5) | Nee | — | — |
InvText_FT |
varbinary(max) | Ja | — | — |
Computed columnsbewerken
InvFileExtension—(N'.html')InvText_FT—(case when [InvText] IS NULL then NULL else 0xFFFE+CONVERT([varbinary](max),case when left([InvText],(5))=N'<html' then [InvText] else N'<html lang="nl">'+[InvText] end) end)
Trigger-gevulde kolommenbewerken
InvStdTotPrice← TRSD_INVOICELINE, TRSM_INVOICELINEInvStdTotPriceInclVat← TRSD_INVOICELINE, TRSM_INVOICELINEInvStdVatPrice← TRSD_INVOICELINE, TRSM_INVOICELINEInvTotal← TRSD_INVOICELINE, TRSM_INVOICELINE
Brondatabewerken
- DB-schema —
lookup_table_schema("Invoice")Alle kolommen met types, triggers, computed. Bron:database-schema.json. - Entity-model —
lookup_entity("Invoice")· ../entities/Invoice Properties, contexts, statussen. Bron:Entities.xml.