コンテンツへスキップ
メニュー
この質問にフラグが付けられました
4 返信
11453 ビュー

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

アバター
破棄
最善の回答

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

アバター
破棄

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

アバター
破棄
最善の回答
アバター
破棄
関連投稿 返信 ビュー 活動
2
3月 15
12787
0
7月 25
1522
2
11月 24
6547
2
10月 24
3488
2
8月 24
2005