Account Summary Master SmartList (ASIEXP13)

azurecurveProductsSmartList (1493)PathnameAccount Summary Master SmartList (ASIEXP13)

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

Product: SmartList (1493)
Series:

Display Name: Account Summary Master SmartList
Physical Name: ASIEXP13
Technical Name: ASI_GL_Account_SUM_Explorer

Group Display Name: SmartList Master
Group Technical Name: ASI_Explorer_Logical_MSTR

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1ASI_Order_By SearchASI_Order_ByLong IntegerLI_1414
2ACTINDX SearchAccount IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Account Summary Master SmartList'].ACTINDX AS 'Account Summary Master SmartList-Account Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP13 AS ['Account Summary Master SmartList']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Account Summary Master SmartList'].ACTINDX = ['Account Index Master'].ACTINDX
3YEAR1 SearchYearIntegerYear4
4PERIODID SearchPeriod IDIntegerINT33
5ASI_Document_Status SearchASI_Document_StatusIntegerINT0
6PERDBLNC SearchPeriod BalanceCurrencyDLR17_$S217
7ACTNUMBR_1 SearchAccount Number:Account_Segment_Pool1StringAccount_Segment_Pool16
8ACTNUMBR_2 SearchAccount Number:Account_Segment_Pool2StringAccount_Segment_Pool26
9ACTNUMBR_3 SearchAccount Number:Account_Segment_Pool3StringAccount_Segment_Pool36
10ACTNUMBR_4 SearchAccount Number:Account_Segment_Pool4StringAccount_Segment_Pool46
11ACTNUMBR_5 SearchAccount Number:Account_Segment_Pool5StringAccount_Segment_Pool56
12ACTNUMBR_6 SearchAccount Number:Account_Segment_Pool6StringAccount_Segment_Pool66
13ACTNUMBR_7 SearchAccount Number:Account_Segment_Pool7StringAccount_Segment_Pool76
14ACTNUMBR_8 SearchAccount Number:Account_Segment_Pool8StringAccount_Segment_Pool86
15ACTNUMBR_9 SearchAccount Number:Account_Segment_Pool9StringAccount_Segment_Pool96
16ACTNUMBR_10 SearchAccount Number:Account_Segment_Pool10StringAccount_Segment_Pool106
17ACTDESCR SearchAccount DescriptionStringSTR5050
18ACTALIAS SearchAccount AliasStringSTR20_Account_Alias20
19ACTIVE SearchActiveBooleanCB_Active0
20ACCATNUM SearchAccount Category NumberIntegerINT2_U02
Key to the Account Category Master (GL00102).

Click to show/hide

SELECT
       ['Account Summary Master SmartList'].ACCATNUM AS 'Account Summary Master SmartList-Account Category Number'
       ,['Account Category Master'].ACCATNUM AS 'Account Category Master-Account Category Number'
FROM
       ASIEXP13 AS ['Account Summary Master SmartList']
INNER JOIN
       GL00102 AS ['Account Category Master']
              ON
                     ['Account Summary Master SmartList'].ACCATNUM = ['Account Category Master'].ACCATNUM
21ACCTTYPE SearchAccount TypeIntegerDDL_Account_Type0
22PSTNGTYP SearchPosting TypeIntegerGB0
23CRDTAMNT SearchCredit AmountCurrencyDLR19_$S219
24DEBITAMT SearchDebit AmountCurrencyDLR19_$S219
25ASI_Favorite_Sequence SearchASI_Favorite_SequenceLong IntegerASI_LI_10_RU10
26MNACSGMT SearchMain Account SegmentStringSTR66_Seg_ID66
27TPCLBLNC SearchTypical BalanceIntegerGB0
28DECPLACS SearchDecimal PlacesIntegerDDL_Decimal_Places0
29FXDORVAR SearchFixed Or VariableIntegerLB_Fixed_Or_Variable0
30BALFRCLC SearchBalance For CalculationIntegerGB0
31DSPLKUPS SearchDisplay In LookupsLong IntegerML_Display_In_Lookups0
32CNVRMTHD SearchConversion MethodIntegerDDL_Conversion_Method0
33HSTRCLRT SearchHistorical RateCurrency (Variable)DLR14_Exchange_Rate14
34NOTEINDX SearchNote IndexCurrencyDLR1414
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['Account Summary Master SmartList'].NOTEINDX AS 'Account Summary Master SmartList-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       ASIEXP13 AS ['Account Summary Master SmartList']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['Account Summary Master SmartList'].NOTEINDX = ['Record Notes Master'].NOTEINDX
35CREATDDT SearchCreated DateDateDT8
36MODIFDT SearchModified DateDateDT8
37USERDEF1 SearchUser Defined 1StringSTR2020
38USERDEF2 SearchUser Defined 2StringSTR2020
39PostSlsIn SearchPost Sales InIntegerSumOrDetail0
40PostIvIn SearchPost Inventory InIntegerSumOrDetail0
41PostPurchIn SearchPost Purchasing InIntegerSumOrDetail0
42PostPRIn SearchPost Payroll InIntegerSumOrDetail0
43ADJINFL SearchAdjust for InflationBooleanCB_Adjust_For_Inflation0
44INFLAEQU SearchInflation Equity Account IndexLong IntegerLI_1414
45INFLAREV SearchInflation Revenue Account IndexLong IntegerLI_1414
azurecurveProductsSmartList (1493)PathnameAccount Summary Master SmartList (ASIEXP13)

Leave a Reply

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