[Home] [Help] [Dependency Information]
Object Name: | PAY_JP_PRE_TAX_OLD |
---|---|
Object Type: | TABLE |
Owner: | HR |
FND Design Data: | PAY.PAY_JP_PRE_TAX_OLD |
Subobject Name: | |
Status: | VALID |
PAY_JP_PRE_TAX_OLD holds Japanese tax amount and information.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PAY_JP_PRE_TAX_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | PRE_TAX_ID |
PAY_JP_PRE_TAX_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | ASSIGNMENT_ACTION_ID |
PAY_JP_PRE_TAX_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | ACTION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PRE_TAX_ID | NUMBER | (15) | Yes | System-generated primary key column. |
ACTION_ID | NUMBER | (9) | Yes | System-generated non-unique column. Used for which row should be processed by PAY_JP_PRE_TAX_PKG. |
ASSIGNMENT_ACTION_ID | NUMBER | (15) | Yes | Foreign key to PAY_ASSIGNMENT_ACTIONS. |
ACTION_STATUS | VARCHAR2 | (1) | Yes | Valid status for the assignment_action_id of PAY_JP_PRE_TAX_PKG process. |
SALARY_CATEGORY | VARCHAR2 | (30) | Salary category. | |
TAXABLE_SAL_AMT | NUMBER | (38) | Yes | Taxable salary amount (including salary for non-resident and terminator). |
TAXABLE_MAT_AMT | NUMBER | (38) | Yes | Taxable material salary amount (including salary for non-resident and terminator). |
PREVIOUS_TAXABLE_AMT | NUMBER | (38) | Yes | Taxable amount from previous career. |
HI_ORGANIZATION_ID | NUMBER | (15) | HI organization_id. Foreign key to HR_ALL_ORGANIZATION_UNITS. | |
HI_PREM_EE | NUMBER | (38) | Yes | Employee's premium for HI. |
HI_PREM_ER | NUMBER | (38) | Yes | Employer's premium for HI. |
WP_ORGANIZATION_ID | NUMBER | (15) | WP organization_id. Foreign key to HR_ALL_ORGANIZATION_UNITS. | |
WP_PREM_EE | NUMBER | (38) | Yes | Employee's premium for WP. |
WP_PREM_ER | NUMBER | (38) | Yes | Employer's premium for WP. |
WPF_ORGANIZATION_ID | NUMBER | (15) | WPF organization_id. Foreign key to HR_ALL_ORGANIZATION_UNITS. | |
WPF_PREM_EE | NUMBER | (38) | Yes | Employee's premium for WPF. |
WPF_PREM_ER | NUMBER | (38) | Yes | Employee's premium for WPF. |
UI_ORGANIZATION_ID | NUMBER | (15) | UI organization_id. Foreign key to HR_ALL_ORGANIZATION_UNITS. | |
UI_CATEGORY | VARCHAR2 | (30) | Employee's caterogy on UI. | |
UI_PREM_EE | NUMBER | (38) | Yes | Employee's premium for UI. |
UI_SAL_AMT | NUMBER | (38) | Yes | Salary amount for UI. |
WAI_ORGANIZATION_ID | NUMBER | (15) | WAI organization_id. Foreign key to HR_ALL_ORGANIZATION_UNITS. | |
WAI_CATEGORY | VARCHAR2 | (30) | Employee's category on UI. | |
WAI_SAL_AMT | NUMBER | (38) | Yes | Salary amount for WAI. |
ITAX_ORGANIZATION_ID | NUMBER | (15) | ITAX organization_id. Foreign key to HR_ALL_ORGANIZATION_UNITS. | |
ITAX_CATEGORY | VARCHAR2 | (30) | Employee's category on ITAX calc. | |
ITAX_YEA_CATEGORY | VARCHAR2 | (30) | Employee's processing category for (Re-)Year-End-Adjustment(YEA). | |
ITAX | NUMBER | (38) | Yes | ITAX Amount (Excluding ITAX Adjustment amount for YEA). |
ITAX_ADJUSTMENT | NUMBER | (38) | Yes | ITAX Adjustment amount for YEA. |
PREVIOUS_ITAX | NUMBER | (38) | Yes | ITAX from previous career. |
LTAX_ORGANIZATION_ID | NUMBER | (15) | LTAX organization_id. Foreign key to HR_ALL_ORGANIZATION_UNITS. | |
LTAX_DISTRICT_CODE | VARCHAR2 | (30) | LTAX DISTRICT Code. | |
LTAX_SWOT_NO | VARCHAR2 | (30) | LTAX SWOT Number. | |
LTAX | NUMBER | (38) | Yes | LTAX amount (excluding lumpsum LTax). |
LTAX_LUMPSUM | NUMBER | (38) | Yes | LTAX Amount for lumpsum. |
SP_LTAX | NUMBER | (38) | Yes | Special LTAX Amount. |
SP_LTAX_INCOME | NUMBER | (38) | Yes | Taxable amount for special LTAX. |
SP_LTAX_SHI | NUMBER | (38) | Yes | Special LTAX amount for DISTRICT. |
SP_LTAX_TO | NUMBER | (38) | Yes | Special LTAX amount for prefecture. |
CI_PREM_EE | NUMBER | (38) | Yes | Employee's premium for CI. |
CI_PREM_ER | NUMBER | (38) | Yes | Employer's premium for CI. |
MUTUAL_AID | NUMBER | (38) | Yes | Premium for Mutual Aid. |
DISASTER_TAX_REDUCTION | NUMBER | (38) | Yes | Disaster Tax Reduction |
SP_LTAX_DISTRICT_CODE | VARCHAR2 | (30) | Special LTAX DISTRICT Code. |
Cut, paste (and edit) the following text to query this object:
SELECT PRE_TAX_ID
, ACTION_ID
, ASSIGNMENT_ACTION_ID
, ACTION_STATUS
, SALARY_CATEGORY
, TAXABLE_SAL_AMT
, TAXABLE_MAT_AMT
, PREVIOUS_TAXABLE_AMT
, HI_ORGANIZATION_ID
, HI_PREM_EE
, HI_PREM_ER
, WP_ORGANIZATION_ID
, WP_PREM_EE
, WP_PREM_ER
, WPF_ORGANIZATION_ID
, WPF_PREM_EE
, WPF_PREM_ER
, UI_ORGANIZATION_ID
, UI_CATEGORY
, UI_PREM_EE
, UI_SAL_AMT
, WAI_ORGANIZATION_ID
, WAI_CATEGORY
, WAI_SAL_AMT
, ITAX_ORGANIZATION_ID
, ITAX_CATEGORY
, ITAX_YEA_CATEGORY
, ITAX
, ITAX_ADJUSTMENT
, PREVIOUS_ITAX
, LTAX_ORGANIZATION_ID
, LTAX_DISTRICT_CODE
, LTAX_SWOT_NO
, LTAX
, LTAX_LUMPSUM
, SP_LTAX
, SP_LTAX_INCOME
, SP_LTAX_SHI
, SP_LTAX_TO
, CI_PREM_EE
, CI_PREM_ER
, MUTUAL_AID
, DISASTER_TAX_REDUCTION
, SP_LTAX_DISTRICT_CODE
FROM HR.PAY_JP_PRE_TAX_OLD;
HR.PAY_JP_PRE_TAX_OLD does not reference any database object
HR.PAY_JP_PRE_TAX_OLD is referenced by following:
|
|
|