Module List >
Module SVC tables
SVC00603
You are currently viewing the COMPANY
database.
Change
|
COMPANY..SVC00603 Table Definition
(COMPANY..SVC_Contract_Line_Invoice_Line)
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
|
|
|
|
| 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
|
|
|
|
|