Create Database TamCOMP on (name = TamCOMP_data, filename ='D:\Tamanna\TamCOMP_data.mdf') log on (name =TamCOMP_log, filename ='D:\Tamanna\TamCOMP_log.ldf')

Create Table TamCOMP.dbo.COUNTRY_MASTER (CountryName Varchar(20) Primary key)
Create Table TamCOMP.dbo.STATE_MASTER (StateName Varchar(25) Primary key, CountryName Varchar(20),StateCode Varchar(2))
Create Table TamCOMP.dbo.ITEM_ON_MASTER (ItemName Varchar(30) Primary Key,ShortName Varchar(7))
Create Table TamCOMP.dbo.CITY_MASTER(CityName Varchar(35) Primary key,StateName Varchar(25),STDCode Numeric(6))
Create Table TamCOMP.dbo.CATALOG_MASTER (CatalogName Varchar(35) Primary key)
Create Table TamCOMP.dbo.BANK_MASTER (BankName Varchar(35) Primary key)
Create Table TamCOMP.dbo.SERIES_MASTER (SeriesName Varchar(30),ItemName Varchar(30),ScreenName Varchar(30),SubScreen Varchar(30),ItemRate Money,Pcs Numeric(6))
Create Table TamCOMP.dbo.MARKET_MASTER (MarketName Varchar(50) Primary key)
Create Table TamCOMP.dbo.JOB_CHALLAN_MASTER (ChallanName Varchar(35),ChallanSrNo Numeric(6),ProcessDays Numeric(6),GSTPerc Money,HSNCode Varchar(10),DescGST Varchar(50))
Create Table TamCOMP.dbo.VOUCHER_TYPE_MASTER (TypeName Varchar(25) Primary key,GSTPerc Money,HSNCode Varchar(10),DescGST Varchar(50))
Create Table TamCOMP.dbo.HASTE_MASTER (Haste Varchar(50) 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(100),HasKSTNo Varchar(35),HasTransport Varchar(35),TINNo Varchar(35),InsPolicyNo Varchar(35),PANNo Varchar(35),GSTIN Varchar(15),CompScheme Varchar(3),GSTRegDate DateTime,AccManager Varchar(100), CityDistanceKM Numeric(6))
Create Table TamCOMP.dbo.GENERAL_ITEM_MASTER (GeneralItemName Varchar(30) Primary key,HSNCode Varchar(10),GSTPerc Money,DescGST Varchar(50))
Create Table TamCOMP.dbo.ITEM_CATEGORIES_MASTER (ItemCategories Varchar(10) Primary Key)
Create Table TamCOMP.dbo.ITEM_QUALITY_MASTER (ItemQuality Varchar(10) Primary Key)
Create Table TamCOMP.dbo.ACCOUNT_TYPES(AccTypes Varchar(35) Primary key,FinalType Varchar(25), FinalCrDr Varchar(25),FinalView Numeric(3),FinalApplicable Varchar(25))
Create Table TamCOMP.dbo.COMPANY_DETAIL(CompCode Varchar(7) Primary Key, CompName Varchar(50),CompAdd1 Varchar(100),CompAdd2 Varchar(100),CompAdd3 Varchar(100),CompCityName Varchar(35),CompCityPin Numeric(6),CompCountry Varchar(20),CompPhone Varchar(35),CompMobile Varchar(35),CompFax Varchar(35),CompEmail Varchar(50),CompResident Varchar(35),CompGSTNo Varchar(35),CompCSTNo Varchar(35),CompPANNo Varchar(35),CompVATNo Varchar(35),CompOpeningDate DateTime,CompClosingDate DateTime, CompYear Varchar(7),CompCurBase Varchar(10),CompCurUnit Varchar(10),CompCaption1 Varchar(35),CompCaption2 Varchar(35),CompFirmType Varchar(35),CompSign Varchar(35),BranchAddress Varchar(80),CompTANNo Varchar(35),CompTDSITO Varchar(35),GSTIN Varchar(15),GSPUserName Varchar(35),GSPPassword Varchar(35),GSPMobileNo Varchar(35))
Create Table TamCOMP.dbo.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(100),AccType Varchar(35),BlackListed Varchar(1),GSTIN Varchar(15),CompScheme Varchar(3),GSTRegDate DateTime,MstType Varchar(25))
Create Table TamCOMP.dbo.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(100),AgentCode Varchar(7) Foreign Key References AGENT_MASTER(AgentCode),DisPerc Money,RDPerPcs Money,RDPerMts Money,Branch Varchar(1))
Create Table TamCOMP.dbo.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(100),AccRef Varchar(255),AccCrLimit Money,AccCrDays Numeric(4),AccOpenBal Money,AccOpenBalCrDr Varchar(2),AccSharePerc Money,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),TDSStart DateTime,TDSEnd DateTime,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),ECommGSTIN Varchar(15),GSTRegDate DateTime,AccManager Varchar(100), CityDistanceKM Numeric(6),SMAccCode Varchar(7))
Create Table TamCOMP.dbo.GREY_ITEM_MASTER (ItemName Varchar(30) Primary Key,ItemRatePerPcs Money,ItemRatePerMts Money,ItemOpeningPcs Numeric(7),ItemOpeningMts Money,ItemOpeningValue Money,HSNCode Varchar(10),GSTPerc Money,DescGST Varchar(50),EntType Varchar(25))
Create Table TamCOMP.dbo.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),ItemOpeningPcs Numeric(7),ItemOpeningMts Money, ItemOpeningValue Money,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 TamCOMP.dbo.SCREEN_ITEM_MASTER (ItemName Varchar(30) Primary Key,ItemRatePerPcs Money,ItemRatePerMts Money,ItemGrp Varchar(30),ItemOpeningPcs Numeric(7),ItemOpeningMts Money, ItemOpeningValue Money,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 TamCOMP.dbo.SUB_SCREEN_ITEM_MASTER (ItemName Varchar(30) Primary Key,ItemRatePerPcs Money,ItemRatePerMts Money,ItemGrp Varchar(30),ItemOpeningPcs Numeric(7),ItemOpeningMts Money, ItemOpeningValue Money,ItemImagePath Varchar(255),ItemOn Varchar(30),Packing Varchar(30))
Create Table TamCOMP.dbo.TRANSPORT_MASTER (TransName Varchar(35) Primary Key,TransPhone Varchar(35),TransEmail Varchar(50),TransAdd1 Varchar(30),TransAdd2 Varchar(30),GSTIN Varchar(50))
Create Table TamCOMP.dbo.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 TamCOMP.dbo.RANGE_DESCRIPTION_MASTER (ItemRangeDesp Varchar(30),ExcessRate Money,ScreenName Varchar(30),PartyCode Varchar(7),JobRate Money)
Create Table TamCOMP.dbo.BILL_DETAIL (BillNo Varchar(8) Primary Key,CurDate DateTime,BillDate DateTime,VouNo Varchar(8),VouDate DateTime,CustCode Varchar(7) Foreign Key References ACCOUNT_MASTER(AccCode),AgentCode Varchar(7) Foreign Key References AGENT_MASTER(AgentCode),Haste Varchar(50),GrossAmt Money,NetAmt Money,Remark Varchar(255),TransName Varchar(35),TransLRNo Varchar(60),TransLRCase Varchar(30),TransLRDate DateTime,TransDespStation Varchar(35),UName Varchar(255),BillStatus Varchar(7),SaleType Varchar(7),TransFreight Money,TransWeight Money,OrderForm Varchar(1),PaymentWithinDays Numeric(3),ManualChallan Varchar(50),ManualOrderNo Varchar(50),SpRemark Varchar(255),IsPrinted Varchar(3),LRStatus Varchar(10),Marka Varchar(255),ShortMts Money,GreyRtnMts Money,FoldLessPerc Money,FoldLessAmt Money,BuyerDetail Varchar(700),GSTSupplyType Varchar(15),Muddat Varchar(3),EWayNo Varchar(20),PayMode Varchar(7),SMAccCode Varchar(7),EntType VarChar(25))
Create Table TamCOMP.dbo.BILL_ITEM_DETAIL (BillNo Varchar(8) Foreign Key References BILL_DETAIL(BillNo),ItemName Varchar(30),ItemPcs Numeric(6),ItemCut Money,ItemMts Money,ItemPer Varchar(1),ItemRate Money,ItemAmount Money,ItemRangeDesp Varchar(30),ItemSrNo Numeric(3),PurSrNo Varchar(15),PurISrNo Numeric(3),ItemFold Money,ItemActMts Money,OrdNo Varchar(8),OrdISrNo Numeric(3),SuppGrpCode Varchar(7) Foreign Key References GROUP_MASTER(GrpCode),ItemAddLess Varchar(1),ItemDisPerc Money,ItemSerialNo Varchar(15),ItemDisAmt Money,Bale Numeric(6),ItemDescription Varchar(30),IFSrNo Varchar(6),SuppRate Money,Charak Money,HandComp Money,LaceWork Money,Checking Money,Packing Money,LDA Money,RD Money,RDAmt Money,LessAmt Money,ItemRemark Varchar(255),Supplier Varchar(7),Dollar Money,RSSaleType Varchar(15),RSSaleSrNo Varchar(6),RSSaleISrNo Numeric(6),LTSaleType Varchar(15),LTSaleSrNo Varchar(6),LTSaleISrNo Numeric(6),ItemID Varchar(25),Barcode Varchar(13), SaleMRP Money, SaleDiscPerc Money,HSNCode Varchar(10), IGSTPerc Money, IGSTAmt Money, CGSTPerc Money, CGSTAmt Money, SGSTPerc Money, SGSTAmt Money, UTGSTPerc Money, UTGSTAmt Money, CESSPerc Money, CESSAmt Money,ItemDiscPerc Money, ItemDiscAmt Money, ItemAddPerc Money, ItemAddAmt Money,PackCharge Money, TransCharge Money, AddLess1Name Varchar(35), AddLess1Perc Money, AddLess1Amt Money, AddLess2Name Varchar(35), AddLess2Perc Money, AddLess2Amt Money,BasicRate Money,Fold1 Money, Fold2 Money,Denier Varchar(25),Grade Varchar(25))
Create Table TamCOMP.dbo.BILL_ITEM_TAKA_DETAIL (BillNo Varchar(8) Foreign Key References BILL_DETAIL(BillNo),ItemSrNo Numeric(3),ISrNo Numeric(5),ItemSet Money,ItemQty Numeric(5),ItemTotal Money,ShadeNo Varchar(15))
Create Table TamCOMP.dbo.BILL_ITEM_IF_TAKA_DETAIL (BillNo Varchar(8) Foreign Key References BILL_DETAIL(BillNo),ItemSrNo Numeric(3),TakaSrNo Numeric(5),ItemIFMts Money,ItemSalMts Money,IFSrNo Varchar(255),IFISrNo Numeric(3))
Create Table TamCOMP.dbo.BILL_ITEM_GREY_TAKA_DETAIL (BillNo Varchar(8) Foreign Key References BILL_DETAIL(BillNo),ItemSrNo Numeric(3),TakaSrNo Numeric(6),GreyMts Money,RecdMts Money, GreyTP1 Money,RecdTP1 Money,GreyTP2 Money,RecdTP2 Money,GreyTP3 Money,RecdTP3 Money,GreyTP4 Money,RecdTP4 Money,GreyTP5 Money,RecdTP5 Money,ShortPerc Money,CurTime DateTime)
Create Table TamCOMP.dbo.BILL_CHALLAN_DETAIL (BillNo Varchar(8) Foreign Key References BILL_DETAIL(BillNo),ChallanNo Varchar(8))
Create Table TamCOMP.dbo.BILL_ITEM_YARN_TAKA_DETAIL (BillNo Varchar(8) Foreign Key References BILL_DETAIL(BillNo),ItemSrNo Numeric(6),TakaSrNo Numeric(6),YCompCode Varchar(7),YModule Varchar(25),YSrNo Varchar(15),YISrNo Numeric(6),YITSrNo Numeric(6),CartoonNo Varchar(50),Cone Numeric(6),NetWeight Money,ShadeColor Varchar(50))
Create Table TamCOMP.dbo.READY_STOCK_WISE_SALE (RSSaleType Varchar(15),RSSaleSrNo Varchar(6),RSSaleISrNo Numeric(6),RSDate DateTime,PartyCode Varchar(7),Screen Varchar(30),Pcs Numeric(6),Mts Money,Costing Money,CostingPer Varchar(255))
Create Table TamCOMP.dbo.LOT_WISE_SALE_STOCK (SrNo Varchar(255),ChNo Varchar(255),BillNo Varchar(255),Date DateTime,Party Varchar(255),Pcs Numeric(6),Mts Money, SndPcs Numeric(6),SndMts Money,BalPcs Numeric(6),BalMts Money,Costing Money,ISrNo Numeric(6),IFType Varchar(255),ItemName Varchar(255),Screen Varchar(255),SaleOrdNo Varchar(255),CostingPer Varchar(255),PartyCode Varchar(7),JobRtnPcs Numeric(6),JobRtnMts Money,FinRtnPcs Numeric(6),FinRtnMts Money,ConSrNo Varchar(6),Cut Money,Barcode Varchar(13), SaleMRP Money, SaleDiscPerc Money, SaleRate Money, StockLocation Varchar(50))
Create Table TamCOMP.dbo.CHALLAN_DETAIL (ChallanNo Varchar(8) Primary Key,CurDate DateTime,ChallanDate DateTime,CustCode Varchar(7) Foreign Key References ACCOUNT_MASTER(AccCode),AgentCode Varchar(7) Foreign Key References AGENT_MASTER(AgentCode),Haste Varchar(50),GrossAmt Money,Remark Varchar(255),TransName Varchar(35),TransLRNo Varchar(15),TransLRCase Varchar(30),TransLRDate DateTime,TransDespStation Varchar(35),UName Varchar(255),OrderForm Varchar(1),Marka Varchar(15),ContedBy Varchar(35),ManualOrderNo Varchar(50),SaleType Varchar(7),PackedBy Varchar(25),CheckedBy Varchar(25),BuyerDetail Varchar(700),Freight Money,Weight Money,SMAccCode Varchar(7))
Create Table TamCOMP.dbo.CHALLAN_ITEM_DETAIL (ChallanNo Varchar(8) Foreign Key References CHALLAN_DETAIL(ChallanNo),ItemName Varchar(30),ItemPcs Numeric(6),ItemCut Money,ItemMts Money,ItemPer Varchar(1),ItemRate Money,ItemAmount Money,ItemRangeDesp Varchar(30),ItemSrNo Numeric(3),ItemFold Money,ItemActMts Money,ItemDescription Varchar(30),OrdNo Varchar(8),OrdISrNo Numeric(3),ItemRemark Varchar(255),Bale Numeric(6),PurSrNo Varchar(15),PurISrNo Numeric(3),ItemID Varchar(25),Barcode Varchar(13), SaleMRP Money, SaleDiscPerc Money)
Create Table TamCOMP.dbo.CHALLAN_ITEM_TAKA_DETAIL (ChallanNo Varchar(8) Foreign Key References CHALLAN_DETAIL(ChallanNo),ItemSrNo Numeric(3),ISrNo Numeric(5),ItemSet Money,ItemQty Numeric(5),ItemTotal Money,ShadeNo Varchar(15))
Create Table TamCOMP.dbo.CHALLAN_ITEM_GREY_TAKA_DETAIL (ChallanNo Varchar(8) Foreign Key References CHALLAN_DETAIL(ChallanNo),ItemSrNo Numeric(3),TakaSrNo Numeric(6),GreyMts Money,RecdMts Money, GreyTP1 Money,RecdTP1 Money,GreyTP2 Money,RecdTP2 Money,GreyTP3 Money,RecdTP3 Money,GreyTP4 Money,RecdTP4 Money,GreyTP5 Money,RecdTP5 Money,ShortPerc Money,CurTime DateTime)
Create Table TamCOMP.dbo.FINISHED_PURCHASE (SrNo Varchar(6) Primary Key,CurDate DateTime,BillNo Varchar(20),BillDate DateTime,ChallanNo Varchar(15),ChallanRecdDate DateTime,WeaverCode Varchar(7) Foreign Key References ACCOUNT_MASTER(AccCode),WeaverAgentCode Varchar(7) Foreign Key References AGENT_MASTER(AgentCode),Haste Varchar(50),GrossAmt Money,NetAmt Money,UName Varchar(255),BillStatus Varchar(7),TransName Varchar(35),TransLRNo Varchar(15),TransLRDate DateTime,TransCase Varchar(30),TransFrom Varchar(35),Remark Varchar(50),OrderFrom Varchar(1),OtherLess Money,RateDiffAmt Money,FoldAmt Money,PurType Varchar(7),EntNo Numeric(6),RevCharge Varchar(3),GSTSupplyType Varchar(15),RCMSrNo Varchar(6))
Create Table TamCOMP.dbo.FINISHED_PURCHASE_ITEM_DETAIL (SrNo Varchar(6) Foreign Key References FINISHED_PURCHASE(SrNo),ItemName Varchar(30),ItemPcs Numeric(6),ItemCut Money,ItemMts Money,ItemPer Varchar(1),ItemRate Money,ItemAmount Money,ItemStatus Varchar(7),ItemRangeDesp Varchar(30),OrderNo Varchar(6),OrdISrNo Numeric(3),ItemAddLess Varchar(1),ItemDisPerc Money,ItemSerialNo Varchar(15),ItemDisAmt Money,ItemBillNo Varchar(20),ItemBISrNo Numeric(3),ItemFold Money,ItemFMts Money,ISrNo Numeric(3),ConSrNo Varchar(6),Barcode Varchar(13), SaleMRP Money, SaleDiscPerc Money, SaleRate Money, StockLocation Varchar(50),HSNCode Varchar(10), IGSTPerc Money, IGSTAmt Money, CGSTPerc Money, CGSTAmt Money, SGSTPerc Money, SGSTAmt Money, UTGSTPerc Money, UTGSTAmt Money, CESSPerc Money, CESSAmt Money,ItemDiscPerc Money, ItemDiscAmt Money, ItemAddPerc Money, ItemAddAmt Money, AddLess1Name Varchar(35), AddLess1Perc Money, AddLess1Amt Money, AddLess2Name Varchar(35), AddLess2Perc Money, AddLess2Amt Money,SaleOrdSrNo Varchar(15),SaleOrdISrNo Numeric(6))
Create Table TamCOMP.dbo.FINISHED_PURCHASE_TAKA_DETAIL (SrNo Varchar(6) Foreign Key References FINISHED_PURCHASE(SrNo),ItemSrNo Numeric(3),TakaSrNo Numeric(3),TakaMts Money,ShadeNo VarChar(15))
Create Table TamCOMP.dbo.GREY_PURCHASE (SrNo Varchar(6) Primary Key,CurDate DateTime,BillNo Varchar(20),BillDate DateTime,ChallanNo Varchar(15),ChallanRecdDate DateTime,WeaverCode Varchar(7) Foreign Key References ACCOUNT_MASTER(AccCode),WeaverAgentCode Varchar(7) Foreign Key References AGENT_MASTER(AgentCode),Haste Varchar(50),GrossAmt Money,NetAmt Money,UName Varchar(255),BillStatus Varchar(7),TransName Varchar(35),TransLRNo Varchar(15),TransLRDate DateTime,TransCase Varchar(30),TransFrom Varchar(35),Remark Varchar(50),OrderFrom Varchar(1),WeightVar Money,VarRate Money,VerAmount Money,ShortMts Money,GreyRtnMts Money,FoldLessPerc Money,FoldLessAmt Money,PurType Varchar(7),EntryNo Numeric(6),RevCharge Varchar(3),GSTSupplyType Varchar(15),RCMSrNo Varchar(6), EntType Varchar(25), Commission Varchar(3), CommOn Varchar(25), CommPerc Money, CommAmt Money)
Create Table TamCOMP.dbo.GREY_PURCHASE_ITEM_DETAIL (SrNo Varchar(6) Foreign Key References GREY_PURCHASE(SrNo),ItemSrNo Numeric(3),ItemName Varchar(30),ItemPcs Numeric(6),ItemCut Money,ItemMts Money,ItemFoldPerc Money,ItemActualMts Money,ItemPer Varchar(1),ItemRate Money,ItemAmount Money,OrderNo Varchar(6),OrdISrNo Numeric(3),Marka Varchar(15),PerWT Money,HSNCode Varchar(10), IGSTPerc Money, IGSTAmt Money, CGSTPerc Money, CGSTAmt Money, SGSTPerc Money, SGSTAmt Money, UTGSTPerc Money, UTGSTAmt Money, CESSPerc Money, CESSAmt Money,ItemDiscPerc Money, ItemDiscAmt Money, ItemAddPerc Money, ItemAddAmt Money, AddLess1Name Varchar(35), AddLess1Perc Money, AddLess1Amt Money, AddLess2Name Varchar(35), AddLess2Perc Money, AddLess2Amt Money,YarnLotNo Varchar(25),Denier Varchar(25),Grade Varchar(25))
Create Table TamCOMP.dbo.GREY_PURCHASE_ITEM_TAKA_DETAIL (SrNo Varchar(6),ItemSrNo Numeric(3),ItemName Varchar(30),TakaSrNo Numeric(3),TakaMts Money,TakaTP1 Money,TakaTP2 Money,TakaTP3 Money,TakaTP4 Money,TakaTP5 Money,StWeight Money,OrgWeight Money,Veriation Money,Marka Varchar(15),WevTkSrNo Numeric(6))
Create Table TamCOMP.dbo.GREY_PURCHASE_YARN_TAKA_DETAIL (SrNo Varchar(6),ItemSrNo Numeric(3),TakaSrNo Numeric(3),CartoonNo Varchar(50),Cone Numeric(6),NetWeight Money,ShadeColor Varchar(50))
Create Table TamCOMP.dbo.PAYMENT_BANK_BOOK_DETAIL (BkSrNo Varchar(6) Primary Key,BkAccCode Varchar(7) Foreign Key References ACCOUNT_MASTER(AccCode),BkBankAccCode Varchar(7) Foreign Key References ACCOUNT_MASTER(AccCode),BkChequeAmt Money,BkChequeDate DateTime,BkRemark Varchar(255),BkCurDate DateTime,BkCurTime DateTime,BkUName Varchar(255),BkClearingDate DateTime,BkChequeNo Varchar(15))
Create Table TamCOMP.dbo.PAYMENT_BANK_BOOK_ADDLESS_DETAIL (BkSrNo Varchar(6) Foreign Key References PAYMENT_BANK_BOOK_DETAIL(BkSrNo),BkBillNo Varchar(20),BkDiscPerc Money,BkDiscPercAmt Money,BkRateDiff Money,BkClaimLess Money,BkBankCommission Money,BkAddInterestPerc Money,BkAddInterestPercAmt Money,BkBillPaidAmt Money,BkStatus Varchar(7),BkTDSPartyCode Varchar(7))
Create Table TamCOMP.dbo.PAYMENT_CASH_BOOK_DETAIL (BkSrNo Varchar(6) Primary Key,BkAccCode Varchar(7) Foreign Key References ACCOUNT_MASTER(AccCode),BkCashAccCode Varchar(7) Foreign Key References ACCOUNT_MASTER(AccCode),BkCashAmt Money,BkCashDate DateTime,BkRemark Varchar(255),BkCurDate DateTime,BkCurTime DateTime,BkUName Varchar(255))
Create Table TamCOMP.dbo.PAYMENT_CASH_BOOK_ADDLESS_DETAIL (BkSrNo Varchar(6) Foreign Key References PAYMENT_CASH_BOOK_DETAIL(BkSrNo),BkBillNo Varchar(20),BkDiscPerc Money,BkDiscPercAmt Money,BkRateDiff Money,BkClaimLess Money,BkBankCommission Money,BkAddInterestPerc Money,BkAddInterestPercAmt Money,BkBillPaidAmt Money,BkStatus Varchar(7))
Create Table TamCOMP.dbo.RECEIVED_BANK_BOOK_DETAIL (BkSrNo Varchar(6) Primary Key,BkAccCode Varchar(7) Foreign Key References ACCOUNT_MASTER(AccCode),BkBankAccCode Varchar(7) Foreign Key References ACCOUNT_MASTER(AccCode),BkPartyBankName Varchar(35),BkChequeAmt Money,BkChequeDate DateTime,BkRemark Varchar(255),BkClearingSlipNo Numeric(10),BkCurDate DateTime,BkCurTime DateTime,BkUName Varchar(255),BkClearingDate DateTime,BkChequeNo Varchar(15),PartySlipNo Varchar(30))
Create Table TamCOMP.dbo.RECEIVED_BANK_BOOK_ADDLESS_DETAIL (BkSrNo Varchar(6) Foreign Key References RECEIVED_BANK_BOOK_DETAIL(BkSrNo),BkBillNo Varchar(20),BkDiscPerc Money,BkDiscPercAmt Money,BkRateDiff Money,BkClaimLess Money,BkBankCommission Money,BkAddInterestPerc Money,BkAddInterestPercAmt Money,BkBillPaidAmt Money,BkStatus Varchar(7),BkDisBal Money,BkRDBal Money,BkGRBal Money,BkIntBal Money,DisputeRemark Varchar(50),BkTDSAmt Money)
Create Table TamCOMP.dbo.RECEIVED_CASH_BOOK_DETAIL (BkSrNo Varchar(6) Primary Key,BkAccCode Varchar(7) Foreign Key References ACCOUNT_MASTER(AccCode),BkCashAccCode Varchar(7) Foreign Key References ACCOUNT_MASTER(AccCode),BkCashAmt Money,BkCashDate DateTime,BkRemark Varchar(255),BkCurDate DateTime,BkCurTime DateTime,BkUName Varchar(255))
Create Table TamCOMP.dbo.RECEIVED_CASH_BOOK_ADDLESS_DETAIL (BkSrNo Varchar(6) Foreign Key References RECEIVED_CASH_BOOK_DETAIL(BkSrNo),BkBillNo Varchar(20),BkDiscPerc Money,BkDiscPercAmt Money,BkRateDiff Money,BkClaimLess Money,BkBankCommission Money,BkAddInterestPerc Money,BkAddInterestPercAmt Money,BkBillPaidAmt Money,BkStatus Varchar(7),BkDisBal Money,BkRDBal Money,BkGRBal Money,BkIntBal Money,DisputeRemark Varchar(50),BkTDSAmt Money)
Create Table TamCOMP.dbo.RECEIVED_RETURN_GOODS_DETAIL (BkSrNo Varchar(6) Primary Key,BkAccCode Varchar(7) Foreign Key References ACCOUNT_MASTER(AccCode),BkGRAmt Money,BkGRDate DateTime,BkRemark Varchar(255),BkCurDate DateTime,BkCurTime DateTime,BkUName Varchar(255),TransName Varchar(35),TransLRNo Varchar(15),TransLRCase Varchar(30),TransLRDate DateTime,TransFromStation Varchar(35),Haste Varchar(50),CreditNoteNo Varchar(50),SaleRtnType Varchar(7),GSTSupplyType Varchar(15),RefBillNo Varchar(25),RefBillDate DateTime,SMAccCode Varchar(7))
Create Table TamCOMP.dbo.RECEIVED_RETURN_GOODS_ADDLESS_DETAIL (BkSrNo Varchar(6) Foreign Key References RECEIVED_RETURN_GOODS_DETAIL(BkSrNo),BkBillNo Varchar(20),BkBillGRAmt Money,BkStatus Varchar(7),BkDescription Varchar(50),ISrNo Numeric(6),AdjGST Money)
Create Table TamCOMP.dbo.RECEIVED_RETURN_GOODS_ITEM_DETAIL (BkSrNo Varchar(6) Foreign Key References RECEIVED_RETURN_GOODS_DETAIL(BkSrNo),BkItemName Varchar(30),BkCut Money,BkPcs Numeric(6),BkMts Money,BkPer Varchar(1),BkRate Money,BkBillGRAmt Money,DesignScreen Varchar(30),ISrNo Numeric(6),PurSrNo Varchar(15),PurISrNo Numeric(6),PurRate Money,PurAmt Money,SubScreen Varchar(30),Fold Money,WOFoldMts Money,Barcode Varchar(13), SaleMRP Money, SaleDiscPerc Money,HSNCode Varchar(10), IGSTPerc Money, IGSTAmt Money, CGSTPerc Money, CGSTAmt Money, SGSTPerc Money, SGSTAmt Money, UTGSTPerc Money, UTGSTAmt Money, CESSPerc Money, CESSAmt Money,ItemDiscPerc Money, ItemDiscAmt Money, ItemAddPerc Money, ItemAddAmt Money,AddLess1Name Varchar(35),AddLess1Perc Money,AddLess1Amt Money,AddLess2Name Varchar(35),AddLess2Perc Money,AddLess2Amt Money)
Create Table TamCOMP.dbo.RECEIVED_RETURN_GOODS_TAKA_DETAIL (BkSrNo Varchar(6) Foreign Key References RECEIVED_RETURN_GOODS_DETAIL(BkSrNo),ItemSrNo Numeric(3),ISrNo Numeric(5),ItemSet Money,ItemQty Numeric(5),ItemTotal Money,ShadeNo Varchar(15))
Create Table TamCOMP.dbo.GREY_PURCHASE_RETURN_GOODS_DETAIL (BkSrNo Varchar(6) Primary Key,BkAccCode Varchar(7) Foreign Key References ACCOUNT_MASTER(AccCode),BkGRAmt Money,BkGRDate DateTime,BkRemark Varchar(255),BkCurDate DateTime,BkCurTime DateTime,BkUName Varchar(255),TransName Varchar(35),TransLRNo Varchar(15),TransLRCase Varchar(30),TransLRDate DateTime,TransFromStation Varchar(35),PurRtnType Varchar(7),RevCharge Varchar(3),GSTSupplyType Varchar(15),RefBillNo Varchar(25),RefBillDate DateTime,EntType VarChar(25))
Create Table TamCOMP.dbo.GREY_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL (BkSrNo Varchar(6) Foreign Key References GREY_PURCHASE_RETURN_GOODS_DETAIL(BkSrNo),BkBillNo Varchar(20),BkItemName Varchar(30),BkCut Money,BkPcs Numeric(6),BkMts Money,BkPer Varchar(1),BkRate Money,BkBillGRAmt Money,BkStatus Varchar(7),ISrNo Numeric(6),PurSrNo Varchar(15),PurISrNo Numeric(6),HSNCode Varchar(10), IGSTPerc Money, IGSTAmt Money, CGSTPerc Money, CGSTAmt Money, SGSTPerc Money, SGSTAmt Money, UTGSTPerc Money, UTGSTAmt Money, CESSPerc Money, CESSAmt Money,ItemDiscPerc Money, ItemDiscAmt Money, ItemAddPerc Money, ItemAddAmt Money,Denier Varchar(25),Grade Varchar(25))
Create Table TamCOMP.dbo.GREY_PURCHASE_RETURN_GOODS_TAKA_DETAIL (BkSrNo Varchar(6) Foreign Key References GREY_PURCHASE_RETURN_GOODS_DETAIL(BkSrNo),ItemSrNo Numeric(3),TakaSrNo Numeric(6),GreyMts Money,RecdMts Money, GreyTP1 Money,RecdTP1 Money,GreyTP2 Money,RecdTP2 Money,GreyTP3 Money,RecdTP3 Money,GreyTP4 Money,RecdTP4 Money,GreyTP5 Money,RecdTP5 Money,ShortPerc Money,CurTime DateTime)
Create Table TamCOMP.dbo.GREY_PURCHASE_RETURN_GOODS_YARN_TAKA_DETAIL (BkSrNo Varchar(6) Foreign Key References GREY_PURCHASE_RETURN_GOODS_DETAIL(BkSrNo),ItemSrNo Numeric(6),TakaSrNo Numeric(6),YCompCode Varchar(7),YModule Varchar(25),YSrNo Varchar(15),YISrNo Numeric(6),YITSrNo Numeric(6),CartoonNo Varchar(50),Cone Numeric(6),NetWeight Money,ShadeColor Varchar(50))
Create Table TamCOMP.dbo.FINISHED_PURCHASE_RETURN_GOODS_DETAIL (BkSrNo Varchar(6) Primary Key,BkAccCode Varchar(7) Foreign Key References ACCOUNT_MASTER(AccCode),BkGRAmt Money,BkGRDate DateTime,BkRemark Varchar(255),BkCurDate DateTime,BkCurTime DateTime,TransName Varchar(35),TransLRNo Varchar(15),TransLRCase Varchar(30),TransLRDate DateTime,TransFromStation Varchar(35),DebitNoteNo Varchar(255),PurRtnType Varchar(7),RevCharge Varchar(3),GSTSupplyType Varchar(15),RefBillNo Varchar(25),RefBillDate DateTime, Haste Varchar(50), Remark2 Varchar(255))
Create Table TamCOMP.dbo.FINISHED_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL (BkSrNo Varchar(6) Foreign Key References FINISHED_PURCHASE_RETURN_GOODS_DETAIL(BkSrNo),BkBillNo Varchar(20),BkItemName Varchar(30),BkCut Money,BkPcs Numeric(6),BkMts Money,BkPer Varchar(1),BkRate Money,BkBillGRAmt Money,BkStatus Varchar(7),ItemRangeDesp Varchar(30),ISrNo Numeric(6),BkItemAmt Money,IFinSrNo Varchar(15),IFinISrNo Numeric(6),IFinType Varchar(20),Barcode Varchar(13),HSNCode Varchar(10), IGSTPerc Money, IGSTAmt Money, CGSTPerc Money, CGSTAmt Money, SGSTPerc Money, SGSTAmt Money, UTGSTPerc Money, UTGSTAmt Money, CESSPerc Money, CESSAmt Money,ItemDiscPerc Money, ItemDiscAmt Money, ItemAddPerc Money, ItemAddAmt Money,AdjGST Money, AddLess1Name Varchar(35), AddLess1Perc Money, AddLess1Amt Money, AddLess2Name Varchar(35), AddLess2Perc Money, AddLess2Amt Money)
Create Table TamCOMP.dbo.GREY_SEND_TO_MILL (SrNo Varchar(6) Primary Key,MillChallanNo Varchar(15),Marka Varchar(15),BatchNo Varchar(6),CurDate DateTime,ChallanDate DateTime,MillCode Varchar(7) Foreign Key References ACCOUNT_MASTER(AccCode),ItemName Varchar(30),ItemTaka Numeric(6),ItemMts Money,LotNo Varchar(15),Remark Varchar(50),UName Varchar(255),ChallanStatus Varchar(1),Program Varchar(255),VouTypeName Varchar(25),ExpFinishedPcs Numeric(6),ExpFinishedItem Varchar(30),PrintingMaster Varchar(35),ItemCut Money,ItemShort Money,IsExpItem Varchar(3),TransName Varchar(35),TransLRNo Varchar(15),WevTkSrNo Numeric(6),GSTSupplyType Varchar(15),EntType Varchar(25),Denier Varchar(25))
Create Table TamCOMP.dbo.GREY_SEND_TO_MILL_TAKA_DETAIL (SrNo Varchar(6) Foreign Key References GREY_SEND_TO_MILL(SrNo),PurSrNo Varchar(15),ItemName Varchar(30),TakaSrNo Numeric(3),TakaMts Money,TakaTP1 Money,TakaTP2 Money,TakaTP3 Money,TakaTP4 Money,TakaTP5 Money,TakaStatus Varchar(1),ExcessMts Money,PurTakaSr Money,RtnSrNo Varchar(6),PurISrNo Money,RFSrNo Varchar(6),RFISrNo Numeric(3),RFTakaSrNo Varchar(6),Marka Varchar(15),SaleOrdNo Varchar(10),WevTkSrNo Numeric(6))
Create Table TamCOMP.dbo.GREY_SEND_TO_MILL_YARN_TAKA_DETAIL (SrNo Varchar(6),TakaSrNo Numeric(6),YCompCode Varchar(7),YModule Varchar(25),YSrNo Varchar(15),YISrNo Numeric(6),YITSrNo Numeric(6),CartoonNo Varchar(50),Cone Numeric(6),NetWeight Money,ShadeColor Varchar(50))
Create Table TamCOMP.dbo.FINISHED_RECEIVED_FROM_MILL (FRSrNo Varchar(6) Primary Key,CurDate DateTime,MillCode Varchar(7) Foreign Key References ACCOUNT_MASTER(AccCode),GPRecdDate DateTime,GPNo Varchar(20),GrossAmt Money,NetProcessAmt Money,GPStatus Varchar(7),Remark Varchar(50),GSTSupplyType Varchar(15),EntType Varchar(25),TransName Varchar(35),TransLRNo Varchar(15))
Create Table TamCOMP.dbo.FINISHED_RECEIVED_FROM_MILL_CHALLAN_DETAIL (FRSrNo Varchar(6) Foreign Key References FINISHED_RECEIVED_FROM_MILL (FRSrNo),FRCSrNo Numeric(3),MillChallanNo Varchar(15),MillSendSrNo Varchar(6),LotNo Varchar(15),GreyTaka Numeric(6),GreyMts Money,FinishedMts Money,ShortMts Money,ShortPerc Money,ProcessRate Money,ProcessAmt Money,ChallanStatus Varchar(7),ExpFinishedPcs Numeric(6),ExpFinishedItem Varchar(30),RatePer Varchar(1),YarnLotNo Varchar(25),Denier Varchar(25),Cone Numeric(6),YCompCode Varchar(7),YModule Varchar(25),YSrNo Varchar(15),YISrNo Numeric(6))
Create Table TamCOMP.dbo.FINISHED_RECEIVED_FROM_MILL_TAKA_DETAIL (FRSrNo Varchar(6) Foreign Key References FINISHED_RECEIVED_FROM_MILL (FRSrNo),FRCSrNo Numeric(3),TakaSrNo Numeric(6),GreyMts Money,RecdMts Money, GreyTP1 Money,RecdTP1 Money,GreyTP2 Money,RecdTP2 Money,GreyTP3 Money,RecdTP3 Money,GreyTP4 Money,RecdTP4 Money,GreyTP5 Money,RecdTP5 Money,ShortPerc Money,CurTime DateTime,WevTkSrNo Numeric(6))
Create Table TamCOMP.dbo.FINISHED_RECEIVED_FROM_MILL_YARN_TAKA_DETAIL (FRSrNo Varchar(6),FRCSrNo Numeric(3),TakaSrNo Numeric(3),CartoonNo Varchar(50),Cone Numeric(6),NetWeight Money,ShadeColor Varchar(50))
Create Table TamCOMP.dbo.GP_RECEIVED_FROM_MILL (FRSrNo Varchar(6) Primary Key,CurDate DateTime,MillCode Varchar(7) Foreign Key References ACCOUNT_MASTER(AccCode),GPRecdDate DateTime,GPNo Varchar(20),GrossAmt Money,TDSPerc Money,TDSAmt Money,NetProcessAmt Money,GPStatus Varchar(7),Remark Varchar(50),TDSAcc Varchar(7),IncomeTaxPerc Money,IncomeTaxAmt Money,SurchargePerc Money,SurchargeAmt Money,EduCessPerc Money,EduCessAmt Money,TDSType Varchar(35),TDSDate DateTime,RevCharge Varchar(3),GSTSupplyType Varchar(15),RCMSrNo Varchar(6),EntType Varchar(25))
Create Table TamCOMP.dbo.GP_RECEIVED_FROM_MILL_CHALLAN_DETAIL (FRSrNo Varchar(6) Foreign Key References GP_RECEIVED_FROM_MILL (FRSrNo),FRCSrNo Numeric(3),MillChallanNo Varchar(15),MillSendSrNo Varchar(6),ChallanNo Varchar(15),GreyTaka Numeric(6),GreyMts Money,FinishedMts Money,ShortMts Money,ShortPerc Money,ProcessRate Money,ProcessAmt Money,FRChSRNo Varchar(6),LotNo Varchar(15),TItemName Varchar(30),RatePer Varchar(1),HSNCode Varchar(10), IGSTPerc Money, IGSTAmt Money, CGSTPerc Money, CGSTAmt Money, SGSTPerc Money, SGSTAmt Money, UTGSTPerc Money, UTGSTAmt Money, CESSPerc Money, CESSAmt Money,ItemDiscPerc Money, ItemDiscAmt Money, ItemAddPerc Money, ItemAddAmt Money, AddLess1Name Varchar(35), AddLess1Perc Money, AddLess1Amt Money, AddLess2Name Varchar(35), AddLess2Perc Money, AddLess2Amt Money,YarnLotNo Varchar(25),Denier Varchar(25),Cone Numeric(6))
Create Table TamCOMP.dbo.GENERAL_PURCHASE (SrNo Varchar(6) Primary Key,CurDate DateTime,BillNo Varchar(20),BillDate DateTime,ChallanNo Varchar(15),ChallanRecdDate DateTime,SuppCode Varchar(7) Foreign Key References ACCOUNT_MASTER(AccCode),GrossAmt Money,NetAmt Money,BillStatus Varchar(7),Remark Varchar(255),PLAcc Varchar(7),TDSAcc Varchar(7),IncomeTaxPerc Money,IncomeTaxAmt Money,SurchargePerc Money,SurchargeAmt Money,EduCessPerc Money,EduCessAmt Money,TDSPerc Money,TDSAmt Money,TDSType Varchar(35),TDSDate DateTime,BrokSrNo Varchar(10),RevCharge Varchar(3),GSTSupplyType Varchar(15),RCMSrNo Varchar(6),GSTITC Varchar(15),EntryOn Varchar(25),CommOn Varchar(25),CommPerc Money,CommPayOn Varchar(25))
Create Table TamCOMP.dbo.GENERAL_PURCHASE_ITEM_DETAIL (SrNo Varchar(6) Foreign Key References GENERAL_PURCHASE(SrNo),ItemSrNo Numeric(3),ItemName Varchar(30),ItemPcs Numeric(6),ItemMts Money,ItemPer Varchar(1),ItemRate Money,ItemAmount Money,HSNCode Varchar(10), IGSTPerc Money, IGSTAmt Money, CGSTPerc Money, CGSTAmt Money, SGSTPerc Money, SGSTAmt Money, UTGSTPerc Money, UTGSTAmt Money, CESSPerc Money, CESSAmt Money,ItemDiscPerc Money, ItemDiscAmt Money, ItemAddPerc Money, ItemAddAmt Money,CommBillNo Varchar(20),CommPartyCode Varchar(7),CommBillCompCode Varchar(7))
Create Table TamCOMP.dbo.OPENING_FINISHED_PURCHASE (SrNo Varchar(6) Primary Key,BillNo Varchar(20),BillDate DateTime,ChallanNo Varchar(15),ChallanRecdDate DateTime,WeaverCode Varchar(7) Foreign Key References ACCOUNT_MASTER(AccCode),WeaverAgentCode Varchar(7) Foreign Key References AGENT_MASTER(AgentCode),NetAmt Money,UName Varchar(255),BillStatus Varchar(7),GRAmt Money,ChqAmt Money,CashAmt Money,AddLess Money,GSTSupplyType Varchar(15),GSTAmt Money,RevCharge Varchar(3))
Create Table TamCOMP.dbo.OPENING_GENERAL_PURCHASE (SrNo Varchar(6) Primary Key,SuppCode Varchar(7) Foreign Key References ACCOUNT_MASTER(AccCode),BillDate DateTime,BillNo Varchar(20),NetAmt Money,BillStatus Varchar(7),UName Varchar(255),GRAmt Money,ChqAmt Money,CashAmt Money,AddLess Money,PLAcc Varchar(7),TDSAmt Money,GSTSupplyType Varchar(15),GSTAmt Money,RevCharge Varchar(3), GSTITC Varchar(15))
Create Table TamCOMP.dbo.OPENING_BILL_DETAIL (BillNo Varchar(10) Primary Key,BillDate DateTime,VouNo Varchar(8),CustCode Varchar(7) Foreign Key References ACCOUNT_MASTER(AccCode),AgentCode Varchar(7) Foreign Key References AGENT_MASTER(AgentCode),Haste Varchar(50),NetAmt Money,TransName Varchar(35),TransLRNo Varchar(60),TransLRCase Varchar(30),TransLRDate DateTime,TransDespStation Varchar(35),UName Varchar(255),BillStatus Varchar(7),GRAmt Money,ChqAmt Money,CashAmt Money,AddLess Money,ItemName Varchar(30),ScreenName Varchar(30),TotPcs Numeric(6),SaleType Varchar(7),PaymentWithinDays Numeric(3),Remark Varchar(255),ManualChallan Varchar(50),ManualOrderNo Varchar(50),BuyerDetail Varchar(700),GSTSupplyType Varchar(15),Muddat Varchar(3),GSTAmt Money,SMAccCode Varchar(7))
Create Table TamCOMP.dbo.OPENING_GREY_SEND_TO_MILL (SrNo Varchar(6) Primary Key,MillChallanNo Varchar(15),Marka Varchar(15),BatchNo Varchar(6),ChallanDate DateTime,MillCode Varchar(7) Foreign Key References ACCOUNT_MASTER(AccCode),ItemName Varchar(30),ItemTaka Numeric(6),ItemMts Money,LotNo Varchar(15),UName Varchar(255),ChallanStatus Varchar(1),Program Varchar(255),SuppCode Varchar(7),ItemRate Money,BillNo Varchar(20),ExpFinishedPcs Numeric(6),ExpFinishedItem Varchar(30),PrintingMaster Varchar(35),ItemCut Money,ItemShort Money,Marka2 Varchar(25),WevTkSrNo Numeric(6),TransName Varchar(35),TransLRNo Varchar(15),SaleOrdNo Varchar(10),GSTSupplyType Varchar(15),VouTypeName Varchar(25),EntType Varchar(25),Denier Varchar(25))
Create Table TamCOMP.dbo.OPENING_GREY_SEND_TO_MILL_TAKA_DETAIL (SrNo Varchar(6) Foreign Key References OPENING_GREY_SEND_TO_MILL(SrNo),TakaSrNo Numeric(3),TakaMts Money,TakaTP1 Money,TakaTP2 Money,TakaTP3 Money,TakaTP4 Money,TakaTP5 Money,TakaStatus Varchar(1),Marka Varchar(15),WevTkSrNo Numeric(6))
Create Table TamCOMP.dbo.OPENING_GREY_SEND_TO_MILL_YARN_TAKA_DETAIL (SrNo Varchar(6),TakaSrNo Numeric(6),YCompCode Varchar(7),YModule Varchar(25),YSrNo Varchar(15),YISrNo Numeric(6),YITSrNo Numeric(6),CartoonNo Varchar(50),Cone Numeric(6),NetWeight Money,ShadeColor Varchar(50))
Create Table TamCOMP.dbo.OPENING_MILL_GP (SrNo Varchar(6) Primary Key,GPNo Varchar(20),GPDate DateTime,MillCode Varchar(7) Foreign Key References ACCOUNT_MASTER(AccCode),NetAmt Money,UName Varchar(255),GPStatus Varchar(7),GRAmt Money,ChqAmt Money,CashAmt Money,AddLess Money,TDSAmt Money,GSTSupplyType Varchar(15),GSTAmt Money,RevCharge Varchar(3),EntType Varchar(25))
Create Table TamCOMP.dbo.OPENING_GREY_PURCHASE (SrNo Varchar(6) Primary Key,BillNo Varchar(20),BillDate DateTime,ChallanNo Varchar(15),ChallanRecdDate DateTime,WeaverCode Varchar(7) Foreign Key References ACCOUNT_MASTER(AccCode),WeaverAgentCode Varchar(7) Foreign Key References AGENT_MASTER(AgentCode),NetAmt Money,UName Varchar(255),BillStatus Varchar(7),GRAmt Money,ChqAmt Money,CashAmt Money,AddLess Money,TransName Varchar(35),TransLRNo Varchar(15),TransLRDate DateTime,TransCase Varchar(30),TransFrom Varchar(35),GSTSupplyType Varchar(15),GSTAmt Money,RevCharge Varchar(3), EntType Varchar(25), Commission Varchar(3), CommOn Varchar(25), CommPerc Money, CommAmt Money)
Create Table TamCOMP.dbo.OPENING_SEND_TO_JOB (SrNo Varchar(6) Primary Key,CurDate DateTime,ChallanNo Varchar(15),ChallanDate DateTime,JobCode Varchar(7) Foreign Key References ACCOUNT_MASTER(AccCode),BillStatus Varchar(7),JobType Varchar(35),AgentCode Varchar(7) Foreign Key References AGENT_MASTER(AgentCode),CheckedBy Varchar(25),GSTSupplyType Varchar(15),EntType Varchar(25))
Create Table TamCOMP.dbo.OPENING_SEND_TO_JOB_ITEM_DETAIL (SrNo Varchar(6) Foreign Key References OPENING_SEND_TO_JOB(SrNo),ItemSrNo Numeric(3),ItemName Varchar(30),ItemProgram Varchar(30),ItemPcs Numeric(6),ItemMts Money,ItemStatus Varchar(1),ItemRate Money,ItemCut Money,LotNo Numeric(6), JobQuality Varchar(35),ItemValue Money, JobWorkMts Money, RecSrNo Varchar(6),RecISrNo Numeric(6),ItemRangeDesp Varchar(30),StockType Varchar(35),ConSrNo Varchar(6),SaleOrdSrNo Varchar(15),SaleOrdISrNo Numeric(6), ItemPer Varchar(1),YarnLotNo Varchar(25),Denier Varchar(25),Cone Numeric(6))
Create Table TamCOMP.dbo.OPENING_SEND_TO_JOB_TAKA_DETAIL (SrNo Varchar(6) Foreign Key References OPENING_SEND_TO_JOB(SrNo),PurSrNo Varchar(15),ItemName Varchar(30),TakaSrNo Numeric(3),TakaMts Money,TakaTP1 Money,TakaTP2 Money,TakaTP3 Money,TakaTP4 Money,TakaTP5 Money,TakaTP6 Money,TakaTP7 Money,TakaTP8 Money,TakaTP9 Money,TakaTP10 Money,TakaStatus Varchar(1),ExcessMts Money,PurTakaSr Money,RtnSrNo Varchar(6),PurISrNo Money,RFSrNo Varchar(6),RFISrNo Numeric(3),RFTakaSrNo Varchar(6),Marka Varchar(15),ItemSrNo Numeric(3))
Create Table TamCOMP.dbo.OPENING_SEND_TO_JOB_YARN_TAKA_DETAIL (SrNo Varchar(6),ItemSrNo Numeric(6),TakaSrNo Numeric(6),YCompCode Varchar(7),YModule Varchar(25),YSrNo Varchar(15),YISrNo Numeric(6),YITSrNo Numeric(6),CartoonNo Varchar(50),Cone Numeric(6),NetWeight Money,ShadeColor Varchar(50))
Create Table TamCOMP.dbo.OPENING_SEND_TO_JOB_FINISHED_TAKA_DETAIL (SrNo Varchar(6) Foreign Key References OPENING_SEND_TO_JOB(SrNo),ItemSrNo Numeric(3),TakaSrNo Numeric(3),TakaMts Money)
Create Table TamCOMP.dbo.OPENING_FINISHED_RECEIVED_FROM_MILL (FRSrNo Varchar(6) Primary Key,CurDate DateTime,MillCode Varchar(7) Foreign Key References ACCOUNT_MASTER(AccCode),GPRecdDate DateTime,GPNo Varchar(20),GrossAmt Money,GPStatus Varchar(7),UName Varchar(255),EntType Varchar(25),TransName Varchar(35),TransLRNo Varchar(15))
Create Table TamCOMP.dbo.OPENING_FINISHED_RECEIVED_FROM_MILL_CHALLAN_DETAIL (FRSrNo Varchar(6) Foreign Key References OPENING_FINISHED_RECEIVED_FROM_MILL (FRSrNo),FRCSrNo Numeric(3),LotNo Varchar(15),ItemName Varchar(30),PurRate Money,ProRate Money,MillSendSrNo Varchar(6),MillChallanNo Varchar(15),GreyTaka Numeric(6),GreyMts Money,FinishedMts Money,ShortMts Money,ShortPerc Money,ProcessRate Money,ProcessAmt Money,ChallanStatus Varchar(7),RatePer Varchar(1),YarnLotNo Varchar(25),Denier Varchar(25),Cone Numeric(6),YCompCode Varchar(7),YModule Varchar(25),YSrNo Varchar(15),YISrNo Numeric(6))
Create Table TamCOMP.dbo.OPENING_FINISHED_RECEIVED_FROM_MILL_YARN_TAKA_DETAIL (FRSrNo Varchar(6),FRCSrNo Numeric(3),TakaSrNo Numeric(3),CartoonNo Varchar(50),Cone Numeric(6),NetWeight Money,ShadeColor Varchar(50))
Create Table TamCOMP.dbo.OPENING_YARN_RECEIVED_FROM_MILL (FRSrNo Varchar(15) Primary Key,CurDate DateTime,MillCode Varchar(7) Foreign Key References ACCOUNT_MASTER(AccCode),GPRecdDate DateTime,GPNo Varchar(20),GrossAmt Money,GPStatus Varchar(7),UName Varchar(255),EntType Varchar(25))
Create Table TamCOMP.dbo.OPENING_YARN_RECEIVED_FROM_MILL_CHALLAN_DETAIL (FRSrNo Varchar(15) Foreign Key References OPENING_YARN_RECEIVED_FROM_MILL (FRSrNo),FRCSrNo Numeric(3),LotNo Varchar(15),ItemName Varchar(30),PurRate Money,ProRate Money,MillSendSrNo Varchar(6),MillChallanNo Varchar(15),GreyTaka Numeric(6),GreyMts Money,FinishedMts Money,ShortMts Money,ShortPerc Money,ProcessRate Money,ProcessAmt Money,ChallanStatus Varchar(7),RatePer Varchar(1),YarnLotNo Varchar(25),Denier Varchar(25),Cone Numeric(6),YCompCode Varchar(7),YModule Varchar(25),YSrNo Varchar(15),YISrNo Numeric(6))
Create Table TamCOMP.dbo.OPENING_YARN_RECEIVED_FROM_MILL_YARN_TAKA_DETAIL (FRSrNo Varchar(15),FRCSrNo Numeric(3),TakaSrNo Numeric(3),CartoonNo Varchar(50),Cone Numeric(6),NetWeight Money,ShadeColor Varchar(50))
Create Table TamCOMP.dbo.ITEM_FINALIZATION (SrNo Varchar(6) Primary Key,CurDate DateTime,ReadyDate DateTime,ItemName Varchar(30),ItemPcs Numeric(6),ItemMts Money,TotalCosting Money,PerPcsCosting Money,TopChNo Varchar(8),TopLotNo Varchar(15),ReqTopMts Money,FinTopMts Money,TopFents Money,TopGreyMts Money,TopFRSrNo Varchar(6),TopShortPerc Money,TopCosting Money,MiddleChNo Varchar(8),MiddleLotNo Varchar(15),ReqMiddleMts Money,FinMiddleMts Money,MiddleFents Money,MiddleGreyMts Money,MiddleFRSrNo Varchar(6),MiddleShortPerc Money,MiddleCosting Money,BottomChNo Varchar(8),BottomLotNo Varchar(15),ReqBottomMts Money,FinBottomMts Money,BottomFents Money,BottomGreyMts Money,BottomFRSrNo Varchar(6),BottomShortPerc Money,BottomCosting Money,OtherChNo Varchar(8),OtherLotNo Varchar(15),ReqOtherMts Money,FinOtherMts Money,OtherFents Money,OtherGreyMts Money,OtherFRSrNo Varchar(6),OtherShortPerc Money,OtherCosting Money,UName Varchar(255),ScreenName Varchar(30),IFCut Money,SecItem Varchar(30),SecCut Money,SecPcs Numeric(6),SecMts Money,TopISrNo Numeric(6),MiddleISrNo Numeric(6),BottomISrNo Numeric(6),OtherISrNo Numeric(6),TopSaleOrdNo Varchar(10),MiddleSaleOrdNo Varchar(10),BottomSaleOrdNo Varchar(10),OtherSaleOrdNo Varchar(10))
Create Table TamCOMP.dbo.ITEM_FINALIZATION_TAKA_DETAIL (SrNo Varchar(6) Foreign Key References ITEM_FINALIZATION(SrNo),ISrNo Numeric(3),TakaSrNo Numeric(6),GreyMts Money,RecdMts Money, GreyTP1 Money,RecdTP1 Money,GreyTP2 Money,RecdTP2 Money,GreyTP3 Money,RecdTP3 Money,GreyTP4 Money,RecdTP4 Money,GreyTP5 Money,RecdTP5 Money,ShortPerc Money,CurTime DateTime,FRSrNo Varchar(6),FRCSrNo Numeric(3))
Create Table TamCOMP.dbo.JOURNAL_VOUCHER (SrNo Varchar(6),CrDrSrNo Numeric(3),JVDate DateTime,DebitCode Varchar(7),CreditCode Varchar(7),Discription Varchar(255),VouNo Varchar(6),Amount Money,Uname Varchar(255))
Create Table TamCOMP.dbo.SEND_TO_JOB (SrNo Varchar(6) Primary Key,CurDate DateTime,ChallanNo Varchar(15),ChallanDate DateTime,JobCode Varchar(7) Foreign Key References ACCOUNT_MASTER(AccCode),BillStatus Varchar(7),TransName Varchar(35),TransLRNo Varchar(15),TransLRDate DateTime,TransCase Varchar(30),TransDespStation Varchar(35),Remark Varchar(700),JobType Varchar(35),AgentCode Varchar(7) Foreign Key References AGENT_MASTER(AgentCode),Remark2 Varchar(700),CheckedBy Varchar(25),GSTSupplyType Varchar(15),EntType Varchar(25))
Create Table TamCOMP.dbo.SEND_TO_JOB_ITEM_DETAIL (SrNo Varchar(6) Foreign Key References SEND_TO_JOB(SrNo),ItemSrNo Numeric(3),ItemName Varchar(30),ItemProgram Varchar(30),ItemPcs Numeric(6),ItemMts Money,ItemStatus Varchar(1),ItemRate Money,ItemCut Money,LotNo Numeric(6), JobQuality Varchar(35),ItemValue Money, JobWorkMts Money, RecSrNo Varchar(6),RecISrNo Numeric(6),ItemRangeDesp Varchar(30),IFinSrNo Varchar(15),IFinISrNo Numeric(6),IFinType Varchar(20),StockType Varchar(35),ConSrNo Varchar(6),SaleOrdSrNo Varchar(15),SaleOrdISrNo Numeric(6), ItemPer Varchar(1),YarnLotNo Varchar(25),Denier Varchar(25),Cone Numeric(6))
Create Table TamCOMP.dbo.SEND_TO_JOB_TAKA_DETAIL (SrNo Varchar(6) Foreign Key References SEND_TO_JOB(SrNo),PurSrNo Varchar(15),ItemName Varchar(30),TakaSrNo Numeric(3),TakaMts Money,TakaTP1 Money,TakaTP2 Money,TakaTP3 Money,TakaTP4 Money,TakaTP5 Money,TakaTP6 Money,TakaTP7 Money,TakaTP8 Money,TakaTP9 Money,TakaTP10 Money,TakaStatus Varchar(1),ExcessMts Money,PurTakaSr Money,RtnSrNo Varchar(6),PurISrNo Money,RFSrNo Varchar(6),RFISrNo Numeric(3),RFTakaSrNo Varchar(6),Marka Varchar(15),ItemSrNo Numeric(3))
Create Table TamCOMP.dbo.SEND_TO_JOB_FINISHED_TAKA_DETAIL (SrNo Varchar(6) Foreign Key References SEND_TO_JOB(SrNo),ItemSrNo Numeric(3),TakaSrNo Numeric(3),TakaMts Money)
Create Table TamCOMP.dbo.SEND_TO_JOB_YARN_TAKA_DETAIL (SrNo Varchar(6),ItemSrNo Numeric(6),TakaSrNo Numeric(6),YCompCode Varchar(7),YModule Varchar(25),YSrNo Varchar(15),YISrNo Numeric(6),YITSrNo Numeric(6),CartoonNo Varchar(50),Cone Numeric(6),NetWeight Money,ShadeColor Varchar(50))
Create Table TamCOMP.dbo.STOCK_TRANSFER_SCREEN_TO_SCREEN (SrNo Money,ItemIn Varchar(255),ItemOut Varchar(255),Mts Money,Pcs Numeric(6),TrfDate DateTime, Costing Money, CostingPer Varchar(1),RSSaleType Varchar(15),RSSaleSrNo Varchar(6),RSSaleISrNo Numeric(6))
Create Table TamCOMP.dbo.CHALLAN_RECEIVED_FROM_JOB (SrNo Varchar(6) Primary Key,CurDate DateTime,JobCode Varchar(7) Foreign Key References ACCOUNT_MASTER(AccCode),ChallanDate DateTime,ChallanNo Varchar(15),GrossAmt Money,ChallanStatus Varchar(7),UName Varchar(255),Remark Varchar(50),JobType Varchar(35),ReadyToSale Varchar(1),AgentCode Varchar(7) Foreign Key References AGENT_MASTER(AgentCode),BillType Varchar(7),GSTSupplyType Varchar(15),EntType Varchar(25))
Create Table TamCOMP.dbo.CHALLAN_RECEIVED_FROM_JOB_CHALLAN_DETAIL (SrNo Varchar(6) Foreign Key References CHALLAN_RECEIVED_FROM_JOB(SrNo),LotNo Numeric(6),ItemName Varchar(30),JobSendChNo Varchar(15),JobSendSrNo Varchar(15),JobSendItmSrNo Numeric(3),ItemPcs Numeric(6),ItemMts Money,SendChStatus Varchar(1),ItemPer Varchar(1),ItemRate Money,ItemAmt Money,WastePcs Numeric(6),WasteMts Money,RtnPcs Numeric(6),RtnMts Money,Screen Varchar(30),StockType Varchar(35),JobQuality Varchar(35),ItemSrNo Numeric(6),OrdSrNo Varchar(8),OrdISrNo Numeric(3),WasteRate Money,WasteAmt Money,ConSrNo Varchar(6),ConISrNo Numeric(6),WasIsShrt Varchar(3),ReadyToSale Varchar(1),Cut Money,Short Money,Line Money,RangeDesp Varchar(30),UsedWeight Money, Shortage Money, SendWeight Money,YCompCode Varchar(7),YModule Varchar(25),YSrNo Varchar(15),YISrNo Numeric(6))
Create Table TamCOMP.dbo.CHALLAN_RECEIVED_FROM_JOB_TAKA_DETAIL (SrNo Varchar(6) Foreign Key References CHALLAN_RECEIVED_FROM_JOB(SrNo),ItemSrNo Numeric(3),TakaSrNo Numeric(6),GreyMts Money,RecdMts Money, GreyTP1 Money,RecdTP1 Money,GreyTP2 Money,RecdTP2 Money,GreyTP3 Money,RecdTP3 Money,GreyTP4 Money,RecdTP4 Money,GreyTP5 Money,RecdTP5 Money, GreyTP6 Money,RecdTP6 Money,GreyTP7 Money,RecdTP7 Money,GreyTP8 Money,RecdTP8 Money,GreyTP9 Money,RecdTP9 Money,GreyTP10 Money,RecdTP10 Money,ShortPerc Money,CurTime DateTime)
Create Table TamCOMP.dbo.CHALLAN_RECEIVED_FROM_JOB_YARN_TAKA_DETAIL (SrNo Varchar(6) Foreign Key References CHALLAN_RECEIVED_FROM_JOB(SrNo),ItemSrNo Numeric(3),YTakaSrNo Numeric(6),WeaverSrNo Varchar(6),MtsKGs Money, UsedWeight Money,WeightPer100Mts Money, MtsPer1KG Money)
Create Table TamCOMP.dbo.CHALLAN_RECEIVED_FROM_JOB_FINISHED_TAKA_DETAIL (SrNo Varchar(6) Foreign Key References CHALLAN_RECEIVED_FROM_JOB(SrNo),ItemSrNo Numeric(3),TakaSrNo Numeric(3),TakaMts Money)
Create Table TamCOMP.dbo.CHALLAN_RECEIVED_FROM_JOB_YARN_CONSUMPTION_DETAIL (SrNo Varchar(6) Foreign Key References CHALLAN_RECEIVED_FROM_JOB(SrNo),ItemSrNo Numeric(3),ConISrNo Numeric(3),UsedPerc Money,UsedWeight Money, ShortPerc Money,ShortWeight Money, YCompCode Varchar(7),YModule Varchar(25),YSrNo Varchar(15),YISrNo Numeric(6), WasteWeight Money, ReturnWeight Money,JobSendChNo Varchar(15),JobSendSrNo Varchar(15),JobSendItmSrNo Numeric(3))
Create Table TamCOMP.dbo.OPENING_CHALLAN_RECEIVED_FROM_JOB (SrNo Varchar(6) Primary Key,CurDate DateTime,JobCode Varchar(7) Foreign Key References ACCOUNT_MASTER(AccCode),ChallanDate DateTime,ChallanNo Varchar(15),GrossAmt Money,ChallanStatus Varchar(7),UName Varchar(255),Remark Varchar(50),JobType Varchar(35),ReadyToSale Varchar(1),AgentCode Varchar(7) Foreign Key References AGENT_MASTER(AgentCode),BillType Varchar(7),EntType Varchar(25))
Create Table TamCOMP.dbo.OPENING_CHALLAN_RECEIVED_FROM_JOB_CHALLAN_DETAIL (SrNo Varchar(6) Foreign Key References OPENING_CHALLAN_RECEIVED_FROM_JOB(SrNo),LotNo Numeric(6),ItemName Varchar(30),JobSendChNo Varchar(15),JobSendSrNo Varchar(15),JobSendItmSrNo Numeric(3),ItemPcs Numeric(6),ItemMts Money,SendChStatus Varchar(1),ItemPer Varchar(1),ItemRate Money,ItemAmt Money,WastePcs Numeric(6),WasteMts Money,RtnPcs Numeric(6),RtnMts Money,Screen Varchar(30),StockType Varchar(35),JobQuality Varchar(35),ItemSrNo Numeric(6),OrdSrNo Varchar(8),OrdISrNo Numeric(3),WasteRate Money,WasteAmt Money,ConSrNo Varchar(6),ConISrNo Numeric(6),WasIsShrt Varchar(3),ReadyToSale Varchar(1),Cut Money,Short Money,Line Money,RangeDesp Varchar(30),UsedWeight Money, Shortage Money, SendWeight Money,YCompCode Varchar(7),YModule Varchar(25),YSrNo Varchar(15),YISrNo Numeric(6))
Create Table TamCOMP.dbo.OPENING_CHALLAN_RECEIVED_FROM_JOB_TAKA_DETAIL (SrNo Varchar(6) Foreign Key References OPENING_CHALLAN_RECEIVED_FROM_JOB(SrNo),ItemSrNo Numeric(3),TakaSrNo Numeric(6),GreyMts Money,RecdMts Money, GreyTP1 Money,RecdTP1 Money,GreyTP2 Money,RecdTP2 Money,GreyTP3 Money,RecdTP3 Money,GreyTP4 Money,RecdTP4 Money,GreyTP5 Money,RecdTP5 Money, GreyTP6 Money,RecdTP6 Money,GreyTP7 Money,RecdTP7 Money,GreyTP8 Money,RecdTP8 Money,GreyTP9 Money,RecdTP9 Money,GreyTP10 Money,RecdTP10 Money,ShortPerc Money,CurTime DateTime)
Create Table TamCOMP.dbo.OPENING_CHALLAN_RECEIVED_FROM_JOB_YARN_TAKA_DETAIL (SrNo Varchar(6) Foreign Key References OPENING_CHALLAN_RECEIVED_FROM_JOB(SrNo),ItemSrNo Numeric(3),YTakaSrNo Numeric(6),WeaverSrNo Varchar(6),MtsKGs Money, UsedWeight Money,WeightPer100Mts Money, MtsPer1KG Money)
Create Table TamCOMP.dbo.OPENING_CHALLAN_RECEIVED_FROM_JOB_FINISHED_TAKA_DETAIL (SrNo varchar(6) Foreign Key References OPENING_CHALLAN_RECEIVED_FROM_JOB(SrNo),ItemSrNo Numeric(3),TakaSrNo Numeric(3),TakaMts Money)
Create Table TamCOMP.dbo.OPENING_CHALLAN_RECEIVED_FROM_JOB_YARN_CONSUMPTION_DETAIL (SrNo Varchar(6) Foreign Key References OPENING_CHALLAN_RECEIVED_FROM_JOB(SrNo),ItemSrNo Numeric(3),ConISrNo Numeric(3),UsedPerc Money,UsedWeight Money, ShortPerc Money,ShortWeight Money, YCompCode Varchar(7),YModule Varchar(25),YSrNo Varchar(15),YISrNo Numeric(6), WasteWeight Money, ReturnWeight Money,JobSendChNo Varchar(15),JobSendSrNo Varchar(15),JobSendItmSrNo Numeric(3))
Create Table TamCOMP.dbo.OPENING_ITEM_SCREEN_COSTING (StockType Varchar(255),RSType Varchar(255),RSSrNo Varchar(255),RSISrNo Numeric(6),RSDate DateTime,PartyCode Varchar(255),ItemName Varchar(255),Screen Varchar(255),Pcs Numeric(6),Mts Money,Costing Money,CostingPer Varchar(255),TotCosting Money)
Create Table TamCOMP.dbo.OPENING_CHALLAN_RECEIVED_FOR_JOB_BILL (SrNo Varchar(6) Primary Key,CurDate DateTime,JobCode Varchar(7) Foreign Key References ACCOUNT_MASTER(AccCode),ChallanDate DateTime,ChallanNo Varchar(15),GrossAmt Money,ChallanStatus Varchar(7),UName Varchar(255),Remark Varchar(50),JobType Varchar(35),ReadyToSale Varchar(1),AgentCode Varchar(7) Foreign Key References AGENT_MASTER(AgentCode),BillType Varchar(7))
Create Table TamCOMP.dbo.OPENING_CHALLAN_RECEIVED_FOR_JOB_BILL_CHALLAN_DETAIL (SrNo Varchar(6) Foreign Key References OPENING_CHALLAN_RECEIVED_FOR_JOB_BILL(SrNo),LotNo Numeric(6),ItemName Varchar(30),JobSendChNo Varchar(15),JobSendSrNo Varchar(15),JobSendItmSrNo Numeric(3),ItemPcs Numeric(6),ItemMts Money,SendChStatus Varchar(1),ItemPer Varchar(1),ItemRate Money,ItemAmt Money,WastePcs Numeric(6),WasteMts Money,RtnPcs Numeric(6),RtnMts Money,Screen Varchar(30),StockType Varchar(35),JobQuality Varchar(35),ItemSrNo Numeric(6),OrdSrNo Varchar(8),OrdISrNo Numeric(3),WasteRate Money,WasteAmt Money,ConSrNo Varchar(6),ConISrNo Numeric(6))
Create Table TamCOMP.dbo.STOCK_TRANSFER (SrNo Varchar(7) Primary Key,CurDate DateTime,ChallanNo Varchar(15),ChallanDate DateTime,BranchCode Varchar(7) Foreign Key References GROUP_MASTER (GrpCode),Stock Varchar(30),StockType Varchar(30),Reason Varchar(255),StockTrfBy Varchar(255),Remark Varchar(255))
Create Table TamCOMP.dbo.STOCK_TRANSFER_DETAIL (SrNo Varchar(7) Foreign Key References STOCK_TRANSFER(SrNo),ISrNo Numeric(6),Item Varchar(35),Pcs Numeric(6),Mts Money)
Create Table TamCOMP.dbo.GREY_RECEIVED_FROM_JOB (SrNo Varchar(7) Primary Key,CurDate DateTime,BillNo Varchar(20),BillDate DateTime,ChallanNo Varchar(15),ChallanRecdDate DateTime,WeaverCode Varchar(7),NetAmt Money,Remark Varchar(50),WeaverAgentCode Varchar(7),EntType Varchar(25))
Create Table TamCOMP.dbo.GREY_RECEIVED_FROM_JOB_ITEM_DETAIL (SrNo Varchar(7) Foreign Key References GREY_RECEIVED_FROM_JOB(SrNo),ItemSrNo Numeric(3),ItemName Varchar(30),ItemPcs Numeric(6),ItemMts Money,ItemPer Varchar(1),ItemRate Money,ItemAmount Money,Marka Varchar(15))
Create Table TamCOMP.dbo.GREY_RECEIVED_FROM_JOB_TAKA_DETAIL (SrNo Varchar(7),ItemSrNo Numeric(3),ItemName Varchar(30),TakaSrNo Numeric(3),TakaMts Money,TakaTP1 Money,TakaTP2 Money,TakaTP3 Money,TakaTP4 Money,TakaTP5 Money,StWeight Money,OrgWeight Money,Veriation Money,Marka Varchar(15))
Create Table TamCOMP.dbo.OPENING_FOR_ITEM_FINALIZATION (MillChallanNo Varchar(255),LotNo Varchar(255),ItemName Varchar(255),GreyTaka Money,GreyMts Money,FinMts Money,ShrtPerc Money,ShrtMts Money,ProcRate Money,FRSrNo Varchar(255),Rate Money,ChStatus Varchar(255),ISrNo Varchar(255),FRISrNo Numeric(3),IFSrNo Varchar(255),AccCode Varchar(255))
Create Table TamCOMP.dbo.RECEIVED_FROM_JOB (SrNo Varchar(6) Primary Key,CurDate DateTime,JobCode Varchar(7) Foreign Key References ACCOUNT_MASTER(AccCode),BillDate DateTime,BillNo Varchar(20),GrossAmt Money,TDSPerc Money,TDSAmt Money,NetAmt Money,TransName Varchar(35),TransLRNo Varchar(15),TransLRCase Varchar(30),TransLRDate DateTime,TransDespStation Varchar(35),BillStatus Varchar(7),Remark Varchar(50),TDSAcc Varchar(7),IncomeTaxPerc Money,IncomeTaxAmt Money,SurchargePerc Money,SurchargeAmt Money,EduCessPerc Money,EduCessAmt Money,TDSType Varchar(35),TDSDate DateTime,AgentCode Varchar(7) Foreign Key References AGENT_MASTER(AgentCode),BillType Varchar(7),RevCharge Varchar(3),GSTSupplyType Varchar(15),RCMSrNo Varchar(6),EntType Varchar(25))
Create Table TamCOMP.dbo.RECEIVED_FROM_JOB_CHALLAN_DETAIL (SrNo Varchar(6) Foreign Key References RECEIVED_FROM_JOB(SrNo),StockType Varchar(35),ItemName Varchar(30),JobSendChNo Varchar(15),JobSendSrNo Varchar(15),JobSendItmSrNo Numeric(3),ItemPcs Numeric(6),ItemMts Money,SendChStatus Varchar(1),ItemPer Varchar(1),ItemRate Money,ItemAmt Money,WastePcs Numeric(6),WasteMts Money,RtnPcs Numeric(6),RtnMts Money,Screen Varchar(30),LotNo Numeric(6),JobQuality Varchar(35),HSNCode Varchar(10), IGSTPerc Money, IGSTAmt Money, CGSTPerc Money, CGSTAmt Money, SGSTPerc Money, SGSTAmt Money, UTGSTPerc Money, UTGSTAmt Money, CESSPerc Money, CESSAmt Money,ItemDiscPerc Money, ItemDiscAmt Money, ItemAddPerc Money, ItemAddAmt Money)
Create Table TamCOMP.dbo.OPENING_RECEIVED_FROM_JOB (SrNo Varchar(6) Primary Key,JobCode Varchar(7) Foreign Key References ACCOUNT_MASTER(AccCode),BillDate DateTime,BillNo Varchar(20),NetAmt Money,BillStatus Varchar(7),UName Varchar(255),GRAmt Money,ChqAmt Money,CashAmt Money,AddLess Money,AgentCode Varchar(7) Foreign Key References AGENT_MASTER(AgentCode),TDSAmt Money,BillType Varchar(7),GSTSupplyType Varchar(15),GSTAmt Money,RevCharge Varchar(3),EntType Varchar(25))
Create Table TamCOMP.dbo.OPENING_GREY_AT_SHOP (SrNo Varchar(15) Primary Key,BillNo Varchar(20),BillDate DateTime,ChallanNo Varchar(15),ChallanRecdDate DateTime,WeaverCode Varchar(7) Foreign Key References ACCOUNT_MASTER(AccCode),GrossAmt Money,UName Varchar(255),TransName Varchar(35),TransLRNo Varchar(15),GSTSupplyType Varchar(15),EntType Varchar(25))
Create Table TamCOMP.dbo.OPENING_GREY_AT_SHOP_ITEM_DETAIL (SrNo Varchar(15) Foreign Key References OPENING_GREY_AT_SHOP(SrNo),ItemSrNo Numeric(3),ItemName Varchar(30),ItemPcs Numeric(6),ItemCut Money,ItemMts Money,ItemFoldPerc Money,ItemActualMts Money,ItemPer Varchar(1),ItemRate Money,ItemAmount Money,Marka Varchar(15),SaleOrdNo Varchar(10),YarnLotNo Varchar(25),Denier Varchar(25),Grade Varchar(25))
Create Table TamCOMP.dbo.OPENING_GREY_AT_SHOP_TAKA_DETAIL (SrNo Varchar(15),ItemSrNo Numeric(3),ItemName Varchar(30),TakaSrNo Numeric(3),TakaMts Money,TakaTP1 Money,TakaTP2 Money,TakaTP3 Money,TakaTP4 Money,TakaTP5 Money,StWeight Money,OrgWeight Money,Veriation Money,Marka Varchar(15),WevTkSrNo Numeric(6))
Create Table TamCOMP.dbo.OPENING_GREY_AT_SHOP_YARN_TAKA_DETAIL (SrNo Varchar(15),ItemSrNo Numeric(3),TakaSrNo Numeric(3),CartoonNo Varchar(50),Cone Numeric(6),NetWeight Money,ShadeColor Varchar(50))
Create Table TamCOMP.dbo.TDS_TCS_CHALLAN (SrNo Varchar(6) Primary Key,CurDate DateTime,ChallanNo Varchar(35),TaxFrom Varchar(35),TANNo Varchar(35),FullName Varchar(35),Add1 Varchar(80),Add2 Varchar(80),CityPin Numeric(6),Phone Varchar(35),TypeOfPay Varchar(3),TDSTCSCode Varchar(35),IncomeTax Money,Surcharge Money,EducationCess Money,Interest Money,Penalty Money,TDSTCSTotal Money,DrawOn Varchar(35),DepositDate DateTime,UName Varchar(255),InterestPerc Money,PenaltyPerc Money,BSRCode Varchar(35),TVNo Varchar(50),TDSMonth Varchar(15),ChqNo Varchar(15))
Create Table TamCOMP.dbo.TDS_TCS_CHALLAN_TDS_TYPE_DETAIL (SrNo Varchar(6) Foreign Key References TDS_TCS_CHALLAN (SrNo),TDSType Varchar(35))
Create Table TamCOMP.dbo.TDS_TCS_CHALLAN_PARTY_DETAIL (SrNo Varchar(6) Foreign Key References TDS_TCS_CHALLAN (SrNo),PartyCode Varchar(7) Foreign Key References ACCOUNT_MASTER(AccCode),Amount Money,TDS Money,Surcharge Money,EduCess Money,TotalTAX Money,TDSPerc Money)
Create Table TamCOMP.dbo.BILL_ACCOUNT_TYPES (AccCode Varchar(7) Foreign Key References ACCOUNT_MASTER(AccCode))
Create Table TamCOMP.dbo.JOB_ACCOUNT_TYPES (AccCode Varchar(7) Foreign Key References ACCOUNT_MASTER(AccCode))
Create Table TamCOMP.dbo.FINISHED_PURCHASE_ACCOUNT_TYPES (AccCode Varchar(7) Foreign Key References ACCOUNT_MASTER(AccCode))
Create Table TamCOMP.dbo.GREY_PURCHASE_ACCOUNT_TYPES (AccCode Varchar(7) Foreign Key References ACCOUNT_MASTER(AccCode))
Create Table TamCOMP.dbo.RETURN_GOODS_ACCOUNT_TYPES (AccCode Varchar(7) Foreign Key References ACCOUNT_MASTER(AccCode))
Create Table TamCOMP.dbo.GREY_RETURN_ACCOUNT_TYPES (AccCode Varchar(7) Foreign Key References ACCOUNT_MASTER(AccCode))
Create Table TamCOMP.dbo.FINISHED_RETURN_ACCOUNT_TYPES (AccCode Varchar(7) Foreign Key References ACCOUNT_MASTER(AccCode))
Create Table TamCOMP.dbo.BANK_BOOK_CHEQUE_RETURN_DETAIL (BkSrNo Varchar(6) Primary Key,BkAccCode Varchar(7) Foreign Key References ACCOUNT_MASTER(AccCode),BkBankAccCode Varchar(7) Foreign Key References ACCOUNT_MASTER(AccCode),BkPartyBankName Varchar(35),BkChequeAmt Money,BkChequeDate DateTime,BkRemark Varchar(255),BkCurDate DateTime,BkCurTime DateTime,BkUName Varchar(255),ReturnDate DateTime,SearchIn Varchar(8),BkChequeNo Varchar(15))
Create Table TamCOMP.dbo.BANK_BOOK_CHEQUE_RETURN_ADDLESS_DETAIL (BkSrNo Varchar(6) Foreign Key References BANK_BOOK_CHEQUE_RETURN_DETAIL(BkSrNo),BkBillNo Varchar(20),BkDiscPerc Money,BkDiscPercAmt Money,BkRateDiff Money,BkClaimLess Money,BkBankCommission Money,BkAddInterestPerc Money,BkAddInterestPercAmt Money,BkBillPaidAmt Money,BkStatus Varchar(7),BkDisBal Money,BkRDBal Money,BkGRBal Money,BkIntBal Money)
Create Table TamCOMP.dbo.GREY_SEND_TO_MILL_PROGRAM (ProgName Varchar(255))
Create Table TamCOMP.dbo.GREY_RETURN_FROM_MILL (FRSrNo Varchar(6) Primary Key,CurDate DateTime,MillCode Varchar(7) Foreign Key References ACCOUNT_MASTER(AccCode),RtnDate DateTime,ChallanNo Varchar(15),UName Varchar(255),Remark Varchar(50),GreyStatus Varchar(6),GSTSupplyType Varchar(15))
Create Table TamCOMP.dbo.GREY_RETURN_FROM_MILL_CHALLAN_DETAIL (FRSrNo Varchar(6) Foreign Key References GREY_RETURN_FROM_MILL(FRSrNo),FRCSrNo Numeric(3),MillChallanNo Varchar(15),MillSendSrNo Varchar(6),LotNo Varchar(15),GreyTaka Numeric(6),GreyMts Money,ReturnMts Money,ChallanStatus Varchar(7))
Create Table TamCOMP.dbo.GREY_RETURN_FROM_MILL_TAKA_DETAIL (FRSrNo Varchar(6) Foreign Key References GREY_RETURN_FROM_MILL(FRSrNo),FRCSrNo Numeric(3),TakaSrNo Numeric(6),GreyMts Money,RtnMts Money, GreyTP1 Money,RtnTP1 Money,GreyTP2 Money,RtnTP2 Money,GreyTP3 Money,RtnTP3 Money,GreyTP4 Money,RtnTP4 Money,GreyTP5 Money,RtnTP5 Money,CurTime DateTime,WevTkSrNo Numeric(6))
Create Table TamCOMP.dbo.MILL_ORDER (FRSrNo Varchar(6) Primary Key,CurDate DateTime,MillCode Varchar(7) Foreign Key References ACCOUNT_MASTER(AccCode),OrdDate DateTime,ProgNo Varchar(15),DyingRange Varchar(15),UName Varchar(255),Remark Varchar(50))
Create Table TamCOMP.dbo.MILL_ORDER_CHALLAN_DETAIL (FRSrNo Varchar(6) Foreign Key References MILL_ORDER(FRSrNo),FRCSrNo Numeric(3),ChallanNo Varchar(8),LotNo Varchar(15),Panna Varchar(15),BatchNo Varchar(6),Marka Varchar(15),GreyTaka Numeric(6),GreyMts Money,CutMts Money,ShortPerc Money,Pcs Numeric(6),MillSendSrNo Varchar(6))
Create Table TamCOMP.dbo.GREY_PURCHASE_ORDER_FORM (SrNo Varchar(6) Primary Key,CurDate DateTime,OrderDate DateTime,WeaverCode Varchar(7) Foreign Key References ACCOUNT_MASTER(AccCode),WeaverAgentCode Varchar(7) Foreign Key References AGENT_MASTER(AgentCode),Haste Varchar(50),GrossAmt Money,UName Varchar(255),OrderStatus Varchar(7),Remark Varchar(50),DueDays Numeric(6))
Create Table TamCOMP.dbo.GREY_PURCHASE_ORDER_FORM_ITEM_DETAIL (SrNo Varchar(6) Foreign Key References GREY_PURCHASE_ORDER_FORM(SrNo),ItemSrNo Numeric(3),ItemName Varchar(30),ItemPcs Numeric(6),ItemCut Money,ItemMts Money,ItemFoldPerc Money,ItemActualMts Money,ItemPer Varchar(1),ItemRate Money,ItemAmount Money,OrdStatus Varchar(7),SaleOrdNo Varchar(15),SaleOrdINo Numeric(6))
Create Table TamCOMP.dbo.FINISHED_PURCHASE_ORDER_FORM (SrNo Varchar(6) Primary Key,CurDate DateTime,OrderDate DateTime,WeaverCode Varchar(7) Foreign Key References ACCOUNT_MASTER(AccCode),WeaverAgentCode Varchar(7) Foreign Key References AGENT_MASTER(AgentCode),Haste Varchar(50),GrossAmt Money,UName Varchar(255),OrderStatus Varchar(7),Remark Varchar(50),PartyOrdNo Varchar(25))
Create Table TamCOMP.dbo.FINISHED_PURCHASE_ORDER_FORM_ITEM_DETAIL (SrNo Varchar(6) Foreign Key References FINISHED_PURCHASE_ORDER_FORM(SrNo),ItemName Varchar(30),ItemPcs Numeric(6),ItemCut Money,ItemMts Money,ItemPer Varchar(1),ItemRate Money,ItemAmount Money,ItemStatus Varchar(7),ItemRangeDesp Varchar(30),ItemSrNo Numeric(3),ConSrNo Varchar(6),SaleOrdSrNo Varchar(15),SaleOrdISrNo Numeric(6))
Create Table TamCOMP.dbo.OPENING_FINISHED_PURCHASE_ORDER_FORM (SrNo Varchar(6) Primary Key,CurDate DateTime,OrderDate DateTime,WeaverCode Varchar(7) Foreign Key References ACCOUNT_MASTER(AccCode),WeaverAgentCode Varchar(7) Foreign Key References AGENT_MASTER(AgentCode),Haste Varchar(50),GrossAmt Money,UName Varchar(255),OrderStatus Varchar(7),Remark Varchar(50),PartyOrdNo Varchar(25))
Create Table TamCOMP.dbo.OPENING_FINISHED_PURCHASE_ORDER_FORM_ITEM_DETAIL (SrNo Varchar(6) Foreign Key References OPENING_FINISHED_PURCHASE_ORDER_FORM(SrNo),ItemName Varchar(30),ItemPcs Numeric(6),ItemCut Money,ItemMts Money,ItemPer Varchar(1),ItemRate Money,ItemAmount Money,ItemStatus Varchar(7),ItemRangeDesp Varchar(30),ItemSrNo Numeric(3),ConSrNo Varchar(6),SaleOrdSrNo Varchar(15),SaleOrdISrNo Numeric(6))
Create Table TamCOMP.dbo.JOB_ORDER_FORM (SrNo Varchar(6) Primary Key,CurDate DateTime,OrderDate DateTime,JobGrpCode Varchar(7) Foreign Key References GROUP_MASTER(GrpCode),AgentCode Varchar(7) Foreign Key References AGENT_MASTER(AgentCode),GrossAmt Money,UName Varchar(255),OrderStatus Varchar(7),Remark Varchar(50),IsPrinted Varchar(3))
Create Table TamCOMP.dbo.JOB_ORDER_FORM_ITEM_DETAIL (SrNo Varchar(6) Foreign Key References JOB_ORDER_FORM(SrNo),ItemName Varchar(30),ItemPcs Numeric(6),ItemCut Money,ItemMts Money,ItemPer Varchar(1),ItemRate Money,ItemAmount Money,ItemStatus Varchar(7),ItemRangeDesp Varchar(30),ItemSrNo Numeric(3),ItemRemark Varchar(255),SOrdNo Varchar(8))
Create Table TamCOMP.dbo.OPENING_JOB_ORDER_FORM (SrNo Varchar(6) Primary Key,CurDate DateTime,OrderDate DateTime,JobGrpCode Varchar(7) Foreign Key References GROUP_MASTER(GrpCode),AgentCode Varchar(7) Foreign Key References AGENT_MASTER(AgentCode),GrossAmt Money,UName Varchar(255),OrderStatus Varchar(7),Remark Varchar(50))
Create Table TamCOMP.dbo.OPENING_JOB_ORDER_FORM_ITEM_DETAIL (SrNo Varchar(6) Foreign Key References OPENING_JOB_ORDER_FORM(SrNo),ItemName Varchar(30),ItemPcs Numeric(6),ItemCut Money,ItemMts Money,ItemPer Varchar(1),ItemRate Money,ItemAmount Money,ItemStatus Varchar(7),ItemRangeDesp Varchar(30),ItemSrNo Numeric(3),ItemRemark Varchar(255),SOrdNo Varchar(8))
Create Table TamCOMP.dbo.TDS_CERTIFICATE_DETAIL (SrNo Varchar(6) Primary Key,CurDate DateTime,TDSDate DateTime,PartyCode Varchar(7) Foreign Key References ACCOUNT_MASTER(AccCode),PeriodStart DateTime,PeriodEnd DateTime,QrtActNo1 Varchar(20),QrtActNo2 Varchar(20),QrtActNo3 Varchar(20),QrtActNo4 Varchar(20),UName Varchar(255),TDSCode Varchar(15),QtrNo Varchar(20),ReceiptNo Varchar(25))
Create Table TamCOMP.dbo.TDS_CERTIFICATE_TDS_DETAIL(SrNo Varchar(6) Foreign Key References TDS_CERTIFICATE_DETAIL (SrNo),TSrNo Numeric(3),Amount Money,IncomeTax Money,Surcharge Money,EduCess Money,TDSAmt Money,ChallanNo Varchar(20),TaxRate Money,IntRate Money,TDSDate DateTime,BankCode Varchar(20),TVNo Varchar(20),BankBranch Varchar(80),TDSMonth Varchar(15),ChequeNo Varchar(15))
Create Table TamCOMP.dbo.PRINTING_MASTER (MasterName Varchar(35),Phone Varchar(30),Mobile Varchar(30),EmailID Varchar(30),MillCode Varchar(7))
Create Table TamCOMP.dbo.ORDER_BILL_DETAIL (OrdNo Varchar(8) Primary Key,CurDate DateTime,OrdDate DateTime,CustCode Varchar(7) Foreign Key References ACCOUNT_MASTER(AccCode),AgentCode Varchar(7) Foreign Key References AGENT_MASTER(AgentCode),Haste Varchar(50),GrossAmt Money,Remark Varchar(50),TransName Varchar(35),TransLRNo Varchar(15),TransLRCase Varchar(30),TransLRDate DateTime,TransDespStation Varchar(35),UName Varchar(255),OrdStatus Varchar(7),TransFreight Money,TransWeight Money,BaleOrderNo Varchar(6),BaleOrderNoSerial Varchar(1),PartyOrdNo Varchar(25),OrderTime DateTime,BuyerDetail Varchar(700),SMAccCode Varchar(7))
Create Table TamCOMP.dbo.ORDER_BILL_ITEM_DETAIL (OrdNo Varchar(8) Foreign Key References ORDER_BILL_DETAIL(OrdNo),ItemName Varchar(30),ItemPcs Numeric(6),ItemCut Money,ItemMts Money,ItemPer Varchar(1),ItemRate Money,ItemAmount Money,ItemRangeDesp Varchar(30),ItemSrNo Numeric(3),PurSrNo Varchar(15),PurISrNo Numeric(3),ItemFold Money,ItemActMts Money,Bale Numeric(6),OrdStatus Varchar(7),GrpCode Varchar(7),JobOrdChNo Varchar(25),SubScreen Varchar(30),ItemRemark Varchar(700),Dollar Money,GreyRate Money,ProcRate Money,JobRate Money,OverHead Money,Commission Money,Others Money,ItemID Varchar(25),ShipCharge Money)
Create Table TamCOMP.dbo.ORDER_BILL_ITEM_TAKA_DETAIL (OrdNo Varchar(8) Foreign Key References ORDER_BILL_DETAIL(OrdNo),ItemSrNo Numeric(3),ISrNo Numeric(5),ItemDesignNo Varchar(20),ItemQty Numeric(5),ItemSet Money,ItemTotal Money)
Create Table TamCOMP.dbo.OPENING_ORDER_BILL_DETAIL (OrdNo Varchar(8) Primary Key,CurDate DateTime,OrdDate DateTime,CustCode Varchar(7) Foreign Key References ACCOUNT_MASTER(AccCode),AgentCode Varchar(7) Foreign Key References AGENT_MASTER(AgentCode),Haste Varchar(50),GrossAmt Money,Remark Varchar(50),TransName Varchar(35),TransLRNo Varchar(15),TransLRCase Varchar(30),TransLRDate DateTime,TransDespStation Varchar(35),UName Varchar(255),OrdStatus Varchar(7),TransFreight Money,TransWeight Money,BaleOrderNo Varchar(6),BaleOrderNoSerial Varchar(1),PartyOrdNo Varchar(25),OrderTime DateTime,BuyerDetail Varchar(700),SMAccCode Varchar(7))
Create Table TamCOMP.dbo.OPENING_ORDER_BILL_ITEM_DETAIL (OrdNo Varchar(8) Foreign Key References OPENING_ORDER_BILL_DETAIL(OrdNo),ItemName Varchar(30),ItemPcs Numeric(6),ItemCut Money,ItemMts Money,ItemPer Varchar(1),ItemRate Money,ItemAmount Money,ItemRangeDesp Varchar(30),ItemSrNo Numeric(3),PurSrNo Varchar(15),PurISrNo Numeric(3),ItemFold Money,ItemActMts Money,Bale Numeric(6),OrdStatus Varchar(7),GrpCode Varchar(7),JobOrdChNo Varchar(25),SubScreen Varchar(30),ItemRemark Varchar(700),Dollar Money,GreyRate Money,ProcRate Money,JobRate Money,OverHead Money,Commission Money,Others Money,ItemID Varchar(25),ShipCharge Money)
Create Table TamCOMP.dbo.OPENING_ORDER_BILL_ITEM_TAKA_DETAIL (OrdNo Varchar(8) Foreign Key References OPENING_ORDER_BILL_DETAIL(OrdNo),ItemSrNo Numeric(3),ISrNo Numeric(5),ItemDesignNo Varchar(20),ItemQty Numeric(5),ItemSet Money,ItemTotal Money)
Create Table TamCOMP.dbo.MULTI_JOURNAL_DETAIL (BkSrNo Varchar(6) Primary Key,BkAccCode Varchar(7) Foreign Key References ACCOUNT_MASTER(AccCode),BkDrCr Varchar(6),BkCurDate DateTime,BkUname Varchar(255),JVType Varchar(25),GSTSupplyType Varchar(15))
Create Table TamCOMP.dbo.MULTI_JOURNAL_ADDLESS_DETAIL (BkSrNo Varchar(6) Foreign Key References MULTI_JOURNAL_DETAIL(BkSrNo),BkISrNo Numeric(6),BkDrCrParty Varchar(7) Foreign Key References ACCOUNT_MASTER(AccCode),BkBillPaidAmt Money,BkBillNo Varchar(20),VouNo Varchar(6),JVDate DateTime,BkRemark Varchar(255),BkStatus Varchar(7),BkBillNo2 Varchar(20),BkStatus2 Varchar(7),HSNCode Varchar(10), IGSTPerc Money, IGSTAmt Money, CGSTPerc Money, CGSTAmt Money, SGSTPerc Money, SGSTAmt Money, UTGSTPerc Money, UTGSTAmt Money, CESSPerc Money, CESSAmt Money,ItemDiscPerc Money, ItemDiscAmt Money, ItemAddPerc Money, ItemAddAmt Money,GSTITC Varchar(15),ROffAmt Money,TDSPerc Money,TDSAmt Money,TDSAcc Varchar(7),IncomeTaxPerc Money,IncomeTaxAmt Money,SurchargePerc Money,SurchargeAmt Money,EduCessPerc Money,EduCessAmt Money,TDSType Varchar(35),TDSDate DateTime,TDSRecPay Varchar(35),PartyNoteNo Varchar(25))
Create Table TamCOMP.dbo.OPENING_GREY_PURCHASE_ORDER_FORM (SrNo Varchar(6) Primary Key,CurDate DateTime,OrderDate DateTime,WeaverCode Varchar(7) Foreign Key References ACCOUNT_MASTER(AccCode),WeaverAgentCode Varchar(7) Foreign Key References AGENT_MASTER(AgentCode),Haste Varchar(50),GrossAmt Money,UName Varchar(255),OrderStatus Varchar(7),Remark Varchar(50),DueDays Numeric(6))
Create Table TamCOMP.dbo.OPENING_GREY_PURCHASE_ORDER_FORM_ITEM_DETAIL (SrNo Varchar(6) Foreign Key References OPENING_GREY_PURCHASE_ORDER_FORM(SrNo),ItemSrNo Numeric(3),ItemName Varchar(30),ItemPcs Numeric(6),ItemCut Money,ItemMts Money,ItemFoldPerc Money,ItemActualMts Money,ItemPer Varchar(1),ItemRate Money,ItemAmount Money,OrdStatus Varchar(7),SaleOrdNo Varchar(15),SaleOrdINo Numeric(6))
Create Table TamCOMP.dbo.LOST_AT_SHOP (SrNo Varchar(6) Primary Key,CurDate DateTime,MemoNo Varchar(8),MemoDate DateTime,GrossAmt Money,UName Varchar(255),Remark Varchar(50),LstType Varchar(35),BillJV Varchar(3),BillJVSrNo Varchar(6),MemoType Varchar(30))
Create Table TamCOMP.dbo.LOST_AT_SHOP_ITEM_DETAIL (SrNo Varchar(6) Foreign Key References LOST_AT_SHOP(SrNo),ItemSrNo Numeric(3),ItemName Varchar(30),ItemPcs Numeric(6),ItemMts Money,ItemPer Varchar(1),ItemRate Money,ItemAmount Money,PurSrNo Varchar(15),PurISrNo Numeric(6),ScreenName Varchar(30))
Create Table TamCOMP.dbo.SCAN_BALANCE_SHEET (SrNo Varchar(700),FormName Varchar(700),CreditAcc Varchar(700),DebitAcc Varchar(700),AgentCode Varchar(700),TDate DateTime,BillNo Varchar(700),ChequeNo Varchar(700),Amount Money,Remark Varchar(700),Status Varchar(700),ZoomCode Varchar(700),Bills Varchar(700),MergeRef Varchar(255))
Create Table TamCOMP.dbo.BILLS_SCAN_BALANCE_SHEET (SrNo Varchar(700),FormName Varchar(700),Bills Varchar(700),BillNo Varchar(700))
Create Table TamCOMP.dbo.SCAN_GREY_SEND_TO_MILL (BillDate DateTime,WeaverName Varchar(50),BillNo Varchar(50),ChNo Varchar(50),PurPcs Money,PurMts Money,PurRtnPcs Money,PurRtnMts Money,GreySalePcs Money,GreySale Money,GrySaleRtnPcs Money,GrySaleRtn Money,MillSndPcs Money,MillSndMts Money,MillRtnPcs Money,MillRtnMts Money,BalancePcs Money,Balance Money,Rate Money,Value  Money,WeaverCode Varchar(50),ItemCode Varchar(50),SrNo Varchar(50),AgentCode Varchar(50),PurISrNo Varchar(50))
Create Table TamCOMP.dbo.SCAN_FINISHED_STOCK (IFSrNo Varchar(50),ReadyDate DateTime,ItemName Varchar(50),IFPcs Money,IFMts Money,IFReqMts Money,IFFinMts Money,IFFent Money,IFLotNo Varchar(50),RecSrNo Varchar(50),RecChNo Varchar(50),IFGreyMts Money,IFCostPerMts Money,GreyPurSrNo Varchar(50),GreyISrNo Varchar(50),GreyItem Varchar(50),WeaverName Varchar(50),GreyBillNo Varchar(50),GreyChNo Varchar(50),MillRecSrNo Varchar(50),MillName Varchar(50),MillRecdDate DateTime,FinPurRtnMts Money)
Create Table TamCOMP.dbo.OPENING_SCAN_FINISHED_STOCK (IFSrNo Varchar(50),ReadyDate DateTime,ItemName Varchar(50),IFPcs Money,IFMts Money,IFReqMts Money,IFFinMts Money,IFFent Money,IFLotNo Varchar(50),RecSrNo Varchar(50),RecChNo Varchar(50),IFGreyMts Money,IFCostPerMts Money,GreyPurSrNo Varchar(50),GreyISrNo Varchar(50),GreyItem Varchar(50),WeaverName Varchar(50),GreyBillNo Varchar(50),GreyChNo Varchar(50),MillRecSrNo Varchar(50),MillName Varchar(50),MillRecdDate DateTime,FinPurRtnMts Money)
Create Table TamCOMP.dbo.COMPANY_SETTING(SettingName Varchar(255),SettingStatus Varchar(255))
Create Table TamCOMP.dbo.MARKING_LEDGER_REPORT(Marking Varchar(50))
Create Table TamCOMP.dbo.RECONCILIATION_HISTORY (MarkDate DateTime, Marking Varchar(50))
Create Table TamCOMP.dbo.GREY_ITEM_WISE_FINISHED_STOCK (ItemName Varchar(30),OpenStock Money)
Create Table TamCOMP.dbo.OPENING_WITHOUT_WORK_STOCK (ItemName Varchar(30),OpenStock Money,OpenStockPcs Numeric(13))
Create Table TamCOMP.dbo.BILLS_INTEREST_CALCULATION (SrNo Varchar(6) Primary Key,CurDate DateTime,PartyCode Varchar(7) Foreign Key References ACCOUNT_MASTER(AccCode),AgentCode Varchar(7) Foreign Key References AGENT_MASTER(AgentCode),RecPay Varchar(255),IntRate Money,GraceDays Numeric(6),Remark Varchar(255),DaysPerYear Numeric(6),IsCompoundingInterest Numeric(1),IntCalcOn Varchar(25),PayStatus Varchar(15))
Create Table TamCOMP.dbo.BILLS_INTEREST_CALCULATION_DETAIL (SrNo Varchar(6) Foreign Key References BILLS_INTEREST_CALCULATION(SrNo),ISrNo Numeric(6),BillNo Varchar(50),BillDate DateTime,BillAmt Money,RecAmt Money,RecdDate DateTime,GraceDays Numeric(6),LateDays Numeric(6),GRAmt Money,DiscAmt Money,RDAmt Money,ClaimAmt Money,BCAmt Money,IntAmt Money,InterestAmt Money,TDSAmt Money)
Create Table TamCOMP.dbo.ADDLESS_DETAIL (FormName Varchar(35),SrNo Numeric(6),FldName Varchar(35),FldPerc Money,FldAddLess Varchar(1),FldPercMulti Varchar(1),FldRound Varchar(3),FldFormula Varchar(255),AccEff Varchar(3),EffAcc Varchar(7))
Create Table TamCOMP.dbo.FIRM_ADDLESS_DETAIL (FormSrNo Varchar(10),FormName Varchar(35),SrNo Numeric(6),FldName Varchar(35),FldPerc Money,FldAddLess Varchar(1),FldPercMulti Varchar(1),FldRound Varchar(3),FldFormula Varchar(255),AccEff Varchar(3),EffAcc Varchar(7),FldAmount Money)
Create Table TamCOMP.dbo.CUTTING_AFTER_JOB (SrNo Varchar(6) Primary Key,EntNo Varchar(15),CutDate DateTime,Remark Varchar(255))
Create Table TamCOMP.dbo.CUTTING_AFTER_JOB_DETAIL (SrNo Varchar(6) Foreign Key References CUTTING_AFTER_JOB(SrNo),RecSrNo Varchar(6),RecISrNo Numeric(6),CutPcs Numeric(6),CutMts Money,FinPcs Numeric(6),FinMts Money,Fent Money)
Create Table TamCOMP.dbo.CONSUMPTION_MODULE (SrNo Varchar(6) Primary Key,ScreenName Varchar(30),ConDate DateTime,Target Money,SaleRate Money,TarCost Money,Closed Varchar(1),Cut Money,PartyDesignNo Varchar(30))
Create Table TamCOMP.dbo.CONSUMPTION_ITEM_MODULE (SrNo Varchar(6) Foreign Key References CONSUMPTION_MODULE(SrNo),ISrNo Numeric(6),ItemName Varchar(30),Per Varchar(1),Consumption Money,Rate Money,Cost Money,Target Money,Remark Varchar(255),ReqStich Varchar(1))
Create Table TamCOMP.dbo.CONSUMPTION_PROCESSING_MODULE (SrNo Varchar(6) Foreign Key References CONSUMPTION_MODULE(SrNo),JobType Varchar(35),ProcessCost Money)
Create Table TamCOMP.dbo.OPENING_LR_GREY_PURCHASE (SrNo Varchar(6) Primary Key,CurDate DateTime,BillNo Varchar(20),BillDate DateTime,ChallanNo Varchar(15),ChallanRecdDate DateTime,WeaverCode Varchar(7) Foreign Key References ACCOUNT_MASTER(AccCode),WeaverAgentCode Varchar(7) Foreign Key References AGENT_MASTER(AgentCode),Haste Varchar(50),GrossAmt Money,NetAmt Money,UName Varchar(255),BillStatus Varchar(7),TransName Varchar(35),TransLRNo Varchar(15),TransLRDate DateTime,TransCase Varchar(30),TransFrom Varchar(35),Remark Varchar(50),OrderFrom Varchar(1),WeightVar Money,VarRate Money,VerAmount Money,ShortMts Money,GreyRtnMts Money,FoldLessPerc Money,FoldLessAmt Money,GSTSupplyType Varchar(15))
Create Table TamCOMP.dbo.OPENING_LR_GREY_PURCHASE_ITEM_DETAIL (SrNo Varchar(6) Foreign Key References OPENING_LR_GREY_PURCHASE(SrNo),ItemSrNo Numeric(3),ItemName Varchar(30),ItemPcs Numeric(6),ItemCut Money,ItemMts Money,ItemFoldPerc Money,ItemActualMts Money,ItemPer Varchar(1),ItemRate Money,ItemAmount Money,OrderNo Varchar(6),OrdISrNo Numeric(3),Marka Varchar(15),PerWT Money,HSNCode Varchar(10))
Create Table TamCOMP.dbo.OPENING_LR_GREY_PURCHASE_ITEM_TAKA_DETAIL (SrNo Varchar(6),ItemSrNo Numeric(3),ItemName Varchar(30),TakaSrNo Numeric(3),TakaMts Money,TakaTP1 Money,TakaTP2 Money,TakaTP3 Money,TakaTP4 Money,TakaTP5 Money,StWeight Money,OrgWeight Money,Veriation Money,Marka Varchar(15),WevTkSrNo Numeric(6))
Create Table TamCOMP.dbo.BARCODE_STOCK (SrNo Varchar(6) Primary Key,CurDate DateTime,BillNo Varchar(20),BillDate DateTime,ChallanNo Varchar(15),ChallanRecdDate DateTime,WeaverCode Varchar(7) Foreign Key References ACCOUNT_MASTER(AccCode),WeaverAgentCode Varchar(7) Foreign Key References AGENT_MASTER(AgentCode),Haste Varchar(50),GrossAmt Money,NetAmt Money,UName Varchar(255),BillStatus Varchar(7),TransName Varchar(35),TransLRNo Varchar(15),TransLRDate DateTime,TransCase Varchar(30),TransFrom Varchar(35),Remark Varchar(50),OrderFrom Varchar(1),OtherLess Money,RateDiffAmt Money,FoldAmt Money,PurType Varchar(7),EntNo Numeric(6))
Create Table TamCOMP.dbo.BARCODE_STOCK_ITEM_DETAIL (SrNo Varchar(6) Foreign Key References BARCODE_STOCK(SrNo),ItemName Varchar(30),ItemPcs Numeric(6),ItemCut Money,ItemMts Money,ItemPer Varchar(1),ItemRate Money,ItemAmount Money,ItemStatus Varchar(7),ItemRangeDesp Varchar(30),OrderNo Varchar(6),OrdISrNo Numeric(3),ItemAddLess Varchar(1),ItemDisPerc Money,ItemSerialNo Varchar(15),ItemDisAmt Money,ItemBillNo Varchar(20),ItemBISrNo Numeric(3),ItemFold Money,ItemFMts Money,ISrNo Numeric(3),ConSrNo Varchar(6),Barcode Varchar(13), SaleMRP Money, SaleDiscPerc Money, SaleRate Money, StockLocation Varchar(50),GSTRate Money,HSNCode Varchar(10))
Create Table TamCOMP.dbo.YARN_PRODUCTION (SrNo Varchar(6) Primary Key,ProductionNo Varchar(15),ProductionDate DateTime,StockType Varchar(35),PartyCode Varchar(7),AgentCode Varchar(7),Remark Varchar(50))
Create Table TamCOMP.dbo.YARN_PRODUCTION_CHALLAN_DETAIL (SrNo Varchar(6) Foreign Key References YARN_PRODUCTION(SrNo),ItemSrNo Numeric(6),LotNo Numeric(6),ItemName Varchar(30),UsedWeight Money, Shortage Money, SendWeight Money,ItemPcs Numeric(6),ItemMts Money,YCompCode Varchar(7),YModule Varchar(25),YSrNo Varchar(15),YISrNo Numeric(6))
Create Table TamCOMP.dbo.YARN_PRODUCTION_YARN_TAKA_DETAIL (SrNo Varchar(6) Foreign Key References YARN_PRODUCTION(SrNo),ItemSrNo Numeric(3),YTakaSrNo Numeric(6),WeaverSrNo Varchar(6),MtsKGs Money, UsedWeight Money,WeightPer100Mts Money, MtsPer1KG Money)
Create Table TamCOMP.dbo.YARN_PRODUCTION_YARN_CONSUMPTION_DETAIL (SrNo Varchar(6) Foreign Key References YARN_PRODUCTION(SrNo),ItemSrNo Numeric(3),ConISrNo Numeric(3),UsedPerc Money,UsedWeight Money, ShortPerc Money,ShortWeight Money, YCompCode Varchar(7),YModule Varchar(25),YSrNo Varchar(15),YISrNo Numeric(6), WasteWeight Money, ReturnWeight Money,JobSendChNo Varchar(15),JobSendSrNo Varchar(15),JobSendItmSrNo Numeric(3))
Create Table TamCOMP.dbo.UPDATE_DETAIL (SoftName Varchar(35),UpdDate DateTime,UpdTime DateTime,UpdNo Money)