| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | T000 | MANDT | Allow NULL? |
| 2 | BUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | No | T001 | BUKRS | Allow NULL? |
| 3 | PLANNERID | Hedge Plan ID | nvarchar | 13 | 0 | CHAR | (N' ') | No | THMEXT_PLANNER | THM_PLANNERID | Allow NULL? |
| 4 | EXPOSUREID | Exposure ID | nvarchar | 5 | 0 | NUMC | (N'00000') | No | THMEXT_EXPOS | THM_EXPOSUREID | Allow NULL? |
| 5 | EXPOSUREDATE | Date to Which Exposure Refers | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | THM_EXPDATE | Allow NULL? |
| 6 | AMOUNT | Exposure Amount | decimal | 17 | 2 | CURR | ((0)) | Yes | | THM_EXPAMOUNT | |
| 7 | CURRENCY | Exposure Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | THM_EXPCURRENCY | Allow NULL? |
| 8 | RATE | FX Rate for Exposure | decimal | 13 | 9 | DEC | ((0)) | Yes | | THM_EXPRATE | |
| 9 | INTRATE_REF | Reference Interest Rate | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | SZSREF | Allow NULL? |
| 10 | INTRATE_ADJ | Determination date for percentage rate of condition items | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | VVDPKOND | Allow NULL? |
| 11 | INTCALC_START | Start of Calculation Period | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DBERVON | Allow NULL? |
| 12 | INTCALC_END | End of Calculation Period | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DBERBIS | Allow NULL? |
| 13 | INTCALC_METHOD | Interest Calculation Method | char | 1 | 0 | CHAR | (N' ') | Yes | | SZBMETH | Allow NULL? |
| 14 | INTCALC_TIMEBAS | Number of base days in a calculation period | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | | ABASTAGE | Allow NULL? |
| 15 | INTCALC_DAYS | Workdays | smallint | 5 | 0 | INT2 | ((0)) | Yes | | ATAGE | |
| 16 | INTCALC_AMNT | Amount in position currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | BBWHR | |
| 17 | INTRATE_FIX | Interest rate as a percentage | decimal | 10 | 7 | DEC | ((0)) | Yes | | TB_PKOND | |
| 18 | INTRATE_SIGN | +/- Sign of Interest Rate Spread | char | 1 | 0 | CHAR | (N' ') | Yes | | THA_SIGN_SOFFSET | Allow NULL? |
| 19 | FLG_INT_AMOUNT | Indicate Interest Amount (E-Hedge Accounting) | char | 1 | 0 | CHAR | (N' ') | Yes | | THM_FLG_INTAMOUNT | Allow NULL? |
| 20 | INTRATE_SOFFSET | Fixer offset for variable interest rate reference | decimal | 10 | 7 | DEC | ((0)) | Yes | | TV_SOFFSET | |
| 21 | INTRATE_REGI | Status of Interest Rate Adjustment | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | TB_IRA_REGISTRATION_STATE | Allow NULL? |
| 22 | INTCALC_AMMRHY | Frequency in months | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | AMMRHY | Allow NULL? |
