SOP10100 - Sales Transaction Work | Prospr - Dynamics GP Table Reference

SOP10100 - Sales Transaction Work

Query Builder

Select * from SOP10100

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
ORIGTYPE	Original 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
ORIGNUMB	Original Number	String	22	View
DOCID	Document ID	String	16	View
DOCDATE	Document Date	Date	4	View
GLPOSTDT	GL Posting Date	Date	4	View
QUOTEDAT	Quote Date	Date	4	View
QUOEXPDA	Quote Expiration Date	Date	4	View
ORDRDATE	Order Date	Date	4	View
INVODATE	Invoice Date	Date	4	View
BACKDATE	Back Order Date	Date	4	View
RETUDATE	Return Date	Date	4	View
ReqShipDate	Requested Ship Date	Date	4	View
FUFILDAT	Fulfillment Date	Date	4	View
ACTLSHIP	Actual Ship Date	Date	4	View
DISCDATE	Discount Date	Date	4	View
DUEDATE	Due Date	Date	4	View
REPTING	Repeating 0 = Non-repeating document 1 = Repeating	Boolean	2	View
TRXFREQU	TRX Frequency 1 = Weekly 2 = Biweekly 3 = Semimonthly 4 = Monthly 5 = Bimonthly 6 = Quarterly 7 = Miscellaneous	Integer	2	View
TIMEREPD	Times Repeated	Integer	2	View
TIMETREP	Times To Repeat	Integer	2	View
DYSTINCR	Days to Increment	Integer	2	View
DTLSTREP	Date Last Repeated	Date	4	View
DSTBTCH1	Dest Batch 1	String	16	View
DSTBTCH2	Dest Batch 2	String	16	View
USDOCID1	Use Document ID 1	String	16	View
USDOCID2	Use Document ID 2	String	16	View
DISCFRGT	Discount Available Freight	Currency	10	View
ORDAVFRT	Originating Discount Available Freight	Currency	10	View
DISCMISC	Discount Available Misc	Currency	10	View
ORDAVMSC	Originating Discount Available Misc	Currency	10	View
DISAVAMT	Discount Available Amount	Currency	10	View
ORDAVAMT	Originating Discount Available Amount	Currency	10	View
DISCRTND	Discount Returned	Currency	10	View
ORDISRTD	Originating Discount Returned	Currency	10	View
DISTKNAM	Discount Taken Amount	Currency	10	View
ORDISTKN	Originating Discount Taken Amount	Currency	10	View
DSCPCTAM	Discount Percent Amount	Integer	2	View
DSCDLRAM	Discount Dollar Amount	Currency	10	View
ORDDLRAT	Originating Discount Dollar Amount	Currency	10	View
DISAVTKN	Discount Available Taken	Currency	10	View
ORDATKN	Originating Discount Available Taken	Currency	10	View
PYMTRMID	Payment Terms ID	String	22	View
PRCLEVEL	PriceLevel	String	12	View
LOCNCODE	Location Code	String	12	View
BCHSOURC	Batch Source	String	16	View
BACHNUMB	Batch Number	String	16	View
CUSTNMBR	Customer Number	String	16	View
CUSTNAME	Customer Name	String	66	View
CSTPONBR	Customer PO Number	String	22	View
PROSPECT	Prospect 0 = Existing Customer 1 = Prospect	Integer	2	View
MSTRNUMB	Master Number	Long Integer	4	View
PCKSLPNO	Packing Slip Number	String	22	View
PICTICNU	Picking Ticket Number	String	22	View
MRKDNAMT	Markdown Amount	Currency	10	View
ORMRKDAM	Originating Markdown Amount	Currency	10	View
PRBTADCD	Primary Billto Address Code	String	16	View
PRSTADCD	Primary Shipto Address Code	String	16	View
CNTCPRSN	Contact Person	String	62	View
ShipToName	ShipToName	String	66	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
PHNUMBR1	Phone Number 1	String	22	View
PHNUMBR2	Phone Number 2	String	22	View
PHONE3	Phone 3	String	22	View
FAXNUMBR	Fax Number	String	22	View
COMAPPTO	Commission Applied To	Integer	2	View
COMMAMNT	Commission Amount	Currency	10	View
OCOMMAMT	Originating Commission Amount	Currency	10	View
CMMSLAMT	Commission Sale Amount	Currency	10	View
ORCOSAMT	Originating Commission Sales Amount	Currency	10	View
NCOMAMNT	Non-Commissioned Amount	Currency	10	View
ORNCMAMT	Originating Non-Commissioned Amount	Currency	10	View
SHIPMTHD	Shipping Method	String	16	View
TRDISAMT	Trade Discount Amount	Currency	10	View
ORTDISAM	Originating Trade Discount Amount	Currency	10	View
TRDISPCT	Trade Discount Percent	Integer	2	View
SUBTOTAL	Subtotal	Currency	10	View
ORSUBTOT	Originating Subtotal	Currency	10	View
REMSUBTO	Remaining Subtotal	Currency	10	View
OREMSUBT	Originating Remaining Subtotal	Currency	10	View
EXTDCOST	Extended Cost	Currency	10	View
OREXTCST	Originating Extended Cost	Currency	10	View
FRTAMNT	Freight Amount	Currency	10	View
ORFRTAMT	Originating Freight Amount	Currency	10	View
MISCAMNT	Misc Amount	Currency	10	View
ORMISCAMT	Originating Misc Amount	Currency	10	View
TXENGCLD	Tax Engine Called	Boolean	2	View
TAXEXMT1	Tax Exempt 1	String	26	View
TAXEXMT2	Tax Exempt 2	String	26	View
TXRGNNUM	Tax Registration Number	String	26	View
TAXSCHID	Tax Schedule ID	String	16	View
TXSCHSRC	Tax Schedule Source	Integer	2	View
BSIVCTTL	Based On Invoice Total	Boolean	2	View
FRTSCHID	Freight Schedule ID	String	16	View
FRTTXAMT	Freight Tax Amount	Currency	10	View
ORFRTTAX	Originating Freight Tax Amount	Currency	10	View
FRGTTXBL	Freight Taxable 1 = Taxable 2 = Nontaxable 3 = Base on customers	Integer	2	View
MSCSCHID	Misc Schedule ID	String	16	View
MSCTXAMT	Misc Tax Amount	Currency	10	View
ORMSCTAX	Originating Misc Tax Amount	Currency	10	View
MISCTXBL	Misc Taxable 1 = Taxable 2 = Nontaxable 3 = Base on customers	Integer	2	View
BKTFRTAM	Backout Freight Amount	Currency	10	View
ORBKTFRT	Originating Backout Freight Amount	Currency	10	View
BKTMSCAM	Backout Misc Amount	Currency	10	View
ORBKTMSC	Originating Backout Misc Amount	Currency	10	View
BCKTXAMT	Backout Tax Amount	Currency	10	View
OBTAXAMT	Originating Backout Tax Amount	Currency	10	View
TXBTXAMT	Taxable Tax Amount	Currency	10	View
OTAXTAMT	Originating Taxable Tax Amount	Currency	10	View
TAXAMNT	Tax Amount	Currency	10	View
ORTAXAMT	Originating Tax Amount	Currency	10	View
ECTRX	EC Transaction	Boolean	2	View
DOCAMNT	Document Amount	Currency	10	View
ORDOCAMT	Originating Document Amount	Currency	10	View
PYMTRCVD	Payment Received	Currency	10	View
ORPMTRVD	Originating Payment Received	Currency	10	View
DEPRECVD	Deposit Received	Currency	10	View
ORDEPRVD	Originating Deposit Received	Currency	10	View
CODAMNT	COD Amount	Currency	10	View
ORCODAMT	Originating COD Amount	Currency	10	View
ACCTAMNT	Account Amount	Currency	10	View
ORACTAMT	Originating Account Amount	Currency	10	View
SALSTERR	Sales Territory	String	16	View
SLPRSNID	Salesperson ID	String	16	View
UPSZONE	UPS Zone	String	4	View
TIMESPRT	Times Printed	Integer	2	View
PSTGSTUS	Posting Status 1 = Work 2 = Open 3 = History 4 = Originating	Integer	2	View
VOIDSTTS	Void Status 0 = Document has not been voided. 1 = Document has been voided. 2 = Document has been marked NSF and voided.	Integer	2	View
ALLOCABY	Allocate By	Integer	2	View
NOTEINDX	Note Index	Currency	10	View
CURNCYID	Currency ID	String	16	View
CURRNIDX	Currency Index	Integer	2	View
RATETPID	Rate Type ID	String	16	View
EXGTBLID	Exchange Table ID	String	16	View
XCHGRATE	Exchange Rate	Currency (Variable)	10	View
DENXRATE	Denomination Exchange Rate	Currency (Variable)	10	View
EXCHDATE	Exchange Date	Date	4	View
TIME1	Time	Time	4	View
RTCLCMTD	Rate Calculation Method	Integer	2	View
MCTRXSTT	MC Transaction State 0 = Euro currency is not created or no denomination currencies are enabled. 1 = Originating is not a denomination; Functional is not a denomination 2 = Originating is not a denomination; Functional is the Euro currency. 3 = Originating is not a denomination; Functional is a denomination. 4 = Originating is a denomination; Functional is not a denomination. 5 = Originating is a denomination; Functional is a denomination. 6 = Originating is a denomination; Functional is the Euro currency. 7 = Originating is the Euro currency; Functional is a denomination. 8 = Originating is the Euro currency; Functional is not a denomination.	Integer	2	View
TRXSORCE	TRX Source	String	14	View
SOPHDRE1	SOP HDR Errors 1	Long Integer	4	View
SOPHDRE2	SOP HDR Errors 2	Long Integer	4	View
SOPLNERR	SOP LINE Errors	Long Integer	4	View
SOPHDRFL	SOP HDR Flags	Long Integer	4	View
SOPMCERR	SOP MC Posting Error Messages	Long Integer	4	View
COMMNTID	Comment ID	String	16	View
REFRENCE	Reference	String	32	View
POSTEDDT	Posted Date	Date	4	View
PTDUSRID	Posted User ID	String	16	View
USER2ENT	User To Enter	String	16	View
CREATDDT	Created Date	Date	4	View
MODIFDT	Modified Date	Date	4	View
Tax_Date	Tax Date	Date	4	View
APLYWITH	Apply Withholding	Boolean	2	View
WITHHAMT	Withholding Amount	Currency	10	View
SHPPGDOC	Shipping Document	Boolean	2	View
CORRCTN	Correction	Boolean	2	View
SIMPLIFD	Simplified	Boolean	2	View
CORRNXST	Correction to Nonexisting Transaction	Boolean	2	View
DOCNCORR	Document Number Corrected	String	22	View
SEQNCORR	Sequence Number Corrected	Integer	2	View
SALEDATE	Sale Date	Date	4	View
SOPHDRE3	SOP HDR Errors 3	Long Integer	4	View
EXCEPTIONALDEMAND	Exceptional Demand	Boolean	2	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
SOPSTATUS	SOP Status	Integer	2	View
SHIPCOMPLETE	Ship Complete Document	Boolean	2	View
DIRECTDEBIT	Direct Debit	Boolean	2	View
WorkflowApprStatCreditLm	Workflow Approval Status Credit Limit	Integer	2	View
WorkflowPriorityCreditLm	Workflow Priority Credit Limit	Integer	2	View
WorkflowApprStatusQuote	Workflow Approval Status Quote	Integer	2	View
WorkflowPriorityQuote	Workflow Priority Quote	Integer	2	View
ContractExchangeRateStat	Contract Exchange Rate Status	Integer	2	View
Print_Phone_NumberGB	Print Phone Number GB	Integer	2	View

SOP10100 - Sales Transaction Work

Query Builder

Customer Service

Information

My Account

Contact Us