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 RM09101
You are currently viewing the COMPANY database.
Change

COMPANY..RM09101 Table Definition

(COMPANY..)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value		 Source
CUSTNMBR char(15)
''
Customer I...(more) Join Now
join ... more text available
CUSTNAME char(65)
''
Customer N...(more) Join Now RM10301.CUSTNAME
CUSTCLAS char(15)
''
Customer C...(more) Join Now RM00101.CUSTCLAS
CPRCSTNM char(15)
''
Corporate ...(more) Join Now RM00101.CPRCSTNM
CNTCPRSN char(31)
''
Contact Pe...(more) Join Now RM00101.CNTCPRSN
STMTNAME char(65)
''
Statement ...(more) Join Now RM00101.STMTNAME
SHRTNAME char(15)
''
Short Name...(more) Join Now RM00101.SHRTNAME
ADRSCODE char(15)
''
Address Co...(more) Join Now RM20101.ADRSCODE
UPSZONE char(3)
''
UPS Zone: ...(more) Join Now RM00101.UPSZONE
SHIPMTHD char(15)
''
Shipping M...(more) Join Now RM20101.SHIPMTHD
join ... more text available
TAXSCHID char(15)
''
Tax Schedu...(more) Join Now PM10000.TAXSCHID
join ... more text available
ADDRESS1 char(31)
''
Address li...(more) Join Now
ADDRESS2 char(31)
''
Address li...(more) Join Now
ADDRESS3 char(31)
''
Address li...(more) Join Now
COUNTRY char(21)
''
Country: C...(more) Join Now RM00101.COUNTRY
CITY char(31)
''
City: City...(more) Join Now RM00101.CITY
STATE char(29)
''
4 characte...(more) Join Now
ZIP char(11)
''

PHONE1 char(21)
''
10 digit p...(more) Join Now
PHONE2 char(21)
''
Phone 2: ...(more) Join Now RM00101.PHONE2
PHONE3 char(21)
''
Phone 3: ...(more) Join Now
FAX char(21)
''
Fax: Same...(more) Join Now RM00101.FAX
PRBTADCD char(15)
''
Primary Bi...(more) Join Now RM00101.PRBTADCD
join ... more text available
PRSTADCD char(15)
''
Primary Sh...(more) Join Now RM00101.PRSTADCD
join ... more text available
STADDRCD char(15)
''
Statement ...(more) Join Now RM00101.STADDRCD
SLPRSNID char(15)
''
The salesp...(more) Join Now
join ... more text available
CHEKBKID char(15)
''
Checkbook ID Checkbook this transaction affects SY30500.CHEKBKID
join ... more text available
PYMTRMID char(21)
''
Payment Te...(more) Join Now
SY033... more text available
CRLMTTYP smallint
0
Credit Lim...(more) Join Now
CRLMTAMT numeric(19,5)
0.00
Credit Lim...(more) Join Now
CRLMTPER smallint
0
Credit Lim...(more) Join Now RM00101.CRLMTPER
CRLMTPAM numeric(19,5)
0.00
Credit Lim...(more) Join Now
CURNCYID char(15)
''
Currency I...(more) Join Now
join ... more text available
RATETPID char(15)
''
A valid Ra...(more) Join Now
CUSTDISC smallint
0
Customer D...(more) Join Now RM00101.CUSTDISC
PRCLEVEL char(11)
''
Price Leve...(more) Join Now RM00101.PRCLEVEL
MINPYTYP smallint
0
Minimum ...(more) Join Now RM00101.MINPYTYP
MINPYDLR numeric(19,5)
0.00
Minimum Pa...(more) Join Now
MINPYPCT smallint
0
Finance Ch...(more) Join Now RM00101.MINPYPCT
FNCHATYP smallint
0
Finance Ch...(more) Join Now
FNCHPCNT smallint
0
Finance Ch...(more) Join Now RM00101.FNCHPCNT
FINCHDLR numeric(19,5)
0.00
Maximum Wr...(more) Join Now
MXWOFTYP smallint
0
Max Writeo...(more) Join Now RM00101.MXWOFTYP
MXWROFAM numeric(19,5)
0.00
Comment 1:...(more) Join Now
COMMENT1 char(31)
''
Comment 1:...(more) Join Now RM00101.COMMENT1
COMMENT2 char(31)
''
Comment 2:...(more) Join Now RM00101.COMMENT2
USERDEF1 char(21)
''
UserDefine...(more) Join Now CM20200.USERDEF1
USERDEF2 char(21)
''
UserDefine...(more) Join Now CM20200.USERDEF2
TAXEXMT1 char(25)
''
Tax Exempt...(more) Join Now RM00101.TAXEXMT1
TAXEXMT2 char(25)
''
Tax Exempt...(more) Join Now RM00101.TAXEXMT2
TXRGNNUM char(25)
''
Tax Regist...(more) Join Now RM00101.TXRGNNUM
BALNCTYP smallint
0
Balance Ty...(more) Join Now RM00101.BALNCTYP
STMTCYCL smallint
0
Statement ...(more) Join Now RM00101.STMTCYCL
BANKNAME char(31)
''
Bank Name:...(more) Join Now RM00101.BANKNAME
BNKBRNCH char(21)
''
Bank Branc...(more) Join Now RM00101.BNKBRNCH
SALSTERR char(15)
''
Territory ...(more) Join Now
join ... more text available
DEFCACTY smallint
0
Default Ca...(more) Join Now RM00101.DEFCACTY
RM_Cash_Account_String char(129)
''

