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

COMPANY..SVC06105 Table Definition

(COMPANY..Depot Master Route)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
WORECTYPE smallint
0
1 - Quoteb...(more) Join Now
WORKORDNUM char(11)
''

Status smallint
0
p>Field Ty...(more) Join Now
SEQUENCE1 numeric(19,5)
0.00

DSCRIPTN char(31)
''
Field Type...(more) Join Now
DEPSTATGRP char(11)
''

STATIONID char(11)
''

TECHID char(11)
''
Field Type...(more) Join Now
ETTR numeric(19,5)
0.00
Field Type...(more) Join Now
ROUTEPROC char(11)
''

SERVICEBOM char(31)
''

STRTDATE datetime
'1/1/1900'
Field Type...(more) Join Now
STRTTIME datetime
'1/1/1900'
Field Type...(more) Join Now
ENDDATE datetime
'1/1/1900'
Field Type...(more) Join Now
ENDTIME datetime
'1/1/1900'
Field Type...(more) Join Now
ETADTE datetime
'1/1/1900'
Field Type...(more) Join Now
ETATME datetime
'1/1/1900'
Field Type...(more) Join Now
ECOMPDT datetime
'1/1/1900'

EComp_Time datetime
'1/1/1900'

NOTEINDX numeric(19,5)
0.00
Note Index...(more) Join Now
join ... more text available
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