{
  "dBType" : "MYSQL5",
  "mOSFilePath" : "psmodules/Sample/psdataentities/IBIZSAMPLE0013/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.`IBIZSAMPLE0012ID`",
    "name" : "IBIZSAMPLE0012ID"
  }, {
    "expression" : "t21.`IBIZSAMPLE0012NAME`",
    "name" : "IBIZSAMPLE0012NAME"
  }, {
    "expression" : "t1.`IBIZSAMPLE0013ID`",
    "name" : "IBIZSAMPLE0013ID"
  }, {
    "expression" : "t1.`IBIZSAMPLE0013NAME`",
    "name" : "IBIZSAMPLE0013NAME"
  }, {
    "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.`IBIZSAMPLE0012ID`,\nt21.`IBIZSAMPLE0012NAME`,\nt1.`IBIZSAMPLE0013ID`,\nt1.`IBIZSAMPLE0013NAME`,\nt1.`IBIZUNIPRODUCTID`,\nt11.`IBIZUNIPRODUCTNAME`,\nt1.`QUANTITY`,\nt11.`UNIT`,\nt11.`UNITPRICE`,\nt1.`UPDATEDATE`,\nt1.`UPDATEMAN`\nFROM `T_IBIZSAMPLE0013` t1 \nLEFT JOIN `T_IBIZUNIPRODUCT` t11 ON t1.`IBIZUNIPRODUCTID` = t11.`IBIZUNIPRODUCTID` \nLEFT JOIN `T_IBIZSAMPLE0012` t21 ON t1.`IBIZSAMPLE0012ID` = t21.`IBIZSAMPLE0012ID` \n",
  "rTMOSFilePath" : "psmodules/Sample/psdataentities/IBIZSAMPLE0013/psdedataqueries/DEFAULT/psdedqcodes/MYSQL5",
  "id" : "PSMODULES/Sample/PSDATAENTITIES/IBIZSample0013/PSDEDATAQUERIES/Default/PSDEDQCODES/MYSQL5.json"
}