Extender Journal Accounts (EXT41101)

azurecurveProductsExtender (3107)ProjectExtender Journal Accounts (EXT41101)

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

Product: Extender (3107)
Series: Project

Display Name: Extender Journal Accounts
Physical Name: EXT41101
Technical Name: PT_Extender_Journal_Accounts

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1PT_Journal_ID SearchPT Journal IDSTR15_LBAUString1615
2DSTSQNUM SearchDistribution Sequence NumberLong IntLong Integer48
3ACTINDX SearchAccount IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Extender Journal Accounts'].ACTINDX AS 'Extender Journal Accounts-Account Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       EXT41101 AS ['Extender Journal Accounts']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Extender Journal Accounts'].ACTINDX = ['Account Index Master'].ACTINDX
4DebitCredit SearchDebit / CreditDebit / CreditInteger20
5DISTAMNT SearchDistribution AmountDLR17_RBSO_STR$Currency1017
6DistRef SearchDistribution ReferenceSTR30String3230
7Ext_Account_From SearchExt_Account_FromExtender Account FromInteger20
8Ext_Amount_From SearchExt_Amount_FromExtender Amount FromInteger20
9Ext_Reference_From SearchExt_Reference_FromExtender Reference FromInteger20
10Form_Field_Number_1 SearchForm Field Number[1]INT5Integer24
11Form_Field_Number_2 SearchForm Field Number[2]INT5Integer24
12Form_Field_Number_3 SearchForm Field Number[3]INT5Integer24
13Form_Field_Number_4 SearchForm Field Number[4]INT5Integer24
14Form_Field_Number_5 SearchForm Field Number[5]INT5Integer24
15Form_Field_Number_6 SearchForm Field Number[6]INT5Integer24
16Form_Field_Number_7 SearchForm Field Number[7]INT5Integer24
17Form_Field_Number_8 SearchForm Field Number[8]INT5Integer24
18Form_Field_Number_9 SearchForm Field Number[9]INT5Integer24
19Form_Field_Number_10 SearchForm Field Number[10]INT5Integer24
20Form_Field_Number_11 SearchForm Field Number[11]INT5Integer24
21Form_Field_Number_12 SearchForm Field Number[12]INT5Integer24
22Form_Field_Number_13 SearchForm Field Number[13]INT5Integer24
23Form_Field_Number_14 SearchForm Field Number[14]INT5Integer24
24Form_Field_Number_15 SearchForm Field Number[15]INT5Integer24
25Form_Field_Number_16 SearchForm Field Number[16]INT5Integer24
26Form_Field_Number_17 SearchForm Field Number[17]INT5Integer24
27Form_Field_Number_18 SearchForm Field Number[18]INT5Integer24
28Form_Field_Number_19 SearchForm Field Number[19]INT5Integer24
29Form_Field_Number_20 SearchForm Field Number[20]INT5Integer24
azurecurveProductsExtender (3107)ProjectExtender Journal Accounts (EXT41101)

Leave a Reply

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