[Home] [Help] [Dependency Information]
Object Name: | FV_TP_TREASURY_SYMBOLS |
---|---|
Object Type: | TABLE |
Owner: | FV |
FND Design Data: | FV.FV_TP_TREASURY_SYMBOLS |
Subobject Name: | |
Status: | VALID |
Table to store Trading Partner Treasury Account Symbols
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
FV_TP_TREASURY_SYMBOL_COMB_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
SUB_LEVEL_PREFIX_CODE
DEPT_TRANSFER AGENCY_ID ESTABLISHED_FISCAL_YR END_YEAR_AVAIL AVAILABILITY_TYPE_CODE MAIN_ACCT_CODE SUB_ACCT_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TREASURY_SYMBOL | VARCHAR2 | (35) | Yes | Treasury Symbol value |
SUB_LEVEL_PREFIX_CODE | VARCHAR2 | (2) | Sublevel Prefix Code | |
DEPT_TRANSFER | VARCHAR2 | (3) | Allocation Transfer Agency Identifier | |
AGENCY_ID | VARCHAR2 | (3) | Yes | Unique Agency Identifier used to represent FPA |
ESTABLISHED_FISCAL_YR | NUMBER | (15) | Beginning Period of Availability | |
END_YEAR_AVAIL | NUMBER | (15) | Ending Period of Availability | |
AVAILABILITY_TYPE_CODE | VARCHAR2 | (1) | Availability Type Code | |
MAIN_ACCT_CODE | VARCHAR2 | (4) | Yes | Main Account Code |
SUB_ACCT_CODE | VARCHAR2 | (3) | Yes | Sub-Account Code |
CREATED_BY | NUMBER | (15) | Yes | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
CREATION_DATE | DATE | Yes | Standard who column - date when this row was created. | |
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). |
LAST_UPDATE_LOGIN | NUMBER | (15) | Yes | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
AUTHORITY_DURATION_CODE | VARCHAR2 | (1) | Yes | Indicates validity period of a trading partner Treasury Account Symbol |
AUTO_CREATE_FLAG#1 | VARCHAR2 | (1) | ||
FEDERAL_ACCT_SYMBOL_NAME | VARCHAR2 | (125) | Federal Account Symbol Name | |
TREASURY_SYMBOL_ID | NUMBER | (15) | Treasury symbol identifier | |
SET_OF_BOOKS_ID | NUMBER | (15) | Ledger ID | |
ORG_ID | NUMBER | (15) | Organization identifier | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flex Field segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flex Field segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flex Field segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flex Field segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flex Field segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flex Field segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flex Field segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flex Field segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flex Field segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flex Field segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flex Field segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flex Field segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flex Field segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flex Field segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flex Field segment | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flex Field structure definition column | |
START_DATE | DATE | Start Date | ||
END_DATE | DATE | End Date | ||
AUTO_CREATE_FLAG_BETC | VARCHAR2 | (1) | Indicates if BETCs associated with the Trading partner TAS can be autocreated |
Cut, paste (and edit) the following text to query this object:
SELECT TREASURY_SYMBOL
, SUB_LEVEL_PREFIX_CODE
, DEPT_TRANSFER
, AGENCY_ID
, ESTABLISHED_FISCAL_YR
, END_YEAR_AVAIL
, AVAILABILITY_TYPE_CODE
, MAIN_ACCT_CODE
, SUB_ACCT_CODE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, AUTHORITY_DURATION_CODE
, AUTO_CREATE_FLAG#1
, FEDERAL_ACCT_SYMBOL_NAME
, TREASURY_SYMBOL_ID
, SET_OF_BOOKS_ID
, ORG_ID
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE_CATEGORY
, START_DATE
, END_DATE
, AUTO_CREATE_FLAG_BETC
FROM FV.FV_TP_TREASURY_SYMBOLS;
FV.FV_TP_TREASURY_SYMBOLS does not reference any database object
FV.FV_TP_TREASURY_SYMBOLS is referenced by following:
|
|
|