Module List > Module RM tables RM00103
You are currently viewing the COMPANY database.
Change

COMPANY..RM00103 Table Definition

(COMPANY..Customer Master Summary)
The RM Customer Master Summary contains summary information about the Customers. YTD, Last Year, & LTD totals as well as last amounts and highest balances for the Customer. It would normally not be imported into unless you wanted last years or Life To Date information for comparative purposes. The Customer Master Summary totals for unposted Sales/Debits, Cash Credits, Other Sales, Other Cash, On Order, & Deposits Received amounts are recalculated on reconciling Customers. The period balances are recalculated at this time as well. This table contains year to date, last year to date and life to date information for each customer. The records in this table are created when records in the RM_Customer_MSTR table are created. There should be one record in this table for every customer. Life to date information is kept up to date at all time; therefore year to date information should always be reflected in life to date fields
4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
TNSFCLIF numeric(19,5)
0.00
The lifeti...(more) Join Now
NONSFLIF int
0
Number of ...(more) Join Now
CUSTNMBR char(15)
''
Customer I...(more) Join Now
join ... more text available
CUSTBLNC numeric(19,5)
0.00
Current Cu...(more) Join Now B3910505.CUSTBLNC
AGPERAMT_1 numeric(19,5)
0.00

AGPERAMT_2 numeric(19,5)
0.00
Array fiel...(more) Join Now B3910505.AGPERAMT_2
AGPERAMT_3 numeric(19,5)
0.00

AGPERAMT_4 numeric(19,5)
0.00
Array fiel...(more) Join Now B3910505.AGPERAMT_4
AGPERAMT_5 numeric(19,5)
0.00

AGPERAMT_6 numeric(19,5)
0.00
Array fiel...(more) Join Now B3910505.AGPERAMT_6
AGPERAMT_7 numeric(19,5)
0.00

LASTAGED datetime
'1/1/1900'
The date t...(more) Join Now
FRSTINDT datetime
'1/1/1900'
The date o...(more) Join Now
LSTNSFCD datetime
'1/1/1900'
The last d...(more) Join Now
LPYMTAMT numeric(19,5)
0.00
The amount...(more) Join Now
LASTPYDT datetime
'1/1/1900'
The date o...(more) Join Now
LSTTRXDT datetime
'1/1/1900'
The date o...(more) Join Now
LSTTRXAM numeric(19,5)
0.00
The amount...(more) Join Now
LSTFCHAM numeric(19,5)
0.00
The financ...(more) Join Now
UPFCHYTD numeric(19,5)
0.00
Current ba...(more) Join Now
AVDTPLYR smallint
0
Average nu...(more) Join Now
AVDTPLIF smallint
0
Average nu...(more) Join Now
AVGDTPYR smallint
0
Average nu...(more) Join Now
NUMADTPL int
0
Number of ...(more) Join Now
NUMADTPY int
0
Number of ...(more) Join Now
NUMADTPR int
0
Number of ...(more) Join Now
TDTKNYTD numeric(19,5)
0.00
The dollar...(more) Join Now
TDTKNLYR numeric(19,5)
0.00
The dollar...(more) Join Now
TDTKNLTD numeric(19,5)
0.00
The dollar...(more) Join Now
TDISAYTD numeric(19,5)
0.00
The discou...(more) Join Now
RETAINAG numeric(19,5)
0.00
Dollar amo...(more) Join Now
TNSFCYTD numeric(19,5)
0.00
The YTD to...(more) Join Now
NONSFYTD int
0
Number of ...(more) Join Now
UNPSTDSA numeric(19,5)
0.00
Dollar Amo...(more) Join Now
UNPSTDCA numeric(19,5)
0.00
Dollar Amo...(more) Join Now
UNPSTOSA numeric(19,5)
0.00
N/A...(more) Join Now
UNPSTOCA numeric(19,5)
0.00
N/A...(more) Join Now
NCSCHPMT numeric(19,5)
0.00
Not used (...(more) Join Now
TTLSLYTD numeric(19,5)
0.00
Total doll...(more) Join Now
TTLSLLTD numeric(19,5)
0.00
Total doll...(more) Join Now
TTLSLLYR numeric(19,5)
0.00
Total doll...(more) Join Now
TCOSTYTD numeric(19,5)
0.00
Total COGS...(more) Join Now
TCOSTLTD numeric(19,5)
0.00
Total COGS...(more) Join Now
TCOSTLYR numeric(19,5)
0.00
Total COGS...(more) Join Now
TCSHRYTD numeric(19,5)
0.00
Total of t...(more) Join Now
TCSHRLTD numeric(19,5)
0.00
Total of t...(more) Join Now
TCSHRLYR numeric(19,5)
0.00
Total of t...(more) Join Now
TFNCHYTD numeric(19,5)
0.00
Finance ch...(more) Join Now
TFNCHLTD numeric(19,5)
0.00
Finance ch...(more) Join Now
TFNCHLYR numeric(19,5)
0.00
Finance ch...(more) Join Now
FNCHCYTD numeric(19,5)
0.00
Finance ch...(more) Join Now
FNCHLYRC numeric(19,5)
0.00
Finance ch...(more) Join Now
TBDDTYTD numeric(19,5)
0.00
N/A...(more) Join Now
TBDDTLYR numeric(19,5)
0.00
N/A...(more) Join Now
TBDDTLTD numeric(19,5)
0.00
N/A...(more) Join Now
TWVFCYTD numeric(19,5)
0.00
Finance ch...(more) Join Now
TWVFCLTD numeric(19,5)
0.00
Finance ch...(more) Join Now
TWVFCLYR numeric(19,5)
0.00
Finance ch...(more) Join Now
TWROFYTD numeric(19,5)
0.00
Dollar amo...(more) Join Now
TWROFLTD numeric(19,5)
0.00
Dollar amo...(more) Join Now
TWROFLYR numeric(19,5)
0.00
Dollar amo...(more) Join Now
TTLINYTD int
0
Number of ...(more) Join Now
TTLINLTD int
0
Number of ...(more) Join Now
TTLINLYR int
0
Number of ...(more) Join Now
TTLFCYTD int
0
Number of ...(more) Join Now
TTLFCLTD int
0
Number of ...(more) Join Now
TTLFCLYR int
0
Number of ...(more) Join Now
WROFSLIF numeric(19,5)
0.00
Write Offs...(more) Join Now
WROFSLYR numeric(19,5)
0.00
Amount wri...(more) Join Now
WROFSYTD numeric(19,5)
0.00
Amount wri...(more) Join Now
HIBALLYR numeric(19,5)
0.00
Highest Ba...(more) Join Now
HIBALYTD numeric(19,5)
0.00
Highest Ba...(more) Join Now
HIBALLTD numeric(19,5)
0.00
Highest Ba...(more) Join Now
LASTSTDT datetime
'1/1/1900'
Date last ...(more) Join Now
LSTSTAMT numeric(19,5)
0.00
Dollar amo...(more) Join Now
DEPRECV numeric(19,5)
0.00

ONORDAMT numeric(19,5)
0.00
Dollar amo...(more) Join Now
TTLRTYTD numeric(19,5)
0.00
Total retu...(more) Join Now
TTLRTLTD numeric(19,5)
0.00
Total retu...(more) Join Now
TTLRTLYR numeric(19,5)
0.00
Total retu...(more) Join Now
DEX_ROW_ID int
auto number (1,1)
Unique ide...(more) Join Now
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3