VIEW: AP.AP_PAYMENT_TEMPLATES#

Source

View Text - Preformatted

select PAYMENT_DOCUMENT_ID PAYMENT_DOCUMENT_ID, TEMPLATE_ID TEMPLATE_ID, TEMPLATE_NAME TEMPLATE_NAME, TEMPLATE_TYPE TEMPLATE_TYPE, DESCRIPTION DESCRIPTION, INACTIVE_DATE INACTIVE_DATE, ADDL_PAY_FROM_DAYS ADDL_PAY_FROM_DAYS, ADDL_PAY_THRU_DAYS ADDL_PAY_THRU_DAYS, HI_PAYMENT_PRIORITY HI_PAYMENT_PRIORITY, LOW_PAYMENT_PRIORITY LOW_PAYMENT_PRIORITY, PAY_ONLY_WHEN_DUE_FLAG PAY_ONLY_WHEN_DUE_FLAG, ZERO_INV_ALLOWED_FLAG ZERO_INV_ALLOWED_FLAG, VENDOR_TYPE_LOOKUP_CODE VENDOR_TYPE_LOOKUP_CODE, VENDOR_ID VENDOR_ID, PARTY_ID PARTY_ID, PAYMENT_METHOD_CODE PAYMENT_METHOD_CODE, INV_EXCHANGE_RATE_TYPE INV_EXCHANGE_RATE_TYPE, 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_DATE_OPTION PAYMENT_DATE_OPTION, ADDL_PAYMENT_DAYS ADDL_PAYMENT_DAYS, BANK_ACCOUNT_ID BANK_ACCOUNT_ID, BANK_CHARGE_BEARER BANK_CHARGE_BEARER, SETTLEMENT_PRIORITY SETTLEMENT_PRIORITY, FIRST_VOUCHER_NUMBER FIRST_VOUCHER_NUMBER, TRANSFER_PRIORITY TRANSFER_PRIORITY, PAYMENT_EXCHANGE_RATE_TYPE PAYMENT_EXCHANGE_RATE_TYPE, PAYMENT_PROFILE_ID PAYMENT_PROFILE_ID, ZERO_AMOUNTS_ALLOWED ZERO_AMOUNTS_ALLOWED, PAYABLES_REVIEW_SETTINGS PAYABLES_REVIEW_SETTINGS, CALC_AWT_INT_FLAG CALC_AWT_INT_FLAG, PAYMENTS_REVIEW_SETTINGS PAYMENTS_REVIEW_SETTINGS, CREATE_INSTRS_FLAG CREATE_INSTRS_FLAG, DOCUMENT_REJECTION_LEVEL_CODE DOCUMENT_REJECTION_LEVEL_CODE, PAYMENT_REJECTION_LEVEL_CODE PAYMENT_REJECTION_LEVEL_CODE, RESUBMIT_FLAG RESUBMIT_FLAG, 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, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN from "AP"."AP_PAYMENT_TEMPLATES"

View Text - HTML Formatted

SELECT PAYMENT_DOCUMENT_ID PAYMENT_DOCUMENT_ID
, TEMPLATE_ID TEMPLATE_ID
, TEMPLATE_NAME TEMPLATE_NAME
, TEMPLATE_TYPE TEMPLATE_TYPE
, DESCRIPTION DESCRIPTION
, INACTIVE_DATE INACTIVE_DATE
, ADDL_PAY_FROM_DAYS ADDL_PAY_FROM_DAYS
, ADDL_PAY_THRU_DAYS ADDL_PAY_THRU_DAYS
, HI_PAYMENT_PRIORITY HI_PAYMENT_PRIORITY
, LOW_PAYMENT_PRIORITY LOW_PAYMENT_PRIORITY
, PAY_ONLY_WHEN_DUE_FLAG PAY_ONLY_WHEN_DUE_FLAG
, ZERO_INV_ALLOWED_FLAG ZERO_INV_ALLOWED_FLAG
, VENDOR_TYPE_LOOKUP_CODE VENDOR_TYPE_LOOKUP_CODE
, VENDOR_ID VENDOR_ID
, PARTY_ID PARTY_ID
, PAYMENT_METHOD_CODE PAYMENT_METHOD_CODE
, INV_EXCHANGE_RATE_TYPE INV_EXCHANGE_RATE_TYPE
, 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_DATE_OPTION PAYMENT_DATE_OPTION
, ADDL_PAYMENT_DAYS ADDL_PAYMENT_DAYS
, BANK_ACCOUNT_ID BANK_ACCOUNT_ID
, BANK_CHARGE_BEARER BANK_CHARGE_BEARER
, SETTLEMENT_PRIORITY SETTLEMENT_PRIORITY
, FIRST_VOUCHER_NUMBER FIRST_VOUCHER_NUMBER
, TRANSFER_PRIORITY TRANSFER_PRIORITY
, PAYMENT_EXCHANGE_RATE_TYPE PAYMENT_EXCHANGE_RATE_TYPE
, PAYMENT_PROFILE_ID PAYMENT_PROFILE_ID
, ZERO_AMOUNTS_ALLOWED ZERO_AMOUNTS_ALLOWED
, PAYABLES_REVIEW_SETTINGS PAYABLES_REVIEW_SETTINGS
, CALC_AWT_INT_FLAG CALC_AWT_INT_FLAG
, PAYMENTS_REVIEW_SETTINGS PAYMENTS_REVIEW_SETTINGS
, CREATE_INSTRS_FLAG CREATE_INSTRS_FLAG
, DOCUMENT_REJECTION_LEVEL_CODE DOCUMENT_REJECTION_LEVEL_CODE
, PAYMENT_REJECTION_LEVEL_CODE PAYMENT_REJECTION_LEVEL_CODE
, RESUBMIT_FLAG RESUBMIT_FLAG
, 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
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM "AP"."AP_PAYMENT_TEMPLATES"