VIEW: CN.CN_POSTING_DETAILS_ALL#

Source

View Text - Preformatted

select POSTING_DETAIL_ID POSTING_DETAIL_ID, 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, STATUS STATUS, LOADED_DATE LOADED_DATE, 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, PENDING_STATUS PENDING_STATUS, INPUT_ACHIEVED INPUT_ACHIEVED, RATE_TIER_ID RATE_TIER_ID, PAYEE_LINE_ID PAYEE_LINE_ID, CL_STATUS CL_STATUS, CREATED_DURING CREATED_DURING, 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, POSTING_BATCH_SUM_ID POSTING_BATCH_SUM_ID, PAY_ELEMENT_TYPE_ID PAY_ELEMENT_TYPE_ID, SECURITY_GROUP_ID SECURITY_GROUP_ID from "CN"."CN_POSTING_DETAILS_ALL"

View Text - HTML Formatted

SELECT POSTING_DETAIL_ID POSTING_DETAIL_ID
, 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
, STATUS STATUS
, LOADED_DATE LOADED_DATE
, 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
, PENDING_STATUS PENDING_STATUS
, INPUT_ACHIEVED INPUT_ACHIEVED
, RATE_TIER_ID RATE_TIER_ID
, PAYEE_LINE_ID PAYEE_LINE_ID
, CL_STATUS CL_STATUS
, CREATED_DURING CREATED_DURING
, 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
, POSTING_BATCH_SUM_ID POSTING_BATCH_SUM_ID
, PAY_ELEMENT_TYPE_ID PAY_ELEMENT_TYPE_ID
, SECURITY_GROUP_ID SECURITY_GROUP_ID
FROM "CN"."CN_POSTING_DETAILS_ALL"