SmartList Account Master (ASIEXP01)

azurecurveProductsSmartList (1493)PathnameSmartList Account Master (ASIEXP01)

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

Product: SmartList (1493)
Series: Pathname

Display Name: SmartList Account Master
Physical Name: ASIEXP01
Technical Name: ASI_GL_Account_MSTR_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
       ['SmartList Account Master'].ACTINDX AS 'SmartList Account Master-Account Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP01 AS ['SmartList Account Master']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Account Master'].ACTINDX = ['Account Index Master'].ACTINDX
3ACTNUMBR_1 SearchAccount Number:Account_Segment_Pool1Account_Segment_Pool1String6
4ACTNUMBR_2 SearchAccount Number:Account_Segment_Pool2Account_Segment_Pool2String6
5ACTNUMBR_3 SearchAccount Number:Account_Segment_Pool3Account_Segment_Pool3String6
6ACTNUMBR_4 SearchAccount Number:Account_Segment_Pool4Account_Segment_Pool4String6
7ACTNUMBR_5 SearchAccount Number:Account_Segment_Pool5Account_Segment_Pool5String6
8ACTNUMBR_6 SearchAccount Number:Account_Segment_Pool6Account_Segment_Pool6String6
9ACTNUMBR_7 SearchAccount Number:Account_Segment_Pool7Account_Segment_Pool7String6
10ACTNUMBR_8 SearchAccount Number:Account_Segment_Pool8Account_Segment_Pool8String6
11ACTNUMBR_9 SearchAccount Number:Account_Segment_Pool9Account_Segment_Pool9String6
12ACTNUMBR_10 SearchAccount Number:Account_Segment_Pool10Account_Segment_Pool10String6
13ACTALIAS SearchAccount AliasSTR20_Account_AliasString20
14MNACSGMT SearchMain Account SegmentSTR66_Seg_IDString66
15ACCTTYPE SearchAccount TypeDDL_Account_TypeInteger0
16ACTDESCR SearchAccount DescriptionSTR50String50
17PSTNGTYP SearchPosting TypeGBInteger0
18ACCATNUM SearchAccount Category NumberINT2_U0Integer2
Key to the Account Category Master (GL00102).

Click to show/hide

SELECT
       ['SmartList Account Master'].ACCATNUM AS 'SmartList Account Master-Account Category Number'
       ,['Account Category Master'].ACCATNUM AS 'Account Category Master-Account Category Number'
FROM
       ASIEXP01 AS ['SmartList Account Master']
INNER JOIN
       GL00102 AS ['Account Category Master']
              ON
                     ['SmartList Account Master'].ACCATNUM = ['Account Category Master'].ACCATNUM
19ACTIVE SearchActiveCB_ActiveBoolean0
20TPCLBLNC SearchTypical BalanceGBInteger0
21DECPLACS SearchDecimal PlacesDDL_Decimal_PlacesInteger0
22FXDORVAR SearchFixed Or VariableLB_Fixed_Or_VariableInteger0
23BALFRCLC SearchBalance For CalculationGBInteger0
24DSPLKUPS SearchDisplay In LookupsML_Display_In_LookupsLong Integer0
25CNVRMTHD SearchConversion MethodDDL_Conversion_MethodInteger0
26HSTRCLRT SearchHistorical RateDLR14_Exchange_RateCurrency (Variable)14
27NOTEINDX SearchNote IndexDLR14Currency14
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['SmartList Account Master'].NOTEINDX AS 'SmartList Account Master-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       ASIEXP01 AS ['SmartList Account Master']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['SmartList Account Master'].NOTEINDX = ['Record Notes Master'].NOTEINDX
28CREATDDT SearchCreated DateDTDate8
29MODIFDT SearchModified DateDTDate8
30USERDEF1 SearchUser Defined 1STR20String20
31USERDEF2 SearchUser Defined 2STR20String20
32PostSlsIn SearchPost Sales InSumOrDetailInteger0
33PostIvIn SearchPost Inventory InSumOrDetailInteger0
34PostPurchIn SearchPost Purchasing InSumOrDetailInteger0
35PostPRIn SearchPost Payroll InSumOrDetailInteger0
36ASI_Favorite_Sequence SearchASI_Favorite_SequenceASI_LI_10_RULong Integer10
37ADJINFL SearchAdjust for InflationCB_Adjust_For_InflationBoolean0
38INFLAEQU SearchInflation Equity Account IndexLI_14Long Integer14
39INFLAREV SearchInflation Revenue Account IndexLI_14Long Integer14
40USRDEFS1 SearchUser Defined String 1STR30String30
41USRDEFS2 SearchUser Defined String 2STR30String30
42ACCTENTR SearchAllow Account EntryCB_Allow_Account_EntryBoolean0
azurecurveProductsSmartList (1493)PathnameSmartList Account Master (ASIEXP01)

Leave a Reply

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