Jump to

• Request
• Response
• Examples

Get all project contract invoices

get

/fscmRestApi/resources/11.13.18.05/projectContractInvoices

Request

Query Parameters

• expand: string
  When this parameter is provided, the specified children are included in the resource payload (instead of just a link). The value of this query parameter is "all" or "". More than one child can be specified using comma as a separator. Example: ?expand=Employees,Localizations. Nested children can also be provided following the format "Child.NestedChild" (Example: ?expand=Employees.Managers). If a nested child is provided (Example: Employees.Managers), the missing children will be processed implicitly. For example, "?expand=Employees.Managers" is the same as "?expand=Employees,Employees.Managers" (which will expand Employees and Managers).
• fields: string
  This parameter filters the resource fields. Only the specified fields are returned, which means that if no fields are specified, no fields are returned (useful to get only the links). If an indirect child resource is provided (Example: Employees.Managers), the missing children will be processed implicitly. For example, "?fields=Employees.Managers:Empname" is the same as "?fields=;Employees:;Employees.Managers:Empname" (which will only return the "Empname" field for Managers). the value of this query parameter is a list of resource fields. The attribute can be a direct (Example: Employees) or indirect (Example: Employees.Managers) child. It cannot be combined with expand query parameter. If both are provided, only fields will be considered.
  
  Format: ?fields=Attribute1,Attribute2
  
  Format for fields in child resource: ?fields=Accessor1:Attribute1,Attribute2
• finder: string
  Used as a predefined finder to search the collection.
  
  Format: ?finder=<finderName>;<variableName>=<variableValue>,<variableName2>=<variableValue2>
  
  The following are the available finder names and corresponding finder variables:
  
  

  • PrimaryKey: Finds the project contract invoice with the specified primary key.
    Finder Variables:
    • InvoiceId; integer; Unique identifier of the invoice.
• limit: integer
  This parameter restricts the number of resources returned inside the resource collection. If the limit exceeds the resource count then the framework will only return the available resources.
• links: string
  This parameter can be used to show only certain links while accessing a singular resource or a resource collection. The parameter value format is a comma-separated list of : <link_relation>
  
  Example:
  self,canonical
  
• offset: integer
  Used to define the starting position of the resource collection. If offset exceeds the resource count then no resources are returned. Default value is 0.
• onlyData: boolean
  The resource item payload will be filtered in order to contain only data (no links section, for example).
• orderBy: string
  This parameter orders a resource collection based on the specified fields. The parameter value is a comma-separated string of attribute names, each optionally followed by a colon and "asc" or "desc". Specify "asc" for ascending and "desc" for descending. The default value is "asc". For example, ?orderBy=field1:asc,field2:desc
• q: string
  This query parameter defines the where clause. The resource collection will be queried using the provided expressions. The value of this query parameter is one or more expressions. Example: ?q=Deptno>=10 and <= 30;Loc!=NY
  
  Format: ?q=expression1;expression2
  
  You can use these queryable attributes to filter this collection resource using the q query parameter:
  

  • AcceptedDate; string; The date and time when the invoice was accepted.
  • AccountingDate; string; The date within a General Ledger (GL) accounting period to which the invoice transactions are posted. The GL date is set by the Transfer Invoice process and it is the date of the first future or open GL period in Oracle Receivables for the invoice date.
  • AccountingPeriodName; string; Name of the General Ledger (GL) period for the GL Date attribute.
  • ApTransferStatusCode; string; Indicates the status of the transfer of the invoice to Accounts Payable (AP). Valid values are P - Pending, A - Accepted, and R - Rejected.
  • ApprovedDate; string; The date on which the invoice is approved.
  • ApprovedbyPerson; string; Name of the person who approved the invoice.
  • ApprovedbyPersonId; integer; Unique identifier of the person who approved the invoice.
  • BillFromDate; string; The date through which to invoice the project. Expenditure items with the expenditure item date on or after the bill from date and events with completion dates on or after the bill through date may be included on an invoice.
  • BillSet; integer; Identifier of a set of invoices created together in the same run which must be released at the same time.
  • BillToAccountNumber; string; Account number of the bill-to customer.
  • BillToAddress; string; Address of the bill-to customer.
  • BillToContactId; integer; Unique identifier of the contact who is a representative for the bill-to customer on the bill plan.
  • BillToContactName; string; Name of the contact who is a representative for the bill-to customer on the bill plan.
  • BillToCustomerId; integer; Unique identifier of the bill-to customer on the invoice.
  • BillToCustomerName; string; Name of the bill-to customer on the invoice.
  • BillToDate; string; The date through which to invoice the project. Expenditure items with the expenditure item date on or before the bill to date and events with completion dates on or before the bill through date may be included on an invoice.
  • BillToSite; string; Address of the bill-to customer.
  • BillToSiteId; integer; Unique identifier of the customer address.
  • BillingTypeCode; string; Indicates the code used to classify the type of billing. Valid values are EX - External, IP - Interproject, and IC - Intercompany.
  • Canceled; string; Indicates that the invoice was cancelled.
  • ContractId; integer; Unique identifier of the contract for the invoice.
  • ContractNumber; string; Number that uniquely identifies the contract for the invoice.
  • ContractTypeId; integer; Unique identifier for the contract type.
  • ContractTypeName; string; Name of the contract type for the contract on the invoice.
  • CreditMemoReasonCode; string; Indicates the code for the reason to create a credit memo.
  • CreditMemoReasonMeaning; string; Indicates the reason for creating the credit memo.
  • CreditedInvoiceId; integer; Unique identifier of the invoice that is credited by this invoice.
  • CreditedInvoiceNumber; integer; Number of the credited Invoice.
  • DocumentNumber; string; Number that identifies a document on the bill plan of a grants contract.
  • DocumentSubType; string; A classification that is assigned to documents such as an invoice or a credit memo. Example subtypes are Domestic Invoice and Foreign Invoice.
  • Exception; string; Indicates that exceptions have occurred for the invoice or for lines on the invoice. Valid values are E - Error, W - Warning, and N - No error.
  • ExportProcessId; integer; Unique identifier of the Export Invoice Details job used to export invoice attributes to a CSV file.
  • InvoiceAmount; number; Amount in the invoice currency.
  • InvoiceComment; string; Free text field for comments that can be printed on an invoice. The default value is the invoice comment defined for the project.
  • InvoiceCurrencyCode; string; Indicates the currency code for the invoice that is transferred to Oracle Receivables.
  • InvoiceDate; string; 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.
  • InvoiceId; integer; Unique identifier of the invoice.
  • InvoiceInstructions; string; Free text field to enter instructions for invoice billing.
  • InvoiceNumber; integer; The sequential number that identifies the invoice within a project contract.
  • InvoiceStatusCode; string; Indicates the code for the status of the invoice. Valid values are SUBMITTED, APPROVAL_REJECTED, RELEASED, DRAFT, REJECTED, TRANSFERRED, ACCEPTED, and APPROVED.
  • InvoiceStatusMeaning; string; Indicates the meaning of the value in the Invoice Status Code attribute. A list of valid values is defined in the lookup type PJB_INVOICE_STATUS_TYPE. Valid values are Accepted, Rejected, Approved, Draft, Transfer rejected, Released, Submitted, or Transferred. You can either enter this attribute or Invoice Status Code.
  • InvoiceTypeCode; string; Indicates the code for the type of the invoice. Valid values are CONCESSION, WRITE_OFF, CANCEL, STANDARD, and CREDIT_MEMO.
  • InvoiceTypeMeaning; string; The meaning of the value of the Invoice Type Code attribute. Valid values are Standard, Credit Memo, Write-Off, Net Invoice, or Canceled.
  • LastUnreleasedByPerson; string; Name of the person who last unreleased the invoice.
  • LastUnreleasedByPersonId; integer; Unique identifier of the person who last unreleased the invoice.
  • LastUnreleasedDate; string; The date and time when the invoice was last unreleased.
  • LocNumber; string; Number that identifies a letter of credit on the bill plan of a grants contract.
  • MajorVersion; integer; Indicates the version number of the contract.
  • Migrated; string; Indicates a migration type of invoice.
  • NetCredit; string; Indicator of net credit on the invoice. Valid values are Y - True and N - False.
  • NetInvoice; string; Indicator of net invoice on the invoice. Valid values are Y - True and N - False.
  • OrganizationId; integer; Unique identifier of the business unit associated with the invoice.
  • OrganizationName; string; Name of the business unit associated with the invoice.
  • PaDate; string; The end date of the Project Accounting (PA) period in which the invoice was generated. The PA period is the open or future PA period on or after the latest date of the expenditure item dates and the event completion dates included on the invoice.
  • PaPeriodName; string; Name of the Project Accounting (PA) period for the invoice.
  • ProjectId; integer; Unique identifier of the project associated to the invoice. This value is populated if the Invoice grouping option is set to Associated Project in the Bill Plan.
  • ProjectName; string; Name of the project associated to the invoice. This value is populated if the Invoice grouping option is set to Associated Project in the Bill Plan.
  • ProjectNumber; string; Number of the project associated to the invoice.This value is populated if the Invoice grouping option is set to Associated Project in the Bill Plan.
  • ReceivablesNumber; string; The Oracle Receivables invoice number that is determined upon release of the invoice and passed to Oracle Receivables upon transfer. This number can be user-entered in the application or system-generated as defined in the implementation options.
  • ReceiverSetupCode; string; Indicates if the invoice is for global projects of a receiver business unit. The value is IC_NON_GLOBAL for non global projects and blank for all other scenarios.
  • RejectedDate; string; The date on which the invoice is rejected.
  • RejectedbyPerson; string; Name of the person who rejected the invoice.
  • RejectedbyPersonId; integer; Unique identifier of the person who rejected the invoice.
  • ReleasedByPersonId; integer; Unique identifier of the person who released the invoice.
  • ReleasedDate; string; The date on which the invoice was released for transfer.
  • ReleasedbyPerson; string; Name of the person who released the invoice.
  • SubmittedByPerson; string; Name of the person who submitted the invoice for approval.
  • SubmittedByPersonId; integer; Unique identifier of the person who submitted the invoice for approval.
  • SubmittedDate; string; The date and time when the invoice was submitted for approval.
  • SystemReference; integer; Indicates the reference to the invoice created in Oracle Receivables from the draft invoice. The Confirm Invoice Acceptance Status in Receivables process populates the value and holds the RA_CUSTOMER_TRX.CUSTOMER_TRX_ID.
  • TaxAmount; number; The total tax amount in the invoice currency.
  • TaxationCountry; string; The country of taxation for calculating tax.
  • TransferredDate; string; Indicates the date on which the invoice is transferred to the Oracle Receivables interface tables.
  • UnreleaseComments; string; Comments entered by the person who unreleased the invoice.
