move: Odoo itgen_odoo_move
read only per partition
- Catalogo:
Odoo - Schema:
account - Etichetta: itgen_odoo_move
Registrazione contabile
È possibile solo recuperare i dati.
Riepilogo
Base model to inherit from to add extract functionality to a model.
Colonne della tabella
Di seguito sono riportate le colonne della tabella move. 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_ |
varchar2 |
Security Token | |||
access_ |
varchar2 |
Portal Access URL | Customer Portal URL | ||
access_ |
varchar2 |
Access warning | |||
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 |
||||
always_ |
boolean |
Always Tax Exigible | |||
amount_ |
numeric |
Amount paid | |||
amount_ |
numeric |
Somma da pagare | |||
amount_ |
numeric |
Amount Due Signed | |||
amount_ |
numeric |
Tax | |||
amount_ |
numeric |
Tax Signed | |||
amount_ |
numeric |
Total | |||
amount_ |
numeric |
Total in Currency Signed | |||
amount_ |
numeric |
Total Signed | |||
amount_ |
numeric |
Untaxed Amount | |||
amount_ |
numeric |
Untaxed Amount Signed | |||
asset_ |
varchar2 |
Asset Type | |||
asset_ |
numeric |
Cumulative Depreciation | |||
asset_ |
datetime |
Date of the beginning of the depreciation | |||
asset_ |
varchar2 |
||||
asset_ |
varchar2 |
Asset Id Display Name | |||
asset_ |
varchar2 |
||||
asset_ |
varchar2 |
||||
asset_ |
int32 |
Number of days | |||
asset_ |
numeric |
Depreciable Value | |||
asset_ |
boolean |
Asset Value Change | |||
attachment_ |
varchar2 |
||||
authorized_ |
varchar2 |
||||
auto_ |
varchar2 |
Auto-post | Specify whether this entry is posted automatically on its accounting date, and any similar recurring invoices. | ||
auto_ |
varchar2 |
||||
auto_ |
varchar2 |
||||
auto_ |
datetime |
Auto-post until | This recurring move will be posted up to and including this date. | ||
bank_ |
varchar2 |
Technical field to get the domain on the bank | |||
bank_ |
varchar2 |
Technical field to get the domain on the bank | |||
campaign_ |
varchar2 |
This is a name that helps you keep track of your different campaign efforts, e.g. Fall_Drive, Christmas_Special | |||
campaign_ |
varchar2 |
This is a name that helps you keep track of your different campaign efforts, e.g. Fall_Drive, Christmas_Special | |||
commercial_ |
varchar2 |
||||
commercial_ |
varchar2 |
||||
company_ |
varchar2 |
||||
company_ |
varchar2 |
||||
company_ |
varchar2 |
||||
company_ |
varchar2 |
||||
count_ |
int32 |
Count Asset | |||
count_ |
int32 |
Count Deferred Expense | |||
count_ |
int32 |
Count Deferred Revenue | |||
country_ |
varchar2 |
Codice della nazione | The ISO country code in two chars.You can use this field for quick search. | ||
create_ |
datetime |
Creato il | |||
create_ |
varchar2 |
||||
create_ |
varchar2 |
||||
currency_ |
varchar2 |
||||
currency_ |
varchar2 |
||||
date |
datetime |
Date | |||
depreciation_ |
numeric |
Depreciation | |||
direction_ |
int32 |
Direction Sign | Multiplicator depending on the document type, to convert a price into a balance | ||
display_ |
boolean |
Display Inactive Currency Warning | |||
display_ |
varchar2 |
Nome visualizzato | |||
display_ |
boolean |
Display QR-code | |||
draft_ |
boolean |
Draft Asset Exists | |||
draft_ |
boolean |
Draft Deferred Expense Exists | |||
draft_ |
boolean |
Draft Deferred Revenue Exists | |||
duplicated_ |
varchar2 |
||||
edi_ |
varchar2 |
Edi Blocking Level | |||
edi_ |
varchar2 |
||||
edi_ |
int32 |
Edi Error Count | How many EDIs are in error for this move ? | ||
edi_ |
varchar2 |
Edi Error Message | |||
edi_ |
boolean |
Edi Show Abandon Cancel Button | |||
edi_ |
boolean |
Edi Show Cancel Button | |||
edi_ |
varchar2 |
Electronic invoicing | The aggregated state of all the EDIs with web-service of this move | ||
edi_ |
varchar2 |
Edi Web Services To Process | |||
expense_ |
varchar2 |
||||
extract_ |
varchar2 |
||||
extract_ |
varchar2 |
||||
extract_ |
boolean |
Can show the ocr banners | |||
extract_ |
boolean |
Can show the ocr send button | |||
extract_ |
int32 |
Extract Detected Layout Id | |||
extract_ |
varchar2 |
Error message | |||
extract_ |
varchar2 |
Extract Detected Partner Name | |||
extract_ |
int32 |
Id of the request to IAP-OCR | |||
extract_ |
varchar2 |
Extract state | |||
extract_ |
boolean |
Extract State Processed | |||
extract_ |
int32 |
Status code | |||
extract_ |
varchar2 |
||||
fiscal_ |
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_ |
varchar2 |
Fiscal positions are used to adapt taxes and accounts for particular customers or sales orders/invoices.The default value comes from the customer. | |||
has_ |
boolean |
Has Message | |||
has_ |
boolean |
Has Reconciled Entries | |||
hide_ |
boolean |
Hide Post Button | |||
highest_ |
varchar2 |
Highest Name | |||
id |
int32 |
ID | |||
inalterable_ |
varchar2 |
Inalterability Hash | |||
invoice_ |
varchar2 |
Defines the smallest coinage of the currency that can be used to pay by cash. | |||
invoice_ |
varchar2 |
Defines the smallest coinage of the currency that can be used to pay by cash. | |||
invoice_ |
datetime |
Invoice/Bill Date | |||
invoice_ |
datetime |
Scadenza | |||
invoice_ |
varchar2 |
Invoice Filter Type Domain | |||
invoice_ |
boolean |
Invoice Has Outstanding | |||
invoice_ |
varchar2 |
International Commercial Terms are a series of predefined commercial terms used in international transactions. | |||
invoice_ |
varchar2 |
International Commercial Terms are a series of predefined commercial terms used in international transactions. | |||
invoice_ |
varchar2 |
||||
invoice_ |
varchar2 |
Origin | The document(s) that generated the invoice. | ||
invoice_ |
varbinary |
Invoice Outstanding Credits Debits Widget | |||
invoice_ |
varchar2 |
Invoice Partner Display Name | |||
invoice_ |
varchar2 |
||||
invoice_ |
varchar2 |
||||
invoice_ |
varbinary |
Invoice Payments Widget | |||
invoice_ |
varchar2 |
Source Email | |||
invoice_ |
varchar2 |
||||
invoice_ |
varchar2 |
||||
invoice_ |
varchar2 |
Auto-complete from a past bill. | |||
invoice_ |
varchar2 |
Auto-complete from a past bill. | |||
is_ |
boolean |
Is In Extractable State | |||
is_ |
boolean |
Is Move Sent | It indicates that the invoice/payment has been sent. | ||
is_ |
boolean |
Is Storno | |||
journal_ |
varchar2 |
||||
journal_ |
varchar2 |
||||
line_ |
varchar2 |
||||
made_ |
boolean |
Made Sequence Hole | |||
medium_ |
varchar2 |
This is the method of delivery, e.g. Postcard, Email, or Banner Ad | |||
medium_ |
varchar2 |
This is the method of delivery, e.g. Postcard, Email, or Banner Ad | |||
message_ |
int32 |
Numero di allegati | |||
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 |
Numero di azioni | Number of messages which requires an action | ||
message_ |
varchar2 |
||||
move_ |
varchar2 |
Type | |||
my_ |
datetime |
My Activity Deadline | |||
name |
varchar2 |
Number | |||
narration |
varchar2 |
Terms and Conditions | |||
needed_ |
varbinary |
Needed Terms | |||
needed_ |
boolean |
Needed Terms Dirty | |||
partner_ |
varchar2 |
Bank Account Number to which the invoice will be paid.A Company bank account if this is a Customer Invoice or Vendor Credit Note, otherwise a Partner bank account number. | |||
partner_ |
varchar2 |
Bank Account Number to which the invoice will be paid.A Company bank account if this is a Customer Invoice or Vendor Credit Note, otherwise a Partner bank account number. | |||
partner_ |
varchar2 |
Partner Credit Warning | |||
partner_ |
varchar2 |
||||
partner_ |
varchar2 |
||||
partner_ |
varchar2 |
The delivery address will be used in the computation of the fiscal position. | |||
partner_ |
varchar2 |
The delivery address will be used in the computation of the fiscal position. | |||
payment_ |
varchar2 |
||||
payment_ |
varchar2 |
||||
payment_ |
varchar2 |
||||
payment_ |
varchar2 |
Riferimento di pagamento | The payment reference to set on journal items. | ||
payment_ |
varchar2 |
Stato del pagamento | |||
payment_ |
varchar2 |
Payment State Before Switch | |||
payment_ |
varbinary |
Payment Term Details | |||
pos_ |
varchar2 |
||||
pos_ |
varchar2 |
||||
posted_ |
boolean |
Posted Before | |||
purchase_ |
varchar2 |
Auto-complete from a past purchase order. | |||
purchase_ |
varchar2 |
Auto-complete from a past purchase order. | |||
purchase_ |
int32 |
Purchase Order Count | |||
purchase_ |
varchar2 |
Auto-complete from a past bill / purchase order. | |||
purchase_ |
varchar2 |
Auto-complete from a past bill / purchase order. | |||
qr_ |
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_ |
boolean |
Quick Edit Mode | |||
quick_ |
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_ |
varbinary |
Quick Encoding Vals | |||
ref |
varchar2 |
Reference | |||
repair_ |
varchar2 |
||||
restrict_ |
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_ |
varchar2 |
||||
reversed_ |
varchar2 |
||||
reversed_ |
varchar2 |
||||
sale_ |
int32 |
Sale Order Count | |||
secure_ |
int32 |
Inalteralbility No Gap Sequence # | |||
sequence_ |
int32 |
Numero di sequenza | |||
sequence_ |
varchar2 |
Sequence Prefix | |||
show_ |
boolean |
Show Discount Details | |||
show_ |
boolean |
Show Name Warning | |||
show_ |
boolean |
Show Payment Term Details | |||
show_ |
boolean |
Show Reset To Draft Button | |||
source_ |
varchar2 |
This is the source of the link, e.g. Search Engine, another domain, or name of email list | |||
source_ |
varchar2 |
This is the source of the link, e.g. Search Engine, another domain, or name of email list | |||
state |
varchar2 |
Status | |||
statement_ |
varchar2 |
||||
statement_ |
varchar2 |
||||
statement_ |
varchar2 |
||||
statement_ |
varchar2 |
||||
statement_ |
varchar2 |
||||
stock_ |
varchar2 |
||||
stock_ |
varchar2 |
||||
stock_ |
varchar2 |
||||
string_ |
varchar2 |
String To Hash | |||
suitable_ |
varchar2 |
||||
suspense_ |
varchar2 |
||||
suspense_ |
varchar2 |
||||
tax_ |
varchar2 |
The cash basis entries created from the taxes on this entry, when reconciling its lines. | |||
tax_ |
varchar2 |
The journal entry from which this tax cash basis journal entry has been created. | |||
tax_ |
varchar2 |
The journal entry from which this tax cash basis journal entry has been created. | |||
tax_ |
varchar2 |
||||
tax_ |
varchar2 |
||||
tax_ |
datetime |
Tax Closing End Date | |||
tax_ |
varchar2 |
Tax Country Code | |||
tax_ |
varchar2 |
||||
tax_ |
varchar2 |
||||
tax_ |
varchar2 |
Tax Lock Date Message | |||
tax_ |
boolean |
Tax Report Control Error | |||
tax_ |
varbinary |
Invoice Totals | Edit Tax amounts if you encounter rounding issues. | ||
team_ |
varchar2 |
||||
team_ |
varchar2 |
||||
timesheet_ |
int32 |
Number of timesheets | |||
timesheet_ |
varchar2 |
||||
timesheet_ |
varchar2 |
||||
timesheet_ |
varchar2 |
||||
timesheet_ |
int32 |
Timesheet Total Duration | Total recorded duration, expressed in the encoding UoM, and rounded to the unit | ||
to_ |
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_ |
varchar2 |
||||
transfer_ |
varchar2 |
||||
transfer_ |
varchar2 |
||||
type_ |
varchar2 |
Nome del tipo | |||
user_ |
varchar2 |
||||
user_ |
varchar2 |
||||
website_ |
varchar2 |
Website through which this invoice was created for eCommerce orders. | |||
website_ |
varchar2 |
Website through which this invoice was created for eCommerce orders. | |||
website_ |
varchar2 |
Website communication history | |||
write_ |
datetime |
Last Updated on | |||
write_ |
varchar2 |
||||
write_ |
varchar2 |
Note di rilascio
Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: