-- Table Type of MWTRN is ADT

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 );