VIEW: AR.AR_LC_CUST_SITES_T#

Source

View Text - Preformatted

select LC_CUST_SITES_ID LC_CUST_SITES_ID, CUSTOMER_ID CUSTOMER_ID, CUSTOMER_SITE_USE_ID CUSTOMER_SITE_USE_ID, CURRENCY_CODE CURRENCY_CODE, CUSTOMER_PROFILE_ID CUSTOMER_PROFILE_ID, COLLECTOR_ID COLLECTOR_ID, 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_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, 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, CONS_INV_FLAG CONS_INV_FLAG, CONS_BILL_LEVEL CONS_BILL_LEVEL, LAST_CONS_BILL_ID LAST_CONS_BILL_ID, LAST_CONS_BILL_AMOUNT LAST_CONS_BILL_AMOUNT, LAST_CONS_BILL_DATE LAST_CONS_BILL_DATE, LAST_CONS_BILL_DUE_DATE LAST_CONS_BILL_DUE_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, ORG_ID ORG_ID, REQUEST_ID REQUEST_ID from "AR"."AR_LC_CUST_SITES_T"

View Text - HTML Formatted

SELECT LC_CUST_SITES_ID LC_CUST_SITES_ID
, CUSTOMER_ID CUSTOMER_ID
, CUSTOMER_SITE_USE_ID CUSTOMER_SITE_USE_ID
, CURRENCY_CODE CURRENCY_CODE
, CUSTOMER_PROFILE_ID CUSTOMER_PROFILE_ID
, COLLECTOR_ID COLLECTOR_ID
, 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_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
, 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
, CONS_INV_FLAG CONS_INV_FLAG
, CONS_BILL_LEVEL CONS_BILL_LEVEL
, LAST_CONS_BILL_ID LAST_CONS_BILL_ID
, LAST_CONS_BILL_AMOUNT LAST_CONS_BILL_AMOUNT
, LAST_CONS_BILL_DATE LAST_CONS_BILL_DATE
, LAST_CONS_BILL_DUE_DATE LAST_CONS_BILL_DUE_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
, ORG_ID ORG_ID
, REQUEST_ID REQUEST_ID
FROM "AR"."AR_LC_CUST_SITES_T"