Module List > Module SVC tables SVC30683
You are currently viewing the COMPANY database.
Change

COMPANY..SVC30683 Table Definition

(COMPANY..svcContractLineCoveragePeriodHIST)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
CONSTS smallint
0
Field Type...(more) Join Now
CONTNBR char(11)
''
Field Type...(more) Join Now
SVC_Contract_Version smallint
0
Field Type...(more) Join Now
LNSEQNBR numeric(19,5)
0
Line SEQ N...(more) Join Now
svcCoveragePeriodStart2_1 datetime
'1/1/1900'

svcCoveragePeriodStart2_2 datetime
'1/1/1900'

svcCoveragePeriodStart2_3 datetime
'1/1/1900'

svcCoveragePeriodStart2_4 datetime
'1/1/1900'

svcCoveragePeriodStart2_5 datetime
'1/1/1900'

svcCoveragePeriodStart2_6 datetime
'1/1/1900'

svcCoveragePeriodStart2_7 datetime
'1/1/1900'

svcCoveragePeriodEnd2_1 datetime
'1/1/1900'

svcCoveragePeriodEnd2_2 datetime
'1/1/1900'

svcCoveragePeriodEnd2_3 datetime
'1/1/1900'

svcCoveragePeriodEnd2_4 datetime
'1/1/1900'

svcCoveragePeriodEnd2_5 datetime
'1/1/1900'

svcCoveragePeriodEnd2_6 datetime
'1/1/1900'

svcCoveragePeriodEnd2_7 datetime
'1/1/1900'

svcCoveragePeriodStart3_1 datetime
'1/1/1900'

svcCoveragePeriodStart3_2 datetime
'1/1/1900'

svcCoveragePeriodStart3_3 datetime
'1/1/1900'

svcCoveragePeriodStart3_4 datetime
'1/1/1900'

svcCoveragePeriodStart3_5 datetime
'1/1/1900'

svcCoveragePeriodStart3_6 datetime
'1/1/1900'

svcCoveragePeriodStart3_7 datetime
'1/1/1900'

svcCoveragePeriodEnd3_1 datetime
'1/1/1900'

svcCoveragePeriodEnd3_2 datetime
'1/1/1900'

svcCoveragePeriodEnd3_3 datetime
'1/1/1900'

svcCoveragePeriodEnd3_4 datetime
'1/1/1900'

svcCoveragePeriodEnd3_5 datetime
'1/1/1900'

svcCoveragePeriodEnd3_6 datetime
'1/1/1900'

svcCoveragePeriodEnd3_7 datetime
'1/1/1900'

svcCoveragePeriodStart4_1 datetime
'1/1/1900'

svcCoveragePeriodStart4_2 datetime
'1/1/1900'

svcCoveragePeriodStart4_3 datetime
'1/1/1900'

svcCoveragePeriodStart4_4 datetime
'1/1/1900'

svcCoveragePeriodStart4_5 datetime
'1/1/1900'

svcCoveragePeriodStart4_6 datetime
'1/1/1900'

svcCoveragePeriodStart4_7 datetime
'1/1/1900'

svcCoveragePeriodEnd4_1 datetime
'1/1/1900'

svcCoveragePeriodEnd4_2 datetime
'1/1/1900'

svcCoveragePeriodEnd4_3 datetime
'1/1/1900'

svcCoveragePeriodEnd4_4 datetime
'1/1/1900'

svcCoveragePeriodEnd4_5 datetime
'1/1/1900'

svcCoveragePeriodEnd4_6 datetime
'1/1/1900'

svcCoveragePeriodEnd4_7 datetime
'1/1/1900'

DEX_ROW_ID int
auto number (1,1)
Unique ide...(more) Join Now
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3