Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/ASIEXP28
Product: SmartList (1493)
Series: Pathname
Display Name: SmartList Purchasing Receipt Lines
Physical Name: ASIEXP28
Technical Name: ASI_POP_ReceiptLine_ExplorerSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 ASI_Favorite_Sequence 
ASI_Favorite_Sequence ASI_LI_10_RU Long Integer 10 2 ASI_Order_By ASI_Order_By LI_14 Long Integer 14 3 ASI_Document_Status ASI_Document_Status INT Integer 0 4 POPRCTNM POP Receipt Number STR17_POP_Number String 17 5 RCPTLNNM Receipt Line Number LI_Sequence_Number Long Integer 10 6 PONUMBER PO Number STR17_POP_Number String 17 7 ITEMNMBR Item Number STR30_Item_Number String 30 Key to the Item Master (IV00101).
Click to show/hide
SELECT
['SmartList Purchasing Receipt Lines'].ITEMNMBR AS 'SmartList Purchasing Receipt Lines-Item Number'
,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
ASIEXP28 AS ['SmartList Purchasing Receipt Lines']
INNER JOIN
IV00101 AS ['Item Master']
ON
['SmartList Purchasing Receipt Lines'].ITEMNMBR = ['Item Master'].ITEMNMBR8 ITEMDESC Item Description STR100 String 100 9 VNDITNUM Vendor Item Number Item_Number String 30 10 VNDITDSC Vendor Item Description STR100 String 100 11 UMQTYINB U Of M QTY In Base DLR17_QTY_RBS0_STR Currency 17 12 ACTLSHIP Actual Ship Date DT Date 8 13 COMMNTID Comment ID STR15_Comment_ID String 15 Key to the Comment Master (SY04200).
Click to show/hide
SELECT
['SmartList Purchasing Receipt Lines'].COMMNTID AS 'SmartList Purchasing Receipt Lines-Comment ID'
,['Comment Master'].COMMNTID AS 'Comment Master-Comment ID'
FROM
ASIEXP28 AS ['SmartList Purchasing Receipt Lines']
INNER JOIN
SY04200 AS ['Comment Master']
ON
['SmartList Purchasing Receipt Lines'].COMMNTID = ['Comment Master'].COMMNTID14 INVINDX Inventory Index LI_14 Long Integer 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['SmartList Purchasing Receipt Lines'].INVINDX AS 'SmartList Purchasing Receipt Lines-Inventory Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP28 AS ['SmartList Purchasing Receipt Lines']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Purchasing Receipt Lines'].INVINDX = ['Account Index Master'].ACTINDX15 UOFM U Of M U_Of_M String 8 16 UNITCOST Unit Cost DLR17_RBS0_UTR$ Currency 17 17 EXTDCOST Extended Cost DLR17_RBS0_UTR$ Currency 17 18 LOCNCODE Location Code STR10_Location_Code String 10 Key to the Site Setup (IV40700).
Click to show/hide
SELECT
['SmartList Purchasing Receipt Lines'].LOCNCODE AS 'SmartList Purchasing Receipt Lines-Location Code'
,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
ASIEXP28 AS ['SmartList Purchasing Receipt Lines']
INNER JOIN
IV40700 AS ['Site Setup']
ON
['SmartList Purchasing Receipt Lines'].LOCNCODE = ['Site Setup'].LOCNCODE19 NONINVEN Non IV INT1 Integer 1 20 DECPLCUR Decimal Places Currency DDL_Decimal_Places_Dollars Integer 0 21 DECPLQTY Decimal Places QTYS DDL_Decimal_Places_QTYS Integer 0 22 ITMTRKOP Item Tracking Option DDL_Track Integer 0 23 TRXSORCE TRX Source STR13 String 13 24 JOBNUMBR Job Number STR17_LBAU String 17 25 COSTCODE Cost Code STR27 String 27 26 COSTTYPE Cost Code Type INT3_RB0_U Integer 3 27 CURNCYID Currency ID STR15_Currency_ID String 15 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['SmartList Purchasing Receipt Lines'].CURNCYID AS 'SmartList Purchasing Receipt Lines-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
ASIEXP28 AS ['SmartList Purchasing Receipt Lines']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['SmartList Purchasing Receipt Lines'].CURNCYID = ['Currency Setup'].CURNCYID28 CURRNIDX Currency Index INT3 Integer 3 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['SmartList Purchasing Receipt Lines'].CURRNIDX AS 'SmartList Purchasing Receipt Lines-Currency Index'
,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
ASIEXP28 AS ['SmartList Purchasing Receipt Lines']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['SmartList Purchasing Receipt Lines'].CURRNIDX = ['Currency Setup'].CURRNIDX29 XCHGRATE Exchange Rate DLR14_Exchange_Rate Currency (Variable) 14 30 RATECALC Rate Calc Method INT Integer 0 31 DENXRATE Denomination Exchange Rate DLR14_Exchange_Rate Currency (Variable) 14 32 ORUNTCST Originating Unit Cost DLR17_RBS0_UTR$ Currency 17 33 OREXTCST Originating Extended Cost DLR17_RBS0_UTR$ Currency 17 34 ODECPLCU Originating Decimal Places Currency DDL_Decimal_Places_Dollars Integer 0 35 BOLPRONUMBER BOL_PRO Number STR30 String 30 36 Capital_Item Capital Item CB_Capital_Item Boolean 0 37 Product_Indicator Product Indicator DDL_Product_Indicator Integer 0 38 Purchase_IV_Item_Taxable Purchase IV Item Taxable DDL_Purchase_Tax_Options Integer 0 39 Purchase_Item_Tax_Schedu Purchase Item Tax Schedule ID STR15_LBAU String 15 Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hide
SELECT
['SmartList Purchasing Receipt Lines'].Purchase_Item_Tax_Schedu AS 'SmartList Purchasing Receipt Lines-Purchase Item Tax Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
ASIEXP28 AS ['SmartList Purchasing Receipt Lines']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['SmartList Purchasing Receipt Lines'].Purchase_Item_Tax_Schedu = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID40 Purchase_Site_Tax_Schedu Purchase Site Tax Schedule ID STR15_LBAU String 15 Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hide
SELECT
['SmartList Purchasing Receipt Lines'].Purchase_Site_Tax_Schedu AS 'SmartList Purchasing Receipt Lines-Purchase Site Tax Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
ASIEXP28 AS ['SmartList Purchasing Receipt Lines']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['SmartList Purchasing Receipt Lines'].Purchase_Site_Tax_Schedu = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID41 BSIVCTTL Based On Invoice Total YN Boolean 0 42 TAXAMNT Tax Amount DLR17_RBS0_UTR$ Currency 17 43 ORTAXAMT Originating Tax Amount DLR17_RBS0_UTR$ Currency 17 44 BKTPURAM Backout Purchases Amount DLR19_RBS0_UTR$ Currency 19 45 OBKPURAMT Originating Backout Purchases Amount DLR19_RBS0_UTR$ Currency 19 46 Revalue_Inventory Revalue Inventory CB_Revalue_Inventory Boolean 0 47 PURPVIDX Purchase Price Variance Index LI_14 Long Integer 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['SmartList Purchasing Receipt Lines'].PURPVIDX AS 'SmartList Purchasing Receipt Lines-Purchase Price Variance Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP28 AS ['SmartList Purchasing Receipt Lines']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Purchasing Receipt Lines'].PURPVIDX = ['Account Index Master'].ACTINDX48 PSTGSTUS Posting Status INT Integer 0 49 POPTYPE POP Type DDL_POP_Type Integer 0 50 VENDORID Vendor ID STR_15_Vendor_ID String 15 Key to the PM Vendor Master File (PM00200).
Click to show/hide
SELECT
['SmartList Purchasing Receipt Lines'].VENDORID AS 'SmartList Purchasing Receipt Lines-Vendor ID'
,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
ASIEXP28 AS ['SmartList Purchasing Receipt Lines']
INNER JOIN
PM00200 AS ['PM Vendor Master File']
ON
['SmartList Purchasing Receipt Lines'].VENDORID = ['PM Vendor Master File'].VENDORID51 VENDNAME Vendor Name STR64_Vendor_Name String 64 52 VNDDOCNM Vendor Document Number STR20_Document_Number String 20 53 GLPOSTDT GL Posting Date DT Date 8 54 receiptdate Receipt Date DT Date 8 55 BCHSOURC Batch Source STR15 String 15 56 BACHNUMB Batch Number STR15_LBAU String 15 57 POSTEDDT Posted Date DATE Date 6 58 PTDUSRID Posted User ID STR15 String 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['SmartList Purchasing Receipt Lines'].PTDUSRID AS 'SmartList Purchasing Receipt Lines-Posted User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
ASIEXP28 AS ['SmartList Purchasing Receipt Lines']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['SmartList Purchasing Receipt Lines'].PTDUSRID = ['Users Master'].USERID59 USER2ENT User To Enter STR15_User_ID String 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['SmartList Purchasing Receipt Lines'].USER2ENT AS 'SmartList Purchasing Receipt Lines-User To Enter'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
ASIEXP28 AS ['SmartList Purchasing Receipt Lines']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['SmartList Purchasing Receipt Lines'].USER2ENT = ['Users Master'].USERID60 CREATDDT Created Date DT Date 8 61 MODIFDT Modified Date DT Date 8 62 Tax_Date Tax Date DT Date 8 63 QTYSHPPD QTY Shipped DLR17_QTY_RBS0_UTR Currency 17 64 QTYINVCD QTY Invoiced DLR17_QTY_RBS0_UTR Currency 17 65 QTYREJ QTY Rejected DLR17_QTY_RBS0_UTR Currency 17 66 Landed_Cost_Group_ID Landed Cost Group ID STR15_LBAU String 15 67 Landed_Cost Landed Cost CB Boolean 0 68 RCPTRETNUM Receipt Return Number STR17_POP_Number String 17 69 INVRETNUM Invoice Return Number STR17_POP_Number String 17 70 BIN Bin STR15_Bin String 15 71 Total_Landed_Cost_Amount Total Landed Cost Amount DLR17_RBS0_UTR$ Currency 17 72 QTYRESERVED QTY Reserved DLR17_QTY_RBS0_UTR Currency 17 73 QTYINVRESERVE QTY Invoice Reserve DLR17_QTY_RBS0_UTR Currency 17 74 UMSCHDSC U Of M Schedule Description STR30 String 30 75 QTYMATCH QTY Matched DLR17_QTY_RBS0_UTR Currency 17 76 ProjNum Project Number STR15_LBAU String 15 77 CostCatID Cost Category ID STR15_LBAU String 15