Get all project costs
get
/fscmRestApi/resources/11.13.18.05/projectCosts
Request
Query Parameters
-
effectiveDate: string
This query parameter is used to fetch resources which are effective dated as of the specified start date. The value of this query parameter is a string having a date in yyyy-MM-dd format
-
expand: string
When this parameter is provided, the specified children are included in the resource payload (instead of just a link). The value of this query parameter is "all" or "". More than one child can be specified using comma as a separator. Example: ?expand=Employees,Localizations. Nested children can also be provided following the format "Child.NestedChild" (Example: ?expand=Employees.Managers). If a nested child is provided (Example: Employees.Managers), the missing children will be processed implicitly. For example, "?expand=Employees.Managers" is the same as "?expand=Employees,Employees.Managers" (which will expand Employees and Managers).
-
fields: string
This parameter filters the resource fields. Only the specified fields are returned, which means that if no fields are specified, no fields are returned (useful to get only the links). If an indirect child resource is provided (Example: Employees.Managers), the missing children will be processed implicitly. For example, "?fields=Employees.Managers:Empname" is the same as "?fields=;Employees:;Employees.Managers:Empname" (which will only return the "Empname" field for Managers). the value of this query parameter is a list of resource fields. The attribute can be a direct (Example: Employees) or indirect (Example: Employees.Managers) child. It cannot be combined with expand query parameter. If both are provided, only fields will be considered.
Format: ?fields=Attribute1,Attribute2
Format for fields in child resource: ?fields=Accessor1:Attribute1,Attribute2 -
finder: string
Used as a predefined finder to search the collection.
Format: ?finder=<finderName>;<variableName>=<variableValue>,<variableName2>=<variableValue2>
The following are the available finder names and corresponding finder variables:- PrimaryKey: Finds all project costs with the specified ID.
Finder Variables:- TransactionNumber; integer; Identifier of the project cost.
- PrimaryKey: Finds all project costs with the specified ID.
-
limit: integer
This parameter restricts the number of resources returned inside the resource collection. If the limit exceeds the resource count then the framework will only return the available resources.
-
links: string
This parameter can be used to show only certain links while accessing a singular resource or a resource collection. The parameter value format is a comma-separated list of : <link_relation>
Example:
self,canonical -
offset: integer
Used to define the starting position of the resource collection. If offset exceeds the resource count then no resources are returned. Default value is 0.
-
onlyData: boolean
The resource item payload will be filtered in order to contain only data (no links section, for example).
-
orderBy: string
This parameter orders a resource collection based on the specified fields. The parameter value is a comma-separated string of attribute names, each optionally followed by a colon and "asc" or "desc". Specify "asc" for ascending and "desc" for descending. The default value is "asc". For example, ?orderBy=field1:asc,field2:desc
-
q: string
This query parameter defines the where clause. The resource collection will be queried using the provided expressions. The value of this query parameter is one or more expressions. Example: ?q=Deptno>=10 and <= 30;Loc!=NY
Format: ?q=expression1;expression2
You can use these queryable attributes to filter this collection resource using the q query parameter:- AccountingDate; string; 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.
- AccrualItemFlag; boolean; 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.
- AdjustingItem; integer; 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.
- 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.
- 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.
- AssignmentId; integer; Identifier of the human resources assignment of the person that incurred the cost that was charged to the project.
- 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.
- BillableFlag; boolean; 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.
- 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.
- 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.
- BurdenCostCreditAccount; string; The ledger account that receives the credit amount for the burden cost associated with a project cost.
- BurdenCostCreditAccountCombinationId; integer; Code combination identifier of the burden cost credit account.
- BurdenCostDebitAccount; string; The ledger account that receives the debit amount for the burden cost associated with a project cost.
- BurdenCostDebitAccountCombinationId; integer; Code combination identifier of the burden cost debit account.
- 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.
- BurdenedCostCreditAccountCombinationId; integer; Code combination identifier of the burdened cost credit account.
- 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.
- BurdenedCostDebitAccountCombinationId; integer; Code combination identifier of the burdened cost debit account.
- BurdenedCostInProjectCurrency; number; Total project cost in the currency of the project that is incurring the unprocessed cost, including the burden cost.
- BurdenedCostInProviderLedgerCurrency; number; Total project cost in the provider ledger currency that includes the burden cost.
- BurdenedCostInReceiverLedgerCurrency; number; Total project cost in the receiver ledger currency that includes the burden cost.
- BurdenedCostInTransactionCurrency; number; Total project cost in the transaction currency for a project that is enabled for burdening, including the burden cost.
- CapitalEventNumber; integer; Identifying number of the capital event associated with the project cost.
- CapitalizableFlag; boolean; 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.
- Comment; string; Comment entered for the project cost.
- ContractId; integer; Identifier of the contract for the project cost of a sponsored project.
- 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.
- ConvertedFlag; boolean; 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.
- CostActionId; integer; The payroll costing unique identifier for the pay action.
- CostActionType; string; The unique payroll action identifier of the cost. This identifier is used to gather accounting information associated with the cost.
- CostAllocationKeyflexId; integer; The unique identifier of the payroll cost allocation key flexfield.
- CostElement; string; Reference to the cost element details in the originating source system that's associated with the project cost.
- CostId; integer; The unique identifier of the payroll cost.
- CreatedBy; string; The user who created the record.
- CreationDate; string; The date when the record was created.
- 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_TYPE.
- 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_TYPE.
- 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.
- DocumentEntryId; integer; Identifier of the document entry used to capture the project cost.
- DocumentId; integer; Identifier of the document used to capture the project cost.
- Email; 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.
- ExpenditureBusinessUnit; string; Name of the expenditure business unit that incurred the project cost.
- ExpenditureBusinessUnitId; integer; Identifier of the expenditure business unit that incurred the project cost.
- 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.
- ExpenditureItemDate; string; Date on which the project cost was incurred.
- ExpenditureOrganization; string; Name of the expenditure organization to which the project cost is charged.
- ExpenditureOrganizationId; integer; Identifier of the expenditure organization 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).
- ExpenditureTypeClass; string; Additional classification of the project cost that drives the expenditure processing for the project cost.
- ExpenditureTypeClassCode; string; Code that identifies the additional classification of the project cost that drives the expenditure processing for the project cost.
- ExpenditureTypeId; integer; Identifier of the expenditure type.
- ExternalBillRate; number; 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.
- FundingSourceId; string; Identifier of the funding source of a sponsored project cost.
- FundingSourceName; string; Name of the funding source of a sponsored project cost.
- FundingSourceNumber; string; Number of the funding source of a sponsored project cost.
- 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.
- HoldIntercompanyInvoiceFlag; boolean; 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.
- HoldIntercompanyRevenueFlag; boolean; 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.
- HoldInvoiceFlag; boolean; 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.
- HoldRevenueFlag; boolean; 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.
- IntercompanyBillRate; number; 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.
- IntercompanyInvoiceAmountInProviderLedgerCurrency; number; The intercompany invoice amount of the project cost, denoted in provider ledger currency.
- 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.
- IntercompanyInvoicedPercentage; number; The percentage of the project cost that has been included on intercompany invoices.
- IntercompanyRecognizedRevenuePercentage; number; The percentage of the project cost that has been recognized for intercompany revenue.
- IntercompanyRevenueInProviderLedgerCurrency; number; The intercompany revenue amount of the project cost, denoted in provider ledger currency.
- 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.
- InventoryItem; string; Name of the inventory item associated with the project cost.
- InventoryItemId; integer; Identifier of the inventory item associated with the project cost.
- InventoryItemNumber; string; Number of the inventory item associated with the project cost.
- InventoryTransactionNumber; string; Reference to the inventory transaction in the originating source system that's associated with the project cost.
- InvoiceAmountInReceiverLedgerCurrency; number; The invoice amount of the project cost, denoted in receiver ledger currency.
- InvoicedPercentage; number; The percentage of the project cost that has been included on invoices.
- 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.
- 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; integer; Identifier of the job that is being performed by the person that incurred the project cost that was charged to the task.
- LaborDistributionOriginalTransactionReference; string; Original reference that identifies a labor distribution transaction.
- LastUpdateDate; string; The date when the record was last updated.
- LastUpdatedBy; string; The user who last updated the record.
- NetZeroItemFlag; boolean; 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.
- 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.
- NonlaborResourceId; integer; 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.
- NonlaborResourceOrganization; string; Name of the organization that owns the nonlabor resource incurring the project cost.
- NonlaborResourceOrganizationId; integer; 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.
- PayrollId; integer; The unique identifier of the payroll associated with this cost.
- PayrollName; string; The name of the payroll associated with this cost.
- PersonId; integer; 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.
- 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.
- 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.
- ProjectId; integer; Identifier of the project to which the cost is charged.
- ProjectName; string; Name of the project to which the cost is charged.
- ProjectNumber; string; Number of the project to which the cost is charged.
- ProjectRoleId; integer; 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.
- ProviderBusinessUnit; string; Name of the business unit that owns the resource that incurred the actual cost.
- ProviderBusinessUnitId; integer; Identifier of the business unit that owns the resource that incurred the actual cost.
- 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.
- 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.
- ProviderLedgerCurrencyConversionDate; string; The date for which to obtain currency conversion rate that is used to convert amounts in transaction currency to provider ledger currency.
- ProviderLedgerCurrencyConversionRate; number; The ratio at which the principal unit of transaction currency is converted 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.
- ProviderOrganization; string; Name of the organization that provided the resource that incurred the cost on the project or cost distribution line.
- ProviderOrganizationId; integer; Identifier of the provider organization of the project cost.
- Quantity; number; Quantity entered on the project cost.
- RawCostCreditAccount; string; The ledger account that receives the credit amount for the raw cost associated with a project cost.
- RawCostCreditAccountCombinationId; integer; Code combination identifier of the raw cost credit account.
- RawCostDebitAccount; string; The ledger account that receives the debit amount for the raw cost associated with a project cost.
- RawCostDebitAccountCombinationId; integer; Code combination identifier of the raw cost debit account.
- RawCostInProjectCurrency; number; Project cost that is directly attributable to the work performed in the currency of the project that is incurring the cost.
- RawCostInProviderLedgerCurrency; number; Project cost in the provider ledger currency that is directly attributable to the work performed.
- RawCostInReceiverLedgerCurrency; number; Project cost in the receiver ledger currency that is directly attributable to the work performed.
- RawCostInTransactionCurrency; number; Project cost in the transaction currency that is directly attributable to the work performed.
- RawCostRateInTransactionCurrency; number; Project cost in the transaction currency that is directly attributable to the work performed.
- ReceiverBusinessUnit; string; Name of the business unit that owns the project for which cost was incurred.
- ReceiverBusinessUnitId; integer; Identifier of the business unit that owns the project for which cost was incurred.
- ReceiverOrganization; string; Name of the organization that owns the project in which the actual cost was incurred.
- ReceiverOrganizationId; integer; Identifier of the receiver organization of the project cost.
- RecognizedRevenuePercentage; number; The percentage of the project cost that has been revenue recognized.
- ResourceInstance; string; Reference to the resource instance 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.
- ResourceTransactionNumber; string; Reference to the resource transaction in the originating source system that's associated with the project cost.
- 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.
- RevenueInReceiverLedgerCurrency; number; The revenue amount of the project cost, denoted in receiver ledger currency.
- 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.
- RunActionId; integer; The unique identifier of the payroll run action used to get accounting information associated with the cost.
- RunId; integer; The unique identifier of the payroll run associated with the 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.
- SourceDistributionLayerReference; integer; The distribution layer identifier of the supply chain cost transaction associated with a project cost transaction.
- SourceTransactionQuantity; number; 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.
- SupplyChainTransactionActionId; integer; Identifier of the transaction action captured in the Supply Chain Management application.
- SupplyChainTransactionSourceTypeId; integer; Identifier of the transaction source type captured in the Supply Chain Management application.
- SupplyChainTransactionTypeId; integer; Identifier of the transaction type captured in the Supply Chain Management application.
- TaskId; integer; Identifier of the task to which the project 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.
- TransactionCurrency; string; The currency in which the project cost was incurred.
- TransactionNumber; integer; Identifier of the project cost.
- TransactionSource; string; Name of the application in which the project cost was originally created.
- TransactionSourceId; integer; Identifier of the application in which the project cost was originally created.
- TransferOrderNumber; string; Reference to the transfer order in the originating source system that's associated with the project cost.
- TransferPriceInProjectCurrency; number; The transfer price of the project cost denoted in project currency.
- TransferPriceInProviderLedgerCurrency; number; The transfer price of the project cost denoted in provider ledger currency.
- TransferPriceInReceiverLedgerCurrency; number; The transfer price of the project cost denoted in receiver ledger currency.
- TransferPriceInTransactionCurrency; number; The transfer price of the project cost denoted in transaction currency.
- TransferredFromTransactionNumber; integer; 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.
- UnitOfMeasure; string; Name of the unit of measure for the item that is requested, ordered, or supplied.
- UnitOfMeasureCode; string; Code that identifies 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.
- WorkOrderNumber; string; Reference to the work order in the originating source system that's associated with the project cost.
- WorkType; string; Name of the work type for the project cost.
- WorkTypeId; integer; Identifier of the work type for the project cost.
-
totalResults: boolean
The resource collection representation will include the "estimated row count" when "?totalResults=true", otherwise the count is not included. The default value is "false".
Header Parameters
-
Effective-Of:
This header accepts a string value. The string is a semi-colon separated list of
= . It is used to perform effective date range operations. The accepted parameters are RangeMode, RangeSpan, RangeStartDate, RangeEndDate, RangeStartSequence and RangeEndSequence. The parameter values are always strings. The possible values for RangeMode are SET_LOGICAL_START, SET_LOGICAL_END, END_DATE, SET_EFFECTIVE_START, SET_EFFECTIVE_END, REPLACE_CORRECTION, REPLACE_UPDATE, RECONCILE_CORRECTION, CORRECTION, RECONCILE_UPDATE, UPDATE, ZAP and DELETE_CHANGES. The possible values for RangeSpan are PHYSICAL_ROW_END_DATE and LOGICAL_ROW_END_DATE. The values for RangeStartDate and RangeEndDate have to be a string representation of a date in yyyy-MM-dd format. The value for RangeStartSequence and RangeEndSequence must be strings such that when parsed they yield positive integers. -
Metadata-Context:
If the REST API supports runtime customizations, the shape of the service may change during runtime. The REST client may isolate itself from these changes or choose to interact with the latest version of the API by specifying this header. For example: Metadata-Context:sandbox="TrackEmployeeFeature".
-
REST-Framework-Version:
The protocol version between a REST client and service. If the client does not specify this header in the request the server will pick a default version for the API.
There's no request body for this operation.
Back to TopResponse
Supported Media Types
- application/json
Default Response
The following table describes the default response for this task.
Headers
-
Metadata-Context:
If the REST API supports runtime customizations, the shape of the service may change during runtime. The REST client may isolate itself from these changes or choose to interact with the latest version of the API by specifying this header. For example: Metadata-Context:sandbox="TrackEmployeeFeature".
-
REST-Framework-Version:
The protocol version between a REST client and service. If the client does not specify this header in the request the server will pick a default version for the API.
Root Schema : projectCosts
Type:
Show Source
object-
count(required): integer
The number of resource instances returned in the current range.
-
hasMore(required): boolean
Indicates whether more resources are available on the server than the subset returned in the response. If the value is true, then there are more resources to retrieve from the server. The default value is false.
-
items: array
Items
Title:
ItemsThe items in the collection. -
limit(required): integer
The actual paging size used by the server.
-
links(required): array
Links
Title:
LinksThe link relations associated with the resource instance. -
offset(required): integer
The offset value used in the current page.
-
totalResults: integer
The estimated row count when "?totalResults=true", otherwise the count is not included.
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : projectCosts-item-response
Type:
Show Source
object-
AccountingDate: string
(date)
Title:
Accounting DateRead Only:trueThe date used to determine the accounting period for a project cost. -
AccountingPeriod: string
Title:
Accounting PeriodRead Only:trueMaximum Length:15The 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. -
AccrualItemFlag: boolean
Title:
Accrual itemRead Only:trueMaximum Length:1Indicates 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. -
AdjustingItem: integer
(int64)
Title:
Adjusting ItemRead Only:trueIndicates 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. -
Adjustments: array
Adjustments
Title:
AdjustmentsThe Adjustments resource is used to view the adjustments performed on project costs. -
AdjustmentStatus: string
Title:
Adjustment StatusRead Only:trueMaximum Length:80Indicates 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. -
AllowAdjustments: string
Title:
Allow adjustmentsRead Only:trueMaximum Length:1Indicates 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. -
AssignmentId: integer
(int64)
Title:
Assignment IDRead Only:trueIdentifier of the human resources assignment of the person that incurred the cost that was charged to the project. -
AssignmentName: string
Title:
Assignment NameRead Only:trueMaximum Length:80Name of the human resources assignment of the person that incurred the cost that was charged to the project. -
AssignmentNumber: string
Title:
Assignment NumberRead Only:trueMaximum Length:30Number of the human resources assignment of the person that incurred the cost that was charged to the project. -
BillableFlag: boolean
Title:
BillableRead Only:trueMaximum Length:1Specifies 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. -
BorrowedAndLentDistributed: string
Title:
Borrowed and Lent DistributedRead Only:trueMaximum Length:80Indicates 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. -
BorrowedAndLentDistributedCode: string
Title:
Borrowed and Lent DistributedRead Only:trueMaximum Length:1Code 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. -
BurdenCostCreditAccount: string
Title:
Burden Cost Credit AccountRead Only:trueThe ledger account that receives the credit amount for the burden cost associated with a project cost. -
BurdenCostCreditAccountCombinationId: integer
(int64)
Title:
Burden Cost Credit Account Combination IDRead Only:trueCode combination identifier of the burden cost credit account. -
BurdenCostDebitAccount: string
Title:
Burden Cost Debit AccountRead Only:trueThe ledger account that receives the debit amount for the burden cost associated with a project cost. -
BurdenCostDebitAccountCombinationId: integer
(int64)
Title:
Burden Cost Debit Account Combination IDRead Only:trueCode combination identifier of the burden cost debit account. -
BurdenedCostCreditAccount: string
Title:
Burdened Cost Credit AccountRead Only:trueThe 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. -
BurdenedCostCreditAccountCombinationId: integer
(int64)
Title:
Burdened Cost Credit Account Combination IDRead Only:trueCode combination identifier of the burdened cost credit account. -
BurdenedCostDebitAccount: string
Title:
Burdened Cost Debit AccountRead Only:trueThe 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. -
BurdenedCostDebitAccountCombinationId: integer
(int64)
Title:
Burdened Cost Debit Account Combination IDRead Only:trueCode combination identifier of the burdened cost debit account. -
BurdenedCostInProjectCurrency: number
Title:
Burdened Cost in Project CurrencyRead Only:trueTotal project cost in the currency of the project that is incurring the unprocessed cost, including the burden cost. -
BurdenedCostInProviderLedgerCurrency: number
Title:
Burdened Cost in Provider Ledger CurrencyRead Only:trueTotal project cost in the provider ledger currency that includes the burden cost. -
BurdenedCostInReceiverLedgerCurrency: number
Title:
Burdened Cost in Receiver Ledger CurrencyRead Only:trueTotal project cost in the receiver ledger currency that includes the burden cost. -
BurdenedCostInTransactionCurrency: number
Title:
Burdened Cost in Transaction CurrencyRead Only:trueTotal project cost in the transaction currency for a project that is enabled for burdening, including the burden cost. -
CapitalEventNumber: integer
(int64)
Title:
Capital Event NumberRead Only:trueIdentifying number of the capital event associated with the project cost. -
CapitalizableFlag: boolean
Title:
CapitalizableRead Only:trueMaximum Length:1Specifies 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. -
Comment: string
Title:
CommentRead Only:trueMaximum Length:240Comment entered for the project cost. -
ContractId: integer
(int64)
Title:
Contract IDRead Only:trueIdentifier of the contract for the project cost of a sponsored project. -
ContractName: string
Title:
Contract NameRead Only:trueMaximum Length:300Name of the contract for the project cost of a sponsored project. -
ContractNumber: string
Title:
Contract NumberRead Only:trueMaximum Length:120Number of the contract for the project cost of a sponsored project. -
ConvertedFlag: boolean
Title:
ConvertedRead Only:trueMaximum Length:1Indicates 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. -
CostActionId: integer
(int64)
Title:
Payroll Cost Action IDRead Only:trueThe payroll costing unique identifier for the pay action. -
CostActionType: string
Title:
Payroll Cost Action TypeRead Only:trueMaximum Length:120The unique payroll action identifier of the cost. This identifier is used to gather accounting information associated with the cost. -
CostAllocationKeyflexId: integer
(int64)
Title:
Payroll Cost Allocation Key Flexfield IDRead Only:trueThe unique identifier of the payroll cost allocation key flexfield. -
CostElement: string
Title:
Cost ElementRead Only:trueMaximum Length:255Reference to the cost element details in the originating source system that's associated with the project cost. -
CostId: integer
(int64)
Title:
Payroll Cost IDRead Only:trueThe unique identifier of the payroll cost. -
CreatedBy: string
Title:
Created ByRead Only:trueMaximum Length:64The user who created the record. -
CreationDate: string
(date-time)
Title:
Creation DateRead Only:trueThe date when the record was created. -
CrossChargeType: string
Title:
Cross-Charge TypeRead Only:trueMaximum Length:80Name 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_TYPE. -
CrossChargeTypeCode: string
Title:
Cross-Charge TypeRead Only:trueMaximum Length:2Code 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_TYPE. -
Document: string
Title:
DocumentRead Only:trueMaximum Length:240Name of the document used to capture the project cost. -
DocumentEntry: string
Title:
Document EntryRead Only:trueMaximum Length:240Name of the document entry used to capture the project cost. -
DocumentEntryId: integer
(int64)
Title:
Document Entry IDRead Only:trueIdentifier of the document entry used to capture the project cost. -
DocumentId: integer
(int64)
Title:
Document IDRead Only:trueIdentifier of the document used to capture the project cost. -
Email: string
Title:
EmailRead Only:trueMaximum Length:240Email 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. -
ExpenditureBusinessUnit: string
Title:
Expenditure Business UnitRead Only:trueMaximum Length:240Name of the expenditure business unit that incurred the project cost. -
ExpenditureBusinessUnitId: integer
(int64)
Title:
Expenditure Business Unit IDRead Only:trueIdentifier of the expenditure business unit that incurred the project cost. -
ExpenditureCategory: string
Title:
Expenditure CategoryRead Only:trueMaximum Length:240The 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. -
ExpenditureItemDate: string
(date)
Title:
Expenditure Item DateRead Only:trueDate on which the project cost was incurred. -
ExpenditureOrganization: string
Title:
OrganizationRead Only:trueMaximum Length:240Name of the expenditure organization to which the project cost is charged. -
ExpenditureOrganizationId: integer
Title:
Expenditure Organization IDRead Only:trueIdentifier of the expenditure organization to which the project cost is charged. -
ExpenditureType: string
Title:
Expenditure TypeRead Only:trueMaximum Length:240A classification of cost that is assigned to each project cost. Expenditure types are grouped into cost groups (expenditure categories) and revenue groups (revenue categories). -
ExpenditureTypeClass: string
Title:
Expenditure Type ClassRead Only:trueMaximum Length:80Additional classification of the project cost that drives the expenditure processing for the project cost. -
ExpenditureTypeClassCode: string
Title:
Expenditure Type Class CodeRead Only:trueMaximum Length:3Code that identifies the additional classification of the project cost that drives the expenditure processing for the project cost. -
ExpenditureTypeId: integer
(int64)
Title:
Expenditure Type IDRead Only:trueIdentifier of the expenditure type. -
ExternalBillRate: number
Title:
External Bill RateThe unit rate at which a project cost is billed on external contracts. -
ExternalBillRateCurrency: string
Title:
External Bill Rate CurrencyMaximum Length:15The currency in which a project cost is billed on external contracts. -
ExternalBillRateSourceName: string
Title:
External Bill Rate Source NameMaximum Length:150Name of the external source application from where the external bill rate originates. -
ExternalBillRateSourceReference: string
Title:
External Bill Rate Source ReferenceMaximum Length:30Identifier of the external bill rate in the external source application. -
FundingSourceId: string
Title:
Funding Source IDRead Only:trueMaximum Length:150Identifier of the funding source of a sponsored project cost. -
FundingSourceName: string
Title:
Funding Source NameRead Only:trueMaximum Length:360Name of the funding source of a sponsored project cost. -
FundingSourceNumber: string
Title:
Funding Source NumberRead Only:trueMaximum Length:50Number of the funding source of a sponsored project cost. -
FundsStatus: string
Title:
Funds StatusRead Only:trueMaximum Length:30Status 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. -
HoldIntercompanyInvoiceFlag: boolean
Title:
Hold Intercompany InvoiceRead Only:trueMaximum Length:1Indicates 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. -
HoldIntercompanyRevenueFlag: boolean
Title:
Hold Intercompany RevenueRead Only:trueMaximum Length:1Indicates 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. -
HoldInvoiceFlag: boolean
Title:
Hold InvoiceRead Only:trueMaximum Length:1Indicates 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. -
HoldRevenueFlag: boolean
Title:
Hold RevenueRead Only:trueMaximum Length:1Indicates 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. -
IntercompanyBillRate: number
Title:
Intercompany Bill RateThe unit rate at which a project cost is billed on intercompany contracts. -
IntercompanyBillRateCurrency: string
Title:
Intercompany Bill Rate CurrencyMaximum Length:15The currency in which a project cost is billed on intercompany contracts. -
IntercompanyBillRateSourceName: string
Title:
Intercompany Bill Rate Source NameMaximum Length:150The name of the external source application from where the intercompany bill rate originates. -
IntercompanyBillRateSourceReference: string
Title:
Intercompany Bill Rate Source ReferenceMaximum Length:20Identifier of the intercompany bill rate in the external source application. -
IntercompanyInvoiceAmountInProviderLedgerCurrency: number
Title:
Intercompany Invoice Amount in Provider Ledger CurrencyRead Only:trueThe intercompany invoice amount of the project cost, denoted in provider ledger currency. -
IntercompanyInvoicedPercentage: number
Title:
Intercompany Invoiced PercentageRead Only:trueThe percentage of the project cost that has been included on intercompany invoices. -
IntercompanyInvoiceStatus: string
Title:
Intercompany Invoice StatusRead Only:trueMaximum Length:1Indicates 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. -
IntercompanyRecognizedRevenuePercentage: number
Title:
Intercompany Recognized Revenue PercentageRead Only:trueThe percentage of the project cost that has been recognized for intercompany revenue. -
IntercompanyRevenueInProviderLedgerCurrency: number
Title:
Intercompany Revenue Amount in Provider Ledger CurrencyRead Only:trueThe intercompany revenue amount of the project cost, denoted in provider ledger currency. -
IntercompanyRevenueStatus: string
Title:
Intercompany Revenue StatusRead Only:trueMaximum Length:1Indicates 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. -
InventoryItem: string
Title:
Inventory ItemRead Only:trueMaximum Length:240Name of the inventory item associated with the project cost. -
InventoryItemId: integer
(int64)
Title:
Inventory Item IDRead Only:trueIdentifier of the inventory item associated with the project cost. -
InventoryItemNumber: string
Title:
Inventory Item NumberRead Only:trueMaximum Length:300Number of the inventory item associated with the project cost. -
InventoryTransactionNumber: string
Title:
Inventory Transaction NumberRead Only:trueMaximum Length:255Reference to the inventory transaction in the originating source system that's associated with the project cost. -
InvoiceAmountInReceiverLedgerCurrency: number
Title:
Invoice Amount in Receiver Ledger CurrencyRead Only:trueThe invoice amount of the project cost, denoted in receiver ledger currency. -
InvoicedPercentage: number
Title:
Invoiced PercentageRead Only:trueThe percentage of the project cost that has been included on invoices. -
InvoicedStatus: string
Title:
Invoice StatusRead Only:trueMaximum Length:1Indicates 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. -
Job: string
Title:
JobRead Only:trueMaximum Length:240Name of the job that is being performed by the person that incurred the project cost that was charged to the task. -
JobId: integer
(int64)
Title:
Job IDRead Only:trueIdentifier of the job that is being performed by the person that incurred the project cost that was charged to the task. -
LaborDistributionOriginalTransactionReference: string
Title:
Labor Distribution Original Transaction ReferenceRead Only:trueMaximum Length:120Original reference that identifies a labor distribution transaction. -
LastUpdateDate: string
(date-time)
Title:
Last Update DateRead Only:trueThe date when the record was last updated. -
LastUpdatedBy: string
Title:
Last Updated ByRead Only:trueMaximum Length:64The user who last updated the record. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
NetZeroItemFlag: boolean
Title:
Net Zero ItemRead Only:trueMaximum Length:1Indicates 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. -
NonlaborResource: string
Title:
Nonlabor ResourceRead Only:trueMaximum Length:240A resource other than human labor through which the project cost is incurred. For example, use of company-owned equipment or internal telecommunications services. -
NonlaborResourceId: integer
(int64)
Title:
Nonlabor Resource IDRead Only:trueIdentifier 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. -
NonlaborResourceOrganization: string
Title:
OrganizationRead Only:trueMaximum Length:240Name of the organization that owns the nonlabor resource incurring the project cost. -
NonlaborResourceOrganizationId: integer
(int64)
Title:
Nonlabor Resource Organization IDRead Only:trueIdentifier of the organization that owns the nonlabor resource incurring the project cost. -
OriginalTransactionReference: string
Title:
Original Transaction ReferenceRead Only:trueMaximum Length:120Original 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. -
PayrollId: integer
(int64)
Title:
Payroll IDRead Only:trueThe unique identifier of the payroll associated with this cost. -
PayrollName: string
Title:
Payroll NameRead Only:trueMaximum Length:120The name of the payroll associated with this cost. -
PersonId: integer
(int64)
Title:
Person IDRead Only:trueIdentifier 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. -
PersonName: string
Title:
Person NameRead Only:trueMaximum Length:240Name 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
Title:
Person NumberRead Only:trueMaximum Length:30Number 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. -
PersonType: string
Title:
Person TypeRead Only:trueMaximum Length:20The 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. -
ProjectCostsDFF: array
Project Costs Descriptive Flexfields
Title:
Project Costs Descriptive FlexfieldsThe Project Costs Descriptive Flexfields resource is used to view and update additional information for project costs. -
ProjectId: integer
(int64)
Title:
Project IDRead Only:trueIdentifier of the project to which the cost is charged. -
ProjectName: string
Title:
Project NameRead Only:trueMaximum Length:240Name of the project to which the cost is charged. -
ProjectNumber: string
Title:
Project NumberRead Only:trueMaximum Length:25Number of the project to which the cost is charged. -
ProjectRoleId: integer
(int64)
Title:
Project Role IDRead Only:trueIdentifier of the project role associated with the project cost. -
ProjectRoleName: string
Title:
Project Role NameRead Only:trueMaximum Length:240A classification of the relationship between a person and the project associated with the project cost, such as Consultant or Technical Lead. -
ProjectStandardCostCollectionFlexFields: array
Project Standard Cost Collection Flexfields
Title:
Project Standard Cost Collection FlexfieldsThe Project Standard Cost Collection Flexfields resource is used to capture, view, and update standard cost collection information for project costs. -
ProviderBusinessUnit: string
Title:
Provider Business UnitRead Only:trueMaximum Length:240Name of the business unit that owns the resource that incurred the actual cost. -
ProviderBusinessUnitId: integer
(int64)
Title:
Provider Business Unit IDRead Only:trueIdentifier of the business unit that owns the resource that incurred the actual cost. -
ProviderLedgerCurrency: string
Title:
Provider Ledger CurrencyRead Only:trueMaximum Length:80Currency 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. -
ProviderLedgerCurrencyCode: string
Title:
Provider Ledger Currency CodeRead Only:trueMaximum Length:15Code 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. -
ProviderLedgerCurrencyConversionDate: string
(date)
Title:
Provider Ledger Currency Conversion DateRead Only:trueThe date for which to obtain currency conversion rate that is used to convert amounts in transaction currency to provider ledger currency. -
ProviderLedgerCurrencyConversionRate: number
Title:
Provider Ledger Currency Conversion RateRead Only:trueThe ratio at which the principal unit of transaction currency is converted to provider ledger currency. -
ProviderLedgerCurrencyConversionRateType: string
Title:
Provider Ledger Currency Conversion Rate TypeRead Only:trueMaximum Length:30The source of a currency conversion rate that determines how to convert amounts in transaction currency to provider ledger currency. -
ProviderOrganization: string
Title:
Provider OrganizationRead Only:trueMaximum Length:240Name of the organization that provided the resource that incurred the cost on the project or cost distribution line. -
ProviderOrganizationId: integer
(int64)
Title:
Provider Organization IDRead Only:trueIdentifier of the provider organization of the project cost. -
Quantity: number
Title:
QuantityRead Only:trueQuantity entered on the project cost. -
RawCostCreditAccount: string
Title:
Raw Cost Debit AccountRead Only:trueThe ledger account that receives the credit amount for the raw cost associated with a project cost. -
RawCostCreditAccountCombinationId: integer
(int64)
Title:
Raw Cost Credit Account Combination IDRead Only:trueCode combination identifier of the raw cost credit account. -
RawCostDebitAccount: string
Title:
Raw Cost Debit AccountRead Only:trueThe ledger account that receives the debit amount for the raw cost associated with a project cost. -
RawCostDebitAccountCombinationId: integer
(int64)
Title:
Raw Cost Debit Account Combination IDRead Only:trueCode combination identifier of the raw cost debit account. -
RawCostInProjectCurrency: number
Title:
Raw Cost in Project CurrencyRead Only:trueProject cost that is directly attributable to the work performed in the currency of the project that is incurring the cost. -
RawCostInProviderLedgerCurrency: number
Title:
Raw Cost in Provider Ledger CurrencyRead Only:trueProject cost in the provider ledger currency that is directly attributable to the work performed. -
RawCostInReceiverLedgerCurrency: number
Title:
Raw Cost in Receiver Ledger CurrencyRead Only:trueProject cost in the receiver ledger currency that is directly attributable to the work performed. -
RawCostInTransactionCurrency: number
Title:
Raw Cost in Transaction CurrencyRead Only:trueProject cost in the transaction currency that is directly attributable to the work performed. -
RawCostRateInTransactionCurrency: number
Title:
Raw Cost in Transaction CurrencyRead Only:trueProject cost in the transaction currency that is directly attributable to the work performed. -
ReceiverBusinessUnit: string
Title:
OrganizationRead Only:trueMaximum Length:240Name of the business unit that owns the project for which cost was incurred. -
ReceiverBusinessUnitId: integer
(int64)
Title:
Receiver Business Unit IDRead Only:trueIdentifier of the business unit that owns the project for which cost was incurred. -
ReceiverOrganization: string
Title:
Receiver OrganizationRead Only:trueMaximum Length:240Name of the organization that owns the project in which the actual cost was incurred. -
ReceiverOrganizationId: integer
(int64)
Title:
Receiver Organization IDRead Only:trueIdentifier of the receiver organization of the project cost. -
RecognizedRevenuePercentage: number
Title:
Recognized Revenue PercentageRead Only:trueThe percentage of the project cost that has been revenue recognized. -
ResourceInstance: string
Title:
Resource InstanceRead Only:trueMaximum Length:255Reference to the resource instance in the originating source system that's associated with the project cost. -
ResourceName: string
Title:
Resource NameRead Only:trueMaximum Length:255Reference to the resource name in the originating source system that's associated with the project cost. -
ResourceTransactionNumber: string
Title:
Resource Transaction NumberRead Only:trueMaximum Length:255Reference to the resource transaction in the originating source system that's associated with the project cost. -
RevenueCategoryCode: string
Title:
Revenue CategoryRead Only:trueMaximum Length:30Code 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. -
RevenueInReceiverLedgerCurrency: number
Title:
Revenue in Receiver Ledger CurrencyRead Only:trueThe revenue amount of the project cost, denoted in receiver ledger currency. -
RevenueStatus: string
Title:
Revenue StatusRead Only:trueMaximum Length:1Indicates if the project cost has been recognized for revenue. A list of valid values is defined in the lookup type PJB_EVT_REVENUE_RECOGNZD. -
RunActionId: integer
(int64)
Title:
Payroll Run Action IDRead Only:trueThe unique identifier of the payroll run action used to get accounting information associated with the cost. -
RunId: integer
(int64)
Title:
Payroll Run IDRead Only:trueThe unique identifier of the payroll run associated with the cost. -
SalesOrderNumber: string
Title:
Sales Order NumberRead Only:trueMaximum Length:255Reference to the sales order in the originating source system that's associated with the project cost. -
ShipmentNumber: string
Title:
Shipment NumberRead Only:trueMaximum Length:255Reference to the shipment details in the originating source system that's associated with the project cost. -
SourceDistributionLayerReference: integer
(int64)
Title:
Source Distribution Layer ReferenceRead Only:trueThe distribution layer identifier of the supply chain cost transaction associated with a project cost transaction. -
SourceTransactionQuantity: number
Title:
Source Transaction QuantityRead Only:trueThe quantity of the project cost transaction as captured in the originating supply chain cost transaction. -
SourceTransactionType: string
Title:
Source Transaction TypeRead Only:trueThe name of the transaction type associated with a project cost transaction as captured in the originating Supply Chain Management application. -
SupplyChainTransactionActionId: integer
(int64)
Title:
Supply Chain Transaction Action IDRead Only:trueIdentifier of the transaction action captured in the Supply Chain Management application. -
SupplyChainTransactionSourceTypeId: integer
(int64)
Title:
Supply Chain Transaction Source Type IDRead Only:trueIdentifier of the transaction source type captured in the Supply Chain Management application. -
SupplyChainTransactionTypeId: integer
(int64)
Title:
Supply Chain Transaction Type IDRead Only:trueIdentifier of the transaction type captured in the Supply Chain Management application. -
TaskId: integer
(int64)
Title:
Task IDRead Only:trueIdentifier of the task to which the project cost is charged. -
TaskName: string
Title:
Task NameRead Only:trueMaximum Length:255Name of the task to which the project cost is charged. -
TaskNumber: string
Title:
Task NumberRead Only:trueMaximum Length:100Number of the task to which the project cost is charged. -
TransactionCurrency: string
Title:
Transaction CurrencyRead Only:trueMaximum Length:80The currency in which the project cost was incurred. -
TransactionNumber: integer
(int64)
Title:
Transaction NumberIdentifier of the project cost. -
TransactionSource: string
Title:
Transaction SourceRead Only:trueMaximum Length:240Name of the application in which the project cost was originally created. -
TransactionSourceId: integer
(int64)
Title:
Transaction Source IDRead Only:trueIdentifier of the application in which the project cost was originally created. -
TransferOrderNumber: string
Title:
Transfer Order NumberRead Only:trueMaximum Length:255Reference to the transfer order in the originating source system that's associated with the project cost. -
TransferPriceInProjectCurrency: number
Title:
Transfer Price Amount in Project CurrencyRead Only:trueThe transfer price of the project cost denoted in project currency. -
TransferPriceInProviderLedgerCurrency: number
Title:
Transfer Price Amount in Provider Ledger CurrencyRead Only:trueThe transfer price of the project cost denoted in provider ledger currency. -
TransferPriceInReceiverLedgerCurrency: number
Title:
Transfer Price Amount in Receiver Ledger CurrencyRead Only:trueThe transfer price of the project cost denoted in receiver ledger currency. -
TransferPriceInTransactionCurrency: number
Title:
Transfer Price Amount in Transaction CurrencyRead Only:trueThe transfer price of the project cost denoted in transaction currency. -
TransferredFromTransactionNumber: integer
(int64)
Title:
Transferred from Transaction NumberRead Only:trueThe 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. -
UnitOfMeasure: string
Title:
Unit of MeasureRead Only:trueMaximum Length:80Name of the unit of measure for the item that is requested, ordered, or supplied. -
UnitOfMeasureCode: string
Title:
Unit of Measure CodeRead Only:trueMaximum Length:30Code that identifies the unit of measure for the item that is requested, ordered, or supplied. -
UserExpenditureBatch: string
Title:
User Expenditure BatchRead Only:trueMaximum Length:200The name of the expenditure group batch that you provide while creating project costs. -
WorkOrderNumber: string
Title:
Work Order NumberRead Only:trueMaximum Length:255Reference to the work order in the originating source system that's associated with the project cost. -
WorkType: string
Title:
Work TypeRead Only:trueMaximum Length:240Name of the work type for the project cost. -
WorkTypeId: integer
(int64)
Title:
Work Type IDRead Only:trueIdentifier of the work type for the project cost.
Nested Schema : Adjustments
Type:
arrayTitle:
AdjustmentsThe Adjustments resource is used to view the adjustments performed on project costs.
Show Source
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : Project Costs Descriptive Flexfields
Type:
arrayTitle:
Project Costs Descriptive FlexfieldsThe Project Costs Descriptive Flexfields resource is used to view and update additional information for project costs.
Show Source
Nested Schema : Project Standard Cost Collection Flexfields
Type:
arrayTitle:
Project Standard Cost Collection FlexfieldsThe Project Standard Cost Collection Flexfields resource is used to capture, view, and update standard cost collection information for project costs.
Show Source
-
Array of:
object Discriminator: __FLEX_Context
Discriminator:
{ "propertyName":"__FLEX_Context", "mapping":{ "AP_Distribution_Sets":"#/components/schemas/oracle_apps_projects_costing_transactions_flex_PjcExp_view_PJCDFFAP__5FDistribution__5FSetsVO-item-response", "AP_Invoice_Distribution":"#/components/schemas/oracle_apps_projects_costing_transactions_flex_PjcExp_view_PJCDFFAP__5FInvoice__5FDistributionVO-item-response", "AP_Invoice_Line":"#/components/schemas/oracle_apps_projects_costing_transactions_flex_PjcExp_view_PJCDFFAP__5FInvoice__5FLineVO-item-response", "EXM_Expense_Report":"#/components/schemas/oracle_apps_projects_costing_transactions_flex_PjcExp_view_PJCDFFEXM__5FExpense__5FReportVO-item-response", "EXM_Expense_Report_Line":"#/components/schemas/oracle_apps_projects_costing_transactions_flex_PjcExp_view_PJCDFFEXM__5FExpense__5FReport__5FLineVO-item-response", "INV_Misc_Transactions":"#/components/schemas/oracle_apps_projects_costing_transactions_flex_PjcExp_view_PJCDFFINV__5FMisc__5FTransactionsVO-item-response", "OM_Sales_Order":"#/components/schemas/oracle_apps_projects_costing_transactions_flex_PjcExp_view_PJCDFFOM__5FSales__5FOrderVO-item-response", "PJC_All":"#/components/schemas/oracle_apps_projects_costing_transactions_flex_PjcExp_view_PJCDFFPJC__5FAllVO-item-response", "PJC_Expenditure_Batch":"#/components/schemas/oracle_apps_projects_costing_transactions_flex_PjcExp_view_PJCDFFPJC__5FExpenditure__5FBatchVO-item-response", "POR_Requisition":"#/components/schemas/oracle_apps_projects_costing_transactions_flex_PjcExp_view_PJCDFFPOR__5FRequisitionVO-item-response", "POR_User_Preferences":"#/components/schemas/oracle_apps_projects_costing_transactions_flex_PjcExp_view_PJCDFFPOR__5FUser__5FPreferencesVO-item-response", "PO_Purchase_Order":"#/components/schemas/oracle_apps_projects_costing_transactions_flex_PjcExp_view_PJCDFFPO__5FPurchase__5FOrderVO-item-response", "PO_Purchase_Order_Line":"#/components/schemas/oracle_apps_projects_costing_transactions_flex_PjcExp_view_PJCDFFPO__5FPurchase__5FOrder__5FLineVO-item-response", "PO_Purchase_Order_Schedule":"#/components/schemas/oracle_apps_projects_costing_transactions_flex_PjcExp_view_PJCDFFPO__5FPurchase__5FOrder__5FScheduleVO-item-response" } }
Nested Schema : projectCosts-Adjustments-item-response
Type:
Show Source
object-
AdjustedBy: string
Read Only:
trueMaximum Length:64Name of the person who initiated the project cost adjustment. -
AdjustedOn: string
(date-time)
Title:
DateRead Only:trueDate on which the project cost was adjusted. -
AdjustmentSource: string
Read Only:
trueMaximum Length:80Source of the project cost adjustment. A list of valid values is defined in the lookup type PJC_ADJ_SOURCE. -
AdjustmentSourceCode: string
Read Only:
trueMaximum Length:30Code that identifies the source of the project cost adjustment. A list of valid values is defined in the lookup type PJC_ADJ_SOURCE. -
AdjustmentStatus: string
Read Only:
trueMaximum Length:80Status of the adjustment that was performed on the project cost. A list of valid values is defined in the lookup type PJC_ADJUST_HISTORY_REC_STATUS. -
AdjustmentStatusCode: string
Read Only:
trueMaximum Length:2Code that identifies the status of the adjustment that was performed on the project cost. A list of valid values is defined in the lookup type PJC_ADJUST_HISTORY_REC_STATUS. -
AdjustmentType: string
Read Only:
trueMaximum Length:80Type of adjustment that was performed on the project cost. A list of valid values is defined in the lookup type PJC_ADJUSTMENT_TYPE. -
AdjustmentTypeCode: string
Read Only:
trueMaximum Length:30Code that identifies the type of adjustment that was performed on the project cost. A list of valid values is defined in the lookup type PJC_ADJUSTMENT_TYPE. -
ExpenditureItemId: integer
(int64)
Read Only:
trueIdentifier of the project cost. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
RejectionReason: string
Read Only:
trueMaximum Length:240Reason why the project cost adjustment wasn't processed successfully. -
RejectionReasonCode: string
Read Only:
trueMaximum Length:30Code that identifies the reason why the project cost adjustment wasn't processed successfully.
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : link
Type:
Show Source
object-
href: string
Title:
hyperlink referenceThe URI to the related resource. -
kind: string
Title:
kindAllowed Values:[ "collection", "item", "describe", "other" ]The kind of the related resource. -
name: string
Title:
nameThe name of the link to the related resource. -
properties: object
properties
-
rel: string
Title:
relationAllowed Values:[ "self", "lov", "parent", "canonical", "child", "enclosure", "action", "custom" ]The name of the relation to the resource instance. Example: self.
Nested Schema : properties
Type:
Show Source
object-
changeIndicator: string
Change indicator or the ETag value of the resource instance.
Nested Schema : projectCosts-ProjectCostsDFF-item-response
Type:
Show Source
object-
__FLEX_Context: string
Title:
Context PromptMaximum Length:30Code that identifies the context for the segments of the project expenditure items. -
__FLEX_Context_DisplayValue: string
Title:
Context PromptName of the context for the segments of the project expenditure items. -
ExpenditureItemId: integer
(int64)
Title:
Transaction NumberThe identifier of the project cost transaction. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance.
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : Discriminator: __FLEX_Context
Type:
objectDiscriminator: __FLEX_Context
Discriminator Values
- AP_Distribution_Sets
- AP_Invoice_Distribution
- AP_Invoice_Line
- EXM_Expense_Report
- EXM_Expense_Report_Line
- INV_Misc_Transactions
- OM_Sales_Order
- PJC_All
- PJC_Expenditure_Batch
- POR_Requisition
- POR_User_Preferences
- PO_Purchase_Order
- PO_Purchase_Order_Line
- PO_Purchase_Order_Schedule
Match One Schema
Show Source
-
AP_Distribution_Sets -
object
oracle_apps_projects_costing_transactions_flex_PjcExp_view_PJCDFFAP__5FDistribution__5FSetsVO-item-response
-
AP_Invoice_Distribution -
object
oracle_apps_projects_costing_transactions_flex_PjcExp_view_PJCDFFAP__5FInvoice__5FDistributionVO-item-response
-
AP_Invoice_Line -
object
oracle_apps_projects_costing_transactions_flex_PjcExp_view_PJCDFFAP__5FInvoice__5FLineVO-item-response
-
EXM_Expense_Report -
object
oracle_apps_projects_costing_transactions_flex_PjcExp_view_PJCDFFEXM__5FExpense__5FReportVO-item-response
-
EXM_Expense_Report_Line -
object
oracle_apps_projects_costing_transactions_flex_PjcExp_view_PJCDFFEXM__5FExpense__5FReport__5FLineVO-item-response
-
INV_Misc_Transactions -
object
oracle_apps_projects_costing_transactions_flex_PjcExp_view_PJCDFFINV__5FMisc__5FTransactionsVO-item-response
-
OM_Sales_Order -
object
oracle_apps_projects_costing_transactions_flex_PjcExp_view_PJCDFFOM__5FSales__5FOrderVO-item-response
-
PJC_All -
object
oracle_apps_projects_costing_transactions_flex_PjcExp_view_PJCDFFPJC__5FAllVO-item-response
-
PJC_Expenditure_Batch -
object
oracle_apps_projects_costing_transactions_flex_PjcExp_view_PJCDFFPJC__5FExpenditure__5FBatchVO-item-response
-
POR_Requisition -
object
oracle_apps_projects_costing_transactions_flex_PjcExp_view_PJCDFFPOR__5FRequisitionVO-item-response
-
POR_User_Preferences -
object
oracle_apps_projects_costing_transactions_flex_PjcExp_view_PJCDFFPOR__5FUser__5FPreferencesVO-item-response
-
PO_Purchase_Order -
object
oracle_apps_projects_costing_transactions_flex_PjcExp_view_PJCDFFPO__5FPurchase__5FOrderVO-item-response
-
PO_Purchase_Order_Line -
object
oracle_apps_projects_costing_transactions_flex_PjcExp_view_PJCDFFPO__5FPurchase__5FOrder__5FLineVO-item-response
-
PO_Purchase_Order_Schedule -
object
oracle_apps_projects_costing_transactions_flex_PjcExp_view_PJCDFFPO__5FPurchase__5FOrder__5FScheduleVO-item-response
Nested Schema : oracle_apps_projects_costing_transactions_flex_PjcExp_view_PJCDFFAP__5FDistribution__5FSetsVO-item-response
Type:
Show Source
object-
__FLEX_Context: string
Title:
Context ValueMaximum Length:40Default Value:AP_Distribution_SetsName of the context for the segments of the standard cost collection flexfields of the project costs. -
__FLEX_Context_DisplayValue: string
Title:
Context ValueName of the context for the segments of the project expenditure items. -
_BILLABLE_FLAG: string
Title:
Billable -
_BILLABLE_FLAG_Display: string
Title:
Billable -
_CAPITALIZABLE_FLAG: string
Title:
Capitalizable -
_CAPITALIZABLE_FLAG_Display: string
Title:
Capitalizable -
_CONTRACT_ID: number
Title:
Contract Number -
_CONTRACT_ID_Display: string
Title:
Contract Number -
_EXPENDITURE_TYPE_ID: number
Title:
Expenditure Type -
_EXPENDITURE_TYPE_ID_Display: string
Title:
Expenditure Type -
_ORGANIZATION_ID: number
Title:
Expenditure Organization -
_ORGANIZATION_ID_Display: string
Title:
Expenditure Organization -
_PROJECT_ID: number
Title:
Project Number -
_PROJECT_ID_Display: string
Title:
Project Number -
_RESERVED_ATTRIBUTE1: string
Title:
Funding Source -
_RESERVED_ATTRIBUTE1_Display: string
Title:
Funding Source -
_TASK_ID: number
Title:
Task Number -
_TASK_ID_Display: string
Title:
Task Number -
_WORK_TYPE_ID: number
Title:
Work Type -
_WORK_TYPE_ID_Display: string
Title:
Work Type -
ExpenditureItemId: integer
(int64)
Title:
Transaction NumberIdentifier of the project cost. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance.
Nested Schema : oracle_apps_projects_costing_transactions_flex_PjcExp_view_PJCDFFAP__5FInvoice__5FDistributionVO-item-response
Type:
Show Source
object-
__FLEX_Context: string
Title:
Context ValueMaximum Length:40Default Value:AP_Invoice_DistributionName of the context for the segments of the standard cost collection flexfields of the project costs. -
__FLEX_Context_DisplayValue: string
Title:
Context ValueName of the context for the segments of the project expenditure items. -
_BILLABLE_FLAG: string
Title:
Billable -
_BILLABLE_FLAG_Display: string
Title:
Billable -
_CAPITALIZABLE_FLAG: string
Title:
Capitalizable -
_CAPITALIZABLE_FLAG_Display: string
Title:
Capitalizable -
_CONTRACT_ID: number
Title:
Contract Number -
_CONTRACT_ID_Display: string
Title:
Contract Number -
_EXPENDITURE_ITEM_DATE: string
(date)
Title:
Expenditure Item Date -
_EXPENDITURE_TYPE_ID: number
Title:
Expenditure Type -
_EXPENDITURE_TYPE_ID_Display: string
Title:
Expenditure Type -
_ORGANIZATION_ID: number
Title:
Expenditure Organization -
_ORGANIZATION_ID_Display: string
Title:
Expenditure Organization -
_PROJECT_ID: number
Title:
Project Number -
_PROJECT_ID_Display: string
Title:
Project Number -
_RESERVED_ATTRIBUTE1: string
Title:
Funding Source -
_RESERVED_ATTRIBUTE1_Display: string
Title:
Funding Source -
_TASK_ID: number
Title:
Task Number -
_TASK_ID_Display: string
Title:
Task Number -
_WORK_TYPE_ID: number
Title:
Work Type -
_WORK_TYPE_ID_Display: string
Title:
Work Type -
ExpenditureItemId: integer
(int64)
Title:
Transaction NumberIdentifier of the project cost. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance.
Nested Schema : oracle_apps_projects_costing_transactions_flex_PjcExp_view_PJCDFFAP__5FInvoice__5FLineVO-item-response
Type:
Show Source
object-
__FLEX_Context: string
Title:
Context ValueMaximum Length:40Default Value:AP_Invoice_LineName of the context for the segments of the standard cost collection flexfields of the project costs. -
__FLEX_Context_DisplayValue: string
Title:
Context ValueName of the context for the segments of the project expenditure items. -
_BILLABLE_FLAG: string
Title:
Billable -
_BILLABLE_FLAG_Display: string
Title:
Billable -
_CAPITALIZABLE_FLAG: string
Title:
Capitalizable -
_CAPITALIZABLE_FLAG_Display: string
Title:
Capitalizable -
_CONTRACT_ID: number
Title:
Contract Number -
_CONTRACT_ID_Display: string
Title:
Contract Number -
_EXPENDITURE_ITEM_DATE: string
(date)
Title:
Expenditure Item Date -
_EXPENDITURE_TYPE_ID: number
Title:
Expenditure Type -
_EXPENDITURE_TYPE_ID_Display: string
Title:
Expenditure Type -
_ORGANIZATION_ID: number
Title:
Expenditure Organization -
_ORGANIZATION_ID_Display: string
Title:
Expenditure Organization -
_PROJECT_ID: number
Title:
Project Number -
_PROJECT_ID_Display: string
Title:
Project Number -
_RESERVED_ATTRIBUTE1: string
Title:
Funding Source -
_RESERVED_ATTRIBUTE1_Display: string
Title:
Funding Source -
_TASK_ID: number
Title:
Task Number -
_TASK_ID_Display: string
Title:
Task Number -
_WORK_TYPE_ID: number
Title:
Work Type -
_WORK_TYPE_ID_Display: string
Title:
Work Type -
ExpenditureItemId: integer
(int64)
Title:
Transaction NumberIdentifier of the project cost. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance.
Nested Schema : oracle_apps_projects_costing_transactions_flex_PjcExp_view_PJCDFFEXM__5FExpense__5FReportVO-item-response
Type:
Show Source
object-
__FLEX_Context: string
Title:
Context ValueMaximum Length:40Default Value:EXM_Expense_ReportName of the context for the segments of the standard cost collection flexfields of the project costs. -
__FLEX_Context_DisplayValue: string
Title:
Context ValueName of the context for the segments of the project expenditure items. -
_BILLABLE_FLAG: string
Title:
Billable -
_BILLABLE_FLAG_Display: string
Title:
Billable -
_CAPITALIZABLE_FLAG: string
Title:
Capitalizable -
_CAPITALIZABLE_FLAG_Display: string
Title:
Capitalizable -
_CONTRACT_ID: number
Title:
Contract Number -
_CONTRACT_ID_Display: string
Title:
Contract Number -
_EXPENDITURE_ITEM_DATE: string
(date)
Title:
Expenditure Item Date -
_EXPENDITURE_TYPE_ID: number
Title:
Expenditure Type -
_ORGANIZATION_ID: number
Title:
Expenditure Organization -
_ORGANIZATION_ID_Display: string
Title:
Expenditure Organization -
_PROJECT_ID: number
Title:
Project Number -
_PROJECT_ID_Display: string
Title:
Project Number -
_RESERVED_ATTRIBUTE1: string
Title:
Funding Source -
_RESERVED_ATTRIBUTE1_Display: string
Title:
Funding Source -
_TASK_ID: number
Title:
Task Number -
_TASK_ID_Display: string
Title:
Task Number -
_WORK_TYPE_ID: number
Title:
Work Type -
_WORK_TYPE_ID_Display: string
Title:
Work Type -
ExpenditureItemId: integer
(int64)
Title:
Transaction NumberIdentifier of the project cost. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance.
Nested Schema : oracle_apps_projects_costing_transactions_flex_PjcExp_view_PJCDFFEXM__5FExpense__5FReport__5FLineVO-item-response
Type:
Show Source
object-
__FLEX_Context: string
Title:
Context ValueMaximum Length:40Default Value:EXM_Expense_Report_LineName of the context for the segments of the standard cost collection flexfields of the project costs. -
__FLEX_Context_DisplayValue: string
Title:
Context ValueName of the context for the segments of the project expenditure items. -
_BILLABLE_FLAG: string
Title:
Billable -
_BILLABLE_FLAG_Display: string
Title:
Billable -
_CAPITALIZABLE_FLAG: string
Title:
Capitalizable -
_CAPITALIZABLE_FLAG_Display: string
Title:
Capitalizable -
_CONTRACT_ID: number
Title:
Contract Number -
_CONTRACT_ID_Display: string
Title:
Contract Number -
_EXPENDITURE_ITEM_DATE: string
(date)
Title:
Expenditure Item Date -
_EXPENDITURE_TYPE_ID: number
Title:
Expenditure Type -
_ORGANIZATION_ID: number
Title:
Expenditure Organization -
_ORGANIZATION_ID_Display: string
Title:
Expenditure Organization -
_PROJECT_ID: number
Title:
Project Number -
_PROJECT_ID_Display: string
Title:
Project Number -
_RESERVED_ATTRIBUTE1: string
Title:
Funding Source -
_RESERVED_ATTRIBUTE1_Display: string
Title:
Funding Source -
_TASK_ID: number
Title:
Task Number -
_TASK_ID_Display: string
Title:
Task Number -
_WORK_TYPE_ID: number
Title:
Work Type -
_WORK_TYPE_ID_Display: string
Title:
Work Type -
ExpenditureItemId: integer
(int64)
Title:
Transaction NumberIdentifier of the project cost. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance.
Nested Schema : oracle_apps_projects_costing_transactions_flex_PjcExp_view_PJCDFFINV__5FMisc__5FTransactionsVO-item-response
Type:
Show Source
object-
__FLEX_Context: string
Title:
Context ValueMaximum Length:40Default Value:INV_Misc_TransactionsName of the context for the segments of the standard cost collection flexfields of the project costs. -
__FLEX_Context_DisplayValue: string
Title:
Context ValueName of the context for the segments of the project expenditure items. -
_BILLABLE_FLAG: string
Title:
Billable -
_BILLABLE_FLAG_Display: string
Title:
Billable -
_CAPITALIZABLE_FLAG: string
Title:
Capitalizable -
_CAPITALIZABLE_FLAG_Display: string
Title:
Capitalizable -
_CONTRACT_ID: number
Title:
Contract Number -
_CONTRACT_ID_Display: string
Title:
Contract Number -
_EXPENDITURE_ITEM_DATE: string
(date)
Title:
Expenditure Item Date -
_EXPENDITURE_TYPE_ID: number
Title:
Expenditure Type -
_EXPENDITURE_TYPE_ID_Display: string
Title:
Expenditure Type -
_ORGANIZATION_ID: number
Title:
Expenditure Organization -
_ORGANIZATION_ID_Display: string
Title:
Expenditure Organization -
_PROJECT_ID: number
Title:
Project Number -
_PROJECT_ID_Display: string
Title:
Project Number -
_RESERVED_ATTRIBUTE1: string
Title:
Funding Source -
_RESERVED_ATTRIBUTE1_Display: string
Title:
Funding Source -
_TASK_ID: number
Title:
Task Number -
_TASK_ID_Display: string
Title:
Task Number -
_WORK_TYPE_ID: number
Title:
Work Type -
_WORK_TYPE_ID_Display: string
Title:
Work Type -
ExpenditureItemId: integer
(int64)
Title:
Transaction NumberIdentifier of the project cost. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance.
Nested Schema : oracle_apps_projects_costing_transactions_flex_PjcExp_view_PJCDFFOM__5FSales__5FOrderVO-item-response
Type:
Show Source
object-
__FLEX_Context: string
Title:
Context ValueMaximum Length:40Default Value:OM_Sales_OrderName of the context for the segments of the standard cost collection flexfields of the project costs. -
__FLEX_Context_DisplayValue: string
Title:
Context ValueName of the context for the segments of the project expenditure items. -
billableFlag: string
Title:
Billable -
billableFlag_Display: string
Title:
Billable -
capitalizableFlag: string
Title:
Capitalizable -
capitalizableFlag_Display: string
Title:
Capitalizable -
contractId: number
Title:
Contract Number -
contractId_Display: string
Title:
Contract Number -
expenditureItemDate: string
(date)
Title:
Expenditure Item Date -
ExpenditureItemId: integer
(int64)
Title:
Transaction NumberIdentifier of the project cost. -
expenditureTypeId: number
Title:
Expenditure Type -
expenditureTypeId_Display: string
Title:
Expenditure Type -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
organizationId: number
Title:
Expenditure Organization -
organizationId_Display: string
Title:
Expenditure Organization -
projectId: number
Title:
Project Number -
projectId_Display: string
Title:
Project Number -
reservedAttribute1: string
Title:
Funding Source -
reservedAttribute1_Display: string
Title:
Funding Source -
taskId: number
Title:
Task Number -
taskId_Display: string
Title:
Task Number -
workTypeId: number
Title:
Work Type -
workTypeId_Display: string
Title:
Work Type
Nested Schema : oracle_apps_projects_costing_transactions_flex_PjcExp_view_PJCDFFPJC__5FAllVO-item-response
Type:
Show Source
object-
__FLEX_Context: string
Title:
Context ValueMaximum Length:40Default Value:PJC_AllName of the context for the segments of the standard cost collection flexfields of the project costs. -
__FLEX_Context_DisplayValue: string
Title:
Context ValueName of the context for the segments of the project expenditure items. -
_BILLABLE_FLAG: string
Title:
Billable -
_BILLABLE_FLAG_DisplayValue: string
Title:
Billable -
_CAPITALIZABLE_FLAG: string
Title:
Capitalizable -
_CAPITALIZABLE_FLAG_DisplayValue: string
Title:
Capitalizable -
_CONTRACT_ID: number
Title:
Contract Number -
_CONTRACT_ID_Display: string
Title:
Contract Number -
_EXPENDITURE_ITEM_DATE: string
(date)
Title:
Expenditure Item Date -
_EXPENDITURE_TYPE_ID: number
Title:
Expenditure Type -
_EXPENDITURE_TYPE_ID_Display: string
Title:
Expenditure Type -
_ORGANIZATION_ID: number
Title:
Expenditure Organization -
_ORGANIZATION_ID_Display: string
Title:
Expenditure Organization -
_PROJECT_ID: number
Title:
Project Number -
_PROJECT_ID_Display: string
Title:
Project Number -
_RESERVED_ATTRIBUTE1: string
Title:
Funding Source -
_RESERVED_ATTRIBUTE1_Display: string
Title:
Funding Source -
_TASK_ID: number
Title:
Task Number -
_TASK_ID_Display: string
Title:
Task Number -
_WORK_TYPE_ID: number
Title:
Work Type -
_WORK_TYPE_ID_Display: string
Title:
Work Type -
ExpenditureItemId: integer
(int64)
Title:
Transaction NumberIdentifier of the project cost. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance.
Nested Schema : oracle_apps_projects_costing_transactions_flex_PjcExp_view_PJCDFFPJC__5FExpenditure__5FBatchVO-item-response
Type:
Show Source
object-
__FLEX_Context: string
Title:
Context ValueMaximum Length:40Default Value:PJC_Expenditure_BatchName of the context for the segments of the standard cost collection flexfields of the project costs. -
__FLEX_Context_DisplayValue: string
Title:
Context ValueName of the context for the segments of the project expenditure items. -
_BILLABLE_FLAG: string
Title:
Billable -
_BILLABLE_FLAG_Display: string
Title:
Billable -
_CAPITALIZABLE_FLAG: string
Title:
Capitalizable -
_CAPITALIZABLE_FLAG_Display: string
Title:
Capitalizable -
_CONTRACT_ID: number
Title:
Contract Number -
_CONTRACT_ID_Display: string
Title:
Contract Number -
_EXPENDITURE_ITEM_DATE: string
(date)
Title:
Expenditure Item Date -
_EXPENDITURE_TYPE_ID: number
Title:
Expenditure Type -
_EXPENDITURE_TYPE_ID_Display: string
Title:
Expenditure Type -
_ORGANIZATION_ID: number
Title:
Expenditure Organization -
_ORGANIZATION_ID_Display: string
Title:
Expenditure Organization -
_PROJECT_ID: number
Title:
Project Number -
_PROJECT_ID_Display: string
Title:
Project Number -
_RESERVED_ATTRIBUTE1: string
Title:
Funding Source -
_RESERVED_ATTRIBUTE1_Display: string
Title:
Funding Source -
_TASK_ID: number
Title:
Task Number -
_TASK_ID_Display: string
Title:
Task Number -
_WORK_TYPE_ID: number
Title:
Work Type -
_WORK_TYPE_ID_Display: string
Title:
Work Type -
ExpenditureItemId: integer
(int64)
Title:
Transaction NumberIdentifier of the project cost. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance.
Nested Schema : oracle_apps_projects_costing_transactions_flex_PjcExp_view_PJCDFFPOR__5FRequisitionVO-item-response
Type:
Show Source
object-
__FLEX_Context: string
Title:
Context ValueMaximum Length:40Default Value:POR_RequisitionName of the context for the segments of the standard cost collection flexfields of the project costs. -
__FLEX_Context_DisplayValue: string
Title:
Context ValueName of the context for the segments of the project expenditure items. -
_BILLABLE_FLAG: string
Title:
Billable -
_BILLABLE_FLAG_Display: string
Title:
Billable -
_CAPITALIZABLE_FLAG: string
Title:
Capitalizable -
_CAPITALIZABLE_FLAG_Display: string
Title:
Capitalizable -
_CONTRACT_ID: number
Title:
Contract Number -
_CONTRACT_ID_Display: string
Title:
Contract Number -
_EXPENDITURE_ITEM_DATE: string
(date)
Title:
Expenditure Item Date -
_EXPENDITURE_TYPE_ID: number
Title:
Expenditure Type -
_EXPENDITURE_TYPE_ID_Display: string
Title:
Expenditure Type -
_ORGANIZATION_ID: number
Title:
Expenditure Organization -
_ORGANIZATION_ID_Display: string
Title:
Expenditure Organization -
_PROJECT_ID: number
Title:
Project Number -
_PROJECT_ID_Display: string
Title:
Project Number -
_RESERVED_ATTRIBUTE1: string
Title:
Funding Source -
_RESERVED_ATTRIBUTE1_Display: string
Title:
Funding Source -
_TASK_ID: number
Title:
Task Number -
_TASK_ID_Display: string
Title:
Task Number -
_WORK_TYPE_ID: number
Title:
Work Type -
_WORK_TYPE_ID_Display: string
Title:
Work Type -
ExpenditureItemId: integer
(int64)
Title:
Transaction NumberIdentifier of the project cost. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance.
Nested Schema : oracle_apps_projects_costing_transactions_flex_PjcExp_view_PJCDFFPOR__5FUser__5FPreferencesVO-item-response
Type:
Show Source
object-
__FLEX_Context: string
Title:
Context ValueMaximum Length:40Default Value:POR_User_PreferencesName of the context for the segments of the standard cost collection flexfields of the project costs. -
__FLEX_Context_DisplayValue: string
Title:
Context ValueName of the context for the segments of the project expenditure items. -
_CONTRACT_ID: number
Title:
Contract Number -
_CONTRACT_ID_Display: string
Title:
Contract Number -
_EXPENDITURE_TYPE_ID: number
Title:
Expenditure Type -
_EXPENDITURE_TYPE_ID_Display: string
Title:
Expenditure Type -
_ORGANIZATION_ID: number
Title:
Expenditure Organization -
_ORGANIZATION_ID_Display: string
Title:
Expenditure Organization -
_PROJECT_ID: number
Title:
Project Number -
_PROJECT_ID_Display: string
Title:
Project Number -
_RESERVED_ATTRIBUTE1: string
Title:
Funding Source -
_RESERVED_ATTRIBUTE1_Display: string
Title:
Funding Source -
_TASK_ID: number
Title:
Task Number -
_TASK_ID_Display: string
Title:
Task Number -
ExpenditureItemId: integer
(int64)
Title:
Transaction NumberIdentifier of the project cost. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance.
Nested Schema : oracle_apps_projects_costing_transactions_flex_PjcExp_view_PJCDFFPO__5FPurchase__5FOrderVO-item-response
Type:
Show Source
object-
__FLEX_Context: string
Title:
Context ValueMaximum Length:40Default Value:PO_Purchase_OrderName of the context for the segments of the standard cost collection flexfields of the project costs. -
__FLEX_Context_DisplayValue: string
Title:
Context ValueName of the context for the segments of the project expenditure items. -
_BILLABLE_FLAG: string
Title:
Billable -
_BILLABLE_FLAG_Display: string
Title:
Billable -
_CAPITALIZABLE_FLAG: string
Title:
Capitalizable -
_CAPITALIZABLE_FLAG_Display: string
Title:
Capitalizable -
_CONTRACT_ID: number
Title:
Contract Number -
_CONTRACT_ID_Display: string
Title:
Contract Number -
_EXPENDITURE_ITEM_DATE: string
(date)
Title:
Expenditure Item Date -
_EXPENDITURE_TYPE_ID: number
Title:
Expenditure Type -
_EXPENDITURE_TYPE_ID_Display: string
Title:
Expenditure Type -
_ORGANIZATION_ID: number
Title:
Expenditure Organization -
_ORGANIZATION_ID_Display: string
Title:
Expenditure Organization -
_PROJECT_ID: number
Title:
Project Number -
_PROJECT_ID_Display: string
Title:
Project Number -
_RESERVED_ATTRIBUTE1: string
Title:
Funding Source -
_RESERVED_ATTRIBUTE1_Display: string
Title:
Funding Source -
_TASK_ID: number
Title:
Task Number -
_TASK_ID_Display: string
Title:
Task Number -
_WORK_TYPE_ID: number
Title:
Work Type -
_WORK_TYPE_ID_Display: string
Title:
Work Type -
ExpenditureItemId: integer
(int64)
Title:
Transaction NumberIdentifier of the project cost. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance.
Nested Schema : oracle_apps_projects_costing_transactions_flex_PjcExp_view_PJCDFFPO__5FPurchase__5FOrder__5FLineVO-item-response
Type:
Show Source
object-
__FLEX_Context: string
Title:
Context ValueMaximum Length:40Default Value:PO_Purchase_Order_LineName of the context for the segments of the standard cost collection flexfields of the project costs. -
__FLEX_Context_DisplayValue: string
Title:
Context ValueName of the context for the segments of the project expenditure items. -
_BILLABLE_FLAG: string
Title:
Billable -
_BILLABLE_FLAG_Display: string
Title:
Billable -
_CAPITALIZABLE_FLAG: string
Title:
Capitalizable -
_CAPITALIZABLE_FLAG_Display: string
Title:
Capitalizable -
_CONTRACT_ID: number
Title:
Contract Number -
_CONTRACT_ID_Display: string
Title:
Contract Number -
_EXPENDITURE_ITEM_DATE: string
(date)
Title:
Expenditure Item Date -
_EXPENDITURE_TYPE_ID: number
Title:
Expenditure Type -
_EXPENDITURE_TYPE_ID_Display: string
Title:
Expenditure Type -
_ORGANIZATION_ID: number
Title:
Expenditure Organization -
_ORGANIZATION_ID_Display: string
Title:
Expenditure Organization -
_PROJECT_ID: number
Title:
Project Number -
_PROJECT_ID_Display: string
Title:
Project Number -
_RESERVED_ATTRIBUTE1: string
Title:
Funding Source -
_RESERVED_ATTRIBUTE1_Display: string
Title:
Funding Source -
_TASK_ID: number
Title:
Task Number -
_TASK_ID_Display: string
Title:
Task Number -
_WORK_TYPE_ID: number
Title:
Work Type -
_WORK_TYPE_ID_Display: string
Title:
Work Type -
ExpenditureItemId: integer
(int64)
Title:
Transaction NumberIdentifier of the project cost. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance.
Nested Schema : oracle_apps_projects_costing_transactions_flex_PjcExp_view_PJCDFFPO__5FPurchase__5FOrder__5FScheduleVO-item-response
Type:
Show Source
object-
__FLEX_Context: string
Title:
Context ValueMaximum Length:40Default Value:PO_Purchase_Order_ScheduleName of the context for the segments of the standard cost collection flexfields of the project costs. -
__FLEX_Context_DisplayValue: string
Title:
Context ValueName of the context for the segments of the project expenditure items. -
_BILLABLE_FLAG: string
Title:
Billable -
_BILLABLE_FLAG_Display: string
Title:
Billable -
_CAPITALIZABLE_FLAG: string
Title:
Capitalizable -
_CAPITALIZABLE_FLAG_Display: string
Title:
Capitalizable -
_CONTRACT_ID: number
Title:
Contract Number -
_CONTRACT_ID_Display: string
Title:
Contract Number -
_EXPENDITURE_ITEM_DATE: string
(date)
Title:
Expenditure Item Date -
_EXPENDITURE_TYPE_ID: number
Title:
Expenditure Type -
_EXPENDITURE_TYPE_ID_Display: string
Title:
Expenditure Type -
_ORGANIZATION_ID: number
Title:
Expenditure Organization -
_ORGANIZATION_ID_Display: string
Title:
Expenditure Organization -
_PROJECT_ID: number
Title:
Project Number -
_PROJECT_ID_Display: string
Title:
Project Number -
_RESERVED_ATTRIBUTE1: string
Title:
Funding Source -
_RESERVED_ATTRIBUTE1_Display: string
Title:
Funding Source -
_TASK_ID: number
Title:
Task Number -
_TASK_ID_Display: string
Title:
Task Number -
_WORK_TYPE_ID: number
Title:
Work Type -
_WORK_TYPE_ID_Display: string
Title:
Work Type -
ExpenditureItemId: integer
(int64)
Title:
Transaction NumberIdentifier of the project cost. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance.
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Examples
The following example shows how to get all project costs by submitting a GET request on the REST resource using cURL.
curl --user ppm_cloud_user https://your_organization.com:port/fscmRestApi/resources/11.13.18.05/projectCosts
Response Body Example
The following shows an example of the response body in JSON format of the award budget period.
{
"items": [
{
"TransactionNumber": 7873694,
"BurdenedCostInProviderLedgerCurrency": 1500,
"ProviderLedgerCurrencyCode": "USD",
"ProviderLedgerCurrencyConversionRate": 1,
"ProviderLedgerCurrencyConversionDate": "2011-11-01",
"ProviderLedgerCurrencyConversionRateType": "100000013585009",
"RawCostInProviderLedgerCurrency": 1500,
"BillableFlag": true,
"FundsStatus": "RESERVED_NO_CONTROL_BUD",
"CapitalizableFlag": true,
"ContractId": 300100047724342,
"ConvertedFlag": null,
"CreatedBy": "ABRAHAM.MASON",
"CreationDate": "2019-06-17T10:28:22+00:00",
"BurdenedCostInTransactionCurrency": 1500,
"RawCostInTransactionCurrency": 1500,
"DocumentEntryId": 100010023900193,
"DocumentId": 100010023900192,
"ExpenditureItemDate": "2011-11-01",
"ExpenditureOrganizationId": 300100017216727,
"ExpenditureTypeId": 10001,
"AssignmentId": 300100026354770,
"LastUpdateDate": "2019-06-17T10:28:22+00:00",
"LastUpdatedBy": "ABRAHAM.MASON",
"NonlaborResourceId": null,
"NonlaborResourceOrganizationId": null,
"OriginalTransactionReference": "7686832",
"AccrualItemFlag": null,
"PersonType": "EMP",
"BurdenedCostInProjectCurrency": 1500,
"ProjectId": 300100043916612,
"RawCostInProjectCurrency": 1500,
"Quantity": 100,
"RawCostRateInTransactionCurrency": 15,
"FundingSourceId": "300100038787369",
"TaskId": 100100036066159,
"TransactionSourceId": 100010023900191,
"UnitOfMeasureCode": "HOURS",
"WorkTypeId": 10020,
"ExpenditureBusinessUnitId": 300100014554154,
"ExpenditureBusinessUnit": "Vision City Operations",
"TransactionSource": "PROJECTS",
"Document": "Time Card",
"DocumentEntry": "Straight Time",
"ProjectName": "GMS Dev Res Spons Project1",
"ProjectNumber": "GMS_DEV_RES_SP_P1",
"TaskName": "Diagnostic Test for Heart",
"TaskNumber": "1.1",
"ExpenditureType": "Airfare",
"ExpenditureCategory": "Expenses",
"ContractName": "GMS Dev Research Award 1",
"ContractNumber": "GMS_DEV_RES_A1",
"FundingSourceName": "Dept of Health and Human Services (DHHS)",
"FundingSourceNumber": "CDRM_70255",
"WorkType": "Commercial Customer-billable",
"PersonName": "phil Williams",
"PersonNumber": "955160008176132",
"PersonId": 300100026354758,
"Email": "prj_phil_williams_grp@oracle.com",
"AssignmentName": "Consultant",
"AssignmentNumber": "E955160008176132",
"Job": "Consultant",
"JobId": 300100007701744,
"UnitOfMeasure": "Hours",
"UserExpenditureBatch": "CDRM Entry",
"NonlaborResourceOrganization": null,
"Comment": null,
"ExternalBillRate": null,
"ExternalBillRateCurrency": null,
"ExternalBillRateSourceName": null,
"ExternalBillRateSourceReference": null,
"IntercompanyBillRate": null,
"IntercompanyBillRateCurrency": null,
"IntercompanyBillRateSourceName": null,
"IntercompanyBillRateSourceReference": null,
"TransactionCurrency": "US Dollar",
"TransferredFromTransactionNumber": 7686832,
"AdjustingItem": null,
"AllowAdjustments": "Y",
"RevenueCategoryCode": "Other",
"CapitalEventNumber": null,
"NetZeroItemFlag": null,
"ExpenditureTypeClass": "Straight Time",
"RawCostInReceiverLedgerCurrency": 1500,
"BurdenedCostInReceiverLedgerCurrency": 1500,
"InvoicedPercentage": null,
"IntercompanyInvoicedPercentage": null,
"IntercompanyInvoiceStatus": "U",
"InvoicedStatus": "U",
"HoldRevenueFlag": false,
"HoldIntercompanyRevenueFlag": false,
"IntercompanyInvoiceAmountInProviderLedgerCurrency": null,
"IntercompanyRevenueInProviderLedgerCurrency": null,
"InvoiceAmountInReceiverLedgerCurrency": null,
"RevenueInReceiverLedgerCurrency": null,
"RecognizedRevenuePercentage": null,
"IntercompanyRecognizedRevenuePercentage": null,
"TransferPriceInProviderLedgerCurrency": null,
"TransferPriceInTransactionCurrency": null,
"TransferPriceInProjectCurrency": null,
"TransferPriceInReceiverLedgerCurrency": null,
"HoldInvoiceFlag": false,
"HoldIntercompanyInvoiceFlag": false,
"IntercompanyRevenueStatus": "U",
"RevenueStatus": "U",
"ExpenditureTypeClassCode": "ST",
"AdjustmentStatus": null,
"ProviderOrganizationId": null,
"ReceiverOrganizationId": null,
"ProviderBusinessUnitId": 300100014554154,
"ReceiverBusinessUnitId": 300100014554154,
"ProviderLedgerCurrency": "US Dollar",
"NonlaborResource": null,
"AccountingDate": "2011-11-01",
"AccountingPeriod": "Nov-11",
"BurdenCostCreditAccountCombinationId": null,
"BurdenCostDebitAccountCombinationId": null,
"BurdenedCostCreditAccountCombinationId": null,
"BurdenedCostDebitAccountCombinationId": null,
"RawCostCreditAccountCombinationId": null,
"RawCostDebitAccountCombinationId": null,
"RawCostCreditAccount": null,
"BurdenCostCreditAccount": null,
"BurdenCostDebitAccount": null,
"BurdenedCostCreditAccount": null,
"BurdenedCostDebitAccount": null,
"RawCostDebitAccount": null,
"ExpenditureOrganization": "Vision City Maintenance",
"ProviderBusinessUnit": "Vision City Operations",
"ReceiverBusinessUnit": "Vision City Operations",
"ProviderOrganization": null,
"ReceiverOrganization": null,
"BorrowedAndLentDistributed": "Not applicable",
"CrossChargeType": null,
"BorrowedAndLentDistributedCode": "X",
"CrossChargeTypeCode": null
}
...
]
}