VIEW: AR.AR_STATEMENT_LINE_CLUSTERS#

Source

View Text - Preformatted

select LINE_CLUSTER_ID LINE_CLUSTER_ID, CUSTOMER_TRX_SEQUENCE CUSTOMER_TRX_SEQUENCE, PAYMENT_SCHEDULE_SEQUENCE PAYMENT_SCHEDULE_SEQUENCE, TRX_ORDER_SEQUENCE TRX_ORDER_SEQUENCE, GENERAL_SEQUENCE GENERAL_SEQUENCE, INVOICE_NUMBER INVOICE_NUMBER, TRX_DATE TRX_DATE, TRANSACTION TRANSACTION, DUE_DATE DUE_DATE, REFERENCE REFERENCE, BILL_TO_LOCATION BILL_TO_LOCATION, TRX_AMOUNT TRX_AMOUNT, AMOUNT_DUE AMOUNT_DUE, ADJUSTMENT_ID ADJUSTMENT_ID, CUSTOMER_ID CUSTOMER_ID, RECEIVABLE_APPLICATION_ID RECEIVABLE_APPLICATION_ID, REQUEST_ID REQUEST_ID, SITE_USE_ID SITE_USE_ID, BILL_TO_CITY BILL_TO_CITY, ORIG_PAYMENT_AMOUNT ORIG_PAYMENT_AMOUNT, TRANSACTION_CODE TRANSACTION_CODE, RECEIPT_CURRENCY_CODE RECEIPT_CURRENCY_CODE, AMOUNT_APPLIED_FROM AMOUNT_APPLIED_FROM from "AR"."AR_STATEMENT_LINE_CLUSTERS"

View Text - HTML Formatted

SELECT LINE_CLUSTER_ID LINE_CLUSTER_ID
, CUSTOMER_TRX_SEQUENCE CUSTOMER_TRX_SEQUENCE
, PAYMENT_SCHEDULE_SEQUENCE PAYMENT_SCHEDULE_SEQUENCE
, TRX_ORDER_SEQUENCE TRX_ORDER_SEQUENCE
, GENERAL_SEQUENCE GENERAL_SEQUENCE
, INVOICE_NUMBER INVOICE_NUMBER
, TRX_DATE TRX_DATE
, TRANSACTION TRANSACTION
, DUE_DATE DUE_DATE
, REFERENCE REFERENCE
, BILL_TO_LOCATION BILL_TO_LOCATION
, TRX_AMOUNT TRX_AMOUNT
, AMOUNT_DUE AMOUNT_DUE
, ADJUSTMENT_ID ADJUSTMENT_ID
, CUSTOMER_ID CUSTOMER_ID
, RECEIVABLE_APPLICATION_ID RECEIVABLE_APPLICATION_ID
, REQUEST_ID REQUEST_ID
, SITE_USE_ID SITE_USE_ID
, BILL_TO_CITY BILL_TO_CITY
, ORIG_PAYMENT_AMOUNT ORIG_PAYMENT_AMOUNT
, TRANSACTION_CODE TRANSACTION_CODE
, RECEIPT_CURRENCY_CODE RECEIPT_CURRENCY_CODE
, AMOUNT_APPLIED_FROM AMOUNT_APPLIED_FROM
FROM "AR"."AR_STATEMENT_LINE_CLUSTERS"