[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PAY_EXTERNAL_ACCOUNTS |
|---|---|
| Object Type: | TABLE |
| Owner: | HR |
| FND Design Data: |  PAY.PAY_EXTERNAL_ACCOUNTS
|
| Subobject Name: | |
| Status: | VALID |
PAY_EXTERNAL_ACCOUNTS stores bank account information to enable
payments to people. It includes source account details, payment
methods and destination accounts.
NOTE: This table holds information used in the Bank Details protected
key flexfield. Localization teams are responsible for setting up
this flexfield for use under their legislation code. Users
cannot change this flexfield structure.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
EXTERNAL_ACCOUNT_ID| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| PAY_EXTERNAL_ACCOUNTS_PK | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
EXTERNAL_ACCOUNT_ID
|
| Table | |
Foreign Table | Foreign Key Column |
PAY_ORG_PAYMENT_METHODS_F
|
 |
PAY_EXTERNAL_ACCOUNTS | PAY_ORG_PAYMENT_METHODS_F EXTERNAL_ACCOUNT_ID |
PAY_PERSONAL_PAYMENT_METHODS_F
|
|
PAY_EXTERNAL_ACCOUNTS | PAY_PERSONAL_PAYMENT_METHODS_F EXTERNAL_ACCOUNT_ID |
PAY_PSS_TRANSACTION_STEPS
|
|
PAY_EXTERNAL_ACCOUNTS | PAY_PSS_TRANSACTION_STEPS EXTERNAL_ACCOUNT_ID |
PAY_PSS_TRANSACTION_STEPS
|
|
PAY_EXTERNAL_ACCOUNTS | PAY_PSS_TRANSACTION_STEPS O_EXTERNAL_ACCOUNT_ID |
|---|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| EXTERNAL_ACCOUNT_ID | NUMBER | (9) | Yes | System-generated primary key column. |
| TERRITORY_CODE | VARCHAR2 | (2) | Foreign key to FND_TERRITORIES. | |
| PRENOTE_DATE | DATE | Date on which a prenote for this account was sent. | ||
| ID_FLEX_NUM | NUMBER | (15) | Yes | Key flexfield structure foreign key. |
| SUMMARY_FLAG | VARCHAR2 | (1) | Yes | Key flexfield summary flag. |
| ENABLED_FLAG | VARCHAR2 | (1) | Yes | Key flexfield enabled flag. |
| START_DATE_ACTIVE | DATE | Date before which key flexfield combination is invalid. | ||
| END_DATE_ACTIVE | DATE | Date after which key flexfield combination is invalid. | ||
| SEGMENT1 | VARCHAR2 | (150) | Key flexfield segment | |
| SEGMENT2 | VARCHAR2 | (150) | Key flexfield segment | |
| SEGMENT3 | VARCHAR2 | (150) | Key flexfield segment | |
| SEGMENT4 | VARCHAR2 | (150) | Key flexfield segment | |
| SEGMENT5 | VARCHAR2 | (150) | Key flexfield segment | |
| SEGMENT6 | VARCHAR2 | (150) | Key flexfield segment | |
| SEGMENT7 | VARCHAR2 | (150) | Key flexfield segment | |
| SEGMENT8 | VARCHAR2 | (150) | Key flexfield segment | |
| SEGMENT9 | VARCHAR2 | (150) | Key flexfield segment | |
| SEGMENT10 | VARCHAR2 | (150) | Key flexfield segment | |
| SEGMENT11 | VARCHAR2 | (150) | Key flexfield segment | |
| SEGMENT12 | VARCHAR2 | (150) | Key flexfield segment | |
| SEGMENT13 | VARCHAR2 | (150) | Key flexfield segment | |
| SEGMENT14 | VARCHAR2 | (150) | Key flexfield segment | |
| SEGMENT15 | VARCHAR2 | (150) | Key flexfield segment | |
| SEGMENT16 | VARCHAR2 | (150) | Key flexfield segment | |
| SEGMENT17 | VARCHAR2 | (150) | Key flexfield segment | |
| SEGMENT18 | VARCHAR2 | (150) | Key flexfield segment | |
| SEGMENT19 | VARCHAR2 | (150) | Key flexfield segment | |
| SEGMENT20 | VARCHAR2 | (150) | Key flexfield segment | |
| SEGMENT21 | VARCHAR2 | (150) | Key flexfield segment column. | |
| SEGMENT22 | VARCHAR2 | (150) | Key flexfield segment column. | |
| SEGMENT23 | VARCHAR2 | (150) | Key flexfield segment column. | |
| SEGMENT24 | VARCHAR2 | (150) | Key flexfield segment column. | |
| SEGMENT25 | VARCHAR2 | (150) | Key flexfield segment column. | |
| SEGMENT26 | VARCHAR2 | (150) | Key flexfield segment column. | |
| SEGMENT27 | VARCHAR2 | (150) | Key flexfield segment column. | |
| SEGMENT28 | VARCHAR2 | (150) | Key flexfield segment column. | |
| SEGMENT29 | VARCHAR2 | (150) | Key flexfield segment column. | |
| SEGMENT30 | VARCHAR2 | (150) | Key flexfield segment column. | |
| LAST_UPDATE_DATE | DATE | Standard Who column - date when a user last updated this row. | ||
| LAST_UPDATED_BY | NUMBER | (15) | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
| 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). | |
| CREATED_BY | NUMBER | (15) | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
| CREATION_DATE | DATE | Standard who column - date when this row was created. | ||
| OBJECT_VERSION_NUMBER | NUMBER | (9) | System-generated version of row. Increments by one with each update. |
Cut, paste (and edit) the following text to query this object:
SELECT EXTERNAL_ACCOUNT_ID
, TERRITORY_CODE
, PRENOTE_DATE
, ID_FLEX_NUM
, SUMMARY_FLAG
, ENABLED_FLAG
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, SEGMENT1
, SEGMENT2
, SEGMENT3
, SEGMENT4
, SEGMENT5
, SEGMENT6
, SEGMENT7
, SEGMENT8
, SEGMENT9
, SEGMENT10
, SEGMENT11
, SEGMENT12
, SEGMENT13
, SEGMENT14
, SEGMENT15
, SEGMENT16
, SEGMENT17
, SEGMENT18
, SEGMENT19
, SEGMENT20
, SEGMENT21
, SEGMENT22
, SEGMENT23
, SEGMENT24
, SEGMENT25
, SEGMENT26
, SEGMENT27
, SEGMENT28
, SEGMENT29
, SEGMENT30
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, OBJECT_VERSION_NUMBER
FROM HR.PAY_EXTERNAL_ACCOUNTS;
HR.PAY_EXTERNAL_ACCOUNTS does not reference any database object
HR.PAY_EXTERNAL_ACCOUNTS is referenced by following:
HR
PAY_EXTERNAL_ACCOUNTS#
|
|
|
|