Mini Item Template


# 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
99 VAT Prod. Posting Group Code10


# 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 Disc. Group Item Discount Group Code 1..n
VAT Prod. Posting Group VAT Product Posting Group Code 1..n

Table Relations From Other Tables

From Table From Field