| 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 | RSICHER | Collateral reference number | nvarchar | 8 | 0 | NUMC | (N'00000000') | No | | RSICHER | Allow NULL? |
| 3 | RERF | Entered by | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | RERF | Allow NULL? |
| 4 | DERF | First Entered on | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DERF | Allow NULL? |
| 5 | TERF | Time of Initial Entry | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | TERF | Allow NULL? |
| 6 | REHER | Source of initial entry | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | REHER | Allow NULL? |
| 7 | RBEAR | Employee ID | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | RBEAR | Allow NULL? |
| 8 | DBEAR | Last Edited on | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DBEAR | Allow NULL? |
| 9 | TBEAR | Last Edited at | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | TBEAR | Allow NULL? |
| 10 | RBHER | Editing Source | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | RBHER | Allow NULL? |
| 11 | SSICH | Collateral type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TD01 | SSICH | Allow NULL? |
| 12 | SSICHART | Category Of Collateral Group (Internal) | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | SSICHART | Allow NULL? |
| 13 | XWPKN | Securities ID number (Display PRF5) | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | XWPKN | Allow NULL? |
| 14 | WAERS | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | WAERS | Allow NULL? |
| 15 | BKURSWRT | Market value of a security according to stmnt in PRF5 | decimal | 13 | 2 | CURR | ((0)) | Yes | | BKURSWRT | |
| 16 | DKURSWRT | Date of valuation at market value | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DKURSWRT | Allow NULL? |
| 17 | BNEWE | Nominal value per share | decimal | 10 | 2 | CURR | ((0)) | Yes | | BNEWE | |
| 18 | BWKUR | Security price for unit quotation | decimal | 13 | 2 | CURR | ((0)) | Yes | | BWKURS | |
| 19 | PKUR | Price in percent | decimal | 10 | 7 | DEC | ((0)) | Yes | | PKUR | |
| 20 | ASTUECK | Number of units for unit-quoted securities | decimal | 15 | 5 | DEC | ((0)) | Yes | | ASTUECK | |
| 21 | BNOMS | Nominal value | decimal | 13 | 2 | CURR | ((0)) | Yes | | BNOMS | |
| 22 | XALKZ | Short name | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | XALKZ | Allow NULL? |
| 23 | XALLB | Long name | nvarchar | 60 | 0 | CHAR | (N' ') | Yes | | XALLB | Allow NULL? |
| 24 | XEMIT | Name of issuer (info) | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | XEMIT | Allow NULL? |
| 25 | PNOMZINS | Nominal interest rate | decimal | 10 | 7 | DEC | ((0)) | Yes | | PNOMZINS | |
| 26 | DEBEG | Issue start date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DEBEG | Allow NULL? |
| 27 | XSERIE | Issue serial number | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | XSERIE | Allow NULL? |
| 28 | XREIHE | Issue Series | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | XREIHE | Allow NULL? |
| 29 | SVERWA | Custody type | char | 1 | 0 | CHAR | (N' ') | Yes | * | SVERWA | Allow NULL? |
| 30 | XDKBZ | Sec.acct position short description | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | XDKBZ | Allow NULL? |
| 31 | DBLFZ | Start of Term | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DBLFZ | Allow NULL? |
| 32 | DELFZ | End of Term | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DELFZ | Allow NULL? |
| 33 | XAKT | File Number | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | XAKT | Allow NULL? |
| 34 | KOMM1 | Name | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | XLBEZ | Allow NULL? |
| 35 | KOMM2 | Name | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | XLBEZ | Allow NULL? |
| 36 | RLDEPO | Securities Account | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | RLDEPO | Allow NULL? |
| 37 | DURUEB | Date of document transfer/date of entry in debt register | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | VVDURUEB | Allow NULL? |
| 38 | BBWHR | Amount in position currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | BBWHR | |
| 39 | SLAENDER | Country ID | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T005 | SLAENDER | Allow NULL? |
