[Home] [Help] [Dependency Information]
Object Name: | XTR_HOLIDAY_RULES |
---|---|
Object Type: | TABLE |
Owner: | XTR |
FND Design Data: | XTR.XTR_HOLIDAY_RULES |
Subobject Name: | |
Status: | VALID |
XTR_HOLIDAY_RULES stores information about rules for calculating holidays for each currency. Each row corresponds to a holiday rule for a currency. You can enter constant dates or define rules to generate a holiday schedule. Treasury stores this set of holiday dates in the XTR_HOLIDAYS table.
This table corresponds to the Currency Holiday Rules window.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CALCULATED_OUT_TO | DATE | Date to which a holiday rule is calculated out | ||
CURRENCY | VARCHAR2 | (15) | Yes | Currency code |
DAY_RULE | VARCHAR2 | (3) | Day of the week of the holiday | |
EXTRA_HOLIDAY_DAYS | NUMBER | Number of additional days that the holiday is observed | ||
HOLIDAY_DAY | NUMBER | Date of the month of the holiday | ||
HOLIDAY_DESC | VARCHAR2 | (20) | Yes | Holiday description |
HOLIDAY_MONTH | VARCHAR2 | (3) | Yes | Month of the holiday |
HOLIDAY_RULE | NUMBER | Week of the month for the holiday | ||
HOLIDAY_TYPE | VARCHAR2 | (1) | Yes | Type of holiday (Rule, One off, or Constant) |
HOLIDAY_YEAR | NUMBER | Year of the holiday | ||
HOL_SEQ | NUMBER | Yes | Holiday rule identifier | |
WEEKEND_ADJ | VARCHAR2 | (3) | Day of the week to adjust the holiday if it occurs on a weekend |
Cut, paste (and edit) the following text to query this object:
SELECT CALCULATED_OUT_TO
, CURRENCY
, DAY_RULE
, EXTRA_HOLIDAY_DAYS
, HOLIDAY_DAY
, HOLIDAY_DESC
, HOLIDAY_MONTH
, HOLIDAY_RULE
, HOLIDAY_TYPE
, HOLIDAY_YEAR
, HOL_SEQ
, WEEKEND_ADJ
FROM XTR.XTR_HOLIDAY_RULES;
XTR.XTR_HOLIDAY_RULES does not reference any database object
XTR.XTR_HOLIDAY_RULES is referenced by following:
|
|
|