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 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 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_LBAUString1210
46LOCNCODE SearchLocation CodeSTR10_Location_CodeString1210
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 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 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_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 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 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 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$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 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 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 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$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 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$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 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_IDString1615
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 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 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_IDString1615
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 IndexINT3Integer23
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_IDString1615
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_IDString1615
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)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
154SOPMCERR SearchSOP MC Posting Error MessagesSOP MC Posting Error MessagesLong Integer40
155COMMNTID SearchComment IDSTR15_Comment_IDString1615
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 SearchReferenceSTR30String3230
157POSTEDDT SearchPosted DateDATEDate46
158PTDUSRID SearchPosted User IDSTR15String1615
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_IDString1615
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 DateDTDate48
161MODIFDT SearchModified DateDTDate48
162Tax_Date SearchTax DateDTDate48
163APLYWITH SearchApply WithholdingBooleanBoolean20
164WITHHAMT SearchWithholding AmountDLR19_RBSO_UTR$Currency1019
165SHPPGDOC SearchShipping DocumentCB_Shipping_DocumentBoolean20
166CORRCTN SearchCorrectionCB_CorrectionBoolean20
167SIMPLIFD SearchSimplifiedCB_SimplifiedBoolean20
168CORRNXST SearchCorrection to Nonexisting TransactionBooleanBoolean20
169DOCNCORR SearchDocument Number CorrectedDocument_NumberString2220
170SEQNCORR SearchSequence Number CorrectedINTInteger20
171SALEDATE SearchSale DateDTDate48
172SOPHDRE3 SearchSOP HDR Errors 3ML_SOP_HDR_Errors_3Long Integer40
173EXCEPTIONALDEMAND SearchExceptional DemandCB_Exceptional_DemandBoolean20
174Flags SearchFlagsINT1Integer21
175BackoutTradeDisc SearchBackout Trade Discount AmountDLR19_RBS0_UTR$Currency1019
176OrigBackoutTradeDisc SearchOriginating Backout Trade Discount AmountDLR19_RBS0_UTR$Currency1019
177GPSFOINTEGRATIONID SearchGPSFO Integration IDSTR30String3230
178INTEGRATIONSOURCE SearchIntegration SourceINTInteger20
179INTEGRATIONID SearchIntegration IDSTR30String3230
180SOPSTATUS SearchSOP StatusINTInteger20
181SHIPCOMPLETE SearchShip Complete DocumentCB_ShipCompleteBoolean20
182DIRECTDEBIT SearchDirect DebitCB_DirectDebitBoolean20
183WorkflowApprStatCreditLm SearchWorkflow Approval Status Credit LimitDDL_WorkflowApprovalStatusInteger20
184WorkflowPriorityCreditLm SearchWorkflow Priority Credit LimitDDL_WorkflowPriorityInteger20
185WorkflowApprStatusQuote SearchWorkflow Approval Status QuoteDDL_WorkflowApprovalStatusInteger20
186WorkflowPriorityQuote SearchWorkflow Priority QuoteDDL_WorkflowPriorityInteger20
187Workflow_Status SearchWorkflow StatusWorkflow StatusInteger20
188ContractExchangeRateStat SearchContract Exchange Rate StatusINTInteger20
189Print_Phone_NumberGB SearchPrint Phone Number GBGBInteger20
190DEX_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.
191DEX_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 Work (SOP10100)

Leave a Reply

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