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

COMPANY..SVC06001 Table Definition

(COMPANY..Depot Station ID Codes)

4Penny.net

Field Definitions:

What is the 'source' column?

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

DSCRIPTN char(31)
''
Field Type...(more) Join Now
LOCNCODE char(11)
''
Field Type...(more) Join Now
join ... more text available
ITEMNMBR char(31)
''
Field Type...(more) Join Now
join ... more text available
WORKDYS_1 tinyint
0
Field Type...(more) Join Now
WORKDYS_2 tinyint
0
Field Type...(more) Join Now
WORKDYS_3 tinyint
0
Field Type...(more) Join Now
WORKDYS_4 tinyint
0
Field Type...(more) Join Now
WORKDYS_5 tinyint
0
Field Type...(more) Join Now
WORKDYS_6 tinyint
0
Field Type...(more) Join Now
WORKDYS_7 tinyint
0
Field Type...(more) Join Now
WORKSTRT_1 datetime
'1/1/1900'
Field Type...(more) Join Now
WORKSTRT_2 datetime
'1/1/1900'
Field Type...(more) Join Now
WORKSTRT_3 datetime
'1/1/1900'
Field Type...(more) Join Now
WORKSTRT_4 datetime
'1/1/1900'
Field Type...(more) Join Now
WORKSTRT_5 datetime
'1/1/1900'
Field Type...(more) Join Now
WORKSTRT_6 datetime
'1/1/1900'
Field Type...(more) Join Now
WORKSTRT_7 datetime
'1/1/1900'
Field Type...(more) Join Now
WORKEND_1 datetime
'1/1/1900'
Field Type...(more) Join Now
WORKEND_2 datetime
'1/1/1900'
Field Type...(more) Join Now
WORKEND_3 datetime
'1/1/1900'
Field Type...(more) Join Now
WORKEND_4 datetime
'1/1/1900'
Field Type...(more) Join Now
WORKEND_5 datetime
'1/1/1900'
Field Type...(more) Join Now
WORKEND_6 datetime
'1/1/1900'
Field Type...(more) Join Now
WORKEND_7 datetime
'1/1/1900'
Field Type...(more) Join Now
PRETIME smallint
0

POSTTIME smallint
0

svcPostToPayroll tinyint
0

PAYRCORD char(7)
''
Pay Record...(more) Join Now UPR40600.PAYRCORD
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