Would like to know which table shows relation between partner and its payment term.
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Akuntansi
- Inventaris
- PoS
- Project
- MRP
Pertanyaan ini telah diberikan tanda
Using Developer Mode 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_02/#property-fields
Arrrrrrr! 1hour later .... "Property fields like this are stored in the ir_property model." ...cheers
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
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
Menikmati diskusi? Jangan hanya membaca, ikuti!
Buat akun sekarang untuk menikmati fitur eksklufi dan agar terlibat dengan komunitas kami!
DaftarPost Terkait | Replies | Tampilan | Aktivitas | |
---|---|---|---|---|
|
2
Mar 15
|
12644 | ||
|
0
Jul 25
|
1397 | ||
|
2
Nov 24
|
6145 | ||
|
2
Okt 24
|
3119 | ||
|
2
Agu 24
|
1817 |