VIEW: IEX.IEX_DLN_UWQ_SUMMARY#

Source

View Text - Preformatted

select DLN_UWQ_SUMMARY_ID DLN_UWQ_SUMMARY_ID, ORG_ID ORG_ID, COLLECTOR_ID COLLECTOR_ID, COLLECTOR_RESOURCE_ID COLLECTOR_RESOURCE_ID, COLLECTOR_RES_TYPE COLLECTOR_RES_TYPE, IEU_OBJECT_FUNCTION IEU_OBJECT_FUNCTION, IEU_OBJECT_PARAMETERS IEU_OBJECT_PARAMETERS, IEU_MEDIA_TYPE_UUID IEU_MEDIA_TYPE_UUID, IEU_PARAM_PK_COL IEU_PARAM_PK_COL, IEU_PARAM_PK_VALUE IEU_PARAM_PK_VALUE, RESOURCE_ID RESOURCE_ID, RESOURCE_TYPE RESOURCE_TYPE, PARTY_ID PARTY_ID, PARTY_NAME PARTY_NAME, CUST_ACCOUNT_ID CUST_ACCOUNT_ID, ACCOUNT_NAME ACCOUNT_NAME, ACCOUNT_NUMBER ACCOUNT_NUMBER, SITE_USE_ID SITE_USE_ID, LOCATION LOCATION, CURRENCY CURRENCY, OP_INVOICES_COUNT OP_INVOICES_COUNT, OP_DEBIT_MEMOS_COUNT OP_DEBIT_MEMOS_COUNT, OP_DEPOSITS_COUNT OP_DEPOSITS_COUNT, OP_BILLS_RECEIVABLES_COUNT OP_BILLS_RECEIVABLES_COUNT, OP_CHARGEBACK_COUNT OP_CHARGEBACK_COUNT, OP_CREDIT_MEMOS_COUNT OP_CREDIT_MEMOS_COUNT, UNRESOLVED_CASH_COUNT UNRESOLVED_CASH_COUNT, DISPUTED_INV_COUNT DISPUTED_INV_COUNT, BEST_CURRENT_RECEIVABLES BEST_CURRENT_RECEIVABLES, OP_INVOICES_VALUE OP_INVOICES_VALUE, OP_DEBIT_MEMOS_VALUE OP_DEBIT_MEMOS_VALUE, OP_DEPOSITS_VALUE OP_DEPOSITS_VALUE, OP_BILLS_RECEIVABLES_VALUE OP_BILLS_RECEIVABLES_VALUE, OP_CHARGEBACK_VALUE OP_CHARGEBACK_VALUE, OP_CREDIT_MEMOS_VALUE OP_CREDIT_MEMOS_VALUE, UNRESOLVED_CASH_VALUE UNRESOLVED_CASH_VALUE, RECEIPTS_AT_RISK_VALUE RECEIPTS_AT_RISK_VALUE, INV_AMT_IN_DISPUTE INV_AMT_IN_DISPUTE, PENDING_ADJ_VALUE PENDING_ADJ_VALUE, PAST_DUE_INV_VALUE PAST_DUE_INV_VALUE, PAST_DUE_INV_INST_COUNT PAST_DUE_INV_INST_COUNT, LAST_PAYMENT_DATE LAST_PAYMENT_DATE, LAST_PAYMENT_AMOUNT LAST_PAYMENT_AMOUNT, LAST_PAYMENT_AMOUNT_CURR LAST_PAYMENT_AMOUNT_CURR, LAST_PAYMENT_NUMBER LAST_PAYMENT_NUMBER, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, NUMBER_OF_DELINQUENCIES NUMBER_OF_DELINQUENCIES, ACTIVE_DELINQUENCIES ACTIVE_DELINQUENCIES, COMPLETE_DELINQUENCIES COMPLETE_DELINQUENCIES, PENDING_DELINQUENCIES PENDING_DELINQUENCIES, SCORE SCORE, ADDRESS1 ADDRESS1, CITY CITY, STATE STATE, COUNTY COUNTY, COUNTRY COUNTRY, PROVINCE PROVINCE, POSTAL_CODE POSTAL_CODE, PHONE_COUNTRY_CODE PHONE_COUNTRY_CODE, PHONE_AREA_CODE PHONE_AREA_CODE, PHONE_NUMBER PHONE_NUMBER, PHONE_EXTENSION PHONE_EXTENSION, NUMBER_OF_BANKRUPTCIES NUMBER_OF_BANKRUPTCIES, NUMBER_OF_PROMISES NUMBER_OF_PROMISES, BROKEN_PROMISE_AMOUNT BROKEN_PROMISE_AMOUNT, PROMISE_AMOUNT PROMISE_AMOUNT, ACTIVE_PROMISES ACTIVE_PROMISES, COMPLETE_PROMISES COMPLETE_PROMISES, PENDING_PROMISES PENDING_PROMISES, WORK_ITEM_ID WORK_ITEM_ID, SCHEDULE_START SCHEDULE_START, SCHEDULE_END SCHEDULE_END, WORK_TYPE WORK_TYPE, CATEGORY_TYPE CATEGORY_TYPE, PRIORITY_TYPE PRIORITY_TYPE, WKITEM_RESOURCE_ID WKITEM_RESOURCE_ID, STRATEGY_ID STRATEGY_ID, STRATEGY_TEMPLATE_ID STRATEGY_TEMPLATE_ID, WORK_ITEM_TEMPLATE_ID WORK_ITEM_TEMPLATE_ID, STATUS_CODE STATUS_CODE, START_TIME START_TIME, END_TIME END_TIME, WORK_ITEM_ORDER WORK_ITEM_ORDER, WKITEM_ESCALATED_YN WKITEM_ESCALATED_YN, STR_STATUS STR_STATUS, AGING_AMOUNT1 AGING_AMOUNT1, AGING_AMOUNT2 AGING_AMOUNT2, AGING_AMOUNT3 AGING_AMOUNT3, AGING_AMOUNT4 AGING_AMOUNT4, AGING_AMOUNT5 AGING_AMOUNT5, AGING_AMOUNT6 AGING_AMOUNT6, AGING_AMOUNT7 AGING_AMOUNT7, AGING_COUNT1 AGING_COUNT1, AGING_COUNT2 AGING_COUNT2, AGING_COUNT3 AGING_COUNT3, AGING_COUNT4 AGING_COUNT4, AGING_COUNT5 AGING_COUNT5, AGING_COUNT6 AGING_COUNT6, AGING_COUNT7 AGING_COUNT7, CASES_COUNT CASES_COUNT, DEL_CASES_COUNT DEL_CASES_COUNT, CONTRACTS_COUNT CONTRACTS_COUNT, DEL_CONTRACTS_COUNT DEL_CONTRACTS_COUNT, COLLECTOR_RESOURCE_NAME COLLECTOR_RESOURCE_NAME, SCORE_ID SCORE_ID, SCORE_NAME SCORE_NAME, BUSINESS_LEVEL BUSINESS_LEVEL, NET_BALANCE NET_BALANCE, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID from "IEX"."IEX_DLN_UWQ_SUMMARY"

