VIEW: CN.CN_PAYMENT_WORKSHEETS_ALL#

Source

View Text - Preformatted

select ORG_ID ORG_ID, SALESREP_ID SALESREP_ID, PAYRUN_ID PAYRUN_ID, PAY_CAP PAY_CAP, COMM_DUE_BB COMM_DUE_BB, BONUS_DUE_BB BONUS_DUE_BB, DRAW_RECOVERABLE_BEGIN DRAW_RECOVERABLE_BEGIN, COMM_PTD COMM_PTD, BONUS_PTD BONUS_PTD, COMM_DRAW COMM_DRAW, BONUS_DRAW BONUS_DRAW, COMM_PAID COMM_PAID, BONUS_PAID BONUS_PAID, DRAW_PAID DRAW_PAID, ADJUST_PAID ADJUST_PAID, COST_CENTER_ID COST_CENTER_ID, REASON REASON, BONUS_REASON BONUS_REASON, RECOVERY_METHOD RECOVERY_METHOD, DRAW_PTD DRAW_PTD, BONUS_GIVEN BONUS_GIVEN, GUARANTEE GUARANTEE, PAYMENT_WORKSHEET_ID PAYMENT_WORKSHEET_ID, ROLE_ID ROLE_ID, CREDIT_TYPE_ID CREDIT_TYPE_ID, RETURNED_FUNDS_FLAG RETURNED_FUNDS_FLAG, POST_SUBLEDGER_FLAG POST_SUBLEDGER_FLAG, MINIMUM_AMOUNT MINIMUM_AMOUNT, COMM_NREC COMM_NREC, REG_BONUS_DUE_BB REG_BONUS_DUE_BB, REG_BONUS_PTD REG_BONUS_PTD, REG_BONUS_REC REG_BONUS_REC, REG_BONUS_TO_REC REG_BONUS_TO_REC, REG_BONUS_PAID REG_BONUS_PAID, PAYEE_COMM_DUE_BB PAYEE_COMM_DUE_BB, PAYEE_COMM_PTD PAYEE_COMM_PTD, PAYEE_COMM_PAID PAYEE_COMM_PAID, PAYEE_BONUS_DUE_BB PAYEE_BONUS_DUE_BB, PAYEE_BONUS_PTD PAYEE_BONUS_PTD, PAYEE_BONUS_PAID PAYEE_BONUS_PAID, CONVERT_TO_TYPE_ID CONVERT_TO_TYPE_ID, CREDIT_CONV_FCT_ID CREDIT_CONV_FCT_ID, CONVERT_TO_PAID CONVERT_TO_PAID, POSTING_STATUS POSTING_STATUS, 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, PMT_AMOUNT_CALC PMT_AMOUNT_CALC, PMT_AMOUNT_ADJ_REC PMT_AMOUNT_ADJ_REC, PMT_AMOUNT_ADJ_NREC PMT_AMOUNT_ADJ_NREC, REVIEWED_BY_ANALYST REVIEWED_BY_ANALYST, ANALYST_NOTES ANALYST_NOTES, SECURITY_GROUP_ID SECURITY_GROUP_ID, CURRENT_EARNINGS_DUE CURRENT_EARNINGS_DUE, PMT_AMOUNT_ADJ PMT_AMOUNT_ADJ, PMT_AMOUNT_RECOVERY PMT_AMOUNT_RECOVERY, QUOTA_ID QUOTA_ID, WORKSHEET_STATUS WORKSHEET_STATUS, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, CURRENT_EARNINGS CURRENT_EARNINGS, BB_PMT_RECOVERY_PLANS BB_PMT_RECOVERY_PLANS, BB_PRIOR_PERIOD_ADJ BB_PRIOR_PERIOD_ADJ, HELD_AMOUNT HELD_AMOUNT, REQUEST_ID REQUEST_ID from "CN"."CN_PAYMENT_WORKSHEETS_ALL"

