# Ledgers: Gripp CRM Ledgers - Catalog: `GrippCrm` - Primary Keys: `id` - Label: Ledgers - Retrieve: True ## Table Columns The columns of the table `Ledgers` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `active` | `char` | Active | ☐ | | | `categorie_discr` | `varchar2` | | ☐ | | | `categorie_id` | `int32` | | ☐ | | | `categorie_searchname` | `varchar2` | | ☐ | | | `createdon_date` | `datetime` | Created on Date | ☐ | | | `createdon_timezone_type` | `int32` | Created on Timezone Type | ☐ | | | `createdon_timezone` | `varchar2` | Created on Timezone | ☐ | | | `debitcredit_discr` | `varchar2` | | ☐ | | | `debitcredit_id` | `int32` | Debit/Credit ID | ☐ | | | `debitcredit_searchname` | `varchar2` | Debit/Credit Search Name | ☐ | | | `id` | `int32` | ID | ☐ | | | `name` | `varchar2` | Name | ☐ | | | `number` | `varchar2` | Number | ☐ | | | `searchname` | `varchar2` | Search Name | ☐ | | | `type_discr` | `varchar2` | | ☐ | | | `type_id` | `int32` | Type ID | ☐ | | | `type_searchname` | `varchar2` | Type Search Name | ☐ | | | `updatedon_date` | `datetime` | Updated on Date | ☐ | | | `updatedon_timezone_type` | `int32` | Updated on Timezone Type | ☐ | | | `updatedon_timezone` | `varchar2` | Updated on Timezone | ☐ | |