PA23302 - PA Rev Recognition Proj Detail WORK File | Prospr

PA23302 - PA Rev Recognition Proj Detail WORK File

Query Builder

Select * from PA23302

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
LNITMSEQ	Line Item Sequence	Long Integer	4	View
PADocnumber20	PA Document No.	String	18	View
CUSTNMBR	Customer Number	String	16	View
PACONTNUMBER	PA Contract Number	String	12	View
PADOCDT	PA Document Date	Date	4	View
CUTOFDAT	Cutoff Date	Date	4	View
PAPROJNUMBER	PA Project Number	String	16	View
PAprojname	PA Project Name	String	32	View
PASegmentCB	PA Segment CB	Boolean	2	View
PA_Combine_Mode	PA RR Combine Mode	Integer	2	View
PAProjectType	PA Project Type	Integer	2	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
PAPercentCompleted	PA Percent Completed	Currency	10	View
PAProject_Amount	PA Project Amount	Currency	10	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
PAPostedQty	PA Actual Qty	Currency	10	View
PA_Actual_CostContract	PA Actual Cost-Contract	Currency	10	View
PA_Actual_QtyContract	PA Actual Qty-Contract	Currency	10	View
PARevenueEarned	PA Revenue Earned	Currency	10	View
PAREB	PA Revenue Earned-Budget	Currency	10	View
PAREF	PA Revenue Earned-Fee	Currency	10	View
PA_Cost_of_Earnings	PA Cost of Earnings	Currency	10	View
PABRecognizedProjAmt	PA Recognized Project Amount	Currency	10	View
PABRecognizedBudgAmount	PA Recognized Budget Amount	Currency	10	View
PARecognizedFeeAmount	PA Recognized Fee Amount	Currency	10	View
PABIEEAMOUNT	PA BIEE Amount	Currency	10	View
PAEIEBAMOUNT	PA EIEB Amount	Currency	10	View
PARRLNEERR	PA RR Line Errors	Long Integer	4	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
PAPostedBillingsN	PA Actual Billings	Currency	10	View
PAPostRecogRevN	PA Actual Recognized Revenue	Currency	10	View
PALossAmount	PA Loss Amount	Currency	10	View
PAFQLaborOnly	PA Forecast Quantity - Labor Only	Currency	10	View
PAFTCLaborOnly	PA Forecast Total Cost - Labor Only	Currency	10	View
PAAQLaborOnly	PA Actual Qty - Labor Only	Currency	10	View
PAACLaborOnly	PA Actual Cost - Labor Only	Currency	10	View

PA23302 - PA Rev Recognition Proj Detail WORK File

Query Builder

Customer Service

Information

My Account

Contact Us