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

COMPANY..PM09200 Table Definition

(COMPANY..)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value		 Source
VENDORID char(15)
''
Vendor ID:...(more) Join Now
join ... more text available
VENDNAME char(65)
''
Vendor Nam...(more) Join Now POP10100.VENDNAME
VNDCHKNM char(65)
''
Vendor Che...(more) Join Now PM20000.VNDCHKNM
VENDSHNM char(15)
''
Vendor Sho...(more) Join Now
VADDCDPR char(15)
''
Vendor Add...(more) Join Now PM10000.VADDCDPR
VADCDPAD char(15)
''
Vendor Add...(more) Join Now POP10100.VADCDPAD
VADCDSFR char(15)
''
Vendor Add...(more) Join Now PM00200.VADCDSFR
VADCDTRO char(15)
''
Vendor Add...(more) Join Now
VNDCLSID char(11)
''
Vendor Cla...(more) Join Now PM00200.VNDCLSID
VNDCNTCT char(31)
''
Vendor Con...(more) Join Now PM00200.VNDCNTCT
ADDRESS1 char(31)
''
Address 1:...(more) Join Now RM00101.ADDRESS1
ADDRESS2 char(31)
''
Address 2:...(more) Join Now RM00101.ADDRESS2
ADDRESS3 char(31)
''
Address 3:...(more) Join Now RM00101.ADDRESS3
CITY char(31)
''
City: City...(more) Join Now RM00101.CITY
STATE char(29)
''
State: Up...(more) Join Now RM00101.STATE
ZIPCODE char(11)
''
Zip Code: ...(more) Join Now SOP10100.ZIPCODE
COUNTRY char(21)
''
Country: C...(more) Join Now RM00101.COUNTRY
PHNUMBR1 char(21)
''
Phone Numb...(more) Join Now SOP10100.PHNUMBR1
PHNUMBR2 char(21)
''
Phone Numb...(more) Join Now SOP10100.PHNUMBR2
PHONE3 char(21)
''
Phone 3: ...(more) Join Now RM00101.PHONE3
FAXNUMBR char(21)
''
Fax Number...(more) Join Now SOP10100.FAXNUMBR
UPSZONE char(3)
''
UPS Zone: ...(more) Join Now RM00101.UPSZONE
SHIPMTHD char(15)
''
Shipping M...(more) Join Now
join ... more text available
TAXSCHID char(15)
''
Tax Schedu...(more) Join Now PM10000.TAXSCHID
join ... more text available
ACNMVNDR char(21)
''
Account Nu...(more) Join Now PM00200.ACNMVNDR
TXIDNMBR char(11)
''
Tax ID Num...(more) Join Now PM00200.TXIDNMBR
VENDSTTS smallint
0
Vendor Sta...(more) Join Now PM00200.VENDSTTS
CURNCYID char(15)
''
Currency I...(more) Join Now
join ... more text available
TXRGNNUM char(25)
''
Tax Regist...(more) Join Now RM00101.TXRGNNUM
PARVENID char(15)
''
Parent Ven...(more) Join Now PM00200.PARVENID
TRDDISCT smallint
0
Trade Disc...(more) Join Now RM10301.TRDDISCT
TEN99TYPE smallint
0
1099 Type:...(more) Join Now
MINORDER numeric(19,5)
0.00
Minimum Or...(more) Join Now
PYMTRMID char(21)
''
Payment Te...(more) Join Now PM10000.PYMTRMID
SY033... more text available
MINPYTYP smallint
0
Minimum ...(more) Join Now RM00101.MINPYTYP
MINPYPCT smallint
0
Finance Ch...(more) Join Now RM00101.MINPYPCT
MINPYDLR numeric(19,5)
0.00
Minimum Pa...(more) Join Now
MXIAFVND smallint
0
Maximum In...(more) Join Now PM00200.MXIAFVND
MAXINDLR numeric(19,5)
0.00
Maximum In...(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
USERDEF2 char(21)
''
UserDefine...(more) Join Now
CRLMTDLR numeric(19,5)
0.00
Credit Lim...(more) Join Now
PYMNTPRI char(3)
''
Payment Pr...(more) Join Now PM00200.PYMNTPRI
KPCALHST tinyint
0
Keep Calen...(more) Join Now RM00101.KPCALHST
KGLDSTHS tinyint
0
Keep GL Di...(more) Join Now PM00200.KGLDSTHS
KPERHIST tinyint
0
Keep Perio...(more) Join Now RM00101.KPERHIST
KPTRXHST tinyint
0
Keep Trx H...(more) Join Now RM00101.KPTRXHST
HOLD tinyint
0
Hold: 1 i...(more) Join Now RM00101.HOLD
PTCSHACF smallint
0
Post To Ca...(more) Join Now PM00200.PTCSHACF
CREDTLMT smallint
0
Credit Lim...(more) Join Now PM00200.CREDTLMT
WRITEOFF smallint
0
Writeoff: ...(more) Join Now PM00200.WRITEOFF
MXWOFAMT numeric(19,5)
0.00
Maximum Wr...(more) Join Now
SBPPSDED tinyint
0
Subject to...(more) Join Now PM00200.SBPPSDED
PPSTAXRT smallint
0
PPS Tax Ra...(more) Join Now
DXVARNUM char(25)
''
Deduction ...(more) Join Now PM00200.DXVARNUM
CRTCOMDT datetime
'1/1/1900'
Certificat...(more) Join Now PM00200.CRTCOMDT
CRTEXPDT datetime
'1/1/1900'
Certificat...(more) Join Now PM00200.CRTEXPDT
RTOBUTKN tinyint
0
Reporting ...(more) Join Now PM00200.RTOBUTKN
XPDTOBLG tinyint
0
Expiration...(more) Join Now PM00200.XPDTOBLG
PRSPAYEE tinyint
0
Prescribed...(more) Join Now PM00200.PRSPAYEE
PM_AP_String char(129)
''

PM_Cash_String char(129)
''

PM_Discount_Available_St char(129)
''

PM_Discount_Taken_String char(129)
''

PM_Finance_Charge_String char(129)
''

PM_Misc_Charges_String char(129)
''

PM_Freight_String char(129)
''

PM_Tax_String char(129)
''

PM_Write_Offs_String char(129)
''

PM_Purchases_String char(129)
''

PM_Retainage_String char(129)
''

PM_Trade_Discount_String char(129)
''

Accrued_Purchases_String char(129)
''

Purchase_Price_Variance_ char(129)
''

CHEKBKID char(15)
''
Checkbook ID Checkbook this transaction affects SY30500.CHEKBKID
join ... more text available
MODIFDT datetime
'1/1/1900'
Date the r...(more) Join Now
CREATDDT datetime
'1/1/1900'
Created Da...(more) Join Now RM00101.CREATDDT
RATETPID char(15)
''
A valid Ra...(more) Join Now
Revalue_Vendor tinyint
0
Revalue Ve...(more) Join Now PM00200.Revalue_Vendor
Post_Results_To smallint
0
Post Resul...(more) Join Now RM00101.Post_Results_To
FREEONBOARD smallint
0
Free On Bo...(more) Join Now IV00103.FREEONBOARD
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
TaxInvRecvd tinyint
0
Tax Invoic...(more) Join Now POP30300.TaxInvRecvd
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
DISCDTDS smallint
0

USEGRPER tinyint
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