ㅋㅋㅋㅋ

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