Master Defaults (SVC00998)

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

Product: FieldService (949)
Series:

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 SearchSequenceCurrencyDLR19_$S219
2SRVRECTYPE SearchService Record TypeIntegerDDL_Service_Record_Type0
3MULEQUIP SearchMultiple EquipmentBooleanCB_Multiple_Equipment0
4MULCODES SearchMultiple CodesBooleanCB_Multiple_Codes0
5MULTECH SearchMultiple TechniciansBooleanCB_Multiple_Technicians0
6TIMEZONE SearchTimeZoneStringSTR3_LBU3
7SRVTYPE SearchService TypeStringSTR10_LBAU10
8OFFID SearchOffice IDStringSTR10_LBAU10
9LOCNCODE SearchLocation CodeStringSTR10_Location_Code10
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 StatusStringSTR3_LBU3
11Backorder_Status SearchBackorder StatusStringSTR3_LBU3
12Intransit_Status SearchIntransit StatusStringSTR3_LBU3
13Dispatch_Status SearchDispatch StatusStringSTR3_LBU3
14Arrival_Status SearchArrival StatusStringSTR3_LBU3
15Complete_Status SearchComplete StatusStringSTR3_LBU3
16POSTAT SearchPurchase Order StatusStringSTR3_LBU3
17Single_PO SearchSingle POBooleanboolean0
18SRLSTAT SearchEquipment StatusStringSTR10_LBAU10
19RETSTATUS SearchReturn Serial StatusStringSTR10_LBAU10
20CKSVCAREA SearchCheck Service AreaBooleanCB_Auto_Check_Service_Area0
21CKSKILL SearchCheck SkillsBooleanCB_Auto_Check_Skills0
22CONSTS SearchContract Record TypeIntegerDDL_Contract_Status0
23PRICSHED SearchPrice ScheduleStringSTR10_Schedule10
24CNTTYPE SearchContract TypeStringSTR10_LBAU10
25MAPPRLOC SearchMap Program LocationStringSTR6060
26USRDFPR1 SearchUser Defined Prompt 1StringSTR1515
27USRDRPR2 SearchUser Defined Prompt 2StringSTR1515
28USRDRPR3 SearchUser Defined Prompt 3StringSTR1515
29USRDRPR4 SearchUser Defined Prompt 4StringSTR1515
30USRDRPR5 SearchUser Defined Prompt 5StringSTR1515
31NUMDAYSOD SearchNumber Of Days OverdueIntegerINT3_U03
32NUMDAYSPM SearchNumber Of Days PMIntegerINT3_U03
33NUMDAYSCB SearchNumber Of Days CallbackIntegerINT3_U03
34CHGHIST SearchChange HistoryBooleanCB0
35AUTOCUST SearchAuto Customer NumberBooleanCB0
36CUSTNMBR SearchCustomer NumberStringSTR15_RM_Customer_Number15
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 NumberStringSTR15_RM_Customer_Number15
38PAGEON SearchPaging OnBooleanCB0
39PAGEPROFILE SearchPaging ProfileStringSTR2020
40PRCLEVEL SearchPriceLevelStringSTR10_LBAU10
41Use_SOP SearchUse SOPBooleanCB0
42Password_Array SearchPassword ArraySTR15_LBAString15
43Password_Array_1 SearchPassword Array[1]StringSTR15_LBA15
44Password_Array_2 SearchPassword Array[2]StringSTR15_LBA15
45Password_Array_3 SearchPassword Array[3]StringSTR15_LBA15
46Password_Array_4 SearchPassword Array[4]StringSTR15_LBA15
47Password_Array_5 SearchPassword Array[5]StringSTR15_LBA15
48Password_Array_6 SearchPassword Array[6]StringSTR15_LBA15
49Password_Array_7 SearchPassword Array[7]StringSTR15_LBA15
50Check_Customer SearchCheck CustomerBooleanCB0
51Check_Customer_Address SearchCheck Customer AddressBooleanCB0
52Check_Serial SearchCheck SerialBooleanCB0
53EMail_Tech SearchE-Mail TechBooleanCB0
54Use_POP SearchUse POPIntegerSVC_DDL_Use_POP0
55Print_to_Web SearchPrint to WebBooleanCB0
56Check_Call_Back SearchCheck Call BackBooleanCB0
57Retainage_Percent SearchRetainage PercentIntegerINT3_U03
58RETTYPE SearchSVC Return TypeStringSTR10_LBAU10
59RTV_Type SearchRTV TypeStringSTR10_LBAU10
60SVC_PO_Validation SearchSVC_PO_ValidationIntegerSVC_PO_Link_Validation0
61Location_Code_Vendor SearchLocation Code VendorStringSTR10_Location_Code10
62WORECTYPE SearchWork Order Record TypeIntegerDDL_Work_Order_Record_Type0
63WO_Office_ID SearchWO Office IDStringSTR10_LBAU10
64WO_TimeZone SearchWO TimeZoneStringSTR3_LBU3
65WOENTSTA SearchWO Entered StatusStringSTR3_LBU3
66WOBOSTAT SearchWO Backordered StatusStringSTR3_LBU3
67WOCOMPSTAT SearchWO Completed StatusStringSTR3_LBU3
68WOWIPSTAT SearchWO WIP StatusStringSTR3_LBU3
69WOTYPE SearchWork Order TypeStringSTR10_LBAU10
70WOLOCAT SearchWO LocationStringSTR10_Location_Code10
71Parts_Available_Status SearchParts Available StatusStringSTR3_LBU3
72SVC_Address_Option SearchSVC_Address_OptionIntegerDDL_Address_Option0
73SVC_Disable_XFR_Grouping SearchSVC_Disable_XFR_GroupingBooleanCB0
74Ready_To_Invoice_Status SearchReady To Invoice StatusStringSTR3_LBU3
75Invoiced_Status SearchInvoiced StatusStringSTR3_LBU3
76SVC_Auto_Create_Labor SearchSVC Auto Create LaborIntegerDDL_Create_Labor0
77USRDRPR6 SearchUser Defined Prompt 6StringSTR1515
78USRDRPR7 SearchUser Defined Prompt 7StringSTR1515
79USRDRPR8 SearchUser Defined Prompt 8StringSTR1515
80USRDRPR9 SearchUser Defined Prompt 9StringSTR1515
81USRDRP10 SearchUser Defined Prompt 10StringSTR1515
82SVC_User_Define_Prompt1 SearchSVC User Define Prompt1StringSTR1515
83SVC_User_Define_Prompt2 SearchSVC User Define Prompt2StringSTR1515
84SVC_User_Define_Prompt3 SearchSVC User Define Prompt3StringSTR1515
85SVC_User_Define_Prompt4 SearchSVC User Define Prompt4StringSTR1515
86SVC_User_Define_Prompt5 SearchSVC User Define Prompt5StringSTR1515
87SVC_User_Define_Prompt6 SearchSVC User Define Prompt6StringSTR1515
88SVC_User_Define_Prompt7 SearchSVC User Define Prompt7StringSTR1515
89SVC_User_Define_Prompt8 SearchSVC User Define Prompt8StringSTR1515
90SVC_User_Define_Prompt9 SearchSVC User Define Prompt9StringSTR1515
91SVC_User_Define_Prompt10 SearchSVC User Define Prompt10StringSTR1515
92SVC_User_Define_Prompt11 SearchSVC User Define Prompt11StringSTR1515
93SVC_User_Define_Prompt12 SearchSVC User Define Prompt12StringSTR1515
94SVC_User_Define_Prompt13 SearchSVC User Define Prompt13StringSTR1515
95SVC_User_Define_Prompt14 SearchSVC User Define Prompt14StringSTR1515
96SVC_User_Define_Prompt15 SearchSVC User Define Prompt15StringSTR1515
97SVC_Check_SC_Labor SearchSVC_Check_SC_LaborIntegerSVC_Stop_Hardness0
98SVC_Check_WO_Labor SearchSVC_Check_WO_LaborIntegerSVC_Stop_Hardness0
99SVC_Check_Call_Back SearchSVC Check Call BackBooleanCB_Call_Back0
100SVC_Service_Type SearchSVC Service TypeStringSTR10_LBAU10
101SVC_Directory SearchSVC DirectoryStringSTR9898
102SVC_Return_Price_Level SearchSVC Return Price LevelStringSTR10_LBAU10
103SVC_Transfer_Option SearchSVC Transfer OptionIntegerDDL_Transfer_Option0
104SVC_Service_Batch_ID SearchSVC Service Batch IDStringSTR15_LBAU15
105SVC_Service_Document_ID SearchSVC Service Document IDStringSTR15_LBAU15
106SVC_Contract_Batch_ID SearchSVC Contract Batch IDStringSTR15_LBAU15
107SVC_Contract_Document_ID SearchSVC Contract Document IDStringSTR15_LBAU15
108SVC_Use_Return SearchSVC Use ReturnBooleanCB0
109SVC_Dup_Serial SearchSVC_Dup_SerialIntegerSVC_DDL_Prompt0
110SVC_Auto_SOP_Contract SearchSVC Auto SOP ContractBooleanCB0
111SVC_Contract_Warranty SearchSVC Contract WarrantyBooleanCB0
112SVC_Create_Serial SearchSVC Create SerialBooleanCB0
113SVC_Vendor_Warranty_Flag SearchSVC Vendor Warranty FlagIntegerSVC_Warranty_Flag0
114SVC_Seller_Warranty_Flag SearchSVC Seller Warranty FlagIntegerSVC_Seller_Warranty0
115SVC_Create_POP_Serial SearchSVC Create POP SerialBooleanCB0
116SVC_ItemDelta SearchSVC ItemDeltaBooleanCB0
117SVC_Allow_Contract_0_SOP SearchSVC Allow Contract 0 SOPBooleanCB0
118SVC_Allow_Service_0_SOP SearchSVC Allow Service 0 SOPBooleanCB0
119SVC_C_Credit_Batch_ID SearchSVC C Credit Batch IDStringSTR15_LBAU15
120SVC_C_Credit_Document_ID SearchSVC C Credit Document IDStringSTR15_LBAU15
121SVC_S_Credit_Batch_ID SearchSVC S Credit Batch IDStringSTR15_LBAU15
122SVC_S_Credit_Document_ID SearchSVC S Credit Document IDStringSTR15_LBAU15
123SVC_Zero_Batch_ID SearchSVC Zero Batch IDStringSTR15_LBAU15
124SVC_Zero_Document_ID SearchSVC Zero Document IDStringSTR15_LBAU15
125SVC_Auto_Credit_Receipt SearchSVC Auto Credit ReceiptBooleanCB0
126SVC_Auto_Replace_Receipt SearchSVC Auto Replace ReceiptBooleanCB0
127SVC_RMA_Invoice_Batch_ID SearchSVC RMA Invoice Batch IDStringSTR15_LBAU15
128SVC_RMA_Credit_Batch_ID SearchSVC RMA Credit Batch IDStringSTR15_LBAU15
129SVC_RMA_Order_Batch_ID SearchSVC RMA Order Batch IDStringSTR15_LBAU15
130Call_To SearchCall ToStringSTR3_LBU3
131Call_From SearchCall FromStringSTR3_LBU3
132priorityLevel SearchpriorityLevelIntegerINT44
133SVC_User_Define_Prompt16 SearchSVC User Define Prompt16StringSTR1515
134SVC_User_Define_Prompt17 SearchSVC User Define Prompt17StringSTR1515
135SVC_User_Define_Prompt18 SearchSVC User Define Prompt18StringSTR1515
136SVC_User_Define_Prompt19 SearchSVC User Define Prompt19StringSTR1515
137SVC_User_Define_Prompt20 SearchSVC User Define Prompt20StringSTR1515
138SVC_Auto_XShip_Receipt SearchSVC Auto XShip ReceiptBooleanCB0
139SVC_Use_Payable SearchSVC Use PayableBooleanCB0
140SVC_PrePaid_Override SearchSVC PrePaid OverrideBooleanCB0
141SVC_DistHistory_Contract SearchSVC Dist History ContractBooleanCB0
142SVC_DistHistory_RMA SearchSVC Dist History RMABooleanCB0
143SVC_DistHistory_RTV SearchSVC Dist History RTVBooleanCB0
144SVC_DistHistory_Service SearchSVC Dist History ServiceBooleanCB0
145SVC_DistHistory_Transfer SearchSVC Dist History TransferBooleanCB0
146SVC_DistHistory_Work_Ord SearchSVC Dist History Work OrderBooleanCB0
147SVC_Use_Same_Number SearchSVC Use Same NumberBooleanCB0
148SVC_InStock_Customer SearchSVC InStock CustomerStringSTR15_RM_Customer_Number15
149SVC_InStock_Status SearchSVC InStock StatusStringSTR10_LBAU10
150SVC_Create_Non_Serial_Eq SearchSVC Create Non Serial EquipBooleanCB0
151SVC_Allow_RMA_0_SOP SearchSVC Allow RMA 0 SOPBooleanCB0
152SVC_Use_Return_Price_Lev SearchSVC Use Return Price LevelBooleanCB0
153SVC_Supersession_Enabled SearchSVC Supersession EnabledBooleanCB0
154AUTOREN SearchAuto RenewingBooleanCB0
155SVC_Days_to_Renew SearchSVC Days to RenewIntegerINT4_U04
156MXINCPCT SearchMax Increase PercentatgeCurrencyDLR5_%28
157PCTCRYFWD SearchPercentage Carried ForwardCurrencyDLR5_%28
158SVC_Remove_Price_Overrid SearchSVC Remove Price OverrideBooleanCB0
159RENPRCSCHD SearchRenewing Price ScheduleStringSTR10_Schedule10
160CNSOLDTD SearchConsolidatedBooleanCB_Consolidated0
161svcDonotCombinePM SearchsvcDonotCombinePMBooleanCB0
162svcContractPMOnly SearchsvcContractPMOnlyBooleanCB0
163svcAutoMoveHistory SearchsvcAutoMoveHistoryBooleanCB0
164svcAllowNonInventoried SearchsvcAllowNonInventoriedBooleanCB0
165svcUsePayRate SearchsvcUsePayRateBooleanCB0
166svcUsePayroll SearchsvcUsePayrollIntegersvcUsePayrollDDL0
167svcDefaultWorkType_1 SearchsvcDefaultWorkType[1]StringSTR10_LBAU10
168svcDefaultWorkType_2 SearchsvcDefaultWorkType[2]StringSTR10_LBAU10
169svcDefaultWorkType SearchsvcDefaultWorkTypeSTR10_LBAUString10
170svcDefaultWorkType_3 SearchsvcDefaultWorkType[3]StringSTR10_LBAU10
171svcDefaultWorkType_4 SearchsvcDefaultWorkType[4]StringSTR10_LBAU10
172svcDefaultWorkType_5 SearchsvcDefaultWorkType[5]StringSTR10_LBAU10
173svcBillingExchangeRate SearchsvcBillingExchangeRateIntegersvcExchangeRateUse0
174svcRevenueExchangeRate SearchsvcRevenueExchangeRateIntegersvcExchangeRateUse0
175svcConsolidateSOPOrder SearchsvcConsolidateSOPOrderBooleanCB0
176svcCreateMAEquipment SearchsvcCreateMAEquipmentBooleanCB0
177svcCreateMANonSerialEq SearchsvcCreateMANonSerialEqBooleanCB0

Leave a Reply

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