--order 502383      
      /*
      CHANGE REPORT for Table DWH_SETTINGSPERTABLE
          - Adding column SOURCESYSTEM
      ACTION is ALTER or modify Table DWH_SETTINGSPERTABLE
      */

ALTER TABLE DWH_SETTINGSPERTABLE ADD (SOURCESYSTEM         NUMBER DEFAULT 0 NOT 
    NULL
                                   CONSTRAINT SourceSystem_valid
                                          CHECK (SOURCESYSTEM IN (0, 1, 2)));

COMMENT ON COLUMN DWH_SETTINGSPERTABLE.SOURCESYSTEM IS 'Defines the source system for the table 
0=ABSSolute
1=PIMS
2=Other System';

-- delete all old rows
truncate table DWH_SETTINGSPERTABLE;

-- insert new rows
insert into DWH_SETTINGSPERTABLE
  (TABLENAME, ISFACTYN, LOADYN, SYSTEMUSER_ID, TIMESTAMP, SOURCESYSTEM)
values
  ('PRODUCTION_QUANTITIES',
   'Y',
   'Y',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'),
   1);
insert into DWH_SETTINGSPERTABLE
  (TABLENAME, ISFACTYN, LOADYN, SYSTEMUSER_ID, TIMESTAMP, SOURCESYSTEM)
values
  ('GARMENT_ISSUE', 'Y', 'Y', 1, to_date('01-01-2009', 'dd-mm-yyyy'), 0);
insert into DWH_SETTINGSPERTABLE
  (TABLENAME, ISFACTYN, LOADYN, SYSTEMUSER_ID, TIMESTAMP, SOURCESYSTEM)
values
  ('CLEAN_WEIGHT', 'Y', 'Y', 1, to_date('01-01-2009', 'dd-mm-yyyy'), 0);
insert into DWH_SETTINGSPERTABLE
  (TABLENAME, ISFACTYN, LOADYN, SYSTEMUSER_ID, TIMESTAMP, SOURCESYSTEM)
values
  ('SOIL_WEIGHT', 'Y', 'Y', 1, to_date('01-01-2009', 'dd-mm-yyyy'), 0);
insert into DWH_SETTINGSPERTABLE
  (TABLENAME, ISFACTYN, LOADYN, SYSTEMUSER_ID, TIMESTAMP, SOURCESYSTEM)
values
  ('WEIGHINGCATEGORY', 'N', 'Y', 1, to_date('01-01-2009', 'dd-mm-yyyy'), 0);
insert into DWH_SETTINGSPERTABLE
  (TABLENAME, ISFACTYN, LOADYN, SYSTEMUSER_ID, TIMESTAMP, SOURCESYSTEM)
values
  ('TURNOVERGROUP', 'N', 'Y', 1, to_date('01-01-2009', 'dd-mm-yyyy'), 0);
insert into DWH_SETTINGSPERTABLE
  (TABLENAME, ISFACTYN, LOADYN, SYSTEMUSER_ID, TIMESTAMP, SOURCESYSTEM)
values
  ('BUSINESSUNIT', 'N', 'Y', 1, to_date('01-01-2009', 'dd-mm-yyyy'), 0);
insert into DWH_SETTINGSPERTABLE
  (TABLENAME, ISFACTYN, LOADYN, SYSTEMUSER_ID, TIMESTAMP, SOURCESYSTEM)
values
  ('ROUTE', 'N', 'Y', 1, to_date('01-01-2009', 'dd-mm-yyyy'), 0);
insert into DWH_SETTINGSPERTABLE
  (TABLENAME, ISFACTYN, LOADYN, SYSTEMUSER_ID, TIMESTAMP, SOURCESYSTEM)
values
  ('QUALITYGRADE', 'N', 'Y', 1, to_date('01-01-2009', 'dd-mm-yyyy'), 0);
insert into DWH_SETTINGSPERTABLE
  (TABLENAME, ISFACTYN, LOADYN, SYSTEMUSER_ID, TIMESTAMP, SOURCESYSTEM)
values
  ('PRODUCT', 'N', 'Y', 1, to_date('01-01-2009', 'dd-mm-yyyy'), 0);
insert into DWH_SETTINGSPERTABLE
  (TABLENAME, ISFACTYN, LOADYN, SYSTEMUSER_ID, TIMESTAMP, SOURCESYSTEM)
values
  ('CHARGETYPE', 'N', 'Y', 1, to_date('01-01-2009', 'dd-mm-yyyy'), 0);
insert into DWH_SETTINGSPERTABLE
  (TABLENAME, ISFACTYN, LOADYN, SYSTEMUSER_ID, TIMESTAMP, SOURCESYSTEM)
