GP Tables

DO40100 - DO Setup

Dynamics GP table DO40100 (DO Setup) contains 16 columns including CMPANYID, WINDLIVEID, WINLIVEPASSWORD....

SQL Query Builder

16 Columns

Column Description Type Length
CMPANYID Company ID Integer 2
WINDLIVEID Windows Live ID String 256
WINLIVEPASSWORD Windows Live Password String 52
COMMERCEACCTNUM Commerce Account Number String 52
COMMERCEORG Commerce Organization String 52
ECOMMORDID Ecommerce Order ID String 16
ECOMMINVID Ecommerce Invoice ID String 16
CUSTNMBR Customer Number String 16
DOCID Document ID String 16
OCSACTIVE Activate Online Commerce Service Boolean 2
PSACTIVE Activate Payment Service Boolean 2
PMTSERVCID Payment Service Service ID String 52
CARDNAME Card Name String 16
VoidAVSAuthorization Void AVS Authorization Boolean 2
VerifyAVSUsing Verify AVS Using Integer 2
ONLINECERTIFICATE Online Certificate Text 2

Related Tables

Tables that share columns with DO40100. Click "Join" to add to your query.