VIEW: AR.AR_LATE_CHARGE_TRX_T#

Source

View Text - Preformatted

select LATE_CHARGE_TRX_ID LATE_CHARGE_TRX_ID, CUSTOMER_ID CUSTOMER_ID, CUSTOMER_SITE_USE_ID CUSTOMER_SITE_USE_ID, CURRENCY_CODE CURRENCY_CODE, CUSTOMER_TRX_ID CUSTOMER_TRX_ID, LEGAL_ENTITY_ID LEGAL_ENTITY_ID, PAYMENT_SCHEDULE_ID PAYMENT_SCHEDULE_ID, CLASS CLASS, AMOUNT_DUE_ORIGINAL AMOUNT_DUE_ORIGINAL, AMOUNT_DUE_REMAINING AMOUNT_DUE_REMAINING, FIN_CHARGE_CHARGED FIN_CHARGE_CHARGED, TRX_DATE TRX_DATE, CUST_TRX_TYPE_ID CUST_TRX_TYPE_ID, LAST_CHARGE_DATE LAST_CHARGE_DATE, EXCHANGE_RATE EXCHANGE_RATE, EXCHANGE_RATE_TYPE EXCHANGE_RATE_TYPE, MIN_INTEREST_CHARGE MIN_INTEREST_CHARGE, MAX_INTEREST_CHARGE MAX_INTEREST_CHARGE, OVERDUE_LATE_PAY_AMOUNT OVERDUE_LATE_PAY_AMOUNT, ORIGINAL_BALANCE ORIGINAL_BALANCE, DUE_DATE DUE_DATE, RECEIPT_DATE RECEIPT_DATE, FINANCE_CHARGE_DATE FINANCE_CHARGE_DATE, CHARGE_TYPE CHARGE_TYPE, ACTUAL_DATE_CLOSED ACTUAL_DATE_CLOSED, INTEREST_RATE INTEREST_RATE, INTEREST_DAYS INTEREST_DAYS, RATE_START_DATE RATE_START_DATE, RATE_END_DATE RATE_END_DATE, SCHEDULE_DAYS_START SCHEDULE_DAYS_START, SCHEDULE_DAYS_TO SCHEDULE_DAYS_TO, LATE_CHARGE_AMOUNT LATE_CHARGE_AMOUNT, LATE_CHARGE_TYPE LATE_CHARGE_TYPE, 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, MESSAGE_TEXT_ID MESSAGE_TEXT_ID, INTEREST_TYPE INTEREST_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, CHARGE_LINE_TYPE CHARGE_LINE_TYPE, ORG_ID ORG_ID, REQUEST_ID REQUEST_ID, DISPLAY_FLAG DISPLAY_FLAG, CASH_RECEIPT_ID CASH_RECEIPT_ID from "AR"."AR_LATE_CHARGE_TRX_T"

View Text - HTML Formatted

SELECT LATE_CHARGE_TRX_ID LATE_CHARGE_TRX_ID
, CUSTOMER_ID CUSTOMER_ID
, CUSTOMER_SITE_USE_ID CUSTOMER_SITE_USE_ID
, CURRENCY_CODE CURRENCY_CODE
, CUSTOMER_TRX_ID CUSTOMER_TRX_ID
, LEGAL_ENTITY_ID LEGAL_ENTITY_ID
, PAYMENT_SCHEDULE_ID PAYMENT_SCHEDULE_ID
, CLASS CLASS
, AMOUNT_DUE_ORIGINAL AMOUNT_DUE_ORIGINAL
, AMOUNT_DUE_REMAINING AMOUNT_DUE_REMAINING
, FIN_CHARGE_CHARGED FIN_CHARGE_CHARGED
, TRX_DATE TRX_DATE
, CUST_TRX_TYPE_ID CUST_TRX_TYPE_ID
, LAST_CHARGE_DATE LAST_CHARGE_DATE
, EXCHANGE_RATE EXCHANGE_RATE
, EXCHANGE_RATE_TYPE EXCHANGE_RATE_TYPE
, MIN_INTEREST_CHARGE MIN_INTEREST_CHARGE
, MAX_INTEREST_CHARGE MAX_INTEREST_CHARGE
, OVERDUE_LATE_PAY_AMOUNT OVERDUE_LATE_PAY_AMOUNT
, ORIGINAL_BALANCE ORIGINAL_BALANCE
, DUE_DATE DUE_DATE
, RECEIPT_DATE RECEIPT_DATE
, FINANCE_CHARGE_DATE FINANCE_CHARGE_DATE
, CHARGE_TYPE CHARGE_TYPE
, ACTUAL_DATE_CLOSED ACTUAL_DATE_CLOSED
, INTEREST_RATE INTEREST_RATE
, INTEREST_DAYS INTEREST_DAYS
, RATE_START_DATE RATE_START_DATE
, RATE_END_DATE RATE_END_DATE
, SCHEDULE_DAYS_START SCHEDULE_DAYS_START
, SCHEDULE_DAYS_TO SCHEDULE_DAYS_TO
, LATE_CHARGE_AMOUNT LATE_CHARGE_AMOUNT
, LATE_CHARGE_TYPE LATE_CHARGE_TYPE
, 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
, MESSAGE_TEXT_ID MESSAGE_TEXT_ID
, INTEREST_TYPE INTEREST_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
, CHARGE_LINE_TYPE CHARGE_LINE_TYPE
, ORG_ID ORG_ID
, REQUEST_ID REQUEST_ID
, DISPLAY_FLAG DISPLAY_FLAG
, CASH_RECEIPT_ID CASH_RECEIPT_ID
FROM "AR"."AR_LATE_CHARGE_TRX_T"