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

COMPANY..PAM10602 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
SEQNUMBR int
0
Sequence N...(more) Join Now SEE30303.SEQNUMBR
PERMORIG char
''

PERMSTAT char
''

CUSTNMBR char
''
Customer c...(more) Join Now
CUSTNAME char
''

TOTALFEE numeric
0.00

PLACENAM char
''

STRTDATE datetime
'1/1/1900'
Start Date...(more) Join Now
Consultant_ID char
''

SLPRSNFN char
''

SPRSNSLN char
''

Office_ID char
''

SBU char
''

MKDTOPST tinyint
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