GP Tables

ENC10310V - Encumbrance AA Budget Summary

SQL Query Builder

16 Columns

Column Description Type Length
aaBudgetTreeID int 0
aaBudgetID int 0
aaBudget char ''
INVINDX int 0
aaCodeSequence int 0
YEAR1 smallint 0
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
ENCMBAMT numeric 0.00
PreEncumberedAmt numeric 0.00
PreBudgetAmt numeric 0.00
DEX_ROW_ID int auto number (1,1)

Related Tables

Tables that share columns with ENC10310V. Click "Join" to add to your query.

DEX_ROW_ID

AAG00200 AAG00201 AAG00202 AAG00300 AAG00301 AAG00302 ACColumn AF00100

aaBudgetID

aaBudget

aaBudgetTreeID

aaCodeSequence