1. REST API for Oracle CX Sales and B2B ServiceREST API for Sales and Fusion Service in Oracle Fusion Cloud Customer Experience
  2. Industry Solutions
  3. Financial Services
  4. Daily Balance

Daily Balance

The Daily Balance resource is used to manage the daily closing balance of a financial account.

Resource Plural Label

Daily Balance

Resource Name

__ORAFS__DailyBalance_c

On this page:

Get all Daily Balances

Request: GET

URI: crmRestApi/resources/11.13.18.05/__ORAFS__DailyBalance_c

Request Path Parameters

There are no required path parameters for this task.

Request Query Parameters

Use the following finder parameters to query the resource:

Finder Name Description

Id

Finds Daily Balance records by ID.

Finder Variables:
  • PrimaryKey
    • Type: Integer
    • Description: The unique identifier of the Daily Balance record.

Request Body

There are no elements in the request body for this task.

Response Body

Returns an array of Daily Balance resources.

The following table summarizes the supported response body content types:

Media Type

application/json

Media Type

application/vnd.oracle.adf.resourcecollection+json

Example

Gets all Daily Balance records.

Example Command: curl --user sales_cloud_user https://servername.fa.us2.oraclecloud.com/crmRestApi/resources/11.13.18.05/_ORAFS__DailyBalance_c

Example Response Body

{
"Id" : 300000000888695,
"RowType" : "__ORAFS__DailyBalance_c",
"RecordName" : "123",
"CreatedBy" : "aic_1",
"CreationDate" : "2015-05-26T11.12.1.0:28:56+00:00",
"LastUpdatedBy" : "SALES.REP1_US@ap6023fems.us.oraclecloud.com",
"LastUpdateDate" : "2015-06-05T05:26:04+00:00",
"LastUpdateLogin" : null,
"CpdrfVerSor" : null,
"UserLastUpdateDate" : null,
"CpdrfLastUpd" : null,
"CpdrfVerPillar" : null,
"JobDefinitionPackage" : null,
"RequestId" : null,
"JobDefinitionName" : null,
"CurrencyCode" : "USD",
"CurcyConvRateType" : "Corporate",
"CorpCurrencyCode" : "USD",
"SourceType" : "__ORAFS__DAILYBALANCE_C",
"AttachmentEn
tityName" : "__ORAFS__DailyBalance_c",
"PKProxy" : "300000000888695",
"IsOwner" : "false",
"__ORAFS__FinancialAccount_Id_c" : 300000000888331,
"__ORAFS__FinancialAccount_c" : "2605201512",
"__ORAFS__ClosingBalance_c" : 13123,
"__ORAFS__ClosingDate_c" : "2015-11.12.1.0-11.12.1.0",
"FinancialSummary_Id___ORAFS__HistoricalAccountSummary" : 300000000907410,
"__ORAFS__Extn__ORAFS__DailyBalance_cFuseCreateLayoutURL" : "/cust/apps/__extension__/__ORAFS__DailyBalance_c/__ORAFS__DailyBalance_cFuseCreate/__ORAFS__DailyBalance_cFuseCreate_Layout2.jsff",
"__ORAFS__Extn__ORAFS__DailyBalance_cFuseCreateLayoutDrivers" : "null",
"__ORAFS__Extn__ORAFS__DailyBalance_cFuseDetailLayoutURL" : "/cust/apps/__extension__/__ORAFS__DailyBalance_c/__ORAFS__DailyBalance_cFuseDetail/__ORAFS__DailyBalance_cFuseDetail_Layout2.jsff",
"__ORAFS__Extn__ORAFS__DailyBalance_cFuseDetailLayoutDrivers" : "null",
"Extn__ORAFS__DailyBalance_cFuseCreateLayoutURL" : "/cust/apps/__extension__/__ORAFS__DailyBalance_c/__ORAFS__DailyBalance_cFuseCreate/__ORAFS__DailyBalance_cFuseCreate_Layout2.jsff",
"Extn__ORAFS__DailyBalance_cFuseCreateLayoutDrivers" : null,
"Extn__ORAFS__DailyBalance_cFuseDetailLayoutURL" : "/cust/apps/__extension__/__ORAFS__DailyBalance_c/__ORAFS__DailyBalance_cFuseDetail/__ORAFS__DailyBalance_cFuseDetail_Layout2.jsff",
"Extn__ORAFS__DailyBalance_cFuseDetailLayoutDrivers" : null,
"links" : [ {
...
}]
}

Create a Daily Balance

Request: POST

URI: crmRestApi/resources/11.13.18.05/__ORAFS__DailyBalance_c

Request Path Parameters

There are no required path parameters for this task.

Request Body

Accepts a Daily Balance item.

The following table summarizes the supported request body content types:

