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 CM tables
CM00102
You are currently viewing the
COMPANY
database.
Change
COMPANY..CM00102
Table Definition
(
COMPANY..Checkbook EFT Optional Header
)
Field Definitions:
What is the 'source' column?
Column Name
Data Type
Default Value
Source
CHEKBKID
char(15)
''
Checkbook ...(more)
Join Now
join ... more text available
EFTOptionalBankLine1
smallint
0
EFTOptionalBankLine2
smallint
0
EFTBankLineArray1_1
char(1)
''
EFTBankLineArray1_2
char(1)
''
EFTBankLineArray1_3
char(1)
''
EFTBankLineArray1_4
char(1)
''
EFTBankLineArray1_5
char(1)
''
EFTBankLineArray1_6
char(1)
''
EFTBankLineArray1_7
char(1)
''
EFTBankLineArray1_8
char(1)
''
EFTBankLineArray1_9
char(1)
''
EFTBankLineArray1_10
char(1)
''
EFTBankLineArray1_11
char(1)
''
EFTBankLineArray1_12
char(1)
''
EFTBankLineArray1_13
char(1)
''
EFTBankLineArray1_14
char(1)
''
EFTBankLineArray1_15
char(1)
''
EFTBankLineArray1_16
char(1)
''
EFTBankLineArray1_17
char(1)
''
EFTBankLineArray1_18
char(1)
''
EFTBankLineArray1_19
char(1)
''
EFTBankLineArray1_20
char(1)
''
EFTBankLineArray1_21
char(1)
''
EFTBankLineArray1_22
char(1)
''
EFTBankLineArray1_23
char(1)
''
EFTBankLineArray1_24
char(1)
''
EFTBankLineArray1_25
char(1)
''
EFTBankLineArray2_1
char(1)
''
EFTBankLineArray2_2
char(1)
''
EFTBankLineArray2_3
char(1)
''
EFTBankLineArray2_4
char(1)
''
EFTBankLineArray2_5
char(1)
''
EFTBankLineArray2_6
char(1)
''
EFTBankLineArray2_7
char(1)
''
EFTBankLineArray2_8
char(1)
''
EFTBankLineArray2_9
char(1)
''
EFTBankLineArray2_10
char(1)
''
EFTBankLineArray2_11
char(1)
''
EFTBankLineArray2_12
char(1)
''
EFTBankLineArray2_13
char(1)
''
EFTBankLineArray2_14
char(1)
''
EFTBankLineArray2_15
char(1)
''
EFTBankLineArray2_16
char(1)
''
EFTBankLineArray2_17
char(1)
''
EFTBankLineArray2_18
char(1)
''
EFTBankLineArray2_19
char(1)
''
EFTBankLineArray2_20
char(1)
''
EFTBankLineArray2_21
char(1)
''
EFTBankLineArray2_22
char(1)
''
EFTBankLineArray2_23
char(1)
''
EFTBankLineArray2_24
char(1)
''
EFTBankLineArray2_25
char(1)
''
EFTBankLineArray3_1
char(1)
''
EFTBankLineArray3_2
char(1)
''
EFTBankLineArray3_3
char(1)
''
EFTBankLineArray3_4
char(1)
''
EFTBankLineArray3_5
char(1)
''
EFTBankLineArray3_6
char(1)
''
EFTBankLineArray3_7
char(1)
''
EFTBankLineArray3_8
char(1)
''
EFTBankLineArray3_9
char(1)
''
EFTBankLineArray3_10
char(1)
''
EFTBankLineArray3_11
char(1)
''
EFTBankLineArray3_12
char(1)
''
EFTBankLineArray3_13
char(1)
''
EFTBankLineArray3_14
char(1)
''
EFTBankLineArray3_15
char(1)
''
EFTBankLineArray3_16
char(1)
''
EFTBankLineArray3_17
char(1)
''
EFTBankLineArray3_18
char(1)
''
EFTBankLineArray3_19
char(1)
''
EFTBankLineArray3_20
char(1)
''
EFTBankLineArray3_21
char(1)
''
EFTBankLineArray3_22
char(1)
''
EFTBankLineArray3_23
char(1)
''
EFTBankLineArray3_24
char(1)
''
EFTBankLineArray3_25
char(1)
''
EFTBankLineArray4_1
char(1)
''
EFTBankLineArray4_2
char(1)
''
EFTBankLineArray4_3
char(1)
''
EFTBankLineArray4_4
char(1)
''
EFTBankLineArray4_5
char(1)
''
EFTBankLineArray4_6
char(1)
''
EFTBankLineArray4_7
char(1)
''
EFTBankLineArray4_8
char(1)
''
EFTBankLineArray4_9
char(1)
''
EFTBankLineArray4_10
char(1)
''
EFTBankLineArray4_11
char(1)
''
EFTBankLineArray4_12
char(1)
''
EFTBankLineArray4_13
char(1)
''
EFTBankLineArray4_14
char(1)
''
EFTBankLineArray4_15
char(1)
''
EFTBankLineArray4_16
char(1)
''
EFTBankLineArray4_17
char(1)
''
EFTBankLineArray4_18
char(1)
''
EFTBankLineArray4_19
char(1)
''
EFTBankLineArray4_20
char(1)
''
EFTBankLineArray4_21
char(1)
''
EFTBankLineArray4_22
char(1)
''
EFTBankLineArray4_23
char(1)
''
EFTBankLineArray4_24
char(1)
''
EFTBankLineArray4_25
char(1)
''
EFTBankLineArray5_1
char(1)
''
EFTBankLineArray5_2
char(1)
''
EFTBankLineArray5_3
char(1)
''
EFTBankLineArray5_4
char(1)
''
EFTBankLineArray5_5
char(1)
''
EFTBankLineArray5_6
char(1)
''
EFTBankLineArray5_7
char(1)
''
EFTBankLineArray5_8
char(1)
''
EFTBankLineArray5_9
char(1)
''
EFTBankLineArray5_10
char(1)
''
EFTBankLineArray5_11
char(1)
''
EFTBankLineArray5_12
char(1)
''
EFTBankLineArray5_13
char(1)
''
EFTBankLineArray5_14
char(1)
''
EFTBankLineArray5_15
char(1)
''
EFTBankLineArray5_16
char(1)
''
EFTBankLineArray5_17
char(1)
''
EFTBankLineArray5_18
char(1)
''
EFTBankLineArray5_19
char(1)
''
EFTBankLineArray5_20
char(1)
''
EFTBankLineArray5_21
char(1)
''
EFTBankLineArray5_22
char(1)
''
EFTBankLineArray5_23
char(1)
''
EFTBankLineArray5_24
char(1)
''
EFTBankLineArray5_25
char(1)
''
EFTBankLineArray6_1
char(1)
''
EFTBankLineArray6_2
char(1)
''
EFTBankLineArray6_3
char(1)
''
EFTBankLineArray6_4
char(1)
''
EFTBankLineArray6_5
char(1)
''
EFTBankLineArray6_6
char(1)
''
EFTBankLineArray6_7
char(1)
''
EFTBankLineArray6_8
char(1)
''
EFTBankLineArray6_9
char(1)
''
EFTBankLineArray6_10
char(1)
''
EFTBankLineArray6_11
char(1)
''
EFTBankLineArray6_12
char(1)
''
EFTBankLineArray6_13
char(1)
''
EFTBankLineArray6_14
char(1)
''
EFTBankLineArray6_15
char(1)
''
EFTBankLineArray6_16
char(1)
''
EFTBankLineArray6_17
char(1)
''
EFTBankLineArray6_18
char(1)
''
EFTBankLineArray6_19
char(1)
''
EFTBankLineArray6_20
char(1)
''
EFTBankLineArray6_21
char(1)
''
EFTBankLineArray6_22
char(1)
''
EFTBankLineArray6_23
char(1)
''
EFTBankLineArray6_24
char(1)
''
EFTBankLineArray6_25
char(1)
''
EFTBankLineArray7_1
char(1)
''
EFTBankLineArray7_2
char(1)
''
EFTBankLineArray7_3
char(1)
''
EFTBankLineArray7_4
char(1)
''
EFTBankLineArray7_5
char(1)
''
EFTBankLineArray7_6
char(1)
''
EFTBankLineArray7_7
char(1)
''
EFTBankLineArray7_8
char(1)
''
EFTBankLineArray7_9
char(1)
''
EFTBankLineArray7_10
char(1)
''
EFTBankLineArray7_11
char(1)
''
EFTBankLineArray7_12
char(1)
''
EFTBankLineArray7_13
char(1)
''
EFTBankLineArray7_14
char(1)
''
EFTBankLineArray7_15
char(1)
''
EFTBankLineArray7_16
char(1)
''
EFTBankLineArray7_17
char(1)
''
EFTBankLineArray7_18
char(1)
''
EFTBankLineArray7_19
char(1)
''
EFTBankLineArray7_20
char(1)
''
EFTBankLineArray7_21
char(1)
''
EFTBankLineArray7_22
char(1)
''
EFTBankLineArray7_23
char(1)
''
EFTBankLineArray7_24
char(1)
''
EFTBankLineArray7_25
char(1)
''
EFTBankLineArray8_1
char(1)
''
EFTBankLineArray8_2
char(1)
''
EFTBankLineArray8_3
char(1)
''
EFTBankLineArray8_4
char(1)
''
EFTBankLineArray8_5
char(1)
''
EFTBankLineArray8_6
char(1)
''
EFTBankLineArray8_7
char(1)
''
EFTBankLineArray8_8
char(1)
''
EFTBankLineArray8_9
char(1)
''
EFTBankLineArray8_10
char(1)
''
EFTBankLineArray8_11
char(1)
''
EFTBankLineArray8_12
char(1)
''
EFTBankLineArray8_13
char(1)
''
EFTBankLineArray8_14
char(1)
''
EFTBankLineArray8_15
char(1)
''
EFTBankLineArray8_16
char(1)
''
EFTBankLineArray8_17
char(1)
''
EFTBankLineArray8_18
char(1)
''
EFTBankLineArray8_19
char(1)
''
EFTBankLineArray8_20
char(1)
''
EFTBankLineArray8_21
char(1)
''
EFTBankLineArray8_22
char(1)
''
EFTBankLineArray8_23
char(1)
''
EFTBankLineArray8_24
char(1)
''
EFTBankLineArray8_25
char(1)
''
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