[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IBY_PAY_PAYMENTS_ALL# |
|---|---|
| Object Type: | VIEW |
| Owner: | IBY |
| Subobject Name: | |
| Status: | VALID |
Cut, paste (and edit) the following text to query this object:
SELECT ECAPP_ID
, PAYER_ID
, BATCH_ID
, PMT_TRXN_ID
, PMT_PRIORITY
, DEBIT_ACCT_NUMBER
, FAX_MAIL_TO_NAME
, MAIL_ADDRESS1
, MAIL_ADDRESS2
, MAIL_ADDRESS3
, MAIL_ADDR_CITY
, MAIL_ADDR_STATE
, MAIL_ADDR_ZIP
, PMT_LOC_COUNTRY_CODE
, VALUE_AMOUNT
, REF_AMOUNT
, VALUE_DATE
, CHARGE_DETAILS
, VAT_AMOUNT
, WHT_AMOUNT
, PMT_DETAILS_1
, PMT_DETAILS_2
, PMT_DETAILS_3
, PMT_DETAILS_4
, TRXN_CODE_CLRID
, BNF_NAME
, BNF_ID
, BNF_ADDRESS_LINE1
, BNF_ADDRESS_LINE2
, BNF_ADDRESS_LINE3
, BNF_ADDR_CITY
, BNF_ADDR_STATE
, BNF_ADDR_ZIP
, BNF_ADDR_COUNTRY
, BNF_ADDR_PHONE
, BNF_REMARKS
, BNF_CHARGE_AMT
, BNF_ADJUSTMENT_AMT
, BNF_BANK_NAME
, BNF_BANK_NUM
, BNF_BANK_ADDRESS
, BNF_BANK_ADDR_CITY
, BNF_BANK_ADDR_STATE
, BNF_BANK_ADDR_ZIP
, BNF_BANK_ADDR_COUNTRY
, BNF_BANK_BRANCH_NAME
, BNF_BANK_BRANCH_NUM
, BNF_BANK_BRANCH_TYPE
, BNF_BANK_SWIFT_CODE
, BNF_BANK_ACCOUNT_NAME
, BNF_BANK_ACCT_NUMBER
, BNF_BANK_ACCT_CHECK_DIGITS
, BNF_BANK_ACCT_IBAN_NUMBER
, BNF_BANK_ACCT_TYPE
, BNF_FAXNO_CABLEADDR
, BNF_SITE_CODE
, BNF_BANK_CLEARING_MTD
, BNF_TAXPAYER_ID
, FUTURE_PAY_DUE_DATE
, CUST_REF
, INTRM_BANK_CODE
, INTRM_SWIFT_CODE
, INTRM_BANK_NAME
, INTRM_BANK_FAXNO_CBL
, PMT_STATUS
, PMT_APPROVAL_STATUS
, UPDATE_DATE
, OBJECT_VERSION_NUMBER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, ORG_ID
, ERROR_LOCATION
, BEP_CODE
, BEP_MESSAGE
FROM IBY.IBY_PAY_PAYMENTS_ALL#;
IBY
IBY_PAY_PAYMENTS_ALL
APPS
IBY_PAY_PAYMENTS_ALL
|
|
|
|