SmartList Landed Cost ID (ASIEXP30)

azurecurve Products SmartList (1493)PathnameSmartList Landed Cost ID (ASIEXP30)

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

Display Name: SmartList Landed Cost ID
Physical Name: ASIEXP30
Technical Name: ASI_IV_Landed_Cost_ID_Explorer

Seq 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	Landed_Cost_ID	Landed Cost ID	String	STR15_LBAU	15
4	Long_Description	Long Description	String	STR50	50
5	VENDORID	Vendor ID	String	STR_15_Vendor_ID	15
	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
6	CALCMTHD	Calculation Method	Integer	Calculation_Method	0
7	Orig_Landed_Cost_Amount	Originating Landed Cost Amount	Currency	DLR17_RBS0_UTR$	17
8	Calculation_Percentage	Calculation Percentage	Long Integer	LI6_U%3	6
9	Invoice_Match	Invoice Match	Boolean	CB_Invoice_Match	0
10	ACPURIDX	Accrued Purchases Index	Long Integer	LI_14	14
	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
11	CURNCYID	Currency ID	String	STR15_Currency_ID	15
	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
12	RATETPID	Rate Type ID	String	STR15_Rate_Type_ID	15
	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
13	ODECPLCU	Originating Decimal Places Currency	Integer	DDL_Decimal_Places_Dollars	0
14	DECPLCUR	Decimal Places Currency	Integer	DDL_Decimal_Places_Dollars	0
15	Revalue_Inventory	Revalue Inventory	Boolean	CB_Revalue_Inventory	0
16	Tolerance_Percentage	Tolerance Percentage	Long Integer	LI7_U%3	7
17	PURPVIDX	Purchase Price Variance Index	Long Integer	LI_14	14
	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
18	TXDETPCTAMT	Tax Detail Percent/Amount	String	STR15	15

azurecurve Products SmartList (1493)PathnameSmartList Landed Cost ID (ASIEXP30)

Click to show/hide

Click to show/hide

Click to show/hide

Click to show/hide

Click to show/hide

Leave a Reply Cancel reply