DynDeveloper.com

DynDeveloper.com
Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now! Log In
Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our SOP scripts. All of our scripts for Dynamics GP can be found here
Module List > Module SVC tables SVC00998
You are currently viewing the COMPANY database.
Change

COMPANY..SVC00998 Table Definition

(COMPANY..Master Defaults)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value		 Source
SEQUENCE1 numeric(19,5)
0.00

SRVRECTYPE smallint
0
Field Type...(more) Join Now
MULEQUIP tinyint
0

MULCODES tinyint
0

MULTECH tinyint
0

TIMEZONE char(3)
''
Field Type...(more) Join Now
SRVTYPE char(11)
''
Field Type...(more) Join Now
OFFID char(11)
''
Field Type...(more) Join Now
LOCNCODE char(11)
''
Field Type...(more) Join Now
join ... more text available
SRVSTAT char(3)
''
Field Type...(more) Join Now
Backorder_Status char(3)
''

Intransit_Status char(3)
''

Dispatch_Status char(3)
''

Arrival_Status char(3)
''

Complete_Status char(3)
''

POSTAT char(3)
''

Single_PO tinyint
0

SRLSTAT char(11)
''

RETSTATUS char(11)
''

CKSVCAREA tinyint
0

CKSKILL tinyint
0

CONSTS smallint
0
Field Type...(more) Join Now
PRICSHED char(11)
''
Field Type...(more) Join Now
CNTTYPE char(11)
''
Field Type...(more) Join Now
MAPPRLOC char(61)
''

USRDFPR1 char(15)
''

USRDRPR2 char(15)
''

USRDRPR3 char(15)
''

USRDRPR4 char(15)
''

USRDRPR5 char(15)
''

NUMDAYSOD smallint
0

NUMDAYSPM smallint
0

NUMDAYSCB smallint
0

CHGHIST tinyint
0

AUTOCUST tinyint
0

CUSTNMBR char(15)
''
Field Type...(more) Join Now
join ... more text available
RETCSTNR char(15)
''

PAGEON tinyint
0

PAGEPROFILE char(21)
''

PRCLEVEL char(11)
''
Field Type...(more) Join Now
Use_SOP tinyint
0

Password_Array_1 char(15)
''

Password_Array_2 char(15)
''

Password_Array_3 char(15)
''

Password_Array_4 char(15)
''

Password_Array_5 char(15)
''

Password_Array_6 char(15)
''

Password_Array_7 char(15)
''

Check_Customer tinyint
0

Check_Customer_Address tinyint
0

Check_Serial tinyint
0

EMail_Tech tinyint
0

Use_POP smallint
0

Print_to_Web tinyint
0
Field Type...(more) Join Now
Check_Call_Back tinyint
0

Retainage_Percent smallint
0

RETTYPE char(11)
''
Field Type...(more) Join Now
RTV_Type char(11)
''

SVC_PO_Validation smallint
0

Location_Code_Vendor char(11)
''

WORECTYPE smallint
0
1 - Quoteb...(more) Join Now
WO_Office_ID char(11)
''

WO_TimeZone char(3)
''

WOENTSTA char(3)
''

WOBOSTAT char(3)
''

WOCOMPSTAT char(3)
''

WOWIPSTAT char(3)
''

WOTYPE char(11)
''

WOLOCAT char(11)
''

Parts_Available_Status char(3)
''

SVC_Address_Option smallint
0
Field Type...(more) Join Now
SVC_Disable_XFR_Grouping tinyint
0
Field Type...(more) Join Now
Ready_To_Invoice_Status char(3)
''

Invoiced_Status char(3)
''

SVC_Auto_Create_Labor smallint
0

USRDRPR6 char(15)
''

USRDRPR7 char(15)
''

USRDRPR8 char(15)
''

USRDRPR9 char(15)
''

USRDRP10 char(15)
''

SVC_User_Define_Prompt1 char(15)
''

SVC_User_Define_Prompt2 char(15)
''

SVC_User_Define_Prompt3 char(15)
''

SVC_User_Define_Prompt4 char(15)
''

SVC_User_Define_Prompt5 char(15)
''

SVC_User_Define_Prompt6 char(15)
''

SVC_User_Define_Prompt7 char(15)
''

SVC_User_Define_Prompt8 char(15)
''

SVC_User_Define_Prompt9 char(15)
''

SVC_User_Define_Prompt10 char(15)
''

SVC_User_Define_Prompt11 char(15)
''

SVC_User_Define_Prompt12 char(15)
''

SVC_User_Define_Prompt13 char(15)
''

