SmartList Customer Items (ASIEXP24)

azurecurve Products SmartList (1493)PathnameSmartList Customer Items (ASIEXP24)

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

Display Name: SmartList Customer Items
Physical Name: ASIEXP24
Technical Name: ASI_Item_Customer_Explorer

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	ASI_Order_By	ASI_Order_By	Long Integer	LI_14	14
2	ITEMNMBR	Item Number	String	STR30_Item_Number	30
	Key to the Item Master (IV00101). Click to show/hide SELECT ['SmartList Customer Items'].ITEMNMBR AS 'SmartList Customer Items-Item Number' ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number' FROM ASIEXP24 AS ['SmartList Customer Items'] INNER JOIN IV00101 AS ['Item Master'] ON ['SmartList Customer Items'].ITEMNMBR = ['Item Master'].ITEMNMBR
3	CUSTNMBR	Customer Number	String	STR15_RM_Customer_Number	15
	Key to the RM Customer MSTR (RM00101). Click to show/hide SELECT ['SmartList Customer Items'].CUSTNMBR AS 'SmartList Customer Items-Customer Number' ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number' FROM ASIEXP24 AS ['SmartList Customer Items'] INNER JOIN RM00101 AS ['RM Customer MSTR'] ON ['SmartList Customer Items'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
4	ASICUSTITNO	ASI Customer Item Number	String	ASI_Customer_Item_Number	30
5	ASICUSTITDSC	ASI Customer Item Description	String	ASI_Customer_Item_Description	50
6	ASICUSTITSNM	ASI Customer Item Short Name	String	STR15	15
7	ASICUSTITGDSC	ASI Customer Item Generic Description	String	STR10	10
8	USERDEF1	User Defined 1	String	STR20	20
9	USERDEF2	User Defined 2	String	STR20	20
10	USRDEF03	User Defined 3	String	STR20	20
11	USRDEF04	User Defined 4	String	STR20	20
12	USRDEF05	User Defined 5	String	STR20	20
13	ASIUSERDEF1	ASI User Defined Key1	String	STR50	50
14	ASIUSERDEF2	ASI User Defined Key2	String	STR50	50
15	ASIUSERDEF3	ASI User Defined Key3	String	STR50	50
16	ASIUSERDEF4	ASI User Defined Key4	String	STR50	50
17	CUSTNAME	Customer Name	String	STR64_Customer_Name	64
18	CUSTCLAS	Customer Class	String	STR15_Customer_Class	15
19	CPRCSTNM	Corporate Customer Number	String	STR15_RM_Customer_Number	15
20	CNTCPRSN	Contact Person	String	STR60	60
21	STMTNAME	Statement Name	String	STR64	64
22	SHRTNAME	Short Name	String	STR15	15
23	ADRSCODE	Address Code	String	STR15_Address_Code	15
24	UPSZONE	UPS Zone	String	STR3	3
25	SHIPMTHD	Shipping Method	String	STR15_Shipping_Method	15
	Key to the Shipping Methods Master (SY03000). Click to show/hide SELECT ['SmartList Customer Items'].SHIPMTHD AS 'SmartList Customer Items-Shipping Method' ,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method' FROM ASIEXP24 AS ['SmartList Customer Items'] INNER JOIN SY03000 AS ['Shipping Methods Master'] ON ['SmartList Customer Items'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD
26	TAXSCHID	Tax Schedule ID	String	STR15_Tax_Schedule_ID	15
	Key to the Sales/Purchases Tax Schedule Header Master (TX00101). Click to show/hide SELECT ['SmartList Customer Items'].TAXSCHID AS 'SmartList Customer Items-Tax Schedule ID' ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID' FROM ASIEXP24 AS ['SmartList Customer Items'] INNER JOIN TX00101 AS ['Sales/Purchases Tax Schedule Header Master'] ON ['SmartList Customer Items'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
