DynDeveloper.com

DynDeveloper.com

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

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

(COMPANY..PM Reprint Void Transaction WORK)

4Penny.net

Field Definitions:

What is the 'source' column?

* the version information goes back to GP 9
Column NameData Type SourceFirst Version
USERIDchar(15) The user t...(more) Join Now
GP 9
join DYNAMICS..SY01400 on SY01400.USERID = PM80300.USERID
TIME1datetime
GP 9
VENDORIDchar(15) Vendor ID:...(more) Join Now
GP 9
join PM00200 on PM00200.VENDORID = PM80300.VENDORID
DOCTYPEsmallint Document T...(more) Join Now
GP 9
VCHRNMBRchar(21) Voucher Nu...(more) Join Now
GP 9
PMVDMSGSbinary(4)
GP 9
DOCDATEdatetime The date a...(more) Join Now
GP 9
DOCNUMBRchar(21) Document N...(more) Join Now PM10000.DOCNUMBR
GP 9
DOCAMNTnumeric(19,5) Source Doc...(more) Join Now PM10000.DOCAMNT
GP 9
CURTRXAMnumeric(19,5) Current Tr...(more) Join Now PM10000.CURTRXAM
GP 9
DISTKNAMnumeric(19,5) Discount T...(more) Join Now
GP 9
DISCAMNTnumeric(19,5) PAM60501.DISCAMNT
GP 9
DISCDATEdatetime Discount D...(more) Join Now PM10000.DISCDATE
GP 9
TRXSORCEchar(13) Transactio...(more) Join Now
GP 9
TEN99AMNTnumeric(19,5) 1099 Amoun...(more) Join Now
GP 9
WROFAMNTnumeric(19,5) Write Off ...(more) Join Now
GP 9
DISAMTAVnumeric(19,5) Discount A...(more) Join Now
GP 9
PRCHAMNTnumeric(19,5) Purchases ...(more) Join Now
GP 9
TRDISAMTnumeric(19,5) Trade Disc...(more) Join Now
GP 9
MSCCHAMTnumeric(19,5) Misc Charg...(more) Join Now
GP 9
FRTAMNTnumeric(19,5) Freight Am...(more) Join Now
GP 9
TAXAMNTnumeric(19,5) Tax Amount...(more) Join Now
GP 9
TTLPYMTSnumeric(19,5) Total Paym...(more) Join Now
GP 9
CHEKBKIDchar(15) Checkbook ID Checkbook this transaction affects PAM22222.CHEKBKID
GP 9
join CM00100 on CM00100.CHEKBKID = PM80300.CHEKBKID
PSTGDATEdatetime Posting Da...(more) Join Now PM10000.PSTGDATE
GP 9
CURNCYIDchar(15) Currency I...(more) Join Now
GP 9
join DYNAMICS..MC40200 on MC40200.CURNCYID = PM80300.CURNCYID
DEYDESCRchar(31)
GP 9
VADCDTROchar(15) Vendor Add...(more) Join Now
GP 9
DEX_ROW_IDint Unique aut...(more) Join Now
GP 9