PA33302 - PA Rev Recognition Budget DTL HIST File | Prospr

PA33302 - PA Rev Recognition Budget DTL HIST File

Query Builder

Select * from PA33302

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
PADocnumber20	PA Document No.	String	18	View
PADOCDT	PA Document Date	Date	4	View
CUSTNMBR	Customer Number	String	16	View
CUTOFDAT	Cutoff Date	Date	4	View
PAPROJNUMBER	PA Project Number	String	16	View
PAprojname	PA Project Name	String	32	View
PAAcctgMethod	PA Accounting Method	Integer	2	View
PASTAT	PA Status 1 = Open 2 = On Hold 3 = Closed 4 = Estimate 5 = Completed	Integer	2	View
PACOSTCATID	PA Cost Category ID	String	16	View
PACBRecogRev	PA Recognize Revenue CB	Boolean	2	View
PATU	PA Transaction Usage 1 = Timesheet 2 = Equipment Log 3 = Miscellaneous Log 4 = Purchases/Material 5 = Employee Expense	Integer	2	View
PAFTotalCost	PA Forecast Total Cost	Currency	10	View
PAFQuantity	PA Forecast Quantity	Currency	10	View
PAFBillings	PA Forecast Billings	Currency	10	View
PAPostCost	PA Actual Cost	Currency	10	View
PAPostedQtySTDN	PA Actual Qty STD	Currency	10	View
PAPercentCompleted	PA Percent Completed	Currency	10	View
PAREB	PA Revenue Earned-Budget	Currency	10	View
PA_Cost_of_Earnings	PA Cost of Earnings	Currency	10	View
PABRecognizedBudgAmount	PA Recognized Budget Amount	Currency	10	View
PABIEEAMOUNT	PA BIEE Amount	Currency	10	View
PAEIEBAMOUNT	PA EIEB Amount	Currency	10	View
PAPostedBillingsN	PA Actual Billings	Currency	10	View
PA_Trade_Discount_Amount	PA Trade Discount Amount	Currency	10	View
PACGBWIPIDX	PA WIP IDX	Long Integer	4	View
PABBillingsIDX	PA Billings IDX	Long Integer	4	View
PABExpenseIDX	PA Expense IDX	Long Integer	4	View
PABLossIDX	PA Loss IDX	Long Integer	4	View
PARev_IDX	PA Revenue IDX	Long Integer	4	View
PABEIEBIDX	PA EIEB IDX	Long Integer	4	View
PABBIEEIDX	PA BIEE IDX	Long Integer	4	View
PACGBRRSublineErrorsB	PA RR Subline Errors-Budget	Long Integer	4	View
NOTEINDX	Note Index	Currency	10	View
PA_ActualCost__LossTest	PA ActualCost - LossTest	Currency	10	View
PA_ProjAmt__LossTest	PA ProjAmt - LossTest	Currency	10	View
PA_ActualRecogRev__LossT	PA ActualRecogRev - LossTest	Currency	10	View
PA_ActualBlgs__XcessTest	PA ActualBlgs - XcessTest	Currency	10	View
PA_Earnings__XcessTest	PA Earnings - XcessTest	Currency	10	View
PAPostRecogRevN	PA Actual Recognized Revenue	Currency	10	View
PALossAmount	PA Loss Amount	Currency	10	View
PAPrevRecognizedRev	PA Prev Recognized Revenue	Currency	10	View
PAPrevBIEEAmount	PA Prev BIEE Amount	Currency	10	View
PAPrevEIEBAmount	PA Prev EIEB Amount	Currency	10	View
PAPrevEarnings	PA Prev Earnings	Currency	10	View
PAPrevLossAmount	PA Prev Loss Amount	Currency	10	View
PAPrevBillings	PA Prev Billings	Currency	10	View
PAPrevCost	PA Prev Cost	Currency	10	View

PA33302 - PA Rev Recognition Budget DTL HIST File

Query Builder

Customer Service

Information

My Account

Contact Us