[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | JG_ZZ_VAT_TRX_DETAILS# |
|---|---|
| Object Type: | VIEW |
| Owner: | JG |
| Subobject Name: | |
| Status: | VALID |
| 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) | ||
| LEGAL_AUTHORITY_NAME | VARCHAR2 | (360) | ||
| LEGAL_AUTH_ADDRESS_LINE2 | VARCHAR2 | (240) | ||
| LEGAL_AUTH_ADDRESS_LINE3 | VARCHAR2 | (240) | ||
| LEGAL_AUTH_CITY | VARCHAR2 | (60) | ||
| LEGAL_CONTACT_PARTY_NAME | VARCHAR2 | (360) | ||
| 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) | ||
| LEGAL_ENTITY_TAX_REG_NUMBER | VARCHAR2 | (80) | ||
| 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) |
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#;
JG
JG_ZZ_VAT_TRX_DETAILS
APPS
JG_ZZ_VAT_TRX_DETAILS
|
|
|
|