An invoice or a bill is a receivables document issued by a seller to a buyer, indicating the items, quantities, and agreed prices for products or services the seller has provided to the buyer. The Receivables Invoices REST Service can be used by the seller to create invoices for goods delivered to and services rendered to the customer. The REST Service integrates the deploying company’s external systems to Oracle Receivables. This service receives the order information from the online user and creates the corresponding invoice in Oracle Receivables.

A RESTful API is an application program interface (API) that uses HTTP requests to GET, PATCH, POST and DELETE data. A RESTful API -- also referred to as a RESTful web service -- is based on representational state transfer (REST) technology, an architectural style and approach to communications often used in REST services development. You can test REST services using Oracle’s APEX RESTful service tester; an internet-accessible application; or a programming platform that supports protocols to transfer data, such as POSTMAN, cURL, or other REST clients. An example of how to invoke this service is described in Appendix 2.4. Receivables Invoice Rest Service is available to any user who has access to Oracle Receivables.

Use the Receivables Invoices REST resource to create, find, and delete invoices. You can:

· Create Receivables invoices, with header information such as transaction type, payment terms, and remit-to address, and with invoice lines for goods delivered and services rendered to the customer.

· Capture additional information for the invoice and invoice lines with descriptive flexfields and global descriptive flexfields.

· Append notes and attachments to the invoice.

· Get and Find details of one or more Receivables invoices. Optionally delete an invoice.

Glossary

The following REST API terminology is commonly used in this document:

Term	Description
cURL	Software that provides a library and command-line tool for transferring data using various protocols.
<host>	Fusion cloud URL of the host.
JSON	JavaScript Object Notation or JSON is an open-standard file format that uses human-readable text to transmit data objects consisting of attribute value pairs and array data types.
List of Values (LOV) Resource	A resource that provides a list of valid values that you can use for a field.
<passwd>	Password of the Fusion user.
<port>	Port for the host; if port is unknown then leave this field blank.
Representation	Used to capture the current or intended state of a resource. It includes both the data that describes the state and the metadata that describes the data. Resources are represented using the JSON format.
Resource	An object with a type, associated data, and relationships to other resources. You can use a set of HTTP methods to access each resource.
Resource Identifier	Used to identify a resource involved in an interaction, such as URL, URI, or URN.
Resource Index URI	The most significant URI for a set of resources.
REST Service	An architectural style that defines a set of constraints to be used for creating web services. It provides interoperability between computer systems on the internet.
Root Resource	An individual resource that does not require a containing context. It is generally the top-level resource without path parameters and is found in a resource index.
Singular Resource	Represents a single entity, such as an invoice.
Subresource	A resource within the context of a parent resource, such as attachments, notes.
URL	Uniform Resource Locator is a reference to a web resource that specifies its location on a computer network and a mechanism for retrieving it.
URI	Uniform Resource Identifier is a string of characters that unambiguously identifies a resource such as a file.
URN	Uniform Resource Name is a Uniform Resource Identifier that uses the URN scheme.
<username>	Represents the user ID necessary to connect to this service.
<version>	Version of the service. For example: 11.18.05.0.0

2 Service Details

2.1 Supported Resources

The following resources are available in the Receivables Invoice REST Service:

Attributes and the description of each attribute for each resource are provided in Service Attribute Section 2.2. The relationships of the parent and child resources are also available in Section 2.2.

receivablesInvoices

The receivables invoices resource is used to create, get, find, update the transaction date and status, and delete a receivables invoice. A sample payload for receivables invoice is provided in Appendix 3.3. Further information for this resource is found in the receivablesInvoices resource service attribute details.

receivablesInvoiceDFF

The receivables invoice descriptive flexfields resource is used to create, get, find, and delete the descriptive flexfield values associated with an invoice. Further information for this resource is found in the receivablesInvoiceDFF resource service attribute details.

receivablesInvoiceTransactionDFF

The receivables invoice transaction descriptive flexfields resource is used to create, get, find, and delete the transaction descriptive flexfield values associated with an invoice. Further information for this resource is found in the receivablesInvoiceTransactionDFF resource service attribute details.

receivablesInvoiceGDF

The receivables invoice global descriptive flexfields resource is used to create, get, find, and delete the global descriptive flexfield values associated with an invoice. Further information for this resource is found in the receivablesInvoiceGDF resource service attribute details.

receivablesInvoiceLines

The receivables invoice lines resource is used to create, get, find, and delete the lines of an invoice. Further information for this resource is found in the receivablesInvoiceLines resource service attribute details.

receivablesInvoiceLineDFF

The receivables invoice line descriptive flexfields resource is used to create, get, find, and delete the descriptive flexfield values associated with invoice lines. Further information for this resource is found in the receivablesInvoiceLineDFF resource service attribute details.

receivablesInvoiceLineTransactionDFF

The receivables invoice line transaction descriptive flexfields resource is used to create, get, find, and delete the transaction descriptive flexfield values associated with invoice lines. Further information for this resource is found in the receivablesInvoiceLineTransactionDFF resource service attribute details.

receivablesInvoiceLineGDF

The receivables invoice line global descriptive flexfields resource is used to create, get, find, and delete the global descriptive flexfield values associated with invoice lines. Further information for this resource is found in the receivablesInvoiceLineGDF resource service attribute details.

receivablesInvoiceLineTaxLines

The receivables invoice line tax lines resource is used to create and get tax lines on an invoice. Further information for this resource is found in the receivablesInvoiceLineTaxLines resource service attribute details.

receivablesInvoiceInstallments

The receivables invoice installments resource is used to edit and get the installments of an invoice. Further information for this resource is found in the receivablesInvoiceInstallments resource service attribute details.

receivablesInvoiceInstallmentGDF

The receivables invoice installment global descriptive flexfields resource is used to create, get, find, and delete the global descriptive flexfield values associated with invoice installments. Further information for this resource is found in the receivablesInvoiceInstallmentGDF resource service attribute details.

receivablesInvoiceInstallmentNotes

The receivables invoice installment notes resource is used to create and find comments, information, or instructions on an invoice installment. Further information for this resource is found in the receivablesInvoiceInstallmentNotes resource service attribute details.

attachments

The receivables invoice attachments resource is used to create, find, and delete the attachments associated with an invoice. Further information for this resource is found in the attachments resource service attribute details.

notes

The receivables invoice notes resource is used to capture, find, and delete the comments, information, or instructions on an invoice. Further information for this resource is found in the notes resource service attribute details.

2.2 Service Attributes

This section describes the parent and child relationship of the Receivables Invoice REST Service, and the resource attributes:

Relationships

receivablesInvoices is the parent resource. The following are children of the receivablesInvoices resource.

· receivablesInvoiceDFF

· receivablesInvoiceTransactionDFF

· receivablesInvoiceGDF

· receivablesInvoiceLines

The following are children of the receivablesInvoiceLines resource and grandchildren of the receivablesInvoices resource.

§ receivablesInvoiceLineDFF

§ receivablesInvoiceLineTransactionDFF

§ receivablesInvoiceLineGDF

§ receivablesInvoiceInstallments

§ The following are children of the receivablesInvoiceInstallments resource and grandchildren of the receivablesInvoices resource.

§ receivablesInvoiceInstallmentGDF

§ receivablesInvoiceInstallmentNotes

§ attachments

§ notes

receivablesInvoices

This is the top-level resource that contains information to create a receivables invoice. A sample request payload and response payload for receivables invoice is provided in Appendix 3.3.

The attributes of the resource are listed below. InvoiceStatus and Transactiondate are the only updateable attributes.

Attribute Name	Attribute Type	Attribute Label	Attribute Description
CustomerTransactionId	Integer	Transaction ID	The unique identifier of the invoice.
DueDate	Date	Due Date	The date when the invoice installment is due to be paid.
ConversionDate	Date	Rate Date	The date used to derive a currency conversion rate.
ConversionRate	Number	Rate	The rate used to convert the invoice currency to the ledger currency.
InvoiceCurrencyCode	String	Invoice Currency	The code that identifies the entered currency of the invoice.
SpecialInstructions	String	Special Instructions	The special instructions that accompany the invoice.
CrossReference	String	Reference	The reference field default value from the transaction source assigned to the invoice. The reference field default value is the source document used to identify transactions created using the transaction source.
DocumentNumber	Integer	Document Number	The document sequence number assigned to the invoice.
TransactionNumber	String	Transaction Number	The transaction number assigned to the invoice.
TransactionDate	Date	Transaction Date	The date when the invoice was created.
TransactionType	String	Transaction Type	The transaction type assigned to the invoice.
TransactionSource	String	Transaction Source	The transaction source assigned to the invoice.
BillToCustomerNumber	String	Bill-to Customer Account Number	The account number of the bill-to customer assigned to the invoice.
BillToSite	String	Bill-to Site	The number that identifies the bill-to customer site assigned to the invoice.
Comments	String	Comments	The user comments that accompany the invoice.
InternalNotes	String	Transaction Internal Notes	The user-defined internal notes that accompany the invoice.
PaymentTerms	String	Payment Terms	The payment terms assigned to the invoice.
LegalEntityIdentifier	String	Legal Entity Identifier	The unique identifier of the legal entity under which the invoice is created. A legal entity is a recognized party with rights and responsibilities given by legislation.
ConversionRateType	String	Conversion Rate Type	The grouping of conversion rates between currencies, used to automatically populate a specific rate to an invoice or invoice line according to business requirements. Valid values are Spot, Corporate, User, and Fixed.
PurchaseOrder	String	PO Number	The purchase order number on the invoice.
PurchaseOrderDate	Date	PO Date	The date when the purchase order was generated for the invoice.
PurchaseOrderRevision	String	PO Revision	The revision number of the purchase order on the invoice.
FirstPartyRegistrationNumber	String	First-Party Tax Registration Number	The tax registration number of the deploying company.
ThirdPartyRegistrationNumber	String	Third-Party Tax Registration Number	The tax registration number of the bill-to customer.
InvoicingRule	String	Invoicing Rule	The accounting approach used to recognize revenue on the invoice. The valid values are In Advance and In Arrears.
ShipToCustomerName	String	Ship-to Name	The name of the customer who receives the goods or services billed on the invoice.
ShipToCustomerNumber	String	Ship-to Customer	The account number of the ship-to customer assigned to the invoice.
BillingDate	Date	Billing Date	The balance forward bill date, if the invoice belongs to a balance forward bill.
BusinessUnit	String	Business Unit	The business unit under which the invoice is created. A business unit is a unit of an enterprise that performs one or more business functions that can be rolled up in a management hierarchy.
InvoiceStatus	String	Status	The value that indicates the level of completion of the invoice. Valid values are Complete, Incomplete, and Frozen.
AccountingDate	Date	Accounting Date	The accounting date assigned to the invoice.
ShipToSite	String	Ship-to Site	The number that identifies the ship-to customer site assigned to the invoice.
PayingCustomerName	String	Paying Customer Account Name	The name of the customer who pays for the goods or services on the invoice.
PayingCustomerSite	String	Paying Customer Site Name	The number that identifies the paying customer site assigned to the invoice.
BillToCustomerName	String	Bill-to Customer Name	The name that identifies the bill-to customer assigned to the invoice.
FreightAmount	Number	Freight	The freight applicable at the invoice level.
Carrier	String	Carrier	The name of the shipping vendor.
ShipDate	Date	Ship Date	The date when the items on the invoice are shipped.
ShippingReference	Number	Shipping Reference	The waybill reference on the invoice.
BillToContact	String	Bill-to Customer Contact Name	The contact details of the bill-to customer.
ShipToContact	String	Ship-to Customer Contact Name	The contact details of the ship-to customer.
PrintOption	String	Generate Bill	The option that indicates whether to print the invoice.
CreatedBy	String	Created By	The user who created the record.
CreationDate	DateTime	Creation Date	The date and time when the record was created.
LastUpdatedBy	String	Last Update By	The user who last updated the record.
LastUpdateDate	DateTime	Last Update Date	The date and time when the record was last updated.
PayingCustomerAccount	String	Paying Customer Account Name	The account number of the paying customer assigned to the invoice.
SoldToPartyNumber	String	Sold-to Customer	The unique number used to identify the sold-to customer on the invoice.
RemitToAddress	String	Remit-to Address	The address to which the customer should send payment for the invoice.
DefaultTaxationCountry	String	Default Taxation Country	The country where the invoice transaction takes place for tax purposes.
DocumentFiscalClassification	String	Document Fiscal Classification	The classification for tax purposes of invoice transactions that require special documentation to accompany the transaction, as designated by a tax authority.
EnteredAmount	Number	Entered Amount	The original invoice amount in the entered currency.
InvoiceBalanceAmount	Number	Accounted Balance Due	The balance due on the invoice.
Prepayment	String	Prepayment	The option used to identify the invoice as a transaction requiring prepayment for goods and services.
Intercompany	String	Intercompany	The option used to identify the invoice as an intercompany transaction.
ReceiptMethod	String	Receipt Method	The receipt method assigned to the invoice.
BankAccountNumber	String	Customer Bank Account Number	The bank account number of the customer on the invoice.
CreditCardIssuerCode	String	Credit Card Issuer Code	The code for the credit card issuer, such as Visa or MasterCard.
CreditCardTokenNumber	String	Credit Card Token Number	The token number issued by the tokenization service provider corresponding to a credit card number.
CreditCardVoiceAuthorizationCode	String	Credit Card Voice Authorization Code	The voice authorization code received from the tokenization service provider for authorization.
CardHolderLastName	String	Last Name of the Credit Card Holder	The last name of the credit card holder.
CardHolderFirstName	String	First Name of the Credit Card Holder	The first name of the credit card holder.
CreditCardAuthorizationRequestIdentifier	String	Credit Card Authorization Request Identifier	The authorization request identifier received from the tokenization service provider to authorize the credit card number.
CreditCardExpirationDate	Date	Credit Card Expiration Date	The date when the credit card expires.
CreditCardErrorCode	String	Credit Card Error Code	The error code when credit card authorization fails.
CreditCardErrorText	String	Credit Card Error Text	The error text when credit card authorization fails.
SalesPersonNumber	String	Primary Sales Person Number	The number that identifies the primary salesperson on the invoice.
StructuredPaymentReference	String	Structured Payment Reference	An industry standard reference on Receivables transactions composed of letters, check digits, and transaction information, used to identify the transaction and its payments to the customer and bank.

receivablesInvoiceDFF

This child level resource of receivablesInvoice contains information related to the receivables invoice descriptive flexfield. The attributes of the resource are:

Attribute Name	Attribute Type	Attribute Label	Attribute Description
CustomerTrxId	Integer	Transaction ID	The unique identifier of the invoice descriptive flexfield.
__FLEX_Context	String	__FLEX_Context Context	The invoice descriptive flexfield context segment.
__FLEX_Context_DisplayValue	String	FLEX_Context Context_Display Value	The invoice descriptive flexfield context segment displayed value.

receivablesInvoiceTransactionDFF

This child level resource of receivablesInvoice contains information related to the receivables invoice transaction descriptive flexfield. The attributes of the resource are:

Attribute Name	Attribute Type	Attribute Label	Attribute Description
CustomerTrxId	Integer	Transaction ID	The unique identifier of the invoice transaction descriptive flexfield.
__FLEX_Context	String	__FLEX_Context Context	The invoice transaction descriptive flexfield context segment.
__FLEX_Context_DisplayValue	String	FLEX_Context Context_Display Value	The invoice transaction descriptive flexfield context segment displayed value.

receivablesInvoiceGDF

This child level resource of receivablesInvoice contains information related to the receivables invoice global descriptive flexfield. The attributes of the resource are:

Attribute Name	Attribute Type	Attribute Label	Attribute Description
CustomerTrxId	Integer	Transaction ID	The unique identifier of the invoice global descriptive flexfield.
__FLEX_Context	String	__FLEX_Context Context	The invoice global descriptive flexfield context segment.
__FLEX_Context_DisplayValue	String	FLEX_Context Context_Display Value	The invoice global descriptive flexfield context segment displayed value.

receivablesInvoiceLines

This child level resource of receivablesInvoices consists of the attributes of the lines within the invoice. The line level attributes describe the information related to each line level content. The attributes of the resource are:

Attribute Name	Attribute Type	Attribute Label	Attribute Description
CustomerTransactionLineId	Integer	Transaction Line ID	The unique identifier of an invoice line.
LineNumber	Number	Line Number	The number of the invoice line.
Description	String	Description	The description that identifies the product or service on the invoice line.
Quantity	Number	Quantity	The quantity of products or services referred to on the invoice line.
UnitSellingPrice	Number	Unit Price	The price of an individual item on the invoice line.
TaxClassificationCode	String	Tax Classification	The code used as a determining factor in tax calculation on the invoice line.
SalesOrder	String	Sales order number referenced on the transaction line.	The sales order number on the invoice line.
AccountingRuleDuration	Integer	Number of Periods	The number of periods in which revenue is to be recognized. A value is required for invoice lines with a fixed or variable revenue scheduling rule rule type.
RuleEndDate	Date	End Date	The date when the revenue scheduling rule ends. This applies to invoices with rules.
RuleStartDate	Date	Start Date	The date when the revenue scheduling rule starts. This applies to invoices with rules.
AccountingRule	String	Rule	The revenue scheduling rule assigned to the invoice line.
Warehouse	String	Warehouse	The ship-from location of the item on the invoice line. This value applies to inventory items.
MemoLine	String	Memo Line	The memo line that identifies the product or service on the invoice line.
UnitOfMeasure	String	UOM	The unit of measure used for the product or service on the invoice line.
ItemNumber	String	Item	The number that identifies the inventory item on the invoice line.
AllocatedFreightAmount	Number	Freight Charge	The freight amount applied to the Invoice line.
AssessableValue	Number	Transaction Line Assessable Value	The numeric value used as the taxable base amount to calculate tax on a specific invoice item.
SalesOrderDate	Date	Date	The date when the sales order was created.
LineAmount	Number	Line Amount	The transaction line amount.
CreatedBy	String	Created By	The user who created the record.
CreationDate	DateTime	Creation Date	The date and time when the record was created.
LastUpdatedBy	String	Last Update By	The user who last updated the record.
LastUpdateDate	DateTime	Last Update Date	The date and time when the record was last updated.
TransacationBusinessCategory	String	Transaction Business Category	The classification for tax purposes of the business nature of a transaction, as designated by a tax authority.
UserDefinedFiscalClassification	String	User-Defined Fiscal Classification	The user-defined classification for tax purposes of additional tax requirements, as designated by a tax authority.
ProductFiscalClassification	String	Category Name	The classification for tax purposes of the taxable nature of the product or product transaction on the invoice line, as designated by a tax authority.
ProductCategory	String	Line Product Category	The classification for tax purposes of a non-inventory based product on the invoice line, as designated by a tax authority.
ProductType	String	Line Product Type	The nature of the item or product on the invoice line, sometimes used as a determining factor in tax calculation. Valid values are Goods and Services.
LineAmountIncludesTax	String	Amount Includes Tax	The option that indicates whether the line amount is inclusive of tax, exclusive of tax, or determined by the tax setup.
LineIntendedUse	String	Intended Use	The classification for tax purposes of the intended use of the product on the invoice line, as designated by a tax authority.
TaxInvoiceNumber	String	Tax Invoice Number	The number assigned to the fiscal document supporting the sale, which is generated upon shipment of goods.
TaxInvoiceDate	Date	Tax Invoice Date	The date when the tax invoice document was generated.
TaxExemptionHandling	String	Tax Exemption Handling	The value that indicates the tax exemption to apply to the invoice line. Valid values are Standard, Require, and Exempt.
TaxExemptionCertificateNumber	String	Tax Exemption Certificate Number	The number that identifies the document that certifies that a party or product is partially or fully exempt from a tax.
TaxExemptionReason	String	Reason	The reason that a party or product has a tax exemption on the invoice line.