27	ADDRESS1	Address 1	String	STR60	60
28	ADDRESS2	Address 2	String	STR60	60
29	ADDRESS3	Address 3	String	STR60	60
30	COUNTRY	Country	String	STR60	60
31	CITY	City	String	STR35	35
32	STATE	State	String	STR30_State	29
33	ZIP	Zip	String	STR10	10
34	PHONE1	Phone 1	String	Phone_Number	14
35	PHONE2	Phone 2	String	Phone_Number	14
36	FAX	Fax	String	STR14_FAX	14
37	PRBTADCD	Primary Billto Address Code	String	STR15_LBAU	15
38	PRSTADCD	Primary Shipto Address Code	String	STR15_LBAU	15
39	STADDRCD	Statement Address Code	String	STR15_LBAU	15
40	SLPRSNID	Salesperson ID	String	STR15_Salesperson_ID	15
	Key to the RM Salesperson Master (RM00301). Click to show/hide SELECT ['SmartList Customer Items'].SLPRSNID AS 'SmartList Customer Items-Salesperson ID' ,['RM Salesperson Master'].SLPRSNID AS 'RM Salesperson Master-Salesperson ID' FROM ASIEXP24 AS ['SmartList Customer Items'] INNER JOIN RM00301 AS ['RM Salesperson Master'] ON ['SmartList Customer Items'].SLPRSNID = ['RM Salesperson Master'].SLPRSNID
41	CHEKBKID	Checkbook ID	String	STR15_Checkbook_ID	15
	Key to the CM Checkbook Master (CM00100). Click to show/hide SELECT ['SmartList Customer Items'].CHEKBKID AS 'SmartList Customer Items-Checkbook ID' ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID' FROM ASIEXP24 AS ['SmartList Customer Items'] INNER JOIN CM00100 AS ['CM Checkbook Master'] ON ['SmartList Customer Items'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID
42	PYMTRMID	Payment Terms ID	String	STR20_Payment_Terms_ID	20
	Key to the Payment Terms Master (SY03300). Click to show/hide SELECT ['SmartList Customer Items'].PYMTRMID AS 'SmartList Customer Items-Payment Terms ID' ,['Payment Terms Master'].PYMTRMID AS 'Payment Terms Master-Payment Terms ID' FROM ASIEXP24 AS ['SmartList Customer Items'] INNER JOIN SY03300 AS ['Payment Terms Master'] ON ['SmartList Customer Items'].PYMTRMID = ['Payment Terms Master'].PYMTRMID
43	CRLMTTYP	Credit Limit Type	Integer	GB_Amt_Type	0
44	CRLMTAMT	Credit Limit Amount	Currency	DLR17_RBS0_UTR$	17
45	CRLMTPER	Credit Limit Period	Integer	DDL	0
46	CRLMTPAM	Credit Limit Period Amount	Currency	DLR17_RBS0_UTR$	17
47	CURNCYID	Currency ID	String	STR15_Currency_ID	15
	Key to the Currency Setup (MC40200). Click to show/hide SELECT ['SmartList Customer Items'].CURNCYID AS 'SmartList Customer Items-Currency ID' ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID' FROM ASIEXP24 AS ['SmartList Customer Items'] INNER JOIN DYNAMICS..MC40200 AS ['Currency Setup'] ON ['SmartList Customer Items'].CURNCYID = ['Currency Setup'].CURNCYID
48	RATETPID	Rate Type ID	String	STR15_Rate_Type_ID	15
	Key to the Multicurrency Rate Type Setup (MC40100). Click to show/hide SELECT ['SmartList Customer Items'].RATETPID AS 'SmartList Customer Items-Rate Type ID' ,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID' FROM ASIEXP24 AS ['SmartList Customer Items'] INNER JOIN MC40100 AS ['Multicurrency Rate Type Setup'] ON ['SmartList Customer Items'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID
