| 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 | * | MANDT | Allow NULL? |
| 2 | SHEETNR | RBD: Fair Value Sheet | nvarchar | 10 | 0 | NUMC | (N'0000000000') | No | | /IBS/E_SHEETNR | Allow NULL? |
| 3 | TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | DEC | ((0)) | No | | TIMESTAMP | |
| 4 | RBDID | RBD: RBD ID (RBD Area) | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | /IBS/E_RBDID | Allow NULL? |
| 5 | RBDNR | RBD: Account Number | nvarchar | 13 | 0 | CHAR | (N' ') | Yes | | /IBS/E_RBDNR | Allow NULL? |
| 6 | DUE_DATE | RBD: Valuation Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | /IBS/E_SDATE | Allow NULL? |
| 7 | BEWME | RBD: Valuation Method | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | /IBS/E_BEWME | Allow NULL? |
| 8 | MODID | RBD: Component ID Source System | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | /IBS/E_RMODID | Allow NULL? |
| 9 | VERTV | RBD: Contract Number Source System | nvarchar | 100 | 0 | CHAR | (N' ') | Yes | | /IBS/E_VERTV | Allow NULL? |
| 10 | LIBUE | RBD: Source Accounting Unit | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | /IBS/E_LIBUE | Allow NULL? |
| 11 | VKREF | RBD: Account Assignment Reference Source System | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | /IBS/E_VKREF | Allow NULL? |
| 12 | PDAVS | RBD: Product Type Source System | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | /IBS/E_PDAVS | Allow NULL? |
| 13 | VEAVS | RBD: Contract Type Previous System | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | /IBS/E_VEAVS | Allow NULL? |
| 14 | RWBKNZ | RBD: Value Adjustment Indicator | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | /IBS/E_RWBKNZ | Allow NULL? |
| 15 | CURRENCY | RBD: Currency of Risk Provision | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | /IBS/E_RBARW | Allow NULL? |
| 16 | ARREAR | RBD: Amount in Arrears in Contract Currency (IAS) | decimal | 23 | 2 | CURR | ((0)) | Yes | | /IBS/E_RBETRV | |
| 17 | OBLIGO | RBD: Book Value for Srce System Contract in Contract Currncy | decimal | 23 | 2 | CURR | ((0)) | Yes | | /IBS/E_OBETRV | |
| 18 | XINCL_RESTKAP | RBD: CF Position Rem. Capital at End of Fixed Int./Term | char | 1 | 0 | CHAR | (N' ') | Yes | | /IBS/E_KZRKI | Allow NULL? |
| 19 | DELFZ | RBD: End of Term for Source System Contract | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | /IBS/E_DELFZ | Allow NULL? |
| 20 | DEFSZ | RBD: End of Fixed Interest Period in Source System Contract | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | /IBS/E_DEFSZ | Allow NULL? |
| 21 | DELINQ_SINCE | RBD: Date Since Which Contract Is in Arrears | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | /IBS/E_DSINCE | Allow NULL? |
| 22 | SUM_LOSSES | RBD: Total Loss Amount for Contract in Source System | decimal | 23 | 2 | CURR | ((0)) | Yes | | /IBS/E_ABETRV | |
| 23 | REAL_DATE | RBD: Date, Recovery Time | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | /IBS/E_DVERW | Allow NULL? |
| 24 | BRESTKAP | RBD: Remaining Capital at End of Cash Flow | decimal | 23 | 2 | CURR | ((0)) | Yes | | /IBS/E_BENDV | |
| 25 | INT_RATE | RBD: Initial Eff. Interest Rate in Source System Contract | decimal | 15 | 10 | DEC | ((0)) | Yes | | /IBS/E_PZINS | |
| 26 | PERC_CAF | RBD: Percentage Expectation Used for Cash Flow | decimal | 5 | 2 | DEC | ((0)) | Yes | | /IBS/E_PERCCF | |
| 27 | INT_METH | RBD: Interest Calculation Method (Financial Mathematics) | char | 1 | 0 | CHAR | (N' ') | Yes | | /IBS/E_INTCM | Allow NULL? |
| 28 | PROCTYPE | RBD: Processing Type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | /IBS/E_PROCTYPE | Allow NULL? |
| 29 | PROCCAT | RBD: Processing Category for IAS | char | 1 | 0 | CHAR | (N' ') | Yes | | /IBS/E_PROCCAT | Allow NULL? |
| 30 | XCF_DIFF | RBD: CF Position Remaining Capital on Valuation Key Date | char | 1 | 0 | CHAR | (N' ') | Yes | | /IBS/E_KZKFC | Allow NULL? |
| 31 | LAST_DUE_DATE | RBD: Valuation Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | /IBS/E_LSDATE | Allow NULL? |
| 32 | COLUP | RBD Indicator: Update Liquidation Dates | char | 1 | 0 | CHAR | (N' ') | Yes | | /IBS/E_RCOLUP | Allow NULL? |
| 33 | GJRBD | RBD: Fiscal Year RBD | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | /IBS/E_GJRBD | Allow NULL? |
| 34 | WB_BESTAND | RBD: Value Adjustment Position Current Period | decimal | 23 | 2 | CURR | ((0)) | Yes | | /IBS/E_WBB_BU | |
| 35 | WB_BESTAND_UN | RBD: Position Unwinding Current Period (Val. Adj.) | decimal | 23 | 2 | CURR | ((0)) | Yes | | /IBS/E_WBB_UN | |
| 36 | WB_BESTAND_SU | RBD: Reserve Field | decimal | 23 | 2 | CURR | ((0)) | Yes | | /IBS/E_WBB_SU | |
| 37 | WB_BESTAND_VJ | RBD: Value Adjustment Position Previous Periods | decimal | 23 | 2 | CURR | ((0)) | Yes | | /IBS/E_WBBBUV | |
| 38 | WB_BESTAND_VJ_UN | RBD: Position Unwinding Previous Periods (Val. Adj.) | decimal | 23 | 2 | CURR | ((0)) | Yes | | /IBS/E_WBBUNV | |
| 39 | WB_BESTAND_VJ_SU | RBD: Reserve Field | decimal | 23 | 2 | CURR | ((0)) | Yes | | /IBS/E_WBBSUV | |
| 40 | WB_BESTAND_VB | RBD: Position Usage (Value Adjustment) | decimal | 23 | 2 | CURR | ((0)) | Yes | | /IBS/E_AUBD_AJ | |
| 41 | WB_BESTAND_DA | RBD: Position Direct Write-Off (Value Adjustment) | decimal | 23 | 2 | CURR | ((0)) | Yes | | /IBS/E_AUBD_VJ | |
| 42 | WB_AE_BESTAND_VJ | RBD: Change Balance Value Adjustment Previous Periods | decimal | 23 | 2 | CURR | ((0)) | Yes | | /IBS/E_WBAEB_VJ | |
| 43 | WB_BEDARF | RBD: Change Requirements Value Adjustment Current Period | decimal | 23 | 2 | CURR | ((0)) | Yes | | /IBS/E_WB_BDG | |
| 44 | WB_BEDARF_UN | RBD: Requirement Unwinding (Value Adjustment) | decimal | 23 | 2 | CURR | ((0)) | Yes | | /IBS/E_WB_BDU | |
| 45 | WB_BEDARF_VJ | RBD: Change Requirement Value Adjustment Previous Periods | decimal | 23 | 2 | CURR | ((0)) | Yes | | /IBS/E_WB_BDS | |
| 46 | WB_BEDARF_VB | RBD: Change Requirement Usage (Value Adjustment) | decimal | 23 | 2 | CURR | ((0)) | Yes | | /IBS/E_AUBDAAJ | |
| 47 | WB_BEDARF_DA | RBD: Change Requirement Direct Write-Off (Value Adjustment) | decimal | 23 | 2 | CURR | ((0)) | Yes | | /IBS/E_AUBDAVJ | |
| 48 | SUM_SICH_AB | RBD: NPV of Expected Collateral Revenues Value Adjustment | decimal | 23 | 2 | CURR | ((0)) | Yes | | /IBS/E_WBCOLL | |
| 49 | SUM_CF_RATE | RBD: Total Cash Flow Positions (Installments) | decimal | 23 | 2 | CURR | ((0)) | Yes | | /IBS/E_SUMCFR | |
| 50 | SUM_CF_ERWA | RBD: Total Cash Flow Expectation (Value Adjustment) | decimal | 23 | 2 | CURR | ((0)) | Yes | | /IBS/E_SUMCFE | |
| 51 | SUM_CF_ABGE | RBD: Net Present Value of Expected Cash Flow (Val. Adj.) | decimal | 23 | 2 | CURR | ((0)) | Yes | | /IBS/E_SUMCFA | |
| 52 | SUM_AKT_UNW | RBD: Unwinding Amount | decimal | 23 | 2 | CURR | ((0)) | Yes | | /IBS/E_BETUN | |
| 53 | SUM_AKT_UNW_MEM | RBD: Unwinding Amount | decimal | 23 | 2 | CURR | ((0)) | Yes | | /IBS/E_BETUN | |
| 54 | OP_CH_UNW | RBD: Open Position Change Value Adjustment | decimal | 23 | 2 | CURR | ((0)) | Yes | | /IBS/E_OPCHUNW | |
| 55 | BEST_UMB_AB | RBD: Balance Sheet Transfer - Retirement - Value Adjustment | decimal | 23 | 2 | CURR | ((0)) | Yes | | /IBS/E_B_UMAB | |
| 56 | BEST_UMB_ZU | RBD: Balance Sheet Transfer - Acquisition - Value Adjustment | decimal | 23 | 2 | CURR | ((0)) | Yes | | /IBS/E_B_UMZU | |
| 57 | RBDKL | RBD: Class | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | * | /IBS/E_RBDKL | Allow NULL? |
| 58 | RBDKL_OLD | RBD: Class (Old) | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | * | /IBS/E_RBDKL_OLD | Allow NULL? |
| 59 | VKREF_OLD | RBD: Account Assignment Reference Source System (Old) | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | /IBS/E_VKREF_OLD | Allow NULL? |
| 60 | KZTRNS | RBD: Balance Sheet Transfer | char | 1 | 0 | CHAR | (N' ') | Yes | | /IBS/E_KZTRNS | Allow NULL? |
| 61 | FLG_INIT | RBD: Checkbox for Initial Run | char | 1 | 0 | CHAR | (N' ') | Yes | | /IBS/E_RFLG_INIT | Allow NULL? |
| 62 | WB_INIT | RBD: Initialization (Value Adjustment) for Current Period | decimal | 23 | 2 | CURR | ((0)) | Yes | | /IBS/E_RAE_INIT_WB | |
| 63 | WB_INIT_VJ | RBD: Initialization of Value Adjustment (Previous Periods) | decimal | 23 | 2 | CURR | ((0)) | Yes | | /IBS/E_RAE_INIT_WB_VJ | |
| 64 | MAN_LOSSES | RBD: Manual Loss Entry | decimal | 23 | 2 | CURR | ((0)) | Yes | | /IBS/E_RMABETRV | |
| 65 | OBLIGO_ORG | RBD: Orig. Book Value of Srce Syst. Contr. in Contract Crcy | decimal | 23 | 2 | CURR | ((0)) | Yes | | /IBS/E_ROBETRV_ORG | |
| 66 | ARCHIVE_STATUS | Archiving Status | char | 1 | 0 | CHAR | (N' ') | Yes | | BCA_AR_STATUS | Allow NULL? |
| 67 | ARCHIVE_FLUD | Resubmission Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BCA_AR_FLUD | Allow NULL? |
| 68 | ANUSR | RBD: User Who Made First Entry | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | /IBS/E_RANUSR | Allow NULL? |
| 69 | ANDAT | RBD: Date of First Entry | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | /IBS/E_RANDAT | Allow NULL? |
| 70 | ANUHR | RBD: Time First Entry Was Made | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | /IBS/E_RANUHR | Allow NULL? |
| 71 | ANHER | RBD: Origin of First Entry | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | * | /IBS/E_RANHER | Allow NULL? |
| 72 | AEUSR | RBD: User who Made the Change | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | /IBS/E_RAEUSR | Allow NULL? |
| 73 | AEDAT | RBD: Date of Last Change | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | /IBS/E_RAEDAT | Allow NULL? |
| 74 | AEUHR | RBD: Time of Last Change | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | /IBS/E_RAEUHR | Allow NULL? |
| 75 | AEHER | RBD: Origin of Last Change | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | * | /IBS/E_RAEHER | Allow NULL? |
| 76 | RS_BASIS | RBD: Open Contingent Liability in Contract Currency | decimal | 23 | 2 | CURR | ((0)) | Yes | | /IBS/E_RS_BASIS | |
| 77 | RS_PROP | RBD: Probability of Risk Provision Usage | decimal | 5 | 2 | DEC | ((0)) | Yes | | /IBS/E_RS_PROP | |
| 78 | RS_PROP_DR | RBD: Usage Amount Contingent Liability | decimal | 5 | 2 | DEC | ((0)) | Yes | | /IBS/E_RS_PROP_DR | |
| 79 | RS_PASSV | RBD: Indicator Prohibition of Liability Recognition (Reset) | char | 1 | 0 | CHAR | (N' ') | Yes | | /IBS/E_RS_PASSV | Allow NULL? |
| 80 | RS_BESTAND | RBD: Provision Balance Current Period | decimal | 23 | 2 | CURR | ((0)) | Yes | | /IBS/E_RSB_AJ | |
| 81 | RS_BESTAND_UN | RBD: Position Unwinding Current Period (Reset) | decimal | 23 | 2 | CURR | ((0)) | Yes | | /IBS/E_RSB_UN_AJ | |
| 82 | RS_BESTAND_VJ | RBD: Provision Balance Previous Periods | decimal | 23 | 2 | CURR | ((0)) | Yes | | /IBS/E_RSB_VJ | |
| 83 | RS_BESTAND_UN_VJ | RBD: Position Unwinding Previous Periods (Reset) | decimal | 23 | 2 | CURR | ((0)) | Yes | | /IBS/E_RSB_UN_VJ | |
| 84 | RS_BEDARF | RBD: Provision Requirement | decimal | 23 | 2 | CURR | ((0)) | Yes | | /IBS/E_RS_BD | |
| 85 | RS_BEDARF_UN | RBD: Unwinding Requirements (Provision) | decimal | 23 | 2 | CURR | ((0)) | Yes | | /IBS/E_RS_BDU | |
| 86 | RS_AE_BESTAND_VJ | RBD: Change Balance Provision Previous Periods | decimal | 23 | 2 | CURR | ((0)) | Yes | | /IBS/E_RS_AEB_VJ | |
| 87 | RS_BEDARF_AJ | RBD: Change Requirement Provision Current Period | decimal | 23 | 2 | CURR | ((0)) | Yes | | /IBS/E_RS_BD_AJ | |
| 88 | RS_BEDARF_VJ | RBD: Change Requirement Provision Previous Periods | decimal | 23 | 2 | CURR | ((0)) | Yes | | /IBS/E_RS_BD_VJ | |
| 89 | RS_SUM_IA_ERWA | RBD: Defined Utilization (Total) | decimal | 23 | 2 | CURR | ((0)) | Yes | | /IBS/E_RS_IA_ERW | |
| 90 | RS_SUM_IA_ABGE | RBD: NPV of Expected Utilization | decimal | 23 | 2 | CURR | ((0)) | Yes | | /IBS/E_RS_SUMIAA | |
| 91 | RS_SUM_CF_ERWA | RBD: Total Cash Flow Expectation (Reset) | decimal | 23 | 2 | CURR | ((0)) | Yes | | /IBS/E_RS_SUMCFE | |
| 92 | RS_SUM_CF_ABGE | RBD: NPV of Expected Cash Flows (Provision) | decimal | 23 | 2 | CURR | ((0)) | Yes | | /IBS/E_RS_SUMCFA | |
| 93 | RS_SUM_SICH_AB | RBD: NPV of Expected Collateral Revenues (Reset) | decimal | 23 | 2 | CURR | ((0)) | Yes | | /IBS/E_RS_SUMCOA | |
| 94 | RS_SUM_I_UNW | RBD: Unwinding Amount | decimal | 23 | 2 | CURR | ((0)) | Yes | | /IBS/E_BETUN | |
| 95 | RS_SUM_I_UNW_MEM | RBD: Unwinding Amount | decimal | 23 | 2 | CURR | ((0)) | Yes | | /IBS/E_BETUN | |
| 96 | RS_SUM_UNW | RBD: Unwinding Amount | decimal | 23 | 2 | CURR | ((0)) | Yes | | /IBS/E_BETUN | |
| 97 | RS_SUM_UNW_MEM | RBD: Unwinding Amount | decimal | 23 | 2 | CURR | ((0)) | Yes | | /IBS/E_BETUN | |
| 98 | RS_SHEETNR_REF | RBD: Fair Value Sheet Reference | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | | /IBS/E_SHEETNR_REF | Allow NULL? |
| 99 | RS_OP_CH_UNW | RBD: Open Position Change Provision | decimal | 23 | 2 | CURR | ((0)) | Yes | | /IBS/E_RS_OPCHUNW | |
| 100 | RS_BEST_UMB_AB | RBD: Balance Sheet Transfer - Retirement - Provision | decimal | 23 | 2 | CURR | ((0)) | Yes | | /IBS/E_RS_B_UMAB | |
| 101 | RS_BEST_UMB_ZU | RBD: Balance Sheet Transfer - Acquisition - Provision | decimal | 23 | 2 | CURR | ((0)) | Yes | | /IBS/E_RS_B_UMZU | |
| 102 | RS_INIT | RBD: Initialization (Provision) for Current Period | decimal | 23 | 2 | CURR | ((0)) | Yes | | /IBS/E_RAE_INIT_RS | |
| 103 | RS_INIT_VJ | RBD: Initialization of Provision (Previous Periods) | decimal | 23 | 2 | CURR | ((0)) | Yes | | /IBS/E_RAE_INIT_RS_VJ | |
