CN_TP_PAYSHEETS_ALL
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.
Details
-
Schema: FUSION
-
Object owner: CN
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
CN_PAYSHEETS_PK |
PAYSHEET_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PARTICIPANT_ID | NUMBER | 18 | Yes | Foreign key to CN_SALESREPS. | |
| NOTES | CLOB | This column stores the notes for paysheets made by Analyst or Compensation manager user | |||
| PAYMENT_DATE | DATE | Date of payment | |||
| CHEQUE_NUMBER | VARCHAR2 | 400 | Cheque number | ||
| PAYMENT_METHOD | VARCHAR2 | 30 | Payment method used to pay the participant. Valid values are Cheque or EFT | ||
| JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | ||
| JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. | ||
| WORKER_ID | NUMBER | 18 | WORKER_ID | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| PAYRUN_ID | NUMBER | 18 | Yes | Foreign key to CN_PAYRUNS. | |
| 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. | |||
| 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. | |||
| 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. | |||
| COST_CENTER_ID | NUMBER | 18 | Cost center | ||
| ORG_ID | NUMBER | 18 | Yes | Indicates the identifier of the business unit associated to the row. | |
| PAYSHEET_ID | NUMBER | 18 | Yes | Unique identifier for payment worksheet | |
| CREDIT_TYPE_ID | NUMBER | 18 | Credit Type | ||
| 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. | |||
| SOURCE_ORG_ID | NUMBER | 18 | Source Org ID from which transaction is imported | ||
| EMPLOYEE_NUMBER | VARCHAR2 | 30 | Employee number | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| 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 | |||
| CURRENT_EARNINGS_DUE | NUMBER | Current Earnings Due | |||
| PAY_AMT_ADJ_FUNC_CURR | NUMBER | Payment Amount Adjustment IN FUNCTIONAL CURRENCY | |||
| PAY_AMT_ADJ_HOME_CURR | NUMBER | PAY_AMT_ADJ_HOME_CURR | |||
| PAY_AMT_ADJ_PAY_CURR | NUMBER | PAY_AMT_ADJ_PAY_CURR | |||
| PMT_AMOUNT_RECOVERY | NUMBER | Payment Amount Recovery | |||
| PAY_TO_HOME_CURR_CNVRT | NUMBER | PAY TO HOME CURR CONVERT RATE | |||
| PAY_TO_FUNC_CURR_CNVRT | NUMBER | PAY TO FUNC CURR CONVERT RATE | |||
| TOTAL_AMT_HOME_CURRENCY | NUMBER | Total amount in participant home currency. | |||
| TOTAL_AMT_PAY_TO_HOME_CNVRT | NUMBER | Pay to home currency conversion rate for total amount. | |||
| REC_MAN_ADJ | NUMBER | The sum of recoverable manual adjustments for a paysheet. | |||
| NREC_MAN_ADJ | NUMBER | The sum of nonrecoverable manual adjustments for a paysheet. | |||
| REC_PMT_TXN_ADJ | NUMBER | The sum of recoverable payment transaction adjustments for a paysheet. | |||
| NREC_PMT_TXN_ADJ | NUMBER | The sum of nonrecoverable payment transaction adjustments for a paysheet. | |||
| BAL_WAIVED | NUMBER | The amount of recoverable balance waived for a paysheet. | |||
| PMT_TXN_AMT_DUE | NUMBER | The sum of payment transactions due after adjustments for a paysheet. | |||
| QUOTA_ID | NUMBER | Foreign key to CN_QUOTAS.QUOTA_ID | |||
| HOME_CURRENCY_CODE | VARCHAR2 | 15 | HOME CURRENCY CODE | ||
| PAY_CURRENCY_CODE | VARCHAR2 | 15 | PAY CURRENCY CODE | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| 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 | |||
| ADJUST_STATUS | VARCHAR2 | 30 | Adjust status | ||
| OBJECT_STATUS | VARCHAR2 | 30 | Object status | ||
| ADJUST_COMMENTS | VARCHAR2 | 1000 | Adjust comments | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| HOME_CURR_DATE_USED | VARCHAR2 | 30 | Date parameter used to evaluate home currency code of the paysheet. | ||
| ATTRIBUTE1 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE2 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE3 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE4 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE5 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE6 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE7 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE8 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE9 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE10 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE11 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE12 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE13 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE14 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE15 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| CN_TP_PAYSHEETS_ALL | cn_tp_payruns_all | PAYRUN_ID |
| CN_TP_PAYSHEETS_ALL | cn_srp_participants_all | PARTICIPANT_ID |
| CN_TP_PAYSHEETS_ALL | cn_credit_types_all_b | CREDIT_TYPE_ID, ORG_ID |
| CN_TP_PAYSHEETS_ALL | cn_plan_components_all_b | QUOTA_ID, ORG_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CN_TP_PAYSHEETS_ALL_N1 | Non Unique | Default | PARTICIPANT_ID, PAYRUN_ID, QUOTA_ID, OBJECT_STATUS |
| CN_TP_PAYSHEETS_ALL_N2 | Non Unique | Default | ORG_ID |
| CN_TP_PAYSHEETS_ALL_N3 | Non Unique | Default | PAYRUN_ID |
| CN_TP_PAYSHEETS_ALL_U1 | Unique | Default | PAYSHEET_ID |