49	CUSTDISC	Customer Discount	Integer	INT5_%2	5
50	PRCLEVEL	PriceLevel	String	STR10_LBAU	10
51	MINPYTYP	Minimum Payment Type	Integer	GB_Amt_Type	0
52	MINPYDLR	Minimum Payment Dollar	Currency	DLR17_RBS0_UTR$	17
53	MINPYPCT	Minimum Payment Percent	Integer	INT5_%2	5
54	FNCHATYP	Finance Charge Amt Type	Integer	GB_Amt_Type	0
55	FNCHPCNT	Finance Charge Percent	Integer	INT5_%2	5
56	FINCHDLR	Finance Charge Dollar	Currency	DLR17_RBS0_UTR$	17
57	MXWOFTYP	Maximum Writeoff Type	Integer	GP_Max_Writeoff	0
58	MXWROFAM	Max Writeoff Amount	Currency	DLR17_RBS0_UTR$	17
59	COMMENT1	Comment1	String	STR30	30
60	COMMENT2	Comment2	String	STR30	30
61	USERDEF11	ASI_User_Defined_1	String	STR20	20
62	USERDEF21	ASI_User_Defined_2	String	STR20	20
63	TAXEXMT1	Tax Exempt 1	String	STR25	25
64	TAXEXMT2	Tax Exempt 2	String	STR25	25
65	TXRGNNUM	Tax Registration Number	String	STR25	25
66	BALNCTYP	Balance Type	Integer	GB_Bal_Type	0
67	STMTCYCL	Statement Cycle	Integer	DDL_Stmt_Cycle	0
68	BANKNAME	Bank Name	String	STR30	30
69	BNKBRNCH	Bank Branch	String	STR20	20
70	SALSTERR	Sales Territory	String	STR15_Sales_Territory	15
	Key to the Sales Territory Master File (RM00303). Click to show/hide SELECT ['SmartList Customer Items'].SALSTERR AS 'SmartList Customer Items-Sales Territory' ,['Sales Territory Master File'].SALSTERR AS 'Sales Territory Master File-Sales Territory' FROM ASIEXP24 AS ['SmartList Customer Items'] INNER JOIN RM00303 AS ['Sales Territory Master File'] ON ['SmartList Customer Items'].SALSTERR = ['Sales Territory Master File'].SALSTERR
71	DEFCACTY	Default Cash Account Type	Integer	GB	0
72	RMCSHACC	RM Cash Account Index	Long Integer	LI_14	14
73	RMARACC	RM AR Account Index	Long Integer	LI_14	14
74	RMSLSACC	RM Sales Account Index	Long Integer	LI_14	14
75	RMIVACC	RM IV Account Index	Long Integer	LI_14	14
76	RMCOSACC	RM Cost Of Sales Account Index	Long Integer	LI_14	14
77	RMTAKACC	RM Discounts Taken Account Index	Long Integer	LI_14	14
78	RMAVACC	RM Discounts Avail Account Index	Long Integer	LI_14	14
79	RMFCGACC	RM Finance Charge Account Index	Long Integer	LI_14	14
80	RMWRACC	RM Writeoff Account Index	Long Integer	LI_14	14
81	FRSTINDT	First Invoice Date	Date	DT_Date	6
82	INACTIVE	Inactive	Boolean	CB_Inactive	0
83	HOLD	Hold	Boolean	CB_Hold	0
84	CRCARDID	Credit Card ID	String	STR15	15
85	CRCRDNUM	Credit Card Number	String	STR20	20
86	CCRDXPDT	Credit Card Exp Date	Date	DT_Date	6
87	KPDSTHST	Keep Distribution History	Boolean	CB_Keep_Dist_History	0
88	KPCALHST	Keep Calendar History	Boolean	CB_Keep_Calendar_History	0
89	KPERHIST	Keep Period History	Boolean	CB_Keep_Period_History	0
90	KPTRXHST	Keep Trx History	Boolean	CB_Keep_Trx_History	0
91	NOTEINDX	Note Index	Currency	DLR14	14
	Key to the Record Notes Master (SY03900). Click to show/hide SELECT ['SmartList Customer Items'].NOTEINDX AS 'SmartList Customer Items-Note Index' ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index' FROM ASIEXP24 AS ['SmartList Customer Items'] INNER JOIN SY03900 AS ['Record Notes Master'] ON ['SmartList Customer Items'].NOTEINDX = ['Record Notes Master'].NOTEINDX
92	CREATDDT	Created Date	Date	DT	8
93	MODIFDT	Modified Date	Date	DT	8
94	ASI_Favorite_Sequence	ASI_Favorite_Sequence	Long Integer	ASI_LI_10_RU	10
95	TNSFCLIF	Total Amount Of NSF Checks Life	Currency	DLR19_RBS0_STR$	19
96	NONSFLIF	Number Of NSF Checks Life	Long Integer	LI6_U0	6
97	CUSTBLNC	Customer Balance	Currency	DLR19_RBS0_STR$	19
98	AGPERAMT_1	Aging Period Amounts[1]	Currency	DLR17_RBSO_STR$	17
99	AGPERAMT_2	Aging Period Amounts[2]	Currency	DLR17_RBSO_STR$	17
100	AGPERAMT_3	Aging Period Amounts[3]	Currency	DLR17_RBSO_STR$	17
101	AGPERAMT_4	Aging Period Amounts[4]	Currency	DLR17_RBSO_STR$	17
102	AGPERAMT_5	Aging Period Amounts[5]	Currency	DLR17_RBSO_STR$	17
103	AGPERAMT_6	Aging Period Amounts[6]	Currency	DLR17_RBSO_STR$	17
104	AGPERAMT_7	Aging Period Amounts[7]	Currency	DLR17_RBSO_STR$	17
105	LASTAGED	Last Aged	Date	DATE	6
106	LSTNSFCD	Last NSF Check Date	Date	DT_Date	6
107	LPYMTAMT	Last Payment Amount	Currency	DLR17_RBS0_STR$	17
108	LASTPYDT	Last Payment Date	Date	DT_Date	6
109	LSTTRXDT	Last Transaction Date	Date	DT_Date	6
110	LSTTRXAM	Last Transaction Amount	Currency	DLR17_RBS0_STR$	17
111	LSTFCHAM	Last Finance Charge Amount	Currency	DLR19_RBS0_STR$	19
112	UPFCHYTD	Unpaid Finance Charges YTD	Currency	DLR17_RBS0_UTR$	17
113	AVDTPLYR	Average Days to Pay - LYR	Integer	INT3_U0	3
114	AVDTPLIF	Average Days To Pay - Life	Integer	INT3_U0	3
115	AVGDTPYR	Average Days To Pay - Year	Integer	INT3_U0	3
116	NUMADTPL	Number ADTP Documents - Life	Long Integer	Long_10U	10
117	NUMADTPY	Number ADTP Documents - Year	Long Integer	Long_10U	10
118	NUMADTPR	Number ADTP Documents - LYR	Long Integer	Long_10U	10
119	TDTKNYTD	Total Discounts Taken YTD	Currency	DLR19_RBS0_STR$	19
120	TDTKNLYR	Total Discounts Taken LYR	Currency	DLR19_RBS0_STR$	19
121	TDTKNLTD	Total Discounts Taken LTD	Currency	DLR19_RBS0_STR$	19
122	TDISAYTD	Total Discounts Available YTD	Currency	DLR19_RBS0_STR$	19
123	RETAINAG	Retainage	Currency	DLR19_RBS0_STR$	19
124	TNSFCYTD	Total Amount Of NSF Checks YTD	Currency	DLR19_RBS0_STR$	19
125	NONSFYTD	Number Of NSF Checks YTD	Long Integer	LI6_U0	6
126	UNPSTDSA	Unposted Sales Amount	Currency	DLR19_RBS0_UTR$	19
127	UNPSTDCA	Unposted Cash Amount	Currency	DLR19_RBS0_UTR$	19
128	UNPSTOSA	Unposted Other Sales Amount	Currency	DLR19_RBS0_UTR$	19
129	UNPSTOCA	Unposted Other Cash Amount	Currency	DLR19_RBS0_UTR$	19
130	NCSCHPMT	Non Current Scheduled Payments	Currency	DLR19_RBS0_STR$	19
131	TTLSLYTD	Total Sales YTD	Currency	DLR19_RBS0_STR$	19
132	TTLSLLTD	Total Sales LTD	Currency	DLR19_RBS0_STR$	19
133	TTLSLLYR	Total Sales LYR	Currency	DLR19_RBS0_STR$	19
134	TCOSTYTD	Total Costs YTD	Currency	DLR19_RBS0_STR$	19
135	TCOSTLTD	Total Costs LTD	Currency	DLR19_RBS0_STR$	19
136	TCOSTLYR	Total Costs LYR	Currency	DLR19_RBS0_STR$	19
137	TCSHRYTD	Total Cash Received YTD	Currency	DLR19_RBS0_STR$	19
138	TCSHRLTD	Total Cash Received LTD	Currency	DLR19_RBS0_STR$	19
139	TCSHRLYR	Total Cash Received LYR	Currency	DLR19_RBS0_STR$	19
140	TFNCHYTD	Total Finance Charges YTD	Currency	DLR19_RBS0_STR$	19
141	TFNCHLTD	Total Finance Charges LTD	Currency	DLR19_RBS0_STR$	19
142	TFNCHLYR	Total Finance Charges LYR	Currency	DLR19_RBS0_STR$	19
143	FNCHCYTD	Finance Charges CYTD	Currency	DLR19_RBS0_STR$	19
144	FNCHLYRC	Finance Charges LYR Calendar	Currency	DLR19_RBS0_STR$	19
145	TBDDTYTD	Total Bad Debt YTD	Currency	DLR19_RBS0_STR$	19
146	TBDDTLYR	Total Bad Deb LYR	Currency	DLR19_RBS0_STR$	19
147	TBDDTLTD	Total Bad Debt LTD	Currency	DLR19_RBS0_STR$	19
148	TWVFCYTD	Total Waived FC YTD	Currency	DLR19_RBS0_STR$	19
149	TWVFCLTD	Total Waived FC LTD	Currency	DLR19_RBS0_STR$	19
150	TWVFCLYR	Total Waived FC LYR	Currency	DLR19_RBS0_STR$	19
151	TWROFYTD	Total Writeoffs YTD	Currency	DLR19_RBS0_STR$	19
152	TWROFLTD	Total Writeoffs LTD	Currency	DLR19_RBS0_STR$	19
153	TWROFLYR	Total Writeoffs LYR	Currency	DLR19_RBS0_STR$	19
154	TTLINYTD	Total # Invoices YTD	Long Integer	LI6_U0	6
155	TTLINLTD	Total # Invoices LTD	Long Integer	LI6_U0	6
156	TTLINLYR	Total # Invoices LYR	Long Integer	LI6_U0	6
157	TTLFCYTD	Total # FC YTD	Long Integer	LI6_U0	6
158	TTLFCLTD	Total # FC LTD	Long Integer	LI6_U0	6
159	TTLFCLYR	Total # FC LYR	Long Integer	LI6_U0	6
160	WROFSLIF	Write Offs LIFE	Currency	DLR19_RBS0_STR$	19
161	WROFSLYR	Write Offs LYR	Currency	DLR19_RBS0_STR$	19
162	WROFSYTD	Write Offs YTD	Currency	DLR19_RBS0_STR$	19
163	HIBALLYR	High Balance LYR	Currency	DLR19_RBSO_STR$	19
164	HIBALYTD	High Balance YTD	Currency	DLR19_RBSO_STR$	19
165	HIBALLTD	High Balance LTD	Currency	DLR19_RBSO_STR$	19
166	LASTSTDT	Last Statement Date	Date	DATE	6
167	LSTSTAMT	Last Statement Amount	Currency	DLR17_RBS0_STR$	17
168	DEPRECV	Deposits Received	Currency	DLR19_RBS0_STR$	19
169	ONORDAMT	On Order Amount	Currency	DLR19_RBS0_UTR$	19
170	Revalue_Customer	Revalue Customer	Boolean	CB Revalue Customer	0
171	Post_Results_To	Post Results To	Integer	GB	0
172	FINCHID	Finance Charge ID	String	STR15_Charge_ID	15
173	GOVCRPID	Governmental Corporate ID	String	STR30_Gov_Corp_ID	30
174	GOVINDID	Governmental Individual ID	String	STR30_Gov_Indiv_ID	30
175	DISGRPER	Discount Grace Period	Integer	INT2_U0	2
176	DOCFMTID	Document Format ID	String	STR15_LBU	15
177	DUEGRPER	Due Date Grace Period	Integer	INT2_U0	2
178	PHONE3	Phone 3	String	Phone_Number3	14
179	TTLRTLTD	Total Returns LTD	Currency	DLR19_RBS0_STR$	19
180	TTLRTLYR	Total Returns LYR	Currency	DLR19_RBS0_STR$	19
181	TTLRTYTD	Total Returns YTD	Currency	DLR19_RBS0_STR$	19
182	ITEMDESC	Item Description	String	STR100	100
183	NOTEINDX1	ASI_Note_Index	Currency	DLR14	14
184	ITMSHNAM	Item Short Name	String	STR15	15
185	ITEMTYPE	Item Type	Integer	DDL_Item_Type	0
186	ITMGEDSC	Item Generic Description	String	STR10	10
187	STNDCOST	Standard Cost	Currency	DLR17_RBS0_UTR$	17
188	CURRCOST	Current Cost	Currency	DLR17_RBS0_UTR$	17
189	ITEMSHWT	Item Shipping Weight	Long Integer	LI6_RBS2_UT	6
190	DECPLQTY	Decimal Places QTYS	Integer	DDL_Decimal_Places_QTYS	0
191	DECPLCUR	Decimal Places Currency	Integer	DDL_Decimal_Places_Dollars	0
192	ITMTSHID	Item Tax Schedule ID	String	STR15_LBAU	15
	Key to the Sales/Purchases Tax Schedule Header Master (TX00101). Click to show/hide SELECT ['SmartList Customer Items'].ITMTSHID AS 'SmartList Customer Items-Item Tax Schedule ID' ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID' FROM ASIEXP24 AS ['SmartList Customer Items'] INNER JOIN TX00101 AS ['Sales/Purchases Tax Schedule Header Master'] ON ['SmartList Customer Items'].ITMTSHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
