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. Integer
2 Item No. Code20
3 Posting Date Date
4 Entry Type Option
6 Document No. Code20
7 Description Text50
8 Location Code Code10
9 Inventory Posting Group Code20
12 Quantity Decimal (0:5)
15 Unit Amount Decimal
16 Unit Cost Decimal
17 Amount Decimal
22 Salespers./Purch. Code Code20
24 User ID Code50
25 Source Code Code10
33 Global Dimension 1 Code Code20
34 Global Dimension 2 Code Code20
45 Journal Batch Name Code10
46 Reason Code Code10
54 Qty. (Calculated) Decimal (0:5)
55 Qty. (Phys. Inventory) Decimal (0:5)
56 Last Item Ledger Entry No. Integer
60 Document Date Date
61 External Document No. Code35
64 No. Series Code20
480 Dimension Set ID Integer Editable: No
5402 Variant Code Code10
5407 Unit of Measure Code Code10
7380 Phys Invt Counting Period Code Code10 Editable: No
7381 Phys Invt Counting Period Type Option Editable: No

Keys

# Fields
0 Entry No. Clustered: Yes
1 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
3 Document No.,Posting Date
4 Item No.,Phys Invt Counting Period Type,Posting Date

Table Relations To Other Tables

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

Table Relations From Other Tables

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