Search for All Customer Site Invoices and Installments

A user wants to search for invoices associated with transactions created for a customer account site to see if the invoices have been created correctly with the proper payment schedules and payment due dates.

Example URL

Here's an example of the resource URL to display data from the Receivables Customer Account Site Activities resource :

GET

fscmRestApi/resources/11.13.18.05/ receivablesCustomerAccountSiteActivities

cURL Command

curl --location --request GET "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/ receivablesCustomerAccountSiteActivities?finder=CustomerAccountSiteActivitiesFinder;BillToSiteNumber=10721&expand=transactionPaymentSchedules"

Supported media types:

• Content-Type: application/json

Example Response

Here's an example of the response body in JSON format:

{
  "items": [
    {
      "BillToSiteUseId": 100100148387733,
      "BillToSiteNumber": "PERF_SITE_BAT10_1017",
      "BillToSiteAddress": "PERF_ADDR_BAT10_1017",
      "AccountNumber": "PERF_ACCT_BAT10_1000",
      "AccountId": 100100148385906,
      "CustomerName": "PERF_CUST_BAT10_1000",
      "CustomerId": 100100148382061,
      "TaxRegistrationNumber": null,
      "TaxpayerIdentificationNumber": null,
      "TotalOpenReceivablesForSite": 10500,
      "TotalTransactionsDueForSite": 100500,
      "CreatedBy": "FUSION_APPS_CRM_SOA_APPID",
      "CreationDate": "2020-07-17T12:57:05.744+00:00",
      "LastUpdateDate": "2020-07-17T12:57:05.744+00:00",
      "LastUpdatedBy": "FUSION_APPS_CRM_SOA_APPID",
      "transactionPaymentSchedules": [
        {
          "InstallmentId": 1347786,
          "InstallmentNumber": 1,
          "TotalOriginalAmount": 1200,
          "TotalBalanceAmount": 1200,
          "PaymentDaysLate": 2324,
          "InstallmentStatus": "Open",
          "TransactionNumber": "P_DM_BAT10_02_1444",
          "TransactionId": 1583789,
          "TransactionDate": "2014-03-17",
          "TransactionClass": "Debit Memo",
          "PaymentScheduleDueDate": "2014-04-16",
          "AccountingDate": "2014-03-17",
          "PurchaseOrder": null,
          "TransactionType": "Debit Memo",
          "ReceiptMethod": null,
          "EnteredCurrency": "USD",
          "TransactionSourceName": "Trans_Source_AI_1_3",
          "StructuredPaymentReference": null,
          "CreatedBy": "AR_MGR_OPERATIONS",
          "CreationDate": "2020-07-20T06:58:20+00:00",
          "LastUpdateDate": "2020-07-20T06:58:23+00:00",
          "LastUpdatedBy": "AR_MGR_OPERATIONS",
          "links": [
            {
              "rel": "self",
              "href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesCustomerAccountSiteActivities/100100148387733/child/transactionPaymentSchedules/1347786",
              "name": "transactionPaymentSchedules",
              "kind": "item"
            },
            {
              "rel": "canonical",
              "href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesCustomerAccountSiteActivities/100100148387733/child/transactionPaymentSchedules/1347786",
              "name": "transactionPaymentSchedules",
              "kind": "item"
            },
            {
              "rel": "parent",
              "href": "https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/receivablesCustomerAccountSiteActivities/100100148387733",
              "name": "receivablesCustomerAccountSiteActivities",
              "kind": "item"
            }
          ]
        },
        {
          "InstallmentId": 1347787,
          "InstallmentNumber": 1,
          "TotalOriginalAmount": 1200,
          "TotalBalanceAmount": 1200,
          "PaymentDaysLate": 2324,
          "InstallmentStatus": "Open",
          "TransactionNumber": "P_DM_BAT10_02_1445",
          "TransactionId": 1583793,
          "TransactionDate": "2014-03-17",
          "TransactionClass": "Debit Memo",
          "PaymentScheduleDueDate": "2014-04-16",
          "AccountingDate": "2014-03-17",
          "PurchaseOrder": null,
          "TransactionType": "Debit Memo",
          "ReceiptMethod": null,
          "EnteredCurrency": "USD",
          "TransactionSourceName": "Trans_Source_AI_1_3",
          "StructuredPaymentReference": null,
          "CreatedBy": "AR_MGR_OPERATIONS",
          "CreationDate": "2020-07-20T06:58:20+00:00",
          "LastUpdateDate": "2020-07-20T06:58:23+00:00",
          "LastUpdatedBy": "AR_MGR_OPERATIONS",
        ...
        }
    ]
}