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

COMPANY..PP50101 Table Definition

(COMPANY..Deferral Amounts Temporary)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
USERID char(15)
''
The user t...(more) Join Now
join ... more text available
BCHSOURC char(15)
''
Batch Sour...(more) Join Now
BACHNUMB char(15)
''
Batch Numb...(more) Join Now
join ... more text available
JRNENTRY int
0

SQNCLINE numeric(19,5)
0.00
Sequence L...(more) Join Now
ACTINDX int
0
Account In...(more) Join Now UPR40500.ACTINDX
join ... more text available
OFFINDX int
0

TRXAMNT numeric(19,5)
0.00

GLLINMSG binary(4)
0

GLLINMS2 binary(4)
0

TRXDATE datetime
'1/1/1900'

ACCTTYPE smallint
0

DSCRIPTN char(31)
''

CURNCYID char(15)
''
Currency I...(more) Join Now POP10100.CURNCYID
join ... more text available
CURRNIDX smallint
0
Currency I...(more) Join Now POP10100.CURRNIDX
join ... more text available
FUNCRIDX smallint
0
Functional...(more) Join Now
ORIGAMT numeric(19,5)
0.00

DOCNUMBR char(21)
''
Document N...(more) Join Now RM20102.DOCNUMBR
CUSTNMBR char(15)
''
Customer N...(more) Join Now POP10100.CUSTNMBR
join ... more text available
CUSTNAME char(65)
''

DOCDATE datetime
'1/1/1900'
Document D...(more) Join Now IV10201.DOCDATE
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