DO10100 - DO Credit Card Services Activity
Dynamics GP table DO10100 (DO Credit Card Services Activity) contains 15 columns including CUSTNMBR, DOCNUMBR, SOPTYPE....
SQL Query Builder
15 Columns
| Column | Description | Type | Length | ||
|---|---|---|---|---|---|
| CUSTNMBR | Customer Number | String | 16 | ||
| DOCNUMBR | Document Number | String | 22 | ||
| SOPTYPE | SOP Type1 = Quote2 = Order3 = Invoice4 = Return5 = Back Order6 = Fulfillment Order (In SBF, this value is not available.) | Integer | 2 | ||
SOP Document Type values (6) 1 = Quote2 = Order3 = Invoice4 = Return5 = Back Order6 = Fulfillment Order | |||||
| RMDTYPAL | RM Document Type-All0 = Reserved for balance carried forward records1 = Sales / Invoice2 = Reserved for schedule payments3 = Debit Memos4 = Finance Charges5 = Service Repairs6= Warranties7 = Credit Memos8 = Returns9 = Payments | Integer | 2 | ||
| SEQNUMBR | Sequence Number | Long Integer | 4 | ||
| LNITMSEQ | Line Item Sequence | Long Integer | 4 | ||
| PAYMENTSERVICEREF | Payment Service Reference | String | 38 | ||
| DATE1 | Date | Date | 4 | ||
| PAYMENTSERVICEOP | Payment Service Operation | Integer | 2 | ||
| TRXAMNT | TRX Amount | Currency | 10 | ||
| PAYMENTSERVICESSTATUS | Payment Services Status | Integer | 2 | ||
| PAYMENTSERVICESSOURCE | Payment Services Source | String | 38 | ||
| doAUTHCODE | doAuthorization Code | String | 52 | ||
| ERMSGTXT | Error Message Text | String | 256 | ||
| ADDRESSRESULT | Address Verification Result | String | 102 | ||
Related Tables
Tables that share columns with DO10100. Click "Join" to add to your query.