DBA Data[Home] [Help] [Dependency Information]

TABLE: XTR.XTR_EXPOSURE_TYPES

Object Details
Object Name: XTR_EXPOSURE_TYPES
Object Type: TABLE
Owner: XTR
FND Design Data: TableXTR.XTR_EXPOSURE_TYPES
Subobject Name:
Status: VALID


XTR_EXPOSURE_TYPES contains exposure type and tax and brokerage settlement code information.
Each row with a value of ?Y? in the TAX_BROKERAGE_TYPE column corresponds to a tax or brokerage settlement code. The settlement codes are used to settle withholding tax and
brokerage fees. Otherwise, the row corresponds to an exposure type.
This table corresponds to the Exposure Types window, the Settlement Codes tabbed region on the Brokerage Schedule and Details window and to the Settlement Codes tabbed region on the Tax Schedule and Details window.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
XTR_EXPOSURE_TYPES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnEXPOSURE_TYPE
ColumnCOMPANY_CODE
XTR_EXPOSURE_TYPES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCOMPANY_CODE
XTR_EXPOSURE_TYPES_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCODE_COMBINATION_ID
ColumnCOMPANY_CODE
Columns
Name Datatype Length Mandatory Comments
AUDIT_INDICATOR VARCHAR2 (1)
Not currently used
BALANCE_SHEET_EXPOSURE VARCHAR2 (1)
Not currently used
COMPANY_CODE VARCHAR2 (7) Yes Company code
EXPOSURE_TYPE VARCHAR2 (10) Yes Exposure type
FREQUENCY NUMBER

Frequency at which the exposure occurs (for example, 5 means the exposure occurs every five days)
CODE_COMBINATION_ID NUMBER (15)
Unique key for identifying GL account references
LAST_DOWNLOAD_DATE DATE

Not currently used
NAME VARCHAR2 (80) Yes Exposure type description
TAX_BROKERAGE_TYPE VARCHAR2 (1)
Flag to indicate if the exposure type is a tax or brokerage type (Y), or not (N)
TAX_OR_BROKERAGE VARCHAR2 (1)
Flag to indicate if the exposure type is a tax (T) or brokerage (B) (meaningful only when the TAX_BROKERAGE_TYPE has value Y)
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
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT AUDIT_INDICATOR
,      BALANCE_SHEET_EXPOSURE
,      COMPANY_CODE
,      EXPOSURE_TYPE
,      FREQUENCY
,      CODE_COMBINATION_ID
,      LAST_DOWNLOAD_DATE
,      NAME
,      TAX_BROKERAGE_TYPE
,      TAX_OR_BROKERAGE
,      UPDATED_BY
,      UPDATED_ON
,      CREATED_BY
,      CREATED_ON
FROM XTR.XTR_EXPOSURE_TYPES;

Dependencies

[top of page]

XTR.XTR_EXPOSURE_TYPES does not reference any database object

XTR.XTR_EXPOSURE_TYPES is referenced by following:

SchemaXTR
ViewXTR_EXPOSURE_TYPES#