[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 |