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

COMPANY..SVC06300 Table Definition

(COMPANY..Depot Schedule)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
STATIONID char(11)
''

SEQUENCE1 numeric(19,5)
0.00

Queue_Status char(3)
''

WORECTYPE smallint
0
1 - Quoteb...(more) Join Now
WORKORDNUM char(11)
''

Route_Sequence numeric(19,5)
0.00

SVC_Depot_Priority numeric(19,5)
0.00

Status smallint
0
p>Field Ty...(more) Join Now
TECHID char(11)
''
Field Type...(more) Join Now
ETTR numeric(19,5)
0.00
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'

ACTSTRTDTE datetime
'1/1/1900'

ACTSTRTTME datetime
'1/1/1900'

LSTSTAID char(11)
''

Last_Sequence numeric(19,5)
0.00

NXTSTATID char(11)
''

NXTSEQ numeric(19,5)
0.00

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