VIEW: AR.AR_BR_TRX_BATCH_RPT#

Source

View Text - Preformatted

select CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REQUEST_ID REQUEST_ID, BATCH_ID BATCH_ID, BR_CUSTOMER_TRX_ID BR_CUSTOMER_TRX_ID, BILL_NUMBER BILL_NUMBER, BR_AMOUNT BR_AMOUNT, BR_CURRENCY BR_CURRENCY, BATCH_STATUS BATCH_STATUS, MATURITY_DATE MATURITY_DATE, DRAWEE_ID DRAWEE_ID, DRAWEE_CONTACT_ID DRAWEE_CONTACT_ID, DRAWEE_SITE_USE_ID DRAWEE_SITE_USE_ID, DRAWEE_BANK_ACCOUNT_ID DRAWEE_BANK_ACCOUNT_ID, TRANSACTION_ID TRANSACTION_ID, AMOUNT_ASSIGNED AMOUNT_ASSIGNED, RECEIPT_METHOD_NAME RECEIPT_METHOD_NAME, RECEIPT_CREATION_RULE_CODE RECEIPT_CREATION_RULE_CODE, BR_MIN_ACCTD_AMOUNT BR_MIN_ACCTD_AMOUNT, BR_MAX_ACCTD_AMOUNT BR_MAX_ACCTD_AMOUNT, LEAD_DAYS LEAD_DAYS from "AR"."AR_BR_TRX_BATCH_RPT"

View Text - HTML Formatted

SELECT CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REQUEST_ID REQUEST_ID
, BATCH_ID BATCH_ID
, BR_CUSTOMER_TRX_ID BR_CUSTOMER_TRX_ID
, BILL_NUMBER BILL_NUMBER
, BR_AMOUNT BR_AMOUNT
, BR_CURRENCY BR_CURRENCY
, BATCH_STATUS BATCH_STATUS
, MATURITY_DATE MATURITY_DATE
, DRAWEE_ID DRAWEE_ID
, DRAWEE_CONTACT_ID DRAWEE_CONTACT_ID
, DRAWEE_SITE_USE_ID DRAWEE_SITE_USE_ID
, DRAWEE_BANK_ACCOUNT_ID DRAWEE_BANK_ACCOUNT_ID
, TRANSACTION_ID TRANSACTION_ID
, AMOUNT_ASSIGNED AMOUNT_ASSIGNED
, RECEIPT_METHOD_NAME RECEIPT_METHOD_NAME
, RECEIPT_CREATION_RULE_CODE RECEIPT_CREATION_RULE_CODE
, BR_MIN_ACCTD_AMOUNT BR_MIN_ACCTD_AMOUNT
, BR_MAX_ACCTD_AMOUNT BR_MAX_ACCTD_AMOUNT
, LEAD_DAYS LEAD_DAYS
FROM "AR"."AR_BR_TRX_BATCH_RPT"