Jump to

• Request
• Response
• Examples

Get an invoice line

get

/fscmRestApi/resources/11.13.18.05/projectContractInvoices/{InvoiceId}/child/InvoiceLines/{InvoiceLineId}

Request

Path Parameters

• InvoiceId(required): integer(int64)
  Unique identifier of the invoice.
• InvoiceLineId(required): integer(int64)
  Unique identifier of the invoice line.

Query Parameters

• dependency: string
  This parameter specifies dependencies which are fields that are set before and rolled back after generating the response. Generally they are used to preview the effects of an attribute change. The fields specified in this parameter are always set in the resource instance in question. When a child resource collection is requested and the parameter is set, the fields will be set in the parent resource instance before generating the resource collection payload. The value of this query parameter is a set of dependency fields. Example: dependency=ProductId=2
  
  Format: <attr1>=<val1>,<attr2>=<value2>
• 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
• 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
  
• onlyData: boolean
  The resource item payload will be filtered in order to contain only data (no links section, for example).

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 Top

Response

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.

Body ()

Root Schema : projectContractInvoices-InvoiceLines-item-response

Type: object

Show Source

• ApTransferErrorCode: string
  Title: Invoice AP Transfer Error Code

  Read Only: true

  Maximum Length: 80

  Indicates the code related to transfer errors between project billing and Accounts Payable (AP). The Invoice Transfer Error Message attribute contains a description of the error.
• ApTransferStatusCode: string
  Title: Invoice Transfer Status to Payables

  Read Only: true

  Maximum Length: 1

  Indicates the status of the transfer of the invoice to Accounts Payable (AP). Valid values are P - Pending, A - Accepted, and R - Rejected.
• AssessableValue: number
  Title: Assessable Value

  An optional value for an assessable value for the transaction line for estimated tax purposes.
• BillPlanId: integer (int64)
  Title: Bill Plan ID

  Read Only: true

  Unique identifier of the bill plan related to the line.
• BillSet: integer (int64)
  Title: Bill Set

  Read Only: true

  Identifier of a set of invoices created together in the same run which must be released at the same time.
• ContractCurrencyCode: string
  Title: Contract Currency

  Read Only: true

  Maximum Length: 30

  Indicates the code of the currency for the contract related to the invoice line.
• ContractCurrencyLineAmount: number
  Title: Invoice Amount in Contract Currency

  Read Only: true

  Amount in contract currency.
• ContractLineId: integer (int64)
  Title: Contract Line ID

  Read Only: true

  Unique identifier of the contract line related to the invoice line.
• ContractLineNumber: string
  Title: Contract Line Number

  Read Only: true

  Maximum Length: 150

  Number that identifies the contract line related to the invoice line if the line represents a single contract line.
• CreditedInvoiceLineId: integer (int64)
  Title: Credited Invoice Line ID

  Read Only: true

  Unique identifier of the invoice line credited by this invoice line.
• DocumentNumber: string
  Title: Document Number

  Read Only: true

  Maximum Length: 240

  Number that identifies a document on the bill plan of a grants contract.
• Exception: string
  Title: Exception

  Read Only: true

  Maximum Length: 1

  Indicates that exceptions have occurred for the invoice line. Valid values are E - Error, W - Warning, and N - No error.
• ExpenditureOrgId: integer (int64)
  Title: Expenditure Organization ID

  Read Only: true

  Unique identifier of the expenditure organization related to the line.
• ExpenditureTypeId: integer (int64)
  Title: Expenditure Type ID

  Read Only: true

  Unique identifier of the expenditure type for the invoice line.
• IntendedUse: string
  Title: Intended Use

  Maximum Length: 240

  A classification of the products by tax authority for tax purposes.
• IntendedUseClassifId: integer (int64)
  Title: Intended Use Classification ID

  Unique identifier of the intended use classification.
• InvoiceCurrencyCode: string
  Title: Invoice Currency

  Read Only: true

  Maximum Length: 30

  Indicates the currency code for the invoice that is transferred to Oracle Receivables.
• InvoiceCurrencyLineAmount: number
  Title: Amount in Invoice Currency

  Read Only: true

  Default Value: 0

  Amount of the invoice line in the invoice currency.
• InvoiceFormatId: integer (int64)
  Title: Invoice Format ID

  Read Only: true

  Unique identifier of the invoice format.
• InvoiceFormatName: string
  Title: Invoice Format Name

  Read Only: true

  Maximum Length: 30

  Name of the invoice format.
• InvoiceLineDff: array Invoice Line Descriptive Flexfields
  Title: Invoice Line Descriptive Flexfields

  A listing of all the descriptive flexfields available for invoice lines.
• InvoiceLineDistributions: array Invoice Line Distributions
  Title: Invoice Line Distributions

  The Invoice Line Distributions resource is used to view the details of invoice line distributions.
• InvoiceLineId: integer (int64)
  Title: Invoice Line ID

  Unique identifier of the invoice line.
• InvoiceLineNumber: integer (int64)
  Title: Invoice Line Number

  Number that identifies an invoice line.
• InvoiceLineType: string
  Title: Invoice Line Type

  Read Only: true

  Maximum Length: 30

  Default Value: STANDARD

  A classification of invoice credit that is assigned to an invoice line. Valid values are CONCESSION, WRITE_OFF, CANCEL, STANDARD, and CREDIT_MEMO.
• InvoiceLineTypeMeaning: string
  Title: Invoice Line Type Meaning

  Read Only: true

  Maximum Length: 80

  Meaning of the invoice line type.
• LedgerCurrencyCode: string
  Title: Ledger Currency

  Read Only: true

  Maximum Length: 30

  The currency used for accounting and reporting in a ledger, often referred to as the accounting currency, base currency, or functional currency.
• LedgerCurrencyLineAmount: number
  Title: Invoice Amount in Ledger Currency

  Read Only: true

  Amount of the invoice line in the ledger currency.
• LineDescription: string
  Title: Invoice Line Description

  Maximum Length: 240

  Description of the invoice line.
• LinkedProjectId: integer (int64)
  Title: Associated Project ID

  Read Only: true

  Unique identifier of the project associated to the related contract line or contract lines. This value is populated if Invoice Format grouping options are set to group distribution lines by Contract Line Project Name or Number.
• LinkedProjectName: string
  Title: Associated Project Name

  Read Only: true

  Maximum Length: 240

  Name of project that is linked to the contract line associated to the invoice line. This value is populated if Invoice Format grouping options are set to group distribution lines by Contract Line Project Name or Number.
• LinkedProjectNumber: string
  Title: Associated Project Number

  Read Only: true

  Maximum Length: 25

  Number of project that is linked to the contract line associated to the invoice line. This value is populated if Invoice Format grouping options are set to group distribution lines by Contract Line Project Name or Number.
• LinkedTaskId: integer (int64)
  Title: Associated Task ID

  Read Only: true

  Unique identifier of the project task associated to the related contract line or contract lines. This value is populated if a task is associated to the contract line and Invoice Format grouping options are set to group distribution lines by Contract Line Task Name or Number.
• LinkedTaskName: string
  Title: Associated Task Name

  Read Only: true

  Maximum Length: 255

  Name of the task that is linked to the contract line associated to the invoice line. This value is populated if a task is associated to the contract line and Invoice Format grouping options are set to group distribution lines by Contract Line Project Name or Number.
• LinkedTaskNumber: string
  Title: Associated Task Number

  Read Only: true

  Maximum Length: 100

  Number of the task that is linked to the contract line associated to the invoice line. This value is populated if a task is associated to the contract line and Invoice Format grouping options are set to group distribution lines by Contract Line Project Name or Number.
• links: array Links
  Title: Links

  The link relations associated with the resource instance.
• LocNumber: string
  Title: LOC Number

  Read Only: true

  Maximum Length: 240

  Number that identifies a letter of credit on the bill plan of a grants contract.
• OutputTaxAmount: number
  Title: Tax Amount in Invoice Currency

  Read Only: true

  The total tax amount in the invoice currency.
• OutputTaxClassCode: string
  Title: Output Tax Classification

  Maximum Length: 150

  A classification of output tax for the invoice line.
• OutputTaxExempt: string
  Title: Output tax exempt

  Maximum Length: 1

  Indicates the use of Standard Exemption rules. Options include Standard, Exempt, or Required. The default is based on user tax setup.
• OutputTaxExmtCertNumber: string
  Title: Tax Exemption Certificate Number

  Maximum Length: 80

  Identifier of the exemption certificate for item lines that have the Output tax Exempt attribute set to E-exempt.
• OutputTaxExmtReasonCode: string
  Title: Tax Exemption Reason

  Maximum Length: 30

  Indicates the code for the reason for tax exemption on lines that have the Output tax Exempt attribute set to E-exempt.
• PaymentTermId: integer (int64)
  Title: Payment Term ID

  Read Only: true

  Unique identifier of the payment term for the receipt from Accounts Receivable (AR) which is applied against the agreement.
• PaymentTermName: string
  Title: Payment Term

  Read Only: true

  Maximum Length: 15

  Name of the payment term.
• ProductCategory: string
  Title: Product Category

  Maximum Length: 240

  A classification of products used for tax purposes.
