VIEW: CN.CN_COMMISSION_LINES_ALL#

Source

View Text - Preformatted

select COMMISSION_LINE_ID COMMISSION_LINE_ID, TRX_SALES_LINE_ID TRX_SALES_LINE_ID, DIRECT_SALESREP_ID DIRECT_SALESREP_ID, CREDITED_SALESREP_ID CREDITED_SALESREP_ID, PROCESSED_PERIOD_ID PROCESSED_PERIOD_ID, PROCESSED_DATE PROCESSED_DATE, QUOTA_ID QUOTA_ID, QUOTA_RULE_ID QUOTA_RULE_ID, REVENUE_CLASS_ID REVENUE_CLASS_ID, TRANSACTION_AMOUNT TRANSACTION_AMOUNT, EVENT_FACTOR EVENT_FACTOR, PAYMENT_FACTOR PAYMENT_FACTOR, PAYMENT_FLAG PAYMENT_FLAG, QUOTA_FACTOR QUOTA_FACTOR, COMMISSIONABLE_AMOUNT COMMISSIONABLE_AMOUNT, COMMISSION_AMOUNT COMMISSION_AMOUNT, COMMISSION_PAYED_PTD COMMISSION_PAYED_PTD, QUOTA_ACHIEVED_PTD QUOTA_ACHIEVED_PTD, RATE_TIER_ID RATE_TIER_ID, SALES_LINE_BATCH_ID SALES_LINE_BATCH_ID, QUOTA_AMOUNT QUOTA_AMOUNT, COMMISSION_RATE COMMISSION_RATE, PAYEE_LINE_ID PAYEE_LINE_ID, STATUS STATUS, TRX_TYPE TRX_TYPE, TIER_SPLIT TIER_SPLIT, EXCEPTION_CODE EXCEPTION_CODE, TRIAL_ADJUSTMENT_FLAG TRIAL_ADJUSTMENT_FLAG, REVERSED_ADJUSTMENT_FLAG REVERSED_ADJUSTMENT_FLAG, TRX_BATCH_ID TRX_BATCH_ID, ROLLUP_PERIOD_ID ROLLUP_PERIOD_ID, REASON_CODE REASON_CODE, COMMENTS COMMENTS, CREATED_DURING CREATED_DURING, PRE_DEFINED_RC_FLAG PRE_DEFINED_RC_FLAG, ROLLUP_FLAG ROLLUP_FLAG, ROLLUP_DATE ROLLUP_DATE, FORECAST_ID FORECAST_ID, UPSIDE_AMOUNT UPSIDE_AMOUNT, UPSIDE_QUANTITY UPSIDE_QUANTITY, UOM_CODE UOM_CODE, 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, ATTRIBUTE16 ATTRIBUTE16, ATTRIBUTE17 ATTRIBUTE17, ATTRIBUTE18 ATTRIBUTE18, ATTRIBUTE19 ATTRIBUTE19, ATTRIBUTE20 ATTRIBUTE20, ATTRIBUTE21 ATTRIBUTE21, ATTRIBUTE22 ATTRIBUTE22, ATTRIBUTE23 ATTRIBUTE23, ATTRIBUTE24 ATTRIBUTE24, ATTRIBUTE25 ATTRIBUTE25, ATTRIBUTE26 ATTRIBUTE26, ATTRIBUTE27 ATTRIBUTE27, ATTRIBUTE28 ATTRIBUTE28, ATTRIBUTE29 ATTRIBUTE29, ATTRIBUTE30 ATTRIBUTE30, ATTRIBUTE31 ATTRIBUTE31, ATTRIBUTE32 ATTRIBUTE32, ATTRIBUTE33 ATTRIBUTE33, ATTRIBUTE34 ATTRIBUTE34, ATTRIBUTE35 ATTRIBUTE35, ATTRIBUTE36 ATTRIBUTE36, ATTRIBUTE37 ATTRIBUTE37, ATTRIBUTE38 ATTRIBUTE38, ATTRIBUTE39 ATTRIBUTE39, ATTRIBUTE40 ATTRIBUTE40, ATTRIBUTE41 ATTRIBUTE41, ATTRIBUTE42 ATTRIBUTE42, ATTRIBUTE43 ATTRIBUTE43, ATTRIBUTE44 ATTRIBUTE44, ATTRIBUTE45 ATTRIBUTE45, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, LAST_UPDATE_DATE LAST_UPDATE_DATE, REQUEST_ID REQUEST_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, ORIG_CURRENCY_CODE ORIG_CURRENCY_CODE, TRANSACTION_AMOUNT_ORIG TRANSACTION_AMOUNT_ORIG, EXCHANGE_RATE EXCHANGE_RATE, ORG_ID ORG_ID, QUANTITY QUANTITY, DISCOUNT_PERCENTAGE DISCOUNT_PERCENTAGE, MARGIN_PERCENTAGE MARGIN_PERCENTAGE, COMM_LINES_API_ID COMM_LINES_API_ID, SOURCE_DOC_TYPE SOURCE_DOC_TYPE, SOURCE_TRX_NUMBER SOURCE_TRX_NUMBER, ERROR_CODE ERROR_CODE, COMMISSION_HEADER_ID COMMISSION_HEADER_ID, SRP_PLAN_ASSIGN_ID SRP_PLAN_ASSIGN_ID, POSTING_STATUS POSTING_STATUS, INPUT_ACHIEVED INPUT_ACHIEVED, OUTPUT_ACHIEVED OUTPUT_ACHIEVED, PERF_ACHIEVED PERF_ACHIEVED, REVERSAL_HEADER_ID REVERSAL_HEADER_ID, ERROR_REASON ERROR_REASON, PAY_PERIOD_ID PAY_PERIOD_ID, PENDING_STATUS PENDING_STATUS, ROLE_ID ROLE_ID, SRP_PAYEE_ASSIGN_ID SRP_PAYEE_ASSIGN_ID, PENDING_DATE PENDING_DATE, THRESHOLD_CHECK_STATUS THRESHOLD_CHECK_STATUS, CREDITED_COMP_GROUP_ID CREDITED_COMP_GROUP_ID, PRE_PROCESSED_CODE PRE_PROCESSED_CODE, SECURITY_GROUP_ID SECURITY_GROUP_ID, CREDIT_TYPE_ID CREDIT_TYPE_ID, ROLLUP_LEVEL ROLLUP_LEVEL from "CN"."CN_COMMISSION_LINES_ALL"

