SmartList Purchasing Receipt Lines (ASIEXP28)

azurecurveProductsSmartList (1493)PathnameSmartList Purchasing Receipt Lines (ASIEXP28)

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_Explorer

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1ASI_Favorite_Sequence SearchASI_Favorite_SequenceLong IntegerASI_LI_10_RU10
2ASI_Order_By SearchASI_Order_ByLong IntegerLI_1414
3ASI_Document_Status SearchASI_Document_StatusIntegerINT0
4POPRCTNM SearchPOP Receipt NumberStringSTR17_POP_Number17
5RCPTLNNM SearchReceipt Line NumberLong IntegerLI_Sequence_Number10
6PONUMBER SearchPO NumberStringSTR17_POP_Number17
7ITEMNMBR SearchItem NumberStringSTR30_Item_Number30
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'].ITEMNMBR
8ITEMDESC SearchItem DescriptionStringSTR100100
9VNDITNUM SearchVendor Item NumberStringItem_Number30
10VNDITDSC SearchVendor Item DescriptionStringSTR100100
11UMQTYINB SearchU Of M QTY In BaseCurrencyDLR17_QTY_RBS0_STR17
12ACTLSHIP SearchActual Ship DateDateDT8
13COMMNTID SearchComment IDStringSTR15_Comment_ID15
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'].COMMNTID
14INVINDX SearchInventory IndexLong IntegerLI_1414
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'].ACTINDX
15UOFM SearchU Of MStringU_Of_M8
16UNITCOST SearchUnit CostCurrencyDLR17_RBS0_UTR$17
17EXTDCOST SearchExtended CostCurrencyDLR17_RBS0_UTR$17
18LOCNCODE SearchLocation CodeStringSTR10_Location_Code10
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'].LOCNCODE
19NONINVEN SearchNon IVIntegerINT11
20DECPLCUR SearchDecimal Places CurrencyIntegerDDL_Decimal_Places_Dollars0
21DECPLQTY SearchDecimal Places QTYSIntegerDDL_Decimal_Places_QTYS0
22ITMTRKOP SearchItem Tracking OptionIntegerDDL_Track0
23TRXSORCE SearchTRX SourceStringSTR1313
24JOBNUMBR SearchJob NumberStringSTR17_LBAU17
25COSTCODE SearchCost CodeStringSTR2727
26COSTTYPE SearchCost Code TypeIntegerINT3_RB0_U3
27CURNCYID SearchCurrency IDStringSTR15_Currency_ID15
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'].CURNCYID
28CURRNIDX SearchCurrency IndexIntegerINT33
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'].CURRNIDX
29XCHGRATE SearchExchange RateCurrency (Variable)DLR14_Exchange_Rate14
30RATECALC SearchRate Calc MethodIntegerINT0
31DENXRATE SearchDenomination Exchange RateCurrency (Variable)DLR14_Exchange_Rate14
32ORUNTCST SearchOriginating Unit CostCurrencyDLR17_RBS0_UTR$17
33OREXTCST SearchOriginating Extended CostCurrencyDLR17_RBS0_UTR$17
34ODECPLCU SearchOriginating Decimal Places CurrencyIntegerDDL_Decimal_Places_Dollars0
35BOLPRONUMBER SearchBOL_PRO NumberStringSTR3030
36Capital_Item SearchCapital ItemBooleanCB_Capital_Item0
37Product_Indicator SearchProduct IndicatorIntegerDDL_Product_Indicator0
38Purchase_IV_Item_Taxable SearchPurchase IV Item TaxableIntegerDDL_Purchase_Tax_Options0
39Purchase_Item_Tax_Schedu SearchPurchase Item Tax Schedule IDStringSTR15_LBAU15
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'].TAXSCHID
40Purchase_Site_Tax_Schedu SearchPurchase Site Tax Schedule IDStringSTR15_LBAU15
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'].TAXSCHID
41BSIVCTTL SearchBased On Invoice TotalBooleanYN0
42TAXAMNT SearchTax AmountCurrencyDLR17_RBS0_UTR$17
43ORTAXAMT SearchOriginating Tax AmountCurrencyDLR17_RBS0_UTR$17
44BKTPURAM SearchBackout Purchases AmountCurrencyDLR19_RBS0_UTR$19
45OBKPURAMT SearchOriginating Backout Purchases AmountCurrencyDLR19_RBS0_UTR$19
46Revalue_Inventory SearchRevalue InventoryBooleanCB_Revalue_Inventory0
47PURPVIDX SearchPurchase Price Variance IndexLong IntegerLI_1414
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'].ACTINDX
48PSTGSTUS SearchPosting StatusIntegerINT0
49POPTYPE SearchPOP TypeIntegerDDL_POP_Type0
50VENDORID SearchVendor IDStringSTR_15_Vendor_ID15
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'].VENDORID
51VENDNAME SearchVendor NameStringSTR64_Vendor_Name64
52VNDDOCNM SearchVendor Document NumberStringSTR20_Document_Number20
53GLPOSTDT SearchGL Posting DateDateDT8
54receiptdate SearchReceipt DateDateDT8
55BCHSOURC SearchBatch SourceStringSTR1515
56BACHNUMB SearchBatch NumberStringSTR15_LBAU15
57POSTEDDT SearchPosted DateDateDATE6
58PTDUSRID SearchPosted User IDStringSTR1515
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'].USERID
59USER2ENT SearchUser To EnterStringSTR15_User_ID15
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'].USERID
60CREATDDT SearchCreated DateDateDT8
61MODIFDT SearchModified DateDateDT8
62Tax_Date SearchTax DateDateDT8
63QTYSHPPD SearchQTY ShippedCurrencyDLR17_QTY_RBS0_UTR17
64QTYINVCD SearchQTY InvoicedCurrencyDLR17_QTY_RBS0_UTR17
65QTYREJ SearchQTY RejectedCurrencyDLR17_QTY_RBS0_UTR17
66Landed_Cost_Group_ID SearchLanded Cost Group IDStringSTR15_LBAU15
67Landed_Cost SearchLanded CostBooleanCB0
68RCPTRETNUM SearchReceipt Return NumberStringSTR17_POP_Number17
69INVRETNUM SearchInvoice Return NumberStringSTR17_POP_Number17
70BIN SearchBinStringSTR15_Bin15
71Total_Landed_Cost_Amount SearchTotal Landed Cost AmountCurrencyDLR17_RBS0_UTR$17
72QTYRESERVED SearchQTY ReservedCurrencyDLR17_QTY_RBS0_UTR17
73QTYINVRESERVE SearchQTY Invoice ReserveCurrencyDLR17_QTY_RBS0_UTR17
74UMSCHDSC SearchU Of M Schedule DescriptionStringSTR3030
75QTYMATCH SearchQTY MatchedCurrencyDLR17_QTY_RBS0_UTR17
76ProjNum SearchProject NumberStringSTR15_LBAU15
77CostCatID SearchCost Category IDStringSTR15_LBAU15
azurecurveProductsSmartList (1493)PathnameSmartList Purchasing Receipt Lines (ASIEXP28)

Leave a Reply

Your email address will not be published. Required fields are marked *