DynDeveloper.com

DynDeveloper.com

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

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

(COMPANY..PM Distribution Void WORK Temporary File)

4Penny.net

Field Definitions:

What is the 'source' column?

* the version information goes back to GP 9
Column NameData Type SourceFirst Version
DOCTYPEsmallint Document T...(more) Join Now
GP 9
VCHRNMBRchar(21) Voucher Nu...(more) Join Now
GP 9
DSTSQNUMint Distributi...(more) Join Now CM20400.DSTSQNUM
GP 9
CNTRLTYPsmallint Control Ty...(more) Join Now
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
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 = PM10600.USERID
PSTGSTUSsmallint Posting St...(more) Join Now
GP 9
VENDORIDchar(15) Vendor ID:...(more) Join Now
GP 9
join PM00200 on PM00200.VENDORID = PM10600.VENDORID
TRXSORCEchar(13) Transactio...(more) Join Now
GP 9
PSTGDATEdatetime Posting Da...(more) Join Now PM10000.PSTGDATE
GP 9
INTERIDchar(5) Intercompa...(more) Join Now GL10001.INTERID
GP 9
CURNCYIDchar(15) Currency I...(more) Join Now
GP 9
join DYNAMICS..MC40200 on MC40200.CURNCYID = PM10600.CURNCYID
CURRNIDXsmallint Currency I...(more) Join Now
GP 9
join DYNAMICS..MC40200 on MC40200.CURRNIDX = PM10600.CURRNIDX
ORCRDAMTnumeric(19,5) Originatin...(more) Join Now GL10001.ORCRDAMT
GP 9
ORDBTAMTnumeric(19,5) Originatin...(more) Join Now GL10001.ORDBTAMT
GP 9
APTVCHNMchar(21)
GP 9
APTODCTYsmallint
GP 9
SPCLDISTsmallint B3950341.SPCLDIST
GP 9
DEX_ROW_IDint Unique aut...(more) Join Now
GP 9