SmartList Customer Items (ASIEXP24)

azurecurveProductsSmartList (1493)PathnameSmartList Customer Items (ASIEXP24)

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

Product: SmartList (1493)
Series: Pathname

Display Name: SmartList Customer Items
Physical Name: ASIEXP24
Technical Name: ASI_Item_Customer_Explorer

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1ASI_Order_By SearchASI_Order_ByLI_14Long Integer414
2ITEMNMBR SearchItem NumberSTR30_Item_NumberString3230
Key to the Item Master (IV00101).

Click to show/hide

SELECT
       ['SmartList Customer Items'].ITEMNMBR AS 'SmartList Customer Items-Item Number'
       ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
       ASIEXP24 AS ['SmartList Customer Items']
INNER JOIN
       IV00101 AS ['Item Master']
              ON
                     ['SmartList Customer Items'].ITEMNMBR = ['Item Master'].ITEMNMBR
3CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString1615
Key to the RM Customer MSTR (RM00101).

Click to show/hide

SELECT
       ['SmartList Customer Items'].CUSTNMBR AS 'SmartList Customer Items-Customer Number'
       ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
       ASIEXP24 AS ['SmartList Customer Items']
INNER JOIN
       RM00101 AS ['RM Customer MSTR']
              ON
                     ['SmartList Customer Items'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
4ASICUSTITNO SearchASI Customer Item NumberASI_Customer_Item_NumberString3230
5ASICUSTITDSC SearchASI Customer Item DescriptionASI_Customer_Item_DescriptionString5250
6ASICUSTITSNM SearchASI Customer Item Short NameSTR15String1615
7ASICUSTITGDSC SearchASI Customer Item Generic DescriptionSTR10String1210
8USERDEF1 SearchUser Defined 1STR20String2220
9USERDEF2 SearchUser Defined 2STR20String2220
10USRDEF03 SearchUser Defined 3STR20String2220
11USRDEF04 SearchUser Defined 4STR20String2220
12USRDEF05 SearchUser Defined 5STR20String2220
13ASIUSERDEF1 SearchASI User Defined Key1STR50String5250
14ASIUSERDEF2 SearchASI User Defined Key2STR50String5250
15ASIUSERDEF3 SearchASI User Defined Key3STR50String5250
16ASIUSERDEF4 SearchASI User Defined Key4STR50String5250
17CUSTNAME SearchCustomer NameSTR64_Customer_NameString6664
18CUSTCLAS SearchCustomer ClassSTR15_Customer_ClassString1615
19CPRCSTNM SearchCorporate Customer NumberSTR15_RM_Customer_NumberString1615
20CNTCPRSN SearchContact PersonSTR60String6260
21STMTNAME SearchStatement NameSTR64String6664
22SHRTNAME SearchShort NameSTR15String1615
23ADRSCODE SearchAddress CodeSTR15_Address_CodeString1615
24UPSZONE SearchUPS ZoneSTR3String43
25SHIPMTHD SearchShipping MethodSTR15_Shipping_MethodString1615
Key to the Shipping Methods Master (SY03000).

Click to show/hide

SELECT
       ['SmartList Customer Items'].SHIPMTHD AS 'SmartList Customer Items-Shipping Method'
       ,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method'
FROM
       ASIEXP24 AS ['SmartList Customer Items']
INNER JOIN
       SY03000 AS ['Shipping Methods Master']
              ON
                     ['SmartList Customer Items'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD
26TAXSCHID SearchTax Schedule IDSTR15_Tax_Schedule_IDString1615
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['SmartList Customer Items'].TAXSCHID AS 'SmartList Customer Items-Tax Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       ASIEXP24 AS ['SmartList Customer Items']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['SmartList Customer Items'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
27ADDRESS1 SearchAddress 1STR60String6260
28ADDRESS2 SearchAddress 2STR60String6260
29ADDRESS3 SearchAddress 3STR60String6260
30COUNTRY SearchCountrySTR60String6260
31CITY SearchCitySTR35String3635
32STATE SearchStateSTR30_StateString3029
33ZIP SearchZipSTR10String1210
34PHONE1 SearchPhone 1Phone_NumberString2214
35PHONE2 SearchPhone 2Phone_NumberString2214
36FAX SearchFaxSTR14_FAXString2214
37PRBTADCD SearchPrimary Billto Address CodeSTR15_LBAUString1615
38PRSTADCD SearchPrimary Shipto Address CodeSTR15_LBAUString1615
39STADDRCD SearchStatement Address CodeSTR15_LBAUString1615
40SLPRSNID SearchSalesperson IDSTR15_Salesperson_IDString1615
Key to the RM Salesperson Master (RM00301).

Click to show/hide

SELECT
       ['SmartList Customer Items'].SLPRSNID AS 'SmartList Customer Items-Salesperson ID'
       ,['RM Salesperson Master'].SLPRSNID AS 'RM Salesperson Master-Salesperson ID'
FROM
       ASIEXP24 AS ['SmartList Customer Items']
INNER JOIN
       RM00301 AS ['RM Salesperson Master']
              ON
                     ['SmartList Customer Items'].SLPRSNID = ['RM Salesperson Master'].SLPRSNID
41CHEKBKID SearchCheckbook IDSTR15_Checkbook_IDString1615
Key to the CM Checkbook Master (CM00100).

Click to show/hide

SELECT
       ['SmartList Customer Items'].CHEKBKID AS 'SmartList Customer Items-Checkbook ID'
       ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
       ASIEXP24 AS ['SmartList Customer Items']
INNER JOIN
       CM00100 AS ['CM Checkbook Master']
              ON
                     ['SmartList Customer Items'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID
42PYMTRMID SearchPayment Terms IDSTR20_Payment_Terms_IDString2220
Key to the Payment Terms Master (SY03300).

Click to show/hide

SELECT
       ['SmartList Customer Items'].PYMTRMID AS 'SmartList Customer Items-Payment Terms ID'
       ,['Payment Terms Master'].PYMTRMID AS 'Payment Terms Master-Payment Terms ID'
FROM
       ASIEXP24 AS ['SmartList Customer Items']
INNER JOIN
       SY03300 AS ['Payment Terms Master']
              ON
                     ['SmartList Customer Items'].PYMTRMID = ['Payment Terms Master'].PYMTRMID
43CRLMTTYP SearchCredit Limit TypeGB_Amt_TypeInteger20
44CRLMTAMT SearchCredit Limit AmountDLR17_RBS0_UTR$Currency1017
45CRLMTPER SearchCredit Limit PeriodDDLInteger20
46CRLMTPAM SearchCredit Limit Period AmountDLR17_RBS0_UTR$Currency1017
47CURNCYID SearchCurrency IDSTR15_Currency_IDString1615
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['SmartList Customer Items'].CURNCYID AS 'SmartList Customer Items-Currency ID'
       ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
       ASIEXP24 AS ['SmartList Customer Items']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['SmartList Customer Items'].CURNCYID = ['Currency Setup'].CURNCYID
48RATETPID SearchRate Type IDSTR15_Rate_Type_IDString1615
Key to the Multicurrency Rate Type Setup (MC40100).

Click to show/hide

SELECT
       ['SmartList Customer Items'].RATETPID AS 'SmartList Customer Items-Rate Type ID'
       ,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
       ASIEXP24 AS ['SmartList Customer Items']
INNER JOIN
       MC40100 AS ['Multicurrency Rate Type Setup']
              ON
                     ['SmartList Customer Items'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID
49CUSTDISC SearchCustomer DiscountINT5_%2Integer25
50PRCLEVEL SearchPriceLevelSTR10_LBAUString1210
51MINPYTYP SearchMinimum Payment TypeGB_Amt_TypeInteger20
52MINPYDLR SearchMinimum Payment DollarDLR17_RBS0_UTR$Currency1017
53MINPYPCT SearchMinimum Payment PercentINT5_%2Integer25
54FNCHATYP SearchFinance Charge Amt TypeGB_Amt_TypeInteger20
55FNCHPCNT SearchFinance Charge PercentINT5_%2Integer25
56FINCHDLR SearchFinance Charge DollarDLR17_RBS0_UTR$Currency1017
57MXWOFTYP SearchMaximum Writeoff TypeGP_Max_WriteoffInteger20
58MXWROFAM SearchMax Writeoff AmountDLR17_RBS0_UTR$Currency1017
59COMMENT1 SearchComment1STR30String3230
60COMMENT2 SearchComment2STR30String3230
61USERDEF11 SearchASI_User_Defined_1STR20String2220
62USERDEF21 SearchASI_User_Defined_2STR20String2220
63TAXEXMT1 SearchTax Exempt 1STR25String2625
64TAXEXMT2 SearchTax Exempt 2STR25String2625
65TXRGNNUM SearchTax Registration NumberSTR25String2625
66BALNCTYP SearchBalance TypeGB_Bal_TypeInteger20
67STMTCYCL SearchStatement CycleDDL_Stmt_CycleInteger20
68BANKNAME SearchBank NameSTR30String3230
69BNKBRNCH SearchBank BranchSTR20String2220
70SALSTERR SearchSales TerritorySTR15_Sales_TerritoryString1615
Key to the Sales Territory Master File (RM00303).

Click to show/hide

SELECT
       ['SmartList Customer Items'].SALSTERR AS 'SmartList Customer Items-Sales Territory'
       ,['Sales Territory Master File'].SALSTERR AS 'Sales Territory Master File-Sales Territory'
FROM
       ASIEXP24 AS ['SmartList Customer Items']
INNER JOIN
       RM00303 AS ['Sales Territory Master File']
              ON
                     ['SmartList Customer Items'].SALSTERR = ['Sales Territory Master File'].SALSTERR
71DEFCACTY SearchDefault Cash Account TypeGBInteger20
72RMCSHACC SearchRM Cash Account IndexLI_14Long Integer414
73RMARACC SearchRM AR Account IndexLI_14Long Integer414
74RMSLSACC SearchRM Sales Account IndexLI_14Long Integer414
75RMIVACC SearchRM IV Account IndexLI_14Long Integer414
76RMCOSACC SearchRM Cost Of Sales Account IndexLI_14Long Integer414
77RMTAKACC SearchRM Discounts Taken Account IndexLI_14Long Integer414
78RMAVACC SearchRM Discounts Avail Account IndexLI_14Long Integer414
79RMFCGACC SearchRM Finance Charge Account IndexLI_14Long Integer414
80RMWRACC SearchRM Writeoff Account IndexLI_14Long Integer414
81FRSTINDT SearchFirst Invoice DateDT_DateDate46
82INACTIVE SearchInactiveCB_InactiveBoolean20
83HOLD SearchHoldCB_HoldBoolean20
84CRCARDID SearchCredit Card IDSTR15String1615
85CRCRDNUM SearchCredit Card NumberSTR20String2220
86CCRDXPDT SearchCredit Card Exp DateDT_DateDate46
87KPDSTHST SearchKeep Distribution HistoryCB_Keep_Dist_HistoryBoolean20
88KPCALHST SearchKeep Calendar HistoryCB_Keep_Calendar_HistoryBoolean20
89KPERHIST SearchKeep Period HistoryCB_Keep_Period_HistoryBoolean20
90KPTRXHST SearchKeep Trx HistoryCB_Keep_Trx_HistoryBoolean20
91NOTEINDX SearchNote IndexDLR14Currency1014
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['SmartList Customer Items'].NOTEINDX AS 'SmartList Customer Items-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       ASIEXP24 AS ['SmartList Customer Items']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['SmartList Customer Items'].NOTEINDX = ['Record Notes Master'].NOTEINDX
92CREATDDT SearchCreated DateDTDate48
93MODIFDT SearchModified DateDTDate48
94ASI_Favorite_Sequence SearchASI_Favorite_SequenceASI_LI_10_RULong Integer410
95TNSFCLIF SearchTotal Amount Of NSF Checks LifeDLR19_RBS0_STR$Currency1019
96NONSFLIF SearchNumber Of NSF Checks LifeLI6_U0Long Integer46
97CUSTBLNC SearchCustomer BalanceDLR19_RBS0_STR$Currency1019
98AGPERAMT_1 SearchAging Period Amounts[1]DLR17_RBSO_STR$Currency1017
99AGPERAMT_2 SearchAging Period Amounts[2]DLR17_RBSO_STR$Currency1017
100AGPERAMT_3 SearchAging Period Amounts[3]DLR17_RBSO_STR$Currency1017
101AGPERAMT_4 SearchAging Period Amounts[4]DLR17_RBSO_STR$Currency1017
102AGPERAMT_5 SearchAging Period Amounts[5]DLR17_RBSO_STR$Currency1017
103AGPERAMT_6 SearchAging Period Amounts[6]DLR17_RBSO_STR$Currency1017
104AGPERAMT_7 SearchAging Period Amounts[7]DLR17_RBSO_STR$Currency1017
105LASTAGED SearchLast AgedDATEDate46
106LSTNSFCD SearchLast NSF Check DateDT_DateDate46
107LPYMTAMT SearchLast Payment AmountDLR17_RBS0_STR$Currency1017
108LASTPYDT SearchLast Payment DateDT_DateDate46
109LSTTRXDT SearchLast Transaction DateDT_DateDate46
110LSTTRXAM SearchLast Transaction AmountDLR17_RBS0_STR$Currency1017
111LSTFCHAM SearchLast Finance Charge AmountDLR19_RBS0_STR$Currency1019
112UPFCHYTD SearchUnpaid Finance Charges YTDDLR17_RBS0_UTR$Currency1017
113AVDTPLYR SearchAverage Days to Pay - LYRINT3_U0Integer23
114AVDTPLIF SearchAverage Days To Pay - LifeINT3_U0Integer23
115AVGDTPYR SearchAverage Days To Pay - YearINT3_U0Integer23
116NUMADTPL SearchNumber ADTP Documents - LifeLong_10ULong Integer410
117NUMADTPY SearchNumber ADTP Documents - YearLong_10ULong Integer410
118NUMADTPR SearchNumber ADTP Documents - LYRLong_10ULong Integer410
119TDTKNYTD SearchTotal Discounts Taken YTDDLR19_RBS0_STR$Currency1019
120TDTKNLYR SearchTotal Discounts Taken LYRDLR19_RBS0_STR$Currency1019
121TDTKNLTD SearchTotal Discounts Taken LTDDLR19_RBS0_STR$Currency1019
122TDISAYTD SearchTotal Discounts Available YTDDLR19_RBS0_STR$Currency1019
123RETAINAG SearchRetainageDLR19_RBS0_STR$Currency1019
124TNSFCYTD SearchTotal Amount Of NSF Checks YTDDLR19_RBS0_STR$Currency1019
125NONSFYTD SearchNumber Of NSF Checks YTDLI6_U0Long Integer46
126UNPSTDSA SearchUnposted Sales AmountDLR19_RBS0_UTR$Currency1019
127UNPSTDCA SearchUnposted Cash AmountDLR19_RBS0_UTR$Currency1019
128UNPSTOSA SearchUnposted Other Sales AmountDLR19_RBS0_UTR$Currency1019
129UNPSTOCA SearchUnposted Other Cash AmountDLR19_RBS0_UTR$Currency1019
130NCSCHPMT SearchNon Current Scheduled PaymentsDLR19_RBS0_STR$Currency1019
131TTLSLYTD SearchTotal Sales YTDDLR19_RBS0_STR$Currency1019
132TTLSLLTD SearchTotal Sales LTDDLR19_RBS0_STR$Currency1019
133TTLSLLYR SearchTotal Sales LYRDLR19_RBS0_STR$Currency1019
134TCOSTYTD SearchTotal Costs YTDDLR19_RBS0_STR$Currency1019
135TCOSTLTD SearchTotal Costs LTDDLR19_RBS0_STR$Currency1019
136TCOSTLYR SearchTotal Costs LYRDLR19_RBS0_STR$Currency1019
137TCSHRYTD SearchTotal Cash Received YTDDLR19_RBS0_STR$Currency1019
138TCSHRLTD SearchTotal Cash Received LTDDLR19_RBS0_STR$Currency1019
139TCSHRLYR SearchTotal Cash Received LYRDLR19_RBS0_STR$Currency1019
140TFNCHYTD SearchTotal Finance Charges YTDDLR19_RBS0_STR$Currency1019
141TFNCHLTD SearchTotal Finance Charges LTDDLR19_RBS0_STR$Currency1019
142TFNCHLYR SearchTotal Finance Charges LYRDLR19_RBS0_STR$Currency1019
143FNCHCYTD SearchFinance Charges CYTDDLR19_RBS0_STR$Currency1019
144FNCHLYRC SearchFinance Charges LYR CalendarDLR19_RBS0_STR$Currency1019
145TBDDTYTD SearchTotal Bad Debt YTDDLR19_RBS0_STR$Currency1019
146TBDDTLYR SearchTotal Bad Deb LYRDLR19_RBS0_STR$Currency1019
147TBDDTLTD SearchTotal Bad Debt LTDDLR19_RBS0_STR$Currency1019
148TWVFCYTD SearchTotal Waived FC YTDDLR19_RBS0_STR$Currency1019
149TWVFCLTD SearchTotal Waived FC LTDDLR19_RBS0_STR$Currency1019
150TWVFCLYR SearchTotal Waived FC LYRDLR19_RBS0_STR$Currency1019
151TWROFYTD SearchTotal Writeoffs YTDDLR19_RBS0_STR$Currency1019
152TWROFLTD SearchTotal Writeoffs LTDDLR19_RBS0_STR$Currency1019
153TWROFLYR SearchTotal Writeoffs LYRDLR19_RBS0_STR$Currency1019
154TTLINYTD SearchTotal # Invoices YTDLI6_U0Long Integer46
155TTLINLTD SearchTotal # Invoices LTDLI6_U0Long Integer46
156TTLINLYR SearchTotal # Invoices LYRLI6_U0Long Integer46
157TTLFCYTD SearchTotal # FC YTDLI6_U0Long Integer46
158TTLFCLTD SearchTotal # FC LTDLI6_U0Long Integer46
159TTLFCLYR SearchTotal # FC LYRLI6_U0Long Integer46
160WROFSLIF SearchWrite Offs LIFEDLR19_RBS0_STR$Currency1019
161WROFSLYR SearchWrite Offs LYRDLR19_RBS0_STR$Currency1019
162WROFSYTD SearchWrite Offs YTDDLR19_RBS0_STR$Currency1019
163HIBALLYR SearchHigh Balance LYRDLR19_RBSO_STR$Currency1019
164HIBALYTD SearchHigh Balance YTDDLR19_RBSO_STR$Currency1019
165HIBALLTD SearchHigh Balance LTDDLR19_RBSO_STR$Currency1019
166LASTSTDT SearchLast Statement DateDATEDate46
167LSTSTAMT SearchLast Statement AmountDLR17_RBS0_STR$Currency1017
168DEPRECV SearchDeposits ReceivedDLR19_RBS0_STR$Currency1019
169ONORDAMT SearchOn Order AmountDLR19_RBS0_UTR$Currency1019
170Revalue_Customer SearchRevalue CustomerCB Revalue CustomerBoolean20
171Post_Results_To SearchPost Results ToGBInteger20
172FINCHID SearchFinance Charge IDSTR15_Charge_IDString1615
173GOVCRPID SearchGovernmental Corporate IDSTR30_Gov_Corp_IDString3230
174GOVINDID SearchGovernmental Individual IDSTR30_Gov_Indiv_IDString3230
175DISGRPER SearchDiscount Grace PeriodINT2_U0Integer22
176DOCFMTID SearchDocument Format IDSTR15_LBUString1615
177DUEGRPER SearchDue Date Grace PeriodINT2_U0Integer22
178PHONE3 SearchPhone 3Phone_Number3String2214
179TTLRTLTD SearchTotal Returns LTDDLR19_RBS0_STR$Currency1019
180TTLRTLYR SearchTotal Returns LYRDLR19_RBS0_STR$Currency1019
181TTLRTYTD SearchTotal Returns YTDDLR19_RBS0_STR$Currency1019
182ITEMDESC SearchItem DescriptionSTR100String102100
183NOTEINDX1 SearchASI_Note_IndexDLR14Currency1014
184ITMSHNAM SearchItem Short NameSTR15String1615
185ITEMTYPE SearchItem TypeDDL_Item_TypeInteger20
186ITMGEDSC SearchItem Generic DescriptionSTR10String1210
187STNDCOST SearchStandard CostDLR17_RBS0_UTR$Currency1017
188CURRCOST SearchCurrent CostDLR17_RBS0_UTR$Currency1017
189ITEMSHWT SearchItem Shipping WeightLI6_RBS2_UTLong Integer46
190DECPLQTY SearchDecimal Places QTYSDDL_Decimal_Places_QTYSInteger20
191DECPLCUR SearchDecimal Places CurrencyDDL_Decimal_Places_DollarsInteger20
192ITMTSHID SearchItem Tax Schedule IDSTR15_LBAUString1615
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['SmartList Customer Items'].ITMTSHID AS 'SmartList Customer Items-Item Tax Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       ASIEXP24 AS ['SmartList Customer Items']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['SmartList Customer Items'].ITMTSHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
193TAXOPTNS SearchTax OptionsDDL_Tax_OptionsInteger20
194IVIVINDX SearchIV IV IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Customer Items'].IVIVINDX AS 'SmartList Customer Items-IV IV Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP24 AS ['SmartList Customer Items']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Customer Items'].IVIVINDX = ['Account Index Master'].ACTINDX
195IVIVOFIX SearchIV IV Offset IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Customer Items'].IVIVOFIX AS 'SmartList Customer Items-IV IV Offset Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP24 AS ['SmartList Customer Items']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Customer Items'].IVIVOFIX = ['Account Index Master'].ACTINDX
196IVCOGSIX SearchIV COGS IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Customer Items'].IVCOGSIX AS 'SmartList Customer Items-IV COGS Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP24 AS ['SmartList Customer Items']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Customer Items'].IVCOGSIX = ['Account Index Master'].ACTINDX
197IVSLSIDX SearchIV Sales IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Customer Items'].IVSLSIDX AS 'SmartList Customer Items-IV Sales Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP24 AS ['SmartList Customer Items']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Customer Items'].IVSLSIDX = ['Account Index Master'].ACTINDX
198IVSLDSIX SearchIV Sales Discounts IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Customer Items'].IVSLDSIX AS 'SmartList Customer Items-IV Sales Discounts Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP24 AS ['SmartList Customer Items']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Customer Items'].IVSLDSIX = ['Account Index Master'].ACTINDX
199IVSLRNIX SearchIV Sales Returns IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Customer Items'].IVSLRNIX AS 'SmartList Customer Items-IV Sales Returns Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP24 AS ['SmartList Customer Items']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Customer Items'].IVSLRNIX = ['Account Index Master'].ACTINDX
200IVINUSIX SearchIV In Use IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Customer Items'].IVINUSIX AS 'SmartList Customer Items-IV In Use Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP24 AS ['SmartList Customer Items']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Customer Items'].IVINUSIX = ['Account Index Master'].ACTINDX
201IVINSVIX SearchIV In Service IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Customer Items'].IVINSVIX AS 'SmartList Customer Items-IV In Service Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP24 AS ['SmartList Customer Items']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Customer Items'].IVINSVIX = ['Account Index Master'].ACTINDX
202IVDMGIDX SearchIV Damaged IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Customer Items'].IVDMGIDX AS 'SmartList Customer Items-IV Damaged Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP24 AS ['SmartList Customer Items']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Customer Items'].IVDMGIDX = ['Account Index Master'].ACTINDX
203IVVARIDX SearchIV Variances IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Customer Items'].IVVARIDX AS 'SmartList Customer Items-IV Variances Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP24 AS ['SmartList Customer Items']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Customer Items'].IVVARIDX = ['Account Index Master'].ACTINDX
204DPSHPIDX SearchDrop Ship IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Customer Items'].DPSHPIDX AS 'SmartList Customer Items-Drop Ship Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP24 AS ['SmartList Customer Items']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Customer Items'].DPSHPIDX = ['Account Index Master'].ACTINDX
205PURPVIDX SearchPurchase Price Variance IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Customer Items'].PURPVIDX AS 'SmartList Customer Items-Purchase Price Variance Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP24 AS ['SmartList Customer Items']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Customer Items'].PURPVIDX = ['Account Index Master'].ACTINDX
206UPPVIDX SearchUnrealized Purchase Price Variance IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Customer Items'].UPPVIDX AS 'SmartList Customer Items-Unrealized Purchase Price Variance Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP24 AS ['SmartList Customer Items']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Customer Items'].UPPVIDX = ['Account Index Master'].ACTINDX
207IVRETIDX SearchInventory Returns IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Customer Items'].IVRETIDX AS 'SmartList Customer Items-Inventory Returns Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP24 AS ['SmartList Customer Items']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Customer Items'].IVRETIDX = ['Account Index Master'].ACTINDX
208ASMVRIDX SearchAssembly Variance IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Customer Items'].ASMVRIDX AS 'SmartList Customer Items-Assembly Variance Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP24 AS ['SmartList Customer Items']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Customer Items'].ASMVRIDX = ['Account Index Master'].ACTINDX
209ITMCLSCD SearchItem Class CodeSTR10_Class_IDString1210
Key to the Item Class Setup (IV40400).

Click to show/hide

SELECT
       ['SmartList Customer Items'].ITMCLSCD AS 'SmartList Customer Items-Item Class Code'
       ,['Item Class Setup'].ITMCLSCD AS 'Item Class Setup-Item Class Code'
FROM
       ASIEXP24 AS ['SmartList Customer Items']
INNER JOIN
       IV40400 AS ['Item Class Setup']
              ON
                     ['SmartList Customer Items'].ITMCLSCD = ['Item Class Setup'].ITMCLSCD
210ITMTRKOP SearchItem Tracking OptionDDL_TrackInteger20
211LOTTYPE SearchLot TypeSTR10_Lot_TypeString1210
212KPERHIST1 SearchASI_Keep_Period_HistoryCB_Keep_Period_HistoryBoolean20
213KPTRXHST1 SearchASI_Keep_Trx_HistoryCB_Keep_Trx_HistoryBoolean20
214KPCALHST1 SearchASI_Keep_Calendar_HistoryCB_Keep_Calendar_HistoryBoolean20
215KPDSTHST1 SearchASI_Keep_Distribution_HistoryCB_Keep_Dist_HistoryBoolean20
216ALWBKORD SearchAllow Back OrdersCB_Allow_Back_OrdersBoolean20
217VCTNMTHD SearchValuation MethodDDL_Valuation_MethodInteger20
218UOMSCHDL SearchU Of M ScheduleSTR10_ScheduleString1210
Key to the Inventory U of M Schedule Setup (IV40201).

Click to show/hide

SELECT
       ['SmartList Customer Items'].UOMSCHDL AS 'SmartList Customer Items-U Of M Schedule'
       ,['Inventory U of M Schedule Setup'].UOMSCHDL AS 'Inventory U of M Schedule Setup-U Of M Schedule'
FROM
       ASIEXP24 AS ['SmartList Customer Items']
INNER JOIN
       IV40201 AS ['Inventory U of M Schedule Setup']
              ON
                     ['SmartList Customer Items'].UOMSCHDL = ['Inventory U of M Schedule Setup'].UOMSCHDL
219ALTITEM1 SearchAlternate Item 1STR30_Item_NumberString3230
220ALTITEM2 SearchAlternate Item 2STR30_Item_NumberString3230
221USCATVLS_1 SearchUser Category Values[1]User_Category_ValueString1210
222USCATVLS_2 SearchUser Category Values[2]User_Category_ValueString1210
223USCATVLS_3 SearchUser Category Values[3]User_Category_ValueString1210
224USCATVLS_4 SearchUser Category Values[4]User_Category_ValueString1210
225USCATVLS_5 SearchUser Category Values[5]User_Category_ValueString1210
226USCATVLS_6 SearchUser Category Values[6]User_Category_ValueString1210
227MSTRCDTY SearchMaster Record TypeINT1Integer21
228MODIFDT1 SearchASI_Modified_DateDTDate48
229CREATDDT1 SearchASI_Created_DateDTDate48
230WRNTYDYS SearchWarranty DaysINT4Integer24
231PRCLEVEL1 SearchASI_PriceLevelSTR10_LBAUString1210
232LOCNCODE SearchLocation CodeSTR10_Location_CodeString1210
Key to the Site Setup (IV40700).

Click to show/hide

SELECT
       ['SmartList Customer Items'].LOCNCODE AS 'SmartList Customer Items-Location Code'
       ,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
       ASIEXP24 AS ['SmartList Customer Items']
INNER JOIN
       IV40700 AS ['Site Setup']
              ON
                     ['SmartList Customer Items'].LOCNCODE = ['Site Setup'].LOCNCODE
233PINFLIDX SearchPurch Inflation IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Customer Items'].PINFLIDX AS 'SmartList Customer Items-Purch Inflation Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP24 AS ['SmartList Customer Items']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Customer Items'].PINFLIDX = ['Account Index Master'].ACTINDX
234PURMCIDX SearchPurch Monetary Correction IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Customer Items'].PURMCIDX AS 'SmartList Customer Items-Purch Monetary Correction Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP24 AS ['SmartList Customer Items']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Customer Items'].PURMCIDX = ['Account Index Master'].ACTINDX
235IVINFIDX SearchInventory Inflation IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Customer Items'].IVINFIDX AS 'SmartList Customer Items-Inventory Inflation Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP24 AS ['SmartList Customer Items']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Customer Items'].IVINFIDX = ['Account Index Master'].ACTINDX
236INVMCIDX SearchInventory Monetary Correction IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Customer Items'].INVMCIDX AS 'SmartList Customer Items-Inventory Monetary Correction Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP24 AS ['SmartList Customer Items']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Customer Items'].INVMCIDX = ['Account Index Master'].ACTINDX
237CGSINFLX SearchCOGS Inflation IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Customer Items'].CGSINFLX AS 'SmartList Customer Items-COGS Inflation Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP24 AS ['SmartList Customer Items']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Customer Items'].CGSINFLX = ['Account Index Master'].ACTINDX
238CGSMCIDX SearchCOGS Monetary Correction IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Customer Items'].CGSMCIDX AS 'SmartList Customer Items-COGS Monetary Correction Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP24 AS ['SmartList Customer Items']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Customer Items'].CGSMCIDX = ['Account Index Master'].ACTINDX
239ITEMCODE SearchItem CodeSTR15String1615
240TCC SearchTax Commodity CodeSTR30_VATString3230
241PriceGroup SearchPrice GroupSTR10_LBAUString1210
242PRICMTHD SearchPrice MethodDDL_Price_MethodInteger20
243PRCHSUOM SearchPurchasing U Of MU_Of_MString108
244SELNGUOM SearchSelling U Of MU_Of_MString108
245KTACCTSR SearchKit COGS Account SourceGBInteger20
246LASTGENSN SearchLast Generated Serial NumberSTR20_LBAUString2220
247ABCCODE SearchABC CodeDDL_ABC_CodeInteger20
248STR30 SearchSTR30STR30String3230
249ORDERFULFILLDEFAULT SearchOrder Fulfillment Shortage DefaultDDL_OrderFulfillDefaultInteger20
250CUSTPRIORITY SearchCustomer PriorityDDL_CustomerPriorityInteger20
251SUBITEMNMBR SearchSubstitute Item NumberSTR30_Item_NumberString3230
azurecurveProductsSmartList (1493)PathnameSmartList Customer Items (ASIEXP24)

Leave a Reply

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