[Home] [Help] [Dependency Information]
Object Name: | CN_PAYMENT_WORKSHEETS_ALL |
---|---|
Object Type: | TABLE |
Owner: | CN |
FND Design Data: | CN.CN_PAYMENT_WORKSHEETS_ALL |
Subobject Name: | |
Status: | VALID |
CN_PAYMENT_WORKSHEETS contains information about
a payment made to a salesperson, including (when frozen)
the original information about balances used to make the
decision on payment.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
CN_PAYMENT_WORKSHEETS_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
PAYRUN_ID
QUOTA_ID ORG_ID |
CN_PAYMENT_WORKSHEETS_N4 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
PAYRUN_ID
SALESREP_ID QUOTA_ID |
CN_PAYMENT_WORKSHEETS_N5 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
PAYMENT_WORKSHEET_ID
ORG_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ORG_ID | NUMBER | (15) | Organization identifier | |
SALESREP_ID | NUMBER | (15) | Yes | Foreign key to CN_SALESREPS. |
PAYRUN_ID | NUMBER | (15) | Yes | Foreign key to CN_PAYRUNS. |
PAY_CAP | NUMBER | Maximum payment cap imposed on this salesrep. This is derived from the payment plan assigned to the sales person. | ||
COMM_DUE_BB | NUMBER | The beginning balances of commissions due for this payment. | ||
BONUS_DUE_BB | NUMBER | The beginning balance of manual bonus due for this payment. | ||
DRAW_RECOVERABLE_BEGIN | NUMBER | Obsolete | ||
COMM_PTD | NUMBER | The commissions earned during the interval of the payment. | ||
BONUS_PTD | NUMBER | The bonus assigned in the payment worksheet itself. | ||
COMM_DRAW | NUMBER | The amount of commissions used to reduce draw recoverable. | ||
BONUS_DRAW | NUMBER | Obsolete | ||
COMM_PAID | NUMBER | The amount of commissions paid to the salesperson. | ||
BONUS_PAID | NUMBER | The amount of manual bonus paid to the salesperson. | ||
DRAW_PAID | NUMBER | The draw paid to the salesperson. | ||
ADJUST_PAID | NUMBER | Obsolete | ||
COST_CENTER_ID | NUMBER | (15) | Cost center | |
REASON | VARCHAR2 | (80) | Obsolete | |
BONUS_REASON | VARCHAR2 | (80) | Not currently used. | |
RECOVERY_METHOD | VARCHAR2 | (80) | Not currently used. | |
DRAW_PTD | NUMBER | Obsolete | ||
BONUS_GIVEN | NUMBER | Obsolete | ||
GUARANTEE | NUMBER | Minimum payment guarantee for this payment. | ||
PAYMENT_WORKSHEET_ID | NUMBER | (15) | Yes | Unique identifier for payment worksheet |
ROLE_ID | NUMBER | (15) | Sales Role | |
CREDIT_TYPE_ID | NUMBER | (15) | Credit Type | |
RETURNED_FUNDS_FLAG | VARCHAR2 | (1) | Indicates whether the worksheet is for returned funds. 'Y' indicates the worksheet is for returned funds. | |
POST_SUBLEDGER_FLAG | VARCHAR2 | (1) | Indicates whether the returned funds have been posted to the salesperson subledger. | |
MINIMUM_AMOUNT | NUMBER | Minimum amount that needs to be paid per pay interval | ||
COMM_NREC | NUMBER | Non-Recoverable amount paid due to payment plan | ||
REG_BONUS_DUE_BB | NUMBER | Beginning balance for calculated bonus | ||
REG_BONUS_PTD | NUMBER | Earnings for calculated bonus for current period | ||
REG_BONUS_REC | NUMBER | Recoverable calculated bonus | ||
REG_BONUS_TO_REC | NUMBER | Recovery from calculated bonus | ||
REG_BONUS_PAID | NUMBER | Regular bonus paid | ||
PAYEE_COMM_DUE_BB | NUMBER | Beginning balance for payee commission | ||
PAYEE_COMM_PTD | NUMBER | Payee Commission due in the current period | ||
PAYEE_COMM_PAID | NUMBER | The amount of payee commissions paid to the salesperson. | ||
PAYEE_BONUS_DUE_BB | NUMBER | Beginning balance for payee bonus | ||
PAYEE_BONUS_PTD | NUMBER | Payee bonus due in the current period | ||
PAYEE_BONUS_PAID | NUMBER | The amount of payee bonus paid to the salesperson. | ||
CONVERT_TO_TYPE_ID | NUMBER | (15) | Not currently used | |
CREDIT_CONV_FCT_ID | NUMBER | (15) | Not currently used | |
CONVERT_TO_PAID | NUMBER | Not currently used | ||
POSTING_STATUS | VARCHAR2 | (30) | Indicates whether the worksheet has been posted | |
CREATED_BY | NUMBER | (15) | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
CREATION_DATE | DATE | Standard who column - date when this row was created. | ||
LAST_UPDATED_BY | NUMBER | (15) | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_DATE | DATE | Standard Who column - date when a user last updated this row. | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
PMT_AMOUNT_CALC | NUMBER | Calculated payment amount | ||
PMT_AMOUNT_ADJ_REC | NUMBER | Recoverable adjusted payment amount | ||
PMT_AMOUNT_ADJ_NREC | NUMBER | Non-recoverable adjusted payment amount | ||
REVIEWED_BY_ANALYST | VARCHAR2 | (1) | Analyst assigned | |
ANALYST_NOTES | VARCHAR2 | (4000) | Analyst note | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments | ||
CURRENT_EARNINGS_DUE | NUMBER | Current Earnings Due | ||
PMT_AMOUNT_ADJ | NUMBER | Payment Amount Adjustment | ||
PMT_AMOUNT_RECOVERY | NUMBER | Payment Amount Recovery | ||
QUOTA_ID | NUMBER | Foreign key to CN_QUOTAS.QUOTA_ID | ||
WORKSHEET_STATUS | VARCHAR2 | (30) | Yes | Worksheet Status |
OBJECT_VERSION_NUMBER | NUMBER | Standard Who column | ||
CURRENT_EARNINGS | NUMBER | Current Earnings | ||
BB_PMT_RECOVERY_PLANS | NUMBER | Begin Balance : Payment Plan Recovery | ||
BB_PRIOR_PERIOD_ADJ | NUMBER | Begin Balance : Prior Period Adjustment | ||
HELD_AMOUNT | NUMBER | Held Amount | ||
REQUEST_ID | NUMBER | Request ID |
Cut, paste (and edit) the following text to query this object:
SELECT ORG_ID
, SALESREP_ID
, PAYRUN_ID
, PAY_CAP
, COMM_DUE_BB
, BONUS_DUE_BB
, DRAW_RECOVERABLE_BEGIN
, COMM_PTD
, BONUS_PTD
, COMM_DRAW
, BONUS_DRAW
, COMM_PAID
, BONUS_PAID
, DRAW_PAID
, ADJUST_PAID
, COST_CENTER_ID
, REASON
, BONUS_REASON
, RECOVERY_METHOD
, DRAW_PTD
, BONUS_GIVEN
, GUARANTEE
, PAYMENT_WORKSHEET_ID
, ROLE_ID
, CREDIT_TYPE_ID
, RETURNED_FUNDS_FLAG
, POST_SUBLEDGER_FLAG
, MINIMUM_AMOUNT
, COMM_NREC
, REG_BONUS_DUE_BB
, REG_BONUS_PTD
, REG_BONUS_REC
, REG_BONUS_TO_REC
, REG_BONUS_PAID
, PAYEE_COMM_DUE_BB
, PAYEE_COMM_PTD
, PAYEE_COMM_PAID
, PAYEE_BONUS_DUE_BB
, PAYEE_BONUS_PTD
, PAYEE_BONUS_PAID
, CONVERT_TO_TYPE_ID
, CREDIT_CONV_FCT_ID
, CONVERT_TO_PAID
, POSTING_STATUS
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, PMT_AMOUNT_CALC
, PMT_AMOUNT_ADJ_REC
, PMT_AMOUNT_ADJ_NREC
, REVIEWED_BY_ANALYST
, ANALYST_NOTES
, SECURITY_GROUP_ID
, CURRENT_EARNINGS_DUE
, PMT_AMOUNT_ADJ
, PMT_AMOUNT_RECOVERY
, QUOTA_ID
, WORKSHEET_STATUS
, OBJECT_VERSION_NUMBER
, CURRENT_EARNINGS
, BB_PMT_RECOVERY_PLANS
, BB_PRIOR_PERIOD_ADJ
, HELD_AMOUNT
, REQUEST_ID
FROM CN.CN_PAYMENT_WORKSHEETS_ALL;
CN.CN_PAYMENT_WORKSHEETS_ALL does not reference any database object
CN.CN_PAYMENT_WORKSHEETS_ALL is referenced by following:
|
|
|