Difference between revisions of "Payment management"
(→Payment distribution) |
|||
| Line 16: | Line 16: | ||
!field name!!type!!description | !field name!!type!!description | ||
|- | |- | ||
| − | |payment_id||INTEGER|| | + | |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 |
