Get Invoices Using a Third-Level Resource Attribute
Your Accounts Payable Supervisor or Manager would like to view all invoices using some information that is captured on the invoice line in a descriptive flexfield. For example, invoices where the ProductSubcategory
is 'Laptops'.
Example URL
Here's an example of the resource URL to display data from only the invoices resource:
GET
/fscmRestApi/resources/latest/invoices?q=invoiceLines.invoiceLineDff. ProductSubcategory='Laptops'
Example Request
Here's an example of the request body in JSON format:
curl --location --request GET 'https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices?q=invoiceLines.invoiceLineDff. ProductSubcategory='Laptops' \
Supported media types:
- Content-Type: application/json
- Add a Header as REST-Framework-Version and value as 2 or above
Example Response
Here's an example of the response body in JSON format:
{
"items": [
{
"InvoiceId": 300100189097414,
"InvoiceNumber": "PJC_20-2-2020-1",
"InvoiceCurrency": "USD",
"PaymentCurrency": "USD",
"InvoiceAmount": 100,
"InvoiceDate": "2020-03-20",
"BusinessUnit": "Vision Operations",
"Supplier": "Advanced Network Devices",
"SupplierNumber": "1013",
"ProcurementBU": null,
"SupplierSite": "FRESNO",
"RequesterId": null,
"Requester": null,
"InvoiceGroup": "PJC",
"ConversionRateType": null,
"ConversionDate": null,
"ConversionRate": null,
"AccountingDate": "2020-03-20",
"Description": null,
"DeliveryChannelCode": null,
"DeliveryChannel": null,
"PayAloneFlag": false,
"InvoiceSource": "Manual invoice entry",
"InvoiceType": "Standard",
"PayGroup": "Standard",
"InvoiceReceivedDate": null,
"PaymentReasonCode": null,
"PaymentReason": null,
"PaymentReasonComments": null,
"PaymentTerms": "Immediate",
"TermsDate": "2020-03-20",
"GoodsReceivedDate": null,
"PaymentMethodCode": "EFT",
"PaymentMethod": "Electronic",
"SupplierTaxRegistrationNumber": null,
"FirstPartyTaxRegistrationId": 35658,
"FirstPartyTaxRegistrationNumber": "10810 2831 RT0001",
"LegalEntity": "Vision Operations",
"LegalEntityIdentifier": "USSYS12030",
"LiabilityDistribution": "01-000-2210-0000-000",
"DocumentCategory": null,
"DocumentSequence": null,
"VoucherNumber": null,
"ValidationStatus": "Not validated",
"ApprovalStatus": "Required",
"PaidStatus": "Unpaid",
"AccountingStatus": "Unaccounted",
"ApplyAfterDate": null,
"CanceledFlag": false,
"AmountPaid": null,
"BaseAmount": null,
"PurchaseOrderNumber": null,
"Party": "Advanced Network Devices",
"PartySite": "FRESNO",
"ControlAmount": null,
"DocumentFiscalClassificationCodePath": null,
"TaxationCountry": "United States",
"RoutingAttribute1": null,
"RoutingAttribute2": null,
"RoutingAttribute3": null,
"RoutingAttribute4": null,
"RoutingAttribute5": null,
"AccountCodingStatus": "Required",
"BudgetDate": "2020-03-20",
"FundsStatus": null,
"CanceledDate": null,
"CanceledBy": null,
"UniqueRemittanceIdentifier": null,
"UniqueRemittanceIdentifierCheckDigit": null,
"CreationDate": "2020-03-20T03:13:07.001+00:00",
"CreatedBy": "FINUSER1",
"LastUpdatedBy": "FINUSER1",
"LastUpdateDate": "2020-03-20T04:22:21.091+00:00",
"LastUpdateLogin": "9FF7988B92FB61E8E053D713F50A1086",
"links": [
{
"rel": "self",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/300100189097414",
"name": "invoices",
"kind": "item",
"properties": {
"changeIndicator": "ACED0005737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A65787000000001770400000001737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000778"
}
},
{
"rel": "canonical",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/300100189097414",
"name": "invoices",
"kind": "item"
},
{
"rel": "child",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/300100189097414/child/appliedPrepayments",
"name": "appliedPrepayments",
"kind": "collection"
},
{
"rel": "child",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/300100189097414/child/attachments",
"name": "attachments",
"kind": "collection"
},
{
"rel": "child",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/300100189097414/child/availablePrepayments",
"name": "availablePrepayments",
"kind": "collection"
},
{
"rel": "child",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/300100189097414/child/invoiceDff",
"name": "invoiceDff",
"kind": "collection"
},
{
"rel": "child",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/300100189097414/child/invoiceGdf",
"name": "invoiceGdf",
"kind": "collection"
},
{
"rel": "child",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/300100189097414/child/invoiceInstallments",
"name": "invoiceInstallments",
"kind": "collection"
},
{
"rel": "child",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/300100189097414/child/invoiceLines",
"name": "invoiceLines",
"kind": "collection"
}
]
}
],
"count": 1,
"hasMore": false,
"limit": 25,
"offset": 0,
"links": [
{
"rel": "self",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices",
"name": "invoices",
"kind": "collection"
},
{
"rel": "action",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/action/cancelInvoice",
"name": "cancelInvoice",
"kind": "other"
},
{
"rel": "action",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/action/cancelLine",
"name": "cancelLine",
"kind": "other"
},
{
"rel": "action",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/action/validateInvoice",
"name": "validateInvoice",
"kind": "other"
},
{
"rel": "action",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/action/calculateTax",
"name": "calculateTax",
"kind": "other"
},
{
"rel": "action",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/action/generateDistributions",
"name": "generateDistributions",
"kind": "other"
},
{
"rel": "action",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/action/applyPrepayments",
"name": "applyPrepayments",
"kind": "other"
},
{
"rel": "action",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/action/unapplyPrepayments",
"name": "unapplyPrepayments",
"kind": "other"
}
]
}