{
  "dBType" : "SQLSERVER",
  "mOSFilePath" : "psmodules/Sample/psdataentities/IBIZSAMPLE0009/psdedataqueries/DEFAULT/psdedqcodes/SQLSERVER",
  "name" : "SqlServer",
  "getPSDEDataQueryCodeExps" : [ {
    "expression" : "t1.[CREATEDATE]",
    "name" : "CREATEDATE"
  }, {
    "expression" : "t1.[CREATEMAN]",
    "name" : "CREATEMAN"
  }, {
    "expression" : "t1.[DATE]",
    "name" : "DATE"
  }, {
    "expression" : "t1.[IBIZSAMPLE0009ID]",
    "name" : "IBIZSAMPLE0009ID"
  }, {
    "expression" : "t1.[IBIZSAMPLE0009NAME]",
    "name" : "IBIZSAMPLE0009NAME"
  }, {
    "expression" : "t1.[KP]",
    "name" : "KP"
  }, {
    "expression" : "t1.[PD]",
    "name" : "PD"
  }, {
    "expression" : "t1.[PG]",
    "name" : "PG"
  }, {
    "expression" : "t1.[SP]",
    "name" : "SP"
  }, {
    "expression" : "t1.[SPMC]",
    "name" : "SPMC"
  }, {
    "expression" : "convert(varchar(50),t1.[KP])+';'+convert(varchar(50),t1.[PG])+';'+convert(varchar(50),t1.[PD])+';'+convert(varchar(50),t1.[SP])+';'",
    "name" : "TJ"
  }, {
    "expression" : "t1.[UPDATEDATE]",
    "name" : "UPDATEDATE"
  }, {
    "expression" : "t1.[UPDATEMAN]",
    "name" : "UPDATEMAN"
  } ],
  "queryCode" : "SELECT\nt1.[CREATEDATE],\nt1.[CREATEMAN],\nt1.[DATE],\nt1.[IBIZSAMPLE0009ID],\nt1.[IBIZSAMPLE0009NAME],\nt1.[KP],\nt1.[PD],\nt1.[PG],\nt1.[SP],\nt1.[SPMC],\nconvert(varchar(50),t1.[KP])+';'+convert(varchar(50),t1.[PG])+';'+convert(varchar(50),t1.[PD])+';'+convert(varchar(50),t1.[SP])+';' AS [TJ],\nt1.[UPDATEDATE],\nt1.[UPDATEMAN]\nFROM [T_IBIZSAMPLE0009] t1 \n",
  "rTMOSFilePath" : "psmodules/Sample/psdataentities/IBIZSAMPLE0009/psdedataqueries/DEFAULT/psdedqcodes/SQLSERVER",
  "id" : "PSMODULES/Sample/PSDATAENTITIES/IBIZSample0009/PSDEDATAQUERIES/Default/PSDEDQCODES/SQLSERVER.json"
}