ASI GL Transaction SmartList (ASIEXP12)

azurecurveProductsSmartList (1493)PathnameASI GL Transaction SmartList (ASIEXP12)

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

Product: SmartList (1493)
Series: Pathname

Display Name: ASI GL Transaction SmartList
Physical Name: ASIEXP12
Technical Name: ASI_GL_TRX_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
2JRNENTRY SearchJournal EntryLI8_U0Long Integer48
3BACHNUMB SearchBatch NumberSTR15_LBAUString1615
4BCHSOURC SearchBatch SourceSTR15String1615
5ASI_Document_Status SearchASI_Document_StatusINTInteger20
6RCTRXSEQ SearchRecurring TRX SequenceDLR19_$S2Currency1019
7SOURCDOC SearchSource DocumentSTR10_Source_DocumentString1210
Key to the Source Document Master (SY00900).

Click to show/hide

SELECT
       ['ASI GL Transaction SmartList'].SOURCDOC AS 'ASI GL Transaction SmartList-Source Document'
       ,['Source Document Master'].SOURCDOC AS 'Source Document Master-Source Document'
FROM
       ASIEXP12 AS ['ASI GL Transaction SmartList']
INNER JOIN
       SY00900 AS ['Source Document Master']
              ON
                     ['ASI GL Transaction SmartList'].SOURCDOC = ['Source Document Master'].SOURCDOC
8REFRENCE SearchReferenceSTR30String3230
9DSCRIPTN SearchDescriptionSTR30String3230
10TRXDATE SearchTRX DateDT_DateDate46
11ACTINDX SearchAccount IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['ASI GL Transaction SmartList'].ACTINDX AS 'ASI GL Transaction SmartList-Account Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP12 AS ['ASI GL Transaction SmartList']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['ASI GL Transaction SmartList'].ACTINDX = ['Account Index Master'].ACTINDX
12POLLDTRX SearchPolled TransactionYNBoolean20
13RVRSNGDT SearchReversing DateDT_DateDate46
14RCRNGTRX SearchRecurring TRXYNBoolean20
15BALFRCLC SearchBalance For CalculationGBInteger20
16PSTGSTUS SearchPosting StatusINTInteger20
17LASTUSER SearchLast UserUser_IDString1615
18LSTDTEDT SearchLast Date EditedDT_DateDate46
19USWHPSTD SearchUser Who PostedUser_IDString1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['ASI GL Transaction SmartList'].USWHPSTD AS 'ASI GL Transaction SmartList-User Who Posted'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       ASIEXP12 AS ['ASI GL Transaction SmartList']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['ASI GL Transaction SmartList'].USWHPSTD = ['Users Master'].USERID
20ORGNTSRC SearchOriginating SourceSTR15String1615
21ORGNATYP SearchOriginating TypeINTInteger20
22QKOFSET SearchQuick OffsetINTInteger20
23TRXTYPE SearchTransaction TypeGBInteger20
24SQNCLINE SearchSequence LineDLR19_$S2Currency1019
25TRXSORCE SearchTRX SourceSTR13String1413
26RVTRXSRC SearchReversing TRX SourceSTR13String1413
27SERIES SearchSeriesDDL_SeriesInteger20
28ORTRXTYP SearchOriginating TRX TypeINTInteger20
29ORCTRNUM SearchOriginating Control NumberSTR20String2220
30ORMSTRID SearchOriginating Master IDSTR30String3230
31ORMSTRNM SearchOriginating Master NameSTR64String6664
32ORDOCNUM SearchOriginating Document NumberSTR20String2220
33ORPSTDDT SearchOriginating Posted DateDT_DateDate46
34ORTRXSRC SearchOriginating TRX SourceSTR13String1413
35OrigDTASeries SearchOriginating DTA SeriesINTInteger20
36OrigSeqNum SearchOriginating Sequence NumberLong IntLong Integer48
37DTA_GL_Status SearchDTA GL StatusINT1Integer21
38DTAControlNum SearchDTA Control NumberSTR20String2220
39DTATRXType SearchDTA TRX TypeINTInteger20
40DTA_Index SearchDTA IndexDLR14Currency1014
41CURNCYID SearchCurrency IDSTR15_Currency_IDString1615
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['ASI GL Transaction SmartList'].CURNCYID AS 'ASI GL Transaction SmartList-Currency ID'
       ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
       ASIEXP12 AS ['ASI GL Transaction SmartList']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['ASI GL Transaction SmartList'].CURNCYID = ['Currency Setup'].CURNCYID