SVC_User_Define_Prompt14 char(15)
''

SVC_User_Define_Prompt15 char(15)
''

SVC_Check_SC_Labor smallint
0

SVC_Check_WO_Labor smallint
0

SVC_Check_Call_Back tinyint
0

SVC_Service_Type char(11)
''

SVC_Directory char(99)
''

SVC_Return_Price_Level char(11)
''

SVC_Transfer_Option smallint
0

SVC_Service_Batch_ID char(15)
''

SVC_Service_Document_ID char(15)
''

SVC_Contract_Batch_ID char(15)
''

SVC_Contract_Document_ID char(15)
''

SVC_Use_Return tinyint
0

SVC_Dup_Serial smallint
0

SVC_Auto_SOP_Contract tinyint
0

SVC_Contract_Warranty tinyint
0

SVC_Create_Serial tinyint
0

SVC_Vendor_Warranty_Flag smallint
0

SVC_Seller_Warranty_Flag smallint
0

SVC_Create_POP_Serial tinyint
0

SVC_ItemDelta tinyint
0

SVC_Allow_Contract_0_SOP tinyint
0

SVC_Allow_Service_0_SOP tinyint
0

SVC_C_Credit_Batch_ID char(15)
''

SVC_C_Credit_Document_ID char(15)
''

SVC_S_Credit_Batch_ID char(15)
''

SVC_S_Credit_Document_ID char(15)
''

SVC_Zero_Batch_ID char(15)
''

SVC_Zero_Document_ID char(15)
''

SVC_Auto_Credit_Receipt tinyint
0

SVC_Auto_Replace_Receipt tinyint
0

SVC_RMA_Invoice_Batch_ID char(15)
''

SVC_RMA_Credit_Batch_ID char(15)
''

SVC_RMA_Order_Batch_ID char(15)
''

Call_To char(3)
''
Field Type...(more) Join Now
Call_From char(3)
''
Field Type...(more) Join Now
priorityLevel smallint
0
Field Type...(more) Join Now
SVC_User_Define_Prompt16 char(15)
''

SVC_User_Define_Prompt17 char(15)
''

SVC_User_Define_Prompt18 char(15)
''

SVC_User_Define_Prompt19 char(15)
''

SVC_User_Define_Prompt20 char(15)
''

SVC_Auto_XShip_Receipt tinyint
0

SVC_Use_Payable tinyint
0

SVC_PrePaid_Override tinyint
0

SVC_DistHistory_Contract tinyint
0

SVC_DistHistory_RMA tinyint
0

SVC_DistHistory_RTV tinyint
0

SVC_DistHistory_Service tinyint
0

SVC_DistHistory_Transfer tinyint
0

SVC_DistHistory_Work_Ord tinyint
0

SVC_Use_Same_Number tinyint
0
Field Type...(more) Join Now
SVC_InStock_Customer char(15)
''

SVC_InStock_Status char(11)
''

SVC_Create_Non_Serial_Eq tinyint
0

SVC_Allow_RMA_0_SOP tinyint
0

SVC_Use_Return_Price_Lev tinyint
0

SVC_Supersession_Enabled tinyint
0

AUTOREN tinyint
0
Field Type...(more) Join Now
SVC_Days_to_Renew smallint
0

MXINCPCT numeric(19,5)
0.00
Field Type...(more) Join Now
PCTCRYFWD numeric(19,5)
0.00
Field Type...(more) Join Now
SVC_Remove_Price_Overrid tinyint
0

RENPRCSCHD char(11)
''
Field Type...(more) Join Now
CNSOLDTD tinyint
0

svcDonotCombinePM tinyint
0

svcContractPMOnly tinyint
0

svcAutoMoveHistory tinyint
0

svcAllowNonInventoried tinyint
0

svcUsePayRate tinyint
0

svcUsePayroll smallint
0

svcDefaultWorkType_1 char(11)
''

svcDefaultWorkType_2 char(11)
''

svcDefaultWorkType_3 char(11)
''

svcDefaultWorkType_4 char(11)
''

svcDefaultWorkType_5 char(11)
''

svcBillingExchangeRate smallint
0

DEX_ROW_ID int
auto number (1,1)
 Unique ide...(more) Join Now
svcRevenueExchangeRate smallint
0

svcConsolidateSOPOrder tinyint
0

svcCreateMAEquipment tinyint
0

svcCreateMANonSerialEq tinyint
0

Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
Archives | Table Listing | eConnect Error Database | eConnect Schema | Gold Star Locksmith
3