Transaction Type

The Transaction Type menu holds the accounting model and the item configuration. It is used for inserting the financial data transactions.

For using transaction types in conjunction with Core Banking, see Transaction Types Used in Core Banking.

HINT  
Users can insert, delete, or export Transaction Types tables.

Creating Transaction Types

1. Log into the FintechOS Portal.

2. Expand the General Ledger Configurations menu and select Transaction Type. The Transaction Operation Types List page opens.

3. At the top-right corner of the page, click the Insert button to create a new transaction type.

4. Fill in the following fields:

Field Required Type Description
Name Yes Text The name of the transaction.
Is Automatic Transaction No Bool

If true, then the transaction is automatic.

IMPORTANT!  
If a transaction type is marked as an automatic transaction (Is Automatic Transaction = True), then that transaction type cannot be selected in the Events page when closing contract events.
Is System Transaction No Bool If true, then this is a system transaction. It is used when there's a need of a transaction for the sole purpose of generating accounting entries (accruals, provisions).
Transaction Code Yes Text The code of the transaction.
Transaction Operation Type Yes Lookup

The type of the transaction. The following options are available:

  • Disbursement

  • Payment In

  • Payment Out

  • Recover Debt

  • Repayment Contract -

Generates Accounting Entry No Bool If true, it generates recordings in the FTOS_GL_AccountingEntryentity.
realTimeProcess No Bool If true, it allows real-time processing for transactions made on bank accounts. For more information, see the Bank Account Transaction Queue page.
To Be Purged No Bool If true, it allows the possibility to purge or archive certain records in draft status.
Master Purge Entity Yes Lookup

The master purge entity under which the draft records are.

NOTE  

This field is displayed only when To Be Purged = True.
Purge Number of Days Yes Whole Number

The default number of calendar days that a record can be kept in Draft status before it is purged. For additional information, see the Core Banking System Parameters page.

NOTE  

This field is displayed only when To Be Purged = True.
Source Entity ID Yes Lookup

The source entity from where the values are taken when generating accounting entries.

NOTE  
This field is displayed only when Generates Accounting Entry = True.

Generate New Contract Version No Bool If true, a new contract version is generated.
Commission Type No Lookup The commission type applicable to transactions of this type.
 

5. Click Save and reload.

IMPORTANT!  
If a transaction type is marked to automatically generate accounting entries (Generates Accounting Entry = True), then the following sections are displayed: Transaction Value Type, Transaction Item Accounting Configuration, and Transaction Accounting Models.

Transaction Value Type

Transaction value types are defined as header items or detail items. Header items are the general details of a transaction (for example date, customer, currency, and so on). The detail items are grouped into numeric or text information.

In this section, users can create and determine the values calculated for each transaction. The additional data from here is used in the Transaction Accounting Models section.

1. To add a new transaction value type, click the Insert button under the Transaction Value Type section. The Add Transaction Value Type page opens.

2. Fill in the following fields:

Field RequiredTypeDescription
Value Type NameNoTextThe name of the value type.
Transaction TypeNoLookupThe transaction value type.
TypeNoOption Set

The type of the transaction. The following options are available:

  • [none]

  • Numeric

  • Text

Value Type AttributeNoLookupThe value of a specific attribute from the source entity. It is a list of all the attributes defined in the SourceEntityId field from the FTOS_GL_TransactionType entity.
Is HeaderNoBoolWhen selected, it defines the header items of the transaction.
FormulaNoTextSupports only basic math operations: addition (+), subtraction (-), multiplication (*), and division (/). Input a specific formula based on the Value Type Attribute chosen.
 

3. Click Save and close.

When a transaction value type is marked as a header item, (Is Header = True), the transaction values are set into the attribute values of the FTOS_GL_OperationTransaction entity. If the Value Type Name field is not an attribute of that entity, then the following error is displayed:

Name should be an attribute name from header table FTOS_GL_ OperationTransaction.

A json with default values is sent when using the function for setting the operation transaction values. The json has the following form:

Copy
[
  {
    attributeName: 'DescriptionText',
    value: 'Disburse 1500'
   },
   {
    attributeName: 'ProvisionAmount',
    value: '15.00'
   }
]
 

The json checks if there is any default value for the attributeName, from the Value Type Name field. If no values are returned, the Formula field is checked. When neither field returned any values, the source entity of the attribute from the Value Type Attribute field is checked.

Transaction Item Accounting Configuration

The Transaction Item Accounting Configuration section holds the configuration of each transaction. It helps define an account from the Accounting Chart.

This section holds the configuration for an item with the respective chart account. It represents the listing of the names of the accounts for the company inserted in the Legal Entity menu.

1. To add a new transaction item accounting configuration, click the Insert button under the Transaction Item Accounting Configuration section. The Add Transaction Item Accounting Config page opens.

2. Fill in the following fields:

 

FieldRequiredTypeDescription
Accounting SystemYesLookup The accounting system.
Accounting ScopeYesLookupThe accounting scope.
Chart AccountYesLookupThe accounting chart.
Operational ItemNoLookupThe item of operations.
CurrencyNoLookupThe currency of the accounting entry line.
Take From ProductNoBoolIf true, then the configurations for each transaction are inherited from the banking product level.

 

3. Click Save and close.

Transaction Accounting Models

This section holds the accounting models, all the rules used in order to generate accounting entries for each transaction.

The details from the Debit Account Rule and the Credit Account Rule are defined by the information from the Transaction Item Accounting Configuration section. All other details are defined by the information from the Transaction Value Type section.

1. To add a new transaction accounting model, click the Insert button under the Transaction Accounting Models section. The Add Transaction Accounting Model page opens.

2. Fill in the following fields:

FieldRequiredTypeDescription
Transaction TypeNoLookupThe transaction type. It is auto-filled.
Accounting SystemNoLookupThe accounting system.
Line ConditionNoText The condition applied in order to post the accounting entry line.
Debit Account RuleNoText The accounting entry value of the debit account. It is auto-filled.
Debit Customer Rule NoText The rule to save the partner transaction in the debit-credit relationship. It is auto-filled.
Accounting Entry Value RuleNoText The posted accounting entry value.
Item Rule NoText The transaction item of the accounting entry line. It is auto-filled.
EntityId RuleNoText The internal status of the record.
Transaction Detail RuleNoText The rule to identify and post the ID of the operational transaction detail.
Credit Account RuleNoText The credit account of the accounting entry line. It is auto-filled.
Credit Customer RuleNoText It is auto-filled by the destination partner ID.
currencyRuleNoText The accounting entry line currency. It is auto-filled.
DescriptionRuleNoText The description of the generated accounting entry. It is auto-filled.
Transaction Id RuleNoText The related contract ID of the transaction.
Transaction Value TypeNoLookupThe value type of the transaction. It is defined in the Transaction Value Type section.
 

3. Click Save and close.