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

COMPANY..RM50105 Table Definition

(COMPANY..rmEmailStmtsHDRTemp)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
DSCRIPTN char
''

STMNTID char
''

CUSTNMBR char
''
Customer N...(more) Join Now PA01101.CUSTNMBR
join ... more text available
STMTNAME char
''

CURNCYID char
''
Currency I...(more) Join Now
join ... more text available
CURRNIDX smallint
0
Currency I...(more) Join Now
join ... more text available
CNTCPRSN char
''
Contact Pe...(more) Join Now PA01101.CNTCPRSN
ADDRESS1 char
''

ADDRESS2 char
''

ADDRESS3 char
''

PHONE1 char
''

PHONE2 char
''

PHONE3 char
''

CITY char
''

STATE char
''

ZIP char
''

DATE1 datetime
'1/1/1900'

MINPYDUE numeric
0.00

CUSTMSGS_1 char
''

CUSTMSGS_2 char
''

CUSTMSGS_3 char
''

AMNTDUE numeric
0.00

STMTMSGS_1 char
''

STMTMSGS_2 char
''

STMTMSGS_3 char
''

STMTMSGS_4 char
''

STMTMSGS_5 char
''

STMTMSGS_6 char
''

STMTMSGS_7 char
''

STMTMSGS_8 char
''

STMTMSGS_9 char
''

STMTMSGS_10 char
''

STMTMSGS_11 char
''

STMTMSGS_12 char
''

STMTMSGS_13 char
''

STMTMSGS_14 char
''

STMTMSGS_15 char
''

DOCARABR_1 char
''

DOCARABR_2 char
''

DOCARABR_3 char
''

DOCARABR_4 char
''

DOCARABR_5 char
''

DOCARABR_6 char
''

DOCARABR_7 char
''

DOCARABR_8 char
''

DOCARABR_9 char
''

DOCARDSC_1 char
''

DOCARDSC_2 char
''

DOCARDSC_3 char
''

DOCARDSC_4 char
''

DOCARDSC_5 char
''

DOCARDSC_6 char
''

DOCARDSC_7 char
''

DOCARDSC_8 char
''

DOCARDSC_9 char
''

AGPERAMT_1 numeric
0.00

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

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

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

AGPERDSC_1 char
''

AGPERDSC_2 char
''

AGPERDSC_3 char
''

AGPERDSC_4 char
''

AGPERDSC_5 char
''

AGPERDSC_6 char
''

AGPERDSC_7 char
''

CMPANYID smallint
0
Company ID...(more) Join Now WPPU0114.CMPANYID
join ... more text available
LOCATNID char
''
Location I...(more) Join Now PA01101.LOCATNID
join ... more text available
PYMTRMID char
''
Payment Te...(more) Join Now
SY033... more text available
CUSTBLNC numeric
0.00
Current Cu...(more) Join Now B3910505.CUSTBLNC
DEPRECV numeric
0.00

RNNMBR int
0

PRNTSTUS smallint
0

USERID char
''
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