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

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

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

(COMPANY..PM Paid Transaction History File)

4Penny.net

Field Definitions:

What is the 'source' column?

Column NameData Type
Default Value
 Source
VCHRNMBR char(21)
''
Voucher Nu...(more) Join Now
VENDORID char(15)
''
Vendor ID:...(more) Join Now
join ... more text available
DOCTYPE smallint
0
Document T...(more) Join Now
DOCDATE datetime
'1/1/1900'
The date a...(more) Join Now
DOCNUMBR char(21)
''
Document N...(more) Join Now PM10000.DOCNUMBR
DOCAMNT numeric(19,5)
0.00
Source Doc...(more) Join Now PM10000.DOCAMNT
CURTRXAM numeric(19,5)
0.00
Current Tr...(more) Join Now PM10000.CURTRXAM
DISTKNAM numeric(19,5)
0.00
Discount T...(more) Join Now
DISCAMNT numeric(19,5)
0.00

DSCDLRAM numeric(19,5)
0.00
Discount D...(more) Join Now
BACHNUMB char(15)
''
Batch Numb...(more) Join Now
join ... more text available
TRXSORCE char(13)
''
Transactio...(more) Join Now
BCHSOURC char(15)
''
Batch Sour...(more) Join Now
DISCDATE datetime
'1/1/1900'
Discount D...(more) Join Now PM10000.DISCDATE
DUEDATE datetime
'1/1/1900'
Due Date: ...(more) Join Now PM10000.DUEDATE
PORDNMBR char(21)
''
Purchase O...(more) Join Now
TEN99AMNT numeric(19,5)
0.00
1099 Amoun...(more) Join Now
WROFAMNT numeric(19,5)
0.00
Write Off ...(more) Join Now
DISAMTAV numeric(19,5)
0.00
Discount A...(more) Join Now
TRXDSCRN char(31)
''
Transactio...(more) Join Now
UN1099AM numeric(19,5)
0.00
Unapplied ...(more) Join Now
BKTPURAM numeric(19,5)
0.00
Backout Pu...(more) Join Now
BKTFRTAM numeric(19,5)
0.00
Backout Fr...(more) Join Now
BKTMSCAM numeric(19,5)
0.00
Backout Mi...(more) Join Now
VOIDED tinyint
0
Voided TRU...(more) Join Now CM20100.VOIDED
HOLD tinyint
0
Hold: 1 i...(more) Join Now RM00101.HOLD
CHEKBKID char(15)
''
Checkbook ID Checkbook this transaction affects SY30500.CHEKBKID
join ... more text available
DINVPDOF datetime
'1/1/1900'
Date Invoi...(more) Join Now PM20000.DINVPDOF
PPSAMDED numeric(19,5)
0.00
PPS Amount...(more) Join Now
PPSTAXRT smallint
0
PPS Tax Ra...(more) Join Now
PGRAMSBJ smallint
0
Percent Of...(more) Join Now
GSTDSAMT numeric(19,5)
0.00
GST Discou...(more) Join Now
POSTEDDT datetime
'1/1/1900'
Posted Dat...(more) Join Now
PTDUSRID char(15)
''
Posted Use...(more) Join Now
MODIFDT datetime
'1/1/1900'
Date the r...(more) Join Now
MDFUSRID char(15)
''
User that ...(more) Join Now
join ... more text available
PYENTTYP smallint
0

CARDNAME char(15)
''
Card Name:...(more) Join Now PM10000.CARDNAME
PRCHAMNT numeric(19,5)
0.00
Purchases ...(more) Join Now
TRDISAMT numeric(19,5)
0.00
Trade Disc...(more) Join Now
MSCCHAMT numeric(19,5)
0.00
Misc Charg...(more) Join Now
FRTAMNT numeric(19,5)
0.00
Freight Am...(more) Join Now
TAXAMNT numeric(19,5)
0.00
Tax Amount...(more) Join Now
TTLPYMTS numeric(19,5)
0.00
Total Paym...(more) Join Now
CURNCYID char(15)
''
Currency I...(more) Join Now
join ... more text available
PYMTRMID char(21)
''
Payment Te...(more) Join Now PM10000.PYMTRMID
SY033... more text available
SHIPMTHD char(15)
''
Shipping M...(more) Join Now
join ... more text available
TAXSCHID char(15)
''
Tax Schedu...(more) Join Now PM10000.TAXSCHID
join ... more text available
PCHSCHID char(15)
''
Purchase S...(more) Join Now
FRTSCHID char(15)
''
Freight ...(more) Join Now
join ... more text available
MSCSCHID char(15)
''
Misc Sched...(more) Join Now
join ... more text available
PSTGDATE datetime
'1/1/1900'

DISAVTKN numeric(19,5)
0.00
Discount A...(more) Join Now
CNTRLTYP smallint
0
Control Ty...(more) Join Now
NOTEINDX numeric(19,5)
0.00
Note Index...(more) Join Now
join ... more text available
PRCTDISC smallint
0
Percent Di...(more) Join Now
RETNAGAM numeric(19,5)
0.00
Retainage ...(more) Join Now
VOIDPDATE datetime
'1/1/1900'
Void GL Po...(more) Join Now CM20300.VOIDPDATE
ICTRX tinyint
0
IC TRX: Im...(more) Join Now
Tax_Date datetime
'1/1/1900'
Tax Date: ...(more) Join Now
PRCHDATE datetime
'1/1/1900'
Purchase D...(more) Join Now
CORRCTN tinyint
0
Correction...(more) Join Now
SIMPLIFD tinyint
0
Simplified...(more) Join Now
APLYWITH tinyint
0
Apply With...(more) Join Now
Electronic tinyint
0

ECTRX tinyint
0
EC Transac...(more) Join Now
DocPrinted tinyint
0
DocPrinted...(more) Join Now
TaxInvReqd tinyint
0
Tax Invoic...(more) Join Now
VNDCHKNM char(65)
''
Vendor Che...(more) Join Now
BackoutTradeDisc numeric(19,5)
0.00
Backout Tr...(more) Join Now
CBVAT tinyint
0
Cash Based...(more) Join Now
VADCDTRO char(15)
''
Vendor Add...(more) Join Now
TEN99TYPE smallint
0
1099 Type:...(more) Join Now
TEN99BOXNUMBER smallint
0
1099 Box N...(more) Join Now
DEX_ROW_TS datetime
(getutcdate())
Time Stamp...(more) Join Now
PONUMBER char
''
PO Number ...(more) Join Now SEE30303.PONUMBER
DEX_ROW_ID int
auto number (1,1)
Unique ide...(more) Join Now
Workflow_Status smallint
0







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