Skip to content

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

VIEW: JG.JG_ZZ_VAT_TRX_DETAILS#

Object Details
Object Name: JG_ZZ_VAT_TRX_DETAILS#
Object Type: VIEW
Owner: JG
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
VAT_TRANSACTION_ID NUMBER (15) Yes
REPORTING_STATUS_ID NUMBER (15) Yes
SELECTION_PROCESS_ID NUMBER (15) Yes
FINAL_REPORTING_ID NUMBER (15)
REP_ENTITY_ID NUMBER (15)
REP_CONTEXT_ENTITY_NAME VARCHAR2 (240)
REP_CONTEXT_ENTITY_LOCATION_ID NUMBER (15)
TAXPAYER_ID VARCHAR2 (30)
ORG_INFORMATION2 VARCHAR2 (150)
ACTIVITY_CODE VARCHAR2 (150)
LEDGER_ID NUMBER (15)
LEDGER_NAME VARCHAR2 (30)
CHART_OF_ACCOUNTS_ID NUMBER (15)
EXTRACT_SOURCE_LEDGER VARCHAR2 (30)
ESTABLISHMENT_ID NUMBER

INTERNAL_ORGANIZATION_ID NUMBER

APPLICATION_ID NUMBER

ENTITY_CODE VARCHAR2 (30)
EVENT_CLASS_CODE VARCHAR2 (30)
TRX_ID NUMBER (15)
TRX_NUMBER VARCHAR2 (150)
TRX_DESCRIPTION VARCHAR2 (240)
TRX_CURRENCY_CODE VARCHAR2 (15)
TRX_TYPE_ID NUMBER (15)
TRX_TYPE_MNG VARCHAR2 (80)
TRX_LINE_ID NUMBER (15)
TRX_LINE_NUMBER NUMBER

TRX_LINE_DESCRIPTION VARCHAR2 (240)
TRX_LEVEL_TYPE VARCHAR2 (30)
TRX_LINE_TYPE VARCHAR2 (30)
TRX_LINE_CLASS VARCHAR2 (30)
TRX_CLASS_MNG VARCHAR2 (80)
TRX_DATE DATE

TRX_DUE_DATE DATE

TRX_COMMUNICATED_DATE DATE

PRODUCT_ID NUMBER

FUNCTIONAL_CURRENCY_CODE VARCHAR2 (30)
CURRENCY_CONVERSION_TYPE VARCHAR2 (30)
CURRENCY_CONVERSION_DATE DATE

CURRENCY_CONVERSION_RATE NUMBER

TERRITORY_SHORT_NAME VARCHAR2 (80)
DOC_SEQ_ID NUMBER (15)
DOC_SEQ_NAME VARCHAR2 (150)
DOC_SEQ_VALUE VARCHAR2 (240)
TRX_LINE_AMT NUMBER

RECEIPT_CLASS_ID NUMBER (15)
APPLIED_FROM_APPLICATION_ID NUMBER (15)
APPLIED_FROM_ENTITY_CODE VARCHAR2 (30)
APPLIED_FROM_EVENT_CLASS_CODE VARCHAR2 (30)
APPLIED_FROM_TRX_ID NUMBER (15)
APPLIED_FROM_LINE_ID NUMBER (15)
APPLIED_FROM_TRX_NUMBER VARCHAR2 (150)
APPLIED_TO_APPLICATION_ID NUMBER (15)
APPLIED_TO_ENTITY_CODE VARCHAR2 (30)
APPLIED_TO_EVENT_CLASS_CODE VARCHAR2 (30)
APPLIED_TO_TRX_ID NUMBER (15)
APPLIED_TO_TRX_LINE_ID NUMBER (15)
APPLIED_TO_TRX_NUMBER VARCHAR2 (150)
ADJUSTED_DOC_APPLICATION_ID NUMBER (15)
ADJUSTED_DOC_ENTITY_CODE VARCHAR2 (30)
ADJUSTED_DOC_EVENT_CLASS_CODE VARCHAR2 (30)
ADJUSTED_DOC_TRX_ID NUMBER (15)
ADJUSTED_DOC_NUMBER VARCHAR2 (150)
ADJUSTED_DOC_DATE DATE

