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

COMPANY..RM50104 Table Definition

(COMPANY..RM Email Statements Transactions Temporary F)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
CUSTNMBR char(15)
''
Customer I...(more) Join Now
join ... more text available
DSCRIPTN char(31)
''
Descriptio...(more) Join Now CM20300.DSCRIPTN
CURNCYID char(15)
''
Currency I...(more) Join Now
join ... more text available
CURRNIDX smallint
0
Currency I...(more) Join Now
join ... more text available
DOCDATE datetime
'1/1/1900'
The date a...(more) Join Now
DOCNUMBR char(21)
''
Document N...(more) Join Now
DOCPRFIX char(3)
''
Document P...(more) Join Now RM10301.DOCPRFIX
RMDTYPAL smallint
0
RM Documen...(more) Join Now
DOCDESCR char(31)
''
Document D...(more) Join Now RM10301.DOCDESCR
PORDNMBR char(21)
''
Purchase O...(more) Join Now PM10000.PORDNMBR
DOCAMNT numeric(19,5)
0.00
Source Doc...(more) Join Now PM10000.DOCAMNT
Credit_Amount_String_30 char(31)
''

DEBITAMT numeric(19,5)
0.00
Debit Amou...(more) Join Now GL10001.DEBITAMT
BALNCDUE numeric(19,5)
0.00

AGNGBUKT smallint
0

CRDTAMNT numeric(19,5)
0.00
Credit Amo...(more) Join Now GL10001.CRDTAMNT
CHCUMNUM char(15)
''

CHCUMNAM char(65)
''

CURTRXAM numeric(19,5)
0.00
Current Tr...(more) Join Now
AMNTPAID numeric(19,5)
0.00
Amount Pai...(more) Join Now SOP10103.AMNTPAID
RNNMBR int
0

SEQNUMBR int
0
Sequence N...(more) Join Now DTA10200.SEQNUMBR
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