PJC_CC_DIST_LINES_ALL
PA_CC_DIST_LINES_ALL stores information about the accounting distributions related to transfer price for cross charged expenditure items. This information will be interfaced to Oracle General Ledger from Oracle Projects.
Details
-
Schema: FUSION
-
Object owner: PJC
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
PJC_CC_DIST_LINES_ALL_PK |
CC_DIST_LINE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| CC_DIST_LINE_ID | NUMBER | 18 | Yes | The system-generated number that uniquely identifies the cross charge distribution | |
| EXPENDITURE_ITEM_ID | NUMBER | 18 | Yes | The identifier of the expenditure item to which the cross charge distribution belongs | |
| LINE_NUM | NUMBER | 18 | Yes | The sequential line number that identifies the cross charge distribution line for an expenditure item | |
| LINE_TYPE | VARCHAR2 | 2 | Yes | The type of the cross charge distribution line | |
| CROSS_CHARGE_CODE | VARCHAR2 | 1 | Yes | Indicates the cross charge processing method for the expenditure item. | |
| ACCT_CURRENCY_CODE | VARCHAR2 | 15 | Yes | Functional currency code of the operating unit to which the cross charge distribution belongs | |
| AMOUNT | NUMBER | Yes | Amount to be posted to GL in the functional currency. If the line type is Borrowed or Lent, the amount is transfer price. If the line type is Provider Reclass, the amount is raw cost | ||
| PROJECT_ID | NUMBER | 18 | Yes | Identifier of the project to which the expenditure item belongs. Denormalized column | |
| TASK_ID | NUMBER | 18 | Yes | Identifier of the task to which the expenditure item belongs. Denormalized column | |
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| 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. | ||
| 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. | ||
| ORG_ID | NUMBER | 18 | Yes | Indicates the identifier of the business unit associated to the row. | |
| LINE_NUM_REVERSED | NUMBER | 18 | The distribution line number for the same expenditure item that is reversed by this distribution line | ||
| DIST_LINE_ID_REVERSED | NUMBER | 18 | Identifier of the cross charge distribution that the line reverses . | ||
| REVERSED_FLAG | VARCHAR2 | 1 | Indicates whether the line has been reversed | ||
| DENOM_TP_CURRENCY_CODE | VARCHAR2 | 15 | Transaction currency code of the transfer price | ||
| DENOM_TRANSFER_PRICE | NUMBER | Transaction amount of the transfer price | |||
| ACCT_TP_RATE_TYPE | VARCHAR2 | 30 | Rate type used to convert the transfer price amount from the transaction currency to the functional currency. Defaulted from the implementation options currency conversion attributes for transfer price | ||
| ACCT_TP_RATE_DATE | DATE | Rate date used to convert the transfer price amount from the transaction currency to the functional currency of the provider operating unit. Derived from the implementation options currency rate date code for transfer price conversion | |||
| ACCT_TP_EXCHANGE_RATE | NUMBER | Exchange rate used to convert the transfer price amount from the transaction currency to the functional currency of the provider operating unit | |||
| PA_DATE | DATE | The end date of the PA Period in which the distribution was processed. The PA date is determined by the cross charge process from the open or future PA period on or after the expenditure item date | |||
| GL_DATE | DATE | The end date of the GL accounting period to which the distribution is posted. This date is determined by the transfer program from the first open or future GL period on or after the distributions PA date | |||
| ACCOUNTING_STATUS_CODE | VARCHAR2 | 30 | The status of the distribution line as the accounting information is transferred to GL. ***** | ||
| TRANSFERRED_DATE | DATE | The date the record was transferred to GL | |||
| TRANSFER_REJECTION_CODE | VARCHAR2 | 30 | Rejection code if the record is rejected in transfer to GL. | ||
| MARKUP_CALC_BASE_CODE | VARCHAR2 | 1 | Audit column for transfer price derivation, thus only for borrowed and lent entries. Transaction amount on which the cross charge rate will be based. | ||
| TP_SCHEDULE_LINE_ID | NUMBER | 18 | TP_SCHEDULE_LINE_ID ***** | ||
| IND_COMPILED_SET_ID | NUMBER | 18 | Audit column for transfer price derivation, thus only for borrowed and lent entries. Identifier of the burden compiled set if a burden schedule is used in determining the transfer price. | ||
| BILL_RATE | NUMBER | Audit column for transfer price derivation, thus only for borrowed and lent entries. Bill rate used in deriving the transfer price if the transfer price was based on a rate defined in a bill rate schedule | |||
| TP_BASE_AMOUNT | NUMBER | Audit column for transfer price derivation, thus only for borrowed and lent entries. Base amount used to derive the transfer price, held in transfer price transaction currency | |||
| BILL_MARKUP_PERCENTAGE | NUMBER | Audit column for transfer price derivation, thus only for borrowed and lent entries. Percentage used in deriving the transfer price if the transfer price was based on a markup in bill rate schedule | |||
| SCHEDULE_LINE_PERCENTAGE | NUMBER | Audit column for transfer price derivation, thus only for borrowed and lent entries. Percentage applied to the calculated transfer price from the schedule line | |||
| RULE_PERCENTAGE | NUMBER | Audit column for transfer price derivation, thus only for borrowed and lent entries. Percentage applied to the calculated transfer price from the rule definition | |||
| REFERENCE_1 | NUMBER | The reference to a record in another entity in Oracle Projects For Provider Reclassification entries, this contains the Invoice Detail identifier | |||
| REFERENCE_2 | VARCHAR2 | 240 | The reference to a record in another entity in Oracle Projects For Provider reclassification entries, this contains the source of the amount which may be either the raw cost or the burdened cost | ||
| REFERENCE_3 | NUMBER | The reference to a record in another entity in Oracle Projects For Provider Reclassification entries, this contains the line number of the corresponding cost distribution line | |||
| TP_JOB_ID | NUMBER | 18 | Identifies the Job for the transaction for which the Transfer Price is based on. | ||
| PROJFUNC_TP_EXCHANGE_RATE | NUMBER | Exchange rate used to convert the transfer price from the transaction currency to the project functional currency. | |||
| PROJFUNC_TRANSFER_PRICE | NUMBER | Transfer price in project functional currency. | |||
| TP_AMT_TYPE_CODE | VARCHAR2 | 30 | Cross charge classification. | ||
| PROJFUNC_TP_RATE_TYPE | VARCHAR2 | 30 | Rate type used to convert the transfer price from the transaction currency to the project functional currency. | ||
| PROJFUNC_TP_RATE_DATE | DATE | Rate date used to convert the transfer price from the transaction currency to the project functional currency. | |||
| GL_PERIOD_NAME | VARCHAR2 | 15 | The GL period in which the transaction is posted. | ||
| PA_PERIOD_NAME | VARCHAR2 | 15 | The PA period in which the transaction is posted. | ||
| PROJECT_TP_CURRENCY_CODE | VARCHAR2 | 15 | Project Currency code | ||
| PROJECT_TP_RATE_DATE | DATE | Rate date used to convert the transfer price from the transaction currency to the project currency. | |||
| PROJECT_TP_RATE_TYPE | VARCHAR2 | 30 | Rate type used to convert the transfer price from the transaction currency to the project currency. | ||
| PROJECT_TP_EXCHANGE_RATE | NUMBER | Exchange rate used to convert the transfer price from the transaction the currency to project currency. | |||
| PROJECT_TRANSFER_PRICE | NUMBER | Transfer price in project currency | |||
| PROJFUNC_TP_CURRENCY_CODE | VARCHAR2 | 15 | Project functional Currency. | ||
| ACCT_EVENT_ID | NUMBER | 18 | Identifier of Accounting Event | ||
| ACCT_SOURCE_CODE | VARCHAR2 | 10 | Code used to identify accounting transactions, which are not migrated to SLA | ||
| 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. | |
| TRANSFER_STATUS_CODE | VARCHAR2 | 1 | TRANSFER_STATUS_CODE will contain Y or N for Extracted and non extracted records. | ||
| EXPORT_PROCESS_ID | NUMBER | 18 | Identifier of the most recent instance of the Extract Cross-Charge Distributions for External Accounting process. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| PJC_CC_DIST_LINES_ALL | pjc_exp_items_all | EXPENDITURE_ITEM_ID |
| PJC_CC_DIST_LINES_ALL | gl_daily_conversion_types | PROJFUNC_TP_RATE_TYPE |
| PJC_CC_DIST_LINES_ALL | gl_daily_conversion_types | PROJECT_TP_RATE_TYPE |
| PJC_CC_DIST_LINES_ALL | pjf_projects_all_b | PROJECT_ID |
| PJC_CC_DIST_LINES_ALL | pjf_proj_elements_b | TASK_ID |
| PJC_CC_DIST_LINES_ALL | gl_daily_conversion_types | ACCT_TP_RATE_TYPE |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PJC_CC_DIST_LINES_ALL_N7 | Non Unique | Default | LAST_UPDATE_DATE |
| PJC_CC_DIST_LINES_N1 | Non Unique | Default | PROJECT_ID, TASK_ID |
| PJC_CC_DIST_LINES_N2 | Non Unique | Default | REQUEST_ID, ACCOUNTING_STATUS_CODE |
| PJC_CC_DIST_LINES_N3 | Non Unique | Default | ACCOUNTING_STATUS_CODE |
| PJC_CC_DIST_LINES_N4 | Non Unique | Default | ACCT_EVENT_ID |
| PJC_CC_DIST_LINES_N5 | Non Unique | Default | ORG_ID, PA_DATE |
| PJC_CC_DIST_LINES_N6 | Non Unique | Default | ORG_ID, GL_DATE |
| PJC_CC_DIST_LINES_U1 | Unique | Default | CC_DIST_LINE_ID |
| PJC_CC_DIST_LINES_U2 | Unique | Default | EXPENDITURE_ITEM_ID, LINE_TYPE, LINE_NUM |