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

COMPANY..SVC30604 Table Definition

(COMPANY..SVC_Contract_Line_Revenue_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
YEAR1 smallint
0
Field Type...(more) Join Now
PERIODID smallint
0
Field Type...(more) Join Now
LNITMSEQ int
0
Field Type...(more) Join Now
Status smallint
0
p>Field Ty...(more) Join Now
POSTEDDT datetime
'1/1/1900'
Field Type...(more) Join Now
Transaction_Date datetime
'1/1/1900'
Field Type...(more) Join Now
USERID char(15)
''
The user t...(more) Join Now
join ... more text available
PSTDAMNT numeric(19,5)
0.00
Field Type...(more) Join Now
Originating_PostedAmount numeric(19,5)
0.00
Field Type...(more) Join Now
Source_Trx_Document_Type char(3)
''
Field Type...(more) Join Now
SourceTrxDocumentNumber char(255)
''
Field Type...(more) Join Now
Transaction_Amount numeric(19,5)
0.00
Field Type...(more) Join Now
OrigTransactionAmount 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
SVC_Invoice_Credit_Amoun numeric(19,5)
0.00
Field Type...(more) Join Now
OrigInvCreditAmt numeric(19,5)
0.00
Field Type...(more) Join Now
DSCDLRAM numeric(19,5)
0.00
Field Type...(more) Join Now
ORDDLRAT numeric(19,5)
0.00
Field Type...(more) Join Now
Net_Transaction_Amount numeric(19,5)
0.00
Field Type...(more) Join Now
OrigNetTransactionAmount numeric(19,5)
0.00
Field Type...(more) Join Now
SVC_Contract_Version smallint
0
Field Type...(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