INSERT INTO A1 ( REV_TYPE_ID, REV_TYPE, ROLLUP1, ROLLUP2, REV_ACCOUNT_ID, CREATE_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, ATTRIBUTE5 ) VALUES ( 1, 'Current Royalties', 'Per Unit Royalties', 'Recurring Royalties', 1000170, TO_Date( '06/02/2008 01:17:37 PM', 'MM/DD/YYYY HH:MI:SS AM') , 'SYSTEM', TO_Date( '06/02/2008 01:17:37 PM', 'MM/DD/YYYY HH:MI:SS AM'), 'SYSTEM' , '41300 - SALES - ROYALTIES'); INSERT INTO A1 ( REV_TYPE_ID, REV_TYPE, ROLLUP1, ROLLUP2, REV_ACCOUNT_ID, CREATE_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, ATTRIBUTE5 ) VALUES ( 2, 'Paid Up/Fixed Fee', 'Fixed Fee Royalties', 'Recurring Royalties', 1000170, TO_Date( '06/02/2008 01:17:37 PM', 'MM/DD/YYYY HH:MI:SS AM') , 'SYSTEM', TO_Date( '06/02/2008 01:17:37 PM', 'MM/DD/YYYY HH:MI:SS AM'), 'SYSTEM' , '41300 - SALES - ROYALTIES'); INSERT INTO A1 ( REV_TYPE_ID, REV_TYPE, ROLLUP1, ROLLUP2, REV_ACCOUNT_ID, CREATE_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, ATTRIBUTE5 ) VALUES ( 3, 'Prepayment Exhaustion', 'Per Unit Royalties', 'Recurring Royalties', 1000170, TO_Date( '06/02/2008 01:17:37 PM', 'MM/DD/YYYY HH:MI:SS AM') , 'SYSTEM', TO_Date( '06/02/2008 01:17:37 PM', 'MM/DD/YYYY HH:MI:SS AM'), 'SYSTEM' , '41300 - SALES - ROYALTIES'); INSERT INTO A1 ( REV_TYPE_ID, REV_TYPE, ROLLUP1, ROLLUP2, REV_ACCOUNT_ID, CREATE_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, ATTRIBUTE5 ) VALUES ( 4, 'Alliance/Strategic Partners', 'Tech Solutions', 'Tech Solutions', 1000167, TO_Date( '06/02/2008 01:17:37 PM', 'MM/DD/YYYY HH:MI:SS AM') , 'SYSTEM', TO_Date( '06/02/2008 01:17:37 PM', 'MM/DD/YYYY HH:MI:SS AM'), 'SYSTEM' , '41100 - SALES - ENGINEERING SERVICES - LABOR'); INSERT INTO A1 ( REV_TYPE_ID, REV_TYPE, ROLLUP1, ROLLUP2, REV_ACCOUNT_ID, CREATE_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, ATTRIBUTE5 ) VALUES ( 5, 'Past Infringement/Non-Recurring Royalties', 'Non-Recurring Royalties', 'Non-Recurring Royalties' , 1000170, TO_Date( '06/02/2008 01:17:37 PM', 'MM/DD/YYYY HH:MI:SS AM'), 'SYSTEM' , TO_Date( '06/02/2008 01:17:37 PM', 'MM/DD/YYYY HH:MI:SS AM'), 'SYSTEM', '41300 - SALES - ROYALTIES'); INSERT INTO A1 ( REV_TYPE_ID, REV_TYPE, ROLLUP1, ROLLUP2, REV_ACCOUNT_ID, CREATE_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, ATTRIBUTE5 ) VALUES ( 6, 'Gov Contracting', 'Tech Solutions', 'Tech Solutions', 1000167, TO_Date( '06/02/2008 01:17:37 PM', 'MM/DD/YYYY HH:MI:SS AM') , 'SYSTEM', TO_Date( '06/02/2008 01:17:37 PM', 'MM/DD/YYYY HH:MI:SS AM'), 'SYSTEM' , '41100 - SALES - ENGINEERING SERVICES - LABOR'); INSERT INTO A1 ( REV_TYPE_ID, REV_TYPE, ROLLUP1, ROLLUP2, REV_ACCOUNT_ID, CREATE_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, ATTRIBUTE5 ) VALUES ( 7, 'Up Front Payments', 'Fixed Fee Royalties', 'Recurring Royalties', 1000170, TO_Date( '06/02/2008 01:17:37 PM', 'MM/DD/YYYY HH:MI:SS AM') , 'SYSTEM', TO_Date( '06/02/2008 01:17:37 PM', 'MM/DD/YYYY HH:MI:SS AM'), 'SYSTEM' , '41300 - SALES - ROYALTIES'); INSERT INTO A1 ( REV_TYPE_ID, REV_TYPE, ROLLUP1, ROLLUP2, REV_ACCOUNT_ID, CREATE_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, ATTRIBUTE5 ) VALUES ( 8, 'Product Sales', 'Tech Solutions', 'Tech Solutions', 1000167, TO_Date( '06/02/2008 01:17:37 PM', 'MM/DD/YYYY HH:MI:SS AM') , 'SYSTEM', TO_Date( '06/02/2008 01:17:37 PM', 'MM/DD/YYYY HH:MI:SS AM'), 'SYSTEM' , '41100 - SALES - ENGINEERING SERVICES - LABOR'); INSERT INTO A1 ( REV_TYPE_ID, REV_TYPE, ROLLUP1, ROLLUP2, REV_ACCOUNT_ID, CREATE_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, ATTRIBUTE5 ) VALUES ( 9, 'Product Royalties', 'Tech Solutions', 'Tech Solutions', 1000167, TO_Date( '06/02/2008 01:17:37 PM', 'MM/DD/YYYY HH:MI:SS AM') , 'SYSTEM', TO_Date( '06/02/2008 01:17:37 PM', 'MM/DD/YYYY HH:MI:SS AM'), 'SYSTEM' , '41100 - SALES - ENGINEERING SERVICES - LABOR'); INSERT INTO A1 ( REV_TYPE_ID, REV_TYPE, ROLLUP1, ROLLUP2, REV_ACCOUNT_ID, CREATE_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, ATTRIBUTE5 ) VALUES ( 10, 'Knowledge Transfer/Know How', 'Tech Solutions', 'Tech Solutions', 1000167, TO_Date( '06/02/2008 01:17:37 PM', 'MM/DD/YYYY HH:MI:SS AM') , 'SYSTEM', TO_Date( '06/02/2008 01:17:37 PM', 'MM/DD/YYYY HH:MI:SS AM'), 'SYSTEM' , '41100 - SALES - ENGINEERING SERVICES - LABOR'); commit; -------------------------------------------------------------------------------------------------------------------- INSERT INTO B1( REV_ACCOUNT_ID, REV_ACCOUNT_NUMBER, REV_ACCOUNT_NAME, CREATED_BY, CREATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE ) VALUES ( 31003, '11302', 'A/R - ACCRUED', 'SYSTEM', TO_Date( '06/02/2008 01:30:48 PM', 'MM/DD/YYYY HH:MI:SS AM') , 'SYSTEM', TO_Date( '06/02/2008 01:30:48 PM', 'MM/DD/YYYY HH:MI:SS AM')); INSERT INTO B1( REV_ACCOUNT_ID, REV_ACCOUNT_NUMBER, REV_ACCOUNT_NAME, CREATED_BY, CREATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE ) VALUES ( 1000101, '11501', 'PREPAID INCOME TAXES', 'SYSTEM', TO_Date( '06/02/2008 01:30:48 PM', 'MM/DD/YYYY HH:MI:SS AM') , 'SYSTEM', TO_Date( '06/02/2008 01:30:48 PM', 'MM/DD/YYYY HH:MI:SS AM')); INSERT INTO B1( REV_ACCOUNT_ID, REV_ACCOUNT_NUMBER, REV_ACCOUNT_NAME, CREATED_BY, CREATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE ) VALUES ( 1002607, '11617', 'DTA - FWT CREDIT', 'SYSTEM', TO_Date( '06/02/2008 01:30:48 PM', 'MM/DD/YYYY HH:MI:SS AM') , 'SYSTEM', TO_Date( '06/02/2008 01:30:48 PM', 'MM/DD/YYYY HH:MI:SS AM')); INSERT INTO B1( REV_ACCOUNT_ID, REV_ACCOUNT_NUMBER, REV_ACCOUNT_NAME, CREATED_BY, CREATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE ) VALUES ( 1000851, '25007', 'FEDERAL INCOME TAX PAYABLE', 'SYSTEM', TO_Date( '06/02/2008 01:30:48 PM', 'MM/DD/YYYY HH:MI:SS AM') , 'SYSTEM', TO_Date( '06/02/2008 01:30:48 PM', 'MM/DD/YYYY HH:MI:SS AM')); INSERT INTO B1( REV_ACCOUNT_ID, REV_ACCOUNT_NUMBER, REV_ACCOUNT_NAME, CREATED_BY, CREATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE ) VALUES ( 1000150, '28002', 'DEFERRED REVENUE - LONG TERM', 'SYSTEM', TO_Date( '06/02/2008 01:30:48 PM', 'MM/DD/YYYY HH:MI:SS AM') , 'SYSTEM', TO_Date( '06/02/2008 01:30:48 PM', 'MM/DD/YYYY HH:MI:SS AM')); INSERT INTO B1( REV_ACCOUNT_ID, REV_ACCOUNT_NUMBER, REV_ACCOUNT_NAME, CREATED_BY, CREATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE ) VALUES ( 1000167, '41100', 'SALES - ENGINEERING SERVICES - LABOR', 'SYSTEM', TO_Date( '06/02/2008 01:30:48 PM', 'MM/DD/YYYY HH:MI:SS AM') , 'SYSTEM', TO_Date( '06/02/2008 01:30:48 PM', 'MM/DD/YYYY HH:MI:SS AM')); INSERT INTO B1( REV_ACCOUNT_ID, REV_ACCOUNT_NUMBER, REV_ACCOUNT_NAME, CREATED_BY, CREATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE ) VALUES ( 1000170, '41300', 'SALES - ROYALTIES', 'SYSTEM', TO_Date( '06/02/2008 01:30:48 PM', 'MM/DD/YYYY HH:MI:SS AM') , 'SYSTEM', TO_Date( '06/02/2008 01:30:48 PM', 'MM/DD/YYYY HH:MI:SS AM')); INSERT INTO B1( REV_ACCOUNT_ID, REV_ACCOUNT_NUMBER, REV_ACCOUNT_NAME, CREATED_BY, CREATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE ) VALUES ( 30905, '91015', 'OTHER INCOME TAXES', 'SYSTEM', TO_Date( '06/02/2008 01:30:48 PM', 'MM/DD/YYYY HH:MI:SS AM') , 'SYSTEM', TO_Date( '06/02/2008 01:30:48 PM', 'MM/DD/YYYY HH:MI:SS AM')); commit;