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

COMPANY..SVC30200 Table Definition

(COMPANY..Service Call Master History)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
CALLNBR char(11)
''
Field Type...(more) Join Now
SRVRECTYPE smallint
0
Field Type...(more) Join Now
SRVSTAT char(3)
''
Field Type...(more) Join Now
SRVTYPE char(11)
''
Field Type...(more) Join Now
SVCDESCR char(61)
''
Field Type...(more) Join Now
priorityLevel smallint
0
Field Type...(more) Join Now
CUSTNMBR char(15)
''
Field Type...(more) Join Now
join ... more text available
Customer_Reference char(21)
''
Field Type...(more) Join Now
ADRSCODE char(15)
''
Field Type...(more) Join Now
CUSTNAME char(65)
''
Field Type...(more) Join Now
ADDRESS1 char(61)
''
Field Type...(more) Join Now
ADDRESS2 char(61)
''
Field Type...(more) Join Now
CITY char(35)
''
Field Type...(more) Join Now
STATE char(29)
''
Field Type...(more) Join Now
ZIP char(11)
''
Field Type...(more) Join Now
CNTCPRSN char(61)
''
Field Type...(more) Join Now
PHONE1 char(21)
''
Field Type...(more) Join Now
OFFID char(11)
''
Field Type...(more) Join Now
SVCAREA char(11)
''
Field Type...(more) Join Now
TECHID char(11)
''
Field Type...(more) Join Now
TIMEZONE char(3)
''
Field Type...(more) Join Now
ENTDTE datetime
'1/1/1900'
Field Type...(more) Join Now
ENTTME datetime
'1/1/1900'
Field Type...(more) Join Now
Notify_Date datetime
'1/1/1900'
Field Type...(more) Join Now
Notify_Time 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
DISPDTE datetime
'1/1/1900'
Field Type...(more) Join Now
DISPTME datetime
'1/1/1900'
Field Type...(more) Join Now
ARRIVDTE datetime
'1/1/1900'
Field Type...(more) Join Now
ARRIVTME datetime
'1/1/1900'
Field Type...(more) Join Now
COMPDTE datetime
'1/1/1900'
Field Type...(more) Join Now
COMPTME datetime
'1/1/1900'
Field Type...(more) Join Now
Response_Date datetime
'1/1/1900'
Field Type...(more) Join Now
Response_Time datetime
'1/1/1900'
Field Type...(more) Join Now
PRICELVL char(15)
''
Field Type...(more) Join Now
PYMTRMID char(21)
''
Payment Te...(more) Join Now
SY033... more text available
SLPRSNID char(15)
''
Field Type...(more) Join Now
join ... more text available
LABSTOTPRC numeric(19,5)
0.00
Field Type...(more) Join Now
LABPCT numeric(19,5)
0.00
Field Type...(more) Join Now
LABSTOTCST numeric(19,5)
0.00
Field Type...(more) Join Now
PARSTOTPRC numeric(19,5)
0.00
Field Type...(more) Join Now
PARTPCT numeric(19,5)
0.00
Field Type...(more) Join Now
PARSTOTCST numeric(19,5)
0.00
Field Type...(more) Join Now
MSCSTOTPRC numeric(19,5)
0.00
Field Type...(more) Join Now
MISCPCT numeric(19,5)
0.00
Field Type...(more) Join Now
MISSTOTCST numeric(19,5)
0.00
Field Type...(more) Join Now
TAXSCHID char(15)
''