193	TAXOPTNS	Tax Options	Integer	DDL_Tax_Options	0
194	IVIVINDX	IV IV Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['SmartList Customer Items'].IVIVINDX AS 'SmartList Customer Items-IV IV Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM ASIEXP24 AS ['SmartList Customer Items'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['SmartList Customer Items'].IVIVINDX = ['Account Index Master'].ACTINDX
195	IVIVOFIX	IV IV Offset Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['SmartList Customer Items'].IVIVOFIX AS 'SmartList Customer Items-IV IV Offset Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM ASIEXP24 AS ['SmartList Customer Items'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['SmartList Customer Items'].IVIVOFIX = ['Account Index Master'].ACTINDX
196	IVCOGSIX	IV COGS Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['SmartList Customer Items'].IVCOGSIX AS 'SmartList Customer Items-IV COGS Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM ASIEXP24 AS ['SmartList Customer Items'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['SmartList Customer Items'].IVCOGSIX = ['Account Index Master'].ACTINDX
197	IVSLSIDX	IV Sales Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['SmartList Customer Items'].IVSLSIDX AS 'SmartList Customer Items-IV Sales Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM ASIEXP24 AS ['SmartList Customer Items'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['SmartList Customer Items'].IVSLSIDX = ['Account Index Master'].ACTINDX
198	IVSLDSIX	IV Sales Discounts Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['SmartList Customer Items'].IVSLDSIX AS 'SmartList Customer Items-IV Sales Discounts Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM ASIEXP24 AS ['SmartList Customer Items'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['SmartList Customer Items'].IVSLDSIX = ['Account Index Master'].ACTINDX
199	IVSLRNIX	IV Sales Returns Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['SmartList Customer Items'].IVSLRNIX AS 'SmartList Customer Items-IV Sales Returns Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM ASIEXP24 AS ['SmartList Customer Items'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['SmartList Customer Items'].IVSLRNIX = ['Account Index Master'].ACTINDX
200	IVINUSIX	IV In Use Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['SmartList Customer Items'].IVINUSIX AS 'SmartList Customer Items-IV In Use Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM ASIEXP24 AS ['SmartList Customer Items'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['SmartList Customer Items'].IVINUSIX = ['Account Index Master'].ACTINDX
201	IVINSVIX	IV In Service Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['SmartList Customer Items'].IVINSVIX AS 'SmartList Customer Items-IV In Service Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM ASIEXP24 AS ['SmartList Customer Items'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['SmartList Customer Items'].IVINSVIX = ['Account Index Master'].ACTINDX
202	IVDMGIDX	IV Damaged Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['SmartList Customer Items'].IVDMGIDX AS 'SmartList Customer Items-IV Damaged Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM ASIEXP24 AS ['SmartList Customer Items'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['SmartList Customer Items'].IVDMGIDX = ['Account Index Master'].ACTINDX
203	IVVARIDX	IV Variances Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['SmartList Customer Items'].IVVARIDX AS 'SmartList Customer Items-IV Variances Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM ASIEXP24 AS ['SmartList Customer Items'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['SmartList Customer Items'].IVVARIDX = ['Account Index Master'].ACTINDX
204	DPSHPIDX	Drop Ship Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['SmartList Customer Items'].DPSHPIDX AS 'SmartList Customer Items-Drop Ship Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM ASIEXP24 AS ['SmartList Customer Items'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['SmartList Customer Items'].DPSHPIDX = ['Account Index Master'].ACTINDX
205	PURPVIDX	Purchase Price Variance Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['SmartList Customer Items'].PURPVIDX AS 'SmartList Customer Items-Purchase Price Variance Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM ASIEXP24 AS ['SmartList Customer Items'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['SmartList Customer Items'].PURPVIDX = ['Account Index Master'].ACTINDX
206	UPPVIDX	Unrealized Purchase Price Variance Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['SmartList Customer Items'].UPPVIDX AS 'SmartList Customer Items-Unrealized Purchase Price Variance Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM ASIEXP24 AS ['SmartList Customer Items'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['SmartList Customer Items'].UPPVIDX = ['Account Index Master'].ACTINDX
207	IVRETIDX	Inventory Returns Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['SmartList Customer Items'].IVRETIDX AS 'SmartList Customer Items-Inventory Returns Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM ASIEXP24 AS ['SmartList Customer Items'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['SmartList Customer Items'].IVRETIDX = ['Account Index Master'].ACTINDX
208	ASMVRIDX	Assembly Variance Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['SmartList Customer Items'].ASMVRIDX AS 'SmartList Customer Items-Assembly Variance Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM ASIEXP24 AS ['SmartList Customer Items'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['SmartList Customer Items'].ASMVRIDX = ['Account Index Master'].ACTINDX
209	ITMCLSCD	Item Class Code	String	STR10_Class_ID	10
	Key to the Item Class Setup (IV40400). Click to show/hide SELECT ['SmartList Customer Items'].ITMCLSCD AS 'SmartList Customer Items-Item Class Code' ,['Item Class Setup'].ITMCLSCD AS 'Item Class Setup-Item Class Code' FROM ASIEXP24 AS ['SmartList Customer Items'] INNER JOIN IV40400 AS ['Item Class Setup'] ON ['SmartList Customer Items'].ITMCLSCD = ['Item Class Setup'].ITMCLSCD
