| 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 | AWARD | Award | nvarchar | 4 | 0 | CHAR | (N' ') | No | | ACE_SOP_AWARD | Allow NULL? |
| 3 | GRANTING_DATE | Data on which an award was granted | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | ACE_SOP_GRANTING_DATE | Allow NULL? |
| 4 | VESTING_DATE | Vesting Date | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | ACE_SOP_VESTING_DATE_BS_MODEL | Allow NULL? |
| 5 | DATE_FROM | Date from which an entry is valid | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | ACE_SOP_RECORD_VALITY_FROM | Allow NULL? |
| 6 | BSMODEL_VALUE | Value of an Option According to Black & Scholes Model | decimal | 15 | 2 | CURR | ((0)) | Yes | | ACE_SOP_BSMODEL_VALUE | |
| 7 | CURRENCY | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | WAERS | Allow NULL? |
| 8 | RF_INTERES_RATE | Zero coupon interest rate | decimal | 10 | 7 | DEC | ((0)) | Yes | | ACE_SOP_RISKFREE_INTEREST_RATE | |
| 9 | EX_OPT_LIFE_TIME | Expected Term of Awards in Days | int | 10 | 0 | INT4 | ((0)) | Yes | | ACE_SOP_EXPECTED_OPT_LIFE_TIME | Allow NULL? |
| 10 | VOLATILITY | Volatility | decimal | 10 | 7 | DEC | ((0)) | Yes | | ACE_SOP_VOLATILITY | |
| 11 | EXPECTED_DIVIDS | Expected dividend | decimal | 10 | 2 | CURR | ((0)) | Yes | | ACE_SOP_EXPECTED_DIVIDENDS | |
