VIEW: ZX.ZX_REP_TRX_DETAIL_T#

Source

View Text - Preformatted

select DETAIL_TAX_LINE_ID DETAIL_TAX_LINE_ID, REP_CONTEXT_ID REP_CONTEXT_ID, EXTRACT_LINE_ID EXTRACT_LINE_ID, EXTRACT_REPORT_LINE_NUMBER EXTRACT_REPORT_LINE_NUMBER, LEDGER_ID LEDGER_ID, LEDGER_NAME LEDGER_NAME, CHART_OF_ACCOUNTS_ID CHART_OF_ACCOUNTS_ID, EXTRACT_SOURCE_LEDGER EXTRACT_SOURCE_LEDGER, EVENT_CLASS_CODE EVENT_CLASS_CODE, EVENT_CLASS_MAPPING_ID EVENT_CLASS_MAPPING_ID, DOC_EVENT_STATUS DOC_EVENT_STATUS, APPLICATION_DOC_STATUS APPLICATION_DOC_STATUS, ESTABLISHMENT_ID ESTABLISHMENT_ID, APPLICATION_ID APPLICATION_ID, INTERNAL_ORGANIZATION_ID INTERNAL_ORGANIZATION_ID, TRX_ID TRX_ID, TRX_NUMBER TRX_NUMBER, TRX_DESCRIPTION TRX_DESCRIPTION, TRX_CURRENCY_CODE TRX_CURRENCY_CODE, TRX_LINE_ID TRX_LINE_ID, TRX_LINE_NUMBER TRX_LINE_NUMBER, TRX_LINE_DESCRIPTION TRX_LINE_DESCRIPTION, TRX_LINE_TYPE TRX_LINE_TYPE, TRX_DATE TRX_DATE, DEPOSIT_DATE DEPOSIT_DATE, TRX_DUE_DATE TRX_DUE_DATE, TRX_SHIPPING_DATE TRX_SHIPPING_DATE, TRX_COMMUNICATED_DATE TRX_COMMUNICATED_DATE, TRX_TYPE_DESCRIPTION TRX_TYPE_DESCRIPTION, TRX_TYPE_ID TRX_TYPE_ID, TRX_LEVEL_TYPE TRX_LEVEL_TYPE, TRX_BATCH_SOURCE_NAME TRX_BATCH_SOURCE_NAME, TRX_SIC_CODE TRX_SIC_CODE, FOB_POINT FOB_POINT, TRX_WAYBILL_NUMBER TRX_WAYBILL_NUMBER, TRX_LINE_CLASS TRX_LINE_CLASS, PRODUCT_ID PRODUCT_ID, PRODUCT_DESCRIPTION PRODUCT_DESCRIPTION, FUNCTIONAL_CURRENCY_CODE FUNCTIONAL_CURRENCY_CODE, CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE, CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE, CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE, PRECISION PRECISION, MINIMUM_ACCOUNTABLE_UNIT MINIMUM_ACCOUNTABLE_UNIT, GDF_FND_CURRENCIES_ATT1 GDF_FND_CURRENCIES_ATT1, CURRENCY_CODE_DESC CURRENCY_CODE_DESC, TERRITORY_SHORT_NAME TERRITORY_SHORT_NAME, DOC_SEQ_ID DOC_SEQ_ID, DOC_SEQ_NAME DOC_SEQ_NAME, DOC_SEQ_VALUE DOC_SEQ_VALUE, TRX_LINE_QUANTITY TRX_LINE_QUANTITY, TRX_LINE_AMT TRX_LINE_AMT, UOM_CODE UOM_CODE, RECEIPT_CLASS_ID RECEIPT_CLASS_ID, TRX_BATCH_SOURCE_ID TRX_BATCH_SOURCE_ID, TRX_BATCH_SOURCE_DATE TRX_BATCH_SOURCE_DATE, RELATED_DOC_APPLICATION_ID RELATED_DOC_APPLICATION_ID, RELATED_DOC_ENTITY_CODE RELATED_DOC_ENTITY_CODE, RELATED_DOC_EVENT_CLASS_CODE RELATED_DOC_EVENT_CLASS_CODE, RELATED_DOC_TRX_ID RELATED_DOC_TRX_ID, RELATED_DOC_NUMBER RELATED_DOC_NUMBER, RELATED_DOC_DATE RELATED_DOC_DATE, APPLIED_FROM_APPLICATION_ID APPLIED_FROM_APPLICATION_ID, APPLIED_FROM_LINE_ID APPLIED_FROM_LINE_ID, APPLIED_FROM_ENTITY_CODE APPLIED_FROM_ENTITY_CODE, APPLIED_FROM_TRX_ID APPLIED_FROM_TRX_ID, APPLIED_FROM_EVENT_CLASS_CODE APPLIED_FROM_EVENT_CLASS_CODE, APPLIED_FROM_TRX_NUMBER APPLIED_FROM_TRX_NUMBER, TRX_APPLIED_FROM_CLASS_MNG TRX_APPLIED_FROM_CLASS_MNG, ADJUSTED_DOC_APPLICATION_ID ADJUSTED_DOC_APPLICATION_ID, ADJUSTED_DOC_ENTITY_CODE ADJUSTED_DOC_ENTITY_CODE, ADJUSTED_DOC_EVENT_CLASS_CODE ADJUSTED_DOC_EVENT_CLASS_CODE, ADJUSTED_DOC_TRX_ID ADJUSTED_DOC_TRX_ID, ADJUSTED_DOC_NUMBER ADJUSTED_DOC_NUMBER, ADJUSTED_DOC_DATE ADJUSTED_DOC_DATE, APPLIED_TO_APPLICATION_ID APPLIED_TO_APPLICATION_ID, APPLIED_TO_TRX_ID APPLIED_TO_TRX_ID, APPLIED_TO_TRX_LINE_ID APPLIED_TO_TRX_LINE_ID, APPLIED_TO_ENTITY_CODE APPLIED_TO_ENTITY_CODE, APPLIED_TO_EVENT_CLASS_CODE APPLIED_TO_EVENT_CLASS_CODE, APPLIED_TO_TRX_NUMBER APPLIED_TO_TRX_NUMBER, TRX_APPLIED_TO_CLASS_MNG TRX_APPLIED_TO_CLASS_MNG, REF_DOC_APPLICATION_ID REF_DOC_APPLICATION_ID, REF_DOC_ENTITY_CODE REF_DOC_ENTITY_CODE, REF_DOC_EVENT_CLASS_CODE REF_DOC_EVENT_CLASS_CODE, REF_DOC_TRX_ID REF_DOC_TRX_ID, REF_DOC_LINE_ID REF_DOC_LINE_ID, REF_DOC_LINE_QUANTITY REF_DOC_LINE_QUANTITY, MERCHANT_PARTY_DOCUMENT_NUMBER MERCHANT_PARTY_DOCUMENT_NUMBER, MERCHANT_PARTY_NAME MERCHANT_PARTY_NAME, MERCHANT_PARTY_REFERENCE MERCHANT_PARTY_REFERENCE, MERCHANT_PARTY_TAX_REG_NUMBER MERCHANT_PARTY_TAX_REG_NUMBER, MERCHANT_PARTY_TAXPAYER_ID MERCHANT_PARTY_TAXPAYER_ID, COUNTRY_OF_SUPPLY COUNTRY_OF_SUPPLY, START_EXPENSE_DATE START_EXPENSE_DATE, DEFAULT_TAXATION_COUNTRY DEFAULT_TAXATION_COUNTRY, TRX_CLASS_MNG TRX_CLASS_MNG, TRX_TYPE_MNG TRX_TYPE_MNG, TAX_RATE_CODE_REG_TYPE_MNG TAX_RATE_CODE_REG_TYPE_MNG, TAX_EXEMPT_REASON_MNG TAX_EXEMPT_REASON_MNG, TAX_EXCEPTION_REASON_MNG TAX_EXCEPTION_REASON_MNG, TRX_QUANTITY_UOM_MNG TRX_QUANTITY_UOM_MNG, TAX_RATE_CODE_VAT_TRX_TYPE_MNG TAX_RATE_CODE_VAT_TRX_TYPE_MNG, DOCUMENT_SUB_TYPE DOCUMENT_SUB_TYPE, SUPPLIER_TAX_INVOICE_NUMBER SUPPLIER_TAX_INVOICE_NUMBER, SUPPLIER_TAX_INVOICE_DATE SUPPLIER_TAX_INVOICE_DATE, SUPPLIER_EXCHANGE_RATE SUPPLIER_EXCHANGE_RATE, TAX_INVOICE_DATE TAX_INVOICE_DATE, TAX_INVOICE_NUMBER TAX_INVOICE_NUMBER, LINE_INTENDED_USE LINE_INTENDED_USE, PRODUCT_FISC_CLASSIFICATION PRODUCT_FISC_CLASSIFICATION, PRODUCT_CATEGORY PRODUCT_CATEGORY, USER_DEFINED_FISC_CLASS USER_DEFINED_FISC_CLASS, TRX_BUSINESS_CATEGORY TRX_BUSINESS_CATEGORY, ASSESSABLE_VALUE ASSESSABLE_VALUE, PORT_OF_ENTRY_CODE PORT_OF_ENTRY_CODE, TAXABLE_LINE_ITEM_FLEXFIELD TAXABLE_LINE_ITEM_FLEXFIELD, TAXABLE_LINE_SOURCE_TABLE TAXABLE_LINE_SOURCE_TABLE, TAXABLE_LINE_TOTAL_AMOUNT TAXABLE_LINE_TOTAL_AMOUNT, TAX_LINE_ID TAX_LINE_ID, TAX_LINE_NUMBER TAX_LINE_NUMBER, TAX_AMT TAX_AMT, TAX_AMT_FUNCL_CURR TAX_AMT_FUNCL_CURR, TAXABLE_AMT TAXABLE_AMT, TAXABLE_AMT_FUNCL_CURR TAXABLE_AMT_FUNCL_CURR, TAXABLE_DISC_AMT TAXABLE_DISC_AMT, TAXABLE_DISC_AMT_FUNCL_CURR TAXABLE_DISC_AMT_FUNCL_CURR, TAX_DISC_AMT TAX_DISC_AMT, TAX_DISC_AMT_FUNCL_CURR TAX_DISC_AMT_FUNCL_CURR, TAX_RATE_CODE TAX_RATE_CODE, TAX_RATE TAX_RATE, TAX_RATE_VAT_TRX_TYPE_CODE TAX_RATE_VAT_TRX_TYPE_CODE, TAX_RATE_VAT_TRX_TYPE_DESC TAX_RATE_VAT_TRX_TYPE_DESC, TAX_TYPE_CODE TAX_TYPE_CODE, TAX_TYPE_MNG TAX_TYPE_MNG, TAX_STATUS_ID TAX_STATUS_ID, TAX_RATE_CODE_NAME TAX_RATE_CODE_NAME, TAX_RATE_CODE_DESCRIPTION TAX_RATE_CODE_DESCRIPTION, TAX_RATE_ID TAX_RATE_ID, TAX_RATE_REGISTER_TYPE_CODE TAX_RATE_REGISTER_TYPE_CODE, TAX_APPLIED TAX_APPLIED, TAX_PROVIDER_ID TAX_PROVIDER_ID, DEF_REC_SETTLEMENT_OPTION_CODE DEF_REC_SETTLEMENT_OPTION_CODE, OFFSET_TAX_RATE_CODE OFFSET_TAX_RATE_CODE, EXEMPT_CERTIFICATE_NUMBER EXEMPT_CERTIFICATE_NUMBER, EXEMPT_REASON_CODE EXEMPT_REASON_CODE, TAX_EXCEPTION_REASON_CODE TAX_EXCEPTION_REASON_CODE, TAX_EXEMPTION_ID TAX_EXEMPTION_ID, TAX_EXCEPTION_ID TAX_EXCEPTION_ID, TAX_RECOVERY_RATE TAX_RECOVERY_RATE, TAX_REGIME_CODE TAX_REGIME_CODE, TAX TAX, TAX_JURISDICTION_CODE TAX_JURISDICTION_CODE, TAX_STATUS_CODE TAX_STATUS_CODE, TAX_CURRENCY_CODE TAX_CURRENCY_CODE, EXCEPTION_RATE EXCEPTION_RATE, EXEMPT_RATE_MODIFIER EXEMPT_RATE_MODIFIER, TAX_DATE TAX_DATE, TAX_DETERMINE_DATE TAX_DETERMINE_DATE, TAX_APPORTIONMENT_LINE_NUMBER TAX_APPORTIONMENT_LINE_NUMBER, TAX_AMT_TAX_CURR TAX_AMT_TAX_CURR, TAXABLE_AMT_TAX_CURR TAXABLE_AMT_TAX_CURR, ORIG_TAXABLE_AMT ORIG_TAXABLE_AMT, ORIG_TAXABLE_AMT_TAX_CURR ORIG_TAXABLE_AMT_TAX_CURR, ORIG_TAX_AMT ORIG_TAX_AMT, ORIG_TAX_AMT_TAX_CURR ORIG_TAX_AMT_TAX_CURR, ORIG_REC_NREC_TAX_AMT ORIG_REC_NREC_TAX_AMT, REC_TAX_AMT_TAX_CURR REC_TAX_AMT_TAX_CURR, NREC_TAX_AMT_TAX_CURR NREC_TAX_AMT_TAX_CURR, TAX_LINE_USER_CATEGORY TAX_LINE_USER_CATEGORY, TAX_LINE_USER_ATTRIBUTE1 TAX_LINE_USER_ATTRIBUTE1, TAX_LINE_USER_ATTRIBUTE2 TAX_LINE_USER_ATTRIBUTE2, TAX_LINE_USER_ATTRIBUTE3 TAX_LINE_USER_ATTRIBUTE3, TAX_LINE_USER_ATTRIBUTE4 TAX_LINE_USER_ATTRIBUTE4, TAX_LINE_USER_ATTRIBUTE5 TAX_LINE_USER_ATTRIBUTE5, TAX_LINE_USER_ATTRIBUTE6 TAX_LINE_USER_ATTRIBUTE6, TAX_LINE_USER_ATTRIBUTE7 TAX_LINE_USER_ATTRIBUTE7, TAX_LINE_USER_ATTRIBUTE8 TAX_LINE_USER_ATTRIBUTE8, TAX_LINE_USER_ATTRIBUTE9 TAX_LINE_USER_ATTRIBUTE9, TAX_LINE_USER_ATTRIBUTE10 TAX_LINE_USER_ATTRIBUTE10, TAX_LINE_USER_ATTRIBUTE11 TAX_LINE_USER_ATTRIBUTE11, TAX_LINE_USER_ATTRIBUTE12 TAX_LINE_USER_ATTRIBUTE12, TAX_LINE_USER_ATTRIBUTE13 TAX_LINE_USER_ATTRIBUTE13, TAX_LINE_USER_ATTRIBUTE14 TAX_LINE_USER_ATTRIBUTE14, TAX_LINE_USER_ATTRIBUTE15 TAX_LINE_USER_ATTRIBUTE15, RECOVERY_TYPE_CODE RECOVERY_TYPE_CODE, RECOVERY_RATE_CODE RECOVERY_RATE_CODE, BILLING_TP_NAME BILLING_TP_NAME, BILLING_TP_NUMBER BILLING_TP_NUMBER, BILLING_TP_TAX_REG_NUM BILLING_TP_TAX_REG_NUM, BILLING_TP_TAXPAYER_ID BILLING_TP_TAXPAYER_ID, BILLING_TP_SITE_NAME_ALT BILLING_TP_SITE_NAME_ALT, BILLING_TP_NAME_ALT BILLING_TP_NAME_ALT, BILLING_TP_SIC_CODE BILLING_TP_SIC_CODE, BILLING_TP_CITY BILLING_TP_CITY, BILLING_TP_COUNTY BILLING_TP_COUNTY, BILLING_TP_STATE BILLING_TP_STATE, BILLING_TP_PROVINCE BILLING_TP_PROVINCE, BILLING_TP_ADDRESS1 BILLING_TP_ADDRESS1, BILLING_TP_ADDRESS2 BILLING_TP_ADDRESS2, BILLING_TP_ADDRESS3 BILLING_TP_ADDRESS3, BILLING_TP_ADDRESS_LINES_ALT BILLING_TP_ADDRESS_LINES_ALT, BILLING_TP_COUNTRY BILLING_TP_COUNTRY, BILLING_TP_POSTAL_CODE BILLING_TP_POSTAL_CODE, SHIPPING_TP_NUMBER SHIPPING_TP_NUMBER, SHIPPING_TP_TAX_REG_NUM SHIPPING_TP_TAX_REG_NUM, SHIPPING_TP_TAXPAYER_ID SHIPPING_TP_TAXPAYER_ID, SHIPPING_TP_NAME SHIPPING_TP_NAME, SHIPPING_TP_NAME_ALT SHIPPING_TP_NAME_ALT, SHIPPING_TP_SIC_CODE SHIPPING_TP_SIC_CODE, SHIPPING_TP_CITY SHIPPING_TP_CITY, SHIPPING_TP_COUNTY SHIPPING_TP_COUNTY, SHIPPING_TP_STATE SHIPPING_TP_STATE, SHIPPING_TP_PROVINCE SHIPPING_TP_PROVINCE, SHIPPING_TP_ADDRESS1 SHIPPING_TP_ADDRESS1, SHIPPING_TP_ADDRESS2 SHIPPING_TP_ADDRESS2, SHIPPING_TP_ADDRESS3 SHIPPING_TP_ADDRESS3, SHIPPING_TP_ADDRESS_LINES_ALT SHIPPING_TP_ADDRESS_LINES_ALT, SHIPPING_TP_COUNTRY SHIPPING_TP_COUNTRY, SHIPPING_TP_POSTAL_CODE SHIPPING_TP_POSTAL_CODE, BILLING_TP_PARTY_NUMBER BILLING_TP_PARTY_NUMBER, BANK_ACCOUNT_NAME BANK_ACCOUNT_NAME, BANK_ACCOUNT_NUM BANK_ACCOUNT_NUM, BILLING_TRADING_PARTNER_ID BILLING_TRADING_PARTNER_ID, BILLING_TP_SITE_ID BILLING_TP_SITE_ID, BILLING_TP_ADDRESS_ID BILLING_TP_ADDRESS_ID, BILLING_TP_TAX_REPORTING_FLAG BILLING_TP_TAX_REPORTING_FLAG, SHIPPING_TRADING_PARTNER_ID SHIPPING_TRADING_PARTNER_ID, SHIPPING_TP_SITE_ID SHIPPING_TP_SITE_ID, SHIPPING_TP_ADDRESS_ID SHIPPING_TP_ADDRESS_ID, BANKING_TP_NAME BANKING_TP_NAME, BANKING_TP_TAXPAYER_ID BANKING_TP_TAXPAYER_ID, BANK_ACCOUNT_ID BANK_ACCOUNT_ID, BANK_BRANCH_ID BANK_BRANCH_ID, BILLING_TP_SITE_NAME BILLING_TP_SITE_NAME, BILLING_TP_SITE_TAX_REG_NUM BILLING_TP_SITE_TAX_REG_NUM, SHIPPING_TP_SITE_NAME SHIPPING_TP_SITE_NAME, SHIPPING_TP_SITE_TAX_REG_NUM SHIPPING_TP_SITE_TAX_REG_NUM, OFFICE_SITE_FLAG OFFICE_SITE_FLAG, SHIP_TO_LOCATION_ID SHIP_TO_LOCATION_ID, SHIP_FROM_LOCATION_ID SHIP_FROM_LOCATION_ID, BILL_TO_LOCATION_ID BILL_TO_LOCATION_ID, BILL_FROM_LOCATION_ID BILL_FROM_LOCATION_ID, SHIP_TO_PARTY_TAX_PROF_ID SHIP_TO_PARTY_TAX_PROF_ID, SHIP_FROM_PARTY_TAX_PROF_ID SHIP_FROM_PARTY_TAX_PROF_ID, BILL_TO_PARTY_TAX_PROF_ID BILL_TO_PARTY_TAX_PROF_ID, BILL_FROM_PARTY_TAX_PROF_ID BILL_FROM_PARTY_TAX_PROF_ID, OWN_HQ_PARTY_TAX_PROF_ID OWN_HQ_PARTY_TAX_PROF_ID, SHIP_TO_SITE_TAX_PROF_ID SHIP_TO_SITE_TAX_PROF_ID, BILL_TO_SITE_TAX_PROF_ID BILL_TO_SITE_TAX_PROF_ID, SHIP_FROM_SITE_TAX_PROF_ID SHIP_FROM_SITE_TAX_PROF_ID, BILL_FROM_SITE_TAX_PROF_ID BILL_FROM_SITE_TAX_PROF_ID, OWN_HQ_PARTY_SITE_PROF_ID OWN_HQ_PARTY_SITE_PROF_ID, SHIP_TO_PARTY_ID SHIP_TO_PARTY_ID, SHIP_FROM_PARTY_ID SHIP_FROM_PARTY_ID, BILL_TO_PARTY_ID BILL_TO_PARTY_ID, BILL_FROM_PARTY_ID BILL_FROM_PARTY_ID, OWN_HQ_PARTY_ID OWN_HQ_PARTY_ID, SHIP_TO_PARTY_SITE_ID SHIP_TO_PARTY_SITE_ID, SHIP_FROM_PARTY_SITE_ID SHIP_FROM_PARTY_SITE_ID, BILL_TO_PARTY_SITE_ID BILL_TO_PARTY_SITE_ID, BILL_FROM_PARTY_SITE_ID BILL_FROM_PARTY_SITE_ID, REGISTRATION_STATUS_CODE REGISTRATION_STATUS_CODE, REG_PARTY_TAX_PROF_ID REG_PARTY_TAX_PROF_ID, REG_PARTY_TAX_SITE_PROF_ID REG_PARTY_TAX_SITE_PROF_ID, POS_TAX_PARTY_PROF_ID POS_TAX_PARTY_PROF_ID, POS_TAX_PARTY_SITE_PROF_ID POS_TAX_PARTY_SITE_PROF_ID, POA_LOCATION_ID POA_LOCATION_ID, PLACE_OF_SUPPLY_TYPE_CODE PLACE_OF_SUPPLY_TYPE_CODE, DEF_PLACE_OF_SUPPLY_TYPE_CODE DEF_PLACE_OF_SUPPLY_TYPE_CODE, POO_LOCATION_ID POO_LOCATION_ID, LEGAL_ENTITY_TAX_REG_NUMBER LEGAL_ENTITY_TAX_REG_NUMBER, HQ_ESTB_REG_NUMBER HQ_ESTB_REG_NUMBER, TAX_LINE_REGISTRATION_NUMBER TAX_LINE_REGISTRATION_NUMBER, REGISTRATION_PARTY_TYPE REGISTRATION_PARTY_TYPE, BALANCING_SEGMENT_VALUE BALANCING_SEGMENT_VALUE, BALANCING_SEGMENT_DESC BALANCING_SEGMENT_DESC, CANCELLED_DATE CANCELLED_DATE, HISTORICAL_FLAG HISTORICAL_FLAG, CANCEL_FLAG CANCEL_FLAG, SELF_ASSESSED_FLAG SELF_ASSESSED_FLAG, REPORTING_ONLY_FLAG REPORTING_ONLY_FLAG, TAX_ONLY_FLAG TAX_ONLY_FLAG, OFFSET_FLAG OFFSET_FLAG, POSTED_FLAG POSTED_FLAG, MRC_TAX_LINE_FLAG MRC_TAX_LINE_FLAG, SMALL_BUSINESS_FLAG SMALL_BUSINESS_FLAG, RECONCILIATION_FLAG RECONCILIATION_FLAG, TAX_RECOVERABLE_FLAG TAX_RECOVERABLE_FLAG, REVERSE_FLAG REVERSE_FLAG, AR_CASH_RECEIPT_REVERSE_STATUS AR_CASH_RECEIPT_REVERSE_STATUS, AR_CASH_RECEIPT_REVERSE_DATE AR_CASH_RECEIPT_REVERSE_DATE, TAXABLE_ITEM_SOURCE_ID TAXABLE_ITEM_SOURCE_ID, AMOUNT_APPLIED AMOUNT_APPLIED, BR_REF_CUSTOMER_TRX_ID BR_REF_CUSTOMER_TRX_ID, TAX_AMT_INCLUDED_FLAG TAX_AMT_INCLUDED_FLAG, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_LOGIN_ID PROGRAM_LOGIN_ID, GDF_PARTY_SITES_BILL_ATT8 GDF_PARTY_SITES_BILL_ATT8, GDF_RA_CUST_BILL_ATT10 GDF_RA_CUST_BILL_ATT10, GDF_RA_CUST_BILL_ATT12 GDF_RA_CUST_BILL_ATT12, GDF_RA_ADDRESSES_BILL_ATT8 GDF_RA_ADDRESSES_BILL_ATT8, GDF_RA_ADDRESSES_BILL_ATT9 GDF_RA_ADDRESSES_BILL_ATT9, GDF_PARTY_SITES_SHIP_ATT8 GDF_PARTY_SITES_SHIP_ATT8, GDF_RA_CUST_SHIP_ATT10 GDF_RA_CUST_SHIP_ATT10, GDF_RA_CUST_SHIP_ATT12 GDF_RA_CUST_SHIP_ATT12, GDF_RA_ADDRESSES_SHIP_ATT8 GDF_RA_ADDRESSES_SHIP_ATT8, GDF_RA_ADDRESSES_SHIP_ATT9 GDF_RA_ADDRESSES_SHIP_ATT9, GDF_PO_VENDOR_SITE_ATT17 GDF_PO_VENDOR_SITE_ATT17, ACCTD_AMOUNT_CR ACCTD_AMOUNT_CR, ACCTD_AMOUNT_DR ACCTD_AMOUNT_DR, REC_APPLICATION_STATUS REC_APPLICATION_STATUS, SUB_LEDGER_INVOICE_IDENTIFIER SUB_LEDGER_INVOICE_IDENTIFIER, ACCOUNT_CLASS ACCOUNT_CLASS, LATEST_REC_FLAG LATEST_REC_FLAG, ENTITY_CODE ENTITY_CODE, POSTED_DATE POSTED_DATE, ACTG_SOURCE_ID ACTG_SOURCE_ID, UNIT_PRICE UNIT_PRICE, GL_DATE GL_DATE from "ZX"."ZX_REP_TRX_DETAIL_T"

