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