batch_payment: Odoo itgen_odoo_batch_payment
read only per partition
- Catalog:
Odoo - Schema:
account - Label: itgen_odoo_batch_payment
Batch Payment
Can only retrieve data.
Table Columns
The columns of the table batch_payment are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.
| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
activity_ |
varchar2 |
||||
activity_ |
varchar2 |
||||
activity_ |
datetime |
Next Activity Deadline | |||
activity_ |
varchar2 |
Activity Exception Decoration | Type of the exception activity on record. | ||
activity_ |
varchar2 |
Icon | Icon to indicate an exception activity. | ||
activity_ |
varchar2 |
||||
activity_ |
varchar2 |
Activity State | Status based on activities Overdue: Due date is already passed Today: Activity date is today Planned: Future activities. | ||
activity_ |
varchar2 |
Next Activity Summary | |||
activity_ |
varchar2 |
Activity Type Icon | Font awesome icon e.g. fa-tasks | ||
activity_ |
varchar2 |
||||
activity_ |
varchar2 |
||||
activity_ |
varchar2 |
||||
activity_ |
varchar2 |
||||
amount |
numeric |
Amount | |||
amount_ |
numeric |
Amount Residual | |||
amount_ |
numeric |
Amount Residual Currency | |||
available_ |
varchar2 |
||||
batch_ |
varchar2 |
Batch Type | |||
company_ |
varchar2 |
||||
company_ |
varchar2 |
||||
create_ |
datetime |
Created on | |||
create_ |
varchar2 |
||||
create_ |
varchar2 |
||||
currency_ |
varchar2 |
||||
currency_ |
varchar2 |
||||
date |
datetime |
Date | |||
display_ |
varchar2 |
Display Name | |||
export_ |
varbinary |
File | Export file related to this batch | ||
export_ |
datetime |
Generation Date | Creation date of the related export file. | ||
export_ |
varchar2 |
File Name | Name of the export file generated for this batch | ||
file_ |
boolean |
File Generation Enabled | Whether or not this batch payment should display the 'Generate File' button instead of 'Print' in form view. | ||
has_ |
boolean |
Has Message | |||
id |
int32 |
ID | |||
journal_ |
varchar2 |
||||
journal_ |
varchar2 |
||||
message_ |
int32 |
Attachment Count | |||
message_ |
varchar2 |
||||
message_ |
boolean |
Message Delivery error | If checked, some messages have a delivery error. | ||
message_ |
int32 |
Number of errors | Number of messages with delivery error | ||
message_ |
boolean |
SMS Delivery error | If checked, some messages have a delivery error. | ||
message_ |
varchar2 |
||||
message_ |
boolean |
Is Follower | |||
message_ |
varchar2 |
||||
message_ |
varchar2 |
||||
message_ |
boolean |
Action Needed | If checked, new messages require your attention. | ||
message_ |
int32 |
Number of Actions | Number of messages which requires an action | ||
message_ |
varchar2 |
||||
my_ |
datetime |
My Activity Deadline | |||
name |
varchar2 |
Reference | |||
payment_ |
varchar2 |
||||
payment_ |
varchar2 |
Code | |||
payment_ |
varchar2 |
The payment method used by the payments in this batch. | |||
payment_ |
varchar2 |
The payment method used by the payments in this batch. | |||
sct_ |
boolean |
SCT Batch Booking | Request batch booking from the bank for the related bank statements. | ||
sct_ |
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 |
varchar2 |
State | |||
website_ |
varchar2 |
Website communication history | |||
write_ |
datetime |
Last Updated on | |||
write_ |
varchar2 |
||||
write_ |
varchar2 |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: