Sales Transaction Amounts History (SOP30300)

azurecurveProductsMicrosoft Dynamics GP (0)SalesSales Transaction Amounts History (SOP30300)

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

Product: Microsoft Dynamics GP (0)
Series: Sales

Display Name: Sales Transaction Amounts History
Physical Name: SOP30300
Technical Name: SOP_LINE_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
3LNITMSEQ SearchLine Item SequenceLong IntegerLI_Sequence_Number10
4CMPNTSEQ SearchComponent SequenceLong IntegerLI_Sequence_Number10
5ITEMNMBR SearchItem NumberStringSTR30_Item_Number30
Key to the Item Master (IV00101).

Click to show/hide

SELECT
       ['Sales Transaction Amounts History'].ITEMNMBR AS 'Sales Transaction Amounts History-Item Number'
       ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
       SOP30300 AS ['Sales Transaction Amounts History']
INNER JOIN
       IV00101 AS ['Item Master']
              ON
                     ['Sales Transaction Amounts History'].ITEMNMBR = ['Item Master'].ITEMNMBR
6ITEMDESC SearchItem DescriptionStringSTR100100
7NONINVEN SearchNon IVIntegerINT11
Used to indicate whether an item is an inventory item or non-inventory item.

Click to show/hide PO Line Statuses

0	Inventory item
1	Non-inventory item
8DROPSHIP SearchDrop ShipIntegerINT22
9UOFM SearchU Of MStringU_Of_M8
The unit of measure. The value in this field must exist in Inventory.
10LOCNCODE SearchLocation CodeStringSTR10_Location_Code10
Key to the Site Setup (IV40700).

Click to show/hide

SELECT
       ['Sales Transaction Amounts History'].LOCNCODE AS 'Sales Transaction Amounts History-Location Code'
       ,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
       SOP30300 AS ['Sales Transaction Amounts History']
INNER JOIN
       IV40700 AS ['Site Setup']
              ON
                     ['Sales Transaction Amounts History'].LOCNCODE = ['Site Setup'].LOCNCODE
