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

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 *