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
DynDeveloper.com

DynDeveloper.com

Sign Up Now!Log In
Module List > Module PM tables > PM40100

DynDeveloper Table Reference is in Wiki format! Registered users have the ability to improve the table reference, add comments, and generally make the world a better place.
You are currently viewing the COMPANY database.
Change

COMPANY..PM40100 Table Definition

(COMPANY..PM Setup File)

4Penny.net

Field Definitions:

What is the 'source' column?

Column NameData Type
Default Value
 Source
UNIQKEY char(1)
''

ADUPINNM smallint
0
Allow dupl...(more) Join Now
OVVCHNUM tinyint
0

TRKDISAV tinyint
0

PRTHATRB tinyint
0

AGEBY smallint
0

APPLYBY smallint
0

RMVNDHPW char(11)
''

RMVTRHPW char(11)
''

XCDMINPW char(11)
''

WROFPSWD char(11)
''

NTVCHNUM char(17)
''
Next Vouch...(more) Join Now
PMNPYNBR char(21)
''

NXTVNDID char(15)
''

USRDFPR1 char(15)
''

USRDRPR2 char(15)
''

PMTRXDSC_1 char(21)
''

PMTRXDSC_2 char(21)
''

PMTRXDSC_3 char(21)
''

PMTRXDSC_4 char(21)
''

PMTRXDSC_5 char(21)
''

PMTRXDSC_6 char(21)
''

PMTRXDSC_7 char(21)
''

PMTRXDSC_8 char(21)
''

PMTRXABR_1 char(3)
''

PMTRXABR_2 char(3)
''

PMTRXABR_3 char(3)
''

PMTRXABR_4 char(3)
''

PMTRXABR_5 char(3)
''

PMTRXABR_6 char(3)
''

PMTRXABR_7 char(3)
''

PMTRXABR_8 char(3)
''

CHEKBKID char(15)
''
Checkbook ID Checkbook this transaction affects SY30500.CHEKBKID
join ... more text available
PCHSCHID char(15)
''
Purchase S...(more) Join Now
FRTSCHID char(15)
''
Freight ...(more) Join Now
join ... more text available
MSCSCHID char(15)
''
Misc Sched...(more) Join Now
join ... more text available
LSTYECAL datetime
'1/1/1900'

LSTYEFSC datetime
'1/1/1900'

Check_Format_Default smallint
0

Check_Stub_Default smallint
0

PRNTPRVSLYAPPLDDCS tinyint
0

DelUPDoc tinyint
0

PrntTaxDetDoc tinyint
0

DateSensitivitySumView smallint
0

PRNTDCUR tinyint
0

AGEUNAPPLDCR tinyint
0

PMNXTSCHDNBR char(21)
''

ExcludeExprdDiscntsPymnt tinyint
0

PMDefaultCheckSort smallint
0

DEX_ROW_ID int
auto number (1,1)
Unique ide...(more) Join Now
WarnIfVenHasExistingPO 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