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