insert into invoicelinesubtype i (i.invoicelinesubtype_id, subtype, invoicelinetype_id,factorydescription, systemuser_id, timestamp) select seq_invoicelinesubtype.nextval, 0, 1, 'Rent Other Items', 1, sysdate from dual;
insert into invoicelinesubtype i (i.invoicelinesubtype_id, subtype, invoicelinetype_id,factorydescription, systemuser_id, timestamp) select seq_invoicelinesubtype.nextval, 0, 2, 'Wash LOG', 1, sysdate from dual;
insert into invoicelinesubtype i (i.invoicelinesubtype_id, subtype, invoicelinetype_id,factorydescription, systemuser_id, timestamp) select seq_invoicelinesubtype.nextval, 0, 5, 'Sales Products via Delivery Note ', 1, sysdate from dual;
insert into invoicelinesubtype i (i.invoicelinesubtype_id, subtype, invoicelinetype_id,factorydescription, systemuser_id, timestamp) select seq_invoicelinesubtype.nextval, 0, 6, 'Repair', 1, sysdate from dual;
insert into invoicelinesubtype i (i.invoicelinesubtype_id, subtype, invoicelinetype_id,factorydescription, systemuser_id, timestamp) select seq_invoicelinesubtype.nextval, 0, 7, 'Replacement Charge', 1, sysdate from dual;
insert into invoicelinesubtype i (i.invoicelinesubtype_id, subtype, invoicelinetype_id,factorydescription, systemuser_id, timestamp) select seq_invoicelinesubtype.nextval, 0, 8, 'Automatic Replace', 1, sysdate from dual;
insert into invoicelinesubtype i (i.invoicelinesubtype_id, subtype, invoicelinetype_id,factorydescription, systemuser_id, timestamp) select seq_invoicelinesubtype.nextval, 0, 9, 'Loss Charge Non Garments', 1, sysdate from dual;
insert into invoicelinesubtype i (i.invoicelinesubtype_id, subtype, invoicelinetype_id,factorydescription, systemuser_id, timestamp) select seq_invoicelinesubtype.nextval, 0, 10, 'Residual Value Charge', 1, sysdate from dual;
insert into invoicelinesubtype i (i.invoicelinesubtype_id, subtype, invoicelinetype_id,factorydescription, systemuser_id, timestamp) select seq_invoicelinesubtype.nextval, 0, 11, 'Insurance Price per Product', 1, sysdate from dual;
insert into invoicelinesubtype i (i.invoicelinesubtype_id, subtype, invoicelinetype_id,factorydescription, systemuser_id, timestamp) select seq_invoicelinesubtype.nextval, 0, 13, 'Finance Charge', 1, sysdate from dual;
insert into invoicelinesubtype i (i.invoicelinesubtype_id, subtype, invoicelinetype_id,factorydescription, systemuser_id, timestamp) select seq_invoicelinesubtype.nextval, 0, 15, 'Miscellaneous Charge', 1, sysdate from dual;
insert into invoicelinesubtype i (i.invoicelinesubtype_id, subtype, invoicelinetype_id,factorydescription, systemuser_id, timestamp) select seq_invoicelinesubtype.nextval, 0, 17, 'Minimum Invoice Charge', 1, sysdate from dual;
insert into invoicelinesubtype i (i.invoicelinesubtype_id, subtype, invoicelinetype_id,factorydescription, systemuser_id, timestamp) select seq_invoicelinesubtype.nextval, 0, 19, 'Emblem Rent', 1, sysdate from dual;
insert into invoicelinesubtype i (i.invoicelinesubtype_id, subtype, invoicelinetype_id,factorydescription, systemuser_id, timestamp) select seq_invoicelinesubtype.nextval, 0, 20, 'Locker Rent', 1, sysdate from dual;
insert into invoicelinesubtype i (i.invoicelinesubtype_id, subtype, invoicelinetype_id,factorydescription, systemuser_id, timestamp) select seq_invoicelinesubtype.nextval, 0, 21, 'Locker Service', 1, sysdate from dual;
insert into invoicelinesubtype i (i.invoicelinesubtype_id, subtype, invoicelinetype_id,factorydescription, systemuser_id, timestamp) select seq_invoicelinesubtype.nextval, 0, 22, 'Lease Non Garments', 1, sysdate from dual;
insert into invoicelinesubtype i (i.invoicelinesubtype_id, subtype, invoicelinetype_id,factorydescription, systemuser_id, timestamp) select seq_invoicelinesubtype.nextval, 0, 23, 'Stock Charge', 1, sysdate from dual;
insert into invoicelinesubtype i (i.invoicelinesubtype_id, subtype, invoicelinetype_id,factorydescription, systemuser_id, timestamp) select seq_invoicelinesubtype.nextval, 0, 24, 'Lost Customer Residual Value Charge', 1, sysdate from dual;
insert into invoicelinesubtype i (i.invoicelinesubtype_id, subtype, invoicelinetype_id,factorydescription, systemuser_id, timestamp) select seq_invoicelinesubtype.nextval, 0, 25, 'Lost Revenue Charge', 1, sysdate from dual;
insert into invoicelinesubtype i (i.invoicelinesubtype_id, subtype, invoicelinetype_id,factorydescription, systemuser_id, timestamp) select seq_invoicelinesubtype.nextval, 1, 1, 'Rent by Wearer Product', 1, sysdate from dual;
insert into invoicelinesubtype i (i.invoicelinesubtype_id, subtype, invoicelinetype_id,factorydescription, systemuser_id, timestamp) select seq_invoicelinesubtype.nextval, 1, 2, 'Wash specified by Wearer', 1, sysdate from dual;
insert into invoicelinesubtype i (i.invoicelinesubtype_id, subtype, invoicelinetype_id,factorydescription, systemuser_id, timestamp) select seq_invoicelinesubtype.nextval, 1, 5, 'Garment Sales via automatic sales during issue', 1, sysdate from dual;
insert into invoicelinesubtype i (i.invoicelinesubtype_id, subtype, invoicelinetype_id,factorydescription, systemuser_id, timestamp) select seq_invoicelinesubtype.nextval, 1, 9, 'Loss Charge Garments - Loan products', 1, sysdate from dual;
insert into invoicelinesubtype i (i.invoicelinesubtype_id, subtype, invoicelinetype_id,factorydescription, systemuser_id, timestamp) select seq_invoicelinesubtype.nextval, 1, 22, 'Lease Garments', 1, sysdate from dual;
insert into invoicelinesubtype i (i.invoicelinesubtype_id, subtype, invoicelinetype_id,factorydescription, systemuser_id, timestamp) select seq_invoicelinesubtype.nextval, 2, 1, 'Rent by Wearer Item Condensed', 1, sysdate from dual;
insert into invoicelinesubtype i (i.invoicelinesubtype_id, subtype, invoicelinetype_id,factorydescription, systemuser_id, timestamp) select seq_invoicelinesubtype.nextval, 3, 1, 'Rent by Total Wearer', 1, sysdate from dual;
insert into invoicelinesubtype i (i.invoicelinesubtype_id, subtype, invoicelinetype_id,factorydescription, systemuser_id, timestamp) select seq_invoicelinesubtype.nextval, 4, 1, 'Rent by Product', 1, sysdate from dual;
insert into invoicelinesubtype i (i.invoicelinesubtype_id, subtype, invoicelinetype_id,factorydescription, systemuser_id, timestamp) select seq_invoicelinesubtype.nextval, 5, 1, 'Rent by Wearer Summary', 1, sysdate from dual;
insert into invoicelinesubtype i (i.invoicelinesubtype_id, subtype, invoicelinetype_id,factorydescription, systemuser_id, timestamp) select seq_invoicelinesubtype.nextval, 6, 1, 'Under Use', 1, sysdate from dual;
insert into invoicelinesubtype i (i.invoicelinesubtype_id, subtype, invoicelinetype_id,factorydescription, systemuser_id, timestamp) select seq_invoicelinesubtype.nextval, 7, 1, 'Rent in Advance', 1, sysdate from dual;
insert into invoicelinesubtype i (i.invoicelinesubtype_id, subtype, invoicelinetype_id,factorydescription, systemuser_id, timestamp) select seq_invoicelinesubtype.nextval, 8, 1, 'Additional Rent for Current Period', 1, sysdate from dual;
insert into invoicelinesubtype i (i.invoicelinesubtype_id, subtype, invoicelinetype_id,factorydescription, systemuser_id, timestamp) select seq_invoicelinesubtype.nextval, 9, 12, 'Prep Charges', 1, sysdate from dual;
insert into invoicelinesubtype i (i.invoicelinesubtype_id, subtype, invoicelinetype_id,factorydescription, systemuser_id, timestamp) select seq_invoicelinesubtype.nextval, 10, 12, 'Emblem Charges', 1, sysdate from dual;
insert into invoicelinesubtype i (i.invoicelinesubtype_id, subtype, invoicelinetype_id,factorydescription, systemuser_id, timestamp) select seq_invoicelinesubtype.nextval, 11, 12, 'Label Charges', 1, sysdate from dual;
insert into invoicelinesubtype i (i.invoicelinesubtype_id, subtype, invoicelinetype_id,factorydescription, systemuser_id, timestamp) select seq_invoicelinesubtype.nextval, 12, 12, 'Restocking Fee', 1, sysdate from dual;
insert into invoicelinesubtype i (i.invoicelinesubtype_id, subtype, invoicelinetype_id,factorydescription, systemuser_id, timestamp) select seq_invoicelinesubtype.nextval, 13, 2, 'Changes per Week', 1, sysdate from dual;
insert into invoicelinesubtype i (i.invoicelinesubtype_id, subtype, invoicelinetype_id,factorydescription, systemuser_id, timestamp) select seq_invoicelinesubtype.nextval, 14, 1, 'Rent Deposit Stock', 1, sysdate from dual;
insert into invoicelinesubtype i (i.invoicelinesubtype_id, subtype, invoicelinetype_id,factorydescription, systemuser_id, timestamp) select seq_invoicelinesubtype.nextval, 15, 2, 'Wash COG', 1, sysdate from dual;
insert into invoicelinesubtype i (i.invoicelinesubtype_id, subtype, invoicelinetype_id,factorydescription, systemuser_id, timestamp) select seq_invoicelinesubtype.nextval, 16, 9, 'Loss Credit', 1, sysdate from dual;
insert into invoicelinesubtype i (i.invoicelinesubtype_id, subtype, invoicelinetype_id,factorydescription, systemuser_id, timestamp) select seq_invoicelinesubtype.nextval, 17, 5, 'Garment Sales via Sales Note', 1, sysdate from dual;
insert into invoicelinesubtype i (i.invoicelinesubtype_id, subtype, invoicelinetype_id,factorydescription, systemuser_id, timestamp) select seq_invoicelinesubtype.nextval, 18, 5, 'Garment Sales Credit', 1, sysdate from dual;
insert into invoicelinesubtype i (i.invoicelinesubtype_id, subtype, invoicelinetype_id,factorydescription, systemuser_id, timestamp) select seq_invoicelinesubtype.nextval, 19, 11, 'Garment insurance for Repair ', 1, sysdate from dual;
insert into invoicelinesubtype i (i.invoicelinesubtype_id, subtype, invoicelinetype_id,factorydescription, systemuser_id, timestamp) select seq_invoicelinesubtype.nextval, 20, 11, 'Garment insurance for Loss', 1, sysdate from dual;
insert into invoicelinesubtype i (i.invoicelinesubtype_id, subtype, invoicelinetype_id,factorydescription, systemuser_id, timestamp) select seq_invoicelinesubtype.nextval, 21, 11, 'Garment insurance for Repair and Loss', 1, sysdate from dual;
insert into invoicelinesubtype i (i.invoicelinesubtype_id, subtype, invoicelinetype_id,factorydescription, systemuser_id, timestamp) select seq_invoicelinesubtype.nextval, 22, 11, 'Garment insurance for Residual Value ', 1, sysdate from dual;
insert into invoicelinesubtype i (i.invoicelinesubtype_id, subtype, invoicelinetype_id,factorydescription, systemuser_id, timestamp) select seq_invoicelinesubtype.nextval, 23, 11, 'Garment insurance for Repair and Residual Value', 1, sysdate from dual;
insert into invoicelinesubtype i (i.invoicelinesubtype_id, subtype, invoicelinetype_id,factorydescription, systemuser_id, timestamp) select seq_invoicelinesubtype.nextval, 24, 11, 'Garment insurance for Loss and Residual Value', 1, sysdate from dual;
insert into invoicelinesubtype i (i.invoicelinesubtype_id, subtype, invoicelinetype_id,factorydescription, systemuser_id, timestamp) select seq_invoicelinesubtype.nextval, 25, 11, 'Garment insurance for Loss, Repair and Residual Value', 1, sysdate from dual;
insert into invoicelinesubtype i (i.invoicelinesubtype_id, subtype, invoicelinetype_id,factorydescription, systemuser_id, timestamp) select seq_invoicelinesubtype.nextval, 26, 10, 'Contract Change', 1, sysdate from dual;
insert into invoicelinesubtype i (i.invoicelinesubtype_id, subtype, invoicelinetype_id,factorydescription, systemuser_id, timestamp) select seq_invoicelinesubtype.nextval, 27, 10, 'Replacement', 1, sysdate from dual;
insert into invoicelinesubtype i (i.invoicelinesubtype_id, subtype, invoicelinetype_id,factorydescription, systemuser_id, timestamp) select seq_invoicelinesubtype.nextval, 28, 10, 'Out Of Circulation', 1, sysdate from dual;
insert into invoicelinesubtype i (i.invoicelinesubtype_id, subtype, invoicelinetype_id,factorydescription, systemuser_id, timestamp) select seq_invoicelinesubtype.nextval, 29, 26, 'Laundry', 1, sysdate from dual;
insert into invoicelinesubtype i (i.invoicelinesubtype_id, subtype, invoicelinetype_id,factorydescription, systemuser_id, timestamp) select seq_invoicelinesubtype.nextval, 30, 26, 'Dry clean', 1, sysdate from dual;
insert into invoicelinesubtype i (i.invoicelinesubtype_id, subtype, invoicelinetype_id,factorydescription, systemuser_id, timestamp) select seq_invoicelinesubtype.nextval, 31, 27, 'Labels Charged', 1, sysdate from dual;
insert into invoicelinesubtype i (i.invoicelinesubtype_id, subtype, invoicelinetype_id,factorydescription, systemuser_id, timestamp) select seq_invoicelinesubtype.nextval, 32, 27, 'Labels Free of Charge', 1, sysdate from dual;
insert into invoicelinesubtype i (i.invoicelinesubtype_id, subtype, invoicelinetype_id,factorydescription, systemuser_id, timestamp) select seq_invoicelinesubtype.nextval, 33, 9, 'Loss Charge Garments - Product list per Customer Inactive', 1, sysdate from dual;
insert into invoicelinesubtype i (i.invoicelinesubtype_id, subtype, invoicelinetype_id,factorydescription, systemuser_id, timestamp) select seq_invoicelinesubtype.nextval, 34, 9, 'Loss Charge Garments - Wearer Inventory Inactive', 1, sysdate from dual;
insert into invoicelinesubtype i (i.invoicelinesubtype_id, subtype, invoicelinetype_id,factorydescription, systemuser_id, timestamp) select seq_invoicelinesubtype.nextval, 35, 9, 'Loss Charge Garments - Wearer Inactive', 1, sysdate from dual;
insert into invoicelinesubtype i (i.invoicelinesubtype_id, subtype, invoicelinetype_id,factorydescription, systemuser_id, timestamp) select seq_invoicelinesubtype.nextval, 36, 9, 'Loss Charge Garments - Replacement', 1, sysdate from dual;
insert into invoicelinesubtype i (i.invoicelinesubtype_id, subtype, invoicelinetype_id,factorydescription, systemuser_id, timestamp) select seq_invoicelinesubtype.nextval, 37, 16, 'Client Charge', 1, sysdate from dual;
insert into invoicelinesubtype i (i.invoicelinesubtype_id, subtype, invoicelinetype_id,factorydescription, systemuser_id, timestamp) select seq_invoicelinesubtype.nextval, 38, 12, 'COG Code Label', 1, sysdate from dual;

