Diagrams


Table

Item Discount Group

DynamicsDocs.comItem Discount Group«Table 341»Item Discount GroupCode [PK,NN]Description«Table 1301»Mini 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. TextsVAT Prod. Posting Group«Table 1304»Sales Price and Line Disc BuffCode [PK,NN]Sales Code [PK]Currency Code [PK]Starting Date [PK]Line Discount %Unit PricePrice Includes VATAllow Invoice Disc.VAT Bus. Posting Gr. [Price]Sales Type; [Customer,Customer Price/D...Minimum Quantity [PK]Ending DateType; [Item,Item Disc. Group] [PK]Line Type; [,Sales Line Discount,Sales...Loaded Item No. [PK]Loaded Disc. Group [PK]Loaded Customer No. [PK]Loaded Price Group [PK]Unit of Measure Code [PK]Variant Code [PK]Allow Line Disc.«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 7004»Sales Line DiscountCode [PK,NN]Sales Code [PK]Currency Code [PK]Starting Date [PK]Line Discount %Sales Type; [Customer,Customer Disc. G...Minimum Quantity [PK]Ending DateType; [Item,Item Disc. Group] [PK]Unit of Measure Code [PK]Variant Code [PK]<Item Disc. Group><Code><Item Disc. Group><Code><Code><Alternative Item No.><Code>

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

Fields

# Name Type
1 Code Code20 NotBlank: Yes
2 Description Text50

Keys

# Fields
0 Code Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field

Table Relations From Other Tables

From Table From Field
Item Item Disc. Group 1..n
Mini Item Template Item Disc. Group 1..n
Sales Line Discount Code 1..n
Sales Price and Line Disc Buff Code 1..n