• ProductFcCategoryId: integer (int64)
  Title: Product FC Category ID

  Unique identifier of the product fiscal classification category.
• ProductFiscClassification: string
  Title: Product Fiscal Classification

  Maximum Length: 240

  A classification of the products based on the inventory item category by the tax authority for tax purposes.
• ProductType: string
  Title: Product Type

  Maximum Length: 240

  This value is another product related tax classification. The value of product type specifies whether the transaction line is for a good, or a service, or it is a memo line.
• ReceiverProjectId: integer (int64)
  Title: Receiver Project ID

  Read Only: true

  Unique identifier of the receiver project.
• ReceiverTaskId: integer (int64)
  Title: Receiver Task ID

  Read Only: true

  Unique identifier of the receiver task.
• ShipToAccountDescription: string
  Title: Ship-to Account Description

  Read Only: true

  Account description of the ship-to customer on the invoice line.
• ShipToAccountNumber: string
  Title: Ship-to Account Number

  Account number of the ship-to customer on the invoice line.
• ShipToAddress: string
  Title: Ship-to Address

  Read Only: true

  Address of the ship-to customer on the invoice line.
• ShipToContactId: integer (int64)
  Title: Ship-to Contact ID

  Read Only: true

  Unique identifier of the ship-to contact. A representative for the ship to customer of the project.
• ShipToCustomerId: integer (int64)
  Title: Ship-to Customer

  Unique identifier of the customer account ship-to address that is the project customer's default work site for the project.
• ShipToCustomerName: string
  Title: Ship-to Customer

  Read Only: true

  Name of the ship-to customer on the invoice line.
• ShipToSiteId: integer (int64)
  Title: Ship-to Site Use ID

  Unique identifier of the ship-to address used for taxation. This attribute is populated only if the invoice formats groups by work site and for events using the work site of the event task.
• ShipToSiteName: string
  Title: Ship-to Site

  Unique identifier of the ship-to site on the invoice line.
• TransactionBusinessCategory: string
  Title: Transaction Business Category

  Maximum Length: 240

  A classification or categorization of an invoice line for tax purposes as required by a tax authority.
• TranslatedText: string
  Title: Translated Description

  Maximum Length: 1000

  The translated text of the invoice line. This text is in the language defined in invoice header.
• UserDefinedFiscalClass: string
  Title: User-Defined Fiscal Classification

  Maximum Length: 30

  Indicates the default taxation country.
• WorkTypeId: integer (int64)
  Title: Work Type ID

  Read Only: true

  Unique identifier of the work type.
• WorkTypeName: string
  Title: Work Type

  Read Only: true

  Maximum Length: 240

  Name of the work type.

