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

Keys

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

Table Relations To Other Tables

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

Table Relations From Other Tables

From Table From Field
Bin Variant Filter (Variant Filter) 1..n