[Home] [Help]
View: APBV_BANK_ACCOUNTS
| Product: | AP - Payables |
|---|
| Description: | Business view |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT ACC.BANK_ACCOUNT_ID
, ACC.BANK_ACCOUNT_NAME
, ACC.BANK_ACCOUNT_NAME_ALT
, ACC.BANK_ACCOUNT_NUM
, ACC.BANK_ACCOUNT_TYPE
, ACC.MULTI_CURRENCY_FLAG
, ACC.POOLED_FLAG
, ACC.DESCRIPTION
, ACC.MAX_OUTLAY
, ACC.MIN_CHECK_AMOUNT
, ACC.MAX_CHECK_AMOUNT
, ACC.ZERO_AMOUNTS_ALLOWED
, ACC.CONTACT_FIRST_NAME
, ACC.CONTACT_MIDDLE_NAME
, ACC.CONTACT_LAST_NAME
, ACC.CONTACT_PREFIX
, ACC.CONTACT_TITLE
, ACC.CONTACT_AREA_CODE
, ACC.CONTACT_PHONE
, ACC.INACTIVE_DATE
, ACC.ACCOUNT_HOLDER_NAME
, ACC.ACCOUNT_HOLDER_NAME_ALT
, ACC.EFT_USER_NUMBER
, ACC.BANK_BRANCH_ID
, ACC.CURRENCY_CODE
, ACC.CREATION_DATE
, ACC.CREATED_BY
, ACC.LAST_UPDATE_DATE
, ACC.LAST_UPDATED_BY
FROM AP_BANK_ACCOUNTS_ALL ACC
WHERE '_BIS:ACC.ORG_ID' IS NOT NULL WITH READ ONLY
Columns
| Name |
| BANK_ACCOUNT_ID |
| BANK_ACCOUNT_NAME |
| ALTERNATE_BANK_ACCOUNT_NAME |
| BANK_ACCOUNT_NUMBER |
| BANK_ACCOUNT_TYPE |
| MULTICURRENCY_ALLOWED_FLAG |
| POOLED_ACCOUNT_FLAG |
| DESCRIPTION |
| MAXIMUM_PAYMENT_BATCH_OUTLAY |
| MINIMUM_PAYMENT_AMOUNT |
| MAXIMUM_PAYMENT_AMOUNT |
| ZERO_PAYMENTS_ALLOWED_FLAG |
| CONTACT_FIRST_NAME |
| CONTACT_MIDDLE_NAME |
| CONTACT_LAST_NAME |
| CONTACT_PREFIX |
| CONTACT_TITLE |
| CONTACT_AREA_CODE |
| CONTACT_PHONE |
| INACTIVE_DATE |
| ACCOUNT_HOLDER_NAME |
| ALTERNATE_ACCOUNT_HOLDER_NAME |
| EFT_USER_NUMBER |
| BANK_BRANCH_ID |
| CURRENCY_CODE |
| CREATION_DATE |
| CREATED_BY |
| LAST_UPDATE_DATE |
| LAST_UPDATED_BY |