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

COMPANY..PP000012 Table Definition

(COMPANY..Deferral Profiles 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
PPOFFSEQ int
0
p>Correspo...(more) Join Now
PP_Sequencer int
0
Sequence n...(more) Join Now
DISTTYPE smallint
0

Distribution

Type

Integer Value

Sales /

Invoices

Sched

Payments

Debit

Memos

Finance

Charges

Service

Repairs

Warranty

Credit

Memos

Returns

Cash

Receipts

Cash

1

*

na

*

*

*

 

*

*

*

Terms Taken

2

*

na

*

*

*

 

*

*

*

Accts Rec

3

*

na

*

*

*

 

*

*

*

Writeoffs

4

 

na

 

 

 

 

*

*

*

Terms Avail

5

*

na

*

*

*

 

*

*

*

GST

6

 

na

 

 

 

 

*

*

*

PPS

7

 

na

 

 

 

 

*

*

*

Other

8

*

na

*

*

*

*

*

*

*

Sales

9

*

na

 

 

 

 

 

 

 

Trade

10

*

na

*

*

*

*

*

*

 

Freight

11

*

na

*

*

*

*

*

*

 

Miscellaneous

12

*

na

*

*

*

*

*

*

 

Taxes

13

*

na

*

*

*

*

*

*

 

COGS

14

*

na

*

*

*

*

*

*

 

Inventory

15

*

na

*

*

*

*

*

*

 

Finance Chrg

16

 

na

 

*

 

 

 

 

 

Returns

17

 

na

 

 

 

 

 

*

 

Debit Memo

18

 

na

*

 

 

 

 

 

 

Credit Memo

19

 

na

 

 

 

 

*

 

 

Service

20

 

na

 

 

*

 

 

 

 

Warr Exp

21

 

na

 

 

 

*

 

 

 

Warr Sls

22

 

na

 

 

 

*

 

 

 

Comm Exp

23

*

na

*

*

*

 

*

*

 

Comm Pay

24

*

na

*

*

*

 

*

*

 

Unit Acc

25

*

na

*

*

*

*

*

*

*

ROUND

26

*

na

*

*

*

 

*

*

*

RZGain

27

*

na

*

*

*

 

*

*

*

RZLOSS

28

*

na

*

*

*

 

*

*

*

URZGain

29

*

na

*

*

*

 

*

*

*

URZLoss

30

*

na

*

*

*

 

*

*

*

RVLPD030.DISTTYPE
PP_Profile_Name char(21)
''

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
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