Site Search:
Sign in | Join | Help

Dynamics GP

Notes, Tips and Tricks on Developing in Dynamics GP

RM00103 field definitions

Here are field definitions for the RM00103 table

 

Name

 Physical Name Type Storage
GPS_Reserved GPS_RESERVED Long Integer 4
Total Amount Of NSF Checks Life TNSFCLIF Currency 10
Number Of NSF Checks Life NONSFLIF Long Integer 4
Customer Number CUSTNMBR String 16
Customer Balance CUSTBLNC Currency 10
Aging Period Amounts AGPERAMT Currency 70
Last Aged LASTAGED Date 4
First Invoice Date FRSTINDT Date 4
Last NSF Check Date LSTNSFCD Date 4
Last Payment Amount LPYMTAMT Currency 10
Last Payment Date LASTPYDT Date 4
Last Transaction Date LSTTRXDT Date 4
Last Transaction Amount LSTTRXAM Currency 10
Last Finance Charge Amount LSTFCHAM Currency 10
Unpaid Finance Charges YTD UPFCHYTD Currency 10
Average Days to Pay - LYR AVDTPLYR Integer 2
Average Days To Pay - Life AVDTPLIF Integer 2
Average Days To Pay - Year AVGDTPYR Integer 2
Number ADTP Documents - Life NUMADTPL Long Integer 4
Number ADTP Documents - Year NUMADTPY Long Integer 4
Number ADTP Documents - LYR NUMADTPR Long Integer 4
Total Discounts Taken YTD TDTKNYTD Currency 10
Total Discounts Taken LYR TDTKNLYR Currency 10
Total Discounts Taken LTD TDTKNLTD Currency 10
Total Discounts Available YTD TDISAYTD Currency 10
Retainage RETAINAG Currency 10
Total Amount Of NSF Checks YTD TNSFCYTD Currency 10
Number Of NSF Checks YTD NONSFYTD Long Integer 4
Unposted Sales Amount UNPSTDSA Currency 10
Unposted Cash Amount UNPSTDCA Currency 10
Unposted Other Sales Amount UNPSTOSA Currency 10
Unposted Other Cash Amount UNPSTOCA Currency 10
Non Current Scheduled Payments NCSCHPMT Currency 10
Total Sales YTD TTLSLYTD Currency 10
Total Sales LTD TTLSLLTD Currency 10
Total Sales LYR TTLSLLYR Currency 10
Total Costs YTD TCOSTYTD Currency 10
Total Costs LTD TCOSTLTD Currency 10
Total Costs LYR TCOSTLYR Currency 10
Total Cash Received YTD TCSHRYTD Currency 10
Total Cash Received LTD TCSHRLTD Currency 10
Total Cash Received LYR TCSHRLYR Currency 10
Total Finance Charges YTD TFNCHYTD Currency 10
Total Finance Charges LTD TFNCHLTD Currency 10
Total Finance Charges LYR TFNCHLYR Currency 10
Finance Charges CYTD FNCHCYTD Currency 10
Finance Charges LYR Calendar FNCHLYRC Currency 10
Total Bad Debt YTD TBDDTYTD Currency 10
Total Bad Deb LYR TBDDTLYR Currency 10
Total Bad Debt LTD TBDDTLTD Currency 10
Total Waived FC YTD TWVFCYTD Currency 10
Total Waived FC LTD TWVFCLTD Currency 10
Total Waived FC LYR TWVFCLYR Currency 10
Total Writeoffs YTD TWROFYTD Currency 10
Total Writeoffs LTD TWROFLTD Currency 10
Total Writeoffs LYR TWROFLYR Currency 10
Total # Invoices YTD TTLINYTD Long Integer 4
Total # Invoices LTD TTLINLTD Long Integer 4
Total # Invoices LYR TTLINLYR Long Integer 4
Total # FC YTD TTLFCYTD Long Integer 4
Total # FC LTD TTLFCLTD Long Integer 4
Total # FC LYR TTLFCLYR Long Integer 4
Write Offs LIFE WROFSLIF Currency 10
Write Offs LYR WROFSLYR Currency 10
Write Offs YTD WROFSYTD Currency 10
High Balance LYR HIBALLYR Currency 10
High Balance YTD HIBALYTD Currency 10
High Balance LTD HIBALLTD Currency 10
Last Statement Date LASTSTDT Date 4
Last Statement Amount LSTSTAMT Currency 10
Deposits Received DEPRECV Currency 10
On Order Amount ONORDAMT Currency 10
Total Returns YTD TTLRTYTD Currency 10
Total Returns LTD TTLRTLTD Currency 10
Total Returns LYR TTLRTLYR Currency 10
Published Feb 22 2008, 12:57 PM by steve gray

Comments

 

Dynamics GP said:

This table contains all the table names, technical names, and user-friendly names for the tables in the

February 22, 2008 1:02 PM
 

steve gray said:

Thank you so much! This list is great!!! Do you have any list for other GP tables?

May 6, 2010 12:54 PM
 

steve gray said:

We have pretty much all of them. You'll find links on the home page. If there is anything missing let us know.

May 6, 2010 5:14 PM

Leave a Comment

(required)  
(optional)
(required)  
Add