⬅ Back Create company.txt
Create Database tmpdb
USE tmpdb
Create Table COUNTRY_MASTER (CountryName Varchar(20) Primary key)
Create Table STATE_MASTER (StateName Varchar(25) Primary key, CountryName Varchar(20))
Create Table ITEM_ON_MASTER (ItemName Varchar(30) Primary Key,ShortName Varchar(7))
Create Table CITY_MASTER(CityName Varchar(35) Primary key,StateName Varchar(25),STDCode Numeric(6))
Create TABLE CATALOG_MASTER (CatalogName Varchar(35) Primary key)
Create Table BANK_MASTER (BankName Varchar(35) Primary key)
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 JOB_CHALLAN_MASTER (ChallanName Varchar(35),ChallanSrNo Numeric(6))
Create Table VOUCHER_TYPE_MASTER (TypeName Varchar(25) Primary key)
Create Table HASTE_MASTER (Haste Varchar(25) Primary key,HasAdd1 Varchar(40), HasAdd2 Varchar(30),HasAdd3 Varchar(30),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))
Create Table GENERAL_ITEM_MASTER (GeneralItemName Varchar(30) Primary key)
Create Table ITEM_CATEGORIES_MASTER (ItemCategories Varchar(10) Primary Key)
Create Table ITEM_QUALITY_MASTER (ItemQuality Varchar(10) 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),CompAdd1 Varchar(40),CompAdd2 Varchar(30),CompAdd3 Varchar(30),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))
Create Table AGENT_MASTER(AgentCode Varchar(7) Primary Key,AgentName Varchar(35), AgentAdd1 Varchar(40), AgentAdd2 Varchar(30),AgentAdd3 Varchar(30),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))
Create Table GROUP_MASTER(GrpCode Varchar(7) Primary Key,GrpName Varchar(35), GrpAdd1 Varchar(40), GrpAdd2 Varchar(30),GrpAdd3 Varchar(30),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(40), AccAdd2 Varchar(30),AccAdd3 Varchar(30),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),AccOpenBal Money,AccOpenBalCrDr Varchar(2),AccSharePerc Money,AccTANNo Varchar(35),AccKSTNo Varchar(35),TDSYesNo Varchar(3),SpecialTDSYN Varchar(1),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(40), AccAdd22 Varchar(30),AccAdd23 Varchar(30),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)
Create Table GREY_ITEM_MASTER (ItemName Varchar(30) Primary Key,ItemRatePerPcs Money,ItemRatePerMts Money,ItemOpeningPcs Numeric(7),ItemOpeningMts Money,ItemOpeningValue Money)
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),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)
Create Table 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))
Create Table 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 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 RANGE_DESCRIPTION_MASTER (ItemRangeDesp Varchar(30),ExcessRate Money,ScreenName Varchar(30),PartyCode Varchar(7),JobRate Money)
Create Table 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(25),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),KSTNo Varchar(35),CSTNo Varchar(35),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)
Create Table 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(6),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 Numeric(6),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))
Create Table 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 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 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 BILL_CHALLAN_DETAIL (BillNo Varchar(8) Foreign Key References BILL_DETAIL(BillNo),ChallanNo Varchar(8))
CREATE TABLE 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 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))
Create Table 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(25),GrossAmt Money,Remark Varchar(255),TransName Varchar(35),TransLRNo Varchar(15),TransLRCase Varchar(30),TransLRDate DateTime,TransDespStation Varchar(35),UName Varchar(255),KSTNo Varchar(35),CSTNo Varchar(35),OrderForm Varchar(1),Marka Varchar(15),ContedBy Varchar(35),ManualOrderNo Varchar(50),SaleType Varchar(7),PackedBy Varchar(25),CheckedBy Varchar(25))
Create Table 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(6),PurISrNo Numeric(3))
Create Table 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 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 FINISHED_PURCHASE (SrNo Varchar(6) Primary Key,CurDate DateTime,BillNo Varchar(15),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(25),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 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,ItemGrpCut Money,ItemTopName Varchar(30),ItemTopMts Money,ItemMiddleName Varchar(30),ItemMiddleMts Money,ItemBottomName Varchar(30),ItemBottomMts Money,ItemOtherName Varchar(30),ItemOtherMts Money,ItemCutPerMtr Money,ItemMtsPerKG Money,ItemGrp Varchar(30),ItemStatus Varchar(7),ItemRangeDesp Varchar(30),OrderNo Varchar(6),OrdISrNo Numeric(3),ItemAddLess Varchar(1),ItemDisPerc Money,ItemSerialNo Numeric(6),ItemDisAmt Money,ItemBillNo Varchar(8),ItemBISrNo Numeric(3),ItemFold Money,ItemFMts Money,ISrNo Numeric(3))
Create Table 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 GREY_PURCHASE (SrNo Varchar(6) Primary Key,CurDate DateTime,BillNo Varchar(15),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(25),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))
Create Table 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)
Create Table 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 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 PAYMENT_BANK_BOOK_ADDLESS_DETAIL (BkSrNo Varchar(6) Foreign Key References PAYMENT_BANK_BOOK_DETAIL(BkSrNo),BkBillNo Varchar(15),BkDiscPerc Money,BkDiscPercAmt Money,BkRateDiff Money,BkClaimLess Money,BkBankCommission Money,BkAddInterestPerc Money,BkAddInterestPercAmt Money,BkBillPaidAmt Money,BkStatus Varchar(7),BkTDSPartyCode Varchar(7))
Create Table 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 PAYMENT_CASH_BOOK_ADDLESS_DETAIL (BkSrNo Varchar(6) Foreign Key References PAYMENT_CASH_BOOK_DETAIL(BkSrNo),BkBillNo Varchar(15),BkDiscPerc Money,BkDiscPercAmt Money,BkRateDiff Money,BkClaimLess Money,BkBankCommission Money,BkAddInterestPerc Money,BkAddInterestPercAmt Money,BkBillPaidAmt Money,BkStatus Varchar(7))
Create Table 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 RECEIVED_BANK_BOOK_ADDLESS_DETAIL (BkSrNo Varchar(6) Foreign Key References RECEIVED_BANK_BOOK_DETAIL(BkSrNo),BkBillNo Varchar(15),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 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 RECEIVED_CASH_BOOK_ADDLESS_DETAIL (BkSrNo Varchar(6) Foreign Key References RECEIVED_CASH_BOOK_DETAIL(BkSrNo),BkBillNo Varchar(15),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 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(25),CreditNoteNo Varchar(10),LessAmt Money,AddAmt Money,SaleRtnType Varchar(7),DiscPerc Money,DiscAmt Money)
Create Table RECEIVED_RETURN_GOODS_ADDLESS_DETAIL (BkSrNo Varchar(6) Foreign Key References RECEIVED_RETURN_GOODS_DETAIL(BkSrNo),BkBillNo Varchar(15),BkBillGRAmt Money,BkStatus Varchar(7),BkDescription Varchar(50),ISrNo Numeric(6))
Create TABLE 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(6),PurISrNo Numeric(6),PurRate Money,PurAmt Money,SubScreen Varchar(30))
Create Table 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 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))
Create Table GREY_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL (BkSrNo Varchar(6) Foreign Key References GREY_PURCHASE_RETURN_GOODS_DETAIL(BkSrNo),BkBillNo Varchar(15),BkItemName Varchar(30),BkCut Money,BkPcs Numeric(6),BkMts Money,BkPer Varchar(1),BkRate Money,BkBillGRAmt Money,BkStatus Varchar(7),BkLess Money,ISrNo Numeric(6),AddPerc Money,AddAmt Money)
Create Table 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 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,BkUName Varchar(255),TransName Varchar(35),TransLRNo Varchar(15),TransLRCase Varchar(30),TransLRDate DateTime,TransFromStation Varchar(35),DebitNoteNo Varchar(255),PurRtnType Varchar(7))
Create Table FINISHED_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL (BkSrNo Varchar(6) Foreign Key References FINISHED_PURCHASE_RETURN_GOODS_DETAIL(BkSrNo),BkBillNo Varchar(15),BkItemName Varchar(30),BkCut Money,BkPcs Numeric(6),BkMts Money,BkPer Varchar(1),BkRate Money,BkBillGRAmt Money,BkStatus Varchar(7),BkLess Money,ItemRangeDesp Varchar(30),ISrNo Numeric(6))
Create Table 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))
Create Table GREY_SEND_TO_MILL_TAKA_DETAIL (SrNo Varchar(6) Foreign Key References GREY_SEND_TO_MILL(SrNo),PurSrNo Varchar(6),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 FINISHED_RECEIVED_FROM_MILL (FRSrNo Varchar(6) Primary Key,CurDate DateTime,MillCode Varchar(7) Foreign Key References ACCOUNT_MASTER(AccCode),GPRecdDate DateTime,GPNo Varchar(15),GrossAmt Money,DiscPerc Money,DiscAmt Money,LessAmt Money,AddAmt Money,TDSPerc Money,TDSAmt Money,NetProcessAmt Money,GPStatus Varchar(7),UName Varchar(255),Remark Varchar(50),TDSDate DateTime)
Create Table 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))
Create Table 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 GP_RECEIVED_FROM_MILL (FRSrNo Varchar(6) Primary Key,CurDate DateTime,MillCode Varchar(7) Foreign Key References ACCOUNT_MASTER(AccCode),GPRecdDate DateTime,GPNo Varchar(15),GrossAmt Money,DiscPerc Money,DiscAmt Money,LessAmt Money,AddAmt Money,TDSPerc Money,TDSAmt Money,NetProcessAmt Money,GPStatus Varchar(7),UName Varchar(255),Remark Varchar(50),TDSAcc Varchar(7),IncomeTaxPerc Money,IncomeTaxAmt Money,SurchargePerc Money,SurchargeAmt Money,EduCessPerc Money,EduCessAmt Money,TDSType Varchar(35),TDSDate DateTime)
Create Table 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))
Create Table GENERAL_PURCHASE (SrNo Varchar(6) Primary Key,CurDate DateTime,BillNo Varchar(15),BillDate DateTime,ChallanNo Varchar(15),ChallanRecdDate DateTime,SuppCode Varchar(7) Foreign Key References ACCOUNT_MASTER(AccCode),GrossAmt Money,VatAddPerc Money,VatAddAmt Money,DiscPerc Money,DiscPercAmt Money,LessAmt Money,AddPerc Money,AddPercAmt Money,AddAmt Money,Oth1Name Varchar(20),Oth1ALType Varchar(1),Oth1Amt Money,Oth2Name Varchar(20),Oth2ALType Varchar(1),Oth2Amt Money,NetAmt Money,UName Varchar(255),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))
Create Table 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)
Create Table OPENING_FINISHED_PURCHASE (SrNo Varchar(6) Primary Key,BillNo Varchar(15),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)
Create Table OPENING_GENERAL_PURCHASE (SrNo Varchar(6) Primary Key,SuppCode Varchar(7) Foreign Key References ACCOUNT_MASTER(AccCode),BillDate DateTime,BillNo Varchar(15),NetAmt Money,BillStatus Varchar(7),UName Varchar(255),GRAmt Money,ChqAmt Money,CashAmt Money,AddLess Money,PLAcc Varchar(7))
Create Table 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(25),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))
Create Table 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(15),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))
Create Table 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 OPENING_MILL_GP (SrNo Varchar(6) Primary Key,GPNo Varchar(15),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)
Create Table OPENING_GREY_PURCHASE (SrNo Varchar(6) Primary Key,BillNo Varchar(15),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))
Create Table 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))
Create Table 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))
Create Table OPENING_SEND_TO_JOB_TAKA_DETAIL (SrNo Varchar(6) Foreign Key References OPENING_SEND_TO_JOB(SrNo),PurSrNo Varchar(6),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 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 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(15),GrossAmt Money,GPStatus Varchar(7),UName Varchar(255))
Create Table 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))
Create Table 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 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 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 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))
Create Table 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(15),StockType Varchar(35),ConSrNo Varchar(6))
Create Table SEND_TO_JOB_TAKA_DETAIL (SrNo Varchar(6) Foreign Key References SEND_TO_JOB(SrNo),PurSrNo Varchar(6),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 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 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 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))
Create Table 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(6),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))
Create Table 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 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 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))
Create Table 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(6),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))
Create Table 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 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 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 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))
Create Table 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(6),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 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 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 GREY_RECEIVED_FROM_JOB (SrNo Varchar(7) Primary Key,CurDate DateTime,BillNo Varchar(15),BillDate DateTime,ChallanNo Varchar(15),ChallanRecdDate DateTime,WeaverCode Varchar(7),NetAmt Money,Remark Varchar(50),WeaverAgentCode Varchar(7))
Create Table 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 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 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 RECEIVED_FROM_JOB (SrNo Varchar(6) Primary Key,CurDate DateTime,JobCode Varchar(7) Foreign Key References ACCOUNT_MASTER(AccCode),BillDate DateTime,BillNo Varchar(15),GrossAmt Money,DiscPerc Money,DiscAmt Money,LessAmt Money,AddAmt Money,TDSPerc Money,TDSAmt Money,NetAmt Money,TransName Varchar(35),TransLRNo Varchar(15),TransLRCase Varchar(30),TransLRDate DateTime,TransDespStation Varchar(35),BillStatus Varchar(7),UName Varchar(255),Remark Varchar(50),TDSAcc Varchar(7),IncomeTaxPerc Money,IncomeTaxAmt Money,SurchargePerc Money,SurchargeAmt Money,EduCessPerc Money,EduCessAmt Money,TDSType Varchar(35),TDSDate DateTime,Shortage Money,AgentCode Varchar(7) Foreign Key References AGENT_MASTER(AgentCode))
Create Table 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(6),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))
Create Table OPENING_RECEIVED_FROM_JOB (SrNo Varchar(6) Primary Key,JobCode Varchar(7) Foreign Key References ACCOUNT_MASTER(AccCode),BillDate DateTime,BillNo Varchar(15),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))
Create Table OPENING_GREY_AT_SHOP (SrNo Varchar(6) Primary Key,BillNo Varchar(8),BillDate DateTime,ChallanNo Varchar(8),ChallanRecdDate DateTime,WeaverCode Varchar(7) Foreign Key References ACCOUNT_MASTER(AccCode),GrossAmt Money,UName Varchar(255),TransName Varchar(35),TransLRNo Varchar(15))
Create Table OPENING_GREY_AT_SHOP_ITEM_DETAIL (SrNo Varchar(6) 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))
Create Table OPENING_GREY_AT_SHOP_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 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 TDS_TCS_CHALLAN_TDS_TYPE_DETAIL (SrNo Varchar(6) Foreign Key References TDS_TCS_CHALLAN (SrNo),TDSType Varchar(35))
Create Table 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 BILL_ACCOUNT_TYPES (AccCode Varchar(7) Foreign Key References ACCOUNT_MASTER(AccCode))
Create Table FINISHED_PURCHASE_ACCOUNT_TYPES (AccCode Varchar(7) Foreign Key References ACCOUNT_MASTER(AccCode))
Create Table GREY_PURCHASE_ACCOUNT_TYPES (AccCode Varchar(7) Foreign Key References ACCOUNT_MASTER(AccCode))
Create Table RETURN_GOODS_ACCOUNT_TYPES (AccCode Varchar(7) Foreign Key References ACCOUNT_MASTER(AccCode))
Create Table GREY_RETURN_ACCOUNT_TYPES (AccCode Varchar(7) Foreign Key References ACCOUNT_MASTER(AccCode))
Create Table FINISHED_RETURN_ACCOUNT_TYPES (AccCode Varchar(7) Foreign Key References ACCOUNT_MASTER(AccCode))
Create Table 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 BANK_BOOK_CHEQUE_RETURN_ADDLESS_DETAIL (BkSrNo Varchar(6) Foreign Key References BANK_BOOK_CHEQUE_RETURN_DETAIL(BkSrNo),BkBillNo Varchar(15),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 GREY_SEND_TO_MILL_PROGRAM (ProgName Varchar(255))
Create Table 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))
Create Table 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 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 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 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 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(25),GrossAmt Money,UName Varchar(255),OrderStatus Varchar(7),Remark Varchar(50),DueDays Numeric(6))
Create Table 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 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(25),GrossAmt Money,UName Varchar(255),OrderStatus Varchar(7),Remark Varchar(50))
Create Table 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,ItemGrpCut Money,ItemTopName Varchar(30),ItemTopMts Money,ItemMiddleName Varchar(30),ItemMiddleMts Money,ItemBottomName Varchar(30),ItemBottomMts Money,ItemOtherName Varchar(30),ItemOtherMts Money,ItemCutPerMtr Money,ItemMtsPerKG Money,ItemGrp Varchar(30),ItemStatus Varchar(7),ItemRangeDesp Varchar(30),ItemSrNo Numeric(3))
Create Table 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(25),GrossAmt Money,UName Varchar(255),OrderStatus Varchar(7),Remark Varchar(50))
Create Table 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,ItemGrpCut Money,ItemTopName Varchar(30),ItemTopMts Money,ItemMiddleName Varchar(30),ItemMiddleMts Money,ItemBottomName Varchar(30),ItemBottomMts Money,ItemOtherName Varchar(30),ItemOtherMts Money,ItemCutPerMtr Money,ItemMtsPerKG Money,ItemGrp Varchar(30),ItemStatus Varchar(7),ItemRangeDesp Varchar(30),ItemSrNo Numeric(3))
Create Table 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 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 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 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 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 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 PRINTING_MASTER (MasterName Varchar(35),Phone Varchar(30),Mobile Varchar(30),EmailID Varchar(30),MillCode Varchar(7))
Create Table 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(25),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),KSTNo Varchar(35),CSTNo Varchar(35),TransFreight Money,TransWeight Money,BaleOrderNo Varchar(6),BaleOrderNoSerial Varchar(1),PartyOrdNo Varchar(25))
Create Table 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(6),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)
Create Table 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))
Create Table 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(25),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),KSTNo Varchar(35),CSTNo Varchar(35),TransFreight Money,TransWeight Money,BaleOrderNo Varchar(6),BaleOrderNoSerial Varchar(1),PartyOrdNo Varchar(25))
Create Table 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(6),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)
Create Table 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))
Create Table 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))
Create Table 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(15),VouNo Varchar(6),JVDate DateTime,BkRemark Varchar(255),BkStatus Varchar(7),BkBillNo2 Varchar(15),BkStatus2 Varchar(7))
Create Table 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(25),GrossAmt Money,UName Varchar(255),OrderStatus Varchar(7),Remark Varchar(50),DueDays Numeric(6))
Create Table 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 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 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(6),PurISrNo Numeric(6),ScreenName Varchar(30))
Create TABLE 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))
Create TABLE BILLS_SCAN_BALANCE_SHEET (SrNo Varchar(700),FormName Varchar(700),Bills Varchar(700),BillNo Varchar(700))
Create Table 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 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 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 COMPANY_SETTING(SettingName Varchar(255),SettingStatus Varchar(255))
Create Table MARKING_LEDGER_REPORT(Marking Varchar(50))
Create TABLE GREY_ITEM_WISE_FINISHED_STOCK (ItemName Varchar(30),OpenStock Money)
Create TABLE OPENING_WITHOUT_WORK_STOCK (ItemName Varchar(30),OpenStock Money,OpenStockPcs Numeric(13))
Create Table 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))
Create Table 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 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 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 CUTTING_AFTER_JOB (SrNo Varchar(6) Primary Key,EntNo Varchar(15),CutDate DateTime,Remark Varchar(255))
Create TABLE 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 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 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 OPENING_LR_GREY_PURCHASE (SrNo Varchar(6) Primary Key,CurDate DateTime,BillNo Varchar(8),BillDate DateTime,ChallanNo Varchar(8),ChallanRecdDate DateTime,WeaverCode Varchar(7) Foreign Key References ACCOUNT_MASTER(AccCode),WeaverAgentCode Varchar(7) Foreign Key References AGENT_MASTER(AgentCode),Haste Varchar(25),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)
Create Table 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)
Create Table 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 UPDATE_DETAIL (SoftName Varchar(35),UpdDate DateTime,UpdTime DateTime,UpdNo Money)