Module List > Module PM tables PM80950
You are currently viewing the COMPANY database.
Change

COMPANY..PM80950 Table Definition

(COMPANY..PM Remittance Temp)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
BACHNUMB char(15)
''
Batch Numb...(more) Join Now
join ... more text available
BCHSOURC char(15)
''
Batch Sour...(more) Join Now
PMNTNMBR char(21)
''
Payment Nu...(more) Join Now CM20300.PMNTNMBR
SEQNUMBR int
0
Sequence N...(more) Join Now DTA10200.SEQNUMBR
DOCDATE datetime
'1/1/1900'
The date a...(more) Join Now
DOCNUMBR char(21)
''
Document N...(more) Join Now PM10000.DOCNUMBR
VENDORID char(15)
''
Vendor ID:...(more) Join Now
join ... more text available
VENDNAME char(65)
''
Vendor Nam...(more) Join Now POP10100.VENDNAME
VNDCHKNM char(65)
''
Vendor Che...(more) Join Now PM20000.VNDCHKNM
CURNCYID char(15)
''
Currency I...(more) Join Now
join ... more text available
VOIDED tinyint
0
Voided TRU...(more) Join Now CM20100.VOIDED
DOCTYPE smallint
0
Document T...(more) Join Now
CHKCOMNT char(61)
''

USERID char(15)
''
The user t...(more) Join Now
join ... more text available
SEPRMTNC tinyint
0
Separate R...(more) Join Now SY00500.SEPRMTNC
ERROR smallint
0

Email_Type smallint
0
1 – ...(more) Join Now RM00106.Email_Type
DOCAMNT numeric
0.00
Source Doc...(more) Join Now RVLPD026.DOCAMNT
DEX_ROW_ID int
auto number (1,1)
Unique ide...(more) Join Now
PYMTTYPE smallint
0
Payment Ty...(more) Join Now
Electronic tinyint
0

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