DynDeveloper.com

DynDeveloper.com

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

DynDeveloper Table Reference is now in Wiki format! Registered users have the ability to improve the table reference, add comments, and 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?

* the version information goes back to GP 9
Column NameData Type SourceFirst Version
VENDORIDchar(15) Vendor ID:...(more) Join Now
GP 9
join PM00200 on PM00200.VENDORID = PM00201.VENDORID
HIESTBALnumeric(19,5) Highest Ba...(more) Join Now
GP 9
CURRBLNCnumeric(19,5) Current Ba...(more) Join Now
GP 9
NOINVYTDint Number of ...(more) Join Now
GP 9
NOINVLIFint Number of ...(more) Join Now
GP 9
NOINVLYRint Number of ...(more) Join Now
GP 9
NOPINYTDint Number of ...(more) Join Now
GP 9
NOPILIFEint Number of ...(more) Join Now
GP 9
AMBLDTYDnumeric(19,5) Amount Bil...(more) Join Now
GP 9
AMBLDLIFnumeric(19,5) Amount Bil...(more) Join Now
GP 9
AMBLDLYRnumeric(19,5) Amount Bil...(more) Join Now
GP 9
AMTPDYTDnumeric(19,5) Amount Pai...(more) Join Now
GP 9
AMTPDLIFnumeric(19,5) Amount Pai...(more) Join Now
GP 9
AMTPDLYRnumeric(19,5) Amount Pai...(more) Join Now
GP 9
TEN99AYTDnumeric(19,5) 1099 Amoun...(more) Join Now
GP 9
TEN99ALIFnumeric(19,5) 1099 Amoun...(more) Join Now
GP 9
TEN99ALYRnumeric(19,5) 1099 Amoun...(more) Join Now
GP 9
DISAVYTDnumeric(19,5) Discount ...(more) Join Now
GP 9
DISAVLIFnumeric(19,5) Discount A...(more) Join Now
GP 9
DISAVLYRnumeric(19,5) Discount A...(more) Join Now
GP 9
DISTKYTDnumeric(19,5) Discount T...(more) Join Now
GP 9
DISTKNLFnumeric(19,5) Discount T...(more) Join Now
GP 9
DISTKLYRnumeric(19,5) Discount T...(more) Join Now
GP 9
DISLSYTDnumeric(19,5) Discount L...(more) Join Now
GP 9
DISLSTLFnumeric(19,5) Discount L...(more) Join Now
GP 9
DISLSLYRnumeric(19,5) Discount L...(more) Join Now
GP 9
FINCHLIFnumeric(19,5) Finance Ch...(more) Join Now
GP 9
FINCHLYRnumeric(19,5) Finance Ch...(more) Join Now
GP 9
FINCHYTDnumeric(19,5) Finance Ch...(more) Join Now
GP 9
WROFSYTDnumeric(19,5) Write Offs...(more) Join Now
GP 9
WROFSLIFnumeric(19,5) Write Offs...(more) Join Now
GP 9
WROFSLYRnumeric(19,5) Write Offs...(more) Join Now
GP 9
RTRNSYTDnumeric(19,5) Returns YT...(more) Join Now
GP 9
RTRNSLIFnumeric(19,5) Returns Li...(more) Join Now
GP 9
RTRNSLYRnumeric(19,5) Returns LY...(more) Join Now
GP 9
TRDTKLIFnumeric(19,5) Trade Disc...(more) Join Now
GP 9
TRDTLYRnumeric(19,5) Trade Disc...(more) Join Now
GP 9
TRDTYTDnumeric(19,5) Trade Disc...(more) Join Now
GP 9
NFNCHLIFint Number of ...(more) Join Now
GP 9
NFNCHLYRint Number of ...(more) Join Now
GP 9
NFNCHYTDint Number of ...(more) Join Now
GP 9
RTNGOWEDnumeric(19,5) Retainage ...(more) Join Now
GP 9
LSTCHNUMchar(21) Last Check...(more) Join Now
GP 9
LSTCHKDTdatetime Last Check...(more) Join Now
GP 9
LSTCHAMTnumeric(19,5) Last Check...(more) Join Now
GP 9
LSTINNUMchar(21) Last Invoi...(more) Join Now
GP 9
LSTINVAMnumeric(19,5) Last Invoi...(more) Join Now
GP 9
LSTPURDTdatetime Last Purch...(more) Join Now
GP 9
FSTPURDTdatetime First Purc...(more) Join Now
GP 9
CURUNPBNnumeric(19,5) Current Un...(more) Join Now
GP 9
UNPDFNCHnumeric(19,5) Unpaid Fin...(more) Join Now
GP 9
DYCHTCLRsmallint Days Check...(more) Join Now
GP 9
AVGDTPYRsmallint Average Da...(more) Join Now
GP 9
AVDTPLIFsmallint Average Da...(more) Join Now
GP 9
ACCRDINVnumeric(19,5) Accured In...(more) Join Now
GP 9
ONORDAMTnumeric(19,5) On Order A...(more) Join Now
GP 9
WITHYTDnumeric(19,5) Withholdin...(more) Join Now
GP 9
WITHLYRnumeric(19,5) Withholdin...(more) Join Now
GP 9
Withholding_LIFEnumeric(19,5) Withholdin...(more) Join Now
GP 9
PrepaymentAmountnumeric
GP 2013
DEX_ROW_IDint Unique aut...(more) Join Now
GP 9