DynDeveloper.com

DynDeveloper.com
Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now! Log In
Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our SOP scripts. All of our scripts for Dynamics GP can be found here
Module List > Module SVC tables SVC70500
You are currently viewing the COMPANY database.
Change

COMPANY..SVC70500 Table Definition

(COMPANY..Service Report Options)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value		 Source
PRTBYSIT smallint
0

PRNTOPTN smallint
0

STTGNDSC char(11)
''

ENGENDSC char(11)
''

ENUSRCAT_1 char(11)
''

ENUSRCAT_2 char(11)
''

ENUSRCAT_3 char(11)
''

ENUSRCAT_4 char(11)
''

ENUSRCAT_5 char(11)
''

ENUSRCAT_6 char(11)
''

STRTUCAT_1 char(11)
''

STRTUCAT_2 char(11)
''

STRTUCAT_3 char(11)
''

STRTUCAT_4 char(11)
''

STRTUCAT_5 char(11)
''

STRTUCAT_6 char(11)
''

CALLNBST char(11)
''

CALLNMEN char(11)
''

CONTNBRS char(11)
''

CONTNBRE char(11)
''

SRLNBRST char(21)
''

SRLNBREN char(21)
''

PMDTLIDS char(9)
''

PMDTLIDE char(9)
''

STCUSTID char(15)
''

ENCUSTID char(15)
''

STTECHID char(11)
''

ENTECHID char(11)
''

STOFFID char(11)
''

ENOFFID char(11)
''

SVCOPT1 char(15)
''

ENDSVCO1 char(15)
''

STSVCOP1 char(21)
''

ENSVCOP2 char(21)
''

STSVCOPT3 char(21)
''

ENSVCOP3 char(21)
''

STSVCOP4 char(31)
''

ENSVCOP4 char(31)
''

STSVCOP5 tinyint
0

ENSVCOP5 tinyint
0

STSVCOP6 char(11)
''

ENSVCOP6 char(11)
''

STSVCOP7 char(11)
''

ENSVCOP7 char(11)
''

STSVCOP8 char(21)
''

ENSVCOP8 char(21)
''

STSVCOP9 smallint
0

ENSVCOP9 smallint
0

STSVCO10 smallint
0

ENSVCO10 smallint
0

STTITNUM char(31)
''

ENITMNBR char(31)
''

SRVRECTYPE smallint
0
Field Type...(more) Join Now
CONSTS smallint
0
Field Type...(more) Join Now
PRVDRINF smallint
0

PRTDSCNT tinyint
0

PRTSVCHS tinyint
0

SVCRPTNM char(31)
''

PRNTNOTS tinyint
0

PRNTTYPE smallint
0

ASKECHTM tinyint
0

INCLGNDS tinyint
0

PRNTOFIL tinyint
0

PRTOPRTR tinyint
0

PRTOSCRN tinyint
0

IFFILXST smallint
0

FILEXPNM char(255)
''

EXPTTYPE smallint
0

RPTGRIND smallint
0

STTCLASS char(11)
''

ENDCLASS char(11)
''

STRTDSCR char(51)
''

ENDDESCR char(51)
''

STTSCHED char(11)
''

ENSCHDUL char(11)
''

STTLOCCD char(11)
''

ENLOCNCD char(11)
''

STTLOTTY char(11)
''

ENLOTTYP char(11)
''

STRTNGDT datetime
'1/1/1900'

ENDINGDT datetime
'1/1/1900'

ENDTKNDT smallint
0

STTOKNDT smallint
0

STRCTNUM char(21)
''

ENRCTNBR char(21)
''

RTPACHIN smallint
0

RTGRSBIN numeric(19,5)
0.00

SORTBY smallint
0

PRTSRLOT tinyint
0

INZROQTY tinyint
0

PRTITQTY tinyint
0

STTBINUM char(21)
''

ENBINNBR char(21)
''

STDOCNUM char(21)
''

ENDOCNUM char(21)
''

STDOCTYP smallint
0

ENDOCTYP smallint
0

STTMODUL char(3)
''

ENDMODUL char(3)
''

STRXSRC char(13)
''

ENTRXSRC char(13)
''

STBCHSRC char(15)
''

ENBCHSRC char(15)
''

STBCHNUM char(15)
''

ENDBNMBR char(15)
''

STVNDRID char(15)
''

ENDVNDID char(15)
''

INQTYREQ tinyint
0

INZRORLV tinyint
0

CALSGQTY smallint
0

RCPTOPTS smallint
0

VENDROPT smallint
0

SEGSRTBY smallint
0

SEGMNTRG smallint
0

Start_PriceLevel char(11)
''

End_PriceLevel char(11)
''

Start_RMA_Number char(15)
''

End_RMA_Number char(15)
''

Start_Required_Date datetime
'1/1/1900'

End_Required_Date datetime
'1/1/1900'

SVC_Print_Open tinyint
0

INCMCINF tinyint
0

PRTCURIN smallint
0

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
Archives | Table Listing | eConnect Error Database | eConnect Schema | Gold Star Locksmith
3