{ "type":"object", "properties":{ "ShipToAddress":{ "title":"Ship-to Address", "type":"string", "description":"Address of the ship-to customer on the invoice line.", "nullable":true, "readOnly":true, "x-hints":{ "dependencies":[ "ShipToSiteId" ] }, "x-queryable":true }, "ApTransferErrorCode":{ "title":"Invoice AP Transfer Error Code", "maxLength":80, "type":"string", "description":"Indicates the code related to transfer errors between project billing and Accounts Payable (AP). The Invoice Transfer Error Message attribute contains a description of the error.", "nullable":true, "readOnly":true, "x-queryable":true }, "InvoiceLineNumber":{ "title":"Invoice Line Number", "type":"integer", "description":"Number that identifies an invoice line.", "format":"int64", "nullable":false, "x-hints":{ "precision":18 }, "x-queryable":true }, "InvoiceLineDff":{ "title":"Invoice Line Descriptive Flexfields", "type":"array", "description":"A listing of all the descriptive flexfields available for invoice lines.", "items":{ "$ref":"#/components/schemas/projectContractInvoices-InvoiceLines-InvoiceLineDff-item-response" }, "x-cardinality":"1" }, "InvoiceFormatId":{ "title":"Invoice Format ID", "type":"integer", "description":"Unique identifier of the invoice format.", "format":"int64", "nullable":true, "readOnly":true, "x-hints":{ "precision":18 }, "x-queryable":true }, "ContractLineId":{ "title":"Contract Line ID", "type":"integer", "description":"Unique identifier of the contract line related to the invoice line.", "format":"int64", "nullable":true, "readOnly":true, "x-hints":{ "precision":18 }, "x-queryable":true }, "InvoiceLineId":{ "title":"Invoice Line ID", "type":"integer", "description":"Unique identifier of the invoice line.", "format":"int64", "nullable":false, "x-hints":{ "precision":18, "fnd:GLOBALLY_UNIQUE":"true" }, "x-queryable":true }, "ExpenditureOrgId":{ "title":"Expenditure Organization ID", "type":"integer", "description":"Unique identifier of the expenditure organization related to the line.", "format":"int64", "nullable":true, "readOnly":true, "x-hints":{ "precision":18 }, "x-queryable":true }, "ShipToCustomerName":{ "title":"Ship-to Customer", "type":"string", "description":"Name of the ship-to customer on the invoice line.", "nullable":true, "readOnly":true, "x-hints":{ "dependencies":[ "ShipToCustomerId" ] }, "x-queryable":true }, "OutputTaxAmount":{ "title":"Tax Amount in Invoice Currency", "type":"number", "description":"The total tax amount in the invoice currency.", "nullable":true, "readOnly":true, "x-queryable":true }, "InvoiceLineTypeMeaning":{ "title":"Invoice Line Type Meaning", "maxLength":80, "type":"string", "description":"Meaning of the invoice line type.", "nullable":false, "readOnly":true, "x-queryable":true }, "ShipToAccountDescription":{ "title":"Ship-to Account Description", "type":"string", "description":"Account description of the ship-to customer on the invoice line.", "nullable":true, "readOnly":true, "x-hints":{ "dependencies":[ "ShipToCustomerId" ] }, "x-queryable":true }, "LinkedTaskName":{ "title":"Associated Task Name", "maxLength":255, "type":"string", "description":"Name of the task that is linked to the contract line associated to the invoice line. This value is populated if a task is associated to the contract line and Invoice Format grouping options are set to group distribution lines by Contract Line Project Name or Number.", "nullable":false, "readOnly":true, "x-queryable":true }, "IntendedUseClassifId":{ "title":"Intended Use Classification ID", "type":"integer", "description":"Unique identifier of the intended use classification.", "format":"int64", "nullable":true, "x-hints":{ "controlType":"combo_lov", "precision":18, "dependencies":[ "IntendedUse" ] }, "x-queryable":true }, "BillSet":{ "title":"Bill Set", "type":"integer", "description":"Identifier of a set of invoices created together in the same run which must be released at the same time.", "format":"int64", "nullable":true, "readOnly":true, "x-hints":{ "precision":18 }, "x-queryable":true }, "links":{ "title":"Links", "type":"array", "description":"The link relations associated with the resource instance.", "items":{ "$ref":"#/components/schemas/link" } }, "ShipToAccountNumber":{ "title":"Ship-to Account Number", "type":"string", "description":"Account number of the ship-to customer on the invoice line.", "nullable":true, "x-hints":{ "controlType":"combo_lov" }, "x-queryable":true }, "ShipToContactId":{ "title":"Ship-to Contact ID", "type":"integer", "description":"Unique identifier of the ship-to contact. A representative for the ship to customer of the project.", "format":"int64", "nullable":true, "readOnly":true, "x-hints":{ "precision":18 }, "x-queryable":true }, "UserDefinedFiscalClass":{ "title":"User-Defined Fiscal Classification", "maxLength":30, "type":"string", "description":"Indicates the default taxation country.", "nullable":true, "x-hints":{ "controlType":"combo_lov" }, "x-queryable":true }, "ProductFcCategoryId":{ "title":"Product FC Category ID", "type":"integer", "description":"Unique identifier of the product fiscal classification category.", "format":"int64", "nullable":true, "x-hints":{ "controlType":"combo_lov", "precision":18, "dependencies":[ "ProductFiscClassification" ] }, "x-queryable":true }, "LinkedTaskNumber":{ "title":"Associated Task Number", "maxLength":100, "type":"string", "description":"Number of the task that is linked to the contract line associated to the invoice line. This value is populated if a task is associated to the contract line and Invoice Format grouping options are set to group distribution lines by Contract Line Project Name or Number.", "nullable":true, "readOnly":true, "x-queryable":true }, "ProductType":{ "title":"Product Type", "maxLength":240, "type":"string", "description":"This value is another product related tax classification. The value of product type specifies whether the transaction line is for a good, or a service, or it is a memo line.", "nullable":true, "x-hints":{ "controlType":"combo_lov" }, "x-queryable":true }, "ExpenditureTypeId":{ "title":"Expenditure Type ID", "type":"integer", "description":"Unique identifier of the expenditure type for the invoice line.", "format":"int64", "nullable":true, "readOnly":true, "x-hints":{ "precision":18 }, "x-queryable":true }, "LocNumber":{ "title":"LOC Number", "maxLength":240, "type":"string", "description":"Number that identifies a letter of credit on the bill plan of a grants contract.", "nullable":true, "readOnly":true, "x-queryable":true }, "InvoiceCurrencyLineAmount":{ "title":"Amount in Invoice Currency", "type":"number", "description":"Amount of the invoice line in the invoice currency.", "nullable":true, "readOnly":true, "default":0, "x-queryable":true }, "ProductCategory":{ "title":"Product Category", "maxLength":240, "type":"string", "description":"A classification of products used for tax purposes.", "nullable":true, "x-hints":{ "controlType":"combo_lov" }, "x-queryable":true }, "AssessableValue":{ "title":"Assessable Value", "type":"number", "description":"An optional value for an assessable value for the transaction line for estimated tax purposes.", "nullable":true, "x-queryable":true }, "InvoiceLineDistributions":{ "title":"Invoice Line Distributions", "type":"array", "description":"The Invoice Line Distributions resource is used to view the details of invoice line distributions.", "items":{ "$ref":"#/components/schemas/projectContractInvoices-InvoiceLines-InvoiceLineDistributions-item-response" } }, "InvoiceFormatName":{ "title":"Invoice Format Name", "maxLength":30, "type":"string", "description":"Name of the invoice format.", "nullable":false, "readOnly":true, "x-queryable":true }, "ContractCurrencyCode":{ "title":"Contract Currency", "maxLength":30, "type":"string", "description":"Indicates the code of the currency for the contract related to the invoice line.", "nullable":true, "readOnly":true, "x-queryable":true }, "ReceiverProjectId":{ "title":"Receiver Project ID", "type":"integer", "description":"Unique identifier of the receiver project.", "format":"int64", "nullable":true, "readOnly":true, "x-hints":{ "precision":18 }, "x-queryable":true }, "InvoiceCurrencyCode":{ "title":"Invoice Currency", "maxLength":30, "type":"string", "description":"Indicates the currency code for the invoice that is transferred to Oracle Receivables.", "nullable":true, "readOnly":true, "x-queryable":true }, "PaymentTermName":{ "title":"Payment Term", "maxLength":15, "type":"string", "description":"Name of the payment term.", "nullable":false, "readOnly":true, "x-queryable":true }, "ContractCurrencyLineAmount":{ "title":"Invoice Amount in Contract Currency", "type":"number", "description":"Amount in contract currency.", "nullable":true, "readOnly":true, "x-queryable":true }, "LinkedTaskId":{ "title":"Associated Task ID", "type":"integer", "description":"Unique identifier of the project task associated to the related contract line or contract lines. This value is populated if a task is associated to the contract line and Invoice Format grouping options are set to group distribution lines by Contract Line Task Name or Number.", "format":"int64", "nullable":true, "readOnly":true, "x-hints":{ "precision":18 }, "x-queryable":true }, "CreditedInvoiceLineId":{ "title":"Credited Invoice Line ID", "type":"integer", "description":"Unique identifier of the invoice line credited by this invoice line.", "format":"int64", "nullable":true, "readOnly":true, "x-hints":{ "precision":18 }, "x-queryable":true }, "OutputTaxExmtReasonCode":{ "title":"Tax Exemption Reason", "maxLength":30, "type":"string", "description":"Indicates the code for the reason for tax exemption on lines that have the Output tax Exempt attribute set to E-exempt.", "nullable":true, "x-hints":{ "controlType":"choice" }, "x-queryable":true }, "InvoiceLineType":{ "title":"Invoice Line Type", "maxLength":30, "type":"string", "description":"A classification of invoice credit that is assigned to an invoice line. Valid values are CONCESSION, WRITE_OFF, CANCEL, STANDARD, and CREDIT_MEMO.", "nullable":false, "readOnly":true, "default":"STANDARD", "x-queryable":true }, "ShipToCustomerId":{ "title":"Ship-to Customer", "type":"integer", "description":"Unique identifier of the customer account ship-to address that is the project customer's default work site for the project.", "format":"int64", "nullable":true, "x-hints":{ "controlType":"combo_lov", "precision":18, "dependencies":[ "ShipToAccountNumber" ] }, "x-queryable":true }, "WorkTypeId":{ "title":"Work Type ID", "type":"integer", "description":"Unique identifier of the work type.", "format":"int64", "nullable":true, "readOnly":true, "x-hints":{ "precision":18 }, "x-queryable":true }, "LinkedProjectNumber":{ "title":"Associated Project Number", "maxLength":25, "type":"string", "description":"Number of project that is linked to the contract line associated to the invoice line. This value is populated if Invoice Format grouping options are set to group distribution lines by Contract Line Project Name or Number.", "nullable":false, "readOnly":true, "x-queryable":true }, "IntendedUse":{ "title":"Intended Use", "maxLength":240, "type":"string", "description":"A classification of the products by tax authority for tax purposes.", "nullable":true, "x-hints":{ "controlType":"combo_lov" }, "x-queryable":true }, "LineDescription":{ "title":"Invoice Line Description", "maxLength":240, "type":"string", "description":"Description of the invoice line.", "nullable":true, "x-queryable":true }, "OutputTaxExmtCertNumber":{ "title":"Tax Exemption Certificate Number", "maxLength":80, "type":"string", "description":"Identifier of the exemption certificate for item lines that have the Output tax Exempt attribute set to E-exempt.", "nullable":true, "x-hints":{ "controlType":"combo_lov" }, "x-queryable":true }, "LedgerCurrencyCode":{ "title":"Ledger Currency", "maxLength":30, "type":"string", "description":"The currency used for accounting and reporting in a ledger, often referred to as the accounting currency, base currency, or functional currency.", "nullable":true, "readOnly":true, "x-queryable":true }, "ShipToSiteName":{ "title":"Ship-to Site", "type":"string", "description":"Unique identifier of the ship-to site on the invoice line.", "nullable":true, "x-hints":{ "controlType":"combo_lov", "dependencies":[ "ShipToCustomerId" ] }, "x-queryable":true }, "PaymentTermId":{ "title":"Payment Term ID", "type":"integer", "description":"Unique identifier of the payment term for the receipt from Accounts Receivable (AR) which is applied against the agreement.", "format":"int64", "nullable":true, "readOnly":true, "x-hints":{ "precision":18 }, "x-queryable":true }, "BillPlanId":{ "title":"Bill Plan ID", "type":"integer", "description":"Unique identifier of the bill plan related to the line.", "format":"int64", "nullable":true, "readOnly":true, "x-hints":{ "precision":18 }, "x-queryable":true }, "WorkTypeName":{ "title":"Work Type", "maxLength":240, "type":"string", "description":"Name of the work type.", "nullable":false, "readOnly":true, "x-queryable":true }, "DocumentNumber":{ "title":"Document Number", "maxLength":240, "type":"string", "description":"Number that identifies a document on the bill plan of a grants contract.", "nullable":true, "readOnly":true, "x-queryable":true }, "Exception":{ "title":"Exception", "maxLength":1, "type":"string", "description":"Indicates that exceptions have occurred for the invoice line. Valid values are E - Error, W - Warning, and N - No error.", "nullable":true, "readOnly":true, "x-queryable":true }, "TransactionBusinessCategory":{ "title":"Transaction Business Category", "maxLength":240, "type":"string", "description":"A classification or categorization of an invoice line for tax purposes as required by a tax authority.", "nullable":true, "x-hints":{ "controlType":"combo_lov" }, "x-queryable":true }, "ContractLineNumber":{ "title":"Contract Line Number", "maxLength":150, "type":"string", "description":"Number that identifies the contract line related to the invoice line if the line represents a single contract line.", "nullable":false, "readOnly":true, "x-queryable":true }, "ApTransferStatusCode":{ "title":"Invoice Transfer Status to Payables", "maxLength":1, "type":"string", "description":"Indicates the status of the transfer of the invoice to Accounts Payable (AP). Valid values are P - Pending, A - Accepted, and R - Rejected.", "nullable":true, "readOnly":true, "x-queryable":true }, "OutputTaxClassCode":{ "title":"Output Tax Classification", "maxLength":150, "type":"string", "description":"A classification of output tax for the invoice line.", "nullable":true, "x-hints":{ "controlType":"combo_lov" }, "x-queryable":true }, "ProductFiscClassification":{ "title":"Product Fiscal Classification", "maxLength":240, "type":"string", "description":"A classification of the products based on the inventory item category by the tax authority for tax purposes.", "nullable":true, "x-hints":{ "controlType":"combo_lov" }, "x-queryable":true }, "TranslatedText":{ "title":"Translated Description", "maxLength":1000, "type":"string", "description":"The translated text of the invoice line. This text is in the language defined in invoice header.", "nullable":true, "x-queryable":true }, "LinkedProjectId":{ "title":"Associated Project ID", "type":"integer", "description":"Unique identifier of the project associated to the related contract line or contract lines. This value is populated if Invoice Format grouping options are set to group distribution lines by Contract Line Project Name or Number.", "format":"int64", "nullable":true, "readOnly":true, "x-hints":{ "precision":18 }, "x-queryable":true }, "LedgerCurrencyLineAmount":{ "title":"Invoice Amount in Ledger Currency", "type":"number", "description":"Amount of the invoice line in the ledger currency.", "nullable":true, "readOnly":true, "x-queryable":true }, "ReceiverTaskId":{ "title":"Receiver Task ID", "type":"integer", "description":"Unique identifier of the receiver task.", "format":"int64", "nullable":true, "readOnly":true, "x-hints":{ "precision":18 }, "x-queryable":true }, "OutputTaxExempt":{ "title":"Output tax exempt", "maxLength":1, "type":"string", "description":"Indicates the use of Standard Exemption rules. Options include Standard, Exempt, or Required. The default is based on user tax setup.", "nullable":true, "x-queryable":true }, "ShipToSiteId":{ "title":"Ship-to Site Use ID", "type":"integer", "description":"Unique identifier of the ship-to address used for taxation. This attribute is populated only if the invoice formats groups by work site and for events using the work site of the event task.", "format":"int64", "nullable":true, "x-hints":{ "controlType":"combo_lov", "precision":18, "dependencies":[ "ShipToCustomerId", "ShipToSiteName" ] }, "x-queryable":true }, "LinkedProjectName":{ "title":"Associated Project Name", "maxLength":240, "type":"string", "description":"Name of project that is linked to the contract line associated to the invoice line. This value is populated if Invoice Format grouping options are set to group distribution lines by Contract Line Project Name or Number.", "nullable":false, "readOnly":true, "x-queryable":true } } }

