Diagrams

Table

Capacity Ledger Entry

DynamicsDocs.comCapacity Ledger Entry«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...«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 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 99000758»Machine CenterNo. [PK]NameSearch NameName 2AddressAddress 2CityPost CodeWork Center No.Direct Unit CostIndirect Cost %Unit CostQueue TimeQueue Time Unit of Meas. CodeLast Date ModifiedCommentCapacityEfficiencyMaximum EfficiencyMinimum EfficiencyBlockedDate FilterWork Shift FilterCapacity [Total]Capacity [Effective]Prod. Order Need [Qty.]Prod. Order Need AmountProd. Order Status Filter; [Simulated,...Setup TimeWait TimeMove Time...«Table 99000754»Work CenterNo. [PK]NameSearch NameName 2AddressAddress 2CityPost CodeAlternate Work CenterWork Center Group CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeSubcontractor No.Direct Unit CostIndirect Cost %Unit CostQueue TimeQueue Time Unit of Meas. CodeLast Date ModifiedCommentUnit of Measure CodeCapacityEfficiencyMaximum EfficiencyMinimum EfficiencyCalendar Rounding Precision [NN]Simulation Type; [Moves,Moves When Nec...Shop Calendar CodeBlockedDate FilterWork Shift Filter...«Table 156»ResourceNo. [PK]Type; [Person,Machine]NameSearch NameName 2AddressAddress 2CitySocial Security No.Job TitleEducationContract ClassEmployment DateResource Group No.Global Dimension 1 CodeGlobal Dimension 2 CodeBase Unit of MeasureDirect Unit CostIndirect Cost %Unit CostProfit %Price/Profit Calculation; [Profit=Pric...Unit PriceVendor No.Last Date ModifiedCommentBlockedDate FilterUnit of Measure FilterCapacityQty. on Order [Job]...«Table 99000780»Capacity Unit of MeasureCode [PK,NN]DescriptionType; [,100/Hour,Minutes,Hours,Days]«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 99000763»Routing HeaderNo. [PK]DescriptionDescription 2Search DescriptionLast Date ModifiedCommentStatus; [New,Certified,Under Developme...Type; [Serial,Parallel]Version Nos.No. Series«Table 27»ItemNo. [PK]No. 2DescriptionSearch DescriptionDescription 2Assembly BOMBase Unit of MeasurePrice Unit ConversionType; [Inventory,Service]Inventory Posting GroupShelf No.Item Disc. GroupAllow Invoice Disc.Statistics GroupCommission GroupUnit PricePrice/Profit Calculation; [Profit=Pric...Profit %Costing Method; [FIFO,LIFO,Specific,Av...Unit CostStandard CostLast Direct CostIndirect Cost %Cost is AdjustedAllow Online AdjustmentVendor No.Vendor Item No.Lead Time CalculationReorder PointMaximum InventoryReorder Quantity...«Table 5401»Item VariantCode [PK,NN]Item No. [PK,NN]DescriptionDescription 2«Table 5404»Item Unit of MeasureItem No. [PK,NN]Code [PK,NN]Qty. per Unit of MeasureLengthWidthHeightCubageWeight«Table 99000761»StopCode [PK,NN]Description«Table 99000762»ScrapCode [PK,NN]Description«Table 99000756»Work Center GroupCode [PK,NN]NameDate FilterWork Shift FilterCapacity [Total]Capacity [Effective]Prod. Order Need [Qty.]Prod. Order Status Filter; [Simulated,...«Table 99000750»Work ShiftCode [PK,NN]Description«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 5406»Prod. Order LineStatus; [Simulated,Planned,Firm Planne...Prod. Order No. [PK]Line No. [PK]Item No.Variant CodeDescriptionDescription 2Location CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeBin CodeQuantityFinished QuantityRemaining QuantityScrap %Due DateStarting DateStarting TimeEnding DateEnding TimePlanning Level CodePriorityProduction BOM No.Routing No.Inventory Posting GroupRouting Reference No.Unit CostCost AmountReserved QuantityCapacity Type Filter; [Work Center,Mac...Capacity No. Filter...«Table 480»Dimension Set EntryDimension Set ID [PK]Dimension Code [PK,NN]Dimension Value Code [NN]Dimension Value IDDimension NameDimension Value Name<No.><No.><Work Center No.><No.><Cap. Unit of Measure Code><Global Dimension 1 Code><Global Dimension 2 Code><Routing No.><Item No.><Variant Code><Unit of Measure Code><Stop Code><Scrap Code><Work Center Group Code><Work Shift Code><Order No.><Order Line No.><Dimension Set ID><From Capacity Entry No.><To Capacity Entry No.><Capacity Ledger Entry No.><From Value Entry No.><To Value Entry No.><Item No.><Source No.><Global Dimension 1 Code><Global Dimension 2 Code><Dimension Set ID><Variant Code><No.><No.><No.><Work Center No.><Queue Time Unit of Meas. Code><Setup Time Unit of Meas. Code><Wait Time Unit of Meas. Code><Move Time Unit of Meas. Code><Work Shift Filter><Item Filter><Stop Code Filter><Scrap Code Filter><Capacity No. Filter><Capacity No. Filter><Alternate Work Center><Work Center Group Code><Global Dimension 1 Code><Global Dimension 2 Code><Queue Time Unit of Meas. Code><Unit of Measure Code><Work Shift Filter><Work Center Filter><Capacity No. Filter><Capacity No. Filter><Global Dimension 1 Code><Global Dimension 2 Code><Global Dimension 1 Filter><Global Dimension 2 Filter><Global Dimension 1 Code><Global Dimension 2 Code><Dimension Value Code><Shortcut Dimension 1 Code><Shortcut Dimension 2 Code><Shortcut Dimension 1 Code><Shortcut Dimension 2 Code><Routing No.><Routing No.><Routing No.><Alternative Item No.><Variant Filter><Item No.><Sales Unit of Measure><Purch. Unit of Measure><Put-away Unit of Measure Code><Item No.><Source No.><Item No.><Variant Code><Unit of Measure Code><Work Shift Filter><Dimension Set ID><Prod. Order No.><Dimension Set ID>

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

Fields

# Name Type
1 Entry No. (Entry No.) Integer
2 No. (No.) Code20
3 Posting Date (Posting Date) Date
4 Type (Type) Option
6 Document No. (Document No.) Code20
7 Description (Description) Text50
8 Operation No. (Operation No.) Code10
9 Work Center No. (Work Center No.) Code20
10 Quantity (Quantity) Decimal (0:5)
11 Setup Time (Setup Time) Decimal (0:5)
12 Run Time (Run Time) Decimal (0:5)
13 Stop Time (Stop Time) Decimal (0:5)
15 Invoiced Quantity (Invoiced Quantity) Decimal (0:5)
16 Output Quantity (Output Quantity) Decimal (0:5)
17 Scrap Quantity (Scrap Quantity) Decimal (0:5)
19 Concurrent Capacity (Concurrent Capacity) Decimal
28 Cap. Unit of Measure Code (Cap. Unit of Measure Code) Code10
29 Qty. per Cap. Unit of Measure (Qty. per Cap. Unit of Measure) Decimal (0:5)
33 Global Dimension 1 Code (Global Dimension 1 Code) Code20
34 Global Dimension 2 Code (Global Dimension 2 Code) Code20
39 Last Output Line (Last Output Line) Boolean
42 Completely Invoiced (Completely Invoiced) Boolean
43 Starting Time (Starting Time) Time
44 Ending Time (Ending Time) Time
52 Routing No. (Routing No.) Code20
53 Routing Reference No. (Routing Reference No.) Integer
56 Item No. (Item No.) Code20
57 Variant Code (Variant Code) Code10
58 Unit of Measure Code (Unit of Measure Code) Code10
59 Qty. per Unit of Measure (Qty. per Unit of Measure) Decimal (0:5)
60 Document Date (Document Date) Date
61 External Document No. (External Document No.) Code35
65 Stop Code (Stop Code) Code10
66 Scrap Code (Scrap Code) Code10
68 Work Center Group Code (Work Center Group Code) Code10
69 Work Shift Code (Work Shift Code) Code10
71 Direct Cost (Direct Cost) Decimal Editable: No
FlowField
72 Overhead Cost (Overhead Cost) Decimal Editable: No
FlowField
76 Direct Cost (ACY) (Direct Cost (ACY)) Decimal Editable: No
FlowField
77 Overhead Cost (ACY) (Overhead Cost (ACY)) Decimal Editable: No
FlowField
78 Subcontracting (Subcontracting) Boolean
90 Order Type (Order Type) Option Editable: No
91 Order No. (Order No.) Code20 Editable: No
92 Order Line No. (Order Line No.) Integer Editable: No
480 Dimension Set ID (Dimension Set ID) Integer Editable: No

Keys

# Fields
0 Entry No. (Entry No.) Clustered: Yes
1 Document No.,Posting Date (Document No.,Posting Date)
2 Order Type,Order No.,Order Line No.,Routing No.,Routing Reference No.,Operation No.,Last Output Line (Order Type,Order No.,Order Line No.,Routing No.,Routing Reference No.,Operation No.,Last Output Line) MaintainSIFTIndex: No
3 Work Center No.,Work Shift Code,Posting Date (Work Center No.,Work Shift Code,Posting Date)
4 Type,No.,Work Shift Code,Item No.,Posting Date (Type,No.,Work Shift Code,Item No.,Posting Date)

Table Relations To Other Tables

Field Related Table Related Field
Cap. Unit of Measure Code (Cap. Unit of Measure Code) Capacity Unit of Measure Code (Code) 1..n
Dimension Set ID (Dimension Set ID) Dimension Set Entry () 1..n
Global Dimension 2 Code (Global Dimension 2 Code) Dimension Value Code (Code) 1..n
Item No. (Item No.) Item No. (No.) 1..n
Unit of Measure Code (Unit of Measure Code) Item Unit of Measure Code (Code) 1..n
Variant Code (Variant Code) Item Variant Code (Code) 1..n
No. (No.) Machine Center No. (No.) 1..n
Order Line No. (Order Line No.) Prod. Order Line Line No. (Line No.) 1..n
Order No. (Order No.) Production Order No. (No.) 1..n
No. (No.) Resource No. (No.) 1..n
Routing No. (Routing No.) Routing Header No. (No.) 1..n
Scrap Code (Scrap Code) Scrap Code (Code) 1..n
Stop Code (Stop Code) Stop Code (Code) 1..n
Work Center No. (Work Center No.) Work Center No. (No.) 1..n
Work Center Group Code (Work Center Group Code) Work Center Group Code (Code) 1..n
Work Shift Code (Work Shift Code) Work Shift Code (Code) 1..n

Table Relations From Other Tables

From Table From Field
Item Register To Capacity Entry No. (To Capacity Entry No.) 1..n
Value Entry Capacity Ledger Entry No. (Capacity Ledger Entry No.) 1..n