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 TypeSQL DB LengthKeyable Length
1SOPTYPE SearchSOP TypeDDL_SOP_TypeInteger20
2SOPNUMBE SearchSOP NumberSTR20_SOP_NumberString2217
3LNITMSEQ SearchLine Item SequenceLI_Sequence_NumberLong Integer410
4CMPNTSEQ SearchComponent SequenceLI_Sequence_NumberLong Integer410
5ITEMNMBR SearchItem NumberSTR30_Item_NumberString3230
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 DescriptionSTR100String102100
7NONINVEN SearchNon IVINT1Integer21
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 ShipINT2Integer22
9UOFM SearchU Of MU_Of_MString108
The unit of measure. The value in this field must exist in Inventory.
10LOCNCODE SearchLocation CodeSTR10_Location_CodeString1210
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 CostDLR17_RBS0_UTR$Currency1017
12ORUNTCST SearchOriginating Unit CostDLR17_RBS0_UTR$Currency1017
13UNITPRCE SearchUnit PriceDLR17_RBS0_STR$Currency1017
14ORUNTPRC SearchOriginating Unit PriceDLR17_RBS0_STR$Currency1017
15XTNDPRCE SearchExtended PriceDLR17_RBS0_STR$Currency1017
16OXTNDPRC SearchOriginating Extended PriceDLR17_RBS0_STR$Currency1017
17REMPRICE SearchRemaining PriceDLR17_RBS0_UTR$Currency1017
18OREPRICE SearchOriginating Remaining PriceDLR17_RBS0_UTR$Currency1017
19EXTDCOST SearchExtended CostDLR17_RBS0_UTR$Currency1017
20OREXTCST SearchOriginating Extended CostDLR17_RBS0_UTR$Currency1017
21MRKDNAMT SearchMarkdown AmountDLR17_RBS0_UTR$Currency1017
22ORMRKDAM SearchOriginating Markdown AmountDLR17_RBS0_UTR$Currency1017
23MRKDNPCT SearchMarkdown PercentINT5_%2Integer25
24MRKDNTYP SearchMarkdown TypeGBInteger20
25INVINDX SearchInventory IndexLI_14Long Integer414
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 IndexLI_14Long Integer414
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 IndexLI_14Long Integer414
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 IndexLI_14Long Integer414
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 IndexLI_14Long Integer414
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 IndexLI_14Long Integer414
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 IndexLI_14Long Integer414
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 IndexLI_14Long Integer414
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 IDSTR15_LBAUString1615
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 TaxableDDL_Tax_OptionsInteger20
35BKTSLSAM SearchBackout Sales AmountDLR19_RBS0_UTR$Currency1019
36ORBKTSLS SearchOriginating Backout Sales AmountDLR19_RBS0_UTR$Currency1019
37TAXAMNT SearchTax AmountDLR17_RBS0_UTR$Currency1017
38ORTAXAMT SearchOriginating Tax AmountDLR17_RBS0_UTR$Currency1017
39TXBTXAMT SearchTaxable Tax AmountDLR19_RBSO_UTR$Currency1019
40OTAXTAMT SearchOriginating Taxable Tax AmountDLR17_RBS0_UTR$Currency1017
41BSIVCTTL SearchBased On Invoice TotalYNBoolean20
42TRDISAMT SearchTrade Discount AmountDLR17_RBS0_UTR$Currency1017
43ORTDISAM SearchOriginating Trade Discount AmountDLR17_RBS0_UTR$Currency1017
44DISCSALE SearchDiscount Available SalesDLR17_RBS0_UTR$Currency1017
45ORDAVSLS SearchOriginating Discount Available SalesDLR17_RBS0_UTR$Currency1017
46QUANTITY SearchQTYDLR17_QTY_RBS0_STRCurrency1017
47ATYALLOC SearchQTY AllocatedDLR17_QTY_RBS0_UTRCurrency1017
48QTYINSVC SearchQTY In ServiceDLR17_QTY_RBS0_UTRCurrency1017
49QTYINUSE SearchQTY In UseDLR17_QTY_RBS0_UTRCurrency1017
50QTYDMGED SearchQTY DamagedDLR17_QTY_RBS0_UTRCurrency1017
51QTYRTRND SearchQTY ReturnedDLR17_QTY_RBS0_UTRCurrency1017
52QTYONHND SearchQTY On HandDLR17_QTY_RBS0_STRCurrency1017
53QTYCANCE SearchQTY CanceledDLR17_QTY_RBS0_UTRCurrency1017
54QTYCANOT SearchQTY Canceled OtherDLR17_QTY_RBS0_UTRCurrency1017
55QTYORDER SearchQTY OrderedDLR17_QTY_RBS0_UTRCurrency1017
56QTYPRBAC SearchQTY Prev Back OrderedDLR17_QTY_RBS0_UTRCurrency1017
57QTYPRBOO SearchQTY Prev BO On OrderDLR17_QTY_RBS0_UTRCurrency1017
58QTYPRINV SearchQTY Prev InvoicedDLR17_QTY_RBS0_UTRCurrency1017
59QTYPRORD SearchQTY Prev OrderedDLR17_QTY_RBS0_UTRCurrency1017
60QTYPRVRECVD SearchQTY Prev ReceivedDLR17_QTY_RBS0_UTRCurrency1017
61QTYRECVD SearchQTY ReceivedDLR17_QTY_RBS0_UTRCurrency1017
62QTYREMAI SearchQTY RemainingDLR17_QTY_RBS0_UTRCurrency1017
63QTYREMBO SearchQTY Remaining On BODLR17_QTY_RBS0_UTRCurrency1017
64QTYTBAOR SearchQTY To Back OrderDLR17_QTY_RBS0_UTRCurrency1017
65QTYTOINV SearchQTY To InvoiceDLR17_QTY_RBS0_UTRCurrency1017
66QTYTORDR SearchQTY To OrderDLR17_QTY_RBS0_UTRCurrency1017
67QTYFULFI SearchQTY FulfilledDLR17_QTY_RBS0_UTRCurrency1017
68QTYSLCTD SearchQTY SelectedDLR17_QTY_RBS0_UTRCurrency1017
69QTYBSUOM SearchQTY In Base U Of MDLR17_QTY_RBS0_STRCurrency1017
70EXTQTYAL SearchExisting Qty AvailableDLR17_RBS0_UTR$Currency1017
71EXTQTYSEL SearchExisting Qty SelectedDLR17_QTY_RBS0_STRCurrency1017
72ReqShipDate SearchRequested Ship DateDTDate48
73FUFILDAT SearchFulfillment DateDTDate48
74ACTLSHIP SearchActual Ship DateDTDate48
75SHIPMTHD SearchShipping MethodSTR15_Shipping_MethodString1615
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 TerritorySTR15_Sales_TerritoryString1615
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 IDSTR15_Salesperson_IDString1615
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 SearchPriceLevelSTR10_LBAUString1210
79COMMNTID SearchComment IDSTR15_Comment_IDString1615
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 1INT1Integer21
81BRKFLD2 SearchBreak Field 2INT1Integer21
82BRKFLD3 SearchBreak Field 3INT1Integer21
83CURRNIDX SearchCurrency IndexINT3Integer23
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 SourceSTR13String1413
85SOPLNERR SearchSOP LINE ErrorsML_SOP_LINE_ErrorsLong Integer40
86DOCNCORR SearchDocument Number CorrectedDocument_NumberString2220
87ORGSEQNM SearchOriginal Sequence Number CorrectedLI_Sequence_NumberLong Integer410
88ITEMCODE SearchItem CodeSTR15String1615
89PURCHSTAT SearchPurchasing StatusDDL_PurchasingStatusInteger20
90DECPLQTY SearchDecimal Places QTYSDDL_Decimal_Places_QTYSInteger20
91DECPLCUR SearchDecimal Places CurrencyDDL_Decimal_Places_DollarsInteger20
92ODECPLCU SearchOriginating Decimal Places CurrencyDDL_Decimal_Places_DollarsInteger20
93EXCEPTIONALDEMAND SearchExceptional DemandCB_Exceptional_DemandBoolean20
94TAXSCHID SearchTax Schedule IDSTR15_Tax_Schedule_IDString1615
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 SourceINT1Integer21
96PRSTADCD SearchPrimary Shipto Address CodeSTR15_LBAUString1615
97ShipToName SearchShipToNameSTR64_Customer_NameString6664
98CNTCPRSN SearchContact PersonSTR60String6260
99ADDRESS1 SearchAddress 1STR60String6260
100ADDRESS2 SearchAddress 2STR60String6260
101ADDRESS3 SearchAddress 3STR60String6260
102CITY SearchCitySTR35String3635
103STATE SearchStateSTR30_StateString3029
104ZIPCODE SearchZip CodeSTR10String1210
105CCode SearchCountry CodeSTR6_VATString86
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 SearchCountrySTR60String6260
107PHONE1 SearchPhone 1Phone_NumberString2214
108PHONE2 SearchPhone 2Phone_NumberString2214
109PHONE3 SearchPhone 3Phone_Number3String2214
110FAXNUMBR SearchFax NumberSTR14_FAXString2214
111Flags SearchFlagsINT1Integer21
112CONTNBR SearchContract NumberSTR11String1211
113CONTLNSEQNBR SearchContract Line SEQ NumberSequence_NumberCurrency1019
114CONTSTARTDTE SearchContract Start DateDATEDate46
115CONTENDDTE SearchContract End DateDATE_LDate40
116CONTITEMNBR SearchContract Item NumberSTR30_Item_NumberString3230
117CONTSERIALNBR SearchContract Serial NumberSTR20_LBAUString2220
118ISLINEINTRA SearchIsLineIntrastatCBBoolean20
119Print_Phone_NumberGB SearchPrint Phone Number GBGBInteger20
120DEX_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.
121DEX_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 Amounts History (SOP30300)

Leave a Reply

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