Skip to Content
Menu
Musisz się zarejestrować, aby móc wchodzić w interakcje z tą społecznością.
To pytanie dostało ostrzeżenie
4 Odpowiedzi
11301 Widoki

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

Awatar
Odrzuć
Najlepsza odpowiedź

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

Awatar
Odrzuć

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

Najlepsza odpowiedź

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
Awatar
Odrzuć
Najlepsza odpowiedź

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

Awatar
Odrzuć
Najlepsza odpowiedź
Awatar
Odrzuć
Powiązane posty Odpowiedzi Widoki Czynność
2
mar 15
12645
0
lip 25
1398
2
lis 24
6147
2
paź 24
3124
2
sie 24
1817