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

COMPANY..SVRMA101 Table Definition

(COMPANY..)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value		 Source
CUSTNMBR char(15)

 Field Type...(more) Join Now
join ... more text available
CUSTNAME char(65)

 Field Type...(more) Join Now
CUSTCLAS char(15)

 Field Type...(more) Join Now
CPRCSTNM char(15)

 Corporate ...(more) Join Now RM00101.CPRCSTNM
CNTCPRSN char(61)

 Field Type...(more) Join Now
STMTNAME char(65)

 Statement ...(more) Join Now RM00101.STMTNAME
SHRTNAME char(15)

 Short Name...(more) Join Now RM00101.SHRTNAME
ADRSCODE char(15)

 Field Type...(more) Join Now
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)
join ... more text available
ADDRESS1 char(61)

 Field Type...(more) Join Now
ADDRESS2 char(61)

 Field Type...(more) Join Now
ADDRESS3 char(61)

 Field Type...(more) Join Now
COUNTRY char(61)

 Field Type...(more) Join Now
CITY char(35)

 Field Type...(more) Join Now
STATE char(29)

 Field Type...(more) Join Now
ZIP char(11)

 Field Type...(more) Join Now
PHONE1 char(21)

 Field Type...(more) Join Now
PHONE2 char(21)

 Field Type...(more) Join Now
PHONE3 char(21)

 Phone 3: ...(more) Join Now RM00101.PHONE3
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)

 Field Type...(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

 Credit Lim...(more) Join Now RM00101.CRLMTTYP
CRLMTAMT numeric(19,5)

 Credit Lim...(more) Join Now RM00101.CRLMTAMT
CRLMTPER smallint

 Credit Lim...(more) Join Now RM00101.CRLMTPER
CRLMTPAM numeric(19,5)

 Credit Lim...(more) Join Now RM00101.CRLMTPAM
CURNCYID char(15)

 Field Type...(more) Join Now
join ... more text available
RATETPID char(15)

 Field Type...(more) Join Now
CUSTDISC smallint

 Customer D...(more) Join Now RM00101.CUSTDISC
PRCLEVEL char(11)

 Field Type...(more) Join Now
MINPYTYP smallint

 Minimum ...(more) Join Now RM00101.MINPYTYP
MINPYDLR numeric(19,5)

 Minimum Pa...(more) Join Now RM00101.MINPYDLR
MINPYPCT smallint

 Finance Ch...(more) Join Now RM00101.MINPYPCT
FNCHATYP smallint

 Finance Ch...(more) Join Now RM00101.FNCHATYP
FNCHPCNT smallint

 Finance Ch...(more) Join Now RM00101.FNCHPCNT
FINCHDLR numeric(19,5)

 Maximum Wr...(more) Join Now RM00101.FINCHDLR
MXWOFTYP smallint

 Max Writeo...(more) Join Now RM00101.MXWOFTYP
MXWROFAM numeric(19,5)

 Comment 1:...(more) Join Now RM00101.MXWROFAM
COMMENT1 char(31)

 Comment 1:...(more) Join Now RM00101.COMMENT1
COMMENT2 char(31)

 Comment 2:...(more) Join Now RM00101.COMMENT2
USERDEF1 char(21)

 Field Type...(more) Join Now
USERDEF2 char(21)

 Field Type...(more) Join Now
TAXEXMT1 char(25)

 Field Type...(more) Join Now
TAXEXMT2 char(25)

 Field Type...(more) Join Now
TXRGNNUM char(25)

 Tax Regist...(more) Join Now RM00101.TXRGNNUM
BALNCTYP smallint

 Balance Ty...(more) Join Now RM00101.BALNCTYP
STMTCYCL smallint

 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)

 Sales Terr...(more) Join Now RM10301.SALSTERR
join ... more text available
DEFCACTY smallint

 Default Ca...(more) Join Now RM00101.DEFCACTY
RMCSHACC int

 RM Cash ...(more) Join Now RM00101.RMCSHACC
RMARACC int

 RM AR Ac...(more) Join Now RM00101.RMARACC
RMSLSACC int

 RM Sales ...(more) Join Now RM00101.RMSLSACC
RMIVACC int

 RM Cost of...(more) Join Now RM00101.RMIVACC
RMCOSACC int

 RM Discoun...(more) Join Now RM00101.RMCOSACC
RMTAKACC int

 RM Discoun...(more) Join Now RM00101.RMTAKACC
RMAVACC int

 RM Discoun...(more) Join Now RM00101.RMAVACC
RMFCGACC int

 RM Finance...(more) Join Now RM00101.RMFCGACC
RMWRACC int

 RM Writeof...(more) Join Now RM00101.RMWRACC
RMSORACC int

 RM Sales O...(more) Join Now RM00101.RMSORACC
FRSTINDT datetime

 First Invo...(more) Join Now RM00101.FRSTINDT
INACTIVE tinyint

 Inactive: ...(more) Join Now RM00101.INACTIVE
HOLD tinyint

 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

 Credit Car...(more) Join Now RM00101.CCRDXPDT
KPDSTHST tinyint

 Keep Distr...(more) Join Now RM00101.KPDSTHST
KPCALHST tinyint

 Keep Calen...(more) Join Now RM00101.KPCALHST
KPERHIST tinyint

 Keep Perio...(more) Join Now RM00101.KPERHIST
KPTRXHST tinyint

 Keep Trx H...(more) Join Now RM00101.KPTRXHST
NOTEINDX numeric(19,5)

 Note Index...(more) Join Now
join ... more text available
CREATDDT datetime

 Field Type...(more) Join Now
MODIFDT datetime

 Date the r...(more) Join Now
Revalue_Customer tinyint

 Revalue Cu...(more) Join Now RM00101.Revalue_Customer
Post_Results_To smallint

 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

 Discount G...(more) Join Now RM10301.DISGRPER
DUEGRPER smallint

 Due Date G...(more) Join Now RM10301.DUEGRPER
DOCFMTID char(15)

 Document F...(more) Join Now RM00101.DOCFMTID
Send_Email_Statements tinyint

 Send Email...(more) Join Now RM00101.Send_Email_Statements
USERLANG smallint

 User Langu...(more) Join Now RM00101.USERLANG
GPSFOINTEGRATIONID char(31)

 GPSFO Inte...(more) Join Now RM00101.GPSFOINTEGRATIONID
INTEGRATIONSOURCE smallint

 Integratio...(more) Join Now RM00101.INTEGRATIONSOURCE
INTEGRATIONID char(31)

 Integratio...(more) Join Now RM00101.INTEGRATIONID
ORDERFULFILLDEFAULT smallint

 Order Fulf...(more) Join Now RM00101.ORDERFULFILLDEFAULT
CUSTPRIORITY smallint

 Customer P...(more) Join Now RM00101.CUSTPRIORITY
CCode char(7)

 Country Co...(more) Join Now RM00101.CCode
DECLID char(15)

 Declarant ...(more) Join Now RM00101.DECLID
RMOvrpymtWrtoffAcctIdx int

 RM Overpay...(more) Join Now RM00101.RMOvrpymtWrtoffAcctIdx
SHIPCOMPLETE tinyint

 Ship Compl...(more) Join Now RM00101.SHIPCOMPLETE
CBVAT tinyint

 Cash Based...(more) Join Now RM00101.CBVAT
INCLUDEINDP tinyint

 Include in...(more) Join Now RM00101.INCLUDEINDP
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