/** MWADD
EXECUTE PROCEDURE sp_CreateIndex90( 'MWADD',   'MWADD.adi',   'IDXTYPE',   'Type',   '',   2,   512,   '' ); 

EXECUTE PROCEDURE sp_CreateIndex90(    'MWADD',   'MWADD.adi',   'PRIMARY',   'UPPER(Code)',   '',   2051,   512,   '' ); 

EXECUTE PROCEDURE sp_CreateIndex90(    'MWADD',   'MWADD.adi',   'IDXNAME',   'UPPER(Name)',   '',   2,   512,   '' ); 


/** MWCAS
EXECUTE PROCEDURE sp_CreateIndex90(   'MWCAS',   'MWCAS.adi',   'IDXINSCARRIER3',   'UPPER(Insurance Carrier #3)',   '',   2,   512,   '' ); 
EXECUTE PROCEDURE sp_CreateIndex90(    'MWCAS',   'MWCAS.adi',   'PRIMARY',   'UPPER(Chart Number);Case Number',   '',   2051,   512,   '' ); 
EXECUTE PROCEDURE sp_CreateIndex90(    'MWCAS',   'MWCAS.adi',   'IDXINSCARRIER2',   'UPPER(Insurance Carrier #2)',   '',   2,   512,   '' ); 
EXECUTE PROCEDURE sp_CreateIndex90(    'MWCAS',   'MWCAS.adi',   'IDXINSCARRIER1',   'UPPER(Insurance Carrier #1)',   '',   2,   512,   '' ); 
EXECUTE PROCEDURE sp_CreateIndex90(    'MWCAS',   'MWCAS.adi',   'IDXGUARANTOR',   'UPPER(Guarantor)',   '',   2,   512,   '' ); 
EXECUTE PROCEDURE sp_CreateIndex90(    'MWCAS',   'MWCAS.adi',   'IDXCHARTDESCRIPTION',   'UPPER(Chart Number);UPPER(Description)',   '',   2,   512,   '' ); 
EXECUTE PROCEDURE sp_CreateIndex90(    'MWCAS',   'MWCAS.adi',   'IDXFACILITY',   'UPPER(Facility);UPPER(Chart Number)',   '',   2,   512,   '' ); 
EXECUTE PROCEDURE sp_CreateIndex90(    'MWCAS',   'MWCAS.adi',   'IDXREFSOURCE',   'UPPER(Referral Source);UPPER(Chart Number)',   '',   2,   512,   '' ); 
EXECUTE PROCEDURE sp_CreateIndex90(    'MWCAS',   'MWCAS.adi',   'IDXREFPROVIDER',   'UPPER(Referring Provider);UPPER(Chart Number)',   '',   2,   512,   '' ); 
EXECUTE PROCEDURE sp_CreateIndex90(    'MWCAS',   'MWCAS.adi',   'IDXCASENUMBER',   'Case Number',   '',   2,   512,   '' ); 
EXECUTE PROCEDURE sp_CreateIndex90(    'MWCAS',   'MWCAS.adi',   'IDXCHARTNUMBER',   'Chart Number',   '',   2,   512,   '' ); 
EXECUTE PROCEDURE sp_CreateIndex90(    'MWCAS',   'MWCAS.adi',   'IDXCASENUMBERDESC',   'UPPER(Chart Number);Case Number',   '',   10,   512,   '' ); 

/* MWTRN

EXECUTE PROCEDURE sp_CreateIndex90( 'MWTRN', 'MWTRN.adi', 'IDXENTRY NUMBER', 'CC Entry Number', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWTRN', 'MWTRN.adi', 'IDXPROVIDER', 'UPPER(Attending Provider)', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWTRN', 'MWTRN.adi', 'IDXCASENUMBER', 'Case Number', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWTRN', 'MWTRN.adi', 'IDXDATECREATED', 'Date Created', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWTRN', 'MWTRN.adi', 'IDXSTATEMENT', 'Statement Number;Date From;Entry Number', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWTRN', 'MWTRN.adi', 'IDXDEPOSITID', 'Deposit ID', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWTRN', 'MWTRN.adi', 'IDXCHARTCASEDOC', 'Chart Number;Case Number;Document Number;Entry Number;Tooth Number', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWTRN', 'MWTRN.adi', 'IDXENTRYNUMBER', 'Entry Number', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWTRN', 'MWTRN.adi', 'PRIMARY', 'Chart Number;Case Number;Entry Number;Tooth Number', '', 2051, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWTRN', 'MWTRN.adi', 'IDXDOCUMENT', 'UPPER(Chart Number);Document Number;UPPER(Transaction Type)', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWTRN', 'MWTRN.adi', 'IDXDATECHARTTYPE', 'Date From;UPPER(Chart Number);UPPER(Transaction Type)', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWTRN', 'MWTRN.adi', 'IDXCHARTNUMBER', 'Chart Number', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWTRN', 'MWTRN.adi', 'IDXCHECKNUMBER', 'Check Number', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWTRN', 'MWTRN.adi', 'IDXTYPE', 'Transaction Type', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWTRN', 'MWTRN.adi', 'IDXPROMODIFIERS', 'Procedure Code;Modifier 1;Modifier 2;Modifier 3;Modifier 4', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWTRN', 'MWTRN.adi', 'IDXCHARTDATE', 'UPPER(Chart Number);Date From', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWTRN', 'MWTRN.adi', 'IDXCLAIMREJECTION', 'Claim Rejection Code', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWTRN', 'MWTRN.adi', 'IDXCLAIM', 'Claim Number;Date From;Entry Number', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWTRN', 'MWTRN.adi', 'IDXSTATEMENTID', 'Statement Number', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWTRN', 'MWTRN.adi', 'IDXDATEMODIFIED', 'Date Modified', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWTRN', 'MWTRN.adi', 'IDXPROCEDURE', 'UPPER(Procedure Code);UPPER(Insurance Category)', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWTRN', 'MWTRN.adi', 'IDXCLAIMREVENUECODE', 'Claim Number;UPPER(Revenue_Code)', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWTRN', 'MWTRN.adi', 'IDXCLAIMDATEREVENUECODE', 'Claim Number;Date From;UPPER(Revenue_Code)', '', 2, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWTRN', 'MWTRN.adi', 'IDXCHARTCASESERVDT', 'Chart Number;Case Number;Date From;Entry Number', '', 2051, 512, NULL );
EXECUTE PROCEDURE sp_CreateIndex90( 'MWTRN', 'MWTRN.adi', 'IDXUBGROUP', 'Claim Number;Revenue_Code;Procedure Code;Modifier 1;Modifier 2;Modifier 3;Modifier 4;Date From', '', 2, 512, NULL );