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:

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 TypeLength
1ASI_Order_By SearchASI_Order_ByLong IntegerLI_1414
2JRNENTRY SearchJournal EntryLong IntegerLI8_U08
3BACHNUMB SearchBatch NumberStringSTR15_LBAU15
4BCHSOURC SearchBatch SourceStringSTR1515
5ASI_Document_Status SearchASI_Document_StatusIntegerINT0
6RCTRXSEQ SearchRecurring TRX SequenceCurrencyDLR19_$S219
7SOURCDOC SearchSource DocumentStringSTR10_Source_Document10
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 SearchReferenceStringSTR3030
9DSCRIPTN SearchDescriptionStringSTR3030
10TRXDATE SearchTRX DateDateDT_Date6
11ACTINDX SearchAccount IndexLong IntegerLI_1414
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 TransactionBooleanYN0
13RVRSNGDT SearchReversing DateDateDT_Date6
14RCRNGTRX SearchRecurring TRXBooleanYN0
15BALFRCLC SearchBalance For CalculationIntegerGB0
16PSTGSTUS SearchPosting StatusIntegerINT0
17LASTUSER SearchLast UserStringUser_ID15
18LSTDTEDT SearchLast Date EditedDateDT_Date6
19USWHPSTD SearchUser Who PostedStringUser_ID15
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 SourceStringSTR1515
21ORGNATYP SearchOriginating TypeIntegerINT0
22QKOFSET SearchQuick OffsetIntegerINT0
23TRXTYPE SearchTransaction TypeIntegerGB0
24SQNCLINE SearchSequence LineCurrencyDLR19_$S219
25TRXSORCE SearchTRX SourceStringSTR1313
26RVTRXSRC SearchReversing TRX SourceStringSTR1313
27SERIES SearchSeriesIntegerDDL_Series0
28ORTRXTYP SearchOriginating TRX TypeIntegerINT0
29ORCTRNUM SearchOriginating Control NumberStringSTR2020
30ORMSTRID SearchOriginating Master IDStringSTR3030
31ORMSTRNM SearchOriginating Master NameStringSTR6464
32ORDOCNUM SearchOriginating Document NumberStringSTR2020
33ORPSTDDT SearchOriginating Posted DateDateDT_Date6
34ORTRXSRC SearchOriginating TRX SourceStringSTR1313
35OrigDTASeries SearchOriginating DTA SeriesIntegerINT0
36OrigSeqNum SearchOriginating Sequence NumberLong IntegerLong Int8
37DTA_GL_Status SearchDTA GL StatusIntegerINT11
38DTAControlNum SearchDTA Control NumberStringSTR2020
39DTATRXType SearchDTA TRX TypeIntegerINT0
40DTA_Index SearchDTA IndexCurrencyDLR1414
41CURNCYID SearchCurrency IDStringSTR15_Currency_ID15
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 IndexIntegerINT33
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 IDStringSTR15_Rate_Type_ID15
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 IDStringSTR15_Exchange_Table_ID15
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 RateCurrency (Variable)DLR14_Exchange_Rate14
46EXCHDATE SearchExchange DateDateDT_Date6
47TIME1 SearchTimeTimeTM66
48RTCLCMTD SearchRate Calculation MethodIntegerGB0
49NOTEINDX SearchNote IndexCurrencyDLR1414
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 AmountCurrencyDLR19_$S219
51DEBITAMT SearchDebit AmountCurrencyDLR19_$S219
52ORCRDAMT SearchOriginating Credit AmountCurrencyDLR19_$S219
53ORDBTAMT SearchOriginating Debit AmountCurrencyDLR19_$S219
54PERIODID SearchPeriod IDIntegerINT33
55OPENYEAR SearchOpen YearIntegerINT4_S04
56HSTYEAR SearchHistory YearIntegerINT4_S04
57CLOSEDYR SearchClosed YearIntegerINT4_S04
58HISTRX SearchHistory TRXBooleanBoolean0
59REVPRDID SearchReversing Period IDIntegerINT33
60REVYEAR SearchReversing YearIntegerINT4_S04
61REVCLYR SearchReversing Closed YearIntegerINT4_S04
62REVHIST SearchReversing History TRXBooleanBoolean0
63ERRSTATE SearchError StateLong IntegerLong Int8
64ICTRX SearchIC TRXBooleanCB_IC_TRX0

Click to show/hide Intercompany flag


0	Not intercompany.
1	Intercompany
65ORCOMID SearchOriginating Company IDStringSTR5_IC_ID5
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 EntryLong IntegerLI8_U08
67ICDISTS SearchICDistsBooleanBoolean0

Click to show/hide Intercompany distirubtions


