VIEW: CN.CN_SRP_PERIODS_ALL#

Source

View Text - Preformatted

select ORG_ID ORG_ID, SRP_PERIOD_ID SRP_PERIOD_ID, SALESREP_ID SALESREP_ID, PERIOD_ID PERIOD_ID, SRP_PLAN_ASSIGN_ID SRP_PLAN_ASSIGN_ID, STATUS STATUS, CALC_BATCH_ID CALC_BATCH_ID, PERIOD_TYPE_ID PERIOD_TYPE_ID, CASH_DTD CASH_DTD, CASH_CTD CASH_CTD, CASH_BBD CASH_BBD, CASH_BBC CASH_BBC, DUE_DTD DUE_DTD, DUE_CTD DUE_CTD, DUE_BBD DUE_BBD, DUE_BBC DUE_BBC, COMMISSION_EARNED_DTD COMMISSION_EARNED_DTD, COMMISSION_EARNED_CTD COMMISSION_EARNED_CTD, COMMISSION_EARNED_BBD COMMISSION_EARNED_BBD, COMMISSION_EARNED_BBC COMMISSION_EARNED_BBC, BONUS_EARNED_DTD BONUS_EARNED_DTD, BONUS_EARNED_CTD BONUS_EARNED_CTD, BONUS_EARNED_BBD BONUS_EARNED_BBD, BONUS_EARNED_BBC BONUS_EARNED_BBC, DRAW_NONREC_DTD DRAW_NONREC_DTD, DRAW_NONREC_CTD DRAW_NONREC_CTD, DRAW_NONREC_BBD DRAW_NONREC_BBD, DRAW_NONREC_BBC DRAW_NONREC_BBC, PAYROLL_DUE_DTD PAYROLL_DUE_DTD, PAYROLL_DUE_CTD PAYROLL_DUE_CTD, PAYROLL_DUE_BBD PAYROLL_DUE_BBD, PAYROLL_DUE_BBC PAYROLL_DUE_BBC, PAYROLL_TRANSFER_DTD PAYROLL_TRANSFER_DTD, PAYROLL_TRANSFER_CTD PAYROLL_TRANSFER_CTD, PAYROLL_TRANSFER_BBD PAYROLL_TRANSFER_BBD, PAYROLL_TRANSFER_BBC PAYROLL_TRANSFER_BBC, DRAW_PAYABLE_DTD DRAW_PAYABLE_DTD, DRAW_PAYABLE_CTD DRAW_PAYABLE_CTD, DRAW_PAYABLE_BBD DRAW_PAYABLE_BBD, DRAW_PAYABLE_BBC DRAW_PAYABLE_BBC, MISC_EARNED_DTD MISC_EARNED_DTD, MISC_EARNED_CTD MISC_EARNED_CTD, MISC_EARNED_BBD MISC_EARNED_BBD, MISC_EARNED_BBC MISC_EARNED_BBC, TRANSFERRED TRANSFERRED, CLASSIFIED CLASSIFIED, UNCLASSIFIED UNCLASSIFIED, DIRECT_PAYED DIRECT_PAYED, DIRECT_UNPAYED DIRECT_UNPAYED, INDIRECT_PAYED INDIRECT_PAYED, CALCULATED CALCULATED, UNCALCULATED UNCALCULATED, SUB_CALCULATED SUB_CALCULATED, SUB_UNCALCULATED SUB_UNCALCULATED, BALANCE10_DTD BALANCE10_DTD, BALANCE10_CTD BALANCE10_CTD, BALANCE10_BBD BALANCE10_BBD, BALANCE10_BBC BALANCE10_BBC, BALANCE11_DTD BALANCE11_DTD, BALANCE11_CTD BALANCE11_CTD, BALANCE11_BBD BALANCE11_BBD, BALANCE11_BBC BALANCE11_BBC, BALANCE12_DTD BALANCE12_DTD, BALANCE12_CTD BALANCE12_CTD, BALANCE12_BBD BALANCE12_BBD, BALANCE12_BBC BALANCE12_BBC, BALANCE13_DTD BALANCE13_DTD, BALANCE13_CTD BALANCE13_CTD, BALANCE13_BBD BALANCE13_BBD, BALANCE13_BBC BALANCE13_BBC, BALANCE14_DTD BALANCE14_DTD, BALANCE14_CTD BALANCE14_CTD, BALANCE14_BBD BALANCE14_BBD, BALANCE14_BBC BALANCE14_BBC, BALANCE15_DTD BALANCE15_DTD, BALANCE15_CTD BALANCE15_CTD, BALANCE15_BBD BALANCE15_BBD, BALANCE15_BBC BALANCE15_BBC, BALANCE16_DTD BALANCE16_DTD, BALANCE16_CTD BALANCE16_CTD, BALANCE16_BBD BALANCE16_BBD, BALANCE16_BBC BALANCE16_BBC, BALANCE17_DTD BALANCE17_DTD, BALANCE17_CTD BALANCE17_CTD, BALANCE17_BBD BALANCE17_BBD, BALANCE17_BBC BALANCE17_BBC, BALANCE18_DTD BALANCE18_DTD, BALANCE18_CTD BALANCE18_CTD, BALANCE18_BBD BALANCE18_BBD, BALANCE18_BBC BALANCE18_BBC, BALANCE19_DTD BALANCE19_DTD, BALANCE19_CTD BALANCE19_CTD, BALANCE19_BBD BALANCE19_BBD, BALANCE19_BBC BALANCE19_BBC, BALANCE20_DTD BALANCE20_DTD, BALANCE20_CTD BALANCE20_CTD, BALANCE20_BBD BALANCE20_BBD, BALANCE20_BBC BALANCE20_BBC, BALANCE21_DTD BALANCE21_DTD, BALANCE21_CTD BALANCE21_CTD, BALANCE21_BBD BALANCE21_BBD, BALANCE21_BBC BALANCE21_BBC, BALANCE22_DTD BALANCE22_DTD, BALANCE22_CTD BALANCE22_CTD, BALANCE22_BBD BALANCE22_BBD, BALANCE22_BBC BALANCE22_BBC, BALANCE23_DTD BALANCE23_DTD, BALANCE23_CTD BALANCE23_CTD, BALANCE23_BBD BALANCE23_BBD, BALANCE23_BBC BALANCE23_BBC, BALANCE24_DTD BALANCE24_DTD, BALANCE24_CTD BALANCE24_CTD, BALANCE24_BBD BALANCE24_BBD, BALANCE24_BBC BALANCE24_BBC, BALANCE25_DTD BALANCE25_DTD, BALANCE25_CTD BALANCE25_CTD, BALANCE25_BBD BALANCE25_BBD, BALANCE25_BBC BALANCE25_BBC, 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, PROCESSING_STATUS_CODE PROCESSING_STATUS_CODE, PROCESS_ALL_FLAG PROCESS_ALL_FLAG, REQUEST_ID REQUEST_ID, PROGRAM_ID PROGRAM_ID, CONSISTENCY_FLAG CONSISTENCY_FLAG, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, START_DATE START_DATE, END_DATE END_DATE, CREDIT_TYPE_ID CREDIT_TYPE_ID, ROLE_ID ROLE_ID, PAY_GROUP_ID PAY_GROUP_ID, PAID_FLAG PAID_FLAG, BALANCE1_DTD BALANCE1_DTD, BALANCE1_CTD BALANCE1_CTD, BALANCE1_BBD BALANCE1_BBD, BALANCE1_BBC BALANCE1_BBC, BALANCE2_DTD BALANCE2_DTD, BALANCE2_CTD BALANCE2_CTD, BALANCE2_BBD BALANCE2_BBD, BALANCE2_BBC BALANCE2_BBC, BALANCE3_DTD BALANCE3_DTD, BALANCE3_CTD BALANCE3_CTD, BALANCE3_BBD BALANCE3_BBD, BALANCE3_BBC BALANCE3_BBC, BALANCE4_DTD BALANCE4_DTD, BALANCE4_CTD BALANCE4_CTD, BALANCE4_BBD BALANCE4_BBD, BALANCE4_BBC BALANCE4_BBC, BALANCE5_DTD BALANCE5_DTD, BALANCE5_CTD BALANCE5_CTD, BALANCE5_BBD BALANCE5_BBD, BALANCE5_BBC BALANCE5_BBC, BALANCE6_DTD BALANCE6_DTD, BALANCE6_CTD BALANCE6_CTD, BALANCE6_BBD BALANCE6_BBD, BALANCE6_BBC BALANCE6_BBC, BALANCE7_DTD BALANCE7_DTD, BALANCE7_CTD BALANCE7_CTD, BALANCE7_BBD BALANCE7_BBD, BALANCE7_BBC BALANCE7_BBC, BALANCE8_DTD BALANCE8_DTD, BALANCE8_CTD BALANCE8_CTD, BALANCE8_BBD BALANCE8_BBD, BALANCE8_BBC BALANCE8_BBC, BALANCE9_DTD BALANCE9_DTD, BALANCE9_CTD BALANCE9_CTD, BALANCE9_BBD BALANCE9_BBD, BALANCE9_BBC BALANCE9_BBC, BALANCE26_DTD BALANCE26_DTD, BALANCE26_CTD BALANCE26_CTD, BALANCE26_BBD BALANCE26_BBD, BALANCE26_BBC BALANCE26_BBC, BALANCE27_DTD BALANCE27_DTD, BALANCE27_CTD BALANCE27_CTD, BALANCE27_BBD BALANCE27_BBD, BALANCE27_BBC BALANCE27_BBC, BALANCE28_DTD BALANCE28_DTD, BALANCE28_CTD BALANCE28_CTD, BALANCE28_BBD BALANCE28_BBD, BALANCE28_BBC BALANCE28_BBC, BALANCE29_DTD BALANCE29_DTD, BALANCE29_CTD BALANCE29_CTD, BALANCE29_BBD BALANCE29_BBD, BALANCE29_BBC BALANCE29_BBC, BALANCE30_DTD BALANCE30_DTD, BALANCE30_CTD BALANCE30_CTD, BALANCE30_BBD BALANCE30_BBD, BALANCE30_BBC BALANCE30_BBC, BALANCE31_DTD BALANCE31_DTD, BALANCE31_CTD BALANCE31_CTD, BALANCE31_BBD BALANCE31_BBD, BALANCE31_BBC BALANCE31_BBC, BALANCE32_DTD BALANCE32_DTD, BALANCE32_CTD BALANCE32_CTD, BALANCE32_BBD BALANCE32_BBD, BALANCE32_BBC BALANCE32_BBC, BALANCE33_DTD BALANCE33_DTD, BALANCE33_CTD BALANCE33_CTD, BALANCE33_BBD BALANCE33_BBD, BALANCE33_BBC BALANCE33_BBC, SECURITY_GROUP_ID SECURITY_GROUP_ID, QUOTA_ID QUOTA_ID from "CN"."CN_SRP_PERIODS_ALL"

