batch_payment |
Batch Payment
Catalog: Odoo
Schema: account
The data in this table is partitioned per value of the column.
This is a read-only table. The Odoo API may not support changing the data or the Invantive SQL driver for Odoo does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Odoo API.
Table Columns
The columns of the table batch_payment are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
activity_calendar_event_id_label |
string |
|
☐ |
|
activity_calendar_event_id |
string |
|
☐ |
|
activity_date_deadline |
datetime |
Next Activity Deadline |
☐ |
|
activity_exception_decoration |
string |
Activity Exception Decoration |
☐ |
Type of the exception activity on record. |
activity_exception_icon |
string |
Icon |
☐ |
Icon to indicate an exception activity. |
activity_ids |
string |
|
☐ |
|
activity_state |
string |
Activity State |
☐ |
Status based on activitiesOverdue: Due date is already passedToday: Activity date is todayPlanned: Future activities. |
activity_summary |
string |
Next Activity Summary |
☐ |
|
activity_type_icon |
string |
Activity Type Icon |
☐ |
Font awesome icon e.g. fa-tasks |
activity_type_id_label |
string |
|
☐ |
|
activity_type_id |
string |
|
☐ |
|
activity_user_id_label |
string |
|
☐ |
|
activity_user_id |
string |
|
☐ |
|
amount_residual_currency |
decimal |
Amount Residual Currency |
☐ |
|
amount_residual |
decimal |
Amount Residual |
☐ |
|
amount |
decimal |
Amount |
☐ |
|
available_payment_method_ids |
string |
|
☐ |
|
batch_type |
string |
Batch Type |
☑ |
|
company_currency_id_label |
string |
|
☐ |
|
company_currency_id |
string |
|
☐ |
|
create_date |
datetime |
Created on |
☐ |
|
create_uid_label |
string |
|
☐ |
|
create_uid |
string |
|
☐ |
|
currency_id_label |
string |
|
☐ |
|
currency_id |
string |
|
☐ |
|
date |
datetime |
Date |
☑ |
|
display_name |
string |
Display Name |
☐ |
|
export_file_create_date |
datetime |
Generation Date |
☐ |
Creation date of the related export file. |
export_file |
byte[] |
File |
☐ |
Export file related to this batch |
export_filename |
string |
File Name |
☐ |
Name of the export file generated for this batch |
file_generation_enabled |
boolean |
File Generation Enabled |
☐ |
Whether or not this batch payment should display the 'Generate File' button instead of 'Print' in form view. |
has_message |
boolean |
Has Message |
☐ |
|
id |
int32 |
ID |
☐ |
|
journal_id_label |
string |
|
☐ |
|
journal_id |
string |
|
☐ |
|
message_attachment_count |
int32 |
Attachment Count |
☐ |
|
message_follower_ids |
string |
|
☐ |
|
message_has_error_counter |
int32 |
Number of errors |
☐ |
Number of messages with delivery error |
message_has_error |
boolean |
Message Delivery error |
☐ |
If checked, some messages have a delivery error. |
message_has_sms_error |
boolean |
SMS Delivery error |
☐ |
If checked, some messages have a delivery error. |
message_ids |
string |
|
☐ |
|
message_is_follower |
boolean |
Is Follower |
☐ |
|
message_main_attachment_id_label |
string |
|
☐ |
|
message_main_attachment_id |
string |
|
☐ |
|
message_needaction_counter |
int32 |
Number of Actions |
☐ |
Number of messages which requires an action |
message_needaction |
boolean |
Action Needed |
☐ |
If checked, new messages require your attention. |
message_partner_ids |
string |
|
☐ |
|
my_activity_date_deadline |
datetime |
My Activity Deadline |
☐ |
|
name |
string |
Reference |
☑ |
|
payment_ids |
string |
|
☐ |
|
payment_method_code |
string |
Code |
☐ |
|
payment_method_id_label |
string |
|
☐ |
The payment method used by the payments in this batch. |
payment_method_id |
string |
|
☐ |
The payment method used by the payments in this batch. |
sct_batch_booking |
boolean |
SCT Batch Booking |
☐ |
Request batch booking from the bank for the related bank statements. |
sct_generic |
boolean |
Sct Generic |
☐ |
Technical feature used during the file creation. A SEPA message is said to be 'generic' if it cannot be considered as a standard european credit transfer. That is if the bank journal is not in €, a transaction is not in € or a payee is not identified by an IBAN account number. |
state |
string |
State |
☐ |
|
website_message_ids |
string |
|
☐ |
Website communication history |
write_date |
datetime |
Last Updated on |
☐ |
|
write_uid_label |
string |
|
☐ |
|
write_uid |
string |
|
☐ |
|
01-03-2023 15:29 Version 22.1.135-BETA+3826