Module List >
Module PA tables
PA11905
You are currently viewing the COMPANY
database.
Change
|
COMPANY..PA11905 Table Definition
(COMPANY..PA Project Closing History Budget)
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
|
| PACOSTCATID |
char(15)
''
|
PA Cost Ca...(more) Join Now
|
|
|
|
| PATU |
smallint
0
|
PA Transac...(more) Join Now
|
|
|
|
| PAProfitType |
smallint
0
|
PA Profit ...(more) Join Now
|
|
|
|
| PACGBWIPIDX |
int
0
|
ACTIDX of ...(more) Join Now
|
|
|
|
| PABBillingsIDX |
int
0
|
|
|
|
|
| PABBIEEIDX |
int
0
|
|
|
|
|
| PABEIEBIDX |
int
0
|
|
|
|
|
| PABLossIDX |
int
0
|
|
|
|
|
| PAFBillings |
numeric(19,5)
0.00
|
PA Forecas...(more) Join Now
|
|
|
|
| PAFTotalCost |
numeric(19,5)
0.00
|
PA Forecas...(more) Join Now
|
|
|
|
| PAFQuantity |
numeric(19,5)
0.00
|
PA Forecas...(more) Join Now
|
|
|
|
| PAPostedQty |
numeric(19,5)
0.00
|
PA Actual ...(more) Join Now
|
|
|
|
| PAPostedTotalCostN |
numeric(19,5)
0.00
|
PA Actual ...(more) Join Now
|
|
|
|
| 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
|
|
|
|
| PAActualLossAmount |
numeric(19,5)
0.00
|
PA Actual ...(more) Join Now
|
|
|
|
| PAPrevCost |
numeric(19,5)
0.00
|
|
|
|
|
| PAPrevBIEEAmount |
numeric(19,5)
0.00
|
|
|
|
|
| PAPrevEIEBAmount |
numeric(19,5)
0.00
|
|
|
|
|
| PAPrevBillings |
numeric(19,5)
0.00
|
|
|
|
|
| PAPrevLossAmount |
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
|
|
|
|
|