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

TABLE: ZX.ZX_REP_MATRIX_EXT_T

Object Details
Object Name: ZX_REP_MATRIX_EXT_T
Object Type: TABLE
Owner: ZX
FND Design Data: TableZX.ZX_REP_MATRIX_EXT_T
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
ZX_REP_MATRIX_EXT_T_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnDETAIL_TAX_LINE_MAT_ID
Columns
Name Datatype Length Mandatory Comments
DETAIL_TAX_LINE_MAT_ID NUMBER (15) Yes Unique identifier
DETAIL_TAX_LINE_ID NUMBER (15)
Detail tax line identifier
TAX1_STATUS_CODE VARCHAR2 (30)
Tax status code for the first tax line
TAX1_REGIME_CODE VARCHAR2 (30)
Tax regime code for the first tax line
TAX1 VARCHAR2 (30)
Tax for the first tax line
TAX1_RATE_CODE_ID NUMBER (15)
Tax rate code identifier for the first tax line
TAX1_RATE_CODE VARCHAR2 (30)
Tax rate code for the first tax line
TAX1_RATE NUMBER

Tax rate for the first tax line
TAX1_RATE_VAT_TRX_TYPE_CODE VARCHAR2 (30)
Tax rate transaction type code for the first tax line
TAX1_RATE_VAT_TRX_TYPE_MNG VARCHAR2 (240)
Tax rate transaction type meaning for the first tax line
TAX1_RATE_VAT_TRX_TYPE_DESC VARCHAR2 (240)
Tax rate transaction type description for the first tax line
TAX1_RATE_CODE_REG_TYPE_CODE VARCHAR2 (30)
Tax registration type code for the first tax line
TAX1_RATE_CODE_REG_TYPE_MNG VARCHAR2 (240)
Tax registration type meaning for the first tax line
TAX1_RATE_CODE_TYPE_CODE VARCHAR2 (30)
Tax rate type code for the first tax line
TAX1_RATE_CODE_TYPE_MNG VARCHAR2 (240)
Tax rate type meaning for the first tax line
TAX1_RATE_CODE_NAME VARCHAR2 (240)
Tax rate name for the first tax line
TAX1_RATE_CODE_DESCRIPTION VARCHAR2 (240)
Tax rate description for the first tax line
TAX1_RECOVERABLE_FLAG VARCHAR2 (1)
Y or N to indicate whether the first tax line is recoverable
TAX1_RECOVERY_RATE NUMBER

Tax recovery rate for the first tax line
TAX2_STATUS_CODE VARCHAR2 (30)
Tax status code for the second tax line
TAX2_REGIME_CODE VARCHAR2 (30)
Tax regime code for the first tax line
TAX2 VARCHAR2 (30)
Tax for the second tax line
TAX2_RATE_CODE_ID NUMBER (15)
Tax rate code identifier for the second tax line
TAX2_RATE_CODE VARCHAR2 (30)
Tax rate code for the second tax line
TAX2_RATE NUMBER

Tax rate for the second tax line
TAX2_RATE_VAT_TRX_TYPE_CODE VARCHAR2 (30)
Tax rate transaction type code for the second tax line
TAX2_RATE_VAT_TRX_TYPE_MNG VARCHAR2 (240)
Tax rate transaction type meaning for the second tax line
TAX2_RATE_VAT_TRX_TYPE_DESC VARCHAR2 (240)
Tax rate transaction type description for the second tax line
TAX2_RATE_CODE_REG_TYPE_CODE VARCHAR2 (30)
Tax registration type code for the second tax line
TAX2_RATE_CODE_REG_TYPE_MNG VARCHAR2 (240)
Tax registration type meaning for the second tax line
TAX2_RATE_CODE_TYPE_CODE VARCHAR2 (30)
Tax rate type code for the second tax line
TAX2_RATE_CODE_TYPE_MNG VARCHAR2 (240)
Tax rate type meaning for the second tax line
TAX2_RATE_CODE_NAME VARCHAR2 (240)
Tax rate name for the second tax line
TAX2_RATE_CODE_DESCRIPTION VARCHAR2 (240)
Tax rate description for the second tax line
TAX2_RECOVERABLE_FLAG VARCHAR2 (1)
Y or N to indicate whether the second tax line is recoverable
TAX2_RECOVERY_RATE NUMBER

