VIEW: CE.CE_PAYMENT_TEMPLATES#

Source

View Text - Preformatted

select PAYTEMPLATE_REFERENCE_NUMBER PAYTEMPLATE_REFERENCE_NUMBER, PAYMENT_TEMPLATE_CODE PAYMENT_TEMPLATE_CODE, SETTLE_BY_SYSTEM_FLAG SETTLE_BY_SYSTEM_FLAG, AUTHORIZE_FLAG AUTHORIZE_FLAG, TRANSACTION_TYPE TRANSACTION_TYPE, PAYTEMPLATE_SUBTYPE_CODE_ID PAYTEMPLATE_SUBTYPE_CODE_ID, ANTICIPATED_VALUE_DAYS ANTICIPATED_VALUE_DAYS, TRANSACTION_DESCRIPTION TRANSACTION_DESCRIPTION, TRANSACTION_COMMENTS TRANSACTION_COMMENTS, PAYMENT_CURRENCY_CODE PAYMENT_CURRENCY_CODE, PAYMENT_AMOUNT PAYMENT_AMOUNT, SOURCE_BANK_ACCOUNT_ID SOURCE_BANK_ACCOUNT_ID, SOURCE_LEGAL_ENTITY_ID SOURCE_LEGAL_ENTITY_ID, SOURCE_BANK_BRANCH_ID SOURCE_BANK_BRANCH_ID, SOURCE_BANK_ID SOURCE_BANK_ID, DESTINATION_LEGAL_ENTITY_ID DESTINATION_LEGAL_ENTITY_ID, DESTINATION_BANK_ACCOUNT_ID DESTINATION_BANK_ACCOUNT_ID, DESTINATION_BANK_BRANCH_ID DESTINATION_BANK_BRANCH_ID, DESTINATION_BANK_ID DESTINATION_BANK_ID, DESTINATION_PARTY_SITE_USE_ID DESTINATION_PARTY_SITE_USE_ID, PAYMENT_METHOD_CODE PAYMENT_METHOD_CODE, BANK_CHARGE_BEARER BANK_CHARGE_BEARER, PAYMENT_REASON_CODE PAYMENT_REASON_CODE, PAYMENT_REASON_COMMENTS PAYMENT_REASON_COMMENTS, REPETITIVE_CODE REPETITIVE_CODE, TEMPLATE_STATUS TEMPLATE_STATUS, END_DATE END_DATE, 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, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER from "CE"."CE_PAYMENT_TEMPLATES"

View Text - HTML Formatted

SELECT PAYTEMPLATE_REFERENCE_NUMBER PAYTEMPLATE_REFERENCE_NUMBER
, PAYMENT_TEMPLATE_CODE PAYMENT_TEMPLATE_CODE
, SETTLE_BY_SYSTEM_FLAG SETTLE_BY_SYSTEM_FLAG
, AUTHORIZE_FLAG AUTHORIZE_FLAG
, TRANSACTION_TYPE TRANSACTION_TYPE
, PAYTEMPLATE_SUBTYPE_CODE_ID PAYTEMPLATE_SUBTYPE_CODE_ID
, ANTICIPATED_VALUE_DAYS ANTICIPATED_VALUE_DAYS
, TRANSACTION_DESCRIPTION TRANSACTION_DESCRIPTION
, TRANSACTION_COMMENTS TRANSACTION_COMMENTS
, PAYMENT_CURRENCY_CODE PAYMENT_CURRENCY_CODE
, PAYMENT_AMOUNT PAYMENT_AMOUNT
, SOURCE_BANK_ACCOUNT_ID SOURCE_BANK_ACCOUNT_ID
, SOURCE_LEGAL_ENTITY_ID SOURCE_LEGAL_ENTITY_ID
, SOURCE_BANK_BRANCH_ID SOURCE_BANK_BRANCH_ID
, SOURCE_BANK_ID SOURCE_BANK_ID
, DESTINATION_LEGAL_ENTITY_ID DESTINATION_LEGAL_ENTITY_ID
, DESTINATION_BANK_ACCOUNT_ID DESTINATION_BANK_ACCOUNT_ID
, DESTINATION_BANK_BRANCH_ID DESTINATION_BANK_BRANCH_ID
, DESTINATION_BANK_ID DESTINATION_BANK_ID
, DESTINATION_PARTY_SITE_USE_ID DESTINATION_PARTY_SITE_USE_ID
, PAYMENT_METHOD_CODE PAYMENT_METHOD_CODE
, BANK_CHARGE_BEARER BANK_CHARGE_BEARER
, PAYMENT_REASON_CODE PAYMENT_REASON_CODE
, PAYMENT_REASON_COMMENTS PAYMENT_REASON_COMMENTS
, REPETITIVE_CODE REPETITIVE_CODE
, TEMPLATE_STATUS TEMPLATE_STATUS
, END_DATE END_DATE
, 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
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
FROM "CE"."CE_PAYMENT_TEMPLATES"