VIEW: AR.AR_MC_RECEIVABLE_APPS#

Source

View Text - Preformatted

select RECEIVABLE_APPLICATION_ID RECEIVABLE_APPLICATION_ID, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, AMOUNT_APPLIED AMOUNT_APPLIED, DISPLAY DISPLAY, STATUS STATUS, PAYMENT_SCHEDULE_ID PAYMENT_SCHEDULE_ID, CASH_RECEIPT_ID CASH_RECEIPT_ID, GL_POSTED_DATE GL_POSTED_DATE, POSTING_CONTROL_ID POSTING_CONTROL_ID, ACCTD_AMOUNT_APPLIED_FROM ACCTD_AMOUNT_APPLIED_FROM, ACCTD_AMOUNT_APPLIED_TO ACCTD_AMOUNT_APPLIED_TO, ACCTD_EARNED_DISCOUNT_TAKEN ACCTD_EARNED_DISCOUNT_TAKEN, ACCTD_UNEARNED_DISCOUNT_TAKEN ACCTD_UNEARNED_DISCOUNT_TAKEN, AMOUNT_APPLIED_FROM AMOUNT_APPLIED_FROM, CASH_RECEIPT_HISTORY_ID CASH_RECEIPT_HISTORY_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, PROGRAM_ID PROGRAM_ID, APPLICATION_RULE APPLICATION_RULE, REVERSAL_CREATED REVERSAL_CREATED, ADJUSTMENT_CREATED ADJUSTMENT_CREATED, LAST_UPDATED_BY LAST_UPDATED_BY from "AR"."AR_MC_RECEIVABLE_APPS"

View Text - HTML Formatted

SELECT RECEIVABLE_APPLICATION_ID RECEIVABLE_APPLICATION_ID
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, AMOUNT_APPLIED AMOUNT_APPLIED
, DISPLAY DISPLAY
, STATUS STATUS
, PAYMENT_SCHEDULE_ID PAYMENT_SCHEDULE_ID
, CASH_RECEIPT_ID CASH_RECEIPT_ID
, GL_POSTED_DATE GL_POSTED_DATE
, POSTING_CONTROL_ID POSTING_CONTROL_ID
, ACCTD_AMOUNT_APPLIED_FROM ACCTD_AMOUNT_APPLIED_FROM
, ACCTD_AMOUNT_APPLIED_TO ACCTD_AMOUNT_APPLIED_TO
, ACCTD_EARNED_DISCOUNT_TAKEN ACCTD_EARNED_DISCOUNT_TAKEN
, ACCTD_UNEARNED_DISCOUNT_TAKEN ACCTD_UNEARNED_DISCOUNT_TAKEN
, AMOUNT_APPLIED_FROM AMOUNT_APPLIED_FROM
, CASH_RECEIPT_HISTORY_ID CASH_RECEIPT_HISTORY_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, PROGRAM_ID PROGRAM_ID
, APPLICATION_RULE APPLICATION_RULE
, REVERSAL_CREATED REVERSAL_CREATED
, ADJUSTMENT_CREATED ADJUSTMENT_CREATED
, LAST_UPDATED_BY LAST_UPDATED_BY
FROM "AR"."AR_MC_RECEIVABLE_APPS"