1. Tables and Views for Financials
  2. JG_ZZ_VAT_TRX_DETAILS

JG_ZZ_VAT_TRX_DETAILS

JG_ZZ_VAT_TRX_DETAILS contains all payment related transactions selected for tax reporting. Taxable transactions (invoices) are already marked as selected directly in ZX repository itself, since payment related transactions have no tax impact, they are not stored in tax repository and they are marked as finally reported using this table. It can be used as a source for audits to provide information reported to the tax authorities at any point in time.

Details

  • Schema: FUSION

  • Object owner: ZX

  • Object type: TABLE

  • Tablespace: APPS_TS_TX_DATA

Primary Key

Name Columns

JG_ZZ_VAT_TRX_DETAILS_PK

VAT_TRANSACTION_ID

Columns

Name Datatype Length Precision Not-null Comments
VAT_TRANSACTION_ID NUMBER 18 Yes Primary Key - Sequence generated.
REPORTING_STATUS_ID NUMBER 18 Yes Reporting status identifier. Foreign Key for JG_ZZ_REP_STATUS table.
SELECTION_PROCESS_ID NUMBER 18 Yes Selection process identifier. Foreign Key for JG_ZZ_REP_STATUS table.
FINAL_REPORTING_ID NUMBER 18 Final process identifier. Foreign Key for JG_ZZ_REP_STATUS table
REP_ENTITY_ID NUMBER 18 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 18 Location identifier of the Legal Entity or Operating Unit
TAXPAYER_ID VARCHAR2 30 First Party Taxpayer Identification Number
ORG_INFORMATION2 VARCHAR2 150 Tax Registration Number of Business Unit
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 18 Ledger (Set of books) identifier
LEDGER_NAME VARCHAR2 30 Ledger Name
CHART_OF_ACCOUNTS_ID NUMBER 18 Chart of Accounts identifier
EXTRACT_SOURCE_LEDGER VARCHAR2 30 Identifies the source ledger for this line. Possible values are Accounts Payable, Accounts Receivable and General Ledger.
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 Subledger Accounting event class code
TRX_ID NUMBER 18 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_SEQ_ID NUMBER 18 Internal identifier used to control the receivable transaction type.
TRX_TYPE_MNG VARCHAR2 80 Meaning of Transaction type.
TRX_LINE_ID NUMBER 18 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 18 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 18 Receipt Class Identifier.
APPLIED_FROM_APPLICATION_ID NUMBER 18 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 18 Internal Unique Identifier used to identify the Applied From document.
APPLIED_FROM_LINE_ID NUMBER 18 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 18 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 18 The internal Id used to identify the Applied to document Name
APPLIED_TO_TRX_LINE_ID NUMBER 18 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 18 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 18 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 18 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 18 Identifier for the reference document header
REF_DOC_LINE_ID NUMBER 18 Identifier of the lowest level for which tax is calculated.
MERCHANT_PARTY_DOCUMENT_NUMBER VARCHAR2 150 Merchant party document number recorded on Expense Report
MERCHANT_PARTY_NAME VARCHAR2 150 Merchant party name recorded on Expense Report
MERCHANT_PARTY_REFERENCE VARCHAR2 250 Merchant party reference recorded on Expense Report
MERCHANT_PARTY_TAX_REG_NUMBER VARCHAR2 150 Merchant party Tax Registration Number recorded on Expense Report
MERCHANT_PARTY_TAXPAYER_ID VARCHAR2 150 Merchant party Taxpayer Identifier recorded on 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 18 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 18 Internal identifier for tax rate
TAX_RATE_CODE VARCHAR2 150 Tax rate code associated with the tax line.
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 18 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 150 Offset tax rate code associated with the tax line.
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 18 Billing Trading partner Identifier
BILLING_TP_TAX_REPORTING_FLAG VARCHAR2 1 Billing Trading Partner Tax reporting Flag
BILLING_TP_SITE_ID NUMBER 18 Site Details
BILLING_TP_ADDRESS_ID NUMBER 18 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 Ship to customer number, used only for Accounts Receivable transactions.
SHIPPING_TP_NUMBER VARCHAR2 60 Ship to customer name, used only for Accounts Receivable transactions.
SHIPPING_TP_TAX_REG_NUM VARCHAR2 50 Ship to customer Tax Registration Number, used only for Accounts Receivable transactions.
SHIPPING_TP_TAXPAYER_ID VARCHAR2 50 Ship to customer Taxpayer Identification Number, used only for Accounts Receivable transactions.
SHIPPING_TRADING_PARTNER_ID NUMBER 18 Ship to customer number, used only for Accounts Receivable transactions.
SHIPPING_TP_SITE_ID NUMBER 18 Site Details
SHIPPING_TP_ADDRESS_ID NUMBER 18 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 18 Supplier ID
BILL_FROM_PARTY_SITE_ID NUMBER 18 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 Identifier, for Accounts Receivable miscellaneous transactions alone.
BANK_ACCOUNT_NAME VARCHAR2 80 Back Account Name
BANK_ACCOUNT_NUM VARCHAR2 30 Bank Account Number
BANK_ACCOUNT_ID NUMBER 18 Bank Account Identifier
BANK_BRANCH_ID NUMBER 18 Bank Branch Identifier
LEGAL_ENTITY_TAX_REG_NUMBER VARCHAR2 80 Legal Entity Tax Registration Number
HQ_ESTB_REG_NUMBER VARCHAR2 30 Main Legal Reporting Unit Tax Registration Number
TAX_LINE_REGISTRATION_NUMBER VARCHAR2 50 Tax line Tax Registration Number
CANCELLED_DATE DATE Date canceled
CANCEL_FLAG VARCHAR2 1 Flag to indicate if the tax line is canceled
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 multiple reporting currencies tax line
RECONCILIATION_FLAG VARCHAR2 1 Reconciliation 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 Accounts Payable invoice source
ACCTD_AMOUNT_DR NUMBER Debit accounted amount from Accounts Receivable distribution
ACCTD_AMOUNT_CR NUMBER Credit accounted amount from Accounts Receivable distribution
REC_APPLICATION_STATUS VARCHAR2 30 Ar_receivable_Applications.status
VAT_COUNTRY_CODE VARCHAR2 50 Financial_system_parameters. Vat_country_code
INVOICE_IDENTIFIER VARCHAR2 20 invoice identifier from GL_JE_LINES table
ACCOUNT_CLASS VARCHAR2 20 Account class from the customer transaction line GL distribution
LATEST_REC_FLAG VARCHAR2 1 Latest flag from RA_CUST_TRX_LINE_GL_DIST.LATEST_REC_FLAG
JGZZ_FISCAL_CODE VARCHAR2 50 Trading partner tax payer identifier
TAX_REFERENCE VARCHAR2 50 First Party Tax Registration Number
PT_LOCATION VARCHAR2 25 Portuguese 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 for ZX_LINES_DET_FACTORS.DOCUMENT_SUB_TYPE
DOCUMENT_SUB_TYPE VARCHAR2 240 French deduction tax rule for ZX_LINES_DET_FACTORS.DOCUMENT_SUB_TYPE
ASSESSABLE_VALUE NUMBER Italian global descriptive flexfield for self invoice taxable amount
PROPERTY_LOCATION VARCHAR2 240 Spanish global descriptive flexfield property locations
CHK_VAT_AMOUNT_PAID VARCHAR2 25 ECE VAT Registers global descriptive flexfield
IMPORT_DOCUMENT_NUMBER VARCHAR2 240 Czech global descriptive flexfield for import document number
IMPORT_DOCUMENT_DATE DATE Czech global descriptive flexfield for import document date
PRL_NO VARCHAR2 25 Spanish HCM locations global descriptive flexfield
PROPERTY_RENTAL VARCHAR2 25 Spanish HR locations global descriptive flexfield for property rental
RATES_REFERENCE VARCHAR2 25 Spanish HCM locations global descriptive flexfield for rates reference
STAIR_NUM VARCHAR2 240 Stair number for Spain
FLOOR_NUM VARCHAR2 240 Spanish HCM Location global descriptive flexfield
DOOR_NUM VARCHAR2 240 Spanish HCM locations global descriptive flexfield
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 18 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 18 Party Identifier
ACTG_PARTY_SITE_ID NUMBER 18 Party Site Identifier
ACTG_PARTY_TYPE VARCHAR2 30 Party Type
ACTG_EVENT_ID NUMBER 18 Accounting Event Identifier
ACTG_HEADER_ID NUMBER Accounting Header Identifier
ACTG_LINE_ID NUMBER 18 Accounting line identifier
ACTG_SOURCE_ID NUMBER 18 Accounting source id
ACTG_SOURCE_TABLE VARCHAR2 30 Accounting source table
ACTG_LINE_CCID NUMBER 18 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 VARCHAR2 64 Yes Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
REQUEST_ID NUMBER Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
PROGRAM_APP_NAME VARCHAR2 50 Standard Who column
PROGRAM_NAME VARCHAR2 30 Standard Who column
PROGRAM_LOGIN_ID NUMBER Standard Who column
JOB_DEFINITION_NAME VARCHAR2 100 Enterprise Service Scheduler: indicates the name of the job that created or last updated the row.
JOB_DEFINITION_PACKAGE VARCHAR2 900 Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row.
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
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 Tax Reporting Code
DEF_REC_SETTLEMENT_OPTION_CODE VARCHAR2 30 Deferred settlement code
REC_NREC_TAX_DIST_ID NUMBER 18 Foreign key for zx_rec_nrec_dist table.
TAX_DIST_ID NUMBER 18 Foreign key for zx_trx_tax_distributions table.
CHECK_ID NUMBER 18 Foreign key identifier to ap_checks table.

Foreign Keys

Table Foreign Table Foreign Key Column
JG_ZZ_VAT_TRX_DETAILS jg_zz_vat_rep_status REPORTING_STATUS_ID
jg_zz_vat_box_allocs jg_zz_vat_trx_details VAT_TRANSACTION_ID

Indexes

Index Uniqueness Tablespace Columns
JG_ZZ_VAT_TRX_DETAILS_N1 Non Unique Default REPORTING_STATUS_ID
JG_ZZ_VAT_TRX_DETAILS_N2 Non Unique Default APPLICATION_ID, EVENT_CLASS_CODE, ENTITY_CODE, TRX_ID
JG_ZZ_VAT_TRX_DETAILS_U1 Unique Default VAT_TRANSACTION_ID