PJF_RATE_OVERRIDES_GT
Temporarily loads transactions for determining an appropriate rate override for the transaction attributes.
Details
-
Schema: FUSION
-
Object owner: PJF
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
PJF_RATE_OVERRIDES_GT_PK |
CURRENT_RUN_ID, SOURCE_TRANSACTION_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| CURRENT_RUN_ID | NUMBER | 18 | Yes | Identifier of the current run of the process that processes this record. | |
| SOURCE_TRANSACTION_ID | NUMBER | 18 | Yes | Identifier of the transaction. | |
| PROJECT_ID | NUMBER | 18 | Identifier of the project. | ||
| TASK_ID | NUMBER | 18 | Identifier of the task. | ||
| CONTRACT_ID | NUMBER | 18 | Identifier of the contract. | ||
| CONTRACT_LINE_ID | NUMBER | 18 | Identifier of the contract line. | ||
| BILL_PLAN_ID | NUMBER | 18 | Identifier of the bill plan. | ||
| PERSON_ID | NUMBER | 18 | Identifier of the person. | ||
| JOB_ID | NUMBER | 18 | Identifier of the job. | ||
| EXPENDITURE_TYPE_ID | NUMBER | 18 | Identifier of the expenditure type. | ||
| TRANSACTION_DATE | DATE | Date on the transaction. | |||
| RATE_OVERRIDE_ID | NUMBER | 18 | Identifier of the derived rate override. | ||
| RATE | NUMBER | Derived override rate. | |||
| RATE_UNIT | VARCHAR2 | 30 | Unit of measure of the derived rate. | ||
| CURRENCY_CODE | VARCHAR2 | 15 | Currency of the derived rate. | ||
| RATE_OVERRIDE_REASON_CODE | VARCHAR2 | 30 | Lookup code of the reason for the rate override. | ||
| PROJECT_ROLE_ID | NUMBER | 18 | Identifier of the project role for which the rate override is defined. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| PJF_RATE_OVERRIDES_GT_U1 | Unique | CURRENT_RUN_ID, SOURCE_TRANSACTION_ID |