--todo 10020

insert into DWH_STRING (DWH_STRING_ID, FACTORYDESCRIPTION, MAXSTRINGLENGTH, DIMENSION_TABLE, DIMENSION_COLUMN, SYSTEMUSER_ID, TIMESTAMP)
values (501, 'Weekly', 30, 'Special Charge', 'Frequency', 1, to_date('01-01-2010', 'dd-mm-yyyy'));
insert into DWH_STRING (DWH_STRING_ID, FACTORYDESCRIPTION, MAXSTRINGLENGTH, DIMENSION_TABLE, DIMENSION_COLUMN, SYSTEMUSER_ID, TIMESTAMP)
values (502, 'Every Delivery', 30, 'Special Charge', 'Frequency', 1, to_date('01-01-2010', 'dd-mm-yyyy'));
insert into DWH_STRING (DWH_STRING_ID, FACTORYDESCRIPTION, MAXSTRINGLENGTH, DIMENSION_TABLE, DIMENSION_COLUMN, SYSTEMUSER_ID, TIMESTAMP)
values (503, 'Every Invoice', 30, 'Special Charge', 'Frequency', 1, to_date('01-01-2010', 'dd-mm-yyyy'));
insert into DWH_STRING (DWH_STRING_ID, FACTORYDESCRIPTION, MAXSTRINGLENGTH, DIMENSION_TABLE, DIMENSION_COLUMN, SYSTEMUSER_ID, TIMESTAMP)
values (504, 'Every Direct Invoice Only', 30, 'Special Charge', 'Frequency', 1, to_date('01-01-2010', 'dd-mm-yyyy'));
insert into DWH_STRING (DWH_STRING_ID, FACTORYDESCRIPTION, MAXSTRINGLENGTH, DIMENSION_TABLE, DIMENSION_COLUMN, SYSTEMUSER_ID, TIMESTAMP)
values (505, 'Per Delivered Piece', 30, 'Special Charge', 'Frequency', 1, to_date('01-01-2010', 'dd-mm-yyyy'));
insert into DWH_STRING (DWH_STRING_ID, FACTORYDESCRIPTION, MAXSTRINGLENGTH, DIMENSION_TABLE, DIMENSION_COLUMN, SYSTEMUSER_ID, TIMESTAMP)
values (506, 'Every Printed Delivery Note', 30, 'Special Charge', 'Frequency', 1, to_date('01-01-2010', 'dd-mm-yyyy'));
insert into DWH_STRING (DWH_STRING_ID, FACTORYDESCRIPTION, MAXSTRINGLENGTH, DIMENSION_TABLE, DIMENSION_COLUMN, SYSTEMUSER_ID, TIMESTAMP)
values (507, 'Every Normal Visit', 30, 'Special Charge', 'Frequency', 1, to_date('01-01-2010', 'dd-mm-yyyy'));
insert into DWH_STRING (DWH_STRING_ID, FACTORYDESCRIPTION, MAXSTRINGLENGTH, DIMENSION_TABLE, DIMENSION_COLUMN, SYSTEMUSER_ID, TIMESTAMP)
values (508, 'Every Special Visit', 30, 'Special Charge', 'Frequency', 1, to_date('01-01-2010', 'dd-mm-yyyy'));
insert into DWH_STRING (DWH_STRING_ID, FACTORYDESCRIPTION, MAXSTRINGLENGTH, DIMENSION_TABLE, DIMENSION_COLUMN, SYSTEMUSER_ID, TIMESTAMP)
values (509, 'Every Active Wearer Every Inv.', 30, 'Special Charge', 'Frequency', 1, to_date('01-01-2010', 'dd-mm-yyyy'));
insert into DWH_STRING (DWH_STRING_ID, FACTORYDESCRIPTION, MAXSTRINGLENGTH, DIMENSION_TABLE, DIMENSION_COLUMN, SYSTEMUSER_ID, TIMESTAMP)
values (511, 'Next Visit', 50, 'Product List / Customer', 'Delayed Even Exchange', 1, to_date('01-01-2010', 'dd-mm-yyyy'));
insert into DWH_STRING (DWH_STRING_ID, FACTORYDESCRIPTION, MAXSTRINGLENGTH, DIMENSION_TABLE, DIMENSION_COLUMN, SYSTEMUSER_ID, TIMESTAMP)
values (512, 'Next Week Same Day', 50, 'Product List / Customer', 'Delayed Even Exchange', 1, to_date('01-01-2010', 'dd-mm-yyyy'));
insert into DWH_STRING (DWH_STRING_ID, FACTORYDESCRIPTION, MAXSTRINGLENGTH, DIMENSION_TABLE, DIMENSION_COLUMN, SYSTEMUSER_ID, TIMESTAMP)
values (513, 'With 10 Days Delay', 50, 'Product List / Customer', 'Delayed Even Exchange', 1, to_date('01-01-2010', 'dd-mm-yyyy'));
insert into DWH_STRING (DWH_STRING_ID, FACTORYDESCRIPTION, MAXSTRINGLENGTH, DIMENSION_TABLE, DIMENSION_COLUMN, SYSTEMUSER_ID, TIMESTAMP)
values (514, 'According to Return Route in Route Schedule', 50, 'Product List / Customer', 'Delayed Even Exchange', 1, to_date('01-01-2010', 'dd-mm-yyyy'));
insert into DWH_STRING (DWH_STRING_ID, FACTORYDESCRIPTION, MAXSTRINGLENGTH, DIMENSION_TABLE, DIMENSION_COLUMN, SYSTEMUSER_ID, TIMESTAMP)
values (515, 'With 14 Days Delay', 50, 'Product List / Customer', 'Delayed Even Exchange', 1, to_date('01-01-2010', 'dd-mm-yyyy'));
insert into DWH_STRING (DWH_STRING_ID, FACTORYDESCRIPTION, MAXSTRINGLENGTH, DIMENSION_TABLE, DIMENSION_COLUMN, SYSTEMUSER_ID, TIMESTAMP)
values (516, 'With 28 Days Delay', 50, 'Product List / Customer', 'Delayed Even Exchange', 1, to_date('01-01-2010', 'dd-mm-yyyy'));
insert into DWH_STRING (DWH_STRING_ID, FACTORYDESCRIPTION, MAXSTRINGLENGTH, DIMENSION_TABLE, DIMENSION_COLUMN, SYSTEMUSER_ID, TIMESTAMP)
values (517, 'According to Delivery Scheme', 50, 'Product List / Customer', 'Delayed Even Exchange', 1, to_date('01-01-2010', 'dd-mm-yyyy'));
insert into DWH_STRING (DWH_STRING_ID, FACTORYDESCRIPTION, MAXSTRINGLENGTH, DIMENSION_TABLE, DIMENSION_COLUMN, SYSTEMUSER_ID, TIMESTAMP)
values (519, 'Yes, Except Special Sizes', 30, 'Product List / Customer', 'Allow Return to Stock', 1, to_date('01-01-2010', 'dd-mm-yyyy'));
insert into DWH_STRING (DWH_STRING_ID, FACTORYDESCRIPTION, MAXSTRINGLENGTH, DIMENSION_TABLE, DIMENSION_COLUMN, SYSTEMUSER_ID, TIMESTAMP)
values (521, 'Packingnote', 30, 'Product List / Customer', 'Specific Put up Type', 1, to_date('01-01-2010', 'dd-mm-yyyy'));
insert into DWH_STRING (DWH_STRING_ID, FACTORYDESCRIPTION, MAXSTRINGLENGTH, DIMENSION_TABLE, DIMENSION_COLUMN, SYSTEMUSER_ID, TIMESTAMP)
values (522, 'Bulk Put up', 30, 'Product List / Customer', 'Specific Put up Type', 1, to_date('01-01-2010', 'dd-mm-yyyy'));
insert into DWH_STRING (DWH_STRING_ID, FACTORYDESCRIPTION, MAXSTRINGLENGTH, DIMENSION_TABLE, DIMENSION_COLUMN, SYSTEMUSER_ID, TIMESTAMP)
values (523, 'Bundle Tag / Packer', 30, 'Product List / Customer', 'Specific Put up Type', 1, to_date('01-01-2010', 'dd-mm-yyyy'));
insert into DWH_STRING (DWH_STRING_ID, FACTORYDESCRIPTION, MAXSTRINGLENGTH, DIMENSION_TABLE, DIMENSION_COLUMN, SYSTEMUSER_ID, TIMESTAMP)
values (524, 'Bulk Put up Scan per Route', 30, 'Product List / Customer', 'Specific Put up Type', 1, to_date('01-01-2010', 'dd-mm-yyyy'));
insert into DWH_STRING (DWH_STRING_ID, FACTORYDESCRIPTION, MAXSTRINGLENGTH, DIMENSION_TABLE, DIMENSION_COLUMN, SYSTEMUSER_ID, TIMESTAMP)
values (525, 'Packer Loose Linen', 30, 'Product List / Customer', 'Specific Put up Type', 1, to_date('01-01-2010', 'dd-mm-yyyy'));
insert into DWH_STRING (DWH_STRING_ID, FACTORYDESCRIPTION, MAXSTRINGLENGTH, DIMENSION_TABLE, DIMENSION_COLUMN, SYSTEMUSER_ID, TIMESTAMP)
values (531, '% of Soil Count', 30, 'Product List / Customer', 'Systematic Repl. Charge Method', 1, to_date('01-01-2010', 'dd-mm-yyyy'));
insert into DWH_STRING (DWH_STRING_ID, FACTORYDESCRIPTION, MAXSTRINGLENGTH, DIMENSION_TABLE, DIMENSION_COLUMN, SYSTEMUSER_ID, TIMESTAMP)
values (532, '% of Circulating Inventory', 30, 'Product List / Customer', 'Systematic Repl. Charge Method', 1, to_date('01-01-2010', 'dd-mm-yyyy'));
insert into DWH_STRING (DWH_STRING_ID, FACTORYDESCRIPTION, MAXSTRINGLENGTH, DIMENSION_TABLE, DIMENSION_COLUMN, SYSTEMUSER_ID, TIMESTAMP)
values (533, 'Fixed Quantity', 30, 'Product List / Customer', 'Systematic Repl. Charge Method', 1, to_date('01-01-2010', 'dd-mm-yyyy'));
insert into DWH_STRING (DWH_STRING_ID, FACTORYDESCRIPTION, MAXSTRINGLENGTH, DIMENSION_TABLE, DIMENSION_COLUMN, SYSTEMUSER_ID, TIMESTAMP)
values (541, 'Every Delivery', 30, 'Product List / Customer', 'Systematic Repl. Charge Freq.', 1, to_date('01-01-2010', 'dd-mm-yyyy'));
insert into DWH_STRING (DWH_STRING_ID, FACTORYDESCRIPTION, MAXSTRINGLENGTH, DIMENSION_TABLE, DIMENSION_COLUMN, SYSTEMUSER_ID, TIMESTAMP)
values (542, 'Every Week First Delivery', 30, 'Product List / Customer', 'Systematic Repl. Charge Freq.', 1, to_date('01-01-2010', 'dd-mm-yyyy'));
insert into DWH_STRING (DWH_STRING_ID, FACTORYDESCRIPTION, MAXSTRINGLENGTH, DIMENSION_TABLE, DIMENSION_COLUMN, SYSTEMUSER_ID, TIMESTAMP)
values (543, 'Every Week Last Delivery', 30, 'Product List / Customer', 'Systematic Repl. Charge Freq.', 1, to_date('01-01-2010', 'dd-mm-yyyy'));
insert into DWH_STRING (DWH_STRING_ID, FACTORYDESCRIPTION, MAXSTRINGLENGTH, DIMENSION_TABLE, DIMENSION_COLUMN, SYSTEMUSER_ID, TIMESTAMP)
values (551, 'Every Week (Accumulated)', 30, 'Product List / Customer', 'Minimum Billing Frequency', 1, to_date('01-01-2010', 'dd-mm-yyyy'));
insert into DWH_STRING (DWH_STRING_ID, FACTORYDESCRIPTION, MAXSTRINGLENGTH, DIMENSION_TABLE, DIMENSION_COLUMN, SYSTEMUSER_ID, TIMESTAMP)
values (552, 'Every Visit (When Billed)', 30, 'Product List / Customer', 'Minimum Billing Frequency', 1, to_date('01-01-2010', 'dd-mm-yyyy'));
insert into DWH_STRING (DWH_STRING_ID, FACTORYDESCRIPTION, MAXSTRINGLENGTH, DIMENSION_TABLE, DIMENSION_COLUMN, SYSTEMUSER_ID, TIMESTAMP)
values (553, 'Every Month', 30, 'Product List / Customer', 'Minimum Billing Frequency', 1, to_date('01-01-2010', 'dd-mm-yyyy'));
insert into DWH_STRING (DWH_STRING_ID, FACTORYDESCRIPTION, MAXSTRINGLENGTH, DIMENSION_TABLE, DIMENSION_COLUMN, SYSTEMUSER_ID, TIMESTAMP)
values (554, 'Every Delivery with Qty > 0', 30, 'Product List / Customer', 'Minimum Billing Frequency', 1, to_date('01-01-2010', 'dd-mm-yyyy'));
insert into DWH_STRING (DWH_STRING_ID, FACTORYDESCRIPTION, MAXSTRINGLENGTH, DIMENSION_TABLE, DIMENSION_COLUMN, SYSTEMUSER_ID, TIMESTAMP)
values (555, 'Delivery Scheme Based', 30, 'Product List / Customer', 'Minimum Billing Frequency', 1, to_date('01-01-2010', 'dd-mm-yyyy'));
insert into DWH_STRING (DWH_STRING_ID, FACTORYDESCRIPTION, MAXSTRINGLENGTH, DIMENSION_TABLE, DIMENSION_COLUMN, SYSTEMUSER_ID, TIMESTAMP)
values (560, 'Per Week', 15, 'Product List / Customer', 'Free of Charge Frequency', 1, to_date('01-01-2010', 'dd-mm-yyyy'));
insert into DWH_STRING (DWH_STRING_ID, FACTORYDESCRIPTION, MAXSTRINGLENGTH, DIMENSION_TABLE, DIMENSION_COLUMN, SYSTEMUSER_ID, TIMESTAMP)
values (561, 'Per Invoice', 15, 'Product List / Customer', 'Free of Charge Frequency', 1, to_date('01-01-2010', 'dd-mm-yyyy'));
insert into DWH_STRING (DWH_STRING_ID, FACTORYDESCRIPTION, MAXSTRINGLENGTH, DIMENSION_TABLE, DIMENSION_COLUMN, SYSTEMUSER_ID, TIMESTAMP)
values (571, 'Split Price', 20, 'Product List / Customer', 'Price Usage', 1, to_date('01-01-2010', 'dd-mm-yyyy'));
insert into DWH_STRING (DWH_STRING_ID, FACTORYDESCRIPTION, MAXSTRINGLENGTH, DIMENSION_TABLE, DIMENSION_COLUMN, SYSTEMUSER_ID, TIMESTAMP)
values (572, 'Rent Price Only', 20, 'Product List / Customer', 'Price Usage', 1, to_date('01-01-2010', 'dd-mm-yyyy'));
insert into DWH_STRING (DWH_STRING_ID, FACTORYDESCRIPTION, MAXSTRINGLENGTH, DIMENSION_TABLE, DIMENSION_COLUMN, SYSTEMUSER_ID, TIMESTAMP)
values (573, 'Wash Price Only', 20, 'Product List / Customer', 'Price Usage', 1, to_date('01-01-2010', 'dd-mm-yyyy'));
insert into DWH_STRING (DWH_STRING_ID, FACTORYDESCRIPTION, MAXSTRINGLENGTH, DIMENSION_TABLE, DIMENSION_COLUMN, SYSTEMUSER_ID, TIMESTAMP)
values (581, 'Pack', 15, 'Product List / Customer', 'Charge Washes Pack', 1, to_date('01-01-2010', 'dd-mm-yyyy'));
insert into DWH_STRING (DWH_STRING_ID, FACTORYDESCRIPTION, MAXSTRINGLENGTH, DIMENSION_TABLE, DIMENSION_COLUMN, SYSTEMUSER_ID, TIMESTAMP)
values (582, 'Content', 15, 'Product List / Customer', 'Charge Washes Pack', 1, to_date('01-01-2010', 'dd-mm-yyyy'));
insert into DWH_STRING (DWH_STRING_ID, FACTORYDESCRIPTION, MAXSTRINGLENGTH, DIMENSION_TABLE, DIMENSION_COLUMN, SYSTEMUSER_ID, TIMESTAMP)
values (583, 'Both', 15, 'Product List / Customer', 'Charge Washes Pack', 1, to_date('01-01-2010', 'dd-mm-yyyy'));
insert into DWH_STRING (DWH_STRING_ID, FACTORYDESCRIPTION, MAXSTRINGLENGTH, DIMENSION_TABLE, DIMENSION_COLUMN, SYSTEMUSER_ID, TIMESTAMP)
values (590, 'Both LOG and COG, same Wash Price', 40, 'Product List / Customer', 'Charge Washes COG', 1, to_date('01-01-2010', 'dd-mm-yyyy'));
insert into DWH_STRING (DWH_STRING_ID, FACTORYDESCRIPTION, MAXSTRINGLENGTH, DIMENSION_TABLE, DIMENSION_COLUMN, SYSTEMUSER_ID, TIMESTAMP)
values (591, 'Both LOG and COG, distinct Wash Price', 40, 'Product List / Customer', 'Charge Washes COG', 1, to_date('01-01-2010', 'dd-mm-yyyy'));
insert into DWH_STRING (DWH_STRING_ID, FACTORYDESCRIPTION, MAXSTRINGLENGTH, DIMENSION_TABLE, DIMENSION_COLUMN, SYSTEMUSER_ID, TIMESTAMP)
values (592, 'LOG Only', 40, 'Product List / Customer', 'Charge Washes COG', 1, to_date('01-01-2010', 'dd-mm-yyyy'));
insert into DWH_STRING (DWH_STRING_ID, FACTORYDESCRIPTION, MAXSTRINGLENGTH, DIMENSION_TABLE, DIMENSION_COLUMN, SYSTEMUSER_ID, TIMESTAMP)
values (593, 'COG Only', 40, 'Product List / Customer', 'Charge Washes COG', 1, to_date('01-01-2010', 'dd-mm-yyyy'));
insert into DWH_STRING (DWH_STRING_ID, FACTORYDESCRIPTION, MAXSTRINGLENGTH, DIMENSION_TABLE, DIMENSION_COLUMN, SYSTEMUSER_ID, TIMESTAMP)
values (594, 'Sales Only', 40, 'Product List / Customer', 'Charge Washes COG', 1, to_date('01-01-2010', 'dd-mm-yyyy'));
update dwh_string s set s.factorydescription = 'Charge # Pcs per Bank/Locker' where s.dwh_string_id=238;
update dwh_string s set s.factorydescription = 'Summary Pers.Billing TotalCode' where s.dwh_string_id=256;
update dwh_string s set s.factorydescription = 'In Advance Correct Addit. Only' where s.dwh_string_id=261;
