DBA Data[Home] [Help]

VIEW: AP.AP_SELECTED_INVOICES_ALL#

Source

View Text - Preformatted

select CHECKRUN_NAME CHECKRUN_NAME, INVOICE_ID INVOICE_ID, PAYMENT_NUM PAYMENT_NUM, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, VENDOR_ID VENDOR_ID, VENDOR_SITE_ID VENDOR_SITE_ID, VENDOR_NUM VENDOR_NUM, VENDOR_NAME VENDOR_NAME, VENDOR_SITE_CODE VENDOR_SITE_CODE, CUSTOMER_NUM CUSTOMER_NUM, ADDRESS_LINE1 ADDRESS_LINE1, ADDRESS_LINE2 ADDRESS_LINE2, ADDRESS_LINE3 ADDRESS_LINE3, CITY CITY, STATE STATE, ZIP ZIP, PROVINCE PROVINCE, COUNTRY COUNTRY, WITHHOLDING_STATUS_LOOKUP_CODE WITHHOLDING_STATUS_LOOKUP_CODE, ATTENTION_AR_FLAG ATTENTION_AR_FLAG, INVOICE_NUM INVOICE_NUM, INVOICE_DATE INVOICE_DATE, VOUCHER_NUM VOUCHER_NUM, INVOICE_AMOUNT INVOICE_AMOUNT, AMOUNT_PAID AMOUNT_PAID, DISCOUNT_AMOUNT_TAKEN DISCOUNT_AMOUNT_TAKEN, AP_CCID AP_CCID, DUE_DATE DUE_DATE, DISCOUNT_DATE DISCOUNT_DATE, INVOICE_DESCRIPTION INVOICE_DESCRIPTION, PAYMENT_PRIORITY PAYMENT_PRIORITY, AMOUNT_REMAINING AMOUNT_REMAINING, DISCOUNT_AMOUNT_REMAINING DISCOUNT_AMOUNT_REMAINING, PAYMENT_AMOUNT PAYMENT_AMOUNT, DISCOUNT_AMOUNT DISCOUNT_AMOUNT, SEQUENCE_NUM SEQUENCE_NUM, OK_TO_PAY_FLAG OK_TO_PAY_FLAG, DONT_PAY_REASON_CODE DONT_PAY_REASON_CODE, ALWAYS_TAKE_DISCOUNT_FLAG ALWAYS_TAKE_DISCOUNT_FLAG, AMOUNT_MODIFIED_FLAG AMOUNT_MODIFIED_FLAG, CHECK_NUMBER CHECK_NUMBER, INVOICE_EXCHANGE_RATE INVOICE_EXCHANGE_RATE, PAYMENT_CROSS_RATE PAYMENT_CROSS_RATE, BANK_ACCOUNT_TYPE BANK_ACCOUNT_TYPE, ORIGINAL_INVOICE_ID ORIGINAL_INVOICE_ID, ORIGINAL_PAYMENT_NUM ORIGINAL_PAYMENT_NUM, 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, BANK_ACCOUNT_NUM BANK_ACCOUNT_NUM, BANK_NUM BANK_NUM, FUTURE_PAY_DUE_DATE FUTURE_PAY_DUE_DATE, EXCLUSIVE_PAYMENT_FLAG EXCLUSIVE_PAYMENT_FLAG, PROPOSED_PAYMENT_AMOUNT PROPOSED_PAYMENT_AMOUNT, PAY_SELECTED_CHECK_ID PAY_SELECTED_CHECK_ID, PRINT_SELECTED_CHECK_ID PRINT_SELECTED_CHECK_ID, ORG_ID ORG_ID, WITHHOLDING_AMOUNT WITHHOLDING_AMOUNT, INVOICE_PAYMENT_ID INVOICE_PAYMENT_ID, DONT_PAY_DESCRIPTION DONT_PAY_DESCRIPTION, 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, TRANSFER_PRIORITY TRANSFER_PRIORITY, EXTERNAL_BANK_ACCOUNT_ID EXTERNAL_BANK_ACCOUNT_ID, ADDRESS_LINE4 ADDRESS_LINE4, IBAN_NUMBER IBAN_NUMBER, CHECKRUN_ID CHECKRUN_ID, LEGAL_ENTITY_ID LEGAL_ENTITY_ID, PAYMENT_CURRENCY_CODE PAYMENT_CURRENCY_CODE, PAYMENT_GROUPING_NUMBER PAYMENT_GROUPING_NUMBER, PAYMENT_EXCHANGE_RATE PAYMENT_EXCHANGE_RATE, PAYMENT_EXCHANGE_RATE_TYPE PAYMENT_EXCHANGE_RATE_TYPE, PAYMENT_EXCHANGE_DATE PAYMENT_EXCHANGE_DATE, 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, AFFECTS_REJECTION_LEVEL AFFECTS_REJECTION_LEVEL from "AP"."AP_SELECTED_INVOICES_ALL"
View Text - HTML Formatted

