VIEW: CN.CN_PAYMENT_TRANSACTIONS_ALL#

Source

View Text - Preformatted

select RECOVERABLE_FLAG RECOVERABLE_FLAG, POSTING_BATCH_ID POSTING_BATCH_ID, POSTING_TYPE POSTING_TYPE, TRX_TYPE TRX_TYPE, PAYEE_SALESREP_ID PAYEE_SALESREP_ID, ROLE_ID ROLE_ID, INCENTIVE_TYPE_CODE INCENTIVE_TYPE_CODE, CREDIT_TYPE_ID CREDIT_TYPE_ID, PAY_PERIOD_ID PAY_PERIOD_ID, AMOUNT AMOUNT, COMMISSION_HEADER_ID COMMISSION_HEADER_ID, COMMISSION_LINE_ID COMMISSION_LINE_ID, SRP_PLAN_ASSIGN_ID SRP_PLAN_ASSIGN_ID, QUOTA_ID QUOTA_ID, PROCESSED_DATE PROCESSED_DATE, CREDITED_SALESREP_ID CREDITED_SALESREP_ID, PROCESSED_PERIOD_ID PROCESSED_PERIOD_ID, QUOTA_RULE_ID QUOTA_RULE_ID, EVENT_FACTOR EVENT_FACTOR, PAYMENT_FACTOR PAYMENT_FACTOR, QUOTA_FACTOR QUOTA_FACTOR, INPUT_ACHIEVED INPUT_ACHIEVED, RATE_TIER_ID RATE_TIER_ID, PAYEE_LINE_ID PAYEE_LINE_ID, COMMISSION_RATE COMMISSION_RATE, 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, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, ORG_ID ORG_ID, HOLD_FLAG HOLD_FLAG, PAID_FLAG PAID_FLAG, PAYMENT_AMOUNT PAYMENT_AMOUNT, PAYRUN_ID PAYRUN_ID, EXPENSE_CCID EXPENSE_CCID, LIABILITY_CCID LIABILITY_CCID, PAY_ELEMENT_TYPE_ID PAY_ELEMENT_TYPE_ID, SECURITY_GROUP_ID SECURITY_GROUP_ID, WAIVE_FLAG WAIVE_FLAG, PAYMENT_TRANSACTION_ID PAYMENT_TRANSACTION_ID, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER from "CN"."CN_PAYMENT_TRANSACTIONS_ALL"

View Text - HTML Formatted

SELECT RECOVERABLE_FLAG RECOVERABLE_FLAG
, POSTING_BATCH_ID POSTING_BATCH_ID
, POSTING_TYPE POSTING_TYPE
, TRX_TYPE TRX_TYPE
, PAYEE_SALESREP_ID PAYEE_SALESREP_ID
, ROLE_ID ROLE_ID
, INCENTIVE_TYPE_CODE INCENTIVE_TYPE_CODE
, CREDIT_TYPE_ID CREDIT_TYPE_ID
, PAY_PERIOD_ID PAY_PERIOD_ID
, AMOUNT AMOUNT
, COMMISSION_HEADER_ID COMMISSION_HEADER_ID
, COMMISSION_LINE_ID COMMISSION_LINE_ID
, SRP_PLAN_ASSIGN_ID SRP_PLAN_ASSIGN_ID
, QUOTA_ID QUOTA_ID
, PROCESSED_DATE PROCESSED_DATE
, CREDITED_SALESREP_ID CREDITED_SALESREP_ID
, PROCESSED_PERIOD_ID PROCESSED_PERIOD_ID
, QUOTA_RULE_ID QUOTA_RULE_ID
, EVENT_FACTOR EVENT_FACTOR
, PAYMENT_FACTOR PAYMENT_FACTOR
, QUOTA_FACTOR QUOTA_FACTOR
, INPUT_ACHIEVED INPUT_ACHIEVED
, RATE_TIER_ID RATE_TIER_ID
, PAYEE_LINE_ID PAYEE_LINE_ID
, COMMISSION_RATE COMMISSION_RATE
, 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
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, ORG_ID ORG_ID
, HOLD_FLAG HOLD_FLAG
, PAID_FLAG PAID_FLAG
, PAYMENT_AMOUNT PAYMENT_AMOUNT
, PAYRUN_ID PAYRUN_ID
, EXPENSE_CCID EXPENSE_CCID
, LIABILITY_CCID LIABILITY_CCID
, PAY_ELEMENT_TYPE_ID PAY_ELEMENT_TYPE_ID
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, WAIVE_FLAG WAIVE_FLAG
, PAYMENT_TRANSACTION_ID PAYMENT_TRANSACTION_ID
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
FROM "CN"."CN_PAYMENT_TRANSACTIONS_ALL"