Module List > Module ENC tables ENC10310V
You are currently viewing the COMPANY database.
Change

COMPANY..ENC10310V Table Definition

(COMPANY..Encumbrance AA Budget Summary)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
aaBudgetTreeID int
0

aaBudgetID int
0

aaBudget char
''

INVINDX int
0
Inventory ...(more) Join Now POP10600.INVINDX
aaCodeSequence int
0

YEAR1 smallint
0
Year...(more) Join Now SY40101.YEAR1
PERIODID smallint
0

PERIODDT datetime
'1/1/1900'

PERDENDT datetime
'1/1/1900'

Actual_Amount numeric
0.00

UNPOSTEDAMT numeric
0.00

BUDGETAMT numeric
0.00
Budget Amo...(more) Join Now PC40308.BUDGETAMT
ENCMBAMT numeric
0.00

PreEncumberedAmt numeric
0.00

PreBudgetAmt numeric
0.00

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