Get all invoice lines
get
/fscmRestApi/resources/11.13.18.05/projectContractInvoices/{InvoiceId}/child/InvoiceLines
Request
Path Parameters
-
InvoiceId(required): integer(int64)
Unique identifier of the invoice.
Query Parameters
-
dependency: string
This parameter specifies dependencies which are fields that are set before and rolled back after generating the response. Generally they are used to preview the effects of an attribute change. The fields specified in this parameter are always set in the resource instance in question. When a child resource collection is requested and the parameter is set, the fields will be set in the parent resource instance before generating the resource collection payload. The value of this query parameter is a set of dependency fields. Example: dependency=ProductId=2
Format: <attr1>=<val1>,<attr2>=<value2> -
expand: string
When this parameter is provided, the specified children are included in the resource payload (instead of just a link). The value of this query parameter is "all" or "". More than one child can be specified using comma as a separator. Example: ?expand=Employees,Localizations. Nested children can also be provided following the format "Child.NestedChild" (Example: ?expand=Employees.Managers). If a nested child is provided (Example: Employees.Managers), the missing children will be processed implicitly. For example, "?expand=Employees.Managers" is the same as "?expand=Employees,Employees.Managers" (which will expand Employees and Managers).
-
fields: string
This parameter filters the resource fields. Only the specified fields are returned, which means that if no fields are specified, no fields are returned (useful to get only the links). If an indirect child resource is provided (Example: Employees.Managers), the missing children will be processed implicitly. For example, "?fields=Employees.Managers:Empname" is the same as "?fields=;Employees:;Employees.Managers:Empname" (which will only return the "Empname" field for Managers). the value of this query parameter is a list of resource fields. The attribute can be a direct (Example: Employees) or indirect (Example: Employees.Managers) child. It cannot be combined with expand query parameter. If both are provided, only fields will be considered.
Format: ?fields=Attribute1,Attribute2
Format for fields in child resource: ?fields=Accessor1:Attribute1,Attribute2 -
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 invoice line with the specified primary key.
Finder Variables:- InvoiceLineId; integer; Unique identifier of the invoice line.
- PrimaryKey: Finds the invoice line with the specified primary key.
-
limit: integer
This parameter restricts the number of resources returned inside the resource collection. If the limit exceeds the resource count then the framework will only return the available resources.
-
links: string
This parameter can be used to show only certain links while accessing a singular resource or a resource collection. The parameter value format is a comma-separated list of : <link_relation>
Example:
self,canonical -
offset: integer
Used to define the starting position of the resource collection. If offset exceeds the resource count then no resources are returned. Default value is 0.
-
onlyData: boolean
The resource item payload will be filtered in order to contain only data (no links section, for example).
-
orderBy: string
This parameter orders a resource collection based on the specified fields. The parameter value is a comma-separated string of attribute names, each optionally followed by a colon and "asc" or "desc". Specify "asc" for ascending and "desc" for descending. The default value is "asc". For example, ?orderBy=field1:asc,field2:desc
-
q: string
This query parameter defines the where clause. The resource collection will be queried using the provided expressions. The value of this query parameter is one or more expressions. Example: ?q=Deptno>=10 and <= 30;Loc!=NY
Format: ?q=expression1;expression2
You can use these queryable attributes to filter this collection resource using the q query parameter:- ApTransferErrorCode; string; 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; 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; An optional value for an assessable value for the transaction line for estimated tax purposes.
- BillPlanId; integer; Unique identifier of the bill plan related to the line.
- BillSet; integer; Identifier of a set of invoices created together in the same run which must be released at the same time.
- ContractCurrencyCode; string; Indicates the code of the currency for the contract related to the invoice line.
- ContractCurrencyLineAmount; number; Amount in contract currency.
- ContractLineId; integer; Unique identifier of the contract line related to the invoice line.
- ContractLineNumber; string; Number that identifies the contract line related to the invoice line if the line represents a single contract line.
- CreditedInvoiceLineId; integer; Unique identifier of the invoice line credited by this invoice line.
- DocumentNumber; string; Number that identifies a document on the bill plan of a grants contract.
- Exception; string; Indicates that exceptions have occurred for the invoice line. Valid values are E - Error, W - Warning, and N - No error.
- ExpenditureOrgId; integer; Unique identifier of the expenditure organization related to the line.
- ExpenditureTypeId; integer; Unique identifier of the expenditure type for the invoice line.
- IntendedUse; string; A classification of the products by tax authority for tax purposes.
- IntendedUseClassifId; integer; Unique identifier of the intended use classification.
- InvoiceCurrencyCode; string; Indicates the currency code for the invoice that is transferred to Oracle Receivables.
- InvoiceCurrencyLineAmount; number; Amount of the invoice line in the invoice currency.
- InvoiceFormatId; integer; Unique identifier of the invoice format.
- InvoiceFormatName; string; Name of the invoice format.
- InvoiceLineId; integer; Unique identifier of the invoice line.
- InvoiceLineNumber; integer; Number that identifies an invoice line.
- InvoiceLineType; string; 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; Meaning of the invoice line type.
- LedgerCurrencyCode; string; The currency used for accounting and reporting in a ledger, often referred to as the accounting currency, base currency, or functional currency.
- LedgerCurrencyLineAmount; number; Amount of the invoice line in the ledger currency.
- LineDescription; string; Description of the invoice line.
- LinkedProjectId; integer; 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; 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; 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; 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; 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; 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.
- LocNumber; string; Number that identifies a letter of credit on the bill plan of a grants contract.
- OutputTaxAmount; number; The total tax amount in the invoice currency.
- OutputTaxClassCode; string; A classification of output tax for the invoice line.
- OutputTaxExempt; string; Indicates the use of Standard Exemption rules. Options include Standard, Exempt, or Required. The default is based on user tax setup.
- OutputTaxExmtCertNumber; string; Identifier of the exemption certificate for item lines that have the Output tax Exempt attribute set to E-exempt.
- OutputTaxExmtReasonCode; string; Indicates the code for the reason for tax exemption on lines that have the Output tax Exempt attribute set to E-exempt.
- PaymentTermId; integer; Unique identifier of the payment term for the receipt from Accounts Receivable (AR) which is applied against the agreement.
- PaymentTermName; string; Name of the payment term.
- ProductCategory; string; A classification of products used for tax purposes.
- ProductFcCategoryId; integer; Unique identifier of the product fiscal classification category.
- ProductFiscClassification; string; A classification of the products based on the inventory item category by the tax authority for tax purposes.
- ProductType; string; 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; Unique identifier of the receiver project.
- ReceiverTaskId; integer; Unique identifier of the receiver task.
- ShipToAccountDescription; string; Account description of the ship-to customer on the invoice line.
- ShipToAccountNumber; string; Account number of the ship-to customer on the invoice line.
- ShipToAddress; string; Address of the ship-to customer on the invoice line.
- ShipToContactId; integer; Unique identifier of the ship-to contact. A representative for the ship to customer of the project.
- ShipToCustomerId; integer; Unique identifier of the customer account ship-to address that is the project customer's default work site for the project.
- ShipToCustomerName; string; Name of the ship-to customer on the invoice line.
- ShipToSiteId; integer; 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; Unique identifier of the ship-to site on the invoice line.
- TransactionBusinessCategory; string; A classification or categorization of an invoice line for tax purposes as required by a tax authority.
- TranslatedText; string; The translated text of the invoice line. This text is in the language defined in invoice header.
- UserDefinedFiscalClass; string; Indicates the default taxation country.
- WorkTypeId; integer; Unique identifier of the work type.
- WorkTypeName; string; Name of the work type.
-
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:
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.
There's no request body for this operation.
Back to TopResponse
Supported Media Types
- application/json
Default Response
The following table describes the default response for this task.
Headers
-
Metadata-Context(required):
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(required):
The protocol version between a REST client and service. If the client does not specify this header in the request the server will pick a default version for the API.
Root Schema : projectContractInvoices-InvoiceLines
Type:
Show Source
object
-
count(required): integer
The number of resource instances returned in the current range.
-
hasMore(required): boolean
Indicates whether more resources are available on the server than the subset returned in the response. If the value is true, then there are more resources to retrieve from the server. The default value is false.
-
items: array
Items
Title:
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.
Nested Schema : Links
Type:
array
Title:
Links
The link relations associated with the resource instance.
Show Source
Nested Schema : projectContractInvoices-InvoiceLines-item-response
Type:
Show Source
object
-
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.
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
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
Nested Schema : Links
Type:
array
Title:
Links
The link relations associated with the resource instance.
Show Source
Nested Schema : projectContractInvoices-InvoiceLines-InvoiceLineDff-item-response
Type:
Show Source
object
-
__FLEX_Context: string
Title:
Context Prompt
Maximum Length:30
Context for flex fields. -
__FLEX_Context_DisplayValue: string
Title:
Context Prompt
-
InvoiceLineId: integer
(int64)
Identifier of the invoice line.
-
links: array
Links
Title:
Links
The link relations associated with the resource instance.
Nested Schema : Links
Type:
array
Title:
Links
The link relations associated with the resource instance.
Show Source
Nested Schema : link
Type:
Show Source
object
-
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.
Nested Schema : properties
Type:
Show Source
object
-
changeIndicator: string
Change indicator or the ETag value of the resource instance.
Nested Schema : projectContractInvoices-InvoiceLines-InvoiceLineDistributions-item-response
Type:
Show Source
object
-
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.
Nested Schema : Links
Type:
array
Title:
Links
The link relations associated with the resource instance.
Show Source
Examples
The following example shows how to get all invoice lines on a project contract by submitting a GET request on the REST resource using cURL.
curl --user ppm_cloud_user https://your_organization.com:port/fscmRestApi/resources/11.13.18.05/projectContractInvoices/100100085970023/child/InvoiceLines
Example of Response Body
The following shows an example of the response body in JSON format.
{ "items": [ { "LedgerCurrencyLineAmount": null, "LedgerCurrencyCode": null, "AssessableValue": 2500, "BillPlanId": null, "BillSet": 1, "ContractCurrencyCode": "USD", "ContractCurrencyLineAmount": 2500, "ContractLineId": 300100169214487, "CreditedInvoiceLineId": null, "DocumentNumber": null, "Exception": "N", "ExpenditureOrgId": null, "ExpenditureTypeId": null, "ApTransferErrorCode": null, "ApTransferStatusCode": null, "IntendedUse": null, "IntendedUseClassifId": null, "InvoiceCurrencyLineAmount": 2500, "InvoiceCurrencyCode": "USD", "InvoiceFormatId": 100000011213026, "LineDescription": " 1 PJB Bug 28128344 Fixture Install 1 2017-01-01 ", "InvoiceLineId": 100100085970024, "InvoiceLineNumber": 1, "InvoiceLineType": "STANDARD", "LocNumber": null, "OutputTaxAmount": 500, "OutputTaxClassCode": "VAT20", "OutputTaxExempt": "S", "OutputTaxExmtCertNumber": null, "OutputTaxExmtReasonCode": null, "PaymentTermId": 4, "ProductFcCategoryId": null, "ProductCategory": null, "ProductFiscClassification": null, "ProductType": null, "ReceiverProjectId": null, "ReceiverTaskId": null, "ShipToContactId": null, "ShipToCustomerId": 1005, "ShipToSiteId": 1024, "TranslatedText": null, "TransactionBusinessCategory": "SALES_TRANSACTION", "UserDefinedFiscalClass": null, "WorkTypeId": null, "InvoiceLineTypeMeaning": "Standard invoice line", "ContractLineNumber": "1", "InvoiceFormatName": "Cont Line Project/Task Event", "PaymentTermName": "30 Net", "WorkTypeName": null, "LinkedProjectId": 300100169214449, "LinkedTaskId": 100100085968379, "LinkedTaskName": "Fixture Install", "LinkedTaskNumber": "2.3", "LinkedProjectName": "PJB Bug 28128344", "LinkedProjectNumber": "PJB Bug 28128344" }