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 TypeLength
1ASI_Order_By SearchASI_Order_ByLI_14Long Integer14
2ITEMNMBR SearchItem NumberSTR30_Item_NumberString30
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_NumberString15
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_NumberString30
5ASICUSTITDSC SearchASI Customer Item DescriptionASI_Customer_Item_DescriptionString50
6ASICUSTITSNM SearchASI Customer Item Short NameSTR15String15
7ASICUSTITGDSC SearchASI Customer Item Generic DescriptionSTR10String10
8USERDEF1 SearchUser Defined 1STR20String20
9USERDEF2 SearchUser Defined 2STR20String20
10USRDEF03 SearchUser Defined 3STR20String20
11USRDEF04 SearchUser Defined 4STR20String20
12USRDEF05 SearchUser Defined 5STR20String20
13ASIUSERDEF1 SearchASI User Defined Key1STR50String50
14ASIUSERDEF2 SearchASI User Defined Key2STR50String50
15ASIUSERDEF3 SearchASI User Defined Key3STR50String50
16ASIUSERDEF4 SearchASI User Defined Key4STR50String50
17CUSTNAME SearchCustomer NameSTR64_Customer_NameString64
18CUSTCLAS SearchCustomer ClassSTR15_Customer_ClassString15
19CPRCSTNM SearchCorporate Customer NumberSTR15_RM_Customer_NumberString15
20CNTCPRSN SearchContact PersonSTR60String60
21STMTNAME SearchStatement NameSTR64String64
22SHRTNAME SearchShort NameSTR15String15
23ADRSCODE SearchAddress CodeSTR15_Address_CodeString15
24UPSZONE SearchUPS ZoneSTR3String3
25SHIPMTHD SearchShipping MethodSTR15_Shipping_MethodString15
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_IDString15
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 1STR60String60
28ADDRESS2 SearchAddress 2STR60String60
29ADDRESS3 SearchAddress 3STR60String60
30COUNTRY SearchCountrySTR60String60
31CITY SearchCitySTR35String35
32STATE SearchStateSTR30_StateString29
33ZIP SearchZipSTR10String10
34PHONE1 SearchPhone 1Phone_NumberString14
35PHONE2 SearchPhone 2Phone_NumberString14
36FAX SearchFaxSTR14_FAXString14
37PRBTADCD SearchPrimary Billto Address CodeSTR15_LBAUString15
38PRSTADCD SearchPrimary Shipto Address CodeSTR15_LBAUString15
39STADDRCD SearchStatement Address CodeSTR15_LBAUString15
40SLPRSNID SearchSalesperson IDSTR15_Salesperson_IDString15
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_IDString15
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_IDString20
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_TypeInteger0
44CRLMTAMT SearchCredit Limit AmountDLR17_RBS0_UTR$Currency17
45CRLMTPER SearchCredit Limit PeriodDDLInteger0
46CRLMTPAM SearchCredit Limit Period AmountDLR17_RBS0_UTR$Currency17
47CURNCYID SearchCurrency IDSTR15_Currency_IDString15
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_IDString15
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_%2Integer5
50PRCLEVEL SearchPriceLevelSTR10_LBAUString10
51MINPYTYP SearchMinimum Payment TypeGB_Amt_TypeInteger0
52MINPYDLR SearchMinimum Payment DollarDLR17_RBS0_UTR$Currency17
53MINPYPCT SearchMinimum Payment PercentINT5_%2Integer5
54FNCHATYP SearchFinance Charge Amt TypeGB_Amt_TypeInteger0
55FNCHPCNT SearchFinance Charge PercentINT5_%2Integer5
56FINCHDLR SearchFinance Charge DollarDLR17_RBS0_UTR$Currency17
57MXWOFTYP SearchMaximum Writeoff TypeGP_Max_WriteoffInteger0
58MXWROFAM SearchMax Writeoff AmountDLR17_RBS0_UTR$Currency17
59COMMENT1 SearchComment1STR30String30
60COMMENT2 SearchComment2STR30String30
61USERDEF11 SearchASI_User_Defined_1STR20String20
62USERDEF21 SearchASI_User_Defined_2STR20String20
63TAXEXMT1 SearchTax Exempt 1STR25String25
64TAXEXMT2 SearchTax Exempt 2STR25String25
65TXRGNNUM SearchTax Registration NumberSTR25String25
66BALNCTYP SearchBalance TypeGB_Bal_TypeInteger0
67STMTCYCL SearchStatement CycleDDL_Stmt_CycleInteger0
68BANKNAME SearchBank NameSTR30String30
69BNKBRNCH SearchBank BranchSTR20String20
70SALSTERR SearchSales TerritorySTR15_Sales_TerritoryString15
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 TypeGBInteger0
72RMCSHACC SearchRM Cash Account IndexLI_14Long Integer14
73RMARACC SearchRM AR Account IndexLI_14Long Integer14
74RMSLSACC SearchRM Sales Account IndexLI_14Long Integer14
75RMIVACC SearchRM IV Account IndexLI_14Long Integer14
76RMCOSACC SearchRM Cost Of Sales Account IndexLI_14Long Integer14
77RMTAKACC SearchRM Discounts Taken Account IndexLI_14Long Integer14
78RMAVACC SearchRM Discounts Avail Account IndexLI_14Long Integer14
79RMFCGACC SearchRM Finance Charge Account IndexLI_14Long Integer14
80RMWRACC SearchRM Writeoff Account IndexLI_14Long Integer14
81FRSTINDT SearchFirst Invoice DateDT_DateDate6
82INACTIVE SearchInactiveCB_InactiveBoolean0
83HOLD SearchHoldCB_HoldBoolean0
84CRCARDID SearchCredit Card IDSTR15String15
85CRCRDNUM SearchCredit Card NumberSTR20String20
86CCRDXPDT SearchCredit Card Exp DateDT_DateDate6
87KPDSTHST SearchKeep Distribution HistoryCB_Keep_Dist_HistoryBoolean0
88KPCALHST SearchKeep Calendar HistoryCB_Keep_Calendar_HistoryBoolean0
89KPERHIST SearchKeep Period HistoryCB_Keep_Period_HistoryBoolean0
90KPTRXHST SearchKeep Trx HistoryCB_Keep_Trx_HistoryBoolean0
91NOTEINDX SearchNote IndexDLR14Currency14
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 DateDTDate8
93MODIFDT SearchModified DateDTDate8
94ASI_Favorite_Sequence SearchASI_Favorite_SequenceASI_LI_10_RULong Integer10
95TNSFCLIF SearchTotal Amount Of NSF Checks LifeDLR19_RBS0_STR$Currency19
96NONSFLIF SearchNumber Of NSF Checks LifeLI6_U0Long Integer6
97CUSTBLNC SearchCustomer BalanceDLR19_RBS0_STR$Currency19
98AGPERAMT_1 SearchAging Period Amounts[1]DLR17_RBSO_STR$Currency17
99AGPERAMT_2 SearchAging Period Amounts[2]DLR17_RBSO_STR$Currency17
100AGPERAMT_3 SearchAging Period Amounts[3]DLR17_RBSO_STR$Currency17
101AGPERAMT_4 SearchAging Period Amounts[4]DLR17_RBSO_STR$Currency17
102AGPERAMT_5 SearchAging Period Amounts[5]DLR17_RBSO_STR$Currency17
103AGPERAMT_6 SearchAging Period Amounts[6]DLR17_RBSO_STR$Currency17
104AGPERAMT_7 SearchAging Period Amounts[7]DLR17_RBSO_STR$Currency17
105LASTAGED SearchLast AgedDATEDate6
106LSTNSFCD SearchLast NSF Check DateDT_DateDate6
107LPYMTAMT SearchLast Payment AmountDLR17_RBS0_STR$Currency17
108LASTPYDT SearchLast Payment DateDT_DateDate6
109LSTTRXDT SearchLast Transaction DateDT_DateDate6
110LSTTRXAM SearchLast Transaction AmountDLR17_RBS0_STR$Currency17
111LSTFCHAM SearchLast Finance Charge AmountDLR19_RBS0_STR$Currency19
112UPFCHYTD SearchUnpaid Finance Charges YTDDLR17_RBS0_UTR$Currency17
113AVDTPLYR SearchAverage Days to Pay - LYRINT3_U0Integer3
114AVDTPLIF SearchAverage Days To Pay - LifeINT3_U0Integer3
115AVGDTPYR SearchAverage Days To Pay - YearINT3_U0Integer3
116NUMADTPL SearchNumber ADTP Documents - LifeLong_10ULong Integer10
117NUMADTPY SearchNumber ADTP Documents - YearLong_10ULong Integer10
118NUMADTPR SearchNumber ADTP Documents - LYRLong_10ULong Integer10
119TDTKNYTD SearchTotal Discounts Taken YTDDLR19_RBS0_STR$Currency19
120TDTKNLYR SearchTotal Discounts Taken LYRDLR19_RBS0_STR$Currency19
121TDTKNLTD SearchTotal Discounts Taken LTDDLR19_RBS0_STR$Currency19
122TDISAYTD SearchTotal Discounts Available YTDDLR19_RBS0_STR$Currency19
123RETAINAG SearchRetainageDLR19_RBS0_STR$Currency19
124TNSFCYTD SearchTotal Amount Of NSF Checks YTDDLR19_RBS0_STR$Currency19
125NONSFYTD SearchNumber Of NSF Checks YTDLI6_U0Long Integer6
126UNPSTDSA SearchUnposted Sales AmountDLR19_RBS0_UTR$Currency19
127UNPSTDCA SearchUnposted Cash AmountDLR19_RBS0_UTR$Currency19
128UNPSTOSA SearchUnposted Other Sales AmountDLR19_RBS0_UTR$Currency19
129UNPSTOCA SearchUnposted Other Cash AmountDLR19_RBS0_UTR$Currency19
130NCSCHPMT SearchNon Current Scheduled PaymentsDLR19_RBS0_STR$Currency19
131TTLSLYTD SearchTotal Sales YTDDLR19_RBS0_STR$Currency19
132TTLSLLTD SearchTotal Sales LTDDLR19_RBS0_STR$Currency19
133TTLSLLYR SearchTotal Sales LYRDLR19_RBS0_STR$Currency19
134TCOSTYTD SearchTotal Costs YTDDLR19_RBS0_STR$Currency19
135TCOSTLTD SearchTotal Costs LTDDLR19_RBS0_STR$Currency19
136TCOSTLYR SearchTotal Costs LYRDLR19_RBS0_STR$Currency19
137TCSHRYTD SearchTotal Cash Received YTDDLR19_RBS0_STR$Currency19
138TCSHRLTD SearchTotal Cash Received LTDDLR19_RBS0_STR$Currency19
139TCSHRLYR SearchTotal Cash Received LYRDLR19_RBS0_STR$Currency19
140TFNCHYTD SearchTotal Finance Charges YTDDLR19_RBS0_STR$Currency19
141TFNCHLTD SearchTotal Finance Charges LTDDLR19_RBS0_STR$Currency19
142TFNCHLYR SearchTotal Finance Charges LYRDLR19_RBS0_STR$Currency19
143FNCHCYTD SearchFinance Charges CYTDDLR19_RBS0_STR$Currency19
144FNCHLYRC SearchFinance Charges LYR CalendarDLR19_RBS0_STR$Currency19
145TBDDTYTD SearchTotal Bad Debt YTDDLR19_RBS0_STR$Currency19
146TBDDTLYR SearchTotal Bad Deb LYRDLR19_RBS0_STR$Currency19
147TBDDTLTD SearchTotal Bad Debt LTDDLR19_RBS0_STR$Currency19
148TWVFCYTD SearchTotal Waived FC YTDDLR19_RBS0_STR$Currency19
149TWVFCLTD SearchTotal Waived FC LTDDLR19_RBS0_STR$Currency19
150TWVFCLYR SearchTotal Waived FC LYRDLR19_RBS0_STR$Currency19
151TWROFYTD SearchTotal Writeoffs YTDDLR19_RBS0_STR$Currency19
152TWROFLTD SearchTotal Writeoffs LTDDLR19_RBS0_STR$Currency19
153TWROFLYR SearchTotal Writeoffs LYRDLR19_RBS0_STR$Currency19
154TTLINYTD SearchTotal # Invoices YTDLI6_U0Long Integer6
155TTLINLTD SearchTotal # Invoices LTDLI6_U0Long Integer6
156TTLINLYR SearchTotal # Invoices LYRLI6_U0Long Integer6
157TTLFCYTD SearchTotal # FC YTDLI6_U0Long Integer6
158TTLFCLTD SearchTotal # FC LTDLI6_U0Long Integer6
159TTLFCLYR SearchTotal # FC LYRLI6_U0Long Integer6
160WROFSLIF SearchWrite Offs LIFEDLR19_RBS0_STR$Currency19
161WROFSLYR SearchWrite Offs LYRDLR19_RBS0_STR$Currency19
162WROFSYTD SearchWrite Offs YTDDLR19_RBS0_STR$Currency19
163HIBALLYR SearchHigh Balance LYRDLR19_RBSO_STR$Currency19
164HIBALYTD SearchHigh Balance YTDDLR19_RBSO_STR$Currency19
165HIBALLTD SearchHigh Balance LTDDLR19_RBSO_STR$Currency19
166LASTSTDT SearchLast Statement DateDATEDate6
167LSTSTAMT SearchLast Statement AmountDLR17_RBS0_STR$Currency17
168DEPRECV SearchDeposits ReceivedDLR19_RBS0_STR$Currency19
169ONORDAMT SearchOn Order AmountDLR19_RBS0_UTR$Currency19
170Revalue_Customer SearchRevalue CustomerCB Revalue CustomerBoolean0
171Post_Results_To SearchPost Results ToGBInteger0
172FINCHID SearchFinance Charge IDSTR15_Charge_IDString15
173GOVCRPID SearchGovernmental Corporate IDSTR30_Gov_Corp_IDString30
174GOVINDID SearchGovernmental Individual IDSTR30_Gov_Indiv_IDString30
175DISGRPER SearchDiscount Grace PeriodINT2_U0Integer2
176DOCFMTID SearchDocument Format IDSTR15_LBUString15
177DUEGRPER SearchDue Date Grace PeriodINT2_U0Integer2
178PHONE3 SearchPhone 3Phone_Number3String14
179TTLRTLTD SearchTotal Returns LTDDLR19_RBS0_STR$Currency19
180TTLRTLYR SearchTotal Returns LYRDLR19_RBS0_STR$Currency19
181TTLRTYTD SearchTotal Returns YTDDLR19_RBS0_STR$Currency19
182ITEMDESC SearchItem DescriptionSTR100String100
183NOTEINDX1 SearchASI_Note_IndexDLR14Currency14
184ITMSHNAM SearchItem Short NameSTR15String15
185ITEMTYPE SearchItem TypeDDL_Item_TypeInteger0
186ITMGEDSC SearchItem Generic DescriptionSTR10String10
187STNDCOST SearchStandard CostDLR17_RBS0_UTR$Currency17
188CURRCOST SearchCurrent CostDLR17_RBS0_UTR$Currency17
189ITEMSHWT SearchItem Shipping WeightLI6_RBS2_UTLong Integer6
190DECPLQTY SearchDecimal Places QTYSDDL_Decimal_Places_QTYSInteger0
191DECPLCUR SearchDecimal Places CurrencyDDL_Decimal_Places_DollarsInteger0
192ITMTSHID SearchItem Tax Schedule IDSTR15_LBAUString15
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_OptionsInteger0
194IVIVINDX SearchIV IV IndexLI_14Long Integer14
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 Integer14
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 Integer14
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 Integer14
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 Integer14
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 Integer14
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 Integer14
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 Integer14
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 Integer14
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 Integer14
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 Integer14
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 Integer14
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 Integer14
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 Integer14
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 Integer14
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_IDString10
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_TrackInteger0
211LOTTYPE SearchLot TypeSTR10_Lot_TypeString10
212KPERHIST1 SearchASI_Keep_Period_HistoryCB_Keep_Period_HistoryBoolean0
213KPTRXHST1 SearchASI_Keep_Trx_HistoryCB_Keep_Trx_HistoryBoolean0
214KPCALHST1 SearchASI_Keep_Calendar_HistoryCB_Keep_Calendar_HistoryBoolean0
215KPDSTHST1 SearchASI_Keep_Distribution_HistoryCB_Keep_Dist_HistoryBoolean0
216ALWBKORD SearchAllow Back OrdersCB_Allow_Back_OrdersBoolean0
217VCTNMTHD SearchValuation MethodDDL_Valuation_MethodInteger0
218UOMSCHDL SearchU Of M ScheduleSTR10_ScheduleString10
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_NumberString30
220ALTITEM2 SearchAlternate Item 2STR30_Item_NumberString30
221USCATVLS_1 SearchUser Category Values[1]User_Category_ValueString10
222USCATVLS_2 SearchUser Category Values[2]User_Category_ValueString10
223USCATVLS_3 SearchUser Category Values[3]User_Category_ValueString10
224USCATVLS_4 SearchUser Category Values[4]User_Category_ValueString10
225USCATVLS_5 SearchUser Category Values[5]User_Category_ValueString10
226USCATVLS_6 SearchUser Category Values[6]User_Category_ValueString10
227MSTRCDTY SearchMaster Record TypeINT1Integer1
228MODIFDT1 SearchASI_Modified_DateDTDate8
229CREATDDT1 SearchASI_Created_DateDTDate8
230WRNTYDYS SearchWarranty DaysINT4Integer4
231PRCLEVEL1 SearchASI_PriceLevelSTR10_LBAUString10
232LOCNCODE SearchLocation CodeSTR10_Location_CodeString10
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 Integer14
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 Integer14
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 Integer14
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 Integer14
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 Integer14
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 Integer14
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 CodeSTR15String15
240TCC SearchTax Commodity CodeSTR30_VATString30
241PriceGroup SearchPrice GroupSTR10_LBAUString10
242PRICMTHD SearchPrice MethodDDL_Price_MethodInteger0
243PRCHSUOM SearchPurchasing U Of MU_Of_MString8
244SELNGUOM SearchSelling U Of MU_Of_MString8
245KTACCTSR SearchKit COGS Account SourceGBInteger0
246LASTGENSN SearchLast Generated Serial NumberSTR20_LBAUString20
247ABCCODE SearchABC CodeDDL_ABC_CodeInteger0
248STR30 SearchSTR30STR30String30
249ORDERFULFILLDEFAULT SearchOrder Fulfillment Shortage DefaultDDL_OrderFulfillDefaultInteger0
250CUSTPRIORITY SearchCustomer PriorityDDL_CustomerPriorityInteger0
251SUBITEMNMBR SearchSubstitute Item NumberSTR30_Item_NumberString30
azurecurveProductsSmartList (1493)PathnameSmartList Customer Items (ASIEXP24)

Leave a Reply

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