View | Details | Raw Unified | Return to bug 26403
Collapse All | Expand All

(-)a/installer/data/mysql/mandatory/account_credit_types.sql (-14 lines)
Lines 1-14 Link Here
1
INSERT INTO account_credit_types ( code, description, can_be_added_manually, is_system ) VALUES
2
('OVERPAYMENT', 'Overpayment refund', 0, 1),
3
('PAYMENT', 'Payment', 0, 1),
4
('WRITEOFF', 'Writeoff', 0, 1),
5
('FORGIVEN', 'Forgiven', 1, 1),
6
('CREDIT', 'Credit', 1, 1),
7
('DISCOUNT', 'A discount applied to a patrons fine', 0, 1),
8
('REFUND', 'Refund', 0, 1),
9
('LOST_FOUND', 'Lost item fee refund', 0, 1),
10
('PURCHASE', 'Purchase', 0, 1),
11
('CANCELLATION', 'Cancellation', 0, 1),
12
('PROCESSING_FOUND', 'Lost item processing fee refund', 0, 1);
13
14
INSERT INTO authorised_values (category,authorised_value,lib) VALUES ('PAYMENT_TYPE','CASH','Cash');
(-)a/installer/data/mysql/mandatory/account_debit_types.sql (-18 lines)
Lines 1-17 Link Here
1
INSERT INTO account_debit_types ( code, description, can_be_invoiced, can_be_sold, default_amount, is_system ) VALUES
2
('ACCOUNT', 'Account creation fee', 0, 0, NULL, 1),
3
('ACCOUNT_RENEW', 'Account renewal fee', 0, 0, NULL, 1),
4
('LOST', 'Lost item', 1, 0, NULL, 1),
5
('MANUAL', 'Manual fee', 1, 0, NULL, 0),
6
('NEW_CARD', 'New card fee', 1, 0, NULL, 1),
7
('OVERDUE', 'Overdue fine', 0, 0, NULL, 1),
8
('PROCESSING', 'Lost item processing fee', 0, 0, NULL, 1),
9
('PAYOUT', 'Payment from library to patron', 0, 0, NULL, 1),
10
('RENT', 'Rental fee', 0, 0, NULL, 1),
11
('RENT_DAILY', 'Daily rental fee', 0, 0, NULL, 1),
12
('RENT_RENEW', 'Renewal of rental item', 0, 0, NULL, 1),
13
('RENT_DAILY_RENEW', 'Renewal of daily rental item', 0, 0, NULL, 1),
14
('RESERVE', 'Hold fee', 0, 0, NULL, 1),
15
('RESERVE_EXPIRED', 'Hold waiting too long', 0, 0, NULL, 1),
16
('VOID', 'Credit has been voided', 0, 0, NULL, 1),
17
('ARTICLE_REQUEST', 'Article request fee', 0, 0, NULL, 1);
18
- 

Return to bug 26403