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 > PM20000

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

(COMPANY..PM Transaction OPEN 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
DOCAMNT numeric(19,5)
0.00
The total ...(more) Join Now
CURTRXAM numeric(19,5)
0.00
Current Tr...(more) Join Now
DISTKNAM numeric(19,5)
0.00
Discount T...(more) Join Now
DISCAMNT numeric(19,5)
0.00
PAM63501.DISCAMNT
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'
This field...(more) Join Now
DUEDATE datetime
'1/1/1900'
Due Date: ...(more) Join Now
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 TR...(more) Join Now
HOLD tinyint
0
Hold Desig...(more) Join Now
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
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
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
SY033... more text available
SHIPMTHD char(15)
''
Shipping M...(more) Join Now
join ... more text available
TAXSCHID char(15)
''
Tax Schedu...(more) Join Now
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
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
BNKRCAMT numeric(19,5)
0.00
Bank Recei...(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
WFI10002.Workflow_Status






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