DB table relating Partner and its Payment term

Question

Would like to know which table shows relation between partner and its payment term.

Ray Carnes · Answer

Using Developer Mode [1] you can hover over any field to see the business object (model) details:

This tells you the *Customer Payment Term* field is called property_payment_term and that it is a many2one field that relates the res.partner model (the model that holds the basic Customer information) with the account.payment.term model.**
**
** Property fields like this are stored in the *ir_property* model.

More about these kinds of fields at https://doc.openerp.com/trunk/server/03_module_dev_

Estudios, Procesos y Sistemas · Answer

Use this SQL

SELECT RP.NAME PARTNER, PT.NAME PAYMENT_TERM FROM IR_PROPERTY IP, RES_PARTNER RP, ACCOUNT_PAYMENT_TERM PT WHERE IP.NAME LIKE '%payment_term' AND CONCAT('res.partner,',RP.ID) = IP.RES_ID AND CONCAT('account.payment.term,',PT.ID) = IP.VALUE_REFERENCE

cd · Answer

**ACCOUNT_PAYMENT_TERM**
id (ex 1)
name (ex 'Immediate payment')
**RES_PARTNER**
id = the ide of the partner
**IR_PROPERTY**
name="property payment term"
value_reference="account.payment.term," + the id of the account_payment__term (ex 1)
res_id = "res_partner," + the id the partner

Relaterade inlägg	Svar	Vyer
How to convert from filestore to databasestore? v6.1 database filestore	2 mars 15	14940
FAQs: Como alterar a passagem na TAP? v6.1	0 juni 26	1
In Odoo, what is the purpose of the PostgreSQL database, and how does Odoo use it? database	0 maj 26	6
{✨📲GUÍA-España~Teléfono} GUÍA Delta España ¿Cómo comunicarse con Delta en España? v6.1	0 maj 26	1
Can i use the same Database for a company with different Department database	0 maj 26	61

Denna fråga har flaggats

ACCOUNT_PAYMENT_TERM

RES_PARTNER

IR_PROPERTY

Njuter du av diskussionen? Läs inte bara, delta också!