VIEW: AP.AP_SELECTED_INVOICE_CHECKS_AL#

Source

View Text - Preformatted

select CHECKRUN_NAME CHECKRUN_NAME, CHECK_NUMBER CHECK_NUMBER, VENDOR_ID VENDOR_ID, VENDOR_SITE_ID VENDOR_SITE_ID, PRINT_SEQUENCE_NUM PRINT_SEQUENCE_NUM, CHECK_AMOUNT CHECK_AMOUNT, VENDOR_AMOUNT VENDOR_AMOUNT, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, OK_TO_PAY_FLAG OK_TO_PAY_FLAG, DONT_PAY_REASON_CODE DONT_PAY_REASON_CODE, STATUS_LOOKUP_CODE STATUS_LOOKUP_CODE, 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, VOID_FLAG VOID_FLAG, CHECK_ID CHECK_ID, CURRENCY_CODE CURRENCY_CODE, DISCOUNT_AMOUNT DISCOUNT_AMOUNT, BANK_ACCOUNT_NUM BANK_ACCOUNT_NUM, BANK_NUM BANK_NUM, BANK_ACCOUNT_TYPE BANK_ACCOUNT_TYPE, CHECK_VOUCHER_NUM CHECK_VOUCHER_NUM, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, FUTURE_PAY_DUE_DATE FUTURE_PAY_DUE_DATE, DUE_DATE DUE_DATE, PAYMENT_DATE PAYMENT_DATE, SELECTED_CHECK_ID SELECTED_CHECK_ID, ATTENTION_AR_FLAG ATTENTION_AR_FLAG, ORG_ID ORG_ID, TRANSFER_PRIORITY TRANSFER_PRIORITY, EXTERNAL_BANK_ACCOUNT_ID EXTERNAL_BANK_ACCOUNT_ID, ADDRESS_LINE4 ADDRESS_LINE4, IBAN_NUMBER IBAN_NUMBER from "AP"."AP_SELECTED_INVOICE_CHECKS_ALL"

View Text - HTML Formatted

SELECT CHECKRUN_NAME CHECKRUN_NAME
, CHECK_NUMBER CHECK_NUMBER
, VENDOR_ID VENDOR_ID
, VENDOR_SITE_ID VENDOR_SITE_ID
, PRINT_SEQUENCE_NUM PRINT_SEQUENCE_NUM
, CHECK_AMOUNT CHECK_AMOUNT
, VENDOR_AMOUNT VENDOR_AMOUNT
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, OK_TO_PAY_FLAG OK_TO_PAY_FLAG
, DONT_PAY_REASON_CODE DONT_PAY_REASON_CODE
, STATUS_LOOKUP_CODE STATUS_LOOKUP_CODE
, 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
, VOID_FLAG VOID_FLAG
, CHECK_ID CHECK_ID
, CURRENCY_CODE CURRENCY_CODE
, DISCOUNT_AMOUNT DISCOUNT_AMOUNT
, BANK_ACCOUNT_NUM BANK_ACCOUNT_NUM
, BANK_NUM BANK_NUM
, BANK_ACCOUNT_TYPE BANK_ACCOUNT_TYPE
, CHECK_VOUCHER_NUM CHECK_VOUCHER_NUM
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, FUTURE_PAY_DUE_DATE FUTURE_PAY_DUE_DATE
, DUE_DATE DUE_DATE
, PAYMENT_DATE PAYMENT_DATE
, SELECTED_CHECK_ID SELECTED_CHECK_ID
, ATTENTION_AR_FLAG ATTENTION_AR_FLAG
, ORG_ID ORG_ID
, TRANSFER_PRIORITY TRANSFER_PRIORITY
, EXTERNAL_BANK_ACCOUNT_ID EXTERNAL_BANK_ACCOUNT_ID
, ADDRESS_LINE4 ADDRESS_LINE4
, IBAN_NUMBER IBAN_NUMBER
FROM "AP"."AP_SELECTED_INVOICE_CHECKS_ALL"