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 TypeLength
1PRTBYSIT SearchPrint by SiteGBInteger0
2PRNTOPTN SearchPrint OptionGBInteger0
3STTGNDSC SearchStart Generic DescriptionSTR10String10
4ENGENDSC SearchEnd Generic DescriptionSTR10String10
5ENUSRCAT SearchEnd User CategorySTR10String10
6ENUSRCAT_1 SearchEnd User Category[1]STR10String10
7ENUSRCAT_2 SearchEnd User Category[2]STR10String10
8ENUSRCAT_3 SearchEnd User Category[3]STR10String10
9ENUSRCAT_4 SearchEnd User Category[4]STR10String10
10ENUSRCAT_5 SearchEnd User Category[5]STR10String10
11ENUSRCAT_6 SearchEnd User Category[6]STR10String10
12STRTUCAT SearchStart User CategorySTR10String10
13STRTUCAT_1 SearchStart User Category[1]STR10String10
14STRTUCAT_2 SearchStart User Category[2]STR10String10
15STRTUCAT_3 SearchStart User Category[3]STR10String10
16STRTUCAT_4 SearchStart User Category[4]STR10String10
17STRTUCAT_5 SearchStart User Category[5]STR10String10
18STRTUCAT_6 SearchStart User Category[6]STR10String10
19CALLNBST SearchStart Service Call NumberSTR10String10
20CALLNMEN SearchEnd Service Call NumberSTR10String10
21CONTNBRS SearchStart Contract NumberSTR10String10
22CONTNBRE SearchEnd Contract NumberSTR10String10
23SRLNBRST SearchStart Serial NumberSTR20_LBAUString20
24SRLNBREN SearchEnd Serial NumberSTR20_LBAUString20
25PMDTLIDS SearchStart PM_DTL_IDSTR8_LBUString8
26PMDTLIDE SearchEnd PM_DTL_IDSTR8_LBUString8
27STCUSTID SearchStart Customer IDSTR15_RM_Customer_NumberString15
28ENCUSTID SearchEnd Customer IDSTR15_RM_Customer_NumberString15
29STTECHID SearchStart Tech IDSTR10String10
30ENTECHID SearchEnd Tech IDSTR10String10
31STOFFID SearchStart Office IDSTR10String10
32ENOFFID SearchEnd Office IDSTR10String10
33SVCOPT1 SearchStart SVC Option1STR15String15
34ENDSVCO1 SearchEnd SVC Option1STR15String15
35STSVCOP1 SearchStart SVC Option2STR20String20
36ENSVCOP2 SearchEnd SVC Option2STR20String20
37STSVCOPT3 SearchStart SVC Option3STR20String20
38ENSVCOP3 SearchEnd SVC Option3STR20String20
39STSVCOP4 SearchStart SVC Option4STR30String30
40ENSVCOP4 SearchEnd SVC Option4STR30String30
41STSVCOP5 SearchStart SVC Option5CBBoolean0
42ENSVCOP5 SearchEnd SVC Option5CBBoolean0
43STSVCOP6 SearchStart SVC Option6STR10String10
44ENSVCOP6 SearchEnd SVC Option6STR10String10
45STSVCOP7 SearchStart SVC Option7STR10String10
46ENSVCOP7 SearchEnd SVC Option7STR10String10
47STSVCOP8 SearchStart SVC Option8STR20String20
48ENSVCOP8 SearchEnd SVC Option8STR20String20
49STSVCOP9 SearchStart SVC Option9INTInteger0
50ENSVCOP9 SearchEnd SVC Option9INTInteger0
51STSVCO10 SearchStart SVC Option10INTInteger0
52ENSVCO10 SearchEnd SVC Option10INTInteger0
53STTITNUM SearchStart Item NumberSTR30_Item_NumberString30
54ENITMNBR SearchEnd Item NumberSTR30_Item_NumberString30
55SRVRECTYPE SearchService Record TypeDDL_Service_Record_TypeInteger0
56CONSTS SearchContract Record TypeDDL_Contract_StatusInteger0
57PRVDRINF SearchPrint Vendor InformationGBInteger0
58PRTDSCNT SearchPrint DiscontinuedCB_DiscontinuedBoolean0
59PRTSVCHS SearchPrint SVC HistoryCB_HistoryBoolean0
60SVCRPTNM SearchSVC Report NameSTR30String30
61PRNTNOTS SearchPrint NotesCB_Print_NotesBoolean0
62PRNTTYPE SearchPrint TypeGBInteger0
63ASKECHTM SearchAsk Each TimeCB_Ask_Each_TimeBoolean0
64INCLGNDS SearchInclude LegendsCB_Include_LegendsBoolean0
65PRNTOFIL SearchPrint to FileCB_Print_to_FileBoolean0
66PRTOPRTR SearchPrint to PrinterCB_Print_to_PrinterBoolean0
67PRTOSCRN SearchPrint to ScreenCB_Print_to_ScreenBoolean0
68IFFILXST SearchIf File ExistingGBInteger0
69FILEXPNM SearchFile Export NameSTR255String255
70EXPTTYPE SearchExport TypeINTInteger0
71RPTGRIND SearchReport Group IndexINTInteger0
72STTCLASS SearchStart ClassSTR10_Item_Class_CodeString10
73ENDCLASS SearchEnd ClassSTR10_Item_Class_CodeString10
74STRTDSCR SearchStart DescriptionSTR50String50
75ENDDESCR SearchEnd DescriptionSTR50String50
76STTSCHED SearchStart ScheduleSTR10_ScheduleString10
77ENSCHDUL SearchEnd ScheduleSTR10_ScheduleString10
78STTLOCCD SearchStart Location CodeSTR10_Location_CodeString10
79ENLOCNCD SearchEnd Location CodeSTR10_Location_CodeString10
80STTLOTTY SearchStart Lot TypeSTR10_Lot_TypeString10
81ENLOTTYP SearchEnd Lot TypeSTR10_Lot_TypeString10
82STRTNGDT SearchStarting DateDTDate8
83ENDINGDT SearchEnding DateDTDate8
84ENDTKNDT SearchEnd Token DateDDL_End_DatesInteger0
85STTOKNDT SearchStart Token DateDDL_Start_DatesInteger0
86STRCTNUM SearchStart Receipt NumberSTR20_Document_NumberString20
87ENRCTNBR SearchEnd Receipt NumberSTR20_Document_NumberString20
88RTPACHIN SearchReport Palette Choice IndexINTInteger0
89RTGRSBIN SearchReport Group Sub IndexDLR14Currency14
90SORTBY SearchSort ByDDL_Sort_ByInteger0
91PRTSRLOT SearchPrint Serial LotCB_Print_Serial_LotBoolean0
92INZROQTY SearchInclude Zero QTYCB_Include_Zero_QTYBoolean0
93PRTITQTY SearchPrint Item QuantitiesCB_Print_Item_QTYSBoolean0
94STTBINUM SearchStart Bin NumberSTR20String20
95ENBINNBR SearchEnd Bin NumberSTR20String20
96STDOCNUM SearchStart Document NumberSTR20String20
97ENDOCNUM SearchEnd Document NumberSTR20String20
98STDOCTYP SearchStart Document TypeINT1Integer1
99ENDOCTYP SearchEnd Document TypeINT1Integer1
100STTMODUL SearchStart ModuleSTR3String3
101ENDMODUL SearchEnd ModuleSTR3String3
102STRXSRC SearchStart TRX SourceSTR13String13
103ENTRXSRC SearchEnd TRX SourceSTR13String13
104STBCHSRC SearchStart Batch SourceSTR15String15
105ENBCHSRC SearchEnd Batch SourceSTR15String15
106STBCHNUM SearchStart Batch NumberSTR15_LBAUString15
107ENDBNMBR SearchEnd Batch NumberSTR15_LBAUString15
108STVNDRID SearchStart Vendor IDSTR15_LBUString15
109ENDVNDID SearchEnd Vendor IDSTR15_LBUString15
110INQTYREQ SearchInclude QTY RequisitionedCB_QTY_RequisitionedBoolean0
111INZRORLV SearchInclude Zero Reorder LevelCB_Zero_ReorderBoolean0
112CALSGQTY SearchCalc Suggested QTYSGBInteger0
113RCPTOPTS SearchReceipt OptionsDDL_Print_OptionInteger0
114VENDROPT SearchVendor OptionsDDL_Vendor_OptionInteger0
115SEGSRTBY SearchSegment Sort ByINT1Integer1
116SEGMNTRG SearchUsing Segment RangeINTInteger0
117Start_PriceLevel SearchStart PriceLevelSTR10_PriceLevelString10
118End_PriceLevel SearchEnd PriceLevelSTR10_PriceLevelString10
119Start_RMA_Number SearchStart RMA NumberSTR15_LBAUString15
120End_RMA_Number SearchEnd RMA NumberSTR15_LBAUString15
121Start_Required_Date SearchStart Required DateDTDate8
122End_Required_Date SearchEnd Required DateDTDate8
123SVC_Print_Open SearchSVC Print OpenCBBoolean0
124INCMCINF SearchInclude Multicurrency InfoCB_Include_Multicurrency_InfoBoolean0
125PRTCURIN SearchPrint Currency InGBInteger0
126DEX_ROW_ID Searchintint10

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 *