VIEW: AR.RA_CUSTOMER_PROFILES_INT_ALL#

Source

View Text - Preformatted

select INTERFACE_STATUS INTERFACE_STATUS, REQUEST_ID REQUEST_ID, INSERT_UPDATE_FLAG INSERT_UPDATE_FLAG, VALIDATED_FLAG VALIDATED_FLAG, ORIG_SYSTEM_CUSTOMER_REF ORIG_SYSTEM_CUSTOMER_REF, ORIG_SYSTEM_ADDRESS_REF ORIG_SYSTEM_ADDRESS_REF, CUSTOMER_PROFILE_CLASS_NAME CUSTOMER_PROFILE_CLASS_NAME, COLLECTOR_NAME COLLECTOR_NAME, CREDIT_BALANCE_STATEMENTS CREDIT_BALANCE_STATEMENTS, CREDIT_CHECKING CREDIT_CHECKING, CREDIT_HOLD CREDIT_HOLD, DISCOUNT_TERMS DISCOUNT_TERMS, DUNNING_LETTERS DUNNING_LETTERS, INTEREST_CHARGES INTEREST_CHARGES, STATEMENTS STATEMENTS, TOLERANCE TOLERANCE, TAX_PRINTING_OPTION TAX_PRINTING_OPTION, ACCOUNT_STATUS ACCOUNT_STATUS, AUTOCASH_HIERARCHY_NAME AUTOCASH_HIERARCHY_NAME, CREDIT_RATING CREDIT_RATING, DISCOUNT_GRACE_DAYS DISCOUNT_GRACE_DAYS, DUNNING_LETTER_SET_NAME DUNNING_LETTER_SET_NAME, INTEREST_PERIOD_DAYS INTEREST_PERIOD_DAYS, OVERRIDE_TERMS OVERRIDE_TERMS, PAYMENT_GRACE_DAYS PAYMENT_GRACE_DAYS, PERCENT_COLLECTABLE PERCENT_COLLECTABLE, RISK_CODE RISK_CODE, STANDARD_TERM_NAME STANDARD_TERM_NAME, STATEMENT_CYCLE_NAME STATEMENT_CYCLE_NAME, CHARGE_ON_FINANCE_CHARGE_FLAG CHARGE_ON_FINANCE_CHARGE_FLAG, GROUPING_RULE_NAME GROUPING_RULE_NAME, CURRENCY_CODE CURRENCY_CODE, AUTO_REC_MIN_RECEIPT_AMOUNT AUTO_REC_MIN_RECEIPT_AMOUNT, INTEREST_RATE INTEREST_RATE, MAX_INTEREST_CHARGE MAX_INTEREST_CHARGE, MIN_DUNNING_AMOUNT MIN_DUNNING_AMOUNT, MIN_DUNNING_INVOICE_AMOUNT MIN_DUNNING_INVOICE_AMOUNT, MIN_FC_BALANCE_AMOUNT MIN_FC_BALANCE_AMOUNT, MIN_FC_INVOICE_AMOUNT MIN_FC_INVOICE_AMOUNT, MIN_STATEMENT_AMOUNT MIN_STATEMENT_AMOUNT, OVERALL_CREDIT_LIMIT OVERALL_CREDIT_LIMIT, TRX_CREDIT_LIMIT TRX_CREDIT_LIMIT, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, AMOUNT_ATTRIBUTE_CATEGORY AMOUNT_ATTRIBUTE_CATEGORY, AMOUNT_ATTRIBUTE1 AMOUNT_ATTRIBUTE1, AMOUNT_ATTRIBUTE10 AMOUNT_ATTRIBUTE10, AMOUNT_ATTRIBUTE11 AMOUNT_ATTRIBUTE11, AMOUNT_ATTRIBUTE12 AMOUNT_ATTRIBUTE12, AMOUNT_ATTRIBUTE13 AMOUNT_ATTRIBUTE13, AMOUNT_ATTRIBUTE14 AMOUNT_ATTRIBUTE14, AMOUNT_ATTRIBUTE15 AMOUNT_ATTRIBUTE15, AMOUNT_ATTRIBUTE2 AMOUNT_ATTRIBUTE2, AMOUNT_ATTRIBUTE3 AMOUNT_ATTRIBUTE3, AMOUNT_ATTRIBUTE4 AMOUNT_ATTRIBUTE4, AMOUNT_ATTRIBUTE5 AMOUNT_ATTRIBUTE5, AMOUNT_ATTRIBUTE6 AMOUNT_ATTRIBUTE6, AMOUNT_ATTRIBUTE7 AMOUNT_ATTRIBUTE7, AMOUNT_ATTRIBUTE8 AMOUNT_ATTRIBUTE8, AMOUNT_ATTRIBUTE9 AMOUNT_ATTRIBUTE9, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, LAST_UPDATE_DATE LAST_UPDATE_DATE, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, AUTO_REC_INCL_DISPUTED_FLAG AUTO_REC_INCL_DISPUTED_FLAG, CLEARING_DAYS CLEARING_DAYS, GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY, GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1, GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE2, GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE3, GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE4, GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE5, GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE6, GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE7, GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE8, GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE9, GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE10, GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE11, GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE12, GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE13, GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE14, GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE15, GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE16, GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE17, GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE18, GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE19, GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE20, ORG_ID ORG_ID, CONS_INV_FLAG CONS_INV_FLAG, CONS_INV_TYPE CONS_INV_TYPE, GDF_CUST_PROF_ATTR_CAT GDF_CUST_PROF_ATTR_CAT, GDF_CUST_PROF_ATTRIBUTE1 GDF_CUST_PROF_ATTRIBUTE1, GDF_CUST_PROF_ATTRIBUTE2 GDF_CUST_PROF_ATTRIBUTE2, GDF_CUST_PROF_ATTRIBUTE3 GDF_CUST_PROF_ATTRIBUTE3, GDF_CUST_PROF_ATTRIBUTE4 GDF_CUST_PROF_ATTRIBUTE4, GDF_CUST_PROF_ATTRIBUTE5 GDF_CUST_PROF_ATTRIBUTE5, GDF_CUST_PROF_ATTRIBUTE6 GDF_CUST_PROF_ATTRIBUTE6, GDF_CUST_PROF_ATTRIBUTE7 GDF_CUST_PROF_ATTRIBUTE7, GDF_CUST_PROF_ATTRIBUTE8 GDF_CUST_PROF_ATTRIBUTE8, GDF_CUST_PROF_ATTRIBUTE9 GDF_CUST_PROF_ATTRIBUTE9, GDF_CUST_PROF_ATTRIBUTE10 GDF_CUST_PROF_ATTRIBUTE10, GDF_CUST_PROF_ATTRIBUTE11 GDF_CUST_PROF_ATTRIBUTE11, GDF_CUST_PROF_ATTRIBUTE12 GDF_CUST_PROF_ATTRIBUTE12, GDF_CUST_PROF_ATTRIBUTE13 GDF_CUST_PROF_ATTRIBUTE13, GDF_CUST_PROF_ATTRIBUTE14 GDF_CUST_PROF_ATTRIBUTE14, GDF_CUST_PROF_ATTRIBUTE15 GDF_CUST_PROF_ATTRIBUTE15, GDF_CUST_PROF_ATTRIBUTE16 GDF_CUST_PROF_ATTRIBUTE16, GDF_CUST_PROF_ATTRIBUTE17 GDF_CUST_PROF_ATTRIBUTE17, GDF_CUST_PROF_ATTRIBUTE18 GDF_CUST_PROF_ATTRIBUTE18, GDF_CUST_PROF_ATTRIBUTE19 GDF_CUST_PROF_ATTRIBUTE19, GDF_CUST_PROF_ATTRIBUTE20 GDF_CUST_PROF_ATTRIBUTE20, LOCKBOX_MATCHING_OPTION LOCKBOX_MATCHING_OPTION, AUTOCASH_HIERARCHY_NAME_ADR AUTOCASH_HIERARCHY_NAME_ADR, CREDIT_CLASSIFICATION CREDIT_CLASSIFICATION, CONS_BILL_LEVEL CONS_BILL_LEVEL, LATE_CHARGE_CALCULATION_TRX LATE_CHARGE_CALCULATION_TRX, CREDIT_ITEMS_FLAG CREDIT_ITEMS_FLAG, DISPUTED_TRANSACTIONS_FLAG DISPUTED_TRANSACTIONS_FLAG, LATE_CHARGE_TYPE LATE_CHARGE_TYPE, LATE_CHARGE_TERM_ID LATE_CHARGE_TERM_ID, INTEREST_CALCULATION_PERIOD INTEREST_CALCULATION_PERIOD, HOLD_CHARGED_INVOICES_FLAG HOLD_CHARGED_INVOICES_FLAG, MESSAGE_TEXT_ID MESSAGE_TEXT_ID, MULTIPLE_INTEREST_RATES_FLAG MULTIPLE_INTEREST_RATES_FLAG, CHARGE_BEGIN_DATE CHARGE_BEGIN_DATE, EXCHANGE_RATE_TYPE EXCHANGE_RATE_TYPE, MIN_FC_INVOICE_OVERDUE_TYPE MIN_FC_INVOICE_OVERDUE_TYPE, MIN_FC_INVOICE_PERCENT MIN_FC_INVOICE_PERCENT, MIN_FC_BALANCE_OVERDUE_TYPE MIN_FC_BALANCE_OVERDUE_TYPE, MIN_FC_BALANCE_PERCENT MIN_FC_BALANCE_PERCENT, INTEREST_TYPE INTEREST_TYPE, INTEREST_FIXED_AMOUNT INTEREST_FIXED_AMOUNT, INTEREST_SCHEDULE_ID INTEREST_SCHEDULE_ID, PENALTY_TYPE PENALTY_TYPE, PENALTY_RATE PENALTY_RATE, MIN_INTEREST_CHARGE MIN_INTEREST_CHARGE, PENALTY_FIXED_AMOUNT PENALTY_FIXED_AMOUNT, PENALTY_SCHEDULE_ID PENALTY_SCHEDULE_ID, AUTOMATCH_SET_NAME AUTOMATCH_SET_NAME from "AR"."RA_CUSTOMER_PROFILES_INT_ALL"

