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 TypeLength
1SEQUENCE1 SearchSequenceDLR19_$S2Currency19
2SRVRECTYPE SearchService Record TypeDDL_Service_Record_TypeInteger0
3MULEQUIP SearchMultiple EquipmentCB_Multiple_EquipmentBoolean0
4MULCODES SearchMultiple CodesCB_Multiple_CodesBoolean0
5MULTECH SearchMultiple TechniciansCB_Multiple_TechniciansBoolean0
6TIMEZONE SearchTimeZoneSTR3_LBUString3
7SRVTYPE SearchService TypeSTR10_LBAUString10
8OFFID SearchOffice IDSTR10_LBAUString10
9LOCNCODE SearchLocation CodeSTR10_Location_CodeString10
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_LBUString3
11Backorder_Status SearchBackorder StatusSTR3_LBUString3
12Intransit_Status SearchIntransit StatusSTR3_LBUString3
13Dispatch_Status SearchDispatch StatusSTR3_LBUString3
14Arrival_Status SearchArrival StatusSTR3_LBUString3
15Complete_Status SearchComplete StatusSTR3_LBUString3
16POSTAT SearchPurchase Order StatusSTR3_LBUString3
17Single_PO SearchSingle PObooleanBoolean0
18SRLSTAT SearchEquipment StatusSTR10_LBAUString10
19RETSTATUS SearchReturn Serial StatusSTR10_LBAUString10
20CKSVCAREA SearchCheck Service AreaCB_Auto_Check_Service_AreaBoolean0
21CKSKILL SearchCheck SkillsCB_Auto_Check_SkillsBoolean0
22CONSTS SearchContract Record TypeDDL_Contract_StatusInteger0
23PRICSHED SearchPrice ScheduleSTR10_ScheduleString10
24CNTTYPE SearchContract TypeSTR10_LBAUString10
25MAPPRLOC SearchMap Program LocationSTR60String60
26USRDFPR1 SearchUser Defined Prompt 1STR15String15
27USRDRPR2 SearchUser Defined Prompt 2STR15String15
28USRDRPR3 SearchUser Defined Prompt 3STR15String15
29USRDRPR4 SearchUser Defined Prompt 4STR15String15
30USRDRPR5 SearchUser Defined Prompt 5STR15String15
31NUMDAYSOD SearchNumber Of Days OverdueINT3_U0Integer3
32NUMDAYSPM SearchNumber Of Days PMINT3_U0Integer3
33NUMDAYSCB SearchNumber Of Days CallbackINT3_U0Integer3
34CHGHIST SearchChange HistoryCBBoolean0
35AUTOCUST SearchAuto Customer NumberCBBoolean0
36CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString15
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_NumberString15
38PAGEON SearchPaging OnCBBoolean0
39PAGEPROFILE SearchPaging ProfileSTR20String20
40PRCLEVEL SearchPriceLevelSTR10_LBAUString10
41Use_SOP SearchUse SOPCBBoolean0
42Password_Array SearchPassword ArraySTR15_LBAString15
43Password_Array_1 SearchPassword Array[1]STR15_LBAString15
44Password_Array_2 SearchPassword Array[2]STR15_LBAString15
45Password_Array_3 SearchPassword Array[3]STR15_LBAString15
46Password_Array_4 SearchPassword Array[4]STR15_LBAString15
47Password_Array_5 SearchPassword Array[5]STR15_LBAString15
48Password_Array_6 SearchPassword Array[6]STR15_LBAString15
49Password_Array_7 SearchPassword Array[7]STR15_LBAString15
50Check_Customer SearchCheck CustomerCBBoolean0
51Check_Customer_Address SearchCheck Customer AddressCBBoolean0
52Check_Serial SearchCheck SerialCBBoolean0
53EMail_Tech SearchE-Mail TechCBBoolean0
54Use_POP SearchUse POPSVC_DDL_Use_POPInteger0
55Print_to_Web SearchPrint to WebCBBoolean0
56Check_Call_Back SearchCheck Call BackCBBoolean0
57Retainage_Percent SearchRetainage PercentINT3_U0Integer3
58RETTYPE SearchSVC Return TypeSTR10_LBAUString10
59RTV_Type SearchRTV TypeSTR10_LBAUString10
60SVC_PO_Validation SearchSVC_PO_ValidationSVC_PO_Link_ValidationInteger0
61Location_Code_Vendor SearchLocation Code VendorSTR10_Location_CodeString10
62WORECTYPE SearchWork Order Record TypeDDL_Work_Order_Record_TypeInteger0
63WO_Office_ID SearchWO Office IDSTR10_LBAUString10
64WO_TimeZone SearchWO TimeZoneSTR3_LBUString3
65WOENTSTA SearchWO Entered StatusSTR3_LBUString3
66WOBOSTAT SearchWO Backordered StatusSTR3_LBUString3
67WOCOMPSTAT SearchWO Completed StatusSTR3_LBUString3
68WOWIPSTAT SearchWO WIP StatusSTR3_LBUString3
69WOTYPE SearchWork Order TypeSTR10_LBAUString10
70WOLOCAT SearchWO LocationSTR10_Location_CodeString10
71Parts_Available_Status SearchParts Available StatusSTR3_LBUString3
72SVC_Address_Option SearchSVC_Address_OptionDDL_Address_OptionInteger0
73SVC_Disable_XFR_Grouping SearchSVC_Disable_XFR_GroupingCBBoolean0
74Ready_To_Invoice_Status SearchReady To Invoice StatusSTR3_LBUString3
75Invoiced_Status SearchInvoiced StatusSTR3_LBUString3
76SVC_Auto_Create_Labor SearchSVC Auto Create LaborDDL_Create_LaborInteger0
77USRDRPR6 SearchUser Defined Prompt 6STR15String15
78USRDRPR7 SearchUser Defined Prompt 7STR15String15
79USRDRPR8 SearchUser Defined Prompt 8STR15String15
80USRDRPR9 SearchUser Defined Prompt 9STR15String15
81USRDRP10 SearchUser Defined Prompt 10STR15String15
82SVC_User_Define_Prompt1 SearchSVC User Define Prompt1STR15String15
83SVC_User_Define_Prompt2 SearchSVC User Define Prompt2STR15String15
84SVC_User_Define_Prompt3 SearchSVC User Define Prompt3STR15String15
85SVC_User_Define_Prompt4 SearchSVC User Define Prompt4STR15String15
86SVC_User_Define_Prompt5 SearchSVC User Define Prompt5STR15String15
87SVC_User_Define_Prompt6 SearchSVC User Define Prompt6STR15String15
88SVC_User_Define_Prompt7 SearchSVC User Define Prompt7STR15String15
89SVC_User_Define_Prompt8 SearchSVC User Define Prompt8STR15String15
90SVC_User_Define_Prompt9 SearchSVC User Define Prompt9STR15String15
91SVC_User_Define_Prompt10 SearchSVC User Define Prompt10STR15String15
92SVC_User_Define_Prompt11 SearchSVC User Define Prompt11STR15String15
93SVC_User_Define_Prompt12 SearchSVC User Define Prompt12STR15String15
94SVC_User_Define_Prompt13 SearchSVC User Define Prompt13STR15String15
95SVC_User_Define_Prompt14 SearchSVC User Define Prompt14STR15String15
96SVC_User_Define_Prompt15 SearchSVC User Define Prompt15STR15String15
97SVC_Check_SC_Labor SearchSVC_Check_SC_LaborSVC_Stop_HardnessInteger0
98SVC_Check_WO_Labor SearchSVC_Check_WO_LaborSVC_Stop_HardnessInteger0
99SVC_Check_Call_Back SearchSVC Check Call BackCB_Call_BackBoolean0
100SVC_Service_Type SearchSVC Service TypeSTR10_LBAUString10
101SVC_Directory SearchSVC DirectorySTR98String98
102SVC_Return_Price_Level SearchSVC Return Price LevelSTR10_LBAUString10
103SVC_Transfer_Option SearchSVC Transfer OptionDDL_Transfer_OptionInteger0
104SVC_Service_Batch_ID SearchSVC Service Batch IDSTR15_LBAUString15
105SVC_Service_Document_ID SearchSVC Service Document IDSTR15_LBAUString15
106SVC_Contract_Batch_ID SearchSVC Contract Batch IDSTR15_LBAUString15
107SVC_Contract_Document_ID SearchSVC Contract Document IDSTR15_LBAUString15
108SVC_Use_Return SearchSVC Use ReturnCBBoolean0
109SVC_Dup_Serial SearchSVC_Dup_SerialSVC_DDL_PromptInteger0
110SVC_Auto_SOP_Contract SearchSVC Auto SOP ContractCBBoolean0
111SVC_Contract_Warranty SearchSVC Contract WarrantyCBBoolean0
112SVC_Create_Serial SearchSVC Create SerialCBBoolean0
113SVC_Vendor_Warranty_Flag SearchSVC Vendor Warranty FlagSVC_Warranty_FlagInteger0
114SVC_Seller_Warranty_Flag SearchSVC Seller Warranty FlagSVC_Seller_WarrantyInteger0
115SVC_Create_POP_Serial SearchSVC Create POP SerialCBBoolean0
116SVC_ItemDelta SearchSVC ItemDeltaCBBoolean0
117SVC_Allow_Contract_0_SOP SearchSVC Allow Contract 0 SOPCBBoolean0
118SVC_Allow_Service_0_SOP SearchSVC Allow Service 0 SOPCBBoolean0
119SVC_C_Credit_Batch_ID SearchSVC C Credit Batch IDSTR15_LBAUString15
120SVC_C_Credit_Document_ID SearchSVC C Credit Document IDSTR15_LBAUString15
121SVC_S_Credit_Batch_ID SearchSVC S Credit Batch IDSTR15_LBAUString15
122SVC_S_Credit_Document_ID SearchSVC S Credit Document IDSTR15_LBAUString15
123SVC_Zero_Batch_ID SearchSVC Zero Batch IDSTR15_LBAUString15
124SVC_Zero_Document_ID SearchSVC Zero Document IDSTR15_LBAUString15
125SVC_Auto_Credit_Receipt SearchSVC Auto Credit ReceiptCBBoolean0
126SVC_Auto_Replace_Receipt SearchSVC Auto Replace ReceiptCBBoolean0
127SVC_RMA_Invoice_Batch_ID SearchSVC RMA Invoice Batch IDSTR15_LBAUString15
128SVC_RMA_Credit_Batch_ID SearchSVC RMA Credit Batch IDSTR15_LBAUString15
129SVC_RMA_Order_Batch_ID SearchSVC RMA Order Batch IDSTR15_LBAUString15
130Call_To SearchCall ToSTR3_LBUString3
131Call_From SearchCall FromSTR3_LBUString3
132priorityLevel SearchpriorityLevelINT4Integer4
133SVC_User_Define_Prompt16 SearchSVC User Define Prompt16STR15String15
134SVC_User_Define_Prompt17 SearchSVC User Define Prompt17STR15String15
135SVC_User_Define_Prompt18 SearchSVC User Define Prompt18STR15String15
136SVC_User_Define_Prompt19 SearchSVC User Define Prompt19STR15String15
137SVC_User_Define_Prompt20 SearchSVC User Define Prompt20STR15String15
138SVC_Auto_XShip_Receipt SearchSVC Auto XShip ReceiptCBBoolean0
139SVC_Use_Payable SearchSVC Use PayableCBBoolean0
140SVC_PrePaid_Override SearchSVC PrePaid OverrideCBBoolean0
141SVC_DistHistory_Contract SearchSVC Dist History ContractCBBoolean0
142SVC_DistHistory_RMA SearchSVC Dist History RMACBBoolean0
143SVC_DistHistory_RTV SearchSVC Dist History RTVCBBoolean0
144SVC_DistHistory_Service SearchSVC Dist History ServiceCBBoolean0
145SVC_DistHistory_Transfer SearchSVC Dist History TransferCBBoolean0
146SVC_DistHistory_Work_Ord SearchSVC Dist History Work OrderCBBoolean0
147SVC_Use_Same_Number SearchSVC Use Same NumberCBBoolean0
148SVC_InStock_Customer SearchSVC InStock CustomerSTR15_RM_Customer_NumberString15
149SVC_InStock_Status SearchSVC InStock StatusSTR10_LBAUString10
150SVC_Create_Non_Serial_Eq SearchSVC Create Non Serial EquipCBBoolean0
151SVC_Allow_RMA_0_SOP SearchSVC Allow RMA 0 SOPCBBoolean0
152SVC_Use_Return_Price_Lev SearchSVC Use Return Price LevelCBBoolean0
153SVC_Supersession_Enabled SearchSVC Supersession EnabledCBBoolean0
154AUTOREN SearchAuto RenewingCBBoolean0
155SVC_Days_to_Renew SearchSVC Days to RenewINT4_U0Integer4
156MXINCPCT SearchMax Increase PercentatgeDLR5_%2Currency8
157PCTCRYFWD SearchPercentage Carried ForwardDLR5_%2Currency8
158SVC_Remove_Price_Overrid SearchSVC Remove Price OverrideCBBoolean0
159RENPRCSCHD SearchRenewing Price ScheduleSTR10_ScheduleString10
160CNSOLDTD SearchConsolidatedCB_ConsolidatedBoolean0
161svcDonotCombinePM SearchsvcDonotCombinePMCBBoolean0
162svcContractPMOnly SearchsvcContractPMOnlyCBBoolean0
163svcAutoMoveHistory SearchsvcAutoMoveHistoryCBBoolean0
164svcAllowNonInventoried SearchsvcAllowNonInventoriedCBBoolean0
165svcUsePayRate SearchsvcUsePayRateCBBoolean0
166svcUsePayroll SearchsvcUsePayrollsvcUsePayrollDDLInteger0
167svcDefaultWorkType SearchsvcDefaultWorkTypeSTR10_LBAUString10
168svcDefaultWorkType_1 SearchsvcDefaultWorkType[1]STR10_LBAUString10
169svcDefaultWorkType_2 SearchsvcDefaultWorkType[2]STR10_LBAUString10
170svcDefaultWorkType_3 SearchsvcDefaultWorkType[3]STR10_LBAUString10
171svcDefaultWorkType_4 SearchsvcDefaultWorkType[4]STR10_LBAUString10
172svcDefaultWorkType_5 SearchsvcDefaultWorkType[5]STR10_LBAUString10
173svcBillingExchangeRate SearchsvcBillingExchangeRatesvcExchangeRateUseInteger0
174svcRevenueExchangeRate SearchsvcRevenueExchangeRatesvcExchangeRateUseInteger0
175svcConsolidateSOPOrder SearchsvcConsolidateSOPOrderCBBoolean0
176svcCreateMAEquipment SearchsvcCreateMAEquipmentCBBoolean0
177svcCreateMANonSerialEq SearchsvcCreateMANonSerialEqCBBoolean0
178DEX_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.

Leave a Reply

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