title: "Invoice" category: reference tags: [entity, invoice, datamodel] source: Entities.xml date: 2026-04-17 status: published
Invoice
Type: Entity Properties: 35 Contexts: 3 Statussen: 10
Zie ook het handgeschreven artikel: invoice
DB-schema:
lookup_table_schema("Invoice")· ../tables/Invoice
Contextsbewerken
- 0: Standaard (
InvoiceContext.None) - 1: Standaard (
InvoiceContext.Standard) - 2: Fleet (
InvoiceContext.Fleet)
Statussenbewerken
- -1: Trash (
InvoiceStatus.Trash) - 0: None (
InvoiceStatus.None) - 1: Open (
InvoiceStatus.Created) - 2: Goedgekeurd (
InvoiceStatus.Approved) - 4: Credit open (
InvoiceStatus.CreditCreated) - 8: Credit goedgekeurd (
InvoiceStatus.CreditApproved) - 32: Open (
InvoiceStatus.CreatedNoPurchase) - 64: Goedgekeurd (
InvoiceStatus.ApprovedNoPurchase) - 128: Credit open (
InvoiceStatus.CreditCreatedNoPurchase) - 256: Credit goedgekeurd (
InvoiceStatus.CreditApprovedNoPurchase)
Propertiesbewerken
| Property | Type | Kolom | Width | Nullable | Default |
|---|---|---|---|---|---|
| Id | UltimoString | INVID | 9 | false | |
| BookDate | Date? | INVBOOKDATE | true | SYSDATE | |
| Context | Context | INVCONTEXT | false | 1 | |
| Currency | Currency | INVCURID | false | ||
| CurrencyConversionFactor | Int16 | INVCURCONVFACTOR | false | ||
| CurrencyRate | Decimal | INVCURRATE | false | ||
| DataProvider | UltimoString | INVDATAPROVIDER | 50 | true | |
| Department | Department | INVDEPID | true | ||
| Description | UltimoString | INVDESCR | 200 | true | |
| Exported | Boolean | INVEXPORTED | false | ||
| ExternalId | UltimoString | INVEXTERNALID | 50 | true | |
| ExternalStatus | UltimoString | INVEXTERNALSTATUS | 50 | true | |
| Extra1 | Int16 | INVEXTRA1 | false | ||
| Extra2 | Int32 | INVEXTRA2 | false | ||
| Extra3 | Int32 | INVEXTRA3 | false | ||
| Extra4 | UltimoString | INVEXTRA4 | 15 | true | |
| Extra5 | UltimoString | INVEXTRA5 | 15 | true | |
| Extra6 | UltimoString | INVEXTRA6 | 15 | true | |
| Lines | List[InvoiceLine] | INVLINVID | false | ||
| ProviderMutationDate | DateTime? | INVPROVIDERMUTDATE | true | ||
| Purchase | Purchase | INVPCHID | true | ||
| PurchaseAddType | PurchaseAddType | INVPURCHASEADDTYPE | false | 0 | |
| RecordCreateDate | DateTime? | INVRECCREATEDATE | true | SYSDATETIME | |
| Site | Site | INVSITID | true | ||
| StandardTotalPrice | CompanyMoney | INVSTDTOTPRICE | false | 0 | |
| StandardTotalPriceIncludingVat | CompanyMoney | INVSTDTOTPRICEINCLVAT | false | 0 | |
| StandardVatPrice | CompanyMoney | INVSTDVATPRICE | false | 0 | |
| Status | Status | INVRECSTATUS | false | ||
| StatusApprovedDate | DateTime? | INVDATE | true | ||
| StatusApprovedEmployee | Employee | INVEMPID | true | ||
| SystemCompany | Company | INVCOMPID | false | ||
| Text | UltimoString | INVTEXT | true | ||
| Total | TransactionMoney | INVTOTAL | false | 0 | |
| TransferNextTime | Boolean | INVTRANSFERNEXTTIME | false | ||
| Vendor | Vendor | INVVDRID | true |
Brondatabewerken
- Entity-definitie —
lookup_entity("Invoice")Model-perspectief (properties, contexts, statussen). Bron:Entities.xml. - DB-schema —
lookup_table_schema("Invoice")· ../tables/Invoice DB-perspectief (triggers, computed, defaults). Bron:database-schema.json. - Workflows —
find_workflows("", entity="Invoice")Before/After Save events voor Invoice. Bron:workflows.xml.