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 TypeDDL_SOP_TypeInteger0
2SOPNUMBE SearchSOP NumberSTR20_SOP_NumberString17
3LNITMSEQ SearchLine Item SequenceLI_Sequence_NumberLong Integer10
4CMPNTSEQ SearchComponent SequenceLI_Sequence_NumberLong Integer10
5ITEMNMBR SearchItem NumberSTR30_Item_NumberString30
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 DescriptionSTR100String100
7NONINVEN SearchNon IVINT1Integer1
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 ShipINT2Integer2
9UOFM SearchU Of MU_Of_MString8
The unit of measure. The value in this field must exist in Inventory.
10LOCNCODE SearchLocation CodeSTR10_Location_CodeString10
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$Currency17
12ORUNTCST SearchOriginating Unit CostDLR17_RBS0_UTR$Currency17
13UNITPRCE SearchUnit PriceDLR17_RBS0_STR$Currency17
14ORUNTPRC SearchOriginating Unit PriceDLR17_RBS0_STR$Currency17
15XTNDPRCE SearchExtended PriceDLR17_RBS0_STR$Currency17
16OXTNDPRC SearchOriginating Extended PriceDLR17_RBS0_STR$Currency17
17REMPRICE SearchRemaining PriceDLR17_RBS0_UTR$Currency17
18OREPRICE SearchOriginating Remaining PriceDLR17_RBS0_UTR$Currency17
19EXTDCOST SearchExtended CostDLR17_RBS0_UTR$Currency17
20OREXTCST SearchOriginating Extended CostDLR17_RBS0_UTR$Currency17
21MRKDNAMT SearchMarkdown AmountDLR17_RBS0_UTR$Currency17
22ORMRKDAM SearchOriginating Markdown AmountDLR17_RBS0_UTR$Currency17
23MRKDNPCT SearchMarkdown PercentINT5_%2Integer5
24MRKDNTYP SearchMarkdown TypeGBInteger0
25INVINDX SearchInventory IndexLI_14Long Integer14
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 Integer14
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 Integer14
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 Integer14
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 Integer14
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 Integer14
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 Integer14
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 Integer14
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_LBAUString15
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_OptionsInteger0
35BKTSLSAM SearchBackout Sales AmountDLR19_RBS0_UTR$Currency19
36ORBKTSLS SearchOriginating Backout Sales AmountDLR19_RBS0_UTR$Currency19
37TAXAMNT SearchTax AmountDLR17_RBS0_UTR$Currency17
38ORTAXAMT SearchOriginating Tax AmountDLR17_RBS0_UTR$Currency17
39TXBTXAMT SearchTaxable Tax AmountDLR19_RBSO_UTR$Currency19
40OTAXTAMT SearchOriginating Taxable Tax AmountDLR17_RBS0_UTR$Currency17
41BSIVCTTL SearchBased On Invoice TotalYNBoolean0
42TRDISAMT SearchTrade Discount AmountDLR17_RBS0_UTR$Currency17
43ORTDISAM SearchOriginating Trade Discount AmountDLR17_RBS0_UTR$Currency17
44DISCSALE SearchDiscount Available SalesDLR17_RBS0_UTR$Currency17
45ORDAVSLS SearchOriginating Discount Available SalesDLR17_RBS0_UTR$Currency17
46QUANTITY SearchQTYDLR17_QTY_RBS0_STRCurrency17
47ATYALLOC SearchQTY AllocatedDLR17_QTY_RBS0_UTRCurrency17
48QTYINSVC SearchQTY In ServiceDLR17_QTY_RBS0_UTRCurrency17
49QTYINUSE SearchQTY In UseDLR17_QTY_RBS0_UTRCurrency17
50QTYDMGED SearchQTY DamagedDLR17_QTY_RBS0_UTRCurrency17
51QTYRTRND SearchQTY ReturnedDLR17_QTY_RBS0_UTRCurrency17
52QTYONHND SearchQTY On HandDLR17_QTY_RBS0_STRCurrency17
53QTYCANCE SearchQTY CanceledDLR17_QTY_RBS0_UTRCurrency17
54QTYCANOT SearchQTY Canceled OtherDLR17_QTY_RBS0_UTRCurrency17
55QTYORDER SearchQTY OrderedDLR17_QTY_RBS0_UTRCurrency17
56QTYPRBAC SearchQTY Prev Back OrderedDLR17_QTY_RBS0_UTRCurrency17
57QTYPRBOO SearchQTY Prev BO On OrderDLR17_QTY_RBS0_UTRCurrency17
58QTYPRINV SearchQTY Prev InvoicedDLR17_QTY_RBS0_UTRCurrency17
59QTYPRORD SearchQTY Prev OrderedDLR17_QTY_RBS0_UTRCurrency17
60QTYPRVRECVD SearchQTY Prev ReceivedDLR17_QTY_RBS0_UTRCurrency17
61QTYRECVD SearchQTY ReceivedDLR17_QTY_RBS0_UTRCurrency17
62QTYREMAI SearchQTY RemainingDLR17_QTY_RBS0_UTRCurrency17
63QTYREMBO SearchQTY Remaining On BODLR17_QTY_RBS0_UTRCurrency17
64QTYTBAOR SearchQTY To Back OrderDLR17_QTY_RBS0_UTRCurrency17
65QTYTOINV SearchQTY To InvoiceDLR17_QTY_RBS0_UTRCurrency17
66QTYTORDR SearchQTY To OrderDLR17_QTY_RBS0_UTRCurrency17
67QTYFULFI SearchQTY FulfilledDLR17_QTY_RBS0_UTRCurrency17
68QTYSLCTD SearchQTY SelectedDLR17_QTY_RBS0_UTRCurrency17
69QTYBSUOM SearchQTY In Base U Of MDLR17_QTY_RBS0_STRCurrency17
70EXTQTYAL SearchExisting Qty AvailableDLR17_RBS0_UTR$Currency17
71EXTQTYSEL SearchExisting Qty SelectedDLR17_QTY_RBS0_STRCurrency17
72ReqShipDate SearchRequested Ship DateDTDate8
73FUFILDAT SearchFulfillment DateDTDate8
74ACTLSHIP SearchActual Ship DateDTDate8
75SHIPMTHD SearchShipping MethodSTR15_Shipping_MethodString15
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_TerritoryString15
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_IDString15
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_LBAUString10
79COMMNTID SearchComment IDSTR15_Comment_IDString15
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 1INT1Integer1
81BRKFLD2 SearchBreak Field 2INT1Integer1
82BRKFLD3 SearchBreak Field 3INT1Integer1
83CURRNIDX SearchCurrency IndexINT3Integer3
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 SourceSTR13String13
85SOPLNERR SearchSOP LINE ErrorsML_SOP_LINE_ErrorsLong Integer0
86DOCNCORR SearchDocument Number CorrectedDocument_NumberString20
87ORGSEQNM SearchOriginal Sequence Number CorrectedLI_Sequence_NumberLong Integer10
88ITEMCODE SearchItem CodeSTR15String15
89PURCHSTAT SearchPurchasing StatusDDL_PurchasingStatusInteger0
90DECPLQTY SearchDecimal Places QTYSDDL_Decimal_Places_QTYSInteger0
91DECPLCUR SearchDecimal Places CurrencyDDL_Decimal_Places_DollarsInteger0
92ODECPLCU SearchOriginating Decimal Places CurrencyDDL_Decimal_Places_DollarsInteger0
93EXCEPTIONALDEMAND SearchExceptional DemandCB_Exceptional_DemandBoolean0
94TAXSCHID SearchTax Schedule IDSTR15_Tax_Schedule_IDString15
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 SourceINT1Integer1
96PRSTADCD SearchPrimary Shipto Address CodeSTR15_LBAUString15
97ShipToName SearchShipToNameSTR64_Customer_NameString64
98CNTCPRSN SearchContact PersonSTR60String60
99ADDRESS1 SearchAddress 1STR60String60
100ADDRESS2 SearchAddress 2STR60String60
101ADDRESS3 SearchAddress 3STR60String60
102CITY SearchCitySTR35String35
103STATE SearchStateSTR30_StateString29
104ZIPCODE SearchZip CodeSTR10String10
105CCode SearchCountry CodeSTR6_VATString6
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 SearchCountrySTR60String60
107PHONE1 SearchPhone 1Phone_NumberString14
108PHONE2 SearchPhone 2Phone_NumberString14
109PHONE3 SearchPhone 3Phone_Number3String14
110FAXNUMBR SearchFax NumberSTR14_FAXString14
111Flags SearchFlagsINT1Integer1
112CONTNBR SearchContract NumberSTR11String11
113CONTLNSEQNBR SearchContract Line SEQ NumberSequence_NumberCurrency19
114CONTSTARTDTE SearchContract Start DateDATEDate6
115CONTENDDTE SearchContract End DateDATE_LDate0
116CONTITEMNBR SearchContract Item NumberSTR30_Item_NumberString30
117CONTSERIALNBR SearchContract Serial NumberSTR20_LBAUString20
118ISLINEINTRA SearchIsLineIntrastatCBBoolean0
119Print_Phone_NumberGB SearchPrint Phone Number GBGBInteger0
120DEX_ROW_TS Searchdatetimedatetime3
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 Searchintint10

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 *