| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPMaster Data |
1 | GMGRVALUETYPE | Value type settings for posting control | 4 | STATISTICAL | Does this value type post statistically? | nvarchar | 1 | 0 | | |
2 | GMSMVALUETYPE | Value type control by grant type and status | 6 | STATISTICAL | Default Statistical Posting Indicator | nvarchar | 1 | 0 | | |
3 | GMSMVALUETYPE_1 | Value type control by grant type and status | 5 | STATISTICAL | Default Statistical Posting Indicator | nvarchar | 1 | 0 | | |
TOPPricing |
4 | PRCC_COND_DEST | Target Fields for Condition Purposes | 5 | STATISTICAL | Statistical Conditions Taken Into Account | nvarchar | 1 | 0 | | |
5 | PRCD_SIM_ITEM | Pricing Document Item (Simulation) | 9 | STATISTICAL | Statistical Values | nvarchar | 1 | 0 | | |
TOPTransaction Tax Engine |
6 | TTEPDT_TAXVALUE | Persistency TTE Document / Item tax value | 17 | STATISTICAL | Statistical | nvarchar | 1 | 0 | | |
7 | TTESDT_TAXVALUE | Document / Item tax value | 17 | STATISTICAL | Statistical | nvarchar | 1 | 0 | | |