Diagrams


Table

Nonstock Item

DynamicsDocs.comNonstock Item«Table 5718»Nonstock ItemEntry No. [PK]Manufacturer CodeVendor No.Vendor Item No.DescriptionUnit of MeasurePublished CostNegotiated CostUnit PriceGross WeightNet WeightItem Template CodeProduct Group CodeLast Date ModifiedBar CodeItem No.CommentNo. Series«Table 5715»Item SubstitutionNo. [PK,NN]Variant Code [PK]Substitute No. [PK,NN]Substitute Variant Code [PK]DescriptionInventoryInterchangeableConditionLocation FilterType; [Item,Nonstock Item] [PK]Substitute Type; [Item,Nonstock Item]...Sub. Item No.Relations LevelQuantity Avail. on Shpt. DateShipment Date«Table 5720»ManufacturerCode [PK]Name«Table 23»VendorNo. [PK]NameSearch NameName 2AddressAddress 2CityContactPhone No.Telex No.Our Account No.Territory CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeBudgeted AmountVendor Posting GroupCurrency CodeLanguage CodeStatistics GroupPayment Terms CodeFin. Charge Terms CodePurchaser CodeShipment Method CodeShipping Agent CodeInvoice Disc. CodeCountry/Region CodeCommentBlocked; [,Payment,All]Pay-to Vendor No.PriorityPayment Method Code...«Table 204»Unit of MeasureCode [PK,NN]DescriptionInternational Standard Code«Table 8618»Config. Template HeaderCode [PK,NN]DescriptionTable IDTable NameTable CaptionUsed In HierarchyEnabledInstance No. Series«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 308»No. SeriesCode [PK,NN]DescriptionDefault Nos.Manual Nos.Date Order<Manufacturer Code><Vendor No.><Unit of Measure><Item Template Code><Item No.><No. Series><No.><Substitute No.><No.><Substitute No.><Manufacturer Code><Pay-to Vendor No.><No. Series><Vendor No.><Sales Unit of Measure><Purch. Unit of Measure><Put-away Unit of Measure Code><Instance No. Series><Alternative Item No.><No. Series><Serial Nos.><Lot Nos.>

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

Fields

# Name Type
1 Entry No. Code20 Editable: Yes
2 Manufacturer Code Code10
3 Vendor No. Code20
4 Vendor Item No. Code20
5 Description Text50 Editable: Yes
6 Unit of Measure Code10
7 Published Cost Decimal
8 Negotiated Cost Decimal
9 Unit Price Decimal
10 Gross Weight Decimal (0:5)
11 Net Weight Decimal (0:5)
12 Item Template Code Code10
13 Product Group Code Code10
14 Last Date Modified Date Editable: No
15 Bar Code Code20
16 Item No. Code20 Editable: No
53 Comment Boolean Editable: No
FlowField
97 No. Series Code10 Editable: No

Keys

# Fields
0 Entry No. Clustered: Yes
1 Vendor Item No.,Manufacturer Code
2 Item No.
3 Vendor No.,Vendor Item No.

Table Relations To Other Tables

Field Related Table Related Field
Item Template Code Config. Template Header Code 1..n
Item No. Item No. 1..n
Manufacturer Code Manufacturer Code 1..n
No. Series No. Series Code 1..n
Unit of Measure Unit of Measure Code 1..n
Vendor No. Vendor No. 1..n

Table Relations From Other Tables

From Table From Field
Item Substitution Substitute No. 1..n