Sales Transaction Work (SOP10100)

azurecurveProductsMicrosoft Dynamics GP (0)SalesSales Transaction Work (SOP10100)

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

Product: Microsoft Dynamics GP (0)
Series: Sales

Display Name: Sales Transaction Work
Physical Name: SOP10100
Technical Name: SOP_HDR_WORK

Group Display Name: Sales Work
Group Technical Name: Sales Work

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 Work'].PYMTRMID AS 'Sales Transaction Work-Payment Terms ID'
       ,['Payment Terms Master'].PYMTRMID AS 'Payment Terms Master-Payment Terms ID'
FROM
       SOP10100 AS ['Sales Transaction Work']
INNER JOIN
       SY03300 AS ['Payment Terms Master']
              ON
                     ['Sales Transaction Work'].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 Work'].LOCNCODE AS 'Sales Transaction Work-Location Code'
       ,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
       SOP10100 AS ['Sales Transaction Work']
INNER JOIN
       IV40700 AS ['Site Setup']
              ON
                     ['Sales Transaction Work'].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 Work'].CUSTNMBR AS 'Sales Transaction Work-Customer Number'
       ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
       SOP10100 AS ['Sales Transaction Work']
INNER JOIN
       RM00101 AS ['RM Customer MSTR']
              ON
                     ['Sales Transaction Work'].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 Work'].CCode AS 'Sales Transaction Work-Country Code'
       ,['VAT Country Code MSTR'].CCode AS 'VAT Country Code MSTR-Country Code'
FROM
       SOP10100 AS ['Sales Transaction Work']
INNER JOIN
       VAT10001 AS ['VAT Country Code MSTR']
              ON
                     ['Sales Transaction Work'].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 Work'].SHIPMTHD AS 'Sales Transaction Work-Shipping Method'
       ,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method'
FROM
       SOP10100 AS ['Sales Transaction Work']
INNER JOIN
       SY03000 AS ['Shipping Methods Master']
              ON
                     ['Sales Transaction Work'].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 Work'].TAXSCHID AS 'Sales Transaction Work-Tax Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       SOP10100 AS ['Sales Transaction Work']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['Sales Transaction Work'].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 Work'].FRTSCHID AS 'Sales Transaction Work-Freight Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       SOP10100 AS ['Sales Transaction Work']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['Sales Transaction Work'].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 Work'].MSCSCHID AS 'Sales Transaction Work-Misc Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       SOP10100 AS ['Sales Transaction Work']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['Sales Transaction Work'].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 Work'].SALSTERR AS 'Sales Transaction Work-Sales Territory'
       ,['Sales Territory Master File'].SALSTERR AS 'Sales Territory Master File-Sales Territory'
FROM
       SOP10100 AS ['Sales Transaction Work']
INNER JOIN
       RM00303 AS ['Sales Territory Master File']
              ON
                     ['Sales Transaction Work'].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 Work'].SLPRSNID AS 'Sales Transaction Work-Salesperson ID'
       ,['RM Salesperson Master'].SLPRSNID AS 'RM Salesperson Master-Salesperson ID'
FROM
       SOP10100 AS ['Sales Transaction Work']
INNER JOIN
       RM00301 AS ['RM Salesperson Master']
              ON
                     ['Sales Transaction Work'].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 Work'].NOTEINDX AS 'Sales Transaction Work-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       SOP10100 AS ['Sales Transaction Work']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['Sales Transaction Work'].NOTEINDX = ['Record Notes Master'].NOTEINDX
139CURNCYID SearchCurrency IDSTR15_Currency_IDString15
Key to the Currency Setup (MC40200).

Click to show/hide

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

Click to show/hide

SELECT
       ['Sales Transaction Work'].CURRNIDX AS 'Sales Transaction Work-Currency Index'
       ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
       SOP10100 AS ['Sales Transaction Work']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['Sales Transaction Work'].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 Work'].RATETPID AS 'Sales Transaction Work-Rate Type ID'
       ,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
       SOP10100 AS ['Sales Transaction Work']
INNER JOIN
       MC40100 AS ['Multicurrency Rate Type Setup']
              ON
                     ['Sales Transaction Work'].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 Work'].EXGTBLID AS 'Sales Transaction Work-Exchange Table ID'
       ,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID'
