Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/ASIEXP23
Product: SmartList (1493)
Series:
Display Name: Item Vendor SmartList
Physical Name: ASIEXP23
Technical Name: ASI_Item_Vendor_ExplorerSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 ASI_Favorite_Sequence 
ASI_Favorite_Sequence Long Integer ASI_LI_10_RU 10 2 ASI_Order_By ASI_Order_By Long Integer LI_14 14 3 ITEMNMBR Item Number String STR30_Item_Number 30 Key to the Item Master (IV00101).
Click to show/hide
SELECT
['Item Vendor SmartList'].ITEMNMBR AS 'Item Vendor SmartList-Item Number'
,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
ASIEXP23 AS ['Item Vendor SmartList']
INNER JOIN
IV00101 AS ['Item Master']
ON
['Item Vendor SmartList'].ITEMNMBR = ['Item Master'].ITEMNMBR4 VENDORID Vendor ID String STR_15_Vendor_ID 15 Key to the PM Vendor Master File (PM00200).
Click to show/hide
SELECT
['Item Vendor SmartList'].VENDORID AS 'Item Vendor SmartList-Vendor ID'
,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
ASIEXP23 AS ['Item Vendor SmartList']
INNER JOIN
PM00200 AS ['PM Vendor Master File']
ON
['Item Vendor SmartList'].VENDORID = ['PM Vendor Master File'].VENDORID5 ITMVNDTY Item Vendor Type Integer INT 0 6 VNDITNUM Vendor Item Number String Item_Number 30 7 QTYRQSTN QTY Requisitioned Currency DLR17_QTY_RBS0_UTR 17 8 QTYONORD QTY On Order Currency DLR17_QTY_RBS0_UTR 17 9 QTY_Drop_Shipped QTY Drop Shipped Currency DLR17_QTY_RBS0_UTR 17 10 LSTORDDT Last ORD Date Date DATE 6 11 LSORDQTY Last ORD QTY Currency DLR17_QTY_RBS0_UTR 17 12 LRCPTQTY Last RCPT QTY Currency DLR17_QTY_RBS0_UTR 17 13 LSRCPTDT Last RCPT Date Date DATE 6 14 LRCPTCST Last RCPT Cost Currency DLR17_RBS0_UTR$ 17 15 AVRGLDTM Average Lead Time Long Integer LI6_RBS2_UT 6 16 NORCTITM Number Of RCPTS For Item Integer INT4 4 17 MINORQTY Minimum ORD QTY Currency DLR17_QTY_RBS0_UTR 17 18 MAXORDQTY Maximum ORD QTY Currency DLR17_QTY_RBS0_UTR 17 19 ECORDQTY Economic ORD QTY Currency DLR17_QTY_RBS0_UTR 17 20 VNDITDSC Vendor Item Description String STR100 100 21 Last_Originating_Cost Last Originating Cost Currency DLR17_RBS0_UTR$ 17 22 Last_Currency_ID Last Currency ID String STR15_Currency_ID 15 23 FREEONBOARD Free On Board Integer DDL_Free_On_Board 0 24 PRCHSUOM Purchasing U Of M String U_Of_M 8 25 CURRNIDX Currency Index Integer INT3 3 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['Item Vendor SmartList'].CURRNIDX AS 'Item Vendor SmartList-Currency Index'
,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
ASIEXP23 AS ['Item Vendor SmartList']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['Item Vendor SmartList'].CURRNIDX = ['Currency Setup'].CURRNIDX26 PLANNINGLEADTIME Planning Lead Time Integer INT4_RB_U0 4 27 ABCCODE ABC Code Integer DDL_ABC_Code 0 28 ALWBKORD Allow Back Orders Boolean CB_Allow_Back_Orders 0 29 ALTITEM1 Alternate Item 1 String STR30_Item_Number 30 30 ALTITEM2 Alternate Item 2 String STR30_Item_Number 30 31 ASMVRIDX Assembly Variance Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['Item Vendor SmartList'].ASMVRIDX AS 'Item Vendor SmartList-Assembly Variance Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP23 AS ['Item Vendor SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['Item Vendor SmartList'].ASMVRIDX = ['Account Index Master'].ACTINDX32 CGSINFLX COGS Inflation Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['Item Vendor SmartList'].CGSINFLX AS 'Item Vendor SmartList-COGS Inflation Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP23 AS ['Item Vendor SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['Item Vendor SmartList'].CGSINFLX = ['Account Index Master'].ACTINDX33 CGSMCIDX COGS Monetary Correction Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['Item Vendor SmartList'].CGSMCIDX AS 'Item Vendor SmartList-COGS Monetary Correction Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP23 AS ['Item Vendor SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['Item Vendor SmartList'].CGSMCIDX = ['Account Index Master'].ACTINDX34 CREATDDT Created Date Date DT 8 35 CURRCOST Current Cost Currency DLR17_RBS0_UTR$ 17 36 DECPLCUR Decimal Places Currency Integer DDL_Decimal_Places_Dollars 0 37 DECPLQTY Decimal Places QTYS Integer DDL_Decimal_Places_QTYS 0 38 DPSHPIDX Drop Ship Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['Item Vendor SmartList'].DPSHPIDX AS 'Item Vendor SmartList-Drop Ship Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP23 AS ['Item Vendor SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['Item Vendor SmartList'].DPSHPIDX = ['Account Index Master'].ACTINDX39 IVINFIDX Inventory Inflation Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['Item Vendor SmartList'].IVINFIDX AS 'Item Vendor SmartList-Inventory Inflation Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP23 AS ['Item Vendor SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['Item Vendor SmartList'].IVINFIDX = ['Account Index Master'].ACTINDX40 INVMCIDX Inventory Monetary Correction Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['Item Vendor SmartList'].INVMCIDX AS 'Item Vendor SmartList-Inventory Monetary Correction Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP23 AS ['Item Vendor SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['Item Vendor SmartList'].INVMCIDX = ['Account Index Master'].ACTINDX41 IVRETIDX Inventory Returns Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['Item Vendor SmartList'].IVRETIDX AS 'Item Vendor SmartList-Inventory Returns Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP23 AS ['Item Vendor SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['Item Vendor SmartList'].IVRETIDX = ['Account Index Master'].ACTINDX42 ITMCLSCD Item Class Code String STR10_Class_ID 10 Key to the Item Class Setup (IV40400).
Click to show/hide
SELECT
['Item Vendor SmartList'].ITMCLSCD AS 'Item Vendor SmartList-Item Class Code'
,['Item Class Setup'].ITMCLSCD AS 'Item Class Setup-Item Class Code'
FROM
ASIEXP23 AS ['Item Vendor SmartList']
INNER JOIN
IV40400 AS ['Item Class Setup']
ON
['Item Vendor SmartList'].ITMCLSCD = ['Item Class Setup'].ITMCLSCD43 ITEMCODE Item Code String STR15 15 44 ITEMDESC Item Description String STR100 100 45 ITMGEDSC Item Generic Description String STR10 10 46 ITEMSHWT Item Shipping Weight Long Integer LI6_RBS2_UT 6 47 ITMSHNAM Item Short Name String STR15 15 48 ITMTSHID Item Tax Schedule ID String STR15_LBAU 15 Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hide
SELECT
['Item Vendor SmartList'].ITMTSHID AS 'Item Vendor SmartList-Item Tax Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
ASIEXP23 AS ['Item Vendor SmartList']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['Item Vendor SmartList'].ITMTSHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID49 ITMTRKOP Item Tracking Option Integer DDL_Track 0 50 ITEMTYPE Item Type Integer DDL_Item_Type 0 51 IVCOGSIX IV COGS Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['Item Vendor SmartList'].IVCOGSIX AS 'Item Vendor SmartList-IV COGS Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP23 AS ['Item Vendor SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['Item Vendor SmartList'].IVCOGSIX = ['Account Index Master'].ACTINDX52 IVDMGIDX IV Damaged Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['Item Vendor SmartList'].IVDMGIDX AS 'Item Vendor SmartList-IV Damaged Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP23 AS ['Item Vendor SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['Item Vendor SmartList'].IVDMGIDX = ['Account Index Master'].ACTINDX53 IVINSVIX IV In Service Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['Item Vendor SmartList'].IVINSVIX AS 'Item Vendor SmartList-IV In Service Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP23 AS ['Item Vendor SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['Item Vendor SmartList'].IVINSVIX = ['Account Index Master'].ACTINDX54 IVINUSIX IV In Use Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['Item Vendor SmartList'].IVINUSIX AS 'Item Vendor SmartList-IV In Use Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP23 AS ['Item Vendor SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['Item Vendor SmartList'].IVINUSIX = ['Account Index Master'].ACTINDX55 IVIVINDX IV IV Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['Item Vendor SmartList'].IVIVINDX AS 'Item Vendor SmartList-IV IV Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP23 AS ['Item Vendor SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['Item Vendor SmartList'].IVIVINDX = ['Account Index Master'].ACTINDX56 IVIVOFIX IV IV Offset Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['Item Vendor SmartList'].IVIVOFIX AS 'Item Vendor SmartList-IV IV Offset Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP23 AS ['Item Vendor SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['Item Vendor SmartList'].IVIVOFIX = ['Account Index Master'].ACTINDX57 IVSLDSIX IV Sales Discounts Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['Item Vendor SmartList'].IVSLDSIX AS 'Item Vendor SmartList-IV Sales Discounts Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP23 AS ['Item Vendor SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['Item Vendor SmartList'].IVSLDSIX = ['Account Index Master'].ACTINDX58 IVSLSIDX IV Sales Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['Item Vendor SmartList'].IVSLSIDX AS 'Item Vendor SmartList-IV Sales Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP23 AS ['Item Vendor SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['Item Vendor SmartList'].IVSLSIDX = ['Account Index Master'].ACTINDX59 IVSLRNIX IV Sales Returns Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['Item Vendor SmartList'].IVSLRNIX AS 'Item Vendor SmartList-IV Sales Returns Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP23 AS ['Item Vendor SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['Item Vendor SmartList'].IVSLRNIX = ['Account Index Master'].ACTINDX60 IVVARIDX IV Variances Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['Item Vendor SmartList'].IVVARIDX AS 'Item Vendor SmartList-IV Variances Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP23 AS ['Item Vendor SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['Item Vendor SmartList'].IVVARIDX = ['Account Index Master'].ACTINDX61 KPCALHST Keep Calendar History Boolean CB_Keep_Calendar_History 0 62 KPDSTHST Keep Distribution History Boolean CB_Keep_Dist_History 0 63 KPERHIST Keep Period History Boolean CB_Keep_Period_History 0 64 KPTRXHST Keep Trx History Boolean CB_Keep_Trx_History 0 65 KTACCTSR Kit COGS Account Source Integer GB 0 66 LASTGENSN Last Generated Serial Number String STR20_LBAU 20 67 LOCNCODE Location Code String STR10_Location_Code 10 Key to the Site Setup (IV40700).
Click to show/hide
SELECT
['Item Vendor SmartList'].LOCNCODE AS 'Item Vendor SmartList-Location Code'
,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
ASIEXP23 AS ['Item Vendor SmartList']
INNER JOIN
IV40700 AS ['Site Setup']
ON
['Item Vendor SmartList'].LOCNCODE = ['Site Setup'].LOCNCODE68 LOTTYPE Lot Type String STR10_Lot_Type 10 69 MSTRCDTY Master Record Type Integer INT1 1 70 MODIFDT Modified Date Date DT 8 71 NOTEINDX Note Index Currency DLR14 14 Key to the Record Notes Master (SY03900).
Click to show/hide
SELECT
['Item Vendor SmartList'].NOTEINDX AS 'Item Vendor SmartList-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
ASIEXP23 AS ['Item Vendor SmartList']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['Item Vendor SmartList'].NOTEINDX = ['Record Notes Master'].NOTEINDX72 PriceGroup Price Group String STR10_LBAU 10 73 PRCLEVEL PriceLevel String STR10_LBAU 10 74 PRICMTHD Price Method Integer DDL_Price_Method 0 75 PINFLIDX Purch Inflation Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['Item Vendor SmartList'].PINFLIDX AS 'Item Vendor SmartList-Purch Inflation Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP23 AS ['Item Vendor SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['Item Vendor SmartList'].PINFLIDX = ['Account Index Master'].ACTINDX76 PURMCIDX Purch Monetary Correction Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['Item Vendor SmartList'].PURMCIDX AS 'Item Vendor SmartList-Purch Monetary Correction Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP23 AS ['Item Vendor SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['Item Vendor SmartList'].PURMCIDX = ['Account Index Master'].ACTINDX77 PURPVIDX Purchase Price Variance Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['Item Vendor SmartList'].PURPVIDX AS 'Item Vendor SmartList-Purchase Price Variance Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP23 AS ['Item Vendor SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['Item Vendor SmartList'].PURPVIDX = ['Account Index Master'].ACTINDX78 SELNGUOM Selling U Of M String U_Of_M 8 79 STNDCOST Standard Cost Currency DLR17_RBS0_UTR$ 17 80 TCC Tax Commodity Code String STR30_VAT 30 81 TAXOPTNS Tax Options Integer DDL_Tax_Options 0 82 UOMSCHDL U Of M Schedule String STR10_Schedule 10 Key to the Inventory U of M Schedule Setup (IV40201).
Click to show/hide
SELECT
['Item Vendor SmartList'].UOMSCHDL AS 'Item Vendor SmartList-U Of M Schedule'
,['Inventory U of M Schedule Setup'].UOMSCHDL AS 'Inventory U of M Schedule Setup-U Of M Schedule'
FROM
ASIEXP23 AS ['Item Vendor SmartList']
INNER JOIN
IV40201 AS ['Inventory U of M Schedule Setup']
ON
['Item Vendor SmartList'].UOMSCHDL = ['Inventory U of M Schedule Setup'].UOMSCHDL83 UPPVIDX Unrealized Purchase Price Variance Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['Item Vendor SmartList'].UPPVIDX AS 'Item Vendor SmartList-Unrealized Purchase Price Variance Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP23 AS ['Item Vendor SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['Item Vendor SmartList'].UPPVIDX = ['Account Index Master'].ACTINDX84 VCTNMTHD Valuation Method Integer DDL_Valuation_Method 0 85 WRNTYDYS Warranty Days Integer INT4 4 86 USCATVLS_1 User Category Values[1] String User_Category_Value 10 87 USCATVLS_2 User Category Values[2] String User_Category_Value 10 88 USCATVLS_3 User Category Values[3] String User_Category_Value 10 89 USCATVLS_4 User Category Values[4] String User_Category_Value 10 90 USCATVLS_5 User Category Values[5] String User_Category_Value 10 91 USCATVLS_6 User Category Values[6] String User_Category_Value 10 92 TEN99TYPE 1099 Type Integer 1099_Type 0 93 ACNMVNDR Account Number With Vendor String STR20 20 94 ACPURIDX Accrued Purchases Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['Item Vendor SmartList'].ACPURIDX AS 'Item Vendor SmartList-Accrued Purchases Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP23 AS ['Item Vendor SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['Item Vendor SmartList'].ACPURIDX = ['Account Index Master'].ACTINDX95 ADDRESS1 Address 1 String STR60 60 96 ADDRESS2 Address 2 String STR60 60 97 ADDRESS3 Address 3 String STR60 60 98 CRTCOMDT Certificate Commencing Date Date DT 8 99 CRTEXPDT Certificate Expiration Date Date DT 8 100 CHEKBKID Checkbook ID String STR15_Checkbook_ID 15 Key to the CM Checkbook Master (CM00100).
Click to show/hide
SELECT
['Item Vendor SmartList'].CHEKBKID AS 'Item Vendor SmartList-Checkbook ID'
,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
ASIEXP23 AS ['Item Vendor SmartList']
INNER JOIN
CM00100 AS ['CM Checkbook Master']
ON
['Item Vendor SmartList'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID101 CITY City String STR35 35 102 COMMENT1 Comment1 String STR30 30 103 COMMENT2 Comment2 String STR30 30 104 COUNTRY Country String STR60 60 105 CREDTLMT Credit Limit Integer GB 0 106 CRLMTDLR Credit Limit Dollar Currency DLR17_$U2 17 107 CURNCYID Currency ID String STR15_Currency_ID 15 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['Item Vendor SmartList'].CURNCYID AS 'Item Vendor SmartList-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
ASIEXP23 AS ['Item Vendor SmartList']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['Item Vendor SmartList'].CURNCYID = ['Currency Setup'].CURNCYID108 DXVARNUM Deduction Exemption/Variation Number String STR25 25 109 DISGRPER Discount Grace Period Integer INT2_U0 2 110 DOCFMTID Document Format ID String STR15_LBU 15 111 DUEGRPER Due Date Grace Period Integer INT2_U0 2 112 XPDTOBLG Expiration Date Obligation Boolean CB_Expiration_Date_Obligation 0 113 FAXNUMBR Fax Number String STR14_FAX 14 114 GOVCRPID Governmental Corporate ID String STR30_Gov_Corp_ID 30 115 GOVINDID Governmental Individual ID String STR30_Gov_Indiv_ID 30 116 HOLD Hold Boolean CB_Hold 0 117 KGLDSTHS Keep GL Dist History Boolean CB_Keep_GL_Dist_History 0 118 MXIAFVND Maximum Invoice Amount For Vendors Integer GB 0 119 MAXINDLR Maximum Invoice Dollar Currency DLR17_$U2 17 120 MXWOFAMT Maximum Write Off Amount Currency DLR17_$U2 17 121 MINORDER Minimum Order Currency DLR17_$U2 17 122 MINPYDLR Minimum Payment Dollar Currency DLR17_RBS0_UTR$ 17 123 MINPYPCT Minimum Payment Percent Integer INT5_%2 5 124 MINPYTYP Minimum Payment Type Integer GB_Amt_Type 0 125 PARVENID Parent Vendor ID String STR_15_Vendor_ID 15 126 PYMNTPRI Payment Priority String STR3 3 127 PYMTRMID Payment Terms ID String STR20_Payment_Terms_ID 20 Key to the Payment Terms Master (SY03300).
Click to show/hide
SELECT
['Item Vendor SmartList'].PYMTRMID AS 'Item Vendor SmartList-Payment Terms ID'
,['Payment Terms Master'].PYMTRMID AS 'Payment Terms Master-Payment Terms ID'
FROM
ASIEXP23 AS ['Item Vendor SmartList']
INNER JOIN
SY03300 AS ['Payment Terms Master']
ON
['Item Vendor SmartList'].PYMTRMID = ['Payment Terms Master'].PYMTRMID128 PHONE3 Phone 3 String Phone_Number3 14 129 PHNUMBR1 Phone Number 1 String Phone_Number 14 130 PHNUMBR2 Phone Number 2 String Phone_Number 14 131 PMAPINDX PM AP Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['Item Vendor SmartList'].PMAPINDX AS 'Item Vendor SmartList-PM AP Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP23 AS ['Item Vendor SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['Item Vendor SmartList'].PMAPINDX = ['Account Index Master'].ACTINDX132 PMCSHIDX PM Cash Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['Item Vendor SmartList'].PMCSHIDX AS 'Item Vendor SmartList-PM Cash Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP23 AS ['Item Vendor SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['Item Vendor SmartList'].PMCSHIDX = ['Account Index Master'].ACTINDX133 PMDAVIDX PM Discount Available Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['Item Vendor SmartList'].PMDAVIDX AS 'Item Vendor SmartList-PM Discount Available Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP23 AS ['Item Vendor SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['Item Vendor SmartList'].PMDAVIDX = ['Account Index Master'].ACTINDX134 PMDTKIDX PM Discount Taken Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['Item Vendor SmartList'].PMDTKIDX AS 'Item Vendor SmartList-PM Discount Taken Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP23 AS ['Item Vendor SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['Item Vendor SmartList'].PMDTKIDX = ['Account Index Master'].ACTINDX135 PMFINIDX PM Finance Charge Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['Item Vendor SmartList'].PMFINIDX AS 'Item Vendor SmartList-PM Finance Charge Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP23 AS ['Item Vendor SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['Item Vendor SmartList'].PMFINIDX = ['Account Index Master'].ACTINDX136 PMFRTIDX PM Freight Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['Item Vendor SmartList'].PMFRTIDX AS 'Item Vendor SmartList-PM Freight Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP23 AS ['Item Vendor SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['Item Vendor SmartList'].PMFRTIDX = ['Account Index Master'].ACTINDX137 PMMSCHIX PM Misc Charges Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['Item Vendor SmartList'].PMMSCHIX AS 'Item Vendor SmartList-PM Misc Charges Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP23 AS ['Item Vendor SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['Item Vendor SmartList'].PMMSCHIX = ['Account Index Master'].ACTINDX138 PMPRCHIX PM Purchases Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['Item Vendor SmartList'].PMPRCHIX AS 'Item Vendor SmartList-PM Purchases Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP23 AS ['Item Vendor SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['Item Vendor SmartList'].PMPRCHIX = ['Account Index Master'].ACTINDX139 PMRTNGIX PM Retainage Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['Item Vendor SmartList'].PMRTNGIX AS 'Item Vendor SmartList-PM Retainage Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP23 AS ['Item Vendor SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['Item Vendor SmartList'].PMRTNGIX = ['Account Index Master'].ACTINDX140 PMTAXIDX PM Tax Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['Item Vendor SmartList'].PMTAXIDX AS 'Item Vendor SmartList-PM Tax Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP23 AS ['Item Vendor SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['Item Vendor SmartList'].PMTAXIDX = ['Account Index Master'].ACTINDX141 PMTDSCIX PM Trade Discount Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['Item Vendor SmartList'].PMTDSCIX AS 'Item Vendor SmartList-PM Trade Discount Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP23 AS ['Item Vendor SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['Item Vendor SmartList'].PMTDSCIX = ['Account Index Master'].ACTINDX142 PMWRTIDX PM Write Offs Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['Item Vendor SmartList'].PMWRTIDX AS 'Item Vendor SmartList-PM Write Offs Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP23 AS ['Item Vendor SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['Item Vendor SmartList'].PMWRTIDX = ['Account Index Master'].ACTINDX143 Post_Results_To Post Results To Integer GB 0 144 PTCSHACF Post To Cash Account From Integer GB 0 145 PPSTAXRT PPS Tax Rate Integer INT5_%2 5 146 PRSPAYEE Prescribed Payee Boolean CB_Prescribed_Payee 0 147 RATETPID Rate Type ID String STR15_Rate_Type_ID 15 Key to the Multicurrency Rate Type Setup (MC40100).
Click to show/hide
SELECT
['Item Vendor SmartList'].RATETPID AS 'Item Vendor SmartList-Rate Type ID'
,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
ASIEXP23 AS ['Item Vendor SmartList']
INNER JOIN
MC40100 AS ['Multicurrency Rate Type Setup']
ON
['Item Vendor SmartList'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID148 RTOBUTKN Reporting Obligation Undertaken Boolean CB_Reporting_Obligation 0 149 Revalue_Vendor Revalue Vendor Boolean CB Revalue Vendor 0 150 SHIPMTHD Shipping Method String STR15_Shipping_Method 15 Key to the Shipping Methods Master (SY03000).
Click to show/hide
SELECT
['Item Vendor SmartList'].SHIPMTHD AS 'Item Vendor SmartList-Shipping Method'
,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method'
FROM
ASIEXP23 AS ['Item Vendor SmartList']
INNER JOIN
SY03000 AS ['Shipping Methods Master']
ON
['Item Vendor SmartList'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD151 STATE State String STR30_State 29 152 SBPPSDED Subject To PPS Deductions Boolean CB_Subject_To_PPS_Deductions 0 153 TXIDNMBR Tax ID Number String Tax_ID_Number 11 154 TaxInvRecvd Tax Invoice Received Boolean CB_Tax_Invoice_Received 0 155 TXRGNNUM Tax Registration Number String STR25 25 156 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
['Item Vendor SmartList'].TAXSCHID AS 'Item Vendor SmartList-Tax Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
ASIEXP23 AS ['Item Vendor SmartList']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['Item Vendor SmartList'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID157 TRDDISCT Trade Discount Integer INT4_%2 4 158 UPSZONE UPS Zone String STR3 3 159 USERDEF1 User Defined 1 String STR20 20 160 USERDEF2 User Defined 2 String STR20 20 161 VADDCDPR Vendor Address Code - Primary String STR15_Address_Code 15 Partial key to the PM Address MSTR (PM00300).
Click to show/hide
SELECT
['Item Vendor SmartList'].VADDCDPR AS 'Item Vendor SmartList-Vendor Address Code - Primary'
,['PM Address MSTR'].ADRSCODE AS 'PM Address MSTR-Address Code'
FROM
ASIEXP23 AS ['Item Vendor SmartList']
INNER JOIN
PM00300 AS ['PM Address MSTR']
ON
['Item Vendor SmartList'].VADDCDPR = ['PM Address MSTR'].ADRSCODE
AND
['Item Vendor SmartList'].VENDORID = ['PM Address MSTR'].VENDORID162 VADCDPAD Vendor Address Code - Purchase Address String STR15_Address_Code 15 Partial key to the PM Address MSTR (PM00300).
Click to show/hide
SELECT
['Item Vendor SmartList'].VADCDPAD AS 'Item Vendor SmartList-Vendor Address Code - Purchase Address'
,['PM Address MSTR'].ADRSCODE AS 'PM Address MSTR-Address Code'
FROM
ASIEXP23 AS ['Item Vendor SmartList']
INNER JOIN
PM00300 AS ['PM Address MSTR']
ON
['Item Vendor SmartList'].VADCDPAD = ['PM Address MSTR'].ADRSCODE
AND
['Item Vendor SmartList'].VENDORID = ['PM Address MSTR'].VENDORID163 VADCDTRO Vendor Address Code - Remit To String STR15_Address_Code 15 Partial key to the PM Address MSTR (PM00300).
Click to show/hide
SELECT
['Item Vendor SmartList'].VADCDTRO AS 'Item Vendor SmartList-Vendor Address Code - Remit To'
,['PM Address MSTR'].ADRSCODE AS 'PM Address MSTR-Address Code'
FROM
ASIEXP23 AS ['Item Vendor SmartList']
INNER JOIN
PM00300 AS ['PM Address MSTR']
ON
['Item Vendor SmartList'].VADCDTRO = ['PM Address MSTR'].ADRSCODE
AND
['Item Vendor SmartList'].VENDORID = ['PM Address MSTR'].VENDORID164 VADCDSFR Vendor Address Code - Ship From String STR15_Address_Code 15 Partial key to the PM Address MSTR (PM00300).
Click to show/hide
SELECT
['Item Vendor SmartList'].VADCDSFR AS 'Item Vendor SmartList-Vendor Address Code - Ship From'
,['PM Address MSTR'].ADRSCODE AS 'PM Address MSTR-Address Code'
FROM
ASIEXP23 AS ['Item Vendor SmartList']
INNER JOIN
PM00300 AS ['PM Address MSTR']
ON
['Item Vendor SmartList'].VADCDSFR = ['PM Address MSTR'].ADRSCODE
AND
['Item Vendor SmartList'].VENDORID = ['PM Address MSTR'].VENDORID165 VNDCHKNM Vendor Check Name String STR64_Vendor_Name 64 166 VNDCLSID Vendor Class ID String STR10_Class_ID 10 Key to the PM Class Master File (PM00100).
Click to show/hide
SELECT
['Item Vendor SmartList'].VNDCLSID AS 'Item Vendor SmartList-Vendor Class ID'
,['PM Class Master File'].VNDCLSID AS 'PM Class Master File-Vendor Class ID'
FROM
ASIEXP23 AS ['Item Vendor SmartList']
INNER JOIN
PM00100 AS ['PM Class Master File']
ON
['Item Vendor SmartList'].VNDCLSID = ['PM Class Master File'].VNDCLSID167 VNDCNTCT Vendor Contact String STR60 60 168 VENDNAME Vendor Name String STR64_Vendor_Name 64 169 VENDSHNM Vendor Short Name String STR15 15 170 VENDSTTS Vendor Status Integer DDL_Vendor_Status 0 171 WRITEOFF Writeoff Integer GB 0 172 ZIPCODE Zip Code String STR10 10 173 CREATDDT1 ASI_Created_Date Date DT 8 174 KPCALHST1 ASI_Keep_Calendar_History Boolean CB_Keep_Calendar_History 0 175 KPERHIST1 ASI_Keep_Period_History Boolean CB_Keep_Period_History 0 176 KPTRXHST1 ASI_Keep_Trx_History Boolean CB_Keep_Trx_History 0 177 MODIFDT1 ASI_Modified_Date Date DT 8 178 NOTEINDX1 ASI_Note_Index Currency DLR14 14 179 PRCHSUOM1 ASI_Purchasing_U_Of_M String U_Of_M 8 180 FREEONBOARD1 ASI_Free_On_Board Integer DDL_Free_On_Board 0 181 PURPVIDX1 ASI_Purchase_Price_Variance_Index Long Integer LI_14 14