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 Manufacturing tables QAD10532
You are currently viewing the COMPANY database.
Change

COMPANY..QAD10532 Table Definition

(COMPANY..QA_SCAR)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value		 Source
SCAR_Number char(21)
''

nsrnum char(21)
''

DATEENTERED_I datetime
'1/1/1900'

ITEMNMBR char(31)
''
Item Numbe...(more) Join Now IV10201.ITEMNMBR
join ... more text available
VENDORID char(15)
''
Vendor ID ...(more) Join Now POP10100.VENDORID
join ... more text available
ORIGINATOR char(15)
''

POPRCTNM char(17)
''
POP Receip...(more) Join Now
RCPTLNNM int
0
Receipt Li...(more) Join Now
PONUMBER char(17)
''
PO Number ...(more) Join Now
POLNENUM int
0
PO Line Nu...(more) Join Now
LOCNCODE char(11)
''
Location C...(more) Join Now POP10110.LOCNCODE
join ... more text available
VENDNAME char(65)
''
Vendor Nam...(more) Join Now POP10100.VENDNAME
ADDRESS1 char(61)
''
Address 1 ...(more) Join Now POP10100.ADDRESS1
ADDRESS2 char(61)
''
Address 2 ...(more) Join Now POP10100.ADDRESS2
CITY char(35)
''
City City ...(more) Join Now POP10100.CITY
STATE char(29)
''
State Stat...(more) Join Now POP10100.STATE
ZIPCODE char(11)
''
ZipCode Th...(more) Join Now POP10100.ZIPCODE
PHNUMBR1 char(21)
''

PHNUMBR2 char(21)
''

FAXNUMBR char(21)
''

ITEMDESC char(101)
''
Item Descr...(more) Join Now POP10110.ITEMDESC
VNDITNUM char(31)
''
Vendor Ite...(more) Join Now
QTYRECEIVED2_I numeric(19,5)
0.00

BASEUOFM char(9)
''

See I... more text available
DATEDUE_I datetime
'1/1/1900'

DATEIN_I datetime
'1/1/1900'

VNDCNTCT char(61)
''

PHONNAME char(21)
''

USERID char(15)
''
The user t...(more) Join Now
join ... more text available
CHANGEDATE_I datetime
'1/1/1900'
*Change Da...(more) Join Now HR2EMP02.CHANGEDATE_I
MFGNOTEINDEX_I numeric(19,5)
0.00

MFGNOTEINDEX2_I numeric(19,5)
0.00

MFGNOTEINDEX3_I numeric(19,5)
0.00

MFGNOTEINDEX4I numeric(19,5)
0.00

MFGNOTEINDEX5I numeric(19,5)
0.00

MFGNOTEINDEX6I numeric(19,5)
0.00

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