VIEW: ZX.ZX_REC_NREC_DIST#

Source

View Text - Preformatted

select REC_NREC_TAX_DIST_ID REC_NREC_TAX_DIST_ID, APPLICATION_ID APPLICATION_ID, ENTITY_CODE ENTITY_CODE, EVENT_CLASS_CODE EVENT_CLASS_CODE, EVENT_TYPE_CODE EVENT_TYPE_CODE, TAX_EVENT_CLASS_CODE TAX_EVENT_CLASS_CODE, TAX_EVENT_TYPE_CODE TAX_EVENT_TYPE_CODE, TRX_ID TRX_ID, TRX_LINE_ID TRX_LINE_ID, TRX_LINE_NUMBER TRX_LINE_NUMBER, TAX_LINE_ID TAX_LINE_ID, TAX_LINE_NUMBER TAX_LINE_NUMBER, TRX_LINE_DIST_ID TRX_LINE_DIST_ID, ITEM_DIST_NUMBER ITEM_DIST_NUMBER, CONTENT_OWNER_ID CONTENT_OWNER_ID, REC_NREC_TAX_DIST_NUMBER REC_NREC_TAX_DIST_NUMBER, TAX_REGIME_ID TAX_REGIME_ID, TAX_REGIME_CODE TAX_REGIME_CODE, TAX_ID TAX_ID, TAX TAX, TAX_STATUS_ID TAX_STATUS_ID, TAX_STATUS_CODE TAX_STATUS_CODE, TAX_RATE_ID TAX_RATE_ID, TAX_RATE_CODE TAX_RATE_CODE, TAX_RATE TAX_RATE, INCLUSIVE_FLAG INCLUSIVE_FLAG, RECOVERY_TYPE_ID RECOVERY_TYPE_ID, RECOVERY_TYPE_CODE RECOVERY_TYPE_CODE, RECOVERY_RATE_ID RECOVERY_RATE_ID, RECOVERY_RATE_CODE RECOVERY_RATE_CODE, REC_NREC_RATE REC_NREC_RATE, REC_TYPE_RULE_FLAG REC_TYPE_RULE_FLAG, NEW_REC_RATE_CODE_FLAG NEW_REC_RATE_CODE_FLAG, RECOVERABLE_FLAG RECOVERABLE_FLAG, REVERSE_FLAG REVERSE_FLAG, HISTORICAL_FLAG HISTORICAL_FLAG, REVERSED_TAX_DIST_ID REVERSED_TAX_DIST_ID, REC_NREC_TAX_AMT REC_NREC_TAX_AMT, REC_NREC_TAX_AMT_TAX_CURR REC_NREC_TAX_AMT_TAX_CURR, REC_NREC_TAX_AMT_FUNCL_CURR REC_NREC_TAX_AMT_FUNCL_CURR, INTENDED_USE INTENDED_USE, PROJECT_ID PROJECT_ID, TASK_ID TASK_ID, AWARD_ID AWARD_ID, EXPENDITURE_TYPE EXPENDITURE_TYPE, EXPENDITURE_ORGANIZATION_ID EXPENDITURE_ORGANIZATION_ID, EXPENDITURE_ITEM_DATE EXPENDITURE_ITEM_DATE, REC_RATE_DET_RULE_FLAG REC_RATE_DET_RULE_FLAG, LEDGER_ID LEDGER_ID, SUMMARY_TAX_LINE_ID SUMMARY_TAX_LINE_ID, RECORD_TYPE_CODE RECORD_TYPE_CODE, CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE, CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE, CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE, TAX_CURRENCY_CONVERSION_DATE TAX_CURRENCY_CONVERSION_DATE, TAX_CURRENCY_CONVERSION_TYPE TAX_CURRENCY_CONVERSION_TYPE, TAX_CURRENCY_CONVERSION_RATE TAX_CURRENCY_CONVERSION_RATE, TRX_CURRENCY_CODE TRX_CURRENCY_CODE, TAX_CURRENCY_CODE TAX_CURRENCY_CODE, TRX_LINE_DIST_AMT TRX_LINE_DIST_AMT, TRX_LINE_DIST_TAX_AMT TRX_LINE_DIST_TAX_AMT, ORIG_REC_NREC_RATE ORIG_REC_NREC_RATE, ORIG_REC_RATE_CODE ORIG_REC_RATE_CODE, ORIG_REC_NREC_TAX_AMT ORIG_REC_NREC_TAX_AMT, ORIG_REC_NREC_TAX_AMT_TAX_CURR ORIG_REC_NREC_TAX_AMT_TAX_CURR, UNROUNDED_REC_NREC_TAX_AMT UNROUNDED_REC_NREC_TAX_AMT, APPLICABILITY_RESULT_ID APPLICABILITY_RESULT_ID, REC_RATE_RESULT_ID REC_RATE_RESULT_ID, BACKWARD_COMPATIBILITY_FLAG BACKWARD_COMPATIBILITY_FLAG, OVERRIDDEN_FLAG OVERRIDDEN_FLAG, SELF_ASSESSED_FLAG SELF_ASSESSED_FLAG, FREEZE_FLAG FREEZE_FLAG, POSTING_FLAG POSTING_FLAG, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY, GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1, GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE2, GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE3, GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE4, GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE5, GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE6, GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE7, GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE8, GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE9, GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE10, GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE11, GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE12, GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE13, GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE14, GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE15, GL_DATE GL_DATE, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, LAST_UPDATE_DATE LAST_UPDATE_DATE, 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_DIST_ID REF_DOC_DIST_ID, MINIMUM_ACCOUNTABLE_UNIT MINIMUM_ACCOUNTABLE_UNIT, PRECISION PRECISION, ROUNDING_RULE_CODE ROUNDING_RULE_CODE, TAXABLE_AMT TAXABLE_AMT, TAXABLE_AMT_TAX_CURR TAXABLE_AMT_TAX_CURR, TAXABLE_AMT_FUNCL_CURR TAXABLE_AMT_FUNCL_CURR, TAX_ONLY_LINE_FLAG TAX_ONLY_LINE_FLAG, UNROUNDED_TAXABLE_AMT UNROUNDED_TAXABLE_AMT, LEGAL_ENTITY_ID LEGAL_ENTITY_ID, ACCOUNT_CCID ACCOUNT_CCID, ACCOUNT_STRING ACCOUNT_STRING, PRD_TAX_AMT PRD_TAX_AMT, PRD_TAX_AMT_TAX_CURR PRD_TAX_AMT_TAX_CURR, PRD_TAX_AMT_FUNCL_CURR PRD_TAX_AMT_FUNCL_CURR, PRD_TOTAL_TAX_AMT PRD_TOTAL_TAX_AMT, PRD_TOTAL_TAX_AMT_TAX_CURR PRD_TOTAL_TAX_AMT_TAX_CURR, PRD_TOTAL_TAX_AMT_FUNCL_CURR PRD_TOTAL_TAX_AMT_FUNCL_CURR, APPLIED_FROM_TAX_DIST_ID APPLIED_FROM_TAX_DIST_ID, ADJUSTED_DOC_TAX_DIST_ID ADJUSTED_DOC_TAX_DIST_ID, FUNC_CURR_ROUNDING_ADJUSTMENT FUNC_CURR_ROUNDING_ADJUSTMENT, GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE16, GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE17, GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE18, GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE19, GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE20, LAST_MANUAL_ENTRY LAST_MANUAL_ENTRY, TAX_APPORTIONMENT_LINE_NUMBER TAX_APPORTIONMENT_LINE_NUMBER, REF_DOC_TAX_DIST_ID REF_DOC_TAX_DIST_ID, MRC_TAX_DIST_FLAG MRC_TAX_DIST_FLAG, MRC_LINK_TO_TAX_DIST_ID MRC_LINK_TO_TAX_DIST_ID, TAX_APPORTIONMENT_FLAG TAX_APPORTIONMENT_FLAG, RATE_TAX_FACTOR RATE_TAX_FACTOR, REF_DOC_PER_UNIT_NREC_TAX_AMT REF_DOC_PER_UNIT_NREC_TAX_AMT, PER_UNIT_NREC_TAX_AMT PER_UNIT_NREC_TAX_AMT, TRX_LINE_DIST_QTY TRX_LINE_DIST_QTY, REF_DOC_TRX_LINE_DIST_QTY REF_DOC_TRX_LINE_DIST_QTY, PRICE_DIFF PRICE_DIFF, QTY_DIFF QTY_DIFF, PER_TRX_CURR_UNIT_NR_AMT PER_TRX_CURR_UNIT_NR_AMT, REF_PER_TRX_CURR_UNIT_NR_AMT REF_PER_TRX_CURR_UNIT_NR_AMT, REF_DOC_CURR_CONV_RATE REF_DOC_CURR_CONV_RATE, UNIT_PRICE UNIT_PRICE, REF_DOC_UNIT_PRICE REF_DOC_UNIT_PRICE, APPLIED_TO_DOC_CURR_CONV_RATE APPLIED_TO_DOC_CURR_CONV_RATE, TRX_NUMBER TRX_NUMBER, TRX_LEVEL_TYPE TRX_LEVEL_TYPE, REF_DOC_TRX_LEVEL_TYPE REF_DOC_TRX_LEVEL_TYPE, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, ORIG_AP_CHRG_DIST_NUM ORIG_AP_CHRG_DIST_NUM, ORIG_AP_CHRG_DIST_ID ORIG_AP_CHRG_DIST_ID, ORIG_AP_TAX_DIST_NUM ORIG_AP_TAX_DIST_NUM, ORIG_AP_TAX_DIST_ID ORIG_AP_TAX_DIST_ID, INTERNAL_ORGANIZATION_ID INTERNAL_ORGANIZATION_ID, TAX_JURISDICTION_ID TAX_JURISDICTION_ID, DEF_REC_SETTLEMENT_OPTION_CODE DEF_REC_SETTLEMENT_OPTION_CODE, ACCOUNT_SOURCE_TAX_RATE_ID ACCOUNT_SOURCE_TAX_RATE_ID, ORIG_GL_DATE ORIG_GL_DATE from "ZX"."ZX_REC_NREC_DIST"

