PA33303 - PA Rev Recognition Fee DTL HIST File | Prospr

PA33303 - PA Rev Recognition Fee DTL HIST File

Query Builder

Select * from PA33303

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
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
PAFeeID	PA Fee ID	String	16	View
PAFeeType	PA Fee Type	Integer	2	View
PAFeeAmount	PA Fee Amount	Currency	10	View
PAPercentCompleted	PA Percent Completed	Currency	10	View
PAREF	PA Revenue Earned-Fee	Currency	10	View
PA_Cost_of_Earnings	PA Cost of Earnings	Currency	10	View
PARecognizedFeeAmount	PA Recognized Fee Amount	Currency	10	View
PACBRecogRev	PA Recognize Revenue CB	Boolean	2	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
PA_Sales_IDX	PA Sales IDX	Long Integer	4	View
PAAR_IDX	PA AR IDX	Long Integer	4	View
PA_Deferred_RevIDX	PA Deferred Rev IDX	Long Integer	4	View
PACGBWIPIDX	PA WIP IDX	Long Integer	4	View
PABBillingsIDX	PA Billings IDX	Long Integer	4	View
PARev_IDX	PA Revenue IDX	Long Integer	4	View
PA_Retention_AR	PA Retention AR IDX	Long Integer	4	View
PA_RR_Subline_ErrorsFee	PA RR Subline Errors-Fee	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
PABBIEEIDX	PA BIEE IDX	Long Integer	4	View
PABEIEBIDX	PA EIEB IDX	Long Integer	4	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
PAPrevBillings	PA Prev Billings	Currency	10	View

PA33303 - PA Rev Recognition Fee DTL HIST File

Query Builder

Customer Service

Information

My Account

Contact Us