| 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 | PRGNO | Refinancing Program Number | nvarchar | 10 | 0 | CHAR | (N' ') | No | | FILA_RE_E_PRGNO | Allow NULL? |
| 3 | REFICAT | Refinancing Category | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TFILA_RE_CAT | FILA_RE_E_REFICAT | Allow NULL? |
| 4 | BUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T001 | BUKRS | Allow NULL? |
| 5 | PBUKRS | Company code of partner | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T001 | PBUKRS | Allow NULL? |
| 6 | CURRENCY | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | WAERS | Allow NULL? |
| 7 | GP_DEB_FIN | Customer Number of Financing Party for Refinancing | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | KNA1 | FILA_RE_E_GP_DEB_FIN | Allow NULL? |
| 8 | GP_CRED_FIN | Vendor Number of Financing Party for Refinancing | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | LFA1 | FILA_RE_E_GP_CRED_FIN | Allow NULL? |
| 9 | GP_DEB_SALB | Customer Number of Sales Company for Object Company | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | KNA1 | FILA_RE_E_GP_DEB_SALB | Allow NULL? |
| 10 | GP_CRED_SALB | Vendor Number of Sales Company for Object Company | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | LFA1 | FILA_RE_E_GP_CRED_SALB | Allow NULL? |
| 11 | FROMDATE | Valid-from date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | FROMDATE | Allow NULL? |
| 12 | TODATE | Valid to Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | TODATE | Allow NULL? |
| 13 | INTEREST | Interest Rate for Refinancing | decimal | 10 | 7 | DEC | ((0)) | Yes | | FILA_RE_E_INTEREST | |
| 14 | INTEREST_INSTAL | Interest Rate for Present Value Calculation | decimal | 10 | 7 | DEC | ((0)) | Yes | | FILA_RE_E_INTEREST_INSTAL | |
| 15 | PRESVAL_MIN | Minimum Present Value per Contract | decimal | 17 | 2 | CURR | ((0)) | Yes | | FILA_RE_E_PRESVAL_MIN | |
| 16 | PRESVAL_MIN_TR | Minimum Present Value per Tranche | decimal | 17 | 2 | CURR | ((0)) | Yes | | FILA_RE_E_PRESVAL_MIN_TR | |
| 17 | PRESVAL_MAX_PRG | Maximum Present Value per Refinancing Program | decimal | 17 | 2 | CURR | ((0)) | Yes | | FILA_RE_E_PRESVAL_MAX_PRG | |
| 18 | PAYMENT_FORM | Payment Form (Period Start, Mid-Period, Period End, Other) | char | 1 | 0 | NUMC | (N'0') | Yes | | TFM_SZAWS | Allow NULL? |
| 19 | TFM_PERIODICITY | Periods | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | TFM_PERIODICITY | Allow NULL? |
| 20 | VVSINCL | Inclusive indicator for beginning and end of a period | char | 1 | 0 | NUMC | (N'0') | Yes | | VVSINCL | Allow NULL? |
| 21 | TB_JZINSRE | Exponential Interest Calculation | char | 1 | 0 | CHAR | (N' ') | Yes | | TB_JZINSRE | Allow NULL? |
| 22 | TFM_AMMRHYZV | Interest Settlement Frequency for Exponential Interest Calc. | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | TFM_AMMRHYZV | Allow NULL? |
| 23 | SZBMETH | Interest Calculation Method | char | 1 | 0 | CHAR | (N' ') | Yes | | SZBMETH | Allow NULL? |
