[Home] [Help] [Dependency Information]
Object Name: | PAY_JP_ITAX_TAX_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PAY.PAY_JP_ITAX_TAX_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Row ID | |
ACTION_INFORMATION_ID | NUMBER | (15) | Yes | Action Information ID |
ACTION_CONTEXT_ID | NUMBER | (15) | Yes | Action Context ID |
ACTION_CONTEXT_TYPE | VARCHAR2 | (15) | Yes | Action Context Type |
EFFECTIVE_DATE | DATE | Effective date | ||
ASSIGNMENT_ID | NUMBER | (10) | Assignment id | |
OBJECT_VERSION_NUMBER | NUMBER | Object Version Number | ||
ACTION_INFORMATION_CATEGORY | VARCHAR2 | (80) | Yes | Action Information Category |
TAXABLE_INCOME | VARCHAR2 | (240) | Taxable Income Gross | |
NET_TAXABLE_INCOME | VARCHAR2 | (240) | Taxable Income Net | |
TOTAL_INCOME_EXEMPT | VARCHAR2 | (240) | Exempt Income | |
WITHHOLDING_ITAX | VARCHAR2 | (240) | Withholding Tax | |
WITHHOLDING_ITAX2 | VARCHAR2 | (240) | Withholding tax | |
SPOUSE_SPECIAL_EXEMPT | VARCHAR2 | (240) | Spouse sepcial exempt amount | |
SOCIAL_INSURANCE_PREMIUM | VARCHAR2 | (240) | Social Insurance Premium | |
MUTUAL_AID_PREMIUM | VARCHAR2 | (240) | Mutual Aid Premium | |
LIFE_INSURANCE_PREMIUM_EXEMPT | VARCHAR2 | (240) | Life Insurance Premium exempt | |
DAMAGE_INSURANCE_PREMIUM_EXEM | VARCHAR2 | (240) | Damage Insurance Premium exempt | |
HOUSING_TAX_REDUCTION | VARCHAR2 | (240) | Housing Tax Reduction | |
ITAX_ADJUSTMENT2 | VARCHAR2 | (240) | Income Tax Adjustment | |
SPOUSE_NET_TAXABLE_INCOME | VARCHAR2 | (240) | Spouse Net Taxable Income | |
PRIVATE_PENSION_PREMIUM | VARCHAR2 | (240) | Private Pension Premium | |
LONG_DAMAGE_INSURANCE_PREMIUM | VARCHAR2 | (240) | Damage Insurance Premium | |
DISASTER_TAX_REDUCTION | VARCHAR2 | (240) | Disaster Tax Reduction | |
PREV_JOB_EMPLOYER_ADD_KANA | VARCHAR2 | (240) | Previous Employer Address Kana | |
PREV_JOB_EMPLOYER_ADD_KANJI | VARCHAR2 | (240) | Previous Employer Address Kanji | |
PREV_JOB_EMPLOYER_NAME_KANA | VARCHAR2 | (240) | Previous Employer Name Kana | |
PREV_JOB_EMPLOYER_NAME_KANJI | VARCHAR2 | (240) | Previous Employer Name Kanji | |
PREV_JOB_FOREIGN_ADDRESS | VARCHAR2 | (240) | Previous Job Foreign address | |
PREV_JOB_TAXABLE_INCOME | VARCHAR2 | (240) | Previous Job Taxable Income | |
PREV_JOB_ITAX | VARCHAR2 | (240) | Previous Job Income tax | |
PREV_JOB_SI_PREM | VARCHAR2 | (240) | Previous Job SI Premium | |
PREV_JOB_TERMINATION_YEAR | VARCHAR2 | (240) | Previous Job Termination Year | |
PREV_JOB_TERMINATION_MONTH | VARCHAR2 | (240) | Previous Job Termination Month | |
PREV_JOB_TERMINATION_DAY | VARCHAR2 | (240) | Previous Job Termination Day | |
HOUSING_RESIDENCE_YEAR | VARCHAR2 | (240) | Housing Residence Year | |
HOUSING_RESIDENCE_MONTH | VARCHAR2 | (240) | Housing Residence Month | |
HOUSING_RESIDENCE_DAY | VARCHAR2 | (240) | Housing Residence Day | |
LAST_UPDATE_LOGIN | NUMBER | Last Update Login | ||
LAST_UPDATED_BY | NUMBER | Last Updated By | ||
LAST_UPDATE_DATE | DATE | Last Update Date | ||
CREATED_BY | NUMBER | Created By | ||
CREATION_DATE | DATE | Creation Date |
Cut, paste (and edit) the following text to query this object:
SELECT 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
FROM APPS.PAY_JP_ITAX_TAX_V;
|
|
|