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

COMPANY..RM50103 Table Definition

(COMPANY..RM Email Statements Header Temporary File)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
DSCRIPTN char(31)
''
Descriptio...(more) Join Now CM20300.DSCRIPTN
STMNTID char(15)
''

CUSTNMBR char(15)
''
Customer I...(more) Join Now
join ... more text available
STMTNAME char(65)
''
Statement ...(more) Join Now RM00101.STMTNAME
CURNCYID char(15)
''
Currency I...(more) Join Now
join ... more text available
CURRNIDX smallint
0
Currency I...(more) Join Now
join ... more text available
CNTCPRSN char(61)
''
Contact Pe...(more) Join Now RM00101.CNTCPRSN
ADDRESS1 char(61)
''
Address li...(more) Join Now
ADDRESS2 char(61)
''
Address li...(more) Join Now
ADDRESS3 char(61)
''
Address li...(more) Join Now
PHONE1 char(21)
''
10 digit p...(more) Join Now
PHONE2 char(21)
''
Phone 2: ...(more) Join Now RM00101.PHONE2
PHONE3 char(21)
''
Phone 3: ...(more) Join Now
CITY char(35)
''
City: City...(more) Join Now RM00101.CITY
STATE char(29)
''
4 characte...(more) Join Now
ZIP char(11)
''

DATE1 datetime
'1/1/1900'
Date: Date...(more) Join Now SY03900.DATE1
MINPYDUE numeric(19,5)
0.00

CUSTMSGS_1 char(41)
''

CUSTMSGS_2 char(41)
''

CUSTMSGS_3 char(41)
''

AMNTDUE numeric(19,5)
0.00

STMTMSGS_1 char(51)
''

STMTMSGS_2 char(51)
''

STMTMSGS_3 char(51)
''

STMTMSGS_4 char(51)
''

STMTMSGS_5 char(51)
''

STMTMSGS_6 char(51)
''

STMTMSGS_7 char(51)
''

STMTMSGS_8 char(51)
''

STMTMSGS_9 char(51)
''

STMTMSGS_10 char(51)
''

STMTMSGS_11 char(51)
''

STMTMSGS_12 char(51)
''

STMTMSGS_13 char(51)
''

STMTMSGS_14 char(51)
''

STMTMSGS_15 char(51)
''

DOCARABR_1 char(3)
''

DOCARABR_2 char(3)
''

DOCARABR_3 char(3)
''

DOCARABR_4 char(3)
''

DOCARABR_5 char(3)
''

DOCARABR_6 char(3)
''

DOCARABR_7 char(3)
''

DOCARABR_8 char(3)
''

DOCARABR_9 char(3)
''

DOCARDSC_1 char(21)
''

DOCARDSC_2 char(21)
''

DOCARDSC_3 char(21)
''

DOCARDSC_4 char(21)
''

DOCARDSC_5 char(21)
''

DOCARDSC_6 char(21)
''

DOCARDSC_7 char(21)
''

DOCARDSC_8 char(21)
''

DOCARDSC_9 char(21)
''

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

AGPERDSC_1 char(15)
''

AGPERDSC_2 char(15)
''

AGPERDSC_3 char(15)
''

AGPERDSC_4 char(15)
''

AGPERDSC_5 char(15)
''

AGPERDSC_6 char(15)
''

AGPERDSC_7 char(15)
''

CMPANYID smallint
0
Company ID...(more) Join Now POP10100.CMPANYID
join ... more text available
LOCATNID char(15)
''
Location I...(more) Join Now UPR00100.LOCATNID
join ... more text available
PYMTRMID char(21)
''
Payment Te...(more) Join Now
SY033... more text available
CUSTBLNC numeric(19,5)
0.00
Current Cu...(more) Join Now B3910505.CUSTBLNC
DEPRECV numeric(19,5)
0.00

RNNMBR int
0

PRNTSTUS smallint
0

USERID char(15)
''
The user t...(more) Join Now
join ... more text available
Process_Index int
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