DynDeveloper.com

DynDeveloper.com

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

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

(COMPANY..Purchasing 1099 Period Detail)
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.  This contains 1099 data for each calendar period from the PM Vendor Master Period Summary table and breaks the 1099 amount into the specific 1099 Type and 1099 Box Number.
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 10
join PM00200 on PM00200.VENDORID = PM00204.VENDORID
TEN99TYPEsmallint 1099 Type:...(more) Join Now
GP 10
YEAR1smallint Year: The...(more) Join Now
GP 10
PERIODIDsmallint Period ID:...(more) Join Now
GP 10
TEN99BOXNUMBERsmallint 1099 Box N...(more) Join Now
GP 10
TEN99AMNTnumeric(19,5) 1099 Amoun...(more) Join Now
GP 10
TEN99FRNORUSDTLchar
GP 2013
DEX_ROW_IDint Unique aut...(more) Join Now
GP 10
TEN99STATECDchar
GP 2013
TEN99STATIDNUMchar
GP 2013
TEN99TAXEXMTCUSIPNUMchar
GP 2013
TEN99DIRSALECBtinyint
GP 2013
TEN99STATNMBRchar
GP 2013
TEN99FATCAFILEREQtinyint
GP 2016