|
recipient_name
|
text
|
string
|
|
|
recipient_email
|
text
|
string
|
|
|
invoice_nr
|
text
|
string
|
|
|
recipient_postal_code
|
text
|
string
|
|
|
recipient_phone
|
text
|
string
|
|
|
recipient_first_name
|
text
|
string
|
|
|
recipient_last_name
|
text
|
string
|
|
|
recipient_address
|
text
|
string
|
|
|
recipient_country
|
text
|
string
|
|
|
due_date
|
numeric
|
number
|
|
|
created_at
|
timestamp with time zone
|
string
|
|
|
currency
|
text
|
string
|
|
|
contact
|
uuid
|
string
|
|
|
status
|
text
|
string
|
|
|
items
|
json
|
json
|
|
|
owner_id
|
text
|
string
|
|
|
recipient_company
|
text
|
string
|
|
|
recipient_company_id
|
uuid
|
string
|
|
|
invoice_id
|
uuid
|
string
|
|
|
paid
|
boolean
|
boolean
|
|
|
payment_instructions
|
text
|
string
|
|
|
pay_button_href
|
text
|
string
|
|
|
author_name
|
text
|
string
|
|
|
link_tos
|
text
|
string
|
|
|
link_privacy_policy
|
text
|
string
|
|
|
memo
|
text
|
string
|
|
|
author_email
|
text
|
string
|
|
|
author_postal_code
|
text
|
string
|
|
|
author_phone
|
text
|
string
|
|
|
author_first_name
|
text
|
string
|
|
|
author_last_name
|
text
|
string
|
|
|
author_address
|
text
|
string
|
|
|
author_country
|
text
|
string
|
|
|
author_company_id
|
text
|
string
|
|
|
author_vat_id
|
text
|
string
|
|
|
author_tax_id
|
text
|
string
|
|
|
author_kvk
|
text
|
string
|
|
|
recipient_kvk
|
text
|
string
|
|
|
recipient_tax_id
|
text
|
string
|
|
|
recipient_vat_id
|
text
|
string
|
|
|
amount
|
numeric
|
number
|
|
|
amount_paid
|
numeric
|
number
|
|
|
amount_remaining
|
numeric
|
number
|
|
|
paid_at
|
numeric
|
number
|
|
|
payment_method
|
text
|
string
|
|
|
number_format
|
text
|
string
|
|
|
email_sent
|
boolean
|
boolean
|
|
|
email_id
|
uuid
|
string
|
|
|
email_sent_at
|
numeric
|
number
|
|
|
times_opened
|
numeric
|
number
|
|
|
times_opened_unique
|
numeric
|
number
|
|
|
company_logo
|
text
|
string
|
|
|
company_logo_href
|
text
|
string
|
|
|
discount_code
|
text
|
string
|
|
|
discount_total
|
numeric
|
number
|
|
|
discount
|
boolean
|
boolean
|
|
|
shipping_rate
|
boolean
|
boolean
|
|
|
shipping_total
|
numeric
|
number
|
|
|
send_as_email
|
boolean
|
boolean
|
|
|
subscription
|
boolean
|
boolean
|
|
|
subscription_id
|
text
|
string
|
|
|
relation_hash
|
text
|
string
|
|
|
scheduled_email_send_at
|
numeric
|
number
|
|
|
descriptor_global
|
text
|
string
|
|
|
descriptor_relation
|
text
|
string
|
|
|
number_global
|
numeric
|
number
|
|
|
number_relation
|
numeric
|
number
|
|
|
pay_button_text
|
text
|
string
|
|
|
url
|
text
|
string
|
|
|
brand_color
|
text
|
string
|
|
|
pdf_generated
|
boolean
|
boolean
|
|
|
pdf_url
|
text
|
string
|
|
|
reverse_charged
|
boolean
|
boolean
|
|
|
invoice_template_id
|
uuid
|
string
|
|
|
custom_fields
|
json
|
json
|
|
|
tax_id_type_recipient
|
text
|
string
|
|
|
tax_id_type_author
|
text
|
string
|
|
|
invoice_number_per_company
|
numeric
|
number
|
|
|
invoice_number_global_all_time
|
numeric
|
number
|
|
|
descriptor_project
|
text
|
string
|
|
|
invoice_number_global_per_quarter
|
numeric
|
number
|
|
|
invoice_number_global_per_fiscal_year
|
numeric
|
number
|
|
|
views
|
numeric
|
number
|
|
|
revenue
|
numeric
|
number
|
|
|
sales
|
numeric
|
number
|
|
|
note
|
text
|
string
|
|
|
url_link_deactivated
|
boolean
|
boolean
|
|
|
metadata
|
json
|
json
|
|
|
quote_template_id
|
text
|
string
|
|
|
total_fmt
|
text
|
string
|
|
|
subtotal_fmt
|
text
|
string
|
|
|
tax_total_fmt
|
text
|
string
|
|
|
has_payment_callback
|
boolean
|
boolean
|
|
|
payment_method_count
|
numeric
|
number
|
|
|
invoice_age_days_past_due
|
numeric
|
number
|
|
|
payment_methods
|
jsonb
|
json
|
|
|
creator_ip_address
|
text
|
string
|