# GB5 Schema Registry Source: INSERT INTO patterns in *QB.cs files | Generated: 2026-06-09 11:02 Re-run: `bash tools/extract-schema.sh` --- ## ASSIGNMENTRULES **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/GOP/DecisionFlowQB.cs` **Columns (from INSERT INTO):** --- ## CANONICALFIELDS **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/GOP/CanonicalModelQB.cs` **Columns (from INSERT INTO):** --- ## CANONICALMODELS **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/GOP/CanonicalModelQB.cs` **Columns (from INSERT INTO):** --- ## COLLAB **Module:** CollabDAL | **Source:** `GB5Solution/CollabSpace/CollabDAL/Query/CollabSession/CollabSessionQB.cs` **Columns (from INSERT INTO):** --- ## DBO **Module:** WiDAL | **Source:** `GB5Solution/WorkInstruction/WiDAL/Query/Wi/WorkstationQB.cs` **Columns (from INSERT INTO):** - `LOADTEMPLATEID` - `OBJECTTYPEID` - `OUID` - `TEMPLATENAME` - `OBJECTID` - `SORTORDER` - `SOURCETYPE` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `TENANTID` - `ENTITYID` - `BIZTRANSACTIONTYPEID` - `WORKFLOWID` - `DATAJSON` - `FACTSJSON` - `CURRENTSTEPID` - `CURRENTAPPROVALLEVEL` - `WORKFLOWSTATUS` - `WORKFLOWINSTANCEID` - `STEPID` - `ASSIGNEDTOUSERID` - `ASSIGNEDROLEID` - `ASSIGNEDUSERGROUPID` - `DUEON` - `COMMENT` - `STEPKEY` - `APPROVALLEVEL` - `ACTION` - `ACTIONBYUSERID` - `LASTACTION` - `APIENDPOINT` - `DECLARATIONDETAILID` - `DECLARATIONID` - `SLNO` - `DECLARATIONTYPE` - `TYPESLNO` - `PARTICULARS` - `PRINCIPLE` - `INTEREST` - `TDSCONTACTID` - `DETAILREMARKS` - `DETAILSTATUS` - `FEEDBACK` - `APPROVEDAMOUNT` - `FROMPERIOD` - `TOPERIOD` - `RENTRECEIVED` - `LOCALTAX` - `STANDARDDEDUCTION` - `NETINCOME` - `TDSSECTIONDETAILID` - `ISMETRO` - `DECLAREDAMOUNT` - `APPROVERID` - `APPROVEDON` - `ASSESSMENTID` - `PROGRAMMEID` - `PROGRAMMESESSIONID` - `SESSIONTOPICID` - `ASSESSMENTTITLE` - `ASSESSMENTTYPE` - `ASSESSMENTMODE` - `ISPREASSESSMENT` - `ISPOSTASSESSMENT` - `PASSTHRESHOLDPCT` - `MAXATTEMPTS` - `DURATIONMINS` - `TOTALMARKS` - `ISLMSDELIVERED` - `LMSASSESSMENTID` - `RANDOMISEQUESTIONS` - `SHOWANSWERSONCOMPLETE` - `ISACTIVE` - `ASSESSMENTQUESTIONID` - `QUESTIONTEXT` - `QUESTIONTYPE` - `OPTIONSJSON` - `CORRECTANSWER` - `MARKS` - `EXPLANATION` - `ATTEMPTID` - `ENROLLMENTID` - `EMPLOYEEID` - `ATTEMPTNO` - `STARTEDON` - `SUBMITTEDON` - `SCOREPCT` - `ATTEMPTISPASSED` - `RESPONSEID` - `QUESTIONID` - `SELECTEDANSWER` - `ISCORRECT` - `ASSESSMENTATTEMPTID` - `COMPLETEDON` - `MARKSOBTAINED` - `EVALUATEDBYID` - `ISLMSSYNCED` - `REMARKS` - `TRAININGCERTIFICATEID` - `TRAININGCOMPLETIONID` - `CERTIFICATENUMBER` - `CERTIFICATETITLE` - `ISSUEDON` - `ISSUEDBYID` - `EXPIRYDATE` - `RENEWALWINDOWDAYS` - `CERTIFICATEURL` - `EXTERNALCERTREF` - `CERTSTATUS` - `ALERTID` - `ALERTTYPE` - `ALERTCHANNEL` - `ALERTSTATUS` - `ALERTSENTON` - `DAYSBEFOREEXPIRY` - `EVALUATIONPLANID` - `PLANTITLE` - `KIRKPATRICK` - `RESPONDENTTYPE` - `EVALTRIGGER` - `EVALWINDOWDAYS` - `REMINDERDAYS` - `ISMULTIPROGRAMME` - `EVALINSTANCEID` - `EVALPLANID` - `INSTANCEID` - `EVALSTATUS` - `DUEDATE` - `EVALRESPONSEID` - `RESPONSETEXT` - `RATINGSCORE` - `VENDORID` - `VENDORCODE` - `VENDORNAME` - `VENDORTYPE` - `CONTACTNAME` - `CONTACTEMAIL` - `CONTACTPHONE` - `VENDORADDRESS` - `SPECIALISATIONS` - `ACCREDITEDBY` - `CONTRACTEXPIRYDATE` - `STARTDATE` - `ENDDATE` - `CONTACTID` - `PROGRAMMECODE` - `PROGRAMMETITLE` - `SHORTDESCRIPTION` - `FULLDESCRIPTION` - `TRAININGDOMAINID` - `PROGRAMMETYPE` - `DELIVERYMODE` - `COMPLEXITYLEVEL` - `DIFFICULTYLEVEL` - `PROVIDERTYPE` - `DURATIONHOURS` - `ISREFRESHER` - `HASASSESSMENT` - `HASPREASSESSMENT` - `CERTONCOMPLETE` - `CERTVALIDITYDAYS` - `MINCAPACITY` - `MAXCAPACITY` - `COSTPERPARTICIPANT` - `LEARNINGOBJECTIVES` - `TARGETAUDIENCE` - `PREREQUISITES` - `PROGRAMMEVERSIONNO` - `TRAINERID` - `TRAINERCODE` - `TRAINERNAME` - `TRAINERFULLNAME` - `TRAINERTYPE` - `EXTERNALVENDORID` - `QUALIFIEDPROGRAMMEIDS` - `MAXSESSIONSPERMONTH` - `EMAIL` - `PHONE` - `TRAININGATTENDANCEID` - `INSTANCESESSIONID` - `ATTENDANCESTATUS` - `ATTENDANCEPCT` - `CHECKINTIME` - `CHECKOUTTIME` - `ABSENCEREASON` - `RECORDEDBYID` - `RECORDEDON` - `COMPLETIONSTATUS` - `OVERALLATTENDANCEPCT` - `PREASSESSMENTSCORE` - `POSTASSESSMENTSCORE` - `SCOREIMPROVEMENT` - `ISPASSED` - `CERTIFICATEISSUED` - `EVALUATIONTRIGGERED` - `TRAINERREMARKS` - `HRREMARKS` - `DOMAINCODE` - `DOMAINNAME` - `DOMAINDESCRIPTION` - `NOMINATIONSOURCE` - `NOMINATEDBYID` - `NOMINATEDON` - `ENROLLMENTSTATUS` - `WAITLISTPOSITION` - `INSTANCETITLE` - `INSTANCECODE` - `TRAININGNEEDID` - `PRIMARYTRAINERID` - `VENUEID` - `INSTANCESTATUS` - `PLANNEDSTARTDATE` - `PLANNEDENDDATE` - `ACTUALSTARTDATE` - `ACTUALENDDATE` - `ENROLLEDCOUNT` - `BATCHNOTE` - `SCHEDULEDDATE` - `STARTTIME` - `ENDTIME` - `ACTUALDURATIONMINS` - `SESSIONDELIVMODE` - `SESSIONSTATUS` - `DOJOSESSIONID` - `OJTPLANID` - `ATTENDANCERECORDED` - `TRAINERNOTES` - `INSTANCEDELIVERYCFGID` - `INSTANCEDELIVMODE` - `LMSCOURSEID` - `EXTERNALCOURSEREF` - `DOJOSTATIONIDS` - `OJTBUDDYID` - `OJTSUPERVISORID` - `BLENDEDSPLIT` - `SPECIALEQUIPMENT` - `NEEDCODE` - `NEEDTITLE` - `DESCRIPTION` - `NEEDSOURCETYPE` - `SOURCEREFENTITY` - `SOURCEREFID` - `PRIORITY` - `AUDIENCETYPE` - `AUDIENCEFILTER` - `TARGETHEADCOUNT` - `ISMANDATORY` - `COMPLIANCEDEADLINE` - `NEEDSTATUS` - `RAISEDBYID` - `RAISEDON` - `DEPARTMENTID` - `TARGETPOPULATION` - `PASSMARK` - `SESSIONCODE` - `SESSIONTITLE` - `SESSIONTYPE` - `ISOPTIONAL` - `ISMANDATORYFORCERT` - `ISASSESSMENTREQUIRED` - `MINATTENDANCEPCT` - `DELIVERYNOTE` - `DOJOSTATIONREF` - `TOPICCODE` - `TOPICTITLE` - `TOPICTYPE` - `CONTENTSUMMARY` - `LMSCONTENTID` - `PROGRAMMEPREREQID` - `PREREQPROGRAMMEID` - `PREREQSKILLID` - `PREREQMINLEVELNO` - `ISHARD` - `PROGRAMMESKILLMAPID` - `SKILLID` - `PRODUCTFAMILYID` - `MODELID` - `QUALIFIESFORLEVELNO` - `ISAUTOPROPOSE` - `REQUIRESPASSEDASSESS` - `PROGCOMPETENCYMAPID` - `COMPETENCYID` - `CONTRIBUTESTOLEVELNO` - `CREDITWEIGHT` - `ISDIRECTEVIDENCE` - `TRAININGVENUEID` - `VENUECODE` - `VENUENAME` - `VENUETYPE` - `CAPACITY` - `VENUELOCATION` - `CONTACTPERSON` - `ISAIRCONDITIONING` - `ISPANTRY` - `ISSCREENSHARING` - `ISRECORDING` - `HASPROJECTOR` - `HASWHITEBOARD` - `VIRTUALLINK` - `PRODUCTIONLINEID` - `ROUTINGDETAILID` - `WORKSTATIONID` - `EFFECTIVEFROM` - `EFFECTIVETO` - `MANPOWERCOUNT` - `LINESHIFTROSTEID` - `SHIFTID` - `ROSTERDATE` - `ROSTERTYPE` - `ROSTERSTATUS` - `INCHARGEEMPLOYEEID` - `PLANNEDROSTERID` - `STAFFINGROLE` - `ISPRIMARY` - `PLANNEDSTARTTIME` - `PLANNEDENDTIME` - `ISABSENT` - `REPLACEDBYEMPLOYEEID` - `POSITIONNO` - `WIEXECUTIONID` - `WIID` - `WIACTIVITYSCHEDULEID` - `WORKORDERID` - `ACTIVITYTYPE` - `TRIGGEREVENT` - `SERIALNO` - `LOTNO` - `EXECSTATUS` - `ADVANCEMODEUSED` - `STDCYCLESECS` - `WISTEPEXECUTIONID` - `WISTEPID` - `STEPSTATUS` - `STDDURATIONSECS` - `ADVANCETRIGGER` - `WORKCENTERID` - `WORKSTATIONCODE` - `WORKSTATIONNAME` - `WORKSTATIONTYPE` - `BAYCODE` - `FLOORDESCRIPTION` - `IPADDRESS` - `MACADDRESS` - `MAXOPERATORS` --- ## DBOBJECT **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/DBObject/DBObjectQB.cs` **Columns (from INSERT INTO):** - `DBOBJECTID` - `DBOBJECTNAME` - `MODULEID` - `SECTION` - `DBOBJECTTYPE` - `REMARKS` - `SORTORDER` - `STATUS` - `VERSION` - `SOURCETYPE` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `ISSTANDARDDATAREQUIRED` - `DATASOURCETYPEID` - `DISPLAYNAME` - `OBJECTNATURE` - `TABLETYPE` - `ISANALYSIS` - `BASEOBJECTID` - `CONDITION` - `ISSYSTEM` - `ISDEVELOPER` - `ISIMPLEMENTATION` - `ISADMIN` - `ISUSER` - `EXPRESSION` - `VARIABLES` - `QUERYTYPE` - `ISARCHIVE` - `REPLAYUNIT` - `REPLAYAMOUNT` - `PARENTOBJECTID` - `GROUPDBOBJECTID` - `DATEKEY` - `DELETEQUERY` - `ISIDENTITYOBJECT` - `DELETEQUERYPOSTGRE` --- ## DEADLETTERS **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/GOP/ExecutionQB.cs` **Columns (from INSERT INTO):** --- ## DECISIONFLOWDEFINITIONS **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/GOP/DecisionFlowQB.cs` **Columns (from INSERT INTO):** --- ## DECISIONFLOWVERSIONS **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/GOP/DecisionFlowQB.cs` **Columns (from INSERT INTO):** --- ## DECISIONSTEPS **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/GOP/DecisionFlowQB.cs` **Columns (from INSERT INTO):** --- ## DECISIONTRANSITIONS **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/GOP/DecisionFlowQB.cs` **Columns (from INSERT INTO):** --- ## EXECUTIONATTEMPTS **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/GOP/ExecutionQB.cs` **Columns (from INSERT INTO):** --- ## EXECUTIONCONTEXTS **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/GOP/ExecutionQB.cs` **Columns (from INSERT INTO):** --- ## EXECUTIONFAILURES **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/GOP/ExecutionQB.cs` **Columns (from INSERT INTO):** --- ## GOPAUDITLOGS **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/GOP/AuditQB.cs` **Columns (from INSERT INTO):** --- ## GRADESPECIFICATIONVALUE **Module:** MMDAL | **Source:** `GB5Solution/MM/MMDAL/Query/GradeSpecificationValue/GradeSpecificationValueQB.cs` **Columns (from INSERT INTO):** - `GRADESTANDARDCATEGORYID` - `PARAMETERSETDETAILID` - `MINVALUE` - `MAXVALUE` - `NOMINALVALUE` - `TOLERANCE` - `TEXTVALUE` - `REMARKS` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `SORTORDER` - `STATUS` - `VERSION` --- ## LENGAGEMENTSIGNAL **Module:** IDMSDAL | **Source:** `GB5Solution/IDMS/IDMSDAL/QueryBuilders/SignalQB.cs` **Columns (from INSERT INTO):** - `ENGAGEMENTID` - `TENANTID` - `SIGNALTYPE` - `SIGNALWEIGHT` - `ISACTIVE` - `DETECTEDON` - `CREATEDBYID` - `CREATEDON` --- ## LGBQUERYEXECUTIONLOG **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/GBQueryExecutor/GBQueryExecutorQB.cs` **Columns (from INSERT INTO):** - `CONFIGUREDQUERYID` - `QUERYCODE` - `QUERYINTENT` - `CALLERMODULE` - `DURATIONMS` - `ROWSRETURNED` - `ISSUCCESS` - `ERRORMESSAGE` - `PARAMETERSJSON` - `CREATEDBYID` - `CREATEDON` - `TENANTID` --- ## LKMGOVERNANCE **Module:** KmsDAL | **Source:** `GB5Solution/KMS/KmsDAL/Query/KmGovernance/KmGovernanceQB.cs` **Columns (from INSERT INTO):** - `ARTIFACTID` - `FROMSTATE` - `TOSTATE` - `TRANSITIONEDBYID` - `TRANSITIONEDON` - `NOTES` - `REJECTIONREASON` - `CREATEDBYID` - `CREATEDON` --- ## LPROCESSEDACTION **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/ActionProcessor/ProcessedActionQB.cs` **Columns (from INSERT INTO):** - `ACTIONRUNID` - `CREATEDBYID` - `CREATEDON` --- ## LREWORKREGISTER **Module:** IDMSDAL | **Source:** `GB5Solution/IDMS/IDMSDAL/QueryBuilders/ReworkQB.cs` **Columns (from INSERT INTO):** - `ENGAGEMENTID` - `TENANTID` - `DELIVERYITEMID` - `DOMAINCODE` - `REASONCODE` - `REASONDETAIL` - `REWORKHOURS` - `FLAGGEDFORPIE` - `CREATEDBYID` - `CREATEDON` --- ## LSHOWREQUEST **Module:** EnablementDAL | **Source:** `GB5Solution/Enablement/EnablementDAL/Query/Show/ShowRequestLogQB.cs` **Columns (from INSERT INTO):** - `REQUESTID` - `USERID` - `TENANTID` - `TRIGGERTYPE` - `TRIGGERSOURCE` - `CONTEXTSNAPSHOT` - `MATCHEDCOUNT` - `RESOLVEDMS` - `ISFRONTENDRESOLVED` - `CREATEDBYID` - `CREATEDON` --- ## LSIGNOFFREGISTER **Module:** IDMSDAL | **Source:** `GB5Solution/IDMS/IDMSDAL/QueryBuilders/SignOffQB.cs` **Columns (from INSERT INTO):** - `ENGAGEMENTID` - `TENANTID` - `DOMAINCODE` - `SIGNOFFTYPE` - `SIGNOFFNAME` - `SIGNEDITEMS` - `CONTENTSNAPSHOT` - `CONTENTHASH` - `SIGNEDBYID` - `SIGNEDBYNAME` - `SIGNEDON` - `ISDIGITALLYSIGNED` - `PORTALSIGNATUREID` - `DELIVERYMANAGERID` - `CREATEDBYID` - `CREATEDON` --- ## LTCMSCOVERAGESNAPSHOT **Module:** TCMSDAL | **Source:** `GB5Solution/TCMS/TCMSDAL/QueryBuilders/TCMSCoverageQB.cs` **Columns (from INSERT INTO):** - `MODULEID` - `TESTRUNID` - `COVERAGEPCT` - `TOTALCASES` - `PASSEDCASES` - `SNAPSHOTDATE` - `TENANTID` --- ## MACCOUNT **Module:** AccountsDAL | **Source:** `GB5Solution/Accounts/AccountsDAL/Query/Account/AccountQB.cs` **Columns (from INSERT INTO):** - `ACCOUNTID` - `ACCOUNTCODE` - `ACCOUNTNAME` - `ACCOUNTSHORTNAME` - `ACCOUNTTYPE` - `ACCOUNTGROUPID` - `CONTROLACCOUNTID` - `CURRENCYID` - `COMBINEACCOUNTID` - `ACCOUNTBANKBRANCHID` - `TDSCATEGORYID` - `INTERESTRATE` - `FAVOURINGNAME` - `BILLALLOCATIONTYPE` - `LEDGERPRINTTYPE` - `SUMMARYPERIOD` - `ISCOMPANY` - `ISINTERCOMPANY` - `ISTDSAPPLICABLE` - `TDSSTATE` - `ISSUBACCOUNTREQUIRED` - `BANKACCOUNTNUMBER` - `BANKACCOUNTTYPE` - `SAFETYLIMIT` - `MINIMUMBALANCE` - `OURCODEWITHPARTY` - `ISCREDITALLOWED` - `CREDITLIMIT` - `ISDEBITALLOWED` - `DEBITLIMIT` - `ISBLOCKED` - `SORTORDER` - `STATUS` - `VERSION` - `SOURCETYPE` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `ACCOUNTSCHEDULENATURE` - `TDSSECTION` - `APPLICABLECOSTCENTERIDS` - `CODEDEFINEID` - `DEFAULTADDRESSID` --- ## MACCOUNTGROUP **Module:** AccountsDAL | **Source:** `GB5Solution/Accounts/AccountsDAL/Query/AccountGroup/AccountGroupQB.cs` **Columns (from INSERT INTO):** - `ACCOUNTGROUPID` - `ACCOUNTGROUPCODE` - `ACCOUNTGROUPNAME` - `ACCOUNTGROUPSHORTNAME` - `ACCOUNTGROUPNATURE` - `PARENTID` - `ACCOUNTSCHEDULEID` - `OPPOSITEGROUPID` - `SORTORDER` - `STATUS` - `VERSION` - `SOURCETYPE` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## MACCOUNTSCHEDULE **Module:** AccountsDAL | **Source:** `GB5Solution/Accounts/AccountsDAL/Query/AccountSchedule/AccountScheduleQB.cs` **Columns (from INSERT INTO):** - `ACCOUNTSCHEDULEID` - `ACCOUNTSCHEDULECODE` - `ACCOUNTSCHEDULENAME` - `ACCOUNTSCHEDULESHORTNAME` - `ACCOUNTSCHEDULENATURE` - `PARENTID` - `SORTORDER` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `SOURCETYPE` --- ## MACTION **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/EventRule/EventRuleQB.cs` **Columns (from INSERT INTO):** - `ACTIONID` - `DESCRIPTION` - `EVENTTYPEID` - `ACTIONTYPE` - `REPLYTO` - `TEMPLATEID` - `TODELIVERYTYPE` - `TOCONTENTTYPE` - `SENDTO` - `MAILCCDELIVERYTYPE` - `MAILCCCONTENTTYPE` - `MAILCC` - `MAILBCCDELIVERYTYPE` - `MAILBCCCONTENTTYPE` - `MAILBCC` - `EXPORTFORMAT` - `REPORTTYPE` - `REPORTFORMATID` - `MAILFILEID` - `JOBID` - `WEBSERVICEID` - `CRITERIACONFIGID` - `SORTORDER` - `SOURCETYPE` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `MENUID` - `TYPE` - `URIPARAMETERVALUE` - `ACTIONFORTYPE` - `REPORTID` - `GROUPBYFIELDS` - `REMARKS` - `REPORTVIEWID` - `MAILLISTID` - `ISPREVIOUSVERSION` - `TENANTID` - `ISFILEBASED` - `ISENCRYPTIONREQUIRED` - `ACTIONNAME` - `CONDITIONEXPRESSION` --- ## MADDRESS **Module:** PayRollDAL | **Source:** `GB5Solution/PayRoll/PayRollDAL/Query/Address/AddressQB.cs` **Columns (from INSERT INTO):** - `ADDRESSID` - `OBJECTTYPEID` - `OBJECTID` - `ADDRESSTYPE` - `ADDRESSNATURE` - `ADDRESSLINE1` - `ADDRESSLINE2` - `ADDRESSLINE3` - `ADDRESSLINE4` - `ADDRESSLINE5` - `ZIPCODE` - `CITYID` - `COUNTRYID` - `PHONE` - `MOBILE` - `FAX` - `WEB` - `GEOCODE` - `STANDARDREGIONID` - `MAIL` - `VATTINNUMBER` - `VATCSTNUMBER` - `PAN` - `TAN` - `SERVICETAXNUMBER` - `EXCISEDIVISION` - `EXCISERANGE` - `EXCISECODENUMBER` - `EXCISENOTIFICATION` - `EXCISECIRCLE` - `EXCISECOLLECTRATE` - `EXCISEREGISTERNUMBER` - `SORTORDER` - `VERSION` - `STATUS` - `SOURCETYPE` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `TDSCIRCLE` - `LOCATIONID` - `GSTIN` - `STATEID` - `GEOLOCATION` - `BORDER` --- ## MALLOCATION **Module:** AdminDAL | **Source:** `GB5Solution/Admin/AdminDAL/Query/Allocation/AllocationQB.cs` **Columns (from INSERT INTO):** - `ALLOCATIONID` - `ALLOCATIONNAME` - `ALLOCATIONSHORTNAME` - `ALLOCATIONTYPEID` - `DESCRIPTION` - `INCHARGEID` - `ISCAPITAL` - `FROMDATE` - `TODATE` - `PARENTALLOCATIONID` - `OBJECTTYPEID` - `OBJECTID` - `COSTCENTERID` - `OUID` - `PARTYID` - `SORTORDER` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `SOURCETYPE` - `TENANTID` - `RATE` - `CURRENCYID` - `NUMBEROFDATA` - `EXPECTEDPERHOUR` - `RATEPERUOM` - `PARTYBRANCHID` - `REFERENCEPARTYBRANCHID` - `BROKERPARTYBRANCHID` - `INCHARGEEMPLOYEEID` - `PORTFOLIOID` - `PMSTATUS` - `WORKLEVELTYPE` - `PROJECTVALUE` - `PROJECTGCVALUE` - `PROJECTBUDGET` - `PROJECTGCBUDGET` - `BILLTYPEID` - `BILLMETHODID` - `REMARKS` --- ## MALLOCATIONTYPE **Module:** AdminDAL | **Source:** `GB5Solution/Admin/AdminDAL/Query/AllocationType/AllocationTypeQB.cs` **Columns (from INSERT INTO):** - `ALLOCATIONTYPEID` - `ALLOCATIONTYPECODE` - `ALLOCATIONTYPENAME` - `ISPOSTCOSTCENTER` - `COSTCATEGORYID` - `ISMULTILEVEL` - `ISDATEBASED` - `OBJECTTYPEID` - `ISCAPITAL` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## MAPI **Module:** AMPDAL | **Source:** `GB5Solution/AMP/AMPDAL/Query/RegisterApi/RegisterApiQB.cs` **Columns (from INSERT INTO):** - `APIID` - `TENANTID` - `APIKEY` - `APINAME` - `DESCRIPTION` - `APIKIND` - `APITYPE` - `CRITICALITY` - `LIFECYCLESTATUS` - `VISIBILITYLEVEL` - `APIPROVIDERTYPE` - `EXPOSURETYPE` - `ISHEADLESSENABLED` - `OWNERTEAM` - `BUSINESSOWNER` - `RUNTIMETYPE` - `TECHNOLOGY` - `REPOURL` - `PIPELINEREF` - `PROVIDERID` - `CATEGORYID` - `APIDOMAINID` - `GEOGRAPHY` - `REGULATORYIMPACT` - `RISKRATING` - `SLAREFERENCE` - `REMARKS` - `ABOUTAPI` - `KEYFEATURES` - `USECASES` - `QUICKSTART` - `SORTORDER` - `STATUS` - `VERSION` - `SOURCETYPE` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## MAPIARTIFACT **Module:** AMPDAL | **Source:** `GB5Solution/AMP/AMPDAL/Query/RegisterApi/RegisterApiQB.cs` **Columns (from INSERT INTO):** - `APIARTIFACTID` - `TENANTID` - `APIID` - `ARTIFACTTYPE` - `TITLE` - `LOCATION` - `REMARKS` - `SORTORDER` - `STATUS` - `VERSION` - `SOURCETYPE` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## MAPICAPABILITY **Module:** AMPDAL | **Source:** `GB5Solution/AMP/AMPDAL/Query/RegisterApi/RegisterApiQB.cs` **Columns (from INSERT INTO):** - `APICAPABILITYID` - `TENANTID` - `APIID` - `APIDOMAINID` - `CAPABILITYNAME` - `DESCRIPTION` - `REMARKS` - `SORTORDER` - `STATUS` - `VERSION` - `SOURCETYPE` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## MAPICAPABILITYLINK **Module:** AMPDAL | **Source:** `GB5Solution/AMP/AMPDAL/Query/RegisterApi/RegisterApiQB.cs` **Columns (from INSERT INTO):** - `APICAPABILITYLINKID` - `TENANTID` - `APIID` - `APICAPABILITYID` - `SORTORDER` - `STATUS` - `VERSION` - `SOURCETYPE` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## MAPIDOMAIN **Module:** AMPDAL | **Source:** `GB5Solution/AMP/AMPDAL/Query/RegisterApi/RegisterApiQB.cs` **Columns (from INSERT INTO):** - `APIDOMAINID` - `BLL` - `TENANTID` - `APIID` - `DOMAINNAME` - `PARENTDOMAINID` - `REMARKS` - `SORTORDER` - `STATUS` - `VERSION` - `SOURCETYPE` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## MAPIEXPOSUREPOLICY **Module:** AMPDAL | **Source:** `GB5Solution/AMP/AMPDAL/Query/RegisterApi/RegisterApiQB.cs` **Columns (from INSERT INTO):** - `APIEXPOSUREPOLICYID` - `TENANTID` - `APIID` - `ALLOWPARTNERACCESS` - `ALLOWPUBLICACCESS` - `BILLINGCATEGORY` - `SLAREFERENCE` - `REMARKS` - `SORTORDER` - `STATUS` - `VERSION` - `SOURCETYPE` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## MAPIINTERFACE **Module:** AMPDAL | **Source:** `GB5Solution/AMP/AMPDAL/Query/RegisterApi/RegisterApiQB.cs` **Columns (from INSERT INTO):** - `APIINTERFACEID` - `TENANTID` - `APIID` - `APIVERSIONID` - `INTERFACETYPE` - `INTERFACENAME` - `SPECTYPE` - `METHOD` - `APIPATH` - `INTERFACEDESCRIPTION` - `SPECLOCATION` - `CONTENTHASH` - `PARSEDSUCCESSFULLY` - `LASTPARSEDAT` - `SOURCE` - `REMARKS` - `SORTORDER` - `STATUS` - `VERSION` - `SOURCETYPE` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## MAPIOPERATION **Module:** AMPDAL | **Source:** `GB5Solution/AMP/AMPDAL/Query/RegisterApi/RegisterApiQB.cs` **Columns (from INSERT INTO):** - `APIOPERATIONID` - `TENANTID` - `APIID` - `APIINTERFACEID` - `OPERATIONKEY` - `HTTPMETHOD` - `RELATIVEPATH` - `SUMMARY` - `REMARKS` - `SORTORDER` - `STATUS` - `VERSION` - `SOURCETYPE` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## MAPIPARAMETER **Module:** AMPDAL | **Source:** `GB5Solution/AMP/AMPDAL/Query/RegisterApi/RegisterApiQB.cs` **Columns (from INSERT INTO):** - `PARAMETERID` - `TENANTID` - `APIID` - `APIOPERATIONID` - `NAME` - `INLOCATION` - `DATATYPE` - `ISREQUIRED` - `REMARKS` - `SORTORDER` - `STATUS` - `VERSION` - `SOURCETYPE` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## MAPIREQUEST **Module:** AMPDAL | **Source:** `GB5Solution/AMP/AMPDAL/Query/ApiRequest/ApiRequestQB.cs` **Columns (from INSERT INTO):** - `APIREQUESTID` - `TENANTID` - `REQUESTCODE` - `REQUESTTITLE` - `REQUESTDESCRIPTION` - `BUSINESSJUSTIFICATION` - `USECASES` - `INTENTKEYWORDS` - `REQUESTEDBYID` - `REQUESTEDON` - `TARGETDOMAINID` - `PROPOSEDAPITYPE` - `PROPOSEDAPIKIND` - `PRIORITY` - `REQUESTSTATUS` - `ASSIGNEDTOID` - `LINKEDAPIID` - `LINKEDAPIVERSIONID` - `TARGETDELIVERYDATE` - `REMARKS` - `SORTORDER` - `STATUS` - `VERSION` - `SOURCETYPE` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## MAPIREQUESTCHECKLIST **Module:** AMPDAL | **Source:** `GB5Solution/AMP/AMPDAL/Query/ApiRequestChecklist/ApiRequestChecklistQB.cs` **Columns (from INSERT INTO):** - `CHECKLISTID` - `TENANTID` - `APIREQUESTID` - `STAGE` - `ITEMTEXT` - `ISCOMPLETE` - `SORTORDER` - `CREATEDON` --- ## MAPIREQUESTDUPLICATECHECK **Module:** AMPDAL | **Source:** `GB5Solution/AMP/AMPDAL/Query/ApiRequestDuplicateCheck/ApiRequestDuplicateCheckQB.cs` **Columns (from INSERT INTO):** - `DUPLICATECHECKID` - `TENANTID` - `SOURCEAPIREQUESTID` - `MATCHSOURCE` - `MATCHEDAPIID` - `MATCHEDREQUESTID` - `MATCHEDINTERFACEID` - `OVERALLSCORE` - `NAMESCORE` - `DOMAINSCORE` - `INTENTSCORE` - `SCHEMASCORE` - `SUGGESTIONTYPE` - `SUGGESTEDCHANGE` - `MATCHREASON` - `REVIEWSTATUS` - `CREATEDON` --- ## MAPIREQUESTSUBSCRIBER **Module:** AMPDAL | **Source:** `GB5Solution/AMP/AMPDAL/Query/ApiRequestSubscriber/ApiRequestSubscriberQB.cs` **Columns (from INSERT INTO):** - `SUBSCRIBERID` - `TENANTID` - `APIREQUESTID` - `SUBSCRIBERUSERID` - `NOTIFYONSTATUS` - `ISACTIVE` - `CREATEDBYID` - `CREATEDON` --- ## MAPIREQUESTTIMELINE **Module:** AMPDAL | **Source:** `GB5Solution/AMP/AMPDAL/Query/ApiRequestTimeline/ApiRequestTimelineQB.cs` **Columns (from INSERT INTO):** - `TIMELINEID` - `TENANTID` - `APIREQUESTID` - `FROMSTATUS` - `TOSTATUS` - `ACTIONTAKENBYID` - `ACTIONTAKENON` - `COMMENTS` - `ATTACHMENTURL` --- ## MAPISCHEMA **Module:** AMPDAL | **Source:** `GB5Solution/AMP/AMPDAL/Query/RegisterApi/RegisterApiQB.cs` **Columns (from INSERT INTO):** - `APISCHEMAID` - `TENANTID` - `APIID` - `APIINTERFACEID` - `APINAME` - `SCHEMAJSON` - `SCHEMANAME` - `SCHEMADESCRIPTION` - `SPECIFICATIONSOURCE` - `SPECIFICATIONURL` - `REQUESTJSON` - `RESPONSEJSON` - `REMARKS` - `SORTORDER` - `STATUS` - `VERSION` - `SOURCETYPE` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## MAPIVERSION **Module:** AMPDAL | **Source:** `GB5Solution/AMP/AMPDAL/Query/RegisterApi/RegisterApiQB.cs` **Columns (from INSERT INTO):** - `APIVERSIONID` - `TENANTID` - `APIID` - `REPLACEMENTAPIID` - `VERSION` - `VERSIONSTATUS` - `ISBREAKING` - `FROMDATE` - `TODATE` - `SUNSETDATE` - `NOTES` - `REMARKS` - `VERSIONDESCRIPTION` - `ADDED` - `SORTORDER` - `STATUS` - `VERSIONNO` - `SOURCETYPE` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## MASSETASSIGNMENT **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/AssetAssignment/AssetAssignmentQB.cs` **Columns (from INSERT INTO):** - `ASSETASSIGNMENTID` - `ASSIGNMENTNAME` - `DESCRIPTION` - `ASSIGNMENTTYPE` - `ASSETTYPEID` - `PARTYBRANCHID` - `PARTYBRANCHLOCATIONID` - `OUID` - `DEPARTMENTID` - `CATEGORYID` - `SUBCATEGORYID` - `USERGROUPID` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `SORTORDER` - `STATUS` - `VERSION` - `SOURCETYPE` - `TENANTID` --- ## MASSETTYPE **Module:** FMDAL | **Source:** `GB5Solution/FM/FMDAL/Query/AssetType/AssetTypeQB.cs` **Columns (from INSERT INTO):** - `ASSETTYPEID` - `ASSETTYPECODE` - `ASSETTYPENAME` - `TRACKINGTYPE` - `PARAMETERSETID` - `NATURE` - `MMTRACKINGREQUIRED` - `ISMETER` - `ISGENERATOR` - `SORTORDER` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `SOURCETYPE` - `ASSETCODEDEFINEID` - `ACCOUNTINGTYPE` - `ASSETWIPACCOUNTID` - `ASSETACCOUNTID` - `DEPRECIATIONACCOUNTID` - `ISDEPRECIATIONAPPLICABLE` - `DEPRECIATIONID` - `DEPRECIATIONPERCENTAGE` - `LIFE` - `ISTAXDEPRECIATIONAPPLICABLE` - `TAXDEPRECIATIONID` - `TAXDEPRECIATIONPERCENTAGE` - `TAXLIFE` - `ISAMC` - `ISINSURANCE` - `ISINSTALLATION` - `ISLOCATION` - `ISWARRANTY` - `ISMAINTENANCE` - `ISLICENSE` - `ISBARCODE` - `ISREGISTRATION` - `ISLEASE` - `ISCENVAT` - `ISRESPONSIBLE` - `ISMANUFACTURER` - `ASSETSCHEDULEID` - `ACCUMULATEDDEPRECIATIONACCOUNTID` - `TENANTID` - `RESOURCETYPEID` - `SLAID` --- ## MATTRIBUTETYPE **Module:** MMDAL | **Source:** `GB5Solution/MM/MMDAL/Query/AttributeType/AttributeTypeQB.cs` **Columns (from INSERT INTO):** - `ATTRIBUTETYPEID` - `ATTRIBUTETYPECODE` - `ATTRIBUTETYPENAME` - `REMARKS` - `SORTORDER` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `SOURCETYPE` --- ## MBANKBRANCH **Module:** AccountsDAL | **Source:** `GB5Solution/Accounts/AccountsDAL/Query/BankBranch/BankBranchQB.cs` **Columns (from INSERT INTO):** - `BANKBRANCHID` - `BANKBRANCHNAME` - `BANKID` - `ADDRESSID` - `COUNTRYID` - `STATEID` - `CITYID` - `MAILID` - `PHONE` - `MOBILE` - `IFSC` - `SWIFT` - `BBAN` - `REMARKS` - `SORTORDER` - `STATUS` - `VERSION` - `SOURCETYPE` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## MBATCHRULE **Module:** MMDAL | **Source:** `GB5Solution/MM/MMDAL/Query/Scheduling/BatchRuleQB.cs` **Columns (from INSERT INTO):** - `MBATCHRULEID` - `WORKCENTERID` - `PROCESSID` - `BATCHBASISTYPE` - `BATCHMINIMUM` - `BATCHMAXIMUM` - `PREFERREDBATCHQTY` - `BATCHCONTINUITY` - `STATUS` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `TENANTID` --- ## MBIZTRANSACTION **Module:** AdminDAL | **Source:** `GB5Solution/Admin/AdminDAL/Query/BIZTransaction/BIZTransactionQB.cs` **Columns (from INSERT INTO):** - `BIZTRANSACTIONID` - `BIZTRANSACTIONCODE` - `BIZTRANSACTIONNAME` - `BIZTRANSACTIONSUBCLASSID` - `PROCESSID` - `SORTORDER` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `FINANCEBOOKID` --- ## MBIZTRANSACTIONKEYS **Module:** Unknown | **Source:** `GB5Shared/Query/VoucherNumber/VoucherNumberQB.cs` **Columns (from INSERT INTO):** - `BIZTRANSACTIONKEYSID` - `BIZTRANSACTIONTYPEID` - `BIZTRANSACTIONYEAR` - `BIZTRANSACTIONMONTH` - `BIZTRANSACTIONDAY` - `PREFIX` - `SUFFIX` - `SYSTEMPREFIX` - `LASTNO` --- ## MBIZTRANSACTIONSUBCLASS **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/BIZTransactionSubClass/BIZTransactionSubClassQB.cs` **Columns (from INSERT INTO):** - `BIZTRANSACTIONSUBCLASSID` - `BIZTRANSACTIONSUBCLASSCODE` - `BIZTRANSACTIONSUBCLASSNAME` - `BIZTRANSACTIONCLASSID` - `SORTORDER` - `STATUS` - `VERSION` - `SOURCETYPE` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## MBOM **Module:** MMDAL | **Source:** `GB5Solution/MM/MMDAL/Query/BOM/BOMQB.cs` **Columns (from INSERT INTO):** - `BOMID` - `BOMTYPE` - `LINKID` - `PRODUCTIONITEMID` - `VERSIONNAME` - `ISDEFAULTVERSION` - `PRODUCTIONQTY` - `ISCHANGEABLE` - `VERSION` - `STATUS` - `SORTORDER` - `LINKTYPEID` - `UOMID` - `FROMDATE` - `TODATE` - `ISPROCESSLEVEL` - `ROUTINGID` - `WASTEPERCENTAGE` - `REQUIREDPRODUCTIONQUANTITY` - `REMARKS` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `SOURCETYPE` - `TENANTID` - `BOMCODE` - `BOMNAME` - `LINKDETAILID` - `LINKDETAILTYPEID` - `DEFAULTBOMID` --- ## MBOMDETAIL **Module:** MMDAL | **Source:** `GB5Solution/MM/MMDAL/Query/BOM/BOMQB.cs` **Columns (from INSERT INTO):** - `BOMLINEID` - `BOMID` - `SLNO` - `PRODUCTIONSTAGE` - `PRODUCTIONPROCESSID` - `MATERIALTYPE` - `INCLUDEEXCLUDETYPE` - `ITEMID` - `SUBITEMID` - `PROCESSID` - `QUANTITY` - `PERCENTAGE` - `UOMID` - `ISCHANGEABLE` - `BOMLEVEL` - `PRODUCTIONSTEP` - `IOTYPE` - `MAKEORBUY` - `SKUID` - `CALCULATIONTYPE` - `UNITQUANTITYFORMULAID` - `PERPRODUCTIONQUANTITYFORMULAID` - `PERPRODUCTIONQUANTITY` - `PRODUCTIONUOMID` - `REQUIREDPRODUCTIONQUANTITY` - `CALCULATEDQUANTITY` - `WASTEPERCENTAGE` - `NETQUANTITY` - `ADJUSTQUANTITY` - `FINALQUANTITY` - `PARAMETERSETID` - `CATEGORYID` - `SUBCATEGORYID` - `ITEMGROUPID` - `ISSUEDQUANTITY` - `LEVELCODE` - `DEFAULTLOCATIONTYPE` - `PREVIOUSPARENTBOMLINEID` - `PARTNUMBER` - `PARTNAME` - `PARTICULARS` - `PARTDRAWINGNUMBER` - `PARTMAINITEMID` - `PARTMAINSKUID` --- ## MBOMDETAILPARAMETER **Module:** MMDAL | **Source:** `GB5Solution/MM/MMDAL/Query/BOM/BOMQB.cs` **Columns (from INSERT INTO):** - `BOMDETAILPARAMETERID` - `BOMLINEID` - `PARAMETERID` - `PARAMETERVALUE` - `FINALVALUE` - `SLNO` - `PARAMETERTYPE` - `PARAMETERINPUTTYPE` --- ## MBRANCH **Module:** AdminDAL | **Source:** `GB5Solution/Admin/AdminDAL/Query/Branch/BranchQB.cs` **Columns (from INSERT INTO):** - `BRANCHID` - `COMPANYID` - `BRANCHCODE` - `BRANCHNAME` - `BRANCHSHORTNAME` - `SORTORDER` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## MCALCULATIONFORMULA **Module:** MMDAL | **Source:** `GB5Solution/MM/MMDAL/Query/CalculationFormula/CalculationFormulaQB.cs` **Columns (from INSERT INTO):** - `CALCULATIONFORMULA` - `SCOPETYPE` - `SCOPEID` - `PHASENO` - `FORMULATEXT` - `OUTPUTUNITID` - `DESCRIPTION` - `SORTORDER` - `STATUS` - `VERSION` - `SOURCETYPE` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## MCALENDAR **Module:** AdminDAL | **Source:** `GB5Solution/Admin/AdminDAL/Query/Calendar/CalendarQB.cs` **Columns (from INSERT INTO):** - `CALENDARID` - `CALENDARCODE` - `CALENDARNAME` - `SORTORDER` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `SOURCETYPE` - `TENANTID` --- ## MCALENDARDETAIL **Module:** AdminDAL | **Source:** `GB5Solution/Admin/AdminDAL/Query/Calendar/CalendarQB.cs` **Columns (from INSERT INTO):** - `CALENDARDETAILID` - `CALENDARID` - `SLNO` - `DETAILDATE` - `DETAILDAY` - `DETAILTYPE` - `PARTICULARS` --- ## MCALLALLOCATION **Module:** CRMDAL | **Source:** `GB5Solution/CRM/CRMDAL/Query/CallAllocation/CallAllocationQB.cs` **Columns (from INSERT INTO):** - `CALLALLOCATIONID` - `BRANDID` - `CATEGORYID` - `SUBCATEGORYID` - `OUID` - `COUNTRYID` - `STATEID` - `CITYID` - `ZIPCODE` - `LOCATIONID` - `PROBLEMCATEGORYID` - `ALLOTMENTTYPE` - `PARTYID` - `PARTYBRANCHID` - `EMPLOYEEID` - `TECHNICIANID` - `WORKTYPEID` - `CALLTYPEID` - `CALLNATUREID` - `USERGROUPID` - `RULENAME` - `RULEDESCRIPTION` --- ## MCANONICALMODEL **Module:** AdminDAL | **Source:** `GB5Solution/Admin/AdminDAL/Query/CanonicalModel/CanonicalModelQB.cs` **Columns (from INSERT INTO):** - `NAME` - `MODULEID` - `SECTIONID` - `DESCRIPTION` - `FIELDDATA` - `SAMPLEDATA` - `DISPLAYTEMPLATEID` - `SORTORDER` - `STATUS` - `VERSION` - `TENANTID` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## MCASHBACKRULE **Module:** PAYDAL | **Source:** `GB5Solution/PAY/PAYDAL/Query/Cashback/CashbackRuleQB.cs` **Columns (from INSERT INTO):** - `CASHBACKRULEID` - `CASHBACKRULENAME` - `CASHBACKTYPE` - `CASHBACKVALUE` - `MINAMOUNT` - `MAXCASHBACK` - `PAYOUTMODE` - `PAYOUTDELAYDAYS` - `PAYGATEWAYID` - `ISACTIVE` - `VALIDFROM` - `VALIDTO` - `DESCRIPTION` - `VERSION` - `STATUS` - `SORTORDER` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `SOURCETYPE` - `TENANTID` --- ## MCERTIFICATIONTYPE **Module:** MMDAL | **Source:** `GB5Solution/MM/MMDAL/Query/CertificationType/CertificationTypeQB.cs` **Columns (from INSERT INTO):** - `CERTIFICATIONTYPEID` - `CERTIFICATIONTYPECODE` - `CERTIFICATIONTYPENAME` - `REMARKS` - `ISVALIDITY` - `SORTORDER` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `SOURCETYPE` --- ## MCHARGE **Module:** MMDAL | **Source:** `GB5Solution/MM/MMDAL/Query/Charge/ChargeQB.cs` **Columns (from INSERT INTO):** - `CHARGEID` - `CHARGECODE` - `CHARGENAME` - `CHARGETYPE` - `REVERSEFORMULAID` - `SORTORDER` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `SOURCETYPE` - `TENANTID` --- ## MCHARGEELEMENT **Module:** MMDAL | **Source:** `GB5Solution/MM/MMDAL/Query/ChargeElement/ChargeElementQB.cs` **Columns (from INSERT INTO):** - `CHARGEELEMENTID` - `CHARGEELEMENTCODE` - `CHARGEELEMENTNAME` - `CHARGENATURE` - `CHARGESECTION` - `INPUTVALUETYPE` - `INPUTTYPE` - `OPERATIONTYPE` - `PARTYACCOUNTTYPE` - `PARTYACCOUNTID` - `PARTYSUBACCOUNTID` - `PARTYLINKTYPE` - `CONTRAACCOUNTTYPE` - `CONTRAACCOUNTID` - `CONTRASUBACCOUNTID` - `DEFAULTINPUTVALUE` - `DEFAULTMINIMUMVALUE` - `DEFAULTMAXIMUMVALUE` - `INPUTDATAFIELDID` - `MINIMUMDATAFIELDID` - `MAXIMUMDATAFIELDID` - `LOADVALIDATIONTYPE` - `TOLERANCETYPE` - `TOLERANCEPLUSVALUE` - `TOLERANCEMINUSVALUE` - `DEPENDSONCHARGEELEMENT` - `FORMULAID` - `PARTYACCOUNTCRITERIACONFIG` - `CONTRAACCOUNTCRITERIACONFIG` - `PARTYACCOUNTMERGE` - `CONTRAACCOUNTMERGE` - `INPUTDATAFIELDTYPE` - `MINIMUMDATAFIELDTYPE` - `MAXIMUMDATAFIELDTYPE` - `SORTORDER` - `STATUS` - `VERSION` - `CREATEDON` - `MODIFIEDON` - `SOURCETYPE` - `CREATEDBYID` - `MODIFIEDBYID` - `TENANTID` --- ## MCHECKING **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/Checking/CheckingQB.cs` **Columns (from INSERT INTO):** - `CHECKINGID` - `CHECKINGCODE` - `CHECKINGNAME` - `DISPLAYTEXT` - `SORTORDER` - `VERSION` - `STATUS` - `SOURCETYPE` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## MCHECKINGOPTION **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/CheckingOption/CheckingOptionQB.cs` **Columns (from INSERT INTO):** - `CHECKINGOPTIONID` - `CHECKINGOPTIONTYPE` - `ENTITYID` - `BIZTRANSACTIONCLASSID` - `SORTORDER` - `VERSION` - `STATUS` - `SOURCETYPE` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## MCHECKLIST **Module:** QMSDAL | **Source:** `GB5Solution/QMS/QMSDAL/Query/Checklist/ChecklistQB.cs` **Columns (from INSERT INTO):** - `CHECKLISTID` - `CHECKLISTCODE` - `CHECKLISTNAME` - `DISPLAYMODE` - `TIMING` - `TEAMID` - `ISBLOCKING` - `ISMANDATORY` - `REMARKS` - `SORTORDER` - `VERSION` - `STATUS` - `TENANTID` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## MCHECKLISTAPPLICABILITY **Module:** QMSDAL | **Source:** `GB5Solution/QMS/QMSDAL/Query/ChecklistApplicability/ChecklistApplicabilityQB.cs` **Columns (from INSERT INTO):** - `CHECKLISTID` - `SCOPETYPE` - `PROCESSID` - `ITEMID` - `SKUID` - `INDENTID` - `INDENTDETAILID` - `WORKCENTERID` - `FREQUENCYTYPE` - `FREQUENCYVALUE` - `EFFECTIVEFROM` - `EFFECTIVETO` - `PRIORITY` - `VERSION` - `TENANTID` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## MCHECKLISTDETAIL **Module:** QMSDAL | **Source:** `GB5Solution/QMS/QMSDAL/Query/ChecklistDetail/ChecklistDetailQB.cs` **Columns (from INSERT INTO):** - `CHECKLISTDETAILID` - `CHECKLISTID` - `SLNO` - `SECTION` - `DETAILTEXT` - `ACTIONTYPE` - `UOMID` - `MINVAL` - `MAXVAL` - `LOVTYPEID` - `ISMANDATORY` - `HELPTEXT` - `FAILACTION` - `TENANTID` --- ## MCHEQUEBOOK **Module:** AccountsDAL | **Source:** `GB5Solution/Accounts/AccountsDAL/Query/ChequeBook/ChequeBookQB.cs` **Columns (from INSERT INTO):** - `CHEQUEBOOKID` - `BANKID` - `INSTRUMENTID` - `BOOKNO` - `NOOFLEAVES` - `STARTNO` - `REMARKS` - `BOOKTYPE` - `CHEQUEPREFIX` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `TENANTID` --- ## MCHEQUEBOOKDETAIL **Module:** AccountsDAL | **Source:** `GB5Solution/Accounts/AccountsDAL/Query/ChequeBook/ChequeBookQB.cs` **Columns (from INSERT INTO):** - `CHEQUEBOOKDETAILID` - `CHEQUEBOOKID` - `CHEQUENO` - `STATUS` - `CANCELREASON` - `TENANTID` --- ## MCITY **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/City/CityQB.cs` **Columns (from INSERT INTO):** - `CITYID` - `CITYCODE` - `CITYNAME` - `COUNTRYID` - `STATUS` - `VERSION` - `SOURCETYPE` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `STATEID` - `TRAFFICREMARKS` - `STDCODE` --- ## MCLIENTCONTACT **Module:** IDMSDAL | **Source:** `GB5Solution/IDMS/IDMSDAL/QueryBuilders/ClientContactQB.cs` **Columns (from INSERT INTO):** - `CONTACTID` - `ENGAGEMENTID` - `TENANTID` - `FULLNAME` - `EMAIL` - `PHONE` - `ROLEINPROJECT` - `ISPRIMARY` - `ISSIGNATORY` - `NOTIFICATIONPREFS` - `VERSION` - `STATUS` - `SORTORDER` - `SOURCETYPE` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## MCODEDEFINE **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/CodeDefine/CodeDefineQB.cs` **Columns (from INSERT INTO):** - `CODEDEFINEID` - `ENTITYID` - `SLNO` - `CATEGORYCODE` - `CATEGORYNAME` - `GENERATIONTYPE` - `CATPREFIX` - `CATSUFFIX` - `FORMULAID` - `FORMULABASEDFIELDS` - `CATSTARTNO` - `CATENDNO` - `CATLASTNO` - `REMARKS` - `CODESIZE` - `SORTORDER` - `STATUS` - `VERSION` - `SOURCETYPE` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `AUTOLOADID` - `TEMPLATEID` - `APPLICABLEOUIDS` --- ## MCODEDEFINESEGMENT **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/CodeDefine/CodeDefineSegmentQB.cs` **Columns (from INSERT INTO):** - `SEGMENTID` - `CODEDEFINEID` - `SLNO` - `SEGMENTTYPE` - `SOURCEFIELD` - `LOOKUPTABLE` - `PREFIX` - `SUFFIX` - `ISMANDATORY` - `DEFAULTVALUE` - `FORMAT` - `SEPARATOR` - `STATUS` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## MCOLOR **Module:** MMDAL | **Source:** `GB5Solution/MM/MMDAL/Query/Color/ColorQB.cs` **Columns (from INSERT INTO):** - `COLORID` - `COLORCODE` - `COLORNAME` - `COLORNAMEINNATIVE` - `COLORTYPE` - `ISTWISTCOLOR` - `FIRSTCOLORID` - `SECONDCOLORID` - `THIRDCOLORID` - `RGBVALUE1` - `RGBVALUE2` - `RGBVALUE3` - `SHADETYPE` - `DYEINGLOSSPERCENTAGE` - `DYEINGRATE` - `SORTORDER` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `SOURCETYPE` - `TENANTID` --- ## MCOMMANDPANEL **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/CommandPanel/CommandPanelQB.cs` **Columns (from INSERT INTO):** - `CATEGORY` - `KEYSTRING` - `ISCTRLKEY` - `ISALTKEY` - `ISSHIFTKEY` - `FORMID` - `ACTIONNAME` - `SORTORDER` - `STATUS` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## MCOMPANY **Module:** AdminDAL | **Source:** `GB5Solution/Admin/AdminDAL/Query/Company/CompanyQB.cs` **Columns (from INSERT INTO):** - `COMPANYID` - `COMPANYCODE` - `COMPANYNAME` - `COMPANYSHORTNAME` - `SORTORDER` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `COMPANYLOGO` - `COMPANYLOGO2` - `SOURCETYPE` - `CINNUMBER` - `IMPORTEXPORTCODE` - `IECDATE` - `TENANTID` - `MSMEREGNO` --- ## MCOMPLIANCE_ADAPTER_CONFIG **Module:** ComplianceDAL | **Source:** `GB5Solution/Compliance/ComplianceDAL/Query/AdapterConfig/AdapterConfigQB.cs` **Columns (from INSERT INTO):** - `ADAPTERCONFIGID` - `GSPCONFIGID` - `FRAMEWORK` - `GSTIN` - `AUTHURL` - `BASEURL` - `CLIENTIDAPI` - `CLIENTSECRET` - `ISACTIVE` - `CLIENTID` - `DATABASENAME` - `CREATEDBYID` - `CREATEDON` --- ## MCOMPLIANCE_ALERT_CONFIG **Module:** ComplianceDAL | **Source:** `GB5Solution/Compliance/ComplianceDAL/Query/ComplianceAlert/ComplianceAlertQB.cs` **Columns (from INSERT INTO):** - `GSTIN` - `FILINGDEADLINEDAYSBEFOR` - `EWBEXPIRYHOURSBEFORE` - `IRNPENDINGDAYSWINDOW` - `SUBMISSIONFAILEDHOURS` - `ENABLEFILINGALERTS` - `ENABLERECONALERTS` - `ENABLEEWBALERTS` - `ENABLEIRNALERTS` - `CLIENTID` - `DATABASENAME` --- ## MCONTACT **Module:** PayRollDAL | **Source:** `GB5Solution/PayRoll/PayRollDAL/Query/Contact/ContactQB.cs` **Columns (from INSERT INTO):** - `CONTACTID` - `OBJECTTYPEID` - `OBJECTID` - `CONTACTNATURE` - `NAME` - `FIRSTNAME` - `MIDDLENAME` - `LASTNAME` - `SALUTATION` - `SEX` - `DOB` - `MAILID` - `SORTORDER` - `VERSION` - `STATUS` - `SOURCETYPE` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `PHONENO` - `MOBILENO` - `RELATIONSHIP` - `DESIGNATION` - `COMPANY` - `DEFAULTIMAGEID` - `LINKTYPE` - `REPORTINGTOID` - `USERLINKID` - `THUMBNAIL` - `TENANTID` - `CLIENTID` - `EMAIL` --- ## MCONTENTCATEGORY **Module:** CMSDAL | **Source:** `GB5Solution/CMS/CMSDAL/Query/ContentCategory/ContentCategoryQB.cs` **Columns (from INSERT INTO):** - `CONTENTCATEGORYCODE` - `CONTENTCATEGORYNAME` - `PARENTCONTENTCATEGORYID` - `SOURCETYPE` - `SORTORDER` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `TENANTID` --- ## MCONTENTTYPE **Module:** CMSDAL | **Source:** `GB5Solution/CMS/CMSDAL/Query/ContentType/ContentTypeQB.cs` **Columns (from INSERT INTO):** - `SPACEID` - `NAME` - `SLUG` - `DESCRIPTION` - `ICON` - `CONTENTCATEGORYID` - `DISPLAYFIELD` - `FIELDS` - `VALIDATION` - `AIFEATURES` - `ISSYSTEM` - `VERSION` - `SORTORDER` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `TENANTID` - `STATUS` - `SOURCETYPE` --- ## MCOSTANALYSIS **Module:** CostingDAL | **Source:** `GB5Solution/Costing/CostingDAL/Query/CostAnalysis/CostAnalysisQB.cs` **Columns (from INSERT INTO):** - `COSTANALYSISID` - `COSTANALYSISCODE` - `COSTANALYSISNAME` - `COSTINGTYPE` - `PERIODFROM` - `PERIODTO` - `BASICRATETYPE` - `MATERIALCOSTTYPE` - `PROCESSCOSTTYPE` - `RESOURCECOSTTYPE` - `ISCOSTPOSTTOSTOCK` - `VERSION` - `STATUS` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## MCOSTCATEGORY **Module:** AccountsDAL | **Source:** `GB5Solution/Accounts/AccountsDAL/Query/CostCategory/CostCategoryQB.cs` **Columns (from INSERT INTO):** - `COSTCATEGORYID` - `COSTCATEGORYCODE` - `COSTCATEGORYNAME` - `COSTCATEGORYSHORTNAME` - `COSTCENTERTYPEID` - `SORTORDER` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## MCOSTCATEGORYCONDITION **Module:** AccountsDAL | **Source:** `GB5Solution/Accounts/AccountsDAL/Query/CostCategory/CostCategoryQB.cs` **Columns (from INSERT INTO):** - `COSTCATEGORYCONDITIONID` - `COSTCATEGORYID` - `COSTCATEGORYCONDITIONTYPE` - `ACCOUNTGROUPID` - `NATURE` --- ## MCOSTCENTER **Module:** AccountsDAL | **Source:** `GB5Solution/Accounts/AccountsDAL/Query/CostCenter/CostCenterQB.cs` **Columns (from INSERT INTO):** - `COSTCENTERID` - `COSTCENTERCODE` - `COSTCENTERNAME` - `COSTCENTERSHORTNAME` - `COSTCENTERTYPEID` - `SORTORDER` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `SOURCETYPE` - `PARENTID` - `PARENTIDS` - `LEVELS` - `APPLICABLEOUIDS` - `APPLICABLEDEPARTMENTIDS` - `APPLICABLEBIZDIMENSIONVALUEV1IDS` --- ## MCOSTCENTERPATTERN **Module:** AccountsDAL | **Source:** `GB5Solution/Accounts/AccountsDAL/Query/CostCenterPattern/CostCenterPatternQB.cs` **Columns (from INSERT INTO):** - `COSTCENTERPATTERNID` - `COSTCENTERPATTERNCODE` - `COSTCENTERPATTERNNAME` - `REMARKS` - `COSTCENTERTYPEID` - `SORTORDER` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `TENANTID` --- ## MCOSTCENTERPATTERNDETAIL **Module:** AccountsDAL | **Source:** `GB5Solution/Accounts/AccountsDAL/Query/CostCenterPattern/CostCenterPatternQB.cs` **Columns (from INSERT INTO):** - `COSTCENTERPATTERNDETAILID` - `COSTCENTERPATTERNID` - `SLNO` - `COSTCENTERID` - `ALLOCATIONPERCENTAGE` --- ## MCOSTCENTERTYPE **Module:** AccountsDAL | **Source:** `GB5Solution/Accounts/AccountsDAL/Query/CostCenterType/CostCenterTypeQB.cs` **Columns (from INSERT INTO):** - `COSTCENTERTYPEID` - `COSTCENTERTYPECODE` - `COSTCENTERTYPENAME` - `TYPE` - `ISHIERACHICALAPPLICABLE` - `OUID` - `ISCODEREQUIRED` - `SORTORDER` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## MCOUNTRY **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/Country/CountryQB.cs` **Columns (from INSERT INTO):** - `COUNTRYID` - `COUNTRYCODE` - `COUNTRYNAME` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `ISDCODE` - `GSTCOUNTRYCODE` --- ## MCRITERIAATTRIBUTE **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/CriteriaAttribute/CriteriaAttributeQB.cs` **Columns (from INSERT INTO):** - `CRITERIAATTRIBUTEID` - `CRITERIAATTRIBUTENAME` - `CRITERIAATTRIBUTETYPE` - `SECTION` - `PICKLISTID` - `APPLICABLEVALUES` - `DEFAULTVALUEINDEX` - `ISCONTEXTVALUE` - `CONTEXTVALUEFIELDNAME` - `ISDATARESTRICTION` - `VARIABLEFIELD` - `APPLICABLEOPERATION` - `DEFAULTOPERATION` - `SORTORDER` - `STATUS` - `VERSION` - `SOURCETYPE` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `GCMTYPEID` - `FILTERTYPE` --- ## MCURRENCY **Module:** AdminDAL | **Source:** `GB5Solution/Admin/AdminDAL/Query/Currency/CurrencyQB.cs` **Columns (from INSERT INTO):** - `CURRENCYID` - `CURRENCYCODE` - `CURRENCYSYMBOL` - `CURRENCYNAME` - `CURRENCYFULL` - `CURRENCYDECIMAL` - `SORTORDER` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `GAINACCOUNTID` - `LOSSACCOUNTID` - `DECIMALNAME` - `GSTCURRENCYCODE` - `NUMBEROFDECIMAL` --- ## MCUSTLOYALTYENROLLMENT **Module:** PAYDAL | **Source:** `GB5Solution/PAY/PAYDAL/Query/Loyalty/CustomerLoyaltyEnrollmentQB.cs` **Columns (from INSERT INTO):** - `ENROLLMENTID` - `CUSTOMERID` - `LOYALTYPROGRAMID` - `LOYALTYTIERID` - `ENROLLEDON` - `MEMBERSHIPNO` - `CURRENTPOINTS` - `LIFETIMEPOINTS` - `LASTACTIVITYDATE` - `REMARKS` - `VERSION` - `STATUS` - `SORTORDER` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `SOURCETYPE` - `TENANTID` --- ## MCYCLECLASS **Module:** MMDAL | **Source:** `GB5Solution/MM/MMDAL/Query/CycleClass/CycleClassQB.cs` **Columns (from INSERT INTO):** - `CYCLECLASSID` - `CYCLECLASS` - `DESCRIPTION` - `INTERVALDAYS` - `PERCENTAGEOFITEMS` - `VERSION` - `STATUS` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `SOURCETYPE` - `SORTORDER` --- ## MDAPOINTGROUP **Module:** PayRollDAL | **Source:** `GB5Solution/PayRoll/PayRollDAL/Query/DAPointGroupId/DAPointGroupQB.cs` **Columns (from INSERT INTO):** - `DAPOINTGROUPID` - `DAPOINTGROUPCODE` - `DAPOINTGROUPNAME` - `DAPOINTGROUPSET` - `BASEINDEX` - `RATEPERPOINT` - `SORTORDER` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `SOURCETYPE` - `TENANTID` --- ## MDATAALERT **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/DataAlert/DataAlertQB.cs` **Columns (from INSERT INTO):** - `DATAALERTID` - `DATAALERTNAME` - `MODULEID` - `SECTION` - `DESCRIPTION` - `ALERTLEVEL` - `EXPRESSION` - `SUMMARYEXPRESSION` - `FILTERSUMMARYEXPRESSION` - `OUWISE` - `USERWISE` - `NOOFFILTERS` - `MESSAGE` - `SOLUTION` - `FILTERNAME1` - `FILTERNAME2` - `FILTERNAME3` - `FILTERNAME4` - `FILTERNAME5` - `FIELDSTODISPLAY` - `ENTITYID` - `SORTORDER` - `VERSION` - `STATUS` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `SOURCETYPE` - `FILTER1` - `FILTER2` - `FILTER3` - `FILTER4` - `FILTER5` --- ## MDATADICTIONARY **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/DataDictionary/DataDictionaryQB.cs` **Columns (from INSERT INTO):** - `DATADICTIONARYID` - `DATADICTIONARYNAME` - `SECTION` - `MODULEID` - `PARTICULARS` - `SORTORDER` - `STATUS` - `VERSION` - `SOURCETYPE` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## MDATASET **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/Dataset/DatasetQB.cs` **Columns (from INSERT INTO):** - `DATASETID` - `DATASETCODE` - `DATASETNAME` - `CRITERIACONFIGID` - `REMARKS` - `SORTORDER` - `STATUS` - `VERSION` - `SOURCETYPE` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## MDATASETDETAIL **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/Dataset/DatasetQB.cs` **Columns (from INSERT INTO):** - `DATASETDETAILID` - `DATASETID` - `SLNO` - `ENTITYID` - `ENTITYCRITERIACONFIGID` - `DBOBJECTID` --- ## MDATATYPE **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/DataType/DataTypeQB.cs` **Columns (from INSERT INTO):** - `DATATYPEID` - `DATATYPECODE` - `DATATYPENAME` - `DTTYPE` - `PARTICULARS` - `VARYINGSIZE` - `FIELDSIZE` - `BASETYPE` - `ACCEPTEDCHARS` - `NOTPERMITTEDCHARS` - `MASKEXPRESSION` - `ENUMERATION` - `SORTORDER` - `STATUS` - `VERSION` - `SOURCETYPE` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## MDATAVALIDATION **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/DataValidation/DataValidationQB.cs` **Columns (from INSERT INTO):** - `DATAVALIDATIONID` - `DATAVALIDATIONCODE` - `DATAVALIDATIONNAME` - `SECTION` - `MODULEID` - `DETAILS` - `QUERY` - `SOLUTION` - `SORTORDER` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## MDEFECT **Module:** MMDAL | **Source:** `GB5Solution/MM/MMDAL/Query/Defect/DefectQB.cs` **Columns (from INSERT INTO):** - `DEFECTID` - `DEFECTCODE` - `DEFECTNAME` - `POINTPERDEFECT` - `REMARKS` - `SORTORDER` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## MDEFERALPLAN **Module:** AccountsDAL | **Source:** `GB5Solution/Accounts/AccountsDAL/Query/DeferalPlan/DeferalPlanQB.cs` **Columns (from INSERT INTO):** - `DEFERALPLANID` - `DEFERALPLANCODE` - `DEFERALPLANNAME` - `REMARKS` - `DEFERALACCOUNTID` - `DEFERALPERCENT` - `PERIODTYPE` - `PERIODS` - `CALCULATIONMETHOD` - `STARTDATETYPE` - `PERIODREMARKSTEMPLATE` - `DAYS` - `MONTHS` - `SORTORDER` - `STATUS` - `VERSION` - `SOURCETYPE` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## MDELIVERY **Module:** MMDAL | **Source:** `GB5Solution/MM/MMDAL/Query/Delivery/DeliveryQB.cs` **Columns (from INSERT INTO):** - `DELIVERYID` - `TYPE` - `FROMCOUNTRYID` - `TOCOUNTRYID` - `FROMPORTID` - `TOPORTID` - `MODEOFDELIVERY` - `NOOFDAYS` - `SORTORDER` - `VERSION` - `STATUS` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `FROMCITYID` - `TOCITYID` --- ## MDEPARTMENT **Module:** AdminDAL | **Source:** `GB5Solution/Admin/AdminDAL/Query/Department/DepartmentQB.cs` **Columns (from INSERT INTO):** - `DEPARTMENTID` - `DEPARTMENTCODE` - `DEPARTMENTNAME` - `ISPRODUCTION` - `PROCESSID` - `CALENDARID` - `DEPARTMENTHEADID` - `APPLICABLEOUIDS` - `SORTORDER` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## MDEVELOPER **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/Developer/DeveloperQB.cs` **Columns (from INSERT INTO):** - `DEVELOPERNAME` - `ACCESSKEYID` - `SECRETKEY` - `DIGEST` - `SORTORDER` - `STATUS` - `VERSION` - `SOURCETYPE` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `ISENCRYPTIONREQUIRED` --- ## MDIVISION **Module:** AdminDAL | **Source:** `GB5Solution/Admin/AdminDAL/Query/Division/DivisionQB.cs` **Columns (from INSERT INTO):** - `DIVISIONID` - `DIVISIONCODE` - `DIVISIONNAME` - `DIVISIONSHORTNAME` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## MDOCUMENTMAP **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/DocumentMap/DocumentMapQB.cs` **Columns (from INSERT INTO):** - `ENTITYID` - `BIZTRANSACTIONCLASSID` - `BIZTRANSACTIONID` - `DOCUMENTSETID` - `SORTORDER` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `SOURCETYPE` --- ## MDOCUMENTSET **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/DocumentSet/DocumentSetQB.cs` **Columns (from INSERT INTO):** - `DOCUMENTSETID` - `DOCUMENTSETCODE` - `DOCUMENTSETNAME` - `REMARKS` - `TAGFIELDS` - `PROPERTYFIELDS` - `MODULEID` - `SORTORDER` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `SOURCETYPE` --- ## MDOCUMENTSETDETAIL **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/DocumentSet/DocumentSetQB.cs` **Columns (from INSERT INTO):** - `DOCUMENTSETDETAILID` - `DOCUMENTSETID` - `SLNO` - `DOCUMENTTYPEID` - `ISMANDATORY` - `ISMULTIPLE` - `DISPLAYNAMETEMPLATE` - `DOCUMENTNAMETEMPLATE` - `LOCATIONTEMPLATE` - `DEFAULTCLASSIFICATIONMARKID` --- ## MDRILLDOWN **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/DrillDown/DrillDownQB.cs` **Columns (from INSERT INTO):** - `DRILLDOWNID` - `DRILLDOWNCODE` - `DRILLDOWNDESCRIPTION` - `DRILLTYPE` - `FROMTYPE` - `FROMMENUID` - `FROMPORTLETID` - `TOTYPE` - `TOMENUID` - `TOPORTLETID` - `SORTORDER` - `VERSION` - `STATUS` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `FROMREPORTID` - `TOREPORTID` - `TOWEBFORMID` - `BIZTRANSACTIONTYPEFIELD` - `MODULEID` --- ## MDRILLDOWNDETAIL **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/DrillDown/DrillDownQB.cs` **Columns (from INSERT INTO):** - `DRILLDOWNDETAILLINEID` - `DRILLDOWNID` - `MAPTYPE` - `SLNO` - `ATTRIBUTEID` - `ASSIGNTYPE` - `SOURCEFIELD` - `FILTERVALUE` - `OPERATIONTYPE` - `JOINTYPE` --- ## MDUTYTABLE **Module:** MMDAL | **Source:** `GB5Solution/MM/MMDAL/Query/DutyTable/DutyTableQB.cs` **Columns (from INSERT INTO):** - `DUTYTABLECODE` - `DUTYTABLENAME` - `SORTORDER` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `SOURCETYPE` - `TENANTID` --- ## MDUTYTARIFF **Module:** MMDAL | **Source:** `GB5Solution/MM/MMDAL/Query/DutyTariff/DutyTariffQB.cs` **Columns (from INSERT INTO):** - `DUTYTARIFFCODE` - `DUTYTARIFFNAME` - `REMARKS` - `TARIFFTYPE` - `DUTYDRAWBACKID` - `SORTORDER` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `SOURCETYPE` - `TENANTID` --- ## MECMRIGHTS **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/ECMRights/ECMRightsQB.cs` **Columns (from INSERT INTO):** - `ECMRIGHTSID` - `USERTYPE` - `RIGHTSFORTYPE` - `USERID` - `USERGROUPID` - `ROLEID` - `SPACEID` - `DOCUMENTSETID` - `OBJECTTYPEID` - `SORTORDER` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `SOURCETYPE` - `TENANTID` --- ## MECMROLE **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/ECMRole/ECMRoleQB.cs` **Columns (from INSERT INTO):** - `ECMROLEID` - `ECMROLECODE` - `ECMROLENAME` - `REMARKS` - `OWNCONTENTRIGHTS` - `OTHERSCONTENTRIGHTS` - `SORTORDER` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `SOURCETYPE` - `TENANTID` --- ## MEIPACTIONREGISTRY **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/MessageHubService/TemplateApproval/TemplateApprovalQB.cs` **Columns (from INSERT INTO):** - `ACTIONID` - `ACTIONCODE` - `NAME` - `IMPLEMENTATIONCLASS` - `TENANTID` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDUTC` - `MODIFIEDBYID` - `MODIFIEDUTC` - `ACTIONNAME` - `ASSEMBLYNAME` - `CLASSNAME` --- ## MEIPCAPABILITY **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/MessageHubService/TemplateApproval/TemplateApprovalQB.cs` **Columns (from INSERT INTO):** - `CAPABILITYID` - `CAPABILITYCODE` - `DESCRIPTION` - `ISACTIVE` - `TENANTID` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDUTC` - `MODIFIEDBYID` - `MODIFIEDUTC` --- ## MEIPCAPABILITYACTIONMAP **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/MessageHubService/TemplateApproval/TemplateApprovalQB.cs` **Columns (from INSERT INTO):** - `MAPID` - `CAPABILITYID` - `ACTIONID` - `SEQUENCE` - `TENANTID` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDUTC` - `MODIFIEDBYID` - `MODIFIEDUTC` - `CAPABILITYCODE` - `ACTIONNAME` - `SEQUENCEORDER` --- ## MEIPCHANNELENDPOINT **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/MessageHubService/TemplateApproval/TemplateApprovalQB.cs` **Columns (from INSERT INTO):** - `TENANTID` - `CHANNELTYPE` - `PROVIDERNAME` --- ## MEIPFLOWDEFINITION **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/MessageHubService/TemplateApproval/TemplateApprovalQB.cs` **Columns (from INSERT INTO):** - `FLOWDEFINITIONID` - `TENANTID` - `FLOWCODE` - `FLOWVERSION` - `FLOWSTATUS` - `JSONDEFINITION` - `VERSION` - `STATUS` - `SORTORDER` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `SOURCETYPE` --- ## MEIPMESSAGETEMPLATE **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/MessageHubService/TemplateApproval/TemplateApprovalQB.cs` **Columns (from INSERT INTO):** - `TENANTID` - `MESSAGEKEY` - `LANGUAGECODE` - `CHANNEL` - `TEMPLATECONTENT` --- ## MEIPRESTACTIONCONFIG **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/MessageHubService/TemplateApproval/TemplateApprovalQB.cs` **Columns (from INSERT INTO):** --- ## MEIPROUTINGRULE **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/EIPConversation/EIPRouting/EIPRoutingQB.cs` **Columns (from INSERT INTO):** - `ROUTINGRULEID` - `TENANTID` - `CHANNELTYPE` - `FLOWID` - `PRIORITY` - `CONDITIONEXPRESSION` - `MATCHTYPE` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDUTC` - `MODIFIEDBYID` - `MODIFIEDUTC` --- ## MEIPTENANT **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/EIPConversation/EIPTenant/EIPTenantQB.cs` **Columns (from INSERT INTO):** - `TENANTID` - `TENANTNAME` - `STATUS` - `DEFAULTLANGUAGE` - `TIMEZONE` --- ## MEMPLOYEE **Module:** PayRollDAL | **Source:** `GB5Solution/PayRoll/PayRollDAL/Query/Employee/EmployeeQB.cs` **Columns (from INSERT INTO):** - `EMPLOYEEID` - `EMPLOYEECOMMONID` - `CODEDEFINEID` - `EMPLOYEECODE` - `EMPLOYEENAME` - `FATHERNAME` - `MOTHERNAME` - `SPOUSENAME` - `DEPARTMENTID` - `COSTCENTERTYPE` - `COSTCENTERID` - `COSTCENTERPATTERNID` - `WORKOUID` - `ISCROSSOU` - `OUGROUPID` - `PAYGROUPID` - `WORKTYPEID` - `EMPLOYEETYPEID` - `STAFFTYPEID` - `DESIGNATIONID` - `NATIONALITYID` - `RELIGIONID` - `LOCATIONID` - `CASTEID` - `HEIGHTINCMS` - `WEIGHTINKGS` - `CHESTSIZE` - `ISHANDICAPPED` - `IDENTIFICATIONMARK` - `PHYSICALCONDITION` - `EMPLOYEESTATUS` - `DATEOFBIRTH` - `ACTUALDATEOFBIRTH` - `DATEOFJOINING` - `ISCONFIRMED` - `DATEOFCONFIRMATION` - `DATEOFRESIGNATION` - `CALCULATEDDATEOFRETIREMENT` - `ACTUALDATEOFRETIREMENT` - `MARITALSTATUS` - `SEX` - `BLOODGROUP` - `ISPFAPPLICABLE` - `PFSTATUS` - `PFNUMBER` - `STATUTORYPFPERCENTAGE` - `EMPLOYEEPFPERCENTAGE` - `EMPLOYERPFPERCENTAGE` - `ISFAMILYPENSION` - `FAMILYPENSIONNUMBER` - `FAMILYPENSIONPERCENTAGE` - `PFJOINDATE` - `PFENDDATE` - `ISESIAPPLICABLE` - `ESISTATUS` - `ESINUMBER` - `ESIJOINDATE` - `ESIENDDATE` - `ESIDISPENSARY` - `EMPLOYEEESIPERCENTAGE` - `ISESIHOURLYCONTRIBUTION` - `BASICON` - `PAYMODE` - `OTPAYMODE` - `ISTDSAPPLICABLE` - `SALARYGRADEID` - `DAPOINTGROUPID` - `PANNUMBER` - `ACCOUNTNUMBER` - `SHIFTID` - `WEEKOFFDAY` - `ACCOUNTID` - `NOMINEE` - `NOMINEERELATION` - `ATTENDANCETYPE` - `ONSITEPLACE` - `ISDAILYREPORT` - `PUNCHTYPE` - `PRIMARYEMAILID` - `PRIMARYMOBILE` - `REPORTINGTOEMPLOYEEID` - `EXPERIENCE` - `ISTEMPORARYCARD` - `TEMPORARYCARDNUMBER` - `CARDVALIDTILL` - `ISNUMBERREQUIRED` - `BIOMATCHNUMBER` - `ADVANCEACCOUNTID` - `SALARYACCOUNTID` - `DEFAULTIMAGEID` - `ISCONTRACT` - `ISNUMBER` - `ISPURCHASE` - `ISMARKETING` - `ISSALES` - `ISPLANNING` - `ISSERVICE` - `ISUSER` - `VERSION` - `STATUS` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `SEGMENTID` - `UNITID` - `SHIFTPATTERNDETAILID` - `PATTERNDATE` - `REASONFORESILEAVING` - `REASONFORPFLEAVING` - `VILLAGEID` - `EMPLOYERESIPERCENTAGE` - `SOURCETYPE` - `SORTORDER` - `OTTYPE` - `CALENDARID` - `PROBATIONSTARTDATE` - `RESOURCETYPEID` - `ISPRODUCTION` - `ADHARNUMBER` - `PFUANNUMBER` - `PAYCONFIGURATIONID` - `PRODUCTCATEGORYIDS` - `PRODUCTPRICECATEGORYIDS` - `TENANTID` - `ISPIREQUIRED` - `GRATUITYGROUPID` - `CURRENCYID` - `ADMINREPORTINGTOID` - `FIRSTNAME` - `MIDDLENAME` - `LASTNAME` - `NOOFVERIFICATION` - `LOCATIONIDS` - `SECONDARYMAILID` - `SECONDARYMOBILE` - `IBANNUMBER` - `EMPLOYEEBANKBRANCHID` - `PRESENTADDRESSID` - `PERMANENTADDRESSID` - `CONTACTID` - `TRAININGPERIOD` - `TRAININGENDINGDATE` - `ISTIMESHEETREQUIRED` - `ISPOSTINGREQUIRED` - `DATEOFINTIMATION` - `REASONFORLEAVING` - `PLACEOFBIRTH` - `NATIVEPLACE` - `NATIVEDISTRICT` - `NOTICEPERIODINDAYS` - `DATEOFREJOIN` - `LEGACYEMPLOYEECODE` - `NATURE` - `VERSIONFROM` - `JOBPOSITIONID` - `CURRENTOUID` - `THUMBNAIL` - `VISAENTITYID` - `GRACEMINUTES` --- ## MEMPLOYEEEXPERIENCE **Module:** PayRollDAL | **Source:** `GB5Solution/PayRoll/PayRollDAL/Query/EmployeeExperience/EmployeeExperienceQB.cs` **Columns (from INSERT INTO):** - `EMPLOYEEEXPERIENCEID` - `EMPLOYEEID` - `SLNO` - `EMPLOYER` - `CITY` - `FROMMONTHYEAR` - `TOMONTHYEAR` - `NUMBEROFYEAR` - `DESIGNATION` - `SALARYDRAWN` - `REASONFORLEAVING` --- ## MEMPLOYEENOMINEE **Module:** PayRollDAL | **Source:** `GB5Solution/PayRoll/PayRollDAL/Query/EmployeeNominee/EmployeeNomineeQB.cs` **Columns (from INSERT INTO):** - `EMPLOYEENOMINEEID` - `EMPLOYEEID` - `NOMINEETYPE` - `SLNO` - `NOMINEENAME` - `RELATION` - `DOB` - `ADDRESS` - `PERCENTAGE` - `GUARDIAN` - `GUARDIANADDRESS` - `AADHARNUMBER` --- ## MEMPLOYEEQUALIFICATION **Module:** PayRollDAL | **Source:** `GB5Solution/PayRoll/PayRollDAL/Query/EmployeeQualification/EmployeeQualificationQB.cs` **Columns (from INSERT INTO):** - `EMPLOYEEQUALIFICATIONID` - `EMPLOYEEID` - `SLNO` - `COURSE` - `INSTITUTE` - `DURATION` - `FROMYEAR` - `TOYEAR` - `GRADE` - `REMARKS` --- ## MEMPLOYEEREFERENCE **Module:** PayRollDAL | **Source:** `GB5Solution/PayRoll/PayRollDAL/Query/EmployeeReference/EmployeeReferenceQB.cs` **Columns (from INSERT INTO):** - `EMPLOYEEREFERENCEID` - `EMPLOYEEID` - `SLNO` - `REFERENCE` - `REFERENCECOMPANY` - `DESIGNATION` - `RELATIONSHIP` - `TIMEKNOWN` - `ISVERIFIED` - `VERIFIEDBYID` - `VERIFIEDON` - `REMARKS` --- ## MEMPLOYEESKILL **Module:** SkillManagementDAL | **Source:** `GB5Solution/SkillManagement/SkillManagementDAL/Query/EmployeeSkillProfile/EmployeeSkillProfileQB.cs` **Columns (from INSERT INTO):** - `EMPLOYEESKILLID` - `EMPLOYEEID` - `SLNO` - `SKILLID` - `SKILLLEVEL` - `PARTICULARS` - `PROFILEID` - `PROFILENAME` - `PRODUCTFAMILYID` - `MODELID` - `CURRENTLEVNO` - `PROFILESTATUS` - `ASSESSEDDT` - `TRAININGPLANDATE` - `ACTUALTRAINDT` - `NEXTREVIEWDT` - `ASSESSEDBYID` - `REMARKS` - `VERSION` - `STATUS` - `SORTORDER` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `SOURCETYPE` - `TENANTID` --- ## MENTITYADDONSET **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/EntityAddOnSet/EntityAddOnSetQB.cs` **Columns (from INSERT INTO):** - `ENTITYID` - `PARAMETERSETID` --- ## MENTITYMEMBERS **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/EntityMember/EntityMemberQB.cs` **Columns (from INSERT INTO):** - `ENTITYMEMBERID` - `ENTITYID` - `SLNO` - `MEMBERNAME` - `DATATYPE` - `PARTICULARS` - `ISPERSIST` - `INPUTTYPE` - `ISPRIMARY` - `ISLOGICAL` - `ISCRITERIA` - `ISSELECTLIST` - `ISUSERIDENTIFYING` - `ISDATARESTRICTIONCRITERIA` - `SECTION` - `DBFIELDID` - `ISINDEXED` - `OBJECTTYPEID` - `ISVERSIONING` - `ISIDENTITY` - `ISSETREQUIRED` - `ISCHECK` - `ISFORMULAFORCODE` - `ISFORMULABASEDFIELD` - `CODEFORMULAID` - `ISCODEFIELD` - `ISCODECATEGORY` - `ISEXPANDREQ` - `ENUMVALUES` - `CRITERIAFIELDNAME` - `CRITERIAATTRIBUTEID` - `ISICEFIELD` - `SAMPLEDATA` - `ISUNIQUEKEY` - `ISCOMMENTREQUIRED` --- ## MENTITYRELATION **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/EntityRelation/EntityRelationQB.cs` **Columns (from INSERT INTO):** - `ENTITYID` - `RELATEDENTITYID` - `PARTICULARS` - `RELATIONTYPE` - `RELATIONNAME` - `DBFIELDID` --- ## MEVENTCHANNEL **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/EventChannel/EventChannelQB.cs` **Columns (from INSERT INTO):** - `EVENTCHANNELID` - `EVENTCHANNELCODE` - `EVENTCHANNELNAME` - `OWNERID` - `ADMINISTRATORID` - `SORTORDER` - `STATUS` - `VERSION` - `SOURCETYPE` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## MEVENTCLASS **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/EventClass/EventClassQB.cs` **Columns (from INSERT INTO):** - `EVENTCLASSID` - `EVENTCLASSCODE` - `EVENTCLASSNAME` - `COLOR` - `WEIGHT` - `EVENTTEXT` - `TAG` - `SOURCE` - `LINK` - `SORTORDER` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## MEVENTSOURCE **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/EventSource/EventSourceQB.cs` **Columns (from INSERT INTO):** - `EVENTSOURCEID` - `EVENTSOURCECODE` - `EVENTSOURCENAME` - `SORTORDER` - `STATUS` - `VERSION` - `SOURCETYPE` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## MEVENTTYPE **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/EventType/EventTypeQB.cs` **Columns (from INSERT INTO):** - `EVENTTYPEID` - `EVENTTYPECODE` - `EVENTTYPENAME` - `TYPE` - `EVENTTYPENATURE` - `SECURITYLEVEL` - `CRITICALITY` - `LINKEDFORMID` - `NOTIFICATION` - `ALERT` - `SECTION` - `ENTITYID` - `SORTORDER` - `STATUS` - `SOURCETYPE` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `EVENTCATEGORY` - `ISBIZDOMAIN` - `ISAUDIT` - `ISTELEMETRY` - `ISCOMPLIANCE` - `RETENTIONDAYS` - `STORAGETIER` --- ## MEVENTTYPEACTION **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/EventTypeAction/EventTypeActionQB.cs` **Columns (from INSERT INTO):** - `EVENTTYPEACTIONID` - `EVENTTYPEID` - `TRIGGERREPORTID` - `STATUS` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `TENANTID` - `NATURE` - `SORTORDER` - `SOURCETYPE` - `VERSION` - `MAILID` --- ## MEVENTTYPEACTIONDETAIL **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/EventRule/EventRuleQB.cs` **Columns (from INSERT INTO):** - `EVENTTYPEACTIONDETAILID` - `EVENTTYPEACTIONID` - `SLNO` - `ACTIONID` - `DESCRIPTION` - `ISACTIVE` - `ISDIRECTCALL` - `ISSCHEDULERCALL` - `EVALCONDITION` - `SOURCETYPE` --- ## MEXCHANGE **Module:** AdminDAL | **Source:** `GB5Solution/Admin/AdminDAL/Query/Exchange/ExchangeQB.cs` **Columns (from INSERT INTO):** - `EXCHANGEID` - `BASECURRENCYID` - `CURRENCYID` - `EXCHANGEDATE` - `CONVERSIONRATE` - `SORTORDER` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## MFIELDCOMPONENT **Module:** CMSDAL | **Source:** `GB5Solution/CMS/CMSDAL/Query/FieldComponent/FieldComponentQB.cs` **Columns (from INSERT INTO):** - `TENANTID` - `NAME` - `SLUG` - `DESCRIPTION` - `FIELDTYPE` - `ICON` - `CATEGORY` - `SCHEMAJSON` - `VALIDATIONRULES` - `DEFAULTVALUE` - `ISSTANDARD` - `USAGECOUNT` - `TAGS` - `COLORID` - `VISIBILITY` - `CONTENTTYPEID` - `FIELDNAME` - `REMARKS` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## MFILE **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/File/FileQB.cs` **Columns (from INSERT INTO):** - `FILEID` - `FILENAME` - `FILELOCATION` - `REMARKS` - `SORTORDER` - `STATUS` - `VERSION` - `SOURCETYPE` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `FILETYPE` - `REPORTID` - `WEBSERVICEID` - `TENANTID` - `ENTITYID` --- ## MFINANCEBOOK **Module:** AdminDAL | **Source:** `GB5Solution/Admin/AdminDAL/Query/FinanceBook/FinanceBookQB.cs` **Columns (from INSERT INTO):** - `FINANCEBOOKID` - `FINANCEBOOKNAME` - `PURPOSE` - `BOOKTYPE` - `BASEBOOKID` - `PERIODGROUP` - `OUID` - `FROMCURRENCYID` - `TOCURRENCYID` - `TRANSFERLEVEL` - `BALANCESHEETRATETYPE` - `PANDLRATETYPE` - `EQUITYRATETYPE` - `BIZTRANSACTIONID` - `DIFFERENCEACCOUNTID` - `STANDARDRATE` - `BOOKIDS` - `SORTORDER` - `STATUS` - `VERSION` - `SOURCETYPE` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `OUIDS` --- ## MFORMULA **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/Formula/FormulaQB.cs` **Columns (from INSERT INTO):** - `FORMULAID` - `FORMULACODE` - `FORMULANAME` - `FORMULATYPE` - `DATATYPE` - `DATASIZE` - `EXPRESSION` - `MODULEID` - `SECTION` - `PHASE` - `FUNCTIONNAME` - `SORTORDER` - `VERSION` - `STATUS` - `SOURCETYPE` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `PRINTINGNAME` - `REMARKS` - `ISRUNNINGTOTAL` - `ISPROCESSDURINGARREAR` --- ## MFORMULAFIELD **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/FormulaField/FormulaFieldQB.cs` **Columns (from INSERT INTO):** - `FORMULAFIELDID` - `FORMULAFIELDCODE` - `FORMULAFIELDNAME` - `MODULEID` - `SECTION` - `DATATYPE` - `DATASIZE` - `ADDEDTYPE` - `ENTITYID` - `SORTORDER` - `VERSION` - `STATUS` - `SOURCETYPE` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## MGBCONFIGUREDQUERY **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/GBQueryExecutor/GBQueryExecutorQB.cs` **Columns (from INSERT INTO):** - `CONFIGUREDQUERYID` - `QUERYCODE` - `QUERYNAME` - `SQLTEMPLATE` - `PARAMETERJSON` - `RESULTMAPPINGJSON` - `ISVALIDATED` - `INTENTPROFILEID` - `VERSION` - `STATUS` - `SORTORDER` - `SOURCETYPE` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `TENANTID` --- ## MGBPERIOD **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/GBPeriod/GBPeriodQB.cs` **Columns (from INSERT INTO):** - `GBPERIODID` - `GBPERIODCODE` - `GBPERIODNAME` - `GBPERIODFROMDATE` - `GBPERIODTODATE` - `PERIODTYPE` - `SORTORDER` - `STATUS` - `VERSION` - `SOURCETYPE` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## MGCM **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/GCM/GCMQB.cs` **Columns (from INSERT INTO):** - `GCMID` - `VERSION` - `GCMCODE` - `GCMNAME` - `COLORID` - `REMARKS` - `STATUS` - `SORTORDER` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `SOURCETYPE` - `GCMTYPEID` --- ## MGCMTYPE **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/GcmType/GcmTypeQB.cs` **Columns (from INSERT INTO):** - `GCMTYPEID` - `GCMTYPECODE` - `GCMTYPEDESCRIPTION` - `MODULEID` - `GCMCODEREQ` - `GCMCODESIZE` - `GCMENTRYTYPE` - `REMARKS` - `ISCOLORED` - `SORTORDER` - `VERSION` - `STATUS` - `SOURCETYPE` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## MGOPFLOW **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/GOP/GopFlowQB.cs` **Columns (from INSERT INTO):** - `GOPFLOWID` - `TENANTID` - `GOPFLOWCODE` - `GOPFLOWNAME` - `DESCRIPTION` - `STATUS` - `VERSION` - `SORTORDER` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## MGOPFLOWSNAPSHOT **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/GOP/GopFlowQB.cs` **Columns (from INSERT INTO):** - `GOPFLOWSNAPSHOTID` - `TENANTID` - `GOPFLOWID` - `SNAPSHOTVERSION` - `ENVIRONMENT` - `SPECAGGREGATEHASH` - `SNAPSHOTJSON` - `ISACTIVE` - `PUBLISHEDON` - `PUBLISHEDBYID` - `SORTORDER` - `STATUS` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## MGOPFLOWSNAPSHOTSTEP **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/GOP/GopFlowQB.cs` **Columns (from INSERT INTO):** - `GOPFLOWSNAPSHOTSTEPID` - `TENANTID` - `GOPFLOWSNAPSHOTID` - `SNAPSHOTVERSION` - `SLNO` - `NODEID` - `NODECODE` - `NODETYPE` - `LOGICALSERVICENAME` - `RESOLVEDENDPOINT` - `HTTPMETHOD` - `RELATIVEPATH` - `REQUESTSCHEMAJSON` - `RESPONSESCHEMAJSON` - `MAPPINGJSON` - `SPECHASH` - `TIMEOUTSECONDS` - `MAXRETRIES` - `SUPPORTSREMEDIATION` - `SORTORDER` - `STATUS` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## MGOPSOURCEBINDING **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/GOP/GopFlowQB.cs` **Columns (from INSERT INTO):** - `GOPSOURCEBINDINGID` - `TENANTID` - `SOURCETYPE` - `SOURCECODE` - `SOURCENAME` - `DESCRIPTION` - `GOPFLOWID` - `SNAPSHOTVERSION` - `ENVIRONMENT` - `ISACTIVE` - `SORTORDER` - `STATUS` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## MGOPTARGETOPERATION **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/GOP/GopTargetOperationQB.cs` **Columns (from INSERT INTO):** - `GOPTARGETOPERATIONID` - `OPERATIONCODE` - `OPERATIONNAME` - `BASEURL` - `RELATIVEPATH` - `HTTPMETHOD` - `REQUESTSCHEMAJSON` - `RESPONSESCHEMAJSON` - `SPECHASH` - `VERSION` - `STATUS` - `SORTORDER` - `SOURCETYPE` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `TENANTID` --- ## MGRADESTANDARD **Module:** MMDAL | **Source:** `GB5Solution/MM/MMDAL/Query/GradeStandard/GradeStandardQB.cs` **Columns (from INSERT INTO):** - `GRADEID` - `GRADESTANDARDCODE` - `GRADESTANDARDNAME` - `ISDEFAULT` - `REMARKS` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `SORTORDER` - `STATUS` - `VERSION` - `TENANTID` --- ## MGRADESTANDARDCATEGORY **Module:** MMDAL | **Source:** `GB5Solution/MM/MMDAL/Query/GradeStandardCategory/GradeStandardCategoryQB.cs` **Columns (from INSERT INTO):** - `GRADESTANDARDID` - `CATEGORYID` - `PARAMETERSETID` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `SORTORDER` - `STATUS` - `VERSION` - `TENANTID` --- ## MGSP_CONFIG **Module:** ComplianceDAL | **Source:** `GB5Solution/Compliance/ComplianceDAL/Query/GSPConfig/GSPConfigQB.cs` **Columns (from INSERT INTO):** - `GSPCONFIGID` - `GSPNAME` - `SOURCETYPE` - `ISACTIVE` - `CLIENTID` - `DATABASENAME` - `CREATEDBYID` - `CREATEDON` --- ## MGST_REGISTRATION **Module:** ComplianceDAL | **Source:** `GB5Solution/Compliance/ComplianceDAL/Query/GSTRegistration/GSTRegistrationQB.cs` **Columns (from INSERT INTO):** - `GSTREGISTRATIONID` - `GSTIN` - `LEGALNAME` - `TRADENAME` - `STATECODE` - `STATENAME` - `REGISTRATIONTYPE` - `OUID` - `OUNAME` - `ISACTIVE` - `CLIENTID` - `DATABASENAME` - `CREATEDBYID` - `CREATEDON` --- ## MICEMAP **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/IceMap/IceMapQB.cs` **Columns (from INSERT INTO):** - `ICEMAPID` - `ICEMAPCODE` - `ICEMAPNAME` - `ICESOURCETYPE` - `SOURCEFILENAME` - `MAPTOTYPE` - `ENTITYID` - `KEYFIELD` - `SOURCESHEETNAME` - `REMARKS` - `SOURCETYPE` - `SORTORDER` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `NOOFHEADERROWS` - `NOOFHEADERCOLUMN` - `MAPTYPE` - `TEMPLATEFILEID` --- ## MICEMAPDETAILS **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/IceMap/IceMapQB.cs` **Columns (from INSERT INTO):** - `MAPDETAILID` - `ICEMAPID` - `SLNO` - `VALUETYPE` - `SOURCEFIELDNAME` - `ISFILTERFIELD` - `DESTINATIONMEMBERID` - `ENTITYID` - `ADDONFIELDNAME` - `GCMTYPEID` - `ISOPTIONAL` - `OPTIONALFIELDVALUE` --- ## MINSPECTIONAREA **Module:** MMDAL | **Source:** `GB5Solution/MM/MMDAL/Query/InspectionArea/InspectionAreaQB.cs` **Columns (from INSERT INTO):** - `INSPECTIONAREAID` - `WORKCENTERID` - `INSPECTIONTYPE` - `INSPECTIONAREA` - `REMARKS` - `SORTORDER` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `SOURCETYPE` --- ## MINSPECTIONTYPE **Module:** MMDAL | **Source:** `GB5Solution/MM/MMDAL/Query/InspectionType/InspectionTypeQB.cs` **Columns (from INSERT INTO):** - `INSPECTIONTYPEID` - `INSPECTIONTYPECODE` - `INSPECTIONTYPENAME` - `DESCRIPTION` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## MINSPECTIONTYPEPARAMETERSET **Module:** MMDAL | **Source:** `GB5Solution/MM/MMDAL/Query/InspectionType/InspectionTypeQB.cs` **Columns (from INSERT INTO):** - `INSPECTIONTYPEPARAMETERSETID` - `INSPECTIONTYPEID` - `PARAMETERSETID` - `ISREQUIRED` - `SLNO` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## MINSTRUMENT **Module:** AccountsDAL | **Source:** `GB5Solution/Accounts/AccountsDAL/Query/Instrument/InstrumentQB.cs` **Columns (from INSERT INTO):** - `INSTRUMENTID` - `INSTRUMENTNAME` - `INSTRUMENTTYPE` - `ACCOUNTPOSTTYPE` - `POSTDATEDTYPE` - `VALIDITYPERIODINDAYS` - `INSTRUMENTSTATUS` - `ISAPPLICABLEFORBANK` - `ISAPPLICABLEFORCOUNTERTRANSACTION` - `ACCOUNTID` - `SORTORDER` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `OUIDS` - `OUGROUPIDS` - `TENANTID` --- ## MINSURANCE **Module:** AccountsDAL | **Source:** `GB5Solution/Accounts/AccountsDAL/Query/Insurance/InsuranceQB.cs` **Columns (from INSERT INTO):** - `INSURANCEID` - `OUTYPE` - `OUGROUPID` - `OUID` - `INSURANCETYPE` - `POLICYNUMBER` - `VEHICLEID` - `PARTYID` - `STARTDATE` - `ENDDATE` - `COVERAGEAMOUNT` - `PREMIUMAMOUNT` - `PERIODTYPE` - `LASTPAIDON` - `LASTPAIDTILL` - `PREMIUMDUEON` - `REMARKS` - `SORTORDER` - `INSURANCESTATUS` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `ASSETID` - `EMPLOYEEID` - `MACHINEID` --- ## MITEM **Module:** MMDAL | **Source:** `GB5Solution/MM/MMDAL/Query/Item/ItemQB.cs` **Columns (from INSERT INTO):** - `ITEMID` - `ITEMCODE` - `ITEMNAME` - `ITEMSHORTNAME` - `ITEMDESCRIPTION` - `CODECATEGORYID` - `CATEGORYID` - `SUBCATEGORYID` - `ITEMGROUPID` - `ITEMBRANDID` - `MODELID` - `PRICECATEGORYID` - `MATERIALGROUPID` - `PROCESSGROUPID` - `MATERIALACCOUNTID` - `ISSALEABLEITEM` - `ISACTIVITY` - `INTRODUCEDDATE` - `ITEMORTEMPLATE` - `DRAWINGNUMBER` - `CATALOGUENUMBER` - `PARAMETERSETID` - `ISITEMREVISED` - `ITEMREVISEDFROM` - `ITEMREVISEDTO` - `ISTRANSACTABLE` - `ISPURCHASABLE` - `ISINTERNALORDER` - `ISBUYBACK` - `ISVARIABLESIZEITEM` - `ISSPARE` - `ISBUYWITHOUTORDER` - `BOMTYPE` - `ISSTOCKPOSTING` - `ISBATCHSTOCK` - `ISUNIQUEBATCH` - `STOCKVALUATIONTYPE` - `TOLLERANCETYPE` - `TOLLERANCEVALUE` - `ISSKUTRACKINGAPPLICABLE` - `DEFAULTSKUID` - `ISSTYLEAPPLICABLE` - `ISCOLORAPPLICABLE` - `ISSIZEAPPLICABLE` - `ISPROCESSAPPLICABLE` - `ISMAKEAPPLICABLE` - `ISPRICEPOINTAPPLICABLE` - `ISGRADEAPPLICABLE` - `ISSEASONAPPLICABLE` - `PURCHASEUOMID` - `STOCKUOMID` - `CONVERSIONFACTOR` - `UOMSETID` - `ISPACKINGSDETAILSREQUIRED` - `PACKSETID` - `DEFAULTPACKID` - `CASECOUNT` - `INSPECTIONTYPE` - `QUALITYPARAMETERSETID` - `ISEXPIRYTRACKINGREQUIRED` - `LIFEINDAYS` - `RATETYPE` - `PRICEFORTYPE` - `LINKITEMID` - `LINKVARIATION` - `PRICINGREFERENCENUMBER` - `ISDISCOUNTAPPLICABLE` - `MAXIMUMDISCOUNTPERCENTAGE` - `ISFREEAPPLICABLE` - `MRPRATE` - `ISSERVICEAPPLICABLE` - `ISWARRANTYAPPLICABLE` - `WARRANTYPERIOD` - `ISPOSTTOCUSTOMERPRODUCT` - `ISINSTALLATIONTRACKINGREQUIRED` - `ISDEFECTIVETOBERETURNED` - `HEIGHT` - `WEIGHT` - `LENGTH` - `BREATH` - `THICKNESS` - `ISDUTYAPPLICABLE` - `ISCENVATAPPLICABLE` - `DUTYTABLEID` - `TAXTABLEID` - `ISTAXTYPECHANGEABLE` - `VATCLAIMTYPE` - `MASTERPLANMETHOD` - `MRPPLANMETHOD` - `LEADTIME` - `REVIEWPERIOD` - `MINIMUMORDERQUANTITY` - `MINLEVEL` - `MAXLEVEL` - `LOTSIZE` - `ROUTINGID` - `ISEXCISEAPPLICABLE` - `PURCHASERATE` - `PURCHASERATEINCLUSIVE` - `PURCHASECOSTNLC` - `SALESRATE` - `SALESRATEINCLUSIVE` - `PLANNERID` - `PROCUREMENTINCHARGEID` - `PRODUCTIONNATURE` - `ISMAKEORBUY` - `ISMANUFACTURABLE` - `ISBULKISSUEITEM` - `SHRINKAGEPERCENTAGE` - `COMPONENTYIELD` - `PREPROCESSINGLEADTIME` - `PROCESSINGLEADTIME` - `POSTPROCESSINGLEADTIME` - `LEADTIMELOTSIZE` - `FIXEDLEADTIME` - `VARIABLELEADTIME` - `VARIABLEQUANTITY` - `MANUFACTURINGLEADTIME` - `LEADTIMEOFFSET` - `BOMYIELDPERCENTAGE` - `SAFETYSTOCKMETHOD` - `SAFETYDAYS` - `MRPPLANNEDPERCENTAGE` - `LOTMETHOD` - `INVENTORYMETHOD` - `LOWESTLEVELINBOM` - `ISBINTRACKINGREQUIRED` - `DUTYTARIFFID` - `SORTORDER` - `VERSION` - `STATUS` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `DEFAULTCMSID` - `VATCOMMODITYID` - `RAWMATERIALITEMID` - `RAWMATERIALSKUID` - `RAWMATERIALQUANTITY` - `NESTINGPLANID` - `SOURCETYPE` - `PURCHASECURRENCYID` - `LASTPURCHASECURRENCYID` - `LASTPURCHASERATE` - `ITEMTYPEID` - `DUTYFORMTYPEID` - `PLANNINGGROUPID` - `ISASSET` - `ASSETTYPEID` - `ASSETLINKTYPE` - `ASSETBATCHLINKTYPE` - `ASSETID` - `GSTTYPE` - `GSTTARIFFID` - `ITCTYPE` - `GSTTABLEID` - `TENANTID` - `SIZESETDETAILID` - `COLORID` - `BOMTOLLERANCEVALUE` - `CALLSETID` - `SAMPLESPERCENTAGE` - `QUALITYPLANREFERENCENO` - `DEFAULTBOMID` - `CYCLECLASSID` - `RESERVATIONTYPE` - `ACTIVITYID` - `ISEWTYPE` - `EWCATEGORYID` - `EWPRICEFROM` - `EWPRICETO` - `COMPREHENSIVEMONTHS` - `NONCOMPREHENSIVEMONTHS` - `EWVENDORID` - `MAXMONTHS` - `ISEWOWN` - `ISPREPAID` - `NOOFPERIODS` - `DEFERALPLANID` - `SIZESETID` - `MEASURETYPEID` - `SKUSETTINGID` - `SUPPLYGROUPID` - `REVISEDFROMITEMID` - `REVISIONNUMBER` - `THUMBNAIL` - `DRAWINGREVISIONNUMBER` - `SHAPEID` - `MATERIALID` - `DISPLAYD1` - `DISPLAYD2` - `DISPLAYD3` - `DISPLAYD4` - `DISPLAYD5` - `D1DISPLAYUNITID` - `D2DISPLAYUNITID` - `D3DISPLAYUNITID` - `D4DISPLAYUNITID` - `D5DISPLAYUNITID` - `STANDARDLENGTHBASE` - `WEIGHTPERMETER` - `VOLUMEPERMETER` --- ## MITEMCATEGORY **Module:** MMDAL | **Source:** `GB5Solution/MM/MMDAL/Query/ItemCategory/ItemCategoryQB.cs` **Columns (from INSERT INTO):** - `ITEMCATEGORYID` - `ITEMCATEGORYCODE` - `ITEMCATEGORYNAME` - `ISSELECTED` - `REMARKS` - `SORTORDER` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `SOURCETYPE` - `ISASSET` - `ISITEM` - `TENANTID` --- ## MITEMFEATURE **Module:** MMDAL | **Source:** `GB5Solution/MM/MMDAL/Query/ItemFeature/ItemFeatureQB.cs` **Columns (from INSERT INTO):** - `ITEMFEATUREID` - `ITEMID` - `SLNO` - `FEATUREDESCRIPTION` - `TENANTID` --- ## MITEMGROUP **Module:** MMDAL | **Source:** `GB5Solution/MM/MMDAL/Query/ItemGroup/ItemGroupQB.cs` **Columns (from INSERT INTO):** - `ITEMGROUPID` - `ITEMGROUPCODE` - `ITEMGROUPNAME` - `LEVELS` - `ISSELECTED` - `REMARKS` - `PARENTGROUPID` - `SORTORDER` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `SOURCETYPE` - `TENANTID` --- ## MITEMSTOCK **Module:** MMDAL | **Source:** `GB5Solution/MM/MMDAL/Query/ItemStock/ItemStockQB.cs` **Columns (from INSERT INTO):** - `ITEMSTOCKID` - `STOREID` - `ITEMID` - `ISCRITICAL` - `STOCKONHAND` - `ROL` - `UOMID` - `SKUID` - `BINNUMBER` - `MODIFIEDON` - `CYCLECLASSID` - `BINID` --- ## MITEMSUBCATEGORY **Module:** MMDAL | **Source:** `GB5Solution/MM/MMDAL/Query/ItemSubCategory/ItemSubCategoryQB.cs` **Columns (from INSERT INTO):** - `ITEMSUBCATEGORYID` - `ITEMSUBCATEGORYCODE` - `ITEMSUBCATEGORYNAME` - `ITEMCATEGORYID` - `ISSELECTED` - `REMARKS` - `SORTORDER` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `ISASSET` - `ISITEM` --- ## MITEMTEMPLATEPART **Module:** MMDAL | **Source:** `GB5Solution/MM/MMDAL/Query/ItemTemplatePart/ItemTemplatePartQB.cs` **Columns (from INSERT INTO):** - `ITEMTEMPLATEPARTID` - `ITEMTEMPLATEPARTCODE` - `ITEMTEMPLATEPARTNAME` - `ITEMTEMPLATEPARTTYPE` - `PARENTPARTID` - `PARAMETERSETID` - `PARTDESCRIPTION` - `UOMID` - `ITEMLINKTYPE` - `LINKITEMID` - `CALCULATIONMETHOD` - `SORTORDER` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## MJOBDEFINE **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/AutoScheduler/AutoSchedulerQB.cs` **Columns (from INSERT INTO):** - `JOBID` - `JOBNAME` - `SCHEDULERID` - `WEBSERVICEID` - `CRITERIACONFIGID` - `STATUS` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `MENUID` --- ## MJOBOFFER **Module:** RecruitmentDAL | **Source:** `GB5Solution/Recruitment/RecruitmentDAL/Query/JobOffer/JobOfferQB.cs` **Columns (from INSERT INTO):** - `JOBOFFERID` - `APPLICANTID` - `JOBPOSITIONID` - `DEPARTMENTID` - `LOCATIONID` - `EXPECTEDJOININGDATE` - `OFFEREXPIRYDATE` - `CTC` - `EMPLOYEEMENTTYPE` - `PROBATIONPERIOD` - `ISORDERGENERATED` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `SORTORDER` - `STATUS` - `VERSION` - `SOURCETYPE` - `TENANTID` --- ## MJOBPOSITION **Module:** RecruitmentDAL | **Source:** `GB5Solution/Recruitment/RecruitmentDAL/Query/JobPosition/JobPositionQB.cs` **Columns (from INSERT INTO):** - `POSITIONTITLE` - `JOBTYPEID` - `DEPARTMENTID` - `LEVELID` - `EXPERIENCE` - `OVERVIEW` - `KEYRESPONSIBILITIES` - `REQUIREDQUALIFICATION` - `TECHSKILLS` - `EDUREQUIREMENTS` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `SORTORDER` - `STATUS` - `VERSION` - `TENANTID` --- ## MJOBPROFILE **Module:** RecruitmentDAL | **Source:** `GB5Solution/Recruitment/RecruitmentDAL/Query/JobProfile/JobProfileQB.cs` **Columns (from INSERT INTO):** - `JOBPROFILEID` - `JOBPROFILENAME` - `JOBPROFILETYPE` - `DEPARTMENTID` - `DESIGNATIONID` - `REPORTINGTODESIGNATIONID` - `JOBID` - `EMPLOYEEID` - `REPORTINGTOID` - `FROMDATE` - `TODATE` - `SUMMARY` - `REMARKS` - `EXPERIENCE` - `QUALIFICATION` - `SORTORDER` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `SOURCETYPE` --- ## MJOBPROFILEDETAIL **Module:** RecruitmentDAL | **Source:** `GB5Solution/Recruitment/RecruitmentDAL/Query/JobProfile/JobProfileQB.cs` **Columns (from INSERT INTO):** - `JOBPROFILEDETAILID` - `JOBPROFILEID` - `DETAILTYPE` - `SLNO` - `DOMAINID` - `SECTIONID` - `OBJECTIVEID` - `KRAID` - `PARTICULARS` - `SKILLID` - `LEVELID` --- ## MJOBROLESKILL **Module:** SkillManagementDAL | **Source:** `GB5Solution/SkillManagement/SkillManagementDAL/Query/RoleSkillRequirement/RoleSkillRequirementQB.cs` **Columns (from INSERT INTO):** - `REQID` - `ROLEID` - `ROLECODE` - `ROLENAME` - `SKILLID` - `SLNO` - `MINLEVNO` - `ISMANDATORY` - `CATEGORY` - `REMARKS` --- ## MKEYCOMPONENT **Module:** MaintenanceDAL | **Source:** `GB5Solution/Maintenance/MaintenanceDAL/Query/KeyComponent/KeyComponentQB.cs` **Columns (from INSERT INTO):** - `KEYCOMPONENTID` - `NATURE` - `ASSETID` - `RESOURCEID` - `MACHINEID` - `ITEMID` - `LOTID` - `REMARKS` - `SORTORDER` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `SOURCETYPE` - `TENANTID` --- ## MKEYCOMPONENTDETAIL **Module:** MaintenanceDAL | **Source:** `GB5Solution/Maintenance/MaintenanceDAL/Query/KeyComponent/KeyComponentQB.cs` **Columns (from INSERT INTO):** - `KEYCOMPONENTDETAILID` - `KEYCOMPONENTID` - `SLNO` - `NATURE` - `ASSETID` - `RESOURCEID` - `MACHINEID` - `ITEMID` - `DETAILSLNO` - `QUANTITY` - `REPLACEDON` - `LOTID` - `REMARKS` --- ## MKMARTIFACT **Module:** KmsDAL | **Source:** `GB5Solution/KMS/KmsDAL/Query/KmArtifact/KmArtifactQB.cs` **Columns (from INSERT INTO):** - `ARTIFACTID` - `DOMAINID` - `ARTIFACTCODE` - `TITLE` - `SUMMARY` - `ARTIFACTTYPE` - `SOURCEKIND` - `GOVERNANCESTATE` - `SCOPELEVEL` - `SCOPEVALUE` - `VERSIONNUMBER` - `PARENTARTIFACTID` - `OWNERUSERID` - `REVIEWERUSERID` - `CONFIDENCESCORE` - `EFFECTIVEFROM` - `EFFECTIVETO` - `SOURCEREFERENCE` - `SOURCEMETADATA` - `EXTRACTIONJOBID` - `TAGS` - `VERSION` - `STATUS` - `SORTORDER` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `SOURCETYPE` - `TENANTID` --- ## MKMARTIFACTCONTENT **Module:** KmsDAL | **Source:** `GB5Solution/KMS/KmsDAL/Query/KmContent/KmContentQB.cs` **Columns (from INSERT INTO):** - `CONTENTID` - `ARTIFACTID` - `SLNO` - `CONTENTBODY` - `CONTENTTYPE` - `LANGUAGECODE` - `ISPRIMARY` - `CHUNKINDEX` - `CHUNKTOTAL` - `CREATEDON` --- ## MKMARTIFACTVERSION **Module:** KmsDAL | **Source:** `GB5Solution/KMS/KmsDAL/Query/KmGovernance/KmGovernanceQB.cs` **Columns (from INSERT INTO):** - `ARTIFACTID` - `VERSIONNUMBER` - `SNAPSHOTJSON` - `GOVERNANCESTATE` - `CHANGESUMMARY` - `CREATEDBYID` - `CREATEDON` --- ## MKMDOMAIN **Module:** KmsDAL | **Source:** `GB5Solution/KMS/KmsDAL/Query/KmDomain/KmDomainQB.cs` **Columns (from INSERT INTO):** - `DOMAINID` - `SPACEID` - `DOMAINCODE` - `DOMAINNAME` - `DESCRIPTION` - `VERSION` - `STATUS` - `SORTORDER` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `SOURCETYPE` - `TENANTID` --- ## MKMSPACE **Module:** KmsDAL | **Source:** `GB5Solution/KMS/KmsDAL/Query/KmSpace/KmSpaceQB.cs` **Columns (from INSERT INTO):** - `SPACEID` - `SPACECODE` - `SPACENAME` - `DESCRIPTION` - `VERSION` - `STATUS` - `SORTORDER` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `SOURCETYPE` - `TENANTID` --- ## MLEADSOURCE **Module:** MarketingDAL | **Source:** `GB5Solution/Marketing/MarketingDAL/Query/LeadSource/LeadSourceQB.cs` **Columns (from INSERT INTO):** - `LEADSOURCEID` - `LEADSOURCECODE` - `LEADSOURCENAME` - `LEADSOURCETYPEID` - `REMARKS` - `SORTORDER` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `SOURCETYPE` - `TENANTID` --- ## MLEADSOURCEDETAIL **Module:** MarketingDAL | **Source:** `GB5Solution/Marketing/MarketingDAL/Query/LeadSource/LeadSourceQB.cs` **Columns (from INSERT INTO):** - `LEADSOURCEDETAILID` - `LEADSOURCEID` - `SLNO` - `DETAIL` - `REMARKS` - `ISACTIVE` --- ## MLEAVE **Module:** PayRollDAL | **Source:** `GB5Solution/PayRoll/PayRollDAL/Query/Leave/LeaveQB.cs` **Columns (from INSERT INTO):** - `LEAVEID` - `LEAVECODE` - `LEAVENAME` - `ISENCASHABLE` - `ISBALANCEMAINTAINED` - `ISCARRIEDOVER` - `CREDITMETHOD` - `LEAVETYPE` - `LEAVESALARYPERCENT` - `INCLUDEHOLIDAY` - `SURROUNDINGDAY` - `SORTORDER` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `SOURCETYPE` - `TENANTID` - `LEAVECREDITFORMULAID` - `ISAPPLICABLEFORLEAVEAPPLICATION` - `LEAVESALARYFORMULAID` - `DISPLAYCODE` - `ISTRACKINGREQUIRED` - `LTALEAVEIDS` - `VALIDPERIOD` --- ## MLOCATION **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/Location/LocationQB.cs` **Columns (from INSERT INTO):** - `LOCATIONID` - `LOCATIONCODE` - `LOCATIONNAME` - `REMARKS` - `SORTORDER` - `STATUS` - `VERSION` - `SOURCETYPE` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `CALENDARID` - `GEOLOCATION` - `BORDER` - `GEOCODE` - `GEODATATYPE` - `SHAPETYPE` - `RADIUS` - `BOUNDS` - `COORDINATES` --- ## MLOTTYPE **Module:** MMDAL | **Source:** `GB5Solution/MM/MMDAL/Query/LotType/LotTypeQB.cs` **Columns (from INSERT INTO):** - `LOTTYPEID` - `OUID` - `LOTTYPE` - `LOTNUMBERINGTYPE` - `PROCESSID` - `ITEMID` - `SKUID` - `LOTNUMBERSIZE` - `PREFIX` - `SUFFIX` - `FROMNUMBER` - `REMARKS` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `LOTTYPENAME` --- ## MLOV **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/Lov/LovQB.cs` **Columns (from INSERT INTO):** - `LOVID` - `LOVCODE` - `LOVNAME` - `LOVTYPEID` - `SCORE` - `SORTORDER` - `STATUS` - `VERSION` - `PARENTID` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## MLOVTYPE **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/LovType/LovTypeQB.cs` **Columns (from INSERT INTO):** - `LOVTYPEID` - `LOVTYPECODE` - `LOVTYPENAME` - `SORTORDER` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `SCOREREQUIRED` - `LOVNATURE` - `GENERATIONTYPE` - `PARENTLOVTYPEID` --- ## MLOYALTYEARNCFG **Module:** PAYDAL | **Source:** `GB5Solution/PAY/PAYDAL/Query/Loyalty/LoyaltyEarnCfgQB.cs` **Columns (from INSERT INTO):** - `LOYALTYEARNCFGID` - `LOYALTYPROGRAMID` - `RULENAME` - `RULETYPE` - `REFERENCEID` - `EARNPOINTS` - `VALIDFROM` - `VALIDTO` - `REMARKS` - `VERSION` - `STATUS` - `SORTORDER` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `SOURCETYPE` - `TENANTID` --- ## MLOYALTYPROGRAM **Module:** PAYDAL | **Source:** `GB5Solution/PAY/PAYDAL/Query/Loyalty/LoyaltyProgramQB.cs` **Columns (from INSERT INTO):** - `LOYALTYPROGRAMID` - `PROGRAMCODE` - `PROGRAMNAME` - `PROGRAMTYPE` - `POINTSNAME` - `POINTSEXPIREDAYS` - `MINREDEEMPOINTS` - `POINTSTOCURRENCY` - `CURRENCYTOPOINTS` - `ALLOWTIERING` - `REMARKS` - `VERSION` - `STATUS` - `SORTORDER` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `SOURCETYPE` - `TENANTID` --- ## MLOYALTYTIER **Module:** PAYDAL | **Source:** `GB5Solution/PAY/PAYDAL/Query/Loyalty/LoyaltyTierQB.cs` **Columns (from INSERT INTO):** - `LOYALTYTIERID` - `LOYALTYPROGRAMID` - `SLNO` - `TIERCODE` - `TIERNAME` - `MINPOINTS` - `MAXPOINTS` - `EARNMULTIPLIER` - `REMARKS` --- ## MMACHINE **Module:** MMDAL | **Source:** `GB5Solution/MM/MMDAL/Query/Machine/MachineQB.cs` **Columns (from INSERT INTO):** - `MACHINEID` - `MACHINECODE` - `MACHINENAME` - `MACHINETYPEID` - `CATEGORYID` - `SUBCATEGORYID` - `MODELID` - `BRANDID` - `YOM` - `CAPACITY` - `CAPACITYUOMID` - `MINCAPACITY` - `MAXCAPACITY` - `SPEED` - `LOTPERDAY` - `ITEMLINKTYPE` - `ITEMID` - `BATCHID` - `ISCRITICAL` - `SERVICESTATUS` - `SERVICEFROMDATE` - `SERVICETODATE` - `SERVICEPROVIDERID` - `SUPPLIERID` - `BILLNUMBER` - `BILLDATE` - `VALUEINBILL` - `PURCHASEDATE` - `INSTALLATIONDATE` - `MACHINESTATUS` - `MACHINEVALUE` - `MFRSLNO` - `WORKCENTERID` - `PROCESSID` - `LASTNUMBER` - `EFFICIENCY` - `SORTORDER` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `OUID` - `THUMBNAIL` --- ## MMACHINETYPE **Module:** MMDAL | **Source:** `GB5Solution/MM/MMDAL/Query/MachineType/MachineTypeQB.cs` **Columns (from INSERT INTO):** - `MACHINETYPEID` - `MACHINETYPECODE` - `MACHINETYPENAME` - `NATURE` - `PARAMETERSETID` - `RESOURCETYPEID` - `SORTORDER` - `STANDARDPRODUCTIONFACTOR` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## MMAILLIST **Module:** AdminDAL | **Source:** `GB5Solution/Admin/AdminDAL/Query/MailList/MailListQB.cs` **Columns (from INSERT INTO):** - `LISTID` - `LISTNAME` - `PARTICULARS` - `TYPE` - `PICKLISTID` - `WEBSERVICEID` - `MAILIDS` - `SORTORDER` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `SOURCETYPE` - `URIPARAMETERVALUE` --- ## MMAILTEMPLATE **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/MailTemplate/MailTemplateQB.cs` **Columns (from INSERT INTO):** - `MAILTEMPLATEID` - `MAILTEMPLATECODE` - `MAILTEMPLATENAME` - `MAILTEMPLATETYPE` - `ATTACHMENTFILEID` - `BODYFILEID` - `EVENTTYPEID` - `SUBJECT` - `BODY` - `REMARKS` - `SORTORDER` - `STATUS` - `VERSION` - `SOURCETYPE` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## MMAPPINGDEFINITION **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/GOP/MappingQB.cs` **Columns (from INSERT INTO):** - `MAPPINGDEFINITIONID` - `TENANTID` - `MAPPERCODE` - `MAPPERNAME` - `SOURCESCHEMA` - `TARGETSCHEMA` - `ISACTIVE` - `DESCRIPTION` - `SORTORDER` - `STATUS` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## MMAPPINGNODE **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/GOP/MappingQB.cs` **Columns (from INSERT INTO):** - `MAPPINGNODEID` - `MAPPINGVERSIONID` - `TENANTID` - `SOURCEPATH` - `TARGETPATH` - `TRANSFORMEXPRESSION` - `EXECUTIONORDER` - `ISREQUIRED` - `SORTORDER` - `STATUS` --- ## MMAPPINGVERSION **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/GOP/MappingQB.cs` **Columns (from INSERT INTO):** - `MAPPINGVERSIONID` - `MAPPINGDEFINITIONID` - `TENANTID` - `VERSIONLABEL` - `VERSIONSTATUS` - `SNAPSHOTJSON` - `ACTIVATEDON` - `SORTORDER` - `STATUS` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## MMASTERSCHEDULE **Module:** MMDAL | **Source:** `GB5Solution/MM/MMDAL/Query/MasterSchedule/MasterScheduleQB.cs` **Columns (from INSERT INTO):** - `MASTERSCHEDULEID` - `MASTERSCHEDULECODE` - `MASTERSCHEDULENAME` - `ORGANIZATIONTYPE` - `OUID` - `OUGROUPID` - `ISINCLUDEINATP` - `ISTRACKCONVERSION` - `ISAUTORELEASE` - `ISPENDING` - `DEMANDTYPE` - `VALIDTILLDATE` - `SORTORDER` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `TENANTID` --- ## MMASTERSCHEDULEDETAIL **Module:** MMDAL | **Source:** `GB5Solution/MM/MMDAL/Query/MasterSchedule/MasterScheduleQB.cs` **Columns (from INSERT INTO):** - `MASTERSCHEDULEDETAILID` - `MASTERSCHEDULEID` - `SLNO` - `ITEMID` - `SKUID` - `SOURCETYPE` - `SOURCEOBJECTTYPEID` - `SOURCEOBJECTID` - `DATEFROM` - `DATETO` - `DAYS` - `DAILYQUANTITY` - `TOTALQUANTITY` - `PLANNEDQUANTITY` - `BALANCEQUANTITY` - `PARTYID` - `ALLOCATIONID` - `TASKID` - `REMARKS` - `RELIEF` - `REFERENCENUMBER` - `REFERENCEDATE` - `MRPRUNID` - `POSTEDMRPRUNID` - `PRIORITY` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `TENANTID` --- ## MMATERIAL **Module:** MMDAL | **Source:** `GB5Solution/MM/MMDAL/Query/Material/MaterialQB.cs` **Columns (from INSERT INTO):** - `MATERIALCODE` - `MATERIALNAME` - `NATURE` - `DENSITY` - `SPECIFICGRAVITY` - `SORTORDER` - `STATUS` - `VERSION` - `SOURCETYPE` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## MMATERIALACCOUNT **Module:** MMDAL | **Source:** `GB5Solution/MM/MMDAL/Query/MaterialAccount/MaterialAccountQB.cs` **Columns (from INSERT INTO):** - `MATERIALACCOUNTID` - `MATERIALACCOUNTCODE` - `MATERIALACCOUNTNAME` - `ISTRANSACTIONTYPEBASED` - `STOCKACCOUNTID` - `CONSUMPTIONACCOUNTID` - `COSTOFGOODSACCOUNTID` - `WIPACCOUNTID` - `WIPSTOCKACCOUNTID` - `COGMACCOUNTID` - `COSTCENTERID` - `SORTORDER` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `SOURCETYPE` - `TENANTID` --- ## MMATERIALACCOUNTDETAIL **Module:** MMDAL | **Source:** `GB5Solution/MM/MMDAL/Query/MaterialAccount/MaterialAccountQB.cs` **Columns (from INSERT INTO):** - `MATERIALACCOUNTDETAILID` - `MATERIALACCOUNTID` - `SLNO` - `TRANSACTIONTYPEID` - `SALESACCOUNTID` - `SALESRETURNACCOUNTID` - `PURCHASEACCOUNTID` - `PURCHASERETURNACCOUNTID` - `COSTCENTERID` --- ## MMATERIALGRADE **Module:** MMDAL | **Source:** `GB5Solution/MM/MMDAL/Query/MaterialGrade/MaterialGradeQB.cs` **Columns (from INSERT INTO):** - `MATERIALGRADEID` - `MATERIALGRADECODE` - `MATERIALGRADENAME` - `REMARKS` - `MATERIALGROUPID` - `ITEMID` - `SORTORDER` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `SOURCETYPE` --- ## MMEASURETYPE **Module:** MMDAL | **Source:** `GB5Solution/MM/MMDAL/Query/MeasureType/MeasureTypeQB.cs` **Columns (from INSERT INTO):** - `MEASURETYPECODE` - `MEASURETYPENAME` - `NOOFMEASURE` - `D1NAME` - `D2NAME` - `D3NAME` - `D4NAME` - `D5NAME` - `EXPRESSION` - `UOMID` - `SORTORDER` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `SOURCETYPE` - `TENANTID` --- ## MMEASUREUNIT **Module:** MMDAL | **Source:** `GB5Solution/MM/MMDAL/Query/MeasureUnit/MeasureUnitQB.cs` **Columns (from INSERT INTO):** - `MEASUREUNITID` - `UNITNAME` - `UNITTYPE` - `MULTIPLIERTOBASE` - `SORTORDER` - `STATUS` - `VERSION` - `SOURCETYPE` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## MMERGE **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/Merge/MergeQB.cs` **Columns (from INSERT INTO):** - `MERGEID` - `MERGECODE` - `MERGENAME` - `MODULEID` - `ISCONSTRAINTBASED` - `DATATYPE` - `LENGTH` - `PREC` - `SCALE` - `PURPOSE` - `REMARKS` - `INPUTTYPE` - `PICKLISTID` - `SOURCEDBOBJECTID` - `SOURCEDBOBJECTFIELDID` - `SORTORDER` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `SOURCETYPE` --- ## MMODULE **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/Module/ModuleQB.cs` **Columns (from INSERT INTO):** - `MODULEID` - `MODULECODE` - `MODULENAME` - `MODULEIMAGEID` - `PROJECTID` - `REMARKS` - `SORTORDER` - `STATUS` - `VERSION` - `SOURCETYPE` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `DEFAULTMENUID` --- ## MMRP **Module:** MMDAL | **Source:** `GB5Solution/MM/MMDAL/Query/MRP/MRPQB.cs` **Columns (from INSERT INTO):** - `MRPID` - `MRPCODE` - `MRPNAME` - `ISAUTORELEASE` - `ISTRACKCONVERSION` - `OVERWRITETYPE` - `ORGANIZATIONTYPE` - `OUID` - `OUGROUPID` - `MASTERSCHEDULEID` - `ISPENDING` - `INCLUDELEADTIME` - `INCLUDELOTSIZE` - `INCLUDESTOCKINTRANSIT` - `INCLUDESTOCK` - `SORTORDER` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `TENANTID` --- ## MMRPPARTYTYPE **Module:** MMDAL | **Source:** `GB5Solution/MM/MMDAL/Query/MRPPartyType/MRPPartyTypeQB.cs` **Columns (from INSERT INTO):** - `MRPPARTYTYPEID` - `MRPPARTYTYPECODE` - `MRPPARTYTYPENAME` - `PARTICULARS` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDON` --- ## MMRPPARTYTYPEDETAIL **Module:** MMDAL | **Source:** `GB5Solution/MM/MMDAL/Query/MRPPartyType/MRPPartyTypeQB.cs` **Columns (from INSERT INTO):** - `MRPPARTYTYPEDETAILID` - `MRPPARTYTYPEID` - `SLNO` - `MRPITEMTYPEID` - `NATURE` - `BIZTRANSACTIONID` --- ## MNARRATION **Module:** AccountsDAL | **Source:** `GB5Solution/Accounts/AccountsDAL/Query/Narration/NarrationQB.cs` **Columns (from INSERT INTO):** - `NARRATIONID` - `NARRATIONNAME` - `NARRATIONTYPE` - `PARAMETERSETID` - `NARRATION` - `SORTORDER` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `SOURCETYPE` - `TENANTID` --- ## MNDTMETHOD **Module:** MMDAL | **Source:** `GB5Solution/MM/MMDAL/Query/NDTMethod/NDTMethodQB.cs` **Columns (from INSERT INTO):** - `METHODCODE` - `METHODNAME` - `REPORTTITLETEMPLATE` - `PARAMETERSET` - `HASSTARTENDTIME` - `REQUIRESCALIBRATION` - `REMARKS` - `SORTORDER` - `STATUS` - `VERSION` - `SOURCETYPE` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `TENANTID` --- ## MOPERATION **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/Operation/OperationQB.cs` **Columns (from INSERT INTO):** - `OPERATIONID` - `OPERATIONCODE` - `OPERATIONNAME` - `REMARKS` - `SORTORDER` - `STATUS` - `VERSION` - `SOURCETYPE` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## MORGANIZATIONGROUP **Module:** AdminDAL | **Source:** `GB5Solution/Admin/AdminDAL/Query/OrganizationGroup/OrganizationGroupQB.cs` **Columns (from INSERT INTO):** - `ORGANIZATIONGROUPID` - `ORGANIZATIONGROUPCODE` - `ORGANIZATIONGROUPNAME` - `SORTORDER` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## MORGANIZATIONGROUPDETAIL **Module:** AdminDAL | **Source:** `GB5Solution/Admin/AdminDAL/Query/OrganizationGroup/OrganizationGroupQB.cs` **Columns (from INSERT INTO):** - `ORGANIZATIONGROUPDETAILID` - `ORGANIZATIONGROUPID` - `SLNO` - `OPERATIONTYPE` - `GROUPTYPE` - `OUID` - `COMPANYID` - `BRANCHID` - `DIVISIONID` - `ORGANISATIONGROUPPARENTID` --- ## MORGANIZATIONUNIT **Module:** AdminDAL | **Source:** `GB5Solution/Admin/AdminDAL/Query/OrganizationUnit/OrganizationUnitQB.cs` **Columns (from INSERT INTO):** - `OUID` - `ORGANIZATIONUNITCODE` - `ORGANIZATIONUNITNAME` - `ORGANIZATIONUNITSHORTNAME` - `COMPANYID` - `BRANCHID` - `DIVISIONID` - `OVERLOCKDATE` - `CURRENCYID` - `COLORID` - `CALENDARID` - `OULOGO1` - `OULOGO2` - `DISPLAYNAME` - `DEFAULTADDRESSID` - `SORTORDER` - `STATUS` - `VERSION` - `SOURCETYPE` - `PERIODGROUP` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## MPACK **Module:** MMDAL | **Source:** `GB5Solution/MM/MMDAL/Query/Pack/PackQB.cs` **Columns (from INSERT INTO):** - `PACKID` - `PACKCODE` - `PACKNAME` - `CONVERSIONTYPE` - `CONVERSIONFACTOR` - `SORTORDER` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## MPACKSET **Module:** MMDAL | **Source:** `GB5Solution/MM/MMDAL/Query/PackSet/PackSetQB.cs` **Columns (from INSERT INTO):** - `PACKSETID` - `PACKSETCODE` - `PACKSETNAME` - `SORTORDER` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `SOURCETYPE` --- ## MPACKSETDETAIL **Module:** MMDAL | **Source:** `GB5Solution/MM/MMDAL/Query/PackSet/PackSetQB.cs` **Columns (from INSERT INTO):** - `PACKSETDETAILID` - `PACKSETID` - `SLNO` - `PACKID` - `CONVERSIONTYPE` - `CONVERSIONFACTOR` --- ## MPAGE **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/Page/PageQB.cs` **Columns (from INSERT INTO):** - `PAGEID` - `PAGECODE` - `PAGENAME` - `REMARKS` - `PAGELAYOUT` - `PAGETYPE` - `MODULEID` - `SORTORDER` - `STATUS` - `VERSION` - `SOURCETYPE` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `IMAGEID` --- ## MPARAMETER **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/Parameter/ParameterQB.cs` **Columns (from INSERT INTO):** - `PARAMETERID` - `PARAMETERCODE` - `PARAMETERNAME` - `PARAMETERDATATYPE` - `PARAMETERDATASIZE` - `UOMID` - `MINVALUE` - `MAXVALUE` - `TYPEOFINFO` - `LOVTYPEID` - `ISFORMULAFIELD` - `REMARKS` - `FIELDMIN` - `FIELDMAX` - `ISCRITICAL` - `SORTORDER` - `STATUS` - `VERSION` - `SOURCETYPE` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `TENANTID` - `CONSOLIDATIONTYPE` --- ## MPARAMETERSET **Module:** MMDAL | **Source:** `GB5Solution/MM/MMDAL/Query/ParameterSet/ParameterSetQB.cs` **Columns (from INSERT INTO):** - `PARAMETERSETID` - `PARAMETERSETCODE` - `PARAMETERSETNAME` - `REMARKS` - `SORTORDER` - `STATUS` - `VERSION` - `SOURCETYPE` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## MPARAMETERSETDETAIL **Module:** MMDAL | **Source:** `GB5Solution/MM/MMDAL/Query/ParameterSet/ParameterSetQB.cs` **Columns (from INSERT INTO):** - `PARAMETERSETLINEID` - `PARAMETERSETID` - `SLNO` - `PARAMETERID` - `ISTRANSACTIONGET` - `SECTION` - `REJECTIONTYPE` --- ## MPARTDIMENSION **Module:** MMDAL | **Source:** `GB5Solution/MM/MMDAL/Query/PartLevel/PartDimensionQB.cs` **Columns (from INSERT INTO):** - `PARTDIMID` - `TENANTID` --- ## MPARTY **Module:** AccountsDAL | **Source:** `GB5Solution/Accounts/AccountsDAL/Query/Party/PartyQB.cs` **Columns (from INSERT INTO):** - `PARTYCODE` - `PARTYNAME` - `PARTYTYPE` - `CODEDEFINEID` - `PARTYFAVOURINGNAME` - `PARTYSHORTNAME` - `PARTYCOMBINEID` - `ISVENDOR` - `ISSERVICEPROVIDER` - `ISACCOUNT` - `ISCUSTOMER` - `ISPROSPECT` - `ISBANK` - `CONTROLACCOUNTID` - `ACCOUNTLINKID` - `SORTORDER` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `ACCOUNTGROUPID` - `CURRENCYID` - `DEFAULTADDRESSID` - `SOURCETYPE` - `TENANTID` - `THUMBNAIL` - `PARTYID` --- ## MPARTYACCOUNTOU **Module:** AccountsDAL | **Source:** `GB5Solution/Accounts/AccountsDAL/Query/PartyOU/PartyOUQB.cs` **Columns (from INSERT INTO):** - `PARTYACCOUNTOUID` - `PARTYID` - `PARTYBRANCHID` - `OUID` - `SEQUENCENUMBER` - `ISPURCHASEAPPLICALBE` - `ISSALESAPPLICABLE` - `PARTYACCOUNTOUTYPE` - `CREDITLIMIT` - `DEBITLIMIT` - `CREDITALLOWED` - `DEBITALLOWED` - `ACCOUNTID` - `PURCHASETERMSSETID` - `SALESTERMSSETID` - `AGENTID` - `TRANSPORTERID` - `TAXTYPEID` - `SALESPRICELISTID` - `PURCHASEPRICELISTID` - `ROUTEIDS` - `SORTORDER` - `STATUS` - `VERSION` - `SOURCETYPE` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `ROUTEID` - `PURCHASEPAYMENTTERMID` - `INCHARGEID` - `SALESPAYMENTTERMID` - `SALESINCHARGEID` - `MRPPARTYTYPEID` - `NUMBEROFBILLS` --- ## MPARTYBRANCH **Module:** AccountsDAL | **Source:** `GB5Solution/Accounts/AccountsDAL/Query/PartyBranch/PartyBranchQB.cs` **Columns (from INSERT INTO):** - `PARTYBRANCHID` - `PARTYID` - `PARTYBRANCHCODE` - `PARTYBRANCHNAME` - `PARTYBRANCHSHORTNAME` - `PARTYBRANCHTYPE` - `ISEOU` - `CURRENCYID` - `PURCHASEPRICELISTID` - `SALESPRICELISTID` - `TAXTYPEID` - `AGENTID` - `TRANSPORTERID` - `ISSALESAPPLICABLE` - `ISPURCHASEAPPLICALBE` - `INDUSTRYTYPE` - `SALESINCHARGEID` - `SALESPAYMENTTERMID` - `PURCHASEPAYMENTTERMID` - `PURCHASETERMSSETID` - `SALESTERMSSETID` - `CREDITDAYS` - `NOOFBILLS` - `ISSUBCONTRACT` - `MSMEREGNO` - `REGISTRATION` - `INCHARGEID` - `DISTRIBUTIONLISTID` - `LINKEDPARTIES` - `PROJECTMANAGERIDS` - `ACCOUNTMANAGERIDS` - `ROUTEID` - `ROUTEIDS` - `STANDARDREGIONID` - `ISEXCISEAPPLICABLE` - `ISCUSTOMERPRODUCT` - `SEQUENCENUMBER` - `INSURANCETYPE` - `FREIGHTTYPE` - `INSURANCEID` - `MRPPARTYTYPEID` - `PARTYINFO` - `SOURCETYPE` - `TENANTID` - `DEFAULTADDRESSID` - `SORTORDER` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## MPARTYBRANCHLOCATION **Module:** FMDAL | **Source:** `GB5Solution/FM/FMDAL/Query/PartyBranchLocation/PartyBranchLocationQB.cs` **Columns (from INSERT INTO):** - `PARTYBRANCHLOCATIONID` - `PARTYBRANCHLOCATIONCODE` - `PARTYBRANCHLOCATIONNAME` - `PARTYBRANCHID` - `PARENTLOCATIONID` - `INCHARGEID` - `NATURE` - `LEVELS` - `PARENTIDS` - `SORTORDER` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## MPARTYPRODUCT **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/JsonReplier/EIPConceptQB.cs` **Columns (from INSERT INTO):** - `OUID` - `PARTYID` - `PARTYBRANCHID` - `ITEMNAME` - `QUANTITY` - `PARTICULARS` - `CREATEDBYID` - `CREATEDON` --- ## MPATTERN **Module:** MMDAL | **Source:** `GB5Solution/MM/MMDAL/Query/Pattern/PatternQB.cs` **Columns (from INSERT INTO):** - `PATTERNID` - `PATTERNCODE` - `PATTERNNAME` - `PATTERNTYPE` - `PARTYID` - `PARAMETERSETID` - `POURINGWEIGHT` - `UOMID` - `GRADEID` - `TOTALWEIGHT` - `RUNNERWEIGHT` - `REMARKS` - `SORTORDER` - `STATUS` - `VERSION` - `SOURCETYPE` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `ITEMID` - `GRADEPARAMETERSETID` - `POURINGPARAMETERSETID` - `KNOCKOUTPARAMETERSETID` - `PATTERNMATERIALID` - `PATTERNMATERIALTOPID` - `PATTERNMATERIALBOTTOMID` - `YIELDPERCENTAGE` - `BOXSIZE` - `SPRUCECUPSIZE` - `FIRSTSAMPLEMADEON` - `CORELABOURCHARGE` - `NUMBEROFCOREBOX` - `TENANTID` - `NATURE` - `LIFECOUNT` - `START` - `OPENINGCOUNT` - `TRANSACTIONCOUNT` - `BALANCECOUNT` - `PATTERNMETHODID` - `NUMBEROFCAVITY` - `NUMBEROFWORKINGCAVITY` - `PLATEOWNERSHIPTYPE` - `PLATEOWNERID` - `MATCHPLATEMATERIALID` - `MATCHPLATESIZE` - `PATTERNLOCATION` - `PLATEREMARKS` --- ## MPATTERNCORE **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/PatternCore/PatternCoreQB.cs` **Columns (from INSERT INTO):** - `PATTERNCORECODE` - `PATTERNCORENAME` - `CORETYPEID` - `CORECAVITY` - `COREOWNERSHIPTYPE` - `PARTYID` - `COREWEIGHT` - `CHAPLET` - `COATINGMETHODID` - `TYPEOFCOATINGID` - `ITEMID` - `SORTORDER` - `STATUS` - `VERSION` - `SOURCETYPE` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `TENANTID` --- ## MPATTERNDETAIL **Module:** MMDAL | **Source:** `GB5Solution/MM/MMDAL/Query/Pattern/PatternQB.cs` **Columns (from INSERT INTO):** - `PATTERNDETAILID` - `PATTERNID` - `SLNO` - `ITEMID` - `SKUID` - `QUANTITY` - `WEIGHT` - `TOTALWEIGHT` - `IOTYPE` - `PATTERNCOREID` - `NOPERBOX` --- ## MPAYCHECKOUTCONFIG **Module:** PAYDAL | **Source:** `GB5Solution/PAY/PAYDAL/Query/Gateway/CheckoutConfigQB.cs` **Columns (from INSERT INTO):** - `CONFIGNAME` - `ALLOWCOD` - `ALLOWPARTIALPAY` - `MINPARTIALPAYTAMT` - `ALLOWB2C` - `ALLOWSAVEDINSTRUMENT` - `PAYMENTEXPIRYMINS` - `DEFAULTCURRENCY` - `DEFAULTGATEWAYCONFID` - `REMARKS` - `VERSION` - `STATUS` - `SORTORDER` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `SOURCETYPE` - `TENANTID` --- ## MPAYELEMENT **Module:** PayRollDAL | **Source:** `GB5Solution/PayRoll/PayRollDAL/Query/Payelement/PayelementQB.cs` **Columns (from INSERT INTO):** - `PAYELEMENTID` - `PAYELEMENTCODE` - `PAYELEMENTNAME` - `PERIODTYPE` - `COSTTYPE` - `SALARYTYPE` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## MPAYGATEWAY **Module:** PAYDAL | **Source:** `GB5Solution/PAY/PAYDAL/Query/Gateway/PayGatewayQB.cs` **Columns (from INSERT INTO):** - `PAYGATEWAYCODE` - `PAYGATEWAYNAME` - `GATEWAYTYPE` - `SUPPORTSUPI` - `SUPPORTSCARD` - `SUPPORTSNETBANKING` - `SUPPORTSCOD` - `SUPPORTSREFUND` - `SUPPORTSPAYOUT` - `WEBHOOKENDPOINT` - `LOGOURL` - `REMARKS` - `VERSION` - `STATUS` - `SORTORDER` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `SOURCETYPE` - `TENANTID` --- ## MPAYGATEWAYCONFIG **Module:** PAYDAL | **Source:** `GB5Solution/PAY/PAYDAL/Query/Gateway/PayGatewayConfigQB.cs` **Columns (from INSERT INTO):** - `PAYGATEWAYID` - `MERCHANTID` - `WEBHOOKURL` - `APIKEYIDVAULTKEY` - `APISECRETVAULTKEY` - `WEBHOOKSECRETVAULTKEY` - `GATEWAYMODE` - `ISDEFAULT` - `SUPPORTEDCURRENCY` - `REMARKS` - `VERSION` - `STATUS` - `SORTORDER` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `SOURCETYPE` - `TENANTID` --- ## MPAYMENTTERM **Module:** MMDAL | **Source:** `GB5Solution/MM/MMDAL/Query/PaymentTerm/PaymentTermQB.cs` **Columns (from INSERT INTO):** - `PAYMENTTERMID` - `PAYMENTTERMCODE` - `PAYMENTTERMNAME` - `REMARKS` - `SORTORDER` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## MPAYMENTTERMDETAIL **Module:** MMDAL | **Source:** `GB5Solution/MM/MMDAL/Query/PaymentTerm/PaymentTermQB.cs` **Columns (from INSERT INTO):** - `PAYMENTTERMDETAILID` - `PAYMENTTERMID` - `SLNO` - `PAYMENTTYPE` - `NUMBEROFDAYS` - `WEFDATETYPE` - `PAYMENTPERCENTAGE` - `CASHDISCOUNTID` --- ## MPERIOD **Module:** AdminDAL | **Source:** `GB5Solution/Admin/AdminDAL/Query/Period/PeriodQB.cs` **Columns (from INSERT INTO):** - `PERIODID` - `PERIODCODE` - `PERIODNAME` - `FROMDATE` - `TODATE` - `SORTORDER` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `PERIODGROUP` --- ## MPORT **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/Port/PortQB.cs` **Columns (from INSERT INTO):** - `PORTID` - `PORTNAME` - `COUNTRYID` - `PORTCODE` - `GSTPORTCODE` - `SORTORDER` - `STATUS` - `VERSION` - `SOURCETYPE` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## MPORTLET **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/PortLet/PortletQB.cs` **Columns (from INSERT INTO):** - `PORTLETID` - `PORTLETCODE` - `PORTLETNAME` - `PORTLETTYPEID` - `MODULEID` - `SECTION` - `URL` - `ISCHANGEABLE` - `REPORTID` - `PROGRAMID` - `MENUID` - `ISMAXIMIZE` - `ISRESIZE` - `ISPRINT` - `ISEXPORT` - `ISSETTINGSID` - `ISCHANGESETTING` - `SETTINGSID` - `SORTORDER` - `STATUS` - `VERSION` - `SOURCETYPE` - `PUBLISHCHANNELNAME` - `PUBLISHFIELDNAME` - `SUBSCRIBECHANNELNAME` - `DEFAULTCRITERIACONFIGID` - `SUBSCRIBEFIELDNAME` - `CHARTTYPE` - `CHARTXAXIS` - `CHARTYAXIS` - `CHARTVALUE` - `REPORTFORMATID` - `ISPAGENATIONREQUIRED` - `NUMBEROFRECORDS` - `XAXISDATEFORMAT` - `YAXISDATEFORMAT` - `HEIGHT` - `WIDTH` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `WEBSERVICESETTINGID` - `FILEID` - `FORMLINKMENUID` - `THUMBNAIL` - `DESCRIPTION` --- ## MPORTLETTYPE **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/PortletType/PortletTypeQB.cs` **Columns (from INSERT INTO):** - `PORTLETTYPEID` - `PORTLETTYPECODE` - `PORTLETTYPENAME` - `ISMAXIMIZE` - `ISRESIZE` - `ISPRINT` - `ISEXPORT` - `ISSETTINGSID` - `ISCHANGESETTING` - `SORTORDER` - `STATUS` - `VERSION` - `SOURCETYPE` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## MPORTLETVSMENU **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/PortletVsMenu/PortletVsMenuQB.cs` **Columns (from INSERT INTO):** - `PORTLETVSMENUID` - `PORTLETID` - `SLNO` - `MENUID` --- ## MPRICECATEGORY **Module:** MMDAL | **Source:** `GB5Solution/MM/MMDAL/Query/PriceCategory/PriceCategoryQB.cs` **Columns (from INSERT INTO):** - `PRICECATEGORYID` - `PRICECATEGORYCODE` - `PRICECATEGORYNAME` - `ISSELECTED` - `SORTORDER` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## MPROCESSGROUP **Module:** MMDAL | **Source:** `GB5Solution/MM/MMDAL/Query/MProcessGroup/MProcessGroupQB.cs` **Columns (from INSERT INTO):** - `PROCESSGROUPID` - `PROCESSGROUPCODE` - `PROCESSGROUPNAME` - `REMARKS` - `PRODUCTTYPE` - `PROCESSTYPE` - `RESOURCETYPE` - `PATTERNTYPE` - `PARAMETERSETID` - `SORTORDER` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `SOURCETYPE` - `TENANTID` --- ## MPROGRAM **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/Program/ProgramQB.cs` **Columns (from INSERT INTO):** - `PROGRAMID` - `PROGRAMNAME` - `SECTION` - `REMARKS` - `PROGRAMTYPEID` - `MODULEID` - `PROGRAMCLASSID` - `SORTORDER` - `STATUS` - `VERSION` - `SOURCETYPE` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## MPROGRAMASSEMBLY **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/ProgramAssembly/ProgramAssemblyQB.cs` **Columns (from INSERT INTO):** - `ASSEMBLYID` - `ASSEMBLYNAME` - `MODULEID` - `SECTION` - `REMARKS` - `SORTORDER` - `STATUS` - `VERSION` - `SOURCETYPE` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## MPROGRAMCLASS **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/ProgramClass/ProgramClassQB.cs` **Columns (from INSERT INTO):** - `PROGRAMCLASSCODE` - `PROGRAMCLASSNAME` - `ASSEMBLYID` - `SECTION` - `REMARKS` - `SORTORDER` - `STATUS` - `VERSION` - `SOURCETYPE` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## MPROGRAMTYPE **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/ProgramType/ProgramTypeQB.cs` **Columns (from INSERT INTO):** - `PROGRAMTYPEID` - `PROGRAMTYPECODE` - `PROGRAMTYPENAME` - `REMARKS` - `SORTORDER` - `STATUS` - `VERSION` - `SOURCETYPE` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## MPROJECT **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/Project/ProjectQB.cs` **Columns (from INSERT INTO):** - `PROJECTID` - `PROJECTCODE` - `PROJECTNAME` - `IMAGEID` - `REMARKS` - `SORTORDER` - `STATUS` - `VERSION` - `SOURCETYPE` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## MQUALIFIERDEFINITION **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/GOP/QualifierQB.cs` **Columns (from INSERT INTO):** - `QUALIFIERID` - `QUALIFIERCODE` - `QUALIFIERNAME` - `ENTITYID` - `QUALIFIERTYPE` - `ENTITYCODE` - `TEMPLATEID` - `ISSYSTEM` - `DESCRIPTION` - `VERSION` - `STATUS` - `SORTORDER` - `SOURCETYPE` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `TENANTID` --- ## MQUALIFIERDEPENDENCY **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/GOP/QualifierQB.cs` **Columns (from INSERT INTO):** - `QUALIFIERDEPENDENCYID` - `QUALIFIERID` - `DEPENDSONQUALIFIERID` - `VERSION` - `STATUS` - `SORTORDER` - `SOURCETYPE` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `TENANTID` --- ## MQUALIFIERENTITY **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/GOP/QualifierQB.cs` **Columns (from INSERT INTO):** - `QUALIFIERENTITYID` - `QUALIFIERID` - `ENTITYCODE` - `STAGE` - `SCOPE` - `ISACTIVE` - `VERSION` - `STATUS` - `SORTORDER` - `SOURCETYPE` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `TENANTID` --- ## MQUALIFIERMETHOD **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/GOP/QualifierQB.cs` **Columns (from INSERT INTO):** - `QUALIFIERMETHODID` - `QUALIFIERID` - `EXECUTIONMODE` - `EXPRESSION` - `QUERYCODE` - `SERVICECODE` - `RETURNTYPE` - `VERSION` - `STATUS` - `SORTORDER` - `SOURCETYPE` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `TENANTID` --- ## MQUALIFIEROUTPUT **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/GOP/QualifierQB.cs` **Columns (from INSERT INTO):** - `QUALIFIEROUTPUTID` - `QUALIFIERID` - `OUTPUTKEY` - `OUTPUTSCOPE` - `SOURCEEXPRESSION` - `VERSION` - `STATUS` - `SORTORDER` - `SOURCETYPE` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `TENANTID` --- ## MQUALIFIERRULECONDITION **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/GOP/QualifierQB.cs` **Columns (from INSERT INTO):** - `QUALIFIERRULECONDITIONID` - `QUALIFIERRULEGROUPID` - `QUALIFIERID` - `FIELDPATH` - `CONDITIONOPERATOR` - `EXPECTEDVALUE` - `SEVERITY` - `ERRORCODE` - `ERRORMESSAGE` - `VERSION` - `STATUS` - `SORTORDER` - `SOURCETYPE` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `TENANTID` --- ## MQUALIFIERRULEGROUP **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/GOP/QualifierQB.cs` **Columns (from INSERT INTO):** - `QUALIFIERRULEGROUPID` - `QUALIFIERID` - `PARENTRULEGROUPID` - `GROUPOPERATOR` - `VERSION` - `STATUS` - `SORTORDER` - `SOURCETYPE` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `TENANTID` --- ## MQUALIFIERVERSION **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/GOP/QualifierQB.cs` **Columns (from INSERT INTO):** - `QUALIFIERVERSIONID` - `QUALIFIERID` - `VERSIONNO` - `VERSIONLABEL` - `VERSIONSTATUS` - `SNAPSHOTJSON` - `ACTIVATEDON` - `VERSION` - `STATUS` - `SORTORDER` - `SOURCETYPE` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `TENANTID` --- ## MREASON **Module:** AdminDAL | **Source:** `GB5Solution/Admin/AdminDAL/Query/Reason/ReasonQB.cs` **Columns (from INSERT INTO):** - `REASONID` - `REASONCODE` - `REASONNAME` - `REASONTYPEID` - `REMARKS` - `SORTORDER` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `SOURCETYPE` - `TENANTID` - `CATEGORY` - `ISPRODUCTIVE` --- ## MREGION **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/Region/RegionQB.cs` **Columns (from INSERT INTO):** - `REGIONID` - `REGIONCODE` - `REGIONNAME` - `REGIONTYPEID` - `PARENTREGIONID` - `PARENTREGIONIDS` - `LEVELS` - `SORTORDER` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `SOURCETYPE` --- ## MREGIONTYPE **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/RegionType/RegionTypeQB.cs` **Columns (from INSERT INTO):** - `REGIONTYPEID` - `REGIONTYPECODE` - `REGIONTYPENAME` - `SORTORDER` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `SOURCETYPE` --- ## MRESOURCETYPE **Module:** CostingDAL | **Source:** `GB5Solution/Costing/CostingDAL/Query/ResourceType/ResourceTypeQB.cs` **Columns (from INSERT INTO):** - `RESOURCETYPEID` - `RESOURCETYPECODE` - `RESOURCETYPENAME` - `PARENTTYPEID` - `REMARKS` - `CAPACITYUOMID` - `ISCAPACITYPLANNING` - `ISRCCP` - `COSTTYPE` - `RESOURCENATURE` - `DEPARTMENTID` - `ISPRODUCTION` - `MACHINETYPEID` - `EMPLOYEETYPEID` - `PROCESSID` - `WORKCENTERID` - `MATERIALFILTERID` - `SORTORDER` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `ASSETTYPEID` --- ## MROLE **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/Role/RoleQB.cs` **Columns (from INSERT INTO):** - `ROLEID` - `ROLECODE` - `ROLENAME` - `REMARKS` - `SORTORDER` - `STATUS` - `VERSION` - `SOURCETYPE` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `TENANTID` --- ## MROLEVSMENU **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/RoleVsMenu/RoleVsMenuQB.cs` **Columns (from INSERT INTO):** - `ROLEVSMENUID` - `ROLEID` - `MENUID` - `SLNO` - `ALLOW` --- ## MROLEVSMODULES **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/RoleVsModule/RoleVsModulesQB.cs` **Columns (from INSERT INTO):** - `ROLEVSMODULESID` - `SLNO` - `ROLEID` - `MODULEID` - `DEFAULTMENUID` --- ## MROLEVSPORTLET **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/RoleVsPortlet/RoleVsPortletQB.cs` **Columns (from INSERT INTO):** - `ROLEVSPORTLETID` - `ROLEID` - `PAGEID` - `PORTLETID` - `CRITERIACONFIGID` - `SLNO` - `PORTLETROW` - `PORTLETCOLUMN` --- ## MROUTINGSKILL **Module:** SkillManagementDAL | **Source:** `GB5Solution/SkillManagement/SkillManagementDAL/Query/SkillProcessStageMap/SkillProcessStageMapQB.cs` **Columns (from INSERT INTO):** - `MAPID` - `SKILLID` - `SLNO` - `ROUTINGID` - `ROUTINGOPCODE` - `ROUTINGOPID` - `WORKCENTERID` - `ISPREREQUISITE` - `MINLEVELREQUIRED` - `REMARKS` --- ## MSECURITYQUESTION **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/SecurityQuestion/SecurityQuestionQB.cs` **Columns (from INSERT INTO):** - `SECURITYQUESTIONID` - `SECURITYQUESTION` - `REMARKS` - `SORTORDER` - `STATUS` - `VERSION` - `SOURCETYPE` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## MSERVERCONFIG **Module:** TCMSDAL | **Source:** `GB5Solution/TCMS/TCMSDAL/QueryBuilders/TCMSTestEnvQB.cs` **Columns (from INSERT INTO):** - `CONNECTIONNAME` - `SERVERID` - `DATABASETYPE` - `DATABASENAME` - `DATABASEUSERNAME` - `DATABASEPASSWORD` - `DATABASEPORT` - `CONTROLSOURCEDBNAME` - `DBINSTANCETYPE` - `NATURE` - `DBSOURCETYPE` - `SYSTEMSERVERCONFIGID` - `CLIENTID` - `CLIENTSITEID` - `STATUS` - `VERSION` - `SOURCETYPE` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `OFFSET` - `MAXVALUE` - `PARENTSERVERCONFIGID` - `FCMCONFIG` - `SERVICESERVERID` - `SERVERCONFIGID` --- ## MSERVICEREQUESTTYPE **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/ServiceRequestType/ServiceRequestTypeQB.cs` **Columns (from INSERT INTO):** - `SERVICEREQUESTTYPECODE` - `SERVICEREQUESTTYPENAME` - `DESCRIPTION` - `DOMAINID` - `DOMAINNAME` - `DOMAINCODE` - `CATEGORYID` - `CATEGORYNAME` - `CATEGORYCODE` - `TEMPLATEFORMID` - `TEMPLATE` - `WORKFLOWRULEID` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `SORTORDER` - `STATUS` - `VERSION` - `SOURCETYPE` - `TENANTID` --- ## MSESSIONSTORE **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/SessionStore/SessionStoreQB.cs` **Columns (from INSERT INTO):** - `SERVERCONFIGID` - `LOGINEVENTLOGID` - `LOGINTIME` - `LASTLOGINUSEDTIME` - `MACHINEIP` - `USERID` - `USERCODE` - `USERNAME` - `ISACTIVE` --- ## MSHAPE **Module:** MMDAL | **Source:** `GB5Solution/MM/MMDAL/Query/Shape/ShapeQB.cs` **Columns (from INSERT INTO):** - `SHAPECODE` - `SHAPENAME` - `DESCRIPTION` - `DIM1NAME` - `DIM2NAME` - `DIM3NAME` - `DIM4NAME` - `DIM5NAME` - `SORTORDER` - `STATUS` - `VERSION` - `SOURCETYPE` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## MSHAPEDIMENSION **Module:** MMDAL | **Source:** `GB5Solution/MM/MMDAL/Query/ShapeDimension/ShapeDimensionQB.cs` **Columns (from INSERT INTO):** - `SHAPEID` - `DIMENSIONCODE` - `SEMANTICNAME` - `DEFAULTMEASUREUNITID` - `REQUIREDTYPE` - `SORTORDER` - `STATUS` - `VERSION` - `SOURCETYPE` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## MSHIFT **Module:** MMDAL | **Source:** `GB5Solution/MM/MMDAL/Query/Shift/ShiftQB.cs` **Columns (from INSERT INTO):** - `SHIFTID` - `SHIFTCODE` - `SHIFTDESCRIPTION` - `ISPRODUCTIONSHIFT` - `ISBREAKAPPLICABLE` - `STARTTIME` - `ENDTIME` - `SHIFTMINUTES` - `WORKINGMINUTES` - `FIRSTHALFENDTIME` - `BREAKMINUTES` - `SECONDHALFSTARTTIME` - `GRACEMINUTES` - `REMARKS` - `SORTORDER` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `SOURCETYPE` - `FULLDAYMINUTES` - `HALFDAYMINUTES` - `TENANTID` - `CUTOFFMINUTES` - `CUTOFFMINUTESOUT` - `WORKTIMEMETHOD` - `PUNCHTOATTENDANCETYPE` --- ## MSIZESET **Module:** MMDAL | **Source:** `GB5Solution/MM/MMDAL/Query/SizeSet/SizeSetQB.cs` **Columns (from INSERT INTO):** - `SIZESETCODE` - `SIZESETNAME` - `SORTORDER` - `VERSION` - `STATUS` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `SOURCETYPE` - `TENANTID` --- ## MSKILL **Module:** SkillManagementDAL | **Source:** `GB5Solution/SkillManagement/SkillManagementDAL/Query/Skill/SkillQB.cs` **Columns (from INSERT INTO):** - `SKILLID` - `GROUPID` - `DOMAINID` - `SKILLCODE` - `SKILLNAME` - `SKILLNAMEFULL` - `SKILLSCOPE` - `LEVELCOUNT` - `ISSPECIALCHAR` - `MATRIXSEQNO` - `ISACTIVE` - `REMARKS` - `NOTES` - `VERSION` - `STATUS` - `SORTORDER` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `SOURCETYPE` - `TENANTID` --- ## MSKILLDOMAIN **Module:** SkillManagementDAL | **Source:** `GB5Solution/SkillManagement/SkillManagementDAL/Query/SkillDomain/SkillDomainQB.cs` **Columns (from INSERT INTO):** - `DOMAINID` - `DOMAINCODE` - `DOMAINNAME` - `DOMAINTYPE` - `DISPLAYORDER` - `ISACTIVE` - `DESCRIPTION` - `VERSION` - `STATUS` - `SORTORDER` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `SOURCETYPE` - `TENANTID` --- ## MSKILLGROUP **Module:** SkillManagementDAL | **Source:** `GB5Solution/SkillManagement/SkillManagementDAL/Query/SkillGroup/SkillGroupQB.cs` **Columns (from INSERT INTO):** - `GROUPID` - `DOMAINID` - `GROUPCODE` - `GROUPNAME` - `DISPLAYORDER` - `ISACTIVE` - `VERSION` - `STATUS` - `SORTORDER` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `SOURCETYPE` - `TENANTID` --- ## MSKILLLEVEL **Module:** SkillManagementDAL | **Source:** `GB5Solution/SkillManagement/SkillManagementDAL/Query/SkillLevel/SkillLevelQB.cs` **Columns (from INSERT INTO):** - `SLEVELID` - `SKILLID` - `SLNO` - `LEVELLABEL` - `LEVELCOUNT` - `LEVELDESCRIPTOR` - `ISMINREQUIRED` - `CANTRAINOTHERS` - `REMARKS` --- ## MSKILLMATRIX **Module:** SkillManagementDAL | **Source:** `GB5Solution/SkillManagement/SkillManagementDAL/Query/SkillMatrixConfig/SkillMatrixConfigQB.cs` **Columns (from INSERT INTO):** - `CONFIGID` - `MATRIXCODE` - `MATRIXTITLE` - `DOMAINID` - `TARGETDEPT` - `TARGETROLEIDS` - `PRODUCTFAMILYID` - `MODELIDS` - `INCLUDESKILLIDS` - `SHOWSUMMARYROW` - `SHOWMINLEVEL` - `UPDATEFREQUENCY` - `ISACTIVE` - `VERSION` - `STATUS` - `SORTORDER` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `SOURCETYPE` - `TENANTID` --- ## MSKILLPRODUCT **Module:** SkillManagementDAL | **Source:** `GB5Solution/SkillManagement/SkillManagementDAL/Query/SkillProductMap/SkillProductMapQB.cs` **Columns (from INSERT INTO):** - `MAPID` - `SKILLID` - `SLNO` - `PRODUCTFAMILYID` - `MODELID` - `SPECIFICPARAMETERS` - `ISACTIVE` - `REMARKS` --- ## MSKUSETTING **Module:** MMDAL | **Source:** `GB5Solution/MM/MMDAL/Query/SKUSetting/SKUSettingQB.cs` **Columns (from INSERT INTO):** - `SKUSETTINGCODE` - `SKUSETTINGNAME` - `SORTORDER` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `SOURCETYPE` - `TENANTID` --- ## MSLA **Module:** CRMDAL | **Source:** `GB5Solution/CRM/CRMDAL/Query/SLA/SLAQB.cs` **Columns (from INSERT INTO):** - `SLAID` - `SLACODE` - `SLANAME` - `DESCRIPTION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `SORTORDER` - `STATUS` - `VERSION` - `SOURCETYPE` - `TENANTID` --- ## MSLADETAIL **Module:** CRMDAL | **Source:** `GB5Solution/CRM/CRMDAL/Query/SLA/SLAQB.cs` **Columns (from INSERT INTO):** - `SLADETAILID` - `SLAID` - `SLAMETRICID` - `SLACONDITION` - `THRESHOLDVALUE` - `THREHOLDUNIT` - `ESCALATIONLEVEL` --- ## MSPACE **Module:** DMSDAL | **Source:** `GB5Solution/DMS/DMSDAL/Query/Space/SpaceQB.cs` **Columns (from INSERT INTO):** - `SPACECODE` - `SPACENAME` - `SPACEDESCRIPTION` - `PARENTSAPCEID` - `PARENTSPACEIDS` - `SPACELEVEL` - `ISKB` - `ISVERSION` - `ISCHECKINOUT` - `ISRSS` - `ISFOLDERS` - `ISCOLLOBORATION` - `ISBLOGS` - `ISDISCUSSION` - `ISWIKI` - `SLUG` - `ICON` - `COLORID` - `SETTINGS` - `SPACESTATUS` - `SORTORDER` - `STATUS` - `VERSION` - `SOURCETYPE` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `TENANTID` --- ## MSPACEFOLDER **Module:** DMSDAL | **Source:** `GB5Solution/DMS/DMSDAL/Query/Folder/FolderQB.cs` **Columns (from INSERT INTO):** - `SPACEFOLDERID` - `SPACEFOLDERNAME` - `SPACEFOLDERDESCRIPTION` - `SPACEFOLDERSTATUS` - `PERMISSION` - `SORTORDER` - `STATUS` - `VERSION` - `SOURCETYPE` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## MSPACEPROJECT **Module:** DMSDAL | **Source:** `GB5Solution/DMS/DMSDAL/Query/Project/ProjectQB.cs` **Columns (from INSERT INTO):** - `SPACEPROJECTID` - `SPACEPROJECTNAME` - `SPACEPROJECTDESCRIPTION` - `SPACEID` - `STARTDATE` - `ENDDATE` - `SPACEPROJECTSTATUS` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `SORTORDER` - `STATUS` - `VERSION` - `SOURCETYPE` - `TENANTID` --- ## MSPECIFICATION **Module:** MMDAL | **Source:** `GB5Solution/MM/MMDAL/Query/Specification/SpecificationQB.cs` **Columns (from INSERT INTO):** - `SPECIFICATIONID` - `SPECIFICATIONNAME` - `SPECIFICATIONDESCRIPTION` - `OBJECTTYPEID` - `OBJECTID` - `STANDARDID` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `SORTORDER` - `STATUS` - `VERSION` --- ## MSPECIFICATIONDETAIL **Module:** MMDAL | **Source:** `GB5Solution/MM/MMDAL/Query/Specification/SpecificationQB.cs` **Columns (from INSERT INTO):** - `SPECIFICATIONDETAILID` - `SPECIFICATIONID` - `SETSLNO` - `PARAMETERSETID` - `SLNO` - `PARAMETERID` - `MINVALUE` - `MAXVALUE` - `PERCENTAGE` - `HELPTEXT` - `REMARKS` --- ## MSTANDARD **Module:** MMDAL | **Source:** `GB5Solution/MM/MMDAL/Query/Standard/StandardQB.cs` **Columns (from INSERT INTO):** - `STANDARDID` - `STANDARDCODE` - `STANDARDNAME` - `STANDARDTYPEID` - `STANDARDNATURE` - `REMARKS` - `SORTORDER` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `SOURCETYPE` --- ## MSTANDARDTYPE **Module:** MMDAL | **Source:** `GB5Solution/MM/MMDAL/Query/StandardType/StandardTypeQB.cs` **Columns (from INSERT INTO):** - `STANDARDTYPEID` - `STANDARDTYPECODE` - `STANDARDTYPENAME` - `REMARKS` - `SORTORDER` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `SOURCETYPE` --- ## MSTATE **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/State/StateQB.cs` **Columns (from INSERT INTO):** - `STATEID` - `STATECODE` - `STATENAME` - `GSTSTATECODE` - `TINSTART` - `COUNTRYID` - `SORTORDER` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `SOURCETYPE` - `GEOLOCATION` - `BORDER` --- ## MSUBSCRIPTION **Module:** AdminDAL | **Source:** `GB5Solution/Admin/AdminDAL/Query/Subscription/SubscriptionQB.cs` **Columns (from INSERT INTO):** - `OBJECTTYPEID` - `OBJECTID` - `OUID` - `BIZTRANSACTIONID` - `PARTICULARS` - `USERIDS` - `SORTORDER` - `VERSION` - `STATUS` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `SOURCETYPE` - `SUBSCRIPTIONID` --- ## MSUPPLYGROUP **Module:** MMDAL | **Source:** `GB5Solution/MM/MMDAL/Query/SupplyGroup/SupplyGroupQB.cs` **Columns (from INSERT INTO):** - `SUPPLYGROUPID` - `SUPPLYGROUPCODE` - `SUPPLYGROUPNAME` - `REMARKS` - `SORTORDER` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `SOURCETYPE` - `TENANTID` --- ## MSUPPLYGROUPDETAIL **Module:** MMDAL | **Source:** `GB5Solution/MM/MMDAL/Query/SupplyGroup/SupplyGroupQB.cs` **Columns (from INSERT INTO):** - `SUPPLYGROUPDETAILID` - `SUPPLYGROUPID` - `SLNO` - `OUID` - `PARTYBRANCHID` - `PARTICULARS` - `SHAREPERCENT` --- ## MTAG **Module:** CMSDAL | **Source:** `GB5Solution/CMS/CMSDAL/Query/Tag/TagQB.cs` **Columns (from INSERT INTO):** - `TENANTID` - `NAME` - `SLUG` - `COLORID` - `TAGTYPE` - `USAGECOUNT` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `SORTORDER` - `STATUS` - `VERSION` - `SOURCETYPE` --- ## MTAXONOMY **Module:** CMSDAL | **Source:** `GB5Solution/CMS/CMSDAL/Query/Taxonomy/TaxonomyQB.cs` **Columns (from INSERT INTO):** - `TAXONOMYID` - `NAME` - `SLUG` - `DESCRIPTION` - `TYPE` - `ALLOWMULTIPLEVALUES` - `ISREQUIRED` - `DISPLAYORDER` - `METADATA` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `SORTORDER` - `STATUS` - `VERSION` - `SOURCETYPE` - `TENANTID` --- ## MTAXONOMYTERM **Module:** CMSDAL | **Source:** `GB5Solution/CMS/CMSDAL/Query/TaxonomyTerm/TaxonomyTermQB.cs` **Columns (from INSERT INTO):** - `TAXONOMYTERMID` - `TAXONOMYID` - `PARENTTAXONOMYTERMID` - `NAME` - `SLUG` - `DESCRIPTION` - `PATH` - `LEVELNO` - `DISPLAYORDER` - `COLOR` - `ICON` - `USAGECOUNT` - `METADATA` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `SORTORDER` - `STATUS` - `VERSION` - `SOURCETYPE` - `TENANTID` --- ## MTAXTABLE **Module:** MMDAL | **Source:** `GB5Solution/MM/MMDAL/Query/TaxTable/TaxTableQB.cs` **Columns (from INSERT INTO):** - `TAXTABLECODE` - `TAXTABLENAME` - `SORTORDER` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `SOURCETYPE` - `TENANTID` --- ## MTCMSAPILINK **Module:** TCMSDAL | **Source:** `GB5Solution/TCMS/TCMSDAL/QueryBuilders/TCMSTraceabilityQB.cs` **Columns (from INSERT INTO):** - `TESTCASEID` - `APIOPERATIONID` - `APIPATH` - `HTTPMETHOD` - `CREATEDBYID` - `CREATEDON` - `APILINKID` --- ## MTCMSMODULE **Module:** TCMSDAL | **Source:** `GB5Solution/TCMS/TCMSDAL/QueryBuilders/TCMSModuleQB.cs` **Columns (from INSERT INTO):** - `MODULECODE` - `MODULENAME` - `DESCRIPTION` - `PROJECTID` - `PIEMODULEID` - `PIEMODULENAME` - `PRIORITY` - `OWNER` - `ISACTIVE` - `TENANTID` - `CREATEDBY` - `CREATEDDATE` --- ## MTCMSPROJECT **Module:** TCMSDAL | **Source:** `GB5Solution/TCMS/TCMSDAL/QueryBuilders/TCMSProjectQB.cs` **Columns (from INSERT INTO):** - `PROJECTCODE` - `PROJECTNAME` - `DESCRIPTION` - `PROJECTTYPE` - `CLIENTID` - `PRODUCTID` - `STATUS` - `LEADCONSULTANT` - `STARTDATE` - `GOLIVEDATE` - `ISACTIVE` - `TENANTID` - `CREATEDBY` - `CREATEDDATE` --- ## MTCMSSCREENLINK **Module:** TCMSDAL | **Source:** `GB5Solution/TCMS/TCMSDAL/QueryBuilders/TCMSTraceabilityQB.cs` **Columns (from INSERT INTO):** - `TESTCASEID` - `SCREENROUTE` - `SCREENTITLE` - `MODULENAME` - `CREATEDBYID` - `CREATEDON` - `SCREENLINKID` --- ## MTCMSTESTCASE **Module:** TCMSDAL | **Source:** `GB5Solution/TCMS/TCMSDAL/QueryBuilders/TCMSTestCaseQB.cs` **Columns (from INSERT INTO):** - `TCID` - `TITLE` - `DESCRIPTION` - `MODULEID` - `FEATUREID` - `PRIORITY` - `TESTTYPE` - `EXECUTIONTYPE` - `SCENARIOTYPE` - `STATUS` - `PRECONDITIONS` - `POSTCONDITIONS` - `TAGS` - `PIESCENID` - `PIEVARIANTID` - `ISAUTOGENERATED` - `ISACTIVE` - `TENANTID` - `CREATEDBY` - `CREATEDDATE` --- ## MTCMSTESTSTEP **Module:** TCMSDAL | **Source:** `GB5Solution/TCMS/TCMSDAL/QueryBuilders/TCMSTestCaseQB.cs` **Columns (from INSERT INTO):** - `TESTCASEID` - `STEPORDER` - `STEPTYPE` - `STEPTEXT` - `EXPECTEDRESULT` - `TESTDATA` - `ISACTIVE` - `TENANTID` --- ## MTDSCATEGORY **Module:** AccountsDAL | **Source:** `GB5Solution/Accounts/AccountsDAL/Query/TDSCategory/TDSCategoryQB.cs` **Columns (from INSERT INTO):** - `TDSCATEGORYID` - `TDSCATEGORYCODE` - `TDSCATEGORYNAME` - `SECTION` - `REFERENCESECTION` - `FORM` - `TDSPERCENT` - `SCPERCENT` - `CESSPERCENT` - `DEDUCTIONACCOUNTID` - `PAIDACCOUNTID` - `SUFFEREDACCOUNTID` - `CLAIMACCOUNTID` - `REMARKS` - `SORTORDER` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `SOURCETYPE` - `TENANTID` - `ISCOMPANY` - `AMOUNTLIMIT` - `TRANSACTIONLIMIT` --- ## MTDSCONTACT **Module:** PayRollDAL | **Source:** `GB5Solution/PayRoll/PayRollDAL/Query/TDSContact/TDSContactQB.cs` **Columns (from INSERT INTO):** - `TDSCONTACTID` - `EMPLOYEEID` - `CONTACTTYPE` - `NAME` - `PAN` - `TAN` - `ADDRESSLINE1` - `ADDRESSLINE2` - `ADDRESSLINE3` - `ADDRESSLINE4` - `ADDRESSLINE5` - `VERSION` - `STATUS` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## MTEMPLATE **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/Template/TemplateQB.cs` **Columns (from INSERT INTO):** - `TEMPLATEID` - `TEMPLATECODE` - `TEMPLATENAME` - `REMARKS` - `SORTORDER` - `STATUS` - `VERSION` - `SOURCETYPE` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## MTERMS **Module:** MMDAL | **Source:** `GB5Solution/MM/MMDAL/Query/Terms/TermsQB.cs` **Columns (from INSERT INTO):** - `TERMSID` - `TERMSSECTION` - `TERMSDESCRIPTION` - `TERMSTYPE` - `SORTORDER` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `SOURCETYPE` - `TENANTID` --- ## MTRANSACTIONTYPE **Module:** MMDAL | **Source:** `GB5Solution/MM/MMDAL/Query/TransactionType/TransactionTypeQB.cs` **Columns (from INSERT INTO):** - `TRANSACTIONTYPEID` - `TRANSACTIONTYPECODE` - `TRANSACTIONTYPENAME` - `TYPE` - `LOCATIONTYPE` - `FORMRECEIVED` - `FORMISSUED` - `ISFORMRECEIVED` - `ISFORMISSUED` - `SORTORDER` - `STATUS` - `VERSION` - `VATCATEGORY` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `TRANSACTIONTYPE` - `CREDITTYPE` - `TRACKINGTYPE` - `SOURCETYPE` - `VATSECTION` - `RG1CATEGORY` - `GSTCATEGORYID` - `REGISTRATION` - `TENANTID` --- ## MUOM **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/UOM/UOMQB.cs` **Columns (from INSERT INTO):** - `UOMID` - `UOMCODE` - `UOMNAME` - `UOMTYPE` - `NOOFDECIMALS` - `SORTORDER` - `STATUS` - `VERSION` - `SOURCETYPE` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `GSTUOMCODE` --- ## MUSER **Module:** PayRollDAL | **Source:** `GB5Solution/PayRoll/PayRollDAL/Query/User/UserQB.cs` **Columns (from INSERT INTO):** - `USERID` - `USERCODE` - `USERNAME` - `USERLOGINNAME` - `PASSWORD` - `DOB` - `USERTYPE` - `NATURE` - `SECURITYLEVEL` - `SECURITYQUESTIONID` - `SECURITYANSWER` - `REMARKS` - `ISEMPLOYEE` - `ISPARTNER` - `PARTNERID` - `PARTNERUSERID` - `VALIDFROM` - `VALIDTO` - `ROLEID` - `PRIMARYMAIL` - `PRIMARYMOBILE` - `PRIMARYPHONE` - `PASSWORDPOLICYID` - `WORKOUID` - `WORKPERIODID` - `WORKPARTYBRANCHID` - `WORKSTOREID` - `WORKDATE` - `LASTSUCCESSLOGINON` - `LASTFAILUREATTEMPTON` - `PREVIOUSPASSWORD1` - `PREVIOUSPASSWORD2` - `PREVIOUSPASSWORD3` - `PASSWORDCHANGEDON` - `PREVIOUSLOGIN` - `WORKREGIONID` - `MODEOFOPERATION` - `USERCRITERIACONFIGID` - `SORTORDER` - `STATUS` - `VERSION` - `SOURCETYPE` - `DEFAULTIMAGEID` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `DEFAULTCMSID` - `USERDATEFORMAT` - `USERCURRENCYFORMAT` - `USERTIMEFORMAT` - `USERQUANTITYFORMAT` - `THEMEOPTION` - `NOOFSESSIONS` - `LOGINONWORKDAYSONLY` - `LOGINFROMTIME` - `LOGINTOTIME` - `LOGINMACHINE` - `LOGINIP` - `DIGITALSIGNEDFILE` - `DIGITALFILEPASSWORD` - `DEFAULTMENUID` - `WORKFINANCEBOOKID` - `TIMEZONEID` - `DEFAULTDEVICEID` - `DELIMITER` - `ISOUTOFOFFICE` - `OUTOFOFFICEFROMDATE` - `OUTOFOFFICETODATE` - `OUTOFOFFICEREMARKS` - `ESIGNATURECMSID` - `MMAILID` - `PUNCHTYPE` - `MFAUSERSETTING` - `MFAUSERACCOUNTID` - `MFAUSERSECRETKEY` - `MFAQRCODE` - `SHOWQRCODE` - `NUMBEROFFAILUREATTEMPTS` - `THUMBNAIL` - `THEMEMODE` - `LANGUAGEID` - `CRITERIARUNTYPE` - `DIGITALKEYLOCATION` --- ## MUSERACCESSRIGHTS **Module:** AdminDAL | **Source:** `GB5Solution/Admin/AdminDAL/Query/UserAccessRights/UserAccessRightsQB.cs` **Columns (from INSERT INTO):** - `USERACCESSRIGHTSID` - `USERID` - `SLNO` - `TYPE` - `OUID` - `OUGROUPID` - `NOOFPERIOD` - `NOOFREADPERIOD` --- ## MUSERGROUP **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/UserGroup/UserGroupQB.cs` **Columns (from INSERT INTO):** - `USERGROUPID` - `USERGROUPCODE` - `USERGROUPNAME` - `SORTORDER` - `STATUS` - `VERSION` - `SOURCETYPE` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## MUSERGROUPDETAIL **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/UserGroup/UserGroupQB.cs` **Columns (from INSERT INTO):** - `USERGROUPDETAILID` - `USERGROUPID` - `SLNO` - `USERID` --- ## MUSERVSPORTLET **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/UserVsPortlet/UserVsPortletQB.cs` **Columns (from INSERT INTO):** - `USERVSPORTLETID` - `USERID` - `PAGEID` - `PORTLETID` - `CRITERIACONFIGID` - `HEIGHT` - `WIDTH` - `SLNO` - `PORTLETROW` - `PORTLETCOLUMN` --- ## MVEHICLE **Module:** LogisticsDAL | **Source:** `GB5Solution/Logistics/LogisticsDAL/Query/Vehicle/VehicleQB.cs` **Columns (from INSERT INTO):** - `VEHICLEID` - `VEHICLENUMBER` - `VEHICLETYPEID` - `DRIVERID` - `EMPTYWEIGHT` - `TONNAGE` - `OWNERSHIPTYPE` - `TRANSPORTERID` - `ASSETID` - `OUIDS` - `YOM` - `ROADTAXVALIDITY` - `FCDATE` - `FCEXPIRYDATE` - `INSURANCEID` - `OWNERCONTACTID` - `MAKEID` - `FUELTYPEID` - `CAPACITYRANGEID` - `MINIMUMTONNAGE` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `SORTORDER` - `STATUS` - `VERSION` --- ## MWEBFORM **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/WebForm/WebFormQB.cs` **Columns (from INSERT INTO):** - `WEBFORMID` - `WEBFORMNAME` - `WEBFORMURL` - `TEMPLATE` - `MODULEID` - `SORTORDER` - `STATUS` - `VERSION` - `SOURCETYPE` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `WEBFORMSECONDURL` - `OBJECTMODELID` - `OBJECTMODELIDS` --- ## MWEBSERVICEPARAMETER **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/WebServiceParameter/WebServiceParameterQB.cs` **Columns (from INSERT INTO):** - `WEBSERVICEPARAMETERID` - `WEBSERVICEID` - `SLNO` - `PARAMETERNAME` - `PARAMETERDATATYPE` - `PARAMETERDESCRIPTION` - `ISCOMPULSARY` --- ## MWEBSERVICESETTING **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/WebServiceSetting/WebServiceSettingQB.cs` **Columns (from INSERT INTO):** - `WEBSERVICESETTINGID` - `WEBSERVICEID` - `SETTINGTYPE` - `REPORTID` - `MENUID` - `SORTORDER` - `STATUS` - `VERSION` - `SOURCETYPE` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## MWORKCENTERSHIFTMAP **Module:** MMDAL | **Source:** `GB5Solution/MM/MMDAL/Query/Scheduling/WorkCenterShiftMapQB.cs` **Columns (from INSERT INTO):** - `SHIFTMAPID` - `WORKCENTERID` - `SHIFTID` - `DAYOFWEEK` - `EFFECTIVEFROM` - `EFFECTIVETO` - `STATUS` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `TENANTID` --- ## MWORKFLOW **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/WorkFlow/WorkFlowQB.cs` **Columns (from INSERT INTO):** - `WORKFLOWNAME` - `ENTITYID` - `PARTICULARS` - `TENANTID` - `SORTORDER` - `VERSION` - `STATUS` - `SOURCETYPE` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## MWORKFLOWCONFIG **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/WorkflowConfig/WorkflowConfigQB.cs` **Columns (from INSERT INTO):** - `CLIENTID` - `ENTITYID` - `OUID` - `BIZTRANSACTIONCLASSID` - `ISBIZTRANSACTIONWISE` - `BIZTRANSACTIONID` - `ISFORMBASEDAPPROVAL` - `WORKFLOWID` - `EVALCONDITION` - `REMARKS` - `PARTICULARSTEMPLATE` - `CREATEDON` --- ## MWORKFLOWDETAIL **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/WorkFlow/WorkFlowQB.cs` **Columns (from INSERT INTO):** - `WORKFLOWID` - `SLNO` - `STEPKEY` - `DISPLAYNAME` - `STEPTYPE` - `ISINITIAL` - `ISFINAL` - `ASSIGNMENTTYPE` - `PARTICULARS` - `ASSIGNMENTID` - `PARALLELGROUPKEY` - `SLAHOURS` - `ESCALATIONRULEGROUPID` - `PICKLISTID` - `DISPLAYLABELID` --- ## OUTBOX **Module:** Unknown | **Source:** `GB5Shared/Query/OutBox/OutBoxQB.cs` **Columns (from INSERT INTO):** - `TOUTBOX` - `OBJECTTYPEID` - `OBJECTID` - `EVENTTYPEID` - `VERSION` - `CORRELATIONKEY` - `USERID` - `TENANTID` - `PAYLOAD` - `STATUS` - `CREATEDON` - `HEADERROWGUID` --- ## PIE **Module:** PIEDAL | **Source:** `GB5Solution/PIE/PIEDAL/Query/Variant/PIEVariantQB.cs` **Columns (from INSERT INTO):** - `PIECONFIGITEMID` - `PIEMODULEID` - `PIECONFIGITEMCODE` - `PIECONFIGITEMNAME` - `ITEMCATEGORY` - `ISMANDATORY` - `DEFAULTVALUE` - `ESTIMATEDHOURS` - `SORTORDER` - `STATUS` - `CMSCONTENTREF` - `CREATEDON` - `CREATEDBYID` - `MODIFIEDON` - `MODIFIEDBYID` - `TENANTID` - `PIETRAININGTOPICID` - `TOPICCODE` - `TOPICNAME` - `MENUPATH` - `TOPICCATEGORY` - `ESTIMATEDMINUTES` - `SEQUENCEORDER` - `PIEUATSCENARIOID` - `SCENARIOCODE` - `SCENARIOTITLE` - `TRANSACTIONTYPE` - `PRECONDITIONS` - `STEPS` - `EXPECTEDRESULT` - `COMPLEXITY` - `PIEMIGRATIONOBJECTID` - `OBJECTCODE` - `OBJECTNAME` - `DATACATEGORY` - `TEMPLATEREF` - `PIEESTIMATIONRULEID` - `ENGAGEMENTTYPE` - `COMPLEXITYLEVEL` - `BASEHOURS` - `CONFIGHOURS` - `TRAININGHOURS` - `MIGRATIONHOURS` - `UATHOURS` - `PMOVERHEADPCT` - `CONFIDENCESCORE` - `VALIDFROM` - `VALIDTO` - `LPIEESTIMATIONSNAPSHOTID` - `ENGAGEMENTREF` - `SNAPSHOTDATA` - `TOTALHOURS` - `PIEMODULECODE` - `PIEMODULENAME` - `PIEMODULEGROUP` - `ICONKEY` - `ISSTANDALONE` - `PIECONFIGDEPENDENCYID` - `DEPENDSONMODULEID` - `DEPENDENCYTYPE` - `PIEKPIID` - `KPICODE` - `KPINAME` - `KPICATEGORY` - `MEASUREMENTGUIDE` - `PIEOUTCOMEID` - `PIEPROFILEID` - `PROFILEVERSION` - `INDUSTRY` - `COMPANYSIZE` - `GEOGRAPHY` - `ACTUALHOURS` - `REWORKHOURS` - `REWORKCOUNT` - `UATPASSRATE` - `GOLIVESUCCESS` - `COMPLETIONDAYS` - `REWORKREASONS` - `DEVIATIONMAP` - `RECORDEDON` - `PIEPROFILECODE` - `PIEPROFILENAME` - `COMPANYSIZEMIN` - `COMPANYSIZEMAX` - `MATCHKEYWORDS` - `PIEPROFILEMODULEID` - `ISPRIMARY` - `PIEPROFILEVARIANTDEFAULTID` - `PIEVARIANTID` - `PIEPROFILEKPIID` - `PIEDEVIATIONQUESTIONID` - `QUESTIONCODE` - `QUESTIONTEXT` - `HELPTEXT` - `ANSWERTYPE` - `OPTIONS` - `PIEDEVIATIONIMPLICATIONID` - `ANSWERVALUE` - `IMPLICATIONTYPE` - `REFID` - `REFCODE` - `EFFORTDELTAHOURS` - `DESCRIPTION` - `PIELEARNINGPROPOSALID` - `PROPOSALTYPE` - `PROPOSALDESCRIPTION` - `EVIDENCEREFS` - `DEVIATIONRATE` - `AICONFIDENCESCORE` - `PROPOSEDCONTENT` - `PIEVARIANTCODE` - `PIEVARIANTNAME` - `PLAINLANGUAGEDESC` - `ISDEFAULT` - `PIEVARIANTIMPLICATIONID` - `RISKNOTE` --- ## REMEDIATIONCASES **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/GOP/ExecutionQB.cs` **Columns (from INSERT INTO):** --- ## SW **Module:** WiDAL | **Source:** `GB5Solution/WorkInstruction/WiDAL/Query/Wi/WiStepExecutionQB.cs` **Columns (from INSERT INTO):** - `TITLE` - `DESCRIPTION` - `SQL` - `CLIENTDATABASEID` - `CRSTATUS` - `QUERYTYPE` - `CATEGORY` - `TICKETREFERENCE` - `ROLLBACKPLAN` - `IMPACTANALYSIS` - `TENANTID` - `VERSION` - `STATUS` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `CHANGEREQUESTID` - `EVENTTYPE` - `EVENTCOMMENT` - `PERFORMEDBYID` - `PERFORMEDON` - `CLIENTDBID` - `CLIENTDBCODE` - `CLIENTDBNAME` - `DBSERVERID` - `DATABASENAME` - `DBMODELID` - `CLIENTDBSTATUS` - `SORTORDER` - `SOURCETYPE` - `DBMODELCODE` - `DBMODELNAME` - `HOSTNAME` - `PORT` - `DBTYPE` - `DBUSERNAME` - `DBPASSWORD` - `SERVERDESC` - `DDLSCRIPTID` - `BRANCHID` - `OBJECTGROUPID` - `OBJECTTYPE` - `SCHEMANAME` - `OBJECTNAME` - `SQLSCRIPT` - `ROLLBACKSQL` - `CHECKSUM` - `SCRIPTSTATUS` - `APPROVALREQUIRED` - `APPROVEDBYID` - `APPROVEDON` - `SEQUENCE` - `EXECSTATUS` - `ERRORMESSAGE` - `EXECUTEDON` - `METAVERSIONID` - `VERSIONLABEL` - `METASTATUS` - `SNAPSHOTJSON` - `TABLENAME` - `COLUMNNAME` - `CHANGETYPE` - `OLDVALUE` - `NEWVALUE` - `GROUPCODE` - `GROUPNAME` - `QUERYTEXT` - `SAVEDQUERYID` - `ROWSRETURNED` - `EXECUTIONMS` - `ISSUCCESS` - `EXECUTEDBYID` - `QUERYNAME` - `ISSHARED` - `BRANCHCODE` - `BRANCHNAME` - `BRANCHTYPE` - `BRANCHSTATUS` - `PARENTBRANCHID` - `SYNCGROUPID` - `SYNCGROUPCODE` - `SYNCGROUPNAME` - `SYNCBEHAVIOR` - `FILTERCLAUSE` - `TAGNAME` - `COLORHEX` - `TAGID` - `PACKAGEID` - `PACKAGENAME` - `PACKAGECODE` - `PKGSTATUS` - `RELEASENOTES` - `PACKAGEDDLID` - `PACKAGEMETAID` - `WISKILLREQUIREMENTID` - `WIID` - `SKILLID` - `MINLEVELNO` - `ENFORCEMENT` - `ISMANDATORY` - `REMARKS` - `WISTEPEXECUTIONID` - `WIEXECUTIONID` - `WISTEPID` - `SLNO` - `STEPSTATUS` - `STARTEDON` - `COMPLETEDON` - `ACTUALDURATIONSECS` - `STDDURATIONSECS` - `ADVANCETRIGGER` - `BARCODESCANNED` - `SKIPPEDREASON` --- ## TACTION **Module:** CRMDAL | **Source:** `GB5Solution/CRM/CRMDAL/Query/Action/ActionQB.cs` **Columns (from INSERT INTO):** - `ACTIONID` - `OUID` - `PERIODID` - `BIZTRANSACTIONTYPEID` - `TRANSACTIONNUMBER` - `TRANSACTIONDATE` - `REFERENCENUMBER` - `REFERENCEDATE` - `ENTRYMODE` - `DEVICEID` - `PARTYBRANCHID` - `PERSONID` - `PERIODFROM` - `PERIODTO` - `REMARKS` - `TAGS` - `OTHERCHARGESID` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `ACTIONBYTYPE` - `CREATEDAT` - `MODIFIEDAT` --- ## TACTIONDETAIL **Module:** CRMDAL | **Source:** `GB5Solution/CRM/CRMDAL/Query/Action/ActionQB.cs` **Columns (from INSERT INTO):** - `ACTIONDETAILID` - `ACTIONID` - `SLNO` - `ACTIONTYPE` - `TASKID` - `CALLID` - `BREAKDOWNID` - `LEADID` - `PARTYBRANCHID` - `ACTIVITYID` - `ASSETID` - `PARAMETERSETID` - `ACTIONSTATUS` - `REASONID` - `REMARKS` - `PERIODFROM` - `PERIODTO` - `ISCOMPLETED` - `COMPLETEDON` - `DURATION` - `ALERTS` - `ALLOCATIONID` - `ATTENDEDBYTYPE` - `ATTENDEDBYEMPLOYEEID` - `ATTENDEDBYCONTACTID` - `ATTENDEDBYPARTYID` - `ATTENDEDBYUSERID` - `INTERVAL` - `NETDURATION` - `ISFREE` - `FCRATE` - `CURRENCYID` - `CONVERSIONRATE` - `RATE` - `RATEPERUOMID` - `FCAMOUNT` - `AMOUNT` - `AMOUNTPLUS` - `AMOUNTMINUS` - `GROSSAMOUNT` - `OTHERAMOUNTPLUS` - `OTHERAMOUNTMINUS` - `NETAMOUNT` - `ISMACHINERUNNING` - `ISINVOICED` - `CHARGESID` - `FOLLOWUPTASKID` - `PENDINGREASONID` - `ACTIONDETAILSTATUS` - `PRIORITYID` - `EXPECTEDDATE` - `EXPECTEDFCREVENUE` - `ORDERCONFIDENCE` - `REVENUECONFIDENCE` - `SUCCESSSTATUS` - `LEADCYCLEDETAILID` - `QUANTITY` - `NOOFDATA` - `OBJECTTYPEID` - `OBJECTID` - `WORKTYPEDETAILID` - `SELECTIONREMARKS` - `SELECTIONSTATUS` - `EXPENSEHEADID` - `PAIDTOACCOUNTID` - `CLAIMAMOUNT` - `APPROVEDAMOUNT` - `RECOVERYPERCENTAGE` - `RECOVERYVALUE` - `RECOVERYTYPE` --- ## TACTIONOUTBOX **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/ActionProcessor/ActionOutboxQB.cs` **Columns (from INSERT INTO):** - `ACTIONRUNID` - `DESTINATIONTOPIC` - `PAYLOAD` - `SENDSTATUS` - `ATTEMPTS` - `VERSION` - `STATUS` - `SORTORDER` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `SOURCETYPE` - `TENANTID` - `CORRELATIONKEY` --- ## TASSESSMENT **Module:** SkillManagementDAL | **Source:** `GB5Solution/SkillManagement/SkillManagementDAL/Query/SkillAssessment/SkillAssessmentQB.cs` **Columns (from INSERT INTO):** - `ASSESSMENTID` - `ASSESSMENTCODE` - `ASSESSMENTNAME` - `EMPLOYEEID` - `SKILLID` - `PRODUCTFAMILYID` - `MODELID` - `LEVELACHIEVED` - `PREVIOUSLEVEL` - `ASSESSEDBYID` - `ASSESSEDDT` - `ASSESSMETHOD` - `EVIDENCEREF` - `REMARKS` - `VERSION` - `STATUS` - `SORTORDER` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `SOURCETYPE` - `TENANTID` --- ## TATTACHMENT **Module:** DMSDAL | **Source:** `GB5Solution/DMS/DMSDAL/Query/ESSDocument/ESSDocumentQB.cs` **Columns (from INSERT INTO):** - `OBJECTTYPEID` - `OBJECTID` - `BIZTRANSACTIONTYPEID` - `SLNO` - `DOCUMENTSETDETAILID` - `ATTACHMENTTYPE` - `DOCUMENTTYPEID` - `VALIDFROM` - `VALIDTO` - `CLASSIFICATIONMARKID` - `TAGS` - `CMSID` - `FOLDERNAME` - `LINKURL` - `DISPLAYFILENAME` - `ATTACHEDFILENAME` - `REMARKS` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `THUMBNAIL` - `ATTACHMENTOPTION` - `OBJECTHEADERID` - `OBJECTHEADERTYPEID` - `OBJECTHEADERGUID` - `ROWGUID` - `MIMETYPE` - `FILESIZEBYTES` --- ## TBATCHCHAIN **Module:** MMDAL | **Source:** `GB5Solution/MM/MMDAL/Query/Scheduling/SchedulingRunQB.cs` **Columns (from INSERT INTO):** - `BATCHCHAINID` - `TENANTID` - `ROOTBATCHNUMBER` - `PROCESSSTEP` - `BATCHID` - `SCHEDULINGRUNID` --- ## TCALL **Module:** CRMDAL | **Source:** `GB5Solution/CRM/CRMDAL/Query/Call/CallQB.cs` **Columns (from INSERT INTO):** - `CALLID` - `OUID` - `BIZTRANSACTIONTYPEID` - `PERIODID` - `CALLNUMBER` - `CALLDATE` - `REFERENCENUMBER` - `REFERENCEDATE` - `OBJECTTYPEID` - `OBJECTID` - `PARTYID` - `PARTYBRANCHID` - `EMPLOYEEID` - `CONTACTID` - `ADDRESSID` - `REPORTEDBY` - `REPORTEDBYID` - `RECEIVEDBYID` - `CALLRECEIVEDMODE` - `CALLTYPEID` - `CALLGENERATIONTYPE` - `CONTRACTID` - `CONTRACTCYCLENUMBER` - `CALLNATUREID` - `CALLPRIORITYID` - `PROBLEMDATE` - `PROBLEMTIME` - `PROMISSEDDATE` - `ALLOTEDTOTYPE` - `ALLOTEDTOEMPLOYEEID` - `ALLOTEDTOCONTACTID` - `ALLOTEDTOPARTYID` - `CALLSTATUS` - `CALLONOBJECTTYPEID` - `CALLONOBJECTID` - `CALLONNAME` - `COVERAGESTATUS` - `REPORTEDPROBLEM` - `ACTIONTAKEN` - `CUSTOMERREMARKS` - `PROBLEMNATUREID` - `PLANDATE` - `POSSIBLEDATE` - `ESTIMATEDLABOURAMOUNT` - `ESTIMATEDSPARESAMOUNT` - `ESTIMATEDOTHERSAMOUNT` - `ESTIMATEDTOTALAMOUNT` - `ESTIMATEDBYID` - `LABOURAMOUNT` - `SPARESAMOUNT` - `OTHERAMOUNT` - `TOTALAMOUNT` - `PERSONID` - `INDOOROUTDOOR` - `ISITEMRECEIVED` - `ITEMRECEIVEDREMARKS` - `ISSTANDBYGIVEN` - `STANDBYITEMID` - `STANDBYREMARKS` - `COMPLETEDBYID` - `COMPLETEDON` - `COMPLETEDONTIME` - `CUSTOMERFEEDBACK` - `ISCLOSED` - `CLOSEDBYID` - `CLOSEDON` - `CLOSEDONTIME` - `REASONID` - `ISACCOUNTED` - `ROOTCAUSEID` - `ROOTCAUSEDESCRIPTION` - `CALLONOBJECTSTATUS` - `ALLOCATIONID` - `ALLOTEDMODE` - `MANUFACTURERSLNO` - `VERSION` - `STATUS` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## TCALLVSDEFECTS **Module:** CRMDAL | **Source:** `GB5Solution/CRM/CRMDAL/Query/Call/CallQB.cs` **Columns (from INSERT INTO):** - `CALLVSDEFECTSID` - `CALLID` - `SLNO` - `PROBLEMID` --- ## TCASHBACKLEDGER **Module:** PAYDAL | **Source:** `GB5Solution/PAY/PAYDAL/Query/Cashback/CashbackLedgerQB.cs` **Columns (from INSERT INTO):** - `CASHBACKLEDGERID` - `PAYORDERID` - `CASHBACKRULEID` - `CUSTOMERID` - `CASHBACKAMT` - `PAYOUTMODE` - `PAYOUTSTATUS` - `SCHEDULEDPAYOUTON` - `PAYOUTON` - `RETRYCOUNT` - `FAILUREREASON` - `VOUCHERID` - `VERSION` - `STATUS` - `SORTORDER` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `SOURCETYPE` - `TENANTID` --- ## TCHECKINGSETTING **Module:** AdminDAL | **Source:** `GB5Solution/Admin/AdminDAL/Query/CheckingSetting/CheckingSettingQB.cs` **Columns (from INSERT INTO):** - `CHECKINGSETTINGID` - `ENTITYID` - `BIZTRANSACTIONCLASSID` - `OUID` - `PERIODID` - `BIZTRANSACTIONTYPEID` - `VERSION` - `STATUS` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## TCHECKLISTLOG **Module:** QMSDAL | **Source:** `GB5Solution/QMS/QMSDAL/Query/ChecklistLog/ChecklistLogQB.cs` **Columns (from INSERT INTO):** - `CHECKLISTLOGID` - `OUID` - `PERIODID` - `BIZTRANSACTIONTYPEID` - `CHECKLISTID` - `LOGNO` - `LOGDATE` - `REFERENCENO` - `REFERENCEDATE` - `OBJECTBIZTRANSACTIONTYPEID` - `OBJECTHEADERTYPEID` - `OBJECTHEADERID` - `OBJECTTYPEID` - `OBJECTID` - `COMPLETEDBYID` - `COMPLETEDON` - `OVERALLRESULT` - `SKIPPEDREASON` - `STATUS` - `TENANTID` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## TCHECKLISTLOGDETAIL **Module:** QMSDAL | **Source:** `GB5Solution/QMS/QMSDAL/Query/ChecklistLog/ChecklistLogQB.cs` **Columns (from INSERT INTO):** - `CHECKLISTLOGDETAILID` - `CHECKLISTLOGID` - `SLNO` - `CHECKLISTDETAILID` - `INPUTVALUE` - `INPUTTEXT` - `INPUTID` - `ATTACHMENTID` - `RESULT` - `REMARKS` - `TENANTID` --- ## TCMSTASK **Module:** CMSDAL | **Source:** `GB5Solution/CMS/CMSDAL/Query/Task/TaskQB.cs` **Columns (from INSERT INTO):** - `TASKNAME` - `TASKDESCRIPTION` - `TASKPRIORITY` - `TASKSTATUS` - `TASKDUEDATE` - `OBJECTTYPEID` - `OBJECTID` - `ASSIGNEDTOUSERID` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## TCOMMENT **Module:** CostingDAL | **Source:** `GB5Solution/Costing/CostingDAL/Query/Costing/CostingQB.cs` **Columns (from INSERT INTO):** - `COMMENTID` - `PARENTCOMMENTID` - `USERID` - `TIMESTAMP` - `COMMENTSTATUS` - `ACCESSTYPE` - `PRIVATEUSERGROUPID` - `OBJECTTYPEID` - `OBJECTID` - `COMMENTTEXT` - `SECURITYLEVEL` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `BIZTRANSACTIONID` - `OUID` --- ## TCOMPLIANCE_ALERT **Module:** ComplianceDAL | **Source:** `GB5Solution/Compliance/ComplianceDAL/Query/ComplianceAlert/ComplianceAlertQB.cs` **Columns (from INSERT INTO):** - `ALERTTYPE` - `GSTIN` - `RETURNPERIOD` - `ARTIFACTID` - `ALERTMESSAGE` - `SEVERITY` - `ISACTIVE` - `CLIENTID` - `DATABASENAME` --- ## TCOMPLIANCE_ARTIFACT **Module:** ComplianceDAL | **Source:** `GB5Solution/Compliance/ComplianceDAL/Query/ComplianceArtifact/ComplianceArtifactQB.cs` **Columns (from INSERT INTO):** - `ARTIFACTID` - `ARTIFACTTYPE` - `FRAMEWORK` - `SOURCEENTITYTYPE` - `SOURCEENTITYID` - `GSTIN` - `RETURNPERIOD` - `STATUS` - `ATTEMPTCOUNT` - `CLIENTID` - `DATABASENAME` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## TCOMPLIANCE_AUDIT **Module:** ComplianceDAL | **Source:** `GB5Solution/Compliance/ComplianceDAL/Query/ComplianceArtifact/ComplianceArtifactQB.cs` **Columns (from INSERT INTO):** - `AUDITID` - `ARTIFACTID` - `ACTION` - `REQUESTPAYLOAD` - `RESPONSEPAYLOAD` - `PREVIOUSSTATE` - `NEWSTATE` - `PROVIDERCODE` - `HTTPSTATUSCODE` - `REFERENCENUMBER` - `ERRORMESSAGE` - `ATTEMPTNUMBER` - `USERID` - `CALLEDON` - `CLIENTID` - `DATABASENAME` --- ## TCOMPLIANCE_PAYLOAD **Module:** ComplianceDAL | **Source:** `GB5Solution/Compliance/ComplianceDAL/Query/ComplianceArtifact/ComplianceArtifactQB.cs` **Columns (from INSERT INTO):** - `PAYLOADID` - `ARTIFACTID` - `PAYLOADTYPE` - `PAYLOADFORMAT` - `PAYLOAD` - `ATTEMPTNUMBER` - `SIGNEDBYID` - `SIGNEDON` - `CLIENTID` - `DATABASENAME` - `CREATEDON` --- ## TCOMPLIANCE_PERIOD **Module:** ComplianceDAL | **Source:** `GB5Solution/Compliance/ComplianceDAL/Query/GSTReturn/GSTReturnQB.cs` **Columns (from INSERT INTO):** - `FRAMEWORK` - `GSTIN` - `RETURNTYPE` - `PERIODYEAR` - `PERIODMONTH` - `STATUS` - `SUBMITTEDON` - `ACKNUMBER` - `FILEDON` - `CONFIRMATIONNUMBER` - `CLIENTID` - `DATABASENAME` - `MODIFIEDBYID` - `MODIFIEDON` --- ## TCOMPLIANCE_PERIOD_SUMMARY **Module:** ComplianceDAL | **Source:** `GB5Solution/Compliance/ComplianceDAL/Query/ComplianceAnalytics/ComplianceAnalyticsQB.cs` **Columns (from INSERT INTO):** - `GSTIN` - `PERIODYEAR` - `PERIODMONTH` - `SUMMARYTYPE` - `TOTALTAXABLEVALUE` - `TOTALIGST` - `TOTALCGST` - `TOTALSGST` - `TOTALCESS` - `TOTALITCIGST` - `TOTALITCCGST` - `TOTALITCSGST` - `TOTALDOCUMENTS` - `INVALIDDOCUMENTS` - `RECOMPUTEDON` - `CLIENTID` - `DATABASENAME` --- ## TCONTENT **Module:** CMSDAL | **Source:** `GB5Solution/CMS/CMSDAL/Query/Content/ContentQB.cs` **Columns (from INSERT INTO):** - `CONTENTTYPEID` - `CMSSPACEID` - `TITLE` - `SLUG` - `CONTENTSTATUS` - `DATAJSON` - `METADATAJSON` - `PUBLISHEDVERSION` - `CURRENTVERSION` - `PUBLISHEDATE` - `PUBLISHEDBYID` - `EXPIRESAT` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `TENANTID` - `STATUS` --- ## TCONVERSATIONOTP **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/JsonReplier/EIPConceptQB.cs` **Columns (from INSERT INTO):** - `CONVERSATIONID` - `OTP` - `EXPIRESON` - `STATUS` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `TENANTID` --- ## TCOSTING **Module:** CostingDAL | **Source:** `GB5Solution/Costing/CostingDAL/Query/Costing/CostingQB.cs` **Columns (from INSERT INTO):** - `COSTINGID` - `OUID` - `PERIODID` - `BIZTRANSACTIONTYPEID` - `COSTINGTYPE` - `COSTANALYSISTYPE` - `COSTINGNUMBER` - `COSTINGDATE` - `FROMDATE` - `TODATE` - `REFERENCENUMBER` - `REFERENCEDATE` - `REMARKS` - `STATUS` - `VERSION` - `VERSIONNUMBER` - `PREVIOUSCOSTINGID` - `COSTINGSTATUSID` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `ROWGUID` --- ## TCOSTINGDETAIL **Module:** CostingDAL | **Source:** `GB5Solution/Costing/CostingDAL/Query/Costing/CostingQB.cs` **Columns (from INSERT INTO):** - `COSTINGDETAILID` - `COSTINGID` - `OBJECTTYPEID` - `OBJECTID` - `ITEMID` - `SKUID` - `QUANTITY` - `UOMID` - `MATERIALCOST` - `MATERIALVALUE` - `MATERIALPROJECTEDCOST` - `MATERIALPROJECTEDVALUE` - `MATERIALPROCESSCOST` - `MATERIALPROCESSVALUE` - `MATERIALPROJECTEDPROCESSCOST` - `MATERIALPROJECTEDPROCESSVALUE` - `MATERIALCHARGESCOST` - `MATERIALCHARGESVALUE` - `MATERIALEXPENSECOST` - `MATERIALEXPENSEVALUE` - `MATERIALREVENUE` - `MATERIALTOTALREVENUE` - `MATERIALTOTALCOST` - `MATERIALTOTALVALUE` - `MATERIALPROJECTEDTOTALCOST` - `MATERIALPROJECTEDTOTALVALUE` - `BASERATE` - `BASERATEINCLUSIVE` - `CURRENCYID` - `CURRENCYCONVERSION` - `BUYUOMID` - `UOMCONVERSION` - `PROCESSCOST` - `PROCESSVALUE` - `PROJECTEDPROCESSCOST` - `PROJECTEDPROCESSVALUE` - `CHARGESCOST` - `CHARGESVALUE` - `EXPENSECOST` - `EXPENSEVALUE` - `REVENUE` - `TOTALREVENUE` - `TOTALCOST` - `TOTALVALUE` - `PROJECTEDTOTALCOST` - `PROJECTEDTOTALVALUE` - `PARAMETERDETAIL` - `BUYCHARGEID` - `SELLCHARGEID` - `SELLRATE` - `SELLCHARGES` - `SELLRATEINCLUSIVE` - `TOTALSALE` - `MRP` - `REALISATION` - `TOTALREALISATIONVALUE` - `SLNO` - `TOTALOTHERBASICVALUE` - `TOTALOTHERCHARGES` - `TOTALOTHERVALUE` - `PRODUCTDESCRIPTION` - `ROWGUID` --- ## TCOSTINGEXPENSE **Module:** CostingDAL | **Source:** `GB5Solution/Costing/CostingDAL/Query/Costing/CostingQB.cs` **Columns (from INSERT INTO):** - `COSTINGEXPENSEID` - `COSTINGMATERIALID` - `COSTINGDETAILID` - `COSTINGPROCESSID` - `EXPENSETYPE` - `TYPE` - `PARTICULARS` - `NUMBER` - `RATEFC` - `RATEPERUOM` - `RATECONVERSION` - `CURRENCYID` - `CURRENCYCONVERSION` - `COST` - `COSTHEADID` - `ROWGUID` --- ## TCOSTINGMATERIAL **Module:** CostingDAL | **Source:** `GB5Solution/Costing/CostingDAL/Query/Costing/CostingQB.cs` **Columns (from INSERT INTO):** - `COSTINGMATERIALID` - `COSTINGDETAILID` - `SLNO` - `STAGECODE` - `ITEMID` - `SKUID` - `QUANTITY` - `UOMID` - `PARENTLINEID` - `LEVEL` - `IOTYPE` - `MAKEORBUY` - `PERPRODUCTIONQUANTITY` - `PERPRODUCTIONUOMID` - `REQUIREDPRODUCTIONQUANTITY` - `CALCULATEDQUANTITY` - `WASTEPERCENTAGE` - `NETQUANTITY` - `ADJUSTQUANTITY` - `FINALQUANTITY` - `AVAILABLERATE` - `PROJECTEDRATE` - `RATEFC` - `CURRENCYID` - `CURRENCYCONVERSION` - `RATE` - `RATEPERUOM` - `RATECONVERSIONTYPE` - `RATECONVERSION` - `MATERIALCOST` - `MATERIALVALUE` - `MATERIALPROJECTEDCOST` - `MATERIALPROJECTEDVALUE` - `MATERIALPROCESSCOST` - `MATERIALPROCESSVALUE` - `MATERIALPROJECTEDPROCESSCOST` - `MATERIALPROJECTEDPROCESSVALUE` - `MATERIALCHARGESCOST` - `MATERIALCHARGESVALUE` - `MATERIALEXPENSECOST` - `MATERIALEXPENSEVALUE` - `MATERIALREVENUE` - `MATERIALTOTALREVENUE` - `MATERIALTOTALCOST` - `MATERIALTOTALVALUE` - `MATERIALPROJECTEDTOTALCOST` - `MATERIALPROJECTEDTOTALVALUE` - `PROCESSCOST` - `PROCESSVALUE` - `PROJECTEDPROCESSCOST` - `PROJECTEDPROCESSVALUE` - `CHARGESCOST` - `CHARGESVALUE` - `EXPENSECOST` - `EXPENSEVALUE` - `REVENUE` - `TOTALREVENUE` - `TOTALCOST` - `TOTALVALUE` - `PROJECTEDTOTALCOST` - `PROJECTEDTOTALVALUE` - `PROJECTIONREFENCEID` - `REMARKS` - `PROJECTEDBY` - `PARAMETERDETAIL` - `LINENUMBER` - `SYSTEMNUMBER` - `ITEMTYPE` - `SECTIONTYPE` - `OTHERRATE` - `OTHERCHARGES` - `OTHERCOST` - `OTHERVALUE` - `OTHERCHARGESCOST` - `DESCRIPTION` - `POSTEDQUANTITY` - `ISCOLLAPSED` - `ISPRINT` - `SPECIFICATIONS` - `POSTBATCHID` - `PREVIOUSTOTALVALUE` - `ROWGUID` --- ## TCOSTINGPROCESS **Module:** CostingDAL | **Source:** `GB5Solution/Costing/CostingDAL/Query/Costing/CostingQB.cs` **Columns (from INSERT INTO):** - `COSTINGPROCESSID` - `PROCESSTYPE` - `COSTINGMATERIALID` - `COSTINGDETAILID` - `TYPE` - `STAGE` - `STEP` - `SLNO` - `PROCESSID` - `ACTIVITYID` - `QUANTITY` - `UOMID` - `LOTSIZE` - `SETUPTIME` - `CYCLETIME` - `MANUFACTURINGLEADTIME` - `AVAILABLECOST` - `PROJECTEDCOST` - `RATEPERUOMID` - `RATECONVERSION` - `COST` - `WASTEPERCENTAGE` - `TOTALCOST` - `REMARKS` - `ITEMID` - `SKUID` - `DESCRIPTION` - `ROWGUID` --- ## TCOSTLAYER **Module:** MMDAL | **Source:** `GB5Solution/MM/MMDAL/Query/StockValuation/FifoLayerCostQB.cs` **Columns (from INSERT INTO):** - `COSTLAYERID` - `OUID` - `STOREID` - `ITEMID` - `SKUID` - `LAYERDATE` - `ORIGINALQUANTITY` - `REMAININGQUANTITY` - `UNITCOST` - `OBJECTTYPEID` - `OBJECTID` - `STOCKLEDGERID` - `ISFULLYCONSUMED` - `CREATEDON` --- ## TCOSTLAYERDETAIL **Module:** MMDAL | **Source:** `GB5Solution/MM/MMDAL/Query/StockValuation/FifoLayerCostQB.cs` **Columns (from INSERT INTO):** - `COSTLAYERDETAILID` - `COSTLAYERID` - `ISSUESTOCKLEDGERID` - `CONSUMEDQUANTITY` - `UNITCOST` - `CONSUMEDON` --- ## TCRITERIACONFIG **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/CriteriaConfig/CriteriaConfigQB.cs` **Columns (from INSERT INTO):** - `CRITERIACONFIGID` - `CRITERIACONFIGNAME` - `CRITERIASERVICEID` - `CRITERIACONFIGTYPE` - `CRITERIAUSERID` - `PERIODFILTER` - `CRITERIAMENUID` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `CRITERIAOUID` - `RECORDSPERPAGE` - `REPORTFORMATID` - `DEFAULTREPORTVIEWID` - `SOURCETYPE` - `CRITERIARUNTYPE` --- ## TDECLARATION **Module:** PayRollDAL | **Source:** `GB5Solution/PayRoll/PayRollDAL/Query/Declaration/DeclarationQB.cs` **Columns (from INSERT INTO):** - `DECLARATIONID` - `EMPLOYEEID` - `PERIODID` - `PLANNUMBER` - `SUBMITTEDON` - `PLANSTATUS` - `PLANDATE` - `REMARKS` - `LOCKSTATUS` - `VERSION` - `STATUS` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `CALCULATIONMETHOD` - `NOOFEDUCATION` - `NOOFHOSTEL` - `PREVIOUSSALARY` - `PREVIOUSTDS` - `PREVIOUSPT` - `PREVIOUSPF` --- ## TDECLARATIONDETAIL **Module:** PayRollDAL | **Source:** `GB5Solution/PayRoll/PayRollDAL/Query/Declaration/DeclarationQB.cs` **Columns (from INSERT INTO):** --- ## TDELIVERYITEM **Module:** IDMSDAL | **Source:** `GB5Solution/IDMS/IDMSDAL/QueryBuilders/DomainItemQB.cs` **Columns (from INSERT INTO):** - `DELIVERYITEMID` - `ENGAGEMENTID` - `TENANTID` - `DOMAINCODE` - `ITEMTYPE` - `ITEMSUBTYPE` - `ITEMNAME` - `ITEMMETADATA` - `STATUS` - `ASSIGNEDTOID` - `DUEON` - `ESTIMATEDHOURS` - `DISPLAYORDER` - `ISMANDATORY` - `REMOTESESSIONREF` - `CLIENTSELFSERVICE` - `ISREWORK` - `REWORKREASONCODE` - `REWORKREASONDETAIL` - `PIECONTENTREF` - `KMSCONTENTREF` - `VERSION` - `SORTORDER` - `SOURCETYPE` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## TDIAGNOSTIC_SESSION **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/DiagnosticsSession/DiagnosticsSessionQB.cs` **Columns (from INSERT INTO):** - `SESSIONSCOPE` - `SCOPEID` - `DIAGNOSTICLEVEL` - `CAPTUREQUERYBODIES` - `CAPTURERESPONSEBODIES` - `INCREASESAMPLING` - `EXPIRESAT` - `ISACTIVE` - `CREATEDBYID` - `TENANTID` - `DIAGNOSTICSESSIONID` --- ## TDIRECTACTIONTOKEN **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/DirectAction/DirectActionTokenQB.cs` **Columns (from INSERT INTO):** - `TOKENHASH` - `CONTEXTID` - `ACTIONCODE` - `ASSIGNEEUSERID` - `TENANTID` - `EXPIRESAT` - `USEDAT` - `STATUS` - `CREATEDON` --- ## TDRAFT **Module:** AdminDAL | **Source:** `GB5Solution/Admin/AdminDAL/Query/Draft/DraftQB.cs` **Columns (from INSERT INTO):** - `DRAFTID` - `ENTITYID` - `MENUID` - `BIZTRANSACTIONTYPEID` - `OUID` - `CODE` - `NAME` - `PARTICULARS` - `DRAFTNUMBER` - `DRAFTDATE` - `REFERENCENUMBER` - `REFERENCEDATE` - `JSONOBJECT` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## TDRAFT_ROWS **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/Draft/DraftRowQB.cs` **Columns (from INSERT INTO):** --- ## TEIPCONVERSATION **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/JsonReplier/EIPConceptQB.cs` **Columns (from INSERT INTO):** - `CLIENTID` - `PLATFORMTYPEID` - `SESSIONTOKEN` - `STATUS` - `LASTACTIVITYON` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `SOURCETYPE` - `TENANTID` --- ## TEIPCONVERSATIONDETAIL **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/JsonReplier/EIPConceptQB.cs` **Columns (from INSERT INTO):** - `CONVERSATIONID` - `DIRECTION` - `MESSAGE` - `PROVIDERMESSAGEID` - `STATUS` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `TENANTID` --- ## TENGAGEMENTMODULE **Module:** IDMSDAL | **Source:** `GB5Solution/IDMS/IDMSDAL/QueryBuilders/EngagementQB.cs` **Columns (from INSERT INTO):** - `ENGAGEMENTMODULEID` - `ENGAGEMENTID` - `TENANTID` - `SLNO` - `MODULEID` - `MODULECODE` - `MODULENAME` - `PIEVARIANTSSELECTED` - `ESTIMATEDHOURS` - `ISPRIMARY` - `SEEDINGSTATUS` --- ## TEVENTACTIONRUN **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/ActionProcessor/EventActionRunQB.cs` **Columns (from INSERT INTO):** - `ACTIONID` - `JOBEXECUTIONID` - `EVENTTYPEID` - `RUNSTATUS` - `ATTEMPTS` - `PAYLOAD` - `CORRELATIONKEY` - `VERSION` - `STATUS` - `SORTORDER` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `SOURCETYPE` - `TENANTID` - `PLAYGROUNDRUNID` - `ACTIONRUNID` --- ## TEVENTLOG **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/EventLog/EventLogQB.cs` **Columns (from INSERT INTO):** - `EVENTTEXT` - `LINK` - `SOURCEID` - `USERID` - `TAGS` - `EVENTVALUE` - `DATA` - `GEO` - `EVENTTYPEID` - `EVENTCLASSID` - `LOGBOOKID` - `DATAID` - `TIMESTAMP` - `EVENTCHANNELID` - `OUID` - `MACHINEIP` - `MODEOFWORKING` - `LOGINEVENTLOGID` - `EVENTLOGID` --- ## TEVENTLOGCHANGE **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/ChangeTracking/ChangeTrackingQB.cs` **Columns (from INSERT INTO):** - `EVENTLOGID` - `FIELDNAME` - `OLDVALUE` - `NEWVALUE` - `TENANTID` --- ## TGATEENTRY **Module:** PayRollDAL | **Source:** `GB5Solution/PayRoll/PayRollDAL/Query/GateEntry/GateEntryQB.cs` **Columns (from INSERT INTO):** - `GATEENTRYID` - `GATEENTRYNUMBER` - `GATEENTRYDATE` - `REFERENCEDATE` - `REFERENCENUMBER` - `DESCRIPTION` - `TIMEIN` - `TIMEOUT` - `DURATION` - `DATEIN` - `DATEOUT` - `ENTRYSTATUS` - `PARTYID` - `PARTYCODE` - `PARTYNAME` - `VEHICLEID` - `VEHICLENUMBER` - `VEHICLETYPEID` - `VEHICLETYPECODE` - `VEHICLETYPENAME` - `DOCUMENTID` - `DOCUMENTNUMBER` - `DOCUMENTDATE` - `NATURENAME` - `MATERIALTYPE` - `TRANSPORTERID` - `TRANSPORTERCODE` - `TRANSPORTERNAME` - `DRIVERID` - `DRIVERNAME` - `VILLAGEID` - `VILLAGECODE` - `VILLAGENAME` - `CITYID` - `CITYCODE` - `CITYNAME` - `STATEID` - `STATECODE` - `STATENAME` - `ITEMID` - `ITEMCODE` - `ITEMNAME` - `ITEMCATEGORYID` - `ITEMCATEGORYCODE` - `ITEMCATEGORYNAME` - `ITEMSUBCATEGORYID` - `ITEMSUBCATEGORYCODE` - `ITEMSUBCATEGORYNAME` - `FIRSTWEIGHTMENT` - `SECONDWEIGHTMENT` - `SORTORDER` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `OUID` - `SOURCETYPE` - `TENANTID` - `NATURE` - `BIZTRANSACTIONTYPEID` - `ASSIGNEDSTOREID` - `LOADINGWEIGHT` - `GROSSWEIGHT` - `RATEFINALIZE` - `VALUE` - `UNLOADINGWEIGHT` - `DOCUMENTIDS` - `DOCUMENTNUMBERS` - `PERIODID` - `LRNUMBER` - `LRDATE` - `REMARKS` --- ## TGATEENTRYDETAIL **Module:** PayRollDAL | **Source:** `GB5Solution/PayRoll/PayRollDAL/Query/GateEntry/GateEntryQB.cs` **Columns (from INSERT INTO):** - `GATEENTRYID` - `SLNO` - `DOCUMENTID` - `DOCUMENTNUMBER` - `ITEMID` - `ITEMCODE` - `ITEMNAME` - `UOMID` - `UOMNAME` - `LOTID` - `LOTNUMBER` - `LOTQUANTITY` - `PACKNUMBERID` - `PACKNUMBER` - `PACKQUANTITY` - `PACKTYPE` - `PACKID` - `PACKCODE` - `PACKNAME` - `MANUFACTURINGDATE` - `EXPIRYDATE` - `ALLOCATIONID` - `DOCUMENTVALUE` - `REMARKS` --- ## TGOPEXECUTIONDEADLETTER **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/GOP/GopQueueQB.cs` **Columns (from INSERT INTO):** --- ## TGOPEXECUTIONHEADER **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/GOP/GopQueueQB.cs` **Columns (from INSERT INTO):** --- ## TGOPEXECUTIONLOCK **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/GOP/GopQueueQB.cs` **Columns (from INSERT INTO):** --- ## TGOPEXECUTIONMETRICS **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/GOP/GopQueueQB.cs` **Columns (from INSERT INTO):** --- ## TGOPEXECUTIONNODELOG **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/GOP/GopQueueQB.cs` **Columns (from INSERT INTO):** --- ## TGOPEXECUTIONNODEMETRICS **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/GOP/GopQueueQB.cs` **Columns (from INSERT INTO):** --- ## TGOPEXECUTIONQUEUE **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/GOP/GopQueueQB.cs` **Columns (from INSERT INTO):** --- ## TGOPEXECUTIONREMEDIATION **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/GOP/GopQueueQB.cs` **Columns (from INSERT INTO):** --- ## TGOPEXECUTIONSTATELOG **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/GOP/GopQueueQB.cs` **Columns (from INSERT INTO):** --- ## TGOPSOURCEFILE **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/GOP/GopQueueQB.cs` **Columns (from INSERT INTO):** --- ## TGST_EINVOICE **Module:** ComplianceDAL | **Source:** `GB5Solution/Compliance/ComplianceDAL/Query/GSTEInvoice/GSTEInvoiceQB.cs` **Columns (from INSERT INTO):** - `ARTIFACTID` - `DOCUMENTID` - `DOCUMENTTYPE` - `DOCUMENTNUMBER` - `DOCUMENTDATE` - `GSTIN` - `IRN` - `SIGNEDQRCODE` - `SIGNEDEINVOICE` - `ACKNOWLEDGEMENTNUMBER` - `ACKNOWLEDGEMENTDATE` - `STATUS` - `SUBMISSIONMODE` - `BATCHID` - `CLIENTID` - `DATABASENAME` - `CREATEDBYID` - `CREATEDON` --- ## TGST_EWAYBILL **Module:** ComplianceDAL | **Source:** `GB5Solution/Compliance/ComplianceDAL/Query/GSTEWayBill/GSTEWayBillQB.cs` **Columns (from INSERT INTO):** - `ARTIFACTID` - `DOCUMENTID` - `DOCUMENTTYPE` - `DOCUMENTNUMBER` - `DOCUMENTDATE` - `EWBNUMBER` - `GSTIN` - `FROMGSTIN` - `FROMNAME` - `FROMADDRESS` - `FROMPINCODE` - `FROMSTATECODE` - `TOGSTIN` - `TONAME` - `TOADDRESS` - `TOPINCODE` - `TOSTATECODE` - `TRANSPORTERGSTIN` - `TRANSPORTERNAME` - `TRANSPORTDOCNUMBER` - `TRANSPORTDOCDATE` - `VEHICLENUMBER` - `VEHICLETYPE` - `TRANSPORTMODE` - `DISTANCE` - `TOTALVALUE` - `TAXABLEVALUE` - `IGSTAMOUNT` - `CGSTAMOUNT` - `SGSTAMOUNT` - `CESSAMOUNT` - `STATUS` - `VALIDUPTO` - `SUBMISSIONMODE` - `BATCHID` - `CLIENTID` - `DATABASENAME` - `CREATEDBYID` - `CREATEDON` --- ## TGST_INWARD **Module:** ComplianceDAL | **Source:** `GB5Solution/Compliance/ComplianceDAL/Query/GSTInward/GSTInwardQB.cs` **Columns (from INSERT INTO):** - `SUPPLIERGSTIN` - `SUPPLIERNAME` - `OURGSTIN` - `RETURNPERIOD` - `INVOICENUMBER` - `INVOICEDATE` - `INVOICEVALUE` - `TAXABLEVALUE` - `IGSTAMOUNT` - `CGSTAMOUNT` - `SGSTAMOUNT` - `CESSAMOUNT` - `ITCELIGIBLE` - `ACCEPTANCESTATUS` - `SOURCE` - `CLIENTID` - `DATABASENAME` - `CREATEDBYID` - `CREATEDON` --- ## TGST_OUTWARD **Module:** ComplianceDAL | **Source:** `GB5Solution/Compliance/ComplianceDAL/Query/GSTOutward/GSTOutwardQB.cs` **Columns (from INSERT INTO):** - `ARTIFACTID` - `GSTIN` - `RETURNPERIOD` - `SOURCEDOCUMENTID` - `INVOICENUMBER` - `INVOICEDATE` - `INVOICEVALUE` - `RECEIVERGSTIN` - `RECEIVERNAME` - `POS` - `SUPPLYTYPE` - `INVOICETYPE` - `TAXABLEVALUE` - `IGSTRATE` - `IGSTAMOUNT` - `CGSTRATE` - `CGSTAMOUNT` - `SGSTRATE` - `SGSTAMOUNT` - `CESSRATE` - `CESSAMOUNT` - `FILINGSTATUS` - `ACKREFERENCENUMBER` - `ORIGINALOUTWARDID` - `CLIENTID` - `DATABASENAME` - `CREATEDBYID` - `CREATEDON` --- ## TGST_RECON **Module:** ComplianceDAL | **Source:** `GB5Solution/Compliance/ComplianceDAL/Query/GSTRecon/GSTReconQB.cs` **Columns (from INSERT INTO):** - `RECONTYPE` - `PERIOD` - `OURGSTIN` - `INWARDID` - `STATUS` - `DIFFTAXABLEVALUE` - `DIFFIGST` - `DIFFCGST` - `DIFFSGST` - `DIFFCESS` - `CLIENTID` - `DATABASENAME` - `CREATEDBYID` - `CREATEDON` --- ## TICEDATA **Module:** AdminDAL | **Source:** `GB5Solution/Admin/AdminDAL/Query/IceDataQB/IceDataQB.cs` **Columns (from INSERT INTO):** - `ICEDATANUMBER` - `REFERENCENUMBER` - `ENTITYID` - `MODELMAPID` - `ICETEMPLATEID` - `ICEDATASTATUS` - `CONFIDENCEPERCENT` - `DISPLAYDATA` - `ORIGINALFILENAME` - `FILEURL` - `FILEBUFFER` - `EXTRACTEDTEXT` - `SOURCEDATA` - `VALIDATIONERRORS` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `TENANTID` --- ## TICEDATADETAIL **Module:** AdminDAL | **Source:** `GB5Solution/Admin/AdminDAL/Query/IceDataQB/IceDataQB.cs` **Columns (from INSERT INTO):** - `ICEDATAID` - `SLNO` - `DETAILREFERENCENUMBER` - `ICEDETAILSTATUS` - `DISPLAYDETAIL` - `DETAILSOURCEDATA` - `CONVERTEDDATA` - `DETAILVALIDATIONERRORS` - `TARGETRESPONSE` - `TARGETID` - `TARGETREFERENCE` - `CURRENTBIZPROCESSSTAGEID` - `REVIEWNOTES` - `REVIEWEDBYID` - `ORIGINALICEDATADETAILID` - `ORIGINALREFERENCENUMBER` - `AMENDMENTSLNO` - `AMENDMENTREASON` - `AMENDMENTDATE` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `TENANTID` --- ## TIMPLEMENTATIONENGAGEMENT **Module:** IDMSDAL | **Source:** `GB5Solution/IDMS/IDMSDAL/QueryBuilders/EngagementQB.cs` **Columns (from INSERT INTO):** - `ENGAGEMENTID` - `TENANTID` - `CLIENTID` - `ENGAGEMENTCODE` - `ENGAGEMENTNAME` - `ENGAGEMENTTYPE` - `ENGAGEMENTSOURCE` - `DELIVERYMODE` - `STATUS` - `ACTIVEDOMAINS` - `PIEENGAGEMENTID` - `PIEESTIMATIONSNAPSHOTREF` - `BILLINGMODEL` - `CONTRACTVALUE` - `CONTRACTREF` - `LEGALVAULTLEVEL` - `VERSION` - `SORTORDER` - `SOURCETYPE` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## TINSPECTION **Module:** MMDAL | **Source:** `GB5Solution/MM/MMDAL/Query/Inspection/InspectionQB.cs` **Columns (from INSERT INTO):** - `INSPECTIONID` - `INSPECTIONDATE` - `OUID` - `PERIODID` - `STAGEID` - `PARTYID` - `SHIFTID` - `BIZTRANSACTIONTYPEID` - `REFERENCENUMBER` - `REFERENCEDATE` - `WORKCENTERID` - `FROMSTOREID` - `TOSTOREID` - `INSPECTIONNUMBER` - `INSPECTIONAREAID` - `INSPECTIONTYPE` - `INSPECTIONTYPEID` - `LOADBIZTRANSACTIONTYPEID` - `LOADHEADEROBJECTTYPEID` - `LOADHEADEROBJECTID` - `TOTALPACKQUANTITY` - `TOTALQUANTITY` - `REMARKS` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## TINSPECTIONDEFECT **Module:** MMDAL | **Source:** `GB5Solution/MM/MMDAL/Query/Inspection/InspectionQB.cs` **Columns (from INSERT INTO):** - `INSPECTIONDEFECTID` - `INSPECTIONDETAILID` - `SLNO` - `QUANTITYMARK` - `DEFECTID` - `NUMBEROFDEFECTS` - `POINTS` - `NUMBEROFDEFECTSAFTER` - `POINTSAFTER` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## TINSPECTIONDETAIL **Module:** MMDAL | **Source:** `GB5Solution/MM/MMDAL/Query/Inspection/InspectionQB.cs` **Columns (from INSERT INTO):** - `INSPECTIONDETAILID` - `INSPECTIONID` - `SLNO` - `LOADOBJECTTYPEID` - `LOADOBJECTID` - `ITEMID` - `SKUID` - `LOTID` - `SPECIFICATIONREFERENCE` - `PARAMETERSETID` - `ROUTINGPARAMETERSETID` - `NUMBEROFSAMPLES` - `DOCUMENTQUANTITY` - `INSPECTEDQUANTITY` - `SHORTAGEQUANTITY` - `EXCESSQUANTITY` - `GOODQUANTITY` - `REJECTEDQUANTITY` - `REWORKQUANTITY` - `OTHERQUANTITY` - `TOTALPOINTS` - `TOTALPOINTSAFTER` - `QCCOMPARISONSTATUS` - `BINIDS` - `BINID` - `PACKNUMBERID` - `PICK` --- ## TINSPECTIONPARAMETER **Module:** MMDAL | **Source:** `GB5Solution/MM/MMDAL/Query/Inspection/InspectionQB.cs` **Columns (from INSERT INTO):** - `INSPECTIONPARAMETERID` - `INSPECTIONDETAILID` - `SLNO` - `SAMPLENUMBER` - `PARAMETERSLNO` - `PARAMETERID` - `UOMID` - `AVERAGE` - `RESULT` - `INPUTVALUE` - `INPUTTEXT` - `INPUTDATE` - `FINALVALUE` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## TINSPECTIONRESULT **Module:** MMDAL | **Source:** `GB5Solution/MM/MMDAL/Query/Inspection/InspectionQB.cs` **Columns (from INSERT INTO):** - `INSPECTIONRESULTID` - `INSPECTIONDETAILID` - `SLNO` - `ITEMID` - `SKUID` - `LOTID` - `QUANTITY` - `INSPECTIONRESULT` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## TINSPECTIONWORKERDETAIL **Module:** MMDAL | **Source:** `GB5Solution/MM/MMDAL/Query/Inspection/InspectionQB.cs` **Columns (from INSERT INTO):** - `INSPECTIONWORKERDETAILID` - `INSPECTIONID` - `SLNO` - `USERID` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## TINTERVIEW **Module:** RecruitmentDAL | **Source:** `GB5Solution/Recruitment/RecruitmentDAL/Query/Interview/InterviewQB.cs` **Columns (from INSERT INTO):** - `INTERVIEWID` - `APPLICANTID` - `JOBPOSITIONID` - `INTERVIEWERID` - `INTERVIEWTYPEID` - `INTERVIEWDATE` - `INTERVIEWTIME` - `DURATIONMINUTES` - `LOCATIONID` - `NOTES` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `TENANTID` --- ## TKMCANDIDATE **Module:** KmsDAL | **Source:** `GB5Solution/KMS/KmsDAL/Query/KmDiscovery/KmDiscoveryQB.cs` **Columns (from INSERT INTO):** - `CANDIDATEID` - `JOBID` - `DOMAINID` - `PROPOSEDTITLE` - `PROPOSEDTYPE` - `PROPOSEDCONTENT` - `PROPOSEDTAGS` - `PROPOSEDSCOPELEVEL` - `CONFIDENCESCORE` - `SOURCECHUNKINDEX` - `SOURCECHUNKTEXT` - `LLMMODEL` - `REVIEWSTATUS` - `REVIEWEDUSERID` - `ARTIFACTID` - `VERSION` - `STATUS` - `SORTORDER` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `SOURCETYPE` - `TENANTID` --- ## TKMJOB **Module:** KmsDAL | **Source:** `GB5Solution/KMS/KmsDAL/Query/KmDiscovery/KmDiscoveryQB.cs` **Columns (from INSERT INTO):** - `JOBID` - `CONNECTORID` - `SOURCEREFERENCE` - `CONTENTHASH` - `JOBSTATUS` - `CHUNKSTOTAL` - `CHUNKSPROCESSED` - `CANDIDATESCREATED` - `VERSION` - `STATUS` - `SORTORDER` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `SOURCETYPE` - `TENANTID` --- ## TLEAVE **Module:** PayRollDAL | **Source:** `GB5Solution/PayRoll/PayRollDAL/Query/TLeave/TLeaveQB.cs` **Columns (from INSERT INTO):** - `LEAVEID` - `OUID` - `PERIODID` - `BIZTRANSACTIONTYPEID` - `LEAVENUMBER` - `LEAVEDATE` - `REFERENCENUMBER` - `REFERENCEDATE` - `REMARKS` - `NUMBEROFDAYS` - `TYPEOFLEAVE` - `REASONID` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## TLEAVEDETAIL **Module:** PayRollDAL | **Source:** `GB5Solution/PayRoll/PayRollDAL/Query/TLeave/TLeaveQB.cs` **Columns (from INSERT INTO):** - `LEAVEDETAILID` - `LEAVEID` - `SLNO` - `EMPLOYEEID` - `LEAVETYPEID` - `LEAVEDATE` - `VALIDTILL` - `NUMBEROFDAYS` - `LEAVESTATUS` - `DAYTYPE` - `MMDETAILID` --- ## TLOT **Module:** QMSDAL | **Source:** `GB5Solution/QMS/QMSDAL/Query/Matrix/MatrixQB.cs` **Columns (from INSERT INTO):** - `LOTID` - `LOTNUMBER` - `ITEMID` - `SKUID` - `LOTDATE` - `LOTEXPIRYDATE` - `REMARKS` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `PROCESSID` - `LOTTYPEID` - `MRPRATE` - `ITEMPOSTEDCOST` - `TENANTID` --- ## TLOTDETAIL **Module:** MMDAL | **Source:** `GB5Solution/MM/MMDAL/Query/StockValuation/FifoLotCostQB.cs` **Columns (from INSERT INTO):** - `LOTDETAILID` - `BIZTRANSACTIONTYPEID` - `OBJECTHEADERTYPEID` - `OBJECTHEADERID` - `OBJECTTYPEID` - `OBJECTID` - `SLNO` - `LOTID` - `QUANTITY` - `GOODQUANTITY` - `REJECTEDQUANTITY` - `REWORKQUANTITY` - `OTHERQUANTITY` - `PACKID` - `PACKQUANTITY` - `OUID` - `STOREID` - `STOCKLEDGERNUMBER` - `STOCKLEDGERDATE` - `REFERENCENUMBER` - `REFERENCEDATE` - `LOCATIONTYPE` - `PARTYBRANCHID` - `STOCKPOSTTYPE` - `MATERIALOWNERSHIPTYPE` - `USEDINLOTID` - `REASONID` - `REMARKS` - `MARKEDGOODQUANTITY` - `ITEMPOSTEDCOST` --- ## TLOYALTYLEDGER **Module:** PAYDAL | **Source:** `GB5Solution/PAY/PAYDAL/Query/Loyalty/LoyaltyLedgerQB.cs` **Columns (from INSERT INTO):** - `LOYALTYLEDGERID` - `ENROLLMENTID` - `LOYALTYPROGRAMID` - `CUSTOMERID` - `ENTRYTYPE` - `POINTS` - `REFERENCEORDERID` - `EARNCFGID` - `EXPIRYDATE` - `REMARKS` - `CREATEDBYID` - `CREATEDON` - `TENANTID` --- ## TMATRIX **Module:** QMSDAL | **Source:** `GB5Solution/QMS/QMSDAL/Query/Matrix/MatrixQB.cs` **Columns (from INSERT INTO):** - `MATRIXID` - `MATRIXCODE` - `MATRIXMODE` - `BATCHASSIGNMODE` - `ALLOCATIONID` - `MMDETAILID` - `ALLOCATIONSLNO` - `SETFROM` - `SETTO` - `FGITEMID` - `FGSKUID` - `PROCESSID` - `PROCESSGROUPID` - `OUTPUTLOTID` - `PROCESSLOTQTY` - `MATRIXSTATUS` - `SUPERSEDEDBYID` - `ACTIVATEDON` - `REMARKS` - `VERSION` - `STATUS` - `SORTORDER` - `SOURCETYPE` - `TENANTID` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## TMATRIXINPUT **Module:** QMSDAL | **Source:** `GB5Solution/QMS/QMSDAL/Query/Matrix/MatrixQB.cs` **Columns (from INSERT INTO):** - `MATRIXINPUTID` - `MATRIXID` - `SLNO` - `ITEMID` - `SKUID` - `ITEMCATEGORY` - `LOTID` - `PLANNEDQTY` - `ALLOCATEDQTY` - `CONSUMEDQTY` - `MIXPROPORTION` - `LINESTATUS` - `TENANTID` --- ## TMATRIXOUTPUT **Module:** QMSDAL | **Source:** `GB5Solution/QMS/QMSDAL/Query/Matrix/MatrixQB.cs` **Columns (from INSERT INTO):** - `MATRIXOUTPUTID` - `MATRIXID` - `SLNO` - `OUTPUTLEVEL` - `ITEMID` - `SKUID` - `LOTID` - `LOTQUANTITY` - `TENANTID` --- ## TMESSAGEHUB **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/TemplateSender/MessageHubQB.cs` **Columns (from INSERT INTO):** - `MESSAGEHUBID` - `ACTIONID` - `ACTIONTYPE` - `MAILTEMPLATEID` - `RECIPIENT` - `MESSAGETEXT` - `DELIVERYSTATUS` - `SORTORDER` - `STATUS` - `VERSION` - `SOURCETYPE` - `TENANTID` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `MODE` - `AUTHTOKEN` - `PHONENUMBERID` - `WEBHOOKURL` --- ## TMESSAGEHUBLOG **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/TemplateSender/MessageHubQB.cs` **Columns (from INSERT INTO):** - `MODE` - `RECIPIENT` - `MESSAGETEXT` - `AUTHTOKEN` - `PHONENUMBERID` - `WEBHOOKURL` - `RESPONSEDATA` - `CREATEDBYID` - `CREATEDON` --- ## TMESSAGEHUBSUPPORTREQUEST **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/JsonReplier/EIPConceptQB.cs` **Columns (from INSERT INTO):** - `CLIENTID` - `SESSIONID` - `PHONENUMBER` - `REMARKS` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## TMRPACTION **Module:** MMDAL | **Source:** `GB5Solution/MM/MMDAL/Query/MRPRun/MRPRunQB.cs` **Columns (from INSERT INTO):** - `MRPRUNID` - `SLNO` - `PLANITEMID` - `PLANSKUID` - `PLANTYPE` - `OBJECTID` - `PLANNEDSTARTDATE` - `PLANNEDORDERDATE` - `PLANNEDDUEDATE` - `PLANNEDQUANTITY` - `ORIGINALPLANNEDQUANTITY` - `INPROCESSQUANTITY` - `IMPLEMENTEDQUANTITY` - `COMPRESSIONDAYS` - `ISFIRMPLAN` - `FIRMDATE` - `FIRMQUANTITY` - `PLANNEDACTION` - `REMARKS` - `PLANSTATUS` - `STOREID` - `ALLOCATIONID` - `TASKID` - `RELEASETYPE` - `RELEASEBIZTRANSACTIONTYPEID` - `RELEASEID` - `ISALLOCATIONBASEDRELEASE` - `PARTYID` - `PARTYBRANCHID` - `ALTERNATEBOMID` - `ALERNATEROUTINGID` - `MRPRUNDETAILID` - `NESTINGPLANID` - `PRIORITY` - `SALESORDERID` - `RUNSCOPE` - `TENANTID` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `MRPACTIONID` - `RELEASEBIZ` - `ALTERNATEROUTINGID` --- ## TMRPRUN **Module:** MMDAL | **Source:** `GB5Solution/MM/MMDAL/Query/MRPRun/MRPRunQB.cs` **Columns (from INSERT INTO):** - `MRPRUNID` - `MRPID` - `MRPDATE` - `TYPE` - `RUNSCOPE` - `SCOPEOBJECTID` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## TMRPRUNDETAILS **Module:** MMDAL | **Source:** `GB5Solution/MM/MMDAL/Query/MRPRun/MRPRunQB.cs` **Columns (from INSERT INTO):** - `MRPRUNDETAILID` - `MRPRUNID` - `PLANITEMID` - `PLANSKUID` - `SLNO` - `DEMANDTYPE` - `LEVEL` - `LOWLEVELCODE` - `REQUIREDPERIOD` - `TOTALGROSSREQUIREMENT` - `INDEPENDENTPLANDEMAND` - `INDEPENDENTCUSTOMERORDER` - `DEPENDENTPLANDEMAND` - `DEPENDENTCUSTOMERORDER` - `ALLOCATION` - `SCHEDULEDRECEIPTS` - `PROJECTEDSOH` - `SOH` - `WIP` - `NETREQUIREMENT` - `PLANNEDORDERRECEIPTS` - `PLANNEDORDERRELEASES` - `LEADTIME` - `TENANTID` --- ## TMRPRUNSTATUS **Module:** MMDAL | **Source:** `GB5Solution/MM/MMDAL/Query/MRPRun/MRPRunQB.cs` **Columns (from INSERT INTO):** - `MRPRUNSTATUSID` - `MRPRUNID` - `STATUS` - `PROGRESSPERCENT` - `CURRENTSTEP` - `ERRORMESSAGE` - `STARTEDAT` - `COMPLETEDAT` - `TENANTID` --- ## TMTRLOT **Module:** MMDAL | **Source:** `GB5Solution/MM/MMDAL/Query/MTR/MtrQB.cs` **Columns (from INSERT INTO):** - `MTRLOTID` - `MTRID` - `SLNO` - `HEATID` - `LOTID` - `LOTREFERENCE` - `QUANTITY` - `UOMID` - `MATERIALSPEC` - `LOTRESULT` - `TENANTID` --- ## TMTRREPORT **Module:** MMDAL | **Source:** `GB5Solution/MM/MMDAL/Query/MTR/MtrQB.cs` **Columns (from INSERT INTO):** - `MTRID` - `MTRNO` - `MTRDATE` - `DOCUMENTID` - `DOCUMENTDETAILID` - `INDENTID` - `PARTYID` - `PARTYBRANCHID` - `REFERENCENUMBER` - `REFERENCEDATE` - `ITEMID` - `SKUID` - `TOTALQTY` - `UOMID` - `MTRTYPEID` - `OVERALLRESULT` - `REMARKS` - `REPORTSTATUS` - `PARENTMTRID` - `ISSUEDBYID` - `ISSUEDON` - `TENANTID` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## TMTRSOURCE **Module:** MMDAL | **Source:** `GB5Solution/MM/MMDAL/Query/MTR/MtrQB.cs` **Columns (from INSERT INTO):** - `MTRSOURCEID` - `MTRLOTID` - `SOURCETYPEID` - `SOURCERECORDID` - `SUMMARYTEXT` - `DISPLAYORDER` - `INCLUDEINPDF` - `DETAILLEVEL` --- ## TNDTCERTIFICATE **Module:** MMDAL | **Source:** `GB5Solution/MM/MMDAL/Query/NDTCertificate/NDTCertificateQB.cs` **Columns (from INSERT INTO):** - `NDTCERTIFICATEID` - `NDTREPORTID` - `NDTAGENCYID` - `CERTIFICATENO` - `CERTIFICATEDATE` - `INSPECTORNAME` - `INSPECTORLEVEL` - `AGENCYCERTIFICATENO` - `VALIDUPTO` - `ATTACHMENTID` - `VERIFIEDBYID` - `VERIFIEDON` - `REMARKS` - `SORTORDER` - `STATUS` - `VERSION` - `SOURCETYPE` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `TENANTID` --- ## TNDTCONDITIONPARAM **Module:** MMDAL | **Source:** `GB5Solution/MM/MMDAL/Query/NDTReport/NDTReportQB.cs` **Columns (from INSERT INTO):** - `NDTREPORTID` - `SLNO` - `METHODPARAMID` - `NUMVALUE` - `TEXTVALUE` - `SELECTVALUE` - `BOOLVALUE` - `DATETIMEVALUE` - `REMARKS` --- ## TNDTITEMRESULT **Module:** MMDAL | **Source:** `GB5Solution/MM/MMDAL/Query/NDTReport/NDTReportQB.cs` **Columns (from INSERT INTO):** - `NDTREPORTID` - `SLNO` - `ITEMID` - `SKUID` - `PONO` - `PODATE` - `ITEMDESCRIPTION` - `MATERIALGRADE` - `HEATCODE` - `DATECODE` - `SERIALNUMBER` - `CAVITYNO` - `QTY` - `RESULT` - `RESULTTEXT` - `INDICATIONDETAIL` - `REMARKS` --- ## TNDTREPORT **Module:** MMDAL | **Source:** `GB5Solution/MM/MMDAL/Query/NDTReport/NDTReportQB.cs` **Columns (from INSERT INTO):** - `OUID` - `PERIODID` - `BIZTRANSACTIONID` - `NDTMETHODID` - `PARAMETERSET` - `REPORTNO` - `REPORTDATE` - `REFERENCENO` - `REFERENCEDATE` - `TESTDATE` - `CUSTOMERID` - `HEATID` - `NDTOBJECTTYPEID` - `NDTOBJECTID` - `STAGEOFTESTID` - `SURFACECONDITIONID` - `ACCEPTANCESTANDARDID` - `PROCEDUREREFERENCE` - `TESTSTARTDATETIME` - `TESTENDDATETIME` - `TOTALTESTHOURS` - `ISTHIRDPARTY` - `NDTAGENCYID` - `TESTEDBYID` - `WITNESSEDBYID` - `APPROVEDBYID` - `CERTIFICATIONLEVEL` - `OVERALLRESULT` - `REMARKS` - `SORTORDER` - `STATUS` - `VERSION` - `SOURCETYPE` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `TENANTID` --- ## TNOTIFICATION **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/DataAlert/ObservabilityAlertQB.cs` **Columns (from INSERT INTO):** - `FROMUSERID` - `MESSAGE` - `EVENTLOGID` - `DATAID` - `CREATEDON` - `MODIFIEDON` - `NOTIFICATIONID` --- ## TNOTIFICATIONTO **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/DataAlert/ObservabilityAlertQB.cs` **Columns (from INSERT INTO):** - `NOTIFICATIONID` - `TOUSERID` - `NOTIFICATIONSTATUS` --- ## TOUTBOX **Module:** Unknown | **Source:** `GB5Shared/Query/OutBox/OutBoxQB.cs` **Columns (from INSERT INTO):** - `OBJECTTYPEID` - `OBJECTID` - `EVENTTYPEID` - `VERSION` - `CORRELATIONKEY` - `USERID` - `TENANTID` - `PAYLOAD` - `STATUS` - `CREATEDON` - `HEADERROWGUID` --- ## TPARTALLOCATION **Module:** MMDAL | **Source:** `GB5Solution/MM/MMDAL/Query/PartLevel/PartAllocationQB.cs` **Columns (from INSERT INTO):** - `PARTALLOCATIONID` - `PARTDETAILID` - `LOTID` - `LOTDETAILID` - `ALLOCATEDQTY` - `ISSUEDQTY` - `CONSUMEDQTY` - `STATUS` - `TENANTID` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## TPARTDETAIL **Module:** MMDAL | **Source:** `GB5Solution/MM/MMDAL/Query/PartLevel/PartDetailQB.cs` **Columns (from INSERT INTO):** - `PARTDETAILID` - `ENTITYTYPEID` - `ENTITYID` - `ENTITYDETAILID` - `PARENTPARTDETAILID` - `ROOTPARTDETAILID` - `ITEMID` - `SKUID` - `PARTDIMID` - `REQUIREDQTY` - `REQUIREDNUMBERS` - `ALLOCATIONID` - `PEGGINGGROUPID` - `SALESORDERID` - `PRIORITY` - `PLANNEDSTARTDATE` - `PLANNEDDUEDATE` - `WIPSTOCK` - `AVAILABLETOWORK` - `STATUS` - `TENANTID` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## TPARTPOSITION **Module:** MMDAL | **Source:** `GB5Solution/MM/MMDAL/Query/PartLevel/PartPositionQB.cs` **Columns (from INSERT INTO):** - `PARTPOSITIONID` - `ITEMID` - `PARTDIMID` - `STOREID` - `LOTID` - `AVAILABLE` - `RESERVED` - `ISSUED` - `TENANTID` --- ## TPAYORDER **Module:** PAYDAL | **Source:** `GB5Solution/PAY/PAYDAL/Query/Order/PayOrderQB.cs` **Columns (from INSERT INTO):** - `PAYORDERNO` - `SOURCEDOCTYPE` - `SOURCEDOCID` - `CUSTOMERID` - `CUSTOMERNAME` - `CUSTOMEREMAIL` - `CUSTOMERPHONE` - `ORDERCURRENCY` - `ORDERAMT` - `BASECURRENCY` - `BASEAMT` - `EXCHANGERATE` - `COUPONDISCAMT` - `LOYALTYDISCAMT` - `NETPAYABLEAMT` - `PAYGATEWAYCONFID` - `GATEWAYPAYORDERID` - `ORDERSTATUS` - `PAIDAMT` - `EXPIRESON` - `VOUCHERID` - `REMARKS` - `VERSION` - `STATUS` - `SORTORDER` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `SOURCETYPE` - `TENANTID` --- ## TPAYPRODUCTION **Module:** PayRollDAL | **Source:** `GB5Solution/PayRoll/PayRollDAL/Query/PayProduction/PayProductionQB.cs` **Columns (from INSERT INTO):** - `PAYPRODUCTIONID` - `OUID` - `PERIODID` - `BIZTRANSACTIONTYPEID` - `PAYPRODUCTIONNUMBER` - `PAYPRODUCTIONDATE` - `REFERENCENUMBER` - `SHIFTID` - `PARTICULARS` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## TPAYPRODUCTIONDETAIL **Module:** PayRollDAL | **Source:** `GB5Solution/PayRoll/PayRollDAL/Query/PayProduction/PayProductionQB.cs` **Columns (from INSERT INTO):** - `PAYPRODUCTIONDETAILID` - `PAYPRODUCTIONID` - `SLNO` - `EMPLOYEEID` - `PROCESSID` - `ITEMID` - `SKUID` - `MACHINEID` - `QUANTITY` - `RATE` - `RATEPER` - `AMOUNT` - `REMARKS` --- ## TPAYREVISION **Module:** PayRollDAL | **Source:** `GB5Solution/PayRoll/PayRollDAL/Query/PayRevision/PayRevisionQB.cs` **Columns (from INSERT INTO):** - `BIZTRANSACTIONTYPEID` - `PAYREVISIONNUMBER` - `REVISIONDATE` - `PAYREFERENCENUMBER` - `REFERENCEDATE` - `APPLICABLE` - `EMPLOYEEID` - `OUID` - `PAYCONFIGURATIONID` - `DAGROUPID` - `EFFECTIVEFROM` - `EFFECTIVETO` - `REMARKS` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `PAYGROUPID` - `NATURE` - `C2C` - `COSTPERHOUR` - `RATEPERHOUR` - `SOURCETYPE` - `FUNCTIONALREPORTINGTOID` - `ADMINREPORTINGTOID` --- ## TPAYTRANSACTION **Module:** PAYDAL | **Source:** `GB5Solution/PAY/PAYDAL/Query/Order/PayTransactionQB.cs` **Columns (from INSERT INTO):** - `PAYORDERID` - `GATEWAYTXNID` - `PAYMENTMETHOD` - `PAYMENTMETHODDETAIL` - `TXNCURRENCY` - `TXNAMT` - `TXNSTATUS` - `GATEWAYRESPONSECODE` - `GATEWAYRESPONSEMSG` - `GATEWAYRAWRESPONSE` - `TXNINITIATEDON` - `TXNCOMPLETEDON` - `PARENTTXNID` - `REMARKS` - `VERSION` - `STATUS` - `SORTORDER` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `SOURCETYPE` - `TENANTID` --- ## TPAYWEBHOOKEVENT **Module:** PAYDAL | **Source:** `GB5Solution/PAY/PAYDAL/Query/Webhook/PayWebhookEventQB.cs` **Columns (from INSERT INTO):** - `PAYGATEWAYID` - `IDEMPOTENCYKEY` - `EVENTTYPE` - `GATEWAYPAYORDERID` - `GATEWAYTXNID` - `RAWPAYLOAD` - `SIGNATUREVALID` - `ISPROCESSED` - `PROCESSEDON` - `PROCESSINGERROR` - `CREATEDBYID` - `CREATEDON` - `TENANTID` --- ## TPCSCARD **Module:** QMSDAL | **Source:** `GB5Solution/QMS/QMSDAL/Query/PcsCard/PcsCardQB.cs` **Columns (from INSERT INTO):** - `PCSCARDID` - `OUID` - `PERIODID` - `BIZTRANSACTIONTYPEID` - `CARDNO` - `INDENTID` - `INDENTDETAILID` - `ITEMID` - `SKUID` - `ROUTINGID` - `ROUTINGVERSIONID` - `SERIALNO` - `CUSTOMERSERIAL` - `SETSLNO` - `CUSTOMERID` - `PROJECTNAME` - `CUSTOMERPO` - `PLANNEDQUANTITY` - `UOMID` - `COLOURCODE` - `DRAWINGNO` - `DRAWINGREV` - `PLANNEDSTART` - `PLANNEDEND` - `ACTUALSTART` - `ACTUALEND` - `TOTALSTAGES` - `COMPLETEDSTAGES` - `CURRENTSTAGE` - `OVERALLSTATUS` - `OVERALLRESULT` - `REMARKS` - `VERSION` - `STATUS` - `SORTORDER` - `TENANTID` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `SOURCETYPE` --- ## TPCSCARDMATERIAL **Module:** QMSDAL | **Source:** `GB5Solution/QMS/QMSDAL/Query/PcsCardMaterial/PcsCardMaterialQB.cs` **Columns (from INSERT INTO):** - `PCSCARDMATERIALID` - `PCSCARDSTAEID` - `SLNO` - `ITEMID` - `MATERIALNAME` - `GRADECODE` - `BATCHNO` - `LOTID` - `QUANTITY` - `UOMID` - `DATEOFMANUFACTURE` - `DATEOPENED` - `DATEOFEXPIRY` - `ISEXPIRED` - `REMARKS` --- ## TPCSCARDSTAGE **Module:** QMSDAL | **Source:** `GB5Solution/QMS/QMSDAL/Query/PcsCardStage/PcsCardStageQB.cs` **Columns (from INSERT INTO):** - `PCSCARDSTAEID` - `PCSCARDID` - `ROUTINGDETAILID` - `STAGENO` - `STAGECODE` - `STAGENAME` - `STAGEGROUP` - `REQUIRESSUPERVISOR` - `REQUIRESMATERIALLOG` - `ALLOWQUANTITY` - `CHECKLISTID` - `PLANNEDSTART` - `PLANNEDEND` - `ACTUALSTART` - `ACTUALEND` - `OPERATORID` - `SUPERVISORID` - `SUPERVISOREDON` - `GOODQUANTITY` - `REWORKQUANTITY` - `REJECTEDQUANTITY` - `OTHERQUANTITY` - `CHECKLISTLOGID` - `STAGESTATUS` - `STAGERESULT` - `REMARKS` --- ## TPEGGING **Module:** MMDAL | **Source:** `GB5Solution/MM/MMDAL/Query/MRPRun/MRPRunQB.cs` **Columns (from INSERT INTO):** - `PEGGINGID` - `MRPACTIONID` - `MRPRUNDETAILID` - `PEGGEDQUANTITY` - `PRIORITY` - `TENANTID` --- ## TPROFILEGENERATOR **Module:** RecruitmentDAL | **Source:** `GB5Solution/Recruitment/RecruitmentDAL/Query/ProfileGenerator/ProfileGeneratorQB.cs` **Columns (from INSERT INTO):** - `POSITIONID` - `DEPARTMENTID` - `LEVELID` - `INDUSTRYCONTEXT` - `ADDITIONALCONTEXT` - `JOBDESCRIPTION` - `KPIS` - `TECHNICALSKILLS` - `SOFTSKILLS` - `DOMAINSKILLS` - `TECHNICALQUESTIONS` - `MANAGERIALQUESTIONS` - `SITUATIONALQUESTIONS` - `PSYCHOMETRICTOOLS` - `EXPERIENCEQUALIFICATIONS` - `TENANTID` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `SORTORDER` - `STATUS` - `VERSION` --- ## TPUNCH **Module:** PayRollDAL | **Source:** `GB5Solution/PayRoll/PayRollDAL/Query/Punch/PunchQB.cs` **Columns (from INSERT INTO):** - `EMPLOYEEID` - `ATTENDANCEDATE` - `PUNCHDATE` - `PUNCHTIME` - `PUNCHSTATUS` - `BIOMETRIC` - `VERIFICATIONSTATUS` - `GEOCODE` - `PUNCHTYPE` - `ADDITIONALINFORMATION` - `SITETYPE` - `SITEID` - `GEOLOCATION` - `DEVICEID` - `ORIGINALPUNCHTIME` - `REASONID` - `RECORDTYPE` - `GEODISTANCE` --- ## TRESOURCEPLAN **Module:** MMDAL | **Source:** `GB5Solution/MM/MMDAL/Query/Scheduling/SchedulingRunQB.cs` **Columns (from INSERT INTO):** - `RESOURCEPLANID` - `INDENTDETAILID` - `MACHINEID` - `WORKCENTERID` - `PROCESSID` - `PLANNEDQUANTITY` - `SCHEDULEDSTARTDATE` - `SCHEDULEDENDDATE` - `RESOURCEPLANCOMBINEID` - `PARALLELNUMBER` - `ISINTERRUPTIBLE` - `SCHEDULINGRUNID` - `ISLOCKED` - `PARTICULARS` - `PLANNATURE` - `RESOURCELEVEL` - `MOUNTINGTASKID` - `RESOURCESEQUENCE` - `TENANTID` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## TR_MADDRESS **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/TRMAddress/TRMAddressQB.cs` **Columns (from INSERT INTO):** - `ADDRESSTRANSLATIONID` - `LANGUAGEID` - `ADDRESSID` - `ADDRESSLINE1` - `ADDRESSLINE2` - `ADDRESSLINE3` - `ADDRESSLINE4` - `ADDRESSLINE5` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `SORTORDER` - `STATUS` - `VERSION` - `SOURCETYPE` - `TENANTID` --- ## TR_MEMPLOYEE **Module:** PayRollDAL | **Source:** `GB5Solution/PayRoll/PayRollDAL/Query/TRMEmployee/TRMEmployeeQB.cs` **Columns (from INSERT INTO):** - `LANGUAGEID` - `EMPLOYEEID` - `EMPLOYEENAME` - `FATHERNAME` - `MOTHERNAME` - `SPOUSENAME` - `FIRSTNAME` - `MIDDLENAME` - `LASTNAME` - `SORTORDER` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `SOURCETYPE` - `TENANTID` --- ## TSCHEDULER **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/Scheduler/SchedulerQB.cs` **Columns (from INSERT INTO):** - `SCHEDULERID` - `CRONEXPRESSION` - `SCHEDULERNAME` - `REMARKS` - `SELECTEDMONTH` - `SELECTEDDAYS` - `DATETYPE` - `SELECTEDDATES` - `OCCURENCENO` - `OCCURENCEDAY` - `EVERYNOOFMONTHS` - `EVERYNOOFDAYS` - `TIMERANGETYPE` - `EVERYNOOFHOURS` - `EVERYNOOFMINUTES` - `OCCURSATTIME` - `OCCURSATMULTIPLETIME` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `SOURCETYPE` --- ## TSCHEDULINGRUNLOG **Module:** MMDAL | **Source:** `GB5Solution/MM/MMDAL/Query/Scheduling/SchedulingRunQB.cs` **Columns (from INSERT INTO):** - `SCHEDULINGRUNID` - `TENANTID` - `TRIGGEREDBYUSERID` - `HORIZONFROMDATE` - `HORIZONTODATE` - `MACHINESSCHEDULED` - `UTILIZATIONPCT` - `DURATIONMS` - `STATUS` - `ERRORMESSAGE` - `RCCPJSON` - `STARTEDAT` - `COMPLETEDAT` --- ## TSERVICEREQUEST **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/ServiceRequest/ServiceRequestQB.cs` **Columns (from INSERT INTO):** - `SERVICEREQUESTTYPEID` - `OUID` - `BIZTRANSACTIONTYPEID` - `TITLE` - `SERVICEREQUESTNUMBER` - `SERVICEREQUESTDATE` - `REFERENCENUMBER` - `REFERENCEDATE` - `DESCRIPTION` - `REQUESTEDBYID` - `ASSIGNEDTOID` - `PRIORITY` - `CRITICALITY` - `REQUESTSTATUS` - `CUSTOMDATA` - `SLARESPONSEDUE` - `SLARESOLUTIONDUE` - `FIRSTRESPONSEAT` - `RESOLVEDAT` - `CLOSEDAT` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `SORTORDER` - `STATUS` - `VERSION` - `SOURCETYPE` - `TENANTID` --- ## TSERVICEREQUESTFIELD **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/ServiceRequestField/ServiceRequestFieldQB.cs` **Columns (from INSERT INTO):** - `SERVICEREQUESTID` - `FIELDNAME` - `FIELDDATATYPE` - `FIELDDATE` - `FIELDTEXT` - `FIELDVALUE` - `FIELDID` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `SORTORDER` - `STATUS` - `VERSION` - `SOURCETYPE` - `TENANTID` --- ## TSHOW **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/TourShow/TourShowQB.cs` **Columns (from INSERT INTO):** - `SPACEID` - `SHOWNATURE` - `SHOWNAME` - `DISPLAYNAME` - `DESCRIPTION` - `OBJECTIVE` - `MODULEID` - `CONTENTCATEGORYID` - `CONDITIONTYPE` - `SHOWCONDITIONS` - `STARTTYPE` - `SHOWTYPE` - `REMEMBERSTAGE` - `DISPLAYPROGRESS` - `TAGS` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `SORTORDER` - `STATUS` - `VERSION` - `SOURCETYPE` - `TENANTID` - `PRIORITY` - `THEME` - `AUTOADVANCE` - `DISPLAYPOSITION` - `DISPLAYDURATION` - `STARTDATE` - `EXPIRYDATE` - `ISSHOWTEMPLATE` - `USERGROUPID` - `CHANNELID` - `SUBSCRIPTIONTYPEID` - `APPROVALSTATUS` - `APPROVEDON` - `APPROVEDBYID` --- ## TSHOWRUN **Module:** EnablementDAL | **Source:** `GB5Solution/Enablement/EnablementDAL/Query/Show/ShowRunQB.cs` **Columns (from INSERT INTO):** - `SHOWRUNID` - `SHOWID` - `USERID` - `REQUESTID` - `RUNSTATE` - `STARTEDBY` - `CURRENTSTEPID` - `STARTEDON` - `TRIGGERSNAPSHOT` - `VERSION` - `STATUS` - `SORTORDER` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `SOURCETYPE` - `DATABASENAME` --- ## TSHOWRUNSTEP **Module:** EnablementDAL | **Source:** `GB5Solution/Enablement/EnablementDAL/Query/Show/ShowRunQB.cs` **Columns (from INSERT INTO):** - `SHOWRUNID` - `SLNO` - `STEPID` - `STEPSTATE` - `ACTIONTAKEN` - `ACTIONPAYLOAD` - `TIMESPENTONMS` - `STEPPEDON` --- ## TSHOWSTEP **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/TourShow/TourShowQB.cs` **Columns (from INSERT INTO):** - `SHOWID` - `STEPNAME` - `STEPTYPE` - `STEPTEXT` - `MENUID` - `CONTENTID` - `STEPORDER` - `ISSTEPTEMPLATE` - `STEPDURATION` - `ISACTIVE` - `CONTENT` - `METADATA` --- ## TSHOWSTEPDETAIL **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/TourShow/TourShowQB.cs` **Columns (from INSERT INTO):** - `SHOWSTEPID` - `ACTIONTYPE` - `BUTTONTEXT` - `BUTTONSTYLE` - `ACTIONORDER` - `TARGETSTEPID` - `WAITTIME` - `CONDITION` - `ISDEFAULT` --- ## TSTOCKACCOUNTPOSTDETAIL **Module:** MMDAL | **Source:** `GB5Solution/MM/MMDAL/Query/StockValuation/StockAccountPostQB.cs` **Columns (from INSERT INTO):** - `STOCKACCOUNTPOSTDETAILID` - `OUID` - `OBJECTTYPEID` - `OBJECTID` - `OBJECTDETAILID` - `ITEMID` - `SKUID` - `POSTINGTYPE` - `POSTEDVALUE` - `GLACCOUNT` - `POSTINGSTATUS` - `CREATEDON` --- ## TSTOCKPOSITION **Module:** MMDAL | **Source:** `GB5Solution/MM/MMDAL/Query/StockValuation/StockPositionQB.cs` **Columns (from INSERT INTO):** - `OUID` - `STOREID` - `ITEMID` - `SKUID` - `QUANTITY` - `SHADOWQUANTITY` - `REJECTEDQUANTITY` - `REWORKQUANTITY` - `OTHERQUANTITY` - `WIPQUANTITY` - `UNLINKEDWIPGOODQUANTITY` - `UNLINKEDWIPREWORKQUANTITY` - `AVERAGEVALUE` - `AVERAGECOST` --- ## TSTOCKVALUATIONRUN **Module:** MMDAL | **Source:** `GB5Solution/MM/MMDAL/Query/StockValuation/StockValuationQB.cs` **Columns (from INSERT INTO):** - `STOCKVALUATIONRUNID` - `OUID` - `RUNTYPE` - `PERIODFROM` - `PERIODTO` - `STOREID` - `ITEMID` - `ITEMCATEGORYID` - `ITEMSUBCATEGORYID` - `VALUATIONMETHODS` - `STATUS` - `STARTEDAT` - `CREATEDBYID` - `CREATEDON` --- ## TSUPPORT_TOKEN **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/DiagnosticsSession/DiagnosticsSessionQB.cs` **Columns (from INSERT INTO):** - `TOKEN` - `DIAGNOSTICSESSIONID` - `ISSUEDTO` - `CAPABILITIES` - `EXPIRESAT` - `ISACTIVE` - `CREATEDBYID` - `TENANTID` - `SUPPORTTOKENID` --- ## TSYSJOB **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/SystemJob/SystemJobQB.cs` **Columns (from INSERT INTO):** - `SYSJOBID` - `SYSJOBTYPE` - `MENUID` - `WEBSERVICEID` - `PARAMETERS` - `SUBMITTEDBYID` - `SUBMITTEDON` - `RUNSTATUS` - `PRIORITY` - `RETRYCOUNT` - `MAXRETRIES` - `QUEUENAME` - `LASTUPDATE` - `PINNED` - `PUBLISH` - `RESULTLOCATION` - `RESULTFORMAT` - `STARTTIME` - `ENDTIME` - `EXPIRYAT` - `ERRORMESSAGE` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `SORTORDER` - `STATUS` - `VERSION` - `SOURCETYPE` - `TENANTID` --- ## TSYSJOBRUN **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/SysJobRun/SysJobRunQB.cs` **Columns (from INSERT INTO):** - `SYSJOBRUNID` - `SYSJOBID` - `STARTEDAT` - `ENDEDAT` - `STATUS` - `LOG` - `WORKER` - `RUNIDENTIFIER` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `SORTORDER` - `VERSION` - `SOURCETYPE` - `TENANTID` --- ## TSYSJOBSHARE **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/SysJobShare/SysJobShareQB.cs` **Columns (from INSERT INTO):** - `SYSJOBSHAREID` - `SYSJOBID` - `SHAREDWITHUSERID` - `CANEXECUTE` - `CANVIEWRESULT` - `SHAREDBYID` - `SHAREDON` - `TENANTID` --- ## TTASK **Module:** MMDAL | **Source:** `GB5Solution/MM/MMDAL/Query/Scheduling/SchedulingRunQB.cs` **Columns (from INSERT INTO):** - `TASKID` - `TASKTYPE` - `BIZTRANSACTIONTYPEID` - `OUID` - `PERIODID` - `TASKNUMBER` - `TASKDATE` - `REFERENCENUMBER` - `REFERENCEDATE` - `TASKNAME` - `TASKDESCRIPTION` - `DETAILTYPE` - `TASKNATURE` - `PARTYBRANCHID` - `ASSETID` - `RESOURCEID` - `MACHINEID` - `ACTIVITYID` - `REQUESTEDBYID` - `INCHARGEID` - `ALLOCATIONID` - `PARENTTASKID` - `WORKTYPEID` - `SLNO` - `WBCCODE` - `WBCLEVEL` - `ASSIGNEDTOTYPE` - `ASSIGNEDTOROLEID` - `ASSIGNEDTOUSERID` - `ASSIGNEDTOUSERGROUPID` - `TASKSTATUS` - `TAGS` - `PLANNEDDAYS` - `PLANNEDHOURS` - `PREDECESSORID` - `PLANSTARTON` - `PLANENDON` - `DUEON` - `EXPIRYTIME` - `EXPIREON` - `GRACETIME` - `CRITICALITY` - `PRIORITY` - `ACTUALSTARTON` - `ACTUALENDON` - `ACTUALDAYS` - `ACTUALHOURS` - `COMPLETEDPERCENTAGE` - `REMARKS` - `STATUS` - `VERSION` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `HEADERTASKID` - `CALLID` - `ASSIGNEDTOEMPLOYEEID` - `ASSIGNEDTOWORKTYPEID` - `ISTODO` - `ASSIGNEDTOCONTACTID` - `ORIGINALPLANNEDHOURS` - `ORIGINALPLANNEDDATE` - `ROLLUPTYPE` - `BUDGETCOST` - `BUDGETREVENUE` - `ACTUALCOST` - `LEADID` - `PLANNUMBEROFDATA` - `ACTUALNUMBEROFDATA` - `COMPLEXITYID` - `OBJECTTYPEID` - `OBJECTID` - `WORKTYPEDETAILID` - `PARAMETERSETID` - `PRECHECKLISTID` - `POSTCHECKLISTID` - `REVIEWCHECKLISTID` - `FORMTEMPLATEID` - `BOMID` - `BORID` - `VEHICLEID` - `ALLOCATIONSPLITID` - `PROJECTSEQUENCE` - `RESOURCESEQUENCE` - `ISBILLABLE` - `ISREWORK` - `TASKSTARTDATE` - `TASKENDDATE` - `TENANTID` --- ## TTCMSDEFECT **Module:** TCMSDAL | **Source:** `GB5Solution/TCMS/TCMSDAL/QueryBuilders/TCMSDefectQB.cs` **Columns (from INSERT INTO):** - `TITLE` - `MODULEID` - `ENTITY` - `OPERATION` - `STEPSTOPRODUCE` - `EXPECTEDRESULT` - `ACTUALRESULT` - `PRIORITY` - `ROOTCAUSEPATTERNID` - `REQUIRESRCA` - `STATUS` - `LINKEDTESTCASEID` - `TENANTID` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## TTCMSDEFECTPATTERN **Module:** TCMSDAL | **Source:** `GB5Solution/TCMS/TCMSDAL/QueryBuilders/TCMSDefectQB.cs` **Columns (from INSERT INTO):** - `PATTERNCODE` - `DESCRIPTION` - `ISACTIVE` - `TENANTID` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` --- ## TTCMSRUNRESULT **Module:** TCMSDAL | **Source:** `GB5Solution/TCMS/TCMSDAL/QueryBuilders/TCMSTestRunQB.cs` **Columns (from INSERT INTO):** - `TESTRUNID` - `TESTCASEID` - `RESULT` - `FAILUREREASON` - `SCREENSHOT` - `NOTES` - `EXECUTIONMS` - `EXECUTEDBY` - `EXECUTEDAT` - `TENANTID` --- ## TTCMSTESTRUN **Module:** TCMSDAL | **Source:** `GB5Solution/TCMS/TCMSDAL/QueryBuilders/TCMSTestRunQB.cs` **Columns (from INSERT INTO):** - `RUNCODE` - `RUNNAME` - `PROJECTID` - `MODULEID` - `RUNTYPE` - `SUITETYPE` - `STATUS` - `LEADEXECUTOR` - `SCHEDULEDSTART` - `SCHEDULEDEND` - `TENANTID` - `CREATEDBY` - `CREATEDDATE` --- ## TTESTENVRESETLOG **Module:** TCMSDAL | **Source:** `GB5Solution/TCMS/TCMSDAL/QueryBuilders/TCMSTestEnvQB.cs` **Columns (from INSERT INTO):** - `SERVERCONFIGID` - `CONNECTIONNAME` - `CONTROLSOURCE` - `TRIGGEREDBY` - `TRIGGEREDON` - `DURATIONMS` - `SUCCESS` - `ERRORMESSAGE` - `RESETLOGID` --- ## TTIMESLIP **Module:** PayRollDAL | **Source:** `GB5Solution/PayRoll/PayRollDAL/Query/TimeSlip/TimeSlipQB.cs` **Columns (from INSERT INTO):** - `TIMESLIPID` - `BIZTRANSACTIONTYPEID` - `OUID` - `PERIODID` - `TIMESLIPNUMBER` - `TIMESLIPDATE` - `EMPLOYEEID` - `ATTENDANCEDATE` - `SHIFTID` - `TYPE` - `FROMTIME` - `TOTIME` - `DURATION` - `REASON` - `APPROVEDBYID` - `VERSION` - `STATUS` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `TIMESLIPSTARTTIME` - `TIMESLIPENDTIME` - `ONDUTYLOCATION` - `MMDETAILID` - `REASONID` --- ## TVISITORPASS **Module:** PayRollDAL | **Source:** `GB5Solution/PayRoll/PayRollDAL/Query/VisitorPass/VisitorPassQB.cs` **Columns (from INSERT INTO):** - `VISITORPASSID` - `BIZTRANSACTIONTYPEID` - `OUID` - `PERIODID` - `PASSNUMBER` - `PASSDATE` - `PASSTYPE` - `APPROVEDBYID` - `VALIDFROMDATE` - `VALIDFROMTIME` - `VALIDTODATE` - `VALIDTOTIME` - `PAX` - `PARTYID` - `PARTYNAME` - `PARTYADDRESS` - `VISITORID` - `VISITORNAME` - `PURPOSE` - `DEPARTMENTID` - `EMPLOYEEID` - `VERSION` - `STATUS` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `DEFAULTCMSID` - `VISITORTYPEID` - `VISITORPURPOSEID` - `REMARKS` - `CONTACTIDS` - `PARTYBRANCHLOCATIONID` - `LOCATIONNAME` --- ## TVISITORPASSDETAIL **Module:** PayRollDAL | **Source:** `GB5Solution/PayRoll/PayRollDAL/Query/VisitorPass/VisitorPassQB.cs` **Columns (from INSERT INTO):** - `VISITORPASSDETAILID` - `VISITORPASSID` - `DETAILTYPE` - `SLNO` - `PARTICULARS` - `REMARKS` - `APPLICABLETYPE` - `LOCATION` --- ## TVISITORPUNCH **Module:** PayRollDAL | **Source:** `GB5Solution/PayRoll/PayRollDAL/Query/VisitorPass/VisitorPassQB.cs` **Columns (from INSERT INTO):** - `VISITORPUNCHID` - `VISITORPASSID` - `PUNCHINDATE` - `PUNCHINTIME` - `VEHICLETYPEID` - `VEHICLEID` - `LAPTOPDETAIL` - `CAMERADETAIL` - `CARDNUMBER` - `PUNCHOUTDATE` - `PUNCHOUTTIME` - `REMARKS` - `STARTON` - `ENDON` - `STARTBYID` - `ENDBYID` - `MEETSTATUS` --- ## WI **Module:** WiDAL | **Source:** `GB5Solution/WorkInstruction/WiDAL/Query/Wi/WorkstationConfigQB.cs` **Columns (from INSERT INTO):** - `WIASSIGNMENTID` - `WIID` - `ROUTINGID` - `ROUTINGOPERATIONID` - `WORKCENTERID` - `WORKSTATIONID` - `PRODUCTFAMILYID` - `MODELID` - `LINEID` - `SPECIFICITYSCORE` - `EFFECTIVEFROM` - `EFFECTIVETO` - `REMARKS` - `ISACTIVE` - `VERSION` - `STATUS` - `SORTORDER` - `CREATEDBYID` - `CREATEDON` - `MODIFIEDBYID` - `MODIFIEDON` - `SOURCETYPE` - `TENANTID` - `WIASSIGNMENTNAME` - `WIACTIVITYSCHEDULEID` - `ACTIVITYTYPE` - `TRIGGEREVENT` - `TRIGGERFREQUENCYN` - `EXECUTIONORDER` - `ISBLOCKINGNEXT` - `REQUIRESSUPERVISOR` - `ALLOWSKIP` - `WIACKNOWLEDGEMENTID` - `EMPLOYEEID` - `WORKORDERID` - `WIVERSION` - `ACKNOWLEDGEDON` - `DEVICECONTEXT` - `ISVALID` - `WISECTIONID` - `SLNO` - `SECTIONTITLE` - `DESCRIPTION` - `WISTEPID` - `STEPDISPLAYNO` - `STEPTITLE` - `WARNINGLEVEL` - `STDDURATIONSECS` - `TOOLSREQUIRED` - `ISOPTIONAL` - `REQUIRESIGNOFF` - `AUTOADVANCESECS` - `WISTEPCONTENTID` - `CONTENTTYPE` - `CONTENTSOURCE` - `CONTENTREF` - `MEDIACAPTION` - `DISPLAYDURATIONSECS` - `LOOPMEDIA` - `ZOOMREGION` - `APPLICABLEMODELIDS` - `WISKILLREQUIREMENTID` - `SKILLID` - `MINLEVELNO` - `ENFORCEMENT` - `ISMANDATORY` - `WICOMPETENCYREQUIREMENTID` - `COMPETENCYID` - `WIPROCESSID` - `WIPROCESSCODE` - `WIPROCESSNAME` - `DEPARTMENTID` - `DISPLAYORDER` - `CONTENTID` - `WISUBPROCESSID` - `WISUBPROCESSCODE` - `WISUBPROCESSNAME` - `WISTATUS` - `CHANGESUMMARY` - `CHANGEDBYID` - `REVIEWEDBYID` - `APPROVEDBYID` - `PUBLISHEDON` - `ARCHIVEDON` - `ISCURRENT` - `WORKSTATIONCONFIGID` - `WORKSTATIONCODE` - `DISPLAYMODE` - `STEPADVANCEMODE` - `FONTSCALE` - `SHOWSTEPTIMER` - `SHOWCYCLETIMER` - `REQUIREACKPERUNIT` - `CONNECTEDWOSOURCE` --- ## WORKFLOWHISTORY **Module:** PayRollDAL | **Source:** `GB5Solution/PayRoll/PayRollDAL/Query/Leave/LeaveQB.cs` **Columns (from INSERT INTO):** --- ## WORKFLOWSTATES **Module:** FrameworkDAL | **Source:** `GB5Framework/FrameworkDAL/Query/GOP/ExecutionQB.cs` **Columns (from INSERT INTO):** --- ## WORKFLOWTRACKING **Module:** PayRollDAL | **Source:** `GB5Solution/PayRoll/PayRollDAL/Query/Leave/LeaveQB.cs` **Columns (from INSERT INTO):** ---