Diagrams

Table

Inventory Adjmt. Entry (Order)

DynamicsDocs.comInventory Adjmt. Entry (Order)«Table 5896»Inventory Adjmt. Entry (Order)Order Type; [,Production,Transfer,Serv...Order No. [PK]Order Line No. [PK]Item No.Routing No.Routing Reference No.Indirect Cost %Overhead RateCost is AdjustedAllow Online AdjustmentUnit CostDirect CostIndirect CostSingle-Level Material CostSingle-Level Capacity CostSingle-Level Subcontrd. CostSingle-Level Cap. Ovhd CostSingle-Level Mfg. Ovhd CostDirect Cost [ACY]Indirect Cost [ACY]Single-Lvl Material Cost [ACY]Single-Lvl Capacity Cost [ACY]Single-Lvl Subcontrd Cost[ACY]Single-Lvl Cap. Ovhd Cost[ACY]Single-Lvl Mfg. Ovhd Cost[ACY]Completely InvoicedIs Finished«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 99000763»Routing HeaderNo. [PK]DescriptionDescription 2Search DescriptionLast Date ModifiedCommentStatus; [New,Certified,Under Developme...Type; [Serial,Parallel]Version Nos.No. Series<Item No.><Routing No.><Alternative Item No.><Routing No.>

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

Fields

# Name Type
1 Order Type (Order Type) Option
2 Order No. (Order No.) Code20
3 Order Line No. (Order Line No.) Integer
4 Item No. (Item No.) Code20
7 Routing No. (Routing No.) Code20
8 Routing Reference No. (Routing Reference No.) Integer
21 Indirect Cost % (Indirect Cost %) Decimal (0:5)
22 Overhead Rate (Overhead Rate) Decimal
29 Cost is Adjusted (Cost is Adjusted) Boolean
30 Allow Online Adjustment (Allow Online Adjustment) Boolean
41 Unit Cost (Unit Cost) Decimal
42 Direct Cost (Direct Cost) Decimal
43 Indirect Cost (Indirect Cost) Decimal
44 Single-Level Material Cost (Single-Level Material Cost) Decimal
45 Single-Level Capacity Cost (Single-Level Capacity Cost) Decimal
46 Single-Level Subcontrd. Cost (Single-Level Subcontrd. Cost) Decimal
47 Single-Level Cap. Ovhd Cost (Single-Level Cap. Ovhd Cost) Decimal
48 Single-Level Mfg. Ovhd Cost (Single-Level Mfg. Ovhd Cost) Decimal
52 Direct Cost (ACY) (Direct Cost (ACY)) Decimal
53 Indirect Cost (ACY) (Indirect Cost (ACY)) Decimal
54 Single-Lvl Material Cost (ACY) (Single-Lvl Material Cost (ACY)) Decimal
55 Single-Lvl Capacity Cost (ACY) (Single-Lvl Capacity Cost (ACY)) Decimal
56 Single-Lvl Subcontrd Cost(ACY) (Single-Lvl Subcontrd Cost(ACY)) Decimal
57 Single-Lvl Cap. Ovhd Cost(ACY) (Single-Lvl Cap. Ovhd Cost(ACY)) Decimal
58 Single-Lvl Mfg. Ovhd Cost(ACY) (Single-Lvl Mfg. Ovhd Cost(ACY)) Decimal
61 Completely Invoiced (Completely Invoiced) Boolean
62 Is Finished (Is Finished) Boolean

Keys

# Fields
0 Order Type,Order No.,Order Line No. (Order Type,Order No.,Order Line No.) Clustered: Yes
1 Cost is Adjusted,Allow Online Adjustment (Cost is Adjusted,Allow Online Adjustment)

Table Relations To Other Tables

Field Related Table Related Field
Item No. (Item No.) Item No. (No.) 1..n
Routing No. (Routing No.) Routing Header No. (No.) 1..n

Table Relations From Other Tables

From Table From Field