![]() Reference to the product type for which this entry is loggedįlag for marking is this entry was sent to the internal message broker Reference to the product encoded key for which this entry is logged Type of GL Account for which this entry is logged, for example ASSETor INCOME.įlag for marking if this entry has been successfully processed and can be removed from this table. Reference to the GL Account for which this entry is logged Reference to GL Journal Entry entry id for which this entry is logged.Īccounting entry type, for example, DEBIT or CREDIT. Reference to the branch encoded key for which this entry is logged.ĭate and time, in UTC, at which this entry was created. For interest accrued that is already paid after a prepayment PREPAID_INTEREST_ACCRUED.īooking Date of the referenced GL Journal Entry For regular interest accrued, that isn’t paid already INTEREST_ACCRUED. Reference to the account (loan/savings) ID for which this entry is logged. Reference to the account (loan/savings) encodedkey for which this entry is logged. In each entity’s table presented in this document, for its date fields extra info will be found about what value is stored in the database (UTC or Organization Time). The application logic then takes care of ensuring that this repayment is set to in arrears as appropriate for the organizations’ time zone. For instance, if a repayment is due on June 16th, 2010 it will be stored as “J00:00:00” in the database. Some variation to this are pure dates which have meaning for the organization itself. Most time stamps in Mambu are stored in UTC. Many tables will also have fields called creationDate and lastModifiedDate indicating when the object was created and last modified. This key is a Universally unique identifier (UUID) generated by the application at the time of creating or storing the object. Common FieldsĪll tables have a primary key called encodedKey. This document focuses on tables which are importable or accessible via APIs. Here we indicate which fields are also logically required or currently unused (or reserved for future use). For instance, a loan account has a foreign key to its holder which may be a client or a group. ![]() Mambu is built on a relational database system, but is often de-normalized and puts the dependency on the application to maintain certain level of integrity. For more information, see Database Backups in our User Guide or Database Backup in our API v2 Reference Overview You may also perform a database backup which will give a backup of all your tables. This document describes the database structure and fields used in Mambu for the purposes of supporting the Mambu APIs, Business Intelligence Reporting, and enabling data migration procedures. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |