Diagrams

Table

Dimensions Template

DynamicsDocs.comDimensions Template«Table 1302»Dimensions TemplateCode [PK,NN]Dimension Code [NN]Dimension Value CodeValue Posting; [,Code Mandatory,Same C...DescriptionTable IdMaster Record Template Code«Table 348»DimensionCode [PK,NN]NameCode CaptionFilter CaptionDescriptionBlockedConsolidation CodeMap-to IC Dimension Code«Table 349»Dimension ValueDimension Code [PK,NN]Code [PK,NN]NameDimension Value Type; [Standard,Headin...TotalingBlockedConsolidation CodeIndentationGlobal Dimension No.Map-to IC Dimension CodeMap-to IC Dimension Value CodeDimension Value ID<Dimension Code><Dimension Value Code><Dimension Code>

Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback

Fields

# Name Type
1 Code (Code) Code10 NotBlank: Yes
3 Dimension Code (Dimension Code) Code20 NotBlank: Yes
4 Dimension Value Code (Dimension Value Code) Code20
5 Value Posting (Value Posting) Option
50 Description (Description) Text50
51 Table Id (Table Id) Integer
52 Master Record Template Code (Master Record Template Code) Code10

Keys

# Fields
0 Code (Code) Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Dimension Code (Dimension Code) Dimension Code (Code) 1..n
Dimension Value Code (Dimension Value Code) Dimension Value Code (Code) 1..n

Table Relations From Other Tables

From Table From Field