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" } ] }