[Home] [Help] [Dependency Information]
Object Name: | XTR_COMPANY_PARAMETERS |
---|---|
Object Type: | TABLE |
Owner: | XTR |
FND Design Data: | XTR.XTR_COMPANY_PARAMETERS |
Subobject Name: | |
Status: | VALID |
This table will store transactional parameters specific to each company. There are currently three existing parameters and eight new ones which will be added to this table. The code that
represents the parameter and their corresponding values can be found in the QuickCodes Columns section.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
XTR_COMPANY_PARAMETERS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
COMPANY_CODE
PARAMETER_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
COMPANY_PARAMETER_ID | NUMBER | (15) | Yes | Unique identifier for each row of company parameter data. |
COMPANY_CODE | VARCHAR2 | (7) | Yes | Specifies which company this data belongs to. |
PARAMETER_CODE | VARCHAR2 | (30) | Yes | A code that identifies the parameter value. |
PARAMETER_VALUE_CODE | VARCHAR2 | (30) | A code that identifies the parameter value. | |
PARAMETER_VALUE | VARCHAR2 | (240) | The parameter value. This column is used when the parameters are not seeded but are entered by the user, e.g. Subscriber FX Match ID. | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who Column. |
CREATION_DATE | DATE | Yes | Standard Who Column. | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who Column. |
LAST_UPDATE_DATE | DATE | Yes | Standard Who Column. | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who Column. |
Cut, paste (and edit) the following text to query this object:
SELECT COMPANY_PARAMETER_ID
, COMPANY_CODE
, PARAMETER_CODE
, PARAMETER_VALUE_CODE
, PARAMETER_VALUE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM XTR.XTR_COMPANY_PARAMETERS;
XTR.XTR_COMPANY_PARAMETERS does not reference any database object
XTR.XTR_COMPANY_PARAMETERS is referenced by following:
|
|
|