[Home] [Help] [Dependency Information]
Object Name: | ZX_REP_MATRIX_EXT_T# |
---|---|
Object Type: | VIEW |
Owner: | ZX |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DETAIL_TAX_LINE_MAT_ID | NUMBER | (15) | Yes | |
DETAIL_TAX_LINE_ID | NUMBER | (15) | ||
TAX1_STATUS_CODE | VARCHAR2 | (30) | ||
TAX1_REGIME_CODE | VARCHAR2 | (30) | ||
TAX1 | VARCHAR2 | (30) | ||
TAX1_RATE_CODE_ID | NUMBER | (15) | ||
TAX1_RATE_CODE | VARCHAR2 | (30) | ||
TAX1_RATE | NUMBER | |||
TAX1_RATE_VAT_TRX_TYPE_CODE | VARCHAR2 | (30) | ||
TAX1_RATE_VAT_TRX_TYPE_MNG | VARCHAR2 | (240) | ||
TAX1_RATE_VAT_TRX_TYPE_DESC | VARCHAR2 | (240) | ||
TAX1_RATE_CODE_REG_TYPE_CODE | VARCHAR2 | (30) | ||
TAX1_RATE_CODE_REG_TYPE_MNG | VARCHAR2 | (240) | ||
TAX1_RATE_CODE_TYPE_CODE | VARCHAR2 | (30) | ||
TAX1_RATE_CODE_TYPE_MNG | VARCHAR2 | (240) | ||
TAX1_RATE_CODE_NAME | VARCHAR2 | (240) | ||
TAX1_RATE_CODE_DESCRIPTION | VARCHAR2 | (240) | ||
TAX1_RECOVERABLE_FLAG | VARCHAR2 | (1) | ||
TAX1_RECOVERY_RATE | NUMBER | |||
TAX2_STATUS_CODE | VARCHAR2 | (30) | ||
TAX2_REGIME_CODE | VARCHAR2 | (30) | ||
TAX2 | VARCHAR2 | (30) | ||
TAX2_RATE_CODE_ID | NUMBER | (15) | ||
TAX2_RATE_CODE | VARCHAR2 | (30) | ||
TAX2_RATE | NUMBER | |||
TAX2_RATE_VAT_TRX_TYPE_CODE | VARCHAR2 | (30) | ||
TAX2_RATE_VAT_TRX_TYPE_MNG | VARCHAR2 | (240) | ||
TAX2_RATE_VAT_TRX_TYPE_DESC | VARCHAR2 | (240) | ||
TAX2_RATE_CODE_REG_TYPE_CODE | VARCHAR2 | (30) | ||
TAX2_RATE_CODE_REG_TYPE_MNG | VARCHAR2 | (240) | ||
TAX2_RATE_CODE_TYPE_CODE | VARCHAR2 | (30) | ||
TAX2_RATE_CODE_TYPE_MNG | VARCHAR2 | (240) | ||
TAX2_RATE_CODE_NAME | VARCHAR2 | (240) | ||
TAX2_RATE_CODE_DESCRIPTION | VARCHAR2 | (240) | ||
TAX2_RECOVERABLE_FLAG | VARCHAR2 | (1) | ||
TAX2_RECOVERY_RATE | NUMBER | |||
TAX3_STATUS_CODE | VARCHAR2 | (30) | ||
TAX3_REGIME_CODE | VARCHAR2 | (30) | ||
TAX3 | VARCHAR2 | (30) | ||
TAX3_RATE_CODE_ID | NUMBER | (15) | ||
TAX3_RATE_CODE | VARCHAR2 | (30) | ||
TAX3_RATE | NUMBER | |||
TAX3_RATE_VAT_TRX_TYPE_CODE | VARCHAR2 | (30) | ||
TAX3_RATE_VAT_TRX_TYPE_MNG | VARCHAR2 | (240) | ||
TAX3_RATE_VAT_TRX_TYPE_DESC | VARCHAR2 | (240) | ||
TAX3_RATE_CODE_REG_TYPE_CODE | VARCHAR2 | (30) | ||
TAX3_RATE_CODE_REG_TYPE_MNG | VARCHAR2 | (240) | ||
TAX3_RATE_CODE_TYPE_CODE | VARCHAR2 | (30) | ||
TAX3_RATE_CODE_TYPE_MNG | VARCHAR2 | (240) | ||
TAX3_RATE_CODE_NAME | VARCHAR2 | (240) | ||
TAX3_RATE_CODE_DESCRIPTION | VARCHAR2 | (240) | ||
TAX3_RECOVERABLE_FLAG | VARCHAR2 | (1) | ||
TAX3_RECOVERY_RATE | NUMBER | |||
TAX4_STATUS_CODE | VARCHAR2 | (30) | ||
TAX4_REGIME_CODE | VARCHAR2 | (30) | ||
TAX4 | VARCHAR2 | (30) | ||
TAX4_RATE_CODE_ID | NUMBER | (15) | ||
TAX4_RATE_CODE | VARCHAR2 | (30) | ||
TAX4_RATE | NUMBER | |||
TAX4_RATE_VAT_TRX_TYPE_CODE | VARCHAR2 | (30) | ||
TAX4_RATE_VAT_TRX_TYPE_MNG | VARCHAR2 | (240) | ||
TAX4_RATE_VAT_TRX_TYPE_DESC | VARCHAR2 | (240) | ||
TAX4_RATE_CODE_REG_TYPE_CODE | VARCHAR2 | (30) | ||
TAX4_RATE_CODE_REG_TYPE_MNG | VARCHAR2 | (240) | ||
TAX4_RATE_CODE_TYPE_CODE | VARCHAR2 | (30) | ||
TAX4_RATE_CODE_TYPE_MNG | VARCHAR2 | (240) | ||
TAX4_RATE_CODE_NAME | VARCHAR2 | (240) | ||
TAX4_RATE_CODE_DESCRIPTION | VARCHAR2 | (240) | ||
TAX4_RECOVERABLE_FLAG | VARCHAR2 | (1) | ||
TAX4_RECOVERY_RATE | NUMBER | |||
TAX1_AMT | NUMBER | |||
TAX1_AMT_FUNCL_CUR | NUMBER | |||
TAX1_LINE_NUMBER | NUMBER | |||
TAXABLE1_AMT | NUMBER | |||
TAXABLE1_AMT_FUNCL_CURR | NUMBER | |||
TAXABLE2_AMT | NUMBER | |||
TAXABLE2_AMT_FUNCL_CURR | NUMBER | |||
TAXABLE3_AMT | NUMBER | |||
TAXABLE3_AMT_FUNCL_CURR | NUMBER | |||
TAXABLE4_AMT | NUMBER | |||
TAXABLE4_AMT_FUNCL_CURR | NUMBER | |||
TAX2_AMT | NUMBER | |||
TAX2_AMT_FUNCL_CURR | NUMBER | |||
TAX2_LINE_NUMBER | NUMBER | |||
TAX3_AMT | NUMBER | |||
TAX3_AMT_FUNCL_CUR | NUMBER | |||
TAX3_LINE_NUMBER | NUMBER | |||
TAX4_AMT | NUMBER | |||
TAX4_AMT_FUNCL_CUR | NUMBER | |||
TAX4_LINE_NUMBER | NUMBER | |||
TAX1_DISC_AMT | NUMBER | |||
TAX1_DISC_AMT_FUNCL_CURR | NUMBER | |||
TAX2_DISC_AMT | NUMBER | |||
TAX2_DISC_AMT_FUNCL_CURR | NUMBER | |||
TAX3_DISC_AMT | NUMBER | |||
TAX3_DISC_AMT_FUNCL_CURR | NUMBER | |||
TAX4_DISC_AMT | NUMBER | |||
TAX4_DISC_AMT_FUNCL_CURR | NUMBER | |||
TAXABLE_DISC_AMT | NUMBER | |||
TAXABLE_DISC_AMT_FUNCL_CURR | NUMBER | |||
CREATED_BY | NUMBER | (15) | Yes | |
CREATION_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
REQUEST_ID | NUMBER | |||
PROGRAM_APPLICATION_ID | NUMBER | |||
PROGRAM_ID | NUMBER | |||
PROGRAM_LOGIN_ID | NUMBER |
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#;
|
|
|