DO10100 - DO Credit Card Services Activity | Prospr

DO10100 - DO Credit Card Services Activity

Select * from DO10100

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
CUSTNMBR	Customer Number	String	16	View
DOCNUMBR	Document Number	String	22	View
SOPTYPE	SOP Type 1 = Quote 2 = Order 3 = Invoice 4 = Return 5 = Back Order 6 = Fulfillment Order (In SBF, this value is not available.)	Integer	2	View
RMDTYPAL	RM Document Type-All 0 = Reserved for balance carried forward records 1 = Sales / Invoice 2 = Reserved for schedule payments 3 = Debit Memos 4 = Finance Charges 5 = Service Repairs 6= Warranties 7 = Credit Memos 8 = Returns 9 = Payments	Integer	2	View
SEQNUMBR	Sequence Number	Long Integer	4	View
LNITMSEQ	Line Item Sequence	Long Integer	4	View
PAYMENTSERVICEREF	Payment Service Reference	String	38	View
DATE1	Date	Date	4	View
PAYMENTSERVICEOP	Payment Service Operation	Integer	2	View
TRXAMNT	TRX Amount	Currency	10	View
PAYMENTSERVICESSTATUS	Payment Services Status	Integer	2	View
PAYMENTSERVICESSOURCE	Payment Services Source	String	38	View
doAUTHCODE	doAuthorization Code	String	52	View
ERMSGTXT	Error Message Text	String	256	View
ADDRESSRESULT	Address Verification Result	String	102	View