| 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 | * | MANDT | Allow NULL? |
| 2 | MDCODE | Market Data Area | nvarchar | 4 | 0 | CHAR | (N' ') | No | /BA1/TF4_RRATES | /BA1/F4_DTE_MDCODE | Allow NULL? |
| 3 | REF_RATE | Reference Interest Rate | nvarchar | 10 | 0 | CHAR | (N' ') | No | /BA1/TF4_RRATES | /BA1/F4_DTE_REFERENCE | Allow NULL? |
| 4 | CCY | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | WAERS | Allow NULL? |
| 5 | DAY_CNT_METH | Interest Calculation Method | char | 1 | 0 | CHAR | (N' ') | Yes | | SZBMETH_NEW | Allow NULL? |
| 6 | TERM | Term | decimal | 3 | 0 | DEC | ((0)) | Yes | | LAUFZEIT | |
| 7 | TIME_UNIT | Time Unit | char | 1 | 0 | CHAR | (N' ') | Yes | | TIMEUNIT | Allow NULL? |
| 8 | PAYMNT_RHYTHM | Payment Frequency | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | /BA1/F4_DTE_PAYMNT_RHYTHM | Allow NULL? |
| 9 | COMP_FREQ | Compounding Frequency | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | /BA1/F4_DTE_COMP_FREQ | Allow NULL? |
| 10 | SKALID | Factory calendar | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TFACD | SKALID | Allow NULL? |
| 11 | FIX_PER | Number of Working Days for Interest Fixing | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | /BA1/F4_DTE_DAY_SHIFT_R | Allow NULL? |
| 12 | WRK_DAY_SHIFT | Working Day Shift for Calculation Day | char | 1 | 0 | NUMC | (N'0') | Yes | | TB_SVWERK | Allow NULL? |
| 13 | MONTH_END_MAT | Maturity Dates at Month End | char | 1 | 0 | CHAR | (N' ') | Yes | | /BA1/F4_DTE_MONTH_END_MATURITY | Allow NULL? |
| 14 | FWD_YCTYPE | Forward Yield Curve Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | /BA1/DV_TF4_YCTY | /BA1/F4_DTE_FWD_YCTYPE | Allow NULL? |
| 15 | XINTRAD | Reference Rate: Can be Used for Intraday Rates | char | 1 | 0 | CHAR | (N' ') | Yes | | /BA1/F4_DTE_IR_XINTRAD | Allow NULL? |
| 16 | FIXING_TIME | Interest Rate Fixed At (UTC) | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | /BA1/F4_DTE_FIXING_TIME | Allow NULL? |
| 17 | FIXING_TZ | Time Zone of Time Point at Which Rate was Fixed | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | TTZZ | /BA1/F4_DTE_FIXING_TIMEZONE | Allow NULL? |
