Customer Master Summary (RM00103)

azurecurve Products Microsoft Dynamics GP (0)SalesCustomer Master Summary (RM00103)

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

Product: Microsoft Dynamics GP (0)
Series: Sales

Display Name: Customer Master Summary
Physical Name: RM00103
Technical Name: RM_Customer_MSTR_SUM

Group Display Name: Receivables Customer Master Files
Group Technical Name: RM_Customer_MSTR_Logical_File

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	TNSFCLIF	Total Amount Of NSF Checks Life	Currency	DLR19_RBS0_STR$	19
2	NONSFLIF	Number Of NSF Checks Life	Long Integer	LI6_U0	6
3	CUSTNMBR	Customer Number	String	STR15_RM_Customer_Number	15
	Key to the RM Customer MSTR (RM00101). Click to show/hide SELECT ['Customer Master Summary'].CUSTNMBR AS 'Customer Master Summary-Customer Number' ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number' FROM RM00103 AS ['Customer Master Summary'] INNER JOIN RM00101 AS ['RM Customer MSTR'] ON ['Customer Master Summary'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
4	CUSTBLNC	Customer Balance	Currency	DLR19_RBS0_STR$	19
5	AGPERAMT_1	Aging Period Amounts[1]	Currency	DLR17_RBSO_STR$	17
6	AGPERAMT	Aging Period Amounts	DLR17_RBSO_STR$	Currency	17
7	AGPERAMT_2	Aging Period Amounts[2]	Currency	DLR17_RBSO_STR$	17
8	AGPERAMT_3	Aging Period Amounts[3]	Currency	DLR17_RBSO_STR$	17
9	AGPERAMT_4	Aging Period Amounts[4]	Currency	DLR17_RBSO_STR$	17
10	AGPERAMT_5	Aging Period Amounts[5]	Currency	DLR17_RBSO_STR$	17
11	AGPERAMT_6	Aging Period Amounts[6]	Currency	DLR17_RBSO_STR$	17
12	AGPERAMT_7	Aging Period Amounts[7]	Currency	DLR17_RBSO_STR$	17
13	LASTAGED	Last Aged	Date	DATE	6
14	FRSTINDT	First Invoice Date	Date	DT_Date	6
15	LSTNSFCD	Last NSF Check Date	Date	DT_Date	6
16	LPYMTAMT	Last Payment Amount	Currency	DLR17_RBS0_STR$	17
17	LASTPYDT	Last Payment Date	Date	DT_Date	6
18	LSTTRXDT	Last Transaction Date	Date	DT_Date	6
19	LSTTRXAM	Last Transaction Amount	Currency	DLR17_RBS0_STR$	17
20	LSTFCHAM	Last Finance Charge Amount	Currency	DLR19_RBS0_STR$	19
21	UPFCHYTD	Unpaid Finance Charges YTD	Currency	DLR17_RBS0_UTR$	17
22	AVDTPLYR	Average Days to Pay - LYR	Integer	INT3_U0	3
23	AVDTPLIF	Average Days To Pay - Life	Integer	INT3_U0	3
24	AVGDTPYR	Average Days To Pay - Year	Integer	INT3_U0	3
25	NUMADTPL	Number ADTP Documents - Life	Long Integer	Long_10U	10
26	NUMADTPY	Number ADTP Documents - Year	Long Integer	Long_10U	10
27	NUMADTPR	Number ADTP Documents - LYR	Long Integer	Long_10U	10
28	TDTKNYTD	Total Discounts Taken YTD	Currency	DLR19_RBS0_STR$	19
29	TDTKNLYR	Total Discounts Taken LYR	Currency	DLR19_RBS0_STR$	19
30	TDTKNLTD	Total Discounts Taken LTD	Currency	DLR19_RBS0_STR$	19
31	TDISAYTD	Total Discounts Available YTD	Currency	DLR19_RBS0_STR$	19
32	RETAINAG	Retainage	Currency	DLR19_RBS0_STR$	19
33	TNSFCYTD	Total Amount Of NSF Checks YTD	Currency	DLR19_RBS0_STR$	19
34	NONSFYTD	Number Of NSF Checks YTD	Long Integer	LI6_U0	6
35	UNPSTDSA	Unposted Sales Amount	Currency	DLR19_RBS0_UTR$	19
36	UNPSTDCA	Unposted Cash Amount	Currency	DLR19_RBS0_UTR$	19
37	UNPSTOSA	Unposted Other Sales Amount	Currency	DLR19_RBS0_UTR$	19
38	UNPSTOCA	Unposted Other Cash Amount	Currency	DLR19_RBS0_UTR$	19
39	NCSCHPMT	Non Current Scheduled Payments	Currency	DLR19_RBS0_STR$	19
40	TTLSLYTD	Total Sales YTD	Currency	DLR19_RBS0_STR$	19
41	TTLSLLTD	Total Sales LTD	Currency	DLR19_RBS0_STR$	19
42	TTLSLLYR	Total Sales LYR	Currency	DLR19_RBS0_STR$	19
43	TCOSTYTD	Total Costs YTD	Currency	DLR19_RBS0_STR$	19
44	TCOSTLTD	Total Costs LTD	Currency	DLR19_RBS0_STR$	19
45	TCOSTLYR	Total Costs LYR	Currency	DLR19_RBS0_STR$	19
46	TCSHRYTD	Total Cash Received YTD	Currency	DLR19_RBS0_STR$	19
47	TCSHRLTD	Total Cash Received LTD	Currency	DLR19_RBS0_STR$	19
48	TCSHRLYR	Total Cash Received LYR	Currency	DLR19_RBS0_STR$	19
49	TFNCHYTD	Total Finance Charges YTD	Currency	DLR19_RBS0_STR$	19
50	TFNCHLTD	Total Finance Charges LTD	Currency	DLR19_RBS0_STR$	19
51	TFNCHLYR	Total Finance Charges LYR	Currency	DLR19_RBS0_STR$	19
52	FNCHCYTD	Finance Charges CYTD	Currency	DLR19_RBS0_STR$	19
53	FNCHLYRC	Finance Charges LYR Calendar	Currency	DLR19_RBS0_STR$	19
54	TBDDTYTD	Total Bad Debt YTD	Currency	DLR19_RBS0_STR$	19
55	TBDDTLYR	Total Bad Deb LYR	Currency	DLR19_RBS0_STR$	19
56	TBDDTLTD	Total Bad Debt LTD	Currency	DLR19_RBS0_STR$	19
57	TWVFCYTD	Total Waived FC YTD	Currency	DLR19_RBS0_STR$	19
58	TWVFCLTD	Total Waived FC LTD	Currency	DLR19_RBS0_STR$	19
59	TWVFCLYR	Total Waived FC LYR	Currency	DLR19_RBS0_STR$	19
60	TWROFYTD	Total Writeoffs YTD	Currency	DLR19_RBS0_STR$	19
61	TWROFLTD	Total Writeoffs LTD	Currency	DLR19_RBS0_STR$	19
62	TWROFLYR	Total Writeoffs LYR	Currency	DLR19_RBS0_STR$	19
63	TTLINYTD	Total # Invoices YTD	Long Integer	LI6_U0	6
64	TTLINLTD	Total # Invoices LTD	Long Integer	LI6_U0	6
65	TTLINLYR	Total # Invoices LYR	Long Integer	LI6_U0	6
66	TTLFCYTD	Total # FC YTD	Long Integer	LI6_U0	6
67	TTLFCLTD	Total # FC LTD	Long Integer	LI6_U0	6
68	TTLFCLYR	Total # FC LYR	Long Integer	LI6_U0	6
69	WROFSLIF	Write Offs LIFE	Currency	DLR19_RBS0_STR$	19
70	WROFSLYR	Write Offs LYR	Currency	DLR19_RBS0_STR$	19
71	WROFSYTD	Write Offs YTD	Currency	DLR19_RBS0_STR$	19
72	HIBALLYR	High Balance LYR	Currency	DLR19_RBSO_STR$	19
73	HIBALYTD	High Balance YTD	Currency	DLR19_RBSO_STR$	19
74	HIBALLTD	High Balance LTD	Currency	DLR19_RBSO_STR$	19
75	LASTSTDT	Last Statement Date	Date	DATE	6
76	LSTSTAMT	Last Statement Amount	Currency	DLR17_RBS0_STR$	17
77	DEPRECV	Deposits Received	Currency	DLR19_RBS0_STR$	19
78	ONORDAMT	On Order Amount	Currency	DLR19_RBS0_UTR$	19
79	TTLRTYTD	Total Returns YTD	Currency	DLR19_RBS0_STR$	19
80	TTLRTLTD	Total Returns LTD	Currency	DLR19_RBS0_STR$	19
81	TTLRTLYR	Total Returns LYR	Currency	DLR19_RBS0_STR$	19

azurecurve Products Microsoft Dynamics GP (0)SalesCustomer Master Summary (RM00103)

Click to show/hide

Leave a Reply Cancel reply