VIEW: AP.AP_INV_SELECTION_CRITERIA_ALL#

Source

View Text - Preformatted

select CHECKRUN_NAME CHECKRUN_NAME, CHECK_DATE CHECK_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, BANK_ACCOUNT_NAME BANK_ACCOUNT_NAME, PERIOD_NAME PERIOD_NAME, PAY_THRU_DATE PAY_THRU_DATE, VENDOR_PAY_GROUP VENDOR_PAY_GROUP, HI_PAYMENT_PRIORITY HI_PAYMENT_PRIORITY, LOW_PAYMENT_PRIORITY LOW_PAYMENT_PRIORITY, MAX_PAYMENT_AMOUNT MAX_PAYMENT_AMOUNT, MIN_CHECK_AMOUNT MIN_CHECK_AMOUNT, MAX_OUTLAY MAX_OUTLAY, PAY_ONLY_WHEN_DUE_FLAG PAY_ONLY_WHEN_DUE_FLAG, STATUS STATUS, CHECK_STOCK_ID CHECK_STOCK_ID, CURRENCY_CODE CURRENCY_CODE, EXCHANGE_RATE EXCHANGE_RATE, EXCHANGE_RATE_TYPE EXCHANGE_RATE_TYPE, EXCHANGE_DATE EXCHANGE_DATE, DOCUMENT_ORDER_LOOKUP_CODE DOCUMENT_ORDER_LOOKUP_CODE, AUDIT_REQUIRED_FLAG AUDIT_REQUIRED_FLAG, INTERVAL INTERVAL, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, VOLUME_SERIAL_NUMBER VOLUME_SERIAL_NUMBER, 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, USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE, USSGL_TRX_CODE_CONTEXT USSGL_TRX_CODE_CONTEXT, ZERO_AMOUNTS_ALLOWED ZERO_AMOUNTS_ALLOWED, START_PRINT_DOCUMENT START_PRINT_DOCUMENT, END_PRINT_DOCUMENT END_PRINT_DOCUMENT, FIRST_VOUCHER_NUMBER FIRST_VOUCHER_NUMBER, FIRST_AVAILABLE_DOCUMENT FIRST_AVAILABLE_DOCUMENT, PAYMENT_METHOD_LOOKUP_CODE PAYMENT_METHOD_LOOKUP_CODE, ZERO_INVOICES_ALLOWED ZERO_INVOICES_ALLOWED, ORG_ID ORG_ID, CHECKRUN_ID CHECKRUN_ID, BATCH_IDENTIFIER BATCH_IDENTIFIER, BANK_ACCOUNT_ID BANK_ACCOUNT_ID, TEMPLATE_FLAG TEMPLATE_FLAG, TRANSFER_PRIORITY TRANSFER_PRIORITY, BATCH_RUN_NAME BATCH_RUN_NAME, BATCH_SET_ID BATCH_SET_ID, BATCH_SET_LINE_ID BATCH_SET_LINE_ID, FUTURE_DATED_PAYMENT_FLAG FUTURE_DATED_PAYMENT_FLAG, ANTICIPATED_VALUE_DATE ANTICIPATED_VALUE_DATE, INVOICE_BATCH_ID INVOICE_BATCH_ID, VENDOR_ID VENDOR_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, REQUEST_ID REQUEST_ID, TEMPLATE_ID TEMPLATE_ID, PAY_FROM_DATE PAY_FROM_DATE, VENDOR_TYPE_LOOKUP_CODE VENDOR_TYPE_LOOKUP_CODE, PAYMENT_PROFILE_ID PAYMENT_PROFILE_ID, INV_EXCHANGE_RATE_TYPE INV_EXCHANGE_RATE_TYPE, PAYABLES_REVIEW_SETTINGS PAYABLES_REVIEW_SETTINGS, CALC_AWT_INT_FLAG CALC_AWT_INT_FLAG, PAYMENTS_REVIEW_SETTINGS PAYMENTS_REVIEW_SETTINGS, DOCUMENT_REJECTION_LEVEL_CODE DOCUMENT_REJECTION_LEVEL_CODE, PAYMENT_REJECTION_LEVEL_CODE PAYMENT_REJECTION_LEVEL_CODE, CREATE_INSTRS_FLAG CREATE_INSTRS_FLAG, PAY_GROUP_OPTION PAY_GROUP_OPTION, CURRENCY_GROUP_OPTION CURRENCY_GROUP_OPTION, LE_GROUP_OPTION LE_GROUP_OPTION, OU_GROUP_OPTION OU_GROUP_OPTION, PAYMENT_METHOD_CODE PAYMENT_METHOD_CODE, BANK_CHARGE_BEARER BANK_CHARGE_BEARER, SETTLEMENT_PRIORITY SETTLEMENT_PRIORITY, RESUBMIT_FLAG RESUBMIT_FLAG, NEXT_VOUCHER_NUMBER NEXT_VOUCHER_NUMBER, PARTY_ID PARTY_ID, PAYMENT_DOCUMENT_ID PAYMENT_DOCUMENT_ID, CE_BANK_ACCT_USE_ID CE_BANK_ACCT_USE_ID, INV_AWT_EXISTS_FLAG INV_AWT_EXISTS_FLAG from "AP"."AP_INV_SELECTION_CRITERIA_ALL"

View Text - HTML Formatted

