[Home] [Help] [Dependency Information]
Object Name: | XTR_DEDUCTION_CALCS |
---|---|
Object Type: | TABLE |
Owner: | XTR |
FND Design Data: | XTR.XTR_DEDUCTION_CALCS |
Subobject Name: | |
Status: | VALID |
XTR_DEDUCTION_CALCS contains pre-defined deduction calculation methods that apply to the set up of tax and brokerage schedules. Each calculation method corresponds to an amount type and calculation basis for a deal type. The calculation method is used in the calculation of withholding tax and brokerage settlement amounts.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
XTR_DEDUCTION_CALCS_U1 | NORMAL | UNIQUE | APPS_TS_SEED |
DEAL_TYPE
AMOUNT_TYPE CALC_BASIS CALC_TYPE ZD_EDITION_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
AMOUNT_TYPE | VARCHAR2 | (7) | Yes | Code that identifies the purpose of the amounts for a deal type |
CALC_BASIS | VARCHAR2 | (10) | Yes | Basis on which the deduction is calculated |
CALC_TYPE | VARCHAR2 | (30) | Yes | Calculation type |
DESCRIPTION | VARCHAR2 | (30) | Yes | Deduction calculation description |
DEAL_TYPE | VARCHAR2 | (7) | Yes | Code for high level deals |
ZD_EDITION_NAME | VARCHAR2 | (30) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT AMOUNT_TYPE
, CALC_BASIS
, CALC_TYPE
, DESCRIPTION
, DEAL_TYPE
, ZD_EDITION_NAME
FROM XTR.XTR_DEDUCTION_CALCS;
XTR.XTR_DEDUCTION_CALCS does not reference any database object
XTR.XTR_DEDUCTION_CALCS is referenced by following:
|
|
|