Stitch’s Mambu integration replicates data using the Mambu v2.0 and v1.0 APIs. Refer to the Schema section for a list of objects available for replication.
Mambu feature snapshot
A high-level look at Stitch's Mambu (v1) integration, including release status, useful links, and the features supported in Stitch.
Indicates if Replication Methods can be defined by you for tables in the integration.
Configurable Replication Methods are not supported for this integration. Stitch will use pre-defined replication methods for tables you set to replicate.
Unsupported
DATA SELECTION
Table selection
The ability to select individual tables for replication in the Stitch interface. If table selection is unavailable, all tables and all the columns they contain will be set to replicate by default.
This feature is supported for this version of the integration.
Supported
Column selection
The ability to select individual columns for replication in the Stitch interface. If column selection is unavailable, all columns will be set to replicate by default.
This feature is supported for this version of the integration.
Supported
Select all
Indicates if the integration supports selecting all available tables and columns.
Reports detailing the Loading phase of the replication process for a given integration. Includes the number of rows loaded for each table and error info, should an error occur.
This feature is supported for this version of the integration.
Supported
Connecting Mambu
Mambu setup requirements
To set up Mambu in Stitch, you need:
A Mambu account with API access. The Mambu integration requires an account login with API access. In Mambu’s app, API access can be granted to any existing user.
On the Stitch Dashboard page, click the Add Integration button.
Click the Mambu icon.
Enter a name for the integration. This is the name that will display on the Stitch Dashboard for the integration; it’ll also be used to create the schema in your destination.
For example, the name “Stitch Mambu” would create a schema called stitch_mambu in the destination. Note: Schema names cannot be changed after you save the integration.
In the Subdomain field, enter your Mambu subdomain. For example: If the subdomain were stitch.mambu.com, only stitch would be entered into this field.
In the Username and Password fields, enter the username and password of the Mambu user with Mambu API access.
Step 2: Define the historical replication start date
The Sync Historical Data setting defines the starting date for your Mambu integration.
This means that data equal to or newer than this date will be replicated to your data warehouse.
Change this setting if you want to replicate data beyond Mambu’s default setting of 1 year. For a detailed look at historical replication jobs, check out the Syncing Historical SaaS Data guide.
Step 3: Create a replication schedule
Information note
Replication schedules affect the time Extraction begins, not the time to data loaded. Refer to the Replication Scheduling documentation for more information.
In the Replication Frequency section, you’ll create the integration’s replication schedule. An integration’s replication schedule determines how often Stitch runs a replication job, and the time that job begins.
Mambu integrations support the following replication scheduling methods:
Note: If a replication job is currently in progress, new selections won’t be used until the next job starts.
For Mambu integrations, you can select:
Individual tables and columns
All tables and columns
Click the tabs to view instructions for each selection method.
In the integration’s Tables to Replicate tab, locate a table you want to replicate.
To track a table, click the checkbox next to the table’s name. A blue checkmark means the table is set to replicate.
To track a column, click the checkbox next to the column’s name. A blue checkmark means the column is set to replicate.
Repeat this process for all the tables and columns you want to replicate.
When finished, click the Finalize Your Selections button at the bottom of the screen to save your selections.
Information noteImportant:
Using the Select All feature will overwrite any previous selections. However, selections aren’t final until Finalize Your Selections is clicked. Clicking Cancel will restore your previous selections.
Refer to the Select All guide for more info about this feature.
Click into the integration from the Stitch Dashboard page.
Click the Tables to Replicate tab.
In the list of tables, click the box next to the Table Names column.
In the menu that displays, click Track all Tables and Fields:
The Track all Tables and Fields menu in the Tables to Replicate tab
Click the Finalize Your Selections button at the bottom of the page to save your data selections.
Initial and historical replication jobs
After you finish setting up Mambu, its Sync Status may show as Pending on either the Stitch Dashboard or in the Integration Details page.
For a new integration, a Pending status indicates that Stitch is in the process of scheduling the initial replication job for the integration. This may take some time to complete.
Information note
Initial replication jobs with Anchor Scheduling
If using Anchor Scheduling, an initial replication job may not kick off immediately. This depends on the selected Replication Frequency and Anchor Time. Refer to the Anchor Scheduling documentation for more information.
Free historical data loads
The first seven days of replication, beginning when data is first replicated, are free. Rows replicated from the new integration during this time won’t count towards your quota. Stitch offers this as a way of testing new integrations, measuring usage, and ensuring historical data volumes don’t quickly consume your quota.
Information noteReplication will continue after the seven days are over. If you’re no longer interested in this source, be sure to pause or delete the integration to prevent unwanted usage.
Mambu table reference
Information note
Schemas and versioning
Schemas and naming conventions can change from version to version, so we recommend verifying your integration’s version before continuing.
The schema and info displayed below is for version 1 of this integration.
Information note
Table and column names in your destination
Depending on your destination, table and column names may not appear as they are outlined below.
For example: Object names are lowercased in Redshift (CusTomERs > customers), while case is maintained in PostgreSQL destinations (CusTomERs > CusTomERs). Refer to the Loading Guide for your destination for more info.
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
city
STRING
country
STRING
encoded_key
STRING
index_in_list
INTEGER
latitude
NUMBER
line1
STRING
line2
STRING
longitude
NUMBER
parent_key
STRING
postcode
STRING
region
STRING
branch_holidays
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
creation_date
DATE-TIME
date
DATE
encoded_key
STRING
is_anually_recurring
BOOLEAN
name
STRING
creation_date
DATE-TIME
custom_field_sets
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
custom_field_set_id
STRING
custom_field_values
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
custom_field_id
STRING
custom_field_value
STRING
email_address
STRING
encoded_key
STRING
id
STRING
last_modified_date
DATE-TIME
name
STRING
notes
STRING
phone_number
STRING
state
STRING
cards
This table contains information about cards.
Note: In order to replicate this table, you must also set the deposit_account table to replicate.
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
city
STRING
country
STRING
encoded_key
STRING
index_in_list
INTEGER
latitude
NUMBER
line1
STRING
line2
STRING
longitude
NUMBER
parent_key
STRING
postcode
STRING
region
STRING
assigned_branch_key
STRING
creation_date
DATE-TIME
custom_field_sets
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
custom_field_set_id
STRING
custom_field_values
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
city
STRING
country
STRING
encoded_key
STRING
index_in_list
INTEGER
latitude
NUMBER
line1
STRING
line2
STRING
longitude
NUMBER
parent_key
STRING
postcode
STRING
region
STRING
approved_date
DATE-TIME
assigned_centre_key
STRING
assigned_user_key
STRING
birth_date
DATE
client_role_key
STRING
closed_date
DATE-TIME
creation_date
DATE-TIME
custom_field_sets
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
custom_field_set_id
STRING
custom_field_values
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
custom_field_id
STRING
custom_field_value
STRING
email_address
STRING
encoded_key
STRING
first_name
STRING
gender
STRING
group_loan_cycle
INTEGER
home_phone
STRING
id
STRING
id_documents
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
client_key
STRING
document_id
STRING
document_type
STRING
encoded_key
STRING
identification_document_template_key
STRING
index_in_list
INTEGER
issuing_authority
STRING
valid_until
DATE
last_modified_date
DATE-TIME
last_name
STRING
middle_name
STRING
migration_event_key
STRING
mobile_phone
STRING
notes
STRING
preferred_language
STRING
profile_picture_key
STRING
profile_signature_key
STRING
state
STRING
communications
This table contains information about communications.
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
custom_field_set_id
STRING
custom_field_values
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
custom_field_id
STRING
custom_field_value
STRING
deposit_account_key
STRING
destination
STRING
encoded_key
STRING
event
STRING
failure_cause
STRING
failure_reason
STRING
group_key
STRING
loan_account_key
STRING
num_retries
INTEGER
reference_id
STRING
repayment_key
STRING
send_date
DATE-TIME
sender_key
STRING
state
STRING
subject
STRING
template_key
STRING
type
STRING
user_key
STRING
credit_arrangements
This table contains information about credit arrangements.
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
custom_field_set_id
STRING
custom_field_values
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
custom_field_id
STRING
custom_field_value
STRING
encoded_key
STRING
expire_date
DATE-TIME
holder_key
STRING
holder_type
STRING
id
STRING
last_modified_date
DATE-TIME
notes
STRING
start_date
DATE-TIME
state
STRING
sub_state
STRING
custom_field_sets
This table contains information about custom field sets.
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
amounts
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
custom_field_product_settings
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
custom_field_encoded_key
STRING
encoded_key
STRING
is_default
BOOLEAN
is_required
BOOLEAN
link_type
STRING
product_key
STRING
custom_field_selection_options
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
encoded_key
STRING
is_default
BOOLEAN
score
STRING
value
STRING
data_type
STRING
edit_rights
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
encoded_key
STRING
is_accessible_by_all_users
BOOLEAN
roles
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
encoded_key
STRING
id
STRING
index_in_list
INTEGER
is_default
BOOLEAN
is_required
BOOLEAN
name
STRING
state
STRING
type
STRING
unique
BOOLEAN
value_length
STRING
values
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
view_rights
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
encoded_key
STRING
is_accessible_by_all_users
BOOLEAN
roles
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
encoded_key
STRING
id
STRING
index_in_list
INTEGER
last_modified_date
DATE-TIME
name
STRING
notes
STRING
type
STRING
usage
STRING
deposit_accounts
This table contains information about deposit accounts.
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
interest_accrued
NUMBER
overdraft_interest_accrued
NUMBER
technical_overdraft_interest_accrued
NUMBER
activation_date
DATE-TIME
approved_date
DATE-TIME
assigned_branch_key
STRING
assigned_centre_key
STRING
assigned_user_key
STRING
balances
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
available_balance
NUMBER
fees_due
NUMBER
hold_balance
NUMBER
locked_balance
NUMBER
overdraft_amount
NUMBER
overdraft_interest_due
NUMBER
technical_overdraft_amount
NUMBER
technical_overdraft_interest_due
NUMBER
total_balance
NUMBER
closed_date
DATE-TIME
creation_date
DATE-TIME
credit_arrangement_key
STRING
currency_code
STRING
custom_field_sets
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
custom_field_set_id
STRING
custom_field_values
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
custom_field_id
STRING
custom_field_value
STRING
encoded_key
STRING
id
STRING
interest_settings
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
interest_payment_settings
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
interest_payment_dates
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
day
INTEGER
month
INTEGER
interest_payment_point
STRING
interest_rate_settings
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
encoded_key
STRING
interest_charge_frequency
STRING
interest_charge_frequency_count
INTEGER
interest_rate
NUMBER
interest_rate_terms
STRING
interest_rate_tiers
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
encoded_key
STRING
ending_balance
NUMBER
ending_day
INTEGER
interest_rate
NUMBER
internal_controls
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
max_withdrawal_amount
NUMBER
recommended_deposit_amount
NUMBER
target_amount
NUMBER
last_account_appraisal_date
DATE-TIME
last_interest_calculation_date
DATE-TIME
last_interest_stored_date
DATE-TIME
last_modified_date
DATE-TIME
last_overdraft_interest_review_date
DATE-TIME
last_sent_to_arrears_date
DATE-TIME
linked_settlement_account_keys
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
locked_date
DATE-TIME
maturity_date
DATE-TIME
migration_event_key
STRING
name
STRING
notes
STRING
overdraft_interest_settings
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
interest_rate_settings
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
encoded_key
STRING
interest_charge_frequency
STRING
interest_charge_frequency_count
INTEGER
interest_rate
NUMBER
interest_rate_review_count
INTEGER
interest_rate_review_unit
STRING
interest_rate_source
STRING
interest_rate_terms
STRING
interest_rate_tiers
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
encoded_key
STRING
ending_balance
NUMBER
ending_day
INTEGER
interest_rate
NUMBER
interest_spread
NUMBER
overdraft_settings
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
allowed_overdraft
BOOLEAN
overdraft_expiry_date
DATE-TIME
overdraft_limit
NUMBER
product_type_key
STRING
withholding_tax_source_key
STRING
deposit_products
This table contains information about deposit (savings) products.
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
branch_key
STRING
encoded_key
STRING
collect_interest_when_locked
BOOLEAN
creation_date
DATE-TIME
currencies
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
code
STRING
creation_date
DATE-TIME
currency_symbol_position
STRING
digits_after_decimal
INTEGER
is_base_currency
BOOLEAN
last_modified_date
DATE-TIME
name
STRING
symbol
STRING
custom_field_values
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
amount
STRING
custom_field
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
amounts
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
custom_field_selection_options
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
encoded_key
STRING
score
STRING
value
STRING
custom_field_set
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
creation_date
DATE-TIME
encoded_key
STRING
id
STRING
index_in_list
INTEGER
last_modified_date
DATE-TIME
name
STRING
type
STRING
usage
STRING
data_type
STRING
edit_rights
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
encoded_key
STRING
is_accessible_by_all_users
BOOLEAN
roles
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
encoded_key
STRING
id
STRING
index_in_list
INTEGER
is_default
BOOLEAN
is_required
BOOLEAN
name
STRING
state
STRING
type
STRING
unique
BOOLEAN
value_length
STRING
values
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
view_rights
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
encoded_key
STRING
is_accessible_by_all_users
BOOLEAN
roles
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
custom_field_id
STRING
custom_field_key
STRING
custom_field_set_group_index
INTEGER
encoded_key
STRING
index_in_list
INTEGER
parent_key
STRING
value
STRING
description
STRING
encoded_key
STRING
for_all_branches
BOOLEAN
for_groups
BOOLEAN
for_individuals
BOOLEAN
id
STRING
id_generator_type
STRING
id_pattern
STRING
interest_accrued_accounting_method
STRING
interest_calculation_balance
STRING
interest_days_in_year
STRING
interest_paid_into_account
BOOLEAN
interest_payment_point
STRING
interest_rate_settings
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
accrue_interest_after_maturity
BOOLEAN
encoded_key
STRING
interest_charge_frequency
STRING
interest_charge_frequency_count
INTEGER
interest_rate_source
STRING
interest_rate_terms
STRING
interest_rate_tiers
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
encoded_key
STRING
ending_balance
NUMBER
ending_day
INTEGER
interest_rate
NUMBER
last_modified_date
DATE-TIME
line_of_credit_requirement
STRING
maturity_period_limit
STRING
max_overdraft_limit
STRING
min_opening_balance
STRING
name
STRING
overdraft_days_in_year
STRING
overdraft_interest_rate_settings
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
accrue_interest_after_maturity
BOOLEAN
encoded_key
STRING
interest_charge_frequency
STRING
interest_charge_frequency_count
INTEGER
interest_rate_source
STRING
interest_rate_terms
STRING
interest_rate_tiers
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
encoded_key
STRING
ending_balance
NUMBER
ending_day
INTEGER
interest_rate
NUMBER
product_type
STRING
savings_fees
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
active
BOOLEAN
amortization_profile
STRING
amount
STRING
amount_calculation_method
STRING
creation_date
DATE-TIME
encoded_key
STRING
fee_amortization_upon_reschedule_option
STRING
fee_application
STRING
fee_product_rules
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
name
STRING
trigger
STRING
savings_product_rules
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
templates
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
creation_date
DATE-TIME
encoded_key
STRING
last_modified_date
DATE-TIME
name
STRING
type
STRING
withholding_tax_enabled
BOOLEAN
deposit_transactions
This table contains information about deposit transactions.
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
total_balance
NUMBER
adjustment_transaction_key
STRING
affected_amounts
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
fees_amount
NUMBER
fraction_amount
NUMBER
funds_amount
NUMBER
interest_amount
NUMBER
overdraft_amount
NUMBER
overdraft_fees_amount
NUMBER
overdraft_interest_amount
NUMBER
technical_overdraft_amount
NUMBER
technical_overdraft_interest_amount
NUMBER
amount
NUMBER
booking_date
DATE-TIME
branch_key
STRING
card_transaction
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
advice
BOOLEAN
amount
NUMBER
card_acceptor
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
city
STRING
country
STRING
mcc
INTEGER
name
STRING
state
STRING
zip
STRING
card_token
STRING
currency_code
STRING
encoded_key
STRING
external_authorization_reference_id
STRING
external_reference_id
STRING
user_transaction_time
STRING
centre_key
STRING
creation_date
DATE-TIME
currency_code
STRING
custom_field_sets
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
custom_field_set_id
STRING
custom_field_values
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
custom_field_id
STRING
custom_field_value
STRING
encoded_key
STRING
external_id
STRING
fees
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
amount
NUMBER
name
STRING
predefined_fee_key
STRING
tax_amount
NUMBER
trigger
STRING
id
STRING
linked_loan_transaction_key
STRING
migration_event_key
STRING
notes
STRING
original_transaction_key
STRING
parent_account_key
STRING
taxes
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
tax_rate
NUMBER
terms
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
interest_settings
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
interest_rate
NUMBER
overdraft_interest_settings
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
index_interest_rate
NUMBER
interest_rate
NUMBER
overdraft_settings
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
overdraft_limit
NUMBER
till_key
STRING
transaction_details
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
transaction_channel_id
STRING
transaction_channel_key
STRING
transfer_details
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
linked_deposit_transaction_key
STRING
linked_loan_transaction_key
STRING
type
STRING
user_key
STRING
value_date
DATE-TIME
gl_accounts
This table contains information about general ledger accounts.
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
code
STRING
currency_symbol_position
STRING
digits_after_decimal
INTEGER
is_base_currency
BOOLEAN
last_modified_date
DATE-TIME
name
STRING
symbol
STRING
encoded_key
STRING
entry_id
STRING
gl_code
STRING
last_modified_date
DATE-TIME
name
STRING
strip_trailing_zeros
BOOLEAN
type
STRING
usage
STRING
gl_journal_entries
This table contains information about general ledger entries.
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
activated
BOOLEAN
allow_manual_journal_entries
BOOLEAN
balance
NUMBER
creation_date
DATE-TIME
currency
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
city
STRING
country
STRING
encoded_key
STRING
index_in_list
INTEGER
latitude
NUMBER
line1
STRING
line2
STRING
longitude
NUMBER
parent_key
STRING
postcode
STRING
region
STRING
assigned_branch_key
STRING
assigned_centre_key
STRING
assigned_user_key
STRING
creation_date
DATE-TIME
custom_field_sets
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
custom_field_set_id
STRING
custom_field_values
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
custom_field_id
STRING
custom_field_value
STRING
email_address
STRING
encoded_key
STRING
group_members
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
client_key
STRING
roles
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
encoded_key
STRING
group_role_name_key
STRING
role_name
STRING
group_name
STRING
group_role_key
STRING
home_phone
STRING
id
STRING
last_modified_date
DATE-TIME
loan_cycle
STRING
migration_event_key
STRING
mobile_phone
STRING
notes
STRING
preferred_language
STRING
index_rate_sources
This table contains information about index rate sources.
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
amount
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
due
NUMBER
expected
NUMBER
paid
NUMBER
tax
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
due
NUMBER
expected
NUMBER
paid
NUMBER
interest
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
amount
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
due
NUMBER
expected
NUMBER
paid
NUMBER
tax
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
due
NUMBER
expected
NUMBER
paid
NUMBER
last_paid_date
DATE-TIME
number
STRING
penalty
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
amount
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
due
NUMBER
expected
NUMBER
paid
NUMBER
tax
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
due
NUMBER
expected
NUMBER
paid
NUMBER
principal
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
amount
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
due
NUMBER
expected
NUMBER
paid
NUMBER
repaid_date
DATE-TIME
state
STRING
loan_accounts
This table contains information about Loan Accounts.
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
date_calculation_method
STRING
encoded_key
STRING
monthly_tolerance_day
INTEGER
non_working_days_method
STRING
tolerance_calculation_method
STRING
tolerance_period
INTEGER
account_holder_key
STRING
account_holder_type
STRING
account_state
STRING
account_sub_state
STRING
accrued_interest
NUMBER
accrued_penalty
NUMBER
activation_transaction_key
STRING
allow_offset
BOOLEAN
approved_date
DATE-TIME
arrears_tolerance_period
INTEGER
assets
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
amount
NUMBER
asset_name
STRING
deposit_account_key
STRING
encoded_key
STRING
guarantor_key
STRING
guarantor_type
STRING
assigned_branch_key
STRING
assigned_centre_key
STRING
assigned_user_key
STRING
balances
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
fees_balance
NUMBER
fees_due
NUMBER
fees_paid
NUMBER
interest_balance
NUMBER
interest_due
NUMBER
interest_from_arrears_balance
NUMBER
interest_from_arrears_due
NUMBER
interest_from_arrears_paid
NUMBER
interest_paid
NUMBER
penalty_balance
NUMBER
penalty_due
NUMBER
penalty_paid
NUMBER
principal_balance
NUMBER
principal_due
NUMBER
principal_paid
NUMBER
redraw_balance
NUMBER
closed_date
DATE-TIME
creation_date
DATE-TIME
credit_arrangement_key
STRING
custom_field_sets
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
custom_field_set_id
STRING
custom_field_values
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
custom_field_id
STRING
custom_field_value
STRING
days_in_arrears
INTEGER
days_late
INTEGER
disbursement_details
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
disbursement_date
DATE-TIME
encoded_key
STRING
expected_disbursement_date
DATE-TIME
fees
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
amount
NUMBER
encoded_key
STRING
predefined_fee_encoded_key
STRING
first_repayment_date
DATE-TIME
transaction_details
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
encoded_key
STRING
internal_transfer
BOOLEAN
target_deposit_account_key
STRING
transaction_channel_id
STRING
transaction_channel_key
STRING
encoded_key
STRING
funding_sources
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
amount
NUMBER
asset_name
STRING
deposit_account_key
STRING
encoded_key
STRING
guarantor_key
STRING
guarantor_type
STRING
id
STRING
interest_commission
NUMBER
share_percentage
NUMBER
future_payments_acceptance
STRING
guarantors
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
amount
NUMBER
asset_name
STRING
deposit_account_key
STRING
encoded_key
STRING
guarantor_key
STRING
guarantor_type
STRING
id
STRING
interest_commission
NUMBER
interest_from_arrears_accrued
NUMBER
interest_settings
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
accrue_interest_after_maturity
BOOLEAN
interest_application_method
STRING
interest_balance_calculation_method
STRING
interest_calculation_method
STRING
interest_charge_frequency
STRING
interest_rate
NUMBER
interest_rate_review_count
INTEGER
interest_rate_review_unit
STRING
interest_rate_source
STRING
interest_spread
NUMBER
interest_type
STRING
last_appraisal_date
DATE-TIME
last_interest_applied_date
DATE-TIME
last_interest_review_date
DATE-TIME
last_locked_date
DATE-TIME
last_modified_date
DATE-TIME
last_set_to_arrears_date
DATE-TIME
last_tax_rate_review_date
DATE-TIME
late_payments_recalculation_method
STRING
loan_amount
NUMBER
loan_name
STRING
locked_operations
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
migration_event_key
STRING
notes
STRING
payment_method
STRING
penalty_settings
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
loan_penalty_calculation_method
STRING
penalty_rate
NUMBER
prepayment_settings
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
apply_interest_on_prepayment_method
STRING
elements_recalculation_method
STRING
prepayment_recalculation_method
STRING
principal-paid_installment_status
STRING
principal_payment_settings
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
amount
NUMBER
encoded_key
STRING
include_fees_in_floor_amount
BOOLEAN
include_interest_in_floor_amount
BOOLEAN
percentage
NUMBER
principal_ceiling_value
NUMBER
principal_floor_value
NUMBER
principal_payment_method
STRING
total_due_amount_floor
NUMBER
total_due_payment
STRING
product_type_key
STRING
rescheduled_account_key
STRING
schedule_settings
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
default_first_repayment_due_date_offset
INTEGER
fixed_days_of_month
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
grace_period
INTEGER
grace_period_type
STRING
has_custom_schedule
BOOLEAN
payment_plan
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
amount
NUMBER
encoded_key
STRING
to_installment
INTEGER
periodic_payment
NUMBER
principal_repayment_interval
INTEGER
repayment_installments
INTEGER
repayment_period_count
INTEGER
repayment_period_unit
STRING
repayment_schedule_method
STRING
schedule_due_dates_method
STRING
short_month_handling_method
STRING
settlement_account_key
STRING
tax_rate
NUMBER
tranches
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
amount
NUMBER
disbursement_details
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
disbursement_transaction_key
STRING
expected_disbursement_date
DATE-TIME
encoded_key
STRING
tranch_number
STRING
loan_products
This table contains information about loan products.
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
amount
STRING
custom_field
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
amounts
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
custom_field_selection_options
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
encoded_key
STRING
score
STRING
value
STRING
custom_field_set
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
creation_date
DATE-TIME
encoded_key
STRING
id
STRING
index_in_list
INTEGER
last_modified_date
DATE-TIME
name
STRING
type
STRING
usage
STRING
data_type
STRING
edit_rights
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
encoded_key
STRING
is_accessible_by_all_users
BOOLEAN
roles
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
encoded_key
STRING
id
STRING
index_in_list
INTEGER
is_default
BOOLEAN
is_required
BOOLEAN
name
STRING
state
STRING
type
STRING
unique
BOOLEAN
value_length
STRING
values
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
view_rights
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
encoded_key
STRING
is_accessible_by_all_users
BOOLEAN
roles
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
custom_field_id
STRING
custom_field_key
STRING
custom_field_set_group_index
INTEGER
encoded_key
STRING
index_in_list
INTEGER
parent_key
STRING
value
STRING
days_in_year
STRING
declining_balance_prepayment_recalculation
STRING
default_loan_amount
STRING
default_num_installments
INTEGER
default_principal_repayment_interval
INTEGER
default_repayment_period_count
INTEGER
encoded_key
STRING
for_hybrid_groups
BOOLEAN
for_individuals
BOOLEAN
for_pure_groups
BOOLEAN
future_payments_acceptance
STRING
grace_period_type
STRING
id
STRING
id_generator_type
STRING
id_pattern
STRING
interest_accrued_accounting_method
STRING
interest_application_method
STRING
interest_balance_calculation_method
STRING
interest_calculation_method
STRING
interest_charge_frequency
STRING
interest_rate_settings
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
default_interest_rate
STRING
encoded_key
STRING
interest_charge_frequency
STRING
interest_charge_frequency_count
INTEGER
interest_rate_source
STRING
interest_rate_terms
STRING
is_investor_funds_enabled
BOOLEAN
last_modified_date
DATE-TIME
late_payments_recalculation_method
STRING
line_of_credit_requirement
STRING
loan_fees
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
active
BOOLEAN
amoritization_profile
STRING
amortization_interval_settings
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
encoded_key
STRING
frequency
STRING
interval_count
INTEGER
period_count
INTEGER
period_unit
STRING
amount
STRING
amount_calculation_method
STRING
creation_date
DATE-TIME
encoded_key
STRING
fee_application
STRING
fee_product_rules
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
name
STRING
trigger
STRING
loan_penalty_calculation_method
STRING
loan_product_rules
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
loan_product_type
STRING
loan_type
STRING
max_number_of_disbursement_tranches
INTEGER
payment_method
STRING
prepayment_acceptance
STRING
product_description
STRING
product_name
STRING
product_security_settings
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
encoded_key
STRING
is_collateral_enabled
BOOLEAN
is_guarantors_enabled
BOOLEAN
is_investor_funds_enabled
BOOLEAN
required_guaranties
STRING
repayment_allocation_order
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
repayment_currency_rounding
STRING
repayment_elements_rounding_method
STRING
repayment_period_unit
STRING
repayment_rescheduling_method
STRING
repayment_schedule_edit_options
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
repayment_schedule_method
STRING
required_guaranty_percentage
STRING
rounding_repayment_schedule_method
STRING
schedule_due_dates_method
STRING
schedule_interest_days_count_method
STRING
settlement_options
STRING
taxes_on_fees_enabled
BOOLEAN
taxes_on_interest_enabled
BOOLEAN
taxes_on_penalty_enabled
BOOLEAN
templates
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
creation_date
DATE-TIME
encoded_key
STRING
last_modified_date
DATE-TIME
name
STRING
type
STRING
loan_repayments
This is a child table of loan_accounts, containing information exclusively about loan repayments.
Note: In order to replicate this table, you must also set the loan_account table to replicate.
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
advance_position
NUMBER
arrears_position
NUMBER
expected_principal_redraw
NUMBER
principal_balance
NUMBER
redraw_balance
NUMBER
total_balance
NUMBER
adjustment_transaction_key
STRING
affected_amounts
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
fees_amount
NUMBER
fraction_amount
NUMBER
funds_amount
NUMBER
interest_amount
NUMBER
overdraft_amount
NUMBER
overdraft_fees_amount
NUMBER
overdraft_interest_amount
NUMBER
technical_overdraft_amount
NUMBER
technical_overdraft_interest_amount
NUMBER
amount
NUMBER
booking_date
DATE-TIME
branch_key
STRING
centre_key
STRING
creation_date
DATE-TIME
custom_field_sets
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
custom_field_set_id
STRING
custom_field_values
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
custom_field_id
STRING
custom_field_value
STRING
custom_payment_amounts
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
amount
NUMBER
custom_payment_amount_type
STRING
tax_on_amount
NUMBER
encoded_key
STRING
external_id
STRING
fees
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
amount
NUMBER
name
STRING
predefined_fee_key
STRING
tax_amount
NUMBER
trigger
STRING
id
STRING
linked_loan_transaction_key
STRING
migration_event_key
STRING
notes
STRING
original_amount
NUMBER
original_currency_code
STRING
original_transaction_key
STRING
parent_account_key
STRING
parent_loan_transaction_key
STRING
taxes
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
deferred_tax_on_interest_amount
NUMBER
tax_interest_from_arrears_amount
NUMBER
tax_on_fees_amount
NUMBER
tax_on_interest_amount
NUMBER
tax_on_penalty_amount
NUMBER
tax_rate
NUMBER
terms
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
interest_settings
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
index_interest_rate
NUMBER
interest_rate
NUMBER
principal_payment_amount
NUMBER
principal_payment_percentage
NUMBER
till_key
STRING
transaction_details
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
transaction_channel_id
STRING
transaction_channel_key
STRING
transfer_details
OBJECT
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
custom_field_set_id
STRING
custom_field_values
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
administrator_access
BOOLEAN
api_access
BOOLEAN
can_manage_all_branches
BOOLEAN
can_manage_entities_assigned_to_other_officers
STRING
credit_officer_access
BOOLEAN
mambu_access
BOOLEAN
managed_branches
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
branch_key
STRING
permissions
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
support_access
BOOLEAN
teller_access
BOOLEAN
assigned_branch_key
STRING
creation_date
DATE-TIME
custom_field_sets
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
custom_field_set_id
STRING
custom_field_values
ARRAY
This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.
custom_field_id
STRING
custom_field_value
STRING
email
STRING
encoded_key
STRING
first_name
STRING
home_phone
STRING
id
STRING
language
STRING
last_logged_in_date
DATE-TIME
last_modified_date
DATE-TIME
last_name
STRING
mobile_phone
STRING
notes
STRING
title
STRING
two_factor_authentication
BOOLEAN
user_state
STRING
username
STRING
Did this page help you?
If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!
