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

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

(COMPANY..PM Scheduled Payment LINE)

4Penny.net

Field Definitions:

What is the 'source' column?

Column NameData Type
Default Value
 Source
SCHEDULE_NUMBER char(21)
''

Schedule_Payment_Number smallint
0

VCHRNMBR char(21)
''
Voucher Nu...(more) Join Now
PAYMENT_AMOUNT numeric(19,5)
0.00

VENDORID char(15)
''
Vendor ID:...(more) Join Now
join ... more text available
INTEREST_AMOUNT numeric(19,5)
0.00

PRINCIPAL_AMOUNT numeric(19,5)
0.00

PRINCIPAL_BALANCE numeric(19,5)
0.00

DOCDATE datetime
'1/1/1900'
The date a...(more) Join Now
DUEDATE datetime
'1/1/1900'
Due Date: ...(more) Join Now PM10000.DUEDATE
Status smallint
0
Status Ind...(more) Join Now BM10400.Status
MARKED tinyint
0

MKDBYUSR char(15)
''

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