Skip to content

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

VIEW: POS.POS_BANK_ACCOUNT_DET_INT#

Object Details
Object Name: POS_BANK_ACCOUNT_DET_INT#
Object Type: VIEW
Owner: POS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
BANK_ACCOUNT_INTERFACE_ID NUMBER
Yes
PAYEE_NAME VARCHAR2 (100)
PAYEE_PARTY_ID NUMBER

PAYEE_SITE_NAME VARCHAR2 (100)
PARTY_SITE_ID NUMBER

OGANIZATION_NAME VARCHAR2 (40)
ORG_ID NUMBER

SUPPLIER_SITE_NAME VARCHAR2 (100)
SUPPLIER_SITE_ID NUMBER

COUNTRY_CODE VARCHAR2 (50)
ALLOW_INTERNATIONAL_PAYMENTS VARCHAR2 (50)
BATCH_ID NUMBER

SOURCE_SYSTEM VARCHAR2 (100)
SOURCE_SYSTEM_REFERENCE VARCHAR2 (100)
PAYMENT_FACTOR_FLAG VARCHAR2 (1)
BANK_NAME VARCHAR2 (100)
BANK_NUMBER VARCHAR2 (100)
BANK_ID NUMBER

BRANCH_NAME VARCHAR2 (100)
BRANCH_NUMBER VARCHAR2 (100)
BRANCH_ID NUMBER

BIC VARCHAR2 (100)
BRANCH_TYPE VARCHAR2 (100)
BANK_INST_TYPE VARCHAR2 (100)
ALT_BANK_NAME VARCHAR2 (100)
BANK_DESCRIPTION VARCHAR2 (1000)
BANK_END_DATE DATE

BANK_ADDRESS_LINE1 VARCHAR2 (1000)
BANK_ADDRESS_LINE2 VARCHAR2 (1000)
BANK_ADDRESS_LINE3 VARCHAR2 (1000)
BANK_CITY VARCHAR2 (100)
BANK_STATE VARCHAR2 (100)
BANK_ZIP VARCHAR2 (40)
ALT_BRANCH_NAME VARCHAR2 (100)
BRANCH_DESCRIPTION VARCHAR2 (1000)
BRANCH_RFC_IDENTIFIER VARCHAR2 (1000)
BRANCH_END_DATE DATE

BRANCH_ADDRESS_LINE1 VARCHAR2 (1000)
BRANCH_ADDRESS_LINE2 VARCHAR2 (1000)
BRANCH_ADDRESS_LINE3 VARCHAR2 (1000)
BRANCH_CITY VARCHAR2 (100)
BRANCH_STATE VARCHAR2 (100)
BRANCH_ZIP VARCHAR2 (50)
BANK_ACCOUNT_NUMBER VARCHAR2 (100)
BANK_ACCOUNT_ID NUMBER

CHECK_DIGITS VARCHAR2 (100)
IBAN VARCHAR2 (100)
ACCOUNT_NAME VARCHAR2 (100)
ACCOUNT_CURRENCY_CODE VARCHAR2 (40)
ALT_ACCOUNT_NAME VARCHAR2 (100)
ACCOUNT_SUFFIX VARCHAR2 (50)
EXCHANGE_RATE_AGREEMENT_TYPE VARCHAR2 (100)
EXCHANGE_RATE NUMBER

AGENCY_LOCATION_CODE VARCHAR2 (50)
ACCOUNT_START_DATE DATE

ACCOUNT_TYPE VARCHAR2 (100)
SEC_ACCOUNT_REF VARCHAR2 (100)
EXCHANGE_RATE_AGREEMENT_NUM VARCHAR2 (100)
ACCOUNT_DESCRIPTION VARCHAR2 (1000)
ACCOUNT_END_DATE DATE

FOREIGN_PAYMENT_USE_FLAG VARCHAR2 (10)
INTER_ACCOUNT1_COUNTRY_CODE VARCHAR2 (50)
INTER_ACCOUNT1_BANK_NAME VARCHAR2 (100)
INTER_ACCOUNT1_BRANCH_NUMBER VARCHAR2 (100)
INTER_ACCOUNT1_NUMBER VARCHAR2 (100)
INTER_ACCOUNT1_IBAN VARCHAR2 (100)
INTER_ACCOUNT1_CITY VARCHAR2 (100)
INTER_ACCOUNT1_BANK_CODE VARCHAR2 (40)
INTER_ACCOUNT1_BIC VARCHAR2 (40)
INTER_ACCOUNT1_CHECK_DIGITS VARCHAR2 (40)
INTER_ACCOUNT1_COMMENTS VARCHAR2 (100)
INTER_ACCOUNT2_COUNTRY_CODE VARCHAR2 (40)
INTER_ACCOUNT2_BANK_NAME VARCHAR2 (100)
INTER_ACCOUNT2_BRANCH_NUMBER VARCHAR2 (100)
INTER_ACCOUNT2_NUMBER VARCHAR2 (100)
INTER_ACCOUNT2_IBAN VARCHAR2 (100)
INTER_ACCOUNT2_CITY VARCHAR2 (100)
INTER_ACCOUNT2_BANK_CODE VARCHAR2 (50)
INTER_ACCOUNT2_BIC VARCHAR2 (100)
INTER_ACCOUNT2_CHECK_DIGITS VARCHAR2 (40)
INTER_ACCOUNT2_COMMENTS VARCHAR2 (100)
CREATION_DATE DATE

