VIEW: IEX.IEX_BANKRUPTCIES#

Source

View Text - Preformatted

select BANKRUPTCY_ID BANKRUPTCY_ID, CAS_ID CAS_ID, DELINQUENCY_ID DELINQUENCY_ID, PARTY_ID PARTY_ID, ACTIVE_FLAG ACTIVE_FLAG, TRUSTEE_CONTACT_ID TRUSTEE_CONTACT_ID, COURT_ID COURT_ID, FIRM_CONTACT_ID FIRM_CONTACT_ID, COUNSEL_CONTACT_ID COUNSEL_CONTACT_ID, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, CHAPTER_CODE CHAPTER_CODE, ASSET_AMOUNT ASSET_AMOUNT, ASSET_CURRENCY_CODE ASSET_CURRENCY_CODE, PAYOFF_AMOUNT PAYOFF_AMOUNT, PAYOFF_CURRENCY_CODE PAYOFF_CURRENCY_CODE, BANKRUPTCY_FILE_DATE BANKRUPTCY_FILE_DATE, COURT_ORDER_DATE COURT_ORDER_DATE, FUNDING_DATE FUNDING_DATE, OBJECT_BAR_DATE OBJECT_BAR_DATE, REPOSSESSION_DATE REPOSSESSION_DATE, DISMISSAL_DATE DISMISSAL_DATE, DATE_341A DATE_341A, DISCHARGE_DATE DISCHARGE_DATE, WITHDRAW_DATE WITHDRAW_DATE, CLOSE_DATE CLOSE_DATE, PROCEDURE_CODE PROCEDURE_CODE, MOTION_CODE MOTION_CODE, CHECKLIST_CODE CHECKLIST_CODE, CEASE_COLLECTIONS_YN CEASE_COLLECTIONS_YN, TURN_OFF_INVOICING_YN TURN_OFF_INVOICING_YN, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, SECURITY_GROUP_ID SECURITY_GROUP_ID, CREDIT_HOLD_REQUEST_FLAG CREDIT_HOLD_REQUEST_FLAG, CREDIT_HOLD_APPROVED_FLAG CREDIT_HOLD_APPROVED_FLAG, SERVICE_HOLD_REQUEST_FLAG SERVICE_HOLD_REQUEST_FLAG, SERVICE_HOLD_APPROVED_FLAG SERVICE_HOLD_APPROVED_FLAG, DISPOSITION_CODE DISPOSITION_CODE, TURN_OFF_INVOICE_YN TURN_OFF_INVOICE_YN, NOTICE_ASSIGNMENT_YN NOTICE_ASSIGNMENT_YN, FILE_PROOF_CLAIM_YN FILE_PROOF_CLAIM_YN, REQUEST_REPURCHASE_YN REQUEST_REPURCHASE_YN, FEE_PAID_DATE FEE_PAID_DATE, REAFFIRMATION_DATE REAFFIRMATION_DATE, RELIEF_STAY_DATE RELIEF_STAY_DATE, FILE_CONTACT_ID FILE_CONTACT_ID, CASE_NUMBER CASE_NUMBER, COURT_CLERK_CONTACT_ID COURT_CLERK_CONTACT_ID, CUST_ACCOUNT_ID CUST_ACCOUNT_ID, CUSTOMER_SITE_USE_ID CUSTOMER_SITE_USE_ID, ORG_ID ORG_ID, APPROVAL_DATE APPROVAL_DATE from "IEX"."IEX_BANKRUPTCIES"

View Text - HTML Formatted

SELECT BANKRUPTCY_ID BANKRUPTCY_ID
, CAS_ID CAS_ID
, DELINQUENCY_ID DELINQUENCY_ID
, PARTY_ID PARTY_ID
, ACTIVE_FLAG ACTIVE_FLAG
, TRUSTEE_CONTACT_ID TRUSTEE_CONTACT_ID
, COURT_ID COURT_ID
, FIRM_CONTACT_ID FIRM_CONTACT_ID
, COUNSEL_CONTACT_ID COUNSEL_CONTACT_ID
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CHAPTER_CODE CHAPTER_CODE
, ASSET_AMOUNT ASSET_AMOUNT
, ASSET_CURRENCY_CODE ASSET_CURRENCY_CODE
, PAYOFF_AMOUNT PAYOFF_AMOUNT
, PAYOFF_CURRENCY_CODE PAYOFF_CURRENCY_CODE
, BANKRUPTCY_FILE_DATE BANKRUPTCY_FILE_DATE
, COURT_ORDER_DATE COURT_ORDER_DATE
, FUNDING_DATE FUNDING_DATE
, OBJECT_BAR_DATE OBJECT_BAR_DATE
, REPOSSESSION_DATE REPOSSESSION_DATE
, DISMISSAL_DATE DISMISSAL_DATE
, DATE_341A DATE_341A
, DISCHARGE_DATE DISCHARGE_DATE
, WITHDRAW_DATE WITHDRAW_DATE
, CLOSE_DATE CLOSE_DATE
, PROCEDURE_CODE PROCEDURE_CODE
, MOTION_CODE MOTION_CODE
, CHECKLIST_CODE CHECKLIST_CODE
, CEASE_COLLECTIONS_YN CEASE_COLLECTIONS_YN
, TURN_OFF_INVOICING_YN TURN_OFF_INVOICING_YN
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, CREDIT_HOLD_REQUEST_FLAG CREDIT_HOLD_REQUEST_FLAG
, CREDIT_HOLD_APPROVED_FLAG CREDIT_HOLD_APPROVED_FLAG
, SERVICE_HOLD_REQUEST_FLAG SERVICE_HOLD_REQUEST_FLAG
, SERVICE_HOLD_APPROVED_FLAG SERVICE_HOLD_APPROVED_FLAG
, DISPOSITION_CODE DISPOSITION_CODE
, TURN_OFF_INVOICE_YN TURN_OFF_INVOICE_YN
, NOTICE_ASSIGNMENT_YN NOTICE_ASSIGNMENT_YN
, FILE_PROOF_CLAIM_YN FILE_PROOF_CLAIM_YN
, REQUEST_REPURCHASE_YN REQUEST_REPURCHASE_YN
, FEE_PAID_DATE FEE_PAID_DATE
, REAFFIRMATION_DATE REAFFIRMATION_DATE
, RELIEF_STAY_DATE RELIEF_STAY_DATE
, FILE_CONTACT_ID FILE_CONTACT_ID
, CASE_NUMBER CASE_NUMBER
, COURT_CLERK_CONTACT_ID COURT_CLERK_CONTACT_ID
, CUST_ACCOUNT_ID CUST_ACCOUNT_ID
, CUSTOMER_SITE_USE_ID CUSTOMER_SITE_USE_ID
, ORG_ID ORG_ID
, APPROVAL_DATE APPROVAL_DATE
FROM "IEX"."IEX_BANKRUPTCIES"