Service Report Options (SVC70500)

azurecurveProductsFieldService (949)ProjectService Report Options (SVC70500)

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

Product: FieldService (949)
Series: Project

Display Name: Service Report Options
Physical Name: SVC70500
Technical Name: SVC_Options_ROPT

Group Display Name: Service Table Group
Group Technical Name: Service

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1PRTBYSIT SearchPrint by SiteGBInteger20
2PRNTOPTN SearchPrint OptionGBInteger20
3STTGNDSC SearchStart Generic DescriptionSTR10String1210
4ENGENDSC SearchEnd Generic DescriptionSTR10String1210
5ENUSRCAT SearchEnd User CategorySTR10String1210
6ENUSRCAT_1 SearchEnd User Category[1]STR10String1210
7ENUSRCAT_2 SearchEnd User Category[2]STR10String1210
8ENUSRCAT_3 SearchEnd User Category[3]STR10String1210
9ENUSRCAT_4 SearchEnd User Category[4]STR10String1210
10ENUSRCAT_5 SearchEnd User Category[5]STR10String1210
11ENUSRCAT_6 SearchEnd User Category[6]STR10String1210
12STRTUCAT SearchStart User CategorySTR10String1210
13STRTUCAT_1 SearchStart User Category[1]STR10String1210
14STRTUCAT_2 SearchStart User Category[2]STR10String1210
15STRTUCAT_3 SearchStart User Category[3]STR10String1210
16STRTUCAT_4 SearchStart User Category[4]STR10String1210
17STRTUCAT_5 SearchStart User Category[5]STR10String1210
18STRTUCAT_6 SearchStart User Category[6]STR10String1210
19CALLNBST SearchStart Service Call NumberSTR10String1210
20CALLNMEN SearchEnd Service Call NumberSTR10String1210
21CONTNBRS SearchStart Contract NumberSTR10String1210
22CONTNBRE SearchEnd Contract NumberSTR10String1210
23SRLNBRST SearchStart Serial NumberSTR20_LBAUString2220
24SRLNBREN SearchEnd Serial NumberSTR20_LBAUString2220
25PMDTLIDS SearchStart PM_DTL_IDSTR8_LBUString108
26PMDTLIDE SearchEnd PM_DTL_IDSTR8_LBUString108
27STCUSTID SearchStart Customer IDSTR15_RM_Customer_NumberString1615
28ENCUSTID SearchEnd Customer IDSTR15_RM_Customer_NumberString1615
29STTECHID SearchStart Tech IDSTR10String1210
30ENTECHID SearchEnd Tech IDSTR10String1210
31STOFFID SearchStart Office IDSTR10String1210
32ENOFFID SearchEnd Office IDSTR10String1210
33SVCOPT1 SearchStart SVC Option1STR15String1615
34ENDSVCO1 SearchEnd SVC Option1STR15String1615
35STSVCOP1 SearchStart SVC Option2STR20String2220
36ENSVCOP2 SearchEnd SVC Option2STR20String2220
37STSVCOPT3 SearchStart SVC Option3STR20String2220
38ENSVCOP3 SearchEnd SVC Option3STR20String2220
39STSVCOP4 SearchStart SVC Option4STR30String3230
40ENSVCOP4 SearchEnd SVC Option4STR30String3230
41STSVCOP5 SearchStart SVC Option5CBBoolean20
42ENSVCOP5 SearchEnd SVC Option5CBBoolean20
43STSVCOP6 SearchStart SVC Option6STR10String1210
44ENSVCOP6 SearchEnd SVC Option6STR10String1210
45STSVCOP7 SearchStart SVC Option7STR10String1210
46ENSVCOP7 SearchEnd SVC Option7STR10String1210
47STSVCOP8 SearchStart SVC Option8STR20String2220
48ENSVCOP8 SearchEnd SVC Option8STR20String2220
49STSVCOP9 SearchStart SVC Option9INTInteger20
50ENSVCOP9 SearchEnd SVC Option9INTInteger20
51STSVCO10 SearchStart SVC Option10INTInteger20
52ENSVCO10 SearchEnd SVC Option10INTInteger20
53STTITNUM SearchStart Item NumberSTR30_Item_NumberString3230
54ENITMNBR SearchEnd Item NumberSTR30_Item_NumberString3230
55SRVRECTYPE SearchService Record TypeDDL_Service_Record_TypeInteger20
56CONSTS SearchContract Record TypeDDL_Contract_StatusInteger20
57PRVDRINF SearchPrint Vendor InformationGBInteger20
58PRTDSCNT SearchPrint DiscontinuedCB_DiscontinuedBoolean20
59PRTSVCHS SearchPrint SVC HistoryCB_HistoryBoolean20
60SVCRPTNM SearchSVC Report NameSTR30String3230
61PRNTNOTS SearchPrint NotesCB_Print_NotesBoolean20
62PRNTTYPE SearchPrint TypeGBInteger20
63ASKECHTM SearchAsk Each TimeCB_Ask_Each_TimeBoolean20
64INCLGNDS SearchInclude LegendsCB_Include_LegendsBoolean20
65PRNTOFIL SearchPrint to FileCB_Print_to_FileBoolean20
66PRTOPRTR SearchPrint to PrinterCB_Print_to_PrinterBoolean20
67PRTOSCRN SearchPrint to ScreenCB_Print_to_ScreenBoolean20
68IFFILXST SearchIf File ExistingGBInteger20
69FILEXPNM SearchFile Export NameSTR255String256255
70EXPTTYPE SearchExport TypeINTInteger20
71RPTGRIND SearchReport Group IndexINTInteger20
72STTCLASS SearchStart ClassSTR10_Item_Class_CodeString1210
73ENDCLASS SearchEnd ClassSTR10_Item_Class_CodeString1210
74STRTDSCR SearchStart DescriptionSTR50String5250
75ENDDESCR SearchEnd DescriptionSTR50String5250
76STTSCHED SearchStart ScheduleSTR10_ScheduleString1210
77ENSCHDUL SearchEnd ScheduleSTR10_ScheduleString1210
78STTLOCCD SearchStart Location CodeSTR10_Location_CodeString1210
79ENLOCNCD SearchEnd Location CodeSTR10_Location_CodeString1210
80STTLOTTY SearchStart Lot TypeSTR10_Lot_TypeString1210
81ENLOTTYP SearchEnd Lot TypeSTR10_Lot_TypeString1210
82STRTNGDT SearchStarting DateDTDate48
83ENDINGDT SearchEnding DateDTDate48
84ENDTKNDT SearchEnd Token DateDDL_End_DatesInteger20
85STTOKNDT SearchStart Token DateDDL_Start_DatesInteger20
86STRCTNUM SearchStart Receipt NumberSTR20_Document_NumberString2220
87ENRCTNBR SearchEnd Receipt NumberSTR20_Document_NumberString2220
88RTPACHIN SearchReport Palette Choice IndexINTInteger20
89RTGRSBIN SearchReport Group Sub IndexDLR14Currency1014
90SORTBY SearchSort ByDDL_Sort_ByInteger20
91PRTSRLOT SearchPrint Serial LotCB_Print_Serial_LotBoolean20
92INZROQTY SearchInclude Zero QTYCB_Include_Zero_QTYBoolean20
93PRTITQTY SearchPrint Item QuantitiesCB_Print_Item_QTYSBoolean20
94STTBINUM SearchStart Bin NumberSTR20String2220
95ENBINNBR SearchEnd Bin NumberSTR20String2220
96STDOCNUM SearchStart Document NumberSTR20String2220
97ENDOCNUM SearchEnd Document NumberSTR20String2220
98STDOCTYP SearchStart Document TypeINT1Integer21
99ENDOCTYP SearchEnd Document TypeINT1Integer21
100STTMODUL SearchStart ModuleSTR3String43
101ENDMODUL SearchEnd ModuleSTR3String43
102STRXSRC SearchStart TRX SourceSTR13String1413
103ENTRXSRC SearchEnd TRX SourceSTR13String1413
104STBCHSRC SearchStart Batch SourceSTR15String1615
105ENBCHSRC SearchEnd Batch SourceSTR15String1615
106STBCHNUM SearchStart Batch NumberSTR15_LBAUString1615
107ENDBNMBR SearchEnd Batch NumberSTR15_LBAUString1615
108STVNDRID SearchStart Vendor IDSTR15_LBUString1615
109ENDVNDID SearchEnd Vendor IDSTR15_LBUString1615
110INQTYREQ SearchInclude QTY RequisitionedCB_QTY_RequisitionedBoolean20
111INZRORLV SearchInclude Zero Reorder LevelCB_Zero_ReorderBoolean20
112CALSGQTY SearchCalc Suggested QTYSGBInteger20
113RCPTOPTS SearchReceipt OptionsDDL_Print_OptionInteger20
114VENDROPT SearchVendor OptionsDDL_Vendor_OptionInteger20
115SEGSRTBY SearchSegment Sort ByINT1Integer21
116SEGMNTRG SearchUsing Segment RangeINTInteger20
117Start_PriceLevel SearchStart PriceLevelSTR10_PriceLevelString1210
118End_PriceLevel SearchEnd PriceLevelSTR10_PriceLevelString1210
119Start_RMA_Number SearchStart RMA NumberSTR15_LBAUString1615
120End_RMA_Number SearchEnd RMA NumberSTR15_LBAUString1615
121Start_Required_Date SearchStart Required DateDTDate48
122End_Required_Date SearchEnd Required DateDTDate48
123SVC_Print_Open SearchSVC Print OpenCBBoolean20
124INCMCINF SearchInclude Multicurrency InfoCB_Include_Multicurrency_InfoBoolean20
125PRTCURIN SearchPrint Currency InGBInteger20
126DEX_ROW_ID Searchintint1010

DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information.

Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.

azurecurveProductsFieldService (949)ProjectService Report Options (SVC70500)

Leave a Reply

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