FROM
       SOP10100 AS ['Sales Transaction Work']
INNER JOIN
       DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance']
              ON
                     ['Sales Transaction Work'].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
154SOPMCERR SearchSOP MC Posting Error MessagesSOP MC Posting Error MessagesLong Integer0
155COMMNTID SearchComment IDSTR15_Comment_IDString15
Key to the Comment Master (SY04200).

Click to show/hide

SELECT
       ['Sales Transaction Work'].COMMNTID AS 'Sales Transaction Work-Comment ID'
       ,['Comment Master'].COMMNTID AS 'Comment Master-Comment ID'
FROM
       SOP10100 AS ['Sales Transaction Work']
INNER JOIN
       SY04200 AS ['Comment Master']
              ON
                     ['Sales Transaction Work'].COMMNTID = ['Comment Master'].COMMNTID
156REFRENCE SearchReferenceSTR30String30
157POSTEDDT SearchPosted DateDATEDate6
158PTDUSRID SearchPosted User IDSTR15String15
Key to the Users Master (SY01400).

Click to show/hide

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

Click to show/hide

SELECT
       ['Sales Transaction Work'].USER2ENT AS 'Sales Transaction Work-User To Enter'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       SOP10100 AS ['Sales Transaction Work']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['Sales Transaction Work'].USER2ENT = ['Users Master'].USERID
160CREATDDT SearchCreated DateDTDate8
161MODIFDT SearchModified DateDTDate8
162Tax_Date SearchTax DateDTDate8
163APLYWITH SearchApply WithholdingBooleanBoolean0
164WITHHAMT SearchWithholding AmountDLR19_RBSO_UTR$Currency19
165SHPPGDOC SearchShipping DocumentCB_Shipping_DocumentBoolean0
166CORRCTN SearchCorrectionCB_CorrectionBoolean0
167SIMPLIFD SearchSimplifiedCB_SimplifiedBoolean0
168CORRNXST SearchCorrection to Nonexisting TransactionBooleanBoolean0
169DOCNCORR SearchDocument Number CorrectedDocument_NumberString20
170SEQNCORR SearchSequence Number CorrectedINTInteger0
171SALEDATE SearchSale DateDTDate8
172SOPHDRE3 SearchSOP HDR Errors 3ML_SOP_HDR_Errors_3Long Integer0
173EXCEPTIONALDEMAND SearchExceptional DemandCB_Exceptional_DemandBoolean0
174Flags SearchFlagsINT1Integer1
175BackoutTradeDisc SearchBackout Trade Discount AmountDLR19_RBS0_UTR$Currency19
176OrigBackoutTradeDisc SearchOriginating Backout Trade Discount AmountDLR19_RBS0_UTR$Currency19
177GPSFOINTEGRATIONID SearchGPSFO Integration IDSTR30String30
178INTEGRATIONSOURCE SearchIntegration SourceINTInteger0
179INTEGRATIONID SearchIntegration IDSTR30String30
180SOPSTATUS SearchSOP StatusINTInteger0
181SHIPCOMPLETE SearchShip Complete DocumentCB_ShipCompleteBoolean0
182DIRECTDEBIT SearchDirect DebitCB_DirectDebitBoolean0
183WorkflowApprStatCreditLm SearchWorkflow Approval Status Credit LimitDDL_WorkflowApprovalStatusInteger0
184WorkflowPriorityCreditLm SearchWorkflow Priority Credit LimitDDL_WorkflowPriorityInteger0
185WorkflowApprStatusQuote SearchWorkflow Approval Status QuoteDDL_WorkflowApprovalStatusInteger0
186WorkflowPriorityQuote SearchWorkflow Priority QuoteDDL_WorkflowPriorityInteger0
187Workflow_Status SearchWorkflow StatusWorkflow StatusInteger0
188ContractExchangeRateStat SearchContract Exchange Rate StatusINTInteger0
189Print_Phone_NumberGB SearchPrint Phone Number GBGBInteger0
190DEX_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.
191DEX_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 Work (SOP10100)

Leave a Reply

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