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

COMPANY..PAM20603 Table Definition

(COMPANY..)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
JOBNUMBR char
''
Job Number...(more) Join Now SF010601.JOBNUMBR
INVCNMBR char
''

INVCDDT datetime
'1/1/1900'

RMDTYPAL smallint
0
RM Documen...(more) Join Now RVLPD013.RMDTYPAL
Taxable_Amount numeric
0.00

TAXAMNT numeric
0.00
Tax Amount...(more) Join Now
ORTAXAMT numeric
0.00
Originatin...(more) Join Now PTE30501.ORTAXAMT
WS_Address char
''

USERID char
''
The user t...(more) Join Now WRS10001.USERID
ADDRESS1 char
''

ADDRESS2 char
''

ADDRESS3 char
''

CITY char
''

STATE char
''

ZIP char
''

POSITION_ID char
''

PAM_Latitude numeric
0.00

PAM_Longitude 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