Nested Schema : Invoice Line Descriptive Flexfields

Type: array

Title: Invoice Line Descriptive Flexfields

A listing of all the descriptive flexfields available for invoice lines.

Show Source

• Array of: object projectContractInvoices-InvoiceLines-InvoiceLineDff-item-response

{ "title":"Invoice Line Descriptive Flexfields", "type":"array", "description":"A listing of all the descriptive flexfields available for invoice lines.", "items":{ "$ref":"#/components/schemas/projectContractInvoices-InvoiceLines-InvoiceLineDff-item-response" }, "x-cardinality":"1" }

Nested Schema : Invoice Line Distributions

Type: array

Title: Invoice Line Distributions

The Invoice Line Distributions resource is used to view the details of invoice line distributions.

Show Source

• Array of: object projectContractInvoices-InvoiceLines-InvoiceLineDistributions-item-response

{ "title":"Invoice Line Distributions", "type":"array", "description":"The Invoice Line Distributions resource is used to view the details of invoice line distributions.", "items":{ "$ref":"#/components/schemas/projectContractInvoices-InvoiceLines-InvoiceLineDistributions-item-response" } }

Nested Schema : Links

Type: array

Title: Links

The link relations associated with the resource instance.

Show Source

• Array of: object link

{ "title":"Links", "type":"array", "description":"The link relations associated with the resource instance.", "items":{ "$ref":"#/components/schemas/link" } }

Nested Schema : projectContractInvoices-InvoiceLines-InvoiceLineDff-item-response

Type: object

Show Source

• __FLEX_Context: string
  Title: Context Prompt

  Maximum Length: 30

  Context for flex fields.
• __FLEX_Context_DisplayValue: string
  Title: Context Prompt

  Context Prompt
• InvoiceLineId: integer (int64)
  Identifier of the invoice line.
• links: array Links
  Title: Links

  The link relations associated with the resource instance.

{ "type":"object", "properties":{ "links":{ "title":"Links", "type":"array", "description":"The link relations associated with the resource instance.", "items":{ "$ref":"#/components/schemas/link" } }, "__FLEX_Context_DisplayValue":{ "title":"Context Prompt", "type":"string", "description":"Context Prompt", "nullable":true, "x-hints":{ "updateable":"false", "DISPLAYHINT":"Hide", "FND_ACFF_IsReadOnly":"true", "FND_ACFF_AkaRealSegmentAttrName":"__FLEX_Context", "FND_ACFF_JavaType":"java.lang.String", "FND_ACFF_ListDisplayAttrName":"Name", "FND_ACFF_MaximumLength":"1024", "FND_ACFF_PreferredDisplayType":"TEXT_BOX" }, "x-oj":{ "transform":{ "path":"oj-sp/common-util/flex-util", "name":"transformFlexUIHints" } }, "x-queryable":true }, "InvoiceLineId":{ "type":"integer", "description":"Identifier of the invoice line.", "format":"int64", "nullable":false, "x-hints":{ "DISPLAYHINT":"Hide", "includeInCompactView":true, "precision":18, "fnd:GLOBALLY_UNIQUE":"true" }, "x-queryable":true }, "__FLEX_Context":{ "title":"Context Prompt", "maxLength":30, "type":"string", "description":"Context for flex fields.", "nullable":true, "x-hints":{ "FND_ACFF_ValueSetInfo":"_FLEX_ContextValueSet_Internal#INDEPENDENT", "controlType":"choice", "FND_ACFF_AkaAttrName":"__FLEX_Context_DisplayValue", "includeInCompactView":true, "FND_ACFF_IsDiscriminator":"true", "FND_ACFF_JavaType":"java.lang.String", "FND_ACFF_MaximumLength":"1024", "FND_ACFF_PreferredDisplayType":"TEXT_BOX" }, "x-oj":{ "transform":{ "path":"oj-sp/common-util/flex-util", "name":"transformFlexUIHints" } }, "x-queryable":true } } }

Nested Schema : Links

Type: array

Title: Links

The link relations associated with the resource instance.

Show Source

• Array of: object link

{ "title":"Links", "type":"array", "description":"The link relations associated with the resource instance.", "items":{ "$ref":"#/components/schemas/link" } }

Nested Schema : link

Type: object

Show Source

• href: string
  Title: hyperlink reference

  The URI to the related resource.
• kind: string
  Title: kind

  Allowed Values: [ "collection", "item", "describe", "other" ]

  The kind of the related resource.
• name: string
  Title: name

  The name of the link to the related resource.
• properties: object properties
• rel: string
  Title: relation

  Allowed Values: [ "self", "lov", "parent", "canonical", "child", "enclosure", "action", "custom" ]

  The name of the relation to the resource instance. Example: self.

{ "type":"object", "properties":{ "kind":{ "title":"kind", "type":"string", "description":"The kind of the related resource.", "enum":[ "collection", "item", "describe", "other" ] }, "rel":{ "title":"relation", "type":"string", "description":"The name of the relation to the resource instance. Example: self.", "enum":[ "self", "lov", "parent", "canonical", "child", "enclosure", "action", "custom" ] }, "name":{ "title":"name", "type":"string", "description":"The name of the link to the related resource." }, "href":{ "title":"hyperlink reference", "type":"string", "description":"The URI to the related resource." }, "properties":{ "type":"object", "properties":{ "changeIndicator":{ "type":"string", "description":"Change indicator or the ETag value of the resource instance." } } } } }

Nested Schema : properties

Type: object

Show Source

• changeIndicator: string
  Change indicator or the ETag value of the resource instance.

{ "type":"object", "properties":{ "changeIndicator":{ "type":"string", "description":"Change indicator or the ETag value of the resource instance." } } }

Nested Schema : projectContractInvoices-InvoiceLines-InvoiceLineDistributions-item-response

Type: object

Show Source

• BillingExtensionId: integer (int64)
  Title: Billing Extension ID

  Read Only: true

  Unique identifier of billing extension used for the transaction.
• BillingJobTitle: string
  Title: Billing Job Title

  Read Only: true

  Maximum Length: 80

  Indicates the title for the billing job.
• BillingResourceId: integer (int64)
  Title: Billing Resource ID

  Read Only: true

  Unique identifier of resource breakdown structure element.
• BillJobId: integer (int64)
  Title: Bill Job ID

  Read Only: true

  Unique identifier of the effective job used when invoicing a labor item as of the last time the expenditure item was invoiced.
• BillPlanId: integer (int64)
  Title: Bill Plan ID

  Read Only: true

  Unique identifier of the bill plan for the invoice distribution.
• BillRate: number
  Title: Bill Rate

  Read Only: true

  Bill rate used in deriving the transfer price if the transfer price was based on a rate defined in a bill rate schedule.
• BillSet: integer (int64)
  Title: Bill Set

  Read Only: true

  Number of the bill set which is defined in bill plan related to the invoice distribution.
• BillTransactionTypeCode: string
  Title: Billing Transaction Type Code

  Read Only: true

  Maximum Length: 30

  Indicates the code used to classify the type of bill transaction. Valid values are EI - Expenditure Item or EVT - Billing Event and defined in the lookup PJB_BILL_TRANSACTION_TYPE.
• ContractCurrencyBilledAmount: number
  Title: Invoice Amount in Contract Currency

  Read Only: true

  Amount billed in currency of the contract.
• ContractCurrencyCode: string
  Title: Contract Currency

  Read Only: true

  Maximum Length: 30

  Indicates the code of the currency for the contract related to the distribution.
• ContractCurrencyInvDateType: string
  Title: Contract Currency Invoice Date Type

  Read Only: true

  Maximum Length: 30

  Indicates the currency conversion date type used to convert the contract to the invoice currency.
• ContractCurrencyInvExchgDate: string (date)
  Title: Contract Currency Invoice Conversion Date

  Read Only: true

  Indicates the date used for the conversion of the rates on the contract for the invoice.
• ContractCurrencyInvExchgRate: number
  Title: Contract Currency Invoice Conversion Rate

  Read Only: true

  Indicates the rate used to convert the invoice amounts from the transaction currency to the contract currency.
