[Home] [Help] [Dependency Information]
Object Name: | CN_SRP_PERIOD_QUOTAS_ALL# |
---|---|
Object Type: | VIEW |
Owner: | CN |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ORG_ID | NUMBER | (15) | ||
SRP_PERIOD_QUOTA_ID | NUMBER | (15) | Yes | |
SRP_PLAN_ASSIGN_ID | NUMBER | (15) | Yes | |
SRP_QUOTA_ASSIGN_ID | NUMBER | (15) | Yes | |
SALESREP_ID | NUMBER | (15) | Yes | |
PERIOD_ID | NUMBER | (15) | Yes | |
QUOTA_ID | NUMBER | (15) | Yes | |
TARGET_AMOUNT | NUMBER | Yes | ||
QUOTA_ACHIEVED_PTD | NUMBER | |||
COMMISSION_PAYED_PTD | NUMBER | Yes | ||
COMMISSION_PAYED_YTD | NUMBER | |||
QUOTA_ACHIEVED_YTD | NUMBER | |||
ITD_TARGET | NUMBER | |||
PERIOD_PAYMENT | NUMBER | |||
ITD_PAYMENT | NUMBER | |||
TRX_AMOUNT_PTD | NUMBER | |||
TRX_AMOUNT_YTD | NUMBER | |||
QUANTITY_PTD | NUMBER | |||
QUANTITY_YTD | NUMBER | |||
COMMISSION_PAYED_ITD | NUMBER | |||
CREATED_BY | NUMBER | (15) | ||
CREATION_DATE | DATE | |||
LAST_UPDATED_BY | NUMBER | (15) | ||
LAST_UPDATE_DATE | DATE | |||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
QUOTA_ACHIEVED_PTD_F | NUMBER | |||
QUOTA_AMOUNT_PTD_F | NUMBER | |||
QUOTA_AMOUNT_YTD_F | NUMBER | |||
QUOTA_ACHIEVED_YTD_F | NUMBER | |||
COMMISSION_PAYED_ITD_F | NUMBER | |||
COMMISSION_PAYED_PTD_F | NUMBER | |||
COMMISSION_PAYED_YTD_F | NUMBER | |||
TRX_AMOUNT_PTD_F | NUMBER | |||
TRX_AMOUNT_YTD_F | NUMBER | |||
QUANTITY_PTD_F | NUMBER | |||
QUANTITY_YTD_F | NUMBER | |||
INPUT_ACHIEVED_PTD | NUMBER | |||
INPUT_ACHIEVED_ITD | NUMBER | |||
OUTPUT_ACHIEVED_PTD | NUMBER | |||
OUTPUT_ACHIEVED_ITD | NUMBER | |||
PERF_ACHIEVED_PTD | NUMBER | |||
PERF_ACHIEVED_ITD | NUMBER | |||
ADVANCE_RECOVERED_PTD | NUMBER | |||
ADVANCE_RECOVERED_ITD | NUMBER | |||
ADVANCE_TO_REC_PTD | NUMBER | |||
ADVANCE_TO_REC_ITD | NUMBER | |||
COMM_PEND_PTD | NUMBER | |||
COMM_PEND_ITD | NUMBER | |||
RECOVERY_AMOUNT_PTD | NUMBER | |||
RECOVERY_AMOUNT_ITD | NUMBER | |||
PERFORMANCE_GOAL_PTD | NUMBER | |||
PERFORMANCE_GOAL_ITD | NUMBER | |||
LAST_RATE_TIER_ID | NUMBER | (15) | ||
LAST_RATES | NUMBER | |||
INPUT_ACHIEVED_PTD_F | NUMBER | |||
INPUT_ACHIEVED_ITD_F | NUMBER | |||
OUTPUT_ACHIEVED_PTD_F | NUMBER | |||
OUTPUT_ACHIEVED_ITD_F | NUMBER | |||
PERF_ACHIEVED_PTD_F | NUMBER | |||
PERF_ACHIEVED_ITD_F | NUMBER | |||
SECURITY_GROUP_ID | NUMBER | |||
ROLLOVER | NUMBER | |||
TOTAL_ROLLOVER | NUMBER | |||
OBJECT_VERSION_NUMBER | NUMBER | (15) | Yes | |
TRANSACTION_AMOUNT_PTD | NUMBER | |||
TRANSACTION_AMOUNT_ITD | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT ORG_ID
, SRP_PERIOD_QUOTA_ID
, SRP_PLAN_ASSIGN_ID
, SRP_QUOTA_ASSIGN_ID
, SALESREP_ID
, PERIOD_ID
, QUOTA_ID
, TARGET_AMOUNT
, QUOTA_ACHIEVED_PTD
, COMMISSION_PAYED_PTD
, COMMISSION_PAYED_YTD
, QUOTA_ACHIEVED_YTD
, ITD_TARGET
, PERIOD_PAYMENT
, ITD_PAYMENT
, TRX_AMOUNT_PTD
, TRX_AMOUNT_YTD
, QUANTITY_PTD
, QUANTITY_YTD
, COMMISSION_PAYED_ITD
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, QUOTA_ACHIEVED_PTD_F
, QUOTA_AMOUNT_PTD_F
, QUOTA_AMOUNT_YTD_F
, QUOTA_ACHIEVED_YTD_F
, COMMISSION_PAYED_ITD_F
, COMMISSION_PAYED_PTD_F
, COMMISSION_PAYED_YTD_F
, TRX_AMOUNT_PTD_F
, TRX_AMOUNT_YTD_F
, QUANTITY_PTD_F
, QUANTITY_YTD_F
, INPUT_ACHIEVED_PTD
, INPUT_ACHIEVED_ITD
, OUTPUT_ACHIEVED_PTD
, OUTPUT_ACHIEVED_ITD
, PERF_ACHIEVED_PTD
, PERF_ACHIEVED_ITD
, ADVANCE_RECOVERED_PTD
, ADVANCE_RECOVERED_ITD
, ADVANCE_TO_REC_PTD
, ADVANCE_TO_REC_ITD
, COMM_PEND_PTD
, COMM_PEND_ITD
, RECOVERY_AMOUNT_PTD
, RECOVERY_AMOUNT_ITD
, PERFORMANCE_GOAL_PTD
, PERFORMANCE_GOAL_ITD
, LAST_RATE_TIER_ID
, LAST_RATES
, INPUT_ACHIEVED_PTD_F
, INPUT_ACHIEVED_ITD_F
, OUTPUT_ACHIEVED_PTD_F
, OUTPUT_ACHIEVED_ITD_F
, PERF_ACHIEVED_PTD_F
, PERF_ACHIEVED_ITD_F
, SECURITY_GROUP_ID
, ROLLOVER
, TOTAL_ROLLOVER
, OBJECT_VERSION_NUMBER
, TRANSACTION_AMOUNT_PTD
, TRANSACTION_AMOUNT_ITD
FROM CN.CN_SRP_PERIOD_QUOTAS_ALL#;
|
|
|