Diagrams


Table

Custom Report Selection

DynamicsDocs.comCustom Report Selection«Table 9657»Custom Report SelectionSource Type [PK]Source No. [PK]Usage; [S.Quote,S.Order,S.Invoice,S.Cr...Sequence [PK]Report IDReport CaptionCustom Report Layout CodeCustom Report DescriptionSend To EmailUse for Email AttachmentUse for Email BodyEmail Body Layout CodeEmail Body Layout Description«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 23»VendorNo. [PK]NameSearch NameName 2AddressAddress 2CityContactPhone No.Telex No.Our Account No.Territory CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeBudgeted AmountVendor Posting GroupCurrency CodeLanguage CodeStatistics GroupPayment Terms CodeFin. Charge Terms CodePurchaser CodeShipment Method CodeShipping Agent CodeInvoice Disc. CodeCountry/Region CodeCommentBlocked; [,Payment,All]Pay-to Vendor No.PriorityPayment Method Code...«Table 9650»Custom Report LayoutCode [PK]Report IDReport NameCompany NameType; [RDLC,Word]LayoutLast ModifiedLast Modified by UserFile ExtensionDescriptionCustom XML PartApp IDBuilt-In<Source No.><Source No.><Custom Report Layout Code><Email Body Layout Code><Bill-to Customer No.><Pay-to Vendor No.>

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

Fields

# Name Type
1 Source Type Integer
2 Source No. Code20
3 Usage Option
4 Sequence Integer AutoIncrement: Yes
5 Report ID Integer
6 Report Caption Text250 Editable: No
FlowField
7 Custom Report Layout Code Code20
8 Custom Report Description Text250 Editable: No
FlowField
9 Send To Email Text200
19 Use for Email Attachment Boolean
20 Use for Email Body Boolean
21 Email Body Layout Code Code20
22 Email Body Layout Description Text250 Editable: No
FlowField

Keys

# Fields
0 Source Type,Source No.,Usage,Sequence Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Report ID AllObjWithCaption Object ID 1..n
Email Body Layout Code Custom Report Layout Code 1..n
Source No. Customer No. 1..n
Source No. Vendor No. 1..n

Table Relations From Other Tables

From Table From Field