• ContractCurrencyInvRateType: string
  Title: Contract Currency Rate Type Code

  Read Only: true

  Maximum Length: 30

  Indicates the code for the contract currency rate type.
• ContractLineId: integer (int64)
  Title: Contract Line ID

  Read Only: true

  Unique Identifier of the contract line for the invoice distribution.
• ContractLineNumber: string
  Title: Contract Line Number

  Read Only: true

  Maximum Length: 150

  Number of the contract line for the invoice distribution.
• CreditedDistributionId: integer (int64)
  Title: Origin of Adjustment

  Read Only: true

  Unique identifier of distribution credited by this distribution.
• CreditedInvoiceId: integer (int64)
  Title: Credited Invoice ID

  Read Only: true

  Unique identifier of invoice that is credited by this distribution.
• CreditedInvoiceLineId: integer (int64)
  Title: Credited Invoice Line ID

  Read Only: true

  Unique identifier of invoice line that is credited by this distribution.
• DocumentNumber: string
  Title: Document Number

  Read Only: true

  Maximum Length: 240

  Number that identifies a document on the bill plan of a grants contract.
• EmployeeBillingTitle: string
  Title: Employee Billing Title

  Read Only: true

  Maximum Length: 80

  Employee billing title.
• ICTpAmountTypeCode: string
  Title: Intercompany Transfer Price Amount Type

  Read Only: true

  Maximum Length: 30

  Amount type code used for an inter company price amount.
• ICTpBaseCode: string
  Title: Intercompany Transfer Price Base

  Read Only: true

  Maximum Length: 30

  Indicates the intercompany transfer price base code of an intercompany transfer invoice.
• IntendedUse: string
  Title: Intended Use

  Read Only: true

  Maximum Length: 240

  A classification of the products by tax authority for tax purposes.
• IntendedUseClassifId: integer (int64)
  Title: Intended Use Classification ID

  Read Only: true

  Unique identifier of the intended use classification.
• InvBurdenCompileSetId: integer (int64)
  Title: Invoice Burden Compile Set

  Read Only: true

  Unique identifier of the compiled set used to calculate a burden schedule. This only applies to invoice distributions based on billing event detail.
• InvDiscountReasonCode: string
  Title: Rate Change Reason

  Read Only: true

  Maximum Length: 30

  Reason code for discount override or rate override.
• InvDistributionTypeCode: string
  Title: Invoice Distribution Type

  Read Only: true

  Maximum Length: 30

  Indicates the code of the type used to classify invoice distribution. Valid values are WRITE_OFF, CONCESSION, CANCEL, STANDARD, and CREDIT_MEMO.
• InvLineDistNumber: integer (int64)
  Title: Invoice Distribution Number

  Read Only: true

  Number that identifies the invoice distribution.
• InvoiceAmountCalculationCode: string
  Title: Invoice Amount Calculation Code

  Read Only: true

  Maximum Length: 30

  Indicates the code for the invoice amount calculation. Valid values are I - Indirect, O - Overrides, E - Extension, B - Bill rates, L - Labor Multiplier.
• InvoiceCurrencyBilledAmount: number
  Title: Invoice Amount in Invoice Currency

  Read Only: true

  Amount billed in the Invoice currency amount.
• InvoiceCurrencyCode: string
  Title: Invoice Currency

  Read Only: true

  Maximum Length: 30

  Indicates the currency code for the invoice that is transferred to Oracle Receivables.
• InvoiceCurrencyCreditAmount: number
  Title: Invoice Currency Credit Amount

  Read Only: true

  Credit amount in the invoice currency.
• InvoiceCurrencyCreditPct: number
  Title: Credit Percentage in Invoice Currency

  Read Only: true

  Indicates the percent of credit in the invoice currency.
• InvoiceCurrencyDateType: string
  Title: Invoice Currency Conversion Date Type

  Read Only: true

  Maximum Length: 30

  Date type of the invoice currency.
• InvoiceCurrencyExchgDate: string (date)
  Title: Invoice Currency Conversion Date

  Read Only: true

  Indicates the exchange date for the conversion of the invoice currency.
• InvoiceCurrencyExchgRate: number
  Title: Invoice Currency Conversion Rate

  Read Only: true

  Exchange rate used for the invoice currency.
• InvoiceCurrencyRateType: string
  Title: Invoice Currency Conversion Rate Type

  Read Only: true

  Maximum Length: 30

  Rate type of the invoice currency.
• InvoiceDate: string (date)
  Title: Date

  Read Only: true

  The invoice date passed to Oracle Receivables, which is used to calculate the invoice due date. Upon release of the invoice, the default value is the released date. You can override the invoice date at the time of release.
• InvoiceDiscountPercentage: number
  Title: Discount Percentage

  Read Only: true

  Indicates a discount percentage, expressed as a proportion multiplied by 100, that is used to calculate the adjusted invoice and rate. The percentage used is based on the markup defined in the bill rate schedule.
• InvoiceDistId: integer (int64)
  Title: Invoice Distribution ID

  Unique identifier of the invoice distribution.
• InvoiceLaborMultiplier: number
  Title: Labor Multiplier

  Read Only: true

  A multiplier that is assigned to the contract line, and is used to calculate the invoice amount for labor items by applying the multipler to the raw cost of the labor items.
• InvoiceMarkupPercentage: number
  Title: Markup Percentage

  Read Only: true

  Indicates the markup percentage used to calculate the adjusted invoice and rate. The percentage used is based on the markup defined in the bill rate schedule.
• LedgerCurrencyBilledAmount: number
  Title: Invoice Amount in Ledger Currency

  Read Only: true

  Amount billed in the currency of the ledger.
• LedgerCurrencyCode: string
  Title: Ledger Currency

  Read Only: true

  Maximum Length: 30

  Ledger currency code.
• LedgerCurrencyInvDateType: string
  Title: Ledger Currency Invoice Date Type

  Read Only: true

  Maximum Length: 30

  Date type of the ledger currency.
• LedgerCurrencyInvExchgDate: string (date)
  Title: Ledger Currency Conversion Date

  Read Only: true

  Indicates the conversion date used to convert the invoice to the ledger currency.
• LedgerCurrencyInvExchgRate: number
  Title: Ledger Currency Conversion Rate

  Read Only: true

  Indicates the conversion currency rate used to convert the invoice to the ledger currency.
• LedgerCurrencyInvRateType: string
  Title: Ledger Currency Invoice Rate Type

  Read Only: true

  Maximum Length: 30

  Indicates the conversion currency rate type used to convert the invoice to the ledger currency.
• LinkedProjectId: integer (int64)
  Title: Associated Project ID

  Read Only: true

  Unique identifier of project that is linked to the contract line associated to the invoice distribution.
• LinkedProjectName: string
  Title: Associated Project Name

  Read Only: true

  Maximum Length: 240

  Name of the project that is linked to the contract line associated to the invoice distribution.
• LinkedProjectNumber: string
  Title: Associated Project Number

  Read Only: true

  Maximum Length: 25

  Number of the project that is linked to the contract line associated to the invoice distribution.
• LinkedTaskId: integer (int64)
  Title: Associated Task ID

  Read Only: true

  Unique identifier of the task that is linked to the contract line associated to the invoice distribution.
• LinkedTaskName: string
  Title: Associated Task Name

  Read Only: true

  Maximum Length: 255

  Name of the task that is linked to the contract line associated to the invoice distribution.
• LinkedTaskNumber: string
  Title: Associated Task Number

  Read Only: true

  Maximum Length: 100

  Number of the project task that is linked to the contract line associated to the invoice distribution.
• links: array Links
  Title: Links

  The link relations associated with the resource instance.
• LocNumber: string
  Title: LOC Number

  Read Only: true

  Maximum Length: 240

  Number that identifies a letter of credit on the bill plan of a grants contract.
• ProductCategory: string
  Title: Product Category

  Read Only: true

  Maximum Length: 240

  A classification of products used for tax purposes.
• ProductFcCategoryId: integer (int64)
  Title: Product FC Category ID

  Read Only: true

  Unique identifier of the product fiscal classification category.
• ProductFiscClassification: string
  Title: Product Fiscal Classification

  Read Only: true

  Maximum Length: 240

  A classification of the products based on the inventory item category by the tax authority for tax purposes.
• ProductType: string
  Title: Product Type

  Read Only: true

  Maximum Length: 240

  This value is another product related tax classification. The value of product type specifies whether the transaction line is for a good, or a service, or it is a memo line.
• ProjectCurrencyBilledAmount: number
  Title: Invoice Amount in Project Currency

  Read Only: true

  Amount billed in the currency of the project.
• ProjectCurrencyCode: string
  Title: Project Currency

  Read Only: true

  Maximum Length: 30

  Indicates the currency code of the project.
• ProjectCurrencyInvDateType: string
  Title: Project Currency Invoice Date Type

  Read Only: true

  Maximum Length: 30

  Date type used for conversion to the project currency.
• ProjectCurrencyInvExchgDate: string (date)
  Title: Project Currency Conversion Date

  Read Only: true

  Indicates the currency conversion date used to convert the invoice distribution to the project currency.
• ProjectCurrencyInvExchgRate: number
  Title: Project Currency Conversion Rate

  Read Only: true

  Indicates the currency conversion rate used to convert the invoice currency to the project currency.