SELECT CHECKRUN_NAME CHECKRUN_NAME
, CHECK_DATE CHECK_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, BANK_ACCOUNT_NAME BANK_ACCOUNT_NAME
, PERIOD_NAME PERIOD_NAME
, PAY_THRU_DATE PAY_THRU_DATE
, VENDOR_PAY_GROUP VENDOR_PAY_GROUP
, HI_PAYMENT_PRIORITY HI_PAYMENT_PRIORITY
, LOW_PAYMENT_PRIORITY LOW_PAYMENT_PRIORITY
, MAX_PAYMENT_AMOUNT MAX_PAYMENT_AMOUNT
, MIN_CHECK_AMOUNT MIN_CHECK_AMOUNT
, MAX_OUTLAY MAX_OUTLAY
, PAY_ONLY_WHEN_DUE_FLAG PAY_ONLY_WHEN_DUE_FLAG
, STATUS STATUS
, CHECK_STOCK_ID CHECK_STOCK_ID
, CURRENCY_CODE CURRENCY_CODE
, EXCHANGE_RATE EXCHANGE_RATE
, EXCHANGE_RATE_TYPE EXCHANGE_RATE_TYPE
, EXCHANGE_DATE EXCHANGE_DATE
, DOCUMENT_ORDER_LOOKUP_CODE DOCUMENT_ORDER_LOOKUP_CODE
, AUDIT_REQUIRED_FLAG AUDIT_REQUIRED_FLAG
, INTERVAL INTERVAL
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, VOLUME_SERIAL_NUMBER VOLUME_SERIAL_NUMBER
, 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
, USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE
, USSGL_TRX_CODE_CONTEXT USSGL_TRX_CODE_CONTEXT
, ZERO_AMOUNTS_ALLOWED ZERO_AMOUNTS_ALLOWED
, START_PRINT_DOCUMENT START_PRINT_DOCUMENT
, END_PRINT_DOCUMENT END_PRINT_DOCUMENT
, FIRST_VOUCHER_NUMBER FIRST_VOUCHER_NUMBER
, FIRST_AVAILABLE_DOCUMENT FIRST_AVAILABLE_DOCUMENT
, PAYMENT_METHOD_LOOKUP_CODE PAYMENT_METHOD_LOOKUP_CODE
, ZERO_INVOICES_ALLOWED ZERO_INVOICES_ALLOWED
, ORG_ID ORG_ID
, CHECKRUN_ID CHECKRUN_ID
, BATCH_IDENTIFIER BATCH_IDENTIFIER
, BANK_ACCOUNT_ID BANK_ACCOUNT_ID
, TEMPLATE_FLAG TEMPLATE_FLAG
, TRANSFER_PRIORITY TRANSFER_PRIORITY
, BATCH_RUN_NAME BATCH_RUN_NAME
, BATCH_SET_ID BATCH_SET_ID
, BATCH_SET_LINE_ID BATCH_SET_LINE_ID
, FUTURE_DATED_PAYMENT_FLAG FUTURE_DATED_PAYMENT_FLAG
, ANTICIPATED_VALUE_DATE ANTICIPATED_VALUE_DATE
, INVOICE_BATCH_ID INVOICE_BATCH_ID
, VENDOR_ID VENDOR_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, REQUEST_ID REQUEST_ID
, TEMPLATE_ID TEMPLATE_ID
, PAY_FROM_DATE PAY_FROM_DATE
, VENDOR_TYPE_LOOKUP_CODE VENDOR_TYPE_LOOKUP_CODE
, PAYMENT_PROFILE_ID PAYMENT_PROFILE_ID
, INV_EXCHANGE_RATE_TYPE INV_EXCHANGE_RATE_TYPE
, PAYABLES_REVIEW_SETTINGS PAYABLES_REVIEW_SETTINGS
, CALC_AWT_INT_FLAG CALC_AWT_INT_FLAG
, PAYMENTS_REVIEW_SETTINGS PAYMENTS_REVIEW_SETTINGS
, DOCUMENT_REJECTION_LEVEL_CODE DOCUMENT_REJECTION_LEVEL_CODE
, PAYMENT_REJECTION_LEVEL_CODE PAYMENT_REJECTION_LEVEL_CODE
, CREATE_INSTRS_FLAG CREATE_INSTRS_FLAG
, PAY_GROUP_OPTION PAY_GROUP_OPTION
, CURRENCY_GROUP_OPTION CURRENCY_GROUP_OPTION
, LE_GROUP_OPTION LE_GROUP_OPTION
, OU_GROUP_OPTION OU_GROUP_OPTION
, PAYMENT_METHOD_CODE PAYMENT_METHOD_CODE
, BANK_CHARGE_BEARER BANK_CHARGE_BEARER
, SETTLEMENT_PRIORITY SETTLEMENT_PRIORITY
, RESUBMIT_FLAG RESUBMIT_FLAG
, NEXT_VOUCHER_NUMBER NEXT_VOUCHER_NUMBER
, PARTY_ID PARTY_ID
, PAYMENT_DOCUMENT_ID PAYMENT_DOCUMENT_ID
, CE_BANK_ACCT_USE_ID CE_BANK_ACCT_USE_ID
, INV_AWT_EXISTS_FLAG INV_AWT_EXISTS_FLAG
FROM "AP"."AP_INV_SELECTION_CRITERIA_ALL"