VIEW: IEX.IEX_DUNNING_PLANS_B#

Source

View Text - Preformatted

select DUNNING_PLAN_ID DUNNING_PLAN_ID, START_DATE START_DATE, END_DATE END_DATE, ENABLED_FLAG ENABLED_FLAG, AGING_BUCKET_ID AGING_BUCKET_ID, SCORE_ID SCORE_ID, DUNNING_LEVEL DUNNING_LEVEL, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, GRACE_DAYS GRACE_DAYS, DUN_DISPUTED_ITEMS DUN_DISPUTED_ITEMS, INCLUDE_UNUSED_PAYMENTS_FLAG INCLUDE_UNUSED_PAYMENTS_FLAG, DUNNING_TYPE DUNNING_TYPE, INCLUDE_CURRENT INCLUDE_CURRENT, DUNNING_LETTER_SET_ID DUNNING_LETTER_SET_ID, MIG_DUNNING_LETTER_SET_ID MIG_DUNNING_LETTER_SET_ID from "IEX"."IEX_DUNNING_PLANS_B"

View Text - HTML Formatted

SELECT DUNNING_PLAN_ID DUNNING_PLAN_ID
, START_DATE START_DATE
, END_DATE END_DATE
, ENABLED_FLAG ENABLED_FLAG
, AGING_BUCKET_ID AGING_BUCKET_ID
, SCORE_ID SCORE_ID
, DUNNING_LEVEL DUNNING_LEVEL
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, GRACE_DAYS GRACE_DAYS
, DUN_DISPUTED_ITEMS DUN_DISPUTED_ITEMS
, INCLUDE_UNUSED_PAYMENTS_FLAG INCLUDE_UNUSED_PAYMENTS_FLAG
, DUNNING_TYPE DUNNING_TYPE
, INCLUDE_CURRENT INCLUDE_CURRENT
, DUNNING_LETTER_SET_ID DUNNING_LETTER_SET_ID
, MIG_DUNNING_LETTER_SET_ID MIG_DUNNING_LETTER_SET_ID
FROM "IEX"."IEX_DUNNING_PLANS_B"