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:

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

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1aaBudgetTreeID SearchaaBudgetTreeIDLong IntegeraaLONG_INT8
2aaBudgetID SearchaaBudgetIDLong IntegerLong Int8
3aaBudget SearchaaBudgetStringSTR15_LBAU15
4INVINDX SearchInventory IndexLong IntegerLI_1414
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 DateDateDT_Date6
6YEAR1 SearchYearIntegerYear4
7PERIODID SearchPeriod IDIntegerINT33
8aaCodeSequence SearchaaCodeSequenceLong IntegeraaLONG_INT8
9aaTrxDimID SearchaaTrxDimIDLong IntegeraaLONG_INT8
10aaTrxDimCodeID SearchaaTrxDimCodeIDLong IntegeraaLONG_INT8
11aaTrxDimParCodeID SearchaaTrxDimParCodeIDLong IntegeraaLONG_INT8
12aaLvlCodeString SearchaaLvlCodeStringStringSTR5050
13Balance SearchBalanceCurrencyDLR19_$S219
azurecurveProductsEncumbrance Management (3258)PurchasingEncumbrance AA Budget By Account (ENCAA40510V)

Leave a Reply

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