contact_id Contacts sensible
Contact ID
string created_at Contacts
Created at
datetime updated_at Contacts
Updated at
datetime deleted_at Contacts
Deleted at
datetime contact_displayed_as Contacts
Contact name
string name Contacts sensible
Name
string reference Contacts
Reference
string tax_number Contacts sensible
Tax number
string main_address_line_1 Contacts sensible
Main address - line 1
string main_address_line_2 Contacts sensible
Main address - line 2
string main_address_city Contacts
Main address - city
string main_address_postal_code Contacts sensible
Main address - postal code
string main_address_country Contacts
Main address - country
string main_address_type Contacts
Main address - type
string main_address_name Contacts
Main address - name
string main_address_region Contacts sensible
Main address - region
string main_contact_person_name Contacts sensible
Main contact person - name
string main_contact_person_job_title Contacts
Main contact person - job title
string main_contact_person_telephone Contacts sensible
Main contact person - telephone
string main_contact_person_mobile Contacts sensible
Main contact person - mobil
string main_contact_person_email Contacts sensible
Main contact person - email
string main_contact_person_fax Contacts sensible
Main contact person - fax
string bank_account_name Contacts sensible
Bank account - name
string bank_account_number Contacts sensible
Bank account - number
string bank_account_sort_code Contacts sensible
Bank account - sort code
string bank_account_bic Contacts sensible
Bank account - BIC
string bank_account_iban Contacts sensible
Bank account - IBAN
string email Contacts sensible
Email
string balance Contacts sensible
Balance
float credit_limit Contacts
Credit limit
float credit_days Contacts
Credit days
float has_unfinished_recurring_invoices Contacts
Has unfinished recurring invoices
integer journal_id Journals
Journal ID
string journal_lines_id Journals
Journal lines - ID
string transaction_id Journals
Transaction ID
string journal_lines_ledger_account_id Journals
Journal lines - ledger account ID
string created_at Journals
Created at
datetime updated_at Journals
Updated at
datetime deleted_at Journals
Deleted at
datetime journal_name Journals
Journal name
string transaction_name Journals
Transaction name
string transaction_type Journals
Transaction type
string reference Journals
Reference
string description Journals
Description
string journal_lines_ledger_account_name Journals
Journal lines - ledger account name
string journal_lines_details Journals
Journal lines - details
string journal_lines_debit Journals
Journal lines - debit
string journal_lines_credit Journals
Journal lines - credit
string journal_lines_include_on_tax_return Journals
Journal lines - include on tax return
integer journal_lines_tax_reconciled Journals
Journal lines - tax reconciled
integer journal_lines_cleared Journals
Journal lines - cleared
integer journal_lines_bank_reconciled Journals
Journal lines - bank reconciled
integer ledger_account_id Ledger Accounts
Ledger Account ID
string ledger_account_group_id Ledger Accounts
Ledger Account Group ID
string ledger_account_type_id Ledger Accounts
Ledger Account Type ID
string ledger_account_classification_id Ledger Accounts
Ledger Account Classification ID
string created_at Ledger Accounts
Created At
datetime updated_at Ledger Accounts
Updated At
datetime nominal_code Ledger Accounts
Nominal Code
string ledger_account_group_displayed_as Ledger Accounts
Ledger Account Group Displayed As
string ledger_account_type_displayed_as Ledger Accounts
Ledger Account Type Displayed As
string ledger_account_classification_displayed_as Ledger Accounts
Ledger Account Classification Displayed As
string product_id Products
Product ID
string sales_ledger_account_id Products
Sales ledger account ID
string purchase_ledger_account_id Products
Purchase ledger account ID
string usual_supplier_id Products
Usual supplier ID
string sales_tax_rate_id Products
Sales tax rate ID
string purchase_tax_rate_id Products
Purchase tax rate ID
string created_at Products
Created at
datetime updated_at Products
Updated at
datetime product_displayed_as Products
Product name
string item_code Products
Item code
string description Products
Description
string purchase_description Products
Purchase description
string sales_ledger_account_name Products
Sales ledger account name
string purchase_ledger_account_name Products
Purchase ledger account name
string sales_tax_rate_name Products
Sales tax rate name
string purchase_tax_rate_name Products
Purchase tax rate name
string usual_supplier_name Products
Usual supplier name
string cost_price Products
Cost price
float invoice_id Purchase Invoices
Invoice ID
string invoice_line_id Purchase Invoices
Invoice line - ID
string transaction_id Purchase Invoices
Transaction ID
string invoice_line_product_id Purchase Invoices
Invoice line - product ID
string invoice_line_service_id Purchase Invoices
Invoice line - service ID
string created_at Purchase Invoices
Created at
datetime updated_at Purchase Invoices
Updated at
datetime deleted_at Purchase Invoices
Deleted at
datetime date Purchase Invoices
Date
datetime due_date Purchase Invoices
Due date
datetime transaction_created_at Purchase Invoices
Transaction created at
datetime transaction_updated_at Purchase Invoices
Transaction updated at
datetime transaction_date Purchase Invoices
Transaction date
datetime invoice_name Purchase Invoices
Invoice name
string contact_name Purchase Invoices sensible
Contact name
string reference Purchase Invoices
Reference
string vendor_reference Purchase Invoices
Vendor reference
string currency Purchase Invoices
Currency
string status Purchase Invoices
Status
string last_paid Purchase Invoices
Last paid
string tax_calculation_method Purchase Invoices
Tax calculation method
string transaction_name Purchase Invoices
Transaction name
string transaction_type Purchase Invoices
Transaction type
string invoice_line_name Purchase Invoices
Invoice line - name
string invoice_line_product Purchase Invoices
Invoice line - product
string invoice_line_service Purchase Invoices
Invoice line - service
string invoice_line_ledger_account Purchase Invoices
Invoice line - ledger account
string total_quantity Purchase Invoices
Total quantity
float net_amount Purchase Invoices
Net amount
float tax_amount Purchase Invoices
Tax amount
float total_amount Purchase Invoices
Total amount
float payments_allocations_total_amount Purchase Invoices
Payments allocations total amount
float payments_allocations_total_discount Purchase Invoices
Payments allocations total discount
float total_paid Purchase Invoices
Total paid
float outstanding_amount Purchase Invoices
Outstanding amount
float exchange_rate Purchase Invoices
Exchange rate
float inverse_exchange_rate Purchase Invoices
Inverse exchange rate
float base_currency_net_amount Purchase Invoices
Base currency net amount
float base_currency_tax_amount Purchase Invoices
Base currency tax amount
float base_currency_total_amount Purchase Invoices
Base currency total amount
float base_currency_outstanding_amount Purchase Invoices
Base currency outstanding amount
float transaction_total Purchase Invoices
Transaction total
float invoice_line_quantity Purchase Invoices
Invoice line - quantity
float invoice_line_unit_price Purchase Invoices
Invoice line - unit price
float invoice_line_net_amount Purchase Invoices
Invoice line - net amount
float invoice_line_tax_amount Purchase Invoices
Invoice line - tax amount
float invoice_line_total_amount Purchase Invoices
Invoice line - total amount
float editable Purchase Invoices
Editable
integer tax_reconciled Purchase Invoices
Tax reconciled
integer transaction_deleted Purchase Invoices
Transaction deleted
integer invoice_line_unit_price_includes_tax Purchase Invoices
Invoice line - unit price includes tax
integer invoice_id Sales Invoices
Invoice ID
string invoice_line_id Sales Invoices
Invoice line - ID
string transaction_id Sales Invoices
Transaction ID
string invoice_line_product_id Sales Invoices
Invoice line - product ID
string invoice_line_service_id Sales Invoices
Invoice line - service ID
string created_at Sales Invoices
Created at
datetime updated_at Sales Invoices
Updated at
datetime deleted_at Sales Invoices
Deleted at
datetime due_date Sales Invoices
Due date
datetime last_paid Sales Invoices
Last paid
datetime transaction_created_at Sales Invoices
Transaction created at
datetime transaction_updated_at Sales Invoices
Transaction updated at
datetime transaction_date Sales Invoices
Transaction date
datetime invoice_name Sales Invoices
Invoice name
string invoice_number_prefix Sales Invoices
Invoice Number Prefix
string invoice_number Sales Invoices
Invoice Number
string contact_name Sales Invoices sensible
Contact name
string reference Sales Invoices
Reference
string currency Sales Invoices
Currency
string status Sales Invoices
Status
string tax_calculation_method Sales Invoices
Tax calculation method
string transaction_name Sales Invoices
Transaction name
string transaction_type Sales Invoices
Transaction type
string invoice_line_name Sales Invoices
Invoice line - name
string invoice_line_product Sales Invoices
Invoice line - product
string invoice_line_service Sales Invoices
Invoice line - service
string invoice_line_ledger_account Sales Invoices
Invoice line - ledger account
string main_address_line_1 Sales Invoices sensible
Main address - line 1
string main_address_line_2 Sales Invoices sensible
Main address - line 2
string main_address_city Sales Invoices
Main address - city
string main_address_postal_code Sales Invoices sensible
Main address - postal code
string main_address_country Sales Invoices
Main address - country
string main_address_region Sales Invoices
Main address - region
string delivery_address_line_1 Sales Invoices sensible
Delivery address - line 1
string delivery_address_line_2 Sales Invoices sensible
Delivery address - line 2
string delivery_address_city Sales Invoices
Delivery address - city
string delivery_address_postal_code Sales Invoices sensible
Delivery address - postal code
string delivery_address_country Sales Invoices
Delivery address - country
string delivery_address_region Sales Invoices
Delivery address - region
string total_quantity Sales Invoices
Total quantity
float shipping_net_amount Sales Invoices
Shipping net amount
float shipping_tax_amount Sales Invoices
Shipping tax amount
float shipping_total_amount Sales Invoices
Shipping total amount
float net_amount Sales Invoices
Net amount
float tax_amount Sales Invoices
Tax amount
float total_amount Sales Invoices
Total amount
float payments_allocations_total_amount Sales Invoices
Payments allocations total amount
float payments_allocations_total_discount Sales Invoices
Payments allocations total discount
float total_paid Sales Invoices
Total paid
float outstanding_amount Sales Invoices
Outstanding amount
float exchange_rate Sales Invoices
Exchange rate
float inverse_exchange_rate Sales Invoices
Inverse exchange rate
float total_discount_amount Sales Invoices
Total discount amount
float transaction_total Sales Invoices
Transaction total
float invoice_line_quantity Sales Invoices
Invoice line - quantity
float invoice_line_unit_price Sales Invoices
Invoice line - unit price
float invoice_line_net_amount Sales Invoices
Invoice line - net amount
float invoice_line_tax_amount Sales Invoices
Invoice line - tax amount
float invoice_line_total_amount Sales Invoices
Invoice line - total amount
float editable Sales Invoices
Editable
integer sent_by_email Sales Invoices
Sent by email
integer tax_reconciled Sales Invoices
Tax reconciled
integer transaction_deleted Sales Invoices
Transaction deleted
integer invoice_line_unit_price_includes_tax Sales Invoices
Invoice line - unit price includes tax
integer invoice_id Sales Invoices No Lines
Invoice ID
string transaction_id Sales Invoices No Lines
Transaction ID
string created_at Sales Invoices No Lines
Created at
datetime updated_at Sales Invoices No Lines
Updated at
datetime deleted_at Sales Invoices No Lines
Deleted at
datetime date Sales Invoices No Lines
Date
datetime due_date Sales Invoices No Lines
Due date
datetime transaction_created_at Sales Invoices No Lines
Transaction created at
datetime transaction_updated_at Sales Invoices No Lines
Transaction updated at
datetime transaction_date Sales Invoices No Lines
Transaction date
datetime invoice_name Sales Invoices No Lines
Invoice name
string invoice_number_prefix Sales Invoices No Lines
Invoice Number Prefix
string invoice_number Sales Invoices No Lines
Invoice Number
string contact_name Sales Invoices No Lines sensible
Contact name
string reference Sales Invoices No Lines
Reference
string last_paid Sales Invoices No Lines
Last paid
string currency Sales Invoices No Lines
Currency
string status Sales Invoices No Lines
Status
string tax_calculation_method Sales Invoices No Lines
Tax calculation method
string transaction_name Sales Invoices No Lines
Transaction name
string transaction_type Sales Invoices No Lines
Transaction type
string main_address_line_1 Sales Invoices No Lines sensible
Main address - line 1
string main_address_line_2 Sales Invoices No Lines sensible
Main address - line 2
string main_address_city Sales Invoices No Lines
Main address - city
string main_address_postal_code Sales Invoices No Lines sensible
Main address - postal code
string main_address_country Sales Invoices No Lines
Main address - country
string main_address_region Sales Invoices No Lines
Main address - region
string delivery_address_line_1 Sales Invoices No Lines sensible
Delivery address - line 1
string delivery_address_line_2 Sales Invoices No Lines sensible
Delivery address - line 2
string delivery_address_city Sales Invoices No Lines
Delivery address - city
string delivery_address_postal_code Sales Invoices No Lines sensible
Delivery address - postal code
string delivery_address_country Sales Invoices No Lines
Delivery address - country
string delivery_address_region Sales Invoices No Lines
Delivery address - region
string total_quantity Sales Invoices No Lines
Total quantity
float shipping_net_amount Sales Invoices No Lines
Shipping net amount
float shipping_tax_amount Sales Invoices No Lines
Shipping tax amount
float shipping_total_amount Sales Invoices No Lines
Shipping total amount
float net_amount Sales Invoices No Lines
Net amount
float tax_amount Sales Invoices No Lines
Tax amount
float total_amount Sales Invoices No Lines
Total amount
float payments_allocations_total_amount Sales Invoices No Lines
Payments allocations total amount
float payments_allocations_total_discount Sales Invoices No Lines
Payments allocations total discount
float total_paid Sales Invoices No Lines
Total paid
float outstanding_amount Sales Invoices No Lines
Outstanding amount
float exchange_rate Sales Invoices No Lines
Exchange rate
float inverse_exchange_rate Sales Invoices No Lines
Inverse exchange rate
float total_discount_amount Sales Invoices No Lines
Total discount amount
float transaction_total Sales Invoices No Lines
Transaction total
float editable Sales Invoices No Lines
Editable
integer sent Sales Invoices No Lines
Sent
integer sent_by_email Sales Invoices No Lines
Sent by email
integer tax_reconciled Sales Invoices No Lines
Tax reconciled
integer transaction_deleted Sales Invoices No Lines
Transaction deleted
integer service_id Services
Service ID
string sales_ledger_account_id Services
Sales ledger account ID
string purchase_ledger_account_id Services
Purchase ledger account ID
string usual_supplier_id Services
Usual supplier ID
string sales_tax_rate_id Services
Sales tax rate ID
string purchase_tax_rate_id Services
Purchase tax rate ID
string created_at Services
Created at
datetime updated_at Services
Updated at
datetime service_displayed_as Services
Service name
string item_code Services
Item code
string description Services
Description
string purchase_description Services
Purchase description
string sales_ledger_account_name Services
Sales ledger account name
string purchase_ledger_account_name Services
Purchase ledger account name
string sales_tax_rate_name Services
Sales tax rate name
string purchase_tax_rate_name Services
Purchase tax rate name
string usual_supplier_name Services
Usual supplier name
string cost_price Services
Cost price
float oss_service Services
OSS service
integer used_on_recurring_invoice Services
Used on recurring invoice
integer transaction_id Transactions
Transaction ID
string contact_id Transactions
Contact ID
string origin_id Transactions
Origin ID
string audit_trail_id Transactions
Audit Trail ID
string created_at Transactions
Created at
datetime updated_at Transactions
Updated at
datetime origin_due_date Transactions
Origin due date
datetime transaction_name Transactions
Transaction name
string reference Transactions
Reference
string contact_name Transactions sensible
Contact name
string transaction_type Transactions
Transaction type
string origin_name Transactions
Origin name
string currency Transactions
Currency
string origin_status Transactions
Origin status
string total_in_transaction_currency Transactions
Total in transaction currency
float origin_outstanding_amount Transactions
Origin outstanding amount
float deleted Transactions
Deleted
integer origin_sent Transactions
Origin sent
integer number_of_attachments Transactions
Number of attachments
integer