View Text - HTML Formatted

SELECT ORG_ID ORG_ID
, SALESREP_ID SALESREP_ID
, PAYRUN_ID PAYRUN_ID
, PAY_CAP PAY_CAP
, COMM_DUE_BB COMM_DUE_BB
, BONUS_DUE_BB BONUS_DUE_BB
, DRAW_RECOVERABLE_BEGIN DRAW_RECOVERABLE_BEGIN
, COMM_PTD COMM_PTD
, BONUS_PTD BONUS_PTD
, COMM_DRAW COMM_DRAW
, BONUS_DRAW BONUS_DRAW
, COMM_PAID COMM_PAID
, BONUS_PAID BONUS_PAID
, DRAW_PAID DRAW_PAID
, ADJUST_PAID ADJUST_PAID
, COST_CENTER_ID COST_CENTER_ID
, REASON REASON
, BONUS_REASON BONUS_REASON
, RECOVERY_METHOD RECOVERY_METHOD
, DRAW_PTD DRAW_PTD
, BONUS_GIVEN BONUS_GIVEN
, GUARANTEE GUARANTEE
, PAYMENT_WORKSHEET_ID PAYMENT_WORKSHEET_ID
, ROLE_ID ROLE_ID
, CREDIT_TYPE_ID CREDIT_TYPE_ID
, RETURNED_FUNDS_FLAG RETURNED_FUNDS_FLAG
, POST_SUBLEDGER_FLAG POST_SUBLEDGER_FLAG
, MINIMUM_AMOUNT MINIMUM_AMOUNT
, COMM_NREC COMM_NREC
, REG_BONUS_DUE_BB REG_BONUS_DUE_BB
, REG_BONUS_PTD REG_BONUS_PTD
, REG_BONUS_REC REG_BONUS_REC
, REG_BONUS_TO_REC REG_BONUS_TO_REC
, REG_BONUS_PAID REG_BONUS_PAID
, PAYEE_COMM_DUE_BB PAYEE_COMM_DUE_BB
, PAYEE_COMM_PTD PAYEE_COMM_PTD
, PAYEE_COMM_PAID PAYEE_COMM_PAID
, PAYEE_BONUS_DUE_BB PAYEE_BONUS_DUE_BB
, PAYEE_BONUS_PTD PAYEE_BONUS_PTD
, PAYEE_BONUS_PAID PAYEE_BONUS_PAID
, CONVERT_TO_TYPE_ID CONVERT_TO_TYPE_ID
, CREDIT_CONV_FCT_ID CREDIT_CONV_FCT_ID
, CONVERT_TO_PAID CONVERT_TO_PAID
, POSTING_STATUS POSTING_STATUS
, 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
, PMT_AMOUNT_CALC PMT_AMOUNT_CALC
, PMT_AMOUNT_ADJ_REC PMT_AMOUNT_ADJ_REC
, PMT_AMOUNT_ADJ_NREC PMT_AMOUNT_ADJ_NREC
, REVIEWED_BY_ANALYST REVIEWED_BY_ANALYST
, ANALYST_NOTES ANALYST_NOTES
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, CURRENT_EARNINGS_DUE CURRENT_EARNINGS_DUE
, PMT_AMOUNT_ADJ PMT_AMOUNT_ADJ
, PMT_AMOUNT_RECOVERY PMT_AMOUNT_RECOVERY
, QUOTA_ID QUOTA_ID
, WORKSHEET_STATUS WORKSHEET_STATUS
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CURRENT_EARNINGS CURRENT_EARNINGS
, BB_PMT_RECOVERY_PLANS BB_PMT_RECOVERY_PLANS
, BB_PRIOR_PERIOD_ADJ BB_PRIOR_PERIOD_ADJ
, HELD_AMOUNT HELD_AMOUNT
, REQUEST_ID REQUEST_ID
FROM "CN"."CN_PAYMENT_WORKSHEETS_ALL"