Sales Transaction History (SOP30200)

azurecurveProductsMicrosoft Dynamics GP (0)SalesSales Transaction History (SOP30200)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SOP30200

Product: Microsoft Dynamics GP (0)
Series: Sales

Display Name: Sales Transaction History
Physical Name: SOP30200
Technical Name: SOP_HDR_HIST

Group Display Name: Sales History
Group Technical Name: Sales History

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1SOPTYPE SearchSOP TypeDDL_SOP_TypeInteger20
2SOPNUMBE SearchSOP NumberSTR20_SOP_NumberString2217
3ORIGTYPE SearchOriginal TypeDDL_SOP_TypeInteger20
4ORIGNUMB SearchOriginal NumberSTR20_SOP_NumberString2217
5DOCID SearchDocument IDSTR15_LBAUString1615
6DOCDATE SearchDocument DateDTDate48
7GLPOSTDT SearchGL Posting DateDTDate48
8QUOTEDAT SearchQuote DateDTDate48
9QUOEXPDA SearchQuote Expiration DateDTDate48
10ORDRDATE SearchOrder DateDTDate48
11INVODATE SearchInvoice DateDTDate48
12BACKDATE SearchBack Order DateDTDate48
13RETUDATE SearchReturn DateDTDate48
14ReqShipDate SearchRequested Ship DateDTDate48
15FUFILDAT SearchFulfillment DateDTDate48
16ACTLSHIP SearchActual Ship DateDTDate48
17DISCDATE SearchDiscount DateDTDate48
18DUEDATE SearchDue DateDTDate48
19REPTING SearchRepeatingCB_RepeatingBoolean20
20TRXFREQU SearchTRX FrequencyDDL_TRX_FrequencyInteger20
21TIMEREPD SearchTimes RepeatedINT4_U0Integer24
22TIMETREP SearchTimes To RepeatINT4_U0Integer24
23DYSTINCR SearchDays to IncrementINT3_RB0_UInteger23
24DTLSTREP SearchDate Last RepeatedDTDate48
25DSTBTCH1 SearchDest Batch 1STR15_LBAUString1615
26DSTBTCH2 SearchDest Batch 2STR15_LBAUString1615
27USDOCID1 SearchUse Document ID 1STR15_LBAUString1615
28USDOCID2 SearchUse Document ID 2STR15_LBAUString1615
29DISCFRGT SearchDiscount Available FreightDLR17_RBS0_UTR$Currency1017
30ORDAVFRT SearchOriginating Discount Available FreightDLR17_RBS0_UTR$Currency1017
31DISCMISC SearchDiscount Available MiscDLR17_RBS0_UTR$Currency1017
32ORDAVMSC SearchOriginating Discount Available MiscDLR17_RBS0_UTR$Currency1017
33DISAVAMT SearchDiscount Available AmountDLR17_RBS0_UTR$Currency1017
34ORDAVAMT SearchOriginating Discount Available AmountDLR17_RBS0_UTR$Currency1017
35DISCRTND SearchDiscount ReturnedDLR17_RBS0_STR$Currency1017
36ORDISRTD SearchOriginating Discount ReturnedDLR17_RBS0_STR$Currency1017
37DISTKNAM SearchDiscount Taken AmountDLR17_RBS0_UTR$Currency1017
38ORDISTKN SearchOriginating Discount Taken AmountDLR17_RBS0_UTR$Currency1017
39DSCPCTAM SearchDiscount Percent AmountINT5_%2Integer25
40DSCDLRAM SearchDiscount Dollar AmountDLR11_RBS0_UTR$Currency1011
41ORDDLRAT SearchOriginating Discount Dollar AmountDLR11_RBS0_UTR$Currency1011
42DISAVTKN SearchDiscount Available TakenDLR17_RBS0_UTR$Currency1017
43ORDATKN SearchOriginating Discount Available TakenDLR17_RBS0_UTR$Currency1017
44PYMTRMID SearchPayment Terms IDSTR20_Payment_Terms_IDString2220
Key to the Payment Terms Master (SY03300).

Click to show/hide

SELECT
       ['Sales Transaction History'].PYMTRMID AS 'Sales Transaction History-Payment Terms ID'
       ,['Payment Terms Master'].PYMTRMID AS 'Payment Terms Master-Payment Terms ID'
FROM
       SOP30200 AS ['Sales Transaction History']
INNER JOIN
       SY03300 AS ['Payment Terms Master']
              ON
                     ['Sales Transaction History'].PYMTRMID = ['Payment Terms Master'].PYMTRMID
