Get all project contract revenues
get
/fscmRestApi/resources/11.13.18.05/projectContractRevenue
Request
Query Parameters
-
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 the project contract revenue with the specified primary key.
Finder Variables:- RevenueDistributionId; integer; Unique identifier of the revenue distribution.
- PrimaryKey: Finds the project contract revenue with the specified primary key.
-
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:- AssociatedTaskName; string; Name of the task that is linked to the contract line associated to the revenue distribution.
- AssociatedTaskNumber; string; A unique number that identifies the task in the task hierarchy that is at or above the level of the task recorded on the transaction and is associated with the contract for which revenue is recognized.
- BillJobId; integer; Unique identifier of the bill job used when recording revenue for a labor item.
- BillRate; number; Bill rate in the currency of the bill transaction.
- BillTransactionId; integer; Number that uniquely identifies a billing transaction that is the source of this revenue distribution.
- BillTransactionTypeCode; string; Indicates the code used to classify the type of bill transaction. Valid values are EI - Expenditure Item or EVT - Billing Event.
- BillingResource; string; This is the name of the Billing Resource for the billing event or expenditure item from the billing event or expenditure item.
- BillingResourceId; integer; Unique identifier of resource breakdown structure element.
- BillingTypeCode; string; Indicates the code used to identify which billing type of the contract the revenue distribution uses to recognize revenue. Valid values are EX - External, IC - Intercompany, IP - Interproject.
- BusinessUnit; string; Name of the business unit associated with the revenue distribution.
- BusinessUnitId; integer; Unique identifier of the business unit associated to the revenue distribution.
- ContCurrencyRevenueAmount; number; Indicates the amount in the contract currency.
- ContCurrencyRevenueExchgDate; string; Indicates the date used for the conversion of the rates on the contract used for the revenue distribution.
- ContCurrencyRevenueExchgRate; number; Indicates the rate used to convert the revenue distribution amounts from the transaction currency to the contract currency.
- ContCurrencyRevenueRateType; string; Indicates a classification of conversion rates used to convert the transaction amounts to the contract currency.
- ContractCurrencyCode; string; Indicates the code of the currency for the contract related to the revenue distribution.
- ContractId; integer; Unique identifier of the contract for the revenue distribution.
- ContractLineId; integer; Unique identifier of the contract line related to the revenue distribution.
- ContractLineNumber; string; Number that identifies the contract line related to the revenue distribution.
- ContractNumber; string; Number that uniquely identifies the contract for the revenue distribution.
- ContractRateDateType; string; Indicates the date type of the contract currency.
- DenomBurdenCost; number; Indicates the burdened cost in the ledger currency of the provider business unit for inter company revenue distributions.
- DenomRawCost; number; Indicates the raw cost of the transaction in the ledger currency of the provider business unit for inter company revenue distributions.
- DocumentNumber; string; Number that identifies a document on the revenue plan of a grants contract.
- EventNumber; integer; Number that identifies an event if the revenue distribution is based on a billing event.
- ExpenditureType; string; A classification of the expenditure type of the expenditure item that was recognized for revenue.
- GlDate; string; The date within a General Ledger (GL) accounting period to which the revenue transactions are posted.
- GlPeriodName; string; Name of the General Ledger (GL) period for the GL Date attribute.
- ICTpAmountTypeCode; string; Indicates the intercompany transfer price amount type of an intercompany transfer revenue distribution.
- ICTpBaseCode; string; Indicates the intercompany transfer price base code of an intercompany transfer revenue distribution.
- InvLaborRateTypeCode; string; Indicates the code of the type used to classify invoice method labor schedule as defined on the related bill plan.
- InvNlRateTypeCode; string; Indicates the invoice method for a nonlabor schedule type.
- InvoiceDate; string; Indicates the invoice date for the invoice related to the revenue distribution.
- LaborScheduleType; string; The type of labor schedule (namely bill rate, burden, or transfer price) from the revenue method used to determine revenue amounts on revenue distributions.
- LedgerCurrencyCode; string; The currency used for accounting and reporting in a ledger, often referred to as the accounting currency, base currency, or functional currency.
- LedgerCurrencyRevenueAmount; number; Indicates the revenue amount in the ledger currency.
- LedgerCurrencyRevenueExchgDate; string; Indicates the conversion date used to convert the revenue distribution to the ledger currency.
- LedgerCurrencyRevenueExchgRate; number; Indicates the conversion currency rate used to convert the revenue distribution to the ledger currency.
- LedgerCurrencyRevenueRateType; string; Indicates the conversion currency rate type used to convert the revenue distribution to the ledger currency.
- LedgerId; integer; Unique identifier of the ledger associated to the revenue distribution.
- LedgerRateDateType; string; Indicates the currency conversion date type used to convert the revenue distribution to the ledger currency.
- LineNumber; integer; A line identifier on a revenue distribution.
- LineNumberReversed; string; The line number of the original revenue distribution line being reversed by this revenue distribution line.
- LinkedProjectId; integer; Indicates the unique identifier of project that is linked to contract and related to the revenue distribution.
- LinkedTaskId; integer; Indicates the unique identifier of task that is linked to contract and related to the revenue distribution.
- LocNumber; string; Indicates the Letter of Credit Number when the revenue distribution is related to a grants contract bill plan.
- NonLaborOrgId; integer; Unique identifier for the organization related to nonlabor revenue distributions.
- NonLaborResourceId; integer; Unique identifier for the resource related to nonlabor revenue distributions.
- NonLaborScheduleType; string; The type of nonlabor schedule (namely bill rate, burden, or transfer price) from the revenue method used to determine revenue amounts on revenue distributions.
- PaDate; string; Indicates the date used for the project accounting.
- PaPeriodName; string; Indicates the period name used for the project accounting.
- PersonId; integer; Unique identifier of the Person related to the revenue distribution.
- ProjectCurrencyCode; string; Indicates the currency code of the project.
- ProjectCurrencyExchgDate; string; Indicates the currency conversion date used to convert the revenue distribution to the project currency.
- ProjectCurrencyExchgRate; number; Indicates the currency conversion rate used to convert the revenue distribution to the project currency.
- ProjectCurrencyRateType; string; Indicates the currency conversion rate type used to convert the revenue distribution to the project currency.
- ProjectCurrencyRevenueAmount; number; Indicates the amount of the revenue distribution in the currency of the project.
- ProjectLinkageId; integer; Unique identifier of the linkage used to identify the contract related to the revenue distribution.
- ProjectName; string; The name assigned to a project recorded on the unprocessed revenue event.
- ProjectNumber; string; Indicates the number for the project linked to the contract.
- ProjectRateDateType; string; Indicates the currency conversion date type used to convert the revenue distribution to the project currency.
- PrvdrLegalEntityId; integer; Unique identifier of the provider legal entity for intercompany revenue distributions.
- Quantity; number; Indicates the quantity of the source expenditure item for revenue distributions created from expenditure items.
- RecvrLegalEntityId; integer; Unique identifier of the receiver legal entity.
- RevenueAmountCalculationCode; string; Indicates the code for the revenue amount calculation. Valid values are I - Indirect, O - Overrides, E - Extension, B - Bill rates, L - Labor Multiplier.
- RevenueBurdenCompileSetId; integer; Unique identifier of the compiled set used to calculate a burden schedule.
- RevenueCategoryCode; string; Indicates the revenue category code for the revenue distribution.
- RevenueCategoryMeaning; string; Indicates the meaning of the Revenue Category Code attribute that represents a grouping of expenditure types by type of revenue. For example, a revenue category with a name such as Labor refers to labor revenue.
- RevenueCurrencyAmount; number; Indicates the revenue amount in the currency of the revenue distribution.
- RevenueCurrencyCode; string; Indicates the code for the currency of the revenue distribution.
- RevenueCurrencyConvType; string; The source of a currency conversion rate type, such as user defined, spot, or corporate, used to convert revenue amount from bill transaction currency into revenue currency.
- RevenueCurrencyDateType; string; The revenue currency conversion date type used to calculate the revenue currency.
- RevenueCurrencyExchgDate; string; The currency conversion exchange date used to calculate the revenue currency.
- RevenueCurrencyExchgRate; number; The source of a currency conversion rate, such as user defined, spot, or corporate, used to convert revenue amount from bill transaction currency into revenue currency.
- RevenueCurrencyRateType; string; The source of a currency conversion rate type, such as user defined, spot, or corporate, used to convert revenue amount from bill transaction currency into revenue currency.
- RevenueDiscountPercentage; number; Indicates a discount percentage, expressed as a proportion multiplied by 100, that is used to calculate the adjusted revenue and rate.
- RevenueDiscountReasonCode; string; Reason code for discount override or rate override.
- RevenueDistributionId; integer; Unique identifier of the revenue distribution.
- RevenueIncrementalPercentage; number; Indicates the incremental percentage the revenue distribution.
- RevenueLaborMultiplier; number; A multiplier that is assigned to a contract line, and is used to calculate the revenue amount for labor items by applying the multiplier to the raw cost of the labor items.
- RevenueLaborRateTypeCode; string; Indicates the code of the type used to classify revenue labor rates.
- RevenueNlRateTypeCode; string; Indicates the code for the revenue nonlabor rate type.
- RevenuePlanId; integer; Unique identifier of the revenue plan.
- RevenueRateSourceId; integer; Unique identifier of the revenue rate source used for bill rate derivation. It stores the rate schedule id of bill rate schedule was used, or the override id if override used.
- RevenueRateSourceTypeCode; string; Indicates the code of the type used to classify the revenue rate sources.
- RevenueRecognized; string; Indicates if the expenditure item or event is partially or fully recognized.
- Reversed; string; Indicates whether this revenue distribution was reversed.
- ReversedRevenueDistributionId; integer; Unique identifier of the reversed revenue distribution if the revenue distribution is a reversal distribution.
- SlaEventId; integer; The system-generated number assigned to a subledger accounting event. You create accounting events for transactions that have a financial accounting impact.
- TaskName; string; Indicates the name of the task for which the revenue distribution applies.
- TaskNumber; string; The number assigned to a task associated with a contract line.
- TpBaseAmount; number; Indicates the basis amount for the transfer price calculation from the transfer price rule used to create an intercompany revenue distribution.
- TpRevenueRulePercentage; number; Indicates the applied percentage value from the transfer price rule used to create an intercompany revenue distribution.
- TpRevenueSchLinePercentage; number; Indicates the applied percentage value from the transfer price schedule line used to create an intercompany revenue distribution.
- TransactionCurrencyCode; string; Indicates the code of the currency used to bill transactions. The bill transaction currency for expenditure items is the bill rate currency if a bill rate schedule is used to derive rates. If a burden rate schedule is used to derive rates, the bill transaction currency is the cost transaction currency.
- TransactionCurrencyRevenueAmount; number; The amount of revenue in bill transaction currency.
- TransactionDate; string; Indicates the expenditure item or event date when transaction occurs for this revenue
- TransactionId; integer; Unique identifier of the expenditure item or event that is revenue distributed by the distribution line.
- TransactionProjectId; integer; Unique identifier of project for the revenue distribution.
- TransactionTaskId; integer; Unique identifier of transaction task for the revenue distribution.
- TransactionType; string; Indicates whether the transaction that created a revenue distribution is an expenditure item or an event. Valid values include Expenditure Item or Event.
- TransactionTypeId; integer; Unique identifier of Event Type or Expenditure Item Type for the revenue distribution.
- Version; integer; Version number of contract when the revenue distribution was created.
-
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
-
Metadata-Context: string
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: string
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 : projectContractRevenue
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 : projectContractRevenue-item-response
Type:
Show Source
object-
AssociatedTaskName: string
Title:
Associated Task NameRead Only:trueMaximum Length:255Name of the task that is linked to the contract line associated to the revenue distribution. -
AssociatedTaskNumber: string
Title:
Associated Task NumberRead Only:trueMaximum Length:100A unique number that identifies the task in the task hierarchy that is at or above the level of the task recorded on the transaction and is associated with the contract for which revenue is recognized. -
BillingResource: string
Title:
Billing ResourceRead Only:trueMaximum Length:240This is the name of the Billing Resource for the billing event or expenditure item from the billing event or expenditure item. -
BillingResourceId: integer
(int64)
Title:
Billing Resource IDRead Only:trueUnique identifier of resource breakdown structure element. -
BillingTypeCode: string
Title:
Billing Type CodeRead Only:trueMaximum Length:30Indicates the code used to identify which billing type of the contract the revenue distribution uses to recognize revenue. Valid values are EX - External, IC - Intercompany, IP - Interproject. -
BillJobId: integer
(int64)
Title:
Bill Job IDRead Only:trueUnique identifier of the bill job used when recording revenue for a labor item. -
BillRate: number
Title:
Bill Rate in Bill Transaction CurrencyRead Only:trueBill rate in the currency of the bill transaction. -
BillTransactionId: integer
(int64)
Title:
Bill Transaction NumberRead Only:trueNumber that uniquely identifies a billing transaction that is the source of this revenue distribution. -
BillTransactionTypeCode: string
Title:
Bill Transaction Type CodeRead Only:trueMaximum Length:30Indicates the code used to classify the type of bill transaction. Valid values are EI - Expenditure Item or EVT - Billing Event. -
BusinessUnit: string
Title:
Business UnitRead Only:trueMaximum Length:240Name of the business unit associated with the revenue distribution. -
BusinessUnitId: integer
(int64)
Title:
Business Unit IDRead Only:trueUnique identifier of the business unit associated to the revenue distribution. -
ContCurrencyRevenueAmount: number
Title:
Revenue in Contract CurrencyRead Only:trueIndicates the amount in the contract currency. -
ContCurrencyRevenueExchgDate: string
(date)
Title:
Contract Currency Conversion DateRead Only:trueIndicates the date used for the conversion of the rates on the contract used for the revenue distribution. -
ContCurrencyRevenueExchgRate: number
Title:
Contract Currency Conversion RateRead Only:trueIndicates the rate used to convert the revenue distribution amounts from the transaction currency to the contract currency. -
ContCurrencyRevenueRateType: string
Title:
Contract Currency Conversion Rate TypeRead Only:trueMaximum Length:30Indicates a classification of conversion rates used to convert the transaction amounts to the contract currency. -
ContractCurrencyCode: string
Title:
Contract CurrencyRead Only:trueMaximum Length:30Indicates the code of the currency for the contract related to the revenue distribution. -
ContractId: integer
(int64)
Title:
Contract IDRead Only:trueUnique identifier of the contract for the revenue distribution. -
ContractLineId: integer
(int64)
Title:
Contract Line IDRead Only:trueUnique identifier of the contract line related to the revenue distribution. -
ContractLineNumber: string
Title:
Contract Line NumberRead Only:trueMaximum Length:150Number that identifies the contract line related to the revenue distribution. -
ContractNumber: string
Title:
Contract NumberRead Only:trueMaximum Length:120Number that uniquely identifies the contract for the revenue distribution. -
ContractRateDateType: string
Title:
Contract Currency Conversion Date TypeRead Only:trueMaximum Length:30Indicates the date type of the contract currency. -
DenomBurdenCost: number
Title:
Burdened Cost Amount in Bill Transaction CurrencyRead Only:trueIndicates the burdened cost in the ledger currency of the provider business unit for inter company revenue distributions. -
DenomRawCost: number
Title:
Raw Cost Amount in Bill Transaction CurrencyRead Only:trueIndicates the raw cost of the transaction in the ledger currency of the provider business unit for inter company revenue distributions. -
DocumentNumber: string
Title:
Document NumberRead Only:trueMaximum Length:240Number that identifies a document on the revenue plan of a grants contract. -
EventNumber: integer
(int64)
Title:
Event NumberRead Only:trueNumber that identifies an event if the revenue distribution is based on a billing event. -
ExpenditureType: string
Title:
Expenditure Type ClassRead Only:trueMaximum Length:80A classification of the expenditure type of the expenditure item that was recognized for revenue. -
GlDate: string
(date)
Title:
Accounting DateRead Only:trueThe date within a General Ledger (GL) accounting period to which the revenue transactions are posted. -
GlPeriodName: string
Title:
Accounting PeriodRead Only:trueMaximum Length:30Name of the General Ledger (GL) period for the GL Date attribute. -
ICTpAmountTypeCode: string
Title:
Intercompany Transfer Price Amount TypeRead Only:trueMaximum Length:30Indicates the intercompany transfer price amount type of an intercompany transfer revenue distribution. -
ICTpBaseCode: string
Title:
Intercompany Transfer Price BaseRead Only:trueMaximum Length:30Indicates the intercompany transfer price base code of an intercompany transfer revenue distribution. -
InvLaborRateTypeCode: string
Title:
Invoice Method Labor Schedule TypeRead Only:trueMaximum Length:30Indicates the code of the type used to classify invoice method labor schedule as defined on the related bill plan. -
InvNlRateTypeCode: string
Title:
Invoice Method Nonlabor Schedule TypeRead Only:trueMaximum Length:30Indicates the invoice method for a nonlabor schedule type. -
InvoiceDate: string
(date)
Title:
Invoice DateRead Only:trueIndicates the invoice date for the invoice related to the revenue distribution. -
LaborScheduleType: string
Title:
Revenue Method Labor Schedule TypeRead Only:trueMaximum Length:80The type of labor schedule (namely bill rate, burden, or transfer price) from the revenue method used to determine revenue amounts on revenue distributions. -
LedgerCurrencyCode: string
Title:
Ledger CurrencyRead Only:trueMaximum Length:30The currency used for accounting and reporting in a ledger, often referred to as the accounting currency, base currency, or functional currency. -
LedgerCurrencyRevenueAmount: number
Title:
Revenue in Ledger CurrencyRead Only:trueIndicates the revenue amount in the ledger currency. -
LedgerCurrencyRevenueExchgDate: string
(date)
Title:
Ledger Currency Conversion DateRead Only:trueIndicates the conversion date used to convert the revenue distribution to the ledger currency. -
LedgerCurrencyRevenueExchgRate: number
Title:
Ledger Currency Conversion RateRead Only:trueIndicates the conversion currency rate used to convert the revenue distribution to the ledger currency. -
LedgerCurrencyRevenueRateType: string
Title:
Ledger Currency Conversion Rate TypeRead Only:trueMaximum Length:30Indicates the conversion currency rate type used to convert the revenue distribution to the ledger currency. -
LedgerId: integer
(int64)
Title:
Ledger IDRead Only:trueUnique identifier of the ledger associated to the revenue distribution. -
LedgerRateDateType: string
Title:
Ledger Currency Conversion Date TypeRead Only:trueMaximum Length:30Indicates the currency conversion date type used to convert the revenue distribution to the ledger currency. -
LineNumber: integer
(int64)
Title:
Line NumberRead Only:trueA line identifier on a revenue distribution. -
LineNumberReversed: string
Title:
Line Number ReversedRead Only:trueMaximum Length:20The line number of the original revenue distribution line being reversed by this revenue distribution line. -
LinkedProjectId: integer
(int64)
Title:
Associated Project IDRead Only:trueIndicates the unique identifier of project that is linked to contract and related to the revenue distribution. -
LinkedTaskId: integer
(int64)
Title:
Linked Task IDRead Only:trueIndicates the unique identifier of task that is linked to contract and related to the revenue distribution. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
LocNumber: string
Title:
LOC NumberRead Only:trueMaximum Length:240Indicates the Letter of Credit Number when the revenue distribution is related to a grants contract bill plan. -
NonLaborOrgId: integer
(int64)
Title:
Nonlabor Organization IDRead Only:trueUnique identifier for the organization related to nonlabor revenue distributions. -
NonLaborResourceId: integer
(int64)
Title:
Nonlabor Resource IDRead Only:trueUnique identifier for the resource related to nonlabor revenue distributions. -
NonLaborScheduleType: string
Title:
Revenue Method Nonlabor Schedule TypeRead Only:trueMaximum Length:80The type of nonlabor schedule (namely bill rate, burden, or transfer price) from the revenue method used to determine revenue amounts on revenue distributions. -
PaDate: string
(date)
Title:
Project Accounting DateRead Only:trueIndicates the date used for the project accounting. -
PaPeriodName: string
Title:
Project Accounting PeriodRead Only:trueMaximum Length:30Indicates the period name used for the project accounting. -
PersonId: integer
(int64)
Title:
Person IDRead Only:trueUnique identifier of the Person related to the revenue distribution. -
ProjectCurrencyCode: string
Title:
Project CurrencyRead Only:trueMaximum Length:30Indicates the currency code of the project. -
ProjectCurrencyExchgDate: string
(date)
Title:
Project Currency Conversion DateRead Only:trueIndicates the currency conversion date used to convert the revenue distribution to the project currency. -
ProjectCurrencyExchgRate: number
Title:
Project Currency Conversion RateRead Only:trueIndicates the currency conversion rate used to convert the revenue distribution to the project currency. -
ProjectCurrencyRateType: string
Title:
Project Currency Rate TypeRead Only:trueMaximum Length:30Indicates the currency conversion rate type used to convert the revenue distribution to the project currency. -
ProjectCurrencyRevenueAmount: number
Title:
Revenue in Project CurrencyRead Only:trueIndicates the amount of the revenue distribution in the currency of the project. -
ProjectLinkageId: integer
(int64)
Title:
Project Linkage IDRead Only:trueUnique identifier of the linkage used to identify the contract related to the revenue distribution. -
ProjectName: string
Title:
Project NameRead Only:trueMaximum Length:240The name assigned to a project recorded on the unprocessed revenue event. -
ProjectNumber: string
Title:
Project NumberRead Only:trueMaximum Length:25Indicates the number for the project linked to the contract. -
ProjectRateDateType: string
Title:
Project Currency Conversion Date TypeRead Only:trueMaximum Length:30Indicates the currency conversion date type used to convert the revenue distribution to the project currency. -
PrvdrLegalEntityId: integer
(int64)
Title:
Provider Legal Entity IDRead Only:trueUnique identifier of the provider legal entity for intercompany revenue distributions. -
Quantity: number
Title:
QuantityRead Only:trueIndicates the quantity of the source expenditure item for revenue distributions created from expenditure items. -
RecvrLegalEntityId: integer
(int64)
Title:
Receiver Legal Entity IDRead Only:trueUnique identifier of the receiver legal entity. -
RevenueAmountCalculationCode: string
Title:
Revenue Amount Calculation CodeRead Only:trueMaximum Length:30Indicates the code for the revenue amount calculation. Valid values are I - Indirect, O - Overrides, E - Extension, B - Bill rates, L - Labor Multiplier. -
RevenueBurdenCompileSetId: integer
(int64)
Title:
Revenue Burden Compile Set IDRead Only:trueUnique identifier of the compiled set used to calculate a burden schedule. -
RevenueCategoryCode: string
Title:
Revenue Category CodeRead Only:trueMaximum Length:30Indicates the revenue category code for the revenue distribution. -
RevenueCategoryMeaning: string
Title:
Revenue CategoryRead Only:trueMaximum Length:80Indicates the meaning of the Revenue Category Code attribute that represents a grouping of expenditure types by type of revenue. For example, a revenue category with a name such as Labor refers to labor revenue. -
RevenueCurrencyAmount: number
Title:
Revenue in Revenue CurrencyRead Only:trueIndicates the revenue amount in the currency of the revenue distribution. -
RevenueCurrencyCode: string
Title:
Revenue CurrencyRead Only:trueMaximum Length:30Indicates the code for the currency of the revenue distribution. -
RevenueCurrencyConvType: string
Title:
Revenue Currency Conversion Rate TypeRead Only:trueMaximum Length:30The source of a currency conversion rate type, such as user defined, spot, or corporate, used to convert revenue amount from bill transaction currency into revenue currency. -
RevenueCurrencyDateType: string
Title:
Revenue Currency Conversion Date TypeRead Only:trueMaximum Length:30The revenue currency conversion date type used to calculate the revenue currency. -
RevenueCurrencyExchgDate: string
(date)
Title:
Revenue Currency Conversion DateRead Only:trueThe currency conversion exchange date used to calculate the revenue currency. -
RevenueCurrencyExchgRate: number
Title:
Revenue Currency Conversion RateRead Only:trueThe source of a currency conversion rate, such as user defined, spot, or corporate, used to convert revenue amount from bill transaction currency into revenue currency. -
RevenueCurrencyRateType: string
Title:
Revenue Currency Conversion Rate TypeRead Only:trueMaximum Length:30The source of a currency conversion rate type, such as user defined, spot, or corporate, used to convert revenue amount from bill transaction currency into revenue currency. -
RevenueDiscountPercentage: number
Title:
Discount PercentageRead Only:trueIndicates a discount percentage, expressed as a proportion multiplied by 100, that is used to calculate the adjusted revenue and rate. -
RevenueDiscountReasonCode: string
Title:
Revenue Discount Reason CodeRead Only:trueMaximum Length:30Reason code for discount override or rate override. -
RevenueDistributionId: integer
(int64)
Title:
Revenue Distribution NumberRead Only:trueUnique identifier of the revenue distribution. -
RevenueIncrementalPercentage: number
Title:
Revenue Incremental PercentageRead Only:trueIndicates the incremental percentage the revenue distribution. -
RevenueLaborMultiplier: number
Title:
Labor MultiplierRead Only:trueA multiplier that is assigned to a contract line, and is used to calculate the revenue amount for labor items by applying the multiplier to the raw cost of the labor items. -
RevenueLaborRateTypeCode: string
Title:
Revenue Labor Rate Type CodeRead Only:trueMaximum Length:30Indicates the code of the type used to classify revenue labor rates. -
RevenueNlRateTypeCode: string
Title:
Revenue Nonlabor Rate Type CodeRead Only:trueMaximum Length:30Indicates the code for the revenue nonlabor rate type. -
RevenuePlanId: integer
(int64)
Title:
Revenue Plan IDRead Only:trueUnique identifier of the revenue plan. -
RevenueRateSourceId: integer
(int64)
Title:
Revenue Rate Source IDRead Only:trueUnique identifier of the revenue rate source used for bill rate derivation. It stores the rate schedule id of bill rate schedule was used, or the override id if override used. -
RevenueRateSourceTypeCode: string
Title:
Revenue Rate Source Type CodeRead Only:trueMaximum Length:30Indicates the code of the type used to classify the revenue rate sources. -
RevenueRecognized: string
Title:
Revenue RecognizedRead Only:trueMaximum Length:1Indicates if the expenditure item or event is partially or fully recognized. -
Reversed: string
Title:
ReversedRead Only:trueMaximum Length:1Indicates whether this revenue distribution was reversed. -
ReversedRevenueDistributionId: integer
(int64)
Title:
Reversed Distribution NumberRead Only:trueUnique identifier of the reversed revenue distribution if the revenue distribution is a reversal distribution. -
SlaEventId: integer
(int64)
Title:
Subledger Accounting Event IDRead Only:trueThe system-generated number assigned to a subledger accounting event. You create accounting events for transactions that have a financial accounting impact. -
TaskName: string
Title:
Task NameRead Only:trueMaximum Length:255Indicates the name of the task for which the revenue distribution applies. -
TaskNumber: string
Title:
Task NumberRead Only:trueMaximum Length:100The number assigned to a task associated with a contract line. -
TpBaseAmount: number
Title:
Transfer Price Base AmountRead Only:trueIndicates the basis amount for the transfer price calculation from the transfer price rule used to create an intercompany revenue distribution. -
TpRevenueRulePercentage: number
Title:
Transfer Price Revenue Rule PercentageRead Only:trueIndicates the applied percentage value from the transfer price rule used to create an intercompany revenue distribution. -
TpRevenueSchLinePercentage: number
Title:
Transfer Price Revenue Schedule Line PercentageRead Only:trueIndicates the applied percentage value from the transfer price schedule line used to create an intercompany revenue distribution. -
TransactionCurrencyCode: string
Title:
Bill Transaction CurrencyRead Only:trueMaximum Length:30Indicates the code of the currency used to bill transactions. The bill transaction currency for expenditure items is the bill rate currency if a bill rate schedule is used to derive rates. If a burden rate schedule is used to derive rates, the bill transaction currency is the cost transaction currency. -
TransactionCurrencyRevenueAmount: number
Title:
Revenue in Bill Transaction CurrencyRead Only:trueThe amount of revenue in bill transaction currency. -
TransactionDate: string
(date)
Title:
Transaction DateRead Only:trueIndicates the expenditure item or event date when transaction occurs for this revenue -
TransactionId: integer
(int64)
Title:
Transaction IDRead Only:trueUnique identifier of the expenditure item or event that is revenue distributed by the distribution line. -
TransactionProjectId: integer
(int64)
Title:
Transaction Project IDRead Only:trueUnique identifier of project for the revenue distribution. -
TransactionTaskId: integer
(int64)
Title:
Transaction Task IDRead Only:trueUnique identifier of transaction task for the revenue distribution. -
TransactionType: string
Title:
Transaction TypeRead Only:trueMaximum Length:80Indicates whether the transaction that created a revenue distribution is an expenditure item or an event. Valid values include Expenditure Item or Event. -
TransactionTypeId: integer
(int64)
Title:
Transaction Type IDRead Only:trueUnique identifier of Event Type or Expenditure Item Type for the revenue distribution. -
Version: integer
(int64)
Title:
VersionRead Only:trueVersion number of contract when the revenue distribution was created.
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.
Examples
Example 1
The following example shows how to get all project contract revenues with a specific set of attributes by submitting a GET request on the REST resource using cURL.
Note:
It's recommended that you only select the required attributes to achieve better performance.curl --user ppm_cloud_user https://your_organization.com:port/fscmRestApi/resources/11.13.18.05/projectContractRevenue?fields=BusinessUnit,ContractNumber,ContractLineNumber,ProjectName,ProjectNumber,TaskNumber,TaskName,BillTransactionTypeCode,TransactionId,ContCurrencyRevenueAmount,ContractCurrencyCode,TransactionDate,LedgerCurrencyRevenueAmount,LedgerCurrencyCode
Example 1 Response Body
The following shows an example of the response body in JSON format.
{
"items": [
{
"BusinessUnit": "Vision Operations",
"ContractNumber": "zBI_revcon6",
"ContractLineNumber": "Line1",
"ProjectName": "zBI_Projrev-06",
"ProjectNumber": "zBI_Projrev-06",
"TaskNumber": "4.3.4",
"TaskName": "Application Setup Phase 2",
"BillTransactionTypeCode": "EVT",
"TransactionId": 100000016853649,
"ContCurrencyRevenueAmount": 5000,
"ContractCurrencyCode": "USD",
"TransactionDate": "2010-04-01",
"LedgerCurrencyRevenueAmount": 5000,
"LedgerCurrencyCode": "USD",
"links": [
{
"rel": "self",
"href": "https://your_organization:port/fscmRestApi/resources/11.13.18.05/projectContractRevenue/100010033111687",
"name": "projectContractRevenue",
"kind": "item"
},
{
"rel": "canonical",
"href": "https://your_organization:port/fscmRestApi/resources/11.13.18.05/projectContractRevenue/100010033111687",
"name": "projectContractRevenue",
"kind": "item"
}
]
},
{
"BusinessUnit": "Vision Operations",
"ContractNumber": "PJB_VOL_Contract",
"ContractLineNumber": "1",
"ProjectName": "PJB_VOL_Project",
"ProjectNumber": "PJB_VOL_Project",
"TaskNumber": "1.1",
"TaskName": "Project Kickoff",
"BillTransactionTypeCode": "EI",
"TransactionId": 7687222,
"ContCurrencyRevenueAmount": 400,
"ContractCurrencyCode": "USD",
"TransactionDate": "2011-04-24",
"LedgerCurrencyRevenueAmount": 400,
"LedgerCurrencyCode": "USD",
"links": [
{
"rel": "self",
"href": "https://your_organization:port/fscmRestApi/resources/11.13.18.05/projectContractRevenue/100100037705976",
"name": "projectContractRevenue",
"kind": "item"
},
{
"rel": "canonical",
"href": "https://your_organization:port/fscmRestApi/resources/11.13.18.05/projectContractRevenue/100100037705976",
"name": "projectContractRevenue",
"kind": "item"
}
]
}
],
"count": 25,
"hasMore": true,
"limit": 25,
"offset": 0,
"links": [
{
"rel": "self",
"href": "https://your_organization:port/fscmRestApi/resources/11.13.18.05/projectContractRevenue",
"name": "projectContractRevenue",
"kind": "collection"
}
]
}Example 2
The following example shows how to get all burden schedules 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/projectContractRevenue
Example 2 Response Body
The following example shows the contents of the response body in JSON format.
{
"items": [
{
"RevenueDistributionId": 100010033099998,
"BusinessUnit": "Vision Corporation",
"ContractNumber": "zBI_revcon2",
"ContractLineNumber": "Line1",
"ProjectName": "zBI_Projrev-02",
"ProjectNumber": "zBI_Projrev-02",
"AssociatedTaskName": null,
"AssociatedTaskNumber": null,
"TaskNumber": "1.1",
"TaskName": "Project Kickoff",
"EventNumber": null,
"ContractLineId": 100000015235306,
"ContractId": 100000015235298,
"BillTransactionTypeCode": "EI",
"BillJobId": 29,
"BillRate": 50,
"BillTransactionId": 100010033099999,
"BillingTypeCode": "EX",
"ContCurrencyRevenueExchgDate": null,
"ContCurrencyRevenueExchgRate": 1,
"ContCurrencyRevenueRateType": null,
"ContCurrencyRevenueAmount": 2500,
"ContractCurrencyCode": "USD",
"ProjectLinkageId": 100000015235308,
"ContractRateDateType": "TRANSACTION",
"DenomBurdenCost": 1725,
"DenomRawCost": 1250,
"DocumentNumber": null,
"GlDate": "2010-03-25",
"GlPeriodName": "Mar-10",
"ICTpAmountTypeCode": null,
"ICTpBaseCode": null,
"InvLaborRateTypeCode": null,
"InvNlRateTypeCode": null,
"InvoiceDate": null,
"LedgerCurrencyRevenueExchgDate": null,
"LedgerCurrencyRevenueExchgRate": 1,
"LedgerCurrencyRevenueRateType": null,
"LedgerCurrencyRevenueAmount": 2500,
"LedgerCurrencyCode": "USD",
"LedgerId": 1,
"LedgerRateDateType": "TRANSACTION",
"LineNumber": 1,
"LineNumberReversed": null,
"LinkedProjectId": 100000015136283,
"LinkedTaskId": null,
"Version": 1,
"LocNumber": null,
"NonLaborOrgId": null,
"NonLaborResourceId": null,
"BusinessUnitId": 204,
"PaDate": "2010-03-25",
"PaPeriodName": "MAR-W4-10",
"PersonId": 4384,
"ProjectCurrencyExchgRate": 1,
"ProjectCurrencyRateType": null,
"ProjectCurrencyRevenueAmount": 2500,
"ProjectCurrencyCode": "USD",
"ProjectCurrencyExchgDate": null,
"ProjectRateDateType": null,
"PrvdrLegalEntityId": 204,
"Quantity": 50,
"BillingResourceId": 100010023981323,
"RecvrLegalEntityId": 204,
"RevenueBurdenCompileSetId": null,
"RevenueDiscountReasonCode": null,
"RevenueIncrementalPercentage": 100,
"RevenueLaborRateTypeCode": "BILL_RATE",
"RevenueNlRateTypeCode": "BILL_RATE",
"RevenueRateSourceTypeCode": null,
"RevenueAmountCalculationCode": "B",
"RevenueCategoryCode": "Labor",
"RevenueCurrencyAmount": 2500,
"RevenueCurrencyDateType": "TRANSACTION",
"RevenueCurrencyExchgDate": null,
"RevenueCurrencyExchgRate": 1,
"RevenueCurrencyRateType": null,
"RevenueCurrencyCode": "USD",
"RevenueDiscountPercentage": null,
"RevenueLaborMultiplier": null,
"RevenuePlanId": 100000015235305,
"RevenueRateSourceId": 100000010146226,
"RevenueRecognized": "F",
"Reversed": null,
"ReversedRevenueDistributionId": null,
"SlaEventId": null,
"TpBaseAmount": null,
"TpRevenueRulePercentage": null,
"TpRevenueSchLinePercentage": null,
"TransactionTypeId": 10009,
"TransactionDate": "2010-03-25",
"TransactionId": 7680619,
"TransactionProjectId": 100000015136283,
"TransactionTaskId": 100000015136315,
"TransactionCurrencyRevenueAmount": 2500,
"TransactionCurrencyCode": "USD",
"RevenueCategoryMeaning": "Labor",
"ExpenditureType": "Straight Time",
"TransactionType": "Expenditure item",
"LaborScheduleType": "Bill rate",
"NonLaborScheduleType": "Bill rate",
"RevenueCurrencyConvType": null,
"BillingResource": "Labor"
}
]
}