RM_AR_Account_String char(129)
''

RM_Sales_Account_String char(129)
''

RM_IV_Account_String char(129)
''

RM_Cost_Of_Sales_Account char(129)
''

RM_Discounts_Taken_Accou char(129)
''

RM_Discounts_Avail_Accou char(129)
''

RM_Finance_Charge_Accoun char(129)
''

RM_Writeoff_Account_Stri char(129)
''

FRSTINDT datetime
'1/1/1900'
The date o...(more) Join Now
INACTIVE tinyint
0
1 if inact...(more) Join Now
HOLD tinyint
0
Hold: 1 i...(more) Join Now RM00101.HOLD
CRCARDID char(15)
''
Credit Car...(more) Join Now RM00101.CRCARDID
CRCRDNUM char(21)
''
Credit Car...(more) Join Now RM00101.CRCRDNUM
CCRDXPDT datetime
'1/1/1900'
Credit Car...(more) Join Now RM00101.CCRDXPDT
KPDSTHST tinyint
0
Keep Distr...(more) Join Now RM00101.KPDSTHST
KPCALHST tinyint
0
1 to keep ...(more) Join Now
KPERHIST tinyint
0
1 to keep ...(more) Join Now
KPTRXHST tinyint
0
Keep Trx H...(more) Join Now RM00101.KPTRXHST
CREATDDT datetime
'1/1/1900'
Date this ...(more) Join Now
MODIFDT datetime
'1/1/1900'
Date the r...(more) Join Now
Revalue_Customer tinyint
0
Revalue Cu...(more) Join Now RM00101.Revalue_Customer
Post_Results_To smallint
0
Post Resul...(more) Join Now RM00101.Post_Results_To
FINCHID char(15)
''
Finance Ch...(more) Join Now RM00101.FINCHID
GOVCRPID char(31)
''
Government...(more) Join Now RM00101.GOVCRPID
GOVINDID char(31)
''
Government...(more) Join Now RM00101.GOVINDID
DISGRPER smallint
0
Discount G...(more) Join Now RM10301.DISGRPER
DUEGRPER smallint
0
Due Date G...(more) Join Now RM10301.DUEGRPER
DOCFMTID char(15)
''
Document F...(more) Join Now RM00101.DOCFMTID
DUETYPE smallint
0

DUEDTDS smallint
0

DISCTYPE smallint
0
=1 if Days...(more) Join Now SY03300.DISCTYPE
DSCLCTYP smallint
0

DSCPCTAM smallint
0
Discount P...(more) Join Now RM20101.DSCPCTAM
DSCDLRAM numeric(19,5)
0.00
Discount D...(more) Join Now PM10000.DSCDLRAM
DISCDTDS smallint
0

Imported_Date datetime
'1/1/1900'

Imported_Time datetime
'1/1/1900'

Migrated tinyint
0

Migrated_Date datetime
'1/1/1900'

Migrated_Time datetime
'1/1/1900'

ERRDESCR char(131)
''

UMA_Text_Field char(255)
''

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
Archives | Table Listing | eConnect Error Database | eConnect Schema | Gold Star Locksmith
3