Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/DO40100
Product: Dynamics Online Services (6499)
Series: System
Display Name: DO Setup
Physical Name: DO40100
Technical Name: doSetupSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 CMPANYID 
Company ID INT5 Integer 4 Key to the Company Master (SY01500).
Click to show/hide
SELECT
['DO Setup'].CMPANYID AS 'DO Setup-Company ID'
,['Company Master'].CMPANYID AS 'Company Master-Company ID'
FROM
DO40100 AS ['DO Setup']
INNER JOIN
DYNAMICS..SY01500 AS ['Company Master']
ON
['DO Setup'].CMPANYID = ['Company Master'].CMPANYID2 WINDLIVEID Windows Live ID STR255 String 255 3 WINLIVEPASSWORD Windows Live Password STR50 String 50 4 COMMERCEACCTNUM Commerce Account Number STR50 String 50 5 COMMERCEORG Commerce Organization STR50 String 50 6 ECOMMORDID Ecommerce Order ID STR15_LBAU String 15 7 ECOMMINVID Ecommerce Invoice ID STR15_LBAU String 15 8 CUSTNMBR Customer Number STR15_RM_Customer_Number String 15 Key to the RM Customer MSTR (RM00101).
Click to show/hide
SELECT
['DO Setup'].CUSTNMBR AS 'DO Setup-Customer Number'
,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
DO40100 AS ['DO Setup']
INNER JOIN
RM00101 AS ['RM Customer MSTR']
ON
['DO Setup'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR9 DOCID Document ID STR15_LBAU String 15 10 OCSACTIVE Activate Online Commerce Service CB_ActivateOnlineCommerceService Boolean 0 11 PSACTIVE Activate Payment Service CB_ActivatePaymentService Boolean 0 12 PMTSERVCID Payment Service Service ID STR50 String 50 13 CARDNAME Card Name STR15_Card_Name String 15 14 VoidAVSAuthorization Void AVS Authorization Void authorization Boolean 0 15 VerifyAVSUsing Verify AVS Using Verify Authorization Integer 0 16 ONLINECERTIFICATE Online Certificate TX500 Text 500