| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | PRT_ACS_GUID | GUID for part accessory | varbinary | 16 | 0 | | | | |
| 3 | OBJ_PRT_GUID | GUID for Object part | varbinary | 16 | 0 | | | | |
| 4 | PART_ID | Part ID for the Object | nvarchar | 10 | 0 | | | | Allow NULL? |
| 5 | ACS_TYPE | Accessory Type | nvarchar | 6 | 0 | | | | Allow NULL? |
| 6 | NO_OF_ACS | No of Accessory Units | int | 10 | 0 | | | | Allow NULL? |
| 7 | ACS_VALUE | Value of the Accessory | decimal | 17 | 2 | | | | |
| 8 | ACS_VALUE_CURR | Currency for Value of the accessory | nvarchar | 5 | 0 | | | | Allow NULL? |
| 9 | IS_SUB_AST_CREA | Indicates whether a Sub-asset is created for Building Part | char | 1 | 0 | | | | Allow NULL? |
| 10 | ACS_DESC | Description of the cost | nvarchar | 30 | 0 | | | | Allow NULL? |
| 11 | ACS_ID | Sequence Number of Accessory or Special Equipment | 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 | VALUATION_TYP | Type of Check conducted on the object | nvarchar | 2 | 0 | | | | Allow NULL? |
| 18 | UNIT_VALN_FREQ | Indicator : Valuation Period | nvarchar | 2 | 0 | | | | Allow NULL? |
| 19 | PERIOD_VALN_FREQ | Period of revaluation for a real estate | nvarchar | 4 | 0 | | | | Allow NULL? |
| 20 | PAST_VALUED_DATE | Most Recent Date on which the Real Estate was last Valued | nvarchar | 8 | 0 | | | | Allow NULL? |
| 21 | START_DATE | Revaluation Start date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 22 | END_DATE | End date for Revaluation of the Real Estate | nvarchar | 8 | 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 | LENDING_RATE2 | Lending rate 2 | decimal | 10 | 6 | | | | |
| 26 | LENDING_RATE3 | Lending rate 3 | decimal | 10 | 6 | | | | |
| 27 | LENDING_RATE4 | Lending rate 4 | decimal | 10 | 6 | | | | |
| 28 | LENDING_RATE5 | Lending rate 5 | decimal | 10 | 6 | | | | |
| 29 | CREATED_BY | Real Estate Add-On User | nvarchar | 12 | 0 | | | | Allow NULL? |
| 30 | CREATED_DATE | Created On | nvarchar | 8 | 0 | | | | Allow NULL? |
| 31 | CREATED_TIME | Created At | nvarchar | 6 | 0 | | | | Allow NULL? |
| 32 | ENTRY_SRC | Sorce of Initial entry | nvarchar | 32 | 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? |
| 36 | PROCESSING_SRC | Processing Source | nvarchar | 32 | 0 | | | | Allow NULL? |
