DynDeveloper.com

DynDeveloper.com
Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now! Log In
Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our SOP scripts. All of our scripts for Dynamics GP can be found here
Module List > Module RM tables RM40101
You are currently viewing the COMPANY database.
Change

COMPANY..RM40101 Table Definition

(COMPANY..RM Module Setup File)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value		 Source
SETUPKEY smallint
0
Setup Key...(more) Join Now IV40100.SETUPKEY
AGEBY smallint
0

AGPEREND_1 smallint
0

AGPEREND_2 smallint
0

AGPEREND_3 smallint
0

AGPEREND_4 smallint
0

AGPEREND_5 smallint
0

AGPEREND_6 smallint
0

AGPEREND_7 smallint
0

AGPERUSD smallint
0

CRLMPSWD char(11)
''

CUSTHPWD char(11)
''

WRTFPSWD char(11)
''

WVFCHPWD char(11)
''

PRTHATRB tinyint
0

CPDFINCH tinyint
0

RMTRKDAV tinyint
0

RMPCAIPD tinyint
0

NSFCHDEF numeric(19,5)
0.00

APLBYDEF smallint
0

LDFNCHGD datetime
'1/1/1900'

LDSTPRTD datetime
'1/1/1900'

LDBLFAGD datetime
'1/1/1900'

LDOITAGD datetime
'1/1/1900'

LDPTRRMV datetime
'1/1/1900'

LSTYECAL datetime
'1/1/1900'

LSTYEFSC datetime
'1/1/1900'

USRDFPR1 char(15)
''

USRDRPR2 char(15)
''

FRTSCHID char(15)
''
Freight Sc...(more) Join Now
join ... more text available
SLSCHDID char(15)
''
Sales Sche...(more) Join Now RM20101.SLSCHDID
MSCSCHID char(15)
''
Misc Sched...(more) Join Now RM20101.MSCSCHID
join ... more text available
CHEKBKID char(15)
''
Checkbook ID Checkbook this transaction affects SY30500.CHEKBKID
join ... more text available
SALESCB tinyint
0

DISCNTCB tinyint
0

FREIGHT tinyint
0

MISC tinyint
0

TAX tinyint
0

RMVDSTTY_1 binary(4)
0

RMVDSTTY_2 binary(4)
0

RMVDSTTY_3 binary(4)
0

RMVDSTTY_4 binary(4)
0

RMVDSTTY_5 binary(4)
0

RMVDSTTY_6 binary(4)
0

RMVDSTTY_7 binary(4)
0

RMVDSTTY_8 binary(4)
0

RMVDSTTY_9 binary(4)
0

LDCMTRNS datetime
'1/1/1900'

PRCLEVEL char(11)
''
Price Leve...(more) Join Now RM00101.PRCLEVEL
RMDFTyp smallint
0

DelUPDoc tinyint
0

PrntTaxDetDoc tinyint
0

RPRNTSTTMNTS tinyint
0

ATAPPLFNNCCHRGSFRST tinyint
0

EmailStmtStatusRecipient char(81)
''

DateSensitivitySumView smallint
0

PRNTDCUR tinyint
0

AGEUNAPPLDCR tinyint
0

WriteoffCreditMemoNumber char(21)
''

WriteoffDebitMemoNumber char(21)
''

USRDRPR3 char
''

DEX_ROW_ID int
auto number (1,1)
 Unique ide...(more) Join Now
USRDRPR4 char
''

DisplayOverCreditIcon tinyint
0

DisplayOverCreditWarning tinyint
0

Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
Archives | Table Listing | eConnect Error Database | eConnect Schema | Gold Star Locksmith
3