Diagrams


Table

Dimension Set Entry

DynamicsDocs.comDimension Set Entry«Table 480»Dimension Set EntryDimension Set ID [PK]Dimension Code [PK,NN]Dimension Value Code [NN]Dimension Value IDDimension NameDimension Value Name«Table 221»Gen. Jnl. AllocationJournal Template Name [PK]Journal Batch Name [PK]Journal Line No. [PK]Line No. [PK]Account No.Shortcut Dimension 1 CodeShortcut Dimension 2 CodeAllocation QuantityAllocation %AmountGen. Posting Type; [,Purchase,Sale]Gen. Bus. Posting GroupGen. Prod. Posting GroupVAT Calculation Type; [Normal VAT,Reve...VAT AmountVAT %Account NameTax Area CodeTax LiableTax Group CodeUse TaxVAT Bus. Posting GroupVAT Prod. Posting GroupAdditional-Currency AmountDimension Set ID«Table 273»Bank Acc. ReconciliationBank Account No. [PK,NN]Statement No. [PK,NN]Statement Ending BalanceStatement DateBalance Last StatementBank StatementTotal Balance on Bank AccountTotal Applied AmountTotal Transaction AmountTotal Unposted Applied AmountTotal DifferenceStatement Type; [Bank Reconciliation,P...Shortcut Dimension 1 CodeShortcut Dimension 2 CodePost Payments OnlyImport Posted Transactions; [,Yes,No]Total Outstd Bank TransactionsTotal Outstd PaymentsTotal Applied Amount PaymentsBank Account Balance [LCY]Total Positive AdjustmentsTotal Negative AdjustmentsTotal Positive DifferenceTotal Negative DifferenceCopy VAT Setup to Jnl. LineDimension Set ID«Table 5405»Production OrderStatus; [Simulated,Planned,Firm Planne...No. [PK]DescriptionSearch DescriptionDescription 2Creation DateLast Date ModifiedSource Type; [Item,Family,Sales Header...Source No.Routing No.Inventory Posting GroupGen. Prod. Posting GroupGen. Bus. Posting GroupCommentStarting TimeStarting DateEnding TimeEnding DateDue DateFinished DateBlockedShortcut Dimension 1 CodeShortcut Dimension 2 CodeLocation CodeBin CodeReplan Ref. No.Replan Ref. Status; [Simulated,Planned...Low-Level CodeQuantityUnit CostCost Amount...«Table 5407»Prod. Order ComponentStatus; [Simulated,Planned,Firm Planne...Prod. Order No. [PK]Prod. Order Line No. [PK]Line No. [PK]Item No.DescriptionUnit of Measure CodeQuantityPositionPosition 2Position 3Lead-Time OffsetRouting Link CodeScrap %Variant CodeExpected QuantityRemaining QuantityAct. Consumption [Qty]Flushing Method; [Manual,Forward,Backw...Location CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeBin CodeSupplied-by Line No.Planning Level CodeItem Low-Level CodeLengthWidthWeightDepthCalculation Formula; [,Length,Length *......«Table 5615»FA AllocationCode [PK,NN]Line No. [PK]DescriptionAccount No.Global Dimension 1 CodeGlobal Dimension 2 CodeAllocation %Allocation Type; [Acquisition,Deprecia...Account NameDimension Set ID«Table 99000829»Planning ComponentWorksheet Template Name [PK]Worksheet Batch Name [PK]Worksheet Line No. [PK]Line No. [PK]Item No.DescriptionUnit of Measure CodeQuantityPositionPosition 2Position 3Lead-Time OffsetRouting Link CodeScrap %Variant CodeExpected QuantityFlushing Method; [Manual,Forward,Backw...Location CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeBin CodeSupplied-by Line No.Planning Level CodeRef. Order Status; [Simulated,Planned,...Ref. Order No.Ref. Order Line No.LengthWidthWeightDepthCalculation Formula; [,Length,Length *......«Table 348»DimensionCode [PK,NN]NameCode CaptionFilter CaptionDescriptionBlockedConsolidation CodeMap-to IC Dimension CodeIdLast Modified Date Time<Dimension Code><Dimension Set ID><Dimension Set ID><Dimension Set ID><Dimension Set ID><Dimension Set ID><Dimension Set ID><Prod. Order No.>

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

Fields

# Name Type
1 Dimension Set ID Integer
2 Dimension Code Code20 NotBlank: Yes
3 Dimension Value Code Code20 NotBlank: Yes
4 Dimension Value ID Integer
5 Dimension Name Text30 Editable: No
FlowField
6 Dimension Value Name Text50 Editable: No
FlowField

Keys

# Fields
0 Dimension Set ID,Dimension Code Clustered: Yes
1 Dimension Value ID

Table Relations To Other Tables

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

Table Relations From Other Tables

From Table From Field
Assembly Header Dimension Set ID 1..n
Assembly Line Dimension Set ID 1..n
Bank Acc. Reconciliation Dimension Set ID 1..n
Bank Acc. Reconciliation Line Dimension Set ID 1..n
Bank Account Ledger Entry Dimension Set ID 1..n
CV Ledger Entry Buffer Dimension Set ID 1..n
Capacity Ledger Entry Dimension Set ID 1..n
Cash Flow Forecast Entry Dimension Set ID 1..n
Cash Flow Worksheet Line Dimension Set ID 1..n
Cust. Ledger Entry Dimension Set ID 1..n
Deferral Post. Buffer Dimension Set ID 1..n
Employee Ledger Entry Dimension Set ID 1..n
Employee Payment Buffer Dimension Set ID 1..n
FA Allocation Dimension Set ID 1..n
FA G/L Posting Buffer Dimension Set ID 1..n
FA Journal Line Dimension Set ID 1..n
FA Ledger Entry Dimension Set ID 1..n
Filed Service Contract Header Dimension Set ID 1..n
Finance Charge Memo Header Dimension Set ID 1..n
G/L Budget Entry Dimension Set ID 1..n
G/L Entry Dimension Set ID 1..n
Gen. Jnl. Allocation Dimension Set ID 1..n
Gen. Journal Line Dimension Set ID 1..n
Ins. Coverage Ledger Entry Dimension Set ID 1..n
Insurance Journal Line Dimension Set ID 1..n
Invoice Post. Buffer Dimension Set ID 1..n
Invt. Post to G/L Test Buffer Dimension Set ID 1..n
Invt. Posting Buffer Dimension Set ID 1..n
Issued Fin. Charge Memo Header Dimension Set ID 1..n
Issued Reminder Header Dimension Set ID 1..n
Item Budget Buffer Dimension Set ID 1..n
Item Budget Entry Dimension Set ID 1..n
Item Journal Line New Dimension Set ID 1..n
Item Ledger Entry Dimension Set ID 1..n
Job Journal Line Dimension Set ID 1..n
Job Ledger Entry Dimension Set ID 1..n
Job Posting Buffer Dimension Set ID 1..n
Job WIP Entry Dimension Set ID 1..n
Job WIP G/L Entry Dimension Set ID 1..n
Maintenance Ledger Entry Dimension Set ID 1..n
Payment Buffer Dimension Set ID 1..n
Phys. Inventory Ledger Entry Dimension Set ID 1..n
Planning Component Dimension Set ID 1..n
Posted Assembly Header Dimension Set ID 1..n
Posted Assembly Line Dimension Set ID 1..n
Prepayment Inv. Line Buffer Dimension Set ID 1..n
Prod. Order Component Dimension Set ID 1..n
Prod. Order Line Dimension Set ID 1..n
Production Order Dimension Set ID 1..n
Purch. Cr. Memo Hdr. Dimension Set ID 1..n
Purch. Cr. Memo Line Dimension Set ID 1..n
Purch. Inv. Header Dimension Set ID 1..n
Purch. Inv. Line Dimension Set ID 1..n
Purch. Rcpt. Header Dimension Set ID 1..n
Purch. Rcpt. Line Dimension Set ID 1..n
Purchase Header Dimension Set ID 1..n
Purchase Header Archive Dimension Set ID 1..n
Purchase Line Dimension Set ID 1..n
Purchase Line Archive Dimension Set ID 1..n
Reminder Header Dimension Set ID 1..n
Requisition Line Dimension Set ID 1..n
Res. Journal Line Dimension Set ID 1..n
Res. Ledger Entry Dimension Set ID 1..n
Return Receipt Header Dimension Set ID 1..n
Return Receipt Line Dimension Set ID 1..n
Return Shipment Header Dimension Set ID 1..n
Return Shipment Line Dimension Set ID 1..n
Sales Cr.Memo Header Dimension Set ID 1..n
Sales Cr.Memo Line Dimension Set ID 1..n
Sales Header Dimension Set ID 1..n
Sales Header Archive Dimension Set ID 1..n
Sales Invoice Header Dimension Set ID 1..n
Sales Invoice Line Dimension Set ID 1..n
Sales Line Dimension Set ID 1..n
Sales Line Archive Dimension Set ID 1..n
Sales Shipment Header Dimension Set ID 1..n
Sales Shipment Line Dimension Set ID 1..n
Service Contract Header Dimension Set ID 1..n
Service Cr.Memo Header Dimension Set ID 1..n
Service Cr.Memo Line Dimension Set ID 1..n
Service Header Dimension Set ID 1..n
Service Invoice Header Dimension Set ID 1..n
Service Invoice Line Dimension Set ID 1..n
Service Item Line Dimension Set ID 1..n
Service Ledger Entry Dimension Set ID 1..n
Service Line Dimension Set ID 1..n
Service Order Posting Buffer Dimension Set ID 1..n
Service Shipment Header Dimension Set ID 1..n
Service Shipment Item Line Dimension Set ID 1..n
Service Shipment Line Dimension Set ID 1..n
Standard General Journal Line Dimension Set ID 1..n
Standard Item Journal Line Dimension Set ID 1..n
Standard Purchase Line Dimension Set ID 1..n
Standard Sales Line Dimension Set ID 1..n
Standard Service Line Dimension Set ID 1..n
Transfer Header Dimension Set ID 1..n
Transfer Line Dimension Set ID 1..n
Transfer Receipt Header Dimension Set ID 1..n
Transfer Receipt Line Dimension Set ID 1..n
Transfer Shipment Header Dimension Set ID 1..n
Transfer Shipment Line Dimension Set ID 1..n
Value Entry Dimension Set ID 1..n
Vendor Ledger Entry Dimension Set ID 1..n
Warranty Ledger Entry Dimension Set ID 1..n