ASI_MDA_SmartList (ASIEXP14)

azurecurve Products SmartList (1493)PathnameASI_MDA_SmartList (ASIEXP14)

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

Display Name: ASI_MDA_SmartList
Physical Name: ASIEXP14
Technical Name: ASI_MDA_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	ACTINDX	Account Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['ASI_MDA_SmartList'].ACTINDX AS 'ASI_MDA_SmartList-Account Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM ASIEXP14 AS ['ASI_MDA_SmartList'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['ASI_MDA_SmartList'].ACTINDX = ['Account Index Master'].ACTINDX
3	CODEAMT	DTA_Amount	Currency	DLR17_RBS0_STR$	17
4	CODEID	DTA_Code_ID	String	STR15_LBAU	15
5	GROUPID	DTA_Group_ID	String	STR15_LBAU	15
6	POSTDESC	DTA_Posting_Descr	String	STR50	50
7	DTAQNTY	DTA_Quantity	Currency	DLR14	14
8	DTAREF	DTA_Reference	String	STR25	25
9	DTASERIES	DTA_Series	Integer	INT2_U0	2
10	DOCNUMBR	Document Number	String	STR20_Document_Number	20
11	RMDTYPAL	RM Document Type-All	Integer	INT2	2
	Document Type records the type of document. Click to show/hide the Document Types 0 Balance Carried Forward 1 Sales / Invoice 2 Scheduled Payments 3 Debit Memo 4 Finance Charge 5 Service Repairs 6 Warranties 7 Credit Memo 8 Returns 9 Payments
12	SEQNUMBR	Sequence Number	Long Integer	LI_Sequence_Number	10
13	TRXDATE	TRX Date	Date	DT_Date	6
14	DTA_GL_Reference	DTA_GL_Reference	String	STR25	25
15	GROUPAMT	DTA_Group_Amount	Currency	DLR17_RBS0_STR$	17
16	JRNENTRY	Journal Entry	Long Integer	LI8_U0	8
17	PSTGSTUS	Posting Status	Integer	INT	0
18	ACTNUMBR_1	Account Number:Account_Segment_Pool1	String	Account_Segment_Pool1	6
19	ACTNUMBR_2	Account Number:Account_Segment_Pool2	String	Account_Segment_Pool2	6
20	ACTNUMBR_3	Account Number:Account_Segment_Pool3	String	Account_Segment_Pool3	6
21	ACTNUMBR_4	Account Number:Account_Segment_Pool4	String	Account_Segment_Pool4	6
22	ACTNUMBR_5	Account Number:Account_Segment_Pool5	String	Account_Segment_Pool5	6
23	ACTNUMBR_6	Account Number:Account_Segment_Pool6	String	Account_Segment_Pool6	6
24	ACTNUMBR_7	Account Number:Account_Segment_Pool7	String	Account_Segment_Pool7	6
25	ACTNUMBR_8	Account Number:Account_Segment_Pool8	String	Account_Segment_Pool8	6
26	ACTNUMBR_9	Account Number:Account_Segment_Pool9	String	Account_Segment_Pool9	6
27	ACTNUMBR_10	Account Number:Account_Segment_Pool10	String	Account_Segment_Pool10	6
28	ASI_Favorite_Sequence	ASI_Favorite_Sequence	Long Integer	ASI_LI_10_RU	10

azurecurve Products SmartList (1493)PathnameASI_MDA_SmartList (ASIEXP14)

Click to show/hide

Click to show/hide the Document Types

Leave a Reply Cancel reply