DynDeveloper.com

DynDeveloper.com

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

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

(COMPANY..PM Reprint Posting Journal Apply To File)

4Penny.net

Field Definitions:

What is the 'source' column?

* the version information goes back to GP 9
Column NameData Type SourceFirst Version
TRXSORCEchar(13) Transactio...(more) Join Now
GP 9
VCHRNMBRchar(21) Voucher Nu...(more) Join Now
GP 9
DOCTYPEsmallint Document T...(more) Join Now
GP 9
APFRDCNMchar(21)
GP 9
VENDORIDchar(15) Vendor ID:...(more) Join Now
GP 9
join PM00200 on PM00200.VENDORID = PM80500.VENDORID
APTVCHNMchar(21)
GP 9
APTODCTYsmallint
GP 9
APTODCNMchar(21)
GP 9
APPLDAMTnumeric(19,5) Applied Am...(more) Join Now
GP 9
DISTKNAMnumeric(19,5) Discount T...(more) Join Now
GP 9
WROFAMNTnumeric(19,5) Write Off ...(more) Join Now
GP 9
PPSAMDEDnumeric(19,5) PPS Amount...(more) Join Now
GP 9
GSTDSAMTnumeric(19,5) GST Discou...(more) Join Now
GP 9
TAXDTLIDchar(15) Tax Detail...(more) Join Now
GP 9
POSTEDDTdatetime Posted Dat...(more) Join Now
GP 9
PTDUSRIDchar(15) Posted Use...(more) Join Now
GP 9
TEN99AMNTnumeric(19,5) 1099 Amoun...(more) Join Now
GP 9
DISAVTKNnumeric(19,5) Discount A...(more) Join Now
GP 9
DOCDATEdatetime The date a...(more) Join Now
GP 9
APTODCDTdatetime
GP 9
KEYSOURCchar(41)
GP 9
ORAPPAMTnumeric(19,5)
GP 9
ORDISTKNnumeric(19,5) Orig Disco...(more) Join Now
GP 9
ORWROFAMnumeric(19,5)
GP 9
ORDATKNnumeric(19,5) Orig Disco...(more) Join Now
GP 9
RLGANLOSnumeric(19,5) Realized G...(more) Join Now
GP 9
DEX_ROW_IDint Unique aut...(more) Join Now
GP 9