ASI GL Transaction SmartList (ASIEXP12)

azurecurve Products SmartList (1493)PathnameASI GL Transaction SmartList (ASIEXP12)

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

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 No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	ASI_Order_By	ASI_Order_By	Long Integer	LI_14	14
2	JRNENTRY	Journal Entry	Long Integer	LI8_U0	8
3	BACHNUMB	Batch Number	String	STR15_LBAU	15
4	BCHSOURC	Batch Source	String	STR15	15
5	ASI_Document_Status	ASI_Document_Status	Integer	INT	0
6	RCTRXSEQ	Recurring TRX Sequence	Currency	DLR19_$S2	19
7	SOURCDOC	Source Document	String	STR10_Source_Document	10
	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
8	REFRENCE	Reference	String	STR30	30
9	DSCRIPTN	Description	String	STR30	30
10	TRXDATE	TRX Date	Date	DT_Date	6
11	ACTINDX	Account Index	Long Integer	LI_14	14
	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
12	POLLDTRX	Polled Transaction	Boolean	YN	0
13	RVRSNGDT	Reversing Date	Date	DT_Date	6
14	RCRNGTRX	Recurring TRX	Boolean	YN	0
15	BALFRCLC	Balance For Calculation	Integer	GB	0
16	PSTGSTUS	Posting Status	Integer	INT	0
17	LASTUSER	Last User	String	User_ID	15
18	LSTDTEDT	Last Date Edited	Date	DT_Date	6
19	USWHPSTD	User Who Posted	String	User_ID	15
	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
20	ORGNTSRC	Originating Source	String	STR15	15
21	ORGNATYP	Originating Type	Integer	INT	0
22	QKOFSET	Quick Offset	Integer	INT	0
23	TRXTYPE	Transaction Type	Integer	GB	0
24	SQNCLINE	Sequence Line	Currency	DLR19_$S2	19
25	TRXSORCE	TRX Source	String	STR13	13
26	RVTRXSRC	Reversing TRX Source	String	STR13	13
27	SERIES	Series	Integer	DDL_Series	0
28	ORTRXTYP	Originating TRX Type	Integer	INT	0
29	ORCTRNUM	Originating Control Number	String	STR20	20
30	ORMSTRID	Originating Master ID	String	STR30	30
31	ORMSTRNM	Originating Master Name	String	STR64	64
32	ORDOCNUM	Originating Document Number	String	STR20	20
33	ORPSTDDT	Originating Posted Date	Date	DT_Date	6
34	ORTRXSRC	Originating TRX Source	String	STR13	13
35	OrigDTASeries	Originating DTA Series	Integer	INT	0
36	OrigSeqNum	Originating Sequence Number	Long Integer	Long Int	8
37	DTA_GL_Status	DTA GL Status	Integer	INT1	1
38	DTAControlNum	DTA Control Number	String	STR20	20
39	DTATRXType	DTA TRX Type	Integer	INT	0
40	DTA_Index	DTA Index	Currency	DLR14	14
41	CURNCYID	Currency ID	String	STR15_Currency_ID	15
	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
42	CURRNIDX	Currency Index	Integer	INT3	3
	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
43	RATETPID	Rate Type ID	String	STR15_Rate_Type_ID	15
	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
44	EXGTBLID	Exchange Table ID	String	STR15_Exchange_Table_ID	15
	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
45	XCHGRATE	Exchange Rate	Currency (Variable)	DLR14_Exchange_Rate	14
46	EXCHDATE	Exchange Date	Date	DT_Date	6
47	TIME1	Time	Time	TM6	6
48	RTCLCMTD	Rate Calculation Method	Integer	GB	0
49	NOTEINDX	Note Index	Currency	DLR14	14
	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