210	ITMTRKOP	Item Tracking Option	Integer	DDL_Track	0
211	LOTTYPE	Lot Type	String	STR10_Lot_Type	10
212	KPERHIST1	ASI_Keep_Period_History	Boolean	CB_Keep_Period_History	0
213	KPTRXHST1	ASI_Keep_Trx_History	Boolean	CB_Keep_Trx_History	0
214	KPCALHST1	ASI_Keep_Calendar_History	Boolean	CB_Keep_Calendar_History	0
215	KPDSTHST1	ASI_Keep_Distribution_History	Boolean	CB_Keep_Dist_History	0
216	ALWBKORD	Allow Back Orders	Boolean	CB_Allow_Back_Orders	0
217	VCTNMTHD	Valuation Method	Integer	DDL_Valuation_Method	0
218	UOMSCHDL	U Of M Schedule	String	STR10_Schedule	10
	Key to the Inventory U of M Schedule Setup (IV40201). Click to show/hide SELECT ['SmartList Customer Items'].UOMSCHDL AS 'SmartList Customer Items-U Of M Schedule' ,['Inventory U of M Schedule Setup'].UOMSCHDL AS 'Inventory U of M Schedule Setup-U Of M Schedule' FROM ASIEXP24 AS ['SmartList Customer Items'] INNER JOIN IV40201 AS ['Inventory U of M Schedule Setup'] ON ['SmartList Customer Items'].UOMSCHDL = ['Inventory U of M Schedule Setup'].UOMSCHDL
