[Home] [Help]
View: PAY_JP_ITAX_TAX_V
| Product: | PAY - Payroll |
|---|
| Description: | This view is used for Japanese localization only. |
|---|
| Implementation/DBA Data: |
 APPS.PAY_JP_ITAX_TAX_V
|
|---|
View Text
SELECT ROWID
, ACTION_INFORMATION_ID
, ACTION_CONTEXT_ID
, ACTION_CONTEXT_TYPE
, EFFECTIVE_DATE
, ASSIGNMENT_ID
, OBJECT_VERSION_NUMBER
, ACTION_INFORMATION_CATEGORY
, ACTION_INFORMATION1
, ACTION_INFORMATION2
, ACTION_INFORMATION3
, ACTION_INFORMATION4
, ACTION_INFORMATION5
, ACTION_INFORMATION6
, ACTION_INFORMATION7
, ACTION_INFORMATION8
, ACTION_INFORMATION9
, ACTION_INFORMATION10
, ACTION_INFORMATION11
, ACTION_INFORMATION12
, ACTION_INFORMATION13
, ACTION_INFORMATION14
, ACTION_INFORMATION15
, ACTION_INFORMATION16
, ACTION_INFORMATION17
, ACTION_INFORMATION18
, ACTION_INFORMATION19
, ACTION_INFORMATION20
, ACTION_INFORMATION21
, ACTION_INFORMATION22
, ACTION_INFORMATION23
, ACTION_INFORMATION24
, ACTION_INFORMATION25
, ACTION_INFORMATION26
, ACTION_INFORMATION27
, ACTION_INFORMATION28
, ACTION_INFORMATION29
, ACTION_INFORMATION30
, LAST_UPDATE_LOGIN
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, CREATED_BY
, CREATION_DATE
FROM PAY_ACTION_INFORMATION
WHERE ACTION_INFORMATION_CATEGORY = 'JP_ITAX_TAX'
AND ACTION_CONTEXT_TYPE = 'AAP'
Columns
| Name |
| ROW_ID |
| ACTION_INFORMATION_ID |
| ACTION_CONTEXT_ID |
| ACTION_CONTEXT_TYPE |
| EFFECTIVE_DATE |
| ASSIGNMENT_ID |
| OBJECT_VERSION_NUMBER |
| ACTION_INFORMATION_CATEGORY |
| TAXABLE_INCOME |
| NET_TAXABLE_INCOME |
| TOTAL_INCOME_EXEMPT |
| WITHHOLDING_ITAX |
| WITHHOLDING_ITAX2 |
| SPOUSE_SPECIAL_EXEMPT |
| SOCIAL_INSURANCE_PREMIUM |
| MUTUAL_AID_PREMIUM |
| LIFE_INSURANCE_PREMIUM_EXEMPT |
| DAMAGE_INSURANCE_PREMIUM_EXEM |
| HOUSING_TAX_REDUCTION |
| ITAX_ADJUSTMENT2 |
| SPOUSE_NET_TAXABLE_INCOME |
| PRIVATE_PENSION_PREMIUM |
| LONG_DAMAGE_INSURANCE_PREMIUM |
| DISASTER_TAX_REDUCTION |
| PREV_JOB_EMPLOYER_ADD_KANA |
| PREV_JOB_EMPLOYER_ADD_KANJI |
| PREV_JOB_EMPLOYER_NAME_KANA |
| PREV_JOB_EMPLOYER_NAME_KANJI |
| PREV_JOB_FOREIGN_ADDRESS |
| PREV_JOB_TAXABLE_INCOME |
| PREV_JOB_ITAX |
| PREV_JOB_SI_PREM |
| PREV_JOB_TERMINATION_YEAR |
| PREV_JOB_TERMINATION_MONTH |
| PREV_JOB_TERMINATION_DAY |
| HOUSING_RESIDENCE_YEAR |
| HOUSING_RESIDENCE_MONTH |
| HOUSING_RESIDENCE_DAY |
| LAST_UPDATE_LOGIN |
| LAST_UPDATED_BY |
| LAST_UPDATE_DATE |
| CREATED_BY |
| CREATION_DATE |