View Text - HTML Formatted

SELECT REC_NREC_TAX_DIST_ID REC_NREC_TAX_DIST_ID
, APPLICATION_ID APPLICATION_ID
, ENTITY_CODE ENTITY_CODE
, EVENT_CLASS_CODE EVENT_CLASS_CODE
, EVENT_TYPE_CODE EVENT_TYPE_CODE
, TAX_EVENT_CLASS_CODE TAX_EVENT_CLASS_CODE
, TAX_EVENT_TYPE_CODE TAX_EVENT_TYPE_CODE
, TRX_ID TRX_ID
, TRX_LINE_ID TRX_LINE_ID
, TRX_LINE_NUMBER TRX_LINE_NUMBER
, TAX_LINE_ID TAX_LINE_ID
, TAX_LINE_NUMBER TAX_LINE_NUMBER
, TRX_LINE_DIST_ID TRX_LINE_DIST_ID
, ITEM_DIST_NUMBER ITEM_DIST_NUMBER
, CONTENT_OWNER_ID CONTENT_OWNER_ID
, REC_NREC_TAX_DIST_NUMBER REC_NREC_TAX_DIST_NUMBER
, TAX_REGIME_ID TAX_REGIME_ID
, TAX_REGIME_CODE TAX_REGIME_CODE
, TAX_ID TAX_ID
, TAX TAX
, TAX_STATUS_ID TAX_STATUS_ID
, TAX_STATUS_CODE TAX_STATUS_CODE
, TAX_RATE_ID TAX_RATE_ID
, TAX_RATE_CODE TAX_RATE_CODE
, TAX_RATE TAX_RATE
, INCLUSIVE_FLAG INCLUSIVE_FLAG
, RECOVERY_TYPE_ID RECOVERY_TYPE_ID
, RECOVERY_TYPE_CODE RECOVERY_TYPE_CODE
, RECOVERY_RATE_ID RECOVERY_RATE_ID
, RECOVERY_RATE_CODE RECOVERY_RATE_CODE
, REC_NREC_RATE REC_NREC_RATE
, REC_TYPE_RULE_FLAG REC_TYPE_RULE_FLAG
, NEW_REC_RATE_CODE_FLAG NEW_REC_RATE_CODE_FLAG
, RECOVERABLE_FLAG RECOVERABLE_FLAG
, REVERSE_FLAG REVERSE_FLAG
, HISTORICAL_FLAG HISTORICAL_FLAG
, REVERSED_TAX_DIST_ID REVERSED_TAX_DIST_ID
, REC_NREC_TAX_AMT REC_NREC_TAX_AMT
, REC_NREC_TAX_AMT_TAX_CURR REC_NREC_TAX_AMT_TAX_CURR
, REC_NREC_TAX_AMT_FUNCL_CURR REC_NREC_TAX_AMT_FUNCL_CURR
, INTENDED_USE INTENDED_USE
, PROJECT_ID PROJECT_ID
, TASK_ID TASK_ID
, AWARD_ID AWARD_ID
, EXPENDITURE_TYPE EXPENDITURE_TYPE
, EXPENDITURE_ORGANIZATION_ID EXPENDITURE_ORGANIZATION_ID
, EXPENDITURE_ITEM_DATE EXPENDITURE_ITEM_DATE
, REC_RATE_DET_RULE_FLAG REC_RATE_DET_RULE_FLAG
, LEDGER_ID LEDGER_ID
, SUMMARY_TAX_LINE_ID SUMMARY_TAX_LINE_ID
, RECORD_TYPE_CODE RECORD_TYPE_CODE
, CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE
, CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE
, CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE
, TAX_CURRENCY_CONVERSION_DATE TAX_CURRENCY_CONVERSION_DATE
, TAX_CURRENCY_CONVERSION_TYPE TAX_CURRENCY_CONVERSION_TYPE
, TAX_CURRENCY_CONVERSION_RATE TAX_CURRENCY_CONVERSION_RATE
, TRX_CURRENCY_CODE TRX_CURRENCY_CODE
, TAX_CURRENCY_CODE TAX_CURRENCY_CODE
, TRX_LINE_DIST_AMT TRX_LINE_DIST_AMT
, TRX_LINE_DIST_TAX_AMT TRX_LINE_DIST_TAX_AMT
, ORIG_REC_NREC_RATE ORIG_REC_NREC_RATE
, ORIG_REC_RATE_CODE ORIG_REC_RATE_CODE
, ORIG_REC_NREC_TAX_AMT ORIG_REC_NREC_TAX_AMT
, ORIG_REC_NREC_TAX_AMT_TAX_CURR ORIG_REC_NREC_TAX_AMT_TAX_CURR
, UNROUNDED_REC_NREC_TAX_AMT UNROUNDED_REC_NREC_TAX_AMT
, APPLICABILITY_RESULT_ID APPLICABILITY_RESULT_ID
, REC_RATE_RESULT_ID REC_RATE_RESULT_ID
, BACKWARD_COMPATIBILITY_FLAG BACKWARD_COMPATIBILITY_FLAG
, OVERRIDDEN_FLAG OVERRIDDEN_FLAG
, SELF_ASSESSED_FLAG SELF_ASSESSED_FLAG
, FREEZE_FLAG FREEZE_FLAG
, POSTING_FLAG POSTING_FLAG
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY
, GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE10
, GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE15
, GL_DATE GL_DATE
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, 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_DIST_ID REF_DOC_DIST_ID
, MINIMUM_ACCOUNTABLE_UNIT MINIMUM_ACCOUNTABLE_UNIT
, PRECISION PRECISION
, ROUNDING_RULE_CODE ROUNDING_RULE_CODE
, TAXABLE_AMT TAXABLE_AMT
, TAXABLE_AMT_TAX_CURR TAXABLE_AMT_TAX_CURR
, TAXABLE_AMT_FUNCL_CURR TAXABLE_AMT_FUNCL_CURR
, TAX_ONLY_LINE_FLAG TAX_ONLY_LINE_FLAG
, UNROUNDED_TAXABLE_AMT UNROUNDED_TAXABLE_AMT
, LEGAL_ENTITY_ID LEGAL_ENTITY_ID
, ACCOUNT_CCID ACCOUNT_CCID
, ACCOUNT_STRING ACCOUNT_STRING
, PRD_TAX_AMT PRD_TAX_AMT
, PRD_TAX_AMT_TAX_CURR PRD_TAX_AMT_TAX_CURR
, PRD_TAX_AMT_FUNCL_CURR PRD_TAX_AMT_FUNCL_CURR
, PRD_TOTAL_TAX_AMT PRD_TOTAL_TAX_AMT
, PRD_TOTAL_TAX_AMT_TAX_CURR PRD_TOTAL_TAX_AMT_TAX_CURR
, PRD_TOTAL_TAX_AMT_FUNCL_CURR PRD_TOTAL_TAX_AMT_FUNCL_CURR
, APPLIED_FROM_TAX_DIST_ID APPLIED_FROM_TAX_DIST_ID
, ADJUSTED_DOC_TAX_DIST_ID ADJUSTED_DOC_TAX_DIST_ID
, FUNC_CURR_ROUNDING_ADJUSTMENT FUNC_CURR_ROUNDING_ADJUSTMENT
, GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE20
, LAST_MANUAL_ENTRY LAST_MANUAL_ENTRY
, TAX_APPORTIONMENT_LINE_NUMBER TAX_APPORTIONMENT_LINE_NUMBER
, REF_DOC_TAX_DIST_ID REF_DOC_TAX_DIST_ID
, MRC_TAX_DIST_FLAG MRC_TAX_DIST_FLAG
, MRC_LINK_TO_TAX_DIST_ID MRC_LINK_TO_TAX_DIST_ID
, TAX_APPORTIONMENT_FLAG TAX_APPORTIONMENT_FLAG
, RATE_TAX_FACTOR RATE_TAX_FACTOR
, REF_DOC_PER_UNIT_NREC_TAX_AMT REF_DOC_PER_UNIT_NREC_TAX_AMT
, PER_UNIT_NREC_TAX_AMT PER_UNIT_NREC_TAX_AMT
, TRX_LINE_DIST_QTY TRX_LINE_DIST_QTY
, REF_DOC_TRX_LINE_DIST_QTY REF_DOC_TRX_LINE_DIST_QTY
, PRICE_DIFF PRICE_DIFF
, QTY_DIFF QTY_DIFF
, PER_TRX_CURR_UNIT_NR_AMT PER_TRX_CURR_UNIT_NR_AMT
, REF_PER_TRX_CURR_UNIT_NR_AMT REF_PER_TRX_CURR_UNIT_NR_AMT
, REF_DOC_CURR_CONV_RATE REF_DOC_CURR_CONV_RATE
, UNIT_PRICE UNIT_PRICE
, REF_DOC_UNIT_PRICE REF_DOC_UNIT_PRICE
, APPLIED_TO_DOC_CURR_CONV_RATE APPLIED_TO_DOC_CURR_CONV_RATE
, TRX_NUMBER TRX_NUMBER
, TRX_LEVEL_TYPE TRX_LEVEL_TYPE
, REF_DOC_TRX_LEVEL_TYPE REF_DOC_TRX_LEVEL_TYPE
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, ORIG_AP_CHRG_DIST_NUM ORIG_AP_CHRG_DIST_NUM
, ORIG_AP_CHRG_DIST_ID ORIG_AP_CHRG_DIST_ID
, ORIG_AP_TAX_DIST_NUM ORIG_AP_TAX_DIST_NUM
, ORIG_AP_TAX_DIST_ID ORIG_AP_TAX_DIST_ID
, INTERNAL_ORGANIZATION_ID INTERNAL_ORGANIZATION_ID
, TAX_JURISDICTION_ID TAX_JURISDICTION_ID
, DEF_REC_SETTLEMENT_OPTION_CODE DEF_REC_SETTLEMENT_OPTION_CODE
, ACCOUNT_SOURCE_TAX_RATE_ID ACCOUNT_SOURCE_TAX_RATE_ID
, ORIG_GL_DATE ORIG_GL_DATE
FROM "ZX"."ZX_REC_NREC_DIST"