USE tcomm
Create Table COUNTRY_MASTER (CountryName Varchar(20) Primary key)
Create Table STATE_MASTER (StateName Varchar(25) Primary key, CountryName Varchar(20),StateCode Varchar(2))
Create Table CATALOG_MASTER (CatalogName Varchar(35) Primary key)
Create Table CITY_MASTER(CityName Varchar(35) Primary key,StateName Varchar(25),STDCode Numeric(6))
Create Table BANK_MASTER (BankName Varchar(35) Primary key)
Create Table VOUCHER_TYPE_MASTER (TypeName Varchar(25) Primary key,GSTPerc Money,HSNCode Varchar(10),DescGST Varchar(50))
Create Table GENERAL_ITEM_MASTER (GeneralItemName Varchar(30) Primary key,HSNCode Varchar(10),GSTPerc Money,DescGST Varchar(50))
Create Table GREY_ITEM_MASTER (ItemName Varchar(30) Primary Key,ItemRatePerPcs Money,ItemRatePerMts Money,HSNCode Varchar(10),GSTPerc Money,DescGST Varchar(50))
Create Table ITEM_CATEGORIES_MASTER (ItemCategories Varchar(10) Primary Key)
Create Table ITEM_QUALITY_MASTER (ItemQuality Varchar(10) Primary Key)
Create Table FINISHED_ITEM_MASTER (ItemName Varchar(30) Primary Key,ItemQuality Varchar(10),ItemCategories Varchar(30),ItemRatePerPcs Money,ItemRatePerMts Money,ItemCut Money,ItemTopName Varchar(30),ItemTopMts Money,ItemMiddleName Varchar(30),ItemMiddleMts Money,ItemBottomName Varchar(30),ItemBottomMts Money,ItemOtherName Varchar(30),ItemOtherMts Money,ItemCutPcsMtr Money,ItemMtsPerKG Money,ItemGrp Varchar(30),ItemImagePath Varchar(255),FoldPerc Money,ItemImagePath2 Varchar(255),ItemImagePath3 Varchar(255),ItemImagePath4 Varchar(255),ItemImagePath5 Varchar(255),PurRatePerPcs Money,PurRatePerMts Money,HSNCode Varchar(10),GSTPerc Money,DescGST Varchar(50))
Create Table SCREEN_ITEM_MASTER (ItemName Varchar(30) Primary Key,ItemRatePerPcs Money,ItemRatePerMts Money,ItemGrp Varchar(30),ItemImagePath Varchar(255),ItemOn Varchar(30),ItemCut Money,FabCost Money,JobCost Money,TotCost Money,CatalogName Varchar(35),Target Money,ItemImagePath2 Varchar(255),ItemImagePath3 Varchar(255),ItemImagePath4 Varchar(255),ItemImagePath5 Varchar(255),ScreenPcs Numeric(6),PurRatePerPcs Money, PurRatePerMts Money,ProfitPerc Money,Size Varchar(15),HSNCode Varchar(10),GSTPerc Money)
Create Table SUB_SCREEN_ITEM_MASTER (ItemName Varchar(30) Primary Key,ItemRatePerPcs Money,ItemRatePerMts Money,ItemGrp Varchar(30),ItemImagePath Varchar(255),ItemOn Varchar(30),Packing Varchar(30))
Create Table RANGE_DESCRIPTION_MASTER (ItemRangeDesp Varchar(30),ExcessRate Money,ScreenName Varchar(30),PartyCode Varchar(7),JobRate Money)
Create Table COMPANY_YEAR(CompYear Varchar(7) Primary key)
Create Table ACCOUNT_TYPES(AccTypes Varchar(35) Primary key,FinalType Varchar(25), FinalCrDr Varchar(25),FinalView Numeric(3),FinalApplicable Varchar(25))
Create Table COMPANY_DETAIL(CompCode Varchar(7) Primary Key, CompName Varchar(35), CompOpeningDate DateTime,CompClosingDate DateTime,CompYear Varchar(7),CompStatus Varchar(5),NextYearCode Varchar(7))
Create Table AGENT_MASTER(AgentCode Varchar(7) Primary Key,AgentName Varchar(35), AgentAdd1 Varchar(100), AgentAdd2 Varchar(100),AgentAdd3 Varchar(100),AgentCityName Varchar(35),AgentCityPin Numeric(6),AgentPhone Varchar(35),AgentMobile Varchar(35),AgentFax Varchar(35),AgentEmail Varchar(50),AgentResident Varchar(35),AgentPANNo Varchar(35),AgentContPerson Varchar(35),AccType Varchar(35),BlackListed Varchar(1),GSTIN Varchar(15),CompScheme Varchar(3))
Create Table GROUP_MASTER(GrpCode Varchar(7) Primary Key,GrpName Varchar(35), GrpAdd1 Varchar(100), GrpAdd2 Varchar(100),GrpAdd3 Varchar(100),GrpCityName Varchar(35),GrpCityPin Numeric(6),GrpPhone Varchar(35),GrpMobile Varchar(35),GrpFax Varchar(35),GrpEmail Varchar(50),GrpResident Varchar(35),GrpContPerson Varchar(35),AgentCode Varchar(7) Foreign Key References AGENT_MASTER(AgentCode),DisPerc Money,RDPerPcs Money,RDPerMts Money,Branch Varchar(1))
Create Table ACCOUNT_MASTER (AccCode Varchar(7) Primary Key,AccName Varchar(50),AccType Varchar(35),AccAgentCode Varchar(7) Foreign Key References AGENT_MASTER(AgentCode),AccGroupCode Varchar(7) Foreign Key References GROUP_MASTER(GrpCode),AccAdd1 Varchar(100), AccAdd2 Varchar(100),AccAdd3 Varchar(100),AccCityName Varchar(35),AccCityPin Numeric(6),AccPhone Varchar(35),AccMobile Varchar(35),AccFax Varchar(35),AccEmail Varchar(50),AccResident Varchar(35),AccGSTNo Varchar(35),AccCSTNo Varchar(35),AccPANNo Varchar(35),AccVATNo Varchar(35),AccContPerson Varchar(35),AccRef Varchar(255),AccCrLimit Money,AccCrDays Numeric(4),AccTANNo Varchar(35),AccKSTNo Varchar(35),TDSYesNo Varchar(3),TDSAccount Varchar(35),JobType Varchar(35),DiscPerc Money,RDPerPcs Money,RDPerMts Money,InsPolicyNo Varchar(35),Dhara Money,DharaDays Numeric(6),TransName Varchar(35), AccAdd21 Varchar(100), AccAdd22 Varchar(100),AccAdd23 Varchar(100),AccCityName2 Varchar(35),AccCityPin2 Numeric(6),BlackListed Varchar(1),BankDetail Varchar(255),ExcessRate Money,SeriesName Varchar(30),CommPerc Money, TDSLimit Money,BankName Varchar(35),AccountNo Varchar(35),IFSCCode Varchar(50),Branch Varchar(50),LessDays Numeric(6),PackPerPcs Money,BankCommPerc Money,BankCommLessPerc Money,PackPerMts Money,PostageCharge Money,Taxable Varchar(1),GSTIN Varchar(15),CompScheme Varchar(3),GSTCategory Varchar(15))
Create Table LOGIN_DETAIL (UName Varchar(20) Primary Key,PWord Varchar(10),UserPermit Varchar(255))
Create Table TRANSPORT_MASTER (TransName Varchar(35) Primary Key,TransPhone Varchar(35),TransEmail Varchar(50),TransAdd1 Varchar(30),TransAdd2 Varchar(30))
Create Table TDS_TYPE_MASTER (TDSType Varchar(35) Primary Key,TDSCode Varchar(30),IncomeTax Money,Surcharge Money,EducationCess Money,AccTDSCode Varchar(7),NatOfPay Varchar(255))
Create Table USER_PERMISSION(UName Varchar(20),USettingName Varchar(255),USettingValue Varchar(255))
Create Table LABEL_DETAIL (StickerName Varchar(30),StickerType Varchar(30),Line1 Varchar(30),Line2 Varchar(30),Line3 Varchar(30),Line4 Varchar(30),Line5 Varchar(30),Line6 Varchar(30),LabSet1 Varchar(30),LabSet2 Varchar(30),LabSet3 Varchar(30),LabSet4 Varchar(30),LabSet5 Varchar(30),LabSet6 Varchar(30),StickerPrint Varchar(7))
Create Table HOLYDAYS_LIST (HolyDate DateTime Primary Key,HolyName Varchar(35))
Create Table HASTE_MASTER (Haste Varchar(25) Primary key,HasAdd1 Varchar(100), HasAdd2 Varchar(100),HasAdd3 Varchar(100),HasCityName Varchar(35),HasCityPin Numeric(6),HasPhone Varchar(35),HasMobile Varchar(35),HasFax Varchar(35),HasEmail Varchar(50),HasResident Varchar(35),HasGSTNo Varchar(35),HasCSTNo Varchar(35),HasContPerson Varchar(35),HasKSTNo Varchar(35),HasTransport Varchar(35),TINNo Varchar(35),InsPolicyNo Varchar(35),PANNo Varchar(35),GSTIN Varchar(15),CompScheme Varchar(3))
Create Table REMARK_MASTER (Remark Varchar(255) Primary key)
Create Table REMARK_DETAIL (PartyCode Varchar(7),RemDate DateTime,Remark Varchar(700))
Create Table REPORT_SETTING (RptName Varchar(255),FldName Varchar(30),CustSize Numeric(2),ColSrNo Numeric(2))
Create Table SERIES_MASTER (SeriesName Varchar(30),ItemName Varchar(30),ScreenName Varchar(30),SubScreen Varchar(30),ItemRate Money,Pcs Numeric(6))
Create Table MARKET_MASTER (MarketName Varchar(50) Primary key)
Create Table THEME_SETTING (ThemeType Varchar(35),ThemeValue Varchar(255))
Create Table PRINTING_MASTER (MasterName Varchar(35),Phone Varchar(30),Mobile Varchar(30),EmailID Varchar(30),MillCode Varchar(7))
Create Table JOB_CHALLAN_MASTER (ChallanName Varchar(35),ChallanSrNo Numeric(6),ProcessDays Numeric(6),GSTPerc Money,HSNCode Varchar(10),DescGST Varchar(50))
Create Table USER_WORK_DETAIL (UName Varchar(20),UPermit Varchar(255),CurDate DateTime,CurTime DateTime,BillNoSerialNo Varchar(255),BillSerialDate DateTime,EntryForm Varchar(255),ActionTaken Varchar(255),Company Varchar(255),CompYear Varchar(255),Party Varchar(255),BillNo Varchar(255))
Create Table ITEM_ON_MASTER (ItemName Varchar(30) Primary Key,ShortName Varchar(7))
Create Table UPDATE_DETAIL (SoftName Varchar(35),UpdDate DateTime,UpdTime DateTime,UpdNo Money)
CREATE TABLE LICENCE_DETAIL (AMCDate Varchar(255),AMCGrace Varchar(255))