Table to hold the different single entries stored in the CBS system. The balances per object are stored in a separate table CBB - CBS Balance per Column and Date Range. To access the data in the CBS system a module CBSMOD with access routines is supplied.
Name | Helptext Description | Data Type | Len | Codetable |
---|---|---|---|---|
INR | Internal Unique ID | Text | 8 | |
OBJTYP | Object Type | Text | 6 | CBOTXT |
OBJINR | Object INR | Text | 8 | |
EXTID | External ID | Text | 16 | |
CBT | Type of Entry | Text | 6 | CBTTXT |
TRNTYP | Type of Initiating Transaction | Text | 6 | |
TRNINR | Initiating Transaction INR | Text | 8 | |
DAT | Value Date | Date | 12 | |
CUR | Currency | Text | 3 | CURTXT |
AMT | Amount | Numeric | 18 | |
RELFLG | Release Status Flag | Text | 1 | Embedded |
CREDAT | Date Created | Date | 12 | |
XRFCUR | Currency of Converted Amount (Optional) | Text | 3 | |
XRFAMT | Converted Amount (Optional) | Numeric | 18 | |
NAM | Name | Text | 40 | |
ACC | Account (Optional) | Text | 34 | |
ACC2 | Account 2 (Optional) | Text | 34 | |
OPTDAT | End Date | Date | 12 | |
GLEDAT | Date of GLE Entry for the Transaction | Date | 12 |
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 holds the table ID of the table of the associated object.
This field holds the identification number (INR) of the object entry. The associated table is identified by the Object Type field.
This additional field is available to be able to store multiple amounts of the same type per contract. The Contract Balance Sheet subsystem always keeps track of balances through the external ID used. Thus, using different external IDs within a contract creates different balances. This is used in L/C contracts,for example, to differentiate between the base amount and additional amount.
This type of entry defines, via the Committed Balance Sheet configuration, which columns are affected by this booking entry and whether the value is to be added to or substracted from the balance of the column.
This field holds the table ID of the transaction which created this entry.
This field holds the identification number (INR) of the creating transaction.
This is the relevant date of this entry.
This is the currency of the amount stored in the relevant column in the Contract Balance Sheet table.
This field holds the booking amount of the entry.
The field indicates the status of the relevant entry in the CBS table. The three possible values are in the following logical sequence. 1. preliminary 2. entered 3. released.
Code | Text |
---|---|
R | Released |
P | Preliminary |
E | Entered |
This date field identifies the date the entry was physically added to the database.
The application can keep track of the counter value of all amounts in another (usually the system) currency. If the counter value is stored, the currency of this converted amount is stored in this field.
If counter values are stored, the converted amount is stored here. The associated currency is stored in the Currency field for converted amounts.
This is the long text description for the booking entry.
This optional account number field might be used to store the account number used in the corresponding general ledger entry. This information might be used when closing a balance to use the same account number as on creating the entry.
This optional counter account number field might be used to store the account number used in the corresponding general ledger entry as counter account. This information might be used when closing a balance to use the same counter account number as on creating the entry.
This additional, optional date field might be used for different purposes. One intended usage is to be able to store the different tenor dates on amounts split between multiple tenors.
To be able to retrieve balances where reconciliation with the general ledger is possible, the date when the original transaction was passed to the general ledger can be stored here.