GP Tables

SOP30200 - Sales Transaction History

Dynamics GP table SOP30200 (Sales Transaction History) contains 180 columns including SOPTYPE, SOPNUMBE, ORIGTYPE....

SQL Query Builder

180 Columns

Column Description Type Length
SOPTYPE SOP Type1 = Quote2 = Order3 = Invoice4 = Return5 = Back Order6 = Fulfillment Order (In SBF, this value is not available.) Integer 2
SOP Document Type values (6)
1 = Quote2 = Order3 = Invoice4 = Return5 = Back Order6 = Fulfillment Order
SOPNUMBE SOP Number String 22
ORIGTYPE Original Type1 = Quote2 = Order3 = Invoice4 = Return5 = Back Order6 = Fulfillment Order (In SBF, this value is not available.) Integer 2
ORIGNUMB Original Number String 22
DOCID Document ID String 16
DOCDATE Document Date Date 4
GLPOSTDT GL Posting Date Date 4
QUOTEDAT Quote Date Date 4
QUOEXPDA Quote Expiration Date Date 4
ORDRDATE Order Date Date 4
INVODATE Invoice Date Date 4
BACKDATE Back Order Date Date 4
RETUDATE Return Date Date 4
ReqShipDate Requested Ship Date Date 4
FUFILDAT Fulfillment Date Date 4
ACTLSHIP Actual Ship Date Date 4
DISCDATE Discount Date Date 4
DUEDATE Due Date Date 4
REPTING Repeating0 = Non-repeating document1 = Repeating Boolean 2
TRXFREQU TRX Frequency1 = Weekly2 = Biweekly3 = Semimonthly4 = Monthly5 = Bimonthly6 = Quarterly7 = Miscellaneous Integer 2
TIMEREPD Times Repeated Integer 2
TIMETREP Times To Repeat Integer 2
DYSTINCR Days to Increment Integer 2
DTLSTREP Date Last Repeated Date 4
DSTBTCH1 Dest Batch 1 String 16
DSTBTCH2 Dest Batch 2 String 16
USDOCID1 Use Document ID 1 String 16
USDOCID2 Use Document ID 2 String 16
DISCFRGT Discount Available Freight Currency 10
ORDAVFRT Originating Discount Available Freight Currency 10
DISCMISC Discount Available Misc Currency 10
ORDAVMSC Originating Discount Available Misc Currency 10
DISAVAMT Discount Available Amount Currency 10
ORDAVAMT Originating Discount Available Amount Currency 10
DISCRTND Discount Returned Currency 10
ORDISRTD Originating Discount Returned Currency 10
DISTKNAM Discount Taken Amount Currency 10
ORDISTKN Originating Discount Taken Amount Currency 10
DSCPCTAM Discount Percent Amount Integer 2
DSCDLRAM Discount Dollar Amount Currency 10
ORDDLRAT Originating Discount Dollar Amount Currency 10
DISAVTKN Discount Available Taken Currency 10
ORDATKN Originating Discount Available Taken Currency 10
PYMTRMID Payment Terms ID String 22
PRCLEVEL PriceLevel String 12
LOCNCODE Location Code String 12
BCHSOURC Batch Source String 16
BACHNUMB Batch Number String 16
CUSTNMBR Customer Number String 16
CUSTNAME Customer Name String 66
CSTPONBR Customer PO Number String 22
PROSPECT Prospect0 = Existing Customer1 = Prospect Integer 2
MSTRNUMB Master Number Long Integer 4
PCKSLPNO Packing Slip Number String 22
PICTICNU Picking Ticket Number String 22
MRKDNAMT Markdown Amount Currency 10
ORMRKDAM Originating Markdown Amount Currency 10
PRBTADCD Primary Billto Address Code String 16
PRSTADCD Primary Shipto Address Code String 16
CNTCPRSN Contact Person String 62
ShipToName ShipToName String 66
ADDRESS1 Address 1 String 62
ADDRESS2 Address 2 String 62
ADDRESS3 Address 3 String 62
CITY City String 36
STATE State String 30
ZIPCODE Zip Code String 12
CCode Country Code String 8
COUNTRY Country String 62
PHNUMBR1 Phone Number 1 String 22
PHNUMBR2 Phone Number 2 String 22
PHONE3 Phone 3 String 22
FAXNUMBR Fax Number String 22
COMAPPTO Commission Applied To Integer 2
COMMAMNT Commission Amount Currency 10
OCOMMAMT Originating Commission Amount Currency 10
CMMSLAMT Commission Sale Amount Currency 10
ORCOSAMT Originating Commission Sales Amount Currency 10
NCOMAMNT Non-Commissioned Amount Currency 10
ORNCMAMT Originating Non-Commissioned Amount Currency 10
SHIPMTHD Shipping Method String 16
TRDISAMT Trade Discount Amount Currency 10
ORTDISAM Originating Trade Discount Amount Currency 10
TRDISPCT Trade Discount Percent Integer 2
SUBTOTAL Subtotal Currency 10
ORSUBTOT Originating Subtotal Currency 10
REMSUBTO Remaining Subtotal Currency 10
OREMSUBT Originating Remaining Subtotal Currency 10
EXTDCOST Extended Cost Currency 10
OREXTCST Originating Extended Cost Currency 10
FRTAMNT Freight Amount Currency 10
ORFRTAMT Originating Freight Amount Currency 10
MISCAMNT Misc Amount Currency 10
ORMISCAMT Originating Misc Amount Currency 10
TXENGCLD Tax Engine Called Boolean 2
TAXEXMT1 Tax Exempt 1 String 26
TAXEXMT2 Tax Exempt 2 String 26
TXRGNNUM Tax Registration Number String 26
TAXSCHID Tax Schedule ID String 16
TXSCHSRC Tax Schedule Source Integer 2
BSIVCTTL Based On Invoice Total Boolean 2
FRTSCHID Freight Schedule ID String 16
FRTTXAMT Freight Tax Amount Currency 10
ORFRTTAX Originating Freight Tax Amount Currency 10
FRGTTXBL Freight Taxable1 = Taxable2 = Nontaxable3 = Base on customers Integer 2
MSCSCHID Misc Schedule ID String 16
MSCTXAMT Misc Tax Amount Currency 10
ORMSCTAX Originating Misc Tax Amount Currency 10
MISCTXBL Misc Taxable1 = Taxable2 = Nontaxable3 = Base on customers Integer 2
BKTFRTAM Backout Freight Amount Currency 10
ORBKTFRT Originating Backout Freight Amount Currency 10
BKTMSCAM Backout Misc Amount Currency 10
ORBKTMSC Originating Backout Misc Amount Currency 10
BCKTXAMT Backout Tax Amount Currency 10
OBTAXAMT Originating Backout Tax Amount Currency 10
TXBTXAMT Taxable Tax Amount Currency 10
OTAXTAMT Originating Taxable Tax Amount Currency 10
TAXAMNT Tax Amount Currency 10
ORTAXAMT Originating Tax Amount Currency 10
ECTRX EC Transaction Boolean 2
DOCAMNT Document Amount Currency 10
ORDOCAMT Originating Document Amount Currency 10
PYMTRCVD Payment Received Currency 10
ORPMTRVD Originating Payment Received Currency 10
DEPRECVD Deposit Received Currency 10
ORDEPRVD Originating Deposit Received Currency 10
CODAMNT COD Amount Currency 10
ORCODAMT Originating COD Amount Currency 10
ACCTAMNT Account Amount Currency 10
ORACTAMT Originating Account Amount Currency 10
SALSTERR Sales Territory String 16
SLPRSNID Salesperson ID String 16
UPSZONE UPS Zone String 4
TIMESPRT Times Printed Integer 2
PSTGSTUS Posting Status1 = Work2 = Open3 = History4 = Originating Integer 2
Posting Status values (11)
0 = Unposted / New1 = Unposted / Work2 = Posted / Open3 = History / Posted with Error10 = First entry before save20 = Saved and unposted30 = Currently posting40 = Posted50 = Error during posting60 = Edited after save70 = Edited recurring batch
VOIDSTTS Void Status0 = Document has not been voided.1 = Document has been voided.2 = Document has been marked NSF and voided. Integer 2
Void Status values (2)
0 = Normal1 = Voided
ALLOCABY Allocate By Integer 2
NOTEINDX Note Index Currency 10
CURNCYID Currency ID Functional currency code (e.g., USD, CAD, GBP). Use to filter or group multicurrency transactions. String 16
CURRNIDX Currency Index Integer 2
RATETPID Rate Type ID String 16
EXGTBLID Exchange Table ID String 16
XCHGRATE Exchange Rate Currency (Variable) 10
DENXRATE Denomination Exchange Rate Currency (Variable) 10
EXCHDATE Exchange Date Date 4
TIME1 Time Time 4
RTCLCMTD Rate Calculation Method Integer 2
MCTRXSTT MC Transaction State0 = Euro currency is not created or no denomination currencies are enabled.1 = Originating is not a denomination; Functional is not a denomination2 = 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
TRXSORCE TRX Source String 14
SOPHDRE1 SOP HDR Errors 1 Long Integer 4
SOPHDRE2 SOP HDR Errors 2 Long Integer 4
SOPLNERR SOP LINE Errors Long Integer 4
SOPHDRFL SOP HDR Flags Long Integer 4
COMMNTID Comment ID String 16
REFRENCE Reference String 32
POSTEDDT Posted Date Date 4
PTDUSRID Posted User ID String 16
USER2ENT User To Enter String 16
CREATDDT Created Date Date 4
MODIFDT Modified Date Date 4
Tax_Date Tax Date Date 4
APLYWITH Apply Withholding Boolean 2
WITHHAMT Withholding Amount Currency 10
SHPPGDOC Shipping Document Boolean 2
CORRCTN Correction Boolean 2
SIMPLIFD Simplified Boolean 2
DOCNCORR Document Number Corrected String 22
SEQNCORR Sequence Number Corrected Integer 2
SALEDATE Sale Date Date 4
EXCEPTIONALDEMAND Exceptional Demand Boolean 2
Flags Flags Integer 2
SOPSTATUS SOP Status Integer 2
SHIPCOMPLETE Ship Complete Document Boolean 2
DIRECTDEBIT Direct Debit Boolean 2
WorkflowApprStatCreditLm Workflow Approval Status Credit Limit Integer 2
WorkflowPriorityCreditLm Workflow Priority Credit Limit Integer 2
WorkflowApprStatusQuote Workflow Approval Status Quote Integer 2
WorkflowPriorityQuote Workflow Priority Quote Integer 2
ContractExchangeRateStat Contract Exchange Rate Status Integer 2

