DynDeveloper.com

DynDeveloper.com
Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now! Log In
Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our SOP scripts. All of our scripts for Dynamics GP can be found here
Module List > Module PP (Def Revenue) tables PP000060
You are currently viewing the COMPANY database.
Change

COMPANY..PP000060 Table Definition

(COMPANY..Deferral Report Options)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value		 Source
IFFILXST smallint
0

FILEXPNM char(255)
''

EXPTTYPE smallint
0

ASKECHTM tinyint
0

PRNTOFIL tinyint
0

PRTOPRTR tinyint
0

PRTOSCRN tinyint
0

PRNTTYPE smallint
0

RPTGRIND smallint
0

RTPACHIN smallint
0

RTGRSBIN numeric(19,5)
0.00

REPORTID smallint
0

FINRPTNM char(31)
''

STRTNGDT datetime
'1/1/1900'

ENDINGDT datetime
'1/1/1900'

STTSEGID char(11)
''

ENDSEGID char(11)
''

STGENINT1 smallint
0

ENDGENINT1 smallint
0

STDOCNUM char(21)
''

ENDOCNUM char(21)
''

STRMTKDT smallint
0

ENRMTKDT smallint
0

SORTBY smallint
0

CBINACTS tinyint
0

PSTNGACT smallint
0

UNITACCT smallint
0

RPRTSHOW smallint
0

PRRPTFOR smallint
0

PRVYRCMB char(5)
''

RPTDETAL smallint
0

INDIVDUL_1 tinyint
0

INDIVDUL_2 tinyint
0

INDIVDUL_3 tinyint
0

INDIVDUL_4 tinyint
0

INDIVDUL_5 tinyint
0

INDIVDUL_6 tinyint
0

INDIVDUL_7 tinyint
0

INDIVDUL_8 tinyint
0

INDIVDUL_9 tinyint
0

INDIVDUL_10 tinyint
0

INDIVDUL_11 tinyint
0

INDIVDUL_12 tinyint
0

INDIVDUL_13 tinyint
0

INDIVDUL_14 tinyint
0

INDIVDUL_15 tinyint
0

INDIVDUL_16 tinyint
0

INDIVDUL_17 tinyint
0

INDIVDUL_18 tinyint
0

INDIVDUL_19 tinyint
0

INDIVDUL_20 tinyint
0

INDIVDUL_21 tinyint
0

INDIVDUL_22 tinyint
0

INDIVDUL_23 tinyint
0

INDIVDUL_24 tinyint
0

INDIVDUL_25 tinyint
0

INDIVDUL_26 tinyint
0

INDIVDUL_27 tinyint
0

INDIVDUL_28 tinyint
0

INDIVDUL_29 tinyint
0

INDIVDUL_30 tinyint
0

INDIVDUL_31 tinyint
0

INDIVDUL_32 tinyint
0

INDIVDUL_33 tinyint
0

INDIVDUL_34 tinyint
0

INDIVDUL_35 tinyint
0

INDIVDUL_36 tinyint
0

INDIVDUL_37 tinyint
0

INDIVDUL_38 tinyint
0

INDIVDUL_39 tinyint
0

INDIVDUL_40 tinyint
0

INDIVDUL_41 tinyint
0

PRNTDSCR smallint
0

PRZROBAL tinyint
0

CLCRATIO smallint
0

INCLGNDS tinyint
0

GLSTTKDT smallint
0

GLENTKDT smallint
0

PRUNTACT tinyint
0

STACCNUM_1 char(9)
''

STACCNUM_2 char(9)
''

STACCNUM_3 char(9)
''

STACCNUM_4 char(9)
''

STACCNUM_5 char(9)
''

EDGACNUM_1 char(9)
''

EDGACNUM_2 char(9)
''

EDGACNUM_3 char(9)
''

EDGACNUM_4 char(9)
''

EDGACNUM_5 char(9)
''

SEGSRTBY smallint
0

RANGEBY smallint
0

ACCLSTAT smallint
0

USEACCEL tinyint
0

CBZBNA tinyint
0

Accounts_Included smallint
0

Start_Position_String char(89)
''

End_Position_String char(89)
''

RPTXRATE numeric(19,7)
0.00
Reporting ...(more) Join Now
RPRTCLMD smallint
0
Reporting ...(more) Join Now
PRTCURIN smallint
0

Checkbook_Date datetime
'1/1/1900'

End_Month smallint
0

Start_Month smallint
0

YEAR1 smallint
0
Year: The ...(more) Join Now UPR00900.YEAR1
PP_Start_Profile char(21)
''

PP_End_Profile char(21)
''

STVNDRID char(15)
''

STCUSTID char(15)
''

ENCUSTID char(15)
''

ENDVNDID char(15)
''

PP_Report_Sort smallint
0

PP_Last_Date datetime
'1/1/1900'

PP_User_Access tinyint
0

DEX_ROW_ID int
auto number (1,1)
 Unique ide...(more) Join Now
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
Archives | Table Listing | eConnect Error Database | eConnect Schema | Gold Star Locksmith
3