Difference between revisions of "Payment management"
(New page: =Payment type= {| {{prettytable}} !field name!!type!!description |- |id||INTEGER||primary key |- |name||TEXT||payment type name |- |text_field_label||TEXT||text field label. If no text fie...) |
(→Payment distribution) |
||
| (One intermediate revision by the same user not shown) | |||
| Line 10: | Line 10: | ||
|- | |- | ||
|order_num||INTEGER||as usual | |order_num||INTEGER||as usual | ||
| + | |} | ||
| + | |||
| + | =Payment distribution= | ||
| + | {| {{prettytable}} | ||
| + | !field name!!type!!description | ||
| + | |- | ||
| + | |payment_id||INTEGER||external key to payment_type.id | ||
| + | |- | ||
| + | |account_club_id||INTEGER||external key to account_club.id | ||
|} | |} | ||
Latest revision as of 22:56, 12 February 2007
Payment type
| field name | type | description |
|---|---|---|
| id | INTEGER | primary key |
| name | TEXT | payment type name |
| text_field_label | TEXT | text field label. If no text field, NULL (text field may be use to fill the cheque number for example) |
| order_num | INTEGER | as usual |
Payment distribution
| field name | type | description |
|---|---|---|
| payment_id | INTEGER | external key to payment_type.id |
| account_club_id | INTEGER | external key to account_club.id |
