Schema KB

238 tables documented.

Browse the schema knowledge base used by this twin and the WhatsApp bot. Each table has a summary, full column dictionary, join map, and sample queries.

/
Backup_Taken_Log BaseSettings ChallanBinTrayDTL CompanyConfig CompanyConfigMenu CustGroupMas Debitdtl Debithdr Deletion_Log DesignationMas DownTime100DTL DownTime100HDR Form_Active_Status ItemCategory Item_ParentToChild MachineOperation PackingSlipdtl PhyLocation RGPduty RMOpr RMParaIRGroup RM_SF_Purchase_Bill RMproduct1 ReasonMappedWithOperation Statemas UoMMaster UserrightsHdr Vehiclemas ViewInvdtlTaxPer appdutymas assemblyproddtl bcdata bcdataHH billagainstwo brandmas cappdutymas catmas cdutymas cgroupmas chapter citemiss citemmas citemusedinpitem citisdtl cjobpodtl cjobpodtlamnd cjobpoduty cjobpohdr cjobpohdramnd cmrpreqitem cmrrduty cmrrhdr cpodtl cpodtlamnd cpoduty cpohdr cpohdramnd cpotempdtlamnd cpotext cpotextamnd csrnduty csubgroupmas currencyrate custrejduty custtax desp1stjob desp1stjobdtl desp2job desp2jobdtl despadvicedtl despadvicehdr downtimedtl downtimemas dprt_mas dutymas empcode exppotax fghdr financialyear form5 goodreceipt grademas groupitem groupmas icsfreqperiod incomconitem incondtl invdespdtl invdesptax invdtl invhdr invlotdetail invtax invtype itemcustrate itemledger itemmas itemoprprod itemparamas itemreturn itemrmchwt itemstagewise itemsup itemvendopr job job2dtl jobdtl jobhdr joboadtl joboahdr jobpodtl jobpodtlamnd jobpohdr jobpohdramnd lablenumbers location machine machineitem mactypemas manuf_method mcdtl mchdr monthwisesale mrci2dtl mrci_rep mrcirdtl mrcirhdr mrprejdtl nonmovingitemCstore nonretitm nonretitmdtl oaTenTativeMdtl oaTenTativeMhdr oadtl oahdr onlinerej_dtl onlinerej_hdr operatormas oprmas oprstationmas packingmaster parameteragnstitem pass1 paydprt_mas pdiinspectiondtl pmcdtl2 pmchdr2 podtl podtlamnd poduty pohdr pohdramnd potax potaxamnd potype prodfdowndtl prodfoprdtl prodscrap product2 productgrade rejaccept_dtl rejaccept_hdr rejectionmas retsrnduty rgpdtl rgphdr rmdia rmincoming rmincomingcoil rmindent rmindentitem rmjobhdr rmjobrec1st rmjobrec1stdtl rmjobrec2nd rmjobrec2nddtl rmmas rmmrpdtl rmmrphdr rmpotab rmpotabamnd rmpotabitem rmpotabitemamnd rmreturn rmreturncust rmreturnendpcs rmreturnendpcsinhouse rmstockbeforedrawcon rmtype rmvendopr saleappdutymas saledutymas saleitemmas scheduledtl scheduledtlamnd schedulehdr schedulehdramnd semidtl sfindent sfindentitem sfpo sfpoamnd sfpoitem sfpoitemamnd sftmas srnduty srntemp suptax surfacefinish tempFGlotqty tempcust tempitempipeline tempjobcenvat templotqty temprmreqgen temprmstockvssale tempsalecustwise tempsalegroupwise tempsaleitemwise tempsalereportqty tempsuplinvdetail temptotaloutvsinfromvendor tmpmrpdtl tmpmrphdr transptmas userrights userrightsmain vendbillcomproforma vendmasitem vendorrating vendtax viewInvHDRDTL viewsobalance vitemopr vmachine wipjobstock wipstock woselect4bill