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. Series«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 Amount«Table 8618»Config. Template HeaderCode [PK,NN]DescriptionTable IDTable NameTable CaptionUsed In HierarchyEnabledInstance No. Series«Table 3»Payment TermsCode [PK,NN]Due Date CalculationDiscount Date CalculationDiscount %DescriptionCalc. Pmt. Disc. on Cr. Memos«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. Type«Table 308»No. SeriesCode [PK,NN]DescriptionDefault Nos.Manual Nos.Date Order<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><No. Series><Posting No. Series><Journal Template Name><No. Series><Posting No. Series><Instance 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 Code10
10 Posted Sales Inv. No. Series Code10

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
Posted Sales Inv. 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

Table Relations From Other Tables

From Table From Field