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

Statussenbewerken

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