| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | SEC_ACC_POS_GUID | GUID for securities positions in an account | varbinary | 16 | 0 | | | | |
| 3 | SEC_ACC_GUID | GUID for securities account | varbinary | 16 | 0 | | | | |
| 4 | POS_NO | Sequence Number of a Position in a Securities Account | nvarchar | 4 | 0 | | | | Allow NULL? |
| 5 | POS_OLD_REF_NO | ID of a Positiion Referenced from an External System | nvarchar | 32 | 0 | | | | Allow NULL? |
| 6 | ISIN | Unique ID for a Position in a Securities Account | nvarchar | 20 | 0 | | | | Allow NULL? |
| 7 | NO_OF_UNITS | Number of Units in a Securities Position | decimal | 15 | 5 | | | | |
| 8 | NOMINAL_VALUE | Nominal Value of a Position | decimal | 17 | 2 | | | | |
| 9 | NOMINAL_VAL_CURR | Currency of nominal value of a position | nvarchar | 5 | 0 | | | | Allow NULL? |
| 10 | CURRENT_PRICE | Current Price of a Securities Postion per Unit | decimal | 17 | 2 | | | | |
| 11 | CURR_PRICE_CURR | Currency of Current Price of a Securities Position | nvarchar | 5 | 0 | | | | Allow NULL? |
| 12 | CURR_PRICE_PCT | Current Price of a Unit of a Securities Position | decimal | 10 | 6 | | | | |
| 13 | CURR_PRICE_AT | Position value recording Timestamp | nvarchar | 15 | 0 | | | | Allow NULL? |
| 14 | MARKET_VALUE | Market Value of a Securities Position | decimal | 17 | 2 | | | | |
| 15 | MARKET_VAL_CURR | Currency of the Market Value of Securities Positions | nvarchar | 5 | 0 | | | | Allow NULL? |
| 16 | CON_MKT_VAL | Market Value of a Securities Account Position | decimal | 17 | 2 | | | | |
| 17 | CON_MKT_VAL_CURR | Currency of Converted Market Value of Positions | nvarchar | 5 | 0 | | | | Allow NULL? |
| 18 | RISK_CODE | Risk Code | nvarchar | 6 | 0 | | | | Allow NULL? |
| 19 | SFTY_IND | Indicates that the asset has a default sfty discount or not | nvarchar | 2 | 0 | | | | Allow NULL? |
| 20 | SFTY_DSCNT | Safety discount | decimal | 10 | 6 | | | | |
| 21 | SFTY_AMOUNT | Safety discount as an amount | decimal | 17 | 2 | | | | |
| 22 | SFTY_AMT_CURR | Currency of the Safety discount amount | nvarchar | 5 | 0 | | | | Allow NULL? |
| 23 | LENDING_RATE_IND | Indicates that the asset has a default lending rate or not | nvarchar | 2 | 0 | | | | Allow NULL? |
| 24 | LENDING_RATE1 | Lending rate 1 | decimal | 10 | 6 | | | | |
| 25 | LIQD_TYP | Liquidation type | nvarchar | 6 | 0 | | | | Allow NULL? |
| 26 | LIQD_REASON | Liquidation Reason | nvarchar | 6 | 0 | | | | Allow NULL? |
| 27 | LIQD_DATE | Date of Liquidation of Collateral | nvarchar | 8 | 0 | | | | Allow NULL? |
| 28 | LIQD_AMT | Proceeds obtained from liquidation of the collateral | decimal | 17 | 2 | | | | |
| 29 | LIQD_CURR | Currency of Liquidation value | nvarchar | 5 | 0 | | | | Allow NULL? |
| 30 | CREATED_BY | Securities Add-On User | nvarchar | 12 | 0 | | | | Allow NULL? |
| 31 | CREATED_DATE | Created On | nvarchar | 8 | 0 | | | | Allow NULL? |
| 32 | CREATED_TIME | Created At | nvarchar | 6 | 0 | | | | Allow NULL? |
| 33 | LAST_CHG_BY | Last Changed By | nvarchar | 12 | 0 | | | | Allow NULL? |
| 34 | LAST_CHG_DATE | Last Changed on | nvarchar | 8 | 0 | | | | Allow NULL? |
| 35 | LAST_CHG_TIME | Last Changed At | nvarchar | 6 | 0 | | | | Allow NULL? |
