[Home] [Help] [Dependency Information]
Object Name: | XTR_TAX_BROKERAGE_RATES |
---|---|
Object Type: | TABLE |
Owner: | XTR |
FND Design Data: | XTR.XTR_TAX_BROKERAGE_RATES |
Subobject Name: | |
Status: | VALID |
XTR_TAX_BROKERAGE_RATES contains the rate group and rates that are applied to withholding tax and brokerage amounts. Brokerage firms charge for their services based on a brokerage rate. A rate group defines a brokerage rate to be applied to a minimum and maximum brokerage amount range. A flat rate is applied to withholding tax amounts.
This table corresponds to the Rate Group tabbed region on the Brokerage Schedule and Details window, and the Rate Schedule tabbed region on the Tax Schedule and Details window.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
AUDIT_INDICATOR | VARCHAR2 | (1) | Not currently used | |
CMF_BROKERAGE_RATE | NUMBER | Not currently used | ||
EFFECTIVE_FROM | DATE | Yes | Effective date | |
FLAT_AMOUNT | NUMBER | Not currently used | ||
INTEREST_RATE | NUMBER | Interest rate at which a deal or transaction is executed | ||
MAX_AMT | NUMBER | Maximum amount for brokerage fee | ||
MIN_AMT | NUMBER | Minimum amount for brokerage fee | ||
RATE_GROUP | VARCHAR2 | (7) | Yes | Rate group code identifying group of tax or brokerage rates |
REF_TYPE | VARCHAR2 | (1) | Yes | Flag to indicate if the rate is a tax (T) rate or a brokerage (B) rate |
UPDATED_BY | VARCHAR2 | (30) | User who last updated this record | |
UPDATED_ON | DATE | Date this record was last updated | ||
CREATED_BY | VARCHAR2 | (30) | Yes | User who created this record |
CREATED_ON | DATE | Yes | Date this record was created |
Cut, paste (and edit) the following text to query this object:
SELECT AUDIT_INDICATOR
, CMF_BROKERAGE_RATE
, EFFECTIVE_FROM
, FLAT_AMOUNT
, INTEREST_RATE
, MAX_AMT
, MIN_AMT
, RATE_GROUP
, REF_TYPE
, UPDATED_BY
, UPDATED_ON
, CREATED_BY
, CREATED_ON
FROM XTR.XTR_TAX_BROKERAGE_RATES;
XTR.XTR_TAX_BROKERAGE_RATES does not reference any database object
XTR.XTR_TAX_BROKERAGE_RATES is referenced by following:
|
|
|