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

COMPANY..SVC00603 Table Definition

(COMPANY..SVC_Contract_Line_Invoice_Line)

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
SVC_Invoice_SEQ_Number int
0
Field Type...(more) Join Now
INVODATE datetime
'1/1/1900'
Field Type...(more) Join Now
DOCAMNT numeric(19,5)
0.00
Field Type...(more) Join Now
SVC_Coverage_Start_Date datetime
'1/1/1900'
Field Type...(more) Join Now
SVC_Coverage_End_Date datetime
'1/1/1900'
Field Type...(more) Join Now
POSTED tinyint
0
Field Type...(more) Join Now
POSTEDDT datetime
'1/1/1900'
Field Type...(more) Join Now
PSTDAMNT numeric(19,5)
0.00
Field Type...(more) Join Now
SVC_Invoice_Credit_Amoun numeric(19,5)
0.00
Field Type...(more) Join Now
SVC_Daily_Rate numeric(19,5)
0.00
Field Type...(more) Join Now
DSCDLRAM numeric(19,5)
0.00
Field Type...(more) Join Now
ORDOCAMT numeric(19,5)
0.00
Field Type...(more) Join Now
ORIGPSTDAMNT numeric(19,5)
0.00
Field Type...(more) Join Now
OrigInvCreditAmt numeric(19,5)
0.00
Field Type...(more) Join Now
ORDDLRAT numeric(19,5)
0.00
Field Type...(more) Join Now
SOPTYPE smallint
0
Field Type...(more) Join Now
SOPNUMBE char(21)
''
Field Type...(more) Join Now
svcReverseType smallint
0
N/A...(more) Join Now
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