VIEW: AP.AP_INVOICE_PAYMENTS_ALL#

Source

View Text - Preformatted

select ACCOUNTING_EVENT_ID ACCOUNTING_EVENT_ID, ACCOUNTING_DATE ACCOUNTING_DATE, ACCRUAL_POSTED_FLAG ACCRUAL_POSTED_FLAG, AMOUNT AMOUNT, CASH_POSTED_FLAG CASH_POSTED_FLAG, CHECK_ID CHECK_ID, INVOICE_ID INVOICE_ID, INVOICE_PAYMENT_ID INVOICE_PAYMENT_ID, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, PAYMENT_NUM PAYMENT_NUM, PERIOD_NAME PERIOD_NAME, POSTED_FLAG POSTED_FLAG, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, ACCTS_PAY_CODE_COMBINATION_ID ACCTS_PAY_CODE_COMBINATION_ID, ASSET_CODE_COMBINATION_ID ASSET_CODE_COMBINATION_ID, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, BANK_ACCOUNT_NUM BANK_ACCOUNT_NUM, BANK_ACCOUNT_TYPE BANK_ACCOUNT_TYPE, BANK_NUM BANK_NUM, DISCOUNT_LOST DISCOUNT_LOST, DISCOUNT_TAKEN DISCOUNT_TAKEN, EXCHANGE_DATE EXCHANGE_DATE, EXCHANGE_RATE EXCHANGE_RATE, EXCHANGE_RATE_TYPE EXCHANGE_RATE_TYPE, GAIN_CODE_COMBINATION_ID GAIN_CODE_COMBINATION_ID, INVOICE_BASE_AMOUNT INVOICE_BASE_AMOUNT, LOSS_CODE_COMBINATION_ID LOSS_CODE_COMBINATION_ID, PAYMENT_BASE_AMOUNT PAYMENT_BASE_AMOUNT, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, CASH_JE_BATCH_ID CASH_JE_BATCH_ID, FUTURE_PAY_CODE_COMBINATION_ID FUTURE_PAY_CODE_COMBINATION_ID, FUTURE_PAY_POSTED_FLAG FUTURE_PAY_POSTED_FLAG, JE_BATCH_ID JE_BATCH_ID, ELECTRONIC_TRANSFER_ID ELECTRONIC_TRANSFER_ID, ASSETS_ADDITION_FLAG ASSETS_ADDITION_FLAG, INVOICE_PAYMENT_TYPE INVOICE_PAYMENT_TYPE, OTHER_INVOICE_ID OTHER_INVOICE_ID, ORG_ID ORG_ID, 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, EXTERNAL_BANK_ACCOUNT_ID EXTERNAL_BANK_ACCOUNT_ID, MRC_EXCHANGE_DATE MRC_EXCHANGE_DATE, MRC_EXCHANGE_RATE MRC_EXCHANGE_RATE, MRC_EXCHANGE_RATE_TYPE MRC_EXCHANGE_RATE_TYPE, MRC_GAIN_CODE_COMBINATION_ID MRC_GAIN_CODE_COMBINATION_ID, MRC_INVOICE_BASE_AMOUNT MRC_INVOICE_BASE_AMOUNT, MRC_LOSS_CODE_COMBINATION_ID MRC_LOSS_CODE_COMBINATION_ID, MRC_PAYMENT_BASE_AMOUNT MRC_PAYMENT_BASE_AMOUNT, REVERSAL_FLAG REVERSAL_FLAG, REVERSAL_INV_PMT_ID REVERSAL_INV_PMT_ID, IBAN_NUMBER IBAN_NUMBER, INVOICING_PARTY_ID INVOICING_PARTY_ID, INVOICING_PARTY_SITE_ID INVOICING_PARTY_SITE_ID, INVOICING_VENDOR_SITE_ID INVOICING_VENDOR_SITE_ID, REMIT_TO_SUPPLIER_NAME REMIT_TO_SUPPLIER_NAME, REMIT_TO_SUPPLIER_ID REMIT_TO_SUPPLIER_ID, REMIT_TO_SUPPLIER_SITE REMIT_TO_SUPPLIER_SITE, REMIT_TO_SUPPLIER_SITE_ID REMIT_TO_SUPPLIER_SITE_ID from "AP"."AP_INVOICE_PAYMENTS_ALL"

View Text - HTML Formatted

