using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace AdminDAL.Query.BIZTransactionType
{
    public static class BIZTransactionTypeQB
    {

        public const string GET_SELECTLIST_BIZTRANSACTIONTYPE_RIGHTS = @"
SELECT
    A.BIZTRANSACTIONTYPEID      AS Id,
    A.BIZTRANSACTIONTYPECODE    AS Code,
    A.BIZTRANSACTIONTYPENAME    AS Name,
    A.STOREID                   AS StoreId,
    B.STORENAME                 AS StoreName,
    A.SORTORDER                 AS SortOrder,
    A.PERIODID                  AS PeriodId,
    C.PERIODCODE                AS PeriodCode,
    C.PERIODNAME                AS PeriodName,
    A.OUID                      AS OrganizationUnitId,
    D.ORGANIZATIONUNITCODE      AS OrganizationUnitCode,
    D.ORGANIZATIONUNITNAME      AS OrganizationUnitName,
    A.ISINTERCOMPANYTRACKING    AS IsIntercompany,
    A.BIZTRANSACTIONCLASSID     AS BizTransactionClassId,
    A.BIZTRANSACTIONID          AS BizTransactionId,
    A.BIZTRANSACTIONSUBCLASSID  AS BizTransactionSubClassId,
    BIZCLASS.MODULEID           AS ModuleId,
    A.NOGENERATIONTYPE          AS NOGenerationType
FROM
    MBIZTRANSACTIONTYPE         A
    LEFT JOIN MSTORE            B  ON  B.STOREID   = A.STOREID
    LEFT JOIN MPERIOD           C  ON  C.PERIODID  = A.PERIODID
    LEFT JOIN MORGANIZATIONUNIT D  ON  D.OUID      = A.OUID
    LEFT JOIN MBIZTRANSACTIONCLASS BIZCLASS ON BIZCLASS.BIZTRANSACTIONCLASSID = A.BIZTRANSACTIONCLASSID
WHERE
    A.STATUS = 0
    AND NOT EXISTS (
            SELECT 1 FROM MADVANCERIGHTS AR
            WHERE AR.BIZTRANSACTIONID = A.BIZTRANSACTIONID
              AND AR.USERID           = @UserId
              AND AR.OUID             = @OrgUnitId
              AND AR.ALLOW            = '11111'
        )
    AND (
            (A.OUTYPE = 0 AND A.OUID = @OrgUnitId)
         OR  A.OUTYPE = 1
        )
    /*CRITERIA*/
ORDER BY
    A.SORTORDER,
    A.BIZTRANSACTIONTYPEID";

        public const string PG_SELECTLIST_BIZTRANSACTIONTYPE_RIGHTS = @"
SELECT
    A.BIZTRANSACTIONTYPEID      AS ""Id"",
    A.BIZTRANSACTIONTYPECODE    AS ""Code"",
    A.BIZTRANSACTIONTYPENAME    AS ""Name"",
    A.STOREID                   AS ""StoreId"",
    B.STORENAME                 AS ""StoreName"",
    A.SORTORDER                 AS ""SortOrder"",
    A.PERIODID                  AS ""PeriodId"",
    C.PERIODCODE                AS ""PeriodCode"",
    C.PERIODNAME                AS ""PeriodName"",
    A.OUID                      AS ""OrganizationUnitId"",
    D.ORGANIZATIONUNITCODE      AS ""OrganizationUnitCode"",
    D.ORGANIZATIONUNITNAME      AS ""OrganizationUnitName"",
    A.ISINTERCOMPANYTRACKING    AS ""IsIntercompany"",
    A.BIZTRANSACTIONCLASSID     AS ""BizTransactionClassId"",
    A.BIZTRANSACTIONID          AS ""BizTransactionId"",
    A.BIZTRANSACTIONSUBCLASSID  AS ""BizTransactionSubClassId"",
    BIZCLASS.MODULEID           AS ""ModuleId"",
    A.NOGENERATIONTYPE          AS ""NOGenerationType""
FROM
    MBIZTRANSACTIONTYPE         A
    LEFT JOIN MSTORE            B  ON  B.STOREID   = A.STOREID
    LEFT JOIN MPERIOD           C  ON  C.PERIODID  = A.PERIODID
    LEFT JOIN MORGANIZATIONUNIT D  ON  D.OUID      = A.OUID
    LEFT JOIN MBIZTRANSACTIONCLASS BIZCLASS ON BIZCLASS.BIZTRANSACTIONCLASSID = A.BIZTRANSACTIONCLASSID
WHERE
    A.STATUS = 0
    AND NOT EXISTS (
            SELECT 1 FROM MADVANCERIGHTS AR
            WHERE AR.BIZTRANSACTIONID = A.BIZTRANSACTIONID
              AND AR.USERID           = @UserId
              AND AR.OUID             = @OrgUnitId
              AND AR.ALLOW            = '11111'
        )
    AND (
            (A.OUTYPE = 0 AND A.OUID = @OrgUnitId)
         OR  A.OUTYPE = 1
        )
    /*CRITERIA*/
ORDER BY
    A.SORTORDER,
    A.BIZTRANSACTIONTYPEID";

        public const string ORACLE_SELECTLIST_BIZTRANSACTIONTYPE = @";";
        public const string MQSQL_SELECTLIST_BIZTRANSACTIONTYPE = @";";


        public const string GET_ROLEVSMENU = @"SELECT
    rvm.ROLEVSMENUID              AS RoleVsMenuId,
    rvm.ROLEID                    AS RoleVsMenuRoleId,
    r.ROLECODE                    AS RoleVsMenuRoleCode,
    r.ROLENAME                    AS RoleVsMenuRoleName,

    rvm.MENUID                    AS RoleVsMenuMenuId,
    m.MENUCODE                    AS RoleVsMenuMenuCode,
    m.MENUNAME                    AS RoleVsMenuMenuName,

    m.MODULEID                AS RoleVsMenuMenuParentId,
    pm.MENUNAME                   AS RoleVsMenuMenuParentName,

    m.MODULEID                AS RoleVsMenuMenuModuleId,
    mod.MODULENAME                AS RoleVsMenuMenuModuleName,

    m.ENTITYID                AS RoleVsMenuMenuEntityId,
    e.ENTITYCODE                  AS RoleVsMenuMenuEntityCode,
    e.ENTITYNAME                  AS RoleVsMenuMenuEntityName,
    m.URIParameterValue           AS RoleVsMenuMenuURIParameterValue,

    rvm.SLNO                      AS RoleVsMenuSlNo,
    rvm.ALLOW                     AS RoleVsMenuAllow,

    SUBSTRING(rvm.ALLOW, 1, 1)    AS RoleVsMenuView,
    SUBSTRING(rvm.ALLOW, 2, 1)    AS RoleVsMenuInsert,
    SUBSTRING(rvm.ALLOW, 3, 1)    AS RoleVsMenuUpdate,
    SUBSTRING(rvm.ALLOW, 4, 1)    AS RoleVsMenuDelete,
    SUBSTRING(rvm.ALLOW, 5, 1)    AS RoleVsMenuPrint,
    SUBSTRING(rvm.ALLOW, 6, 1)    AS RoleVsMenuExport,

    mod.MODULEID                  AS ModuleId

FROM MROLEVSMENU rvm
INNER JOIN MROLE r
    ON r.ROLEID = rvm.ROLEID
INNER JOIN MMENU m
    ON m.MENUID = rvm.MENUID
LEFT JOIN MMENU pm
    ON pm.MENUID = m.MODULEID
LEFT JOIN MMODULE mod
    ON mod.MODULEID = m.MODULEID
LEFT JOIN MENTITY e
    ON e.ENTITYID = m.ENTITYID
WHERE 1 = 1
  AND rvm.ROLEID = @roleid
  AND rvm.MENUID = @menuid
ORDER BY rvm.SLNO;
 ";


        public const string GET_ROLEVSMENU_PG = @"SELECT
    rvm.rolevsmenuid              AS ""RoleVsMenuId"",
    rvm.roleid                    AS ""RoleVsMenuRoleId"",
    r.rolecode                    AS ""RoleVsMenuRoleCode"",
    r.rolename                    AS ""RoleVsMenuRoleName"",

    rvm.menuid                    AS ""RoleVsMenuMenuId"",
    m.menucode                    AS ""RoleVsMenuMenuCode"",
    m.menuname                    AS ""RoleVsMenuMenuName"",

    m.moduleid                    AS ""RoleVsMenuMenuParentId"",
    pm.menuname                   AS ""RoleVsMenuMenuParentName"",

    m.moduleid                    AS ""RoleVsMenuMenuModuleId"",
    mod.modulename                AS ""RoleVsMenuMenuModuleName"",

    m.entityid                    AS ""RoleVsMenuMenuEntityId"",
    e.entitycode                  AS ""RoleVsMenuMenuEntityCode"",
    e.entityname                  AS ""RoleVsMenuMenuEntityName"",
    m.uriparametervalue         AS ""RoleVsMenuMenuURIParameterValue"",

    rvm.slno                      AS ""RoleVsMenuSlNo"",
    rvm.ALLOW                   AS ""RoleVsMenuAllow"",

    SUBSTRING(rvm.ALLOW, 1, 1)  AS ""RoleVsMenuView"",
    SUBSTRING(rvm.ALLOW, 2, 1)  AS ""RoleVsMenuInsert"",
    SUBSTRING(rvm.ALLOW, 3, 1)  AS ""RoleVsMenuUpdate"",
    SUBSTRING(rvm.ALLOW, 4, 1)  AS ""RoleVsMenuDelete"",
    SUBSTRING(rvm.ALLOW, 5, 1)  AS ""RoleVsMenuPrint"",
    SUBSTRING(rvm.ALLOW, 6, 1)  AS ""RoleVsMenuExport"",

    mod.moduleid                  AS ""ModuleId""

FROM mrolevsmenu rvm
INNER JOIN mrole r
    ON r.roleid = rvm.roleid
INNER JOIN mmenu m
    ON m.menuid = rvm.menuid
LEFT JOIN mmenu pm
    ON pm.menuid = m.moduleid
LEFT JOIN mmodule mod
    ON mod.moduleid = m.moduleid
LEFT JOIN MENTITY e
    ON e.ENTITYID = m.ENTITYID
WHERE rvm.roleid = @roleid
  AND rvm.menuid = @menuid
ORDER BY rvm.slno;
";

        public const string GET_BIZTRANSACTIONTYPE_LIST_BY_CRITERIA = @"
            SELECT
                A.BIZTRANSACTIONTYPEID       AS Id,
                A.BIZTRANSACTIONTYPECODE     AS Code,
                A.BIZTRANSACTIONTYPENAME     AS Name,
                A.OUID                       AS OrganizationUnitId,
                A.BIZTRANSACTIONCLASSID      AS BizTransactionClassId,
                A.BIZTRANSACTIONSUBCLASSID   AS BizTransactionSubClassId,
                A.BIZTRANSACTIONID           AS BizTransactionId,
                A.PERIODID                   AS PeriodId,
                A.STOREID                    AS StoreId,
                A.SORTORDER                  AS SortOrder,
                A.NOGENERATIONTYPE           AS NOGenerationType
            FROM MBIZTRANSACTIONTYPE A
            WHERE A.OUID = @ouid
            /*CRITERIA*/
            ORDER BY A.SORTORDER, A.BIZTRANSACTIONTYPEID;";

        public const string PG_GET_BIZTRANSACTIONTYPE_LIST_BY_CRITERIA = @"
            SELECT
                a.biztransactiontypeid       AS ""Id"",
                a.biztransactiontypecode     AS ""Code"",
                a.biztransactiontypename     AS ""Name"",
                a.ouid                       AS ""OrganizationUnitId"",
                a.biztransactionclassid      AS ""BizTransactionClassId"",
                a.biztransactionsubclassid   AS ""BizTransactionSubClassId"",
                a.biztransactionid           AS ""BizTransactionId"",
                a.periodid                   AS ""PeriodId"",
                a.storeid                    AS ""StoreId"",
                a.sortorder                  AS ""SortOrder"",
                a.nogenerationtype           AS ""NOGenerationType""
            FROM mbiztransactiontype a
            WHERE a.ouid = @ouid
            /*CRITERIA*/
            ORDER BY a.sortorder, a.biztransactiontypeid;";

        public const string GET_BIZTRANSACTIONTYPE_DETAILS_SQL = @"
            SELECT
                btt.BIZTRANSACTIONTYPEID                AS BIZTransactionTypeId,
                btt.BIZTRANSACTIONTYPECODE              AS BIZTransactionTypeCode,
                btt.BIZTRANSACTIONTYPENAME              AS BIZTransactionTypeName,
                btt.BIZTRANSACTIONCLASSID               AS BIZTransactionTypeClassId,
                btc.BIZTRANSACTIONCLASSCODE             AS BIZTransactionTypeClassCode,
                btc.BIZTRANSACTIONCLASSNAME             AS BIZTransactionTypeClassName,
                btc.ISCHARGES                           AS BIZTransactionClassIsCharges,
                btc.STOCKPOSTTYPE                       AS BIZTransactionClassStockPostType,
                btc.MODULEID                            AS BIZTransactionClassModuleId,
                btc.ISAMENDMENTREQUIRED                 AS BizTransactionClassIsAmendmentRequired,
                btc.ISPARTYAPPLICABLE                   AS BizTransactionClassIsPartyApplicable,
                btc.ISVARIANCETRACKING                  AS BizTransactionClassIsVarianceTracking,
                btc.UPDATEITEMPARTY                     AS BizTransactionClassUpdateItemParty,
                btc.STOCKVALUEAFFECTING                 AS BizTransactionClassStockValueAffecting,
                btc.ISFORECASTAPPLICABLE                AS BIZTransactionClassIsForeCastApplicable,
                btc.INPUTPOSTTYPE                       AS BIZTransactionClassInputPostType,
                btc.OUTPUTPOSTTYPE                      AS BIZTransactionClassOutputPostType,
                btc.WASTEPOSTTYPE                       AS BIZTransactionClassWastePostType,
                btc.FROMADDRESS                         AS BizTransactionClassFromAddress,
                btc.RESERVATIONNATURE                   AS BIZTransactionClassReservationNature,
                btt.BIZTRANSACTIONSUBCLASSID            AS BIZTransactionTypeSubClassId,
                btsc.BIZTRANSACTIONSUBCLASSCODE         AS BIZTransactionTypeSubClassCode,
                btsc.BIZTRANSACTIONSUBCLASSNAME         AS BIZTransactionTypeSubClassName,
                btt.BIZTRANSACTIONID                    AS BIZTransactionId,
                bt.BIZTRANSACTIONCODE                   AS BIZTransactionCode,
                bt.BIZTRANSACTIONNAME                   AS BIZTransactionName,
                btt.OUID                                AS OrganizationUnitId,
                ou.ORGANIZATIONUNITCODE                 AS OrganizationUnitCode,
                ou.ORGANIZATIONUNITNAME                 AS OrganizationUnitName,
                btt.OUGROUPID                           AS OrganizationGroupId,
                og.ORGANIZATIONGROUPCODE                AS OrganizationGroupCode,
                og.ORGANIZATIONGROUPNAME                AS OrganizationGroupName,
                btt.PERIODID                            AS PeriodId,
                per.PERIODCODE                          AS PeriodCode,
                per.PERIODNAME                          AS PeriodName,
                btt.STOREID                             AS StoreId,
                st.STORECODE                            AS StoreCode,
                st.STORENAME                            AS StoreName,
                btt.PROCESSID                           AS ProcessId,
                pr.PROCESSCODE                          AS ProcessCode,
                pr.PROCESSNAME                          AS ProcessName,
                btt.WORKCENTERID                        AS WorkCenterId,
                wc.WORKCENTERCODE                       AS WorkCenterCode,
                wc.WORKCENTERNAME                       AS WorkCenterName,
                btt.ADDITIONALCHARGEID                  AS AdditionalChargeId,
                ac.CHARGECODE                           AS AdditionalChargeCode,
                ac.CHARGENAME                           AS AdditionalChargeName,
                btt.OTHERCHARGEID                       AS OtherChargeId,
                oc.CHARGECODE                           AS OtherChargeCode,
                oc.CHARGENAME                           AS OtherChargeName,
                btt.TOTALCHARGEID                       AS TotalChargeId,
                tc.CHARGECODE                           AS TotalChargeCode,
                tc.CHARGENAME                           AS TotalChargeName,
                btt.FIXEDACCOUNTID                      AS FixedAccountId,
                fa.ACCOUNTCODE                          AS FixedAccountCode,
                fa.ACCOUNTNAME                          AS FixedAccountName,
                btt.CASHACCOUNTID                       AS CashAccountId,
                ca.ACCOUNTCODE                          AS CashAccountCode,
                ca.ACCOUNTNAME                          AS CashAccountName,
                btt.COSTOFSALESACCOUNTID                AS BIZTransactionTypeCostOfSalesAccountId,
                csa.ACCOUNTCODE                         AS BIZTransactionTypeCostOfSalesAccountCode,
                csa.ACCOUNTNAME                         AS BIZTransactionTypeCostOfSalesAccountName,
                btt.COUNTERID                           AS CounterId,
                cnt.COUNTERCODE                         AS CounterCode,
                cnt.COUNTERNAME                         AS CounterName,
                btt.ALLOCATIONTYPEID                    AS AllocationTypeId,
                alt.ALLOCATIONTYPECODE                  AS AllocationTypeCode,
                alt.ALLOCATIONTYPENAME                  AS AllocationTypeName,
                btt.ALLOCATIONID                        AS MAllocationId,
                mal.ALLOCATIONNAME                      AS MAllocationName,
                btt.CURRENCYID                          AS CurrencyId,
                cur.CURRENCYCODE                        AS CurrencyCode,
                cur.CURRENCYNAME                        AS CurrencyName,
                cur.CURRENCYDECIMAL                     AS CurrencyCurrencyDecimal,
                btt.LOTTYPEID                           AS LotTypeId,
                lot.LOTTYPENAME                         AS LotTypeName,
                btt.REPORTFORMATID                      AS ReportFormatId,
                rft.REPORTFORMATNAME                    AS ReportFormatName,
                rft.REPORTFILE                          AS ReportFormatReportFile,
                rft.DATASOURCEFILENAME                  AS ReportFormatDataSourceFileName,
                btt.PARTYID                             AS BIZTransactionTypePartyId,
                par.PARTYCODE                           AS BIZTransactionTypePartyCode,
                par.PARTYNAME                           AS BIZTransactionTypePartyName,
                btt.OUTYPE                              AS BIZTransactionTypeOUType,
                btt.NOGENERATIONTYPE                    AS BIZTransactionTypeNOGenerationType,
                btt.NOGENERATIONPERIODTYPE              AS BIZTransactionTypeNOGenerationPeriodType,
                btt.NUMBERSIZE                          AS BIZTransactionTypeNumberSize,
                btt.PREFIX                              AS BIZTransactionTypePrefix,
                btt.SUFFIX                              AS BIZTransactionTypeSuffix,
                btt.SYSTEMPREFIX                        AS BIZTransactionTypeSystemPrefix,
                btt.SYSTEMSUFFIX                        AS BIZTransactionTypeSystemSuffix,
                btt.ISMULTICURRENCYAPPLICABLE            AS BIZTransactionTypeIsMultiCurrency,
                btt.ISMULTIPLEOU                        AS BIZTransactionTypeIsMultipleOU,
                btt.ISCOSTCENTER                        AS BIZTransactionTypeIsCostCenter,
                btt.ISMULTIPLECOSTCATEGORY              AS BIZTransactionTypeIsMultipleCostCategory,
                btt.ISSPLITCOSTCENTER                   AS BIZTransactionTypeIsSplitCostCenter,
                btt.ISALLOCATION                        AS BIZTransactionTypeIsAllocation,
                btt.ALLOCATIONNATURE                    AS BIZTransactionTypeAllocationNature,
                btt.ISMULTIPLEUOM                       AS BIZTransactionTypeIsMultipleUOM,
                btt.ISPACKINGQUANTITY                   AS BIZTransactionTypeIsPackingQuality,
                btt.ISPACKINGDETAILSREQUIRED            AS BIZTransactionTypeIsPackingDetails,
                btt.ISBATCHDETAILS                      AS BIZTransactionTypeIsBatchDetails,
                btt.ISBATCHCREATIONPOSSIBLE             AS BIZTransactionTypeIsBatchCreationPossible,
                btt.ISSEPARATEBATCHENTRYPOSSIBLE        AS BIZTransactionTypeIsSeparateBatchEntryPossible,
                btt.ISMOVEMENTTYPE                      AS BIZTransactionTypeIsMovementType,
                btt.ISTRIPBILL                          AS BIZTransactionTypeIsTripBill,
                btt.ISSUPPLIEMENTARY                    AS BIZTransactionTypeIsSuppliementary,
                btt.ISMULTIPLESTORES                    AS BIZTransactionTypeIsMultipleStores,
                btt.ISDELIVEYRSCHEDULE                  AS BIZTransactionTypeIsDeliverySchedule,
                btt.ISSCHEME                            AS BIZTransactionTypeIsScheme,
                btt.ISFREE                              AS BIZTransactionTypeIsFree,
                btt.RATEFORFREE                         AS BIZTransactionTypeRateForFree,
                btt.ISEXCISE                            AS BIZTransactionTypeIsExcise,
                btt.ISCENVAT                            AS BIZTransactionTypeIsCenVat,
                btt.ISTRANSACTIONTYPECHANGEABLE         AS BIZTransactionTypeIsTransactionTypeChangeable,
                btt.ISFORMDETAILS                       AS BIZTransactionTypeIsFormDetails,
                btt.ACCOUNTPOSTTYPE                     AS BIZTransactionTypeAccountPostType,
                btt.ACCOUNTPOSTBASIS                    AS BIZTransactionTypeAccountPostBasis,
                btt.ACCOUNTVOUCHERTYPE                  AS BIZTransactionTypeAccountVoucherType,
                btt.LEDGERTYPE                          AS BIZTransactionTypeLedgerType,
                btt.NARRATIONTYPE                       AS BIZTransactionTypeNarrationType,
                btt.BILLACCOUNTTYPE                     AS BIZTransactionTypeBillAccountType,
                btt.COSTOFSALESPOSTINGTYPE              AS BIZTransactionTypeCostOfSalesPostingType,
                btt.ISCASHCREDIT                        AS BIZTransactionTypeIsCashCredit,
                btt.CASHBILLACCOUNTINGTYPE              AS BIZTransactionTypeCashBillAccountingType,
                btt.STOCKPOSTTYPE                       AS BIZTransactionTypeStockPostType,
                btt.TRANSFERSTOCKPOSTTYPE               AS BIZTransactionTypeTransferStockPostType,
                btt.STOCKCHECKTYPE                      AS BIZTransactionTypeStockCheckType,
                btt.ISSELECTIONREQUIRED                 AS BIZTransactionTypeIsSelection,
                btt.SELECTIONFROMTYPE                   AS BIZTransactionTypeSelectionFromType,
                btt.SELECTIONTYPE                       AS BIZTransactionTypeSelectionType,
                btt.ISNONSELECTIONENTRY                 AS BIZTransactionTypeIsNonSelectionEntry,
                btt.ISVARIANCEALLOWED                   AS BIZTransactionTypeIsVarianceAllowed,
                btt.ISQUANTITYVARIANCE                  AS BIZTransactionTypeIsQuantityVariance,
                btt.ISQUALITYVARIANCE                   AS BIZTransactionTypeIsQualityVariance,
                btt.ISRATEVARIANCE                      AS BIZTransactionTypeIsRateVariance,
                btt.ISPENDINGPOST                       AS BIZTransactionTypeIsPendingPost,
                btt.PENDINGFORPROCESS                   AS BIZTransactionTypePendingForProcess,
                btt.PENDINGFORSTOCK                     AS BIZTransactionTypePendingForStock,
                btt.ISINTERCOMPANYTRACKING              AS BIZTransactionTypeIsInterCompanyTracking,
                btt.ISDELIVERYTRACKING                  AS BIZTransactionTypeIsDeliveryTracking,
                btt.DEFAULTDELIVERYTYPE                 AS BIZTransactionTypeDefaultDeliveryType,
                btt.BACKDATEENTRYDAY                    AS BIZTransactionTypeBackDateEntryDay,
                btt.BACKDATEUPDATEDAY                   AS BIZTransactionTypeBackDateUpdateDay,
                btt.BACKDATEDELETEDAY                   AS BIZTransactionTypeBackDateDeleteDay,
                btt.BACKDATECHECKTYPE                   AS BIZTransactionTypeBackDateCheckType,
                btt.FORWARDENTRYDAY                     AS BIZTransactionTypeForwardEntryDay,
                btt.ISSTOCKCC                           AS BIZTransactionTypeIsStockCC,
                btt.SORTORDER                           AS BIZTransactionTypeSortOrder,
                btt.STATUS                              AS BIZTransactionTypeStatus,
                btt.ISCANCELAPPLICABLE                  AS BIZTransactionTypeIsCancelApplicable,
                btt.ISZEROVALUE                         AS BIZTransactionTypeIsZeroValue,
                btt.PURPOSE                             AS BIZTransactionTypePurpose,
                btt.SHOWHISTORY                         AS BIZTransactionTypeShowHistory,
                btt.STOCKACCOUNTPOSTING                 AS BIZTransactionTypeStockAccountPosting,
                btt.STOCKACCOUNTTYPE                    AS BIZTransactionTypeStockAccountType,
                btt.STOCKCONTRATYPE                     AS BIZTransactionTypeStockContraType,
                btt.ISFORECASTAPPLICABLE                AS BIZTransactionClassIsForeCastApplicable,
                btt.MATERIALACCOUNTCHANGEABLE           AS BIZTransactionTypeMaterialAccountChangeable,
                btt.ISRATEPERUOMAPPLICABLE              AS BIZTransactionTypeRatePerUOMApplicable,
                btt.ISSKUAPPLICABLE                     AS BIZTransactionTypeSKUApplicable,
                btt.LINEWISETRACKINGREQUIRED            AS BIZTransactionTypeLinewiseTrackingRequired,
                btt.ISACTUALQUANTITY                    AS BIZTransactionTypeIsActualQuantity,
                btt.ISGOODQUANTITY                      AS BIZTransactionTypeIsGoodQuantity,
                btt.ISREJECTEDQUANTITY                  AS BIZTransactionTypeIsRejectedQuantity,
                btt.ISREWORKQUANTITY                    AS BIZTransactionTypeIsReworkQuantity,
                btt.ISOTHERQUANTITY                     AS BIZTransactionTypeIsOtherQuantity,
                btt.ISBATCHINHEADER                     AS BIZTransactionTypeIsBatchInHeader,
                btt.FROMPACKSTATUS                      AS BIZTransactionTypeFromPackStatus,
                btt.TOPACKSTATUS                        AS BIZTransactionTypeToPackStatus,
                btt.PRINTTYPE                           AS PrintType,
                btt.ISDISCOUNTAPPLICABLE                AS BIZTransactionTypeIsDiscountApplicable,
                btt.STOCKVIEWTYPE                       AS BIZTransactionTypeStockviewType,
                btt.ISSUETYPE                           AS BIZTransactionTypeIssueType,
                btt.ISREASONAPPLICABLE                  AS BIZTransactionTypeIsReasonApplicable,
                btt.ISQUALITYDETAILS                    AS BIZTransactionTypeIsQualityDetails,
                btt.ISGROSSWEIGHT                       AS BIZTransactionTypeIsGrossWeight,
                btt.ISNETWEIGHT                         AS BIZTransactionTypeIsNetWeight,
                btt.ISTAREWEIGHT                        AS BIZTransactionTypeIsTareWeight,
                btt.ATTACHMENTTYPE                      AS BIZTransactionTypeAttachmentType,
                btt.SCANNINGREQUIRED                    AS BIZTransactionTypeScanningRequired,
                btt.ISBIZDIMENSIONTYPE                  AS BIZTransactionTypeIsBizDimensionType,
                btt.L1TYPE                              AS BIZTransactionTypeL1Type,
                btt.L2TYPE                              AS BIZTransactionTypeL2Type,
                btt.L3TYPE                              AS BIZTransactionTypeL3Type,
                btt.L4TYPE                              AS BIZTransactionTypeL4Type,
                btt.L5TYPE                              AS BIZTransactionTypeL5Type,
                btt.SEGMENTID                           AS SegmentId,
                btt.STOCKCCID                           AS StockCCId,
                scc.COSTCENTERCODE                      AS StockCCCode,
                scc.COSTCENTERNAME                      AS StockCCName,
                btt.ACCOUNTBIZTRANSACTIONTYPEID         AS AccountBizTransactionTypeId,
                abt.BIZTRANSACTIONTYPECODE              AS AccountBizTransactionTypeCode,
                abt.BIZTRANSACTIONTYPENAME              AS AccountBizTransactionTypeName,
                btt.SELECTIONCLASSID                    AS SelectionClassId,
                sbc.BIZTRANSACTIONCLASSCODE             AS SelectionClassCode,
                sbc.BIZTRANSACTIONCLASSNAME             AS SelectionClassName,
                btt.SELECTIONSUBCLASSID                 AS SelectionSubClassId,
                sbsc.BIZTRANSACTIONSUBCLASSCODE         AS SelectionSubClassCode,
                sbsc.BIZTRANSACTIONSUBCLASSNAME         AS SelectionSubClassName,
                btt.PARTYCRITERIACONFIGID               AS PartyCriteriaConfigId,
                pcc.CRITERIACONFIGNAME                  AS PartyCriteriaConfigName,
                btt.SELECTIONBIZTRANSACTIONID           AS SelectionBIZTransactionId,
                sbt.BIZTRANSACTIONCODE                  AS SelectionBIZTransactionCode,
                sbt.BIZTRANSACTIONNAME                  AS SelectionBIZTransactionName,
                btt.HEADEXCISEREGISTERID                AS HeadExciseRegisterId,
                her.EXCISEREGISTERNAME                  AS HeadExciseRegisterName,
                btt.ITEMEXCISEREGISTERID                AS ItemExciseRegisterId,
                ier.EXCISEREGISTERNAME                  AS ItemExciseRegisterName,
                btt.NCRBIZTRANSACTIONID                 AS NcrBiztransactionId,
                nbt.BIZTRANSACTIONCODE                  AS NcrBiztransactionCode,
                nbt.BIZTRANSACTIONNAME                  AS NcrBiztransactionName,
                btt.ITEMCRITERIACONFIGID                AS ItemCriteriaConfigId,
                icc.CRITERIACONFIGNAME                  AS ItemCriteriaConfigName,
                btt.STOCKACCOUNTBIZTRANSACTIONTYPEID    AS StockAccountBiztransactionTypeId,
                sabt.BIZTRANSACTIONTYPECODE             AS StockAccountBiztransactionTypeCode,
                sabt.BIZTRANSACTIONTYPENAME             AS StockAccountBiztransactionTypeName,
                btt.STOCKFIXEDACCOUNTID                 AS StockFixedAccountId,
                sfa.ACCOUNTCODE                         AS StockFixedAccountCode,
                sfa.ACCOUNTNAME                         AS StockFixedAccountName,
                btt.STOCKCONTRAACCOUNTID                AS StockContraAccountId,
                sca.ACCOUNTCODE                         AS StockContraAccountCode,
                sca.ACCOUNTNAME                         AS StockContraAccountName,
                btt.LABOURCHARGESACCOUNTID              AS LabourChargesAccountId,
                lca.ACCOUNTCODE                         AS LabourChargesAccountCode,
                lca.ACCOUNTNAME                         AS LabourChargesAccountName,
                btt.LABOURCHARGESPAYABLEACCOUNTID       AS LabourChargesPayableAccountId,
                lcpa.ACCOUNTCODE                        AS LabourChargesPayableAccountCode,
                lcpa.ACCOUNTNAME                        AS LabourChargesPayableAccountName,
                btt.TERMSETID                           AS TermsSetId,
                ts.TERMSSETNAME                         AS TermsSetName,
                btt.MULTIBIZTRANSACTIONID               AS MultiBIZTransactionId,
                mbt.BIZTRANSACTIONCODE                  AS MultiBIZTransactionCode,
                mbt.BIZTRANSACTIONNAME                  AS MultiBIZTransactionName,
                btt.DEFAULTSKUID                        AS DefaultSKUId,
                dsku.SKUCODE                            AS DefaultSKUCode,
                dsku.SKUNAME                            AS DefaultSKUName,
                btt.DEFAULTITEMID                       AS DefaultItemId,
                di.ITEMCODE                             AS DefaultItemCode,
                di.ITEMNAME                             AS DefaultItemName,
                btt.DEFAULTOUID                         AS DefaultOUId,
                defou.ORGANIZATIONUNITCODE              AS DefaultOUCode,
                defou.ORGANIZATIONUNITNAME              AS DefaultOUName,
                btt.COSTCENTERTYPEID                    AS BIZTransactionTypeCostCenterTypeId,
                cctype.COSTCENTERTYPECODE               AS BIZTransactionTypeCostCenterTypeCode,
                cctype.COSTCENTERTYPENAME               AS BIZTransactionTypeCostCenterTypeName,
                btt.LOADINTERMMBIZTRANSACTIONID         AS LoadInterMMBiztransactionId,
                limbt.BIZTRANSACTIONCODE                AS LoadInterMMBiztransactionCode,
                limbt.BIZTRANSACTIONNAME                AS LoadInterMMBiztransactionName,
                btt.SAMPLEPARTYBRANCHID                 AS SamplePartyBranchId,
                btt.AUTOREJECTIONAPPLICABLE             AS AutoRejectionApplicable,
                btt.SHOWFIELDS                          AS ShowFields,
                btt.CONSUMPTIONBIZTRANSACTIONID         AS ConsumptionBIZTransactionId,
                btt.ISRECOVERYTRACK                     AS BIZTransactionTypeIsRecoveryTrack,
                btt.LINEWISEREFERENCEREQUIRED           AS BIZTransactionTypeLinewiseReferenceRequired,
                btt.SKUCREATIONALLOWED                  AS BIZTransactionTypeSKUCreationAllowed,
                btt.MAXDIMENSIONALLOWED                 AS BIZTransactionTypeMaxDimensionAllowed,
                btt.MRPDETAILSREQUIRED                  AS BIZTransactionTypeMRPDetailsRequired,
                btt.ISADVANCEACCOUNTPOSTING             AS BIZTransactionTypeIsAdvanceAccountPosting,
                btt.LOTMARKTYPE                         AS BIZTransactionTypeLotMarkType,
                btt.PENDINGPOSTING                      AS BIZTransactionTypePendingPosting,
                btt.ITEMALIASREQUIRED                   AS BIZTransactionTypeItemAliasRequired,
                btt.ITEMEXTENDEDSEARCHREQUIRED          AS BIZTransactionTypeItemExtendedSearchRequired,
                btt.ISBINREQUIRED                       AS BIZTransactionTypeIsBinRequired,
                btt.RATELOADING                         AS BIZTransactionTypeRateLoading,
                btt.POSTTOITEMPARTY                     AS BIZTransactionTypePostToItemParty,
                btt.ITEMFROMITEMPARTYONLY               AS BIZTransactionTypeItemFromItemParty,
                btt.ISIORATIO                           AS BIZTransactionTypeIsIoRatio,
                btt.REJECTIONNCR                        AS BIZTransactionTypeRejectionNCR,
                btt.REWORKNCR                           AS BIZTransactionTypeReworkNCR,
                btt.OTHERNCR                            AS BIZTransactionTypeOtherNCR,
                btt.PREVIOUSPROCESS                     AS BIZTransactionTypePreviousProcess,
                btt.INCLUDEFORPLANNING                  AS BIZTransactionTypeIncludeForPlanning,
                btt.CREATEDBYID                         AS BIZTransactionTypeCreatedById,
                btt.CREATEDON                           AS BIZTransactionTypeCreatedOn,
                btt.MODIFIEDBYID                        AS BIZTransactionTypeModifiedById,
                btt.MODIFIEDON                          AS BIZTransactionTypeModifiedOn,
                btt.SOURCETYPE                          AS BIZTransactionTypeSourceType,
                btt.VERSION                             AS BIZTransactionTypeVersion,
                btt.ASSETPOSTTYPE                       AS BIZTransactionTypeAssetPostType,
                btt.CONTRACTDETAILTYPE                  AS BIZTransactionTypeContractDetailType
            FROM MBIZTRANSACTIONTYPE btt
            LEFT JOIN MBIZTRANSACTIONCLASS btc      ON btc.BIZTRANSACTIONCLASSID = btt.BIZTRANSACTIONCLASSID
            LEFT JOIN MBIZTRANSACTIONSUBCLASS btsc  ON btsc.BIZTRANSACTIONSUBCLASSID = btt.BIZTRANSACTIONSUBCLASSID
            LEFT JOIN MBIZTRANSACTION bt            ON bt.BIZTRANSACTIONID = btt.BIZTRANSACTIONID
            LEFT JOIN MORGANIZATIONUNIT ou          ON ou.OUID = btt.OUID
            LEFT JOIN MORGANIZATIONGROUP og         ON og.ORGANIZATIONGROUPID = btt.OUGROUPID
            LEFT JOIN MPERIOD per                   ON per.PERIODID = btt.PERIODID
            LEFT JOIN MSTORE st                     ON st.STOREID = btt.STOREID
            LEFT JOIN MPROCESS pr                   ON pr.PROCESSID = btt.PROCESSID
            LEFT JOIN MWORKCENTER wc                ON wc.WORKCENTERID = btt.WORKCENTERID
            LEFT JOIN MCHARGE ac                    ON ac.CHARGEID = btt.ADDITIONALCHARGEID
            LEFT JOIN MCHARGE oc                    ON oc.CHARGEID = btt.OTHERCHARGEID
            LEFT JOIN MCHARGE tc                    ON tc.CHARGEID = btt.TOTALCHARGEID
            LEFT JOIN MACCOUNT fa                   ON fa.ACCOUNTID = btt.FIXEDACCOUNTID
            LEFT JOIN MACCOUNT ca                   ON ca.ACCOUNTID = btt.CASHACCOUNTID
            LEFT JOIN MACCOUNT csa                  ON csa.ACCOUNTID = btt.COSTOFSALESACCOUNTID
            LEFT JOIN MCOUNTER cnt                  ON cnt.COUNTERID = btt.COUNTERID
            LEFT JOIN MALLOCATIONTYPE alt           ON alt.ALLOCATIONTYPEID = btt.ALLOCATIONTYPEID
            LEFT JOIN MALLOCATION mal               ON mal.ALLOCATIONID = btt.ALLOCATIONID
            LEFT JOIN MCURRENCY cur                 ON cur.CURRENCYID = btt.CURRENCYID
            LEFT JOIN MLOTTYPE lot                  ON lot.LOTTYPEID = btt.LOTTYPEID
            LEFT JOIN MREPORTFORMAT rft             ON rft.REPORTFORMATID = btt.REPORTFORMATID
            LEFT JOIN MPARTY par                    ON par.PARTYID = btt.PARTYID
            LEFT JOIN MCOSTCENTER scc               ON scc.COSTCENTERID = btt.STOCKCCID
            LEFT JOIN MBIZTRANSACTIONTYPE abt       ON abt.BIZTRANSACTIONTYPEID = btt.ACCOUNTBIZTRANSACTIONTYPEID
            LEFT JOIN MBIZTRANSACTIONCLASS sbc      ON sbc.BIZTRANSACTIONCLASSID = btt.SELECTIONCLASSID
            LEFT JOIN MBIZTRANSACTIONSUBCLASS sbsc  ON sbsc.BIZTRANSACTIONSUBCLASSID = btt.SELECTIONSUBCLASSID
            LEFT JOIN TCRITERIACONFIG pcc           ON pcc.CRITERIACONFIGID = btt.PARTYCRITERIACONFIGID
            LEFT JOIN MBIZTRANSACTION sbt           ON sbt.BIZTRANSACTIONID = btt.SELECTIONBIZTRANSACTIONID
            LEFT JOIN MEXCISEREGISTER her           ON her.EXCISEREGISTERID = btt.HEADEXCISEREGISTERID
            LEFT JOIN MEXCISEREGISTER ier           ON ier.EXCISEREGISTERID = btt.ITEMEXCISEREGISTERID
            LEFT JOIN MBIZTRANSACTION nbt           ON nbt.BIZTRANSACTIONID = btt.NCRBIZTRANSACTIONID
            LEFT JOIN TCRITERIACONFIG icc           ON icc.CRITERIACONFIGID = btt.ITEMCRITERIACONFIGID
            LEFT JOIN MBIZTRANSACTIONTYPE sabt      ON sabt.BIZTRANSACTIONTYPEID = btt.STOCKACCOUNTBIZTRANSACTIONTYPEID
            LEFT JOIN MACCOUNT sfa                  ON sfa.ACCOUNTID = btt.STOCKFIXEDACCOUNTID
            LEFT JOIN MACCOUNT sca                  ON sca.ACCOUNTID = btt.STOCKCONTRAACCOUNTID
            LEFT JOIN MACCOUNT lca                  ON lca.ACCOUNTID = btt.LABOURCHARGESACCOUNTID
            LEFT JOIN MACCOUNT lcpa                 ON lcpa.ACCOUNTID = btt.LABOURCHARGESPAYABLEACCOUNTID
            LEFT JOIN MTERMSSET ts                  ON ts.TERMSSETID = btt.TERMSETID
            LEFT JOIN MBIZTRANSACTION mbt           ON mbt.BIZTRANSACTIONID = btt.MULTIBIZTRANSACTIONID
            LEFT JOIN MSKU dsku                     ON dsku.SKUID = btt.DEFAULTSKUID
            LEFT JOIN MITEM di                      ON di.ITEMID = btt.DEFAULTITEMID
            LEFT JOIN MORGANIZATIONUNIT defou       ON defou.OUID = btt.DEFAULTOUID
            LEFT JOIN MCOSTCENTERTYPE cctype        ON cctype.COSTCENTERTYPEID = btt.COSTCENTERTYPEID
            LEFT JOIN MBIZTRANSACTION limbt         ON limbt.BIZTRANSACTIONID = btt.LOADINTERMMBIZTRANSACTIONID
            WHERE btt.BIZTRANSACTIONTYPEID = @biztransactiontypeid;";

        public const string PG_GET_BIZTRANSACTIONTYPE_DETAILS_SQL = @"
            SELECT
                btt.biztransactiontypeid                AS ""BIZTransactionTypeId"",
                btt.biztransactiontypecode              AS ""BIZTransactionTypeCode"",
                btt.biztransactiontypename              AS ""BIZTransactionTypeName"",
                btt.biztransactionclassid               AS ""BIZTransactionTypeClassId"",
                btc.biztransactionclasscode             AS ""BIZTransactionTypeClassCode"",
                btc.biztransactionclassname             AS ""BIZTransactionTypeClassName"",
                btc.ischarges                           AS ""BIZTransactionClassIsCharges"",
                btc.stockposttype                       AS ""BIZTransactionClassStockPostType"",
                btc.moduleid                            AS ""BIZTransactionClassModuleId"",
                btc.isamendmentrequired                 AS ""BizTransactionClassIsAmendmentRequired"",
                btc.ispartyapplicable                   AS ""BizTransactionClassIsPartyApplicable"",
                btc.isvariancetracking                  AS ""BizTransactionClassIsVarianceTracking"",
                btc.updateitemparty                     AS ""BizTransactionClassUpdateItemParty"",
                btc.stockvalueaffecting                 AS ""BizTransactionClassStockValueAffecting"",
                btc.isforecastapplicable                AS ""BIZTransactionClassIsForeCastApplicable"",
                btc.inputposttype                       AS ""BIZTransactionClassInputPostType"",
                btc.outputposttype                      AS ""BIZTransactionClassOutputPostType"",
                btc.wasteposttype                       AS ""BIZTransactionClassWastePostType"",
                btc.fromaddress                         AS ""BizTransactionClassFromAddress"",
                btc.reservationnature                   AS ""BIZTransactionClassReservationNature"",
                btt.biztransactionsubclassid            AS ""BIZTransactionTypeSubClassId"",
                btsc.biztransactionsubclasscode         AS ""BIZTransactionTypeSubClassCode"",
                btsc.biztransactionsubclassname         AS ""BIZTransactionTypeSubClassName"",
                btt.biztransactionid                    AS ""BIZTransactionId"",
                bt.biztransactioncode                   AS ""BIZTransactionCode"",
                bt.biztransactionname                   AS ""BIZTransactionName"",
                btt.ouid                                AS ""OrganizationUnitId"",
                ou.organizationunitcode                 AS ""OrganizationUnitCode"",
                ou.organizationunitname                 AS ""OrganizationUnitName"",
                btt.ougroupid                           AS ""OrganizationGroupId"",
                og.organizationgroupcode                AS ""OrganizationGroupCode"",
                og.organizationgroupname                AS ""OrganizationGroupName"",
                btt.periodid                            AS ""PeriodId"",
                per.periodcode                          AS ""PeriodCode"",
                per.periodname                          AS ""PeriodName"",
                btt.storeid                             AS ""StoreId"",
                st.storecode                            AS ""StoreCode"",
                st.storename                            AS ""StoreName"",
                btt.processid                           AS ""ProcessId"",
                pr.processcode                          AS ""ProcessCode"",
                pr.processname                          AS ""ProcessName"",
                btt.workcenterid                        AS ""WorkCenterId"",
                wc.workcentercode                       AS ""WorkCenterCode"",
                wc.workcentername                       AS ""WorkCenterName"",
                btt.additionalchargeid                  AS ""AdditionalChargeId"",
                ac.chargecode                           AS ""AdditionalChargeCode"",
                ac.chargename                           AS ""AdditionalChargeName"",
                btt.otherchargeid                       AS ""OtherChargeId"",
                oc.chargecode                           AS ""OtherChargeCode"",
                oc.chargename                           AS ""OtherChargeName"",
                btt.totalchargeid                       AS ""TotalChargeId"",
                tc.chargecode                           AS ""TotalChargeCode"",
                tc.chargename                           AS ""TotalChargeName"",
                btt.fixedaccountid                      AS ""FixedAccountId"",
                fa.accountcode                          AS ""FixedAccountCode"",
                fa.accountname                          AS ""FixedAccountName"",
                btt.cashaccountid                       AS ""CashAccountId"",
                ca.accountcode                          AS ""CashAccountCode"",
                ca.accountname                          AS ""CashAccountName"",
                btt.costofsalesaccountid                AS ""BIZTransactionTypeCostOfSalesAccountId"",
                csa.accountcode                         AS ""BIZTransactionTypeCostOfSalesAccountCode"",
                csa.accountname                         AS ""BIZTransactionTypeCostOfSalesAccountName"",
                btt.counterid                           AS ""CounterId"",
                cnt.countercode                         AS ""CounterCode"",
                cnt.countername                         AS ""CounterName"",
                btt.allocationtypeid                    AS ""AllocationTypeId"",
                alt.allocationtypecode                  AS ""AllocationTypeCode"",
                alt.allocationtypename                  AS ""AllocationTypeName"",
                btt.allocationid                        AS ""MAllocationId"",
                mal.allocationname                      AS ""MAllocationName"",
                btt.currencyid                          AS ""CurrencyId"",
                cur.currencycode                        AS ""CurrencyCode"",
                cur.currencyname                        AS ""CurrencyName"",
                cur.currencydecimal                     AS ""CurrencyCurrencyDecimal"",
                btt.lottypeid                           AS ""LotTypeId"",
                lot.lottypename                         AS ""LotTypeName"",
                btt.reportformatid                      AS ""ReportFormatId"",
                rft.reportformatname                    AS ""ReportFormatName"",
                rft.reportfile                          AS ""ReportFormatReportFile"",
                rft.datasourcefilename                  AS ""ReportFormatDataSourceFileName"",
                btt.partyid                             AS ""BIZTransactionTypePartyId"",
                par.partycode                           AS ""BIZTransactionTypePartyCode"",
                par.partyname                           AS ""BIZTransactionTypePartyName"",
                btt.outype                              AS ""BIZTransactionTypeOUType"",
                btt.nogenerationtype                    AS ""BIZTransactionTypeNOGenerationType"",
                btt.nogenerationperiodtype              AS ""BIZTransactionTypeNOGenerationPeriodType"",
                btt.numbersize                          AS ""BIZTransactionTypeNumberSize"",
                btt.prefix                              AS ""BIZTransactionTypePrefix"",
                btt.suffix                              AS ""BIZTransactionTypeSuffix"",
                btt.systemprefix                        AS ""BIZTransactionTypeSystemPrefix"",
                btt.systemsuffix                        AS ""BIZTransactionTypeSystemSuffix"",
                btt.ismulticurrencyapplicable           AS ""BIZTransactionTypeIsMultiCurrency"",
                btt.ismultipleou                        AS ""BIZTransactionTypeIsMultipleOU"",
                btt.iscostcenter                        AS ""BIZTransactionTypeIsCostCenter"",
                btt.ismultiplecostcategory              AS ""BIZTransactionTypeIsMultipleCostCategory"",
                btt.issplitcostcenter                   AS ""BIZTransactionTypeIsSplitCostCenter"",
                btt.isallocation                        AS ""BIZTransactionTypeIsAllocation"",
                btt.allocationnature                    AS ""BIZTransactionTypeAllocationNature"",
                btt.ismultipleuom                       AS ""BIZTransactionTypeIsMultipleUOM"",
                btt.ispackingquantity                   AS ""BIZTransactionTypeIsPackingQuality"",
                btt.ispackingdetailsrequired            AS ""BIZTransactionTypeIsPackingDetails"",
                btt.isbatchdetails                      AS ""BIZTransactionTypeIsBatchDetails"",
                btt.isbatchcreationpossible             AS ""BIZTransactionTypeIsBatchCreationPossible"",
                btt.isseparatebatchentrypossible        AS ""BIZTransactionTypeIsSeparateBatchEntryPossible"",
                btt.ismovementtype                      AS ""BIZTransactionTypeIsMovementType"",
                btt.istripbill                          AS ""BIZTransactionTypeIsTripBill"",
                btt.issuppliementary                    AS ""BIZTransactionTypeIsSuppliementary"",
                btt.ismultiplestores                    AS ""BIZTransactionTypeIsMultipleStores"",
                btt.isdeliveyrschedule                  AS ""BIZTransactionTypeIsDeliverySchedule"",
                btt.isscheme                            AS ""BIZTransactionTypeIsScheme"",
                btt.isfree                              AS ""BIZTransactionTypeIsFree"",
                btt.rateforfree                         AS ""BIZTransactionTypeRateForFree"",
                btt.isexcise                            AS ""BIZTransactionTypeIsExcise"",
                btt.iscenvat                            AS ""BIZTransactionTypeIsCenVat"",
                btt.istransactiontypechangeable         AS ""BIZTransactionTypeIsTransactionTypeChangeable"",
                btt.isformdetails                       AS ""BIZTransactionTypeIsFormDetails"",
                btt.accountposttype                     AS ""BIZTransactionTypeAccountPostType"",
                btt.accountpostbasis                    AS ""BIZTransactionTypeAccountPostBasis"",
                btt.accountvouchertype                  AS ""BIZTransactionTypeAccountVoucherType"",
                btt.ledgertype                          AS ""BIZTransactionTypeLedgerType"",
                btt.narrationtype                       AS ""BIZTransactionTypeNarrationType"",
                btt.billaccounttype                     AS ""BIZTransactionTypeBillAccountType"",
                btt.costofsalespostingtype              AS ""BIZTransactionTypeCostOfSalesPostingType"",
                btt.iscashcredit                        AS ""BIZTransactionTypeIsCashCredit"",
                btt.cashbillaccountingtype              AS ""BIZTransactionTypeCashBillAccountingType"",
                btt.stockposttype                       AS ""BIZTransactionTypeStockPostType"",
                btt.transferstockposttype               AS ""BIZTransactionTypeTransferStockPostType"",
                btt.stockchecktype                      AS ""BIZTransactionTypeStockCheckType"",
                btt.isselectionrequired                 AS ""BIZTransactionTypeIsSelection"",
                btt.selectionfromtype                   AS ""BIZTransactionTypeSelectionFromType"",
                btt.selectiontype                       AS ""BIZTransactionTypeSelectionType"",
                btt.isnonselectionentry                 AS ""BIZTransactionTypeIsNonSelectionEntry"",
                btt.isvarianceallowed                   AS ""BIZTransactionTypeIsVarianceAllowed"",
                btt.isquantityvariance                  AS ""BIZTransactionTypeIsQuantityVariance"",
                btt.isqualityvariance                   AS ""BIZTransactionTypeIsQualityVariance"",
                btt.isratevariance                      AS ""BIZTransactionTypeIsRateVariance"",
                btt.ispendingpost                       AS ""BIZTransactionTypeIsPendingPost"",
                btt.pendingforprocess                   AS ""BIZTransactionTypePendingForProcess"",
                btt.pendingforstock                     AS ""BIZTransactionTypePendingForStock"",
                btt.isintercompanytracking              AS ""BIZTransactionTypeIsInterCompanyTracking"",
                btt.isdeliverytracking                  AS ""BIZTransactionTypeIsDeliveryTracking"",
                btt.defaultdeliverytype                 AS ""BIZTransactionTypeDefaultDeliveryType"",
                btt.backdateentryday                    AS ""BIZTransactionTypeBackDateEntryDay"",
                btt.backdateupdateday                   AS ""BIZTransactionTypeBackDateUpdateDay"",
                btt.backdatedeleteday                   AS ""BIZTransactionTypeBackDateDeleteDay"",
                btt.backdatechecktype                   AS ""BIZTransactionTypeBackDateCheckType"",
                btt.forwardentryday                     AS ""BIZTransactionTypeForwardEntryDay"",
                btt.isstockcc                           AS ""BIZTransactionTypeIsStockCC"",
                btt.sortorder                           AS ""BIZTransactionTypeSortOrder"",
                btt.status                              AS ""BIZTransactionTypeStatus"",
                btt.iscancelapplicable                  AS ""BIZTransactionTypeIsCancelApplicable"",
                btt.iszerovalue                         AS ""BIZTransactionTypeIsZeroValue"",
                btt.purpose                             AS ""BIZTransactionTypePurpose"",
                btt.showhistory                         AS ""BIZTransactionTypeShowHistory"",
                btt.stockaccountposting                 AS ""BIZTransactionTypeStockAccountPosting"",
                btt.stockaccounttype                    AS ""BIZTransactionTypeStockAccountType"",
                btt.stockcontratype                     AS ""BIZTransactionTypeStockContraType"",
                btt.isforecastapplicable                AS ""BIZTransactionClassIsForeCastApplicable"",
                btt.materialaccountchangeable           AS ""BIZTransactionTypeMaterialAccountChangeable"",
                btt.israteperuomapplicable              AS ""BIZTransactionTypeRatePerUOMApplicable"",
                btt.isskuapplicable                     AS ""BIZTransactionTypeSKUApplicable"",
                btt.linewisetrackingrequired             AS ""BIZTransactionTypeLinewiseTrackingRequired"",
                btt.isactualquantity                    AS ""BIZTransactionTypeIsActualQuantity"",
                btt.isgoodquantity                      AS ""BIZTransactionTypeIsGoodQuantity"",
                btt.isrejectedquantity                  AS ""BIZTransactionTypeIsRejectedQuantity"",
                btt.isreworkquantity                    AS ""BIZTransactionTypeIsReworkQuantity"",
                btt.isotherquantity                     AS ""BIZTransactionTypeIsOtherQuantity"",
                btt.isbatchinheader                     AS ""BIZTransactionTypeIsBatchInHeader"",
                btt.frompackstatus                      AS ""BIZTransactionTypeFromPackStatus"",
                btt.topackstatus                        AS ""BIZTransactionTypeToPackStatus"",
                btt.printtype                           AS ""PrintType"",
                btt.isdiscountapplicable                AS ""BIZTransactionTypeIsDiscountApplicable"",
                btt.stockviewtype                       AS ""BIZTransactionTypeStockviewType"",
                btt.issuetype                           AS ""BIZTransactionTypeIssueType"",
                btt.isreasonapplicable                  AS ""BIZTransactionTypeIsReasonApplicable"",
                btt.isqualitydetails                    AS ""BIZTransactionTypeIsQualityDetails"",
                btt.isgrossweight                       AS ""BIZTransactionTypeIsGrossWeight"",
                btt.isnetweight                         AS ""BIZTransactionTypeIsNetWeight"",
                btt.istareweight                        AS ""BIZTransactionTypeIsTareWeight"",
                btt.attachmenttype                      AS ""BIZTransactionTypeAttachmentType"",
                btt.scanningrequired                    AS ""BIZTransactionTypeScanningRequired"",
                btt.isbizdimensiontype                  AS ""BIZTransactionTypeIsBizDimensionType"",
                btt.l1type                              AS ""BIZTransactionTypeL1Type"",
                btt.l2type                              AS ""BIZTransactionTypeL2Type"",
                btt.l3type                              AS ""BIZTransactionTypeL3Type"",
                btt.l4type                              AS ""BIZTransactionTypeL4Type"",
                btt.l5type                              AS ""BIZTransactionTypeL5Type"",
                btt.segmentid                           AS ""SegmentId"",
                btt.stockccid                           AS ""StockCCId"",
                scc.costcentercode                      AS ""StockCCCode"",
                scc.costcentername                      AS ""StockCCName"",
                btt.accountbiztransactiontypeid         AS ""AccountBizTransactionTypeId"",
                abt.biztransactiontypecode              AS ""AccountBizTransactionTypeCode"",
                abt.biztransactiontypename              AS ""AccountBizTransactionTypeName"",
                btt.selectionclassid                    AS ""SelectionClassId"",
                sbc.biztransactionclasscode             AS ""SelectionClassCode"",
                sbc.biztransactionclassname             AS ""SelectionClassName"",
                btt.selectionsubclassid                 AS ""SelectionSubClassId"",
                sbsc.biztransactionsubclasscode         AS ""SelectionSubClassCode"",
                sbsc.biztransactionsubclassname         AS ""SelectionSubClassName"",
                btt.partycriteriaconfigid               AS ""PartyCriteriaConfigId"",
                pcc.criteriaconfigname                  AS ""PartyCriteriaConfigName"",
                btt.selectionbiztransactionid           AS ""SelectionBIZTransactionId"",
                sbt.biztransactioncode                  AS ""SelectionBIZTransactionCode"",
                sbt.biztransactionname                  AS ""SelectionBIZTransactionName"",
                btt.headexciseregisterid                AS ""HeadExciseRegisterId"",
                her.exciseregistername                  AS ""HeadExciseRegisterName"",
                btt.itemexciseregisterid                AS ""ItemExciseRegisterId"",
                ier.exciseregistername                  AS ""ItemExciseRegisterName"",
                btt.ncrbiztransactionid                 AS ""NcrBiztransactionId"",
                nbt.biztransactioncode                  AS ""NcrBiztransactionCode"",
                nbt.biztransactionname                  AS ""NcrBiztransactionName"",
                btt.itemcriteriaconfigid                AS ""ItemCriteriaConfigId"",
                icc.criteriaconfigname                  AS ""ItemCriteriaConfigName"",
                btt.stockaccountbiztransactiontypeid    AS ""StockAccountBiztransactionTypeId"",
                sabt.biztransactiontypecode             AS ""StockAccountBiztransactionTypeCode"",
                sabt.biztransactiontypename             AS ""StockAccountBiztransactionTypeName"",
                btt.stockfixedaccountid                 AS ""StockFixedAccountId"",
                sfa.accountcode                         AS ""StockFixedAccountCode"",
                sfa.accountname                         AS ""StockFixedAccountName"",
                btt.stockcontraaccountid                AS ""StockContraAccountId"",
                sca.accountcode                         AS ""StockContraAccountCode"",
                sca.accountname                         AS ""StockContraAccountName"",
                btt.labourchargesaccountid              AS ""LabourChargesAccountId"",
                lca.accountcode                         AS ""LabourChargesAccountCode"",
                lca.accountname                         AS ""LabourChargesAccountName"",
                btt.labourchargespayableaccountid       AS ""LabourChargesPayableAccountId"",
                lcpa.accountcode                        AS ""LabourChargesPayableAccountCode"",
                lcpa.accountname                        AS ""LabourChargesPayableAccountName"",
                btt.termsetid                           AS ""TermsSetId"",
                ts.termssetname                         AS ""TermsSetName"",
                btt.multibiztransactionid               AS ""MultiBIZTransactionId"",
                mbt.biztransactioncode                  AS ""MultiBIZTransactionCode"",
                mbt.biztransactionname                  AS ""MultiBIZTransactionName"",
                btt.defaultskuid                        AS ""DefaultSKUId"",
                dsku.skucode                            AS ""DefaultSKUCode"",
                dsku.skuname                            AS ""DefaultSKUName"",
                btt.defaultitemid                       AS ""DefaultItemId"",
                di.itemcode                             AS ""DefaultItemCode"",
                di.itemname                             AS ""DefaultItemName"",
                btt.defaultouid                         AS ""DefaultOUId"",
                defou.organizationunitcode              AS ""DefaultOUCode"",
                defou.organizationunitname              AS ""DefaultOUName"",
                btt.costcentertypeid                    AS ""BIZTransactionTypeCostCenterTypeId"",
                cctype.costcentertypecode               AS ""BIZTransactionTypeCostCenterTypeCode"",
                cctype.costcentertypename               AS ""BIZTransactionTypeCostCenterTypeName"",
                btt.loadintermmbiztransactionid         AS ""LoadInterMMBiztransactionId"",
                limbt.biztransactioncode                AS ""LoadInterMMBiztransactionCode"",
                limbt.biztransactionname                AS ""LoadInterMMBiztransactionName"",
                btt.samplepartybranchid                 AS ""SamplePartyBranchId"",
                btt.autorejectionapplicable             AS ""AutoRejectionApplicable"",
                btt.showfields                          AS ""ShowFields"",
                btt.consumptionbiztransactionid         AS ""ConsumptionBIZTransactionId"",
                btt.isrecoverytrack                     AS ""BIZTransactionTypeIsRecoveryTrack"",
                btt.linewisereferencerequired           AS ""BIZTransactionTypeLinewiseReferenceRequired"",
                btt.skucreationallowed                  AS ""BIZTransactionTypeSKUCreationAllowed"",
                btt.maxdimensionallowed                 AS ""BIZTransactionTypeMaxDimensionAllowed"",
                btt.mrpdetailsrequired                  AS ""BIZTransactionTypeMRPDetailsRequired"",
                btt.isadvanceaccountposting             AS ""BIZTransactionTypeIsAdvanceAccountPosting"",
                btt.lotmarktype                         AS ""BIZTransactionTypeLotMarkType"",
                btt.pendingposting                      AS ""BIZTransactionTypePendingPosting"",
                btt.itemaliasrequired                   AS ""BIZTransactionTypeItemAliasRequired"",
                btt.itemextendedsearchrequired          AS ""BIZTransactionTypeItemExtendedSearchRequired"",
                btt.isbinrequired                       AS ""BIZTransactionTypeIsBinRequired"",
                btt.rateloading                         AS ""BIZTransactionTypeRateLoading"",
                btt.posttoitemparty                     AS ""BIZTransactionTypePostToItemParty"",
                btt.itemfromitempartyonly               AS ""BIZTransactionTypeItemFromItemParty"",
                btt.isioratio                           AS ""BIZTransactionTypeIsIoRatio"",
                btt.rejectionncr                        AS ""BIZTransactionTypeRejectionNCR"",
                btt.reworkncr                           AS ""BIZTransactionTypeReworkNCR"",
                btt.otherncr                            AS ""BIZTransactionTypeOtherNCR"",
                btt.previousprocess                     AS ""BIZTransactionTypePreviousProcess"",
                btt.includeforplanning                  AS ""BIZTransactionTypeIncludeForPlanning"",
                btt.createdbyid                         AS ""BIZTransactionTypeCreatedById"",
                btt.createdon                           AS ""BIZTransactionTypeCreatedOn"",
                btt.modifiedbyid                        AS ""BIZTransactionTypeModifiedById"",
                btt.modifiedon                          AS ""BIZTransactionTypeModifiedOn"",
                btt.sourcetype                          AS ""BIZTransactionTypeSourceType"",
                btt.version                             AS ""BIZTransactionTypeVersion"",
                btt.assetposttype                       AS ""BIZTransactionTypeAssetPostType"",
                btt.contractdetailtype                  AS ""BIZTransactionTypeContractDetailType""
            FROM mbiztransactiontype btt
            LEFT JOIN mbiztransactionclass btc      ON btc.biztransactionclassid = btt.biztransactionclassid
            LEFT JOIN mbiztransactionsubclass btsc  ON btsc.biztransactionsubclassid = btt.biztransactionsubclassid
            LEFT JOIN mbiztransaction bt            ON bt.biztransactionid = btt.biztransactionid
            LEFT JOIN morganizationunit ou          ON ou.ouid = btt.ouid
            LEFT JOIN morganizationgroup og         ON og.organizationgroupid = btt.ougroupid
            LEFT JOIN mperiod per                   ON per.periodid = btt.periodid
            LEFT JOIN mstore st                     ON st.storeid = btt.storeid
            LEFT JOIN mprocess pr                   ON pr.processid = btt.processid
            LEFT JOIN mworkcenter wc                ON wc.workcenterid = btt.workcenterid
            LEFT JOIN mcharge ac                    ON ac.chargeid = btt.additionalchargeid
            LEFT JOIN mcharge oc                    ON oc.chargeid = btt.otherchargeid
            LEFT JOIN mcharge tc                    ON tc.chargeid = btt.totalchargeid
            LEFT JOIN maccount fa                   ON fa.accountid = btt.fixedaccountid
            LEFT JOIN maccount ca                   ON ca.accountid = btt.cashaccountid
            LEFT JOIN maccount csa                  ON csa.accountid = btt.costofsalesaccountid
            LEFT JOIN mcounter cnt                  ON cnt.counterid = btt.counterid
            LEFT JOIN mallocationtype alt           ON alt.allocationtypeid = btt.allocationtypeid
            LEFT JOIN mallocation mal               ON mal.allocationid = btt.allocationid
            LEFT JOIN mcurrency cur                 ON cur.currencyid = btt.currencyid
            LEFT JOIN mlottype lot                  ON lot.lottypeid = btt.lottypeid
            LEFT JOIN mreportformat rft             ON rft.reportformatid = btt.reportformatid
            LEFT JOIN mparty par                    ON par.partyid = btt.partyid
            LEFT JOIN mcostcenter scc               ON scc.costcenterid = btt.stockccid
            LEFT JOIN mbiztransactiontype abt       ON abt.biztransactiontypeid = btt.accountbiztransactiontypeid
            LEFT JOIN mbiztransactionclass sbc      ON sbc.biztransactionclassid = btt.selectionclassid
            LEFT JOIN mbiztransactionsubclass sbsc  ON sbsc.biztransactionsubclassid = btt.selectionsubclassid
            LEFT JOIN tcriteriaconfig pcc           ON pcc.criteriaconfigid = btt.partycriteriaconfigid
            LEFT JOIN mbiztransaction sbt           ON sbt.biztransactionid = btt.selectionbiztransactionid
            LEFT JOIN mexciseregister her           ON her.exciseregisterid = btt.headexciseregisterid
            LEFT JOIN mexciseregister ier           ON ier.exciseregisterid = btt.itemexciseregisterid
            LEFT JOIN mbiztransaction nbt           ON nbt.biztransactionid = btt.ncrbiztransactionid
            LEFT JOIN tcriteriaconfig icc           ON icc.criteriaconfigid = btt.itemcriteriaconfigid
            LEFT JOIN mbiztransactiontype sabt      ON sabt.biztransactiontypeid = btt.stockaccountbiztransactiontypeid
            LEFT JOIN maccount sfa                  ON sfa.accountid = btt.stockfixedaccountid
            LEFT JOIN maccount sca                  ON sca.accountid = btt.stockcontraaccountid
            LEFT JOIN maccount lca                  ON lca.accountid = btt.labourchargesaccountid
            LEFT JOIN maccount lcpa                 ON lcpa.accountid = btt.labourchargespayableaccountid
            LEFT JOIN mtermsset ts                  ON ts.termssetid = btt.termsetid
            LEFT JOIN mbiztransaction mbt           ON mbt.biztransactionid = btt.multibiztransactionid
            LEFT JOIN msku dsku                     ON dsku.skuid = btt.defaultskuid
            LEFT JOIN mitem di                      ON di.itemid = btt.defaultitemid
            LEFT JOIN morganizationunit defou       ON defou.ouid = btt.defaultouid
            LEFT JOIN mcostcentertype cctype        ON cctype.costcentertypeid = btt.costcentertypeid
            LEFT JOIN mbiztransaction limbt         ON limbt.biztransactionid = btt.loadintermmbiztransactionid
            WHERE btt.biztransactiontypeid = @biztransactiontypeid;";

        public const string GET_DBLEVELSETTING = @"
            SELECT
                ISCANCELAPPLICABLE              AS DBLevelSettingIsCancelApplicable,
                ISCANCELDELETEONLYFORPENDING    AS DBLevelSettingIsCancelDeleteOnlyForPending,
                D1LABEL                         AS D1Label,
                D2LABEL                         AS D2Label,
                D3LABEL                         AS D3Label,
                D4LABEL                         AS D4Label,
                D5LABEL                         AS D5Label
            FROM MDBLEVELSETTING;";

        public const string PG_GET_DBLEVELSETTING = @"
            SELECT
                iscancelapplicable              AS ""DBLevelSettingIsCancelApplicable"",
                iscanceldeleteonlyforpending    AS ""DBLevelSettingIsCancelDeleteOnlyForPending"",
                d1label                         AS ""D1Label"",
                d2label                         AS ""D2Label"",
                d3label                         AS ""D3Label"",
                d4label                         AS ""D4Label"",
                d5label                         AS ""D5Label""
            FROM mdblevelsetting;";
        // Ported from GB4 BIZTransactionTypeBLL.SaveBIZTransactionTypeNew / BizTransactionTypeQueryBuilder.
        // Column list generated from this file's own GET_BIZTRANSACTIONTYPE_DETAILS_SQL (own-table
        // btt.* columns only) and cross-checked against every property name against BIZTransactionTypeDTO.cs -
        // 3 mismatches were found there (SELECT alias vs actual DTO property) and corrected here:
        // COSTCENTERTYPEID -> CostCenterTypeId (not BIZTransactionTypeCostCenterTypeId), AUTOREJECTIONAPPLICABLE
        // -> BIZTransactionTypeAutoRejectionApplicable, SHOWFIELDS -> BIZTransactionTypeShowFields (not the
        // un-prefixed aliases the existing SELECT uses).
        public const string CHECK_BIZTRANSACTIONTYPE_EXISTS = @"
SELECT COUNT(BIZTRANSACTIONTYPEID) FROM MBIZTRANSACTIONTYPE
WHERE BIZTRANSACTIONID = @BizTransactionId AND OUID = @OUId AND PERIODID = @PeriodId;";

        public const string INSERT_BIZTRANSACTIONTYPE = @"
INSERT INTO MBIZTRANSACTIONTYPE
(
                BIZTRANSACTIONTYPEID,
                BIZTRANSACTIONTYPECODE,
                BIZTRANSACTIONTYPENAME,
                BIZTRANSACTIONCLASSID,
                BIZTRANSACTIONSUBCLASSID,
                BIZTRANSACTIONID,
                OUID,
                OUGROUPID,
                PERIODID,
                STOREID,
                PROCESSID,
                WORKCENTERID,
                ADDITIONALCHARGEID,
                OTHERCHARGEID,
                TOTALCHARGEID,
                FIXEDACCOUNTID,
                CASHACCOUNTID,
                COSTOFSALESACCOUNTID,
                COUNTERID,
                ALLOCATIONTYPEID,
                ALLOCATIONID,
                CURRENCYID,
                LOTTYPEID,
                REPORTFORMATID,
                PARTYID,
                OUTYPE,
                NOGENERATIONTYPE,
                NOGENERATIONPERIODTYPE,
                NUMBERSIZE,
                PREFIX,
                SUFFIX,
                SYSTEMPREFIX,
                SYSTEMSUFFIX,
                ISMULTICURRENCYAPPLICABLE,
                ISMULTIPLEOU,
                ISCOSTCENTER,
                ISMULTIPLECOSTCATEGORY,
                ISSPLITCOSTCENTER,
                ISALLOCATION,
                ALLOCATIONNATURE,
                ISMULTIPLEUOM,
                ISPACKINGQUANTITY,
                ISPACKINGDETAILSREQUIRED,
                ISBATCHDETAILS,
                ISBATCHCREATIONPOSSIBLE,
                ISSEPARATEBATCHENTRYPOSSIBLE,
                ISMOVEMENTTYPE,
                ISTRIPBILL,
                ISSUPPLIEMENTARY,
                ISMULTIPLESTORES,
                ISDELIVEYRSCHEDULE,
                ISSCHEME,
                ISFREE,
                RATEFORFREE,
                ISEXCISE,
                ISCENVAT,
                ISTRANSACTIONTYPECHANGEABLE,
                ISFORMDETAILS,
                ACCOUNTPOSTTYPE,
                ACCOUNTPOSTBASIS,
                ACCOUNTVOUCHERTYPE,
                LEDGERTYPE,
                NARRATIONTYPE,
                BILLACCOUNTTYPE,
                COSTOFSALESPOSTINGTYPE,
                ISCASHCREDIT,
                CASHBILLACCOUNTINGTYPE,
                STOCKPOSTTYPE,
                TRANSFERSTOCKPOSTTYPE,
                STOCKCHECKTYPE,
                ISSELECTIONREQUIRED,
                SELECTIONFROMTYPE,
                SELECTIONTYPE,
                ISNONSELECTIONENTRY,
                ISVARIANCEALLOWED,
                ISQUANTITYVARIANCE,
                ISQUALITYVARIANCE,
                ISRATEVARIANCE,
                ISPENDINGPOST,
                PENDINGFORPROCESS,
                PENDINGFORSTOCK,
                ISINTERCOMPANYTRACKING,
                ISDELIVERYTRACKING,
                DEFAULTDELIVERYTYPE,
                BACKDATEENTRYDAY,
                BACKDATEUPDATEDAY,
                BACKDATEDELETEDAY,
                BACKDATECHECKTYPE,
                FORWARDENTRYDAY,
                ISSTOCKCC,
                SORTORDER,
                STATUS,
                ISCANCELAPPLICABLE,
                ISZEROVALUE,
                PURPOSE,
                SHOWHISTORY,
                STOCKACCOUNTPOSTING,
                STOCKACCOUNTTYPE,
                STOCKCONTRATYPE,
                ISFORECASTAPPLICABLE,
                MATERIALACCOUNTCHANGEABLE,
                ISRATEPERUOMAPPLICABLE,
                ISSKUAPPLICABLE,
                LINEWISETRACKINGREQUIRED,
                ISACTUALQUANTITY,
                ISGOODQUANTITY,
                ISREJECTEDQUANTITY,
                ISREWORKQUANTITY,
                ISOTHERQUANTITY,
                ISBATCHINHEADER,
                FROMPACKSTATUS,
                TOPACKSTATUS,
                PRINTTYPE,
                ISDISCOUNTAPPLICABLE,
                STOCKVIEWTYPE,
                ISSUETYPE,
                ISREASONAPPLICABLE,
                ISQUALITYDETAILS,
                ISGROSSWEIGHT,
                ISNETWEIGHT,
                ISTAREWEIGHT,
                ATTACHMENTTYPE,
                SCANNINGREQUIRED,
                ISBIZDIMENSIONTYPE,
                L1TYPE,
                L2TYPE,
                L3TYPE,
                L4TYPE,
                L5TYPE,
                SEGMENTID,
                STOCKCCID,
                ACCOUNTBIZTRANSACTIONTYPEID,
                SELECTIONCLASSID,
                SELECTIONSUBCLASSID,
                PARTYCRITERIACONFIGID,
                SELECTIONBIZTRANSACTIONID,
                HEADEXCISEREGISTERID,
                ITEMEXCISEREGISTERID,
                NCRBIZTRANSACTIONID,
                ITEMCRITERIACONFIGID,
                STOCKACCOUNTBIZTRANSACTIONTYPEID,
                STOCKFIXEDACCOUNTID,
                STOCKCONTRAACCOUNTID,
                LABOURCHARGESACCOUNTID,
                LABOURCHARGESPAYABLEACCOUNTID,
                TERMSETID,
                MULTIBIZTRANSACTIONID,
                DEFAULTSKUID,
                DEFAULTITEMID,
                DEFAULTOUID,
                COSTCENTERTYPEID,
                LOADINTERMMBIZTRANSACTIONID,
                SAMPLEPARTYBRANCHID,
                AUTOREJECTIONAPPLICABLE,
                SHOWFIELDS,
                CONSUMPTIONBIZTRANSACTIONID,
                ISRECOVERYTRACK,
                LINEWISEREFERENCEREQUIRED,
                SKUCREATIONALLOWED,
                MAXDIMENSIONALLOWED,
                MRPDETAILSREQUIRED,
                ISADVANCEACCOUNTPOSTING,
                LOTMARKTYPE,
                PENDINGPOSTING,
                ITEMALIASREQUIRED,
                ITEMEXTENDEDSEARCHREQUIRED,
                ISBINREQUIRED,
                RATELOADING,
                POSTTOITEMPARTY,
                ITEMFROMITEMPARTYONLY,
                ISIORATIO,
                REJECTIONNCR,
                REWORKNCR,
                OTHERNCR,
                PREVIOUSPROCESS,
                INCLUDEFORPLANNING,
                CREATEDBYID,
                CREATEDON,
                MODIFIEDBYID,
                MODIFIEDON,
                SOURCETYPE,
                VERSION,
                ASSETPOSTTYPE,
                CONTRACTDETAILTYPE
)
VALUES
(
                @BIZTransactionTypeId,
                @BIZTransactionTypeCode,
                @BIZTransactionTypeName,
                @BIZTransactionTypeClassId,
                @BIZTransactionTypeSubClassId,
                @BIZTransactionId,
                @OrganizationUnitId,
                @OrganizationGroupId,
                @PeriodId,
                @StoreId,
                @ProcessId,
                @WorkCenterId,
                @AdditionalChargeId,
                @OtherChargeId,
                @TotalChargeId,
                @FixedAccountId,
                @CashAccountId,
                @BIZTransactionTypeCostOfSalesAccountId,
                @CounterId,
                @AllocationTypeId,
                @MAllocationId,
                @CurrencyId,
                @LotTypeId,
                @ReportFormatId,
                @BIZTransactionTypePartyId,
                @BIZTransactionTypeOUType,
                @BIZTransactionTypeNOGenerationType,
                @BIZTransactionTypeNOGenerationPeriodType,
                @BIZTransactionTypeNumberSize,
                @BIZTransactionTypePrefix,
                @BIZTransactionTypeSuffix,
                @BIZTransactionTypeSystemPrefix,
                @BIZTransactionTypeSystemSuffix,
                @BIZTransactionTypeIsMultiCurrency,
                @BIZTransactionTypeIsMultipleOU,
                @BIZTransactionTypeIsCostCenter,
                @BIZTransactionTypeIsMultipleCostCategory,
                @BIZTransactionTypeIsSplitCostCenter,
                @BIZTransactionTypeIsAllocation,
                @BIZTransactionTypeAllocationNature,
                @BIZTransactionTypeIsMultipleUOM,
                @BIZTransactionTypeIsPackingQuality,
                @BIZTransactionTypeIsPackingDetails,
                @BIZTransactionTypeIsBatchDetails,
                @BIZTransactionTypeIsBatchCreationPossible,
                @BIZTransactionTypeIsSeparateBatchEntryPossible,
                @BIZTransactionTypeIsMovementType,
                @BIZTransactionTypeIsTripBill,
                @BIZTransactionTypeIsSuppliementary,
                @BIZTransactionTypeIsMultipleStores,
                @BIZTransactionTypeIsDeliverySchedule,
                @BIZTransactionTypeIsScheme,
                @BIZTransactionTypeIsFree,
                @BIZTransactionTypeRateForFree,
                @BIZTransactionTypeIsExcise,
                @BIZTransactionTypeIsCenVat,
                @BIZTransactionTypeIsTransactionTypeChangeable,
                @BIZTransactionTypeIsFormDetails,
                @BIZTransactionTypeAccountPostType,
                @BIZTransactionTypeAccountPostBasis,
                @BIZTransactionTypeAccountVoucherType,
                @BIZTransactionTypeLedgerType,
                @BIZTransactionTypeNarrationType,
                @BIZTransactionTypeBillAccountType,
                @BIZTransactionTypeCostOfSalesPostingType,
                @BIZTransactionTypeIsCashCredit,
                @BIZTransactionTypeCashBillAccountingType,
                @BIZTransactionTypeStockPostType,
                @BIZTransactionTypeTransferStockPostType,
                @BIZTransactionTypeStockCheckType,
                @BIZTransactionTypeIsSelection,
                @BIZTransactionTypeSelectionFromType,
                @BIZTransactionTypeSelectionType,
                @BIZTransactionTypeIsNonSelectionEntry,
                @BIZTransactionTypeIsVarianceAllowed,
                @BIZTransactionTypeIsQuantityVariance,
                @BIZTransactionTypeIsQualityVariance,
                @BIZTransactionTypeIsRateVariance,
                @BIZTransactionTypeIsPendingPost,
                @BIZTransactionTypePendingForProcess,
                @BIZTransactionTypePendingForStock,
                @BIZTransactionTypeIsInterCompanyTracking,
                @BIZTransactionTypeIsDeliveryTracking,
                @BIZTransactionTypeDefaultDeliveryType,
                @BIZTransactionTypeBackDateEntryDay,
                @BIZTransactionTypeBackDateUpdateDay,
                @BIZTransactionTypeBackDateDeleteDay,
                @BIZTransactionTypeBackDateCheckType,
                @BIZTransactionTypeForwardEntryDay,
                @BIZTransactionTypeIsStockCC,
                @BIZTransactionTypeSortOrder,
                @BIZTransactionTypeStatus,
                @BIZTransactionTypeIsCancelApplicable,
                @BIZTransactionTypeIsZeroValue,
                @BIZTransactionTypePurpose,
                @BIZTransactionTypeShowHistory,
                @BIZTransactionTypeStockAccountPosting,
                @BIZTransactionTypeStockAccountType,
                @BIZTransactionTypeStockContraType,
                @BIZTransactionClassIsForeCastApplicable,
                @BIZTransactionTypeMaterialAccountChangeable,
                @BIZTransactionTypeRatePerUOMApplicable,
                @BIZTransactionTypeSKUApplicable,
                @BIZTransactionTypeLinewiseTrackingRequired,
                @BIZTransactionTypeIsActualQuantity,
                @BIZTransactionTypeIsGoodQuantity,
                @BIZTransactionTypeIsRejectedQuantity,
                @BIZTransactionTypeIsReworkQuantity,
                @BIZTransactionTypeIsOtherQuantity,
                @BIZTransactionTypeIsBatchInHeader,
                @BIZTransactionTypeFromPackStatus,
                @BIZTransactionTypeToPackStatus,
                @PrintType,
                @BIZTransactionTypeIsDiscountApplicable,
                @BIZTransactionTypeStockviewType,
                @BIZTransactionTypeIssueType,
                @BIZTransactionTypeIsReasonApplicable,
                @BIZTransactionTypeIsQualityDetails,
                @BIZTransactionTypeIsGrossWeight,
                @BIZTransactionTypeIsNetWeight,
                @BIZTransactionTypeIsTareWeight,
                @BIZTransactionTypeAttachmentType,
                @BIZTransactionTypeScanningRequired,
                @BIZTransactionTypeIsBizDimensionType,
                @BIZTransactionTypeL1Type,
                @BIZTransactionTypeL2Type,
                @BIZTransactionTypeL3Type,
                @BIZTransactionTypeL4Type,
                @BIZTransactionTypeL5Type,
                @SegmentId,
                @StockCCId,
                @AccountBizTransactionTypeId,
                @SelectionClassId,
                @SelectionSubClassId,
                @PartyCriteriaConfigId,
                @SelectionBIZTransactionId,
                @HeadExciseRegisterId,
                @ItemExciseRegisterId,
                @NcrBiztransactionId,
                @ItemCriteriaConfigId,
                @StockAccountBiztransactionTypeId,
                @StockFixedAccountId,
                @StockContraAccountId,
                @LabourChargesAccountId,
                @LabourChargesPayableAccountId,
                @TermsSetId,
                @MultiBIZTransactionId,
                @DefaultSKUId,
                @DefaultItemId,
                @DefaultOUId,
                @CostCenterTypeId,
                @LoadInterMMBiztransactionId,
                @SamplePartyBranchId,
                @BIZTransactionTypeAutoRejectionApplicable,
                @BIZTransactionTypeShowFields,
                @ConsumptionBIZTransactionId,
                @BIZTransactionTypeIsRecoveryTrack,
                @BIZTransactionTypeLinewiseReferenceRequired,
                @BIZTransactionTypeSKUCreationAllowed,
                @BIZTransactionTypeMaxDimensionAllowed,
                @BIZTransactionTypeMRPDetailsRequired,
                @BIZTransactionTypeIsAdvanceAccountPosting,
                @BIZTransactionTypeLotMarkType,
                @BIZTransactionTypePendingPosting,
                @BIZTransactionTypeItemAliasRequired,
                @BIZTransactionTypeItemExtendedSearchRequired,
                @BIZTransactionTypeIsBinRequired,
                @BIZTransactionTypeRateLoading,
                @BIZTransactionTypePostToItemParty,
                @BIZTransactionTypeItemFromItemParty,
                @BIZTransactionTypeIsIoRatio,
                @BIZTransactionTypeRejectionNCR,
                @BIZTransactionTypeReworkNCR,
                @BIZTransactionTypeOtherNCR,
                @BIZTransactionTypePreviousProcess,
                @BIZTransactionTypeIncludeForPlanning,
                @BIZTransactionTypeCreatedById,
                @BIZTransactionTypeCreatedOn,
                @BIZTransactionTypeModifiedById,
                @BIZTransactionTypeModifiedOn,
                @BIZTransactionTypeSourceType,
                @BIZTransactionTypeVersion,
                @BIZTransactionTypeAssetPostType,
                @BIZTransactionTypeContractDetailType
);";

        public const string UPDATE_BIZTRANSACTIONTYPE = @"
UPDATE MBIZTRANSACTIONTYPE SET
                BIZTRANSACTIONTYPECODE = @BIZTransactionTypeCode,
                BIZTRANSACTIONTYPENAME = @BIZTransactionTypeName,
                BIZTRANSACTIONCLASSID = @BIZTransactionTypeClassId,
                BIZTRANSACTIONSUBCLASSID = @BIZTransactionTypeSubClassId,
                BIZTRANSACTIONID = @BIZTransactionId,
                OUID = @OrganizationUnitId,
                OUGROUPID = @OrganizationGroupId,
                PERIODID = @PeriodId,
                STOREID = @StoreId,
                PROCESSID = @ProcessId,
                WORKCENTERID = @WorkCenterId,
                ADDITIONALCHARGEID = @AdditionalChargeId,
                OTHERCHARGEID = @OtherChargeId,
                TOTALCHARGEID = @TotalChargeId,
                FIXEDACCOUNTID = @FixedAccountId,
                CASHACCOUNTID = @CashAccountId,
                COSTOFSALESACCOUNTID = @BIZTransactionTypeCostOfSalesAccountId,
                COUNTERID = @CounterId,
                ALLOCATIONTYPEID = @AllocationTypeId,
                ALLOCATIONID = @MAllocationId,
                CURRENCYID = @CurrencyId,
                LOTTYPEID = @LotTypeId,
                REPORTFORMATID = @ReportFormatId,
                PARTYID = @BIZTransactionTypePartyId,
                OUTYPE = @BIZTransactionTypeOUType,
                NOGENERATIONTYPE = @BIZTransactionTypeNOGenerationType,
                NOGENERATIONPERIODTYPE = @BIZTransactionTypeNOGenerationPeriodType,
                NUMBERSIZE = @BIZTransactionTypeNumberSize,
                PREFIX = @BIZTransactionTypePrefix,
                SUFFIX = @BIZTransactionTypeSuffix,
                SYSTEMPREFIX = @BIZTransactionTypeSystemPrefix,
                SYSTEMSUFFIX = @BIZTransactionTypeSystemSuffix,
                ISMULTICURRENCYAPPLICABLE = @BIZTransactionTypeIsMultiCurrency,
                ISMULTIPLEOU = @BIZTransactionTypeIsMultipleOU,
                ISCOSTCENTER = @BIZTransactionTypeIsCostCenter,
                ISMULTIPLECOSTCATEGORY = @BIZTransactionTypeIsMultipleCostCategory,
                ISSPLITCOSTCENTER = @BIZTransactionTypeIsSplitCostCenter,
                ISALLOCATION = @BIZTransactionTypeIsAllocation,
                ALLOCATIONNATURE = @BIZTransactionTypeAllocationNature,
                ISMULTIPLEUOM = @BIZTransactionTypeIsMultipleUOM,
                ISPACKINGQUANTITY = @BIZTransactionTypeIsPackingQuality,
                ISPACKINGDETAILSREQUIRED = @BIZTransactionTypeIsPackingDetails,
                ISBATCHDETAILS = @BIZTransactionTypeIsBatchDetails,
                ISBATCHCREATIONPOSSIBLE = @BIZTransactionTypeIsBatchCreationPossible,
                ISSEPARATEBATCHENTRYPOSSIBLE = @BIZTransactionTypeIsSeparateBatchEntryPossible,
                ISMOVEMENTTYPE = @BIZTransactionTypeIsMovementType,
                ISTRIPBILL = @BIZTransactionTypeIsTripBill,
                ISSUPPLIEMENTARY = @BIZTransactionTypeIsSuppliementary,
                ISMULTIPLESTORES = @BIZTransactionTypeIsMultipleStores,
                ISDELIVEYRSCHEDULE = @BIZTransactionTypeIsDeliverySchedule,
                ISSCHEME = @BIZTransactionTypeIsScheme,
                ISFREE = @BIZTransactionTypeIsFree,
                RATEFORFREE = @BIZTransactionTypeRateForFree,
                ISEXCISE = @BIZTransactionTypeIsExcise,
                ISCENVAT = @BIZTransactionTypeIsCenVat,
                ISTRANSACTIONTYPECHANGEABLE = @BIZTransactionTypeIsTransactionTypeChangeable,
                ISFORMDETAILS = @BIZTransactionTypeIsFormDetails,
                ACCOUNTPOSTTYPE = @BIZTransactionTypeAccountPostType,
                ACCOUNTPOSTBASIS = @BIZTransactionTypeAccountPostBasis,
                ACCOUNTVOUCHERTYPE = @BIZTransactionTypeAccountVoucherType,
                LEDGERTYPE = @BIZTransactionTypeLedgerType,
                NARRATIONTYPE = @BIZTransactionTypeNarrationType,
                BILLACCOUNTTYPE = @BIZTransactionTypeBillAccountType,
                COSTOFSALESPOSTINGTYPE = @BIZTransactionTypeCostOfSalesPostingType,
                ISCASHCREDIT = @BIZTransactionTypeIsCashCredit,
                CASHBILLACCOUNTINGTYPE = @BIZTransactionTypeCashBillAccountingType,
                STOCKPOSTTYPE = @BIZTransactionTypeStockPostType,
                TRANSFERSTOCKPOSTTYPE = @BIZTransactionTypeTransferStockPostType,
                STOCKCHECKTYPE = @BIZTransactionTypeStockCheckType,
                ISSELECTIONREQUIRED = @BIZTransactionTypeIsSelection,
                SELECTIONFROMTYPE = @BIZTransactionTypeSelectionFromType,
                SELECTIONTYPE = @BIZTransactionTypeSelectionType,
                ISNONSELECTIONENTRY = @BIZTransactionTypeIsNonSelectionEntry,
                ISVARIANCEALLOWED = @BIZTransactionTypeIsVarianceAllowed,
                ISQUANTITYVARIANCE = @BIZTransactionTypeIsQuantityVariance,
                ISQUALITYVARIANCE = @BIZTransactionTypeIsQualityVariance,
                ISRATEVARIANCE = @BIZTransactionTypeIsRateVariance,
                ISPENDINGPOST = @BIZTransactionTypeIsPendingPost,
                PENDINGFORPROCESS = @BIZTransactionTypePendingForProcess,
                PENDINGFORSTOCK = @BIZTransactionTypePendingForStock,
                ISINTERCOMPANYTRACKING = @BIZTransactionTypeIsInterCompanyTracking,
                ISDELIVERYTRACKING = @BIZTransactionTypeIsDeliveryTracking,
                DEFAULTDELIVERYTYPE = @BIZTransactionTypeDefaultDeliveryType,
                BACKDATEENTRYDAY = @BIZTransactionTypeBackDateEntryDay,
                BACKDATEUPDATEDAY = @BIZTransactionTypeBackDateUpdateDay,
                BACKDATEDELETEDAY = @BIZTransactionTypeBackDateDeleteDay,
                BACKDATECHECKTYPE = @BIZTransactionTypeBackDateCheckType,
                FORWARDENTRYDAY = @BIZTransactionTypeForwardEntryDay,
                ISSTOCKCC = @BIZTransactionTypeIsStockCC,
                SORTORDER = @BIZTransactionTypeSortOrder,
                STATUS = @BIZTransactionTypeStatus,
                ISCANCELAPPLICABLE = @BIZTransactionTypeIsCancelApplicable,
                ISZEROVALUE = @BIZTransactionTypeIsZeroValue,
                PURPOSE = @BIZTransactionTypePurpose,
                SHOWHISTORY = @BIZTransactionTypeShowHistory,
                STOCKACCOUNTPOSTING = @BIZTransactionTypeStockAccountPosting,
                STOCKACCOUNTTYPE = @BIZTransactionTypeStockAccountType,
                STOCKCONTRATYPE = @BIZTransactionTypeStockContraType,
                ISFORECASTAPPLICABLE = @BIZTransactionClassIsForeCastApplicable,
                MATERIALACCOUNTCHANGEABLE = @BIZTransactionTypeMaterialAccountChangeable,
                ISRATEPERUOMAPPLICABLE = @BIZTransactionTypeRatePerUOMApplicable,
                ISSKUAPPLICABLE = @BIZTransactionTypeSKUApplicable,
                LINEWISETRACKINGREQUIRED = @BIZTransactionTypeLinewiseTrackingRequired,
                ISACTUALQUANTITY = @BIZTransactionTypeIsActualQuantity,
                ISGOODQUANTITY = @BIZTransactionTypeIsGoodQuantity,
                ISREJECTEDQUANTITY = @BIZTransactionTypeIsRejectedQuantity,
                ISREWORKQUANTITY = @BIZTransactionTypeIsReworkQuantity,
                ISOTHERQUANTITY = @BIZTransactionTypeIsOtherQuantity,
                ISBATCHINHEADER = @BIZTransactionTypeIsBatchInHeader,
                FROMPACKSTATUS = @BIZTransactionTypeFromPackStatus,
                TOPACKSTATUS = @BIZTransactionTypeToPackStatus,
                PRINTTYPE = @PrintType,
                ISDISCOUNTAPPLICABLE = @BIZTransactionTypeIsDiscountApplicable,
                STOCKVIEWTYPE = @BIZTransactionTypeStockviewType,
                ISSUETYPE = @BIZTransactionTypeIssueType,
                ISREASONAPPLICABLE = @BIZTransactionTypeIsReasonApplicable,
                ISQUALITYDETAILS = @BIZTransactionTypeIsQualityDetails,
                ISGROSSWEIGHT = @BIZTransactionTypeIsGrossWeight,
                ISNETWEIGHT = @BIZTransactionTypeIsNetWeight,
                ISTAREWEIGHT = @BIZTransactionTypeIsTareWeight,
                ATTACHMENTTYPE = @BIZTransactionTypeAttachmentType,
                SCANNINGREQUIRED = @BIZTransactionTypeScanningRequired,
                ISBIZDIMENSIONTYPE = @BIZTransactionTypeIsBizDimensionType,
                L1TYPE = @BIZTransactionTypeL1Type,
                L2TYPE = @BIZTransactionTypeL2Type,
                L3TYPE = @BIZTransactionTypeL3Type,
                L4TYPE = @BIZTransactionTypeL4Type,
                L5TYPE = @BIZTransactionTypeL5Type,
                SEGMENTID = @SegmentId,
                STOCKCCID = @StockCCId,
                ACCOUNTBIZTRANSACTIONTYPEID = @AccountBizTransactionTypeId,
                SELECTIONCLASSID = @SelectionClassId,
                SELECTIONSUBCLASSID = @SelectionSubClassId,
                PARTYCRITERIACONFIGID = @PartyCriteriaConfigId,
                SELECTIONBIZTRANSACTIONID = @SelectionBIZTransactionId,
                HEADEXCISEREGISTERID = @HeadExciseRegisterId,
                ITEMEXCISEREGISTERID = @ItemExciseRegisterId,
                NCRBIZTRANSACTIONID = @NcrBiztransactionId,
                ITEMCRITERIACONFIGID = @ItemCriteriaConfigId,
                STOCKACCOUNTBIZTRANSACTIONTYPEID = @StockAccountBiztransactionTypeId,
                STOCKFIXEDACCOUNTID = @StockFixedAccountId,
                STOCKCONTRAACCOUNTID = @StockContraAccountId,
                LABOURCHARGESACCOUNTID = @LabourChargesAccountId,
                LABOURCHARGESPAYABLEACCOUNTID = @LabourChargesPayableAccountId,
                TERMSETID = @TermsSetId,
                MULTIBIZTRANSACTIONID = @MultiBIZTransactionId,
                DEFAULTSKUID = @DefaultSKUId,
                DEFAULTITEMID = @DefaultItemId,
                DEFAULTOUID = @DefaultOUId,
                COSTCENTERTYPEID = @CostCenterTypeId,
                LOADINTERMMBIZTRANSACTIONID = @LoadInterMMBiztransactionId,
                SAMPLEPARTYBRANCHID = @SamplePartyBranchId,
                AUTOREJECTIONAPPLICABLE = @BIZTransactionTypeAutoRejectionApplicable,
                SHOWFIELDS = @BIZTransactionTypeShowFields,
                CONSUMPTIONBIZTRANSACTIONID = @ConsumptionBIZTransactionId,
                ISRECOVERYTRACK = @BIZTransactionTypeIsRecoveryTrack,
                LINEWISEREFERENCEREQUIRED = @BIZTransactionTypeLinewiseReferenceRequired,
                SKUCREATIONALLOWED = @BIZTransactionTypeSKUCreationAllowed,
                MAXDIMENSIONALLOWED = @BIZTransactionTypeMaxDimensionAllowed,
                MRPDETAILSREQUIRED = @BIZTransactionTypeMRPDetailsRequired,
                ISADVANCEACCOUNTPOSTING = @BIZTransactionTypeIsAdvanceAccountPosting,
                LOTMARKTYPE = @BIZTransactionTypeLotMarkType,
                PENDINGPOSTING = @BIZTransactionTypePendingPosting,
                ITEMALIASREQUIRED = @BIZTransactionTypeItemAliasRequired,
                ITEMEXTENDEDSEARCHREQUIRED = @BIZTransactionTypeItemExtendedSearchRequired,
                ISBINREQUIRED = @BIZTransactionTypeIsBinRequired,
                RATELOADING = @BIZTransactionTypeRateLoading,
                POSTTOITEMPARTY = @BIZTransactionTypePostToItemParty,
                ITEMFROMITEMPARTYONLY = @BIZTransactionTypeItemFromItemParty,
                ISIORATIO = @BIZTransactionTypeIsIoRatio,
                REJECTIONNCR = @BIZTransactionTypeRejectionNCR,
                REWORKNCR = @BIZTransactionTypeReworkNCR,
                OTHERNCR = @BIZTransactionTypeOtherNCR,
                PREVIOUSPROCESS = @BIZTransactionTypePreviousProcess,
                INCLUDEFORPLANNING = @BIZTransactionTypeIncludeForPlanning,
                MODIFIEDBYID = @BIZTransactionTypeModifiedById,
                MODIFIEDON = @BIZTransactionTypeModifiedOn,
                SOURCETYPE = @BIZTransactionTypeSourceType,
                VERSION = @BIZTransactionTypeVersion,
                ASSETPOSTTYPE = @BIZTransactionTypeAssetPostType,
                CONTRACTDETAILTYPE = @BIZTransactionTypeContractDetailType
WHERE BIZTRANSACTIONTYPEID = @BIZTransactionTypeId;";
    }
}