DynDeveloper.com

DynDeveloper.com

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

DynDeveloper Table Reference is now in Wiki format! Registered users have the ability to improve the table reference, add comments, and 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?

* the version information goes back to GP 9
Column NameData Type SourceFirst Version
UNIQKEYchar(1) PAM40401.UNIQKEY
GP 9
ADUPINNMsmallint Allow dupl...(more) Join Now
GP 9
OVVCHNUMtinyint
GP 9
TRKDISAVtinyint
GP 9
PRTHATRBtinyint
GP 9
AGEBYsmallint
GP 9
APPLYBYsmallint
GP 9
RMVNDHPWchar(11)
GP 9
RMVTRHPWchar(11)
GP 9
XCDMINPWchar(11)
GP 9
WROFPSWDchar(11)
GP 9
NTVCHNUMchar(17) Next Vouch...(more) Join Now
GP 9
PMNPYNBRchar(21)
GP 9
NXTVNDIDchar(15)
GP 9
USRDFPR1char(15) PAM40119.USRDFPR1
GP 9
USRDRPR2char(15) PAM40119.USRDRPR2
GP 9
PMTRXDSC_1char(21)
GP 9
PMTRXDSC_2char(21)
GP 9
PMTRXDSC_3char(21)
GP 9
PMTRXDSC_4char(21)
GP 9
PMTRXDSC_5char(21)
GP 9
PMTRXDSC_6char(21)
GP 9
PMTRXDSC_7char(21)
GP 9
PMTRXDSC_8char(21)
GP 9
PMTRXABR_1char(3)
GP 9
PMTRXABR_2char(3)
GP 9
PMTRXABR_3char(3)
GP 9
PMTRXABR_4char(3)
GP 9
PMTRXABR_5char(3)
GP 9
PMTRXABR_6char(3)
GP 9
PMTRXABR_7char(3)
GP 9
PMTRXABR_8char(3)
GP 9
CHEKBKIDchar(15) Checkbook ID Checkbook this transaction affects PAM22222.CHEKBKID
GP 9
join CM00100 on CM00100.CHEKBKID = PM40100.CHEKBKID
PCHSCHIDchar(15) Purchase S...(more) Join Now
GP 9
FRTSCHIDchar(15) Freight ...(more) Join Now
GP 9
join TX00101 on TX00101.FRTSCHID = PM40100.FRTSCHID
MSCSCHIDchar(15) Misc Sched...(more) Join Now
GP 9
join TX00101 on TX00101.MSCSCHID = PM40100.MSCSCHID
LSTYECALdatetime
GP 9
LSTYEFSCdatetime
GP 9
Check_Format_Defaultsmallint
GP 9
Check_Stub_Defaultsmallint
GP 9
PRNTPRVSLYAPPLDDCStinyint
GP 9
DelUPDoctinyint
GP 9
PrntTaxDetDoctinyint
GP 9
DateSensitivitySumViewsmallint
GP 9
PRNTDCURtinyint
GP 9
AGEUNAPPLDCRtinyint
GP 9
PMNXTSCHDNBRchar(21)
GP 9
ExcludeExprdDiscntsPymnttinyint
GP 2010
PMDefaultCheckSortsmallint
GP 2013
DEX_ROW_IDint Unique aut...(more) Join Now
GP 9
WarnIfVenHasExistingPOtinyint
GP 2013