Table creation script and file to be loaded CREATE TABLE APPS.LAXMAN_ETDS_FH ( A NUMBER, B NUMBER, C NUMBER, D NUMBER, Line_number NUMBER, Record_type VARCHAR2(2), File_type VARCHAR2(4), upload_type VARCHAR2(2), file_creation_date DATE, file_sequence_number NUMBER, uploader_type VARCHAR2(1), TAN_of_deductor VARCHAR2(10), Total_no_of_batches NUMBER, Record_hash VARCHAR2(2), FVU_version VARCHAR2(2), file_hash VARCHAR2(2), sam_version VARCHAR2(2), sam_hash VARCHAR2(2), SCM_version VARCHAR2(2), SCM_hash VARCHAR2(2) ) CREATE TABLE APPS.LAXMAN_ETDS_BH ( A number, B number, c number, d number, Line_Number NUMBER, Record_Type VARCHAR2(2), Batch_Number NUMBER, Count_of_ChlnRecords NUMBER, Form_Number VARCHAR2(4), Transaction_Type varchar2(2), Batch_Updation_Indicator varchar2(2), Original_RRR_No varchar(2), Previous_RRR_Number varchar2(2), RRR_Number varchar2(2), RRR_Date varchar2(2), Last_TAN_Deductor varchar2(2), TAN_of_Deductor VARCHAR2(10), Filler1 varchar2(2), PAN_of_Deductor VARCHAR2(10), Assessment_Yr NUMBER, Financial_Yr NUMBER, Period VARCHAR2(2), Name_of_Deductor VARCHAR2(75), Deductor_Branch VARCHAR2(75), Deductor_Address1 VARCHAR2(25), Deductor_Address2 VARCHAR2(25), Deductor_Address3 VARCHAR2(25), Deductor_Address4 VARCHAR2(25), Deductor_Address5 VARCHAR2(25), Deductor_State NUMBER, Deductor_Pincode NUMBER, Deductor_EmailID VARCHAR2(75), Deductor_STD NUMBER, Deductor_Ph_No NUMBER, Address_cahnge_since_last_Ret VARCHAR2(1), Deductor_Type VARCHAR2(1), Person_responsible_Deduction VARCHAR2(75), Designation VARCHAR2(20), Resp_Person_Address1 VARCHAR2(25), Resp_Person_Address2 VARCHAR2(25), Resp_Person_Address3 VARCHAR2(25), Resp_Person_Address4 VARCHAR2(25), Resp_Person_Address5 VARCHAR2(25), Resp_Person_State NUMBER, Resp_Person_PIN NUMBER, Resp_Person_Email VARCHAR2(75), Remark VARCHAR2(75), Resp_Person_STD_CODE NUMBER, Resp_Person_Phone_No NUMBER, Change_Addr_since_last_Return VARCHAR2(1), Batch_Total_Deposit_Amt NUMBER, TDSCircle varchar2(2), Count_Salary_Det_Records varchar2(2) , Batch_Total_Gross_Income varchar2(2), AO_Approval VARCHAR2(1), AO_Approval_number VARCHAR2(15), Record_Hash varchar2(2)) CREATE TABLE APPS.LAXMAN_ETDS_cd ( A number, B number, c number, d number, Line_Number NUMBER, Record_Type VARCHAR2(2), Batch_Number NUMBER, Chln_Det_Record_No NUMBER, Count_Deductee NUMBER, NIL_Chln_Indicator VARCHAR2(1), Chln_Updation_Indicator varchar2(2), Filler_2 varchar2(2), Filler_3 varchar2(2), Filler_4 varchar2(2), Last_Bank_Chln_No varchar2(2), Bank_Challan_No NUMBER, Last_Transfer_Vch_No varchar2(2), Transfer_Vch_No NUMBER, Last_Bank_Branch_Code varchar2(2), Bank_Branch_Code NUMBER , Last_Date_Bank_Chln_No varchar2(2), Date_Bank_Chln_No DATE , Filler_5 varchar2(2), Filler_6 varchar2(2), Section VARCHAR2(3), Oltas_TDS_Income_Tax NUMBER(15,2), Oltas_TDS_Surcharge NUMBER(15,2), Oltas_TDS_Cess NUMBER(15,2), Oltas_TDS_Interest_Amt NUMBER(15,2), Oltas_TDS_Others NUMBER(15,2), Total_Deposit_Amt_Chln NUMBER(15,2), Last_Total_Dep_Amt varchar2(2), Tot_Tax_Dep_Amt nUMBER(15,2), TDS_Income_Tax nUMBER(15,2), TDS_Surcharge nUMBER(15,2), TDS_Cess nUMBER(15,2), Sum_Tot_IT_Deducted_Source nUMBER(15,2), TDS_TCS_Interest_Amt nUMBER(15,2), TDS_TCS_Others_amt nUMBER(15,2), Cheque_DD_No nUMBER(15,2), Book_entry_Cash VARCHAR2(1), Remarks VARCHAR2(14), Record_Hash varchar2(2)) CREATE TABLE APPS.LAXMAN_ETDS_dd ( A number, B number, c number, d number, Line_No Number, Record_Type varchar2(2), Batch_Number number, Chln_Det_Record Number, Deductee_Detail_Record_No number, Mode_etds varchar2(1), Employee_Serial_No varchar2(2), Deductee_Code varchar2(1), Last_Party_PAN varchar2(2), Deductee_PAN varchar2(10), Last_Party_PAN_Ref_No varchar2(2), PAN_Ref_No varchar2(10), Name_deductee varchar2(75), TDS_IT_for_period number(15,2), TDS_Surcharge number(15,2), TDS_TCS_Cess number(15,2), Tot_IT_Deduc_Source number(15,2), Last_Tot_IT_Deduct_Source varchar2(2), Tot_Tax_Deposited number(15,2), Last_Tot_Tax_Deposited varchar2(2), Tot_Purchase varchar2(2), Amt_Payment_Credit number(15,2), Date_Amt_paid DATE, Date_tax_Deducted DATE , Date_Deposit varchar2(2), Rate_Tax_Ded_Coll number(7,4), Grossing_up_Ind varchar2(2), Book_Entry varchar2(1), Date_Tax_Deduction varchar2(2), Remarks_1 varchar2(1), Remarks_2 varchar2(75), Remarks_3 varchar2(14), Record_Hash varchar2(2)) 1^FH^NS1^R^03112006^1^D^BLRV03426D^1^^^^^^^ 2^BH^1^4^26Q^^^^^^^^BLRV03426D^^AAACV7160R^200607^200506^Q4^V S Dempo & company Pvt. Ltd.^^DEMPO HOUSE^CAMPAL^PANAJI, GOA^^^10^403001^^^^N^O^RANGANATH T NAIK^SR. EXECUTIVE ACCTS^CAMPAL - PANJIM^^^^^10^403001^^^^^N^114471.00^^^^N^^ 3^CD^1^1^1^N^^^^^^00001^^^^0220342^^01062006^^^94J^33060.00^3306.00^727.00^0.00^0.00^37093.00^^37093.00^33059.72^3305.97^727.31^37093.00^0.00^0.00^7718535^^^ 4^DD^1^1^1^O^^2^^AAAFF0644F^^^FRASER & ROSS^33059.72^3305.97^727.31^37093.00^^37093.00^^^661200.00^31032006^31032006^^5.6100^^N^^^^^ 5^CD^1^2^1^N^^^^^^00012^^^^0220342^^07092006^^^94J^10000.00^1000.00^220.00^0.00^0.00^11220.00^^11220.00^10000.00^1000.00^220.00^11220.00^0.00^0.00^900789^^^ 6^DD^1^2^1^O^^2^^PANNOTAVBL^^^DELOITTE HASKINS & SELLS^10000.00^1000.00^220.00^11220.00^^11220.00^^^200000.00^09022006^31032006^^5.6100^^N^^^^^ 7^CD^1^3^26^N^^^^^^00015^^^^0220342^^31052006^^^94J^48404.00^3702.00^1042.00^0.00^0.00^53148.00^^53148.00^48404.22^3701.66^1042.12^53148.00^0.00^0.00^142^^^ 8^DD^1^3^1^O^^2^^AAEPB4614K^^^AJIT S.BHASME^1250.00^0.00^25.00^1275.00^^1275.00^^^25000.00^25032006^31032006^^5.1000^^N^^^^^ 9^DD^1^3^2^O^^2^^PANNOTAVBL^^^ANIL R. UPADHYE AND ASSOCIATES^139.93^13.99^3.08^157.00^^157.00^^^2806.00^27032006^31032006^^5.6100^^N^^^^^ 10^DD^1^3^3^O^^2^^AGHPS6127P^^^RAMESH N SARDESAI^600.00^0.00^12.00^612.00^^612.00^^^12000.00^24032006^31032006^^5.1000^^N^^^^^ 11^DD^1^3^4^O^^2^^AAAFS1034J^^^SHARP & TANNAN ASSOCIATES^2065.95^206.60^45.45^2318.00^^2318.00^^^41325.00^11012006^31032006^^5.6100^^N^^^^^ 12^DD^1^3^5^O^^2^^PANNOTAVBL^^^A.B.SOHANI^1025.49^0.00^20.51^1046.00^^1046.00^^^21300.00^06032006^31032006^^5.1000^^N^^^^^ 13^DD^1^3^6^O^^2^^PANNOTAVBL^^^BHIM SAIN^700.00^0.00^14.00^714.00^^714.00^^^17971.00^31032006^31032006^^5.1000^^N^^^^^ 14^DD^1^3^7^O^^2^^PANNOTAVBL^^^CHANDRAKANT M.GAUNS^247.06^0.00^4.94^252.00^^252.00^^^4950.00^13032006^13032006^^5.1000^^N^^^^^ 15^DD^1^3^8^O^^2^^PANNOTAVBL^^^DUDHASAGAR TRANSPORTER & CONTRACTOR^193.41^19.34^4.25^217.00^^217.00^^^3870.43^10122005^31032006^^5.6100^^N^^^^^ 16^DD^1^3^9^O^^2^^PANNOTAVBL^^^ERICSON & RICHARDS^324.42^32.44^7.14^364.00^^364.00^^^6486.00^20022006^31032006^^5.6100^^N^^^^^ 17^DD^1^3^10^O^^2^^PANNOTAVBL^^^J.A.F.LEITAO & SON^1511.76^0.00^30.24^1542.00^^1542.00^^^30230.00^28032006^31032006^^5.1000^^N^^^^^ 18^DD^1^3^11^O^^2^^PANNOTAVBL^^^PAIK TRANSPORT^155.96^15.60^3.44^175.00^^175.00^^^3104.01^12022006^31032006^^5.6100^^N^^^^^ 19^DD^1^3^12^O^^2^^PANNOTAVBL^^^PRADIP KUMAR SEN^525.49^0.00^10.51^536.00^^536.00^^^10500.00^31032006^31032006^^5.1000^^N^^^^^ 20^DD^1^3^13^O^^2^^AERPP9406N^^^PRAKASH PRABHUDESSAI^100.00^0.00^2.00^102.00^^102.00^^^2000.00^31032006^31032006^^5.1000^^N^^^^^ 21^DD^1^3^14^O^^2^^PANNOTAVBL^^^RAGHUVIR B.S.KUNDAIKER^377.45^0.00^7.55^385.00^^385.00^^^28640.00^23032006^31032006^^5.1000^^N^^^^^ 22^DD^1^3^15^O^^2^^PANNOTAVBL^^^S.V.NADKARNI^1000.00^0.00^20.00^1020.00^^1020.00^^^20000.00^31032006^31032006^^5.1000^^N^^^^^ 23^DD^1^3^16^O^^2^^PANNOTAVBL^^^SEA & OCEAN SHIPPING^624.77^62.48^13.75^701.00^^701.00^^^12495.00^25022006^31032006^^5.6100^^N^^^^^ 24^DD^1^3^17^O^^2^^PANNOTAVBL^^^SUDESH USGAONKAR^500.00^0.00^10.00^510.00^^510.00^^^10000.00^31032006^31032006^^5.1000^^N^^^^^ 25^DD^1^3^18^O^^2^^PANNOTAVBL^^^SUDHA EARTHMOVERS^11252.27^1125.20^247.53^12625.00^^12625.00^^^225000.00^24032006^31032006^^5.6100^^N^^^^^ 26^DD^1^3^19^O^^2^^PANNOTAVBL^^^SUDIN USGAONKAR^500.00^0.00^10.00^510.00^^510.00^^^10000.00^31032006^31032006^^5.1000^^N^^^^^ 27^DD^1^3^20^O^^2^^PANNOTAVBL^^^VINOD KUMAR SUNDRIYAL^1250.00^0.00^25.00^1275.00^^1275.00^^^25000.00^06032006^06032006^^5.1000^^N^^^^^ 28^DD^1^3^21^O^^2^^PANNOTAVBL^^^Y.S.RAGHAVENDRA RAO^1050.00^0.00^21.00^1071.00^^1071.00^^^21000.00^31032006^31032006^^5.1000^^N^^^^^ 29^DD^1^3^22^O^^2^^PANNOTAVBL^^^SATERI BORCOTESHWAR ENTERPRISES^1229.95^122.99^27.06^1380.00^^1380.00^^^24615.68^03032006^31032006^^5.6100^^N^^^^^ 30^DD^1^3^23^O^^2^^PANNOTAVBL^^^DEVASHRI REAL ESTATE DEVELOPERS^11864.53^1186.45^261.02^13312.00^^13312.00^^^237293.00^18022006^31032006^^5.6100^^N^^^^^ 31^DD^1^3^24^O^^2^^PANNOTAVBL^^^P.P.MAHATME & CO.^750.45^75.04^16.51^842.00^^842.00^^^15000.00^31032006^31032006^^5.6100^^N^^^^^ 32^DD^1^3^25^O^^2^^PANNOTAVBL^^^PRAKASH NADKARNI^750.00^0.00^15.00^765.00^^765.00^^^20000.00^31032006^31032006^^5.1000^^N^^^^^ 33^DD^1^3^26^O^^2^^PANNOTAVBL^^^KESHAV NARAYAN KAMAT & CO.^8415.33^841.53^185.14^9442.00^^9442.00^^^168300.00^31032006^31032006^^5.6100^^N^^^^^ 34^CD^1^4^4^N^^^^^^00071^^^^0220342^^07042006^^^94J^12755.00^0.00^255.00^0.00^0.00^13010.00^^13010.00^12754.90^0.00^255.10^13010.00^0.00^0.00^31^^^ 35^DD^1^4^1^O^^2^^ACCPB6429L^^^M.V.BHARNE^275.49^0.00^5.51^281.00^^281.00^^^5510.00^17022006^01032006^^5.1000^^N^^^^^ 36^DD^1^4^2^O^^2^^PANNOTAVBL^^^SHIRISH GUPTE^4953.92^0.00^99.08^5053.00^^5053.00^^^99083.00^29032006^31032006^^5.1000^^N^^^^^ 37^DD^1^4^3^O^^2^^PANNOTAVBL^^^RAGHUVIR B.S.KUNDAIKER^7350.00^0.00^147.00^7497.00^^7497.00^^^259055.00^01032006^31032006^^5.1000^^N^^^^^ 38^DD^1^4^4^O^^2^^PANNOTAVBL^^^DR. G.M.S. NADKARNI^175.49^0.00^3.51^179.00^^179.00^^^3500.00^04032006^04032006^^5.1000^^N^^^^^