Create Unique Index [PRIMARY] on MWTRN( [CHART NUMBER],[CASE NUMBER],[ENTRY NUMBER],[TOOTH NUMBER] );
Create Index IDXPROCEDURE on MWTRN( [PROCEDURE CODE], [INSURANCE CATEGORY] );
Create Index IDXCLAIM on MWTRN( [CLAIM NUMBER],[DATE FROM],[ENTRY NUMBER] );
Create Index IDXDATECHARTTYPE on MWTRN( [DATE FROM], [CHART NUMBER], [TRANSACTION TYPE] );
Create Index IDXCHARTDATE on MWTRN( [CHART NUMBER], [DATE FROM] );
Create Index IDXENTRYNUMBER on MWTRN( [ENTRY NUMBER] );
Create Index IDXDATECREATED on MWTRN( [DATE CREATED] );
Create Index IDXPROVIDER on MWTRN( [ATTENDING PROVIDER] );
Create Index IDXDOCUMENT on MWTRN( [CHART NUMBER], [DOCUMENT NUMBER], [TRANSACTION TYPE] );
Create Index IDXTYPE on MWTRN( [TRANSACTION TYPE] );
Create Index [IDXENTRY NUMBER] on MWTRN( [CC ENTRY NUMBER] );
Create Index IDXCHARTCASEDOC on MWTRN( [CHART NUMBER],[CASE NUMBER],[DOCUMENT NUMBER],[ENTRY NUMBER],[TOOTH NUMBER] );
Create Index IDXCASENUMBER on MWTRN( [CASE NUMBER] );
Create Index IDXCHARTNUMBER on MWTRN( [CHART NUMBER] );
Create Index IDXDATEMODIFIED on MWTRN( [DATE MODIFIED] );
Create Index IDXDEPOSITID on MWTRN( [DEPOSIT ID] );
Create Index IDXCHECKNUMBER on MWTRN( [CHECK NUMBER] );
Create Index IDXSTATEMENT on MWTRN( [STATEMENT NUMBER],[DATE FROM],[ENTRY NUMBER] );
Create Index IDXSTATEMENTID on MWTRN( [STATEMENT NUMBER] );
Create Index IDXPROMODIFIERS on MWTRN( [PROCEDURE CODE],[MODIFIER 1],[MODIFIER 2],[MODIFIER 3],[MODIFIER 4] );
Create Index IDXCLAIMREJECTION on MWTRN( [CLAIM REJECTION CODE] );