Get Specific Details for Invoices, Lines, Distributions and Installments
Your Accounts Payable Supervisor or Manager would like to view a limited set of information from multiple invoice entities such as invoice header, lines, distributions, and installments. They are:
- Invoices:
- Invoice Number
- Invoice Amount
- Invoice Installments:
- Unpaid Amount
- Payment Method
- Invoice Lines:
- Line Number
- Line Amount
- Invoice Distributions:
- Distribution Line Number
- Distribution Amount
Example URL
Here's an example of the resource URL to display data from the invoices, invoice lines, invoice distributions, and invoice installments resources:
GET
/fscmRestApi/resources/11.13.18.05/invoices?fields=InvoiceNumber,InvoiceAmount;invoiceInstallments:UnpaidAmount,PaymentMethod;invoiceLines:LineNumber,LineAmount;invoiceLines.invoiceDistributions:DistributionLineNumber,DistributionAmount&onlyData=truecURL 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=InvoiceNumber,InvoiceAmount;invoiceInstallments:UnpaidAmount,PaymentMethod;invoiceLines:LineNumber,LineAmount;invoiceLines.invoiceDistributions:DistributionLineNumber,DistributionAmount&onlyData=true
Example Response
Here's an example of the response body in JSON format:
{
"items": [
{
"InvoiceNumber": "Withholding tax - 300100151967070-2",
"InvoiceAmount": 50,
"invoiceInstallments": [
{
"UnpaidAmount": 50,
"PaymentMethod": "Check"
}
],
"invoiceLines": [
{
"LineNumber": 1,
"LineAmount": 50,
"invoiceDistributions": [
{
"DistributionLineNumber": 1,
"DistributionAmount": 50
}
]
}
]
},
{
"InvoiceNumber": "Withholding tax - 300100152264186-2",
"InvoiceAmount": 80,
"invoiceInstallments": [
{
"UnpaidAmount": 80,
"PaymentMethod": "Check"
}
],
"invoiceLines": [
{
"LineNumber": 1,
"LineAmount": 80,
"invoiceDistributions": [
{
"DistributionLineNumber": 1,
"DistributionAmount": 80
}
]
}
]
},
{
"InvoiceNumber": "Withholding tax - 300100152264179-2",
"InvoiceAmount": 200,
"invoiceInstallments": [
{
"UnpaidAmount": 200,
"PaymentMethod": "Check"
}
],
"invoiceLines": [
{
"LineNumber": 1,
"LineAmount": 200,
"invoiceDistributions": [
{
"DistributionLineNumber": 1,
"DistributionAmount": 200
}
]
}
]
},
{
"InvoiceNumber": "Withholding tax - 300100152264183-2",
"InvoiceAmount": 30,
"invoiceInstallments": [
{
"UnpaidAmount": 30,
"PaymentMethod": "Check"
}
],
"invoiceLines": [
{
"LineNumber": 1,
"LineAmount": 30,
"invoiceDistributions": [
{
"DistributionLineNumber": 1,
"DistributionAmount": 30
}
]
}
]
},
{
"InvoiceNumber": "Withholding tax - 300100152264213-2",
"InvoiceAmount": 150,
"invoiceInstallments": [
{
"UnpaidAmount": 150,
"PaymentMethod": "Check"
}
],
"invoiceLines": [
{
"LineNumber": 1,
"LineAmount": 150,
"invoiceDistributions": [
{
"DistributionLineNumber": 1,
"DistributionAmount": 150
}
]
}
]
},
{
"InvoiceNumber": "TH_05",
"InvoiceAmount": 5000,
"invoiceInstallments": [
{
"UnpaidAmount": 0,
"PaymentMethod": "Check"
}
],
"invoiceLines": [
{
"LineNumber": 2,
"LineAmount": -150,
"invoiceDistributions": [
{
"DistributionLineNumber": 1,
"DistributionAmount": -150
}
]
},
{
"LineNumber": 1,
"LineAmount": 5000,
"invoiceDistributions": [
{
"DistributionLineNumber": 1,
"DistributionAmount": 5000
}
]
}
]
},
{
"InvoiceNumber": "TH_04",
"InvoiceAmount": 4000,
"invoiceInstallments": [
{
"UnpaidAmount": 0,
"PaymentMethod": "Check"
}
],
"invoiceLines": [
{
"LineNumber": 2,
"LineAmount": -80,
"invoiceDistributions": [
{
"DistributionLineNumber": 1,
"DistributionAmount": -80
}
]
},
{
"LineNumber": 1,
"LineAmount": 4000,
"invoiceDistributions": [
{
"DistributionLineNumber": 1,
"DistributionAmount": 4000
}
]
}
]
},
{
"InvoiceNumber": "TH_02",
"InvoiceAmount": 2000,
"invoiceInstallments": [
{
"UnpaidAmount": 0,
"PaymentMethod": "Check"
}
],
"invoiceLines": [
{
"LineNumber": 2,
"LineAmount": -200,
"invoiceDistributions": [
{
"DistributionLineNumber": 1,
"DistributionAmount": -200
}
]
},
{
"LineNumber": 1,
"LineAmount": 2000,
"invoiceDistributions": [
{
"DistributionLineNumber": 1,
"DistributionAmount": 2000
}
]
}
]
},
{
"InvoiceNumber": "TH_01",
"InvoiceAmount": 1000,
"invoiceInstallments": [
{
"UnpaidAmount": 0,
"PaymentMethod": "Check"
}
],
"invoiceLines": [
{
"LineNumber": 2,
"LineAmount": -50,
"invoiceDistributions": [
{
"DistributionLineNumber": 1,
"DistributionAmount": -50
}
]
},
{
"LineNumber": 1,
"LineAmount": 1000,
"invoiceDistributions": [
{
"DistributionLineNumber": 1,
"DistributionAmount": 1000
}
]
}
]
},
{
"InvoiceNumber": "TH_03",
"InvoiceAmount": 3000,
"invoiceInstallments": [
{
"UnpaidAmount": 0,
"PaymentMethod": "Check"
}
],
"invoiceLines": [
{
"LineNumber": 2,
"LineAmount": -30,
"invoiceDistributions": [
{
"DistributionLineNumber": 1,
"DistributionAmount": -30
}
]
},
{
"LineNumber": 1,
"LineAmount": 3000,
"invoiceDistributions": [
{
"DistributionLineNumber": 1,
"DistributionAmount": 3000
}
]
}
]
},
{
"InvoiceNumber": "Withholding tax - 300100171617230-4",
"InvoiceAmount": 5,
"invoiceInstallments": [
{
"UnpaidAmount": 5,
"PaymentMethod": "Check"
}
],
"invoiceLines": [
{
"LineNumber": 1,
"LineAmount": 5,
"invoiceDistributions": [
{
"DistributionLineNumber": 1,
"DistributionAmount": 5
}
]
}
]
},
{
"InvoiceNumber": "Withholding tax - 300100171617230-6",
"InvoiceAmount": 1,
"invoiceInstallments": [
{
"UnpaidAmount": 1,
"PaymentMethod": "Check"
}
],
"invoiceLines": [
{
"LineNumber": 1,
"LineAmount": 1,
"invoiceDistributions": [
{
"DistributionLineNumber": 1,
"DistributionAmount": 1
}
]
}
]
},
{
"InvoiceNumber": "Withholding tax - 300100171617230-5",
"InvoiceAmount": 10,
"invoiceInstallments": [
{
"UnpaidAmount": 10,
"PaymentMethod": "Check"
}
],
"invoiceLines": [
{
"LineNumber": 1,
"LineAmount": 10,
"invoiceDistributions": [
{
"DistributionLineNumber": 1,
"DistributionAmount": 10
}
]
}
]
},
{
"InvoiceNumber": "WHT_181016_1",
"InvoiceAmount": 300,
"invoiceInstallments": [
{
"UnpaidAmount": 0,
"PaymentMethod": "Check"
}
],
"invoiceLines": [
{
"LineNumber": 4,
"LineAmount": -5,
"invoiceDistributions": [
{
"DistributionLineNumber": 1,
"DistributionAmount": -5
}
]
},
{
"LineNumber": 5,
"LineAmount": -10,
"invoiceDistributions": [
{
"DistributionLineNumber": 1,
"DistributionAmount": -10
}
]
},
{
"LineNumber": 6,
"LineAmount": -1,
"invoiceDistributions": [
{
"DistributionLineNumber": 1,
"DistributionAmount": -1
}
]
},
{
"LineNumber": 1,
"LineAmount": 100,
"invoiceDistributions": [
{
"DistributionLineNumber": 1,
"DistributionAmount": 100
}
]
},
{
"LineNumber": 2,
"LineAmount": 100,
"invoiceDistributions": [
{
"DistributionLineNumber": 1,
"DistributionAmount": 100
}
]
},
{
"LineNumber": 3,
"LineAmount": 100,
"invoiceDistributions": [
{
"DistributionLineNumber": 1,
"DistributionAmount": 100
}
]
}
]
},
{
"InvoiceNumber": "Test1",
"InvoiceAmount": 1000,
"invoiceInstallments": [
{
"UnpaidAmount": 1000,
"PaymentMethod": "Check"
}
],
"invoiceLines": [
{
"LineNumber": 1,
"LineAmount": 1000,
"invoiceDistributions": [
{
"DistributionLineNumber": 1,
"DistributionAmount": 1000
}
]
}
]
},
{
"InvoiceNumber": "AP_RRF_CCU_I637",
"InvoiceAmount": 2925,
"invoiceInstallments": [
{
"UnpaidAmount": 2925,
"PaymentMethod": "Electronic"
}
],
"invoiceLines": [
{
"LineNumber": 1,
"LineAmount": 2925,
"invoiceDistributions": []
}
]
},
{
"InvoiceNumber": "AP_RRF_CCU_I647",
"InvoiceAmount": 3175,
"invoiceInstallments": [
{
"UnpaidAmount": 3175,
"PaymentMethod": "Electronic"
}
],
"invoiceLines": [
{
"LineNumber": 1,
"LineAmount": 3175,
"invoiceDistributions": []
}
]
},
{
"InvoiceNumber": "AP_RRF_CCU_I648",
"InvoiceAmount": 3200,
"invoiceInstallments": [
{
"UnpaidAmount": 3200,
"PaymentMethod": "Electronic"
}
],
"invoiceLines": [
{
"LineNumber": 1,
"LineAmount": 3200,
"invoiceDistributions": []
}
]
},
{
"InvoiceNumber": "AP_RRF_CCU_I650",
"InvoiceAmount": 3250,
"invoiceInstallments": [
{
"UnpaidAmount": 3250,
"PaymentMethod": "Electronic"
}
],
"invoiceLines": [
{
"LineNumber": 1,
"LineAmount": 3250,
"invoiceDistributions": []
}
]
},
{
"InvoiceNumber": "AP_RRF_CCU_I656",
"InvoiceAmount": 3400,
"invoiceInstallments": [
{
"UnpaidAmount": 3400,
"PaymentMethod": "Electronic"
}
],
"invoiceLines": [
{
"LineNumber": 1,
"LineAmount": 3400,
"invoiceDistributions": []
}
]
},
{
"InvoiceNumber": "AP_RRF_CCU_I657",
"InvoiceAmount": 3425,
"invoiceInstallments": [
{
"UnpaidAmount": 3425,
"PaymentMethod": "Electronic"
}
],
"invoiceLines": [
{
"LineNumber": 1,
"LineAmount": 3425,
"invoiceDistributions": []
}
]
},
{
"InvoiceNumber": "AP_RRF_CCU_I659",
"InvoiceAmount": 3475,
"invoiceInstallments": [
{
"UnpaidAmount": 3475,
"PaymentMethod": "Electronic"
}
],
"invoiceLines": [
{
"LineNumber": 1,
"LineAmount": 3475,
"invoiceDistributions": []
}
]
},
{
"InvoiceNumber": "AP_RRF_CCU_I666",
"InvoiceAmount": 3650,
"invoiceInstallments": [
{
"UnpaidAmount": 3650,
"PaymentMethod": "Electronic"
}
],
"invoiceLines": [
{
"LineNumber": 1,
"LineAmount": 3650,
"invoiceDistributions": []
}
]
},
{
"InvoiceNumber": "AP_RRF_CCU_I668",
"InvoiceAmount": 3700,
"invoiceInstallments": [
{
"UnpaidAmount": 3700,
"PaymentMethod": "Electronic"
}
],
"invoiceLines": [
{
"LineNumber": 1,
"LineAmount": 3700,
"invoiceDistributions": []
}
]
},
{
"InvoiceNumber": "AP_RRF_CCU_I675",
"InvoiceAmount": 3875,
"invoiceInstallments": [
{
"UnpaidAmount": 3875,
"PaymentMethod": "Electronic"
}
],
"invoiceLines": [
{
"LineNumber": 1,
"LineAmount": 3875,
"invoiceDistributions": []
}
]
}
],
"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"
},
{
"rel": "action",
"href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices/action/applyPrepayments",
"name": "applyPrepayments",
"kind": "other"
}
]
}