SELECT CHECKRUN_NAME CHECKRUN_NAME
, INVOICE_ID INVOICE_ID
, PAYMENT_NUM PAYMENT_NUM
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, VENDOR_ID VENDOR_ID
, VENDOR_SITE_ID VENDOR_SITE_ID
, VENDOR_NUM VENDOR_NUM
, VENDOR_NAME VENDOR_NAME
, VENDOR_SITE_CODE VENDOR_SITE_CODE
, CUSTOMER_NUM CUSTOMER_NUM
, ADDRESS_LINE1 ADDRESS_LINE1
, ADDRESS_LINE2 ADDRESS_LINE2
, ADDRESS_LINE3 ADDRESS_LINE3
, CITY CITY
, STATE STATE
, ZIP ZIP
, PROVINCE PROVINCE
, COUNTRY COUNTRY
, WITHHOLDING_STATUS_LOOKUP_CODE WITHHOLDING_STATUS_LOOKUP_CODE
, ATTENTION_AR_FLAG ATTENTION_AR_FLAG
, INVOICE_NUM INVOICE_NUM
, INVOICE_DATE INVOICE_DATE
, VOUCHER_NUM VOUCHER_NUM
, INVOICE_AMOUNT INVOICE_AMOUNT
, AMOUNT_PAID AMOUNT_PAID
, DISCOUNT_AMOUNT_TAKEN DISCOUNT_AMOUNT_TAKEN
, AP_CCID AP_CCID
, DUE_DATE DUE_DATE
, DISCOUNT_DATE DISCOUNT_DATE
, INVOICE_DESCRIPTION INVOICE_DESCRIPTION
, PAYMENT_PRIORITY PAYMENT_PRIORITY
, AMOUNT_REMAINING AMOUNT_REMAINING
, DISCOUNT_AMOUNT_REMAINING DISCOUNT_AMOUNT_REMAINING
, PAYMENT_AMOUNT PAYMENT_AMOUNT
, DISCOUNT_AMOUNT DISCOUNT_AMOUNT
, SEQUENCE_NUM SEQUENCE_NUM
, OK_TO_PAY_FLAG OK_TO_PAY_FLAG
, DONT_PAY_REASON_CODE DONT_PAY_REASON_CODE
, ALWAYS_TAKE_DISCOUNT_FLAG ALWAYS_TAKE_DISCOUNT_FLAG
, AMOUNT_MODIFIED_FLAG AMOUNT_MODIFIED_FLAG
, CHECK_NUMBER CHECK_NUMBER
, INVOICE_EXCHANGE_RATE INVOICE_EXCHANGE_RATE
, PAYMENT_CROSS_RATE PAYMENT_CROSS_RATE
, BANK_ACCOUNT_TYPE BANK_ACCOUNT_TYPE
, ORIGINAL_INVOICE_ID ORIGINAL_INVOICE_ID
, ORIGINAL_PAYMENT_NUM ORIGINAL_PAYMENT_NUM
, 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
, BANK_ACCOUNT_NUM BANK_ACCOUNT_NUM
, BANK_NUM BANK_NUM
, FUTURE_PAY_DUE_DATE FUTURE_PAY_DUE_DATE
, EXCLUSIVE_PAYMENT_FLAG EXCLUSIVE_PAYMENT_FLAG
, PROPOSED_PAYMENT_AMOUNT PROPOSED_PAYMENT_AMOUNT
, PAY_SELECTED_CHECK_ID PAY_SELECTED_CHECK_ID
, PRINT_SELECTED_CHECK_ID PRINT_SELECTED_CHECK_ID
, ORG_ID ORG_ID
, WITHHOLDING_AMOUNT WITHHOLDING_AMOUNT
, INVOICE_PAYMENT_ID INVOICE_PAYMENT_ID
, DONT_PAY_DESCRIPTION DONT_PAY_DESCRIPTION
, 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
, TRANSFER_PRIORITY TRANSFER_PRIORITY
, EXTERNAL_BANK_ACCOUNT_ID EXTERNAL_BANK_ACCOUNT_ID
, ADDRESS_LINE4 ADDRESS_LINE4
, IBAN_NUMBER IBAN_NUMBER
, CHECKRUN_ID CHECKRUN_ID
, LEGAL_ENTITY_ID LEGAL_ENTITY_ID
, PAYMENT_CURRENCY_CODE PAYMENT_CURRENCY_CODE
, PAYMENT_GROUPING_NUMBER PAYMENT_GROUPING_NUMBER
, PAYMENT_EXCHANGE_RATE PAYMENT_EXCHANGE_RATE
, PAYMENT_EXCHANGE_RATE_TYPE PAYMENT_EXCHANGE_RATE_TYPE
, PAYMENT_EXCHANGE_DATE PAYMENT_EXCHANGE_DATE
, 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
, AFFECTS_REJECTION_LEVEL AFFECTS_REJECTION_LEVEL
FROM "AP"."AP_SELECTED_INVOICES_ALL"