Related Tables

Tables that share columns with SOP30200. Click "Join" to add to your query.

NOTEINDX

AAG00400 AAG00401 AF40100 AF40103 AF40106 ASIEXP01 ASIEXP02 ASIEXP03

CURNCYID

AAG10001 AAG20001 AAG20011 AAG2001T AAG30001 AAG40001 AAG50001 AAG60001

CURRNIDX

AAG10001 AAG20001 AAG20011 AAG2001T AAG30001 AAG40001 AAG50001 AAG60001

TIME1

AAG10001 AAG20001 AAG20011 AAG2001T AAG30001 AAG40001 ASIEXP06 ASIEXP07

RATETPID

AAG10001 AAG20001 AAG20011 AAG2001T AAG30001 AAG40001 ASIEXP02 ASIEXP03

CUSTNMBR

ASIEXP02 ASIEXP06 ASIEXP07 ASIEXP08 ASIEXP15 ASIEXP19 ASIEXP20 ASIEXP21

TRXSORCE

ASIEXP06 ASIEXP07 ASIEXP08 ASIEXP09 ASIEXP10 ASIEXP12 ASIEXP18 ASIEXP19

XCHGRATE

AAG10001 AAG20001 AAG20011 AAG2001T AAG30001 AAG40001 ASIEXP06 ASIEXP07

DENXRATE

AAG10001 AAG20001 AAG20011 AAG2001T AAG30001 AAG40001 ASIEXP06 ASIEXP07

BACHNUMB

ASIEXP06 ASIEXP08 ASIEXP09 ASIEXP10 ASIEXP12 ASIEXP19 ASIEXP20 ASIEXP25