Skip to content

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

VIEW: ZX.ZX_REP_MATRIX_EXT_T#

Object Details
Object Name: ZX_REP_MATRIX_EXT_T#
Object Type: VIEW
Owner: ZX
Subobject Name:
Status: VALID

[View Source]

Columns
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

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# references the following:

SchemaZX
TableZX_REP_MATRIX_EXT_T
ZX.ZX_REP_MATRIX_EXT_T# is referenced by following:

SchemaAPPS
SynonymZX_REP_MATRIX_EXT_T