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 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
       ['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_Pool1String86
4ACTNUMBR_2 SearchAccount Number:Account_Segment_Pool2Account_Segment_Pool2String86
5ACTNUMBR_3 SearchAccount Number:Account_Segment_Pool3Account_Segment_Pool3String86
6ACTNUMBR_4 SearchAccount Number:Account_Segment_Pool4Account_Segment_Pool4String86
7ACTNUMBR_5 SearchAccount Number:Account_Segment_Pool5Account_Segment_Pool5String86
8ACTNUMBR_6 SearchAccount Number:Account_Segment_Pool6Account_Segment_Pool6String86
9ACTNUMBR_7 SearchAccount Number:Account_Segment_Pool7Account_Segment_Pool7String86
10ACTNUMBR_8 SearchAccount Number:Account_Segment_Pool8Account_Segment_Pool8String86
11ACTNUMBR_9 SearchAccount Number:Account_Segment_Pool9Account_Segment_Pool9String86
12ACTNUMBR_10 SearchAccount Number:Account_Segment_Pool10Account_Segment_Pool10String86
13ACTALIAS SearchAccount AliasSTR20_Account_AliasString2220
14MNACSGMT SearchMain Account SegmentSTR66_Seg_IDString6866
15ACCTTYPE SearchAccount TypeDDL_Account_TypeInteger20
16ACTDESCR SearchAccount DescriptionSTR50String5250
17PSTNGTYP SearchPosting TypeGBInteger20
18ACCATNUM SearchAccount Category NumberINT2_U0Integer22
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_ActiveBoolean20
20TPCLBLNC SearchTypical BalanceGBInteger20
21DECPLACS SearchDecimal PlacesDDL_Decimal_PlacesInteger20
22FXDORVAR SearchFixed Or VariableLB_Fixed_Or_VariableInteger20
23BALFRCLC SearchBalance For CalculationGBInteger20
24DSPLKUPS SearchDisplay In LookupsML_Display_In_LookupsLong Integer40
25CNVRMTHD SearchConversion MethodDDL_Conversion_MethodInteger20
26HSTRCLRT SearchHistorical RateDLR14_Exchange_RateCurrency (Variable)1014
27NOTEINDX SearchNote IndexDLR14Currency1014
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 DateDTDate48
29MODIFDT SearchModified DateDTDate48
30USERDEF1 SearchUser Defined 1STR20String2220
31USERDEF2 SearchUser Defined 2STR20String2220
32PostSlsIn SearchPost Sales InSumOrDetailInteger20
33PostIvIn SearchPost Inventory InSumOrDetailInteger20
34PostPurchIn SearchPost Purchasing InSumOrDetailInteger20
35PostPRIn SearchPost Payroll InSumOrDetailInteger20
36ASI_Favorite_Sequence SearchASI_Favorite_SequenceASI_LI_10_RULong Integer410
37ADJINFL SearchAdjust for InflationCB_Adjust_For_InflationBoolean20
38INFLAEQU SearchInflation Equity Account IndexLI_14Long Integer414
39INFLAREV SearchInflation Revenue Account IndexLI_14Long Integer414
40USRDEFS1 SearchUser Defined String 1STR30String3230
41USRDEFS2 SearchUser Defined String 2STR30String3230
42ACCTENTR SearchAllow Account EntryCB_Allow_Account_EntryBoolean20
azurecurveProductsSmartList (1493)PathnameSmartList Account Master (ASIEXP01)

Leave a Reply

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