50	CRDTAMNT	Credit Amount	Currency	DLR19_$S2	19
51	DEBITAMT	Debit Amount	Currency	DLR19_$S2	19
52	ORCRDAMT	Originating Credit Amount	Currency	DLR19_$S2	19
53	ORDBTAMT	Originating Debit Amount	Currency	DLR19_$S2	19
54	PERIODID	Period ID	Integer	INT3	3
55	OPENYEAR	Open Year	Integer	INT4_S0	4
56	HSTYEAR	History Year	Integer	INT4_S0	4
57	CLOSEDYR	Closed Year	Integer	INT4_S0	4
58	HISTRX	History TRX	Boolean	Boolean	0
59	REVPRDID	Reversing Period ID	Integer	INT3	3
60	REVYEAR	Reversing Year	Integer	INT4_S0	4
61	REVCLYR	Reversing Closed Year	Integer	INT4_S0	4
62	REVHIST	Reversing History TRX	Boolean	Boolean	0
63	ERRSTATE	Error State	Long Integer	Long Int	8
64	ICTRX	IC TRX	Boolean	CB_IC_TRX	0
	Click to show/hide Intercompany flag 0 Not intercompany. 1 Intercompany
65	ORCOMID	Originating Company ID	String	STR5_IC_ID	5
	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
66	ORIGINJE	Originating Journal Entry	Long Integer	LI8_U0	8
67	ICDISTS	ICDists	Boolean	Boolean	0
	Click to show/hide Intercompany distirubtions 0 Not intercompany. 1 Intercompany distributions present.
68	PRNTSTUS	Printing Status	Integer	INT	0
69	DOCDATE	Document Date	Date	DT	8
70	ACTNUMBR_1	Account Number:Account_Segment_Pool1	String	Account_Segment_Pool1	6
71	ACTNUMBR_2	Account Number:Account_Segment_Pool2	String	Account_Segment_Pool2	6
72	ACTNUMBR_3	Account Number:Account_Segment_Pool3	String	Account_Segment_Pool3	6
73	ACTNUMBR_4	Account Number:Account_Segment_Pool4	String	Account_Segment_Pool4	6
74	ACTNUMBR_5	Account Number:Account_Segment_Pool5	String	Account_Segment_Pool5	6
75	ACTNUMBR_6	Account Number:Account_Segment_Pool6	String	Account_Segment_Pool6	6
76	ACTNUMBR_7	Account Number:Account_Segment_Pool7	String	Account_Segment_Pool7	6
77	ACTNUMBR_8	Account Number:Account_Segment_Pool8	String	Account_Segment_Pool8	6
78	ACTNUMBR_9	Account Number:Account_Segment_Pool9	String	Account_Segment_Pool9	6
79	ACTNUMBR_10	Account Number:Account_Segment_Pool10	String	Account_Segment_Pool10	6
80	ACTDESCR	Account Description	String	STR50	50
81	ACCTTYPE	Account Type	Integer	DDL_Account_Type	0
82	PSTNGTYP	Posting Type	Integer	GB	0
83	TRXAMNT	TRX Amount	Currency	DLR19_$S2	19
84	FXDORVAR	Fixed Or Variable	Integer	LB_Fixed_Or_Variable	0
85	INTERID	Intercompany ID	String	STR5_IC_ID	5
	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
