Diagrams


Table

Tracking Specification

DynamicsDocs.comTracking Specification«Table 336»Tracking SpecificationEntry No. [PK]Item No.Location CodeQuantity [Base]DescriptionCreation DateSource TypeSource Subtype; [0,1,2,3,4,5,6,7,8,9,1...Source IDSource Batch NameSource Prod. Order LineSource Ref. No.Item Ledger Entry No.Transfer Item Entry No.Serial No.PositiveQty. per Unit of MeasureAppl.-to Item EntryWarranty DateExpiration DateQty. to Handle [Base]Qty. to Invoice [Base]Quantity Handled [Base]Quantity Invoiced [Base]Qty. to HandleQty. to InvoiceBuffer Status; [,MODIFY,INSERT]Buffer Status2; [,ExpDate blocked]Buffer Value1Buffer Value2Buffer Value3...«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 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 32»Item Ledger EntryEntry No. [PK]Item No.Posting DateEntry Type; [Purchase,Sale,Positive Ad...Source No.Document No.DescriptionLocation CodeQuantityRemaining QuantityInvoiced QuantityApplies-to EntryOpenGlobal Dimension 1 CodeGlobal Dimension 2 CodePositiveSource Type; [,Customer,Vendor,Item]Drop ShipmentTransaction TypeTransport MethodCountry/Region CodeEntry/Exit PointDocument DateExternal Document No.AreaTransaction SpecificationNo. SeriesReserved QuantityDocument Type; [,Sales Shipment,Sales...Document Line No.Order Type; [,Production,Transfer,Serv......«Table 5401»Item VariantCode [PK,NN]Item No. [PK,NN]DescriptionDescription 2«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<Item No.><Location Code><Item Ledger Entry No.><Transfer Item Entry No.><Variant Code><Bin Code><Alternative Item No.><Location Filter><Bin Filter><Item Filter><Variant Filter><Item No.><Item No.><Source No.><Originally Ordered No.><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><Location Code><Location Code><Variant Code><Originally Ordered Var. Code>

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 Item No. (Item No.) Code20
3 Location Code (Location Code) Code10
4 Quantity (Base) (Quantity (Base)) Decimal (0:5)
7 Description (Description) Text50
8 Creation Date (Creation Date) Date
10 Source Type (Source Type) Integer
11 Source Subtype (Source Subtype) Option
12 Source ID (Source ID) Code20
13 Source Batch Name (Source Batch Name) Code10
14 Source Prod. Order Line (Source Prod. Order Line) Integer
15 Source Ref. No. (Source Ref. No.) Integer
16 Item Ledger Entry No. (Item Ledger Entry No.) Integer
17 Transfer Item Entry No. (Transfer Item Entry No.) Integer
24 Serial No. (Serial No.) Code20
28 Positive (Positive) Boolean
29 Qty. per Unit of Measure (Qty. per Unit of Measure) Decimal (0:5) Editable: No
38 Appl.-to Item Entry (Appl.-to Item Entry) Integer
40 Warranty Date (Warranty Date) Date
41 Expiration Date (Expiration Date) Date
50 Qty. to Handle (Base) (Qty. to Handle (Base)) Decimal (0:5)
51 Qty. to Invoice (Base) (Qty. to Invoice (Base)) Decimal (0:5)
52 Quantity Handled (Base) (Quantity Handled (Base)) Decimal (0:5) Editable: No
53 Quantity Invoiced (Base) (Quantity Invoiced (Base)) Decimal (0:5) Editable: No
60 Qty. to Handle (Qty. to Handle) Decimal (0:5)
61 Qty. to Invoice (Qty. to Invoice) Decimal (0:5)
70 Buffer Status (Buffer Status) Option Editable: No
71 Buffer Status2 (Buffer Status2) Option Editable: No
72 Buffer Value1 (Buffer Value1) Decimal Editable: No
73 Buffer Value2 (Buffer Value2) Decimal Editable: No
74 Buffer Value3 (Buffer Value3) Decimal Editable: No
75 Buffer Value4 (Buffer Value4) Decimal Editable: No
76 Buffer Value5 (Buffer Value5) Decimal Editable: No
80 New Serial No. (New Serial No.) Code20
81 New Lot No. (New Lot No.) Code20
900 Prohibit Cancellation (Prohibit Cancellation) Boolean
5400 Lot No. (Lot No.) Code20
5401 Variant Code (Variant Code) Code10
5402 Bin Code (Bin Code) Code20
5811 Appl.-from Item Entry (Appl.-from Item Entry) Integer
5817 Correction (Correction) Boolean
6505 New Expiration Date (New Expiration Date) Date
7300 Quantity actual Handled (Base) (Quantity actual Handled (Base)) Decimal (0:5) Editable: No

Keys

# Fields
0 Entry No. (Entry No.) Clustered: Yes
1 Source ID,Source Type,Source Subtype,Source Batch Name,Source Prod. Order Line,Source Ref. No. (Source ID,Source Type,Source Subtype,Source Batch Name,Source Prod. Order Line,Source Ref. No.) MaintainSQLIndex: No
MaintainSIFTIndex: No
2 Lot No.,Serial No. (Lot No.,Serial No.)

Table Relations To Other Tables

Field Related Table Related Field
Bin Code (Bin Code) Bin Code (Code) 1..n
Item No. (Item No.) Item No. (No.) 1..n
Transfer Item Entry No. (Transfer Item Entry No.) Item Ledger Entry Entry No. (Entry No.) 1..n
Variant Code (Variant Code) Item Variant Code (Code) 1..n
Location Code (Location Code) Location Code (Code) 1..n

Table Relations From Other Tables

From Table From Field