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: Pathname

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 TypeSQL DB LengthKeyable Length
1ASI_Order_By SearchASI_Order_ByLI_14Long Integer414
2ACTINDX SearchAccount IndexLI_14Long Integer414
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_AmountDLR17_RBS0_STR$Currency1017
4CODEID SearchDTA_Code_IDSTR15_LBAUString1615
5GROUPID SearchDTA_Group_IDSTR15_LBAUString1615
6POSTDESC SearchDTA_Posting_DescrSTR50String5250
7DTAQNTY SearchDTA_QuantityDLR14Currency1014
8DTAREF SearchDTA_ReferenceSTR25String2625
9DTASERIES SearchDTA_SeriesINT2_U0Integer22
10DOCNUMBR SearchDocument NumberSTR20_Document_NumberString2220
11RMDTYPAL SearchRM Document Type-AllINT2Integer22
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 NumberLI_Sequence_NumberLong Integer410
13TRXDATE SearchTRX DateDT_DateDate46
14DTA_GL_Reference SearchDTA_GL_ReferenceSTR25String2625
15GROUPAMT SearchDTA_Group_AmountDLR17_RBS0_STR$Currency1017
16JRNENTRY SearchJournal EntryLI8_U0Long Integer48
17PSTGSTUS SearchPosting StatusINTInteger20
18ACTNUMBR_1 SearchAccount Number:Account_Segment_Pool1Account_Segment_Pool1String86
19ACTNUMBR_2 SearchAccount Number:Account_Segment_Pool2Account_Segment_Pool2String86
20ACTNUMBR_3 SearchAccount Number:Account_Segment_Pool3Account_Segment_Pool3String86
21ACTNUMBR_4 SearchAccount Number:Account_Segment_Pool4Account_Segment_Pool4String86
22ACTNUMBR_5 SearchAccount Number:Account_Segment_Pool5Account_Segment_Pool5String86
23ACTNUMBR_6 SearchAccount Number:Account_Segment_Pool6Account_Segment_Pool6String86
24ACTNUMBR_7 SearchAccount Number:Account_Segment_Pool7Account_Segment_Pool7String86
25ACTNUMBR_8 SearchAccount Number:Account_Segment_Pool8Account_Segment_Pool8String86
26ACTNUMBR_9 SearchAccount Number:Account_Segment_Pool9Account_Segment_Pool9String86
27ACTNUMBR_10 SearchAccount Number:Account_Segment_Pool10Account_Segment_Pool10String86
28ASI_Favorite_Sequence SearchASI_Favorite_SequenceASI_LI_10_RULong Integer410
azurecurveProductsSmartList (1493)PathnameASI_MDA_SmartList (ASIEXP14)

Leave a Reply

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