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 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 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_DateDate6
6YEAR1 SearchYearYearInteger4
7PERIODID SearchPeriod IDINT3Integer3
8aaCodeSequence SearchaaCodeSequenceaaLONG_INTLong Integer8
9aaTrxDimID SearchaaTrxDimIDaaLONG_INTLong Integer8
10aaTrxDimCodeID SearchaaTrxDimCodeIDaaLONG_INTLong Integer8
11aaTrxDimParCodeID SearchaaTrxDimParCodeIDaaLONG_INTLong Integer8
12aaLvlCodeString SearchaaLvlCodeStringSTR50String50
13Balance SearchBalanceDLR19_$S2Currency19
14DEX_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 By Account (ENCAA40510V)

Leave a Reply

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