SELECT BUILTIN_RESULT.TYPE_STRING("ACCOUNT".externalid) AS externalidRAW /*{externalid#RAW}*/, BUILTIN_RESULT.TYPE_STRING("ACCOUNT".acctnumber) AS acctnumberRAW /*{acctnumber#RAW}*/, BUILTIN_RESULT.TYPE_STRING("ACCOUNT".accountsearchdisplaynamecopy) AS accountsearchdisplaynamecopy /*{accountsearchdisplaynamecopy#RAW}*/, BUILTIN_RESULT.TYPE_STRING("ACCOUNT".accountsearchdisplayname) AS accountsearchdisplaynameRAW /*{accountsearchdisplayname#RAW}*/, BUILTIN_RESULT.TYPE_STRING("ACCOUNT".accttype) AS accttypeRAW /*{accttype#RAW}*/, BUILTIN_RESULT.TYPE_STRING("ACCOUNT".subsidiary) AS subsidiaryRAW /*{subsidiary#RAW}*/, BUILTIN_RESULT.TYPE_INTEGER("ACCOUNT"."PARENT") AS parentRAW /*{parent#RAW}*/, BUILTIN_RESULT.TYPE_STRING("ACCOUNT".description) AS descriptionRAW /*{description#RAW}*/, BUILTIN_RESULT.TYPE_INTEGER("ACCOUNT".category1099misc) AS category1099miscRAW /*{category1099misc#RAW}*/, BUILTIN_RESULT.TYPE_STRING("ACCOUNT".cashflowrate) AS cashflowrateRAW /*{cashflowrate#RAW}*/, BUILTIN_RESULT.TYPE_STRING(currency.name) AS currencynameRAW /*{currency.name#RAW}*/, BUILTIN_RESULT.TYPE_STRING("ACCOUNT".custrecord110) AS custrecord110RAW /*{custrecord110#RAW}*/, BUILTIN_RESULT.TYPE_STRING("ACCOUNT".generalrate) AS generalrateRAW /*{generalrate#RAW}*/, BUILTIN_RESULT.TYPE_STRING("ACCOUNT".custrecord_hsbc_account) AS custrecordhsbcaccountRAW /*{custrecord_hsbc_account#RAW}*/, BUILTIN_RESULT.TYPE_BOOLEAN("ACCOUNT".includechildren) AS includechildrenRAW /*{includechildren#RAW}*/, BUILTIN_RESULT.TYPE_STRING(AccountContextSearch.locale) AS accountcontextsearchlocaleR /*{accountcontextsearch.locale#RAW}*/, BUILTIN_RESULT.TYPE_BOOLEAN("ACCOUNT".revalue) AS revalueRAW /*{revalue#RAW}*/, BUILTIN_RESULT.TYPE_STRING("ACCOUNT".custrecord_fam_account_showinfixedasset) AS custrecordfamaccountshowin /*{custrecord_fam_account_showinfixedasset#RAW}*/, BUILTIN_RESULT.TYPE_STRING("ACCOUNT".sspecacct) AS sspecacctRAW /*{sspecacct#RAW}*/, BUILTIN_RESULT.TYPE_BOOLEAN("ACCOUNT".issummary) AS issummaryRAW /*{issummary#RAW}*/, BUILTIN_RESULT.TYPE_BOOLEAN("ACCOUNT".isinactive) AS isinactiveRAW /*{isinactive#RAW}*/ FROM "ACCOUNT", AccountContextSearch, currency WHERE (("ACCOUNT"."ID" = AccountContextSearch."ACCOUNT"(+) AND "ACCOUNT".currency = currency."ID"(+))) AND UPPER("ACCOUNT".externalid) IN ('680440')