Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/ASIEXP11
Product: SmartList (1493)
Series: Pathname
Display Name: SmartList Item Quantity Master Group Display Name: SmartList Master
Physical Name: ASIEXP11
Technical Name: ASI_IV_Item_MSTR_QTYS_Explorer
Group Technical Name: ASI_Explorer_Logical_MSTR
Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
---|---|---|---|---|---|---|
1 | ASI_Order_By ![]() | ASI_Order_By | LI_14 | Long Integer | 14 | |
2 | ITEMNMBR ![]() | Item Number | STR30_Item_Number | String | 30 | |
Key to the Item Master (IV00101).
Click to show/hideSELECT
['SmartList Item Quantity Master'].ITEMNMBR AS 'SmartList Item Quantity Master-Item Number'
,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
ASIEXP11 AS ['SmartList Item Quantity Master']
INNER JOIN
IV00101 AS ['Item Master']
ON
['SmartList Item Quantity Master'].ITEMNMBR = ['Item Master'].ITEMNMBR | ||||||
3 | LOCNCODE ![]() | Location Code | STR10_Location_Code | String | 10 | |
Key to the Site Setup (IV40700).
Click to show/hideSELECT
['SmartList Item Quantity Master'].LOCNCODE AS 'SmartList Item Quantity Master-Location Code'
,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
ASIEXP11 AS ['SmartList Item Quantity Master']
INNER JOIN
IV40700 AS ['Site Setup']
ON
['SmartList Item Quantity Master'].LOCNCODE = ['Site Setup'].LOCNCODE | ||||||
4 | BINNMBR ![]() | Bin Number | STR20 | String | 20 | |
5 | RCRDTYPE ![]() | Record Type | INT1 | Integer | 1 | |
6 | PRIMVNDR ![]() | Primary Vendor | STR_15_Vendor_ID | String | 15 | |
7 | ITMFRFLG ![]() | Item Freeze Flag | YN | Boolean | 0 | |
8 | BGNGQTY ![]() | Beginning QTY | DLR17_QTY_RBS0_STR | Currency | 17 | |
9 | LSORDQTY ![]() | Last ORD QTY | DLR17_QTY_RBS0_UTR | Currency | 17 | |
10 | LRCPTQTY ![]() | Last RCPT QTY | DLR17_QTY_RBS0_UTR | Currency | 17 | |
11 | LSTORDDT ![]() | Last ORD Date | DATE | Date | 6 | |
12 | LSORDVND ![]() | Last ORD Vendor | STR_15_Vendor_ID | String | 15 | |
13 | LSRCPTDT ![]() | Last RCPT Date | DATE | Date | 6 | |
14 | QTYRQSTN ![]() | QTY Requisitioned | DLR17_QTY_RBS0_UTR | Currency | 17 | |
15 | QTYONORD ![]() | QTY On Order | DLR17_QTY_RBS0_UTR | Currency | 17 | |
16 | QTYBKORD ![]() | QTY Back Ordered | DLR17_QTY_RBS0_UTR | Currency | 17 | |
17 | QTY_Drop_Shipped ![]() | QTY Drop Shipped | DLR17_QTY_RBS0_UTR | Currency | 17 | |
18 | ORDRPNTQTY ![]() | Order Point Qty | DLR17_QTY_RBS0_UTR | Currency | 17 | |
19 | REORDERVARIANCE ![]() | Reorder Variance | DLR17_QTY_RBS0_UTR | Currency | 17 | |
20 | ORDRUPTOLVL ![]() | Order Up To Level | DLR17_QTY_RBS0_UTR | Currency | 17 | |
21 | QTYINUSE ![]() | QTY In Use | DLR17_QTY_RBS0_UTR | Currency | 17 | |
22 | QTYINSVC ![]() | QTY In Service | DLR17_QTY_RBS0_UTR | Currency | 17 | |
23 | QTYRTRND ![]() | QTY Returned | DLR17_QTY_RBS0_UTR | Currency | 17 | |
24 | QTYDMGED ![]() | QTY Damaged | DLR17_QTY_RBS0_UTR | Currency | 17 | |
25 | QTYONHND ![]() | QTY On Hand | DLR17_QTY_RBS0_STR | Currency | 17 | |
26 | ATYALLOC ![]() | QTY Allocated | DLR17_QTY_RBS0_UTR | Currency | 17 | |
27 | QTYCOMTD ![]() | QTY Committed | DLR17_QTY_RBS0_UTR | Currency | 17 | |
28 | QTYSOLD ![]() | QTY Sold | DLR17_QTY_RBS0_UTR | Currency | 17 | |
29 | DECPLQTY ![]() | Decimal Places QTYS | DDL_Decimal_Places_QTYS | Integer | 0 | |
30 | DECPLCUR ![]() | Decimal Places Currency | DDL_Decimal_Places_Dollars | Integer | 0 | |
31 | QTYAVAIL ![]() | QTY Available | DLR17_QTY_RBS0_UTR | Currency | 17 | |
32 | ITEMDESC ![]() | Item Description | STR100 | String | 100 | |
33 | ITMGEDSC ![]() | Item Generic Description | STR10 | String | 10 | |
34 | ITMSHNAM ![]() | Item Short Name | STR15 | String | 15 | |
35 | VENDNAME ![]() | Vendor Name | STR64_Vendor_Name | String | 64 | |
36 | VNDITNUM ![]() | Vendor Item Number | Item_Number | String | 30 | |
37 | VNDITDSC ![]() | Vendor Item Description | STR100 | String | 100 | |
38 | CURRCOST ![]() | Current Cost | DLR17_RBS0_UTR$ | Currency | 17 | |
39 | STNDCOST ![]() | Standard Cost | DLR17_RBS0_UTR$ | Currency | 17 | |
40 | BASEUOFM ![]() | Base U Of M | U_Of_M | String | 8 | |
41 | USCATVLS_1 ![]() | User Category Values[1] | User_Category_Value | String | 10 | |
42 | USCATVLS_2 ![]() | User Category Values[2] | User_Category_Value | String | 10 | |
43 | USCATVLS_3 ![]() | User Category Values[3] | User_Category_Value | String | 10 | |
44 | USCATVLS_4 ![]() | User Category Values[4] | User_Category_Value | String | 10 | |
45 | USCATVLS_5 ![]() | User Category Values[5] | User_Category_Value | String | 10 | |
46 | USCATVLS_6 ![]() | User Category Values[6] | User_Category_Value | String | 10 | |
47 | ALTITEM1 ![]() | Alternate Item 1 | STR30_Item_Number | String | 30 | |
48 | ALTITEM2 ![]() | Alternate Item 2 | STR30_Item_Number | String | 30 | |
49 | VCTNMTHD ![]() | Valuation Method | DDL_Valuation_Method | Integer | 0 | |
50 | ITMTSHID ![]() | Item Tax Schedule ID | STR15_LBAU | String | 15 | |
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hideSELECT
['SmartList Item Quantity Master'].ITMTSHID AS 'SmartList Item Quantity Master-Item Tax Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
ASIEXP11 AS ['SmartList Item Quantity Master']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['SmartList Item Quantity Master'].ITMTSHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID | ||||||
51 | ITEMTYPE ![]() | Item Type | DDL_Item_Type | Integer | 0 | |
52 | ITMTRKOP ![]() | Item Tracking Option | DDL_Track | Integer | 0 | |
53 | KPERHIST ![]() | Keep Period History | CB_Keep_Period_History | Boolean | 0 | |
54 | KPTRXHST ![]() | Keep Trx History | CB_Keep_Trx_History | Boolean | 0 | |
55 | KPCALHST ![]() | Keep Calendar History | CB_Keep_Calendar_History | Boolean | 0 | |
56 | KPDSTHST ![]() | Keep Distribution History | CB_Keep_Dist_History | Boolean | 0 | |
57 | ITEMSHWT ![]() | Item Shipping Weight | LI6_RBS2_UT | Long Integer | 6 | |
58 | TAXOPTNS ![]() | Tax Options | DDL_Tax_Options | Integer | 0 | |
59 | IVIVINDX ![]() | IV IV Index | LI_14 | Long Integer | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['SmartList Item Quantity Master'].IVIVINDX AS 'SmartList Item Quantity Master-IV IV Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP11 AS ['SmartList Item Quantity Master']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Item Quantity Master'].IVIVINDX = ['Account Index Master'].ACTINDX | ||||||
60 | IVIVOFIX ![]() | IV IV Offset Index | LI_14 | Long Integer | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['SmartList Item Quantity Master'].IVIVOFIX AS 'SmartList Item Quantity Master-IV IV Offset Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP11 AS ['SmartList Item Quantity Master']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Item Quantity Master'].IVIVOFIX = ['Account Index Master'].ACTINDX | ||||||
61 | IVCOGSIX ![]() | IV COGS Index | LI_14 | Long Integer | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['SmartList Item Quantity Master'].IVCOGSIX AS 'SmartList Item Quantity Master-IV COGS Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP11 AS ['SmartList Item Quantity Master']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Item Quantity Master'].IVCOGSIX = ['Account Index Master'].ACTINDX | ||||||
62 | IVSLSIDX ![]() | IV Sales Index | LI_14 | Long Integer | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['SmartList Item Quantity Master'].IVSLSIDX AS 'SmartList Item Quantity Master-IV Sales Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP11 AS ['SmartList Item Quantity Master']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Item Quantity Master'].IVSLSIDX = ['Account Index Master'].ACTINDX | ||||||
63 | IVSLDSIX ![]() | IV Sales Discounts Index | LI_14 | Long Integer | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['SmartList Item Quantity Master'].IVSLDSIX AS 'SmartList Item Quantity Master-IV Sales Discounts Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP11 AS ['SmartList Item Quantity Master']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Item Quantity Master'].IVSLDSIX = ['Account Index Master'].ACTINDX | ||||||
64 | IVSLRNIX ![]() | IV Sales Returns Index | LI_14 | Long Integer | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['SmartList Item Quantity Master'].IVSLRNIX AS 'SmartList Item Quantity Master-IV Sales Returns Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP11 AS ['SmartList Item Quantity Master']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Item Quantity Master'].IVSLRNIX = ['Account Index Master'].ACTINDX | ||||||
65 | IVINUSIX ![]() | IV In Use Index | LI_14 | Long Integer | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['SmartList Item Quantity Master'].IVINUSIX AS 'SmartList Item Quantity Master-IV In Use Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP11 AS ['SmartList Item Quantity Master']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Item Quantity Master'].IVINUSIX = ['Account Index Master'].ACTINDX | ||||||
66 | IVINSVIX ![]() | IV In Service Index | LI_14 | Long Integer | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['SmartList Item Quantity Master'].IVINSVIX AS 'SmartList Item Quantity Master-IV In Service Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP11 AS ['SmartList Item Quantity Master']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Item Quantity Master'].IVINSVIX = ['Account Index Master'].ACTINDX | ||||||
67 | IVDMGIDX ![]() | IV Damaged Index | LI_14 | Long Integer | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['SmartList Item Quantity Master'].IVDMGIDX AS 'SmartList Item Quantity Master-IV Damaged Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP11 AS ['SmartList Item Quantity Master']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Item Quantity Master'].IVDMGIDX = ['Account Index Master'].ACTINDX | ||||||
68 | IVVARIDX ![]() | IV Variances Index | LI_14 | Long Integer | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['SmartList Item Quantity Master'].IVVARIDX AS 'SmartList Item Quantity Master-IV Variances Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP11 AS ['SmartList Item Quantity Master']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Item Quantity Master'].IVVARIDX = ['Account Index Master'].ACTINDX | ||||||
69 | DPSHPIDX ![]() | Drop Ship Index | LI_14 | Long Integer | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['SmartList Item Quantity Master'].DPSHPIDX AS 'SmartList Item Quantity Master-Drop Ship Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP11 AS ['SmartList Item Quantity Master']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Item Quantity Master'].DPSHPIDX = ['Account Index Master'].ACTINDX | ||||||
70 | PURPVIDX ![]() | Purchase Price Variance Index | LI_14 | Long Integer | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['SmartList Item Quantity Master'].PURPVIDX AS 'SmartList Item Quantity Master-Purchase Price Variance Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP11 AS ['SmartList Item Quantity Master']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Item Quantity Master'].PURPVIDX = ['Account Index Master'].ACTINDX | ||||||
71 | IVRETIDX ![]() | Inventory Returns Index | LI_14 | Long Integer | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['SmartList Item Quantity Master'].IVRETIDX AS 'SmartList Item Quantity Master-Inventory Returns Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP11 AS ['SmartList Item Quantity Master']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Item Quantity Master'].IVRETIDX = ['Account Index Master'].ACTINDX | ||||||
72 | ASMVRIDX ![]() | Assembly Variance Index | LI_14 | Long Integer | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['SmartList Item Quantity Master'].ASMVRIDX AS 'SmartList Item Quantity Master-Assembly Variance Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP11 AS ['SmartList Item Quantity Master']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Item Quantity Master'].ASMVRIDX = ['Account Index Master'].ACTINDX | ||||||
73 | ITMCLSCD ![]() | Item Class Code | STR10_Class_ID | String | 10 | |
Key to the Item Class Setup (IV40400).
Click to show/hideSELECT
['SmartList Item Quantity Master'].ITMCLSCD AS 'SmartList Item Quantity Master-Item Class Code'
,['Item Class Setup'].ITMCLSCD AS 'Item Class Setup-Item Class Code'
FROM
ASIEXP11 AS ['SmartList Item Quantity Master']
INNER JOIN
IV40400 AS ['Item Class Setup']
ON
['SmartList Item Quantity Master'].ITMCLSCD = ['Item Class Setup'].ITMCLSCD | ||||||
74 | LOTTYPE ![]() | Lot Type | STR10_Lot_Type | String | 10 | |
75 | ALWBKORD ![]() | Allow Back Orders | CB_Allow_Back_Orders | Boolean | 0 | |
76 | UOMSCHDL ![]() | U Of M Schedule | STR10_Schedule | String | 10 | |
Key to the Inventory U of M Schedule Setup (IV40201).
Click to show/hideSELECT
['SmartList Item Quantity Master'].UOMSCHDL AS 'SmartList Item Quantity Master-U Of M Schedule'
,['Inventory U of M Schedule Setup'].UOMSCHDL AS 'Inventory U of M Schedule Setup-U Of M Schedule'
FROM
ASIEXP11 AS ['SmartList Item Quantity Master']
INNER JOIN
IV40201 AS ['Inventory U of M Schedule Setup']
ON
['SmartList Item Quantity Master'].UOMSCHDL = ['Inventory U of M Schedule Setup'].UOMSCHDL | ||||||
77 | MSTRCDTY ![]() | Master Record Type | INT1 | Integer | 1 | |
78 | WRNTYDYS ![]() | Warranty Days | INT4 | Integer | 4 | |
79 | PRCLEVEL ![]() | PriceLevel | STR10_LBAU | String | 10 | |
80 | ASI_Favorite_Sequence ![]() | ASI_Favorite_Sequence | ASI_LI_10_RU | Long Integer | 10 | |
81 | ABCCODE ![]() | ABC Code | DDL_ABC_Code | Integer | 0 | |
82 | CGSINFLX ![]() | COGS Inflation Index | LI_14 | Long Integer | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['SmartList Item Quantity Master'].CGSINFLX AS 'SmartList Item Quantity Master-COGS Inflation Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP11 AS ['SmartList Item Quantity Master']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Item Quantity Master'].CGSINFLX = ['Account Index Master'].ACTINDX | ||||||
83 | CGSMCIDX ![]() | COGS Monetary Correction Index | LI_14 | Long Integer | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['SmartList Item Quantity Master'].CGSMCIDX AS 'SmartList Item Quantity Master-COGS Monetary Correction Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP11 AS ['SmartList Item Quantity Master']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Item Quantity Master'].CGSMCIDX = ['Account Index Master'].ACTINDX | ||||||
84 | IVINFIDX ![]() | Inventory Inflation Index | LI_14 | Long Integer | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['SmartList Item Quantity Master'].IVINFIDX AS 'SmartList Item Quantity Master-Inventory Inflation Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP11 AS ['SmartList Item Quantity Master']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Item Quantity Master'].IVINFIDX = ['Account Index Master'].ACTINDX | ||||||
85 | INVMCIDX ![]() | Inventory Monetary Correction Index | LI_14 | Long Integer | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['SmartList Item Quantity Master'].INVMCIDX AS 'SmartList Item Quantity Master-Inventory Monetary Correction Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP11 AS ['SmartList Item Quantity Master']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Item Quantity Master'].INVMCIDX = ['Account Index Master'].ACTINDX | ||||||
86 | ITEMCODE ![]() | Item Code | STR15 | String | 15 | |
87 | KTACCTSR ![]() | Kit COGS Account Source | GB | Integer | 0 | |
88 | LASTGENSN ![]() | Last Generated Serial Number | STR20_LBAU | String | 20 | |
89 | PriceGroup ![]() | Price Group | STR10_LBAU | String | 10 | |
90 | PRICMTHD ![]() | Price Method | DDL_Price_Method | Integer | 0 | |
91 | PINFLIDX ![]() | Purch Inflation Index | LI_14 | Long Integer | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['SmartList Item Quantity Master'].PINFLIDX AS 'SmartList Item Quantity Master-Purch Inflation Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP11 AS ['SmartList Item Quantity Master']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Item Quantity Master'].PINFLIDX = ['Account Index Master'].ACTINDX | ||||||
92 | PURMCIDX ![]() | Purch Monetary Correction Index | LI_14 | Long Integer | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['SmartList Item Quantity Master'].PURMCIDX AS 'SmartList Item Quantity Master-Purch Monetary Correction Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP11 AS ['SmartList Item Quantity Master']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Item Quantity Master'].PURMCIDX = ['Account Index Master'].ACTINDX | ||||||
93 | PRCHSUOM ![]() | Purchasing U Of M | U_Of_M | String | 8 | |
94 | SELNGUOM ![]() | Selling U Of M | U_Of_M | String | 8 | |
95 | TCC ![]() | Tax Commodity Code | STR30_VAT | String | 30 | |
96 | UPPVIDX ![]() | Unrealized Purchase Price Variance Index | LI_14 | Long Integer | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['SmartList Item Quantity Master'].UPPVIDX AS 'SmartList Item Quantity Master-Unrealized Purchase Price Variance Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP11 AS ['SmartList Item Quantity Master']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Item Quantity Master'].UPPVIDX = ['Account Index Master'].ACTINDX | ||||||
97 | LSTCNTDT ![]() | Last Count Date | DT | Date | 8 | |
98 | LSTCNTTM ![]() | Last Count Time | TM6 | Time | 6 | |
99 | NXTCNTDT ![]() | Next Count Date | DT | Date | 8 | |
100 | NXTCNTTM ![]() | Next Count Time | TM6 | Time | 6 | |
101 | STCKCNTINTRVL ![]() | Stock Count Interval | INT4_U0 | Integer | 4 | |
102 | LOCNCODE1 ![]() | ASI_Location_Code | STR10_Location_Code | String | 10 | |
103 | VENDORID ![]() | Vendor ID | STR_15_Vendor_ID | String | 15 | |
Key to the PM Vendor Master File (PM00200).
Click to show/hideSELECT
['SmartList Item Quantity Master'].VENDORID AS 'SmartList Item Quantity Master-Vendor ID'
,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
ASIEXP11 AS ['SmartList Item Quantity Master']
INNER JOIN
PM00200 AS ['PM Vendor Master File']
ON
['SmartList Item Quantity Master'].VENDORID = ['PM Vendor Master File'].VENDORID | ||||||
104 | VNDCHKNM ![]() | Vendor Check Name | STR64_Vendor_Name | String | 64 | |
105 | VENDSHNM ![]() | Vendor Short Name | STR15 | String | 15 | |
106 | VADDCDPR ![]() | Vendor Address Code - Primary | STR15_Address_Code | String | 15 | |
Partial key to the PM Address MSTR (PM00300).
Click to show/hideSELECT
['SmartList Item Quantity Master'].VADDCDPR AS 'SmartList Item Quantity Master-Vendor Address Code - Primary'
,['PM Address MSTR'].ADRSCODE AS 'PM Address MSTR-Address Code'
FROM
ASIEXP11 AS ['SmartList Item Quantity Master']
INNER JOIN
PM00300 AS ['PM Address MSTR']
ON
['SmartList Item Quantity Master'].VADDCDPR = ['PM Address MSTR'].ADRSCODE
AND
['SmartList Item Quantity Master'].VENDORID = ['PM Address MSTR'].VENDORID | ||||||
107 | VADCDPAD ![]() | Vendor Address Code - Purchase Address | STR15_Address_Code | String | 15 | |
Partial key to the PM Address MSTR (PM00300).
Click to show/hideSELECT
['SmartList Item Quantity Master'].VADCDPAD AS 'SmartList Item Quantity Master-Vendor Address Code - Purchase Address'
,['PM Address MSTR'].ADRSCODE AS 'PM Address MSTR-Address Code'
FROM
ASIEXP11 AS ['SmartList Item Quantity Master']
INNER JOIN
PM00300 AS ['PM Address MSTR']
ON
['SmartList Item Quantity Master'].VADCDPAD = ['PM Address MSTR'].ADRSCODE
AND
['SmartList Item Quantity Master'].VENDORID = ['PM Address MSTR'].VENDORID | ||||||
108 | VADCDSFR ![]() | Vendor Address Code - Ship From | STR15_Address_Code | String | 15 | |
Partial key to the PM Address MSTR (PM00300).
Click to show/hideSELECT
['SmartList Item Quantity Master'].VADCDSFR AS 'SmartList Item Quantity Master-Vendor Address Code - Ship From'
,['PM Address MSTR'].ADRSCODE AS 'PM Address MSTR-Address Code'
FROM
ASIEXP11 AS ['SmartList Item Quantity Master']
INNER JOIN
PM00300 AS ['PM Address MSTR']
ON
['SmartList Item Quantity Master'].VADCDSFR = ['PM Address MSTR'].ADRSCODE
AND
['SmartList Item Quantity Master'].VENDORID = ['PM Address MSTR'].VENDORID | ||||||
109 | VADCDTRO ![]() | Vendor Address Code - Remit To | STR15_Address_Code | String | 15 | |
Partial key to the PM Address MSTR (PM00300).
Click to show/hideSELECT
['SmartList Item Quantity Master'].VADCDTRO AS 'SmartList Item Quantity Master-Vendor Address Code - Remit To'
,['PM Address MSTR'].ADRSCODE AS 'PM Address MSTR-Address Code'
FROM
ASIEXP11 AS ['SmartList Item Quantity Master']
INNER JOIN
PM00300 AS ['PM Address MSTR']
ON
['SmartList Item Quantity Master'].VADCDTRO = ['PM Address MSTR'].ADRSCODE
AND
['SmartList Item Quantity Master'].VENDORID = ['PM Address MSTR'].VENDORID | ||||||
110 | VNDCLSID ![]() | Vendor Class ID | STR10_Class_ID | String | 10 | |
Key to the PM Class Master File (PM00100).
Click to show/hideSELECT
['SmartList Item Quantity Master'].VNDCLSID AS 'SmartList Item Quantity Master-Vendor Class ID'
,['PM Class Master File'].VNDCLSID AS 'PM Class Master File-Vendor Class ID'
FROM
ASIEXP11 AS ['SmartList Item Quantity Master']
INNER JOIN
PM00100 AS ['PM Class Master File']
ON
['SmartList Item Quantity Master'].VNDCLSID = ['PM Class Master File'].VNDCLSID | ||||||
111 | VNDCNTCT ![]() | Vendor Contact | STR60 | String | 60 | |
112 | ADDRESS1 ![]() | Address 1 | STR60 | String | 60 | |
113 | ADDRESS2 ![]() | Address 2 | STR60 | String | 60 | |
114 | ADDRESS3 ![]() | Address 3 | STR60 | String | 60 | |
115 | CITY ![]() | City | STR35 | String | 35 | |
116 | STATE ![]() | State | STR30_State | String | 29 | |
117 | ZIPCODE ![]() | Zip Code | STR10 | String | 10 | |
118 | COUNTRY ![]() | Country | STR60 | String | 60 | |
119 | PHNUMBR1 ![]() | Phone Number 1 | Phone_Number | String | 14 | |
120 | PHNUMBR2 ![]() | Phone Number 2 | Phone_Number | String | 14 | |
121 | FAXNUMBR ![]() | Fax Number | STR14_FAX | String | 14 | |
122 | UPSZONE ![]() | UPS Zone | STR3 | String | 3 | |
123 | SHIPMTHD ![]() | Shipping Method | STR15_Shipping_Method | String | 15 | |
Key to the Shipping Methods Master (SY03000).
Click to show/hideSELECT
['SmartList Item Quantity Master'].SHIPMTHD AS 'SmartList Item Quantity Master-Shipping Method'
,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method'
FROM
ASIEXP11 AS ['SmartList Item Quantity Master']
INNER JOIN
SY03000 AS ['Shipping Methods Master']
ON
['SmartList Item Quantity Master'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD | ||||||
124 | TAXSCHID ![]() | Tax Schedule ID | STR15_Tax_Schedule_ID | String | 15 | |
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hideSELECT
['SmartList Item Quantity Master'].TAXSCHID AS 'SmartList Item Quantity Master-Tax Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
ASIEXP11 AS ['SmartList Item Quantity Master']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['SmartList Item Quantity Master'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID | ||||||
125 | ACNMVNDR ![]() | Account Number With Vendor | STR20 | String | 20 | |
126 | TXIDNMBR ![]() | Tax ID Number | Tax_ID_Number | String | 11 | |
127 | VENDSTTS ![]() | Vendor Status | DDL_Vendor_Status | Integer | 0 | |
128 | CURNCYID ![]() | Currency ID | STR15_Currency_ID | String | 15 | |
Key to the Currency Setup (MC40200).
Click to show/hideSELECT
['SmartList Item Quantity Master'].CURNCYID AS 'SmartList Item Quantity Master-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
ASIEXP11 AS ['SmartList Item Quantity Master']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['SmartList Item Quantity Master'].CURNCYID = ['Currency Setup'].CURNCYID | ||||||
129 | TXRGNNUM ![]() | Tax Registration Number | STR25 | String | 25 | |
130 | PARVENID ![]() | Parent Vendor ID | STR_15_Vendor_ID | String | 15 | |
131 | TRDDISCT ![]() | Trade Discount | INT4_%2 | Integer | 4 | |
132 | TEN99TYPE ![]() | 1099 Type | 1099_Type | Integer | 0 | |
133 | MINORDER ![]() | Minimum Order | DLR17_$U2 | Currency | 17 | |
134 | PYMTRMID ![]() | Payment Terms ID | STR20_Payment_Terms_ID | String | 20 | |
Key to the Payment Terms Master (SY03300).
Click to show/hideSELECT
['SmartList Item Quantity Master'].PYMTRMID AS 'SmartList Item Quantity Master-Payment Terms ID'
,['Payment Terms Master'].PYMTRMID AS 'Payment Terms Master-Payment Terms ID'
FROM
ASIEXP11 AS ['SmartList Item Quantity Master']
INNER JOIN
SY03300 AS ['Payment Terms Master']
ON
['SmartList Item Quantity Master'].PYMTRMID = ['Payment Terms Master'].PYMTRMID | ||||||
135 | MINPYTYP ![]() | Minimum Payment Type | GB_Amt_Type | Integer | 0 | |
136 | MINPYPCT ![]() | Minimum Payment Percent | INT5_%2 | Integer | 5 | |
137 | MINPYDLR ![]() | Minimum Payment Dollar | DLR17_RBS0_UTR$ | Currency | 17 | |
138 | MXIAFVND ![]() | Maximum Invoice Amount For Vendors | GB | Integer | 0 | |
139 | MAXINDLR ![]() | Maximum Invoice Dollar | DLR17_$U2 | Currency | 17 | |
140 | COMMENT1 ![]() | Comment1 | STR30 | String | 30 | |
141 | COMMENT2 ![]() | Comment2 | STR30 | String | 30 | |
142 | USERDEF1 ![]() | User Defined 1 | STR20 | String | 20 | |
143 | USERDEF2 ![]() | User Defined 2 | STR20 | String | 20 | |
144 | CRLMTDLR ![]() | Credit Limit Dollar | DLR17_$U2 | Currency | 17 | |
145 | PYMNTPRI ![]() | Payment Priority | STR3 | String | 3 | |
146 | KGLDSTHS ![]() | Keep GL Dist History | CB_Keep_GL_Dist_History | Boolean | 0 | |
147 | HOLD ![]() | Hold | CB_Hold | Boolean | 0 | |
148 | PTCSHACF ![]() | Post To Cash Account From | GB | Integer | 0 | |
149 | CREDTLMT ![]() | Credit Limit | GB | Integer | 0 | |
150 | WRITEOFF ![]() | Writeoff | GB | Integer | 0 | |
151 | MXWOFAMT ![]() | Maximum Write Off Amount | DLR17_$U2 | Currency | 17 | |
152 | SBPPSDED ![]() | Subject To PPS Deductions | CB_Subject_To_PPS_Deductions | Boolean | 0 | |
153 | PPSTAXRT ![]() | PPS Tax Rate | INT5_%2 | Integer | 5 | |
154 | DXVARNUM ![]() | Deduction Exemption/Variation Number | STR25 | String | 25 | |
155 | CRTCOMDT ![]() | Certificate Commencing Date | DT | Date | 8 | |
156 | CRTEXPDT ![]() | Certificate Expiration Date | DT | Date | 8 | |
157 | RTOBUTKN ![]() | Reporting Obligation Undertaken | CB_Reporting_Obligation | Boolean | 0 | |
158 | XPDTOBLG ![]() | Expiration Date Obligation | CB_Expiration_Date_Obligation | Boolean | 0 | |
159 | PRSPAYEE ![]() | Prescribed Payee | CB_Prescribed_Payee | Boolean | 0 | |
160 | PMAPINDX ![]() | PM AP Index | LI_14 | Long Integer | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['SmartList Item Quantity Master'].PMAPINDX AS 'SmartList Item Quantity Master-PM AP Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP11 AS ['SmartList Item Quantity Master']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Item Quantity Master'].PMAPINDX = ['Account Index Master'].ACTINDX | ||||||
161 | PMCSHIDX ![]() | PM Cash Index | LI_14 | Long Integer | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['SmartList Item Quantity Master'].PMCSHIDX AS 'SmartList Item Quantity Master-PM Cash Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP11 AS ['SmartList Item Quantity Master']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Item Quantity Master'].PMCSHIDX = ['Account Index Master'].ACTINDX | ||||||
162 | PMDAVIDX ![]() | PM Discount Available Index | LI_14 | Long Integer | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['SmartList Item Quantity Master'].PMDAVIDX AS 'SmartList Item Quantity Master-PM Discount Available Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP11 AS ['SmartList Item Quantity Master']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Item Quantity Master'].PMDAVIDX = ['Account Index Master'].ACTINDX | ||||||
163 | PMDTKIDX ![]() | PM Discount Taken Index | LI_14 | Long Integer | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['SmartList Item Quantity Master'].PMDTKIDX AS 'SmartList Item Quantity Master-PM Discount Taken Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP11 AS ['SmartList Item Quantity Master']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Item Quantity Master'].PMDTKIDX = ['Account Index Master'].ACTINDX | ||||||
164 | PMFINIDX ![]() | PM Finance Charge Index | LI_14 | Long Integer | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['SmartList Item Quantity Master'].PMFINIDX AS 'SmartList Item Quantity Master-PM Finance Charge Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP11 AS ['SmartList Item Quantity Master']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Item Quantity Master'].PMFINIDX = ['Account Index Master'].ACTINDX | ||||||
165 | PMMSCHIX ![]() | PM Misc Charges Index | LI_14 | Long Integer | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['SmartList Item Quantity Master'].PMMSCHIX AS 'SmartList Item Quantity Master-PM Misc Charges Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP11 AS ['SmartList Item Quantity Master']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Item Quantity Master'].PMMSCHIX = ['Account Index Master'].ACTINDX | ||||||
166 | PMFRTIDX ![]() | PM Freight Index | LI_14 | Long Integer | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['SmartList Item Quantity Master'].PMFRTIDX AS 'SmartList Item Quantity Master-PM Freight Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP11 AS ['SmartList Item Quantity Master']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Item Quantity Master'].PMFRTIDX = ['Account Index Master'].ACTINDX | ||||||
167 | PMTAXIDX ![]() | PM Tax Index | LI_14 | Long Integer | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['SmartList Item Quantity Master'].PMTAXIDX AS 'SmartList Item Quantity Master-PM Tax Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP11 AS ['SmartList Item Quantity Master']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Item Quantity Master'].PMTAXIDX = ['Account Index Master'].ACTINDX | ||||||
168 | PMWRTIDX ![]() | PM Write Offs Index | LI_14 | Long Integer | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['SmartList Item Quantity Master'].PMWRTIDX AS 'SmartList Item Quantity Master-PM Write Offs Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP11 AS ['SmartList Item Quantity Master']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Item Quantity Master'].PMWRTIDX = ['Account Index Master'].ACTINDX | ||||||
169 | PMPRCHIX ![]() | PM Purchases Index | LI_14 | Long Integer | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['SmartList Item Quantity Master'].PMPRCHIX AS 'SmartList Item Quantity Master-PM Purchases Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP11 AS ['SmartList Item Quantity Master']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Item Quantity Master'].PMPRCHIX = ['Account Index Master'].ACTINDX | ||||||
170 | PMRTNGIX ![]() | PM Retainage Index | LI_14 | Long Integer | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['SmartList Item Quantity Master'].PMRTNGIX AS 'SmartList Item Quantity Master-PM Retainage Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP11 AS ['SmartList Item Quantity Master']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Item Quantity Master'].PMRTNGIX = ['Account Index Master'].ACTINDX | ||||||
171 | PMTDSCIX ![]() | PM Trade Discount Index | LI_14 | Long Integer | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['SmartList Item Quantity Master'].PMTDSCIX AS 'SmartList Item Quantity Master-PM Trade Discount Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP11 AS ['SmartList Item Quantity Master']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Item Quantity Master'].PMTDSCIX = ['Account Index Master'].ACTINDX | ||||||
172 | ACPURIDX ![]() | Accrued Purchases Index | LI_14 | Long Integer | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['SmartList Item Quantity Master'].ACPURIDX AS 'SmartList Item Quantity Master-Accrued Purchases Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP11 AS ['SmartList Item Quantity Master']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Item Quantity Master'].ACPURIDX = ['Account Index Master'].ACTINDX | ||||||
173 | PURPVIDX1 ![]() | ASI_Purchase_Price_Variance_Index | LI_14 | Long Integer | 14 | |
174 | NOTEINDX ![]() | Note Index | DLR14 | Currency | 14 | |
Key to the Record Notes Master (SY03900).
Click to show/hideSELECT
['SmartList Item Quantity Master'].NOTEINDX AS 'SmartList Item Quantity Master-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
ASIEXP11 AS ['SmartList Item Quantity Master']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['SmartList Item Quantity Master'].NOTEINDX = ['Record Notes Master'].NOTEINDX | ||||||
175 | CHEKBKID ![]() | Checkbook ID | STR15_Checkbook_ID | String | 15 | |
Key to the CM Checkbook Master (CM00100).
Click to show/hideSELECT
['SmartList Item Quantity Master'].CHEKBKID AS 'SmartList Item Quantity Master-Checkbook ID'
,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
ASIEXP11 AS ['SmartList Item Quantity Master']
INNER JOIN
CM00100 AS ['CM Checkbook Master']
ON
['SmartList Item Quantity Master'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID | ||||||
176 | MODIFDT ![]() | Modified Date | DT | Date | 8 | |
177 | CREATDDT ![]() | Created Date | DT | Date | 8 | |
178 | RATETPID ![]() | Rate Type ID | STR15_Rate_Type_ID | String | 15 | |
Key to the Multicurrency Rate Type Setup (MC40100).
Click to show/hideSELECT
['SmartList Item Quantity Master'].RATETPID AS 'SmartList Item Quantity Master-Rate Type ID'
,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
ASIEXP11 AS ['SmartList Item Quantity Master']
INNER JOIN
MC40100 AS ['Multicurrency Rate Type Setup']
ON
['SmartList Item Quantity Master'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID | ||||||
179 | Revalue_Vendor ![]() | Revalue Vendor | CB Revalue Vendor | Boolean | 0 | |
180 | Post_Results_To ![]() | Post Results To | GB | Integer | 0 | |
181 | FREEONBOARD ![]() | Free On Board | DDL_Free_On_Board | Integer | 0 | |
182 | DISGRPER ![]() | Discount Grace Period | INT2_U0 | Integer | 2 | |
183 | DOCFMTID ![]() | Document Format ID | STR15_LBU | String | 15 | |
184 | DUEGRPER ![]() | Due Date Grace Period | INT2_U0 | Integer | 2 | |
185 | GOVCRPID ![]() | Governmental Corporate ID | STR30_Gov_Corp_ID | String | 30 | |
186 | GOVINDID ![]() | Governmental Individual ID | STR30_Gov_Indiv_ID | String | 30 | |
187 | PHONE3 ![]() | Phone 3 | Phone_Number3 | String | 14 | |
188 | TaxInvRecvd ![]() | Tax Invoice Received | CB_Tax_Invoice_Received | Boolean | 0 | |
189 | KPCALHST1 ![]() | ASI_Keep_Calendar_History | CB_Keep_Calendar_History | Boolean | 0 | |
190 | KPERHIST1 ![]() | ASI_Keep_Period_History | CB_Keep_Period_History | Boolean | 0 | |
191 | KPTRXHST1 ![]() | ASI_Keep_Trx_History | CB_Keep_Trx_History | Boolean | 0 | |
192 | UMDPQTYS ![]() | U Of M Decimal Places QTYS | DDL_Decimal_Places_QTYS | Integer | 0 | |
193 | UMSCHDSC ![]() | U Of M Schedule Description | STR30 | String | 30 | |
194 | CURRNIDX ![]() | Currency Index | INT3 | Integer | 3 | |
Key to the Currency Setup (MC40200).
Click to show/hideSELECT
['SmartList Item Quantity Master'].CURRNIDX AS 'SmartList Item Quantity Master-Currency Index'
,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
ASIEXP11 AS ['SmartList Item Quantity Master']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['SmartList Item Quantity Master'].CURRNIDX = ['Currency Setup'].CURRNIDX | ||||||
195 | ECORDQTY ![]() | Economic ORD QTY | DLR17_QTY_RBS0_UTR | Currency | 17 | |
196 | ITMVNDTY ![]() | Item Vendor Type | INT | Integer | 0 | |
197 | Last_Currency_ID ![]() | Last Currency ID | STR15_Currency_ID | String | 15 | |
198 | Last_Originating_Cost ![]() | Last Originating Cost | DLR17_RBS0_UTR$ | Currency | 17 | |
199 | LRCPTCST ![]() | Last RCPT Cost | DLR17_RBS0_UTR$ | Currency | 17 | |
200 | MAXORDQTY ![]() | Maximum ORD QTY | DLR17_QTY_RBS0_UTR | Currency | 17 | |
201 | MINORQTY ![]() | Minimum ORD QTY | DLR17_QTY_RBS0_UTR | Currency | 17 | |
202 | NORCTITM ![]() | Number Of RCPTS For Item | INT4 | Integer | 4 | |
203 | PLANNINGLEADTIME ![]() | Planning Lead Time | INT4_RB_U0 | Integer | 4 | |
204 | AVRGLDTM ![]() | Average Lead Time | LI6_RBS2_UT | Long Integer | 6 | |
205 | FREEONBOARD1 ![]() | ASI_Free_On_Board | DDL_Free_On_Board | Integer | 0 | |
206 | LSTORDDT1 ![]() | ASI_Last_ORD_Date | DATE | Date | 6 | |
207 | LSORDQTY1 ![]() | ASI_Last_ORD_QTY | DLR17_QTY_RBS0_UTR | Currency | 17 | |
208 | LSRCPTDT1 ![]() | ASI_Last_RCPT_Date | DATE | Date | 6 | |
209 | LRCPTQTY1 ![]() | ASI_Last_RCPT_QTY | DLR17_QTY_RBS0_UTR | Currency | 17 | |
210 | QTY_Drop_Shipped1 ![]() | ASI_QTY_Drop_Shipped | DLR17_QTY_RBS0_UTR | Currency | 17 | |
211 | QTYONORD1 ![]() | ASI_QTY_On_Order | DLR17_QTY_RBS0_UTR | Currency | 17 | |
212 | QTYRQSTN1 ![]() | ASI_QTY_Requisitioned | DLR17_QTY_RBS0_UTR | Currency | 17 | |
213 | PRCHSUOM1 ![]() | ASI_Purchasing_U_Of_M | U_Of_M | String | 8 | |
214 | Landed_Cost_Group_ID ![]() | Landed Cost Group ID | STR15_LBAU | String | 15 | |
215 | PORETRNBIN ![]() | Purchase Returns Bin | STR15_Bin | String | 15 | |
216 | SOFULFILLMENTBIN ![]() | SO Fulfillment Bin | STR15_Bin | String | 15 | |
217 | SORETURNBIN ![]() | SO Return Bin | STR15_Bin | String | 15 | |
218 | BOMRCPTBIN ![]() | BOM Receipt Bin | STR15_Bin | String | 15 | |
219 | MATERIALISSUEBIN ![]() | Material Issues Bin | STR15_Bin | String | 15 | |
220 | MORECEIPTBIN ![]() | MO Receipt Bin | STR15_Bin | String | 15 | |
221 | REPAIRISSUESBIN ![]() | Repair Issues Bin | STR15_Bin | String | 15 | |
222 | BUYERID ![]() | Buyer ID | STR15_User_ID | String | 15 | |
223 | PLANNERID ![]() | Planner ID | STR15_User_ID | String | 15 | |
224 | ORDERPOLICY ![]() | Order Policy | DDL_Order_Policy | Integer | 0 | |
225 | FXDORDRQTY ![]() | Fixed Order Qty | DLR17_QTY_RBS0_UTR | Currency | 17 | |
226 | NMBROFDYS ![]() | Number of Days | INT3_U0 | Integer | 3 | |
227 | MNMMORDRQTY ![]() | Minimum Order Qty | DLR17_QTY_RBS0_UTR | Currency | 17 | |
228 | MXMMORDRQTY ![]() | Maximum Order Qty | DLR17_QTY_RBS0_UTR | Currency | 17 | |
229 | ORDERMULTIPLE ![]() | Order Multiple | DLR17_QTY_RBS0_UTR | Currency | 17 | |
230 | REPLENISHMENTMETHOD ![]() | Replenishment Method | DDL_Replenishment_Method | Integer | 0 | |
231 | SHRINKAGEFACTOR ![]() | Shrinkage Factor | DLR1_4 | Currency | 6 | |
232 | PRCHSNGLDTM ![]() | Purchasing Lead Time | DLR4_U2 | Currency | 9 | |
233 | MNFCTRNGFXDLDTM ![]() | Manufacturing Fixed Lead Time | DLR4_U2 | Currency | 9 | |
234 | MNFCTRNGVRBLLDTM ![]() | Manufacturing Variable Lead Time | DLR3_U4 | Currency | 8 | |
235 | STAGINGLDTME ![]() | Staging Lead Time | DLR4_U2 | Currency | 9 | |
236 | PLNNNGTMFNCDYS ![]() | Planning Time Fence Days | INT3_U0 | Integer | 3 | |
237 | DMNDTMFNCPRDS ![]() | Demand Time Fence Periods | INT3_U0 | Integer | 3 | |
238 | INCLDDINPLNNNG ![]() | Included in Planning | CB | Boolean | 0 | |
239 | FRCSTCNSMPTNPRD ![]() | Forecast Consumption Period | DDL_Forecast_Consumption_Period | Integer | 0 | |
240 | SFTYSTCKQTY ![]() | Safety Stock Qty | DLR17_QTY_RBS0_UTR | Currency | 17 | |
241 | PORECEIPTBIN ![]() | Purchase Receipt Bin | STR15_Bin | String | 15 | |
242 | ReplenishmentLevel ![]() | Replenishment Level | DDL_ReplenishmentLevel | Integer | 0 | |
243 | POPOrderMethod ![]() | POP Order Method | DDL_POP_OrderMethod | Integer | 0 | |
244 | MasterLocationCode ![]() | Master Location Code | STR10_Location_Code | String | 10 | |
245 | POPVendorSelection ![]() | POP Vendor Selection | DDL_POP_VendorSelection | Integer | 0 | |
246 | POPPricingSelection ![]() | POP Pricing Selection | DDL_POP_PriceSelection | Integer | 0 | |
247 | PurchasePrice ![]() | Purchase Price | DLR17_RBS0_UTR$ | Currency | 17 | |
248 | IncludeAllocations ![]() | Include Allocations | CB_IncludeAllocations | Boolean | 0 | |
249 | IncludeBackorders ![]() | Include Backorders | CB_IncludeBackorders | Boolean | 0 | |
250 | IncludeRequisitions ![]() | Include Requisitions | CB_IncludeRequisitions | Boolean | 0 |