Přejít na obsah
Menu
You need to be registered to interact with the community.
This question has been flagged
4 Odpovědi
11283 Zobrazení

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

Avatar
Zrušit
Nejlepší odpověď

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

image description

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

Avatar
Zrušit

Arrrrrrr! 1hour later .... "Property fields like this are stored in the ir_property model." ...cheers

Nejlepší odpověď

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
Avatar
Zrušit
Nejlepší odpověď

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

Avatar
Zrušit
Nejlepší odpověď
Avatar
Zrušit
Related Posts Odpovědi Zobrazení Aktivita
2
bře 15
12634
0
čvc 25
1373
2
lis 24
6117
2
říj 24
3101
2
srp 24
1814