Master Defaults (SVC00998)

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

Product: FieldService (949)
Series: Project

Display Name: Master Defaults
Physical Name: SVC00998
Technical Name: SVC_Master_Defaults

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

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1SEQUENCE1 SearchSequenceDLR19_$S2Currency1019
2SRVRECTYPE SearchService Record TypeDDL_Service_Record_TypeInteger20
3MULEQUIP SearchMultiple EquipmentCB_Multiple_EquipmentBoolean20
4MULCODES SearchMultiple CodesCB_Multiple_CodesBoolean20
5MULTECH SearchMultiple TechniciansCB_Multiple_TechniciansBoolean20
6TIMEZONE SearchTimeZoneSTR3_LBUString43
7SRVTYPE SearchService TypeSTR10_LBAUString1210
8OFFID SearchOffice IDSTR10_LBAUString1210
9LOCNCODE SearchLocation CodeSTR10_Location_CodeString1210
Key to the Site Setup (IV40700).

Click to show/hide

SELECT
       ['Master Defaults'].LOCNCODE AS 'Master Defaults-Location Code'
       ,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
       SVC00998 AS ['Master Defaults']
INNER JOIN
       IV40700 AS ['Site Setup']
              ON
                     ['Master Defaults'].LOCNCODE = ['Site Setup'].LOCNCODE
10SRVSTAT SearchService Call StatusSTR3_LBUString43
11Backorder_Status SearchBackorder StatusSTR3_LBUString43
12Intransit_Status SearchIntransit StatusSTR3_LBUString43
13Dispatch_Status SearchDispatch StatusSTR3_LBUString43
14Arrival_Status SearchArrival StatusSTR3_LBUString43
15Complete_Status SearchComplete StatusSTR3_LBUString43
16POSTAT SearchPurchase Order StatusSTR3_LBUString43
17Single_PO SearchSingle PObooleanBoolean20
18SRLSTAT SearchEquipment StatusSTR10_LBAUString1210
19RETSTATUS SearchReturn Serial StatusSTR10_LBAUString1210
20CKSVCAREA SearchCheck Service AreaCB_Auto_Check_Service_AreaBoolean20
21CKSKILL SearchCheck SkillsCB_Auto_Check_SkillsBoolean20
22CONSTS SearchContract Record TypeDDL_Contract_StatusInteger20
23PRICSHED SearchPrice ScheduleSTR10_ScheduleString1210
24CNTTYPE SearchContract TypeSTR10_LBAUString1210
25MAPPRLOC SearchMap Program LocationSTR60String6260
26USRDFPR1 SearchUser Defined Prompt 1STR15String1615
27USRDRPR2 SearchUser Defined Prompt 2STR15String1615
28USRDRPR3 SearchUser Defined Prompt 3STR15String1615
29USRDRPR4 SearchUser Defined Prompt 4STR15String1615
30USRDRPR5 SearchUser Defined Prompt 5STR15String1615
31NUMDAYSOD SearchNumber Of Days OverdueINT3_U0Integer23
32NUMDAYSPM SearchNumber Of Days PMINT3_U0Integer23
33NUMDAYSCB SearchNumber Of Days CallbackINT3_U0Integer23
34CHGHIST SearchChange HistoryCBBoolean20
35AUTOCUST SearchAuto Customer NumberCBBoolean20
36CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString1615
Key to the RM Customer MSTR (RM00101).

Click to show/hide

SELECT
       ['Master Defaults'].CUSTNMBR AS 'Master Defaults-Customer Number'
       ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
       SVC00998 AS ['Master Defaults']
