VIEW: AR.AR_INTEREST_HEADERS_ALL#

Source

View Text - Preformatted

select INTEREST_HEADER_ID INTEREST_HEADER_ID, INTEREST_BATCH_ID INTEREST_BATCH_ID, CUSTOMER_ID CUSTOMER_ID, CUSTOMER_SITE_USE_ID CUSTOMER_SITE_USE_ID, HEADER_TYPE HEADER_TYPE, CURRENCY_CODE CURRENCY_CODE, LATE_CHARGE_CALCULATION_TRX LATE_CHARGE_CALCULATION_TRX, CREDIT_ITEMS_FLAG CREDIT_ITEMS_FLAG, DISPUTED_TRANSACTIONS_FLAG DISPUTED_TRANSACTIONS_FLAG, PAYMENT_GRACE_DAYS PAYMENT_GRACE_DAYS, LATE_CHARGE_TERM_ID LATE_CHARGE_TERM_ID, INTEREST_PERIOD_DAYS INTEREST_PERIOD_DAYS, INTEREST_CALCULATION_PERIOD INTEREST_CALCULATION_PERIOD, CHARGE_ON_FINANCE_CHARGE_FLAG CHARGE_ON_FINANCE_CHARGE_FLAG, 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, CUST_ACCT_PROFILE_AMT_ID CUST_ACCT_PROFILE_AMT_ID, EXCHANGE_RATE EXCHANGE_RATE, EXCHANGE_RATE_TYPE EXCHANGE_RATE_TYPE, MIN_FC_INVOICE_OVERDUE_TYPE MIN_FC_INVOICE_OVERDUE_TYPE, MIN_FC_INVOICE_AMOUNT MIN_FC_INVOICE_AMOUNT, MIN_FC_INVOICE_PERCENT MIN_FC_INVOICE_PERCENT, MIN_FC_BALANCE_OVERDUE_TYPE MIN_FC_BALANCE_OVERDUE_TYPE, MIN_FC_BALANCE_AMOUNT MIN_FC_BALANCE_AMOUNT, MIN_FC_BALANCE_PERCENT MIN_FC_BALANCE_PERCENT, MIN_INTEREST_CHARGE MIN_INTEREST_CHARGE, MAX_INTEREST_CHARGE MAX_INTEREST_CHARGE, INTEREST_TYPE INTEREST_TYPE, INTEREST_RATE INTEREST_RATE, INTEREST_FIXED_AMOUNT INTEREST_FIXED_AMOUNT, INTEREST_SCHEDULE_ID INTEREST_SCHEDULE_ID, PENALTY_TYPE PENALTY_TYPE, PENALTY_RATE PENALTY_RATE, PENALTY_FIXED_AMOUNT PENALTY_FIXED_AMOUNT, PENALTY_SCHEDULE_ID PENALTY_SCHEDULE_ID, LAST_ACCRUE_CHARGE_DATE LAST_ACCRUE_CHARGE_DATE, CUSTOMER_PROFILE_ID CUSTOMER_PROFILE_ID, COLLECTOR_ID COLLECTOR_ID, LEGAL_ENTITY_ID LEGAL_ENTITY_ID, PROCESS_MESSAGE PROCESS_MESSAGE, PROCESS_STATUS PROCESS_STATUS, CUST_TRX_TYPE_ID CUST_TRX_TYPE_ID, ORG_ID ORG_ID, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, WORKER_NUM WORKER_NUM, REQUEST_ID REQUEST_ID, FINANCE_CHARGE_DATE FINANCE_CHARGE_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, DISPLAY_FLAG DISPLAY_FLAG from "AR"."AR_INTEREST_HEADERS_ALL"

View Text - HTML Formatted

SELECT INTEREST_HEADER_ID INTEREST_HEADER_ID
, INTEREST_BATCH_ID INTEREST_BATCH_ID
, CUSTOMER_ID CUSTOMER_ID
, CUSTOMER_SITE_USE_ID CUSTOMER_SITE_USE_ID
, HEADER_TYPE HEADER_TYPE
, CURRENCY_CODE CURRENCY_CODE
, LATE_CHARGE_CALCULATION_TRX LATE_CHARGE_CALCULATION_TRX
, CREDIT_ITEMS_FLAG CREDIT_ITEMS_FLAG
, DISPUTED_TRANSACTIONS_FLAG DISPUTED_TRANSACTIONS_FLAG
, PAYMENT_GRACE_DAYS PAYMENT_GRACE_DAYS
, LATE_CHARGE_TERM_ID LATE_CHARGE_TERM_ID
, INTEREST_PERIOD_DAYS INTEREST_PERIOD_DAYS
, INTEREST_CALCULATION_PERIOD INTEREST_CALCULATION_PERIOD
, CHARGE_ON_FINANCE_CHARGE_FLAG CHARGE_ON_FINANCE_CHARGE_FLAG
, 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
, CUST_ACCT_PROFILE_AMT_ID CUST_ACCT_PROFILE_AMT_ID
, EXCHANGE_RATE EXCHANGE_RATE
, EXCHANGE_RATE_TYPE EXCHANGE_RATE_TYPE
, MIN_FC_INVOICE_OVERDUE_TYPE MIN_FC_INVOICE_OVERDUE_TYPE
, MIN_FC_INVOICE_AMOUNT MIN_FC_INVOICE_AMOUNT
, MIN_FC_INVOICE_PERCENT MIN_FC_INVOICE_PERCENT
, MIN_FC_BALANCE_OVERDUE_TYPE MIN_FC_BALANCE_OVERDUE_TYPE
, MIN_FC_BALANCE_AMOUNT MIN_FC_BALANCE_AMOUNT
, MIN_FC_BALANCE_PERCENT MIN_FC_BALANCE_PERCENT
, MIN_INTEREST_CHARGE MIN_INTEREST_CHARGE
, MAX_INTEREST_CHARGE MAX_INTEREST_CHARGE
, INTEREST_TYPE INTEREST_TYPE
, INTEREST_RATE INTEREST_RATE
, INTEREST_FIXED_AMOUNT INTEREST_FIXED_AMOUNT
, INTEREST_SCHEDULE_ID INTEREST_SCHEDULE_ID
, PENALTY_TYPE PENALTY_TYPE
, PENALTY_RATE PENALTY_RATE
, PENALTY_FIXED_AMOUNT PENALTY_FIXED_AMOUNT
, PENALTY_SCHEDULE_ID PENALTY_SCHEDULE_ID
, LAST_ACCRUE_CHARGE_DATE LAST_ACCRUE_CHARGE_DATE
, CUSTOMER_PROFILE_ID CUSTOMER_PROFILE_ID
, COLLECTOR_ID COLLECTOR_ID
, LEGAL_ENTITY_ID LEGAL_ENTITY_ID
, PROCESS_MESSAGE PROCESS_MESSAGE
, PROCESS_STATUS PROCESS_STATUS
, CUST_TRX_TYPE_ID CUST_TRX_TYPE_ID
, ORG_ID ORG_ID
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, WORKER_NUM WORKER_NUM
, REQUEST_ID REQUEST_ID
, FINANCE_CHARGE_DATE FINANCE_CHARGE_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, DISPLAY_FLAG DISPLAY_FLAG
FROM "AR"."AR_INTEREST_HEADERS_ALL"