VIEW: CS.CS_CONTRACT_TEMPLATES#

Source

View Text - Preformatted

select CONTRACT_TEMPLATE_ID CONTRACT_TEMPLATE_ID, NAME NAME, CONTRACT_TYPE_ID CONTRACT_TYPE_ID, DURATION DURATION, PERIOD_CODE PERIOD_CODE, WORKFLOW WORKFLOW, PRICE_LIST_ID PRICE_LIST_ID, CURRENCY_CODE CURRENCY_CODE, CONVERSION_TYPE_CODE CONVERSION_TYPE_CODE, CONVERSION_RATE CONVERSION_RATE, CONVERSION_DATE CONVERSION_DATE, INVOICING_RULE_ID INVOICING_RULE_ID, ACCOUNTING_RULE_ID ACCOUNTING_RULE_ID, BILLING_FREQUENCY_PERIOD BILLING_FREQUENCY_PERIOD, CREATE_SALES_ORDER CREATE_SALES_ORDER, RENEWAL_RULE RENEWAL_RULE, TERMINATION_RULE TERMINATION_RULE, TERMS_ID TERMS_ID, TAX_HANDLING TAX_HANDLING, TAX_EXEMPT_NUM TAX_EXEMPT_NUM, TAX_EXEMPT_REASON_CODE TAX_EXEMPT_REASON_CODE, CONTRACT_AMOUNT CONTRACT_AMOUNT, DISCOUNT_ID DISCOUNT_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, AUTO_RENEWAL_FLAG AUTO_RENEWAL_FLAG, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, START_DATE_ACTIVE START_DATE_ACTIVE, END_DATE_ACTIVE END_DATE_ACTIVE, 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, CONTEXT CONTEXT, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER from "CS"."CS_CONTRACT_TEMPLATES"

View Text - HTML Formatted

SELECT CONTRACT_TEMPLATE_ID CONTRACT_TEMPLATE_ID
, NAME NAME
, CONTRACT_TYPE_ID CONTRACT_TYPE_ID
, DURATION DURATION
, PERIOD_CODE PERIOD_CODE
, WORKFLOW WORKFLOW
, PRICE_LIST_ID PRICE_LIST_ID
, CURRENCY_CODE CURRENCY_CODE
, CONVERSION_TYPE_CODE CONVERSION_TYPE_CODE
, CONVERSION_RATE CONVERSION_RATE
, CONVERSION_DATE CONVERSION_DATE
, INVOICING_RULE_ID INVOICING_RULE_ID
, ACCOUNTING_RULE_ID ACCOUNTING_RULE_ID
, BILLING_FREQUENCY_PERIOD BILLING_FREQUENCY_PERIOD
, CREATE_SALES_ORDER CREATE_SALES_ORDER
, RENEWAL_RULE RENEWAL_RULE
, TERMINATION_RULE TERMINATION_RULE
, TERMS_ID TERMS_ID
, TAX_HANDLING TAX_HANDLING
, TAX_EXEMPT_NUM TAX_EXEMPT_NUM
, TAX_EXEMPT_REASON_CODE TAX_EXEMPT_REASON_CODE
, CONTRACT_AMOUNT CONTRACT_AMOUNT
, DISCOUNT_ID DISCOUNT_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, AUTO_RENEWAL_FLAG AUTO_RENEWAL_FLAG
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, START_DATE_ACTIVE START_DATE_ACTIVE
, END_DATE_ACTIVE END_DATE_ACTIVE
, 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
, CONTEXT CONTEXT
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
FROM "CS"."CS_CONTRACT_TEMPLATES"