ProjectCosts
The Project Costs resource is used to view project costs. Project costs are the smallest logical units of expenditure that you can charge to a project or task. For example, a time card item or an expense report item.
Columns
| Name | Type | Description |
| TransactionNumber [KEY] | Long | Identifier of the project cost. |
| BurdenedCostInProviderLedgerCurrency | Decimal | Total project cost in the provider ledger currency that includes the burden cost. |
| ProviderLedgerCurrencyCode | String | Code of the currency of the ledger that owns the resource that is incurring the project cost. This currency is used for accounting and reporting in the provider ledger. |
| ProviderLedgerCurrencyConversionRate | Decimal | The ratio at which the principal unit of transaction currency is converted to provider ledger currency. |
| ProviderLedgerCurrencyConversionDate | Date | The date for which to obtain currency conversion rate that is used to convert amounts in transaction currency to provider ledger currency. |
| ProviderLedgerCurrencyConversionRateType | String | The source of a currency conversion rate that determines how to convert amounts in transaction currency to provider ledger currency. |
| RawCostInProviderLedgerCurrency | Decimal | Project cost in the provider ledger currency that is directly attributable to the work performed. |
| BillableFlag | Bool | Specifies if the project cost is billable. A value of true means that the project cost is billable and a value of false means that the project cost is not billable. |
| FundsStatus | String | Status of funds check or funds reservation validation result. A list of valid values - Failed, Passed, and Warning - is defined in the lookup type PJC_XCC_STATUS. |
| CapitalizableFlag | Bool | Specifies if the project cost is capitalizable. A value of true means that the project cost is capitalizable and a value of false means that the project cost is not capitalizable. |
| ContractId | Long | Identifier of the contract for the project cost of a sponsored project. |
| ConvertedFlag | Bool | Indicates if the project cost was converted from a legacy system. A value of true means that the project cost is converted from a legacy system and a value of false means that the project cost is not converted from a legacy system. |
| CreatedBy | String | The user who created the record. |
| CreationDate | Datetime | The date when the record was created. |
| BurdenedCostInTransactionCurrency | Decimal | Total project cost in the transaction currency for a project that is enabled for burdening, including the burden cost. |
| RawCostInTransactionCurrency | Decimal | Project cost in the transaction currency that is directly attributable to the work performed |
| DocumentEntryId | Long | Identifier of the document entry used to capture the project cost. |
| DocumentId | Long | Identifier of the document used to capture the project cost. |
| ExpenditureItemDate | Date | Date on which the project cost was incurred. |
| ExpenditureOrganizationId | Long | Identifier of the expenditure organization to which the project cost is charged. |
| ExpenditureTypeId | Long | Identifier of the expenditure type. |
| AssignmentId | Long | Identifier of the human resources assignment of the person that incurred the cost that was charged to the project. |
| LastUpdateDate | Datetime | The date when the record was last updated. |
| LastUpdatedBy | String | The user who last updated the record. |
| NonlaborResourceId | Long | Identifier of a resource other than human labor through which the project cost is incurred. For example, use of company-owned equipment or internal telecommunications services. |
| NonlaborResourceOrganizationId | Long | Identifier of the organization that owns the nonlabor resource incurring the project cost. |
| OriginalTransactionReference | String | Original transaction reference of a third-party project cost. If duplicate references aren't allowed by the document, then multiple project costs can't refer to the same original transaction. |
| AccrualItemFlag | Bool | Indicates if the project cost belongs to an expenditure batch that will accrue cost in a period and automatically reverse them in the next period. A value of true means that the project cost is an accrual item and a value of false means that the project cost is not an accrual item. |
| PersonType | String | The type used to classify the person in human resources. A list of valid values - Employee and Contingent worker - is defined in the lookup type PJF_PERSON_TYPE. |
| BurdenedCostInProjectCurrency | Decimal | Total project cost in the currency of the project that is incurring the unprocessed cost, including the burden cost. |
| ProjectId | Long | Identifier of the project to which the cost is charged. |
| RawCostInProjectCurrency | Decimal | Project cost that is directly attributable to the work performed in the currency of the project that is incurring the cost. |
| Quantity | Decimal | Quantity entered on the project cost. |
| RawCostRateInTransactionCurrency | Decimal | Project cost in the transaction currency that is directly attributable to the work performed. |
| FundingSourceId | String | Identifier of the funding source of a sponsored project cost. |
| TaskId | Long | Identifier of the task to which the project cost is charged. |
| TransactionSourceId | Long | Identifier of the application in which the project cost was originally created. |
| UnitOfMeasureCode | String | Code that identifies the unit of measure for the item that is requested, ordered, or supplied. |
| WorkTypeId | Long | Identifier of the work type for the project cost. |
| ExpenditureBusinessUnitId | Long | Identifier of the expenditure business unit that incurred the project cost. |
| ExpenditureBusinessUnit | String | Name of the expenditure business unit that incurred the project cost. |
| Document | String | Name of the document used to capture the project cost. |
| DocumentEntry | String | Name of the document entry used to capture the project cost. |
| ProjectName | String | Name of the project to which the cost is charged. |
| ProjectNumber | String | Number of the project to which the cost is charged. |
| TaskName | String | Name of the task to which the project cost is charged. |
| TaskNumber | String | Number of the task to which the project cost is charged. |
| ExpenditureType | String | A classification of cost that is assigned to each project cost. Expenditure types are grouped into cost groups (expenditure categories) and revenue groups (revenue categories). |
| ExpenditureCategory | String | The cost group associated with a project cost. The expenditure category is derived based on the expenditure type and it is a method of grouping expenditure types by the type of cost. |
| ContractName | String | Name of the contract for the project cost of a sponsored project. |
| ContractNumber | String | Number of the contract for the project cost of a sponsored project. |
| FundingSourceName | String | Name of the funding source of a sponsored project cost. |
| FundingSourceNumber | String | Number of the funding source of a sponsored project cost. |
| WorkType | String | Name of the work type for the project cost. |
| PersonName | String | Name of an individual human team member through whom the project cost is incurred. A person must be associated with all time card and expense report transactions and is optional for other types of transactions. |
| PersonNumber | String | Number that uniquely identifies the person who is associated with the project cost. A person must be associated with all time card and expense report transactions and is optional for other types of transactions. It does not have any relation to any national identifier component. |
| PersonId | Long | Identifier of the person through whom the project cost is incurred. A person must be associated with all time card and expense report transactions and is optional for other types of transactions. |
| String | Email address of the person through whom the project cost is incurred. A person must be associated with all time card and expense report transactions and is optional for other types of transactions. | |
| AssignmentName | String | Name of the human resources assignment of the person that incurred the cost that was charged to the project. |
| AssignmentNumber | String | Number of the human resources assignment of the person that incurred the cost that was charged to the project. |
| Job | String | Name of the job that is being performed by the person that incurred the project cost that was charged to the task. |
| JobId | Long | Identifier of the job that is being performed by the person that incurred the project cost that was charged to the task. |
| UnitOfMeasure | String | Name of the unit of measure for the item that is requested, ordered, or supplied. |
| UserExpenditureBatch | String | The name of the expenditure group batch that you provide while creating project costs. |
| NonlaborResourceOrganization | String | Name of the organization that owns the nonlabor resource incurring the project cost. |
| Comment | String | Comment entered for the project cost. |
| ExternalBillRate | Decimal | The unit rate at which a project cost is billed on external contracts. |
| ExternalBillRateCurrency | String | The currency in which a project cost is billed on external contracts. |
| ExternalBillRateSourceName | String | Name of the external source application from where the external bill rate originates. |
| ExternalBillRateSourceReference | String | Identifier of the external bill rate in the external source application. |
| IntercompanyBillRate | Decimal | The unit rate at which a project cost is billed on intercompany contracts. |
| IntercompanyBillRateCurrency | String | The currency in which a project cost is billed on intercompany contracts. |
| IntercompanyBillRateSourceName | String | The name of the external source application from where the intercompany bill rate originates. |
| IntercompanyBillRateSourceReference | String | Identifier of the intercompany bill rate in the external source application. |
| TransactionCurrency | String | The currency in which the project cost was incurred. |
| TransferredFromTransactionNumber | Long | The transaction number of the original project cost which was transferred from a different project, task, contract, or funding source resulting in the creation of the project cost. |
| AdjustingItem | Long | Indicates that the project cost transaction was created as a result of adjusting another project cost. A value of true means that the project cost was created due to the adjustment of another project cost and a value of false or null means that the project cost wasn't created due to the adjustment of another project cost. |
| AllowAdjustments | String | Indicates if the project cost is eligible to be adjusted. A value of true means that you can perform adjustments on the project cost and a value of false means that you can't perform adjustments on the project cost. You can perform adjustments on the project cost if adjustment is allowed at the document entry level, the project cost is not already under adjustment, and if the project cost is not an accrual item. |
| RevenueCategoryCode | String | Code that identifies the grouping of expenditure types or events by type of revenue. For example, a revenue category with a name of Labor refers to labor revenue. |
| CapitalEventNumber | Long | Identifying number of the capital event associated with the project cost. |
| NetZeroItemFlag | Bool | Indicates that the project cost has either been reversed or is reversing another project cost, resulting in a sum of zero for the two costs together. A value of true means that the project cost has a matching reversal cost and a value of false means that the project cost doesn't have a matching reversal cost. |
| ExpenditureTypeClass | String | Additional classification of the project cost that drives the expenditure processing for the project cost. |
| RawCostInReceiverLedgerCurrency | Decimal | Project cost in the receiver ledger currency that is directly attributable to the work performed. |
| BurdenedCostInReceiverLedgerCurrency | Decimal | Total project cost in the receiver ledger currency that includes the burden cost. |
| InvoicedPercentage | Decimal | The percentage of the project cost that has been included on invoices. |
| IntercompanyInvoicedPercentage | Decimal | The percentage of the project cost that has been included on intercompany invoices. |
| IntercompanyInvoiceStatus | String | Indicates if the project cost has been included on an intercompany invoice. A list of valid values is defined in the lookup type ORA_PJC_TXN_BILLING_STATUS. |
| InvoicedStatus | String | Indicates if the project cost has been included on an invoice. A list of valid values is defined in the lookup type ORA_PJC_TXN_BILLING_STATUS. |
| HoldRevenueFlag | Bool | Indicates that the project cost is being held from recognizing revenue. A value of true means that the project cost is being held from recognizing revenue and a value of false means that the project cost is not being held from recognizing revenue. |
| HoldIntercompanyRevenueFlag | Bool | Indicates that the project cost is being held from recognizing intercompany revenue. A value of true means that the project cost is being held from recognizing intercompany revenue and a value of false means that the project cost is not being held from recognizing intercompany revenue. |
| IntercompanyInvoiceAmountInProviderLedgerCurrency | Decimal | The intercompany invoice amount of the project cost, denoted in provider ledger currency. |
| IntercompanyRevenueInProviderLedgerCurrency | Decimal | The intercompany revenue amount of the project cost, denoted in provider ledger currency. |
| InvoiceAmountInReceiverLedgerCurrency | Decimal | The invoice amount of the project cost, denoted in receiver ledger currency. |
| RevenueInReceiverLedgerCurrency | Decimal | The revenue amount of the project cost, denoted in receiver ledger currency. |
| RecognizedRevenuePercentage | Decimal | The percentage of the project cost that has been revenue recognized. |
| IntercompanyRecognizedRevenuePercentage | Decimal | The percentage of the project cost that has been recognized for intercompany revenue. |
| TransferPriceInProviderLedgerCurrency | Decimal | The transfer price of the project cost denoted in provider ledger currency. |
| TransferPriceInTransactionCurrency | Decimal | The transfer price of the project cost denoted in transaction currency. |
| TransferPriceInProjectCurrency | Decimal | The transfer price of the project cost denoted in project currency. |
| TransferPriceInReceiverLedgerCurrency | Decimal | The transfer price of the project cost denoted in receiver ledger currency. |
| HoldInvoiceFlag | Bool | Indicates if the project cost is being held from inclusion on an invoice. A value of true means that the project cost is being held from inclusion on an invoice and a value of false means that the project cost is not being held from inclusion on an invoice. |
| HoldIntercompanyInvoiceFlag | Bool | Indicates if the project cost is being held from inclusion on an intercompany invoice. A value of true means that the project cost is being held from inclusion on an intercompany invoice and a value of false means that the project cost is not being held from inclusion on an intercompany invoice. |
| IntercompanyRevenueStatus | String | Indicates if the project cost has been recognized for intercompany revenue. A list of valid values is defined in the lookup type PJB_EVT_REVENUE_RECOGNZD. |
| RevenueStatus | String | Indicates if the project cost has been recognized for revenue. A list of valid values is defined in the lookup type PJB_EVT_REVENUE_RECOGNZD. |
| ExpenditureTypeClassCode | String | Code that identifies the additional classification of the project cost that drives the expenditure processing for the project cost. |
| AdjustmentStatus | String | Indicates the status of an adjustment made to the project cost. A list of valid values - Pending and Rejected - is defined in the lookup type PJC_ADJ_STATUS. |
| ProviderOrganizationId | Long | Identifier of the provider organization of the project cost. |
| ReceiverOrganizationId | Long | Identifier of the receiver organization of the project cost. |
| ProviderBusinessUnitId | Long | Identifier of the business unit that owns the resource that incurred the actual cost. |
| ReceiverBusinessUnitId | Long | Identifier of the business unit that owns the project for which cost was incurred. |
| ProviderLedgerCurrency | String | Currency of the ledger that owns the resource that is incurring the project cost. This currency is used for accounting and reporting in the provider ledger. |
| NonlaborResource | String | A resource other than human labor through which the project cost is incurred. For example, use of company-owned equipment or internal telecommunications services. |
| AccountingDate | Date | The date used to determine the accounting period for a project cost. |
| AccountingPeriod | String | The accounting period of the cost distribution in the provider organization's accounting calendar. The provider is the organization that owns the labor or nonlabor resource that incurred the project cost. |
| BurdenCostCreditAccountCombinationId | Long | Code combination identifier of the burden cost credit account. |
| BurdenCostDebitAccountCombinationId | Long | Code combination identifier of the burden cost debit account. |
| BurdenedCostCreditAccountCombinationId | Long | Code combination identifier of the burdened cost credit account. |
| BurdenedCostDebitAccountCombinationId | Long | Code combination identifier of the burdened cost debit account. |
| RawCostCreditAccountCombinationId | Long | Code combination identifier of the raw cost credit account. |
| RawCostDebitAccountCombinationId | Long | Code combination identifier of the raw cost debit account. |
| RawCostCreditAccount | String | The ledger account that receives the credit amount for the raw cost associated with a project cost. |
| BurdenCostCreditAccount | String | The ledger account that receives the credit amount for the burden cost associated with a project cost. |
| BurdenCostDebitAccount | String | The ledger account that receives the debit amount for the burden cost associated with a project cost. |
| BurdenedCostCreditAccount | String | The ledger account that receives the credit amount for the burdened cost associated with a project cost. The burdened cost includes the sum of the raw and burden cost. |
| BurdenedCostDebitAccount | String | The ledger account that receives the debit amount for the burdened cost associated with a project cost. The burdened cost includes the sum of the raw and burden cost. |
| RawCostDebitAccount | String | The ledger account that receives the debit amount for the raw cost associated with a project cost. |
| ExpenditureOrganization | String | Name of the expenditure organization to which the project cost is charged. |
| ProviderBusinessUnit | String | Name of the business unit that owns the resource that incurred the actual cost. |
| ReceiverBusinessUnit | String | Name of the business unit that owns the project for which cost was incurred. |
| ProviderOrganization | String | Name of the organization that provided the resource that incurred the cost on the project or cost distribution line. |
| ReceiverOrganization | String | Name of the organization that owns the project in which the actual cost was incurred. |
| BorrowedAndLentDistributed | String | Indicates if borrowed and lent transactions have been created for the project cost. A list of valid values is defined in the lookup PJC_CC_PROCESSED_CODE. |
| CrossChargeType | String | Name of the type of cross-charge processing to be performed on the project cost. A list of valid values is defined in the lookup type PJC_CC_CROSS_CHARGE_CODE. |
| BorrowedAndLentDistributedCode | String | Code that indicates if borrowed and lent transactions have been created for the project cost. A list of valid values is defined in the lookup PJC_CC_PROCESSED_CODE. |
| CrossChargeTypeCode | String | Code of the type of cross-charge processing to be performed on the project cost. A list of valid values is defined in the lookup type PJC_CC_CROSS_CHARGE_CODE. |
| TransactionSource | String | Name of the application in which the project cost was originally created. |
| LaborDistributionOriginalTransactionReference | String | Original reference that identifies a labor distribution transaction. |
| InventoryItemNumber | String | Number of the inventory item associated with the project cost. |
| InventoryItem | String | Name of the inventory item associated with the project cost. |
| InventoryItemId | Long | Identifier of the inventory item associated with the project cost. |
| SalesOrderNumber | String | Reference to the sales order in the originating source system that's associated with the project cost. |
| ShipmentNumber | String | Reference to the shipment details in the originating source system that's associated with the project cost. |
| TransferOrderNumber | String | Reference to the transfer order in the originating source system that's associated with the project cost. |
| WorkOrderNumber | String | Reference to the work order in the originating source system that's associated with the project cost. |
| InventoryTransactionNumber | String | Reference to the inventory transaction in the originating source system that's associated with the project cost. |
| ResourceTransactionNumber | String | Reference to the resource transaction in the originating source system that's associated with the project cost. |
| ResourceName | String | Reference to the resource name in the originating source system that's associated with the project cost. |
| CostElement | String | Reference to the cost element details in the originating source system that's associated with the project cost. |
| ResourceInstance | String | Reference to the resource instance in the originating source system that's associated with the project cost. |
| SupplyChainTransactionActionId | Long | Identifier of the transaction action captured in the Supply Chain Management application. |
| SupplyChainTransactionTypeId | Long | Identifier of the transaction type captured in the Supply Chain Management application. |
| SupplyChainTransactionSourceTypeId | Long | Identifier of the transaction source type captured in the Supply Chain Management application. |
| SourceTransactionQuantity | Decimal | The quantity of the project cost transaction as captured in the originating supply chain cost transaction. |
| SourceTransactionType | String | The name of the transaction type associated with a project cost transaction as captured in the originating Supply Chain Management application. |
| SourceDistributionLayerReference | Long | The distribution layer identifier of the supply chain cost transaction associated with a project cost transaction. |
| ProjectRoleId | Long | Identifier of the project role associated with the project cost. |
| ProjectRoleName | String | A classification of the relationship between a person and the project associated with the project cost, such as Consultant or Technical Lead. |
| CostId | Long | The unique identifier of the payroll cost. |
| CostAllocationKeyflexId | Long | The unique identifier of the payroll cost allocation key flexfield. |
| PayrollName | String | The name of the payroll associated with this cost. |
| CostActionType | String | The unique payroll action identifier of the cost. This identifier is used to gather accounting information associated with the cost. |
| CostActionId | Long | The payroll costing unique identifier for the pay action. |
| PayrollId | Long | The unique identifier of the payroll associated with this cost. |
| RunId | Long | The unique identifier of the payroll run associated with the cost. |
| RunActionId | Long | The unique identifier of the payroll run action used to get accounting information associated with the cost. |
| Finder | String | finder |