values
  ('DELIVERIES', 'Y', 'Y', 1, to_date('01-01-2009', 'dd-mm-yyyy'), 0);
insert into DWH_SETTINGSPERTABLE
  (TABLENAME, ISFACTYN, LOADYN, SYSTEMUSER_ID, TIMESTAMP, SOURCESYSTEM)
values
  ('CURRENCY', 'N', 'Y', 1, to_date('01-01-2009', 'dd-mm-yyyy'), 0);
insert into DWH_SETTINGSPERTABLE
  (TABLENAME, ISFACTYN, LOADYN, SYSTEMUSER_ID, TIMESTAMP, SOURCESYSTEM)
values
  ('INVOICE', 'N', 'Y', 1, to_date('01-01-2009', 'dd-mm-yyyy'), 0);
insert into DWH_SETTINGSPERTABLE
  (TABLENAME, ISFACTYN, LOADYN, SYSTEMUSER_ID, TIMESTAMP, SOURCESYSTEM)
values
  ('GROWTHREASON', 'N', 'Y', 1, to_date('01-01-2009', 'dd-mm-yyyy'), 0);
insert into DWH_SETTINGSPERTABLE
  (TABLENAME, ISFACTYN, LOADYN, SYSTEMUSER_ID, TIMESTAMP, SOURCESYSTEM)
values
  ('REVENUE_GROWTH', 'Y', 'Y', 1, to_date('01-01-2009', 'dd-mm-yyyy'), 0);
insert into DWH_SETTINGSPERTABLE
  (TABLENAME, ISFACTYN, LOADYN, SYSTEMUSER_ID, TIMESTAMP, SOURCESYSTEM)
values
  ('REASONCODE', 'N', 'Y', 1, to_date('01-01-2009', 'dd-mm-yyyy'), 0);
insert into DWH_SETTINGSPERTABLE
  (TABLENAME, ISFACTYN, LOADYN, SYSTEMUSER_ID, TIMESTAMP, SOURCESYSTEM)
values
  ('REVENUE', 'Y', 'Y', 1, to_date('01-01-2009', 'dd-mm-yyyy'), 0);
insert into DWH_SETTINGSPERTABLE
  (TABLENAME, ISFACTYN, LOADYN, SYSTEMUSER_ID, TIMESTAMP, SOURCESYSTEM)
values
  ('CUSTOMER', 'N', 'Y', 1, to_date('01-01-2009', 'dd-mm-yyyy'), 0);
insert into DWH_SETTINGSPERTABLE
  (TABLENAME, ISFACTYN, LOADYN, SYSTEMUSER_ID, TIMESTAMP, SOURCESYSTEM)
values
  ('TIME', 'N', 'Y', 1, to_date('01-01-2009', 'dd-mm-yyyy'), 0);
insert into DWH_SETTINGSPERTABLE
  (TABLENAME, ISFACTYN, LOADYN, SYSTEMUSER_ID, TIMESTAMP, SOURCESYSTEM)
values
  ('FINISHINGMETHOD', 'N', 'Y', 1, to_date('01-01-2009', 'dd-mm-yyyy'), 0);
insert into DWH_SETTINGSPERTABLE
  (TABLENAME, ISFACTYN, LOADYN, SYSTEMUSER_ID, TIMESTAMP, SOURCESYSTEM)
values
  ('CONTACTCATEGORY', 'N', 'Y', 1, to_date('01-01-2009', 'dd-mm-yyyy'), 0);
insert into DWH_SETTINGSPERTABLE
  (TABLENAME, ISFACTYN, LOADYN, SYSTEMUSER_ID, TIMESTAMP, SOURCESYSTEM)
values
  ('CLOSED_CONTACTS', 'Y', 'Y', 1, to_date('01-01-2009', 'dd-mm-yyyy'), 0);
insert into DWH_SETTINGSPERTABLE
  (TABLENAME, ISFACTYN, LOADYN, SYSTEMUSER_ID, TIMESTAMP, SOURCESYSTEM)
values
  ('DELIVERY_NOTE', 'N', 'Y', 1, to_date('01-01-2009', 'dd-mm-yyyy'), 0);
insert into DWH_SETTINGSPERTABLE
  (TABLENAME, ISFACTYN, LOADYN, SYSTEMUSER_ID, TIMESTAMP, SOURCESYSTEM)
values
  ('COSTS_PBA', 'Y', 'Y', 1, to_date('01-01-2009', 'dd-mm-yyyy'), 0);
insert into DWH_SETTINGSPERTABLE
  (TABLENAME, ISFACTYN, LOADYN, SYSTEMUSER_ID, TIMESTAMP, SOURCESYSTEM)
values
  ('CREDITS', 'Y', 'Y', 1, to_date('01-01-2009', 'dd-mm-yyyy'), 0);
