Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SVC00998
Product: FieldService (949)
Series:
Display Name: Master Defaults Group Display Name: Service Table Group
Physical Name: SVC00998
Technical Name: SVC_Master_Defaults
Group Technical Name: Service
Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
---|---|---|---|---|---|---|
1 | SEQUENCE1 ![]() | Sequence | Currency | DLR19_$S2 | 19 | |
2 | SRVRECTYPE ![]() | Service Record Type | Integer | DDL_Service_Record_Type | 0 | |
3 | MULEQUIP ![]() | Multiple Equipment | Boolean | CB_Multiple_Equipment | 0 | |
4 | MULCODES ![]() | Multiple Codes | Boolean | CB_Multiple_Codes | 0 | |
5 | MULTECH ![]() | Multiple Technicians | Boolean | CB_Multiple_Technicians | 0 | |
6 | TIMEZONE ![]() | TimeZone | String | STR3_LBU | 3 | |
7 | SRVTYPE ![]() | Service Type | String | STR10_LBAU | 10 | |
8 | OFFID ![]() | Office ID | String | STR10_LBAU | 10 | |
9 | LOCNCODE ![]() | Location Code | String | STR10_Location_Code | 10 | |
Key to the Site Setup (IV40700).
Click to show/hideSELECT
['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 | ||||||
10 | SRVSTAT ![]() | Service Call Status | String | STR3_LBU | 3 | |
11 | Backorder_Status ![]() | Backorder Status | String | STR3_LBU | 3 | |
12 | Intransit_Status ![]() | Intransit Status | String | STR3_LBU | 3 | |
13 | Dispatch_Status ![]() | Dispatch Status | String | STR3_LBU | 3 | |
14 | Arrival_Status ![]() | Arrival Status | String | STR3_LBU | 3 | |
15 | Complete_Status ![]() | Complete Status | String | STR3_LBU | 3 | |
16 | POSTAT ![]() | Purchase Order Status | String | STR3_LBU | 3 | |
17 | Single_PO ![]() | Single PO | Boolean | boolean | 0 | |
18 | SRLSTAT ![]() | Equipment Status | String | STR10_LBAU | 10 | |
19 | RETSTATUS ![]() | Return Serial Status | String | STR10_LBAU | 10 | |
20 | CKSVCAREA ![]() | Check Service Area | Boolean | CB_Auto_Check_Service_Area | 0 | |
21 | CKSKILL ![]() | Check Skills | Boolean | CB_Auto_Check_Skills | 0 | |
22 | CONSTS ![]() | Contract Record Type | Integer | DDL_Contract_Status | 0 | |
23 | PRICSHED ![]() | Price Schedule | String | STR10_Schedule | 10 | |
24 | CNTTYPE ![]() | Contract Type | String | STR10_LBAU | 10 | |
25 | MAPPRLOC ![]() | Map Program Location | String | STR60 | 60 | |
26 | USRDFPR1 ![]() | User Defined Prompt 1 | String | STR15 | 15 | |
27 | USRDRPR2 ![]() | User Defined Prompt 2 | String | STR15 | 15 | |
28 | USRDRPR3 ![]() | User Defined Prompt 3 | String | STR15 | 15 | |
29 | USRDRPR4 ![]() | User Defined Prompt 4 | String | STR15 | 15 | |
30 | USRDRPR5 ![]() | User Defined Prompt 5 | String | STR15 | 15 | |
31 | NUMDAYSOD ![]() | Number Of Days Overdue | Integer | INT3_U0 | 3 | |
32 | NUMDAYSPM ![]() | Number Of Days PM | Integer | INT3_U0 | 3 | |
33 | NUMDAYSCB ![]() | Number Of Days Callback | Integer | INT3_U0 | 3 | |
34 | CHGHIST ![]() | Change History | Boolean | CB | 0 | |
35 | AUTOCUST ![]() | Auto Customer Number | Boolean | CB | 0 | |
36 | CUSTNMBR ![]() | Customer Number | String | STR15_RM_Customer_Number | 15 | |
Key to the RM Customer MSTR (RM00101).
Click to show/hideSELECT
['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 | ||||||
37 | RETCSTNR ![]() | Return Customer Number | String | STR15_RM_Customer_Number | 15 | |
38 | PAGEON ![]() | Paging On | Boolean | CB | 0 | |
39 | PAGEPROFILE ![]() | Paging Profile | String | STR20 | 20 | |
40 | PRCLEVEL ![]() | PriceLevel | String | STR10_LBAU | 10 | |
41 | Use_SOP ![]() | Use SOP | Boolean | CB | 0 | |
42 | Password_Array_1 ![]() | Password Array[1] | String | STR15_LBA | 15 | |
43 | Password_Array ![]() | Password Array | STR15_LBA | String | 15 | |
44 | Password_Array_2 ![]() | Password Array[2] | String | STR15_LBA | 15 | |
45 | Password_Array_3 ![]() | Password Array[3] | String | STR15_LBA | 15 | |
46 | Password_Array_4 ![]() | Password Array[4] | String | STR15_LBA | 15 | |
47 | Password_Array_5 ![]() | Password Array[5] | String | STR15_LBA | 15 | |
48 | Password_Array_6 ![]() | Password Array[6] | String | STR15_LBA | 15 | |
49 | Password_Array_7 ![]() | Password Array[7] | String | STR15_LBA | 15 | |
50 | Check_Customer ![]() | Check Customer | Boolean | CB | 0 | |
51 | Check_Customer_Address ![]() | Check Customer Address | Boolean | CB | 0 | |
52 | Check_Serial ![]() | Check Serial | Boolean | CB | 0 | |
53 | EMail_Tech ![]() | E-Mail Tech | Boolean | CB | 0 | |
54 | Use_POP ![]() | Use POP | Integer | SVC_DDL_Use_POP | 0 | |
55 | Print_to_Web ![]() | Print to Web | Boolean | CB | 0 | |
56 | Check_Call_Back ![]() | Check Call Back | Boolean | CB | 0 | |
57 | Retainage_Percent ![]() | Retainage Percent | Integer | INT3_U0 | 3 | |
58 | RETTYPE ![]() | SVC Return Type | String | STR10_LBAU | 10 | |
59 | RTV_Type ![]() | RTV Type | String | STR10_LBAU | 10 | |
60 | SVC_PO_Validation ![]() | SVC_PO_Validation | Integer | SVC_PO_Link_Validation | 0 | |
61 | Location_Code_Vendor ![]() | Location Code Vendor | String | STR10_Location_Code | 10 | |
62 | WORECTYPE ![]() | Work Order Record Type | Integer | DDL_Work_Order_Record_Type | 0 | |
63 | WO_Office_ID ![]() | WO Office ID | String | STR10_LBAU | 10 | |
64 | WO_TimeZone ![]() | WO TimeZone | String | STR3_LBU | 3 | |
65 | WOENTSTA ![]() | WO Entered Status | String | STR3_LBU | 3 | |
66 | WOBOSTAT ![]() | WO Backordered Status | String | STR3_LBU | 3 | |
67 | WOCOMPSTAT ![]() | WO Completed Status | String | STR3_LBU | 3 | |
68 | WOWIPSTAT ![]() | WO WIP Status | String | STR3_LBU | 3 | |
69 | WOTYPE ![]() | Work Order Type | String | STR10_LBAU | 10 | |
70 | WOLOCAT ![]() | WO Location | String | STR10_Location_Code | 10 | |
71 | Parts_Available_Status ![]() | Parts Available Status | String | STR3_LBU | 3 | |
72 | SVC_Address_Option ![]() | SVC_Address_Option | Integer | DDL_Address_Option | 0 | |
73 | SVC_Disable_XFR_Grouping ![]() | SVC_Disable_XFR_Grouping | Boolean | CB | 0 | |
74 | Ready_To_Invoice_Status ![]() | Ready To Invoice Status | String | STR3_LBU | 3 | |
75 | Invoiced_Status ![]() | Invoiced Status | String | STR3_LBU | 3 | |
76 | SVC_Auto_Create_Labor ![]() | SVC Auto Create Labor | Integer | DDL_Create_Labor | 0 | |
77 | USRDRPR6 ![]() | User Defined Prompt 6 | String | STR15 | 15 | |
78 | USRDRPR7 ![]() | User Defined Prompt 7 | String | STR15 | 15 | |
79 | USRDRPR8 ![]() | User Defined Prompt 8 | String | STR15 | 15 | |
80 | USRDRPR9 ![]() | User Defined Prompt 9 | String | STR15 | 15 | |
81 | USRDRP10 ![]() | User Defined Prompt 10 | String | STR15 | 15 | |
82 | SVC_User_Define_Prompt1 ![]() | SVC User Define Prompt1 | String | STR15 | 15 | |
83 | SVC_User_Define_Prompt2 ![]() | SVC User Define Prompt2 | String | STR15 | 15 | |
84 | SVC_User_Define_Prompt3 ![]() | SVC User Define Prompt3 | String | STR15 | 15 | |
85 | SVC_User_Define_Prompt4 ![]() | SVC User Define Prompt4 | String | STR15 | 15 | |
86 | SVC_User_Define_Prompt5 ![]() | SVC User Define Prompt5 | String | STR15 | 15 | |
87 | SVC_User_Define_Prompt6 ![]() | SVC User Define Prompt6 | String | STR15 | 15 | |
88 | SVC_User_Define_Prompt7 ![]() | SVC User Define Prompt7 | String | STR15 | 15 | |
89 | SVC_User_Define_Prompt8 ![]() | SVC User Define Prompt8 | String | STR15 | 15 | |
90 | SVC_User_Define_Prompt9 ![]() | SVC User Define Prompt9 | String | STR15 | 15 | |
91 | SVC_User_Define_Prompt10 ![]() | SVC User Define Prompt10 | String | STR15 | 15 | |
92 | SVC_User_Define_Prompt11 ![]() | SVC User Define Prompt11 | String | STR15 | 15 | |
93 | SVC_User_Define_Prompt12 ![]() | SVC User Define Prompt12 | String | STR15 | 15 | |
94 | SVC_User_Define_Prompt13 ![]() | SVC User Define Prompt13 | String | STR15 | 15 | |
95 | SVC_User_Define_Prompt14 ![]() | SVC User Define Prompt14 | String | STR15 | 15 | |
96 | SVC_User_Define_Prompt15 ![]() | SVC User Define Prompt15 | String | STR15 | 15 | |
97 | SVC_Check_SC_Labor ![]() | SVC_Check_SC_Labor | Integer | SVC_Stop_Hardness | 0 | |
98 | SVC_Check_WO_Labor ![]() | SVC_Check_WO_Labor | Integer | SVC_Stop_Hardness | 0 | |
99 | SVC_Check_Call_Back ![]() | SVC Check Call Back | Boolean | CB_Call_Back | 0 | |
100 | SVC_Service_Type ![]() | SVC Service Type | String | STR10_LBAU | 10 | |
101 | SVC_Directory ![]() | SVC Directory | String | STR98 | 98 | |
102 | SVC_Return_Price_Level ![]() | SVC Return Price Level | String | STR10_LBAU | 10 | |
103 | SVC_Transfer_Option ![]() | SVC Transfer Option | Integer | DDL_Transfer_Option | 0 | |
104 | SVC_Service_Batch_ID ![]() | SVC Service Batch ID | String | STR15_LBAU | 15 | |
105 | SVC_Service_Document_ID ![]() | SVC Service Document ID | String | STR15_LBAU | 15 | |
106 | SVC_Contract_Batch_ID ![]() | SVC Contract Batch ID | String | STR15_LBAU | 15 | |
107 | SVC_Contract_Document_ID ![]() | SVC Contract Document ID | String | STR15_LBAU | 15 | |
108 | SVC_Use_Return ![]() | SVC Use Return | Boolean | CB | 0 | |
109 | SVC_Dup_Serial ![]() | SVC_Dup_Serial | Integer | SVC_DDL_Prompt | 0 | |
110 | SVC_Auto_SOP_Contract ![]() | SVC Auto SOP Contract | Boolean | CB | 0 | |
111 | SVC_Contract_Warranty ![]() | SVC Contract Warranty | Boolean | CB | 0 | |
112 | SVC_Create_Serial ![]() | SVC Create Serial | Boolean | CB | 0 | |
113 | SVC_Vendor_Warranty_Flag ![]() | SVC Vendor Warranty Flag | Integer | SVC_Warranty_Flag | 0 | |
114 | SVC_Seller_Warranty_Flag ![]() | SVC Seller Warranty Flag | Integer | SVC_Seller_Warranty | 0 | |
115 | SVC_Create_POP_Serial ![]() | SVC Create POP Serial | Boolean | CB | 0 | |
116 | SVC_ItemDelta ![]() | SVC ItemDelta | Boolean | CB | 0 | |
117 | SVC_Allow_Contract_0_SOP ![]() | SVC Allow Contract 0 SOP | Boolean | CB | 0 | |
118 | SVC_Allow_Service_0_SOP ![]() | SVC Allow Service 0 SOP | Boolean | CB | 0 | |
119 | SVC_C_Credit_Batch_ID ![]() | SVC C Credit Batch ID | String | STR15_LBAU | 15 | |
120 | SVC_C_Credit_Document_ID ![]() | SVC C Credit Document ID | String | STR15_LBAU | 15 | |
121 | SVC_S_Credit_Batch_ID ![]() | SVC S Credit Batch ID | String | STR15_LBAU | 15 | |
122 | SVC_S_Credit_Document_ID ![]() | SVC S Credit Document ID | String | STR15_LBAU | 15 | |
123 | SVC_Zero_Batch_ID ![]() | SVC Zero Batch ID | String | STR15_LBAU | 15 | |
124 | SVC_Zero_Document_ID ![]() | SVC Zero Document ID | String | STR15_LBAU | 15 | |
125 | SVC_Auto_Credit_Receipt ![]() | SVC Auto Credit Receipt | Boolean | CB | 0 | |
126 | SVC_Auto_Replace_Receipt ![]() | SVC Auto Replace Receipt | Boolean | CB | 0 | |
127 | SVC_RMA_Invoice_Batch_ID ![]() | SVC RMA Invoice Batch ID | String | STR15_LBAU | 15 | |
128 | SVC_RMA_Credit_Batch_ID ![]() | SVC RMA Credit Batch ID | String | STR15_LBAU | 15 | |
129 | SVC_RMA_Order_Batch_ID ![]() | SVC RMA Order Batch ID | String | STR15_LBAU | 15 | |
130 | Call_To ![]() | Call To | String | STR3_LBU | 3 | |
131 | Call_From ![]() | Call From | String | STR3_LBU | 3 | |
132 | priorityLevel ![]() | priorityLevel | Integer | INT4 | 4 | |
133 | SVC_User_Define_Prompt16 ![]() | SVC User Define Prompt16 | String | STR15 | 15 | |
134 | SVC_User_Define_Prompt17 ![]() | SVC User Define Prompt17 | String | STR15 | 15 | |
135 | SVC_User_Define_Prompt18 ![]() | SVC User Define Prompt18 | String | STR15 | 15 | |
136 | SVC_User_Define_Prompt19 ![]() | SVC User Define Prompt19 | String | STR15 | 15 | |
137 | SVC_User_Define_Prompt20 ![]() | SVC User Define Prompt20 | String | STR15 | 15 | |
138 | SVC_Auto_XShip_Receipt ![]() | SVC Auto XShip Receipt | Boolean | CB | 0 | |
139 | SVC_Use_Payable ![]() | SVC Use Payable | Boolean | CB | 0 | |
140 | SVC_PrePaid_Override ![]() | SVC PrePaid Override | Boolean | CB | 0 | |
141 | SVC_DistHistory_Contract ![]() | SVC Dist History Contract | Boolean | CB | 0 | |
142 | SVC_DistHistory_RMA ![]() | SVC Dist History RMA | Boolean | CB | 0 | |
143 | SVC_DistHistory_RTV ![]() | SVC Dist History RTV | Boolean | CB | 0 | |
144 | SVC_DistHistory_Service ![]() | SVC Dist History Service | Boolean | CB | 0 | |
145 | SVC_DistHistory_Transfer ![]() | SVC Dist History Transfer | Boolean | CB | 0 | |
146 | SVC_DistHistory_Work_Ord ![]() | SVC Dist History Work Order | Boolean | CB | 0 | |
147 | SVC_Use_Same_Number ![]() | SVC Use Same Number | Boolean | CB | 0 | |
148 | SVC_InStock_Customer ![]() | SVC InStock Customer | String | STR15_RM_Customer_Number | 15 | |
149 | SVC_InStock_Status ![]() | SVC InStock Status | String | STR10_LBAU | 10 | |
150 | SVC_Create_Non_Serial_Eq ![]() | SVC Create Non Serial Equip | Boolean | CB | 0 | |
151 | SVC_Allow_RMA_0_SOP ![]() | SVC Allow RMA 0 SOP | Boolean | CB | 0 | |
152 | SVC_Use_Return_Price_Lev ![]() | SVC Use Return Price Level | Boolean | CB | 0 | |
153 | SVC_Supersession_Enabled ![]() | SVC Supersession Enabled | Boolean | CB | 0 | |
154 | AUTOREN ![]() | Auto Renewing | Boolean | CB | 0 | |
155 | SVC_Days_to_Renew ![]() | SVC Days to Renew | Integer | INT4_U0 | 4 | |
156 | MXINCPCT ![]() | Max Increase Percentatge | Currency | DLR5_%2 | 8 | |
157 | PCTCRYFWD ![]() | Percentage Carried Forward | Currency | DLR5_%2 | 8 | |
158 | SVC_Remove_Price_Overrid ![]() | SVC Remove Price Override | Boolean | CB | 0 | |
159 | RENPRCSCHD ![]() | Renewing Price Schedule | String | STR10_Schedule | 10 | |
160 | CNSOLDTD ![]() | Consolidated | Boolean | CB_Consolidated | 0 | |
161 | svcDonotCombinePM ![]() | svcDonotCombinePM | Boolean | CB | 0 | |
162 | svcContractPMOnly ![]() | svcContractPMOnly | Boolean | CB | 0 | |
163 | svcAutoMoveHistory ![]() | svcAutoMoveHistory | Boolean | CB | 0 | |
164 | svcAllowNonInventoried ![]() | svcAllowNonInventoried | Boolean | CB | 0 | |
165 | svcUsePayRate ![]() | svcUsePayRate | Boolean | CB | 0 | |
166 | svcUsePayroll ![]() | svcUsePayroll | Integer | svcUsePayrollDDL | 0 | |
167 | svcDefaultWorkType_1 ![]() | svcDefaultWorkType[1] | String | STR10_LBAU | 10 | |
168 | svcDefaultWorkType_2 ![]() | svcDefaultWorkType[2] | String | STR10_LBAU | 10 | |
169 | svcDefaultWorkType ![]() | svcDefaultWorkType | STR10_LBAU | String | 10 | |
170 | svcDefaultWorkType_3 ![]() | svcDefaultWorkType[3] | String | STR10_LBAU | 10 | |
171 | svcDefaultWorkType_4 ![]() | svcDefaultWorkType[4] | String | STR10_LBAU | 10 | |
172 | svcDefaultWorkType_5 ![]() | svcDefaultWorkType[5] | String | STR10_LBAU | 10 | |
173 | svcBillingExchangeRate ![]() | svcBillingExchangeRate | Integer | svcExchangeRateUse | 0 | |
174 | svcRevenueExchangeRate ![]() | svcRevenueExchangeRate | Integer | svcExchangeRateUse | 0 | |
175 | svcConsolidateSOPOrder ![]() | svcConsolidateSOPOrder | Boolean | CB | 0 | |
176 | svcCreateMAEquipment ![]() | svcCreateMAEquipment | Boolean | CB | 0 | |
177 | svcCreateMANonSerialEq ![]() | svcCreateMANonSerialEq | Boolean | CB | 0 |