Module List >
Module PA tables
PT00101
You are currently viewing the COMPANY
database.
Change
|
COMPANY..PT00101 Table Definition
(COMPANY..Project Costing Master)
Field Definitions:
What is the 'source' column?
| 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
|
|
|
|
|