86	ORIGAMT	Originating Amount	Currency	DLR19_$S2	19
87	DECPLACS	Decimal Places	Integer	DDL_Decimal_Places	0
88	ASI_Favorite_Sequence	ASI_Favorite_Sequence	Long Integer	ASI_LI_10_RU	10
89	GLHDRMSG	GL HDR Messages	Long Integer	ML_GL_HDR_Messages	0
90	GLHDRMS2	GL HDR Messages2	Long Integer	ML_GL_HDR_Messages_2	0
91	GLHDRVAL	GL Header Valid	Long Integer	ML_GL_Header_Valid	0
92	GLLINMSG	GL LINE Messages	Long Integer	ML_GL_LINE_Messages	0
93	GLLINMS2	GL LINE Messages2	Long Integer	ML_GL_LINE_Messages2	0
94	GLLINVAL	GL Line Valid	Long Integer	ML_GL_Line_Valid	0
95	DENXRATE	Denomination Exchange Rate	Currency (Variable)	DLR14_Exchange_Rate	14
96	MCTRXSTT	MC Transaction State	Integer	INT1	1
97	PPSGNMBR	Period Posting Number	Long Integer	LI8_U0	8
98	PSTGNMBR	Posting Number	Long Integer	LI8_U0	8
99	LNESTAT	Line Status	Integer	INT	0
100	ASI_Account_Type	ASI_Account_Type	Integer	DDL_Account_Type	0
101	ASI_Posting_Type	ASI_Posting_Type	Integer	ASI_Posting_Type	0
102	MNACSGMT	Main Account Segment	String	STR66_Seg_ID	66
103	ACCATNUM	Account Category Number	Integer	INT2_U0	2
	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
104	ACTIVE	Active	Boolean	CB_Active	0
105	TPCLBLNC	Typical Balance	Integer	GB	0
106	ASI_Decimal_Places	ASI_Decimal_Places	Integer	DDL_Decimal_Places	0
107	ASI_Account_Description	ASI_Account_Description	String	STR50	50
108	ASI_Fixed_Or_Variable	ASI_Fixed_Or_Variable	Integer	LB_Fixed_Or_Variable	0
109	ASI_Balance_For_Calculat	ASI_Balance_For_Calculation	Integer	ASI_Balance_For_Calculation	0
110	DSPLKUPS	Display In Lookups	Long Integer	ML_Display_In_Lookups	0
111	CNVRMTHD	Conversion Method	Integer	DDL_Conversion_Method	0
112	HSTRCLRT	Historical Rate	Currency (Variable)	DLR14_Exchange_Rate	14
113	NOTEINDX1	ASI_Note_Index	Currency	DLR14	14
114	CREATDDT	Created Date	Date	DT	8
115	MODIFDT	Modified Date	Date	DT	8
116	USERDEF1	User Defined 1	String	STR20	20
117	USERDEF2	User Defined 2	String	STR20	20
118	PostSlsIn	Post Sales In	Integer	SumOrDetail	0
119	PostIvIn	Post Inventory In	Integer	SumOrDetail	0
120	PostPurchIn	Post Purchasing In	Integer	SumOrDetail	0
121	PostPRIn	Post Payroll In	Integer	SumOrDetail	0
122	ADJINFL	Adjust for Inflation	Boolean	CB_Adjust_For_Inflation	0
123	INFLAEQU	Inflation Equity Account Index	Long Integer	LI_14	14
124	INFLAREV	Inflation Revenue Account Index	Long Integer	LI_14	14
125	ALIAS	Alias	Integer	INT	0
126	CorrespondingUnit	CorrespondingUnit	String	STR5_IC_ID	5
127	Tax_Date	Tax Date	Date	DT	8
128	VOIDED	Voided	Boolean	CB	0
129	Back_Out_JE	Back Out JE	Long Integer	LI8_U0	8
130	Back_Out_JE_Year	Back Out JE Year	Integer	INT	0
131	Original_JE	Original JE	Long Integer	LI8_U0	8
132	Original_JE_Year	Original JE Year	Integer	INT	0
133	Original_JE_Seq_Num	Original JE Seq Num	Currency	DLR19_$S2	19
134	Correcting_JE	Correcting JE	Long Integer	LI8_U0	8
135	Correcting_JE_Year	Correcting JE Year	Integer	INT	0
136	User_Defined_Text01	User Defined Text01	String	STR30	30
137	User_Defined_Text02	User Defined Text02	String	STR30	30

azurecurve Products SmartList (1493)PathnameASI GL Transaction SmartList (ASIEXP12)

Leave a Reply Cancel reply