Master Defaults (SVC00998)

azurecurve Products FieldService (949)ProjectMaster Defaults (SVC00998)

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

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

Group Display Name: Service Table Group
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/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
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/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
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	Password Array	STR15_LBA	String	15
43	Password_Array_1	Password Array[1]	String	STR15_LBA	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

azurecurve Products FieldService (949)ProjectMaster Defaults (SVC00998)

Click to show/hide

Click to show/hide

Leave a Reply Cancel reply