Diagrams


Table

Stockkeeping Unit

DynamicsDocs.comStockkeeping Unit«Table 5700»Stockkeeping UnitItem No. [PK,NN]Variant Code [PK]Location Code [PK]DescriptionDescription 2Assembly BOMShelf No.Unit CostStandard CostLast Direct CostVendor No.Vendor Item No.Lead Time CalculationReorder PointMaximum InventoryReorder QuantityCommentLast Date ModifiedDate FilterGlobal Dimension 1 FilterGlobal Dimension 2 FilterInventoryQty. on Purch. OrderQty. on Sales OrderDrop Shipment FilterAssembly Policy; [Assemble-to-Stock,As...Qty. on Assembly OrderQty. on Asm. ComponentQty. on Job OrderTransfer-Level CodeLot Size...«Table 7354»BinLocation Code [PK,NN]Code [PK,NN]DescriptionZone CodeAdjustment BinBin Type CodeWarehouse Class CodeBlock Movement; [,Inbound,Outbound,All...Special Equipment CodeBin RankingMaximum CubageMaximum WeightEmptyItem FilterVariant FilterDefaultCross-Dock BinDedicated«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 14»LocationCode [PK,NN]NameDefault Bin CodeName 2AddressAddress 2CityPhone No.Phone No. 2Telex No.Fax No.ContactPost CodeCountyE-MailHome PageCountry/Region CodeUse As In-TransitRequire Put-awayRequire PickCross-Dock Due Date Calc.Use Cross-DockingRequire ReceiveRequire ShipmentBin MandatoryDirected Put-away and PickDefault Bin Selection; [,Fixed Bin,Las...Outbound Whse. Handling TimeInbound Whse. Handling TimePut-away Template CodeUse Put-away Worksheet...«Table 23»VendorNo. [PK]NameSearch NameName 2AddressAddress 2CityContactPhone No.Telex No.Our Account No.Territory CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeBudgeted AmountVendor Posting GroupCurrency CodeLanguage CodeStatistics GroupPayment Terms CodeFin. Charge Terms CodePurchaser CodeShipment Method CodeShipping Agent CodeInvoice Disc. CodeCountry/Region CodeCommentBlocked; [,Payment,All]Pay-to Vendor No.PriorityPayment Method Code...«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 IDIdLast Modified Date Time«Table 7305»Special EquipmentCode [PK,NN]Description«Table 7307»Put-away Template HeaderCode [PK,NN]Description«Table 5404»Item Unit of MeasureItem No. [PK,NN]Code [PK,NN]Qty. per Unit of MeasureLengthWidthHeightCubageWeight«Table 7381»Phys. Invt. Counting PeriodCode [PK,NN]DescriptionCount Frequency per Year [NN]<Item No.><Variant Code><Location Code><Components at Location><Transfer-from Code><Vendor No.><Global Dimension 1 Filter><Global Dimension 2 Filter><Bin Filter><Variant Filter><Special Equipment Code><Put-away Template Code><Put-away Unit of Measure Code><Phys Invt Counting Period Code><Location Code><Default Bin Code><Open Shop Floor Bin Code><To-Production Bin Code><From-Production Bin Code><Adjustment Bin Code><Receipt Bin Code><Shipment Bin Code><Cross-Dock Bin Code><To-Assembly Bin Code><From-Assembly Bin Code><Asm.-to-Order Shpt. Bin Code><Special Equipment Code><Item Filter><Bin Filter><Vendor No.><Alternative Item No.><Global Dimension 1 Filter><Global Dimension 2 Filter><Global Dimension 1 Code><Global Dimension 2 Code><Location Filter><Variant Filter><Item No.><Sales Unit of Measure><Purch. Unit of Measure><Put-away Unit of Measure Code><Item No.><Special Equipment Code><Put-away Template Code><Phys Invt Counting Period Code><Put-away Template Code><Location Code><Global Dimension 1 Code><Global Dimension 2 Code><Global Dimension 1 Filter><Global Dimension 2 Filter><Pay-to Vendor No.>

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

Fields

# Name Type
1 Item No. Code20 NotBlank: Yes
2 Variant Code Code10
3 Location Code Code10
4 Description Text50 Editable: No
FlowField
5 Description 2 Text50 Editable: No
FlowField
6 Assembly BOM Boolean Editable: No
FlowField
12 Shelf No. Code10
22 Unit Cost Decimal
24 Standard Cost Decimal
25 Last Direct Cost Decimal
31 Vendor No. Code20
32 Vendor Item No. Text20
33 Lead Time Calculation DateFormula
34 Reorder Point Decimal (0:5)
35 Maximum Inventory Decimal (0:5)
36 Reorder Quantity Decimal (0:5)
53 Comment Boolean Editable: No
FlowField
62 Last Date Modified Date Editable: No
64 Date Filter Date FlowFilter
65 Global Dimension 1 Filter Code20 FlowFilter
66 Global Dimension 2 Filter Code20 FlowFilter
68 Inventory Decimal (0:5) Editable: No
FlowField
84 Qty. on Purch. Order Decimal (0:5) Editable: No
FlowField
85 Qty. on Sales Order Decimal (0:5) Editable: No
FlowField
89 Drop Shipment Filter Boolean FlowFilter
910 Assembly Policy Option
977 Qty. on Assembly Order Decimal (0:5) Editable: No
FlowField
978 Qty. on Asm. Component Decimal (0:5) Editable: No
FlowField
1001 Qty. on Job Order Decimal (0:5) Editable: No
FlowField
5400 Transfer-Level Code Integer Editable: No
5401 Lot Size Decimal (0:5)
5410 Discrete Order Quantity Integer
5411 Minimum Order Quantity Decimal (0:5)
5412 Maximum Order Quantity Decimal (0:5)
5413 Safety Stock Quantity Decimal (0:5)
5414 Order Multiple Decimal (0:5)
5415 Safety Lead Time DateFormula
5416 Components at Location Code10
5417 Flushing Method Option
5419 Replenishment System Option
5420 Scheduled Receipt (Qty.) Decimal (0:5) Editable: No
FlowField
5421 Scheduled Need (Qty.) Decimal (0:5) Editable: No
FlowField
5423 Bin Filter Code20 FlowFilter
5428 Time Bucket DateFormula
5440 Reordering Policy Option
5441 Include Inventory Boolean
5442 Manufacturing Policy Option
5443 Rescheduling Period DateFormula
5444 Lot Accumulation Period DateFormula
5445 Dampener Period DateFormula
5446 Dampener Quantity Decimal (0:5)
5447 Overflow Level Decimal (0:5)
5700 Transfer-from Code Code10
5701 Qty. in Transit Decimal (0:5) Editable: No
FlowField
5702 Trans. Ord. Receipt (Qty.) Decimal (0:5) Editable: No
FlowField
5703 Trans. Ord. Shipment (Qty.) Decimal (0:5) Editable: No
FlowField
5901 Qty. on Service Order Decimal (0:5) Editable: No
FlowField
7301 Special Equipment Code Code10
7302 Put-away Template Code Code10
7307 Put-away Unit of Measure Code Code10
7380 Phys Invt Counting Period Code Code10
7381 Last Counting Period Update Date Editable: No
7383 Last Phys. Invt. Date Date Editable: No
FlowField
7384 Use Cross-Docking Boolean
7385 Next Counting Start Date Date
7386 Next Counting End Date Date
99000765 Planned Order Receipt (Qty.) Decimal (0:5) Editable: No
FlowField
99000766 FP Order Receipt (Qty.) Decimal (0:5) Editable: No
FlowField
99000767 Rel. Order Receipt (Qty.) Decimal (0:5) Editable: No
FlowField
99000769 Planned Order Release (Qty.) Decimal (0:5) Editable: No
FlowField
99000770 Purch. Req. Receipt (Qty.) Decimal (0:5) FlowField
99000771 Purch. Req. Release (Qty.) Decimal (0:5) FlowField
99000777 Qty. on Prod. Order Decimal (0:5) Editable: No
FlowField
99000778 Qty. on Component Lines Decimal (0:5) Editable: No
FlowField

Keys

# Fields
0 Location Code,Item No.,Variant Code Clustered: Yes
1 Replenishment System,Vendor No.,Transfer-from Code
2 Item No.,Location Code,Variant Code
3 Item No.,Transfer-Level Code

Table Relations To Other Tables

Field Related Table Related Field
Bin Filter Bin Code 1..n
Global Dimension 2 Filter Dimension Value Code 1..n
Item No. Item 1..n
Put-away Unit of Measure Code Item Unit of Measure Code 1..n
Variant Code Item Variant Code 1..n
Transfer-from Code Location 1..n
Phys Invt Counting Period Code Phys. Invt. Counting Period Code 1..n
Put-away Template Code Put-away Template Header Code 1..n
Special Equipment Code Special Equipment Code 1..n
Vendor No. Vendor No. 1..n

Table Relations From Other Tables

From Table From Field
Bin Variant Filter 1..n