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: Pathname

Display Name: SmartList Purchasing Receipt Lines
Physical Name: ASIEXP28
Technical Name: ASI_POP_ReceiptLine_Explorer

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1ASI_Favorite_Sequence SearchASI_Favorite_SequenceASI_LI_10_RULong Integer410
2ASI_Order_By SearchASI_Order_ByLI_14Long Integer414
3ASI_Document_Status SearchASI_Document_StatusINTInteger20
4POPRCTNM SearchPOP Receipt NumberSTR17_POP_NumberString1817
5RCPTLNNM SearchReceipt Line NumberLI_Sequence_NumberLong Integer410
6PONUMBER SearchPO NumberSTR17_POP_NumberString1817
7ITEMNMBR SearchItem NumberSTR30_Item_NumberString3230
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 DescriptionSTR100String102100
9VNDITNUM SearchVendor Item NumberItem_NumberString3230
10VNDITDSC SearchVendor Item DescriptionSTR100String102100
11UMQTYINB SearchU Of M QTY In BaseDLR17_QTY_RBS0_STRCurrency1017
12ACTLSHIP SearchActual Ship DateDTDate48
13COMMNTID SearchComment IDSTR15_Comment_IDString1615
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 IndexLI_14Long Integer414
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 MU_Of_MString108
16UNITCOST SearchUnit CostDLR17_RBS0_UTR$Currency1017
17EXTDCOST SearchExtended CostDLR17_RBS0_UTR$Currency1017
18LOCNCODE SearchLocation CodeSTR10_Location_CodeString1210
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 IVINT1Integer21
20DECPLCUR SearchDecimal Places CurrencyDDL_Decimal_Places_DollarsInteger20
21DECPLQTY SearchDecimal Places QTYSDDL_Decimal_Places_QTYSInteger20
22ITMTRKOP SearchItem Tracking OptionDDL_TrackInteger20
23TRXSORCE SearchTRX SourceSTR13String1413
24JOBNUMBR SearchJob NumberSTR17_LBAUString1817
25COSTCODE SearchCost CodeSTR27String2827
26COSTTYPE SearchCost Code TypeINT3_RB0_UInteger23
27CURNCYID SearchCurrency IDSTR15_Currency_IDString1615
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 IndexINT3Integer23
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 RateDLR14_Exchange_RateCurrency (Variable)1014
30RATECALC SearchRate Calc MethodINTInteger20
31DENXRATE SearchDenomination Exchange RateDLR14_Exchange_RateCurrency (Variable)1014
32ORUNTCST SearchOriginating Unit CostDLR17_RBS0_UTR$Currency1017
33OREXTCST SearchOriginating Extended CostDLR17_RBS0_UTR$Currency1017
34ODECPLCU SearchOriginating Decimal Places CurrencyDDL_Decimal_Places_DollarsInteger20
35BOLPRONUMBER SearchBOL_PRO NumberSTR30String3230
36Capital_Item SearchCapital ItemCB_Capital_ItemBoolean20
37Product_Indicator SearchProduct IndicatorDDL_Product_IndicatorInteger20
38Purchase_IV_Item_Taxable SearchPurchase IV Item TaxableDDL_Purchase_Tax_OptionsInteger20
39Purchase_Item_Tax_Schedu SearchPurchase Item Tax Schedule IDSTR15_LBAUString1615
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 IDSTR15_LBAUString1615
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 TotalYNBoolean20
42TAXAMNT SearchTax AmountDLR17_RBS0_UTR$Currency1017
43ORTAXAMT SearchOriginating Tax AmountDLR17_RBS0_UTR$Currency1017
44BKTPURAM SearchBackout Purchases AmountDLR19_RBS0_UTR$Currency1019
45OBKPURAMT SearchOriginating Backout Purchases AmountDLR19_RBS0_UTR$Currency1019
46Revalue_Inventory SearchRevalue InventoryCB_Revalue_InventoryBoolean20
47PURPVIDX SearchPurchase Price Variance IndexLI_14Long Integer414
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 StatusINTInteger20
49POPTYPE SearchPOP TypeDDL_POP_TypeInteger20
50VENDORID SearchVendor IDSTR_15_Vendor_IDString1615
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 NameSTR64_Vendor_NameString6664
52VNDDOCNM SearchVendor Document NumberSTR20_Document_NumberString2220
53GLPOSTDT SearchGL Posting DateDTDate48
54receiptdate SearchReceipt DateDTDate48
55BCHSOURC SearchBatch SourceSTR15String1615
56BACHNUMB SearchBatch NumberSTR15_LBAUString1615
57POSTEDDT SearchPosted DateDATEDate46
58PTDUSRID SearchPosted User IDSTR15String1615
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 EnterSTR15_User_IDString1615
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 DateDTDate48
61MODIFDT SearchModified DateDTDate48
62Tax_Date SearchTax DateDTDate48
63QTYSHPPD SearchQTY ShippedDLR17_QTY_RBS0_UTRCurrency1017
64QTYINVCD SearchQTY InvoicedDLR17_QTY_RBS0_UTRCurrency1017
65QTYREJ SearchQTY RejectedDLR17_QTY_RBS0_UTRCurrency1017
66Landed_Cost_Group_ID SearchLanded Cost Group IDSTR15_LBAUString1615
67Landed_Cost SearchLanded CostCBBoolean20
68RCPTRETNUM SearchReceipt Return NumberSTR17_POP_NumberString1817
69INVRETNUM SearchInvoice Return NumberSTR17_POP_NumberString1817
70BIN SearchBinSTR15_BinString1615
71Total_Landed_Cost_Amount SearchTotal Landed Cost AmountDLR17_RBS0_UTR$Currency1017
72QTYRESERVED SearchQTY ReservedDLR17_QTY_RBS0_UTRCurrency1017
73QTYINVRESERVE SearchQTY Invoice ReserveDLR17_QTY_RBS0_UTRCurrency1017
74UMSCHDSC SearchU Of M Schedule DescriptionSTR30String3230
75QTYMATCH SearchQTY MatchedDLR17_QTY_RBS0_UTRCurrency1017
76ProjNum SearchProject NumberSTR15_LBAUString1615
77CostCatID SearchCost Category IDSTR15_LBAUString1615
azurecurveProductsSmartList (1493)PathnameSmartList Purchasing Receipt Lines (ASIEXP28)

Leave a Reply

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