Encumbrance AA Budget By Account (ENCAA40510V)

azurecurveProductsEncumbrance Management (3258)PurchasingEncumbrance AA Budget By Account (ENCAA40510V)

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

Product: Encumbrance Management (3258)
Series: Purchasing

Display Name: Encumbrance AA Budget By Account
Physical Name: ENCAA40510V
Technical Name: ENC_aaBudgetAccount

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1aaBudgetTreeID SearchaaBudgetTreeIDaaLONG_INTLong Integer48
2aaBudgetID SearchaaBudgetIDLong IntLong Integer48
3aaBudget SearchaaBudgetSTR15_LBAUString1615
4INVINDX SearchInventory IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Encumbrance AA Budget By Account'].INVINDX AS 'Encumbrance AA Budget By Account-Inventory Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ENCAA40510V AS ['Encumbrance AA Budget By Account']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Encumbrance AA Budget By Account'].INVINDX = ['Account Index Master'].ACTINDX
5PERIODDT SearchPeriod DateDT_DateDate46
6YEAR1 SearchYearYearInteger24
7PERIODID SearchPeriod IDINT3Integer23
8aaCodeSequence SearchaaCodeSequenceaaLONG_INTLong Integer48
9aaTrxDimID SearchaaTrxDimIDaaLONG_INTLong Integer48
10aaTrxDimCodeID SearchaaTrxDimCodeIDaaLONG_INTLong Integer48
11aaTrxDimParCodeID SearchaaTrxDimParCodeIDaaLONG_INTLong Integer48
12aaLvlCodeString SearchaaLvlCodeStringSTR50String5250
13Balance SearchBalanceDLR19_$S2Currency1019
14DEX_ROW_ID Searchintint1010

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 By Account (ENCAA40510V)

Leave a Reply

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