User Tools
Add this page to your book 
Remove this page from your book 
Manage book (
Help Table of Contents
CBB - CBS Balance per Column and Date Range
Module CBB
This table holds the different balance values per contract, column and date range. To access this table the access routines of the module CBSMOD should be used. The data of this table is automatically extracted and maintained during maintenance of the table CBE - CBS Entry which holds the individual entries.
Datafields
| Name | Helptext Description | Data Type | Len | Codetable |
|---|---|---|---|---|
| INR | Internal Unique ID | Text | 8 | |
| OBJTYP | Object Type | Text | 6 | CBOTXT |
| OBJINR | Object INR | Text | 8 | |
| CBC | CBS Column | Text | 6 | CBCTXT |
| EXTID | External ID | Text | 16 | |
| BEGDAT | Starting Date | Date | 12 | |
| ENDDAT | End of Validity (Excl.) | Date | 12 | |
| CUR | Currency | Text | 3 | CURTXT |
| AMT | Amount | Numeric | 18 | |
| CBEINR | INR of original CBE Entry | Text | 8 | |
| XRFCUR | Currency of Converted Amount | Text | 3 | |
| XRFAMT | Converted Balance | Numeric | 18 | |
| COMCUR | Currency of Committed Balance | Text | 3 | |
| COMAMT | Committed Balance | Numeric | 18 | |
| XCOCUR | Currency of Converted Committed Balance | Text | 3 | |
| XCOAMT | Converted Committed Balance | Numeric | 18 |
Datafield Description and Properties
Datafield INR Internal Unique ID
Unique internal ID of a record within the table. The INR is a text field, which is created by retrieving the next valid entry from the counter of this table. The field INR is used to enable links from other tables to this table.
For contractdata the INR also links the two tables xxD and xxT as associated entries hold the same INR.
Datafield OBJTYP Object Type
This field contains the 'holding object type' for the entry.
Datafield OBJINR Object INR
This field contains the ID number of the 'holding object'. The table of the holding object is stored in the Object Type Field.
Datafield CBC CBS Column
This field contains the pointer for the column in the CBS (Contract Balance Sheet) table.
Datafield EXTID External ID
Additional external ID to optionaly differentiate groups of entries.
Datafield BEGDAT Starting Date
The starting date for validity of the entry.
Datafield ENDDAT End of Validity (Excl.)
This date defines the day following the ending validity of this remaining amount. If the end date is equal to the start date, which happens if there are more than one entry for a given date, the entry is never valid and just kept for sake of completeness.
Datafield CUR Currency
This field contains the currency identified by its ISO code for the adjacent amount.
Datafield AMT Amount
This is the balance that is valid for the relevant date.
Datafield CBEINR INR of original CBE Entry
This field identifies the last CBE entry which defines this balance.
Datafield XRFCUR Currency of Converted Amount
Currency of the converted amount. This currency is usually set from System Currency. This field is an optional field and may be empty, if no converted amount of the specific balance is known.
Datafield XRFAMT Converted Balance
The converted amount of the Amount field. If the Currency field for the converted amount has been set, this field holds the converted amount based on the middle rate of the date, on which the original CBE entry was made. If XRFCUR is empty, this field has to be zero.
Datafield COMCUR Currency of Committed Balance
This field holds the currency of an optional committed balance.
Datafield COMAMT Committed Balance
This field holds the total balance of all CBE entries which affect the column value and which are marked as committed.
Datafield XCOCUR Currency of Converted Committed Balance
Currency of the converted committed amount. This currency is usually set from System Currency. This field is an optional field and may be empty, if no converted amount of the specific balance is known.
Datafield XCOAMT Converted Committed Balance
The converted amount of the Committed Balance. Ifthe Currency field for the committed balance has been set, this field holds the converted committed amount based on the middle rate of the date, on which the original CBE entry was made. If the Currency field is empty, this field has to be zero.
