Diagrams


Table

Customer Template

DynamicsDocs.comCustomer Template«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 352»Default DimensionTable ID [PK,NN]No. [PK]Dimension Code [PK,NN]Dimension Value CodeValue Posting; [,Code Mandatory,Same C...Table CaptionMulti Selection Action; [,Change,Delet...«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 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 286»TerritoryCode [PK,NN]Name«Table 349»Dimension ValueDimension Code [PK,NN]Code [PK,NN]NameDimension Value Type; [Standard,Headin...TotalingBlockedConsolidation CodeIndentationGlobal Dimension No.Map-to IC Dimension CodeMap-to IC Dimension Value CodeDimension Value ID«Table 92»Customer Posting GroupCode [PK,NN]Receivables AccountService Charge Acc.Payment Disc. Debit Acc.Invoice Rounding AccountAdditional Fee AccountInterest AccountDebit Curr. Appln. Rndg. Acc.Credit Curr. Appln. Rndg. Acc.Debit Rounding AccountCredit Rounding AccountPayment Disc. Credit Acc.Payment Tolerance Debit Acc.Payment Tolerance Credit Acc.Add. Fee per Line Account«Table 4»CurrencyCode [PK,NN]Last Date ModifiedLast Date AdjustedUnrealized Gains Acc.Realized Gains Acc.Unrealized Losses Acc.Realized Losses Acc.Invoice Rounding PrecisionInvoice Rounding Type; [Nearest,Up,Dow...Amount Rounding PrecisionUnit-Amount Rounding PrecisionDescriptionAmount Decimal Places [NN]Unit-Amount Decimal Places [NN]Customer FilterVendor FilterGlobal Dimension 1 FilterGlobal Dimension 2 FilterDate FilterCust. Ledg. Entries in FilterCustomer BalanceCustomer Outstanding OrdersCustomer Shipped Not InvoicedCustomer Balance DueVendor Ledg. Entries in FilterVendor BalanceVendor Outstanding OrdersVendor Amt. Rcd. Not InvoicedVendor Balance DueCustomer Balance [LCY]Vendor Balance [LCY]...«Table 6»Customer Price GroupCode [PK,NN]Price Includes VATAllow Invoice Disc.VAT Bus. Posting Gr. [Price]DescriptionAllow Line Disc.«Table 3»Payment TermsCode [PK,NN]Due Date CalculationDiscount Date CalculationDiscount %DescriptionCalc. Pmt. Disc. on Cr. Memos«Table 10»Shipment MethodCode [PK,NN]Description«Table 340»Customer Discount GroupCode [PK,NN]Description«Table 9»Country/RegionCode [PK,NN]NameEU Country/Region CodeIntrastat CodeAddress Format; [Post Code+City,City+P...Contact Address Format; [First,After C...VAT Scheme«Table 289»Payment MethodCode [PK,NN]DescriptionBal. Account Type; [G/L Account,Bank A...Bal. Account No.Payment Processor; [,Dynamics Online]Direct DebitDirect Debit Pmt. Terms CodePmt. Export Line DefinitionBank Data Conversion Pmt. Type«Table 250»Gen. Business Posting GroupCode [PK,NN]DescriptionDef. VAT Bus. Posting GroupAuto Insert Default«Table 323»VAT Business Posting GroupCode [PK,NN]Description<Territory Code><Global Dimension 1 Code><Global Dimension 2 Code><Customer Posting Group><Currency Code><Customer Price Group><Payment Terms Code><Shipment Method Code><Customer Disc. Group><Country/Region Code><Payment Method Code><Gen. Bus. Posting Group><VAT Bus. Posting Group><No.><Sell-to Customer Template Code><Bill-to Customer Template Code><Sell-to Customer Template Code><Dimension Value Code><Payment Terms Code><Prepmt. Payment Terms Code><Shipment Method Code><Shortcut Dimension 1 Code><Shortcut Dimension 2 Code><Customer Posting Group><Currency Code><Customer Price Group><Customer Disc. Group><Gen. Bus. Posting Group><VAT Country/Region Code><Bill-to Country/Region Code><Sell-to Country/Region Code><Ship-to Country/Region Code><Payment Method Code><VAT Bus. Posting Group><Payment Terms Code><Prepmt. Payment Terms Code><Shipment Method Code><Shortcut Dimension 1 Code><Shortcut Dimension 2 Code><Customer Posting Group><Currency Code><Price Group Code><Cust./Item Disc. Gr.><Gen. Bus. Posting Group><VAT Country/Region Code><Bill-to Country/Region Code><Sell-to Country/Region Code><Ship-to Country/Region Code><Payment Method Code><VAT Bus. Posting Group><Global Dimension 1 Filter><Global Dimension 2 Filter><VAT Bus. Posting Gr. (Price)><Direct Debit Pmt. Terms Code><Def. VAT Bus. Posting Group>

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 Description Text50
15 Territory Code Code10
16 Global Dimension 1 Code Code20
17 Global Dimension 2 Code Code20
21 Customer Posting Group Code10
22 Currency Code Code10
23 Customer Price Group Code10
27 Payment Terms Code Code10
30 Shipment Method Code Code10
33 Invoice Disc. Code Code20
34 Customer Disc. Group Code20
35 Country/Region Code Code10
47 Payment Method Code Code10
88 Gen. Bus. Posting Group Code10
110 VAT Bus. Posting Group Code10
7001 Allow Line Disc. Boolean

Keys

# Fields
0 Code Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Country/Region Code Country/Region Code 1..n
Currency Code Currency Code 1..n
Customer Disc. Group Customer Discount Group Code 1..n
Customer Posting Group Customer Posting Group Code 1..n
Customer Price Group Customer Price Group Code 1..n
Global Dimension 2 Code Dimension Value Code 1..n
Gen. Bus. Posting Group Gen. Business Posting Group Code 1..n
Payment Method Code Payment Method Code 1..n
Payment Terms Code Payment Terms Code 1..n
Shipment Method Code Shipment Method Code 1..n
Territory Code Territory Code 1..n
VAT Bus. Posting Group VAT Business Posting Group Code 1..n

Table Relations From Other Tables

From Table From Field
Default Dimension No. 1..n
Sales Header Bill-to Customer Template Code 1..n
Sales Header Archive Sell-to Customer Template Code 1..n