SmartList Inventory Transaction Amount (ASIEXP19)

azurecurveProductsSmartList (1493)PathnameSmartList Inventory Transaction Amount (ASIEXP19)

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

Product: SmartList (1493)
Series: Pathname

Display Name: SmartList Inventory Transaction Amount
Physical Name: ASIEXP19
Technical Name: ASI_IV_TRX_LINE_Explorer

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1ASI_Order_By SearchASI_Order_ByLI_14Long Integer14
2DOCNUMBR SearchDocument NumberSTR20_Document_NumberString20
3IVDOCTYP SearchIV Document TypeDDL_IV_Document_TypeInteger0
4ASI_Document_Status SearchASI_Document_StatusINTInteger0
5ITEMNMBR SearchItem NumberSTR30_Item_NumberString30
Key to the Item Master (IV00101).

Click to show/hide

SELECT
       ['SmartList Inventory Transaction Amount'].ITEMNMBR AS 'SmartList Inventory Transaction Amount-Item Number'
       ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
       ASIEXP19 AS ['SmartList Inventory Transaction Amount']
INNER JOIN
       IV00101 AS ['Item Master']
              ON
                     ['SmartList Inventory Transaction Amount'].ITEMNMBR = ['Item Master'].ITEMNMBR
6LNSEQNBR SearchLine SEQ NumberSequence_NumberCurrency19
7UOFM SearchU Of MU_Of_MString8
8QTYBSUOM SearchQTY In Base U Of MDLR17_QTY_RBS0_STRCurrency17
9TRXQTY SearchTRX QTYDLR17_QTY_RBS0_STRCurrency17
10UNITCOST SearchUnit CostDLR17_RBS0_UTR$Currency17
11EXTDCOST SearchExtended CostDLR17_RBS0_UTR$Currency17
12TRXLOCTN SearchTRX LocationSTR10_Location_CodeString10
Key to the Site Setup (IV40700).

Click to show/hide

SELECT
       ['SmartList Inventory Transaction Amount'].TRXLOCTN AS 'SmartList Inventory Transaction Amount-TRX Location'
       ,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
       ASIEXP19 AS ['SmartList Inventory Transaction Amount']
INNER JOIN
       IV40700 AS ['Site Setup']
              ON
                     ['SmartList Inventory Transaction Amount'].TRXLOCTN = ['Site Setup'].LOCNCODE
13TRNSTLOC SearchTransfer To LocationSTR10_Location_CodeString10
Key to the Site Setup (IV40700).

Click to show/hide

SELECT
       ['SmartList Inventory Transaction Amount'].TRNSTLOC AS 'SmartList Inventory Transaction Amount-Transfer To Location'
       ,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
       ASIEXP19 AS ['SmartList Inventory Transaction Amount']
INNER JOIN
       IV40700 AS ['Site Setup']
              ON
                     ['SmartList Inventory Transaction Amount'].TRNSTLOC = ['Site Setup'].LOCNCODE
14TRFQTYTY SearchTransfer From QTY TypeDDL_QTY_TypeInteger0
15TRTQTYTY SearchTransfer To QTY TypeDDL_QTY_TypeInteger0
16IVIVINDX SearchIV IV IndexLI_14Long Integer14
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Inventory Transaction Amount'].IVIVINDX AS 'SmartList Inventory Transaction Amount-IV IV Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP19 AS ['SmartList Inventory Transaction Amount']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Inventory Transaction Amount'].IVIVINDX = ['Account Index Master'].ACTINDX
17IVIVOFIX SearchIV IV Offset IndexLI_14Long Integer14
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Inventory Transaction Amount'].IVIVOFIX AS 'SmartList Inventory Transaction Amount-IV IV Offset Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP19 AS ['SmartList Inventory Transaction Amount']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Inventory Transaction Amount'].IVIVOFIX = ['Account Index Master'].ACTINDX
18IVWLNMSG SearchIV WORK LINE MessagesIV_WORK_LINE_MessagesLong Integer0
19TRXSORCE SearchTRX SourceSTR13String13
20DOCDATE SearchDocument DateDTDate8
21HSTMODUL SearchHistory ModuleSTR3String3
22CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString15
Key to the RM Customer MSTR (RM00101).

