[account_balance]
AB_Id=decimal,0
AB_Year1=decimal,0
AB_Year2=decimal,0
AB_Year=varchar,0
AB_AccId=decimal,0
AB_Opening=decimal,2
AB_OpeningSign=char,0
AB_Closing=decimal,2
AB_ClosingSign=char,0
AB_DeleteFlag=varchar,0
[account_detail]
AD_AccId=decimal,0
AD_UserId=decimal,0
AD_Brand=varchar,0
AD_CtPerson1=varchar,0
AD_CtPerson2=varchar,0
AD_Address1=varchar,0
AD_Address2=varchar,0
AD_Address3=varchar,0
AD_Area=varchar,0
AD_City=varchar,0
AD_Pin=varchar,0
AD_State=varchar,0
AD_Country=varchar,0
AD_Phone_O1=varchar,0
AD_Phone_O2=varchar,0
AD_Phone_R=varchar,0
AD_Fax=varchar,0
AD_BankACnum=varchar,0
AD_Mobile1=varchar,0
AD_Mobile2=varchar,0
AD_Email=varchar,0
AD_Website=varchar,0
AD_DLNo1=varchar,0
AD_DLNo2=varchar,0
AD_PrintingAddress=varchar,0
AD_CSTNo=varchar,0
AD_TinNo=varchar,0
AD_PANNo=varchar,0
AD_AadharNo=varchar,0
AD_LicenceNo=varchar,0
AD_Licencedate=datetime,0
AD_ECCNo=varchar,0
AD_ESICNo=varchar,0
AD_OANo=varchar,0
AD_RegistrationNo=varchar,0
AD_PFNo=varchar,0
AD_Division=varchar,0
AD_Range=varchar,0
AD_Comm=varchar,0
AD_ExtraNo1=varchar,0
AD_ExtraNo2=varchar,0
AD_AgentId1=decimal,0
AD_AgentId2=decimal,0
AD_HasteId=decimal,0
AD_PartyId=decimal,0
AD_MainParty=char,0
AD_ShowInAll=varchar,0
AD_Transport=varchar,0
AD_TransportId=decimal,0
AD_DBCPerc=varchar,0
AD_QtyDisc=varchar,0
AD_APPDays=decimal,0
AD_CreditDays=decimal,0
AD_CreditLimit=decimal,2
AD_Discount=decimal,2
AD_Discount2=decimal,2
AD_RDRate=decimal,2
AD_UsedInVat=char,0
AD_TaxTypeId=decimal,0
AD_InvTypeId=decimal,0
AD_TaxPer=decimal,2
AD_TaxForm=varchar,0
AD_TaxFormDesc=varchar,0
AD_VatType=varchar,0
AD_Tax1AccId=decimal,0
AD_TDSPer=decimal,3
AD_TDSFlag=char,0
AD_TCSPer=decimal,3
AD_TCSFlag=char,0
AD_CtPerson3=varchar,0
AD_CtPerson4=varchar,0
AD_CtPerson5=varchar,0
AD_CtMob1=varchar,0
AD_CtMob2=varchar,0
AD_CtMob3=varchar,0
AD_CtMob4=varchar,0
AD_CtMob5=varchar,0
AD_CtChk1=char,0
AD_CtChk2=char,0
AD_CtChk3=char,0
AD_CtChk4=char,0
AD_CtChk5=char,0
AD_RateListId=decimal,0
AD_BankName=varchar,0
AD_BranchName=varchar,0
AD_IFCSCode=varchar,0
AD_CashCredit=varchar,0
AD_DeleteFlag=varchar,0
AD_Remarks=varchar,0
AD_CINNo=varchar,0
AD_DeliveryAt=varchar,0
AD_BlackCustFlag=varchar,0
AD_CommType=varchar,0
AD_CommRate=decimal,2
AD_TinPassword=varchar,0
AD_District=varchar,0
AD_CGSTNo=varchar,0
AD_IGSTNo=varchar,0
AD_SGSTNo=varchar,0
AD_GState=varchar,0
AD_GStateCode=varchar,0
AD_Distance=decimal,0
AD_GSTType=varchar,0
AD_LicenceExpdate=datetime,0
AD_ReferenceName=varchar,0
AD_ReferenceNo=varchar,0
AD_ReputedPersonName=varchar,0
AD_ReputedPersonNo=varchar,0
AD_IsExportIGST=tinyint,0
AD_Chithiday=varchar,0
AD_FromTime=time,0
AD_ToTime=time,0
AD_PaymentDay=varchar,0
AD_PaymentFrom=time,0
AD_PaymentTo=time,0
AD_LoginId=varchar,0
AD_LoginPassword=varchar,0
AD_ItemRateType=varchar,0
AD_CIR=decimal,2
AD_Birthdate=datetime,0
AD_PODCharges=decimal,2
[account_master]
AM_AccId=decimal,0
AM_MacId=decimal,0
AM_RecId=decimal,0
AM_UserId=decimal,0
AM_AccCode=varchar,0
AM_AccName=varchar,0
AM_AccAlias=varchar,0
AM_AccType=varchar,0
AM_Flag=varchar,0
AM_GrpNo=decimal,0
AM_SubGrpNo=decimal,0
AM_Level=decimal,0
AM_Year=varchar,0
AM_Opening=decimal,2
AM_OpeningSign=char,0
AM_Closing=decimal,2
AM_ClosingSign=char,0
AM_Remarks=varchar,0
AM_OpeningFlag=char,0
AM_DeleteFlag=varchar,0
AM_Prefix=varchar,0
AM_Suffix=varchar,0
AM_Type=varchar,0
AM_SubType=varchar,0
AM_UpOpening=varchar,0
AM_WhatsappNo=varchar,0
AM_EntryDate=datetime,0
AM_ModifiedDate=datetime,0
AM_CustType=varchar,0
[barcode_setting]
B_Id=decimal,0
B_Number=decimal,0
B_Character=char,0
[category_master]
CM_Id=decimal,0
CM_Name=varchar,0
CM_Flag=varchar,0
CM_GrpId=decimal,0
CM_Remarks=varchar,0
[challan_master]
IM_Id=decimal,0
IM_MacId=decimal,0
IM_RecId=decimal,0
IM_UserId=decimal,0
IM_Year=varchar,0
IM_Type=varchar,0
IM_TaxTypeId=decimal,0
IM_InvoiceTypeId=decimal,0
IM_Prefix=varchar,0
IM_Suffix=varchar,0
IM_InvNo=decimal,0
IM_InvoiceNo=varchar,0
IM_StrInvNo=varchar,0
IM_EntryDate=datetime,0
IM_ModifiedDate=datetime,0
IM_Date=datetime,0
IM_Time=datetime,0
IM_Category=varchar,0
IM_SubCategory=varchar,0
IM_OrderNo=varchar,0
IM_OrderDate=datetime,0
IM_ChallanNo=varchar,0
IM_ChallanDate=datetime,0
IM_LRNo=varchar,0
IM_LRDate=datetime,0
IM_CustRefNo=varchar,0
IM_CustRefDate=datetime,0
IM_AONo=varchar,0
IM_AODate=datetime,0
IM_OtherRef=varchar,0
IM_BaleNo=varchar,0
IM_NoOfBale=decimal,0
IM_CashCredit=varchar,0
IM_CPartyId=decimal,0
IM_CustId=decimal,0
IM_Cust2Id=decimal,0
IM_CustAdd=varchar,0
IM_SPartyId=decimal,0
IM_SuppId=decimal,0
IM_Supp2Id=decimal,0
IM_SuppAdd=varchar,0
IM_SalesAccId=decimal,0
IM_Tax1AccId=decimal,0
IM_Tax2AccId=decimal,0
IM_Tax3AccId=decimal,0
IM_SalesDrAccId=decimal,0
IM_AgentId=decimal,0
IM_SubAgentId=decimal,0
IM_HasteId=decimal,0
IM_TransportId=decimal,0
IM_SalesManId=decimal,0
IM_SubSalesManId=decimal,0
IM_Transport=varchar,0
IM_From=varchar,0
IM_To=varchar,0
IM_DeliveryAt=varchar,0
IM_Freight=varchar,0
IM_Weight=varchar,0
IM_Courier=varchar,0
IM_Insurance=varchar,0
IM_RNo=varchar,0
IM_Remarks1=varchar,0
IM_Remarks2=varchar,0
IM_Remarks3=varchar,0
IM_Note1=varchar,0
IM_Note2=varchar,0
IM_Note3=varchar,0
IM_TotalAmt01=decimal,2
IM_Charges01AccId=decimal,0
IM_Charges01Desc=varchar,0
IM_Charges01Perc=varchar,0
IM_Charges01Amt=decimal,2
IM_Charges02AccId=decimal,0
IM_Charges02Desc=varchar,0
IM_Charges02Perc=varchar,0
IM_Charges02Amt=decimal,2
IM_Charges03AccId=decimal,0
IM_Charges03Desc=varchar,0
IM_Charges03Perc=varchar,0
IM_Charges03Amt=decimal,2
IM_Charges04AccId=decimal,0
IM_Charges04Desc=varchar,0
IM_Charges04Perc=varchar,0
IM_Charges04Amt=decimal,2
IM_Charges05AccId=decimal,0
IM_Charges05Desc=varchar,0
IM_Charges05Perc=varchar,0
IM_Charges05Amt=decimal,2
IM_TotalAmt02=decimal,2
IM_Tax01AccId=decimal,0
IM_Tax01Desc=varchar,0
IM_Tax01Perc=varchar,0
IM_Tax01Amt=decimal,2
IM_Tax02AccId=decimal,0
IM_Tax02Desc=varchar,0
IM_Tax02Perc=varchar,0
IM_Tax02Amt=decimal,2
IM_Tax03AccId=decimal,0
IM_Tax03Desc=varchar,0
IM_Tax03Perc=varchar,0
IM_Tax03Amt=decimal,2
IM_Tax04AccId=decimal,0
IM_Tax04Desc=varchar,0
IM_Tax04Perc=varchar,0
IM_Tax04Amt=decimal,2
IM_Tax05AccId=decimal,0
IM_Tax05Desc=varchar,0
IM_Tax05Perc=varchar,0
IM_Tax05Amt=decimal,2
IM_TotalAmt03=decimal,2
IM_Charges06AccId=decimal,0
IM_Charges06Desc=varchar,0
IM_Charges06Perc=varchar,0
IM_Charges06Amt=decimal,2
IM_Charges07AccId=decimal,0
IM_Charges07Desc=varchar,0
IM_Charges07Perc=varchar,0
IM_Charges07Amt=decimal,2
IM_Charges08AccId=decimal,0
IM_Charges08Desc=varchar,0
IM_Charges08Perc=varchar,0
IM_Charges08Amt=decimal,2
IM_Charges09AccId=decimal,0
IM_Charges09Desc=varchar,0
IM_Charges09Perc=varchar,0
IM_Charges09Amt=decimal,2
IM_Charges10AccId=decimal,0
IM_Charges10Desc=varchar,0
IM_Charges10Perc=varchar,0
IM_Charges10Amt=decimal,2
IM_TotalAmt04=decimal,2
IM_Tax06AccId=decimal,0
IM_Tax06Desc=varchar,0
IM_Tax06Perc=varchar,0
IM_Tax06Amt=decimal,2
IM_Tax07AccId=decimal,0
IM_Tax07Desc=varchar,0
IM_Tax07Perc=varchar,0
IM_Tax07Amt=decimal,2
IM_Tax08AccId=decimal,0
IM_Tax08Desc=varchar,0
IM_Tax08Perc=varchar,0
IM_Tax08Amt=decimal,2
IM_Tax09AccId=decimal,0
IM_Tax09Desc=varchar,0
IM_Tax09Perc=varchar,0
IM_Tax09Amt=decimal,2
IM_Tax10AccId=decimal,0
IM_Tax10Desc=varchar,0
IM_Tax10Perc=varchar,0
IM_Tax10Amt=decimal,2
IM_TotalAmt05=decimal,2
IM_Charges11AccId=decimal,0
IM_Charges11Desc=varchar,0
IM_Charges11Perc=varchar,0
IM_Charges11Amt=decimal,2
IM_Charges12AccId=decimal,0
IM_Charges12Desc=varchar,0
IM_Charges12Perc=varchar,0
IM_Charges12Amt=decimal,2
IM_Charges13AccId=decimal,0
IM_Charges13Desc=varchar,0
IM_Charges13Perc=varchar,0
IM_Charges13Amt=decimal,2
IM_Charges14AccId=decimal,0
IM_Charges14Desc=varchar,0
IM_Charges14Perc=varchar,0
IM_Charges14Amt=decimal,2
IM_Charges15AccId=decimal,0
IM_Charges15Desc=varchar,0
IM_Charges15Perc=varchar,0
IM_Charges15Amt=decimal,2
IM_TotalAmt06=decimal,2
IM_RndOffAccId=decimal,0
IM_RndOff=decimal,2
IM_AddAmt=decimal,2
IM_LessAmt=decimal,2
IM_BillAmt=decimal,2
IM_RefAmt=decimal,2
IM_AmtInWords=varchar,0
IM_GSTNo=varchar,0
IM_GTotalAmt01=decimal,2
IM_GDiscAmt=decimal,2
IM_GDiscAmt1=decimal,2
IM_GTaxable=decimal,2
IM_GCGST=decimal,2
IM_GSGST=decimal,2
IM_GIGST=decimal,2
IM_GST=decimal,2
IM_CessAmt=decimal,2
IM_GNetAmt=decimal,2
IM_Pcs=decimal,2
IM_Mtrs=decimal,2
IM_GSTApproved=varchar,0
IM_AddInStock=varchar,0
IM_VoucherId=decimal,0
IM_PymtDays=decimal,0
IM_PaymentRemarks=varchar,0
IM_ChallanIds=varchar,0
IM_OrderId=decimal,0
IM_Previous=varchar,0
IM_Next=varchar,0
IM_Paid=varchar,0
IM_Cleared=char,0
IM_ManualCLeared=char,0
IM_PackedBy=varchar,0
IM_PackingCharges=decimal,2
IM_PackingPaidFlag=varchar,0
IM_DeliverdBy=varchar,0
IM_DeliveryCharges=decimal,2
IM_DeliveryPaidFlag=varchar,0
IM_NetPymtDays=decimal,0
IM_DiscPer=decimal,2
IM_DeliverDate=datetime,0
IM_RateListId=decimal,0
IM_Chrg1Amt=decimal,2
IM_Chrg2Amt=decimal,2
IM_Chrg3Amt=decimal,2
IM_Chrg4Amt=decimal,2
IM_Chrg5Amt=decimal,2
IM_Chrg6Amt=decimal,2
IM_Chrg7Amt=decimal,2
IM_Chrg8Amt=decimal,2
IM_Chrg9Amt=decimal,2
IM_Chrg10Amt=decimal,2
IM_Chrg11Amt=decimal,2
IM_Chrg12Amt=decimal,2
IM_RcvdDate=datetime,0
IM_NetAmt=decimal,2
IM_GRAmt=decimal,2
IM_CommAmt=decimal,2
IM_VchNo=varchar,0
IM_GrNo=varchar,0
IM_GRDate=datetime,0
IM_CommPer=decimal,2
IM_AgentCommPer=decimal,2
IM_ASCommPer=decimal,2
IM_CommDue=decimal,2
IM_CommRcvd=decimal,2
IM_CommFlag=char,0
IM_SComm=decimal,2
IM_SSComm=decimal,2
IM_SCommType=varchar,0
IM_VId=decimal,0
IM_RefId=decimal,0
IM_RcvdChallan=varchar,0
IM_RMClear=varchar,0
IM_RClear=varchar,0
IM_CommId=decimal,0
IM_RcvdForm=varchar,0
IM_FormNo=varchar,0
IM_FormDate=datetime,0
IM_ReverseCharge=varchar,0
IM_RndFlag=varchar,0
IM_TDSRndFlag=varchar,0
IM_IsExportIGST=tinyint,0
IM_Distance=decimal,2
IM_VehicleNo=varchar,0
IM_VehicleType=varchar,0
IM_TransMode=varchar,0
IM_StockFlag=varchar,0
IM_StockReferenceFlag=varchar,0
IM_VoucherFlag=varchar,0
IM_ReferenceFlag=varchar,0
IM_CtPerson1=varchar,0
IM_RateTypeFlag=varchar,0
IM_EwayBillNo=varchar,0
IM_EwayBillDate=datetime,0
IM_EwayBillRemarks=varchar,0
IM_EwayFlag=varchar,0
IM_EwayCtr=decimal,0
IM_EwayStatus=varchar,0
IM_EwayTransactionType=varchar,0
IM_TCSRndFlag=varchar,0
IM_IsCancel=tinyint,0
IM_Cancelled=varchar,0
IM_DiscPer1=decimal,2
IM_DiscAmt1=decimal,2
IM_PerformaNo=int,0
IM_InvoiceType=varchar,0
[challan_transaction]
IT_Id=decimal,0
IT_SrNo=decimal,0
IT_SerialNo=decimal,0
IT_ItemId=decimal,0
IT_ItemId1=decimal,0
IT_Cut=decimal,2
IT_Packing=decimal,2
IT_Pcs=decimal,2
IT_Mtrs=decimal,2
IT_RateType=varchar,0
IT_StockQty=decimal,2
IT_InvQty=decimal,2
IT_Rate=decimal,2
IT_SubTotal=decimal,2
IT_Desc1=varchar,0
IT_Desc2=varchar,0
IT_Desc3=varchar,0
IT_Desc4=varchar,0
IT_Remark1=varchar,0
IT_Remark2=varchar,0
IT_Remark3=varchar,0
IT_Remark4=varchar,0
IT_Extra1=varchar,0
IT_Extra2=varchar,0
IT_Extra3=varchar,0
IT_Extra4=varchar,0
IT_StockRemarks=varchar,0
IT_ChallanId=decimal,0
IT_OrderId=decimal,0
IT_RefId=decimal,0
IT_RefType=varchar,0
IT_CLeared=char,0
IT_ManualCLeared=char,0
IT_DisPer=decimal,2
IT_DisPer1=decimal,2
IT_VatPer=decimal,2
IT_AddTaxPer=decimal,2
IT_DisAmt=decimal,2
IT_DisAmt1=decimal,2
IT_RGPer=decimal,2
IT_RGAmt=decimal,2
IT_RDPer=decimal,2
IT_RDAmt=decimal,2
IT_VatAmt=decimal,2
IT_AddtaxAmt=decimal,2
IT_ToatalRare1=decimal,2
IT_ToatalRare2=decimal,2
IT_ToatalRare3=decimal,2
IT_MRP=decimal,2
IT_PTS=decimal,2
IT_PTR=decimal,2
IT_FreeQty=decimal,2
IT_CustRefNo=varchar,0
IT_CustRefDate=datetime,0
IT_ExpDate=datetime,0
IT_MfgDate=datetime,0
IT_Flag=decimal,0
IT_XS=decimal,2
IT_S=decimal,2
IT_M=decimal,2
IT_L=decimal,2
IT_XL=decimal,2
IT_2XL=decimal,2
IT_3XL=decimal,2
IT_4XL=decimal,2
IT_5XL=decimal,2
IT_6XL=decimal,2
IT_7XL=decimal,2
IT_8XL=decimal,2
IT_9XL=decimal,2
IT_10XL=decimal,2
IT_FREESIZE=decimal,2
IT_Color=varchar,0
IT_ColorIds=varchar,0
IT_Size=varchar,0
IT_Godown=varchar,0
IT_CGSTPer=decimal,2
IT_CGSTAmt=decimal,2
IT_SGSTPer=decimal,2
IT_SGSTAmt=decimal,2
IT_IGSTPer=decimal,2
IT_IGSTAmt=decimal,2
IT_GSTPer=decimal,2
IT_TotalGST=decimal,2
IT_CessPer=decimal,2
IT_CessAmt=decimal,2
IT_Total1=decimal,2
IT_TaxablAmt=decimal,2
IT_HSNId=decimal,0
IT_UnitId=decimal,0
IT_IsExportIGST=tinyint,0
IT_StockFlag=varchar,0
IT_CessCalculateOn=varchar,0
[challan_transaction1]
IT_Id=decimal,0
IT_SrNo=decimal,0
IT_SerialNo=decimal,0
IT_ChallanId=decimal,0
IT_OrderId=decimal,0
IT_ItemId=decimal,0
IT_Amount=decimal,2
IT_Amount1=decimal,2
IT_Amount2=decimal,2
IT_BillNo=varchar,0
IT_BillDate=datetime,0
IT_EwayBillNo=varchar,0
IT_EwayBillDate=datetime,0
IT_EwayBillValidateDate=datetime,0
IT_EwayBillRemarks=varchar,0
IT_Remarks=varchar,0
IT_Remarks1=varchar,0
IT_Remarks2=varchar,0
[cmp_master]
cm_id=int,0
cm_clientid=varchar,0
cm_clientcode=varchar,0
cm_clientname=varchar,0
cm_purchasedate=datetime,0
cm_licensedate=datetime,0
cm_license=varchar,0
cm_ewaydate=datetime,0
cm_ewayflag=varchar,0
cm_ewaybillctr=int,0
cm_ewaybillwarning=int,0
[color_master]
CM_Id=decimal,0
CM_MacId=decimal,0
CM_RecId=decimal,0
CM_UserId=decimal,0
CM_Year=varchar,0
CM_ColorName=varchar,0
CM_ColorCode=varchar,0
CM_Shade=varchar,0
CM_Extra1=varchar,0
CM_Extra2=varchar,0
CM_DeleteFlag=varchar,0
[company_master]
CMP_Id=decimal,0
CMP_Code=char,0
CMP_Name=varchar,0
CMP_Address1=varchar,0
CMP_Address2=varchar,0
CMP_Address3=varchar,0
CMP_Area=varchar,0
CMP_City=varchar,0
CMP_Pin=varchar,0
CMP_State=varchar,0
CMP_Country=varchar,0
CMP_Phone_01=varchar,0
CMP_Phone_02=varchar,0
CMP_Phone_R=varchar,0
CMP_Fax=varchar,0
CMP_Mobile1=varchar,0
CMP_Mobile2=varchar,0
CMP_Email=varchar,0
CMP_Website=varchar,0
CMP_PrintingAddress=varchar,0
CMP_DLNo1=varchar,0
CMP_DLNo2=varchar,0
CMP_CSTNo=varchar,0
CMP_TinNo=varchar,0
CMP_PANNo=varchar,0
CMP_ServiceTaxNo=varchar,0
CMP_ECCNo=varchar,0
CMP_ESICNo=varchar,0
CMP_OANo=varchar,0
CMP_RegistrationNo=varchar,0
CMP_PFNo=varchar,0
CMP_Division=varchar,0
CMP_Range=varchar,0
CMP_Comm=varchar,0
[complaint_master]
cm_id=decimal,0
cm_macid=decimal,0
cm_recid=decimal,0
cm_userid=decimal,0
cm_year=varchar,0
cm_branchid=decimal,0
cm_servicetype=varchar,0
cm_servicetypeid=decimal,0
cm_entrydate=datetime,0
cm_modifieddate=datetime,0
cm_date=datetime,0
cm_rcvdondate=datetime,0
cm_prefix=varchar,0
cm_suffix=varchar,0
cm_no=decimal,0
cm_compno=varchar,0
cm_complainno=varchar,0
cm_custid=decimal,0
cm_mobno=varchar,0
cm_phoneno=varchar,0
cm_custadress=varchar,0
cm_email=varchar,0
cm_itemid=decimal,0
cm_ModelDesc=varchar,0
cm_productseriolno=varchar,0
cm_broughtby=varchar,0
cm_accessoriesrcvd=varchar,0
cm_accessoriesname1=varchar,0
cm_accessoriesname2=varchar,0
cm_accessoriesname3=varchar,0
cm_accessoriesname4=varchar,0
cm_accessoriesname5=varchar,0
cm_accessoriesname6=varchar,0
cm_accessoriesname7=varchar,0
cm_accessoriesname8=varchar,0
cm_accessoriesname9=varchar,0
cm_accessoriesremarks=varchar,0
cm_observation1=varchar,0
cm_observation2=varchar,0
cm_observation3=varchar,0
cm_observation4=varchar,0
cm_observation5=varchar,0
cm_observation6=varchar,0
cm_observation7=varchar,0
cm_observation8=varchar,0
cm_observation9=varchar,0
cm_observation10=varchar,0
cm_description=varchar,0
cm_productcollectedby=varchar,0
cm_priority=varchar,0
cm_status=varchar,0
cm_remarks1=varchar,0
cm_remarks2=varchar,0
cm_remarks3=varchar,0
cm_extra1=varchar,0
cm_extra2=varchar,0
cm_extra3=varchar,0
[complaints_master]
sm_id=decimal,0
sm_srno=decimal,0
sm_userid=decimal,0
sm_process=varchar,0
sm_entrydate=datetime,0
sm_modifieddate=datetime,0
sm_date=datetime,0
sm_days=decimal,0
sm_deliverydate=datetime,0
sm_amount=decimal,0
sm_amountinwords=varchar,0
sm_status=varchar,0
sm_givenby=varchar,0
sm_ctperson1=varchar,0
sm_ctperson2=varchar,0
sm_ctperson3=varchar,0
sm_remarks1=varchar,0
sm_remarks2=varchar,0
sm_remarks3=varchar,0
sm_idprooftype=varchar,0
sm_idprooftnum=varchar,0
[dashboard]
d_id=int,0
d_syncdate=datetime,0
d_header=varchar,0
d_amt1=decimal,2
d_amt2=decimal,2
d_amt3=decimal,3
d_flag=varchar,0
d_clientcode=varchar,0
d_clientname=varchar,0
d_clientid=varchar,0
d_fromdate=datetime,0
d_todate=datetime,0
d_accid=int,0
d_accname=varchar,0
d_closing=decimal,2
d_closingsign=varchar,0
[distance_master]
D_Id=decimal,0
D_FromCity=varchar,0
D_ToCity=varchar,0
D_KM=decimal,2
D_Remarks=varchar,0
[ewayaapi_errorlog]
e_id=int,0
e_type=varchar,0
e_entrydate=datetime,0
e_fromgstno=varchar,0
e_fromname=varchar,0
e_togstno=varchar,0
e_toname=varchar,0
e_billno=varchar,0
e_billdate=datetime,0
e_apierror=varchar,0
e_error=varchar,0
[ewayaapi_manager]
e_id=int,0
e_type=varchar,0
e_entrydate=datetime,0
e_fromgstno=varchar,0
e_fromname=varchar,0
e_status=varchar,0
e_apiresponse=varchar,0
e_clientid=int,0
e_clientname=varchar,0
e_clientcode=varchar,0
e_action=varchar,0
e_billno=varchar,0
e_billdate=datetime,0
e_custgstno=varchar,0
e_custname=varchar,0
e_frompincode=varchar,0
e_topincode=varchar,0
e_distance=decimal,0
e_billamt=decimal,2
e_uploadflag=varchar,0
[financial_year]
F_Id=int,0
F_Year=varchar,0
F_FirstYear=int,0
F_ToYear=int,0
F_Fromdate=datetime,0
F_ToDate=datetime,0
F_YearId=int,0
[g_hsn_master]
HM_Id=decimal,0
HM_Chapter=decimal,0
HM_Heading=decimal,0
HM_SubHeading=decimal,0
HM_HSNCode=varchar,0
HM_Desc=varchar,0
HM_GSTPerc=decimal,2
HM_CGST=decimal,2
HM_SGST=decimal,2
HM_IGST=decimal,2
HM_Cess=decimal,2
HM_GSTPercExport=decimal,2
HM_CGSTExport=decimal,2
HM_SGSTExport=decimal,2
HM_IGSTExport=decimal,2
HM_CessExport=decimal,2
HM_Remarks=varchar,0
HM_RateWiseSlabs=varchar,0
HM_DeleteFlag=varchar,0
HM_CessCalculateOn=varchar,0
[g_hsn_transaction]
HT_Id=decimal,0
HT_StartRate=decimal,2
HT_EndRate=decimal,2
HT_GSTPerc=decimal,2
HT_CGST=decimal,2
HT_SGST=decimal,2
HT_IGST=decimal,2
HT_Cess=decimal,2
HT_GSTPercExport=decimal,2
HT_CGSTExport=decimal,2
HT_SGSTExport=decimal,2
HT_IGSTExport=decimal,2
HT_CessExport=decimal,2
HT_Desc=varchar,0
[godown_master]
GM_Id=decimal,0
GM_MacId=decimal,0
GM_RecId=decimal,0
GM_UserId=decimal,0
GM_Code=varchar,0
GM_Name=varchar,0
GM_Alias=varchar,0
GM_Address1=varchar,0
GM_Address2=varchar,0
GM_Address3=varchar,0
GM_City=varchar,0
GM_Pin=varchar,0
GM_State=varchar,0
GM_PrintingAddress=varchar,0
GM_Desc=varchar,0
[invoice_master]
IM_Id=decimal,0
IM_MacId=decimal,0
IM_RecId=decimal,0
IM_UserId=decimal,0
IM_Year=varchar,0
IM_Type=varchar,0
IM_TaxTypeId=decimal,0
IM_InvoiceTypeId=decimal,0
IM_Prefix=varchar,0
IM_Suffix=varchar,0
IM_InvNo=decimal,0
IM_InvoiceNo=varchar,0
IM_StrInvNo=varchar,0
IM_EntryDate=datetime,0
IM_ModifiedDate=datetime,0
IM_Date=datetime,0
IM_Time=datetime,0
IM_Category=varchar,0
IM_SubCategory=varchar,0
IM_OrderNo=varchar,0
IM_OrderDate=datetime,0
IM_ChallanNo=varchar,0
IM_ChallanDate=datetime,0
IM_LRNo=varchar,0
IM_LRDate=datetime,0
IM_CustRefNo=varchar,0
IM_CustRefDate=datetime,0
IM_AONo=varchar,0
IM_AODate=datetime,0
IM_OtherRef=varchar,0
IM_BaleNo=varchar,0
IM_NoOfBale=decimal,0
IM_CashCredit=varchar,0
IM_CPartyId=decimal,0
IM_CustId=decimal,0
IM_Cust2Id=decimal,0
IM_CustAdd=varchar,0
IM_SPartyId=decimal,0
IM_SuppId=decimal,0
IM_Supp2Id=decimal,0
IM_SuppAdd=varchar,0
IM_SalesAccId=decimal,0
IM_Tax1AccId=decimal,0
IM_Tax2AccId=decimal,0
IM_Tax3AccId=decimal,0
IM_SalesDrAccId=decimal,0
IM_AgentId=decimal,0
IM_SubAgentId=decimal,0
IM_HasteId=decimal,0
IM_TransportId=decimal,0
IM_SalesManId=decimal,0
IM_SubSalesManId=decimal,0
IM_Transport=varchar,0
IM_From=varchar,0
IM_To=varchar,0
IM_DeliveryAt=varchar,0
IM_Freight=varchar,0
IM_Weight=varchar,0
IM_Courier=varchar,0
IM_Insurance=varchar,0
IM_RNo=varchar,0
IM_Remarks1=varchar,0
IM_Remarks2=varchar,0
IM_Remarks3=varchar,0
IM_Note1=varchar,0
IM_Note2=varchar,0
IM_Note3=varchar,0
IM_TotalAmt01=decimal,2
IM_Charges01AccId=decimal,0
IM_Charges01Desc=varchar,0
IM_Charges01Perc=varchar,0
IM_Charges01Amt=decimal,2
IM_Charges02AccId=decimal,0
IM_Charges02Desc=varchar,0
IM_Charges02Perc=varchar,0
IM_Charges02Amt=decimal,2
IM_Charges03AccId=decimal,0
IM_Charges03Desc=varchar,0
IM_Charges03Perc=varchar,0
IM_Charges03Amt=decimal,2
IM_Charges04AccId=decimal,0
IM_Charges04Desc=varchar,0
IM_Charges04Perc=varchar,0
IM_Charges04Amt=decimal,2
IM_Charges05AccId=decimal,0
IM_Charges05Desc=varchar,0
IM_Charges05Perc=varchar,0
IM_Charges05Amt=decimal,2
IM_TotalAmt02=decimal,2
IM_Tax01AccId=decimal,0
IM_Tax01Desc=varchar,0
IM_Tax01Perc=varchar,0
IM_Tax01Amt=decimal,2
IM_Tax02AccId=decimal,0
IM_Tax02Desc=varchar,0
IM_Tax02Perc=varchar,0
IM_Tax02Amt=decimal,2
IM_Tax03AccId=decimal,0
IM_Tax03Desc=varchar,0
IM_Tax03Perc=varchar,0
IM_Tax03Amt=decimal,2
IM_Tax04AccId=decimal,0
IM_Tax04Desc=varchar,0
IM_Tax04Perc=varchar,0
IM_Tax04Amt=decimal,2
IM_Tax05AccId=decimal,0
IM_Tax05Desc=varchar,0
IM_Tax05Perc=varchar,0
IM_Tax05Amt=decimal,2
IM_TotalAmt03=decimal,2
IM_Charges06AccId=decimal,0
IM_Charges06Desc=varchar,0
IM_Charges06Perc=varchar,0
IM_Charges06Amt=decimal,2
IM_Charges07AccId=decimal,0
IM_Charges07Desc=varchar,0
IM_Charges07Perc=varchar,0
IM_Charges07Amt=decimal,2
IM_Charges08AccId=decimal,0
IM_Charges08Desc=varchar,0
IM_Charges08Perc=varchar,0
IM_Charges08Amt=decimal,2
IM_Charges09AccId=decimal,0
IM_Charges09Desc=varchar,0
IM_Charges09Perc=varchar,0
IM_Charges09Amt=decimal,2
IM_Charges10AccId=decimal,0
IM_Charges10Desc=varchar,0
IM_Charges10Perc=varchar,0
IM_Charges10Amt=decimal,2
IM_TotalAmt04=decimal,2
IM_Tax06AccId=decimal,0
IM_Tax06Desc=varchar,0
IM_Tax06Perc=varchar,0
IM_Tax06Amt=decimal,2
IM_Tax07AccId=decimal,0
IM_Tax07Desc=varchar,0
IM_Tax07Perc=varchar,0
IM_Tax07Amt=decimal,2
IM_Tax08AccId=decimal,0
IM_Tax08Desc=varchar,0
IM_Tax08Perc=varchar,0
IM_Tax08Amt=decimal,2
IM_Tax09AccId=decimal,0
IM_Tax09Desc=varchar,0
IM_Tax09Perc=varchar,0
IM_Tax09Amt=decimal,2
IM_Tax10AccId=decimal,0
IM_Tax10Desc=varchar,0
IM_Tax10Perc=varchar,0
IM_Tax10Amt=decimal,2
IM_TotalAmt05=decimal,2
IM_Charges11AccId=decimal,0
IM_Charges11Desc=varchar,0
IM_Charges11Perc=varchar,0
IM_Charges11Amt=decimal,2
IM_Charges12AccId=decimal,0
IM_Charges12Desc=varchar,0
IM_Charges12Perc=varchar,0
IM_Charges12Amt=decimal,2
IM_Charges13AccId=decimal,0
IM_Charges13Desc=varchar,0
IM_Charges13Perc=varchar,0
IM_Charges13Amt=decimal,2
IM_Charges14AccId=decimal,0
IM_Charges14Desc=varchar,0
IM_Charges14Perc=varchar,0
IM_Charges14Amt=decimal,2
IM_Charges15AccId=decimal,0
IM_Charges15Desc=varchar,0
IM_Charges15Perc=varchar,0
IM_Charges15Amt=decimal,2
IM_TotalAmt06=decimal,2
IM_RndOffAccId=decimal,0
IM_RndOff=decimal,2
IM_AddAmt=decimal,2
IM_LessAmt=decimal,2
IM_BillAmt=decimal,2
IM_RefAmt=decimal,2
IM_AmtInWords=varchar,0
IM_GSTNo=varchar,0
IM_GTotalAmt01=decimal,2
IM_GDiscAmt=decimal,2
IM_GDiscAmt1=decimal,2
IM_GTaxable=decimal,2
IM_GCGST=decimal,2
IM_GSGST=decimal,2
IM_GIGST=decimal,2
IM_GST=decimal,2
IM_CessAmt=decimal,2
IM_GNetAmt=decimal,2
IM_Pcs=decimal,2
IM_Mtrs=decimal,2
IM_GSTApproved=varchar,0
IM_AddInStock=varchar,0
IM_VoucherId=decimal,0
IM_PymtDays=decimal,0
IM_PaymentRemarks=varchar,0
IM_ChallanIds=varchar,0
IM_OrderId=decimal,0
IM_Previous=varchar,0
IM_Next=varchar,0
IM_Paid=varchar,0
IM_Cleared=char,0
IM_ManualCLeared=char,0
IM_PackedBy=varchar,0
IM_PackingCharges=decimal,2
IM_PackingPaidFlag=varchar,0
IM_DeliverdBy=varchar,0
IM_DeliveryCharges=decimal,2
IM_DeliveryPaidFlag=varchar,0
IM_NetPymtDays=decimal,0
IM_DiscPer=decimal,2
IM_DeliverDate=datetime,0
IM_RateListId=decimal,0
IM_Chrg1Amt=decimal,2
IM_Chrg2Amt=decimal,2
IM_Chrg3Amt=decimal,2
IM_Chrg4Amt=decimal,2
IM_Chrg5Amt=decimal,2
IM_Chrg6Amt=decimal,2
IM_Chrg7Amt=decimal,2
IM_Chrg8Amt=decimal,2
IM_Chrg9Amt=decimal,2
IM_Chrg10Amt=decimal,2
IM_Chrg11Amt=decimal,2
IM_Chrg12Amt=decimal,2
IM_RcvdDate=datetime,0
IM_NetAmt=decimal,2
IM_GRAmt=decimal,2
IM_CommAmt=decimal,2
IM_VchNo=varchar,0
IM_GrNo=varchar,0
IM_GRDate=datetime,0
IM_CommPer=decimal,3
IM_AgentCommPer=decimal,3
IM_ASCommPer=decimal,3
IM_CommDue=decimal,2
IM_CommRcvd=decimal,2
IM_CommFlag=char,0
IM_SComm=decimal,2
IM_SSComm=decimal,2
IM_SCommType=varchar,0
IM_VId=decimal,0
IM_RefId=decimal,0
IM_RcvdChallan=varchar,0
IM_RMClear=varchar,0
IM_RClear=varchar,0
IM_CommId=decimal,0
IM_RcvdForm=varchar,0
IM_FormNo=varchar,0
IM_FormDate=datetime,0
IM_ReverseCharge=varchar,0
IM_RndFlag=varchar,0
IM_TDSRndFlag=varchar,0
IM_TCSRndFlag=varchar,0
IM_IsExportIGST=tinyint,0
IM_Distance=decimal,2
IM_VehicleNo=varchar,0
IM_VehicleType=varchar,0
IM_TransMode=varchar,0
IM_StockFlag=varchar,0
IM_StockReferenceFlag=varchar,0
IM_VoucherFlag=varchar,0
IM_ReferenceFlag=varchar,0
IM_CtPerson1=varchar,0
IM_RateTypeFlag=varchar,0
IM_EwayBillNo=varchar,0
IM_EwayBillDate=datetime,0
IM_EwayBillRemarks=varchar,0
IM_EwayFlag=varchar,0
IM_EwayCtr=decimal,0
IM_EwayStatus=varchar,0
IM_EwayTransactionType=varchar,0
IM_EInvoiceAckNo=varchar,0
IM_EInvoiceAckDate=datetime,0
IM_EInvoiceIRN=varchar,0
IM_EInvoiceRemarks=varchar,0
IM_EInvoiceSigned=varchar,0
IM_QrCode=longblob,0
IM_IsCancel=tinyint,0
IM_Cancelled=varchar,0
IM_DiscPer1=decimal,2
IM_DiscAmt1=decimal,2
IM_PerformaNo=int,0
IM_InvoiceType=varchar,0
[invoice_transaction]
IT_Id=decimal,0
IT_SrNo=decimal,0
IT_SerialNo=decimal,0
IT_ItemId=decimal,0
IT_ItemId1=decimal,0
IT_Cut=decimal,3
IT_Packing=decimal,3
IT_Pcs=decimal,3
IT_Mtrs=decimal,3
IT_RateType=varchar,0
IT_StockQty=decimal,3
IT_InvQty=decimal,3
IT_Rate=decimal,3
IT_SubTotal=decimal,3
IT_Desc1=varchar,0
IT_Desc2=varchar,0
IT_Desc3=varchar,0
IT_Desc4=varchar,0
IT_Remark1=varchar,0
IT_Remark2=varchar,0
IT_Remark3=varchar,0
IT_Remark4=varchar,0
IT_Extra1=varchar,0
IT_Extra2=varchar,0
IT_Extra3=varchar,0
IT_Extra4=varchar,0
IT_StockRemarks=varchar,0
IT_ChallanId=decimal,0
IT_OrderId=decimal,0
IT_RefId=decimal,0
IT_RefType=varchar,0
IT_CLeared=char,0
IT_ManualCLeared=char,0
IT_DisPer=decimal,2
IT_DisPer1=decimal,2
IT_VatPer=decimal,2
IT_AddTaxPer=decimal,2
IT_DisAmt=decimal,2
IT_DisAmt1=decimal,2
IT_RGPer=decimal,2
IT_RGAmt=decimal,2
IT_RDPer=decimal,2
IT_RDAmt=decimal,2
IT_VatAmt=decimal,2
IT_AddtaxAmt=decimal,2
IT_ToatalRare1=decimal,2
IT_ToatalRare2=decimal,2
IT_ToatalRare3=decimal,2
IT_MRP=decimal,2
IT_PTS=decimal,2
IT_PTR=decimal,2
IT_FreeQty=decimal,2
IT_CustRefNo=varchar,0
IT_CustRefDate=datetime,0
IT_ExpDate=datetime,0
IT_MfgDate=datetime,0
IT_Flag=decimal,0
IT_XS=decimal,2
IT_S=decimal,2
IT_M=decimal,2
IT_L=decimal,2
IT_XL=decimal,2
IT_2XL=decimal,2
IT_3XL=decimal,2
IT_4XL=decimal,2
IT_5XL=decimal,2
IT_6XL=decimal,2
IT_7XL=decimal,2
IT_8XL=decimal,2
IT_9XL=decimal,2
IT_10XL=decimal,2
IT_FREESIZE=decimal,2
IT_Color=varchar,0
IT_ColorIds=varchar,0
IT_Size=varchar,0
IT_Godown=varchar,0
IT_CGSTPer=decimal,2
IT_CGSTAmt=decimal,2
IT_SGSTPer=decimal,2
IT_SGSTAmt=decimal,2
IT_IGSTPer=decimal,2
IT_IGSTAmt=decimal,2
IT_GSTPer=decimal,2
IT_TotalGST=decimal,2
IT_CessPer=decimal,2
IT_CessAmt=decimal,2
IT_Total1=decimal,2
IT_TaxablAmt=decimal,2
IT_HSNId=decimal,0
IT_UnitId=decimal,0
IT_IsExportIGST=tinyint,0
IT_StockFlag=varchar,0
IT_CessCalculateOn=varchar,0
[invoice_type]
Id=int,0
Name=varchar,0
[item_catalogue]
IM_ItemId=decimal,0
IM_LinkItemId=decimal,0
IM_ColorIds=varchar,0
IM_SrNo=decimal,0
IM_Set=decimal,2
IM_Pcs=decimal,2
IM_Rate=decimal,2
IM_CRate=decimal,2
IM_XS=decimal,2
IM_S=decimal,2
IM_M=decimal,2
IM_L=decimal,2
IM_XL=decimal,2
IM_2XL=decimal,2
IM_3XL=decimal,2
IM_4XL=decimal,2
IM_5XL=decimal,2
IM_6XL=decimal,2
IM_7XL=decimal,2
IM_8XL=decimal,2
IM_9XL=decimal,2
IM_10XL=decimal,2
[item_color]
IM_ItemId=decimal,0
IM_ColorId=decimal,0
IM_Hide=varchar,0
[item_size]
IM_ItemId=decimal,0
IM_SizeId=decimal,0
IM_Size=varchar,0
IM_SRate=decimal,2
IM_PRate=decimal,2
IM_SRate2=decimal,2
[item_transaction]
IM_ProductId=decimal,0
IM_SrNo=decimal,0
IM_ItemId=decimal,0
IM_Qty=decimal,2
IM_UnitId=decimal,2
IM_Rate=decimal,2
IM_Remarks=varchar,0
IM_Extra1=varchar,0
IM_Extra2=varchar,0
IM_Extra3=varchar,0
[items]
IM_ItemId=decimal,0
IM_MacId=decimal,0
IM_RecId=decimal,0
IM_UserId=decimal,0
IM_Year=varchar,0
IM_ItemCode=varchar,0
IM_ItemName=varchar,0
IM_ItemAlias=varchar,0
IM_ItemDesc=varchar,0
IM_Flag=varchar,0
IM_GrpNo=decimal,0
IM_SubGrpNo=decimal,0
IM_Opening=decimal,2
IM_Closing=decimal,2
IM_ReOrderLevel=decimal,2
IM_UnitId=decimal,0
IM_Image=mediumblob,0
IM_PRate1=decimal,2
IM_PRate2=decimal,2
IM_PRate3=decimal,2
IM_PRate4=decimal,2
IM_SRate1=decimal,2
IM_SRate2=decimal,2
IM_SRate3=decimal,2
IM_SRate4=decimal,2
IM_HSNCode=varchar,0
IM_HSNId=decimal,0
IM_Tax1Perc=decimal,2
IM_Tax2Perc=decimal,2
IM_Tax3Perc=decimal,2
IM_Grp1=decimal,0
IM_Grp2=decimal,0
IM_Grp3=decimal,0
IM_Grp4=decimal,0
IM_Grp5=decimal,0
IM_packing=varchar,0
IM_CutAvg=varchar,0
IM_Remark1=varchar,0
IM_Remark2=varchar,0
IM_Remark3=varchar,0
IM_Extra1=varchar,0
IM_Extra2=varchar,0
IM_Extra3=varchar,0
IM_Extra4=varchar,0
IM_Extra5=varchar,0
IM_MfgDate=datetime,0
IM_ExpDate=datetime,0
IM_BrandId=decimal,0
IM_Prefix=varchar,0
IM_ItemNo=decimal,0
IM_ItemNumber=varchar,0
IM_Vat=decimal,2
IM_AddTax=decimal,2
IM_Composition=varchar,0
IM_DeliveryDate=datetime,0
IM_TFDisplay=varchar,0
IM_Status=varchar,0
IM_DeleteFlag=varchar,0
IM_EntryDate=datetime,0
IM_ModifiedDate=datetime,0
IM_ItemDesc1=varchar,0
IM_ItemDesc2=varchar,0
IM_ItemDesc3=varchar,0
IM_MRP=decimal,2
IM_ItemDiscPer=decimal,2
IM_PcsPerCarton=decimal,0
IM_ImagesName=varchar,0
[items_balance]
IB_Id=decimal,0
IB_Year1=varchar,0
IB_Year2=varchar,0
IB_Year=varchar,0
IB_AccId=decimal,0
IB_Opening=decimal,2
IB_OpeningSign=char,0
IB_Closing=decimal,2
IB_ClosingSign=char,0
IB_DeleteFlag=varchar,0
[jobwork]
JW_Id=decimal,0
JW_MacId=decimal,0
JW_RecId=decimal,0
JW_StrId=varchar,0
JW_Date=datetime,0
JW_FinishItemId=decimal,0
JW_Qty=decimal,0
JW_Flag=char,0
[jobwork_costing]
IM_Id=decimal,0
IM_SrNo=decimal,0
IM_Level=varchar,0
IM_Level1=varchar,0
IM_FItemId=decimal,0
IM_ItemId=decimal,0
IM_ItemName=varchar,0
IM_AccId=decimal,0
IM_AccName=varchar,0
IM_Desc1=varchar,0
IM_Desc2=varchar,0
IM_Desc3=varchar,0
IM_Extra1=varchar,0
IM_Extra2=varchar,0
IM_Extra3=varchar,0
IM_Extra4=varchar,0
IM_Qty=decimal,2
IM_Cut=decimal,2
IM_Mtrs=decimal,2
IM_Rate=decimal,2
IM_SubTotal=decimal,2
IM_Remarks=varchar,0
[jobwork_master]
IM_Id=decimal,0
IM_MacId=decimal,0
IM_RecId=decimal,0
IM_UserId=decimal,0
IM_Year=varchar,0
IM_Type=varchar,0
IM_TaxTypeId=decimal,0
IM_InvoiceTypeId=decimal,0
IM_Prefix=varchar,0
IM_Suffix=varchar,0
IM_InvNo=decimal,0
IM_InvoiceNo=varchar,0
IM_StrInvNo=varchar,0
IM_EntryDate=datetime,0
IM_ModifiedDate=datetime,0
IM_Date=datetime,0
IM_Time=datetime,0
IM_Category=varchar,0
IM_SubCategory=varchar,0
IM_OrderNo=varchar,0
IM_OrderDate=datetime,0
IM_ChallanNo=varchar,0
IM_ChallanDate=datetime,0
IM_LRNo=varchar,0
IM_LRDate=datetime,0
IM_CustRefNo=varchar,0
IM_CustRefDate=datetime,0
IM_AONo=varchar,0
IM_AODate=datetime,0
IM_OtherRef=varchar,0
IM_BaleNo=varchar,0
IM_NoOfBale=decimal,0
IM_CashCredit=varchar,0
IM_CPartyId=decimal,0
IM_CustId=decimal,0
IM_Cust2Id=decimal,0
IM_CustAdd=varchar,0
IM_SPartyId=decimal,0
IM_SuppId=decimal,0
IM_Supp2Id=decimal,0
IM_SuppAdd=varchar,0
IM_SalesAccId=decimal,0
IM_Tax1AccId=decimal,0
IM_Tax2AccId=decimal,0
IM_Tax3AccId=decimal,0
IM_SalesDrAccId=decimal,0
IM_AgentId=decimal,0
IM_SubAgentId=decimal,0
IM_HasteId=decimal,0
IM_TransportId=decimal,0
IM_SalesManId=decimal,0
IM_SubSalesManId=decimal,0
IM_Transport=varchar,0
IM_From=varchar,0
IM_To=varchar,0
IM_DeliveryAt=varchar,0
IM_Freight=varchar,0
IM_Weight=varchar,0
IM_Courier=varchar,0
IM_Insurance=varchar,0
IM_RNo=varchar,0
IM_Remarks1=varchar,0
IM_Remarks2=varchar,0
IM_Remarks3=varchar,0
IM_Note1=varchar,0
IM_Note2=varchar,0
IM_Note3=varchar,0
IM_TotalAmt01=decimal,2
IM_Charges01AccId=decimal,0
IM_Charges01Desc=varchar,0
IM_Charges01Perc=varchar,0
IM_Charges01Amt=decimal,2
IM_Charges02AccId=decimal,0
IM_Charges02Desc=varchar,0
IM_Charges02Perc=varchar,0
IM_Charges02Amt=decimal,2
IM_Charges03AccId=decimal,0
IM_Charges03Desc=varchar,0
IM_Charges03Perc=varchar,0
IM_Charges03Amt=decimal,2
IM_Charges04AccId=decimal,0
IM_Charges04Desc=varchar,0
IM_Charges04Perc=varchar,0
IM_Charges04Amt=decimal,2
IM_Charges05AccId=decimal,0
IM_Charges05Desc=varchar,0
IM_Charges05Perc=varchar,0
IM_Charges05Amt=decimal,2
IM_TotalAmt02=decimal,2
IM_Tax01AccId=decimal,0
IM_Tax01Desc=varchar,0
IM_Tax01Perc=varchar,0
IM_Tax01Amt=decimal,2
IM_Tax02AccId=decimal,0
IM_Tax02Desc=varchar,0
IM_Tax02Perc=varchar,0
IM_Tax02Amt=decimal,2
IM_Tax03AccId=decimal,0
IM_Tax03Desc=varchar,0
IM_Tax03Perc=varchar,0
IM_Tax03Amt=decimal,2
IM_Tax04AccId=decimal,0
IM_Tax04Desc=varchar,0
IM_Tax04Perc=varchar,0
IM_Tax04Amt=decimal,2
IM_Tax05AccId=decimal,0
IM_Tax05Desc=varchar,0
IM_Tax05Perc=varchar,0
IM_Tax05Amt=decimal,2
IM_TotalAmt03=decimal,2
IM_Charges06AccId=decimal,0
IM_Charges06Desc=varchar,0
IM_Charges06Perc=varchar,0
IM_Charges06Amt=decimal,2
IM_Charges07AccId=decimal,0
IM_Charges07Desc=varchar,0
IM_Charges07Perc=varchar,0
IM_Charges07Amt=decimal,2
IM_Charges08AccId=decimal,0
IM_Charges08Desc=varchar,0
IM_Charges08Perc=varchar,0
IM_Charges08Amt=decimal,2
IM_Charges09AccId=decimal,0
IM_Charges09Desc=varchar,0
IM_Charges09Perc=varchar,0
IM_Charges09Amt=decimal,2
IM_Charges10AccId=decimal,0
IM_Charges10Desc=varchar,0
IM_Charges10Perc=varchar,0
IM_Charges10Amt=decimal,2
IM_TotalAmt04=decimal,2
IM_Tax06AccId=decimal,0
IM_Tax06Desc=varchar,0
IM_Tax06Perc=varchar,0
IM_Tax06Amt=decimal,2
IM_Tax07AccId=decimal,0
IM_Tax07Desc=varchar,0
IM_Tax07Perc=varchar,0
IM_Tax07Amt=decimal,2
IM_Tax08AccId=decimal,0
IM_Tax08Desc=varchar,0
IM_Tax08Perc=varchar,0
IM_Tax08Amt=decimal,2
IM_Tax09AccId=decimal,0
IM_Tax09Desc=varchar,0
IM_Tax09Perc=varchar,0
IM_Tax09Amt=decimal,2
IM_Tax10AccId=decimal,0
IM_Tax10Desc=varchar,0
IM_Tax10Perc=varchar,0
IM_Tax10Amt=decimal,2
IM_TotalAmt05=decimal,2
IM_Charges11AccId=decimal,0
IM_Charges11Desc=varchar,0
IM_Charges11Perc=varchar,0
IM_Charges11Amt=decimal,2
IM_Charges12AccId=decimal,0
IM_Charges12Desc=varchar,0
IM_Charges12Perc=varchar,0
IM_Charges12Amt=decimal,2
IM_Charges13AccId=decimal,0
IM_Charges13Desc=varchar,0
IM_Charges13Perc=varchar,0
IM_Charges13Amt=decimal,2
IM_Charges14AccId=decimal,0
IM_Charges14Desc=varchar,0
IM_Charges14Perc=varchar,0
IM_Charges14Amt=decimal,2
IM_Charges15AccId=decimal,0
IM_Charges15Desc=varchar,0
IM_Charges15Perc=varchar,0
IM_Charges15Amt=decimal,2
IM_TotalAmt06=decimal,2
IM_RndOffAccId=decimal,0
IM_RndOff=decimal,2
IM_AddAmt=decimal,2
IM_LessAmt=decimal,2
IM_BillAmt=decimal,2
IM_RefAmt=decimal,2
IM_AmtInWords=varchar,0
IM_GSTNo=varchar,0
IM_GTotalAmt01=decimal,2
IM_GDiscAmt=decimal,2
IM_GDiscAmt1=decimal,2
IM_GTaxable=decimal,2
IM_GCGST=decimal,2
IM_GSGST=decimal,2
IM_GIGST=decimal,2
IM_GST=decimal,2
IM_CessAmt=decimal,2
IM_GNetAmt=decimal,2
IM_Pcs=decimal,2
IM_Mtrs=decimal,2
IM_GSTApproved=varchar,0
IM_AddInStock=varchar,0
IM_VoucherId=decimal,0
IM_PymtDays=decimal,0
IM_PaymentRemarks=varchar,0
IM_ChallanIds=varchar,0
IM_OrderId=decimal,0
IM_Previous=varchar,0
IM_Next=varchar,0
IM_Paid=varchar,0
IM_Cleared=char,0
IM_ManualCLeared=char,0
IM_PackedBy=varchar,0
IM_PackingCharges=decimal,2
IM_PackingPaidFlag=varchar,0
IM_DeliverdBy=varchar,0
IM_DeliveryCharges=decimal,2
IM_DeliveryPaidFlag=varchar,0
IM_NetPymtDays=decimal,0
IM_DiscPer=decimal,2
IM_DeliverDate=datetime,0
IM_RateListId=decimal,0
IM_Chrg1Amt=decimal,2
IM_Chrg2Amt=decimal,2
IM_Chrg3Amt=decimal,2
IM_Chrg4Amt=decimal,2
IM_Chrg5Amt=decimal,2
IM_Chrg6Amt=decimal,2
IM_Chrg7Amt=decimal,2
IM_Chrg8Amt=decimal,2
IM_Chrg9Amt=decimal,2
IM_Chrg10Amt=decimal,2
IM_Chrg11Amt=decimal,2
IM_Chrg12Amt=decimal,2
IM_RcvdDate=datetime,0
IM_NetAmt=decimal,2
IM_GRAmt=decimal,2
IM_CommAmt=decimal,2
IM_VchNo=varchar,0
IM_GrNo=varchar,0
IM_GRDate=datetime,0
IM_CommPer=decimal,2
IM_AgentCommPer=decimal,2
IM_ASCommPer=decimal,2
IM_CommDue=decimal,2
IM_CommRcvd=decimal,2
IM_CommFlag=char,0
IM_SComm=decimal,2
IM_SSComm=decimal,2
IM_SCommType=varchar,0
IM_VId=decimal,0
IM_RefId=decimal,0
IM_RcvdChallan=varchar,0
IM_RMClear=varchar,0
IM_RClear=varchar,0
IM_CommId=decimal,0
IM_RcvdForm=varchar,0
IM_FormNo=varchar,0
IM_FormDate=datetime,0
IM_ReverseCharge=varchar,0
IM_RndFlag=varchar,0
IM_TDSRndFlag=varchar,0
IM_IsExportIGST=tinyint,0
IM_Distance=decimal,2
IM_VehicleNo=varchar,0
IM_VehicleType=varchar,0
IM_TransMode=varchar,0
IM_StockFlag=varchar,0
IM_StockReferenceFlag=varchar,0
IM_VoucherFlag=varchar,0
IM_ReferenceFlag=varchar,0
IM_CtPerson1=varchar,0
IM_RateTypeFlag=varchar,0
IM_EwayBillNo=varchar,0
IM_EwayBillDate=datetime,0
IM_EwayBillRemarks=varchar,0
IM_EwayFlag=varchar,0
IM_EwayCtr=decimal,0
IM_EwayStatus=varchar,0
IM_EwayTransactionType=varchar,0
IM_TCSRndFlag=varchar,0
IM_IsCancel=tinyint,0
IM_Cancelled=varchar,0
IM_DiscPer1=decimal,2
IM_DiscAmt1=decimal,2
IM_PerformaNo=int,0
IM_InvoiceType=varchar,0
[jobwork_task_master]
JM_Id=decimal,0
JM_MacId=decimal,0
JM_RecId=decimal,0
JM_JobWorkId=decimal,0
JM_ProcessId=decimal,0
JM_StartDate=datetime,0
JM_EndDtae=datetime,0
JM_Flag=char,0
[jobwork_transaction]
IT_Id=decimal,0
IT_SrNo=decimal,0
IT_SerialNo=decimal,0
IT_RMItemId=decimal,0
IT_RMCut=decimal,2
IT_RMPacking=decimal,2
IT_RMPcs=decimal,2
IT_RMMtrs=decimal,2
IT_RMExtra1=varchar,0
IT_RMExtra2=varchar,0
IT_RMExtra3=varchar,0
IT_ItemId=decimal,0
IT_Cut=decimal,2
IT_Packing=decimal,2
IT_Pcs=decimal,2
IT_Mtrs=decimal,2
IT_RateType=varchar,0
IT_StockQty=decimal,2
IT_InvQty=decimal,2
IT_Rate=decimal,2
IT_SubTotal=decimal,2
IT_Desc1=varchar,0
IT_Desc2=varchar,0
IT_Desc3=varchar,0
IT_Desc4=varchar,0
IT_Remark1=varchar,0
IT_Remark2=varchar,0
IT_Remark3=varchar,0
IT_Remark4=varchar,0
IT_Extra1=varchar,0
IT_Extra2=varchar,0
IT_Extra3=varchar,0
IT_Extra4=varchar,0
IT_StockRemarks=varchar,0
IT_ChallanId=decimal,0
IT_OrderId=decimal,0
IT_RefId=decimal,0
IT_RefType=varchar,0
IT_CLeared=char,0
IT_ManualCLeared=char,0
IT_DisPer=decimal,2
IT_DisPer1=decimal,2
IT_VatPer=decimal,2
IT_AddTaxPer=decimal,2
IT_DisAmt=decimal,2
IT_DisAmt1=decimal,2
IT_RGPer=decimal,2
IT_RGAmt=decimal,2
IT_RDPer=decimal,2
IT_RDAmt=decimal,2
IT_VatAmt=decimal,2
IT_AddtaxAmt=decimal,2
IT_ToatalRare1=decimal,2
IT_ToatalRare2=decimal,2
IT_ToatalRare3=decimal,2
IT_MRP=decimal,2
IT_PTS=decimal,2
IT_PTR=decimal,2
IT_FreeQty=decimal,2
IT_CustRefNo=varchar,0
IT_CustRefDate=datetime,0
IT_ExpDate=datetime,0
IT_MfgDate=datetime,0
IT_Flag=decimal,0
IT_XS=decimal,2
IT_S=decimal,2
IT_M=decimal,2
IT_L=decimal,2
IT_XL=decimal,2
IT_2XL=decimal,2
IT_3XL=decimal,2
IT_4XL=decimal,2
IT_5XL=decimal,2
IT_6XL=decimal,2
IT_7XL=decimal,2
IT_8XL=decimal,2
IT_9XL=decimal,2
IT_10XL=decimal,2
IT_FREESIZE=decimal,2
IT_Color=varchar,0
IT_ColorIds=varchar,0
IT_Size=varchar,0
IT_Godown=varchar,0
IT_CGSTPer=decimal,2
IT_CGSTAmt=decimal,2
IT_SGSTPer=decimal,2
IT_SGSTAmt=decimal,2
IT_IGSTPer=decimal,2
IT_IGSTAmt=decimal,2
IT_GSTPer=decimal,2
IT_TotalGST=decimal,2
IT_CessPer=decimal,2
IT_CessAmt=decimal,2
IT_Total1=decimal,2
IT_TaxablAmt=decimal,2
IT_HSNId=decimal,0
IT_UnitId=decimal,0
IT_RcvdPcs=decimal,2
IT_DamagedPCS=decimal,2
IT_SortedPcs=decimal,2
IT_TotalPCS=decimal,2
IT_RefSrNo=decimal,0
IT_IsExportIGST=tinyint,0
IT_StockFlag=varchar,0
IT_CessCalculateOn=varchar,0
[m_menumaster]
M_Id=decimal,0
M_Name=varchar,0
M_Visible=char,0
M_MainForm=varchar,0
M_FormType=varchar,0
M_Form=varchar,0
M_Remarks=varchar,0
M_GrpNO=decimal,0
[order_master]
IM_Id=decimal,0
IM_MacId=decimal,0
IM_RecId=decimal,0
IM_UserId=decimal,0
IM_Year=varchar,0
IM_Type=varchar,0
IM_TaxTypeId=decimal,0
IM_InvoiceTypeId=decimal,0
IM_Prefix=varchar,0
IM_Suffix=varchar,0
IM_InvNo=decimal,0
IM_InvoiceNo=varchar,0
IM_StrInvNo=varchar,0
IM_EntryDate=datetime,0
IM_ModifiedDate=datetime,0
IM_Date=datetime,0
IM_Time=datetime,0
IM_Category=varchar,0
IM_SubCategory=varchar,0
IM_OrderNo=varchar,0
IM_OrderDate=datetime,0
IM_ChallanNo=varchar,0
IM_ChallanDate=datetime,0
IM_LRNo=varchar,0
IM_LRDate=datetime,0
IM_CustRefNo=varchar,0
IM_CustRefDate=datetime,0
IM_AONo=varchar,0
IM_AODate=datetime,0
IM_OtherRef=varchar,0
IM_BaleNo=varchar,0
IM_NoOfBale=decimal,0
IM_CashCredit=varchar,0
IM_CPartyId=decimal,0
IM_CustId=decimal,0
IM_Cust2Id=decimal,0
IM_CustAdd=varchar,0
IM_SPartyId=decimal,0
IM_SuppId=decimal,0
IM_Supp2Id=decimal,0
IM_SuppAdd=varchar,0
IM_SalesAccId=decimal,0
IM_Tax1AccId=decimal,0
IM_Tax2AccId=decimal,0
IM_Tax3AccId=decimal,0
IM_SalesDrAccId=decimal,0
IM_AgentId=decimal,0
IM_SubAgentId=decimal,0
IM_HasteId=decimal,0
IM_TransportId=decimal,0
IM_SalesManId=decimal,0
IM_SubSalesManId=decimal,0
IM_Transport=varchar,0
IM_From=varchar,0
IM_To=varchar,0
IM_DeliveryAt=varchar,0
IM_Freight=varchar,0
IM_Weight=varchar,0
IM_Courier=varchar,0
IM_Insurance=varchar,0
IM_RNo=varchar,0
IM_Remarks1=varchar,0
IM_Remarks2=varchar,0
IM_Remarks3=varchar,0
IM_Note1=varchar,0
IM_Note2=varchar,0
IM_Note3=varchar,0
IM_TotalAmt01=decimal,2
IM_Charges01AccId=decimal,0
IM_Charges01Desc=varchar,0
IM_Charges01Perc=varchar,0
IM_Charges01Amt=decimal,2
IM_Charges02AccId=decimal,0
IM_Charges02Desc=varchar,0
IM_Charges02Perc=varchar,0
IM_Charges02Amt=decimal,2
IM_Charges03AccId=decimal,0
IM_Charges03Desc=varchar,0
IM_Charges03Perc=varchar,0
IM_Charges03Amt=decimal,2
IM_Charges04AccId=decimal,0
IM_Charges04Desc=varchar,0
IM_Charges04Perc=varchar,0
IM_Charges04Amt=decimal,2
IM_Charges05AccId=decimal,0
IM_Charges05Desc=varchar,0
IM_Charges05Perc=varchar,0
IM_Charges05Amt=decimal,2
IM_TotalAmt02=decimal,2
IM_Tax01AccId=decimal,0
IM_Tax01Desc=varchar,0
IM_Tax01Perc=varchar,0
IM_Tax01Amt=decimal,2
IM_Tax02AccId=decimal,0
IM_Tax02Desc=varchar,0
IM_Tax02Perc=varchar,0
IM_Tax02Amt=decimal,2
IM_Tax03AccId=decimal,0
IM_Tax03Desc=varchar,0
IM_Tax03Perc=varchar,0
IM_Tax03Amt=decimal,2
IM_Tax04AccId=decimal,0
IM_Tax04Desc=varchar,0
IM_Tax04Perc=varchar,0
IM_Tax04Amt=decimal,2
IM_Tax05AccId=decimal,0
IM_Tax05Desc=varchar,0
IM_Tax05Perc=varchar,0
IM_Tax05Amt=decimal,2
IM_TotalAmt03=decimal,2
IM_Charges06AccId=decimal,0
IM_Charges06Desc=varchar,0
IM_Charges06Perc=varchar,0
IM_Charges06Amt=decimal,2
IM_Charges07AccId=decimal,0
IM_Charges07Desc=varchar,0
IM_Charges07Perc=varchar,0
IM_Charges07Amt=decimal,2
IM_Charges08AccId=decimal,0
IM_Charges08Desc=varchar,0
IM_Charges08Perc=varchar,0
IM_Charges08Amt=decimal,2
IM_Charges09AccId=decimal,0
IM_Charges09Desc=varchar,0
IM_Charges09Perc=varchar,0
IM_Charges09Amt=decimal,2
IM_Charges10AccId=decimal,0
IM_Charges10Desc=varchar,0
IM_Charges10Perc=varchar,0
IM_Charges10Amt=decimal,2
IM_TotalAmt04=decimal,2
IM_Tax06AccId=decimal,0
IM_Tax06Desc=varchar,0
IM_Tax06Perc=varchar,0
IM_Tax06Amt=decimal,2
IM_Tax07AccId=decimal,0
IM_Tax07Desc=varchar,0
IM_Tax07Perc=varchar,0
IM_Tax07Amt=decimal,2
IM_Tax08AccId=decimal,0
IM_Tax08Desc=varchar,0
IM_Tax08Perc=varchar,0
IM_Tax08Amt=decimal,2
IM_Tax09AccId=decimal,0
IM_Tax09Desc=varchar,0
IM_Tax09Perc=varchar,0
IM_Tax09Amt=decimal,2
IM_Tax10AccId=decimal,0
IM_Tax10Desc=varchar,0
IM_Tax10Perc=varchar,0
IM_Tax10Amt=decimal,2
IM_TotalAmt05=decimal,2
IM_Charges11AccId=decimal,0
IM_Charges11Desc=varchar,0
IM_Charges11Perc=varchar,0
IM_Charges11Amt=decimal,2
IM_Charges12AccId=decimal,0
IM_Charges12Desc=varchar,0
IM_Charges12Perc=varchar,0
IM_Charges12Amt=decimal,2
IM_Charges13AccId=decimal,0
IM_Charges13Desc=varchar,0
IM_Charges13Perc=varchar,0
IM_Charges13Amt=decimal,2
IM_Charges14AccId=decimal,0
IM_Charges14Desc=varchar,0
IM_Charges14Perc=varchar,0
IM_Charges14Amt=decimal,2
IM_Charges15AccId=decimal,0
IM_Charges15Desc=varchar,0
IM_Charges15Perc=varchar,0
IM_Charges15Amt=decimal,2
IM_TotalAmt06=decimal,2
IM_RndOffAccId=decimal,0
IM_RndOff=decimal,2
IM_AddAmt=decimal,2
IM_LessAmt=decimal,2
IM_BillAmt=decimal,2
IM_RefAmt=decimal,2
IM_AmtInWords=varchar,0
IM_GSTNo=varchar,0
IM_GTotalAmt01=decimal,2
IM_GDiscAmt=decimal,2
IM_GDiscAmt1=decimal,2
IM_GTaxable=decimal,2
IM_GCGST=decimal,2
IM_GSGST=decimal,2
IM_GIGST=decimal,2
IM_GST=decimal,2
IM_CessAmt=decimal,2
IM_GNetAmt=decimal,2
IM_Pcs=decimal,2
IM_Mtrs=decimal,2
IM_GSTApproved=varchar,0
IM_AddInStock=varchar,0
IM_VoucherId=decimal,0
IM_PymtDays=decimal,0
IM_PaymentRemarks=varchar,0
IM_ChallanIds=varchar,0
IM_OrderId=decimal,0
IM_Previous=varchar,0
IM_Next=varchar,0
IM_Paid=varchar,0
IM_Cleared=char,0
IM_ManualCLeared=char,0
IM_PackedBy=varchar,0
IM_PackingCharges=decimal,2
IM_PackingPaidFlag=varchar,0
IM_DeliverdBy=varchar,0
IM_DeliveryCharges=decimal,2
IM_DeliveryPaidFlag=varchar,0
IM_NetPymtDays=decimal,0
IM_DiscPer=decimal,2
IM_DeliverDate=datetime,0
IM_RateListId=decimal,0
IM_Chrg1Amt=decimal,2
IM_Chrg2Amt=decimal,2
IM_Chrg3Amt=decimal,2
IM_Chrg4Amt=decimal,2
IM_Chrg5Amt=decimal,2
IM_Chrg6Amt=decimal,2
IM_Chrg7Amt=decimal,2
IM_Chrg8Amt=decimal,2
IM_Chrg9Amt=decimal,2
IM_Chrg10Amt=decimal,2
IM_Chrg11Amt=decimal,2
IM_Chrg12Amt=decimal,2
IM_RcvdDate=datetime,0
IM_NetAmt=decimal,2
IM_GRAmt=decimal,2
IM_CommAmt=decimal,2
IM_VchNo=varchar,0
IM_GrNo=varchar,0
IM_GRDate=datetime,0
IM_CommPer=decimal,2
IM_AgentCommPer=decimal,2
IM_ASCommPer=decimal,2
IM_CommDue=decimal,2
IM_CommRcvd=decimal,2
IM_CommFlag=char,0
IM_SComm=decimal,2
IM_SSComm=decimal,2
IM_SCommType=varchar,0
IM_VId=decimal,0
IM_RefId=decimal,0
IM_RcvdChallan=varchar,0
IM_RMClear=varchar,0
IM_RClear=varchar,0
IM_CommId=decimal,0
IM_RcvdForm=varchar,0
IM_FormNo=varchar,0
IM_FormDate=datetime,0
IM_ReverseCharge=varchar,0
IM_RndFlag=varchar,0
IM_TDSRndFlag=varchar,0
IM_IsExportIGST=tinyint,0
IM_Distance=decimal,2
IM_VehicleNo=varchar,0
IM_VehicleType=varchar,0
IM_TransMode=varchar,0
IM_StockFlag=varchar,0
IM_StockReferenceFlag=varchar,0
IM_VoucherFlag=varchar,0
IM_ReferenceFlag=varchar,0
IM_CtPerson1=varchar,0
IM_RateTypeFlag=varchar,0
IM_EwayBillNo=varchar,0
IM_EwayBillDate=datetime,0
IM_EwayBillRemarks=varchar,0
IM_EwayFlag=varchar,0
IM_EwayCtr=decimal,0
IM_EwayStatus=varchar,0
IM_EwayTransactionType=varchar,0
IM_TCSRndFlag=varchar,0
IM_IsCancel=tinyint,0
IM_Cancelled=varchar,0
IM_DiscPer1=decimal,2
IM_DiscAmt1=decimal,2
IM_PerformaNo=int,0
IM_InvoiceType=varchar,0
[order_transaction]
IT_Id=decimal,0
IT_SrNo=decimal,0
IT_SerialNo=decimal,0
IT_ItemId=decimal,0
IT_ItemId1=decimal,0
IT_Cut=decimal,2
IT_Packing=decimal,2
IT_Pcs=decimal,2
IT_Mtrs=decimal,2
IT_RateType=varchar,0
IT_StockQty=decimal,2
IT_InvQty=decimal,2
IT_Rate=decimal,2
IT_SubTotal=decimal,2
IT_Desc1=varchar,0
IT_Desc2=varchar,0
IT_Desc3=varchar,0
IT_Desc4=varchar,0
IT_Remark1=varchar,0
IT_Remark2=varchar,0
IT_Remark3=varchar,0
IT_Remark4=varchar,0
IT_Extra1=varchar,0
IT_Extra2=varchar,0
IT_Extra3=varchar,0
IT_Extra4=varchar,0
IT_StockRemarks=varchar,0
IT_ChallanId=decimal,0
IT_OrderId=decimal,0
IT_RefId=decimal,0
IT_RefType=varchar,0
IT_CLeared=char,0
IT_ManualCLeared=char,0
IT_DisPer=decimal,2
IT_DisPer1=decimal,2
IT_VatPer=decimal,2
IT_AddTaxPer=decimal,2
IT_DisAmt=decimal,2
IT_DisAmt1=decimal,2
IT_RGPer=decimal,2
IT_RGAmt=decimal,2
IT_RDPer=decimal,2
IT_RDAmt=decimal,2
IT_VatAmt=decimal,2
IT_AddtaxAmt=decimal,2
IT_ToatalRare1=decimal,2
IT_ToatalRare2=decimal,2
IT_ToatalRare3=decimal,2
IT_MRP=decimal,2
IT_PTS=decimal,2
IT_PTR=decimal,2
IT_FreeQty=decimal,2
IT_CustRefNo=varchar,0
IT_CustRefDate=datetime,0
IT_ExpDate=datetime,0
IT_MfgDate=datetime,0
IT_Flag=decimal,0
IT_XS=decimal,2
IT_S=decimal,2
IT_M=decimal,2
IT_L=decimal,2
IT_XL=decimal,2
IT_2XL=decimal,2
IT_3XL=decimal,2
IT_4XL=decimal,2
IT_5XL=decimal,2
IT_6XL=decimal,2
IT_7XL=decimal,2
IT_8XL=decimal,2
IT_9XL=decimal,2
IT_10XL=decimal,2
IT_FREESIZE=decimal,2
IT_Color=varchar,0
IT_ColorIds=varchar,0
IT_Size=varchar,0
IT_Godown=varchar,0
IT_CGSTPer=decimal,2
IT_CGSTAmt=decimal,2
IT_SGSTPer=decimal,2
IT_SGSTAmt=decimal,2
IT_IGSTPer=decimal,2
IT_IGSTAmt=decimal,2
IT_GSTPer=decimal,2
IT_TotalGST=decimal,2
IT_CessPer=decimal,2
IT_CessAmt=decimal,2
IT_Total1=decimal,2
IT_TaxablAmt=decimal,2
IT_HSNId=decimal,0
IT_UnitId=decimal,0
IT_IsExportIGST=tinyint,0
IT_StockFlag=varchar,0
IT_CessCalculateOn=varchar,0
[orderdispatch_master]
IM_Id=decimal,0
IM_MacId=decimal,0
IM_RecId=decimal,0
IM_UserId=decimal,0
IM_Year=varchar,0
IM_Type=varchar,0
IM_Prefix=varchar,0
IM_Suffix=varchar,0
IM_InvNo=decimal,0
IM_InvoiceNo=varchar,0
IM_StrInvNo=varchar,0
IM_CustRefNo=varchar,0
IM_EntryDate=datetime,0
IM_ModifiedDate=datetime,0
IM_Date=datetime,0
IM_Time=datetime,0
IM_OrderQty=decimal,2
IM_InvQty=decimal,2
IM_BillAmt=decimal,2
IM_AmtInWords=varchar,0
IM_TaxTypeId=decimal,0
IM_InvoiceTypeId=decimal,0
IM_SalesAccId=decimal,0
IM_CashCredit=varchar,0
IM_Remarks1=varchar,0
IM_Remarks2=varchar,0
IM_Remarks3=varchar,0
[orderdispatch_transaction]
IT_Id=decimal,0
IT_SrNo=decimal,0
IT_SerialNo=decimal,0
IT_ItemId=decimal,0
IT_ItemName=varchar,0
IT_Color=varchar,0
IT_UnitId=decimal,0
IT_UnitName=varchar,0
IT_OrderQty=decimal,2
IT_InvQty=decimal,3
IT_RateType=varchar,0
IT_StockQty=decimal,3
IT_Rate=decimal,3
IT_SubTotal=decimal,3
IT_CustId=decimal,0
IT_CustName=varchar,0
IT_HasteId=decimal,0
IT_HasteName=varchar,0
IT_Remark1=varchar,0
IT_Remark2=varchar,0
IT_Remark3=varchar,0
IT_Remark4=varchar,0
IT_InvoiceId=decimal,0
IT_InvNo=decimal,0
[person_detail]
PD_Id=decimal,0
PD_BirthDate=datetime,0
PD_Gender=varchar,0
PD_Address1=varchar,0
PD_Address2=varchar,0
PD_Address3=varchar,0
PD_Area=varchar,0
PD_City=varchar,0
PD_Pin=varchar,0
PD_State=varchar,0
PD_PrintingAddress=varchar,0
PD_Phone_O1=varchar,0
PD_Phone_O2=varchar,0
PD_Phone_R=varchar,0
PD_Mobile1=varchar,0
PD_Mobile2=varchar,0
PD_Fax=varchar,0
PD_Email=varchar,0
PD_Flag=varchar,0
PD_DeleteFlag=varchar,0
PD_AnniversaryDate=datetime,0
PD_Extra1=varchar,0
PD_Extra2=varchar,0
[processname_master]
Pd_Id=decimal,0
Pd_Name=varchar,0
Pd_Remarks=varchar,0
Pd_SrNo=decimal,0
[purchase_master]
IM_Id=decimal,0
IM_MacId=decimal,0
IM_RecId=decimal,0
IM_UserId=decimal,0
IM_Year=varchar,0
IM_Type=varchar,0
IM_TaxTypeId=decimal,0
IM_InvoiceTypeId=decimal,0
IM_Prefix=varchar,0
IM_Suffix=varchar,0
IM_InvNo=decimal,0
IM_InvoiceNo=varchar,0
IM_StrInvNo=varchar,0
IM_EntryDate=datetime,0
IM_ModifiedDate=datetime,0
IM_Date=datetime,0
IM_Time=datetime,0
IM_Category=varchar,0
IM_SubCategory=varchar,0
IM_OrderNo=varchar,0
IM_OrderDate=datetime,0
IM_ChallanNo=varchar,0
IM_ChallanDate=datetime,0
IM_LRNo=varchar,0
IM_LRDate=datetime,0
IM_CustRefNo=varchar,0
IM_CustRefDate=datetime,0
IM_AONo=varchar,0
IM_AODate=datetime,0
IM_OtherRef=varchar,0
IM_BaleNo=varchar,0
IM_NoOfBale=decimal,0
IM_CashCredit=varchar,0
IM_CPartyId=decimal,0
IM_CustId=decimal,0
IM_Cust2Id=decimal,0
IM_CustAdd=varchar,0
IM_SPartyId=decimal,0
IM_SuppId=decimal,0
IM_Supp2Id=decimal,0
IM_SuppAdd=varchar,0
IM_SalesAccId=decimal,0
IM_Tax1AccId=decimal,0
IM_Tax2AccId=decimal,0
IM_Tax3AccId=decimal,0
IM_SalesDrAccId=decimal,0
IM_AgentId=decimal,0
IM_SubAgentId=decimal,0
IM_HasteId=decimal,0
IM_TransportId=decimal,0
IM_SalesManId=decimal,0
IM_SubSalesManId=decimal,0
IM_Transport=varchar,0
IM_From=varchar,0
IM_To=varchar,0
IM_DeliveryAt=varchar,0
IM_Freight=varchar,0
IM_Weight=varchar,0
IM_Courier=varchar,0
IM_Insurance=varchar,0
IM_RNo=varchar,0
IM_Remarks1=varchar,0
IM_Remarks2=varchar,0
IM_Remarks3=varchar,0
IM_Note1=varchar,0
IM_Note2=varchar,0
IM_Note3=varchar,0
IM_TotalAmt01=decimal,2
IM_Charges01AccId=decimal,0
IM_Charges01Desc=varchar,0
IM_Charges01Perc=varchar,0
IM_Charges01Amt=decimal,2
IM_Charges02AccId=decimal,0
IM_Charges02Desc=varchar,0
IM_Charges02Perc=varchar,0
IM_Charges02Amt=decimal,2
IM_Charges03AccId=decimal,0
IM_Charges03Desc=varchar,0
IM_Charges03Perc=varchar,0
IM_Charges03Amt=decimal,2
IM_Charges04AccId=decimal,0
IM_Charges04Desc=varchar,0
IM_Charges04Perc=varchar,0
IM_Charges04Amt=decimal,2
IM_Charges05AccId=decimal,0
IM_Charges05Desc=varchar,0
IM_Charges05Perc=varchar,0
IM_Charges05Amt=decimal,2
IM_TotalAmt02=decimal,2
IM_Tax01AccId=decimal,0
IM_Tax01Desc=varchar,0
IM_Tax01Perc=varchar,0
IM_Tax01Amt=decimal,2
IM_Tax02AccId=decimal,0
IM_Tax02Desc=varchar,0
IM_Tax02Perc=varchar,0
IM_Tax02Amt=decimal,2
IM_Tax03AccId=decimal,0
IM_Tax03Desc=varchar,0
IM_Tax03Perc=varchar,0
IM_Tax03Amt=decimal,2
IM_Tax04AccId=decimal,0
IM_Tax04Desc=varchar,0
IM_Tax04Perc=varchar,0
IM_Tax04Amt=decimal,2
IM_Tax05AccId=decimal,0
IM_Tax05Desc=varchar,0
IM_Tax05Perc=varchar,0
IM_Tax05Amt=decimal,2
IM_TotalAmt03=decimal,2
IM_Charges06AccId=decimal,0
IM_Charges06Desc=varchar,0
IM_Charges06Perc=varchar,0
IM_Charges06Amt=decimal,2
IM_Charges07AccId=decimal,0
IM_Charges07Desc=varchar,0
IM_Charges07Perc=varchar,0
IM_Charges07Amt=decimal,2
IM_Charges08AccId=decimal,0
IM_Charges08Desc=varchar,0
IM_Charges08Perc=varchar,0
IM_Charges08Amt=decimal,2
IM_Charges09AccId=decimal,0
IM_Charges09Desc=varchar,0
IM_Charges09Perc=varchar,0
IM_Charges09Amt=decimal,2
IM_Charges10AccId=decimal,0
IM_Charges10Desc=varchar,0
IM_Charges10Perc=varchar,0
IM_Charges10Amt=decimal,2
IM_TotalAmt04=decimal,2
IM_Tax06AccId=decimal,0
IM_Tax06Desc=varchar,0
IM_Tax06Perc=varchar,0
IM_Tax06Amt=decimal,2
IM_Tax07AccId=decimal,0
IM_Tax07Desc=varchar,0
IM_Tax07Perc=varchar,0
IM_Tax07Amt=decimal,2
IM_Tax08AccId=decimal,0
IM_Tax08Desc=varchar,0
IM_Tax08Perc=varchar,0
IM_Tax08Amt=decimal,2
IM_Tax09AccId=decimal,0
IM_Tax09Desc=varchar,0
IM_Tax09Perc=varchar,0
IM_Tax09Amt=decimal,2
IM_Tax10AccId=decimal,0
IM_Tax10Desc=varchar,0
IM_Tax10Perc=varchar,0
IM_Tax10Amt=decimal,2
IM_TotalAmt05=decimal,2
IM_Charges11AccId=decimal,0
IM_Charges11Desc=varchar,0
IM_Charges11Perc=varchar,0
IM_Charges11Amt=decimal,2
IM_Charges12AccId=decimal,0
IM_Charges12Desc=varchar,0
IM_Charges12Perc=varchar,0
IM_Charges12Amt=decimal,2
IM_Charges13AccId=decimal,0
IM_Charges13Desc=varchar,0
IM_Charges13Perc=varchar,0
IM_Charges13Amt=decimal,2
IM_Charges14AccId=decimal,0
IM_Charges14Desc=varchar,0
IM_Charges14Perc=varchar,0
IM_Charges14Amt=decimal,2
IM_Charges15AccId=decimal,0
IM_Charges15Desc=varchar,0
IM_Charges15Perc=varchar,0
IM_Charges15Amt=decimal,2
IM_TotalAmt06=decimal,2
IM_RndOffAccId=decimal,0
IM_RndOff=decimal,2
IM_AddAmt=decimal,2
IM_LessAmt=decimal,2
IM_BillAmt=decimal,2
IM_RefAmt=decimal,2
IM_AmtInWords=varchar,0
IM_GSTNo=varchar,0
IM_GTotalAmt01=decimal,2
IM_GDiscAmt=decimal,2
IM_GDiscAmt1=decimal,2
IM_GTaxable=decimal,2
IM_GCGST=decimal,2
IM_GSGST=decimal,2
IM_GIGST=decimal,2
IM_GST=decimal,2
IM_CessAmt=decimal,2
IM_GNetAmt=decimal,2
IM_Pcs=decimal,2
IM_Mtrs=decimal,2
IM_GSTApproved=varchar,0
IM_AddInStock=varchar,0
IM_VoucherId=decimal,0
IM_PymtDays=decimal,0
IM_PaymentRemarks=varchar,0
IM_ChallanIds=varchar,0
IM_OrderId=decimal,0
IM_Previous=varchar,0
IM_Next=varchar,0
IM_Paid=varchar,0
IM_Cleared=char,0
IM_ManualCLeared=char,0
IM_PackedBy=varchar,0
IM_PackingCharges=decimal,2
IM_PackingPaidFlag=varchar,0
IM_DeliverdBy=varchar,0
IM_DeliveryCharges=decimal,2
IM_DeliveryPaidFlag=varchar,0
IM_NetPymtDays=decimal,0
IM_DiscPer=decimal,2
IM_DeliverDate=datetime,0
IM_RateListId=decimal,0
IM_Chrg1Amt=decimal,2
IM_Chrg2Amt=decimal,2
IM_Chrg3Amt=decimal,2
IM_Chrg4Amt=decimal,2
IM_Chrg5Amt=decimal,2
IM_Chrg6Amt=decimal,2
IM_Chrg7Amt=decimal,2
IM_Chrg8Amt=decimal,2
IM_Chrg9Amt=decimal,2
IM_Chrg10Amt=decimal,2
IM_Chrg11Amt=decimal,2
IM_Chrg12Amt=decimal,2
IM_RcvdDate=datetime,0
IM_NetAmt=decimal,2
IM_GRAmt=decimal,2
IM_CommAmt=decimal,2
IM_VchNo=varchar,0
IM_GrNo=varchar,0
IM_GRDate=datetime,0
IM_CommPer=decimal,2
IM_AgentCommPer=decimal,2
IM_ASCommPer=decimal,2
IM_CommDue=decimal,2
IM_CommRcvd=decimal,2
IM_CommFlag=char,0
IM_SComm=decimal,2
IM_SSComm=decimal,2
IM_SCommType=varchar,0
IM_VId=decimal,0
IM_RefId=decimal,0
IM_RcvdChallan=varchar,0
IM_RMClear=varchar,0
IM_RClear=varchar,0
IM_CommId=decimal,0
IM_RcvdForm=varchar,0
IM_FormNo=varchar,0
IM_FormDate=datetime,0
IM_ReverseCharge=varchar,0
IM_RndFlag=varchar,0
IM_TDSRndFlag=varchar,0
IM_IsExportIGST=tinyint,0
IM_Distance=decimal,2
IM_VehicleNo=varchar,0
IM_VehicleType=varchar,0
IM_TransMode=varchar,0
IM_StockFlag=varchar,0
IM_StockReferenceFlag=varchar,0
IM_VoucherFlag=varchar,0
IM_ReferenceFlag=varchar,0
IM_CtPerson1=varchar,0
IM_RateTypeFlag=varchar,0
IM_EwayBillNo=varchar,0
IM_EwayBillDate=datetime,0
IM_EwayBillRemarks=varchar,0
IM_EwayFlag=varchar,0
IM_EwayCtr=decimal,0
IM_EwayStatus=varchar,0
IM_EwayTransactionType=varchar,0
IM_EInvoiceAckNo=varchar,0
IM_EInvoiceAckDate=datetime,0
IM_EInvoiceIRN=varchar,0
IM_EInvoiceRemarks=varchar,0
IM_EInvoiceSigned=varchar,0
IM_TCSRndFlag=varchar,0
IM_IsCancel=tinyint,0
IM_Cancelled=varchar,0
IM_DiscPer1=decimal,2
IM_DiscAmt1=decimal,2
IM_PerformaNo=int,0
IM_InvoiceType=varchar,0
[purchase_transaction]
IT_Id=decimal,0
IT_SrNo=decimal,0
IT_SerialNo=decimal,0
IT_ItemId=decimal,0
IT_ItemId1=decimal,0
IT_Cut=decimal,2
IT_Packing=decimal,2
IT_Pcs=decimal,2
IT_Mtrs=decimal,2
IT_RateType=varchar,0
IT_StockQty=decimal,2
IT_InvQty=decimal,2
IT_Rate=decimal,2
IT_SubTotal=decimal,2
IT_Desc1=varchar,0
IT_Desc2=varchar,0
IT_Desc3=varchar,0
IT_Desc4=varchar,0
IT_Remark1=varchar,0
IT_Remark2=varchar,0
IT_Remark3=varchar,0
IT_Remark4=varchar,0
IT_Extra1=varchar,0
IT_Extra2=varchar,0
IT_Extra3=varchar,0
IT_Extra4=varchar,0
IT_StockRemarks=varchar,0
IT_ChallanId=decimal,0
IT_OrderId=decimal,0
IT_RefId=decimal,0
IT_RefType=varchar,0
IT_CLeared=char,0
IT_ManualCLeared=char,0
IT_DisPer=decimal,2
IT_DisPer1=decimal,2
IT_VatPer=decimal,2
IT_AddTaxPer=decimal,2
IT_DisAmt=decimal,2
IT_DisAmt1=decimal,2
IT_RGPer=decimal,2
IT_RGAmt=decimal,2
IT_RDPer=decimal,2
IT_RDAmt=decimal,2
IT_VatAmt=decimal,2
IT_AddtaxAmt=decimal,2
IT_ToatalRare1=decimal,2
IT_ToatalRare2=decimal,2
IT_ToatalRare3=decimal,2
IT_MRP=decimal,2
IT_PTS=decimal,2
IT_PTR=decimal,2
IT_FreeQty=decimal,2
IT_CustRefNo=varchar,0
IT_CustRefDate=datetime,0
IT_ExpDate=datetime,0
IT_MfgDate=datetime,0
IT_Flag=decimal,0
IT_XS=decimal,2
IT_S=decimal,2
IT_M=decimal,2
IT_L=decimal,2
IT_XL=decimal,2
IT_2XL=decimal,2
IT_3XL=decimal,2
IT_4XL=decimal,2
IT_5XL=decimal,2
IT_6XL=decimal,2
IT_7XL=decimal,2
IT_8XL=decimal,2
IT_9XL=decimal,2
IT_10XL=decimal,2
IT_FREESIZE=decimal,2
IT_Color=varchar,0
IT_ColorIds=varchar,0
IT_Size=varchar,0
IT_Godown=varchar,0
IT_CGSTPer=decimal,2
IT_CGSTAmt=decimal,2
IT_SGSTPer=decimal,2
IT_SGSTAmt=decimal,2
IT_IGSTPer=decimal,2
IT_IGSTAmt=decimal,2
IT_GSTPer=decimal,2
IT_TotalGST=decimal,2
IT_CessPer=decimal,2
IT_CessAmt=decimal,2
IT_Total1=decimal,2
IT_TaxablAmt=decimal,2
IT_HSNId=decimal,0
IT_UnitId=decimal,0
IT_IsExportIGST=tinyint,0
IT_StockFlag=varchar,0
IT_CessCalculateOn=varchar,0
[purchasechallan_master]
IM_Id=decimal,0
IM_MacId=decimal,0
IM_RecId=decimal,0
IM_UserId=decimal,0
IM_Year=varchar,0
IM_Type=varchar,0
IM_TaxTypeId=decimal,0
IM_InvoiceTypeId=decimal,0
IM_Prefix=varchar,0
IM_Suffix=varchar,0
IM_InvNo=decimal,0
IM_InvoiceNo=varchar,0
IM_StrInvNo=varchar,0
IM_EntryDate=datetime,0
IM_ModifiedDate=datetime,0
IM_Date=datetime,0
IM_Time=datetime,0
IM_Category=varchar,0
IM_SubCategory=varchar,0
IM_OrderNo=varchar,0
IM_OrderDate=datetime,0
IM_ChallanNo=varchar,0
IM_ChallanDate=datetime,0
IM_LRNo=varchar,0
IM_LRDate=datetime,0
IM_CustRefNo=varchar,0
IM_CustRefDate=datetime,0
IM_AONo=varchar,0
IM_AODate=datetime,0
IM_OtherRef=varchar,0
IM_BaleNo=varchar,0
IM_NoOfBale=decimal,0
IM_CashCredit=varchar,0
IM_CPartyId=decimal,0
IM_CustId=decimal,0
IM_Cust2Id=decimal,0
IM_CustAdd=varchar,0
IM_SPartyId=decimal,0
IM_SuppId=decimal,0
IM_Supp2Id=decimal,0
IM_SuppAdd=varchar,0
IM_SalesAccId=decimal,0
IM_Tax1AccId=decimal,0
IM_Tax2AccId=decimal,0
IM_Tax3AccId=decimal,0
IM_SalesDrAccId=decimal,0
IM_AgentId=decimal,0
IM_SubAgentId=decimal,0
IM_HasteId=decimal,0
IM_TransportId=decimal,0
IM_SalesManId=decimal,0
IM_SubSalesManId=decimal,0
IM_Transport=varchar,0
IM_From=varchar,0
IM_To=varchar,0
IM_DeliveryAt=varchar,0
IM_Freight=varchar,0
IM_Weight=varchar,0
IM_Courier=varchar,0
IM_Insurance=varchar,0
IM_RNo=varchar,0
IM_Remarks1=varchar,0
IM_Remarks2=varchar,0
IM_Remarks3=varchar,0
IM_Note1=varchar,0
IM_Note2=varchar,0
IM_Note3=varchar,0
IM_TotalAmt01=decimal,2
IM_Charges01AccId=decimal,0
IM_Charges01Desc=varchar,0
IM_Charges01Perc=varchar,0
IM_Charges01Amt=decimal,2
IM_Charges02AccId=decimal,0
IM_Charges02Desc=varchar,0
IM_Charges02Perc=varchar,0
IM_Charges02Amt=decimal,2
IM_Charges03AccId=decimal,0
IM_Charges03Desc=varchar,0
IM_Charges03Perc=varchar,0
IM_Charges03Amt=decimal,2
IM_Charges04AccId=decimal,0
IM_Charges04Desc=varchar,0
IM_Charges04Perc=varchar,0
IM_Charges04Amt=decimal,2
IM_Charges05AccId=decimal,0
IM_Charges05Desc=varchar,0
IM_Charges05Perc=varchar,0
IM_Charges05Amt=decimal,2
IM_TotalAmt02=decimal,2
IM_Tax01AccId=decimal,0
IM_Tax01Desc=varchar,0
IM_Tax01Perc=varchar,0
IM_Tax01Amt=decimal,2
IM_Tax02AccId=decimal,0
IM_Tax02Desc=varchar,0
IM_Tax02Perc=varchar,0
IM_Tax02Amt=decimal,2
IM_Tax03AccId=decimal,0
IM_Tax03Desc=varchar,0
IM_Tax03Perc=varchar,0
IM_Tax03Amt=decimal,2
IM_Tax04AccId=decimal,0
IM_Tax04Desc=varchar,0
IM_Tax04Perc=varchar,0
IM_Tax04Amt=decimal,2
IM_Tax05AccId=decimal,0
IM_Tax05Desc=varchar,0
IM_Tax05Perc=varchar,0
IM_Tax05Amt=decimal,2
IM_TotalAmt03=decimal,2
IM_Charges06AccId=decimal,0
IM_Charges06Desc=varchar,0
IM_Charges06Perc=varchar,0
IM_Charges06Amt=decimal,2
IM_Charges07AccId=decimal,0
IM_Charges07Desc=varchar,0
IM_Charges07Perc=varchar,0
IM_Charges07Amt=decimal,2
IM_Charges08AccId=decimal,0
IM_Charges08Desc=varchar,0
IM_Charges08Perc=varchar,0
IM_Charges08Amt=decimal,2
IM_Charges09AccId=decimal,0
IM_Charges09Desc=varchar,0
IM_Charges09Perc=varchar,0
IM_Charges09Amt=decimal,2
IM_Charges10AccId=decimal,0
IM_Charges10Desc=varchar,0
IM_Charges10Perc=varchar,0
IM_Charges10Amt=decimal,2
IM_TotalAmt04=decimal,2
IM_Tax06AccId=decimal,0
IM_Tax06Desc=varchar,0
IM_Tax06Perc=varchar,0
IM_Tax06Amt=decimal,2
IM_Tax07AccId=decimal,0
IM_Tax07Desc=varchar,0
IM_Tax07Perc=varchar,0
IM_Tax07Amt=decimal,2
IM_Tax08AccId=decimal,0
IM_Tax08Desc=varchar,0
IM_Tax08Perc=varchar,0
IM_Tax08Amt=decimal,2
IM_Tax09AccId=decimal,0
IM_Tax09Desc=varchar,0
IM_Tax09Perc=varchar,0
IM_Tax09Amt=decimal,2
IM_Tax10AccId=decimal,0
IM_Tax10Desc=varchar,0
IM_Tax10Perc=varchar,0
IM_Tax10Amt=decimal,2
IM_TotalAmt05=decimal,2
IM_Charges11AccId=decimal,0
IM_Charges11Desc=varchar,0
IM_Charges11Perc=varchar,0
IM_Charges11Amt=decimal,2
IM_Charges12AccId=decimal,0
IM_Charges12Desc=varchar,0
IM_Charges12Perc=varchar,0
IM_Charges12Amt=decimal,2
IM_Charges13AccId=decimal,0
IM_Charges13Desc=varchar,0
IM_Charges13Perc=varchar,0
IM_Charges13Amt=decimal,2
IM_Charges14AccId=decimal,0
IM_Charges14Desc=varchar,0
IM_Charges14Perc=varchar,0
IM_Charges14Amt=decimal,2
IM_Charges15AccId=decimal,0
IM_Charges15Desc=varchar,0
IM_Charges15Perc=varchar,0
IM_Charges15Amt=decimal,2
IM_TotalAmt06=decimal,2
IM_RndOffAccId=decimal,0
IM_RndOff=decimal,2
IM_AddAmt=decimal,2
IM_LessAmt=decimal,2
IM_BillAmt=decimal,2
IM_RefAmt=decimal,2
IM_AmtInWords=varchar,0
IM_GSTNo=varchar,0
IM_GTotalAmt01=decimal,2
IM_GDiscAmt=decimal,2
IM_GDiscAmt1=decimal,2
IM_GTaxable=decimal,2
IM_GCGST=decimal,2
IM_GSGST=decimal,2
IM_GIGST=decimal,2
IM_GST=decimal,2
IM_CessAmt=decimal,2
IM_GNetAmt=decimal,2
IM_Pcs=decimal,2
IM_Mtrs=decimal,2
IM_GSTApproved=varchar,0
IM_AddInStock=varchar,0
IM_VoucherId=decimal,0
IM_PymtDays=decimal,0
IM_PaymentRemarks=varchar,0
IM_ChallanIds=varchar,0
IM_OrderId=decimal,0
IM_Previous=varchar,0
IM_Next=varchar,0
IM_Paid=varchar,0
IM_Cleared=char,0
IM_ManualCLeared=char,0
IM_PackedBy=varchar,0
IM_PackingCharges=decimal,2
IM_PackingPaidFlag=varchar,0
IM_DeliverdBy=varchar,0
IM_DeliveryCharges=decimal,2
IM_DeliveryPaidFlag=varchar,0
IM_NetPymtDays=decimal,0
IM_DiscPer=decimal,2
IM_DeliverDate=datetime,0
IM_RateListId=decimal,0
IM_Chrg1Amt=decimal,2
IM_Chrg2Amt=decimal,2
IM_Chrg3Amt=decimal,2
IM_Chrg4Amt=decimal,2
IM_Chrg5Amt=decimal,2
IM_Chrg6Amt=decimal,2
IM_Chrg7Amt=decimal,2
IM_Chrg8Amt=decimal,2
IM_Chrg9Amt=decimal,2
IM_Chrg10Amt=decimal,2
IM_Chrg11Amt=decimal,2
IM_Chrg12Amt=decimal,2
IM_RcvdDate=datetime,0
IM_NetAmt=decimal,2
IM_GRAmt=decimal,2
IM_CommAmt=decimal,2
IM_VchNo=varchar,0
IM_GrNo=varchar,0
IM_GRDate=datetime,0
IM_CommPer=decimal,2
IM_AgentCommPer=decimal,2
IM_ASCommPer=decimal,2
IM_CommDue=decimal,2
IM_CommRcvd=decimal,2
IM_CommFlag=char,0
IM_SComm=decimal,2
IM_SSComm=decimal,2
IM_SCommType=varchar,0
IM_VId=decimal,0
IM_RefId=decimal,0
IM_RcvdChallan=varchar,0
IM_RMClear=varchar,0
IM_RClear=varchar,0
IM_CommId=decimal,0
IM_RcvdForm=varchar,0
IM_FormNo=varchar,0
IM_FormDate=datetime,0
IM_ReverseCharge=varchar,0
IM_RndFlag=varchar,0
IM_TDSRndFlag=varchar,0
IM_IsExportIGST=tinyint,0
IM_Distance=decimal,2
IM_VehicleNo=varchar,0
IM_VehicleType=varchar,0
IM_TransMode=varchar,0
IM_StockFlag=varchar,0
IM_StockReferenceFlag=varchar,0
IM_VoucherFlag=varchar,0
IM_ReferenceFlag=varchar,0
IM_CtPerson1=varchar,0
IM_RateTypeFlag=varchar,0
IM_EwayBillNo=varchar,0
IM_EwayBillDate=datetime,0
IM_EwayBillRemarks=varchar,0
IM_EwayFlag=varchar,0
IM_EwayCtr=decimal,0
IM_EwayStatus=varchar,0
IM_EwayTransactionType=varchar,0
IM_TCSRndFlag=varchar,0
IM_IsCancel=tinyint,0
IM_Cancelled=varchar,0
IM_DiscPer1=decimal,2
IM_DiscAmt1=decimal,2
IM_PerformaNo=int,0
IM_InvoiceType=varchar,0
[purchasechallan_transaction]
IT_Id=decimal,0
IT_SrNo=decimal,0
IT_SerialNo=decimal,0
IT_ItemId=decimal,0
IT_ItemId1=decimal,0
IT_Cut=decimal,2
IT_Packing=decimal,2
IT_Pcs=decimal,2
IT_Mtrs=decimal,2
IT_RateType=varchar,0
IT_StockQty=decimal,2
IT_InvQty=decimal,2
IT_Rate=decimal,2
IT_SubTotal=decimal,2
IT_Desc1=varchar,0
IT_Desc2=varchar,0
IT_Desc3=varchar,0
IT_Desc4=varchar,0
IT_Remark1=varchar,0
IT_Remark2=varchar,0
IT_Remark3=varchar,0
IT_Remark4=varchar,0
IT_Extra1=varchar,0
IT_Extra2=varchar,0
IT_Extra3=varchar,0
IT_Extra4=varchar,0
IT_StockRemarks=varchar,0
IT_ChallanId=decimal,0
IT_OrderId=decimal,0
IT_RefId=decimal,0
IT_RefType=varchar,0
IT_CLeared=char,0
IT_ManualCLeared=char,0
IT_DisPer=decimal,2
IT_DisPer1=decimal,2
IT_VatPer=decimal,2
IT_AddTaxPer=decimal,2
IT_DisAmt=decimal,2
IT_DisAmt1=decimal,2
IT_RGPer=decimal,2
IT_RGAmt=decimal,2
IT_RDPer=decimal,2
IT_RDAmt=decimal,2
IT_VatAmt=decimal,2
IT_AddtaxAmt=decimal,2
IT_ToatalRare1=decimal,2
IT_ToatalRare2=decimal,2
IT_ToatalRare3=decimal,2
IT_MRP=decimal,2
IT_PTS=decimal,2
IT_PTR=decimal,2
IT_FreeQty=decimal,2
IT_CustRefNo=varchar,0
IT_CustRefDate=datetime,0
IT_ExpDate=datetime,0
IT_MfgDate=datetime,0
IT_Flag=decimal,0
IT_XS=decimal,2
IT_S=decimal,2
IT_M=decimal,2
IT_L=decimal,2
IT_XL=decimal,2
IT_2XL=decimal,2
IT_3XL=decimal,2
IT_4XL=decimal,2
IT_5XL=decimal,2
IT_6XL=decimal,2
IT_7XL=decimal,2
IT_8XL=decimal,2
IT_9XL=decimal,2
IT_10XL=decimal,2
IT_FREESIZE=decimal,2
IT_Color=varchar,0
IT_ColorIds=varchar,0
IT_Size=varchar,0
IT_Godown=varchar,0
IT_CGSTPer=decimal,2
IT_CGSTAmt=decimal,2
IT_SGSTPer=decimal,2
IT_SGSTAmt=decimal,2
IT_IGSTPer=decimal,2
IT_IGSTAmt=decimal,2
IT_GSTPer=decimal,2
IT_TotalGST=decimal,2
IT_CessPer=decimal,2
IT_CessAmt=decimal,2
IT_Total1=decimal,2
IT_TaxablAmt=decimal,2
IT_HSNId=decimal,0
IT_UnitId=decimal,0
IT_IsExportIGST=tinyint,0
IT_StockFlag=varchar,0
IT_CessCalculateOn=varchar,0
[purchasechallan_transaction1]
IT_Id=decimal,0
IT_SrNo=decimal,0
IT_SerialNo=decimal,0
IT_ChallanId=decimal,0
IT_OrderId=decimal,0
IT_ItemId=decimal,0
IT_Amount=decimal,2
IT_Amount1=decimal,2
IT_Amount2=decimal,2
IT_BillNo=varchar,0
IT_BillDate=datetime,0
IT_EwayBillNo=varchar,0
IT_EwayBillDate=datetime,0
IT_EwayBillValidateDate=datetime,0
IT_EwayBillRemarks=varchar,0
IT_Remarks=varchar,0
IT_Remarks1=varchar,0
IT_Remarks2=varchar,0
[quote_master]
IM_Id=decimal,0
IM_MacId=decimal,0
IM_RecId=decimal,0
IM_UserId=decimal,0
IM_Year=varchar,0
IM_Type=varchar,0
IM_TaxTypeId=decimal,0
IM_InvoiceTypeId=decimal,0
IM_Prefix=varchar,0
IM_Suffix=varchar,0
IM_InvNo=decimal,0
IM_InvoiceNo=varchar,0
IM_StrInvNo=varchar,0
IM_EntryDate=datetime,0
IM_ModifiedDate=datetime,0
IM_Date=datetime,0
IM_Time=datetime,0
IM_Category=varchar,0
IM_SubCategory=varchar,0
IM_OrderNo=varchar,0
IM_OrderDate=datetime,0
IM_ChallanNo=varchar,0
IM_ChallanDate=datetime,0
IM_LRNo=varchar,0
IM_LRDate=datetime,0
IM_CustRefNo=varchar,0
IM_CustRefDate=datetime,0
IM_AONo=varchar,0
IM_AODate=datetime,0
IM_OtherRef=varchar,0
IM_BaleNo=varchar,0
IM_NoOfBale=decimal,0
IM_CashCredit=varchar,0
IM_CPartyId=decimal,0
IM_CustId=decimal,0
IM_Cust2Id=decimal,0
IM_CustAdd=varchar,0
IM_SPartyId=decimal,0
IM_SuppId=decimal,0
IM_Supp2Id=decimal,0
IM_SuppAdd=varchar,0
IM_SalesAccId=decimal,0
IM_Tax1AccId=decimal,0
IM_Tax2AccId=decimal,0
IM_Tax3AccId=decimal,0
IM_SalesDrAccId=decimal,0
IM_AgentId=decimal,0
IM_SubAgentId=decimal,0
IM_HasteId=decimal,0
IM_TransportId=decimal,0
IM_SalesManId=decimal,0
IM_SubSalesManId=decimal,0
IM_Transport=varchar,0
IM_From=varchar,0
IM_To=varchar,0
IM_DeliveryAt=varchar,0
IM_Freight=varchar,0
IM_Weight=varchar,0
IM_Courier=varchar,0
IM_Insurance=varchar,0
IM_RNo=varchar,0
IM_Remarks1=varchar,0
IM_Remarks2=varchar,0
IM_Remarks3=varchar,0
IM_Note1=varchar,0
IM_Note2=varchar,0
IM_Note3=varchar,0
IM_TotalAmt01=decimal,2
IM_Charges01AccId=decimal,0
IM_Charges01Desc=varchar,0
IM_Charges01Perc=varchar,0
IM_Charges01Amt=decimal,2
IM_Charges02AccId=decimal,0
IM_Charges02Desc=varchar,0
IM_Charges02Perc=varchar,0
IM_Charges02Amt=decimal,2
IM_Charges03AccId=decimal,0
IM_Charges03Desc=varchar,0
IM_Charges03Perc=varchar,0
IM_Charges03Amt=decimal,2
IM_Charges04AccId=decimal,0
IM_Charges04Desc=varchar,0
IM_Charges04Perc=varchar,0
IM_Charges04Amt=decimal,2
IM_Charges05AccId=decimal,0
IM_Charges05Desc=varchar,0
IM_Charges05Perc=varchar,0
IM_Charges05Amt=decimal,2
IM_TotalAmt02=decimal,2
IM_Tax01AccId=decimal,0
IM_Tax01Desc=varchar,0
IM_Tax01Perc=varchar,0
IM_Tax01Amt=decimal,2
IM_Tax02AccId=decimal,0
IM_Tax02Desc=varchar,0
IM_Tax02Perc=varchar,0
IM_Tax02Amt=decimal,2
IM_Tax03AccId=decimal,0
IM_Tax03Desc=varchar,0
IM_Tax03Perc=varchar,0
IM_Tax03Amt=decimal,2
IM_Tax04AccId=decimal,0
IM_Tax04Desc=varchar,0
IM_Tax04Perc=varchar,0
IM_Tax04Amt=decimal,2
IM_Tax05AccId=decimal,0
IM_Tax05Desc=varchar,0
IM_Tax05Perc=varchar,0
IM_Tax05Amt=decimal,2
IM_TotalAmt03=decimal,2
IM_Charges06AccId=decimal,0
IM_Charges06Desc=varchar,0
IM_Charges06Perc=varchar,0
IM_Charges06Amt=decimal,2
IM_Charges07AccId=decimal,0
IM_Charges07Desc=varchar,0
IM_Charges07Perc=varchar,0
IM_Charges07Amt=decimal,2
IM_Charges08AccId=decimal,0
IM_Charges08Desc=varchar,0
IM_Charges08Perc=varchar,0
IM_Charges08Amt=decimal,2
IM_Charges09AccId=decimal,0
IM_Charges09Desc=varchar,0
IM_Charges09Perc=varchar,0
IM_Charges09Amt=decimal,2
IM_Charges10AccId=decimal,0
IM_Charges10Desc=varchar,0
IM_Charges10Perc=varchar,0
IM_Charges10Amt=decimal,2
IM_TotalAmt04=decimal,2
IM_Tax06AccId=decimal,0
IM_Tax06Desc=varchar,0
IM_Tax06Perc=varchar,0
IM_Tax06Amt=decimal,2
IM_Tax07AccId=decimal,0
IM_Tax07Desc=varchar,0
IM_Tax07Perc=varchar,0
IM_Tax07Amt=decimal,2
IM_Tax08AccId=decimal,0
IM_Tax08Desc=varchar,0
IM_Tax08Perc=varchar,0
IM_Tax08Amt=decimal,2
IM_Tax09AccId=decimal,0
IM_Tax09Desc=varchar,0
IM_Tax09Perc=varchar,0
IM_Tax09Amt=decimal,2
IM_Tax10AccId=decimal,0
IM_Tax10Desc=varchar,0
IM_Tax10Perc=varchar,0
IM_Tax10Amt=decimal,2
IM_TotalAmt05=decimal,2
IM_Charges11AccId=decimal,0
IM_Charges11Desc=varchar,0
IM_Charges11Perc=varchar,0
IM_Charges11Amt=decimal,2
IM_Charges12AccId=decimal,0
IM_Charges12Desc=varchar,0
IM_Charges12Perc=varchar,0
IM_Charges12Amt=decimal,2
IM_Charges13AccId=decimal,0
IM_Charges13Desc=varchar,0
IM_Charges13Perc=varchar,0
IM_Charges13Amt=decimal,2
IM_Charges14AccId=decimal,0
IM_Charges14Desc=varchar,0
IM_Charges14Perc=varchar,0
IM_Charges14Amt=decimal,2
IM_Charges15AccId=decimal,0
IM_Charges15Desc=varchar,0
IM_Charges15Perc=varchar,0
IM_Charges15Amt=decimal,2
IM_TotalAmt06=decimal,2
IM_RndOffAccId=decimal,0
IM_RndOff=decimal,2
IM_AddAmt=decimal,2
IM_LessAmt=decimal,2
IM_BillAmt=decimal,2
IM_RefAmt=decimal,2
IM_AmtInWords=varchar,0
IM_GSTNo=varchar,0
IM_GTotalAmt01=decimal,2
IM_GDiscAmt=decimal,2
IM_GDiscAmt1=decimal,2
IM_GTaxable=decimal,2
IM_GCGST=decimal,2
IM_GSGST=decimal,2
IM_GIGST=decimal,2
IM_GST=decimal,2
IM_CessAmt=decimal,2
IM_GNetAmt=decimal,2
IM_Pcs=decimal,2
IM_Mtrs=decimal,2
IM_GSTApproved=varchar,0
IM_AddInStock=varchar,0
IM_VoucherId=decimal,0
IM_PymtDays=decimal,0
IM_PaymentRemarks=varchar,0
IM_ChallanIds=varchar,0
IM_OrderId=decimal,0
IM_Previous=varchar,0
IM_Next=varchar,0
IM_Paid=varchar,0
IM_Cleared=char,0
IM_ManualCLeared=char,0
IM_PackedBy=varchar,0
IM_PackingCharges=decimal,2
IM_PackingPaidFlag=varchar,0
IM_DeliverdBy=varchar,0
IM_DeliveryCharges=decimal,2
IM_DeliveryPaidFlag=varchar,0
IM_NetPymtDays=decimal,0
IM_DiscPer=decimal,2
IM_DeliverDate=datetime,0
IM_RateListId=decimal,0
IM_Chrg1Amt=decimal,2
IM_Chrg2Amt=decimal,2
IM_Chrg3Amt=decimal,2
IM_Chrg4Amt=decimal,2
IM_Chrg5Amt=decimal,2
IM_Chrg6Amt=decimal,2
IM_Chrg7Amt=decimal,2
IM_Chrg8Amt=decimal,2
IM_Chrg9Amt=decimal,2
IM_Chrg10Amt=decimal,2
IM_Chrg11Amt=decimal,2
IM_Chrg12Amt=decimal,2
IM_RcvdDate=datetime,0
IM_NetAmt=decimal,2
IM_GRAmt=decimal,2
IM_CommAmt=decimal,2
IM_VchNo=varchar,0
IM_GrNo=varchar,0
IM_GRDate=datetime,0
IM_CommPer=decimal,2
IM_AgentCommPer=decimal,2
IM_ASCommPer=decimal,2
IM_CommDue=decimal,2
IM_CommRcvd=decimal,2
IM_CommFlag=char,0
IM_SComm=decimal,2
IM_SSComm=decimal,2
IM_SCommType=varchar,0
IM_VId=decimal,0
IM_RefId=decimal,0
IM_RcvdChallan=varchar,0
IM_RMClear=varchar,0
IM_RClear=varchar,0
IM_CommId=decimal,0
IM_RcvdForm=varchar,0
IM_FormNo=varchar,0
IM_FormDate=datetime,0
IM_ReverseCharge=varchar,0
IM_RndFlag=varchar,0
IM_TDSRndFlag=varchar,0
IM_IsExportIGST=tinyint,0
IM_Distance=decimal,2
IM_VehicleNo=varchar,0
IM_VehicleType=varchar,0
IM_TransMode=varchar,0
IM_StockFlag=varchar,0
IM_StockReferenceFlag=varchar,0
IM_VoucherFlag=varchar,0
IM_ReferenceFlag=varchar,0
IM_CtPerson1=varchar,0
IM_RateTypeFlag=varchar,0
IM_EwayBillNo=varchar,0
IM_EwayBillDate=datetime,0
IM_EwayBillRemarks=varchar,0
IM_EwayFlag=varchar,0
IM_EwayCtr=decimal,0
IM_EwayStatus=varchar,0
IM_EwayTransactionType=varchar,0
IM_TCSRndFlag=varchar,0
IM_IsCancel=tinyint,0
IM_Cancelled=varchar,0
IM_DiscPer1=decimal,2
IM_DiscAmt1=decimal,2
[quote_transaction]
IT_Id=decimal,0
IT_SrNo=decimal,0
IT_SerialNo=decimal,0
IT_ItemId=decimal,0
IT_ItemId1=decimal,0
IT_Cut=decimal,2
IT_Packing=decimal,2
IT_Pcs=decimal,2
IT_Mtrs=decimal,2
IT_RateType=varchar,0
IT_StockQty=decimal,2
IT_InvQty=decimal,2
IT_Rate=decimal,2
IT_SubTotal=decimal,2
IT_Desc1=varchar,0
IT_Desc2=varchar,0
IT_Desc3=varchar,0
IT_Desc4=varchar,0
IT_Remark1=varchar,0
IT_Remark2=varchar,0
IT_Remark3=varchar,0
IT_Remark4=varchar,0
IT_Extra1=varchar,0
IT_Extra2=varchar,0
IT_Extra3=varchar,0
IT_Extra4=varchar,0
IT_StockRemarks=varchar,0
IT_ChallanId=decimal,0
IT_OrderId=decimal,0
IT_RefId=decimal,0
IT_RefType=varchar,0
IT_CLeared=char,0
IT_ManualCLeared=char,0
IT_DisPer=decimal,2
IT_DisPer1=decimal,2
IT_VatPer=decimal,2
IT_AddTaxPer=decimal,2
IT_DisAmt=decimal,2
IT_DisAmt1=decimal,2
IT_RGPer=decimal,2
IT_RGAmt=decimal,2
IT_RDPer=decimal,2
IT_RDAmt=decimal,2
IT_VatAmt=decimal,2
IT_AddtaxAmt=decimal,2
IT_ToatalRare1=decimal,2
IT_ToatalRare2=decimal,2
IT_ToatalRare3=decimal,2
IT_MRP=decimal,2
IT_PTS=decimal,2
IT_PTR=decimal,2
IT_FreeQty=decimal,2
IT_CustRefNo=varchar,0
IT_CustRefDate=datetime,0
IT_ExpDate=datetime,0
IT_MfgDate=datetime,0
IT_Flag=decimal,0
IT_XS=decimal,2
IT_S=decimal,2
IT_M=decimal,2
IT_L=decimal,2
IT_XL=decimal,2
IT_2XL=decimal,2
IT_3XL=decimal,2
IT_4XL=decimal,2
IT_5XL=decimal,2
IT_6XL=decimal,2
IT_7XL=decimal,2
IT_8XL=decimal,2
IT_9XL=decimal,2
IT_10XL=decimal,2
IT_FREESIZE=decimal,2
IT_Color=varchar,0
IT_ColorIds=varchar,0
IT_Size=varchar,0
IT_Godown=varchar,0
IT_CGSTPer=decimal,2
IT_CGSTAmt=decimal,2
IT_SGSTPer=decimal,2
IT_SGSTAmt=decimal,2
IT_IGSTPer=decimal,2
IT_IGSTAmt=decimal,2
IT_GSTPer=decimal,2
IT_TotalGST=decimal,2
IT_CessPer=decimal,2
IT_CessAmt=decimal,2
IT_Total1=decimal,2
IT_TaxablAmt=decimal,2
IT_HSNId=decimal,0
IT_UnitId=decimal,0
IT_IsExportIGST=tinyint,0
IT_StockFlag=varchar,0
[rate_list]
R_Id=decimal,0
R_MacId=decimal,0
R_RecId=decimal,0
R_UserId=decimal,0
R_CustId=decimal,0
R_ItemId=decimal,0
R_Rate=decimal,2
R_Grate=decimal,2
R_Extra1=varchar,0
R_Extra2=varchar,0
R_Extra3=varchar,0
R_SizeId=decimal,0
R_Size=varchar,0
R_FromQty=decimal,2
R_ToQty=decimal,2
[reference]
R_Id=decimal,0
R_MacId=decimal,0
R_RecId=decimal,0
R_UserId=decimal,0
R_Year=varchar,0
R_Type=varchar,0
R_RefId=decimal,0
R_RefType=varchar,0
R_No=varchar,0
R_StrNo=varchar,0
R_EntryDate=datetime,0
R_ModifiedDate=datetime,0
R_Date=datetime,0
R_AccId=decimal,0
R_Acc2Id=decimal,0
R_Amt=decimal,2
R_AmtInWords=varchar,0
R_Sign=varchar,0
R_Clear=varchar,0
R_ManualClear=varchar,0
R_AgentId=decimal,0
R_OrderId=decimal,0
R_Remarks=varchar,0
R_Flag=varchar,0
R_RecordNo=decimal,0
R_DeleteFlag=varchar,0
[reference_details]
RD_Id=decimal,0
RD_SrNo=decimal,0
RD_Type=varchar,0
RD_RefId=decimal,0
RD_RefType=varchar,0
RD_Date=datetime,0
RD_AccId=decimal,0
RD_DrawnOn=varchar,0
RD_Branch=varchar,0
RD_ChqNo=varchar,0
RD_Amt=decimal,2
RD_Amt1=decimal,2
RD_Amt2=decimal,2
RD_Remarks=varchar,0
[reference_transaction]
R_Id=decimal,0
R_Type=varchar,0
R_RefId=decimal,0
R_RefType=varchar,0
R_SrNo=decimal,0
R_AccId=decimal,0
R_Amt=decimal,2
R_Sign=varchar,0
R_Flag=varchar,0
R_RecordNo=decimal,0
[reminder]
R_Id=decimal,0
R_Sr=decimal,0
R_BirthDate=datetime,0
R_Name=varchar,0
R_Remind=varchar,0
R_Cleared=tinyint,0
R_Remarks=varchar,0
[rpt_account]
AM_AccId=decimal,0
AM_MacId=decimal,0
AM_RecId=decimal,0
AM_UserId=decimal,0
AM_AccCode=varchar,0
AM_AccName=varchar,0
AM_AccAlias=varchar,0
AM_AccType=varchar,0
AM_Flag=varchar,0
AM_GrpNo=decimal,0
AM_Level=decimal,0
AM_Opening=decimal,2
AM_OpeningSign=char,0
AM_Closing=decimal,2
AM_ClosingSign=char,0
AM_Remarks=varchar,0
AM_OpeningFlag=char,0
AD_CtPerson1=varchar,0
AD_CtPerson2=varchar,0
AD_Address1=varchar,0
AD_Address2=varchar,0
AD_Address3=varchar,0
AD_Area=varchar,0
AD_City=varchar,0
AD_Pin=varchar,0
AD_State=varchar,0
AD_Country=varchar,0
AD_Phone_O1=varchar,0
AD_Phone_O2=varchar,0
AD_Phone_R=varchar,0
AD_Fax=varchar,0
AD_Mobile1=varchar,0
AD_Mobile2=varchar,0
AD_Email=varchar,0
AD_Website=varchar,0
AD_DLNo1=varchar,0
AD_DLNo2=varchar,0
AD_PrintingAddress=varchar,0
AD_CSTNo=varchar,0
AD_TinNo=varchar,0
AD_PANNo=varchar,0
AD_ECCNo=varchar,0
AD_ESICNo=varchar,0
AD_OANo=varchar,0
AD_RegistrationNo=varchar,0
AD_PFNo=varchar,0
AD_Division=varchar,0
AD_Range=varchar,0
AD_Comm=varchar,0
AD_ExtraNo1=varchar,0
AD_ExtraNo2=varchar,0
AD_AgentId1=decimal,0
AD_AgentId2=decimal,0
AD_HasteId=decimal,0
AD_PartyId=decimal,0
AD_MainParty=char,0
AD_ShowInAll=varchar,0
AD_Transport=varchar,0
AD_DBCPerc=varchar,0
AD_QtyDisc=varchar,0
AD_CreditDays=decimal,0
AD_CreditLimit=decimal,2
AD_Discount=decimal,2
AD_UsedInVat=char,0
AD_TaxTypeId=decimal,0
AD_InvTypeId=decimal,0
AD_TaxPer=decimal,2
AD_TaxForm=varchar,0
AD_VatType=varchar,0
AD_Tax1AccId=decimal,0
AD_TDSPer=decimal,2
AD_TDSFlag=char,0
AD_CtPerson3=varchar,0
AD_CtMob1=varchar,0
AD_CtMob2=varchar,0
AD_CtMob3=varchar,0
AD_CtChk1=char,0
AD_CtChk2=char,0
AD_CtChk3=char,0
AD_RateListId=decimal,0
AD_AgentName=varchar,0
AD_SubAgentName=varchar,0
AD_HasteName=varchar,0
AD_PartyName=varchar,0
AD_Visible=char,0
[rpt_accountledger]
RL_VoucherId=decimal,0
RL_SrNo=decimal,0
RL_VoucherDate=datetime,0
RL_Particulars=varchar,0
RL_Narration=varchar,0
RL_VoucherType=varchar,0
RL_VoucherNo=varchar,0
RL_DrAmount=decimal,0
RL_CrAmount=decimal,0
RL_BalAmount=decimal,0
RL_BalAmountSign=varchar,0
RL_AccountId=decimal,0
RL_AccountName=varchar,0
RL_SortFlag=decimal,0
RL_MachineFlag=varchar,0
[rpt_bankreceipt]
R_No=decimal,0
R_MacId=decimal,0
R_AccName=varchar,0
R_BankName=varchar,0
R_BankAccNo=varchar,0
R_Date=datetime,0
R_PhNo=varchar,0
R_BankAdd1=varchar,0
R_BankAdd2=varchar,0
R_BankAdd3=varchar,0
R_SrNo=decimal,0
R_CustId=decimal,0
R_Customer=varchar,0
R_DrawnOn=varchar,0
R_Branch=varchar,0
R_ChqNo=varchar,0
R_ChqDate=datetime,0
R_Amt=decimal,2
R_Remark=varchar,0
R_Extra=varchar,0
R_AmtInWords=varchar,0
[rpt_chart]
C_Id=decimal,0
C_MacId=decimal,0
C_Images=longblob,0
C_Visible=varchar,0
[rpt_cheque]
Chq_Id=decimal,0
Chq_MacId=decimal,0
Chq_Date=datetime,0
Chq_PayToName=varchar,0
Chq_Amount=decimal,2
Chq_AmtInWords=varchar,0
Chq_AmtInWords1=varchar,0
Chq_AccPayee=varchar,0
Chq_Remarks1=varchar,0
Chq_Remarks2=varchar,0
[rpt_finalaccounts]
T_Id=decimal,0
T_MacId=decimal,0
T_Date=datetime,0
T_SrNo=decimal,0
T_AccId=decimal,0
T_AccName=varchar,0
T_PrtDebiitId=decimal,0
T_PrtDebitName=varchar,0
T_PrtDebitTotalAmt=decimal,2
T_PrtDebitAmt=varchar,0
T_PrtCreditId=decimal,0
T_PrtCreditName=varchar,0
T_PrtCreditTotalAmt=decimal,2
T_PrtCreditAmt=varchar,0
T_PrtDLevel=decimal,0
T_PrtDType=char,0
T_PrtCLevel=decimal,0
T_PrtCType=char,0
T_ProfitAmt=decimal,2
T_LossAmt=decimal,2
T_ToatalAmt=decimal,2
T_CreditBal=decimal,2
T_DebitBal=decimal,2
T_DiffDebitBal=decimal,2
T_DittCreditBal=decimal,2
T_Extra1=varchar,0
T_Extra2=varchar,0
T_Extra3=varchar,0
T_Visible=char,0
T_OpeningCr=decimal,2
T_OpeningDr=decimal,2
T_DiffOpCr=decimal,2
T_DiffOpDr=decimal,2
T_TotalOpCr=decimal,2
T_TotalOpDr=decimal,2
T_Debit=decimal,2
T_Credit=decimal,2
T_DiffDebit=decimal,2
T_DiffCredit=decimal,2
T_TotalDebit=decimal,2
T_TotalCredit=decimal,2
[rpt_gst]
G_Id=decimal,0
G_MacId=decimal,0
G_RecId=decimal,0
G_FinancialYear=varchar,0
G_Month=varchar,0
G_Year=varchar,0
G_Fromdate=datetime,0
G_ToDate=datetime,0
G_GSTNoAcc=varchar,0
G_GSTNo=varchar,0
G_CompanyName=varchar,0
G_ITaxable=decimal,2
G_IIGST=decimal,2
G_ICGST=decimal,2
G_ISGST=decimal,2
G_ICessAmt=decimal,2
G_PTaxable=decimal,2
G_PIGST=decimal,2
G_PCGST=decimal,2
G_PSGST=decimal,2
G_PCessAmt=decimal,2
G_JTaxable=decimal,2
G_JIGST=decimal,2
G_JCGST=decimal,2
G_JSGST=decimal,2
G_JCessAmt=decimal,2
G_ACTaxable=decimal,2
G_ACIGST=decimal,2
G_ACCGST=decimal,2
G_ACSGST=decimal,2
G_ACCessAmt=decimal,2
G_ETaxable=decimal,2
G_EIGST=decimal,2
G_ECGST=decimal,2
G_ESGST=decimal,2
G_ECessAmt=decimal,2
G_SRTaxable=decimal,2
G_SRIGST=decimal,2
G_SRCGST=decimal,2
G_SRSGST=decimal,2
G_SRCessAmt=decimal,2
G_PRTaxable=decimal,2
G_PRIGST=decimal,2
G_PRCGST=decimal,2
G_PRSGST=decimal,2
G_PRCessAmt=decimal,2
G_I1Taxable=decimal,2
G_I1IGST=decimal,2
G_I1CGST=decimal,2
G_I1SGST=decimal,2
G_I1CessAmt=decimal,2
G_ITaxableUR=decimal,2
G_IIGSTUR=decimal,2
G_ICGSTUR=decimal,2
G_ISGSTUR=decimal,2
G_ICessAmtUR=decimal,2
G_PTaxableUR=decimal,2
G_PIGSTUR=decimal,2
G_PCGSTUR=decimal,2
G_PSGSTUR=decimal,2
G_PCessAmtUR=decimal,2
G_JTaxableUR=decimal,2
G_JIGSTUR=decimal,2
G_JCGSTUR=decimal,2
G_JSGSTUR=decimal,2
G_JCessAmtUR=decimal,2
G_ACTaxableUR=decimal,2
G_ACIGSTUR=decimal,2
G_ACCGSTUR=decimal,2
G_ACSGSTUR=decimal,2
G_ACCessAmtUR=decimal,2
G_ETaxableUR=decimal,2
G_EIGSTUR=decimal,2
G_ECGSTUR=decimal,2
G_ESGSTUR=decimal,2
G_ECessAmtUR=decimal,2
G_ITaxableUrR=decimal,2
G_IIGSTUrR=decimal,2
G_ICGSTUrR=decimal,2
G_ISGSTUrR=decimal,2
G_ICessAmtUrR=decimal,2
G_PTaxableUrR=decimal,2
G_PIGSTUrR=decimal,2
G_PCGSTUrR=decimal,2
G_PSGSTUrR=decimal,2
G_SRTaxableUrR=decimal,2
G_SRIGSTUrR=decimal,2
G_SRCGSTUrR=decimal,2
G_SRSGSTUrR=decimal,2
G_SRCessAmtUrR=decimal,2
G_PRTaxableUrR=decimal,2
G_PRIGSTUrR=decimal,2
G_PRCGSTUrR=decimal,2
G_PRSGSTUrR=decimal,2
G_PRCessAmtUrR=decimal,2
G_PCessAmtUrR=decimal,2
G_PlaceOfSupply=varchar,0
G_TotalTaxable3=decimal,2
G_TotalIGST3=decimal,2
G_Remarks=varchar,0
G_Remarks1=varchar,0
G_Remarks2=varchar,0
[rpt_invoice]
IM_Id=decimal,0
IM_MacId=decimal,0
IM_RecId=decimal,0
IM_UserId=decimal,0
IM_Type=varchar,0
IM_InvNo=decimal,0
IM_InvoiceNo=varchar,0
IM_TaxTypeId=decimal,0
IM_TaxTypeName=varchar,0
IM_InvoiceTypeId=decimal,0
IM_InvoiceTypeName=varchar,0
IM_EntryDate=varchar,0
IM_Date=datetime,0
IM_OrderNo=varchar,0
IM_OrderDate=varchar,0
IM_ChallanNo=varchar,0
IM_ChallanDate=datetime,0
IM_LRNo=varchar,0
IM_LRDate=datetime,0
IM_CustRefNo=varchar,0
IM_OtherRef=varchar,0
IM_BaleNo=varchar,0
IM_NoOfBale=varchar,0
IM_CashCredit=varchar,0
IM_CPartyId=decimal,0
IM_CPartyName=varchar,0
IM_CustId=decimal,0
IM_Cust2Id=decimal,0
IM_CustName=varchar,0
IM_Cust2Name=varchar,0
IM_CtPerson1=varchar,0
IM_CtPerson2=varchar,0
IM_CustAdd1=varchar,0
IM_CustAdd2=varchar,0
IM_CustAdd3=varchar,0
IM_Area=varchar,0
IM_City=varchar,0
IM_Pin=varchar,0
IM_State=varchar,0
IM_Country=varchar,0
IM_PhoneNo1=varchar,0
IM_PhoneNo2=varchar,0
IM_PhoneR=varchar,0
IM_Fax=varchar,0
IM_Mobile1=varchar,0
IM_Mobile2=varchar,0
IM_Email=varchar,0
IM_Website=varchar,0
IM_DLNo1=varchar,0
IM_DLNo2=varchar,0
IM_PrintingAddress=varchar,0
IM_CSTNo=varchar,0
IM_TinNo=varchar,0
IM_PanNo=varchar,0
IM_EccNo=varchar,0
IM_ESICNo=varchar,0
IM_OANo=varchar,0
IM_RegistrationNo=varchar,0
IM_PFNo=varchar,0
IM_SPartyId=decimal,0
IM_SPartyName=varchar,0
IM_SuppId=decimal,0
IM_Supp2Id=decimal,0
IM_SuppName=varchar,0
IM_Supp2Name=varchar,0
IM_SalesAccId=decimal,0
IM_SalesAccName=varchar,0
IM_Tax1AccId=decimal,0
IM_Tax1AccName=varchar,0
IM_Tax2AccId=decimal,0
IM_Tax3AccId=decimal,0
IM_Tax2AccName=varchar,0
IM_SalesDrAccId=decimal,0
IM_SalesDrAccName=varchar,0
IM_AgentId=decimal,0
IM_AgentName=varchar,0
IM_SubAgentId=decimal,0
IM_SubAgentName=varchar,0
IM_HasteId=decimal,0
IM_HasteName=varchar,0
IM_Transport=varchar,0
IM_From=varchar,0
IM_To=varchar,0
IM_DeliveryAt=varchar,0
IM_Freight=varchar,0
IM_Weight=varchar,0
IM_Courier=varchar,0
IM_Insurance=varchar,0
IM_RNo=varchar,0
IM_Remarks1=varchar,0
IM_Remarks2=varchar,0
IM_Remarks3=varchar,0
IM_Note1=varchar,0
IM_Note2=varchar,0
IM_Note3=varchar,0
IM_TotalAmt01=decimal,2
IM_Charges01Desc=varchar,0
IM_Charges01Perc=varchar,0
IM_Charges01Amt=decimal,2
IM_Charges02Desc=varchar,0
IM_Charges02Perc=varchar,0
IM_Charges02Amt=decimal,2
IM_Charges03Desc=varchar,0
IM_Charges03Perc=varchar,0
IM_Charges03Amt=decimal,2
IM_Charges04Desc=varchar,0
IM_Charges04Perc=varchar,0
IM_Charges04Amt=decimal,2
IM_Charges05Desc=varchar,0
IM_Charges05Perc=varchar,0
IM_Charges05Amt=decimal,2
IM_TotalAmt02=decimal,2
IM_Tax01Desc=varchar,0
IM_Tax01Perc=varchar,0
IM_Tax01Amt=decimal,2
IM_Tax02Desc=varchar,0
IM_Tax02Perc=varchar,0
IM_Tax02Amt=decimal,2
IM_Tax03Desc=varchar,0
IM_Tax03Perc=varchar,0
IM_Tax03Amt=decimal,2
IM_Tax04Desc=varchar,0
IM_Tax04Perc=varchar,0
IM_Tax04Amt=decimal,2
IM_Tax05Desc=varchar,0
IM_Tax05Perc=varchar,0
IM_Tax05Amt=decimal,2
IM_TotalAmt03=decimal,2
IM_Charges06Desc=varchar,0
IM_Charges06Perc=varchar,0
IM_Charges06Amt=decimal,2
IM_Charges07Desc=varchar,0
IM_Charges07Perc=varchar,0
IM_Charges07Amt=decimal,2
IM_Charges08Desc=varchar,0
IM_Charges08Perc=varchar,0
IM_Charges08Amt=decimal,2
IM_Charges09Desc=varchar,0
IM_Charges09Perc=varchar,0
IM_Charges09Amt=decimal,2
IM_Charges10Desc=varchar,0
IM_Charges10Perc=varchar,0
IM_Charges10Amt=decimal,2
IM_TotalAmt04=decimal,2
IM_Tax06Desc=varchar,0
IM_Tax06Perc=varchar,0
IM_Tax06Amt=decimal,2
IM_Tax07Desc=varchar,0
IM_Tax07Perc=varchar,0
IM_Tax07Amt=decimal,2
IM_Tax08Desc=varchar,0
IM_Tax08Perc=varchar,0
IM_Tax08Amt=decimal,2
IM_Tax09Desc=varchar,0
IM_Tax09Perc=varchar,0
IM_Tax09Amt=decimal,2
IM_Tax10Desc=varchar,0
IM_Tax10Perc=varchar,0
IM_Tax10Amt=decimal,2
IM_TotalAmt05=decimal,2
IM_Charges11Desc=varchar,0
IM_Charges11Perc=varchar,0
IM_Charges11Amt=decimal,2
IM_Charges12Desc=varchar,0
IM_Charges12Perc=varchar,0
IM_Charges12Amt=decimal,2
IM_Charges13Desc=varchar,0
IM_Charges13Perc=varchar,0
IM_Charges13Amt=decimal,2
IM_Charges14Desc=varchar,0
IM_Charges14Perc=varchar,0
IM_Charges14Amt=decimal,2
IM_Charges15Desc=varchar,0
IM_Charges15Perc=varchar,0
IM_Charges15Amt=decimal,2
IM_TotalAmt06=decimal,2
IM_RndOff=decimal,2
IM_BillAmt=decimal,2
IM_BillAountInWords=varchar,0
IM_AddInStock=varchar,0
IM_VoucherId=decimal,0
IM_PymtDays=decimal,0
IM_PaymentRemarks=varchar,0
IM_ChallanIds=varchar,0
IM_Previous=varchar,0
IM_Next=varchar,0
IM_Paid=varchar,0
IM_Cleared=char,0
IM_ManualCLeared=char,0
IM_PackedBy=varchar,0
IM_PackingCharges=decimal,2
IM_PackingPaidFlag=varchar,0
IM_DeliveredBy=varchar,0
IM_DeliveryCharges=decimal,2
IM_DeliveryPaidFlag=varchar,0
IM_DueDate=varchar,0
IM_BankAcNo=varchar,0
IM_OriginalDup=varchar,0
IM_CashCreditMemo=varchar,0
IM_InvoiceType=varchar,0
IM_MaxSrNo=decimal,0
IM_DFactor=decimal,0
IT_Id=decimal,0
IT_SrNo=decimal,0
IT_ItemId=decimal,0
IT_ItemId1=decimal,0
IT_ItemName=varchar,0
IT_Cut=decimal,3
IT_Packing=decimal,3
IT_Pcs=decimal,3
IT_Mtrs=decimal,3
IT_RateType=varchar,0
IT_StockQty=decimal,3
IT_InvQty=decimal,3
IT_Rate=decimal,3
IT_SubTotal=decimal,3
IT_Desc1=varchar,0
IT_Desc2=varchar,0
IT_Desc3=varchar,0
IT_Desc4=varchar,0
IT_Remark1=varchar,0
IT_Remark2=varchar,0
IT_Remark3=varchar,0
IT_Remark4=varchar,0
IT_Extra1=varchar,0
IT_Extra2=varchar,0
IT_Extra3=varchar,0
IT_Extra4=varchar,0
IT_StockRemarks=varchar,0
IT_RefId=decimal,0
IT_RefType=varchar,0
IT_CLeared=char,0
IT_ManualCLeared=char,0
IM_Visible=char,0
IM_OrderId=decimal,0
IM_NetPymtDays=decimal,0
IM_DiscPer=decimal,2
IT_ChallanId=decimal,0
IT_OrderId=decimal,0
IM_DeliverDate=datetime,0
IM_RateListId=decimal,0
IT_DisPer=decimal,2
IT_VatPer=decimal,2
IT_AddTaxPer=decimal,2
IT_DisAmt=decimal,2
IT_VatAmt=decimal,2
IT_AddtaxAmt=decimal,2
IT_ToatalRare1=decimal,2
IT_ToatalRare2=decimal,2
IT_ToatalRare3=decimal,2
IT_MRP=decimal,2
IT_PTR=decimal,2
IT_PTS=decimal,2
IT_FreeQty=decimal,2
IT_MfgDate=datetime,0
IT_Flag=decimal,0
IM_Chrg1Amt=decimal,2
IM_Chrg2Amt=decimal,2
IM_Chrg3Amt=decimal,2
IM_Chrg4Amt=decimal,2
IM_Chrg5Amt=decimal,2
IM_Chrg6Amt=decimal,2
IM_Chrg7Amt=decimal,2
IM_Chrg8Amt=decimal,2
IM_Chrg9Amt=decimal,2
IM_RcvdDate=datetime,0
IM_NetAmt=decimal,2
IM_CommPer=decimal,3
IM_AgentCommPer=decimal,3
IM_CommDue=decimal,2
IM_CommRcvd=decimal,2
IM_CommFlag=char,0
IM_VId=decimal,0
IM_RefId=decimal,0
IM_RcvdChallan=varchar,0
IM_Tax3AccName=varchar,0
[rpt_invoicecmp]
IM_Id=decimal,0
IM_MacId=decimal,0
IM_RecId=decimal,0
IM_UserId=decimal,0
IM_Type=varchar,0
IM_InvNo=decimal,0
IM_InvoiceNo=varchar,0
IM_TaxTypeId=decimal,0
IM_TaxTypeName=varchar,0
IM_InvoiceTypeId=decimal,0
IM_InvoiceTypeName=varchar,0
IM_EntryDate=varchar,0
IM_Date=datetime,0
IM_OrderNo=varchar,0
IM_OrderDate=varchar,0
IM_ChallanNo=varchar,0
IM_ChallanDate=datetime,0
IM_LRNo=varchar,0
IM_LRDate=datetime,0
IM_CustRefNo=varchar,0
IM_OtherRef=varchar,0
IM_BaleNo=varchar,0
IM_NoOfBale=varchar,0
IM_CashCredit=varchar,0
IM_CPartyId=decimal,0
IM_CPartyName=varchar,0
IM_CustId=decimal,0
IM_Cust2Id=decimal,0
IM_CustName=varchar,0
IM_Cust2Name=varchar,0
IM_CtPerson1=varchar,0
IM_CtPerson2=varchar,0
IM_CustAdd1=varchar,0
IM_CustAdd2=varchar,0
IM_CustAdd3=varchar,0
IM_Area=varchar,0
IM_City=varchar,0
IM_Pin=varchar,0
IM_State=varchar,0
IM_Country=varchar,0
IM_PhoneNo1=varchar,0
IM_PhoneNo2=varchar,0
IM_PhoneR=varchar,0
IM_Fax=varchar,0
IM_Mobile1=varchar,0
IM_Mobile2=varchar,0
IM_Email=varchar,0
IM_Website=varchar,0
IM_DLNo1=varchar,0
IM_DLNo2=varchar,0
IM_PrintingAddress=varchar,0
IM_CSTNo=varchar,0
IM_TinNo=varchar,0
IM_PanNo=varchar,0
IM_EccNo=varchar,0
IM_ESICNo=varchar,0
IM_OANo=varchar,0
IM_RegistrationNo=varchar,0
IM_PFNo=varchar,0
IM_SPartyId=decimal,0
IM_SPartyName=varchar,0
IM_SuppId=decimal,0
IM_Supp2Id=decimal,0
IM_SuppName=varchar,0
IM_Supp2Name=varchar,0
IM_SalesAccId=decimal,0
IM_SalesAccName=varchar,0
IM_Tax1AccId=decimal,0
IM_Tax1AccName=varchar,0
IM_Tax2AccId=decimal,0
IM_Tax3AccId=decimal,0
IM_Tax2AccName=varchar,0
IM_SalesDrAccId=decimal,0
IM_SalesDrAccName=varchar,0
IM_AgentId=decimal,0
IM_AgentName=varchar,0
IM_SubAgentId=decimal,0
IM_SubAgentName=varchar,0
IM_HasteId=decimal,0
IM_HasteName=varchar,0
IM_Transport=varchar,0
IM_From=varchar,0
IM_To=varchar,0
IM_DeliveryAt=varchar,0
IM_Freight=varchar,0
IM_Weight=varchar,0
IM_Courier=varchar,0
IM_Insurance=varchar,0
IM_RNo=varchar,0
IM_Remarks1=varchar,0
IM_Remarks2=varchar,0
IM_Remarks3=varchar,0
IM_Note1=varchar,0
IM_Note2=varchar,0
IM_Note3=varchar,0
IM_TotalAmt01=decimal,2
IM_Charges01Desc=varchar,0
IM_Charges01Perc=varchar,0
IM_Charges01Amt=decimal,2
IM_Charges02Desc=varchar,0
IM_Charges02Perc=varchar,0
IM_Charges02Amt=decimal,2
IM_Charges03Desc=varchar,0
IM_Charges03Perc=varchar,0
IM_Charges03Amt=decimal,2
IM_Charges04Desc=varchar,0
IM_Charges04Perc=varchar,0
IM_Charges04Amt=decimal,2
IM_Charges05Desc=varchar,0
IM_Charges05Perc=varchar,0
IM_Charges05Amt=decimal,2
IM_TotalAmt02=decimal,2
IM_Tax01Desc=varchar,0
IM_Tax01Perc=varchar,0
IM_Tax01Amt=decimal,2
IM_Tax02Desc=varchar,0
IM_Tax02Perc=varchar,0
IM_Tax02Amt=decimal,2
IM_Tax03Desc=varchar,0
IM_Tax03Perc=varchar,0
IM_Tax03Amt=decimal,2
IM_Tax04Desc=varchar,0
IM_Tax04Perc=varchar,0
IM_Tax04Amt=decimal,2
IM_Tax05Desc=varchar,0
IM_Tax05Perc=varchar,0
IM_Tax05Amt=decimal,2
IM_TotalAmt03=decimal,2
IM_Charges06Desc=varchar,0
IM_Charges06Perc=varchar,0
IM_Charges06Amt=decimal,2
IM_Charges07Desc=varchar,0
IM_Charges07Perc=varchar,0
IM_Charges07Amt=decimal,2
IM_Charges08Desc=varchar,0
IM_Charges08Perc=varchar,0
IM_Charges08Amt=decimal,2
IM_Charges09Desc=varchar,0
IM_Charges09Perc=varchar,0
IM_Charges09Amt=decimal,2
IM_Charges10Desc=varchar,0
IM_Charges10Perc=varchar,0
IM_Charges10Amt=decimal,2
IM_TotalAmt04=decimal,2
IM_Tax06Desc=varchar,0
IM_Tax06Perc=varchar,0
IM_Tax06Amt=decimal,2
IM_Tax07Desc=varchar,0
IM_Tax07Perc=varchar,0
IM_Tax07Amt=decimal,2
IM_Tax08Desc=varchar,0
IM_Tax08Perc=varchar,0
IM_Tax08Amt=decimal,2
IM_Tax09Desc=varchar,0
IM_Tax09Perc=varchar,0
IM_Tax09Amt=decimal,2
IM_Tax10Desc=varchar,0
IM_Tax10Perc=varchar,0
IM_Tax10Amt=decimal,2
IM_TotalAmt05=decimal,2
IM_Charges11Desc=varchar,0
IM_Charges11Perc=varchar,0
IM_Charges11Amt=decimal,2
IM_Charges12Desc=varchar,0
IM_Charges12Perc=varchar,0
IM_Charges12Amt=decimal,2
IM_Charges13Desc=varchar,0
IM_Charges13Perc=varchar,0
IM_Charges13Amt=decimal,2
IM_Charges14Desc=varchar,0
IM_Charges14Perc=varchar,0
IM_Charges14Amt=decimal,2
IM_Charges15Desc=varchar,0
IM_Charges15Perc=varchar,0
IM_Charges15Amt=decimal,2
IM_TotalAmt06=decimal,2
IM_RndOff=decimal,2
IM_BillAmt=decimal,2
IM_BillAountInWords=varchar,0
IM_AddInStock=varchar,0
IM_VoucherId=decimal,0
IM_PymtDays=decimal,0
IM_PaymentRemarks=varchar,0
IM_ChallanIds=varchar,0
IM_Previous=varchar,0
IM_Next=varchar,0
IM_Paid=varchar,0
IM_Cleared=char,0
IM_ManualCLeared=char,0
IM_PackedBy=varchar,0
IM_PackingCharges=decimal,2
IM_PackingPaidFlag=varchar,0
IM_DeliveredBy=varchar,0
IM_DeliveryCharges=decimal,2
IM_DeliveryPaidFlag=varchar,0
IM_DueDate=varchar,0
IM_BankAcNo=varchar,0
IM_OriginalDup=varchar,0
IM_CashCreditMemo=varchar,0
IM_InvoiceType=varchar,0
IM_MaxSrNo=decimal,0
IM_DFactor=decimal,0
IT_Id=decimal,0
IT_SrNo=decimal,0
IT_ItemId=decimal,0
IT_ItemId1=decimal,0
IT_ItemName=varchar,0
IT_Cut=decimal,2
IT_Packing=decimal,2
IT_Pcs=decimal,2
IT_Mtrs=decimal,2
IT_RateType=varchar,0
IT_StockQty=decimal,2
IT_InvQty=decimal,2
IT_Rate=decimal,2
IT_SubTotal=decimal,2
IT_Desc1=varchar,0
IT_Desc2=varchar,0
IT_Desc3=varchar,0
IT_Desc4=varchar,0
IT_Remark1=varchar,0
IT_Remark2=varchar,0
IT_Remark3=varchar,0
IT_Remark4=varchar,0
IT_Extra1=varchar,0
IT_Extra2=varchar,0
IT_Extra3=varchar,0
IT_Extra4=varchar,0
IT_StockRemarks=varchar,0
IT_RefId=decimal,0
IT_RefType=varchar,0
IT_CLeared=char,0
IT_ManualCLeared=char,0
IM_Visible=char,0
IM_OrderId=decimal,0
IM_NetPymtDays=decimal,0
IM_DiscPer=decimal,2
IT_ChallanId=decimal,0
IT_OrderId=decimal,0
IM_DeliverDate=datetime,0
IM_RateListId=decimal,0
IT_DisPer=decimal,2
IT_VatPer=decimal,2
IT_AddTaxPer=decimal,2
IT_DisAmt=decimal,2
IT_VatAmt=decimal,2
IT_AddtaxAmt=decimal,2
IT_ToatalRare1=decimal,2
IT_ToatalRare2=decimal,2
IT_ToatalRare3=decimal,2
IT_MRP=decimal,2
IT_PTR=decimal,2
IT_PTS=decimal,2
IT_FreeQty=decimal,2
IT_MfgDate=datetime,0
IT_Flag=decimal,0
IM_Chrg1Amt=decimal,2
IM_Chrg2Amt=decimal,2
IM_Chrg3Amt=decimal,2
IM_Chrg4Amt=decimal,2
IM_Chrg5Amt=decimal,2
IM_Chrg6Amt=decimal,2
IM_Chrg7Amt=decimal,2
IM_Chrg8Amt=decimal,2
IM_Chrg9Amt=decimal,2
IM_RcvdDate=datetime,0
IM_NetAmt=decimal,2
IM_CommPer=decimal,2
IM_AgentCommPer=decimal,2
IM_CommDue=decimal,2
IM_CommRcvd=decimal,2
IM_CommFlag=char,0
IM_VId=decimal,0
IM_RefId=decimal,0
IM_RcvdChallan=varchar,0
IM_Tax3AccName=varchar,0
IM_CompanyName=varchar,0
IM_CmpName=varchar,0
IM_CustCity=varchar,0
IM_AgentCity=varchar,0
[rpt_item_images]
IM_ItemId=decimal,0
IM_MacId=decimal,0
IM_ImagePath=varchar,0
IM_Image=mediumblob,0
[rpt_itemledger]
L_Id=decimal,0
L_MacId=decimal,0
L_Date=datetime,0
L_RefNo=varchar,0
L_VchNo=varchar,0
L_AccId=decimal,0
L_AccName=varchar,0
L_Particulars=varchar,0
L_Narration=varchar,0
L_Type=char,0
L_InwordQty=decimal,2
L_OutwordQty=decimal,2
L_BalQty=decimal,2
L_ClosingDrQty=decimal,2
L_ClosingCrQty=decimal,2
L_GrandTotal=decimal,2
L_ClosingDate=datetime,0
L_Sign=char,0
L_Extra=varchar,0
L_Extra1=varchar,0
L_Extra2=varchar,0
L_Extra3=varchar,0
L_Extra4=varchar,0
L_FromDate=varchar,0
L_Todate=varchar,0
L_Month=varchar,0
L_Year=varchar,0
L_ItemName=varchar,0
L_BatchName=varchar,0
L_GroupName=varchar,0
L_ExDate=datetime,0
L_MfgDate=datetime,0
L_MRP=decimal,2
L_PTS=decimal,2
L_PTR=decimal,2
L_SRate=decimal,2
L_PRate=decimal,2
[rpt_items]
IM_ItemId=decimal,0
IM_MacId=decimal,0
IM_UserId=decimal,0
IM_ItemName=varchar,0
IM_ItemDesc=varchar,0
IM_Flag=char,0
IM_GrpNo=decimal,0
IM_Opening=decimal,2
IM_Closing=decimal,2
IM_ReOrderLevel=decimal,2
IM_UnitId=decimal,0
IM_Image=varchar,0
IM_PRate1=decimal,2
IM_PRate2=decimal,2
IM_PRate3=decimal,2
IM_PRate4=decimal,2
IM_SRate1=decimal,2
IM_SRate2=decimal,2
IM_SRate3=decimal,2
IM_SRate4=decimal,2
IM_HSNCode=varchar,0
IM_Tax1Perc=decimal,2
IM_Tax2Perc=decimal,2
IM_Tax3Perc=decimal,2
IM_Grp1=decimal,0
IM_Grp2=decimal,0
IM_Grp3=decimal,0
IM_Grp4=decimal,0
IM_Grp5=decimal,0
IM_packing=varchar,0
IM_CutAvg=varchar,0
IM_Remark1=varchar,0
IM_Remark2=varchar,0
IM_Remark3=varchar,0
IM_Extra1=varchar,0
IM_Extra2=varchar,0
IM_Extra3=varchar,0
IM_Extra4=varchar,0
IM_Extra5=varchar,0
IM_MfgDate=datetime,0
IM_ExpDate=datetime,0
IM_BrandId=decimal,0
IM_CustId=decimal,0
IM_CustName=varchar,0
IM_Visible=char,0
IM_UnitName=varchar,0
IM_ItemCode=varchar,0
IM_Prefix=varchar,0
IM_ItemNo=decimal,0
IM_ItemNumber=varchar,0
IM_Vat=decimal,2
IM_AddTax=decimal,2
IM_Composition=varchar,0
[rpt_ledger]
L_Id=decimal,0
L_MacId=decimal,0
L_Date=datetime,0
L_RefNo=varchar,0
L_VchNo=varchar,0
L_AccId=decimal,0
L_AccName=varchar,0
L_Particulars=varchar,0
L_Narration=varchar,0
L_Type=char,0
L_DebitAmt=decimal,2
L_CreditAmt=decimal,2
L_BalAmt=varchar,0
L_ClosingDrBal=decimal,2
L_ClosingCrBal=decimal,2
L_GrandTotal=decimal,2
L_ClosingDate=datetime,0
L_Sign=char,0
L_Extra=varchar,0
L_Extra1=varchar,0
L_Extra2=varchar,0
L_Extra3=varchar,0
L_Extra4=varchar,0
L_FromDate=varchar,0
L_Todate=varchar,0
L_Month=varchar,0
L_Year=varchar,0
L_Remarks=varchar,0
L_Remarks1=varchar,0
L_Remarks2=varchar,0
L_Remarks3=varchar,0
L_Flag1=varchar,0
L_Flag2=varchar,0
L_Flag3=varchar,0
[rpt_stockmaster]
S_Id=decimal,0
S_MacId=decimal,0
S_RecId=decimal,0
S_Year=varchar,0
S_EntryDate=datetime,0
S_ModifiedDate=datetime,0
S_Date=datetime,0
S_EntryNo=varchar,0
S_SrNo=decimal,0
S_SerialNo=decimal,0
S_VoucherType=varchar,0
S_BillNo=varchar,0
S_StrBillNo=varchar,0
S_AccId=decimal,0
S_AccName=varchar,0
S_SalesAccId=decimal,0
S_ItemId=decimal,0
S_ItemName=varchar,0
S_UnitId=decimal,0
S_UnitName=varchar,0
S_ItemId2=decimal,0
S_Opening=decimal,2
S_Closing=decimal,2
S_Qty=decimal,2
S_QtySign=char,0
S_Remarks=varchar,0
S_Rate=decimal,2
S_RollNo=varchar,0
S_Category=varchar,0
S_Size=varchar,0
S_Godown=varchar,0
S_RackNo=varchar,0
S_Color=varchar,0
S_ColorIds=varchar,0
S_Extra1=varchar,0
S_Extra2=varchar,0
S_Extra3=varchar,0
S_VchFlag=varchar,0
S_Cleared=varchar,0
S_Add1=varchar,0
S_Add2=varchar,0
S_Add3=varchar,0
S_Add4=varchar,0
S_Add5=varchar,0
S_Add6=varchar,0
S_Add7=varchar,0
S_add8=varchar,0
S_Add9=varchar,0
S_LrNo=varchar,0
S_RcvdStock=decimal,0
S_XS=decimal,2
S_S=decimal,2
S_M=decimal,2
S_L=decimal,2
S_XL=decimal,2
S_2XL=decimal,2
S_3XL=decimal,2
S_4XL=decimal,2
S_5XL=decimal,2
S_6XL=decimal,2
S_7XL=decimal,2
S_8XL=decimal,2
S_9XL=decimal,2
S_10XL=decimal,2
S_FREESIZE=decimal,2
S_level=decimal,0
[rpt_vouchers]
R_Id=decimal,0
R_Date=datetime,0
R_InvDate=datetime,0
R_MacId=decimal,0
R_VchNo=decimal,0
R_VoucherNo=varchar,0
R_RefId=decimal,0
R_RefType=varchar,0
R_SrNo=decimal,0
R_CustName=varchar,0
R_CustAmt=decimal,2
R_CustAmtSign=varchar,0
R_SuppName=varchar,0
R_SuppAmt=decimal,2
R_SuppAmtSign=varchar,0
R_CustAdd=varchar,0
R_SuppAdd=varchar,0
R_Acc1Name=varchar,0
R_Acc1Amt=decimal,2
R_Acc1AmtSign=char,0
R_Acc2Name=varchar,0
R_Acc2Amt=decimal,2
R_Acc2AmtSign=char,0
R_Acc3Name=varchar,0
R_Acc3Amt=decimal,2
R_Acc3AmtSign=char,0
R_Acc4Name=varchar,0
R_Acc4Amt=decimal,2
R_Acc4AmtSign=char,0
R_Acc5Name=varchar,0
R_Acc5Amt=decimal,2
R_Acc5AmtSign=char,0
R_Acc6Name=varchar,0
R_Acc6Amt=decimal,2
R_Acc6AmtSign=char,0
R_Acc7Name=varchar,0
R_Acc7Amt=decimal,2
R_Acc7AmtSign=char,0
R_Acc8Name=varchar,0
R_Acc8Amt=decimal,2
R_Acc8AmtSign=char,0
R_Acc9Name=varchar,0
R_Acc9Amt=decimal,2
R_Acc9AmtSign=char,0
R_Amount=decimal,2
R_Sign=char,0
R_Remarks=varchar,0
R_AmountInWords=varchar,0
R_Extra1=varchar,0
R_Extra2=varchar,0
R_Extra3=varchar,0
R_Type=varchar,0
R_InvNo=varchar,0
R_InvAmt=decimal,2
R_RcvdAmt=decimal,2
R_PendingAmt=decimal,2
R_Visible=char,0
R_DFactore=decimal,0
RT_SrNo=decimal,0
RT_AccId=decimal,0
RT_AccName=varchar,0
RT_Amt=decimal,2
RT_Sign=char,0
RT_MaxSrNo=decimal,0
RD_Id=decimal,0
RD_SrNo=decimal,0
RD_Type=varchar,0
RD_RefId=decimal,0
RD_RefType=varchar,0
RD_Date=datetime,0
RD_AccId=decimal,0
RD_DrawnOn=varchar,0
RD_Branch=varchar,0
RD_ChqNo=varchar,0
RD_Amt=decimal,2
RD_Remarks=varchar,0
R_CustId=decimal,0
R_SuppId=decimal,0
R_Acc1Id=decimal,0
R_Acc2Id=decimal,0
R_Acc3Id=decimal,0
R_Acc4Id=decimal,0
R_Acc5Id=decimal,0
R_Acc6Id=decimal,0
R_Acc7Id=decimal,0
R_Acc8Id=decimal,0
R_Acc9Id=decimal,0
R_Cust2Id=decimal,0
R_Supp2Id=decimal,0
R_Cust2Name=varchar,0
R_Supp2Name=varchar,0
R_ChqNo=varchar,0
R_ChqDate=datetime,0
R_DrawnOn=varchar,0
R_Branch=varchar,0
[rpt_voucherslist]
V_Id=decimal,0
V_MacId=decimal,0
V_RecId=decimal,0
V_UserId=decimal,0
V_EntryType=varchar,0
V_Date=datetime,0
V_DebitAC=varchar,0
V_DebitAccId=decimal,0
V_CreditAC=varchar,0
V_CreditAccId=decimal,0
V_DebitAmt=decimal,2
V_CreditAmt=decimal,2
V_Amt=decimal,2
V_Amt1=decimal,2
V_Amt2=decimal,2
V_Amt3=decimal,2
V_Type=varchar,0
V_VchNo=decimal,0
V_VouchersNo=varchar,0
V_Flag=varchar,0
V_Period=varchar,0
V_Extra1=varchar,0
V_Extra2=varchar,0
V_ChqNo=varchar,0
V_ChqDate=datetime,0
V_DrawnOn=varchar,0
V_Branch=varchar,0
[service_type]
st_id=decimal,0
st_name=varchar,0
st_remarks=varchar,0
[setting]
s_id=int,0
s_macid=int,0
s_name=varchar,0
s_keyword=varchar,0
s_value=varchar,0
s_description=varchar,0
[setting_bl]
T_Id=decimal,0
T_No=decimal,0
T_GrpId=decimal,0
T_GrpName=varchar,0
T_GrpDisplayName=varchar,0
T_Type=char,0
T_Level=decimal,0
T_ShowGrpName=char,0
T_ShowLedgers=char,0
T_ShowLedgerClsgBal=char,0
[setting_finalacc]
T_Id=decimal,0
T_GrpId=decimal,0
T_GrpName=varchar,0
T_GrpDisplayName=varchar,0
T_Type=char,0
T_Level=decimal,0
T_ShowGrpName=char,0
T_ShowLedgers=char,0
T_ShowLedgerClsgBal=char,0
T_TBFlag=tinyint,0
T_BLFlag=tinyint,0
T_PLFlag=tinyint,0
T_TAFlag=tinyint,0
T_TBSeq=decimal,0
T_BLSeq=decimal,0
T_PLSeq=decimal,0
T_TASeq=decimal,0
T_DeleteFlag=varchar,0
[setting_pl]
T_Id=decimal,0
T_No=decimal,0
T_GrpId=decimal,0
T_GrpName=varchar,0
T_GrpDisplayName=varchar,0
T_Type=char,0
T_Level=decimal,0
T_ShowGrpName=char,0
T_ShowLedgers=char,0
T_ShowLedgerClsgBal=char,0
[setting_ta]
T_Id=decimal,0
T_No=decimal,0
T_GrpId=decimal,0
T_GrpName=varchar,0
T_GrpDisplayName=varchar,0
T_Type=char,0
T_Level=decimal,0
T_ShowGrpName=char,0
T_ShowLedgers=char,0
T_ShowLedgerClsgBal=char,0
[settings_tb]
T_Id=decimal,0
T_No=decimal,0
T_GrpId=decimal,0
T_GrpName=varchar,0
T_GrpDisplayName=varchar,0
T_Type=char,0
T_Level=decimal,0
T_ShowGrpName=char,0
T_ShowLedgers=char,0
T_ShowLedgerClsgBal=char,0
[size_master]
S_Id=decimal,0
S_Name=varchar,0
S_DefaultValue=decimal,2
S_Type=varchar,0
[stock_master]
S_Id=decimal,0
S_MacId=decimal,0
S_RecId=decimal,0
S_Year=varchar,0
S_EntryDate=datetime,0
S_ModifiedDate=datetime,0
S_Date=datetime,0
S_EntryNo=varchar,0
S_SrNo=decimal,0
S_SerialNo=decimal,0
S_VoucherType=varchar,0
S_BillNo=varchar,0
S_StrBillNo=varchar,0
S_AccId=decimal,0
S_SalesAccId=decimal,0
S_ItemId=decimal,0
S_UnitId=decimal,0
S_ItemId2=decimal,0
S_Qty=decimal,2
S_QtySign=char,0
S_Remarks=varchar,0
S_Rate=decimal,2
S_RollNo=varchar,0
S_Category=varchar,0
S_Size=varchar,0
S_Godown=varchar,0
S_RackNo=varchar,0
S_Color=varchar,0
S_ColorIds=varchar,0
S_Extra1=varchar,0
S_Extra2=varchar,0
S_Extra3=varchar,0
S_VchFlag=varchar,0
S_Cleared=varchar,0
S_Add1=varchar,0
S_Add2=varchar,0
S_Add3=varchar,0
S_Add4=varchar,0
S_Add5=varchar,0
S_Add6=varchar,0
S_Add7=varchar,0
S_add8=varchar,0
S_Add9=varchar,0
S_LrNo=varchar,0
S_RcvdStock=decimal,0
S_XS=decimal,2
S_S=decimal,2
S_M=decimal,2
S_L=decimal,2
S_XL=decimal,2
S_2XL=decimal,2
S_3XL=decimal,2
S_4XL=decimal,2
S_5XL=decimal,2
S_6XL=decimal,2
S_7XL=decimal,2
S_8XL=decimal,2
S_9XL=decimal,2
S_10XL=decimal,2
S_FREESIZE=decimal,2
S_level=decimal,0
[stock_reference]
SR_Id=decimal,0
SR_MacId=decimal,0
SR_RecId=decimal,0
SR_UserId=decimal,0
SR_Year=varchar,0
SR_Type=varchar,0
SR_AccId=decimal,0
SR_SalesAccId=decimal,0
SR_Date=datetime,0
SR_InvNo=varchar,0
SR_BaleNo=varchar,0
SR_RefNo=varchar,0
SR_StrRefNo=varchar,0
SR_SRNo=decimal,0
Sr_SerialNo=decimal,0
SR_ItemId=decimal,0
SR_UnitId=decimal,0
SR_Cut=decimal,2
SR_Qty=decimal,2
SR_Mtrs=decimal,2
SR_Rate=decimal,2
SR_RefId=decimal,0
SR_RefType=varchar,0
SR_Remarks=varchar,0
SR_XS=decimal,2
SR_S=decimal,2
SR_M=decimal,2
SR_L=decimal,2
SR_XL=decimal,2
SR_2XL=decimal,2
SR_3XL=decimal,2
SR_4XL=decimal,2
SR_5XL=decimal,2
SR_6XL=decimal,2
SR_7XL=decimal,2
SR_8XL=decimal,2
SR_9XL=decimal,2
SR_10XL=decimal,2
SR_FREESIZE=decimal,2
SR_Color=varchar,0
SR_ColorIds=varchar,0
SR_Size=varchar,0
SR_Godown=varchar,0
SR_RackNo=varchar,0
SR_Clear=varchar,0
SR_ManualClear=varchar,0
SR_Return=varchar,0
SR_JobType=varchar,0
SR_Level=decimal,0
SR_ProcessType=varchar,0
[test_master]
Id1=decimal,0
String1=varchar,0
double1=decimal,2
date1=datetime,0
Extar1=varchar,0
Extra2=varchar,0
date2=datetime,0
Extra3=decimal,0
[traking_master]
TM_Id=int,0
TM_UserId=decimal,0
TM_MFId=decimal,0
TM_ChallanId=decimal,0
TM_SrNo=decimal,0
TM_Date=datetime,0
TM_Status=varchar,0
TM_Station=varchar,0
TM_Action=varchar,0
TM_Remarks=varchar,0
TM_Updateby=varchar,0
[tyre_master]
T_Id=decimal,0
T_MacId=decimal,0
T_RecId=decimal,0
T_UserId=decimal,0
T_Year=varchar,0
T_EntryType=varchar,0
T_SrNo=decimal,0
T_BillNo=varchar,0
T_BillDate=datetime,0
T_AccId=decimal,0
T_Acc2Id=decimal,0
T_TyreName=varchar,0
T_TyreNo=varchar,0
T_VehicleId=decimal,0
T_Amt=decimal,2
T_AmtInWords=varchar,0
T_StartKM=decimal,2
T_EndKM=decimal,2
T_EndDate=datetime,0
T_TotalSr=decimal,2
T_Ret=decimal,2
T_RetDate=datetime,0
T_RetEndDate=datetime,0
T_TotalRetSr=decimal,2
T_ChqNo=varchar,0
T_ChqDate=datetime,0
T_DrawnOn=varchar,0
T_Branch=varchar,0
T_remarks=varchar,0
[u_reciept_master]
RM_Id=decimal,0
RM_MacId=decimal,0
RM_RecId=decimal,0
RM_Date=datetime,0
RM_BankAccNo=varchar,0
RM_BankId=decimal,0
RM_AccoutName=varchar,0
RM_PhNo=decimal,0
RM_BankName=varchar,0
RM_Add1=varchar,0
RM_Add2=varchar,0
RM_Add3=varchar,0
RM_TotalAmt=decimal,2
RM_AmtInWords=varchar,0
RM_Remarks=varchar,0
RM_DepositeType=varchar,0
[u_reciept_transaction]
RT_Id=decimal,0
RT_SrNo=decimal,0
RT_DrawnOn=varchar,0
RT_BranchName=varchar,0
RT_ChqNo=varchar,0
RT_ChqDate=datetime,0
RT_CustId=decimal,0
RT_CustName=varchar,0
RT_Amt=decimal,2
RT_Remarks=varchar,0
RT_Currency=decimal,0
RT_CurrencyQty=decimal,0
RT_VoucherId=decimal,0
[unit_master]
UM_Id=decimal,0
UM_MacId=decimal,0
UM_RecId=decimal,0
UM_UserId=decimal,0
UM_UnitCode=varchar,0
UM_Unit=varchar,0
UM_Remarks=varchar,0
[url_master]
um_id=int,0
um_url=varchar,0
um_urltype=varchar,0
um_defailt=varchar,0
um_sync=int,0
[user_master]
UM_Id=decimal,0
UM_User=varchar,0
UM_Pwd=varchar,0
UM_Remarks=varchar,0
UM_Dashboard=varchar,0
UM_MenuRights=varchar,0
[vehicle]
V_Id=decimal,0
V_MacId=decimal,0
V_RecId=decimal,0
V_UserId=decimal,0
V_Year=varchar,0
V_Name=varchar,0
V_No=varchar,0
V_Type=varchar,0
V_ModelNo=varchar,0
V_Make=varchar,0
V_Outside=varchar,0
V_InsuranceNo=varchar,0
V_InsuranceCompany=varchar,0
V_InsuranceDate=datetime,0
V_Permit=varchar,0
V_LPermit=varchar,0
V_NPermit=varchar,0
V_LPermitDate=datetime,0
V_NPermitDate=datetime,0
V_FitnessDate=datetime,0
V_PUCDate=datetime,0
V_TaxDate=datetime,0
V_OwnerId=decimal,0
V_AgentId=decimal,0
V_Owner=varchar,0
V_OwnerCompany=varchar,0
V_Weight=decimal,2
V_PanNo=varchar,0
V_TdsApp=varchar,0
V_TDSPer=decimal,2
V_Remarks=varchar,0
V_DeleteFlag=varchar,0
[vouchers]
V_Id=decimal,0
V_MacId=decimal,0
V_RecId=decimal,0
V_UserId=decimal,0
V_Year=varchar,0
V_EntryType=varchar,0
V_SrNo=decimal,0
V_Date=datetime,0
V_EntryDate=datetime,0
V_ModifiedDate=datetime,0
V_AccId=decimal,0
V_Acc2Id=decimal,0
V_Acc3Id=decimal,0
V_Amt=decimal,2
V_AmtInWords=varchar,0
V_Sign=char,0
V_onAccAmt=decimal,2
V_onAccAmt1=decimal,2
V_onAccAmt2=decimal,2
V_RefNo=varchar,0
V_RefType=varchar,0
V_BankName=varchar,0
V_Remarks=varchar,0
V_Type=varchar,0
V_Prefix=varchar,0
V_Suffix=varchar,0
V_VchNo=decimal,0
V_VoucherNo=varchar,0
V_StrVoucherNo=varchar,0
V_Type2=varchar,0
V_Prefix2=varchar,0
V_Suffix2=varchar,0
V_VchNo2=decimal,0
V_VoucherNo2=varchar,0
V_Flag=char,0
V_RecordNo=decimal,0
V_Extra1=varchar,0
V_Extra2=varchar,0
V_Extra3=varchar,0
V_AgainInvNo=varchar,0
V_IsAgainBill=varchar,0
V_ReferenceType=varchar,0
V_AgentId=decimal,0
V_OrderId=decimal,0
V_VehicleId=decimal,0
V_From=varchar,0
V_To=varchar,0
V_ChqNo=varchar,0
V_ChqDate=datetime,0
V_DrawnOn=varchar,0
V_Branch=varchar,0
V_chqNum=decimal,0
V_VchFlag=varchar,0
V_ReferenceFlag=varchar,0
V_BankDate=datetime,0
V_PymtMode=varchar,0
V_TaxableAmt=decimal,2
V_CGSTAmt=decimal,2
V_SGSTAmt=decimal,2
V_IGSTAmt=decimal,2
V_GSTAmt=decimal,2
V_RndAmt=decimal,2
V_GSTType=varchar,0
V_ReverseFlag=varchar,0
V_GSTRate=decimal,2
V_HSNId=decimal,0
V_Cancelled=varchar,0
V_IsCancel=tinyint,0
[vouchers_advance]
V_Id=decimal,0
V_MacId=decimal,0
V_RecId=decimal,0
V_UserId=decimal,0
V_Year=varchar,0
V_EntryType=varchar,0
V_SrNo=decimal,0
V_Date=datetime,0
V_EntryDate=datetime,0
V_AccId=decimal,0
V_Acc2Id=decimal,0
V_Acc3Id=decimal,0
V_Amt=decimal,2
V_AmtInWords=varchar,0
V_Sign=char,0
V_RefNo=varchar,0
V_RefType=varchar,0
V_BankName=varchar,0
V_Remarks=varchar,0
V_Type=varchar,0
V_Prefix=varchar,0
V_Suffix=varchar,0
V_VchNo=decimal,0
V_VoucherNo=varchar,0
V_Flag=char,0
V_Extra1=varchar,0
V_Extra2=varchar,0
V_onAccAmt=decimal,0
V_Extra3=varchar,0
V_AgainInvNo=varchar,0
V_IsAgainBill=varchar,0
V_ReferenceType=varchar,0
V_AgentId=decimal,0
V_VehicleId=decimal,0
V_From=varchar,0
V_To=varchar,0
V_OrderId=decimal,0
V_ChqNo=varchar,0
V_ChqDate=datetime,0
V_DrawnOn=varchar,0
V_Branch=varchar,0
V_VchFlag=varchar,0
[z_cheque_details]
CD_Id=decimal,0
CD_BookNo=varchar,0
CD_MacId=decimal,0
CD_RecId=decimal,0
CD_ChequeNo=decimal,0
CD_Date=datetime,0
CD_PayToId=decimal,0
CD_PayToName=varchar,0
CD_Amount=decimal,2
CD_AmountInWords=varchar,0
CD_Cancelled=char,0
CD_AcPayee=varchar,0
CD_Extra1=varchar,0
CD_Extra2=varchar,0
CD_Extra3=varchar,0
CD_VoucherId=decimal,0
CD_EntryDate=datetime,0
CD_ModifiedDate=datetime,0
[z_cheque_master]
CM_Id=decimal,0
CM_MacId=decimal,0
CM_RecId=decimal,0
CM_Year=varchar,0
CM_BookNo=varchar,0
CM_BankId=decimal,0
CM_BookDate=datetime,0
CM_ChqNoFrom=decimal,0
CM_ChqNoTo=decimal,0
CM_BookName=varchar,0
CM_Complete=char,0
CM_Remarks=varchar,0
[z_einvoice_token]
e_id=int,0
e_token=varchar,0
e_validity=datetime,0
e_remarks=varchar,0
[z_einvoices]
e_Id=decimal,0
e_EntryType=varchar,0
e_Type=varchar,0
e_DocNo=varchar,0
e_DocDate=datetime,0
e_EInvoiceAckNo=varchar,0
e_EInvoiceAckDate=datetime,0
e_EInvoiceIRN=varchar,0
e_EInvoiceRemarks=varchar,0
e_EInvoiceSigned=varchar,0
e_QrCode=longblob,0
[z_ewaybill_token]
e_id=int,0
e_token=varchar,0
e_validity=datetime,0
e_remarks=varchar,0
[z_invoicetype]
Z_Id=decimal,0
Z_InvType=varchar,0
Z_Remarks=varchar,0
[z_keywords]
Z_Id=decimal,0
Z_MacId=decimal,0
Z_RecId=decimal,0
Z_UserId=decimal,0
Z_Flag=char,0
Z_GrpNo=decimal,0
Z_KeyWord=varchar,0
Z_KeyValue=varchar,0
Z_AccountId=decimal,0
Z_Remarks=varchar,0
[z_labelprint]
L_Id=decimal,0
L_MacId=decimal,0
L_ItemName=varchar,0
L_Size=varchar,0
L_Rate=decimal,2
L_Extra1=varchar,0
L_Extra2=varchar,0
L_Extra3=varchar,0
L_MaxNo=decimal,0
[z_menumaster]
ZM_Id=decimal,0
ZM_MenuName=varchar,0
ZM_DisplayName=varchar,0
[z_patch_history]
P_Id=decimal,0
P_VersionNO=varchar,0
P_ShortDesc=varchar,0
P_Description=varchar,0
P_Develope=varchar,0
P_CreatedDate=datetime,0
P_ImplementDate=datetime,0
P_Extra1=varchar,0
P_Extra2=varchar,0
P_Extra3=varchar,0
[z_patch_history_1314]
P_Id=decimal,0
P_VersionNO=varchar,0
P_ShortDesc=varchar,0
P_Description=varchar,0
P_Develope=varchar,0
P_CreatedDate=datetime,0
P_ImplementDate=datetime,0
P_Extra1=varchar,0
P_Extra2=varchar,0
P_Extra3=varchar,0
[z_patch_history_1617]
P_Id=decimal,0
P_MacId=decimal,0
P_VersionNO=varchar,0
P_ShortDesc=varchar,0
P_Description=varchar,0
P_Develope=varchar,0
P_CreatedDate=datetime,0
P_ImplementDate=datetime,0
P_Extra1=varchar,0
P_Extra2=varchar,0
P_Extra3=varchar,0
[z_patch_history_2122]
P_Id=decimal,0
P_MacId=decimal,0
P_VersionNO=varchar,0
P_ShortDesc=varchar,0
P_Description=varchar,0
P_Develope=varchar,0
P_CreatedDate=datetime,0
P_ImplementDate=datetime,0
P_Extra1=varchar,0
P_Extra2=varchar,0
P_Extra3=varchar,0
[z_report_header]
Z_Ganesh1=varchar,0
Z_Ganesh2=varchar,0
Z_Ganesh3=varchar,0
Z_Ganesh4=varchar,0
Z_Ganesh5=varchar,0
Z_CmpName1=varchar,0
Z_CmpName2=varchar,0
Z_CmpName3=varchar,0
Z_CmpName4=varchar,0
Z_CmpName5=varchar,0
Z_Add1=varchar,0
Z_Add2=varchar,0
Z_Add3=varchar,0
Z_Add4=varchar,0
Z_Add5=varchar,0
Z_Phone1=varchar,0
Z_Phone2=varchar,0
Z_Phone3=varchar,0
Z_Phone4=varchar,0
Z_Phone5=varchar,0
Z_Term1=varchar,0
Z_Term2=varchar,0
Z_Term3=varchar,0
Z_Term4=varchar,0
Z_Term5=varchar,0
Z_Visible=char,0
[z_srallocation_details]
D_Id=decimal,0
D_BookNo=varchar,0
D_MacId=decimal,0
D_RecId=decimal,0
D_EntNo=decimal,0
D_BranchId=decimal,0
D_Type=varchar,0
D_LRId=decimal,0
D_Status=tinyint,0
[z_srallocation_master]
M_Id=decimal,0
M_MacId=decimal,0
M_RecId=decimal,0
M_UserId=decimal,0
M_Year=varchar,0
M_BranchId=decimal,0
M_Type=varchar,0
M_BookNo=varchar,0
M_BookDate=datetime,0
M_FromNo=decimal,0
M_ToNo=decimal,0
M_Current=decimal,0
M_Status=tinyint,0
M_Remarks=varchar,0
[z_state_master]
S_Id=decimal,0
S_Name=varchar,0
S_Code=varchar,0
S_Desc=varchar,0
[z_stickerprint]
L_Id=decimal,0
L_MacId=decimal,0
L_ItemId=decimal,0
L_Size=varchar,0
L_Rate=decimal,2
L_Extra1=varchar,0
L_Extra2=varchar,0
L_Extra3=varchar,0
L_MaxNo=decimal,0
[z_taxtype]
Z_Id=decimal,0
Z_TaxType=varchar,0
Z_InvType=varchar,0
Z_Flag=char,0
Z_Remarks=varchar,0
[z_update_history]
P_Id=decimal,0
P_MacId=decimal,0
P_VersionNo=varchar,0
P_ImplementDate=datetime,0
P_ShortDesc=varchar,0
P_Description=varchar,0
P_Extra1=varchar,0
P_Extra2=varchar,0
P_Extra3=varchar,0
[z_userdata]
CASH_ACC=varchar,0
LEVL_CODE=varchar,0
ACC_OPBL=decimal,2
ACC_CLBL=decimal,2
CR_DAYS=varchar,0
BOM_IND=varchar,0
BROK_ACC=varchar,0
COMM_RATE=decimal,2
INT_RATE=decimal,2
ACC_ADD1=varchar,0
ACC_ADD2=varchar,0
ACC_ADD3=varchar,0
ACC_RCNO=varchar,0
ACC_RCNO1=varchar,0
CASH_CQNO=varchar,0
TRANS_NAME=varchar,0
INC_RATE=decimal,2
DR_NOTE=varchar,0
CR_NOTE=varchar,0
STAT_NAME=varchar,0
SALES_TAX=varchar,0
CST_NO=varchar,0
MAS_IND=varchar,0
ACC_SEL=varchar,0
TDS_RATE=decimal,2
SC_RATE=decimal,2
CESS_RATE=decimal,2
[z_userrights]
ZR_UserId=decimal,0
ZR_MenuId=decimal,0
ZR_Active=varchar,0
ZR_Insert=varchar,0
ZR_Update=varchar,0
ZR_Del=varchar,0
ZR_Print=varchar,0
[comp_master]
cm_id=decimal,0
cm_macid=decimal,0
cm_recid=decimal,0
cm_userid=decimal,0
cm_year=varchar,0
cm_branchid=decimal,0
cm_servicetypeid=decimal,0
cm_entrydate=datetime,0
cm_modifieddate=datetime,0
cm_date=datetime,0
cm_prefix=varchar,0
cm_suffix=varchar,0
cm_no=decimal,0
cm_compno=varchar,0
cm_complainno=varchar,0
cm_custid=decimal,0
cm_mobno=varchar,0
cm_phoneno=varchar,0
cm_custadress=varchar,0
cm_email=varchar,0
cm_itemid=decimal,0
cm_ModelDesc=varchar,0
cm_productseriolno=varchar,0
cm_broughtby=varchar,0
cm_accessoriesrcvd=varchar,0
cm_accessoriesname=varchar,0
cm_accessoriesremarks=varchar,0
cm_observation1=varchar,0
cm_observation2=varchar,0
cm_observation3=varchar,0
cm_observation4=varchar,0
cm_observation5=varchar,0
cm_observation6=varchar,0
cm_observation7=varchar,0
cm_observation8=varchar,0
cm_observation9=varchar,0
cm_observation10=varchar,0
cm_description=varchar,0
cm_productcollectedby=varchar,0
cm_priority=varchar,0
cm_status=varchar,0
cm_remarks1=varchar,0
cm_remarks2=varchar,0
cm_remarks3=varchar,0
cm_extra1=varchar,0
cm_extra2=varchar,0
cm_extra3=varchar,0
cm_type=varchar,0
cm_mainengid=decimal,0
cm_enggid=decimal,0
cm_categoryid=decimal,0
cm_comptypeid=decimal,0
cm_compreport=varchar,0
cm_compreporteng=varchar,0
cm_product=varchar,0
cm_reportby=varchar,0
cm_cmptype=varchar,0
cm_reportby2=varchar,0
cm_reportby3=varchar,0
cm_mobno2=varchar,0
cm_mobno3=varchar,0
cm_mobno4=varchar,0
cm_remarks=varchar,0
cm_version=varchar,0
cm_dbpath=varchar,0
cm_tempsrno=decimal,0
cm_intype=varchar,0
cm_estcompsolndate=datetime,0
cm_callbackno=varchar,0
cm_reportno=varchar,0
cm_cmpflag=varchar,0
cm_productiid=decimal,0
cm_RefId=decimal,0
[customers]
AM_AccId=decimal,0
AM_MacId=decimal,0
AM_RecId=decimal,0
AM_UserId=decimal,0
AM_AccCode=varchar,0
AM_AccName=varchar,0
AM_AccAlias=varchar,0
AM_AccType=varchar,0
AM_Flag=varchar,0
AM_GrpNo=decimal,0
AM_SubGrpNo=decimal,0
AM_Level=decimal,0
AM_Year=varchar,0
AM_Opening=decimal,2
AM_OpeningSign=char,0
AM_Closing=decimal,2
AM_ClosingSign=char,0
AM_Remarks=varchar,0
AM_OpeningFlag=char,0
AM_DeleteFlag=varchar,0
AM_Prefix=varchar,0
AM_Suffix=varchar,0
AM_Type=varchar,0
AM_UpOpening=varchar,0
AM_EntryDate=datetime,0
AM_ModifiedDate=datetime,0
AD_AccId=decimal,0
AD_UserId=decimal,0
AD_Brand=varchar,0
AD_CtPerson1=varchar,0
AD_CtPerson2=varchar,0
AD_Address1=varchar,0
AD_Address2=varchar,0
AD_Address3=varchar,0
AD_Area=varchar,0
AD_City=varchar,0
AD_Pin=varchar,0
AD_State=varchar,0
AD_Country=varchar,0
AD_Phone_O1=varchar,0
AD_Phone_O2=varchar,0
AD_Phone_R=varchar,0
AD_Fax=varchar,0
AD_BankACnum=varchar,0
AD_Mobile1=varchar,0
AD_Mobile2=varchar,0
AD_Email=varchar,0
AD_Website=varchar,0
AD_DLNo1=varchar,0
AD_DLNo2=varchar,0
AD_PrintingAddress=varchar,0
AD_CSTNo=varchar,0
AD_TinNo=varchar,0
AD_PANNo=varchar,0
AD_AadharNo=varchar,0
AD_LicenceNo=varchar,0
AD_Licencedate=datetime,0
AD_ECCNo=varchar,0
AD_ESICNo=varchar,0
AD_OANo=varchar,0
AD_RegistrationNo=varchar,0
AD_PFNo=varchar,0
AD_Division=varchar,0
AD_Range=varchar,0
AD_Comm=varchar,0
AD_ExtraNo1=varchar,0
AD_ExtraNo2=varchar,0
AD_AgentId1=decimal,0
AD_AgentId2=decimal,0
AD_HasteId=decimal,0
AD_PartyId=decimal,0
AD_MainParty=char,0
AD_ShowInAll=varchar,0
AD_Transport=varchar,0
AD_TransportId=decimal,0
AD_DBCPerc=varchar,0
AD_QtyDisc=varchar,0
AD_CreditDays=decimal,0
AD_CreditLimit=decimal,2
AD_Discount=decimal,2
AD_RDRate=decimal,2
AD_UsedInVat=char,0
AD_TaxTypeId=decimal,0
AD_InvTypeId=decimal,0
AD_TaxPer=decimal,2
AD_TaxForm=varchar,0
AD_TaxFormDesc=varchar,0
AD_VatType=varchar,0
AD_Tax1AccId=decimal,0
AD_TDSPer=decimal,3
AD_TDSFlag=char,0
AD_CtPerson3=varchar,0
AD_CtPerson4=varchar,0
AD_CtPerson5=varchar,0
AD_CtMob1=varchar,0
AD_CtMob2=varchar,0
AD_CtMob3=varchar,0
AD_CtMob4=varchar,0
AD_CtMob5=varchar,0
AD_CtChk1=char,0
AD_CtChk2=char,0
AD_CtChk3=char,0
AD_CtChk4=char,0
AD_CtChk5=char,0
AD_RateListId=decimal,0
AD_BankName=varchar,0
AD_BranchName=varchar,0
AD_IFCSCode=varchar,0
AD_CashCredit=varchar,0
AD_DeleteFlag=varchar,0
AD_Remarks=varchar,0
AD_CINNo=varchar,0
AD_DeliveryAt=varchar,0
AD_BlackCustFlag=varchar,0
AD_CommType=varchar,0
AD_CommRate=decimal,2
AD_TinPassword=varchar,0
AD_District=varchar,0
AD_CGSTNo=varchar,0
AD_IGSTNo=varchar,0
AD_SGSTNo=varchar,0
AD_GState=varchar,0
AD_GStateCode=varchar,0
AD_GSTType=varchar,0
AD_LicenceExpdate=datetime,0
AD_ReferenceName=varchar,0
AD_ReferenceNo=varchar,0
AD_ReputedPersonName=varchar,0
AD_ReputedPersonNo=varchar,0
AD_IsExportIGST=tinyint,0
AD_Chithiday=varchar,0
AD_FromTime=time,0
AD_ToTime=time,0
AD_PaymentDay=varchar,0
AD_PaymentFrom=time,0
AD_PaymentTo=time,0
[item_group]
IM_ItemId=decimal,0
IM_MacId=decimal,0
IM_RecId=decimal,0
IM_UserId=decimal,0
IM_Year=varchar,0
IM_ItemCode=varchar,0
IM_ItemName=varchar,0
IM_ItemAlias=varchar,0
IM_ItemDesc=varchar,0
IM_Flag=varchar,0
IM_GrpNo=decimal,0
IM_SubGrpNo=decimal,0
IM_Opening=decimal,2
IM_Closing=decimal,2
IM_ReOrderLevel=decimal,2
IM_UnitId=decimal,0
IM_Image=mediumblob,0
IM_PRate1=decimal,2
IM_PRate2=decimal,2
IM_PRate3=decimal,2
IM_PRate4=decimal,2
IM_SRate1=decimal,2
IM_SRate2=decimal,2
IM_SRate3=decimal,2
IM_SRate4=decimal,2
IM_HSNCode=varchar,0
IM_HSNId=decimal,0
IM_Tax1Perc=decimal,2
IM_Tax2Perc=decimal,2
IM_Tax3Perc=decimal,2
IM_Grp1=decimal,0
IM_Grp2=decimal,0
IM_Grp3=decimal,0
IM_Grp4=decimal,0
IM_Grp5=decimal,0
IM_packing=varchar,0
IM_CutAvg=varchar,0
IM_Remark1=varchar,0
IM_Remark2=varchar,0
IM_Remark3=varchar,0
IM_Extra1=varchar,0
IM_Extra2=varchar,0
IM_Extra3=varchar,0
IM_Extra4=varchar,0
IM_Extra5=varchar,0
IM_MfgDate=datetime,0
IM_ExpDate=datetime,0
IM_BrandId=decimal,0
IM_Prefix=varchar,0
IM_ItemNo=decimal,0
IM_ItemNumber=varchar,0
IM_Vat=decimal,2
IM_AddTax=decimal,2
IM_Composition=varchar,0
IM_DeliveryDate=datetime,0
IM_TFDisplay=varchar,0
IM_Status=varchar,0
IM_DeleteFlag=varchar,0
IM_EntryDate=datetime,0
IM_ModifiedDate=datetime,0
[process_hosiary]
PH_Id=decimal,0
PH_MacId=decimal,0
PH_RecId=decimal,0
PH_UserId=decimal,0
PH_Year=varchar,0
PH_JobNo1=decimal,0
PH_JobNo2=varchar,0
PH_JobDate=datetime,0
PH_ItemGrpId=decimal,0
PH_ItemId=decimal,0
PH_Style=varchar,0
PH_Color=varchar,0
PH_Weight=decimal,2
PH_CutQty1=decimal,2
PH_CutQty2=decimal,2
PH_CutDate=datetime,0
PH_CutAccId=decimal,0
PH_Stich1Qty1=decimal,2
PH_Stich1Qty2=decimal,2
PH_Stich1Date=datetime,0
PH_Stich1AccId=decimal,0
PH_Stich2Qty1=decimal,2
PH_Stich2Qty2=decimal,2
PH_Stich2Date=datetime,0
PH_Stich2AccId=decimal,0
PH_Stich3Qty1=decimal,2
PH_Stich3Qty2=decimal,2
PH_Stich3Date=datetime,0
PH_Stich3AccId=decimal,0
PH_PackQty1=decimal,2
PH_PackQty2=decimal,2
PH_PackDate=datetime,0
PH_PackAccId=decimal,0
PH_Remarks=varchar,0
PH_Extra1=varchar,0
PH_Extra2=varchar,0
PH_Extra3=varchar,0
PH_CutQty=decimal,2
PH_S1Qty=decimal,2
PH_S2Qty=decimal,2
PH_PackQty=decimal,2
PH_Prefix=varchar,0
PH_Flag=decimal,0
[quate_master]
IM_Id=decimal,0
IM_MacId=decimal,0
IM_RecId=decimal,0
IM_UserId=decimal,0
IM_Year=varchar,0
IM_Type=varchar,0
IM_TaxTypeId=decimal,0
IM_InvoiceTypeId=decimal,0
IM_Prefix=varchar,0
IM_Suffix=varchar,0
IM_InvNo=decimal,0
IM_InvoiceNo=varchar,0
IM_StrInvNo=varchar,0
IM_EntryDate=datetime,0
IM_ModifiedDate=datetime,0
IM_Date=datetime,0
IM_Time=datetime,0
IM_Category=varchar,0
IM_SubCategory=varchar,0
IM_OrderNo=varchar,0
IM_OrderDate=datetime,0
IM_ChallanNo=varchar,0
IM_ChallanDate=datetime,0
IM_LRNo=varchar,0
IM_LRDate=datetime,0
IM_CustRefNo=varchar,0
IM_CustRefDate=datetime,0
IM_AONo=varchar,0
IM_AODate=datetime,0
IM_OtherRef=varchar,0
IM_BaleNo=varchar,0
IM_NoOfBale=decimal,0
IM_CashCredit=varchar,0
IM_CPartyId=decimal,0
IM_CustId=decimal,0
IM_Cust2Id=decimal,0
IM_CustAdd=varchar,0
IM_SPartyId=decimal,0
IM_SuppId=decimal,0
IM_Supp2Id=decimal,0
IM_SuppAdd=varchar,0
IM_SalesAccId=decimal,0
IM_Tax1AccId=decimal,0
IM_Tax2AccId=decimal,0
IM_Tax3AccId=decimal,0
IM_SalesDrAccId=decimal,0
IM_AgentId=decimal,0
IM_SubAgentId=decimal,0
IM_HasteId=decimal,0
IM_TransportId=decimal,0
IM_SalesManId=decimal,0
IM_SubSalesManId=decimal,0
IM_Transport=varchar,0
IM_From=varchar,0
IM_To=varchar,0
IM_DeliveryAt=varchar,0
IM_Freight=varchar,0
IM_Weight=varchar,0
IM_Courier=varchar,0
IM_Insurance=varchar,0
IM_RNo=varchar,0
IM_Remarks1=varchar,0
IM_Remarks2=varchar,0
IM_Remarks3=varchar,0
IM_Note1=varchar,0
IM_Note2=varchar,0
IM_Note3=varchar,0
IM_TotalAmt01=decimal,2
IM_Charges01AccId=decimal,0
IM_Charges01Desc=varchar,0
IM_Charges01Perc=varchar,0
IM_Charges01Amt=decimal,2
IM_Charges02AccId=decimal,0
IM_Charges02Desc=varchar,0
IM_Charges02Perc=varchar,0
IM_Charges02Amt=decimal,2
IM_Charges03AccId=decimal,0
IM_Charges03Desc=varchar,0
IM_Charges03Perc=varchar,0
IM_Charges03Amt=decimal,2
IM_Charges04AccId=decimal,0
IM_Charges04Desc=varchar,0
IM_Charges04Perc=varchar,0
IM_Charges04Amt=decimal,2
IM_Charges05AccId=decimal,0
IM_Charges05Desc=varchar,0
IM_Charges05Perc=varchar,0
IM_Charges05Amt=decimal,2
IM_TotalAmt02=decimal,2
IM_Tax01AccId=decimal,0
IM_Tax01Desc=varchar,0
IM_Tax01Perc=varchar,0
IM_Tax01Amt=decimal,2
IM_Tax02AccId=decimal,0
IM_Tax02Desc=varchar,0
IM_Tax02Perc=varchar,0
IM_Tax02Amt=decimal,2
IM_Tax03AccId=decimal,0
IM_Tax03Desc=varchar,0
IM_Tax03Perc=varchar,0
IM_Tax03Amt=decimal,2
IM_Tax04AccId=decimal,0
IM_Tax04Desc=varchar,0
IM_Tax04Perc=varchar,0
IM_Tax04Amt=decimal,2
IM_Tax05AccId=decimal,0
IM_Tax05Desc=varchar,0
IM_Tax05Perc=varchar,0
IM_Tax05Amt=decimal,2
IM_TotalAmt03=decimal,2
IM_Charges06AccId=decimal,0
IM_Charges06Desc=varchar,0
IM_Charges06Perc=varchar,0
IM_Charges06Amt=decimal,2
IM_Charges07AccId=decimal,0
IM_Charges07Desc=varchar,0
IM_Charges07Perc=varchar,0
IM_Charges07Amt=decimal,2
IM_Charges08AccId=decimal,0
IM_Charges08Desc=varchar,0
IM_Charges08Perc=varchar,0
IM_Charges08Amt=decimal,2
IM_Charges09AccId=decimal,0
IM_Charges09Desc=varchar,0
IM_Charges09Perc=varchar,0
IM_Charges09Amt=decimal,2
IM_Charges10AccId=decimal,0
IM_Charges10Desc=varchar,0
IM_Charges10Perc=varchar,0
IM_Charges10Amt=decimal,2
IM_TotalAmt04=decimal,2
IM_Tax06AccId=decimal,0
IM_Tax06Desc=varchar,0
IM_Tax06Perc=varchar,0
IM_Tax06Amt=decimal,2
IM_Tax07AccId=decimal,0
IM_Tax07Desc=varchar,0
IM_Tax07Perc=varchar,0
IM_Tax07Amt=decimal,2
IM_Tax08AccId=decimal,0
IM_Tax08Desc=varchar,0
IM_Tax08Perc=varchar,0
IM_Tax08Amt=decimal,2
IM_Tax09AccId=decimal,0
IM_Tax09Desc=varchar,0
IM_Tax09Perc=varchar,0
IM_Tax09Amt=decimal,2
IM_Tax10AccId=decimal,0
IM_Tax10Desc=varchar,0
IM_Tax10Perc=varchar,0
IM_Tax10Amt=decimal,2
IM_TotalAmt05=decimal,2
IM_Charges11AccId=decimal,0
IM_Charges11Desc=varchar,0
IM_Charges11Perc=varchar,0
IM_Charges11Amt=decimal,2
IM_Charges12AccId=decimal,0
IM_Charges12Desc=varchar,0
IM_Charges12Perc=varchar,0
IM_Charges12Amt=decimal,2
IM_Charges13AccId=decimal,0
IM_Charges13Desc=varchar,0
IM_Charges13Perc=varchar,0
IM_Charges13Amt=decimal,2
IM_Charges14AccId=decimal,0
IM_Charges14Desc=varchar,0
IM_Charges14Perc=varchar,0
IM_Charges14Amt=decimal,2
IM_Charges15AccId=decimal,0
IM_Charges15Desc=varchar,0
IM_Charges15Perc=varchar,0
IM_Charges15Amt=decimal,2
IM_TotalAmt06=decimal,2
IM_RndOffAccId=decimal,0
IM_RndOff=decimal,2
IM_AddAmt=decimal,2
IM_LessAmt=decimal,2
IM_BillAmt=decimal,2
IM_RefAmt=decimal,2
IM_AmtInWords=varchar,0
IM_GSTNo=varchar,0
IM_GTotalAmt01=decimal,2
IM_GDiscAmt=decimal,2
IM_GDiscAmt1=decimal,2
IM_GTaxable=decimal,2
IM_GCGST=decimal,2
IM_GSGST=decimal,2
IM_GIGST=decimal,2
IM_GST=decimal,2
IM_CessAmt=decimal,2
IM_GNetAmt=decimal,2
IM_Pcs=decimal,2
IM_Mtrs=decimal,2
IM_GSTApproved=varchar,0
IM_AddInStock=varchar,0
IM_VoucherId=decimal,0
IM_PymtDays=decimal,0
IM_PaymentRemarks=varchar,0
IM_ChallanIds=varchar,0
IM_OrderId=decimal,0
IM_Previous=varchar,0
IM_Next=varchar,0
IM_Paid=varchar,0
IM_Cleared=char,0
IM_ManualCLeared=char,0
IM_PackedBy=varchar,0
IM_PackingCharges=decimal,2
IM_PackingPaidFlag=varchar,0
IM_DeliverdBy=varchar,0
IM_DeliveryCharges=decimal,2
IM_DeliveryPaidFlag=varchar,0
IM_NetPymtDays=decimal,0
IM_DiscPer=decimal,2
IM_DeliverDate=datetime,0
IM_RateListId=decimal,0
IM_Chrg1Amt=decimal,2
IM_Chrg2Amt=decimal,2
IM_Chrg3Amt=decimal,2
IM_Chrg4Amt=decimal,2
IM_Chrg5Amt=decimal,2
IM_Chrg6Amt=decimal,2
IM_Chrg7Amt=decimal,2
IM_Chrg8Amt=decimal,2
IM_Chrg9Amt=decimal,2
IM_Chrg10Amt=decimal,2
IM_Chrg11Amt=decimal,2
IM_Chrg12Amt=decimal,2
IM_RcvdDate=datetime,0
IM_NetAmt=decimal,2
IM_GRAmt=decimal,2
IM_CommAmt=decimal,2
IM_VchNo=varchar,0
IM_GrNo=varchar,0
IM_GRDate=datetime,0
IM_CommPer=decimal,2
IM_AgentCommPer=decimal,2
IM_ASCommPer=decimal,2
IM_CommDue=decimal,2
IM_CommRcvd=decimal,2
IM_CommFlag=char,0
IM_SComm=decimal,2
IM_SSComm=decimal,2
IM_SCommType=varchar,0
IM_VId=decimal,0
IM_RefId=decimal,0
IM_RcvdChallan=varchar,0
IM_RMClear=varchar,0
IM_RClear=varchar,0
IM_CommId=decimal,0
IM_RcvdForm=varchar,0
IM_FormNo=varchar,0
IM_FormDate=datetime,0
IM_ReverseCharge=varchar,0
IM_RndFlag=varchar,0
IM_TDSRndFlag=varchar,0
IM_IsExportIGST=tinyint,0
IM_Distance=decimal,2
IM_VehicleNo=varchar,0
IM_VehicleType=varchar,0
IM_TransMode=varchar,0
IM_StockFlag=varchar,0
IM_StockReferenceFlag=varchar,0
IM_VoucherFlag=varchar,0
IM_ReferenceFlag=varchar,0
IM_CtPerson1=varchar,0
IM_RateTypeFlag=varchar,0
IM_EwayBillNo=varchar,0
IM_EwayBillDate=datetime,0
IM_EwayBillRemarks=varchar,0
IM_EwayFlag=varchar,0
IM_EwayCtr=decimal,0
IM_EwayStatus=varchar,0
IM_EwayTransactionType=varchar,0
IM_TCSRndFlag=varchar,0
[quate_transaction]
IT_Id=decimal,0
IT_SrNo=decimal,0
IT_SerialNo=decimal,0
IT_ItemId=decimal,0
IT_ItemId1=decimal,0
IT_Cut=decimal,2
IT_Packing=decimal,2
IT_Pcs=decimal,2
IT_Mtrs=decimal,2
IT_RateType=varchar,0
IT_StockQty=decimal,2
IT_InvQty=decimal,2
IT_Rate=decimal,2
IT_SubTotal=decimal,2
IT_Desc1=varchar,0
IT_Desc2=varchar,0
IT_Desc3=varchar,0
IT_Desc4=varchar,0
IT_Remark1=varchar,0
IT_Remark2=varchar,0
IT_Remark3=varchar,0
IT_Remark4=varchar,0
IT_Extra1=varchar,0
IT_Extra2=varchar,0
IT_Extra3=varchar,0
IT_Extra4=varchar,0
IT_StockRemarks=varchar,0
IT_ChallanId=decimal,0
IT_OrderId=decimal,0
IT_RefId=decimal,0
IT_RefType=varchar,0
IT_CLeared=char,0
IT_ManualCLeared=char,0
IT_DisPer=decimal,2
IT_DisPer1=decimal,2
IT_VatPer=decimal,2
IT_AddTaxPer=decimal,2
IT_DisAmt=decimal,2
IT_DisAmt1=decimal,2
IT_RGPer=decimal,2
IT_RGAmt=decimal,2
IT_RDPer=decimal,2
IT_RDAmt=decimal,2
IT_VatAmt=decimal,2
IT_AddtaxAmt=decimal,2
IT_ToatalRare1=decimal,2
IT_ToatalRare2=decimal,2
IT_ToatalRare3=decimal,2
IT_MRP=decimal,2
IT_PTS=decimal,2
IT_PTR=decimal,2
IT_FreeQty=decimal,2
IT_CustRefNo=varchar,0
IT_CustRefDate=datetime,0
IT_ExpDate=datetime,0
IT_MfgDate=datetime,0
IT_Flag=decimal,0
IT_XS=decimal,2
IT_S=decimal,2
IT_M=decimal,2
IT_L=decimal,2
IT_XL=decimal,2
IT_2XL=decimal,2
IT_3XL=decimal,2
IT_4XL=decimal,2
IT_5XL=decimal,2
IT_6XL=decimal,2
IT_7XL=decimal,2
IT_8XL=decimal,2
IT_9XL=decimal,2
IT_10XL=decimal,2
IT_FREESIZE=decimal,2
IT_Color=varchar,0
IT_ColorIds=varchar,0
IT_Size=varchar,0
IT_Godown=varchar,0
IT_CGSTPer=decimal,2
IT_CGSTAmt=decimal,2
IT_SGSTPer=decimal,2
IT_SGSTAmt=decimal,2
IT_IGSTPer=decimal,2
IT_IGSTAmt=decimal,2
IT_GSTPer=decimal,2
IT_TotalGST=decimal,2
IT_CessPer=decimal,2
IT_CessAmt=decimal,2
IT_Total1=decimal,2
IT_TaxablAmt=decimal,2
IT_HSNId=decimal,0
IT_UnitId=decimal,0
IT_IsExportIGST=tinyint,0
IT_StockFlag=varchar,0
[rate_list_new]
R_Id=decimal,0
R_MacId=decimal,0
R_RecId=decimal,0
R_UserId=decimal,0
R_CustId=decimal,0
R_ItemId=decimal,0
R_Rate=decimal,2
R_Extra1=varchar,0
R_Extra2=varchar,0
R_Extra3=varchar,0
[comp_category]
c_id=decimal,0
c_macid=decimal,0
c_recid=decimal,0
c_categoryname=varchar,0
c_prefix=varchar,0
c_type=char,0
c_remarks=varchar,0
[comp_type]
ct_id=decimal,0
ct_macid=decimal,0
ct_recid=decimal,0
ct_comptype=varchar,0
ct_categoryid=decimal,0
ct_type=char,0
ct_remarks=varchar,0
ct_subtype=varchar,0
[priority_master]
p_id=decimal,0
p_name=varchar,0
p_remarks=varchar,0
[solution_master]
sl_id=decimal,0
sl_srno=decimal,0
sl_type=varchar,0
sl_userid=decimal,0
sl_enggid=decimal,0
sl_engg2id=decimal,0
sl_entrydate=datetime,0
sl_allocateddate=datetime,0
sl_reportno=varchar,0
sl_enggreport=varchar,0
sl_enggremarks=varchar,0
sl_taskstatus=varchar,0
sl_masterstatus=varchar,0
sl_priority=varchar,0
sl_version=varchar,0
sl_updateversion=varchar,0
sl_estcompsolndate=datetime,0
[status_master]
s_id=decimal,0
s_name=varchar,0
s_type=char,0
s_remarks=varchar,0
s_orderno=decimal,0
[z_wa_msgs]
w_id=int,0
w_date=datetime,0
w_type=varchar,0
w_instanceid=varchar,0
w_token=varchar,0
w_number=varchar,0
w_msg=varchar,0
w_media=varchar,0
w_mediaurl=varchar,0
w_flag=varchar,0
w_senttime=datetime,0
w_status=varchar,0
w_remarks=varchar,0