Tax recovery rate for the second tax line
TAX3_STATUS_CODE VARCHAR2 (30)
Tax status code for the third tax line
TAX3_REGIME_CODE VARCHAR2 (30)
Tax regime code for the third tax line
TAX3 VARCHAR2 (30)
Tax for the third tax line
TAX3_RATE_CODE_ID NUMBER (15)
Tax rate code identifier for the third tax line
TAX3_RATE_CODE VARCHAR2 (30)
Tax rate code for the third tax line
TAX3_RATE NUMBER

Tax rate for the third tax line
TAX3_RATE_VAT_TRX_TYPE_CODE VARCHAR2 (30)
Tax rate transaction type code for the third tax line
TAX3_RATE_VAT_TRX_TYPE_MNG VARCHAR2 (240)
Tax rate transaction type meaning for the third tax line
TAX3_RATE_VAT_TRX_TYPE_DESC VARCHAR2 (240)
Tax rate transaction type description for the third tax line
TAX3_RATE_CODE_REG_TYPE_CODE VARCHAR2 (30)
Tax registration type code for the third tax line
TAX3_RATE_CODE_REG_TYPE_MNG VARCHAR2 (240)
Tax registration type meaning for the third tax line
TAX3_RATE_CODE_TYPE_CODE VARCHAR2 (30)
Tax rate type code for the third tax line
TAX3_RATE_CODE_TYPE_MNG VARCHAR2 (240)
Tax rate type meaning for the third tax line
TAX3_RATE_CODE_NAME VARCHAR2 (240)
Tax rate name for the third tax line
TAX3_RATE_CODE_DESCRIPTION VARCHAR2 (240)
Tax rate description for the third tax line
TAX3_RECOVERABLE_FLAG VARCHAR2 (1)
Y or N to indicate whether the third tax line is recoverable
TAX3_RECOVERY_RATE NUMBER

Tax recovery rate for the third tax line
TAX4_STATUS_CODE VARCHAR2 (30)
Tax status code for the fourth tax line
TAX4_REGIME_CODE VARCHAR2 (30)
Tax regime code for the third tax line
TAX4 VARCHAR2 (30)
Tax for the fourth tax line
TAX4_RATE_CODE_ID NUMBER (15)
Tax rate code identifier for the fourth tax line
TAX4_RATE_CODE VARCHAR2 (30)
Tax rate code for the fourth tax line
TAX4_RATE NUMBER

Tax rate for the fourth tax line
TAX4_RATE_VAT_TRX_TYPE_CODE VARCHAR2 (30)
Tax rate transaction type code for the fourth tax line
TAX4_RATE_VAT_TRX_TYPE_MNG VARCHAR2 (240)
Tax rate transaction type meaning for the fourth tax line
TAX4_RATE_VAT_TRX_TYPE_DESC VARCHAR2 (240)
Tax rate transaction type description for the fourth tax line
TAX4_RATE_CODE_REG_TYPE_CODE VARCHAR2 (30)
Tax registration type code for the fourth tax line
TAX4_RATE_CODE_REG_TYPE_MNG VARCHAR2 (240)
Tax registration type meaning for the fourth tax line
TAX4_RATE_CODE_TYPE_CODE VARCHAR2 (30)
Tax rate type code for the fourth tax line
TAX4_RATE_CODE_TYPE_MNG VARCHAR2 (240)
Tax rate type meaning for the fourth tax line
TAX4_RATE_CODE_NAME VARCHAR2 (240)
Tax rate name for the fourth tax line
TAX4_RATE_CODE_DESCRIPTION VARCHAR2 (240)
Tax rate description for the fourth tax line
TAX4_RECOVERABLE_FLAG VARCHAR2 (1)
Y or N to indicate whether the fourth tax line is recoverable
TAX4_RECOVERY_RATE NUMBER

Tax recovery rate for the fourth tax line
TAX1_AMT NUMBER

Tax amount in transaction currency for the first tax line
TAX1_AMT_FUNCL_CUR NUMBER

Tax amount in functional currency for the first tax line
TAX1_LINE_NUMBER NUMBER

Tax line number for the first tax line
TAXABLE1_AMT NUMBER

Taxable amount for the first tax line
TAXABLE1_AMT_FUNCL_CURR NUMBER

Taxable amount in functional currency for the first tax line
TAXABLE2_AMT NUMBER

Taxable amount for the second tax line
TAXABLE2_AMT_FUNCL_CURR NUMBER

Taxable amount in functional currency for the second tax line
TAXABLE3_AMT NUMBER

Taxable amount for the third tax line
TAXABLE3_AMT_FUNCL_CURR NUMBER

Taxable amount in functional currency for the third tax line
TAXABLE4_AMT NUMBER

Taxable amount for the fourth tax line
TAXABLE4_AMT_FUNCL_CURR NUMBER

Taxable amount in functional currency for the fourth tax line
TAX2_AMT NUMBER

Tax amount in transaction currency for the second tax line
TAX2_AMT_FUNCL_CURR NUMBER

Tax amount in functional currency for the second tax line
TAX2_LINE_NUMBER NUMBER

Tax line number for the second tax line
TAX3_AMT NUMBER

Tax amount in transaction currency for the third tax line
TAX3_AMT_FUNCL_CUR NUMBER

Tax amount in functional currency for the third tax line
TAX3_LINE_NUMBER NUMBER

Tax line number for the third tax line
TAX4_AMT NUMBER

Tax amount in transaction currency for the fourth tax line
TAX4_AMT_FUNCL_CUR NUMBER

Tax amount in functional currency for the fourth tax line
TAX4_LINE_NUMBER NUMBER

Tax line number for the fourth tax line
TAX1_DISC_AMT NUMBER

Tax discount amount for the first tax line
TAX1_DISC_AMT_FUNCL_CURR NUMBER

Tax discount amount in functional currency for the first tax line
TAX2_DISC_AMT NUMBER

Tax discount amount for the second tax line
TAX2_DISC_AMT_FUNCL_CURR NUMBER

Tax discount amount in functional currency for the second tax line
TAX3_DISC_AMT NUMBER

Tax discount amount for the third tax line
TAX3_DISC_AMT_FUNCL_CURR NUMBER

Tax discount amount in functional currency for the third tax line
TAX4_DISC_AMT NUMBER

Tax discount amount for the fourth tax line
TAX4_DISC_AMT_FUNCL_CURR NUMBER

Tax discount amount in functional currency for the fourth tax line
TAXABLE_DISC_AMT NUMBER

Taxable discount amount
TAXABLE_DISC_AMT_FUNCL_CURR NUMBER

Taxable discount amount in functional currency
CREATED_BY NUMBER (15) Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
REQUEST_ID NUMBER

Request identifier of last concurrent program to update this record
PROGRAM_APPLICATION_ID NUMBER

Application identifier of last concurrent program to update this record
PROGRAM_ID NUMBER

Program identifier of last concurrent program to update this record
PROGRAM_LOGIN_ID NUMBER

Login user identifier of last concurrent program to update this record
Query Text

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


SELECT DETAIL_TAX_LINE_MAT_ID
,      DETAIL_TAX_LINE_ID
,      TAX1_STATUS_CODE
,      TAX1_REGIME_CODE
,      TAX1
,      TAX1_RATE_CODE_ID
,      TAX1_RATE_CODE
,      TAX1_RATE
,      TAX1_RATE_VAT_TRX_TYPE_CODE
,      TAX1_RATE_VAT_TRX_TYPE_MNG
,      TAX1_RATE_VAT_TRX_TYPE_DESC
,      TAX1_RATE_CODE_REG_TYPE_CODE
,      TAX1_RATE_CODE_REG_TYPE_MNG
,      TAX1_RATE_CODE_TYPE_CODE
,      TAX1_RATE_CODE_TYPE_MNG
,      TAX1_RATE_CODE_NAME
,      TAX1_RATE_CODE_DESCRIPTION
,      TAX1_RECOVERABLE_FLAG
,      TAX1_RECOVERY_RATE
,      TAX2_STATUS_CODE
,      TAX2_REGIME_CODE
,      TAX2
,      TAX2_RATE_CODE_ID
,      TAX2_RATE_CODE
,      TAX2_RATE
,      TAX2_RATE_VAT_TRX_TYPE_CODE
,      TAX2_RATE_VAT_TRX_TYPE_MNG
,      TAX2_RATE_VAT_TRX_TYPE_DESC
,      TAX2_RATE_CODE_REG_TYPE_CODE
,      TAX2_RATE_CODE_REG_TYPE_MNG
,      TAX2_RATE_CODE_TYPE_CODE
,      TAX2_RATE_CODE_TYPE_MNG
,      TAX2_RATE_CODE_NAME
,      TAX2_RATE_CODE_DESCRIPTION
,      TAX2_RECOVERABLE_FLAG
,      TAX2_RECOVERY_RATE
,      TAX3_STATUS_CODE
,      TAX3_REGIME_CODE
,      TAX3
,      TAX3_RATE_CODE_ID
,      TAX3_RATE_CODE
,      TAX3_RATE
,      TAX3_RATE_VAT_TRX_TYPE_CODE
,      TAX3_RATE_VAT_TRX_TYPE_MNG
,      TAX3_RATE_VAT_TRX_TYPE_DESC
,      TAX3_RATE_CODE_REG_TYPE_CODE
,      TAX3_RATE_CODE_REG_TYPE_MNG
,      TAX3_RATE_CODE_TYPE_CODE
,      TAX3_RATE_CODE_TYPE_MNG
,      TAX3_RATE_CODE_NAME
,      TAX3_RATE_CODE_DESCRIPTION
,      TAX3_RECOVERABLE_FLAG
,      TAX3_RECOVERY_RATE
,      TAX4_STATUS_CODE
,      TAX4_REGIME_CODE
,      TAX4
,      TAX4_RATE_CODE_ID
,      TAX4_RATE_CODE
,      TAX4_RATE
,      TAX4_RATE_VAT_TRX_TYPE_CODE
,      TAX4_RATE_VAT_TRX_TYPE_MNG
,      TAX4_RATE_VAT_TRX_TYPE_DESC
,      TAX4_RATE_CODE_REG_TYPE_CODE
,      TAX4_RATE_CODE_REG_TYPE_MNG
,      TAX4_RATE_CODE_TYPE_CODE
,      TAX4_RATE_CODE_TYPE_MNG
,      TAX4_RATE_CODE_NAME
,      TAX4_RATE_CODE_DESCRIPTION
,      TAX4_RECOVERABLE_FLAG
,      TAX4_RECOVERY_RATE
,      TAX1_AMT
,      TAX1_AMT_FUNCL_CUR
,      TAX1_LINE_NUMBER
,      TAXABLE1_AMT
,      TAXABLE1_AMT_FUNCL_CURR
,      TAXABLE2_AMT
,      TAXABLE2_AMT_FUNCL_CURR
,      TAXABLE3_AMT
,      TAXABLE3_AMT_FUNCL_CURR
,      TAXABLE4_AMT
,      TAXABLE4_AMT_FUNCL_CURR
,      TAX2_AMT
,      TAX2_AMT_FUNCL_CURR
,      TAX2_LINE_NUMBER
,      TAX3_AMT
,      TAX3_AMT_FUNCL_CUR
,      TAX3_LINE_NUMBER
,      TAX4_AMT
,      TAX4_AMT_FUNCL_CUR
,      TAX4_LINE_NUMBER
,      TAX1_DISC_AMT
,      TAX1_DISC_AMT_FUNCL_CURR
,      TAX2_DISC_AMT
,      TAX2_DISC_AMT_FUNCL_CURR
,      TAX3_DISC_AMT
,      TAX3_DISC_AMT_FUNCL_CURR
,      TAX4_DISC_AMT
,      TAX4_DISC_AMT_FUNCL_CURR
,      TAXABLE_DISC_AMT
,      TAXABLE_DISC_AMT_FUNCL_CURR
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_LOGIN_ID
FROM ZX.ZX_REP_MATRIX_EXT_T;

Dependencies

[top of page]

ZX.ZX_REP_MATRIX_EXT_T does not reference any database object

ZX.ZX_REP_MATRIX_EXT_T is referenced by following:

SchemaAPPS
SynonymZX_REP_MATRIX_EXT_T