[Home] [Help]
[Dependency Information]
Object Name: | XTR_DATE_AMOUNT_TYPES |
---|---|
Object Type: | TABLE |
Owner: | XTR |
FND Design Data: | ![]() |
Subobject Name: | |
Status: | VALID |
XTR_DATE_AMOUNT_TYPES contains pre-defined date amount type combinations for deal types. Each row corresponds to a date amount type and whether or not it will appear on maturity reports.
Tablespace: | ![]() |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
XTR_DATE_AMOUNT_TYPES_U1 | NORMAL | UNIQUE |
![]() |
![]() ![]() ![]() ![]() |
XTR_DATE_AMOUNT_TYPES_N1 | NORMAL | NONUNIQUE |
![]() |
![]() ![]() |
XTR_DATE_AMOUNT_TYPES_N2 | NORMAL | NONUNIQUE |
![]() |
![]() ![]() |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
AMOUNT_TYPE | VARCHAR2 | (7) | Yes | Code that identifies the purpose of the amounts for a deal type |
CASHFLOW_REPORT | VARCHAR2 | (1) | Not currently used | |
DATE_TYPE | VARCHAR2 | (7) | Yes | Date type tied to specific deal types (for example, accrual, maturity, start, and dealt dates) |
DEAL_TYPE | VARCHAR2 | (7) | Yes | Code for high level deals |
MATURITY_REPORT | VARCHAR2 | (1) | Flag to indicate if the date amount type will be included in maturity reports (Y), or not (N) | |
PAY_RECEIVE_REPORT | VARCHAR2 | (1) | Not currently used | |
ZD_EDITION_NAME | VARCHAR2 | (30) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT AMOUNT_TYPE
, CASHFLOW_REPORT
, DATE_TYPE
, DEAL_TYPE
, MATURITY_REPORT
, PAY_RECEIVE_REPORT
, ZD_EDITION_NAME
FROM XTR.XTR_DATE_AMOUNT_TYPES;
XTR.XTR_DATE_AMOUNT_TYPES does not reference any database object
XTR.XTR_DATE_AMOUNT_TYPES is referenced by following:
|
|
|