| 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 | TRNO | Tranche Number | nvarchar | 10 | 0 | CHAR | (N' ') | No | FILA_RE_TR_H | FILA_RE_E_TRNO | Allow NULL? |
| 3 | OBJID | Object Number | varbinary | 16 | 0 | RAW | | No | LAE_CRM_ITEMS | FILA_OBJID | |
| 4 | SUBID | Subobject Number | nvarchar | 5 | 0 | NUMC | (N'00000') | No | LAE_CRM_ITEMS | FILA_SUBID | Allow NULL? |
| 5 | TMSTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | DEC | ((0)) | No | LAE_CRM_ITEMS | TIMESTAMP | |
| 6 | VTYPE | Partner Contract Type of Source Document | char | 1 | 0 | CHAR | (N' ') | Yes | | FILA_RE_E_VTYPE | Allow NULL? |
| 7 | OBJECTID | Contract Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | FILA_REFOBJ | Allow NULL? |
| 8 | ITEMNO | Item Number | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | | FILA_ITEMNO | Allow NULL? |
| 9 | STATUS_TR_I | Status of Tranche Item Data (Refinancing) | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | FILA_RE_E_TRI_STAT | Allow NULL? |
| 10 | DAT_STATUS | Date of Status | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | FILA_RE_E_DAT_STATUS | Allow NULL? |
| 11 | PRESVAL | Present Value | decimal | 17 | 2 | CURR | ((0)) | Yes | | FILA_RE_E_PRESVAL | |
| 12 | RESVAL_S | Residual Value of Source Document | decimal | 17 | 2 | CURR | ((0)) | Yes | | FILA_RE_E_RESVAL_S | |
| 13 | RESVAL_T | Residual Value of Target Document | decimal | 17 | 2 | CURR | ((0)) | Yes | | FILA_RE_E_RESVAL_T | |
| 14 | ADD_AMOUNT | Additional Amount | decimal | 17 | 2 | CURR | ((0)) | Yes | | FILA_RE_E_ADD_AMOUNT | |
| 15 | DP_AMOUNT | Leasing Special Payment | decimal | 17 | 2 | CURR | ((0)) | Yes | | FILA_RE_E_DP_AMOUNT | |
| 16 | SALES_PRICE | Sales Price | decimal | 17 | 2 | CURR | ((0)) | Yes | | FILA_RE_E_SALES_PRICE | |
| 17 | RESIDUALTERM | Remaining Term | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | FILA_RE_E_RESIDUALTERM | Allow NULL? |
| 18 | INTEREST | Interest Rate for Refinancing | decimal | 10 | 7 | DEC | ((0)) | Yes | | FILA_RE_E_INTEREST | |
| 19 | INTEREST_INSTAL | Interest Rate for Present Value Calculation | decimal | 10 | 7 | DEC | ((0)) | Yes | | FILA_RE_E_INTEREST_INSTAL | |
| 20 | OUTSTAND_PAY | Total of Outstanding Payments | decimal | 17 | 2 | CURR | ((0)) | Yes | | FILA_RE_E_OUTSTAND_PAY | |
| 21 | PRGNO | Refinancing Program Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | FILA_RE_PRG | FILA_RE_E_PRGNO | Allow NULL? |
| 22 | DUE | Due Date of Return Transaction (Lease Refinancing) | char | 1 | 0 | NUMC | (N'0') | Yes | | FILA_RE_E_DUE | Allow NULL? |
| 23 | CLUSTER_TYP | Cluster Type in Refinancing | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | FILA_RE_E_CLUSTER_TYP | Allow NULL? |
| 24 | BUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T001 | BUKRS | Allow NULL? |
| 25 | RSTATUS_TR_I | Status of Tranche Item Data (Return Transaction) | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | FILA_RE_E_TRI_STAT_RET | Allow NULL? |
| 26 | CANCEL_REASON | Cancellation Reason | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | FILA_RE_E_CANCEL_REASON | Allow NULL? |
| 27 | RESVAL_MAN | Market Value at End of Refinancing | decimal | 17 | 2 | CURR | ((0)) | Yes | | FILA_RE_E_RESVAL_MAN | |
| 28 | SELMODE | Selection Mode for Return Transaction Report | char | 1 | 0 | CHAR | (N' ') | Yes | | FILA_RE_E_SELMODE | Allow NULL? |
| 29 | PVTYPE | Partner Contract Type of Target Document | char | 1 | 0 | CHAR | (N' ') | Yes | | FILA_RE_E_PVTYPE | Allow NULL? |
| 30 | PBUKRS | Company code of partner | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T001 | PBUKRS | Allow NULL? |
| 31 | POBJID | Object Number of Reference Object | varbinary | 16 | 0 | RAW | | Yes | | FILA_OBJID_REF | |
| 32 | PSUBID | Reference Sub-Object Number | nvarchar | 5 | 0 | NUMC | (N'00000') | Yes | | FILA_SUBID_REF | Allow NULL? |
| 33 | PTMSTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | DEC | ((0)) | Yes | | TIMESTAMP | |
| 34 | POBJECTID | Contract Number of Reference Object | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | FILA_RE_E_FILA_REFOBJ_REF | Allow NULL? |
| 35 | PITEMNO | Item Number of Reference Object | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | | FILA_RE_E_FILA_ITEMNO_REF | Allow NULL? |
| 36 | CREATED_AT | Created On | decimal | 15 | 0 | DEC | ((0)) | Yes | | FILA_RE_E_CREATED_AT | |
| 37 | CREATED_BY | Created By | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | FILA_RE_E_CREATED_BY | Allow NULL? |
| 38 | CHANGED_AT | Changed On | decimal | 15 | 0 | DEC | ((0)) | Yes | | FILA_RE_E_CHANGED_AT | |
| 39 | CHANGED_BY | Changed By | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | FILA_RE_E_CHANGED_BY | Allow NULL? |