insert into DWH_SETTINGSPERTABLE
  (TABLENAME, ISFACTYN, LOADYN, SYSTEMUSER_ID, TIMESTAMP, SOURCESYSTEM)
values
  ('STAY', 'N', 'Y', 1, to_date('01-01-2009', 'dd-mm-yyyy'), 0);
insert into DWH_SETTINGSPERTABLE
  (TABLENAME, ISFACTYN, LOADYN, SYSTEMUSER_ID, TIMESTAMP, SOURCESYSTEM)
values
  ('TRANSACTION_TYPE', 'N', 'Y', 1, to_date('01-01-2009', 'dd-mm-yyyy'), 0);
insert into DWH_SETTINGSPERTABLE
  (TABLENAME, ISFACTYN, LOADYN, SYSTEMUSER_ID, TIMESTAMP, SOURCESYSTEM)
values
  ('STOCK_ROOM', 'N', 'Y', 1, to_date('01-01-2009', 'dd-mm-yyyy'), 0);
insert into DWH_SETTINGSPERTABLE
  (TABLENAME, ISFACTYN, LOADYN, SYSTEMUSER_ID, TIMESTAMP, SOURCESYSTEM)
values
  ('SYSTEM_USER', 'N', 'Y', 1, to_date('01-01-2009', 'dd-mm-yyyy'), 0);
insert into DWH_SETTINGSPERTABLE
  (TABLENAME, ISFACTYN, LOADYN, SYSTEMUSER_ID, TIMESTAMP, SOURCESYSTEM)
values
  ('SCANS', 'Y', 'Y', 1, to_date('01-01-2009', 'dd-mm-yyyy'), 0);
insert into DWH_SETTINGSPERTABLE
  (TABLENAME, ISFACTYN, LOADYN, SYSTEMUSER_ID, TIMESTAMP, SOURCESYSTEM)
values
  ('ROUTE_HISTORY', 'Y', 'Y', 1, to_date('01-01-2009', 'dd-mm-yyyy'), 0);
insert into DWH_SETTINGSPERTABLE
  (TABLENAME, ISFACTYN, LOADYN, SYSTEMUSER_ID, TIMESTAMP, SOURCESYSTEM)
values
  ('WORKSPOT', 'N', 'Y', 1, to_date('01-01-2009', 'dd-mm-yyyy'), 1);
insert into DWH_SETTINGSPERTABLE
  (TABLENAME, ISFACTYN, LOADYN, SYSTEMUSER_ID, TIMESTAMP, SOURCESYSTEM)
values
  ('SHIFT', 'N', 'Y', 1, to_date('01-01-2009', 'dd-mm-yyyy'), 1);
insert into DWH_SETTINGSPERTABLE
  (TABLENAME, ISFACTYN, LOADYN, SYSTEMUSER_ID, TIMESTAMP, SOURCESYSTEM)
values
  ('HOUR_TYPE', 'N', 'Y', 1, to_date('01-01-2009', 'dd-mm-yyyy'), 1);
insert into DWH_SETTINGSPERTABLE
  (TABLENAME, ISFACTYN, LOADYN, SYSTEMUSER_ID, TIMESTAMP, SOURCESYSTEM)
values
  ('ABSENCE_REASON', 'N', 'Y', 1, to_date('01-01-2009', 'dd-mm-yyyy'), 1);
insert into DWH_SETTINGSPERTABLE
  (TABLENAME, ISFACTYN, LOADYN, SYSTEMUSER_ID, TIMESTAMP, SOURCESYSTEM)
values
  ('PIMS_EMPLOYEE', 'N', 'Y', 1, to_date('01-01-2009', 'dd-mm-yyyy'), 1);
insert into DWH_SETTINGSPERTABLE
  (TABLENAME, ISFACTYN, LOADYN, SYSTEMUSER_ID, TIMESTAMP, SOURCESYSTEM)
values
  ('JOB_CODE', 'N', 'Y', 1, to_date('01-01-2009', 'dd-mm-yyyy'), 1);
insert into DWH_SETTINGSPERTABLE
  (TABLENAME, ISFACTYN, LOADYN, SYSTEMUSER_ID, TIMESTAMP, SOURCESYSTEM)
values
  ('PIMS_BUSINESS_UNIT',
   'N',
   'Y',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'),
   1);
insert into DWH_SETTINGSPERTABLE
  (TABLENAME, ISFACTYN, LOADYN, SYSTEMUSER_ID, TIMESTAMP, SOURCESYSTEM)
values
  ('AR_AGING_SNAPSHOT',
   'Y',
   'Y',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'),
   0);
insert into DWH_SETTINGSPERTABLE
  (TABLENAME, ISFACTYN, LOADYN, SYSTEMUSER_ID, TIMESTAMP, SOURCESYSTEM)
