| 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_GUID | GUID for securities account | varbinary | 16 | 0 | | | | |
| 3 | DEPO_BANK_ID | Depository Bank Identification | nvarchar | 18 | 0 | | | | Allow NULL? |
| 4 | ACCOUNT_NUMBER | Securities Account Identification Number | nvarchar | 20 | 0 | | | | Allow NULL? |
| 5 | SEC_ACC_DESC | Description of the Securities Account | nvarchar | 30 | 0 | | | | Allow NULL? |
| 6 | ACC_OLD_REF_NO | ID of a Securities Account Referenced from External System | nvarchar | 32 | 0 | | | | Allow NULL? |
| 7 | SEC_ACC_VAL | Value of the Securities Account | decimal | 17 | 2 | | | | |
| 8 | SEC_ACC_VAL_CURR | Currency of Securities Account Value | nvarchar | 5 | 0 | | | | Allow NULL? |
| 9 | VAL_DATE | Date of last valuation | nvarchar | 8 | 0 | | | | Allow NULL? |
| 10 | ADMIN_ORG_UNIT | Administration Organizational Unit | nvarchar | 12 | 0 | | | | Allow NULL? |
| 11 | BANKAREA | Bank Area in Collateral Management | nvarchar | 4 | 0 | | | | Allow NULL? |
| 12 | RISK_CODE | Risk Code | nvarchar | 6 | 0 | | | | Allow NULL? |
| 13 | SFTY_IND | Indicates that the asset has a default sfty discount or not | nvarchar | 2 | 0 | | | | Allow NULL? |
| 14 | SFTY_DSCNT | Safety discount | decimal | 10 | 6 | | | | |
| 15 | SFTY_AMOUNT | Safety discount as an amount | decimal | 17 | 2 | | | | |
| 16 | SFTY_AMT_CURR | Currency of the Safety discount amount | nvarchar | 5 | 0 | | | | Allow NULL? |
| 17 | UNIT_VALN_FREQ | Indicator : Valuation Frequency of Securities Account | nvarchar | 2 | 0 | | | | Allow NULL? |
| 18 | PERIOD_VALN_FREQ | Period of revaluation for securities | nvarchar | 4 | 0 | | | | Allow NULL? |
| 19 | START_DATE | Valuation Start date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 20 | END_DATE | Valuation End date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 21 | LENDING_RATE_IND | Indicates that the asset has a default lending rate or not | nvarchar | 2 | 0 | | | | Allow NULL? |
| 22 | LENDING_RATE1 | Lending rate 1 | decimal | 10 | 6 | | | | |
| 23 | LIQD_TYP | Liquidation type | nvarchar | 6 | 0 | | | | Allow NULL? |
| 24 | LIQD_REASON | Liquidation Reason | nvarchar | 6 | 0 | | | | Allow NULL? |
| 25 | LIQD_DATE | Date of Liquidation of Collateral | nvarchar | 8 | 0 | | | | Allow NULL? |
| 26 | LIQD_AMT | Proceeds obtained from liquidation of the collateral | decimal | 17 | 2 | | | | |
| 27 | LIQD_CURR | Currency of Liquidation value | nvarchar | 5 | 0 | | | | Allow NULL? |
| 28 | ORG_UNIT1 | Organizational Unit 1: Assets | nvarchar | 10 | 0 | | | | Allow NULL? |
| 29 | ORG_UNIT2 | Organizational Unit 2: Assets | nvarchar | 10 | 0 | | | | Allow NULL? |
| 30 | ORG_UNIT3 | Organizational Unit 3: Assets | nvarchar | 10 | 0 | | | | Allow NULL? |
| 31 | ORG_UNIT4 | Organizational Unit 4: Assets | nvarchar | 10 | 0 | | | | Allow NULL? |
| 32 | ORG_UNIT5 | Organizational Unit 5: Assets | nvarchar | 10 | 0 | | | | Allow NULL? |
| 33 | CREATED_BY | Securities Add-On User | nvarchar | 12 | 0 | | | | Allow NULL? |
| 34 | CREATED_DATE | Created On | nvarchar | 8 | 0 | | | | Allow NULL? |
| 35 | CREATED_TIME | Created At | nvarchar | 6 | 0 | | | | Allow NULL? |
| 36 | LAST_CHG_BY | Last Changed By | nvarchar | 12 | 0 | | | | Allow NULL? |
| 37 | LAST_CHG_DATE | Last Changed on | nvarchar | 8 | 0 | | | | Allow NULL? |
| 38 | LAST_CHG_TIME | Last Changed At | nvarchar | 6 | 0 | | | | Allow NULL? |
