Diagrams


Table

Standard Cost Worksheet

DynamicsDocs.comStandard Cost Worksheet«Table 5841»Standard Cost WorksheetStandard Cost Worksheet Name [PK]Type; [Item,Work Center,Machine Center...No. [PK,NN]DescriptionImplementedReplenishment System; [Purchase,Prod....Standard CostNew Standard CostIndirect Cost %New Indirect Cost %Overhead RateNew Overhead RateSingle-Lvl Material CostNew Single-Lvl Material CostSingle-Lvl Cap. CostNew Single-Lvl Cap. CostSingle-Lvl Subcontrd CostNew Single-Lvl Subcontrd CostSingle-Lvl Cap. Ovhd CostNew Single-Lvl Cap. Ovhd CostSingle-Lvl Mfg. Ovhd CostNew Single-Lvl Mfg. Ovhd CostRolled-up Material CostNew Rolled-up Material CostRolled-up Cap. CostNew Rolled-up Cap. CostRolled-up Subcontrd CostNew Rolled-up Subcontrd CostRolled-up Cap. Ovhd CostNew Rolled-up Cap. Ovhd CostRolled-up Mfg. Ovhd Cost...«Table 5840»Standard Cost Worksheet NameName [PK,NN]Description«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 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]...<Standard Cost Worksheet Name><No.><No.><No.><No.><Alternative Item No.><Item Filter><Work Center No.><Alternate Work Center>

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

Fields

# Name Type
2 Standard Cost Worksheet Name Code10
3 Type Option
4 No. Code20 NotBlank: Yes
5 Description Text50
6 Implemented Boolean Editable: No
7 Replenishment System Option Editable: No
11 Standard Cost Decimal Editable: No
12 New Standard Cost Decimal
13 Indirect Cost % Decimal (0:5) Editable: No
14 New Indirect Cost % Decimal (0:5)
15 Overhead Rate Decimal (2:5) Editable: No
16 New Overhead Rate Decimal (2:5)
21 Single-Lvl Material Cost Decimal Editable: No
22 New Single-Lvl Material Cost Decimal Editable: No
23 Single-Lvl Cap. Cost Decimal Editable: No
24 New Single-Lvl Cap. Cost Decimal Editable: No
25 Single-Lvl Subcontrd Cost Decimal Editable: No
26 New Single-Lvl Subcontrd Cost Decimal Editable: No
27 Single-Lvl Cap. Ovhd Cost Decimal Editable: No
28 New Single-Lvl Cap. Ovhd Cost Decimal Editable: No
29 Single-Lvl Mfg. Ovhd Cost Decimal Editable: No
30 New Single-Lvl Mfg. Ovhd Cost Decimal Editable: No
41 Rolled-up Material Cost Decimal Editable: No
42 New Rolled-up Material Cost Decimal Editable: No
43 Rolled-up Cap. Cost Decimal Editable: No
44 New Rolled-up Cap. Cost Decimal Editable: No
45 Rolled-up Subcontrd Cost Decimal Editable: No
46 New Rolled-up Subcontrd Cost Decimal Editable: No
47 Rolled-up Cap. Ovhd Cost Decimal Editable: No
48 New Rolled-up Cap. Ovhd Cost Decimal Editable: No
49 Rolled-up Mfg. Ovhd Cost Decimal Editable: No
50 New Rolled-up Mfg. Ovhd Cost Decimal Editable: No

Keys

# Fields
0 Standard Cost Worksheet Name,Type,No. Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
No. Item No. 1..n
No. Machine Center No. 1..n
No. Resource No. 1..n
Standard Cost Worksheet Name Standard Cost Worksheet Name Name 1..n
No. Work Center No. 1..n

Table Relations From Other Tables

From Table From Field