Get Specific Details for Invoices
Your accounts
payable user wants to view details for invoices they created. Specifically:
- Invoice ID
- Business unit
- Supplier
- Supplier site
- Invoice number
- Pay group
Example URL
Here's an example of the resource URL to display data from only the invoices resource:
GET
fscmRestApi/resources/11.13.18.05/invoices?fields=InvoiceId,BusinessUnit,Supplier,SupplierSite,InvoiceNumber,PayGroup&onlyData=true
cURL Command
curl -i -u "<username>:<password>" -H "Content-Type: application/json" -X GET https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices?fields=InvoiceId,BusinessUnit,Supplier,SupplierSite,InvoiceNumber,PayGroup&onlyData=true
Example Response
Here's an example of the response body in JSON format:
{
"items": [
{
"InvoiceId": 361908,
"BusinessUnit": "Vision Thailand- BU01 New",
"Supplier": "Thailand Tax Authority",
"SupplierSite": "Tax Authority O",
"InvoiceNumber": "Withholding tax - 300100171617230-4",
"PayGroup": null
},
{
"InvoiceId": 361909,
"BusinessUnit": "Vision Thailand- BU01 New",
"Supplier": "Thailand Tax Authority",
"SupplierSite": "Tax Authority O",
"InvoiceNumber": "Withholding tax - 300100171617230-6",
"PayGroup": null
},
{
"InvoiceId": 361910,
"BusinessUnit": "Vision Thailand- BU01 New",
"Supplier": "Thailand Tax Authority",
"SupplierSite": "Tax Authority O",
"InvoiceNumber": "Withholding tax - 300100171617230-5",
"PayGroup": null
},
{
"InvoiceId": 300100171617230,
"BusinessUnit": "Vision Thailand- BU01 New",
"Supplier": "Vision Thailand Supplier",
"SupplierSite": "Park66",
"InvoiceNumber": "WHT_181016_1",
"PayGroup": null
},
{
"InvoiceId": 361911,
"BusinessUnit": "Vision Thailand- BU02 New",
"Supplier": "Thailand Tax Authority",
"SupplierSite": "Tax Authority O",
"InvoiceNumber": "Withholding tax - 300100171617251-3",
"PayGroup": null
},
{
"InvoiceId": 361912,
"BusinessUnit": "Vision Thailand- BU02 New",
"Supplier": "Thailand Tax Authority",
"SupplierSite": "Tax Authority O",
"InvoiceNumber": "Withholding tax - 300100171617251-4",
"PayGroup": null
},
{
"InvoiceId": 362908,
"BusinessUnit": "Vision Thailand- BU02 New",
"Supplier": "Thailand Tax Authority",
"SupplierSite": "Tax Authority O",
"InvoiceNumber": "Withholding tax - 300100171617263-3",
"PayGroup": null
},
{
"InvoiceId": 362909,
"BusinessUnit": "Vision Thailand- BU02 New",
"Supplier": "Thailand Tax Authority",
"SupplierSite": "Tax Authority O",
"InvoiceNumber": "Withholding tax - 300100171617263-4",
"PayGroup": null
},
{
"InvoiceId": 300100171617251,
"BusinessUnit": "Vision Thailand- BU02 New",
"Supplier": "Vision Thailand Supplier",
"SupplierSite": "Park66",
"InvoiceNumber": "WHT_181016_2",
"PayGroup": null
},
{
"InvoiceId": 300100171617284,
"BusinessUnit": "Vision Thailand- BU02 New",
"Supplier": "Vision Thailand Supplier",
"SupplierSite": "Park66",
"InvoiceNumber": "VAT_181016_2",
"PayGroup": null
},
{
"InvoiceId": 300100171617263,
"BusinessUnit": "Vision Thailand- BU02 New",
"Supplier": "Vision Thailand Supplier",
"SupplierSite": "Park66",
"InvoiceNumber": "VAT_181016_1",
"PayGroup": null
},
{
"InvoiceId": 300100166952340,
"BusinessUnit": "Vertex BU",
"Supplier": "Advanced Network Devices",
"SupplierSite": "FRESNO 1",
"InvoiceNumber": "AC_Test",
"PayGroup": null
},
{
"InvoiceId": 294895,
"BusinessUnit": "Vision India - BU01",
"Supplier": "India Tax Authority",
"SupplierSite": "IL Tax BU01",
"InvoiceNumber": "Withholding tax - 300100119154019-2",
"PayGroup": "Standard"
},
{
"InvoiceId": 300100119154390,
"BusinessUnit": "Vision India - BU01",
"Supplier": "Gallant P1 004",
"SupplierSite": "Gall P1 004BU01",
"InvoiceNumber": "WHT_SC_TOT_02",
"PayGroup": "Standard"
},
{
"InvoiceId": 293903,
"BusinessUnit": "Vision India - BU01",
"Supplier": "India Tax Authority",
"SupplierSite": "IL Tax BU01",
"InvoiceNumber": "Withholding tax - 300100119490486-2",
"PayGroup": "Standard"
},
{
"InvoiceId": 300100119154009,
"BusinessUnit": "Vision India - BU01",
"Supplier": "Gallant P1 001",
"SupplierSite": "Gall P1 001 B01",
"InvoiceNumber": "WHT_P1_01",
"PayGroup": "Standard"
},
{
"InvoiceId": 293895,
"BusinessUnit": "Vision India - BU01",
"Supplier": "India Tax Authority",
"SupplierSite": "IL Tax BU01",
"InvoiceNumber": "Withholding tax - 300100119154009-2",
"PayGroup": "Standard"
},
{
"InvoiceId": 294896,
"BusinessUnit": "Vision India - BU01",
"Supplier": "India Tax Authority",
"SupplierSite": "IL Tax BU01",
"InvoiceNumber": "Withholding tax - 300100119154723-2",
"PayGroup": "Standard"
},
{
"InvoiceId": 300100119154807,
"BusinessUnit": "Vision India - BU01",
"Supplier": "Gallant P1 001",
"SupplierSite": "Gall P1 001 B01",
"InvoiceNumber": "WHT_SC_ST_194A_01",
"PayGroup": "Standard"
},
{
"InvoiceId": 293901,
"BusinessUnit": "Vision India - BU01",
"Supplier": "India Tax Authority",
"SupplierSite": "IL Tax BU01",
"InvoiceNumber": "Withholding tax - 300100119154807-2",
"PayGroup": "Standard"
},
{
"InvoiceId": 300100119490395,
"BusinessUnit": "Vision India - BU01",
"Supplier": "Gallant P1 001",
"SupplierSite": "Gall P1 001 B01",
"InvoiceNumber": "WHT_SC_ST_194D_01",
"PayGroup": "Standard"
},
{
"InvoiceId": 293902,
"BusinessUnit": "Vision India - BU01",
"Supplier": "India Tax Authority",
"SupplierSite": "IL Tax BU01",
"InvoiceNumber": "Withholding tax - 300100119490395-2",
"PayGroup": "Standard"
},
{
"InvoiceId": 300100119154019,
"BusinessUnit": "Vision India - BU01",
"Supplier": "Gallant P1 004",
"SupplierSite": "Gall P1 004BU01",
"InvoiceNumber": "WHT_SC_TOT_01",
"PayGroup": "Standard"
},
{
"InvoiceId": 300100119154723,
"BusinessUnit": "Vision India - BU01",
"Supplier": "Gallant P1 001",
"SupplierSite": "Gall P1 001 B01",
"InvoiceNumber": "WHT_SC_MT_01",
"PayGroup": "Standard"
},
{
"InvoiceId": 293896,
"BusinessUnit": "Vision India - BU01",
"Supplier": "India Tax Authority",
"SupplierSite": "IL Tax BU01",
"InvoiceNumber": "Withholding tax - 300100119154019-2-Canceled",
"PayGroup": "Standard"
}
],
"count": 25,
"hasMore": true,
"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"
}
]
}