Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/ASIEXP28
Product: SmartList (1493)
Series:
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 Long Integer ASI_LI_10_RU 10 2 ASI_Order_By ASI_Order_By Long Integer LI_14 14 3 ASI_Document_Status ASI_Document_Status Integer INT 0 4 POPRCTNM POP Receipt Number String STR17_POP_Number 17 5 RCPTLNNM Receipt Line Number Long Integer LI_Sequence_Number 10 6 PONUMBER PO Number String STR17_POP_Number 17 7 ITEMNMBR Item Number String STR30_Item_Number 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 String STR100 100 9 VNDITNUM Vendor Item Number String Item_Number 30 10 VNDITDSC Vendor Item Description String STR100 100 11 UMQTYINB U Of M QTY In Base Currency DLR17_QTY_RBS0_STR 17 12 ACTLSHIP Actual Ship Date Date DT 8 13 COMMNTID Comment ID String STR15_Comment_ID 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 Long Integer LI_14 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 String U_Of_M 8 16 UNITCOST Unit Cost Currency DLR17_RBS0_UTR$ 17 17 EXTDCOST Extended Cost Currency DLR17_RBS0_UTR$ 17 18 LOCNCODE Location Code String STR10_Location_Code 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 Integer INT1 1 20 DECPLCUR Decimal Places Currency Integer DDL_Decimal_Places_Dollars 0 21 DECPLQTY Decimal Places QTYS Integer DDL_Decimal_Places_QTYS 0 22 ITMTRKOP Item Tracking Option Integer DDL_Track 0 23 TRXSORCE TRX Source String STR13 13 24 JOBNUMBR Job Number String STR17_LBAU 17 25 COSTCODE Cost Code String STR27 27 26 COSTTYPE Cost Code Type Integer INT3_RB0_U 3 27 CURNCYID Currency ID String STR15_Currency_ID 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 Integer INT3 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 Currency (Variable) DLR14_Exchange_Rate 14 30 RATECALC Rate Calc Method Integer INT 0 31 DENXRATE Denomination Exchange Rate Currency (Variable) DLR14_Exchange_Rate 14 32 ORUNTCST Originating Unit Cost Currency DLR17_RBS0_UTR$ 17 33 OREXTCST Originating Extended Cost Currency DLR17_RBS0_UTR$ 17 34 ODECPLCU Originating Decimal Places Currency Integer DDL_Decimal_Places_Dollars 0 35 BOLPRONUMBER BOL_PRO Number String STR30 30 36 Capital_Item Capital Item Boolean CB_Capital_Item 0 37 Product_Indicator Product Indicator Integer DDL_Product_Indicator 0 38 Purchase_IV_Item_Taxable Purchase IV Item Taxable Integer DDL_Purchase_Tax_Options 0 39 Purchase_Item_Tax_Schedu Purchase Item Tax Schedule ID String STR15_LBAU 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 String STR15_LBAU 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 Boolean YN 0 42 TAXAMNT Tax Amount Currency DLR17_RBS0_UTR$ 17 43 ORTAXAMT Originating Tax Amount Currency DLR17_RBS0_UTR$ 17 44 BKTPURAM Backout Purchases Amount Currency DLR19_RBS0_UTR$ 19 45 OBKPURAMT Originating Backout Purchases Amount Currency DLR19_RBS0_UTR$ 19 46 Revalue_Inventory Revalue Inventory Boolean CB_Revalue_Inventory 0 47 PURPVIDX Purchase Price Variance Index Long Integer LI_14 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 Integer INT 0 49 POPTYPE POP Type Integer DDL_POP_Type 0 50 VENDORID Vendor ID String STR_15_Vendor_ID 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 String STR64_Vendor_Name 64 52 VNDDOCNM Vendor Document Number String STR20_Document_Number 20 53 GLPOSTDT GL Posting Date Date DT 8 54 receiptdate Receipt Date Date DT 8 55 BCHSOURC Batch Source String STR15 15 56 BACHNUMB Batch Number String STR15_LBAU 15 57 POSTEDDT Posted Date Date DATE 6 58 PTDUSRID Posted User ID String STR15 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 String STR15_User_ID 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 Date DT 8 61 MODIFDT Modified Date Date DT 8 62 Tax_Date Tax Date Date DT 8 63 QTYSHPPD QTY Shipped Currency DLR17_QTY_RBS0_UTR 17 64 QTYINVCD QTY Invoiced Currency DLR17_QTY_RBS0_UTR 17 65 QTYREJ QTY Rejected Currency DLR17_QTY_RBS0_UTR 17 66 Landed_Cost_Group_ID Landed Cost Group ID String STR15_LBAU 15 67 Landed_Cost Landed Cost Boolean CB 0 68 RCPTRETNUM Receipt Return Number String STR17_POP_Number 17 69 INVRETNUM Invoice Return Number String STR17_POP_Number 17 70 BIN Bin String STR15_Bin 15 71 Total_Landed_Cost_Amount Total Landed Cost Amount Currency DLR17_RBS0_UTR$ 17 72 QTYRESERVED QTY Reserved Currency DLR17_QTY_RBS0_UTR 17 73 QTYINVRESERVE QTY Invoice Reserve Currency DLR17_QTY_RBS0_UTR 17 74 UMSCHDSC U Of M Schedule Description String STR30 30 75 QTYMATCH QTY Matched Currency DLR17_QTY_RBS0_UTR 17 76 ProjNum Project Number String STR15_LBAU 15 77 CostCatID Cost Category ID String STR15_LBAU 15