[{
	"schemaMetadataInfo" : 
	{
		"adapterNotes" : "{\"catalogSeparator\":\".\",\"identifierQuoteString\":\"\\\"\",\"storesLowerCaseIdentifiers\":false,\"storesUpperCaseIdentifiers\":true,\"storesMixedCaseIdentifiers\":false,\"supportsMixedCaseIdentifiers\":false,\"storesLowerCaseQuotedIdentifiers\":false,\"storesUpperCaseQuotedIdentifiers\":false,\"storesMixedCaseQuotedIdentifiers\":true,\"supportsMixedCaseQuotedIdentifiers\":true,\"areNullsSortedAtEnd\":false,\"areNullsSortedAtStart\":false,\"areNullsSortedHigh\":true,\"areNullsSortedLow\":false}",
		"name" : "VS_20_HDA_WINLINE_CCVBI",
		"properties" : 
		{
			"CONNECTION_NAME" : "JDBC_PROD_PBI",
			"EXA_CONNECTION" : "JDBC_PROD_PBI",
			"IMPORT_FROM_EXA" : "true",
			"SCHEMA_NAME" : "S_20_HDA_WINLINE_CCVBI"
		}
	},
	"type" : "getCapabilities"
},
{"type":"getCapabilities","capabilities":["SELECTLIST_PROJECTION","SELECTLIST_EXPRESSIONS","FILTER_EXPRESSIONS","AGGREGATE_SINGLE_GROUP","AGGREGATE_GROUP_BY_COLUMN","AGGREGATE_GROUP_BY_EXPRESSION","AGGREGATE_GROUP_BY_TUPLE","AGGREGATE_HAVING","ORDER_BY_COLUMN","ORDER_BY_EXPRESSION","LIMIT","LIMIT_WITH_OFFSET","JOIN","JOIN_TYPE_INNER","JOIN_TYPE_LEFT_OUTER","JOIN_TYPE_RIGHT_OUTER","JOIN_TYPE_FULL_OUTER","JOIN_CONDITION_EQUI","FN_ADD","FN_SUB","FN_MULT","FN_FLOAT_DIV","FN_NEG","FN_ABS","FN_ACOS","FN_ASIN","FN_ATAN","FN_ATAN2","FN_CEIL","FN_COS","FN_COSH","FN_COT","FN_DEGREES","FN_DIV","FN_EXP","FN_FLOOR","FN_GREATEST","FN_LEAST","FN_LN","FN_LOG","FN_MOD","FN_POWER","FN_RADIANS","FN_RAND","FN_ROUND","FN_SIGN","FN_SIN","FN_SINH","FN_SQRT","FN_TAN","FN_TANH","FN_TRUNC","FN_ASCII","FN_BIT_LENGTH","FN_CHR","FN_COLOGNE_PHONETIC","FN_CONCAT","FN_DUMP","FN_EDIT_DISTANCE","FN_INITCAP","FN_INSERT","FN_INSTR","FN_LENGTH","FN_LOCATE","FN_LOWER","FN_LPAD","FN_LTRIM","FN_OCTET_LENGTH","FN_REGEXP_INSTR","FN_REGEXP_REPLACE","FN_REGEXP_SUBSTR","FN_REPEAT","FN_REPLACE","FN_REVERSE","FN_RIGHT","FN_RPAD","FN_RTRIM","FN_SOUNDEX","FN_SPACE","FN_SUBSTR","FN_TRANSLATE","FN_TRIM","FN_UNICODE","FN_UNICODECHR","FN_UPPER","FN_ADD_DAYS","FN_ADD_HOURS","FN_ADD_MINUTES","FN_ADD_MONTHS","FN_ADD_SECONDS","FN_ADD_WEEKS","FN_ADD_YEARS","FN_CONVERT_TZ","FN_CURRENT_DATE","FN_CURRENT_TIMESTAMP","FN_DATE_TRUNC","FN_DAY","FN_DAYS_BETWEEN","FN_DBTIMEZONE","FN_EXTRACT","FN_FROM_POSIX_TIME","FN_HOUR","FN_HOURS_BETWEEN","FN_LOCALTIMESTAMP","FN_MINUTE","FN_MINUTES_BETWEEN","FN_MONTH","FN_MONTHS_BETWEEN","FN_NUMTODSINTERVAL","FN_NUMTOYMINTERVAL","FN_POSIX_TIME","FN_SECOND","FN_SECONDS_BETWEEN","FN_SESSIONTIMEZONE","FN_SYSDATE","FN_SYSTIMESTAMP","FN_WEEK","FN_YEAR","FN_YEARS_BETWEEN","FN_ST_X","FN_ST_Y","FN_ST_ENDPOINT","FN_ST_ISCLOSED","FN_ST_ISRING","FN_ST_LENGTH","FN_ST_NUMPOINTS","FN_ST_POINTN","FN_ST_STARTPOINT","FN_ST_AREA","FN_ST_EXTERIORRING","FN_ST_INTERIORRINGN","FN_ST_NUMINTERIORRINGS","FN_ST_GEOMETRYN","FN_ST_NUMGEOMETRIES","FN_ST_BOUNDARY","FN_ST_BUFFER","FN_ST_CENTROID","FN_ST_CONTAINS","FN_ST_CONVEXHULL","FN_ST_CROSSES","FN_ST_DIFFERENCE","FN_ST_DIMENSION","FN_ST_DISJOINT","FN_ST_DISTANCE","FN_ST_ENVELOPE","FN_ST_EQUALS","FN_ST_FORCE2D","FN_ST_GEOMETRYTYPE","FN_ST_INTERSECTION","FN_ST_INTERSECTS","FN_ST_ISEMPTY","FN_ST_ISSIMPLE","FN_ST_OVERLAPS","FN_ST_SETSRID","FN_ST_SYMDIFFERENCE","FN_ST_TOUCHES","FN_ST_TRANSFORM","FN_ST_UNION","FN_ST_WITHIN","FN_CAST","FN_IS_NUMBER","FN_IS_BOOLEAN","FN_IS_DATE","FN_IS_DSINTERVAL","FN_IS_YMINTERVAL","FN_IS_TIMESTAMP","FN_TO_CHAR","FN_TO_DATE","FN_TO_DSINTERVAL","FN_TO_YMINTERVAL","FN_TO_NUMBER","FN_TO_TIMESTAMP","FN_BIT_AND","FN_BIT_CHECK","FN_BIT_LROTATE","FN_BIT_LSHIFT","FN_BIT_NOT","FN_BIT_OR","FN_BIT_RROTATE","FN_BIT_RSHIFT","FN_BIT_SET","FN_BIT_TO_NUM","FN_BIT_XOR","FN_CASE","FN_CURRENT_SCHEMA","FN_CURRENT_SESSION","FN_CURRENT_STATEMENT","FN_CURRENT_USER","FN_HASH_MD5","FN_HASHTYPE_MD5","FN_HASH_SHA1","FN_HASHTYPE_SHA1","FN_HASH_SHA256","FN_HASHTYPE_SHA256","FN_HASH_SHA512","FN_HASHTYPE_SHA512","FN_HASH_TIGER","FN_HASHTYPE_TIGER","FN_NULLIFZERO","FN_SYS_GUID","FN_ZEROIFNULL","FN_JSON_VALUE","FN_SESSION_PARAMETER","FN_MIN_SCALE","FN_PRED_AND","FN_PRED_OR","FN_PRED_NOT","FN_PRED_EQUAL","FN_PRED_NOTEQUAL","FN_PRED_LESS","FN_PRED_LESSEQUAL","FN_PRED_LIKE","FN_PRED_LIKE_ESCAPE","FN_PRED_REGEXP_LIKE","FN_PRED_BETWEEN","FN_PRED_IN_CONSTLIST","FN_PRED_IS_NULL","FN_PRED_IS_NOT_NULL","FN_PRED_IS_JSON","FN_PRED_IS_NOT_JSON","FN_AGG_COUNT","FN_AGG_COUNT_STAR","FN_AGG_COUNT_DISTINCT","FN_AGG_COUNT_TUPLE","FN_AGG_SUM","FN_AGG_SUM_DISTINCT","FN_AGG_MIN","FN_AGG_MAX","FN_AGG_AVG","FN_AGG_AVG_DISTINCT","FN_AGG_MEDIAN","FN_AGG_FIRST_VALUE","FN_AGG_LAST_VALUE","FN_AGG_STDDEV","FN_AGG_STDDEV_DISTINCT","FN_AGG_STDDEV_POP","FN_AGG_STDDEV_POP_DISTINCT","FN_AGG_STDDEV_SAMP","FN_AGG_STDDEV_SAMP_DISTINCT","FN_AGG_VARIANCE","FN_AGG_VARIANCE_DISTINCT","FN_AGG_VAR_POP","FN_AGG_VAR_POP_DISTINCT","FN_AGG_VAR_SAMP","FN_AGG_VAR_SAMP_DISTINCT","FN_AGG_GROUP_CONCAT","FN_AGG_GROUP_CONCAT_DISTINCT","FN_AGG_GROUP_CONCAT_SEPARATOR","FN_AGG_GROUP_CONCAT_ORDER_BY","FN_AGG_GEO_INTERSECTION_AGGREGATE","FN_AGG_GEO_UNION_AGGREGATE","FN_AGG_ST_INTERSECTION","FN_AGG_ST_UNION","FN_AGG_APPROXIMATE_COUNT_DISTINCT","FN_AGG_MUL","FN_AGG_MUL_DISTINCT","FN_AGG_EVERY","FN_AGG_SOME","FN_AGG_LISTAGG","FN_AGG_LISTAGG_DISTINCT","FN_AGG_LISTAGG_SEPARATOR","FN_AGG_LISTAGG_ON_OVERFLOW_ERROR","FN_AGG_LISTAGG_ON_OVERFLOW_TRUNCATE","FN_AGG_LISTAGG_ORDER_BY","LITERAL_NULL","LITERAL_BOOL","LITERAL_DATE","LITERAL_TIMESTAMP","LITERAL_TIMESTAMP_UTC","LITERAL_DOUBLE","LITERAL_EXACTNUMERIC","LITERAL_STRING","LITERAL_INTERVAL"]},
{
	"involvedTables" : 
	[
		{
			"columns" : 
			[
				{
					"adapterNotes" : "{\"jdbcDataType\":126,\"typeName\":\"HASHTYPE\"}",
					"dataType" : 
					{
						"bytesize" : 16,
						"type" : "HASHTYPE"
					},
					"name" : "HDA_OID_HASH"
				},
				{
					"adapterNotes" : "{\"jdbcDataType\":126,\"typeName\":\"HASHTYPE\"}",
					"dataType" : 
					{
						"bytesize" : 16,
						"type" : "HASHTYPE"
					},
					"name" : "HDA_COLUMN_HASH"
				},
				{
					"adapterNotes" : "{\"jdbcDataType\":93,\"typeName\":\"TIMESTAMP\"}",
					"dataType" : 
					{
						"type" : "TIMESTAMP"
					},
					"name" : "HDA_VALID_FROM"
				},
				{
					"adapterNotes" : "{\"jdbcDataType\":93,\"typeName\":\"TIMESTAMP\"}",
					"dataType" : 
					{
						"type" : "TIMESTAMP"
					},
					"name" : "HDA_VALID_TO"
				},
				{
					"adapterNotes" : "{\"jdbcDataType\":3,\"typeName\":\"DECIMAL\"}",
					"dataType" : 
					{
						"precision" : 18,
						"scale" : 0,
						"type" : "DECIMAL"
					},
					"name" : "HDA_AUDIT_ID"
				},
				{
					"adapterNotes" : "{\"jdbcDataType\":16,\"typeName\":\"BOOLEAN\"}",
					"dataType" : 
					{
						"type" : "BOOLEAN"
					},
					"name" : "HDA_VOIDED"
				},
				{
					"adapterNotes" : "{\"jdbcDataType\":3,\"typeName\":\"DECIMAL\"}",
					"dataType" : 
					{
						"precision" : 18,
						"scale" : 0,
						"type" : "DECIMAL"
					},
					"name" : "SOURCE_SYSTEM_ID"
				},
				{
					"adapterNotes" : "{\"jdbcDataType\":93,\"typeName\":\"TIMESTAMP\"}",
					"dataType" : 
					{
						"type" : "TIMESTAMP"
					},
					"name" : "STG_TIMESTAMP"
				},
				{
					"adapterNotes" : "{\"jdbcDataType\":3,\"typeName\":\"DECIMAL\"}",
					"dataType" : 
					{
						"precision" : 18,
						"scale" : 0,
						"type" : "DECIMAL"
					},
					"name" : "STG_AUDIT_ID"
				},
				{
					"adapterNotes" : "{\"jdbcDataType\":3,\"typeName\":\"DECIMAL\"}",
					"dataType" : 
					{
						"precision" : 18,
						"scale" : 0,
						"type" : "DECIMAL"
					},
					"name" : "STG_SEQUENCE"
				},
				{
					"adapterNotes" : "{\"jdbcDataType\":3,\"typeName\":\"DECIMAL\"}",
					"dataType" : 
					{
						"precision" : 18,
						"scale" : 0,
						"type" : "DECIMAL"
					},
					"name" : "STG_OPERATION"
				},
				{
					"adapterNotes" : "{\"jdbcDataType\":12,\"typeName\":\"VARCHAR\"}",
					"dataType" : 
					{
						"size" : 40,
						"type" : "VARCHAR"
					},
					"name" : "C_GLACCOUNTNO"
				},
				{
					"adapterNotes" : "{\"jdbcDataType\":12,\"typeName\":\"VARCHAR\"}",
					"dataType" : 
					{
						"size" : 510,
						"type" : "VARCHAR"
					},
					"name" : "C_GLACCOUNTNAME"
				},
				{
					"adapterNotes" : "{\"jdbcDataType\":12,\"typeName\":\"VARCHAR\"}",
					"dataType" : 
					{
						"size" : 68,
						"type" : "VARCHAR"
					},
					"name" : "C_MSOPRIM"
				},
				{
					"adapterNotes" : "{\"jdbcDataType\":12,\"typeName\":\"VARCHAR\"}",
					"dataType" : 
					{
						"size" : 8,
						"type" : "VARCHAR"
					},
					"name" : "C_MSOCOMP"
				},
				{
					"adapterNotes" : "{\"jdbcDataType\":3,\"typeName\":\"DECIMAL\"}",
					"dataType" : 
					{
						"precision" : 10,
						"scale" : 0,
						"type" : "DECIMAL"
					},
					"name" : "C_MSOYEAR"
				}
			],
			"name" : "V_CWLGLACCOUNT_ACTUAL"
		}
	],
	"pushdownRequest" : 
	{
		"from" : 
		{
			"name" : "V_CWLGLACCOUNT_ACTUAL",
			"type" : "table"
		},
		"selectList" : 
		[
			{
				"columnNr" : 11,
				"name" : "C_GLACCOUNTNO",
				"tableName" : "V_CWLGLACCOUNT_ACTUAL",
				"type" : "column"
			},
			{
				"columnNr" : 12,
				"name" : "C_GLACCOUNTNAME",
				"tableName" : "V_CWLGLACCOUNT_ACTUAL",
				"type" : "column"
			},
			{
				"type" : "literal_null"
			},
			{
				"type" : "literal_string",
				"value" : "Winline"
			},
			{
				"type" : "literal_exactnumeric",
				"value" : "1"
			},
			{
				"type" : "literal_string",
				"value" : "1"
			},
			{
				"type" : "literal_string",
				"value" : "1"
			},
			{
				"type" : "literal_string",
				"value" : "1"
			},
			{
				"type" : "literal_exactnumeric",
				"value" : "11"
			},
			{
				"type" : "literal_string",
				"value" : "11"
			},
			{
				"type" : "literal_bool",
				"value" : true
			},
			{
				"type" : "literal_string",
				"value" : "TRUE"
			}
		],
		"type" : "select"
	},
	"schemaMetadataInfo" : 
	{
		"adapterNotes" : "{\"catalogSeparator\":\".\",\"identifierQuoteString\":\"\\\"\",\"storesLowerCaseIdentifiers\":false,\"storesUpperCaseIdentifiers\":true,\"storesMixedCaseIdentifiers\":false,\"supportsMixedCaseIdentifiers\":false,\"storesLowerCaseQuotedIdentifiers\":false,\"storesUpperCaseQuotedIdentifiers\":false,\"storesMixedCaseQuotedIdentifiers\":true,\"supportsMixedCaseQuotedIdentifiers\":true,\"areNullsSortedAtEnd\":false,\"areNullsSortedAtStart\":false,\"areNullsSortedHigh\":true,\"areNullsSortedLow\":false}",
		"name" : "VS_20_HDA_WINLINE_CCVBI",
		"properties" : 
		{
			"CONNECTION_NAME" : "JDBC_PROD_PBI",
			"EXA_CONNECTION" : "JDBC_PROD_PBI",
			"IMPORT_FROM_EXA" : "true",
			"SCHEMA_NAME" : "S_20_HDA_WINLINE_CCVBI"
		}
	},
	"type" : "pushdown"
},
{"type":"pushdown","sql":"IMPORT FROM EXA AT \"JDBC_PROD_PBI\" STATEMENT 'SELECT \"V_CWLGLACCOUNT_ACTUAL\".\"C_GLACCOUNTNO\", \"V_CWLGLACCOUNT_ACTUAL\".\"C_GLACCOUNTNAME\", NULL, ''Winline'', 1, ''1'', ''1'', ''1'', 11, ''11'', true, ''TRUE'' FROM \"S_20_HDA_WINLINE_CCVBI\".\"V_CWLGLACCOUNT_ACTUAL\"'"}]