REF_DOC_APPLICATION_ID NUMBER (15)
REF_DOC_ENTITY_CODE VARCHAR2 (30)
REF_DOC_EVENT_CLASS_CODE VARCHAR2 (30)
REF_DOC_TRX_ID NUMBER (15)
REF_DOC_LINE_ID NUMBER (15)
MERCHANT_PARTY_DOCUMENT_NUMBER VARCHAR2 (150)
MERCHANT_PARTY_NAME VARCHAR2 (150)
MERCHANT_PARTY_REFERENCE VARCHAR2 (250)
MERCHANT_PARTY_TAX_REG_NUMBER VARCHAR2 (150)
MERCHANT_PARTY_TAXPAYER_ID VARCHAR2 (150)
START_EXPENSE_DATE DATE

TAXABLE_LINE_SOURCE_TABLE VARCHAR2 (30)
TAX_LINE_ID NUMBER (15)
TAX_LINE_NUMBER NUMBER

TAX_INVOICE_DATE DATE

TAXABLE_AMT NUMBER

TAXABLE_AMT_FUNCL_CURR NUMBER

TAX_AMT NUMBER

TAX_AMT_FUNCL_CURR NUMBER

REC_TAX_AMT_TAX_CURR NUMBER

NREC_TAX_AMT_TAX_CURR NUMBER

TAXABLE_DISC_AMT NUMBER

TAXABLE_DISC_AMT_FUNCL_CURR NUMBER

TAX_DISC_AMT NUMBER

TAX_DISC_AMT_FUNCL_CURR NUMBER

TAX_RATE_ID NUMBER (15)
TAX_RATE_CODE VARCHAR2 (150)
TAX_RATE NUMBER

TAX_RATE_CODE_NAME VARCHAR2 (240)
TAX_RATE_CODE_DESCRIPTION VARCHAR2 (240)
TAX_RATE_VAT_TRX_TYPE_CODE VARCHAR2 (30)
TAX_RATE_VAT_TRX_TYPE_DESC VARCHAR2 (240)
TAX_RATE_CODE_VAT_TRX_TYPE_MNG VARCHAR2 (240)
TAX_RATE_REGISTER_TYPE_CODE VARCHAR2 (30)
TAX_TYPE_CODE VARCHAR2 (30)
TAX_TYPE_MNG VARCHAR2 (80)
TAX_RECOVERY_RATE NUMBER

TAX_REGIME_CODE VARCHAR2 (30)
TAX VARCHAR2 (30)
TAX_JURISDICTION_CODE VARCHAR2 (30)
TAX_STATUS_ID NUMBER (15)
TAX_STATUS_CODE VARCHAR2 (30)
TAX_CURRENCY_CODE VARCHAR2 (30)
OFFSET_TAX_RATE_CODE VARCHAR2 (30)
BILLING_TP_NAME VARCHAR2 (360)
BILLING_TP_NUMBER VARCHAR2 (240)
BILLING_TP_TAX_REG_NUM VARCHAR2 (50)
BILLING_TP_TAXPAYER_ID VARCHAR2 (50)
BILLING_TP_PARTY_NUMBER VARCHAR2 (30)
BILLING_TRADING_PARTNER_ID NUMBER (15)
BILLING_TP_TAX_REPORTING_FLAG VARCHAR2 (1)
BILLING_TP_SITE_ID NUMBER (15)
BILLING_TP_ADDRESS_ID NUMBER (15)
BILLING_TP_SITE_NAME VARCHAR2 (40)
BILLING_TP_SITE_TAX_REG_NUM VARCHAR2 (50)
SHIPPING_TP_NAME VARCHAR2 (360)
SHIPPING_TP_NUMBER VARCHAR2 (60)
SHIPPING_TP_TAX_REG_NUM VARCHAR2 (50)
SHIPPING_TP_TAXPAYER_ID VARCHAR2 (50)
SHIPPING_TRADING_PARTNER_ID NUMBER (15)
SHIPPING_TP_SITE_ID NUMBER (15)
SHIPPING_TP_ADDRESS_ID NUMBER (15)
SHIPPING_TP_SITE_NAME VARCHAR2 (40)
SHIPPING_TP_SITE_TAX_REG_NUM VARCHAR2 (50)
BILL_FROM_PARTY_ID NUMBER (15)
BILL_FROM_PARTY_SITE_ID NUMBER (15)
BANKING_TP_NAME VARCHAR2 (360)
BANKING_TP_TAXPAYER_ID VARCHAR2 (50)
BANK_ACCOUNT_NAME VARCHAR2 (80)
BANK_ACCOUNT_NUM VARCHAR2 (30)
BANK_ACCOUNT_ID NUMBER (15)
BANK_BRANCH_ID NUMBER (15)
HQ_ESTB_REG_NUMBER VARCHAR2 (30)
TAX_LINE_REGISTRATION_NUMBER VARCHAR2 (50)
CANCELLED_DATE DATE