View Text - HTML Formatted

SELECT ORG_ID ORG_ID
, SRP_PERIOD_ID SRP_PERIOD_ID
, SALESREP_ID SALESREP_ID
, PERIOD_ID PERIOD_ID
, SRP_PLAN_ASSIGN_ID SRP_PLAN_ASSIGN_ID
, STATUS STATUS
, CALC_BATCH_ID CALC_BATCH_ID
, PERIOD_TYPE_ID PERIOD_TYPE_ID
, CASH_DTD CASH_DTD
, CASH_CTD CASH_CTD
, CASH_BBD CASH_BBD
, CASH_BBC CASH_BBC
, DUE_DTD DUE_DTD
, DUE_CTD DUE_CTD
, DUE_BBD DUE_BBD
, DUE_BBC DUE_BBC
, COMMISSION_EARNED_DTD COMMISSION_EARNED_DTD
, COMMISSION_EARNED_CTD COMMISSION_EARNED_CTD
, COMMISSION_EARNED_BBD COMMISSION_EARNED_BBD
, COMMISSION_EARNED_BBC COMMISSION_EARNED_BBC
, BONUS_EARNED_DTD BONUS_EARNED_DTD
, BONUS_EARNED_CTD BONUS_EARNED_CTD
, BONUS_EARNED_BBD BONUS_EARNED_BBD
, BONUS_EARNED_BBC BONUS_EARNED_BBC
, DRAW_NONREC_DTD DRAW_NONREC_DTD
, DRAW_NONREC_CTD DRAW_NONREC_CTD
, DRAW_NONREC_BBD DRAW_NONREC_BBD
, DRAW_NONREC_BBC DRAW_NONREC_BBC
, PAYROLL_DUE_DTD PAYROLL_DUE_DTD
, PAYROLL_DUE_CTD PAYROLL_DUE_CTD
, PAYROLL_DUE_BBD PAYROLL_DUE_BBD
, PAYROLL_DUE_BBC PAYROLL_DUE_BBC
, PAYROLL_TRANSFER_DTD PAYROLL_TRANSFER_DTD
, PAYROLL_TRANSFER_CTD PAYROLL_TRANSFER_CTD
, PAYROLL_TRANSFER_BBD PAYROLL_TRANSFER_BBD
, PAYROLL_TRANSFER_BBC PAYROLL_TRANSFER_BBC
, DRAW_PAYABLE_DTD DRAW_PAYABLE_DTD
, DRAW_PAYABLE_CTD DRAW_PAYABLE_CTD
, DRAW_PAYABLE_BBD DRAW_PAYABLE_BBD
, DRAW_PAYABLE_BBC DRAW_PAYABLE_BBC
, MISC_EARNED_DTD MISC_EARNED_DTD
, MISC_EARNED_CTD MISC_EARNED_CTD
, MISC_EARNED_BBD MISC_EARNED_BBD
, MISC_EARNED_BBC MISC_EARNED_BBC
, TRANSFERRED TRANSFERRED
, CLASSIFIED CLASSIFIED
, UNCLASSIFIED UNCLASSIFIED
, DIRECT_PAYED DIRECT_PAYED
, DIRECT_UNPAYED DIRECT_UNPAYED
, INDIRECT_PAYED INDIRECT_PAYED
, CALCULATED CALCULATED
, UNCALCULATED UNCALCULATED
, SUB_CALCULATED SUB_CALCULATED
, SUB_UNCALCULATED SUB_UNCALCULATED
, BALANCE10_DTD BALANCE10_DTD
, BALANCE10_CTD BALANCE10_CTD
, BALANCE10_BBD BALANCE10_BBD
, BALANCE10_BBC BALANCE10_BBC
, BALANCE11_DTD BALANCE11_DTD
, BALANCE11_CTD BALANCE11_CTD
, BALANCE11_BBD BALANCE11_BBD
, BALANCE11_BBC BALANCE11_BBC
, BALANCE12_DTD BALANCE12_DTD
, BALANCE12_CTD BALANCE12_CTD
, BALANCE12_BBD BALANCE12_BBD
, BALANCE12_BBC BALANCE12_BBC
, BALANCE13_DTD BALANCE13_DTD
, BALANCE13_CTD BALANCE13_CTD
, BALANCE13_BBD BALANCE13_BBD
, BALANCE13_BBC BALANCE13_BBC
, BALANCE14_DTD BALANCE14_DTD
, BALANCE14_CTD BALANCE14_CTD
, BALANCE14_BBD BALANCE14_BBD
, BALANCE14_BBC BALANCE14_BBC
, BALANCE15_DTD BALANCE15_DTD
, BALANCE15_CTD BALANCE15_CTD
, BALANCE15_BBD BALANCE15_BBD
, BALANCE15_BBC BALANCE15_BBC
, BALANCE16_DTD BALANCE16_DTD
, BALANCE16_CTD BALANCE16_CTD
, BALANCE16_BBD BALANCE16_BBD
, BALANCE16_BBC BALANCE16_BBC
, BALANCE17_DTD BALANCE17_DTD
, BALANCE17_CTD BALANCE17_CTD
, BALANCE17_BBD BALANCE17_BBD
, BALANCE17_BBC BALANCE17_BBC
, BALANCE18_DTD BALANCE18_DTD
, BALANCE18_CTD BALANCE18_CTD
, BALANCE18_BBD BALANCE18_BBD
, BALANCE18_BBC BALANCE18_BBC
, BALANCE19_DTD BALANCE19_DTD
, BALANCE19_CTD BALANCE19_CTD
, BALANCE19_BBD BALANCE19_BBD
, BALANCE19_BBC BALANCE19_BBC
, BALANCE20_DTD BALANCE20_DTD
, BALANCE20_CTD BALANCE20_CTD
, BALANCE20_BBD BALANCE20_BBD
, BALANCE20_BBC BALANCE20_BBC
, BALANCE21_DTD BALANCE21_DTD
, BALANCE21_CTD BALANCE21_CTD
, BALANCE21_BBD BALANCE21_BBD
, BALANCE21_BBC BALANCE21_BBC
, BALANCE22_DTD BALANCE22_DTD
, BALANCE22_CTD BALANCE22_CTD
, BALANCE22_BBD BALANCE22_BBD
, BALANCE22_BBC BALANCE22_BBC
, BALANCE23_DTD BALANCE23_DTD
, BALANCE23_CTD BALANCE23_CTD
, BALANCE23_BBD BALANCE23_BBD
, BALANCE23_BBC BALANCE23_BBC
, BALANCE24_DTD BALANCE24_DTD
, BALANCE24_CTD BALANCE24_CTD
, BALANCE24_BBD BALANCE24_BBD
, BALANCE24_BBC BALANCE24_BBC
, BALANCE25_DTD BALANCE25_DTD
, BALANCE25_CTD BALANCE25_CTD
, BALANCE25_BBD BALANCE25_BBD
, BALANCE25_BBC BALANCE25_BBC
, 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
, PROCESSING_STATUS_CODE PROCESSING_STATUS_CODE
, PROCESS_ALL_FLAG PROCESS_ALL_FLAG
, REQUEST_ID REQUEST_ID
, PROGRAM_ID PROGRAM_ID
, CONSISTENCY_FLAG CONSISTENCY_FLAG
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, START_DATE START_DATE
, END_DATE END_DATE
, CREDIT_TYPE_ID CREDIT_TYPE_ID
, ROLE_ID ROLE_ID
, PAY_GROUP_ID PAY_GROUP_ID
, PAID_FLAG PAID_FLAG
, BALANCE1_DTD BALANCE1_DTD
, BALANCE1_CTD BALANCE1_CTD
, BALANCE1_BBD BALANCE1_BBD
, BALANCE1_BBC BALANCE1_BBC
, BALANCE2_DTD BALANCE2_DTD
, BALANCE2_CTD BALANCE2_CTD
, BALANCE2_BBD BALANCE2_BBD
, BALANCE2_BBC BALANCE2_BBC
, BALANCE3_DTD BALANCE3_DTD
, BALANCE3_CTD BALANCE3_CTD
, BALANCE3_BBD BALANCE3_BBD
, BALANCE3_BBC BALANCE3_BBC
, BALANCE4_DTD BALANCE4_DTD
, BALANCE4_CTD BALANCE4_CTD
, BALANCE4_BBD BALANCE4_BBD
, BALANCE4_BBC BALANCE4_BBC
, BALANCE5_DTD BALANCE5_DTD
, BALANCE5_CTD BALANCE5_CTD
, BALANCE5_BBD BALANCE5_BBD
, BALANCE5_BBC BALANCE5_BBC
, BALANCE6_DTD BALANCE6_DTD
, BALANCE6_CTD BALANCE6_CTD
, BALANCE6_BBD BALANCE6_BBD
, BALANCE6_BBC BALANCE6_BBC
, BALANCE7_DTD BALANCE7_DTD
, BALANCE7_CTD BALANCE7_CTD
, BALANCE7_BBD BALANCE7_BBD
, BALANCE7_BBC BALANCE7_BBC
, BALANCE8_DTD BALANCE8_DTD
, BALANCE8_CTD BALANCE8_CTD
, BALANCE8_BBD BALANCE8_BBD
, BALANCE8_BBC BALANCE8_BBC
, BALANCE9_DTD BALANCE9_DTD
, BALANCE9_CTD BALANCE9_CTD
, BALANCE9_BBD BALANCE9_BBD
, BALANCE9_BBC BALANCE9_BBC
, BALANCE26_DTD BALANCE26_DTD
, BALANCE26_CTD BALANCE26_CTD
, BALANCE26_BBD BALANCE26_BBD
, BALANCE26_BBC BALANCE26_BBC
, BALANCE27_DTD BALANCE27_DTD
, BALANCE27_CTD BALANCE27_CTD
, BALANCE27_BBD BALANCE27_BBD
, BALANCE27_BBC BALANCE27_BBC
, BALANCE28_DTD BALANCE28_DTD
, BALANCE28_CTD BALANCE28_CTD
, BALANCE28_BBD BALANCE28_BBD
, BALANCE28_BBC BALANCE28_BBC
, BALANCE29_DTD BALANCE29_DTD
, BALANCE29_CTD BALANCE29_CTD
, BALANCE29_BBD BALANCE29_BBD
, BALANCE29_BBC BALANCE29_BBC
, BALANCE30_DTD BALANCE30_DTD
, BALANCE30_CTD BALANCE30_CTD
, BALANCE30_BBD BALANCE30_BBD
, BALANCE30_BBC BALANCE30_BBC
, BALANCE31_DTD BALANCE31_DTD
, BALANCE31_CTD BALANCE31_CTD
, BALANCE31_BBD BALANCE31_BBD
, BALANCE31_BBC BALANCE31_BBC
, BALANCE32_DTD BALANCE32_DTD
, BALANCE32_CTD BALANCE32_CTD
, BALANCE32_BBD BALANCE32_BBD
, BALANCE32_BBC BALANCE32_BBC
, BALANCE33_DTD BALANCE33_DTD
, BALANCE33_CTD BALANCE33_CTD
, BALANCE33_BBD BALANCE33_BBD
, BALANCE33_BBC BALANCE33_BBC
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, QUOTA_ID QUOTA_ID
FROM "CN"."CN_SRP_PERIODS_ALL"