Get all project commitments

get

/fscmRestApi/resources/11.13.18.05/projectCommitments

Request

Query Parameters
  • 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
  • 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).
  • 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
  • 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 commitments with the specified commitment ID.
      Finder Variables:
      • CommitmentId; integer; Unique identifier of the commitment transaction.
    • findProjectCommitmentbyTypeStatusAndDateRange: Finds all project commitment transactions with the specified source, type, and status for a range of expenditure item dates.
      Finder Variables:
      • ApprovedFlag; boolean; Identifies if the commitment transaction is approved or not in the source application. A value of true means that the project commitment is in approved status and a value of false means that the project commitment is not in approved status.
      • CommitmentSourceType; string; Identifies the commitment transaction as either internal or external. A list of accepted values - Internal, External, or All - is defined in the lookup type PJC_COMMITMENT_TYPE.
      • CommitmentType; string; Identifies the commitment transaction as either purchase requisition, purchase order, supplier invoice, or external. A list of accepted values is defined in the lookup type PJC_CMT_LINE_TYPE.
      • ExpenditureItemDate; string; Date on which the commitment cost was incurred.
      • ProcessingStatus; string; Identifies the commitment transaction as either unprocessed, processed, or error. A list of accepted values - Processed, Unprocessed, or Error - is defined in the lookup type PJC_CMT_PROCESSING_STATUS.
      • ProjectName; string; Name of the project to which the commitment cost is charged.
      • SysEffectiveDate; object.
  • 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.
  • 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
  • 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.
  • The resource item payload will be filtered in order to contain only data (no links section, for example).
  • 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
  • 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:
    • ApprovedFlag; boolean; Identifies if the commitment transaction is approved or not in the source application. A value of true means that the project commitment is in approved status and a value of false means that the project commitment is not in approved status.
    • AwardBudgetPeriod; string; Interval of time (usually twelve months) into which the duration of an award project is divided for budgetary and funding purposes. The award budget period must lie within the project and award start and finish dates.
    • BillableFlag; boolean; Specifies whether the commitment transaction is billable. A value of true means that the project commitment transaction is billable and a value of false means that the project commitment transaction is not billable.
    • BurdenedCostInProjectCurrency; number; Total committed cost in the project currency for the project.
    • BurdenedCostInProviderLedgerCurrency; number; Total committed cost in the provider ledger currency for the project. You must provide a value for this attribute while creating a project commitment transaction for which the burdened cost is accounted externally.
    • BurdenedCostInReceiverLedgerCurrency; number; Total committed cost in the receiver ledger currency for the project.
    • BurdenedCostInTransactionCurrency; number; Total committed cost in the transaction currency for the project. You must provide a value for this attribute while creating an externally burdened project commitment transaction for a project that is enabled for burdening.
    • BusinessUnit; string; Name of the expenditure business unit that incurred the commitment cost. You must enter at least one from among this attribute and Business Unit ID while creating a project commitment.
    • BusinessUnitId; integer; Identifier of the expenditure business unit that incurred the commitment cost. You must enter at least one from among this attribute and Business Unit while creating a project commitment.
    • Buyer; string; Name of the buyer mentioned on the purchase order.
    • CanceledAmount; number; Amount on the purchase order that is cancelled.
    • CanceledQuantity; number; Quantity on the purchase order that is cancelled.
    • CapitalizableFlag; boolean; Specifies whether the commitment transaction is capitalizable. A value of true means that the project commitment transaction is capitalizable and a value of false means that the project commitment transaction is not capitalizable.
    • CommitmentCreationDate; string; Date on which the commitment transaction is created. Default value is the system date while creating a project commitment.
    • CommitmentId; integer; Unique identifier of the commitment transaction.
    • CommitmentNumber; string; Number of the commitment transaction. Examples include purchase requisition number, purchase order number, supplier invoice number, and external commitment transaction number.
    • CommitmentSourceType; string; Identifies the commitment transaction as either internal or external. A list of accepted values - Internal, External, or All - is defined in the lookup type PJC_COMMITMENT_TYPE. Default value is External while creating a project commitment.
    • CommitmentType; string; Identifies the commitment transaction as either purchase requisition, purchase order, supplier invoice, or external. A list of accepted values is defined in the lookup type PJC_CMT_LINE_TYPE. Default value is External while creating a project commitment.
    • ContractId; integer; Identifier of the contract for the commitment transaction of a sponsored project. If the sponsored project is associated to multiple contracts then you must enter at least one from among this attribute, Contract Name, and Contract Number while creating a project commitment. If the sponsored project is associated to a single contract, then the default value is the identifier of the associated contract. The contract must be in one of the following statuses: Draft, Active, Under amendment, or Expired.
    • ContractName; string; Name of the contract for the commitment transaction of a sponsored project. If the sponsored project is associated to multiple contracts then you must enter at least one from among this attribute, Contract ID, and Contract Number while creating a project commitment. If the sponsored project is associated to a single contract, then the default value is the name of the associated contract. The contract must be in one of the following statuses: Draft, Active, Under amendment, or Expired.
    • ContractNumber; string; Number of the contract for the commitment transaction of a sponsored project. If the sponsored project is associated to multiple contracts then you must enter at least one from among this attribute, Contract ID, and Contract Name while creating a project commitment. If the sponsored project is associated to a single contract, then the default value is the number of the associated contract. The contract must be in one of the following statuses: Draft, Active, Under amendment, or Expired.
    • Currency; string; Code identifying the currency in which the commitment transaction cost is incurred. You must enter a value for this attribute for project commitment transactions that are externally costed or accounted. The currency must be an active valid general ledger currency.
    • DeliveredAmount; number; Amount on the purchase order that is delivered.
    • DeliveredQuantity; number; Quantity on the purchase order that is delivered.
    • Document; string; Name of the document used to capture the commitment transaction. You must enter at least one from among this attribute and Document ID while creating a project commitment. The document must be active and enabled for commitment sources.
    • DocumentEntry; string; Name of the document entry used to capture the commitment transaction. You must enter at least one from among this attribute and Document Entry ID while creating a project commitment.
    • DocumentEntryId; integer; Identifier of the document entry used to capture the commitment transaction. You must enter at least one from among this attribute and Document Entry while creating a project commitment.
    • DocumentId; integer; Identifier of the document used to capture the commitment transaction. You must enter at least one from among this attribute and Document while creating a project commitment. The document must be active and enabled for commitment sources.
    • ExpenditureItemDate; string; Date on which the commitment cost was incurred. The expenditure item date must lie within the project start and finish dates.
    • ExpenditureType; string; A classification of cost that is assigned to each project commitment transaction. Expenditure types are grouped into cost groups (expenditure categories) and revenue groups (revenue categories). You must enter at least one from among this attribute and Expenditure Type ID while creating a project commitment. The expenditure type must be active as of the expenditure item date.
    • ExpenditureTypeId; integer; Identifier of the expenditure type. You must enter at least one from among this attribute and Expenditure Type while creating a project commitment. The expenditure type must be active as of the expenditure item date.
    • FundingSource; string; Funding source of a project commitment that is processed for sponsored project costing. If the sponsored project is associated to multiple contracts or a single contract with multiple funding sources then you must enter at least one from among this attribute and Funding Source ID while creating a project commitment. If the sponsored project is associated to a single contract and a single funding source, then the default value is the name of the associated funding source.
    • FundingSourceId; string; Identifier of the funding source of a project commitment that is processed for sponsored project costing. If the sponsored project is associated to multiple contracts or a single contract with multiple funding sources then you must enter at least one from among this attribute and Funding Source while creating a project commitment. If the sponsored project is associated to a single contract and a single funding source, then the default value is the identifier of the associated funding source.
    • InventoryItemId; integer; Identifier of the inventory item for the commitment cost. You must enter at least one from among this attribute, Inventory Item, and Inventory Item Number while creating a project inventory commitment.
    • InventoryItemNumber; string; Number of the inventory item for the commitment cost. You must enter at least one from among this attribute, Inventory Item, and Inventory Item ID while creating a project inventory commitment.
    • InvoicedAmount; number; Amount on the purchase order that is invoiced.
    • InvoicedQuantity; number; Quantity on the purchase order that is invoiced.
    • NeedByDate; string; Date by which the materials must be delivered.
    • OrderedAmount; number; Amount ordered on the purchase order.
    • OrderedQuantity; number; Quantity ordered on the purchase order.
    • Organization; string; Name of the expenditure organization to which the commitment cost is charged. You must enter at least one from among this attribute and Organization ID while creating a project commitment. The organization must be an active project expenditure organization as of the expenditure item date.
    • OrganizationId; integer; Identifier of the expenditure organization to which the commitment cost is charged. You must enter at least one from among this attribute and Organization while creating a project commitment. The organization must be an active project expenditure organization as of the expenditure item date.
    • OriginalTransactionReference; string; Original transaction reference of a third-party commitment transaction. If duplicate references aren't allowed by the document, then multiple project commitments can't refer to the same original transaction.
    • OriginallyOrderedAmount; number; Original amount on the purchase order.
    • OriginallyOrderedQuantity; number; Original quantity on the purchase order.
    • OutstandingDeliveryAmount; number; Amount for the purchase order quantity that is not yet delivered.
    • OutstandingDeliveryQuantity; number; Quantity on the purchase order that is not yet delivered.
    • OutstandingInvoiceAmount; number; Amount on the purchase order that is not yet invoiced by the supplier.
    • OutstandingInvoiceQuantity; number; Quantity on the purchase order that is not yet invoiced by the supplier.
    • OverbilledAmount; number; Amount that is overbilled by the supplier.
    • OverbilledQuantity; number; Quantity that is overbilled by the supplier.
    • ProcessingStatus; string; Identifies the commitment transaction as either unprocessed, processed, or error. A list of accepted values - Processed, Unprocessed, or Error - is defined in the lookup type PJC_CMT_PROCESSING_STATUS. Default value is Unprocessed while creating a project commitment.
    • ProjectId; integer; Identifier of the project to which the commitment cost is charged. You must enter at least one from among this attribute, Project Number, and Project Name while creating a project commitment. The project must be active and in an appropriate status.
    • ProjectName; string; Name of the project to which the commitment cost is charged. You must enter at least one from among this attribute, Project ID, and Project Number while creating a project commitment. The project must be active and in an appropriate status.
    • ProjectNumber; string; Number of the project to which the commitment cost is charged. You must enter at least one from among this attribute, Project ID, and Project Name while creating a project commitment. The project must be active and in an appropriate status.
    • PromisedDate; string; Date by which the supplier has committed to deliver the materials.
    • ProviderAccountingDate; string; Date used to determine the provider accounting period for a commitment transaction. You must provide a value for this attribute for an externally accounted project commitment transaction.
    • ProviderAccountingPeriod; string; Accounting period of the commitment transaction in the accounting calendar of the provider organization.
    • ProviderProjectAccountingDate; string; Date used to determine the provider project accounting period of the commitment transaction.
    • ProviderProjectAccountingPeriod; string; Project accounting period of the commitment transaction in the project accounting calendar of the provider organization.
    • Quantity; number; Quantity entered on the commitment transaction. You must enter a value for this attribute while creating a project commitment that is not externally costed and uses a rate-based expenditure type.
    • RawCostInProjectCurrency; number; Cost committed in the project currency for the project that is directly attributable to the work performed .
    • RawCostInProviderLedgerCurrency; number; Cost committed in the provider ledger currency for the project that is directly attributable to the work performed. You must provide a value for this attribute while creating an externally accounted project commitment transaction.
    • RawCostInReceiverLedgerCurrency; number; Cost committed in the receiver ledger currency for the project that is directly attributable to the work performed.
    • RawCostInTransactionCurrency; number; Cost committed in the transaction currency for the project that is directly attributable to the work performed. You must provide a value for this attribute while creating an externally costed project commitment transaction.
    • ReceiverAccountingDate; string; Date used to determine the receiver accounting period for a commitment transaction. The receiver is the organization that owns the project that incurred the commitment cost.
    • ReceiverAccountingPeriod; string; Accounting period of the commitment transaction in the accounting calendar of the receiver organization. The receiver is the organization that owns the project that incurred the commitment cost.
    • ReceiverProjectAccountingDate; string; Date used to determine the receiver project accounting period of the commitment transaction. The receiver is the organization that owns the project that incurred the commitment cost.
    • ReceiverProjectAccountingPeriod; string; Project accounting period of the commitment transaction in the project accounting calendar of the receiver organization. The receiver is the organization that owns the project that incurred the commitment cost.
    • Requester; string; Name of the person who created the purchase requisition.
    • Supplier; string; Name of the supplier who sent the invoice. You can enter either this attribute or Supplier ID or both while creating a project commitment. The supplier must be active as of the expenditure item date.
    • SupplierId; integer; Identifier of the supplier who sent the invoice. You can enter either this attribute or Supplier or both while creating a project commitment. The supplier must be active as of the expenditure item date.
    • TaskId; integer; Identifier of the task to which the commitment cost is charged. You must enter at least one from among this attribute, Task Number, and Task Name while creating a project commitment. The task must be active and included in a published task structure.
    • TaskName; string; Name of the task to which the commitment cost is charged. You must enter at least one from among this attribute, Task ID, and Task Number while creating a project commitment. The task must be active and included in a published task structure.
    • TaskNumber; string; Number of the task to which the commitment cost is charged. You must enter at least one from among this attribute, Task ID, and Task Name while creating a project commitment. The task must be active and included in a published task structure.
    • TransactionSource; string; Name of the application in which the commitment transaction was originally created. You must enter at least one from among this attribute and Transaction Source ID while creating a project commitment.
    • TransactionSourceId; integer; Identifier of the application in which the commitment transaction was originally created. You must enter at least one from among this attribute and Transaction Source while creating a project commitment.
    • UnitOfMeasure; string; Name of the unit of measure for the item that is requested, ordered, or supplied. You must enter at least one from among this attribute and Unit of Measure Code while creating a project commitment that is not externally costed.
    • UnitOfMeasureCode; string; Code identifying the unit of measure of the item that is requested, ordered, or supplied. You must enter at least one from among this attribute or Unit of Measure while creating a project commitment that is not externally costed.
    • UnitPrice; number; Price per unit of the item that is requested, ordered, or supplied. You cannot enter a value less than zero.
    • WorkType; string; Name of the work type for the commitment transaction. You can enter either this attribute or Work Type ID or both while creating a project commitment. The work type must be active as of the expenditure item date.
    • WorkTypeId; integer; Identifier of the work type for the commitment transaction. You can enter either this attribute or Work Type or both while creating a project commitment. The work type must be active as of the expenditure item date.
  • 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
  • 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.
  • 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".
  • 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 Top

