Excel Reports (ERB10000)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/ERB10000

Product: SmartList Builder (3830)
Series: System

Display Name: Excel Reports
Physical Name: ERB10000
Technical Name: ERB_Excel_Reports

Group Display Name: Excel Report Setup Tables
Group Technical Name: Excel Report Setup

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1Excel_Report_ID SearchExcel Report IDSTR15_LBAUString1615
2Excel_Report_Name SearchExcel Report NameSTR64String6664
3View_Name SearchView NameSTR64String6664
4Create_Summary_Page SearchCreate Summary PageCreate Summary PageBoolean20
5Consolidate_Report SearchConsolidate ReportConsolidate reportBoolean20
6PRODID SearchProduct IDINT4Integer24
7Series_Number SearchSeries NumberINT5Integer24
8Publish_Option SearchPublish OptionINT5Integer24
9Target_URL SearchTarget URLSTR255String256255
10Data_Connection_Filename SearchData Connection FilenameSTR64String6664
11Data_Connection_Location SearchData Connection LocationSTR255String256255
12Excel_Report_Filename SearchExcel Report FilenameSTR64String6664
13Excel_Report_Location SearchExcel Report LocationSTR255String256255
14NOTEINDX SearchNote IndexDLR14Currency1014
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['Excel Reports'].NOTEINDX AS 'Excel Reports-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       ERB10000 AS ['Excel Reports']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['Excel Reports'].NOTEINDX = ['Record Notes Master'].NOTEINDX
15CREATDDT SearchCreated DateDTDate48
16CRUSRID SearchCreated User IDSTR15_User_IDString1615
17MODIFDT SearchModified DateDTDate48
18MDFUSRID SearchModified User IDSTR15String1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['Excel Reports'].MDFUSRID AS 'Excel Reports-Modified User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       ERB10000 AS ['Excel Reports']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['Excel Reports'].MDFUSRID = ['Users Master'].USERID
19Consolidate_Worksheet SearchConsolidate WorksheetConsolidate WorksheetBoolean20
20Display_Total_Line SearchDisplay Total LineDisplay totalsBoolean20
21Pivot_Table_Column_Total SearchPivot Table Column TotalsPivot Table Column TotalsBoolean20
22Pivot_Table_Row_Totals SearchPivot Table Row TotalsPivot Table Row TotalsBoolean20
23Pivot_Table_Expansion SearchPivot Table Show ExpansionPivot Table Show ExpansionBoolean20
24Excel_Report_Type SearchExcel Report TypeExcel Report TypeInteger20
25ASI_Search_Type SearchASI_Search_TypeASI_Search_TypeInteger20

Leave a Reply

Your email address will not be published. Required fields are marked *