payment |
Payments
Catalog: Odoo
Schema: account
Documentation:
Populate factory part for account.payment.
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 payment are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
access_token |
string |
Security Token |
☐ |
|
access_url |
string |
Portal Access URL |
☐ |
Customer Portal URL |
access_warning |
string |
Access warning |
☐ |
|
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 |
|
☐ |
|
always_tax_exigible |
boolean |
Always Tax Exigible |
☐ |
|
amount_available_for_refund |
decimal |
Amount Available For Refund |
☐ |
|
amount_company_currency_signed |
decimal |
Amount Company Currency Signed |
☐ |
|
amount_paid |
decimal |
Amount paid |
☐ |
|
amount_residual_signed |
decimal |
Amount Due Signed |
☐ |
|
amount_residual |
decimal |
Amount Due |
☐ |
|
amount_signed |
decimal |
Amount Signed |
☐ |
Negative value of amount field if payment_type is outbound |
amount_tax_signed |
decimal |
Tax Signed |
☐ |
|
amount_tax |
decimal |
Tax |
☐ |
|
amount_total_in_currency_signed |
decimal |
Total in Currency Signed |
☐ |
|
amount_total_signed |
decimal |
Total Signed |
☐ |
|
amount_total |
decimal |
Total |
☐ |
|
amount_untaxed_signed |
decimal |
Untaxed Amount Signed |
☐ |
|
amount_untaxed |
decimal |
Untaxed Amount |
☐ |
|
amount |
decimal |
Amount |
☐ |
|
asset_asset_type |
string |
Asset Type |
☐ |
|
asset_depreciated_value |
decimal |
Cumulative Depreciation |
☐ |
|
asset_depreciation_beginning_date |
datetime |
Date of the beginning of the depreciation |
☐ |
|
asset_id_display_name |
string |
Asset Id Display Name |
☐ |
|
asset_id_label |
string |
|
☐ |
|
asset_id |
string |
|
☐ |
|
asset_ids |
string |
|
☐ |
|
asset_number_days |
int32 |
Number of days |
☐ |
|
asset_remaining_value |
decimal |
Depreciable Value |
☐ |
|
asset_value_change |
boolean |
Asset Value Change |
☐ |
|
attachment_ids |
string |
|
☐ |
|
authorized_transaction_ids |
string |
|
☐ |
|
auto_post_origin_id_label |
string |
|
☐ |
|
auto_post_origin_id |
string |
|
☐ |
|
auto_post_until |
datetime |
Auto-post until |
☐ |
This recurring move will be posted up to and including this date. |
auto_post |
string |
Auto-post |
☑ |
Specify whether this entry is posted automatically on its accounting date, and any similar recurring invoices. |
available_journal_ids |
string |
|
☐ |
|
available_partner_bank_ids |
string |
|
☐ |
|
available_payment_method_line_ids |
string |
|
☐ |
|
bank_partner_id_label |
string |
|
☐ |
Technical field to get the domain on the bank |
bank_partner_id |
string |
|
☐ |
Technical field to get the domain on the bank |
batch_payment_id_label |
string |
|
☐ |
|
batch_payment_id |
string |
|
☐ |
|
campaign_id_label |
string |
|
☐ |
This is a name that helps you keep track of your different campaign efforts, e.g. Fall_Drive, Christmas_Special |
campaign_id |
string |
|
☐ |
This is a name that helps you keep track of your different campaign efforts, e.g. Fall_Drive, Christmas_Special |
commercial_partner_id_label |
string |
|
☐ |
|
commercial_partner_id |
string |
|
☐ |
|
company_currency_id_label |
string |
|
☐ |
|
company_currency_id |
string |
|
☐ |
|
company_id_label |
string |
|
☐ |
|
company_id |
string |
|
☐ |
|
count_asset |
int32 |
Count Asset |
☐ |
|
count_deferred_expense |
int32 |
Count Deferred Expense |
☐ |
|
count_deferred_revenue |
int32 |
Count Deferred Revenue |
☐ |
|
country_code |
string |
Country Code |
☐ |
The ISO country code in two chars. You can use this field for quick search. |
create_date |
datetime |
Created on |
☐ |
|
create_uid_label |
string |
|
☐ |
|
create_uid |
string |
|
☐ |
|
currency_id_label |
string |
|
☐ |
The payment's currency. |
currency_id |
string |
|
☐ |
The payment's currency. |
date |
datetime |
Date |
☑ |
|
depreciation_value |
decimal |
Depreciation |
☐ |
|
destination_account_id_label |
string |
|
☐ |
|
destination_account_id |
string |
|
☐ |
|
destination_journal_id_label |
string |
|
☐ |
|
destination_journal_id |
string |
|
☐ |
|
direction_sign |
int32 |
Direction Sign |
☐ |
Multiplicator depending on the document type, to convert a price into a balance |
display_inactive_currency_warning |
boolean |
Display Inactive Currency Warning |
☐ |
|
display_name |
string |
Display Name |
☐ |
|
display_qr_code |
boolean |
Display QR-code |
☐ |
|
draft_asset_exists |
boolean |
Draft Asset Exists |
☐ |
|
draft_deferred_expense_exists |
boolean |
Draft Deferred Expense Exists |
☐ |
|
draft_deferred_revenue_exists |
boolean |
Draft Deferred Revenue Exists |
☐ |
|
duplicated_ref_ids |
string |
|
☐ |
|
edi_blocking_level |
string |
Edi Blocking Level |
☐ |
|
edi_document_ids |
string |
|
☐ |
|
edi_error_count |
int32 |
Edi Error Count |
☐ |
How many EDIs are in error for this move ? |
edi_error_message |
string |
Edi Error Message |
☐ |
|
edi_show_abandon_cancel_button |
boolean |
Edi Show Abandon Cancel Button |
☐ |
|
edi_show_cancel_button |
boolean |
Edi Show Cancel Button |
☐ |
|
edi_state |
string |
Electronic invoicing |
☐ |
The aggregated state of all the EDIs with web-service of this move |
edi_web_services_to_process |
string |
Edi Web Services To Process |
☐ |
|
expense_sheet_id |
string |
|
☐ |
|
extract_attachment_id_label |
string |
|
☐ |
|
extract_attachment_id |
string |
|
☐ |
|
extract_can_show_banners |
boolean |
Can show the ocr banners |
☐ |
|
extract_can_show_send_button |
boolean |
Can show the ocr send button |
☐ |
|
extract_detected_layout |
int32 |
Extract Detected Layout Id |
☐ |
|
extract_error_message |
string |
Error message |
☐ |
|
extract_partner_name |
string |
Extract Detected Partner Name |
☐ |
|
extract_remote_id |
int32 |
Id of the request to IAP-OCR |
☐ |
|
extract_state_processed |
boolean |
Extract State Processed |
☐ |
|
extract_state |
string |
Extract state |
☑ |
|
extract_status_code |
int32 |
Status code |
☐ |
|
extract_word_ids |
string |
|
☐ |
|
fiscal_position_id_label |
string |
|
☐ |
Fiscal positions are used to adapt taxes and accounts for particular customers or sales orders/invoices. The default value comes from the customer. |
fiscal_position_id |
string |
|
☐ |
Fiscal positions are used to adapt taxes and accounts for particular customers or sales orders/invoices. The default value comes from the customer. |
force_outstanding_account_id_label |
string |
|
☐ |
|
force_outstanding_account_id |
string |
|
☐ |
|
has_message |
boolean |
Has Message |
☐ |
|
has_reconciled_entries |
boolean |
Has Reconciled Entries |
☐ |
|
hide_post_button |
boolean |
Hide Post Button |
☐ |
|
highest_name |
string |
Highest Name |
☐ |
|
id |
int32 |
ID |
☐ |
|
inalterable_hash |
string |
Inalterability Hash |
☐ |
|
invoice_cash_rounding_id_label |
string |
|
☐ |
Defines the smallest coinage of the currency that can be used to pay by cash. |
invoice_cash_rounding_id |
string |
|
☐ |
Defines the smallest coinage of the currency that can be used to pay by cash. |
invoice_date_due |
datetime |
Due Date |
☐ |
|
invoice_date |
datetime |
Invoice/Bill Date |
☐ |
|
invoice_filter_type_domain |
string |
Invoice Filter Type Domain |
☐ |
|
invoice_has_outstanding |
boolean |
Invoice Has Outstanding |
☐ |
|
invoice_incoterm_id_label |
string |
|
☐ |
International Commercial Terms are a series of predefined commercial terms used in international transactions. |
invoice_incoterm_id |
string |
|
☐ |
International Commercial Terms are a series of predefined commercial terms used in international transactions. |
invoice_line_ids |
string |
|
☐ |
|
invoice_origin |
string |
Origin |
☐ |
The document(s) that generated the invoice. |
invoice_outstanding_credits_debits_widget |
byte[] |
Invoice Outstanding Credits Debits Widget |
☐ |
|
invoice_partner_display_name |
string |
Invoice Partner Display Name |
☐ |
|
invoice_payment_term_id_label |
string |
|
☐ |
|
invoice_payment_term_id |
string |
|
☐ |
|
invoice_payments_widget |
byte[] |
Invoice Payments Widget |
☐ |
|
invoice_source_email |
string |
Source Email |
☐ |
|
invoice_user_id_label |
string |
|
☐ |
|
invoice_user_id |
string |
|
☐ |
|
invoice_vendor_bill_id_label |
string |
|
☐ |
Auto-complete from a past bill. |
invoice_vendor_bill_id |
string |
|
☐ |
Auto-complete from a past bill. |
is_donation |
boolean |
Is Donation |
☐ |
|
is_in_extractable_state |
boolean |
Is In Extractable State |
☐ |
|
is_internal_transfer |
boolean |
Internal Transfer |
☐ |
|
is_matched |
boolean |
Is Matched With a Bank Statement |
☐ |
|
is_move_sent |
boolean |
Is Move Sent |
☐ |
It indicates that the invoice/payment has been sent. |
is_reconciled |
boolean |
Is Reconciled |
☐ |
|
is_storno |
boolean |
Is Storno |
☐ |
|
journal_id_label |
string |
|
☐ |
|
journal_id |
string |
|
☐ |
|
line_ids |
string |
|
☐ |
|
made_sequence_hole |
boolean |
Made Sequence Hole |
☐ |
|
medium_id_label |
string |
|
☐ |
This is the method of delivery, e.g. Postcard, Email, or Banner Ad |
medium_id |
string |
|
☐ |
This is the method of delivery, e.g. Postcard, Email, or Banner Ad |
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 |
|
☐ |
|
move_id_label |
string |
|
☐ |
|
move_id |
string |
|
☐ |
|
move_type |
string |
Type |
☑ |
|
my_activity_date_deadline |
datetime |
My Activity Deadline |
☐ |
|
name |
string |
Number |
☐ |
|
narration |
string |
Terms and Conditions |
☐ |
|
needed_terms_dirty |
boolean |
Needed Terms Dirty |
☐ |
|
needed_terms |
byte[] |
Needed Terms |
☐ |
|
outstanding_account_id_label |
string |
|
☐ |
|
outstanding_account_id |
string |
|
☐ |
|
paired_internal_transfer_payment_id_label |
string |
|
☐ |
When an internal transfer is posted, a paired payment is created. They are cross referenced through this field |
paired_internal_transfer_payment_id |
string |
|
☐ |
When an internal transfer is posted, a paired payment is created. They are cross referenced through this field |
partner_bank_id_label |
string |
|
☐ |
|
partner_bank_id |
string |
|
☐ |
|
partner_credit_warning |
string |
Partner Credit Warning |
☐ |
|
partner_id_label |
string |
|
☐ |
|
partner_id |
string |
|
☐ |
|
partner_shipping_id_label |
string |
|
☐ |
The delivery address will be used in the computation of the fiscal position. |
partner_shipping_id |
string |
|
☐ |
The delivery address will be used in the computation of the fiscal position. |
partner_type |
string |
Partner Type |
☑ |
|
payment_id_label |
string |
|
☐ |
|
payment_id |
string |
|
☐ |
|
payment_ids |
string |
|
☐ |
|
payment_method_code |
string |
Code |
☐ |
|
payment_method_id_label |
string |
|
☐ |
|
payment_method_id |
string |
|
☐ |
|
payment_method_line_id_label |
string |
|
☐ |
Manual: Pay or Get paid by any method outside of Odoo.Payment Providers: Each payment provider has its own Payment Method. Request a transaction on/to a card thanks to a payment token saved by the partner when buying or subscribing online.Check: Pay bills by check and print it from Odoo.Batch Deposit: Collect several customer checks at once generating and submitting a batch deposit to your bank. Module account_batch_payment is necessary.SEPA Credit Transfer: Pay in the SEPA zone by submitting a SEPA Credit Transfer file to your bank. Module account_sepa is necessary.SEPA Direct Debit: Get paid in the SEPA zone thanks to a mandate your partner will have granted to you. Module account_sepa is necessary. |
payment_method_line_id |
string |
|
☐ |
Manual: Pay or Get paid by any method outside of Odoo.Payment Providers: Each payment provider has its own Payment Method. Request a transaction on/to a card thanks to a payment token saved by the partner when buying or subscribing online.Check: Pay bills by check and print it from Odoo.Batch Deposit: Collect several customer checks at once generating and submitting a batch deposit to your bank. Module account_batch_payment is necessary.SEPA Credit Transfer: Pay in the SEPA zone by submitting a SEPA Credit Transfer file to your bank. Module account_sepa is necessary.SEPA Direct Debit: Get paid in the SEPA zone thanks to a mandate your partner will have granted to you. Module account_sepa is necessary. |
payment_method_name |
string |
Name |
☐ |
|
payment_reference |
string |
Payment Reference |
☐ |
Reference of the document used to issue this payment. Eg. check number, file name, etc. |
payment_state_before_switch |
string |
Payment State Before Switch |
☐ |
|
payment_state |
string |
Payment Status |
☐ |
|
payment_term_details |
byte[] |
Payment Term Details |
☐ |
|
payment_token_id_label |
string |
|
☐ |
Note that only tokens from providers allowing to capture the amount are available. |
payment_token_id |
string |
|
☐ |
Note that only tokens from providers allowing to capture the amount are available. |
payment_transaction_id_label |
string |
|
☐ |
|
payment_transaction_id |
string |
|
☐ |
|
payment_type |
string |
Payment Type |
☑ |
|
pos_order_ids |
string |
|
☐ |
|
pos_payment_ids |
string |
|
☐ |
|
pos_payment_method_id_label |
string |
|
☐ |
|
pos_payment_method_id |
string |
|
☐ |
|
pos_session_id_label |
string |
|
☐ |
|
pos_session_id |
string |
|
☐ |
|
posted_before |
boolean |
Posted Before |
☐ |
|
purchase_id_label |
string |
|
☐ |
Auto-complete from a past purchase order. |
purchase_id |
string |
|
☐ |
Auto-complete from a past purchase order. |
purchase_order_count |
int32 |
Purchase Order Count |
☐ |
|
purchase_vendor_bill_id_label |
string |
|
☐ |
Auto-complete from a past bill / purchase order. |
purchase_vendor_bill_id |
string |
|
☐ |
Auto-complete from a past bill / purchase order. |
qr_code_method |
string |
Payment QR-code |
☐ |
Type of QR-code to be generated for the payment of this invoice, when printing it. If left blank, the first available and usable method will be used. |
qr_code |
string |
QR Code URL |
☐ |
|
quick_edit_mode |
boolean |
Quick Edit Mode |
☐ |
|
quick_edit_total_amount |
decimal |
Total (Tax inc.) |
☐ |
Use this field to encode the total amount of the invoice.Odoo will automatically create one invoice line with default values to match it. |
quick_encoding_vals |
byte[] |
Quick Encoding Vals |
☐ |
|
reconciled_bill_ids |
string |
|
☐ |
Invoices whose journal items have been reconciled with these payments. |
reconciled_bills_count |
int32 |
# Reconciled Bills |
☐ |
|
reconciled_invoice_ids |
string |
|
☐ |
Invoices whose journal items have been reconciled with these payments. |
reconciled_invoices_count |
int32 |
# Reconciled Invoices |
☐ |
|
reconciled_invoices_type |
string |
Reconciled Invoices Type |
☐ |
|
reconciled_statement_line_ids |
string |
|
☐ |
Statements lines matched to this payment |
reconciled_statement_lines_count |
int32 |
# Reconciled Statement Lines |
☐ |
|
ref |
string |
Reference |
☐ |
|
refunds_count |
int32 |
Refunds Count |
☐ |
|
repair_ids |
string |
|
☐ |
|
require_partner_bank_account |
boolean |
Require Partner Bank Account |
☐ |
|
restrict_mode_hash_table |
boolean |
Lock Posted Entries with Hash |
☐ |
If ticked, the accounting entry or invoice receives a hash as soon as it is posted and cannot be modified anymore. |
reversal_move_id |
string |
|
☐ |
|
reversed_entry_id_label |
string |
|
☐ |
|
reversed_entry_id |
string |
|
☐ |
|
sale_order_count |
int32 |
Sale Order Count |
☐ |
|
secure_sequence_number |
int32 |
Inalteralbility No Gap Sequence # |
☐ |
|
sequence_number |
int32 |
Sequence Number |
☐ |
|
sequence_prefix |
string |
Sequence Prefix |
☐ |
|
show_discount_details |
boolean |
Show Discount Details |
☐ |
|
show_name_warning |
boolean |
Show Name Warning |
☐ |
|
show_partner_bank_account |
boolean |
Show Partner Bank Account |
☐ |
|
show_payment_term_details |
boolean |
Show Payment Term Details |
☐ |
|
show_reset_to_draft_button |
boolean |
Show Reset To Draft Button |
☐ |
|
source_id_label |
string |
|
☐ |
This is the source of the link, e.g. Search Engine, another domain, or name of email list |
source_id |
string |
|
☐ |
This is the source of the link, e.g. Search Engine, another domain, or name of email list |
source_payment_id_label |
string |
|
☐ |
The source payment of related refund payments |
source_payment_id |
string |
|
☐ |
The source payment of related refund payments |
state |
string |
Status |
☑ |
|
statement_id_label |
string |
|
☐ |
|
statement_id |
string |
|
☐ |
|
statement_line_id_label |
string |
|
☐ |
|
statement_line_id |
string |
|
☐ |
|
statement_line_ids |
string |
|
☐ |
|
stock_move_id_label |
string |
|
☐ |
|
stock_move_id |
string |
|
☐ |
|
stock_valuation_layer_ids |
string |
|
☐ |
|
string_to_hash |
string |
String To Hash |
☐ |
|
suitable_journal_ids |
string |
|
☐ |
|
suitable_payment_token_ids |
string |
|
☐ |
|
suspense_statement_line_id_label |
string |
|
☐ |
|
suspense_statement_line_id |
string |
|
☐ |
|
tax_cash_basis_created_move_ids |
string |
|
☐ |
The cash basis entries created from the taxes on this entry, when reconciling its lines. |
tax_cash_basis_origin_move_id_label |
string |
|
☐ |
The journal entry from which this tax cash basis journal entry has been created. |
tax_cash_basis_origin_move_id |
string |
|
☐ |
The journal entry from which this tax cash basis journal entry has been created. |
tax_cash_basis_rec_id_label |
string |
|
☐ |
|
tax_cash_basis_rec_id |
string |
|
☐ |
|
tax_closing_end_date |
datetime |
Tax Closing End Date |
☐ |
|
tax_country_code |
string |
Tax Country Code |
☐ |
|
tax_country_id_label |
string |
|
☐ |
|
tax_country_id |
string |
|
☐ |
|
tax_lock_date_message |
string |
Tax Lock Date Message |
☐ |
|
tax_report_control_error |
boolean |
Tax Report Control Error |
☐ |
|
tax_totals |
byte[] |
Invoice Totals |
☐ |
Edit Tax amounts if you encounter rounding issues. |
team_id_label |
string |
|
☐ |
|
team_id |
string |
|
☐ |
|
timesheet_count |
int32 |
Number of timesheets |
☐ |
|
timesheet_encode_uom_id_label |
string |
|
☐ |
|
timesheet_encode_uom_id |
string |
|
☐ |
|
timesheet_ids |
string |
|
☐ |
|
timesheet_total_duration |
int32 |
Timesheet Total Duration |
☐ |
Total recorded duration, expressed in the encoding UoM, and rounded to the unit |
to_check |
boolean |
To Check |
☐ |
If this checkbox is ticked, it means that the user was not sure of all the related information at the time of the creation of the move and that the move needs to be checked again. |
transaction_ids |
string |
|
☐ |
|
transfer_model_id_label |
string |
|
☐ |
|
transfer_model_id |
string |
|
☐ |
|
type_name |
string |
Type Name |
☐ |
|
use_electronic_payment_method |
boolean |
Use Electronic Payment Method |
☐ |
|
user_id_label |
string |
|
☐ |
|
user_id |
string |
|
☐ |
|
website_id_label |
string |
|
☐ |
Website through which this invoice was created for eCommerce orders. |
website_id |
string |
|
☐ |
Website through which this invoice was created for eCommerce orders. |
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