DynDeveloper.com
Table Edits
Forum
Articles
0
0
0
Sign Up Now!
Log In
Home
Knowledge Base
The Dynamics GP Table Reference
Our list of the Dynamics GP Tables, their structures and relationships
eConnect
Our Tutorials, Code Examples
eConnect Schema Reference
Visual Studio Tools For Dynamics GP
How Tos
Tutorials
Most popular posts
Code Examples
Menus for VS Tools
SDK
Service Based Architecture
Tutorials, Code Examples
Kellerman Controls
Store, Examples, Support
APIs and Webhooks
Web Services
Help, code samples, resources
VBA/Dynamics Modifier VBA mods
Our VBA code library
Integration Manager
Tools for working with Integration Manager
SSRS
SQL (General)
SQL for GP
SQL for Beginners
.NET Development
Code libraries, How Tos, Tutorials
GitHub
Telerik Development
ASP.NET Menu
WinForms Menu
DevExpress
Dynamics GP
Dynamics 365
Extender
Tips and Tricks
SmartConnect
Mercury BI
Dynamics Report Writer
Management Reporter
And More
Microsoft Access
Our Favorite Posts
Sign Up
Ask A Question
More
Contact Us
Products We Recommend
Policies
Knowledgebase
Table Reference
eConnect Code
Telerik
ASP.NET
Winforms
SQL
General
For Dynamics
For Beginners
SSRS
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
SOP Scripts
eConnect
taSopDeleteDocumentWrapper
taSopLineDeleteWrapper
taSOPLineIvcInsert Wrapper
taSopLineIvcInsertComponent
taSOPLotAuto - complete procedure
Functions
ddf_Address
ddf_AllHoldsOnASOPDoc
General
Getting Email addresses from Dynamics GP
Move a SOP transaction from open to history
Posting Sequences
SOP40200 'Allow' fields query
sopGetIDNumber
sopTrxDeleteWork
Unvoid a SOP document
Stored Procedures
dd_SOP10102_UPD
dd_SOPGetNextDocNumber/ sopGetIDNumber.
dd_SOPPayment_INS
dd_SOPRound - Round a SOP Multicurrency document to two decimal places
dd_SOPTotal
dd_SOPTotalTaxes
dd_taSopVoidDocumentWrapper
Module List
>
Module EC tables
eConnect_Out_Setup
You are currently viewing the
COMPANY
database.
Change
COMPANY..eConnect_Out_Setup
Table Definition
(
COMPANY..
)
Field Definitions:
What is the 'source' column?
Column Name
Data Type
Default Value
Source
QUEUEPATH
varchar(100)
''
QUEUE_ENABLED
int
0
DOCTYPE
varchar(50)
Document T...(more)
Join Now
PM10000.DOCTYPE
INSERT_ENABLED
int
0
UPDATE_ENABLED
int
0
DELETE_ENABLED
int
0
TABLENAME
varchar(30)
ALIAS
varchar(30)
''
MAIN
int
0
PARENTLEVEL
int
0
ORDERBY
int
0
USERDEF1
varchar(30)
''
UserDefine...(more)
Join Now
CM20200.USERDEF1
USERDEF2
varchar(30)
''
UserDefine...(more)
Join Now
CM20200.USERDEF2
USERDEF3
varchar(30)
''
USERDEF4
varchar(30)
''
USERDEF5
varchar(30)
''
REQUIRED1
varchar(30)
''
INDEX1
varchar(30)
''
Index Key ...(more)
Join Now
POP40100.INDEX1
INDEX2
varchar(30)
''
INDEX3
varchar(30)
''
INDEX4
varchar(30)
''
INDEX5
varchar(30)
''
INDEX6
varchar(30)
''
INDEX7
varchar(30)
''
INDEX8
varchar(30)
''
INDEX9
varchar(30)
''
INDEX10
varchar(30)
''
INDEX11
varchar(30)
''
INDEX12
varchar(30)
''
INDEX13
varchar(30)
''
INDEX14
varchar(30)
''
INDEX15
varchar(30)
''
INDEXCNT
int
0
TRIGGER1
varchar(30)
''
TRIGGER2
varchar(30)
''
TRIGGER3
varchar(30)
''
TRIGGER4
varchar(30)
''
TRIGGER5
varchar(30)
''
TRIGGER6
varchar(30)
''
TRIGGER7
varchar(30)
''
TRIGGER8
varchar(30)
''
TRIGGER9
varchar(30)
''
TRIGGER10
varchar(30)
''
TRIGGER11
varchar(30)
''
TRIGGER12
varchar(30)
''
TRIGGER13
varchar(30)
''
TRIGGER14
varchar(30)
''
TRIGGER15
varchar(30)
''
TRIGGERCNT
int
0
JOINTABLE
varchar(30)
''
JOIN1
varchar(30)
''
JOIN2
varchar(30)
''
JOIN3
varchar(30)
''
JOIN4
varchar(30)
''
JOIN5
varchar(30)
''
JOIN6
varchar(30)
''
JOIN7
varchar(30)
''
JOIN8
varchar(30)
''
JOIN9
varchar(30)
''
JOIN10
varchar(30)
''
JOINTO1
varchar(30)
''
JOINTO2
varchar(30)
''
JOINTO3
varchar(30)
''
JOINTO4
varchar(30)
''
JOINTO5
varchar(30)
''
JOINTO6
varchar(30)
''
JOINTO7
varchar(30)
''
JOINTO8
varchar(30)
''
JOINTO9
varchar(30)
''
JOINTO10
varchar(30)
''
DATACNT
int
0
DATA1
varchar(30)
''
DATA2
varchar(30)
''
DATA3
varchar(30)
''
DATA4
varchar(30)
''
DATA5
varchar(30)
''
DATA6
varchar(30)
''
DATA7
varchar(30)
''
DATA8
varchar(30)
''
DATA9
varchar(30)
''
DATA10
varchar(30)
''
DATA11
varchar(30)
''
DATA12
varchar(30)
''
DATA13
varchar(30)
''
DATA14
varchar(30)
''
DATA15
varchar(30)
''
DATA16
varchar(30)
''
DATA17
varchar(30)
''
DATA18
varchar(30)
''
DATA19
varchar(30)
''
DATA20
varchar(30)
''
DATA21
varchar(30)
''
DATA22
varchar(30)
''
DATA23
varchar(30)
''
DATA24
varchar(30)
''
DATA25
varchar(30)
''
DATA26
varchar(30)
''
DATA27
varchar(30)
''
DATA28
varchar(30)
''
DATA29
varchar(30)
''
DATA30
varchar(30)
''
DATA31
varchar(30)
''
DATA32
varchar(30)
''
DATA33
varchar(30)
''
DATA34
varchar(30)
''
DATA35
varchar(30)
''
DATA36
varchar(30)
''
DATA37
varchar(30)
''
DATA38
varchar(30)
''
DATA39
varchar(30)
''
DATA40
varchar(30)
''
DATA41
varchar(30)
''
DATA42
varchar(30)
''
DATA43
varchar(30)
''
DATA44
varchar(30)
''
DATA45
varchar(30)
''
DATA46
varchar(30)
''
DATA47
varchar(30)
''
DATA48
varchar(30)
''
DATA49
varchar(30)
''
DATA50
varchar(30)
''
DATA51
varchar(30)
''
DATA52
varchar(30)
''
DATA53
varchar(30)
''
DATA54
varchar(30)
''
DATA55
varchar(30)
''
DATA56
varchar(30)
''
DATA57
varchar(30)
''
DATA58
varchar(30)
''
DATA59
varchar(30)
''
DATA60
varchar(30)
''
DATA61
varchar(30)
''
DATA62
varchar(30)
''
DATA63
varchar(30)
''
DATA64
varchar(30)
''
DATA65
varchar(30)
''
DATA66
varchar(30)
''
DATA67
varchar(30)
''
DATA68
varchar(30)
''
DATA69
varchar(30)
''
DATA70
varchar(30)
''
DATA71
varchar(30)
''
DATA72
varchar(30)
''
DATA73
varchar(30)
''
DATA74
varchar(30)
''
DATA75
varchar(30)
''
DATA76
varchar(30)
''
DATA77
varchar(30)
''
DATA78
varchar(30)
''
DATA79
varchar(30)
''
DATA80
varchar(30)
''
DATA81
varchar(30)
''
DATA82
varchar(30)
''
DATA83
varchar(30)
''
DATA84
varchar(30)
''
DATA85
varchar(30)
''
DATA86
varchar(30)
''
DATA87
varchar(30)
''
DATA88
varchar(30)
''
DATA89
varchar(30)
''
DATA90
varchar(30)
''
DATA91
varchar(30)
''
DATA92
varchar(30)
''
DATA93
varchar(30)
''
DATA94
varchar(30)
''
DATA95
varchar(30)
''
DATA96
varchar(30)
''
DATA97
varchar(30)
''
DATA98
varchar(30)
''
DATA99
varchar(30)
''
DATA100
varchar(30)
''
DATA101
varchar(30)
''
DATA102
varchar(30)
''
DATA103
varchar(30)
''
DATA104
varchar(30)
''
DATA105
varchar(30)
''
DATA106
varchar(30)
''
DATA107
varchar(30)
''
DATA108
varchar(30)
''
DATA109
varchar(30)
''
DATA110
varchar(30)
''
DATA111
varchar(30)
''
DATA112
varchar(30)
''
DATA113
varchar(30)
''
DATA114
varchar(30)
''
DATA115
varchar(30)
''
DATA116
varchar(30)
''
DATA117
varchar(30)
''
DATA118
varchar(30)
''
DATA119
varchar(30)
''
DATA120
varchar(30)
''
DATA121
varchar(30)
''
DATA122
varchar(30)
''
DATA123
varchar(30)
''
DATA124
varchar(30)
''
DATA125
varchar(30)
''
DATA126
varchar(30)
''
DATA127
varchar(30)
''
DATA128
varchar(30)
''
DATA129
varchar(30)
''
DATA130
varchar(30)
''
DATA131
varchar(30)
''
DATA132
varchar(30)
''
DATA133
varchar(30)
''
DATA134
varchar(30)
''
DATA135
varchar(30)
''
DATA136
varchar(30)
''
DATA137
varchar(30)
''
DATA138
varchar(30)
''
DATA139
varchar(30)
''
DATA140
varchar(30)
''
DATA141
varchar(30)
''
DATA142
varchar(30)
''
DATA143
varchar(30)
''
DATA144
varchar(30)
''
DATA145
varchar(30)
''
DATA146
varchar(30)
''
DATA147
varchar(30)
''
DATA148
varchar(30)
''
DATA149
varchar(30)
''
DATA150
varchar(30)
''
DATA151
varchar(30)
''
DATA152
varchar(30)
''
DATA153
varchar(30)
''
DATA154
varchar(30)
''
DATA155
varchar(30)
''
DATA156
varchar(30)
''
DATA157
varchar(30)
''
DATA158
varchar(30)
''
DATA159
varchar(30)
''
DATA160
varchar(30)
''
DATA161
varchar(30)
''
DATA162
varchar(30)
''
DATA163
varchar(30)
''
DATA164
varchar(30)
''
DATA165
varchar(30)
''
DATA166
varchar(30)
''
DATA167
varchar(30)
''
DATA168
varchar(30)
''
DATA169
varchar(30)
''
DATA170
varchar(30)
''
DATA171
varchar(30)
''
DATA172
varchar(30)
''
DATA173
varchar(30)
''
DATA174
varchar(30)
''
DATA175
varchar(30)
''
DATA176
varchar(30)
''
DATA177
varchar(30)
''
DATA178
varchar(30)
''
DATA179
varchar(30)
''
DATA180
varchar(30)
''
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3