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

COMPANY..SOP40200 Table Definition

(COMPANY..Sales Type ID Setup)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value		 Source
DOCID char(15)
''
Indicates ...(more) Join Now
NOTEINDX numeric(19,5)
0.00
Note Index...(more) Join Now
join ... more text available
SOPTYPE smallint
0
Values sto...(more) Join Now
SETUPKEY smallint
0
Setup Key...(more) Join Now IV40100.SETUPKEY
DOCTYABR char(3)
''

SOPNUMBE char(21)
''
The number...(more) Join Now
COMMNTID char(15)
''
Comment ID...(more) Join Now SOP10100.COMMNTID
join ... more text available
DOCUFORM smallint
0

DAYTOEXP smallint
0

ALLREPEA tinyint
0

ALLOCABY smallint
0
Allocate B...(more) Join Now
USEPROSP tinyint
0

USNXTINV tinyint
0

USPFULPR tinyint
0

QUOTOINV tinyint
0

QUOTOORD tinyint
0

INVTOBAC tinyint
0

BACTOINV tinyint
0

BACTOORD tinyint
0

ORDTOBAC tinyint
0

ORDTOORD tinyint
0

USDOCID1 char(15)
''
Use Docume...(more) Join Now SOP10100.USDOCID1
USDOCID2 char(15)
''
Freight: T...(more) Join Now SOP10100.USDOCID2
QTYDEFAU smallint
0

SOPALLOW_1 tinyint
0
QUOTES, BA...(more) Join Now
SOPALLOW_2 tinyint
0
span style...(more) Join Now
SOPALLOW_3 tinyint
0
span style...(more) Join Now
SOPALLOW_4 tinyint
0
span style...(more) Join Now
SOPALLOW_5 tinyint
0
span style...(more) Join Now
SOPALLOW_6 tinyint
0

SOPALLOW_7 tinyint
0

SOPALLOW_8 tinyint
0

SOPALLOW_9 tinyint
0

SOPALLOW_10 tinyint
0

SOPPSSWD_1 char(11)
''

SOPPSSWD_2 char(11)
''

SOPPSSWD_3 char(11)
''

SOPPSSWD_4 char(11)
''

SOPPSSWD_5 char(11)
''

SOPPSSWD_6 char(11)
''

SOPPSSWD_7 char(11)
''

SOPPSSWD_8 char(11)
''

SOPPSSWD_9 char(11)
''

SOPPSSWD_10 char(11)
''

SOPSEQNC_1 smallint
0

SOPSEQNC_2 smallint
0

SOPSEQNC_3 smallint
0

SOPSEQNC_4 smallint
0

SOPSEQNC_5 smallint
0

SOPSEQNC_6 smallint
0

SOPSEQNC_7 smallint
0

SOPSEQNC_8 smallint
0

USER2ENT char(15)
''
User To En...(more) Join Now POP30300.USER2ENT
CREATDDT datetime
'1/1/1900'
Created Da...(more) Join Now RM00101.CREATDDT
MODIFDT datetime
'1/1/1900'
Date the r...(more) Join Now
SHPPGDOC tinyint
0
Shipping D...(more) Join Now SOP10100.SHPPGDOC
CORRCTN tinyint
0
Correction...(more) Join Now
SIMPLIFD tinyint
0
Simplified...(more) Join Now RM20101.SIMPLIFD
ALLBACKODPRT tinyint
0

XORDINVC tinyint
0

USDOCID3 char(15)
''

WORKFLOWENABLED tinyint
0

UPDTONPRINT tinyint
0

CREDITLIMITHOLDID char(15)
''

UPDTACTUALSHPDT tinyint
0

WORKFLOWHOLDID char(15)
''

OVERRIDEIVCBILLQTY tinyint
0

ENABLEBACKORDER tinyint
0

ENABLECANCELED tinyint
0

SOPSTATUSACTIVE_1 tinyint
0

SOPSTATUSACTIVE_2 tinyint
0

SOPSTATUSACTIVE_3 tinyint
0

SOPSTATUSACTIVE_4 tinyint
0

SOPSTATUSACTIVE_5 tinyint
0

SOPSTATUSACTIVE_6 tinyint
0

SOPSTATUSACTIVE_7 tinyint
0

SOPSTATUSACTIVE_8 tinyint
0

SOPSTATUSACTIVE_9 tinyint
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