| 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 | DERIV_TRANS_OID | Object Identity in Database Format | nvarchar | 32 | 0 | CHAR | (N' ') | No | TRLT_DERIVTRANS | TPM_DB_OS_GUID | Allow NULL? |
| 3 | DERIV_FLOWNUMBER | Number of TRL Flow | int | 10 | 0 | INT4 | ((0)) | No | | TPM_TRLDERIVFLOWNR | Allow NULL? |
| 4 | POSITION_OID | Object Identity in Database Format | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | TRLT_POSITION | TPM_DB_OS_GUID | Allow NULL? |
| 5 | SUBPOSITION_OID | Globally Unique Identifier | varbinary | 16 | 0 | RAW | | Yes | | OS_GUID | |
| 6 | DIST_FLOW_NUMBER | Number of a Distributor Flow | int | 10 | 0 | INT4 | ((0)) | Yes | | TPM_TRDFLOWNR | Allow NULL? |
| 7 | POS_MAN_PROC | Position Management Procedure | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | TPM_POS_MAN_PROC | Allow NULL? |
| 8 | DERIV_METHOD | Derivation Method | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | TPM_DERIV_METHOD | Allow NULL? |
| 9 | UNITS | Units | decimal | 22 | 6 | DEC | ((0)) | Yes | | TPM_UNITS | |
| 10 | NOMINAL_CURR | Nominal Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | TPM_NOMINAL_CURR | Allow NULL? |
| 11 | NOMINAL_AMT | Nominal Amount | decimal | 21 | 2 | CURR | ((0)) | Yes | | TPM_NOMINAL_AMT | |
| 12 | NOMINAL_ORG_AMT | Original Nominal Amount in Position Currency | decimal | 21 | 2 | CURR | ((0)) | Yes | | TPM_NOMINAL_ORG_AMT | |
| 13 | POSITION_CURR | Position Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | TPM_POSITION_CURR | Allow NULL? |
| 14 | POSITION_AMT | Amount (Position Currency) | decimal | 21 | 2 | CURR | ((0)) | Yes | | TPM_POSITION_AMT | |
| 15 | POSAMT_IDX_CLEAN | Amount in Position Currency Index-Clean | decimal | 21 | 2 | CURR | ((0)) | Yes | | TPM_POSITION_AMT_IDX_CLEAN | |
| 16 | VALUATION_CURR | Valuation Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | TPM_VALUATION_CURR | Allow NULL? |
| 17 | VALUATION_AMT | Amount in Valuation Currency | decimal | 21 | 2 | CURR | ((0)) | Yes | | TPM_VALUATION_AMT | |
| 18 | AMT_PM_CAT | Position Change Category | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | TPM_AMT_PM_CAT | Allow NULL? |
| 19 | QUANT_CAT | Position Change Category: Quantity | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | TPM_QTY_PM_CAT | Allow NULL? |
| 20 | DIST_FLOWTYPE | Update Type | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | * | TPM_DIS_FLOWTYPE | Allow NULL? |
| 21 | SOURCETARGET_FLG | Indicator: Source or Target of a Flow | char | 1 | 0 | CHAR | (N' ') | Yes | | TPM_SOURCE_TARGET_FLG | Allow NULL? |
| 22 | TRANSFER_GROUP | Group of Flows from a Source or Target | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | TPM_TRANSFER_GROUP | Allow NULL? |
| 23 | EFF_INT_RATE_U | For Calculation of Amortization Amts (SAC) for Used EffInR | decimal | 10 | 7 | DEC | ((0)) | Yes | | TPM_TRL_EFF_INT_RATE_USED | |
| 24 | SCHED_EFF_RATE | Key for Redemption Schedule that Explains Effect. Int. Rate | int | 10 | 0 | INT4 | ((0)) | Yes | | RDPT_SCHEDULE_KEY_EFF_RATE | Allow NULL? |
| 25 | EFF_INT_RATE_N | Valid Effective Interest Rate for the Next Amortization | decimal | 10 | 7 | DEC | ((0)) | Yes | | TPM_TRL_EFF_INT_RATE_NEW | |
| 26 | SCHED_FIX | Key for Fixed Redemption Schedule | int | 10 | 0 | INT4 | ((0)) | Yes | | RDPT_SCHEDULE_KEY_FIX | Allow NULL? |
| 27 | SUB_SOURCETARGET | Source or Target of Subposition Transfer | char | 1 | 0 | CHAR | (N' ') | Yes | | TPM_SUB_SOURCE_TARGET | Allow NULL? |
| 28 | SUB_TRANSFERGRP | Group of Flows in Subposition Transfer | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | TPM_SUB_TRANSFER_GROUP | Allow NULL? |
| 29 | EFFTEST_RESULT | Result of Effectiveness Test for Flows | char | 1 | 0 | NUMC | (N'0') | Yes | | TPM_EFFTEST_RESULTFORFLOWS | Allow NULL? |
