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_ExplorerSeq No Physical Name Display Name Dexterity Data Type SQL Data Type SQL DB Length Keyable Length 1 ASI_Order_By 
ASI_Order_By LI_14 Long Integer 4 14 2 DOCNUMBR Document Number STR20_Document_Number String 22 20 3 IVDOCTYP IV Document Type DDL_IV_Document_Type Integer 2 0 4 ASI_Document_Status ASI_Document_Status INT Integer 2 0 5 ITEMNMBR Item Number STR30_Item_Number String 32 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 Sequence_Number Currency 10 19 7 UOFM U Of M U_Of_M String 10 8 8 QTYBSUOM QTY In Base U Of M DLR17_QTY_RBS0_STR Currency 10 17 9 TRXQTY TRX QTY DLR17_QTY_RBS0_STR Currency 10 17 10 UNITCOST Unit Cost DLR17_RBS0_UTR$ Currency 10 17 11 EXTDCOST Extended Cost DLR17_RBS0_UTR$ Currency 10 17 12 TRXLOCTN TRX Location STR10_Location_Code String 12 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 STR10_Location_Code String 12 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 DDL_QTY_Type Integer 2 0 15 TRTQTYTY Transfer To QTY Type DDL_QTY_Type Integer 2 0 16 IVIVINDX IV IV Index LI_14 Long Integer 4 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 LI_14 Long Integer 4 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 IV_WORK_LINE_Messages Long Integer 4 0 19 TRXSORCE TRX Source STR13 String 14 13 20 DOCDATE Document Date DT Date 4 8 21 HSTMODUL History Module STR3 String 4 3 22 CUSTNMBR Customer Number STR15_RM_Customer_Number String 16 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 STR100 String 102 100 24 NOTEINDX Note Index DLR14 Currency 10 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 STR15 String 16 15 26 ITEMTYPE Item Type DDL_Item_Type Integer 2 0 27 ITMGEDSC Item Generic Description STR10 String 12 10 28 STNDCOST Standard Cost DLR17_RBS0_UTR$ Currency 10 17 29 CURRCOST Current Cost DLR17_RBS0_UTR$ Currency 10 17 30 LISTPRCE List Price DLR17_RBS0_STR$ Currency 10 17 31 ITEMSHWT Item Shipping Weight LI6_RBS2_UT Long Integer 4 6 32 DECPLQTY Decimal Places QTYS DDL_Decimal_Places_QTYS Integer 2 0 33 DECPLCUR Decimal Places Currency DDL_Decimal_Places_Dollars Integer 2 0 34 ITMTSHID Item Tax Schedule ID STR15_LBAU String 16 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 DDL_Tax_Options Integer 2 0 36 COMMCODE Commission Code STR15_LBAU String 16 15 37 IVCOGSIX IV COGS Index LI_14 Long Integer 4 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 LI_14 Long Integer 4 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 LI_14 Long Integer 4 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 LI_14 Long Integer 4 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 LI_14 Long Integer 4 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 LI_14 Long Integer 4 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 LI_14 Long Integer 4 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 LI_14 Long Integer 4 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 LI_14 Long Integer 4 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 LI_14 Long Integer 4 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 LI_14 Long Integer 4 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 LI_14 Long Integer 4 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 STR10_Class_ID String 12 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 DDL_Track Integer 2 0 51 LOTTYPE Lot Type STR10_Lot_Type String 12 10 52 KPERHIST Keep Period History CB_Keep_Period_History Boolean 2 0 53 KPTRXHST Keep Trx History CB_Keep_Trx_History Boolean 2 0 54 KPCALHST Keep Calendar History CB_Keep_Calendar_History Boolean 2 0 55 KPDSTHST Keep Distribution History CB_Keep_Dist_History Boolean 2 0 56 ALWBKORD Allow Back Orders CB_Allow_Back_Orders Boolean 2 0 57 VCTNMTHD Valuation Method DDL_Valuation_Method Integer 2 0 58 UOMSCHDL U Of M Schedule STR10_Schedule String 12 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 Reference Invalid storage type 30 0 0 60 ALTITEM1 Alternate Item 1 STR30_Item_Number String 32 30 61 ALTITEM2 Alternate Item 2 STR30_Item_Number String 32 30 62 USCATVLS_1 User Category Values[1] User_Category_Value String 12 10 63 USCATVLS_2 User Category Values[2] User_Category_Value String 12 10 64 USCATVLS_3 User Category Values[3] User_Category_Value String 12 10 65 USCATVLS_4 User Category Values[4] User_Category_Value String 12 10 66 USCATVLS_5 User Category Values[5] User_Category_Value String 12 10 67 USCATVLS_6 User Category Values[6] User_Category_Value String 12 10 68 MSTRCDTY Master Record Type INT1 Integer 2 1 69 MODIFDT Modified Date DT Date 4 8 70 CREATDDT Created Date DT Date 4 8 71 WRNTYDYS Warranty Days INT4 Integer 2 4 72 PRCLEVEL PriceLevel STR10_LBAU String 12 10 73 LOCNCODE Location Code STR10_Location_Code String 12 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 LI_14 Long Integer 4 14 75 ASI_Main_IV_IV_Offset_In ASI_Main_IV_IV_Offset_Index LI_14 Long Integer 4 14 76 BACHNUMB Batch Number STR15_LBAU String 16 15 77 BCHSOURC Batch Source STR15 String 16 15 78 RCDOCNUM Recurring Document Number STR20_Document_Number String 22 20 79 MDFUSRID Modified User ID STR15 String 16 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 4 6 81 PTDUSRID Posted User ID STR15 String 16 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 DT Date 4 8 83 PSTGSTUS Posting Status INT Integer 2 0 84 TRXQTYTL TRX QTY Total DLR17_QTY_RBS0_UTR Currency 10 17 85 IVWHRMSG IV WORK HDR Messages IV_WORK_HDR_Messages Long Integer 4 0 86 ASI_Favorite_Sequence ASI_Favorite_Sequence ASI_LI_10_RU Long Integer 4 10 87 ABCCODE ABC Code DDL_ABC_Code Integer 2 0 88 CGSINFLX COGS Inflation Index LI_14 Long Integer 4 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 LI_14 Long Integer 4 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 LI_14 Long Integer 4 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 LI_14 Long Integer 4 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 STR15 String 16 15 93 KTACCTSR Kit COGS Account Source GB Integer 2 0 94 LASTGENSN Last Generated Serial Number STR20_LBAU String 22 20 95 PriceGroup Price Group STR10_LBAU String 12 10 96 PRICMTHD Price Method DDL_Price_Method Integer 2 0 97 PINFLIDX Purch Inflation Index LI_14 Long Integer 4 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 LI_14 Long Integer 4 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 U_Of_M String 10 8 100 SELNGUOM Selling U Of M U_Of_M String 10 8 101 TCC Tax Commodity Code STR30_VAT String 32 30 102 UPPVIDX Unrealized Purchase Price Variance Index LI_14 Long Integer 4 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 STR10_Location_Code String 12 10 104 USAGETYPE Usage Type INT Integer 2 0 105 SRCRFRNCNMBR Source Reference Number STR30 String 32 30 106 SOURCEINDICATOR Source Indicator DDL_Source_Indicator Integer 2 0 107 UMSCHDSC U Of M Schedule Description STR30 String 32 30