Diagrams

Table

Phys. Invt. Counting Period

DynamicsDocs.comPhys. Invt. Counting Period«Table 7381»Phys. Invt. Counting PeriodCode [PK,NN]DescriptionCount Frequency per Year [NN]«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 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 5700»Stockkeeping UnitItem No. [PK,NN]Variant Code [PK]Location Code [PK]DescriptionDescription 2Assembly BOMShelf No.Unit CostStandard CostLast Direct CostVendor No.Vendor Item No.Lead Time CalculationReorder PointMaximum InventoryReorder QuantityCommentLast Date ModifiedDate FilterGlobal Dimension 1 FilterGlobal Dimension 2 FilterInventoryQty. on Purch. OrderQty. on Sales OrderDrop Shipment FilterAssembly Policy; [Assemble-to-Stock,As...Qty. on Assembly OrderQty. on Asm. ComponentQty. on Job OrderTransfer-Level CodeLot Size...«Table 7311»Warehouse Journal LineJournal Template Name [PK]Journal Batch Name [PK]Line No. [PK]Registering DateLocation Code [PK]From Zone CodeFrom Bin CodeDescriptionItem No.QuantityQty. [Base]Qty. [Absolute]Qty. [Absolute, Base]Zone CodeBin CodeSource TypeSource Subtype; [0,1,2,3,4,5,6,7,8,9,1...Source No.Source Line No.Source Subline No.Source Document; [,S. Order,S. Invoice...Source CodeTo Zone CodeTo Bin CodeReason CodeRegistering No. SeriesFrom Bin Type CodeCubageWeightWhse. Document No.Whse. Document Type; [Whse. Journal,Re......«Table 7312»Warehouse EntryEntry No. [PK]Journal Batch NameLine No.Registering DateLocation CodeZone CodeBin CodeDescriptionItem No.QuantityQty. [Base]Source TypeSource Subtype; [0,1,2,3,4,5,6,7,8,9,1...Source No.Source Line No.Source Subline No.Source Document; [,S. Order,S. Invoice...Source CodeReason CodeNo. SeriesBin Type CodeCubageWeightJournal Template NameWhse. Document No.Whse. Document Type; [Whse. Journal,Re...Whse. Document Line No.Entry Type; [Negative Adjmt.,Positive...Reference Document; [,Posted Rcpt.,Pos...Reference No.User ID...«Table 7380»Phys. Invt. Item SelectionItem No. [PK,NN]Variant Code [PK]Location Code [PK]DescriptionShelf No.Phys Invt Counting Period Code [PK]Last Counting DateCount Frequency per YearSelectedPhys Invt Counting Period Type; [,Item...Next Counting Start DateNext Counting End Date«Table 83»Item Journal LineJournal Template Name [PK]Line No. [PK]Item No.Posting DateEntry Type; [Purchase,Sale,Positive Ad...Source No.Document No.DescriptionLocation CodeInventory Posting GroupSource Posting GroupQuantityInvoiced QuantityUnit AmountUnit CostAmountDiscount AmountSalespers./Purch. CodeSource CodeApplies-to EntryItem Shpt. Entry No.Shortcut Dimension 1 CodeShortcut Dimension 2 CodeIndirect Cost %Source Type; [,Customer,Vendor,Item]Journal Batch Name [PK]Reason CodeRecurring Method; [,Fixed,Variable]Expiration DateRecurring FrequencyDrop Shipment...<Phys Invt Counting Period Code><Phys Invt Counting Period Code><Phys Invt Counting Period Code><Phys Invt Counting Period Code><Phys Invt Counting Period Code><Phys Invt Counting Period Code><Phys Invt Counting Period Code><Alternative Item No.><Item No.><Item No.><Item No.><Item No.><Item No.><Item No.><Source No.><Originally Ordered No.>

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

Fields

# Name Type
1 Code (Code) Code10 NotBlank: Yes
2 Description (Description) Text50
3 Count Frequency per Year (Count Frequency per Year) Integer NotBlank: Yes

Keys

# Fields
0 Code (Code) Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field

Table Relations From Other Tables

From Table From Field
Item Phys Invt Counting Period Code (Phys Invt Counting Period Code) 1..n
Item Journal Line Phys Invt Counting Period Code (Phys Invt Counting Period Code) 1..n
Phys. Inventory Ledger Entry Phys Invt Counting Period Code (Phys Invt Counting Period Code) 1..n
Phys. Invt. Item Selection Phys Invt Counting Period Code (Phys Invt Counting Period Code) 1..n
Stockkeeping Unit Phys Invt Counting Period Code (Phys Invt Counting Period Code) 1..n
Warehouse Entry Phys Invt Counting Period Code (Phys Invt Counting Period Code) 1..n
Warehouse Journal Line Phys Invt Counting Period Code (Phys Invt Counting Period Code) 1..n