DynDeveloper.com

DynDeveloper.com

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

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

(COMPANY..PM Tax History File)

4Penny.net

Field Definitions:

What is the 'source' column?

* the version information goes back to GP 9
Column NameData Type SourceFirst Version
VENDORIDchar(15) Vendor ID:...(more) Join Now
GP 9
join PM00200 on PM00200.VENDORID = PM30700.VENDORID
VCHRNMBRchar(21) Voucher Nu...(more) Join Now
GP 9
DOCTYPEsmallint Document T...(more) Join Now
GP 9
BACHNUMBchar(15) Batch Numb...(more) Join Now
GP 9
join SY00500 on SY00500.BACHNUMB = PM30700.BACHNUMB
TAXDTLIDchar(15) Tax Detail...(more) Join Now
GP 9
BKOUTTAXtinyint Backout Ta...(more) Join Now PM10500.BKOUTTAX
GP 9
TAXAMNTnumeric(19,5) Tax Amount...(more) Join Now
GP 9
ORTAXAMTnumeric(19,5) Orig Tax A...(more) Join Now POP30300.ORTAXAMT
GP 9
PCTAXAMTnumeric(19,5) Purchase T...(more) Join Now
GP 9
ORPURTAXnumeric(19,5) Originatin...(more) Join Now
GP 9
FRTTXAMTnumeric(19,5) Freight Ta...(more) Join Now POP30300.FRTTXAMT
GP 9
ORFRTTAXnumeric(19,5) Orig Freig...(more) Join Now POP30300.ORFRTTAX
GP 9
MSCTXAMTnumeric(19,5) Misc Tax A...(more) Join Now POP10300.MSCTXAMT
GP 9
ORMSCTAXnumeric(19,5) Orig Misc ...(more) Join Now POP10300.ORMSCTAX
GP 9
ACTINDXint Account In...(more) Join Now UPR00100.ACTINDX
GP 9
join GL00100 on GL00100.ACTINDX = PM30700.ACTINDX
TRXSORCEchar(13) Transactio...(more) Join Now
GP 9
TDTTXPURnumeric(19,5) Tax Detail...(more) Join Now
GP 9
ORTXBPURnumeric(19,5) Originatin...(more) Join Now
GP 9
TXDTTPURnumeric(19,5) Tax Detail...(more) Join Now
GP 9
ORTOTPURnumeric(19,5) Originatin...(more) Join Now PM10500.ORTOTPUR
GP 9
CURRNIDXsmallint Currency I...(more) Join Now
GP 9
join DYNAMICS..MC40200 on MC40200.CURRNIDX = PM30700.CURRNIDX
DEX_ROW_IDint Unique aut...(more) Join Now
GP 9