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 TypeSQL DB LengthKeyable Length
1ASI_Order_By SearchASI_Order_ByLI_14Long Integer414
2ACTINDX SearchAccount IndexLI_14Long Integer414
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 SearchYearYearInteger24
4PERIODID SearchPeriod IDINT3Integer23
5ASI_Document_Status SearchASI_Document_StatusINTInteger20
6PERDBLNC SearchPeriod BalanceDLR17_$S2Currency1017
7ACTNUMBR_1 SearchAccount Number:Account_Segment_Pool1Account_Segment_Pool1String86
8ACTNUMBR_2 SearchAccount Number:Account_Segment_Pool2Account_Segment_Pool2String86
9ACTNUMBR_3 SearchAccount Number:Account_Segment_Pool3Account_Segment_Pool3String86
10ACTNUMBR_4 SearchAccount Number:Account_Segment_Pool4Account_Segment_Pool4String86
11ACTNUMBR_5 SearchAccount Number:Account_Segment_Pool5Account_Segment_Pool5String86
12ACTNUMBR_6 SearchAccount Number:Account_Segment_Pool6Account_Segment_Pool6String86
13ACTNUMBR_7 SearchAccount Number:Account_Segment_Pool7Account_Segment_Pool7String86
14ACTNUMBR_8 SearchAccount Number:Account_Segment_Pool8Account_Segment_Pool8String86
15ACTNUMBR_9 SearchAccount Number:Account_Segment_Pool9Account_Segment_Pool9String86
16ACTNUMBR_10 SearchAccount Number:Account_Segment_Pool10Account_Segment_Pool10String86
17ACTDESCR SearchAccount DescriptionSTR50String5250
18ACTALIAS SearchAccount AliasSTR20_Account_AliasString2220
19ACTIVE SearchActiveCB_ActiveBoolean20
20ACCATNUM SearchAccount Category NumberINT2_U0Integer22
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_TypeInteger20
22PSTNGTYP SearchPosting TypeGBInteger20
23CRDTAMNT SearchCredit AmountDLR19_$S2Currency1019
24DEBITAMT SearchDebit AmountDLR19_$S2Currency1019
25ASI_Favorite_Sequence SearchASI_Favorite_SequenceASI_LI_10_RULong Integer410
26MNACSGMT SearchMain Account SegmentSTR66_Seg_IDString6866
27TPCLBLNC SearchTypical BalanceGBInteger20
28DECPLACS SearchDecimal PlacesDDL_Decimal_PlacesInteger20
29FXDORVAR SearchFixed Or VariableLB_Fixed_Or_VariableInteger20
30BALFRCLC SearchBalance For CalculationGBInteger20
31DSPLKUPS SearchDisplay In LookupsML_Display_In_LookupsLong Integer40
32CNVRMTHD SearchConversion MethodDDL_Conversion_MethodInteger20
33HSTRCLRT SearchHistorical RateDLR14_Exchange_RateCurrency (Variable)1014
34NOTEINDX SearchNote IndexDLR14Currency1014
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 DateDTDate48
36MODIFDT SearchModified DateDTDate48
37USERDEF1 SearchUser Defined 1STR20String2220
38USERDEF2 SearchUser Defined 2STR20String2220
39PostSlsIn SearchPost Sales InSumOrDetailInteger20
40PostIvIn SearchPost Inventory InSumOrDetailInteger20
41PostPurchIn SearchPost Purchasing InSumOrDetailInteger20
42PostPRIn SearchPost Payroll InSumOrDetailInteger20
43ADJINFL SearchAdjust for InflationCB_Adjust_For_InflationBoolean20
44INFLAEQU SearchInflation Equity Account IndexLI_14Long Integer414
45INFLAREV SearchInflation Revenue Account IndexLI_14Long Integer414
azurecurveProductsSmartList (1493)PathnameAccount Summary Master SmartList (ASIEXP13)

Leave a Reply

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