11UNITCOST SearchUnit CostCurrencyDLR17_RBS0_UTR$17
12ORUNTCST SearchOriginating Unit CostCurrencyDLR17_RBS0_UTR$17
13UNITPRCE SearchUnit PriceCurrencyDLR17_RBS0_STR$17
14ORUNTPRC SearchOriginating Unit PriceCurrencyDLR17_RBS0_STR$17
15XTNDPRCE SearchExtended PriceCurrencyDLR17_RBS0_STR$17
16OXTNDPRC SearchOriginating Extended PriceCurrencyDLR17_RBS0_STR$17
17REMPRICE SearchRemaining PriceCurrencyDLR17_RBS0_UTR$17
18OREPRICE SearchOriginating Remaining PriceCurrencyDLR17_RBS0_UTR$17
19EXTDCOST SearchExtended CostCurrencyDLR17_RBS0_UTR$17
20OREXTCST SearchOriginating Extended CostCurrencyDLR17_RBS0_UTR$17
21MRKDNAMT SearchMarkdown AmountCurrencyDLR17_RBS0_UTR$17
22ORMRKDAM SearchOriginating Markdown AmountCurrencyDLR17_RBS0_UTR$17
23MRKDNPCT SearchMarkdown PercentIntegerINT5_%25
24MRKDNTYP SearchMarkdown TypeIntegerGB0
25INVINDX SearchInventory IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Sales Transaction Amounts History'].INVINDX AS 'Sales Transaction Amounts History-Inventory Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       SOP30300 AS ['Sales Transaction Amounts History']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Sales Transaction Amounts History'].INVINDX = ['Account Index Master'].ACTINDX
26CSLSINDX SearchCost Of Sales IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Sales Transaction Amounts History'].CSLSINDX AS 'Sales Transaction Amounts History-Cost Of Sales Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       SOP30300 AS ['Sales Transaction Amounts History']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Sales Transaction Amounts History'].CSLSINDX = ['Account Index Master'].ACTINDX
27SLSINDX SearchSales IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Sales Transaction Amounts History'].SLSINDX AS 'Sales Transaction Amounts History-Sales Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       SOP30300 AS ['Sales Transaction Amounts History']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Sales Transaction Amounts History'].SLSINDX = ['Account Index Master'].ACTINDX
28MKDNINDX SearchMarkdown IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Sales Transaction Amounts History'].MKDNINDX AS 'Sales Transaction Amounts History-Markdown Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       SOP30300 AS ['Sales Transaction Amounts History']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Sales Transaction Amounts History'].MKDNINDX = ['Account Index Master'].ACTINDX
29RTNSINDX SearchReturns IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Sales Transaction Amounts History'].RTNSINDX AS 'Sales Transaction Amounts History-Returns Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       SOP30300 AS ['Sales Transaction Amounts History']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Sales Transaction Amounts History'].RTNSINDX = ['Account Index Master'].ACTINDX
30INUSINDX SearchIn Use IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Sales Transaction Amounts History'].INUSINDX AS 'Sales Transaction Amounts History-In Use Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       SOP30300 AS ['Sales Transaction Amounts History']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Sales Transaction Amounts History'].INUSINDX = ['Account Index Master'].ACTINDX
31INSRINDX SearchIn Service IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Sales Transaction Amounts History'].INSRINDX AS 'Sales Transaction Amounts History-In Service Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       SOP30300 AS ['Sales Transaction Amounts History']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Sales Transaction Amounts History'].INSRINDX = ['Account Index Master'].ACTINDX
32DMGDINDX SearchDamaged IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Sales Transaction Amounts History'].DMGDINDX AS 'Sales Transaction Amounts History-Damaged Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       SOP30300 AS ['Sales Transaction Amounts History']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Sales Transaction Amounts History'].DMGDINDX = ['Account Index Master'].ACTINDX
33ITMTSHID SearchItem Tax Schedule IDStringSTR15_LBAU15
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['Sales Transaction Amounts History'].ITMTSHID AS 'Sales Transaction Amounts History-Item Tax Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       SOP30300 AS ['Sales Transaction Amounts History']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['Sales Transaction Amounts History'].ITMTSHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
34IVITMTXB SearchIV Item TaxableIntegerDDL_Tax_Options0
35BKTSLSAM SearchBackout Sales AmountCurrencyDLR19_RBS0_UTR$19
36ORBKTSLS SearchOriginating Backout Sales AmountCurrencyDLR19_RBS0_UTR$19
37TAXAMNT SearchTax AmountCurrencyDLR17_RBS0_UTR$17
38ORTAXAMT SearchOriginating Tax AmountCurrencyDLR17_RBS0_UTR$17
39TXBTXAMT SearchTaxable Tax AmountCurrencyDLR19_RBSO_UTR$19
40OTAXTAMT SearchOriginating Taxable Tax AmountCurrencyDLR17_RBS0_UTR$17
41BSIVCTTL SearchBased On Invoice TotalBooleanYN0
42TRDISAMT SearchTrade Discount AmountCurrencyDLR17_RBS0_UTR$17
43ORTDISAM SearchOriginating Trade Discount AmountCurrencyDLR17_RBS0_UTR$17
44DISCSALE SearchDiscount Available SalesCurrencyDLR17_RBS0_UTR$17
45ORDAVSLS SearchOriginating Discount Available SalesCurrencyDLR17_RBS0_UTR$17
46QUANTITY SearchQTYCurrencyDLR17_QTY_RBS0_STR17
47ATYALLOC SearchQTY AllocatedCurrencyDLR17_QTY_RBS0_UTR17
48QTYINSVC SearchQTY In ServiceCurrencyDLR17_QTY_RBS0_UTR17
49QTYINUSE SearchQTY In UseCurrencyDLR17_QTY_RBS0_UTR17
50QTYDMGED SearchQTY DamagedCurrencyDLR17_QTY_RBS0_UTR17
51QTYRTRND SearchQTY ReturnedCurrencyDLR17_QTY_RBS0_UTR17
52QTYONHND SearchQTY On HandCurrencyDLR17_QTY_RBS0_STR17
53QTYCANCE SearchQTY CanceledCurrencyDLR17_QTY_RBS0_UTR17
54QTYCANOT SearchQTY Canceled OtherCurrencyDLR17_QTY_RBS0_UTR17
55QTYORDER SearchQTY OrderedCurrencyDLR17_QTY_RBS0_UTR17
56QTYPRBAC SearchQTY Prev Back OrderedCurrencyDLR17_QTY_RBS0_UTR17
57QTYPRBOO SearchQTY Prev BO On OrderCurrencyDLR17_QTY_RBS0_UTR17
58QTYPRINV SearchQTY Prev InvoicedCurrencyDLR17_QTY_RBS0_UTR17
59QTYPRORD SearchQTY Prev OrderedCurrencyDLR17_QTY_RBS0_UTR17
60QTYPRVRECVD SearchQTY Prev ReceivedCurrencyDLR17_QTY_RBS0_UTR17
61QTYRECVD SearchQTY ReceivedCurrencyDLR17_QTY_RBS0_UTR17
62QTYREMAI SearchQTY RemainingCurrencyDLR17_QTY_RBS0_UTR17
63QTYREMBO SearchQTY Remaining On BOCurrencyDLR17_QTY_RBS0_UTR17
64QTYTBAOR SearchQTY To Back OrderCurrencyDLR17_QTY_RBS0_UTR17
65QTYTOINV SearchQTY To InvoiceCurrencyDLR17_QTY_RBS0_UTR17
66QTYTORDR SearchQTY To OrderCurrencyDLR17_QTY_RBS0_UTR17
67QTYFULFI SearchQTY FulfilledCurrencyDLR17_QTY_RBS0_UTR17
68QTYSLCTD SearchQTY SelectedCurrencyDLR17_QTY_RBS0_UTR17
69QTYBSUOM SearchQTY In Base U Of MCurrencyDLR17_QTY_RBS0_STR17
70EXTQTYAL SearchExisting Qty AvailableCurrencyDLR17_RBS0_UTR$17
71EXTQTYSEL SearchExisting Qty SelectedCurrencyDLR17_QTY_RBS0_STR17
72ReqShipDate SearchRequested Ship DateDateDT8
73FUFILDAT SearchFulfillment DateDateDT8
74ACTLSHIP SearchActual Ship DateDateDT8
75SHIPMTHD SearchShipping MethodStringSTR15_Shipping_Method15
Key to the Shipping Methods Master (SY03000).

