VIEW: AP.AP_SELF_ASSESSED_TAX_DIST_ALL#

Source

View Text - Preformatted

select INVOICE_DISTRIBUTION_ID INVOICE_DISTRIBUTION_ID, ORG_ID ORG_ID, ACCOUNTING_DATE ACCOUNTING_DATE, ACCRUAL_POSTED_FLAG ACCRUAL_POSTED_FLAG, ASSETS_ADDITION_FLAG ASSETS_ADDITION_FLAG, ASSETS_TRACKING_FLAG ASSETS_TRACKING_FLAG, CASH_POSTED_FLAG CASH_POSTED_FLAG, DISTRIBUTION_LINE_NUMBER DISTRIBUTION_LINE_NUMBER, DIST_CODE_COMBINATION_ID DIST_CODE_COMBINATION_ID, INVOICE_ID INVOICE_ID, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LINE_TYPE_LOOKUP_CODE LINE_TYPE_LOOKUP_CODE, PERIOD_NAME PERIOD_NAME, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, SELF_ASSESSED_FLAG SELF_ASSESSED_FLAG, AMOUNT AMOUNT, BASE_AMOUNT BASE_AMOUNT, BATCH_ID BATCH_ID, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, DESCRIPTION DESCRIPTION, FINAL_MATCH_FLAG FINAL_MATCH_FLAG, INCOME_TAX_REGION INCOME_TAX_REGION, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, MATCH_STATUS_FLAG MATCH_STATUS_FLAG, POSTED_FLAG POSTED_FLAG, PO_DISTRIBUTION_ID PO_DISTRIBUTION_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, QUANTITY_INVOICED QUANTITY_INVOICED, REQUEST_ID REQUEST_ID, REVERSAL_FLAG REVERSAL_FLAG, TYPE_1099 TYPE_1099, UNIT_PRICE UNIT_PRICE, ENCUMBERED_FLAG ENCUMBERED_FLAG, STAT_AMOUNT STAT_AMOUNT, EXPENDITURE_ITEM_DATE EXPENDITURE_ITEM_DATE, EXPENDITURE_ORGANIZATION_ID EXPENDITURE_ORGANIZATION_ID, EXPENDITURE_TYPE EXPENDITURE_TYPE, PARENT_INVOICE_ID PARENT_INVOICE_ID, PA_ADDITION_FLAG PA_ADDITION_FLAG, PA_QUANTITY PA_QUANTITY, PREPAY_AMOUNT_REMAINING PREPAY_AMOUNT_REMAINING, PROJECT_ID PROJECT_ID, TASK_ID TASK_ID, USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE, USSGL_TRX_CODE_CONTEXT USSGL_TRX_CODE_CONTEXT, QUANTITY_VARIANCE QUANTITY_VARIANCE, BASE_QUANTITY_VARIANCE BASE_QUANTITY_VARIANCE, PACKET_ID PACKET_ID, AWT_FLAG AWT_FLAG, AWT_GROUP_ID AWT_GROUP_ID, AWT_TAX_RATE_ID AWT_TAX_RATE_ID, AWT_GROSS_AMOUNT AWT_GROSS_AMOUNT, AWT_INVOICE_ID AWT_INVOICE_ID, AWT_ORIGIN_GROUP_ID AWT_ORIGIN_GROUP_ID, REFERENCE_1 REFERENCE_1, REFERENCE_2 REFERENCE_2, AWT_INVOICE_PAYMENT_ID AWT_INVOICE_PAYMENT_ID, RECEIPT_VERIFIED_FLAG RECEIPT_VERIFIED_FLAG, RECEIPT_REQUIRED_FLAG RECEIPT_REQUIRED_FLAG, RECEIPT_MISSING_FLAG RECEIPT_MISSING_FLAG, JUSTIFICATION JUSTIFICATION, EXPENSE_GROUP EXPENSE_GROUP, START_EXPENSE_DATE START_EXPENSE_DATE, END_EXPENSE_DATE END_EXPENSE_DATE, RECEIPT_CURRENCY_CODE RECEIPT_CURRENCY_CODE, RECEIPT_CONVERSION_RATE RECEIPT_CONVERSION_RATE, RECEIPT_CURRENCY_AMOUNT RECEIPT_CURRENCY_AMOUNT, DAILY_AMOUNT DAILY_AMOUNT, WEB_PARAMETER_ID WEB_PARAMETER_ID, ADJUSTMENT_REASON ADJUSTMENT_REASON, AWARD_ID AWARD_ID, DIST_MATCH_TYPE DIST_MATCH_TYPE, RCV_TRANSACTION_ID RCV_TRANSACTION_ID, PARENT_REVERSAL_ID PARENT_REVERSAL_ID, TAX_RECOVERABLE_FLAG TAX_RECOVERABLE_FLAG, TAX_CODE_ID TAX_CODE_ID, MERCHANT_DOCUMENT_NUMBER MERCHANT_DOCUMENT_NUMBER, MERCHANT_NAME MERCHANT_NAME, MERCHANT_REFERENCE MERCHANT_REFERENCE, MERCHANT_TAX_REG_NUMBER MERCHANT_TAX_REG_NUMBER, MERCHANT_TAXPAYER_ID MERCHANT_TAXPAYER_ID, COUNTRY_OF_SUPPLY COUNTRY_OF_SUPPLY, MATCHED_UOM_LOOKUP_CODE MATCHED_UOM_LOOKUP_CODE, GMS_BURDENABLE_RAW_COST GMS_BURDENABLE_RAW_COST, ACCOUNTING_EVENT_ID ACCOUNTING_EVENT_ID, PREPAY_DISTRIBUTION_ID PREPAY_DISTRIBUTION_ID, CREDIT_CARD_TRX_ID CREDIT_CARD_TRX_ID, UPGRADE_POSTED_AMT UPGRADE_POSTED_AMT, UPGRADE_BASE_POSTED_AMT UPGRADE_BASE_POSTED_AMT, INVENTORY_TRANSFER_STATUS INVENTORY_TRANSFER_STATUS, COMPANY_PREPAID_INVOICE_ID COMPANY_PREPAID_INVOICE_ID, CC_REVERSAL_FLAG CC_REVERSAL_FLAG, AWT_WITHHELD_AMT AWT_WITHHELD_AMT, PA_CMT_XFACE_FLAG PA_CMT_XFACE_FLAG, CANCELLATION_FLAG CANCELLATION_FLAG, INVOICE_LINE_NUMBER INVOICE_LINE_NUMBER, ROUNDING_AMT ROUNDING_AMT, CHARGE_APPLICABLE_TO_DIST_ID CHARGE_APPLICABLE_TO_DIST_ID, CORRECTED_INVOICE_DIST_ID CORRECTED_INVOICE_DIST_ID, CORRECTED_QUANTITY CORRECTED_QUANTITY, RELATED_ID RELATED_ID, ASSET_BOOK_TYPE_CODE ASSET_BOOK_TYPE_CODE, ASSET_CATEGORY_ID ASSET_CATEGORY_ID, DISTRIBUTION_CLASS DISTRIBUTION_CLASS, INTENDED_USE INTENDED_USE, DETAIL_TAX_DIST_ID DETAIL_TAX_DIST_ID, REC_NREC_RATE REC_NREC_RATE, RECOVERY_RATE_ID RECOVERY_RATE_ID, RECOVERY_RATE_NAME RECOVERY_RATE_NAME, RECOVERY_TYPE_CODE RECOVERY_TYPE_CODE, WITHHOLDING_TAX_CODE_ID WITHHOLDING_TAX_CODE_ID, TAX_ALREADY_DISTRIBUTED_FLAG TAX_ALREADY_DISTRIBUTED_FLAG, SUMMARY_TAX_LINE_ID SUMMARY_TAX_LINE_ID, TAXABLE_AMOUNT TAXABLE_AMOUNT, TAXABLE_BASE_AMOUNT TAXABLE_BASE_AMOUNT, PREPAY_TAX_DIFF_AMOUNT PREPAY_TAX_DIFF_AMOUNT, EXTRA_PO_ERV EXTRA_PO_ERV, SELF_ASSESSED_TAX_LIAB_CCID SELF_ASSESSED_TAX_LIAB_CCID, 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, GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE16, GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE17, GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE18, GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE19, GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE20, PROJECT_ACCOUNTING_CONTEXT PROJECT_ACCOUNTING_CONTEXT, RCV_CHARGE_ADDITION_FLAG RCV_CHARGE_ADDITION_FLAG, BC_EVENT_ID BC_EVENT_ID, AMOUNT_VARIANCE AMOUNT_VARIANCE, BASE_AMOUNT_VARIANCE BASE_AMOUNT_VARIANCE from "AP"."AP_SELF_ASSESSED_TAX_DIST_ALL"

