SVC00998 - Master Defaults | Prospr - Dynamics GP Table Reference

SVC00998 - Master Defaults

Query Builder

Select * from SVC00998

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
SEQUENCE1	Sequence	Currency	10	View
SRVRECTYPE	Service Record Type	Integer	2	View
MULEQUIP	Multiple Equipment	Boolean	2	View
MULCODES	Multiple Codes	Boolean	2	View
MULTECH	Multiple Technicians	Boolean	2	View
TIMEZONE	TimeZone	String	4	View
SRVTYPE	Service Type	String	12	View
OFFID	Office ID	String	12	View
LOCNCODE	Location Code	String	12	View
SRVSTAT	Service Call Status	String	4	View
Backorder_Status	Backorder Status	String	4	View
Intransit_Status	Intransit Status	String	4	View
Dispatch_Status	Dispatch Status	String	4	View
Arrival_Status	Arrival Status	String	4	View
Complete_Status	Complete Status	String	4	View
POSTAT	Purchase Order Status	String	4	View
Single_PO	Single PO	Boolean	2	View
SRLSTAT	Equipment Status	String	12	View
RETSTATUS	Return Serial Status	String	12	View
CKSVCAREA	Check Service Area	Boolean	2	View
CKSKILL	Check Skills	Boolean	2	View
CONSTS	Contract Record Type	Integer	2	View
PRICSHED	Price Schedule	String	12	View
CNTTYPE	Contract Type	String	12	View
MAPPRLOC	Map Program Location	String	62	View
USRDFPR1	User Defined Prompt 1	String	16	View
USRDRPR2	User Defined Prompt 2	String	16	View
USRDRPR3	User Defined Prompt 3	String	16	View
USRDRPR4	User Defined Prompt 4	String	16	View
USRDRPR5	User Defined Prompt 5	String	16	View
NUMDAYSOD	Number Of Days Overdue	Integer	2	View
NUMDAYSPM	Number Of Days PM	Integer	2	View
NUMDAYSCB	Number Of Days Callback	Integer	2	View
CHGHIST	Change History	Boolean	2	View
AUTOCUST	Auto Customer Number	Boolean	2	View
CUSTNMBR	Customer Number	String	16	View
RETCSTNR	Return Customer Number	String	16	View
PAGEON	Paging On	Boolean	2	View
PAGEPROFILE	Paging Profile	String	22	View
PRCLEVEL	PriceLevel	String	12	View
Use_SOP	Use SOP	Boolean	2	View
Password_Array_1	Password Array[1]	String	16	View
Password_Array_2	Password Array[2]	String	16	View
Password_Array_3	Password Array[3]	String	16	View
Password_Array_4	Password Array[4]	String	16	View
Password_Array_5	Password Array[5]	String	16	View
Password_Array_6	Password Array[6]	String	16	View
Password_Array_7	Password Array[7]	String	16	View
Check_Customer	Check Customer	Boolean	2	View
Check_Customer_Address	Check Customer Address	Boolean	2	View
Check_Serial	Check Serial	Boolean	2	View
EMail_Tech	E-Mail Tech	Boolean	2	View
Use_POP	Use POP	Integer	2	View
Print_to_Web	Print to Web	Boolean	2	View
Check_Call_Back	Check Call Back	Boolean	2	View
Retainage_Percent	Retainage Percent	Integer	2	View
RETTYPE	SVC Return Type	String	12	View
RTV_Type	RTV Type	String	12	View
SVC_PO_Validation	SVC_PO_Validation	Integer	2	View
Location_Code_Vendor	Location Code Vendor	String	12	View
WORECTYPE	Work Order Record Type	Integer	2	View
WO_Office_ID	WO Office ID	String	12	View
WO_TimeZone	WO TimeZone	String	4	View
WOENTSTA	WO Entered Status	String	4	View
WOBOSTAT	WO Backordered Status	String	4	View
WOCOMPSTAT	WO Completed Status	String	4	View
WOWIPSTAT	WO WIP Status	String	4	View
WOTYPE	Work Order Type	String	12	View
WOLOCAT	WO Location	String	12	View
Parts_Available_Status	Parts Available Status	String	4	View
SVC_Address_Option	SVC_Address_Option	Integer	2	View
SVC_Disable_XFR_Grouping	SVC_Disable_XFR_Grouping	Boolean	2	View
Ready_To_Invoice_Status	Ready To Invoice Status	String	4	View
Invoiced_Status	Invoiced Status	String	4	View
SVC_Auto_Create_Labor	SVC Auto Create Labor	Integer	2	View
USRDRPR6	User Defined Prompt 6	String	16	View
USRDRPR7	User Defined Prompt 7	String	16	View
USRDRPR8	User Defined Prompt 8	String	16	View
USRDRPR9	User Defined Prompt 9	String	16	View
USRDRP10	User Defined Prompt 10	String	16	View
SVC_User_Define_Prompt1	SVC User Define Prompt1	String	16	View
SVC_User_Define_Prompt2	SVC User Define Prompt2	String	16	View
SVC_User_Define_Prompt3	SVC User Define Prompt3	String	16	View
SVC_User_Define_Prompt4	SVC User Define Prompt4	String	16	View
SVC_User_Define_Prompt5	SVC User Define Prompt5	String	16	View
SVC_User_Define_Prompt6	SVC User Define Prompt6	String	16	View
SVC_User_Define_Prompt7	SVC User Define Prompt7	String	16	View
SVC_User_Define_Prompt8	SVC User Define Prompt8	String	16	View
SVC_User_Define_Prompt9	SVC User Define Prompt9	String	16	View
SVC_User_Define_Prompt10	SVC User Define Prompt10	String	16	View
SVC_User_Define_Prompt11	SVC User Define Prompt11	String	16	View
SVC_User_Define_Prompt12	SVC User Define Prompt12	String	16	View
SVC_User_Define_Prompt13	SVC User Define Prompt13	String	16	View
SVC_User_Define_Prompt14	SVC User Define Prompt14	String	16	View
SVC_User_Define_Prompt15	SVC User Define Prompt15	String	16	View
SVC_Check_SC_Labor	SVC_Check_SC_Labor	Integer	2	View
SVC_Check_WO_Labor	SVC_Check_WO_Labor	Integer	2	View
SVC_Check_Call_Back	SVC Check Call Back	Boolean	2	View
SVC_Service_Type	SVC Service Type	String	12	View
SVC_Directory	SVC Directory	String	100	View
SVC_Return_Price_Level	SVC Return Price Level	String	12	View
SVC_Transfer_Option	SVC Transfer Option	Integer	2	View
SVC_Service_Batch_ID	SVC Service Batch ID	String	16	View
SVC_Service_Document_ID	SVC Service Document ID	String	16	View
SVC_Contract_Batch_ID	SVC Contract Batch ID	String	16	View
SVC_Contract_Document_ID	SVC Contract Document ID	String	16	View
SVC_Use_Return	SVC Use Return	Boolean	2	View
SVC_Dup_Serial	SVC_Dup_Serial	Integer	2	View
SVC_Auto_SOP_Contract	SVC Auto SOP Contract	Boolean	2	View
SVC_Contract_Warranty	SVC Contract Warranty	Boolean	2	View
SVC_Create_Serial	SVC Create Serial	Boolean	2	View
SVC_Vendor_Warranty_Flag	SVC Vendor Warranty Flag	Integer	2	View
SVC_Seller_Warranty_Flag	SVC Seller Warranty Flag	Integer	2	View
SVC_Create_POP_Serial	SVC Create POP Serial	Boolean	2	View
SVC_ItemDelta	SVC ItemDelta	Boolean	2	View
SVC_Allow_Contract_0_SOP	SVC Allow Contract 0 SOP	Boolean	2	View
SVC_Allow_Service_0_SOP	SVC Allow Service 0 SOP	Boolean	2	View
SVC_C_Credit_Batch_ID	SVC C Credit Batch ID	String	16	View
SVC_C_Credit_Document_ID	SVC C Credit Document ID	String	16	View
SVC_S_Credit_Batch_ID	SVC S Credit Batch ID	String	16	View
SVC_S_Credit_Document_ID	SVC S Credit Document ID	String	16	View
SVC_Zero_Batch_ID	SVC Zero Batch ID	String	16	View
SVC_Zero_Document_ID	SVC Zero Document ID	String	16	View
SVC_Auto_Credit_Receipt	SVC Auto Credit Receipt	Boolean	2	View
SVC_Auto_Replace_Receipt	SVC Auto Replace Receipt	Boolean	2	View
SVC_RMA_Invoice_Batch_ID	SVC RMA Invoice Batch ID	String	16	View
SVC_RMA_Credit_Batch_ID	SVC RMA Credit Batch ID	String	16	View
SVC_RMA_Order_Batch_ID	SVC RMA Order Batch ID	String	16	View
Call_To	Call To	String	4	View
Call_From	Call From	String	4	View
priorityLevel	priorityLevel	Integer	2	View
SVC_User_Define_Prompt16	SVC User Define Prompt16	String	16	View
SVC_User_Define_Prompt17	SVC User Define Prompt17	String	16	View
SVC_User_Define_Prompt18	SVC User Define Prompt18	String	16	View
SVC_User_Define_Prompt19	SVC User Define Prompt19	String	16	View
SVC_User_Define_Prompt20	SVC User Define Prompt20	String	16	View
SVC_Auto_XShip_Receipt	SVC Auto XShip Receipt	Boolean	2	View
SVC_Use_Payable	SVC Use Payable	Boolean	2	View
SVC_PrePaid_Override	SVC PrePaid Override	Boolean	2	View
SVC_DistHistory_Contract	SVC Dist History Contract	Boolean	2	View
SVC_DistHistory_RMA	SVC Dist History RMA	Boolean	2	View
SVC_DistHistory_RTV	SVC Dist History RTV	Boolean	2	View
SVC_DistHistory_Service	SVC Dist History Service	Boolean	2	View
SVC_DistHistory_Transfer	SVC Dist History Transfer	Boolean	2	View
SVC_DistHistory_Work_Ord	SVC Dist History Work Order	Boolean	2	View
SVC_Use_Same_Number	SVC Use Same Number	Boolean	2	View
SVC_InStock_Customer	SVC InStock Customer	String	16	View
SVC_InStock_Status	SVC InStock Status	String	12	View
SVC_Create_Non_Serial_Eq	SVC Create Non Serial Equip	Boolean	2	View
SVC_Allow_RMA_0_SOP	SVC Allow RMA 0 SOP	Boolean	2	View
SVC_Use_Return_Price_Lev	SVC Use Return Price Level	Boolean	2	View
SVC_Supersession_Enabled	SVC Supersession Enabled	Boolean	2	View
AUTOREN	Auto Renewing	Boolean	2	View
SVC_Days_to_Renew	SVC Days to Renew	Integer	2	View
MXINCPCT	Max Increase Percentatge	Currency	10	View
PCTCRYFWD	Percentage Carried Forward	Currency	10	View
SVC_Remove_Price_Overrid	SVC Remove Price Override	Boolean	2	View
RENPRCSCHD	Renewing Price Schedule	String	12	View
CNSOLDTD	Consolidated	Boolean	2	View
svcDonotCombinePM	svcDonotCombinePM	Boolean	2	View
svcContractPMOnly	svcContractPMOnly	Boolean	2	View
svcAutoMoveHistory	svcAutoMoveHistory	Boolean	2	View
svcAllowNonInventoried	svcAllowNonInventoried	Boolean	2	View
svcUsePayRate	svcUsePayRate	Boolean	2	View
svcUsePayroll	svcUsePayroll	Integer	2	View
svcDefaultWorkType_1	svcDefaultWorkType[1]	String	12	View
svcDefaultWorkType_2	svcDefaultWorkType[2]	String	12	View
svcDefaultWorkType_3	svcDefaultWorkType[3]	String	12	View
svcDefaultWorkType_4	svcDefaultWorkType[4]	String	12	View
svcDefaultWorkType_5	svcDefaultWorkType[5]	String	12	View
svcBillingExchangeRate	svcBillingExchangeRate	Integer	2	View
svcRevenueExchangeRate	svcRevenueExchangeRate	Integer	2	View
svcConsolidateSOPOrder	svcConsolidateSOPOrder	Boolean	2	View
svcCreateMAEquipment	svcCreateMAEquipment	Boolean	2	View
svcCreateMANonSerialEq	svcCreateMANonSerialEq	Boolean	2	View

SVC00998 - Master Defaults

Query Builder

Customer Service

Information

My Account

Contact Us