...
field | type | comment | |||||
HistoryBusinessModel fields | |||||||
subject_type | str |
| |||||
subject_id | uuid/int ? | https://stackoverflow.com/questions/33528098/django-model-one-foreign-key-to-many-tables Picker based on drop down ? (multiple picker displayed based drop down ? ) | |||||
thirdparty_type | str |
| |||||
thirdparty_id | uuid/int ? | https://stackoverflow.com/questions/33528098/django-model-one-foreign-key-to-many-tables Picker based on drop down ? (multiple picker displayed based drop down ? ) | |||||
(nice to have)related_invoice_id | uuid | link to invoices | |||||
code | str | or reference for the insurance (editable) | |||||
code_tp | str | or reference for the thirdparty (editable) | |||||
code_ext | str | if required for external system integration such as payment systems (editable) | |||||
date_due | date | date on which the payment is due (editable) | |||||
date_invoice | date | Date of the “invoice“ (date of today but editable) | |||||
*dateValidFrom | date | invoice covering service/item from (editable) | |||||
*dateValidTo | date | invoice covering service/item to (editable) | |||||
date_payed | date | Date on which the payment was actually documented as Done (editable) | |||||
amount_discount | float | total of the detail discount (calculated be) | |||||
amount_net | float | Total without tax (calculated be) | |||||
tax_analysis | json |
| |||||
amount_total | float | total net + tax total (calculated be) | |||||
status | int | ENUM: draft, validated, payed, cancelled, deleted (editable ), amended, suspended | |||||
currency_tp_code | str | currency of the third_party (if different) (hidden) | |||||
currency_code | str | currency of insurance (calculated be) (hidden) | |||||
note | bigttext | (editable) | |||||
terms | bigttext | conditions (editable) | |||||
payment_reference | str |
...
subject_type / subject_id | Subjet |
thirdparty_type/ thirdparty_id | Recipient(invoice)/Sender(Bill) |
(nice to have)related_invoice_id | related invoice “Picker with code“ |
code | code |
code_tp | Code recipient (resp. sender) |
code_ext | Code external system |
date_due | date due |
date_invoice | date invoice |
*dateValidFrom | from |
*dateValidTo | to |
date_payed | date payed |
amount_discount | discount |
amount_net | net |
tax_analysis | tax (just show total) |
amount_total | Total |
status | status |
currency_tp_code | currency recipient (resp sender) |
currency_code | currency |
note | note |
terms | terms |
payment_reference | payment reference |
...