| 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 | KEY_DATE | Position Value Date | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | TPM_POSITION_DATE | Allow NULL? |
| 3 | COMPANY_CODE | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | No | * | BUKRS | Allow NULL? |
| 4 | COM_VAL_CLASS | General Valuation Class | nvarchar | 4 | 0 | NUMC | (N'0000') | No | TRGC_COM_VALCL | TPM_COM_VAL_CLASS | Allow NULL? |
| 5 | VALUATION_AREA | Valuation Area | nvarchar | 3 | 0 | CHAR | (N' ') | No | * | TPM_VAL_AREA | Allow NULL? |
| 6 | DEAL_NUMBER | Financial Transaction | nvarchar | 13 | 0 | CHAR | (N' ') | No | * | TB_RFHA | Allow NULL? |
| 7 | FUND | Fund | nvarchar | 10 | 0 | CHAR | (N' ') | No | * | FM_FUND | Allow NULL? |
| 8 | GRANT_NBR | Grant | nvarchar | 20 | 0 | CHAR | (N' ') | No | | GM_GRANT_NBR | Allow NULL? |
| 9 | POSNR | Item Number Legacy Data Transfer | nvarchar | 8 | 0 | NUMC | (N'00000000') | No | | TPM_TRDT_POSNR | Allow NULL? |
| 10 | POSITION_CURR | Position Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | TPM_POSITION_CURR | Allow NULL? |
| 11 | VALUATION_CURR | Valuation Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | TPM_VALUATION_CURR | Allow NULL? |
| 12 | VAL_TI_PC | Security Valuation in Position Currency | decimal | 21 | 2 | CURR | ((0)) | Yes | | TPM_VAL_TI_PC | |
| 13 | VAL_TI_VC | Security Valuation in Valuation Currency | decimal | 21 | 2 | CURR | ((0)) | Yes | | TPM_VAL_TI_VC | |
| 14 | VAL_FX_VC | Foreign Currency Valuation in Valuation Currency | decimal | 21 | 2 | CURR | ((0)) | Yes | | TPM_VAL_FX_VC | |
| 15 | VAL_CH_TI_PC | Valuation of Cap. Costs, Security, in Position Currency | decimal | 21 | 2 | CURR | ((0)) | Yes | | TPM_VAL_CH_TI_PC | |
| 16 | VAL_CH_TI_VC | Valuation of Cap. Costs, Security, in Valuation Currency | decimal | 21 | 2 | CURR | ((0)) | Yes | | TPM_VAL_CH_TI_VC | |
| 17 | VAL_CH_FX_VC | Valuation of Capitalized Costs, FX, in Valuation Currency | decimal | 21 | 2 | CURR | ((0)) | Yes | | TPM_VAL_CH_FX_VC | |
| 18 | IMPAIRMENT_PC | Impairment in Position Currency | decimal | 21 | 2 | CURR | ((0)) | Yes | | TPM_IMPAIRMENT_PC | |
| 19 | IMPAIRMENT_VC | Impairment in Valuation Currency | decimal | 21 | 2 | CURR | ((0)) | Yes | | TPM_IMPAIRMENT_VC | |
| 20 | AMORT_PC | Amortization in Position Currency | decimal | 21 | 2 | CURR | ((0)) | Yes | | TPM_AMORT_PC | |
| 21 | AMORT_VC | Amortization in Valuation Currency | decimal | 21 | 2 | CURR | ((0)) | Yes | | TPM_AMORT_VC | |
| 22 | VAL_TI_PC_NPL | Securities Valuation Not Affecting P/L in Position Currency | decimal | 21 | 2 | CURR | ((0)) | Yes | | TPM_VAL_TI_PC_NPL | |
| 23 | VAL_TI_VC_NPL | Securities Valuation Not Affecting P/L in Valuation Currency | decimal | 21 | 2 | CURR | ((0)) | Yes | | TPM_VAL_TI_VC_NPL | |
| 24 | VAL_FX_VC_NPL | Forex Valuation Not Affecting P/L in Valuation Currency | decimal | 21 | 2 | CURR | ((0)) | Yes | | TPM_VAL_FX_VC_NPL | |
| 25 | VAL_CH_TI_PC_NPL | Security Costs Valuation Not Affecting P/L in Position Crcy | decimal | 21 | 2 | CURR | ((0)) | Yes | | TPM_VAL_CH_TI_PC_NPL | |
| 26 | VAL_CH_TI_VC_NPL | Security Costs Valuation Not Affecting P/L in Valuation Crcy | decimal | 21 | 2 | CURR | ((0)) | Yes | | TPM_VAL_CH_TI_VC_NPL | |
| 27 | VAL_CH_FX_VC_NPL | Forex Costs Valuation Not Affecting P/L in Valuation Crcy | decimal | 21 | 2 | CURR | ((0)) | Yes | | TPM_VAL_CH_FX_VC_NPL | |
| 28 | VAL_PURCH_VC | Purchase Currency Valuation in Valuation Currency | decimal | 21 | 2 | CURR | ((0)) | Yes | | TPM_VAL_PURCH_VC | |
| 29 | VAL_SALE_VC | Sale Currency Valuation in Valuation Currency | decimal | 21 | 2 | CURR | ((0)) | Yes | | TPM_VAL_SALE_VC | |
| 30 | VAL_MS_DEF_PC | Margin/Swap Deferral in Position Currency | decimal | 21 | 2 | CURR | ((0)) | Yes | | TPM_VAL_MS_DEF_PC | |
| 31 | VAL_MS_DEF_VC | Margin/Swap Deferral in Valuation Currency | decimal | 21 | 2 | CURR | ((0)) | Yes | | TPM_VAL_MS_DEF_VC | |
| 32 | VAL_SWAP_VC | Swap Accrual/Deferral in Valuation Currency | decimal | 21 | 2 | CURR | ((0)) | Yes | | TPM_VAL_SWAP_VC | |
| 33 | ACCR_PC | Accrual/Deferral in Position Currency | decimal | 21 | 2 | CURR | ((0)) | Yes | | TPM_ACCR_PC | |
| 34 | ACCR_VC | Accrual/Deferral in Valuation Currency | decimal | 21 | 2 | CURR | ((0)) | Yes | | TPM_ACCR_VC | |
| 35 | ACCR2_PC | Accrual/Deferral (2) in Position Currency | decimal | 21 | 2 | CURR | ((0)) | Yes | | TPM_ACCR2_PC | |
| 36 | ACCR2_VC | Accrual/Deferral (2) in Valuation Currency | decimal | 21 | 2 | CURR | ((0)) | Yes | | TPM_ACCR2_VC | |
| 37 | RESET_VAL | Valuation with Reset | char | 1 | 0 | CHAR | (N' ') | Yes | | TPM_TRDT_RESET_VAL | Allow NULL? |
| 38 | RESET_ACCR | Accrual/Deferral with Reset | char | 1 | 0 | CHAR | (N' ') | Yes | | TPM_TRDT_RESET_ACCR | Allow NULL? |
| 39 | RESET_KEY_DATE | Key Date for Reset within Legacy Data Transfer | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | TPM_TRDT_RESET_KEYDATE | Allow NULL? |
| 40 | BUSTRANSID | Identifier of the Distributor Business Transaction | varbinary | 16 | 0 | RAW | | Yes | | TPM_BUSTRANSID | |
| 41 | TRANS_FLG | Flag: Legacy Data Transferred | char | 1 | 0 | CHAR | (N' ') | Yes | | TPM_TRDT_TRANS_FLG | Allow NULL? |
| 42 | HADJ_PC | Hedge Adjustment in Position Currency | decimal | 21 | 2 | CURR | ((0)) | Yes | | FTI_HADJ_PC | |
| 43 | HADJ_IDXCL_PC | Hedge Adjustment in Position Currency, Index-Clean | decimal | 21 | 2 | CURR | ((0)) | Yes | | FTI_HADJ_INDX_PC | |
| 44 | HADJ_VC | Hedge Adjustment in Valuation Currency | decimal | 21 | 2 | CURR | ((0)) | Yes | | FTI_HADJ_VC | |
| 45 | EFF_PC | Effective Amount in Position Currency | decimal | 21 | 2 | CURR | ((0)) | Yes | | FTI_EFFECTIVE_PC | |
| 46 | EFF_VC | Effective Amount in Valuation Currency | decimal | 21 | 2 | CURR | ((0)) | Yes | | FTI_EFFECTIVE_VC | |
| 47 | EFF_IDXCL_PC | Effective Amount in Position Currency, Index Clean | decimal | 21 | 2 | CURR | ((0)) | Yes | | FTI_EFFECTIVE_IDXCL_PC | |
| 48 | INEFF_PC | Ineffective Amount in Position Currency | decimal | 21 | 2 | CURR | ((0)) | Yes | | FTI_INEFFECTIVE_PC | |
| 49 | INEFF_VC | Ineffective Amount in Valuation Currency | decimal | 21 | 2 | CURR | ((0)) | Yes | | FTI_INEFFECTIVE_VC | |
| 50 | INEFF_IDXCL_PC | Ineffective Amount in Position Currency, Index Clean | decimal | 21 | 2 | CURR | ((0)) | Yes | | FTI_INEFFECTIVE_IDXCL_PC | |
| 51 | EFFD_PC | Effective Amount (Dormant) in Position Currency | decimal | 21 | 2 | CURR | ((0)) | Yes | | FTI_EFFECTIVE_DORMANT_PC | |
| 52 | EFFD_VC | Effective Amount (Dormant) in Valuation Currency | decimal | 21 | 2 | CURR | ((0)) | Yes | | FTI_EFFECTIVE_DORMANT_VC | |
| 53 | EFFD_IDXCL_PC | Effective Amount (Dormant) in Position Currency, Index-Clean | decimal | 21 | 2 | CURR | ((0)) | Yes | | FTI_EFFECTIVE_DORMANT_IDXCL_PC | |
| 54 | INEFFD_PC | Ineffective Amount (Dormant) in Position Currency | decimal | 21 | 2 | CURR | ((0)) | Yes | | FTI_INEFFECTIVE_DORMANT_PC | |
| 55 | INEFFD_VC | Ineffective Amount (Dormant) in Valuation Currency | decimal | 21 | 2 | CURR | ((0)) | Yes | | FTI_INEFFECTIVE_DORMANT_VC | |
| 56 | INEFFD_IDXCL_PC | Ineffective Amount (Dormant) in Position Currency, Index-Cln | decimal | 21 | 2 | CURR | ((0)) | Yes | | FTI_INEFF_DORMANT_IDXCL_PC | |
| 57 | INT_INCOME_PC | Interest Income in Position Currency | decimal | 21 | 2 | CURR | ((0)) | Yes | | FTI_INT_INCOME_PC | |
| 58 | INT_INCOME_VC | Interest Income in Valuation Currency | decimal | 21 | 2 | CURR | ((0)) | Yes | | FTI_INT_INCOME_VC | |
| 59 | DISAGIO_PC | Discount/Premium in Position Currency | decimal | 21 | 2 | CURR | ((0)) | Yes | | TPM_DISAGIO_PC | |
| 60 | DISAGIO_VC | Discount/Premium in Valuation Currency | decimal | 21 | 2 | CURR | ((0)) | Yes | | TPM_DISAGIO_VC | |
| 61 | RESET_AMORT | Amortization with Reset | char | 1 | 0 | CHAR | (N' ') | Yes | | TPM_TRDT_RESET_AMORT | Allow NULL? |