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

COMPANY..PP100100 Table Definition

(COMPANY..Deferral Header History)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
PP_Module smallint
0
5 = SOP...(more) Join Now
PP_Record_Type smallint
0
p>For SOP:...(more) Join Now
PP_Document_Number char(21)
''
The Source...(more) Join Now
PP_Sequencer int
0
Sequence n...(more) Join Now
PPOFFSEQ int
0
p>Correspo...(more) Join Now
VCHRNMBR char(21)
''
Voucher Nu...(more) Join Now
CNTRLTYP smallint
0
Control Ty...(more) Join Now
DSTSQNUM int
0
Sequence N...(more) Join Now
STRTNGDT datetime
'1/1/1900'
Date the t...(more) Join Now
ENDINGDT datetime
'1/1/1900'

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

PP_Deferrals_Transfer_In int
0

PP_Recognition_Index int
0

TRXAMNT numeric(19,5)
0.00

USERID char(15)
''
The user t...(more) Join Now
join ... more text available
REFRENCE char(31)
''
For Payabl...(more) Join Now
IntegerValue smallint
0
In my test...(more) Join Now
PP_Calculation_Method smallint
0
1 Days In ...(more) Join Now
PP_Miscellaneous_Periods smallint
0

VOIDSTTS smallint
0
1 = Voided...(more) Join Now
CUSTVNDR char(15)
''
The transa...(more) Join Now
DOCDATE datetime
'1/1/1900'
Document D...(more) Join Now
NOTEINDX numeric(19,5)
0.00
Note Index...(more) Join Now
join ... more text available
JRNENTRY int
0
Journal En...(more) Join Now
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