values
  ('AR_TRANSACTION_TYPE',
   'N',
   'Y',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'),
   0);
insert into DWH_SETTINGSPERTABLE
  (TABLENAME, ISFACTYN, LOADYN, SYSTEMUSER_ID, TIMESTAMP, SOURCESYSTEM)
values
  ('AR_TRANSACTIONS', 'Y', 'Y', 1, to_date('01-01-2009', 'dd-mm-yyyy'), 0);
insert into DWH_SETTINGSPERTABLE
  (TABLENAME, ISFACTYN, LOADYN, SYSTEMUSER_ID, TIMESTAMP, SOURCESYSTEM)
values
  ('GARMENT_SALES', 'Y', 'Y', 1, to_date('01-01-2009', 'dd-mm-yyyy'), 0);
insert into DWH_SETTINGSPERTABLE
  (TABLENAME, ISFACTYN, LOADYN, SYSTEMUSER_ID, TIMESTAMP, SOURCESYSTEM)
values
  ('SOIL_COUNTS', 'Y', 'Y', 1, to_date('01-01-2009', 'dd-mm-yyyy'), 0);
insert into DWH_SETTINGSPERTABLE
  (TABLENAME, ISFACTYN, LOADYN, SYSTEMUSER_ID, TIMESTAMP, SOURCESYSTEM)
values
  ('STOCK_TRANSACTIONS',
   'Y',
   'Y',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'),
   0);
insert into DWH_SETTINGSPERTABLE
  (TABLENAME, ISFACTYN, LOADYN, SYSTEMUSER_ID, TIMESTAMP, SOURCESYSTEM)
values
  ('CIRC_INV_SNAPSHOT',
   'Y',
   'Y',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'),
   0);
insert into DWH_SETTINGSPERTABLE
  (TABLENAME, ISFACTYN, LOADYN, SYSTEMUSER_ID, TIMESTAMP, SOURCESYSTEM)
values
  ('SETS_IN_CIRC_SNAPSHOT',
   'Y',
   'Y',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'),
   0);
insert into DWH_SETTINGSPERTABLE
  (TABLENAME, ISFACTYN, LOADYN, SYSTEMUSER_ID, TIMESTAMP, SOURCESYSTEM)
values
  ('REPAIR_TYPE', 'N', 'Y', 1, to_date('01-01-2009', 'dd-mm-yyyy'), 0);
insert into DWH_SETTINGSPERTABLE
  (TABLENAME, ISFACTYN, LOADYN, SYSTEMUSER_ID, TIMESTAMP, SOURCESYSTEM)
values
  ('REPAIRS', 'Y', 'Y', 1, to_date('01-01-2009', 'dd-mm-yyyy'), 0);
insert into DWH_SETTINGSPERTABLE
  (TABLENAME, ISFACTYN, LOADYN, SYSTEMUSER_ID, TIMESTAMP, SOURCESYSTEM)
values
  ('PRODUCTION_HOURS', 'Y', 'Y', 1, to_date('01-01-2009', 'dd-mm-yyyy'), 1);
insert into DWH_SETTINGSPERTABLE
  (TABLENAME, ISFACTYN, LOADYN, SYSTEMUSER_ID, TIMESTAMP, SOURCESYSTEM)
values
  ('ABSENCE_HOURS', 'Y', 'Y', 1, to_date('01-01-2009', 'dd-mm-yyyy'), 1);
insert into DWH_SETTINGSPERTABLE
  (TABLENAME, ISFACTYN, LOADYN, SYSTEMUSER_ID, TIMESTAMP, SOURCESYSTEM)
values
  ('WEARER_SNAPSHOT', 'Y', 'Y', 1, to_date('01-01-2009', 'dd-mm-yyyy'), 0);
insert into DWH_SETTINGSPERTABLE
  (TABLENAME, ISFACTYN, LOADYN, SYSTEMUSER_ID, TIMESTAMP, SOURCESYSTEM)
values
  ('WORKSTATION', 'N', 'Y', 1, to_date('01-01-2009', 'dd-mm-yyyy'), 0);
insert into DWH_SETTINGSPERTABLE
  (TABLENAME, ISFACTYN, LOADYN, SYSTEMUSER_ID, TIMESTAMP, SOURCESYSTEM)
values
  ('STATUS', 'N', 'Y', 1, to_date('01-01-2009', 'dd-mm-yyyy'), 0);

-- delete old rows
truncate table DWH_STRING_DESC;
delete from dwh_string;

