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

COMPANY..SVC30601 Table Definition

(COMPANY..SVC_Contract_Line_HIST)

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
LNSEQNBR numeric(19,5)
0
Line SEQ N...(more) Join Now
Contract_Transfer_Status smallint
0
Field Type...(more) Join Now
Contract_Transfer_Date datetime
'1/1/1900'
Field Type...(more) Join Now
CNTPRCOVR tinyint
0

NOTEINDX numeric(19,5)
0.00
Note Index...(more) Join Now
join ... more text available
ADRSCODE char(15)
''
Field Type...(more) Join Now
QUANTITY numeric(19,5)
0.00
Field Type...(more) Join Now
ITEMNMBR char(31)
''
Field Type...(more) Join Now
join ... more text available
CONFGREF char(21)
''

EQUIPID int
0
Field Type...(more) Join Now
SERLNMBR char(21)
''
Field Type...(more) Join Now
FRZEND datetime
'1/1/1900'
Field Type...(more) Join Now
FRXSTRT datetime
'1/1/1900'
Field Type...(more) Join Now
BLKTIM numeric(19,5)
0.00
Field Type...(more) Join Now
VALTIM numeric(19,5)
0.00
Field Type...(more) Join Now
DSCPCTAM smallint
0
Field Type...(more) Join Now
COMDLRAM numeric(19,5)
0.00
Field Type...(more) Join Now
COUNTRY char(61)
''
Field Type...(more) Join Now
PRCSTAT char(1)
''
Field Type...(more) Join Now
PORDNMBR char(21)
''
Field Type...(more) Join Now
DSCRIPTN char(31)
''
Field Type...(more) Join Now
PARTPCT numeric(19,5)
0.00
Field Type...(more) Join Now
LABPCT numeric(19,5)
0.00
Field Type...(more) Join Now
MISCPCT numeric(19,5)
0.00
Field Type...(more) Join Now
PMMSCPCT numeric(19,5)
0.00
Field Type...(more) Join Now
PMPRTPCT numeric(19,5)
0.00
Field Type...(more) Join Now
PMLABPCT numeric(19,5)
0.00
Field Type...(more) Join Now
VENDORID char(15)
''
Field Type...(more) Join Now
join ... more text available
RETNAGAM numeric(19,5)
0.00
Field Type...(more) Join Now
RTNBILLD numeric(19,5)
0.00
Field Type...(more) Join Now
SLPRSNID char(15)
''
Field Type...(more) Join Now
join ... more text available
COMMCODE char(15)
''
Field Type...(more) Join Now
COMPRCNT smallint
0
Field Type...(more) Join Now
BILSTRT datetime
'1/1/1900'
Field Type...(more) Join Now
BILEND datetime
'1/1/1900'
Field Type...(more) Join Now
BILLNGTH smallint
0
Field Type...(more) Join Now
BILPRD smallint
0
Field Type...(more) Join Now
FRSTBLDTE datetime
'1/1/1900'
Field Type...(more) Join Now
Last_Amount_Billed numeric(19,5)
0.00
Field Type...(more) Join Now
LSTBLDTE datetime
'1/1/1900'
Field Type...(more) Join Now
NBRCAL smallint
0
Field Type...(more) Join Now
TOTAL numeric(19,5)
0.00
Field Type...(more) Join Now
ACTCAL smallint
0
Field Type...(more) Join Now
TOTVALCAL numeric(19,5)
0.00
Field Type...(more) Join Now
CONTACT char(61)
''
Field Type...(more) Join Now
CURNCYID char(15)
''
Field Type...(more) Join Now
join ... more text available
NXTBLDTE datetime
'1/1/1900'
Field Type...(more) Join Now
CNTTYPE char(11)
''
Field Type...(more) Join Now
PRICSHED char(11)
''
Field Type...(more) Join Now
CUSTNMBR char(15)
''
Field Type...(more) Join Now
join ... more text available
ENTDTE datetime
'1/1/1900'
Field Type...(more) Join Now
MINBIL numeric(19,5)
0.00
Field Type...(more) Join Now
MAXBIL numeric(19,5)
0.00
Field Type...(more) Join Now
MAXBILL numeric(19,5)
0.00
Field Type...(more) Join Now
AUTOREN tinyint
0
Field Type...(more) Join Now
priorityLevel smallint
0
Field Type...(more) Join Now
MSTCNTRCT char(11)
''
Field Type...(more) Join Now
SRVTYPE char(11)
''
Field Type...(more) Join Now
BILFRRET tinyint
0
Field Type...(more) Join Now
TOTBIL numeric(19,5)
0.00
Field Type...(more) Join Now
PREPAID tinyint
0
Field Type...(more) Join Now
BILONDY smallint
0
Field Type...(more) Join Now
BILCYC smallint
0
Field Type...(more) Join Now
UOFM char(9)
''
Field Type...(more) Join Now
See I... more text available
BILSTAT smallint
0
Field Type...(more) Join Now
ENTTME datetime
'1/1/1900'
Field Type...(more) Join Now
STRTDATE datetime
'1/1/1900'
Field Type...(more) Join Now
ENDDATE 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
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
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
TAXSCHID char(15)
''

