Diagrams

Table

Item Register

DynamicsDocs.comItem Register«Table 46»Item RegisterNo. [PK]From Entry No.To Entry No.Creation DateSource CodeUser IDJournal Batch NameFrom Phys. Inventory Entry No.To Phys. Inventory Entry No.From Value Entry No.To Value Entry No.From Capacity Entry No.To Capacity Entry No.«Table 87»Date Compr. RegisterNo. [PK]Creation DateTable CaptionPeriod Length; [Day,Week,Month,Quarter...Ending DateNo. of New RecordsNo. Records DeletedUser IDFilterStarting DateTable IDRegister No.Source CodeRetain Field ContentsRetain Totals«Table 32»Item Ledger EntryEntry No. [PK]Item No.Posting DateEntry Type; [Purchase,Sale,Positive Ad...Source No.Document No.DescriptionLocation CodeQuantityRemaining QuantityInvoiced QuantityApplies-to EntryOpenGlobal Dimension 1 CodeGlobal Dimension 2 CodePositiveSource Type; [,Customer,Vendor,Item]Drop ShipmentTransaction TypeTransport MethodCountry/Region CodeEntry/Exit PointDocument DateExternal Document No.AreaTransaction SpecificationNo. SeriesReserved QuantityDocument Type; [,Sales Shipment,Sales...Document Line No.Order Type; [,Production,Transfer,Serv......«Table 230»Source CodeCode [PK,NN]Description«Table 2000000120»UserUser Security ID [PK]User NameFull NameState; [Enabled,Disabled]Expiry DateWindows Security IDChange PasswordLicense Type; [Full User,Limited User,...Authentication EmailContact EmailExchange IdentifierApplication ID«Table 233»Item Journal BatchJournal Template Name [PK,NN]Name [PK,NN]DescriptionReason CodeNo. SeriesPosting No. SeriesTemplate Type; [Item,Transfer,Phys. In...Recurring«Table 281»Phys. Inventory Ledger EntryEntry No. [PK]Item No.Posting DateEntry Type; [Purchase,Sale,Positive Ad...Document No.DescriptionLocation CodeInventory Posting GroupQuantityUnit AmountUnit CostAmountSalespers./Purch. CodeUser IDSource CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeJournal Batch NameReason CodeQty. [Calculated]Qty. [Phys. Inventory]Last Item Ledger Entry No.Document DateExternal Document No.No. SeriesDimension Set IDVariant CodeUnit of Measure CodePhys Invt Counting Period CodePhys Invt Counting Period Type; [,Item...«Table 5802»Value EntryEntry No. [PK]Item No.Posting DateItem Ledger Entry Type; [Purchase,Sale...Source No.Document No.DescriptionLocation CodeInventory Posting GroupSource Posting GroupItem Ledger Entry No.Valued QuantityItem Ledger Entry QuantityInvoiced QuantityCost per UnitSales Amount [Actual]Salespers./Purch. CodeDiscount AmountUser IDSource CodeApplies-to EntryGlobal Dimension 1 CodeGlobal Dimension 2 CodeSource Type; [,Customer,Vendor,Item]Cost Amount [Actual]Cost Posted to G/LReason CodeDrop ShipmentJournal Batch NameGen. Bus. Posting GroupGen. Prod. Posting Group...«Table 5832»Capacity Ledger EntryEntry No. [PK]No.Posting DateType; [Work Center,Machine Center, ,Re...Document No.DescriptionOperation No.Work Center No.QuantitySetup TimeRun TimeStop TimeInvoiced QuantityOutput QuantityScrap QuantityConcurrent CapacityCap. Unit of Measure CodeQty. per Cap. Unit of MeasureGlobal Dimension 1 CodeGlobal Dimension 2 CodeLast Output LineCompletely InvoicedStarting TimeEnding TimeRouting No.Routing Reference No.Item No.Variant CodeUnit of Measure CodeQty. per Unit of MeasureDocument Date...<From Entry No.><To Entry No.><Source Code><User ID><Journal Batch Name><From Phys. Inventory Entry No.><To Phys. Inventory Entry No.><From Value Entry No.><To Value Entry No.><From Capacity Entry No.><To Capacity Entry No.><Register No.><User ID><Source Code><Last Item Ledger Entry No.><Item Ledger Entry No.><Source Code><Source Code><User ID><User ID><Capacity Ledger Entry No.>

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

Fields

# Name Type
1 No. (No.) Integer
2 From Entry No. (From Entry No.) Integer
3 To Entry No. (To Entry No.) Integer
4 Creation Date (Creation Date) Date
5 Source Code (Source Code) Code10
6 User ID (User ID) Code50
7 Journal Batch Name (Journal Batch Name) Code10
10 From Phys. Inventory Entry No. (From Phys. Inventory Entry No.) Integer
11 To Phys. Inventory Entry No. (To Phys. Inventory Entry No.) Integer
5800 From Value Entry No. (From Value Entry No.) Integer
5801 To Value Entry No. (To Value Entry No.) Integer
5831 From Capacity Entry No. (From Capacity Entry No.) Integer
5832 To Capacity Entry No. (To Capacity Entry No.) Integer

Keys

# Fields
0 No. (No.) Clustered: Yes
1 Creation Date (Creation Date)
2 Source Code,Journal Batch Name,Creation Date (Source Code,Journal Batch Name,Creation Date)

Table Relations To Other Tables

Field Related Table Related Field
To Capacity Entry No. (To Capacity Entry No.) Capacity Ledger Entry Entry No. (Entry No.) 1..n
Journal Batch Name (Journal Batch Name) Item Journal Batch Name (Name) 1..n
To Entry No. (To Entry No.) Item Ledger Entry Entry No. (Entry No.) 1..n
To Phys. Inventory Entry No. (To Phys. Inventory Entry No.) Phys. Inventory Ledger Entry Entry No. (Entry No.) 1..n
Source Code (Source Code) Source Code Code (Code) 1..n
User ID (User ID) User User Name (User Name) 1..n
To Value Entry No. (To Value Entry No.) Value Entry Entry No. (Entry No.) 1..n

Table Relations From Other Tables

From Table From Field
Date Compr. Register Register No. (Register No.) 1..n