{
  "dBType" : "MYSQL5",
  "mOSFilePath" : "psmodules/Sample/psdataentities/IBIZSAMPLE0011/psdedataqueries/DEFAULT/psdedqcodes/MYSQL5",
  "name" : "MySQL5",
  "getPSDEDataQueryCodeExps" : [ {
    "expression" : "t1.`QUANTITY`*t11.`UNITPRICE`",
    "name" : "AMOUNT"
  }, {
    "expression" : "t1.`CREATEDATE`",
    "name" : "CREATEDATE"
  }, {
    "expression" : "t1.`CREATEMAN`",
    "name" : "CREATEMAN"
  }, {
    "expression" : "t1.`IBIZSAMPLE0010ID`",
    "name" : "IBIZSAMPLE0010ID"
  }, {
    "expression" : "t21.`IBIZSAMPLE0010NAME`",
    "name" : "IBIZSAMPLE0010NAME"
  }, {
    "expression" : "t1.`IBIZSAMPLE0011ID`",
    "name" : "IBIZSAMPLE0011ID"
  }, {
    "expression" : "t1.`IBIZSAMPLE0011NAME`",
    "name" : "IBIZSAMPLE0011NAME"
  }, {
    "expression" : "t1.`IBIZUNIPRODUCTID`",
    "name" : "IBIZUNIPRODUCTID"
  }, {
    "expression" : "t11.`IBIZUNIPRODUCTNAME`",
    "name" : "IBIZUNIPRODUCTNAME"
  }, {
    "expression" : "t1.`QUANTITY`",
    "name" : "QUANTITY"
  }, {
    "expression" : "t11.`UNIT`",
    "name" : "UNIT"
  }, {
    "expression" : "t11.`UNITPRICE`",
    "name" : "UNITPRICE"
  }, {
    "expression" : "t1.`UPDATEDATE`",
    "name" : "UPDATEDATE"
  }, {
    "expression" : "t1.`UPDATEMAN`",
    "name" : "UPDATEMAN"
  } ],
  "queryCode" : "SELECT\nt1.`QUANTITY`*t11.`UNITPRICE` AS `AMOUNT`,\nt1.`CREATEDATE`,\nt1.`CREATEMAN`,\nt1.`IBIZSAMPLE0010ID`,\nt21.`IBIZSAMPLE0010NAME`,\nt1.`IBIZSAMPLE0011ID`,\nt1.`IBIZSAMPLE0011NAME`,\nt1.`IBIZUNIPRODUCTID`,\nt11.`IBIZUNIPRODUCTNAME`,\nt1.`QUANTITY`,\nt11.`UNIT`,\nt11.`UNITPRICE`,\nt1.`UPDATEDATE`,\nt1.`UPDATEMAN`\nFROM `T_IBIZSAMPLE0011` t1 \nLEFT JOIN `T_IBIZUNIPRODUCT` t11 ON t1.`IBIZUNIPRODUCTID` = t11.`IBIZUNIPRODUCTID` \nLEFT JOIN `T_IBIZSAMPLE0010` t21 ON t1.`IBIZSAMPLE0010ID` = t21.`IBIZSAMPLE0010ID` \n",
  "rTMOSFilePath" : "psmodules/Sample/psdataentities/IBIZSAMPLE0011/psdedataqueries/DEFAULT/psdedqcodes/MYSQL5",
  "id" : "PSMODULES/Sample/PSDATAENTITIES/IBIZSample0011/PSDEDATAQUERIES/Default/PSDEDQCODES/MYSQL5.json"
}