Module List >
Module SVC tables
SVC30604
You are currently viewing the COMPANY
database.
Change
|
COMPANY..SVC30604 Table Definition
(COMPANY..SVC_Contract_Line_Revenue_HIST)
Field Definitions:
What is the 'source' column?
| 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
|
|
|
|
|