Module List >
Module PA tables
PA23500
You are currently viewing the COMPANY
database.
Change
|
COMPANY..PA23500 Table Definition
(COMPANY..PA Change Order Fee Header OPEN)
Field Definitions:
What is the 'source' column?
| PACONTNUMBER |
char(11)
''
|
PA Contrac...(more) Join Now
|
|
|
|
| PACHGORDNO |
char(17)
''
|
PA Change ...(more) Join Now
|
|
|
|
| PAPROJNUMBER |
char(15)
''
|
PA Project...(more) Join Now
|
|
|
join ... more text available
|
| PALineItemSeq |
int
0
|
PA Line It...(more) Join Now
|
|
|
|
| PAVARTOTFEEAMT |
numeric(19,5)
0.00
|
|
|
|
|
| PAsequencenumber |
smallint
0
|
|
|
|
|
| PAbegindate |
datetime
'1/1/1900'
|
PA Begin D...(more) Join Now
|
|
|
|
| PAEnDate |
datetime
'1/1/1900'
|
PA End Dat...(more) Join Now
|
|
|
|
| PATOTPRJFEEAMT |
numeric(19,5)
0.00
|
|
|
|
|
| PATOTRETNFEEAMT |
numeric(19,5)
0.00
|
|
|
|
|
| PATOTRETNTNAMT |
numeric(19,5)
0.00
|
|
|
|
|
| PATOTSRVCFEEAMT |
numeric(19,5)
0.00
|
|
|
|
|
| PAClose_CB |
tinyint
0
|
|
|
|
|
| PAVARPRJFEEAMT |
numeric(19,5)
0.00
|
|
|
|
|
| PAVARRETFEEAMT |
numeric(19,5)
0.00
|
|
|
|
|
| PAVARETNFEEAMT |
numeric(19,5)
0.00
|
|
|
|
|
| PAVARSERVFEEAMT |
numeric(19,5)
0.00
|
|
|
|
|
| PAPosted_Project_Fee |
numeric(19,5)
0.00
|
PA Actual ...(more) Join Now
|
|
|
|
| PAPosted_Retainer_Fee |
numeric(19,5)
0.00
|
PA Actual ...(more) Join Now
|
|
|
|
| PAPOSTRETAMT |
numeric(19,5)
0.00
|
PA Actual ...(more) Join Now
|
|
|
|
| PAPosted_Service_Fee |
numeric(19,5)
0.00
|
PA Actual ...(more) Join Now
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|
|