Report Selections

Diagrams

Table

Report Selections

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

Fields

#	Name	Type
1	Usage (Usage)	Option	[S.Quote,S.Order,S.Invoice,S.Cr.Memo,S.Test,P.Quote,P.Order,P.Invoice,P.Cr.Memo,P.Receipt,P.Ret.Shpt.,P.Test,B.Stmt,B.Recon.Test,B.Check,Reminder,Fin.Charge,Rem.Test,F.C.Test,Prod. Order,S.Blanket,P.Blanket,M1,M2,M3,M4,Inv1,Inv2,Inv3,SM.Quote,SM.Order,SM.Invoice,SM.Credit Memo,SM.Contract Quote,SM.Contract,SM.Test,S.Return,P.Return,S.Shipment,S.Ret.Rcpt.,S.Work Order,Invt. Period Test,SM.Shipment,S.Test Prepmt.,P.Test Prepmt.,S.Arch. Quote,S.Arch. Order,P.Arch. Quote,P.Arch. Order,S. Arch. Return Order,P. Arch. Return Order,Asm. Order,P.Assembly Order,S.Order Pick Instruction,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,C.Statement,V.Remittance,JQ,S.Invoice Draft,Pro Forma S. Invoice]
2	Sequence (Sequence)	Code10 [Numeric:Yes]
3	Report ID (Report ID)	Integer	TableRelation: AllObjWithCaption."Object ID" WHERE (Object Type=CONST(Report))
4	Report Caption (Report Caption)	Text250	CalcFormula: Lookup(AllObjWithCaption."Object Caption" WHERE (Object Type=CONST(Report), Object ID=FIELD(Report ID)));	Editable: No FlowField
7	Custom Report Layout Code (Custom Report Layout Code)	Code20	TableRelation: "Custom Report Layout".Code WHERE (Code=FIELD(Custom Report Layout Code))	Editable: No
19	Use for Email Attachment (Use for Email Attachment)	Boolean	InitValue: Yes
20	Use for Email Body (Use for Email Body)	Boolean
21	Email Body Layout Code (Email Body Layout Code)	Code20	TableRelation: IF (Email Body Layout Type=CONST(Custom Report Layout)) "Custom Report Layout".Code WHERE (Code=FIELD(Email Body Layout Code), Report ID=FIELD(Report ID)) ELSE IF (Email Body Layout Type=CONST(HTML Layout)) "O365 HTML Template".Code;
22	Email Body Layout Description (Email Body Layout Description)	Text250	CalcFormula: Lookup("Custom Report Layout".Description WHERE (Code=FIELD(Email Body Layout Code)))	Editable: No FlowField
25	Email Body Layout Type (Email Body Layout Type)	Option	[Custom Report Layout,HTML Layout]

Keys

#	Fields
0	Usage,Sequence (Usage,Sequence)		Clustered: Yes

Table Relations To Other Tables

Field	Related Table	Related Field
Report ID (Report ID)	AllObjWithCaption	Object ID (Object ID)	TableRelation: AllObjWithCaption."Object ID" WHERE (Object Type=CONST(Report))	1..n
Email Body Layout Code (Email Body Layout Code)	Custom Report Layout	Code (Code)	TableRelation: IF (Email Body Layout Type=CONST(Custom Report Layout)) "Custom Report Layout".Code WHERE (Code=FIELD(Email Body Layout Code), Report ID=FIELD(Report ID)) ELSE IF (Email Body Layout Type=CONST(HTML Layout)) "O365 HTML Template".Code;	1..n
Email Body Layout Code (Email Body Layout Code)	O365 HTML Template	Code (Code)	TableRelation: IF (Email Body Layout Type=CONST(Custom Report Layout)) "Custom Report Layout".Code WHERE (Code=FIELD(Email Body Layout Code), Report ID=FIELD(Report ID)) ELSE IF (Email Body Layout Type=CONST(HTML Layout)) "O365 HTML Template".Code;	1..n

Table Relations From Other Tables

From Table	From Field