INNER JOIN
       RM00101 AS ['RM Customer MSTR']
              ON
                     ['Master Defaults'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
37RETCSTNR SearchReturn Customer NumberSTR15_RM_Customer_NumberString1615
38PAGEON SearchPaging OnCBBoolean20
39PAGEPROFILE SearchPaging ProfileSTR20String2220
40PRCLEVEL SearchPriceLevelSTR10_LBAUString1210
41Use_SOP SearchUse SOPCBBoolean20
42Password_Array SearchPassword ArraySTR15_LBAString1615
43Password_Array_1 SearchPassword Array[1]STR15_LBAString1615
44Password_Array_2 SearchPassword Array[2]STR15_LBAString1615
45Password_Array_3 SearchPassword Array[3]STR15_LBAString1615
46Password_Array_4 SearchPassword Array[4]STR15_LBAString1615
47Password_Array_5 SearchPassword Array[5]STR15_LBAString1615
48Password_Array_6 SearchPassword Array[6]STR15_LBAString1615
49Password_Array_7 SearchPassword Array[7]STR15_LBAString1615
50Check_Customer SearchCheck CustomerCBBoolean20
51Check_Customer_Address SearchCheck Customer AddressCBBoolean20
52Check_Serial SearchCheck SerialCBBoolean20
53EMail_Tech SearchE-Mail TechCBBoolean20
54Use_POP SearchUse POPSVC_DDL_Use_POPInteger20
55Print_to_Web SearchPrint to WebCBBoolean20
56Check_Call_Back SearchCheck Call BackCBBoolean20
57Retainage_Percent SearchRetainage PercentINT3_U0Integer23
58RETTYPE SearchSVC Return TypeSTR10_LBAUString1210
59RTV_Type SearchRTV TypeSTR10_LBAUString1210
60SVC_PO_Validation SearchSVC_PO_ValidationSVC_PO_Link_ValidationInteger20
61Location_Code_Vendor SearchLocation Code VendorSTR10_Location_CodeString1210
62WORECTYPE SearchWork Order Record TypeDDL_Work_Order_Record_TypeInteger20
63WO_Office_ID SearchWO Office IDSTR10_LBAUString1210
64WO_TimeZone SearchWO TimeZoneSTR3_LBUString43
65WOENTSTA SearchWO Entered StatusSTR3_LBUString43
66WOBOSTAT SearchWO Backordered StatusSTR3_LBUString43
67WOCOMPSTAT SearchWO Completed StatusSTR3_LBUString43
68WOWIPSTAT SearchWO WIP StatusSTR3_LBUString43
69WOTYPE SearchWork Order TypeSTR10_LBAUString1210
70WOLOCAT SearchWO LocationSTR10_Location_CodeString1210
71Parts_Available_Status SearchParts Available StatusSTR3_LBUString43
72SVC_Address_Option SearchSVC_Address_OptionDDL_Address_OptionInteger20
73SVC_Disable_XFR_Grouping SearchSVC_Disable_XFR_GroupingCBBoolean20
74Ready_To_Invoice_Status SearchReady To Invoice StatusSTR3_LBUString43
75Invoiced_Status SearchInvoiced StatusSTR3_LBUString43
76SVC_Auto_Create_Labor SearchSVC Auto Create LaborDDL_Create_LaborInteger20
77USRDRPR6 SearchUser Defined Prompt 6STR15String1615
78USRDRPR7 SearchUser Defined Prompt 7STR15String1615
79USRDRPR8 SearchUser Defined Prompt 8STR15String1615
80USRDRPR9 SearchUser Defined Prompt 9STR15String1615
81USRDRP10 SearchUser Defined Prompt 10STR15String1615
82SVC_User_Define_Prompt1 SearchSVC User Define Prompt1STR15String1615
83SVC_User_Define_Prompt2 SearchSVC User Define Prompt2STR15String1615
84SVC_User_Define_Prompt3 SearchSVC User Define Prompt3STR15String1615
85SVC_User_Define_Prompt4 SearchSVC User Define Prompt4STR15String1615
86SVC_User_Define_Prompt5 SearchSVC User Define Prompt5STR15String1615
87SVC_User_Define_Prompt6 SearchSVC User Define Prompt6STR15String1615
88SVC_User_Define_Prompt7 SearchSVC User Define Prompt7STR15String1615
89SVC_User_Define_Prompt8 SearchSVC User Define Prompt8STR15String1615
90SVC_User_Define_Prompt9 SearchSVC User Define Prompt9STR15String1615
91SVC_User_Define_Prompt10 SearchSVC User Define Prompt10STR15String1615
92SVC_User_Define_Prompt11 SearchSVC User Define Prompt11STR15String1615
93SVC_User_Define_Prompt12 SearchSVC User Define Prompt12STR15String1615
94SVC_User_Define_Prompt13 SearchSVC User Define Prompt13STR15String1615
95SVC_User_Define_Prompt14 SearchSVC User Define Prompt14STR15String1615
96SVC_User_Define_Prompt15 SearchSVC User Define Prompt15STR15String1615
97SVC_Check_SC_Labor SearchSVC_Check_SC_LaborSVC_Stop_HardnessInteger20
98SVC_Check_WO_Labor SearchSVC_Check_WO_LaborSVC_Stop_HardnessInteger20
99SVC_Check_Call_Back SearchSVC Check Call BackCB_Call_BackBoolean20
100SVC_Service_Type SearchSVC Service TypeSTR10_LBAUString1210
101SVC_Directory SearchSVC DirectorySTR98String10098
102SVC_Return_Price_Level SearchSVC Return Price LevelSTR10_LBAUString1210
103SVC_Transfer_Option SearchSVC Transfer OptionDDL_Transfer_OptionInteger20
104SVC_Service_Batch_ID SearchSVC Service Batch IDSTR15_LBAUString1615
105SVC_Service_Document_ID SearchSVC Service Document IDSTR15_LBAUString1615
106SVC_Contract_Batch_ID SearchSVC Contract Batch IDSTR15_LBAUString1615
107SVC_Contract_Document_ID SearchSVC Contract Document IDSTR15_LBAUString1615
108SVC_Use_Return SearchSVC Use ReturnCBBoolean20
109SVC_Dup_Serial SearchSVC_Dup_SerialSVC_DDL_PromptInteger20
110SVC_Auto_SOP_Contract SearchSVC Auto SOP ContractCBBoolean20
111SVC_Contract_Warranty SearchSVC Contract WarrantyCBBoolean20
112SVC_Create_Serial SearchSVC Create SerialCBBoolean20
113SVC_Vendor_Warranty_Flag SearchSVC Vendor Warranty FlagSVC_Warranty_FlagInteger20
114SVC_Seller_Warranty_Flag SearchSVC Seller Warranty FlagSVC_Seller_WarrantyInteger20
115SVC_Create_POP_Serial SearchSVC Create POP SerialCBBoolean20
116SVC_ItemDelta SearchSVC ItemDeltaCBBoolean20
117SVC_Allow_Contract_0_SOP SearchSVC Allow Contract 0 SOPCBBoolean20
118SVC_Allow_Service_0_SOP SearchSVC Allow Service 0 SOPCBBoolean20
119SVC_C_Credit_Batch_ID SearchSVC C Credit Batch IDSTR15_LBAUString1615
120SVC_C_Credit_Document_ID SearchSVC C Credit Document IDSTR15_LBAUString1615
121SVC_S_Credit_Batch_ID SearchSVC S Credit Batch IDSTR15_LBAUString1615
122SVC_S_Credit_Document_ID SearchSVC S Credit Document IDSTR15_LBAUString1615
123SVC_Zero_Batch_ID SearchSVC Zero Batch IDSTR15_LBAUString1615
124SVC_Zero_Document_ID SearchSVC Zero Document IDSTR15_LBAUString1615
125SVC_Auto_Credit_Receipt SearchSVC Auto Credit ReceiptCBBoolean20
126SVC_Auto_Replace_Receipt SearchSVC Auto Replace ReceiptCBBoolean20
127SVC_RMA_Invoice_Batch_ID SearchSVC RMA Invoice Batch IDSTR15_LBAUString1615
128SVC_RMA_Credit_Batch_ID SearchSVC RMA Credit Batch IDSTR15_LBAUString1615
129SVC_RMA_Order_Batch_ID SearchSVC RMA Order Batch IDSTR15_LBAUString1615
130Call_To SearchCall ToSTR3_LBUString43
131Call_From SearchCall FromSTR3_LBUString43
132priorityLevel SearchpriorityLevelINT4Integer24
133SVC_User_Define_Prompt16 SearchSVC User Define Prompt16STR15String1615
134SVC_User_Define_Prompt17 SearchSVC User Define Prompt17STR15String1615
135SVC_User_Define_Prompt18 SearchSVC User Define Prompt18STR15String1615
136SVC_User_Define_Prompt19 SearchSVC User Define Prompt19STR15String1615
137SVC_User_Define_Prompt20 SearchSVC User Define Prompt20STR15String1615
138SVC_Auto_XShip_Receipt SearchSVC Auto XShip ReceiptCBBoolean20
139SVC_Use_Payable SearchSVC Use PayableCBBoolean20
140SVC_PrePaid_Override SearchSVC PrePaid OverrideCBBoolean20
141SVC_DistHistory_Contract SearchSVC Dist History ContractCBBoolean20
142SVC_DistHistory_RMA SearchSVC Dist History RMACBBoolean20
143SVC_DistHistory_RTV SearchSVC Dist History RTVCBBoolean20
144SVC_DistHistory_Service SearchSVC Dist History ServiceCBBoolean20
145SVC_DistHistory_Transfer SearchSVC Dist History TransferCBBoolean20
146SVC_DistHistory_Work_Ord SearchSVC Dist History Work OrderCBBoolean20
147SVC_Use_Same_Number SearchSVC Use Same NumberCBBoolean20
148SVC_InStock_Customer SearchSVC InStock CustomerSTR15_RM_Customer_NumberString1615
149SVC_InStock_Status SearchSVC InStock StatusSTR10_LBAUString1210
150SVC_Create_Non_Serial_Eq SearchSVC Create Non Serial EquipCBBoolean20
151SVC_Allow_RMA_0_SOP SearchSVC Allow RMA 0 SOPCBBoolean20
152SVC_Use_Return_Price_Lev SearchSVC Use Return Price LevelCBBoolean20
153SVC_Supersession_Enabled SearchSVC Supersession EnabledCBBoolean20
154AUTOREN SearchAuto RenewingCBBoolean20
155SVC_Days_to_Renew SearchSVC Days to RenewINT4_U0Integer24
156MXINCPCT SearchMax Increase PercentatgeDLR5_%2Currency108
157PCTCRYFWD SearchPercentage Carried ForwardDLR5_%2Currency108
158SVC_Remove_Price_Overrid SearchSVC Remove Price OverrideCBBoolean20
159RENPRCSCHD SearchRenewing Price ScheduleSTR10_ScheduleString1210
160CNSOLDTD SearchConsolidatedCB_ConsolidatedBoolean20
161svcDonotCombinePM SearchsvcDonotCombinePMCBBoolean20
162svcContractPMOnly SearchsvcContractPMOnlyCBBoolean20
163svcAutoMoveHistory SearchsvcAutoMoveHistoryCBBoolean20
164svcAllowNonInventoried SearchsvcAllowNonInventoriedCBBoolean20
165svcUsePayRate SearchsvcUsePayRateCBBoolean20
166svcUsePayroll SearchsvcUsePayrollsvcUsePayrollDDLInteger20
167svcDefaultWorkType SearchsvcDefaultWorkTypeSTR10_LBAUString1210
168svcDefaultWorkType_1 SearchsvcDefaultWorkType[1]STR10_LBAUString1210
169svcDefaultWorkType_2 SearchsvcDefaultWorkType[2]STR10_LBAUString1210
170svcDefaultWorkType_3 SearchsvcDefaultWorkType[3]STR10_LBAUString1210
171svcDefaultWorkType_4 SearchsvcDefaultWorkType[4]STR10_LBAUString1210
172svcDefaultWorkType_5 SearchsvcDefaultWorkType[5]STR10_LBAUString1210
173svcBillingExchangeRate SearchsvcBillingExchangeRatesvcExchangeRateUseInteger20
174svcRevenueExchangeRate SearchsvcRevenueExchangeRatesvcExchangeRateUseInteger20
175svcConsolidateSOPOrder SearchsvcConsolidateSOPOrderCBBoolean20
176svcCreateMAEquipment SearchsvcCreateMAEquipmentCBBoolean20
177svcCreateMANonSerialEq SearchsvcCreateMANonSerialEqCBBoolean20
178DEX_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.

Leave a Reply

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