• totalResults: boolean
  The resource collection representation will include the "estimated row count" when "?totalResults=true", otherwise the count is not included. The default value is "false".

Header Parameters

• Metadata-Context: string
  If the REST API supports runtime customizations, the shape of the service may change during runtime. The REST client may isolate itself from these changes or choose to interact with the latest version of the API by specifying this header. For example: Metadata-Context:sandbox="TrackEmployeeFeature".
• REST-Framework-Version: string
  The protocol version between a REST client and service. If the client does not specify this header in the request the server will pick a default version for the API.

There's no request body for this operation.

Back to 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

Type: object

Show Source

• count(required): integer
  The number of resource instances returned in the current range.
• hasMore(required): boolean
  Indicates whether more resources are available on the server than the subset returned in the response. If the value is true, then there are more resources to retrieve from the server. The default value is false.
• items: array Items
  Title: Items

  The items in the collection.
• limit(required): integer
  The actual paging size used by the server.
• links(required): array Links
  Title: Links

  The link relations associated with the resource instance.
• offset(required): integer
  The offset value used in the current page.
• totalResults: integer
  The estimated row count when "?totalResults=true", otherwise the count is not included.

{ "required":[ "count", "hasMore", "limit", "links", "offset" ], "type":"object", "properties":{ "totalResults":{ "type":"integer", "description":"The estimated row count when \"?totalResults=true\", otherwise the count is not included." }, "offset":{ "type":"integer", "description":"The offset value used in the current page." }, "count":{ "type":"integer", "description":"The number of resource instances returned in the current range." }, "hasMore":{ "type":"boolean", "description":"Indicates whether more resources are available on the server than the subset returned in the response. If the value is true, then there are more resources to retrieve from the server. The default value is false." }, "limit":{ "type":"integer", "description":"The actual paging size used by the server." }, "links":{ "title":"Links", "type":"array", "description":"The link relations associated with the resource instance.", "items":{ "$ref":"#/components/schemas/link" } }, "items":{ "title":"Items", "type":"array", "description":"The items in the collection.", "items":{ "$ref":"#/components/schemas/projectContractInvoices-item-response" } } }, "x-hints":{ "usage":"BusinessObject" } }

Nested Schema : Items

Type: array

Title: Items

The items in the collection.

Show Source

• Array of: object projectContractInvoices-item-response

