Sales Transaction Amounts Work (SOP10200)

azurecurveProductsMicrosoft Dynamics GP (0)SalesSales Transaction Amounts Work (SOP10200)

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

Product: Microsoft Dynamics GP (0)
Series: Sales

Display Name: Sales Transaction Amounts Work
Physical Name: SOP10200
Technical Name: SOP_LINE_WORK

Group Display Name: Sales Work
Group Technical Name: Sales Work

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 Work'].ITEMNMBR AS 'Sales Transaction Amounts Work-Item Number'
       ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
       SOP10200 AS ['Sales Transaction Amounts Work']
INNER JOIN
       IV00101 AS ['Item Master']
              ON
                     ['Sales Transaction Amounts Work'].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 Work'].LOCNCODE AS 'Sales Transaction Amounts Work-Location Code'
       ,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
       SOP10200 AS ['Sales Transaction Amounts Work']
INNER JOIN
       IV40700 AS ['Site Setup']
              ON
                     ['Sales Transaction Amounts Work'].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 Work'].INVINDX AS 'Sales Transaction Amounts Work-Inventory Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       SOP10200 AS ['Sales Transaction Amounts Work']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Sales Transaction Amounts Work'].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 Work'].CSLSINDX AS 'Sales Transaction Amounts Work-Cost Of Sales Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       SOP10200 AS ['Sales Transaction Amounts Work']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Sales Transaction Amounts Work'].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 Work'].SLSINDX AS 'Sales Transaction Amounts Work-Sales Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       SOP10200 AS ['Sales Transaction Amounts Work']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Sales Transaction Amounts Work'].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 Work'].MKDNINDX AS 'Sales Transaction Amounts Work-Markdown Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       SOP10200 AS ['Sales Transaction Amounts Work']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Sales Transaction Amounts Work'].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 Work'].RTNSINDX AS 'Sales Transaction Amounts Work-Returns Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       SOP10200 AS ['Sales Transaction Amounts Work']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Sales Transaction Amounts Work'].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 Work'].INUSINDX AS 'Sales Transaction Amounts Work-In Use Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       SOP10200 AS ['Sales Transaction Amounts Work']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Sales Transaction Amounts Work'].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 Work'].INSRINDX AS 'Sales Transaction Amounts Work-In Service Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       SOP10200 AS ['Sales Transaction Amounts Work']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Sales Transaction Amounts Work'].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 Work'].DMGDINDX AS 'Sales Transaction Amounts Work-Damaged Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       SOP10200 AS ['Sales Transaction Amounts Work']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Sales Transaction Amounts Work'].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 Work'].ITMTSHID AS 'Sales Transaction Amounts Work-Item Tax Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       SOP10200 AS ['Sales Transaction Amounts Work']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['Sales Transaction Amounts Work'].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
55QTYONPO SearchQTY On PODLR17_QTY_RBS0_UTRCurrency17
56QTYORDER SearchQTY OrderedDLR17_QTY_RBS0_UTRCurrency17
57QTYPRBAC SearchQTY Prev Back OrderedDLR17_QTY_RBS0_UTRCurrency17
58QTYPRBOO SearchQTY Prev BO On OrderDLR17_QTY_RBS0_UTRCurrency17
59QTYPRINV SearchQTY Prev InvoicedDLR17_QTY_RBS0_UTRCurrency17
60QTYPRORD SearchQTY Prev OrderedDLR17_QTY_RBS0_UTRCurrency17
61QTYPRVRECVD SearchQTY Prev ReceivedDLR17_QTY_RBS0_UTRCurrency17
62QTYRECVD SearchQTY ReceivedDLR17_QTY_RBS0_UTRCurrency17
63QTYREMAI SearchQTY RemainingDLR17_QTY_RBS0_UTRCurrency17
64QTYREMBO SearchQTY Remaining On BODLR17_QTY_RBS0_UTRCurrency17
65QTYTBAOR SearchQTY To Back OrderDLR17_QTY_RBS0_UTRCurrency17
66QTYTOINV SearchQTY To InvoiceDLR17_QTY_RBS0_UTRCurrency17
67QTYTORDR SearchQTY To OrderDLR17_QTY_RBS0_UTRCurrency17
68QTYFULFI SearchQTY FulfilledDLR17_QTY_RBS0_UTRCurrency17
69QTYSLCTD SearchQTY SelectedDLR17_QTY_RBS0_UTRCurrency17
70QTYBSUOM SearchQTY In Base U Of MDLR17_QTY_RBS0_STRCurrency17
71EXTQTYAL SearchExisting Qty AvailableDLR17_RBS0_UTR$Currency17
72EXTQTYSEL SearchExisting Qty SelectedDLR17_QTY_RBS0_STRCurrency17
73ReqShipDate SearchRequested Ship DateDTDate8
74FUFILDAT SearchFulfillment DateDTDate8
75ACTLSHIP SearchActual Ship DateDTDate8
76SHIPMTHD SearchShipping MethodSTR15_Shipping_MethodString15
Key to the Shipping Methods Master (SY03000).

Click to show/hide

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

Click to show/hide

SELECT
       ['Sales Transaction Amounts Work'].SALSTERR AS 'Sales Transaction Amounts Work-Sales Territory'
       ,['Sales Territory Master File'].SALSTERR AS 'Sales Territory Master File-Sales Territory'
FROM
       SOP10200 AS ['Sales Transaction Amounts Work']
