Get a project contract invoice
get
/fscmRestApi/resources/11.13.18.05/projectContractInvoices/{InvoiceId}
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 -
links: string
This parameter can be used to show only certain links while accessing a singular resource or a resource collection. The parameter value format is a comma-separated list of : <link_relation>
Example:
self,canonical -
onlyData: boolean
The resource item payload will be filtered in order to contain only data (no links section, for example).
Header Parameters
-
Metadata-Context:
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-item-response
Type:
Show Source
object
-
AcceptedDate: string
(date-time)
Title:
Accepted Date
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.
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
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
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
Nested Schema : Links
Type:
array
Title:
Links
The link relations associated with the resource instance.
Show Source
Nested Schema : projectContractInvoices-Attachments-item-response
Type:
Show Source
object
-
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
-
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. -
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.
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-InvoiceHeaderDff-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
-
InvoiceId: integer
(int64)
Identifier of the invoice.
-
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 : 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 : 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
Links
- Attachments
-
Parameters:
- InvoiceId:
$request.path.InvoiceId
The attachments resource is used to view, create, update and delete attachments for project contract invoices. - InvoiceId:
- InvoiceHeaderDff
-
Operation: /fscmRestApi/resources/11.13.18.05/projectContractInvoices/{InvoiceId}/child/InvoiceHeaderDffParameters:
- InvoiceId:
$request.path.InvoiceId
A listing of all the descriptive flexfields available for project contract invoices. - InvoiceId:
- InvoiceLines
-
Operation: /fscmRestApi/resources/11.13.18.05/projectContractInvoices/{InvoiceId}/child/InvoiceLinesParameters:
- InvoiceId:
$request.path.InvoiceId
The Invoice Lines resource is used to view the details of the invoice lines. - InvoiceId:
- approveProjectContractInvoice
-
Parameters:
- InvoiceId:
$request.path.InvoiceId
Use this action to approve a submitted invoice. - InvoiceId:
- rejectProjectContractInvoice
-
Parameters:
- InvoiceId:
$request.path.InvoiceId
Use this action to reject a submitted invoice. - InvoiceId:
- releaseProjectContractInvoice
-
Parameters:
- InvoiceId:
$request.path.InvoiceId
Use this action to release invoices that have been approved and are ready to be released. - InvoiceId:
- returnToDraftProjectContractInvoice
-
Parameters:
- InvoiceId:
$request.path.InvoiceId
Use this action to return an approved or approval rejected invoice to draft status. - InvoiceId:
- submitProjectContractInvoice
-
Parameters:
- InvoiceId:
$request.path.InvoiceId
Use this action to submit invoices for approval. - InvoiceId:
- unreleaseProjectContractInvoice
-
Parameters:
- InvoiceId:
$request.path.InvoiceId
Use this action to unrelease invoices that are either in released status or transfer rejected status. To unrelease an invoice that is not the last in sequence, you must first unrelease and delete all subsequent invoices. Invoices that are in transferred or accepted statuses cannot be unreleased. - InvoiceId:
Examples
The following example shows how to get a 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/100100055358196
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 }