View Text - HTML Formatted

SELECT DETAIL_TAX_LINE_ID DETAIL_TAX_LINE_ID
, REP_CONTEXT_ID REP_CONTEXT_ID
, EXTRACT_LINE_ID EXTRACT_LINE_ID
, EXTRACT_REPORT_LINE_NUMBER EXTRACT_REPORT_LINE_NUMBER
, LEDGER_ID LEDGER_ID
, LEDGER_NAME LEDGER_NAME
, CHART_OF_ACCOUNTS_ID CHART_OF_ACCOUNTS_ID
, EXTRACT_SOURCE_LEDGER EXTRACT_SOURCE_LEDGER
, EVENT_CLASS_CODE EVENT_CLASS_CODE
, EVENT_CLASS_MAPPING_ID EVENT_CLASS_MAPPING_ID
, DOC_EVENT_STATUS DOC_EVENT_STATUS
, APPLICATION_DOC_STATUS APPLICATION_DOC_STATUS
, ESTABLISHMENT_ID ESTABLISHMENT_ID
, APPLICATION_ID APPLICATION_ID
, INTERNAL_ORGANIZATION_ID INTERNAL_ORGANIZATION_ID
, TRX_ID TRX_ID
, TRX_NUMBER TRX_NUMBER
, TRX_DESCRIPTION TRX_DESCRIPTION
, TRX_CURRENCY_CODE TRX_CURRENCY_CODE
, TRX_LINE_ID TRX_LINE_ID
, TRX_LINE_NUMBER TRX_LINE_NUMBER
, TRX_LINE_DESCRIPTION TRX_LINE_DESCRIPTION
, TRX_LINE_TYPE TRX_LINE_TYPE
, TRX_DATE TRX_DATE
, DEPOSIT_DATE DEPOSIT_DATE
, TRX_DUE_DATE TRX_DUE_DATE
, TRX_SHIPPING_DATE TRX_SHIPPING_DATE
, TRX_COMMUNICATED_DATE TRX_COMMUNICATED_DATE
, TRX_TYPE_DESCRIPTION TRX_TYPE_DESCRIPTION
, TRX_TYPE_ID TRX_TYPE_ID
, TRX_LEVEL_TYPE TRX_LEVEL_TYPE
, TRX_BATCH_SOURCE_NAME TRX_BATCH_SOURCE_NAME
, TRX_SIC_CODE TRX_SIC_CODE
, FOB_POINT FOB_POINT
, TRX_WAYBILL_NUMBER TRX_WAYBILL_NUMBER
, TRX_LINE_CLASS TRX_LINE_CLASS
, PRODUCT_ID PRODUCT_ID
, PRODUCT_DESCRIPTION PRODUCT_DESCRIPTION
, FUNCTIONAL_CURRENCY_CODE FUNCTIONAL_CURRENCY_CODE
, CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE
, CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE
, CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE
, PRECISION PRECISION
, MINIMUM_ACCOUNTABLE_UNIT MINIMUM_ACCOUNTABLE_UNIT
, GDF_FND_CURRENCIES_ATT1 GDF_FND_CURRENCIES_ATT1
, CURRENCY_CODE_DESC CURRENCY_CODE_DESC
, TERRITORY_SHORT_NAME TERRITORY_SHORT_NAME
, DOC_SEQ_ID DOC_SEQ_ID
, DOC_SEQ_NAME DOC_SEQ_NAME
, DOC_SEQ_VALUE DOC_SEQ_VALUE
, TRX_LINE_QUANTITY TRX_LINE_QUANTITY
, TRX_LINE_AMT TRX_LINE_AMT
, UOM_CODE UOM_CODE
, RECEIPT_CLASS_ID RECEIPT_CLASS_ID
, TRX_BATCH_SOURCE_ID TRX_BATCH_SOURCE_ID
, TRX_BATCH_SOURCE_DATE TRX_BATCH_SOURCE_DATE
, RELATED_DOC_APPLICATION_ID RELATED_DOC_APPLICATION_ID
, RELATED_DOC_ENTITY_CODE RELATED_DOC_ENTITY_CODE
, RELATED_DOC_EVENT_CLASS_CODE RELATED_DOC_EVENT_CLASS_CODE
, RELATED_DOC_TRX_ID RELATED_DOC_TRX_ID
, RELATED_DOC_NUMBER RELATED_DOC_NUMBER
, RELATED_DOC_DATE RELATED_DOC_DATE
, APPLIED_FROM_APPLICATION_ID APPLIED_FROM_APPLICATION_ID
, APPLIED_FROM_LINE_ID APPLIED_FROM_LINE_ID
, APPLIED_FROM_ENTITY_CODE APPLIED_FROM_ENTITY_CODE
, APPLIED_FROM_TRX_ID APPLIED_FROM_TRX_ID
, APPLIED_FROM_EVENT_CLASS_CODE APPLIED_FROM_EVENT_CLASS_CODE
, APPLIED_FROM_TRX_NUMBER APPLIED_FROM_TRX_NUMBER
, TRX_APPLIED_FROM_CLASS_MNG TRX_APPLIED_FROM_CLASS_MNG
, ADJUSTED_DOC_APPLICATION_ID ADJUSTED_DOC_APPLICATION_ID
, ADJUSTED_DOC_ENTITY_CODE ADJUSTED_DOC_ENTITY_CODE
, ADJUSTED_DOC_EVENT_CLASS_CODE ADJUSTED_DOC_EVENT_CLASS_CODE
, ADJUSTED_DOC_TRX_ID ADJUSTED_DOC_TRX_ID
, ADJUSTED_DOC_NUMBER ADJUSTED_DOC_NUMBER
, ADJUSTED_DOC_DATE ADJUSTED_DOC_DATE
, APPLIED_TO_APPLICATION_ID APPLIED_TO_APPLICATION_ID
, APPLIED_TO_TRX_ID APPLIED_TO_TRX_ID
, APPLIED_TO_TRX_LINE_ID APPLIED_TO_TRX_LINE_ID
, APPLIED_TO_ENTITY_CODE APPLIED_TO_ENTITY_CODE
, APPLIED_TO_EVENT_CLASS_CODE APPLIED_TO_EVENT_CLASS_CODE
, APPLIED_TO_TRX_NUMBER APPLIED_TO_TRX_NUMBER
, TRX_APPLIED_TO_CLASS_MNG TRX_APPLIED_TO_CLASS_MNG
, REF_DOC_APPLICATION_ID REF_DOC_APPLICATION_ID
, REF_DOC_ENTITY_CODE REF_DOC_ENTITY_CODE
, REF_DOC_EVENT_CLASS_CODE REF_DOC_EVENT_CLASS_CODE
, REF_DOC_TRX_ID REF_DOC_TRX_ID
, REF_DOC_LINE_ID REF_DOC_LINE_ID
, REF_DOC_LINE_QUANTITY REF_DOC_LINE_QUANTITY
, MERCHANT_PARTY_DOCUMENT_NUMBER MERCHANT_PARTY_DOCUMENT_NUMBER
, MERCHANT_PARTY_NAME MERCHANT_PARTY_NAME
, MERCHANT_PARTY_REFERENCE MERCHANT_PARTY_REFERENCE
, MERCHANT_PARTY_TAX_REG_NUMBER MERCHANT_PARTY_TAX_REG_NUMBER
, MERCHANT_PARTY_TAXPAYER_ID MERCHANT_PARTY_TAXPAYER_ID
, COUNTRY_OF_SUPPLY COUNTRY_OF_SUPPLY
, START_EXPENSE_DATE START_EXPENSE_DATE
, DEFAULT_TAXATION_COUNTRY DEFAULT_TAXATION_COUNTRY
, TRX_CLASS_MNG TRX_CLASS_MNG
, TRX_TYPE_MNG TRX_TYPE_MNG
, TAX_RATE_CODE_REG_TYPE_MNG TAX_RATE_CODE_REG_TYPE_MNG
, TAX_EXEMPT_REASON_MNG TAX_EXEMPT_REASON_MNG
, TAX_EXCEPTION_REASON_MNG TAX_EXCEPTION_REASON_MNG
, TRX_QUANTITY_UOM_MNG TRX_QUANTITY_UOM_MNG
, TAX_RATE_CODE_VAT_TRX_TYPE_MNG TAX_RATE_CODE_VAT_TRX_TYPE_MNG
, DOCUMENT_SUB_TYPE DOCUMENT_SUB_TYPE
, SUPPLIER_TAX_INVOICE_NUMBER SUPPLIER_TAX_INVOICE_NUMBER
, SUPPLIER_TAX_INVOICE_DATE SUPPLIER_TAX_INVOICE_DATE
, SUPPLIER_EXCHANGE_RATE SUPPLIER_EXCHANGE_RATE
, TAX_INVOICE_DATE TAX_INVOICE_DATE
, TAX_INVOICE_NUMBER TAX_INVOICE_NUMBER
, LINE_INTENDED_USE LINE_INTENDED_USE
, PRODUCT_FISC_CLASSIFICATION PRODUCT_FISC_CLASSIFICATION
, PRODUCT_CATEGORY PRODUCT_CATEGORY
, USER_DEFINED_FISC_CLASS USER_DEFINED_FISC_CLASS
, TRX_BUSINESS_CATEGORY TRX_BUSINESS_CATEGORY
, ASSESSABLE_VALUE ASSESSABLE_VALUE
, PORT_OF_ENTRY_CODE PORT_OF_ENTRY_CODE
, TAXABLE_LINE_ITEM_FLEXFIELD TAXABLE_LINE_ITEM_FLEXFIELD
, TAXABLE_LINE_SOURCE_TABLE TAXABLE_LINE_SOURCE_TABLE
, TAXABLE_LINE_TOTAL_AMOUNT TAXABLE_LINE_TOTAL_AMOUNT
, TAX_LINE_ID TAX_LINE_ID
, TAX_LINE_NUMBER TAX_LINE_NUMBER
, TAX_AMT TAX_AMT
, TAX_AMT_FUNCL_CURR TAX_AMT_FUNCL_CURR
, TAXABLE_AMT TAXABLE_AMT
, TAXABLE_AMT_FUNCL_CURR TAXABLE_AMT_FUNCL_CURR
, TAXABLE_DISC_AMT TAXABLE_DISC_AMT
, TAXABLE_DISC_AMT_FUNCL_CURR TAXABLE_DISC_AMT_FUNCL_CURR
, TAX_DISC_AMT TAX_DISC_AMT
, TAX_DISC_AMT_FUNCL_CURR TAX_DISC_AMT_FUNCL_CURR
, TAX_RATE_CODE TAX_RATE_CODE
, TAX_RATE TAX_RATE
, TAX_RATE_VAT_TRX_TYPE_CODE TAX_RATE_VAT_TRX_TYPE_CODE
, TAX_RATE_VAT_TRX_TYPE_DESC TAX_RATE_VAT_TRX_TYPE_DESC
, TAX_TYPE_CODE TAX_TYPE_CODE
, TAX_TYPE_MNG TAX_TYPE_MNG
, TAX_STATUS_ID TAX_STATUS_ID
, TAX_RATE_CODE_NAME TAX_RATE_CODE_NAME
, TAX_RATE_CODE_DESCRIPTION TAX_RATE_CODE_DESCRIPTION
, TAX_RATE_ID TAX_RATE_ID
, TAX_RATE_REGISTER_TYPE_CODE TAX_RATE_REGISTER_TYPE_CODE
, TAX_APPLIED TAX_APPLIED
, TAX_PROVIDER_ID TAX_PROVIDER_ID
, DEF_REC_SETTLEMENT_OPTION_CODE DEF_REC_SETTLEMENT_OPTION_CODE
, OFFSET_TAX_RATE_CODE OFFSET_TAX_RATE_CODE
, EXEMPT_CERTIFICATE_NUMBER EXEMPT_CERTIFICATE_NUMBER
, EXEMPT_REASON_CODE EXEMPT_REASON_CODE
, TAX_EXCEPTION_REASON_CODE TAX_EXCEPTION_REASON_CODE
, TAX_EXEMPTION_ID TAX_EXEMPTION_ID
, TAX_EXCEPTION_ID TAX_EXCEPTION_ID
, TAX_RECOVERY_RATE TAX_RECOVERY_RATE
, TAX_REGIME_CODE TAX_REGIME_CODE
, TAX TAX
, TAX_JURISDICTION_CODE TAX_JURISDICTION_CODE
, TAX_STATUS_CODE TAX_STATUS_CODE
, TAX_CURRENCY_CODE TAX_CURRENCY_CODE
, EXCEPTION_RATE EXCEPTION_RATE
, EXEMPT_RATE_MODIFIER EXEMPT_RATE_MODIFIER
, TAX_DATE TAX_DATE
, TAX_DETERMINE_DATE TAX_DETERMINE_DATE
, TAX_APPORTIONMENT_LINE_NUMBER TAX_APPORTIONMENT_LINE_NUMBER
, TAX_AMT_TAX_CURR TAX_AMT_TAX_CURR
, TAXABLE_AMT_TAX_CURR TAXABLE_AMT_TAX_CURR
, ORIG_TAXABLE_AMT ORIG_TAXABLE_AMT
, ORIG_TAXABLE_AMT_TAX_CURR ORIG_TAXABLE_AMT_TAX_CURR
, ORIG_TAX_AMT ORIG_TAX_AMT
, ORIG_TAX_AMT_TAX_CURR ORIG_TAX_AMT_TAX_CURR
, ORIG_REC_NREC_TAX_AMT ORIG_REC_NREC_TAX_AMT
, REC_TAX_AMT_TAX_CURR REC_TAX_AMT_TAX_CURR
, NREC_TAX_AMT_TAX_CURR NREC_TAX_AMT_TAX_CURR
, TAX_LINE_USER_CATEGORY TAX_LINE_USER_CATEGORY
, TAX_LINE_USER_ATTRIBUTE1 TAX_LINE_USER_ATTRIBUTE1
, TAX_LINE_USER_ATTRIBUTE2 TAX_LINE_USER_ATTRIBUTE2
, TAX_LINE_USER_ATTRIBUTE3 TAX_LINE_USER_ATTRIBUTE3
, TAX_LINE_USER_ATTRIBUTE4 TAX_LINE_USER_ATTRIBUTE4
, TAX_LINE_USER_ATTRIBUTE5 TAX_LINE_USER_ATTRIBUTE5
, TAX_LINE_USER_ATTRIBUTE6 TAX_LINE_USER_ATTRIBUTE6
, TAX_LINE_USER_ATTRIBUTE7 TAX_LINE_USER_ATTRIBUTE7
, TAX_LINE_USER_ATTRIBUTE8 TAX_LINE_USER_ATTRIBUTE8
, TAX_LINE_USER_ATTRIBUTE9 TAX_LINE_USER_ATTRIBUTE9
, TAX_LINE_USER_ATTRIBUTE10 TAX_LINE_USER_ATTRIBUTE10
, TAX_LINE_USER_ATTRIBUTE11 TAX_LINE_USER_ATTRIBUTE11
, TAX_LINE_USER_ATTRIBUTE12 TAX_LINE_USER_ATTRIBUTE12
, TAX_LINE_USER_ATTRIBUTE13 TAX_LINE_USER_ATTRIBUTE13
, TAX_LINE_USER_ATTRIBUTE14 TAX_LINE_USER_ATTRIBUTE14
, TAX_LINE_USER_ATTRIBUTE15 TAX_LINE_USER_ATTRIBUTE15
, RECOVERY_TYPE_CODE RECOVERY_TYPE_CODE
, RECOVERY_RATE_CODE RECOVERY_RATE_CODE
, BILLING_TP_NAME BILLING_TP_NAME
, BILLING_TP_NUMBER BILLING_TP_NUMBER
, BILLING_TP_TAX_REG_NUM BILLING_TP_TAX_REG_NUM
, BILLING_TP_TAXPAYER_ID BILLING_TP_TAXPAYER_ID
, BILLING_TP_SITE_NAME_ALT BILLING_TP_SITE_NAME_ALT
, BILLING_TP_NAME_ALT BILLING_TP_NAME_ALT
, BILLING_TP_SIC_CODE BILLING_TP_SIC_CODE
, BILLING_TP_CITY BILLING_TP_CITY
, BILLING_TP_COUNTY BILLING_TP_COUNTY
, BILLING_TP_STATE BILLING_TP_STATE
, BILLING_TP_PROVINCE BILLING_TP_PROVINCE
, BILLING_TP_ADDRESS1 BILLING_TP_ADDRESS1
, BILLING_TP_ADDRESS2 BILLING_TP_ADDRESS2
, BILLING_TP_ADDRESS3 BILLING_TP_ADDRESS3
, BILLING_TP_ADDRESS_LINES_ALT BILLING_TP_ADDRESS_LINES_ALT
, BILLING_TP_COUNTRY BILLING_TP_COUNTRY
, BILLING_TP_POSTAL_CODE BILLING_TP_POSTAL_CODE
, SHIPPING_TP_NUMBER SHIPPING_TP_NUMBER
, SHIPPING_TP_TAX_REG_NUM SHIPPING_TP_TAX_REG_NUM
, SHIPPING_TP_TAXPAYER_ID SHIPPING_TP_TAXPAYER_ID
, SHIPPING_TP_NAME SHIPPING_TP_NAME
, SHIPPING_TP_NAME_ALT SHIPPING_TP_NAME_ALT
, SHIPPING_TP_SIC_CODE SHIPPING_TP_SIC_CODE
, SHIPPING_TP_CITY SHIPPING_TP_CITY
, SHIPPING_TP_COUNTY SHIPPING_TP_COUNTY
, SHIPPING_TP_STATE SHIPPING_TP_STATE
, SHIPPING_TP_PROVINCE SHIPPING_TP_PROVINCE
, SHIPPING_TP_ADDRESS1 SHIPPING_TP_ADDRESS1
, SHIPPING_TP_ADDRESS2 SHIPPING_TP_ADDRESS2
, SHIPPING_TP_ADDRESS3 SHIPPING_TP_ADDRESS3
, SHIPPING_TP_ADDRESS_LINES_ALT SHIPPING_TP_ADDRESS_LINES_ALT
, SHIPPING_TP_COUNTRY SHIPPING_TP_COUNTRY
, SHIPPING_TP_POSTAL_CODE SHIPPING_TP_POSTAL_CODE
, BILLING_TP_PARTY_NUMBER BILLING_TP_PARTY_NUMBER
, BANK_ACCOUNT_NAME BANK_ACCOUNT_NAME
, BANK_ACCOUNT_NUM BANK_ACCOUNT_NUM
, BILLING_TRADING_PARTNER_ID BILLING_TRADING_PARTNER_ID
, BILLING_TP_SITE_ID BILLING_TP_SITE_ID
, BILLING_TP_ADDRESS_ID BILLING_TP_ADDRESS_ID
, BILLING_TP_TAX_REPORTING_FLAG BILLING_TP_TAX_REPORTING_FLAG
, SHIPPING_TRADING_PARTNER_ID SHIPPING_TRADING_PARTNER_ID
, SHIPPING_TP_SITE_ID SHIPPING_TP_SITE_ID
, SHIPPING_TP_ADDRESS_ID SHIPPING_TP_ADDRESS_ID
, BANKING_TP_NAME BANKING_TP_NAME
, BANKING_TP_TAXPAYER_ID BANKING_TP_TAXPAYER_ID
, BANK_ACCOUNT_ID BANK_ACCOUNT_ID
, BANK_BRANCH_ID BANK_BRANCH_ID
, BILLING_TP_SITE_NAME BILLING_TP_SITE_NAME
, BILLING_TP_SITE_TAX_REG_NUM BILLING_TP_SITE_TAX_REG_NUM
, SHIPPING_TP_SITE_NAME SHIPPING_TP_SITE_NAME
, SHIPPING_TP_SITE_TAX_REG_NUM SHIPPING_TP_SITE_TAX_REG_NUM
, OFFICE_SITE_FLAG OFFICE_SITE_FLAG
, SHIP_TO_LOCATION_ID SHIP_TO_LOCATION_ID
, SHIP_FROM_LOCATION_ID SHIP_FROM_LOCATION_ID
, BILL_TO_LOCATION_ID BILL_TO_LOCATION_ID
, BILL_FROM_LOCATION_ID BILL_FROM_LOCATION_ID
, SHIP_TO_PARTY_TAX_PROF_ID SHIP_TO_PARTY_TAX_PROF_ID
, SHIP_FROM_PARTY_TAX_PROF_ID SHIP_FROM_PARTY_TAX_PROF_ID
, BILL_TO_PARTY_TAX_PROF_ID BILL_TO_PARTY_TAX_PROF_ID
, BILL_FROM_PARTY_TAX_PROF_ID BILL_FROM_PARTY_TAX_PROF_ID
, OWN_HQ_PARTY_TAX_PROF_ID OWN_HQ_PARTY_TAX_PROF_ID
, SHIP_TO_SITE_TAX_PROF_ID SHIP_TO_SITE_TAX_PROF_ID
, BILL_TO_SITE_TAX_PROF_ID BILL_TO_SITE_TAX_PROF_ID
, SHIP_FROM_SITE_TAX_PROF_ID SHIP_FROM_SITE_TAX_PROF_ID
, BILL_FROM_SITE_TAX_PROF_ID BILL_FROM_SITE_TAX_PROF_ID
, OWN_HQ_PARTY_SITE_PROF_ID OWN_HQ_PARTY_SITE_PROF_ID
, SHIP_TO_PARTY_ID SHIP_TO_PARTY_ID
, SHIP_FROM_PARTY_ID SHIP_FROM_PARTY_ID
, BILL_TO_PARTY_ID BILL_TO_PARTY_ID
, BILL_FROM_PARTY_ID BILL_FROM_PARTY_ID
, OWN_HQ_PARTY_ID OWN_HQ_PARTY_ID
, SHIP_TO_PARTY_SITE_ID SHIP_TO_PARTY_SITE_ID
, SHIP_FROM_PARTY_SITE_ID SHIP_FROM_PARTY_SITE_ID
, BILL_TO_PARTY_SITE_ID BILL_TO_PARTY_SITE_ID
, BILL_FROM_PARTY_SITE_ID BILL_FROM_PARTY_SITE_ID
, REGISTRATION_STATUS_CODE REGISTRATION_STATUS_CODE
, REG_PARTY_TAX_PROF_ID REG_PARTY_TAX_PROF_ID
, REG_PARTY_TAX_SITE_PROF_ID REG_PARTY_TAX_SITE_PROF_ID
, POS_TAX_PARTY_PROF_ID POS_TAX_PARTY_PROF_ID
, POS_TAX_PARTY_SITE_PROF_ID POS_TAX_PARTY_SITE_PROF_ID
, POA_LOCATION_ID POA_LOCATION_ID
, PLACE_OF_SUPPLY_TYPE_CODE PLACE_OF_SUPPLY_TYPE_CODE
, DEF_PLACE_OF_SUPPLY_TYPE_CODE DEF_PLACE_OF_SUPPLY_TYPE_CODE
, POO_LOCATION_ID POO_LOCATION_ID
, LEGAL_ENTITY_TAX_REG_NUMBER LEGAL_ENTITY_TAX_REG_NUMBER
, HQ_ESTB_REG_NUMBER HQ_ESTB_REG_NUMBER
, TAX_LINE_REGISTRATION_NUMBER TAX_LINE_REGISTRATION_NUMBER
, REGISTRATION_PARTY_TYPE REGISTRATION_PARTY_TYPE
, BALANCING_SEGMENT_VALUE BALANCING_SEGMENT_VALUE
, BALANCING_SEGMENT_DESC BALANCING_SEGMENT_DESC
, CANCELLED_DATE CANCELLED_DATE
, HISTORICAL_FLAG HISTORICAL_FLAG
, CANCEL_FLAG CANCEL_FLAG
, SELF_ASSESSED_FLAG SELF_ASSESSED_FLAG
, REPORTING_ONLY_FLAG REPORTING_ONLY_FLAG
, TAX_ONLY_FLAG TAX_ONLY_FLAG
, OFFSET_FLAG OFFSET_FLAG
, POSTED_FLAG POSTED_FLAG
, MRC_TAX_LINE_FLAG MRC_TAX_LINE_FLAG
, SMALL_BUSINESS_FLAG SMALL_BUSINESS_FLAG
, RECONCILIATION_FLAG RECONCILIATION_FLAG
, TAX_RECOVERABLE_FLAG TAX_RECOVERABLE_FLAG
, REVERSE_FLAG REVERSE_FLAG
, AR_CASH_RECEIPT_REVERSE_STATUS AR_CASH_RECEIPT_REVERSE_STATUS
, AR_CASH_RECEIPT_REVERSE_DATE AR_CASH_RECEIPT_REVERSE_DATE
, TAXABLE_ITEM_SOURCE_ID TAXABLE_ITEM_SOURCE_ID
, AMOUNT_APPLIED AMOUNT_APPLIED
, BR_REF_CUSTOMER_TRX_ID BR_REF_CUSTOMER_TRX_ID
, TAX_AMT_INCLUDED_FLAG TAX_AMT_INCLUDED_FLAG
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_LOGIN_ID PROGRAM_LOGIN_ID
, GDF_PARTY_SITES_BILL_ATT8 GDF_PARTY_SITES_BILL_ATT8
, GDF_RA_CUST_BILL_ATT10 GDF_RA_CUST_BILL_ATT10
, GDF_RA_CUST_BILL_ATT12 GDF_RA_CUST_BILL_ATT12
, GDF_RA_ADDRESSES_BILL_ATT8 GDF_RA_ADDRESSES_BILL_ATT8
, GDF_RA_ADDRESSES_BILL_ATT9 GDF_RA_ADDRESSES_BILL_ATT9
, GDF_PARTY_SITES_SHIP_ATT8 GDF_PARTY_SITES_SHIP_ATT8
, GDF_RA_CUST_SHIP_ATT10 GDF_RA_CUST_SHIP_ATT10
, GDF_RA_CUST_SHIP_ATT12 GDF_RA_CUST_SHIP_ATT12
, GDF_RA_ADDRESSES_SHIP_ATT8 GDF_RA_ADDRESSES_SHIP_ATT8
, GDF_RA_ADDRESSES_SHIP_ATT9 GDF_RA_ADDRESSES_SHIP_ATT9
, GDF_PO_VENDOR_SITE_ATT17 GDF_PO_VENDOR_SITE_ATT17
, ACCTD_AMOUNT_CR ACCTD_AMOUNT_CR
, ACCTD_AMOUNT_DR ACCTD_AMOUNT_DR
, REC_APPLICATION_STATUS REC_APPLICATION_STATUS
, SUB_LEDGER_INVOICE_IDENTIFIER SUB_LEDGER_INVOICE_IDENTIFIER
, ACCOUNT_CLASS ACCOUNT_CLASS
, LATEST_REC_FLAG LATEST_REC_FLAG
, ENTITY_CODE ENTITY_CODE
, POSTED_DATE POSTED_DATE
, ACTG_SOURCE_ID ACTG_SOURCE_ID
, UNIT_PRICE UNIT_PRICE
, GL_DATE GL_DATE
FROM "ZX"."ZX_REP_TRX_DETAIL_T"