INNER JOIN
       RM00303 AS ['Sales Territory Master File']
              ON
                     ['Sales Transaction Amounts Work'].SALSTERR = ['Sales Territory Master File'].SALSTERR
78SLPRSNID SearchSalesperson IDSTR15_Salesperson_IDString15
Key to the RM Salesperson Master (RM00301).

Click to show/hide

SELECT
       ['Sales Transaction Amounts Work'].SLPRSNID AS 'Sales Transaction Amounts Work-Salesperson ID'
       ,['RM Salesperson Master'].SLPRSNID AS 'RM Salesperson Master-Salesperson ID'
FROM
       SOP10200 AS ['Sales Transaction Amounts Work']
INNER JOIN
       RM00301 AS ['RM Salesperson Master']
              ON
                     ['Sales Transaction Amounts Work'].SLPRSNID = ['RM Salesperson Master'].SLPRSNID
79PRCLEVEL SearchPriceLevelSTR10_LBAUString10
80COMMNTID SearchComment IDSTR15_Comment_IDString15
Key to the Comment Master (SY04200).

Click to show/hide

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

Click to show/hide

SELECT
       ['Sales Transaction Amounts Work'].CURRNIDX AS 'Sales Transaction Amounts Work-Currency Index'
       ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
       SOP10200 AS ['Sales Transaction Amounts Work']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['Sales Transaction Amounts Work'].CURRNIDX = ['Currency Setup'].CURRNIDX
85TRXSORCE SearchTRX SourceSTR13String13
86SOPLNERR SearchSOP LINE ErrorsML_SOP_LINE_ErrorsLong Integer0
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
93QTYTOSHP SearchQTY To ShipDLR17_QTY_RBS0_UTRCurrency17
94XFRSHDOC SearchTransferred To Shipping DocumentBooleanBoolean0
95EXCEPTIONALDEMAND SearchExceptional DemandCB_Exceptional_DemandBoolean0
96TAXSCHID SearchTax Schedule IDSTR15_Tax_Schedule_IDString15
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['Sales Transaction Amounts Work'].TAXSCHID AS 'Sales Transaction Amounts Work-Tax Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       SOP10200 AS ['Sales Transaction Amounts Work']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['Sales Transaction Amounts Work'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
97TXSCHSRC SearchTax Schedule SourceINT1Integer1
98PRSTADCD SearchPrimary Shipto Address CodeSTR15_LBAUString15
99ShipToName SearchShipToNameSTR64_Customer_NameString64
100CNTCPRSN SearchContact PersonSTR60String60
101ADDRESS1 SearchAddress 1STR60String60
102ADDRESS2 SearchAddress 2STR60String60
103ADDRESS3 SearchAddress 3STR60String60
104CITY SearchCitySTR35String35
105STATE SearchStateSTR30_StateString29
106ZIPCODE SearchZip CodeSTR10String10
107CCode SearchCountry CodeSTR6_VATString6
Key to the VAT Country Code MSTR (VAT10001).

Click to show/hide

SELECT
       ['Sales Transaction Amounts Work'].CCode AS 'Sales Transaction Amounts Work-Country Code'
       ,['VAT Country Code MSTR'].CCode AS 'VAT Country Code MSTR-Country Code'
FROM
       SOP10200 AS ['Sales Transaction Amounts Work']
INNER JOIN
       VAT10001 AS ['VAT Country Code MSTR']
              ON
                     ['Sales Transaction Amounts Work'].CCode = ['VAT Country Code MSTR'].CCode
108COUNTRY SearchCountrySTR60String60
109PHONE1 SearchPhone 1Phone_NumberString14
110PHONE2 SearchPhone 2Phone_NumberString14
111PHONE3 SearchPhone 3Phone_Number3String14
112FAXNUMBR SearchFax NumberSTR14_FAXString14
113Flags SearchFlagsINT1Integer1
114BackoutTradeDisc SearchBackout Trade Discount AmountDLR19_RBS0_UTR$Currency19
115OrigBackoutTradeDisc SearchOriginating Backout Trade Discount AmountDLR19_RBS0_UTR$Currency19
116GPSFOINTEGRATIONID SearchGPSFO Integration IDSTR30String30
117INTEGRATIONSOURCE SearchIntegration SourceINTInteger0
118INTEGRATIONID SearchIntegration IDSTR30String30
119CONTNBR SearchContract NumberSTR11String11
120CONTLNSEQNBR SearchContract Line SEQ NumberSequence_NumberCurrency19
121CONTSTARTDTE SearchContract Start DateDATEDate6
122CONTENDDTE SearchContract End DateDATE_LDate0
123CONTITEMNBR SearchContract Item NumberSTR30_Item_NumberString30
124CONTSERIALNBR SearchContract Serial NumberSTR20_LBAUString20
125BULKPICKPRNT SearchBulk Pick PrintedBooleanBoolean0
126INDPICKPRNT SearchIndividual Pick PrintedBooleanBoolean0
127ISLINEINTRA SearchIsLineIntrastatCBBoolean0
128SOFULFILLMENTBIN SearchSO Fulfillment BinSTR15_BinString15
129MULTIPLEBINS SearchMultiple BinsCBBoolean0
130Print_Phone_NumberGB SearchPrint Phone Number GBGBInteger0
131DEX_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.
132DEX_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 Work (SOP10200)

Leave a Reply

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