| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
---|
| 1 | MANDANT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | T000 | MANDT | Allow NULL? |
| 2 | SHEETNR | RBD: Fair Value Sheet | nvarchar | 10 | 0 | NUMC | (N'0000000000') | No | | /IBS/E_SHEETNR | Allow NULL? |
| 3 | POSIT | RBD: Sequence Number | nvarchar | 10 | 0 | NUMC | (N'0000000000') | No | | /IBS/E_POSIT | Allow NULL? |
| 4 | TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | DEC | ((0)) | No | | TIMESTAMP | |
| 5 | DUE_DATE | RBD: Due Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | /IBS/E_DFAELL | Allow NULL? |
| 6 | CURRENCY | RBD: Currency of Risk Provision | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | /IBS/E_RBARW | Allow NULL? |
| 7 | SIGN_DEB_CRED | RBD: Debit/Credit Indicator 1 | char | 1 | 0 | CHAR | (N' ') | Yes | | /IBS/E_RFLG_DC1 | Allow NULL? |
| 8 | RATE | RBD: Expected Utilization (Installment) | decimal | 23 | 2 | CURR | ((0)) | Yes | | /IBS/E_RB_IA | |
| 9 | SIGN_DEB_CRED2 | RBD: Debit/Credit Indicator 2 | char | 1 | 0 | CHAR | (N' ') | Yes | | /IBS/E_RFLG_DC2 | Allow NULL? |
| 10 | RATE_MAN | RBD: Relevant Amount for Utilization | decimal | 23 | 2 | CURR | ((0)) | Yes | | /IBS/E_RB_IA_MAN | |
| 11 | RS_PROP | RBD: Probability of Risk Provision Usage | decimal | 5 | 2 | DEC | ((0)) | Yes | | /IBS/E_RS_PROP | |
| 12 | EXPECT | RBD: Expected Utilization (Weighted) | decimal | 23 | 2 | CURR | ((0)) | Yes | | /IBS/E_RB_IA_EXPW | |
| 13 | CFTYP | RBD: Cash Flow Category | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | | /IBS/E_CFTYP | Allow NULL? |
| 14 | CFCAT | RBD: Cash Flow Category | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | /IBS/E_CFCAT | Allow NULL? |
| 15 | DISC_RATE | RBD: Discount Interest Rate AP 1 | decimal | 15 | 10 | DEC | ((0)) | Yes | | /IBS/E_RDISC_RATE1 | |
| 16 | PRESENT_VAL | RBD: Net Present Value AP 1 in Contract Currency | decimal | 23 | 2 | CURR | ((0)) | Yes | | /IBS/E_RPVECF1 | |
| 17 | DISC_RATE2 | RBD: Discount Interest Rate AP 2 | decimal | 15 | 10 | DEC | ((0)) | Yes | | /IBS/E_RDISC_RATE2 | |
| 18 | PRESENT_VAL2 | RBD: Net Present Value AP 2 in Contract Currency | decimal | 23 | 2 | CURR | ((0)) | Yes | | /IBS/E_RPVECF2 | |
| 19 | REFNR | RBD: Reference | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | /IBS/E_RREFNR | Allow NULL? |
| 20 | ANUSR | RBD: User Who Made First Entry | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | /IBS/E_RANUSR | Allow NULL? |
| 21 | ANDAT | RBD: Date of First Entry | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | /IBS/E_RANDAT | Allow NULL? |
| 22 | ANUHR | RBD: Time First Entry Was Made | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | /IBS/E_RANUHR | Allow NULL? |
| 23 | ANHER | RBD: Origin of First Entry | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | * | /IBS/E_RANHER | Allow NULL? |
| 24 | AEUSR | RBD: User who Made the Change | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | /IBS/E_RAEUSR | Allow NULL? |
| 25 | AEDAT | RBD: Date of Last Change | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | /IBS/E_RAEDAT | Allow NULL? |
| 26 | AEUHR | RBD: Time of Last Change | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | /IBS/E_RAEUHR | Allow NULL? |
| 27 | AEHER | RBD: Origin of Last Change | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | * | /IBS/E_RAEHER | Allow NULL? |