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

COMPANY..PAM50600 Table Definition

(COMPANY..)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
CHEKNMBR char
''

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

SBU char
''

String5 char
''

ACCTSEG1 char
''

ACCTSEG2 char
''

INTERID char
''

ACTNUMST char
''

DEBITAMT numeric
0.00
Debit Amou...(more) Join Now WO010702.DEBITAMT
CRDTAMNT numeric
0.00
Credit Amo...(more) Join Now WO010702.CRDTAMNT
ACTINDX int
0
Account In...(more) Join Now WO010702.ACTINDX
DATE1 datetime
'1/1/1900'

USERID char
''
The user t...(more) Join Now WRS10001.USERID
BACHNUMB char
''
Batch Numb...(more) Join Now UPR10304.BACHNUMB
JRNENTRY int
0

ACTINDX2 int
0

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