42CURRNIDX SearchCurrency IndexINT3Integer23
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['ASI GL Transaction SmartList'].CURRNIDX AS 'ASI GL Transaction SmartList-Currency Index'
       ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
       ASIEXP12 AS ['ASI GL Transaction SmartList']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['ASI GL Transaction SmartList'].CURRNIDX = ['Currency Setup'].CURRNIDX
43RATETPID SearchRate Type IDSTR15_Rate_Type_IDString1615
Key to the Multicurrency Rate Type Setup (MC40100).

Click to show/hide

SELECT
       ['ASI GL Transaction SmartList'].RATETPID AS 'ASI GL Transaction SmartList-Rate Type ID'
       ,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
       ASIEXP12 AS ['ASI GL Transaction SmartList']
INNER JOIN
       MC40100 AS ['Multicurrency Rate Type Setup']
              ON
                     ['ASI GL Transaction SmartList'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID
44EXGTBLID SearchExchange Table IDSTR15_Exchange_Table_IDString1615
Key to the Multicurrency Exchange Rate Maintenance (MC00100).

Click to show/hide

SELECT
       ['ASI GL Transaction SmartList'].EXGTBLID AS 'ASI GL Transaction SmartList-Exchange Table ID'
       ,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID'
FROM
       ASIEXP12 AS ['ASI GL Transaction SmartList']
INNER JOIN
       DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance']
              ON
                     ['ASI GL Transaction SmartList'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID
45XCHGRATE SearchExchange RateDLR14_Exchange_RateCurrency (Variable)1014
46EXCHDATE SearchExchange DateDT_DateDate46
47TIME1 SearchTimeTM6Time46
48RTCLCMTD SearchRate Calculation MethodGBInteger20
49NOTEINDX SearchNote IndexDLR14Currency1014
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['ASI GL Transaction SmartList'].NOTEINDX AS 'ASI GL Transaction SmartList-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       ASIEXP12 AS ['ASI GL Transaction SmartList']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['ASI GL Transaction SmartList'].NOTEINDX = ['Record Notes Master'].NOTEINDX
50CRDTAMNT SearchCredit AmountDLR19_$S2Currency1019
51DEBITAMT SearchDebit AmountDLR19_$S2Currency1019
52ORCRDAMT SearchOriginating Credit AmountDLR19_$S2Currency1019
53ORDBTAMT SearchOriginating Debit AmountDLR19_$S2Currency1019
54PERIODID SearchPeriod IDINT3Integer23
55OPENYEAR SearchOpen YearINT4_S0Integer24
56HSTYEAR SearchHistory YearINT4_S0Integer24
57CLOSEDYR SearchClosed YearINT4_S0Integer24
58HISTRX SearchHistory TRXBooleanBoolean20
59REVPRDID SearchReversing Period IDINT3Integer23
60REVYEAR SearchReversing YearINT4_S0Integer24
61REVCLYR SearchReversing Closed YearINT4_S0Integer24
62REVHIST SearchReversing History TRXBooleanBoolean20
63ERRSTATE SearchError StateLong IntLong Integer48
64ICTRX SearchIC TRXCB_IC_TRXBoolean20

Click to show/hide Intercompany flag


0	Not intercompany.
1	Intercompany
65ORCOMID SearchOriginating Company IDSTR5_IC_IDString65
Key to the Company Master (SY01500).

Click to show/hide

SELECT
       ['ASI GL Transaction SmartList'].ORCOMID AS 'ASI GL Transaction SmartList-Originating Company ID'
       ,['Company Master'].CMPANYID AS 'Company Master-Company ID'
FROM
       ASIEXP12 AS ['ASI GL Transaction SmartList']
INNER JOIN
       DYNAMICS..SY01500 AS ['Company Master']
              ON
                     ['ASI GL Transaction SmartList'].ORCOMID = ['Company Master'].CMPANYID
66ORIGINJE SearchOriginating Journal EntryLI8_U0Long Integer48
67ICDISTS SearchICDistsBooleanBoolean20

Click to show/hide Intercompany distirubtions


0	Not intercompany.
1	Intercompany distributions present.
68PRNTSTUS SearchPrinting StatusINTInteger20
69DOCDATE SearchDocument DateDTDate48
70ACTNUMBR_1 SearchAccount Number:Account_Segment_Pool1Account_Segment_Pool1String86
71ACTNUMBR_2 SearchAccount Number:Account_Segment_Pool2Account_Segment_Pool2String86
72ACTNUMBR_3 SearchAccount Number:Account_Segment_Pool3Account_Segment_Pool3String86
73ACTNUMBR_4 SearchAccount Number:Account_Segment_Pool4Account_Segment_Pool4String86
74ACTNUMBR_5 SearchAccount Number:Account_Segment_Pool5Account_Segment_Pool5String86
75ACTNUMBR_6 SearchAccount Number:Account_Segment_Pool6Account_Segment_Pool6String86
76ACTNUMBR_7 SearchAccount Number:Account_Segment_Pool7Account_Segment_Pool7String86
77ACTNUMBR_8 SearchAccount Number:Account_Segment_Pool8Account_Segment_Pool8String86
78ACTNUMBR_9 SearchAccount Number:Account_Segment_Pool9Account_Segment_Pool9String86
79ACTNUMBR_10 SearchAccount Number:Account_Segment_Pool10Account_Segment_Pool10String86
80ACTDESCR SearchAccount DescriptionSTR50String5250
81ACCTTYPE SearchAccount TypeDDL_Account_TypeInteger20
82PSTNGTYP SearchPosting TypeGBInteger20
83TRXAMNT SearchTRX AmountDLR19_$S2Currency1019
84FXDORVAR SearchFixed Or VariableLB_Fixed_Or_VariableInteger20
85INTERID SearchIntercompany IDSTR5_IC_IDString65
Key to the Company Master (SY01500).

Click to show/hide

SELECT
       ['ASI GL Transaction SmartList'].INTERID AS 'ASI GL Transaction SmartList-Intercompany ID'
       ,['Company Master'].INTERID AS 'Company Master-Intercompany ID'
FROM
       ASIEXP12 AS ['ASI GL Transaction SmartList']
INNER JOIN
       DYNAMICS..SY01500 AS ['Company Master']
              ON
                     ['ASI GL Transaction SmartList'].INTERID = ['Company Master'].INTERID
86ORIGAMT SearchOriginating AmountDLR19_$S2Currency1019
87DECPLACS SearchDecimal PlacesDDL_Decimal_PlacesInteger20
88ASI_Favorite_Sequence SearchASI_Favorite_SequenceASI_LI_10_RULong Integer410
89GLHDRMSG SearchGL HDR MessagesML_GL_HDR_MessagesLong Integer40
90GLHDRMS2 SearchGL HDR Messages2ML_GL_HDR_Messages_2Long Integer40
91GLHDRVAL SearchGL Header ValidML_GL_Header_ValidLong Integer40
92GLLINMSG SearchGL LINE MessagesML_GL_LINE_MessagesLong Integer40
93GLLINMS2 SearchGL LINE Messages2ML_GL_LINE_Messages2Long Integer40
94GLLINVAL SearchGL Line ValidML_GL_Line_ValidLong Integer40
95DENXRATE SearchDenomination Exchange RateDLR14_Exchange_RateCurrency (Variable)1014
96MCTRXSTT SearchMC Transaction StateINT1Integer21
97PPSGNMBR SearchPeriod Posting NumberLI8_U0Long Integer48
98PSTGNMBR SearchPosting NumberLI8_U0Long Integer48
99LNESTAT SearchLine StatusINTInteger20
100ASI_Account_Type SearchASI_Account_TypeDDL_Account_TypeInteger20
101ASI_Posting_Type SearchASI_Posting_TypeASI_Posting_TypeInteger20
102MNACSGMT SearchMain Account SegmentSTR66_Seg_IDString6866
103ACCATNUM SearchAccount Category NumberINT2_U0Integer22
Key to the Account Category Master (GL00102).

Click to show/hide

SELECT
       ['ASI GL Transaction SmartList'].ACCATNUM AS 'ASI GL Transaction SmartList-Account Category Number'
       ,['Account Category Master'].ACCATNUM AS 'Account Category Master-Account Category Number'
FROM
       ASIEXP12 AS ['ASI GL Transaction SmartList']
INNER JOIN
       GL00102 AS ['Account Category Master']
              ON
                     ['ASI GL Transaction SmartList'].ACCATNUM = ['Account Category Master'].ACCATNUM
104ACTIVE SearchActiveCB_ActiveBoolean20
105TPCLBLNC SearchTypical BalanceGBInteger20
106ASI_Decimal_Places SearchASI_Decimal_PlacesDDL_Decimal_PlacesInteger20
107ASI_Account_Description SearchASI_Account_DescriptionSTR50String5250
108ASI_Fixed_Or_Variable SearchASI_Fixed_Or_VariableLB_Fixed_Or_VariableInteger20
109ASI_Balance_For_Calculat SearchASI_Balance_For_CalculationASI_Balance_For_CalculationInteger20
110DSPLKUPS SearchDisplay In LookupsML_Display_In_LookupsLong Integer40
111CNVRMTHD SearchConversion MethodDDL_Conversion_MethodInteger20
112HSTRCLRT SearchHistorical RateDLR14_Exchange_RateCurrency (Variable)1014
113NOTEINDX1 SearchASI_Note_IndexDLR14Currency1014
114CREATDDT SearchCreated DateDTDate48
115MODIFDT SearchModified DateDTDate48
116USERDEF1 SearchUser Defined 1STR20String2220
117USERDEF2 SearchUser Defined 2STR20String2220
118PostSlsIn SearchPost Sales InSumOrDetailInteger20
119PostIvIn SearchPost Inventory InSumOrDetailInteger20
120PostPurchIn SearchPost Purchasing InSumOrDetailInteger20
121PostPRIn SearchPost Payroll InSumOrDetailInteger20
122ADJINFL SearchAdjust for InflationCB_Adjust_For_InflationBoolean20
123INFLAEQU SearchInflation Equity Account IndexLI_14Long Integer414
124INFLAREV SearchInflation Revenue Account IndexLI_14Long Integer414
125ALIAS SearchAliasINTInteger20
126CorrespondingUnit SearchCorrespondingUnitSTR5_IC_IDString65
127Tax_Date SearchTax DateDTDate48
128VOIDED SearchVoidedCBBoolean20
129Back_Out_JE SearchBack Out JELI8_U0Long Integer48
130Back_Out_JE_Year SearchBack Out JE YearINTInteger20
131Original_JE SearchOriginal JELI8_U0Long Integer48
132Original_JE_Year SearchOriginal JE YearINTInteger20
133Original_JE_Seq_Num SearchOriginal JE Seq NumDLR19_$S2Currency1019
134Correcting_JE SearchCorrecting JELI8_U0Long Integer48
135Correcting_JE_Year SearchCorrecting JE YearINTInteger20
azurecurveProductsSmartList (1493)PathnameASI GL Transaction SmartList (ASIEXP12)

Leave a Reply

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