Diagrams


Table

O365 Sales Initial Setup

DynamicsDocs.comO365 Sales Initial Setup«Table 2110»O365 Sales Initial SetupPrimary Key [PK]Payment Reg. Template NamePayment Reg. Batch NameIs initializedDefault Customer TemplateDefault Item TemplateDefault Payment Terms CodeDefault Payment Method CodeSales Invoice No. SeriesPosted Sales Inv. No. SeriesTax Type; [VAT,Sales Tax]Default VAT Bus. Posting GroupNormal VAT Prod. Posting Gr.Reduced VAT Prod. Posting Gr.Zero VAT Prod. Posting Gr.C2Graph EndpointSales Quote No. SeriesEngage EndpointCoupons Integration EnabledGraph Enablement Reminder«Table 80»Gen. Journal TemplateName [PK,NN]DescriptionTest Report IDPage IDPosting Report IDForce Posting ReportType; [General,Sales,Purchases,Cash Re...Source CodeReason CodeRecurringTest Report CaptionPage CaptionPosting Report CaptionForce Doc. BalanceBal. Account Type; [G/L Account,Custom...Bal. Account No.No. SeriesPosting No. SeriesCopy VAT Setup to Jnl. LinesAllow VAT DifferenceCust. Receipt Report IDCust. Receipt Report CaptionVendor Receipt Report IDVendor Receipt Report Caption«Table 232»Gen. Journal BatchJournal Template Name [PK,NN]Name [PK,NN]DescriptionReason CodeBal. Account Type; [G/L Account,Custom...Bal. Account No.No. SeriesPosting No. SeriesCopy VAT Setup to Jnl. LinesAllow VAT DifferenceAllow Payment ExportBank Statement Import FormatTemplate Type; [General,Sales,Purchase...RecurringSuggest Balancing AmountIdLast Modified DateTime«Table 8618»Config. Template HeaderCode [PK,NN]DescriptionTable IDTable NameTable CaptionUsed In HierarchyEnabled«Table 3»Payment TermsCode [PK,NN]Due Date CalculationDiscount Date CalculationDiscount %DescriptionCalc. Pmt. Disc. on Cr. MemosLast Modified Date TimeId«Table 289»Payment MethodCode [PK,NN]DescriptionBal. Account Type; [G/L Account,Bank A...Bal. Account No.Direct DebitDirect Debit Pmt. Terms CodePmt. Export Line DefinitionBank Data Conversion Pmt. TypeUse for InvoicingLast Modified Date TimeId«Table 308»No. SeriesCode [PK,NN]DescriptionDefault Nos.Manual Nos.Date Order«Table 323»VAT Business Posting GroupCode [PK,NN]DescriptionLast Modified Date TimeId«Table 324»VAT Product Posting GroupCode [PK,NN]DescriptionIdLast Modified DateTime<Payment Reg. Template Name><Payment Reg. Batch Name><Default Customer Template><Default Item Template><Default Payment Terms Code><Default Payment Method Code><Sales Invoice No. Series><Posted Sales Inv. No. Series><Sales Quote No. Series><Default VAT Bus. Posting Group><Normal VAT Prod. Posting Gr.><Reduced VAT Prod. Posting Gr.><Zero VAT Prod. Posting Gr.><No. Series><Posting No. Series><Journal Template Name><No. Series><Posting No. Series><Direct Debit Pmt. Terms Code>

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

Fields

# Name Type
1 Primary Key Code10
2 Payment Reg. Template Name Code10
3 Payment Reg. Batch Name Code10
4 Is initialized Boolean
5 Default Customer Template Code10
6 Default Item Template Code10
7 Default Payment Terms Code Code10
8 Default Payment Method Code Code10
9 Sales Invoice No. Series Code20
10 Posted Sales Inv. No. Series Code20
11 Tax Type Option
12 Default VAT Bus. Posting Group Code20
13 Normal VAT Prod. Posting Gr. Code20
14 Reduced VAT Prod. Posting Gr. Code20
15 Zero VAT Prod. Posting Gr. Code20
16 C2Graph Endpoint Text250
17 Sales Quote No. Series Code20
18 Engage Endpoint Text250
19 Coupons Integration Enabled Boolean
20 Graph Enablement Reminder Boolean

Keys

# Fields
0 Primary Key Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Default Item Template Config. Template Header Code 1..n
Payment Reg. Batch Name Gen. Journal Batch Name 1..n
Payment Reg. Template Name Gen. Journal Template Name 1..n
Sales Quote No. Series No. Series Code 1..n
Default Payment Method Code Payment Method Code 1..n
Default Payment Terms Code Payment Terms Code 1..n
Default VAT Bus. Posting Group VAT Business Posting Group Code 1..n
Zero VAT Prod. Posting Gr. VAT Product Posting Group Code 1..n

Table Relations From Other Tables

From Table From Field