join ... more text available
CNFGLVL smallint
0

CNFGSEQ smallint
0

Contract_Length smallint
0
Field Type...(more) Join Now
Contract_Period smallint
0
Field Type...(more) Join Now
Invoiced_Amount numeric(19,5)
0.00
Field Type...(more) Join Now
Amount_To_Invoice numeric(19,5)
0.00
Field Type...(more) Join Now
Liabiltiy_Reduction tinyint
0
Field Type...(more) Join Now
Liability_Amount numeric(19,5)
0.00
Field Type...(more) Join Now
Total_Liability_Amount numeric(19,5)
0.00
Field Type...(more) Join Now
NUMOFINV int
0
Field Type...(more) Join Now
New_Invoice_Amount numeric(19,5)
0.00

Contract_Line_Status char(1)
''

Contract_Renewal_Contact char(31)
''
Field Type...(more) Join Now
Contract_Response_Time char(7)
''
Field Type...(more) Join Now
Liability_Months smallint
0
Field Type...(more) Join Now
Next_Liability_Date datetime
'1/1/1900'
Field Type...(more) Join Now
Last_Liability_Date datetime
'1/1/1900'
Field Type...(more) Join Now
Total_Liability_Billed numeric(19,5)
0.00
Field Type...(more) Join Now
TAXEXMT1 char(25)
''
Field Type...(more) Join Now
TAXEXMT2 char(25)
''
Field Type...(more) Join Now
Total_Unit numeric(19,5)
0.00
Field Type...(more) Join Now
UNITCOST numeric(19,5)
0.00
Field Type...(more) Join Now
Unit_Cost_Total numeric(19,5)
0.00

SVC_Liability_Type smallint
0
Field Type...(more) Join Now
SVC_Contract_Signed datetime
'1/1/1900'
Field Type...(more) Join Now
RETTYPE char(11)
''
Field Type...(more) Join Now
SVC_Monthly_Price numeric(19,5)
0.00

Location_Segment char(67)
''
Field Type...(more) Join Now
Bill_To_Customer char(15)
''
Field Type...(more) Join Now
SVC_Bill_To_Address_Code char(15)
''
Field Type...(more) Join Now
DSCDLRAM numeric(19,5)
0.00
Field Type...(more) Join Now
SVC_Invoiced_Discount numeric(19,5)
0.00

SVC_Discount_Recognized numeric(19,5)
0.00
Field Type...(more) Join Now
SVC_Discount_Remaining numeric(19,5)
0.00
Field Type...(more) Join Now
SVC_Discount_Next numeric(19,5)
0.00
Field Type...(more) Join Now
SVC_PM_Date smallint
0

SVC_PM_Day smallint
0

