Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our SOP scripts. All of our scripts for Dynamics GP can be found here
DynDeveloper.com

DynDeveloper.com

Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now!Log In
Module List > Module PM tables > PM30700
DynDeveloper Table Reference is in Wiki format! Registered users have the ability to improve the table reference, add comments, and generally 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?

 Column NameData Type
Default Value
 Source
VENDORID char(15)
''
Vendor ID:...(more) Join Now
join ... more text available
VCHRNMBR char(21)
''
Voucher Nu...(more) Join Now
DOCTYPE smallint
0
Document T...(more) Join Now
BACHNUMB char(15)
''
Batch Numb...(more) Join Now
join ... more text available
TAXDTLID char(15)
''
Tax Detail...(more) Join Now
BKOUTTAX tinyint
0
Backout Ta...(more) Join Now PM10500.BKOUTTAX
TAXAMNT numeric(19,5)
0.00
Tax Amount...(more) Join Now
ORTAXAMT numeric(19,5)
0.00
Orig Tax A...(more) Join Now POP30300.ORTAXAMT
PCTAXAMT numeric(19,5)
0.00
Purchase T...(more) Join Now
ORPURTAX numeric(19,5)
0.00
Originatin...(more) Join Now
FRTTXAMT numeric(19,5)
0.00
Freight Ta...(more) Join Now POP30300.FRTTXAMT
ORFRTTAX numeric(19,5)
0.00
Orig Freig...(more) Join Now POP30300.ORFRTTAX
MSCTXAMT numeric(19,5)
0.00
Misc Tax A...(more) Join Now POP10300.MSCTXAMT
ORMSCTAX numeric(19,5)
0.00
Orig Misc ...(more) Join Now POP10300.ORMSCTAX
ACTINDX int
0
Account In...(more) Join Now UPR00100.ACTINDX
join ... more text available
TRXSORCE char(13)
''
Transactio...(more) Join Now
TDTTXPUR numeric(19,5)
0.00
Tax Detail...(more) Join Now
ORTXBPUR numeric(19,5)
0.00
Originatin...(more) Join Now
TXDTTPUR numeric(19,5)
0.00
Tax Detail...(more) Join Now
ORTOTPUR numeric(19,5)
0.00
Originatin...(more) Join Now PM10500.ORTOTPUR
CURRNIDX smallint
0
Currency I...(more) Join Now
join ... more text available
DEX_ROW_ID int
auto number (1,1)
Unique ide...(more) Join Now






Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables