[Home] [Help] [Dependency Information]
Object Name: | ZX_REP_MATRIX_EXT_T |
---|---|
Object Type: | TABLE |
Owner: | ZX |
FND Design Data: | ZX.ZX_REP_MATRIX_EXT_T |
Subobject Name: | |
Status: | VALID |
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
ZX_REP_MATRIX_EXT_T_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | DETAIL_TAX_LINE_MAT_ID |
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 |
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;
ZX.ZX_REP_MATRIX_EXT_T does not reference any database object
ZX.ZX_REP_MATRIX_EXT_T is referenced by following:
|
|
|