• ProjectCurrencyInvRateType: string
  Title: Project Currency Invoice Rate Type

  Read Only: true

  Maximum Length: 30

  Indicates the currency conversion rate type used to convert the invoice to the project currency.
• ProviderLegalEntityId: integer (int64)
  Title: Provider Legal Entity ID

  Read Only: true

  Unique identifier of the provider legal entity.
• Quantity: integer
  Title: Quantity

  Read Only: true

  Indicates the quantity of the source expenditure item for invoice transactions created from expenditure items.
• ReceiverLegalEntityId: integer (int64)
  Title: Receiver Legal Entity ID

  Read Only: true

  Unique identifier of the receiver legal entity.
• TpInvRulePercentage: number
  Title: Transfer Price Invoice Rule Percentage

  Read Only: true

  Indicates the applied percentage value from the transfer price rule used to create an intercompany invoice.
• TpInvSchLinePercentage: number
  Title: Transfer Price Invoice Schedule Line Percentage

  Read Only: true

  The applied percentage value from the transfer price schedule line used to create an intercompany invoice.
• TransactionBusinessCategory: string
  Title: Transaction Business Category

  Read Only: true

  Maximum Length: 240

  A classification or categorization of a transaction for tax purposes as required by a tax authority.
• TransactionCurrencyBilledAmount: number
  Title: Billed Amount in Transaction Currency

  Read Only: true

  Billed amount in the transaction currency.
• TransactionCurrencyCode: string
  Title: Transaction Currency

  Read Only: true

  Maximum Length: 30

  Transaction currency for the expenditure or events.
• TransactionDate: string (date)
  Title: Transaction Date

  Read Only: true

  Date when transaction occurs.
• TransactionId: integer (int64)
  Title: Transaction ID

  Read Only: true

  Unique identifier of the expenditure item or event related to the invoice distribution.
• TransactionProjectId: integer (int64)
  Title: Transaction Project ID

  Read Only: true

  Unique identifier of the project related to the invoice distribution transaction.
• TransactionProjectName: string
  Title: Transaction Project Name

  Read Only: true

  Maximum Length: 240

  Name of the project related to the invoice distribution transaction.
• TransactionProjectNumber: string
  Title: Transaction Project Number

  Read Only: true

  Maximum Length: 25

  Number of the project related to the invoice distribution transaction.
• TransactionTaskId: integer (int64)
  Title: Transaction Task ID

  Read Only: true

  Unique identifier of the project task related to the invoice distribution transaction.
• TransactionTaskName: string
  Title: Transaction Task Name

  Read Only: true

  Maximum Length: 255

  Name of the project task related to the invoice distribution transaction.
• TransactionTaskNumber: string
  Title: Transaction Task Number

  Read Only: true

  Maximum Length: 100

  Number of the project task related to the invoice distribution transaction.
• TransactionTypeId: integer (int64)
  Title: Transaction Type ID

  Read Only: true

  Unique identifier of the Event Type or Expenditure Item Type related to the invoice distribution.
• UserDefinedFiscalClass: string
  Title: User-Defined Fiscal Classification

  Read Only: true

  Maximum Length: 240

  Indicates the default taxation country.

