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 Extender tables
EXT40150
You are currently viewing the
COMPANY
database.
Change
COMPANY..EXT40150
Table Definition
(
COMPANY..Extender Detail Windows
)
Field Definitions:
What is the 'source' column?
Column Name
Data Type
Default Value
Source
PT_Window_ID
char(15)
''
PT_Window_Description
char(65)
''
PRODID
smallint
0
Long_Form_Name
char(255)
''
Long_Window_Name
char(101)
''
Detail_Prompts_1
char(65)
''
Detail_Prompts_2
char(65)
''
Detail_Prompts_3
char(65)
''
Detail_Prompts_4
char(65)
''
Detail_Prompts_5
char(65)
''
Detail_Prompts_6
char(65)
''
Detail_Prompts_7
char(65)
''
Detail_Prompts_8
char(65)
''
Detail_Prompts_9
char(65)
''
Detail_Prompts_10
char(65)
''
Detail_Prompts_11
char(65)
''
Detail_Prompts_12
char(65)
''
Detail_Prompts_13
char(65)
''
Detail_Prompts_14
char(65)
''
Detail_Prompts_15
char(65)
''
Detail_Prompts_16
char(65)
''
Detail_Prompts_17
char(65)
''
Detail_Prompts_18
char(65)
''
Detail_Prompts_19
char(65)
''
Detail_Prompts_20
char(65)
''
Detail_Field_Type_1
smallint
0
Detail_Field_Type_2
smallint
0
Detail_Field_Type_3
smallint
0
Detail_Field_Type_4
smallint
0
Detail_Field_Type_5
smallint
0
Detail_Field_Type_6
smallint
0
Detail_Field_Type_7
smallint
0
Detail_Field_Type_8
smallint
0
Detail_Field_Type_9
smallint
0
Detail_Field_Type_10
smallint
0
Detail_Field_Type_11
smallint
0
Detail_Field_Type_12
smallint
0
Detail_Field_Type_13
smallint
0
Detail_Field_Type_14
smallint
0
Detail_Field_Type_15
smallint
0
Detail_Field_Type_16
smallint
0
Detail_Field_Type_17
smallint
0
Detail_Field_Type_18
smallint
0
Detail_Field_Type_19
smallint
0
Detail_Field_Type_20
smallint
0
Detail_Lookups_1
smallint
0
Detail_Lookups_2
smallint
0
Detail_Lookups_3
smallint
0
Detail_Lookups_4
smallint
0
Detail_Lookups_5
smallint
0
Detail_Lookups_6
smallint
0
Detail_Lookups_7
smallint
0
Detail_Lookups_8
smallint
0
Detail_Lookups_9
smallint
0
Detail_Lookups_10
smallint
0
Detail_Lookups_11
smallint
0
Detail_Lookups_12
smallint
0
Detail_Lookups_13
smallint
0
Detail_Lookups_14
smallint
0
Detail_Lookups_15
smallint
0
Detail_Lookups_16
smallint
0
Detail_Lookups_17
smallint
0
Detail_Lookups_18
smallint
0
Detail_Lookups_19
smallint
0
Detail_Lookups_20
smallint
0
Detail_Required_1
tinyint
0
Detail_Required_2
tinyint
0
Detail_Required_3
tinyint
0
Detail_Required_4
tinyint
0
Detail_Required_5
tinyint
0
Detail_Required_6
tinyint
0
Detail_Required_7
tinyint
0
Detail_Required_8
tinyint
0
Detail_Required_9
tinyint
0
Detail_Required_10
tinyint
0
Detail_Required_11
tinyint
0
Detail_Required_12
tinyint
0
Detail_Required_13
tinyint
0
Detail_Required_14
tinyint
0
Detail_Required_15
tinyint
0
Detail_Required_16
tinyint
0
Detail_Required_17
tinyint
0
Detail_Required_18
tinyint
0
Detail_Required_19
tinyint
0
Detail_Required_20
tinyint
0
Detail_Decimal_Places_1
smallint
0
Detail_Decimal_Places_2
smallint
0
Detail_Decimal_Places_3
smallint
0
Detail_Decimal_Places_4
smallint
0
Detail_Decimal_Places_5
smallint
0
Detail_Decimal_Places_6
smallint
0
Detail_Decimal_Places_7
smallint
0
Detail_Decimal_Places_8
smallint
0
Detail_Decimal_Places_9
smallint
0
Detail_Decimal_Places_10
smallint
0
Detail_Decimal_Places_11
smallint
0
Detail_Decimal_Places_12
smallint
0
Detail_Decimal_Places_13
smallint
0
Detail_Decimal_Places_14
smallint
0
Detail_Decimal_Places_15
smallint
0
Detail_Decimal_Places_16
smallint
0
Detail_Decimal_Places_17
smallint
0
Detail_Decimal_Places_18
smallint
0
Detail_Decimal_Places_19
smallint
0
Detail_Decimal_Places_20
smallint
0
Detail_Row_1
smallint
0
Detail_Row_2
smallint
0
Detail_Row_3
smallint
0
Detail_Row_4
smallint
0
Detail_Row_5
smallint
0
Detail_Row_6
smallint
0
Detail_Row_7
smallint
0
Detail_Row_8
smallint
0
Detail_Row_9
smallint
0
Detail_Row_10
smallint
0
Detail_Row_11
smallint
0
Detail_Row_12
smallint
0
Detail_Row_13
smallint
0
Detail_Row_14
smallint
0
Detail_Row_15
smallint
0
Detail_Row_16
smallint
0
Detail_Row_17
smallint
0
Detail_Row_18
smallint
0
Detail_Row_19
smallint
0
Detail_Row_20
smallint
0
HotKey
char(1)
''
Long_Field_Name
char(101)
''
PT_Open_Method
smallint
0
Auto_Open
tinyint
0
PT_Auto_Close
tinyint
0
Show_Total_CB
tinyint
0
Total_Field
smallint
0
NOTEINDX
numeric(19,5)
0.00
ID of the ...(more)
Join Now
join ... more text available
MODIFDT
datetime
'1/1/1900'
The last d...(more)
Join Now
MDFUSRID
char(15)
''
The userna...(more)
Join Now
join ... more text available
CREATDDT
datetime
'1/1/1900'
Created Da...(more)
Join Now
POP10100.CREATDDT
CRUSRID
char(15)
''
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
3