[Home] [Help] [Dependency Information]
Object Name: | PAY_TAXABILITY_RULES_DATES |
---|---|
Object Type: | TABLE |
Owner: | HR |
FND Design Data: | PAY.PAY_TAXABILITY_RULES_DATES |
Subobject Name: | |
Status: | VALID |
PAY_TAXABILITY_RULES_DATES is used to maintain taxability rules
date-effectively.
Taxability rules in PAY_TAXABILITY_RULES have a foreign key to this
table, which indicates for which length of time the rules are valid.
Through this table, taxability rules can be maintained for each year,
instead of being over written as they used to be.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PAY_TAXABILITY_RULES_DATES_PK | NORMAL | UNIQUE | APPS_TS_SEED | TAXABILITY_RULES_DATE_ID |
Table | |
Foreign Table | Foreign Key Column | PAY_TAXABILITY_RULES | PAY_TAXABILITY_RULES_DATES | PAY_TAXABILITY_RULES TAXABILITY_RULES_DATE_ID |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TAXABILITY_RULES_DATE_ID | NUMBER | (15) | Yes | System generated primary-key column. |
VALID_DATE_FROM | DATE | Yes | Start date of the length of time for which a set of taxability rules are valid. | |
VALID_DATE_TO | DATE | Yes | End date of he length of time for which a set of taxability rules are valid | |
LEGISLATION_CODE | VARCHAR2 | (30) | Yes | Foreign key to FND_TERRITORIES. |
TAX_RULES_INFORMATION_CATEGORY | VARCHAR2 | (30) | Developer descriptive flexfield column. | |
TAX_RULES_INFORMATION1 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
TAX_RULES_INFORMATION2 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
TAX_RULES_INFORMATION3 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
TAX_RULES_INFORMATION4 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
TAX_RULES_INFORMATION5 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
TAX_RULES_INFORMATION6 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
TAX_RULES_INFORMATION7 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
TAX_RULES_INFORMATION8 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
TAX_RULES_INFORMATION9 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
TAX_RULES_INFORMATION10 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
TAX_RULES_INFORMATION11 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
TAX_RULES_INFORMATION12 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
TAX_RULES_INFORMATION13 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
TAX_RULES_INFORMATION14 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
TAX_RULES_INFORMATION15 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
TAX_RULES_INFORMATION16 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
TAX_RULES_INFORMATION17 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
TAX_RULES_INFORMATION18 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
TAX_RULES_INFORMATION19 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
TAX_RULES_INFORMATION20 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
TAX_RULES_INFORMATION21 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
TAX_RULES_INFORMATION22 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
TAX_RULES_INFORMATION23 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
TAX_RULES_INFORMATION24 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
TAX_RULES_INFORMATION25 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
TAX_RULES_INFORMATION26 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
TAX_RULES_INFORMATION27 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
TAX_RULES_INFORMATION28 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
TAX_RULES_INFORMATION29 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
TAX_RULES_INFORMATION30 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
LAST_UPDATE_DATE | DATE | Standard Who column - date when a user last updated this row. | ||
LAST_UPDATED_BY | NUMBER | (15) | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
CREATED_BY | NUMBER | (15) | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
CREATION_DATE | DATE | Standard who column - date when this row was created. | ||
OBJECT_VERSION_NUMBER | NUMBER | System generated version of row. Increments by one with eah update. |
Cut, paste (and edit) the following text to query this object:
SELECT TAXABILITY_RULES_DATE_ID
, VALID_DATE_FROM
, VALID_DATE_TO
, LEGISLATION_CODE
, TAX_RULES_INFORMATION_CATEGORY
, TAX_RULES_INFORMATION1
, TAX_RULES_INFORMATION2
, TAX_RULES_INFORMATION3
, TAX_RULES_INFORMATION4
, TAX_RULES_INFORMATION5
, TAX_RULES_INFORMATION6
, TAX_RULES_INFORMATION7
, TAX_RULES_INFORMATION8
, TAX_RULES_INFORMATION9
, TAX_RULES_INFORMATION10
, TAX_RULES_INFORMATION11
, TAX_RULES_INFORMATION12
, TAX_RULES_INFORMATION13
, TAX_RULES_INFORMATION14
, TAX_RULES_INFORMATION15
, TAX_RULES_INFORMATION16
, TAX_RULES_INFORMATION17
, TAX_RULES_INFORMATION18
, TAX_RULES_INFORMATION19
, TAX_RULES_INFORMATION20
, TAX_RULES_INFORMATION21
, TAX_RULES_INFORMATION22
, TAX_RULES_INFORMATION23
, TAX_RULES_INFORMATION24
, TAX_RULES_INFORMATION25
, TAX_RULES_INFORMATION26
, TAX_RULES_INFORMATION27
, TAX_RULES_INFORMATION28
, TAX_RULES_INFORMATION29
, TAX_RULES_INFORMATION30
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, OBJECT_VERSION_NUMBER
FROM HR.PAY_TAXABILITY_RULES_DATES;
HR.PAY_TAXABILITY_RULES_DATES does not reference any database object
HR.PAY_TAXABILITY_RULES_DATES is referenced by following:
|
|
|