PJC_COST_DIST_LINES_ALL
PA_COST_DISTRIBUTION_LINES_ALL stores information about the cost distribution of expenditure items. When a cost distribution program processes an expenditure item, it creates one or more corresponding cost distribution lines to hold the cost amounts and the general ledger account information to which the cost amounts will post. Cost distribution lines amount are implicitly debit amounts. An expenditure item may have many cost distribution lines if: 1) you account for total burdened costs by running the Distribute Total Burdened Costs process. The cost distribution lines for total burdened costs are identified with the line type of C and D. 2) adjusting cost distribution lines are created due a change in either the cost amount, the GL account, burden cost quantity, burden compiled set identifier or the billable flag. Adjusting lines are identified with a value in the LINE_NUM_REVERSED column. The transfer status of a cost distribution lines is maintained as follows: For labor and usages: Distribute Costs - Create CDL; set to Pending (P) Transfer Costs - If successfully transferred to GL, set to Accepted(A); Else rejected in transfer to GL, set to Rejected in Transfer (X) Tieback Costs - If successfully tied back from GL, no update since already set to Accepted; Else rejected by GL, set to Rejected (R) to be re-transferred For expense reports: Distribute Costs - Create CDL; set to Pending (P) Transfer Costs - If successfully transferred to Oracle Payables, set to Transferred (T); Else rejected in transfer to AP; set to Rejected in Transfer (X) Tieback Costs - If successfully tied back from Oracle Payables, set to Accepted(A); Else rejected by Oracle Payables; set to Rejected (R) to be re-transferred For supplier invoices from Oracle Payables: Interface from Oracle Payables - Upon creation, set to Received (V) For supplier invoice adjustment lines: Distribute Costs - Create CDL; set to Pending (P) If payables rules do not allow adjustments to the invoice (example: if the invoice is cancelled), then distribute supplier invoice adjustments program would create the CDL and set the value to (G), these lines will always reside in Oracle Projects and will not be transferred to Oracle Payables.) Transfer Costs - If successfully transferred to Oracle Payables, set to Accepted(A); Else rejected in transfer to Oracle Payables, set to Rejected in Transfer (X) No Tieback
Details
-
Schema: FUSION
-
Object owner: PJC
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
PJC_COST_DIST_LINES_ALL_PK |
EXPENDITURE_ITEM_ID, LINE_NUM |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| EXPENDITURE_ITEM_ID | NUMBER | 18 | Yes | The identifier of the expenditure item that is cost distributed by the distribution line | |
| RATE_OVERRIDE_ID | NUMBER | 18 | Identifier of rate_override_id from pjf_rate_overrides table | ||
| LINE_NUM | NUMBER | 18 | Yes | The sequential number that identifies the cost distribution line for an expenditure item | |
| PARENT_LINE_NUM | NUMBER | 18 | Line Number for the raw cost distribution line. Valid for I line types only. | ||
| INTERFACE_ID | NUMBER | 18 | INTERFACE_ID ***** | ||
| 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. | |
| ACCOUNTING_STATUS_CODE | VARCHAR2 | 5 | The status of the distribution line as the cost information is transferred to another application ***** | ||
| PROJFUNC_RAW_COST | NUMBER | Yes | Amount in project functional currency. Derrived by converting raw cost in transaction currency to project functional currency ***** | ||
| QUANTITY | NUMBER | Yes | The number of units that are costed in the distribution line cost. The quantity is set from the expenditure item quantity when the distribution line is created and is used for populating the quantities in the accumulation tables | ||
| BILLABLE_FLAG | VARCHAR2 | 1 | Yes | Flag that indicates whether the cost amount is billable. The flag is set from the expenditure item billable flag when the distribution line is created and is used for determining billable/non-billable costs in the accumulation tables | |
| 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. | ||
| PRVDR_PA_DATE | DATE | Yes | Date used to determine the correct project accounting period in the provider operating unit. The PA date is determined by the Distribution programs from the open or future PA period on or after the transaction date ***** | ||
| PRVDR_GL_DATE | DATE | Yes | Date used to determine the correct general ledger accounting period in the provider operating unit. The GL date is determined by the Distribution programs from the open or future GL period on or after the transaction date. For supplier invoices this date is copied from AP. ***** | ||
| TRANSFER_REJECTION_REASON | VARCHAR2 | 250 | The reason why the distribution line was rejected by the PA Cost Transfer program or rejected by the other application's interface program | ||
| ACCUMULATED_FLAG | VARCHAR2 | 1 | Flag indicating if distribution line cost is included in the accumulator tables. Set to 'N' initially, 'Y' when the line is accumulated. Obsolete as of 4.0 with the new project summary amounts. Replaced by RESOURCE_ACCUMULATED_FLAG. | ||
| REVERSED_FLAG | VARCHAR2 | 1 | Flag that indicates if the distribution line is reversed by another distribution line | ||
| LINE_NUM_REVERSED | NUMBER | 18 | The distribution line number that is reversed by this distribution line | ||
| IND_COMPILED_SET_ID | NUMBER | 18 | The identifier of the compiled set which is used to calculate the burden cost | ||
| LINE_TYPE | VARCHAR2 | 1 | Yes | The type of the cost distribution line | |
| PROJFUNC_BURDENED_COST | NUMBER | Yes | Amount of the burdened cost in project functional currency ***** | ||
| PROJFUNC_COST_EXCHANGE_RATE | NUMBER | Exchange rate used to convert costs from the transaction currency to the project functional currency. | |||
| PROJECT_BURDENED_COST | NUMBER | Yes | Burdened cost in project currency. | ||
| ORG_ID | NUMBER | 18 | Yes | Indicates the identifier of the business unit associated to the row. | |
| PROJECT_UNIT_ID | NUMBER | 18 | PROJECT_UNIT_ID ***** | ||
| CAPITALIZABLE_FLAG | VARCHAR2 | 1 | Yes | CAPITALIZABLE_FLAG ***** | |
| BURDEN_SUM_SOURCE_RUN_ID | NUMBER | 18 | This will identify group of Cost Distribution Lines that were summarized to create summarized burden component expenditure items(EI). The same run_id will be populated in EI table to identify all EI's created during a run. | ||
| BURDEN_SUM_REJECTION_CODE | VARCHAR2 | 30 | Burden component summarization rejection code | ||
| PROJECT_ID | NUMBER | 18 | Yes | Identifier of the project | |
| TASK_ID | NUMBER | 18 | Yes | Identifier of the task | |
| DENOM_CURRENCY_CODE | VARCHAR2 | 15 | Yes | Transaction Currency code of the transaction | |
| DENOM_RAW_COST | NUMBER | Yes | The raw cost in transaction currency | ||
| DENOM_BURDENED_COST | NUMBER | Yes | The amount of the burdened cost in transaction currency It is only populated for raw cost distribution lines | ||
| ACCT_CURRENCY_CODE | VARCHAR2 | 15 | Yes | Functional Currency Code | |
| ACCT_RATE_DATE | DATE | Conversion rate date used to convert raw cost from transaction currency to functional currency | |||
| ACCT_RATE_TYPE | VARCHAR2 | 30 | Conversion rate type used to convert raw cost from transaction currency to functional currency | ||
| ACCT_EXCHANGE_RATE | NUMBER | Conversion rate used to convert raw cost from transaction currency to functional currency | |||
| ACCT_RAW_COST | NUMBER | Yes | The amount in functional currency to be charged to the gl account for the expenditure item The amount is stored as a debit, so the burden credit amounts and adjustment amounts are negative | ||
| ACCT_BURDENED_COST | NUMBER | Yes | Burdened cost in functional currency | ||
| PROJECT_CURRENCY_CODE | VARCHAR2 | 15 | Yes | Project currency code of the transaction | |
| PROJECT_RATE_DATE | DATE | Conversion rate date used to convert raw cost from transaction currency to project currency | |||
| PROJECT_RATE_TYPE | VARCHAR2 | 30 | Conversion rate date used to convert raw cost from transaction currency to project currency | ||
| PROJECT_EXCHANGE_RATE | NUMBER | Conversion rate date used to convert raw cost from transaction currency to project currency | |||
| PRC_GENERATED_FLAG | VARCHAR2 | 1 | For future Use | ||
| RECVR_PA_DATE | DATE | Date used to determine the correct project accounting period in the receiver operating unit. The PA date is determined by the Distribution programs from the open or future PA period on or after the transaction date | |||
| RECVR_GL_DATE | DATE | Date used to determine the correct general ledgert accounting period in the receiver operating unit. The GL date is determined by the Distribution programs from the open or future GL period on or after the transaction date | |||
| PROJECT_RAW_COST | NUMBER | Yes | Raw cost in project currency. | ||
| WORK_TYPE_ID | NUMBER | 18 | Identifier for a work type assigned to the transaction. | ||
| PRVDR_GL_PERIOD_NAME | VARCHAR2 | 15 | Yes | The GL period in which the transaction is posted. ***** | |
| COST_SCHEDULE_LINE_ID | NUMBER | 18 | Cost rate schedule line identifier ***** | ||
| COST_SCHEDULE_ID | NUMBER | 18 | Cost rate schedule identifier ***** | ||
| RECVR_GL_PERIOD_NAME | VARCHAR2 | 15 | The GL period in which the transaction is posted on the receiving ledger. | ||
| PRVDR_PA_PERIOD_NAME | VARCHAR2 | 15 | Yes | The PA period in which the transaction is posted. ***** | |
| PROJFUNC_COST_RATE_TYPE | VARCHAR2 | 30 | Rate type used to convert costs from the transaction currency to the project functional currency. | ||
| PROJFUNC_COST_RATE_DATE | DATE | Rate date used to convert costs from the transaction currency to the project functional currency. | |||
| RECVR_PA_PERIOD_NAME | VARCHAR2 | 15 | The PA period in which the transaction is posted on the receiving ledger. | ||
| PROJFUNC_CURRENCY_CODE | VARCHAR2 | 15 | Yes | Project functional currency code. | |
| ORG_LABOR_SCH_RULE_ID | NUMBER | 18 | Identifier for org schedule assignment | ||
| COMP_DETAILS_ID | NUMBER | 18 | Reference to Labor Rate Override. ***** | ||
| PREV_IND_COMPILED_SET_ID | NUMBER | 18 | Identifier of the compiled set previously used to calculate the burden cost. | ||
| SI_ASSETS_ADDITION_FLAG | VARCHAR2 | 1 | This column indicates the status of the cost distribution line in relation to Oracle Assets. This column only applies to supplier cost expenditure items. Valid values are as follows:Y - The distribution line is interfaced to Oracle Assets. | ||
| 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 | ||
| NON_LABOR_RESOURCE_ID | NUMBER | 18 | NON_LABOR_RESOURCE_ID ***** | ||
| TXN_ACCUM_HEADER_ID | NUMBER | 18 | Accum Header Identifier ***** | ||
| PJS_SUMMARY_ID | NUMBER | 18 | PJS_SUMMARY_ID ***** | ||
| BURDENED_COST_CR_CCID | NUMBER | 18 | BURDENED_COST_CR_CCID ***** | ||
| BURDENED_COST_DR_CCID | NUMBER | 18 | BURDENED_COST_DR_CCID ***** | ||
| RAW_COST_CR_CCID | NUMBER | 18 | RAW_COST_CR_CCID ***** | ||
| RAW_COST_DR_CCID | NUMBER | 18 | RAW_COST_DR_CCID ***** | ||
| BURDEN_COST_CR_CCID | NUMBER | 18 | BURDEN_COST_CR_CCID ***** | ||
| BURDEN_COST_DR_CCID | NUMBER | 18 | BURDEN_COST_DR_CCID ***** | ||
| RAW_LINE_NUM_REVERSED | NUMBER | 18 | RAW_LINE_NUM_REVERSED ***** | ||
| ORIG_HISTORICAL_FLAG | VARCHAR2 | 1 | ORIG_HISTORICAL_FLAG ***** | ||
| 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. | |
| 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. | ||
| PRBS_ELEMENT_ID | NUMBER | 18 | Planning resource breakdown structure element identifier of the planning resource that the transaction maps to. | ||
| PRBS_TXN_ACCUM_HEADER_ID | NUMBER | 18 | Unique identifier for the transaction attributes that are used for mapping and deriving a planning resource breakdown structure element. | ||
| BUDGET_CCID | NUMBER | 18 | Budget account used for budget checking raw cost. | ||
| BUDGETARY_CONTROL_VAL_STATUS | VARCHAR2 | 30 | Budgetary control validation status at the distribution level. | ||
| DATA_SET_ID | NUMBER | 18 | Identifies data for a particular budgetary control request. | ||
| BUDGET_PERIOD_ID | NUMBER | 18 | Identifier of Budget Period for which the funding is made. | ||
| TRANSFER_STATUS_CODE | VARCHAR2 | 1 | TRANSFER_STATUS_CODE will contain Y or N for Extracted and non extracted records. | ||
| PLANNED_FLAG | VARCHAR2 | 1 | Identifier whether the transaction amount is palnned or not. | ||
| BACKING_HEADER_ID1 | NUMBER | 18 | Backing Header Identifier One | ||
| BACKING_DIST_ID1 | NUMBER | 18 | Backing Distribution Identifier One | ||
| BACKING_DIST_ID2 | NUMBER | 18 | Backing Distribution Identifier Two | ||
| BACKING_DIST_ID3 | NUMBER | 18 | Backing Distribution Identifier Three | ||
| BACKING_AMOUNT | NUMBER | Backing Distribution Amount | |||
| EXPORT_PROCESS_ID | NUMBER | 18 | Identifier of the most recent instance of the Extract Cost Distributions for External Accounting process. | ||
| LAST_COSTED_DATE | DATE | Date on which the costing process was run and the cost measures of the distribution were derived. For cost distribution lines, this date may precede the cost distribution line creation date as there may be a delay between the date an unprocessed transaction is costed and the date the transaction is successfully imported (which is when the cost distribution line is created). | |||
| COST_RATE_MULTIPLIER | NUMBER | Labor costing multiplier value that was derived during the costing process. This value is used to calculate the raw cost. For example, quantity * raw cost rate * labor costing multiplier value = raw cost. | |||
| BACKING_HEADER_ID2 | NUMBER | 18 | Backing Header Identifier Two | ||
| BACKING_LEDGER_CURR_AMT | NUMBER | Backing Ledger Currency Amount | |||
| BACKING_DIST_ID4 | NUMBER | 18 | Backing Distribution Identifier Four | ||
| BACKING_DIST_ID5 | NUMBER | 18 | Backing Distribution Identifier Five | ||
| BACKING_DIST_ID6 | NUMBER | 18 | Backing Distribution Identifier Six | ||
| TOP_PRBS_ELEMENT_ID | NUMBER | 18 | The identifier of the top resource derived for the transaction using the planning resource breakdown structure. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| PJC_COST_DIST_LINES_ALL | pjc_exp_items_all | EXPENDITURE_ITEM_ID |
| PJC_COST_DIST_LINES_ALL | pjf_proj_elements_b | TASK_ID |
| PJC_COST_DIST_LINES_ALL | gl_daily_conversion_types | ACCT_RATE_TYPE |
| PJC_COST_DIST_LINES_ALL | gl_daily_conversion_types | PROJECT_RATE_TYPE |
| PJC_COST_DIST_LINES_ALL | pjf_work_types_b | WORK_TYPE_ID |
| PJC_COST_DIST_LINES_ALL | gl_daily_conversion_types | PROJFUNC_COST_RATE_TYPE |
| PJC_COST_DIST_LINES_ALL | pjf_projects_all_b | PROJECT_ID |
| PJC_COST_DIST_LINES_ALL | pjf_bu_impl_all | ORG_ID |
| PJC_COST_DIST_LINES_ALL | pjf_rate_overrides | RATE_OVERRIDE_ID |
| PJC_COST_DIST_LINES_ALL | pjf_periods_all | PRVDR_PA_PERIOD_NAME, ORG_ID |
| PJC_COST_DIST_LINES_ALL | pjf_periods_all | RECVR_PA_PERIOD_NAME, ORG_ID |
| pjc_prj_asset_ln_dets | pjc_cost_dist_lines_all | EXPENDITURE_ITEM_ID, LINE_NUM |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PJC_COST_DIST_LINES_ALL_N1 | Non Unique | Default | PROJECT_ID |
| PJC_COST_DIST_LINES_ALL_N10 | Non Unique | Default | ORG_ID |
| PJC_COST_DIST_LINES_ALL_N11 | Non Unique | Default | INTERFACE_ID |
| PJC_COST_DIST_LINES_ALL_N12 | Non Unique | Default | BURDEN_SUM_SOURCE_RUN_ID, PROJECT_ID, ORG_ID |
| PJC_COST_DIST_LINES_ALL_N13 | Non Unique | Default | ORG_LABOR_SCH_RULE_ID |
| PJC_COST_DIST_LINES_ALL_N15 | Non Unique | Default | BUDGETARY_CONTROL_VAL_STATUS, PROJECT_ID |
| PJC_COST_DIST_LINES_ALL_N17 | Non Unique | Default | ACCT_EVENT_ID |
| PJC_COST_DIST_LINES_ALL_N18 | Non Unique | Default | BUDGET_PERIOD_ID |
| PJC_COST_DIST_LINES_ALL_N2 | Non Unique | Default | PJS_SUMMARY_ID |
| PJC_COST_DIST_LINES_ALL_N3 | Non Unique | Default | COMP_DETAILS_ID |
| PJC_COST_DIST_LINES_ALL_N4 | Non Unique | Default | REQUEST_ID |
| PJC_COST_DIST_LINES_ALL_N5 | Non Unique | Default | LAST_UPDATE_DATE |
| PJC_COST_DIST_LINES_ALL_N6 | Non Unique | Default | ACCUMULATED_FLAG |
| PJC_COST_DIST_LINES_ALL_N7 | Non Unique | Default | PRVDR_PA_DATE, ORG_ID |
| PJC_COST_DIST_LINES_ALL_N8 | Non Unique | Default | PRVDR_GL_DATE, ORG_ID |
| PJC_COST_DIST_LINES_ALL_N9 | Non Unique | Default | IND_COMPILED_SET_ID |
| PJC_COST_DIST_LINES_ALL_U1 | Unique | Default | EXPENDITURE_ITEM_ID, LINE_NUM |