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