Invoices and Properties

This component provides two tables; one for invoices and one for properties, where an invoice can be linked to the related property.

Data model

The following diagram shows the data model for invoices and properties.

The model contains the following items:

• InvoicesAndProperties
  This just holds the lists of Invoices and Properties
  This just holds the list of InvoiceAndProperty.
• InvoiceAndProperty
  All information about an invoice and/or the related property. If you buy something, you have an invoice and related property. If you get your house painted, you just have an invoice. If you get a present, you only have the property.
  • date
    The invoice date.
  • company
    The company paid to. E.g. where a property was bought, or the company that did the work.
  • description
    Plain text description of the invoice and/or property.
  • amount
    The amount of money paid. If you specify invoiceAndPropertyItems, each with their amount, you don’t have to fill this in as it is calculated by the application. However you can still fill this in, e.g. in case there were extra costs besides what you specified in the items.
  • brand
    The brand of the property, e.g. ‘Bosch’.
  • type
    The type or model of the property.
  • serialNumber
    The serial number of the property.
  • fromDate
    Since when do you have the property.
  • untilDate
    Until when you had the property.
  • archive
    Typically set when you don’t have the property anymore.
    This is used in the application to hide these properties.
  • remarks
    Any other information you want to store about the invoice and/or property
  • pictures
    Any pictures of the property.documents
    Any documents related to the invoice and/or property, like e.g. the invoice or user manual.
  • invoiceAndPropertyItems
    A list of type InvoiceAndPropertyItem. This is typically used if you buy related items, e.g. like a camera body, a lens and a flash.
• InvoiceAndPropertyItem
  Information about a single item.
  • description
    Plain text description of the item.
  • brand
    The brand of the property, e.g. ‘Bosch’.
  • type
    The type or model of the property.
  • serialNumber
    The serial number of the property.
  • amount
    The amount of money paid for the item.
  • fromDate
    Since when do you have the property.
  • untilDate
    Until when you had the property.
  • archive
    Typically set when you don’t have the property anymore.
    This is used in the application to hide these properties.
  • remarks
    Any other information you want to store about the invoice and/or property
  • pictures
    Any pictures of the item.
  • documents
    Any documents related to the item, like e.g. the invoice or user manual.
• Invoices
  The list of invoices
• Expenditure
  Specifies a single item bought or paid. This type is extended by both an Invoice and an InvoiceItem. This means that an Invoice and an InvoiceItem both have all attributes of en Expenditure.
  • description
    Plain text description of the expenditure
  • descriptionFromProperty
    Usually an invoice is related to a property (via the purchase reference). In this case you can set this value to true, indicating that the description of the expenditure isn’t filled in and in the application the description shown is derived from the property.
  • amount
    The amount of money paid.
  • remarks
    Any other information you want to store about the expenditure
  • purchase
    A reference to the related purchase (a property)
• Invoice
  All information about an invoice. Besides the attributes inherited from an Expenditure it has:
  • date
    The invoice date.
  • company
    The company paid to. E.g. where a property was bought, or the company that did the work.
  • invoiceItems
    A list of type InvoiceItem. This is typically used if you buy related items, e.g. like a camera body, a lens and a flash.
  • documents
    Any documents related to the invoice.
• Properties
  The list of properties.
• Property
  All information related to a property.
  • description
    A description of the property, e.g. ‘Refrigerator’
  • brand
    The brand of the property, e.g. ‘Bosch’.
  • type
    The type or model of the property.
  • serialNumber
    The serial number of the property.
  • remarks
    Any other information you want to store about the property.
  • fromDate
    Since when do you have the property.
  • untilDate
    Until when you had the property.
  • archive
    Typically set when you don’t have the property anymore.
    This is used in the application to hide these properties.
  • documents
    Any documents related to the property like e.g. user manuals.
  • pictures
    Any pictures of the property.
  • expenditure
    A reference to the related Invoice or InvoiceItem
• FileReference
  A reference to a file.
  • file
    A path to a file. The path is relative to the InvoicesAndPropertiesFolder.
  • title
    An optional title describing the file.
  • tags
    Words describing the usage of the reference. Not used in this application.