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

COMPANY..RVLPD027 Table Definition

(COMPANY..Purchasing Payment Document Settlement Heade)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
REMTYPE smallint
0

REMITID char(15)
''

PMTDOCID char(15)
''

OrigPmntDocStatus smallint
0

ORICBOOK char(15)
''

DESCBOOK char(15)
''

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
MCSTRUCT_1 char(15)
''

MCSTRUCT_2 smallint
0

MCSTRUCT_3 char(15)
''

MCSTRUCT_4 char(15)
''

MCSTRUCT_5 numeric(19,7)
0.00

MCSTRUCT_6 datetime
'1/1/1900'

MCSTRUCT_7 smallint
0

MCSTRUCT_8 datetime
'1/1/1900'

MCSTRUCT_9 smallint
0

MCSTRUCT_10 smallint
0

MCSTRUCT_11 smallint
0

MCSTRUCT_12 datetime
'1/1/1900'

MCSTRUCT_13 numeric(19,7)
0.00

MCSTRUCT_14 smallint
0

TRXDATE datetime
'1/1/1900'

PSTGDATE datetime
'1/1/1900'

BANKACCT char(35)
''

COMMAMNT numeric(19,5)
0.00
Commission...(more) Join Now
ACTINDX int
0
Account In...(more) Join Now UPR40500.ACTINDX
join ... more text available
REMTSTAT smallint
0

NUMOFTRX int
0
Number Of ...(more) Join Now SOP30100.NUMOFTRX
FUNCTAMT numeric(19,5)
0.00

ORIGAMT numeric(19,5)
0.00

CMRecordNumber numeric(19,5)
0.00

NOTEINDX numeric(19,5)
0.00
Note Index...(more) Join Now
join ... more text available
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