PA70101 - PA Project Series Report Options | Prospr

PA70101 - PA Project Series Report Options

Query Builder

Select * from PA70101

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
RPTGRIND	Report Group Index	Integer	2	View
RTPACHIN	Report Palette Choice Index	Integer	2	View
RTGRSBIN	Report Group Sub Index	Currency	10	View
REPORTID	Report ID	Integer	2	View
RPTGRNMS	Report Group Names	String	22	View
ASKECHTM	Ask Each Time	Boolean	2	View
PRTOSCRN	Print to Screen	Boolean	2	View
PRTOPRTR	Print to Printer	Boolean	2	View
PRNTOFIL	Print to File	Boolean	2	View
EXPTTYPE	Export Type	Integer	2	View
FILEXPNM	File Export Name	String	256	View
IFFILXST	If File Existing	Integer	2	View
PRNTTYPE	Print Type	Integer	2	View
SORTBY	Sort By	Integer	2	View
RANGEBY	Range By	Integer	2	View
YEAR1	Year	Integer	2	View
PERIODID	Period ID	Integer	2	View
PATU	PA Transaction Usage 1 = Timesheet 2 = Equipment Log 3 = Miscellaneous Log 4 = Purchases/Material 5 = Employee Expense	Integer	2	View
PAReport_Include	PA Report Include	Integer	2	View
PARange_By_Array_1	PA Range By Array[1]	Boolean	2	View
PARange_By_Array_2	PA Range By Array[2]	Boolean	2	View
PARange_By_Array_3	PA Range By Array[3]	Boolean	2	View
PARange_By_Array_4	PA Range By Array[4]	Boolean	2	View
PARange_By_Array_5	PA Range By Array[5]	Boolean	2	View
PARange_By_Array_6	PA Range By Array[6]	Boolean	2	View
PARange_By_Array_7	PA Range By Array[7]	Boolean	2	View
PARange_By_Array_8	PA Range By Array[8]	Boolean	2	View
PARange_By_Array_9	PA Range By Array[9]	Boolean	2	View
PARange_By_Array_10	PA Range By Array[10]	Boolean	2	View
PAExclude_Array_1	PA Exclude Array[1]	Boolean	2	View
PAExclude_Array_2	PA Exclude Array[2]	Boolean	2	View
PAExclude_Array_3	PA Exclude Array[3]	Boolean	2	View
PAExclude_Array_4	PA Exclude Array[4]	Boolean	2	View
PAExclude_Array_5	PA Exclude Array[5]	Boolean	2	View
PAExclude_Array_6	PA Exclude Array[6]	Boolean	2	View
PAExclude_Array_7	PA Exclude Array[7]	Boolean	2	View
PAExclude_Array_8	PA Exclude Array[8]	Boolean	2	View
PAExclude_Array_9	PA Exclude Array[9]	Boolean	2	View
PAExclude_Array_10	PA Exclude Array[10]	Boolean	2	View
PA_Net_Write_Down_In_Exc	PA Net Write Down In Excess Of	Currency	10	View
DETLDRPT	Detailed Report	Boolean	2	View
MTHSLCTD	Month Selected	Integer	2	View
SUMDTTKN	Summary Date Token	Integer	2	View
SMRYDATE	Summary Date	Date	4	View
PACashBudgetSalesLevel	PA Cash Budget Sales Level	Integer	2	View
PACashBudgetPctgLevels_1	PA Cash Budget Percentage Levels[1]	Integer	2	View
PACashBudgetPctgLevels_2	PA Cash Budget Percentage Levels[2]	Integer	2	View
PACashBudgetPctgLevels_3	PA Cash Budget Percentage Levels[3]	Integer	2	View
PACashBudgetStartingCash	PA Cash Budget Starting Cash Position	Currency	10	View
PACashBudgetCashNeedsLev	PA Cash Budget Cash Needs Level	Currency	10	View
PRPSTJCB	Print Posting Journal CB	Boolean	2	View
PRTDBRCD	Print Detail Breakdown Reg CB	Boolean	2	View
PRSBDRCB	Print Summary Breakdown Reg CB	Boolean	2	View
STRTYEAR	Start Year	Integer	2	View
ENDYEAR	End Year	Integer	2	View
STBCHNUM	Start Batch Number	String	16	View
ENDBNMBR	End Batch Number	String	16	View
STDOCN	Start Doc No	Long Integer	4	View
ENDOCN	End Doc No	Long Integer	4	View
STTPRJCLID	Start Project Class ID	String	16	View
ENDPRJCLID	End Project Class ID	String	16	View
PASTPROJN	PA Start Project Number	String	16	View
PAENPROJN	PA End Project Number	String	16	View
STTPROJID	Start Project ID	String	16	View
ENDPROJID	End Project ID	String	16	View
StartProjectMgrID	Start Project Mgr ID	String	16	View
EndProjectMgrID	End Project Mgr ID	String	16	View
StartBusinessMgrID	Start Business Mgr ID	String	16	View
EndBusinessMgrID	End Business Mgr ID	String	16	View
STRTDEPT	Start Department	String	8	View
ENDDEPT	End Department	String	8	View
STTCNTRCLID	Start Contract Class ID	String	16	View
ENDCNTRCLID	End Contract Class ID	String	16	View
Start_Contract_Number	Start Contract Number	String	12	View
End_Contract_Number	End Contract Number	String	12	View
STTCONTRID	Start Contract ID	String	16	View
ENDCONTRID	End Contract ID	String	16	View
STSPRSID	Start Salesperson ID	String	16	View
ENSPSNID	End Salesperson ID	String	16	View
STDATEIN	Start Date Incurred	Date	4	View
ENDATEIN	End Date Incurred	Date	4	View
STREFDOC	Start Ref Doc No	Long Integer	4	View
ENREFDOC	End Ref Doc No	Long Integer	4	View
STDISTT	Start Dist Type	Integer	2	View
ENDISTT	End Dist Type	Integer	2	View
STACCNDX	Start Account Index	Long Integer	4	View
EDACCNDX	End Account Index	Long Integer	4	View
STRTNGDT	Starting Date	Date	4	View
ENDINGDT	Ending Date	Date	4	View
STTUDEF1	Start User Defined 1	String	22	View
ENUSRDF1	End User Defined 1	String	22	View
STTDOCDT	Start Document Date	Date	4	View
ENDDOCDT	End Document Date	Date	4	View
STTPSTDT	Start Post Date	Date	4	View
ENDPSTDT	End Post Date	Date	4	View
STRXSRC	Start TRX Source	String	14	View
ENTRXSRC	End TRX Source	String	14	View
STCUSTID	Start Customer ID	String	16	View
ENCUSTID	End Customer ID	String	16	View
STCUSTNM	Start Customer Name	String	66	View
ENCSTNAM	End Customer Name	String	66	View
PAStart_ID_Array_1	PA Start ID Array[1]	String	16	View
PAStart_ID_Array_2	PA Start ID Array[2]	String	16	View
PAStart_ID_Array_3	PA Start ID Array[3]	String	16	View
PAStart_ID_Array_4	PA Start ID Array[4]	String	16	View
PAStart_ID_Array_5	PA Start ID Array[5]	String	16	View
PAStart_ID_Array_6	PA Start ID Array[6]	String	16	View
PAStart_ID_Array_7	PA Start ID Array[7]	String	16	View
PAStart_ID_Array_8	PA Start ID Array[8]	String	16	View
PAStart_ID_Array_9	PA Start ID Array[9]	String	16	View
PAStart_ID_Array_10	PA Start ID Array[10]	String	16	View
PAEnd_ID_Array_1	PA End ID Array[1]	String	16	View
PAEnd_ID_Array_2	PA End ID Array[2]	String	16	View
PAEnd_ID_Array_3	PA End ID Array[3]	String	16	View
PAEnd_ID_Array_4	PA End ID Array[4]	String	16	View
PAEnd_ID_Array_5	PA End ID Array[5]	String	16	View
PAEnd_ID_Array_6	PA End ID Array[6]	String	16	View
PAEnd_ID_Array_7	PA End ID Array[7]	String	16	View
PAEnd_ID_Array_8	PA End ID Array[8]	String	16	View
PAEnd_ID_Array_9	PA End ID Array[9]	String	16	View
PAEnd_ID_Array_10	PA End ID Array[10]	String	16	View
PAStart_Name_Array_1	PA Start Name Array[1]	String	32	View
PAStart_Name_Array_2	PA Start Name Array[2]	String	32	View
PAStart_Name_Array_3	PA Start Name Array[3]	String	32	View
PAStart_Name_Array_4	PA Start Name Array[4]	String	32	View
PAStart_Name_Array_5	PA Start Name Array[5]	String	32	View
PAStart_Name_Array_6	PA Start Name Array[6]	String	32	View
PAStart_Name_Array_7	PA Start Name Array[7]	String	32	View
PAStart_Name_Array_8	PA Start Name Array[8]	String	32	View
PAStart_Name_Array_9	PA Start Name Array[9]	String	32	View
PAStart_Name_Array_10	PA Start Name Array[10]	String	32	View
PAEnd_Name_Array_1	PA End Name Array[1]	String	32	View
PAEnd_Name_Array_2	PA End Name Array[2]	String	32	View
PAEnd_Name_Array_3	PA End Name Array[3]	String	32	View
PAEnd_Name_Array_4	PA End Name Array[4]	String	32	View
PAEnd_Name_Array_5	PA End Name Array[5]	String	32	View
PAEnd_Name_Array_6	PA End Name Array[6]	String	32	View
PAEnd_Name_Array_7	PA End Name Array[7]	String	32	View
PAEnd_Name_Array_8	PA End Name Array[8]	String	32	View
PAEnd_Name_Array_9	PA End Name Array[9]	String	32	View
PAEnd_Name_Array_10	PA End Name Array[10]	String	32	View
PASTDOCT	PA Start Doc Type	Integer	2	View
PAENDOCT	PA End Doc Type	Integer	2	View
PAStart_PO_Number	PA Start PO Number	Long Integer	4	View
PAEnd_PO_Number	PA End PO Number	Long Integer	4	View
PAStart_TRX_Type	PA Start TRX Type	Integer	2	View
PAEnd_TRX_Type	PA End TRX Type	Integer	2	View
PRTCURIN	Print Currency In	Integer	2	View
RPTXRATE	Reporting Exchange Rate	Currency (Variable)	10	View
RPRTCLMD	Reporting Rate Calculation Method	Integer	2	View
INCLUDEHOLDPO	Include Hold PO	Boolean	2	View
INCLUDEHOLDPOONLY	Include Hold PO Only	Boolean	2	View
Include_New	Include New	Boolean	2	View
Include_Released	Include Released	Boolean	2	View
Include_Change_Order	Include Change Order	Boolean	2	View
Include_Received	Include Received	Boolean	2	View
Include_Closed	Include Closed	Boolean	2	View
Include_Canceled	Include Canceled	Boolean	2	View
INCRCPTS	Include Receipts	Boolean	2	View
ENDVNDID	End Vendor ID	String	16	View
ENDVNDNM	End Vendor Name	String	66	View
ENDPOSTA	End PO Status	Integer	2	View
EndPOPRcptNum	End POP Receipt Number	String	18	View
DISSRLOT	Display Serial/Lot Number	Boolean	2	View
ENITMNBR	End Item Number	String	32	View
End_Promised_Date	End Promised Date	Date	4	View
End_Required_Date	End Required Date	Date	4	View
ENDLOCID	End Location ID	String	16	View
ENRCTDT	End Receipt Date	Date	4	View
ENDBUYERID	End Buyer ID	String	16	View
ENDLINEORIGIN	End Line Origin	Integer	2	View
ENDRELEASEBYDATE	End Release By Date	Date	4	View
PAENDCOSTID	PA End Cost Category ID	String	16	View
ENAUCNCD	End Audit Control Code	String	14	View
Days_Overdue	Days Overdue	Boolean	2	View
DATEOVERDUE	Date Overdue	Date	4	View
COMPTYPE	Compare Type	Integer	2	View
POP_Date_Selection1	PA_Date_Selection	Integer	2	View
INCLFUNC	Include Functional Currency	Boolean	2	View
INCMCINF	Include Multicurrency Info	Boolean	2	View
STVNDRID	Start Vendor ID	String	16	View
STVNDNAM	Start Vendor Name	String	66	View
STRPOSTA	Start PO Status	Integer	2	View
STRPONUM	Start PO Number	String	18	View
StartPOPRcptNum	Start POP Receipt Number	String	18	View
ENDPONUM	End PO Number	String	18	View
STTITNUM	Start Item Number	String	32	View
Start_Promised_Date	Start Promised Date	Date	4	View
Start_Required_Date	Start Required Date	Date	4	View
STTLOCID	Start Location ID	String	16	View
STRCTDT	Start Receipt Date	Date	4	View
STARTBUYERID	Start Buyer ID	String	16	View
STARTLINEORIGIN	Start Line Origin	Integer	2	View
STARTRELEASEBYDATE	Start Release By Date	Date	4	View
PASTTCOSTID	PA Start Cost Category ID	String	16	View
STTACNCD	Start Audit Control Code	String	14	View

PA70101 - PA Project Series Report Options

Query Builder

Customer Service

Information

My Account

Contact Us