SOP10103 - Sales Payment Work and History | Prospr

SOP10103 - Sales Payment Work and History

Select * from SOP10103

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
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
SOPNUMBE	SOP Number	String	22	View
SEQNUMBR	Sequence Number	Long Integer	4	View
PYMTTYPE	Payment Type	Integer	2	View
DOCNUMBR	Document Number	String	22	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
CHEKBKID	Checkbook ID	String	16	View
CHEKNMBR	Check Number	String	22	View
CARDNAME	Card Name	String	16	View
RCTNCCRD	Receipt Number Credit Card	String	22	View
AUTHCODE	Authorization Code	String	16	View
AMNTPAID	Amount Paid	Currency	10	View
OAMTPAID	Originating Amount Paid	Currency	10	View
AMNTREMA	Amount Remaining	Currency	10	View
OAMNTREM	Originating Amount Remaining	Currency	10	View
DOCDATE	Document Date	Date	4	View
EXPNDATE	Expiration Date	Date	4	View
CURNCYID	Currency ID	String	16	View
CURRNIDX	Currency Index	Integer	2	View
TRXSORCE	TRX Source	String	14	View
DEPSTATS	Deposit Status	Integer	2	View
DELETE1	Delete	Boolean	2	View
GLPOSTDT	GL Posting Date	Date	4	View
CASHINDEX	Cash Index	Long Integer	4	View
DEPINDEX	Deposits Index	Long Integer	4	View
EFTFLAG	EFT Flag	Boolean	2	View