| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | TRNO | Tranche Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 3 | OBJID | Object Number | varbinary | 16 | 0 | | | | |
| 4 | SUBID | Subobject Number | nvarchar | 5 | 0 | | | | Allow NULL? |
| 5 | TMSTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | | | |
| 6 | VTYPE | Partner Contract Type of Source Document | char | 1 | 0 | | | | Allow NULL? |
| 7 | OBJECTID | Contract Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 8 | ITEMNO | Item Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 9 | STATUS_TR_I | Status of Tranche Item Data (Refinancing) | nvarchar | 2 | 0 | | | | Allow NULL? |
| 10 | DAT_STATUS | Date of Status | nvarchar | 8 | 0 | | | | Allow NULL? |
| 11 | PRESVAL | Present Value | decimal | 17 | 2 | | | | |
| 12 | RESVAL_S | Residual Value of Source Document | decimal | 17 | 2 | | | | |
| 13 | RESVAL_T | Residual Value of Target Document | decimal | 17 | 2 | | | | |
| 14 | ADD_AMOUNT | Additional Amount | decimal | 17 | 2 | | | | |
| 15 | DP_AMOUNT | Leasing Special Payment | decimal | 17 | 2 | | | | |
| 16 | SALES_PRICE | Sales Price | decimal | 17 | 2 | | | | |
| 17 | RESIDUALTERM | Remaining Term | nvarchar | 3 | 0 | | | | Allow NULL? |
| 18 | INTEREST | Interest Rate for Refinancing | decimal | 10 | 7 | | | | |
| 19 | INTEREST_INSTAL | Interest Rate for Present Value Calculation | decimal | 10 | 7 | | | | |
| 20 | OUTSTAND_PAY | Total of Outstanding Payments | decimal | 17 | 2 | | | | |
| 21 | PRGNO | Refinancing Program Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 22 | DUE | Due Date of Return Transaction (Lease Refinancing) | char | 1 | 0 | | | | Allow NULL? |
| 23 | CLUSTER_TYP | Cluster Type in Refinancing | nvarchar | 2 | 0 | | | | Allow NULL? |
| 24 | BUKRS | Company Code | nvarchar | 4 | 0 | | | | Allow NULL? |
| 25 | RSTATUS_TR_I | Status of Tranche Item Data (Return Transaction) | nvarchar | 2 | 0 | | | | Allow NULL? |
| 26 | CANCEL_REASON | Cancellation Reason | nvarchar | 4 | 0 | | | | Allow NULL? |
| 27 | RESVAL_MAN | Market Value at End of Refinancing | decimal | 17 | 2 | | | | |
| 28 | SELMODE | Selection Mode for Return Transaction Report | char | 1 | 0 | | | | Allow NULL? |
| 29 | PVTYPE | Partner Contract Type of Target Document | char | 1 | 0 | | | | Allow NULL? |
| 30 | PBUKRS | Company code of partner | nvarchar | 4 | 0 | | | | Allow NULL? |
| 31 | POBJID | Object Number of Reference Object | varbinary | 16 | 0 | | | | |
| 32 | PSUBID | Reference Sub-Object Number | nvarchar | 5 | 0 | | | | Allow NULL? |
| 33 | PTMSTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | | | |
| 34 | POBJECTID | Contract Number of Reference Object | nvarchar | 10 | 0 | | | | Allow NULL? |
| 35 | PITEMNO | Item Number of Reference Object | nvarchar | 10 | 0 | | | | Allow NULL? |
| 36 | CREATED_AT | Created On | decimal | 15 | 0 | | | | |
| 37 | CREATED_BY | Created By | nvarchar | 12 | 0 | | | | Allow NULL? |
| 38 | CHANGED_AT | Changed On | decimal | 15 | 0 | | | | |
| 39 | CHANGED_BY | Changed By | nvarchar | 12 | 0 | | | | Allow NULL? |
