DynDeveloper.com

DynDeveloper.com

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

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..PM80950 Table Definition

(COMPANY..PM Remittance Temp)

4Penny.net

Field Definitions:

What is the 'source' column?

* the version information goes back to GP 9
Column NameData Type SourceFirst Version
BACHNUMBchar(15) Batch Numb...(more) Join Now
GP 2010
join SY00500 on SY00500.BACHNUMB = PM80950.BACHNUMB
BCHSOURCchar(15) Batch Sour...(more) Join Now
GP 2010
PMNTNMBRchar(21) Payment Nu...(more) Join Now CM20300.PMNTNMBR
GP 2010
SEQNUMBRint Sequence N...(more) Join Now DTA10200.SEQNUMBR
GP 2010
DOCDATEdatetime The date a...(more) Join Now
GP 2010
DOCNUMBRchar(21) Document N...(more) Join Now PM10000.DOCNUMBR
GP 2010
VENDORIDchar(15) Vendor ID:...(more) Join Now
GP 2010
join PM00200 on PM00200.VENDORID = PM80950.VENDORID
VENDNAMEchar(65) Vendor Nam...(more) Join Now POP10100.VENDNAME
GP 2010
VNDCHKNMchar(65) Vendor Che...(more) Join Now PM20000.VNDCHKNM
GP 2010
CURNCYIDchar(15) Currency I...(more) Join Now
GP 2010
join DYNAMICS..MC40200 on MC40200.CURNCYID = PM80950.CURNCYID
VOIDEDtinyint Voided TRU...(more) Join Now CM20100.VOIDED
GP 2010
DOCTYPEsmallint Document T...(more) Join Now
GP 2010
CHKCOMNTchar(61)
GP 2010
USERIDchar(15) The user t...(more) Join Now
GP 2010
join DYNAMICS..SY01400 on SY01400.USERID = PM80950.USERID
SEPRMTNCtinyint Separate R...(more) Join Now SY00500.SEPRMTNC
GP 2010
ERRORsmallint
GP 2010
Email_Typesmallint 1 – ...(more) Join Now RM00106.Email_Type
GP 2010
DEX_ROW_IDint Unique aut...(more) Join Now
GP 2010
DOCAMNTnumeric PAM50905.DOCAMNT
GP 2013
PYMTTYPEsmallint Payment Ty...(more) Join Now SOP30201.PYMTTYPE
GP 2013
Electronictinyint
GP 2013