SELECT ACCOUNTING_EVENT_ID ACCOUNTING_EVENT_ID
, ACCOUNTING_DATE ACCOUNTING_DATE
, ACCRUAL_POSTED_FLAG ACCRUAL_POSTED_FLAG
, AMOUNT AMOUNT
, CASH_POSTED_FLAG CASH_POSTED_FLAG
, CHECK_ID CHECK_ID
, INVOICE_ID INVOICE_ID
, INVOICE_PAYMENT_ID INVOICE_PAYMENT_ID
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, PAYMENT_NUM PAYMENT_NUM
, PERIOD_NAME PERIOD_NAME
, POSTED_FLAG POSTED_FLAG
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, ACCTS_PAY_CODE_COMBINATION_ID ACCTS_PAY_CODE_COMBINATION_ID
, ASSET_CODE_COMBINATION_ID ASSET_CODE_COMBINATION_ID
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, BANK_ACCOUNT_NUM BANK_ACCOUNT_NUM
, BANK_ACCOUNT_TYPE BANK_ACCOUNT_TYPE
, BANK_NUM BANK_NUM
, DISCOUNT_LOST DISCOUNT_LOST
, DISCOUNT_TAKEN DISCOUNT_TAKEN
, EXCHANGE_DATE EXCHANGE_DATE
, EXCHANGE_RATE EXCHANGE_RATE
, EXCHANGE_RATE_TYPE EXCHANGE_RATE_TYPE
, GAIN_CODE_COMBINATION_ID GAIN_CODE_COMBINATION_ID
, INVOICE_BASE_AMOUNT INVOICE_BASE_AMOUNT
, LOSS_CODE_COMBINATION_ID LOSS_CODE_COMBINATION_ID
, PAYMENT_BASE_AMOUNT PAYMENT_BASE_AMOUNT
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, CASH_JE_BATCH_ID CASH_JE_BATCH_ID
, FUTURE_PAY_CODE_COMBINATION_ID FUTURE_PAY_CODE_COMBINATION_ID
, FUTURE_PAY_POSTED_FLAG FUTURE_PAY_POSTED_FLAG
, JE_BATCH_ID JE_BATCH_ID
, ELECTRONIC_TRANSFER_ID ELECTRONIC_TRANSFER_ID
, ASSETS_ADDITION_FLAG ASSETS_ADDITION_FLAG
, INVOICE_PAYMENT_TYPE INVOICE_PAYMENT_TYPE
, OTHER_INVOICE_ID OTHER_INVOICE_ID
, ORG_ID ORG_ID
, 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
, EXTERNAL_BANK_ACCOUNT_ID EXTERNAL_BANK_ACCOUNT_ID
, MRC_EXCHANGE_DATE MRC_EXCHANGE_DATE
, MRC_EXCHANGE_RATE MRC_EXCHANGE_RATE
, MRC_EXCHANGE_RATE_TYPE MRC_EXCHANGE_RATE_TYPE
, MRC_GAIN_CODE_COMBINATION_ID MRC_GAIN_CODE_COMBINATION_ID
, MRC_INVOICE_BASE_AMOUNT MRC_INVOICE_BASE_AMOUNT
, MRC_LOSS_CODE_COMBINATION_ID MRC_LOSS_CODE_COMBINATION_ID
, MRC_PAYMENT_BASE_AMOUNT MRC_PAYMENT_BASE_AMOUNT
, REVERSAL_FLAG REVERSAL_FLAG
, REVERSAL_INV_PMT_ID REVERSAL_INV_PMT_ID
, IBAN_NUMBER IBAN_NUMBER
, INVOICING_PARTY_ID INVOICING_PARTY_ID
, INVOICING_PARTY_SITE_ID INVOICING_PARTY_SITE_ID
, INVOICING_VENDOR_SITE_ID INVOICING_VENDOR_SITE_ID
, REMIT_TO_SUPPLIER_NAME REMIT_TO_SUPPLIER_NAME
, REMIT_TO_SUPPLIER_ID REMIT_TO_SUPPLIER_ID
, REMIT_TO_SUPPLIER_SITE REMIT_TO_SUPPLIER_SITE
, REMIT_TO_SUPPLIER_SITE_ID REMIT_TO_SUPPLIER_SITE_ID
FROM "AP"."AP_INVOICE_PAYMENTS_ALL"