{ "type":"object", "properties":{ "LedgerCurrencyBilledAmount":{ "title":"Invoice Amount in Ledger Currency", "type":"number", "description":"Amount billed in the currency of the ledger.", "nullable":true, "readOnly":true, "x-queryable":true }, "LedgerCurrencyInvExchgRate":{ "title":"Ledger Currency Conversion Rate", "type":"number", "description":"Indicates the conversion currency rate used to convert the invoice to the ledger currency.", "nullable":true, "readOnly":true, "x-queryable":true }, "InvoiceCurrencyCreditAmount":{ "title":"Invoice Currency Credit Amount", "type":"number", "description":"Credit amount in the invoice currency.", "nullable":true, "readOnly":true, "x-queryable":true }, "ContractLineId":{ "title":"Contract Line ID", "type":"integer", "description":"Unique Identifier of the contract line for the invoice distribution.", "format":"int64", "nullable":false, "readOnly":true, "x-hints":{ "precision":18 }, "x-queryable":true }, "TransactionTypeId":{ "title":"Transaction Type ID", "type":"integer", "description":"Unique identifier of the Event Type or Expenditure Item Type related to the invoice distribution.", "format":"int64", "nullable":true, "readOnly":true, "x-hints":{ "precision":18 }, "x-queryable":true }, "TransactionProjectNumber":{ "title":"Transaction Project Number", "maxLength":25, "type":"string", "description":"Number of the project related to the invoice distribution transaction.", "nullable":false, "readOnly":true, "x-queryable":true }, "BillingJobTitle":{ "title":"Billing Job Title", "maxLength":80, "type":"string", "description":"Indicates the title for the billing job.", "nullable":true, "readOnly":true, "x-queryable":true }, "ProjectCurrencyInvExchgDate":{ "title":"Project Currency Conversion Date", "type":"string", "description":"Indicates the currency conversion date used to convert the invoice distribution to the project currency.", "format":"date", "nullable":true, "readOnly":true, "x-queryable":true }, "LedgerCurrencyInvDateType":{ "title":"Ledger Currency Invoice Date Type", "maxLength":30, "type":"string", "description":"Date type of the ledger currency.", "nullable":true, "readOnly":true, "x-queryable":true }, "InvoiceLaborMultiplier":{ "title":"Labor Multiplier", "type":"number", "description":"A multiplier that is assigned to the contract line, and is used to calculate the invoice amount for labor items by applying the multipler to the raw cost of the labor items.", "nullable":true, "readOnly":true, "x-queryable":true }, "ProjectCurrencyCode":{ "title":"Project Currency", "maxLength":30, "type":"string", "description":"Indicates the currency code of the project.", "nullable":true, "readOnly":true, "x-queryable":true }, "TransactionTaskNumber":{ "title":"Transaction Task Number", "maxLength":100, "type":"string", "description":"Number of the project task related to the invoice distribution transaction.", "nullable":true, "readOnly":true, "x-queryable":true }, "IntendedUseClassifId":{ "title":"Intended Use Classification ID", "type":"integer", "description":"Unique identifier of the intended use classification.", "format":"int64", "nullable":true, "readOnly":true, "x-hints":{ "precision":18 }, "x-queryable":true }, "LinkedTaskName":{ "title":"Associated Task Name", "maxLength":255, "type":"string", "description":"Name of the task that is linked to the contract line associated to the invoice distribution.", "nullable":false, "readOnly":true, "x-queryable":true }, "EmployeeBillingTitle":{ "title":"Employee Billing Title", "maxLength":80, "type":"string", "description":"Employee billing title.", "nullable":true, "readOnly":true, "x-queryable":true }, "BillSet":{ "title":"Bill Set", "type":"integer", "description":"Number of the bill set which is defined in bill plan related to the invoice distribution.", "format":"int64", "nullable":true, "readOnly":true, "x-hints":{ "precision":18 }, "x-queryable":true }, "CreditedInvoiceId":{ "title":"Credited Invoice ID", "type":"integer", "description":"Unique identifier of invoice that is credited by this distribution.", "format":"int64", "nullable":true, "readOnly":true, "x-hints":{ "precision":18 }, "x-queryable":true }, "TransactionProjectName":{ "title":"Transaction Project Name", "maxLength":240, "type":"string", "description":"Name of the project related to the invoice distribution transaction.", "nullable":false, "readOnly":true, "x-queryable":true }, "links":{ "title":"Links", "type":"array", "description":"The link relations associated with the resource instance.", "items":{ "$ref":"#/components/schemas/link" } }, "InvDistributionTypeCode":{ "title":"Invoice Distribution Type", "maxLength":30, "type":"string", "description":"Indicates the code of the type used to classify invoice distribution. Valid values are WRITE_OFF, CONCESSION, CANCEL, STANDARD, and CREDIT_MEMO.", "nullable":true, "readOnly":true, "x-queryable":true }, "InvoiceCurrencyDateType":{ "title":"Invoice Currency Conversion Date Type", "maxLength":30, "type":"string", "description":"Date type of the invoice currency.", "nullable":true, "readOnly":true, "x-queryable":true }, "CreditedDistributionId":{ "title":"Origin of Adjustment", "type":"integer", "description":"Unique identifier of distribution credited by this distribution.", "format":"int64", "nullable":true, "readOnly":true, "x-hints":{ "precision":18 }, "x-queryable":true }, "ProviderLegalEntityId":{ "title":"Provider Legal Entity ID", "type":"integer", "description":"Unique identifier of the provider legal entity.", "format":"int64", "nullable":true, "readOnly":true, "x-hints":{ "precision":18 }, "x-queryable":true }, "InvoiceAmountCalculationCode":{ "title":"Invoice Amount Calculation Code", "maxLength":30, "type":"string", "description":"Indicates the code for the invoice amount calculation. Valid values are I - Indirect, O - Overrides, E - Extension, B - Bill rates, L - Labor Multiplier.", "nullable":true, "readOnly":true, "x-queryable":true }, "ReceiverLegalEntityId":{ "title":"Receiver Legal Entity ID", "type":"integer", "description":"Unique identifier of the receiver legal entity.", "format":"int64", "nullable":true, "readOnly":true, "x-hints":{ "precision":18 }, "x-queryable":true }, "InvoiceCurrencyExchgDate":{ "title":"Invoice Currency Conversion Date", "type":"string", "description":"Indicates the exchange date for the conversion of the invoice currency.", "format":"date", "nullable":true, "readOnly":true, "x-queryable":true }, "UserDefinedFiscalClass":{ "title":"User-Defined Fiscal Classification", "maxLength":240, "type":"string", "description":"Indicates the default taxation country.", "nullable":true, "readOnly":true, "x-queryable":true }, "ProductFcCategoryId":{ "title":"Product FC Category ID", "type":"integer", "description":"Unique identifier of the product fiscal classification category.", "format":"int64", "nullable":true, "readOnly":true, "x-hints":{ "precision":18 }, "x-queryable":true }, "ProductType":{ "title":"Product Type", "maxLength":240, "type":"string", "description":"This value is another product related tax classification. The value of product type specifies whether the transaction line is for a good, or a service, or it is a memo line.", "nullable":true, "readOnly":true, "x-queryable":true }, "ProjectCurrencyBilledAmount":{ "title":"Invoice Amount in Project Currency", "type":"number", "description":"Amount billed in the currency of the project.", "nullable":true, "readOnly":true, "x-queryable":true }, "ProjectCurrencyInvExchgRate":{ "title":"Project Currency Conversion Rate", "type":"number", "description":"Indicates the currency conversion rate used to convert the invoice currency to the project currency.", "nullable":true, "readOnly":true, "x-queryable":true }, "TransactionCurrencyBilledAmount":{ "title":"Billed Amount in Transaction Currency", "type":"number", "description":"Billed amount in the transaction currency.", "nullable":true, "readOnly":true, "x-queryable":true }, "LinkedTaskNumber":{ "title":"Associated Task Number", "maxLength":100, "type":"string", "description":"Number of the project task that is linked to the contract line associated to the invoice distribution.", "nullable":true, "readOnly":true, "x-queryable":true }, "InvoiceDiscountPercentage":{ "title":"Discount Percentage", "type":"number", "description":"Indicates a discount percentage, expressed as a proportion multiplied by 100, that is used to calculate the adjusted invoice and rate. The percentage used is based on the markup defined in the bill rate schedule.", "nullable":true, "readOnly":true, "x-queryable":true }, "TransactionTaskName":{ "title":"Transaction Task Name", "maxLength":255, "type":"string", "description":"Name of the project task related to the invoice distribution transaction.", "nullable":false, "readOnly":true, "x-queryable":true }, "TransactionId":{ "title":"Transaction ID", "type":"integer", "description":"Unique identifier of the expenditure item or event related to the invoice distribution.", "format":"int64", "nullable":false, "readOnly":true, "x-hints":{ "precision":18 }, "x-queryable":true }, "BillTransactionTypeCode":{ "title":"Billing Transaction Type Code", "maxLength":30, "type":"string", "description":"Indicates the code used to classify the type of bill transaction. Valid values are EI - Expenditure Item or EVT - Billing Event and defined in the lookup PJB_BILL_TRANSACTION_TYPE.", "nullable":true, "readOnly":true, "x-queryable":true }, "ICTpAmountTypeCode":{ "title":"Intercompany Transfer Price Amount Type", "maxLength":30, "type":"string", "description":"Amount type code used for an inter company price amount.", "nullable":true, "readOnly":true, "x-queryable":true }, "InvoiceCurrencyBilledAmount":{ "title":"Invoice Amount in Invoice Currency", "type":"number", "description":"Amount billed in the Invoice currency amount.", "nullable":true, "readOnly":true, "x-queryable":true }, "ContractCurrencyInvRateType":{ "title":"Contract Currency Rate Type Code", "maxLength":30, "type":"string", "description":"Indicates the code for the contract currency rate type.", "nullable":true, "readOnly":true, "x-queryable":true }, "LocNumber":{ "title":"LOC Number", "maxLength":240, "type":"string", "description":"Number that identifies a letter of credit on the bill plan of a grants contract.", "nullable":true, "readOnly":true, "x-queryable":true }, "LedgerCurrencyInvExchgDate":{ "title":"Ledger Currency Conversion Date", "type":"string", "description":"Indicates the conversion date used to convert the invoice to the ledger currency.", "format":"date", "nullable":true, "readOnly":true, "x-queryable":true }, "ContractCurrencyBilledAmount":{ "title":"Invoice Amount in Contract Currency", "type":"number", "description":"Amount billed in currency of the contract.", "nullable":true, "readOnly":true, "x-queryable":true }, "ProductCategory":{ "title":"Product Category", "maxLength":240, "type":"string", "description":"A classification of products used for tax purposes.", "nullable":true, "readOnly":true, "x-queryable":true }, "InvoiceDistId":{ "title":"Invoice Distribution ID", "type":"integer", "description":"Unique identifier of the invoice distribution.", "format":"int64", "nullable":false, "x-hints":{ "precision":18 }, "x-queryable":true }, "ContractCurrencyInvExchgRate":{ "title":"Contract Currency Invoice Conversion Rate", "type":"number", "description":"Indicates the rate used to convert the invoice amounts from the transaction currency to the contract currency.", "nullable":true, "readOnly":true, "x-queryable":true }, "TpInvSchLinePercentage":{ "title":"Transfer Price Invoice Schedule Line Percentage", "type":"number", "description":"The applied percentage value from the transfer price schedule line used to create an intercompany invoice.", "nullable":true, "readOnly":true, "x-queryable":true }, "ContractCurrencyInvDateType":{ "title":"Contract Currency Invoice Date Type", "maxLength":30, "type":"string", "description":"Indicates the currency conversion date type used to convert the contract to the invoice currency.", "nullable":true, "readOnly":true, "x-queryable":true }, "ContractCurrencyCode":{ "title":"Contract Currency", "maxLength":30, "type":"string", "description":"Indicates the code of the currency for the contract related to the distribution.", "nullable":true, "readOnly":true, "x-queryable":true }, "InvoiceCurrencyCode":{ "title":"Invoice Currency", "maxLength":30, "type":"string", "description":"Indicates the currency code for the invoice that is transferred to Oracle Receivables.", "nullable":true, "readOnly":true, "x-queryable":true }, "TpInvRulePercentage":{ "title":"Transfer Price Invoice Rule Percentage", "type":"number", "description":"Indicates the applied percentage value from the transfer price rule used to create an intercompany invoice.", "nullable":true, "readOnly":true, "x-queryable":true }, "LinkedTaskId":{ "title":"Associated Task ID", "type":"integer", "description":"Unique identifier of the task that is linked to the contract line associated to the invoice distribution.", "format":"int64", "nullable":true, "readOnly":true, "x-hints":{ "precision":18 }, "x-queryable":true }, "CreditedInvoiceLineId":{ "title":"Credited Invoice Line ID", "type":"integer", "description":"Unique identifier of invoice line that is credited by this distribution.", "format":"int64", "nullable":true, "readOnly":true, "x-hints":{ "precision":18 }, "x-queryable":true }, "ProjectCurrencyInvDateType":{ "title":"Project Currency Invoice Date Type", "maxLength":30, "type":"string", "description":"Date type used for conversion to the project currency.", "nullable":true, "readOnly":true, "x-queryable":true }, "TransactionProjectId":{ "title":"Transaction Project ID", "type":"integer", "description":"Unique identifier of the project related to the invoice distribution transaction.", "format":"int64", "nullable":true, "readOnly":true, "x-hints":{ "precision":18 }, "x-queryable":true }, "InvoiceMarkupPercentage":{ "title":"Markup Percentage", "type":"number", "description":"Indicates the markup percentage used to calculate the adjusted invoice and rate. The percentage used is based on the markup defined in the bill rate schedule.", "nullable":true, "readOnly":true, "x-queryable":true }, "LinkedProjectNumber":{ "title":"Associated Project Number", "maxLength":25, "type":"string", "description":"Number of the project that is linked to the contract line associated to the invoice distribution.", "nullable":false, "readOnly":true, "x-queryable":true }, "IntendedUse":{ "title":"Intended Use", "maxLength":240, "type":"string", "description":"A classification of the products by tax authority for tax purposes.", "nullable":true, "readOnly":true, "x-queryable":true }, "InvoiceCurrencyExchgRate":{ "title":"Invoice Currency Conversion Rate", "type":"number", "description":"Exchange rate used for the invoice currency.", "nullable":true, "readOnly":true, "x-queryable":true }, "InvoiceCurrencyRateType":{ "title":"Invoice Currency Conversion Rate Type", "maxLength":30, "type":"string", "description":"Rate type of the invoice currency.", "nullable":true, "readOnly":true, "x-queryable":true }, "TransactionTaskId":{ "title":"Transaction Task ID", "type":"integer", "description":"Unique identifier of the project task related to the invoice distribution transaction.", "format":"int64", "nullable":true, "readOnly":true, "x-hints":{ "precision":18 }, "x-queryable":true }, "ProjectCurrencyInvRateType":{ "title":"Project Currency Invoice Rate Type", "maxLength":30, "type":"string", "description":"Indicates the currency conversion rate type used to convert the invoice to the project currency.", "nullable":true, "readOnly":true, "x-queryable":true }, "LedgerCurrencyCode":{ "title":"Ledger Currency", "maxLength":30, "type":"string", "description":"Ledger currency code.", "nullable":true, "readOnly":true, "x-queryable":true }, "InvoiceDate":{ "title":"Date", "type":"string", "description":"The invoice date passed to Oracle Receivables, which is used to calculate the invoice due date. Upon release of the invoice, the default value is the released date. You can override the invoice date at the time of release.", "format":"date", "nullable":true, "readOnly":true, "x-queryable":true }, "TransactionDate":{ "title":"Transaction Date", "type":"string", "description":"Date when transaction occurs.", "format":"date", "nullable":true, "readOnly":true, "x-queryable":true }, "BillJobId":{ "title":"Bill Job ID", "type":"integer", "description":"Unique identifier of the effective job used when invoicing a labor item as of the last time the expenditure item was invoiced.", "format":"int64", "nullable":true, "readOnly":true, "x-hints":{ "precision":18 }, "x-queryable":true }, "InvLineDistNumber":{ "title":"Invoice Distribution Number", "type":"integer", "description":"Number that identifies the invoice distribution.", "format":"int64", "nullable":true, "readOnly":true, "x-hints":{ "precision":18 }, "x-queryable":true }, "BillPlanId":{ "title":"Bill Plan ID", "type":"integer", "description":"Unique identifier of the bill plan for the invoice distribution.", "format":"int64", "nullable":false, "readOnly":true, "x-hints":{ "precision":18 }, "x-queryable":true }, "Quantity":{ "title":"Quantity", "type":"integer", "description":"Indicates the quantity of the source expenditure item for invoice transactions created from expenditure items.", "nullable":true, "readOnly":true, "x-queryable":true }, "DocumentNumber":{ "title":"Document Number", "maxLength":240, "type":"string", "description":"Number that identifies a document on the bill plan of a grants contract.", "nullable":true, "readOnly":true, "x-queryable":true }, "TransactionCurrencyCode":{ "title":"Transaction Currency", "maxLength":30, "type":"string", "description":"Transaction currency for the expenditure or events.", "nullable":true, "readOnly":true, "x-queryable":true }, "BillingExtensionId":{ "title":"Billing Extension ID", "type":"integer", "description":"Unique identifier of billing extension used for the transaction.", "format":"int64", "nullable":true, "readOnly":true, "x-hints":{ "precision":18 }, "x-queryable":true }, "TransactionBusinessCategory":{ "title":"Transaction Business Category", "maxLength":240, "type":"string", "description":"A classification or categorization of a transaction for tax purposes as required by a tax authority.", "nullable":true, "readOnly":true, "x-queryable":true }, "LedgerCurrencyInvRateType":{ "title":"Ledger Currency Invoice Rate Type", "maxLength":30, "type":"string", "description":"Indicates the conversion currency rate type used to convert the invoice to the ledger currency.", "nullable":true, "readOnly":true, "x-queryable":true }, "BillingResourceId":{ "title":"Billing Resource ID", "type":"integer", "description":"Unique identifier of resource breakdown structure element.", "format":"int64", "nullable":true, "readOnly":true, "x-hints":{ "precision":18 }, "x-queryable":true }, "ContractLineNumber":{ "title":"Contract Line Number", "maxLength":150, "type":"string", "description":"Number of the contract line for the invoice distribution.", "nullable":false, "readOnly":true, "x-queryable":true }, "InvoiceCurrencyCreditPct":{ "title":"Credit Percentage in Invoice Currency", "type":"number", "description":"Indicates the percent of credit in the invoice currency.", "nullable":true, "readOnly":true, "x-queryable":true }, "ProductFiscClassification":{ "title":"Product Fiscal Classification", "maxLength":240, "type":"string", "description":"A classification of the products based on the inventory item category by the tax authority for tax purposes.", "nullable":true, "readOnly":true, "x-queryable":true }, "LinkedProjectId":{ "title":"Associated Project ID", "type":"integer", "description":"Unique identifier of project that is linked to the contract line associated to the invoice distribution.", "format":"int64", "nullable":true, "readOnly":true, "x-hints":{ "precision":18 }, "x-queryable":true }, "InvBurdenCompileSetId":{ "title":"Invoice Burden Compile Set", "type":"integer", "description":"Unique identifier of the compiled set used to calculate a burden schedule. This only applies to invoice distributions based on billing event detail.", "format":"int64", "nullable":true, "readOnly":true, "x-hints":{ "precision":18 }, "x-queryable":true }, "ICTpBaseCode":{ "title":"Intercompany Transfer Price Base", "maxLength":30, "type":"string", "description":"Indicates the intercompany transfer price base code of an intercompany transfer invoice.", "nullable":true, "readOnly":true, "x-queryable":true }, "BillRate":{ "title":"Bill Rate", "type":"number", "description":"Bill rate used in deriving the transfer price if the transfer price was based on a rate defined in a bill rate schedule.", "nullable":true, "readOnly":true, "x-queryable":true }, "ContractCurrencyInvExchgDate":{ "title":"Contract Currency Invoice Conversion Date", "type":"string", "description":"Indicates the date used for the conversion of the rates on the contract for the invoice.", "format":"date", "nullable":true, "readOnly":true, "x-queryable":true }, "InvDiscountReasonCode":{ "title":"Rate Change Reason", "maxLength":30, "type":"string", "description":"Reason code for discount override or rate override.", "nullable":true, "readOnly":true, "x-queryable":true }, "LinkedProjectName":{ "title":"Associated Project Name", "maxLength":240, "type":"string", "description":"Name of the project that is linked to the contract line associated to the invoice distribution.", "nullable":false, "readOnly":true, "x-queryable":true } } }