Click to show/hide

SELECT
       ['Sales Transaction Amounts History'].SHIPMTHD AS 'Sales Transaction Amounts History-Shipping Method'
       ,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method'
FROM
       SOP30300 AS ['Sales Transaction Amounts History']
INNER JOIN
       SY03000 AS ['Shipping Methods Master']
              ON
                     ['Sales Transaction Amounts History'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD
76SALSTERR SearchSales TerritoryStringSTR15_Sales_Territory15
Key to the Sales Territory Master File (RM00303).

Click to show/hide

SELECT
       ['Sales Transaction Amounts History'].SALSTERR AS 'Sales Transaction Amounts History-Sales Territory'
       ,['Sales Territory Master File'].SALSTERR AS 'Sales Territory Master File-Sales Territory'
FROM
       SOP30300 AS ['Sales Transaction Amounts History']
INNER JOIN
       RM00303 AS ['Sales Territory Master File']
              ON
                     ['Sales Transaction Amounts History'].SALSTERR = ['Sales Territory Master File'].SALSTERR
77SLPRSNID SearchSalesperson IDStringSTR15_Salesperson_ID15
Key to the RM Salesperson Master (RM00301).

Click to show/hide

SELECT
       ['Sales Transaction Amounts History'].SLPRSNID AS 'Sales Transaction Amounts History-Salesperson ID'
       ,['RM Salesperson Master'].SLPRSNID AS 'RM Salesperson Master-Salesperson ID'
FROM
       SOP30300 AS ['Sales Transaction Amounts History']
INNER JOIN
       RM00301 AS ['RM Salesperson Master']
              ON
                     ['Sales Transaction Amounts History'].SLPRSNID = ['RM Salesperson Master'].SLPRSNID
78PRCLEVEL SearchPriceLevelStringSTR10_LBAU10
79COMMNTID SearchComment IDStringSTR15_Comment_ID15
Key to the Comment Master (SY04200).

Click to show/hide

SELECT
       ['Sales Transaction Amounts History'].COMMNTID AS 'Sales Transaction Amounts History-Comment ID'
       ,['Comment Master'].COMMNTID AS 'Comment Master-Comment ID'
FROM
       SOP30300 AS ['Sales Transaction Amounts History']
INNER JOIN
       SY04200 AS ['Comment Master']
              ON
                     ['Sales Transaction Amounts History'].COMMNTID = ['Comment Master'].COMMNTID
80BRKFLD1 SearchBreak Field 1IntegerINT11
81BRKFLD2 SearchBreak Field 2IntegerINT11
82BRKFLD3 SearchBreak Field 3IntegerINT11
83CURRNIDX SearchCurrency IndexIntegerINT33
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['Sales Transaction Amounts History'].CURRNIDX AS 'Sales Transaction Amounts History-Currency Index'
       ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
       SOP30300 AS ['Sales Transaction Amounts History']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['Sales Transaction Amounts History'].CURRNIDX = ['Currency Setup'].CURRNIDX
84TRXSORCE SearchTRX SourceStringSTR1313
85SOPLNERR SearchSOP LINE ErrorsLong IntegerML_SOP_LINE_Errors0
86DOCNCORR SearchDocument Number CorrectedStringDocument_Number20
87ORGSEQNM SearchOriginal Sequence Number CorrectedLong IntegerLI_Sequence_Number10
88ITEMCODE SearchItem CodeStringSTR1515
89PURCHSTAT SearchPurchasing StatusIntegerDDL_PurchasingStatus0
90DECPLQTY SearchDecimal Places QTYSIntegerDDL_Decimal_Places_QTYS0
91DECPLCUR SearchDecimal Places CurrencyIntegerDDL_Decimal_Places_Dollars0
92ODECPLCU SearchOriginating Decimal Places CurrencyIntegerDDL_Decimal_Places_Dollars0
93EXCEPTIONALDEMAND SearchExceptional DemandBooleanCB_Exceptional_Demand0
94TAXSCHID SearchTax Schedule IDStringSTR15_Tax_Schedule_ID15
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['Sales Transaction Amounts History'].TAXSCHID AS 'Sales Transaction Amounts History-Tax Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       SOP30300 AS ['Sales Transaction Amounts History']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['Sales Transaction Amounts History'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
95TXSCHSRC SearchTax Schedule SourceIntegerINT11
96PRSTADCD SearchPrimary Shipto Address CodeStringSTR15_LBAU15
97ShipToName SearchShipToNameStringSTR64_Customer_Name64
98CNTCPRSN SearchContact PersonStringSTR6060
99ADDRESS1 SearchAddress 1StringSTR6060
100ADDRESS2 SearchAddress 2StringSTR6060
101ADDRESS3 SearchAddress 3StringSTR6060
102CITY SearchCityStringSTR3535
103STATE SearchStateStringSTR30_State29
104ZIPCODE SearchZip CodeStringSTR1010
105CCode SearchCountry CodeStringSTR6_VAT6
Key to the VAT Country Code MSTR (VAT10001).

Click to show/hide

SELECT
       ['Sales Transaction Amounts History'].CCode AS 'Sales Transaction Amounts History-Country Code'
       ,['VAT Country Code MSTR'].CCode AS 'VAT Country Code MSTR-Country Code'
FROM
       SOP30300 AS ['Sales Transaction Amounts History']
INNER JOIN
       VAT10001 AS ['VAT Country Code MSTR']
              ON
                     ['Sales Transaction Amounts History'].CCode = ['VAT Country Code MSTR'].CCode
106COUNTRY SearchCountryStringSTR6060
107PHONE1 SearchPhone 1StringPhone_Number14
108PHONE2 SearchPhone 2StringPhone_Number14
109PHONE3 SearchPhone 3StringPhone_Number314
110FAXNUMBR SearchFax NumberStringSTR14_FAX14
111Flags SearchFlagsIntegerINT11
112CONTNBR SearchContract NumberStringSTR1111
113CONTLNSEQNBR SearchContract Line SEQ NumberCurrencySequence_Number19
114CONTSTARTDTE SearchContract Start DateDateDATE6
115CONTENDDTE SearchContract End DateDateDATE_L0
116CONTITEMNBR SearchContract Item NumberStringSTR30_Item_Number30
117CONTSERIALNBR SearchContract Serial NumberStringSTR20_LBAU20
118ISLINEINTRA SearchIsLineIntrastatBooleanCB0
119Print_Phone_NumberGB SearchPrint Phone Number GBIntegerGB0
azurecurveProductsMicrosoft Dynamics GP (0)SalesSales Transaction Amounts History (SOP30300)

Leave a Reply

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