VIEW: IBY.IBY_PAY_BATCHES_ALL#

Source

View Text - Preformatted

select PMT_BATCH_REQUEST_ID PMT_BATCH_REQUEST_ID, PAYER_ID PAYER_ID, MPAYER_ID MPAYER_ID, BATCH_ID BATCH_ID, IBY_BATCH_ID IBY_BATCH_ID, IBY_MBATCH_ID IBY_MBATCH_ID, ECAPP_ID ECAPP_ID, BEPID BEPID, BEPKEY BEPKEY, CUST_ID CUST_ID, CUST_NAME CUST_NAME, CUST_ADDR1 CUST_ADDR1, CUST_ADDR2 CUST_ADDR2, CUST_ADDR3 CUST_ADDR3, CUST_ADDR_CITY CUST_ADDR_CITY, CUST_ADDR_COUNTY CUST_ADDR_COUNTY, CUST_ADDR_STATE CUST_ADDR_STATE, CUST_ADDR_ZIP CUST_ADDR_ZIP, CUST_ADDR_COUNTRY CUST_ADDR_COUNTRY, CUST_ADDR_ADDN CUST_ADDR_ADDN, ORIG_BANK_NAME ORIG_BANK_NAME, ORIG_BANK_NUMBER ORIG_BANK_NUMBER, ORIG_BANK_BRANCH_NAME ORIG_BANK_BRANCH_NAME, ORIG_BANK_BRANCH_TYPE ORIG_BANK_BRANCH_TYPE, ORIG_BANK_BRANCH_NUM ORIG_BANK_BRANCH_NUM, ORIG_EFT_SWIFT_CODE ORIG_EFT_SWIFT_CODE, ORIG_BANK_ACCOUNT_NAME ORIG_BANK_ACCOUNT_NAME, ORIG_BANK_ACCT_NUMBER ORIG_BANK_ACCT_NUMBER, ORIG_BANK_ACCT_CHECK_DIGITS ORIG_BANK_ACCT_CHECK_DIGITS, ORIG_BANK_ACCT_TYPE ORIG_BANK_ACCT_TYPE, ORIG_BANK_ADDR_LINE1 ORIG_BANK_ADDR_LINE1, ORIG_BANK_ADDR_CITY ORIG_BANK_ADDR_CITY, ORIG_BANK_ADDR_STATE ORIG_BANK_ADDR_STATE, ORIG_BANK_ADDR_ZIP ORIG_BANK_ADDR_ZIP, ORIG_COUNTRY_CODE ORIG_COUNTRY_CODE, PMT_METHOD PMT_METHOD, CURRENCY_CODE CURRENCY_CODE, REF_CURRENCY_CODE REF_CURRENCY_CODE, DOC_ORDER_LOOKUP_CODE DOC_ORDER_LOOKUP_CODE, NUM_OF_TRXNS NUM_OF_TRXNS, BATCH_TOTAL BATCH_TOTAL, BATCH_STATUS BATCH_STATUS, REQUEST_DATE REQUEST_DATE, PMT_BATCH_NAME PMT_BATCH_NAME, PMT_BATCH_SET_ID PMT_BATCH_SET_ID, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, ERROR_LOCATION ERROR_LOCATION, ORG_ID ORG_ID, BEP_CODE BEP_CODE, BEP_MESSAGE BEP_MESSAGE from "IBY"."IBY_PAY_BATCHES_ALL"

View Text - HTML Formatted

SELECT PMT_BATCH_REQUEST_ID PMT_BATCH_REQUEST_ID
, PAYER_ID PAYER_ID
, MPAYER_ID MPAYER_ID
, BATCH_ID BATCH_ID
, IBY_BATCH_ID IBY_BATCH_ID
, IBY_MBATCH_ID IBY_MBATCH_ID
, ECAPP_ID ECAPP_ID
, BEPID BEPID
, BEPKEY BEPKEY
, CUST_ID CUST_ID
, CUST_NAME CUST_NAME
, CUST_ADDR1 CUST_ADDR1
, CUST_ADDR2 CUST_ADDR2
, CUST_ADDR3 CUST_ADDR3
, CUST_ADDR_CITY CUST_ADDR_CITY
, CUST_ADDR_COUNTY CUST_ADDR_COUNTY
, CUST_ADDR_STATE CUST_ADDR_STATE
, CUST_ADDR_ZIP CUST_ADDR_ZIP
, CUST_ADDR_COUNTRY CUST_ADDR_COUNTRY
, CUST_ADDR_ADDN CUST_ADDR_ADDN
, ORIG_BANK_NAME ORIG_BANK_NAME
, ORIG_BANK_NUMBER ORIG_BANK_NUMBER
, ORIG_BANK_BRANCH_NAME ORIG_BANK_BRANCH_NAME
, ORIG_BANK_BRANCH_TYPE ORIG_BANK_BRANCH_TYPE
, ORIG_BANK_BRANCH_NUM ORIG_BANK_BRANCH_NUM
, ORIG_EFT_SWIFT_CODE ORIG_EFT_SWIFT_CODE
, ORIG_BANK_ACCOUNT_NAME ORIG_BANK_ACCOUNT_NAME
, ORIG_BANK_ACCT_NUMBER ORIG_BANK_ACCT_NUMBER
, ORIG_BANK_ACCT_CHECK_DIGITS ORIG_BANK_ACCT_CHECK_DIGITS
, ORIG_BANK_ACCT_TYPE ORIG_BANK_ACCT_TYPE
, ORIG_BANK_ADDR_LINE1 ORIG_BANK_ADDR_LINE1
, ORIG_BANK_ADDR_CITY ORIG_BANK_ADDR_CITY
, ORIG_BANK_ADDR_STATE ORIG_BANK_ADDR_STATE
, ORIG_BANK_ADDR_ZIP ORIG_BANK_ADDR_ZIP
, ORIG_COUNTRY_CODE ORIG_COUNTRY_CODE
, PMT_METHOD PMT_METHOD
, CURRENCY_CODE CURRENCY_CODE
, REF_CURRENCY_CODE REF_CURRENCY_CODE
, DOC_ORDER_LOOKUP_CODE DOC_ORDER_LOOKUP_CODE
, NUM_OF_TRXNS NUM_OF_TRXNS
, BATCH_TOTAL BATCH_TOTAL
, BATCH_STATUS BATCH_STATUS
, REQUEST_DATE REQUEST_DATE
, PMT_BATCH_NAME PMT_BATCH_NAME
, PMT_BATCH_SET_ID PMT_BATCH_SET_ID
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, ERROR_LOCATION ERROR_LOCATION
, ORG_ID ORG_ID
, BEP_CODE BEP_CODE
, BEP_MESSAGE BEP_MESSAGE
FROM "IBY"."IBY_PAY_BATCHES_ALL"