Skip to content

DBA Data[Home] [Help] [Dependency Information]

VIEW: AP.AP_BANK_ACCOUNTS_ALL#

Object Details
Object Name: AP_BANK_ACCOUNTS_ALL#
Object Type: VIEW
Owner: AP
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
BANK_ACCOUNT_ID NUMBER (15) Yes
BANK_ACCOUNT_NAME VARCHAR2 (80) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_LOGIN NUMBER (15)
CREATION_DATE DATE

CREATED_BY VARCHAR2 (15)
BANK_ACCOUNT_NUM VARCHAR2 (30) Yes
BANK_BRANCH_ID NUMBER (15) Yes
SET_OF_BOOKS_ID NUMBER (15) Yes
CURRENCY_CODE VARCHAR2 (15)
DESCRIPTION VARCHAR2 (240)
CONTACT_FIRST_NAME VARCHAR2 (15)
CONTACT_MIDDLE_NAME VARCHAR2 (15)
CONTACT_LAST_NAME VARCHAR2 (20)
CONTACT_PREFIX VARCHAR2 (5)
CONTACT_TITLE VARCHAR2 (30)
CONTACT_AREA_CODE VARCHAR2 (10)
CONTACT_PHONE VARCHAR2 (15)
MAX_CHECK_AMOUNT NUMBER

MIN_CHECK_AMOUNT NUMBER

ONE_SIGNATURE_MAX_FLAG VARCHAR2 (1)
INACTIVE_DATE DATE

AVG_FLOAT_DAYS NUMBER (15)
ASSET_CODE_COMBINATION_ID NUMBER (15)
GAIN_CODE_COMBINATION_ID NUMBER (15)
LOSS_CODE_COMBINATION_ID NUMBER (15)
BANK_ACCOUNT_TYPE VARCHAR2 (25)
VALIDATION_NUMBER NUMBER (5)
MAX_OUTLAY NUMBER

MULTI_CURRENCY_FLAG VARCHAR2 (1) Yes
ACCOUNT_TYPE VARCHAR2 (25) Yes
ATTRIBUTE_CATEGORY VARCHAR2 (150)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
POOLED_FLAG VARCHAR2 (1)
ZERO_AMOUNTS_ALLOWED VARCHAR2 (1)
REQUEST_ID NUMBER (15)
PROGRAM_APPLICATION_ID NUMBER (15)
PROGRAM_ID NUMBER (15)
PROGRAM_UPDATE_DATE DATE

