SmartList RM Customer MSTR (ASIEXP02)

azurecurve Products SmartList (1493)PathnameSmartList RM Customer MSTR (ASIEXP02)

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

Display Name: SmartList RM Customer MSTR
Physical Name: ASIEXP02
Technical Name: ASI_RM_Customer_MSTR_Explorer

Group Display Name: SmartList Master
Group Technical Name: ASI_Explorer_Logical_MSTR

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	CUSTNMBR	Customer Number	String	STR15_RM_Customer_Number	15
	Key to the RM Customer MSTR (RM00101). Click to show/hide SELECT ['SmartList RM Customer MSTR'].CUSTNMBR AS 'SmartList RM Customer MSTR-Customer Number' ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number' FROM ASIEXP02 AS ['SmartList RM Customer MSTR'] INNER JOIN RM00101 AS ['RM Customer MSTR'] ON ['SmartList RM Customer MSTR'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
3	CUSTNAME	Customer Name	String	STR64_Customer_Name	64
4	CUSTCLAS	Customer Class	String	STR15_Customer_Class	15
5	CPRCSTNM	Corporate Customer Number	String	STR15_RM_Customer_Number	15
6	CNTCPRSN	Contact Person	String	STR60	60
7	STMTNAME	Statement Name	String	STR64	64
8	SHRTNAME	Short Name	String	STR15	15
9	ADRSCODE	Address Code	String	STR15_Address_Code	15
10	UPSZONE	UPS Zone	String	STR3	3
11	SHIPMTHD	Shipping Method	String	STR15_Shipping_Method	15
	Key to the Shipping Methods Master (SY03000). Click to show/hide SELECT ['SmartList RM Customer MSTR'].SHIPMTHD AS 'SmartList RM Customer MSTR-Shipping Method' ,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method' FROM ASIEXP02 AS ['SmartList RM Customer MSTR'] INNER JOIN SY03000 AS ['Shipping Methods Master'] ON ['SmartList RM Customer MSTR'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD
12	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 RM Customer MSTR'].TAXSCHID AS 'SmartList RM Customer MSTR-Tax Schedule ID' ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID' FROM ASIEXP02 AS ['SmartList RM Customer MSTR'] INNER JOIN TX00101 AS ['Sales/Purchases Tax Schedule Header Master'] ON ['SmartList RM Customer MSTR'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
13	ADDRESS1	Address 1	String	STR60	60
14	ADDRESS2	Address 2	String	STR60	60
15	ADDRESS3	Address 3	String	STR60	60
16	COUNTRY	Country	String	STR60	60
17	CITY	City	String	STR35	35
18	STATE	State	String	STR30_State	29
19	ZIP	Zip	String	STR10	10
20	PHONE1	Phone 1	String	Phone_Number	14
21	PHONE2	Phone 2	String	Phone_Number	14
22	FAX	Fax	String	STR14_FAX	14
23	PRBTADCD	Primary Billto Address Code	String	STR15_LBAU	15
24	PRSTADCD	Primary Shipto Address Code	String	STR15_LBAU	15
25	STADDRCD	Statement Address Code	String	STR15_LBAU	15
26	SLPRSNID	Salesperson ID	String	STR15_Salesperson_ID	15
	Key to the RM Salesperson Master (RM00301). Click to show/hide SELECT ['SmartList RM Customer MSTR'].SLPRSNID AS 'SmartList RM Customer MSTR-Salesperson ID' ,['RM Salesperson Master'].SLPRSNID AS 'RM Salesperson Master-Salesperson ID' FROM ASIEXP02 AS ['SmartList RM Customer MSTR'] INNER JOIN RM00301 AS ['RM Salesperson Master'] ON ['SmartList RM Customer MSTR'].SLPRSNID = ['RM Salesperson Master'].SLPRSNID
27	CHEKBKID	Checkbook ID	String	STR15_Checkbook_ID	15
	Key to the CM Checkbook Master (CM00100). Click to show/hide SELECT ['SmartList RM Customer MSTR'].CHEKBKID AS 'SmartList RM Customer MSTR-Checkbook ID' ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID' FROM ASIEXP02 AS ['SmartList RM Customer MSTR'] INNER JOIN CM00100 AS ['CM Checkbook Master'] ON ['SmartList RM Customer MSTR'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID
28	PYMTRMID	Payment Terms ID	String	STR20_Payment_Terms_ID	20
	Key to the Payment Terms Master (SY03300). Click to show/hide SELECT ['SmartList RM Customer MSTR'].PYMTRMID AS 'SmartList RM Customer MSTR-Payment Terms ID' ,['Payment Terms Master'].PYMTRMID AS 'Payment Terms Master-Payment Terms ID' FROM ASIEXP02 AS ['SmartList RM Customer MSTR'] INNER JOIN SY03300 AS ['Payment Terms Master'] ON ['SmartList RM Customer MSTR'].PYMTRMID = ['Payment Terms Master'].PYMTRMID
29	CRLMTTYP	Credit Limit Type	Integer	GB_Amt_Type	0
30	CRLMTAMT	Credit Limit Amount	Currency	DLR17_RBS0_UTR$	17
31	CRLMTPER	Credit Limit Period	Integer	DDL	0
32	CRLMTPAM	Credit Limit Period Amount	Currency	DLR17_RBS0_UTR$	17
33	CURNCYID	Currency ID	String	STR15_Currency_ID	15
	Key to the Currency Setup (MC40200). Click to show/hide SELECT ['SmartList RM Customer MSTR'].CURNCYID AS 'SmartList RM Customer MSTR-Currency ID' ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID' FROM ASIEXP02 AS ['SmartList RM Customer MSTR'] INNER JOIN DYNAMICS..MC40200 AS ['Currency Setup'] ON ['SmartList RM Customer MSTR'].CURNCYID = ['Currency Setup'].CURNCYID
34	RATETPID	Rate Type ID	String	STR15_Rate_Type_ID	15
	Key to the Multicurrency Rate Type Setup (MC40100). Click to show/hide SELECT ['SmartList RM Customer MSTR'].RATETPID AS 'SmartList RM Customer MSTR-Rate Type ID' ,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID' FROM ASIEXP02 AS ['SmartList RM Customer MSTR'] INNER JOIN MC40100 AS ['Multicurrency Rate Type Setup'] ON ['SmartList RM Customer MSTR'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID
35	CUSTDISC	Customer Discount	Integer	INT5_%2	5
36	PRCLEVEL	PriceLevel	String	STR10_LBAU	10
37	MINPYTYP	Minimum Payment Type	Integer	GB_Amt_Type	0
38	MINPYDLR	Minimum Payment Dollar	Currency	DLR17_RBS0_UTR$	17
39	MINPYPCT	Minimum Payment Percent	Integer	INT5_%2	5
40	FNCHATYP	Finance Charge Amt Type	Integer	GB_Amt_Type	0
41	FNCHPCNT	Finance Charge Percent	Integer	INT5_%2	5
42	FINCHDLR	Finance Charge Dollar	Currency	DLR17_RBS0_UTR$	17
43	MXWOFTYP	Maximum Writeoff Type	Integer	GP_Max_Writeoff	0
44	MXWROFAM	Max Writeoff Amount	Currency	DLR17_RBS0_UTR$	17
45	COMMENT1	Comment1	String	STR30	30
46	COMMENT2	Comment2	String	STR30	30
47	USERDEF1	User Defined 1	String	STR20	20
48	USERDEF2	User Defined 2	String	STR20	20
49	TAXEXMT1	Tax Exempt 1	String	STR25	25
50	TAXEXMT2	Tax Exempt 2	String	STR25	25
51	TXRGNNUM	Tax Registration Number	String	STR25	25
52	BALNCTYP	Balance Type	Integer	GB_Bal_Type	0
53	STMTCYCL	Statement Cycle	Integer	DDL_Stmt_Cycle	0
54	BANKNAME	Bank Name	String	STR30	30
55	BNKBRNCH	Bank Branch	String	STR20	20
56	SALSTERR	Sales Territory	String	STR15_Sales_Territory	15
	Key to the Sales Territory Master File (RM00303). Click to show/hide SELECT ['SmartList RM Customer MSTR'].SALSTERR AS 'SmartList RM Customer MSTR-Sales Territory' ,['Sales Territory Master File'].SALSTERR AS 'Sales Territory Master File-Sales Territory' FROM ASIEXP02 AS ['SmartList RM Customer MSTR'] INNER JOIN RM00303 AS ['Sales Territory Master File'] ON ['SmartList RM Customer MSTR'].SALSTERR = ['Sales Territory Master File'].SALSTERR
57	DEFCACTY	Default Cash Account Type	Integer	GB	0
58	RMCSHACC	RM Cash Account Index	Long Integer	LI_14	14
59	RMARACC	RM AR Account Index	Long Integer	LI_14	14
60	RMSLSACC	RM Sales Account Index	Long Integer	LI_14	14
61	RMIVACC	RM IV Account Index	Long Integer	LI_14	14
62	RMCOSACC	RM Cost Of Sales Account Index	Long Integer	LI_14	14
63	RMTAKACC	RM Discounts Taken Account Index	Long Integer	LI_14	14
64	RMAVACC	RM Discounts Avail Account Index	Long Integer	LI_14	14
65	RMFCGACC	RM Finance Charge Account Index	Long Integer	LI_14	14
66	RMWRACC	RM Writeoff Account Index	Long Integer	LI_14	14
67	FRSTINDT	First Invoice Date	Date	DT_Date	6
68	INACTIVE	Inactive	Boolean	CB_Inactive	0
69	HOLD	Hold	Boolean	CB_Hold	0
70	CRCARDID	Credit Card ID	String	STR15	15
71	CRCRDNUM	Credit Card Number	String	STR20	20
72	CCRDXPDT	Credit Card Exp Date	Date	DT_Date	6
73	KPDSTHST	Keep Distribution History	Boolean	CB_Keep_Dist_History	0
74	KPCALHST	Keep Calendar History	Boolean	CB_Keep_Calendar_History	0
75	KPERHIST	Keep Period History	Boolean	CB_Keep_Period_History	0
76	KPTRXHST	Keep Trx History	Boolean	CB_Keep_Trx_History	0
77	NOTEINDX	Note Index	Currency	DLR14	14
	Key to the Record Notes Master (SY03900). Click to show/hide SELECT ['SmartList RM Customer MSTR'].NOTEINDX AS 'SmartList RM Customer MSTR-Note Index' ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index' FROM ASIEXP02 AS ['SmartList RM Customer MSTR'] INNER JOIN SY03900 AS ['Record Notes Master'] ON ['SmartList RM Customer MSTR'].NOTEINDX = ['Record Notes Master'].NOTEINDX
78	CREATDDT	Created Date	Date	DT	8
79	MODIFDT	Modified Date	Date	DT	8
80	ASI_Favorite_Sequence	ASI_Favorite_Sequence	Long Integer	ASI_LI_10_RU	10
81	TNSFCLIF	Total Amount Of NSF Checks Life	Currency	DLR19_RBS0_STR$	19
82	NONSFLIF	Number Of NSF Checks Life	Long Integer	LI6_U0	6
83	CUSTBLNC	Customer Balance	Currency	DLR19_RBS0_STR$	19
84	AGPERAMT_1	Aging Period Amounts[1]	Currency	DLR17_RBSO_STR$	17
85	AGPERAMT_2	Aging Period Amounts[2]	Currency	DLR17_RBSO_STR$	17
86	AGPERAMT_3	Aging Period Amounts[3]	Currency	DLR17_RBSO_STR$	17
87	AGPERAMT_4	Aging Period Amounts[4]	Currency	DLR17_RBSO_STR$	17
88	AGPERAMT_5	Aging Period Amounts[5]	Currency	DLR17_RBSO_STR$	17
89	AGPERAMT_6	Aging Period Amounts[6]	Currency	DLR17_RBSO_STR$	17
90	AGPERAMT_7	Aging Period Amounts[7]	Currency	DLR17_RBSO_STR$	17
91	LASTAGED	Last Aged	Date	DATE	6
92	LSTNSFCD	Last NSF Check Date	Date	DT_Date	6
93	LPYMTAMT	Last Payment Amount	Currency	DLR17_RBS0_STR$	17
94	LASTPYDT	Last Payment Date	Date	DT_Date	6
95	LSTTRXDT	Last Transaction Date	Date	DT_Date	6
96	LSTTRXAM	Last Transaction Amount	Currency	DLR17_RBS0_STR$	17
97	LSTFCHAM	Last Finance Charge Amount	Currency	DLR19_RBS0_STR$	19
98	UPFCHYTD	Unpaid Finance Charges YTD	Currency	DLR17_RBS0_UTR$	17
99	AVDTPLYR	Average Days to Pay - LYR	Integer	INT3_U0	3
100	AVDTPLIF	Average Days To Pay - Life	Integer	INT3_U0	3
101	AVGDTPYR	Average Days To Pay - Year	Integer	INT3_U0	3
102	NUMADTPL	Number ADTP Documents - Life	Long Integer	Long_10U	10
103	NUMADTPY	Number ADTP Documents - Year	Long Integer	Long_10U	10
104	NUMADTPR	Number ADTP Documents - LYR	Long Integer	Long_10U	10
105	TDTKNYTD	Total Discounts Taken YTD	Currency	DLR19_RBS0_STR$	19
106	TDTKNLYR	Total Discounts Taken LYR	Currency	DLR19_RBS0_STR$	19
107	TDTKNLTD	Total Discounts Taken LTD	Currency	DLR19_RBS0_STR$	19
108	TDISAYTD	Total Discounts Available YTD	Currency	DLR19_RBS0_STR$	19
109	RETAINAG	Retainage	Currency	DLR19_RBS0_STR$	19
110	TNSFCYTD	Total Amount Of NSF Checks YTD	Currency	DLR19_RBS0_STR$	19
111	NONSFYTD	Number Of NSF Checks YTD	Long Integer	LI6_U0	6
112	UNPSTDSA	Unposted Sales Amount	Currency	DLR19_RBS0_UTR$	19
113	UNPSTDCA	Unposted Cash Amount	Currency	DLR19_RBS0_UTR$	19
114	UNPSTOSA	Unposted Other Sales Amount	Currency	DLR19_RBS0_UTR$	19
115	UNPSTOCA	Unposted Other Cash Amount	Currency	DLR19_RBS0_UTR$	19
116	NCSCHPMT	Non Current Scheduled Payments	Currency	DLR19_RBS0_STR$	19
117	TTLSLYTD	Total Sales YTD	Currency	DLR19_RBS0_STR$	19
118	TTLSLLTD	Total Sales LTD	Currency	DLR19_RBS0_STR$	19
119	TTLSLLYR	Total Sales LYR	Currency	DLR19_RBS0_STR$	19
120	TCOSTYTD	Total Costs YTD	Currency	DLR19_RBS0_STR$	19
121	TCOSTLTD	Total Costs LTD	Currency	DLR19_RBS0_STR$	19
122	TCOSTLYR	Total Costs LYR	Currency	DLR19_RBS0_STR$	19
123	TCSHRYTD	Total Cash Received YTD	Currency	DLR19_RBS0_STR$	19
124	TCSHRLTD	Total Cash Received LTD	Currency	DLR19_RBS0_STR$	19
125	TCSHRLYR	Total Cash Received LYR	Currency	DLR19_RBS0_STR$	19
126	TFNCHYTD	Total Finance Charges YTD	Currency	DLR19_RBS0_STR$	19
127	TFNCHLTD	Total Finance Charges LTD	Currency	DLR19_RBS0_STR$	19
128	TFNCHLYR	Total Finance Charges LYR	Currency	DLR19_RBS0_STR$	19
129	FNCHCYTD	Finance Charges CYTD	Currency	DLR19_RBS0_STR$	19
130	FNCHLYRC	Finance Charges LYR Calendar	Currency	DLR19_RBS0_STR$	19
131	TBDDTYTD	Total Bad Debt YTD	Currency	DLR19_RBS0_STR$	19
132	TBDDTLYR	Total Bad Deb LYR	Currency	DLR19_RBS0_STR$	19
133	TBDDTLTD	Total Bad Debt LTD	Currency	DLR19_RBS0_STR$	19
134	TWVFCYTD	Total Waived FC YTD	Currency	DLR19_RBS0_STR$	19
135	TWVFCLTD	Total Waived FC LTD	Currency	DLR19_RBS0_STR$	19
136	TWVFCLYR	Total Waived FC LYR	Currency	DLR19_RBS0_STR$	19
137	TWROFYTD	Total Writeoffs YTD	Currency	DLR19_RBS0_STR$	19
138	TWROFLTD	Total Writeoffs LTD	Currency	DLR19_RBS0_STR$	19
139	TWROFLYR	Total Writeoffs LYR	Currency	DLR19_RBS0_STR$	19
140	TTLINYTD	Total # Invoices YTD	Long Integer	LI6_U0	6
141	TTLINLTD	Total # Invoices LTD	Long Integer	LI6_U0	6
142	TTLINLYR	Total # Invoices LYR	Long Integer	LI6_U0	6
143	TTLFCYTD	Total # FC YTD	Long Integer	LI6_U0	6
144	TTLFCLTD	Total # FC LTD	Long Integer	LI6_U0	6
145	TTLFCLYR	Total # FC LYR	Long Integer	LI6_U0	6
146	WROFSLIF	Write Offs LIFE	Currency	DLR19_RBS0_STR$	19
147	WROFSLYR	Write Offs LYR	Currency	DLR19_RBS0_STR$	19
148	WROFSYTD	Write Offs YTD	Currency	DLR19_RBS0_STR$	19
149	HIBALLYR	High Balance LYR	Currency	DLR19_RBSO_STR$	19
150	HIBALYTD	High Balance YTD	Currency	DLR19_RBSO_STR$	19
151	HIBALLTD	High Balance LTD	Currency	DLR19_RBSO_STR$	19
152	LASTSTDT	Last Statement Date	Date	DATE	6
153	LSTSTAMT	Last Statement Amount	Currency	DLR17_RBS0_STR$	17
154	DEPRECV	Deposits Received	Currency	DLR19_RBS0_STR$	19
155	ONORDAMT	On Order Amount	Currency	DLR19_RBS0_UTR$	19
156	Revalue_Customer	Revalue Customer	Boolean	CB Revalue Customer	0
157	Post_Results_To	Post Results To	Integer	GB	0
158	FINCHID	Finance Charge ID	String	STR15_Charge_ID	15
159	GOVCRPID	Governmental Corporate ID	String	STR30_Gov_Corp_ID	30
160	GOVINDID	Governmental Individual ID	String	STR30_Gov_Indiv_ID	30
161	DISGRPER	Discount Grace Period	Integer	INT2_U0	2
162	DOCFMTID	Document Format ID	String	STR15_LBU	15
163	DUEGRPER	Due Date Grace Period	Integer	INT2_U0	2
164	PHONE3	Phone 3	String	Phone_Number3	14
165	TTLRTLTD	Total Returns LTD	Currency	DLR19_RBS0_STR$	19
166	TTLRTLYR	Total Returns LYR	Currency	DLR19_RBS0_STR$	19
167	TTLRTYTD	Total Returns YTD	Currency	DLR19_RBS0_STR$	19
168	RMSORACC	RM Sales Order Returns Account Index	Long Integer	LI_14	14
169	Send_Email_Statements	Send Email Statements	Boolean	CB	0
170	ORDERFULFILLDEFAULT	Order Fulfillment Shortage Default	Integer	DDL_OrderFulfillDefault	0
171	CUSTPRIORITY	Customer Priority	Integer	DDL_CustomerPriority	0
172	SHIPCOMPLETE	Ship Complete Document	Boolean	CB_ShipComplete	0

azurecurve Products SmartList (1493)PathnameSmartList RM Customer MSTR (ASIEXP02)

Leave a Reply Cancel reply