Nested Schema : Links

Type: array

Title: Links

The link relations associated with the resource instance.

Show Source

• Array of: object link

{ "title":"Links", "type":"array", "description":"The link relations associated with the resource instance.", "items":{ "$ref":"#/components/schemas/link" } }

Links

InvoiceLineDff

Operation: /fscmRestApi/resources/11.13.18.05/projectContractInvoices/{InvoiceId}/child/InvoiceLines/{InvoiceLineId}/child/InvoiceLineDff

Parameters:

• InvoiceId: $request.path.InvoiceId
• InvoiceLineId: $request.path.InvoiceLineId

A listing of all the descriptive flexfields available for invoice lines.

InvoiceLineDistributions

Operation: /fscmRestApi/resources/11.13.18.05/projectContractInvoices/{InvoiceId}/child/InvoiceLines/{InvoiceLineId}/child/InvoiceLineDistributions

Parameters:

• InvoiceId: $request.path.InvoiceId
• InvoiceLineId: $request.path.InvoiceLineId

The Invoice Line Distributions resource is used to view the details of invoice line distributions.

Back to Top

Examples

The following example shows how to get an invoice line on a project contract 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/projectContractInvoices/100100085970023/child/InvoiceLines/100100085970024

Example of Response Body

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

{ "items": [ { "LedgerCurrencyLineAmount": null, "LedgerCurrencyCode": null, "AssessableValue": 2500, "BillPlanId": null, "BillSet": 1, "ContractCurrencyCode": "USD", "ContractCurrencyLineAmount": 2500, "ContractLineId": 300100169214487, "CreditedInvoiceLineId": null, "DocumentNumber": null, "Exception": "N", "ExpenditureOrgId": null, "ExpenditureTypeId": null, "ApTransferErrorCode": null, "ApTransferStatusCode": null, "IntendedUse": null, "IntendedUseClassifId": null, "InvoiceCurrencyLineAmount": 2500, "InvoiceCurrencyCode": "USD", "InvoiceFormatId": 100000011213026, "LineDescription": " 1 Bug 28128344 Fixture Install 1 2017-01-01 ", "InvoiceLineId": 100100085970024, "InvoiceLineNumber": 1, "InvoiceLineType": "STANDARD", "LocNumber": null, "OutputTaxAmount": 500, "OutputTaxClassCode": "VAT20", "OutputTaxExempt": "S", "OutputTaxExmtCertNumber": null, "OutputTaxExmtReasonCode": null, "PaymentTermId": 4, "ProductFcCategoryId": null, "ProductCategory": null, "ProductFiscClassification": null, "ProductType": null, "ReceiverProjectId": null, "ReceiverTaskId": null, "ShipToContactId": null, "ShipToCustomerId": 1005, "ShipToSiteId": 1024, "TranslatedText": null, "TransactionBusinessCategory": "SALES_TRANSACTION", "UserDefinedFiscalClass": null, "WorkTypeId": null, "InvoiceLineTypeMeaning": "Standard invoice line", "ContractLineNumber": "1", "InvoiceFormatName": "Cont Line Project/Task Event", "PaymentTermName": "30 Net", "WorkTypeName": null, "LinkedProjectId": 300100169214449, "LinkedTaskId": 100100085968379, "LinkedTaskName": "Fixture Install", "LinkedTaskNumber": "2.3", "LinkedProjectName": " Bug 28128344", "LinkedProjectNumber": " Bug 28128344" }

Back to Top