View Text - HTML Formatted

SELECT INTERFACE_STATUS INTERFACE_STATUS
, REQUEST_ID REQUEST_ID
, INSERT_UPDATE_FLAG INSERT_UPDATE_FLAG
, VALIDATED_FLAG VALIDATED_FLAG
, ORIG_SYSTEM_CUSTOMER_REF ORIG_SYSTEM_CUSTOMER_REF
, ORIG_SYSTEM_ADDRESS_REF ORIG_SYSTEM_ADDRESS_REF
, CUSTOMER_PROFILE_CLASS_NAME CUSTOMER_PROFILE_CLASS_NAME
, COLLECTOR_NAME COLLECTOR_NAME
, CREDIT_BALANCE_STATEMENTS CREDIT_BALANCE_STATEMENTS
, CREDIT_CHECKING CREDIT_CHECKING
, CREDIT_HOLD CREDIT_HOLD
, DISCOUNT_TERMS DISCOUNT_TERMS
, DUNNING_LETTERS DUNNING_LETTERS
, INTEREST_CHARGES INTEREST_CHARGES
, STATEMENTS STATEMENTS
, TOLERANCE TOLERANCE
, TAX_PRINTING_OPTION TAX_PRINTING_OPTION
, ACCOUNT_STATUS ACCOUNT_STATUS
, AUTOCASH_HIERARCHY_NAME AUTOCASH_HIERARCHY_NAME
, CREDIT_RATING CREDIT_RATING
, DISCOUNT_GRACE_DAYS DISCOUNT_GRACE_DAYS
, DUNNING_LETTER_SET_NAME DUNNING_LETTER_SET_NAME
, INTEREST_PERIOD_DAYS INTEREST_PERIOD_DAYS
, OVERRIDE_TERMS OVERRIDE_TERMS
, PAYMENT_GRACE_DAYS PAYMENT_GRACE_DAYS
, PERCENT_COLLECTABLE PERCENT_COLLECTABLE
, RISK_CODE RISK_CODE
, STANDARD_TERM_NAME STANDARD_TERM_NAME
, STATEMENT_CYCLE_NAME STATEMENT_CYCLE_NAME
, CHARGE_ON_FINANCE_CHARGE_FLAG CHARGE_ON_FINANCE_CHARGE_FLAG
, GROUPING_RULE_NAME GROUPING_RULE_NAME
, CURRENCY_CODE CURRENCY_CODE
, AUTO_REC_MIN_RECEIPT_AMOUNT AUTO_REC_MIN_RECEIPT_AMOUNT
, INTEREST_RATE INTEREST_RATE
, MAX_INTEREST_CHARGE MAX_INTEREST_CHARGE
, MIN_DUNNING_AMOUNT MIN_DUNNING_AMOUNT
, MIN_DUNNING_INVOICE_AMOUNT MIN_DUNNING_INVOICE_AMOUNT
, MIN_FC_BALANCE_AMOUNT MIN_FC_BALANCE_AMOUNT
, MIN_FC_INVOICE_AMOUNT MIN_FC_INVOICE_AMOUNT
, MIN_STATEMENT_AMOUNT MIN_STATEMENT_AMOUNT
, OVERALL_CREDIT_LIMIT OVERALL_CREDIT_LIMIT
, TRX_CREDIT_LIMIT TRX_CREDIT_LIMIT
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, AMOUNT_ATTRIBUTE_CATEGORY AMOUNT_ATTRIBUTE_CATEGORY
, AMOUNT_ATTRIBUTE1 AMOUNT_ATTRIBUTE1
, AMOUNT_ATTRIBUTE10 AMOUNT_ATTRIBUTE10
, AMOUNT_ATTRIBUTE11 AMOUNT_ATTRIBUTE11
, AMOUNT_ATTRIBUTE12 AMOUNT_ATTRIBUTE12
, AMOUNT_ATTRIBUTE13 AMOUNT_ATTRIBUTE13
, AMOUNT_ATTRIBUTE14 AMOUNT_ATTRIBUTE14
, AMOUNT_ATTRIBUTE15 AMOUNT_ATTRIBUTE15
, AMOUNT_ATTRIBUTE2 AMOUNT_ATTRIBUTE2
, AMOUNT_ATTRIBUTE3 AMOUNT_ATTRIBUTE3
, AMOUNT_ATTRIBUTE4 AMOUNT_ATTRIBUTE4
, AMOUNT_ATTRIBUTE5 AMOUNT_ATTRIBUTE5
, AMOUNT_ATTRIBUTE6 AMOUNT_ATTRIBUTE6
, AMOUNT_ATTRIBUTE7 AMOUNT_ATTRIBUTE7
, AMOUNT_ATTRIBUTE8 AMOUNT_ATTRIBUTE8
, AMOUNT_ATTRIBUTE9 AMOUNT_ATTRIBUTE9
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, AUTO_REC_INCL_DISPUTED_FLAG AUTO_REC_INCL_DISPUTED_FLAG
, CLEARING_DAYS CLEARING_DAYS
, GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY
, GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE10
, GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE20
, ORG_ID ORG_ID
, CONS_INV_FLAG CONS_INV_FLAG
, CONS_INV_TYPE CONS_INV_TYPE
, GDF_CUST_PROF_ATTR_CAT GDF_CUST_PROF_ATTR_CAT
, GDF_CUST_PROF_ATTRIBUTE1 GDF_CUST_PROF_ATTRIBUTE1
, GDF_CUST_PROF_ATTRIBUTE2 GDF_CUST_PROF_ATTRIBUTE2
, GDF_CUST_PROF_ATTRIBUTE3 GDF_CUST_PROF_ATTRIBUTE3
, GDF_CUST_PROF_ATTRIBUTE4 GDF_CUST_PROF_ATTRIBUTE4
, GDF_CUST_PROF_ATTRIBUTE5 GDF_CUST_PROF_ATTRIBUTE5
, GDF_CUST_PROF_ATTRIBUTE6 GDF_CUST_PROF_ATTRIBUTE6
, GDF_CUST_PROF_ATTRIBUTE7 GDF_CUST_PROF_ATTRIBUTE7
, GDF_CUST_PROF_ATTRIBUTE8 GDF_CUST_PROF_ATTRIBUTE8
, GDF_CUST_PROF_ATTRIBUTE9 GDF_CUST_PROF_ATTRIBUTE9
, GDF_CUST_PROF_ATTRIBUTE10 GDF_CUST_PROF_ATTRIBUTE10
, GDF_CUST_PROF_ATTRIBUTE11 GDF_CUST_PROF_ATTRIBUTE11
, GDF_CUST_PROF_ATTRIBUTE12 GDF_CUST_PROF_ATTRIBUTE12
, GDF_CUST_PROF_ATTRIBUTE13 GDF_CUST_PROF_ATTRIBUTE13
, GDF_CUST_PROF_ATTRIBUTE14 GDF_CUST_PROF_ATTRIBUTE14
, GDF_CUST_PROF_ATTRIBUTE15 GDF_CUST_PROF_ATTRIBUTE15
, GDF_CUST_PROF_ATTRIBUTE16 GDF_CUST_PROF_ATTRIBUTE16
, GDF_CUST_PROF_ATTRIBUTE17 GDF_CUST_PROF_ATTRIBUTE17
, GDF_CUST_PROF_ATTRIBUTE18 GDF_CUST_PROF_ATTRIBUTE18
, GDF_CUST_PROF_ATTRIBUTE19 GDF_CUST_PROF_ATTRIBUTE19
, GDF_CUST_PROF_ATTRIBUTE20 GDF_CUST_PROF_ATTRIBUTE20
, LOCKBOX_MATCHING_OPTION LOCKBOX_MATCHING_OPTION
, AUTOCASH_HIERARCHY_NAME_ADR AUTOCASH_HIERARCHY_NAME_ADR
, CREDIT_CLASSIFICATION CREDIT_CLASSIFICATION
, CONS_BILL_LEVEL CONS_BILL_LEVEL
, LATE_CHARGE_CALCULATION_TRX LATE_CHARGE_CALCULATION_TRX
, CREDIT_ITEMS_FLAG CREDIT_ITEMS_FLAG
, DISPUTED_TRANSACTIONS_FLAG DISPUTED_TRANSACTIONS_FLAG
, LATE_CHARGE_TYPE LATE_CHARGE_TYPE
, LATE_CHARGE_TERM_ID LATE_CHARGE_TERM_ID
, INTEREST_CALCULATION_PERIOD INTEREST_CALCULATION_PERIOD
, HOLD_CHARGED_INVOICES_FLAG HOLD_CHARGED_INVOICES_FLAG
, MESSAGE_TEXT_ID MESSAGE_TEXT_ID
, MULTIPLE_INTEREST_RATES_FLAG MULTIPLE_INTEREST_RATES_FLAG
, CHARGE_BEGIN_DATE CHARGE_BEGIN_DATE
, EXCHANGE_RATE_TYPE EXCHANGE_RATE_TYPE
, MIN_FC_INVOICE_OVERDUE_TYPE MIN_FC_INVOICE_OVERDUE_TYPE
, MIN_FC_INVOICE_PERCENT MIN_FC_INVOICE_PERCENT
, MIN_FC_BALANCE_OVERDUE_TYPE MIN_FC_BALANCE_OVERDUE_TYPE
, MIN_FC_BALANCE_PERCENT MIN_FC_BALANCE_PERCENT
, INTEREST_TYPE INTEREST_TYPE
, INTEREST_FIXED_AMOUNT INTEREST_FIXED_AMOUNT
, INTEREST_SCHEDULE_ID INTEREST_SCHEDULE_ID
, PENALTY_TYPE PENALTY_TYPE
, PENALTY_RATE PENALTY_RATE
, MIN_INTEREST_CHARGE MIN_INTEREST_CHARGE
, PENALTY_FIXED_AMOUNT PENALTY_FIXED_AMOUNT
, PENALTY_SCHEDULE_ID PENALTY_SCHEDULE_ID
, AUTOMATCH_SET_NAME AUTOMATCH_SET_NAME
FROM "AR"."RA_CUSTOMER_PROFILES_INT_ALL"