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: Pathname

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_ByLI_14Long Integer14
2ACTINDX SearchAccount IndexLI_14Long Integer14
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 SearchYearYearInteger4
4PERIODID SearchPeriod IDINT3Integer3
5ASI_Document_Status SearchASI_Document_StatusINTInteger0
6PERDBLNC SearchPeriod BalanceDLR17_$S2Currency17
7ACTNUMBR_1 SearchAccount Number:Account_Segment_Pool1Account_Segment_Pool1String6
8ACTNUMBR_2 SearchAccount Number:Account_Segment_Pool2Account_Segment_Pool2String6
9ACTNUMBR_3 SearchAccount Number:Account_Segment_Pool3Account_Segment_Pool3String6
10ACTNUMBR_4 SearchAccount Number:Account_Segment_Pool4Account_Segment_Pool4String6
11ACTNUMBR_5 SearchAccount Number:Account_Segment_Pool5Account_Segment_Pool5String6
12ACTNUMBR_6 SearchAccount Number:Account_Segment_Pool6Account_Segment_Pool6String6
13ACTNUMBR_7 SearchAccount Number:Account_Segment_Pool7Account_Segment_Pool7String6
14ACTNUMBR_8 SearchAccount Number:Account_Segment_Pool8Account_Segment_Pool8String6
15ACTNUMBR_9 SearchAccount Number:Account_Segment_Pool9Account_Segment_Pool9String6
16ACTNUMBR_10 SearchAccount Number:Account_Segment_Pool10Account_Segment_Pool10String6
17ACTDESCR SearchAccount DescriptionSTR50String50
18ACTALIAS SearchAccount AliasSTR20_Account_AliasString20
19ACTIVE SearchActiveCB_ActiveBoolean0
20ACCATNUM SearchAccount Category NumberINT2_U0Integer2
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 TypeDDL_Account_TypeInteger0
22PSTNGTYP SearchPosting TypeGBInteger0
23CRDTAMNT SearchCredit AmountDLR19_$S2Currency19
24DEBITAMT SearchDebit AmountDLR19_$S2Currency19
25ASI_Favorite_Sequence SearchASI_Favorite_SequenceASI_LI_10_RULong Integer10
26MNACSGMT SearchMain Account SegmentSTR66_Seg_IDString66
27TPCLBLNC SearchTypical BalanceGBInteger0
28DECPLACS SearchDecimal PlacesDDL_Decimal_PlacesInteger0
29FXDORVAR SearchFixed Or VariableLB_Fixed_Or_VariableInteger0
30BALFRCLC SearchBalance For CalculationGBInteger0
31DSPLKUPS SearchDisplay In LookupsML_Display_In_LookupsLong Integer0
32CNVRMTHD SearchConversion MethodDDL_Conversion_MethodInteger0
33HSTRCLRT SearchHistorical RateDLR14_Exchange_RateCurrency (Variable)14
34NOTEINDX SearchNote IndexDLR14Currency14
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 DateDTDate8
36MODIFDT SearchModified DateDTDate8
37USERDEF1 SearchUser Defined 1STR20String20
38USERDEF2 SearchUser Defined 2STR20String20
39PostSlsIn SearchPost Sales InSumOrDetailInteger0
40PostIvIn SearchPost Inventory InSumOrDetailInteger0
41PostPurchIn SearchPost Purchasing InSumOrDetailInteger0
42PostPRIn SearchPost Payroll InSumOrDetailInteger0
43ADJINFL SearchAdjust for InflationCB_Adjust_For_InflationBoolean0
44INFLAEQU SearchInflation Equity Account IndexLI_14Long Integer14
45INFLAREV SearchInflation Revenue Account IndexLI_14Long Integer14
azurecurveProductsSmartList (1493)PathnameAccount Summary Master SmartList (ASIEXP13)

Leave a Reply

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