Diagrams


Table

Dimension

DynamicsDocs.comDimension«Table 348»DimensionCode [PK,NN]NameCode CaptionFilter CaptionDescriptionBlockedConsolidation CodeMap-to IC Dimension Code«Table 1002»Job Task DimensionJob No. [PK,NN]Job Task No. [PK,NN]Dimension Code [PK]Dimension Value CodeMultiple Selection Action; [,Change,De...«Table 1108»Cost Accounting SetupPrimary Key [PK]Starting Date for G/L TransferAlign G/L Account; [No Alignment,Autom...Align Cost Center Dimension; [No Align...Align Cost Object Dimension; [No Align...Last Allocation IDLast Allocation Doc. No.Auto Transfer from G/LCheck G/L PostingsCost Center DimensionCost Object Dimension«Table 1302»Dimensions TemplateCode [PK,NN]Dimension Code [NN]Dimension Value CodeValue Posting; [,Code Mandatory,Same C...DescriptionTable IdMaster Record Template Code«Table 311»Sales & Receivables SetupPrimary Key [PK]Discount Posting; [No Discounts,Invoic...Credit Warnings; [Both Warnings,Credit...Stockout WarningShipment on InvoiceInvoice RoundingExt. Doc. No. MandatoryCustomer Nos.Quote Nos.Order Nos.Invoice Nos.Posted Invoice Nos.Credit Memo Nos.Posted Credit Memo Nos.Posted Shipment Nos.Reminder Nos.Issued Reminder Nos.Fin. Chrg. Memo Nos.Issued Fin. Chrg. M. Nos.Posted Prepmt. Inv. Nos.Posted Prepmt. Cr. Memo Nos.Blanket Order Nos.Calc. Inv. DiscountAppln. between Currencies; [None,EMU,A...Copy Comments Blanket to OrderCopy Comments Order to InvoiceCopy Comments Order to Shpt.Allow VAT DifferenceCalc. Inv. Disc. per VAT IDLogo Position on Documents; [No Logo,L...Check Prepmt. when Posting...«Table 313»Inventory SetupPrimary Key [PK]Automatic Cost PostingLocation MandatoryItem Nos.Automatic Cost Adjustment; [Never,Day,...Prevent Negative InventoryTransfer Order Nos.Posted Transfer Shpt. Nos.Posted Transfer Rcpt. Nos.Copy Comments Order to Shpt.Copy Comments Order to Rcpt.Nonstock Item Nos.Outbound Whse. Handling TimeInbound Whse. Handling TimeExpected Cost Posting to G/LAverage Cost Calc. Type; [,Item,Item &...Average Cost Period; [,Day,Week,Month,...Item Group Dimension CodeInventory Put-away Nos.Inventory Pick Nos.Posted Invt. Put-away Nos.Posted Invt. Pick Nos.Inventory Movement Nos.Registered Invt. Movement Nos.Internal Movement Nos.«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«Table 350»Dimension CombinationDimension 1 Code [PK,NN]Dimension 2 Code [PK,NN]Combination Restriction; [Limited,Bloc...«Table 351»Dimension Value CombinationDimension 1 Code [PK,NN]Dimension 1 Value Code [PK,NN]Dimension 2 Code [PK,NN]Dimension 2 Value Code [PK,NN]«Table 352»Default DimensionTable ID [PK,NN]No. [PK]Dimension Code [PK,NN]Dimension Value CodeValue Posting; [,Code Mandatory,Same C...Table CaptionMulti Selection Action; [,Change,Delet...«Table 360»Dimension BufferTable ID [PK]Entry No. [PK]Dimension Code [PK,NN]Dimension Value Code [NN]New Dimension Value CodeLine No.No. Of Dimensions«Table 363»Analysis ViewCode [PK,NN]NameAccount Source; [G/L Account,Cash Flow...Last Entry No.Last Budget Entry No.Last Date UpdatedUpdate on PostingBlockedAccount FilterBusiness Unit FilterStarting DateDate Compression; [None,Day,Week,Month...Dimension 1 CodeDimension 2 CodeDimension 3 CodeDimension 4 CodeInclude BudgetsRefresh When Unblocked«Table 364»Analysis View FilterAnalysis View Code [PK,NN]Dimension Code [PK,NN]Dimension Value Filter«Table 388»Dimension TranslationCode [PK,NN]Language ID [PK,NN]NameCode CaptionFilter CaptionLanguage Name«Table 411»IC DimensionCode [PK,NN]NameBlockedMap-to Dimension Code«Table 412»IC Dimension ValueDimension Code [PK,NN]Code [PK,NN]NameDimension Value Type; [Standard,Headin...BlockedMap-to Dimension CodeMap-to Dimension Value CodeIndentation«Table 480»Dimension Set EntryDimension Set ID [PK]Dimension Code [PK,NN]Dimension Value Code [NN]Dimension Value IDDimension NameDimension Value Name«Table 482»Reclas. Dimension Set BufferDimension Code [PK,NN]Dimension Value CodeDimension Value IDNew Dimension Value CodeNew Dimension Value IDDimension NameDimension Value NameNew Dimension Value Name«Table 7114»Analysis LineAnalysis Area; [Sales,Purchase,Invento...Analysis Line Template Name [PK]Line No. [PK]Row Ref. No.DescriptionType; [Item,Item Group,Customer,Custom...RangeNew PageShow; [Yes,No,If Any Column Not Zero]BoldItalicUnderlineShow Opposite SignSource Type Filter; [,Customer,Vendor,...Date FilterItem Budget FilterLocation FilterDimension 1 FilterDimension 2 FilterDimension 3 FilterDimension 1 TotalingDimension 2 TotalingDimension 3 TotalingSource No. FilterGroup Dimension CodeIndentation«Table 7132»Item Budget NameAnalysis Area; [Sales,Purchase] [PK]Name [PK,NN]DescriptionBlockedBudget Dimension 1 CodeBudget Dimension 2 CodeBudget Dimension 3 Code«Table 7152»Item Analysis ViewAnalysis Area; [Sales,Purchase,Invento...Code [PK,NN]NameLast Entry No.Last Budget Entry No.Last Date UpdatedUpdate on PostingBlockedItem FilterLocation FilterStarting DateDate Compression; [None,Day,Week,Month...Dimension 1 CodeDimension 2 CodeDimension 3 CodeInclude BudgetsRefresh When Unblocked«Table 7153»Item Analysis View FilterAnalysis Area; [Sales,Purchase,Invento...Analysis View Code [PK,NN]Dimension Code [PK,NN]Dimension Value Filter«Table 95»G/L Budget NameName [PK,NN]DescriptionBlockedBudget Dimension 1 CodeBudget Dimension 2 CodeBudget Dimension 3 CodeBudget Dimension 4 Code«Table 98»General Ledger SetupPrimary Key [PK]Allow Posting FromAllow Posting ToRegister TimePmt. Disc. Excl. VATDate FilterGlobal Dimension 1 FilterGlobal Dimension 2 FilterCust. Balances DueVendor Balances DueUnrealized VATAdjust for Payment Disc.Mark Cr. Memos as CorrectionsLocal Address Format; [Post Code+City,...Inv. Rounding Precision [LCY]Inv. Rounding Type [LCY]; [Nearest,Up,...Local Cont. Addr. Format; [First,After...Bank Account Nos.Summarize G/L EntriesAmount Decimal PlacesUnit-Amount Decimal PlacesAdditional Reporting CurrencyVAT Tolerance %EMU CurrencyLCY CodeVAT Exchange Rate Adjustment; [No Adju...Amount Rounding PrecisionUnit-Amount Rounding PrecisionAppln. Rounding PrecisionGlobal Dimension 1 CodeGlobal Dimension 2 Code...<Map-to IC Dimension Code><Map-to Dimension Code><Dimension Code><Cost Center Dimension><Cost Object Dimension><Dimension Code><Customer Group Dimension Code><Salesperson Dimension Code><Item Group Dimension Code><Dimension Code><Dimension 1 Code><Dimension 2 Code><Dimension 1 Code><Dimension 2 Code><Dimension Code><Dimension Code><Dimension 1 Code><Dimension 2 Code><Dimension 3 Code><Dimension 4 Code><Dimension Code><Code><Map-to Dimension Code><Dimension Code><Dimension Code><Group Dimension Code><Budget Dimension 1 Code><Budget Dimension 2 Code><Budget Dimension 3 Code><Dimension 1 Code><Dimension 2 Code><Dimension 3 Code><Dimension Code><Budget Dimension 1 Code><Budget Dimension 2 Code><Budget Dimension 3 Code><Budget Dimension 4 Code><Global Dimension 1 Code><Global Dimension 2 Code><Shortcut Dimension 1 Code><Shortcut Dimension 2 Code><Shortcut Dimension 3 Code><Shortcut Dimension 4 Code><Shortcut Dimension 5 Code><Shortcut Dimension 6 Code><Shortcut Dimension 7 Code><Shortcut Dimension 8 Code><Dimension Value Code><Dimension Value Code><Map-to IC Dimension Value Code><Map-to Dimension Value Code><Dimension 1 Value Code><Dimension 2 Value Code><Dimension Value Code><Dimension Value Code><New Dimension Value Code><Dimension Value Code><Dimension Value Code><New Dimension Value Code><Global Dimension 1 Filter><Global Dimension 2 Filter><Analysis View Code><Dimension Code><Item Budget Filter><Analysis View Code>

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

Fields

# Name Type
1 Code Code20 NotBlank: Yes
2 Name Text30
3 Code Caption Text80
4 Filter Caption Text80
5 Description Text50
6 Blocked Boolean
7 Consolidation Code Code20
8 Map-to IC Dimension Code Code20

Keys

# Fields
0 Code Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Map-to IC Dimension Code IC Dimension Code 1..n

Table Relations From Other Tables

From Table From Field
Analysis Line Group Dimension Code 1..n
Analysis View Dimension 4 Code 1..n
Analysis View Filter Dimension Code 1..n
Cost Accounting Setup Cost Object Dimension 1..n
Default Dimension Dimension Code 1..n
Dimension Buffer Dimension Code 1..n
Dimension Combination Dimension 2 Code 1..n
Dimension Set Entry Dimension Code 1..n
Dimension Translation Code 1..n
Dimension Value Dimension Code 1..n
Dimension Value Combination Dimension 2 Code 1..n
Dimensions Template Dimension Code 1..n
G/L Budget Name Budget Dimension 4 Code 1..n
General Ledger Setup Shortcut Dimension 8 Code 1..n
IC Dimension Map-to Dimension Code 1..n
IC Dimension Value Map-to Dimension Code 1..n
Inventory Setup Item Group Dimension Code 1..n
Item Analysis View Dimension 3 Code 1..n
Item Analysis View Filter Dimension Code 1..n
Item Budget Name Budget Dimension 3 Code 1..n
Job Task Dimension Dimension Code 1..n
Reclas. Dimension Set Buffer Dimension Code 1..1
Sales & Receivables Setup Salesperson Dimension Code 1..n