SOP10102 - Sales Distribution Work and History | Prospr

SOP10102 - Sales Distribution Work and History

Select * from SOP10102

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
DISTTYPE	Distribution Type 1 = Cash 2 = Payable 3 = Discount Available 4 = Discount Taken 5 = Finance Charge 6 = Purchase 8 = Misc. Charge 9 = Freight 10 = Taxes 11 = Writeoffs 12 = Other 13 = GST Disc	Integer	2	View
DistRef	Distribution Reference	String	32	View
ACTINDX	Account Index	Long Integer	4	View
DEBITAMT	Debit Amount	Currency	10	View
ORDBTAMT	Originating Debit Amount	Currency	10	View
CRDTAMNT	Credit Amount	Currency	10	View
ORCRDAMT	Originating Credit Amount	Currency	10	View
CURRNIDX	Currency Index	Integer	2	View
TRXSORCE	TRX Source	String	14	View
POSTED	Posted	Boolean	2	View
Contract_Exchange_Rate	Contract Exchange Rate	Currency (Variable)	10	View