receivablesInvoiceLineDFF

This child level resource of receivablesInvoiceLines contains information related to the invoice lines descriptive flexfields. The attributes of the resource are:

Attribute Name	Attribute Type	Attribute Label	Attribute Description
CustomerTrxLineId	Integer	Transaction Line ID	The unique identifier of the invoice line descriptive flexfield.
__FLEX_Context	String	__FLEX_Context Context	The invoice line descriptive flexfield context segment.
__FLEX_Context_DisplayValue	String	FLEX_Context Context_Display Value	The invoice line descriptive flexfield context segment displayed value.

receivablesInvoiceLineTransactionDFF

This child level resource of receivablesInvoiceLines contains information related to the invoice line transaction descriptive flexfields. The attributes of the resource are:

Attribute Name	Attribute Type	Attribute Label	Attribute Description
CustomerTrxLineId	Integer	Transaction Line ID	The unique identifier of the invoice line transaction descriptive flexfield.
__FLEX_Context	String	__FLEX_Context Context	The invoice line transaction descriptive flexfield context segment.
__FLEX_Context_DisplayValue	String	FLEX_Context Context_Display Value	The invoice line transaction descriptive flexfield context segment displayed value.

receivablesInvoiceLineGDF

This child level resource of receivablesInvoiceLines contains information related to the invoice lines global descriptive flexfields. The attributes of the resource are:

Attribute Name	Attribute Type	Attribute Label	Attribute Description
CustomerTrxLineId	Integer	Transaction Line ID	The unique identifier of the invoice line global descriptive flexfield.
__FLEX_Context	String	__FLEX_Context Context	The invoice line global descriptive flexfield context segment.
__FLEX_Context_DisplayValue	String	FLEX_Context Context_Display Value	The invoice line global descriptive flexfield context segment displayed value.

receivablesInvoiceLineTaxLines

This child level resource of receivablesInvoiceLines contains information related to the receivables invoice line tax lines. The attributes of the resource are:

Attribute Name	Attribute Type	Attribute Label	Attribute Description
CustomerTransactionLineId	Integer	Transaction Line ID	The unique identifier of each separate tax line of the invoice.
TaxLineNumber	Number	Tax Line Number	The line number of the tax line of the invoice line.
CreatedBy	String	Created By	The user who created the record.
CreationDate	DateTime	Creation Date	The date and time when the record was created.
LastUpdatedBy	String	Last Update By	The user who last updated the record.
LastUpdateDate	DateTime	Last Update Date	The date and time when the record was last updated.
TaxJurisdictionCode	String	Tax Jurisdiction Code	The tax jurisdiction code assigned to the tax line.
TaxRate	Number	Tax Rate	The tax rate assigned to the invoice line.
TaxRateCode	String	Tax Rate Code	The tax rate code assigned to the invoice line.
TaxRegimeCode	String	Tax Regime Code	The tax regime code assigned to the tax line.
TaxStatusCode	String	Tax Status Code	The tax status code assigned to the tax line.
Tax	String	Tax	The code of the tax assigned to the tax line.
TaxAmount	Number	Tax Amount	The tax amount on the invoice line in the entered currency.
TaxableAmount	Number	Taxable Amount	The amount on the invoice line eligible for taxation. The tax rate is applied to the taxable amount.
TaxPointBasis	String	Tax Point Basis	The transaction event that is the basis for tax on the invoice line.
TaxPointDate	Date	Tax Point Date	The date when the taxpayer becomes liable for paying the tax to the tax authority. Valid values are delivery date, invoice date, and pickup date.
PlaceOfSupply	String	Place of Supply	The location where the transaction on the invoice line is determined to take place for tax purposes.
TaxInclusiveIndicator	String	Tax Inclusive Indicator	The option that indicates whether the invoice line amount is inclusive of tax.

receivablesInvoiceInstallments

This child level resource of receivablesInvoices contains information related to the attributes of the installments within the invoice. The attributes of the resource are:

Attribute Name	Attribute Type	Attribute Label	Attribute Description
InstallmentId	Number	Installment ID	The unique identifier of the invoice installment.
InstallmentSequenceNumber	Number	Installment Sequence Number	The sequence number of the invoice installment.
InstallmentDueDate	Date	Installment Due Date	The due date of the installment.
OriginalAmount	Number	Original Amount	The original due amount of the installment.
PaymentDaysLate	Number	Payment Days Late	The number of days after the due date of the installment.
InstallmentBalanceDue	Number	Installment Balance Due	The outstanding balance on the installment.
InstallmentStatus	String	Installment Status	The status of the installment.
DisputeAmount	Number	Dispute Amount	The amount in dispute on the installment.
DisputeDate	Date	Dispute Date	The date when a dispute was recorded against the installment.
InstallmentClosedDate	Date	Installment Closed Date	The actual date when the payment schedule was closed.
InstallmentGLClosedDate	Date	Installment GL Closed Date	The accounting date when the payment schedule was closed.
AccountedBalanceDue	Number	Accounted Balance Due	The amount due on the installment in the ledger currency.
InstallmentAmountAdjusted	Number	Installment Amount Adjusted	The amount that was adjusted on the installment.
InstallmentAmountCredited	Number	Installment Amount Credited	The amount that was credited on the installment.
AmountPaid	Number	Amount Paid	The amount that was paid on the installment.
PendingAdjustmentAmount	Number	Pending Adjustment Amount	The adjustment amount on the installment that is pending approval.
InstallmentLineAmountOriginal	Number	Installment Line Amount Original	The original transaction line amount of the installment.
InstallmentLineAmountDue	Number	Installment Line Amount Due	The transaction line amount due on the installment.
InstallmentFreightAmountOriginal	Number	Installment Freight Amount Original	The original freight amount of the installment.
InstallmentFreightAmountDue	Number	Installment Freight Amount Due	The freight amount due on the installment.
InstallmentTaxAmountOriginal	Number	Installment Tax Amount Original	The original tax amount of the installment.
InstallmentTaxAmountDue	Number	Installment Tax Amount Due	The tax amount due on the installment.
CreationDate	DateTime	Creation Date	The date and time when the record was created.
CreatedBy	String	Created By	The user who created the record.
LastUpdateDate	DateTime	Last Update Date	The date and time when the record was last updated.
LastUpdatedBy	String	Last Updated By	The user who last updated the record.

receivablesInvoiceInstallmentGDF

This child level resource of receivablesInvoiceInstallment contains information related to the invoice installment global descriptive flexfields. The attributes of the resource are:

Attribute Name	Attribute Type	Attribute Label	Attribute Description
PaymentScheduleId	Number	Installment ID	The unique identifier of the installment global descriptive flexfield.
FLEX_PARAM_GLOBAL_COUNTRY_CODE	String	FLEX_PARAM_GLOBAL_COUNTRY_CODE	The installment global descriptive flexfield country code.
__FLEX_Context	String	__FLEX_Context	The installment global descriptive flexfield context segment.
_FLEX_NumOfSegments	String	_FLEX_NumOfSegments	The installment global descriptive flexfield context segment displayed value.

receivablesInvoiceInstallmentNotes

This child level resource of receivablesInvoiceInstallmentNotes contains information related to the invoice installment notes. The attributes of the resource are:

Attribute Name	Attribute Type	Attribute Label	Attribute Description
NoteId	Integer	Note ID	The unique identifier of the installment note.
SourceObjectCode	String	Related Object Type	The code indicating the source object as defined in OBJECTS Metadata. Possible values are Activities, Opportunities, and Sales Business Plan.
SourceObjectId	String	Related Object ID	The unique identifier of the source object as defined in OBJECTS Metadata. Examples are Activities and Opportunities.
PartyName	String	Author	The name of the party associated with the note on the installment.
NoteTxt	attachment	Note Text	The text of the note on the installment.
NoteTypeCode	String	Note Type	The code for categorization of the note type. A list of valid values is defined in the lookup NoteSourceTypeVA.
VisibilityCode	String	Visibility	The visibility level of the note, such as Private, Internal, or External. A list of valid values is defined in the lookup NoteVisibilityLookupVA.
CreatorPartyId	Integer	Creator Party ID	The unique identifier of the party who created the note.
CreatedBy	String	Created By	The user who created the note.
CreationDate	Date	Creation Date	The date and time when the note was created.
LastUpdateDate	String	Last Update Date	The date when the note was last updated.
PartyId	Integer	Party ID	The unique identifier of the party associated with the note.
CorpCurrencyCode	String	Corporate Currency Code	The corporate currency code of the note associated with the contact.
CurcyConvRateType	String	Currency Conversion Rate Type	The currency conversion rate type associated with the note.
CurrencyCode	String	Currency	The currency code associated with the note.
ContactRelationshipId	String	Contact Relationship ID	The unique identifier of the relationship populated when the note is associated with a contact.
LastUpdatedBy	String	Last Update By	The user who last updated the note.
LastUpdateLogin	String	Last Update Login	The login of the user who last updated the note.
UpdateFlag	String	Update Indicator	The option used to indicate whether the note can be updated.
DeleteFlag	String	Delete Indicator	The option used to indicate whether the note can be deleted.

attachments

This child level resource of receivablesInvoice contains information related to the attachments of the invoice. The attributes of the resource are:

Attribute Name	Attribute Type	Attribute Label	Attribute Description
AttachedDocumentId	Integer	Attached Document ID	The unique identifier of a document attached to the invoice.
LastUpdateDate	Date	Last Update Date	The date when the record was last updated.
LastUpdatedBy	String	Last Updated By	The user who last updated the record.
DatatypeCode	String	Type	The value that indicates the data type code of the attachment.
FileName	String	File Name	The file name of the attachment.
DmFolderPath	String	Dm Folder Path	The folder path of the attachment.
Url	String	Url	The URL of the attachment.
CategoryName	String	Category	The category of the attachment.
UserName	String	Category Name	The user login name associated with the attachment.
Uri	String	Uri	The URI of the attachment.
FileUrl	String	File Url	The URL of the attachment file.
UploadedText	String	Uploaded Text	The text of the attachment.
UploadedFileContentType	String	Uploaded File Content Type	The content type of the attachment file.
UploadedFileLength	String	Uploaded File Length	The length of the attachment file.
UploadedFileName	String	Uploaded File Name	The name of the attachment file.
ContentRepositoryFileShared	String	Content Repository File Shared	The option used to indicate whether the attachment is shared.
Title	String	Title	The title of the attachment.
Description	String	Description	The description of the attachment.
ErrorStatusCode	String	Error Status Code	The error code, if any, for the attachment.
ErrorStatusMessage	String	Error Status Message	The error message, if any, for the attachment.
CreatedBy	String	Created By	The user who created the record.
CreationDate	Date	Creation Date	The date when the record was created.
FileContents	attachment	File Contents	The contents of the attachment file.
ExpirationDate	String	Expiration Date	The date when the contents of the attachment expire.
LastUpdatedByUserName	String	Last Updated By User Name	The name of the user who last updated the attachment.
CreatedByUserName	String	Created By User Name	The name of the user who created the attachment.

notes

This child level resource of receivablesInvoice contains information related to the receivables notes. The attributes of the resource are:

Attribute Name	Attribute Type	Attribute Label	Attribute Description
NoteId	Integer	Note ID	The unique identifier of the note.
SourceObjectCode	String	Related Object Type	The code indicating the source object as defined in OBJECTS Metadata. Possible values are Activities, Opportunities, and Sales Business Plan.
SourceObjectId	String	Related Object	The unique identifier of the source object as defined in OBJECTS Metadata. Examples are Activities and Opportunities.
PartyName	String	Author	The name of the party associated with the note on the invoice.
NoteTxt	attachment	Note Text	The text of the note on the invoice.
NoteTypeCode	String	Type	The code for categorization of the note type. A list of valid values is defined in the lookup NoteSourceTypeVA.
VisibilityCode	String	Visibility	The visibility level of the note, such as Private, Internal, or External. A list of valid values is defined in the lookup NoteVisibilityLookupVA.
CreatorPartyId	Integer	Creator Party ID	The unique identifier of the party who created the note.
CreatedBy	String	Created By	The user who created the note.
CreationDate	Date	Creation Date	The date when the note was created.
LastUpdateDate	String	Last Update Date	The date when the note was last updated.
PartyId	Integer	Party ID	The unique identifier of the party associated with the note.
CorpCurrencyCode	String	Corporate Currency Code	The corporate currency code of the note associated with the contact.
CurcyConvRateType	String	Currency Conversion Rate Type	The currency conversion rate type associated with the note.
CurrencyCode	String	Currency Code	The currency code associated with the note.
ContactRelationshipId	String	Contact Relationship ID	The unique identifier of the relationship populated when the note is associated with a contact.
LastUpdatedBy	String	Last Update By	The login of the user who last updated the note.
LastUpdateLogin	String	Last Update Login	The login of the user who last updated the record.
UpdateFlag	String	Update Indicator	The option used to indicate whether the note can be updated.
DeleteFlag	String	Delete Indicator	The option used to indicate whether the note can be deleted.

2.3 Setups and Security

2.3.1 Prerequisite Setups

The prerequisite setups needed to invoke the Receivables Invoice REST service are the same as that of creating an invoice. These can be set up in the Fusion instance through the Functional Setup Manager.

· Receivables System Options

· Receivables Payment Terms

· Transaction Type

· Transaction Source

· Auto-Accounting Rule

· Remit-to Address

· Customer

Flexfields can be set up to record additional information for the invoice. Refer to Transaction Flexfields and AutoInvoice: Explained for information on how to leverage flexfields for your business.

2.3.2 Security Details

To access REST APIs, user roles must have the right security privileges. You must also include job roles, if any, for the APIs. To use the Receivables Invoices REST service, you must have these function security privileges. Add them to custom job roles, as required. You can also include any seeded job role that has the function security privileges mentioned below to access REST services.

Functional Security Privilege Name - AR_CREATE_RECEIVABLES_INVOICE_PRIV

Resource and Method - receivablesInvoices (GET, POST, and PATCH)

2.4 Invoking the Receivables Invoice REST Service

URL Path for the Receivables Invoice REST Service

The URL paths for all the ERP REST resources use the new root context value fscmRestApi.

Example REST API URL path for Receivables Invoices is

https://<host>:<port>//fscmRestApi/resources/11.13.x.x/receivablesInvoices

11.13.x.x has to be replaced with the current version of REST API delivered and the same is documented in Oracle Help Center REST API documentation.

Release 13 URL Path https://<host>:<port>//fscmRestApi/resources/11.13.0.0/receivablesInvoices

2.5 Request Processing and Error Handling

When a service request is processed, several scenarios could occur. The request could return a response, it could error with a handled exception, or error with an unhandled exception.

Please refer to Appendix 3.4 for the details on the error messages and the corresponding message text associated with each error message.

Here are some examples of situations which could be encountered when a request is submitted:

a) A service request is submitted and successfully processed:

For example: if a create invoice request is submitted and successfully processed, a response is returned. The response would create an invoice.

b) In the case of a handled exception, if a service request is submitted and the response did not come up with any matching information, it will return with a message.

For example: a service request to create an invoice is submitted and a response is returned. However, the system could not create the invoice because there is no matching business unit. The response would communicate an error message to the user ‘The business unit you entered does not exist.’

c) In the case of an unhandled exception, if a service request is submitted and there is no response from the REST service, it will return with a status:

For example: a service request to get an invoice is submitted, but the server is down, and the request could not be processed. When an unexpected condition is encountered, and no specific message is suitable, the system would return a status code of ‘500 Internal Server Error’.

3 Appendix

3.1 Testing the Receivables Invoices Rest Service

You can test REST services using Oracle’s APEX RESTful service test, an internet-accessible application or a programming platform that supports protocols to transfer data, such as POSTMAN, cURL, or other REST clients.

The following table shows examples of the POST, GET, and DELETE operations on the receivablesinvoices resource using cURL.

Operation	cURL Command
POST (Creating an invoice)	curl --user ALL_FUNCTION_ALL_DATA:Welcome1 -X POST -H "Content-Type: application/vnd.oracle.adf.resourceitem+json" --data @customerTransaction_create_payload.json "https://<host>:<port>/fscmRestApi/resources/11.13.0.0/receivablesinvoices"
GET (Retrieving an invoice)	curl --user <Username>:<Password> -X GET "https://<host>:<port>//fscmRestApi/resources/11.13.0.0/receivablesinvoices? finder=PrimaryKey;CustomerTransactionId =100100060574233"
DELETE (Updating an invoice)	curl --user <Username>:<Password> -X PATCH -H "Content-Type: application/vnd.oracle.adf.resourceitem+json" --data @customertransaction update_payload.json "https://<host>:<port>/fscmRestApi/resources/11.13.0.0/receivablesinvoices/{CustomerTransactionId}"

Operation

cURL Command

POST

(Creating an invoice)

curl --user ALL_FUNCTION_ALL_DATA:Welcome1 -X POST -H "Content-Type: application/vnd.oracle.adf.resourceitem+json" --data @customerTransaction_create_payload.json

"https://<host>:<port>/fscmRestApi/resources/11.13.0.0/receivablesinvoices"

GET

(Retrieving an invoice)

curl --user <Username>:<Password> -X GET "https://<host>:<port>//fscmRestApi/resources/11.13.0.0/receivablesinvoices? finder=PrimaryKey;CustomerTransactionId =100100060574233"

DELETE

(Updating an invoice)

curl --user <Username>:<Password> -X PATCH -H "Content-Type: application/vnd.oracle.adf.resourceitem+json"

--data @customertransaction update_payload.json

"https://<host>:<port>/fscmRestApi/resources/11.13.0.0/receivablesinvoices/{CustomerTransactionId}"

3.2 Use Cases

The typical use cases for the Receivables Invoice REST Service are shown below:

a) Use Case: Create an invoice with lines

You can use the Receivables Invoice resource to create invoices in Receivables with lines.

Example:

A customer goes to the web store and places an order for a laptop, battery, and charger. The invoice lines contain the detail information.

REST Service

Use the REST Service to create an invoice with lines.

Refer to Appendix 3.3.1 for the sample request and response payload to create an invoice with lines.

b) Use Case: Get details of a specific invoice

You can use the Get Method of the Receivables Invoice Service to retrieve details of a specific invoice to find out its details or to trigger follow-up action.

Example:

A customer logs in to a self-service customer portal to find and retrieve the invoice to view details of the invoice, including the invoice lines and amounts, to find out why he was incorrectly billed for internet service.

REST Service

Use the REST service to get the invoice with the invoice number, lines, and amount.

Refer to Appendix 3.3.2 for the sample request and response payload to get a specific invoice and its details.

c) Use Case: Find invoices that are overdue

