POST 17.0/database/bankaccountbalances/list

Description

Retrieve a list of Bank Account Balances

URI Parameters

None.

ListOptions
Name Description Type Additional information
Fields

Collection of string

None.
Filters

Collection of DatabaseFilter

None.
Order

string

None.

application/json, text/json
Sample: 
{
  "fields": [
    "sample string 1",
    "sample string 2"
  ],
  "filters": [
    {
      "fieldName": "sample string 1",
      "value": "sample string 2",
      "operator": "sample string 3",
      "valueType": "sample string 4"
    },
    {
      "fieldName": "sample string 1",
      "value": "sample string 2",
      "operator": "sample string 3",
      "valueType": "sample string 4"
    }
  ],
  "order": "sample string 1"
}

application/xml, text/xml
Sample: 
<ListOptions xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
  <Fields>
    <string>sample string 1</string>
    <string>sample string 2</string>
  </Fields>
  <Filters>
    <DatabaseFilter>
      <FieldName>sample string 1</FieldName>
      <Value>sample string 2</Value>
      <Operator>sample string 3</Operator>
      <ValueType>sample string 4</ValueType>
    </DatabaseFilter>
    <DatabaseFilter>
      <FieldName>sample string 1</FieldName>
      <Value>sample string 2</Value>
      <Operator>sample string 3</Operator>
      <ValueType>sample string 4</ValueType>
    </DatabaseFilter>
  </Filters>
  <Order>sample string 1</Order>
</ListOptions>

application/x-www-form-urlencoded
Sample:

Sample not available.

Collection of BankAccountBalancesUpdate
Name Description Type Additional information
ID

integer

None.
BankAccountID

integer

None.
RunDate

date

None.
ClearedFundsHeld

decimal number

None.
UnclearedFundsHels

decimal number

None.
FeesToTransfer

decimal number

None.
DepositsToTransfer

decimal number

None.
OverseasTaxToTransfer

decimal number

None.
Expenses

decimal number

None.
SuspenseAccount

decimal number

None.
AccountBalance

decimal number

None.
Variance

decimal number

None.
AddedDate

date

None.
UserID

integer

None.

application/json, text/json
Sample: 
[
  {
    "id": 1,
    "bankAccountID": 1,
    "runDate": "2025-01-09T20:19",
    "clearedFundsHeld": 1.0,
    "unclearedFundsHels": 1.0,
    "feesToTransfer": 1.0,
    "depositsToTransfer": 1.0,
    "overseasTaxToTransfer": 1.0,
    "expenses": 1.0,
    "suspenseAccount": 1.0,
    "accountBalance": 1.0,
    "variance": 1.0,
    "addedDate": "2025-01-09T20:19",
    "userID": 1
  },
  {
    "id": 1,
    "bankAccountID": 1,
    "runDate": "2025-01-09T20:19",
    "clearedFundsHeld": 1.0,
    "unclearedFundsHels": 1.0,
    "feesToTransfer": 1.0,
    "depositsToTransfer": 1.0,
    "overseasTaxToTransfer": 1.0,
    "expenses": 1.0,
    "suspenseAccount": 1.0,
    "accountBalance": 1.0,
    "variance": 1.0,
    "addedDate": "2025-01-09T20:19",
    "userID": 1
  }
]

application/xml, text/xml
Sample: 
<ArrayOfBankAccountBalancesUpdate xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
  <BankAccountBalancesUpdate>
    <ID>1</ID>
    <BankAccountID>1</BankAccountID>
    <RunDate>2025-01-09T20:19:26.2828332+00:00</RunDate>
    <ClearedFundsHeld>1</ClearedFundsHeld>
    <UnclearedFundsHels>1</UnclearedFundsHels>
    <FeesToTransfer>1</FeesToTransfer>
    <DepositsToTransfer>1</DepositsToTransfer>
    <OverseasTaxToTransfer>1</OverseasTaxToTransfer>
    <Expenses>1</Expenses>
    <SuspenseAccount>1</SuspenseAccount>
    <AccountBalance>1</AccountBalance>
    <Variance>1</Variance>
    <AddedDate>2025-01-09T20:19:26.2828332+00:00</AddedDate>
    <UserID>1</UserID>
  </BankAccountBalancesUpdate>
  <BankAccountBalancesUpdate>
    <ID>1</ID>
    <BankAccountID>1</BankAccountID>
    <RunDate>2025-01-09T20:19:26.2828332+00:00</RunDate>
    <ClearedFundsHeld>1</ClearedFundsHeld>
    <UnclearedFundsHels>1</UnclearedFundsHels>
    <FeesToTransfer>1</FeesToTransfer>
    <DepositsToTransfer>1</DepositsToTransfer>
    <OverseasTaxToTransfer>1</OverseasTaxToTransfer>
    <Expenses>1</Expenses>
    <SuspenseAccount>1</SuspenseAccount>
    <AccountBalance>1</AccountBalance>
    <Variance>1</Variance>
    <AddedDate>2025-01-09T20:19:26.2828332+00:00</AddedDate>
    <UserID>1</UserID>
  </BankAccountBalancesUpdate>
</ArrayOfBankAccountBalancesUpdate>