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

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

(COMPANY..PM Vendor Master Summary)
The PM Vendor Master Summary contains summary information about the vendors.  YTD, Last Year, & LTD totals as well as last amounts and highest balances for the vendor.  It would normally not be imported into unless you wanted imported last years or Life To Date information for comparative purposes.  The Vendor Master Summary totals for Current Balance, Unapplied Payments, Unpaid Finance Charges, & On Order amounts are recalculated on reconciling vendors
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
HIESTBAL numeric(19,5)
0.00
Highest Ba...(more) Join Now
CURRBLNC numeric(19,5)
0.00
Current Ba...(more) Join Now
NOINVYTD int
0
Number of ...(more) Join Now
NOINVLIF int
0
Number of ...(more) Join Now
NOINVLYR int
0
Number of ...(more) Join Now
NOPINYTD int
0
Number of ...(more) Join Now
NOPILIFE int
0
Number of ...(more) Join Now
AMBLDTYD numeric(19,5)
0.00
Amount Bil...(more) Join Now
AMBLDLIF numeric(19,5)
0.00
Amount Bil...(more) Join Now
AMBLDLYR numeric(19,5)
0.00
Amount Bil...(more) Join Now
AMTPDYTD numeric(19,5)
0.00
Amount Pai...(more) Join Now
AMTPDLIF numeric(19,5)
0.00
Amount Pai...(more) Join Now
AMTPDLYR numeric(19,5)
0.00
Amount Pai...(more) Join Now
TEN99AYTD numeric(19,5)
0.00
1099 Amoun...(more) Join Now
TEN99ALIF numeric(19,5)
0.00
1099 Amoun...(more) Join Now
TEN99ALYR numeric(19,5)
0.00
1099 Amoun...(more) Join Now
DISAVYTD numeric(19,5)
0.00
Discount ...(more) Join Now
DISAVLIF numeric(19,5)
0.00
Discount A...(more) Join Now
DISAVLYR numeric(19,5)
0.00
Discount A...(more) Join Now
DISTKYTD numeric(19,5)
0.00
Discount T...(more) Join Now
DISTKNLF numeric(19,5)
0.00
Discount T...(more) Join Now
DISTKLYR numeric(19,5)
0.00
Discount T...(more) Join Now
DISLSYTD numeric(19,5)
0.00
Discount L...(more) Join Now
DISLSTLF numeric(19,5)
0.00
Discount L...(more) Join Now
DISLSLYR numeric(19,5)
0.00
Discount L...(more) Join Now
FINCHLIF numeric(19,5)
0.00
Finance Ch...(more) Join Now
FINCHLYR numeric(19,5)
0.00
Finance Ch...(more) Join Now
FINCHYTD numeric(19,5)
0.00
Finance Ch...(more) Join Now
WROFSYTD numeric(19,5)
0.00
Write Offs...(more) Join Now
WROFSLIF numeric(19,5)
0.00
Write Offs...(more) Join Now
WROFSLYR numeric(19,5)
0.00
Write Offs...(more) Join Now
RTRNSYTD numeric(19,5)
0.00
Returns YT...(more) Join Now
RTRNSLIF numeric(19,5)
0.00
Returns Li...(more) Join Now
RTRNSLYR numeric(19,5)
0.00
Returns LY...(more) Join Now
TRDTKLIF numeric(19,5)
0.00
Trade Disc...(more) Join Now
TRDTLYR numeric(19,5)
0.00
Trade Disc...(more) Join Now
TRDTYTD numeric(19,5)
0.00
Trade Disc...(more) Join Now
NFNCHLIF int
0
Number of ...(more) Join Now
NFNCHLYR int
0
Number of ...(more) Join Now
NFNCHYTD int
0
Number of ...(more) Join Now
RTNGOWED numeric(19,5)
0.00
Retainage ...(more) Join Now
LSTCHNUM char(21)
''
Last Check...(more) Join Now
LSTCHKDT datetime
'1/1/1900'
Last Check...(more) Join Now
LSTCHAMT numeric(19,5)
0.00
Last Check...(more) Join Now
LSTINNUM char(21)
''
Last Invoi...(more) Join Now
LSTINVAM numeric(19,5)
0.00
Last Invoi...(more) Join Now
LSTPURDT datetime
'1/1/1900'
Last Purch...(more) Join Now
FSTPURDT datetime
'1/1/1900'
First Purc...(more) Join Now
CURUNPBN numeric(19,5)
0.00
Current Un...(more) Join Now
UNPDFNCH numeric(19,5)
0.00
Unpaid Fin...(more) Join Now
DYCHTCLR smallint
0
Days Check...(more) Join Now
AVGDTPYR smallint
0
Average Da...(more) Join Now
AVDTPLIF smallint
0
Average Da...(more) Join Now
ACCRDINV numeric(19,5)
0.00
Accured In...(more) Join Now
ONORDAMT numeric(19,5)
0.00
On Order A...(more) Join Now
WITHYTD numeric(19,5)
0.00
Withholdin...(more) Join Now
WITHLYR numeric(19,5)
0.00
Withholdin...(more) Join Now
Withholding_LIFE numeric(19,5)
0.00
Withholdin...(more) Join Now
DEX_ROW_ID int
auto number (1,1)
Unique ide...(more) Join Now
PrepaymentAmount numeric
0.00







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