ASI_MDA_SmartList (ASIEXP14)

azurecurveProductsSmartList (1493)PathnameASI_MDA_SmartList (ASIEXP14)

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

Product: SmartList (1493)
Series:

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 NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1ASI_Order_By SearchASI_Order_ByLong IntegerLI_1414
2ACTINDX SearchAccount IndexLong IntegerLI_1414
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
3CODEAMT SearchDTA_AmountCurrencyDLR17_RBS0_STR$17
4CODEID SearchDTA_Code_IDStringSTR15_LBAU15
5GROUPID SearchDTA_Group_IDStringSTR15_LBAU15
6POSTDESC SearchDTA_Posting_DescrStringSTR5050
7DTAQNTY SearchDTA_QuantityCurrencyDLR1414
8DTAREF SearchDTA_ReferenceStringSTR2525
9DTASERIES SearchDTA_SeriesIntegerINT2_U02
10DOCNUMBR SearchDocument NumberStringSTR20_Document_Number20
11RMDTYPAL SearchRM Document Type-AllIntegerINT22
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
12SEQNUMBR SearchSequence NumberLong IntegerLI_Sequence_Number10
13TRXDATE SearchTRX DateDateDT_Date6
14DTA_GL_Reference SearchDTA_GL_ReferenceStringSTR2525
15GROUPAMT SearchDTA_Group_AmountCurrencyDLR17_RBS0_STR$17
16JRNENTRY SearchJournal EntryLong IntegerLI8_U08
17PSTGSTUS SearchPosting StatusIntegerINT0
18ACTNUMBR_1 SearchAccount Number:Account_Segment_Pool1StringAccount_Segment_Pool16
19ACTNUMBR_2 SearchAccount Number:Account_Segment_Pool2StringAccount_Segment_Pool26
20ACTNUMBR_3 SearchAccount Number:Account_Segment_Pool3StringAccount_Segment_Pool36
21ACTNUMBR_4 SearchAccount Number:Account_Segment_Pool4StringAccount_Segment_Pool46
22ACTNUMBR_5 SearchAccount Number:Account_Segment_Pool5StringAccount_Segment_Pool56
23ACTNUMBR_6 SearchAccount Number:Account_Segment_Pool6StringAccount_Segment_Pool66
24ACTNUMBR_7 SearchAccount Number:Account_Segment_Pool7StringAccount_Segment_Pool76
25ACTNUMBR_8 SearchAccount Number:Account_Segment_Pool8StringAccount_Segment_Pool86
26ACTNUMBR_9 SearchAccount Number:Account_Segment_Pool9StringAccount_Segment_Pool96
27ACTNUMBR_10 SearchAccount Number:Account_Segment_Pool10StringAccount_Segment_Pool106
28ASI_Favorite_Sequence SearchASI_Favorite_SequenceLong IntegerASI_LI_10_RU10
azurecurveProductsSmartList (1493)PathnameASI_MDA_SmartList (ASIEXP14)

Leave a Reply

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