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

COMPANY..PA11905 Table Definition

(COMPANY..PA Project Closing History Budget)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
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
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