ㅋㅋㅋㅋ
Tables (49)
account_account
- id — integer — NOT NULL
- currency_id — integer
- create_uid — integer — Created
- write_uid — integer — Last
- account_type — character — NOT NULL — Type
- name — jsonb — NOT NULL — Account
- description — jsonb — Description
- code_store — jsonb — Code
- note — text — Internal
- active — boolean — Active
- reconcile — boolean — Allow
- non_trade — boolean — Non
- create_date — timestamp — Created
- write_date — timestamp — Last
- disallowed_expenses_category_id — integer — Disallowed
- create_asset — character — NOT NULL — Create
- multiple_assets_per_line — boolean — Multiple
account_account_account_asset_rel
- account_account_id — integer — NOT NULL
- account_asset_id — integer — NOT NULL
account_account_res_company_rel
- account_account_id — integer — NOT NULL
- res_company_id — integer — NOT NULL
account_account_tag_account_move_line_rel
- account_move_line_id — integer — NOT NULL
- account_account_tag_id — integer — NOT NULL
account_account_tag_product_template_rel
- product_template_id — integer — NOT NULL
- account_account_tag_id — integer — NOT NULL
account_analytic_account
- id — integer — NOT NULL
- plan_id — integer — NOT NULL
- root_plan_id — integer — Root
- company_id — integer — Company
- partner_id — integer — Customer
- create_uid — integer — Created
- write_uid — integer — Last
- code — character — Reference
- name — jsonb — NOT NULL — Analytic
- active — boolean — Active
- create_date — timestamp — Created
- write_date — timestamp — Last
account_analytic_account_account_transfer_model_line_rel
- account_transfer_model_line_id — integer — NOT NULL
- account_analytic_account_id — integer — NOT NULL
account_analytic_applicability
- id — integer — NOT NULL
- analytic_plan_id — integer
- company_id — integer — Company
- create_uid — integer — Created
- write_uid — integer — Last
- business_domain — character — NOT NULL — Domain
- applicability — character — NOT NULL — Applicability
- create_date — timestamp — Created
- write_date — timestamp — Last
- product_categ_id — integer — Product
- account_prefix — character — Financial
account_analytic_distribution_model
- id — integer — NOT NULL
- sequence — integer
- partner_id — integer — Partner
- partner_category_id — integer — Partner
- company_id — integer — Company
- create_uid — integer — Created
- write_uid — integer — Last
- analytic_distribution — jsonb — Analytic
- create_date — timestamp — Created
- write_date — timestamp — Last
- product_id — integer — Product
- product_categ_id — integer — Product
- account_prefix — character — Accounts
account_analytic_line
- id — integer — NOT NULL
- account_id — integer
- product_uom_id — integer — Unit
- partner_id — integer — Partner
- user_id — integer — User
- company_id — integer — NOT NULL — Company
- currency_id — integer — Currency
- create_uid — integer — Created
- write_uid — integer — Last
- name — character — NOT NULL — Description
- category — character — Category
- date — date — NOT NULL — Date
- amount — numeric — NOT NULL — Amount
- create_date — timestamp — Created
- write_date — timestamp — Last
- unit_amount — double — Quantity
- product_id — integer — Product
- general_account_id — integer — Financial
- journal_id — integer — Financial
- move_line_id — integer — Journal
- code — character — Code
- ref — character — Ref.
account_analytic_plan
- id — integer — NOT NULL
- parent_id — integer
- color — integer — Color
- sequence — integer — Sequence
- create_uid — integer — Created
- write_uid — integer — Last
- parent_path — character — Parent
- complete_name — character — Complete
- name — jsonb — NOT NULL — Name
- default_applicability — jsonb — Default
- description — text — Description
- create_date — timestamp — Created
- write_date — timestamp — Last
account_asset
- id — integer — NOT NULL
- company_id — integer — NOT NULL
- currency_id — integer — Currency
- method_number — integer — Duration
- account_asset_id — integer — Fixed
- asset_group_id — integer — Asset
- account_depreciation_id — integer — Depreciation
- account_depreciation_expense_id — integer — Expense
- journal_id — integer — Journal
- model_id — integer — Model
- parent_id — integer — Parent
- create_uid — integer — Created
- write_uid — integer — Last
- name — character — NOT NULL — Asset
- state — character — Status
- method — character — Method
- method_period — character — Number
- prorata_computation_type — character — NOT NULL — Computation
- prorata_date — date — NOT NULL — Prorata
- acquisition_date — date — Acquisition
- disposal_date — date — Disposal
- analytic_distribution — jsonb — Analytic
- asset_properties_definition — jsonb — Model
- asset_properties — jsonb — Properties
- original_value — numeric — Original
- book_value — numeric — Book
- salvage_value — numeric — Not
- non_deductible_tax_value — numeric — Non
- already_depreciated_amount_import — numeric — Already
- net_gain_on_sale — numeric — Net
- active — boolean — Active
- create_date — timestamp — Created
- write_date — timestamp — Last
- method_progress_factor — double — Declining
- salvage_value_pct — double — Not
- asset_paused_days — double — Asset
account_asset_group
- id — integer — NOT NULL
- company_id — integer
- create_uid — integer — Created
- write_uid — integer — Last
- name — character — Name
- create_date — timestamp — Created
- write_date — timestamp — Last
account_auto_reconcile_wizard
- id — integer — NOT NULL
- company_id — integer — NOT NULL
- create_uid — integer — Created
- write_uid — integer — Last
- search_mode — character — NOT NULL — Reconcile
- from_date — date — From
- to_date — date — NOT NULL — To
- create_date — timestamp — Created
- write_date — timestamp — Last
account_auto_reconcile_wizard_account_move_line_rel
- account_auto_reconcile_wizard_id — integer — NOT NULL
- account_move_line_id — integer — NOT NULL
account_auto_reconcile_wizard_res_partner_rel
- account_auto_reconcile_wizard_id — integer — NOT NULL
- res_partner_id — integer — NOT NULL
account_automatic_entry_wizard_account_move_line_rel
- account_automatic_entry_wizard_id — integer — NOT NULL
- account_move_line_id — integer — NOT NULL
account_autopost_bills_wizard
- id — integer — NOT NULL
- partner_id — integer
- nb_unmodified_bills — integer — Number
- create_uid — integer — Created
- write_uid — integer — Last
- create_date — timestamp — Created
- write_date — timestamp — Last
account_bank_selection
- id — integer — NOT NULL
- account_online_link_id — integer
- selected_account — integer — Selected
- create_uid — integer — Created
- write_uid — integer — Last
- create_date — timestamp — Created
- write_date — timestamp — Last
account_bank_statement
- id — integer — NOT NULL
- company_id — integer
- currency_id — integer — Currency
- journal_id — integer — Journal
- create_uid — integer — Created
- write_uid — integer — Last
- name — character — Reference
- reference — character — External
- first_line_index — character — First
- date — date — Date
- balance_start — numeric — Starting
- balance_end — numeric — Computed
- balance_end_real — numeric — Ending
- is_complete — boolean — Is
- create_date — timestamp — Created
- write_date — timestamp — Last
- message_main_attachment_id — integer — Main
- extract_attachment_id — integer — Extract
- extract_state — character — Extract
- extract_status — character — Extract
- extract_document_uuid — character — ID
- is_in_extractable_state — boolean — Is
- extract_state_processed — boolean — Extract
account_bank_statement_ir_attachment_rel
- account_bank_statement_id — integer — NOT NULL
- ir_attachment_id — integer — NOT NULL
account_bank_statement_line_transient
- id — integer — NOT NULL
- sequence — integer
- journal_id — integer — Journal
- online_account_id — integer — Account
- company_id — integer — Company
- foreign_currency_id — integer — Foreign
- create_uid — integer — Created
- write_uid — integer — Last
- online_transaction_identifier — character — Online
- payment_ref — character — Payment
- account_number — character — Account
- partner_name — character — Partner
- state — character — State
- date — date — Date
- transaction_details — jsonb — Transaction
- amount — numeric — Amount
- amount_currency — numeric — Amount
- create_date — timestamp — Created
- write_date — timestamp — Last
account_cash_rounding
- id — integer — NOT NULL
- create_uid — integer
- write_uid — integer — Last
- strategy — character — NOT NULL — Rounding
- rounding_method — character — NOT NULL — Rounding
- name — jsonb — NOT NULL — Name
- profit_account_id — jsonb — Profit
- loss_account_id — jsonb — Loss
- create_date — timestamp — Created
- write_date — timestamp — Last
- rounding — double — NOT NULL — Rounding
account_change_lock_date
- id — integer — NOT NULL
- company_id — integer — NOT NULL
- create_uid — integer — Created
- write_uid — integer — Last
- exception_applies_to — character — NOT NULL — Exception
- exception_duration — character — NOT NULL — Exception
- exception_reason — character — Exception
- fiscalyear_lock_date — date — Lock
- tax_lock_date — date — Lock
- sale_lock_date — date — Lock
- purchase_lock_date — date — Lock
- hard_lock_date — date — Hard
- create_date — timestamp — Created
- write_date — timestamp — Last
account_disallowed_expenses_category
- id — integer — NOT NULL
- company_id — integer
- create_uid — integer — Created
- write_uid — integer — Last
- code — character — NOT NULL — Code
- name — jsonb — NOT NULL — Name
- active — boolean — Active
- create_date — timestamp — Created
- write_date — timestamp — Last
account_disallowed_expenses_rate
- id — integer — NOT NULL
- category_id — integer — NOT NULL
- company_id — integer — NOT NULL — Company
- create_uid — integer — Created
- write_uid — integer — Last
- date_from — date — NOT NULL — Start
- create_date — timestamp — Created
- write_date — timestamp — Last
- rate — double — NOT NULL — Deductibility
account_duplicate_transaction_wizard
- id — integer — NOT NULL
- journal_id — integer
- create_uid — integer — Created
- write_uid — integer — Last
- date — date — Starting
- create_date — timestamp — Created
- write_date — timestamp — Last
account_financial_year_op
- id — integer — NOT NULL
- company_id — integer — NOT NULL
- create_uid — integer — Created
- write_uid — integer — Last
- create_date — timestamp — Created
- write_date — timestamp — Last
account_fiscal_position
- id — integer — NOT NULL
- sequence — integer
- company_id — integer — NOT NULL — Company
- country_id — integer — Country
- country_group_id — integer — Country
- create_uid — integer — Created
- write_uid — integer — Last
- zip_from — character — Zip
- zip_to — character — Zip
- foreign_vat — character — Foreign
- name — jsonb — NOT NULL — Fiscal
- note — jsonb — Notes
- active — boolean — Active
- auto_apply — boolean — Detect
- vat_required — boolean — VAT
- is_domestic — boolean — Is
- create_date — timestamp — Created
- write_date — timestamp — Last
account_fiscal_position_account
- id — integer — NOT NULL
- position_id — integer — NOT NULL
- company_id — integer — Company
- account_src_id — integer — NOT NULL — Account
- account_dest_id — integer — NOT NULL — Account
- create_uid — integer — Created
- write_uid — integer — Last
- create_date — timestamp — Created
- write_date — timestamp — Last
account_fiscal_position_account_tax_rel
- account_fiscal_position_id — integer — NOT NULL
- account_tax_id — integer — NOT NULL
account_fiscal_position_res_country_state_rel
- account_fiscal_position_id — integer — NOT NULL
- res_country_state_id — integer — NOT NULL
account_followup_followup_line
- id — integer — NOT NULL
- delay — integer — NOT NULL
- company_id — integer — NOT NULL — Company
- mail_template_id — integer — Mail
- sms_template_id — integer — Sms
- activity_type_id — integer — Activity
- create_uid — integer — Created
- write_uid — integer — Last
- activity_summary — character — Summary
- activity_default_responsible_type — character — NOT NULL — Responsible
- name — jsonb — NOT NULL — Description
- activity_note — text — Note
- send_email — boolean — Email
- join_invoices — boolean — Attach
- send_sms — boolean — SMS
- create_activity — boolean — Schedule
- auto_execute — boolean — Automatic
- create_date — timestamp — Created
- write_date — timestamp — Last
- send_letter — boolean — Letter
account_followup_followup_line_res_users_rel
- account_followup_followup_line_id — integer — NOT NULL
- res_users_id — integer — NOT NULL
account_followup_manual_reminder_ir_attachment_rel
- account_followup_manual_reminder_id — integer — NOT NULL
- ir_attachment_id — integer — NOT NULL
account_full_reconcile
- id — integer — NOT NULL
- create_uid — integer
- write_uid — integer — Last
- create_date — timestamp — Created
- write_date — timestamp — Last
account_group
- id — integer — NOT NULL
- parent_id — integer
- company_id — integer — NOT NULL — Company
- create_uid — integer — Created
- write_uid — integer — Last
- code_prefix_start — character — Code
- code_prefix_end — character — Code
- name — jsonb — NOT NULL — Name
- create_date — timestamp — Created
- write_date — timestamp — Last
- ::character — varying))::text)))
account_import_summary
- id — integer — NOT NULL
- create_uid — integer
- write_uid — integer — Last
- import_summary_name — character — Import
- create_date — timestamp — Created
- write_date — timestamp — Last
account_import_summary_account_journal_rel
- account_import_summary_id — integer — NOT NULL
- account_journal_id — integer — NOT NULL
account_import_summary_res_partner_rel
- account_import_summary_id — integer — NOT NULL
- res_partner_id — integer — NOT NULL
account_invoice_transaction_rel
- invoice_id — integer — NOT NULL
- transaction_id — integer — NOT NULL
account_journal_account_journal_group_rel
- account_journal_group_id — integer — NOT NULL
- account_journal_id — integer — NOT NULL
account_loan
- id — integer — NOT NULL
- company_id — integer — NOT NULL
- duration — integer — Duration
- long_term_account_id — integer — Long
- short_term_account_id — integer — Short
- expense_account_id — integer — Expense
- journal_id — integer — Journal
- asset_group_id — integer — Asset
- create_uid — integer — Created
- write_uid — integer — Last
- display_name — character — Loan
- name — character — NOT NULL — Name
- state — character — NOT NULL — Status
- date — date — Loan
- skip_until_date — date — Skip
- loan_properties — jsonb — Properties
- amount_borrowed — numeric — Amount
- interest — numeric — Interest
- active — boolean — Active
- create_date — timestamp — Created
- write_date — timestamp — Last
account_loan_close_wizard
- id — integer — NOT NULL
- loan_id — integer — NOT NULL
- create_uid — integer — Created
- write_uid — integer — Last
- date — date — NOT NULL — Close
- create_date — timestamp — Created
- write_date — timestamp — Last
account_loan_compute_wizard
- id — integer — NOT NULL
- loan_id — integer — NOT NULL
- loan_term — integer — NOT NULL — Loan
- create_uid — integer — Created
- write_uid — integer — Last
- payment_end_of_month — character — NOT NULL — Payment
- compounding_method — character — NOT NULL — Compounding
- start_date — date — NOT NULL — Start
- first_payment_date — date — NOT NULL — First
- loan_amount — numeric — NOT NULL — Loan
- create_date — timestamp — Created
- write_date — timestamp — Last
- interest_rate — double — NOT NULL — Interest
account_loan_line
- id — integer — NOT NULL
- loan_id — integer — NOT NULL
- create_uid — integer — Created
- write_uid — integer — Last
- date — date — NOT NULL — Date
- principal — numeric — Principal
- interest — numeric — Interest
- payment — numeric — Payment
- long_term_theoretical_balance — numeric — Long-Term
- short_term_theoretical_balance — numeric — Short-Term
- create_date — timestamp — Created
- write_date — timestamp — Last
account_lock_exception
- id — integer — NOT NULL
- company_id — integer — NOT NULL
- user_id — integer — User
- create_uid — integer — Created
- write_uid — integer — Last
- reason — character — Reason
- lock_date_field — character — NOT NULL — Lock
- lock_date — date — Changed
- company_lock_date — date — Original
- active — boolean — Active
- end_datetime — timestamp — End
- create_date — timestamp — Created
- write_date — timestamp — Last
account_merge_wizard
- id — integer — NOT NULL
- create_uid — integer
- write_uid — integer — Last
- is_group_by_name — boolean — Group
- create_date — timestamp — Created
- write_date — timestamp — Last
account_merge_wizard_line
- id — integer — NOT NULL
- wizard_id — integer — NOT NULL
- sequence — integer — Sequence
- account_id — integer — Account
- create_uid — integer — Created
- write_uid — integer — Last
- grouping_key — character — Grouping
- display_type — character — NOT NULL — Display
- is_selected — boolean — Is
- create_date — timestamp — Created
- write_date — timestamp — Last