0	Not intercompany.
1	Intercompany distributions present.
68PRNTSTUS SearchPrinting StatusIntegerINT0
69DOCDATE SearchDocument DateDateDT8
70ACTNUMBR_1 SearchAccount Number:Account_Segment_Pool1StringAccount_Segment_Pool16
71ACTNUMBR_2 SearchAccount Number:Account_Segment_Pool2StringAccount_Segment_Pool26
72ACTNUMBR_3 SearchAccount Number:Account_Segment_Pool3StringAccount_Segment_Pool36
73ACTNUMBR_4 SearchAccount Number:Account_Segment_Pool4StringAccount_Segment_Pool46
74ACTNUMBR_5 SearchAccount Number:Account_Segment_Pool5StringAccount_Segment_Pool56
75ACTNUMBR_6 SearchAccount Number:Account_Segment_Pool6StringAccount_Segment_Pool66
76ACTNUMBR_7 SearchAccount Number:Account_Segment_Pool7StringAccount_Segment_Pool76
77ACTNUMBR_8 SearchAccount Number:Account_Segment_Pool8StringAccount_Segment_Pool86
78ACTNUMBR_9 SearchAccount Number:Account_Segment_Pool9StringAccount_Segment_Pool96
79ACTNUMBR_10 SearchAccount Number:Account_Segment_Pool10StringAccount_Segment_Pool106
80ACTDESCR SearchAccount DescriptionStringSTR5050
81ACCTTYPE SearchAccount TypeIntegerDDL_Account_Type0
82PSTNGTYP SearchPosting TypeIntegerGB0
83TRXAMNT SearchTRX AmountCurrencyDLR19_$S219
84FXDORVAR SearchFixed Or VariableIntegerLB_Fixed_Or_Variable0
85INTERID SearchIntercompany IDStringSTR5_IC_ID5
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 AmountCurrencyDLR19_$S219
87DECPLACS SearchDecimal PlacesIntegerDDL_Decimal_Places0
88ASI_Favorite_Sequence SearchASI_Favorite_SequenceLong IntegerASI_LI_10_RU10
89GLHDRMSG SearchGL HDR MessagesLong IntegerML_GL_HDR_Messages0
90GLHDRMS2 SearchGL HDR Messages2Long IntegerML_GL_HDR_Messages_20
91GLHDRVAL SearchGL Header ValidLong IntegerML_GL_Header_Valid0
92GLLINMSG SearchGL LINE MessagesLong IntegerML_GL_LINE_Messages0
93GLLINMS2 SearchGL LINE Messages2Long IntegerML_GL_LINE_Messages20
94GLLINVAL SearchGL Line ValidLong IntegerML_GL_Line_Valid0
95DENXRATE SearchDenomination Exchange RateCurrency (Variable)DLR14_Exchange_Rate14
96MCTRXSTT SearchMC Transaction StateIntegerINT11
97PPSGNMBR SearchPeriod Posting NumberLong IntegerLI8_U08
98PSTGNMBR SearchPosting NumberLong IntegerLI8_U08
99LNESTAT SearchLine StatusIntegerINT0
100ASI_Account_Type SearchASI_Account_TypeIntegerDDL_Account_Type0
101ASI_Posting_Type SearchASI_Posting_TypeIntegerASI_Posting_Type0
102MNACSGMT SearchMain Account SegmentStringSTR66_Seg_ID66
103ACCATNUM SearchAccount Category NumberIntegerINT2_U02
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 SearchActiveBooleanCB_Active0
105TPCLBLNC SearchTypical BalanceIntegerGB0
106ASI_Decimal_Places SearchASI_Decimal_PlacesIntegerDDL_Decimal_Places0
107ASI_Account_Description SearchASI_Account_DescriptionStringSTR5050
108ASI_Fixed_Or_Variable SearchASI_Fixed_Or_VariableIntegerLB_Fixed_Or_Variable0
109ASI_Balance_For_Calculat SearchASI_Balance_For_CalculationIntegerASI_Balance_For_Calculation0
110DSPLKUPS SearchDisplay In LookupsLong IntegerML_Display_In_Lookups0
111CNVRMTHD SearchConversion MethodIntegerDDL_Conversion_Method0
112HSTRCLRT SearchHistorical RateCurrency (Variable)DLR14_Exchange_Rate14
113NOTEINDX1 SearchASI_Note_IndexCurrencyDLR1414
114CREATDDT SearchCreated DateDateDT8
115MODIFDT SearchModified DateDateDT8
116USERDEF1 SearchUser Defined 1StringSTR2020
117USERDEF2 SearchUser Defined 2StringSTR2020
118PostSlsIn SearchPost Sales InIntegerSumOrDetail0
119PostIvIn SearchPost Inventory InIntegerSumOrDetail0
120PostPurchIn SearchPost Purchasing InIntegerSumOrDetail0
121PostPRIn SearchPost Payroll InIntegerSumOrDetail0
122ADJINFL SearchAdjust for InflationBooleanCB_Adjust_For_Inflation0
123INFLAEQU SearchInflation Equity Account IndexLong IntegerLI_1414
124INFLAREV SearchInflation Revenue Account IndexLong IntegerLI_1414
125ALIAS SearchAliasIntegerINT0
126CorrespondingUnit SearchCorrespondingUnitStringSTR5_IC_ID5
127Tax_Date SearchTax DateDateDT8
128VOIDED SearchVoidedBooleanCB0
129Back_Out_JE SearchBack Out JELong IntegerLI8_U08
130Back_Out_JE_Year SearchBack Out JE YearIntegerINT0
131Original_JE SearchOriginal JELong IntegerLI8_U08
132Original_JE_Year SearchOriginal JE YearIntegerINT0
133Original_JE_Seq_Num SearchOriginal JE Seq NumCurrencyDLR19_$S219
134Correcting_JE SearchCorrecting JELong IntegerLI8_U08
135Correcting_JE_Year SearchCorrecting JE YearIntegerINT0
136User_Defined_Text01 SearchUser Defined Text01StringSTR3030
137User_Defined_Text02 SearchUser Defined Text02StringSTR3030
azurecurveProductsSmartList (1493)PathnameASI GL Transaction SmartList (ASIEXP12)

Leave a Reply

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