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 TypeIntegerDDL_SOP_Type0
2SOPNUMBE SearchSOP NumberStringSTR20_SOP_Number17
3ORIGTYPE SearchOriginal TypeIntegerDDL_SOP_Type0
4ORIGNUMB SearchOriginal NumberStringSTR20_SOP_Number17
5DOCID SearchDocument IDStringSTR15_LBAU15
6DOCDATE SearchDocument DateDateDT8
7GLPOSTDT SearchGL Posting DateDateDT8
8QUOTEDAT SearchQuote DateDateDT8
9QUOEXPDA SearchQuote Expiration DateDateDT8
10ORDRDATE SearchOrder DateDateDT8
11INVODATE SearchInvoice DateDateDT8
12BACKDATE SearchBack Order DateDateDT8
13RETUDATE SearchReturn DateDateDT8
14ReqShipDate SearchRequested Ship DateDateDT8
15FUFILDAT SearchFulfillment DateDateDT8
16ACTLSHIP SearchActual Ship DateDateDT8
17DISCDATE SearchDiscount DateDateDT8
18DUEDATE SearchDue DateDateDT8
19REPTING SearchRepeatingBooleanCB_Repeating0
20TRXFREQU SearchTRX FrequencyIntegerDDL_TRX_Frequency0
21TIMEREPD SearchTimes RepeatedIntegerINT4_U04
22TIMETREP SearchTimes To RepeatIntegerINT4_U04
23DYSTINCR SearchDays to IncrementIntegerINT3_RB0_U3
24DTLSTREP SearchDate Last RepeatedDateDT8
25DSTBTCH1 SearchDest Batch 1StringSTR15_LBAU15
26DSTBTCH2 SearchDest Batch 2StringSTR15_LBAU15
27USDOCID1 SearchUse Document ID 1StringSTR15_LBAU15
28USDOCID2 SearchUse Document ID 2StringSTR15_LBAU15
29DISCFRGT SearchDiscount Available FreightCurrencyDLR17_RBS0_UTR$17
30ORDAVFRT SearchOriginating Discount Available FreightCurrencyDLR17_RBS0_UTR$17
31DISCMISC SearchDiscount Available MiscCurrencyDLR17_RBS0_UTR$17
32ORDAVMSC SearchOriginating Discount Available MiscCurrencyDLR17_RBS0_UTR$17
33DISAVAMT SearchDiscount Available AmountCurrencyDLR17_RBS0_UTR$17
34ORDAVAMT SearchOriginating Discount Available AmountCurrencyDLR17_RBS0_UTR$17
35DISCRTND SearchDiscount ReturnedCurrencyDLR17_RBS0_STR$17
36ORDISRTD SearchOriginating Discount ReturnedCurrencyDLR17_RBS0_STR$17
37DISTKNAM SearchDiscount Taken AmountCurrencyDLR17_RBS0_UTR$17
38ORDISTKN SearchOriginating Discount Taken AmountCurrencyDLR17_RBS0_UTR$17
39DSCPCTAM SearchDiscount Percent AmountIntegerINT5_%25
40DSCDLRAM SearchDiscount Dollar AmountCurrencyDLR11_RBS0_UTR$11
41ORDDLRAT SearchOriginating Discount Dollar AmountCurrencyDLR11_RBS0_UTR$11
42DISAVTKN SearchDiscount Available TakenCurrencyDLR17_RBS0_UTR$17
43ORDATKN SearchOriginating Discount Available TakenCurrencyDLR17_RBS0_UTR$17
44PYMTRMID SearchPayment Terms IDStringSTR20_Payment_Terms_ID20
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 SearchPriceLevelStringSTR10_LBAU10
46LOCNCODE SearchLocation CodeStringSTR10_Location_Code10
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 SourceStringSTR1515
48BACHNUMB SearchBatch NumberStringSTR15_LBAU15
49CUSTNMBR SearchCustomer NumberStringSTR15_RM_Customer_Number15
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 NameStringSTR64_Customer_Name64
51CSTPONBR SearchCustomer PO NumberStringSTR20_Document_Number20
52PROSPECT SearchProspectIntegerINT11
53MSTRNUMB SearchMaster NumberLong IntegerLI_MasterNumber9
54PCKSLPNO SearchPacking Slip NumberStringSTR20_IVC_Document_Number17
55PICTICNU SearchPicking Ticket NumberStringSTR20_SOP_Number17
56MRKDNAMT SearchMarkdown AmountCurrencyDLR17_RBS0_UTR$17
57ORMRKDAM SearchOriginating Markdown AmountCurrencyDLR17_RBS0_UTR$17
58PRBTADCD SearchPrimary Billto Address CodeStringSTR15_LBAU15
59PRSTADCD SearchPrimary Shipto Address CodeStringSTR15_LBAU15
60CNTCPRSN SearchContact PersonStringSTR6060
61ShipToName SearchShipToNameStringSTR64_Customer_Name64
62ADDRESS1 SearchAddress 1StringSTR6060
63ADDRESS2 SearchAddress 2StringSTR6060
64ADDRESS3 SearchAddress 3StringSTR6060
65CITY SearchCityStringSTR3535
66STATE SearchStateStringSTR30_State29
67ZIPCODE SearchZip CodeStringSTR1010
68CCode SearchCountry CodeStringSTR6_VAT6
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 SearchCountryStringSTR6060
70PHNUMBR1 SearchPhone Number 1StringPhone_Number14
71PHNUMBR2 SearchPhone Number 2StringPhone_Number14
72PHONE3 SearchPhone 3StringPhone_Number314
73FAXNUMBR SearchFax NumberStringSTR14_FAX14
74COMAPPTO SearchCommission Applied ToIntegerGB0
75COMMAMNT SearchCommission AmountCurrencyDLR17_RBS0_STR$17
76OCOMMAMT SearchOriginating Commission AmountCurrencyDLR17_RBSO_STR$17
77CMMSLAMT SearchCommission Sale AmountCurrencyDLR17_RBS0_STR$17
78ORCOSAMT SearchOriginating Commission Sales AmountCurrencyDLR17_RBS0_STR$17
79NCOMAMNT SearchNon-Commissioned AmountCurrencyDLR19_RBS0_STR$19
80ORNCMAMT SearchOriginating Non-Commissioned AmountCurrencyDLR19_RBS0_STR$19
81SHIPMTHD SearchShipping MethodStringSTR15_Shipping_Method15
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 AmountCurrencyDLR17_RBS0_UTR$17
83ORTDISAM SearchOriginating Trade Discount AmountCurrencyDLR17_RBS0_UTR$17
84TRDISPCT SearchTrade Discount PercentIntegerINT4_%24
85SUBTOTAL SearchSubtotalCurrencyDLR17_RBS0_STR$17
86ORSUBTOT SearchOriginating SubtotalCurrencyDLR17_RBS0_STR$17
87REMSUBTO SearchRemaining SubtotalCurrencyDLR17_RBS0_UTR$17
88OREMSUBT SearchOriginating Remaining SubtotalCurrencyDLR17_RBS0_UTR$17
89EXTDCOST SearchExtended CostCurrencyDLR17_RBS0_UTR$17
90OREXTCST SearchOriginating Extended CostCurrencyDLR17_RBS0_UTR$17
91FRTAMNT SearchFreight AmountCurrencyDLR17_RBS0_UTR$17
92ORFRTAMT SearchOriginating Freight AmountCurrencyDLR17_RBS0_UTR$17
93MISCAMNT SearchMisc AmountCurrencyDLR17_RBS0_UTR$17
94ORMISCAMT SearchOriginating Misc AmountCurrencyDLR19_RBSO_UTR$19
95TXENGCLD SearchTax Engine CalledBooleanYN0
96TAXEXMT1 SearchTax Exempt 1StringSTR2525
97TAXEXMT2 SearchTax Exempt 2StringSTR2525
98TXRGNNUM SearchTax Registration NumberStringSTR2525
99TAXSCHID SearchTax Schedule IDStringSTR15_Tax_Schedule_ID15
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 SourceIntegerINT11
101BSIVCTTL SearchBased On Invoice TotalBooleanYN0
102FRTSCHID SearchFreight Schedule IDStringSTR15_LBAU15
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 AmountCurrencyDLR19_RBSO_UTR$19
104ORFRTTAX SearchOriginating Freight Tax AmountCurrencyDLR19_RBSO_UTR$19
105FRGTTXBL SearchFreight TaxableIntegerDDL_Tax_Options0
106MSCSCHID SearchMisc Schedule IDStringSTR15_LBAU15
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 AmountCurrencyDLR19_RBSO_UTR$19
108ORMSCTAX SearchOriginating Misc Tax AmountCurrencyDLR19_RBSO_UTR$19
109MISCTXBL SearchMisc TaxableIntegerDDL_Tax_Options0
110BKTFRTAM SearchBackout Freight AmountCurrencyDLR19_RBS0_UTR$19
111ORBKTFRT SearchOriginating Backout Freight AmountCurrencyDLR19_RBS0_UTR$19
112BKTMSCAM SearchBackout Misc AmountCurrencyDLR19_RBS0_UTR$19
113ORBKTMSC SearchOriginating Backout Misc AmountCurrencyDLR19_RBS0_UTR$19
114BCKTXAMT SearchBackout Tax AmountCurrencyDLR17_RBS0_UTR$17
115OBTAXAMT SearchOriginating Backout Tax AmountCurrencyDLR17_RBS0_UTR$17
116TXBTXAMT SearchTaxable Tax AmountCurrencyDLR19_RBSO_UTR$19
117OTAXTAMT SearchOriginating Taxable Tax AmountCurrencyDLR17_RBS0_UTR$17
118TAXAMNT SearchTax AmountCurrencyDLR17_RBS0_UTR$17
119ORTAXAMT SearchOriginating Tax AmountCurrencyDLR17_RBS0_UTR$17
120ECTRX SearchEC TransactionBooleanCB_EC_Transaction0
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 AmountCurrencyDLR19_RBSO_UTR$19
122ORDOCAMT SearchOriginating Document AmountCurrencyDLR17_RBS0_STR$17
123PYMTRCVD SearchPayment ReceivedCurrencyDLR19_RBS0_UTR$19
124ORPMTRVD SearchOriginating Payment ReceivedCurrencyDLR19_RBS0_UTR$19
125DEPRECVD SearchDeposit ReceivedCurrencyDLR19_RBS0_UTR$19
126ORDEPRVD SearchOriginating Deposit ReceivedCurrencyDLR19_RBS0_UTR$19
127CODAMNT SearchCOD AmountCurrencyDLR17_RBS0_UTR$17
128ORCODAMT SearchOriginating COD AmountCurrencyDLR17_RBS0_UTR$17
129ACCTAMNT SearchAccount AmountCurrencyDLR19_RBS0_UTR$19
130ORACTAMT SearchOriginating Account AmountCurrencyDLR19_RBS0_UTR$19
131SALSTERR SearchSales TerritoryStringSTR15_Sales_Territory15
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 IDStringSTR15_Salesperson_ID15
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 ZoneStringSTR33
134TIMESPRT SearchTimes PrintedIntegerINT4_U04
135PSTGSTUS SearchPosting StatusIntegerINT0
136VOIDSTTS SearchVoid StatusIntegerINT0
137ALLOCABY SearchAllocate ByIntegerDDL_Allocate_By0
138NOTEINDX SearchNote IndexCurrencyDLR1414
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 IDStringSTR15_Currency_ID15
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 IndexIntegerINT33
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 IDStringSTR15_Rate_Type_ID15
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 IDStringSTR15_Exchange_Table_ID15
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 RateCurrency (Variable)DLR14_Exchange_Rate14
144DENXRATE SearchDenomination Exchange RateCurrency (Variable)DLR14_Exchange_Rate14
145EXCHDATE SearchExchange DateDateDT_Date6
146TIME1 SearchTimeTimeTM66
147RTCLCMTD SearchRate Calculation MethodIntegerGB0
148MCTRXSTT SearchMC Transaction StateIntegerINT11
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 SourceStringSTR1313
150SOPHDRE1 SearchSOP HDR Errors 1Long IntegerML_SOP_HDR_Errors_10
151SOPHDRE2 SearchSOP HDR Errors 2Long IntegerML_SOP_HDR_Errors_20
152SOPLNERR SearchSOP LINE ErrorsLong IntegerML_SOP_LINE_Errors0
153SOPHDRFL SearchSOP HDR FlagsLong IntegerML_SOP_HDR_Flags0
154COMMNTID SearchComment IDStringSTR15_Comment_ID15
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 SearchReferenceStringSTR3030
156POSTEDDT SearchPosted DateDateDATE6
157PTDUSRID SearchPosted User IDStringSTR1515
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 EnterStringSTR15_User_ID15
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 DateDateDT8
160MODIFDT SearchModified DateDateDT8
161Tax_Date SearchTax DateDateDT8
162APLYWITH SearchApply WithholdingBooleanBoolean0
163WITHHAMT SearchWithholding AmountCurrencyDLR19_RBSO_UTR$19
164SHPPGDOC SearchShipping DocumentBooleanCB_Shipping_Document0
165CORRCTN SearchCorrectionBooleanCB_Correction0
166SIMPLIFD SearchSimplifiedBooleanCB_Simplified0
167DOCNCORR SearchDocument Number CorrectedStringDocument_Number20
168SEQNCORR SearchSequence Number CorrectedIntegerINT0
169SALEDATE SearchSale DateDateDT8
170EXCEPTIONALDEMAND SearchExceptional DemandBooleanCB_Exceptional_Demand0
171Flags SearchFlagsIntegerINT11
172SOPSTATUS SearchSOP StatusIntegerINT0
173SHIPCOMPLETE SearchShip Complete DocumentBooleanCB_ShipComplete0
174DIRECTDEBIT SearchDirect DebitBooleanCB_DirectDebit0
175WorkflowApprStatCreditLm SearchWorkflow Approval Status Credit LimitIntegerDDL_WorkflowApprovalStatus0
176WorkflowPriorityCreditLm SearchWorkflow Priority Credit LimitIntegerDDL_WorkflowPriority0
177WorkflowApprStatusQuote SearchWorkflow Approval Status QuoteIntegerDDL_WorkflowApprovalStatus0
178WorkflowPriorityQuote SearchWorkflow Priority QuoteIntegerDDL_WorkflowPriority0
179Workflow_Status SearchWorkflow StatusIntegerWorkflow Status0
180ContractExchangeRateStat SearchContract Exchange Rate StatusIntegerINT0
181Print_Phone_NumberGB SearchPrint Phone Number GBIntegerGB0
azurecurveProductsMicrosoft Dynamics GP (0)SalesSales Transaction History (SOP30200)

Leave a Reply

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