Module List > Module PP (Def Revenue) tables PP000010
You are currently viewing the COMPANY database.
Change

COMPANY..PP000010 Table Definition

(COMPANY..Deferral Profiles Header)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
PP_Profile_Name char(21)
''

PP_Module smallint
0
5 = SOP...(more) Join Now
OFFINDX int
0

ACTINDX int
0
Account In...(more) Join Now UPR40500.ACTINDX
join ... more text available
PP_Deferred_BC_Index int
0

PP_Deferrals_Transfer_In int
0

PP_Recognition_Index int
0

PP_Calculation_Method smallint
0
1 Days In ...(more) Join Now
PP_Debit_Credit_1 smallint
0

PP_Debit_Credit_2 smallint
0

PP_Debit_Credit_3 smallint
0

PP_Debit_Credit_4 smallint
0

PP_Debit_Credit_5 smallint
0

PP_Debit_Credit_6 smallint
0

PP_Debit_Credit_7 smallint
0

PP_Debit_Credit_8 smallint
0

PP_Debit_Credit_9 smallint
0

PP_Debit_Credit_10 smallint
0

STRTNGDT datetime
'1/1/1900'

ENDINGDT datetime
'1/1/1900'

NUMOFPER smallint
0
Number of ...(more) Join Now
NOTEINDX numeric(19,5)
0.00
Note Index...(more) Join Now
join ... more text available
PP_Overwrite_Original_Di tinyint
0

PP_Miscellaneous_Periods smallint
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
3