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

COMPANY..RVLPD009 Table Definition

(COMPANY..Sales Payment Document OPEN)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
RMDTYPAL smallint
0
RM Documen...(more) Join Now
DOCNUMBR char(21)
''
Document N...(more) Join Now
CUSTNMBR char(15)
''
Customer N...(more) Join Now POP10100.CUSTNMBR
join ... more text available
CUSTNAME char(65)
''

STMTNAME char(65)
''

PMTDOCID char(15)
''

CHEKNMBR char(21)
''

PDOCSTRM 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)
''

CMRecordNumber numeric(19,5)
0.00

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