219	ALTITEM1	Alternate Item 1	String	STR30_Item_Number	30
220	ALTITEM2	Alternate Item 2	String	STR30_Item_Number	30
221	USCATVLS_1	User Category Values[1]	String	User_Category_Value	10
222	USCATVLS_2	User Category Values[2]	String	User_Category_Value	10
223	USCATVLS_3	User Category Values[3]	String	User_Category_Value	10
224	USCATVLS_4	User Category Values[4]	String	User_Category_Value	10
225	USCATVLS_5	User Category Values[5]	String	User_Category_Value	10
226	USCATVLS_6	User Category Values[6]	String	User_Category_Value	10
227	MSTRCDTY	Master Record Type	Integer	INT1	1
228	MODIFDT1	ASI_Modified_Date	Date	DT	8
229	CREATDDT1	ASI_Created_Date	Date	DT	8
230	WRNTYDYS	Warranty Days	Integer	INT4	4
231	PRCLEVEL1	ASI_PriceLevel	String	STR10_LBAU	10
232	LOCNCODE	Location Code	String	STR10_Location_Code	10
	Key to the Site Setup (IV40700). Click to show/hide SELECT ['SmartList Customer Items'].LOCNCODE AS 'SmartList Customer Items-Location Code' ,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code' FROM ASIEXP24 AS ['SmartList Customer Items'] INNER JOIN IV40700 AS ['Site Setup'] ON ['SmartList Customer Items'].LOCNCODE = ['Site Setup'].LOCNCODE