You can use the Receivables Invoice resource to find invoices that are overdue for a customer.

Example:

A seller wants to check on a customer’s invoices to view how many invoices are overdue and the amounts that are overdue.

REST Service

Use the REST service to search for the past due invoices with the invoice number and due date for the customer that has past due dates.

Refer to Appendix 3.3.3 for the sample request and response payload to find invoices that are overdue.

d) Use Case: Create an invoice with automatic receipt method

You can use the Receivables Invoice resource to create invoices in Receivables with an automatic receipt method.

Example:

A customer goes to the web store and places an order for a computer monitor. The invoice will be paid with an automatic receipt method.

REST Service

Use the REST Service to create an invoice with an automatic clearing receipt method.

Refer to Appendix 3.3.4 for the sample request and response payload to create an invoice with an automatic receipt method.

e) Use Case: Create an invoice with “In Advance” invoicing rule, and revenue scheduling rule

You can use the Receivables Invoice REST Service to create an invoice in Receivables with an invoicing rule and revenue scheduling rule.

Example:

A computer store is selling computers with warranty and the revenue is to be recognized over time.

REST Service

Use the REST Service to initiate a request to create an invoice in Receivables with the ‘In Advance’ invoicing rule and a revenue scheduling rule to allow revenue recognition over several months.

Refer to Appendix 3.3.5 for the sample request and response payload to create an invoice with the “In Advance” invoicing rule and a revenue scheduling rule.

f) Use Case: Create an invoice with split payment method and add an attachment

You can use the Receivables Invoice resource to create invoices in Receivables with split payment terms and attach a document.

Example:

A customer purchases a new autonomous database server and has an agreement to pay in installments over 90 days. Instructions on how to install and maintain the server are appended to the invoice.

REST Service

Use the REST Service to create an invoice with 30/60/90 payment terms, as the customer will pay in installments. Attach a manual on how to configure and maintain the server to the invoice.

Refer to Appendix 3.3.6 for the sample request and response payload to create an invoice with split payment method and add an attachment.

g) Use Case: Create an invoice with foreign currency and descriptive flexfield

You can use the Receivables Invoice REST Service to create invoices in Receivables to bill customers for goods sold or services rendered in a foreign currency.

Example:

A visitor to the U.S. (Ledger Currency is USD) logs into a web store to browse for laptops and support services. He submits an order for a high-speed processor computer, with 12 GB memory, and adds information about the Green color, and geographic location (Paris) of the laptop he wishes to purchase with a foreign currency.

REST Service

Use the REST Service to initiate a request from the web store to create an invoice with the foreign currency in Oracle Receivables for a laptop, supporting services, and a descriptive flexfield to capture additional information color and location for the customer.

Refer to Appendix 3.3.7 for the sample request and response payload to create an invoice with foreign currency and descriptive flexfield.

h) Use Case: Delete an invoice

You can use the Receivables Invoice resource to delete an invoice that is created with the incorrect transaction source.

Example:

The user created an invoice with an incorrect transaction source. He deletes the invoice.

REST Service

Use the REST service to delete the incorrectly created invoice.

Refer to Appendix 3.3.8 for the sample request and response payload to delete a specific invoice.

i) Use Case: Complete an invoice

You can use the Receivables Invoice REST Service to complete the invoice.

Example:

Users of an organization create invoices in Receivables manually. The users are situated across the world. The invoices created are incomplete. The finance supervisor reviews the invoices and completes them.

REST Service

Use the REST service to complete an invoice.

Refer to Appendix 3.3.9 for the sample request and response payload to complete an invoice.

j) Use Case: Incomplete an invoice

You can use the Receivables Invoice REST Service to incomplete an invoice.

Example:

A customer calls the call center to inform them of the change of their bill-to address and wants all invoices due for payment from the current date to be sent to the new address.

Use the REST Service to update the Complete flag of an invoice by passing the Complete flag value as N to the Receivables Invoice REST service to incomplete the invoice. Then the new bill-to site can be selected for the invoice.

REST Service

Use the REST service to incomplete an invoice.

Refer to Appendix 3.3.10 for the sample request and response payload to incomplete an invoice.

k) Use Case: Update installments of an invoice

You can use the Receivables Invoice REST Service to update the installments on an invoice in Receivables.

Example:

The customer places an order for a service, and has opted to pay using flexible billing terms instead of the default payment terms chosen at the time of placing the order. The invoice is retrieved by performing a get operation using the Receivables invoices REST service. Use the Receivables Invoice REST Service to update the due dates and amounts on installments of the invoice.

REST Service

Use the REST service to update the installments of an invoice.

Refer to Appendix 3.3.11 for the sample request and response payload to update the installments of an invoice.

l) Use Case: Update the payment terms on an invoice

You can use the Receivables Invoice REST Service to update the payment terms on an invoice in Receivables.

Example:

A high-value customer of an organization has negotiated better payment terms on their purchases and wants the same to be reflected on the invoices due effective today. All invoices created with due date from the current date of the month are retrieved by performing find operation using the Receivables Invoice REST service.

REST Service

Use the REST service to update the payment term of an invoice.

Refer to Appendix 3.3.12 for the sample request and response payload to update the payment terms oo an invoice.

m) Use Case: Create manual tax lines on an invoice

You can use the Receivables Invoice REST Service to create a tax line on an invoice line.

Example:

A customer uses an external order booking system to place and book orders. The external order booking system also calculates the tax for the orders booked and shipped. Use the Receivables Invoice REST service to integrate and create the invoice lines for the orders fulfilled and their related tax calculations. The Receivables Invoice REST service allows the user to create manual tax lines along with the invoice and its invoice lines.

REST Service

Use the REST service to create a tax line on a line of an invoice.

Refer to Appendix 3.3.13 for the sample request and response payload to create a tax line for a line of an invoice.

3.3 Examples of Sample Payloads

Following section provides the sample Request and Response payloads for the operations in Receivables Invoices Service.

3.3.1 Sample Payload to Create an Invoice with Lines

Sample URL

https://<host>:<port>/fscmRestApi/resources/11.13.0.0/receivablesInvoices

Sample Request Payload that the Client Sends

