Module List > Module RM tables RM00700
You are currently viewing the COMPANY database.
Change

COMPANY..RM00700 Table Definition

(COMPANY..RM Report Options)
Powers the Customer Email Options form off the Customer Maintenance form
4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
AGNGDTKN smallint
0

RANGEBY smallint
0

PRTDBRCD tinyint
0

PRPSTJCB tinyint
0

PRSBDRCB tinyint
0

ENDDOCDT datetime
'1/1/1900'
Field Type...(more) Join Now SVC00670.ENDDOCDT
FILEXPNM char(255)
''

FINRPTNM char(31)
''

ASKECHTM tinyint
0

INCLGNDS tinyint
0

IFFILXST smallint
0

EXPTTYPE smallint
0

PRNTNOTS tinyint
0

CSTSRTBY smallint
0

PRNTOFIL tinyint
0

PRTOPRTR tinyint
0

PRTOSCRN tinyint
0

PRNTTYPE smallint
0

RPTGRIND smallint
0

RTGRSBIN numeric(19,5)
0.00

RTPACHIN smallint
0

SORTBY smallint
0

ENFULNAM char(41)
''

ENDADDCT char(61)
''

ENDCLSID char(15)
''

ENCUSTID char(15)
''

ENCSTNAM char(65)
''

ENDPHON1 char(21)
''

ENSLSTER char(15)
''

ENSPSNID char(15)
''

ENDSHNAM char(15)
''

ENDSTATE char(29)
''

ENUSRDF1 char(21)
''

ENDZIPCD char(11)
''

ENDINGDT datetime
'1/1/1900'

ENCLDSCR char(31)
''

ENLSTNAM char(21)
''

ENDVENDR char(15)
''

ENDEMPLY char(15)
''

ENDCITY char(35)
''

ENDOCNUM char(21)
''

ENDOCTYP smallint
0

ENDPEROD smallint
0

ENDPSTDT datetime
'1/1/1900'

ENDBNMBR char(15)
''

ENBCHSRC char(15)
''

ENTRXSRC char(13)
''

ENRMTKDT smallint
0

ENSLSAMT numeric(19,5)
0.00

ENPRMRGN numeric(19,5)
0.00

STRTFLNM char(41)
''

STRMTKDT smallint
0

STADDCTT char(61)
''

STTCLSID char(15)
''

STCUSTID char(15)
''

STCUSTNM char(65)
''

STRTDATE datetime
'1/1/1900'
Start Date...(more) Join Now UPR00100.STRTDATE
STRTNGDT datetime
'1/1/1900'

STTPHON1 char(21)
''

STSLSTER char(15)
''

STSPRSID char(15)
''

STTSHNAM char(15)
''

STTSTATE char(29)
''

STTUDEF1 char(21)
''

STRTZPCD char(11)
''

STCLSDSC char(31)
''

STTLSTNM char(21)
''

STRTVNDR char(15)
''

STRTEMPL char(15)
''

STRTCITY char(35)
''

STMTCYCL smallint
0
Statement ...(more) Join Now RM00101.STMTCYCL
ENSTCYCL smallint
0

STDOCNUM char(21)
''

STTDOCTP smallint
0

STTDOCDT datetime
'1/1/1900'
Field Type...(more) Join Now SVC00670.STTDOCDT
STPERIOD smallint
0

STTPSTDT datetime
'1/1/1900'

STBCHNUM char(15)
''

STBCHSRC char(15)
''

STRXSRC char(13)
''

STPRMRGN numeric(19,5)
0.00

STSLSAMT numeric(19,5)
0.00

INACTIVE tinyint
0
1 if inact...(more) Join Now
BALNCTYP smallint
0
Balance Ty...(more) Join Now RM00101.BALNCTYP
ACTIVE tinyint
0
p>Active:&...(more) Join Now GL00100.ACTIVE
HISTTYPE smallint
0
History Ty...(more) Join Now PM00202.HISTTYPE
TRANTOPR tinyint
0

PRNTDTLD tinyint
0

CUTOFDAT datetime
'1/1/1900'

CRBLNCCB tinyint
0

FLLYPDCB tinyint
0

NOACTVCB tinyint
0

ZROBALCB tinyint
0

PASTDUCB tinyint
0

WHICHRPT smallint
0

PERTYPGB smallint
0

YEAR1 smallint
0
The fiscal...(more) Join Now
STTACNUM_1 char(5)
''

STTACNUM_2 char(5)
''

STTACNUM_3 char(5)
''

STTACNUM_4 char(5)
''

STTACNUM_5 char(5)
''

STTACNUM_6 char
''

EACCNBR_1 char(5)
''

EACCNBR_2 char(5)
''

STTACNUM_7 char
''

STTACNUM_8 char
''

EACCNBR_3 char(5)
''

EACCNBR_4 char(5)
''

STTACNUM_9 char
''

STTACNUM_10 char
''

EACCNBR_5 char(5)
''

SEGMNTRG smallint
0

ENITMNBR char(31)
''

ENDSERLT char(21)
''

STTITNUM char(31)
''

STRTSRLT char(21)
''

EACCNBR_6 char
''

TRXTYPE smallint
0
Transactio...(more) Join Now GL10000.TRXTYPE
EACCNBR_7 char
''

INCLTXDT tinyint
0

INCLPYMT tinyint
0

EACCNBR_8 char
''

EACCNBR_9 char
''

STQUOEXD datetime
'1/1/1900'

EACCNBR_10 char
''

EDQUOEXD datetime
'1/1/1900'

STREQDAT datetime
'1/1/1900'

ENDREQDT datetime
'1/1/1900'

STTLOCCD char(11)
''

ENLOCNCD char(11)
''

STMSTNMB int
0

EDMASNMB int
0

STPRHDID char(15)
''

ENPRHDID char(15)
''

STTDOCID char(15)
''

ENDDOCID char(15)
''

STSOPTYP smallint
0

EDSOPTYP smallint
0

DISCOMP tinyint
0

DISPRCHD tinyint
0

DISSRLOT tinyint
0

DISUSRDF tinyint
0

EXCCOMP tinyint
0

EXCFULFIL tinyint
0

INCMCINF tinyint
0

RPTXRATE numeric(19,7)
0.00
Reporting ...(more) Join Now MC40000.RPTXRATE
RPRTCLMD smallint
0
Reporting ...(more) Join Now MC40000.RPRTCLMD
PRTCURIN smallint
0

CONNAACT tinyint
0

DateSensitivitySumSelect smallint
0

SummaryYear 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
3