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 TypeLength
1SOPTYPE SearchSOP TypeDDL_SOP_TypeInteger0
2SOPNUMBE SearchSOP NumberSTR20_SOP_NumberString17
3ORIGTYPE SearchOriginal TypeDDL_SOP_TypeInteger0
4ORIGNUMB SearchOriginal NumberSTR20_SOP_NumberString17
5DOCID SearchDocument IDSTR15_LBAUString15
6DOCDATE SearchDocument DateDTDate8
7GLPOSTDT SearchGL Posting DateDTDate8
8QUOTEDAT SearchQuote DateDTDate8
9QUOEXPDA SearchQuote Expiration DateDTDate8
10ORDRDATE SearchOrder DateDTDate8
11INVODATE SearchInvoice DateDTDate8
12BACKDATE SearchBack Order DateDTDate8
13RETUDATE SearchReturn DateDTDate8
14ReqShipDate SearchRequested Ship DateDTDate8
15FUFILDAT SearchFulfillment DateDTDate8
16ACTLSHIP SearchActual Ship DateDTDate8
17DISCDATE SearchDiscount DateDTDate8
18DUEDATE SearchDue DateDTDate8
19REPTING SearchRepeatingCB_RepeatingBoolean0
20TRXFREQU SearchTRX FrequencyDDL_TRX_FrequencyInteger0
21TIMEREPD SearchTimes RepeatedINT4_U0Integer4
22TIMETREP SearchTimes To RepeatINT4_U0Integer4
23DYSTINCR SearchDays to IncrementINT3_RB0_UInteger3
24DTLSTREP SearchDate Last RepeatedDTDate8
25DSTBTCH1 SearchDest Batch 1STR15_LBAUString15
26DSTBTCH2 SearchDest Batch 2STR15_LBAUString15
27USDOCID1 SearchUse Document ID 1STR15_LBAUString15
28USDOCID2 SearchUse Document ID 2STR15_LBAUString15
29DISCFRGT SearchDiscount Available FreightDLR17_RBS0_UTR$Currency17
30ORDAVFRT SearchOriginating Discount Available FreightDLR17_RBS0_UTR$Currency17
31DISCMISC SearchDiscount Available MiscDLR17_RBS0_UTR$Currency17
32ORDAVMSC SearchOriginating Discount Available MiscDLR17_RBS0_UTR$Currency17
33DISAVAMT SearchDiscount Available AmountDLR17_RBS0_UTR$Currency17
34ORDAVAMT SearchOriginating Discount Available AmountDLR17_RBS0_UTR$Currency17
35DISCRTND SearchDiscount ReturnedDLR17_RBS0_STR$Currency17
36ORDISRTD SearchOriginating Discount ReturnedDLR17_RBS0_STR$Currency17
37DISTKNAM SearchDiscount Taken AmountDLR17_RBS0_UTR$Currency17
38ORDISTKN SearchOriginating Discount Taken AmountDLR17_RBS0_UTR$Currency17
39DSCPCTAM SearchDiscount Percent AmountINT5_%2Integer5
40DSCDLRAM SearchDiscount Dollar AmountDLR11_RBS0_UTR$Currency11
41ORDDLRAT SearchOriginating Discount Dollar AmountDLR11_RBS0_UTR$Currency11
42DISAVTKN SearchDiscount Available TakenDLR17_RBS0_UTR$Currency17
43ORDATKN SearchOriginating Discount Available TakenDLR17_RBS0_UTR$Currency17
44PYMTRMID SearchPayment Terms IDSTR20_Payment_Terms_IDString20
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_LBAUString10
46LOCNCODE SearchLocation CodeSTR10_Location_CodeString10
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 SourceSTR15String15
48BACHNUMB SearchBatch NumberSTR15_LBAUString15
49CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString15
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_NameString64
51CSTPONBR SearchCustomer PO NumberSTR20_Document_NumberString20
52PROSPECT SearchProspectINT1Integer1
53MSTRNUMB SearchMaster NumberLI_MasterNumberLong Integer9
54PCKSLPNO SearchPacking Slip NumberSTR20_IVC_Document_NumberString17
55PICTICNU SearchPicking Ticket NumberSTR20_SOP_NumberString17
56MRKDNAMT SearchMarkdown AmountDLR17_RBS0_UTR$Currency17
57ORMRKDAM SearchOriginating Markdown AmountDLR17_RBS0_UTR$Currency17
58PRBTADCD SearchPrimary Billto Address CodeSTR15_LBAUString15
59PRSTADCD SearchPrimary Shipto Address CodeSTR15_LBAUString15
60CNTCPRSN SearchContact PersonSTR60String60
61ShipToName SearchShipToNameSTR64_Customer_NameString64
62ADDRESS1 SearchAddress 1STR60String60
63ADDRESS2 SearchAddress 2STR60String60
64ADDRESS3 SearchAddress 3STR60String60
65CITY SearchCitySTR35String35
66STATE SearchStateSTR30_StateString29
67ZIPCODE SearchZip CodeSTR10String10
68CCode SearchCountry CodeSTR6_VATString6
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 SearchCountrySTR60String60
70PHNUMBR1 SearchPhone Number 1Phone_NumberString14
71PHNUMBR2 SearchPhone Number 2Phone_NumberString14
72PHONE3 SearchPhone 3Phone_Number3String14
73FAXNUMBR SearchFax NumberSTR14_FAXString14
74COMAPPTO SearchCommission Applied ToGBInteger0
75COMMAMNT SearchCommission AmountDLR17_RBS0_STR$Currency17
76OCOMMAMT SearchOriginating Commission AmountDLR17_RBSO_STR$Currency17
77CMMSLAMT SearchCommission Sale AmountDLR17_RBS0_STR$Currency17
78ORCOSAMT SearchOriginating Commission Sales AmountDLR17_RBS0_STR$Currency17
79NCOMAMNT SearchNon-Commissioned AmountDLR19_RBS0_STR$Currency19
80ORNCMAMT SearchOriginating Non-Commissioned AmountDLR19_RBS0_STR$Currency19
81SHIPMTHD SearchShipping MethodSTR15_Shipping_MethodString15
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$Currency17
83ORTDISAM SearchOriginating Trade Discount AmountDLR17_RBS0_UTR$Currency17
84TRDISPCT SearchTrade Discount PercentINT4_%2Integer4
85SUBTOTAL SearchSubtotalDLR17_RBS0_STR$Currency17
86ORSUBTOT SearchOriginating SubtotalDLR17_RBS0_STR$Currency17
87REMSUBTO SearchRemaining SubtotalDLR17_RBS0_UTR$Currency17
88OREMSUBT SearchOriginating Remaining SubtotalDLR17_RBS0_UTR$Currency17
89EXTDCOST SearchExtended CostDLR17_RBS0_UTR$Currency17
90OREXTCST SearchOriginating Extended CostDLR17_RBS0_UTR$Currency17
91FRTAMNT SearchFreight AmountDLR17_RBS0_UTR$Currency17
92ORFRTAMT SearchOriginating Freight AmountDLR17_RBS0_UTR$Currency17
93MISCAMNT SearchMisc AmountDLR17_RBS0_UTR$Currency17
94ORMISCAMT SearchOriginating Misc AmountDLR19_RBSO_UTR$Currency19
95TXENGCLD SearchTax Engine CalledYNBoolean0
96TAXEXMT1 SearchTax Exempt 1STR25String25
97TAXEXMT2 SearchTax Exempt 2STR25String25
98TXRGNNUM SearchTax Registration NumberSTR25String25
99TAXSCHID SearchTax Schedule IDSTR15_Tax_Schedule_IDString15
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 SourceINT1Integer1
101BSIVCTTL SearchBased On Invoice TotalYNBoolean0
102FRTSCHID SearchFreight Schedule IDSTR15_LBAUString15
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$Currency19
104ORFRTTAX SearchOriginating Freight Tax AmountDLR19_RBSO_UTR$Currency19
105FRGTTXBL SearchFreight TaxableDDL_Tax_OptionsInteger0
106MSCSCHID SearchMisc Schedule IDSTR15_LBAUString15
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$Currency19
108ORMSCTAX SearchOriginating Misc Tax AmountDLR19_RBSO_UTR$Currency19
109MISCTXBL SearchMisc TaxableDDL_Tax_OptionsInteger0
110BKTFRTAM SearchBackout Freight AmountDLR19_RBS0_UTR$Currency19
111ORBKTFRT SearchOriginating Backout Freight AmountDLR19_RBS0_UTR$Currency19
112BKTMSCAM SearchBackout Misc AmountDLR19_RBS0_UTR$Currency19
113ORBKTMSC SearchOriginating Backout Misc AmountDLR19_RBS0_UTR$Currency19
114BCKTXAMT SearchBackout Tax AmountDLR17_RBS0_UTR$Currency17
115OBTAXAMT SearchOriginating Backout Tax AmountDLR17_RBS0_UTR$Currency17
116TXBTXAMT SearchTaxable Tax AmountDLR19_RBSO_UTR$Currency19
117OTAXTAMT SearchOriginating Taxable Tax AmountDLR17_RBS0_UTR$Currency17
118TAXAMNT SearchTax AmountDLR17_RBS0_UTR$Currency17
119ORTAXAMT SearchOriginating Tax AmountDLR17_RBS0_UTR$Currency17
120ECTRX SearchEC TransactionCB_EC_TransactionBoolean0
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$Currency19
122ORDOCAMT SearchOriginating Document AmountDLR17_RBS0_STR$Currency17
123PYMTRCVD SearchPayment ReceivedDLR19_RBS0_UTR$Currency19
124ORPMTRVD SearchOriginating Payment ReceivedDLR19_RBS0_UTR$Currency19
125DEPRECVD SearchDeposit ReceivedDLR19_RBS0_UTR$Currency19
126ORDEPRVD SearchOriginating Deposit ReceivedDLR19_RBS0_UTR$Currency19
127CODAMNT SearchCOD AmountDLR17_RBS0_UTR$Currency17
128ORCODAMT SearchOriginating COD AmountDLR17_RBS0_UTR$Currency17
129ACCTAMNT SearchAccount AmountDLR19_RBS0_UTR$Currency19
130ORACTAMT SearchOriginating Account AmountDLR19_RBS0_UTR$Currency19
131SALSTERR SearchSales TerritorySTR15_Sales_TerritoryString15
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_IDString15
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 ZoneSTR3String3
134TIMESPRT SearchTimes PrintedINT4_U0Integer4
135PSTGSTUS SearchPosting StatusINTInteger0
136VOIDSTTS SearchVoid StatusINTInteger0
137ALLOCABY SearchAllocate ByDDL_Allocate_ByInteger0
138NOTEINDX SearchNote IndexDLR14Currency14
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_IDString15
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 IndexINT3Integer3
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_IDString15
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_IDString15
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)14
144DENXRATE SearchDenomination Exchange RateDLR14_Exchange_RateCurrency (Variable)14
145EXCHDATE SearchExchange DateDT_DateDate6
146TIME1 SearchTimeTM6Time6
147RTCLCMTD SearchRate Calculation MethodGBInteger0
148MCTRXSTT SearchMC Transaction StateINT1Integer1
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 SourceSTR13String13
150SOPHDRE1 SearchSOP HDR Errors 1ML_SOP_HDR_Errors_1Long Integer0
151SOPHDRE2 SearchSOP HDR Errors 2ML_SOP_HDR_Errors_2Long Integer0
152SOPLNERR SearchSOP LINE ErrorsML_SOP_LINE_ErrorsLong Integer0
153SOPHDRFL SearchSOP HDR FlagsML_SOP_HDR_FlagsLong Integer0
154COMMNTID SearchComment IDSTR15_Comment_IDString15
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 SearchReferenceSTR30String30
156POSTEDDT SearchPosted DateDATEDate6
157PTDUSRID SearchPosted User IDSTR15String15
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_IDString15
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 DateDTDate8
160MODIFDT SearchModified DateDTDate8
161Tax_Date SearchTax DateDTDate8
162APLYWITH SearchApply WithholdingBooleanBoolean0
163WITHHAMT SearchWithholding AmountDLR19_RBSO_UTR$Currency19
164SHPPGDOC SearchShipping DocumentCB_Shipping_DocumentBoolean0
165CORRCTN SearchCorrectionCB_CorrectionBoolean0
166SIMPLIFD SearchSimplifiedCB_SimplifiedBoolean0
167DOCNCORR SearchDocument Number CorrectedDocument_NumberString20
168SEQNCORR SearchSequence Number CorrectedINTInteger0
169SALEDATE SearchSale DateDTDate8
170EXCEPTIONALDEMAND SearchExceptional DemandCB_Exceptional_DemandBoolean0
171Flags SearchFlagsINT1Integer1
172SOPSTATUS SearchSOP StatusINTInteger0
173SHIPCOMPLETE SearchShip Complete DocumentCB_ShipCompleteBoolean0
174DIRECTDEBIT SearchDirect DebitCB_DirectDebitBoolean0
175WorkflowApprStatCreditLm SearchWorkflow Approval Status Credit LimitDDL_WorkflowApprovalStatusInteger0
176WorkflowPriorityCreditLm SearchWorkflow Priority Credit LimitDDL_WorkflowPriorityInteger0
177WorkflowApprStatusQuote SearchWorkflow Approval Status QuoteDDL_WorkflowApprovalStatusInteger0
178WorkflowPriorityQuote SearchWorkflow Priority QuoteDDL_WorkflowPriorityInteger0
179Workflow_Status SearchWorkflow StatusWorkflow StatusInteger0
180ContractExchangeRateStat SearchContract Exchange Rate StatusINTInteger0
181Print_Phone_NumberGB SearchPrint Phone Number GBGBInteger0
182DEX_ROW_TS Searchdatetimedatetime3
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 Searchintint10

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 *