PP000060 - Deferral Report Options

Dynamics GP table PP000060 (Deferral Report Options) contains 113 columns including IFFILXST, FILEXPNM, EXPTTYPE....

SQL Query Builder

SELECT * FROM PP000060

113 Columns

Select all

Column	Description	Type	Length	Shared With
IFFILXST	If File Existing	Integer	2	-
FILEXPNM	File Export Name	String	256	-
EXPTTYPE	Export Type	Integer	2	-
ASKECHTM	Ask Each Time	Boolean	2	-
PRNTOFIL	Print to File	Boolean	2	-
PRTOPRTR	Print to Printer	Boolean	2	1 tables
PRTOSCRN	Print to Screen	Boolean	2	1 tables
PRNTTYPE	Print Type	Integer	2	-
RPTGRIND	Report Group Index	Integer	2	3 tables
RTPACHIN	Report Palette Choice Index	Integer	2	2 tables
RTGRSBIN	Report Group Sub Index	Currency	10	2 tables
REPORTID	Report ID	Integer	2	12 tables
FINRPTNM	Financial Report Name	String	32	-
STRTNGDT	Starting Date	Date	4	6 tables
ENDINGDT	Ending Date	Date	4	7 tables
STTSEGID	Start Segment ID	String	12	-
ENDSEGID	End Segment ID	String	12	-
STGENINT1	Start Generic Integer1	Integer	2	-
ENDGENINT1	End Generic Integer1	Integer	2	-
STDOCNUM	Start Document Number	String	22	-
ENDOCNUM	End Document Number	String	22	-
STRMTKDT	Start RM Token Date	Integer	2	-
ENRMTKDT	End RM Token Date	Integer	2	-
SORTBY	Sort By	Integer	2	-
CBINACTS	CB Inactive Accounts	Boolean	2	-
PSTNGACT	Posting Account	Integer	2	-
UNITACCT	Unit Account	Integer	2	-
RPRTSHOW	Reports Show	Integer	2	-
PRRPTFOR	Print Report For	Integer	2	-
PRVYRCMB	Previous Year CMB	String	6	-
RPTDETAL	Report Detail	Integer	2	-
INDIVDUL_1	Individual[1]	Boolean	2	-
INDIVDUL_2	Individual[2]	Boolean	2	-
INDIVDUL_3	Individual[3]	Boolean	2	-
INDIVDUL_4	Individual[4]	Boolean	2	-
INDIVDUL_5	Individual[5]	Boolean	2	-
INDIVDUL_6	Individual[6]	Boolean	2	-
INDIVDUL_7	Individual[7]	Boolean	2	-
INDIVDUL_8	Individual[8]	Boolean	2	-
INDIVDUL_9	Individual[9]	Boolean	2	-
INDIVDUL_10	Individual[10]	Boolean	2	-
INDIVDUL_11	Individual[11]	Boolean	2	-
INDIVDUL_12	Individual[12]	Boolean	2	-
INDIVDUL_13	Individual[13]	Boolean	2	-
INDIVDUL_14	Individual[14]	Boolean	2	-
INDIVDUL_15	Individual[15]	Boolean	2	-
INDIVDUL_16	Individual[16]	Boolean	2	-
INDIVDUL_17	Individual[17]	Boolean	2	-
INDIVDUL_18	Individual[18]	Boolean	2	-
INDIVDUL_19	Individual[19]	Boolean	2	-
INDIVDUL_20	Individual[20]	Boolean	2	-
INDIVDUL_21	Individual[21]	Boolean	2	-
INDIVDUL_22	Individual[22]	Boolean	2	-
INDIVDUL_23	Individual[23]	Boolean	2	-
INDIVDUL_24	Individual[24]	Boolean	2	-
INDIVDUL_25	Individual[25]	Boolean	2	-
INDIVDUL_26	Individual[26]	Boolean	2	-
INDIVDUL_27	Individual[27]	Boolean	2	-
INDIVDUL_28	Individual[28]	Boolean	2	-
INDIVDUL_29	Individual[29]	Boolean	2	-
INDIVDUL_30	Individual[30]	Boolean	2	-
INDIVDUL_31	Individual[31]	Boolean	2	-
INDIVDUL_32	Individual[32]	Boolean	2	-
INDIVDUL_33	Individual[33]	Boolean	2	-
INDIVDUL_34	Individual[34]	Boolean	2	-
INDIVDUL_35	Individual[35]	Boolean	2	-
INDIVDUL_36	Individual[36]	Boolean	2	-
INDIVDUL_37	Individual[37]	Boolean	2	-
INDIVDUL_38	Individual[38]	Boolean	2	-
INDIVDUL_39	Individual[39]	Boolean	2	-
INDIVDUL_40	Individual[40]	Boolean	2	-
INDIVDUL_41	Individual[41]	Boolean	2	-
PRNTDSCR	Print Description	Integer	2	-
PRZROBAL	Print Zero Balances	Boolean	2	-
CLCRATIO	Calculate Ratio	Integer	2	-
INCLGNDS	Include Legends	Boolean	2	-
GLSTTKDT	GL Start Token Date	Integer	2	-
GLENTKDT	GL End Token Date	Integer	2	-
PRUNTACT	Print Unit Accounts	Boolean	2	-
STACCNUM_1	Starting Account Number:Account_Segment_Pool1	String	10	-
STACCNUM_2	Starting Account Number:Account_Segment_Pool2	String	10	-
STACCNUM_3	Starting Account Number:Account_Segment_Pool3	String	10	-
STACCNUM_4	Starting Account Number:Account_Segment_Pool4	String	10	-
STACCNUM_5	Starting Account Number:Account_Segment_Pool5	String	10	-
EDGACNUM_1	Ending Account Number:Account_Segment_Pool1	String	10	-
EDGACNUM_2	Ending Account Number:Account_Segment_Pool2	String	10	-
EDGACNUM_3	Ending Account Number:Account_Segment_Pool3	String	10	-
EDGACNUM_4	Ending Account Number:Account_Segment_Pool4	String	10	-
EDGACNUM_5	Ending Account Number:Account_Segment_Pool5	String	10	-
SEGSRTBY	Segment Sort By	Integer	2	-
RANGEBY	Range By	Integer	2	-
ACCLSTAT	Accelerator Status	Integer	2	-
USEACCEL	Use Accelerator	Boolean	2	-
CBZBNA	Zero Balance And No Activity	Boolean	2	-
Accounts_Included	Accounts Included	Integer	2	-
Start_Position_String	Start Position String	String	90	-
End_Position_String	End Position String	String	90	-
RPTXRATE	Reporting Exchange Rate	Currency (Variable)	10	-
RPRTCLMD	Reporting Rate Calculation Method	Integer	2	-
PRTCURIN	Print Currency In	Integer	2	-
Checkbook_Date	Checkbook Date	Date	4	-
End_Month	End Month	Integer	2	-
Start_Month	Start Month	Integer	2	-
YEAR1	Year	Integer	2	28 tables
PP_Start_Profile	PP Start Profile	String	22	-
PP_End_Profile	PP End Profile	String	22	-
STVNDRID	Start Vendor ID	String	16	-
STCUSTID	Start Customer ID	String	16	1 tables
ENCUSTID	End Customer ID	String	16	1 tables
ENDVNDID	End Vendor ID	String	16	-
PP_Report_Sort	PP_Report_Sort	Integer	2	-
PP_Last_Date	PP_Last_Date	Date	4	-
PP_User_Access	PP_User_Access	Boolean	2	1 tables