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 (Primary Key) Code10
2 Payment Reg. Template Name (Payment Reg. Template Name) Code10
3 Payment Reg. Batch Name (Payment Reg. Batch Name) Code10
4 Is initialized (Is initialized) Boolean
5 Default Customer Template (Default Customer Template) Code10
6 Default Item Template (Default Item Template) Code10
7 Default Payment Terms Code (Default Payment Terms Code) Code10
8 Default Payment Method Code (Default Payment Method Code) Code10
9 Sales Invoice No. Series (Sales Invoice No. Series) Code10
10 Posted Sales Inv. No. Series (Posted Sales Inv. No. Series) Code10

Keys

# Fields
0 Primary Key (Primary Key) Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Default Item Template (Default Item Template) Config. Template Header Code (Code) 1..n
Payment Reg. Batch Name (Payment Reg. Batch Name) Gen. Journal Batch Name (Name) 1..n
Payment Reg. Template Name (Payment Reg. Template Name) Gen. Journal Template Name (Name) 1..n
Posted Sales Inv. No. Series (Posted Sales Inv. No. Series) No. Series Code (Code) 1..n
Default Payment Method Code (Default Payment Method Code) Payment Method Code (Code) 1..n
Default Payment Terms Code (Default Payment Terms Code) Payment Terms Code (Code) 1..n

Table Relations From Other Tables

From Table From Field