Diagrams


Table

Customer Price Group

DynamicsDocs.comCustomer Price Group«Table 6»Customer Price GroupCode [PK,NN]Price Includes VATAllow Invoice Disc.VAT Bus. Posting Gr. [Price]DescriptionAllow Line Disc.«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 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 459»Sales Prepayment %Item No. [PK,NN]Sales Type; [Customer,Customer Price G...Sales Code [PK]Starting Date [PK]Ending DatePrepayment %«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 6081»Serv. Price Group SetupService Price Group Code [PK,NN]Fault Area Code [PK]Cust. Price Group Code [PK]Currency Code [PK]Starting Date [PK]Serv. Price Adjmt. Gr. CodeInclude DiscountsAdjustment Type; [Fixed,Maximum,Minimu...AmountInclude VAT«Table 7002»Sales PriceItem No. [PK,NN]Sales Code [PK]Currency Code [PK]Starting Date [PK]Unit PricePrice Includes VATAllow Invoice Disc.VAT Bus. Posting Gr. [Price]Sales Type; [Customer,Customer Price G...Minimum Quantity [PK]Ending DateUnit of Measure Code [PK]Variant Code [PK]Allow Line Disc.«Table 7023»Sales Price WorksheetItem No. [PK,NN]Sales Code [PK]Currency Code [PK]Starting Date [PK]Current Unit PriceNew Unit PricePrice Includes VATAllow Invoice Disc.VAT Bus. Posting Gr. [Price]Sales Type; [Customer,Customer Price G...Minimum Quantity [PK]Ending Date [PK]Item DescriptionSales DescriptionUnit of Measure Code [PK]Variant Code [PK]Allow Line Disc.«Table 323»VAT Business Posting GroupCode [PK,NN]Description<VAT Bus. Posting Gr. (Price)><Customer Price Group><Customer Price Group><Customer Price Group><Sales Code><Customer Price Group><Cust. Price Group Code><Sales Code><Sales Code><VAT Bus. Posting Group><Bill-to Customer No.><Bill-to Customer No.><VAT Bus. Posting Group><Sales Code><Sales Code><Sales Code><VAT Bus. Posting Group><VAT Bus. Posting Gr. (Price)><VAT Bus. Posting Gr. (Price)>

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

Fields

# Name Type
1 Code Code10 NotBlank: Yes
2 Price Includes VAT Boolean
5 Allow Invoice Disc. Boolean
6 VAT Bus. Posting Gr. (Price) Code10
10 Description Text50
7001 Allow Line Disc. Boolean

Keys

# Fields
0 Code Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
VAT Bus. Posting Gr. (Price) VAT Business Posting Group Code 1..n

Table Relations From Other Tables

From Table From Field
Customer Customer Price Group 1..n
Customer Template Customer Price Group 1..n
Job Customer Price Group 1..n
Job Journal Line Customer Price Group 1..n
Job Ledger Entry Customer Price Group 1..n
Job Planning Line Customer Price Group 1..n
Mini Customer Template Customer Price Group 1..n
Return Receipt Header Customer Price Group 1..n
Return Receipt Line Customer Price Group 1..n
Sales Cr.Memo Header Customer Price Group 1..n
Sales Cr.Memo Line Customer Price Group 1..n
Sales Header Customer Price Group 1..n
Sales Header Archive Price Group Code 1..n
Sales Invoice Header Customer Price Group 1..n
Sales Invoice Line Customer Price Group 1..n
Sales Line Customer Price Group 1..n
Sales Line Archive Price Group Code 1..n
Sales Prepayment % Sales Code 1..n
Sales Price Sales Code 1..n
Sales Price Worksheet Sales Code 1..n
Sales Price and Line Disc Buff Sales Code 1..n
Sales Shipment Header Customer Price Group 1..n
Sales Shipment Line Customer Price Group 1..n
Serv. Price Group Setup Cust. Price Group Code 1..n
Service Cr.Memo Header Customer Price Group 1..n
Service Cr.Memo Line Customer Price Group 1..n
Service Header Customer Price Group 1..n
Service Invoice Header Customer Price Group 1..n
Service Invoice Line Customer Price Group 1..n
Service Line Customer Price Group 1..n
Service Shipment Header Customer Price Group 1..n
Service Shipment Line Customer Price Group 1..n