title: "InvoiceLine" category: reference tags: [entity, invoice-line, datamodel] source: Entities.xml date: 2026-04-17 status: published
InvoiceLine
Type: Entity Properties: 59 Contexts: 3 Statussen: 15
DB-schema:
lookup_table_schema("InvoiceLine")· ../tables/InvoiceLine
Contextsbewerken
- 0: Standaard (
InvoiceLineContext.None) - 1: Standaard (
InvoiceLineContext.Standard) - 2: Fleet (
InvoiceLineContext.Fleet)
Statussenbewerken
- -1: Trash (
InvoiceLineStatus.Trash) - 0: None (
InvoiceLineStatus.None) - 1: Open (
InvoiceLineStatus.Created) - 2: Goedgekeurd (
InvoiceLineStatus.Approved) - 4: Credit open (
InvoiceLineStatus.CreditCreated) - 8: Credit goedgekeurd (
InvoiceLineStatus.CreditApproved) - 16: Bestelregel (
InvoiceLineStatus.PurchaseLineAdded) - 32: Open (
InvoiceLineStatus.CreatedNoPurchase) - 64: Goedgekeurd (
InvoiceLineStatus.ApprovedNoPurchase) - 128: Credit open (
InvoiceLineStatus.CreditCreatedNoPurchase) - 256: Credit goedgekeurd (
InvoiceLineStatus.CreditApprovedNoPurchase) - 512: Factuurvoorstel (
InvoiceLineStatus.InvoiceProposal) - 1024: 0 factureren (
InvoiceLineStatus.InvoiceZero) - 2048: Volgende run (
InvoiceLineStatus.InvoiceNextRun) - 16384: Gefactureerd (
InvoiceLineStatus.Invoiced)
Propertiesbewerken
| Property | Type | Kolom | Width | Nullable | Default |
|---|---|---|---|---|---|
| Id.Invoice | Invoice | INVLINVID | false | ||
| Id.LineId | UltimoString | INVLLINEID | 4 | false | |
| Account | Account | INVLACCID | true | ||
| Article | Article | INVLARTID | true | ||
| BookCostOnServiceContract | Boolean | INVLBOOKCOSTONSVC | false | 0 | |
| Charge | Boolean | INVLCHARGE | false | 0 | |
| Context | Context | INVLCONTEXT | false | 1 | |
| CostCenter | CostCenter | INVLCCRID | true | ||
| Costs | List[Cost] | CSTINVID, CSTINVLLINEID | true | , | |
| CostType | CostType | INVLCSTTID | true | ||
| Currency | Currency | INVLCURID | false | ||
| Customer | Customer | INVLCUSID | true | ||
| DataProvider | UltimoString | INVLDATAPROVIDER | 50 | true | |
| Department | Department | INVLDEPID | true | ||
| Description | UltimoString | INVLDESCR | 200 | true | |
| Discount | Decimal | INVLDISCOUNT | false | ||
| Equipment | Equipment | INVLEQMID | true | ||
| Exported | Boolean | INVLEXPORTED | false | ||
| ExternalId | UltimoString | INVLEXTERNALID | 50 | true | |
| ExternalStatus | UltimoString | INVLEXTERNALSTATUS | 50 | true | |
| Extra1 | Int16 | INVLEXTRA1 | false | ||
| Extra2 | Int16 | INVLEXTRA2 | false | ||
| Extra3 | Int32 | INVLEXTRA3 | false | ||
| Extra4 | Int32 | INVLEXTRA4 | false | ||
| Extra5 | UltimoString | INVLEXTRA5 | 15 | true | |
| Extra6 | UltimoString | INVLEXTRA6 | 15 | true | |
| Extra7 | UltimoString | INVLEXTRA7 | 15 | true | |
| GrossPrice | TransactionMoney | INVLGROSSPRICE | false | 0 | |
| GrossTotalPrice | TransactionMoney | INVLGROSSTOTPRICE | false | 0 | |
| InternalChargeLine | InternalChargeLine | INVLINVOID, INVLINVOLLINEID | true | , | |
| InvoiceCost | CompanyMoney | INVLINVCOST | false | 0 | |
| Invoiced | Boolean | INVLINVOICED | false | ||
| InvoiceQuantity | Decimal | INVLINVQTY | false | ||
| Job | Job | INVLJOBID | true | ||
| NowInvoice | CompanyMoney | INVLNOWINV | false | 0 | |
| NowInvoiceIncludingVat | CompanyMoney | INVLNOWINVINCLVAT | false | 0 | |
| OriginalStatus | Status | INVLORGRECSTATUS | false | ||
| Price | TransactionMoney | INVLPRICE | false | 0 | |
| ProcessFunction | ProcessFunction | INVLPRFID | true | ||
| Project | Project | INVLPRJID | true | ||
| ProviderMutationDate | DateTime? | INVLPROVIDERMUTDATE | true | ||
| PurchaseLine | PurchaseLine | INVLPCHID, INVLPCHLID | true | , | |
| Quantity | Decimal | INVLQTY | false | ||
| ReceiptLine | ReceiptLine | INVLRCPID, INVLRCPLID | true | , | |
| RecordCreateDate | DateTime? | INVLRECCREATEDATE | true | SYSDATETIME | |
| ServiceContractLine | ServiceContractLine | INVLSVCID, INVLSVCLLINEID | true | , | |
| Settle | Boolean | INVLSETTLE | false | ||
| SkillCategory | SkillCategory | INVLSKCID | true | ||
| StandardTotalPrice | CompanyMoney | INVLSTDTOTPRICE | false | 0 | |
| StandardTotalPriceIncludingVat | CompanyMoney | INVLSTDTOTPRICEINCLVAT | false | 0 | |
| StandardVatPrice | CompanyMoney | INVLSTDVATPRICE | false | 0 | |
| Status | Status | INVLRECSTATUS | false | ||
| SystemCompany | Company | INVLCOMPID | false | ||
| TotalPrice | TransactionMoney | INVLTOTPRICE | false | 0 | |
| TotalPriceIncludingVat | TransactionMoney | INVLTOTPRICEINCLVAT | false | 0 | |
| TransferNextTime | Boolean | INVLTRANSFERNEXTTIME | false | ||
| Vat | Vat | INVLVATID | true | ||
| VatPercentage | Decimal | INVLVATPERCENTAGE | false | ||
| VatPrice | TransactionMoney | INVLVATPRICE | false | 0 |
Brondatabewerken
- Entity-definitie —
lookup_entity("InvoiceLine")Model-perspectief (properties, contexts, statussen). Bron:Entities.xml. - DB-schema —
lookup_table_schema("InvoiceLine")· ../tables/InvoiceLine DB-perspectief (triggers, computed, defaults). Bron:database-schema.json. - Workflows —
find_workflows("", entity="InvoiceLine")Before/After Save events voor InvoiceLine. Bron:workflows.xml.