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 TypeSQL DB LengthKeyable Length
1ASI_Order_By SearchASI_Order_ByLI_14Long Integer414
2DOCNUMBR SearchDocument NumberSTR20_Document_NumberString2220
3IVDOCTYP SearchIV Document TypeDDL_IV_Document_TypeInteger20
4ASI_Document_Status SearchASI_Document_StatusINTInteger20
5ITEMNMBR SearchItem NumberSTR30_Item_NumberString3230
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_NumberCurrency1019
7UOFM SearchU Of MU_Of_MString108
8QTYBSUOM SearchQTY In Base U Of MDLR17_QTY_RBS0_STRCurrency1017
9TRXQTY SearchTRX QTYDLR17_QTY_RBS0_STRCurrency1017
10UNITCOST SearchUnit CostDLR17_RBS0_UTR$Currency1017
11EXTDCOST SearchExtended CostDLR17_RBS0_UTR$Currency1017
12TRXLOCTN SearchTRX LocationSTR10_Location_CodeString1210
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_CodeString1210
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_TypeInteger20
15TRTQTYTY SearchTransfer To QTY TypeDDL_QTY_TypeInteger20
16IVIVINDX SearchIV IV IndexLI_14Long Integer414
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 Integer414
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 Integer40
19TRXSORCE SearchTRX SourceSTR13String1413
20DOCDATE SearchDocument DateDTDate48
21HSTMODUL SearchHistory ModuleSTR3String43
22CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString1615
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 DescriptionSTR100String102100
24NOTEINDX SearchNote IndexDLR14Currency1014
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 NameSTR15String1615
26ITEMTYPE SearchItem TypeDDL_Item_TypeInteger20
27ITMGEDSC SearchItem Generic DescriptionSTR10String1210
28STNDCOST SearchStandard CostDLR17_RBS0_UTR$Currency1017
29CURRCOST SearchCurrent CostDLR17_RBS0_UTR$Currency1017
30LISTPRCE SearchList PriceDLR17_RBS0_STR$Currency1017
31ITEMSHWT SearchItem Shipping WeightLI6_RBS2_UTLong Integer46
32DECPLQTY SearchDecimal Places QTYSDDL_Decimal_Places_QTYSInteger20
33DECPLCUR SearchDecimal Places CurrencyDDL_Decimal_Places_DollarsInteger20
34ITMTSHID SearchItem Tax Schedule IDSTR15_LBAUString1615
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_OptionsInteger20
36COMMCODE SearchCommission CodeSTR15_LBAUString1615
37IVCOGSIX SearchIV COGS IndexLI_14Long Integer414
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 Integer414
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 Integer414
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 Integer414
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 Integer414
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 Integer414
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 Integer414
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 Integer414
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 Integer414
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 Integer414
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 Integer414
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 Integer414
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_IDString1210
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_TrackInteger20
51LOTTYPE SearchLot TypeSTR10_Lot_TypeString1210
52KPERHIST SearchKeep Period HistoryCB_Keep_Period_HistoryBoolean20
53KPTRXHST SearchKeep Trx HistoryCB_Keep_Trx_HistoryBoolean20
54KPCALHST SearchKeep Calendar HistoryCB_Keep_Calendar_HistoryBoolean20
55KPDSTHST SearchKeep Distribution HistoryCB_Keep_Dist_HistoryBoolean20
56ALWBKORD SearchAllow Back OrdersCB_Allow_Back_OrdersBoolean20
57VCTNMTHD SearchValuation MethodDDL_Valuation_MethodInteger20
58UOMSCHDL SearchU Of M ScheduleSTR10_ScheduleString1210
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 3000
60ALTITEM1 SearchAlternate Item 1STR30_Item_NumberString3230
61ALTITEM2 SearchAlternate Item 2STR30_Item_NumberString3230
62USCATVLS_1 SearchUser Category Values[1]User_Category_ValueString1210
63USCATVLS_2 SearchUser Category Values[2]User_Category_ValueString1210
64USCATVLS_3 SearchUser Category Values[3]User_Category_ValueString1210
65USCATVLS_4 SearchUser Category Values[4]User_Category_ValueString1210
66USCATVLS_5 SearchUser Category Values[5]User_Category_ValueString1210
67USCATVLS_6 SearchUser Category Values[6]User_Category_ValueString1210
68MSTRCDTY SearchMaster Record TypeINT1Integer21
69MODIFDT SearchModified DateDTDate48
70CREATDDT SearchCreated DateDTDate48
71WRNTYDYS SearchWarranty DaysINT4Integer24
72PRCLEVEL SearchPriceLevelSTR10_LBAUString1210
73LOCNCODE SearchLocation CodeSTR10_Location_CodeString1210
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 Integer414
75ASI_Main_IV_IV_Offset_In SearchASI_Main_IV_IV_Offset_IndexLI_14Long Integer414
76BACHNUMB SearchBatch NumberSTR15_LBAUString1615
77BCHSOURC SearchBatch SourceSTR15String1615
78RCDOCNUM SearchRecurring Document NumberSTR20_Document_NumberString2220
79MDFUSRID SearchModified User IDSTR15String1615
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 DateDATEDate46
81PTDUSRID SearchPosted User IDSTR15String1615
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 DateDTDate48
83PSTGSTUS SearchPosting StatusINTInteger20
84TRXQTYTL SearchTRX QTY TotalDLR17_QTY_RBS0_UTRCurrency1017
85IVWHRMSG SearchIV WORK HDR MessagesIV_WORK_HDR_MessagesLong Integer40
86ASI_Favorite_Sequence SearchASI_Favorite_SequenceASI_LI_10_RULong Integer410
87ABCCODE SearchABC CodeDDL_ABC_CodeInteger20
88CGSINFLX SearchCOGS Inflation IndexLI_14Long Integer414
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 Integer414
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 Integer414
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 Integer414
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 CodeSTR15String1615
93KTACCTSR SearchKit COGS Account SourceGBInteger20
94LASTGENSN SearchLast Generated Serial NumberSTR20_LBAUString2220
95PriceGroup SearchPrice GroupSTR10_LBAUString1210
96PRICMTHD SearchPrice MethodDDL_Price_MethodInteger20
97PINFLIDX SearchPurch Inflation IndexLI_14Long Integer414
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 Integer414
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_MString108
100SELNGUOM SearchSelling U Of MU_Of_MString108
101TCC SearchTax Commodity CodeSTR30_VATString3230
102UPPVIDX SearchUnrealized Purchase Price Variance IndexLI_14Long Integer414
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_CodeString1210
104USAGETYPE SearchUsage TypeINTInteger20
105SRCRFRNCNMBR SearchSource Reference NumberSTR30String3230
106SOURCEINDICATOR SearchSource IndicatorDDL_Source_IndicatorInteger20
107UMSCHDSC SearchU Of M Schedule DescriptionSTR30String3230
azurecurveProductsSmartList (1493)PathnameSmartList Inventory Transaction Amount (ASIEXP19)

Leave a Reply

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