Bank Statement TXT/CSV Import (Base)

• default_sheet_mapping_id Many2one → account.statement.import.sheet.mapping
  comodel_name='account.statement.import.sheet.mapping'

No public methods.

• sheet_mapping_id Many2one → account.statement.import.sheet.mapping
  comodel_name='account.statement.import.sheet.mapping' default=<expr> string='Sheet mapping'

No public methods.

• amount_column Char
  help="Amount of transaction in journal's currency"
• amount_column Char
  help='Used if amount type is "Simple value" or "Absolute value"\nAmount of transaction in journal\'s currency\nSome statement formats use credit/debit columns' string='Amount column'
• amount_credit_column Char
  help="Credit amount of transaction in journal's currency" string='Credit amount column'
• amount_debit_column Char
  help="Debit amount of transaction in journal's currency" string='Debit amount column'
• amount_inverse_sign Boolean
  help='In some cases such as in credit card statements the amounts are expressed in the inverse sign. By setting this flag during the upload the amounts will be inverted in sign.' string='Inverse sign of amount'
• amount_type Selection
  default='simple_value' help='Simple value: use igned amount in amount column\nAbsolute Value: use a same column for debit and credit\n(absolute value + indicate sign)\nDistinct Credit/debit Column: use a distinct column for debit and credit' required=True selection=[('simple_value', 'Simple value'), ('absolute_value', 'Absolute value'), ('distinct_credit_debit', 'Distinct Credit/debit Column')] string='Amount type'
• balance_column Char
  help="Balance after transaction in journal's currency"
• bank_account_column Char
  help="Partner's bank account"
• bank_name_column Char
  help="Partner's bank"
• credit_value Char
  default='C' help="Value of debit/credit column that indicates if it's a credit"
• currency_column Char
  help='In case statement is multi-currency, column to get currency of transaction from'
• debit_credit_column Char
  help='Used if amount type is "Absolute value"\nSome statement formats use absolute amount value and indicate sign\nof the transaction by specifying if it was a debit or a credit one' string='Debit/credit column'
• debit_value Char
  default='D' help="Value of debit/credit column that indicates if it's a debit"
• delimiter Selection
  default='comma' selection=[('dot', 'dot (.)'), ('comma', 'comma (,)'), ('semicolon', 'semicolon (;)'), ('tab', 'tab'), ('space', 'space'), ('n/a', 'N/A')]
• description_column Char
• file_encoding Selection
  default='utf-8' selection=[('utf-8', 'UTF-8'), ('utf-8-sig', 'UTF-8 (with BOM)'), ('utf-16', 'UTF-16'), ('utf-16-sig', 'UTF-16 (with BOM)'), ('windows-1252', 'Western (Windows-1252)'), ('iso-8859-1', 'Western (Latin-1 / ISO 8859-1)'), ('iso-8859-2', 'Central European (Latin-2 / ISO 8859-2)'), ('iso-8859-4', 'Baltic (Latin-4 / ISO 8859-4)'), ('big5', 'Traditional Chinese (big5)'), ('gb18030', 'Unified Chinese (gb18030)'), ('shift_jis', 'Japanese (Shift JIS)'), ('windows-1251', 'Cyrillic (Windows-1251)'), ('koi8_r', 'Cyrillic (KOI8-R)'), ('koi8_u', 'Cyrillic (KOI8-U)')] string='Encoding'
• float_decimal_sep Selection
  default='comma' help="When the separator is 'none', the value will be shifted according to the currency decimals. For example, 12345 will be converted to 123.45" selection=[('dot', 'dot (.)'), ('comma', 'comma (,)'), ('none', 'none')] string='Decimals Separator'
• float_thousands_sep Selection
  default='dot' selection=[('dot', 'dot (.)'), ('comma', 'comma (,)'), ('quote', "quote (')"), ('none', 'none')] string='Thousands Separator'
• footer_lines_skip_count Integer
  default='0' help='Set the Footer lines number.Used in some csv/xlsx file that integrate meta data inlast lines.' string='Footer lines skip count'
• header_lines_skip_count Integer
  default='0' help='Set the Header lines number.' string='Header lines skip count'
• name Char
  required=True
• no_header Boolean
  help='When this occurs please indicate the column number in the Columns section instead of the column name, considering that the first column is 0' string='File does not contain header line'
• notes_column Char
• offset_column Integer
  default=0 help='Columns to ignore before starting to parse'
• original_amount_column Char
  help='In case statement provides original currency for transactions with automatic currency conversion, column to get original transaction amount in original transaction currency from'
• original_currency_column Char
  help='In case statement provides original currency for transactions with automatic currency conversion, column to get original currency of transaction from'
• partner_name_column Char
• quotechar Char
  default='"' size=1 string='Text qualifier'
• reference_column Char
• skip_empty_lines Boolean
  default=True help='Allows to skip empty lines'
• timestamp_column Char
  required=True
• timestamp_format Char
  required=True
• transaction_id_column Char
  string='Unique transaction ID column'

• onchange_decimal_separator(self)
  @api.onchange('float_decimal_sep')
• onchange_thousands_separator(self)
  @api.onchange('float_thousands_sep')

No new fields.

• parse(self, data_file, mapping, filename)
  @api.model
  Parse an uploaded sheet file into account statement import data. :param bytes data_file: Uploaded file content. :param recordset mapping: Sheet mapping used to read columns and formats. :param str filename: Original upload filename :return: Tuple with currency code, account number, and statement values. :rtype: tuple(str, str, list[dict])
• parse_header_csv(self, rows, mapping)
  @api.model
  Return the CSV header row after applying configured skips and offset.