invantive documentation
Forum di supporto InvantiveAccedi / Registrati

payment: Odoo itgen_odoo_payment

read only per partition

  • Catalogo: Odoo
  • Schema: account
  • Etichetta: itgen_odoo_payment

Pagamenti

È possibile solo recuperare i dati.

Populate factory part for account.payment.

Colonne della tabella

Di seguito sono riportate le colonne della tabella payment. Ogni colonna ha un tipo di dati SQL. Un nuovo valore non nullo deve essere fornito per ogni colonna richiesta in ogni momento durante l'inserimento e l'aggiornamento.

Name Tipo di dati Label Required Marks Documentation
access_token varchar2 Security Token
access_url varchar2 Portal Access URL Customer Portal URL
access_warning varchar2 Access warning
activity_calendar_event_id varchar2
activity_calendar_event_id_label varchar2
activity_date_deadline datetime Next Activity Deadline
activity_exception_decoration varchar2 Activity Exception Decoration Type of the exception activity on record.
activity_exception_icon varchar2 Icon Icon to indicate an exception activity.
activity_ids varchar2
activity_state varchar2 Activity State Status based on activities Overdue: Due date is already passed Today: Activity date is today Planned: Future activities.
activity_summary varchar2 Next Activity Summary
activity_type_icon varchar2 Activity Type Icon Font awesome icon e.g. fa-tasks
activity_type_id varchar2
activity_type_id_label varchar2
activity_user_id varchar2
activity_user_id_label varchar2
always_tax_exigible boolean Always Tax Exigible
amount numeric Amount
amount_available_for_refund numeric Amount Available For Refund
amount_company_currency_signed numeric Amount Company Currency Signed
amount_paid numeric Amount paid
amount_residual numeric Somma da pagare
amount_residual_signed numeric Amount Due Signed
amount_signed numeric Amount Signed Negative value of amount field if payment_type is outbound
amount_tax numeric Tax
amount_tax_signed numeric Tax Signed
amount_total numeric Total
amount_total_in_currency_signed numeric Total in Currency Signed
amount_total_signed numeric Total Signed
amount_untaxed numeric Untaxed Amount
amount_untaxed_signed numeric Untaxed Amount Signed
asset_asset_type varchar2 Asset Type
asset_depreciated_value numeric Cumulative Depreciation
asset_depreciation_beginning_date datetime Date of the beginning of the depreciation
asset_id varchar2
asset_id_display_name varchar2 Asset Id Display Name
asset_id_label varchar2
asset_ids varchar2
asset_number_days int32 Number of days
asset_remaining_value numeric Depreciable Value
asset_value_change boolean Asset Value Change
attachment_ids varchar2
authorized_transaction_ids varchar2
auto_post varchar2 Auto-post Specify whether this entry is posted automatically on its accounting date, and any similar recurring invoices.
auto_post_origin_id varchar2
auto_post_origin_id_label varchar2
auto_post_until datetime Auto-post until This recurring move will be posted up to and including this date.
available_journal_ids varchar2
available_partner_bank_ids varchar2
available_payment_method_line_ids varchar2
bank_partner_id varchar2 Technical field to get the domain on the bank
bank_partner_id_label varchar2 Technical field to get the domain on the bank
batch_payment_id varchar2
batch_payment_id_label varchar2
campaign_id varchar2 This is a name that helps you keep track of your different campaign efforts, e.g. Fall_Drive, Christmas_Special
campaign_id_label varchar2 This is a name that helps you keep track of your different campaign efforts, e.g. Fall_Drive, Christmas_Special
commercial_partner_id varchar2
commercial_partner_id_label varchar2
company_currency_id varchar2
company_currency_id_label varchar2
company_id varchar2
company_id_label varchar2
count_asset int32 Count Asset
count_deferred_expense int32 Count Deferred Expense
count_deferred_revenue int32 Count Deferred Revenue
country_code varchar2 Codice della nazione The ISO country code in two chars.You can use this field for quick search.
create_date datetime Creato il
create_uid varchar2
create_uid_label varchar2
currency_id varchar2 The payment's currency.
currency_id_label varchar2 The payment's currency.
date datetime Date
depreciation_value numeric Depreciation
destination_account_id varchar2
destination_account_id_label varchar2
destination_journal_id varchar2
destination_journal_id_label varchar2
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 varchar2 Nome visualizzato
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 varchar2
edi_blocking_level varchar2 Edi Blocking Level
edi_document_ids varchar2
edi_error_count int32 Edi Error Count How many EDIs are in error for this move ?
edi_error_message varchar2 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 varchar2 Electronic invoicing The aggregated state of all the EDIs with web-service of this move
edi_web_services_to_process varchar2 Edi Web Services To Process
expense_sheet_id varchar2
extract_attachment_id varchar2
extract_attachment_id_label varchar2
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 varchar2 Error message
extract_partner_name varchar2 Extract Detected Partner Name
extract_remote_id int32 Id of the request to IAP-OCR
extract_state varchar2 Extract state
extract_state_processed boolean Extract State Processed
extract_status_code int32 Status code
extract_word_ids varchar2
fiscal_position_id varchar2 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_label varchar2 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 varchar2
force_outstanding_account_id_label varchar2
has_message boolean Has Message
has_reconciled_entries boolean Has Reconciled Entries
hide_post_button boolean Hide Post Button
highest_name varchar2 Highest Name
id int32 ID
inalterable_hash varchar2 Inalterability Hash
invoice_cash_rounding_id varchar2 Defines the smallest coinage of the currency that can be used to pay by cash.
invoice_cash_rounding_id_label varchar2 Defines the smallest coinage of the currency that can be used to pay by cash.
invoice_date datetime Invoice/Bill Date
invoice_date_due datetime Scadenza
invoice_filter_type_domain varchar2 Invoice Filter Type Domain
invoice_has_outstanding boolean Invoice Has Outstanding
invoice_incoterm_id varchar2 International Commercial Terms are a series of predefined commercial terms used in international transactions.
invoice_incoterm_id_label varchar2 International Commercial Terms are a series of predefined commercial terms used in international transactions.
invoice_line_ids varchar2
invoice_origin varchar2 Origin The document(s) that generated the invoice.
invoice_outstanding_credits_debits_widget varbinary Invoice Outstanding Credits Debits Widget
invoice_partner_display_name varchar2 Invoice Partner Display Name
invoice_payment_term_id varchar2
invoice_payment_term_id_label varchar2
invoice_payments_widget varbinary Invoice Payments Widget
invoice_source_email varchar2 Source Email
invoice_user_id varchar2
invoice_user_id_label varchar2
invoice_vendor_bill_id varchar2 Auto-complete from a past bill.
invoice_vendor_bill_id_label varchar2 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 varchar2
journal_id_label varchar2
line_ids varchar2
made_sequence_hole boolean Made Sequence Hole
medium_id varchar2 This is the method of delivery, e.g. Postcard, Email, or Banner Ad
medium_id_label varchar2 This is the method of delivery, e.g. Postcard, Email, or Banner Ad
message_attachment_count int32 Numero di allegati
message_follower_ids varchar2
message_has_error boolean Message Delivery error If checked, some messages have a delivery error.
message_has_error_counter int32 Number of errors Number of messages with delivery error
message_has_sms_error boolean SMS Delivery error If checked, some messages have a delivery error.
message_ids varchar2
message_is_follower boolean Is Follower
message_main_attachment_id varchar2
message_main_attachment_id_label varchar2
message_needaction boolean Action Needed If checked, new messages require your attention.
message_needaction_counter int32 Numero di azioni Number of messages which requires an action
message_partner_ids varchar2
move_id varchar2
move_id_label varchar2
move_type varchar2 Type
my_activity_date_deadline datetime My Activity Deadline
name varchar2 Number
narration varchar2 Terms and Conditions
needed_terms varbinary Needed Terms
needed_terms_dirty boolean Needed Terms Dirty
outstanding_account_id varchar2
outstanding_account_id_label varchar2
paired_internal_transfer_payment_id varchar2 When an internal transfer is posted, a paired payment is created.They are cross referenced through this field
paired_internal_transfer_payment_id_label varchar2 When an internal transfer is posted, a paired payment is created.They are cross referenced through this field
partner_bank_id varchar2
partner_bank_id_label varchar2
partner_credit_warning varchar2 Partner Credit Warning
partner_id varchar2
partner_id_label varchar2
partner_shipping_id varchar2 The delivery address will be used in the computation of the fiscal position.
partner_shipping_id_label varchar2 The delivery address will be used in the computation of the fiscal position.
partner_type varchar2 Partner Type
payment_id varchar2
payment_id_label varchar2
payment_ids varchar2
payment_method_code varchar2 Code
payment_method_id varchar2
payment_method_id_label varchar2
payment_method_line_id varchar2 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_label varchar2 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 varchar2 Name
payment_reference varchar2 Riferimento di pagamento Reference of the document used to issue this payment.Eg. check number, file name, etc.
payment_state varchar2 Stato del pagamento
payment_state_before_switch varchar2 Payment State Before Switch
payment_term_details varbinary Payment Term Details
payment_token_id varchar2 Note that only tokens from providers allowing to capture the amount are available.
payment_token_id_label varchar2 Note that only tokens from providers allowing to capture the amount are available.
payment_transaction_id varchar2
payment_transaction_id_label varchar2
payment_type varchar2 Tipo di pagamento
pos_order_ids varchar2
pos_payment_ids varchar2
pos_payment_method_id varchar2
pos_payment_method_id_label varchar2
pos_session_id varchar2
pos_session_id_label varchar2
posted_before boolean Posted Before
purchase_id varchar2 Auto-complete from a past purchase order.
purchase_id_label varchar2 Auto-complete from a past purchase order.
purchase_order_count int32 Purchase Order Count
purchase_vendor_bill_id varchar2 Auto-complete from a past bill / purchase order.
purchase_vendor_bill_id_label varchar2 Auto-complete from a past bill / purchase order.
qr_code varchar2 QR Code URL
qr_code_method varchar2 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.
quick_edit_mode boolean Quick Edit Mode
quick_edit_total_amount numeric 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 varbinary Quick Encoding Vals
reconciled_bill_ids varchar2 Invoices whose journal items have been reconciled with these payments.
reconciled_bills_count int32 # Reconciled Bills
reconciled_invoice_ids varchar2 Invoices whose journal items have been reconciled with these payments.
reconciled_invoices_count int32 # Reconciled Invoices
reconciled_invoices_type varchar2 Reconciled Invoices Type
reconciled_statement_line_ids varchar2 Statements lines matched to this payment
reconciled_statement_lines_count int32 # Reconciled Statement Lines
ref varchar2 Reference
refunds_count int32 Refunds Count
repair_ids varchar2
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 varchar2
reversed_entry_id varchar2
reversed_entry_id_label varchar2
sale_order_count int32 Sale Order Count
secure_sequence_number int32 Inalteralbility No Gap Sequence #
sequence_number int32 Numero di sequenza
sequence_prefix varchar2 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 varchar2 This is the source of the link, e.g. Search Engine, another domain, or name of email list
source_id_label varchar2 This is the source of the link, e.g. Search Engine, another domain, or name of email list
source_payment_id varchar2 The source payment of related refund payments
source_payment_id_label varchar2 The source payment of related refund payments
state varchar2 Status
statement_id varchar2
statement_id_label varchar2
statement_line_id varchar2
statement_line_id_label varchar2
statement_line_ids varchar2
stock_move_id varchar2
stock_move_id_label varchar2
stock_valuation_layer_ids varchar2
string_to_hash varchar2 String To Hash
suitable_journal_ids varchar2
suitable_payment_token_ids varchar2
suspense_statement_line_id varchar2
suspense_statement_line_id_label varchar2
tax_cash_basis_created_move_ids varchar2 The cash basis entries created from the taxes on this entry, when reconciling its lines.
tax_cash_basis_origin_move_id varchar2 The journal entry from which this tax cash basis journal entry has been created.
tax_cash_basis_origin_move_id_label varchar2 The journal entry from which this tax cash basis journal entry has been created.
tax_cash_basis_rec_id varchar2
tax_cash_basis_rec_id_label varchar2
tax_closing_end_date datetime Tax Closing End Date
tax_country_code varchar2 Tax Country Code
tax_country_id varchar2
tax_country_id_label varchar2
tax_lock_date_message varchar2 Tax Lock Date Message
tax_report_control_error boolean Tax Report Control Error
tax_totals varbinary Invoice Totals Edit Tax amounts if you encounter rounding issues.
team_id varchar2
team_id_label varchar2
timesheet_count int32 Number of timesheets
timesheet_encode_uom_id varchar2
timesheet_encode_uom_id_label varchar2
timesheet_ids varchar2
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 varchar2
transfer_model_id varchar2
transfer_model_id_label varchar2
type_name varchar2 Nome del tipo
use_electronic_payment_method boolean Use Electronic Payment Method
user_id varchar2
user_id_label varchar2
website_id varchar2 Website through which this invoice was created for eCommerce orders.
website_id_label varchar2 Website through which this invoice was created for eCommerce orders.
website_message_ids varchar2 Website communication history
write_date datetime Last Updated on
write_uid varchar2
write_uid_label varchar2

Note di rilascio

Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: