Module List >
Module SVC tables
SVC00675
You are currently viewing the COMPANY
database.
Change
|
COMPANY..SVC00675 Table Definition
(COMPANY..svcContractLineMoveWork)
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
|
|
|
|
| CNTTYPE |
char(11)
''
|
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
|
|
|
|
| ITEMNMBR |
char(31)
''
|
Field Type...(more) Join Now
|
|
|
join ... more text available
|
| SERLNMBR |
char(21)
''
|
Field Type...(more) Join Now
|
|
|
|
| EQUIPID |
int
0
|
Field Type...(more) Join Now
|
|
|
|
| DSCRIPTN |
char(31)
''
|
Field Type...(more) Join Now
|
|
|
|
| QUANTITY |
numeric(19,5)
0.00
|
Field Type...(more) Join Now
|
|
|
|
| Effective_Date |
datetime
'1/1/1900'
|
Effective ...(more) Join Now
|
BM00101.Effective_Date
|
|
|
| CMXFRNUM |
char(21)
''
|
|
|
|
|
| To_Customer_Number |
char(15)
''
|
|
|
|
|
| ADRSCODE |
char(15)
''
|
Field Type...(more) Join Now
|
|
|
|
| PRICSHED |
char(11)
''
|
Field Type...(more) Join Now
|
|
|
|
| CNTPRCOVR |
tinyint
0
|
|
|
|
|
| TOTAL |
numeric(19,5)
0.00
|
Field Type...(more) Join Now
|
|
|
|
| SVC_Monthly_Price |
numeric(19,5)
0.00
|
|
|
|
|
| DEDCAMNT_1 |
numeric(19,5)
0.00
|
Deduction ...(more) Join Now
|
UPR00500.DEDCAMNT_1
|
|
|
| DEDCAMNT_2 |
numeric(19,5)
0.00
|
|
|
|
|
| DEDCAMNT_3 |
numeric(19,5)
0.00
|
|
|
|
|
| DEDCAMNT_4 |
numeric(19,5)
0.00
|
|
|
|
|
| DEDCAMNT_5 |
numeric(19,5)
0.00
|
|
|
|
|
| RETNAGAM |
numeric(19,5)
0.00
|
Field Type...(more) Join Now
|
|
|
|
| RTNBILLD |
numeric(19,5)
0.00
|
Field Type...(more) Join Now
|
|
|
|
| NBRCAL |
smallint
0
|
Field Type...(more) Join Now
|
|
|
|
| ACTCAL |
smallint
0
|
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
|
|
|
|
| MKDTOPST |
tinyint
0
|
Field Type...(more) Join Now
|
|
|
|
| POSTDATE |
datetime
'1/1/1900'
|
Post Dateb...(more) Join Now
|
RM20101.POSTDATE
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|
|