{
  "dBType" : "POSTGRESQL",
  "name" : "PostgreSQL",
  "getPSDEDataQueryCodeExps" : [ {
    "expression" : "t1.QUANTITY*t11.UNITPRICE",
    "name" : "AMOUNT"
  }, {
    "expression" : "t1.CREATEDATE",
    "name" : "CREATEDATE"
  }, {
    "expression" : "t1.CREATEMAN",
    "name" : "CREATEMAN"
  }, {
    "expression" : "t1.IBIZORDERDETAILA",
    "name" : "IBIZORDERDETAILA"
  }, {
    "expression" : "t1.IBIZORDERDETAILID",
    "name" : "IBIZORDERDETAILID"
  }, {
    "expression" : "t1.IBIZORDERDETAILNAME",
    "name" : "IBIZORDERDETAILNAME"
  }, {
    "expression" : "t1.IBIZORDERID",
    "name" : "IBIZORDERID"
  }, {
    "expression" : "t21.IBIZORDERNAME",
    "name" : "IBIZORDERNAME"
  }, {
    "expression" : "t1.IBIZUNIPRODUCTID",
    "name" : "IBIZUNIPRODUCTID"
  }, {
    "expression" : "t11.IBIZUNIPRODUCTNAME",
    "name" : "IBIZUNIPRODUCTNAME"
  }, {
    "expression" : "t21.ORDERUID",
    "name" : "ORDERUID"
  }, {
    "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.IBIZORDERDETAILA,\nt1.IBIZORDERDETAILID,\nt1.IBIZORDERDETAILNAME,\nt1.IBIZORDERID,\nt21.IBIZORDERNAME,\nt1.IBIZUNIPRODUCTID,\nt11.IBIZUNIPRODUCTNAME,\nt21.ORDERUID,\nt1.QUANTITY,\nt11.UNIT,\nt11.UNITPRICE,\nt1.UPDATEDATE,\nt1.UPDATEMAN\nFROM T_IBIZORDERDETAIL t1 \nLEFT JOIN T_IBIZUNIPRODUCT t11 ON t1.IBIZUNIPRODUCTID = t11.IBIZUNIPRODUCTID \nLEFT JOIN T_IBIZORDER t21 ON t1.IBIZORDERID = t21.IBIZORDERID \n",
  "id" : "PSMODULES/Sample/PSDATAENTITIES/IBIZOrderDetail/PSDEDATAQUERIES/X/PSDEDQCODES/POSTGRESQL.json"
}