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 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 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 SearchPriceLevelStringSTR10_LBAU10
46LOCNCODE SearchLocation CodeStringSTR10_Location_Code10
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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 IDStringSTR15_Salesperson_ID15
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 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 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 IDStringSTR15_Currency_ID15
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 IndexIntegerINT33
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 IDStringSTR15_Rate_Type_ID15
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 IDStringSTR15_Exchange_Table_ID15
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 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
154SOPMCERR SearchSOP MC Posting Error MessagesLong IntegerSOP MC Posting Error Messages0
155COMMNTID SearchComment IDStringSTR15_Comment_ID15
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 SearchReferenceStringSTR3030
157POSTEDDT SearchPosted DateDateDATE6
158PTDUSRID SearchPosted User IDStringSTR1515
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 EnterStringSTR15_User_ID15
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 DateDateDT8
161MODIFDT SearchModified DateDateDT8
162Tax_Date SearchTax DateDateDT8
163APLYWITH SearchApply WithholdingBooleanBoolean0
164WITHHAMT SearchWithholding AmountCurrencyDLR19_RBSO_UTR$19
165SHPPGDOC SearchShipping DocumentBooleanCB_Shipping_Document0
166CORRCTN SearchCorrectionBooleanCB_Correction0
167SIMPLIFD SearchSimplifiedBooleanCB_Simplified0
168CORRNXST SearchCorrection to Nonexisting TransactionBooleanBoolean0
169DOCNCORR SearchDocument Number CorrectedStringDocument_Number20
170SEQNCORR SearchSequence Number CorrectedIntegerINT0
171SALEDATE SearchSale DateDateDT8
172SOPHDRE3 SearchSOP HDR Errors 3Long IntegerML_SOP_HDR_Errors_30
173EXCEPTIONALDEMAND SearchExceptional DemandBooleanCB_Exceptional_Demand0
174Flags SearchFlagsIntegerINT11
175BackoutTradeDisc SearchBackout Trade Discount AmountCurrencyDLR19_RBS0_UTR$19
176OrigBackoutTradeDisc SearchOriginating Backout Trade Discount AmountCurrencyDLR19_RBS0_UTR$19
177GPSFOINTEGRATIONID SearchGPSFO Integration IDStringSTR3030
178INTEGRATIONSOURCE SearchIntegration SourceIntegerINT0
179INTEGRATIONID SearchIntegration IDStringSTR3030
180SOPSTATUS SearchSOP StatusIntegerINT0
181SHIPCOMPLETE SearchShip Complete DocumentBooleanCB_ShipComplete0
182DIRECTDEBIT SearchDirect DebitBooleanCB_DirectDebit0
183WorkflowApprStatCreditLm SearchWorkflow Approval Status Credit LimitIntegerDDL_WorkflowApprovalStatus0
184WorkflowPriorityCreditLm SearchWorkflow Priority Credit LimitIntegerDDL_WorkflowPriority0
185WorkflowApprStatusQuote SearchWorkflow Approval Status QuoteIntegerDDL_WorkflowApprovalStatus0
186WorkflowPriorityQuote SearchWorkflow Priority QuoteIntegerDDL_WorkflowPriority0
187Workflow_Status SearchWorkflow StatusIntegerWorkflow Status0
188ContractExchangeRateStat SearchContract Exchange Rate StatusIntegerINT0
189Print_Phone_NumberGB SearchPrint Phone Number GBIntegerGB0
azurecurveProductsMicrosoft Dynamics GP (0)SalesSales Transaction Work (SOP10100)

Leave a Reply

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