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

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

(COMPANY..PM Manual Payment WORK File)

The PM_Manual_Payment_WORK table is the primary storage area for manual payments. It contains fields linking it to the Batch_Headers table where batch information is stored, to the PM_Keys_MSTR table where used payment numbers are stored, and to the CM_Checkbook_MSTR table where Document Numbers are stored. All of these tables must be maintained as to ensure unique control ID values. If Multicurrency is registered and the Currency ID of the payment does not match the functional currency then the MC_PM_Transactions table will also contain a record for this payment.


4Penny.net

Field Definitions:

What is the 'source' column?

Column NameData Type
Default Value
 Source
BACHNUMB char(15)
''
Batch Numb...(more) Join Now
join ... more text available
BCHSOURC char(15)
''
Batch Sour...(more) Join Now
PMNTNMBR char(21)
''
Payment Nu...(more) Join Now
VENDORID char(15)
''
Vendor ID:...(more) Join Now
join ... more text available
DOCNUMBR char(21)
''
Document N...(more) Join Now
DOCTYPE smallint
0
Document T...(more) Join Now
DOCAMNT numeric(19,5)
0.00
Document A...(more) Join Now
DOCDATE datetime
'1/1/1900'
Document D...(more) Join Now
PSTGDATE datetime
'1/1/1900'

PYENTTYP smallint
0

CHEKAMNT numeric(19,5)
0.00
Check Amou...(more) Join Now
CARDNAME char(15)
''
Card Name:...(more) Join Now
CURNCYID char(15)
''
Currency I...(more) Join Now
join ... more text available
CHEKBKID char(15)
''
Checkbook ID Checkbook this transaction affects SY30500.CHEKBKID
join ... more text available
TRXDSCRN char(31)
''
Transactio...(more) Join Now
DISAMTAV numeric(19,5)
0.00
Discount A...(more) Join Now
DISTKNAM numeric(19,5)
0.00
Discount T...(more) Join Now
WROFAMNT numeric(19,5)
0.00
Writeoff A...(more) Join Now
CURTRXAM numeric(19,5)
0.00
Current Tr...(more) Join Now
APPLDAMT numeric(19,5)
0.00
Applied Am...(more) Join Now
PMWRKMSG binary(4)
0
PM WORK Me...(more) Join Now
PMWRKMS2 binary(4)
0
PM WORK Me...(more) Join Now
PMDSTMSG binary(4)
0
PM Distrib...(more) Join Now
GSTDSAMT numeric(19,5)
0.00
GST Discou...(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
NOTEINDX numeric(19,5)
0.00
Note Index...(more) Join Now
join ... more text available
VCHRNMBR char(21)
''
Voucher Nu...(more) Join Now
CNTRLTYP smallint
0
Control Ty...(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
POSTEDDT datetime
'1/1/1900'
Posted Dat...(more) Join Now
PTDUSRID char(15)
''
Posted Use...(more) Join Now
RETNAGAM numeric(19,5)
0.00
Retainage ...(more) Join Now
Electronic tinyint
0

DEX_ROW_ID int
auto number (1,1)
Unique ide...(more) Join Now
PONUMBER char
''
PO Number ...(more) Join Now SEE30303.PONUMBER






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