expensetype.txt

来自「国外的一套开源CRM」· 文本 代码 · 共 10 行

insert into expense_type values ( 1, 'telephone usage', 'Charges from actual telephone usage.', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into expense_type values ( 2, 'telephone base', 'Charges for telephone not associated to usage.', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into expense_type values ( 3, 'breakfast', 'Total amount of breakfast including tips.', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into expense_type values ( 4, 'lunch', 'Total amount of lunch including tips.', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into expense_type values ( 5, 'dinner', 'Total amount of dinner including tips.', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into expense_type values ( 6, 'air travel', 'Total amount from Air Tickets.', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into expense_type values ( 7, 'ground travel', 'Total amount from taxis', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into expense_type values ( 8, 'parking', 'Amount from parking fees.', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into expense_type values ( 9, 'hotel', 'Amount from hotel stay.', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');
insert into expense_type values ( 10, 'misc', 'Mmiscellaneous charges.', 'sfa', '1970-12-31 00:00:00', 'sfa', '1970-12-31 00:00:00');