Module List > Module SE tables SE000401
You are currently viewing the COMPANY database.
Change

COMPANY..SE000401 Table Definition

(COMPANY..Account Rollups Account Period Detail)

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
ACTNUMBR_1 char(5)
''
Account Nu...(more) Join Now GL00105.ACTNUMBR_1
ACTNUMBR_2 char(5)
''
Account Nu...(more) Join Now
ACTNUMBR_3 char(5)
''
Account Nu...(more) Join Now GL00105.ACTNUMBR_3
ACTNUMBR_4 char(5)
''
Account Nu...(more) Join Now
ACTNUMBR_5 char(5)
''
Account Nu...(more) Join Now GL00105.ACTNUMBR_5
PERIODID smallint
0
Period ID...(more) Join Now SY40100.PERIODID
ACTNUMBR_6 char
''

ACTNUMBR_7 char
''

SESORNO1 smallint
0

SESORT1 char(11)
''

ACTNUMBR_8 char
''

ACTNUMBR_9 char
''

SE_Zero_NM smallint
0

SE_Zero_PB smallint
0

ACTNUMBR_10 char
''

NETAMNT numeric(19,5)
0.00

PERDBLNC numeric(19,5)
0.00

OPENYEAR smallint
0
Open Year:...(more) Join Now GL10000.OPENYEAR
CURRNIDX smallint
0
Currency I...(more) Join Now CM20200.CURRNIDX
join ... more text available
SEBUDDET smallint
0

ACTINDX int
0
Account In...(more) Join Now UPR00100.ACTINDX
join ... more text available
ACTNUMST char(129)
''
Account Nu...(more) Join Now GL00105.ACTNUMST
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