Response

Supported Media Types

Default Response

The following table describes the default response for this task.
Headers
  • 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".
  • 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.
Body ()
Root Schema : projectCommitments
Type: object
Show Source
Nested Schema : Items
Type: array
Title: Items
The items in the collection.
Show Source
Nested Schema : projectCommitments-item-response
Type: object
Show Source
  • Title: Approved
    Maximum Length: 1
    Identifies if the commitment transaction is approved or not in the source application. A value of true means that the project commitment is in approved status and a value of false means that the project commitment is not in approved status.
  • Title: Award Budget Period
    Maximum Length: 15
    Interval of time (usually twelve months) into which the duration of an award project is divided for budgetary and funding purposes. The award budget period must lie within the project and award start and finish dates.
  • Title: Billable
    Maximum Length: 1
    Specifies whether the commitment transaction is billable. A value of true means that the project commitment transaction is billable and a value of false means that the project commitment transaction is not billable.
  • Title: Burdened Cost in Project Currency
    Total committed cost in the project currency for the project.
  • Title: Burdened Cost in Provider Ledger Currency
    Total committed cost in the provider ledger currency for the project. You must provide a value for this attribute while creating a project commitment transaction for which the burdened cost is accounted externally.
  • Title: Burdened Cost in Receiver Ledger Currency
    Total committed cost in the receiver ledger currency for the project.
  • Title: Burdened Cost in Transaction Currency
    Total committed cost in the transaction currency for the project. You must provide a value for this attribute while creating an externally burdened project commitment transaction for a project that is enabled for burdening.
  • Title: Business Unit
    Maximum Length: 240
    Name of the expenditure business unit that incurred the commitment cost. You must enter at least one from among this attribute and Business Unit ID while creating a project commitment.
  • Title: Business Unit ID
    Identifier of the expenditure business unit that incurred the commitment cost. You must enter at least one from among this attribute and Business Unit while creating a project commitment.
  • Title: Buyer
    Maximum Length: 2000
    Name of the buyer mentioned on the purchase order.
  • Title: Canceled Amount
    Amount on the purchase order that is cancelled.
  • Title: Canceled Quantity
    Quantity on the purchase order that is cancelled.
  • Title: Capitalizable
    Maximum Length: 1
    Specifies whether the commitment transaction is capitalizable. A value of true means that the project commitment transaction is capitalizable and a value of false means that the project commitment transaction is not capitalizable.
  • Title: Commitment Creation Date
    Date on which the commitment transaction is created. Default value is the system date while creating a project commitment.
  • Title: Commitment ID
    Unique identifier of the commitment transaction.
  • Title: Commitment Number
    Maximum Length: 64
    Number of the commitment transaction. Examples include purchase requisition number, purchase order number, supplier invoice number, and external commitment transaction number.
  • Title: Commitment Source Type
    Maximum Length: 80
    Identifies the commitment transaction as either internal or external. A list of accepted values - Internal, External, or All - is defined in the lookup type PJC_COMMITMENT_TYPE. Default value is External while creating a project commitment.
  • Title: Commitment Type
    Maximum Length: 80
    Identifies the commitment transaction as either purchase requisition, purchase order, supplier invoice, or external. A list of accepted values is defined in the lookup type PJC_CMT_LINE_TYPE. Default value is External while creating a project commitment.
  • Title: Contract ID
    Identifier of the contract for the commitment transaction of a sponsored project. If the sponsored project is associated to multiple contracts then you must enter at least one from among this attribute, Contract Name, and Contract Number while creating a project commitment. If the sponsored project is associated to a single contract, then the default value is the identifier of the associated contract. The contract must be in one of the following statuses: Draft, Active, Under amendment, or Expired.
  • Title: Contract Name
    Maximum Length: 300
    Name of the contract for the commitment transaction of a sponsored project. If the sponsored project is associated to multiple contracts then you must enter at least one from among this attribute, Contract ID, and Contract Number while creating a project commitment. If the sponsored project is associated to a single contract, then the default value is the name of the associated contract. The contract must be in one of the following statuses: Draft, Active, Under amendment, or Expired.
  • Title: Contract Number
    Maximum Length: 120
    Number of the contract for the commitment transaction of a sponsored project. If the sponsored project is associated to multiple contracts then you must enter at least one from among this attribute, Contract ID, and Contract Name while creating a project commitment. If the sponsored project is associated to a single contract, then the default value is the number of the associated contract. The contract must be in one of the following statuses: Draft, Active, Under amendment, or Expired.
  • Title: Currency
    Maximum Length: 15
    Code identifying the currency in which the commitment transaction cost is incurred. You must enter a value for this attribute for project commitment transactions that are externally costed or accounted. The currency must be an active valid general ledger currency.
  • Title: Delivered Amount
    Amount on the purchase order that is delivered.
  • Title: Delivered Quantity
    Quantity on the purchase order that is delivered.
  • Title: Document
    Maximum Length: 240
    Name of the document used to capture the commitment transaction. You must enter at least one from among this attribute and Document ID while creating a project commitment. The document must be active and enabled for commitment sources.
  • Title: Document Entry
    Maximum Length: 240
    Name of the document entry used to capture the commitment transaction. You must enter at least one from among this attribute and Document Entry ID while creating a project commitment.
  • Title: Document Entry ID
    Identifier of the document entry used to capture the commitment transaction. You must enter at least one from among this attribute and Document Entry while creating a project commitment.
  • Title: Document ID
    Identifier of the document used to capture the commitment transaction. You must enter at least one from among this attribute and Document while creating a project commitment. The document must be active and enabled for commitment sources.
  • Title: Expenditure Item Date
    Date on which the commitment cost was incurred. The expenditure item date must lie within the project start and finish dates.
  • Title: Expenditure Type
    Maximum Length: 240
    A classification of cost that is assigned to each project commitment transaction. Expenditure types are grouped into cost groups (expenditure categories) and revenue groups (revenue categories). You must enter at least one from among this attribute and Expenditure Type ID while creating a project commitment. The expenditure type must be active as of the expenditure item date.
  • Title: Expenditure Type ID
    Identifier of the expenditure type. You must enter at least one from among this attribute and Expenditure Type while creating a project commitment. The expenditure type must be active as of the expenditure item date.
  • Title: Funding Source
    Maximum Length: 360
    Funding source of a project commitment that is processed for sponsored project costing. If the sponsored project is associated to multiple contracts or a single contract with multiple funding sources then you must enter at least one from among this attribute and Funding Source ID while creating a project commitment. If the sponsored project is associated to a single contract and a single funding source, then the default value is the name of the associated funding source.
  • Title: Funding Source ID
    Maximum Length: 150
    Identifier of the funding source of a project commitment that is processed for sponsored project costing. If the sponsored project is associated to multiple contracts or a single contract with multiple funding sources then you must enter at least one from among this attribute and Funding Source while creating a project commitment. If the sponsored project is associated to a single contract and a single funding source, then the default value is the identifier of the associated funding source.
  • Title: Inventory Item ID
    Identifier of the inventory item for the commitment cost. You must enter at least one from among this attribute, Inventory Item, and Inventory Item Number while creating a project inventory commitment.
  • Title: Inventory Item Number
    Maximum Length: 300
    Number of the inventory item for the commitment cost. You must enter at least one from among this attribute, Inventory Item, and Inventory Item ID while creating a project inventory commitment.
  • Title: Invoiced Amount
    Amount on the purchase order that is invoiced.
  • Title: Invoiced Quantity
    Quantity on the purchase order that is invoiced.
  • Links
  • Title: Need-by Date
    Date by which the materials must be delivered.
  • Title: Ordered Amount
    Amount ordered on the purchase order.
  • Title: Ordered Quantity
    Quantity ordered on the purchase order.
  • Title: Organization
    Maximum Length: 240
    Name of the expenditure organization to which the commitment cost is charged. You must enter at least one from among this attribute and Organization ID while creating a project commitment. The organization must be an active project expenditure organization as of the expenditure item date.
  • Title: Organization ID
    Identifier of the expenditure organization to which the commitment cost is charged. You must enter at least one from among this attribute and Organization while creating a project commitment. The organization must be an active project expenditure organization as of the expenditure item date.
  • Title: Originally Ordered Amount
    Original amount on the purchase order.
  • Title: Originally Ordered Quantity
    Original quantity on the purchase order.
  • Title: Original Transaction Reference
    Maximum Length: 120
    Original transaction reference of a third-party commitment transaction. If duplicate references aren't allowed by the document, then multiple project commitments can't refer to the same original transaction.
  • Title: Outstanding Delivery Amount
    Amount for the purchase order quantity that is not yet delivered.
  • Title: Outstanding Delivery Quantity
    Quantity on the purchase order that is not yet delivered.
  • Title: Outstanding Invoice Amount
    Amount on the purchase order that is not yet invoiced by the supplier.
  • Title: Outstanding Invoice Quantity
    Quantity on the purchase order that is not yet invoiced by the supplier.
  • Title: Overbilled Amount
    Amount that is overbilled by the supplier.
  • Title: Overbilled Quantity
    Quantity that is overbilled by the supplier.
  • Title: Processing Status
    Maximum Length: 80
    Identifies the commitment transaction as either unprocessed, processed, or error. A list of accepted values - Processed, Unprocessed, or Error - is defined in the lookup type PJC_CMT_PROCESSING_STATUS. Default value is Unprocessed while creating a project commitment.
  • Title: Project ID
    Identifier of the project to which the commitment cost is charged. You must enter at least one from among this attribute, Project Number, and Project Name while creating a project commitment. The project must be active and in an appropriate status.
  • Title: Project Name
    Maximum Length: 240
    Name of the project to which the commitment cost is charged. You must enter at least one from among this attribute, Project ID, and Project Number while creating a project commitment. The project must be active and in an appropriate status.
  • Title: Project Number
    Maximum Length: 25
    Number of the project to which the commitment cost is charged. You must enter at least one from among this attribute, Project ID, and Project Name while creating a project commitment. The project must be active and in an appropriate status.
  • Title: Promised Date
    Date by which the supplier has committed to deliver the materials.
  • Title: Provider Accounting Date
    Date used to determine the provider accounting period for a commitment transaction. You must provide a value for this attribute for an externally accounted project commitment transaction.
  • Title: Provider Accounting Period
    Maximum Length: 15
    Accounting period of the commitment transaction in the accounting calendar of the provider organization.
  • Title: Provider Project Accounting Date
    Date used to determine the provider project accounting period of the commitment transaction.
  • Title: Provider Project Accounting Period
    Maximum Length: 20
    Project accounting period of the commitment transaction in the project accounting calendar of the provider organization.
  • Title: Quantity
    Quantity entered on the commitment transaction. You must enter a value for this attribute while creating a project commitment that is not externally costed and uses a rate-based expenditure type.
  • Title: Raw Cost in Project Currency
    Cost committed in the project currency for the project that is directly attributable to the work performed .
  • Title: Raw Cost in Provider Ledger Currency
    Cost committed in the provider ledger currency for the project that is directly attributable to the work performed. You must provide a value for this attribute while creating an externally accounted project commitment transaction.
  • Title: Raw Cost in Receiver Ledger Currency
    Cost committed in the receiver ledger currency for the project that is directly attributable to the work performed.
  • Title: Raw Cost in Transaction Currency
    Cost committed in the transaction currency for the project that is directly attributable to the work performed. You must provide a value for this attribute while creating an externally costed project commitment transaction.
  • Title: Receiver Accounting Date
    Date used to determine the receiver accounting period for a commitment transaction. The receiver is the organization that owns the project that incurred the commitment cost.
  • Title: Receiver Accounting Period
    Maximum Length: 15
    Accounting period of the commitment transaction in the accounting calendar of the receiver organization. The receiver is the organization that owns the project that incurred the commitment cost.
  • Title: Receiver Project Accounting Date
    Date used to determine the receiver project accounting period of the commitment transaction. The receiver is the organization that owns the project that incurred the commitment cost.
  • Title: Receiver Project Accounting Period
    Maximum Length: 15
    Project accounting period of the commitment transaction in the project accounting calendar of the receiver organization. The receiver is the organization that owns the project that incurred the commitment cost.
  • Title: Requester
    Maximum Length: 2000
    Name of the person who created the purchase requisition.
  • Title: Supplier
    Maximum Length: 360
    Name of the supplier who sent the invoice. You can enter either this attribute or Supplier ID or both while creating a project commitment. The supplier must be active as of the expenditure item date.
  • Title: Supplier ID
    Identifier of the supplier who sent the invoice. You can enter either this attribute or Supplier or both while creating a project commitment. The supplier must be active as of the expenditure item date.
  • Title: Task ID
    Identifier of the task to which the commitment cost is charged. You must enter at least one from among this attribute, Task Number, and Task Name while creating a project commitment. The task must be active and included in a published task structure.
  • Title: Task Name
    Maximum Length: 255
    Name of the task to which the commitment cost is charged. You must enter at least one from among this attribute, Task ID, and Task Number while creating a project commitment. The task must be active and included in a published task structure.
  • Title: Task Number
    Maximum Length: 100
    Number of the task to which the commitment cost is charged. You must enter at least one from among this attribute, Task ID, and Task Name while creating a project commitment. The task must be active and included in a published task structure.
  • Title: Transaction Source
    Maximum Length: 240
    Name of the application in which the commitment transaction was originally created. You must enter at least one from among this attribute and Transaction Source ID while creating a project commitment.
  • Title: Transaction Source ID
    Identifier of the application in which the commitment transaction was originally created. You must enter at least one from among this attribute and Transaction Source while creating a project commitment.
  • Title: Unit of Measure
    Maximum Length: 80
    Name of the unit of measure for the item that is requested, ordered, or supplied. You must enter at least one from among this attribute and Unit of Measure Code while creating a project commitment that is not externally costed.
  • Title: Unit of Measure Code
    Maximum Length: 30
    Code identifying the unit of measure of the item that is requested, ordered, or supplied. You must enter at least one from among this attribute or Unit of Measure while creating a project commitment that is not externally costed.
  • Title: Unit Price
    Price per unit of the item that is requested, ordered, or supplied. You cannot enter a value less than zero.
  • Title: Work Type
    Maximum Length: 240
    Name of the work type for the commitment transaction. You can enter either this attribute or Work Type ID or both while creating a project commitment. The work type must be active as of the expenditure item date.
  • Title: Work Type ID
    Identifier of the work type for the commitment transaction. You can enter either this attribute or Work Type or both while creating a project commitment. The work type must be active as of the expenditure item date.
