Diagrams

Table

Customer Discount Group

DynamicsDocs.comCustomer Discount Group«Table 340»Customer Discount GroupCode [PK,NN]Description«Table 110»Sales Shipment HeaderSell-to Customer No. [NN]No. [PK]Bill-to Customer No. [NN]Bill-to NameBill-to Name 2Bill-to AddressBill-to Address 2Bill-to CityBill-to ContactYour ReferenceShip-to CodeShip-to NameShip-to Name 2Ship-to AddressShip-to Address 2Ship-to CityShip-to ContactOrder DatePosting DateShipment DatePosting DescriptionPayment Terms CodeDue DatePayment Discount %Pmt. Discount DateShipment Method CodeLocation CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeCustomer Posting GroupCurrency Code...«Table 111»Sales Shipment LineSell-to Customer No.Document No. [PK]Line No. [PK]Type; [,G/L Account,Item,Resource,Fixe...No.Location CodePosting GroupShipment DateDescriptionDescription 2Unit of MeasureQuantityUnit PriceUnit Cost [LCY]VAT %Line Discount %Allow Invoice Disc.Gross WeightNet WeightUnits per ParcelUnit VolumeAppl.-to Item EntryItem Shpt. Entry No.Shortcut Dimension 1 CodeShortcut Dimension 2 CodeCustomer Price GroupJob No.Work Type CodeQty. Shipped Not InvoicedQuantity InvoicedOrder No....«Table 112»Sales Invoice HeaderSell-to Customer No. [NN]No. [PK]Bill-to Customer No. [NN]Bill-to NameBill-to Name 2Bill-to AddressBill-to Address 2Bill-to CityBill-to ContactYour ReferenceShip-to CodeShip-to NameShip-to Name 2Ship-to AddressShip-to Address 2Ship-to CityShip-to ContactOrder DatePosting DateShipment DatePosting DescriptionPayment Terms CodeDue DatePayment Discount %Pmt. Discount DateShipment Method CodeLocation CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeCustomer Posting GroupCurrency Code...«Table 113»Sales Invoice LineSell-to Customer No.Document No. [PK]Line No. [PK]Type; [,G/L Account,Item,Resource,Fixe...No.Location CodePosting GroupShipment DateDescriptionDescription 2Unit of MeasureQuantityUnit PriceUnit Cost [LCY]VAT %Line Discount %Line Discount AmountAmountAmount Including VATAllow Invoice Disc.Gross WeightNet WeightUnits per ParcelUnit VolumeAppl.-to Item EntryShortcut Dimension 1 CodeShortcut Dimension 2 CodeCustomer Price GroupJob No.Work Type CodeShipment No....«Table 114»Sales Cr.Memo HeaderSell-to Customer No. [NN]No. [PK]Bill-to Customer No. [NN]Bill-to NameBill-to Name 2Bill-to AddressBill-to Address 2Bill-to CityBill-to ContactYour ReferenceShip-to CodeShip-to NameShip-to Name 2Ship-to AddressShip-to Address 2Ship-to CityShip-to ContactPosting DateShipment DatePosting DescriptionPayment Terms CodeDue DatePayment Discount %Pmt. Discount DateShipment Method CodeLocation CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeCustomer Posting GroupCurrency CodeCurrency Factor...«Table 115»Sales Cr.Memo LineSell-to Customer No.Document No. [PK]Line No. [PK]Type; [,G/L Account,Item,Resource,Fixe...No.Location CodePosting GroupShipment DateDescriptionDescription 2Unit of MeasureQuantityUnit PriceUnit Cost [LCY]VAT %Line Discount %Line Discount AmountAmountAmount Including VATAllow Invoice Disc.Gross WeightNet WeightUnits per ParcelUnit VolumeAppl.-to Item EntryShortcut Dimension 1 CodeShortcut Dimension 2 CodeCustomer Price GroupJob No.Work Type CodeBill-to Customer No....«Table 1300»Mini Customer TemplateKey [PK]Code [NN]Template Name [NN]CityDocument Sending ProfileCredit Limit [LCY]Customer Posting GroupCurrency CodeCustomer Price GroupLanguage CodePayment Terms CodeFin. Charge Terms CodeCustomer Disc. GroupCountry/Region CodePrint StatementsPayment Method CodeApplication Method; [Manual,Apply to O...Prices Including VATGen. Bus. Posting GroupPost CodeCountyReminder Terms CodeVAT Bus. Posting GroupBlock Payment ToleranceAllow Line Disc.«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 167»JobNo. [PK]Search DescriptionDescriptionDescription 2Bill-to Customer No.Creation DateStarting DateEnding DateStatus; [Planning,Quote,Open,Completed...Person ResponsibleGlobal Dimension 1 CodeGlobal Dimension 2 CodeJob Posting GroupBlocked; [,Posting,All]Last Date ModifiedCommentCustomer Disc. GroupCustomer Price GroupLanguage CodeScheduled Res. Qty.Resource FilterPosting Date FilterResource Gr. FilterScheduled Res. Gr. Qty.PictureBill-to NameBill-to AddressBill-to Address 2Bill-to CityBill-to CountyBill-to Post Code...«Table 18»CustomerNo. [PK]NameSearch NameName 2AddressAddress 2CityContactPhone No.Telex No.Document Sending ProfileOur Account No.Territory CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeChain NameBudgeted AmountCredit Limit [LCY]Customer Posting GroupCurrency CodeCustomer Price GroupLanguage CodeStatistics GroupPayment Terms CodeFin. Charge Terms CodeSalesperson CodeShipment Method CodeShipping Agent CodePlace of ExportInvoice Disc. CodeCustomer Disc. Group...«Table 36»Sales HeaderDocument Type; [Quote,Order,Invoice,Cr...Sell-to Customer No.No. [PK]Bill-to Customer No. [NN]Bill-to NameBill-to Name 2Bill-to AddressBill-to Address 2Bill-to CityBill-to ContactYour ReferenceShip-to CodeShip-to NameShip-to Name 2Ship-to AddressShip-to Address 2Ship-to CityShip-to ContactOrder DatePosting DateShipment DatePosting DescriptionPayment Terms CodeDue DatePayment Discount %Pmt. Discount DateShipment Method CodeLocation CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeCustomer Posting Group...«Table 37»Sales LineDocument Type; [Quote,Order,Invoice,Cr...Sell-to Customer No.Document No. [PK]Line No. [PK]Type; [,G/L Account,Item,Resource,Fixe...No.Location CodePosting GroupShipment DateDescriptionDescription 2Unit of MeasureQuantityOutstanding QuantityQty. to InvoiceQty. to ShipUnit PriceUnit Cost [LCY]VAT %Line Discount %Line Discount AmountAmountAmount Including VATAllow Invoice Disc.Gross WeightNet WeightUnits per ParcelUnit VolumeAppl.-to Item EntryShortcut Dimension 1 CodeShortcut Dimension 2 Code...«Table 5105»Customer TemplateCode [PK,NN]DescriptionTerritory CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeCustomer Posting GroupCurrency CodeCustomer Price GroupPayment Terms CodeShipment Method CodeInvoice Disc. CodeCustomer Disc. GroupCountry/Region CodePayment Method CodeGen. Bus. Posting GroupVAT Bus. Posting GroupAllow Line Disc.«Table 5107»Sales Header ArchiveDocument Type; [Quote,Order,Invoice,Cr...Sell-to Customer No.No. [PK]Bill-to Customer No. [NN]Bill-to NameBill-to Name 2Bill-to AddressBill-to Address 2Bill-to CityBill-to ContactYour ReferenceShip-to CodeShip-to NameShip-to Name 2Ship-to AddressShip-to Address 2Ship-to CityShip-to ContactOrder DatePosting DateShipment DatePosting DescriptionPayment Terms CodeDue DatePayment Discount %Pmt. Discount DateShipment Method CodeLocation CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeCustomer Posting Group...«Table 5108»Sales Line ArchiveDocument Type; [Quote,Order,Invoice,Cr...Sell-to Customer No.Document No. [PK]Line No. [PK]Type; [,G/L Account,Item,Resource,Fixe...No.Location CodePosting GroupQuantity Disc. CodeShipment DateDescriptionDescription 2Unit of MeasureQuantityOutstanding QuantityQty. to InvoiceQty. to ShipUnit PriceUnit Cost [LCY]VAT %Quantity Disc. %Line Discount %Line Discount AmountAmountAmount Including VATAllow Invoice Disc.Gross WeightNet WeightUnits per ParcelUnit VolumeAppl.-to Item Entry...«Table 5900»Service HeaderDocument Type; [Quote,Order,Invoice,Cr...Customer No.No. [PK]Bill-to Customer No. [NN]Bill-to NameBill-to Name 2Bill-to AddressBill-to Address 2Bill-to CityBill-to ContactYour ReferenceShip-to CodeShip-to NameShip-to Name 2Ship-to AddressShip-to Address 2Ship-to CityShip-to ContactOrder Date [NN]Posting DatePosting DescriptionPayment Terms CodeDue DatePayment Discount %Pmt. Discount DateShipment Method CodeLocation CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeCustomer Posting GroupCurrency Code...«Table 5902»Service LineDocument Type; [Quote,Order,Invoice,Cr...Customer No.Document No. [PK]Line No. [PK]Type; [,Item,Resource,Cost,G/L Account...No.Location CodePosting GroupDescriptionDescription 2Unit of MeasureQuantityOutstanding QuantityQty. to InvoiceQty. to ShipUnit PriceUnit Cost [LCY]VAT %Line Discount %Line Discount AmountAmountAmount Including VATAllow Invoice Disc.Gross WeightNet WeightUnits per ParcelUnit VolumeAppl.-to Item EntryShortcut Dimension 1 CodeShortcut Dimension 2 CodeCustomer Price Group...«Table 5990»Service Shipment HeaderCustomer No. [NN]No. [PK]Bill-to Customer No. [NN]Bill-to NameBill-to Name 2Bill-to AddressBill-to Address 2Bill-to CityBill-to ContactYour ReferenceShip-to CodeShip-to NameShip-to Name 2Ship-to AddressShip-to Address 2Ship-to CityShip-to ContactOrder Date [NN]Posting DatePosting DescriptionPayment Terms CodeDue DatePayment Discount %Pmt. Discount DateLocation CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeCustomer Posting GroupCurrency CodeCurrency FactorCustomer Price Group...«Table 5991»Service Shipment LineCustomer No.Document No. [PK]Line No. [PK]Type; [,Item,Resource,Cost,G/L Account...No.Location CodePosting GroupDescriptionDescription 2Unit of MeasureQuantityUnit PriceUnit Cost [LCY]VAT %Line Discount %Allow Invoice Disc.Gross WeightNet WeightUnits per ParcelUnit VolumeAppl.-to Item EntryItem Shpt. Entry No.Shortcut Dimension 1 CodeShortcut Dimension 2 CodeCustomer Price GroupWork Type CodeQty. Shipped Not InvoicedQuantity InvoicedOrder No.Order Line No.Bill-to Customer No....«Table 5992»Service Invoice HeaderCustomer No. [NN]No. [PK]Bill-to Customer No. [NN]Bill-to NameBill-to Name 2Bill-to AddressBill-to Address 2Bill-to CityBill-to ContactYour ReferenceShip-to CodeShip-to NameShip-to Name 2Ship-to AddressShip-to Address 2Ship-to CityShip-to ContactOrder Date [NN]Posting DatePosting DescriptionPayment Terms CodeDue DatePayment Discount %Pmt. Discount DateLocation CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeCustomer Posting GroupCurrency CodeCurrency FactorCustomer Price Group...«Table 5993»Service Invoice LineCustomer No.Document No. [PK]Line No. [PK]Type; [,Item,Resource,Cost,G/L Account...No.Location CodePosting GroupDescriptionDescription 2Unit of MeasureQuantityUnit PriceUnit Cost [LCY]VAT %Line Discount %Line Discount AmountAmountAmount Including VATAllow Invoice Disc.Gross WeightNet WeightUnits per ParcelUnit VolumeAppl.-to Item EntryShortcut Dimension 1 CodeShortcut Dimension 2 CodeCustomer Price GroupWork Type CodeShipment No.Shipment Line No.Bill-to Customer No....«Table 5994»Service Cr.Memo HeaderCustomer No. [NN]No. [PK]Bill-to Customer No. [NN]Bill-to NameBill-to Name 2Bill-to AddressBill-to Address 2Bill-to CityBill-to ContactYour ReferenceShip-to CodeShip-to NameShip-to Name 2Ship-to AddressShip-to Address 2Ship-to CityShip-to ContactPosting DatePosting DescriptionPayment Terms CodeDue DatePayment Discount %Pmt. Discount DateLocation CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeCustomer Posting GroupCurrency CodeCurrency FactorCustomer Price GroupPrices Including VAT...«Table 5995»Service Cr.Memo LineCustomer No.Document No. [PK]Line No. [PK]Type; [,Item,Resource,Cost,G/L Account...No.Location CodePosting GroupDescriptionDescription 2Unit of MeasureQuantityUnit PriceUnit Cost [LCY]VAT %Line Discount %Line Discount AmountAmountAmount Including VATAllow Invoice Disc.Gross WeightNet WeightUnits per ParcelUnit VolumeShortcut Dimension 1 CodeShortcut Dimension 2 CodeCustomer Price GroupWork Type CodeShipment No.Bill-to Customer No.Inv. Discount AmountGen. Bus. Posting Group...«Table 6660»Return Receipt HeaderSell-to Customer No. [NN]No. [PK]Bill-to Customer No. [NN]Bill-to NameBill-to Name 2Bill-to AddressBill-to Address 2Bill-to CityBill-to ContactYour ReferenceShip-to CodeShip-to NameShip-to Name 2Ship-to AddressShip-to Address 2Ship-to CityShip-to ContactOrder DatePosting DateShipment DatePosting DescriptionPayment Terms CodeDue DatePayment Discount %Pmt. Discount DateShipment Method CodeLocation CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeCustomer Posting GroupCurrency Code...«Table 6661»Return Receipt LineSell-to Customer No.Document No. [PK]Line No. [PK]Type; [,G/L Account,Item,Resource,Fixe...No.Location CodePosting GroupShipment DateDescriptionDescription 2Unit of MeasureQuantityUnit PriceUnit Cost [LCY]VAT %Line Discount %Allow Invoice Disc.Gross WeightNet WeightUnits per ParcelUnit VolumeAppl.-to Item EntryItem Rcpt. Entry No.Shortcut Dimension 1 CodeShortcut Dimension 2 CodeCustomer Price GroupJob No.Work Type CodeQuantity InvoicedBill-to Customer No.Gen. Bus. Posting Group...«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]<Customer Disc. Group><Customer Disc. Group><Customer Disc. Group><Customer Disc. Group><Customer Disc. Group><Customer Disc. Group><Customer Disc. Group><Sales Code><Customer Disc. Group><Customer Disc. Group><Customer Disc. Group><Customer Disc. Group><Customer Disc. Group><Cust./Item Disc. Gr.><Customer Disc. Group><Customer Disc. Group><Customer Disc. Group><Customer Disc. Group><Customer Disc. Group><Customer Disc. Group><Customer Disc. Group><Customer Disc. Group><Customer Disc. Group><Customer Disc. Group><Customer Disc. Group><Sales Code><Sell-to Customer No.><Bill-to Customer No.><Document No.><Last Shipping No.><Last Shipping No.><Last Shipping No.><Sell-to Customer No.><Bill-to Customer No.><Job No.><Attached to Line No.><Blanket Order No.><Blanket Order Line No.><Sell-to Customer No.><Bill-to Customer No.><Document No.><Last Posting No.><Last Prepayment No.><Last Posting No.><Last Prepayment No.><Last Prepmt. Cr. Memo No.><Last Posting No.><Sell-to Customer No.><Bill-to Customer No.><Job No.><Attached to Line No.><Blanket Order No.><Blanket Order Line No.><Sell-to Customer No.><Bill-to Customer No.><Document No.><Last Prepmt. Cr. Memo No.><Sell-to Customer No.><Bill-to Customer No.><Job No.><Attached to Line No.><Blanket Order No.><Blanket Order Line No.><Sales Code><Bill-to Customer No.><Job No.><Job No.><Job No.><Job No.><Bill-to Customer No.><Sell-to Customer No.><Bill-to Customer No.><Sell-to Customer No.><Bill-to Customer No.><Sell-to Customer No.><Bill-to Customer No.><Sell-to Customer No.><Bill-to Customer No.><Customer No.><Bill-to Customer No.><Customer Filter><Customer No.><Bill-to Customer No.><Customer No.><Bill-to Customer No.><Customer Filter><Customer No.><Bill-to Customer No.><Customer No.><Bill-to Customer No.><Customer Filter><Customer No.><Bill-to Customer No.><Customer No.><Bill-to Customer No.><Customer Filter><Customer No.><Bill-to Customer No.><Sell-to Customer No.><Bill-to Customer No.><Sell-to Customer No.><Bill-to Customer No.><Sales Code><Sell-to Customer Template Code><Bill-to Customer Template Code><Last Return Receipt No.><Document No.><Blanket Order No.><Blanket Order No.><Blanket Order No.><Attached to Line No.><Blanket Order Line No.><Blanket Order Line No.><Blanket Order Line No.><Sell-to Customer Template Code><Last Return Receipt No.><Document No.><Attached to Line No.><Last Shipping No.><Last Posting No.><Document No.><Attached to Line No.><Document No.><Attached to Line No.><Document No.><Attached to Line No.><Document No.><Attached to Line No.>

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

Fields

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

Keys

# 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
Customer Customer Disc. Group (Customer Disc. Group) 1..n
Customer Template Customer Disc. Group (Customer Disc. Group) 1..n
Job Customer Disc. Group (Customer Disc. Group) 1..n
Mini Customer Template Customer Disc. Group (Customer Disc. Group) 1..n
Return Receipt Header Customer Disc. Group (Customer Disc. Group) 1..n
Return Receipt Line Customer Disc. Group (Customer Disc. Group) 1..n
Sales Cr.Memo Header Customer Disc. Group (Customer Disc. Group) 1..n
Sales Cr.Memo Line Customer Disc. Group (Customer Disc. Group) 1..n
Sales Header Customer Disc. Group (Customer Disc. Group) 1..n
Sales Header Archive Cust./Item Disc. Gr. (Cust./Item Disc. Gr.) 1..n
Sales Invoice Header Customer Disc. Group (Customer Disc. Group) 1..n
Sales Invoice Line Customer Disc. Group (Customer Disc. Group) 1..n
Sales Line Customer Disc. Group (Customer Disc. Group) 1..n
Sales Line Archive Customer Disc. Group (Customer Disc. Group) 1..n
Sales Line Discount Sales Code (Sales Code) 1..n
Sales Price and Line Disc Buff Sales Code (Sales Code) 1..n
Sales Shipment Header Customer Disc. Group (Customer Disc. Group) 1..n
Sales Shipment Line Customer Disc. Group (Customer Disc. Group) 1..n
Service Cr.Memo Header Customer Disc. Group (Customer Disc. Group) 1..n
Service Cr.Memo Line Customer Disc. Group (Customer Disc. Group) 1..n
Service Header Customer Disc. Group (Customer Disc. Group) 1..n
Service Invoice Header Customer Disc. Group (Customer Disc. Group) 1..n
Service Invoice Line Customer Disc. Group (Customer Disc. Group) 1..n
Service Line Customer Disc. Group (Customer Disc. Group) 1..n
Service Shipment Header Customer Disc. Group (Customer Disc. Group) 1..n
Service Shipment Line Customer Disc. Group (Customer Disc. Group) 1..n