Budget Transaction Amounts Work (GL12001)

azurecurveProductsMicrosoft Dynamics GP (0)FinancialBudget Transaction Amounts Work (GL12001)

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

Product: Microsoft Dynamics GP (0)
Series: Financial

Display Name: Budget Transaction Amounts Work
Physical Name: GL12001
Technical Name: GL_BUD_TRX_LINE_WORK

Group Display Name: Transaction Work
Group Technical Name: Transaction Work

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1BACHNUMB SearchBatch NumberStringSTR15_LBAU15
2JRNENTRY SearchJournal EntryLong IntegerLI8_U08
3BUDGETID SearchBudget IDStringSTR15_LBAU15
Key to the Budget Master (GL00200).

Click to show/hide

SELECT
       ['Budget Transaction Amounts Work'].BUDGETID AS 'Budget Transaction Amounts Work-Budget ID'
       ,['Budget Master'].BUDGETID AS 'Budget Master-Budget ID'
FROM
       GL12001 AS ['Budget Transaction Amounts Work']
INNER JOIN
       GL00200 AS ['Budget Master']
              ON
                     ['Budget Transaction Amounts Work'].BUDGETID = ['Budget Master'].BUDGETID
4YEAR1 SearchYearIntegerYear4
5PERIODDT SearchPeriod DateDateDT_Date6
6PERIODID SearchPeriod IDIntegerINT33
7ACTINDX SearchAccount IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Budget Transaction Amounts Work'].ACTINDX AS 'Budget Transaction Amounts Work-Account Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       GL12001 AS ['Budget Transaction Amounts Work']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Budget Transaction Amounts Work'].ACTINDX = ['Account Index Master'].ACTINDX
8BUDGETAMT SearchBudget AmountCurrencyDLR19_$S219
9BudgerAdjustment SearchBudgetAdjustmentCurrencyDollar1919
10GLLINVAL SearchGL Line ValidLong IntegerML_GL_Line_Valid0
azurecurveProductsMicrosoft Dynamics GP (0)FinancialBudget Transaction Amounts Work (GL12001)

Leave a Reply

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