SOP10105 - Sales Taxes Work and History | Prospr

SOP10105 - Sales Taxes Work and History

Select * from SOP10105

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
LNITMSEQ	Line Item Sequence	Long Integer	4	View
TAXDTLID	Tax Detail ID	String	16	View
ACTINDX	Account Index	Long Integer	4	View
BKOUTTAX	Backout Tax	Boolean	2	View
TXABLETX	Taxable Tax	Boolean	2	View
STAXAMNT	Sales Tax Amount	Currency	10	View
ORSLSTAX	Originating Sales Tax Amount	Currency	10	View
FRTTXAMT	Freight Tax Amount	Currency	10	View
ORFRTTAX	Originating Freight Tax Amount	Currency	10	View
MSCTXAMT	Misc Tax Amount	Currency	10	View
ORMSCTAX	Originating Misc Tax Amount	Currency	10	View
TAXDTSLS	Tax Detail Total Sales	Currency	10	View
ORTOTSLS	Originating Total Sales	Currency	10	View
TDTTXSLS	Tax Detail Total Taxable Sales	Currency	10	View
ORTXSLS	Originating Total Taxable Sales	Currency	10	View
TXDTOTTX	Tax Detail Total Tax Potential	Currency	10	View
OTTAXPON	Originating Total Tax Potential	Currency	10	View
DELETE1	Delete	Boolean	2	View
CURRNIDX	Currency Index	Integer	2	View
TRXSORCE	TRX Source	String	14	View