VIEW: AR.AR_CASH_RECEIPT_HISTORY_ALL#

Source

View Text - Preformatted

select CASH_RECEIPT_HISTORY_ID CASH_RECEIPT_HISTORY_ID, CASH_RECEIPT_ID CASH_RECEIPT_ID, STATUS STATUS, TRX_DATE TRX_DATE, AMOUNT AMOUNT, FIRST_POSTED_RECORD_FLAG FIRST_POSTED_RECORD_FLAG, POSTABLE_FLAG POSTABLE_FLAG, FACTOR_FLAG FACTOR_FLAG, GL_DATE GL_DATE, CURRENT_RECORD_FLAG CURRENT_RECORD_FLAG, BATCH_ID BATCH_ID, ACCOUNT_CODE_COMBINATION_ID ACCOUNT_CODE_COMBINATION_ID, REVERSAL_GL_DATE REVERSAL_GL_DATE, REVERSAL_CASH_RECEIPT_HIST_ID REVERSAL_CASH_RECEIPT_HIST_ID, FACTOR_DISCOUNT_AMOUNT FACTOR_DISCOUNT_AMOUNT, BANK_CHARGE_ACCOUNT_CCID BANK_CHARGE_ACCOUNT_CCID, POSTING_CONTROL_ID POSTING_CONTROL_ID, REVERSAL_POSTING_CONTROL_ID REVERSAL_POSTING_CONTROL_ID, GL_POSTED_DATE GL_POSTED_DATE, REVERSAL_GL_POSTED_DATE REVERSAL_GL_POSTED_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, ACCTD_AMOUNT ACCTD_AMOUNT, ACCTD_FACTOR_DISCOUNT_AMOUNT ACCTD_FACTOR_DISCOUNT_AMOUNT, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, EXCHANGE_DATE EXCHANGE_DATE, EXCHANGE_RATE EXCHANGE_RATE, EXCHANGE_RATE_TYPE EXCHANGE_RATE_TYPE, LAST_UPDATE_DATE LAST_UPDATE_DATE, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, REQUEST_ID REQUEST_ID, LAST_UPDATED_BY LAST_UPDATED_BY, PRV_STAT_CASH_RECEIPT_HIST_ID PRV_STAT_CASH_RECEIPT_HIST_ID, CREATED_FROM CREATED_FROM, REVERSAL_CREATED_FROM REVERSAL_CREATED_FROM, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, NOTE_STATUS NOTE_STATUS, ORG_ID ORG_ID, MRC_POSTING_CONTROL_ID MRC_POSTING_CONTROL_ID, MRC_GL_POSTED_DATE MRC_GL_POSTED_DATE, MRC_REVERSAL_GL_POSTED_DATE MRC_REVERSAL_GL_POSTED_DATE, MRC_ACCTD_AMOUNT MRC_ACCTD_AMOUNT, MRC_ACCTD_FACTOR_DISC_AMOUNT MRC_ACCTD_FACTOR_DISC_AMOUNT, MRC_EXCHANGE_DATE MRC_EXCHANGE_DATE, MRC_EXCHANGE_RATE MRC_EXCHANGE_RATE, MRC_EXCHANGE_RATE_TYPE MRC_EXCHANGE_RATE_TYPE, EVENT_ID EVENT_ID from "AR"."AR_CASH_RECEIPT_HISTORY_ALL"

View Text - HTML Formatted

SELECT CASH_RECEIPT_HISTORY_ID CASH_RECEIPT_HISTORY_ID
, CASH_RECEIPT_ID CASH_RECEIPT_ID
, STATUS STATUS
, TRX_DATE TRX_DATE
, AMOUNT AMOUNT
, FIRST_POSTED_RECORD_FLAG FIRST_POSTED_RECORD_FLAG
, POSTABLE_FLAG POSTABLE_FLAG
, FACTOR_FLAG FACTOR_FLAG
, GL_DATE GL_DATE
, CURRENT_RECORD_FLAG CURRENT_RECORD_FLAG
, BATCH_ID BATCH_ID
, ACCOUNT_CODE_COMBINATION_ID ACCOUNT_CODE_COMBINATION_ID
, REVERSAL_GL_DATE REVERSAL_GL_DATE
, REVERSAL_CASH_RECEIPT_HIST_ID REVERSAL_CASH_RECEIPT_HIST_ID
, FACTOR_DISCOUNT_AMOUNT FACTOR_DISCOUNT_AMOUNT
, BANK_CHARGE_ACCOUNT_CCID BANK_CHARGE_ACCOUNT_CCID
, POSTING_CONTROL_ID POSTING_CONTROL_ID
, REVERSAL_POSTING_CONTROL_ID REVERSAL_POSTING_CONTROL_ID
, GL_POSTED_DATE GL_POSTED_DATE
, REVERSAL_GL_POSTED_DATE REVERSAL_GL_POSTED_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, ACCTD_AMOUNT ACCTD_AMOUNT
, ACCTD_FACTOR_DISCOUNT_AMOUNT ACCTD_FACTOR_DISCOUNT_AMOUNT
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, EXCHANGE_DATE EXCHANGE_DATE
, EXCHANGE_RATE EXCHANGE_RATE
, EXCHANGE_RATE_TYPE EXCHANGE_RATE_TYPE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, REQUEST_ID REQUEST_ID
, LAST_UPDATED_BY LAST_UPDATED_BY
, PRV_STAT_CASH_RECEIPT_HIST_ID PRV_STAT_CASH_RECEIPT_HIST_ID
, CREATED_FROM CREATED_FROM
, REVERSAL_CREATED_FROM REVERSAL_CREATED_FROM
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, NOTE_STATUS NOTE_STATUS
, ORG_ID ORG_ID
, MRC_POSTING_CONTROL_ID MRC_POSTING_CONTROL_ID
, MRC_GL_POSTED_DATE MRC_GL_POSTED_DATE
, MRC_REVERSAL_GL_POSTED_DATE MRC_REVERSAL_GL_POSTED_DATE
, MRC_ACCTD_AMOUNT MRC_ACCTD_AMOUNT
, MRC_ACCTD_FACTOR_DISC_AMOUNT MRC_ACCTD_FACTOR_DISC_AMOUNT
, MRC_EXCHANGE_DATE MRC_EXCHANGE_DATE
, MRC_EXCHANGE_RATE MRC_EXCHANGE_RATE
, MRC_EXCHANGE_RATE_TYPE MRC_EXCHANGE_RATE_TYPE
, EVENT_ID EVENT_ID
FROM "AR"."AR_CASH_RECEIPT_HISTORY_ALL"