title: "InvoiceOut (table)" category: reference tags: [table, invoiceout, datamodel] source: database-schema.json date: 2026-04-17 status: published
dba.InvoiceOut
Schema: dba
Aantal kolommen: 63
Kolommenbewerken
| Kolom | Type | Nullable | Default | Identity |
|---|---|---|---|---|
InvoId |
nvarchar(9) | Nee | — | — |
InvoDescr |
nvarchar(200) | Ja | — | — |
InvoContext |
bigint | Nee | ((1)) | — |
InvoRecStatus |
int | Nee | ((0)) | — |
InvoBookDate |
date | Ja | — | — |
InvoCcrId |
nvarchar(9) | Ja | — | — |
InvoCompId |
nvarchar(6) | Nee | — | — |
InvoCostCalc |
decimal(21,5) | Nee | ((0)) | — |
InvoCreateDate |
date | Ja | — | — |
InvoCreditCompleted |
smallint | Nee | ((0)) | — |
InvoCreditCompletedDate |
datetimeoffset(7) | Ja | — | — |
InvoCreditCompletedEmpId |
nvarchar(9) | Ja | — | — |
InvoCusId |
nvarchar(6) | Ja | — | — |
InvoDepId |
nvarchar(11) | Ja | — | — |
InvoEqmCost |
decimal(21,5) | Nee | ((0)) | — |
InvoEqmId |
nvarchar(24) | Ja | — | — |
InvoEqmInv |
decimal(21,5) | Nee | ((0)) | — |
InvoExported |
smallint | Nee | ((0)) | — |
InvoExtCost |
decimal(21,5) | Nee | ((0)) | — |
InvoExtCostCalc |
decimal(21,5) | Nee | ((0)) | — |
InvoExtInv |
decimal(21,5) | Nee | ((0)) | — |
InvoInvDate |
date | Ja | — | — |
InvoInvocId |
nvarchar(14) | Ja | — | — |
InvoInvpId |
nvarchar(14) | Ja | — | — |
InvoIotCalc |
decimal(21,5) | Nee | ((0)) | — |
InvoIotCost |
decimal(21,5) | Nee | ((0)) | — |
InvoIotInv |
decimal(21,5) | Nee | ((0)) | — |
InvoJobId |
nvarchar(12) | Ja | — | — |
InvoLabCost |
decimal(21,5) | Nee | ((0)) | — |
InvoLabInv |
decimal(21,5) | Nee | ((0)) | — |
InvoLabourCostCalc |
decimal(21,5) | Nee | ((0)) | — |
InvoPrfId |
nvarchar(50) | Ja | — | — |
InvoPrjId |
nvarchar(6) | Ja | — | — |
InvoPurchCost |
decimal(21,5) | Nee | ((0)) | — |
InvoPurchCostCalc |
decimal(21,5) | Nee | ((0)) | — |
InvoPurchInv |
decimal(21,5) | Nee | ((0)) | — |
InvoRecCreateDate |
datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
InvoResCalc |
decimal(21,5) | Nee | ((0)) | — |
InvoResCost |
decimal(21,5) | Nee | ((0)) | — |
InvoResInv |
decimal(21,5) | Nee | ((0)) | — |
InvoResocId |
nvarchar(4) | Ja | — | — |
InvoResocResId |
nvarchar(6) | Ja | — | — |
INVORRECOSTINV |
decimal(21,5) | Nee | ((0)) | — |
InvoSkcId |
nvarchar(9) | Ja | — | — |
InvoSourceInvoId |
nvarchar(9) | Ja | — | — |
InvoSvcId |
nvarchar(9) | Ja | — | — |
InvoTlsCost |
decimal(21,5) | Nee | ((0)) | — |
InvoTlsCostCalc |
decimal(21,5) | Nee | ((0)) | — |
InvoTlsInv |
decimal(21,5) | Nee | ((0)) | — |
InvoTotCostVatId |
nvarchar(3) | Ja | — | — |
InvoTotCostVatPercentage |
decimal(21,2) | Nee | ((0)) | — |
InvoTotCostVatPrice |
decimal(21,5) | Nee | ((0)) | — |
InvoVdrId |
nvarchar(6) | Ja | — | — |
InvoWhsoCost |
decimal(21,5) | Nee | ((0)) | — |
InvoWhsoCostCalc |
decimal(21,5) | Nee | ((0)) | — |
InvoWhsoInv |
decimal(21,5) | Nee | ((0)) | — |
InvoWotId |
nvarchar(6) | Ja | — | — |
InvoTotCost |
decimal(21,2) | Nee | — | — |
InvoDataProvider |
nvarchar(50) | Ja | — | — |
InvoProviderMutDate |
datetimeoffset(7) | Ja | — | — |
InvoTransferNextTime |
smallint | Nee | ((0)) | — |
InvoExternalId |
nvarchar(50) | Ja | — | — |
InvoExternalStatus |
nvarchar(50) | Ja | — | — |
Computed columnsbewerken
InvoTotCost—(CONVERT([decimal](21,2),(((((((([INVOEQMINV]+[INVOEXTINV])+[INVOIOTINV])+[INVOLABINV])+[INVOPURCHINV])+[INVORESINV])+[INVOTLSINV])+[INVOWHSOINV])+[INVOTOTCOSTVATPRICE])+[INVORRECOSTINV]))
Trigger-gevulde kolommenbewerken
InvoEqmCost← TRSD_INVOICEOUTLINE, TRSM_INVOICEOUTLINEInvoEqmInv← TRSD_INVOICEOUTLINE, TRSM_INVOICEOUTLINEInvoExtCost← TRSD_INVOICEOUTLINE, TRSM_INVOICEOUTLINEInvoExtCostCalc← TRSD_INVOICEOUTLINE, TRSM_INVOICEOUTLINEInvoExtInv← TRSD_INVOICEOUTLINE, TRSM_INVOICEOUTLINEInvoIotCost← TRSD_INVOICEOUTLINE, TRSM_INVOICEOUTLINEInvoIotInv← TRSD_INVOICEOUTLINE, TRSM_INVOICEOUTLINEInvoLabCost← TRSD_INVOICEOUTLINE, TRSM_INVOICEOUTLINEInvoLabInv← TRSD_INVOICEOUTLINE, TRSM_INVOICEOUTLINEInvoLabourCostCalc← TRSD_INVOICEOUTLINE, TRSM_INVOICEOUTLINEInvoPurchCost← TRSD_INVOICEOUTLINE, TRSM_INVOICEOUTLINEInvoPurchCostCalc← TRSD_INVOICEOUTLINE, TRSM_INVOICEOUTLINEInvoPurchInv← TRSD_INVOICEOUTLINE, TRSM_INVOICEOUTLINEInvoResCost← TRSD_INVOICEOUTLINE, TRSM_INVOICEOUTLINEInvoResInv← TRSD_INVOICEOUTLINE, TRSM_INVOICEOUTLINEINVORRECOSTINV← TRSD_INVOICEOUTLINE, TRSM_INVOICEOUTLINEInvoTlsCost← TRSD_INVOICEOUTLINE, TRSM_INVOICEOUTLINEInvoTlsCostCalc← TRSD_INVOICEOUTLINE, TRSM_INVOICEOUTLINEInvoTlsInv← TRSD_INVOICEOUTLINE, TRSM_INVOICEOUTLINEInvoTotCostVatPrice← TRSD_INVOICEOUTLINE, TRSM_INVOICEOUTLINEInvoWhsoCost← TRSD_INVOICEOUTLINE, TRSM_INVOICEOUTLINEInvoWhsoCostCalc← TRSD_INVOICEOUTLINE, TRSM_INVOICEOUTLINEInvoWhsoInv← TRSD_INVOICEOUTLINE, TRSM_INVOICEOUTLINE
Brondatabewerken
- DB-schema —
lookup_table_schema("InvoiceOut")Alle kolommen met types, triggers, computed. Bron:database-schema.json.