VIEW: AR.AR_STATEMENTS_HISTORY_ALL#

Source

View Text - Preformatted

select LINE_CLUSTER_ID LINE_CLUSTER_ID, SEND_TO_ADDRESS_ID SEND_TO_ADDRESS_ID, CUSTOMER_ID CUSTOMER_ID, REMIT_TO_ADDRESS_ID REMIT_TO_ADDRESS_ID, STATEMENT_DATE STATEMENT_DATE, CURRENCY_CODE CURRENCY_CODE, FINANCE_CHARGES FINANCE_CHARGES, TOTAL_AMOUNT_DUE TOTAL_AMOUNT_DUE, SITE_USE_ID SITE_USE_ID, STATEMENT_TYPE STATEMENT_TYPE, BILL_TO_LOCATION BILL_TO_LOCATION, CREDIT_BALANCE_STATEMENTS CREDIT_BALANCE_STATEMENTS, CUST_CUSTOMER_PROFILE_ID CUST_CUSTOMER_PROFILE_ID, MIN_STATEMENT_AMOUNT MIN_STATEMENT_AMOUNT, MONTHLY_INTEREST_RATE MONTHLY_INTEREST_RATE, SITE_CUSTOMER_PROFILE_ID SITE_CUSTOMER_PROFILE_ID, IS_IT_A_REPRINT IS_IT_A_REPRINT, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, ORG_ID ORG_ID, STATEMENT_CYCLE_ID STATEMENT_CYCLE_ID from "AR"."AR_STATEMENTS_HISTORY_ALL"

View Text - HTML Formatted

SELECT LINE_CLUSTER_ID LINE_CLUSTER_ID
, SEND_TO_ADDRESS_ID SEND_TO_ADDRESS_ID
, CUSTOMER_ID CUSTOMER_ID
, REMIT_TO_ADDRESS_ID REMIT_TO_ADDRESS_ID
, STATEMENT_DATE STATEMENT_DATE
, CURRENCY_CODE CURRENCY_CODE
, FINANCE_CHARGES FINANCE_CHARGES
, TOTAL_AMOUNT_DUE TOTAL_AMOUNT_DUE
, SITE_USE_ID SITE_USE_ID
, STATEMENT_TYPE STATEMENT_TYPE
, BILL_TO_LOCATION BILL_TO_LOCATION
, CREDIT_BALANCE_STATEMENTS CREDIT_BALANCE_STATEMENTS
, CUST_CUSTOMER_PROFILE_ID CUST_CUSTOMER_PROFILE_ID
, MIN_STATEMENT_AMOUNT MIN_STATEMENT_AMOUNT
, MONTHLY_INTEREST_RATE MONTHLY_INTEREST_RATE
, SITE_CUSTOMER_PROFILE_ID SITE_CUSTOMER_PROFILE_ID
, IS_IT_A_REPRINT IS_IT_A_REPRINT
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, ORG_ID ORG_ID
, STATEMENT_CYCLE_ID STATEMENT_CYCLE_ID
FROM "AR"."AR_STATEMENTS_HISTORY_ALL"