View Text - HTML Formatted

SELECT COMMISSION_LINE_ID COMMISSION_LINE_ID
, TRX_SALES_LINE_ID TRX_SALES_LINE_ID
, DIRECT_SALESREP_ID DIRECT_SALESREP_ID
, CREDITED_SALESREP_ID CREDITED_SALESREP_ID
, PROCESSED_PERIOD_ID PROCESSED_PERIOD_ID
, PROCESSED_DATE PROCESSED_DATE
, QUOTA_ID QUOTA_ID
, QUOTA_RULE_ID QUOTA_RULE_ID
, REVENUE_CLASS_ID REVENUE_CLASS_ID
, TRANSACTION_AMOUNT TRANSACTION_AMOUNT
, EVENT_FACTOR EVENT_FACTOR
, PAYMENT_FACTOR PAYMENT_FACTOR
, PAYMENT_FLAG PAYMENT_FLAG
, QUOTA_FACTOR QUOTA_FACTOR
, COMMISSIONABLE_AMOUNT COMMISSIONABLE_AMOUNT
, COMMISSION_AMOUNT COMMISSION_AMOUNT
, COMMISSION_PAYED_PTD COMMISSION_PAYED_PTD
, QUOTA_ACHIEVED_PTD QUOTA_ACHIEVED_PTD
, RATE_TIER_ID RATE_TIER_ID
, SALES_LINE_BATCH_ID SALES_LINE_BATCH_ID
, QUOTA_AMOUNT QUOTA_AMOUNT
, COMMISSION_RATE COMMISSION_RATE
, PAYEE_LINE_ID PAYEE_LINE_ID
, STATUS STATUS
, TRX_TYPE TRX_TYPE
, TIER_SPLIT TIER_SPLIT
, EXCEPTION_CODE EXCEPTION_CODE
, TRIAL_ADJUSTMENT_FLAG TRIAL_ADJUSTMENT_FLAG
, REVERSED_ADJUSTMENT_FLAG REVERSED_ADJUSTMENT_FLAG
, TRX_BATCH_ID TRX_BATCH_ID
, ROLLUP_PERIOD_ID ROLLUP_PERIOD_ID
, REASON_CODE REASON_CODE
, COMMENTS COMMENTS
, CREATED_DURING CREATED_DURING
, PRE_DEFINED_RC_FLAG PRE_DEFINED_RC_FLAG
, ROLLUP_FLAG ROLLUP_FLAG
, ROLLUP_DATE ROLLUP_DATE
, FORECAST_ID FORECAST_ID
, UPSIDE_AMOUNT UPSIDE_AMOUNT
, UPSIDE_QUANTITY UPSIDE_QUANTITY
, UOM_CODE UOM_CODE
, 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
, ATTRIBUTE16 ATTRIBUTE16
, ATTRIBUTE17 ATTRIBUTE17
, ATTRIBUTE18 ATTRIBUTE18
, ATTRIBUTE19 ATTRIBUTE19
, ATTRIBUTE20 ATTRIBUTE20
, ATTRIBUTE21 ATTRIBUTE21
, ATTRIBUTE22 ATTRIBUTE22
, ATTRIBUTE23 ATTRIBUTE23
, ATTRIBUTE24 ATTRIBUTE24
, ATTRIBUTE25 ATTRIBUTE25
, ATTRIBUTE26 ATTRIBUTE26
, ATTRIBUTE27 ATTRIBUTE27
, ATTRIBUTE28 ATTRIBUTE28
, ATTRIBUTE29 ATTRIBUTE29
, ATTRIBUTE30 ATTRIBUTE30
, ATTRIBUTE31 ATTRIBUTE31
, ATTRIBUTE32 ATTRIBUTE32
, ATTRIBUTE33 ATTRIBUTE33
, ATTRIBUTE34 ATTRIBUTE34
, ATTRIBUTE35 ATTRIBUTE35
, ATTRIBUTE36 ATTRIBUTE36
, ATTRIBUTE37 ATTRIBUTE37
, ATTRIBUTE38 ATTRIBUTE38
, ATTRIBUTE39 ATTRIBUTE39
, ATTRIBUTE40 ATTRIBUTE40
, ATTRIBUTE41 ATTRIBUTE41
, ATTRIBUTE42 ATTRIBUTE42
, ATTRIBUTE43 ATTRIBUTE43
, ATTRIBUTE44 ATTRIBUTE44
, ATTRIBUTE45 ATTRIBUTE45
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, REQUEST_ID REQUEST_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, ORIG_CURRENCY_CODE ORIG_CURRENCY_CODE
, TRANSACTION_AMOUNT_ORIG TRANSACTION_AMOUNT_ORIG
, EXCHANGE_RATE EXCHANGE_RATE
, ORG_ID ORG_ID
, QUANTITY QUANTITY
, DISCOUNT_PERCENTAGE DISCOUNT_PERCENTAGE
, MARGIN_PERCENTAGE MARGIN_PERCENTAGE
, COMM_LINES_API_ID COMM_LINES_API_ID
, SOURCE_DOC_TYPE SOURCE_DOC_TYPE
, SOURCE_TRX_NUMBER SOURCE_TRX_NUMBER
, ERROR_CODE ERROR_CODE
, COMMISSION_HEADER_ID COMMISSION_HEADER_ID
, SRP_PLAN_ASSIGN_ID SRP_PLAN_ASSIGN_ID
, POSTING_STATUS POSTING_STATUS
, INPUT_ACHIEVED INPUT_ACHIEVED
, OUTPUT_ACHIEVED OUTPUT_ACHIEVED
, PERF_ACHIEVED PERF_ACHIEVED
, REVERSAL_HEADER_ID REVERSAL_HEADER_ID
, ERROR_REASON ERROR_REASON
, PAY_PERIOD_ID PAY_PERIOD_ID
, PENDING_STATUS PENDING_STATUS
, ROLE_ID ROLE_ID
, SRP_PAYEE_ASSIGN_ID SRP_PAYEE_ASSIGN_ID
, PENDING_DATE PENDING_DATE
, THRESHOLD_CHECK_STATUS THRESHOLD_CHECK_STATUS
, CREDITED_COMP_GROUP_ID CREDITED_COMP_GROUP_ID
, PRE_PROCESSED_CODE PRE_PROCESSED_CODE
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, CREDIT_TYPE_ID CREDIT_TYPE_ID
, ROLLUP_LEVEL ROLLUP_LEVEL
FROM "CN"."CN_COMMISSION_LINES_ALL"