Module List > Module RVLPD tables RVLPD025
You are currently viewing the COMPANY database.
Change

COMPANY..RVLPD025 Table Definition

(COMPANY..Purchasing Payment Document OPEN)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
VENDORID char(15)
''
Vendor ID ...(more) Join Now POP10100.VENDORID
join ... more text available
VENDNAME char(65)
''
Vendor Nam...(more) Join Now
DOCNUMBR char(21)
''
Document N...(more) Join Now
VNDCHKNM char(65)
''

DOCTYPE smallint
0
Document T...(more) Join Now
PMTDOCID char(15)
''

CHEKNMBR char(21)
''

PDOCSTPM smallint
0

CHEKBKID char(15)
''
Checkbook ID Checkbook this transaction affects SY30500.CHEKBKID
join ... more text available
DOCDATE datetime
'1/1/1900'
Document D...(more) Join Now IV10201.DOCDATE
DUEDATE datetime
'1/1/1900'
Due Date T...(more) Join Now POP10100.DUEDATE
DOCAMNT numeric(19,5)
0.00
Source Doc...(more) Join Now
ORDOCAMT numeric(19,5)
0.00
Orig Docum...(more) Join Now
CURNCYID char(15)
''
Currency I...(more) Join Now POP10100.CURNCYID
join ... more text available
CURRNIDX smallint
0
Currency I...(more) Join Now
join ... more text available
TRXDSCRN char(31)
''

NOTEINDX numeric(19,5)
0.00
Note Index...(more) Join Now
join ... more text available
VALSTRG1 char(65)
''

VALSTRG2 char(65)
''

VALSTRG3 char(65)
''

VALSTRG4 char(65)
''

VALSTRG5 char(65)
''

VALSTRG6 char(65)
''

VALDATE1 datetime
'1/1/1900'

VALDATE2 datetime
'1/1/1900'

VALCURR1 numeric(19,5)
0.00

VALCURR2 numeric(19,5)
0.00

VALBACT1 char(35)
''

VALBACT2 char(35)
''

TRXSORCE char(13)
''
Transactio...(more) Join Now
MKDBYUSR char(15)
''

MKTOPROC tinyint
0

REMTYPE smallint
0

REMITID char(15)
''

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