-- --------------------------------------------------------

-- 
-- Table structure for table `ACCOUNTS`
-- 

CREATE TABLE `ACCOUNTS` (
  `COLLECTOR_ID` int(3) NOT NULL,
  `ACCT_ID` varchar(8) NOT NULL,
  `ACCT_NAME` varchar(23) NOT NULL,
  `ACCT_PHONE` text NOT NULL,
  `ACCT_FAX` text NOT NULL,
  `ACCT_EMAIL` text NOT NULL,
  `ACCT_BADPHONE` int(1) NOT NULL,
  `ACCT_LVM` int(1) NOT NULL,
  `ACCT_ACTIONSTEP` int(1) NOT NULL,
  `ACCT_PAYPROM` int(1) NOT NULL,
  `ACCT_DISPUTED` int(1) NOT NULL,
  `ACCT_COMMENT` text NOT NULL,
  `ACCT_COLL_COMMENT` text NOT NULL,
  `ACCT_SENDVIA` int(1) NOT NULL,
  `ACCT_ATTN` varchar(12) NOT NULL,
  `ACCT_COMMENT_DATE` int(8) NOT NULL,
  `ACCT_AUTO_DATE` int(8) NOT NULL,
  `ACCT_LAST_WORKED` int(6) NOT NULL,
  `ACCT_DUPLICATE` int(1) NOT NULL,
  PRIMARY KEY  (`COLLECTOR_ID`,`ACCT_ID`),
  KEY `COLLECTOR_ID` (`COLLECTOR_ID`),
  KEY `ACCT_DUPLICATE` (`ACCT_DUPLICATE`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

-- 
-- Table structure for table `INVOICES`
-- 

CREATE TABLE `INVOICES` (
  `COLLECTOR_ID` int(3) NOT NULL,
  `ACCT_ID` varchar(8) NOT NULL,
  `INV_ID` varchar(10) NOT NULL,
  `INV_PO_NO` varchar(10) NOT NULL,
  `INV_DUE_DATE` int(10) NOT NULL,
  `INV_TRANS_DATE` int(10) NOT NULL,
  `INV_TRANS_TYPE` varchar(7) NOT NULL,
  `INV_AMT_OUT` double(9,2) NOT NULL,
  `INV_CURR_FUT_DUE` double(9,2) NOT NULL,
  `INV_1_30` double(9,2) NOT NULL,
  `INV_31_60` double(9,2) NOT NULL,
  `INV_61_90` double(9,2) NOT NULL,
  `INV_91` double(9,2) NOT NULL,
  `INV_TOT_PAST` double(9,2) NOT NULL,
  `INV_TOT_BAL` double(9,2) NOT NULL,
  `INV_SEND` int(1) NOT NULL,
  PRIMARY KEY  (`COLLECTOR_ID`,`ACCT_ID`,`INV_ID`),
  KEY `COLLECTOR_ID` (`COLLECTOR_ID`,`ACCT_ID`),
  KEY `INV_31_60` (`INV_31_60`),
  KEY `INV_61_90` (`INV_61_90`),
  KEY `INV_91` (`INV_91`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO `ACCOUNTS` VALUES (1, 'MM000001', 'BOB THE BUILDER        ', '999 999-9999', '', '', 0, 0, 0, 0, 0, '', '', 0, '', 0, 20060726, 0, 0);
INSERT INTO `ACCOUNTS` VALUES (1, 'MM000002', 'JOHN DEER              ', '999 999-9999', '', '', 0, 0, 0, 0, 0, '', '', 0, '', 0, 20060726, 0, 0);

INSERT INTO `INVOICES` VALUES (1, 'MM000001', '32280F45  ', 'MEGASALE  ', 20060703, 20060403, '', 1028.06, 0.00, 1028.06, 0.00, 0.00, 0.00, 1028.06, 1028.06, 0);
INSERT INTO `INVOICES` VALUES (1, 'MM000001', '32280F46  ', 'MEGASALE  ', 20060703, 20060403, '', 1028.06, 0.00, 1028.06, 0.00, 0.00, 0.00, 1028.06, 1028.06, 0);
INSERT INTO `INVOICES` VALUES (1, 'MM000001', '32280F47  ', 'MEGASALE  ', 20060703, 20060403, '', 1028.06, 0.00, 1028.06, 0.00, 0.00, 0.00, 1028.06, 1028.06, 0);
INSERT INTO `INVOICES` VALUES (1, 'MM000001', '32280F48  ', 'MEGASALE  ', 20060703, 20060403, '', 1028.06, 0.00, 1028.06, 0.00, 0.00, 0.00, 1028.06, 1028.06, 0);
INSERT INTO `INVOICES` VALUES (1, 'MM000001', '32280F49  ', 'MEGASALE  ', 20060703, 20060403, '', 1028.06, 0.00, 1028.06, 0.00, 0.00, 0.00, 1028.06, 1028.06, 0);

INSERT INTO `INVOICES` VALUES (1, 'MM000002', '32280F55  ', 'MEGASALE  ', 20060703, 20060403, '', 1028.06, 0.00, 1028.06, 0.00, 0.00, 0.00, 1028.06, 1028.06, 0);
INSERT INTO `INVOICES` VALUES (1, 'MM000002', '32280F56  ', 'MEGASALE  ', 20060703, 20060403, '', 1028.06, 0.00, 1028.06, 0.00, 0.00, 0.00, 1028.06, 1028.06, 0);
INSERT INTO `INVOICES` VALUES (1, 'MM000002', '32280F57  ', 'MEGASALE  ', 20060703, 20060403, '', 1028.06, 0.00, 1028.06, 0.00, 0.00, 0.00, 1028.06, 1028.06, 0);
INSERT INTO `INVOICES` VALUES (1, 'MM000002', '32280F58  ', 'MEGASALE  ', 20060703, 20060403, '', 1028.06, 0.00, 1028.06, 0.00, 0.00, 0.00, 1028.06, 1028.06, 0);
INSERT INTO `INVOICES` VALUES (1, 'MM000002', '32280F59  ', 'MEGASALE  ', 20060703, 20060403, '', 1028.06, 0.00, 1028.06, 0.00, 0.00, 0.00, 1028.06, 1028.06, 0);