[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#;
|
|
|