[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | JG_ZZ_VAT_TRX_DETAILS |
|---|---|
| Object Type: | TABLE |
| Owner: | JG |
| FND Design Data: |  JG.JG_ZZ_VAT_TRX_DETAILS
|
| Subobject Name: | |
| Status: | VALID |
JG_ZZ_VAT_TRX_DETAILS contains all transactions selected for VAT reporting. The transaction is inserted in the table once for each TRN, LE, Regime, Period, Source combination. The EMEA VAT processing features such as Allocation Rules, Final Reporting etc will update information in this table. It can be used as a source for audits on what information was reported to the Tax authorities at any point in time.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| JG_ZZ_VAT_TRX_DETAILS_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 VAT_TRANSACTION_ID
|
| JG_ZZ_VAT_TRX_DETAILS_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
REPORTING_STATUS_ID
|
| JG_ZZ_VAT_TRX_DETAILS_N2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
APPLICATION_ID
EVENT_CLASS_CODE
ENTITY_CODE
TRX_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| VAT_TRANSACTION_ID | NUMBER | (15) | Yes | Primary Key - Sequence generated |
| REPORTING_STATUS_ID | NUMBER | (15) | Yes | Reporting status identifier . Foreign Key for jg_zz_rep_status table. |
| SELECTION_PROCESS_ID | NUMBER | (15) | Yes | Selection Process Identifier. Foreign Key for JG_ZZ_REP_STATUS table |
| FINAL_REPORTING_ID | NUMBER | (15) | Final Process Identifier. Foreign Key for JG_ZZ_REP_STATUS table | |
| REP_ENTITY_ID | NUMBER | (15) | Legal Entity Identifier or Operating Unit identifier | |
| REP_CONTEXT_ENTITY_NAME | VARCHAR2 | (240) | Legal Entity Name or Operating Unit Name | |
| REP_CONTEXT_ENTITY_LOCATION_ID | NUMBER | (15) | Location identifier of the Legal Entity or Operating Unit | |
| TAXPAYER_ID | VARCHAR2 | (30) | First Party TaxpayerID | |
| ORG_INFORMATION2 | VARCHAR2 | (150) | Tax Registration Number of OU | |
| LEGAL_AUTHORITY_NAME | VARCHAR2 | (360) | Legal Authority Name | |
| LEGAL_AUTH_ADDRESS_LINE2 | VARCHAR2 | (240) | Legal Authority Address information | |
| LEGAL_AUTH_ADDRESS_LINE3 | VARCHAR2 | (240) | Legal Authority Address information | |
| LEGAL_AUTH_CITY | VARCHAR2 | (60) | Legal Authority Address information | |
| LEGAL_CONTACT_PARTY_NAME | VARCHAR2 | (360) | Legal Contact Name | |
| ACTIVITY_CODE | VARCHAR2 | (150) | Activity Code | |
| LEDGER_ID | NUMBER | (15) | Ledger (Set of books) identifier | |
| LEDGER_NAME | VARCHAR2 | (30) | Ledger Name | |
| CHART_OF_ACCOUNTS_ID | NUMBER | (15) | Chart of Accounts identifier | |
| EXTRACT_SOURCE_LEDGER | VARCHAR2 | (30) | Identifies the source ledger for this line. Can be one of AP, AR, GL | |
| ESTABLISHMENT_ID | NUMBER | Establishment identifier of the first party | ||
| INTERNAL_ORGANIZATION_ID | NUMBER | Identifier of the internal organization for which a transaction is processed. | ||
| APPLICATION_ID | NUMBER | Application identifier of the transaction | ||
| ENTITY_CODE | VARCHAR2 | (30) | Entity Code | |
| EVENT_CLASS_CODE | VARCHAR2 | (30) | Lookup code for XLA event class code. | |
| TRX_ID | NUMBER | (15) | The transaction header identifier, identifying the transaction extracted. | |
| TRX_NUMBER | VARCHAR2 | (150) | The transaction number. | |
| TRX_DESCRIPTION | VARCHAR2 | (240) | Description for the transaction. | |
| TRX_CURRENCY_CODE | VARCHAR2 | (15) | Transaction currency code | |
| TRX_TYPE_ID | NUMBER | (15) | Internal identifier used to control the receivable transaction type. | |
| TRX_TYPE_MNG | VARCHAR2 | (80) | Meaning of Transaction type. | |
| TRX_LINE_ID | NUMBER | (15) | Identifier of the lowest level for which tax is calculated. | |
| TRX_LINE_NUMBER | NUMBER | Transaction line number | ||
| TRX_LINE_DESCRIPTION | VARCHAR2 | (240) | Enter Comments Here | |
| TRX_LEVEL_TYPE | VARCHAR2 | (30) | Transaction level type.Values can be HEADER, LINE, FREIGHT or SHIPMENT. | |
| TRX_LINE_TYPE | VARCHAR2 | (30) | Identifies the line type of a transaction line. | |
| TRX_LINE_CLASS | VARCHAR2 | (30) | Event class for the transaction line. | |
| TRX_CLASS_MNG | VARCHAR2 | (80) | Meaning of Transaction class | |
| TRX_DATE | DATE | Transaction date | ||
| TRX_DUE_DATE | DATE | Payment due date of the transaction. | ||
| TRX_COMMUNICATED_DATE | DATE | Printed/Received date of the transaction. | ||
| PRODUCT_ID | NUMBER | Internal identifier of the inventory item or memo line used in transaction line. | ||
| FUNCTIONAL_CURRENCY_CODE | VARCHAR2 | (30) | Functional currency code | |
| CURRENCY_CONVERSION_TYPE | VARCHAR2 | (30) | The exchange rate type used to convert the transaction currency to functional. | |
| CURRENCY_CONVERSION_DATE | DATE | The date used to lookup the exchange rate. | ||
| CURRENCY_CONVERSION_RATE | NUMBER | The exchange rate used to convert the transaction currency to the functional. | ||
| TERRITORY_SHORT_NAME | VARCHAR2 | (80) | Territory Short Name | |
| DOC_SEQ_ID | NUMBER | (15) | Internal identifier of the sequence name used in the transaction. | |
| DOC_SEQ_NAME | VARCHAR2 | (150) | Name of the sequence used in the transaction. | |
| DOC_SEQ_VALUE | VARCHAR2 | (240) | Document sequence number for the transaction. | |
| TRX_LINE_AMT | NUMBER | Transaction line amount. | ||
| RECEIPT_CLASS_ID | NUMBER | (15) | Receipt Class Identifier. | |
| APPLIED_FROM_APPLICATION_ID | NUMBER | (15) | Only AP. Application Id for the Applied from document. | |
| APPLIED_FROM_ENTITY_CODE | VARCHAR2 | (30) | Entity Code for the Applied From document | |
| APPLIED_FROM_EVENT_CLASS_CODE | VARCHAR2 | (30) | Event class code for the Applied From document. | |
| APPLIED_FROM_TRX_ID | NUMBER | (15) | Internal Unique Identifier used to identify the Applied From document. | |
| APPLIED_FROM_LINE_ID | NUMBER | (15) | Identifier of the lowest level for which tax is calculated. | |
| APPLIED_FROM_TRX_NUMBER | VARCHAR2 | (150) | Transaction Number for the Applied From document. | |
| APPLIED_TO_APPLICATION_ID | NUMBER | (15) | Application Id for the Applied To document. | |
| APPLIED_TO_ENTITY_CODE | VARCHAR2 | (30) | Entity Code for the Applied To document. | |
| APPLIED_TO_EVENT_CLASS_CODE | VARCHAR2 | (30) | Event class for the Applied To document. | |
| APPLIED_TO_TRX_ID | NUMBER | (15) | The internal Id used to identify the Applied to document Name | |
| APPLIED_TO_TRX_LINE_ID | NUMBER | (15) | The internal line Id used to identify the Applied to document Name | |
| APPLIED_TO_TRX_NUMBER | VARCHAR2 | (150) | Transaction Number for the Applied To document. | |
| ADJUSTED_DOC_APPLICATION_ID | NUMBER | (15) | Adjusted document application identifier | |
| ADJUSTED_DOC_ENTITY_CODE | VARCHAR2 | (30) | Adjusted document entity code. | |
| ADJUSTED_DOC_EVENT_CLASS_CODE | VARCHAR2 | (30) | Adjusted document event class code. | |
| ADJUSTED_DOC_TRX_ID | NUMBER | (15) | Adjusted document transaction identifier | |
| ADJUSTED_DOC_NUMBER | VARCHAR2 | (150) | The Adjusted to transaction number | |
| ADJUSTED_DOC_DATE | DATE | The Adjusted to transaction date | ||
| REF_DOC_APPLICATION_ID | NUMBER | (15) | Reference document application identifier. | |
| REF_DOC_ENTITY_CODE | VARCHAR2 | (30) | Reference document entity code. | |
| REF_DOC_EVENT_CLASS_CODE | VARCHAR2 | (30) | Reference document event class code. | |
| REF_DOC_TRX_ID | NUMBER | (15) | Identifier for the reference document header | |
| REF_DOC_LINE_ID | NUMBER | (15) | Identifier of the lowest level for which tax is calculated. | |
| MERCHANT_PARTY_DOCUMENT_NUMBER | VARCHAR2 | (150) | Merchant party document number recorded on the Payables expense report | |
| MERCHANT_PARTY_NAME | VARCHAR2 | (150) | Merchant party name recorded on the Payables expense report | |
| MERCHANT_PARTY_REFERENCE | VARCHAR2 | (250) | Merchant party reference recorded on the Payables expense report | |
| MERCHANT_PARTY_TAX_REG_NUMBER | VARCHAR2 | (150) | Merchant party tax registration number recorded on the Payables expense report | |
| MERCHANT_PARTY_TAXPAYER_ID | VARCHAR2 | (150) | Merchant party taxpayer id recorded on the Payables expense report | |
| START_EXPENSE_DATE | DATE | Start Expense Date | ||
| TAXABLE_LINE_SOURCE_TABLE | VARCHAR2 | (30) | Identifies the taxable Source Table name. | |
| TAX_LINE_ID | NUMBER | (15) | Tax line Identifier for transactions. | |
| TAX_LINE_NUMBER | NUMBER | Tax line number for transactions. | ||
| TAX_INVOICE_DATE | DATE | Tax Reporting Date | ||
| TAXABLE_AMT | NUMBER | Taxable amount in transaction currency | ||
| TAXABLE_AMT_FUNCL_CURR | NUMBER | Taxable amount in functional currency | ||
| TAX_AMT | NUMBER | Tax amount in transaction currency | ||
| TAX_AMT_FUNCL_CURR | NUMBER | Tax amount in functional currency | ||
| REC_TAX_AMT_TAX_CURR | NUMBER | Total recoverable tax amount in tax currency | ||
| NREC_TAX_AMT_TAX_CURR | NUMBER | Total non-recoverable tax amount in tax currency | ||
| TAXABLE_DISC_AMT | NUMBER | Taxable Discount amount in transaction currency | ||
| TAXABLE_DISC_AMT_FUNCL_CURR | NUMBER | Taxable Discount amount in functional currency | ||
| TAX_DISC_AMT | NUMBER | Tax Discount Amount in Transaction Currency | ||
| TAX_DISC_AMT_FUNCL_CURR | NUMBER | Tax Discount Amount in Functional Currency | ||
| TAX_RATE_ID | NUMBER | (15) | Internal identifier for tax rate | |
| TAX_RATE_CODE | VARCHAR2 | (150) | Tax rate name associated with the tax rate identifier. | |
| TAX_RATE | NUMBER | The rate specified for a tax status in effect for a period of time | ||
| TAX_RATE_CODE_NAME | VARCHAR2 | (240) | Tax Rate Code Name | |
| TAX_RATE_CODE_DESCRIPTION | VARCHAR2 | (240) | Tax Rate Code description | |
| TAX_RATE_VAT_TRX_TYPE_CODE | VARCHAR2 | (30) | VAT Transaction type Code for the Tax Rate | |
| TAX_RATE_VAT_TRX_TYPE_DESC | VARCHAR2 | (240) | Description of VAT Transaction type Code for the Tax Rate | |
| TAX_RATE_CODE_VAT_TRX_TYPE_MNG | VARCHAR2 | (240) | Meaning associated with VAT Transaction Type code for the Tax Rate | |
| TAX_RATE_REGISTER_TYPE_CODE | VARCHAR2 | (30) | Tax rate Register Type | |
| TAX_TYPE_CODE | VARCHAR2 | (30) | Tax rate type code | |
| TAX_TYPE_MNG | VARCHAR2 | (80) | Enter Comments Here | |
| TAX_RECOVERY_RATE | NUMBER | Tax Recovery rate | ||
| TAX_REGIME_CODE | VARCHAR2 | (30) | Tax Regime code | |
| TAX | VARCHAR2 | (30) | Tax | |
| TAX_JURISDICTION_CODE | VARCHAR2 | (30) | Tax Jurisdiction code | |
| TAX_STATUS_ID | NUMBER | (15) | Internal identifier of Tax status. | |
| TAX_STATUS_CODE | VARCHAR2 | (30) | Tax status code. | |
| TAX_CURRENCY_CODE | VARCHAR2 | (30) | Tax Currency code | |
| OFFSET_TAX_RATE_CODE | VARCHAR2 | (30) | Offset Tax Rate Code | |
| BILLING_TP_NAME | VARCHAR2 | (360) | The Ship to Customer Name, used only for Receivable Transactions | |
| BILLING_TP_NUMBER | VARCHAR2 | (240) | Number of the trading partner (customer or supplier). | |
| BILLING_TP_TAX_REG_NUM | VARCHAR2 | (50) | Billing Trading partner Tax registration number | |
| BILLING_TP_TAXPAYER_ID | VARCHAR2 | (50) | Taxpayer Identifier of the trading partner (customer or supplier). | |
| BILLING_TP_PARTY_NUMBER | VARCHAR2 | (30) | Customer or Supplier Number. | |
| BILLING_TRADING_PARTNER_ID | NUMBER | (15) | Billing Trading partner Identifier | |
| BILLING_TP_TAX_REPORTING_FLAG | VARCHAR2 | (1) | Billing Trading Partner Tax reporting Flag | |
| BILLING_TP_SITE_ID | NUMBER | (15) | Site Details | |
| BILLING_TP_ADDRESS_ID | NUMBER | (15) | Site Details | |
| BILLING_TP_SITE_NAME | VARCHAR2 | (40) | Site Details | |
| BILLING_TP_SITE_TAX_REG_NUM | VARCHAR2 | (50) | Site Details | |
| SHIPPING_TP_NAME | VARCHAR2 | (360) | The ShipTo Customer Number, used only for Receivables Transaction. | |
| SHIPPING_TP_NUMBER | VARCHAR2 | (60) | The ShipTo Customer name, used only for Receivables Transaction. | |
| SHIPPING_TP_TAX_REG_NUM | VARCHAR2 | (50) | The ShipTo Customer tax registration number, used only for AR transactions. | |
| SHIPPING_TP_TAXPAYER_ID | VARCHAR2 | (50) | The ShipTo Customer taxpayerId, used only for Receivables Transaction. | |
| SHIPPING_TRADING_PARTNER_ID | NUMBER | (15) | The ShipTo Customer Number, used only for Receivables Transaction. | |
| SHIPPING_TP_SITE_ID | NUMBER | (15) | Site Details | |
| SHIPPING_TP_ADDRESS_ID | NUMBER | (15) | Site Details | |
| SHIPPING_TP_SITE_NAME | VARCHAR2 | (40) | Site Details | |
| SHIPPING_TP_SITE_TAX_REG_NUM | VARCHAR2 | (50) | Site Details | |
| BILL_FROM_PARTY_ID | NUMBER | (15) | Supplier ID | |
| BILL_FROM_PARTY_SITE_ID | NUMBER | (15) | Enter Comments Here | |
| BANKING_TP_NAME | VARCHAR2 | (360) | Banking Trading Partner Name, (For AR Misc transactions alone). | |
| BANKING_TP_TAXPAYER_ID | VARCHAR2 | (50) | Banking Trading Partner TaxPayer Id, (For AR Misc transactions alone). | |
| BANK_ACCOUNT_NAME | VARCHAR2 | (80) | Back Account Name | |
| BANK_ACCOUNT_NUM | VARCHAR2 | (30) | Bank Account Number | |
| BANK_ACCOUNT_ID | NUMBER | (15) | Bank Account Identifier | |
| BANK_BRANCH_ID | NUMBER | (15) | Bank Branch Identifier | |
| LEGAL_ENTITY_TAX_REG_NUMBER | VARCHAR2 | (80) | Legal Entity Tax Reg Num | |
| HQ_ESTB_REG_NUMBER | VARCHAR2 | (30) | HQ establishment Tax Reg Num | |
| TAX_LINE_REGISTRATION_NUMBER | VARCHAR2 | (50) | Tax Line Tax Reg Num | |
| CANCELLED_DATE | DATE | Cancelled Date | ||
| CANCEL_FLAG | VARCHAR2 | (1) | Flag to indicate if the tax line is cancelled. | |
| OFFSET_FLAG | VARCHAR2 | (1) | Flag to indicate that the tax is a offset tax. | |
| POSTED_FLAG | VARCHAR2 | (1) | Flag to indicate that the tax distribution was posted | |
| MRC_TAX_LINE_FLAG | VARCHAR2 | (1) | Flag to indicate MRC tax line | |
| RECONCILIATION_FLAG | VARCHAR2 | (1) | Reconcilation Flag | |
| TAX_RECOVERABLE_FLAG | VARCHAR2 | (1) | Tax Recoverable flag | |
| REVERSE_FLAG | VARCHAR2 | (1) | It indicates a tax distribution reverses another Tax distribution. | |
| CORRECTION_FLAG | VARCHAR2 | (1) | Flag to indicate correction records | |
| AR_CASH_RECEIPT_REVERSE_STATUS | VARCHAR2 | (30) | Receipt Reverse status - Ar_cash_receipts.status | |
| AR_CASH_RECEIPT_REVERSE_DATE | DATE | Receipt Reverse date - Ar_cash_receipts. Reversal_Date | ||
| PAYABLES_INVOICE_SOURCE | VARCHAR2 | (50) | ap_invoices.source | |
| ACCTD_AMOUNT_DR | NUMBER | Ar_distributions. Acctd_amount_dr | ||
| ACCTD_AMOUNT_CR | NUMBER | Ar_distributions. Acctd_amount_cr | ||
| REC_APPLICATION_STATUS | VARCHAR2 | (30) | Ar_receivable_Applications.status | |
| VAT_COUNTRY_CODE | VARCHAR2 | (50) | Financial_system_parameters. Vat_country_code | |
| INVOICE_IDENTIFIER | VARCHAR2 | (20) | Gl_je_lines.invoice_identifier | |
| ACCOUNT_CLASS | VARCHAR2 | (20) | Ra_cust_trx_line_gl_dist.account_class | |
| LATEST_REC_FLAG | VARCHAR2 | (1) | Ra_cust_trx_line_gl_dist.latest_rec_flag | |
| JGZZ_FISCAL_CODE | VARCHAR2 | (50) | Hz_parties. Jgzz_fiscal_code - zx_rep_trx_detail_t.Billing_tp_taxpayer_id | |
| TAX_REFERENCE | VARCHAR2 | (50) | Hz_parties.Tax_reference - zx_rep_trx_detail_t.Billing_tp_tax_reg_num | |
| PT_LOCATION | VARCHAR2 | (25) | Portguese Location - Possible values are: A, C, M | |
| INVOICE_REPORT_TYPE | VARCHAR2 | (150) | Enter Comments Here | |
| ES_CORRECTION_YEAR | VARCHAR2 | (25) | Enter Comments Here | |
| ES_CORRECTION_PERIOD | VARCHAR2 | (25) | Spanish Correction Period | |
| TRIANGULATION | VARCHAR2 | (240) | Spanish Triangulation - ZX_LINES_DET_FACTORS.DOCUMENT_SUB_TYPE | |
| DOCUMENT_SUB_TYPE | VARCHAR2 | (240) | French Deduction Tax Rule - ZX_LINES_DET_FACTORS.DOCUMENT_SUB_TYPE | |
| ASSESSABLE_VALUE | NUMBER | Italian GDF, Self Invoice taxable amount | ||
| PROPERTY_LOCATION | VARCHAR2 | (240) | Spanish GDF Property Locations | |
| CHK_VAT_AMOUNT_PAID | VARCHAR2 | (25) | ECE VAT Registers GDF | |
| IMPORT_DOCUMENT_NUMBER | VARCHAR2 | (240) | Czech GDFs | |
| IMPORT_DOCUMENT_DATE | DATE | Czech GDFs | ||
| PRL_NO | VARCHAR2 | (25) | Spanish HR Locations GDFs | |
| PROPERTY_RENTAL | VARCHAR2 | (25) | Spanish HR Locations GDFs | |
| RATES_REFERENCE | VARCHAR2 | (25) | Spanish HR Locations GDFs | |
| STAIR_NUM | VARCHAR2 | (240) | Spanish HR Locations GDFs | |
| FLOOR_NUM | VARCHAR2 | (240) | Spanish HR Locations GDFs | |
| DOOR_NUM | VARCHAR2 | (240) | Spanish HR Locations GDFs | |
| AMOUNT_APPLIED | NUMBER | Amount Applied | ||
| ACTG_EVENT_TYPE_CODE | VARCHAR2 | (30) | Event type code | |
| ACTG_EVENT_TYPE_MNG | VARCHAR2 | (240) | event type meaning | |
| ACTG_EVENT_NUMBER | NUMBER | Event Number | ||
| ACTG_EVENT_STATUS_FLAG | VARCHAR2 | (1) | Event status flag | |
| ACTG_EVENT_STATUS_MNG | VARCHAR2 | (240) | Even status meaning | |
| ACTG_CATEGORY_CODE | VARCHAR2 | (30) | Category Code | |
| ACTG_CATEGORY_MNG | VARCHAR2 | (240) | Category meaning | |
| ACCOUNTING_DATE | DATE | Accounting date | ||
| GL_TRANSFER_FLAG | VARCHAR2 | (1) | GL Transfer flag | |
| ACTG_LINE_NUM | NUMBER | (15) | Accounting Line Number | |
| ACTG_LINE_TYPE_CODE | VARCHAR2 | (30) | Accounting Line Type Code | |
| ACTG_LINE_TYPE_MNG | VARCHAR2 | (240) | Accounting Line Type Code meaning | |
| ACTG_LINE_DESCRIPTION | VARCHAR2 | (1996) | Accounting Line Description. | |
| ACTG_STAT_AMT | NUMBER | Statistical Amount | ||
| ACTG_PARTY_ID | NUMBER | (15) | Party Identifier | |
| ACTG_PARTY_SITE_ID | NUMBER | (15) | Party Site Identifier | |
| ACTG_PARTY_TYPE | VARCHAR2 | (30) | Party Type | |
| ACTG_EVENT_ID | NUMBER | (15) | Accounting Event Identifier | |
| ACTG_HEADER_ID | NUMBER | Accounting Header Identifier | ||
| ACTG_LINE_ID | NUMBER | (15) | Accounting Line Identifer | |
| ACTG_SOURCE_ID | NUMBER | (15) | Accounting source id | |
| ACTG_SOURCE_TABLE | VARCHAR2 | (30) | Accounting source table | |
| ACTG_LINE_CCID | NUMBER | (15) | Code Combination Identifier | |
| ACCOUNT_FLEXFIELD | VARCHAR2 | (2000) | Account Flexfield | |
| ACCOUNT_DESCRIPTION | VARCHAR2 | (1996) | Account Description | |
| PERIOD_NAME | VARCHAR2 | (30) | Period Name | |
| TRX_ARAP_BALANCING_SEGMENT | VARCHAR2 | (240) | Balancing segment | |
| TRX_ARAP_NATURAL_ACCOUNT | VARCHAR2 | (240) | Natural segment | |
| TRX_TAXABLE_BALANCING_SEGMENT | VARCHAR2 | (240) | Taxable Balancing segment | |
| TRX_TAXABLE_NATURAL_ACCOUNT | VARCHAR2 | (240) | Taxable Natural segment | |
| TRX_TAX_BALANCING_SEGMENT | VARCHAR2 | (240) | Tax Balancing segment | |
| TRX_TAX_NATURAL_ACCOUNT | VARCHAR2 | (240) | Tax Natural segment. | |
| 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 | Standard Who column | ||
| PROGRAM_APPLICATION_ID | NUMBER | Standard Who column | ||
| PROGRAM_ID | NUMBER | Standard Who column | ||
| PROGRAM_LOGIN_ID | NUMBER | Standard Who column | ||
| OBJECT_VERSION_NUMBER | NUMBER | Yes | Object Version Number | |
| GL_DATE | DATE | GL_DATE for the tax transaction line | ||
| TRX_CONTROL_ACCOUNT_FLEXFIELD | VARCHAR2 | (2000) | Taxable line account flexfield | |
| TAX_ORIGIN | VARCHAR2 | (30) | Tax Origin | |
| REPORTING_CODE | VARCHAR2 | (60) | EMEA VAT Reporting code | |
| DEF_REC_SETTLEMENT_OPTION_CODE | VARCHAR2 | (30) | Deferred settlement code | |
| IL_VAT_REP_STATUS_ID | NUMBER | (15) | Israel VAT Reporting Status ID | |
| TAXABLE_ITEM_SOURCE_ID | NUMBER | (15) | Taxable Item Source ID | |
| INTRA_EU_TRX_TYPE_CODE | VARCHAR2 | (150) | Spanish Modelo 349 Intra EU VAT Transaction Type Code |
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 does not reference any database object
JG.JG_ZZ_VAT_TRX_DETAILS is referenced by following:
JG
JG_ZZ_VAT_TRX_DETAILS#
|
|
|
|