CANCEL_FLAG VARCHAR2 (1)
OFFSET_FLAG VARCHAR2 (1)
POSTED_FLAG VARCHAR2 (1)
MRC_TAX_LINE_FLAG VARCHAR2 (1)
RECONCILIATION_FLAG VARCHAR2 (1)
TAX_RECOVERABLE_FLAG VARCHAR2 (1)
REVERSE_FLAG VARCHAR2 (1)
CORRECTION_FLAG VARCHAR2 (1)
AR_CASH_RECEIPT_REVERSE_STATUS VARCHAR2 (30)
AR_CASH_RECEIPT_REVERSE_DATE DATE

PAYABLES_INVOICE_SOURCE VARCHAR2 (50)
ACCTD_AMOUNT_DR NUMBER

ACCTD_AMOUNT_CR NUMBER

REC_APPLICATION_STATUS VARCHAR2 (30)
VAT_COUNTRY_CODE VARCHAR2 (50)
INVOICE_IDENTIFIER VARCHAR2 (20)
ACCOUNT_CLASS VARCHAR2 (20)
LATEST_REC_FLAG VARCHAR2 (1)
JGZZ_FISCAL_CODE VARCHAR2 (50)
TAX_REFERENCE VARCHAR2 (50)
PT_LOCATION VARCHAR2 (25)
INVOICE_REPORT_TYPE VARCHAR2 (150)
ES_CORRECTION_YEAR VARCHAR2 (25)
ES_CORRECTION_PERIOD VARCHAR2 (25)
TRIANGULATION VARCHAR2 (240)
DOCUMENT_SUB_TYPE VARCHAR2 (240)
ASSESSABLE_VALUE NUMBER

PROPERTY_LOCATION VARCHAR2 (240)
CHK_VAT_AMOUNT_PAID VARCHAR2 (25)
IMPORT_DOCUMENT_NUMBER VARCHAR2 (240)
IMPORT_DOCUMENT_DATE DATE

PRL_NO VARCHAR2 (25)
PROPERTY_RENTAL VARCHAR2 (25)
RATES_REFERENCE VARCHAR2 (25)
STAIR_NUM VARCHAR2 (240)
FLOOR_NUM VARCHAR2 (240)
DOOR_NUM VARCHAR2 (240)
AMOUNT_APPLIED NUMBER

ACTG_EVENT_TYPE_CODE VARCHAR2 (30)
ACTG_EVENT_TYPE_MNG VARCHAR2 (240)
ACTG_EVENT_NUMBER NUMBER

ACTG_EVENT_STATUS_FLAG VARCHAR2 (1)
ACTG_EVENT_STATUS_MNG VARCHAR2 (240)
ACTG_CATEGORY_CODE VARCHAR2 (30)
ACTG_CATEGORY_MNG VARCHAR2 (240)
ACCOUNTING_DATE DATE

GL_TRANSFER_FLAG VARCHAR2 (1)
ACTG_LINE_NUM NUMBER (15)
ACTG_LINE_TYPE_CODE VARCHAR2 (30)
ACTG_LINE_TYPE_MNG VARCHAR2 (240)
ACTG_LINE_DESCRIPTION VARCHAR2 (1996)
ACTG_STAT_AMT NUMBER

