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:

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_ByLong IntegerLI_1414
2DOCNUMBR SearchDocument NumberStringSTR20_Document_Number20
3IVDOCTYP SearchIV Document TypeIntegerDDL_IV_Document_Type0
4ASI_Document_Status SearchASI_Document_StatusIntegerINT0
5ITEMNMBR SearchItem NumberStringSTR30_Item_Number30
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 NumberCurrencySequence_Number19
7UOFM SearchU Of MStringU_Of_M8
8QTYBSUOM SearchQTY In Base U Of MCurrencyDLR17_QTY_RBS0_STR17
9TRXQTY SearchTRX QTYCurrencyDLR17_QTY_RBS0_STR17
10UNITCOST SearchUnit CostCurrencyDLR17_RBS0_UTR$17
11EXTDCOST SearchExtended CostCurrencyDLR17_RBS0_UTR$17
12TRXLOCTN SearchTRX LocationStringSTR10_Location_Code10
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 LocationStringSTR10_Location_Code10
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 TypeIntegerDDL_QTY_Type0
15TRTQTYTY SearchTransfer To QTY TypeIntegerDDL_QTY_Type0
16IVIVINDX SearchIV IV IndexLong IntegerLI_1414
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 IndexLong IntegerLI_1414
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 MessagesLong IntegerIV_WORK_LINE_Messages0
19TRXSORCE SearchTRX SourceStringSTR1313
20DOCDATE SearchDocument DateDateDT8
21HSTMODUL SearchHistory ModuleStringSTR33
22CUSTNMBR SearchCustomer NumberStringSTR15_RM_Customer_Number15
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 DescriptionStringSTR100100
24NOTEINDX SearchNote IndexCurrencyDLR1414
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 NameStringSTR1515
26ITEMTYPE SearchItem TypeIntegerDDL_Item_Type0
27ITMGEDSC SearchItem Generic DescriptionStringSTR1010
28STNDCOST SearchStandard CostCurrencyDLR17_RBS0_UTR$17
29CURRCOST SearchCurrent CostCurrencyDLR17_RBS0_UTR$17
30LISTPRCE SearchList PriceCurrencyDLR17_RBS0_STR$17
31ITEMSHWT SearchItem Shipping WeightLong IntegerLI6_RBS2_UT6
32DECPLQTY SearchDecimal Places QTYSIntegerDDL_Decimal_Places_QTYS0
33DECPLCUR SearchDecimal Places CurrencyIntegerDDL_Decimal_Places_Dollars0
34ITMTSHID SearchItem Tax Schedule IDStringSTR15_LBAU15
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 OptionsIntegerDDL_Tax_Options0
36COMMCODE SearchCommission CodeStringSTR15_LBAU15
37IVCOGSIX SearchIV COGS IndexLong IntegerLI_1414
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 IndexLong IntegerLI_1414
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 IndexLong IntegerLI_1414
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 IndexLong IntegerLI_1414
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 IndexLong IntegerLI_1414
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 IndexLong IntegerLI_1414
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 IndexLong IntegerLI_1414
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 IndexLong IntegerLI_1414
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 IndexLong IntegerLI_1414
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 IndexLong IntegerLI_1414
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 IndexLong IntegerLI_1414
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 IndexLong IntegerLI_1414
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 CodeStringSTR10_Class_ID10
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 OptionIntegerDDL_Track0
51LOTTYPE SearchLot TypeStringSTR10_Lot_Type10
52KPERHIST SearchKeep Period HistoryBooleanCB_Keep_Period_History0
53KPTRXHST SearchKeep Trx HistoryBooleanCB_Keep_Trx_History0
54KPCALHST SearchKeep Calendar HistoryBooleanCB_Keep_Calendar_History0
55KPDSTHST SearchKeep Distribution HistoryBooleanCB_Keep_Dist_History0
56ALWBKORD SearchAllow Back OrdersBooleanCB_Allow_Back_Orders0
57VCTNMTHD SearchValuation MethodIntegerDDL_Valuation_Method0
58UOMSCHDL SearchU Of M ScheduleStringSTR10_Schedule10
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 SearchObjRef1Invalid storage type 30Reference0
60ALTITEM1 SearchAlternate Item 1StringSTR30_Item_Number30
61ALTITEM2 SearchAlternate Item 2StringSTR30_Item_Number30
62USCATVLS_1 SearchUser Category Values[1]StringUser_Category_Value10
63USCATVLS_2 SearchUser Category Values[2]StringUser_Category_Value10
64USCATVLS_3 SearchUser Category Values[3]StringUser_Category_Value10
65USCATVLS_4 SearchUser Category Values[4]StringUser_Category_Value10
66USCATVLS_5 SearchUser Category Values[5]StringUser_Category_Value10
67USCATVLS_6 SearchUser Category Values[6]StringUser_Category_Value10
68MSTRCDTY SearchMaster Record TypeIntegerINT11
69MODIFDT SearchModified DateDateDT8
70CREATDDT SearchCreated DateDateDT8
71WRNTYDYS SearchWarranty DaysIntegerINT44
72PRCLEVEL SearchPriceLevelStringSTR10_LBAU10
73LOCNCODE SearchLocation CodeStringSTR10_Location_Code10
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_IndexLong IntegerLI_1414
75ASI_Main_IV_IV_Offset_In SearchASI_Main_IV_IV_Offset_IndexLong IntegerLI_1414
76BACHNUMB SearchBatch NumberStringSTR15_LBAU15
77BCHSOURC SearchBatch SourceStringSTR1515
78RCDOCNUM SearchRecurring Document NumberStringSTR20_Document_Number20
79MDFUSRID SearchModified User IDStringSTR1515
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 IDStringSTR1515
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 DateDateDT8
83PSTGSTUS SearchPosting StatusIntegerINT0
84TRXQTYTL SearchTRX QTY TotalCurrencyDLR17_QTY_RBS0_UTR17
85IVWHRMSG SearchIV WORK HDR MessagesLong IntegerIV_WORK_HDR_Messages0
86ASI_Favorite_Sequence SearchASI_Favorite_SequenceLong IntegerASI_LI_10_RU10
87ABCCODE SearchABC CodeIntegerDDL_ABC_Code0
88CGSINFLX SearchCOGS Inflation IndexLong IntegerLI_1414
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 IndexLong IntegerLI_1414
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 IndexLong IntegerLI_1414
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 IndexLong IntegerLI_1414
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 CodeStringSTR1515
93KTACCTSR SearchKit COGS Account SourceIntegerGB0
94LASTGENSN SearchLast Generated Serial NumberStringSTR20_LBAU20
95PriceGroup SearchPrice GroupStringSTR10_LBAU10
96PRICMTHD SearchPrice MethodIntegerDDL_Price_Method0
97PINFLIDX SearchPurch Inflation IndexLong IntegerLI_1414
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 IndexLong IntegerLI_1414
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 MStringU_Of_M8
100SELNGUOM SearchSelling U Of MStringU_Of_M8
101TCC SearchTax Commodity CodeStringSTR30_VAT30
102UPPVIDX SearchUnrealized Purchase Price Variance IndexLong IntegerLI_1414
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_CodeStringSTR10_Location_Code10
104USAGETYPE SearchUsage TypeIntegerINT0
105SRCRFRNCNMBR SearchSource Reference NumberStringSTR3030
106SOURCEINDICATOR SearchSource IndicatorIntegerDDL_Source_Indicator0
107UMSCHDSC SearchU Of M Schedule DescriptionStringSTR3030
azurecurveProductsSmartList (1493)PathnameSmartList Inventory Transaction Amount (ASIEXP19)

Leave a Reply

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