| Seq 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).
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'].ITEMNMBR |
| 4 | VENDORID | Vendor ID | String | STR_15_Vendor_ID | 15 |
| Key to the PM Vendor Master File (PM00200).
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'].VENDORID |
| 5 | 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).
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'].CURRNIDX |
| 26 | 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).
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'].ACTINDX |
| 32 | CGSINFLX | COGS Inflation Index | Long Integer | LI_14 | 14 |
| Key to the Account Index Master (GL00105).
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'].ACTINDX |
| 33 | CGSMCIDX | COGS Monetary Correction Index | Long Integer | LI_14 | 14 |
| Key to the Account Index Master (GL00105).
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'].ACTINDX |
| 34 | 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).
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'].ACTINDX |
| 39 | IVINFIDX | Inventory Inflation Index | Long Integer | LI_14 | 14 |
| Key to the Account Index Master (GL00105).
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'].ACTINDX |
| 40 | INVMCIDX | Inventory Monetary Correction Index | Long Integer | LI_14 | 14 |
| Key to the Account Index Master (GL00105).
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'].ACTINDX |
| 41 | IVRETIDX | Inventory Returns Index | Long Integer | LI_14 | 14 |
| Key to the Account Index Master (GL00105).
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'].ACTINDX |
| 42 | ITMCLSCD | Item Class Code | String | STR10_Class_ID | 10 |
| Key to the Item Class Setup (IV40400).
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'].ITMCLSCD |
| 43 | 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).
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'].TAXSCHID |
| 49 | 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).
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'].ACTINDX |
| 52 | IVDMGIDX | IV Damaged Index | Long Integer | LI_14 | 14 |
| Key to the Account Index Master (GL00105).
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'].ACTINDX |
| 53 | IVINSVIX | IV In Service Index | Long Integer | LI_14 | 14 |
| Key to the Account Index Master (GL00105).
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'].ACTINDX |
| 54 | IVINUSIX | IV In Use Index | Long Integer | LI_14 | 14 |
| Key to the Account Index Master (GL00105).
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'].ACTINDX |
| 55 | IVIVINDX | IV IV Index | Long Integer | LI_14 | 14 |
| Key to the Account Index Master (GL00105).
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'].ACTINDX |
| 56 | IVIVOFIX | IV IV Offset Index | Long Integer | LI_14 | 14 |
| Key to the Account Index Master (GL00105).
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'].ACTINDX |
| 57 | IVSLDSIX | IV Sales Discounts Index | Long Integer | LI_14 | 14 |
| Key to the Account Index Master (GL00105).
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'].ACTINDX |
| 58 | IVSLSIDX | IV Sales Index | Long Integer | LI_14 | 14 |
| Key to the Account Index Master (GL00105).
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'].ACTINDX |
| 59 | IVSLRNIX | IV Sales Returns Index | Long Integer | LI_14 | 14 |
| Key to the Account Index Master (GL00105).
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'].ACTINDX |
| 60 | IVVARIDX | IV Variances Index | Long Integer | LI_14 | 14 |
| Key to the Account Index Master (GL00105).
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'].ACTINDX |
| 61 | 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).
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'].LOCNCODE |
| 68 | 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).
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'].NOTEINDX |
| 72 | 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).
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'].ACTINDX |
| 76 | PURMCIDX | Purch Monetary Correction Index | Long Integer | LI_14 | 14 |
| Key to the Account Index Master (GL00105).
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'].ACTINDX |
| 77 | PURPVIDX | Purchase Price Variance Index | Long Integer | LI_14 | 14 |
| Key to the Account Index Master (GL00105).
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'].ACTINDX |
| 78 | 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).
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'].UOMSCHDL |
| 83 | UPPVIDX | Unrealized Purchase Price Variance Index | Long Integer | LI_14 | 14 |
| Key to the Account Index Master (GL00105).
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'].ACTINDX |
| 84 | 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).
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'].ACTINDX |
| 95 | 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).
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'].CHEKBKID |
| 101 | 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).
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'].CURNCYID |
| 108 | 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).
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'].PYMTRMID |
| 128 | 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).
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'].ACTINDX |
| 132 | PMCSHIDX | PM Cash Index | Long Integer | LI_14 | 14 |
| Key to the Account Index Master (GL00105).
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'].ACTINDX |
| 133 | PMDAVIDX | PM Discount Available Index | Long Integer | LI_14 | 14 |
| Key to the Account Index Master (GL00105).
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'].ACTINDX |
| 134 | PMDTKIDX | PM Discount Taken Index | Long Integer | LI_14 | 14 |
| Key to the Account Index Master (GL00105).
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'].ACTINDX |
| 135 | PMFINIDX | PM Finance Charge Index | Long Integer | LI_14 | 14 |
| Key to the Account Index Master (GL00105).
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'].ACTINDX |
| 136 | PMFRTIDX | PM Freight Index | Long Integer | LI_14 | 14 |
| Key to the Account Index Master (GL00105).
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'].ACTINDX |
| 137 | PMMSCHIX | PM Misc Charges Index | Long Integer | LI_14 | 14 |
| Key to the Account Index Master (GL00105).
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'].ACTINDX |
| 138 | PMPRCHIX | PM Purchases Index | Long Integer | LI_14 | 14 |
| Key to the Account Index Master (GL00105).
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'].ACTINDX |
| 139 | PMRTNGIX | PM Retainage Index | Long Integer | LI_14 | 14 |
| Key to the Account Index Master (GL00105).
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'].ACTINDX |
| 140 | PMTAXIDX | PM Tax Index | Long Integer | LI_14 | 14 |
| Key to the Account Index Master (GL00105).
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'].ACTINDX |
| 141 | PMTDSCIX | PM Trade Discount Index | Long Integer | LI_14 | 14 |
| Key to the Account Index Master (GL00105).
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'].ACTINDX |
| 142 | PMWRTIDX | PM Write Offs Index | Long Integer | LI_14 | 14 |
| Key to the Account Index Master (GL00105).
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'].ACTINDX |
| 143 | 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).
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'].RATETPID |
| 148 | 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).
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'].SHIPMTHD |
| 151 | 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).
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'].TAXSCHID |
| 157 | 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).
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'].VENDORID |
| 162 | VADCDPAD | Vendor Address Code - Purchase Address | String | STR15_Address_Code | 15 |
| Partial key to the PM Address MSTR (PM00300).
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'].VENDORID |
| 163 | VADCDTRO | Vendor Address Code - Remit To | String | STR15_Address_Code | 15 |
| Partial key to the PM Address MSTR (PM00300).
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'].VENDORID |
| 164 | VADCDSFR | Vendor Address Code - Ship From | String | STR15_Address_Code | 15 |
| Partial key to the PM Address MSTR (PM00300).
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'].VENDORID |
| 165 | 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).
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'].VNDCLSID |
| 167 | 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 |
