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 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 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 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 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$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 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 Integer414
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 Integer414
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 Integer414
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 Integer414
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 Integer414
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 Integer414
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 Integer414
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_LBAUString1615
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_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
55QTYONPO SearchQTY On PODLR17_QTY_RBS0_UTRCurrency1017
56QTYORDER SearchQTY OrderedDLR17_QTY_RBS0_UTRCurrency1017
57QTYPRBAC SearchQTY Prev Back OrderedDLR17_QTY_RBS0_UTRCurrency1017
58QTYPRBOO SearchQTY Prev BO On OrderDLR17_QTY_RBS0_UTRCurrency1017
59QTYPRINV SearchQTY Prev InvoicedDLR17_QTY_RBS0_UTRCurrency1017
60QTYPRORD SearchQTY Prev OrderedDLR17_QTY_RBS0_UTRCurrency1017
61QTYPRVRECVD SearchQTY Prev ReceivedDLR17_QTY_RBS0_UTRCurrency1017
62QTYRECVD SearchQTY ReceivedDLR17_QTY_RBS0_UTRCurrency1017
63QTYREMAI SearchQTY RemainingDLR17_QTY_RBS0_UTRCurrency1017
64QTYREMBO SearchQTY Remaining On BODLR17_QTY_RBS0_UTRCurrency1017
65QTYTBAOR SearchQTY To Back OrderDLR17_QTY_RBS0_UTRCurrency1017
66QTYTOINV SearchQTY To InvoiceDLR17_QTY_RBS0_UTRCurrency1017
67QTYTORDR SearchQTY To OrderDLR17_QTY_RBS0_UTRCurrency1017
68QTYFULFI SearchQTY FulfilledDLR17_QTY_RBS0_UTRCurrency1017
69QTYSLCTD SearchQTY SelectedDLR17_QTY_RBS0_UTRCurrency1017
70QTYBSUOM SearchQTY In Base U Of MDLR17_QTY_RBS0_STRCurrency1017
71EXTQTYAL SearchExisting Qty AvailableDLR17_RBS0_UTR$Currency1017
72EXTQTYSEL SearchExisting Qty SelectedDLR17_QTY_RBS0_STRCurrency1017
73ReqShipDate SearchRequested Ship DateDTDate48
74FUFILDAT SearchFulfillment DateDTDate48
75ACTLSHIP SearchActual Ship DateDTDate48
76SHIPMTHD SearchShipping MethodSTR15_Shipping_MethodString1615
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_TerritoryString1615
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_IDString1615
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_LBAUString1210
80COMMNTID SearchComment IDSTR15_Comment_IDString1615
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 1INT1Integer21
82BRKFLD2 SearchBreak Field 2INT1Integer21
83BRKFLD3 SearchBreak Field 3INT1Integer21
84CURRNIDX SearchCurrency IndexINT3Integer23
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 SourceSTR13String1413
86SOPLNERR SearchSOP LINE ErrorsML_SOP_LINE_ErrorsLong Integer40
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
93QTYTOSHP SearchQTY To ShipDLR17_QTY_RBS0_UTRCurrency1017
94XFRSHDOC SearchTransferred To Shipping DocumentBooleanBoolean20
95EXCEPTIONALDEMAND SearchExceptional DemandCB_Exceptional_DemandBoolean20
96TAXSCHID SearchTax Schedule IDSTR15_Tax_Schedule_IDString1615
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 SourceINT1Integer21
98PRSTADCD SearchPrimary Shipto Address CodeSTR15_LBAUString1615
99ShipToName SearchShipToNameSTR64_Customer_NameString6664
100CNTCPRSN SearchContact PersonSTR60String6260
101ADDRESS1 SearchAddress 1STR60String6260
102ADDRESS2 SearchAddress 2STR60String6260
103ADDRESS3 SearchAddress 3STR60String6260
104CITY SearchCitySTR35String3635
105STATE SearchStateSTR30_StateString3029
106ZIPCODE SearchZip CodeSTR10String1210
107CCode SearchCountry CodeSTR6_VATString86
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 SearchCountrySTR60String6260
109PHONE1 SearchPhone 1Phone_NumberString2214
110PHONE2 SearchPhone 2Phone_NumberString2214
111PHONE3 SearchPhone 3Phone_Number3String2214
112FAXNUMBR SearchFax NumberSTR14_FAXString2214
113Flags SearchFlagsINT1Integer21
114BackoutTradeDisc SearchBackout Trade Discount AmountDLR19_RBS0_UTR$Currency1019
115OrigBackoutTradeDisc SearchOriginating Backout Trade Discount AmountDLR19_RBS0_UTR$Currency1019
116GPSFOINTEGRATIONID SearchGPSFO Integration IDSTR30String3230
117INTEGRATIONSOURCE SearchIntegration SourceINTInteger20
118INTEGRATIONID SearchIntegration IDSTR30String3230
119CONTNBR SearchContract NumberSTR11String1211
120CONTLNSEQNBR SearchContract Line SEQ NumberSequence_NumberCurrency1019
121CONTSTARTDTE SearchContract Start DateDATEDate46
122CONTENDDTE SearchContract End DateDATE_LDate40
123CONTITEMNBR SearchContract Item NumberSTR30_Item_NumberString3230
124CONTSERIALNBR SearchContract Serial NumberSTR20_LBAUString2220
125BULKPICKPRNT SearchBulk Pick PrintedBooleanBoolean20
126INDPICKPRNT SearchIndividual Pick PrintedBooleanBoolean20
127ISLINEINTRA SearchIsLineIntrastatCBBoolean20
128SOFULFILLMENTBIN SearchSO Fulfillment BinSTR15_BinString1615
129MULTIPLEBINS SearchMultiple BinsCBBoolean20
130Print_Phone_NumberGB SearchPrint Phone Number GBGBInteger20
131DEX_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.
132DEX_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 Work (SOP10200)

Leave a Reply

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