Click to show/hide

SELECT
       ['SmartList Inventory Transaction Amount'].CUSTNMBR AS 'SmartList Inventory Transaction Amount-Customer Number'
       ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
       ASIEXP19 AS ['SmartList Inventory Transaction Amount']
INNER JOIN
       RM00101 AS ['RM Customer MSTR']
              ON
                     ['SmartList Inventory Transaction Amount'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
23ITEMDESC SearchItem DescriptionSTR100String100
24NOTEINDX SearchNote IndexDLR14Currency14
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['SmartList Inventory Transaction Amount'].NOTEINDX AS 'SmartList Inventory Transaction Amount-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       ASIEXP19 AS ['SmartList Inventory Transaction Amount']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['SmartList Inventory Transaction Amount'].NOTEINDX = ['Record Notes Master'].NOTEINDX
25ITMSHNAM SearchItem Short NameSTR15String15
26ITEMTYPE SearchItem TypeDDL_Item_TypeInteger0
27ITMGEDSC SearchItem Generic DescriptionSTR10String10
28STNDCOST SearchStandard CostDLR17_RBS0_UTR$Currency17
29CURRCOST SearchCurrent CostDLR17_RBS0_UTR$Currency17
30LISTPRCE SearchList PriceDLR17_RBS0_STR$Currency17
31ITEMSHWT SearchItem Shipping WeightLI6_RBS2_UTLong Integer6
32DECPLQTY SearchDecimal Places QTYSDDL_Decimal_Places_QTYSInteger0
33DECPLCUR SearchDecimal Places CurrencyDDL_Decimal_Places_DollarsInteger0
34ITMTSHID SearchItem Tax Schedule IDSTR15_LBAUString15
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['SmartList Inventory Transaction Amount'].ITMTSHID AS 'SmartList Inventory Transaction Amount-Item Tax Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       ASIEXP19 AS ['SmartList Inventory Transaction Amount']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['SmartList Inventory Transaction Amount'].ITMTSHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
35TAXOPTNS SearchTax OptionsDDL_Tax_OptionsInteger0
36COMMCODE SearchCommission CodeSTR15_LBAUString15
37IVCOGSIX SearchIV COGS IndexLI_14Long Integer14
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Inventory Transaction Amount'].IVCOGSIX AS 'SmartList Inventory Transaction Amount-IV COGS Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP19 AS ['SmartList Inventory Transaction Amount']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Inventory Transaction Amount'].IVCOGSIX = ['Account Index Master'].ACTINDX
38IVSLSIDX SearchIV Sales IndexLI_14Long Integer14
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Inventory Transaction Amount'].IVSLSIDX AS 'SmartList Inventory Transaction Amount-IV Sales Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP19 AS ['SmartList Inventory Transaction Amount']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Inventory Transaction Amount'].IVSLSIDX = ['Account Index Master'].ACTINDX
39IVSLDSIX SearchIV Sales Discounts IndexLI_14Long Integer14
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Inventory Transaction Amount'].IVSLDSIX AS 'SmartList Inventory Transaction Amount-IV Sales Discounts Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP19 AS ['SmartList Inventory Transaction Amount']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Inventory Transaction Amount'].IVSLDSIX = ['Account Index Master'].ACTINDX
40IVSLRNIX SearchIV Sales Returns IndexLI_14Long Integer14
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Inventory Transaction Amount'].IVSLRNIX AS 'SmartList Inventory Transaction Amount-IV Sales Returns Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP19 AS ['SmartList Inventory Transaction Amount']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Inventory Transaction Amount'].IVSLRNIX = ['Account Index Master'].ACTINDX
41IVINUSIX SearchIV In Use IndexLI_14Long Integer14
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Inventory Transaction Amount'].IVINUSIX AS 'SmartList Inventory Transaction Amount-IV In Use Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP19 AS ['SmartList Inventory Transaction Amount']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Inventory Transaction Amount'].IVINUSIX = ['Account Index Master'].ACTINDX
42IVINSVIX SearchIV In Service IndexLI_14Long Integer14
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Inventory Transaction Amount'].IVINSVIX AS 'SmartList Inventory Transaction Amount-IV In Service Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP19 AS ['SmartList Inventory Transaction Amount']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Inventory Transaction Amount'].IVINSVIX = ['Account Index Master'].ACTINDX
43IVDMGIDX SearchIV Damaged IndexLI_14Long Integer14
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Inventory Transaction Amount'].IVDMGIDX AS 'SmartList Inventory Transaction Amount-IV Damaged Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP19 AS ['SmartList Inventory Transaction Amount']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Inventory Transaction Amount'].IVDMGIDX = ['Account Index Master'].ACTINDX
44IVVARIDX SearchIV Variances IndexLI_14Long Integer14
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Inventory Transaction Amount'].IVVARIDX AS 'SmartList Inventory Transaction Amount-IV Variances Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP19 AS ['SmartList Inventory Transaction Amount']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Inventory Transaction Amount'].IVVARIDX = ['Account Index Master'].ACTINDX
45DPSHPIDX SearchDrop Ship IndexLI_14Long Integer14
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Inventory Transaction Amount'].DPSHPIDX AS 'SmartList Inventory Transaction Amount-Drop Ship Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP19 AS ['SmartList Inventory Transaction Amount']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Inventory Transaction Amount'].DPSHPIDX = ['Account Index Master'].ACTINDX
46PURPVIDX SearchPurchase Price Variance IndexLI_14Long Integer14
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Inventory Transaction Amount'].PURPVIDX AS 'SmartList Inventory Transaction Amount-Purchase Price Variance Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP19 AS ['SmartList Inventory Transaction Amount']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Inventory Transaction Amount'].PURPVIDX = ['Account Index Master'].ACTINDX
47IVRETIDX SearchInventory Returns IndexLI_14Long Integer14
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Inventory Transaction Amount'].IVRETIDX AS 'SmartList Inventory Transaction Amount-Inventory Returns Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP19 AS ['SmartList Inventory Transaction Amount']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Inventory Transaction Amount'].IVRETIDX = ['Account Index Master'].ACTINDX
48ASMVRIDX SearchAssembly Variance IndexLI_14Long Integer14
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Inventory Transaction Amount'].ASMVRIDX AS 'SmartList Inventory Transaction Amount-Assembly Variance Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP19 AS ['SmartList Inventory Transaction Amount']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Inventory Transaction Amount'].ASMVRIDX = ['Account Index Master'].ACTINDX
49ITMCLSCD SearchItem Class CodeSTR10_Class_IDString10
Key to the Item Class Setup (IV40400).

Click to show/hide

SELECT
       ['SmartList Inventory Transaction Amount'].ITMCLSCD AS 'SmartList Inventory Transaction Amount-Item Class Code'
       ,['Item Class Setup'].ITMCLSCD AS 'Item Class Setup-Item Class Code'
FROM
       ASIEXP19 AS ['SmartList Inventory Transaction Amount']
INNER JOIN
       IV40400 AS ['Item Class Setup']
              ON
                     ['SmartList Inventory Transaction Amount'].ITMCLSCD = ['Item Class Setup'].ITMCLSCD
50ITMTRKOP SearchItem Tracking OptionDDL_TrackInteger0
51LOTTYPE SearchLot TypeSTR10_Lot_TypeString10
52KPERHIST SearchKeep Period HistoryCB_Keep_Period_HistoryBoolean0
53KPTRXHST SearchKeep Trx HistoryCB_Keep_Trx_HistoryBoolean0
54KPCALHST SearchKeep Calendar HistoryCB_Keep_Calendar_HistoryBoolean0
55KPDSTHST SearchKeep Distribution HistoryCB_Keep_Dist_HistoryBoolean0
56ALWBKORD SearchAllow Back OrdersCB_Allow_Back_OrdersBoolean0
57VCTNMTHD SearchValuation MethodDDL_Valuation_MethodInteger0
58UOMSCHDL SearchU Of M ScheduleSTR10_ScheduleString10
Key to the Inventory U of M Schedule Setup (IV40201).

Click to show/hide

SELECT
       ['SmartList Inventory Transaction Amount'].UOMSCHDL AS 'SmartList Inventory Transaction Amount-U Of M Schedule'
       ,['Inventory U of M Schedule Setup'].UOMSCHDL AS 'Inventory U of M Schedule Setup-U Of M Schedule'
FROM
       ASIEXP19 AS ['SmartList Inventory Transaction Amount']
INNER JOIN
       IV40201 AS ['Inventory U of M Schedule Setup']
              ON
                     ['SmartList Inventory Transaction Amount'].UOMSCHDL = ['Inventory U of M Schedule Setup'].UOMSCHDL
59ObjRef1 SearchObjRef1ReferenceInvalid storage type 300
60ALTITEM1 SearchAlternate Item 1STR30_Item_NumberString30
61ALTITEM2 SearchAlternate Item 2STR30_Item_NumberString30
62USCATVLS_1 SearchUser Category Values[1]User_Category_ValueString10
63USCATVLS_2 SearchUser Category Values[2]User_Category_ValueString10
64USCATVLS_3 SearchUser Category Values[3]User_Category_ValueString10
65USCATVLS_4 SearchUser Category Values[4]User_Category_ValueString10
66USCATVLS_5 SearchUser Category Values[5]User_Category_ValueString10
67USCATVLS_6 SearchUser Category Values[6]User_Category_ValueString10
68MSTRCDTY SearchMaster Record TypeINT1Integer1
69MODIFDT SearchModified DateDTDate8
70CREATDDT SearchCreated DateDTDate8
71WRNTYDYS SearchWarranty DaysINT4Integer4
72PRCLEVEL SearchPriceLevelSTR10_LBAUString10
73LOCNCODE SearchLocation CodeSTR10_Location_CodeString10
Key to the Site Setup (IV40700).

Click to show/hide

SELECT
       ['SmartList Inventory Transaction Amount'].LOCNCODE AS 'SmartList Inventory Transaction Amount-Location Code'
       ,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
       ASIEXP19 AS ['SmartList Inventory Transaction Amount']
INNER JOIN
       IV40700 AS ['Site Setup']
              ON
                     ['SmartList Inventory Transaction Amount'].LOCNCODE = ['Site Setup'].LOCNCODE
74ASI_Main_IV_IV_Index SearchASI_Main_IV_IV_IndexLI_14Long Integer14
75ASI_Main_IV_IV_Offset_In SearchASI_Main_IV_IV_Offset_IndexLI_14Long Integer14
76BACHNUMB SearchBatch NumberSTR15_LBAUString15
77BCHSOURC SearchBatch SourceSTR15String15
78RCDOCNUM SearchRecurring Document NumberSTR20_Document_NumberString20
79MDFUSRID SearchModified User IDSTR15String15
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['SmartList Inventory Transaction Amount'].MDFUSRID AS 'SmartList Inventory Transaction Amount-Modified User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       ASIEXP19 AS ['SmartList Inventory Transaction Amount']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['SmartList Inventory Transaction Amount'].MDFUSRID = ['Users Master'].USERID
80POSTEDDT SearchPosted DateDATEDate6
81PTDUSRID SearchPosted User IDSTR15String15
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['SmartList Inventory Transaction Amount'].PTDUSRID AS 'SmartList Inventory Transaction Amount-Posted User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       ASIEXP19 AS ['SmartList Inventory Transaction Amount']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['SmartList Inventory Transaction Amount'].PTDUSRID = ['Users Master'].USERID
82GLPOSTDT SearchGL Posting DateDTDate8
83PSTGSTUS SearchPosting StatusINTInteger0
84TRXQTYTL SearchTRX QTY TotalDLR17_QTY_RBS0_UTRCurrency17
85IVWHRMSG SearchIV WORK HDR MessagesIV_WORK_HDR_MessagesLong Integer0
86ASI_Favorite_Sequence SearchASI_Favorite_SequenceASI_LI_10_RULong Integer10
87ABCCODE SearchABC CodeDDL_ABC_CodeInteger0
88CGSINFLX SearchCOGS Inflation IndexLI_14Long Integer14
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Inventory Transaction Amount'].CGSINFLX AS 'SmartList Inventory Transaction Amount-COGS Inflation Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP19 AS ['SmartList Inventory Transaction Amount']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Inventory Transaction Amount'].CGSINFLX = ['Account Index Master'].ACTINDX
89CGSMCIDX SearchCOGS Monetary Correction IndexLI_14Long Integer14
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Inventory Transaction Amount'].CGSMCIDX AS 'SmartList Inventory Transaction Amount-COGS Monetary Correction Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP19 AS ['SmartList Inventory Transaction Amount']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Inventory Transaction Amount'].CGSMCIDX = ['Account Index Master'].ACTINDX
90IVINFIDX SearchInventory Inflation IndexLI_14Long Integer14
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Inventory Transaction Amount'].IVINFIDX AS 'SmartList Inventory Transaction Amount-Inventory Inflation Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP19 AS ['SmartList Inventory Transaction Amount']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Inventory Transaction Amount'].IVINFIDX = ['Account Index Master'].ACTINDX
91INVMCIDX SearchInventory Monetary Correction IndexLI_14Long Integer14
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Inventory Transaction Amount'].INVMCIDX AS 'SmartList Inventory Transaction Amount-Inventory Monetary Correction Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP19 AS ['SmartList Inventory Transaction Amount']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Inventory Transaction Amount'].INVMCIDX = ['Account Index Master'].ACTINDX
92ITEMCODE SearchItem CodeSTR15String15
93KTACCTSR SearchKit COGS Account SourceGBInteger0
94LASTGENSN SearchLast Generated Serial NumberSTR20_LBAUString20
95PriceGroup SearchPrice GroupSTR10_LBAUString10
96PRICMTHD SearchPrice MethodDDL_Price_MethodInteger0
97PINFLIDX SearchPurch Inflation IndexLI_14Long Integer14
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Inventory Transaction Amount'].PINFLIDX AS 'SmartList Inventory Transaction Amount-Purch Inflation Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP19 AS ['SmartList Inventory Transaction Amount']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Inventory Transaction Amount'].PINFLIDX = ['Account Index Master'].ACTINDX
98PURMCIDX SearchPurch Monetary Correction IndexLI_14Long Integer14
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Inventory Transaction Amount'].PURMCIDX AS 'SmartList Inventory Transaction Amount-Purch Monetary Correction Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP19 AS ['SmartList Inventory Transaction Amount']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Inventory Transaction Amount'].PURMCIDX = ['Account Index Master'].ACTINDX
99PRCHSUOM SearchPurchasing U Of MU_Of_MString8
100SELNGUOM SearchSelling U Of MU_Of_MString8
101TCC SearchTax Commodity CodeSTR30_VATString30
102UPPVIDX SearchUnrealized Purchase Price Variance IndexLI_14Long Integer14
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Inventory Transaction Amount'].UPPVIDX AS 'SmartList Inventory Transaction Amount-Unrealized Purchase Price Variance Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP19 AS ['SmartList Inventory Transaction Amount']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Inventory Transaction Amount'].UPPVIDX = ['Account Index Master'].ACTINDX
103LOCNCODE1 SearchASI_Location_CodeSTR10_Location_CodeString10
104USAGETYPE SearchUsage TypeINTInteger0
105SRCRFRNCNMBR SearchSource Reference NumberSTR30String30
106SOURCEINDICATOR SearchSource IndicatorDDL_Source_IndicatorInteger0
107UMSCHDSC SearchU Of M Schedule DescriptionSTR30String30
azurecurveProductsSmartList (1493)PathnameSmartList Inventory Transaction Amount (ASIEXP19)

Leave a Reply

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