RECEIPT_MULTI_CURRENCY_FLAG VARCHAR2 (1)
CHECK_DIGITS VARCHAR2 (30)
ORG_ID NUMBER (15)
CASH_CLEARING_CCID NUMBER (15)
BANK_CHARGES_CCID NUMBER (15)
BANK_ERRORS_CCID NUMBER (15)
EARNED_CCID NUMBER (15)
UNEARNED_CCID NUMBER (15)
ON_ACCOUNT_CCID NUMBER (15)
UNAPPLIED_CCID NUMBER (15)
UNIDENTIFIED_CCID NUMBER (15)
FACTOR_CCID NUMBER (15)
RECEIPT_CLEARING_CCID NUMBER (15)
REMITTANCE_CCID NUMBER (15)
SHORT_TERM_DEPOSIT_CCID NUMBER (15)
GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 (150)
GLOBAL_ATTRIBUTE1 VARCHAR2 (150)
GLOBAL_ATTRIBUTE2 VARCHAR2 (150)
GLOBAL_ATTRIBUTE3 VARCHAR2 (150)
GLOBAL_ATTRIBUTE4 VARCHAR2 (150)
GLOBAL_ATTRIBUTE5 VARCHAR2 (150)
GLOBAL_ATTRIBUTE6 VARCHAR2 (150)
GLOBAL_ATTRIBUTE7 VARCHAR2 (150)
GLOBAL_ATTRIBUTE8 VARCHAR2 (150)
GLOBAL_ATTRIBUTE9 VARCHAR2 (150)
GLOBAL_ATTRIBUTE10 VARCHAR2 (150)
GLOBAL_ATTRIBUTE11 VARCHAR2 (150)
GLOBAL_ATTRIBUTE12 VARCHAR2 (150)
GLOBAL_ATTRIBUTE13 VARCHAR2 (150)
GLOBAL_ATTRIBUTE14 VARCHAR2 (150)
GLOBAL_ATTRIBUTE15 VARCHAR2 (150)
GLOBAL_ATTRIBUTE16 VARCHAR2 (150)
GLOBAL_ATTRIBUTE17 VARCHAR2 (150)
GLOBAL_ATTRIBUTE18 VARCHAR2 (150)
GLOBAL_ATTRIBUTE19 VARCHAR2 (150)
GLOBAL_ATTRIBUTE20 VARCHAR2 (150)
BANK_ACCOUNT_NAME_ALT VARCHAR2 (320)
ACCOUNT_HOLDER_NAME VARCHAR2 (240)
ACCOUNT_HOLDER_NAME_ALT VARCHAR2 (150)
EFT_REQUESTER_ID VARCHAR2 (25)
EFT_USER_NUMBER VARCHAR2 (30)
PAYROLL_BANK_ACCOUNT_ID NUMBER (9)
FUTURE_DATED_PAYMENT_CCID NUMBER (15)
EDISC_RECEIVABLES_TRX_ID NUMBER (15)
UNEDISC_RECEIVABLES_TRX_ID NUMBER (15)
BR_REMITTANCE_CCID NUMBER (15)
BR_FACTOR_CCID NUMBER (15)
BR_STD_RECEIVABLES_TRX_ID NUMBER (15)
ALLOW_MULTI_ASSIGNMENTS_FLAG VARCHAR2 (1)
AGENCY_LOCATION_CODE VARCHAR2 (30)
IBAN_NUMBER VARCHAR2 (40)
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT BANK_ACCOUNT_ID
,      BANK_ACCOUNT_NAME
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      BANK_ACCOUNT_NUM
,      BANK_BRANCH_ID
,      SET_OF_BOOKS_ID
,      CURRENCY_CODE
,      DESCRIPTION
,      CONTACT_FIRST_NAME
,      CONTACT_MIDDLE_NAME
,      CONTACT_LAST_NAME
,      CONTACT_PREFIX
,      CONTACT_TITLE
,      CONTACT_AREA_CODE
,      CONTACT_PHONE
,      MAX_CHECK_AMOUNT
,      MIN_CHECK_AMOUNT
,      ONE_SIGNATURE_MAX_FLAG
,      INACTIVE_DATE
,      AVG_FLOAT_DAYS
,      ASSET_CODE_COMBINATION_ID
,      GAIN_CODE_COMBINATION_ID
,      LOSS_CODE_COMBINATION_ID
,      BANK_ACCOUNT_TYPE
,      VALIDATION_NUMBER
,      MAX_OUTLAY
,      MULTI_CURRENCY_FLAG
,      ACCOUNT_TYPE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      POOLED_FLAG
,      ZERO_AMOUNTS_ALLOWED
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      RECEIPT_MULTI_CURRENCY_FLAG
,      CHECK_DIGITS
,      ORG_ID
,      CASH_CLEARING_CCID
,      BANK_CHARGES_CCID
,      BANK_ERRORS_CCID
,      EARNED_CCID
,      UNEARNED_CCID
,      ON_ACCOUNT_CCID
,      UNAPPLIED_CCID
,      UNIDENTIFIED_CCID
,      FACTOR_CCID
,      RECEIPT_CLEARING_CCID
,      REMITTANCE_CCID
,      SHORT_TERM_DEPOSIT_CCID
,      GLOBAL_ATTRIBUTE_CATEGORY
,      GLOBAL_ATTRIBUTE1
,      GLOBAL_ATTRIBUTE2
,      GLOBAL_ATTRIBUTE3
,      GLOBAL_ATTRIBUTE4
,      GLOBAL_ATTRIBUTE5
,      GLOBAL_ATTRIBUTE6
,      GLOBAL_ATTRIBUTE7
,      GLOBAL_ATTRIBUTE8
,      GLOBAL_ATTRIBUTE9
,      GLOBAL_ATTRIBUTE10
,      GLOBAL_ATTRIBUTE11
,      GLOBAL_ATTRIBUTE12
,      GLOBAL_ATTRIBUTE13
,      GLOBAL_ATTRIBUTE14
,      GLOBAL_ATTRIBUTE15
,      GLOBAL_ATTRIBUTE16
,      GLOBAL_ATTRIBUTE17
,      GLOBAL_ATTRIBUTE18
,      GLOBAL_ATTRIBUTE19
,      GLOBAL_ATTRIBUTE20
,      BANK_ACCOUNT_NAME_ALT
,      ACCOUNT_HOLDER_NAME
,      ACCOUNT_HOLDER_NAME_ALT
,      EFT_REQUESTER_ID
,      EFT_USER_NUMBER
,      PAYROLL_BANK_ACCOUNT_ID
,      FUTURE_DATED_PAYMENT_CCID
,      EDISC_RECEIVABLES_TRX_ID
,      UNEDISC_RECEIVABLES_TRX_ID
,      BR_REMITTANCE_CCID
,      BR_FACTOR_CCID
,      BR_STD_RECEIVABLES_TRX_ID
,      ALLOW_MULTI_ASSIGNMENTS_FLAG
,      AGENCY_LOCATION_CODE
,      IBAN_NUMBER
FROM AP.AP_BANK_ACCOUNTS_ALL#;

Dependencies

[top of page]

AP.AP_BANK_ACCOUNTS_ALL# references the following:

SchemaAP
TableAP_BANK_ACCOUNTS_ALL
AP.AP_BANK_ACCOUNTS_ALL# is referenced by following:

SchemaAPPS
SynonymAP_BANK_ACCOUNTS
SynonymAP_BANK_ACCOUNTS_ALL