SmartList Landed Cost Group ID (ASIEXP31)

azurecurveProductsSmartList (1493)PathnameSmartList Landed Cost Group ID (ASIEXP31)

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

Product: SmartList (1493)
Series: Pathname

Display Name: SmartList Landed Cost Group ID
Physical Name: ASIEXP31
Technical Name: ASI_IV_Landed_Cost_Group_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_Group_ID SearchLanded Cost Group IDSTR15_LBAUString1615
4Long_Description SearchLong DescriptionSTR50String5250
5Landed_Cost_ID SearchLanded Cost IDSTR15_LBAUString1615
6Long_Description2 SearchASI_Long Description2STR50String5250
7VENDORID SearchVendor IDSTR_15_Vendor_IDString1615
Key to the PM Vendor Master File (PM00200).

Click to show/hide

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

Click to show/hide

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

Click to show/hide

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

Click to show/hide

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

Click to show/hide

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

Leave a Reply

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