{ "title":"Items", "type":"array", "description":"The items in the collection.", "items":{ "$ref":"#/components/schemas/projectContractInvoices-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-item-response

Type: object

Show Source

• AcceptedDate: string (date-time)
  Title: Accepted Date

  Read Only: true

  The date and time when the invoice was accepted.
• AccountingDate: string (date)
  Title: Accounting Date

  Read Only: true

  The date within a General Ledger (GL) accounting period to which the invoice transactions are posted. The GL date is set by the Transfer Invoice process and it is the date of the first future or open GL period in Oracle Receivables for the invoice date.
• AccountingPeriodName: string
  Title: Accounting Period

  Read Only: true

  Maximum Length: 15

  Name of the General Ledger (GL) period for the GL Date attribute.
• ApprovedbyPerson: string
  Title: Approved By

  Read Only: true

  Name of the person who approved the invoice.
• ApprovedbyPersonId: integer
  Title: Approved by Person ID

  Read Only: true

  Unique identifier of the person who approved the invoice.
• ApprovedDate: string (date)
  Title: Approved Date

  Read Only: true

  The date on which the invoice is approved.
• 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.
• Attachments: array Project Contract Invoices Attachments
  Title: Project Contract Invoices Attachments

  The attachments resource is used to view, create, update and delete attachments for project contract invoices.
• BillFromDate: string (date)
  Title: Bill from Date

  Read Only: true

  The date through which to invoice the project. Expenditure items with the expenditure item date on or after the bill from date and events with completion dates on or after the bill through date may be included on an invoice.
• BillingTypeCode: string
  Title: Billing Type

  Read Only: true

  Maximum Length: 30

  Indicates the code used to classify the type of billing. Valid values are EX - External, IP - Interproject, and IC - Intercompany.
• 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.
• BillToAccountNumber: string
  Title: Bill-to Account Number

  Read Only: true

  Maximum Length: 30

  Account number of the bill-to customer.
• BillToAddress: string
  Title: Bill-to Address

  Read Only: true

  Address of the bill-to customer.
• BillToContactId: integer (int64)
  Title: Bill-to Contact ID

  Read Only: true

  Unique identifier of the contact who is a representative for the bill-to customer on the bill plan.
• BillToContactName: string
  Title: Bill-to Contact

  Read Only: true

  Maximum Length: 255

  Name of the contact who is a representative for the bill-to customer on the bill plan.
• BillToCustomerId: integer (int64)
  Title: Bill-to Customer ID

  Read Only: true

  Unique identifier of the bill-to customer on the invoice.
• BillToCustomerName: string
  Title: Bill-to Customer

  Read Only: true

  Maximum Length: 240

  Name of the bill-to customer on the invoice.
• BillToDate: string (date)
  Title: Bill-Through Date

  Read Only: true

  The date through which to invoice the project. Expenditure items with the expenditure item date on or before the bill to date and events with completion dates on or before the bill through date may be included on an invoice.
• BillToSite: string
  Title: Bill-to Site

  Read Only: true

  Maximum Length: 150

  Address of the bill-to customer.
• BillToSiteId: integer (int64)
  Title: Bill-to Site ID

  Read Only: true

  Unique identifier of the customer address.
• Canceled: string
  Title: Canceled

  Read Only: true

  Maximum Length: 1

  Indicates that the invoice was cancelled.
• ContractId: integer (int64)
  Title: Contract ID

  Read Only: true

  Unique identifier of the contract for the invoice.
• ContractNumber: string
  Title: Contract Number

  Read Only: true

  Maximum Length: 120

  Number that uniquely identifies the contract for the invoice.
• ContractTypeId: integer (int64)
  Title: Contract Type ID

  Read Only: true

  Unique identifier for the contract type.
• ContractTypeName: string
  Title: Contract Type

  Read Only: true

  Maximum Length: 150

  Name of the contract type for the contract on the invoice.
• CreditedInvoiceId: integer (int64)
  Title: Credited Invoice ID

  Read Only: true

  Unique identifier of the invoice that is credited by this invoice.
• CreditedInvoiceNumber: integer (int64)
  Title: Credited Invoice Number

  Read Only: true

  Number of the credited Invoice.
• CreditMemoReasonCode: string
  Title: Credit Memo Reason Code

  Maximum Length: 30

  Indicates the code for the reason to create a credit memo.
• CreditMemoReasonMeaning: string
  Title: Credit Memo Reason

  Read Only: true

  Maximum Length: 80

  Indicates the reason for creating the credit memo.
• DocumentNumber: string
  Title: Document Number

  Read Only: true

  Maximum Length: 240

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

  Maximum Length: 240

  A classification that is assigned to documents such as an invoice or a credit memo. Example subtypes are Domestic Invoice and Foreign Invoice.
• Exception: string
  Title: Exception

  Maximum Length: 1

  Indicates that exceptions have occurred for the invoice or for lines on the invoice. Valid values are E - Error, W - Warning, and N - No error.
• ExportProcessId: integer (int64)
  Title: Export Process ID

  Read Only: true

  Unique identifier of the Export Invoice Details job used to export invoice attributes to a CSV file.
• InvoiceAmount: number
  Title: Amount in Invoice Currency

  Read Only: true

  Amount in the invoice currency.
• InvoiceComment: string
  Title: Invoice Comment

  Maximum Length: 240

  Free text field for comments that can be printed on an invoice. The default value is the invoice comment defined for the project.
• InvoiceCurrencyCode: string
  Title: Invoice Currency

  Read Only: true

  Maximum Length: 30

  Indicates the currency code for the invoice that is transferred to Oracle Receivables.
• InvoiceDate: string (date)
  Title: Date

  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.
• InvoiceHeaderDff: array Invoice Header Descriptive Flexfields
  Title: Invoice Header Descriptive Flexfields

  A listing of all the descriptive flexfields available for project contract invoices.
• InvoiceId: integer (int64)
  Title: Invoice ID

  Read Only: true

  Unique identifier of the invoice.
• InvoiceInstructions: string
  Title: Billing Instructions

  Maximum Length: 240

  Free text field to enter instructions for invoice billing.
• InvoiceLines: array Invoice Lines
  Title: Invoice Lines

  The Invoice Lines resource is used to view the details of the invoice lines.
• InvoiceNumber: integer (int64)
  Title: Number

  Read Only: true

  The sequential number that identifies the invoice within a project contract.
• InvoiceStatusCode: string
  Title: Invoice Status Code

  Maximum Length: 30

  Default Value: DRAFT

  Indicates the code for the status of the invoice. Valid values are SUBMITTED, APPROVAL_REJECTED, RELEASED, DRAFT, REJECTED, TRANSFERRED, ACCEPTED, and APPROVED.
• InvoiceStatusMeaning: string
  Title: Status

  Read Only: true

  Maximum Length: 80

  Indicates the meaning of the value in the Invoice Status Code attribute. A list of valid values is defined in the lookup type PJB_INVOICE_STATUS_TYPE. Valid values are Accepted, Rejected, Approved, Draft, Transfer rejected, Released, Submitted, or Transferred. You can either enter this attribute or Invoice Status Code.
• InvoiceTypeCode: string
  Title: Invoice Type Code

  Read Only: true

  Maximum Length: 30

  Indicates the code for the type of the invoice. Valid values are CONCESSION, WRITE_OFF, CANCEL, STANDARD, and CREDIT_MEMO.
• InvoiceTypeMeaning: string
  Title: Invoice Type

  Read Only: true

  Maximum Length: 80

  The meaning of the value of the Invoice Type Code attribute. Valid values are Standard, Credit Memo, Write-Off, Net Invoice, or Canceled.
• LastUnreleasedByPerson: string
  Title: Last Unreleased by Person

  Read Only: true

  Name of the person who last unreleased the invoice.
• LastUnreleasedByPersonId: integer (int64)
  Title: Last Unreleased by Person ID

  Unique identifier of the person who last unreleased the invoice.
• LastUnreleasedDate: string (date-time)
  Title: Last Unreleased Date

  The date and time when the invoice was last unreleased.
• 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.
• MajorVersion: integer (int64)
  Title: Contract Version

  Read Only: true

  Indicates the version number of the contract.
• Migrated: string
  Title: Migration Invoice

  Read Only: true

  Maximum Length: 1

  Indicates a migration type of invoice.
• NetCredit: string
  Title: Net Credit

  Read Only: true

  Maximum Length: 1

  Indicator of net credit on the invoice. Valid values are Y - True and N - False.
• NetInvoice: string
  Title: Net Invoice

  Read Only: true

  Maximum Length: 1

  Indicator of net invoice on the invoice. Valid values are Y - True and N - False.
• OrganizationId: integer (int64)
  Title: Organization ID

  Read Only: true

  Unique identifier of the business unit associated with the invoice.
• OrganizationName: string
  Title: Business Unit

  Read Only: true

  Maximum Length: 240

  Name of the business unit associated with the invoice.
• PaDate: string (date)
  Title: Project Accounting Date

  Read Only: true

  The end date of the Project Accounting (PA) period in which the invoice was generated. The PA period is the open or future PA period on or after the latest date of the expenditure item dates and the event completion dates included on the invoice.
• PaPeriodName: string
  Title: Project Accounting Period

  Read Only: true

  Maximum Length: 15

  Name of the Project Accounting (PA) period for the invoice.
• ProjectId: integer (int64)
  Title: Project ID

  Read Only: true

  Unique identifier of the project associated to the invoice. This value is populated if the Invoice grouping option is set to Associated Project in the Bill Plan.
• ProjectName: string
  Title: Project Name

  Read Only: true

  Name of the project associated to the invoice. This value is populated if the Invoice grouping option is set to Associated Project in the Bill Plan.
• ProjectNumber: string
  Title: Project Number

  Read Only: true

  Number of the project associated to the invoice.This value is populated if the Invoice grouping option is set to Associated Project in the Bill Plan.
• ReceivablesNumber: string
  Title: Receivables Number

  Maximum Length: 20

  The Oracle Receivables invoice number that is determined upon release of the invoice and passed to Oracle Receivables upon transfer. This number can be user-entered in the application or system-generated as defined in the implementation options.
• ReceiverSetupCode: string
  Title: Receiver Setup Code

  Read Only: true

  Maximum Length: 30

  Indicates if the invoice is for global projects of a receiver business unit. The value is IC_NON_GLOBAL for non global projects and blank for all other scenarios.
• RejectedbyPerson: string
  Title: Rejected By

  Read Only: true

  Name of the person who rejected the invoice.
• RejectedbyPersonId: integer
  Title: Rejected by Person ID

  Read Only: true

  Unique identifier of the person who rejected the invoice.
• RejectedDate: string (date)
  Title: Rejected Date

  Read Only: true

  The date on which the invoice is rejected.
• ReleasedbyPerson: string
  Title: Released By

  Read Only: true

  Name of the person who released the invoice.
• ReleasedByPersonId: integer (int64)
  Title: Released by Person ID

  Unique identifier of the person who released the invoice.
• ReleasedDate: string (date)
  Title: Released Date

  The date on which the invoice was released for transfer.
• ReportTypeCode: string
  Title: Report Type Code

  Read Only: true

  Maximum Length: 30

  Indicates the code of the Federal report type specified in the bill plan.
• SubmittedByPerson: string
  Title: Submitted by Person

  Read Only: true

  Name of the person who submitted the invoice for approval.
• SubmittedByPersonId: integer (int64)
  Title: Submitted by Person ID

  Unique identifier of the person who submitted the invoice for approval.
• SubmittedDate: string (date-time)
  Title: Submitted Date

  The date and time when the invoice was submitted for approval.
• SystemReference: integer (int64)
  Title: System Reference

  Read Only: true

  Indicates the reference to the invoice created in Oracle Receivables from the draft invoice. The Confirm Invoice Acceptance Status in Receivables process populates the value and holds the RA_CUSTOMER_TRX.CUSTOMER_TRX_ID.
• TaxAmount: number
  Title: Tax Amount in Invoice Currency

  Read Only: true

  The total tax amount in the invoice currency.
• TaxationCountry: string
  Title: Taxation Country

  Maximum Length: 2

  The country of taxation for calculating tax.
• TransferredDate: string (date)
  Title: Transfer Date

  Indicates the date on which the invoice is transferred to the Oracle Receivables interface tables.
• UnreleaseComments: string
  Title: Unrelease Comments

  Maximum Length: 240

  Comments entered by the person who unreleased the invoice.

{ "type":"object", "properties":{ "RejectedDate":{ "title":"Rejected Date", "type":"string", "description":"The date on which the invoice is rejected.", "format":"date", "nullable":true, "readOnly":true, "x-queryable":true }, "ContractNumber":{ "title":"Contract Number", "maxLength":120, "type":"string", "description":"Number that uniquely identifies the contract for the invoice.", "nullable":false, "readOnly":true, "x-queryable":true }, "NetInvoice":{ "title":"Net Invoice", "maxLength":1, "type":"string", "description":"Indicator of net invoice on the invoice. Valid values are Y - True and N - False.", "nullable":true, "readOnly":true, "x-queryable":true }, "BillToAccountNumber":{ "title":"Bill-to Account Number", "maxLength":30, "type":"string", "description":"Account number of the bill-to customer.", "nullable":false, "readOnly":true, "x-queryable":true }, "RejectedbyPerson":{ "title":"Rejected By", "type":"string", "description":"Name of the person who rejected the invoice.", "nullable":true, "readOnly":true, "x-hints":{ "DISPLAYHINT":"Hide" }, "x-queryable":true }, "BillToAddress":{ "title":"Bill-to Address", "type":"string", "description":"Address of the bill-to customer.", "nullable":true, "readOnly":true, "x-queryable":true }, "ReceiverSetupCode":{ "title":"Receiver Setup Code", "maxLength":30, "type":"string", "description":"Indicates if the invoice is for global projects of a receiver business unit. The value is IC_NON_GLOBAL for non global projects and blank for all other scenarios.", "nullable":true, "readOnly":true, "x-queryable":true }, "TaxAmount":{ "title":"Tax Amount in Invoice Currency", "type":"number", "description":"The total tax amount in the invoice currency.", "nullable":true, "readOnly":true, "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 }, "ContractTypeName":{ "title":"Contract Type", "maxLength":150, "type":"string", "description":"Name of the contract type for the contract on the invoice.", "nullable":true, "readOnly":true, "x-queryable":true }, "CreditedInvoiceId":{ "title":"Credited Invoice ID", "type":"integer", "description":"Unique identifier of the invoice that is credited by this invoice.", "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" } }, "LastUnreleasedByPersonId":{ "title":"Last Unreleased by Person ID", "type":"integer", "description":"Unique identifier of the person who last unreleased the invoice.", "format":"int64", "nullable":true, "x-hints":{ "precision":18 }, "x-queryable":true }, "InvoiceNumber":{ "title":"Number", "type":"integer", "description":"The sequential number that identifies the invoice within a project contract.", "format":"int64", "nullable":false, "readOnly":true, "x-hints":{ "precision":18 }, "x-queryable":true }, "NetCredit":{ "title":"Net Credit", "maxLength":1, "type":"string", "description":"Indicator of net credit on the invoice. Valid values are Y - True and N - False.", "nullable":true, "readOnly":true, "x-queryable":true }, "SystemReference":{ "title":"System Reference", "type":"integer", "description":"Indicates the reference to the invoice created in Oracle Receivables from the draft invoice. The Confirm Invoice Acceptance Status in Receivables process populates the value and holds the RA_CUSTOMER_TRX.CUSTOMER_TRX_ID.", "format":"int64", "nullable":true, "readOnly":true, "x-hints":{ "precision":18 }, "x-queryable":true }, "PaDate":{ "title":"Project Accounting Date", "type":"string", "description":"The end date of the Project Accounting (PA) period in which the invoice was generated. The PA period is the open or future PA period on or after the latest date of the expenditure item dates and the event completion dates included on the invoice.", "format":"date", "nullable":true, "readOnly":true, "x-queryable":true }, "ApprovedDate":{ "title":"Approved Date", "type":"string", "description":"The date on which the invoice is approved.", "format":"date", "nullable":true, "readOnly":true, "x-queryable":true }, "InvoiceHeaderDff":{ "title":"Invoice Header Descriptive Flexfields", "type":"array", "description":"A listing of all the descriptive flexfields available for project contract invoices.", "items":{ "$ref":"#/components/schemas/projectContractInvoices-InvoiceHeaderDff-item-response" }, "x-cardinality":"1" }, "BillFromDate":{ "title":"Bill from Date", "type":"string", "description":"The date through which to invoice the project. Expenditure items with the expenditure item date on or after the bill from date and events with completion dates on or after the bill through date may be included on an invoice.", "format":"date", "nullable":true, "readOnly":true, "x-queryable":true }, "TaxationCountry":{ "title":"Taxation Country", "maxLength":2, "type":"string", "description":"The country of taxation for calculating tax.", "nullable":true, "x-hints":{ "controlType":"combo_lov" }, "x-queryable":true }, "DocumentSubType":{ "title":"Document Subtype", "maxLength":240, "type":"string", "description":"A classification that is assigned to documents such as an invoice or a credit memo. Example subtypes are Domestic Invoice and Foreign Invoice.", "nullable":true, "x-hints":{ "controlType":"combo_lov" }, "x-queryable":true }, "BillToSiteId":{ "title":"Bill-to Site ID", "type":"integer", "description":"Unique identifier of the customer address.", "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 }, "ReleasedByPersonId":{ "title":"Released by Person ID", "type":"integer", "description":"Unique identifier of the person who released the invoice.", "format":"int64", "nullable":true, "x-hints":{ "precision":18 }, "x-queryable":true }, "ExportProcessId":{ "title":"Export Process ID", "type":"integer", "description":"Unique identifier of the Export Invoice Details job used to export invoice attributes to a CSV file.", "format":"int64", "nullable":true, "readOnly":true, "x-hints":{ "precision":18 }, "x-queryable":true }, "Canceled":{ "title":"Canceled", "maxLength":1, "type":"string", "description":"Indicates that the invoice was cancelled.", "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":false, "readOnly":true, "x-queryable":true }, "PaPeriodName":{ "title":"Project Accounting Period", "maxLength":15, "type":"string", "description":"Name of the Project Accounting (PA) period for the invoice.", "nullable":true, "readOnly":true, "x-queryable":true }, "ApprovedbyPerson":{ "title":"Approved By", "type":"string", "description":"Name of the person who approved the invoice.", "nullable":true, "readOnly":true, "x-hints":{ "DISPLAYHINT":"Hide" }, "x-queryable":true }, "BillToCustomerName":{ "title":"Bill-to Customer", "maxLength":240, "type":"string", "description":"Name of the bill-to customer on the invoice.", "nullable":true, "readOnly":true, "x-queryable":true }, "OrganizationName":{ "title":"Business Unit", "maxLength":240, "type":"string", "description":"Name of the business unit associated with the invoice.", "nullable":true, "readOnly":true, "x-queryable":true }, "BillToCustomerId":{ "title":"Bill-to Customer ID", "type":"integer", "description":"Unique identifier of the bill-to customer on the invoice.", "format":"int64", "nullable":false, "readOnly":true, "x-hints":{ "precision":18 }, "x-queryable":true }, "InvoiceStatusCode":{ "title":"Invoice Status Code", "maxLength":30, "type":"string", "description":"Indicates the code for the status of the invoice. Valid values are SUBMITTED, APPROVAL_REJECTED, RELEASED, DRAFT, REJECTED, TRANSFERRED, ACCEPTED, and APPROVED.", "nullable":false, "default":"DRAFT", "x-queryable":true }, "ProjectName":{ "title":"Project Name", "type":"string", "description":"Name of the project associated to the invoice. This value is populated if the Invoice grouping option is set to Associated Project in the Bill Plan.", "nullable":true, "readOnly":true, "x-queryable":true }, "ContractTypeId":{ "title":"Contract Type ID", "type":"integer", "description":"Unique identifier for the contract type.", "format":"int64", "nullable":false, "readOnly":true, "x-hints":{ "precision":18 }, "x-queryable":true }, "ApprovedbyPersonId":{ "title":"Approved by Person ID", "type":"integer", "description":"Unique identifier of the person who approved the invoice.", "nullable":true, "readOnly":true, "x-queryable":true }, "CreditedInvoiceNumber":{ "title":"Credited Invoice Number", "type":"integer", "description":"Number of the credited Invoice.", "format":"int64", "nullable":false, "readOnly":true, "x-hints":{ "precision":18 }, "x-queryable":true }, "AccountingDate":{ "title":"Accounting Date", "type":"string", "description":"The date within a General Ledger (GL) accounting period to which the invoice transactions are posted. The GL date is set by the Transfer Invoice process and it is the date of the first future or open GL period in Oracle Receivables for the invoice date.", "format":"date", "nullable":true, "readOnly":true, "x-queryable":true }, "OrganizationId":{ "title":"Organization ID", "type":"integer", "description":"Unique identifier of the business unit associated with the invoice.", "format":"int64", "nullable":false, "readOnly":true, "x-hints":{ "precision":18 }, "x-queryable":true }, "InvoiceAmount":{ "title":"Amount in Invoice Currency", "type":"number", "description":"Amount in the invoice currency.", "nullable":true, "readOnly":true, "x-queryable":true }, "InvoiceId":{ "title":"Invoice ID", "type":"integer", "description":"Unique identifier of the invoice.", "format":"int64", "nullable":false, "readOnly":true, "x-hints":{ "precision":18, "fnd:GLOBALLY_UNIQUE":"true" }, "x-queryable":true }, "SubmittedDate":{ "title":"Submitted Date", "type":"string", "description":"The date and time when the invoice was submitted for approval.", "format":"date-time", "nullable":true, "x-queryable":true }, "AccountingPeriodName":{ "title":"Accounting Period", "maxLength":15, "type":"string", "description":"Name of the General Ledger (GL) period for the GL Date attribute.", "nullable":true, "readOnly":true, "x-queryable":true }, "InvoiceTypeMeaning":{ "title":"Invoice Type", "maxLength":80, "type":"string", "description":"The meaning of the value of the Invoice Type Code attribute. Valid values are Standard, Credit Memo, Write-Off, Net Invoice, or Canceled.", "nullable":false, "readOnly":true, "x-queryable":true }, "Attachments":{ "title":"Project Contract Invoices Attachments", "type":"array", "description":"The attachments resource is used to view, create, update and delete attachments for project contract invoices.", "items":{ "$ref":"#/components/schemas/projectContractInvoices-Attachments-item-response" } }, "CreditMemoReasonCode":{ "title":"Credit Memo Reason Code", "maxLength":30, "type":"string", "description":"Indicates the code for the reason to create a credit memo.", "nullable":true, "x-queryable":true }, "AcceptedDate":{ "title":"Accepted Date", "type":"string", "description":"The date and time when the invoice was accepted.", "format":"date-time", "nullable":true, "readOnly":true, "x-queryable":true }, "BillToSite":{ "title":"Bill-to Site", "maxLength":150, "type":"string", "description":"Address of the bill-to customer.", "nullable":true, "readOnly":true, "x-queryable":true }, "Migrated":{ "title":"Migration Invoice", "maxLength":1, "type":"string", "description":"Indicates a migration type of invoice.", "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, "x-queryable":true }, "MajorVersion":{ "title":"Contract Version", "type":"integer", "description":"Indicates the version number of the contract.", "format":"int64", "nullable":true, "readOnly":true, "x-hints":{ "precision":18 }, "x-queryable":true }, "LastUnreleasedDate":{ "title":"Last Unreleased Date", "type":"string", "description":"The date and time when the invoice was last unreleased.", "format":"date-time", "nullable":true, "x-queryable":true }, "SubmittedByPerson":{ "title":"Submitted by Person", "type":"string", "description":"Name of the person who submitted the invoice for approval.", "nullable":true, "readOnly":true, "x-queryable":true }, "SubmittedByPersonId":{ "title":"Submitted by Person ID", "type":"integer", "description":"Unique identifier of the person who submitted the invoice for approval.", "format":"int64", "nullable":true, "x-hints":{ "precision":18 }, "x-queryable":true }, "InvoiceLines":{ "title":"Invoice Lines", "type":"array", "description":"The Invoice Lines resource is used to view the details of the invoice lines.", "items":{ "$ref":"#/components/schemas/projectContractInvoices-InvoiceLines-item-response" } }, "BillToDate":{ "title":"Bill-Through Date", "type":"string", "description":"The date through which to invoice the project. Expenditure items with the expenditure item date on or before the bill to date and events with completion dates on or before the bill through date may be included on an invoice.", "format":"date", "nullable":true, "readOnly":true, "x-queryable":true }, "RejectedbyPersonId":{ "title":"Rejected by Person ID", "type":"integer", "description":"Unique identifier of the person who rejected the invoice.", "nullable":true, "readOnly":true, "x-queryable":true }, "ProjectNumber":{ "title":"Project Number", "type":"string", "description":"Number of the project associated to the invoice.This value is populated if the Invoice grouping option is set to Associated Project in the Bill Plan.", "nullable":true, "readOnly":true, "x-queryable":true }, "InvoiceInstructions":{ "title":"Billing Instructions", "maxLength":240, "type":"string", "description":"Free text field to enter instructions for invoice billing.", "nullable":true, "x-queryable":true }, "ProjectId":{ "title":"Project ID", "type":"integer", "description":"Unique identifier of the project associated to the invoice. This value is populated if the Invoice grouping option is set to Associated Project in the Bill Plan.", "format":"int64", "nullable":true, "readOnly":true, "x-hints":{ "precision":18 }, "x-queryable":true }, "BillingTypeCode":{ "title":"Billing Type", "maxLength":30, "type":"string", "description":"Indicates the code used to classify the type of billing. Valid values are EX - External, IP - Interproject, and IC - Intercompany.", "nullable":false, "readOnly":true, "x-queryable":true }, "ContractId":{ "title":"Contract ID", "type":"integer", "description":"Unique identifier of the contract for the invoice.", "format":"int64", "nullable":false, "readOnly":true, "x-hints":{ "precision":18 }, "x-queryable":true }, "BillToContactId":{ "title":"Bill-to Contact ID", "type":"integer", "description":"Unique identifier of the contact who is a representative for the bill-to customer on the bill plan.", "format":"int64", "nullable":true, "readOnly":true, "x-hints":{ "precision":18 }, "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 }, "ReportTypeCode":{ "title":"Report Type Code", "maxLength":30, "type":"string", "description":"Indicates the code of the Federal report type specified in the bill plan.", "nullable":true, "readOnly":true, "x-queryable":false }, "Exception":{ "title":"Exception", "maxLength":1, "type":"string", "description":"Indicates that exceptions have occurred for the invoice or for lines on the invoice. Valid values are E - Error, W - Warning, and N - No error.", "nullable":true, "x-queryable":true }, "InvoiceComment":{ "title":"Invoice Comment", "maxLength":240, "type":"string", "description":"Free text field for comments that can be printed on an invoice. The default value is the invoice comment defined for the project.", "nullable":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 }, "ReleasedbyPerson":{ "title":"Released By", "type":"string", "description":"Name of the person who released the invoice.", "nullable":true, "readOnly":true, "x-hints":{ "DISPLAYHINT":"Hide" }, "x-queryable":true }, "CreditMemoReasonMeaning":{ "title":"Credit Memo Reason", "maxLength":80, "type":"string", "description":"Indicates the reason for creating the credit memo.", "nullable":false, "readOnly":true, "x-queryable":true }, "InvoiceTypeCode":{ "title":"Invoice Type Code", "maxLength":30, "type":"string", "description":"Indicates the code for the type of the invoice. Valid values are CONCESSION, WRITE_OFF, CANCEL, STANDARD, and CREDIT_MEMO.", "nullable":true, "readOnly":true, "x-queryable":true }, "InvoiceStatusMeaning":{ "title":"Status", "maxLength":80, "type":"string", "description":"Indicates the meaning of the value in the Invoice Status Code attribute. A list of valid values is defined in the lookup type PJB_INVOICE_STATUS_TYPE. Valid values are Accepted, Rejected, Approved, Draft, Transfer rejected, Released, Submitted, or Transferred. You can either enter this attribute or Invoice Status Code.", "nullable":false, "readOnly":true, "x-queryable":true }, "BillToContactName":{ "title":"Bill-to Contact", "maxLength":255, "type":"string", "description":"Name of the contact who is a representative for the bill-to customer on the bill plan.", "nullable":true, "readOnly":true, "x-queryable":true }, "ReceivablesNumber":{ "title":"Receivables Number", "maxLength":20, "type":"string", "description":"The Oracle Receivables invoice number that is determined upon release of the invoice and passed to Oracle Receivables upon transfer. This number can be user-entered in the application or system-generated as defined in the implementation options.", "nullable":true, "x-queryable":true }, "LastUnreleasedByPerson":{ "title":"Last Unreleased by Person", "type":"string", "description":"Name of the person who last unreleased the invoice.", "nullable":true, "readOnly":true, "x-queryable":true }, "TransferredDate":{ "title":"Transfer Date", "type":"string", "description":"Indicates the date on which the invoice is transferred to the Oracle Receivables interface tables.", "format":"date", "nullable":true, "x-queryable":true }, "UnreleaseComments":{ "title":"Unrelease Comments", "maxLength":240, "type":"string", "description":"Comments entered by the person who unreleased the invoice.", "nullable":true, "x-queryable":true }, "ReleasedDate":{ "title":"Released Date", "type":"string", "description":"The date on which the invoice was released for transfer.", "format":"date", "nullable":true, "x-queryable":true } } }

Nested Schema : Project Contract Invoices Attachments

Type: array

Title: Project Contract Invoices Attachments

The attachments resource is used to view, create, update and delete attachments for project contract invoices.

Show Source

• Array of: object projectContractInvoices-Attachments-item-response

{ "title":"Project Contract Invoices Attachments", "type":"array", "description":"The attachments resource is used to view, create, update and delete attachments for project contract invoices.", "items":{ "$ref":"#/components/schemas/projectContractInvoices-Attachments-item-response" } }

Nested Schema : Invoice Header Descriptive Flexfields

Type: array

Title: Invoice Header Descriptive Flexfields

A listing of all the descriptive flexfields available for project contract invoices.

Show Source

• Array of: object projectContractInvoices-InvoiceHeaderDff-item-response

{ "title":"Invoice Header Descriptive Flexfields", "type":"array", "description":"A listing of all the descriptive flexfields available for project contract invoices.", "items":{ "$ref":"#/components/schemas/projectContractInvoices-InvoiceHeaderDff-item-response" }, "x-cardinality":"1" }

Nested Schema : Invoice Lines

Type: array

Title: Invoice Lines

The Invoice Lines resource is used to view the details of the invoice lines.

Show Source

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

{ "title":"Invoice Lines", "type":"array", "description":"The Invoice Lines resource is used to view the details of the invoice lines.", "items":{ "$ref":"#/components/schemas/projectContractInvoices-InvoiceLines-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-Attachments-item-response

Type: object

Show Source

• AsyncTrackerId: string
  Title: Asynchronous Upload Tracker Id

  Attribute provided for the exclusive use by the Attachment UI components to assist in uploading files.
• AttachedDocumentId: integer (int64)
  Title: Attached Document Id

  The unique identifier of the attached document.
• CategoryName: string
  Title: Category

  Maximum Length: 30

  The category of the attachment.
• ContentRepositoryFileShared: boolean
  Title: Shared

  Indicates whether the attachment is shared.
• CreatedBy: string
  Title: Created By

  Read Only: true

  Maximum Length: 255

  The user who created the record.
• CreatedByUserName: string
  Title: Created By User Name

  Read Only: true

  The user name who created the record.
• CreationDate: string (date-time)
  Title: Creation Date

  Read Only: true

  The date when the record was created.
• DatatypeCode: string
  Title: Type

  Maximum Length: 30

  Default Value: FILE

  A value that indicates the data type.
• Description: string
  Title: Description

  Maximum Length: 255

  The description of the attachment.
• DmDocumentId: string
  Maximum Length: 255

  The document ID from which the attachment is created.
• DmFolderPath: string
  Title: Dm Folder Path

  Maximum Length: 1000

  The folder path from which the attachment is created.
• DmVersionNumber: string
  Maximum Length: 255

  The document version number from which the attachment is created.
• DownloadInfo: string
  Title: DownloadInfo

  JSON object represented as a string containing information used to programmatically retrieve a file attachment.
• ErrorStatusCode: string
  Title: Error Status Code

  The error code, if any, for the attachment.
• ErrorStatusMessage: string
  Title: Error Status Message

  The error message, if any, for the attachment.
• ExpirationDate: string (date-time)
  Title: Expiration Date

  The expiration date of the contents in the attachment.
• FileContents: string (byte)
  Title: File Contents

  The contents of the attachment.
• FileName: string
  Title: File Name

  Maximum Length: 2048

  The file name of the attachment.
• FileUrl: string
  Title: File Url

  The URI of the file.
• FileWebImage: string (byte)
  Title: File Web Image

  Read Only: true

  The base64 encoded image of the file displayed in .png format if the source is a convertible image.
• LastUpdateDate: string (date-time)
  Title: Last Update Date

  Read Only: true

  The date when the record was last updated.
• LastUpdatedBy: string
  Title: Last Updated By

  Read Only: true

  Maximum Length: 255

  The user who last updated the record.
• LastUpdatedByUserName: string
  Title: Last Updated By User

  Read Only: true

  The user name who last updated the record.
• links: array Links
  Title: Links

  The link relations associated with the resource instance.
• PostProcessingAction: string
  Title: PostProcessingAction

  The name of the action that can be performed after an attachment is uploaded.
• Title: string
  Title: Title

  The title of the attachment.
• UploadedFileContentType: string
  Title: Uploaded File Content Type

  The content type of the attachment.
• UploadedFileLength: integer
  Title: File Size

  The size of the attachment file.
• UploadedFileName: string
  Title: Uploaded File Name

  The name to assign to a new attachment file.
• UploadedText: string
  Title: Uploaded Text

  The text content for a new text attachment.
• Uri: string
  Title: Uri

  Maximum Length: 4000

  The URI of a Topology Manager type attachment.
• Url: string
  Title: Url

  Maximum Length: 4000

  The URL of a web page type attachment.
• UserName: string
  Title: User Name

  Read Only: true

  Maximum Length: 255

  The login credentials of the user who created the attachment.

{ "type":"object", "properties":{ "CreationDate":{ "title":"Creation Date", "type":"string", "description":"The date when the record was created.", "format":"date-time", "nullable":false, "readOnly":true, "x-hints":{ "includeInCompactView":true }, "x-queryable":true }, "Description":{ "title":"Description", "maxLength":255, "type":"string", "description":"The description of the attachment.", "nullable":true, "x-queryable":false, "x-hints":{ "includeInCompactView":true, "fnd:FND_AUDIT_ATTR_ENABLED":"false" } }, "FileName":{ "title":"File Name", "maxLength":2048, "type":"string", "description":"The file name of the attachment.", "nullable":true, "x-hints":{ "includeInCompactView":true, "fnd:FND_AUDIT_ATTR_ENABLED":"true" }, "x-queryable":true }, "FileWebImage":{ "title":"File Web Image", "type":"string", "description":"The base64 encoded image of the file displayed in .png format if the source is a convertible image.", "format":"byte", "nullable":true, "readOnly":true, "x-queryable":false, "x-hints":{ "XML_ELEMENT":"#hide", "PAYLOADHINT":"Show" } }, "Uri":{ "title":"Uri", "maxLength":4000, "type":"string", "description":"The URI of a Topology Manager type attachment.", "nullable":true, "x-hints":{ "includeInCompactView":true, "fnd:FND_AUDIT_ATTR_ENABLED":"false" }, "x-queryable":true }, "Url":{ "title":"Url", "maxLength":4000, "type":"string", "description":"The URL of a web page type attachment.", "nullable":true, "x-hints":{ "includeInCompactView":true, "fnd:FND_AUDIT_ATTR_ENABLED":"true" }, "x-queryable":true }, "DmDocumentId":{ "maxLength":255, "type":"string", "description":"The document ID from which the attachment is created.", "nullable":true, "x-hints":{ "includeInCompactView":true, "fnd:FND_AUDIT_ATTR_ENABLED":"true", "fnd:OA_TRANSLATABLE":"true" }, "x-queryable":true }, "AttachedDocumentId":{ "title":"Attached Document Id", "type":"integer", "description":"The unique identifier of the attached document.", "format":"int64", "nullable":false, "x-hints":{ "includeInCompactView":true, "precision":18, "fnd:FND_AUDIT_ATTR_ENABLED":"true", "fnd:GLOBALLY_UNIQUE":"true" }, "x-queryable":true }, "UploadedFileContentType":{ "title":"Uploaded File Content Type", "type":"string", "description":"The content type of the attachment.", "nullable":true, "x-queryable":false, "x-hints":{ "includeInCompactView":true, "fnd:FND_AUDIT_ATTR_ENABLED":"false" } }, "DownloadInfo":{ "title":"DownloadInfo", "type":"string", "description":"JSON object represented as a string containing information used to programmatically retrieve a file attachment.", "nullable":true, "x-queryable":false, "x-hints":{ "includeInCompactView":true, "fnd:FND_AUDIT_ATTR_ENABLED":"false" } }, "CreatedByUserName":{ "title":"Created By User Name", "type":"string", "description":"The user name who created the record.", "nullable":true, "readOnly":true, "x-hints":{ "includeInCompactView":true, "fnd:FND_AUDIT_ATTR_ENABLED":"false" }, "x-queryable":true }, "links":{ "title":"Links", "type":"array", "description":"The link relations associated with the resource instance.", "items":{ "$ref":"#/components/schemas/link" } }, "UploadedFileLength":{ "title":"File Size", "type":"integer", "description":"The size of the attachment file.", "nullable":true, "x-queryable":false, "x-hints":{ "includeInCompactView":true, "fnd:FND_AUDIT_ATTR_ENABLED":"false" } }, "DmVersionNumber":{ "maxLength":255, "type":"string", "description":"The document version number from which the attachment is created.", "nullable":true, "x-hints":{ "includeInCompactView":true, "fnd:FND_AUDIT_ATTR_ENABLED":"true" }, "x-queryable":true }, "LastUpdatedBy":{ "title":"Last Updated By", "maxLength":255, "type":"string", "description":"The user who last updated the record.", "nullable":false, "readOnly":true, "x-hints":{ "includeInCompactView":true }, "x-queryable":true }, "ErrorStatusMessage":{ "title":"Error Status Message", "type":"string", "description":"The error message, if any, for the attachment.", "nullable":true, "x-queryable":false, "x-hints":{ "includeInCompactView":true, "fnd:FND_AUDIT_ATTR_ENABLED":"false" } }, "UserName":{ "title":"User Name", "maxLength":255, "type":"string", "description":"The login credentials of the user who created the attachment.", "nullable":false, "readOnly":true, "x-hints":{ "includeInCompactView":true, "fnd:FND_AUDIT_ATTR_ENABLED":"false" }, "x-queryable":true }, "CreatedBy":{ "title":"Created By", "maxLength":255, "type":"string", "description":"The user who created the record.", "nullable":false, "readOnly":true, "x-hints":{ "includeInCompactView":true }, "x-queryable":true }, "DatatypeCode":{ "title":"Type", "maxLength":30, "type":"string", "description":"A value that indicates the data type.", "nullable":false, "default":"FILE", "x-hints":{ "includeInCompactView":true, "fnd:FND_AUDIT_ATTR_ENABLED":"true" }, "x-queryable":true }, "PostProcessingAction":{ "title":"PostProcessingAction", "type":"string", "description":"The name of the action that can be performed after an attachment is uploaded.", "nullable":true, "x-queryable":false, "x-hints":{ "includeInCompactView":true, "fnd:FND_AUDIT_ATTR_ENABLED":"false" } }, "Title":{ "title":"Title", "type":"string", "description":"The title of the attachment.", "nullable":true, "x-queryable":false, "x-hints":{ "includeInCompactView":true, "fnd:FND_AUDIT_ATTR_ENABLED":"false" } }, "LastUpdatedByUserName":{ "title":"Last Updated By User", "type":"string", "description":"The user name who last updated the record.", "nullable":true, "readOnly":true, "x-hints":{ "includeInCompactView":true, "fnd:FND_AUDIT_ATTR_ENABLED":"false" }, "x-queryable":true }, "UploadedFileName":{ "title":"Uploaded File Name", "type":"string", "description":"The name to assign to a new attachment file.", "nullable":true, "x-queryable":false, "x-hints":{ "includeInCompactView":true, "fnd:FND_AUDIT_ATTR_ENABLED":"false" } }, "FileUrl":{ "title":"File Url", "type":"string", "description":"The URI of the file.", "nullable":true, "x-queryable":false, "x-hints":{ "includeInCompactView":true, "fnd:FND_AUDIT_ATTR_ENABLED":"false" } }, "ContentRepositoryFileShared":{ "title":"Shared", "type":"boolean", "description":"Indicates whether the attachment is shared.", "nullable":true, "x-queryable":false, "x-hints":{ "includeInCompactView":true, "fnd:FND_AUDIT_ATTR_ENABLED":"false" } }, "FileContents":{ "title":"File Contents", "type":"string", "description":"The contents of the attachment.", "format":"byte", "nullable":true, "x-queryable":false, "x-hints":{ "XML_ELEMENT":"#hide" } }, "ExpirationDate":{ "title":"Expiration Date", "type":"string", "description":"The expiration date of the contents in the attachment.", "format":"date-time", "nullable":true, "x-hints":{ "includeInCompactView":true }, "x-queryable":true }, "ErrorStatusCode":{ "title":"Error Status Code", "type":"string", "description":"The error code, if any, for the attachment.", "nullable":true, "x-queryable":false, "x-hints":{ "includeInCompactView":true, "fnd:FND_AUDIT_ATTR_ENABLED":"false" } }, "DmFolderPath":{ "title":"Dm Folder Path", "maxLength":1000, "type":"string", "description":"The folder path from which the attachment is created.", "nullable":true, "x-hints":{ "includeInCompactView":true, "fnd:FND_AUDIT_ATTR_ENABLED":"true" }, "x-queryable":true }, "UploadedText":{ "title":"Uploaded Text", "type":"string", "description":"The text content for a new text attachment.", "nullable":true, "x-queryable":false, "x-hints":{ "includeInCompactView":true, "fnd:FND_AUDIT_ATTR_ENABLED":"false" } }, "CategoryName":{ "title":"Category", "maxLength":30, "type":"string", "description":"The category of the attachment.", "nullable":true, "x-hints":{ "includeInCompactView":true, "fnd:FND_AUDIT_ATTR_ENABLED":"true" }, "x-queryable":true }, "LastUpdateDate":{ "title":"Last Update Date", "type":"string", "description":"The date when the record was last updated.", "format":"date-time", "nullable":false, "readOnly":true, "x-hints":{ "includeInCompactView":true, "FMT_FORMAT":"d-MMM-yyyy HH:mm:ss" }, "x-queryable":true }, "AsyncTrackerId":{ "title":"Asynchronous Upload Tracker Id", "type":"string", "description":"Attribute provided for the exclusive use by the Attachment UI components to assist in uploading files.", "nullable":true, "x-queryable":false, "x-hints":{ "DISPLAYHINT":"Hide", "includeInCompactView":true, "PAYLOADHINT":"Show" } } } }

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-InvoiceHeaderDff-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
• InvoiceId: integer (int64)
  Identifier of the invoice.
• 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" } }, "InvoiceId":{ "type":"integer", "description":"Identifier of the invoice.", "format":"int64", "nullable":false, "x-hints":{ "DISPLAYHINT":"Hide", "includeInCompactView":true, "precision":18, "fnd:GLOBALLY_UNIQUE":"true" }, "x-queryable":true }, "__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 }, "__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 : 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 : 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" } }

Back to Top

Examples

The following example shows how to get all project contract invoices 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

Example of Response Body

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

{ "items": [ { "BillFromDate": "1952-01-01", "BillSet": 1, "BillToContactId": 4840, "BillToCustomerId": 1005, "BillToDate": "2017-07-27", "BillToSiteId": 300100038711498, "BillingTypeCode": "EX", "Canceled": null, "ContractId": 300100121123900, "CreditMemoReasonCode": null, "CreditedInvoiceId": null, "DocumentNumber": null, "DocumentSubType": null, "Exception": "N", "ExportProcessId": null, "AccountingDate": "2016-12-31", "AccountingPeriodName": "Dec-16", "ApTransferStatusCode": null, "InvoiceComment": null, "InvoiceCurrencyCode": "USD", "InvoiceDate": "2016-12-31", "InvoiceId": 100100055358196, "InvoiceInstructions": null, "InvoiceNumber": 1, "InvoiceStatusCode": "TRANSFERRED", "InvoiceTypeCode": "STANDARD", "LocNumber": null, "MajorVersion": 1, "OrganizationId": 458, "PaDate": "2016-12-31", "PaPeriodName": "52-16", "ReceivablesNumber": "ARAttchVS1", "ReceiverSetupCode": null, "ReleasedByPersonId": 100010032550827, "ReleasedDate": "2017-07-27", "ReportTypeCode": null, "SystemReference": null, "TaxationCountry": "US", "TransferredDate": "2017-07-27", "ContractNumber": "CDRMPJB_AR AttachVS", "ContractTypeName": "Dummy4", "ContractTypeId": 2004, "BillToCustomerName": "ATnT Universal Card", "CreditedInvoiceNumber": null, "InvoiceAmount": 200, "TaxAmount": 0, "Migrated": "N", "NetCredit": null, "OrganizationName": "Vision Services", "InvoiceStatusMeaning": "Transferred", "InvoiceTypeMeaning": "Standard invoice", "ApprovedbyPersonId": 100010032550827, "RejectedbyPersonId": null, "ApprovedDate": "2017-07-27", "RejectedDate": null, "ApprovedbyPerson": "Abraham Mason", "RejectedbyPerson": null, "ReleasedbyPerson": "Abraham Mason", "BillToContactName": "Paula Springer", "CreditMemoReasonMeaning": null, "BillToSite": "CDRM_6185", "UnreleaseComments": null, "LastUnreleasedByPersonId": null, "LastUnreleasedDate": null, "LastUnreleasedByPerson": null }

Back to Top