Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/ASIEXP24
Product: SmartList (1493)
Series:
Display Name: SmartList Customer Items
Physical Name: ASIEXP24
Technical Name: ASI_Item_Customer_ExplorerSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 ASI_Order_By 
ASI_Order_By Long Integer LI_14 14 2 ITEMNMBR Item Number String STR30_Item_Number 30 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'].ITEMNMBR3 CUSTNMBR Customer Number String STR15_RM_Customer_Number 15 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'].CUSTNMBR4 ASICUSTITNO ASI Customer Item Number String ASI_Customer_Item_Number 30 5 ASICUSTITDSC ASI Customer Item Description String ASI_Customer_Item_Description 50 6 ASICUSTITSNM ASI Customer Item Short Name String STR15 15 7 ASICUSTITGDSC ASI Customer Item Generic Description String STR10 10 8 USERDEF1 User Defined 1 String STR20 20 9 USERDEF2 User Defined 2 String STR20 20 10 USRDEF03 User Defined 3 String STR20 20 11 USRDEF04 User Defined 4 String STR20 20 12 USRDEF05 User Defined 5 String STR20 20 13 ASIUSERDEF1 ASI User Defined Key1 String STR50 50 14 ASIUSERDEF2 ASI User Defined Key2 String STR50 50 15 ASIUSERDEF3 ASI User Defined Key3 String STR50 50 16 ASIUSERDEF4 ASI User Defined Key4 String STR50 50 17 CUSTNAME Customer Name String STR64_Customer_Name 64 18 CUSTCLAS Customer Class String STR15_Customer_Class 15 19 CPRCSTNM Corporate Customer Number String STR15_RM_Customer_Number 15 20 CNTCPRSN Contact Person String STR60 60 21 STMTNAME Statement Name String STR64 64 22 SHRTNAME Short Name String STR15 15 23 ADRSCODE Address Code String STR15_Address_Code 15 24 UPSZONE UPS Zone String STR3 3 25 SHIPMTHD Shipping Method String STR15_Shipping_Method 15 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'].SHIPMTHD26 TAXSCHID Tax Schedule ID String STR15_Tax_Schedule_ID 15 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'].TAXSCHID27 ADDRESS1 Address 1 String STR60 60 28 ADDRESS2 Address 2 String STR60 60 29 ADDRESS3 Address 3 String STR60 60 30 COUNTRY Country String STR60 60 31 CITY City String STR35 35 32 STATE State String STR30_State 29 33 ZIP Zip String STR10 10 34 PHONE1 Phone 1 String Phone_Number 14 35 PHONE2 Phone 2 String Phone_Number 14 36 FAX Fax String STR14_FAX 14 37 PRBTADCD Primary Billto Address Code String STR15_LBAU 15 38 PRSTADCD Primary Shipto Address Code String STR15_LBAU 15 39 STADDRCD Statement Address Code String STR15_LBAU 15 40 SLPRSNID Salesperson ID String STR15_Salesperson_ID 15 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'].SLPRSNID41 CHEKBKID Checkbook ID String STR15_Checkbook_ID 15 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'].CHEKBKID42 PYMTRMID Payment Terms ID String STR20_Payment_Terms_ID 20 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'].PYMTRMID43 CRLMTTYP Credit Limit Type Integer GB_Amt_Type 0 44 CRLMTAMT Credit Limit Amount Currency DLR17_RBS0_UTR$ 17 45 CRLMTPER Credit Limit Period Integer DDL 0 46 CRLMTPAM Credit Limit Period Amount Currency DLR17_RBS0_UTR$ 17 47 CURNCYID Currency ID String STR15_Currency_ID 15 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'].CURNCYID48 RATETPID Rate Type ID String STR15_Rate_Type_ID 15 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'].RATETPID49 CUSTDISC Customer Discount Integer INT5_%2 5 50 PRCLEVEL PriceLevel String STR10_LBAU 10 51 MINPYTYP Minimum Payment Type Integer GB_Amt_Type 0 52 MINPYDLR Minimum Payment Dollar Currency DLR17_RBS0_UTR$ 17 53 MINPYPCT Minimum Payment Percent Integer INT5_%2 5 54 FNCHATYP Finance Charge Amt Type Integer GB_Amt_Type 0 55 FNCHPCNT Finance Charge Percent Integer INT5_%2 5 56 FINCHDLR Finance Charge Dollar Currency DLR17_RBS0_UTR$ 17 57 MXWOFTYP Maximum Writeoff Type Integer GP_Max_Writeoff 0 58 MXWROFAM Max Writeoff Amount Currency DLR17_RBS0_UTR$ 17 59 COMMENT1 Comment1 String STR30 30 60 COMMENT2 Comment2 String STR30 30 61 USERDEF11 ASI_User_Defined_1 String STR20 20 62 USERDEF21 ASI_User_Defined_2 String STR20 20 63 TAXEXMT1 Tax Exempt 1 String STR25 25 64 TAXEXMT2 Tax Exempt 2 String STR25 25 65 TXRGNNUM Tax Registration Number String STR25 25 66 BALNCTYP Balance Type Integer GB_Bal_Type 0 67 STMTCYCL Statement Cycle Integer DDL_Stmt_Cycle 0 68 BANKNAME Bank Name String STR30 30 69 BNKBRNCH Bank Branch String STR20 20 70 SALSTERR Sales Territory String STR15_Sales_Territory 15 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'].SALSTERR71 DEFCACTY Default Cash Account Type Integer GB 0 72 RMCSHACC RM Cash Account Index Long Integer LI_14 14 73 RMARACC RM AR Account Index Long Integer LI_14 14 74 RMSLSACC RM Sales Account Index Long Integer LI_14 14 75 RMIVACC RM IV Account Index Long Integer LI_14 14 76 RMCOSACC RM Cost Of Sales Account Index Long Integer LI_14 14 77 RMTAKACC RM Discounts Taken Account Index Long Integer LI_14 14 78 RMAVACC RM Discounts Avail Account Index Long Integer LI_14 14 79 RMFCGACC RM Finance Charge Account Index Long Integer LI_14 14 80 RMWRACC RM Writeoff Account Index Long Integer LI_14 14 81 FRSTINDT First Invoice Date Date DT_Date 6 82 INACTIVE Inactive Boolean CB_Inactive 0 83 HOLD Hold Boolean CB_Hold 0 84 CRCARDID Credit Card ID String STR15 15 85 CRCRDNUM Credit Card Number String STR20 20 86 CCRDXPDT Credit Card Exp Date Date DT_Date 6 87 KPDSTHST Keep Distribution History Boolean CB_Keep_Dist_History 0 88 KPCALHST Keep Calendar History Boolean CB_Keep_Calendar_History 0 89 KPERHIST Keep Period History Boolean CB_Keep_Period_History 0 90 KPTRXHST Keep Trx History Boolean CB_Keep_Trx_History 0 91 NOTEINDX Note Index Currency DLR14 14 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'].NOTEINDX92 CREATDDT Created Date Date DT 8 93 MODIFDT Modified Date Date DT 8 94 ASI_Favorite_Sequence ASI_Favorite_Sequence Long Integer ASI_LI_10_RU 10 95 TNSFCLIF Total Amount Of NSF Checks Life Currency DLR19_RBS0_STR$ 19 96 NONSFLIF Number Of NSF Checks Life Long Integer LI6_U0 6 97 CUSTBLNC Customer Balance Currency DLR19_RBS0_STR$ 19 98 AGPERAMT_1 Aging Period Amounts[1] Currency DLR17_RBSO_STR$ 17 99 AGPERAMT_2 Aging Period Amounts[2] Currency DLR17_RBSO_STR$ 17 100 AGPERAMT_3 Aging Period Amounts[3] Currency DLR17_RBSO_STR$ 17 101 AGPERAMT_4 Aging Period Amounts[4] Currency DLR17_RBSO_STR$ 17 102 AGPERAMT_5 Aging Period Amounts[5] Currency DLR17_RBSO_STR$ 17 103 AGPERAMT_6 Aging Period Amounts[6] Currency DLR17_RBSO_STR$ 17 104 AGPERAMT_7 Aging Period Amounts[7] Currency DLR17_RBSO_STR$ 17 105 LASTAGED Last Aged Date DATE 6 106 LSTNSFCD Last NSF Check Date Date DT_Date 6 107 LPYMTAMT Last Payment Amount Currency DLR17_RBS0_STR$ 17 108 LASTPYDT Last Payment Date Date DT_Date 6 109 LSTTRXDT Last Transaction Date Date DT_Date 6 110 LSTTRXAM Last Transaction Amount Currency DLR17_RBS0_STR$ 17 111 LSTFCHAM Last Finance Charge Amount Currency DLR19_RBS0_STR$ 19 112 UPFCHYTD Unpaid Finance Charges YTD Currency DLR17_RBS0_UTR$ 17 113 AVDTPLYR Average Days to Pay - LYR Integer INT3_U0 3 114 AVDTPLIF Average Days To Pay - Life Integer INT3_U0 3 115 AVGDTPYR Average Days To Pay - Year Integer INT3_U0 3 116 NUMADTPL Number ADTP Documents - Life Long Integer Long_10U 10 117 NUMADTPY Number ADTP Documents - Year Long Integer Long_10U 10 118 NUMADTPR Number ADTP Documents - LYR Long Integer Long_10U 10 119 TDTKNYTD Total Discounts Taken YTD Currency DLR19_RBS0_STR$ 19 120 TDTKNLYR Total Discounts Taken LYR Currency DLR19_RBS0_STR$ 19 121 TDTKNLTD Total Discounts Taken LTD Currency DLR19_RBS0_STR$ 19 122 TDISAYTD Total Discounts Available YTD Currency DLR19_RBS0_STR$ 19 123 RETAINAG Retainage Currency DLR19_RBS0_STR$ 19 124 TNSFCYTD Total Amount Of NSF Checks YTD Currency DLR19_RBS0_STR$ 19 125 NONSFYTD Number Of NSF Checks YTD Long Integer LI6_U0 6 126 UNPSTDSA Unposted Sales Amount Currency DLR19_RBS0_UTR$ 19 127 UNPSTDCA Unposted Cash Amount Currency DLR19_RBS0_UTR$ 19 128 UNPSTOSA Unposted Other Sales Amount Currency DLR19_RBS0_UTR$ 19 129 UNPSTOCA Unposted Other Cash Amount Currency DLR19_RBS0_UTR$ 19 130 NCSCHPMT Non Current Scheduled Payments Currency DLR19_RBS0_STR$ 19 131 TTLSLYTD Total Sales YTD Currency DLR19_RBS0_STR$ 19 132 TTLSLLTD Total Sales LTD Currency DLR19_RBS0_STR$ 19 133 TTLSLLYR Total Sales LYR Currency DLR19_RBS0_STR$ 19 134 TCOSTYTD Total Costs YTD Currency DLR19_RBS0_STR$ 19 135 TCOSTLTD Total Costs LTD Currency DLR19_RBS0_STR$ 19 136 TCOSTLYR Total Costs LYR Currency DLR19_RBS0_STR$ 19 137 TCSHRYTD Total Cash Received YTD Currency DLR19_RBS0_STR$ 19 138 TCSHRLTD Total Cash Received LTD Currency DLR19_RBS0_STR$ 19 139 TCSHRLYR Total Cash Received LYR Currency DLR19_RBS0_STR$ 19 140 TFNCHYTD Total Finance Charges YTD Currency DLR19_RBS0_STR$ 19 141 TFNCHLTD Total Finance Charges LTD Currency DLR19_RBS0_STR$ 19 142 TFNCHLYR Total Finance Charges LYR Currency DLR19_RBS0_STR$ 19 143 FNCHCYTD Finance Charges CYTD Currency DLR19_RBS0_STR$ 19 144 FNCHLYRC Finance Charges LYR Calendar Currency DLR19_RBS0_STR$ 19 145 TBDDTYTD Total Bad Debt YTD Currency DLR19_RBS0_STR$ 19 146 TBDDTLYR Total Bad Deb LYR Currency DLR19_RBS0_STR$ 19 147 TBDDTLTD Total Bad Debt LTD Currency DLR19_RBS0_STR$ 19 148 TWVFCYTD Total Waived FC YTD Currency DLR19_RBS0_STR$ 19 149 TWVFCLTD Total Waived FC LTD Currency DLR19_RBS0_STR$ 19 150 TWVFCLYR Total Waived FC LYR Currency DLR19_RBS0_STR$ 19 151 TWROFYTD Total Writeoffs YTD Currency DLR19_RBS0_STR$ 19 152 TWROFLTD Total Writeoffs LTD Currency DLR19_RBS0_STR$ 19 153 TWROFLYR Total Writeoffs LYR Currency DLR19_RBS0_STR$ 19 154 TTLINYTD Total # Invoices YTD Long Integer LI6_U0 6 155 TTLINLTD Total # Invoices LTD Long Integer LI6_U0 6 156 TTLINLYR Total # Invoices LYR Long Integer LI6_U0 6 157 TTLFCYTD Total # FC YTD Long Integer LI6_U0 6 158 TTLFCLTD Total # FC LTD Long Integer LI6_U0 6 159 TTLFCLYR Total # FC LYR Long Integer LI6_U0 6 160 WROFSLIF Write Offs LIFE Currency DLR19_RBS0_STR$ 19 161 WROFSLYR Write Offs LYR Currency DLR19_RBS0_STR$ 19 162 WROFSYTD Write Offs YTD Currency DLR19_RBS0_STR$ 19 163 HIBALLYR High Balance LYR Currency DLR19_RBSO_STR$ 19 164 HIBALYTD High Balance YTD Currency DLR19_RBSO_STR$ 19 165 HIBALLTD High Balance LTD Currency DLR19_RBSO_STR$ 19 166 LASTSTDT Last Statement Date Date DATE 6 167 LSTSTAMT Last Statement Amount Currency DLR17_RBS0_STR$ 17 168 DEPRECV Deposits Received Currency DLR19_RBS0_STR$ 19 169 ONORDAMT On Order Amount Currency DLR19_RBS0_UTR$ 19 170 Revalue_Customer Revalue Customer Boolean CB Revalue Customer 0 171 Post_Results_To Post Results To Integer GB 0 172 FINCHID Finance Charge ID String STR15_Charge_ID 15 173 GOVCRPID Governmental Corporate ID String STR30_Gov_Corp_ID 30 174 GOVINDID Governmental Individual ID String STR30_Gov_Indiv_ID 30 175 DISGRPER Discount Grace Period Integer INT2_U0 2 176 DOCFMTID Document Format ID String STR15_LBU 15 177 DUEGRPER Due Date Grace Period Integer INT2_U0 2 178 PHONE3 Phone 3 String Phone_Number3 14 179 TTLRTLTD Total Returns LTD Currency DLR19_RBS0_STR$ 19 180 TTLRTLYR Total Returns LYR Currency DLR19_RBS0_STR$ 19 181 TTLRTYTD Total Returns YTD Currency DLR19_RBS0_STR$ 19 182 ITEMDESC Item Description String STR100 100 183 NOTEINDX1 ASI_Note_Index Currency DLR14 14 184 ITMSHNAM Item Short Name String STR15 15 185 ITEMTYPE Item Type Integer DDL_Item_Type 0 186 ITMGEDSC Item Generic Description String STR10 10 187 STNDCOST Standard Cost Currency DLR17_RBS0_UTR$ 17 188 CURRCOST Current Cost Currency DLR17_RBS0_UTR$ 17 189 ITEMSHWT Item Shipping Weight Long Integer LI6_RBS2_UT 6 190 DECPLQTY Decimal Places QTYS Integer DDL_Decimal_Places_QTYS 0 191 DECPLCUR Decimal Places Currency Integer DDL_Decimal_Places_Dollars 0 192 ITMTSHID Item Tax Schedule ID String STR15_LBAU 15 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'].TAXSCHID193 TAXOPTNS Tax Options Integer DDL_Tax_Options 0 194 IVIVINDX IV IV Index Long Integer LI_14 14 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'].ACTINDX195 IVIVOFIX IV IV Offset Index Long Integer LI_14 14 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'].ACTINDX196 IVCOGSIX IV COGS Index Long Integer LI_14 14 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'].ACTINDX197 IVSLSIDX IV Sales Index Long Integer LI_14 14 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'].ACTINDX198 IVSLDSIX IV Sales Discounts Index Long Integer LI_14 14 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'].ACTINDX199 IVSLRNIX IV Sales Returns Index Long Integer LI_14 14 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'].ACTINDX200 IVINUSIX IV In Use Index Long Integer LI_14 14 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'].ACTINDX201 IVINSVIX IV In Service Index Long Integer LI_14 14 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'].ACTINDX202 IVDMGIDX IV Damaged Index Long Integer LI_14 14 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'].ACTINDX203 IVVARIDX IV Variances Index Long Integer LI_14 14 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'].ACTINDX204 DPSHPIDX Drop Ship Index Long Integer LI_14 14 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'].ACTINDX205 PURPVIDX Purchase Price Variance Index Long Integer LI_14 14 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'].ACTINDX206 UPPVIDX Unrealized Purchase Price Variance Index Long Integer LI_14 14 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'].ACTINDX207 IVRETIDX Inventory Returns Index Long Integer LI_14 14 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'].ACTINDX208 ASMVRIDX Assembly Variance Index Long Integer LI_14 14 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'].ACTINDX209 ITMCLSCD Item Class Code String STR10_Class_ID 10 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'].ITMCLSCD210 ITMTRKOP Item Tracking Option Integer DDL_Track 0 211 LOTTYPE Lot Type String STR10_Lot_Type 10 212 KPERHIST1 ASI_Keep_Period_History Boolean CB_Keep_Period_History 0 213 KPTRXHST1 ASI_Keep_Trx_History Boolean CB_Keep_Trx_History 0 214 KPCALHST1 ASI_Keep_Calendar_History Boolean CB_Keep_Calendar_History 0 215 KPDSTHST1 ASI_Keep_Distribution_History Boolean CB_Keep_Dist_History 0 216 ALWBKORD Allow Back Orders Boolean CB_Allow_Back_Orders 0 217 VCTNMTHD Valuation Method Integer DDL_Valuation_Method 0 218 UOMSCHDL U Of M Schedule String STR10_Schedule 10 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'].UOMSCHDL219 ALTITEM1 Alternate Item 1 String STR30_Item_Number 30 220 ALTITEM2 Alternate Item 2 String STR30_Item_Number 30 221 USCATVLS_1 User Category Values[1] String User_Category_Value 10 222 USCATVLS_2 User Category Values[2] String User_Category_Value 10 223 USCATVLS_3 User Category Values[3] String User_Category_Value 10 224 USCATVLS_4 User Category Values[4] String User_Category_Value 10 225 USCATVLS_5 User Category Values[5] String User_Category_Value 10 226 USCATVLS_6 User Category Values[6] String User_Category_Value 10 227 MSTRCDTY Master Record Type Integer INT1 1 228 MODIFDT1 ASI_Modified_Date Date DT 8 229 CREATDDT1 ASI_Created_Date Date DT 8 230 WRNTYDYS Warranty Days Integer INT4 4 231 PRCLEVEL1 ASI_PriceLevel String STR10_LBAU 10 232 LOCNCODE Location Code String STR10_Location_Code 10 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'].LOCNCODE233 PINFLIDX Purch Inflation Index Long Integer LI_14 14 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'].ACTINDX234 PURMCIDX Purch Monetary Correction Index Long Integer LI_14 14 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'].ACTINDX235 IVINFIDX Inventory Inflation Index Long Integer LI_14 14 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'].ACTINDX236 INVMCIDX Inventory Monetary Correction Index Long Integer LI_14 14 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'].ACTINDX237 CGSINFLX COGS Inflation Index Long Integer LI_14 14 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'].ACTINDX238 CGSMCIDX COGS Monetary Correction Index Long Integer LI_14 14 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'].ACTINDX239 ITEMCODE Item Code String STR15 15 240 TCC Tax Commodity Code String STR30_VAT 30 241 PriceGroup Price Group String STR10_LBAU 10 242 PRICMTHD Price Method Integer DDL_Price_Method 0 243 PRCHSUOM Purchasing U Of M String U_Of_M 8 244 SELNGUOM Selling U Of M String U_Of_M 8 245 KTACCTSR Kit COGS Account Source Integer GB 0 246 LASTGENSN Last Generated Serial Number String STR20_LBAU 20 247 ABCCODE ABC Code Integer DDL_ABC_Code 0 248 STR30 STR30 String STR30 30 249 ORDERFULFILLDEFAULT Order Fulfillment Shortage Default Integer DDL_OrderFulfillDefault 0 250 CUSTPRIORITY Customer Priority Integer DDL_CustomerPriority 0 251 SUBITEMNMBR Substitute Item Number String STR30_Item_Number 30