-- add new rows
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (1, 'Yes', 10, 'General', null, 1, to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (2, 'No', 10, 'General', null, 1, to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (3,
   'Unknown',
   10,
   'General',
   null,
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (4,
   'Not Applicable',
   30,
   'General',
   null,
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (5, 'N/A', 6, 'General', null, 1, to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (6,
   'Not Defined',
   30,
   'General',
   null,
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (7,
   'Obsolete',
   15,
   'General',
   null,
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (8,
   'Active',
   15,
   'General',
   null,
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (9,
   'Inactive',
   15,
   'General',
   null,
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (10, 'All', 15, 'General', null, 1, to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (20,
   'W',
   15,
   'Calendar Time',
   'Week Code',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (21,
   'Week',
   15,
   'Calendar Time',
   'Week Name',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (22,
   'P',
   15,
   'Calendar Time',
   'Period Code',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (23,
   'Period',
   15,
   'Calendar Time',
   'Period Name',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (24,
   'Q',
   15,
   'Calendar Time',
   'Quarter Code',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (25,
   'Quarter',
   15,
   'Calendar Time',
   'Quarter Name',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (30,
   'COD',
   30,
   'Customer',
   'Payment Method',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (31,
   'Charge',
   30,
   'Customer',
   'Payment Method',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (32,
   'Cash',
   30,
   'Customer',
   'Payment Type',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (33,
   'Check',
   30,
   'Customer',
   'Payment Type',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (34,
   'Credit Card',
   30,
   'Customer',
   'Payment Type',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (35,
   'Electronic Fund Transfer',
   30,
   'Customer',
   'Payment Type',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (36,
   'EDI',
   30,
   'Customer',
   'Payment Type',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (37,
   'Accept Giro',
   30,
   'Customer',
   'Payment Type',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (38,
   'Automatic Collection',
   30,
   'Customer',
   'Payment Type',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (39,
   'Via pay-by Customer',
   30,
   'Customer',
   'Payment Type',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (40,
   'Rent Billing Method Unknown',
   30,
   'Charge Type',
   'Charge Description',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (41,
   'Flat Rated Rent',
   30,
   'Charge Type',
   'Charge Description',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (42,
   'Minimum Based Rent',
   30,
   'Charge Type',
   'Charge Description',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (43,
   'Inventory Based Rent',
   30,
   'Charge Type',
   'Charge Description',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (44,
   'Piece Rated Rent',
   30,
   'Charge Type',
   'Charge Description',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (45,
   'Lease',
   30,
   'Charge Type',
   'Charge Description',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (46,
   'Unrelated Loan',
   30,
   'Charge Type',
   'Charge Description',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (50,
   'From Plant',
   30,
   'Route',
   'Depot',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (51,
   'Not linked to Route',
   30,
   'Route',
   'Route Description',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (60,
   'Non Garments',
   30,
   'Product',
   'Type of Merchandize',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (61,
   'Garments',
   30,
   'Product',
   'Type of Merchandize',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (62,
   'Sales-only Items/Disposables',
   30,
   'Product',
   'Type of Merchandize',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (63,
   'Emblems',
   30,
   'Product',
   'Type of Merchandize',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (64,
   'Residential Garments',
   30,
   'Product',
   'Type of Merchandize',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (65,
   'Not Soil Counted',
   20,
   'Product',
   'Soil Count Method',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (66,
   'Manual',
   20,
   'Product',
   'Soil Count Method',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (67,
   'Auto Return Assumed',
   20,
   'Product',
   'Soil Count Method',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (68,
   'Weight Based',
   20,
   'Product',
   'Soil Count Method',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (69,
   'Delayed Even Exchange',
   40,
   'Product',
   'Exchange Method',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (70,
   'Straight Even Exchange',
   40,
   'Product',
   'Exchange Method',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (71,
   'Delivery based on order/standards',
   40,
   'Product',
   'Exchange Method',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (80,
   'New',
   10,
   'Quality Grade',
   'New Used',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (81,
   'Used',
   10,
   'Quality Grade',
   'New Used',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (85,
   'New / Increase',
   30,
   'Growth Reason',
   'Growth Reason Type',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (86,
   'Quit / Decrease',
   30,
   'Growth Reason',
   'Growth Reason Type',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (91,
   'New/Quit Customer',
   30,
   'Growth Reason',
   'Net Growth Reason',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (92,
   'New/Quit Customer Product',
   30,
   'Growth Reason',
   'Net Growth Reason',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (93,
   'Changed Customer Product',
   30,
   'Growth Reason',
   'Net Growth Reason',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (94,
   'New/Quit Wearers',
   30,
   'Growth Reason',
   'Net Growth Reason',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (95,
   'New/Quit Wearer Products',
   30,
   'Growth Reason',
   'Net Growth Reason',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (96,
   'Wearer Inventory Changes',
   30,
   'Growth Reason',
   'Net Growth Reason',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (97,
   'Price Changes',
   30,
   'Growth Reason',
   'Net Growth Reason',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
--section break for pack_Script
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (101,
   'New Customer',
   30,
   'Growth Reason',
   'Growth Reason',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (102,
   'Quit Customer',
   30,
   'Growth Reason',
   'Growth Reason',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (103,
   'New Customer Product',
   30,
   'Growth Reason',
   'Growth Reason',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (104,
   'Quit Customer Product',
   30,
   'Growth Reason',
   'Growth Reason',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (105,
   'Increased Customer Product',
   30,
   'Growth Reason',
   'Growth Reason',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (106,
   'Decreased Customer Product',
   30,
   'Growth Reason',
   'Growth Reason',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (107,
   'New Wearer',
   30,
   'Growth Reason',
   'Growth Reason',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (108,
   'Quit Wearer',
   30,
   'Growth Reason',
   'Growth Reason',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (109,
   'New Wearer Product',
   30,
   'Growth Reason',
   'Growth Reason',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (110,
   'Quit Wearer Product',
   30,
   'Growth Reason',
   'Growth Reason',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (111,
   'Increased Wearer Inventory',
   30,
   'Growth Reason',
   'Growth Reason',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (112,
   'Decreased Wearer Inventory',
   30,
   'Growth Reason',
   'Growth Reason',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (113,
   'Price Increase',
   30,
   'Growth Reason',
   'Growth Reason',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (114,
   'Price Decrease',
   30,
   'Growth Reason',
   'Growth Reason',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (120,
   'Fscl W',
   15,
   'Fiscal Time',
   'Week Code',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (121,
   'Fiscal Week',
   15,
   'Fiscal Time',
   'Week Name',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (122,
   'Fscl P',
   15,
   'Fiscal Time',
   'Period Code',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (123,
   'Fiscal Period',
   15,
   'Fiscal Time',
   'Period Name',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (124,
   'Fscl Q',
   15,
   'Fiscal Time',
   'Quarter Code',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (125,
   'Fiscal Quarter',
   15,
   'Fiscal Time',
   'Quarter Name',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (200,
   'Delivery Standards',
   30,
   'Customer',
   'Standard Quantity Definition',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (201,
   'Usage Standards',
   30,
   'Customer',
   'Standard Quantity Definition',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (202,
   'This Customer',
   30,
   'Customer',
   'Containers Owned By',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (203,
   'Bill-to Customer',
   30,
   'Customer',
   'Containers Owned By',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (204,
   'Master Account',
   30,
   'Customer',
   'Containers Owned By',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (205,
   'Laundry',
   30,
   'Customer',
   'Containers Owned By',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (206,
   'Customer',
   30,
   'Customer',
   'Consignment Note Level',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (207,
   'Department',
   30,
   'Customer',
   'Consignment Note Level',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (208,
   'Delivery Point',
   30,
   'Customer',
   'Consignment Note Level',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (210,
   'No Sorting Info',
   30,
   'Customer',
   'Outscan Sort By',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (211,
   'Department',
   30,
   'Customer',
   'Outscan Sort By',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (212,
   'Bank / Locker',
   30,
   'Customer',
   'Outscan Sort By',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (213,
   'Garment Dispenser',
   30,
   'Customer',
   'Outscan Sort By',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (214,
   'Delivery Point',
   30,
   'Customer',
   'Outscan Sort By',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (215,
   'Service Team',
   30,
   'Customer',
   'Outscan Sort By',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (216,
   'Finishing Method',
   30,
   'Customer',
   'Outscan Sort By',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (217,
   'Size',
   30,
   'Customer',
   'Outscan Sort By',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (218,
   'Bank / Locker + Sticker',
   30,
   'Customer',
   'Outscan Sort By',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (219,
   'Sort Address',
   30,
   'Customer',
   'Outscan Sort By',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (230,
   'General Price List',
   30,
   'Customer',
   'Insurance Price Type',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (231,
   'Customer Specific Price',
   30,
   'Customer',
   'Insurance Price Type',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (235,
   'Charge Fixed # of Banks ',
   30,
   'Customer',
   'Locker Rent Type',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (236,
   'Charge per Occupied Locker',
   30,
   'Customer',
   'Locker Rent Type',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (237,
   'Charge # of Bank/Lockers ',
   30,
   'Customer',
   'Locker Service Charge Type',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (238,
   'Charge # of Pieces per Bank/Locker',
   30,
   'Customer',
   'Locker Service Charge Type',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (240,
   'Regular Mail',
   30,
   'Customer',
   'Send Invoice By',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (241,
   'E-mail',
   30,
   'Customer',
   'Send Invoice By',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (242,
   'Fax',
   30,
   'Customer',
   'Send Invoice By',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (243,
   'EDI',
   30,
   'Customer',
   'Send Invoice By',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (251,
   'Products by Wearer',
   30,
   'Customer',
   'Garment Rent Specification',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (252,
   'Products by Wearer Condensed',
   30,
   'Customer',
   'Garment Rent Specification',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (253,
   'Wearer Totals Only',
   30,
   'Customer',
   'Garment Rent Specification',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (254,
   'By Product',
   30,
   'Customer',
   'Garment Rent Specification',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (255,
   'Number of Men per Total Price',
   30,
   'Customer',
   'Garment Rent Specification',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (256,
   'Summary Person Billing with Total Code',
   30,
   'Customer',
   'Garment Rent Specification',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (260,
   'In Arrear',
   30,
   'Customer',
   'Rent Period',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (261,
   'In Advance (Correct Additions Only)',
   30,
   'Customer',
   'Rent Period',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (262,
   'In Advance',
   30,
   'Customer',
   'Rent Period',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (265,
   'No Split',
   30,
   'Customer',
   'Split Invoice',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (266,
   'Per product grouping code',
   30,
   'Customer',
   'Split Invoice',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (267,
   'Per Cost Center',
   30,
   'Customer',
   'Split Invoice',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (268,
   'Rent / Other services',
   30,
   'Customer',
   'Split Invoice',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (270,
   'Invoice',
   30,
   'Customer',
   'Finance Charge Put On',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (271,
   'Statement',
   30,
   'Customer',
   'Finance Charge Put On',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (275,
   'Other',
   30,
   'Customer',
   'Credit Card Type',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (281,
   'Always',
   30,
   'Customer',
   'Send Statement',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (282,
   'Only When Past Due',
   30,
   'Customer',
   'Send Statement',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (283,
   'Never',
   30,
   'Customer',
   'Send Statement',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (285,
   'Yes, Bulk Inscan Allowed',
   30,
   'Customer',
   'Residential Inscan',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (286,
   'Yes, but Not in Bulk',
   30,
   'Customer',
   'Residential Inscan',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
--section break for pack_Script
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (290,
   'Sequence# Delivery Note',
   30,
   'Customer',
   'Sort Order Residential Washes',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (291,
   'Client Number',
   30,
   'Customer',
   'Sort Order Residential Washes',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (292,
   'Client Search Name',
   30,
   'Customer',
   'Sort Order Residential Washes',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (293,
   'Department / Room#',
   30,
   'Customer',
   'Sort Order Residential Washes',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (301,
   'Next Visit',
   30,
   'Customer',
   'Return Residential Items',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (302,
   'Same Route Next Week',
   30,
   'Customer',
   'Return Residential Items',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (303,
   'Return Route',
   30,
   'Customer',
   'Return Residential Items',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (310,
   'no sorting info',
   30,
   'Customer',
   'Residential Outscan Sort by',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (311,
   'Departement#',
   30,
   'Customer',
   'Residential Outscan Sort by',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (312,
   'Room#',
   30,
   'Customer',
   'Residential Outscan Sort by',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (313,
   'Box#',
   30,
   'Customer',
   'Residential Outscan Sort by',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (314,
   'Delivery Point',
   30,
   'Customer',
   'Residential Outscan Sort by',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (315,
   'Service Team',
   30,
   'Customer',
   'Residential Outscan Sort by',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (316,
   'Client#',
   30,
   'Customer',
   'Residential Outscan Sort by',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (317,
   'Box# + Department#',
   30,
   'Customer',
   'Residential Outscan Sort by',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (322,
   'Automatic',
   30,
   'Customer',
   'Anniversary Price Adjustment',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (323,
   'Signal Only',
   30,
   'Customer',
   'Anniversary Price Adjustment',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (331,
   'Fixed (Dictated)',
   30,
   'Customer',
   'Master Account Relation',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (332,
   'Free',
   30,
   'Customer',
   'Master Account Relation',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (350,
   'High',
   10,
   'Contacts',
   'Priority',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (351,
   'Medium',
   10,
   'Contacts',
   'Priority',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (352,
   'Low',
   10,
   'Contacts',
   'Priority',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (360,
   'Charge',
   20,
   'Repairs',
   'Status',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (361,
   'Free of Charge',
   20,
   'Repairs',
   'Status',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (362,
   'Charge Cancelled',
   20,
   'Repairs',
   'Status',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (363,
   'No Repair Charge',
   20,
   'Repairs',
   'Status',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (364,
   'Reason Not Charged',
   20,
   'Garment Issue',
   'Status',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (365,
   'In Free Period',
   20,
   'Garment Issue',
   'Status',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (366,
   'No Charge Defined',
   20,
   'Garment Issue',
   'Status',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (401,
   'Flat Rated Rent',
   30,
   'Charge Type',
   'Billing Method',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (402,
   'Rent Based on Minimum',
   30,
   'Charge Type',
   'Billing Method',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (403,
   'Inventory Based',
   30,
   'Charge Type',
   'Billing Method',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (404,
   'Piece Rate Only ',
   30,
   'Charge Type',
   'Billing Method',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (405,
   'Lease',
   30,
   'Charge Type',
   'Billing Method',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (409,
   'Unrelated Loan',
   30,
   'Charge Type',
   'Billing Method',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (411,
   'Not Started',
   30,
   'Route History',
   'Status Columns',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (412,
   'In Progress',
   30,
   'Route History',
   'Status Columns',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (413,
   'Completed',
   30,
   'Route History',
   'Status Columns',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (414,
   'Processed',
   30,
   'Route History',
   'Status Columns',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (421,
   'No Put Up Printed',
   30,
   'Route History',
   'Packing Status',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (422,
   'Put Up Printed',
   30,
   'Route History',
   'Packing Status',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (430,
   'Not Exported',
   30,
   'Route History',
   'Status Columns',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (431,
   'Exported',
   30,
   'Route History',
   'Status Columns',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (432,
   'Imported',
   30,
   'Route History',
   'Status Columns',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (440,
   'Not Ready for Transfer',
   30,
   'Route History',
   'Sorting Status & PDA Status',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (441,
   'Ready for Transfer',
   30,
   'Route History',
   'Sorting Status & PDA Status',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (442,
   'Transferred',
   30,
   'Route History',
   'Sorting Status & PDA Status',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (450,
   'Packing Note generated based on Orders',
   40,
   'Delivery Note',
   'Origin',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (451,
   'Manually Added',
   40,
   'Delivery Note',
   'Origin',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (452,
   'Batch Delivery Note',
   40,
   'Delivery Note',
   'Origin',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (453,
   'Correction Ticket',
   40,
   'Delivery Note',
   'Origin',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (454,
   'Stock Delivery Note',
   40,
   'Delivery Note',
   'Origin',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (455,
   'Special Order',
   40,
   'Delivery Note',
   'Origin',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (456,
   'Bulk Note',
   40,
   'Delivery Note',
   'Origin',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (457,
   'Bin Note',
   40,
   'Delivery Note',
   'Origin',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (458,
   'Transfer Weights',
   40,
   'Delivery Note',
   'Origin',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (459,
   'Imported from external datawarehouse',
   40,
   'Delivery Note',
   'Origin',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (460,
   'Mounting Order',
   40,
   'Delivery Note',
   'Origin',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (461,
   'Generated',
   30,
   'Invoice',
   'Invoice Type',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (462,
   'Manual',
   30,
   'Invoice',
   'Invoice Type',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (463,
   'Credit',
   30,
   'Invoice',
   'Invoice Type',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (464,
   'Additional Generated',
   30,
   'Invoice',
   'Invoice Type',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (465,
   'Lost Customer Invoice',
   30,
   'Invoice',
   'Invoice Type',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (466,
   'Corrections Invoice',
   30,
   'Invoice',
   'Invoice Type',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (470,
   'Pieces',
   10,
   'Work Spot',
   'Pieces Weight',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (471,
   'Weight',
   10,
   'Work Spot',
   'Pieces Weight',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (480,
   'Permanent',
   20,
   'Employee',
   'Contract Type',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (481,
   'Temporary',
   20,
   'Employee',
   'Contract Type',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (482,
   'External',
   20,
   'Employee',
   'Contract Type',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (485,
   'Male',
   10,
   'Employee',
   'Gender',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (486,
   'Female',
   10,
   'Employee',
   'Gender',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (490,
   'Debit',
   20,
   'AR Transaction Type',
   'Debit Credit',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));
insert into DWH_STRING
  (DWH_STRING_ID,
   FACTORYDESCRIPTION,
   MAXSTRINGLENGTH,
   DIMENSION_TABLE,
   DIMENSION_COLUMN,
   SYSTEMUSER_ID,
   TIMESTAMP)
values
  (491,
   'Credit',
   20,
   'AR Transaction Type',
   'Debit Credit',
   1,
   to_date('01-01-2009', 'dd-mm-yyyy'));

insert into dwh_string_desc
  (dwh_string_id, languagecode, string, systemuser_id, timestamp)
  select i.dwh_string_id, 'EN_US', i.factorydescription, 1, sysdate
    from dwh_string i
   where i.dwh_string_id not in
         (select dwh_string_id
            from dwh_string_desc dd
           where dd.dwh_string_id = i.dwh_string_id
             and dd.languagecode = 'EN_US');


