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
NaomiP
5/31/2007 12:24:00 PM
JC00106
Name
Physical Name
Type
Keyable
Storage
GPS_Reserved
GPS_RESERVED
Long Integer
10
4
WS Job Number
WS_Job_Number
String
17
18
Customer Number
CUSTNMBR
String
15
16
Address Code
ADRSCODE
String
15
16
WS Job Location Type
WS_Job_Location_Type
Integer
3
2
User ID
USERID
String
15
16
User Define 1
User_Define_1
String
30
32
User Define 2
User_Define_2
String
30
32
User Defined 1
USERDEF1
String
20
22
User Defined 2
USERDEF2
String
20
22
User Defined Integer 1
User_Def_Integer_1
Long Integer
6
4
User Defined Integer 2
User_Def_Integer_2
Long Integer
6
4
User Defined Integer 3
User_Defined_Integer_3
Long Integer
6
4
User Defined Integer 4
User_Defined_Integer_4
Long Integer
6
4
User Defined Dollar 1
User_Defined_Dollar_1
Currency
14
10
User Defined Dollar 2
User_Defined_Dollar_2
Currency
14
10
User Defined Dollar 3
User_Defined_Dollar_3
Currency
14
10
User Defined Dollar 4
User_Defined_Dollar_4
Currency
14
10
User Defined Date 1
USRDAT01
Date
8
4
User Defined Date 2
USRDAT02
Date
8
4
WS User Defined Date 3
User_Defined_Date_3
Date
6
4
WS User Defined Date 4
User_Defined_Date_4
Date
6
4
User Defined CB 1
User_Defined_CB_1
Boolean
0
2
User Defined CB 2
User_Defined_CB_2
Boolean
0
2
User Defined CB 3
User_Defined_CB_3
Boolean
0
2
User Defined CB 4
User_Defined_CB_4
Boolean
0
2
Wennsoft Affiliate
Wennsoft_Affiliate
String
15
16
Wennsoft Branch
Wennsoft_Branch
String
15
16
Wennsoft Region
Wennsoft_Region
String
15
16
Modified Date
MODIFDT
Date
8
4
Modified Time
Modified_Time
Time
6
4
Modified User ID
MDFUSRID
String
15
16
SV Language ID
SV_Language_ID
Integer
2
2
Time Zone
Time_Zone
String
3
4
Technician ID
Technician_ID
String
15
16
Technician Team
Technician_Team
String
15
16
WS Inactive
WS_Inactive
Boolean
0
2
WSReserved CB1
WSReserved_CB1
Boolean
0
2
WSReserved CB2
WSReserved_CB2
Boolean
0
2
WSReserved CB3
WSReserved_CB3
Boolean
0
2
WSReserved CB4
WSReserved_CB4
Boolean
0
2
WSReserved CB5
WSReserved_CB5
Boolean
0
2
WSReserved CB6
WSReserved_CB6
Boolean
0
2
WSReserved CB7
WSReserved_CB7
Boolean
0
2
WSReserved CB8
WSReserved_CB8
Boolean
0
2
WSReserved CB9
WSReserved_CB9
Boolean
0
2
WSReserved CB10
WSReserved_CB10
Boolean
0
2
WSReserved STR1
WSReserved_STR1
String
10
12
WSReserved STR2
WSReserved_STR2
String
10
12
Version:
Unknown or N/A
Section:
Dynamics GP
This thread has been marked as 'Closed' and archived
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