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

COMPANY..RM40501 Table Definition

(COMPANY..RM Statements Options File)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
STMNTID char(15)
''

DSCRIPTN char(31)
''
Descriptio...(more) Join Now CM20300.DSCRIPTN
NOTEINDX numeric(19,5)
0.00
Note Index...(more) Join Now
join ... more text available
STMTFORM smallint
0

PRTCRLMT tinyint
0

PRTPYTRM tinyint
0

PRNTFNCH tinyint
0

PRNTMSGS tinyint
0

STMNTFOR binary(4)
0

RSTRACTY smallint
0

CUSTSORT smallint
0

DOCSORTS smallint
0

AGPERAMT_1 numeric(19,5)
0.00

AGPERAMT_2 numeric(19,5)
0.00
Array fiel...(more) Join Now B3910505.AGPERAMT_2
AGPERAMT_3 numeric(19,5)
0.00

AGPERAMT_4 numeric(19,5)
0.00
Array fiel...(more) Join Now B3910505.AGPERAMT_4
AGPERAMT_5 numeric(19,5)
0.00

AGPERAMT_6 numeric(19,5)
0.00
Array fiel...(more) Join Now B3910505.AGPERAMT_6
AGPERAMT_7 numeric(19,5)
0.00

STMTRSTR smallint
0

RSTRFRID char(15)
''

RSTRTOID char(15)
''

RSTRFNAM char(65)
''

RSTRTNAM char(65)
''

RSTRFCLS char(15)
''

RSTRTCLS char(15)
''

RSTRFRUD char(21)
''

RSTRTOUD char(21)
''

RSTFSPSN char(15)
''

RSTTSPSN char(15)
''

RSTRFTER char(15)
''

RSTTOTER char(15)
''

RSTRFZIP char(11)
''

RSTRTZIP char(11)
''

RSTFSTCY smallint
0

RSTTSTCY smallint
0

STMTLPTD datetime
'1/1/1900'

PRTDTTKN smallint
0

SUMDTTKN smallint
0

COFDTOKN smallint
0

STMTPRDT datetime
'1/1/1900'

SMRYDATE datetime
'1/1/1900'

CUTOFDAT datetime
'1/1/1900'

ASKECHTM tinyint
0

EXPTTYPE smallint
0

FILEXPNM char(255)
''

IFFILXST smallint
0

PRNTOFIL tinyint
0

PRTOPRTR tinyint
0

PRTOSCRN tinyint
0

LOCATNID char(15)
''
Location I...(more) Join Now UPR00100.LOCATNID
join ... more text available
INDCHLDSTMT tinyint
0

Email_Statements_Options smallint
0

Email_Statements_Form smallint
0

EmailStmtsSubjectLine char(131)
''

RDCOLDPDBYUNAPPLDCR tinyint
0

PrintRemainingDocs tinyint
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