[Home] [Help] [Dependency Information]
Object Name: | AP_BANK_BRANCHES |
---|---|
Object Type: | TABLE |
Owner: | AP |
FND Design Data: | SQLAP.AP_BANK_BRANCHES |
Subobject Name: | |
Status: | VALID |
AP_BANK_BRANCHES contains information about the bank branches you define when you set up your banks. You need one row for each bank branch you use. One bank branch may have multiple bank accounts.
This table corresponds to the Bank Branch region of the Banks window.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
AP_BANK_BRANCHES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | BANK_BRANCH_ID |
AP_BANK_BRANCHES_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
BANK_NAME
BANK_BRANCH_NAME |
AP_BANK_BRANCHES_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | CLEARING_HOUSE_ID |
AP_BANK_BRANCHES_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | EDI_ID_NUMBER |
AP_BANK_BRANCHES_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
BANK_NUM
BANK_NUMBER COUNTRY |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BANK_BRANCH_ID | NUMBER | (15) | Yes | Bank branch identifier |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
BANK_NAME | VARCHAR2 | (60) | Yes | Bank name |
BANK_BRANCH_NAME | VARCHAR2 | (60) | Yes | Bank branch name |
DESCRIPTION | VARCHAR2 | (240) | Description | |
ADDRESS_LINE1 | VARCHAR2 | (35) | First address line | |
ADDRESS_LINE2 | VARCHAR2 | (35) | Second address line | |
ADDRESS_LINE3 | VARCHAR2 | (35) | Third address line | |
CITY | VARCHAR2 | (25) | City | |
STATE | VARCHAR2 | (25) | State or province | |
ZIP | VARCHAR2 | (20) | Zip code | |
PROVINCE | VARCHAR2 | (25) | No longer used | |
COUNTRY | VARCHAR2 | (25) | Country | |
AREA_CODE | VARCHAR2 | (10) | Area code | |
PHONE | VARCHAR2 | (15) | Phone number | |
CONTACT_FIRST_NAME | VARCHAR2 | (15) | First name of branch contact person | |
CONTACT_MIDDLE_NAME | VARCHAR2 | (15) | Middle name of branch contact person | |
CONTACT_LAST_NAME | VARCHAR2 | (20) | Last name of branch contact person | |
CONTACT_PREFIX | VARCHAR2 | (5) | Prefix of branch contact person (Ms., Mr., Mrs., Miss, etc.) | |
CONTACT_TITLE | VARCHAR2 | (30) | Title of branch contact person | |
BANK_NUM | VARCHAR2 | (25) | Branch number | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
CREATION_DATE | DATE | Standard who column - date when this row was created. | ||
CREATED_BY | NUMBER | (15) | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
INSTITUTION_TYPE | VARCHAR2 | (25) | Yes | Not used by Oracle Payables applications |
CLEARING_HOUSE_ID | NUMBER | Not used by Oracle Payables applications | ||
TRANSMISSION_PROGRAM_ID | NUMBER | Not used by Oracle Payables applications | ||
PRINTING_PROGRAM_ID | NUMBER | Not used by Oracle Payables applications | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | Descriptive flexfield structure definition column. | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
REQUEST_ID | NUMBER | (15) | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). | |
PROGRAM_APPLICATION_ID | NUMBER | (15) | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). | |
PROGRAM_ID | NUMBER | (15) | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). | |
PROGRAM_UPDATE_DATE | DATE | Concurrent Program who column - date when a program last updated this row). | ||
ADDRESS_STYLE | VARCHAR2 | (30) | Used as context field for FAF desc flex. Do not populate. Join with FND_TERRITORIES where COUNTRY=TERRITORY_CODE | |
BANK_NUMBER | VARCHAR2 | (30) | Bank number. Added for Flexible Bank Structure functionality. Holds the number used by some countries to identify bank | |
ADDRESS_LINE4 | VARCHAR2 | (35) | Fourth address line. Used for flexible address formatting | |
COUNTY | VARCHAR2 | (25) | Added for Flexible Address Format functionality | |
EFT_USER_NUMBER | VARCHAR2 | (30) | The number that identifies you as a user of electronic funds transfer services to your bank or clearing organization | |
EFT_SWIFT_CODE | VARCHAR2 | (12) | EFT swift code | |
END_DATE | DATE | End date | ||
EDI_ID_NUMBER | VARCHAR2 | (30) | EDI trading partner number for the Bank Branch | |
BANK_BRANCH_TYPE | VARCHAR2 | (25) | Branch type indicates which list the bank routing number is on. Valid types are ABA, CHIPS, SWIFT and OTHER | |
GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | Reserved for country-specific functionality | |
GLOBAL_ATTRIBUTE1 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
GLOBAL_ATTRIBUTE2 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
GLOBAL_ATTRIBUTE3 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
GLOBAL_ATTRIBUTE4 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
GLOBAL_ATTRIBUTE5 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
GLOBAL_ATTRIBUTE6 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
GLOBAL_ATTRIBUTE7 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
GLOBAL_ATTRIBUTE8 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
GLOBAL_ATTRIBUTE9 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
GLOBAL_ATTRIBUTE10 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
GLOBAL_ATTRIBUTE11 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
GLOBAL_ATTRIBUTE12 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
GLOBAL_ATTRIBUTE13 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
GLOBAL_ATTRIBUTE14 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
GLOBAL_ATTRIBUTE15 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
GLOBAL_ATTRIBUTE16 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
GLOBAL_ATTRIBUTE17 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
GLOBAL_ATTRIBUTE18 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
GLOBAL_ATTRIBUTE19 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
GLOBAL_ATTRIBUTE20 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
BANK_NAME_ALT | VARCHAR2 | (320) | Alternate bank name | |
BANK_BRANCH_NAME_ALT | VARCHAR2 | (320) | Alternate bank branch name | |
ADDRESS_LINES_ALT | VARCHAR2 | (560) | Alternate address lines | |
ACTIVE_DATE | DATE | Active date | ||
TP_HEADER_ID | NUMBER | (15) | Trading partner header identifier | |
ECE_TP_LOCATION_CODE | VARCHAR2 | (60) | Trading partner location code | |
PAYROLL_BANK_ACCOUNT_ID | NUMBER | (9) | Bank account identifier for payroll bank accounts | |
RFC_IDENTIFIER | VARCHAR2 | (15) | Regional Finance Center Identifier used only to identify a branch of the United States Treasury bank. | |
BANK_ADMIN_EMAIL | VARCHAR2 | (255) | E-mail address for XML messages administrator at the bank |
Cut, paste (and edit) the following text to query this object:
SELECT BANK_BRANCH_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, BANK_NAME
, BANK_BRANCH_NAME
, DESCRIPTION
, ADDRESS_LINE1
, ADDRESS_LINE2
, ADDRESS_LINE3
, CITY
, STATE
, ZIP
, PROVINCE
, COUNTRY
, AREA_CODE
, PHONE
, CONTACT_FIRST_NAME
, CONTACT_MIDDLE_NAME
, CONTACT_LAST_NAME
, CONTACT_PREFIX
, CONTACT_TITLE
, BANK_NUM
, LAST_UPDATE_LOGIN
, CREATION_DATE
, CREATED_BY
, INSTITUTION_TYPE
, CLEARING_HOUSE_ID
, TRANSMISSION_PROGRAM_ID
, PRINTING_PROGRAM_ID
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, ADDRESS_STYLE
, BANK_NUMBER
, ADDRESS_LINE4
, COUNTY
, EFT_USER_NUMBER
, EFT_SWIFT_CODE
, END_DATE
, EDI_ID_NUMBER
, BANK_BRANCH_TYPE
, 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_NAME_ALT
, BANK_BRANCH_NAME_ALT
, ADDRESS_LINES_ALT
, ACTIVE_DATE
, TP_HEADER_ID
, ECE_TP_LOCATION_CODE
, PAYROLL_BANK_ACCOUNT_ID
, RFC_IDENTIFIER
, BANK_ADMIN_EMAIL
FROM AP.AP_BANK_BRANCHES;
AP.AP_BANK_BRANCHES does not reference any database object
AP.AP_BANK_BRANCHES is referenced by following:
|
|
|