account_reconcile_model

-1 rows


Description

Preset to create journal entries during a invoices and payments matching

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('account_reconcile_model_id_seq'::regclass)
account_journal_account_reconcile_model_rel.account_reconcile_model_id account_journal_account_reconci_account_reconcile_model_id_fkey C
account_move_line.reconcile_model_id account_move_line_reconcile_model_id_fkey N
account_reconcile_model_line.model_id account_reconcile_model_line_model_id_fkey C
account_reconcile_model_partner_mapping.model_id account_reconcile_model_partner_mapping_model_id_fkey C
account_reconcile_model_res_partner_category_rel.account_reconcile_model_id account_reconcile_model_res_pa_account_reconcile_model_id_fkey1 C
account_reconcile_model_res_partner_rel.account_reconcile_model_id account_reconcile_model_res_par_account_reconcile_model_id_fkey C
sequence int4 10 null

Sequence
company_id int4 10 null
res_company.id account_reconcile_model_company_id_fkey R

Company
past_months_limit int4 10 √ null

Search Months Limit
create_uid int4 10 √ null
res_users.id account_reconcile_model_create_uid_fkey N

Created by
write_uid int4 10 √ null
res_users.id account_reconcile_model_write_uid_fkey N

Last Updated by
rule_type varchar 2147483647 null

Type
matching_order varchar 2147483647 null

Matching Order
match_nature varchar 2147483647 null

Amount Type
match_amount varchar 2147483647 √ null

Amount Condition
match_label varchar 2147483647 √ null

Label
match_label_param varchar 2147483647 √ null

Label Parameter
match_note varchar 2147483647 √ null

Note
match_note_param varchar 2147483647 √ null

Note Parameter
match_transaction_type varchar 2147483647 √ null

Transaction Type
match_transaction_type_param varchar 2147483647 √ null

Transaction Type Parameter
payment_tolerance_type varchar 2147483647 null

Payment Tolerance Type
decimal_separator varchar 2147483647 √ null

Decimal Separator
name jsonb 2147483647 null

Name
active bool 1 √ null

Active
auto_reconcile bool 1 √ null

Auto-validate
to_check bool 1 √ null

To Check
match_text_location_label bool 1 √ null

Match Text Location Label
match_text_location_note bool 1 √ null

Match Text Location Note
match_text_location_reference bool 1 √ null

Match Text Location Reference
match_same_currency bool 1 √ null

Same Currency
allow_payment_tolerance bool 1 √ null

Payment Tolerance
match_partner bool 1 √ null

Partner is Set
create_date timestamp 29,6 √ null

Created on
write_date timestamp 29,6 √ null

Last Updated on
match_amount_min float8 17,17 √ null

Amount Min Parameter
match_amount_max float8 17,17 √ null

Amount Max Parameter
payment_tolerance_param float8 17,17 √ null

Gap

Indexes

Constraint Name Type Sort Column(s)
account_reconcile_model_pkey Primary key Asc id
account_reconcile_model_name_unique Must be unique Asc/Asc name + company_id

Relationships

Close relationships within degrees of separation