Diagrams


Table

Phys. Invt. Item Selection

DynamicsDocs.comPhys. Invt. Item Selection«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 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 5401»Item VariantCode [PK,NN]Item No. [PK,NN]DescriptionDescription 2«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 7381»Phys. Invt. Counting PeriodCode [PK,NN]DescriptionCount Frequency per Year [NN]<Item No.><Variant Code><Location Code><Phys Invt Counting Period Code><Alternative Item No.><Location Filter><Variant Filter><Item No.><Phys Invt Counting Period Code>

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

Fields

# Name Type
1 Item No. Code20 NotBlank: Yes
Editable: No
2 Variant Code Code10 Editable: No
3 Location Code Code10 Editable: No
4 Description Text50 Editable: No
FlowField
5 Shelf No. Code10 Editable: No
6 Phys Invt Counting Period Code Code10 Editable: No
7 Last Counting Date Date Editable: No
9 Count Frequency per Year Integer BlankZero: Yes
Editable: No
10 Selected Boolean
11 Phys Invt Counting Period Type Option
12 Next Counting Start Date Date Editable: No
13 Next Counting End Date Date Editable: No

Keys

# Fields
0 Item No.,Variant Code,Location Code,Phys Invt Counting Period Code Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Item No. Item No. 1..n
Variant Code Item Variant Code 1..n
Location Code Location 1..n
Phys Invt Counting Period Code Phys. Invt. Counting Period Code 1..n

Table Relations From Other Tables

From Table From Field