233	PINFLIDX	Purch Inflation Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['SmartList Customer Items'].PINFLIDX AS 'SmartList Customer Items-Purch Inflation Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM ASIEXP24 AS ['SmartList Customer Items'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['SmartList Customer Items'].PINFLIDX = ['Account Index Master'].ACTINDX
234	PURMCIDX	Purch Monetary Correction Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['SmartList Customer Items'].PURMCIDX AS 'SmartList Customer Items-Purch Monetary Correction Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM ASIEXP24 AS ['SmartList Customer Items'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['SmartList Customer Items'].PURMCIDX = ['Account Index Master'].ACTINDX
235	IVINFIDX	Inventory Inflation Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['SmartList Customer Items'].IVINFIDX AS 'SmartList Customer Items-Inventory Inflation Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM ASIEXP24 AS ['SmartList Customer Items'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['SmartList Customer Items'].IVINFIDX = ['Account Index Master'].ACTINDX
236	INVMCIDX	Inventory Monetary Correction Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['SmartList Customer Items'].INVMCIDX AS 'SmartList Customer Items-Inventory Monetary Correction Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM ASIEXP24 AS ['SmartList Customer Items'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['SmartList Customer Items'].INVMCIDX = ['Account Index Master'].ACTINDX
237	CGSINFLX	COGS Inflation Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['SmartList Customer Items'].CGSINFLX AS 'SmartList Customer Items-COGS Inflation Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM ASIEXP24 AS ['SmartList Customer Items'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['SmartList Customer Items'].CGSINFLX = ['Account Index Master'].ACTINDX
238	CGSMCIDX	COGS Monetary Correction Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['SmartList Customer Items'].CGSMCIDX AS 'SmartList Customer Items-COGS Monetary Correction Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM ASIEXP24 AS ['SmartList Customer Items'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['SmartList Customer Items'].CGSMCIDX = ['Account Index Master'].ACTINDX
239	ITEMCODE	Item Code	String	STR15	15
240	TCC	Tax Commodity Code	String	STR30_VAT	30
241	PriceGroup	Price Group	String	STR10_LBAU	10
242	PRICMTHD	Price Method	Integer	DDL_Price_Method	0
243	PRCHSUOM	Purchasing U Of M	String	U_Of_M	8
244	SELNGUOM	Selling U Of M	String	U_Of_M	8
245	KTACCTSR	Kit COGS Account Source	Integer	GB	0
246	LASTGENSN	Last Generated Serial Number	String	STR20_LBAU	20
247	ABCCODE	ABC Code	Integer	DDL_ABC_Code	0
248	STR30	STR30	String	STR30	30
249	ORDERFULFILLDEFAULT	Order Fulfillment Shortage Default	Integer	DDL_OrderFulfillDefault	0
250	CUSTPRIORITY	Customer Priority	Integer	DDL_CustomerPriority	0
251	SUBITEMNMBR	Substitute Item Number	String	STR30_Item_Number	30

azurecurve Products SmartList (1493)PathnameSmartList Customer Items (ASIEXP24)

Leave a Reply Cancel reply