Diagrams


Table

Phys. Inventory Ledger Entry

DynamicsDocs.comPhys. Inventory Ledger Entry«Table 281»Phys. Inventory Ledger EntryEntry No. [PK]Item No.Posting DateEntry Type; [Purchase,Sale,Positive Ad...Document No.DescriptionLocation CodeInventory Posting GroupQuantityUnit AmountUnit CostAmountSalespers./Purch. CodeUser IDSource CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeJournal Batch NameReason CodeQty. [Calculated]Qty. [Phys. Inventory]Last Item Ledger Entry No.Document DateExternal Document No.No. SeriesDimension Set IDVariant CodeUnit of Measure CodePhys Invt Counting Period CodePhys Invt Counting Period Type; [,Item...«Table 46»Item RegisterNo. [PK]From Entry No.To Entry No.Creation DateSource CodeUser IDJournal Batch NameFrom Phys. Inventory Entry No.To Phys. Inventory Entry No.From Value Entry No.To Value Entry No.From Capacity Entry No.To Capacity Entry No.«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 94»Inventory Posting GroupCode [PK,NN]DescriptionUsed in ItemsUsed in Value Entries«Table 13»Salesperson/PurchaserCode [PK,NN]NameCommission %ImageGlobal Dimension 1 CodeGlobal Dimension 2 CodeE-MailPhone No.Next Task DateNo. of OpportunitiesEstimated Value [LCY]Calcd. Current Value [LCY]Date FilterNo. of InteractionsCost [LCY]Duration [Min.]Job TitleAction Taken Filter; [,Next,Previous,U...Sales Cycle FilterSales Cycle Stage FilterProbability % FilterCompleted % FilterAvg. Estimated Value [LCY]Avg.Calcd. Current Value [LCY]Contact FilterContact Company FilterCampaign FilterEstimated Value FilterCalcd. Current Value FilterChances of Success % FilterTask Status Filter; [Not Started,In Pr......«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«Table 230»Source CodeCode [PK,NN]Description«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 231»Reason CodeCode [PK,NN]DescriptionDate FilterContract Gain/Loss Amount«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 308»No. SeriesCode [PK,NN]DescriptionDefault Nos.Manual Nos.Date Order«Table 480»Dimension Set EntryDimension Set ID [PK]Dimension Code [PK,NN]Dimension Value Code [NN]Dimension Value IDDimension NameDimension Value Name«Table 5401»Item VariantCode [PK,NN]Item No. [PK,NN]DescriptionDescription 2«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.><Location Code><Inventory Posting Group><Salespers./Purch. Code><User ID><Source Code><Global Dimension 1 Code><Global Dimension 2 Code><Reason Code><Last Item Ledger Entry No.><No. Series><Dimension Set ID><Variant Code><Unit of Measure Code><Phys Invt Counting Period Code><From Phys. Inventory Entry No.><To Phys. Inventory Entry No.><From Entry No.><To Entry No.><Source Code><User ID><Inventory Posting Group><Alternative Item No.><Global Dimension 1 Filter><Global Dimension 2 Filter><Global Dimension 1 Code><Global Dimension 2 Code><Location Filter><No. Series><Serial Nos.><Lot Nos.><Variant Filter><Item No.><Sales Unit of Measure><Purch. Unit of Measure><Put-away Unit of Measure Code><Item No.><Phys Invt Counting Period Code><Item No.><Source No.><Originally Ordered No.><Location Code><Global Dimension 1 Code><Global Dimension 2 Code><Global Dimension 1 Code><Global Dimension 2 Code><Dimension Value Code><No. Series><Dimension Set ID><Variant Code><Originally Ordered Var. Code><Unit of Measure 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 Posting Date (Posting Date) Date
4 Entry Type (Entry Type) Option
6 Document No. (Document No.) Code20
7 Description (Description) Text50
8 Location Code (Location Code) Code10
9 Inventory Posting Group (Inventory Posting Group) Code20
12 Quantity (Quantity) Decimal (0:5)
15 Unit Amount (Unit Amount) Decimal
16 Unit Cost (Unit Cost) Decimal
17 Amount (Amount) Decimal
22 Salespers./Purch. Code (Salespers./Purch. Code) Code20
24 User ID (User ID) Code50
25 Source Code (Source Code) Code10
33 Global Dimension 1 Code (Global Dimension 1 Code) Code20
34 Global Dimension 2 Code (Global Dimension 2 Code) Code20
45 Journal Batch Name (Journal Batch Name) Code10
46 Reason Code (Reason Code) Code10
54 Qty. (Calculated) (Qty. (Calculated)) Decimal (0:5)
55 Qty. (Phys. Inventory) (Qty. (Phys. Inventory)) Decimal (0:5)
56 Last Item Ledger Entry No. (Last Item Ledger Entry No.) Integer
60 Document Date (Document Date) Date
61 External Document No. (External Document No.) Code35
64 No. Series (No. Series) Code20
480 Dimension Set ID (Dimension Set ID) Integer Editable: No
5402 Variant Code (Variant Code) Code10
5407 Unit of Measure Code (Unit of Measure Code) Code10
7380 Phys Invt Counting Period Code (Phys Invt Counting Period Code) Code10 Editable: No
7381 Phys Invt Counting Period Type (Phys Invt Counting Period Type) Option Editable: No

Keys

# Fields
0 Entry No. (Entry No.) Clustered: Yes
1 Item No.,Variant Code,Location Code,Posting Date (Item No.,Variant Code,Location Code,Posting Date)
2 Item No.,Variant Code,Global Dimension 1 Code,Global Dimension 2 Code,Location Code,Posting Date (Item No.,Variant Code,Global Dimension 1 Code,Global Dimension 2 Code,Location Code,Posting Date)
3 Document No.,Posting Date (Document No.,Posting Date)
4 Item No.,Phys Invt Counting Period Type,Posting Date (Item No.,Phys Invt Counting Period Type,Posting Date)

Table Relations To Other Tables

Field Related Table Related Field
Dimension Set ID (Dimension Set ID) Dimension Set Entry () 1..n
Global Dimension 2 Code (Global Dimension 2 Code) Dimension Value Code (Code) 1..n
Inventory Posting Group (Inventory Posting Group) Inventory Posting Group Code (Code) 1..n
Item No. (Item No.) Item No. (No.) 1..n
Last Item Ledger Entry No. (Last Item Ledger Entry No.) Item Ledger Entry Entry No. (Entry No.) 1..n
Unit of Measure Code (Unit of Measure Code) Item Unit of Measure Code (Code) 1..n
Variant Code (Variant Code) Item Variant Code (Code) 1..n
Location Code (Location Code) Location Code (Code) 1..n
No. Series (No. Series) No. Series Code (Code) 1..n
Phys Invt Counting Period Code (Phys Invt Counting Period Code) Phys. Invt. Counting Period Code (Code) 1..n
Reason Code (Reason Code) Reason Code Code (Code) 1..n
Salespers./Purch. Code (Salespers./Purch. Code) Salesperson/Purchaser Code (Code) 1..n
Source Code (Source Code) Source Code Code (Code) 1..n
User ID (User ID) User User Name (User Name) 1..n

Table Relations From Other Tables

From Table From Field
Item Register To Phys. Inventory Entry No. (To Phys. Inventory Entry No.) 1..n