SOP10200 - Sales Transaction Amounts Work | Prospr

SOP10200 - Sales Transaction Amounts Work

Query Builder

Select * from SOP10200

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
CMPNTSEQ	Component Sequence	Long Integer	4	View
ITEMNMBR	Item Number	String	32	View
ITEMDESC	Item Description	String	102	View
NONINVEN	Non IV	Integer	2	View
DROPSHIP	Drop Ship	Integer	2	View
UOFM	U Of M	String	10	View
LOCNCODE	Location Code	String	12	View
UNITCOST	Unit Cost	Currency	10	View
ORUNTCST	Originating Unit Cost	Currency	10	View
UNITPRCE	Unit Price	Currency	10	View
ORUNTPRC	Originating Unit Price	Currency	10	View
XTNDPRCE	Extended Price	Currency	10	View
OXTNDPRC	Originating Extended Price	Currency	10	View
REMPRICE	Remaining Price	Currency	10	View
OREPRICE	Originating Remaining Price	Currency	10	View
EXTDCOST	Extended Cost	Currency	10	View
OREXTCST	Originating Extended Cost	Currency	10	View
MRKDNAMT	Markdown Amount	Currency	10	View
ORMRKDAM	Originating Markdown Amount	Currency	10	View
MRKDNPCT	Markdown Percent	Integer	2	View
MRKDNTYP	Markdown Type	Integer	2	View
INVINDX	Inventory Index	Long Integer	4	View
CSLSINDX	Cost Of Sales Index	Long Integer	4	View
SLSINDX	Sales Index	Long Integer	4	View
MKDNINDX	Markdown Index	Long Integer	4	View
RTNSINDX	Returns Index	Long Integer	4	View
INUSINDX	In Use Index	Long Integer	4	View
INSRINDX	In Service Index	Long Integer	4	View
DMGDINDX	Damaged Index	Long Integer	4	View
ITMTSHID	Item Tax Schedule ID	String	16	View
IVITMTXB	IV Item Taxable	Integer	2	View
BKTSLSAM	Backout Sales Amount	Currency	10	View
ORBKTSLS	Originating Backout Sales Amount	Currency	10	View
TAXAMNT	Tax Amount	Currency	10	View
ORTAXAMT	Originating Tax Amount	Currency	10	View
TXBTXAMT	Taxable Tax Amount	Currency	10	View
OTAXTAMT	Originating Taxable Tax Amount	Currency	10	View
BSIVCTTL	Based On Invoice Total	Boolean	2	View
TRDISAMT	Trade Discount Amount	Currency	10	View
ORTDISAM	Originating Trade Discount Amount	Currency	10	View
DISCSALE	Discount Available Sales	Currency	10	View
ORDAVSLS	Originating Discount Available Sales	Currency	10	View
QUANTITY	QTY	Currency	10	View
ATYALLOC	QTY Allocated	Currency	10	View
QTYINSVC	QTY In Service	Currency	10	View
QTYINUSE	QTY In Use	Currency	10	View
QTYDMGED	QTY Damaged	Currency	10	View
QTYRTRND	QTY Returned	Currency	10	View
QTYONHND	QTY On Hand	Currency	10	View
QTYCANCE	QTY Canceled	Currency	10	View
QTYCANOT	QTY Canceled Other	Currency	10	View
QTYONPO	QTY On PO	Currency	10	View
QTYORDER	QTY Ordered	Currency	10	View
QTYPRBAC	QTY Prev Back Ordered	Currency	10	View
QTYPRBOO	QTY Prev BO On Order	Currency	10	View
QTYPRINV	QTY Prev Invoiced	Currency	10	View
QTYPRORD	QTY Prev Ordered	Currency	10	View
QTYPRVRECVD	QTY Prev Received	Currency	10	View
QTYRECVD	QTY Received	Currency	10	View
QTYREMAI	QTY Remaining	Currency	10	View
QTYREMBO	QTY Remaining On BO	Currency	10	View
QTYTBAOR	QTY To Back Order	Currency	10	View
QTYTOINV	QTY To Invoice	Currency	10	View
QTYTORDR	QTY To Order	Currency	10	View
QTYFULFI	QTY Fulfilled	Currency	10	View
QTYSLCTD	QTY Selected	Currency	10	View
QTYBSUOM	QTY In Base U Of M	Currency	10	View
EXTQTYAL	Existing Qty Available	Currency	10	View
EXTQTYSEL	Existing Qty Selected	Currency	10	View
ReqShipDate	Requested Ship Date	Date	4	View
FUFILDAT	Fulfillment Date	Date	4	View
ACTLSHIP	Actual Ship Date	Date	4	View
SHIPMTHD	Shipping Method	String	16	View
SALSTERR	Sales Territory	String	16	View
SLPRSNID	Salesperson ID	String	16	View
PRCLEVEL	PriceLevel	String	12	View
COMMNTID	Comment ID	String	16	View
BRKFLD1	Break Field 1	Integer	2	View
BRKFLD2	Break Field 2	Integer	2	View
BRKFLD3	Break Field 3	Integer	2	View
CURRNIDX	Currency Index	Integer	2	View
TRXSORCE	TRX Source	String	14	View
SOPLNERR	SOP LINE Errors	Long Integer	4	View
ORGSEQNM	Original Sequence Number Corrected	Long Integer	4	View
ITEMCODE	Item Code	String	16	View
PURCHSTAT	Purchasing Status	Integer	2	View
DECPLQTY	Decimal Places QTYS	Integer	2	View
DECPLCUR	Decimal Places Currency	Integer	2	View
ODECPLCU	Originating Decimal Places Currency	Integer	2	View
QTYTOSHP	QTY To Ship	Currency	10	View
XFRSHDOC	Transferred To Shipping Document	Boolean	2	View
EXCEPTIONALDEMAND	Exceptional Demand	Boolean	2	View
TAXSCHID	Tax Schedule ID	String	16	View
TXSCHSRC	Tax Schedule Source	Integer	2	View
PRSTADCD	Primary Shipto Address Code	String	16	View
ShipToName	ShipToName	String	66	View
CNTCPRSN	Contact Person	String	62	View
ADDRESS1	Address 1	String	62	View
ADDRESS2	Address 2	String	62	View
ADDRESS3	Address 3	String	62	View
CITY	City	String	36	View
STATE	State	String	30	View
ZIPCODE	Zip Code	String	12	View
CCode	Country Code	String	8	View
COUNTRY	Country	String	62	View
PHONE1	Phone 1	String	22	View
PHONE2	Phone 2	String	22	View
PHONE3	Phone 3	String	22	View
FAXNUMBR	Fax Number	String	22	View
Flags	Flags	Integer	2	View
BackoutTradeDisc	Backout Trade Discount Amount	Currency	10	View
OrigBackoutTradeDisc	Originating Backout Trade Discount Amount	Currency	10	View
GPSFOINTEGRATIONID	GPSFO Integration ID	String	32	View
INTEGRATIONSOURCE	Integration Source	Integer	2	View
INTEGRATIONID	Integration ID	String	32	View
CONTNBR	Contract Number	String	12	View
CONTLNSEQNBR	Contract Line SEQ Number	Currency	10	View
CONTSTARTDTE	Contract Start Date	Date	4	View
CONTENDDTE	Contract End Date	Date	4	View
CONTITEMNBR	Contract Item Number	String	32	View
CONTSERIALNBR	Contract Serial Number	String	22	View
BULKPICKPRNT	Bulk Pick Printed	Boolean	2	View
INDPICKPRNT	Individual Pick Printed	Boolean	2	View
ISLINEINTRA	IsLineIntrastat	Boolean	2	View
SOFULFILLMENTBIN	SO Fulfillment Bin	String	16	View
MULTIPLEBINS	Multiple Bins	Boolean	2	View
Print_Phone_NumberGB	Print Phone Number GB	Integer	2	View

SOP10200 - Sales Transaction Amounts Work

Query Builder

Customer Service

Information

My Account

Contact Us