VIEW: AR.AR_BATCHES_ALL#

Source

View Text - Preformatted

select BATCH_ID BATCH_ID, 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, NAME NAME, BATCH_DATE BATCH_DATE, GL_DATE GL_DATE, STATUS STATUS, DEPOSIT_DATE DEPOSIT_DATE, CLOSED_DATE CLOSED_DATE, TYPE TYPE, BATCH_SOURCE_ID BATCH_SOURCE_ID, CONTROL_COUNT CONTROL_COUNT, CONTROL_AMOUNT CONTROL_AMOUNT, BATCH_APPLIED_STATUS BATCH_APPLIED_STATUS, CURRENCY_CODE CURRENCY_CODE, EXCHANGE_RATE_TYPE EXCHANGE_RATE_TYPE, EXCHANGE_DATE EXCHANGE_DATE, EXCHANGE_RATE EXCHANGE_RATE, TRANSMISSION_REQUEST_ID TRANSMISSION_REQUEST_ID, LOCKBOX_ID LOCKBOX_ID, LOCKBOX_BATCH_NAME LOCKBOX_BATCH_NAME, COMMENTS COMMENTS, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, MEDIA_REFERENCE MEDIA_REFERENCE, OPERATION_REQUEST_ID OPERATION_REQUEST_ID, RECEIPT_METHOD_ID RECEIPT_METHOD_ID, REMITTANCE_BANK_ACCOUNT_ID REMITTANCE_BANK_ACCOUNT_ID, RECEIPT_CLASS_ID RECEIPT_CLASS_ID, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, REMITTANCE_BANK_BRANCH_ID REMITTANCE_BANK_BRANCH_ID, REMIT_METHOD_CODE REMIT_METHOD_CODE, REQUEST_ID REQUEST_ID, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, TRANSMISSION_ID TRANSMISSION_ID, BANK_DEPOSIT_NUMBER BANK_DEPOSIT_NUMBER, ORG_ID ORG_ID, PURGED_CHILDREN_FLAG PURGED_CHILDREN_FLAG, WITH_RECOURSE_FLAG WITH_RECOURSE_FLAG, AUTO_PRINT_PROGRAM_ID AUTO_PRINT_PROGRAM_ID, AUTO_TRANS_PROGRAM_ID AUTO_TRANS_PROGRAM_ID, REMIT_BANK_ACCT_USE_ID REMIT_BANK_ACCT_USE_ID, OLD_REMITTANCE_BANK_BRANCH_ID OLD_REMITTANCE_BANK_BRANCH_ID from "AR"."AR_BATCHES_ALL"

View Text - HTML Formatted

SELECT BATCH_ID BATCH_ID
, 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
, NAME NAME
, BATCH_DATE BATCH_DATE
, GL_DATE GL_DATE
, STATUS STATUS
, DEPOSIT_DATE DEPOSIT_DATE
, CLOSED_DATE CLOSED_DATE
, TYPE TYPE
, BATCH_SOURCE_ID BATCH_SOURCE_ID
, CONTROL_COUNT CONTROL_COUNT
, CONTROL_AMOUNT CONTROL_AMOUNT
, BATCH_APPLIED_STATUS BATCH_APPLIED_STATUS
, CURRENCY_CODE CURRENCY_CODE
, EXCHANGE_RATE_TYPE EXCHANGE_RATE_TYPE
, EXCHANGE_DATE EXCHANGE_DATE
, EXCHANGE_RATE EXCHANGE_RATE
, TRANSMISSION_REQUEST_ID TRANSMISSION_REQUEST_ID
, LOCKBOX_ID LOCKBOX_ID
, LOCKBOX_BATCH_NAME LOCKBOX_BATCH_NAME
, COMMENTS COMMENTS
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, MEDIA_REFERENCE MEDIA_REFERENCE
, OPERATION_REQUEST_ID OPERATION_REQUEST_ID
, RECEIPT_METHOD_ID RECEIPT_METHOD_ID
, REMITTANCE_BANK_ACCOUNT_ID REMITTANCE_BANK_ACCOUNT_ID
, RECEIPT_CLASS_ID RECEIPT_CLASS_ID
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, REMITTANCE_BANK_BRANCH_ID REMITTANCE_BANK_BRANCH_ID
, REMIT_METHOD_CODE REMIT_METHOD_CODE
, REQUEST_ID REQUEST_ID
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, TRANSMISSION_ID TRANSMISSION_ID
, BANK_DEPOSIT_NUMBER BANK_DEPOSIT_NUMBER
, ORG_ID ORG_ID
, PURGED_CHILDREN_FLAG PURGED_CHILDREN_FLAG
, WITH_RECOURSE_FLAG WITH_RECOURSE_FLAG
, AUTO_PRINT_PROGRAM_ID AUTO_PRINT_PROGRAM_ID
, AUTO_TRANS_PROGRAM_ID AUTO_TRANS_PROGRAM_ID
, REMIT_BANK_ACCT_USE_ID REMIT_BANK_ACCT_USE_ID
, OLD_REMITTANCE_BANK_BRANCH_ID OLD_REMITTANCE_BANK_BRANCH_ID
FROM "AR"."AR_BATCHES_ALL"