ACTG_PARTY_ID NUMBER (15)
ACTG_PARTY_SITE_ID NUMBER (15)
ACTG_PARTY_TYPE VARCHAR2 (30)
ACTG_EVENT_ID NUMBER (15)
ACTG_HEADER_ID NUMBER

ACTG_LINE_ID NUMBER (15)
ACTG_SOURCE_ID NUMBER (15)
ACTG_SOURCE_TABLE VARCHAR2 (30)
ACTG_LINE_CCID NUMBER (15)
ACCOUNT_FLEXFIELD VARCHAR2 (2000)
ACCOUNT_DESCRIPTION VARCHAR2 (1996)
PERIOD_NAME VARCHAR2 (30)
TRX_ARAP_BALANCING_SEGMENT VARCHAR2 (240)
TRX_ARAP_NATURAL_ACCOUNT VARCHAR2 (240)
TRX_TAXABLE_BALANCING_SEGMENT VARCHAR2 (240)
TRX_TAXABLE_NATURAL_ACCOUNT VARCHAR2 (240)
TRX_TAX_BALANCING_SEGMENT VARCHAR2 (240)
TRX_TAX_NATURAL_ACCOUNT VARCHAR2 (240)
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

OBJECT_VERSION_NUMBER NUMBER
Yes
GL_DATE DATE

TRX_CONTROL_ACCOUNT_FLEXFIELD VARCHAR2 (2000)
TAX_ORIGIN VARCHAR2 (30)
REPORTING_CODE VARCHAR2 (60)
DEF_REC_SETTLEMENT_OPTION_CODE VARCHAR2 (30)
IL_VAT_REP_STATUS_ID NUMBER (15)
TAXABLE_ITEM_SOURCE_ID NUMBER (15)
INTRA_EU_TRX_TYPE_CODE VARCHAR2 (150)
Query Text

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


