Module List >
Module PA tables
PA11906
You are currently viewing the COMPANY
database.
Change
|
COMPANY..PA11906 Table Definition
(COMPANY..PA Project Closing History Fee)
Field Definitions:
What is the 'source' column?
| PA_Proj_Closing_Sequence |
int
0
|
|
|
|
|
| PALineItemSeq |
int
0
|
PA Line It...(more) Join Now
|
|
|
|
| JRNENTRY |
int
0
|
|
|
|
|
| PACONTNUMBER |
char(11)
''
|
PA Contrac...(more) Join Now
|
|
|
|
| PAPROJNUMBER |
char(15)
''
|
PA Project...(more) Join Now
|
|
|
join ... more text available
|
| PAFeeID |
char(15)
''
|
PA Fee ID ...(more) Join Now
|
|
|
|
| PAFeeType |
smallint
0
|
In additio...(more) Join Now
|
|
|
|
| PAFeeAmount |
numeric(19,5)
0.00
|
PA Fee Amo...(more) Join Now
|
|
|
|
| PACGBWIPIDX |
int
0
|
ACTIDX of ...(more) Join Now
|
|
|
|
| PABBillingsIDX |
int
0
|
|
|
|
|
| PARev_IDX |
int
0
|
|
|
|
|
| PABBIEEIDX |
int
0
|
|
|
|
|
| PABEIEBIDX |
int
0
|
|
|
|
|
| PAPostedBillingsN |
numeric(19,5)
0.00
|
|
|
|
|
| PAPostRecogRevN |
numeric(19,5)
0.00
|
PA Actual ...(more) Join Now
|
|
|
|
| PAPOSBIEEAMOUNT |
numeric(19,5)
0.00
|
PA Actual ...(more) Join Now
|
|
|
|
| PAPOSEIEBAMOUNT |
numeric(19,5)
0.00
|
PA Actual ...(more) Join Now
|
|
|
|
| PAPrevBillings |
numeric(19,5)
0.00
|
|
|
|
|
| PAPrevBIEEAmount |
numeric(19,5)
0.00
|
|
|
|
|
| PAPrevEIEBAmount |
numeric(19,5)
0.00
|
|
|
|
|
| PAPrevRecognizedRev |
numeric(19,5)
0.00
|
|
|
|
|
| PAPrevEarnings |
numeric(19,5)
0.00
|
|
|
|
|
| PAPosted_Earnings |
numeric(19,5)
0.00
|
PA Actual ...(more) Join Now
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|
|