CURRNIDX smallint
0
Field Type...(more) Join Now
join ... more text available
RATETPID char(15)
''
Field Type...(more) Join Now
EXGTBLID char(15)
''
Field Type...(more) Join Now
XCHGRATE numeric(19,7)
0.00
Field Type...(more) Join Now
EXCHDATE datetime
'1/1/1900'
Field Type...(more) Join Now
DECPLACS smallint
0
Field Type...(more) Join Now
TIME1 datetime
'1/1/1900'
Field Type...(more) Join Now
RATECALC smallint
0
Field Type...(more) Join Now
VIEWMODE smallint
0
Field Type...(more) Join Now
ISMCTRX smallint
0
Field Type...(more) Join Now
EXPNDATE datetime
'1/1/1900'
Field Type...(more) Join Now
DENXRATE numeric(19,7)
0.00
Field Type...(more) Join Now
MCTRXSTT smallint
0
Field Type...(more) Join Now
ORIGVALTIM numeric(19,5)
0.00
Field Type...(more) Join Now
ORCOMAMT numeric(19,5)
0.00
Field Type...(more) Join Now
ORIGRETNAGAM numeric(19,5)
0.00
Field Type...(more) Join Now
ORIGRTNBILLD numeric(19,5)
0.00
Field Type...(more) Join Now
ORIGLASTAmountBilled numeric(19,5)
0.00
Field Type...(more) Join Now
ORIGTOTAL numeric(19,5)
0.00
Field Type...(more) Join Now
ORIGTOTVALCAL numeric(19,5)
0.00
Field Type...(more) Join Now
ORIGMINBIL numeric(19,5)
0.00
Field Type...(more) Join Now
ORIGMAXBIL numeric(19,5)
0.00
Field Type...(more) Join Now
Originating_Max_Billable numeric(19,5)
0.00
Field Type...(more) Join Now
ORIGTOTBIL numeric(19,5)
0.00
Field Type...(more) Join Now
Orig_Invoiced_Amount numeric(19,5)
0.00
Field Type...(more) Join Now
Orig_Amount_To_Invoice numeric(19,5)
0.00
Field Type...(more) Join Now
Orig_Liability_Amount numeric(19,5)
0.00
Field Type...(more) Join Now
OrigTotLiabilityAmount numeric(19,5)
0.00
Field Type...(more) Join Now
OrigTotLiabBilled numeric(19,5)
0.00
Field Type...(more) Join Now
Originating_Total_Unit numeric(19,5)
0.00
Field Type...(more) Join Now
ORUNTCST numeric(19,5)
0.00
Field Type...(more) Join Now
ORDDLRAT numeric(19,5)
0.00
Field Type...(more) Join Now
OrigDiscountReceived numeric(19,5)
0.00
Field Type...(more) Join Now
OrigDiscountRemaining numeric(19,5)
0.00
Field Type...(more) Join Now
OrigDiscountNext numeric(19,5)
0.00
Field Type...(more) Join Now
ORIGUNITCOSTTOTAL numeric(19,5)
0.00

ORIGMONTHPRICE numeric(19,5)
0.00

ORIGINVOICEDDISC numeric(19,5)
0.00

OrigNewInvoiceAmount numeric(19,5)
0.00

TAXAMNT numeric(19,5)
0.00
Field Type...(more) Join Now
ORTAXAMT numeric(19,5)
0.00
Field Type...(more) Join Now
SVC_FO_ID char(51)
''
Field Type...(more) Join Now
SVC_Contract_Version smallint
0
Field Type...(more) Join Now
MovedRevenue numeric(19,5)
0.00

OriginalTotal numeric(19,5)
0.00

OrigMovedRevenue numeric(19,5)
0.00

OrigOriginalTotal numeric(19,5)
0.00

Credit_Hold tinyint
0

DEX_ROW_ID int
auto number (1,1)
Unique ide...(more) Join Now
ITEMDESC char
''
Item Descr...(more) Join Now WO010116.ITEMDESC
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