Customer Master Summary (RM00103)

azurecurveProductsMicrosoft 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 NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1TNSFCLIF SearchTotal Amount Of NSF Checks LifeDLR19_RBS0_STR$Currency1019
2NONSFLIF SearchNumber Of NSF Checks LifeLI6_U0Long Integer46
3CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString1615
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
4CUSTBLNC SearchCustomer BalanceDLR19_RBS0_STR$Currency1019
5AGPERAMT SearchAging Period AmountsDLR17_RBSO_STR$Currency1017
6AGPERAMT_1 SearchAging Period Amounts[1]DLR17_RBSO_STR$Currency1017
7AGPERAMT_2 SearchAging Period Amounts[2]DLR17_RBSO_STR$Currency1017
8AGPERAMT_3 SearchAging Period Amounts[3]DLR17_RBSO_STR$Currency1017
9AGPERAMT_4 SearchAging Period Amounts[4]DLR17_RBSO_STR$Currency1017
10AGPERAMT_5 SearchAging Period Amounts[5]DLR17_RBSO_STR$Currency1017
11AGPERAMT_6 SearchAging Period Amounts[6]DLR17_RBSO_STR$Currency1017
12AGPERAMT_7 SearchAging Period Amounts[7]DLR17_RBSO_STR$Currency1017
13LASTAGED SearchLast AgedDATEDate46
14FRSTINDT SearchFirst Invoice DateDT_DateDate46
15LSTNSFCD SearchLast NSF Check DateDT_DateDate46
16LPYMTAMT SearchLast Payment AmountDLR17_RBS0_STR$Currency1017
17LASTPYDT SearchLast Payment DateDT_DateDate46
18LSTTRXDT SearchLast Transaction DateDT_DateDate46
19LSTTRXAM SearchLast Transaction AmountDLR17_RBS0_STR$Currency1017
20LSTFCHAM SearchLast Finance Charge AmountDLR19_RBS0_STR$Currency1019
21UPFCHYTD SearchUnpaid Finance Charges YTDDLR17_RBS0_UTR$Currency1017
22AVDTPLYR SearchAverage Days to Pay - LYRINT3_U0Integer23
23AVDTPLIF SearchAverage Days To Pay - LifeINT3_U0Integer23
24AVGDTPYR SearchAverage Days To Pay - YearINT3_U0Integer23
25NUMADTPL SearchNumber ADTP Documents - LifeLong_10ULong Integer410
26NUMADTPY SearchNumber ADTP Documents - YearLong_10ULong Integer410
27NUMADTPR SearchNumber ADTP Documents - LYRLong_10ULong Integer410
28TDTKNYTD SearchTotal Discounts Taken YTDDLR19_RBS0_STR$Currency1019
29TDTKNLYR SearchTotal Discounts Taken LYRDLR19_RBS0_STR$Currency1019
30TDTKNLTD SearchTotal Discounts Taken LTDDLR19_RBS0_STR$Currency1019
31TDISAYTD SearchTotal Discounts Available YTDDLR19_RBS0_STR$Currency1019
32RETAINAG SearchRetainageDLR19_RBS0_STR$Currency1019
33TNSFCYTD SearchTotal Amount Of NSF Checks YTDDLR19_RBS0_STR$Currency1019
34NONSFYTD SearchNumber Of NSF Checks YTDLI6_U0Long Integer46
35UNPSTDSA SearchUnposted Sales AmountDLR19_RBS0_UTR$Currency1019
36UNPSTDCA SearchUnposted Cash AmountDLR19_RBS0_UTR$Currency1019
37UNPSTOSA SearchUnposted Other Sales AmountDLR19_RBS0_UTR$Currency1019
38UNPSTOCA SearchUnposted Other Cash AmountDLR19_RBS0_UTR$Currency1019
39NCSCHPMT SearchNon Current Scheduled PaymentsDLR19_RBS0_STR$Currency1019
40TTLSLYTD SearchTotal Sales YTDDLR19_RBS0_STR$Currency1019
41TTLSLLTD SearchTotal Sales LTDDLR19_RBS0_STR$Currency1019
42TTLSLLYR SearchTotal Sales LYRDLR19_RBS0_STR$Currency1019
43TCOSTYTD SearchTotal Costs YTDDLR19_RBS0_STR$Currency1019
44TCOSTLTD SearchTotal Costs LTDDLR19_RBS0_STR$Currency1019
45TCOSTLYR SearchTotal Costs LYRDLR19_RBS0_STR$Currency1019
46TCSHRYTD SearchTotal Cash Received YTDDLR19_RBS0_STR$Currency1019
47TCSHRLTD SearchTotal Cash Received LTDDLR19_RBS0_STR$Currency1019
48TCSHRLYR SearchTotal Cash Received LYRDLR19_RBS0_STR$Currency1019
49TFNCHYTD SearchTotal Finance Charges YTDDLR19_RBS0_STR$Currency1019
50TFNCHLTD SearchTotal Finance Charges LTDDLR19_RBS0_STR$Currency1019
51TFNCHLYR SearchTotal Finance Charges LYRDLR19_RBS0_STR$Currency1019
52FNCHCYTD SearchFinance Charges CYTDDLR19_RBS0_STR$Currency1019
53FNCHLYRC SearchFinance Charges LYR CalendarDLR19_RBS0_STR$Currency1019
54TBDDTYTD SearchTotal Bad Debt YTDDLR19_RBS0_STR$Currency1019
55TBDDTLYR SearchTotal Bad Deb LYRDLR19_RBS0_STR$Currency1019
56TBDDTLTD SearchTotal Bad Debt LTDDLR19_RBS0_STR$Currency1019
57TWVFCYTD SearchTotal Waived FC YTDDLR19_RBS0_STR$Currency1019
58TWVFCLTD SearchTotal Waived FC LTDDLR19_RBS0_STR$Currency1019
59TWVFCLYR SearchTotal Waived FC LYRDLR19_RBS0_STR$Currency1019
60TWROFYTD SearchTotal Writeoffs YTDDLR19_RBS0_STR$Currency1019
61TWROFLTD SearchTotal Writeoffs LTDDLR19_RBS0_STR$Currency1019
62TWROFLYR SearchTotal Writeoffs LYRDLR19_RBS0_STR$Currency1019
63TTLINYTD SearchTotal # Invoices YTDLI6_U0Long Integer46
64TTLINLTD SearchTotal # Invoices LTDLI6_U0Long Integer46
65TTLINLYR SearchTotal # Invoices LYRLI6_U0Long Integer46
66TTLFCYTD SearchTotal # FC YTDLI6_U0Long Integer46
67TTLFCLTD SearchTotal # FC LTDLI6_U0Long Integer46
68TTLFCLYR SearchTotal # FC LYRLI6_U0Long Integer46
69WROFSLIF SearchWrite Offs LIFEDLR19_RBS0_STR$Currency1019
70WROFSLYR SearchWrite Offs LYRDLR19_RBS0_STR$Currency1019
71WROFSYTD SearchWrite Offs YTDDLR19_RBS0_STR$Currency1019
72HIBALLYR SearchHigh Balance LYRDLR19_RBSO_STR$Currency1019
73HIBALYTD SearchHigh Balance YTDDLR19_RBSO_STR$Currency1019
74HIBALLTD SearchHigh Balance LTDDLR19_RBSO_STR$Currency1019
75LASTSTDT SearchLast Statement DateDATEDate46
76LSTSTAMT SearchLast Statement AmountDLR17_RBS0_STR$Currency1017
77DEPRECV SearchDeposits ReceivedDLR19_RBS0_STR$Currency1019
78ONORDAMT SearchOn Order AmountDLR19_RBS0_UTR$Currency1019
79TTLRTYTD SearchTotal Returns YTDDLR19_RBS0_STR$Currency1019
80TTLRTLTD SearchTotal Returns LTDDLR19_RBS0_STR$Currency1019
81TTLRTLYR SearchTotal Returns LYRDLR19_RBS0_STR$Currency1019
82DEX_ROW_ID Searchintint1010

DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information.

Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.

azurecurveProductsMicrosoft Dynamics GP (0)SalesCustomer Master Summary (RM00103)

Leave a Reply

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