DynDeveloper.com

DynDeveloper.com

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

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

(COMPANY..PM Distribution OPEN OPEN Temporary File)

4Penny.net

Field Definitions:

What is the 'source' column?

* the version information goes back to GP 9
Column NameData Type SourceFirst Version
KEYSOURCchar(41)
GP 9
VCHRNMBRchar(21) Voucher Nu...(more) Join Now
GP 9
DOCTYPEsmallint Document T...(more) Join Now
GP 9
DSTSQNUMint Distributi...(more) Join Now CM20400.DSTSQNUM
GP 9
CRDTAMNTnumeric(19,5) Credit Amo...(more) Join Now GL10001.CRDTAMNT
GP 9
DEBITAMTnumeric(19,5) Debit Amou...(more) Join Now GL10001.DEBITAMT
GP 9
DSTINDXint B3950350.DSTINDX
GP 9
DISTTYPEsmallint Distributi...(more) Join Now
GP 9
APTVCHNMchar(21)
GP 9
APTODCTYsmallint
GP 9
CHANGEDtinyint Changed Se...(more) Join Now POP10140.CHANGED
GP 9
USERIDchar(15) The user t...(more) Join Now
GP 9
join DYNAMICS..SY01400 on SY01400.USERID = PM20200.USERID
PSTGSTUSsmallint Posting St...(more) Join Now
GP 9
GLPOSTDTdatetime Date that ...(more) Join Now
GP 9
CURNCYIDchar(15) Currency I...(more) Join Now
GP 9
join DYNAMICS..MC40200 on MC40200.CURNCYID = PM20200.CURNCYID
CURRNIDXsmallint Currency I...(more) Join Now
GP 9
join DYNAMICS..MC40200 on MC40200.CURRNIDX = PM20200.CURRNIDX
ORCRDAMTnumeric(19,5) Originatin...(more) Join Now GL10001.ORCRDAMT
GP 9
ORDBTAMTnumeric(19,5) Originatin...(more) Join Now GL10001.ORDBTAMT
GP 9
DEX_ROW_IDint Unique aut...(more) Join Now
GP 9