Back to Top

Examples

The following example shows how to get all project commitments 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/projectCommitments

Example of Response Body

The following shows an example of the response body in JSON format.

{
"items": [
  {
"CommitmentId": 9390,
"CommitmentNumber": "10501004",
"BusinessUnitId": 204,
"BusinessUnit": "Vision Operations",
"OrganizationId": 458,
"Organization": "Vision Services",
"TransactionSourceId": 300100007235514,
"TransactionSource": "Oracle Fusion Purchasing",
"DocumentId": 300100007235521,
"Document": "Purchase Requisition",
"DocumentEntryId": 300100007235523,
"DocumentEntry": "Item Cost",
"ProjectId": 300100008820583,
"ProjectNumber": "OTBI VS Project",
"ProjectName": "OTBI VS Project",
"TaskId": 300100008871481,
"TaskNumber": "1.1",
"TaskName": "1.1",
"CommitmentSourceType": "Internal",
"CommitmentType": "Purchase requisition",
"ProcessingStatus": "Processed",
"ApprovedFlag": true,
"CommitmentCreationDate": null,
"OriginalTransactionReference": null,
"OriginallyOrderedQuantity": null,
"OriginallyOrderedAmount": null,
"OrderedAmount": null,
"DeliveredAmount": null,
"CanceledAmount": null,
"OverbilledAmount": null,
"InvoicedAmount": null,
"OutstandingInvoiceAmount": null,
"OutstandingDeliveryAmount": null,
"OrderedQuantity": null,
"DeliveredQuantity": null,
"CanceledQuantity": null,
"InvoicedQuantity": null,
"OverbilledQuantity": null,
"OutstandingInvoiceQuantity": null,
"OutstandingDeliveryQuantity": null,
"Quantity": 5,
"Currency": "USD",
"BurdenedCostInTransactionCurrency": 3300,
"RawCostInTransactionCurrency": 2500,
"RawCostInProjectCurrency": 2500,
"BurdenedCostInProjectCurrency": 3300,
"RawCostInReceiverLedgerCurrency": 2500,
"BurdenedCostInReceiverLedgerCurrency": 3300,
"RawCostInProviderLedgerCurrency": 2500,
"BurdenedCostInProviderLedgerCurrency": 3300,
"ExpenditureTypeId": 10012,
"ExpenditureType": "Supplies",
"ExpenditureItemDate": "2012-05-08",
"ProviderProjectAccountingDate": "2012-05-08",
"ProviderProjectAccountingPeriod": "19-12",
"ProviderAccountingDate": "2012-05-08",
"ProviderAccountingPeriod": "May-12",
"ReceiverAccountingPeriod": "May-12",
"ReceiverAccountingDate": "2012-05-08",
"ReceiverProjectAccountingDate": "2012-05-08",
"ReceiverProjectAccountingPeriod": "May-W1-12",
"NeedByDate": "2012-05-08",
"PromisedDate": null,
"CapitalizableFlag": true,
"BillableFlag": true,
"InventoryItemId": null,
"InventoryItemNumber": null,
"UnitOfMeasureCode": "Ea",
"UnitOfMeasure": "Each",
"UnitPrice": 500,
"SupplierId": 7,
"Supplier": "Capp Consulting",
"Requester": "Abraham Mason",
"Buyer": null,
"WorkTypeId": 10020,
"WorkType": "Commercial Customer-billable",
"ContractId": null,
"ContractName": null,
"ContractNumber": null,
"FundingSourceId": null,
"FundingSource": null,
"AwardBudgetPeriod": null
Back to Top