SmartList Landed Cost ID (ASIEXP30)

azurecurveProductsSmartList (1493)PathnameSmartList Landed Cost ID (ASIEXP30)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/ASIEXP30

Product: SmartList (1493)
Series: Pathname

Display Name: SmartList Landed Cost ID
Physical Name: ASIEXP30
Technical Name: ASI_IV_Landed_Cost_ID_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
3Landed_Cost_ID SearchLanded Cost IDSTR15_LBAUString1615
4Long_Description SearchLong DescriptionSTR50String5250
5VENDORID SearchVendor IDSTR_15_Vendor_IDString1615
Key to the PM Vendor Master File (PM00200).

Click to show/hide

SELECT
       ['SmartList Landed Cost ID'].VENDORID AS 'SmartList Landed Cost ID-Vendor ID'
       ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
       ASIEXP30 AS ['SmartList Landed Cost ID']
INNER JOIN
       PM00200 AS ['PM Vendor Master File']
              ON
                     ['SmartList Landed Cost ID'].VENDORID = ['PM Vendor Master File'].VENDORID
6CALCMTHD SearchCalculation MethodCalculation_MethodInteger20
7Orig_Landed_Cost_Amount SearchOriginating Landed Cost AmountDLR17_RBS0_UTR$Currency1017
8Calculation_Percentage SearchCalculation PercentageLI6_U%3Long Integer46
9Invoice_Match SearchInvoice MatchCB_Invoice_MatchBoolean20
10ACPURIDX SearchAccrued Purchases IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Landed Cost ID'].ACPURIDX AS 'SmartList Landed Cost ID-Accrued Purchases Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP30 AS ['SmartList Landed Cost ID']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Landed Cost ID'].ACPURIDX = ['Account Index Master'].ACTINDX
11CURNCYID SearchCurrency IDSTR15_Currency_IDString1615
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['SmartList Landed Cost ID'].CURNCYID AS 'SmartList Landed Cost ID-Currency ID'
       ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
       ASIEXP30 AS ['SmartList Landed Cost ID']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['SmartList Landed Cost ID'].CURNCYID = ['Currency Setup'].CURNCYID
12RATETPID SearchRate Type IDSTR15_Rate_Type_IDString1615
Key to the Multicurrency Rate Type Setup (MC40100).

Click to show/hide

SELECT
       ['SmartList Landed Cost ID'].RATETPID AS 'SmartList Landed Cost ID-Rate Type ID'
       ,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
       ASIEXP30 AS ['SmartList Landed Cost ID']
INNER JOIN
       MC40100 AS ['Multicurrency Rate Type Setup']
              ON
                     ['SmartList Landed Cost ID'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID
13ODECPLCU SearchOriginating Decimal Places CurrencyDDL_Decimal_Places_DollarsInteger20
14DECPLCUR SearchDecimal Places CurrencyDDL_Decimal_Places_DollarsInteger20
15Revalue_Inventory SearchRevalue InventoryCB_Revalue_InventoryBoolean20
16Tolerance_Percentage SearchTolerance PercentageLI7_U%3Long Integer47
17PURPVIDX SearchPurchase Price Variance IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['SmartList Landed Cost ID'].PURPVIDX AS 'SmartList Landed Cost ID-Purchase Price Variance Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ASIEXP30 AS ['SmartList Landed Cost ID']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['SmartList Landed Cost ID'].PURPVIDX = ['Account Index Master'].ACTINDX
18TXDETPCTAMT SearchTax Detail Percent/AmountSTR15String1615
azurecurveProductsSmartList (1493)PathnameSmartList Landed Cost ID (ASIEXP30)

Leave a Reply

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