Diagrams

Table

Item Tracing Buffer

DynamicsDocs.comItem Tracing Buffer«Table 6520»Item Tracing BufferLine No. [PK]Parent Item Ledger Entry No.LevelItem No.Posting DateEntry Type; [Purchase,Sale,Positive Ad...Source Type; [,Customer,Vendor,Item]Source No.Source NameDocument No.DescriptionLocation CodeQuantityRemaining QuantityOpenPositiveVariant CodeSerial No.Lot No.Item Ledger Entry No.Created byCreated onRecord IdentifierItem DescriptionAlready Traced«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 18»CustomerNo. [PK]NameSearch NameName 2AddressAddress 2CityContactPhone No.Telex No.Document Sending ProfileOur Account No.Territory CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeChain NameBudgeted AmountCredit Limit [LCY]Customer Posting GroupCurrency CodeCustomer Price GroupLanguage CodeStatistics GroupPayment Terms CodeFin. Charge Terms CodeSalesperson CodeShipment Method CodeShipping Agent CodePlace of ExportInvoice Disc. CodeCustomer Disc. Group...«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 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«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 2000000120»UserUser Security ID [PK]User NameFull NameState; [Enabled,Disabled]Expiry DateWindows Security IDChange PasswordLicense Type; [Full User,Limited User,...Authentication EmailContact EmailExchange IdentifierApplication ID<Item No.><Source No.><Source No.><Source No.><Location Code><Variant Code><Item Ledger Entry No.><Created by><Vendor No.><Alternative Item No.><Location Filter><Variant Filter><Item No.><Item No.><Source No.><Originally Ordered No.><Bill-to Customer No.><Location Code><Source No.><Pay-to Vendor No.><Location Code><Source No.><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 Line No. (Line No.) Integer
2 Parent Item Ledger Entry No. (Parent Item Ledger Entry No.) Integer Editable: No
3 Level (Level) Integer Editable: No
4 Item No. (Item No.) Code20 Editable: No
5 Posting Date (Posting Date) Date Editable: No
6 Entry Type (Entry Type) Option Editable: No
7 Source Type (Source Type) Option Editable: No
8 Source No. (Source No.) Code20 Editable: No
9 Source Name (Source Name) Text50 Editable: No
10 Document No. (Document No.) Code20 Editable: No
11 Description (Description) Text100 Editable: No
12 Location Code (Location Code) Code10 Editable: No
13 Quantity (Quantity) Decimal (0:5) Editable: No
14 Remaining Quantity (Remaining Quantity) Decimal (0:5) Editable: No
16 Open (Open) Boolean Editable: No
17 Positive (Positive) Boolean Editable: No
18 Variant Code (Variant Code) Code10 Editable: No
19 Serial No. (Serial No.) Code20 Editable: No
20 Lot No. (Lot No.) Code20 Editable: No
21 Item Ledger Entry No. (Item Ledger Entry No.) Integer Editable: No
22 Created by (Created by) Code50 Editable: No
23 Created on (Created on) Date Editable: No
24 Record Identifier (Record Identifier) RecordID Editable: No
25 Item Description (Item Description) Text50
26 Already Traced (Already Traced) Boolean Editable: No

Keys

# Fields
0 Line No. (Line No.) Clustered: Yes
1 Item Ledger Entry No. (Item Ledger Entry No.)
2 Serial No.,Item Ledger Entry No. (Serial No.,Item Ledger Entry No.)
3 Lot No.,Item Ledger Entry No. (Lot No.,Item Ledger Entry No.)
4 Item No.,Item Ledger Entry No. (Item No.,Item Ledger Entry No.)

Table Relations To Other Tables

Field Related Table Related Field
Source No. (Source No.) Customer No. (No.) 1..n
Source No. (Source No.) Item No. (No.) 1..n
Item Ledger Entry No. (Item Ledger 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
Created by (Created by) User User Name (User Name) 1..n
Source No. (Source No.) Vendor No. (No.) 1..n

Table Relations From Other Tables

From Table From Field