SELECT VAT_TRANSACTION_ID
,      REPORTING_STATUS_ID
,      SELECTION_PROCESS_ID
,      FINAL_REPORTING_ID
,      REP_ENTITY_ID
,      REP_CONTEXT_ENTITY_NAME
,      REP_CONTEXT_ENTITY_LOCATION_ID
,      TAXPAYER_ID
,      ORG_INFORMATION2
,      LEGAL_AUTHORITY_NAME
,      LEGAL_AUTH_ADDRESS_LINE2
,      LEGAL_AUTH_ADDRESS_LINE3
,      LEGAL_AUTH_CITY
,      LEGAL_CONTACT_PARTY_NAME
,      ACTIVITY_CODE
,      LEDGER_ID
,      LEDGER_NAME
,      CHART_OF_ACCOUNTS_ID
,      EXTRACT_SOURCE_LEDGER
,      ESTABLISHMENT_ID
,      INTERNAL_ORGANIZATION_ID
,      APPLICATION_ID
,      ENTITY_CODE
,      EVENT_CLASS_CODE
,      TRX_ID
,      TRX_NUMBER
,      TRX_DESCRIPTION
,      TRX_CURRENCY_CODE
,      TRX_TYPE_ID
,      TRX_TYPE_MNG
,      TRX_LINE_ID
,      TRX_LINE_NUMBER
,      TRX_LINE_DESCRIPTION
,      TRX_LEVEL_TYPE
,      TRX_LINE_TYPE
,      TRX_LINE_CLASS
,      TRX_CLASS_MNG
,      TRX_DATE
,      TRX_DUE_DATE
,      TRX_COMMUNICATED_DATE
,      PRODUCT_ID
,      FUNCTIONAL_CURRENCY_CODE
,      CURRENCY_CONVERSION_TYPE
,      CURRENCY_CONVERSION_DATE
,      CURRENCY_CONVERSION_RATE
,      TERRITORY_SHORT_NAME
,      DOC_SEQ_ID
,      DOC_SEQ_NAME
,      DOC_SEQ_VALUE
,      TRX_LINE_AMT
,      RECEIPT_CLASS_ID
,      APPLIED_FROM_APPLICATION_ID
,      APPLIED_FROM_ENTITY_CODE
,      APPLIED_FROM_EVENT_CLASS_CODE
,      APPLIED_FROM_TRX_ID
,      APPLIED_FROM_LINE_ID
,      APPLIED_FROM_TRX_NUMBER
,      APPLIED_TO_APPLICATION_ID
,      APPLIED_TO_ENTITY_CODE
,      APPLIED_TO_EVENT_CLASS_CODE
,      APPLIED_TO_TRX_ID
,      APPLIED_TO_TRX_LINE_ID
,      APPLIED_TO_TRX_NUMBER
,      ADJUSTED_DOC_APPLICATION_ID
,      ADJUSTED_DOC_ENTITY_CODE
,      ADJUSTED_DOC_EVENT_CLASS_CODE
,      ADJUSTED_DOC_TRX_ID
,      ADJUSTED_DOC_NUMBER
,      ADJUSTED_DOC_DATE
,      REF_DOC_APPLICATION_ID
,      REF_DOC_ENTITY_CODE
,      REF_DOC_EVENT_CLASS_CODE
,      REF_DOC_TRX_ID
,      REF_DOC_LINE_ID
,      MERCHANT_PARTY_DOCUMENT_NUMBER
,      MERCHANT_PARTY_NAME
,      MERCHANT_PARTY_REFERENCE
,      MERCHANT_PARTY_TAX_REG_NUMBER
,      MERCHANT_PARTY_TAXPAYER_ID
,      START_EXPENSE_DATE
,      TAXABLE_LINE_SOURCE_TABLE
,      TAX_LINE_ID
,      TAX_LINE_NUMBER
,      TAX_INVOICE_DATE
,      TAXABLE_AMT
,      TAXABLE_AMT_FUNCL_CURR
,      TAX_AMT
,      TAX_AMT_FUNCL_CURR
,      REC_TAX_AMT_TAX_CURR
,      NREC_TAX_AMT_TAX_CURR
,      TAXABLE_DISC_AMT
,      TAXABLE_DISC_AMT_FUNCL_CURR
,      TAX_DISC_AMT
,      TAX_DISC_AMT_FUNCL_CURR
,      TAX_RATE_ID
,      TAX_RATE_CODE
,      TAX_RATE
,      TAX_RATE_CODE_NAME
,      TAX_RATE_CODE_DESCRIPTION
,      TAX_RATE_VAT_TRX_TYPE_CODE
,      TAX_RATE_VAT_TRX_TYPE_DESC
,      TAX_RATE_CODE_VAT_TRX_TYPE_MNG
,      TAX_RATE_REGISTER_TYPE_CODE
,      TAX_TYPE_CODE
,      TAX_TYPE_MNG
,      TAX_RECOVERY_RATE
,      TAX_REGIME_CODE
,      TAX
,      TAX_JURISDICTION_CODE
,      TAX_STATUS_ID
,      TAX_STATUS_CODE
,      TAX_CURRENCY_CODE
,      OFFSET_TAX_RATE_CODE
,      BILLING_TP_NAME
,      BILLING_TP_NUMBER
,      BILLING_TP_TAX_REG_NUM
,      BILLING_TP_TAXPAYER_ID
,      BILLING_TP_PARTY_NUMBER
,      BILLING_TRADING_PARTNER_ID
,      BILLING_TP_TAX_REPORTING_FLAG
,      BILLING_TP_SITE_ID
,      BILLING_TP_ADDRESS_ID
,      BILLING_TP_SITE_NAME
,      BILLING_TP_SITE_TAX_REG_NUM
,      SHIPPING_TP_NAME
,      SHIPPING_TP_NUMBER
,      SHIPPING_TP_TAX_REG_NUM
,      SHIPPING_TP_TAXPAYER_ID
,      SHIPPING_TRADING_PARTNER_ID
,      SHIPPING_TP_SITE_ID
,      SHIPPING_TP_ADDRESS_ID
,      SHIPPING_TP_SITE_NAME
,      SHIPPING_TP_SITE_TAX_REG_NUM
,      BILL_FROM_PARTY_ID
,      BILL_FROM_PARTY_SITE_ID
,      BANKING_TP_NAME
,      BANKING_TP_TAXPAYER_ID
,      BANK_ACCOUNT_NAME
,      BANK_ACCOUNT_NUM
,      BANK_ACCOUNT_ID
,      BANK_BRANCH_ID
,      LEGAL_ENTITY_TAX_REG_NUMBER
,      HQ_ESTB_REG_NUMBER
,      TAX_LINE_REGISTRATION_NUMBER
,      CANCELLED_DATE
,      CANCEL_FLAG
,      OFFSET_FLAG
,      POSTED_FLAG
,      MRC_TAX_LINE_FLAG
,      RECONCILIATION_FLAG
,      TAX_RECOVERABLE_FLAG
,      REVERSE_FLAG
,      CORRECTION_FLAG
,      AR_CASH_RECEIPT_REVERSE_STATUS
,      AR_CASH_RECEIPT_REVERSE_DATE
,      PAYABLES_INVOICE_SOURCE
,      ACCTD_AMOUNT_DR
,      ACCTD_AMOUNT_CR
,      REC_APPLICATION_STATUS
,      VAT_COUNTRY_CODE
,      INVOICE_IDENTIFIER
,      ACCOUNT_CLASS
,      LATEST_REC_FLAG
,      JGZZ_FISCAL_CODE
,      TAX_REFERENCE
,      PT_LOCATION
,      INVOICE_REPORT_TYPE
,      ES_CORRECTION_YEAR
,      ES_CORRECTION_PERIOD
,      TRIANGULATION
,      DOCUMENT_SUB_TYPE
,      ASSESSABLE_VALUE
,      PROPERTY_LOCATION
,      CHK_VAT_AMOUNT_PAID
,      IMPORT_DOCUMENT_NUMBER
,      IMPORT_DOCUMENT_DATE
,      PRL_NO
,      PROPERTY_RENTAL
,      RATES_REFERENCE
,      STAIR_NUM
,      FLOOR_NUM
,      DOOR_NUM
,      AMOUNT_APPLIED
,      ACTG_EVENT_TYPE_CODE
,      ACTG_EVENT_TYPE_MNG
,      ACTG_EVENT_NUMBER
,      ACTG_EVENT_STATUS_FLAG
,      ACTG_EVENT_STATUS_MNG
,      ACTG_CATEGORY_CODE
,      ACTG_CATEGORY_MNG
,      ACCOUNTING_DATE
,      GL_TRANSFER_FLAG
,      ACTG_LINE_NUM
,      ACTG_LINE_TYPE_CODE
,      ACTG_LINE_TYPE_MNG
,      ACTG_LINE_DESCRIPTION
,      ACTG_STAT_AMT
,      ACTG_PARTY_ID
,      ACTG_PARTY_SITE_ID
,      ACTG_PARTY_TYPE
,      ACTG_EVENT_ID
,      ACTG_HEADER_ID
,      ACTG_LINE_ID
,      ACTG_SOURCE_ID
,      ACTG_SOURCE_TABLE
,      ACTG_LINE_CCID
,      ACCOUNT_FLEXFIELD
,      ACCOUNT_DESCRIPTION
,      PERIOD_NAME
,      TRX_ARAP_BALANCING_SEGMENT
,      TRX_ARAP_NATURAL_ACCOUNT
,      TRX_TAXABLE_BALANCING_SEGMENT
,      TRX_TAXABLE_NATURAL_ACCOUNT
,      TRX_TAX_BALANCING_SEGMENT
,      TRX_TAX_NATURAL_ACCOUNT
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_LOGIN_ID
,      OBJECT_VERSION_NUMBER
,      GL_DATE
,      TRX_CONTROL_ACCOUNT_FLEXFIELD
,      TAX_ORIGIN
,      REPORTING_CODE
,      DEF_REC_SETTLEMENT_OPTION_CODE
,      IL_VAT_REP_STATUS_ID
,      TAXABLE_ITEM_SOURCE_ID
,      INTRA_EU_TRX_TYPE_CODE
FROM JG.JG_ZZ_VAT_TRX_DETAILS#;

Dependencies

[top of page]

JG.JG_ZZ_VAT_TRX_DETAILS# references the following:

SchemaJG
TableJG_ZZ_VAT_TRX_DETAILS
JG.JG_ZZ_VAT_TRX_DETAILS# is referenced by following:

SchemaAPPS
SynonymJG_ZZ_VAT_TRX_DETAILS