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

COMPANY..PA33302 Table Definition

(COMPANY..PA Rev Recognition Budget DTL HIST File)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
PADocnumber20 char(17)
''

PADOCDT datetime
'1/1/1900'

CUSTNMBR char(15)
''
Customer c...(more) Join Now
join ... more text available
CUTOFDAT datetime
'1/1/1900'

PAPROJNUMBER char(15)
''
PA Project...(more) Join Now
join ... more text available
PAprojname char(31)
''

PAAcctgMethod smallint
0
Useful in ...(more) Join Now
PASTAT smallint
0
Contains t...(more) Join Now
PACOSTCATID char(15)
''
PA Cost Ca...(more) Join Now
PACBRecogRev tinyint
0

PATU smallint
0
PA Transac...(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
PAFBillings numeric(19,5)
0.00
PA Forecas...(more) Join Now
PAPostCost numeric(19,5)
0.00

PAPostedQtySTDN numeric(19,5)
0.00

PAPercentCompleted numeric(19,5)
0.00

PAREB numeric(19,5)
0.00

PA_Cost_of_Earnings numeric(19,5)
0.00
table styl...(more) Join Now
PABRecognizedBudgAmount numeric(19,5)
0.00

PABIEEAMOUNT numeric(19,5)
0.00

PAEIEBAMOUNT numeric(19,5)
0.00

PAPostedBillingsN numeric(19,5)
0.00

PA_Trade_Discount_Amount numeric(19,5)
0.00

PACGBWIPIDX int
0
ACTIDX of ...(more) Join Now
PABBillingsIDX int
0

PABExpenseIDX int
0

PABLossIDX int
0

PARev_IDX int
0

PABEIEBIDX int
0

PABBIEEIDX int
0

PACGBRRSublineErrorsB binary(4)
0

NOTEINDX numeric(19,5)
0.00
Note Index...(more) Join Now
join ... more text available
PA_ActualCost__LossTest numeric(19,5)
0.00

PA_ProjAmt__LossTest numeric(19,5)
0.00

PA_ActualRecogRev__LossT numeric(19,5)
0.00

PA_ActualBlgs__XcessTest numeric(19,5)
0.00

PA_Earnings__XcessTest numeric(19,5)
0.00

PAPostRecogRevN numeric(19,5)
0.00
PA Actual ...(more) Join Now
PALossAmount numeric(19,5)
0.00

PAPrevRecognizedRev numeric(19,5)
0.00

PAPrevBIEEAmount numeric(19,5)
0.00

PAPrevEIEBAmount numeric(19,5)
0.00

PAPrevEarnings numeric(19,5)
0.00

PAPrevLossAmount numeric(19,5)
0.00

PAPrevBillings numeric(19,5)
0.00

PAPrevCost numeric(19,5)
0.00

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