DebitCredits: Twinfield Domain DebitCredits
read only
- Catalog:
Twinfield - Schema:
CodeValues - Label: Domain DebitCredits
Lookup-table that translates code values of the domain 'DebitCredits' into descriptions.
Can only retrieve data.
Example
The code value 'debit' means 'Debit. On an electronic bank statement, money paid by the bank.'.
Performance Characteristics
| Characteristic | Value |
|---|---|
| Estimated rows | 2 |
| Average access latency (ms) | 54 |
| Full scan rows per minute | 1,690 |
| Point query rows per minute | 1,111 |
| Write rows per minute | 378 |
Table Columns
The columns of the table DebitCredits are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.
| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
code |
varchar2 |
Code | fetched only when named | Unique code within the domain. | |
description |
varchar2 |
Description | fetched only when named | Meaning of the unique code within the domain. | |
domain |
varchar2 |
Domain | fetched only when named | Each domain defines a map of codes to values. | |
resource_ |
varchar2 |
Resource Code | fetched only when named | Resource code for internationalization. |
Code Values
| Code | Description |
|---|---|
credit |
itgen_twinfield_debitcredits_credit |
debit |
itgen_twinfield_debitcredits_debit |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver:
Changes of This Table, 26.0 to 27.0
View Twinfield.CodeValues.DebitCredits is added
The view has 4 columns and can select.
- importance 3