VIEW: IBY.IBY_BATCHES_ALL#

Source

View Text - Preformatted

select MBATCHID MBATCHID, BATCHID BATCHID, PAYEEID PAYEEID, BEPID BEPID, MPAYEEID MPAYEEID, ECAPPID ECAPPID, PAYMENTMETHODNAME PAYMENTMETHODNAME, BATCHSTATUS BATCHSTATUS, BATCHCLOSEDATE BATCHCLOSEDATE, NUMTRXNS NUMTRXNS, BATCHSTATEID BATCHSTATEID, BATCHTOTAL BATCHTOTAL, BATCHSALES BATCHSALES, BATCHCREDIT BATCHCREDIT, CURRENCYNAMECODE CURRENCYNAMECODE, VPSBATCHID VPSBATCHID, GWBATCHID GWBATCHID, ERRORLOCATION ERRORLOCATION, BEPCODE BEPCODE, BEPMESSAGE BEPMESSAGE, BATCHOPENDATE BATCHOPENDATE, REQTYPE REQTYPE, REQDATE REQDATE, DESTURL DESTURL, TERMINALID TERMINALID, ACQUIRER ACQUIRER, NLSLANG NLSLANG, NEEDSUPDT NEEDSUPDT, LAST_UPDATE_DATE LAST_UPDATE_DATE, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, ORG_ID ORG_ID, SECURITY_GROUP_ID SECURITY_GROUP_ID, BEPKEY BEPKEY, SENTCOUNTER SENTCOUNTER, SENTCOUNTERDAILY SENTCOUNTERDAILY, LEGAL_ENTITY_ID LEGAL_ENTITY_ID, PROCESS_PROFILE_CODE PROCESS_PROFILE_CODE, PAYEEINSTRID PAYEEINSTRID, SETTLEDATE SETTLEDATE, ORG_TYPE ORG_TYPE, INSTRUMENT_TYPE INSTRUMENT_TYPE, BR_DISPUTED_FLAG BR_DISPUTED_FLAG, PAYER_NOTIFICATION_REQUIRED PAYER_NOTIFICATION_REQUIRED, PAYER_NOTIFICATION_CREATED PAYER_NOTIFICATION_CREATED from "IBY"."IBY_BATCHES_ALL"

View Text - HTML Formatted

SELECT MBATCHID MBATCHID
, BATCHID BATCHID
, PAYEEID PAYEEID
, BEPID BEPID
, MPAYEEID MPAYEEID
, ECAPPID ECAPPID
, PAYMENTMETHODNAME PAYMENTMETHODNAME
, BATCHSTATUS BATCHSTATUS
, BATCHCLOSEDATE BATCHCLOSEDATE
, NUMTRXNS NUMTRXNS
, BATCHSTATEID BATCHSTATEID
, BATCHTOTAL BATCHTOTAL
, BATCHSALES BATCHSALES
, BATCHCREDIT BATCHCREDIT
, CURRENCYNAMECODE CURRENCYNAMECODE
, VPSBATCHID VPSBATCHID
, GWBATCHID GWBATCHID
, ERRORLOCATION ERRORLOCATION
, BEPCODE BEPCODE
, BEPMESSAGE BEPMESSAGE
, BATCHOPENDATE BATCHOPENDATE
, REQTYPE REQTYPE
, REQDATE REQDATE
, DESTURL DESTURL
, TERMINALID TERMINALID
, ACQUIRER ACQUIRER
, NLSLANG NLSLANG
, NEEDSUPDT NEEDSUPDT
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, ORG_ID ORG_ID
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, BEPKEY BEPKEY
, SENTCOUNTER SENTCOUNTER
, SENTCOUNTERDAILY SENTCOUNTERDAILY
, LEGAL_ENTITY_ID LEGAL_ENTITY_ID
, PROCESS_PROFILE_CODE PROCESS_PROFILE_CODE
, PAYEEINSTRID PAYEEINSTRID
, SETTLEDATE SETTLEDATE
, ORG_TYPE ORG_TYPE
, INSTRUMENT_TYPE INSTRUMENT_TYPE
, BR_DISPUTED_FLAG BR_DISPUTED_FLAG
, PAYER_NOTIFICATION_REQUIRED PAYER_NOTIFICATION_REQUIRED
, PAYER_NOTIFICATION_CREATED PAYER_NOTIFICATION_CREATED
FROM "IBY"."IBY_BATCHES_ALL"