{

"BillingDate": "2018-02-20",

"BillToCustomerNumber": "1008",

"BusinessUnit": "Vision Operations",

"Comments": "New Laptop Promotion",

"DueDate": "2018-02-20",

"InternalNotes": "Best Priced item",

"InvoiceCurrencyCode": "USD",

"PaymentTerms": "30 Net",

"TransactionDate": "2018-02-20",

"TransactionSource": "Manual-NES",

"ShipToCustomerName": "Total Internet",

"ShipToCustomerNumber": "1008",

"ShipToSite": "1042",

"TransactionType": "Invoice",

"receivablesInvoiceLines": [

{

"Description" : "Laptop",

"LineNumber": 1,

"Quantity": 2,

"UnitSellingPrice": 1299.99

{

"Description" : "Battery",

"LineNumber": 2,

"Quantity": 2,

"UnitSellingPrice": 102.15

{

"Description" : "Charger",

"LineNumber": 3,

"Quantity": 4,

"UnitSellingPrice": 65.45

}

]

}

Sample Response Payload that the Client Receives

{

"CustomerTransactionId": 300100170996427,

"DueDate": "2018-02-20",

"ConversionDate": null,

"ConversionRate": null,

"InvoiceCurrencyCode": "USD",

"SpecialInstructions": null,

"CrossReference": null,

"DocumentNumber": null,

"TransactionNumber": "1007",

"TransactionDate": "2018-02-20",

"TransactionType": "Invoice",

"TransactionSource": "Manual-NES",

"BillToCustomerNumber": "1008",

"BillToSite": "Foster City (OPS)",

"Comments": "New Laptop Promotion",

"InternalNotes": "Best Priced item",

"PaymentTerms": "30 Net",

"LegalEntityIdentifier": "USSYS12030",

"ConversionRateType": null,

"PurchaseOrder": null,

"PurchaseOrderDate": null,

"PurchaseOrderRevision": null,

"FirstPartyRegistrationNumber": "4567890",

"ThirdPartyRegistrationNumber": null,

"InvoicingRule": null,

"ShipToCustomerName": "Total Internet",

"ShipToCustomerNumber": "1008",

"BillingDate": "2018-02-20",

"BusinessUnit": "Vision Operations",

"InvoiceStatus": null,

"AccountingDate": null,

"ShipToSite": "1042",

"PayingCustomerName": null,

"PayingCustomerSite": null,

"BillToCustomerName": null,

"FreightAmount": null,

"Carrier": null,

"ShipDate": null,

"ShippingReference": null,

"BillToContact": null,

"ShipToContact": null,

"PrintOption": null,

"CreatedBy": "AR_MGR_OPERATIONS",

"CreationDate": "2018-12-19T05:30:04.003+00:00",

"LastUpdatedBy": "AR_MGR_OPERATIONS",

"LastUpdateDate": "2018-12-19T05:30:04.841+00:00",

"PayingCustomerAccount": null,

"SoldToPartyNumber": null,

"RemitToAddress": null,

"DefaultTaxationCountry": null,

"EnteredAmount": null,

"InvoiceBalanceAmount": null,

"Prepayment": null,

"Intercompany": null,

"DocumentFiscalClassification": null,

"BankAccountNumber": null,

"CreditCardAuthorizationRequestIdentifier": null,

"CreditCardExpirationDate": null,

"CreditCardIssuerCode": null,

"CreditCardTokenNumber": null,

"CreditCardVoiceAuthorizationCode": null,

"CreditCardErrorCode": null,

"CreditCardErrorText": null,

"CardHolderLastName": null,

"CardHolderFirstName": null,

"ReceiptMethod": null,

"SalesPersonNumber": null,

"StructuredPaymentReference": null,

"receivablesInvoiceLines": [

{

"CustomerTransactionLineId": 300100170996428,

"LineNumber": 1,

"Description": "Laptop",

"Quantity": 2,

"UnitSellingPrice": 1299.99,

"TaxClassificationCode": null,

"SalesOrder": null,

"AccountingRuleDuration": null,

"RuleEndDate": null,

"RuleStartDate": null,

"AccountingRule": null,

"Warehouse": null,

"MemoLine": null,

"UnitOfMeasure": null,

"ItemNumber": null,

"AllocatedFreightAmount": null,

"AssessableValue": null,

"SalesOrderDate": null,

"LineAmount": null,

"CreatedBy": "AR_MGR_OPERATIONS",

"CreationDate": "2018-12-19T05:30:04.321+00:00",

"LastUpdatedBy": "AR_MGR_OPERATIONS",

"LastUpdateDate": "2018-12-19T05:30:04.847+00:00",

"TransacationBusinessCategory": null,

"UserDefinedFiscalClassification": null,

"ProductFiscalClassification": null,

"ProductCategory": null,

"ProductType": null,

"LineIntendedUse": null,

"LineAmountIncludesTax": null,

"TaxInvoiceDate": null,

"TaxInvoiceNumber": null,

"TaxExemptionCertificateNumber": null,

"TaxExemptionHandling": null,

"TaxExemptionReason": null,

"links": [

{

"rel": "self",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996427/child/receivablesInvoiceLines/300100170996428",

"name": "receivablesInvoiceLines",

"kind": "item",

"properties": {

"changeIndicator": "ACED0005737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A65787000000001770400000001737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000178"

}

{

"rel": "canonical",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996427/child/receivablesInvoiceLines/300100170996428",

"name": "receivablesInvoiceLines",

"kind": "item"

{

"rel": "parent",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996427",

"name": "receivablesInvoices",

"kind": "item"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996427/child/receivablesInvoiceLines/300100170996428/lov/memoLines",

"name": "memoLines",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996427/child/receivablesInvoiceLines/300100170996428/lov/warehouses",

"name": "warehouses",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996427/child/receivablesInvoiceLines/300100170996428/lov/itemNumbers",

"name": "itemNumbers",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996427/child/receivablesInvoiceLines/300100170996428/lov/productCategories",

"name": "productCategories",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996427/child/receivablesInvoiceLines/300100170996428/lov/userDefinedFiscClasses",

"name": "userDefinedFiscClasses",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996427/child/receivablesInvoiceLines/300100170996428/lov/exemptReasonCodes",

"name": "exemptReasonCodes",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996427/child/receivablesInvoiceLines/300100170996428/lov/taxExemptHandlingStatuses",

"name": "taxExemptHandlingStatuses",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996427/child/receivablesInvoiceLines/300100170996428/lov/transactionBizCategories",

"name": "transactionBizCategories",

"kind": "collection"

{

"rel": "lov",

"name": "productFiscClassifications",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996427/child/receivablesInvoiceLines/300100170996428/lov/accountingRules",

"name": "accountingRules",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996427/child/receivablesInvoiceLines/300100170996428/lov/unitOfMeasures",

"name": "unitOfMeasures",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996427/child/receivablesInvoiceLines/300100170996428/lov/productTypes",

"name": "productTypes",

"kind": "collection"

{

"rel": "child",

"name": "receivablesInvoiceLineGdf",

"kind": "collection"

{

"rel": "child",

"name": "receivablesInvoiceLineTaxLines",

"kind": "collection"

{

"rel": "child",

"name": "receivablesInvoiceLineDFF",

"kind": "collection"

{

"rel": "child",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996427/child/receivablesInvoiceLines/300100170996428/child/attachments",

"name": "attachments",

"kind": "collection"

{

"rel": "child",

"name": "receivablesInvoiceLineTransactionDFF",

"kind": "collection"

}

]

{

"CustomerTransactionLineId": 300100170996429,

"LineNumber": 2,

"Description": "Battery",

"Quantity": 2,

"UnitSellingPrice": 102.15,

"TaxClassificationCode": null,

"SalesOrder": null,

"AccountingRuleDuration": null,

"RuleEndDate": null,

"RuleStartDate": null,

"AccountingRule": null,

"Warehouse": null,

"MemoLine": null,

"UnitOfMeasure": null,

"ItemNumber": null,

"AllocatedFreightAmount": null,

"AssessableValue": null,

"SalesOrderDate": null,

"LineAmount": null,

"CreatedBy": "AR_MGR_OPERATIONS",

"CreationDate": "2018-12-19T05:30:04.506+00:00",

"LastUpdatedBy": "AR_MGR_OPERATIONS",

"LastUpdateDate": "2018-12-19T05:30:04.850+00:00",

"TransacationBusinessCategory": null,

"UserDefinedFiscalClassification": null,

"ProductFiscalClassification": null,

"ProductCategory": null,

"ProductType": null,

"LineIntendedUse": null,

"LineAmountIncludesTax": null,

"TaxInvoiceDate": null,

"TaxInvoiceNumber": null,

"TaxExemptionCertificateNumber": null,

"TaxExemptionHandling": null,

"TaxExemptionReason": null,

"links": [

{

"rel": "self",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996427/child/receivablesInvoiceLines/300100170996429",

"name": "receivablesInvoiceLines",

"kind": "item",

"properties": {

}

{

"rel": "canonical",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996427/child/receivablesInvoiceLines/300100170996429",

"name": "receivablesInvoiceLines",

"kind": "item"

{

"rel": "parent",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996427",

"name": "receivablesInvoices",

"kind": "item"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996427/child/receivablesInvoiceLines/300100170996429/lov/memoLines",

"name": "memoLines",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996427/child/receivablesInvoiceLines/300100170996429/lov/warehouses",

"name": "warehouses",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996427/child/receivablesInvoiceLines/300100170996429/lov/itemNumbers",

"name": "itemNumbers",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996427/child/receivablesInvoiceLines/300100170996429/lov/productCategories",

"name": "productCategories",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996427/child/receivablesInvoiceLines/300100170996429/lov/userDefinedFiscClasses",

"name": "userDefinedFiscClasses",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996427/child/receivablesInvoiceLines/300100170996429/lov/exemptReasonCodes",

"name": "exemptReasonCodes",

"kind": "collection"

{

"rel": "lov",

"name": "taxExemptHandlingStatuses",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996427/child/receivablesInvoiceLines/300100170996429/lov/transactionBizCategories",

"name": "transactionBizCategories",

"kind": "collection"

{

"rel": "lov",

"name": "productFiscClassifications",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996427/child/receivablesInvoiceLines/300100170996429/lov/accountingRules",

"name": "accountingRules",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996427/child/receivablesInvoiceLines/300100170996429/lov/unitOfMeasures",

"name": "unitOfMeasures",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996427/child/receivablesInvoiceLines/300100170996429/lov/productTypes",

"name": "productTypes",

"kind": "collection"

{

"rel": "child",

"name": "receivablesInvoiceLineGdf",

"kind": "collection"

{

"rel": "child",

"name": "receivablesInvoiceLineTaxLines",

"kind": "collection"

{

"rel": "child",

"name": "receivablesInvoiceLineDFF",

"kind": "collection"

{

"rel": "child",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996427/child/receivablesInvoiceLines/300100170996429/child/attachments",

"name": "attachments",

"kind": "collection"

{

"rel": "child",

"name": "receivablesInvoiceLineTransactionDFF",

"kind": "collection"

}

]

{

"CustomerTransactionLineId": 300100170996430,

"LineNumber": 3,

"Description": "Charger",

"Quantity": 4,

"UnitSellingPrice": 65.45,

"TaxClassificationCode": null,

"SalesOrder": null,

"AccountingRuleDuration": null,

"RuleEndDate": null,

"RuleStartDate": null,

"AccountingRule": null,

"Warehouse": null,

"MemoLine": null,

"UnitOfMeasure": null,

"ItemNumber": null,

"AllocatedFreightAmount": null,

"AssessableValue": null,

"SalesOrderDate": null,

"LineAmount": null,

"CreatedBy": "AR_MGR_OPERATIONS",

"CreationDate": "2018-12-19T05:30:04.672+00:00",

"LastUpdatedBy": "AR_MGR_OPERATIONS",

"LastUpdateDate": "2018-12-19T05:30:04.852+00:00",

"TransacationBusinessCategory": null,

"UserDefinedFiscalClassification": null,

"ProductFiscalClassification": null,

"ProductCategory": null,

"ProductType": null,

"LineIntendedUse": null,

"LineAmountIncludesTax": null,

"TaxInvoiceDate": null,

"TaxInvoiceNumber": null,

"TaxExemptionCertificateNumber": null,

"TaxExemptionHandling": null,

"TaxExemptionReason": null,

"links": [

{

"rel": "self",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996427/child/receivablesInvoiceLines/300100170996430",

"name": "receivablesInvoiceLines",

"kind": "item",

"properties": {

}

{

"rel": "canonical",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996427/child/receivablesInvoiceLines/300100170996430",

"name": "receivablesInvoiceLines",

"kind": "item"

{

"rel": "parent",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996427",

"name": "receivablesInvoices",

"kind": "item"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996427/child/receivablesInvoiceLines/300100170996430/lov/memoLines",

"name": "memoLines",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996427/child/receivablesInvoiceLines/300100170996430/lov/warehouses",

"name": "warehouses",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996427/child/receivablesInvoiceLines/300100170996430/lov/itemNumbers",

"name": "itemNumbers",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996427/child/receivablesInvoiceLines/300100170996430/lov/productCategories",

"name": "productCategories",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996427/child/receivablesInvoiceLines/300100170996430/lov/userDefinedFiscClasses",

"name": "userDefinedFiscClasses",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996427/child/receivablesInvoiceLines/300100170996430/lov/exemptReasonCodes",

"name": "exemptReasonCodes",

"kind": "collection"

{

"rel": "lov",

"name": "taxExemptHandlingStatuses",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996427/child/receivablesInvoiceLines/300100170996430/lov/transactionBizCategories",

"name": "transactionBizCategories",

"kind": "collection"

{

"rel": "lov",

"name": "productFiscClassifications",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996427/child/receivablesInvoiceLines/300100170996430/lov/accountingRules",

"name": "accountingRules",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996427/child/receivablesInvoiceLines/300100170996430/lov/unitOfMeasures",

"name": "unitOfMeasures",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996427/child/receivablesInvoiceLines/300100170996430/lov/productTypes",

"name": "productTypes",

"kind": "collection"

{

"rel": "child",

"name": "receivablesInvoiceLineGdf",

"kind": "collection"

{

"rel": "child",

"name": "receivablesInvoiceLineTaxLines",

"kind": "collection"

{

"rel": "child",

"name": "receivablesInvoiceLineDFF",

"kind": "collection"

{

"rel": "child",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996427/child/receivablesInvoiceLines/300100170996430/child/attachments",

"name": "attachments",

"kind": "collection"

{

"rel": "child",

"name": "receivablesInvoiceLineTransactionDFF",

"kind": "collection"

}

]

}

"links": [

{

"rel": "self",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996427",

"name": "receivablesInvoices",

"kind": "item",

"properties": {

}

{

"rel": "canonical",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996427",

"name": "receivablesInvoices",

"kind": "item"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996427/lov/transactionSources",

"name": "transactionSources",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996427/lov/businessUnits",

"name": "businessUnits",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996427/lov/PaymentTermsVA",

"name": "PaymentTermsVA",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996427/lov/thirdPartyTaxRegistrationNumbers",

"name": "thirdPartyTaxRegistrationNumbers",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996427/lov/invoiceStatuses",

"name": "invoiceStatuses",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996427/lov/shipToCustomers",

"name": "shipToCustomers",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996427/lov/billToCustomers",

"name": "billToCustomers",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996427/lov/legalEntities",

"name": "legalEntities",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996427/lov/invoicingRules",

"name": "invoicingRules",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996427/lov/billToSites",

"name": "billToSites",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996427/lov/taxationCountries",

"name": "taxationCountries",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996427/lov/firstPartyTaxRegistrationNumbers",

"name": "firstPartyTaxRegistrationNumbers",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996427/lov/transactionTypes",

"name": "transactionTypes",

"kind": "collection"

{

"rel": "child",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996427/child/receivablesInvoiceLines",

"name": "receivablesInvoiceLines",

"kind": "collection"

{

"rel": "child",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996427/child/receivablesInvoiceTransactionDFF",

"name": "receivablesInvoiceTransactionDFF",

"kind": "collection"

{

"rel": "child",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996427/child/receivablesInvoiceGdf",

"name": "receivablesInvoiceGdf",

"kind": "collection"

{

"rel": "child",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996427/child/receivablesInvoiceInstallments",

"name": "receivablesInvoiceInstallments",

"kind": "collection"

{

"rel": "child",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996427/child/receivablesInvoiceDFF",

"name": "receivablesInvoiceDFF",

"kind": "collection"

{

"rel": "child",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996427/child/attachments",

"name": "attachments",

"kind": "collection"

{

"rel": "child",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996427/child/notes",

"name": "notes",

"kind": "collection"

}

]

}

3.3.2 Sample Payload to Get a Details of a Specific Invoice

Sample URL

https://<host>:<port>/fscmRestApi/resources/11.13.0.0/receivablesInvoices?finder=PrimaryKey;CustomerTransactionId=<CustomerTransactionId>

Sample Request Payload that the Client Sends

https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996427

Sample Response Payload that the Client Receives

{

"CustomerTransactionId": 300100170996427,

"DueDate": "2018-02-20",

"ConversionDate": null,

"ConversionRate": null,

"InvoiceCurrencyCode": "USD",

"SpecialInstructions": null,

"CrossReference": null,

"DocumentNumber": null,

"TransactionNumber": "1007",

"TransactionDate": "2018-02-20",

"TransactionType": "Invoice",

"TransactionSource": "Manual-NES",

"BillToCustomerNumber": "1008",

"BillToSite": "Foster City (OPS)",

"Comments": "New Laptop Promotion",

"InternalNotes": "Best Priced item",

"PaymentTerms": "30 Net",

"LegalEntityIdentifier": "USSYS12030",

"ConversionRateType": null,

"PurchaseOrder": null,

"PurchaseOrderDate": null,

"PurchaseOrderRevision": null,

"FirstPartyRegistrationNumber": "4567890",

"ThirdPartyRegistrationNumber": null,

"InvoicingRule": null,

"ShipToCustomerName": "Total Internet",

"ShipToCustomerNumber": "1008",

"BillingDate": "2018-02-20",

"BusinessUnit": "Vision Operations",

"InvoiceStatus": "Complete",

"AccountingDate": "2018-02-20",

"ShipToSite": "1042",

"PayingCustomerName": "Total Internet",

"PayingCustomerSite": "Foster City (OPS)",

"BillToCustomerName": "Total Internet",

"FreightAmount": null,

"Carrier": null,

"ShipDate": null,

"ShippingReference": null,

"BillToContact": null,

"ShipToContact": null,

"PrintOption": "Yes",

"CreatedBy": "AR_MGR_OPERATIONS",

"CreationDate": "2018-12-19T05:30:04.003+00:00",

"LastUpdatedBy": "AR_MGR_OPERATIONS",

"LastUpdateDate": "2018-12-19T05:30:04.841+00:00",

"PayingCustomerAccount": "1008",

"SoldToPartyNumber": "1008",

"RemitToAddress": "ZD, Park Avenue St",

"DefaultTaxationCountry": "US",

"EnteredAmount": 3066.08,

"InvoiceBalanceAmount": 3066.08,

"Prepayment": "No",

"Intercompany": "No",

"DocumentFiscalClassification": null,

"BankAccountNumber": null,

"CreditCardAuthorizationRequestIdentifier": null,

"CreditCardExpirationDate": null,

"CreditCardIssuerCode": null,

"CreditCardTokenNumber": null,

"CreditCardVoiceAuthorizationCode": null,

"CreditCardErrorCode": null,

"CreditCardErrorText": null,

"CardHolderLastName": null,

"CardHolderFirstName": null,

"ReceiptMethod": null,

"SalesPersonNumber": null,

"StructuredPaymentReference": null,

"links": [

{

"rel": "self",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996427",

"name": "receivablesInvoices",

"kind": "item",

"properties": {

"changeIndicator": "ACED0005737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A657870000000017704000000017372001B6F7261636C652E6A626F2E646F6D61696E2E4E756C6C56616C75655899C1C58DAABEEB02000149000A6D53514C54797065496478700000000C78"

}

{

"rel": "canonical",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996427",

"name": "receivablesInvoices",

"kind": "item"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996427/lov/transactionSources",

"name": "transactionSources",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996427/lov/businessUnits",

"name": "businessUnits",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996427/lov/PaymentTermsVA",

"name": "PaymentTermsVA",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996427/lov/thirdPartyTaxRegistrationNumbers",

"name": "thirdPartyTaxRegistrationNumbers",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996427/lov/invoiceStatuses",

"name": "invoiceStatuses",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996427/lov/shipToCustomers",

"name": "shipToCustomers",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996427/lov/billToCustomers",

"name": "billToCustomers",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996427/lov/legalEntities",

"name": "legalEntities",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996427/lov/invoicingRules",

"name": "invoicingRules",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996427/lov/billToSites",

"name": "billToSites",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996427/lov/taxationCountries",

"name": "taxationCountries",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996427/lov/firstPartyTaxRegistrationNumbers",

"name": "firstPartyTaxRegistrationNumbers",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996427/lov/transactionTypes",

"name": "transactionTypes",

"kind": "collection"

{

"rel": "child",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996427/child/receivablesInvoiceLines",

"name": "receivablesInvoiceLines",

"kind": "collection"

{

"rel": "child",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996427/child/receivablesInvoiceTransactionDFF",

"name": "receivablesInvoiceTransactionDFF",

"kind": "collection"

{

"rel": "child",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996427/child/receivablesInvoiceGdf",

"name": "receivablesInvoiceGdf",

"kind": "collection"

{

"rel": "child",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996427/child/receivablesInvoiceInstallments",

"name": "receivablesInvoiceInstallments",

"kind": "collection"

{

"rel": "child",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996427/child/receivablesInvoiceDFF",

"name": "receivablesInvoiceDFF",

"kind": "collection"

{

"rel": "child",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996427/child/attachments",

"name": "attachments",

"kind": "collection"

{

"rel": "child",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996427/child/notes",

"name": "notes",

"kind": "collection"

}

]

}

3.3.3 Sample Payload to Find Invoices that are Overdue

Sample URL

https://<host>:<port>/fscmRestApi/resources/11.13.0.0/receivablesInvoices?finder=invoiceSearch;TransactionNumber=”<TransactionNumber>“

Sample Request Payload that the Client Sends

https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices?finder=invoiceSearch;ShipToCustomerName=Total Internet,InvoiceStatus=Complete,DueDate=2018-02-20

Sample Response Payload that the Client Receives

{

"items": [

{

"CustomerTransactionId": 300100170996427,

"DueDate": "2018-02-20",

"ConversionDate": null,

"ConversionRate": null,

"InvoiceCurrencyCode": "USD",

"SpecialInstructions": null,

"CrossReference": null,

"DocumentNumber": null,

"TransactionNumber": "1007",

"TransactionDate": "2018-02-20",

"TransactionType": "Invoice",

"TransactionSource": "Manual-NES",

"BillToCustomerNumber": "1008",

"BillToSite": "Foster City (OPS)",

"Comments": "New Laptop Promotion",

"InternalNotes": "Best Priced item",

"PaymentTerms": "30 Net",

"LegalEntityIdentifier": "USSYS12030",

"ConversionRateType": null,

"PurchaseOrder": null,

"PurchaseOrderDate": null,

"PurchaseOrderRevision": null,

"FirstPartyRegistrationNumber": "4567890",

"ThirdPartyRegistrationNumber": null,

"InvoicingRule": null,

"ShipToCustomerName": "Total Internet",

"ShipToCustomerNumber": "1008",

"BillingDate": "2018-02-20",

"BusinessUnit": "Vision Operations",

"InvoiceStatus": "Complete",

"AccountingDate": "2018-02-20",

"ShipToSite": "1042",

"PayingCustomerName": "Total Internet",

"PayingCustomerSite": "Foster City (OPS)",

"BillToCustomerName": "Total Internet",

"FreightAmount": null,

"Carrier": null,

"ShipDate": null,

"ShippingReference": null,

"BillToContact": null,

"ShipToContact": null,

"PrintOption": "Yes",

"CreatedBy": "AR_MGR_OPERATIONS",

"CreationDate": "2018-12-19T05:30:04.003+00:00",

"LastUpdatedBy": "AR_MGR_OPERATIONS",

"LastUpdateDate": "2018-12-19T05:30:04.841+00:00",

"PayingCustomerAccount": "1008",

"SoldToPartyNumber": "1008",

"RemitToAddress": "ZD, Park Avenue St",

"DefaultTaxationCountry": "US",

"EnteredAmount": 3066.08,

"InvoiceBalanceAmount": 3066.08,

"Prepayment": "No",

"Intercompany": "No",

"DocumentFiscalClassification": null,

"BankAccountNumber": null,

"CreditCardAuthorizationRequestIdentifier": null,

"CreditCardExpirationDate": null,

"CreditCardIssuerCode": null,

"CreditCardTokenNumber": null,

"CreditCardVoiceAuthorizationCode": null,

"CreditCardErrorCode": null,

"CreditCardErrorText": null,

"CardHolderLastName": null,

"CardHolderFirstName": null,

"ReceiptMethod": null,

"SalesPersonNumber": null,

"StructuredPaymentReference": null,

"links": [

{

"rel": "self",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996427",

"name": "receivablesInvoices",

"kind": "item",

"properties": {

}

{

"rel": "canonical",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996427",

"name": "receivablesInvoices",

"kind": "item"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996427/lov/transactionSources",

"name": "transactionSources",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996427/lov/businessUnits",

"name": "businessUnits",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996427/lov/PaymentTermsVA",

"name": "PaymentTermsVA",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996427/lov/thirdPartyTaxRegistrationNumbers",

"name": "thirdPartyTaxRegistrationNumbers",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996427/lov/invoiceStatuses",

"name": "invoiceStatuses",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996427/lov/shipToCustomers",

"name": "shipToCustomers",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996427/lov/billToCustomers",

"name": "billToCustomers",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996427/lov/legalEntities",

"name": "legalEntities",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996427/lov/invoicingRules",

"name": "invoicingRules",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996427/lov/billToSites",

"name": "billToSites",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996427/lov/taxationCountries",

"name": "taxationCountries",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996427/lov/firstPartyTaxRegistrationNumbers",

"name": "firstPartyTaxRegistrationNumbers",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996427/lov/transactionTypes",

"name": "transactionTypes",

"kind": "collection"

{

"rel": "child",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996427/child/receivablesInvoiceLines",

"name": "receivablesInvoiceLines",

"kind": "collection"

{

"rel": "child",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996427/child/receivablesInvoiceTransactionDFF",

"name": "receivablesInvoiceTransactionDFF",

"kind": "collection"

{

"rel": "child",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996427/child/receivablesInvoiceGdf",

"name": "receivablesInvoiceGdf",

"kind": "collection"

{

"rel": "child",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996427/child/receivablesInvoiceInstallments",

"name": "receivablesInvoiceInstallments",

"kind": "collection"

{

"rel": "child",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996427/child/receivablesInvoiceDFF",

"name": "receivablesInvoiceDFF",

"kind": "collection"

{

"rel": "child",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996427/child/attachments",

"name": "attachments",

"kind": "collection"

{

"rel": "child",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100170996427/child/notes",

"name": "notes",

"kind": "collection"

}

]

}

"count": 1,

"hasMore": false,

"limit": 25,

"offset": 0,

"links": [

{

"rel": "self",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices",

"name": "receivablesInvoices",

"kind": "collection"

}

]

}

3.3.4 Sample Payload to Create an Invoice with Automatic Receipt Method

Sample URL

https://<host>:<port>/fscmRestApi/resources/11.13.0.0/receivablesInvoices

Sample Request Payload that the Client Sends

{

"AccountingDate": "2018-12-19",

"BillToCustomerNumber": "1008",

"BusinessUnit": "Vision Operations",

"TransactionDate": "2018-12-19",

"TransactionNumber": "Aito02",

"FirstPartyRegistrationNumber" : "4567890",

"ThirdPartyRegistrationNumber" : null,

"PaymentTerms": "Immediate",

"ReceiptMethod": "ACH",

"TransactionSource": "AR_Trans Source_08",

"TransactionType": "Invoice_35",

"receivablesInvoiceLines": [

{

"Description": "Monitor",

"Quantity": 10,

"UnitSellingPrice": 15

}

]

}

Sample Response Payload that the Client Receives

{

"CustomerTransactionId": 300100170996493,

"DueDate": null,

"ConversionDate": null,

"ConversionRate": null,

"InvoiceCurrencyCode": "USD",

"SpecialInstructions": null,

"CrossReference": null,

"DocumentNumber": null,

"TransactionNumber": "Aito02",

"TransactionDate": "2018-12-19",

"TransactionType": "Invoice_35",

"TransactionSource": "AR_Trans Source_08",

"BillToCustomerNumber": "1008",

"BillToSite": "Foster City (OPS)",

"Comments": null,

"InternalNotes": null,

"PaymentTerms": "Immediate",

"LegalEntityIdentifier": "USSYS12030",

"ConversionRateType": null,

"PurchaseOrder": null,

"PurchaseOrderDate": null,

"PurchaseOrderRevision": null,

"FirstPartyRegistrationNumber": "4567890",

"ThirdPartyRegistrationNumber": null,

"InvoicingRule": null,

"ShipToCustomerName": "Total Internet",

"ShipToCustomerNumber": "1008",

"BillingDate": null,

"BusinessUnit": "Vision Operations",

"InvoiceStatus": null,

"AccountingDate": "2018-12-19",

"ShipToSite": null,

"PayingCustomerName": null,

"PayingCustomerSite": null,

"BillToCustomerName": null,

"FreightAmount": null,

"Carrier": null,

"ShipDate": null,

"ShippingReference": null,

"BillToContact": null,

"ShipToContact": null,

"PrintOption": null,

"CreatedBy": "AR_MGR_OPERATIONS",

"CreationDate": "2018-12-19T06:40:06.003+00:00",

"LastUpdatedBy": "AR_MGR_OPERATIONS",

"LastUpdateDate": "2018-12-19T06:40:06.420+00:00",

"PayingCustomerAccount": null,

"SoldToPartyNumber": null,

"RemitToAddress": null,

"DefaultTaxationCountry": null,

"EnteredAmount": null,

"InvoiceBalanceAmount": null,

"Prepayment": null,

"Intercompany": null,

"DocumentFiscalClassification": null,

"BankAccountNumber": null,

"CreditCardAuthorizationRequestIdentifier": null,

"CreditCardExpirationDate": null,

"CreditCardIssuerCode": null,

"CreditCardTokenNumber": null,

"CreditCardVoiceAuthorizationCode": null,

"CreditCardErrorCode": null,

"CreditCardErrorText": null,

"CardHolderLastName": null,

"CardHolderFirstName": null,

"ReceiptMethod": "ACH",

"SalesPersonNumber": null,

"StructuredPaymentReference": null,

"receivablesInvoiceLines": [

{

"CustomerTransactionLineId": 300100170996494,

"LineNumber": 1,

"Description": "Monitor",

"Quantity": 10,

"UnitSellingPrice": 15,

"TaxClassificationCode": null,

"SalesOrder": null,

"AccountingRuleDuration": null,

"RuleEndDate": null,

"RuleStartDate": null,

"AccountingRule": null,

"Warehouse": null,

"MemoLine": null,

"UnitOfMeasure": null,

"ItemNumber": null,

"AllocatedFreightAmount": null,

"AssessableValue": null,

"SalesOrderDate": null,

"LineAmount": null,

"CreatedBy": "AR_MGR_OPERATIONS",

"CreationDate": "2018-12-19T06:40:06.237+00:00",

"LastUpdatedBy": "AR_MGR_OPERATIONS",

"LastUpdateDate": "2018-12-19T06:40:06.427+00:00",

"TransacationBusinessCategory": null,

"UserDefinedFiscalClassification": null,

"ProductFiscalClassification": null,

"ProductCategory": null,

"ProductType": null,

"LineIntendedUse": null,

"LineAmountIncludesTax": null,

"TaxInvoiceDate": null,

"TaxInvoiceNumber": null,

"TaxExemptionCertificateNumber": null,

"TaxExemptionHandling": null,

"TaxExemptionReason": null,

"links": [

{

"rel": "self",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996493/child/receivablesInvoiceLines/300100170996494",

"name": "receivablesInvoiceLines",

"kind": "item",

"properties": {

}

{

"rel": "canonical",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996493/child/receivablesInvoiceLines/300100170996494",

"name": "receivablesInvoiceLines",

"kind": "item"

{

"rel": "parent",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996493",

"name": "receivablesInvoices",

"kind": "item"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996493/child/receivablesInvoiceLines/300100170996494/lov/memoLines",

"name": "memoLines",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996493/child/receivablesInvoiceLines/300100170996494/lov/warehouses",

"name": "warehouses",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996493/child/receivablesInvoiceLines/300100170996494/lov/itemNumbers",

"name": "itemNumbers",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996493/child/receivablesInvoiceLines/300100170996494/lov/productCategories",

"name": "productCategories",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996493/child/receivablesInvoiceLines/300100170996494/lov/userDefinedFiscClasses",

"name": "userDefinedFiscClasses",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996493/child/receivablesInvoiceLines/300100170996494/lov/exemptReasonCodes",

"name": "exemptReasonCodes",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996493/child/receivablesInvoiceLines/300100170996494/lov/taxExemptHandlingStatuses",

"name": "taxExemptHandlingStatuses",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996493/child/receivablesInvoiceLines/300100170996494/lov/transactionBizCategories",

"name": "transactionBizCategories",

"kind": "collection"

{

"rel": "lov",

"name": "productFiscClassifications",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996493/child/receivablesInvoiceLines/300100170996494/lov/accountingRules",

"name": "accountingRules",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996493/child/receivablesInvoiceLines/300100170996494/lov/unitOfMeasures",

"name": "unitOfMeasures",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996493/child/receivablesInvoiceLines/300100170996494/lov/productTypes",

"name": "productTypes",

"kind": "collection"

{

"rel": "child",

"name": "receivablesInvoiceLineGdf",

"kind": "collection"

{

"rel": "child",

"name": "receivablesInvoiceLineTaxLines",

"kind": "collection"

{

"rel": "child",

"name": "receivablesInvoiceLineDFF",

"kind": "collection"

{

"rel": "child",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996493/child/receivablesInvoiceLines/300100170996494/child/attachments",

"name": "attachments",

"kind": "collection"

{

"rel": "child",

"name": "receivablesInvoiceLineTransactionDFF",

"kind": "collection"

}

]

}

"links": [

{

"rel": "self",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996493",

"name": "receivablesInvoices",

"kind": "item",

"properties": {

}

{

"rel": "canonical",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996493",

"name": "receivablesInvoices",

"kind": "item"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996493/lov/transactionSources",

"name": "transactionSources",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996493/lov/businessUnits",

"name": "businessUnits",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996493/lov/PaymentTermsVA",

"name": "PaymentTermsVA",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996493/lov/thirdPartyTaxRegistrationNumbers",

"name": "thirdPartyTaxRegistrationNumbers",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996493/lov/invoiceStatuses",

"name": "invoiceStatuses",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996493/lov/shipToCustomers",

"name": "shipToCustomers",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996493/lov/billToCustomers",

"name": "billToCustomers",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996493/lov/legalEntities",

"name": "legalEntities",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996493/lov/invoicingRules",

"name": "invoicingRules",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996493/lov/billToSites",

"name": "billToSites",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996493/lov/taxationCountries",

"name": "taxationCountries",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996493/lov/firstPartyTaxRegistrationNumbers",

"name": "firstPartyTaxRegistrationNumbers",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996493/lov/transactionTypes",

"name": "transactionTypes",

"kind": "collection"

{

"rel": "child",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996493/child/receivablesInvoiceLines",

"name": "receivablesInvoiceLines",

"kind": "collection"

{

"rel": "child",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996493/child/receivablesInvoiceTransactionDFF",

"name": "receivablesInvoiceTransactionDFF",

"kind": "collection"

{

"rel": "child",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996493/child/receivablesInvoiceGdf",

"name": "receivablesInvoiceGdf",

"kind": "collection"

{

"rel": "child",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996493/child/receivablesInvoiceInstallments",

"name": "receivablesInvoiceInstallments",

"kind": "collection"

{

"rel": "child",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996493/child/receivablesInvoiceDFF",

"name": "receivablesInvoiceDFF",

"kind": "collection"

{

"rel": "child",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996493/child/attachments",

"name": "attachments",

"kind": "collection"

{

"rel": "child",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996493/child/notes",

"name": "notes",

"kind": "collection"

}

]

}

3.3.5 Sample Payload to Create an Invoice with an “In Advance” Invoicing Rule and Revenue Scheduling Rule

Sample URL

https://<host>:<port>/fscmRestApi/resources/11.13.0.0/receivablesInvoices

Sample Request Payload that the Client Sends

{

"AccountingDate": "2018-12-19",

"BillToCustomerNumber": "CDRM_3195",

"BusinessUnit": "Vision Operations",

"ShipToCustomerName": "Total Internet",

"ShipToCustomerNumber": "1008",

"TransactionDate": "2018-12-19",

"TransactionNumber": "Adv03",

"InvoicingRule" : "Advance Invoice",

"FirstPartyRegistrationNumber" : "4567890",

"ThirdPartyRegistrationNumber" : null,

"TransactionSource": "AR_Trans Source_08",

"TransactionType": "Invoice_35",

"receivablesInvoiceLines": [

{

"Description": "Computers",

"ItemNumber" : null,

"Warehouse" : null,

"SalesOrder" : null,

"AccountingRuleDuration" : 3,

"RuleEndDate" : null,

"RuleStartDate" : "2018-12-19",

"AccountingRule" : "3 Months Fixed",

"Quantity": 13,

"UnitSellingPrice": 4516.15,

"TaxClassificationCode": "VAT20"

{

"Description": "Printers",

"ItemNumber" : null,

"Warehouse" : null,

"SalesOrder" : null,

"AccountingRuleDuration" : 6,

"RuleEndDate" : null,

"RuleStartDate" : "2018-12-19",

"AccountingRule" : "6 Months Fixed",

"Quantity": 1253,

"UnitSellingPrice": 114,

"TaxClassificationCode": "VAT20"

}

]

}

Sample Response Payload that the Client Receives

{

"CustomerTransactionId": 300100170996497,

"DueDate": null,

"ConversionDate": null,

"ConversionRate": null,

"InvoiceCurrencyCode": "USD",

"SpecialInstructions": null,

"CrossReference": null,

"DocumentNumber": null,

"TransactionNumber": "Adv03",

"TransactionDate": "2018-12-19",

"TransactionType": "Invoice_35",

"TransactionSource": "AR_Trans Source_08",

"BillToCustomerNumber": "CDRM_3195",

"BillToSite": "CDRM_1270",

"Comments": null,

"InternalNotes": null,

"PaymentTerms": "30 Net",

"LegalEntityIdentifier": "USSYS12030",

"ConversionRateType": null,

"PurchaseOrder": null,

"PurchaseOrderDate": null,

"PurchaseOrderRevision": null,

"FirstPartyRegistrationNumber": "4567890",

"ThirdPartyRegistrationNumber": null,

"InvoicingRule": "Advance Invoice",

"ShipToCustomerName": "Total Internet",

"ShipToCustomerNumber": "1008",

"BillingDate": null,

"BusinessUnit": "Vision Operations",

"InvoiceStatus": null,

"AccountingDate": "2018-12-19",

"ShipToSite": null,

"PayingCustomerName": null,

"PayingCustomerSite": null,

"BillToCustomerName": null,

"FreightAmount": null,

"Carrier": null,

"ShipDate": null,

"ShippingReference": null,

"BillToContact": null,

"ShipToContact": null,

"PrintOption": null,

"CreatedBy": "AR_MGR_OPERATIONS",

"CreationDate": "2018-12-19T06:42:32.002+00:00",

"LastUpdatedBy": "AR_MGR_OPERATIONS",

"LastUpdateDate": "2018-12-19T06:42:32.425+00:00",

"PayingCustomerAccount": null,

"SoldToPartyNumber": null,

"RemitToAddress": null,

"DefaultTaxationCountry": null,

"EnteredAmount": null,

"InvoiceBalanceAmount": null,

"Prepayment": null,

"Intercompany": null,

"DocumentFiscalClassification": null,

"BankAccountNumber": null,

"CreditCardAuthorizationRequestIdentifier": null,

"CreditCardExpirationDate": null,

"CreditCardIssuerCode": null,

"CreditCardTokenNumber": null,

"CreditCardVoiceAuthorizationCode": null,

"CreditCardErrorCode": null,

"CreditCardErrorText": null,

"CardHolderLastName": null,

"CardHolderFirstName": null,

"ReceiptMethod": null,

"SalesPersonNumber": null,

"StructuredPaymentReference": null,

"receivablesInvoiceLines": [

{

"CustomerTransactionLineId": 300100170996498,

"LineNumber": 1,

"Description": "Computers",

"Quantity": 13,

"UnitSellingPrice": 4516.15,

"TaxClassificationCode": "VAT20",

"SalesOrder": null,

"AccountingRuleDuration": 3,

"RuleEndDate": null,

"RuleStartDate": "2018-12-19",

"AccountingRule": "3 Months Fixed",

"Warehouse": null,

"MemoLine": null,

"UnitOfMeasure": null,

"ItemNumber": null,

"AllocatedFreightAmount": null,

"AssessableValue": null,

"SalesOrderDate": null,

"LineAmount": 58709.95,

"CreatedBy": "AR_MGR_OPERATIONS",

"CreationDate": "2018-12-19T06:42:32.237+00:00",

"LastUpdatedBy": "AR_MGR_OPERATIONS",

"LastUpdateDate": "2018-12-19T06:42:32.432+00:00",

"TransacationBusinessCategory": null,

"UserDefinedFiscalClassification": null,

"ProductFiscalClassification": null,

"ProductCategory": null,

"ProductType": null,

"LineIntendedUse": null,

"LineAmountIncludesTax": null,

"TaxInvoiceDate": null,

"TaxInvoiceNumber": null,

"TaxExemptionCertificateNumber": null,

"TaxExemptionHandling": null,

"TaxExemptionReason": null,

"links": [

{

"rel": "self",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996497/child/receivablesInvoiceLines/300100170996498",

"name": "receivablesInvoiceLines",

"kind": "item",

"properties": {

}

{

"rel": "canonical",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996497/child/receivablesInvoiceLines/300100170996498",

"name": "receivablesInvoiceLines",

"kind": "item"

{

"rel": "parent",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996497",

"name": "receivablesInvoices",

"kind": "item"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996497/child/receivablesInvoiceLines/300100170996498/lov/memoLines",

"name": "memoLines",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996497/child/receivablesInvoiceLines/300100170996498/lov/warehouses",

"name": "warehouses",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996497/child/receivablesInvoiceLines/300100170996498/lov/itemNumbers",

"name": "itemNumbers",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996497/child/receivablesInvoiceLines/300100170996498/lov/productCategories",

"name": "productCategories",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996497/child/receivablesInvoiceLines/300100170996498/lov/userDefinedFiscClasses",

"name": "userDefinedFiscClasses",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996497/child/receivablesInvoiceLines/300100170996498/lov/exemptReasonCodes",

"name": "exemptReasonCodes",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996497/child/receivablesInvoiceLines/300100170996498/lov/taxExemptHandlingStatuses",

"name": "taxExemptHandlingStatuses",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996497/child/receivablesInvoiceLines/300100170996498/lov/transactionBizCategories",

"name": "transactionBizCategories",

"kind": "collection"

{

"rel": "lov",

"name": "productFiscClassifications",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996497/child/receivablesInvoiceLines/300100170996498/lov/accountingRules",

"name": "accountingRules",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996497/child/receivablesInvoiceLines/300100170996498/lov/unitOfMeasures",

"name": "unitOfMeasures",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996497/child/receivablesInvoiceLines/300100170996498/lov/productTypes",

"name": "productTypes",

"kind": "collection"

{

"rel": "child",

"name": "receivablesInvoiceLineGdf",

"kind": "collection"

{

"rel": "child",

"name": "receivablesInvoiceLineTaxLines",

"kind": "collection"

{

"rel": "child",

"name": "receivablesInvoiceLineDFF",

"kind": "collection"

{

"rel": "child",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996497/child/receivablesInvoiceLines/300100170996498/child/attachments",

"name": "attachments",

"kind": "collection"

{

"rel": "child",

"name": "receivablesInvoiceLineTransactionDFF",

"kind": "collection"

}

]

{

"CustomerTransactionLineId": 300100170996499,

"LineNumber": 2,

"Description": "Printers",

"Quantity": 1253,

"UnitSellingPrice": 114,

"TaxClassificationCode": "VAT20",

"SalesOrder": null,

"AccountingRuleDuration": 6,

"RuleEndDate": null,

"RuleStartDate": "2018-12-19",

"AccountingRule": "6 Months Fixed",

"Warehouse": null,

"MemoLine": null,

"UnitOfMeasure": null,

"ItemNumber": null,

"AllocatedFreightAmount": null,

"AssessableValue": null,

"SalesOrderDate": null,

"LineAmount": null,

"CreatedBy": "AR_MGR_OPERATIONS",

"CreationDate": "2018-12-19T06:42:32.332+00:00",

"LastUpdatedBy": "AR_MGR_OPERATIONS",

"LastUpdateDate": "2018-12-19T06:42:32.434+00:00",

"TransacationBusinessCategory": null,

"UserDefinedFiscalClassification": null,

"ProductFiscalClassification": null,

"ProductCategory": null,

"ProductType": null,

"LineIntendedUse": null,

"LineAmountIncludesTax": null,

"TaxInvoiceDate": null,

"TaxInvoiceNumber": null,

"TaxExemptionCertificateNumber": null,

"TaxExemptionHandling": null,

"TaxExemptionReason": null,

"links": [

{

"rel": "self",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996497/child/receivablesInvoiceLines/300100170996499",

"name": "receivablesInvoiceLines",

"kind": "item",

"properties": {

}

{

"rel": "canonical",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996497/child/receivablesInvoiceLines/300100170996499",

"name": "receivablesInvoiceLines",

"kind": "item"

{

"rel": "parent",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996497",

"name": "receivablesInvoices",

"kind": "item"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996497/child/receivablesInvoiceLines/300100170996499/lov/memoLines",

"name": "memoLines",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996497/child/receivablesInvoiceLines/300100170996499/lov/warehouses",

"name": "warehouses",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996497/child/receivablesInvoiceLines/300100170996499/lov/itemNumbers",

"name": "itemNumbers",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996497/child/receivablesInvoiceLines/300100170996499/lov/productCategories",

"name": "productCategories",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996497/child/receivablesInvoiceLines/300100170996499/lov/userDefinedFiscClasses",

"name": "userDefinedFiscClasses",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996497/child/receivablesInvoiceLines/300100170996499/lov/exemptReasonCodes",

"name": "exemptReasonCodes",

"kind": "collection"

{

"rel": "lov",

"name": "taxExemptHandlingStatuses",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996497/child/receivablesInvoiceLines/300100170996499/lov/transactionBizCategories",

"name": "transactionBizCategories",

"kind": "collection"

{

"rel": "lov",

"name": "productFiscClassifications",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996497/child/receivablesInvoiceLines/300100170996499/lov/accountingRules",

"name": "accountingRules",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996497/child/receivablesInvoiceLines/300100170996499/lov/unitOfMeasures",

"name": "unitOfMeasures",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996497/child/receivablesInvoiceLines/300100170996499/lov/productTypes",

"name": "productTypes",

"kind": "collection"

{

"rel": "child",

"name": "receivablesInvoiceLineGdf",

"kind": "collection"

{

"rel": "child",

"name": "receivablesInvoiceLineTaxLines",

"kind": "collection"

{

"rel": "child",

"name": "receivablesInvoiceLineDFF",

"kind": "collection"

{

"rel": "child",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996497/child/receivablesInvoiceLines/300100170996499/child/attachments",

"name": "attachments",

"kind": "collection"

{

"rel": "child",

"name": "receivablesInvoiceLineTransactionDFF",

"kind": "collection"

}

]

}

"links": [

{

"rel": "self",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996497",

"name": "receivablesInvoices",

"kind": "item",

"properties": {

}

{

"rel": "canonical",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996497",

"name": "receivablesInvoices",

"kind": "item"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996497/lov/transactionSources",

"name": "transactionSources",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996497/lov/businessUnits",

"name": "businessUnits",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996497/lov/PaymentTermsVA",

"name": "PaymentTermsVA",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996497/lov/thirdPartyTaxRegistrationNumbers",

"name": "thirdPartyTaxRegistrationNumbers",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996497/lov/invoiceStatuses",

"name": "invoiceStatuses",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996497/lov/shipToCustomers",

"name": "shipToCustomers",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996497/lov/billToCustomers",

"name": "billToCustomers",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996497/lov/legalEntities",

"name": "legalEntities",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996497/lov/invoicingRules",

"name": "invoicingRules",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996497/lov/billToSites",

"name": "billToSites",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996497/lov/taxationCountries",

"name": "taxationCountries",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996497/lov/firstPartyTaxRegistrationNumbers",

"name": "firstPartyTaxRegistrationNumbers",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996497/lov/transactionTypes",

"name": "transactionTypes",

"kind": "collection"

{

"rel": "child",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996497/child/receivablesInvoiceLines",

"name": "receivablesInvoiceLines",

"kind": "collection"

{

"rel": "child",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996497/child/receivablesInvoiceTransactionDFF",

"name": "receivablesInvoiceTransactionDFF",

"kind": "collection"

{

"rel": "child",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996497/child/receivablesInvoiceGdf",

"name": "receivablesInvoiceGdf",

"kind": "collection"

{

"rel": "child",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996497/child/receivablesInvoiceInstallments",

"name": "receivablesInvoiceInstallments",

"kind": "collection"

{

"rel": "child",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996497/child/receivablesInvoiceDFF",

"name": "receivablesInvoiceDFF",

"kind": "collection"

{

"rel": "child",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996497/child/attachments",

"name": "attachments",

"kind": "collection"

{

"rel": "child",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996497/child/notes",

"name": "notes",

"kind": "collection"

}

]

}

3.3.6 Sample Payload to Create an Invoice with Split Payment Method and Attachment

Sample URL

https://<host>:<port>/fscmRestApi/resources/11.13.0.0/receivablesInvoices

Sample Request Payload that the Client Sends

{

"AccountingDate": "2017-11-14",

"BillingDate": "2017-11-14",

"BillToCustomerNumber": "1008",

"BillToSite": "Foster City (OPS)",

"BillToContact": "Maggie Munro",

"BusinessUnit": "Vision Operations",

"Comments": "Test comments",

"ConversionDate": "2017-12-15",

"ConversionRate": 0.75,

"ConversionRateType": "User",

"CrossReference": "Test cross reference",

"DueDate": "2017-12-15",

"InternalNotes": "Test internal notes",

"InvoiceCurrencyCode": "EUR",

"InvoicingRule": "Advance Invoice",

"LegalEntityIdentifier": "USSYS12030",

"PaymentTerms": "30/60/90",

"PurchaseOrder": "Test purchase order",

"PurchaseOrderDate": "2017-11-14",

"PurchaseOrderRevision": "Test purchase order revision",

"ShipToCustomerName": "Total Internet",

"ShipToCustomerNumber": "1008",

"ShipToSite": "1042",

"ShipToContact": "Maggie Munro",

"SpecialInstructions": "Test special instructions",

"TransactionDate": "2017-11-14",

"TransactionNumber": "Apr25-1",

"TransactionSource": "AR_Trans Source_08",

"TransactionType": "Invoice_35",

"PrintOption": "No",

"Carrier": "Carrier Value",

"ShipDate": "2017-11-14",

"ShippingReference": "Shipping Reference Value",

"receivablesInvoiceLines": [

{

"AccountingRule": "AR_RevRules_Var_02-NES",

"AccountingRuleDuration": 3,

"Description" : "Database Server",

"LineNumber": 1,

"RuleStartDate": "2017-11-14",

"TaxClassificationCode": "VAT20",

"Quantity": 1,

"UnitOfMeasure": "EA",

"UnitSellingPrice": 2256578,

"Warehouse": "Vision Operations",

"SalesOrder": "900",

"SalesOrderDate": "2017-11-14",

"AllocatedFreightAmount": 200,

}

]

}

Sample Response Payload that the Client Receives

{

"CustomerTransactionId": 300100170996512,

"DueDate": "2017-12-15",

"ConversionDate": "2017-12-15",

"ConversionRate": 0.75,

"InvoiceCurrencyCode": "EUR",

"SpecialInstructions": "Test special instructions",

"CrossReference": "Test cross reference",

"DocumentNumber": null,

"TransactionNumber": "Apr25-1",

"TransactionDate": "2017-11-14",

"TransactionType": "Invoice_35",

"TransactionSource": "AR_Trans Source_08",

"BillToCustomerNumber": "1008",

"BillToSite": "Foster City (OPS)",

"Comments": "Test comments",

"InternalNotes": "Test internal notes",

"PaymentTerms": "30/60/90",

"LegalEntityIdentifier": "USSYS12030",

"ConversionRateType": "User",

"PurchaseOrder": "Test purchase order",

"PurchaseOrderDate": "2017-11-14",

"PurchaseOrderRevision": "Test purchase order revision",

"FirstPartyRegistrationNumber": "4567890",

"ThirdPartyRegistrationNumber": null,

"InvoicingRule": "Advance Invoice",

"ShipToCustomerName": "Total Internet",

"ShipToCustomerNumber": "1008",

"BillingDate": "2017-11-14",

"BusinessUnit": "Vision Operations",

"InvoiceStatus": null,

"AccountingDate": "2017-11-14",

"ShipToSite": "1042",

"PayingCustomerName": null,

"PayingCustomerSite": null,

"BillToCustomerName": null,

"FreightAmount": null,

"Carrier": "Carrier Value",

"ShipDate": "2017-11-14",

"ShippingReference": "Shipping Reference Value",

"BillToContact": "Maggie Munro",

"ShipToContact": "Maggie Munro",

"PrintOption": "No",

"CreatedBy": "AR_MGR_OPERATIONS",

"CreationDate": "2018-12-19T06:46:56.003+00:00",

"LastUpdatedBy": "AR_MGR_OPERATIONS",

"LastUpdateDate": "2018-12-19T06:46:56.369+00:00",

"PayingCustomerAccount": null,

"SoldToPartyNumber": null,

"RemitToAddress": null,

"DefaultTaxationCountry": null,

"EnteredAmount": null,

"InvoiceBalanceAmount": null,

"Prepayment": null,

"Intercompany": null,

"DocumentFiscalClassification": null,

"BankAccountNumber": null,

"CreditCardAuthorizationRequestIdentifier": null,

"CreditCardExpirationDate": null,

"CreditCardIssuerCode": null,

"CreditCardTokenNumber": null,

"CreditCardVoiceAuthorizationCode": null,

"CreditCardErrorCode": null,

"CreditCardErrorText": null,

"CardHolderLastName": null,

"CardHolderFirstName": null,

"ReceiptMethod": null,

"SalesPersonNumber": null,

"StructuredPaymentReference": null,

"receivablesInvoiceLines": [

{

"CustomerTransactionLineId": 300100170996513,

"LineNumber": 1,

"Description": "Database Server",

"Quantity": 1,

"UnitSellingPrice": 2256578,

"TaxClassificationCode": "VAT20",

"SalesOrder": "900",

"AccountingRuleDuration": 3,

"RuleEndDate": null,

"RuleStartDate": "2017-11-14",

"AccountingRule": "AR_RevRules_Var_02-NES",

"Warehouse": null,

"MemoLine": null,

"UnitOfMeasure": "EA",

"ItemNumber": null,

"AllocatedFreightAmount": 200,

"AssessableValue": null,

"SalesOrderDate": "2017-11-14",

"LineAmount": 2256578,

"CreatedBy": "AR_MGR_OPERATIONS",

"CreationDate": "2018-12-19T06:46:56.254+00:00",

"LastUpdatedBy": "AR_MGR_OPERATIONS",

"LastUpdateDate": "2018-12-19T06:46:56.377+00:00",

"TransacationBusinessCategory": null,

"UserDefinedFiscalClassification": null,

"ProductFiscalClassification": null,

"ProductCategory": null,

"ProductType": null,

"LineIntendedUse": null,

"LineAmountIncludesTax": null,

"TaxInvoiceDate": null,

"TaxInvoiceNumber": null,

"TaxExemptionCertificateNumber": null,

"TaxExemptionHandling": null,

"TaxExemptionReason": null,

"links": [

{

"rel": "self",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996512/child/receivablesInvoiceLines/300100170996513",

"name": "receivablesInvoiceLines",

"kind": "item",

"properties": {

}

{

"rel": "canonical",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996512/child/receivablesInvoiceLines/300100170996513",

"name": "receivablesInvoiceLines",

"kind": "item"

{

"rel": "parent",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996512",

"name": "receivablesInvoices",

"kind": "item"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996512/child/receivablesInvoiceLines/300100170996513/lov/memoLines",

"name": "memoLines",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996512/child/receivablesInvoiceLines/300100170996513/lov/warehouses",

"name": "warehouses",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996512/child/receivablesInvoiceLines/300100170996513/lov/itemNumbers",

"name": "itemNumbers",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996512/child/receivablesInvoiceLines/300100170996513/lov/productCategories",

"name": "productCategories",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996512/child/receivablesInvoiceLines/300100170996513/lov/userDefinedFiscClasses",

"name": "userDefinedFiscClasses",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996512/child/receivablesInvoiceLines/300100170996513/lov/exemptReasonCodes",

"name": "exemptReasonCodes",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996512/child/receivablesInvoiceLines/300100170996513/lov/taxExemptHandlingStatuses",

"name": "taxExemptHandlingStatuses",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996512/child/receivablesInvoiceLines/300100170996513/lov/transactionBizCategories",

"name": "transactionBizCategories",

"kind": "collection"

{

"rel": "lov",

"name": "productFiscClassifications",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996512/child/receivablesInvoiceLines/300100170996513/lov/accountingRules",

"name": "accountingRules",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996512/child/receivablesInvoiceLines/300100170996513/lov/unitOfMeasures",

"name": "unitOfMeasures",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996512/child/receivablesInvoiceLines/300100170996513/lov/productTypes",

"name": "productTypes",

"kind": "collection"

{

"rel": "child",

"name": "receivablesInvoiceLineGdf",

"kind": "collection"

{

"rel": "child",

"name": "receivablesInvoiceLineTaxLines",

"kind": "collection"

{

"rel": "child",

"name": "receivablesInvoiceLineDFF",

"kind": "collection"

{

"rel": "child",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996512/child/receivablesInvoiceLines/300100170996513/child/attachments",

"name": "attachments",

"kind": "collection"

{

"rel": "child",

"name": "receivablesInvoiceLineTransactionDFF",

"kind": "collection"

}

]

}

"links": [

{

"rel": "self",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996512",

"name": "receivablesInvoices",

"kind": "item",

"properties": {

}

{

"rel": "canonical",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996512",

"name": "receivablesInvoices",

"kind": "item"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996512/lov/transactionSources",

"name": "transactionSources",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996512/lov/businessUnits",

"name": "businessUnits",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996512/lov/PaymentTermsVA",

"name": "PaymentTermsVA",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996512/lov/thirdPartyTaxRegistrationNumbers",

"name": "thirdPartyTaxRegistrationNumbers",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996512/lov/invoiceStatuses",

"name": "invoiceStatuses",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996512/lov/shipToCustomers",

"name": "shipToCustomers",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996512/lov/billToCustomers",

"name": "billToCustomers",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996512/lov/legalEntities",

"name": "legalEntities",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996512/lov/invoicingRules",

"name": "invoicingRules",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996512/lov/billToSites",

"name": "billToSites",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996512/lov/taxationCountries",

"name": "taxationCountries",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996512/lov/firstPartyTaxRegistrationNumbers",

"name": "firstPartyTaxRegistrationNumbers",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996512/lov/transactionTypes",

"name": "transactionTypes",

"kind": "collection"

{

"rel": "child",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996512/child/receivablesInvoiceLines",

"name": "receivablesInvoiceLines",

"kind": "collection"

{

"rel": "child",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996512/child/receivablesInvoiceTransactionDFF",

"name": "receivablesInvoiceTransactionDFF",

"kind": "collection"

{

"rel": "child",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996512/child/receivablesInvoiceGdf",

"name": "receivablesInvoiceGdf",

"kind": "collection"

{

"rel": "child",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996512/child/receivablesInvoiceInstallments",

"name": "receivablesInvoiceInstallments",

"kind": "collection"

{

"rel": "child",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996512/child/receivablesInvoiceDFF",

"name": "receivablesInvoiceDFF",

"kind": "collection"

{

"rel": "child",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996512/child/attachments",

"name": "attachments",

"kind": "collection"

{

"rel": "child",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996512/child/notes",

"name": "notes",

"kind": "collection"

}

]

}

3.3.7 Sample Payload to Create an Invoice with Foreign Currency and Descriptive Flexfield

Sample URL

https://<host>:<port>/fscmRestApi/resources/11.13.0.0/receivablesInvoices

Sample Request Payload that the Client Sends

{

"BillToCustomerNumber": "1003",

"BusinessUnit": "Vision Operations",

"InvoiceCurrencyCode": "EUR",

"ConversionDate": "2017-12-15",

"ConversionRate": 0.75,

"ConversionRateType": "User",

"TransactionNumber": "Dec 8(4)",

"TransactionSource": "AR_Trans Source_08",

"TransactionType": "Invoice_35",

"receivablesInvoiceLines": [

{

"Description" : "Laptop-Highspeed",

"Quantity": 10,

"UnitSellingPrice": 100,

"receivablesInvoiceLineDFF": [

{

"__FLEX_Context": "Invoice Lines",

"_Data__on__the__Project": "Test Data",

"_PCN": "Test PCN",

"_Name": "Test Name",

"_resource__type": "Test Type",

"_Line5": "Test Line"

}

]

}

"receivablesInvoiceDFF": [

{

"__FLEX_Context": "Transactions",

"_Transactions1": "Transaction 1",

"_Transactions2": "Transaction 2",

"_Transactions3": "Transaction 3"

}

]

}

Sample Response Payload that the Client Receives

{

"CustomerTransactionId": 300100170996529,

"DueDate": null,

"ConversionDate": "2017-12-15",

"ConversionRate": 0.75,

"InvoiceCurrencyCode": "EUR",

"SpecialInstructions": null,

"CrossReference": null,

"DocumentNumber": null,

"TransactionNumber": "Dec 8(4)",

"TransactionDate": "2018-12-19",

"TransactionType": "Invoice_35",

"TransactionSource": "AR_Trans Source_08",

"BillToCustomerNumber": "1003",

"BillToSite": "Atlanta (OPS)",

"Comments": null,

"InternalNotes": null,

"PaymentTerms": "30 Net",

"LegalEntityIdentifier": "USSYS12030",

"ConversionRateType": "User",

"PurchaseOrder": null,

"PurchaseOrderDate": null,

"PurchaseOrderRevision": null,

"FirstPartyRegistrationNumber": "4567890",

"ThirdPartyRegistrationNumber": "EST22335566",

"InvoicingRule": null,

"ShipToCustomerName": "UNITED PARCEL SERVICE, INC",

"ShipToCustomerNumber": "1003",

"BillingDate": null,

"BusinessUnit": "Vision Operations",

"InvoiceStatus": null,

"AccountingDate": null,

"ShipToSite": null,

"PayingCustomerName": null,

"PayingCustomerSite": null,

"BillToCustomerName": null,

"FreightAmount": null,

"Carrier": null,

"ShipDate": null,

"ShippingReference": null,

"BillToContact": null,

"ShipToContact": null,

"PrintOption": null,

"CreatedBy": "AR_MGR_OPERATIONS",

"CreationDate": "2018-12-19T06:50:15.004+00:00",

"LastUpdatedBy": "AR_MGR_OPERATIONS",

"LastUpdateDate": "2018-12-19T06:50:15.572+00:00",

"PayingCustomerAccount": null,

"SoldToPartyNumber": null,

"RemitToAddress": null,

"DefaultTaxationCountry": null,

"EnteredAmount": null,

"InvoiceBalanceAmount": null,

"Prepayment": null,

"Intercompany": null,

"DocumentFiscalClassification": null,

"BankAccountNumber": null,

"CreditCardAuthorizationRequestIdentifier": null,

"CreditCardExpirationDate": null,

"CreditCardIssuerCode": null,

"CreditCardTokenNumber": null,

"CreditCardVoiceAuthorizationCode": null,

"CreditCardErrorCode": null,

"CreditCardErrorText": null,

"CardHolderLastName": null,

"CardHolderFirstName": null,

"ReceiptMethod": null,

"SalesPersonNumber": null,

"StructuredPaymentReference": null,

"receivablesInvoiceLines": [

{

"CustomerTransactionLineId": 300100170996530,

"LineNumber": 1,

"Description": "Laptop-Highspeed",

"Quantity": 10,

"UnitSellingPrice": 100,

"TaxClassificationCode": null,

"SalesOrder": null,

"AccountingRuleDuration": null,

"RuleEndDate": null,

"RuleStartDate": null,

"AccountingRule": null,

"Warehouse": null,

"MemoLine": null,

"UnitOfMeasure": null,

"ItemNumber": null,

"AllocatedFreightAmount": null,

"AssessableValue": null,

"SalesOrderDate": null,

"LineAmount": null,

"CreatedBy": "AR_MGR_OPERATIONS",

"CreationDate": "2018-12-19T06:50:15.255+00:00",

"LastUpdatedBy": "AR_MGR_OPERATIONS",

"LastUpdateDate": "2018-12-19T06:50:15.578+00:00",

"TransacationBusinessCategory": null,

"UserDefinedFiscalClassification": null,

"ProductFiscalClassification": null,

"ProductCategory": null,

"ProductType": null,

"LineIntendedUse": null,

"LineAmountIncludesTax": null,

"TaxInvoiceDate": null,

"TaxInvoiceNumber": null,

"TaxExemptionCertificateNumber": null,

"TaxExemptionHandling": null,

"TaxExemptionReason": null,

"receivablesInvoiceLineDFF": [

{

"CustomerTrxLineId": 300100170996530,

"__FLEX_Context": "Invoice Lines",

"__FLEX_Context_DisplayValue": "Invoice Lines",

"_Data__on__the__Project": "Test Data",

"_PCN": "Test PCN",

"_Name": "Test Name",

"_resource__type": "Test Type",

"_Line5": "Test Line",

"links": [

{

"rel": "self",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996529/child/receivablesInvoiceLines/300100170996530/child/receivablesInvoiceLineDFF/300100170996530",

"name": "receivablesInvoiceLineDFF",

"kind": "item",

"properties": {

}

{

"rel": "canonical",

"name": "receivablesInvoiceLineDFF",

"kind": "item"

{

"rel": "parent",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996529/child/receivablesInvoiceLines/300100170996530",

"name": "receivablesInvoiceLines",

"kind": "item"

{

"rel": "lov",

"name": "LVVO___FLEX_Context",

"kind": "collection"

}

]

}

"links": [

{

"rel": "self",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996529/child/receivablesInvoiceLines/300100170996530",

"name": "receivablesInvoiceLines",

"kind": "item",

"properties": {

}

{

"rel": "canonical",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996529/child/receivablesInvoiceLines/300100170996530",

"name": "receivablesInvoiceLines",

"kind": "item"

{

"rel": "parent",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996529",

"name": "receivablesInvoices",

"kind": "item"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996529/child/receivablesInvoiceLines/300100170996530/lov/memoLines",

"name": "memoLines",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996529/child/receivablesInvoiceLines/300100170996530/lov/warehouses",

"name": "warehouses",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996529/child/receivablesInvoiceLines/300100170996530/lov/itemNumbers",

"name": "itemNumbers",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996529/child/receivablesInvoiceLines/300100170996530/lov/productCategories",

"name": "productCategories",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996529/child/receivablesInvoiceLines/300100170996530/lov/userDefinedFiscClasses",

"name": "userDefinedFiscClasses",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996529/child/receivablesInvoiceLines/300100170996530/lov/exemptReasonCodes",

"name": "exemptReasonCodes",

"kind": "collection"

{

"rel": "lov",

"name": "taxExemptHandlingStatuses",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996529/child/receivablesInvoiceLines/300100170996530/lov/transactionBizCategories",

"name": "transactionBizCategories",

"kind": "collection"

{

"rel": "lov",

"name": "productFiscClassifications",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996529/child/receivablesInvoiceLines/300100170996530/lov/accountingRules",

"name": "accountingRules",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996529/child/receivablesInvoiceLines/300100170996530/lov/unitOfMeasures",

"name": "unitOfMeasures",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996529/child/receivablesInvoiceLines/300100170996530/lov/productTypes",

"name": "productTypes",

"kind": "collection"

{

"rel": "child",

"name": "receivablesInvoiceLineGdf",

"kind": "collection"

{

"rel": "child",

"name": "receivablesInvoiceLineTaxLines",

"kind": "collection"

{

"rel": "child",

"name": "receivablesInvoiceLineDFF",

"kind": "collection"

{

"rel": "child",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996529/child/receivablesInvoiceLines/300100170996530/child/attachments",

"name": "attachments",

"kind": "collection"

{

"rel": "child",

"name": "receivablesInvoiceLineTransactionDFF",

"kind": "collection"

}

]

}

"receivablesInvoiceDFF": [

{

"CustomerTrxId": 300100170996529,

"__FLEX_Context": "Transactions",

"__FLEX_Context_DisplayValue": "Transactions",

"_Transactions1": "Transaction 1",

"_Transactions2": "Transaction 2",

"_Transactions3": "Transaction 3",

"links": [

{

"rel": "self",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996529/child/receivablesInvoiceDFF/300100170996529",

"name": "receivablesInvoiceDFF",

"kind": "item",

"properties": {

}

{

"rel": "canonical",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996529/child/receivablesInvoiceDFF/300100170996529",

"name": "receivablesInvoiceDFF",

"kind": "item"

{

"rel": "parent",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996529",

"name": "receivablesInvoices",

"kind": "item"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996529/child/receivablesInvoiceDFF/300100170996529/lov/LVVO___FLEX_Context",

"name": "LVVO___FLEX_Context",

"kind": "collection"

}

]

}

"links": [

{

"rel": "self",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996529",

"name": "receivablesInvoices",

"kind": "item",

"properties": {

}

{

"rel": "canonical",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996529",

"name": "receivablesInvoices",

"kind": "item"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996529/lov/transactionSources",

"name": "transactionSources",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996529/lov/businessUnits",

"name": "businessUnits",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996529/lov/PaymentTermsVA",

"name": "PaymentTermsVA",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996529/lov/thirdPartyTaxRegistrationNumbers",

"name": "thirdPartyTaxRegistrationNumbers",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996529/lov/invoiceStatuses",

"name": "invoiceStatuses",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996529/lov/shipToCustomers",

"name": "shipToCustomers",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996529/lov/billToCustomers",

"name": "billToCustomers",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996529/lov/legalEntities",

"name": "legalEntities",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996529/lov/invoicingRules",

"name": "invoicingRules",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996529/lov/billToSites",

"name": "billToSites",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996529/lov/taxationCountries",

"name": "taxationCountries",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996529/lov/firstPartyTaxRegistrationNumbers",

"name": "firstPartyTaxRegistrationNumbers",

"kind": "collection"

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996529/lov/transactionTypes",

"name": "transactionTypes",

"kind": "collection"

{

"rel": "child",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996529/child/receivablesInvoiceLines",

"name": "receivablesInvoiceLines",

"kind": "collection"

{

"rel": "child",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996529/child/receivablesInvoiceTransactionDFF",

"name": "receivablesInvoiceTransactionDFF",

"kind": "collection"

{

"rel": "child",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996529/child/receivablesInvoiceGdf",

"name": "receivablesInvoiceGdf",

"kind": "collection"

{

"rel": "child",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996529/child/receivablesInvoiceInstallments",

"name": "receivablesInvoiceInstallments",

"kind": "collection"

{

"rel": "child",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996529/child/receivablesInvoiceDFF",

"name": "receivablesInvoiceDFF",

"kind": "collection"

{

"rel": "child",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996529/child/attachments",

"name": "attachments",

"kind": "collection"

{

"rel": "child",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/300100170996529/child/notes",

"name": "notes",

"kind": "collection"

}

]

}

3.3.8 Sample Payload to Delete an Invoice

Sample URL

https://<host>:<port>/fscmRestApi/resources/11.13.0.0/receivablesInvoices/<CustomerTransactionId>

Sample Request Payload that the Client Sends to delete an invoice

In the URL itself you need to pass the customerTranasctionId

https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.0.0/receivablesInvoices/30010017099648

Sample Response Payload that the Client Receives for delete an invoice

“No Content”

3.3.9 Sample Payload to Complete an Invoice

cURL Command:

curl --user <username>:<password> -X PATCH -H "Content-Type: application/vnd.oracle.adf.resourceitem+json" --data @complete_invoice_payload.json https://<host>:<port>/fscmRestApi/resources/<version>/receivablesInvoices/<CustomerTransactionId>

Sample URL

https://<host>:<port>/fscmRestApi/resources/11.13.0.0/receivablesInvoices/<CustomerTransactionId>

Sample Request Payload that the Client Sends to complete an invoice

In the URL itself you need to pass the customerTranasctionId

{

"InvoiceStatus":"Complete"

}

Sample Response Payload that the Client Receives to complete an invoice

{

"items": [

{

"CustomerTransactionId": 300100169169047,

"DueDate": "2018-02-20",

"ConversionDate": null,

"ConversionRate": null,

"InvoiceCurrencyCode": "USD",

"SpecialInstructions": null,

"CrossReference": null,

"DocumentNumber": null,

"TransactionNumber": "864",

"TransactionDate": "2018-02-20",

"TransactionType": "Invoice",

"TransactionSource": "Manual-NES",

"BillToCustomerNumber": "1008",

"BillToSite": "Foster City (OPS)",

"Comments": "New Laptop Promotion",

"InternalNotes": "Best Priced item",

"PaymentTerms": "30 Net",

"LegalEntityIdentifier": "USSYS12030",

"ConversionRateType": null,

"PurchaseOrder": null,

"PurchaseOrderDate": null,

"PurchaseOrderRevision": null,

"FirstPartyRegistrationNumber": "4567890",

"ThirdPartyRegistrationNumber": null,

"InvoicingRule": null,

"ShipToCustomerName": "Total Internet",

"ShipToCustomerNumber": "1008",

"BillingDate": "2018-02-20",

"BusinessUnit": "Vision Operations",

"InvoiceStatus": "Complete",

"AccountingDate": "2018-02-20",

"ShipToSite": "1042",

"PayingCustomerName": "Total Internet",

"PayingCustomerSite": "Foster City (OPS)",

"BillToCustomerName": "Total Internet",

"FreightAmount": null,

"Carrier": null,

"ShipDate": null,

"ShippingReference": null,

"BillToContact": null,

"ShipToContact": null,

"PrintOption": "Yes",

"CreatedBy": "AR_MGR_OPERATIONS",

"CreationDate": "2018-11-23T08:53:33.019+00:00",

"LastUpdatedBy": "AR_MGR_OPERATIONS",

"LastUpdateDate": "2018-11-23T09:11:14+00:00",

"PayingCustomerAccount": "1008",

"SoldToPartyNumber": "1008",

"RemitToAddress": "ZD, Park Avenue St",

"DefaultTaxationCountry": "US",

"EnteredAmount": 1299.99,

"InvoiceBalanceAmount": 1299.99,

"Prepayment": "No",

"Intercompany": "No",

"DocumentFiscalClassification": null,

"BankAccountNumber": null,

"CreditCardAuthorizationRequestIdentifier": null,

"CreditCardExpirationDate": null,

"CreditCardIssuerCode": null,

"CreditCardTokenNumber": null,

"CreditCardVoiceAuthorizationCode": null,

"CreditCardErrorCode": null,

"CreditCardErrorText": null,

"CardHolderLastName": null,

"CardHolderFirstName": null,

"ReceiptMethod": null,

"SalesPersonNumber": null,

"StructuredPaymentReference": null,

"links": [

{

"rel": "self",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100169169047",

"name": "receivablesInvoices",

"kind": "item",

"properties": {

"changeIndicator": "ACED0005737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A657870000000017704000000017372001B6F7261636C652E6A626F2E646F6D61696E2E4E756C6C56616C75655899C1C58DAABEEB02000149000A6D53514C54797065496478700000000C78"

}

},

{

"rel": "canonical",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100169169047",

"name": "receivablesInvoices",

"kind": "item"

},

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100169169047/lov/transactionSources",

"name": "transactionSources",

"kind": "collection"

},

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100169169047/lov/businessUnits",

"name": "businessUnits",

"kind": "collection"

},

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100169169047/lov/PaymentTermsVA",

"name": "PaymentTermsVA",

"kind": "collection"

},

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100169169047/lov/thirdPartyTaxRegistrationNumbers",

"name": "thirdPartyTaxRegistrationNumbers",

"kind": "collection"

},

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100169169047/lov/invoiceStatuses",

"name": "invoiceStatuses",

"kind": "collection"

},

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100169169047/lov/shipToCustomers",

"name": "shipToCustomers",

"kind": "collection"

},

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100169169047/lov/billToCustomers",

"name": "billToCustomers",

"kind": "collection"

},

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100169169047/lov/legalEntities",

"name": "legalEntities",

"kind": "collection"

},

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100169169047/lov/invoicingRules",

"name": "invoicingRules",

"kind": "collection"

},

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100169169047/lov/billToSites",

"name": "billToSites",

"kind": "collection"

},

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100169169047/lov/taxationCountries",

"name": "taxationCountries",

"kind": "collection"

},

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100169169047/lov/firstPartyTaxRegistrationNumbers",

"name": "firstPartyTaxRegistrationNumbers",

"kind": "collection"

},

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100169169047/lov/transactionTypes",

"name": "transactionTypes",

"kind": "collection"

},

{

"rel": "child",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100169169047/child/receivablesInvoiceLines",

"name": "receivablesInvoiceLines",

"kind": "collection"

},

{

"rel": "child",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100169169047/child/receivablesInvoiceTransactionDFF",

"name": "receivablesInvoiceTransactionDFF",

"kind": "collection"

},

{

"rel": "child",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100169169047/child/receivablesInvoiceGdf",

"name": "receivablesInvoiceGdf",

"kind": "collection"

},

{

"rel": "child",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100169169047/child/receivablesInvoiceInstallments",

"name": "receivablesInvoiceInstallments",

"kind": "collection"

},

{

"rel": "child",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100169169047/child/receivablesInvoiceDFF",

"name": "receivablesInvoiceDFF",

"kind": "collection"

},

{

"rel": "child",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100169169047/child/attachments",

"name": "attachments",

"kind": "collection"

},

{

"rel": "child",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100169169047/child/notes",

"name": "notes",

"kind": "collection"

}

]

}

],

"count": 1,

"hasMore": false,

"limit": 25,

"offset": 0,

"links": [

{

"rel": "self",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices",

"name": "receivablesInvoices",

"kind": "collection"

}

]

}

3.3.10 Sample Payload to Incomplete an Invoice

cURL Command:

curl --user <username>:<password> -X PATCH -H "Content-Type: application/vnd.oracle.adf.resourceitem+json" --data @Incomplete_invoice_payload.json https://<host>:<port>/fscmRestApi/resources/<version>/receivablesInvoices/<CustomerTransactionId>

Sample URL

https://<host>:<port>/fscmRestApi/resources/11.13.0.0/receivablesInvoices/<CustomerTransactionId>

Sample Request Payload that the Client Sends to incomplete an invoice

{

"InvoiceStatus":"Incomplete"

}

Sample Response Payload that the Client Receives to incomplete an invoice

{

"CustomerTransactionId": 300100169169047,

"DueDate": "2018-02-20",

"ConversionDate": null,

"ConversionRate": null,

"InvoiceCurrencyCode": "USD",

"SpecialInstructions": null,

"CrossReference": null,

"DocumentNumber": null,

"TransactionNumber": "864",

"TransactionDate": "2018-02-20",

"TransactionType": "Invoice",

"TransactionSource": "Manual-NES",

"BillToCustomerNumber": "1008",

"BillToSite": "Foster City (OPS)",

"Comments": "New Laptop Promotion",

"InternalNotes": "Best Priced item",

"PaymentTerms": "30 Net",

"LegalEntityIdentifier": "USSYS12030",

"ConversionRateType": null,

"PurchaseOrder": null,

"PurchaseOrderDate": null,

"PurchaseOrderRevision": null,

"FirstPartyRegistrationNumber": "4567890",

"ThirdPartyRegistrationNumber": null,

"InvoicingRule": null,

"ShipToCustomerName": "Total Internet",

"ShipToCustomerNumber": "1008",

"BillingDate": "2018-02-20",

"BusinessUnit": "Vision Operations",

"InvoiceStatus": "Incomplete",

"AccountingDate": "2018-02-20",

"ShipToSite": "1042",

"PayingCustomerName": "Total Internet",

"PayingCustomerSite": "Foster City (OPS)",

"BillToCustomerName": "Total Internet",

"FreightAmount": null,

"Carrier": null,

"ShipDate": null,

"ShippingReference": null,

"BillToContact": null,

"ShipToContact": null,

"PrintOption": "Yes",

"CreatedBy": "AR_MGR_OPERATIONS",

"CreationDate": "2018-11-23T08:53:33.019+00:00",

"LastUpdatedBy": "AR_MGR_OPERATIONS",

"LastUpdateDate": "2018-11-23T09:14:35+00:00",

"PayingCustomerAccount": "1008",

"SoldToPartyNumber": "1008",

"RemitToAddress": "ZD, Park Avenue St",

"DefaultTaxationCountry": "US",

"EnteredAmount": 1299.99,

"InvoiceBalanceAmount": 1299.99,

"Prepayment": "No",

"Intercompany": "No",

"DocumentFiscalClassification": null,

"BankAccountNumber": null,

"CreditCardAuthorizationRequestIdentifier": null,

"CreditCardExpirationDate": null,

"CreditCardIssuerCode": null,

"CreditCardTokenNumber": null,

"CreditCardVoiceAuthorizationCode": null,

"CreditCardErrorCode": null,

"CreditCardErrorText": null,

"CardHolderLastName": null,

"CardHolderFirstName": null,

"ReceiptMethod": null,

"SalesPersonNumber": null,

"StructuredPaymentReference": null,

"links": [

{

"rel": "self",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100169169047",

"name": "receivablesInvoices",

"kind": "item",

"properties": {

"changeIndicator": "ACED0005737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A65787000000001770400000001737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000878"

}

},

{

"rel": "canonical",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100169169047",

"name": "receivablesInvoices",

"kind": "item"

},

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100169169047/lov/transactionSources",

"name": "transactionSources",

"kind": "collection"

},

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100169169047/lov/businessUnits",

"name": "businessUnits",

"kind": "collection"

},

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100169169047/lov/PaymentTermsVA",

"name": "PaymentTermsVA",

"kind": "collection"

},

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100169169047/lov/thirdPartyTaxRegistrationNumbers",

"name": "thirdPartyTaxRegistrationNumbers",

"kind": "collection"

},

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100169169047/lov/invoiceStatuses",

"name": "invoiceStatuses",

"kind": "collection"

},

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100169169047/lov/shipToCustomers",

"name": "shipToCustomers",

"kind": "collection"

},

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100169169047/lov/billToCustomers",

"name": "billToCustomers",

"kind": "collection"

},

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100169169047/lov/legalEntities",

"name": "legalEntities",

"kind": "collection"

},

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100169169047/lov/invoicingRules",

"name": "invoicingRules",

"kind": "collection"

},

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100169169047/lov/billToSites",

"name": "billToSites",

"kind": "collection"

},

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100169169047/lov/taxationCountries",

"name": "taxationCountries",

"kind": "collection"

},

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100169169047/lov/firstPartyTaxRegistrationNumbers",

"name": "firstPartyTaxRegistrationNumbers",

"kind": "collection"

},

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100169169047/lov/transactionTypes",

"name": "transactionTypes",

"kind": "collection"

},

{

"rel": "child",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100169169047/child/receivablesInvoiceLines",

"name": "receivablesInvoiceLines",

"kind": "collection"

},

{

"rel": "child",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100169169047/child/receivablesInvoiceTransactionDFF",

"name": "receivablesInvoiceTransactionDFF",

"kind": "collection"

},

{

"rel": "child",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100169169047/child/receivablesInvoiceGdf",

"name": "receivablesInvoiceGdf",

"kind": "collection"

},

{

"rel": "child",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100169169047/child/receivablesInvoiceInstallments",

"name": "receivablesInvoiceInstallments",

"kind": "collection"

},

{

"rel": "child",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100169169047/child/receivablesInvoiceDFF",

"name": "receivablesInvoiceDFF",

"kind": "collection"

},

{

"rel": "child",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100169169047/child/attachments",

"name": "attachments",

"kind": "collection"

},

{

"rel": "child",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100169169047/child/notes",

"name": "notes",

"kind": "collection"

}

]

}

3.3.11 Sample Payload to Update Installments of an Invoice

Sample URL

cURL Command:

curl --user <username>:<password> -X PATCH -H "Content-Type: application/vnd.oracle.adf.resourceitem+json" --data @update_installment_payload.json https://<host>:<port>/fscmRestApi/resources/<version>/receivablesInvoices/<CustomerTransactionId>

Example URL

The following is the format of the resource URL.

https://<host>:<port>/fscmRestApi/resources/11.13.0.0/receivablesInvoices/<CustomerTransactionId>

Sample Request Payload that the Client Sends to update the installments of an invoice

In the URL itself you need to pass the customerTranasctionId

{

"receivablesInvoiceInstallments":

[

{

"InstallmentId": 321956,

"OriginalAmount": 459,

"InstallmentDueDate": "2018-03-20"

{

"InstallmentId": 321957,

"OriginalAmount": 399,

"InstallmentDueDate": "2018-04-19"

}

]

}

Sample Response Payload that the Client Receives to update the installments of an invoice

{

"CustomerTransactionId": 300100169169047,

"DueDate": "2018-02-20",

"ConversionDate": null,

"ConversionRate": null,

"InvoiceCurrencyCode": "USD",

"SpecialInstructions": null,

"CrossReference": null,

"DocumentNumber": null,

"TransactionNumber": "864",

"TransactionDate": "2018-02-20",

"TransactionType": "Invoice",

"TransactionSource": "Manual-NES",

"BillToCustomerNumber": "1008",

"BillToSite": "Foster City (OPS)",

"Comments": "New Laptop Promotion",

"InternalNotes": "Best Priced item",

"PaymentTerms": "30/60/90",

"LegalEntityIdentifier": "USSYS12030",

"ConversionRateType": null,

"PurchaseOrder": null,

"PurchaseOrderDate": null,

"PurchaseOrderRevision": null,

"FirstPartyRegistrationNumber": "4567890",

"ThirdPartyRegistrationNumber": null,

"InvoicingRule": null,

"ShipToCustomerName": "Total Internet",

"ShipToCustomerNumber": "1008",

"BillingDate": "2018-02-20",

"BusinessUnit": "Vision Operations",

"InvoiceStatus": "Complete",

"AccountingDate": "2018-02-20",

"ShipToSite": "1042",

"PayingCustomerName": "Total Internet",

"PayingCustomerSite": "Foster City (OPS)",

"BillToCustomerName": "Total Internet",

"FreightAmount": null,

"Carrier": null,

"ShipDate": null,

"ShippingReference": null,

"BillToContact": null,

"ShipToContact": null,

"PrintOption": "Yes",

"CreatedBy": "AR_MGR_OPERATIONS",

"CreationDate": "2018-11-23T08:53:33.019+00:00",

"LastUpdatedBy": "AR_MGR_OPERATIONS",

"LastUpdateDate": "2018-11-23T09:22:18+00:00",

"PayingCustomerAccount": "1008",

"SoldToPartyNumber": "1008",

"RemitToAddress": "ZD, Park Avenue St",

"DefaultTaxationCountry": "US",

"EnteredAmount": 1299.99,

"InvoiceBalanceAmount": 1299.99,

"Prepayment": "No",

"Intercompany": "No",

"DocumentFiscalClassification": null,

"BankAccountNumber": null,

"CreditCardAuthorizationRequestIdentifier": null,

"CreditCardExpirationDate": null,

"CreditCardIssuerCode": null,

"CreditCardTokenNumber": null,

"CreditCardVoiceAuthorizationCode": null,

"CreditCardErrorCode": null,

"CreditCardErrorText": null,

"CardHolderLastName": null,

"CardHolderFirstName": null,

"ReceiptMethod": null,

"SalesPersonNumber": null,

"StructuredPaymentReference": null,

"receivablesInvoiceInstallments": [

{

"InstallmentId": 321956,

"InstallmentSequenceNumber": 1,

"InstallmentDueDate": "2018-03-20",

"OriginalAmount": 459,

"PaymentDaysLate": 246,

"InstallmentBalanceDue": 459,

"InstallmentStatus": "Open",

"DisputeAmount": null,

"DisputeDate": null,

"InstallmentClosedDate": "4712-12-31",

"InstallmentGLClosedDate": "4712-12-31",

"AccountedBalanceDue": 459,

"InstallmentAmountAdjusted": null,

"InstallmentAmountCredited": null,

"AmountPaid": null,

"PendingAdjustmentAmount": null,

"InstallmentLineAmountOriginal": 459,

"InstallmentLineAmountDue": 459,

"InstallmentFreightAmountOriginal": 0,

"InstallmentFreightAmountDue": 0,

"InstallmentTaxAmountOriginal": 0,

"InstallmentTaxAmountDue": 0,

"CreationDate": "2018-11-23T09:19:59+00:00",

"CreatedBy": "AR_MGR_OPERATIONS",

"LastUpdateDate": "2018-11-23T09:22:18.006+00:00",

"LastUpdatedBy": "AR_MGR_OPERATIONS",

"links": [

{

"rel": "self",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100169169047/child/receivablesInvoiceInstallments/321956",

"name": "receivablesInvoiceInstallments",

"kind": "item",

"properties": {

}

},

{

"rel": "canonical",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100169169047/child/receivablesInvoiceInstallments/321956",

"name": "receivablesInvoiceInstallments",

"kind": "item"

},

{

"rel": "parent",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100169169047",

"name": "receivablesInvoices",

"kind": "item"

},

{

"rel": "child",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100169169047/child/receivablesInvoiceInstallments/321956/child/receivablesInvoiceInstallmentGDF",

"name": "receivablesInvoiceInstallmentGDF",

"kind": "collection"

},

{

"rel": "child",

"name": "receivablesInvoiceInstallmentNotes",

"kind": "collection"

}

]

},

{

"InstallmentId": 321957,

"InstallmentSequenceNumber": 2,

"InstallmentDueDate": "2018-04-19",

"OriginalAmount": 399,

"PaymentDaysLate": 216,

"InstallmentBalanceDue": 399,

"InstallmentStatus": "Open",

"DisputeAmount": null,

"DisputeDate": null,

"InstallmentClosedDate": "4712-12-31",

"InstallmentGLClosedDate": "4712-12-31",

"AccountedBalanceDue": 399,

"InstallmentAmountAdjusted": null,

"InstallmentAmountCredited": null,

"AmountPaid": null,

"PendingAdjustmentAmount": null,

"InstallmentLineAmountOriginal": 399,

"InstallmentLineAmountDue": 399,

"InstallmentFreightAmountOriginal": 0,

"InstallmentFreightAmountDue": 0,

"InstallmentTaxAmountOriginal": 0,

"InstallmentTaxAmountDue": 0,

"CreationDate": "2018-11-23T09:19:59+00:00",

"CreatedBy": "AR_MGR_OPERATIONS",

"LastUpdateDate": "2018-11-23T09:22:18.013+00:00",

"LastUpdatedBy": "AR_MGR_OPERATIONS",

"links": [

{

"rel": "self",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100169169047/child/receivablesInvoiceInstallments/321957",

"name": "receivablesInvoiceInstallments",

"kind": "item",

"properties": {

}

},

{

"rel": "canonical",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100169169047/child/receivablesInvoiceInstallments/321957",

"name": "receivablesInvoiceInstallments",

"kind": "item"

},

{

"rel": "parent",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100169169047",

"name": "receivablesInvoices",

"kind": "item"

},

{

"rel": "child",

"name": "receivablesInvoiceInstallmentGDF",

"kind": "collection"

},

{

"rel": "child",

"name": "receivablesInvoiceInstallmentNotes",

"kind": "collection"

}

]

}

],

"links": [

{

"rel": "self",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100169169047",

"name": "receivablesInvoices",

"kind": "item",

"properties": {

}

},

{

"rel": "canonical",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100169169047",

"name": "receivablesInvoices",

"kind": "item"

},

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100169169047/lov/transactionSources",

"name": "transactionSources",

"kind": "collection"

},

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100169169047/lov/businessUnits",

"name": "businessUnits",

"kind": "collection"

},

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100169169047/lov/PaymentTermsVA",

"name": "PaymentTermsVA",

"kind": "collection"

},

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100169169047/lov/thirdPartyTaxRegistrationNumbers",

"name": "thirdPartyTaxRegistrationNumbers",

"kind": "collection"

},

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100169169047/lov/invoiceStatuses",

"name": "invoiceStatuses",

"kind": "collection"

},

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100169169047/lov/shipToCustomers",

"name": "shipToCustomers",

"kind": "collection"

},

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100169169047/lov/billToCustomers",

"name": "billToCustomers",

"kind": "collection"

},

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100169169047/lov/legalEntities",

"name": "legalEntities",

"kind": "collection"

},

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100169169047/lov/invoicingRules",

"name": "invoicingRules",

"kind": "collection"

},

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100169169047/lov/billToSites",

"name": "billToSites",

"kind": "collection"

},

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100169169047/lov/taxationCountries",

"name": "taxationCountries",

"kind": "collection"

},

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100169169047/lov/firstPartyTaxRegistrationNumbers",

"name": "firstPartyTaxRegistrationNumbers",

"kind": "collection"

},

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100169169047/lov/transactionTypes",

"name": "transactionTypes",

"kind": "collection"

},

{

"rel": "child",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100169169047/child/receivablesInvoiceLines",

"name": "receivablesInvoiceLines",

"kind": "collection"

},

{

"rel": "child",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100169169047/child/receivablesInvoiceTransactionDFF",

"name": "receivablesInvoiceTransactionDFF",

"kind": "collection"

},

{

"rel": "child",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100169169047/child/receivablesInvoiceGdf",

"name": "receivablesInvoiceGdf",

"kind": "collection"

},

{

"rel": "child",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100169169047/child/receivablesInvoiceInstallments",

"name": "receivablesInvoiceInstallments",

"kind": "collection"

},

{

"rel": "child",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100169169047/child/receivablesInvoiceDFF",

"name": "receivablesInvoiceDFF",

"kind": "collection"

},

{

"rel": "child",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100169169047/child/attachments",

"name": "attachments",

"kind": "collection"

},

{

"rel": "child",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100169169047/child/notes",

"name": "notes",

"kind": "collection"

}

]

}

3.3.12 Sample Payload to Update the Payment Term of an Invoice

cURL Command:

curl --user <username>:<password> -X PATCH -H "Content-Type: application/vnd.oracle.adf.resourceitem+json" --data @update_payment_term_payload.json https://<host>:<port>/fscmRestApi/resources/<version>/receivablesInvoices/<CustomerTransactionId>

Sample URL

https://<host>:<port>/fscmRestApi/resources/11.13.0.0/receivablesInvoices/<CustomerTransactionId>

Sample Request Payload that the Client Sends to update the payment term of an invoice

In the URL itself you need to pass the customerTranasctionId

{

"PaymentTerms": "30/60/90"

}

Sample Response Payload that the Client Receives to update the payment term of an invoice

{

"CustomerTransactionId": 300100169169047,

"DueDate": "2018-02-20",

"ConversionDate": null,

"ConversionRate": null,

"InvoiceCurrencyCode": "USD",

"SpecialInstructions": null,

"CrossReference": null,

"DocumentNumber": null,

"TransactionNumber": "864",

"TransactionDate": "2018-02-20",

"TransactionType": "Invoice",

"TransactionSource": "Manual-NES",

"BillToCustomerNumber": "1008",

"BillToSite": "Foster City (OPS)",

"Comments": "New Laptop Promotion",

"InternalNotes": "Best Priced item",

"PaymentTerms": "30/60/90",

"LegalEntityIdentifier": "USSYS12030",

"ConversionRateType": null,

"PurchaseOrder": null,

"PurchaseOrderDate": null,

"PurchaseOrderRevision": null,

"FirstPartyRegistrationNumber": "4567890",

"ThirdPartyRegistrationNumber": null,

"InvoicingRule": null,

"ShipToCustomerName": "Total Internet",

"ShipToCustomerNumber": "1008",

"BillingDate": "2018-02-20",

"BusinessUnit": "Vision Operations",

"InvoiceStatus": "Complete",

"AccountingDate": "2018-02-20",

"ShipToSite": "1042",

"PayingCustomerName": "Total Internet",

"PayingCustomerSite": "Foster City (OPS)",

"BillToCustomerName": "Total Internet",

"FreightAmount": null,

"Carrier": null,

"ShipDate": null,

"ShippingReference": null,

"BillToContact": null,

"ShipToContact": null,

"PrintOption": "Yes",

"CreatedBy": "AR_MGR_OPERATIONS",

"CreationDate": "2018-11-23T08:53:33.019+00:00",

"LastUpdatedBy": "AR_MGR_OPERATIONS",

"LastUpdateDate": "2018-11-23T09:19:59+00:00",

"PayingCustomerAccount": "1008",

"SoldToPartyNumber": "1008",

"RemitToAddress": "ZD, Park Avenue St",

"DefaultTaxationCountry": "US",

"EnteredAmount": 1299.99,

"InvoiceBalanceAmount": 1299.99,

"Prepayment": "No",

"Intercompany": "No",

"DocumentFiscalClassification": null,

"BankAccountNumber": null,

"CreditCardAuthorizationRequestIdentifier": null,

"CreditCardExpirationDate": null,

"CreditCardIssuerCode": null,

"CreditCardTokenNumber": null,

"CreditCardVoiceAuthorizationCode": null,

"CreditCardErrorCode": null,

"CreditCardErrorText": null,

"CardHolderLastName": null,

"CardHolderFirstName": null,

"ReceiptMethod": null,

"SalesPersonNumber": null,

"StructuredPaymentReference": null,

"links": [

{

"rel": "self",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100169169047",

"name": "receivablesInvoices",

"kind": "item",

"properties": {

}

},

{

"rel": "canonical",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100169169047",

"name": "receivablesInvoices",

"kind": "item"

},

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100169169047/lov/transactionSources",

"name": "transactionSources",

"kind": "collection"

},

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100169169047/lov/businessUnits",

"name": "businessUnits",

"kind": "collection"

},

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100169169047/lov/PaymentTermsVA",

"name": "PaymentTermsVA",

"kind": "collection"

},

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100169169047/lov/thirdPartyTaxRegistrationNumbers",

"name": "thirdPartyTaxRegistrationNumbers",

"kind": "collection"

},

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100169169047/lov/invoiceStatuses",

"name": "invoiceStatuses",

"kind": "collection"

},

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100169169047/lov/shipToCustomers",

"name": "shipToCustomers",

"kind": "collection"

},

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100169169047/lov/billToCustomers",

"name": "billToCustomers",

"kind": "collection"

},

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100169169047/lov/legalEntities",

"name": "legalEntities",

"kind": "collection"

},

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100169169047/lov/invoicingRules",

"name": "invoicingRules",

"kind": "collection"

},

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100169169047/lov/billToSites",

"name": "billToSites",

"kind": "collection"

},

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100169169047/lov/taxationCountries",

"name": "taxationCountries",

"kind": "collection"

},

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100169169047/lov/firstPartyTaxRegistrationNumbers",

"name": "firstPartyTaxRegistrationNumbers",

"kind": "collection"

},

{

"rel": "lov",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100169169047/lov/transactionTypes",

"name": "transactionTypes",

"kind": "collection"

},

{

"rel": "child",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100169169047/child/receivablesInvoiceLines",

"name": "receivablesInvoiceLines",

"kind": "collection"

},

{

"rel": "child",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100169169047/child/receivablesInvoiceTransactionDFF",

"name": "receivablesInvoiceTransactionDFF",

"kind": "collection"

},

{

"rel": "child",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100169169047/child/receivablesInvoiceGdf",

"name": "receivablesInvoiceGdf",

"kind": "collection"

},

{

"rel": "child",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100169169047/child/receivablesInvoiceInstallments",

"name": "receivablesInvoiceInstallments",

"kind": "collection"

},

{

"rel": "child",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100169169047/child/receivablesInvoiceDFF",

"name": "receivablesInvoiceDFF",

"kind": "collection"

},

{

"rel": "child",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100169169047/child/attachments",

"name": "attachments",

"kind": "collection"

},

{

"rel": "child",

"href": "https://fuscdrmsmc44-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/receivablesInvoices/300100169169047/child/notes",

"name": "notes",

"kind": "collection"

}

]

}

3.3.13 Sample Payload to Create Manual Tax Lines for an Invoice

cURL Command:

curl --user <username>:<password> -X POST -H "Content-Type: application/vnd.oracle.adf.resourceitem+json" --data @invoice_with_manual_taxlines_payload.json https://<host>:<port>/fscmRestApi/resources/<version>/receivablesInvoices

Sample URL

The following is the format of the resource URL.

https://<host>:<port>/fscmRestApi/resources/<version>/receivablesInvoices

Sample Request Payload that the Client Sends to create manual tax lines for an invoice

{

"BillingDate":"2018-10-10",

"BillToCustomerNumber":"1008",

"BusinessUnit":"Vision Operations",

"Comments":"Test comments",

"DueDate":"2018-10-10",

"InternalNotes":"Test internal notes",

"InvoiceCurrencyCode":"USD",

"PaymentTerms":"30 Net",

"TransactionDate":"2018-10-10",

"TransactionSource":"Manual-NES",

"ShipToCustomerName":"Total Internet",

"ShipToCustomerNumber":"1008",

"ShipToSite":"1042",

"TransactionType":"Invoice",

"StructuredPaymentReference":"TestRef",

"receivablesInvoiceLines":[

{

"Description":"Item",

"LineNumber":1,

"Quantity":102,

"UnitSellingPrice":100,

"TaxClassificationCode":"VAT20",

"receivablesInvoiceLineTaxLines":[

{

"TaxAmount":680,

"TaxRegimeCode":"FUS_STCC_REGIME-UES",

"TaxRateCode":"VAT20"

}

]

{

"Description":"Item",

"LineNumber":2,

"Quantity":10,

"UnitSellingPrice":100.2,

"TaxClassificationCode":"VAT20",

"receivablesInvoiceLineTaxLines":[

{

"TaxAmount":180.4,

"TaxRegimeCode":"FUS_STCC_REGIME-UES",

"TaxRateCode":"VAT20"

}

]

}

]

}

Sample Response Payload that the Client Receives to create manual tax lines for an invoice

{

"BillingDate":"2018-10-10",

"BillToCustomerNumber":"1008",

"BusinessUnit":"Vision Operations",

"Comments":"Test comments",

"DueDate":"2018-10-10",

"InternalNotes":"Test internal notes",

"InvoiceCurrencyCode":"USD",

"PaymentTerms":"30 Net",

"TransactionDate":"2018-10-10",

"TransactionSource":"Manual-NES",

"ShipToCustomerName":"Total Internet",

"ShipToCustomerNumber":"1008",

"ShipToSite":"1042",

"TransactionType":"Invoice",

"StructuredPaymentReference":"TestRef",

"receivablesInvoiceLines":[

{

"Description":"Item",

"LineNumber":1,

"Quantity":102,

"UnitSellingPrice":100,

"TaxClassificationCode":"VAT20",

"receivablesInvoiceLineTaxLines":[

{

"TaxAmount":680,

"TaxRegimeCode":"FUS_STCC_REGIME-UES",

"TaxRateCode":"VAT20"

}

]

{

"Description":"Item",

"LineNumber":2,

"Quantity":10,

"UnitSellingPrice":100.2,

"TaxClassificationCode":"VAT20",

"receivablesInvoiceLineTaxLines":[

{

"TaxAmount":180.4,

"TaxRegimeCode":"FUS_STCC_REGIME-UES",

"TaxRateCode":"VAT20"

}

]

}

]

}

3.4 Error Messages

When a service request is being processed and an error is encountered, the nature of the error will be communicated to the client. The table below shows the error message names and accompanying text that describes each error.

Receivables Invoice REST Service Error Messages Table

Message Name

Message Text

AR_BILL_TO_CUST_NOT_FOUND

The criteria you entered did not return a bill-to customer. Ensure that you entered the correct customer name and account number.

AR_BILL_TO_SITE_DUPLICATE

The criteria you entered returned duplicate customer bill-to sites.

AR_BILL_TO_SITE_NOT_FOUND

The customer bill-to site you entered does not exist.

AR_FUNC_CURRENCY_REQ

The currency you entered is invalid. You can only create an invoice in the ledger currency.

AR_BU_NOT_FOUND

The business unit you entered does not exist.

AR_BATCH_SOURCE_NOT_FOUND

The transaction source you entered does not exist.

AR_SHIP_TO_CUST_NOT_FOUND

The criteria you entered did not return a ship-to customer. Ensure that you entered the correct ship-to customer name and account number.

AR_SHIP_TO_CUST_NUM_REQ

Enter the ship-to customer account number.

AR_SHIP_TO_SITE_NOT_FOUND

The customer ship-to site you entered does not exist.

AR_ITEM_NOT_FOUND

Enter the ship-to customer account number.

AR_INVALID_INVENTORY_ITEM_CODE

The item {ITEM_NUMBER} you entered is invalid.

AR_LINE_ATTR_OPT_REQ

Enter a value for item, memo line, or description for line {NUMBER}.

AR_WH_NOT_FOUND

The warehouse {WAREHOUSE_CODE} you entered on line {NUMBER} does not exist.

AR_NO_ITEM_NO_WH

You must provide an item for line {LINE_NUMBER} if you provide the warehouse {WAREHOUSE_CODE}.

AR_ITEM_INVENTORYORG_WS

The item {ITEM} is not associated with the warehouse {WAREHOUSE_CODE}.

AR_VALID_WARESHOUSECODE_WS

The warehouse {WAREHOUSE_CODE} should refer to the item master setup as the item validation organization for the business unit.

AR_REV_RULE_NAME_NOT_FOUND

The revenue scheduling rule {REVENUE_RULE} that you entered on line {NUMBER} does not exist.

AR_RULE_NAME_NOT_NULL_WS

You must enter a revenue scheduling rule on line {LINE_NUMBER} because an invoicing rule is defined at the invoice header level.

AR_INVALID_ACCOUNTING_RULE_WS

The revenue scheduling rule {REVENUE_RULE} that you entered is invalid.

AR_RULE_DURATION_VAR

You must provide a duration for the revenue scheduling rule entered on line {NUMBER} because it is defined with the variable schedule rule type.

AR_RULE_DURATION_NOT_REQ

You cannot enter a revenue scheduling rule duration for line {NUMBER}.

AR_RULE_START_DT_NOT_NULL

You must enter a revenue scheduling rule start date on line {NUMBER}.

AR_RULE_END_DATE_LATER

The revenue scheduling rule end date that you entered on line {NUMBER} must be later than or equal to the start date.

AR_TRANS_BUS_CATG_NOT_FOUND

The transaction business category that you entered on line {NUMBER} does not exist.

AR_USER_DEFINED_FC_NOT_FOUND

The user-defined fiscal classification that you entered on line {NUMBER} does not exist.

AR_INTENDED_USE_NOT_FOUND

The intended use that you entered on line {NUMBER} does not exist.

AR_PRODUCT_FC_NOT_FOUND

The product fiscal classification that you entered on line {NUMBER} does not exist.

AR_PRODUCT_CATG_NOT_FOUND

The product category that you entered on line {NUMBER} does not exist.

AR_PRODUCT_TYPE_NOT_FOUND

The product type that you entered on line {NUMBER} does not exist.

AR_TCC_NOT_FOUND

The tax classification code that you entered on line {NUMBER} does not exist.