[Home] [Help] [Dependency Information]
Object Name: | XTR_AMOUNT_TYPES |
---|---|
Object Type: | TABLE |
Owner: | XTR |
FND Design Data: | XTR.XTR_AMOUNT_TYPES |
Subobject Name: | |
Status: | VALID |
XTR_AMOUNT_TYPES contains the amount types for deal types. The amount types for retail term money deals are user-defined while the other deal types are pre-defined. Each row in this table corresponds to an amount type. Several amount types can be defined for a given deal type.
Along with date types and amount actions, amount types help define the journals structure. Oracle Treasury derives the amount types in XTR_DEAL_DATE_AMOUNTS from this table.
This table corresponds to the Amounts region in the Amount Types tab region in the Deal Types / Product Types / Deal Subtypes window.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
XTR_AMOUNT_TYPES_U1 | NORMAL | UNIQUE | APPS_TS_SEED |
AMOUNT_TYPE
DEAL_TYPE |
XTR_AMOUNT_TYPES_U2 | NORMAL | UNIQUE | APPS_TS_SEED |
DEAL_TYPE
USER_AMOUNT_TYPE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
AMOUNT_NAME | VARCHAR2 | (80) | Yes | Amount type name |
AMOUNT_TYPE | VARCHAR2 | (7) | Yes | Code that identifies the purpose of the amounts for a deal type |
USER_AMOUNT_TYPE | VARCHAR2 | (7) | Yes | User-defined amount type code |
DEAL_TYPE | VARCHAR2 | (7) | Yes | Code for high level deals |
SEEDED_DESCRIPTION | VARCHAR2 | (80) | Yes | Pre-defined amount type description |
JOURNAL_USE | VARCHAR2 | (1) | Yes | Flag to indicate whether you can create journal with the amount type (Y), or not (N) |
UPDATED_BY | VARCHAR2 | (30) | User who last updated this record |
Cut, paste (and edit) the following text to query this object:
SELECT AMOUNT_NAME
, AMOUNT_TYPE
, USER_AMOUNT_TYPE
, DEAL_TYPE
, SEEDED_DESCRIPTION
, JOURNAL_USE
, UPDATED_BY
FROM XTR.XTR_AMOUNT_TYPES;
XTR.XTR_AMOUNT_TYPES does not reference any database object
XTR.XTR_AMOUNT_TYPES is referenced by following:
|
|
|