View Text - HTML Formatted

SELECT DLN_UWQ_SUMMARY_ID DLN_UWQ_SUMMARY_ID
, ORG_ID ORG_ID
, COLLECTOR_ID COLLECTOR_ID
, COLLECTOR_RESOURCE_ID COLLECTOR_RESOURCE_ID
, COLLECTOR_RES_TYPE COLLECTOR_RES_TYPE
, IEU_OBJECT_FUNCTION IEU_OBJECT_FUNCTION
, IEU_OBJECT_PARAMETERS IEU_OBJECT_PARAMETERS
, IEU_MEDIA_TYPE_UUID IEU_MEDIA_TYPE_UUID
, IEU_PARAM_PK_COL IEU_PARAM_PK_COL
, IEU_PARAM_PK_VALUE IEU_PARAM_PK_VALUE
, RESOURCE_ID RESOURCE_ID
, RESOURCE_TYPE RESOURCE_TYPE
, PARTY_ID PARTY_ID
, PARTY_NAME PARTY_NAME
, CUST_ACCOUNT_ID CUST_ACCOUNT_ID
, ACCOUNT_NAME ACCOUNT_NAME
, ACCOUNT_NUMBER ACCOUNT_NUMBER
, SITE_USE_ID SITE_USE_ID
, LOCATION LOCATION
, CURRENCY CURRENCY
, OP_INVOICES_COUNT OP_INVOICES_COUNT
, OP_DEBIT_MEMOS_COUNT OP_DEBIT_MEMOS_COUNT
, OP_DEPOSITS_COUNT OP_DEPOSITS_COUNT
, OP_BILLS_RECEIVABLES_COUNT OP_BILLS_RECEIVABLES_COUNT
, OP_CHARGEBACK_COUNT OP_CHARGEBACK_COUNT
, OP_CREDIT_MEMOS_COUNT OP_CREDIT_MEMOS_COUNT
, UNRESOLVED_CASH_COUNT UNRESOLVED_CASH_COUNT
, DISPUTED_INV_COUNT DISPUTED_INV_COUNT
, BEST_CURRENT_RECEIVABLES BEST_CURRENT_RECEIVABLES
, OP_INVOICES_VALUE OP_INVOICES_VALUE
, OP_DEBIT_MEMOS_VALUE OP_DEBIT_MEMOS_VALUE
, OP_DEPOSITS_VALUE OP_DEPOSITS_VALUE
, OP_BILLS_RECEIVABLES_VALUE OP_BILLS_RECEIVABLES_VALUE
, OP_CHARGEBACK_VALUE OP_CHARGEBACK_VALUE
, OP_CREDIT_MEMOS_VALUE OP_CREDIT_MEMOS_VALUE
, UNRESOLVED_CASH_VALUE UNRESOLVED_CASH_VALUE
, RECEIPTS_AT_RISK_VALUE RECEIPTS_AT_RISK_VALUE
, INV_AMT_IN_DISPUTE INV_AMT_IN_DISPUTE
, PENDING_ADJ_VALUE PENDING_ADJ_VALUE
, PAST_DUE_INV_VALUE PAST_DUE_INV_VALUE
, PAST_DUE_INV_INST_COUNT PAST_DUE_INV_INST_COUNT
, LAST_PAYMENT_DATE LAST_PAYMENT_DATE
, LAST_PAYMENT_AMOUNT LAST_PAYMENT_AMOUNT
, LAST_PAYMENT_AMOUNT_CURR LAST_PAYMENT_AMOUNT_CURR
, LAST_PAYMENT_NUMBER LAST_PAYMENT_NUMBER
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, NUMBER_OF_DELINQUENCIES NUMBER_OF_DELINQUENCIES
, ACTIVE_DELINQUENCIES ACTIVE_DELINQUENCIES
, COMPLETE_DELINQUENCIES COMPLETE_DELINQUENCIES
, PENDING_DELINQUENCIES PENDING_DELINQUENCIES
, SCORE SCORE
, ADDRESS1 ADDRESS1
, CITY CITY
, STATE STATE
, COUNTY COUNTY
, COUNTRY COUNTRY
, PROVINCE PROVINCE
, POSTAL_CODE POSTAL_CODE
, PHONE_COUNTRY_CODE PHONE_COUNTRY_CODE
, PHONE_AREA_CODE PHONE_AREA_CODE
, PHONE_NUMBER PHONE_NUMBER
, PHONE_EXTENSION PHONE_EXTENSION
, NUMBER_OF_BANKRUPTCIES NUMBER_OF_BANKRUPTCIES
, NUMBER_OF_PROMISES NUMBER_OF_PROMISES
, BROKEN_PROMISE_AMOUNT BROKEN_PROMISE_AMOUNT
, PROMISE_AMOUNT PROMISE_AMOUNT
, ACTIVE_PROMISES ACTIVE_PROMISES
, COMPLETE_PROMISES COMPLETE_PROMISES
, PENDING_PROMISES PENDING_PROMISES
, WORK_ITEM_ID WORK_ITEM_ID
, SCHEDULE_START SCHEDULE_START
, SCHEDULE_END SCHEDULE_END
, WORK_TYPE WORK_TYPE
, CATEGORY_TYPE CATEGORY_TYPE
, PRIORITY_TYPE PRIORITY_TYPE
, WKITEM_RESOURCE_ID WKITEM_RESOURCE_ID
, STRATEGY_ID STRATEGY_ID
, STRATEGY_TEMPLATE_ID STRATEGY_TEMPLATE_ID
, WORK_ITEM_TEMPLATE_ID WORK_ITEM_TEMPLATE_ID
, STATUS_CODE STATUS_CODE
, START_TIME START_TIME
, END_TIME END_TIME
, WORK_ITEM_ORDER WORK_ITEM_ORDER
, WKITEM_ESCALATED_YN WKITEM_ESCALATED_YN
, STR_STATUS STR_STATUS
, AGING_AMOUNT1 AGING_AMOUNT1
, AGING_AMOUNT2 AGING_AMOUNT2
, AGING_AMOUNT3 AGING_AMOUNT3
, AGING_AMOUNT4 AGING_AMOUNT4
, AGING_AMOUNT5 AGING_AMOUNT5
, AGING_AMOUNT6 AGING_AMOUNT6
, AGING_AMOUNT7 AGING_AMOUNT7
, AGING_COUNT1 AGING_COUNT1
, AGING_COUNT2 AGING_COUNT2
, AGING_COUNT3 AGING_COUNT3
, AGING_COUNT4 AGING_COUNT4
, AGING_COUNT5 AGING_COUNT5
, AGING_COUNT6 AGING_COUNT6
, AGING_COUNT7 AGING_COUNT7
, CASES_COUNT CASES_COUNT
, DEL_CASES_COUNT DEL_CASES_COUNT
, CONTRACTS_COUNT CONTRACTS_COUNT
, DEL_CONTRACTS_COUNT DEL_CONTRACTS_COUNT
, COLLECTOR_RESOURCE_NAME COLLECTOR_RESOURCE_NAME
, SCORE_ID SCORE_ID
, SCORE_NAME SCORE_NAME
, BUSINESS_LEVEL BUSINESS_LEVEL
, NET_BALANCE NET_BALANCE
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
FROM "IEX"."IEX_DLN_UWQ_SUMMARY"