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 SVC00602
You are currently viewing the COMPANY database.
Change

COMPANY..SVC00602 Table Definition

(COMPANY..SVC_Codes_Contract_Type)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value		 Source
CNTTYPE char(11)
''
Field Type...(more) Join Now
CNTTYPDESC char(31)
''

SRVTYPE char(11)
''
Field Type...(more) Join Now
GL_Prepaid_Account int
0

GL_Service_Account int
0

ITEMNMBR char(31)
''
Field Type...(more) Join Now
join ... more text available
USECVPD_1 tinyint
0
Field Type...(more) Join Now
USECVPD_2 tinyint
0
Field Type...(more) Join Now
USECVPD_3 tinyint
0
Field Type...(more) Join Now
USECVPD_4 tinyint
0
Field Type...(more) Join Now
USECVPD_5 tinyint
0
Field Type...(more) Join Now
USECVPD_6 tinyint
0
Field Type...(more) Join Now
USECVPD_7 tinyint
0
Field Type...(more) Join Now
Contract_Coverage_Period_1 datetime
'1/1/1900'
Field Type...(more) Join Now
Contract_Coverage_Period_2 datetime
'1/1/1900'
Field Type...(more) Join Now
Contract_Coverage_Period_3 datetime
'1/1/1900'
Field Type...(more) Join Now
Contract_Coverage_Period_4 datetime
'1/1/1900'
Field Type...(more) Join Now
Contract_Coverage_Period_5 datetime
'1/1/1900'
Field Type...(more) Join Now
Contract_Coverage_Period_6 datetime
'1/1/1900'
Field Type...(more) Join Now
Contract_Coverage_Period_7 datetime
'1/1/1900'
Field Type...(more) Join Now
CNTCOVPD_1 datetime
'1/1/1900'
Field Type...(more) Join Now
CNTCOVPD_2 datetime
'1/1/1900'
Field Type...(more) Join Now
CNTCOVPD_3 datetime
'1/1/1900'
Field Type...(more) Join Now
CNTCOVPD_4 datetime
'1/1/1900'
Field Type...(more) Join Now
CNTCOVPD_5 datetime
'1/1/1900'
Field Type...(more) Join Now
CNTCOVPD_6 datetime
'1/1/1900'
Field Type...(more) Join Now
CNTCOVPD_7 datetime
'1/1/1900'
Field Type...(more) Join Now
Grace_Days smallint
0

Meter_Bases_1 int
0
Field Type...(more) Join Now
Meter_Bases_2 int
0
Field Type...(more) Join Now
Meter_Bases_3 int
0
Field Type...(more) Join Now
Meter_Bases_4 int
0
Field Type...(more) Join Now
Meter_Bases_5 int
0
Field Type...(more) Join Now
Meter_Overages_1 int
0
Field Type...(more) Join Now
Meter_Overages_2 int
0
Field Type...(more) Join Now
Meter_Overages_3 int
0
Field Type...(more) Join Now
Meter_Overages_4 int
0
Field Type...(more) Join Now
Meter_Overages_5 int
0
Field Type...(more) Join Now
Meter_Overages_6 int
0
Field Type...(more) Join Now
Meter_Overages_7 int
0
Field Type...(more) Join Now
Meter_Overages_8 int
0
Field Type...(more) Join Now
Meter_Overages_9 int
0
Field Type...(more) Join Now
Meter_Overages_10 int
0
Field Type...(more) Join Now
Meter_Overages_11 int
0
Field Type...(more) Join Now
Meter_Overages_12 int
0
Field Type...(more) Join Now
Meter_Overages_13 int
0
Field Type...(more) Join Now
Meter_Overages_14 int
0
Field Type...(more) Join Now
Meter_Overages_15 int
0
Field Type...(more) Join Now
Meter_Overages_16 int
0
Field Type...(more) Join Now
Meter_Overages_17 int
0
Field Type...(more) Join Now
Meter_Overages_18 int
0
Field Type...(more) Join Now
Meter_Overages_19 int
0
Field Type...(more) Join Now
Meter_Overages_20 int
0
Field Type...(more) Join Now
Meter_Charges_1 numeric(19,5)
0.00
Field Type...(more) Join Now
Meter_Charges_2 numeric(19,5)
0.00
Field Type...(more) Join Now
Meter_Charges_3 numeric(19,5)
0.00
Field Type...(more) Join Now
Meter_Charges_4 numeric(19,5)
0.00
Field Type...(more) Join Now
Meter_Charges_5 numeric(19,5)
0.00
Field Type...(more) Join Now
Meter_Charges_6 numeric(19,5)
0.00
Field Type...(more) Join Now
Meter_Charges_7 numeric(19,5)
0.00
Field Type...(more) Join Now
Meter_Charges_8 numeric(19,5)
0.00
Field Type...(more) Join Now
Meter_Charges_9 numeric(19,5)
0.00
Field Type...(more) Join Now
Meter_Charges_10 numeric(19,5)
0.00
Field Type...(more) Join Now
Meter_Charges_11 numeric(19,5)
0.00
Field Type...(more) Join Now
Meter_Charges_12 numeric(19,5)
0.00
Field Type...(more) Join Now
Meter_Charges_13 numeric(19,5)
0.00
Field Type...(more) Join Now
Meter_Charges_14 numeric(19,5)
0.00
Field Type...(more) Join Now
Meter_Charges_15 numeric(19,5)
0.00
Field Type...(more) Join Now
Meter_Charges_16 numeric(19,5)
0.00
Field Type...(more) Join Now
Meter_Charges_17 numeric(19,5)
0.00
Field Type...(more) Join Now
Meter_Charges_18 numeric(19,5)
0.00
Field Type...(more) Join Now
Meter_Charges_19 numeric(19,5)
0.00
Field Type...(more) Join Now
Meter_Charges_20 numeric(19,5)
0.00
Field Type...(more) Join Now
Meter_Expires_1 tinyint
0
Field Type...(more) Join Now
Meter_Expires_2 tinyint
0
Field Type...(more) Join Now
Meter_Expires_3 tinyint
0
Field Type...(more) Join Now
Meter_Expires_4 tinyint
0
Field Type...(more) Join Now
Meter_Expires_5 tinyint
0
Field Type...(more) Join Now
SVC_Invoice_Detail tinyint
0
Field Type...(more) Join Now
PREPAID tinyint
0
Field Type...(more) Join Now
SVC_Contract_Batch_ID char(15)
''

SVC_Contract_Document_ID char(15)
''

Contract_Response_Time char(7)
''
Field Type...(more) Join Now
SVC_Discount_Flag tinyint
0

SVC_Discount_Account int
0

SVC_C_Credit_Batch_ID char(15)
''

SVC_C_Credit_Document_ID char(15)
''

priorityLevel smallint
0
Field Type...(more) Join Now
svcBillingExchangeRate smallint
0

DEX_ROW_ID int
auto number (1,1)
 Unique ide...(more) Join Now
svcRevenueExchangeRate smallint
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