Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/DO10100
Product: Dynamics Online Services (6499)
Series: Sales
Display Name: DO Credit Card Services Activity
Physical Name: DO10100
Technical Name: doCreditCardAuthorizationActivitySeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 CUSTNMBR 
Customer Number STR15_RM_Customer_Number String 15 Key to the RM Customer MSTR (RM00101).
Click to show/hide
SELECT
['DO Credit Card Services Activity'].CUSTNMBR AS 'DO Credit Card Services Activity-Customer Number'
,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
DO10100 AS ['DO Credit Card Services Activity']
INNER JOIN
RM00101 AS ['RM Customer MSTR']
ON
['DO Credit Card Services Activity'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR2 DOCNUMBR Document Number STR20_Document_Number String 20 3 SOPTYPE SOP Type DDL_SOP_Type Integer 0 4 RMDTYPAL RM Document Type-All INT2 Integer 2 Document Type records the type of document.
Click to show/hide the Document Types
0 Balance Carried Forward
1 Sales / Invoice
2 Scheduled Payments
3 Debit Memo
4 Finance Charge
5 Service Repairs
6 Warranties
7 Credit Memo
8 Returns
9 Payments5 SEQNUMBR Sequence Number LI_Sequence_Number Long Integer 10 6 LNITMSEQ Line Item Sequence LI_Sequence_Number Long Integer 10 7 PAYMENTSERVICEREF Payment Service Reference STR36 String 36 8 DATE1 Date DT6 Date 6 9 PAYMENTSERVICEOP Payment Service Operation DDL_PaymentServiceOp Integer 0 10 TRXAMNT TRX Amount DLR19_$S2 Currency 19 11 PAYMENTSERVICESSTATUS Payment Services Status DDL_PaymentServicesStatus Integer 0 12 PAYMENTSERVICESSOURCE Payment Services Source STR36 String 36 13 doAUTHCODE doAuthorization Code STR50 String 50 14 ERMSGTXT Error Message Text STR255 String 255 15 ADDRESSRESULT Address Verification Result STR100 String 100