Module List > Module PA tables PT00101
You are currently viewing the COMPANY database.
Change

COMPANY..PT00101 Table Definition

(COMPANY..Project Costing Master)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
PROJNAME char(21)
''

PROJDESC char(51)
''

PROJMGR char(31)
''

PROJTYPE char(31)
''

ESTSTARTDATE datetime
'1/1/1900'

ESTCOMPDATE datetime
'1/1/1900'

ACTSTARTDATE datetime
'1/1/1900'

ACTCOMPDATE datetime
'1/1/1900'

PROJSTATUS smallint
0

CLOSEDTOBILL tinyint
0

CLOSEDTOCOST tinyint
0

CUSTNMBR char(15)
''
Customer N...(more) Join Now RM20101.CUSTNMBR
join ... more text available
PRBTADCD char(15)
''
Primary Bi...(more) Join Now RM00101.PRBTADCD
join ... more text available
ADRSCODE char(15)
''
Address Co...(more) Join Now RM20101.ADRSCODE
ADDRESS1 char(61)
''
Address 1:...(more) Join Now RM00101.ADDRESS1
ADDRESS2 char(61)
''
Address 2:...(more) Join Now RM00101.ADDRESS2
CITY char(35)
''
City: City...(more) Join Now RM00101.CITY
STATE char(29)
''
State: Up...(more) Join Now RM00101.STATE
ZIP char(11)
''
Zip: Up t...(more) Join Now RM00101.ZIP
ESTPREFER smallint
0

ESTMATCOST numeric(19,5)
0.00

ESTLABORCOST numeric(19,5)
0.00

ESTMISCCOST numeric(19,5)
0.00

ESTMATREV numeric(19,5)
0.00

ESTLABORREV numeric(19,5)
0.00

ESTMISCREV numeric(19,5)
0.00

ACTMATCOST numeric(19,5)
0.00

ACTLABORCOST numeric(19,5)
0.00

ACTMISCCOST numeric(19,5)
0.00

ACTMATREV numeric(19,5)
0.00

ACTLABORREV numeric(19,5)
0.00

ACTMISCREV numeric(19,5)
0.00

USERDEF1 char(21)
''
UserDefine...(more) Join Now CM20200.USERDEF1
USERDEF2 char(21)
''
UserDefine...(more) Join Now CM20200.USERDEF2
CREATDDT datetime
'1/1/1900'
Created Da...(more) Join Now RM00101.CREATDDT
CRUSRID char(15)
''

MODIFDT datetime
'1/1/1900'
Date the r...(more) Join Now
MDFUSRID char(15)
''
User that ...(more) Join Now
join ... more text available
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