join ... more text available
TAXEXMT1 char(25)
''
Field Type...(more) Join Now
TAXEXMT2 char(25)
''
Field Type...(more) Join Now
PRETAXTOT numeric(19,5)
0.00
Field Type...(more) Join Now
TAXAMNT numeric(19,5)
0.00
Field Type...(more) Join Now
TOTAL numeric(19,5)
0.00
Field Type...(more) Join Now
Invoiced_Amount numeric(19,5)
0.00
Field Type...(more) Join Now
METER1 int
0
Field Type...(more) Join Now
METER2 int
0
Field Type...(more) Join Now
METER3 int
0
Field Type...(more) Join Now
PORDNMBR char(21)
''
Field Type...(more) Join Now
NOTEINDX numeric(19,5)
0.00
Note Index...(more) Join Now
join ... more text available
NOTFYFLAG tinyint
0
Field Type...(more) Join Now
USERDEF1 char(21)
''
Field Type...(more) Join Now
USERDEF2 char(21)
''
Field Type...(more) Join Now
USRDEF03 char(21)
''
Field Type...(more) Join Now
USRDEF04 char(21)
''
Field Type...(more) Join Now
USRDEF05 char(21)
''
Field Type...(more) Join Now
MSTRRECTYPE smallint
0
Field Type...(more) Join Now
MSTRCALLNBR char(11)
''
Field Type...(more) Join Now
ESCDATE datetime
'1/1/1900'
Field Type...(more) Join Now
ESCTIME datetime
'1/1/1900'
Field Type...(more) Join Now
Escalation_Level int
0
Field Type...(more) Join Now
SPLTTERMS char(11)
''
Field Type...(more) Join Now
Callback tinyint
0
Field Type...(more) Join Now
PROJCTID char(15)
''
Field Type...(more) Join Now
ProjectRef1_1 char(15)
''
Field Type...(more) Join Now
ProjectRef1_2 char(15)
''
Field Type...(more) Join Now
ProjectRef1_3 char(15)
''
Field Type...(more) Join Now
ProjectRef1_4 char(15)
''
Field Type...(more) Join Now
CONSTS smallint
0
Field Type...(more) Join Now
CONTNBR char(11)
''
Field Type...(more) Join Now
SVC_Contract_Line_SEQ numeric(19,5)
0.00
Field Type...(more) Join Now
ETTR numeric(19,5)
0.00
Field Type...(more) Join Now
SVC_On_Hold tinyint
0
Field Type...(more) Join Now
Print_to_Web tinyint
0
Field Type...(more) Join Now
Meters_1 int
0
Field Type...(more) Join Now
Meters_2 int
0
Field Type...(more) Join Now
Meters_3 int
0
Field Type...(more) Join Now
Meters_4 int
0
Field Type...(more) Join Now
Meters_5 int
0
Field Type...(more) Join Now
Meter_Internal_Uses_1 int
0
Field Type...(more) Join Now
Meter_Internal_Uses_2 int
0
Field Type...(more) Join Now
Meter_Internal_Uses_3 int
0
Field Type...(more) Join Now
Meter_Internal_Uses_4 int
0
Field Type...(more) Join Now
Meter_Internal_Uses_5 int
0
Field Type...(more) Join Now
Bill_To_Customer char(15)
''
Field Type...(more) Join Now
CURNCYID char(15)
''
Field Type...(more) Join Now
join ... more text available
SVC_Bill_To_Address_Code char(15)
''
Field Type...(more) Join Now
CURRNIDX smallint
0
Field Type...(more) Join Now
join ... more text available
RATETPID char(15)
''
Field Type...(more) Join Now
EXGTBLID char(15)
''
Field Type...(more) Join Now
XCHGRATE numeric(19,7)
0.00
Field Type...(more) Join Now
EXCHDATE datetime
'1/1/1900'
Field Type...(more) Join Now
DECPLACS smallint
0
Field Type...(more) Join Now
TIME1 datetime
'1/1/1900'
Field Type...(more) Join Now
RATECALC smallint
0
Field Type...(more) Join Now
VIEWMODE smallint
0
Field Type...(more) Join Now
ISMCTRX smallint
0
Field Type...(more) Join Now
EXPNDATE datetime
'1/1/1900'
Field Type...(more) Join Now
DENXRATE numeric(19,7)
0.00
Field Type...(more) Join Now
MCTRXSTT smallint
0
Field Type...(more) Join Now
ORIGMISSTOTCST numeric(19,5)
0.00
Field Type...(more) Join Now
ORIGMSCSTOTPRC numeric(19,5)
0.00
Field Type...(more) Join Now
ORIGLABSUBTOTCOST numeric(19,5)
0.00
Field Type...(more) Join Now
ORIGLABSTOTPRC numeric(19,5)
0.00
Field Type...(more) Join Now
ORIGPARSTOTCST numeric(19,5)
0.00
Field Type...(more) Join Now
ORIGPARSTOTPRC numeric(19,5)
0.00
Field Type...(more) Join Now
ORIGPRETAXTOT numeric(19,5)
0.00
Field Type...(more) Join Now
ORTAXAMT numeric(19,5)
0.00
Field Type...(more) Join Now
ORIGTOTAL numeric(19,5)
0.00
Field Type...(more) Join Now
Orig_Invoiced_Amount numeric(19,5)
0.00
Field Type...(more) Join Now
ADDRESS3 char(61)
''
Field Type...(more) Join Now
COUNTRY char(61)
''
Field Type...(more) Join Now
SVC_Pre600 tinyint
0
Field Type...(more) Join Now
SVC_FO_ID char(51)
''
Field Type...(more) Join Now
Replaces_1 tinyint
0
Field Type...(more) Join Now
Replaces_2 tinyint
0
Field Type...(more) Join Now
Replaces_3 tinyint
0
Field Type...(more) Join Now
Replaces_4 tinyint
0
Field Type...(more) Join Now
Replaces_5 tinyint
0
Field Type...(more) Join Now
Workflow_Approval_Status smallint
0
Time: Time...(more) Join Now
Workflow_Priority smallint
0
Workflow A...(more) Join Now SY00500.Workflow_Priority
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