Module List > Module XL tables XLImport
You are currently viewing the COMPANY database.
Change

COMPANY..XLImport Table Definition

(COMPANY..XLImport)

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
BUDGETID char(15)
''
Budget ID:...(more) Join Now GL00200.BUDGETID
ACTNUMBR_1 char(5)
''
Account Nu...(more) Join Now
ACTNUMBR_2 char(5)
''
Account Nu...(more) Join Now
ACTNUMBR_3 char(5)
''
Account Nu...(more) Join Now
ACTNUMBR_4 char(5)
''
Account Nu...(more) Join Now
ACTNUMBR_5 char(5)
''
Account Nu...(more) Join Now
ACTNUMBR_6 char
''

PERIODDT datetime
'1/1/1900'
Period Dat...(more) Join Now SY40100.PERIODDT
PERIODID smallint
0
Period ID...(more) Join Now SY40100.PERIODID
ACTNUMBR_7 char
''

ACTNUMBR_8 char
''

BUDGETAMT numeric(19,5)
0.00
Budget Amo...(more) Join Now
ACTNUMBR_9 char
''

ACCATNUM smallint
0
Account Ca...(more) Join Now GL00100.ACCATNUM
ACTINDX int
0
Account In...(more) Join Now UPR00100.ACTINDX
join ... more text available
ACTNUMBR_10 char
''

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