PJF_TP_SCHEDULES
PA_CC_TP_SCHEDULES_BG stores the transfer price schedules which define how transfer price is calculated between the provider and receiver organizations for cross charged labor and non-labor transactions. A transfer price schedule consists of lines, each which specifies organizations and transfer price rules for labor and non-labor cross charged transactions between the organizations. You can define different schedules for different uses. For example, an implementation can have one transfer price schedule for all contract projects and another schedule for all indirect projects enabling different levels of relationships and different transfer price rules to be used in determining the transfer price. Schedules are shared across operating units within a business group.
Details
-
Schema: FUSION
-
Object owner: PJF
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
PJF_TP_SCHEDULES_PK |
TP_SCHEDULE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping |
|---|---|---|---|---|---|---|
| TP_SCHEDULE_ID | NUMBER | 18 | Yes | The system-generated number that uniquely identifies the transfer price schedule | ||
| TP_SCHEDULE_NAME | VARCHAR2 | 50 | Yes | The implementation-defined name that uniquely identifies the transfer price schedule in the business group ***** | ||
| START_DATE_ACTIVE | DATE | Yes | First effective date of the transfer price schedule | |||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | |||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | |||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | |||
| END_DATE_ACTIVE | DATE | Last effective date of the transfer price schedule | ||||
| DESCRIPTION | VARCHAR2 | 240 | Description of the transfer price schedule | |||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | Transfer Price Schedules Flexfield (PJF_TP_SCHEDULE_DESC_FLEX) | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transfer Price Schedules Flexfield (PJF_TP_SCHEDULE_DESC_FLEX) | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transfer Price Schedules Flexfield (PJF_TP_SCHEDULE_DESC_FLEX) | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transfer Price Schedules Flexfield (PJF_TP_SCHEDULE_DESC_FLEX) | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transfer Price Schedules Flexfield (PJF_TP_SCHEDULE_DESC_FLEX) | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transfer Price Schedules Flexfield (PJF_TP_SCHEDULE_DESC_FLEX) | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transfer Price Schedules Flexfield (PJF_TP_SCHEDULE_DESC_FLEX) | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transfer Price Schedules Flexfield (PJF_TP_SCHEDULE_DESC_FLEX) | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transfer Price Schedules Flexfield (PJF_TP_SCHEDULE_DESC_FLEX) | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transfer Price Schedules Flexfield (PJF_TP_SCHEDULE_DESC_FLEX) | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transfer Price Schedules Flexfield (PJF_TP_SCHEDULE_DESC_FLEX) | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transfer Price Schedules Flexfield (PJF_TP_SCHEDULE_DESC_FLEX) | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transfer Price Schedules Flexfield (PJF_TP_SCHEDULE_DESC_FLEX) | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transfer Price Schedules Flexfield (PJF_TP_SCHEDULE_DESC_FLEX) | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transfer Price Schedules Flexfield (PJF_TP_SCHEDULE_DESC_FLEX) | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transfer Price Schedules Flexfield (PJF_TP_SCHEDULE_DESC_FLEX) | ||
| 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. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| pjf_projects_all_b | pjf_tp_schedules | NL_TP_SCHEDULE_ID |
| pjf_projects_all_b | pjf_tp_schedules | LABOR_TP_SCHEDULE_ID |
| pjf_tp_schedule_lines | pjf_tp_schedules | TP_SCHEDULE_ID |
| pjf_tp_schedule_line_lkp | pjf_tp_schedules | TP_SCHEDULE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PJF_TP_SCHEDULES_U1 | Unique | Default | TP_SCHEDULE_ID |
| PJF_TP_SCHEDULES_U2 | Unique | Default | TP_SCHEDULE_NAME |