Encumbrance AA Budget Summary (ENC10310V)

azurecurveProductsEncumbrance Management (3258)PurchasingEncumbrance AA Budget Summary (ENC10310V)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/ENC10310V

Product: Encumbrance Management (3258)
Series: Purchasing

Display Name: Encumbrance AA Budget Summary
Physical Name: ENC10310V
Technical Name: ENC_aaBudgetSummary

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1aaBudgetTreeID SearchaaBudgetTreeIDaaLONG_INTLong Integer8
2aaBudgetID SearchaaBudgetIDLong IntLong Integer8
3aaBudget SearchaaBudgetSTR15_LBAUString15
4INVINDX SearchInventory IndexLI_14Long Integer14
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Encumbrance AA Budget Summary'].INVINDX AS 'Encumbrance AA Budget Summary-Inventory Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ENC10310V AS ['Encumbrance AA Budget Summary']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Encumbrance AA Budget Summary'].INVINDX = ['Account Index Master'].ACTINDX
5aaCodeSequence SearchaaCodeSequenceaaLONG_INTLong Integer8
6YEAR1 SearchYearYearInteger4
7PERIODID SearchPeriod IDINT3Integer3
8PERIODDT SearchPeriod DateDT_DateDate6
9PERDENDT SearchPeriod-Ending DateDT_Ending_DateDate0
10Actual_Amount SearchActual AmountDLR19_$S2Currency19
11UNPOSTEDAMT SearchUnposted AmountDLR19_$S2Currency19
12BUDGETAMT SearchBudget AmountDLR19_$S2Currency19
13ENCMBAMT SearchEncumbered AmountDLR19_$S2Currency19
14PreEncumberedAmt SearchPreEncumbered AmountDLR19_$S2Currency19
15PreBudgetAmt SearchPreBudget AmountDLR19_$S2Currency19
16DEX_ROW_ID Searchintint10

DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information.

Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.

azurecurveProductsEncumbrance Management (3258)PurchasingEncumbrance AA Budget Summary (ENC10310V)

Leave a Reply

Your email address will not be published. Required fields are marked *