45PRCLEVEL SearchPriceLevelSTR10_LBAUString1210
46LOCNCODE SearchLocation CodeSTR10_Location_CodeString1210
Key to the Site Setup (IV40700).

Click to show/hide

SELECT
       ['Sales Transaction History'].LOCNCODE AS 'Sales Transaction History-Location Code'
       ,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
       SOP30200 AS ['Sales Transaction History']
INNER JOIN
       IV40700 AS ['Site Setup']
              ON
                     ['Sales Transaction History'].LOCNCODE = ['Site Setup'].LOCNCODE
47BCHSOURC SearchBatch SourceSTR15String1615
48BACHNUMB SearchBatch NumberSTR15_LBAUString1615
49CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString1615
Key to the RM Customer MSTR (RM00101).

Click to show/hide

SELECT
       ['Sales Transaction History'].CUSTNMBR AS 'Sales Transaction History-Customer Number'
       ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
       SOP30200 AS ['Sales Transaction History']
INNER JOIN
       RM00101 AS ['RM Customer MSTR']
              ON
                     ['Sales Transaction History'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
50CUSTNAME SearchCustomer NameSTR64_Customer_NameString6664
51CSTPONBR SearchCustomer PO NumberSTR20_Document_NumberString2220
52PROSPECT SearchProspectINT1Integer21
53MSTRNUMB SearchMaster NumberLI_MasterNumberLong Integer49
54PCKSLPNO SearchPacking Slip NumberSTR20_IVC_Document_NumberString2217
55PICTICNU SearchPicking Ticket NumberSTR20_SOP_NumberString2217
56MRKDNAMT SearchMarkdown AmountDLR17_RBS0_UTR$Currency1017
57ORMRKDAM SearchOriginating Markdown AmountDLR17_RBS0_UTR$Currency1017
58PRBTADCD SearchPrimary Billto Address CodeSTR15_LBAUString1615
59PRSTADCD SearchPrimary Shipto Address CodeSTR15_LBAUString1615
60CNTCPRSN SearchContact PersonSTR60String6260
61ShipToName SearchShipToNameSTR64_Customer_NameString6664
62ADDRESS1 SearchAddress 1STR60String6260
63ADDRESS2 SearchAddress 2STR60String6260
64ADDRESS3 SearchAddress 3STR60String6260
65CITY SearchCitySTR35String3635
66STATE SearchStateSTR30_StateString3029
67ZIPCODE SearchZip CodeSTR10String1210
68CCode SearchCountry CodeSTR6_VATString86
Key to the VAT Country Code MSTR (VAT10001).

Click to show/hide

SELECT
       ['Sales Transaction History'].CCode AS 'Sales Transaction History-Country Code'
       ,['VAT Country Code MSTR'].CCode AS 'VAT Country Code MSTR-Country Code'
FROM
       SOP30200 AS ['Sales Transaction History']
INNER JOIN
       VAT10001 AS ['VAT Country Code MSTR']
              ON
                     ['Sales Transaction History'].CCode = ['VAT Country Code MSTR'].CCode
69COUNTRY SearchCountrySTR60String6260
70PHNUMBR1 SearchPhone Number 1Phone_NumberString2214
71PHNUMBR2 SearchPhone Number 2Phone_NumberString2214
72PHONE3 SearchPhone 3Phone_Number3String2214
73FAXNUMBR SearchFax NumberSTR14_FAXString2214
74COMAPPTO SearchCommission Applied ToGBInteger20
75COMMAMNT SearchCommission AmountDLR17_RBS0_STR$Currency1017
76OCOMMAMT SearchOriginating Commission AmountDLR17_RBSO_STR$Currency1017
77CMMSLAMT SearchCommission Sale AmountDLR17_RBS0_STR$Currency1017
78ORCOSAMT SearchOriginating Commission Sales AmountDLR17_RBS0_STR$Currency1017
79NCOMAMNT SearchNon-Commissioned AmountDLR19_RBS0_STR$Currency1019
80ORNCMAMT SearchOriginating Non-Commissioned AmountDLR19_RBS0_STR$Currency1019
81SHIPMTHD SearchShipping MethodSTR15_Shipping_MethodString1615
Key to the Shipping Methods Master (SY03000).

Click to show/hide

SELECT
       ['Sales Transaction History'].SHIPMTHD AS 'Sales Transaction History-Shipping Method'
       ,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method'
FROM
       SOP30200 AS ['Sales Transaction History']
INNER JOIN
       SY03000 AS ['Shipping Methods Master']
              ON
                     ['Sales Transaction History'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD
82TRDISAMT SearchTrade Discount AmountDLR17_RBS0_UTR$Currency1017
83ORTDISAM SearchOriginating Trade Discount AmountDLR17_RBS0_UTR$Currency1017
84TRDISPCT SearchTrade Discount PercentINT4_%2Integer24
85SUBTOTAL SearchSubtotalDLR17_RBS0_STR$Currency1017
86ORSUBTOT SearchOriginating SubtotalDLR17_RBS0_STR$Currency1017
87REMSUBTO SearchRemaining SubtotalDLR17_RBS0_UTR$Currency1017
88OREMSUBT SearchOriginating Remaining SubtotalDLR17_RBS0_UTR$Currency1017
89EXTDCOST SearchExtended CostDLR17_RBS0_UTR$Currency1017
90OREXTCST SearchOriginating Extended CostDLR17_RBS0_UTR$Currency1017
91FRTAMNT SearchFreight AmountDLR17_RBS0_UTR$Currency1017
92ORFRTAMT SearchOriginating Freight AmountDLR17_RBS0_UTR$Currency1017
93MISCAMNT SearchMisc AmountDLR17_RBS0_UTR$Currency1017
94ORMISCAMT SearchOriginating Misc AmountDLR19_RBSO_UTR$Currency1019
95TXENGCLD SearchTax Engine CalledYNBoolean20
96TAXEXMT1 SearchTax Exempt 1STR25String2625
97TAXEXMT2 SearchTax Exempt 2STR25String2625
98TXRGNNUM SearchTax Registration NumberSTR25String2625
99TAXSCHID SearchTax Schedule IDSTR15_Tax_Schedule_IDString1615
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['Sales Transaction History'].TAXSCHID AS 'Sales Transaction History-Tax Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       SOP30200 AS ['Sales Transaction History']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['Sales Transaction History'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
100TXSCHSRC SearchTax Schedule SourceINT1Integer21
101BSIVCTTL SearchBased On Invoice TotalYNBoolean20
102FRTSCHID SearchFreight Schedule IDSTR15_LBAUString1615
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['Sales Transaction History'].FRTSCHID AS 'Sales Transaction History-Freight Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       SOP30200 AS ['Sales Transaction History']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['Sales Transaction History'].FRTSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
103FRTTXAMT SearchFreight Tax AmountDLR19_RBSO_UTR$Currency1019
104ORFRTTAX SearchOriginating Freight Tax AmountDLR19_RBSO_UTR$Currency1019
105FRGTTXBL SearchFreight TaxableDDL_Tax_OptionsInteger20
106MSCSCHID SearchMisc Schedule IDSTR15_LBAUString1615
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['Sales Transaction History'].MSCSCHID AS 'Sales Transaction History-Misc Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       SOP30200 AS ['Sales Transaction History']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['Sales Transaction History'].MSCSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
107MSCTXAMT SearchMisc Tax AmountDLR19_RBSO_UTR$Currency1019
108ORMSCTAX SearchOriginating Misc Tax AmountDLR19_RBSO_UTR$Currency1019
109MISCTXBL SearchMisc TaxableDDL_Tax_OptionsInteger20
110BKTFRTAM SearchBackout Freight AmountDLR19_RBS0_UTR$Currency1019
111ORBKTFRT SearchOriginating Backout Freight AmountDLR19_RBS0_UTR$Currency1019
112BKTMSCAM SearchBackout Misc AmountDLR19_RBS0_UTR$Currency1019
113ORBKTMSC SearchOriginating Backout Misc AmountDLR19_RBS0_UTR$Currency1019
114BCKTXAMT SearchBackout Tax AmountDLR17_RBS0_UTR$Currency1017
115OBTAXAMT SearchOriginating Backout Tax AmountDLR17_RBS0_UTR$Currency1017
116TXBTXAMT SearchTaxable Tax AmountDLR19_RBSO_UTR$Currency1019
117OTAXTAMT SearchOriginating Taxable Tax AmountDLR17_RBS0_UTR$Currency1017
118TAXAMNT SearchTax AmountDLR17_RBS0_UTR$Currency1017
119ORTAXAMT SearchOriginating Tax AmountDLR17_RBS0_UTR$Currency1017
120ECTRX SearchEC TransactionCB_EC_TransactionBoolean20
The field is set to true for each VAT Line Analysis record, if the user marks the transaction as being an EC Transaction.

Click to show/hide Document Printed flag


0	Not an EU Transaction.
1	EU Transaction.
121DOCAMNT SearchDocument AmountDLR19_RBSO_UTR$Currency1019
122ORDOCAMT SearchOriginating Document AmountDLR17_RBS0_STR$Currency1017
123PYMTRCVD SearchPayment ReceivedDLR19_RBS0_UTR$Currency1019
124ORPMTRVD SearchOriginating Payment ReceivedDLR19_RBS0_UTR$Currency1019
125DEPRECVD SearchDeposit ReceivedDLR19_RBS0_UTR$Currency1019
126ORDEPRVD SearchOriginating Deposit ReceivedDLR19_RBS0_UTR$Currency1019
127CODAMNT SearchCOD AmountDLR17_RBS0_UTR$Currency1017
128ORCODAMT SearchOriginating COD AmountDLR17_RBS0_UTR$Currency1017
129ACCTAMNT SearchAccount AmountDLR19_RBS0_UTR$Currency1019
130ORACTAMT SearchOriginating Account AmountDLR19_RBS0_UTR$Currency1019
131SALSTERR SearchSales TerritorySTR15_Sales_TerritoryString1615
Key to the Sales Territory Master File (RM00303).

Click to show/hide

SELECT
       ['Sales Transaction History'].SALSTERR AS 'Sales Transaction History-Sales Territory'
       ,['Sales Territory Master File'].SALSTERR AS 'Sales Territory Master File-Sales Territory'
FROM
       SOP30200 AS ['Sales Transaction History']
INNER JOIN
       RM00303 AS ['Sales Territory Master File']
              ON
                     ['Sales Transaction History'].SALSTERR = ['Sales Territory Master File'].SALSTERR
132SLPRSNID SearchSalesperson IDSTR15_Salesperson_IDString1615
Key to the RM Salesperson Master (RM00301).

Click to show/hide

SELECT
       ['Sales Transaction History'].SLPRSNID AS 'Sales Transaction History-Salesperson ID'
       ,['RM Salesperson Master'].SLPRSNID AS 'RM Salesperson Master-Salesperson ID'
FROM
       SOP30200 AS ['Sales Transaction History']
INNER JOIN
       RM00301 AS ['RM Salesperson Master']
              ON
                     ['Sales Transaction History'].SLPRSNID = ['RM Salesperson Master'].SLPRSNID
133UPSZONE SearchUPS ZoneSTR3String43
134TIMESPRT SearchTimes PrintedINT4_U0Integer24
135PSTGSTUS SearchPosting StatusINTInteger20
136VOIDSTTS SearchVoid StatusINTInteger20
137ALLOCABY SearchAllocate ByDDL_Allocate_ByInteger20
138NOTEINDX SearchNote IndexDLR14Currency1014
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['Sales Transaction History'].NOTEINDX AS 'Sales Transaction History-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       SOP30200 AS ['Sales Transaction History']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['Sales Transaction History'].NOTEINDX = ['Record Notes Master'].NOTEINDX
139CURNCYID SearchCurrency IDSTR15_Currency_IDString1615
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['Sales Transaction History'].CURNCYID AS 'Sales Transaction History-Currency ID'
       ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
       SOP30200 AS ['Sales Transaction History']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['Sales Transaction History'].CURNCYID = ['Currency Setup'].CURNCYID
140CURRNIDX SearchCurrency IndexINT3Integer23
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['Sales Transaction History'].CURRNIDX AS 'Sales Transaction History-Currency Index'
       ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
       SOP30200 AS ['Sales Transaction History']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['Sales Transaction History'].CURRNIDX = ['Currency Setup'].CURRNIDX
141RATETPID SearchRate Type IDSTR15_Rate_Type_IDString1615
Key to the Multicurrency Rate Type Setup (MC40100).

Click to show/hide

SELECT
       ['Sales Transaction History'].RATETPID AS 'Sales Transaction History-Rate Type ID'
       ,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
       SOP30200 AS ['Sales Transaction History']
INNER JOIN
       MC40100 AS ['Multicurrency Rate Type Setup']
              ON
                     ['Sales Transaction History'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID
142EXGTBLID SearchExchange Table IDSTR15_Exchange_Table_IDString1615
Key to the Multicurrency Exchange Rate Maintenance (MC00100).

Click to show/hide

SELECT
       ['Sales Transaction History'].EXGTBLID AS 'Sales Transaction History-Exchange Table ID'
       ,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID'
FROM
       SOP30200 AS ['Sales Transaction History']
INNER JOIN
       DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance']
              ON
                     ['Sales Transaction History'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID
143XCHGRATE SearchExchange RateDLR14_Exchange_RateCurrency (Variable)1014
144DENXRATE SearchDenomination Exchange RateDLR14_Exchange_RateCurrency (Variable)1014
145EXCHDATE SearchExchange DateDT_DateDate46
146TIME1 SearchTimeTM6Time46
147RTCLCMTD SearchRate Calculation MethodGBInteger20
148MCTRXSTT SearchMC Transaction StateINT1Integer21
MC Transaction State of the transaction. State the transaction was created in. For non multi-currency transactions, this field will be blank.

Click to show/hide MC Transaction States

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.
149TRXSORCE SearchTRX SourceSTR13String1413
150SOPHDRE1 SearchSOP HDR Errors 1ML_SOP_HDR_Errors_1Long Integer40
151SOPHDRE2 SearchSOP HDR Errors 2ML_SOP_HDR_Errors_2Long Integer40
152SOPLNERR SearchSOP LINE ErrorsML_SOP_LINE_ErrorsLong Integer40
153SOPHDRFL SearchSOP HDR FlagsML_SOP_HDR_FlagsLong Integer40
154COMMNTID SearchComment IDSTR15_Comment_IDString1615
Key to the Comment Master (SY04200).

Click to show/hide

SELECT
       ['Sales Transaction History'].COMMNTID AS 'Sales Transaction History-Comment ID'
       ,['Comment Master'].COMMNTID AS 'Comment Master-Comment ID'
FROM
       SOP30200 AS ['Sales Transaction History']
INNER JOIN
       SY04200 AS ['Comment Master']
              ON
                     ['Sales Transaction History'].COMMNTID = ['Comment Master'].COMMNTID
155REFRENCE SearchReferenceSTR30String3230
156POSTEDDT SearchPosted DateDATEDate46
157PTDUSRID SearchPosted User IDSTR15String1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['Sales Transaction History'].PTDUSRID AS 'Sales Transaction History-Posted User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       SOP30200 AS ['Sales Transaction History']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['Sales Transaction History'].PTDUSRID = ['Users Master'].USERID
158USER2ENT SearchUser To EnterSTR15_User_IDString1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['Sales Transaction History'].USER2ENT AS 'Sales Transaction History-User To Enter'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       SOP30200 AS ['Sales Transaction History']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['Sales Transaction History'].USER2ENT = ['Users Master'].USERID
159CREATDDT SearchCreated DateDTDate48
160MODIFDT SearchModified DateDTDate48
161Tax_Date SearchTax DateDTDate48
162APLYWITH SearchApply WithholdingBooleanBoolean20
163WITHHAMT SearchWithholding AmountDLR19_RBSO_UTR$Currency1019
164SHPPGDOC SearchShipping DocumentCB_Shipping_DocumentBoolean20
165CORRCTN SearchCorrectionCB_CorrectionBoolean20
166SIMPLIFD SearchSimplifiedCB_SimplifiedBoolean20
167DOCNCORR SearchDocument Number CorrectedDocument_NumberString2220
168SEQNCORR SearchSequence Number CorrectedINTInteger20
169SALEDATE SearchSale DateDTDate48
170EXCEPTIONALDEMAND SearchExceptional DemandCB_Exceptional_DemandBoolean20
171Flags SearchFlagsINT1Integer21
172SOPSTATUS SearchSOP StatusINTInteger20
173SHIPCOMPLETE SearchShip Complete DocumentCB_ShipCompleteBoolean20
174DIRECTDEBIT SearchDirect DebitCB_DirectDebitBoolean20
175WorkflowApprStatCreditLm SearchWorkflow Approval Status Credit LimitDDL_WorkflowApprovalStatusInteger20
176WorkflowPriorityCreditLm SearchWorkflow Priority Credit LimitDDL_WorkflowPriorityInteger20
177WorkflowApprStatusQuote SearchWorkflow Approval Status QuoteDDL_WorkflowApprovalStatusInteger20
178WorkflowPriorityQuote SearchWorkflow Priority QuoteDDL_WorkflowPriorityInteger20
179Workflow_Status SearchWorkflow StatusWorkflow StatusInteger20
180ContractExchangeRateStat SearchContract Exchange Rate StatusINTInteger20
181Print_Phone_NumberGB SearchPrint Phone Number GBGBInteger20
182DEX_ROW_TS Searchdatetimedatetime33
DEX_ROW_TS records the time the record was last changed; often used with integration tools to identify which records have changed and need to be synchronised.
183DEX_ROW_ID Searchintint1010

DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information.

Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.

azurecurveProductsMicrosoft Dynamics GP (0)SalesSales Transaction History (SOP30200)

Leave a Reply

Your email address will not be published. Required fields are marked *