RM00103 - Customer Master Summary | Prospr - Dynamics GP Table Reference

RM00103 - Customer Master Summary

Query Builder

Select * from RM00103

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
TNSFCLIF	Total Amount Of NSF Checks Life	Currency	10	View
NONSFLIF	Number Of NSF Checks Life	Long Integer	4	View
CUSTNMBR	Customer Number	String	16	View
CUSTBLNC	Customer Balance	Currency	10	View
AGPERAMT_1	Aging Period Amounts[1]	Currency	10	View
AGPERAMT_2	Aging Period Amounts[2]	Currency	10	View
AGPERAMT_3	Aging Period Amounts[3]	Currency	10	View
AGPERAMT_4	Aging Period Amounts[4]	Currency	10	View
AGPERAMT_5	Aging Period Amounts[5]	Currency	10	View
AGPERAMT_6	Aging Period Amounts[6]	Currency	10	View
AGPERAMT_7	Aging Period Amounts[7]	Currency	10	View
LASTAGED	Last Aged	Date	4	View
FRSTINDT	First Invoice Date	Date	4	View
LSTNSFCD	Last NSF Check Date	Date	4	View
LPYMTAMT	Last Payment Amount	Currency	10	View
LASTPYDT	Last Payment Date	Date	4	View
LSTTRXDT	Last Transaction Date	Date	4	View
LSTTRXAM	Last Transaction Amount	Currency	10	View
LSTFCHAM	Last Finance Charge Amount	Currency	10	View
UPFCHYTD	Unpaid Finance Charges YTD	Currency	10	View
AVDTPLYR	Average Days to Pay - LYR	Integer	2	View
AVDTPLIF	Average Days To Pay - Life	Integer	2	View
AVGDTPYR	Average Days To Pay - Year	Integer	2	View
NUMADTPL	Number ADTP Documents - Life	Long Integer	4	View
NUMADTPY	Number ADTP Documents - Year	Long Integer	4	View
NUMADTPR	Number ADTP Documents - LYR	Long Integer	4	View
TDTKNYTD	Total Discounts Taken YTD	Currency	10	View
TDTKNLYR	Total Discounts Taken LYR	Currency	10	View
TDTKNLTD	Total Discounts Taken LTD	Currency	10	View
TDISAYTD	Total Discounts Available YTD	Currency	10	View
RETAINAG	Retainage	Currency	10	View
TNSFCYTD	Total Amount Of NSF Checks YTD	Currency	10	View
NONSFYTD	Number Of NSF Checks YTD	Long Integer	4	View
UNPSTDSA	Unposted Sales Amount	Currency	10	View
UNPSTDCA	Unposted Cash Amount	Currency	10	View
UNPSTOSA	Unposted Other Sales Amount	Currency	10	View
UNPSTOCA	Unposted Other Cash Amount	Currency	10	View
NCSCHPMT	Non Current Scheduled Payments	Currency	10	View
TTLSLYTD	Total Sales YTD	Currency	10	View
TTLSLLTD	Total Sales LTD	Currency	10	View
TTLSLLYR	Total Sales LYR	Currency	10	View
TCOSTYTD	Total Costs YTD	Currency	10	View
TCOSTLTD	Total Costs LTD	Currency	10	View
TCOSTLYR	Total Costs LYR	Currency	10	View
TCSHRYTD	Total Cash Received YTD	Currency	10	View
TCSHRLTD	Total Cash Received LTD	Currency	10	View
TCSHRLYR	Total Cash Received LYR	Currency	10	View
TFNCHYTD	Total Finance Charges YTD	Currency	10	View
TFNCHLTD	Total Finance Charges LTD	Currency	10	View
TFNCHLYR	Total Finance Charges LYR	Currency	10	View
FNCHCYTD	Finance Charges CYTD	Currency	10	View
FNCHLYRC	Finance Charges LYR Calendar	Currency	10	View
TBDDTYTD	Total Bad Debt YTD	Currency	10	View
TBDDTLYR	Total Bad Deb LYR	Currency	10	View
TBDDTLTD	Total Bad Debt LTD	Currency	10	View
TWVFCYTD	Total Waived FC YTD	Currency	10	View
TWVFCLTD	Total Waived FC LTD	Currency	10	View
TWVFCLYR	Total Waived FC LYR	Currency	10	View
TWROFYTD	Total Writeoffs YTD	Currency	10	View
TWROFLTD	Total Writeoffs LTD	Currency	10	View
TWROFLYR	Total Writeoffs LYR	Currency	10	View
TTLINYTD	Total # Invoices YTD	Long Integer	4	View
TTLINLTD	Total # Invoices LTD	Long Integer	4	View
TTLINLYR	Total # Invoices LYR	Long Integer	4	View
TTLFCYTD	Total # FC YTD	Long Integer	4	View
TTLFCLTD	Total # FC LTD	Long Integer	4	View
TTLFCLYR	Total # FC LYR	Long Integer	4	View
WROFSLIF	Write Offs LIFE	Currency	10	View
WROFSLYR	Write Offs LYR	Currency	10	View
WROFSYTD	Write Offs YTD	Currency	10	View
HIBALLYR	High Balance LYR	Currency	10	View
HIBALYTD	High Balance YTD	Currency	10	View
HIBALLTD	High Balance LTD	Currency	10	View
LASTSTDT	Last Statement Date	Date	4	View
LSTSTAMT	Last Statement Amount	Currency	10	View
DEPRECV	Deposits Received	Currency	10	View
ONORDAMT	On Order Amount	Currency	10	View
TTLRTYTD	Total Returns YTD	Currency	10	View
TTLRTLTD	Total Returns LTD	Currency	10	View
TTLRTLYR	Total Returns LYR	Currency	10	View

RM00103 - Customer Master Summary

Query Builder

Customer Service

Information

My Account

Contact Us