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.
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 |
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.
This field contains the 'holding object type' for the entry.
This field contains the ID number of the 'holding object'. The table of the holding object is stored in the Object Type Field.
This field contains the pointer for the column in the CBS (Contract Balance Sheet) table.
Additional external ID to optionaly differentiate groups of entries.
The starting date for validity of the entry.
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.
This field contains the currency identified by its ISO code for the adjacent amount.
This is the balance that is valid for the relevant date.
This field identifies the last CBE entry which defines this balance.
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.
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.
This field holds the currency of an optional committed balance.
This field holds the total balance of all CBE entries which affect the column value and which are marked as committed.
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.
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.