Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/ASIEXP19
Product: SmartList (1493)
Series:
Display Name: SmartList Inventory Transaction Amount
Physical Name: ASIEXP19
Technical Name: ASI_IV_TRX_LINE_ExplorerSeq 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 DOCNUMBR Document Number String STR20_Document_Number 20 3 IVDOCTYP IV Document Type Integer DDL_IV_Document_Type 0 4 ASI_Document_Status ASI_Document_Status Integer INT 0 5 ITEMNMBR Item Number String STR30_Item_Number 30 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'].ITEMNMBR6 LNSEQNBR Line SEQ Number Currency Sequence_Number 19 7 UOFM U Of M String U_Of_M 8 8 QTYBSUOM QTY In Base U Of M Currency DLR17_QTY_RBS0_STR 17 9 TRXQTY TRX QTY Currency DLR17_QTY_RBS0_STR 17 10 UNITCOST Unit Cost Currency DLR17_RBS0_UTR$ 17 11 EXTDCOST Extended Cost Currency DLR17_RBS0_UTR$ 17 12 TRXLOCTN TRX Location String STR10_Location_Code 10 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'].LOCNCODE13 TRNSTLOC Transfer To Location String STR10_Location_Code 10 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'].LOCNCODE14 TRFQTYTY Transfer From QTY Type Integer DDL_QTY_Type 0 15 TRTQTYTY Transfer To QTY Type Integer DDL_QTY_Type 0 16 IVIVINDX IV IV Index Long Integer LI_14 14 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'].ACTINDX17 IVIVOFIX IV IV Offset Index Long Integer LI_14 14 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'].ACTINDX18 IVWLNMSG IV WORK LINE Messages Long Integer IV_WORK_LINE_Messages 0 19 TRXSORCE TRX Source String STR13 13 20 DOCDATE Document Date Date DT 8 21 HSTMODUL History Module String STR3 3 22 CUSTNMBR Customer Number String STR15_RM_Customer_Number 15 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'].CUSTNMBR23 ITEMDESC Item Description String STR100 100 24 NOTEINDX Note Index Currency DLR14 14 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'].NOTEINDX25 ITMSHNAM Item Short Name String STR15 15 26 ITEMTYPE Item Type Integer DDL_Item_Type 0 27 ITMGEDSC Item Generic Description String STR10 10 28 STNDCOST Standard Cost Currency DLR17_RBS0_UTR$ 17 29 CURRCOST Current Cost Currency DLR17_RBS0_UTR$ 17 30 LISTPRCE List Price Currency DLR17_RBS0_STR$ 17 31 ITEMSHWT Item Shipping Weight Long Integer LI6_RBS2_UT 6 32 DECPLQTY Decimal Places QTYS Integer DDL_Decimal_Places_QTYS 0 33 DECPLCUR Decimal Places Currency Integer DDL_Decimal_Places_Dollars 0 34 ITMTSHID Item Tax Schedule ID String STR15_LBAU 15 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'].TAXSCHID35 TAXOPTNS Tax Options Integer DDL_Tax_Options 0 36 COMMCODE Commission Code String STR15_LBAU 15 37 IVCOGSIX IV COGS Index Long Integer LI_14 14 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'].ACTINDX38 IVSLSIDX IV Sales Index Long Integer LI_14 14 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'].ACTINDX39 IVSLDSIX IV Sales Discounts Index Long Integer LI_14 14 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'].ACTINDX40 IVSLRNIX IV Sales Returns Index Long Integer LI_14 14 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'].ACTINDX41 IVINUSIX IV In Use Index Long Integer LI_14 14 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'].ACTINDX42 IVINSVIX IV In Service Index Long Integer LI_14 14 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'].ACTINDX43 IVDMGIDX IV Damaged Index Long Integer LI_14 14 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'].ACTINDX44 IVVARIDX IV Variances Index Long Integer LI_14 14 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'].ACTINDX45 DPSHPIDX Drop Ship Index Long Integer LI_14 14 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'].ACTINDX46 PURPVIDX Purchase Price Variance Index Long Integer LI_14 14 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'].ACTINDX47 IVRETIDX Inventory Returns Index Long Integer LI_14 14 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'].ACTINDX48 ASMVRIDX Assembly Variance Index Long Integer LI_14 14 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'].ACTINDX49 ITMCLSCD Item Class Code String STR10_Class_ID 10 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'].ITMCLSCD50 ITMTRKOP Item Tracking Option Integer DDL_Track 0 51 LOTTYPE Lot Type String STR10_Lot_Type 10 52 KPERHIST Keep Period History Boolean CB_Keep_Period_History 0 53 KPTRXHST Keep Trx History Boolean CB_Keep_Trx_History 0 54 KPCALHST Keep Calendar History Boolean CB_Keep_Calendar_History 0 55 KPDSTHST Keep Distribution History Boolean CB_Keep_Dist_History 0 56 ALWBKORD Allow Back Orders Boolean CB_Allow_Back_Orders 0 57 VCTNMTHD Valuation Method Integer DDL_Valuation_Method 0 58 UOMSCHDL U Of M Schedule String STR10_Schedule 10 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'].UOMSCHDL59 ObjRef1 ObjRef1 Invalid storage type 30 Reference 0 60 ALTITEM1 Alternate Item 1 String STR30_Item_Number 30 61 ALTITEM2 Alternate Item 2 String STR30_Item_Number 30 62 USCATVLS_1 User Category Values[1] String User_Category_Value 10 63 USCATVLS_2 User Category Values[2] String User_Category_Value 10 64 USCATVLS_3 User Category Values[3] String User_Category_Value 10 65 USCATVLS_4 User Category Values[4] String User_Category_Value 10 66 USCATVLS_5 User Category Values[5] String User_Category_Value 10 67 USCATVLS_6 User Category Values[6] String User_Category_Value 10 68 MSTRCDTY Master Record Type Integer INT1 1 69 MODIFDT Modified Date Date DT 8 70 CREATDDT Created Date Date DT 8 71 WRNTYDYS Warranty Days Integer INT4 4 72 PRCLEVEL PriceLevel String STR10_LBAU 10 73 LOCNCODE Location Code String STR10_Location_Code 10 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'].LOCNCODE74 ASI_Main_IV_IV_Index ASI_Main_IV_IV_Index Long Integer LI_14 14 75 ASI_Main_IV_IV_Offset_In ASI_Main_IV_IV_Offset_Index Long Integer LI_14 14 76 BACHNUMB Batch Number String STR15_LBAU 15 77 BCHSOURC Batch Source String STR15 15 78 RCDOCNUM Recurring Document Number String STR20_Document_Number 20 79 MDFUSRID Modified User ID String STR15 15 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'].USERID80 POSTEDDT Posted Date Date DATE 6 81 PTDUSRID Posted User ID String STR15 15 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'].USERID82 GLPOSTDT GL Posting Date Date DT 8 83 PSTGSTUS Posting Status Integer INT 0 84 TRXQTYTL TRX QTY Total Currency DLR17_QTY_RBS0_UTR 17 85 IVWHRMSG IV WORK HDR Messages Long Integer IV_WORK_HDR_Messages 0 86 ASI_Favorite_Sequence ASI_Favorite_Sequence Long Integer ASI_LI_10_RU 10 87 ABCCODE ABC Code Integer DDL_ABC_Code 0 88 CGSINFLX COGS Inflation Index Long Integer LI_14 14 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'].ACTINDX89 CGSMCIDX COGS Monetary Correction Index Long Integer LI_14 14 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'].ACTINDX90 IVINFIDX Inventory Inflation Index Long Integer LI_14 14 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'].ACTINDX91 INVMCIDX Inventory Monetary Correction Index Long Integer LI_14 14 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'].ACTINDX92 ITEMCODE Item Code String STR15 15 93 KTACCTSR Kit COGS Account Source Integer GB 0 94 LASTGENSN Last Generated Serial Number String STR20_LBAU 20 95 PriceGroup Price Group String STR10_LBAU 10 96 PRICMTHD Price Method Integer DDL_Price_Method 0 97 PINFLIDX Purch Inflation Index Long Integer LI_14 14 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'].ACTINDX98 PURMCIDX Purch Monetary Correction Index Long Integer LI_14 14 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'].ACTINDX99 PRCHSUOM Purchasing U Of M String U_Of_M 8 100 SELNGUOM Selling U Of M String U_Of_M 8 101 TCC Tax Commodity Code String STR30_VAT 30 102 UPPVIDX Unrealized Purchase Price Variance Index Long Integer LI_14 14 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'].ACTINDX103 LOCNCODE1 ASI_Location_Code String STR10_Location_Code 10 104 USAGETYPE Usage Type Integer INT 0 105 SRCRFRNCNMBR Source Reference Number String STR30 30 106 SOURCEINDICATOR Source Indicator Integer DDL_Source_Indicator 0 107 UMSCHDSC U Of M Schedule Description String STR30 30