CREATED_BY NUMBER

LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER

LAST_UPDATE_LOGIN NUMBER

REQUEST_ID NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

INTERFACE_STATUS VARCHAR2 (50)
PARTY_SITE_ORIG_SYS VARCHAR2 (100)
PARTY_SITE_ORIG_SYS_REF VARCHAR2 (100)
PARTY_SITE_NAME VARCHAR2 (100)
VENDOR_SITE_CODE VARCHAR2 (100)
INSERT_UPDATE_FLAG VARCHAR2 (10)
PARTY_ID NUMBER

Query Text

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


SELECT BANK_ACCOUNT_INTERFACE_ID
,      PAYEE_NAME
,      PAYEE_PARTY_ID
,      PAYEE_SITE_NAME
,      PARTY_SITE_ID
,      OGANIZATION_NAME
,      ORG_ID
,      SUPPLIER_SITE_NAME
,      SUPPLIER_SITE_ID
,      COUNTRY_CODE
,      ALLOW_INTERNATIONAL_PAYMENTS
,      BATCH_ID
,      SOURCE_SYSTEM
,      SOURCE_SYSTEM_REFERENCE
,      PAYMENT_FACTOR_FLAG
,      BANK_NAME
,      BANK_NUMBER
,      BANK_ID
,      BRANCH_NAME
,      BRANCH_NUMBER
,      BRANCH_ID
,      BIC
,      BRANCH_TYPE
,      BANK_INST_TYPE
,      ALT_BANK_NAME
,      BANK_DESCRIPTION
,      BANK_END_DATE
,      BANK_ADDRESS_LINE1
,      BANK_ADDRESS_LINE2
,      BANK_ADDRESS_LINE3
,      BANK_CITY
,      BANK_STATE
,      BANK_ZIP
,      ALT_BRANCH_NAME
,      BRANCH_DESCRIPTION
,      BRANCH_RFC_IDENTIFIER
,      BRANCH_END_DATE
,      BRANCH_ADDRESS_LINE1
,      BRANCH_ADDRESS_LINE2
,      BRANCH_ADDRESS_LINE3
,      BRANCH_CITY
,      BRANCH_STATE
,      BRANCH_ZIP
,      BANK_ACCOUNT_NUMBER
,      BANK_ACCOUNT_ID
,      CHECK_DIGITS
,      IBAN
,      ACCOUNT_NAME
,      ACCOUNT_CURRENCY_CODE
,      ALT_ACCOUNT_NAME
,      ACCOUNT_SUFFIX
,      EXCHANGE_RATE_AGREEMENT_TYPE
,      EXCHANGE_RATE
,      AGENCY_LOCATION_CODE
,      ACCOUNT_START_DATE
,      ACCOUNT_TYPE
,      SEC_ACCOUNT_REF
,      EXCHANGE_RATE_AGREEMENT_NUM
,      ACCOUNT_DESCRIPTION
,      ACCOUNT_END_DATE
,      FOREIGN_PAYMENT_USE_FLAG
,      INTER_ACCOUNT1_COUNTRY_CODE
,      INTER_ACCOUNT1_BANK_NAME
,      INTER_ACCOUNT1_BRANCH_NUMBER
,      INTER_ACCOUNT1_NUMBER
,      INTER_ACCOUNT1_IBAN
,      INTER_ACCOUNT1_CITY
,      INTER_ACCOUNT1_BANK_CODE
,      INTER_ACCOUNT1_BIC
,      INTER_ACCOUNT1_CHECK_DIGITS
,      INTER_ACCOUNT1_COMMENTS
,      INTER_ACCOUNT2_COUNTRY_CODE
,      INTER_ACCOUNT2_BANK_NAME
,      INTER_ACCOUNT2_BRANCH_NUMBER
,      INTER_ACCOUNT2_NUMBER
,      INTER_ACCOUNT2_IBAN
,      INTER_ACCOUNT2_CITY
,      INTER_ACCOUNT2_BANK_CODE
,      INTER_ACCOUNT2_BIC
,      INTER_ACCOUNT2_CHECK_DIGITS
,      INTER_ACCOUNT2_COMMENTS
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      INTERFACE_STATUS
,      PARTY_SITE_ORIG_SYS
,      PARTY_SITE_ORIG_SYS_REF
,      PARTY_SITE_NAME
,      VENDOR_SITE_CODE
,      INSERT_UPDATE_FLAG
,      PARTY_ID
FROM POS.POS_BANK_ACCOUNT_DET_INT#;

Dependencies

[top of page]

POS.POS_BANK_ACCOUNT_DET_INT# references the following:

SchemaPOS
TablePOS_BANK_ACCOUNT_DET_INT
POS.POS_BANK_ACCOUNT_DET_INT# is referenced by following:

SchemaAPPS
SynonymPOS_BANK_ACCOUNT_DET_INT