Diagrams


Table

Item Template

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 Code10
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 Code10
96 Automatic Ext. Texts Boolean
98 Tax Group Code Code10
99 VAT Prod. Posting Group Code10
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
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