Diagrams


Table

Item Template

DynamicsDocs.comItem Template«Table 1301»Item TemplateKey [PK]Code [NN]Template Name [NN]Base Unit of MeasureType; [Inventory,Service]Inventory Posting GroupItem Disc. GroupAllow Invoice Disc.Price/Profit Calculation; [Profit=Pric...Profit %Costing Method; [FIFO,LIFO,Specific,Av...Indirect Cost %Price Includes VATGen. Prod. Posting GroupAutomatic Ext. TextsTax Group CodeVAT Prod. Posting GroupItem Category CodeService Item GroupWarehouse Class Code«Table 204»Unit of MeasureCode [PK,NN]DescriptionInternational Standard CodeSymbolLast Modified Date TimeId«Table 94»Inventory Posting GroupCode [PK,NN]DescriptionUsed in ItemsUsed in Value Entries«Table 341»Item Discount GroupCode [PK,NN]Description«Table 251»Gen. Product Posting GroupCode [PK,NN]DescriptionDef. VAT Prod. Posting GroupAuto Insert Default«Table 321»Tax GroupCode [PK,NN]DescriptionIdLast Modified DateTime«Table 324»VAT Product Posting GroupCode [PK,NN]DescriptionIdLast Modified DateTime«Table 5722»Item CategoryCode [PK,NN]Parent CategoryDescriptionIndentationPresentation OrderHas ChildrenLast Modified Date TimeId«Table 5904»Service Item GroupCode [PK,NN]DescriptionCreate Service ItemDefault Contract Discount %Default Serv. Price Group CodeDefault Response Time [Hours]«Table 7304»Warehouse ClassCode [PK,NN]Description<Base Unit of Measure><Inventory Posting Group><Item Disc. Group><Gen. Prod. Posting Group><Tax Group Code><VAT Prod. Posting Group><Item Category Code><Service Item Group><Warehouse Class Code><Def. VAT Prod. Posting Group><Parent Category>

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

Fields

# Name Type
1 Key Integer AutoIncrement: Yes
2 Code Code10 NotBlank: Yes
3 Template Name Text50 NotBlank: Yes
8 Base Unit of Measure Code10
10 Type Option
11 Inventory Posting Group Code20
14 Item Disc. Group Code20
15 Allow Invoice Disc. Boolean
19 Price/Profit Calculation Option
20 Profit % Decimal (0:5)
21 Costing Method Option
28 Indirect Cost % Decimal (0:5)
87 Price Includes VAT Boolean
91 Gen. Prod. Posting Group Code20
96 Automatic Ext. Texts Boolean
98 Tax Group Code Code20
99 VAT Prod. Posting Group Code20
5702 Item Category Code Code20
5900 Service Item Group Code10
7300 Warehouse Class Code Code10

Keys

# Fields
0 Key Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Gen. Prod. Posting Group Gen. Product Posting Group Code 1..n
Inventory Posting Group Inventory Posting Group Code 1..n
Item Category Code Item Category Code 1..n
Item Disc. Group Item Discount Group Code 1..n
Service Item Group Service Item Group Code 1..n
Tax Group Code Tax Group Code 1..n
Base Unit of Measure Unit of Measure Code 1..n
VAT Prod. Posting Group VAT Product Posting Group Code 1..n
Warehouse Class Code Warehouse Class Code 1..n

Table Relations From Other Tables

From Table From Field