DynDeveloper.com

DynDeveloper.com
Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now! Log In
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
Module List > Module IV tables IV50200
You are currently viewing the COMPANY database.
Change

COMPANY..IV50200 Table Definition

(COMPANY..Stock Count Assignment Temp)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value		 Source
INCLUDEITEM tinyint
0
Include It...(more) Join Now POP10140.INCLUDEITEM
ITEMNMBR char(31)
''
Item Numbe...(more) Join Now
join ... more text available
LOCNCODE char(11)
''
Location C...(more) Join Now
join ... more text available
BINNMBR char(21)
''
Bin Number...(more) Join Now IV00102.BINNMBR
ITMCLSCD char(11)
''
Item Class...(more) Join Now
ABCCODE smallint
0
ABC Code:&...(more) Join Now IV00101.ABCCODE
ITMGEDSC char(11)
''
span style...(more) Join Now IV00101.ITMGEDSC
ITEMDESC char(101)
''
Item Descr...(more) Join Now IV00101.ITEMDESC
LSTCNTDT datetime
'1/1/1900'
Last Count...(more) Join Now IV00102.LSTCNTDT
STCKCNTINTRVL smallint
0
Stock Coun...(more) Join Now IV00102.STCKCNTINTRVL
NXTCNTDT datetime
'1/1/1900'
Next Count...(more) Join Now IV00102.NXTCNTDT
NXTCNTTM datetime
'1/1/1900'
Next Count...(more) Join Now IV00102.NXTCNTTM
UPDATED tinyint
0

ITEMTYPE smallint
0
span style...(more) Join Now IV00101.ITEMTYPE
USERID char(15)
''
The user t...(more) Join Now
join ... more text available
IntegerValue smallint
0

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
Archives | Table Listing | eConnect Error Database | eConnect Schema | Gold Star Locksmith
3