Item Discount Group

DynamicsDocs.comItem Discount Group«Table 341»Item Discount GroupCode [PK,NN]Description«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 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


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


# Fields
0 Code (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 (Item Disc. Group) 1..n
Item Template Item Disc. Group (Item Disc. Group) 1..n
Sales Line Discount Code (Code) 1..n
Sales Price and Line Disc Buff Code (Code) 1..n