Whse. Item Tracking Line

DynamicsDocs.comWhse. Item Tracking Line«Table 6550»Whse. Item Tracking LineEntry No. [PK]Item No.Location CodeQuantity [Base]DescriptionSource TypeSource Subtype; [0,1,2,3,4,5,6,7,8,9,1...Source IDSource Batch NameSource Prod. Order LineSource Ref. No.Serial No.Qty. per Unit of MeasureWarranty DateExpiration DateQty. to Handle [Base]Qty. to Invoice [Base]Quantity Handled [Base]Quantity Invoiced [Base]Qty. to HandleBuffer Status; [,MODIFY]Buffer Status2; [,ExpDate blocked]New Serial No.New Lot No.Source Type Filter; [,Receipt,Shipment...Qty. Registered [Base]Put-away Qty. [Base]Pick Qty. [Base]Created by Whse. Activity LineLot No.Variant Code...«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 5401»Item VariantCode [PK,NN]Item No. [PK,NN]DescriptionDescription 2<Item No.><Location Code><Variant Code><Alternative Item No.><Location Filter><Variant Filter><Item No.>

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


# 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
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
24 Serial No. (Serial No.) Code20
29 Qty. per Unit of Measure (Qty. per Unit of Measure) Decimal (0:5) Editable: No
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)
70 Buffer Status (Buffer Status) Option Editable: No
71 Buffer Status2 (Buffer Status2) Option Editable: No
80 New Serial No. (New Serial No.) Code20
81 New Lot No. (New Lot No.) Code20
90 Source Type Filter (Source Type Filter) Option FlowFilter
91 Qty. Registered (Base) (Qty. Registered (Base)) Decimal
92 Put-away Qty. (Base) (Put-away Qty. (Base)) Decimal FlowField
93 Pick Qty. (Base) (Pick Qty. (Base)) Decimal FlowField
94 Created by Whse. Activity Line (Created by Whse. Activity Line) Boolean
5400 Lot No. (Lot No.) Code20
5401 Variant Code (Variant Code) Code10
6505 New Expiration Date (New Expiration Date) Date


# 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.,Location Code (Source ID,Source Type,Source Subtype,Source Batch Name,Source Prod. Order Line,Source Ref. No.,Location Code) MaintainSIFTIndex: No
2 Serial No.,Lot No. (Serial No.,Lot No.)

Table Relations To Other Tables

Field Related Table Related Field
Item No. (Item No.) Item No. (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