DynDeveloper.com

DynDeveloper.com

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

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

(COMPANY..PM Vendor Master Period Summary)
This file would not normally be imported into.  An exception would be to provide totals for previous periods and years before dynamics was used for comparative reports to current data.
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 = PM00202.VENDORID
PERIODIDsmallint Period ID:...(more) Join Now
GP 9
YEAR1smallint Year: The...(more) Join Now
GP 9
HISTTYPEsmallint History Ty...(more) Join Now
GP 9
AMBLDLIFnumeric(19,5) Amount Bil...(more) Join Now
GP 9
AMTPDLIFnumeric(19,5) Amount Pai...(more) Join Now
GP 9
TEN99ALIFnumeric(19,5) 1099 Amoun...(more) Join Now
GP 9
DISAVLIFnumeric(19,5) Discount A...(more) Join Now
GP 9
DISTKNLFnumeric(19,5) Discount T...(more) Join Now
GP 9
DISLSTLFnumeric(19,5) Discount L...(more) Join Now
GP 9
FINCHLIFnumeric(19,5) Finance Ch...(more) Join Now
GP 9
WROFSLIFnumeric(19,5) Writeoffs ...(more) Join Now
GP 9
RTRNSLIFnumeric(19,5) Returns Li...(more) Join Now
GP 9
TRDTKLIFnumeric(19,5) Trade Disc...(more) Join Now
GP 9
NFNCHLIFint Number of ...(more) Join Now
GP 9
NOINVLIFint Number of ...(more) Join Now
GP 9
Withholding_LIFEnumeric(19,5) Withholdin...(more) Join Now
GP 9
DEX_ROW_IDint Unique aut...(more) Join Now
GP 9