Module List > Module PAM tables PAM30001
You are currently viewing the COMPANY database.
Change

COMPANY..PAM30001 Table Definition

(COMPANY..)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
USERID char
''
The user t...(more) Join Now WRS10001.USERID
RMDTYPAL smallint
0
RM Documen...(more) Join Now RVLPD013.RMDTYPAL
DOCNUMBR char
''
Document N...(more) Join Now RVLPD029.DOCNUMBR
BTCHID char
''

SEQNUMBR int
0
Sequence N...(more) Join Now SEE30303.SEQNUMBR
HOLD tinyint
0

VCHRNMBR char
''
Voucher Nu...(more) Join Now PP100101.VCHRNMBR
APPLDAMT numeric
0.00

JOBNUMBR char
''
Job Number...(more) Join Now SF010601.JOBNUMBR
TEMPID char
''

OTOTALFE numeric
0.00

ORIGINALAMOUNT numeric
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