Diagrams

Table

Family Line

DynamicsDocs.comFamily Line«Table 99000774»Family LineFamily No. [PK,NN]Line No. [PK]Item No. [NN]DescriptionDescription 2Unit of Measure CodeQuantityLow-Level Code«Table 99000773»FamilyNo. [PK,NN]DescriptionDescription 2Search NameBlockedLast Date ModifiedRouting 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 5404»Item Unit of MeasureItem No. [PK,NN]Code [PK,NN]Qty. per Unit of MeasureLengthWidthHeightCubageWeight<Family No.><Item No.><Unit of Measure Code><Alternative Item No.><Sales Unit of Measure><Purch. Unit of Measure><Put-away Unit of Measure Code><Item No.>

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

Fields

# Name Type
1 Family No. (Family No.) Code20 NotBlank: Yes
2 Line No. (Line No.) Integer
8 Item No. (Item No.) Code20 NotBlank: Yes
10 Description (Description) Text50
11 Description 2 (Description 2) Text50
12 Unit of Measure Code (Unit of Measure Code) Code10
20 Quantity (Quantity) Decimal (0:5)
25 Low-Level Code (Low-Level Code) Integer

Keys

# Fields
0 Family No.,Line No. (Family No.,Line No.) Clustered: Yes
1 Low-Level Code (Low-Level Code)

Table Relations To Other Tables

Field Related Table Related Field
Family No. (Family No.) Family No. (No.) 1..n
Item No. (Item No.) Item No. (No.) 1..n
Unit of Measure Code (Unit of Measure Code) Item Unit of Measure Code (Code) 1..n

Table Relations From Other Tables

From Table From Field