View Text - HTML Formatted

SELECT INVOICE_DISTRIBUTION_ID INVOICE_DISTRIBUTION_ID
, ORG_ID ORG_ID
, ACCOUNTING_DATE ACCOUNTING_DATE
, ACCRUAL_POSTED_FLAG ACCRUAL_POSTED_FLAG
, ASSETS_ADDITION_FLAG ASSETS_ADDITION_FLAG
, ASSETS_TRACKING_FLAG ASSETS_TRACKING_FLAG
, CASH_POSTED_FLAG CASH_POSTED_FLAG
, DISTRIBUTION_LINE_NUMBER DISTRIBUTION_LINE_NUMBER
, DIST_CODE_COMBINATION_ID DIST_CODE_COMBINATION_ID
, INVOICE_ID INVOICE_ID
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LINE_TYPE_LOOKUP_CODE LINE_TYPE_LOOKUP_CODE
, PERIOD_NAME PERIOD_NAME
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, SELF_ASSESSED_FLAG SELF_ASSESSED_FLAG
, AMOUNT AMOUNT
, BASE_AMOUNT BASE_AMOUNT
, BATCH_ID BATCH_ID
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, DESCRIPTION DESCRIPTION
, FINAL_MATCH_FLAG FINAL_MATCH_FLAG
, INCOME_TAX_REGION INCOME_TAX_REGION
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, MATCH_STATUS_FLAG MATCH_STATUS_FLAG
, POSTED_FLAG POSTED_FLAG
, PO_DISTRIBUTION_ID PO_DISTRIBUTION_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, QUANTITY_INVOICED QUANTITY_INVOICED
, REQUEST_ID REQUEST_ID
, REVERSAL_FLAG REVERSAL_FLAG
, TYPE_1099 TYPE_1099
, UNIT_PRICE UNIT_PRICE
, ENCUMBERED_FLAG ENCUMBERED_FLAG
, STAT_AMOUNT STAT_AMOUNT
, EXPENDITURE_ITEM_DATE EXPENDITURE_ITEM_DATE
, EXPENDITURE_ORGANIZATION_ID EXPENDITURE_ORGANIZATION_ID
, EXPENDITURE_TYPE EXPENDITURE_TYPE
, PARENT_INVOICE_ID PARENT_INVOICE_ID
, PA_ADDITION_FLAG PA_ADDITION_FLAG
, PA_QUANTITY PA_QUANTITY
, PREPAY_AMOUNT_REMAINING PREPAY_AMOUNT_REMAINING
, PROJECT_ID PROJECT_ID
, TASK_ID TASK_ID
, USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE
, USSGL_TRX_CODE_CONTEXT USSGL_TRX_CODE_CONTEXT
, QUANTITY_VARIANCE QUANTITY_VARIANCE
, BASE_QUANTITY_VARIANCE BASE_QUANTITY_VARIANCE
, PACKET_ID PACKET_ID
, AWT_FLAG AWT_FLAG
, AWT_GROUP_ID AWT_GROUP_ID
, AWT_TAX_RATE_ID AWT_TAX_RATE_ID
, AWT_GROSS_AMOUNT AWT_GROSS_AMOUNT
, AWT_INVOICE_ID AWT_INVOICE_ID
, AWT_ORIGIN_GROUP_ID AWT_ORIGIN_GROUP_ID
, REFERENCE_1 REFERENCE_1
, REFERENCE_2 REFERENCE_2
, AWT_INVOICE_PAYMENT_ID AWT_INVOICE_PAYMENT_ID
, RECEIPT_VERIFIED_FLAG RECEIPT_VERIFIED_FLAG
, RECEIPT_REQUIRED_FLAG RECEIPT_REQUIRED_FLAG
, RECEIPT_MISSING_FLAG RECEIPT_MISSING_FLAG
, JUSTIFICATION JUSTIFICATION
, EXPENSE_GROUP EXPENSE_GROUP
, START_EXPENSE_DATE START_EXPENSE_DATE
, END_EXPENSE_DATE END_EXPENSE_DATE
, RECEIPT_CURRENCY_CODE RECEIPT_CURRENCY_CODE
, RECEIPT_CONVERSION_RATE RECEIPT_CONVERSION_RATE
, RECEIPT_CURRENCY_AMOUNT RECEIPT_CURRENCY_AMOUNT
, DAILY_AMOUNT DAILY_AMOUNT
, WEB_PARAMETER_ID WEB_PARAMETER_ID
, ADJUSTMENT_REASON ADJUSTMENT_REASON
, AWARD_ID AWARD_ID
, DIST_MATCH_TYPE DIST_MATCH_TYPE
, RCV_TRANSACTION_ID RCV_TRANSACTION_ID
, PARENT_REVERSAL_ID PARENT_REVERSAL_ID
, TAX_RECOVERABLE_FLAG TAX_RECOVERABLE_FLAG
, TAX_CODE_ID TAX_CODE_ID
, MERCHANT_DOCUMENT_NUMBER MERCHANT_DOCUMENT_NUMBER
, MERCHANT_NAME MERCHANT_NAME
, MERCHANT_REFERENCE MERCHANT_REFERENCE
, MERCHANT_TAX_REG_NUMBER MERCHANT_TAX_REG_NUMBER
, MERCHANT_TAXPAYER_ID MERCHANT_TAXPAYER_ID
, COUNTRY_OF_SUPPLY COUNTRY_OF_SUPPLY
, MATCHED_UOM_LOOKUP_CODE MATCHED_UOM_LOOKUP_CODE
, GMS_BURDENABLE_RAW_COST GMS_BURDENABLE_RAW_COST
, ACCOUNTING_EVENT_ID ACCOUNTING_EVENT_ID
, PREPAY_DISTRIBUTION_ID PREPAY_DISTRIBUTION_ID
, CREDIT_CARD_TRX_ID CREDIT_CARD_TRX_ID
, UPGRADE_POSTED_AMT UPGRADE_POSTED_AMT
, UPGRADE_BASE_POSTED_AMT UPGRADE_BASE_POSTED_AMT
, INVENTORY_TRANSFER_STATUS INVENTORY_TRANSFER_STATUS
, COMPANY_PREPAID_INVOICE_ID COMPANY_PREPAID_INVOICE_ID
, CC_REVERSAL_FLAG CC_REVERSAL_FLAG
, AWT_WITHHELD_AMT AWT_WITHHELD_AMT
, PA_CMT_XFACE_FLAG PA_CMT_XFACE_FLAG
, CANCELLATION_FLAG CANCELLATION_FLAG
, INVOICE_LINE_NUMBER INVOICE_LINE_NUMBER
, ROUNDING_AMT ROUNDING_AMT
, CHARGE_APPLICABLE_TO_DIST_ID CHARGE_APPLICABLE_TO_DIST_ID
, CORRECTED_INVOICE_DIST_ID CORRECTED_INVOICE_DIST_ID
, CORRECTED_QUANTITY CORRECTED_QUANTITY
, RELATED_ID RELATED_ID
, ASSET_BOOK_TYPE_CODE ASSET_BOOK_TYPE_CODE
, ASSET_CATEGORY_ID ASSET_CATEGORY_ID
, DISTRIBUTION_CLASS DISTRIBUTION_CLASS
, INTENDED_USE INTENDED_USE
, DETAIL_TAX_DIST_ID DETAIL_TAX_DIST_ID
, REC_NREC_RATE REC_NREC_RATE
, RECOVERY_RATE_ID RECOVERY_RATE_ID
, RECOVERY_RATE_NAME RECOVERY_RATE_NAME
, RECOVERY_TYPE_CODE RECOVERY_TYPE_CODE
, WITHHOLDING_TAX_CODE_ID WITHHOLDING_TAX_CODE_ID
, TAX_ALREADY_DISTRIBUTED_FLAG TAX_ALREADY_DISTRIBUTED_FLAG
, SUMMARY_TAX_LINE_ID SUMMARY_TAX_LINE_ID
, TAXABLE_AMOUNT TAXABLE_AMOUNT
, TAXABLE_BASE_AMOUNT TAXABLE_BASE_AMOUNT
, PREPAY_TAX_DIFF_AMOUNT PREPAY_TAX_DIFF_AMOUNT
, EXTRA_PO_ERV EXTRA_PO_ERV
, SELF_ASSESSED_TAX_LIAB_CCID SELF_ASSESSED_TAX_LIAB_CCID
, 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
, GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE20
, PROJECT_ACCOUNTING_CONTEXT PROJECT_ACCOUNTING_CONTEXT
, RCV_CHARGE_ADDITION_FLAG RCV_CHARGE_ADDITION_FLAG
, BC_EVENT_ID BC_EVENT_ID
, AMOUNT_VARIANCE AMOUNT_VARIANCE
, BASE_AMOUNT_VARIANCE BASE_AMOUNT_VARIANCE
FROM "AP"."AP_SELF_ASSESSED_TAX_DIST_ALL"