VIEW: FV.FV_INTERIM_CASH_RECEIPTS_ALL#

Source

View Text - Preformatted

select BATCH_ID BATCH_ID, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, RECEIPT_METHOD_ID RECEIPT_METHOD_ID, CURRENCY_CODE CURRENCY_CODE, RECEIPT_NUMBER RECEIPT_NUMBER, CUSTOMER_ID CUSTOMER_ID, SPECIAL_TYPE SPECIAL_TYPE, STATUS STATUS, CUSTOMER_TRX_ID CUSTOMER_TRX_ID, GL_DATE GL_DATE, AMOUNT AMOUNT, SITE_USE_ID SITE_USE_ID, BANK_ACCOUNT_ID BANK_ACCOUNT_ID, RECEIPT_DATE RECEIPT_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, RELATED_INVOICE_ID RELATED_INVOICE_ID, PAYMENT_SCHEDULE_ID PAYMENT_SCHEDULE_ID, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, 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, ORG_ID ORG_ID, USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE, RECEIPT_DESC_TYPE RECEIPT_DESC_TYPE, CUSTOMER_TRX_LINE_ID CUSTOMER_TRX_LINE_ID, CE_BANK_ACCOUNT_ID CE_BANK_ACCOUNT_ID, CE_BANK_ACCT_USE_ID CE_BANK_ACCT_USE_ID from "FV"."FV_INTERIM_CASH_RECEIPTS_ALL"

View Text - HTML Formatted

SELECT BATCH_ID BATCH_ID
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, RECEIPT_METHOD_ID RECEIPT_METHOD_ID
, CURRENCY_CODE CURRENCY_CODE
, RECEIPT_NUMBER RECEIPT_NUMBER
, CUSTOMER_ID CUSTOMER_ID
, SPECIAL_TYPE SPECIAL_TYPE
, STATUS STATUS
, CUSTOMER_TRX_ID CUSTOMER_TRX_ID
, GL_DATE GL_DATE
, AMOUNT AMOUNT
, SITE_USE_ID SITE_USE_ID
, BANK_ACCOUNT_ID BANK_ACCOUNT_ID
, RECEIPT_DATE RECEIPT_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, RELATED_INVOICE_ID RELATED_INVOICE_ID
, PAYMENT_SCHEDULE_ID PAYMENT_SCHEDULE_ID
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, 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
, ORG_ID ORG_ID
, USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE
, RECEIPT_DESC_TYPE RECEIPT_DESC_TYPE
, CUSTOMER_TRX_LINE_ID CUSTOMER_TRX_LINE_ID
, CE_BANK_ACCOUNT_ID CE_BANK_ACCOUNT_ID
, CE_BANK_ACCT_USE_ID CE_BANK_ACCT_USE_ID
FROM "FV"."FV_INTERIM_CASH_RECEIPTS_ALL"