Media Type

application/vnd.oracle.adf.resourceitem+j son

Response Body

Returns a Daily Balance resource item.

The following table summarizes the supported response body content types:

Media Type

application/vnd.oracle.adf.resourcecollection+json

Example

Creates a new Daily Balance record.

Example Command: curl --user sales_cloud_user https://servername.fa.us2.oraclecloud.com/crmRestApi/resources/11.13.18.05/_ORAFS__DailyBalance_c

Get a Daily Balance

Request: GET

URI: crmRestApi/resources/11.13.18.05/__ORAFS__DailyBalance_c/< Replace with system generated unique ID>

Request Path Parameters

The following are the required path parameters for this task:

Name Type Description

Id

Integer

The unique identifier of the Daily Balance record.

Request Body

There are no elements in the request body for this task.

Response Body

Returns a Daily Balance resource item.

The following table summarizes the supported response body content types:

Media Type

application/json

Media Type

application/vnd.oracle.adf.resourceitem+json

Example

Gets a Daily Balance record.

Example Command: curl --user sales_cloud_user https://servername.fa.us2.oraclecloud.com/crmRestApi/resources/11.13.18.05/__ORAFS__DailyBalance_c/30000000089311.12.1.02

Update a Daily Balance

Request: PATCH

URI: crmRestApi/resources/11.13.18.05/__ORAFS__DailyBalance_c/< Replace with system generated unique ID>

Request Path Parameters

The following are the required path parameters for this task:

Name Type Description

Id

Integer

The unique identifier of the Daily Balance record.

Request Body

The following table summarizes the supported request body content types:

Media Type

application/vnd.oracle.adf.resourceitem+json

Response Body

Returns a Daily Balance resource item.

The following table summarizes the supported response body content types:

Media Type

application/vnd.oracle.adf.resourceitem+json

Example

Updates an existing Daily Balance record.

Example Command: curl --user sales_cloud_user https://servername.fa.us2.oraclecloud.com/crmRestApi/resources/11.13.18.05/__ORAFS__DailyBalance_c/30000000089311.12.1.02

Delete a Daily Balance

Request: DELETE

URI: crmRestApi/resources/11.13.18.05/__ORAFS__DailyBalance_c/< Replace with system generated unique ID>

Request Path Parameters

The following are the required path parameters for this task:

Name Type Description

Id

Integer

The unique identifier of the Daily Balance record.

Request Body

There are no elements in the request body for this task.

Response Body

There are no elements in the response body for this task.

Example

Deletes an existing Daily Balance record.

Example Command: curl --user sales_cloud_user https://servername.fa.us2.oraclecloud.com/crmRestApi/resources/11.13.18.05/__ORAFS__DailyBalance_c/30000000089311.12.1.02

List of Values

This resource defines the following list of values (LOV):

LOV Name Source Attribute in LOV Target Attribute in Resource

ViewAccessor_CurrencyCode

CurrencyCode

Currency Code

FK_LOVVA_For___ORAFS__FinancialAccount_c

_ORAFS__FinancialAccount_Id_c

Financial Account

LOVVA_For___ORAFS__FinancialAccount_c

__ORAFS__FinancialAccount_c

Financial Account

Resource Attributes

This resource has the following attributes:

Attribute Name Attribute Type Description

Id

integer

The unique identifier of the Daily Balance record.

UI Label

Record ID

RowType

string

The name of the Daily Balance object. In this case __ORAFS__DailyBalance_c.

Properties

The maximum length is 80.

RecordName

string

An autogenerated unique identifier for the Daily Balance record.

Properties

The maximum length is 80.

UI Label

Daily Balance #

CreatedBy

string

The user who created the Daily Balance record.

Properties

The maximum length is 32.

UI Label

Created By

CreationDate

string

The date and time when the Daily Balance record was created.

UI Label

Creation Date

LastUpdatedBy

string

The user who last updated the Daily Balance record.

Properties

The maximum length is 32.

UI Label

Last Updated By

LastUpdateDate

string

The date and time when the Daily Balance record was last updated.

UI Label

Last Update Date

CurrencyCode

string

The currency code associated with the Daily Balance record.

Properties

The maximum length is 15.

UI Label

Currency Code

__ORAFS__FinancialAccount_Id_c

integer

The unique identifier of the financial account for which the Daily Balance information is entered.

UI Label

Financial Account

__ORAFS__FinancialAccount_c

string

The financial account for which the Daily Balance information is entered.

Properties

The maximum length is 1500.

UI Label

Financial Account

__ORAFS__ClosingBalance_c

number

The closing balance of the financial account.

UI Label

Closing Balance

__ORAFS__ClosingDate_c

string

The date for which the closing balance information is entered.

UI Label

Closing Date