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)
Field Definitions:
What is the 'source' column?
| 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
|
|
|
|
|